A company has collected the data on the spreadsheet below for the two plants it operates. The plants are of similar size and capacity. All data are in thousands of US$.

a- Using a spreadsheet, calculate the labor, capital and multifactor (including, labor, capital and materials) productivity for each plant for all years. b- Using a spreadsheet, plot plant A's and Bs labor productivity on the same graph. C- Using a spreadsheet, plot plant A's and Bs capital productivity on the same graph. d- Using a spreadsheet, plot plant A's and Bs multifactor productivity on the same graph. e- Evaluate each plant's performance overtime both independent of the other plant and relative to the other plant, what would you recommend? (5 marks) 2330 Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 Sales 3510 3820 3960 4100 4290 4650 4750 4790 5040 5340 5630 Plant A Labor Capital Materials 180 878 2080 195 1023 2060 200 1080 2105 215 1117 217.5 1257 2430 232.5 1200 2660 240 1210 2440 249.5 1290 2760 252 1380 2920 270 1450 3120 290 1530 2960 Sales 3480 3790 4030 4060 4270 4580 4830 4890 5020 5050 5510 Plant B Labor Capital Materials 178 870.5 1780 191 967 2030 200.5 1050 2210 199 1080 2180 206 1160 2190 218 1260 2410 226 1360 2850 225.5 1405 2750 228 1470 2970 226 1510 2990 243 1680 3100