Dental Procedure Appointments Setup or Changeover Time $($Minutes$)$ Processing Time $($Minutes$)$ Demand $($No$.$ of Patients Scheduled$)$

Single tooth crown $1$st appt. $15803$

Single tooth crown $2$nd appt. $10301$

Tooth whitening $5303$

Partial denture $1$st appt. $15301$

Partial denture $2$nd appt. $10250$

Partial denture $3$rd appt. $10303$

Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

Questions

$1.$ What is the total setup time?

fill in the blank $2$

minutes

$2.$ What is the total processing time?

fill in the blank $3$

minutes

$3.$ What is the total time?

fill in the blank $4$

minutes

$4.$ 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.

fill in the blank $5$

$\%$

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

fill in the blank $6$

$\%$

$6.$ Is there sufficient capacity to perform all the work?