a$.(4$ Points$)$ In column C $($starting in the appropriate cell$),$ write a formula to forecast

demand through October using an ES model with smoothing constant alpha given in cell

D$1.$ Be sure to reference the cells containing the weights in the formula.

b$.(3$ Points$)$ In cell H$5,$ write a formula to forecast demand for November using the ES

model you constructed.

c$.(4$ Points$)$ In column D$,$ under the label $$ES Error,$$ write a formula in the appropriate

cells calculating the error terms necessary to calculate the MAPE for the ES model. Do

$3$

not construct a column of errors, then another column of absolute$,$ squared, or absolute

relative errors. Construct only one set of errors using the appropriate formula to make

the errors absolute$,$ squared, or absolute relative $($whichever is appropriate for MAPE$).$