The file Cranberries.xlsx includes quarterly sales in pounds of cranberries at a supermarket, price per pound charge, and the average price charged by competition.

a. Use this data to determine how seasonality, trend, and price affect quarterly sales.

b. Use a Multiplicative Model for seasonality. (The average of seasonal indexes should equal 1.)

c. Introduce a trend and set up the model so that you can estimate price elasticity.

d. If you charge $5 a pound in Q1 2012 and the competitor charges $5 per pound, predict the Q1 2012 sales.

e. Fill in the blank: You are 95 percent sure the Q1 2012 sales are between and Problems 2-4 use the workbook Snickers.xlsx.