Using simple moving averages and the following time serles data, respond to each of the Items.

Click here for the Excel Data File

Required:

a$.$ Compute all possible forecasts using a four$-$perlod & elght$-$perlod 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?

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?