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

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

forcast 1

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

MSE MAD Tracking signal

control limits

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

An elastic beam of unit length has bending stiffness c(x) = I + x2 for 0

Do a little research to answer the following question. You can use the course manual, the internet or any other source to find answers, but BE SURE TO SUMMARIZE, PARAPHRASE AND CITE YOUR RESEARCH...

Question 3 6 2 . 5 pts Shannon Hill needed to buy an airline ticket to visit her parents. She went to several websites to compare rates and chose a fight on Go Anywhere Airlines because, for a...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...