c) The MSE for a 3-year moving average based forecast is 68 sales (round your response to the nearest whole number).

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 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
icon
Related questions
Question

68 is incorrect

Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
1
сле со NH
2
3
4
5
Sales
450
495
520
566
585
a) Forecasted sales for year 6 using a 3-year moving average is 557 sales (round your response to one decimal place).
b) The MAD for a 3-year moving average based forecast is 67.9 sales (round your response to one decimal place).
c) The MSE for a 3-year moving average based forecast is 68 sales (round your response to the nearest whole number).
Transcribed Image Text:Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year 1 сле со NH 2 3 4 5 Sales 450 495 520 566 585 a) Forecasted sales for year 6 using a 3-year moving average is 557 sales (round your response to one decimal place). b) The MAD for a 3-year moving average based forecast is 67.9 sales (round your response to one decimal place). c) The MSE for a 3-year moving average based forecast is 68 sales (round your response to the nearest whole number).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 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,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing