60.1K

Verified Solution

Link Copied!

*******Give me a breakdown of each letter question. Also, show screenshots from the SOLVER.*****

Q2. (30 points) 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. 3 A template is provided below for possible use. 4 Parameters 6 Rate of Return Max of Total Available Max of Total Allocated Loans 7 Automobile Loans 8% 8 Furniture Loans 10% 19 Other Secured Loans 11% 20 Signature Loans 12% 10% 21 Risk-free Securities 30% 221 23 Funds Available 24 25 Model 26 Automobile Loans 27 Furniture Loans 28 Other Secured Loans 29 Signature Loans 30 Risk-free Securities 31 32 9% $2,000,000 45 Q2. (30 points) 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. 3 A template is provided below for possible use. 4 Parameters 6 Rate of Return Max of Total Available Max of Total Allocated Loans 7 Automobile Loans 8% 8 Furniture Loans 10% 19 Other Secured Loans 11% 20 Signature Loans 12% 10% 21 Risk-free Securities 30% 221 23 Funds Available 24 25 Model 26 Automobile Loans 27 Furniture Loans 28 Other Secured Loans 29 Signature Loans 30 Risk-free Securities 31 32 9% $2,000,000 45

Answer & Explanation Solved by verified expert

See Answer