1. Calculate Cost of Goods Sold (COGS)
First Sale (120 units on Apr 15):
- The first 50 units sold are from opening inventory: 50 units × 80=4,000
- The next 70 units are from the Apr 8 purchase: 70 units × 85=5,950
- COGS for first sale = 4,000+5,950 = 9,950
Second Sale (70 units on Apr 28):
- After the first sale, 30 units remain from the Apr 8 purchase (100 - 70).
- The first 30 units sold are these remaining units: 30 units × 85=2,550
- The next 40 units are from the Apr 22 purchase: 40 units × 90=3,600
- COGS for second sale = 2,550+3,600 = 6,150
Total COGS for April:
- Total COGS = 9,950+6,150 = **16,100∗∗
2. Calculate Closing Inventory
Units available: 50 (opening) + 100 (Apr 8) + 80 (Apr 22) = 230 units
Units sold: 120 + 70 = 190 units
Closing units: 230 - 190 = 40 units
Value of Closing Inventory (FIFO - newest stock remains):
- The remaining 40 units are from the latest purchase (Apr 22).
- Value = 40 units × 90=∗∗3,600**
Check:
Opening Inventory ($4,000) + Purchases (($8,500)+($7,200)) - Closing Inventory ($3,600) = COGS
4,000+15,700 - 3,600=∗∗16,100** ✓