An average of 30 cars per hour arrive at a single-server drive-in a McDonalds shop. Assume that the average service time for each customer (car) is 1 min. and that the queue created complies with the assumptions of the M/M/1 queue:

. Create an Excel simulation and run it to answer the following:

. What is the probability that the server is idle?

. What is the average number of cars waiting in line for coffee?

. What is the amount of time a customer spends in the drive through area(including serving time)?

. How many customers per hour will be server by this shop?

. Create a graph with probabilities that there are n cars in the queue for n from 0 to 30