not sure what im missing can anyone help?
March Sunday Monday Tuesday Wednesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 Purchase 100 units $50 each 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 23 20 19 21 22 March Sunday Monday Tuesday Wednesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 2 3 4 7 Keep Only Exclude 00 9 Purchase 400 units $55 each 10 11 12 13 14 15 16 17 18 19 20 21 22 23 March Wednesday Sunday Monday Tuesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 1 N 3 4 5 6 7 8 9 Sales 420 units $85 each 10 11 12 13 14 15 16 1 2 3 4 5 6 7 00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Keep Only Exclude Purchase 120 units $60 each 24 25 27 28 29 30 20 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Keep Only Exclude Purchase 200 units $62 each 31 10 12 11 13 14 16 15 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Keep Only Exclude Sales 160 units $95 each 31 per unit Sold per unit 1550 00 S Sold 5,000.00 100 1 100 350.00 March 1 March 100 @ 400 $50.00 $ 55.00 S 5.000.00 22 000.00 $ 27,000.00 4006 5500 TO 100 550.00 $ 55.00 $ 50.00 $ 55.00 March = s 5.000.00 17.600.00 $ 22.600.00 80 4.400.00 4.400.00 s March 18 120 560.00 B0 $ 50.00 5 55.00 $50.00 1200 4,400.00 7.200.00 $ 11,500.00 March 25 200 $ 62.00 800 120 2006 550.00 $ 55.00 $ 80.00 $ 62.00 4.400.00 7,200.00 12 400,00 $ 24.000.00 March 29 BO 80 $50.00 355.00 $ 60.00 $ 62.00 4,400.00 4,800.00 0.00 $ 9,200.00 $ 31,800.00 $50.00 $ 55.00 $ 60.00 $ 62.00 40 200 2.400.00 12.400.00 $ 14,800.00 S 14,800.00 Totais Return to question units 100 sold March init Sold 50.00 100 $ unit 50.00 March 5 s 400 Q5 55.00 s 100 la 400 s 10.00 55.00 S 5.000,00 5.000.00 22.000.00 27.000.00 March 15 50.00 55.00 s 400 4,000.00 D S $ 1.000.00 22.000.00 $ 23,000.00 50.00 55.00 March 18 120 s 4.000.00 50.00 30 s $ 4.000.00 eos 50,00 55.00 60.00 5 5 120 March 25 5 7.200,00 11 200.00 200 s 62.00 80 5 5 4,000.00 $ 120 50.00 55.00 60.00 6200 O is 200 ml Is 7.200,00 12,400.00 23,500.00 March 20 s $ $ 0.00 80 > is 4,000.00 w Bebe = @ $ 5 50.00 55.00 50.00 6200 0.00 0.00 9.920.00 $ 9,920.00 160 5- 50.00 55.00 60.00 $ 62.00 1200 40 0 7,200.00 2.480.00 13,680.00 Tocals s $ 32.920.00 $ 13.080.00 Required: Required 2 Required olo Compute the cost assigned to ending inventory using Weighted Average. (Round your average cost per unit to 2 decimal places) Weighted Average Perpetual Goods Purchased Cost of Goods Sold Inventory Balance Data of Cost per of units Cost per Cost of Goods Cost per sold unit of units Sold unit unit Inventory Balance March 100 50.00 100 $ 50.00 $ 5.000.00 March 5 400 $ 55.00 100 $ 50.00 $ 5,000.00 400 a 5 S500 22,000.00 Average 500 5 54.00 - $ 27,000.00 March 420 3 54.00 $22.680.00 80 $ 54,00 $ 4.320.00 March 18 120 80 $ 54.00 $ 4.320.00 1200 $ 60.00 7,200.00 Average 200 $ 11,520.00 March 25 2001 52.00 200 200@ $ 62 12.400,00 400 @s 59.80 $ 12.400.00 March 20 160 59.80 9.568.00 240 $ 59.80 $ 14,352,00 Totals $32.24800
