5. The Chief Financial Officer of Eaton Medical Devices has determined that the firm's capital investment budget will be $5,000,000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all of the positive NPV projects available to the firm. Project Cost NPV A $922,775 $106,728 B 488,486 50,524 1,432,913 244,053 D 892,192 77,709 E 166,844 15,277 F 1,159,674 66,922 G 2,697,950 107,166 H 239,625 69,015 1,777,453 52,614 884,841 49,296 I J You have been asked to choose which investments should be made. a. Using the Solver, determine which of the above projects should be included in the budget if the firm's goal is to maximize shareholder wealth. (Note: Set the Solver to use the Simplex LP method, and turn off the Ignore Integer Constraints setting.) b. Now assume that the CFO has informed you that projects A and B are mutually exclusive, but one of them must be selected. Change your Solver constraints to account for this new information and find the new solution. (Use the same options as in part a.) c. Ignore the constraints from part b. The CFO has now informed you that Project I is of great strategic importance to the survival of the firm. It must be accepted. Which projects should be accepted? d. Explain why the different constraints in parts a, b, and c cause different results. Which one results in the highest total investment? Which one has the highest overall NPV? e. If you rank the projects by profitability index and then select them until you reach a total cost near $5,000,000, do you get the same results as when optimizing by NPV? Use the RANK.AVG function to rank the projects by profitability index in descending order