Computer-assisted substantive tests for inventory

Assignment Help Auditing
Reference no: EM13683093

16-26 (Evaluation of internal controls-raw materials and supplies inventory) The Jameson Company produces a variety of chemical products for use by plastics manufacturers. The plant operates on two shifts, five days per week, with maintenance work performed on the third shift and on Saturdays as required. 

An audit conducted by the staff of the new corporate internal audit department has recently been completed, and the comments on inventory control were not favorable. Audit comments were particularly directed to the control of raw material ingredients and maintenance  materials. 

Raw material ingredients are received at the back of the plant, signed for by one of the employees of the batching department, and stored near the location of the initial batching process. Receiving tallies are given to the supervisor during the day, and he forwards the tallies to the inventory control department at the end of the day. The inventory control department calculates ingredient use using weekly reports of actual production and standard formulas. 

Physical inventories are taken quarterly. Purchase requisitions are prepared by the inventory control department and rush orders are frequent. In spite of the need for rush orders, the production superintendent regularly gets memos from the controller stating that there must be excessive inventory because the ingredient inventory dollar value is too high. 

Maintenance parts and supplies are received and stored in a storeroom. There is a storeroom clerk on each of the operating shifts. Storeroom requisitions are to be filled out for everything taken from the storeroom; however, this practice is not always followed. The storeroom is not locked when the clerk is out because of the need to obtain parts quickly. 

The storeroom is also open during the third shift for the maintenance crews to get parts as needed. Purchase requisitions are prepared by the storeroom clerk, and physical inventory is taken on a cycle count basis. Rush orders are frequent. 

Required

a.     Identify the weaknesses in Jameson Company's internal control procedures used for (1) ingredients inventory and (2) maintenance material and supplies inventory. 

b.     Recommend improvements that should be instituted for each of these areas.

16-29 (Computer-assisted substantive tests for inventory) An auditor is conducting an audit of the financial statements of a wholesale cosmetics distributor with an inventory consisting of thousands of individual items. The distributor keeps its inventory in its own distribution center and two public warehouses. An inventory computer file is maintained on a computer disk and at the end of each day the file is updated. Each record of the inventory file contains the following data: 

1.     Item number

2.     Location of item

3.     Description of item

4.     Quantity on hand

5.     Cost per item

6.     Date of last purchase

7.     Date of last sale

8.     Quantity sold during year 

The auditor is planning to observe the distributor's physical count of inventories as of a given date. The auditor will have available a computer tape of the data on the inventory file on the date of the physical count and a general-purpose computer software package. 

Required

 

The auditor is planning to perform inventory substantive tests. Identify the inventory tests and describe how use of the general-purpose software package and the tape of the inventory file data might be helpful to the auditor in performing such tests. (Hint: You may wish to refer to Chapter 12 as well as this chapter in answering this question.) Organize your answer as follows:

 

 

Reference no: EM13683093

Questions Cloud

What is the safes acceleration up the ramp : Burglars are trying to push a 1000 kg safe up a 20o frictionless ramp with a horizontal force of 4000N. What is Burglars are trying to push a 1000 kg safe up a 20o frictionless ramp with a horizontal force of 4000N. What is the safe's acceleration up..
Find an exponential decay or growth graph of a real phenomen : Find an exponential decay or growth graph of a real phenomenon. State clearly what is decaying or growing. Find out the half-life and time constant from the graph. Please show your steps.
Based on a video clip on apple documentary : Based on a video clip on Apple's documentary uploaded in the Personalized Learning Space (PLS) about, Steve Jobs' marketing strategies, identify and describe keylessons that you have learned and become an eye opener for you from a marketing point of ..
Recently you have been appointed as marketing director : Recently, you have been appointed as Marketing Director for a start-up company (a franchisee model can also be considered). Your CEO asked you to plan a marketing strategy and its activities for the whole year.
Computer-assisted substantive tests for inventory : Evaluation of internal controls-raw materials and supplies inventory, Computer-assisted substantive tests for inventory
Describe how use of the general-purpose software package : describe how use of the general-purpose software package and the tape of the inventory file data might be helpful to the auditor in performing such tests.
Compute expected frequencies for each of the cells : Compute expected frequencies for each of the cells in the table in part c). Do you feel that the exponential distribution provides an adequate description of these data?
Compute the concentration of zn2+ in a solution : Compute the concentration of Zn2+ in a solution prepared by mixing equal volumes of 5.0x103 M Zn(NO3)2 and 0.10 M NaCN. Ignore the hydrolysis of CN(aq).
Explain how would this error effect the time required : While performing an activation energy experiment you accidently added 4.0 ml of water instead of 1.0ml. Explain how would this error effect the time required for the color to change? (Increase, Decrease, Un-effacted).

Reviews

Write a Review

Auditing Questions & Answers

  Describe the substantive tests

Describe the substantive tests that you would perform on transactions in the acquisitions cycle of this system to gain adequate assurance over the assertions of completeness, cut off and accuracy.

  Impacts of world bank in developing countries

Please see article. Identify one of the issues or activities that the World Bank is involved. How have they made a difference in a developing country or countries with regards to this issue?

  What is becky''s bad debt deduction for 2012

the bankruptcy proceedings are closed, and creditors receive 10 percent of the amount due on the debt. What is Becky's bad debt deduction for 2012? For 2013?

  Internal control and audit sampling

You have discussed with the president of Vista Corporation several material weaknesses in internal control that have come to your attention during your audit.

  Feature of internal control

Many businesses receive most of their cash on credit sales through the mail. Suppose you own a business in which you must hire employees to handle cash receipts and perform the related accounting duties.

  Based on peach blossom cologne company - audit case1 what

based on peach blossom cologne company - audit case.1. what are expectations of the board of directors concerning audit

  Alex is a director and the ceo of stylux appliances pty ltd

alex is a director and the ceo of stylux appliances pty ltd stylux. the company retails electrical appliances. the

  Overview - pressure hydraulicspressure hydraulics is a

overview - pressure hydraulicspressure hydraulics is a locally owned business that currently has three service centres

  The ceo of your company recently met with the external

the ceo of your company recently met with the external auditors to discuss the scope of the years audit. the auditors

  Listed below are 12 internal control procedures or

listed below are 12 internal control procedures or requirements for the expenditure cycle purchasing payroll accounts

  You are the auditor of globe ltd a manufacturer of colour

you are the auditor of globe ltd a manufacturer of colour printers. you have closely scrutinised the financial reports

  Martin s albert social security number 111-11-1111 is 39

martin s. albert social security number 111-11-1111 is 39 years old and is married to michele r. albert social security

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd