Question: 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

Problem 3-22 (Algo) Two independent methods of
Problem 3-22 (Algo) Two independent methods of
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: Sales 840 Month 1 2 3 4 5 6 7 8 9 10 840 840 835 765 830 795 850 845 785 Forecast 1 830 800 780 825 765 795 780 785 820 810 Forecast 2 785 800 850 815 790 786 815 785 835 820 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.) 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.) 50 MAPE F1 MAPE F2 % c. Prepare a noive forecast for periods 2 through 11 using the given sates dato. Compute each of the following: (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s controllimits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) MSE MAD Tracking in Control limits 0

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!