Linear Programming Using Excel : Parameters that Lead to a Certain Profit
Not what you're looking for?
You are managing the OR and have been told to come up with the mix of surgeries and doctors that will yield $2,300,000. Currently your OR performs 5 different surgeries and has 3 different doctors. Your OR operates one shift per day with a maximum amount of 8,000 OR hours. The only constraints that you have been given are the following:
? No single surgery will exceed 30% of the total surgeries
? No single surgery will be less than 5% of the total surgeries
? No single doctor will have more than 45% of the total surgeries
? No single doctor will have less than 10% of the total surgeries
? The total number of patients must be an integer (set the constraint to "int")
Using Linear Programming, calculate the total number of surgeries and the percentage of surgeries by type (1-5) and doctor (a-c) that yields a profit of $2,300,000.
**See attachment for numbers relating to this problem
Purchase this Solution
Solution Summary
Linear programming is used to find parameters that lead to a certain profit. The solution is detailed and well presented. The solution received a rating of "5" from the student who posted the question.
Solution Preview
Please see the attached file for the complete solution.
Thanks for using BrainMass.
• No single surgery will exceed 30% of the total surgeries
• No single surgery will be less than 5% of the total surgeries
• No single doctor will have more than 45% of the total surgeries
• No single doctor will have less than 10% of the total surgeries
• The total number of patients must be an integer (set the ...
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Probability Quiz
Some questions on probability