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), two second appointment for a single tooth crown, four tooth-whitening appointments, two first 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	Appointments Setup or Changeover Time (Minutes)	Processing Time (Minutes)	Demand (No. of Patients Scheduled)
Single tooth crown 1st appt.	20		95		2
Single tooth crown 2nd appt.	10		30		2
Tooth whitening	10		30		4
Partial denture 1st appt.	5		40		2
Partial denture 2nd appt.	15		30		0
Partial denture 3rd appt.	10		30		1

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

2. What is the total processing time?

fill in the blank ? minutes

3. What is the total time?

fill in the blank ? 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. What percentage of the total capacity is spent on dental procedures. Round your answer to two decimal places.

fill in the blank ? %

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

Yes, there is sufficient capacity. No, there is a capacity shortage.

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl17 {color:windowtext; font-weight:700; vertical-align:middle;} .xl18 {color:windowtext; vertical-align:middle;} .xl19 {color:windowtext;} .xl20 {color:windowtext; font-weight:700; text-align:center; vertical-align:middle;} .xl21 {color:windowtext; font-weight:700;} .xl22 {color:windowtext; background:#F4B084; mso-pattern:black none;} .xl23 {color:windowtext; vertical-align:middle; background:#9BC2E6; mso-pattern:black none;} .xl24 {color:windowtext; vertical-align:middle; background:#A9D08E; mso-pattern:black none;} .xl25 {color:windowtext; vertical-align:middle; background:#A9D08E; mso-pattern:black none;}

Capacity Measurement
					Total	Total
Work Order	Setup Time	Processing Time	Order Size		Setup Time	Processing Time	Total Time
Single tooth crown 1st appt.	20	95	2		40	0
Single tooth crown 2nd appt.	10	30	2		20	60
Tooth whitening	10	30	4		40	120
Partial denture 1st appt.	5	40	2		10	80
Partial denture 2nd appt.	15	30	0		0	0
Partial denture 3rd appt.	10	30	1		10	30
				Total
				Percentage
				Formulas
					Total	Total
					Setup Time	Processing Time	Total Time
					=B5*D5	=C5*E5	#N/A
					=B6*D6	=C6*D6	#N/A
					=B7*D7	=C7*D7	#N/A
					=B8*D8	=C8*D8	#N/A
					=B9*D9	=C9*D9	#N/A
					=B10*D10	=C10*D10	#N/A
				Total	#N/A	#N/A	#N/A
				Percentage	#N/A	#N/A	#N/A