Aug. 1 Inventory On Hand—2,000 Units; Cost $5.70 Each.
Second sales assumed to be 7,000 units at a price of $11.40 each.
Answer:
Altira Corporation
August 2021 Ending Inventory & Cost of Goods Sold:
1. Ending Inventory = 9,000 units at $5.88 per unit = $52,920
2. Cost of goods sold =
9,600 x $5.87 = $56,352
7,000 x $5.95 = $41,650
16,600 units = $98,002
Explanation:
a) Calculations:
Units Unit Cost Total Cost
Beginning Inventory 2,000 $5.70 $11,400
Purchases 12,000 $5.90 $70,800
Weighted average cost = ($11,400 + $70,800) / 14,000 = $5.87
Sales (9,600) $12.00 $115,200
Units remaining 4,400 $5.87 $25,828
Purchases 7,200 $6.00 $43,200
Weighted average cost = ($25,828 + $43,200) / 11,600 = $5.95
Sales (7,000) $11.40 $79,800
Units remaining 4,600 $5.95 $27,370
Purchases 4,400 $5.80 $25,520
Weighted average cost = ($27,370 + $25,520) / 9,000 = $5.88
Ending Inventory 9,000 $5.88 $52,920
b) The 'Average Cost Method' or the Weighted Average Cost Method assumes that the cost of inventory is based on the average cost of the goods available for sale during the period. To compute the average cost, divide the total cost of goods available for sale by the total units available for sale.
