In: Accounting
|
|
|
|
Req.1
Average Cost Per Unit | $4.82 |
Explanation:
1)
Date | Unit | Cost per unit | Total cost |
---|---|---|---|
a | b | a*b | |
Jan 2. | 1300 | 4.38 | 5694 |
Jan 10. | 700 | 4.67 | 3269 |
Jan 18. | 1100 | 4.82 | 5302 |
Jan 23. | 1400 | 4.96 | 6944 |
Jan 28. | 1700 | 5.11 | 8687 |
Total | 6200 | $29,896 | |
Average cost per unit = 29896/6200=$ 4.82 | |||
Ending inventory in units=1000 units |
Req.2
FIFO | LIFO | Average | |
Ending Inventory | $5110 | $4380 | $4,820 |
Explanation:
1) FIFO:
Goods purchased first are sold first |
Hence,ending inventory of 1000 units consist of last purchase (Jan 28.) |
Ending inventory=1000*5.11 = $ 5110 |
2) LIFO:
Goods purchased last are sold first |
Hence,ending inventory of 1000 units consist of last purchase (Jan 2) |
Ending inventory=1000*4.38= $ 4,380 |
3)Average
Ending Inventory : 1000* $4.82 = $ 4820 |
Req.3
FIFO | LIFO | Average Cost | |
Would amount be same | Yes | No | No |
Amoun | $5110 | $4889 | $5057 |
Explanation:
1) FIFO
Amount would remain same so no need to calculate.
2) LIFO:
Jan 2 : 200 Unit *$4.38 | $876 |
Jan 23 : 500 Unit *$4.96 | $2480 |
Jan 28: 300 Unit *5.11 | $1533 |
Total | $4889 |
3) Average Moving Cost