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

Period

$12$

$3$ GA ON $89$ BEN $1314$

Demand

$726027522646$

$52$

$2853505787$

$22$

$56$

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.

$4-$Period

Absolute Error

$8-$Period

Absolute Error

$4-$Period

Absolute

Percent Error

$8-$Period

Absolute

Percent Error

Period

Demand

$4-$Period SMA

$8-$Period SMA

$72$

$60$

$27$

$52$

$26$

$46$

$2$

$3$

t

$5$

$$

OO

olo

alQo

lo

olo

$\%$

$6$

$7$

$52$

$28$

$53$

$50$

$8$

$9$

$\%$

$\%$

$\%$

$\%$

$\%$

$10$

$11$

$12$

$13$

$57$

$87$

$22$

$56$

oo

O

$14$

$15$

$\%$

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

Note: Round your answers to $2$ decimal places

$4-$Period MAD

$8-$Period MAD

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

Note: Round your answers to $2$ decimal places

$4-$Period MAPE

$8-$Period MAPE

$\%$o

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

Based on the MAD, which forecast is better?

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

Based on the MAPE, which forecast is better?

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

What is your conclusion regarding the best forecasting model?