OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance its loan portfolio. Its operations manager is asked to build an LP model to help guide company decisions as to how to disburse the revolving fund across different loan categories. The operations manager garnered the following data on available types of loans based on market research of the industry: Types of loan Personal Interest rate Bad debt ratio 0.15 .10 Car Home 0.20 0.17 Small and medium enterprises | 0.25 0.04 0.02 0.15 Commercial 0.10 0.02 The Bank's net return is interest rate net of Bad debt. Revenue from interest is gained only from good loans. The mutual funds Division has allocated $5.0M and is currently looking for investment opportunities to invest these funds, The financial analyst suggested that all new investments be made in the oil industry, steel industry or in government bonds. The analyst identified five investment opportunities: two from the oil industry, two from the steel and government bonds. Types of opportunities АВС oil XZY oil Returns 0.095 0.085 Mona steel TNT steel Government Bonds 0.04 0.05 0.015 Formulate a LP model for the OECS bank that will maximize net returns from the loans division and a separate model for the Mutual Funds Division including ratio constraints. For the mutual Funds Division 1. Generate the objective function 2. Generate the budget constraint 3. The amount invested in oil should be at least three times the amount invested in the steel industry 4. The investment in ABC oil cannot be more than 50 % of total oil industry 5. The investment in TNT steel should be at most 40 % of the total investment in Government Bond 6. The investment in XYZ oil should be at least 20 % of the total funds available but no more than 40% of total funds 7. The steel industry should not receive more than 30 % of total funds
OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance its loan portfolio. Its operations manager is asked to build an LP model to help guide company decisions as to how to disburse the revolving fund across different loan categories. The operations manager garnered the following data on available types of loans based on market research of the industry: Types of loan Personal Interest rate Bad debt ratio 0.15 .10 Car Home 0.20 0.17 Small and medium enterprises | 0.25 0.04 0.02 0.15 Commercial 0.10 0.02 The Bank's net return is interest rate net of Bad debt. Revenue from interest is gained only from good loans. The mutual funds Division has allocated $5.0M and is currently looking for investment opportunities to invest these funds, The financial analyst suggested that all new investments be made in the oil industry, steel industry or in government bonds. The analyst identified five investment opportunities: two from the oil industry, two from the steel and government bonds. Types of opportunities АВС oil XZY oil Returns 0.095 0.085 Mona steel TNT steel Government Bonds 0.04 0.05 0.015 Formulate a LP model for the OECS bank that will maximize net returns from the loans division and a separate model for the Mutual Funds Division including ratio constraints. For the mutual Funds Division 1. Generate the objective function 2. Generate the budget constraint 3. The amount invested in oil should be at least three times the amount invested in the steel industry 4. The investment in ABC oil cannot be more than 50 % of total oil industry 5. The investment in TNT steel should be at most 40 % of the total investment in Government Bond 6. The investment in XYZ oil should be at least 20 % of the total funds available but no more than 40% of total funds 7. The steel industry should not receive more than 30 % of total funds
Chapter14: Marketing Channels And Supply Chain Management
Section14.1: Taza Cultivates Channel Relationships With Chocolate
Problem 1VC
Related questions
Question
Transcribed Image Text:OECS Bank has both a loans division and mutual funds division. It has allocated $40.0M to finance
its loan portfolio. Its operations manager is asked to build an LP model to help guide company
decisions as to how to disburse the revolving fund across different loan categories. The operations
manager garnered the following data on available types of loans based on market research of the
industry:
Types of loan
Personal
Car
Interest rate
Bad debt ratio
0.15
.10
0.20
0.17
Small and medium enterprises | 0.25
0.04
Home
0.02
0.15
Commercial
0.10
0.02
The Bank's net return is interest rate net of Bad debt. Revenue from interest is gained only from good
loans.
The mutual funds Division has allocated $5.0M and is currently looking for investment opportunities
to invest these funds, The financial analyst suggested that all new investments be made in the oil
industry, steel industry or in government bonds. The analyst identified five investment opportunities:
two from the oil industry, two from the steel and government bonds.
Types of opportunities
АВС oil
XZY oil
Mona steel
TNT steel
Government Bonds
Returns
0.095
0.085
0.04
0.05
0.015
Formulate a LP model for the OECS bank that will maximize net returns from the loans division and
a separate model for the Mutual Funds Division including ratio constraints .
For the mutual Funds Division
1. Generate the objective function
2. Generate the budget constraint
3. The amount invested in oil should be at least three times the amount invested in the steel industry
4. The investment in ABC oil cannot be more than 50 % of total oil industry
5. The investment in TNT steel should be at most 40 % of the total investment in Government Bond
6. The investment in XYZ oil should be at least 20 % of the total funds available but no more than
40% of total funds
7. The steel industry should not receive more than 30 % of total funds
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you