SHOW EXCEL STEPS AS WELL, EQUATIONS, AND SOLVER

The board of directors of Southeast Co. is considering seven large capital investments. Each investment can be made only once. These investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table. The total amount of capital available for these investments is $120 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 5 and 6 . Furthermore, neither 5 nor 6 can be undertaken unless at least one of the first three opportunities is undertaken. The objective is to select the combination of capital investments that will maximize the total estimated long-run profit (net present value). Formulate and solve the binary programming model that will provide the optimal solution. Describe the optimal solution (i.e., which opportunities should be invested in and what is the total estimated long-run profit?). What are the binding constraints