(Hospital Expansion Problem) Mt. Siani Hospital in New Orleans is a large, private, 600-bed facilty, complete with laboratories, operating rooms, and x-ray eqipment. In seeking to increase revenues, Mt. Sinai's administration has decided to make a 90-bed addition on a portion of adjacent land currently used for staff parking. The administration feel that the lags, operating rooms, and x-ray department are not being fully utilized at present and do not need to be expanded to handle additonal patients. The addition of 90 beds, however, involves deciding how many beds should be allocated to the medical staff for medical patients and how many to the surgical patients. The hospital's accounting and medical records departments have provided the following pertinent information. The average medical patient generates $2,280 in revenues. The average surgical patient is in the hospital 5 days and receives a $1,515 bill. The laboratory is capable of handling 15,000 tests per year more than it was handling. The average medical patient requires 3.1 lab tests and the average surgical patient takes 2.6 lab tests. Furthermore, the average medical patient uses on x-ray, whereas the average surgical patient requires two x-rays. If the hospital was expanded by 90 beds, the x-ray dept could handle up to 7,000 x-rays w/o significant additional cost. Finally, the administration estimates that up to 2,800 additionally operations could be performed in existing operating rooms facilities. Medical patients, of course, do not require surgery, whereas each surgical patient generally has on surgery performed.
Formulate this problem so as to determine how many medical beds and how many surgical beds should be added to maximize revenues. Assume that the hospital is open 365 days a year.© BrainMass Inc. brainmass.com October 25, 2018, 2:14 am ad1c9bdddf
A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.
Transportation Model (Linear programming model formulation)
Consider the following transportation problem ...
Formulate this problem as a linear programming model and solve it by using Solver in Excel.
(Please see the attached file).