Consider the Think-Big Development Co. problem presented in Section 6.2, including the spreadsheet in Figure 6.3 showing its formulation and optimal solution. In parts a to g, use the spreadsheet and Solver to check whether the optimal solution would change and, if so, what the new optimal solution would be, if the estimates in Table 6.3 of the net present values of the projects were to be changed in each of the following ways.

(Consider each part by itself.)

a. The net present value of project 1 (a high-rise office building)

increases by $200,000.

b. The net present value of project 2 (a hotel) increases by

$200,000.

c. The net present value of project 1 decreases by $5 million.

d. The net present value of project 3 (a shopping center) decreases by $200,000.