please help me and show me the steps I need to use Excel and Solver to answer the question.

3. A brokerage firm has been tasked with investing $500,000 for a new client. The client has asked that the broker select promising stocks and bonds for investment, subject to the following guidelines: at least 20% in municipal bonds, at least 10% each in real estate and pharmaceutical stock, and at least 40% in a combination of energy and domestic automobile stocks with each accounting for at least 15%. The retums are as follows: Municipal = 5.3%, Domestic Automobile = 8.8%, Energy = 4.9%, Pharmaceuticals = 8.4% and Real Estate = 10.4%. a) Write a linear program complete with objective function and all constraints to maximize the retum. (8 points) b) What is the optimal solution? Give values for all variables rounded to the nearest cent. (5 points) c) How much annual income does the optimal solution generate? (2 points)