Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
please provide each step on excel Adirondack Savings Bank ASS) has $1 million in new funds that must be allocated to home loans, personal loans,
please provide each step on excel
Adirondack Savings Bank ASS) 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 10% for automable 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 blocated 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 anual return for the new funds. If the constants "it must be entered in the box. If your answer is zero enter "O". Let - amount allecated to home loans Pamount allocated to personal loans A-amount allecated to automobile loans Max 05 .10 S.L. + Minimum Home Loans + BAS * Personal loan Roulement + 3. X Amount of New Funds (b) How much should be allocated to each type of loan? Loan type Allocation home $ 40000 Personal 5 300000 Automobile 410000 What is the total annual return? If required, round your answer to nearest who doller amount. Adirondack Savings Bank ASS) 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 10% for automable 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 blocated 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 anual return for the new funds. If the constants "it must be entered in the box. If your answer is zero enter "O". Let - amount allecated to home loans Pamount allocated to personal loans A-amount allecated to automobile loans Max 05 .10 S.L. + Minimum Home Loans + BAS * Personal loan Roulement + 3. X Amount of New Funds (b) How much should be allocated to each type of loan? Loan type Allocation home $ 40000 Personal 5 300000 Automobile 410000 What is the total annual return? If required, round your answer to nearest who doller amountStep by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started