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	835	845	785
2	835	805	820
3	825	790	795
4	800	830	810
5	790	790	775
6	825	790	821
7	770	785	775
8	855	800	780
9	810	820	795
10	805	855	835

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

Having a lot of trouble with C. Please help with C, thank you!!!

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

You are the forex control officer in the foreign exchange department of Bank Monash (based in Melbourne, Australia). You have been given three tasks to accomplish. Task 1: You need to write a put...

Discuss the limitations in offsetting a subsidiary's abnormal degree of financial leverage.

1 2 Multiple Choice 1 pointWhich one of the following is a current liability?Estimated income taxes which were just paid todayAn invoice due from a customer in 3 0 daysA loan payment due to a bank 1...

Save Homework: Chapter 9 Homework Score: 0 of 1 pt X P9-17 (similar to) 7 of 105 complete HW Score: 32 22%, 3.22 of 10 pts Question Helpo percent interest way The market price of the bond is $945,...