A brokerage firm has been tasked with investing exactly $100,000 for a new client. The client has asked that the broker select promising stocks and bonds for investing subject to the following guidelines: 1) At least 20% of the total investment should be in municipal bonds 2) At least 10% of the total investment should be in real estate stock 3) At least 10% of the total investment should be in domestic automobile stock 4) At least 40% of the total investment should be in combination of the amount invested in energy and pharmaceutical stocks. 5) The amount invested in a combination of real estate and pharmaceutical stock should be no more than 50% of the total amount that is invested in a combination of energy and automobile stocks Subject to these constraints, the client's goal is to maximize the projected return on investment. A list of potential investments are irn the table below ANNUAL RATE OF RETURN 5.3% 8.8% 4.9% 8.4% 10.4% INVESTMENT City of Miami (municipal) bonds American Smart Car GreenEarth E RealCo (real estate) Formulate this as an LP problem and solve in Excel. ANNUAL RATE OF RETURN 5.3% 8.8% 4.9% 8.4% 10.4% INVESTMENT ! City of Miami (municipal) bonds American Smart Car GreenEarth Energy Rosslyn Pharmaceuticals RealCo (real estate) Formulate this as an LP problem and solve in Excel. a) What is the total return for your investment strategy? b) How much should be invested ($) in each investment? c) Be sure to paste your Excel solution into this answer box for full/partial credit