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:

What if changeover time is reduced by $50\%$ and the procedure time stays the same? $($keep in mind the minimum allowable changeover time$)$ Show the affect on Changeover time as well as utilization for each surgeon $[3$ marks$]$

What if surgeries could be completed $20\%$ faster but with the original setup$/$changeover time? Show the affect on procedure time as well as utilization for each surgeon $[2$ marks$]$

What are your final recommendations to the business owners? $[$You must provide evidence$-$based reasons for your recommendations$][4$ marks$]$