The employee 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-free securities to stabilize income. The various revenue-producing investments, together with annual rates of return, are as follows. Type of Loan/Investment Annual Rate of Return (%) Automobile loans 7 Furniture loans 9 Other secured loans 10 Signature loans 11 Risk-free securities 8 The credit union will have $2,200,000 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 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $2,200,000 be allocated to each of the loan/investment alternatives (in dollars) to maximize total annual return? Automobile loans $___ Furniture loans $ _ Other secured loans $ _ Signature loans $ _ Risk-free securities $ _ What is the projected total annual return (in dollars)? $____

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

The employee 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-free securities to stabilize income. The various revenue-producing investments, together with annual rates of return, are as follows.

Type of Loan/Investment	Annual Rate of Return (%)
Automobile loans	7
Furniture loans	9
Other secured loans	10
Signature loans	11
Risk-free securities	8

The credit union will have $2,200,000 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 30% of the total funds available for investment.
Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans).
Furniture loans plus other secured loans may not exceed the automobile loans.
Other secured loans plus signature loans may not exceed the funds invested in risk-free securities.

How should the $2,200,000 be allocated to each of the loan/investment alternatives (in dollars) to maximize total annual return?

Automobile loans $_____
Furniture loans $ _____

Other secured loans $ _____

Signature loans $ _____

Risk-free securities $ _____

What is the projected total annual return (in dollars)?

$______

Expert Solution