50%(2)1 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
avail. represent the constraints that show the availabilities of the related resources. Adjustable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$A$2DRG110020005501E+30$B$2DRG250015001500300$C$2DRG34005001501E+30$D$2DRG4220030075112.5ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$J$5Diagnostic avail.57025057021036$J$8bed-day avail.190010001E+30810$J$11Nursing avail.12200500001E+3048780$J$14Drugs avail.50000150000450010500$F$17Min DRG110-5501023.3310$F$20min DRG250015351E+30$F$23min DRG340-150404540$F$26min DRG42200160601E+30
(a)What is the maximum amount the hospital should be willing to pay for 10,000 extrahours of nursing? For 20,000 extra hours of nursing? (b)If the hospital discovers that it can increase its diagnostic services availability from 570to 800 hours with a total cost of $50,000, should it implement this? (c)If the hospital’s drug availability increases from $50,000 to $54,000, will the basischange? What will be the new optimal profit? (d)Which is worse for the hospital: Losing 30 hours of its diagnostic availability or having tohandle 15 more DRG1 cases?(e)If the profit of the DRG4 case increases to $350, what will be the new optimal mix ofDRGs and the new maximum profit? (f)If a supplier offers the hospital an additional $5000 worth of drugs weekly at a price of$4000, should the hospital accept this offer? (g)The hospital currently has 1000 available bed days. What is the minimum value foravailable bed days that will result in the same basis?(h)Which is better for the hospital: Having to handle 20 less DRG3 cases or having $3500worth of additional drugs? (i)If the profit of a DRG2 case increases to $2500, what will be the new optimal mix ofDRGs and the new maximum profit?
You've reached the end of your free preview.
Want to read both pages?
Optimization, Harshad number, The Profit, Availability, Gotham City Hospital