1. A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return.

Bond	Annual Return	Maturity	Risk	Tax-Free
A	9.5%	Long	High	Yes
B	8.0%	Short	Low	Yes
C	9.0%	Long	Low	No
D	9.0%	Long	High	Yes
E	9.0%	Short	High	No

The officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go into tax-free investments and at least 40% of the total annual return should be tax-free.

1. Formulate an LP model for this problem.
2. Create a spreadsheet model for this problem and solve it using Solver.
3. What is the optimal solution?
4. Generate Sensitivity, Answer and Limit reports and interpret the results.

Please provide screenshots of your Excel worksheet, the final result and the formulas used so i can solve it on my own as well.