Thursday, September 26, 2019

Inventory Task (Simulation)

A B C
Product Line Adjustment Required to Inventory Balance, If Any ($) Justification for Adjustment Required
Widgets - 10mm ($3,743) Items on consignment with customer
The SKU 267-1 physical count per Inventory Count Sheet A and B (Document #2) was 250 units. The Perpetual Inventory Listing (Document #4) shows 1,000 units. Per the Supplier Report (Document #3), 750 units (15% of 5,000 units) at $4.99 per unit were provided to a customer on a consignment basis on December 31, year 4, and should be reclassified into consigned inventory. Total adjustment is a decrease to inventory of $3,743 (750 units × $4.99, rounded).
Widgets - 5mm 0  Errors in the count
The SKU 267-4 physical count per Inventory Count Sheet A and B (Document #2) was 4,098 units. The Perpetual Inventory Listing (Document #4) shows 4,102 units. Per the Supplier Report (Document #3), the final count should be 4,102 units (10,000 units – 5,898 units). Per Document #1 (Email from Controller), there was a mistake in the auditor’s count, and the correct amount was confirmed by another auditor; therefore, no adjustment to the client records is required.
Hex bolts $645  Returns not yet processed in the perpetual inventory system
The SKU 561-3 physical count per Inventory Count Sheet A and B (Document #2) was 9,925 units. The Perpetual Inventory Listing (Document #4) shows 9,875 units. The difference of 50 units (9,925 units – 9,875 units) was Hex Bolts located in the Returns Area of the warehouse (Document #5), and per Document #1 (Email from Controller), these units had not yet been added back into the Perpetual Inventory account; therefore, an adjustment to increase inventory by $645 is necessary (50 units × $12.89).
  Total ($3,098)
Total net adjustment to the Inventory account was ($3,098) [($3,743) + $0 + $645] and is automatically calculated in this simulation.



Conclusion
Based on the inventory work performed, the inventory balance is not materially misstated because the required adjustments identified are less than performance materiality.
Given that the materiality limit was $8,000 and the performance materiality was set at $5,000, the ($3,098) adjustment to Inventory is immaterial; therefore, one can conclude that the inventory balance is not materially misstated.


No comments:

Post a Comment