Question
(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
(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:
Item number
Location of item
Description of item
Quantity on hand
Cost per item
Date of last purchase
Date of last sale
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:
Inventory Substantive Test | How Generalized Audit Software Might Be Helpful for Substantive Tests |
---|---|
Observe the physical count, making and recording test counts when applicable. | Determine which items are to be test counted by selecting a random sample of a representative number of items from the inventory file as of the date of the physical count. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started