Exhibit B. A commercial property development company has $200 million available to start several big projects. The capital required and estimated return (in millions) for each project are as follows. A B C D E F G Capital 38 50 34 35 46 39 34 Estimated Return 5 6 3 7 6 6 8 B-1. Help the company select projects so it can maximize the expected total return. (1) What kind of problem is it? What model is it to solve the problem? Formulate and solve the problem. (2) What projects should be selected? What is the total expected return? (3) How much capital is not invested? Briefly explain why not all capital are used, if any. B-2. Add the following constraints to B-1: (1) Projects E and F cannot be selected simultaneously due to overlap of a key resource. (2) Project D is selected only if project B is also selected. Formulate the problem as a spreadsheet model to determine the optimal investment strategy. Solve the problem. What is the optimal strategy? What is the estimated total profit? How much capital is not invested? B-3. Use Analytic Solver to conduct parameter analysis on B-1 for capital available between $150 and $250 million with an increment of 10 million and show how the total estimated return and projects selected change. Describe how capital available change the results.