Click here for the Excel Data File

Required:

b$.$ Compute all possible forecasts using a six$-$period simple moving average model. Compute the MAD and MAPE. Note: Round your

answer to $1$ decimal place except "MAPE" answer which should be rounded to $2$ decimal places.

c$.$

d$.$ What is the forecast demand for period $11?$

Note: Round your answer to $1$ decimal place.

The forecast demand for period $11$ is

What is the error associated with the eleventh$-$period forecast?

Note: Round your answer to $1$ decimal place.