QUESTION 4 MAW Forecasting Data.xlsx Click on the above Link to open a Spreadsheet file with Weekly Data to calculate the 3 Week Weighted Moving Avg Forecasts. next calculate the Goodness Criteria, particularly MAD Based on your calculations, the MAD is 2.6.34 b. 3.30 3.46 d.4.11 2.5.37 6 Week (t) Sale (At) F(t) 1 $90.00 2 $95.00 3 $85.00 4 $100.00 85*50%+95*30%+90*20% 5 $102.00 Drop the A1 and A4 in the above Formula to get the F5 (Forecast for Week 5) $98.00 Calcualte all the remaining Forecast and then Calculate the Goodness Criteria. 7 $96.00 8 $110.00 9 $112.00 10 $115.00 11 $108.00 12 $107.00 13 $118.00 14 $120.00 15 $122.00 16 $116.00 17 $114.00 18 $127.00 19 $130.00 20 5 7