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
- Identify Control Weaknesses and Recommendations. Georgia Beemster, CPA, is examining the financial statements of the Louisville Sales Corporation, which recently installed acomputerized processing system. The following comments have been extracted from Beemster’s notes on computer operations and the processing and control of shipping notices andcustomer invoices:∙ To minimize inconvenience, Louisville made the conversion to the new accounting information system without changing its existing system. The vendor supervised the conversion andtrained all computer department employees in systems design, operations, and programming.∙ Each computer run is assigned to a specific employee who is responsible for makingprogram changes, running the program, and answering questions. This procedure hasthe advantage of eliminating the need for records of computer operations because eachemployee is responsible for her or his own computer runs.∙ At least one computer department employee remains in the…arrow_forwardLamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Is the sales department separate from the credit office and the IT department?arrow_forwardAscendex 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_forward
- Internal Controls Homer Simpson’s first assignment as an internal auditor for Springfield Services Company involved an audit of the data processing centre controls. The Data Processing Manager, Mr. Burns, gave him a tour of the facilities. Mr. Burns explained that the facilities were located between the accounting and the personnel departments because of the high volume of transactions generated by these two areas. "Our doors are always open as a matter of policy. This way, users feel involved and committed to the system," he told Homer as they entered the glass doors of the facility. Homer was introduced to a programmer and a systems analyst who were reviewing and approving results of a program they had written together. The computer tape files were stored in the centre of the room on open shelves for ease of access to both operators and programmers. The lower part of the shelving was a locked storage cabinet. Mr. Burns showed Homer the back-up copies of tapes stored there…arrow_forwardSystems Planning A new systems development project is being planned for the Reindeer Christmas Supplies Company. The invoicing, cash receipts, and accounts payable modules are all going to be updated. The controller, Kris K. Ringle, is a little anxious about this project. The last systems development project that affected his department was not very successful,and the employees in the accounting department did not accept the new system very well at first. He feels that the systems personnel did not interact sufficiently with the users of the systems in the accounting department. Prepare a memo from Ringle to the head of the information systems department, Sandy Klaus. In this memo, provide some suggestions for including the accounting personnel in the systems development project. Give some very persuasive arguments why prototyping would be helpful to the workers in the accounting department.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 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_forward
- Internet Exercise: Reporting on Service Organization Controls. Search for a service organization auditor’s report on internal controls on the web. (Hint: You may have to look under the old name “SAS 70 reports.”) If you cannot find an auditor’s report, find a company’s news release describing its auditor’s service organization report. Required:a. Why do you think it is so difficult to find an actual report?b. If you found an auditor’s report, were any deficiencies noted? If so, what were they?c. Why would a service organization publicize the results of its auditor’s report?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_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning