Question: Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 month forecasts and

Problem 3-22 (Algo) Two independent methods of

Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 month forecasts and actual sales are as follows Month Sales 8.30 845 Forecast 815 815 830 2 3 4 5 6 2 Forecast 1 340 800 83e 820 Bes nes ste 795 50 790 es 765 34 785 860 765 786 305 790 815 795 855 10 790 a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.) MAD SE 32 50 Forecast 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 MAPEF "S c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following. () MSE, (2) MAD. (B) trading signal at month 10, and (4) 2s controllimits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) MSE Trading Signal Control

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!