Process Analysis: Case

casenumbers.xlsx

Electronics City

			DEMAND
					xmas cust
3000					12000	25%	3000	f,s,s	number of customers Thanksgiving weekend
				9000
42					14	3	42	hours	total hours opened
				30
65.2173913043	38	2478.2608695652					71.4285714286	f,s,s	customers/hr.
130.4347826087	4	521.7391304348					142.8571428571	fri am	customers per hours from 8am to noon
		3000
			Capacity
				#		probability		items/cust
				1		0.3		0.3
				2		0.2		0.4
63.829787234	37	2361.7021276596		3		0.25		0.75
127.6595744681	5	638.2978723404		4		0.2		0.8
		3000		5		0.05		0.25
						1		2.5	avg items/cust
								0.2	time/cust
			30					0.5	avg min to input items/cust
					payment	%	time	min/cust
					cash	0.35	0.6	0.21
					check	0.05	3	0.15
					credit card	0.6	1	0.6
			57.6					0.96	avg min to process payment/cust
			87.6					1.46	min/cust
			Capacity options		cash registers	reg *60 min/hr
					2	120		82.1917808219
					1	60		41.095890411	Current	cust/hr
					3	180		123.2876712329
					4	240		164.3835616438