how to solve this problem using excel - SOLVER FUNCTION with simplex solver method

2- Theo Harris earns S55000 a year and has $9000 to invest in a portfolio. His investment alternatives and their expected returns are shown in the table at the top of the next column Investment Description IRA (retirement) Employer's retirement plan Deferred income (retirement) Unity mutual fund Liberty mutual fund Monev market Expected return 3.5% 4.5% 890 7% 7.5% 5.5% Theo's investment goals are as follows and can be ranked according to the weights showin in parenthesis. Which investments should be included in Theo's portfolio, and how much should he invest in each? Goal 1: (25) Invest all funds available Goal 2: (20) Maximize the total annual return in dollars, with a target of $1000 Goal 3: (15) Invest at least 3% of salary in employer's retirement plan Goal 4: (15) Invest at least 10% of the total investment in the money market Goal 5: (10) Invest at most 25% of the total investment in retirement plans Goal 6: (10) Invest at least 50% of the total investment in non-retirement plans Goal 7: (5) Invest at most 50% of the total investment in mutual funds Which investments should be included in John's portfolio? 2- Theo Harris earns S55000 a year and has $9000 to invest in a portfolio. His investment alternatives and their expected returns are shown in the table at the top of the next column Investment Description IRA (retirement) Employer's retirement plan Deferred income (retirement) Unity mutual fund Liberty mutual fund Monev market Expected return 3.5% 4.5% 890 7% 7.5% 5.5% Theo's investment goals are as follows and can be ranked according to the weights showin in parenthesis. Which investments should be included in Theo's portfolio, and how much should he invest in each? Goal 1: (25) Invest all funds available Goal 2: (20) Maximize the total annual return in dollars, with a target of $1000 Goal 3: (15) Invest at least 3% of salary in employer's retirement plan Goal 4: (15) Invest at least 10% of the total investment in the money market Goal 5: (10) Invest at most 25% of the total investment in retirement plans Goal 6: (10) Invest at least 50% of the total investment in non-retirement plans Goal 7: (5) Invest at most 50% of the total investment in mutual funds Which investments should be included in John's portfolio