2. Where is the bottleneck in this three-stage process? Both the clerks and typists have an 80 percent target utilization. Do not round intermediate calculations, Round up your answers to the nearest whole number. The derks the bottleneck resource. To reach 80% target utilization, clerks are needed. The trpists (5) the bottieneck resource. To reach 80% target utilization. trpists are needed. Excel Ondine Activity: Identifying Bottlenecks The process for renewing a driver's license at the Archer County Courthouse is as follows. First, the clerk fills out the application; then the clerk takes the driver's picture; and finally, a typist enters the information into the computer system and processes the new license. It takes an average of five minutes to fill out an application, one minutes to take a picture, and seven minutes to process the new license, Due to county and state budget cuts, Archer County Courthouse now has only two clerks and two typists and expects to process 40 drivers/hoor The data has been collected in the Nicrosoft Excel Online file below. Open the spreadsheet and perform the reculrexf analysis to answer the questions below, Open spreadsheet Questions 1. What is the current labor utilization of each fabor type? Round vour answers to the nearest whole oumber. Utiliration (Cierks): vtil zation (Trpists): Search (Ait + Q) 312 fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline 4 & A & B & & C & D & E \\ \hline 1 & Identifying Bottlenecks & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & Time to fill out an application (in minutes) & 5 & & & & \\ \hline 4 & Time to take a picture (in minutes) & 1 & & & & \\ \hline 5 & Time to process the new license (in minutes) & 7 & & & & \\ \hline 6 & Current number of clerks & 2 & & & & \\ \hline 7 & Current number of typists & 2 & & & & \\ \hline 8 & Expected demand rate (drivers/hour) & 40 & & & & \\ \hline 9 & Minutes in an hour & 60 & & & & \\ \hline 10 & & & & & & \\ \hline 11 & & & Formulas & & & \\ \hline 12 & Service rate for clerks (drivers/hour) & - & =60 & & & \\ \hline 13 & Service rate for typists (drivers/hour) & & & \#N/A & & \\ \hline 14 & & & & & & \\ \hline 15 & Utilization (Clerks) & & r & \#N/A & & \\ \hline 16 & Utilization (Typists) & & r & \#N/A & & \\ \hline 17 & & & & & & \\ \hline 18 & Target utilization & 80% & & & & \\ \hline 19 & Required number of clerks & & r & #N/A & & \\ \hline 20 & Requirednumber of typists & & r & \#N/A & & \\ \hline 21 & & & & & & \\ \hline 22 & & & & & & \\ \hline 23 & & & & & & \\ \hline \end{tabular}