MGMT 3207 Operations Management Problem

Two independent methods of forecasting based on judgment and experience 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 835 815 770
2 850 820 800
3 825 795 820
4 795 810 825
5 775 795 810
6 835 765 781
7 820 775 780
8 845 820 825
9 815 835 805
10 820 800 840
________________________________________
    
a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.)
    
          MSE         MAD
  Forecast 1 
  Forecast 2 
 ________________________________________
b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.)
  MAPE F1   %

  MAPE F2   %

________________________________________
c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s control limits. (Round your answers to 2 decimal places.)
  MSE   

  MAD   

  Tracking signal   

  Control limits 0 ±    

________________________________________