Reference no: EM13971387

ABE Plumbing, Inc

ABE Plumbing, Inc., 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 Allentown-Bethlehem- Easton metropolitan area. Over the years they have expanded their operations to serve customer across the nation and now employ over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently ABE has experienced fierce competition from the large online discount stores such as Harbor Freight and Northern Supply. In addition the company is suffering from operational inefficiencies related to its archaic information system. ABE's expenditure cycle procedures are described in the following paragraphs. Expenditure Cycle ABE 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/ Accounts Payable 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 clerk 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 accounts payable clerk receives the vendor's invoice, she reconciles it with the purchase order and receiving report from her terminal. The clerk then creates a digital cash disbursement voucher record and sets a due date for payment. The system automatically updates the AP control account in the general ledger. Daily, the accounts payable clerk reviews the open cash disbursement voucher records from her terminal looking for items that need to be paid. The clerk then creates a record for the payment in the digital check register and closes the open cash disbursement voucher. Finally, the clerk prints a hard copy of the check and sends it to the vendor. The system automatically updates the accounts payable and cash general ledger accounts. Required

a. Create a data flow diagram of the current system.

b. Create a system flowchart of the existing system.

c. Identify the internal control weaknesses in the system. Model your response according to the six categories of physical control activities specified in SAS 78/COSO.

d. Prepare a system flowchart of a redesigned computer based system that resolves the control weaknesses you identified. Explain your solution.