For this problem, we need to find out which capital investments to make (Yes=1, No=0) (the YELLOW area).

Set up the needed formulas and then use the Excel Solver to find out the maximum Total Profit with the following constrain:

a. The amount of capital used by the investments cannot exceed the limited amount of capital available (50).

Capital Investment Investment Opportunities One Two Three Four Five Six Seven Profit 42 47 21 36 18 33 45 o Capital Needed 12 10 15 7 14 18 16 50 Total Profit 0 Yes/No 0 0 0 0 0 0 0 For this problem, we need to find out which capital investments to make (Yes=1, No=0) (the YELLOW area). Set up the needed formulas and then use the Excel Solver to find out the maximum Total Profit with the following constrain: a. The amount of capital used by the investments cannot exceed the limited amount of capital available (50)