An investor wants to invest $50,000 in two mutual funds, A and B. The rates of return, risks and minimum investment requirements for each fund are: Note that a low Risk rating means a less risky investment. The investor can invest to maximize the expected rate of return or minimize risk. Any money beyond the minimum investment requirements can be invested in either fund.
The following is the multi-objective linear programming (MOLP) formulation for this problem: The solution for the second LP is (X₁, X₂) = (20,000, 30,000).
Based on this solution, what values should go in cells B2:D11 of the spreadsheet?

Question

An investor wants to invest $50,000 in two mutual funds, A and B. The rates of return, risks and minimum investment requirements for each fund are:

Note that a low Risk rating means a less risky investment. The investor can invest to maximize the expected rate of return or minimize risk. Any money beyond the minimum investment requirements can be invested in either fund.
The following is the multi-objective linear programming (MOLP) formulation for this problem:

The solution for the second LP is (X₁, X₂) = (20,000, 30,000).
Based on this solution, what values should go in cells B2:D11 of the spreadsheet?

Quizplus · Accepted Answer

The Answer of An investor wants to invest $50,000 in two mutual funds, A and B. The rates of return, risks and minimum investment requirements for each fund are: Note that a low Risk rating means a less risky investment. The investor can invest to maximize the expected rate of return or minimize risk. Any money beyond the minimum investment requirements can be invested in either fund. The following is the multi-objective linear programming (MOLP) formulation for this problem: The solution for the second LP is (X₁, X₂) = (20,000, 30,000). Based on this solution, what values should go in cells B2:D11 of the spreadsheet?

An Investor Wants to Invest $50,000 in Two Mutual Funds