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

  Internal audit

Describe and evaluate this type of internal audit. What types of organisation would it be most useful for?

  Accounting professional and ethical standards

Code of Ethics for Professional Accountants

  Prepare swag''s consolidated balance sheet

Prepare Swag's consolidated balance sheet

  Auditing and assurance

Notable operational challenges for 4X Heavy Ltd faced in 2012/2013 were but not limited to

  State of the company’s industry and associated risk factors

Audit partner is concerned about his lack of knowledge of the industry the company is operating in, state of the company's industry and associated risk factors

  Prepare a memo to the audit partner

Prepare a memo to the audit partner on the ‘state of the company's industry' and associated risk factors.

  Adjusting or non- adjusting events

State whether Event is adjusting or non-adjusting event.

  Audit financial data

As a consequence an accounts payable clerk and financial accountant were made redundant from the business during the year.

  Identify principal audit risk

To identify principal audit risk and corresponding audit procedures

  Auditing and assurance

Show the audit inherent risk and rate the risk as low, medium or high.

  National health reform

Explain the role of the following three 'bodies' in National Health Reform

  Prepare a memo on the state of the company''s industry

Prepare a memo on the 'state of the company's industry' and associated risk factors.

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