Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 8ICC
a.
To determine
Prepare a data flow diagram of the current system.
b.
To determine
Prepare the system flowchart of the existing system.
c.
To determine
Explain the physical internal control weaknesses in the system.
d.
To determine
Explain the IT controls that should be placed in the system.
e.
To determine
Create a system flowchart of a redesigned computer-based system that resolves the control weaknesses identified.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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…
Law 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…
4. Generators R Us (Manual and Stand-Alone PC Procedures)
Generators R Us (GRU) is a manufacturer of portable electric generators used for emergency power supply in both civil and private disaster situations. GRU’s headquarters and manufacturing facilities are in Dallas, Texas, where they employ 125 manufacturing and clerical staff. Although much of the company’s accounting system employs advanced technology, its payroll and fixed asset systems are legacy systems that rely on manual processes supported by stand-alone PCs. Recently, GRU has experienced operational problems with these processes and the management has hired your auditing firm to assess its operations and internal control procedures.
Payroll System
In the GRU production departments, each worker records the number of hours he or she has worked each day by clocking in and out on a time card machine. The supervisor oversees this process and each week sends the hard-copy time cards to the payroll department. Using a…
Chapter 5 Solutions
Accounting Information Systems
Ch. 5 - Prob. 1RQCh. 5 - What purpose does a purchasing department serve?Ch. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Some organizations do not use an AP subsidiary...
Ch. 5 - What is the purpose of the blind copy of a PO?Ch. 5 - Prob. 12RQCh. 5 - Prob. 1DQCh. 5 - Prob. 2DQCh. 5 - Prob. 3DQCh. 5 - The level of day-to-day department activity in...Ch. 5 - Prob. 5DQCh. 5 - What is central to a successful EDI...Ch. 5 - Discuss the objective of eliminating the receiving...Ch. 5 - What purpose does multilevel security control play...Ch. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Which of the following statements is correct? a....Ch. 5 - Which of the following represents incompatible...Ch. 5 - Prob. 3MCQCh. 5 - Prob. 4MCQCh. 5 - Prob. 5MCQCh. 5 - Prob. 6MCQCh. 5 - Prob. 7MCQCh. 5 - Which of the following tasks should the cash...Ch. 5 - Which ledger can be updated solely from the...Ch. 5 - Prob. 10MCQCh. 5 - Prob. 1PCh. 5 - INVENTORY ORDERING ALTERNATIVES The flowchart for...Ch. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8PCh. 5 - Prob. 9PCh. 5 - Prob. 10PCh. 5 - Prob. 11PCh. 5 - UNRECORDED LIABILITIES You are auditing the...Ch. 5 - SMITHS MARKET (SMALL BUSINESS ACCOUNTING SYSTEM)...Ch. 5 - POSAVEK REMODELING AND BUILDING SUPPLY COMPANY...Ch. 5 - GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING...Ch. 5 - Prob. 4ICCCh. 5 - Prob. 5ICCCh. 5 - Prob. 6ICCCh. 5 - Prob. 7ICCCh. 5 - Prob. 8ICC
Knowledge Booster
Similar questions
- 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. ULCs 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 supervisors terminal and to the cost accounting clerks 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 accounting clerk receives the digital work order and initiates a new WEP account for the batch. During the production process, the clerk receives hard-copy move tickets, materials requisitions, and job tickets from the work centers, which the clerk uses to update WIP account. When production is complete, the clerk closes the WIP account for the batch and transfers it to the finished good inventory subsidiary ledger. At the days 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.arrow_forwardPosavek is a wholesale supplier of building supplies building contractors, hardware stores, and home-improvement centers in the Boston metropolitan area. Over the years, Posavek has expanded its operations to serve customers across the nation and now employs over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently, Posavek has experienced fierce competition from the large online discount stores. In addition, the company is suffering from operational inefficiencies related to its archaic information system. Posavek revenue cycle procedures are described in the following paragraphs. Revenue Cycle Posaveks sales department representatives receive orders via traditional mail, e-mail, telephone, and the occasional walk-in customer. Because Posavek is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customers order into the centralized computer sales order system. The computer and file server are housed in Posaveks small data processing department. If the customer has done business with Posavek in the past, his or her data are already on file. If the customer is a first-time buyer, however, the clerk creates a new record in the customer account file. The system then creates a record of the transaction in the open sales order file. When the order is entered, an electronic copy of it is sent to the customers e-mail address as confirmation. A clerk in the warehouse department periodically reviews the open sales order file from a terminal and prints two copies of a stock release document for each new sale, which he uses to pick the items sold from the shelves. The warehouse clerk sends one copy of the stock release to the sales department and the second copy, along with the goods, to the shipping department. The warehouse clerk then updates the inventory subsidiary file to reflect the items and quantities shipped. Upon receipt of the stock release document, the sales clerk accesses the open sales order file from a terminal, closes the sales order, and files the stock release document in the sales department. The sales order system automatically posts these transactions to the sales, inventory control, and cost-of-goods-sold accounts in the general ledger file. Upon receipt of the goods and the stock release, the shipping department clerk prepares the goods for shipment to the customer. The clerk prepares three copies of the bill of lading. Two of these go with the goods to the carrier and the third, along with the stock release document, is filed in the shipping department. The billing department clerk reviews the closed sales orders from a terminal and prepares two copies of the sales invoice. One copy is mailed to the customer, and the other is filed in the billing department. The clerk then creates a new record in the accounts receivable subsidiary file. The sales order system automatically updates the accounts receivable control account in the general ledger file. CASH RECEIPTS PROCEDURES Mail room clerks open customer cash receipts, reviews the check and remittance advices for completeness, and prepares two copies of a remittance list. One copy is sent with the checks to the cash receipts department. The second copy of the remittance advices are sent to the billing department. When the cash receipts clerk receives the checks and remittance list, he verifies the checks received against those on the remittance list and signs the checks For Deposit Only. Once the checks are endorsed, he records the receipts in the cash receipts journal from his terminal. The clerk then fills out a deposit slip and deposits the checks in the bank. Upon receipt of the remittances, the billing department clerk records the amounts in the accounts receivable subsidiary ledger from the department terminal. The system automatically updates the AR control account in the general ledger Posavek has hired your public accounting firm to review its sales order procedures for internal control compliance and to make recommendations for changes. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.arrow_forwardLAWN WIZARD INC. (MANUAL SYSTEM WITH STAND-ALONE PC SUPPORT) Law 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 application. The system automatically creates an open work order record and prints the hard-copy move tickets and materials requisitions. The supervisor distributes the move tickets and two copies of the purchase requisitions to each work center invoked in the production process. Work center employees exchange the material requisitions for assembly parts and other materials needed to complete the batch. If additional parts or materials are needed beyond the standard quantity, the supervisor issues additional material requisitions. As the production is completed in each work center, employees record their labor time for each batch on hard-copy job cards, which they send to cost accounting along with the move ticket. Finally, upon completion of the batch, the supervisor closes the open work order file. The storekeeping clerk files one copy of the material requisition in the department and updates the raw materials inventory file from the computer in his office. The manager then sends the second copy of the material requisition to cost accounting. At the end of the day, the manager prepares a hard-copy journal voucher and sends it to the general ledger department. The cost accounting clerk receives the work order and sets up a WIP account for the batch. Throughout the production period, the clerk also receives move tickets, job tickets, and materials requisitions, which she uses to post to WIP. At the end of each day, the cost accounting clerk prepares a hard-copy journal voucher, which she sends to general ledger department. The journal voucher reflects the total value of WIP and transfers to finished good inventory. The general ledger clerk receives the journal vouchers, posts to the appropriate GL accounts, and files the journal vouchers in the department. Required a. Create a system flowchart of the existing system. b. What risks exist in the system as it is currently designed? c. Describe the changes needed to reduce the risks.arrow_forward
- 4. Generators R Us (Manual and Stand-Alone PC Procedures) Generators R Us (GRU) is a manufacturer of portable electric generators used for emergency power supply in both civil and private disaster situations. GRU’s headquarters and manufacturing facilities are in Dallas, Texas, where they employ 125 manufacturing and clerical staff. Although much of the company’s accounting system employs advanced technology, its payroll and fixed asset systems are legacy systems that rely on manual processes supported by stand-alone PCs. Recently, GRU has experienced operational problems with these processes and the management has hired your auditing firm to assess its operations and internal control procedures. Payroll System In the GRU production departments, each worker records the number of hours he or she has worked each day by clocking in and out on a time card machine. The supervisor oversees this process and each week sends the hard-copy time cards to the payroll department. Using a…arrow_forward4. Generators R Us (Manual and Stand-Alone PC Procedures) Generators R Us (GRU) is a manufacturer of portable electric generators used for emergency power supply in both civil and private disaster situations. GRU’s headquarters and manufacturing facilities are in Dallas, Texas, where they employ 125 manufacturing and clerical staff. Although much of the company’s accounting system employs advanced technology, its payroll and fixed asset systems are legacy systems that rely on manual processes supported by stand-alone PCs. Recently, GRU has experienced operational problems with these processes and the management has hired your auditing firm to assess its operations and internal control procedures. Payroll System In the GRU production departments, each worker records the number of hours he or she has worked each day by clocking in and out on a time card machine. The supervisor oversees this process and each week sends the hard-copy time cards to the payroll department. Using a…arrow_forward4. Generators R Us (Manual and Stand-Alone PC Procedures) Generators R Us (GRU) is a manufacturer of portable electric generators used for emergency power supply in both civil and private disaster situations. GRU’s headquarters and manufacturing facilities are in Dallas, Texas, where they employ 125 manufacturing and clerical staff. Although much of the company’s accounting system employs advanced technology, its payroll and fixed asset systems are legacy systems that rely on manual processes supported by stand-alone PCs. Recently, GRU has experienced operational problems with these processes and the management has hired your auditing firm to assess its operations and internal control procedures. Payroll System In the GRU production departments, each worker records the number of hours he or she has worked each day by clocking in and out on a time card machine. The supervisor oversees this process and each week sends the hard-copy time cards to the payroll department. Using a…arrow_forward
- 4. Generators R Us (Manual and Stand-Alone PC Procedures)Generators R Us (GRU) is a manufacturer of portable electric generators used for emergency power supply in both civil and private disaster situations. GRU’s headquarters and manufacturing facilities are in Dallas, Texas, where they employ 125 manufacturing and clerical staff. Although much of the company’s accounting system employs advanced technology, its payroll and fixed asset systems are legacy systems that rely on manual processes supported by stand-alone PCs. Recently, GRU has experienced operational problems with these processes and the management has hired your auditing firm to assess its operations and internal control procedures. Payroll SystemIn the GRU production departments, each worker records the number of hours he or she has worked each day by clocking in and out on a time card machine. The supervisor oversees this process and each week sends the hard-copy time cards to the payroll department. Using a stand-alone…arrow_forwardAvenue 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_forwardAudio Visual Corporation (AVC) manufactures and sells visual display equipment. Headquartered in Boston, it has seven sales offices with nearby warehouses that carry its inventory of new equipment and replacement parts. AVC has a departmentalized manufacturing plant with assembly, maintenance, engineering, scheduling, and cost accounting departments as well as several component parts departments. When management decided to upgrade its AIS, they installed a mainframe at headquarters and local area networks at each sales office. The IS manager and four systems analysts were hired shortly before they integrated the new computer and the existing AIS. The other IS employees have been with the company for years. During its early years, AVC had a centralized decision-making organization. Top management formulated all plans and directed all operations. As the company expanded, decision making was decentralized, although data processing was highly centralized. Departments coordinated their…arrow_forward
- RUE BENNETT Company develops software for small businesses and household computers. The majority of the company's computer programmers are working on developing software that will perform relatively specialized functions in a user-friendly manner. Before the working model is released to production for the preparation of masters and additional testing, it undergoes extensive testing. As a result of this meticulous planning, various computer software packages have been developed that have proven to be very successful in the industry. RUE BENNETT Company incurred the following costs during 2020: Cost to reproduce and prepare software for sale 200,002 Amortization of capitalized software development costs from current and prior years 94,321 Expenses related to projects after technological feasibility has been established but before software is available for commercial production 151,323 Salaries and wages of programmers doing research 910,000 Expenses related…arrow_forwardJade Ltd is now considering how to obtain a computer software. The director of Jade Ltd has noticed that over the last 20 years, many companies have spent a great deal of money internally developing new intangible assets, such as software. You have been asked by the director to provide your advice on the accounting treatments of the two possibilities below: (i) Employ its own programmers to write software that the company will use (ii) Purchase computer software externally, including packages for payroll and general ledger. Required: In accordance with IAS 38 / AASB 138 Intangible Assets, discuss whether internally developed intangible assets should be recognised, and explain the differ in the accounting treatments for the two possible options.arrow_forwardRequired information [The following information applies to the questions displayed below.] Marin Company produces two software products (Cloud-X and Cloud-Y) in two separate departments (A and B). These products are highly regarded network maintenance programs. Cloud-X is used for small networks and Cloud-Y is used for large networks. Marin is known for the quality of its products and its ability to meet dates promised for software upgrades. Department A produces Cloud-X, and department B produces Cloud-Y. The production departments are supported by two support departments, systems design and programming services. The sources and uses of the support department time are summarized as follows: From Design Programming Department A Department B 5,000 400 Design Programming The costs in the two service departments are as follows: Labor and materials (all variable) Depreciation and other fixed costs Total To a. Direct Method b. Step Method (Design Department goes first) c. The Reciprocal…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:CengageCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Business Its Legal Ethical & Global Environment
Accounting
ISBN:9781305224414
Author:JENNINGS
Publisher:Cengage
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning