Question: 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

Excel Online Activity: Capacity A typical
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. Supp 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 deaning and setting up for the next dental procedure. Setup and processing times for three procedures are shown in the Mi 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 E Online file below), one second appointment for a single tooth crown, two tooth-whitening appointments, four first appointments for a denture, and four third appointments for a partial denture. Assume there is one setup time per dental procedure to set up and cleant 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) 20 95 2 Single tooth crown 1st appt. Single tooth crown 2nd appt. Tooth whitening 10 30 1 5 30 2 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. Supp 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 deaning and setting up for the next dental procedure. Setup and processing times for three procedures are shown in the Mi 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 E Online file below), one second appointment for a single tooth crown, two tooth-whitening appointments, four first appointments for a denture, and four third appointments for a partial denture. Assume there is one setup time per dental procedure to set up and cleant 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) 20 95 2 Single tooth crown 1st appt. Single tooth crown 2nd appt. Tooth whitening 10 30 1 5 30 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!