Question: provide excel file with simulation A clinical assistant to the doctor's office wants to study the amount of time a patient spends waiting for a
provide excel file with simulation
A clinical assistant to the doctor's office wants to study the amount of time a patient spends waiting for a doctor. She decides to use simulation to estimate this waiting time. The doctor's office has two doctors working during the day, Doctor A and Doctor B Patients wait for doctors in a single FIFO queue. Each patient is served by the first doctor that becomes available and then leaves the office. If a patient finds both doctors available, then the patient is served by Doctor A
From empirical study, the following probability distributions on the time between arrivals of patients and on the doctors' service time the same for both doctors are available:
tabletablePatient interarrival timein minutesProbability
tabletableDoctor service timein minutesProbability
Sketch the whole process at the doctor's office. Label the components of your diagram.
What are the expected interarrival time and expected service time without simulation
What are the arrival rate and service rate without simulation If the doctor's office had only one doctor, what could you say about the expected waiting time of patients using your knowledge of queuing theory
Using the following random numbers from uniform distribution between and simulate the arrival and service of customers.
From the simulation, what is your best estimate of the average patient waiting time?
What is your best estimate of the average number of patients waiting? Explain.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
