PLEASE MAKE SURE PART C MSE AND CONTROL LIMITS ARE CORRECT

Problem 3-22 (Algo) 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 1 2 3 4 5 6 7 8 8 9 10 Sales 840 840 800 795 765 845 800 860 795 835 Forecast 1 1 820 815 805 785 770 785 800 810 815 855 Forecast 2 765 800 855 805 795 806 795 785 840 835 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Forecast 1 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. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limits 0+