Please be sure that all answer cells contain any necessary formulas to be eligible for full credit. Which means show work in excel.

A portfolio manager wants to get the most return for clients while diversifying risk. The manager can invest funds in stocks, mutual funds, gold, bonds, or cryptocurrency. The estimated returns for each of the investment options are 15%, 12%, 10%, 7%, and 18%, respectively. Of the $10M available for investment, at least $2M must be invested in mutual funds. A maximum of $1M can be invested in cryptocurrency. At least 30% of the investment should be made in gold and bonds and at least 25% should be invested in stocks.

a. Solve the linear program using Solver and write the strategy.

b. Run a sensitivity analysis and identify the constraints that are binding.

c. What is the change in the objective function value if at least $3M must be invested in mutual funds and a maximum of $500K can be invested in cryptocurrency?