Question

calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, eg. 5.25 and final answers to decimal places, eg. 5,250.) Cost of Goods Sold Units Cost Total Date Apr-01 Purchases Units Cost Total Beginning Inventory 27 $13 $351 Apr-15 Apr-15 59 $15 $885 Apr-20 30 $ Apr 28 50 Apr-23 $800 $16

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Perpetual Weighted Average
Date	Cost of Goods available for sale	Cost of Goods sold	Inventory Balance
No. of Units	Cost per unit	Amount	No. of Units	Cost per unit	Cost of Goods sold	No. of Units	Cost per unit	Inventory Balance
Apr 1	27.00	13.00	351.00				27.00	13.00	351.00
Apr 15	59.00	15.00	885.00				27.00	13.00	351.00
							59.00	15.00	885.00
							86.00	14.37	1,236.00	Use this for weighted average
Apr 20				30.00	14.37	431.00	56.00	14.37	805.00
Apr 23	50.00	16.00	800.00				56.00	14.37	805.00
							50.00	16.00	800.00
							106.00	15.14	1,605.00	Use this for weighted average
Apr 28				65.00	15.14	984.00	41.00	15.14	621.00
Ending Inventory	136.00		2,036.00	95.00		1,415.00	41.00		621.00