Problem $12-2($Algo$)$

Given the series of demand data below

Period: $12345678910$

Demand: $43365239194137422943$

Click here for the Excel Data File

a$.$ Calculate the forecasts for periods $7$ through $11$ using moving average models with n $=2,$ n $=4,$ and n $=6.$

b$-1.$ Calculate the bias and MAD for each set of forecasts.

b$-2.$ Which moving average model is best with respect to MAD?