EXCEL ASSIGNMENTS, SUPPLY CHAIN MANAGEMENT

profilesward44
Queue_template3.xlsm
Home>Business & Finance homework help>Management homework help>EXCEL ASSIGNMENTS, SUPPLY CHAIN MANAGEMENT

Intro

This worksheet computes queuing results for the following model:
M / M / s
Click on the worksheet tab to access the template
Enter the required parameters in the boxes

QUEUING TEMPLATES © 1997 by David W. Ashley

MMs

M/M/s queuing computations lambda/mu 0.9166666666666666 s-1 0.0 THE ARRIVAL RATE SHOULD BE LESS THAN THE OVERALL SERVICE RATE!
Arrival rate 5.5 Assumes Poisson process for /s 0.9166666666666666
Service rate 6.0 arrivals and services. 10.999999999999995 s factorial = 1
Number of servers 1.0 (max of 40)
P(0) = 0.08333333333333337 0.9166666666666666 1.0
Utilization 91.67% P(n) 1.0 1.0
P(0), probability that the system is empty 0.0833 0.0 1.0 0.08333333333333337 0.08333333333333337 1.0 1.0
Nq, expected queue length 10.0833 1.0 0.0 0.07638888888888892 0.0 1.0 1.0
N, expected number in system 11.0000 2.0 0.0 0.07002314814814818 0.0 1.0 1.0
Lq, expected time in queue 1.8333 3.0 0.0 0.06418788580246916 0.0 1.0 1.0
L, expected total time in system 2.0000 4.0 0.0 0.05883889531893006 0.0 1.0 1.0
Probability that a customer waits 0.9167 5.0 0.0 0.05393565404235255 0.0 1.0 1.0
6.0 0.0 0.04944101620548984 0.0 1.0 1.0
7.0 0.0 0.04532093152169902 0.0 1.0 1.0
8.0 0.0 0.0415441872282241 0.0 1.0 1.0
9.0 0.0 0.038082171625872095 0.0 1.0 1.0
10.0 0.0 0.034908657323716084 0.0 1.0 1.0
11.0 0.0 0.031999602546739746 0.0 1.0 1.0
12.0 0.0 0.0293329690011781 0.0 1.0 1.0
13.0 0.0 0.02688855491774659 0.0 1.0 1.0
14.0 0.0 0.02464784200793437 0.0 1.0 1.0
15.0 0.0 0.02259385517393984 0.0 1.0 1.0
16.0 0.0 0.020711033909444853 0.0 1.0 1.0
17.0 0.0 0.018985114416991116 0.0 1.0 1.0
18.0 0.0 0.017403021548908524 0.0 1.0 1.0
19.0 0.0 0.015952769753166146 0.0 1.0 1.0
20.0 0.0 0.014623372273735634 0.0 1.0 1.0
21.0 0.013404757917590998 0.0 1.0 1.0
22.0 0.012287694757791748 0.0 1.0 1.0
23.0 0.011263720194642435 0.0 1.0 1.0
24.0 0.010325076845088899 0.0 1.0 1.0
25.0 0.009464653774664824 0.0 1.0 1.0
26.0 0.008675932626776088 0.0 1.0 1.0
27.0 0.007952938241211413 0.0 1.0 1.0
28.0 0.0072901933877771285 0.0 1.0 1.0
29.0 0.006682677272129034 0.0 1.0 1.0
30.0 0.006125787499451614 0.0 1.0 1.0
31.0 0.005615305207830646 0.0 1.0 1.0
32.0 0.005147363107178092 0.0 1.0 1.0
33.0 0.004718416181579917 0.0 1.0 1.0
34.0 0.004325214833114924 0.0 1.0 1.0
35.0 0.0039647802636886805 0.0 1.0 1.0
36.0 0.0036343819083812902 0.0 1.0 1.0
37.0 0.003331516749349516 0.0 1.0 1.0
38.0 0.0030538903535703896 0.0 1.0 1.0
39.0 0.002799399490772857 0.0 1.0 1.0
40.0 0.002566116199875119 0.0 1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
1.0 1.0
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 8.333333333333337E-2 7.6388888888888923E-2 7.0023148148148182E-2 6.4187885802469161E-2 5.8838895318930058E-2 5.3935654042352552E-2 4.9441016205489838E-2 4.5320931521699019E-2 4.1544187228224103E-2 3.8082171625872095E-2 3.4908657323716084E-2 3.1999602546739746E-2 2.93329690011781E-2 2.6888554917746589E-2 2.4647842007934372E-2 2.2593855173939841E-2 2.0711033909444853E-2 1.8985114416991116E-2 1.7403021548908524E-2 1.5952769753166146E-2 1.4623372273735634E-2 1.3404757917590998E-2 1.2287694757791748E-2 1.1263720194642435E-2 1.0325076845088899E-2 9.4646537746648236E-3 8.6759326267760884E-3 7.9529382412114134E-3 7.2901933877771285E-3 6.6826772721290343E-3 6.1257874994516143E-3 5.615305207830646E-3 5.1473631071780922E-3 4.7184161815799174E-3 4.3252148331149242E-3 3.9647802636886805E-3 3.6343819083812902E-3 3.3315167493495161E-3 3.0538903535703896E-3 2.799399490772857E-3 2.5661161998751189E-3

NUMBER IN SYSTEM

Probability