Problem $3-20($Algo$)$

In this problem, you are to test the validity of your forecasting model. Here are the forecasts for a model you have been using and the actual demands that occurred:

$\backslash$table$[[$WEEK$,$FORECAST,ACTUAL$],[1,850,925],[2,875,1,025],[3,975,1,075],[4,975,925],[5,1,025,925],[6,1,000,1,020]]$

a$.$ Use the method stated in the text to compute the MAD and tracking signal for each week. Note: Negatlve values should be Indlcated by a minus sign. Round your "Tracking Signal" to $2$ declmal 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,850,925,,,,,,],[2,875,1,025,,,,,,],[3,975,1,075,,,,,,],[4,975,925,,,,,,],[5,1,025,925,,,,,,],[6,1,000,1,020,,,,,,]]$

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

The forecasting model is unacceptable.

The forecasting model is acceptable.