Simulation on Excel

l3o0hd_s
Basicsimulation.xlsx
Home>Business & Finance homework help>Operations Management homework help>Simulation on Excel

Sheet1

Int arr time Prob lower upper Proc Time prob lower upper
10 0.2 1 20 5 0.4 1 40
20 0.4 21 60 10 0.3 41 70
30 0.4 61 100 20 0.3 71 100
1
customer RN int arr time Arrives Rn Proc time Serv beg Serv ends wait idle
1 51 20 20 32 5 20 25 0
2 67 30 50 96 20 50 70 0 25
3 68 30 80 100 20 80 100 0 10
4 88 30 110 49 10 110 120 0 10
5 60 20 130 20 5 130 135 0 10
6 19 10 140 80 20 140 160 0 5
7 82 30 170 60 10 170 180 0 10
8 94 30 200 83 20 200 220 0 20
9 14 10 210 72 20 220 240 10 0
10 31 20 230 2 5 240 245 10 0
avg 2 10

Sheet2

Sheet3