Question

Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, p...

Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 4% for home loans, 14% for personal loans, and 9% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans.

(a) Formulate a linear programming model that can be used to determine the amount of funds ASB should allocate to each type of loan to maximize the total annual return for the new funds. If the constant is "1" it must be entered in the box. If your answer is zero enter “0”.
Let H = amount allocated to home loans
P = amount allocated to personal loans
A = amount allocated to automobile loans
Max H + P + A
s.t.
H + P + A Minimum Home Loans
H + P + A Personal Loan Requirement
H + P + A = Amount of New Funds
(b) How much should be allocated to each type of loan?
Loan type Allocation
Home $
Personal $
Automobile $
What is the total annual return?
If required, round your answer to nearest whole dollar amount.
$
What is the annual percentage return?
If required, round your answer to two decimal places.
%
(c) If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change?
No- Select your answer -YesNoItem 21
Explain.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
(d) Suppose the total amount of new funds available is increased by $10,000. What effect would this have on the total annual return? Explain.
If required, round your answer to nearest whole dollar amount.
An increase of $10,000 to the total amount of funds available would increase the total annual return by $ .
(e) Assume that ASB has the original $1 million in new funds available and that the planning committee has agreed to relax the requirement that at least 40% of the new funds must be allocated to home loans by 1%. How much would the annual return change?
If required, round your answer to nearest whole dollar amount.
$
How much would the annual percentage return change?
If required, round your answer to two decimal places.
%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Lingo model- Global optimal Sot n foun, 0. 000 000 Elapied runfime Seconds; °24 model chous Total vanto bles 3 Noninear vartaLafable VuResyad Cot- a 8450000 0,000 000 0,000 O o6 0.00000 Hre lome Alh Pergonal022 fe. 0,34「 rent-age = ㅕ (O Refer the RRiqht hand side Range,t Ro urvent- Allounile Aoable RHS Peereak Cy 000006 0 86000 o 00000O 0 0000oo o 6 000006 φ, oooooo SNFI

Add a comment
Know the answer?
Add Answer to:
Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, p...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 4% for home loans, 10% for personal loans, and 7% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 13% for personal loans, and 8% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 11% for personal loans, and 11% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and auto...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 11% for personal loans, and 8% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 13% for personal loans, and 8% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • Ch 12 LP Quiz -2 ark ASB) has $1 m rds that must be alocated toho ne loans, personal loans, and a...

    ch 12 LP Quiz -2 ark ASB) has $1 m rds that must be alocated toho ne loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 7% for home loans, on n new 14% for personal loans, and 8% for automoble loans. The bank's peched that the amount alocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. planning committee has deode that at least 40% of...

  • The employee credit union at State University is planning the allocation of funds for the coming year. The credit union...

    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 revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (% Automobile loans Furniture loans 12 Other secured loans 14 Signature loans 13 Risk-free securities The credit union will have...

  • The employee credit union at State University is planning the allocation of funds for the coming year.

    Problem 4-03 (Algorithmic)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 revenueproducing investments together with annual rates of return are as follows:Type of Loan/InvestmentAnnual Rate of Return (%)Automobile loans8Furniture loans12Other secured loans14Signature loans13Risk-free securities9The credit union will have $1.7 million available for investment during the coming year....

  • The employee credit union at State University is planning the allocation of funds for the coming ...

    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 Furniture loans Other secured loans Signature loans Risk-free securities 10 12 8 The credit union will have...

  • The employee credit union at State University is planning the allocation of funds for the coming ...

    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 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT