In: Accounting
Cost Flow Methods
The following three identical units of Item Alpha are purchased during April:
Item Alpha | Units | Cost | |||||
Apr. | 2 | Purchase | 1 | $76 | |||
14 | Purchase | 1 | 81 | ||||
28 | Purchase | 1 | 83 | ||||
Total | 3 | $240 | |||||
Average cost per unit | $80 | ($240 ÷ 3 units) |
Assume that one unit is sold on April 30 for $132.
Determine the gross profit for April and ending inventory on April 30 using the (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average cost methods.
Gross Profit | Ending Inventory | |
a. First-in, first-out (FIFO) | ||
b. Last-in, first-out (LIFO) | ||
c. Weighted average cost |
Correct Answer:
Working:
FIFO |
LIFO |
Weighted Average |
|
Cost of Ending Inventory |
$ 164 |
$ 157 |
$ 160 |
Gross profit |
$ 49 |
$ 42 |
$ 45 |
Working:
FIFO |
|||||||
A |
Total Units Available for sale |
3 |
$ 240 |
||||
Units Sold |
1 |
||||||
Ending Inventory Units |
2 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
1 |
$ 76.00 |
$ 76 |
||||
B |
Total Cost of Goods Sold |
1 |
units |
$ 76 |
|||
A-B |
Ending Inventory |
2 |
units |
$ 164 |
LIFO |
|||||||
A |
Total Units Available for sale |
3 |
$ 240 |
||||
Units Sold |
1 |
||||||
Ending Inventory Units |
2 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
1 |
$ 83.00 |
$ 83 |
||||
B |
Total Cost of Goods Sold |
1 |
units |
$ 83 |
|||
A-B |
Ending Inventory |
2 |
units |
$ 157 |
Weighted Average |
|||||||
A |
Total Units Available for sale |
3 |
$ 240 |
||||
Units Sold |
1 |
||||||
Ending Inventory Units |
2 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
1 |
$ 80.00 |
$ 80.00 |
$ 80 |
|||
B |
Total Cost of Goods Sold |
1 |
units |
$ 80.00 |
|||
A-B |
Ending Inventory |
2 |
units |
$ 160.00 |
End of answer.
Please give a thumbs up, it will be highly appreciated.
Thanks.