Forecasting Assignment $$ use Excel to graph and calculate forecasts

Problem #$1$

Over the past three months the demand for product XYZ has been $255,219$ and $231$ units. Calculate the three$-$month moving average forecast for month $4.$

If the actual demand in month $4$ is $228,$ what will be the forecast for month $5?$

Month

Demand

Forecast

$1$

$255$

$2$

$219$

$3$

$231$