Use the spreadsheet template in table 79 to simulate a

Question

Discussion Questions -

Q1. Use the spreadsheet template in Table 7.9 to simulate a customer service desk with two servers. The start time of the process is 9:00 AM (cell C4), and the inter-arrival times (cells B5 to B14) are given in minutes. Assume that the process consists of a single queue operating under a first-in-first-out discipline. That is, customers join the queue and move to the first available customer service representative in the order in which they arrived. Calculate the average waiting time and the utilization of each server.

Q2. The chief of staff in the emergency room of Exercise is considering the computerization of the admissions process. This change will not reduce the 10 min service time, but it wills male it constant. Develop a spreadsheet simulation to compare the performance of the proposed automated process with the performance of the manual existing process. Hint: Note that inter arrival and service times that follow an exponential distribution can be generated with the Excel functions RAND() and LN() and the following expressions:

A_j = -(1/λ)xLN(RAND())

S_j = -(1/μ)xLN(RAND())

where

μ is the mean service rate

λ is the mean arrival rate

The Excel formula RAND() generates a random number between 0 and 1. The natural logarithm of the random number is found to transform this number into an exponentially distributed value. The transformation to an exponential distribution is completed when the value is divided by the appropriated mean rate and the negative sign applied. (Simulate 500 patient is each case.)

Q3. At Letchworth Community College, one person, the registrar, registers students for classes. Students arrive at a rate of 10/h (Poisson arrivals), and the registration process takes 5 min on the average (exponential distribution). The registrar is paid $5 per hour, and the cost of keeping students waiting is estimated to be $2 for each student for each hour waited (not including service time). Develop a process driven spreadsheet simulation to compare the estimated hourly cost of the following three systems.

a. The current system.

b. A computerized system that results in a service time of exactly 4 min. The computer leasing cost is $7 per hour.

c. Hiring a more efficient registrar. Service time could be reduced to an average of 3 min (exponentially distributed), and the new registrar would be paid $5 per hour.