Each Tuesday, the new residents at an inpatient rehabilitation clinic must visit the medication lab and have
Question:
Each Tuesday, the new residents at an inpatient rehabilitation clinic must visit the medication lab and have all of their existing medications inventoried when they arrive. The interarrival times of patients to the medication lab follow a uniform distribution with an upper bound of 45 minutes and a lower bound of 30 minutes. The service times to have their medication logged follow a normal distribution with a mean of 20 minutes and a standard deviation of 5 seconds. Using Excel, determine queuing and service statistics for the 40 patients who visit the medication lab over a one-day period. The columns of data you will need to generate include patient ID, interarrival time, arrival time, service start time, wait time, service time, service completion time, time in the system, and server idle time. The service times to have medication logged should be a mean of 20 minutes with a standard deviation of 5 minutes.
Calculate the following summary statistics for the question:
a. Number of patients who wait
b. Probability of waiting
c. Average wait time
d. Maximum wait time
e. Percentage of time server is busy
f. Number waiting > 1 minute
g. Probability of waiting > 1 minute
h. Average number of patients in line REFERENCES
Provide the answers in excel with formulas and explanation
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor