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

Two independent methods of forecasting based on
Two independent methods of forecasting based on
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: Forecast 1 830 820 805 795 Month 1 2 3 4 5 6 7 9 10 Sales 835 845 840 820 775 830 785 835 815 835 810 810 795 830 Forecast 2 815 830 790 849 810 776 785 775 815 795 785 820 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) Answer is complete but not entirely correct. MSE MAD 597.20 20.50 Forecast 1 Forecast 2 1.429.55 29.40 Camut MARF In earn freast (Round our intermediate calculations to 5 decimal places and final answers to 4 decimal b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.) Answer is complete and correct. MAPE F1 MAPE F2 2.5049 3.5560 % c. Prepare a nalve forecast for periods 2 through 11 using the given sales dota. 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.) Answer is complete but not entirely correct. MSE MAD Tracking signal Controllimit 1,362,50 33.75 13.00 9.00 0 1

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!