Create the Structured Narration Table, Context Diagram, Physical DFD, Annotated Structured Narration Table and Logical DFD of the current AGC system that you are reviewing.

Introduction

You are a consultant in a business consulting firm. You are assigned to a client, Auto Glass Company (AGC), a manufacturer of an automobile glass. In the first meeting with AGC you find that AGC uses old in-house developed software to record transactions in its following functions: Sales Department, Accounting Department, Purchasing Department, Warehouse and the Factory. The software used in each function is not integrated, requiring manual processes to link one function to another. AGC is a listed company that is run like a family business. It has a low employee turnover and a company culture that highly trusts employees integrity. However, AGC realizes that as a listed company it needs to have better corporate governance especially as it is planning to expand to the international market. One of AGCs main problem is dealing with the document used in the manual processes. AGC often loses the document, although each document type is properly stored in a separate tray and in numerical order. In addition, AGC realises that the design of its system results in document output that provides an insufficient audit trail. The latter is exacerbated by the fact that the system does not have proper user profile management; it segregates users per roles but not per person. Therefore, personnel with the same roles, for example, sales staff, must share the same user ID. In view of those deficiencies, AGC wants to adopt an ERP.

Business Process

The following is the narration that you received from AGC Internal Audit Department. This narration is created by the AGC internal audit department after interviewing relevant employees.

Every day AGC receives purchase orders from its customers that are filed after processing. AGC makes goods to order. It does not stock finished goods. It only stocks raw materials. For every order, a sales staff in the Sales Department creates a sales order in the system. During this process, the sales staff inputs the customer details based on the customer master data and item details based on a product list data file stored in the system. AGC customers are car manufacturers and distributors only. Therefore, all customers have previously been verified and are listed in the customer master data. The customer master data is maintained by a sales analyst and lists the customer name, address for billing and delivery, credit limit and terms of payment as well as other permanent details. Since AGC only deals with limited and largely long-time customers, credit check is not done for every order. It is only reviewed every end of the month by the sales managerwho remembers the credit limit of all customersonce the customer account balance report is received from the Accounting Department. After all sales order data have been entered and saved in the sales order data file, the system prints three copies of the sales order to the printer at the sales managers room. The printed sales order is then reviewed and signed by the sales manager. The sales staff then keeps sales order copy 1 in the sales order tray and the copy 2 and copy 3 are sent to, respectively, the Warehouse and the Accounting Department. The sales staff then make a phone call to the customers purchasing staff to advise sales confirmation and estimated delivery date.

Upon receiving the sales order copy 2, the warehouse manager on duty creates a picking list for that order based on the bill of materials (BOM) master data in the system. The BOM determines the types and amount of raw materials needed for each order. Then the picking list is printed and given to the warehouse staff. When the picking list is printed, the system updates the level of raw material stockTherefore, if a raw material reaches the reorder point, the system automatically creates a purchase requisition (PR). The warehouse manager then prints it and sends it off to the Purchasing Department.

Once the warehouse staff has picked all the required materials, the sales order copy 2 is sent along with the raw materials to the Factory. The picking list is then stored in picking list tray. At the end of the month, once the warehouse staff complete the physical stock count using a printed form, the warehouse manager on duty reconciles the level of stock based on the physical stock count form and the picking slips.

After the Factory receives the raw materials and the sales order copy 2, the factory manager on duty creates production notice in the system based on the sales order copy 2 and prints it. The sales order is stored in sales order copy 2 tray. The production notice is given to the first section of the Factory that commences the production of the automobile glass. The process of producing the automobile glass is sequential, therefore, the production notice goes along the process until the last section where staff stamps COMPLETED on the production notice.

Once the production completes, the finished goods and the production notice are sent to the Shipping Bay next to the Factory where checking and packing are done before the finished goods are shipped to the customers. Here, the shipping staff checks the quality of the finished goods and matches it with the production notice. The shipping staff then stamps CHECKED on the production notice and stores it in the production notice tray. Once the shipping staff have packed the goods, they create the shipping slips in the system based on the checked production notice and print three copies of the shipping slips. The packed goods are picked up by the courier at the scheduled time. Upon the pick-up, the courier reviews the shipping slips to the packed goods and signs off. The shipping staff then sign it too and checks for completeness before attaching the shipping slip copy 1 to the packed goods, stores copy 2 in the shipping slip tray and sends copy 3 to the Accounting Department. At the end of the day, in order to determine the level of goods produced, shipped and on backlog, the factory manager on duty retrieves and reconciles sales order copy 2, production notice and shipping slips copy 2.

As soon as account receivables (AR) staff in the Accounting Department receive shipping slips copy 3 from the shipping staff, the AR staff create AR entries in the system based on the shipping slip after matching it with the sales order copy 3 (that they received earlier from the sales staff). The AR is then saved to the AR data file and the physical documents filed. At the end of the day, the accounting manager prints invoices for all unbilled AR, then reviews and signs them. The AR staff then sends signed invoices to customers. Typically, close to the due date of the invoices, customers deposit the payment to the AGC bank account and send the remittance advice to AGC. Every end of the month, the cashier in the Accounting Department records the cash receipt into the system after reconciling the remittance advice to the monthly bank statement from the Bank. This process updates the AR data file and the advice and statements are filed. As soon as the cash receipt recording is completed, the AR staff prepare a customer account balance report based on the updated AR data, print it and then sends it to the Sales Manager.

At the end of the month, the IT department processes end of month closing based on relevant data from all department and produces the trial balance.

Appendix A contains a sample of documents from the AGC system that has been randomly selected by the internal audit staff for you to review before you conduct the fieldwork.

Required Tasks

As an Accounting Information System specialist, you are asked to assess the AGC business process. Due to limited time, you are asked to only review its significant processes. That is, all processes within the revenue cycle. You will review the current relevant business process (referred to below as the current AGC system) and then assess existing internal controls to allow you to suggest improvements required. As a final step, you will determine whether AGC needs to adopt an ERP or not. In doing so, you will have to do the following:

1. Create the Structured Narration Table, Context Diagram, Physical DFD, Annotated Structured Narration Table and Logical DFD of the current AGC system that you are reviewing.

2. Create the flowchart of the current AGC system being reviewed.

3. Identify five present controls and five missing controls. List them in the table provided and annotate on the flowchart you have created in Task 2.

4. Develop the control risk matrix, listing the five present and five recommended controls for addressing missing controls identified in the flowchart in point 2. Suggest what are the critical improvements needed based on your answers in Task 4. In addition, discuss what approach is better for AGC if it wants to achieve the suggested improvement (Total Quality Management or Business Process Reengineering)?

5. Based on your answers in Task 1 to 5, determine whether AGC needs to adopt an ERP or not. Explain why.