$16$

Problem $3-18($Algo$)$

$7$ points

$01$:$39$:$22$

eBook

References

A particular forecasting model was used to forecast a six$-$month period. Here are the forecasts and actual demands that resulted:

$\backslash$table$[[,$FORECAST,ACTUAL$],[$April$,260,209],[$May$,335,236],[$June$,410,310],[$July$,360,291],[$August$,385,315],[$September$,460,394]]$

a$.$ Find the tracking signal for each month.

Note: Negative values should be indicated by a minus sign. Round your answers to $2$ decimal places.

$\backslash$table$[[$Month$,$Tracking Signal$],[$April$,],[$May$,],[$June$,0\mathrm{.}00],[$July$,4\mathrm{.}00],[$August$,0\mathrm{.}00],[$September$,6\mathrm{.}00]]$

b$.$ Is the model being used giving acceptable answers?