Explore BrainMass

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

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

#### 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 ...

#### 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.

\$2.49