Emergency calls for the 911 system of Melbourne, for the past 12 weeks as shown in the
Question:
A. Compute the exponential smoothed forecasts of calls for each week. Assume the initial forecast of 50 calls in the first week and use Alpha =0.2, What is the forecast for week 13?
B. find the forecast for week 2 through 13 trend adjustment exponential smoothing model. Assuming an initial forecast of 50 calls for week 1and an initial trend of 0. Use exponential smoothing of Alpha =0.3 and Beta =0.2 what is the forecast for week 13??
C. Is this model(trend adjustment exponential smoothing) better than the earlier model (exponential smoothing forecast) and why (or why not)??
Show all your calculations on a piece of paper as well as on an excel sheet. Show the formulas used in order to see how to use it on excel because the teacher wants it on both methods. Paper and excel sheets. Make sure you show the formulas as a snap.
Weeks | Calls |
1 | 50 |
2 | 35 |
3 | 25 |
4 | 40 |
5 | 45 |
6 | 35 |
7 | 40 |
8 | 60 |
9 | 75 |
10 | 50 |
11 | 40 |
12 | 65 |