Question: 8. Use Solver to find the optimal solution to the given integer programming problem. Consider the same operating room discussed in the Solver example in



8. Use Solver to find the optimal solution to the given integer programming problem. Consider the same operating room discussed in the Solver example in the chapter. Suppose that instead of maximizing profit from surgeries, our objec- tive is to minimize the cost incurred due to surgeries. As before, we denote the number of major surgeries scheduled in a week using decision variable Si, the number of minor surgeries scheduled in a week using decision variable S2, and the number of elective surgeries scheduled in a week using decision variable s3. 286 . CHAPTER 8 The relevant data for each type of surgery is: Labor Hours Surgery Type Cost Operating Room Time 4 hours 15 10 0.5 hour $5,500 $3,000 $4,000 Major (51) Minor (52) Elective (53) 2 hours 12 In addition, for this problem we will assume the facility has only one operating room, which is available 60 hours per week, and the facility has a total of 500 labor hours a week that can be devoted to surgeries. Prior to using Solver, you may want to formulate your problem (i.e., clearly identify decision variables, objective function, and constraints). The relevant data for each type of surgery is: Labor Hours Surgery Type Cost Operating Room Time 15 10 Major (57) Minor (s) Elective (53) $5,500 $3,000 $4,000 4 hours 0.5 hour 2 hours 12 In addition, for this problem we will assume the facility has only one operating room, which is available 60 hours per week, and the facility has a total of 500 labor hours a week that can be devoted to surgeries. Prior to using Solver, you may want to formulate your problem (i.e., clearly identify decision variables, objective function, and constraints)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
