PLEASE USE THE EXPONENTIAL SMOOTHING METHOD

(SHOW STEPS ON EXCEL)

TABLE 1		SALES FIGURES
Month	1993	1994	1995	1996	1997	1998	1999	2000	2001
January	139.7	165.1	177.8	228.6	266.7	431.8	381	431.8	495.3
February	114.3	177.8	203.2	254	317.5	457.2	406.4	444.5	533.4
March	101.6	177.8	228.6	266.7	368.3	457.2	431.8	495.3	635
April	152.4	203.2	279.4	342.9	431.8	482.6	457.2	533.4	673.1
May	215.9	241.3	317.5	355.6	457.2	533.4	495.3	558.8	749.3
June	228.6	279.4	330.2	406.4	571.5	622.3	584.2	647.7	812.8
July	215.9	292.1	368.3	444.5	546.1	660.4	609.6	673.1	800.1
August	190.5	317.5	355.6	431.8	482.6	520.7	558.8	660.4	736.6
September	177.8	203.2	241.3	330.2	431.8	508	508	609.6	685.8
October	139.7	177.8	215.9	330.2	406.4	482.6	495.3	584.2	635
November	139.7	165.1	215.9	304.8	393.7	457.2	444.5	520.7	622.3
December	152.4	177.8	203.2	292.1	406.4	431.8	419.1	482.6	622.3

TABLE 2	COST OF LOCKERS
Year	Per-Unit Labor Cost
1988	$80.15
1989	85.29
1990	85.75
1991	64.23
1992	63.70
1993	62.54
1994	60.19
1995	59.84
1996	57.29
1997	58.74
1998	55.01
1999	56.20
2000	55.93
2001	55.60

task is to provide Steven Berg with a forecast of sales and per-unit labour costs for 2002. For each data set: 1) USE THE EXPONENTIAL SMOOTHING METHOD in forecasting this data.w 2) Write a brief (no more than 1/2 page) explanation of why you chose the method you did - observations about the data and characteristics of the chosen methodology. 3) Generate a forecast for 2002. Show the spreadsheet(s) you used to build the model. Annotate briefly to explain your methodology