Problem -From the following transactions calculate the cost of closing...
FIFO Method Calculation for Closing Inventory and Cost of Goods Sold
Perpetual Inventory System
Opening Balance: 2000 units @ $10 = $20,000
Purchases:
- 15 July: 1000 units @ $15 = $15,000
- 31 July: 800 units @ $11 = $8,800
Total Cost of Goods Available for Sale: $43,800
Sales:
- 1 August: 2000 units sold @ $10 = $20,000
- 15 August: 1000 units sold @ $15 = $15,000
- 30 August: 1000 units sold @ $11 = $11,000
Total Cost of Goods Sold: $46,000
Closing Inventory:
Units remaining: 800
Cost of 800 units @ $11 = $8,800
Therefore, the cost of closing inventory is $8,800 and the cost of goods sold is $46,000.
Periodic Inventory System
Opening Balance: 2000 units @ $10 = $20,000
Purchases:
- 15 July: 1000 units @ $15 = $15,000
- 31 July: 800 units @ $11 = $8,800
Total Cost of Goods Available for Sale: $43,800
Cost of Goods Sold:
- 1 August: 2000 units sold (1000 FIFO, 1000 LIFO)
- Cost of 1000 units @ $10 = $10,000 (FIFO)
- Cost of 1000 units @ $11 = $11,000 (LIFO)
- 15 August: 1000 units sold (800 FIFO, 200 LIFO)
- Cost of 800 units @ $10 = $8,000 (FIFO)
- Cost of 200 units @ $11 = $2,200 (LIFO)
- 30 August: 1000 units sold FIFO
- Cost of 1000 units @ $11 = $11,000 (FIFO)
Total Cost of Goods Sold: $42,200 (FIFO) or $43,200 (LIFO)
Closing Inventory:
Units remaining: 800
Cost of 800 units @ $11 = $8,800
Therefore, the cost of closing inventory is $8,800 and the cost of goods sold is $42,200 (FIFO) or $43,200 (LIFO).