The Sales2 variable in the file from the previous problem was created from the Sales1 variable by
Question:
The Sales2 variable in the file from the previous problem was created from the Sales1 variable by multiplying by monthly seasonal factors. Basically, the summer months are high and the winter months are low.
This might represent the sales of a product that has a linear trend and seasonality.
a. Repeat parts a to c from the previous problem to see how well these forecasting methods can deal with trend and seasonality.
b. Use Winters’ method, with various values of the three smoothing constants, to forecast the series.
Can you do much better? Which smoothing constants work well?
c. What can you conclude from your findings in parts a and b about forecasting this type of series?
Step by Step Answer:
Practical Management Science
ISBN: 9781111531317
4th Edition
Authors: Wayne L. Winston, S. Christian Albright