=E*

c. Perform sensitivity analysis on the amount of investment capital made available for the development projects by using the Solver Table to solve the model with the following amounts of investment capital (in millions of dollars): 16, 18, 20, 22, 24, 26, 28, and 30. Include both the changing cells and the target cell as output cells in the Solver Table.

Investment Estimated Profit Capital Required Opportunity (millions) (millions)

1 $17 $43 2 10 28 3 15 34 4 19 48 5 7 17 6 13 32 7 9 23