A B C D E F G

1 Case: Winter Park Hotel (Current System)

2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and m must be RATES, and use the same time unit. For example, given a service time such as 10
5 minutes per customer, convert it to a service rate such as 6 per hour.
hour.
6 2. The total service rate (rate x servers) must be greater than the
the arrival
arrival rate.
rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 18 Average server utilization (r) 0.9000
10 Service rate (m) 20 Average number of customers in the queue (Lq) 8.1000
11 Number of servers (s) 1 Average number of customers in the system (L) 9.0000
12 Average waiting time in the queue (Wq) 0.4500
13 Average time in the system (W) 0.5000
14 Probability (% of time) system is empty (P0) 0.1000
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.1000 0.1000
21 1 0.0900 0.1900
22 2 0.0810 0.2710
23 3 0.0729 0.3439
24 4 0.0656 0.4095
25 5 0.0590 0.4686
26 6 0.0531 0.5217
27 7 0.0478 0.5695
28 8 0.0430 0.6126
29 9 0.0387 0.6513
30 10 0.0349 0.6862
31 11 0.0314 0.7176
32 12 0.0282 0.7458
33 13 0.0254 0.7712
 A B C D E F G
34 14 0.0229 0.7941
35 15 0.0206 0.8147
36 16 0.0185 0.8332
37 17 0.0167 0.8499
38 18 0.0150 0.8649
39 19 0.0135 0.8784
40 20 0.0122 0.8906
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 0.9 1 9 0.1 0.9 8.1
45 2 0.405 1.9 0.736363636363636 0.37931 0.45 0.228527
46 3 0.1215 2.305 0.173571428571429 0.40346 0.3 0.030012
47 4 0.0273375 2.4265 0.035274193548387 0.40621 0.225 0.00416
48 5 0.0049208 2.4538375 0.006000914634146 0.40653 0.18 0.000536
49 6 0.0007381 2.45875825 0.000868367647059 0.40657 0.15 6.23E-05
50 7 9.49E-05 2.45949636 0.000108901844262 0.40657 0.128571 6.533E-06
51 8 1.068E-05 2.45959126 1.20296001006036E-05 0.40657 0.1125 6.2E-07
52 9 1.068E-06 2.45960194 1.18625223214286E-06 0.40657 0.1 5.359E-08
53 10 9.609E-08 2.45960301 1.05589484399529E-07 0.40657 0.09 4.246E-09
54 11 7.862E-09 2.4596031 8.56215720031825E-09 0.40657 0.081818 3.102E-10
55 12 5.896E-10 2.45960311 6.37428410736223E-10 0.40657 0.075 2.101E-11
56 13 4.082E-11 2.45960311 4.38561282593311E-11 0.40657 0.069231 1.326E-12
57 14 2.624E-12 2.45960311 2.80442299908465E-12 0.40657 0.064286 7.833E-14
58 15 1.574E-13 2.45960311 1.67498212559311E-13 0.40657 0.06 4.347E-15
59 16 8.856E-15 2.45960311 9.38433694206471E-15 0.40657 0.05625 2.274E-16
60 17 4.689E-16 2.45960311 4.95082061501007E-16 0.40657 0.052941 1.125E-17
61 18 2.344E-17 2.45960311 2.46774649850347E-17 0.40657 0.05 5.281E-19
62 19 1.11E-18 2.45960311 1.1657034564754E-18 0.40657 0.047368 2.357E-20
63 20 4.997E-20 2.45960311 5.23265618792621E-20 0.40657 0.045 1E-21
64 21 2.142E-21 2.45960311 2.23754626543412E-21 0.40657 0.042857 4.073E-23
65 22 8.761E-23 2.45960311 9.13500608027606E-23 0.40657 0.040909 1.584E-24
66 23 3.428E-24 2.45960311 3.56795074998853E-24 0.40657 0.03913 5.908E-26
67 24 1.286E-25 2.45960311 1.33571504643839E-25 0.40657 0.0375 2.116E-27
68 25 4.628E-27 2.45960311 4.80109194596373E-27 0.40657 0.036 7.29E-29
 A B C D E F G
69 26 1.602E-28 2.45960311 1.65953281765663E-28 0.40657 0.034615 2.419E-30
70 27 5.34E-30 2.45960311 5.52443948583306E-30 0.40657 0.033333 7.745E-32
71 28 1.717E-31 2.45960311 1.77352854342242E-31 0.40657 0.032143 2.395E-33
72 29 5.327E-33 2.45960311 5.4977581563387E-33 0.40657 0.031034 7.159E-35
73 30 1.598E-34 2.45960311 1.64756847699734E-34 0.40657 0.03 2.072E-36
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 9 0.45 0.5
45 1.128527 0.012696 0.062696
46 0.930012 0.001667 0.051667
47 0.90416 0.000231 0.050231
48 0.900536 2.975E-05 0.05003
49 0.900062 3.461E-06 0.050003
50 0.900007 3.629E-07 0.05
51 0.900001 3.444E-08 0.05
52 0.9 2.977E-09 0.05
53 0.9 2.359E-10 0.05
54 0.9 1.723E-11 0.05
55 0.9 1.167E-12 0.05
56 0.9 7.368E-14 0.05
57 0.9 4.352E-15 0.05
58 0.9 2.415E-16 0.05
59 0.9 1.263E-17 0.05
60 0.9 6.251E-19 0.05
61 0.9 2.934E-20 0.05
62 0.9 1.309E-21 0.05
63 0.9 5.569E-23 0.05
64 0.9 2.263E-24 0.05
65 0.9 8.801E-26 0.05
66 0.9 3.282E-27 0.05
67 0.9 1.175E-28 0.05
68 0.9 4.05E-30 0.05
 H I J
69 0.9 1.344E-31 0.05
70 0.9 4.303E-33 0.05
71 0.9 1.33E-34 0.05
72 0.9 3.977E-36 0.05
73 0.9 1.151E-37 0.05
 A B C D E F G
1 Case: Winter Park Hotel (Quick Server)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and m must bebe RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time
time such
such as
as 10
10
5 minutes per customer, convert it to a service rate such as 6 per hour.
6 2. The total service rate (rate x servers) must be greater than the arrival rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 27 Average server utilization (r) 0.9000
10 Service rate (m) 30 Average number of customers in the queue (Lq) 8.1000
11 Number of servers (s) 1 Average number of customers in the system (L) 9.0000
12 Average waiting time in the queue (Wq) 0.3000
13 Average time in the system (W) 0.3333
14 Probability (% of time) system is empty (P0) 0.1000
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.1000 0.1000
21 1 0.0900 0.1900
22 2 0.0810 0.2710
23 3 0.0729 0.3439
24 4 0.0656 0.4095
25 5 0.0590 0.4686
26 6 0.0531 0.5217
27 7 0.0478 0.5695
28 8 0.0430 0.6126
29 9 0.0387 0.6513
30 10 0.0349 0.6862
31 11 0.0314 0.7176
32 12 0.0282 0.7458
33 13 0.0254 0.7712
 A B C D E F G
34 14 0.0229 0.7941
35 15 0.0206 0.8147
36 16 0.0185 0.8332
37 17 0.0167 0.8499
38 18 0.0150 0.8649
39 19 0.0135 0.8784
40 20 0.0122 0.8906
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 0.9 1 9 0.1 0.9 8.1
45 2 0.405 1.9 0.736363636363636 0.37931 0.45 0.228527
46 3 0.1215 2.305 0.173571428571429 0.40346 0.3 0.030012
47 4 0.0273375 2.4265 0.035274193548387 0.40621 0.225 0.00416
48 5 0.0049208 2.4538375 0.006000914634146 0.40653 0.18 0.000536
49 6 0.0007381 2.45875825 0.000868367647059 0.40657 0.15 6.23E-05
50 7 9.49E-05 2.45949636 0.000108901844262 0.40657 0.128571 6.533E-06
51 8 1.068E-05 2.45959126 1.20296001006036E-05 0.40657 0.1125 6.2E-07
52 9 1.068E-06 2.45960194 1.18625223214286E-06 0.40657 0.1 5.359E-08
53 10 9.609E-08 2.45960301 1.05589484399529E-07 0.40657 0.09 4.246E-09
54 11 7.862E-09 2.4596031 8.56215720031825E-09 0.40657 0.081818 3.102E-10
55 12 5.896E-10 2.45960311 6.37428410736223E-10 0.40657 0.075 2.101E-11
56 13 4.082E-11 2.45960311 4.38561282593311E-11 0.40657 0.069231 1.326E-12
57 14 2.624E-12 2.45960311 2.80442299908465E-12 0.40657 0.064286 7.833E-14
58 15 1.574E-13 2.45960311 1.67498212559311E-13 0.40657 0.06 4.347E-15
59 16 8.856E-15 2.45960311 9.38433694206471E-15 0.40657 0.05625 2.274E-16
60 17 4.689E-16 2.45960311 4.95082061501007E-16 0.40657 0.052941 1.125E-17
61 18 2.344E-17 2.45960311 2.46774649850347E-17 0.40657 0.05 5.281E-19
62 19 1.11E-18 2.45960311 1.1657034564754E-18 0.40657 0.047368 2.357E-20
63 20 4.997E-20 2.45960311 5.23265618792621E-20 0.40657 0.045 1E-21
64 21 2.142E-21 2.45960311 2.23754626543412E-21 0.40657 0.042857 4.073E-23
65 22 8.761E-23 2.45960311 9.13500608027606E-23 0.40657 0.040909 1.584E-24
66 23 3.428E-24 2.45960311 3.56795074998853E-24 0.40657 0.03913 5.908E-26
67 24 1.286E-25 2.45960311 1.33571504643839E-25 0.40657 0.0375 2.116E-27
68 25 4.628E-27 2.45960311 4.80109194596373E-27 0.40657 0.036 7.29E-29
 A B C D E F G
69 26 1.602E-28 2.45960311 1.65953281765663E-28 0.40657 0.034615 2.419E-30
70 27 5.34E-30 2.45960311 5.52443948583306E-30 0.40657 0.033333 7.745E-32
71 28 1.717E-31 2.45960311 1.77352854342242E-31 0.40657 0.032143 2.395E-33
72 29 5.327E-33 2.45960311 5.4977581563387E-33 0.40657 0.031034 7.159E-35
73 30 1.598E-34 2.45960311 1.64756847699734E-34 0.40657 0.03 2.072E-36
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 9 0.3 0.333333
45 1.128527 0.008464 0.041797
46 0.930012 0.001112 0.034445
47 0.90416 0.000154 0.033487
48 0.900536 1.983E-05 0.033353
49 0.900062 2.308E-06 0.033336
50 0.900007 2.419E-07 0.033334
51 0.900001 2.296E-08 0.033333
52 0.9 1.985E-09 0.033333
53 0.9 1.573E-10 0.033333
54 0.9 1.149E-11 0.033333
55 0.9 7.783E-13 0.033333
56 0.9 4.912E-14 0.033333
57 0.9 2.901E-15 0.033333
58 0.9 1.61E-16 0.033333
59 0.9 8.422E-18 0.033333
60 0.9 4.167E-19 0.033333
61 0.9 1.956E-20 0.033333
62 0.9 8.728E-22 0.033333
63 0.9 3.713E-23 0.033333
64 0.9 1.509E-24 0.033333
65 0.9 5.867E-26 0.033333
66 0.9 2.188E-27 0.033333
67 0.9 7.836E-29 0.033333
68 0.9 2.7E-30 0.033333
 H I J
69 0.9 8.96E-32 0.033333
70 0.9 2.869E-33 0.033333
71 0.9 8.869E-35 0.033333
72 0.9 2.652E-36 0.033333
73 0.9 7.673E-38 0.033333
 A B C D E F G
1 Case: Winter Park Hotel (Slow Servers)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and
and m must
must be
be RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time such as 10
5 minutes per customer, convert it to a service rate such as 6 per hour.
hour.
6 2. The total service rate (rate x servers) must be greater than the
the arrival
arrival rate.
rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 15.75 Average server utilization (r) 0.8925
10 Service rate (m) 17.647 Average number of customers in the queue (Lq) 7.4098
11 Number of servers (s) 1 Average number of customers in the system (L) 8.3023
12 Average waiting time in the queue (Wq) 0.4705
13 Average time in the system (W) 0.5271
14 Probability (% of time) system is empty (P0) 0.1075
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.1075 0.1075
21 1 0.0959 0.2034
22 2 0.0856 0.2891
23 3 0.0764 0.3655
24 4 0.0682 0.4337
25 5 0.0609 0.4946
26 6 0.0543 0.5489
27 7 0.0485 0.5974
28 8 0.0433 0.6407
29 9 0.0386 0.6793
30 10 0.0345 0.7138
31 11 0.0308 0.7446
32 12 0.0275 0.7720
33 13 0.0245 0.7965
 A B C D E F G
34 14 0.0219 0.8184
35 15 0.0195 0.8379
36 16 0.0174 0.8553
37 17 0.0156 0.8709
38 18 0.0139 0.8848
39 19 0.0124 0.8972
40 20 0.0111 0.9082
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 0.8925 1 8.30232558139535 0.1075 0.8925 7.409826
45 2 0.3982781 1.8925 0.719238148984199 0.38289 0.44625 0.221926
46 3 0.1184877 2.29077813 0.168665825177936 0.4066 0.2975 0.029042
47 4 0.0264376 2.40926587 0.034030670925935 0.40928 0.223125 0.004
48 5 0.0047191 2.43570344 0.005744501009607 0.40959 0.1785 0.000511
49 6 0.000702 2.44042255 0.00082463113355 0.40963 0.14875 5.903E-05
50 7 8.95E-05 2.44112452 0.00010257974176 0.40963 0.1275 6.14E-06
51 8 9.985E-06 2.44121402 1.12387599059763E-05 0.40963 0.111563 5.781E-07
52 9 9.902E-07 2.44122401 1.09917424118588E-06 0.40963 0.099167 4.957E-08
53 10 8.837E-08 2.441225 9.70331287482228E-08 0.40963 0.08925 3.895E-09
54 11 7.17E-09 2.44122508 7.80339677384553E-09 0.40963 0.081136 2.823E-10
55 12 5.333E-10 2.44122509 5.76138181456362E-10 0.40963 0.074375 1.896E-11
56 13 3.661E-11 2.44122509 3.93111257078597E-11 0.40963 0.068654 1.187E-12
57 14 2.334E-12 2.44122509 2.49295801375203E-12 0.40963 0.06375 6.953E-14
58 15 1.389E-13 2.44122509 1.47660712867977E-13 0.40963 0.0595 3.827E-15
59 16 7.747E-15 2.44122509 8.20425938465707E-15 0.40963 0.055781 1.985E-16
60 17 4.067E-16 2.44122509 4.2923199566752E-16 0.40963 0.0525 9.742E-18
61 18 2.017E-17 2.44122509 2.12174399787383E-17 0.40963 0.049583 4.534E-19
62 19 9.472E-19 2.44122509 9.93932191493294E-19 0.40963 0.046974 2.007E-20
63 20 4.227E-20 2.44122509 4.42451840708384E-20 0.40963 0.044625 8.466E-22
64 21 1.797E-21 2.44122509 1.87624706641909E-21 0.40963 0.0425 3.411E-23
65 22 7.288E-23 2.44122509 7.59626725211859E-23 0.40963 0.040568 1.316E-24
66 23 2.828E-24 2.44122509 2.94227284732666E-24 0.40963 0.038804 4.866E-26
67 24 1.052E-25 2.44122509 1.09232029969104E-25 0.40963 0.037188 1.728E-27
68 25 3.755E-27 2.44122509 3.89356809043889E-27 0.40963 0.0357 5.905E-29
 A B C D E F G
69 26 1.289E-28 2.44122509 1.3346417129651E-28 0.40963 0.034327 1.943E-30
70 27 4.26E-30 2.44122509 4.40593165114388E-30 0.40963 0.033056 6.17E-32
71 28 1.358E-31 2.44122509 1.40267816505133E-31 0.40963 0.031875 1.892E-33
72 29 4.179E-33 2.44122509 4.31196748269051E-33 0.40963 0.030776 5.609E-35
73 30 1.243E-34 2.44122509 1.2814539886047E-34 0.40963 0.02975 1.61E-36
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 8.302326 0.470465 0.527132
45 1.114426 0.014091 0.070757
46 0.921542 0.001844 0.058511
47 0.8965 0.000254 0.056921
48 0.893011 3.246E-05 0.056699
49 0.892559 3.748E-06 0.05667
50 0.892506 3.899E-07 0.056667
51 0.892501 3.67E-08 0.056667
52 0.8925 3.147E-09 0.056667
53 0.8925 2.473E-10 0.056667
54 0.8925 1.792E-11 0.056667
55 0.8925 1.204E-12 0.056667
56 0.8925 7.537E-14 0.056667
57 0.8925 4.415E-15 0.056667
58 0.8925 2.43E-16 0.056667
59 0.8925 1.261E-17 0.056667
60 0.8925 6.186E-19 0.056667
61 0.8925 2.879E-20 0.056667
62 0.8925 1.274E-21 0.056667
63 0.8925 5.375E-23 0.056667
64 0.8925 2.166E-24 0.056667
65 0.8925 8.354E-26 0.056667
66 0.8925 3.089E-27 0.056667
67 0.8925 1.097E-28 0.056667
68 0.8925 3.749E-30 0.056667
 H I J
69 0.8925 1.234E-31 0.056667
70 0.8925 3.917E-33 0.056667
71 0.8925 1.201E-34 0.056667
72 0.8925 3.561E-36 0.056667
73 0.8925 1.022E-37 0.056667
 A B C D E F G
1 Case: Winter Park Hotel (Single Line)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and m must bebe RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time
time such
such as
as 10
10
5 minutes per customer, convert it to a service rate such as 6 per hour.
6 2. The total service rate (rate x servers) must be greater than the arrival rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 90 Average server utilization (r) 0.9000
10 Service rate (m) 20 Average number of customers in the queue (Lq) 6.8624
11 Number of servers (s) 5 Average number of customers in the system (L) 11.3624
12 Average waiting time in the queue (Wq) 0.0762
13 Average time in the system (W) 0.1262
14 Probability (% of time) system is empty (P0) 0.0050
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.0050 0.0050
21 1 0.0223 0.0273
22 2 0.0502 0.0775
23 3 0.0753 0.1528
24 4 0.0847 0.2375
25 5 0.0762 0.3138
26 6 0.0686 0.3824
27 7 0.0618 0.4441
28 8 0.0556 0.4997
29 9 0.0500 0.5498
30 10 0.0450 0.5948
31 11 0.0405 0.6353
32 12 0.0365 0.6718
33 13 0.0328 0.7046
 A B C D E F G
34 14 0.0295 0.7341
35 15 0.0266 0.7607
36 16 0.0239 0.7846
37 17 0.0215 0.8062
38 18 0.0194 0.8256
39 19 0.0174 0.8430
40 20 0.0157 0.8587
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 4.5 1 -1.28571428571429 -3.5 4.5 -5.785714
45 2 10.125 5.5 -8.1 -0.38462 2.25 -5.607692
46 3 15.1875 15.625 -30.375 -0.0678 1.5 -6.177966
47 4 17.085938 30.8125 -136.6875 -0.00945 1.125 -11.61924
48 5 15.377344 47.8984375 153.7734375 0.00496 0.9 6.862439
49 6 11.533008 63.2757813 46.13203125 0.00914 0.75 1.264956
50 7 7.4140765 74.8087891 20.7594140625 0.01046 0.642857 0.390998
51 8 4.170418 82.2228655 9.53238400829082 0.0109 0.5625 0.133572
52 9 2.085209 86.3932835 4.17041800362723 0.01104 0.5 0.04605
53 10 0.9383441 88.4784925 1.70608009239296 0.01109 0.45 0.015478
54 11 0.383868 89.4168366 0.649622804411165 0.0111 0.409091 0.004993
55 12 0.1439505 89.8007046 0.230320812473049 0.01111 0.375 0.001535
56 13 0.049829 89.9446551 0.076209092362406 0.01111 0.346154 0.000448
57 14 0.0160165 89.9944841 0.023603220913863 0.01111 0.321429 0.000124
58 15 0.0048049 90.0105006 0.00686420200046 0.01111 0.3 3.268E-05
59 16 0.0013514 90.0153055 0.001880194460996 0.01111 0.28125 8.173E-06
60 17 0.0003577 90.0166569 0.000486500316783 0.01111 0.264706 1.946E-06
61 18 8.943E-05 90.0170146 0.000119240273721 0.01111 0.25 4.415E-07
62 19 2.118E-05 90.0171041 2.77542016420097E-05 0.01111 0.236842 9.569E-08
63 20 4.766E-06 90.0171253 6.14927557603101E-06 0.01111 0.225 1.983E-08
64 21 1.021E-06 90.01713 1.29973324675201E-06 0.01111 0.214286 3.938E-09
65 22 2.089E-07 90.017131 2.62599166180508E-07 0.01111 0.204545 7.501E-10
66 23 4.087E-08 90.0171313 5.0810035225344E-08 0.01111 0.195652 1.373E-10
67 24 7.663E-09 90.0171313 9.43129416390164E-09 0.01111 0.1875 2.418E-11
68 25 1.379E-09 90.0171313 1.6821058188666E-09 0.01111 0.18 4.102E-12
 A B C D E F G
69 26 2.387E-10 90.0171313 2.88696301005478E-10 0.01111 0.173077 6.713E-13
70 27 3.979E-11 90.0171313 4.77459267047521E-11 0.01111 0.166667 1.061E-13
71 28 6.395E-12 90.0171313 7.61903085714129E-12 0.01111 0.160714 1.621E-14
72 29 9.923E-13 90.0171313 1.17450803665115E-12 0.01111 0.155172 2.396E-15
73 30 1.488E-13 90.0171313 1.75104139338458E-13 0.01111 0.15 3.433E-16
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 -1.285714 -0.064286 -0.014286
45 -1.107692 -0.062308 -0.012308
46 -1.677966 -0.068644 -0.018644
47 -7.119244 -0.129103 -0.079103
48 11.36244 0.076249 0.126249
49 5.764956 0.014055 0.064055
50 4.890998 0.004344 0.054344
51 4.633572 0.001484 0.051484
52 4.54605 0.000512 0.050512
53 4.515478 0.000172 0.050172
54 4.504993 5.548E-05 0.050055
55 4.501535 1.705E-05 0.050017
56 4.500448 4.98E-06 0.050005
57 4.500124 1.38E-06 0.050001
58 4.500033 3.631E-07 0.05
59 4.500008 9.081E-08 0.05
60 4.500002 2.162E-08 0.05
61 4.5 4.906E-09 0.05
62 4.5 1.063E-09 0.05
63 4.5 2.204E-10 0.05
64 4.5 4.375E-11 0.05
65 4.5 8.335E-12 0.05
66 4.5 1.526E-12 0.05
67 4.5 2.686E-13 0.05
68 4.5 4.558E-14 0.05
 H I J
69 4.5 7.458E-15 0.05
70 4.5 1.179E-15 0.05
71 4.5 1.801E-16 0.05
72 4.5 2.663E-17 0.05
73 4.5 3.814E-18 0.05
 A B C D E F G
1 Case: Winter Park Hotel (ATM)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and
and m must
must be
be RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time such as 10
5 minutes per customer, convert it to a service rate such as 6 per hour.
hour.
6 2. The total service rate (rate x servers) must be greater than the
the arrival
arrival rate.
rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 18 Average server utilization (r) 0.9000
10 Service rate (m) 20 Average number of customers in the queue (Lq) 8.1000
11 Number of servers (s) 1 Average number of customers in the system (L) 9.0000
12 Average waiting time in the queue (Wq) 0.4500
13 Average time in the system (W) 0.5000
14 Probability (% of time) system is empty (P0) 0.1000
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.1000 0.1000
21 1 0.0900 0.1900
22 2 0.0810 0.2710
23 3 0.0729 0.3439
24 4 0.0656 0.4095
25 5 0.0590 0.4686
26 6 0.0531 0.5217
27 7 0.0478 0.5695
28 8 0.0430 0.6126
29 9 0.0387 0.6513
30 10 0.0349 0.6862
31 11 0.0314 0.7176
32 12 0.0282 0.7458
33 13 0.0254 0.7712
 A B C D E F G
34 14 0.0229 0.7941
35 15 0.0206 0.8147
36 16 0.0185 0.8332
37 17 0.0167 0.8499
38 18 0.0150 0.8649
39 19 0.0135 0.8784
40 20 0.0122 0.8906
41 Computations
42 n or s (lam/mu)^n/nCumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 0.9 1 9 0.1 0.9 8.1
45 2 0.405 1.9 0.736363636363636 0.37931 0.45 0.228527
46 3 0.1215 2.305 0.173571428571429 0.40346 0.3 0.030012
47 4 0.0273375 2.4265 0.035274193548387 0.40621 0.225 0.00416
48 5 0.0049208 2.4538375 0.006000914634146 0.40653 0.18 0.000536
49 6 0.0007381 2.45875825 0.000868367647059 0.40657 0.15 6.23E-05
50 7 9.49E-05 2.45949636 0.000108901844262 0.40657 0.128571 6.533E-06
51 8 1.0676E-05 2.45959126 1.20296001006036E-05 0.40657 0.1125 6.2E-07
52 9 1.0676E-06 2.45960194 1.18625223214286E-06 0.40657 0.1 5.359E-08
53 10 9.6086E-08 2.45960301 1.05589484399529E-07 0.40657 0.09 4.246E-09
54 11 7.8616E-09 2.4596031 8.56215720031825E-09 0.40657 0.081818 3.102E-10
55 12 5.8962E-10 2.45960311 6.37428410736223E-10 0.40657 0.075 2.101E-11
56 13 4.082E-11 2.45960311 4.38561282593311E-11 0.40657 0.069231 1.326E-12
57 14 2.6241E-12 2.45960311 2.80442299908465E-12 0.40657 0.064286 7.833E-14
58 15 1.5745E-13 2.45960311 1.67498212559311E-13 0.40657 0.06 4.347E-15
59 16 8.8565E-15 2.45960311 9.38433694206471E-15 0.40657 0.05625 2.274E-16
60 17 4.6887E-16 2.45960311 4.95082061501007E-16 0.40657 0.052941 1.125E-17
61 18 2.3444E-17 2.45960311 2.46774649850347E-17 0.40657 0.05 5.281E-19
62 19 1.1105E-18 2.45960311 1.1657034564754E-18 0.40657 0.047368 2.357E-20
63 20 4.9972E-20 2.45960311 5.23265618792621E-20 0.40657 0.045 1E-21
64 21 2.1417E-21 2.45960311 2.23754626543412E-21 0.40657 0.042857 4.073E-23
65 22 8.7613E-23 2.45960311 9.13500608027606E-23 0.40657 0.040909 1.584E-24
66 23 3.4283E-24 2.45960311 3.56795074998853E-24 0.40657 0.03913 5.908E-26
67 24 1.2856E-25 2.45960311 1.33571504643839E-25 0.40657 0.0375 2.116E-27
68 25 4.6283E-27 2.45960311 4.80109194596373E-27 0.40657 0.036 7.29E-29
 A B C D E F G
69 26 1.6021E-28 2.45960311 1.65953281765663E-28 0.40657 0.034615 2.419E-30
70 27 5.3403E-30 2.45960311 5.52443948583306E-30 0.40657 0.033333 7.745E-32
71 28 1.7165E-31 2.45960311 1.77352854342242E-31 0.40657 0.032143 2.395E-33
72 29 5.3271E-33 2.45960311 5.4977581563387E-33 0.40657 0.031034 7.159E-35
73 30 1.5981E-34 2.45960311 1.64756847699734E-34 0.40657 0.03 2.072E-36
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 9 0.45 0.5
45 1.128527 0.012696 0.062696
46 0.930012 0.001667 0.051667
47 0.90416 0.000231 0.050231
48 0.900536 2.975E-05 0.05003
49 0.900062 3.461E-06 0.050003
50 0.900007 3.629E-07 0.05
51 0.900001 3.444E-08 0.05
52 0.9 2.977E-09 0.05
53 0.9 2.359E-10 0.05
54 0.9 1.723E-11 0.05
55 0.9 1.167E-12 0.05
56 0.9 7.368E-14 0.05
57 0.9 4.352E-15 0.05
58 0.9 2.415E-16 0.05
59 0.9 1.263E-17 0.05
60 0.9 6.251E-19 0.05
61 0.9 2.934E-20 0.05
62 0.9 1.309E-21 0.05
63 0.9 5.569E-23 0.05
64 0.9 2.263E-24 0.05
65 0.9 8.801E-26 0.05
66 0.9 3.282E-27 0.05
67 0.9 1.175E-28 0.05
68 0.9 4.05E-30 0.05
 H I J
69 0.9 1.344E-31 0.05
70 0.9 4.303E-33 0.05
71 0.9 1.33E-34 0.05
72 0.9 3.977E-36 0.05
73 0.9 1.151E-37 0.05
 A B C D E F G
1 Case: Winter Park Hotel (Remaining with 4 Servers)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and m must bebe RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time
time such
such as
as 10
10
5 minutes per customer, convert it to a service rate such as 6 per hour.
6 2. The total service rate (rate x servers) must be greater than the arrival rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 72 Average server utilization (r) 0.9000
10 Service rate (m) 20 Average number of customers in the queue (Lq) 7.0898
11 Number of servers (s) 4 Average number of customers in the system (L) 10.6898
12 Average waiting time in the queue (Wq) 0.0985
13 Average time in the system (W) 0.1485
14 Probability (% of time) system is empty (P0) 0.0113
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.0113 0.0113
21 1 0.0405 0.0518
22 2 0.0729 0.1247
23 3 0.0875 0.2122
24 4 0.0788 0.2910
25 5 0.0709 0.3619
26 6 0.0638 0.4257
27 7 0.0574 0.4832
28 8 0.0517 0.5348
29 9 0.0465 0.5814
30 10 0.0419 0.6232
31 11 0.0377 0.6609
32 12 0.0339 0.6948
33 13 0.0305 0.7253
 A B C D E F G
34 14 0.0275 0.7528
35 15 0.0247 0.7775
36 16 0.0222 0.7998
37 17 0.0200 0.8198
38 18 0.0180 0.8378
39 19 0.0162 0.8540
40 20 0.0146 0.8686
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 3.6 1 -1.38461538461538 -2.6 3.6 -4.984615
45 2 6.48 4.6 -8.1 -0.28571 1.8 -5.207143
46 3 7.776 11.08 -38.88 -0.03597 1.2 -8.391367
47 4 6.9984 18.856 69.984 0.01126 0.9 7.089779
48 5 5.038848 25.8544 17.9958857142857 0.0228 0.72 1.055298
49 6 3.0233088 30.893248 7.558272 0.02601 0.6 0.294849
50 7 1.5548445 33.9165568 3.20115049411765 0.02694 0.514286 0.091316
51 8 0.69968 35.4714013 1.27214552103896 0.02722 0.45 0.028327
52 9 0.279872 36.1710814 0.466453357714286 0.02729 0.4 0.008488
53 10 0.1007539 36.4509534 0.157428008228571 0.02732 0.36 0.002419
54 11 0.032974 36.5517073 0.049015423102517 0.02732 0.327273 0.000651
55 12 0.0098922 36.5846813 0.014131719387999 0.02732 0.3 0.000165
56 13 0.0027394 36.5945735 0.003788503495506 0.02732 0.276923 3.964E-05
57 14 0.0007044 36.5973129 0.000948246732899 0.02732 0.257143 8.969E-06
58 15 0.0001691 36.5980173 0.000222445850124 0.02732 0.24 1.919E-06
59 16 3.804E-05 36.5981864 4.90816004788927E-05 0.02732 0.225 3.893E-07
60 17 8.055E-06 36.5982244 1.02192287564262E-05 0.02732 0.211765 7.502E-08
61 18 1.611E-06 36.5982325 2.01378919611928E-06 0.02732 0.2 1.376E-08
62 19 3.052E-07 36.5982341 3.76604732780748E-07 0.02732 0.189474 2.406E-09
63 20 5.494E-08 36.5982344 6.70056687591933E-08 0.02732 0.18 4.019E-10
64 21 9.419E-09 36.5982344 1.13678582860425E-08 0.02732 0.171429 6.426E-11
65 22 1.541E-09 36.5982344 1.84286398301682E-09 0.02732 0.163636 9.852E-12
66 23 2.412E-10 36.5982344 2.86015253596612E-10 0.02732 0.156522 1.45E-12
67 24 3.619E-11 36.5982344 4.25731144739715E-11 0.02732 0.15 2.053E-13
68 25 5.211E-12 36.5982344 6.0875574902034E-12 0.02732 0.144 2.798E-14
 A B C D E F G
69 26 7.215E-13 36.5982344 8.37473980437982E-13 0.02732 0.138462 3.678E-15
70 27 9.62E-14 36.5982344 1.11002468413082E-13 0.02732 0.133333 4.666E-16
71 28 1.237E-14 36.5982344 1.4193758256099E-14 0.02732 0.128571 5.722E-17
72 29 1.535E-15 36.5982344 1.75306485547769E-15 0.02732 0.124138 6.789E-18
73 30 1.843E-16 36.5982344 2.0937859245674E-16 0.02732 0.12 7.801E-19
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 -1.384615 -0.069231 -0.019231
45 -1.607143 -0.072321 -0.022321
46 -4.791367 -0.116547 -0.066547
47 10.68978 0.098469 0.148469
48 4.655298 0.014657 0.064657
49 3.894849 0.004095 0.054095
50 3.691316 0.001268 0.051268
51 3.628327 0.000393 0.050393
52 3.608488 0.000118 0.050118
53 3.602419 3.36E-05 0.050034
54 3.600651 9.049E-06 0.050009
55 3.600165 2.298E-06 0.050002
56 3.60004 5.506E-07 0.050001
57 3.600009 1.246E-07 0.05
58 3.600002 2.666E-08 0.05
59 3.6 5.408E-09 0.05
60 3.6 1.042E-09 0.05
61 3.6 1.911E-10 0.05
62 3.6 3.341E-11 0.05
63 3.6 5.582E-12 0.05
64 3.6 8.926E-13 0.05
65 3.6 1.368E-13 0.05
66 3.6 2.014E-14 0.05
67 3.6 2.851E-15 0.05
68 3.6 3.886E-16 0.05
 H I J
69 3.6 5.108E-17 0.05
70 3.6 6.481E-18 0.05
71 3.6 7.947E-19 0.05
72 3.6 9.429E-20 0.05
73 3.6 1.084E-20 0.05
 A B C D E F G
1 Case: Winter Park Hotel (Remaining with 5 Servers)
2 Queuing Model M/M/s (Exponential Service Times)
3
4 1. Both l and m must bebe RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. For
For example,
example, given
given aa service
service time
time such
such as
as 10
10
5 minutes per customer, convert it to a service rate such as 6 per hour.
6 2. The total service rate (rate x servers) must be greater than the arrival rate.
7
8 Input Data Operating Characteristics
9 Arrival rate (l) 72 Average server utilization (r) 0.7200
10 Service rate (m) 20 Average number of customers in the queue (Lq) 1.0553
11 Number of servers (s) 5 Average number of customers in the system (L) 4.6553
12 Average waiting time in the queue (Wq) 0.0147
13 Average time in the system (W) 0.0647
14 Probability (% of time) system is empty (P0) 0.0228
15
16
17
18 Probabilities
Cumulative
19
Number of Units Probability Probability
20 0 0.0228 0.0228
21 1 0.0821 0.1049
22 2 0.1478 0.2527
23 3 0.1773 0.4300
24 4 0.1596 0.5896
25 5 0.1149 0.7045
26 6 0.0827 0.7873
27 7 0.0596 0.8468
28 8 0.0429 0.8897
29 9 0.0309 0.9206
30 10 0.0222 0.9428
31 11 0.0160 0.9588
32 12 0.0115 0.9704
33 13 0.0083 0.9787
 A B C D E F G
34 14 0.0060 0.9846
35 15 0.0043 0.9889
36 16 0.0031 0.9920
37 17 0.0022 0.9943
38 18 0.0016 0.9959
39 19 0.0012 0.9970
40 20 0.0008 0.9979
41 Computations
42 n or s (lam/mu)^n/ Cumsum(n-1 term2 P0(s) Rho(s) Lq(s)
43 0 1
44 1 3.6 1 -1.38461538461538 -2.6 3.6 -4.984615
45 2 6.48 4.6 -8.1 -0.28571 1.8 -5.207143
46 3 7.776 11.08 -38.88 -0.03597 1.2 -8.391367
47 4 6.9984 18.856 69.984 0.01126 0.9 7.089779
48 5 5.038848 25.8544 17.9958857142857 0.0228 0.72 1.055298
49 6 3.0233088 30.893248 7.558272 0.02601 0.6 0.294849
50 7 1.5548445 33.9165568 3.20115049411765 0.02694 0.514286 0.091316
51 8 0.69968 35.4714013 1.27214552103896 0.02722 0.45 0.028327
52 9 0.279872 36.1710814 0.466453357714286 0.02729 0.4 0.008488
53 10 0.1007539 36.4509534 0.157428008228571 0.02732 0.36 0.002419
54 11 0.032974 36.5517073 0.049015423102517 0.02732 0.327273 0.000651
55 12 0.0098922 36.5846813 0.014131719387999 0.02732 0.3 0.000165
56 13 0.0027394 36.5945735 0.003788503495506 0.02732 0.276923 3.964E-05
57 14 0.0007044 36.5973129 0.000948246732899 0.02732 0.257143 8.969E-06
58 15 0.0001691 36.5980173 0.000222445850124 0.02732 0.24 1.919E-06
59 16 3.804E-05 36.5981864 4.90816004788927E-05 0.02732 0.225 3.893E-07
60 17 8.055E-06 36.5982244 1.02192287564262E-05 0.02732 0.211765 7.502E-08
61 18 1.611E-06 36.5982325 2.01378919611928E-06 0.02732 0.2 1.376E-08
62 19 3.052E-07 36.5982341 3.76604732780748E-07 0.02732 0.189474 2.406E-09
63 20 5.494E-08 36.5982344 6.70056687591933E-08 0.02732 0.18 4.019E-10
64 21 9.419E-09 36.5982344 1.13678582860425E-08 0.02732 0.171429 6.426E-11
65 22 1.541E-09 36.5982344 1.84286398301682E-09 0.02732 0.163636 9.852E-12
66 23 2.412E-10 36.5982344 2.86015253596612E-10 0.02732 0.156522 1.45E-12
67 24 3.619E-11 36.5982344 4.25731144739715E-11 0.02732 0.15 2.053E-13
68 25 5.211E-12 36.5982344 6.0875574902034E-12 0.02732 0.144 2.798E-14
 A B C D E F G
69 26 7.215E-13 36.5982344 8.37473980437982E-13 0.02732 0.138462 3.678E-15
70 27 9.62E-14 36.5982344 1.11002468413082E-13 0.02732 0.133333 4.666E-16
71 28 1.237E-14 36.5982344 1.4193758256099E-14 0.02732 0.128571 5.722E-17
72 29 1.535E-15 36.5982344 1.75306485547769E-15 0.02732 0.124138 6.789E-18
73 30 1.843E-16 36.5982344 2.0937859245674E-16 0.02732 0.12 7.801E-19
 H I J
34
35
36
37
38
39
40
41
42 L(s) Wq(s) W(S)
43
44 -1.384615 -0.069231 -0.019231
45 -1.607143 -0.072321 -0.022321
46 -4.791367 -0.116547 -0.066547
47 10.68978 0.098469 0.148469
48 4.655298 0.014657 0.064657
49 3.894849 0.004095 0.054095
50 3.691316 0.001268 0.051268
51 3.628327 0.000393 0.050393
52 3.608488 0.000118 0.050118
53 3.602419 3.36E-05 0.050034
54 3.600651 9.049E-06 0.050009
55 3.600165 2.298E-06 0.050002
56 3.60004 5.506E-07 0.050001
57 3.600009 1.246E-07 0.05
58 3.600002 2.666E-08 0.05
59 3.6 5.408E-09 0.05
60 3.6 1.042E-09 0.05
61 3.6 1.911E-10 0.05
62 3.6 3.341E-11 0.05
63 3.6 5.582E-12 0.05
64 3.6 8.926E-13 0.05
65 3.6 1.368E-13 0.05
66 3.6 2.014E-14 0.05
67 3.6 2.851E-15 0.05
68 3.6 3.886E-16 0.05
 H I J
69 3.6 5.108E-17 0.05
70 3.6 6.481E-18 0.05
71 3.6 7.947E-19 0.05
72 3.6 9.429E-20 0.05
73 3.6 1.084E-20 0.05