Problem $7$

Data for a Mammography Center procedures are given in the table. The

volumes shown are for a $5-$month period $($you can use $30$ days per month$).$

The Center works only one $8-$hour shift per day $($so the shift volumes and daily

volumes are the same$).$ The indirect support hours are $\mathrm{.}13$ hours per

procedure and fixed administrative hours required are $4$ per shift. The unit

has a target utilization rate of $83\%.$ Sick, vacation, and other leave days total

$30$ per year and workers get $2$ days off per week.

a$.$ Compute the average volume for a shift based on the volumes. How

many technicians would be needed for an average shift?

b$.$ What is the FTE requirement for radiology technicians? Please write steps on how to do this in excel.