$(3$ points$)$ Step $1$ Use Excel's Data Analysis$->$Regression on first two$-$week's $($i$.$e$.,$ periods $1-14)$ data to create the level and trend estimates in period $0$

In doing so$,$ under Output options of the Regression window, select Output Range and select A$33$

This will give the regression summary under the data table $($see below the data table$)$

Use the regression result to populate cells E$2$ and F$2($blue cells in row $2)$

Then, explain which values of the regression results you used

as level and trend estimates for period $0$ and why. $2-4$ sentences would be sufficient.

$(4$ points$)$ Step $2$ Calculate forecasts and forecasting errors. To do so:

Initially set alpha $=0\mathrm{.}5$ and beta $*=*0\mathrm{.}5$ in cells $K2$ and $L2$

After that, calculate the forecast made in period ofor periad $1$;

then assume that demand for period $1$ is revealed and calculate the updated level and trend estimates for period $1$

and then calculate the forecast made in period $1$ for period $2$; and so on

until you calculate the forecast made in period $20$ for period $21$ and you calculated the level and trend estimates for period $21$

Put the formulas for level and trend estimates in columns E $($green cells$)$ and F $($green cells$),$ respectively.

and formulas for forecast calculations in column $G($yellowish cells$)$

Once one$-$step$-$ahead forecasts are calculated for periods $1-21,$ calculate the forecast errors and squared foreckst enrors

in columns $H($pink cells$)$ and I $($gray cells$)$ respectively

Finally, write the formula for sum of squared errors in cell $124($orange cell$)$

$[3$ points$]$ step $3$ Determine the optimal alphs and beta" values that will minimse the sum of squared errors.$(3$ points$)$ Step $3$ Determine the optimal alpha and beta$*$ values that will minimize the sum of squared errors.

To do so$,$ go to Solver and setup the optimization problem

Do not forget to add the constraints that the parameters values should be $1$

And select GRG Nonlinear from the solving method

Report how much the sum of the squared errors changed below

$(2$ points$)$ Step $4$ After getting the optimal alpha and beta" values, calculate the forecasts made in period $21$

for periods $22-28$ in cells G$24$:$30($blue cells$).$ To do so$,$ write the formulas. That is$,$

do not type in just values

$(1$ point$)$ Step $5$ is the method used biased? Explain why briefly.

Shaw your calculations, Your can have extra calculations on columns $K$ and L$.2-4$ sentences should be sufficient

$(1$ point$)$ Step $6$ Discuss how can you improve this forecasting approach? What could you make differently for better accuracy, if possible?

Discuss the coverall process and any improvement suggestions. $3-6$ sentences would be sufficient.