Worked example 1
A business has the following inventory transactions for Material X in March:
- Mar 1: Opening inventory of 100 units @ $4.00 each.
- Mar 10: Purchase of 150 units @ $5.00 each.
- Mar 22: Issue of 180 units to production.
Calculate the value of the closing inventory at March 31 using (a) FIFO and (b) AVCO.
Show solution outline
1. Calculate Closing Inventory Units: Closing Units = Opening Units + Purchases - Issues Closing Units = 100 + 150 - 180 = 70 units
(a) FIFO Method: First-In, First-Out means we issue the oldest stock first.
- The issue of 180 units is made up of:
- 100 units @ $4.00 (from opening inventory) = $400
- 80 units @ $5.00 (from Mar 10 purchase) = $400
- Closing inventory consists of the remaining units from the latest purchase:
- Remaining units = 150 - 80 = 70 units
- Value of Closing Inventory = 70 units * 350**
(b) AVCO (Weighted Average Cost) Method: Recalculate the average cost after each purchase.
- After the purchase on Mar 10, calculate the new weighted average cost:
- Total Value = (100 units * $4.00) + (150 units * $5.00) = 750 =
- Total Units = 100 + 150 = 250 units
- New AVCO per unit = $1,150 / 250 units = $4.60 per unit
- Value the issue on Mar 22 using this new average cost:
- Value of Issue = 180 units * 828
- Value the closing inventory of 70 units:
- Value of Closing Inventory = 70 units * 322**
- (Alternatively: Total Value $1,150 - Issue Value $828 =