PLEASE ANSWER QUESTION 20-22 !

Prepare a spreadsheet model for the ferry passenger data in Table 17.6, and recalculate the forecasts using an a of 0.3, a B of 0.1, and a of 0.2. Has this change in the smoothing constants improved the MAD? TABLE 17.6 Exponential Smoothing with Seasonal and Trend Adjustments: Excel Spreadsheet Illustration Ferry Passengers Taken to a Resort Island (alpha = 0.2, Meta = 0.2, gamma = 0,3) B D E F G H 1 2 alpha beta gamma 0.2 0.2 0.3 3 Index Forecast 5 Period Actual A t Smoothed Trend 5 T 2009 Error A fil 6 7 1 8 2 3 WN 9 10 11 12 13 14 19 00 Olol January February March April May June July August September October November December January February March April May June July August September October November December 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 1,651 1,305 1,617 1,721 2,015 2,297 2,606 2,687 2,292 1,981 1,696 1,794 1,806 1,731 1.733 1,904 2,036 2.560 2.679 2.821 2,359 2,160 1,B02 1,853 486 34 0.837 0.662 0.820 0.873 1.022 1.165 1.322 1.363 1.162 1.005 0.860 0.910 0.876 0.719 0.824 0.878 1.000 1.166 1.293 1.340 1.138 1.000 0.850 0.894 1,794.00 1,866.74 2,027.99 2,080.19 2.136.79 2,146.07 2.188.39 2.188.42 2,190.61 2.179.61 2,188.66 2.183.54 2.164.10 0.00 14.55 43.89 45.55 47.76 40.07 40.52 32.42 26.37 18.90 16.93 12.52 6.13 48 197 13 1,245 1,699 1,856 2,233 2,547 2,947 3,027 2.576 2.210 1,897 1.998 268 206 217 50 95 145 MAD 160 Problem 14.10 Use your results for homework problem 14.10 to answer the following questions. By the way, I do not care if you used a spreadsheet or hand calculations to work the problem. Question 20 (5 points) Listen What is the revised forecast (F) for December? Do not round your forecast to a whole number Your Answer: Answer Question 21 (5 points) Listen What is the new MAD? Your Answer: Answer Question 22 (5 points) Listen The MAD has improved. True False