USE EXCEL SOLVER FOR THIS QUESTION AND SET IT UP LIKE THE EXCEL I SET UP

I do not know where to put 1's on the following worksheet

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 at least 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.

Develop a linear optimization model to maximize the net return. Interpret the sensitivity report.

1. Large cap blend 2. Small cap growth 3. Green fund 4. Growth and income 5. Multicap growth 6. Midcap index 7. Multicap core 8. Small cap international 9. Emerging international 10. Money market fund 11. Savings account (current holding) (current holding) (current holding) (current holding) Average Return 17.2% 20.4% 26.3% 15.6% 19.8% 22.1% 27.9% 35.0% 36.1% 4.75% 1.0% Expenses 0.93% 0.56% 0.70% 0.92% 0.92% 0.22% 0.98% 0.54% 1.17% 0 0 Investment Allocations Decision variables Investment Invest. 6 Invest. 7 Invest. 1 Invest. 2 Invest. 3 Invest. 4 Invest. 5 Invest. 8 Invest. 9 Invest. 10 Invest. 11 Investment plan 20.4% 1.0% Objective function Average Return 17.2% Expenses 0.93% Net return 16.27% 0.56% 19.84% 26.3% 0.70% 25,60% 15.6% 0.92% 14.68% 19.8% 0.92% 18.88% 22.1% 0.22% 21.88% 27.9% 0.98% 26.92% 35.0% 0.54% 34.46% 36.1% 1.17% 34.93% 4.75% 0 0 4.75% 0 1.00% Total $0.00 LHS RHS 1 0 >= 5000 14000 1 > 0 0 1 1 >= 16000 1 1 1 1 0 > 35000 1 1 1 1 1 1 1 0 > 30000 0