A bank has $684,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 12%, mortgages 10.5%, car loans 11.5%, and personal loans 14.5%. To make sure the portfolio is not too risky, the bank wants to restrict personal loans to no more than the 25% of the total portfolio. The bank also wants to ensure that at least as much money is invested in mortgages as is invested in personal loans. The bank also wants to invest least as much in bonds as they do in personal loans. (Let X₁ X₂ X3, and X4 be the amount (in dollars) invested in bonds, mortgages, car loans, and personal loans, respectively.) (a) Formulate an LP model for this problem with the objective of maximizing the expected return (in dollars) on the portfolio. MAX: Subject to: total amount spent amount for personal loans mortgages and personal loans 0000 bonds and personal loans X₁ X₂ X3 X₂ 20 (b) Implement your model in a spreadsheet and solve it. What is the optimal solution? (X₁ X₂ X3x X₂) = ([

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 34P
icon
Related questions
Question
100%
A bank has $684,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 12%, mortgages 10.5%, car loans 11.5%, and personal loans 14.5%. To make sure the portfolio is not
too risky, the bank wants to restrict personal loans to no more than the 25% of the total portfolio. The bank also wants to ensure that at least as much money is invested in mortgages as is invested in personal loans. The bank also wants to invest at least as much in
bonds as they do in personal loans. (Let X₁, X₂, X3, and X4 be the amount (in dollars) invested in bonds, mortgages, car loans, and personal loans, respectively.)
(a) Formulate an LP model for this problem with the objective of maximizing the expected return (in dollars) on the portfolio.
MAX:
Subject to:
total amount spent
amount for personal loans
mortgages and personal loans
bonds and personal loans
X₁ X₂ X3 X4 ²0
(b) Implement your model in a spreadsheet and solve it. What is the optimal solution?
(X1₁ X₂ X3 X4) =
Transcribed Image Text:A bank has $684,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 12%, mortgages 10.5%, car loans 11.5%, and personal loans 14.5%. To make sure the portfolio is not too risky, the bank wants to restrict personal loans to no more than the 25% of the total portfolio. The bank also wants to ensure that at least as much money is invested in mortgages as is invested in personal loans. The bank also wants to invest at least as much in bonds as they do in personal loans. (Let X₁, X₂, X3, and X4 be the amount (in dollars) invested in bonds, mortgages, car loans, and personal loans, respectively.) (a) Formulate an LP model for this problem with the objective of maximizing the expected return (in dollars) on the portfolio. MAX: Subject to: total amount spent amount for personal loans mortgages and personal loans bonds and personal loans X₁ X₂ X3 X4 ²0 (b) Implement your model in a spreadsheet and solve it. What is the optimal solution? (X1₁ X₂ X3 X4) =
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,