A recent MBA graduate, Dara, has gained control over custodial accounts that her parents had established.

Currently, her money is invested in four funds, but she has identified several other funds as options for investment. She has $100,000 to invest with the following restrictions:

• Keep at least $5,000 in savings.

• Invest at least 14% in the money market fund.

• Invest at least 16% in international funds.
• Keep 35% of funds in current holdings.
• Do not allocate more than 20% of funds to any one investment except for the money market and savings account.
• Allocate at least 30% into new investments.
Average Return Expenses 1. Large cap blend 17.2% 0.93% (current holding)
2. Small cap growth 20.4% 0.56% (current holding)
3. Green fund 26.3% 0.70% (current holding)
4. Growth and income 15.6% 0.92% (current holding)
5. Multicap growth 19.8% 0.92%
6. Midcap index 22.1% 0.22%
7. Multicap core 27.9% 0.98%
8. Small cap international 35.0% 0.54%
9. Emerging international 36.1% 1.17%
10. Money market fund 4.75% 0 11. Savings account 1.0% 0

a. Develop a linear optimization model to maximize the net return.

b. Interpret the Sensitivity report.

c. Use Solver’s parameter-analysis method to investigate different assumptions about the portfolio constraints.

d. Summarize your results and write a short memo in nontechnical language to Dara.