Bramble Lane Outfitters Ltd. (perpetual, moving weighted average), trail shoes, March: 1 Mar opening 40 pairs @ 52; 8 Mar purchase 60 @ 55; 12 Mar sale of 70; 20 Mar purchase 50 @ $58; 27 Mar sale of 45. Carry unit costs to four decimals; round only the reported figures to the cent.
Bramble Lane Outfitters Ltd. (perpetual, moving weighted average), trail shoes, March: 1 Mar opening 40 pairs @ 52; 8 Mar purchase 60 @ 55; 12 Mar sale of 70; 20 Mar purchase 50 @ $58; 27 Mar sale of 45. Carry unit costs to four decimals; round only the reported figures to the cent.
Answer
Average unit cost after 8 March → 53.8 · Cost of goods sold, 12 March → 3766 · Average unit cost after 20 March → 56.425 · Ending inventory, 31 March → 1974.88
Cells - Average unit cost after 8 March · ±0.005 - Cost of goods sold, 12 March · ±0.5 - Average unit cost after 20 March · ±0.005 - Ending inventory, 31 March · ±0.5 After 8 Mar: (2,080 + 3,300) ÷ 100 = **53.80**. 12 Mar: 70 × 53.80 = **3,766**, leaving 30 units at 1,614. After 20 Mar: (1,614 + 2,900) ÷ 80 = **56.425**. 27 Mar: 45 × 56.425 = 2,539.125; ending = 4,514 − 2,539.125 = 1,974.875 → **1,974.88**. Excel at each purchase: `=SUMPRODUCT(units, costs)/SUM(units)`.
Dauderis & Annand §6.1 (the rounding warning), §6.2; Lyryx Intermediate FA Vol 1 §7.3.2; Hermanson Vol 1 ch 7 (weighted average under both systems) (concept map H10–H12)