Use the simulation templates provided to simulate a system with 3 tellers in the following two scenarios: • In one sheet assume there is a single queue and everyone is served First Come First Served (FCFS) • In another assume that there is a queue for each teller – Assume customers join the 3 queues cyclically – that is first to queue 1, second to queue 2, third to queue 3, fourth to queue 1, fifth to queue 2, etc Simulate100 (one thousand) customer arrivals using excel. Compare the performance under the two service rules.

  

Transcribed Image Text:

1 2 4 5 7 8 9 10 11 12 A 29 30 31 1 2 3 13 7 14 8 15 9 16 10 17 11 18 12 19 13 20 14 21 15 22 16 23 17 24 18 19 20 4 5 6 25 26 27 21 28 22 23 24 25 43 44 45 32 26 33 27 34 28 35 29 36 30 37 31 38 32 39 33 40 34 41 35 42 36 37 38 39 40 46 47 41 48 42 49 43 50 44 51 45 52 46 53 47 54 48 55 49 56 50 57 51 58 52 59 53 60 54 61 55 62 56 63 57 64 58 65 59 66 60 67 61 68 62 69 63 70 64 71 65 72 | 66 73 67 74 68 75 69 76 70 77 71 78 72 7972 B Interarrival time C Clock (Arrival D I J E F Three Servers QUEUE SIMULATION FOR FCN BANK Service time Teller 1 TS TF G H Teller 2 TS TF Teller 3 TS TF K Server L Waiting Time M Time in System N 0 OP Interarrival Time Seconds (mid points used] 2.5 7.5 12.5 17.5 22.5 27.5 R 5 15 25 35 45 55 65 75 85 95 105 115 Probability 0.47 0.23 0.15 0.08 0.04 0.03 Service Time Seconds (mid-points used) Probability 0.02 0.20 0.20 0.17 0.10 0.09 0.10 0.03 0.05 0.02 0.01 0.01 S 1 2 4 5 7 8 9 10 11 12 A 29 30 31 1 2 3 13 7 14 8 15 9 16 10 17 11 18 12 19 13 20 14 21 15 22 16 23 17 24 18 19 20 4 5 6 25 26 27 21 28 22 23 24 25 43 44 45 32 26 33 27 34 28 35 29 36 30 37 31 38 32 39 33 40 34 41 35 42 36 37 38 39 40 46 47 41 48 42 49 43 50 44 51 45 52 46 53 47 54 48 55 49 56 50 57 51 58 52 59 53 60 54 61 55 62 56 63 57 64 58 65 59 66 60 67 61 68 62 69 63 70 64 71 65 72 | 66 73 67 74 68 75 69 76 70 77 71 78 72 7972 B Interarrival time C Clock (Arrival D I J E F Three Servers QUEUE SIMULATION FOR FCN BANK Service time Teller 1 TS TF G H Teller 2 TS TF Teller 3 TS TF K Server L Waiting Time M Time in System N 0 OP Interarrival Time Seconds (mid points used] 2.5 7.5 12.5 17.5 22.5 27.5 R 5 15 25 35 45 55 65 75 85 95 105 115 Probability 0.47 0.23 0.15 0.08 0.04 0.03 Service Time Seconds (mid-points used) Probability 0.02 0.20 0.20 0.17 0.10 0.09 0.10 0.03 0.05 0.02 0.01 0.01 S