please answer with excel formulas and show your work. thank you!

12 13 A bcal business is concerned about it's operation. In an attempt to increase productivity they have invested 14 monay in the business. You have been hired as an operations analyst to report to the owner whether or not 15 the operation has improved from last year to this year. Operational data is below. 16 PART A : Determine the productivily index for e ch resource input for last year and this year. 17 What is the productivity percent change in each ? PART B: Has the operation improved and 8 so where? 18 Note: please show your work. 19 20 PART A \begin{tabular}{rl|} 21 & \\ 22 & Output (kilos) \\ 23 & Labour (hours) \\ 24 & Material (litres) \\ 25 & Capital invested (\$) \\ 26 & Energy (BTU) \end{tabular} Lastyear \begin{tabular}{|c|} \hline 1700 \\ \hline 320 \\ \hline 50 \\ $12,000 \\ \hline 3500 \\ \hline \end{tabular} This Year 220030553$19,0004200 Percent Change 28 Please record your productivity index's in the spaces below. \begin{tabular}{l|l} 29 \\ 30 \\ 31 \end{tabular} \mid Labour index 32 33 34 35 Material Index Captal index Lastyear + This Year assignment Ready If the Accessibilityi Unavailable 12 13 A bcal business is concerned about it's operation. In an attempt to increase productivity they have invested 14 monay in the business. You have been hired as an operations analyst to report to the owner whether or not 15 the operation has improved from last year to this year. Operational data is below. 16 PART A : Determine the productivily index for e ch resource input for last year and this year. 17 What is the productivity percent change in each ? PART B: Has the operation improved and 8 so where? 18 Note: please show your work. 19 20 PART A \begin{tabular}{rl|} 21 & \\ 22 & Output (kilos) \\ 23 & Labour (hours) \\ 24 & Material (litres) \\ 25 & Capital invested (\$) \\ 26 & Energy (BTU) \end{tabular} Lastyear \begin{tabular}{|c|} \hline 1700 \\ \hline 320 \\ \hline 50 \\ $12,000 \\ \hline 3500 \\ \hline \end{tabular} This Year 220030553$19,0004200 Percent Change 28 Please record your productivity index's in the spaces below. \begin{tabular}{l|l} 29 \\ 30 \\ 31 \end{tabular} \mid Labour index 32 33 34 35 Material Index Captal index Lastyear + This Year assignment Ready If the Accessibilityi Unavailable