Can you show me how to solve this problem? In this problem, you are to test the validity of your for
Can you show me how to solve this problem?
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:
WEEK | FORECAST | ACTUAL |
1 | 770 | 895 |
2 | 845 | 995 |
3 | 945 | 1,045 |
4 | 945 | 895 |
5 | 995 | 895 |
6 | 970 | 1,050 |
a. Use the method stated in the text to compute the MAD and tracking signal for each week. (Negative values should be indicated by a minus sign. Round your “Tracking Signal” to 1 decimal place and all other answers to the nearest whole number.)
Week | Forecast | Actual | Deviation | RSFE | Absolute Deviation |
Sum of Absolute Deviation |
MAD | TS |
1 | 770 | 895 | ||||||
2 | 845 | 995 | ||||||
3 | 945 | 1,045 | ||||||
4 | 945 | 895 | ||||||
5 | 995 | 895 | ||||||
6 | 970 | 1,050 | ||||||
b. Decide whether the forecasting model you have been using is giving reasonable results.
The forecasting model is acceptable | |
The forecasting model is unacceptable |