supermarket wishes to study the operation of a checkout counter. The arrival times of customers to the checkout counter are known to be exponentially distributed, with a mean inter-arrival time of 2.3** minutes. The checkout times (service times) are distributed as follows:

Checkout Time (Min.)0.8 1.6 2.3 3.1 3.8 Probability (fraction of time)0.07 0.20 0.45 0.21 0.07

If the checkout counter is busy the customers must wait in line until the counter becomes free. We want to estimate:

1). The fraction of time the checkout counter is busy

2). The Average number of customers waiting in line (if any) 3). The Average waiting time for the customers who wait.

Develop a spreadsheet that can be used to simulate 100 events ((an event is an arrival or departure).