A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 360 units. Ending inventory at January 31 totals 130 units. Beginning inventory on January 1 Units 320 Unit Cost $ 3.10 Purchase on January 9 Purchase on January 25 70 100 3.30 3.40 QS 5-7 (Algo) Perpetual: Inventory costing with weighted average LO P1 Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. Note: Round your per unit costs to 2 decimal places. Goods purchased Weighted Average - Perpetual: Cost of Goods Sold Inventory Balance # of Date # of units Cost per unit Cost per units unit sold Cost of Goods Sold # of units Cost per unit Inventory Balance January 1 320 at $ 3.10= $ 992.00 January 9 Average cost January 9 70 at $ 3.30 320 at $ 3.10 = $ 992.00 70 at $ 390 at $ 3.30= 231.00 3.13 $ 1,223.00 100 at $ 3.40 390 at $ 3.13 = $ 1,220.70 January 25 100 at $ 3.40 = 340.00 Average cost January 25 January 26 Total January 26 490 at $ 1,560.70 360 at $ 3.40 = $ 1,224.00 130 at $ 3.10 = $ 403.00 $ 1,224.00 $ 403.00
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 360 units. Ending inventory at January 31 totals 130 units. Beginning inventory on January 1 Units 320 Unit Cost $ 3.10 Purchase on January 9 Purchase on January 25 70 100 3.30 3.40 QS 5-7 (Algo) Perpetual: Inventory costing with weighted average LO P1 Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. Note: Round your per unit costs to 2 decimal places. Goods purchased Weighted Average - Perpetual: Cost of Goods Sold Inventory Balance # of Date # of units Cost per unit Cost per units unit sold Cost of Goods Sold # of units Cost per unit Inventory Balance January 1 320 at $ 3.10= $ 992.00 January 9 Average cost January 9 70 at $ 3.30 320 at $ 3.10 = $ 992.00 70 at $ 390 at $ 3.30= 231.00 3.13 $ 1,223.00 100 at $ 3.40 390 at $ 3.13 = $ 1,220.70 January 25 100 at $ 3.40 = 340.00 Average cost January 25 January 26 Total January 26 490 at $ 1,560.70 360 at $ 3.40 = $ 1,224.00 130 at $ 3.10 = $ 403.00 $ 1,224.00 $ 403.00