Question

In: Operations Management

The board of directors of General Wheels Co. is considering seven large capital investments. Each investment...

The board of directors of General Wheels 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.

Investment opportunity

Estimated profit ($million)

Capital required ($million)

1

$17

$43

2

$10

$28

3

$15

$34

4

$19

$48

5

$7

$17

6

$13

$32

7

$9

$23

The total amount of capital available for these investments is $100 million. Investment opportunities 1 and 2 are mutually exclusive (i.e., they cannot be chosen simultaneously), and so are 3 and 4. Furthermore, 5 can be undertaken only if both 1 and 3 are taken. Opportunity 7 has to be chosen if both 2 and 4 are selected, and Opportunity 7 cannot be invested unless at least one of 5 and 6 is invested. The objective is to select the combination of capital investments that will maximize the total estimated long-run profit (net present value). Formulate this problem as an integer programming model.

Decision variables (1 mark):

Objective function (1 mark):

Constraints (7 mark):

Solutions

Expert Solution

Answer: We will formulate the given problem as an integer programming model as mentioned below:

Decision Variable:

Let Decision Variables:

X1 = 1 If Investment Opportunity 1 is selected, 0 otherwise,

X2 = 1 If Investment Opportunity 2 is selected, 0 otherwise,

X3 = 1 If Investment Opportunity 3 is selected, 0 otherwise,

X4 = 1 If Investment Opportunity 4 is selected, 0 otherwise,

X5 = 1 If Investment Opportunity 5 is selected, 0 otherwise,

X6 = 1 If Investment Opportunity 6 is selected, 0 otherwise, and

X7 = 1 If Investment Opportunity 7 is selected, 0 otherwise.

Objective Function:

Here, an objective is to maximize the total estimated long-run profit. Hence, the objective function:

Maximize Z = 17 X1 + 10 X2 + 15 X3 + 19 X4 + 7 X5 + 13 X6 + 9 X7

Subject to Constraints:

C1 = 43 X1 + 28 X2 + 34 X3 + 48 X4 + 17 X5 + 32 X6 + 23 X7 ≤100 (Total Amount of Capital Available)

C2 = X1 + X2 = 1 (Opportunities 1 and 2 can not be chosen symultanously)

C3 = X3 + X4 = 1 (Opportunities 3 and 4 can not be chosen symultanously)

C(4-a) = 2 X5 X1 + X3 (Opportunity 5 can be taken only if Opportunites 1 and 3 both are under taken), or

C(4-b) = X5 X1 + X3 - 1 (Opportunity 5 can be taken only if Opportunites 1 and 3 both are under taken)

C(5-a) = X2 + X4 2 X7 (Opportunity 7 has to be chosen if, Opportunites 2 and 4 both are under taken), or

C(5-b) = X2 + X4 - 1 X7 (Opportunity 7 has to be chosen if, Opportunites 2 and 4 both are under taken)

C6 = X7 X5 + X6 (Opportunity 7 can not be chosen unless at least one of Opportunity 5 and 6 is chosen)

Where X1, X2, X3, X4, X5, X6, X7 ∈ {0, 1}


Related Solutions

Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each investment...
Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each investment has a useful life of five (5) years. Consider the profit for the following three alternative investment options: Discount Factor Project A Project B Project C Capital Investment $175,000 $195,000 $205,000 Annual Profit:     Year 1 0.86957 $15,500 $21,000 $25,000     Year 2 0.75614 15,500 19,500   23,000     Year 3 0.65752 15,500 17,000 20,500     Year 4 0.57175 15,500 15,500 17,000     Year 5...
The Board of Directors of Potato Pave Inc. (PPI) is considering a $10 million dollar investment...
The Board of Directors of Potato Pave Inc. (PPI) is considering a $10 million dollar investment in new molecular biology technology that will enable PPI to, if successful, grow and produce potato plants of improved varieties and at a faster rate compared to conventional potato farming technologies. The successful implementation of this new technology is expected to bring in $100 million for PPI, and the likelihood of such success is 25%. There is a 5% chance the technology will ravage...
The Board of Directors of Potato Pave Inc. (PPI) is considering a $10 million dollar investment...
The Board of Directors of Potato Pave Inc. (PPI) is considering a $10 million dollar investment in new molecular biology technology that will enable PPI to, if successful, grow and produce potato plants of improved varieties and at a faster rate compared to conventional potato farming technologies. The successful implementation of this new technology is expected to bring in $100 million for PPI, and the likelihood of such success is 25%. There is a 5% chance the technology will ravage...
4. Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each...
4. Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each investment has a useful life of five (5) years. Consider the profit for the following three alternative investment options: Discount Factor Project A Project B Project C Capital Investment $175,000 $195,000 $205,000 Annual Profit:     Year 1 0.86957 $15,500 $21,000 $25,000     Year 2 0.75614 15,500 19,500   23,000     Year 3 0.65752 15,500 17,000 20,500     Year 4 0.57175 15,500 15,500 17,000     Year...
4. Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each...
4. Relaxation Resorts Inc. is a large company that is considering three long-term capital investments. Each investment has a useful life of five (5) years. Consider the profit for the following three alternative investment options: Discount Factor Project A Project B Project C Capital Investment $175,000 $195,000 $205,000 Annual Profit:     Year 1 0.86957 $15,500 $21,000 $25,000     Year 2 0.75614 15,500 19,500   23,000     Year 3 0.65752 15,500 17,000 20,500     Year 4 0.57175 15,500 15,500 17,000     Year...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors set the maximum requirements of return of pay back 3 years and has set the cost of capital is 10%, below is the cash flow: CF1= $75,800 , CF2= $78,960 , CF3= $82,278, CF4= $117,612. Would you accept the project based on NPV, IRR? Would you accept the project based on Payback rule if project cut-off period is 3 years? How would you explain...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors set the maximum requirements of return of pay back 3 years and has set the cost of capital is 10%, below is the cash flow: CF1= $75,800 , CF2= $78,960 , CF3= $82,278, CF4= $117,612. (15') Would you accept the project based on NPV, IRR? (4') Would you accept the project based on Payback rule if project cut-off period is 3 years? (3') How...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors...
C&P Trading Inc. is considering a project, initial investment is $260,000. The company board of directors set the maximum requirements of return of pay back 3 years and has set the cost of capital is 10%, below is the cash flow: CF1= $75,800 , CF2= $78,960 , CF3= $82,278, CF4= $117,612. (15') Would you accept the project based on NPV, IRR? (4') Would you accept the project based on Payback rule if project cut-off period is 3 years? (3') How...
Morten Co. is experiencing a slowdown in their operations. The Board of Directors believe it is...
Morten Co. is experiencing a slowdown in their operations. The Board of Directors believe it is reasonably possibly that they will have to terminate the current Chief Executive Officer (CEO) as a result. If that comes to pass, the company will be required to pay a severance package per the CEO’s employment contract including: $60,000 cash upon termination; Another $30,000 to be paid one year following termination; Cash payments of $18,000 to be paid each year for 5 years. Required:...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income...
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $63,000 $205,000 $132,000 $328,000 2 63,000 205,000 101,000 277,000 3 63,000 205,000 50,000 195,000 4 63,000 205,000 22,000 133,000 5 63,000 205,000 10,000 92,000 Total $315,000 $1,025,000 $315,000 $1,025,000 Each project requires an investment of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT