Monthly attendance at financial planning seminars for the past 24 months, and forecasts and errors for...

Transcribed Image Text:

Monthly attendance at financial planning seminars for the past 24 months, and forecasts and errors for those months, are shown in the following table. Determine if the forecast is working by computing a tracking signal, beginning with month 10, updating MAD with exponential smoothing. Use an alpha value of 0.2. (Round all your calculations to three decimal points.) Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Attend 42 46 50 51 46 42 34 29 22 20 24 30 37 48 49 41 36 34 25 6 3 0 9 13 Forecast 42 47 55 51 48 39 28 38 22 18 24 40 36 53 50 36 38 36 25 11 -1 10 14 18 A-F 0 -1 -5 0 -2 3 6 -9 0 2 0 -10 1 -5 -1 5 -2 -2 0 -5 4 -10 -5 -5 lel 0 1 5 0 2 3 6 9 0 2 0 10 1 5 1 5 2 2 0 5 4 10 5 5 Cumulative lel 0 1 6 6 8 11 17 26 26 28 MAD 2.800 2.240 Cumulative Error Tracking Signal Monthly attendance at financial planning seminars for the past 24 months, and forecasts and errors for those months, are shown in the following table. Determine if the forecast is working by computing a tracking signal, beginning with month 10, updating MAD with exponential smoothing. Use an alpha value of 0.2. (Round all your calculations to three decimal points.) Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Attend 42 46 50 51 46 42 34 29 22 20 24 30 37 48 49 41 36 34 25 6 3 0 9 13 Forecast 42 47 55 51 48 39 28 38 22 18 24 40 36 53 50 36 38 36 25 11 -1 10 14 18 A-F 0 -1 -5 0 -2 3 6 -9 0 2 0 -10 1 -5 -1 5 -2 -2 0 -5 4 -10 -5 -5 lel 0 1 5 0 2 3 6 9 0 2 0 10 1 5 1 5 2 2 0 5 4 10 5 5 Cumulative lel 0 1 6 6 8 11 17 26 26 28 MAD 2.800 2.240 Cumulative Error Tracking Signal