. The demand for all-terrain bicycles had been steadily increasing since 1989. In the following table are the sales per quarter of mountain bikes produced by Canyon and Cactus Cycles since the second quarter of 1989. (a) Plot the data and verify that the model for linear trend is acceptable. Draw a line through the plotted data and obtain a visual estimate of a and b. (b) Estimate the parameters of the model in preparation for double exponential smoothing. (c) Forecast sales for the third quarter of 1996 using these initial estimates. (d) Forecast sales for the fourth quarter of 1996 using alpha 0.3 and beta 0.25 if sales in the third quarter of 1996 were equal to 234. (e) Use linear regression to estimate the parameters and forecast the third quarter of 1996.
. The demand for all-terrain bicycles had been steadily increasing since 1989. In the following table are the sales per quarter of mountain bikes produced by Canyon and Cactus Cycles since the second quarter of 1989. (a) Plot the data and verify that the model for linear trend is acceptable. Draw a line through the plotted data and obtain a visual estimate of a and b. (b) Estimate the parameters of the model in preparation for double exponential smoothing. (c) Forecast sales for the third quarter of 1996 using these initial estimates. (d) Forecast sales for the fourth quarter of 1996 using alpha 0.3 and beta 0.25 if sales in the third quarter of 1996 were equal to 234. (e) Use linear regression to estimate the parameters and forecast the third quarter of 1996.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question

Transcribed Image Text:4.29. The demand for all-terrain bicycles had been steadily increasing since 1989. In the following
table are the sales per quarter of mountain bikes produced by Canyon and Cactus Cycles since
the second quarter of 1989.
(a) Plot the data and verify that the model for linear trend is acceptable. Draw a line through the
plotted data and obtain a visual estimate of a and b.
(b) Estimate the parameters of the model in preparation for double exponential smoothing.
(c) Forecast sales for the third quarter of 1996 using these initial estimates.
(d) Forecast sales for the fourth quarter of 1996 using alpha 0.3 and beta = 0.25 if sales in
the third quarter of 1996 were equal to 234.
(e) Use linear regression to estimate the parameters and forecast the third quarter of 1996.

Transcribed Image Text:Observation
1
2
3
4
5
6
1
8
9
10
11
12
13
14
Year
1989
1990
1991
1992
Quarter
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
Demand
16
73
61
57
43
44
68
68
73
84
93
128
100
130
148
Observation
BARDGING
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Year Quarter Demand
1993
1
147
142
134
159
181
168
168
188
186
189
184
224
207
223
1994
1995
FORECASTING 133
1996
2
3
4
1
2
3
4
1
2
3
4
1
2
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.