PLEASE SHOW YOUR WORK/STEPS on EXCEL

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

For each data set: 1) USE THE SIMPLE MOVING AVERAGE METHOD in forecasting this data. 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