Question: please show all work for a, b, and c Two independent methods of forecasting based on Judgment and experience have been prepared each month for
please show all work for a, b, and c
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 1 Forecast 2 1 830 825 805 2 830 785 805 3 810 790 805 4 800 795 815 5 770 805 780 830 765 796 775 765 810 855 810 850 9 835 820 840 10 855 845 6 7 8 825 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.) MAPE F1 MAPE F2 % X c. Prepare a naive forecast for periods 2 through it 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 Controllimis 0

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
