I forgot to delete the total profit, I was trying to solve it myself.

F U B Capital Investment Five Two Three Four One Six Seven Investment Opportunities 15 47 21 18 33 42 36 Profit s 50 50 0 0 0 50 0 0 0 Capital Needed Total Profit 2350 0 0 0 0 0 0 0 Yes/No 1 For this problem, we need to find out which capital investments to make (Yes=1, No=0) (the YELLOW area). 2 3 4 5 6 7 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). F U B Capital Investment Five Two Three Four One Six Seven Investment Opportunities 15 47 21 18 33 42 36 Profit s 50 50 0 0 0 50 0 0 0 Capital Needed Total Profit 2350 0 0 0 0 0 0 0 Yes/No 1 For this problem, we need to find out which capital investments to make (Yes=1, No=0) (the YELLOW area). 2 3 4 5 6 7 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)