Allocation of funds lp problemthe employee credit union at

Reference no: EM13361380

Allocation of Funds: LP Problem

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 returns are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other Secured loans 11 Signature loans 12 Risk Free securities 9 The credit union has $2,000,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,000,000 be allocated to each of the loan/investment alternatives to maximize total return? What is the projected total annual return? Formulate the problem and solve it on a computer by using the Microsoft's Excel. You need to submit the formulation as well as the computer output.

Reference no: EM13361380

Questions Cloud

Aggregate planning level capacity and chase demand : aggregate planning level capacity and chase demand strategya small manufacturing plant is considering their aggregate

Union vs non-unionized workplacecompare organizational : union vs. non-unionized workplacecompare organizational environments of a union and non-union workplace as it impacts

Northwoods direct labor costsnorthwoods appliances produces : northwoods direct labor costsnorthwoods appliances produces washers and dryers in an assembly-line process. labor costs

Why employees resist labor unionsexplain what are some : why employees resist labor unionsexplain what are some reasons that employees still resist unions even after the

Allocation of funds lp problemthe employee credit union at : allocation of funds lp problemthe employee credit union at state university is planning the allocation of funds for the

Grefrath corporation is developing direct labor standards a : grefrath corporation is developing direct labor standards. a particular product requires 0.62 direct labor-hours per

Jeffs corporation compute standard rate per direct : jeffs corporation compute standard rate per direct laborjeffs corporation is developing direct labor standards. the

Garrigus corporation is developing direct labor standards : garrigus corporation is developing direct labor standards. the basic direct labor wage rate is 15 per hour. employment

Mazzucco corporation labor rate variancemazzucco : mazzucco corporation labor rate variancemazzucco corporation has provided the following data concerning its direct

User Account

All Pages