Preview

Quantitative Methods in Business – Linear Programming

Good Essays
Open Document
Open Document
830 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Quantitative Methods in Business – Linear Programming
Quantitative Methods in Business – Linear Programming
1- Statement of the Problem:
Middle East for investment offers a bundle of investment options in many types of securities.
Mr. Brown, an investor, would like to invest $ 5 million in various securities. He wishes to maximize his yearly profit over the next year. The investment company offered him a portfolio including Bonds, Stocks, Gold and Land. The expected return is 6% for Bonds, 14% for Stocks, 10% for Gold and 5% for Land. For diversification purposes, the maximum amount to be invested is $ 3 million in Bonds, $ 3 million in Stocks, $ 2 million in Gold and $ 1 million in Land. In addition to that, the investment company specifies that at least 40% of the total investment should be in Bonds and Stocks, and no more than 20% of the total investment should be in land.

2- Formulation:
The decision variables are:
B= Total Dollar amount to be invested in Bonds.
S= Total Dollar amount to be invested in Stocks.
G= Total Dollar Amount to be invested in Gold.
L= Total Dollar Amount to be invested in Land.

The objective function that maximizes the return per year is:
Z= 0.06B+0.14S+0.1G+0.05L
Subject to:
1) B+S+G+L≤5,000,000
2) B≤3,000,000
3) S≤3,000,000
4) G≤2,000,000
5) L≤1,000,000
6) B+S≥0.40(B+S+G+L)
→ B+S≥0.4B+0.4S+0.4G+0.4L
→ 0.6B+0.6S-0.4G-0.4L≥0
7) L ≤0.2(B+S+G+L)
→L ≤0.2B+0.2S+0.2G+0.2L
→ -0.2B-0.2S-0.2G+0.8L ≤0
Given that B; S; G and L are positive values
3- POM-QM Output:

4- Analysis:

 That is, Mr. Brown needs to invest $ 3 million in stocks and $ 2 million in Gold. The total return would be $ 620,000 and the total return on investment (ROI) would be:
Total return/Total amount invested= 620,000/5,000,000= 12.4%
 The reduced cost for the amount invested in Bonds (B), which is at zero level, is 0.04 (4%). This means that the expected return on Bonds should increase by 4% (from 6% to 10%) in order for B to become non-zero.

The reduced

You May Also Find These Documents Helpful

  • Satisfactory Essays

    b. You invest $100 in stocks and sell them one year later for $115. Use the instructions in Lesson 3 to calculate the ROI dollar amount and percentage. (2.0 points)…

    • 354 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acc/531 Week 3

    • 790 Words
    • 4 Pages

    A portfolio is formed as follows: sell short $1,000 of Stock 1; buy $1,500 of Stock 2; buy $1,500 of Stock 3. The investor uses $1,000 of his own equity, with the remaining amount borrowed at a risk-free interest rate of 4% (with continuous compounding).…

    • 790 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acct2 13456789

    • 2315 Words
    • 20 Pages

    Bill Dunn made an investment on July 1, 2007 which earned $9,000 and a 12% return on July 1, 2008. How much did Bill invest?…

    • 2315 Words
    • 20 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hrm/531 Week 1

    • 774 Words
    • 4 Pages

    In November 2007 you bought 100 shares of Microsoft stock for $35.375 a share. In November 2009 you sold your stock for $92.5625 a share. What was your average annual rate of return on your Microsoft investment? (disregard dividends and commissions)…

    • 774 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    The investor decides to construct a complete portfolio with the optimal risky portfolio and risk free asset and decides to allocate 35% of the total investment in risk free asset and 65% of the total investment in the risky portfolio.…

    • 1422 Words
    • 7 Pages
    Good Essays
  • Good Essays

    34. You have compiled the following information on your investments. What rate of return should you expect to earn on this portfolio?…

    • 497 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Fin 419

    • 805 Words
    • 4 Pages

    P5–3 Risk preferences Sharon Smith, the financial manager for Barnett Corporation, wishes to evaluate three prospective investments: X, Y, and Z. Currently, the firm earns 12% on its investments, which have a risk index of 6%. The expected return and expected risk of the investments are as follows:…

    • 805 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    assignment 4

    • 374 Words
    • 2 Pages

    8. Calculate the return on investment in dollars and as a percentage for an investment that you purchase for $500 and sell for $600. (2.0 points) TIP: If you don't remember how to calculate return on investment, review the Calculating ROI pages in Section 4, Lesson 2.…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Cost Benefit Analysis

    • 539 Words
    • 3 Pages

    e. Return on investment after six months (assume half of the employees/but all of the cost) (5 points)…

    • 539 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    5. Consider the country diversification of funds assets. Identify the countries in which the funds in most heavily invested. Speculate as to why this might be the case. Are there any countries in which you would have expected the fund to be more heavily invested than it is? Are there any countries in which you would have expected the fund to be invested and it is not?…

    • 825 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The first step is to develop a linear programming model for maximizing return subject to constraints…

    • 332 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    problem set 4

    • 441 Words
    • 5 Pages

    (c) If choosing between investing all her capital in asset 2 or in the equally…

    • 441 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    vii) Redo part (vi) but now constrain the minimum and maximum weights on the seven different asset classes using the constraints shown in Exhibit 13. It may not be possible to achieve some of the expected real returns you were getting earlier. If that is the case, use five expected real return levels that you can attain.…

    • 394 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Equity Method: Exercise

    • 754 Words
    • 4 Pages

    (d) At the end of the first year, A sells 30% of its investment for $9000. (Make ‘T’ acct & take 30% of the total in the account at end of year… = $…

    • 754 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    linear programming

    • 354 Words
    • 2 Pages

    Spreadsheet Modeling and Excel Solver A mathematical model implemented in a spreadsheet is called a spreadsheet model. Major spreadsheet packages come with a built-in optimization tool called Solver. Now we demonstrate how to use Excel spreadsheet modeling and Solver to find the optimal solution of optimization problems. If the model has two variables, the graphical method can be used to solve the model. Very few real world problems involve only two variables. For problems with more than two variables, we need to use complex techniques and tedious calculations to find the optimal solution. The spreadsheet and solver approach makes solving optimization problems a fairly simple task and it is more useful for students who do not have strong mathematics background. The first step is to organize the spreadsheet to represent the model. We use separate cells to represent decision variables, create a formula in a cell to represent the objective function and create a formula in a cell for each constraint left hand side. Once the model is implemented in a spreadsheet, next step is to use the Solver to find the solution. In the Solver, we need to identify the locations (cells) of objective function, decision variables, nature of the objective function (maximize/minimize) and constraints. Example One (Linear model): Investment Problem Our first example illustrates how to allocate money to different bonds to maximize the total return (Ragsdale 2011, p. 121). A trust office at the Blacksburg National Bank needs to determine how to invest $100,000 in following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax-Free A B C D E 9.5% 8.0% 9.0% 9.0% 9.0% Long Short Long Long Short High Low Low High High Yes Yes No Yes No The officer wants to invest at least 50% of the money in short term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total return should be…

    • 354 Words
    • 2 Pages
    Satisfactory Essays