Question: 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
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:
.png)
(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 one is best touse.
YEAR 1 QUARTER 274 QUARTER 2 172 QUARTER 3 130 QUARTER 4 162 YEAR 2 282 178 136 168 YEAR 3 282 182 134 170 YEAR 4 296 210 158 182
Step by Step Solution
3.31 Rating (157 Votes )
There are 3 Steps involved in it
a Using computer software we get Y 1975 034 X where X time period The slope is 034 which indicates a small negative trend Note that the results are no... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
162-M-S-F (66).docx
120 KBs Word File
