Respond to each of the items using the following time series data.

Period Demand

$1104$

$2132$

$3117$

$4120$

$5104$

$6141$

$7120$

$8136$

$9109$

$10143$

$11142$

$12109$

$13113$

$14124$

$15113$

$16104$

An older version of the Microsoft Excel logo$.$ Click here for the Excel Data File

Required:

Compute all possible forecasts using a five$-$period moving average.

Note: Round all your answers to $1$ decimal place except "Absolute percent error" answers which should be rounded to $2$ decimal places.

Compute the MAD and MAPE.

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

What is the forecast demand for period $17?$

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

What is the error associated with the period $17$ forecast?

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