Purchase Solution

Linear Programming Using Excel : Parameters that Lead to a Certain Profit

Not what you're looking for?

Ask Custom Question

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.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

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.