PLEASE ANSWER QUESTION 12.10 ONLY. PLEASE USE SOLVER FUNCTION IN EXCEL

12.9 Shown for background information only.

12.9 The engineer at Clean Water Engineering has established a capital investment limit of $800,000 for next year for projects that target improved recovery of highly brackish groundwater. Select any or all of the following projects, using a MARR of 10% per year. Present your solution by hand calculations, not Excel. Initial Annual Life, Salvage Project Investment, $ NCF, $/Year Years Value, $ A - 250,000 50,000 4 45,000 B -300,000 90,000 4 - 10,000 C -550,000 150,000 4 100,000 12.10 Develop an Excel spreadsheet for the three projects in Problem 12.9. Assume that the engineer wants project C to be the only one selected. Considering the viable project options and b = $800,000, determine (a) the largest initial invest- ment for C and (b) the largest MARR allowed to guarantee that C is selected