Question

# Brooks Development Corporation (BDC) faces the following capital budgeting decision. Six real estate projects are available...

Brooks Development Corporation (BDC) faces the following capital budgeting decision. Six real estate projects are available for investment. The net present value and expenditures required for each project (in millions of dollars) are as follows:

Project    1    2    3    4 5    6

Net Present value (\$Millions) \$15 \$5    \$13 \$14    \$20    \$9

Expedature required (\$Millions) \$90 \$34    \$81 \$70    \$114    \$50

There are conditions that limit the investment alternatives:

• At least two of projects 1, 3, 5, and 6 must be undertaken.

• If either project 3 or 5 is undertaken, they must both be undertaken.

• Project 4 cannot be undertaken unless both projects 1 and 3 also are undertaken.

The budget for this investment period is \$220 million.

a. Formulate a binary integer program that will enable BDC to find the projects to invest in to maximize net present value, while satisfying all project restrictions and not exceeding the budget.

Let Yj be the binary integer such that Yj=1 when the j-th project is undertaken and Yj=0 otherwise.

Maximize Z = Total NPV = 15 Y1 + 5 Y2 + 13 Y3 + 14 Y4 + 20 Y5 + 9 Y6

Subject to,

90 Y1 + 34 Y2 + 81 Y3 + 70 Y4 + 114 Y5 + 50 Y6 <= 220 [Budget]

Y1 + Y3 + Y5 + Y6 >= 2 [Condition 1]

Y3 - Y5 = 0 [Condition 2]

Y1 + Y3 - 2 Y4 >= 0 [Condition 3]

Yj = {0,1}

Solution

Y3 = Y5 = 1 and Y1 = Y2 = Y4 = Y6 = 0 (i.e. project 3 and 5 are to be executed) and the total NPV = \$33 Million.

#### Earn Coins

Coins can be redeemed for fabulous gifts.