Oya Optim, the business analyst, can invest up to $15,000 in stocks and loans. Each dollar invested in stocks yields $0.10 profit, and each dollar invested in loan yields $0.15 profit. At least 30% of all money invested must be in stocks, and at least $6000 must be in loans. Determine how Oya can maximize the profit earned on her investments. Build an appropriate LP model. Solve the model using the graphical solution method. Develop a spreadsheet model and use the Solver to find the optimum solution. Create an Answer and a Sensitivity report. Explain all findings in the reports. Change the conditions or values in the case or add new constraints, then show how the solution changes.
Oya Optim, the business analyst, can invest up to $15,000 in stocks and loans. Each dollar invested in stocks yields $0.10 profit, and each dollar invested in loan yields $0.15 profit. At least 30% of all money invested must be in stocks, and at least $6000 must be in loans. Determine how Oya can maximize the profit earned on her investments. Build an appropriate LP model. Solve the model using the graphical solution method. Develop a spreadsheet model and use the Solver to find the optimum solution. Create an Answer and a Sensitivity report. Explain all findings in the reports. Change the conditions or values in the case or add new constraints, then show how the solution changes.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter7: Nonlinear Optimization Models
Section: Chapter Questions
Problem 49P: If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60...
Related questions
Question
Oya Optim, the business analyst, can invest up to $15,000 in stocks and loans. Each dollar invested in stocks yields $0.10 profit, and each dollar invested in loan yields $0.15 profit. At least 30% of all money invested must be in stocks, and at least $6000 must be in loans. Determine how Oya can maximize the profit earned on her investments.
- Build an appropriate LP model.
- Solve the model using the graphical solution method.
- Develop a spreadsheet model and use the Solver to find the optimum solution.
- Create an Answer and a Sensitivity report. Explain all findings in the reports.
- Change the conditions or values in the case or add new constraints, then show how the solution changes.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,