PLEASE ANSWER QUESTION IN EXCEL WITH THE FORMULAS

Question 3 (14 pts): Emergency calls to Winter Park, Florida's 911 system for the past 24 weeks are provided in the Homework 9 (Chapter 5) Data.xlsx Excel file. a) (2 pts) Compute the exponential smoothing forecast of calls for each week. Assume an initial forecast of 50 calls in the first week, and use a=0.1. What are the forecasts for weeks 1-25? b) (2 pts) Re-forecast each period (i.e., periods 1-25) using a = 0.6. c) (2 pts) Actual calls during week 25 were 85. Which smoothing constant provides a better forecast? Why? d) (4 pts) If the initial forecast of the first week is 60, what would be the forecast of week 25 using exponential smoothing with a = 0.6? Is it a better forecast if the actual calls during week 25 were 65? e) (4 pts) Compute the exponential smoothing with trend forecast of calls for each week. Assume an initial smoothed forecast (Ft) of 50 and an initial smoothed trend (Tt) of 0, and use a = 0.6 and ISOM 201 Homework 9 (Chapter 5) = B = 0.2. What is the forecast for week 25? Is it a better forecast compared to the one obtained in Part (d)? F11 fx A B C D E 1 Q3: Emergency calls 2 3 Week 4 1 5 2 Calls 50 35 25 40 45 6 3 7 4 8 5 LO 96 35 20 10 7 11 8 30 35 12 9 13 10 14 11 15 12 16 13 17 14 18 15 20 15 40 55 35 25 19 16 55 20 17 21 18 22 19 23 20 24 21 25 22 26 23 27 24 28 25 55 40 35 60 75 50 40 65