Question

Evaluation and testing of controls at Hales Ltd

Tyrone has provided a narrative of controls over inventory at Hales Ltd and would like you to provide some advice on making the preliminary control risk assessment. Hales is a distributor of haircare products, including shampoos, conditioners and styling products throughout Australia. Hales uses an on-line ordering system. Hales does not manufacture any goods in house, instead, an inventory of raw materials is kept, with manufacturing being outsourced to other companies. Hales has around 35 suppliers and 15 manufacturers. These companies have proven to be reliable in the past. Tyrone has made the following notes about three particular elements of the inventory system.

Purchase of raw materials

Purchase orders are generated by the computer when the inventory level of a particular material falls below 75% of what was used in the previous month. Purchase orders include the date, the suppliers name and the raw material required. Three copies of the purchase order are created. The first copy goes to the warehouse where it is used to enable the following up of overdue orders. The second copy is filed by the accounts clerk by order of date and the third copy goes to the supplier. Upon receipt of materials, barcodes on the delivery packages are scanned into the computer system. A two part receiving report is then generated. The first part is matched to the purchase order by the warehouse manager. The second is sent to the accounts clerk who files it. If the scanning of barcodes does not match data on the master file then the process is stopped.

Procedures for finished goods

When finished goods fall below 65% of the previous months sales, production orders are triggered. Production orders include a date, the manufacturers name, the raw materials needed and the volume of finished goods required. Two copies of the production order are generated. The first copy is sent to the raw materials warehouse where it is used as a picking slip by the warehouse staff. It is then included with materials which are sent to the manufacturer. The second copy is filed by the production manager by order of date. When finished goods arrive at Hales, barcodes on the delivery packets are scanned. A two part receiving report is generated, with the first copy being matched to the production order by the production manager and the second copy being filed by the accounts clerk. As with materials purchases, if the scanning of barcodes does not match the codes on the master file then the process is stopped.

Changes to the master file

The inventory master file contains information on the volumes of inventory on hand including barcode information and locations within the warehouse. The master file also has details of approved suppliers and manufacturers. Orders can only be made to suppliers and manufacturers on the master file. Changes to the master file can be made by the production manager. This applies to both raw materials and finished goods. To make changes the production manager completes an amendment form which is then kept as a record of any changes made.

Other information

There are separate warehouses, staff and procedures in place for the raw materials and finished goods. The selection of suppliers of raw materials and manufacturers is done automatically by the computer based on the latest price as per the last invoice and delivery time. Password access to the computer permits the following:

• Raw materials store staff have access to purchase order printing and goods received notes printing for materials.

• Finished goods store staff have access to goods received notes printing for finished goods.

• The production manager has access to production order printing and master file changes.

• The acounts clerk has access to master file changes.

Question 4

In relation to Hales Ltd:

• The weaknesses in the internal controls for each of the three aspects of the inventory system identified (raw materials, finished goods and changes to the master file).

• An assessment of the implications of each of the weaknesses you have identified.

• Three tests of control JDM’s IT audit division could perform to assist Tyrone with verifying the effectiveness of the internal controls (assuming that JDM will be performing tests of control).

• Two Computer Assisted Audit Techniques (CAATs) that Tyrone could request the IT auditors run to assist him in testing the valuation of inventory.

Answer 1

According to data :- P. NOI * Computer Assisted Auditing Techniques provide an automated approach to audit teste, replacing tests that would have been performed manually by the internal audit team. The completeness of manual tests is often limited by the completness of the data that can be analyzed by through a reasonable effort and by short time. t is obvious that the quality of audit consistently depends on the Capability of auditors to obtain additional support and Coverage for audit opinion at a low incremental Cost an auditor a The use of CATS gives internal auditors an opportunity to reach their tadget by: 1. Addresing expectations & Zimproving audit quality 3. Reducing risks Increasing productivity 5. Giving added value Suggestions

P.Q 6. Andentifying and extending Services 4. Improving team technology and information System skills CAAT Applications to industries his document gives a wide range of tests that are typically performed by internal auditors in Several Qistees 1. General Business process 9. finance and Banking . Services and Distribution 3. ci. Health Care 5. Government 6. manufacturing 4. Retail The involvement of the MIS team in your planning will give you additional resources to identify and evaluate EDP risk and to

P.3 better chose the tests that will efficiently leach your objectives Stock & INVENTORY CONTROL 1. Select items from perpetual stock for test sleconciliation 2. Use Sampling Command for physical reconciliation testing. 3. Reconcile selected physical counts to computed 3 amounts 4. Compare the valere of physical counts to general ledger value. 5. Statistically analyze usage and ordering to improve turnover. 6. Report on stock and high value balances using any selection 7. Test clerical accuracy of totals & extensions. 8. Summarize and stratify turnover by stock any item in Ordet.

P.4 9. Test for duplicate parts, item numbers, polices or descriptions. 10. Segregate variances from Standard pricing in peso amount Order 11. Identify obsolete inventory by sosted turnover analysis 12. Quick indentify items with yearly volume under on - hand quantity. 13. Isolate and analyze high value transactions by value, group, etc. 1. Identify starting and Sending period balances by class of group Р 15. Report on product in order of profitability (low-high, high-low) 16. Automatically Summarize products by group, location, type. etc. 17. Calculate Current inventory items based on Lifo value of pool.

or Cost P.S 18. Assess the financial viability of Life versus FIFO management 19. Determine the percentage change in sales, Police and ( levele 30. Analyze the difference between standard Costs and actual Costs. al. Isolate stock lines where the cost is greater than retail price. 99. Extract products with zero quantities ad Zero Porces 23. check product reasdening volume by item, ware house, vendol, and, gu. Divide inventory into closes and compare percent investment plean, vote positively.