Assignment

Saved

Help

Save & Exit

Sub

actual demands that occurred:

Check my wor

$\backslash$table$[[$WEEK$,$FORECAST,ACTUAL$],[1,810,905],[2,855,1,005],[3,950,1,055],[4,950,905],[5,1,010,905],[6,980,1,000]]$

a$.$ Use the method stated in the text to compute the MAD and tracking signal for each week.

Note: Negative values should be indicated by a minus sign. Round your "Tracking Signal" to $2$ decimal place and all other answers to the nearest whole number.

$\backslash$table$[[$Week$,$Forecast,Actual,Deviation,RSFE,$\backslash$table$[[$Absolute$],[$Deviation$]],\backslash$table$[[$Sum of$],[$Absolute$],[$Deviation$]],$MAD,TS$],[1,810,905,95,95,95,95,95,1\mathrm{.}00],[2,855,1,005,150,,150,,,],[3,950,1,055,105,,105,,,],[4,950,905,-45,,45,,,],[5,1,010,905,-105,,105,,,],[6,980,1,000,20,,20,,,]]$

b$.$ Decide whether the forecasting model you have been using is giving reasonable results.

The forecasting model is unacceptable.

Prev.

$8$ of $16$

Next