Use the given MS Excel spreadsheet to complete the following problem based on the given information below

using what you learned in the notes, videos, and Total Cost Assessment for Environmental Engineers and

Managers reading. Include your name and Week$5$Quiz in the file name; upload your completed work to the

Assignment in Canvas.

$1.)$ In the given spreadsheet, use the background information to conduct a balanced TCA on the two P$2$ options

the shortcut TCA proved worth further investigation. Provide your answers in the three worksheets $($tabs$)$

and use formulas to show your work$/$all the steps. Make sure your formulas are linked from one tab to the

next. No retyping numbers!

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

$3.)$ For up to $5$ points extra credit, calculate the operating costs as if you were going to pursue both options at

the same time. What would the incremental cash flow be$?$ You definitely don't just add across.$$ For each

operating cost, you need to think about how each project effects the operating cost. One could go up where

the other goes down, they could both drive the cost down, the cost could be wiped out entirely, etc.