Assignment 1. linear programming case study

 

Your instructor will assign a linear programming project for this assignment according to the following specifications.

It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won’t have alternate optimal solutions). The problem will also include a component that involves sensitivity analysis and the use of the shadow price.

You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work.

Writeup.

Your writeup should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.

After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel. Explain what the results mean.

Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.

Excel.

As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results.

Click here to view the grading rubric for this assignment.

Week 8 Project

You are a portfolio manager for the XYZ investment fund.  The objective for the fund is to maximize your portfolio returns from the investments on four alternatives.  The investments include (1) stocks, (2) real estate, (3) bonds, and (4) certificate of deposit (CD).  Your total investment portfolio is $1,000,000.  

Investment Returns

Based on the returns from the past five years, you concluded that the investment annual returns on stocks are 10%, on real estates are 7% on bonds are 4% and on CD is 1%.  

Risk Constraints

However, you also have to analyze the risks associate with each investment category.  A wildly used risk measurement parameter is called Value at Risk (VaR).  (Note: VaRmeasures the risk of loss on a specific portfolio of financial assets.)  For example, givena million dollar stock investmentif a portfolio of stocks has a one-day 4VaR, there is a 5% probability that the stock portfolio will fall in value by more than 1,000,000 * 0.04 = $40,000 over a one day period.  In the portfolio, the VaR for stock investments is 6%.  Similarly, the VaR for real estate investment is 2% and the VaR for bond investment is 1% and the VaR for investment in CD is 0%.  To manage the portfolio, you decided that at 5% probability, your VaR for stocks cannot exceed $25,000, VaR for real estate cannot exceed $15,000, VaR for bonds cannot exceed $2,500 and the VaR for CD investment is $0. 

Diversification and Liquidity Constraints

As a diversified investment portfolio, you also decided that each investment category must hold at least $50,000 of the total investment assets.  In addition, you must hold combined CD and bond investment no less than $200,000 in order to meet liquidity requirement.

The total amount of real estate holding shall not exceed 30% of the portfolio assets.

A. As a portfolio manager, please formulate and solve the investment portfolio problem using linear programming technique.  What are the amounts invest in (1) stocks, (2) real estate, (3) bonds and (4) CD?

B. If $500,000 additional investments are available to you in your portfolio, how would you invest the capital? 

C. Would you maintain the portfolio investment if stock yields lowered to 6%?  How would you re-distribute your investment portfolio? 

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more