please use excel to explain it. I also need formula solver. How to caculate "Amount invested"?

A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Maturity Risk Annual Return 9.5% 8.0% 9.0% 9.0% 9.0% Long Short B Tax Free Yes Yes No Yes No High Low Low High High Long D E Long Short The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the