Question: Show work for the question by hand please, not excel. 5. Two independent methods of forecasting based on judgment and experience have been prepared each

Show work for the question by hand please, not excel.

Show work for the question by hand please, not

5. 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 3 Sales 770 789 794 780 768 772 760 775 786 790 Forecast 1 771 785 790 784 770 768 761 Forecast 2 769 787 792 798 774 770 759 775 788 788 6 7 8 9 771 784 788 10 a. Compute the MSE and MAD for each forecast. Does either forecast seem superior? b. Compute MAPE for each forecast. c. Prepare a nave forecast for periods 2 through 11 using the given sales data. Compute each of the following (1) MSE, (2) MAD. How do the nave results compare with the other two forecasts

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!