Two independent methods of forecasting based on judgment andexperience have been prepared each month for the past 10 months.The forecasts and actual sales are as follows:
Month | Sales | Forecast 1 | Forecast 2 |
1 | 830 | 790 | 760 |
2 | 845 | 800 | 795 |
3 | 795 | 805 | 820 |
4 | 825 | 815 | 830 |
5 | 770 | 780 | 795 |
6 | 835 | 790 | 796 |
7 | 785 | 765 | 800 |
8 | 835 | 785 | 835 |
9 | 805 | 800 | 810 |
10 | 855 | 820 | 795 |
c. Prepare a naive forecast for periods 2through 11 using the given sales data. Compute each of thefollowing; (1) MSE, (2) MAD, (3) tracking signal at month 10, and(4) 2s control limits. (Round your answers to 2decimal places.)
| |
MSE | |
MAD | |
Tracking signal | |
Control limits | 0 ± |
|