Question

In: Operations Management

Energy Management Corporation (EMC) must decide its level of capital investment in the six energy ventures...

Energy Management Corporation (EMC) must decide its level of capital investment in the six energy ventures described below. EMC wishes to maximize its total expected return on a maximum total investment of $10,000,000. At least half of this must be in the United States, including Alaska. No more than 20% can be in sour crude and coal investments. In addition, allocations must at least meet the minimums specified in column three below. For example, investment in Wyoming Coal must be at least $1,000,000.

Venture (Location)

Expected Return

Minimum Investment

Primary Product

Wyoming Coal

75%

$1,000,000

Coal

Colorado Shale

62%

$400,000

Sour crude

Prudhoe Bay Alaska

125%

$1,000,000

Sweet crude

Mexico

135%

None

Sweet crude

Alberta Tar Sands

80%

None

Sour crude

Virginia Coal

85%

$300,000

Coal

1. Formulate the linear programming model. Clearly state your decision variables, objective function and all constraints. Use fractions rather than percentages in your formulation of the objective function.

2. Solve the model using Microsoft Excel Solver. Attach the Microsoft Excel file as part of your submission.

3. Interpret the results from Microsoft Excel Solver, including the Sensitivity Report. What aspects of the computer-generated strategy are you in agreement with (based on a consideration of the sensitivity data)? What aspects of it would you disagree with? Why?

Solutions

Expert Solution

1) Linear program model is following:

Decision variables:

Let W be the amount ($million) to be invested in Wyoming Coal

C be the amount ($million) to be invested in Colorado Shale

P be the amount ($million) to be invested in Prudhoe Bay Alaska

M be the amount ($million) to be invested in Mexico

A be the amount ($million) to be invested in Alberta Tar Sands

V be the amount ($million) to be invested in Virginia Coal

Objective function:

Max .75W+.62C+1.25P+1.35M+.8A+.85V (total expected return)

Constraints:

W+C+P+M+A+V <= 10 (maximum total investment of $ 10 million)

W+C+A+V <= 2   (no more than 20% =.2*10 = $ 2m of the total investment can be in sour crude and coal)

W+C+P+V >= 5        (at least half =10*.5 = $ 5m of the total investment should be US including Alaska)

W >= 1   (minimum investment of $ 1 million in Wyoming Coal)

C >= 0.4   (minimum investment of $ 0.4 million in Colorado Shale)

P >= 1   (minimum investment of $ 1 million in Prudhoe Bay Alaska)

V >= 0.3   (minimum investment of $ 0.3 million in Virginia Coal)

W,C,P,M,A,V >= 0

2) Solution using Excel Solver is following:

Step 1: Create Excel model

Step 2: Enter Solver parameters:

Step 3: Click Solve button to generate the optimal solution:

3) Results:

Following amounts should be invested

Venture (Location) Investment ($ million)
Wyoming Coal 1
Colorado Shale 0.4
Prudhoe Bay Alaska 3.3
Mexico 5
Alberta Tar Sands 0
Virginia Coal 0.3
Total 10

After obtaining the solution, On the Solver Results notification window, Select Sensitivity report and click Ok to generate sensitivity report as follows:

I agree with the constraints which have non-negative shadow prices, because these are binding constraints


Related Solutions

The management of Sugar Daddy Cupcakes are analyzing two competing investment projects and must decide which...
The management of Sugar Daddy Cupcakes are analyzing two competing investment projects and must decide which one should be done immediately and which one to postpone for at least a year. The details of each proposed investment are provided below. The company has a 12% required rate of return to evaluate all investments that directly impact operations and amortizes the investment in plant and equipment using straight-line depreciation over 10 years. The company’s tax rate is 25%. The CCA rate...
Dell had its management buyout in 2013. Dell, as a private company, acquired EMC, a publicly...
Dell had its management buyout in 2013. Dell, as a private company, acquired EMC, a publicly listed company, for $67 billion; the deal closed in September 2017. What are the synergy benefits and challenges for Dell and EMC since this acquisition? (List all 5 benefits and challenges)
The management of Ethan plc is trying to decide on a cost of capital to apply...
The management of Ethan plc is trying to decide on a cost of capital to apply to the evaluation of investment projects. The company has an issued share capital of 500,000 ordinary K1 shares, with a current market value cum-div of K1.17 per share. It has also issued K200,000 of 10% debentures, which are redeemable at par in five years’ time and have a current market value of K105.30 cum-interest, and K100,000 of K1 irredeemable 6% preference shares, currently priced...
The management of Ethan plc is trying to decide on a cost of capital to apply...
The management of Ethan plc is trying to decide on a cost of capital to apply to the evaluation of investment projects. The company has an issued share capital of 500,000 ordinary K1 shares, with a current market value cum-div of K1.17 per share. It has also issued K200,000 of 10% debentures, which are redeemable at par in five years’ time and have a current market value of K105.30 cum-interest, and K100,000 of K1 irredeemable 6% preference shares, currently priced...
2 The management of Ethan plc is trying to decide on a cost of capital to...
2 The management of Ethan plc is trying to decide on a cost of capital to apply to the evaluation of investment projects. The company has an issued share 'capital of 500,000 ordinary $l shares, with a current market value cum-div of $l.17 per share. It has also issued $200,000 of 10 debentures, which are redeemable at par in five years' time and have a current market value of$105.30 cum-interest, and $lOO,OOO of $l irredeemable 6 preference shares, currently priced...
Bayshore Investment Corporation employs a cost of capital rate of 12% for all capital investment and...
Bayshore Investment Corporation employs a cost of capital rate of 12% for all capital investment and has prepared the following analysis for four projects for the upcoming year: Project 1 Project 2 Project 3 Project 4 Initial Investment $400,000 $596,000 $496,000 $544,000 Net Present Value ($7,596) $8,552 $28,128 $29,324 Internal Rate of Return 11% 13% 14% 15% Which project(s) should Bayshore Investment Corporation undertake during the upcoming year based on a budget of $1,200,000? (A) Projects 1 and 3 (B)...
Pfizer Corporation announced a new capital investment program., and its stock price increased.
Pfizer Corporation announced a new capital investment program., and its stock price increased. Western Digital Corporation (a disk-drive maker) announced a new capital investment program, and its stock price decreased. How do you explain these opposing responses? what should a company that is considering a new capital investment conclude from this evidence?
If Infosys Technologies investment in human capital is a core strategic investment, surely it must be...
If Infosys Technologies investment in human capital is a core strategic investment, surely it must be on the company’s balance sheet, where is it on the company’s audited balance sheet? If is it not there, why is it not there? Should it be there
Suppose that firms decide to increase their investment in physical capital. Use the model of the...
Suppose that firms decide to increase their investment in physical capital. Use the model of the market for loanable funds in an open economy to answer the following questions. Be sure to use the appropriate graphs to illustrate the answer. a) What happens to the quantities of national savings, private savings, and public savings? b) What happens to the real interest rate, the quantity of investment, and the quantity of net capital outflows? c) What happens to the real exchange...
Your supervisor is on the company’s capital investment decision team that is to decide on alternatives...
Your supervisor is on the company’s capital investment decision team that is to decide on alternatives for the acquisition of a new computer system for the company. The supervisor says, “The book value of the existing computer system for the firm that we are considering replacing is nothing but an accounting amount and as such is irrelevant in the capital expenditure analysis.” Does this reasoning make sense? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT