Problem 9 - The Doctor Will See You 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. NAME SCHEDULED APPOINTMENT TIME EXPECTED TIME NEEDED 9:30 AM Dwight 9:45 AM 20 Romo 15 Patrick 10:15 AM 15 Wagner 10:30 AM 10 Josh 10:45 AM 30 Peyton 11:15 AM 15 15 Aaron 11:30 AM 20 Eggleston 11:35 AM Unfortunately, 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. (c) 50% of the patients will be on time. (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. (c) 25% of the time he will finish in 20% more time than expected. (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