Single Channel Queue System-Simulation with Excel

A small supermarket shop has a single checkout counter. Customers come to the cash register randomly every 1 to 8 minutes. The probabilities of the possible values of the time between arrivals are equally probable as given in the table below.

Figure 1: Distribution of time between arrivals

Time Between Arrivals (Minutes)	Possibility
1	0,05
2	0,10
3	0,20
4	0,25
5	0,15
6	0,10
7	0,10
8	0,05

Service times vary according to the possibilities given in the table below.

Figure 2: Distribution of Service Time

Service Time (Minutes)	Possibility
1	0,15
2	0,20
3	0,20
4	0,30
5	0,10
6	0,05

The problem can simulate the reach and service for 100 customers and deliver the following to their accounts with Excel.

a) Average queuing time per customer,

b) The probability of having to wait in a queue,

c) The free time percentage of the cashier,

d) Average service time,

e) Average time between arrivals,

f) Total waiting time in the queue,

g) Average time used in an animal system,

Please solve using Monte Carlo simulation with EXCEL.