USE EXCEL ( SIMULATION)

Telephone calls come into an office randomly. The time between calls follows a uniform distribution between 1min and 15 mins. When the receptionist is busy, a telephone message tells the caller that the call is important and to please wait on the line until the next reservation agent becomes available. We can assume that customers don't hang up once they join the call queue. The service time for call is the following discrete distribution: Probability Service time 6 7 .20 .30 .30 20 8 9 Simulate the operation of the office telephone system for 1100 customers. Discard the first 100 customers and use data over the next 1000 customers to answer the following questions: 1. What is the average waiting time for customers? 2. What is the utilization of the receptionist? 3. What is the probability that a customer waits for longer than 1 min before their call is answered