Solver In excel

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rate of return on each type of investment is known to be: bonds, 10%; home loans, 16%; auto loans, 13%; personal loans, 20%. To ensure that the bank's portfolio is not too risky, the bank's investment manager has placed the following three restrictions on the bank's portfolio: a) The amount invested in personal loans cannot exceed the amount invested in bonds. b) The amount invested in home loans cannot exceed the amount invested in auto loans. c) No more than 25% of the total amount invested may be in personal loans. The bank's objective is to maximize the annual return on its investment portfolio. Formulate an LP that will enable the bank to meet this goal