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

  Public administration audit critique

Prepare a two-page audit critique, and include each of the following: Briefly describe the purpose of the audit (identify the type of audit). Briefly describe the method(s) used during the audit

  Determining audit situations

For each of these, indicate whether you would include in written representations for (1) all audits, (2) audits of public entities (under AS 5), or (3) not included in written representations.

  Review of the audit working papers

State the audit evidence that you should expect to find in undertaking your review of the audit working papers and financial statements of Aspersion.

  Explain the ethical audit issues

Ethical audit issue must contain integrity, auditing duties and responsibility - ethical issue must contain objectivity, confidentiality, competence

  Audit theory and assurance

A Business report identifying auditing procedures and practices

  Determining audit practices

Identify a profile for a taxpayer who is more likely than the national average to be audited by the IRS. What factors cause certain taxpayers to be audited more frequently?

  Questionpropose a broad audit plana what material kinds of

questionpropose a broad audit plana. what material kinds of transactions and transaction cycles are involved?b. what

  Equity valution for bank of america

You are considering an investment in Bank of America (BAC, NYSE). From your analysis, you believe this stock should be valued so as to produce a 9.5 percent long-term rate of return.

  Find what is carl''s agi for 2010

Carl had the subsequent transactions for 2010 - Find what is Carl's AGI for 2010

  Identify any threats to compliance with the ifac code

Recently John was approached by the board of Company Ltd with an offer of employment as a director starting in two years time. The only condition was that the audit fees have to be reduced for the current and next year's audit.

  Audit risk model and discuss how they interact

Audit risk is a key consideration and guide to planning an audit - explain why and list the key components of the Audit Risk Model (ARM) and discuss how they interact?

  Design a monitoring activity

What are monitoring activities and design a monitoring activity that would achieve this assurance objective.

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