Question: Using formulas only not excel. Thank you! Two independent methods of forecasting based on judgment and experience have been prepared each month for the past

Using formulas only not excel. Thank you!
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 2 3 4 5 770 789 794 780 768 772 760 775 786 790 771 785 790 784 770 768 761 771 784 788 769 787 792 798 774 770 759 775 788 788 6 7 8 9 10 (a) Compute the MAD, MSE, and MAPE for each forecast (2 points) (b) Does either forecast seem superior? Explain (2 points)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
