How to solve Using excel. Please include steps and formulas

10-38. ?A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table:

\table[[\table[[Time Between],[Arrivals (min.)]],Probability],[1,0.15],[2,0.24],[3,0.27],[4,0.22],[5,0.12]]

\table[[\table[[Service Time],[(min.)]],Probability],[1,0.15],[2,0.35],[3,0.22],[4,0.28]]

Simulate the arrival of 200 ?customers to compute each of the following measures: (a) ?average time a customer waits for service, (b) ?average time a customer

A B c D E F G H J K L M N 0 P Q 1 |Problem 10-38 Queueing Problem 2 |(Calculations set to Manual. Press F9 to recalculate). 3 Time Between Arrival Begin Wait for Service End Timein 4 (Customer Arrivals Time Service Service Time Service System 5 0 0 0 0 0 0 0 0 6 1 7 2 8 3 9 4 10 5 1| 6 12 7 RN intvl LL Time Probabili 9 13 g 10 14 9 11 15 10 12 16 11 13 17 12 14 18 13 Based on 1 replication: 15 19 14 Avg customer wait (minutes) 16 20 15 Avg customer system (minutes) 17 % Teller Utilization (Total Service Time / il 16 Total Operating Minutes of Bank) 18 22 17 19 23 18 Based on 200 replications: 20 2 19 Avg customer wait (minutes) 21 25 20 Avg customer system (minutes) 22 % Teller Utilization (Total Service Time / 26 21 Total Operating Minutes of Bank) 23 27 22 24 28 23 25 29 24 26 30 25 27 A 26 28 32 27 29 33 28 30 34 29 31