Solve this in excel using the provide template, answer the questions and guide me how to set it up in excel.

Use this problem to answer Questions 10 - 13 A trust officer at the Blacksburg Mational Bank needs to determine how to invest 5100,000 in the following collection of bonds to maximize the total annual return (before tax). Bond Annual Return Maturity Risk Tax-Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low Mo D 9.0% Long High Yes E 9.0% Short High Mo 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 in tax-free investments, and at least 40% of the total annual return should be tax free. Suppose the decision variable X; represents the amount of money invested inbond i fori = 4, B, ..., E. Formulate a linear programming (LP) model to solve the optimal strategy. (10} (1 point) Write down the constraint using the defined decision variables requiring "invest at least 50% of the money in short-term issues\". {11} (1 point) Write down the constraint using the defined decision variables requiring \"at least 30% of the funds should go in tax-free investments\". (12) (1.5 points) Solve the optimal strategy using the preliminary spreadsheet \"Investment LP.xlsx". What is the optimal objective value in dollars: Objective value= {13) (0.5 points) Upload your spreadsheet model with the optimal solution and answer report. A B G Data Bond Return Maturity Risk Tax-Free A 9.50% Long High CO 8.00% Short Low Yes C 9.00% Long Low No D 9.00% Long High Yes m 9.00% Short High No Bond A B C D E Total budget Percentage in short-term bonds Percentage in high-risk bonds 14 Percentage in tax-free bonds Percentage of total tax-free return Return 9.50% 8.00% 9.00% 9.00% 9.00% 18 Decision variable 19 A B C D E Amount allocated (Dollars) 21 Constraints LHS sign RHS Total budget 25 Percentage in short-term bonds Percentage in high-risk bonds Percentage in tax-free bonds Percentage of total tax-free return Objective function Maximize