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

The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred:
\table[[FORECAST,ACTUAL],[1,480,1,530],[1,380,1,480],[1,680,1,580],[1,730,1,630],[1,780,1,680]]
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 decimal places and all other answers to the nearest whole number.
\table[[Period,Forecast,Actual,Deviation,RSFE,\table[[Absolute],[Deviation]],\table[[Sum of],[Absolute],[Deviation]],MAD,TS],[1,1,480,1,530,-50,-50,50,50,50.00,-1.00],[2,1,380,1,480,-100,-150,100,150,75.00,-2.00],[3,1,680,1,580,100,-50,100,250,83.33,-0.60],[4,1,730,1,630,100,50,100,350,87.50,0.57],[5,1,780,1,680,100,150,100,450,90.00,1.67]]Deviation, RSFE and TS are wrong
 The following table shows predicted product demand using your particular forecasting

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!