Ask Operation Research Expert

Linear Programming : Sensitivity analysis and interpretation

Use Excel

Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of clients. A particular portfolio consists of U shares of U.S. Oil and H shares of Huber Steel. The annual return for U.S. Oil is $3 per share and the annual return for Huber Steel is $5 per share. U.S. Oil sells for $25 per share and Huber Steel sells for $50 per share. The portfolio has $80,000 to be invested. The portfolio risk index (0.50 per share U.S. Oil and 0.25 per share for Huber Steel) has a maximum of 700. In addition, the portfolio is limited to a maximum of 1000 shares of U.S. Oil. The linear programming formulation that will maximize the total annual return of the portfolio is as follows:

Max z = 3U + 5H

Subject to:

25U + 50H ≤ 80,000 Funds available

0.50U + 0.25H ≤ 700 Risk maximum

1U ≤ 1000 U.S. Oil maximum

U, H ≥ 0

Solve the problem using Excel Solver.

a) What is the optimal solution, and what is the value of the total annual return?

b) Which constraints are binding? What is your interpretation of these constraints in terms of the problem?

c) What are the shadow prices for the constraints? Interpret each.

d) Would it be beneficial to increase the maximum amount invested in U.S. Oil? Why or why not?

Operation Research, Management Studies

  • Category:- Operation Research
  • Reference No.:- M924968

Have any Question?


Related Questions in Operation Research

Real estate property analysisresearch the property you

Real Estate Property Analysis Research the property you selected in your Local Real Estate Opportunities activity. Using the newspaper listing from your exploration, either go online to the real estate agency that is lis ...

Explain the mathematical system of or and linear

Explain the Mathematical system of OR and linear programming

Assignment - country analysis this is a marketing and

Assignment - Country Analysis This is a marketing and analysis paper on two countries, South Korea and India. The objective is to determine if both countries are a great market for TESLA to expand their business in a glo ...

Assignment requirementassignment reflective writing aims to

Assignment Requirement Assignment Reflective writing aims to get you to think about your learning and understand your learning experiences. When students writing Assignment 3 need to follow steps: 1. Evaluate the effecti ...

Your presentation should include the followingintroduction

Your presentation should include the following: Introduction (5-6 slides) Explain the importance of evidence-based decision making in health care. Discuss how this evidence applies to patient care outcomes, financial out ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As