ALCO PRODUCTS, INC.

Required

1.Evaluate the plant systems and procedures and identify the key weaknesses.

2 What is the probable source of the shortage?

3.Recommend changes to the plant procedures to facilitate control.

Background

The auditing department of Alco Products was contacted by the manager of accounting for the metalstamping division who informed it that one of their plants had been experiencing inventory shortages. The manager stated that he believed the finished goods book inventory had been overstated and that this condition had been discovered as a result of an analysis of material consumption that indicated that the finishedgoods inventory level should be higher than it was.

The manager informed the auditors that, at month's end, production employees from each production stage performed the inventory counts for the raw materials and workinprocess inventories and reported them to the accounting department. The finishedgoods inventory was controlled through perpetual inventory records that were reconciled to the general ledger at the end of each quarter. WIP material consumption was then calculated based on transfers to finished goods plus standard scrap loss currently at 10 percent (based on scrap sales remittances from the scrap dealer) of the material transferred to the finishedgoods inventory. Based on the analysis of beginning and ending inventory balances, material receipts and material consumption, it was determined that there should have been more finished goods in the inventory. The auditors were asked to visit the location to review the inventory and proofofbilling procedures and validate the reported shortages and determine the causes. (See exhibit for activity recap.)

Audit Plan

The auditors arrived at the location and discussed their preliminary audit plan with plant management. It was agreed that, since the raw material and workinprocess inventories were taken at different times, the auditors would observe the physical inventory count procedures for both and would perform these counts of the finished goods later in the day. Also, the auditors would review the prior months' inventories. The auditors were advised that they would meet with the production people taking the inventory. It was agreed that a review would be made of the production and the scrapreporting systems subsequent to completion of the inventory work. Raw material receiving procedures would be examined as well as procedures for control of finishedgoods shipments.

Plant Procedures

Raw Materials

The auditors learned that the aluminum was received in twopound sheets, 100 sheets to a bundle, and four bundles to a pallet and was stored in the manufacturing area to facilitate access during production. When received, a materialreceived record was prepared, pre-numbered and used for receipt of items entering the plant.The record was sent to the accounting department where it was compared to a copy of the purchase order and held, pending receipt of the invoice. As the material was introduced into the manufacturing process, a requisition was prepared and forwarded to the accounting department.

Work in Process

After the material was requisitioned from the rawmaterial inventory, it was fed into machines where 24 finishedgoods pieces were stamped out of each sheet. The skeleton (rawmaterialsheet remainder) was then placed in a scrap bin; and the finishedgoods pieces were packed 200 pieces to a package, a maximum of 50 packages to a pallet. A twopart load ticket was then prepared, and a copy was sent to the accounting department for updating the perpetual inventory records. The other accompanied the load to the finishedgoods warehouse.

Scrap Procedures

The skeletons were collected in a scrap bin, and the full bins were emptied into a trailer located at the scrap dock. At his convenience, the scrap dealer came to the plant, dropped off an empty trailer, and picked up the full one. When the scrap dealer left the plant, the gate guard recorded the scrap dealer's billoflading number. If the guard was making his hourly security inspection, the scrap dealer was responsible for recording this number. If a filled trailer was not picked up, the scrap dealer was contacted and requested to pick it up.

The scrap dealer took the load to a local business that had a truck scale, weighed the truck, and recorded the weights. The scrap dealer sent a copy of the weight ticket to the plant along with the check and the remittance advice for the value of the scrap. These data were used to develop the scrap loss. The accounting department received the check, compared the weight tickets to the remittance advice, and verified the value per pound to the contract.

Finished Goods

When the material was received from the workingprocess area, warehouse employees verified the loadticket count; and the pallets were stored. At the time of shipment, a pre-numbered bill of lading was prepared with copies for the accounting department, customer, shipping department files, and a gate guard who verified the load. The accounting department verified the shipping information on the bill of lading to the original shipping authorization and invoice to the customer, accounted for the bills of lading through a sequential numerical checkoff list, and posted the perpetual inventory records from the copy of the bill of lading forwarded from the gate guard.

Audit Procedures

The auditors observed the current month's physical inventory of raw material and work in process and verified that the counts and summarizations were accurate. They made test counts of the finished goods and agreed on the counts in the perpetual records. They reviewed the prior month's physical inventories of raw materials and work in process and agreed on the tabulations in the general ledger. They tested the preceding month's receipts and issuances of raw material, verified the accuracy of material reported as used in work in process, and verified the reported work-inprocess production by reference to loadticket recaps and finishedgoodsstorage reports. Reported scrap shipments were reviewed by comparison of the gate log to remittances received from the scrap dealer, and finished goods shipments were verified by examination of the billoflading check-off list for completeness and tracing to the related invoices.

Exhibit

Inventory and Activity Recap

Subject

Beginning

Ending

Raw Materials

70,000 Sheets

80,000 Sheets

Work in Process

30,000 Sheets

30,000 Sheets

Finished Goods

2,400,000 Pieces

2,256,000 Pieces

SubjectOther Information

Raw Materials Receipts45,000 Sheets

Raw Materials Transferred to Work in Process35,000 Sheets

Work in Process Requisitioned from Raw Materials35,000 Sheets

Finished Goods Production (WIP to Finished Goods)672,000 Pieces

Finished Goods Shipped816,000 Pieces