a$.$After obtaining initial estimates for level, trend and seasonal factors, forecast demand for year $5$ using Winter$$s model with $\backslash$alpha $=0\mathrm{.}05,\backslash$beta $=0\mathrm{.}10$ and $\backslash$gamma $=0\mathrm{.}15$ Consider the given dataset:

a$.$ After obtaining initial estimates for level, trend and seasonal factors, forecast demand for year $5$ using

Winter's model with $=0\mathrm{.}05,=0\mathrm{.}10$ and $=0\mathrm{.}15$

b$.$ Compute MAD, MSE and MAPE, bias and Tracking Signal for the forecast.

c$.$ Can you find values of $,,$ and $$ that result in a lower MAD? How? Show your calculations.

NOTE: You should use MS Excel in order to answer these questions. Submit your excel working file!b$.$Compute MAD, MSE and MAPE, bias and Tracking Signal for the forecast. c$.$Can you find values of $\backslash$alpha $,\backslash$beta $,$ and $\backslash$gamma that result in a lower MAD?How? Show your calculations. NOTE: You should use MS Excel in order to answer thesequestions. Submit your excel working file!