Excel Solver_21.10.2015 - Gotham City Hospital serves cases from four diagnostic-related groups(DRGs The profit contribution diagnostic service use(in

# Excel Solver_21.10.2015 - Gotham City Hospital serves cases...

This preview shows page 1 - 2 out of 2 pages.

Gotham City Hospital serves cases from four diagnostic-related groups (DRGs). The profit contribution, diagnostic service use (in hours), bed-day use (in days), nursing care use (in hours), and drug use (in dollars) are given in the table below. The hospital now has available each week 570 hours of diagnostic services, 1,000 bed days, 50,000 nursing hours, and \$50,000 worth of drugs. To meet the community’s minimum health care demands at least 10 DRG1, 15 DRG2, 40 DRG3, and 160 DRG4 cases must be handled each week. DRG Profit (\$) Diagnostic Services (hours) Bed-Day (days) Nursing Use (hours) Drugs (\$) 1 2,000 7 5 30 800 2 1,500 4 2 10 500 3 500 2 1 5 150 4 300 1 0 1 50 The hospital’s optimal mix of DRGs was found with Excel Solver and the maximum profit is \$181,000. Below is the sensitivity report where DRGi represents the decision variable that shows the number of DRGi cases handled, min DRGi represents the constraint of minimum number of DRGi cases that should be handled, and diagnostic, bed-day, nursing and drugs avail. represent the constraints that show the availabilities of the related resources.

#### You've reached the end of your free preview.

Want to read both pages?

• Fall '15
• KOYUNCU
• Optimization, Harshad number, The Profit, Availability, Gotham City Hospital