Simulation Case Study

SimulationCaseStudyPhoenixBoutiqueHotelGroupTemplate.xlsx

Simulation

Arrival Interval Distribution
	Random Number Lower Limit	Range Upper Limit	Arrival Gap Minute
Probability
0.13	0	10	1
0.23	11	31	2
0.27	32	53	3
0.19	54	73	4
0.15	74	89	5
0.09	90	99	6
Service Time Distribution
	Random Number Lower Limit	Range Upper Limit	Service Time (minutes)
Probability
0.19	0	19	1
0.17	20	38	2
0.16	39	56	3
0.15	57	73	4
0.11	74	86	5
0.08	87	96	6
0.03	97	99	7
Customer Number	Random Number	Arrival Gap	Random Number	Service Time	Arrive Time	Service Start	Service End	Time in System	Time on Hold	Time Server Idle	Percent Utilization
				Summary for This Trial Run Average:
				maximums
1	41		40
2	27		36
3	1		93
4	65		42
5	59		66
6	37		73
7	67		12
8	87		10
9	34		4
10	3		87
11	38		96
12	69		77
13	34		95
14	63		59
15	53		66