Consider the queueing problem in Question 1. a) Data was collected on the same queueing system on Thursday. The data is available in the Excel file. ii. (1 point) Compute the a, p, CVa, CVp for this queueing system. Use minutes as your time unit. iii. (6 points) Compute the average number of trucks in the queue, average number of trucks in the system, average number of trucks being served, average utilization rate of a server, average wait time in the queue (in minutes) per truck, average time spent in the system (in minutes) per truck, and average service time (in minutes) per truck. You must show all the work you do as you calculate each value.

Average no. of trucks in the queue Average no. of trucks in the system Average no. of trucks being served Average utilization rate of a server Average wait time in the queue per truck (in minutes) Average time spent in the system per truck (in minutes) Average service time per truck (in minutes)\

6 iv. (1 point) Compare the queuing performance in parts a, b, c of Question 1 to part a of Question 2. What is the effect of increase in utilization rate of servers on wait times? b) (1 point) Explain clearly why high utilization rates have a significant impact on the queueing performance.

Part a) Data collected on Thursday
Trucks	Time between arrivals (minutes)	Service time (minutes)
1	0.48	0.28
2	0.096	0.4
3	0.128	0.28
4	0.288	0.24
5	0.448	0.28
6	0.416	0.24
7	0.32	0.32
8	0.32	0.24
9	0.256	0.24
10	0.224	0.28
11	0.096	0.36
12	0.16	0.2
13	0.448	0.28
14	0.16	0.24
15	0.384	0.28
16	0.192	0.28
17	0.352	0.24
18	0.224	0.24