Regression Analysis for Operations Management

1. What variables do you think would affect shipments of Treat?
Trend
Season (Month)
Consumer pack promotion (this month and two prior months)
Dealer allowance (this month and two previous months)

2.From the point of view of management, what model(s) do you think make(s) most sense for predicting monthly shipments of Treat cereal?

3. After testing those models (using Excel) that you think are most attractive for forecasting purposes in this situation, select the model that you think is best and use that to project shipments for Jan-Dec 1988. What do you need to know in order to use this model to prepare these forecasts?

4. What can you learn from an examination of the coefficients in your model as to the relative impact of consumer promotions versus dealer promotions?

For this question, you may check this YouTube to see how you can perform a multi-variable regression model and answer this question.

https://www.youtube.com/watch?time_continue=1&v=HgfHefwK7VQ&feature=emb_logo