[-/6 Points] RAGSMDA9 3.E.020. (x1,x2,x3,x4)=( A bank has $568,000 in assets to allocate among investments in bonds, home mortgages, car loars, and personal loans. Bonds are expected to produce a return of 11%, mortgages 9,5%, car loans 10.5%, and personal loans 13.5%. To make sure the portfolio is not too risky, the bank wants to restrict personal loans to no mere than the 25% of the total portfolio. The bank aiso wants to ensure that at least as much money is invested in mortgages as is invested in personal loans. The bark also wants to invest at least as much in bonds as they do in personsl loans. (Let x1,x2,x3, and x4 be the amount (in doliars) invested in bonds, mortgages, car loans, and personal loans, respectively.) (a) Fermulate an Lip model for this problem with the objective of maximizing the expected retum (in (b) Implement your model in a spreadsheet and solve it. What is the optimal solution