Formulate this problem as linear programming problem

Assignment Help Operation Management

Reference no: EM132215142

The U-Save Loan Company is planning its operations for the next year. The company makes four types of loans, listed below, together with the annual return (in percent) to the company. Legal requirements and company policies place the following limits on the various types of loans. Signature loans may not exceed 10 percent of the total amount of loans. The amount of signature and furniture loans together may not exceed 20 percent of the total amount of loans. First mortgages must be at least 40 percent of the total mortgages and at least 20 percent of the total amount of loans. The company can lend a maximum of 1.5 million dollars next operating period. Type Annual Return (percent) Signature loan 15 Furniture loan 12 Second Home Mortgage 10 First Home Mortgage 7 U-Save wants to know the amounts it should invest in each type of loan to maximize its total annual return. Formulate this problem as a linear programming problem and solve it using MS Excel Solver.

Reference no: EM132215142

Questions Cloud

Equal opportunity and diversity in the workplace : Equal Opportunity and Diversity in the workplace -- why is it important to understand as a manager?

Explain the origins and development of your topic : When selecting two theories, consider whether each theory could: be used to develop strategies or programs to benefit human development relevant to your topic

What kind of test would you prepare : You are a teaching assistant for an undergraduate history class and need to prepare a test. You want evidence to show that students know the material well.

Advise alan about the likely success of his action : BULAW5914 Advise Alan about the likely success of his action in negligence - In your response you must support our argument with appropriate cases

Formulate this problem as linear programming problem : The U-Save Loan Company is planning its operations for the next year. Formulate this problem as a linear programming problem and solve it using MS Excel Solver.

Does the mother have a right to not disclose the diagnosis : In your initial post, explain how the APA Ethical Principles and Code of Conduct can be used to guide decisions in this ethically complex situation.

Additional linear programing problems : The management of the Best Laptop Manufacturing (BLM) has decided to expand its product mix.

Describe two factors that might make minority groups : Describe two factors that might make minority groups especially vulnerable in the Medicaid policy your colleague cited.

How you create your personal model for group leadership : Submit the theory selection portion (1-2 pages) of your final project. In this section, you review the literature in group counseling and addictions counseling.

User Account

All Pages