5-37 Trevor Harty, an avid mountain biker, always wanted to start a business selling top-of-the-line mountain bikes and other outdoor supplies. A little over 6 years ago, he and a silent partner opened a store called Hale and Harty Trail Bikes and Supplies. Growth was rapid in the first 2 years, but since that time, growth in sales has slowed a bit, as expected. The quarterly sales (in $1,000s) for the past 4 years are shown in the table below: QUARTER YEAR 1 YEAR 2 YEAR 3 YEAR 4 1 274 282 282 296 2 172 178 182 210 130 136 134 158 162 168 170 182 3. 4-

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...
icon
Related questions
Question
5-37 Trevor Harty, an avid mountain biker, always wanted to start a
business selling top-of-the-line mountain bikes and other outdoor
supplies. A little over 6 years ago, he and a silent partner opened a
store called Hale and Harty Trail Bikes and Supplies. Growth was
rapid in the first 2 years, but since that time, growth in sales has
slowed a bit, as expected. The quarterly sales (in $1,000s) for the
past 4 years are shown in the table below:
QUARTER
YEAR 1
YEAR 2
YEAR 3
YEAR 4
1
274
282
282
296
2
172
178
182
210
3
130
136
134
158
4
162
168
170
182
Transcribed Image Text:5-37 Trevor Harty, an avid mountain biker, always wanted to start a business selling top-of-the-line mountain bikes and other outdoor supplies. A little over 6 years ago, he and a silent partner opened a store called Hale and Harty Trail Bikes and Supplies. Growth was rapid in the first 2 years, but since that time, growth in sales has slowed a bit, as expected. The quarterly sales (in $1,000s) for the past 4 years are shown in the table below: QUARTER YEAR 1 YEAR 2 YEAR 3 YEAR 4 1 274 282 282 296 2 172 178 182 210 3 130 136 134 158 4 162 168 170 182
a. Develop a trend line using the data in the table. Use this to
forecast sales for each quarter of year 5. What does the
slope of this line indicate?
b. Use the multiplicative decomposition model to incorporate
both trend and seasonal components into the forecast.
What does the slope of this line indicate?
c. Compare the slope of the trend line in part (a) to the slope
in the trend line for the decomposition model that was
based on the deseasonalized sales figures. Discuss why
these are so different and explain which is the better one to
use.
Transcribed Image Text:a. Develop a trend line using the data in the table. Use this to forecast sales for each quarter of year 5. What does the slope of this line indicate? b. Use the multiplicative decomposition model to incorporate both trend and seasonal components into the forecast. What does the slope of this line indicate? c. Compare the slope of the trend line in part (a) to the slope in the trend line for the decomposition model that was based on the deseasonalized sales figures. Discuss why these are so different and explain which is the better one to use.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.