Question

The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year.

QUARTER	SALES	QUARTER	SALES
1	218	5	162
2	238	6	190
3	209	7	156
4	176	8	141

Use regression and seasonal indexes to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.)

The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year.

Forecast:

Q9:

Q10:

Q11:

Q12:

Answer 1

Solution:

Regression equation is,

Hence, the forecast for Q9, Q10, Q11, and Q12 are given below calculated from given equation.