Question: PLEASE SHOW WORK Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months The forecasts

PLEASE SHOW WORK
PLEASE SHOW WORK Two independent methods of
PLEASE SHOW WORK Two independent methods of
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 Sales 835 840 800 795 790 840 785 830 785 840 Forecast 1 840 800 780 795 10 775 795 770 790 840 Forecast 2 805 820 320 845 805 776 795 825 840 840 9 10 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Forecast 1 Forecast 2 ampute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal s.) E F1 EF2 % Draw BB 2 Mart b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimat 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 decimal places.) MSE MAD Tracking signal 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!