12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month Motorcycle Sales January February 7 March 10 April May 7 June 12 July 10 August 11 September 12 October 10 November December 14 16 a. Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of the next year?
12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month Motorcycle Sales January February 7 March 10 April May 7 June 12 July 10 August 11 September 12 October 10 November December 14 16 a. Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of the next year?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...
Related questions
Question
![12-1. The Hartley-Davis motorcycle dealer in the Minneapolis-
St. Paul area wants to be able to forecast accurately the de-
mand for the Roadhog Super motorcycle during the next
month. From sales records, the dealer has accumulated the
data in the following table for the past year.
Month
January
February
March
April
Мay
June
Motorcycle Sales
7
10
8
7
12
July
August
September
10
11
12
October
10
November
December
14
16
a Compute a three-month moving average forecast of
demand for April through January (of the next year).
b. Compore a five-month moving average forecast for
June drough January.
c. Compare the two forecasts computed in parts (a) and
(b) using MAD. Which one should the dealer use for
January of dhe next year?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff078624b-a94f-44e2-8c28-b1cd1e50eb77%2F89ba3587-6616-4816-b794-2e2e941b419f%2Fbn2rd69_processed.jpeg&w=3840&q=75)
Transcribed Image Text:12-1. The Hartley-Davis motorcycle dealer in the Minneapolis-
St. Paul area wants to be able to forecast accurately the de-
mand for the Roadhog Super motorcycle during the next
month. From sales records, the dealer has accumulated the
data in the following table for the past year.
Month
January
February
March
April
Мay
June
Motorcycle Sales
7
10
8
7
12
July
August
September
10
11
12
October
10
November
December
14
16
a Compute a three-month moving average forecast of
demand for April through January (of the next year).
b. Compore a five-month moving average forecast for
June drough January.
c. Compare the two forecasts computed in parts (a) and
(b) using MAD. Which one should the dealer use for
January of dhe next year?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing