In: Accounting
|
|
|
|
Average | ||||
FIFO | LIFO | Cost | ||
Ending Inventory | $ 85,500.00 | $ 58,520.00 | $ 72,447.00 | |
Cost of Goods sold | $ 1,79,550.00 | $ 2,06,530.00 | $ 1,92,603.00 |
Workings:
Particulars | Units | Rate | Amount | ||
Beginning Inventory | 3800 | $ 7.00 | $ 26,600.00 | ||
Purchases: | |||||
Oct-03 | 4750 | $ 8.00 | $ 38,000.00 | ||
Oct-09 | 6650 | $ 9.00 | $ 59,850.00 | ||
Oct-19 | 5700 | $ 10.00 | $ 57,000.00 | ||
Oct-25 | 7600 | $ 11.00 | $ 83,600.00 | ||
Cost of Goods Available for sale | 28500 | $ 9.30 | $ 2,65,050.00 | ||
Units Sold | 20710 | ||||
Ending Inventory | 7790 |
FIFO | |||||
Ending Inventory: | Units | Rate | Amount | ||
Units from: | Oct-25 | 7600 | $ 11.00 | $ 83,600.00 | |
Oct-19 | 190 | $ 10.00 | $ 1,900.00 | ||
7790 | $ 85,500.00 | ||||
Cost of Goods sold | ($ 265050 - $ 85500) | $ 1,79,550.00 | |||
LIFO | |||||
Ending Inventory: | Units | Rate | Amount | ||
Units from: | Beg. Inv. | 3800 | $ 7.00 | $ 26,600.00 | |
Oct-03 | 3990 | $ 8.00 | $ 31,920.00 | ||
7790 | $ 58,520.00 | ||||
Cost of Goods sold | ($ 265050 - $ 58520) | $ 2,06,530.00 | |||
Average Cost | |||||
Units | Rate | Amount | |||
Ending Inventory | 7790 | $ 9.30 | $ 72,447.00 | ||
Cost of Goods sold | 20710 | $ 9.30 | $ 1,92,603.00 | ||
28500 | $ 2,65,050.00 |