Surgical Procedure List

$\backslash$table$[[\backslash$table$[[$Assigned$],[$Doctor$]],$Procedure,$\backslash$table$[[$Setup$/$Changeover Time$]],\backslash$table$[[$Procedure Time$]],\backslash$table$[[$Demand $[$# of patients$],[$scheduled each week$]]]],[$A$,$Cholecystectomy,$54,80,1],[$A$,$Ileostomy,$59,120,2],[$A$,$Lobectomy,$56,150,3],[$B$,$Septoplasty,$41,70,2],[$B$,$Tonsillectomy,$56,60,2],[$B$,$Appendectomy,$26,30,2],[$B$,$Hysterectomy,$34,90,2]]$

The hospital requires a minimum of $21$ minutes in the setup$/$changeover category to prepare the operating room for the next surgery. Tracy and Matt have added time to the changeovers after each surgery in order to allow them time to wash up$,$ rest an appropriate amount of time, and review the patiers files in order to be properly prepared for the next surgery. The surgeons have decided upon these times and are not very interested in reducing them because they feel that reducing the changeover times would make them feel rushed and it might lead to medical and surgical errors.

In a Excel spreadsheet, show your work and answer the following questions:

What is the total minutes available per surgeon considering the safety capacity required? $[2$ marks$]$

What is the current workload for the surgeons? Show your answer in total minutes per surgeon as well as utilization rate per surgeon. $[5$ marks$]$

Based on the current workload, should Tracy and Matt hire more doctors? If you determine the utilization is to high suggest possible solutions. $[4$ marks$]$

Prepare $2$ separate 'what if$\text{'}$ scenarios to show the effect on capacity of the following: