please help with excel

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 Roma 9:30 AM 15 Dwight 9:45 A.M. 20 Patrick 15 10:15 AM Wagner 10 10:30 AM Josh 10:45 AM 30 Peyton 11:15 AM 15 Aaron 11:30 AM 20 Eggleston 11:35 AM 15 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. (0) 50% of the time he will finish in the expected time 25% of the time he will finish in 20% more time than expected id) 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 AM, and that patients are treated in order of their scheduled exam (even if one late patient arrives after an early one) wil he be able to make the right? 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 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 Romo 9:30 AM 15 Dwight 9:45 AM 20 Patrick 10:15 AM 15 Wagner 10:30 AM 10 Josh 10:45 AM 30 Peyton 11:15 AM 15 Aaron 11:30 AM 20 15 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 ( 15% of the time he will finish in 20% less time than expected, (b) 50% of the time he will fish in the expected tune (0)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 Apni 29 to catch a flight to a dermatology convention in New York. Assuming that he is ready to start his workday at 9.30AM and that patients are treated in order of their scheduled exan even if one late patient anves after an early one), will he be able to make the right build a solution to this problem in Excel Simulate the problem with Rock Solver Upload w region commenting on this simulation and also your Excel worksheet Josh 15 11:15 AM Peyton 11:30 AM 20 Aaron 11:35 AM 15 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) Sox of the patients will be on time. (d) 20% of the patients will be 10 minutes late. le) 5% of the patients will be 20 minutes late. He further estimates that faj 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. 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 shown in the following table. NAME SCHEDULED APPOINTMENT TIME EXPECTED TIME NEEDED Romo 9:30 A.M. 15 Dwight 9:45 A.M. 20 Patrick 10:15 A. M. 15 Wagner 10:30 A.M. 10 Josh 10:45 A.M. 30 Peyton 11:15 A.M. 15 Aaron 11.30 A.M. 20 Eggleston 11:35 A.M. 15 Unfortunately, not every patient arrives exactly on schedule, and expected times to examine patients are iust that expected. Some examinations take longer than expected, and some take less time. Peyton 11:15 A.M. 15 Aaron 11:30 A.M. 20 Eggleston 11:35 A.M. 15 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: ta) 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. 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 Romo 15 20 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. (6) 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 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 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 Roma 9:30 AM 15 Dwight 9:45 A.M. 20 Patrick 15 10:15 AM Wagner 10 10:30 AM Josh 10:45 AM 30 Peyton 11:15 AM 15 Aaron 11:30 AM 20 Eggleston 11:35 AM 15 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. (0) 50% of the time he will finish in the expected time 25% of the time he will finish in 20% more time than expected id) 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 AM, and that patients are treated in order of their scheduled exam (even if one late patient arrives after an early one) wil he be able to make the right? 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 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 Romo 9:30 AM 15 Dwight 9:45 AM 20 Patrick 10:15 AM 15 Wagner 10:30 AM 10 Josh 10:45 AM 30 Peyton 11:15 AM 15 Aaron 11:30 AM 20 15 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 ( 15% of the time he will finish in 20% less time than expected, (b) 50% of the time he will fish in the expected tune (0)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 Apni 29 to catch a flight to a dermatology convention in New York. Assuming that he is ready to start his workday at 9.30AM and that patients are treated in order of their scheduled exan even if one late patient anves after an early one), will he be able to make the right build a solution to this problem in Excel Simulate the problem with Rock Solver Upload w region commenting on this simulation and also your Excel worksheet Josh 15 11:15 AM Peyton 11:30 AM 20 Aaron 11:35 AM 15 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) Sox of the patients will be on time. (d) 20% of the patients will be 10 minutes late. le) 5% of the patients will be 20 minutes late. He further estimates that faj 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. 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 shown in the following table. NAME SCHEDULED APPOINTMENT TIME EXPECTED TIME NEEDED Romo 9:30 A.M. 15 Dwight 9:45 A.M. 20 Patrick 10:15 A. M. 15 Wagner 10:30 A.M. 10 Josh 10:45 A.M. 30 Peyton 11:15 A.M. 15 Aaron 11.30 A.M. 20 Eggleston 11:35 A.M. 15 Unfortunately, not every patient arrives exactly on schedule, and expected times to examine patients are iust that expected. Some examinations take longer than expected, and some take less time. Peyton 11:15 A.M. 15 Aaron 11:30 A.M. 20 Eggleston 11:35 A.M. 15 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: ta) 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. 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 Romo 15 20 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. (6) 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 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