Concept explainers
A CPA’s client, Boos & Baumkirchner, Inc., is a medium-size manufacturer of products for the leisure-time activities market (camping equipment, scuba gear, bows and arrows, and so forth). During the past year, a new computer system was installed and inventory records of finished goods and parts were converted to the new system. The inventory master file is maintained electronically. Each record 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 used or sold 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 CPA’s use to make audit test counts. The following information is on each card:
- 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 entered into the system. The cards will be processed against the inventory database, and quantity-on-hand figures will be adjusted to reflect the actual count. A computer-generated edit 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 investigated 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 CPA has available generalized audit software that will run on the client’s computer and can process the client’s electronic records.
Required
- a. In general and without regard to the facts in this case, discuss the nature of generalized audit software and list the various types and uses.
- b. List and describe at least five ways generalized audit software can be used to assist in all aspects of the audit of the inventory of Boos & Baumkirchner, Inc. (For example, the software can be used to read the inventory master file and list items and parts with a high unit cost or total value. Such items can be included in the test counts to increase the dollar coverage of the audit verification.)*
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
AUDITING+ASSURANCE 12MONTH ACCESS CARD
- Paul Williams recently joined XYZ2 Limited as the head of the accounting department. Williams spent the first few weeks analysing the account information system. Based on this analysis, Williams is concerned about the purchase system of XYZ2 Limited. Here are the details of the purchase system. The purchasing agent of XYZ2 Limited periodically checks inventory levels from a computer terminal connected to a central accounting system. The agent searches the inventory file for items that need to be ordered. He then selects a supplier, prints a hard copy of the purchase order, and mails it to the vendor. The clerk files one copy of the PO in the department and sends a second copy to the AP Clerk. When the inventories arrive at the receiving department, a receiving clerk reconciles the items with the packing slip, inspects them for condition, and manually prepares a three-part receiving report. The clerk sends one copy to the purchasing department to close out the open PO, files one copy…arrow_forwardYou are asked to travel to Milwaukee to observe and verify the inventory of the Milwaukee branch of one of your cilents. You arrive on Thursday, December 30, and find that the inventory procedures have just been started. You spot a railway car on the sidetrack ar the unloading door and ask the warehouse superintendent, Buck Rogers, how he plans to inventory the contents of the car. He responds "We are not going to include the contents in the inventory." Later in the day, you ask the bookkeeper for the invoive on the carload and the related freight bill. The invoice lists the various items, prices, and extensions of the goods in the car. You note that the carload of goods in the car was $35,300. The frieght bill called for a payment of $1,500. Terms were net 30 days. The bookkeeper affirms the fact that this invoice is to be held for recording in January. a. Does your cilent have a liability that should be recorded at December 31? Discuss. b. Prepare a journal entry(ies), if required,…arrow_forwardPaul Williams recently joined XYZ2 Limited as the head of accounting department. Williams spent the first few weeks to analyse the account information system. Based on this analysis, Williams is concerned about the purchase system of XYZ2 Limited. Here is the details of purchase system. The purchasing agent of XYZ2 Limited periodically checks inventory levels from a computer terminal, which is connected to a central accounting system. The agent searches the inventory file for items that need to be ordered. He then selects a supplier, prints a hard copy of the purchase order, and mails it to the vendor. The clerk files one copy of the PO in the department and sends a second copy to the AP Clerk. When the inventories arrive at the receiving department, a receiving clerk reconciles the items with the packing slip, inspects them for condition, and manually prepares a three-part receiving report. The clerk sends one copy to the purchasing department to close out the open PO, files one copy…arrow_forward
- (Inventoriable Goods and Costs) You are asked to travel to Milwaukee to observe and verify the inventory of the Milwaukee branch of one of your clients. You arrive on Thursday, December 30, and find that the inventory procedures have just been started. You spot a railway car on the sidetrack at the unloading door and ask the warehouse superintendent, Buck Rogers, how he plans to inventory the contents of the car. He responds, “We are not going to include the contents in the inventory.”Later in the day, you ask the bookkeeper for the invoice on the carload and the related freight bill. The invoice lists the various items, prices, and extensions of the goods in the car. You note that the carload was shipped December 24 from Albuquerque, f.o.b. Albuquerque, and that the total invoice price of the goods in the car was $35,300. The freight bill called for a payment of $1,500. Terms were net 30 days. The bookkeeper affirms the fact that this invoice is to be held for recording in…arrow_forwardWhen Mr. Avila orders materials for his construction business, he sends a duplicate copy of the purchase order to the receiving department. During the delivery of materials, Mr. Nobles, the receiving clerk, records the receipt of shipment of this purchase order. After recording, Mr. Nobles sends the purchase order to the accounting department where it is used to record materials purchased and accounts payable. The materials are trasported to the storage area by forklifts. The additional purchased quantities are recorded on storage records. Required: Identify the weakness/weaknesses in internal control and opposite the identified weakness or weaknesses, enumerate the control procedure/s that you will recommend to avoid or mitigate the risk of loss.arrow_forwardIn March 2021, Price Company began developing a new software system to be used internally for managing its inventory. The software integrates customer orders with inventory on hand to automatically place orders for additional inventory when needed. The software then automatically records inventory as the shipment is received and read by scanners. The software development was completed in October 2021 at a cost of $150,000. Of this amount, $25,000 was spent before the application development stage was established. Price expects to use the software for at least five years. Determine the initial amount that Price should capitalize as software development costs.arrow_forward
- In connection with your examination of the financial statements of Camry Products Co, a limited liability company, for the year ended 31 March 20X9, you are reviewing the plans for a physical inventory count at the company's warehouse on 31 March 20X9. The company assembles domestic appliances, and inventory of finished appliances, unassembled parts and sundry inventory are stored in the warehouse which is adjacent to the company's assembly plant. The plant will continue to produce goods during the inventory count until 5pm on 31 March 20X9. On 30 March 20X9, the warehouse staff will deliver the estimated quantities of unassembled parts and sundry inventory which will be required for production for 31 March 20X9; however, emergency requisitions by the factory will be filled on 31 March. During the inventory count, the warehouse staff will continue to receive parts and sundry inventory, and to dispatch finished appliances. Appliances which are completed on 31 March 20X9 will remain in…arrow_forwardYou have been assigned to the audit of Carter Brandon Co (CBC), and you are drafting the audit for payables and accruals for the year ended 31 December 20x7. The company operates from a site in West Wendon. All raw materials are received in the stores and all deliveries are checked to the delivery note and purchase order. The stores supervisor raises a goods received note and is also responsible for raising credit requests if there are any problems with the raw materials delivered.When the purchase ledger department staff receive the purchase invoices, they match them to the relevant goods received notes and purchase orders, and post them to the computerised purchase ledger. Suppliers are paid on the last day of each month. Other payables and accruals consist of tax, wages and other statutory deductions, accruals and time- apportioned expenses such as electricity and telephone.a. Assess the audit work you will carry out to compare suppliers' statements with balances recorded on the…arrow_forwardYou are working as a summer intern for AAA Auditing, Inc. You have been asked to help resolve discrepancies noted in the audit for Dolfin Corporation, a retailer of specialty aquarium supplies.As a retail company, Dolfin Corporation uses the perpetual inventory system. To prepare for this assignment, you have been asked to review your knowledge of salesand purchase transactions by completing the following table.Consider the effect of each transaction on the three accounts listed, and identify which accounts are debited or credited. If not affected by the transaction, select "No Effect". Inventory Estimated Returns Inventory Cost of Goods Sold Purchase of merchandise for resale Debit Cash sale of merchandise Credit Customer returns Debit Yearly estimate for customer returns Freight paid for merchandise purchased FOB shipping point Debit Return of merchandise purchased for resale Credit Freight paid for sales with FOB destination No Effect Sale on…arrow_forward
- You are auditing a client that supplies electrical products to retail stores and electrical contractors throughout the country.The client keeps its accounts receivable records on a computer system, which is updated at the end of each business day.You plan to audit accounts receivable balance as at the end of the financial year, and you have a generalised audit software (GAS) package available to help in this task.Required:Identify ten (10) substantive audit procedures that you could perform using generalised audit software (GAS) in relation to auditing the accounts receivable account.arrow_forwardYou are working as a summer intern for AAA Auditing. You have been asked to help resolve discrepancies noted in the audit for Dolfin Company, a retailer of specialty aquarium supplies. As a merchandising company, Dolfin Company uses the perpetual inventory system. To prepare for this assignment, you have been asked to review your knowledge of sales and purchase transactions by completing the following table. Consider the effect of each transaction on the three accounts listed, then use checkmarks to identify which accounts are debited or credited. If none of these accounts is affected by the transaction, check the “No Effect” box. Merchandise Inventory Estimated Returns Inventory Cost of Merchandise Sold No Effect Debit Credit Debit Credit Debit Credit Purchase of merchandise for resale Customer returns Customer payment on account Payment of service…arrow_forwardAs you are planning the annual audit of Norton Corporation, you note that the company has a number of user operated computers in use in various locations. One of the machines has been installed in the stores department, which has the responsibility for disbursing stock items and for maintaining stores records. In your audit, you find that one employee receives the requisitions for stores, disburses the stock, maintains the records, operates the computer, and authorizes adjustments to the total amounts of stock recorded by the computer. When you discuss the applicable controls with the department manager, you are told that the user operated computer is assigned exclusively to that department. Therefore, the manager contends that it does not require the same types of controls applicable to large IT systems. a. Comment on the manager’s contention.arrow_forward
- Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub