Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments
2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments in his hospital. Some of the patients take more or less than 30 minutes depending on the type of patient's health issue. The following summary shows the various types of health issues, their probabilities and time actually needed to complete the check up: Type of health issue (A-E) Time Required for check up Probability of patients' health issue type A 40 0.40 B 0.15 0.20 0.10 0.15 D E 15 25 60 30 Simulate the hospital for five hours and determine the average waiting time for the patients. Assume that all the patients show up at the hospital at exactly their scheduled arrival time starting at 7.00 a.m till 11:30 am. For patient arrival, use random numbers with a uniform distribution. Run ten or more experiments to estimate the average waiting time of hospital patients, and briefly comment on the efficiency of hospital operations given the waiting time.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started