A CIA’s client, The Outsider, Inc., is a medium-sized manufacturer of products for the leisure time activities market (camping equipment, scuba gear, bows and arrows, and so on). During the past year, a computer system was installed, and inventory records of finished goods and parts were converted to a computer processing. The inventory master life is maintained on a disk. Each recorded of the file contains the following information: Item or part number Description Size Unit of measure code Quantity on hand Cost per unit Total value of inventory on hand at cost Date of last sale or usage Quantity sold or used this year Economic order quantity Code number of major vendor Code number of secondary vendor In preparation for year-end inventory, the client has two identical sets of preprinted inventory count cards. One set is for the client’s inventory counts and the other is for the CIA’s use to make audit test counts. The following information has been keypunched into the cards and interpreted on their face: Item or part number Description Size Unit of measure code In taking the year-end inventory, the client’s personnel will write the actual counted quantity on the face of each card. When all counts are complete, the counted quantity will be keypunched into the cards. The cards will be processed against the disk file, and quantity-on-hand figures will be adjusted to reflect the actual count. A computer listing will be prepared to show any missing inventory count cards and all quantity adjustments of more than $100 in value. These items will be investigation by client personnel, and all required adjustments will be made. When adjustments have been completed, the final year-end balances will be computed and posted to the general ledger. The CIA has available generalized audit software that can process both cards and disk files. Required: a. In general and without regard to the facts above, discuss the nature of generalized audit software and list the various types of uses of such software. b. List and describe at least five ways generalized audit software can be used to assist in the audit of inventory of The Outsider, Inc. (For example, the software can be used to read the disk inventory master file and list items of high unit cost or total value. Such item can be included in the CIA’s test counts to increase the dollar coverage of the audit.
A CIA’s client, The Outsider, Inc., is a medium-sized manufacturer of products for the leisure time activities market (camping equipment, scuba gear, bows and arrows, and so on). During the past year, a computer system was installed, and inventory records of finished goods and parts were converted to a computer processing. The inventory master life is maintained on a disk. Each recorded of the file contains the following information:
Item or part number
Description
Size
Unit of measure code
Quantity on hand
Cost per unit
Total value of inventory on hand at cost
Date of last sale or usage
Quantity sold or used this year
Economic order quantity
Code number of major vendor
Code number of secondary vendor
In preparation for year-end inventory, the client has two identical sets of preprinted inventory count cards. One set is for the client’s inventory counts and the other is for the CIA’s use to make audit test counts. The following information has been keypunched into the cards and interpreted on their face:
Item or part number
Description
Size
Unit of measure code
In taking the year-end inventory, the client’s personnel will write the actual counted quantity on the face of each card. When all counts are complete, the counted quantity will be keypunched into the cards. The cards will be processed against the disk file, and quantity-on-hand figures will be adjusted to reflect the actual count. A computer listing will be prepared to show any missing inventory count cards and all quantity adjustments of more than $100 in value. These items will be investigation by client personnel, and all required adjustments will be made. When adjustments have been completed, the final year-end balances will be computed and posted to the general ledger.
The CIA has available generalized audit software that can process both cards and disk files.
Required:
a. In general and without regard to the facts above, discuss the nature of generalized audit software and list the various types of uses of such software.
b. List and describe at least five ways generalized audit software can be used to assist in the audit of inventory of The Outsider, Inc. (For example, the software can be used to read the disk inventory master file and list items of high unit cost or total value. Such item can be included in the CIA’s test counts to increase the dollar coverage of the audit.
Step by step
Solved in 2 steps
