Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6 Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual

image text in transcribed

6 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 2 Forecast 1 775 1 845 785 2 840 835 795 3 820 815 795 4 860 835 835 5 765 780 B10 6 830 795 776 7 785 765 770 8 840 835 785 9 795 800 825 10 B40 785 850 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Porecast 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 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. (Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limita 0 + 5 points eBook D Print 0 References 6 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 2 Forecast 1 775 1 845 785 2 840 835 795 3 820 815 795 4 860 835 835 5 765 780 B10 6 830 795 776 7 785 765 770 8 840 835 785 9 795 800 825 10 B40 785 850 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) MSE MAD Porecast 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 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. (Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limita 0 + 5 points eBook D Print 0 References

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Democracy Towards A Sustainable Financial System

Authors: Alessandro Vercelli

1st Edition

3030279111, 978-3030279110

More Books

Students also viewed these Finance questions