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,1222,],[2,1211,],[3,1212,],[4,1231,1215],[5,1307,1218],[6,1299,1250],[7,1280,1279]]$

Forecast period $8$ using the moving average technique: $n=3$

Answer