$18$

Problem $3-21($Algo$)$

$7$

points

$01$:$35$:$33$

Skipped

eBook

Print

$$

References

The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred:

$\backslash$table$[[$FORECAST$,$ACTUAL$],[1,498,1,548],[1,395,1,495],[1,698,1,598],[1,745,1,648],[1,795,1,698]]$

Compute the tracking signal using the mean absolute deviation and running sum of forecast errors.

Note: Negative values should be indicated by a minus sign. Round your "Mean Absolute Deviation", "Tracking Signal" to $2$ dec places and all other answers to the nearest whole number.

$\backslash$table$[[$Period$,$Forecast,Actual,Deviation,RSFE,$\backslash$table$[[$Absolute$],[$Deviation$]],\backslash$table$[[$Sum of$],[$Absolute$],[$Deviation$]],$MAD,TS$],[1,1,498,1,548,,,,,,],[2,1,395,1,495,,,,,,],[3,1,698,1,598,,,,,,],[4,1,745,1,648,,,,,,],[5,1,795,1,698,,,,,,]]$