: Emergency calls to Winter Park, Florida$$s $911$ system for the past $24$ weeks are

provided in the $$Homework $11($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 $\backslash$alpha $=0\mathrm{.}01.$ What are the forecasts for weeks $1-25?$

b$)(2$ pts$)$ Re$-$forecast each period $($i$.$e$.,$ periods $1-25)$ using $\backslash$alpha $=0\mathrm{.}6.$

c$)(2$ pts$)$ Actual calls during week $25$ were $65.$ 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 $\backslash$alpha $=0\mathrm{.}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 $\backslash$alpha $=0\mathrm{.}6$ and

$\backslash$beta $=0\mathrm{.}2.$ What is the forecast for week $25?$ Is it a better forecast compared to the one obtained in

Part $($d$)?$