Computer-Assisted Substantive Tests for Inventory Audit
Not what you're looking for?
Just need some assistance getting my mind wrapped around this problem...
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.
**** See ATTACHED Word document for complete description ****
Purchase this Solution
Solution Summary
This solution states the inventory substantive tests and explains how general-purpose computer software packages and copy of inventory data might be helpful.
Education
- BA, Ain Shams University, Cairo Egypt
- MBA, California State University, Sacramento
Recent Feedback
- "ty i have more need help with"
- "ty i have jmore i need help with"
- "great help"
- "excellent help"
- "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Introduction to Finance
This quiz test introductory finance topics.