Video

Excel Online Tutorial $$

Excel Online Activity: Capacity

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, four tooth$-$whitening appointments, four first appointments for a partial denture, one second appointments for a partial denture, and

one 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?

Dental Procedure

Single tooth crown $1$st

appt.

Single tooth crown $2$nd

appt.

Tooth whitening

Partial denture $1$st appt.

Partial denture $2$nd

appt.

Partial denture $3$rd appt.

Appointments Setup

or Changeover Time

$($Minutes$)$

$15$

$10$

$5$

$15$

$15$

$5$Chapter $10$ Excel Activity: Capacity

Open spreadsheet

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?