Question: Two independent methods o f forecasting based o n judgment and experience have been prepared each month for the past 1 0 months. The forecasts

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
1835840820
2835820795
3820835835
4825795855
5780775790
6825775796
7800775775
8840780820
9790820815
10800830815
a. Compute the MSE and MAD for each forecast. (Round your answers to2 decimal places.)
MSE MAD
Forecast 1
Forecast 2
22.40
b. Compute MAPE for each forecast. (Round your intermediate calculations to5 decimal places and final answers to4 decimal places.)
MAPE F1
%
MAPE F2
2.7395
%
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 to2 decimal places.)
MSE
MAD
Tracking signal
Control limits0

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!