Question: 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

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	840	785	815
2	840	815	805
3	810	790	805
4	850	805	835
5	770	785	780
6	835	770	786
7	815	760	810
8	850	830	835
9	835	830	825
10	825	815	825

a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.)

b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.)

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. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

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!

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 5 790 794 776...

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...

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: b. Compute MAPE for each...

3. Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months Compute MAD and MSE (sum of squared errors divided by (n-1)] for each...

1. 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: a. Compute the MSE and...

Problem 3-22 (Algo) 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:...

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...

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: a. Compute the MSE and MAD...

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...

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: a. [6marks] Compute the...

On July 1, 2020, West Company purchased for cash, ten $10,000 bonds of North Corporation at a market rate of 6%. The bonds pay 5% interest, payable on a semiannual basis each july 1 and January 1,...

When does a life insurance contract become effective if the initial premium is not collected during the application process? A . After application has been approved by the underwriters B . After all...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...