this need to be solved using solver function.

Problem Statement: United Bank of Scotland has $2,500,000 in funds from a private investor that it just recelved. As a new account manager, your boss wants you to take this on as a hew assignment. The investor says she wants an asset allocation as follows: equities/stocks (expected 12% return), money market (2.5\% return) and bonds (5\% return). The investor indicates she is willing to take moderate risk, and therefore the max allocation to equities is capped at 45% of her total investment AND a minimum of 108 of the portfolio must be held in money market funds. A. What is the allocation of her portfolio in stocks, bonds and money market funds and what is her expected annual portfolio return? A. The investor is curioss what return a high risk allocation might provide. Under this scenario, a min of 5% of the porfolio must be invested in money market funds and the max allocation in stocks is raised to 60%. What is the new allocation and expected annual return? For this project, you will use Excels Solver function to do two very different types of problems, demonstrating the great versatility of this tool. As background, Solver is used to solve linear programming problems, which are a subject under a field called management decision science which dates back to at least the 1960s. Needless to say, management decision science pre-dates today's larger subject of analytics; it is even used at Maryvilie University in how it allocates classrooms each semester. The first scenario you will tackle is from finance and it involves portfolio allocation and how optimizing its return given certain constraints. The other scenario is from the world of sports business/marketing and involves allocation of a marketing budget to reach the maximum audience, again with constraints involved. You are to complete each of the problems on the worksheets below, documenting your work and save the file with your name at the end of the file name