Cardiac surgical versus oncology patients

Assignment Help Operation Management

Reference no: EM132237735

West End Hospital is pursuing a sixty-two-bed expansion and would like to determine how many beds should be allocated to cardiac surgical patients versus oncology patients to maximize revenues. The average length of stay for cardiac surgical patients is 4.7 days whereas the average length of stay for oncology patients is seven days. Assume the hospital is open 365 days a year. The average revenue generated from from an oncology patient is $9,500 and the average revenue generated from a cardiac surgical patient is $10,750. The hospital currently has four hundred beds, and its laboratories, radiology department, and operating rooms have excess capacity and would be able to handle the increased demand from the expansion with existing staff. the laboratories could process up to an additional ten thousand tests annually. the average cardiac surgical patient requires 2.5 lab tests whereas the average oncology patient requires two lab tests. the radiology department can process up to an additonal five thousand imaging requests annually. the average cardiac surgical patient requires two imaging services whereas the oncology patient requires four. Last, fifteen hundred additional surgeries could be accommodated in the hospital's existing operating rooms.

a. Formulate this as a linear programming problem.

b. Solve the problem using Excel Solver.

c. What is the optimal allocation of beds to cardiac surgical versus oncology patients?

Please show answers using Excel

Reference no: EM132237735

Questions Cloud

Describe in detail the recent cyber security issue : Describe in detail the recent cyber security issue that you selected. How was the enterprise impacted?

About the discussing employee performance : If you were conducting s feedback session with an employee who reports to you, which of these guidelines would require you to prepare ahead of time?

Identify the target audience : Identify the company, brand, product, or service being advertised. Identify the target audience.

Type of uncertainty referenced by the warfighting manual : Describe a decision your company (past or present) has made when facing uncertainty - the type of uncertainty referenced by the Warfighting manual

Cardiac surgical versus oncology patients : What is the optimal allocation of beds to cardiac surgical versus oncology patients?

Bowlin work be used to justify somewhat higher price quotes : How can the high quality of Bowlin's work be used to justify somewhat higher price quotes?

Achieved by building index on the other field : If a file is hashed on one field, direct access based on another field can be achieved by building an index on the other field.

Generic functions performed by departments in organizations : There are essentially two types of generic functions performed by departments in organizations.

About the elasticity of demand affecting bowlin pricing : What would the nature of this industry suggest about the elasticity of demand affecting Bowlin's pricing?

User Account

All Pages