Additional Information:
June.1 Beginning merchandise inventory 17 units at $15each
12 Purchase 5 units at $19each
20 Sale 14 units at $37each
24 Purchase 11 units at $23each
29 Sale 13 units at $37each
Answer:
a) Ending Merchandise Inventory and Cost of Goods Sold under FIFO:
Beginning Inventory, 17 units at $15each $255
Plus Purchases:
June 12 Purchase, 5 units at $19each 95
June 24 Purchase, 11 units at $23each 253
Cost of Goods Available for Sale $603
Less Ending Inventory 138
Cost of Goods Sold $465
b) Ending Merchandise Inventory and Cost of Goods Sold under LIFO:
Beginning Inventory, 17 units at $15each $255
Plus Purchases:
June 12 Purchase, 5 units at $19each 95
June 24 Purchase, 11 units at $23each 253
Cost of Goods Available for Sale $603
Less Ending Inventory 90
Cost of Goods Sold $513
c) Ending Merchandise Inventory and Cost of Goods Sold under Weighted Average:
Beginning Inventory, 17 units at $15each $255
Plus Purchases:
June 12 Purchase, 5 units at $19each 95
June 24 Purchase, 11 units at $23each 253
Cost of Goods Available for Sale $603
Less Ending Inventory 109.62
Cost of Goods Sold $493.38
2. Ending Inventory = 6 units (17 units + 5 - 14 + 11 - 13)
FIFO LIFO Weighted Average
Ending Inventory value = $23 *6 = $138; $15 *6 = $90; $18.27 *6 = $109.62
Weighted Average = Cost of Goods Available for Sale / Quantity Available for Sale = $603/33 = $18.27 per unit
Explanation:
FIFO: First In, First Out: This is a method of costing inventory which assumes that goods remaining in stock are those that were brought in last. This means that goods are sold out according to the time they are bought, with earlier bought goods being sold before later bought goods.
LIFO: Last In, First Out: This costing method assumes that goods that are sold are those that were bought later leaving those bought earlier to remain in stock. The entity using this method exhausts the last quantity bought before selling the earlier quantities.
Weighted Average: This is another technique which weighs the averages of the cost of inventory before determining the value of inventory. The weighted average method divides the cost of the goods available for sale by the number of those units still on the shelf. The result is the weighted average cost per unit, which can be used to assign a cost to both the ending inventory and the cost of goods sold.
