Use the seasonal indices developed for problem 12 and the centered moving average method to:

1. Deseasonalize the ice cream sales data.

2. Develop a linear trend equation using the deseasonalized data.

3. Develop a trend forecast for the first quarter of year 5.

4. Develop a seasonalized forecast for the first quarter of year 5.

Data from problem 12

The fictitious Haskin & Collins Ice Cream Store needs an accurate estimate of demand. The owner of the store believes that the demand for ice cream has a quarterly seasonal pattern. To analyze the pattern, the owner gathered the following quarterly ice cream sales data in gallons for the last 4 years:

Transcribed Image Text:

Year Quarter 3 4 January-March April-June July-September October-December 370 470 380 530 550 500 700 620 770 820 980 990 420 440 510 530 2.