Reference no: EM133626815
Assignment:
Exercise 15.1 Arrivals to a flu shot clinic held by a local grocery store follow a Poisson distribution with a mean of 1.0 providing the paperwork it takes eight minutes to complete the flu shot process once a person turns up. Using the Monte Carlo simulation
1) Simulate the process for the first twenty persons arriving for flu shots
2) Determine the average time in queue.
3) Determine the service utilization
4) Determine the average time in the system. The Poisson distribution is a probability distribution that is used to show how many times an event is likely to occur over a specified period of time. It is also known as the count distribution 15.3 Using Excel to simulate the flu shot clinic process in Exercise 15.1 for one thousand hours and answer the following:
1) how many people arrived for flu shots
2) How many balked due to queues?
3) What is the average number of persons in the system (L)?
4) What is the average waiting time (Wq)?
5) What is the average total time in the system (W)?