In: Accounting
  | 
  | 
  | 
  | 
  | 
| 
 Average Method  | 
 Cost of Goods available for sale  | 
||
| 
 Units  | 
 Cost/unit  | 
 COG for sale  | 
|
| 
 Beginning Inventory  | 
 2400  | 
 $ 6.00  | 
 $ 14,400.00  | 
| 
 Purchases:  | 
|||
| 
 03-Oct  | 
 3000  | 
 $ 7.00  | 
 $ 21,000.00  | 
| 
 09-Oct  | 
 4200  | 
 $ 8.00  | 
 $ 33,600.00  | 
| 
 19-Oct  | 
 3600  | 
 $ 9.00  | 
 $ 32,400.00  | 
| 
 25-Oct  | 
 4800  | 
 $ 10.00  | 
 $ 48,000.00  | 
| 
 TOTAL  | 
 18000  | 
 $ 8.3000  | 
 $ 149,400.00  | 
Cost of Goods available for sale = $ 149400
Weighted Average Cost per unit = $ 149400 / 18000 = $ 8.30
| 
 FIFO  | 
 LIFO  | 
 Weighted Average  | 
|
| 
 Ending Inventory  | 
 $ 49,080.00  | 
 $ 32,040.00  | 
 $ 40,836.00 [4920 x $ 8.30]  | 
| 
 Cost of Goods Sold  | 
 $ 100,320.00  | 
 $ 117,360.00  | 
 $ 108,564.00 [13080 x $ 8.30]  | 
| 
 FIFO  | 
 Cost of Goods available for sale  | 
 Cost of Goods Sold  | 
 Ending Inventory  | 
||||||
| 
 Units  | 
 Cost/unit  | 
 COG for sale  | 
 Units sold  | 
 Cost/unit  | 
 COGS  | 
 Units  | 
 Cost/unit  | 
 Ending inventory  | 
|
| 
 Beginning Inventory  | 
 2400  | 
 $ 6.00  | 
 $ 14,400.00  | 
 2400  | 
 $ 6.00  | 
 $ 14,400.00  | 
 0  | 
 $ 6.00  | 
 $ -  | 
| 
 Purchases:  | 
|||||||||
| 
 03-Oct  | 
 3000  | 
 $ 7.00  | 
 $ 21,000.00  | 
 3000  | 
 $ 7.00  | 
 $ 21,000.00  | 
 0  | 
 $ 7.00  | 
 $ -  | 
| 
 09-Oct  | 
 4200  | 
 $ 8.00  | 
 $ 33,600.00  | 
 4200  | 
 $ 8.00  | 
 $ 33,600.00  | 
 0  | 
 $ 8.00  | 
 $ -  | 
| 
 19-Oct  | 
 3600  | 
 $ 9.00  | 
 $ 32,400.00  | 
 3480  | 
 $ 9.00  | 
 $ 31,320.00  | 
 120  | 
 $ 9.00  | 
 $ 1,080.00  | 
| 
 25-Oct  | 
 4800  | 
 $ 10.00  | 
 $ 48,000.00  | 
 0  | 
 $ 10.00  | 
 $ -  | 
 4800  | 
 $ 10.00  | 
 $ 48,000.00  | 
| 
 TOTAL  | 
 18000  | 
 $ 149,400.00  | 
 13080  | 
 $ 100,320.00  | 
 4920  | 
 $ 49,080.00  | 
|||
| 
 LIFO  | 
 Cost of Goods available for sale  | 
 Cost of Goods Sold  | 
 Ending Inventory  | 
||||||
| 
 Units  | 
 Cost/unit  | 
 COG for sale  | 
 Units sold  | 
 Cost/unit  | 
 COGS  | 
 Units  | 
 Cost/unit  | 
 Ending inventory  | 
|
| 
 Beginning Inventory  | 
 2400  | 
 $ 6.00  | 
 $ 14,400.00  | 
 0  | 
 $ 6.00  | 
 $ -  | 
 2400  | 
 $ 6.00  | 
 $ 14,400.00  | 
| 
 Purchases:  | 
|||||||||
| 
 03-Oct  | 
 3000  | 
 $ 7.00  | 
 $ 21,000.00  | 
 480  | 
 $ 7.00  | 
 $ 3,360.00  | 
 2520  | 
 $ 7.00  | 
 $ 17,640.00  | 
| 
 09-Oct  | 
 4200  | 
 $ 8.00  | 
 $ 33,600.00  | 
 4200  | 
 $ 8.00  | 
 $ 33,600.00  | 
 0  | 
 $ 8.00  | 
 $ -  | 
| 
 19-Oct  | 
 3600  | 
 $ 9.00  | 
 $ 32,400.00  | 
 3600  | 
 $ 9.00  | 
 $ 32,400.00  | 
 0  | 
 $ 9.00  | 
 $ -  | 
| 
 25-Oct  | 
 4800  | 
 $ 10.00  | 
 $ 48,000.00  | 
 4800  | 
 $ 10.00  | 
 $ 48,000.00  | 
 0  | 
 $ 10.00  | 
 $ -  | 
| 
 TOTAL  | 
 18000  | 
 $ 149,400.00  | 
 13080  | 
 $ 117,360.00  | 
 4920  | 
 $ 32,040.00  | 
|||