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

question 65

Essay

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?

---

Definitions:

Earth Day

An annual event aimed at promoting environmental awareness and conservation practices, celebrated on April 22.

Proved Reserves

Specific mineral deposits that have been shown by scientific examination and cost calculation to be extractable and deliverable to the market for use, with current technology and expected market conditions.

Mineral

A naturally occurring, inorganic solid with a definite chemical composition and crystalline structure, used in various industries.

Conservation

The sustainable management and use of natural resources to prevent depletion or degradation, safeguarding biodiversity and ecosystems.