For the first example, please create a chart that shows the increase in average time in line when the arrival rate increases from 5 customers per hour to 14 customers per hour (increments will be half an hour). You will have to create a data table (What-if Analysis -> Data Table) Comment on your findings in a textbox. SHOW ALL WORK FOR EXCEL

D E F G Arrival Rate Average Time in Line Average Number in Line Utilization A B Single Channel (Server) Waiting Line Model Arrival rate Interarrival Time Service rate Service time 2 = 17. = = 1/4 = 10 6.00 15 4.00 every hour minutes between arrivals every hour minutes service time Constant Service Time 6.00 6.50 7.00 7.50 8.00 8.50 9.00 9.50 10.00 Exponential Service Time 66.7% 33.3% 1.3333 2.0000 0.1333 System Utilization Probability system is empty Average number in line Average number in system Average time in line (hrs) Average time in system (hrs) 10.50 p= Po = La= Ls= W = W, = 11.00 11.50 0.2000 P( 3 units in system) PL