operations management howework

Sheet1

Template for the M/M/s Queueing Model
		Data					Results		Range Name	Cells
	l =	1	(mean arrival rate)		1	L =	0.3333333333		L	G4
	m =	4	(mean service rate)		0	Lq =	0.0833333333		Lambda	C4
	s =	1	(# servers)		0				Lq	G5
					0	W =	0.33333		Mu	C5
	Pr(W > t) =	0.0497870684			0	Wq =	0.08333		n	F13:F38
	when t =	1			0				P0	G13
					0	r =	0.25		Pn	G13:G38
	Prob(Wq > t) =	0.0124467671			0				Rho	G10
	when t =	1			0	n	Pn		s	C6
					0	0	0.75		Time1	C9
					0	1	0.1875		Time2	C12
					0	2	0.046875		W	G7
					0	3	0.01171875		Wq	G8
					0	4	0.0029296875
					0	5	0.0007324219
					0	6	0.0001831055
					0	7	0.0000457764
					0	8	0.0000114441
					0	9	0.000002861
					0	10	0.0000007153
					0	11	0.0000001788
					0	12	0.0000000447
					0	13	0.0000000112
					0	14	0.0000000028
					0	15	0.0000000007
					0	16	0.0000000002
						17	0
						18	0
						19	0
						20	0
						21	0
						22	0
						23	0
						24	0
						25	6.66133814775094E-16

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 0.75 0.1875 4.6875E-2 1.171875E-2 2.9296875E-3 7.32421875E-4 1.8310546875E-4 4.57763671875E-5 1.1444091796875E-5 2.86102294921875E-6 7.152557373046875E-7 1.7881393432617188E-7 4.4703483581542969E-8 1.1175870895385742E-8 2.7939677238464355E-9 6.9849193096160889E-10 1.7462298274040222E-10 4.3655745685100555E-11 1.0913936421275139E-11 2.7284841053187847E-12 6.8212102632969618E-13 1.7053025658242404E-13 4.2632564145606011E-14 1.0658141036401503E-14 2.6645352591003757E-15 6.6613381477509392E-16

Number of Customers in System

Probability

Sheet2

Template for the M/G/1 Queueing Model
		Data				Results		Range Name	Cell
	l =	0.05	(mean arrival rate)		L =	3		L	G4
	1/m =	15	(expected service time)		Lq =	2.25		Lambda	C4
	s=	15	(standard deviation)					Lq	G5
	s =	1	(# servers)		W =	60		OneOverMu	C5
					Wq =	45		Rho	G10
								s	C7
					r =	0.75		Sigma	C6
								W	G7
					P0 =	0.25		Wq	G8