Please help me solve this question on Linear Optimization Models using solver in in Excel showing the formulas and solver configuration! $11.$ Crodit Union Fund Allocation. The employes credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk$-$fres securities to stabilize income. The various revenue$-$producing investments, together with annual rates of return, are as follows:

The credit union will have $\backslash (\backslash$$ $2\backslash )$ million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments:

$-$ Risk$-$free securities may not exceed $\backslash (30\backslash \%\backslash )$ of the total funds available for investment.

$-$ Signature loans may not excesd $10\backslash \%$ of the funds invested in all loans $($automobile$,$ furniture, other secured, and signature loans$).$

$-$ Furniture loans plus other secured loans may not excesd the automobile loans.

$-$ Other secured loans plus signature loans may not excesd the funds invested in riskfree securities$.$

How should the $\backslash (\backslash$$ $2\backslash )$ million be allocated to each of the loan$/$investment alternatives to maximize total annual return? What is the projected total annual return?