Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6 Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual
6 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 2 Forecast 1 775 1 845 785 2 840 835 795 3 820 815 795 4 860 835 835 5 765 780 B10 6 830 795 776 7 785 765 770 8 840 835 785 9 795 800 825 10 B40 785 850 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Porecast 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 limita 0 + 5 points eBook D Print 0 References 6 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 2 Forecast 1 775 1 845 785 2 840 835 795 3 820 815 795 4 860 835 835 5 765 780 B10 6 830 795 776 7 785 765 770 8 840 835 785 9 795 800 825 10 B40 785 850 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Porecast 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 limita 0 + 5 points eBook D Print 0 References
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started