Adirondack Savings Bank (ASB) has $1,000,000 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 7% for home loans, 12% 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 in order to maximize the total annual return for the new funds. b. How much should be allocated to each type of loan? What is the total annual return? What is the annual percentage return? c. If the interest rate on home loans increased to 9%, would the amount allocated to each type of loan change? Explain. d. Suppose the total amount of new funds available was increased by $10,000. What effect would this have on the total annual return? Explain. e. Assume that ASB has the original $1,000,000 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? How much would the annual percentage return change?

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...
icon
Related questions
Question
100%

I NEED HELP WITH QUESTION D AND E.

 

 

Adirondack Savings Bank (ASB) has $1,000,000 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 7% for home loans, 12% 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 in order to maximize the total annual return for the new funds.

b. How much should be allocated to each type of loan? What is the total annual return? What is the annual percentage return?

c. If the interest rate on home loans increased to 9%, would the amount allocated to each type of loan change? Explain.

d. Suppose the total amount of new funds available was increased by $10,000. What effect would this have on the total annual return? Explain.

e. Assume that ASB has the original $1,000,000 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? How much would the annual percentage return change?

Expert Solution
Step 1

 

Let Home loan = H, Personal Loan = P, and Auto loan = A
Max Z = 0.07 H + 0.12 P + 0.09 A
subject to 
H+P+A = 1000000
H >= 0.4(H+P+A) at least 40% of new funds on home loans
or 
0.6 H - 0.4P - 0.4 A >= 0
P <= 0.6 A
or 
P - 0.6 A <= 0
H, P, A >= 0
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 8 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.