QUESTION 10 MA Forecasting Data.xlsx Click on the above Link to open a Spreadsheet with Sales Data for 20 Weeks. First Develop a 3 Week Moving Average Forecast and then calculate the Mean Absolute Deviation (MAD). Your Calculated MAD is = a. 4.65 b. 3.72 c. 7.44 d. 3.91 e. 8.73

WEEKLY SALES REPORT OF A BUSINESS FOR CALCULATING 3 WEEK MOVING AVG FORECASts Week (t) Sale (At) F(t) Example of Calculation 1 $90.00 2 $95.00 3 $85.00 4 $100.00 (90+95+85)/3 = $90.00 5 $102.00 For F5, Drop the A1 and repalce it with A4 and 6 $98.00 Continue Calculating the remaining Forecasts. 7 $96.00 Next Calcualte the Goodness Criteria. 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