90.2K

Verified Solution

Link Copied!

Barbara Lynch, the product manager for a line of skiwearproduced by HeathCo Industries, has been working on developingsales forecasts for the skiwear that is sold under the NorthernSlopes and Jacque Monri brands. She has had variousregression-based forecasting models developed. Quarterly sales for1988Q1 through 1997Q4 are as follows:

	Sales
Year	Q1	Q2	Q3	Q4
1988	72,962	81,921	97,729	142,161
1989	145,592	117,129	114,159	151,402
1990	153,907	100,144	123,242	128,497
1991	176,076	180,440	162,665	220,818
1992	202,415	211,780	163,710	200,135
1993	174,200	182,556	198,990	243,700
1994	253,142	218,755	225,422	253,653
1995	257,156	202,568	224,482	229,879
1996	289,321	266,095	262,938	322,052
1997	313,769	315,011	264,939	301,479

a) Prepare a time-series plot of the data, and on the basis ofwhat you see in the plot, write a brief paragraph in which youexplain what patterns you think are present in the salesseries.

b) Smooth out seasonal influences and irregular movement bycalculating the center moving averages. Add the centered movingaverages to the original data you plotted in part a. Has theprocess of calculating center moving averages been effective insmoothing out the seasonal and irregular fluctuations in the data?Explain.

c) Determine the degree of seasonality by calculating seasonalindexes for each quarter of the year.

d) Develop a forecast for Ms Lynch for the four quarters of1998.