West End Hospital is pursuing a sixty-two-bed expansion andwould like to determine how many beds should be allocated tocardiac surgical patients versus oncology patients to maximizerevenues. The average length of stay for cardiac surgical patientsis 4.7 days whereas the average length of stay for oncologypatients is seven days. Assume the hospital is open 365 days ayear. The average revenue generated from from an oncology patientis $9,500 and the average revenue generated from a cardiac surgicalpatient is $10,750. The hospital currently has four hundred beds,and its laboratories, radiology department, and operating roomshave excess capacity and would be able to handle the increaseddemand from the expansion with existing staff. the laboratoriescould process up to an additional ten thousand tests annually. theaverage cardiac surgical patient requires 2.5 lab tests whereas theaverage oncology patient requires two lab tests. the radiologydepartment can process up to an additonal five thousand imagingrequests annually. the average cardiac surgical patient requirestwo imaging services whereas the oncology patient requires four.Last, fifteen hundred additional surgeries could be accommodated inthe 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 surgicalversus oncology patients?

Please show answers using Excel!