Given the series of demand data below

$\backslash$table$[[$Period:$,1,2,3,4,5,6,7,8,9,10],[$Demand:$,36,32,50,46,18,46,36,43,26,39]]$

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?

Complete this question by entering your answers in the tabs below.

ReqA

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

Note: Round your intermediate calculations and final answers to $1$ decimal place.

$\backslash$table$[[$Week$,n=2,n=4,n=6$

Given the series of demand data below

$\backslash$table$[[$Period:$,1,2,3,4,5,6,7,8,9,10],[$Demand:$,36,32,50,46,18,46,36,43,,]]$

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?

Complete this question by entering your answers in the tabs below.

ReqAReqB$1$ Req B$2$

Calculate the bias and MAD for each set of forecasts.

Note: Negative answers should be indicated by a minus sign. Round your intermediate calculations and final answers to $1$ decimal place.

$\backslash$table$[[,$Moving Average Forecast

Given the series of demand data below

Period:

Demand:

$1$

$36$

$2$

$32$

$3$

$50$

$4$

$46$

$5$

$18$

$6$

$46$

$7$

$36$

$8$

$43$

$9$

$26$

$10$

$39$

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?

Complete this question by entering your answers in the tabs below.

ReC A

Req B$1$

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

Note: Round your intermediate calculations and final answers to $1$ decimal place.

$\backslash$table$[[$Week$,n=2,n=4,n=6],[n=2,n=4,n=6$