need help with weight average

LIUMTA Lumpally uses the moving weighted average method for inventory costing. equired: he following incomplete inventory sheet regarding Product W506 is available for the month of March 2017. Complete the heet. (Use the value of the ending inventory as your base number and adjust the COGS $ amount to the required amo ake the Total Goods Available for Sale to the total of the Value of the ending inventory and the COGS total. Negative hould be indicated with minus sign. Round your intermediate and final answers to 2 decimal places.) Purchases/Transportation-In! (PurchaseReturns Discounts) Cost of Goods Sold/{Returns to Inventory) Balance in Inventory Date Units CostUnit Total $ Units Cost'Unit Total S Units Total $ Avg Cost Unit 95.00 var. 153 Breught Forward 28 $ 5.035.00 53 $ S 5.035 00 96.00 2.688.00 95.35 $ 7.723.35 95.35 3.718.65 2. 3 4 7 95.355 (19) 95.35 95.35 5.846.35 (1.811.65) 61 4.576.80 13 7 95.35 1.239.55 96.00 3.168.00 2 co 36 95.75 $ 10.891.00 104 Goods Sold Totals 114| Goods Available for Sale 10 Ending Inventory LIUMTA Lumpally uses the moving weighted average method for inventory costing. equired: he following incomplete inventory sheet regarding Product W506 is available for the month of March 2017. Complete the heet. (Use the value of the ending inventory as your base number and adjust the COGS $ amount to the required amo ake the Total Goods Available for Sale to the total of the Value of the ending inventory and the COGS total. Negative hould be indicated with minus sign. Round your intermediate and final answers to 2 decimal places.) Purchases/Transportation-In! (PurchaseReturns Discounts) Cost of Goods Sold/{Returns to Inventory) Balance in Inventory Date Units CostUnit Total $ Units Cost'Unit Total S Units Total $ Avg Cost Unit 95.00 var. 153 Breught Forward 28 $ 5.035.00 53 $ S 5.035 00 96.00 2.688.00 95.35 $ 7.723.35 95.35 3.718.65 2. 3 4 7 95.355 (19) 95.35 95.35 5.846.35 (1.811.65) 61 4.576.80 13 7 95.35 1.239.55 96.00 3.168.00 2 co 36 95.75 $ 10.891.00 104 Goods Sold Totals 114| Goods Available for Sale 10 Ending Inventory