finance decision analysis

A bank has $511,000 in assets to allocate among investments in bonds, home mortgages, car loans, and personal loans. Bonds are expected to produce a return of 12%, mortgages 10.5%, car loans 11.5%, and personal loans 14.5%. To make sure the portfolio is not too risky, the bank wants to restrict personal loans to no more than the 25% of the total portfolio. The bank also wants to ensure that at least as much money is invested in mortgages as is invested in personal loans, The bank also wants to invest at least as much in bonds as they do in personal loans. (Let X1,X2,X3, and X4 be the amount (in dollars) imvested in bonds, mortgages, car loans, and personal loans, respectively.) (a) Formulate an 15 model for this problem with the objective of maximizing the expected return (in dollars) on the portfolio. x1,x2,x3,x40 (b) Implemenk your model in a spreadsheot and solve it. What is the optimal solution? (x1,x2,x3,x4)=(