Thanks a lot

Investment Plan Prod-Inv Tax-Free Return Amount Bond A B C D E Yield Maturity 9.5% Long 8.0% Short 9.0% Long 9.0% Long 9.0% Short Risk High Low Low High High Tax-Free Yes Yes No Yes No 80% Los A trust officer at the Blacksburg National Bank needs to determine how to in $100,000 in the following collection of bonds to maximize the annual retum Annual Bond Return Maturity Risk Tex Free A Long High Yes Short Low Yes c 9.01 Low No D 97% Lan High 9.09 Short Hich No min The officer wants to invest at least 50% of the money in short termine and more than 50 in high risk wes Atlas of the funds should go in investments, and at least 40% of the total annual return should be tax free Formulate an LP model for this problem Create a spreadshot model for the problem, and solve it using Solver What is the optimal solution? $100,000 > 550,000 C 350.000 > 330,000 40%