9.  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.

10.  Calculate the following summary statistics for question 9:

 a. Number of patients who wait for

b. Probability of waiting for

c. Average wait time 

d. Maximum wait time

e. Percentage of time server is busy

f. The number waiting > 1 minute