Need LP tutorial help involving optimization and the use of Solver.
Solve the following modifications of the Tatham Capital Budgeting model (solve each part independently of the others)
(a) Suppose that at most two of the project 1 - 5 can be selected. write the appropriate algebraic constraint and solve. What is the new Z*?
(b) Suppose that if investment 1 is selected, then investment 3 must also be selected. Write the appropriate algebraic constraint and solve. What is the new Z*?
(c) Suppose that at least one of the investments 6 and 7 must be selected. Write the appropriate algebraic constraint and solve. What is the new Z*?
(d) Suppose that investment 2 can be selected only if both investments 1 and 3 are selected. Write the appropriate algebraic constraint and solve. What is the new Z*?