Question

QUESTION 1 [25%]. An orthopedic clinic takes appointments between 8:00 and 11:30 a.m. and between 1:00 and 3:30 p.m. and is operational 234 days per year. The clinic receives 24,903 visits annually. Because patient visits involve more than just a visit with the MD, the clinic flow is not a simple in-and-out process. Patients are subjected to a multiple-line queuing system. The first step is patient registration. Four registration clerks are able to register an average of 5.5 patients per hour. Registration includes co-pay collection, insurance and referral verification, and updating demographics in the computer information system. Although the clerical staff have other duties at the end of the day, their only responsibility for this six-hour span is to register patients. The second step is nurse check-in, in which six nurses spend an average of ten minutes with each patient. The average time a patient is with one of the seven MDs is twenty-four minutes. Arrivals follow a Poisson distribution, with a mean of 15 for all steps.

For each individual process (registration, nurse check-in, and MD visit), compute the following performance metrics using the Excel queuing template:

1. a Arrival and service rates

1.b Average number of patients in a queue

1.c Average number of patients in the system

1.d Probability of idle time

1.e System utilization rate

Answer 1

	No. of servers (s)	Arrival rate per hr. (λ)	Service rate per hr. (μ)
Registration	4	15	5.5
Nurse Check-in	6	15	60/10=6
MDs	7	15	60/24=2.5

(B)to (E)

Excel QM use to find queuing parameters

Go waiting Lines - Several server models (M/M/s) and enter the details as:-

Summary :-

	Registration	Nurse Check-In	MDs
Utilization	0.682	0.417	0.857
Average customers in queue (Lq)	0.859	0.034	3.683
Average customers in system(Ls)	3.586	2.534	9.683
Probability of idle server	0.055	0.082	0.002

Thank You Please Upvote and like my answer it will be highly appreciated and helpful. Please like....!!!!!