Using simple moving averages and the following time series data, respond to each of the items.

Period Demand

$172$

$260$

$327$

$452$

$526$

$646$

$752$

$828$

$953$

$1050$

$1157$

$1287$

$1322$

$1456$

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

Required:

a$.$ Compute all possible forecasts using a four$-$period & eight$-$period simple moving average model.

Note: Round your answers to $2$ decimal places.

b$-1.$ Compute the MAD for each forecast.

Note: Round your answers to $2$ decimal places.

b$-2.$ Compute the MAPE for each forecast.

Note: Round your answers to $2$ decimal places.

c$-1.$ Based on the MAD, which forecast is better?

c$-2.$ Based on the MAPE, which forecast is better?

c$-3.$ What is your conclusion regarding the best forecasting model?

Pre