Question: Emergency calls for the 911 system of Melbourne, for the past 12 weeks as shown in the following table. A. Compute the exponential smoothed forecasts

Emergency calls for the 911 system of Melbourne, for the past 12 weeks as shown in the following table. 


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 
150
235
325
440
545
635
740
860
975
1050
1140
1265



Step by Step Solution

3.35 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!