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 six minutes to fill out an application, three 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 41 drivers/hour.

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

Questions

1. What is the current labor utilization of each labor type? Round your answers to the nearest whole number.

Utilization (Clerks):
Utilization (Typists):

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 clerks

areare not

the bottleneck resource. To reach 80% target utilization, fill in the blank 5 clerks are needed.

The typists

areare not

the bottleneck resource. To reach 80% target utilization, fill in the blank 7 typists are needed.