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: Month 1 2 3 1 5 6 Sales 845 335 795 -830 235 Forecast 800 805 820 015 270 775 765 779 30 785 Eorecast 2 765 800 805 830 780 783 775 010 820 785 700 BIS 825 10 a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.) MSE MAD 3050 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 94 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 Controllimit 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!