In: Accounting
Ehlo Company is a multiproduct firm. Presented below is all information concerning one of its products, the Hawkeye.
Date Transaction Quantity Price/Cost
1/1 Beginning inventory 1,000 $12
2/4 Purchase 1,000 16
2/20 Sale 1,500 30
4/2 Purchase 1,000 20
Compute the ending inventory, assuming Ehlo uses:
(a) Perpetual system, FIFO cost flow.
(b) Periodic system, LIFO cost flow.
(c) Perpetual system, LIFO cost flow.
(d) Periodic system, weighted-average cost flow.
(e) Perpetual system, moving-average cost flow.
Closing Inventory using:
(a) Perpetual system, FIFO cost flow = $28000
(b) Periodic system, LIFO cost flow = $20000
(c) Perpetual system, LIFO cost flow = $26000
(d) Periodic system, weighted-average cost flow = $24000
(e) Perpetual system, moving-average cost flow = $27000
Working Note:
(a)
(b) Closing inventory using Periodic system, LIFO cost flow = 500 unit @ $16 each + 1000 unit @ $12 each = $20000
(c)
(d) Closing inventory using Periodic system, weighted-average cost flow = (3000-1500)*{($12000+$16000+$20000)/(1000+1000+1000)} = 1500 units @$16 each = $24000
(e)