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

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...
icon
Related questions
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 are as follows:
1
ns. The forecasts and actual sales are as
2
Month Sales
1
835
2
845
3
850
4
820
5
785
6
840
7
815
840
785
800
8
9
10
Forecast
a. Compute the MSE and MAD for each forecast. (Round your
answers to 2 decimal places.)
Forecast
MAPE F1
Forecast 1
835
830
MAPF F2
< Prev
840
790
815
785
770
835
MSE
805
785
b. Compute MAPE for each forecast. (Round your intermediate
calculations to 5 decimal places and final answers to 4 decimal
places.)
%
%
Forecast 2
765
830
815
830
800
806
775
810
815
805
15 of 15
MAD
‒‒‒
22.50
28.40
Next >
Transcribed Image Text:1 ns. The forecasts and actual sales are as 2 Month Sales 1 835 2 845 3 850 4 820 5 785 6 840 7 815 840 785 800 8 9 10 Forecast a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) Forecast MAPE F1 Forecast 1 835 830 MAPF F2 < Prev 840 790 815 785 770 835 MSE 805 785 b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.) % % Forecast 2 765 830 815 830 800 806 775 810 815 805 15 of 15 MAD ‒‒‒ 22.50 28.40 Next >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,