answer in excel

A credit union is planning the allocation of funds for the coming year. The credit makes four typer of loans to its members. In addition, the credit union invests in risk.free securities. The rates of return on the different investments are indicated below. The credit unlon will have 52 milion avallable for investment. Various laws stipulate the following restrictions. a. Risk free securities may not exceed 30% of total funds. b. Signature loans may not exceed 10% of the funds invested in all loans (automoble, furniture, other secured and sigrature loans). c. Furniture loans plus other secured loans may not exceed the automobile loans. d. Other secured loans plus signature loans may not exceed the funds invested in risk free securities. Use ip to determine the optimal allocation of funds. The solver dlalog box must be populated ond I should be oble to execute solver. Download the answer report. A template is provided below for possible use