excel online activity: capacity\na typical dentist’s office has a complicated mix of dental procedures and…

excel online activity: capacity\na 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.\non 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 two 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?\ndental procedure,appointments setup or changeover time (minutes),processing time (minutes),demand (no. of patients scheduled)\nsingle tooth crown 1st appt.,20,85,2\nsingle tooth crown 2nd appt.,15,40,1\ntooth whitening,10,25,4\npartial denture 1st appt.,5,25,4\npartial denture 2nd appt.,10,20,1\npartial denture 3rd appt.,5,25,2\nopen the spreadsheet and perform the required analysis to answer the questions below.\nopen spreadsheet\nquestions\n1. what is the total setup time?\nminutes\n2. what is the total processing time?\nminutes\n3. what is the total time?\nminutes\n4. 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.\n%\n5. what percentage of the total capacity is spent on dental procedures? round your answer to two decimal places.

excel online activity: capacity\na 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.\non 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 two 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?\ndental procedure,appointments setup or changeover time (minutes),processing time (minutes),demand (no. of patients scheduled)\nsingle tooth crown 1st appt.,20,85,2\nsingle tooth crown 2nd appt.,15,40,1\ntooth whitening,10,25,4\npartial denture 1st appt.,5,25,4\npartial denture 2nd appt.,10,20,1\npartial denture 3rd appt.,5,25,2\nopen the spreadsheet and perform the required analysis to answer the questions below.\nopen spreadsheet\nquestions\n1. what is the total setup time?\nminutes\n2. what is the total processing time?\nminutes\n3. what is the total time?\nminutes\n4. 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.\n%\n5. what percentage of the total capacity is spent on dental procedures? round your answer to two decimal places.

Answer

Explanation:

Step1: Calculate total setup time

Multiply setup time per - procedure by number of appointments and sum. [ \begin{align*} \text{Total Setup Time}&=(20\times2 + 15\times1+10\times4 + 5\times4+10\times1 + 5\times2)\ &=(40 + 15+40 + 20+10 + 10)\ &=135 \end{align*} ]

Step2: Calculate total processing time

Multiply processing time per - procedure by number of appointments and sum. [ \begin{align*} \text{Total Processing Time}&=(85\times2+40\times1 + 25\times4+25\times4+20\times1+25\times2)\ &=(170+40 + 100+100+20+50)\ &=480 \end{align*} ]

Step3: Calculate total time

Total time is sum of setup and processing times. [ \begin{align*} \text{Total Time}&=\text{Total Setup Time}+\text{Total Processing Time}\ &=135 + 480\ &=615 \end{align*} ]

Step4: Calculate percentage of setup time

The dentist works (9 - 1=8) hours a day, which is (8\times60 = 480) minutes. [ \begin{align*} \text{Percentage of Setup Time}&=\frac{\text{Total Setup Time}}{\text{Total Time}}\times100\ &=\frac{135}{615}\times100\ &\approx21.95% \end{align*} ]

Step5: Calculate percentage of processing time

[ \begin{align*} \text{Percentage of Processing Time}&=\frac{\text{Total Processing Time}}{\text{Total Time}}\times100\ &=\frac{480}{615}\times100\ &\approx78.05% \end{align*} ]

Answer:

  1. 135 minutes
  2. 480 minutes
  3. 615 minutes
  4. 21.95%
  5. 78.05%