Accounting Information Systems
9th Edition
ISBN: 9781133934400
Author: James A. Hall
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5ICC
a.
To determine
Prepare a data flow diagram of the current system.
b.
To determine
Prepare a system flow chart of the existing system.
c.
To determine
Describe the physical internal control weaknesses in the system.
d.
To determine
Prepare a system flowchart of a redesigned computer-based system which will resolve the control weaknesses.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Read the case below and answer the questions following it.
DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded theiroperations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs.
Revenue Cycle
DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in.…
Read the case below and answer the questions following it.
DURAPLAST Company Ltd., opened its doors in 1979 as awholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs.
Revenue Cycle
DURAPLAST’s sales department consists of 17 full-time andpart-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in.…
Read the case below and answer the questions following it.
DURAPLAST Company Ltd., opened its doors in 1979 as awholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs.
Revenue Cycle
DURAPLAST’s sales department consists of 17 full-time andpart-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in.…
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 - Prob. 1MCQCh. 5 - Prob. 2MCQCh. 5 - Prob. 3MCQCh. 5 - Prob. 4MCQCh. 5 - Prob. 5MCQCh. 5 - Prob. 6MCQCh. 5 - Prob. 7MCQCh. 5 - Prob. 8MCQCh. 5 - Prob. 9MCQCh. 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 - SMITHS MARKET (SMALL BUSINESS ACCOUNTING SYSTEM)...Ch. 5 - Prob. 2ICCCh. 5 - Prob. 3ICCCh. 5 - Prob. 4ICCCh. 5 - Prob. 5ICCCh. 5 - GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING...Ch. 5 - Prob. 7ICCCh. 5 - Prob. 8ICC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardDURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardDURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forward
- DURAPLAST Company Ltd., opened its doors in 1979 as a wholesale supplier of plumbing equipment, tools, and parts to hardware stores, home-improvement centers, and professional plumbers in the Accra-Tema Metropolitan area. Over the years they have expanded their operations to serve customers across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently DURAPLAST has experienced fierce competition from the large online discount stores such as Qualiplast and Interplast. In addition, the company is suffering from operational inefficiencies related to its archaic information system. DURAPLAST’s revenue cycle procedures are described in the following paragraphs. Revenue Cycle DURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its…arrow_forwardPOSAVEK REMODELING AND BUILDING SUPPLY COMPANY (CENTRALIZED SMALL BUSINESS ACCOUNTING SYSTEM) Posavek is a wholesale supplier of building supplies to 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. Posaveks expenditure cycle procedures are described in the following paragraphs. Expenditure Cycle Posavek uses a centralized accounting system for managing inventory purchases and recording transactions. The system is almost entirely paperless. Each department has a computer terminal that is networked to the purchases/AP system that is run from a small data processing department. All accounting records are maintained on centralized computer files that are stored on a file server in the data processing department. Purchasing The process begins in the purchasing department. Each morning the purchasing agent reviews the inventory levels from his department terminal and searches for items that have fallen to their reorder points and need to be replenished. The purchasing agent then selects the vendors and creates digital purchase orders in the purchase order file. He then prints two hard copies of each purchase order and sends them to the respective vendors. Receiving When the items are received, the receiving department clerk reconciles the goods with the attached packing slip and the digital purchase order, which he accesses from his computer terminal. The clerk then creates a digital receiving report, stating the condition of the materials received. The system automatically closes the purchase order previously created by the purchasing agent. In addition, the receiving clerk prints a hard copy of the receiving report, which he sends with the inventory to the warehouse where the items are stored. Warehouse Upon receipt of the inventory, the warehouse cleric reconciles the items with the receiving report and updates the inventory subsidiary ledger. The accounting system automatically and immediately updates the inventory control account in the general ledger. Accounts Payable Once the AP clerk receives the vendors invoice, she reconciles it with the purchase order and receiving report from her terminal. The clerk then creates a digital vendor invoice record and sets a due date for payment. The system automatically updates the AP control account in the general ledger. Daily, the AP clerk reviews the open vendor invoice records from her terminal, looking for items that need to be paid. The clerk then records the payment in the digital check register and closes the open vendor invoice. Finally, the clerk prints a hard copy of the check and sends it to the vendor. The system automatically updates the AP and cash GL accounts. 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_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_forward
- Relco Industries recently purchased Arbeck, Inc., a manufacturer of electrical components that the construction industry uses. Roland Ford has been appointed as chief financial officer of Arbeck, and the president of Relco, Martha Sanderson, has asked him to prepare an organizational chart for his department at Arbeck. The chart that Ford has prepared is shown in the figure. Ford believes that the treasurer’s department should include the following employees: assistant treasurer, manager of accounts receivable and four subordinates, manager of investments and three subordinates, and manager of stockholder relations and two subordinates—a total of 13 employees besides the treasurer.The controller’s department should consist of an assistant controller, a manager of general accounting and four subordinates, a manager of fixed asset control and three subordinates, and a manager of cost accounting with four subordinates—a total of 15 employees besides the controller.When Ford presented his…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_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_forward
- Sonos, Incorporated designs, develops, manufactures, and sells multi-room audio products. The Sonos sound system provides customers with an immersive listening experience created by the design of its speakers and components, a proprietary software platform, and the ability to stream content from a variety of sources over the customer's wireless network or over Bluetooth. In an earlier year, it reported the following on its income statement (dollars in millions). Net sales Costs and expenses Cost of sales Research and development Selling, general, and administrative Operating income (loss) Interest and other incone (expenses), net Loss before provision for income taxes Provision for income taxes Net loss The company's beginning and ending assets were $762 and $816, respectively. Transaction a b. $ 1,326 Required: Listed here are hypothetical additional transactions. Assuming that they also occurred during the fiscal year, complete the following tabulation, indicating the sign of the…arrow_forwardQT, Inc., and Elppa Computers, Inc., compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…arrow_forwardQT, Inc., and Elppa Computers, Inc., compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $56,940 $120,357 Cost of merchandise sold 44,754 92,385 Inventory, beginning of period 1,382 6,317 Inventory, end of period 1,404 7,490 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. QT Elppa 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory…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,Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License