$1.)$ In the given spreadsheet, use the background information to conduct a shortcut TCA on the three P$2$ options. Provide your answers in the spreadsheet and use formulas to show your work$/$all the steps.

$2.)$ Which options are worth pursuing and why? Which one should be implemented first, and why?

Background Information

As the environmental manager for McMurray Inc., you start investigating process improvements to cut or eliminate waste to avoid risks and capture new opportunities. Initial research leads you to three pollution prevention prospects which you will evaluate with shortcut total cost assessments to decide which one or more to pursue. The finance department tells you to assume a discount rate of $7\%$ for all projects. The current operating $($ongoing$)$ costs for the process lines considered for modification are listed in the table below. The three highest operating cash flows are highlighted in the table below. Operating Cash Flow Current Process Chemical purchases $ $(686,676\mathrm{.}28)$ Chemicals $ $(2,155,159\mathrm{.}02)$ Testing $ $(28,696\mathrm{.}12)$Waste management Disposal $ $(450,815\mathrm{.}34)$ Safety training$/$equipment $ $(6,603\mathrm{.}58)$ Insurance $ $(24,447\mathrm{.}50)$ Filing paperwork time $ $(1,208\mathrm{.}55)$ Annual permitting $ $(2,512\mathrm{.}50)\%$ inc.$/$dec$.$ Production costs $$/$yr $ $(2,697,552\mathrm{.}70)$ Time $ $(39,999\mathrm{.}60)$ Maintenance Materials $ $(5,199\mathrm{.}48)$ Water $ $(532,883\mathrm{.}61)$ Electricity $ $(889,502\mathrm{.}99)$Utilities Gas$/$steam $ $(102,724\mathrm{.}88)$ Total annual operating cash flow $ $(7,623,982\mathrm{.}16)$