Dr. Mark Sloan practices dermatology in Seattle, Washington. Sloan tries hard to schedule appointments so that patients

Fantastic news! We've Found the answer you've been seeking!

Question:

Dr. Mark Sloan practices dermatology in Seattle, Washington. Sloan tries hard to schedule appointments so that patients do not have to wait beyond their appointment time. His April 29 schedule is shown in the following table.

Unfortunately, not every patient arrives exactly on schedule, and expected time to examine patients are just that expected. Some examinations take longer than expected, and some take less time Sloan?s experience dictates the following:

Unfortuntely, not every patient arrives exactly on schedule, and expected times to examine patients are just that ? expected. Some examinations take longer than expected, and some take less time.

Sloan?s experience dictates the following:

(a) 15% of the patients will be 20 minutes early.

(b) 10% of the patients will be 10 minutes early.

(d) 20% of the patients will be 10 minutes late.

(e) 5% of the patients will be 20 minutes late..

He further estimates that

(a) 15% of the time he will finish in 20% less time than expected.

(b) 50 % of the time he will finish in the expected time.

(d) 10% of the time he will finish in 40% more time than expected.

Dr. Sloan has to leave at 12:15 P.M. on April 29 to catch a flight to a dermatology convention in New York. Assuming that he is ready to start his workday at 9:30 A.M. and that patients are treated in order of their scheduled exam (even if one late patient arrives after an early one), will he be able to make the flight? Build a solution to this problem in Excel. Simulate the problem with Risk Solver. Upload a report commenting on this simulation and also your Excel worksheet.