| 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. |
No comments:
Post a Comment