Excel Online Activity: Capacity

A typical dentist's office has a complicated mix of dental procedures and significant setup times; thus, it is similar to a job shop.

Suppose a dentist works a $9-$hour day with one hour for lunch and breaks. During the first six months the practice is open, he does

all the work, including cleaning and setting up for the next dental procedure. Setup and processing times for three procedures are

shown in the Microsoft Excel Online file below. Also shown are the number of appointments and demand for each type.

On a particular day, there are two scheduled first appointments for single tooth crowns $($see last column of the table in the Microsoft

Excel Online file below$),$ one second appointment for a single tooth crown, two tooth$-$whitening appointments, two first

appointments for a partial denture, and four third appointments for a partial denture. Assume there is one setup time per dental

procedure to set up and clean the equipment and room before the next patient arrives. Is there sufficient capacity to perform all

the work?

Questions

What is the total setup time?

minutes

What is the total processing time?

minutes

What is the total time?

minutes

What percentage of the total capacity is used to set up and change over from one dental procedure to the next? Round your

answer to two decimal places.

$\%$

What percentage of the total capacity is spent on dental procedures? Round your answer to two decimal places.

$\%$

Is there sufficient capacity to perform all the work?