PLEASE USE EXCEL!!

1 Problem 2 (I5 Poins). Michael, Ine. is an investment advisory firm that uses an asset allocation model that 2 recommends the portion of each client's portfolio to be invested in a growth fund (G). 3 an income fund (I), and a money market fund ( M ). To maintain diversity in each client's portfolio, 4 the firm places limits on the percentage of each portfolio that may be invested in each of the three 5 funds. General guidelines indicate that the amount invested in the growth fund must be between 20% 6 and 40% of the total portfolio value. Similar percentages for the other two funds stipulate that 7 between 20% and 50% of the total portfolio value must be in the income fund and at least 30% of the 8 total portfolio value must be in the money market fund. 10 In addition, the company attempts to assess the risk tolerance of each client and adjust the portfolio to 11 meet the needs of the individual investor. A new client has $1,000,000 to invest, and Michael has 12 assigned the following risk constraint for this client: 0.05G+0.02I