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