PLEASE USE EXCEL & SHOW STEPS [PLEASE TAKE YOUR TIME TO ANSWER THE QUESTION]

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 the following data set below: 1) USE THE Weighted Moving Averages in forecasting this data. 2) Write a brief (no more than 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