Trevor
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: Year 1 Year 2 Year 3 Year 4 Quarter 1 274 282 282 296 Quarter 2 182 198 185 210 Quarter 3 132 138 336 160 Quarter 4 163 169 172 188 • 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? • Use the multiplicative decomposition model to incorporate both trend and seasonal components into the forecast. What does the slope of this line indicate? • 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 to use.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images