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 |