Page 180 Problem 5-30 Use the data from this problem to perform the following: (similarly set up the problem as in class, your time periods will all be in one column, and your actual forecast all in one column, then first forecast column, then error column, etc. A) Using a moving average of 6 time periods, forecast the emergency calls for week 25. B) Using a moving average of 9 time periods, forecast the emergency calls for week 25. C) Assuming an initial forecast of 50 calls in week 1, use exponential smoothing to forecast calls for week 25. Use alpha = .4. D) Calculate the MAD for each forecasting technique and determine which is the most accurate? Why? Forecasting Template.xlsx Q: ' ida's 911 sys- x* 5-30 Emergency calls to Winter Park, Florida's tem for the past 24 weeks arc as follows: EVARALLLLAL RAW S v | oew o =5 WEEK CALLS WEEK CALLS (a) Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week, and use a = 0.1. What is the forecast for week 257 (b) Reforecast each period using @ = 0.6. (c) Actual calls during week 25 were 85. Which g At { : . ~ smoothing constant provides a superior forecast? rras sl B