Abilene Cracker Distribution Company

$($

ACDC

$)$

$$is looking to bring on an additional forecasting analyst intern for the coming year. Your potential manager provided you the following worksheet to complete:

$($

Your potential manager also provided helpful equations at the bottom of the worksheet

$($

i

$)$

$)$

$$For all questions, show your work.

Part A: Stationary Forecasting Methods

Using the following data:

$\backslash$

table

$[$

$[$

Period

$,$

Demand,Forecast

$]$

$,$

$[$

$1$

$,$

$1$

$2$

$2$

$2$

$,$

$]$

$,$

$[$

$2$

$,$

$1$

$2$

$1$

$1$

$,$

$]$

$,$

$[$

$3$

$,$

$1$

$2$

$1$

$2$

$,$

$]$

$,$

$[$

$4$

$,$

$1$

$2$

$3$

$1$

$,$

$1$

$2$

$1$

$5$

$]$

$,$

$[$

$5$

$,$

$1$

$3$

$0$

$7$

$,$

$1$

$2$

$1$

$8$

$]$

$,$

$[$

$6$

$,$

$1$

$2$

$9$

$9$

$,$

$1$

$2$

$5$

$0$

$]$

$,$

$[$

$7$

$,$

$1$

$2$

$8$

$0$

$,$

$1$

$2$

$7$

$9$

$]$

$]$

Forecast period

$8$

$$using the moving average technique:

$$

$=$

$3$

Answer