Internal Control Cases
UTICA LIGHTING COMPANY (CENTRALIZED SYSTEM WITH DISTRIBUTED TERMINALS)
Utica Lighting Company (ULC) is a manufacturer of outdoor lighting systems for patios, walkways, and public areas. It markets its product to landscaping companies and local municipalities. ULC employs a centralized computer system with distributed terminals in the various departments. Recently the company has been having manufacturing delays and cost overruns. ULC has hired your auditing firm to assess its operations and internal control procedures.
ULC’s conversion cycle is triggered by a report from the finished goods warehouse. The warehouse clerk periodically reviews the inventory records in a search for low-stock items. When the quantity on hand of an inventory item in the finished goods warehouse falls below its pre-established minimum, the warehouse clerk sends a digital inventory status report from the warehouse terminal to production planning and control advising them to schedule a production batch run for the item in question.
Upon receipt of the report the production planning and control department clerk accesses the digital bill of materials and the routing sheet files for the items to be produced and adds the production details to the digital production schedule. The system automatically adds a record to the open work order file and sends a digital work order to the work center supervisor’s terminal and to the cost accounting clerk’s terminal.
The work center supervisor accesses the work order from his terminal and prints hard-copy move tickets and material requisitions for each stage in the production process. Production employees take the materials requisitions to the storekeeper and secure the components, subassemblies, and raw materials needed to perform their production tasks. If excess materials beyond the standard amount are needed, the supervisor prepares additional materials requisitions. The employees also complete job time tickets after each stage in the process to reflect the time spent on the job. When the employees complete their tasks, they send the move tickets and time tickets to the cost accounting department.
The storekeeper receives the materials requisitions and releases the materials into production. He then updates the raw material inventory records and sends the requisition to cost accounting. When inventories of component parts and raw materials fall to their reorder points, the storekeeper prepares purchase orders and sends them to the respective vendors. Vendors deliver raw material inventories directly to the storeroom, at which time the storeroom clerk inspects them and updates the digital raw materials subsidiary ledger. Each day the storekeeper prepares a journal voucher and posts to the general ledger raw material control account.
The cost
At the day’s end, the cost accounting clerk prepares a digital journal voucher reflecting the WIP status and any transfers from WIP to finished goods inventory. The clerk then posts the journal voucher to the WEP and FG general ledger control accounts.
Required
- a. Prepare a data flow diagram of the current system.
- b. Prepare a system flowchart of the existing system.
- c. Describe the internal control weaknesses.
Trending nowThis is a popular solution!
Chapter 7 Solutions
Accounting Information Systems
- Ascendex Sdn Bhd is an online company that supplies a range of IT products. Its product line includes IT hardware and software. Their main customers are government agencies and private company. The company employs a combination of manual procedures and a networked accounting system with distributed terminals in several departments. After years of satisfactory performance, however, Ascendex Sdn Bhd is now experiencing operational inefficiencies and accounting errors. Your firm has been hired to evaluate Ascendex’s business processes and internal controls. Ascendex’s expenditure cycle is described in the following paragraphs. PURCHASE SYSTEM PROCEDURES Ascendex’s transactions are initiated when the purchasing department clerk reviews the inventory file for items that need to be replenished. The clerk selects a vendor, adds a record to the digital purchase order (PO) File, and prints four hard copies of the PO. One copy is filed in the department; the second copy is sent to the receiving…arrow_forwardWarehouse operations have shut down at SHXCX Manufacturing suddenly due to a power outage. Warehouse managers are still able to communicate with their home office and their data servers, but unfortunately have no prepared solution to restoring operations. Which of the following controls would be best suited to combat this problem? Select one: O a. Validity test O b. Business Continuity Plan (BCP) c. Disaster Recovery Plan (DRP) d. Both B and Carrow_forwardPlease answer 1, 2 and 3.arrow_forward
- You are currently working in a mid-tier accounting firm. In an engagement meeting with a client, the management of your client is concerned that the audit tests that you perform will disrupt operations. Your client has recently implemented a data warehouse and the management suggests that you draw the data for analytical reviews and substantive testing from the data warehouse instead of the operational database. The management points out that operational data are copied weekly into the data warehouse and all data you need are contained there. Q. Outline your response to the management’s proposal and mention any concerns you might have.arrow_forwardYou are currently working in a mid-tier accounting firm. In an engagement meeting with a client, the management of your client is concerned that the audit tests that you perform will disrupt operations.Your client has recently implemented a data warehouse and the management suggests that you draw the data for analytical reviews and substantive testing from the data warehouse instead of theoperational database. The management points out that operational data are copied weekly into thedata warehouse and all data you need are contained there. Outline your response to the management’s proposal and mention any concerns you might have.arrow_forwardwhat is the potential consequences and give each of the question a prevention technique. 1)A company has recently installed a new computer network. The operating philosophy adopted by the new network administrator was to establish an open system that would foster work group date to the network users. To accomplish this objective, the data administrator assigned employee access privileges to data based on department and functional affiliation rather than specific tasks. 2)Sara is a system programmer who was told she would be terminated in three weeks due to poor performance and was asked to conclude all of her projects during the three-week period. Two weeks later Sara created a logic bomb designed to get activated three months after her departure. Subsequently, the bomb destroyed hundreds of records in her previous employer’s accounts receivable invoice file. 3)Matt discovered a new sensitivity analysis public-domain program on the Internet. He downloaded the software to his laptop at…arrow_forward
- Blackmon Company provides locator services to the city transportation departments. Blackmons service involves installing a dedicated hardware transmitter in each city bus. This transmitter provides real-time information to a central logistics center that provides a manager with detailed information as to bus location, speed, current weather, and traffic patterns. The manager can then reroute buses to improve efficiency of operations and increase customer satisfaction. Customers generally sign two separate contracts: one contract governs the sale of the hardware devices, while the second governs the provision of the locator services. On January 1, 2019, a customer purchased Blackmons service by signing a contract for 100 devices for 480,000, the normal selling price. In addition, the customer signed a separate 12-month service contract for 2,000 per month (20 per month per unit, which is the standard selling price for the service). This amount is billed on a monthly basis, and the customer pays for January service on January 31, 2019. The hardware device can only be used with Blackmons services and there are currently no other competitors making devices that work with the Blackmon service. The customer may cancel at any time; however, the amount paid for the device is nonrefundable. The customer is given the right to renew the service contract at the existing rate each December, and the average life of a customer contract is 5 years. The customer takes delivery of the device on January 1, 2019, and begins the locator service on that date. Required: 1. Identify the contract(s) for accounting purposes. 2. How many performance obligations exist? When will the performance obligation(s) be satisfied? 3. Prepare Blackmons journal entries for January 2019. 4. Assume that other competitors sell a similar locator service comparable to Blackmons. Would this fact change your previous answers?arrow_forwardSystems Development and Implementation Kruger Designs hired a consulting firm 3 months ago to redesign the information system used by the architects. The architects will be able to use state-of-the-art CAD programs to help in designing the products. Further, they will be able to store these designs on a network server where they and other architects may be able to call them back up for future designs with similar components. The consulting firm has been instructed todevelop the system without disrupting the architects. In fact, top management believes that the best route is to develop the system and then to “introduce” it to the architects during a training session. Management does not want the architects to spend precious billable hours guessing about the new system or putting work off until the new system is working. Thus, the consultants are operating in a back room under a shroud of secrecy. Required: a. Do you think that management is taking the best course of action for the…arrow_forwardPERFORMANCE WATER PUMPS (CENTRALIZED SYSTEM WITH DISTRIBUTED TERMINALS) Performance Water Pumps (PWP) is a leading man- ufacturer of water pumps with high capacity capabil- ity. These pumps are used in both civil and private disaster situations. PWP's primary market is disaster recovery companies that assist home owners follow- ing basement flooding. They also sell to building contractors, municipalities, and rental companies. The company publishes an industry catalog of pumps and other auxiliary equipment, which it dis- tributes to customers and prospective customers. PWP's headquarters and manufacturing facilities are in Leesville, Louisiana where they employ 125 manufacturing and clerical staff. PWP employs a centralized computer system with distributed terminals in the departments. Recently they have been having operational problems with PWP has hired your auditing firm to assess its operations and internal control procedures. Purchasing System When an inventory item falls to…arrow_forward
- Avenue Eight Designs hired a consulting firm three months ago to redesign the information system used by the architects. The architects will be able to use state-of-the-art CAD programs to help designing the products. Further, they will able to store these design on a network server where they and other architects may be able to call them back up for future designs with similar components. The consulting firm has been instructed to develop the system without disrupting the architects. In fact, the top management believes that the best route is to develop the system and then to “introduce” it to the architects during training session. Management does not want the architects to spend precious billable hours guessing about the new system of putting work off until the new system is working. Thus, the consultants are operating in a back room under a shroud of secrecy. a) Do you think that management is taking the best course of action for the announcement of the new system? Why? b) Do you…arrow_forwardLaw Wizard Inc. (LWI) is a manufacturer of a range of walk-behind gasoline lawnmowers, which it markets to garden centers and home improvement centers. LWI employs a batch production process whose inventory management, production planning, and accounting procedures consist of a combination of manual activities supported by stand-alone (non-networked) PC technology. The company is experiencing production delays and cost overruns. Its CEO has hired your firm to review its procedures and make recommendations for improving its operations. The batch production process is initiated by receipt of individual customer orders, which are grouped together in batches for manufacturing. The production planning and control clerk enters the orders into the digital production schedule from his department PC and prints two hard-copy work orders. He sends one of these to cost accounting and the other to the production department. The production department supervisor enters the work order into a PC…arrow_forwardSYSTEM DOCUMENTATION-EXPENDITURE CYCLE (MANUAL AND COMPUTER PROCEDURES) The following describes the expenditure cycle for a hypothetical company. The company has a centralized computer system with terminals located in various departments. The terminals are networked to a computer application, and digital accounting records are hosted on a server in the data processing department. Each day, the computer in the data processing center scans the inventory records looking for items that must be replenished. For each item below its reorder point, the system creates a digital purchase order and prints two hard copies. A technician in the data center sends the purchase orders to the purchasing department clerk. Upon receipt of the purchase orders, the purchasing clerk reviews and signs them. He sends Copy 1 to the supplier and files Copy 2 in the purchasing department. A few days later, the supplier ships the order and the goods arrive at the receiving department. The receiving clerk reviews…arrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
- Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L