In excel please

part a) For the application described above, develop a complete |.P model below, with decision variables, objective function and constraints. part b) Proceed to create a spreadsheet model part c) Solve the LP for the optimal solution and provide the optimal solution here |:| A trust ofcer at the Sunrise 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.50% Long High Yes B 8% Short Low Yes C 9% Long Low No D 9% Long High Yes E 9% Short High No