********Break down the answers for each question*******

A through D.

A credit union is planning the allocation of funds for the coming year. The credit makes four types 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 union will have $ 2 million available 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 (automobile, furniture, other secured and signature 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 LP to determine the optimal allocation of funds. The solver dialog box must be populated and I should be able to execute solver. Download the answer report. A template is provided below for possible use. Parameters Rate of Return Max of Total Available Max of Total Allocated Loans 8% 10% Automobile Loans Furniture Loans Other Secured Loans Signature Loans Risk-free Securities 11% 12% 10% 9% 30% Funds Available $2,000,000 Model Automobile Loans Furniture Loans Other Secured Loans Signature Loans Risk-free Securities Obj. Function Return Constraints LHS RHS Risk-free Securities Signature Loans Furniture Loans + Other Secured Loans Other Secured Loans + Signature Loans Total Loans