Supply chain

profileSJBRANA
PracticeExam3_Solution.xlsx
Home>Business & Finance homework help>Operations Management homework help>Supply chain

Problem 1

Activity Immediate Predecessor Activities Optimistic Time Most Likely Time Pessimistic Time A) Expected Time A) Variance
A -- 4 5 6 5 0.1111111111
B -- 4 4.5 8 5 0.4444444444
C B 3 5 7 5 0.4444444444
D A, C 3 4 8 4.5 0.6944444444
E B,C 5 5 14 6.5 2.25
F B,D 5 6 7 6 0.1111111111
G E 4.5 6.5 8.5 6.5 0.4444444444
H D,G 5 6 13 7 1.7777777778
I D, G 3 5 8.5 5.25 0.8402777778
J H 2 5 8 5 1
H 23.00 30.00 J 30.00 35.00
D 10.00 14.50 7.00 23.00 30.00 5.00 30.00 35.00
B) 4.50 18.50 23.00
A 0.00 5.00
START 5.00 13.50 18.50 I 23.00 28.25
F 14.50 20.50 5.25 29.75 35.00
6.00 29.00 35.00
B 0.00 5.00 C 5.00 10.00
5.00 0.00 5.00 5.00 5.00 10.00
E 10.00 16.50 G 16.50 23.00
6.50 10.00 16.50 6.50 16.50 23.00
C) D)

Problem 2

Selling Price $2,000 Trial Software Engineer(Variable cost) Production Cost (Variable cost) Random Number First-Year Demand Profit Function
Administrative Cost(Fixed cost) $500,000 1 $46 $117 0.84748 1200 $1,004,680.26
Advertising Cost(Fixed cost) $700,000 2 $56 $167 0.71982 800 $221,974.53
3 $37 $143 0.56234 800 $255,408.91
4 $45 $117 0.04335 500 -$280,936.68
Software Engineer: (Normal Distribution) 5 $39 $112 0.94750 1250 $1,111,345.40
Mean $45.00 6 $53 $126 0.10262 600 -$107,667.74
Standard Deviation $5.20 7 $49 $93 0.52912 800 $286,579.79
8 $43 $88 0.02185 500 -$265,725.82
11 $49 $142 0.16025 600 -$114,400.77
Production Cost: (Uniform Distribution) 12 $36 $93 0.98087 1250 $1,138,160.88
Smallest Value $80.00 13 $44 $121 0.83173 1200 $1,001,869.20
Largest Value $167.00 14 $50 $110 0.57431 800 $271,559.05
15 $46 $103 0.89738 1200 $1,021,275.95
19 $39 $128 0.03032 500 -$283,405.61
Demand: Discrete Distribution 20 $47 $125 0.50561 800 $263,007.89
Probability Cumulative Direct Labor Cost per Unit 21 $59 $164 0.47208 800 $221,309.17
0.1 0 500 22 $50 $138 0.78535 800 $249,288.73
0.2 0.1 600 23 $43 $147 0.93639 1250 $1,062,991.50
0.5 0.3 800 24 $48 $119 0.99811 1250 $1,090,555.96
0.1 0.8 1200 25 $45 $160 0.68698 800 $236,043.61
0.1 0.9 1250 26 $32 $110 0.95666 1250 $1,122,388.78
27 $47 $110 0.14826 600 -$93,637.13
28 $43 $101 0.32095 800 $284,662.53
29 $37 $133 0.79828 800 $263,684.84
30 $42 $114 0.54963 800 $275,163.65
31 $44 $166 0.72315 800 $232,459.71
32 $48 $110 0.42423 800 $273,562.11
33 $47 $157 0.46875 800 $236,511.10
34 $49 $85 0.96868 1250 $1,132,415.55
35 $50 $151 0.41618 800 $239,257.09
36 $52 $157 0.05565 500 -$304,414.31
37 $39 $96 0.17100 600 -$80,557.58
38 $36 $101 0.19053 600 -$82,055.81
39 $38 $115 0.86775 1200 $1,016,128.10
40 $40 $110 0.20070 600 -$89,948.69
41 $43 $85 0.34112 800 $297,198.46
42 $48 $115 0.97780 1250 $1,095,359.28
43 $41 $112 0.05080 500 -$276,465.49
44 $41 $132 0.65416 800 $261,550.46
45 $38 $99 0.42425 800 $289,968.89
46 $50 $141 0.46353 800 $247,325.69
47 $40 $98 0.06316 500 -$269,054.60
48 $46 $118 0.89002 1200 $1,003,361.11
49 $54 $96 0.66853 800 $279,739.06
50 $46 $108 0.41619 800 $277,196.53
51 $40 $149 0.98539 1250 $1,064,553.42
52 $44 $166 0.56720 800 $231,640.73
53 $44 $133 0.93608 1250 $1,078,756.03
54 $47 $159 0.63497 800 $235,021.16
55 $51 $150 0.30464 800 $239,688.82
56 $34 $164 0.40695 800 $241,058.68
57 $36 $105 0.38273 800 $287,402.52
58 $41 $130 0.06818 500 -$285,520.57
59 $42 $131 0.68277 800 $261,324.80
60 $43 $161 0.64510 800 $237,284.02
61 $44 $134 0.12214 600 -$106,923.56
62 $42 $143 0.76096 800 $251,884.81
63 $43 $104 0.47720 800 $281,921.34
64 $43 $127 0.62122 800 $264,161.83
65 $41 $96 0.74218 800 $290,811.37
66 $43 $104 0.89367 1200 $1,023,852.36
67 $46 $84 0.25942 600 -$78,171.82
68 $47 $95 0.18980 600 -$85,365.58
69 $46 $145 0.30674 800 $247,269.53
70 $48 $114 0.96339 1250 $1,097,117.87
71 $48 $94 0.16726 600 -$84,976.54
72 $44 $131 0.95138 1250 $1,080,756.70
73 $46 $110 0.99188 1250 $1,104,976.29
74 $52 $139 0.67167 800 $247,244.25
75 $41 $120 0.73752 800 $271,242.34
76 $47 $136 0.18086 600 -$109,629.80
77 $48 $127 0.36476 800 $259,955.20
78 $48 $152 0.27007 600 -$120,217.61
79 $48 $159 0.23499 600 -$124,190.91
80 $41 $81 0.43343 800 $303,036.97
81 $51 $111 0.06758 500 -$280,661.98
82 $42 $159 0.86071 1200 $958,399.28
83 $51 $132 0.83122 1200 $980,509.87
84 $41 $151 0.92116 1250 $1,059,489.75
85 $51 $152 0.97571 1250 $1,047,178.28
86 $49 $97 0.37508 800 $283,306.45
87 $42 $149 0.15193 600 -$114,682.75
88 $46 $160 0.88888 1200 $952,770.30
89 $39 $118 0.42066 800 $274,123.96
90 $34 $142 0.58621 800 $258,891.01
91 $50 $165 0.84854 1200 $941,525.77
92 $44 $114 0.37101 800 $273,109.57
93 $49 $123 0.35208 800 $261,940.77
94 $46 $155 0.52475 800 $239,001.24
95 $45 $97 0.09854 500 -$270,925.41
96 $42 $129 0.57934 800 $262,627.60
97 $43 $108 0.67952 800 $279,030.05
98 $43 $88 0.69929 800 $295,627.00
99 $47 $167 0.07057 500 -$306,979.87
100 $37 $164 0.42154 800 $239,099.77
101 $47 $81 0.17786 600 -$76,650.84
102 $39 $97 0.43971 800 $291,505.75
103 $40 $162 0.26808 600 -$121,233.16
104 $48 $149 0.04629 500 -$298,745.27
105 $44 $137 0.07434 500 -$290,798.68
106 $50 $100 0.03267 500 -$275,157.31
107 $33 $125 0.69928 800 $273,646.46
108 $43 $86 0.39781 800 $297,140.13
109 $45 $131 0.00653 500 -$287,929.93
110 $38 $93 0.31233 800 $294,888.43
111 $44 $140 0.00260 500 -$292,153.45
112 $41 $132 0.22834 600 -$103,905.11
113 $45 $115 0.00433 500 -$280,067.13
114 $46 $147 0.98070 1250 $1,058,026.84
115 $49 $144 0.55225 800 $245,548.23
116 $34 $100 0.20697 600 -$80,515.87
117 $45 $95 0.42223 800 $287,948.13
118 $44 $146 0.01930 500 -$294,613.77
119 $48 $83 0.65647 800 $295,728.26
120 $49 $156 0.31276 800 $235,366.38
121 $44 $151 0.16662 600 -$117,204.56
122 $41 $111 0.68263 800 $278,366.67
123 $39 $133 0.98306 1250 $1,085,087.29
124 $52 $143 0.18773 600 -$116,761.86
125 $44 $156 0.75764 800 $239,940.11
126 $46 $116 0.08496 500 -$281,210.12
127 $46 $99 0.70695 800 $284,194.64
128 $43 $132 0.91034 1250 $1,082,088.91
129 $45 $145 0.62849 800 $248,019.64
130 $44 $162 0.71540 800 $234,567.52
131 $47 $119 0.58497 800 $267,407.65
132 $51 $109 0.07333 500 -$280,237.03
133 $50 $90 0.07450 500 -$270,026.79
134 $51 $140 0.02351 500 -$295,494.44
135 $39 $82 0.82848 1200 $1,055,148.55
136 $53 $160 0.65096 800 $229,252.12
137 $51 $102 0.85133 1200 $1,016,375.98
138 $37 $113 0.37504 800 $280,289.87
139 $46 $101 0.77945 800 $281,925.67
140 $44 $138 0.78652 800 $254,743.13
141 $35 $87 0.41578 800 $302,005.36
142 $44 $122 0.40342 800 $266,890.79
143 $48 $82 0.25470 600 -$77,814.90
144 $43 $149 0.02000 500 -$296,027.37
145 $45 $133 0.78322 800 $257,145.41
146 $45 $142 0.70158 800 $250,261.55
147 $54 $87 0.85581 1200 $1,030,228.35
148 $38 $105 0.73698 800 $285,583.35
149 $50 $146 0.12513 600 -$117,682.22
150 $41 $129 0.57325 800 $263,725.80
151 $45 $128 0.33258 800 $261,727.05
152 $48 $134 0.47371 800 $254,115.39
153 $42 $153 0.59519 800 $243,710.30
154 $48 $99 0.69657 800 $282,279.57
155 $47 $122 0.74991 800 $264,873.42
156 $36 $85 0.60524 800 $303,121.67
157 $44 $142 0.06153 500 -$293,295.67
158 $44 $159 0.50252 800 $237,604.85
159 $37 $102 0.87394 1200 $1,034,051.42
160 $43 $86 0.08672 500 -$264,738.83
161 $48 $136 0.58923 800 $252,760.42
162 $54 $158 0.64019 800 $230,754.99
163 $40 $162 0.73475 800 $238,355.90
164 $47 $142 0.37693 800 $248,355.38
165 $42 $144 0.95633 1250 $1,067,628.77
166 $44 $122 0.28585 600 -$99,171.40
167 $46 $140 0.80832 1200 $977,253.84
168 $48 $142 0.70284 800 $248,056.63
169 $46 $140 0.96737 1250 $1,067,856.31
170 $43 $109 0.83404 1200 $1,016,878.88
171 $44 $128 0.64514 800 $262,552.16
172 $44 $127 0.78435 800 $263,636.12
173 $53 $131 0.96305 1250 $1,070,433.38
174 $46 $116 0.26201 600 -$97,058.32
175 $43 $143 0.88608 1200 $977,064.00
176 $51 $152 0.01915 500 -$301,372.78
177 $42 $142 0.56598 800 $252,172.04
178 $49 $97 0.95988 1250 $1,117,456.89
179 $56 $145 0.81956 1200 $959,590.42
180 $43 $148 0.34251 800 $246,927.98
181 $47 $115 0.71466 800 $270,159.71
182 $47 $124 0.25868 600 -$102,463.77
183 $47 $103 0.34758 800 $280,051.24
184 $42 $107 0.09888 500 -$274,557.36
185 $41 $111 0.33880 800 $278,400.29
186 $54 $91 0.74778 800 $283,814.26
187 $41 $152 0.79772 800 $245,338.17
188 $34 $166 0.19699 600 -$120,355.36
189 $44 $159 0.18426 600 -$121,397.94
190 $45 $133 0.46860 800 $257,408.68
191 $50 $111 0.79094 800 $271,011.24
192 $40 $117 0.70144 800 $274,324.98
193 $37 $136 0.59209 800 $261,995.15
194 $48 $138 0.68015 800 $250,641.25
195 $46 $82 0.81577 1200 $1,046,583.03
196 $47 $136 0.73543 800 $253,929.50
197 $48 $109 0.65025 800 $274,638.49
198 $44 $102 0.56272 800 $282,537.88
199 $41 $114 0.92074 1250 $1,106,546.87
200 $42 $156 0.26850 600 -$119,310.47
201 $45 $129 0.31389 800 $260,288.78
202 $47 $138 0.01901 500 -$292,925.34
203 $47 $95 0.98769 1250 $1,123,143.31
204 $45 $95 0.06782 500 -$269,749.50
205 $47 $154 0.26278 600 -$121,003.44
206 $39 $142 0.11990 600 -$108,634.57
207 $37 $109 0.49058 800 $283,760.87
208 $42 $164 0.09131 500 -$303,130.37
209 $43 $90 0.12490 600 -$80,148.82
210 $56 $167 0.87854 1200 $932,956.02
211 $51 $155 0.04885 500 -$302,813.98
212 $43 $90 0.93918 1250 $1,133,459.50
213 $37 $121 0.32986 800 $273,327.27
214 $50 $123 0.13941 600 -$103,443.12
215 $40 $110 0.04841 500 -$274,906.83
216 $41 $89 0.58198 800 $296,427.25
217 $48 $80 0.10263 600 -$76,641.47
218 $48 $147 0.29900 600 -$117,006.86
219 $42 $140 0.62665 800 $254,073.71
220 $41 $156 0.47309 800 $242,641.59
221 $42 $118 0.44442 800 $271,923.39
222 $41 $105 0.65684 800 $283,250.46
223 $40 $118 0.74225 800 $273,392.62
224 $41 $86 0.47827 800 $298,139.42
225 $45 $132 0.41613 800 $258,524.39
226 $48 $104 0.66783 800 $278,455.80
227 $48 $150 0.38677 800 $241,569.05
228 $47 $135 0.55977 800 $254,213.10
229 $48 $130 0.53909 800 $257,067.95
230 $38 $126 0.56226 800 $269,107.13
231 $42 $144 0.12157 600 -$111,403.82
232 $43 $100 0.99292 1250 $1,121,387.76
233 $56 $96 0.31796 800 $278,110.72
234 $38 $127 0.13143 600 -$98,633.52
235 $37 $158 0.72997 800 $243,794.26
236 $41 $162 0.86376 1200 $956,394.38
237 $41 $108 0.25538 600 -$89,379.83
238 $52 $126 0.81922 1200 $985,796.27
239 $47 $124 0.21931 600 -$102,771.47
240 $57 $93 0.94282 1250 $1,112,343.72
241 $51 $162 0.52581 800 $229,654.27
242 $36 $131 0.91787 1250 $1,091,048.47
243 $47 $154 0.82479 1200 $958,754.98
244 $47 $84 0.98322 1250 $1,135,835.52
245 $40 $91 0.74160 800 $295,861.56
246 $48 $166 0.17547 600 -$128,542.00
247 $51 $110 0.21340 600 -$96,592.52
248 $56 $111 0.66329 800 $266,616.34
249 $50 $153 0.24281 600 -$121,746.01
250 $53 $126 0.45291 800 $257,262.83
Summary Statistics
Mean Profit $296,391.27
Standard Deviation 435613.848347377
Maximum Profit $1,138,160.88
Minimum Profit -$306,979.87
Number of Losses 72
Probability of Loss 0.29
Profit Ranges Bin Frequency
-500000 - -200000 -200000 31
-200000 - -100000 -100000 24
-100000 - -50000 -50000 17
-50000 - 0 0 0
0 - 50000 50000 0
50000 - 100000 100000 0
100000 - 200000 200000 0
200000 - 3000000 3000000 173
3000000 - 4000000 4000000 0
4000000 - 5000000 5000000 0
>5000000 0

Frequency -500000 - -200000 -200000 - -100000 -100000 - -50000 -50000 - 0 0 - 50000 50000 - 100000 100000 - 200000 200000 - 3000000 3000000 - 4000000 4000000 - 5000000 > 5000000 31 24 17 0 0 0 0 173 0 0 0

Alternative Formula for First-Year Demand: =IF(H2<$A$18,$C$18,IF(H2<($A$18+$A$19),$C$19,IF(H2<$A$18+$A$19+$A$20,$C$20,IF(H2<$A$18+$A$19+$A$20+$A$21,$C$21,$C$22))))

Problem 3

Interarrival Time: Uniform Distribution Passenger Interarrival Time Arrival Time Random Number Service Time Service Start Time Comepletion Time Time Inspector 1 becomes Available Time Inspector 2 becomes Available Waiting Time Time in System
Smallest Value 0 1 9.2884579439 9.2884579439 0.0059912578 5 9.2884579439 14.2884579439 14.2884579439 0 0 5
Largest Value 10 2 5.341384654 14.6298425979 0.741245474 10 14.6298425979 24.6298425979 14.2884579439 24.6298425979 0 10
3 7.424043104 22.0538857019 0.7104793442 10 22.0538857019 32.0538857019 32.0538857019 24.6298425979 0 10
Service Times: Discrete Distribution 4 6.4427041885 28.4965898904 0.8634428608 10 28.4965898904 38.4965898904 32.0538857019 38.4965898904 0 10
Probability Cumulative Service Times 5 6.7950055058 35.2915953962 0.0963214498 5 35.2915953962 40.2915953962 40.2915953962 38.4965898904 0 5
0.2 0 5 6 4.6940092121 39.9856046083 0.0521851513 5 39.9856046083 44.9856046083 40.2915953962 44.9856046083 0 5
0.4 0.2 8 7 7.9353690047 47.920973613 0.2801694706 8 47.920973613 55.920973613 55.920973613 44.9856046083 0 8
0.3 0.6 10 8 8.8158304645 56.7368040775 0.47114084 8 56.7368040775 64.7368040775 55.920973613 64.7368040775 0 8
0.1 0.9 12 9 2.856140824 59.5929449015 0.975224044 12 59.5929449015 71.5929449015 71.5929449015 64.7368040775 0 12
10 4.2812942436 63.8742391451 0.3173004879 8 64.7368040775 72.7368040775 71.5929449015 72.7368040775 0.8625649324 8.8625649324
11 0.8151323737 64.6893715188 0.3766548999 8 71.5929449015 79.5929449015 79.5929449015 72.7368040775 6.9035733827 14.9035733827
12 1.2089377393 65.8983092581 0.7330442732 10 72.7368040775 82.7368040775 79.5929449015 82.7368040775 6.8384948194 16.8384948194
13 3.7926992141 69.6910084722 0.9086961589 12 79.5929449015 91.5929449015 91.5929449015 82.7368040775 9.9019364293 21.9019364293
14 3.1623259343 72.8533344065 0.1587422809 5 82.7368040775 87.7368040775 91.5929449015 87.7368040775 9.883469671 14.883469671
15 0.4803711926 73.3337055991 0.163772393 5 87.7368040775 92.7368040775 91.5929449015 92.7368040775 14.4030984784 19.4030984784
16 1.3004253026 74.6341309017 0.4763468771 8 91.5929449015 99.5929449015 99.5929449015 92.7368040775 16.9588139998 24.9588139998
17 9.105550087 83.7396809887 0.186553494 5 92.7368040775 97.7368040775 99.5929449015 97.7368040775 8.9971230888 13.9971230888
18 5.8690045964 89.6086855852 0.048780452 5 97.7368040775 102.7368040775 99.5929449015 102.7368040775 8.1281184924 13.1281184924
19 2.1854166991 91.7941022843 0.8718958942 10 99.5929449015 109.5929449015 109.5929449015 102.7368040775 7.7988426173 17.7988426173
20 5.312180343 97.1062826273 0.1118739702 5 102.7368040775 107.7368040775 109.5929449015 107.7368040775 5.6305214502 10.6305214502
21 8.1177358224 105.2240184497 0.440488773 8 107.7368040775 115.7368040775 109.5929449015 115.7368040775 2.5127856278 10.5127856278
22 9.8214875126 115.0455059623 0.1349352245 5 115.0455059623 120.0455059623 120.0455059623 115.7368040775 0 5
23 2.9146276263 117.9601335886 0.0806278326 5 117.9601335886 122.9601335886 120.0455059623 122.9601335886 0 5
24 8.1709188013 126.1310523899 0.7822947231 10 126.1310523899 136.1310523899 136.1310523899 122.9601335886 0 10
25 8.6174189538 134.7484713436 0.3513819595 8 134.7484713436 142.7484713436 136.1310523899 142.7484713436 0 8
26 3.0327241306 137.7811954743 0.8532063688 10 137.7811954743 147.7811954743 147.7811954743 142.7484713436 0 10
27 2.5157409769 140.2969364512 0.4703095889 8 142.7484713436 150.7484713436 147.7811954743 150.7484713436 2.4515348925 10.4515348925
28 8.4812520617 148.7781885128 0.3353287138 8 148.7781885128 156.7781885128 156.7781885128 150.7484713436 0 8
29 7.9624844877 156.7406730006 0.7978343793 10 156.7406730006 166.7406730006 156.7781885128 166.7406730006 0 10
30 5.8260268414 162.5666998419 0.4298155529 8 162.5666998419 170.5666998419 170.5666998419 166.7406730006 0 8
31 1.2068958106 163.7735956526 0.5921684131 8 166.7406730006 174.7406730006 170.5666998419 174.7406730006 2.967077348 10.967077348
32 7.7011049247 171.4747005773 0.0766575003 5 171.4747005773 176.4747005773 176.4747005773 174.7406730006 0 5
33 2.4809584711 173.9556590484 0.0598764467 5 174.7406730006 179.7406730006 176.4747005773 179.7406730006 0.7850139521 5.7850139521
34 2.7791102642 176.7347693126 0.3357823934 8 176.7347693126 184.7347693126 184.7347693126 179.7406730006 0 8
35 1.6715304111 178.4062997237 0.4810776264 8 179.7406730006 187.7406730006 184.7347693126 187.7406730006 1.3343732768 9.3343732768
36 1.0104904231 179.4167901469 0.0347716469 5 184.7347693126 189.7347693126 189.7347693126 187.7406730006 5.3179791657 10.3179791657
37 7.8335897901 187.2503799369 0.6763928796 10 187.7406730006 197.7406730006 189.7347693126 197.7406730006 0.4902930637 10.4902930637
38 3.3106814695 190.5610614064 0.2355157923 8 190.5610614064 198.5610614064 198.5610614064 197.7406730006 0 8
39 0.7197246827 191.2807860891 0.8954144784 10 197.7406730006 207.7406730006 198.5610614064 207.7406730006 6.4598869115 16.4598869115
40 3.1607144601 194.4415005492 0.734506157 10 198.5610614064 208.5610614064 208.5610614064 207.7406730006 4.1195608572 14.1195608572
41 4.287356051 198.7288566002 0.0115869019 5 207.7406730006 212.7406730006 208.5610614064 212.7406730006 9.0118164003 14.0118164003
42 2.8258583375 201.5547149377 0.5102756511 8 208.5610614064 216.5610614064 216.5610614064 212.7406730006 7.0063464687 15.0063464687
43 0.2467229159 201.8014378536 0.821520026 10 212.7406730006 222.7406730006 216.5610614064 222.7406730006 10.939235147 20.939235147
44 3.0921836557 204.8936215093 0.4044572322 8 216.5610614064 224.5610614064 224.5610614064 222.7406730006 11.6674398971 19.6674398971
45 9.1131733436 214.006794853 0.9149006744 12 222.7406730006 234.7406730006 224.5610614064 234.7406730006 8.7338781476 20.7338781476
46 6.2107227027 220.2175175556 0.6144122665 10 224.5610614064 234.5610614064 234.5610614064 234.7406730006 4.3435438508 14.3435438508
47 7.5505066505 227.7680242061 0.911945339 12 234.5610614064 246.5610614064 246.5610614064 234.7406730006 6.7930372003 18.7930372003
48 8.0827660379 235.850790244 0.5762839073 8 235.850790244 243.850790244 246.5610614064 243.850790244 0 8
49 7.1032466489 242.9540368928 0.1645374745 5 243.850790244 248.850790244 246.5610614064 248.850790244 0.8967533511 5.8967533511
50 1.5354058962 244.489442789 0.6786889777 10 246.5610614064 256.5610614064 256.5610614064 248.850790244 2.0716186174 12.0716186174
51 2.6314654249 247.1209082139 0.8516482362 10 248.850790244 258.850790244 256.5610614064 258.850790244 1.7298820301 11.7298820301
52 1.2113393854 248.3322475993 0.8611280562 10 256.5610614064 266.5610614064 266.5610614064 258.850790244 8.2288138071 18.2288138071
53 9.4261365703 257.7583841696 0.4443256674 8 258.850790244 266.850790244 266.5610614064 266.850790244 1.0924060744 9.0924060744
54 8.8416418818 266.6000260514 0.7661216012 10 266.6000260514 276.6000260514 276.6000260514 266.850790244 0 10
55 1.1685577607 267.7685838121 0.0726458021 5 267.7685838121 272.7685838121 276.6000260514 272.7685838121 0 5
56 5.3416945328 273.1102783449 0.5754320674 8 273.1102783449 281.1102783449 276.6000260514 281.1102783449 0 8
57 3.9691636475 277.0794419924 0.8975477365 10 277.0794419924 287.0794419924 287.0794419924 281.1102783449 0 10
58 0.525771004 277.6052129965 0.8636015837 10 281.1102783449 291.1102783449 287.0794419924 291.1102783449 3.5050653485 13.5050653485
59 6.0243595792 283.6295725756 0.1856596776 5 287.0794419924 292.0794419924 292.0794419924 291.1102783449 3.4498694168 8.4498694168
60 5.9018585573 289.5314311329 0.3459506269 8 291.1102783449 299.1102783449 292.0794419924 299.1102783449 1.578847212 9.578847212
61 3.0760853695 292.6075165025 0.9609889628 12 292.6075165025 304.6075165025 304.6075165025 299.1102783449 0 12
62 9.5399791121 302.1474956146 0.2205335037 8 302.1474956146 310.1474956146 304.6075165025 310.1474956146 0 8
63 0.9345170016 303.0820126162 0.985553802 12 304.6075165025 316.6075165025 316.6075165025 310.1474956146 1.5255038862 13.5255038862
64 6.2163710201 309.2983836364 0.2222618671 8 310.1474956146 318.1474956146 316.6075165025 318.1474956146 0.8491119782 8.8491119782
65 2.1422511115 311.4406347479 0.8273676337 10 316.6075165025 326.6075165025 326.6075165025 318.1474956146 5.1668817546 15.1668817546
66 5.4232678456 316.8639025935 0.565286903 8 318.1474956146 326.1474956146 326.6075165025 326.1474956146 1.2835930211 9.2835930211
67 6.3307751135 323.194677707 0.6947729457 10 326.1474956146 336.1474956146 326.6075165025 336.1474956146 2.9528179076 12.9528179076
68 1.4156574614 324.6103351683 0.0461802322 5 326.6075165025 331.6075165025 331.6075165025 336.1474956146 1.9971813342 6.9971813342
69 7.1961082331 331.8064434014 0.6539335463 10 331.8064434014 341.8064434014 341.8064434014 336.1474956146 0 10
70 0.3349904621 332.1414338635 0.2150257142 8 336.1474956146 344.1474956146 341.8064434014 344.1474956146 4.0060617511 12.0060617511
71 2.0481641732 334.1895980367 0.1266543171 5 341.8064434014 346.8064434014 346.8064434014 344.1474956146 7.6168453647 12.6168453647
72 5.2916362079 339.4812342446 0.9005499955 12 344.1474956146 356.1474956146 346.8064434014 356.1474956146 4.66626137 16.66626137
73 2.9024491289 342.3836833735 0.4323191325 8 346.8064434014 354.8064434014 354.8064434014 356.1474956146 4.4227600279 12.4227600279
74 2.6430067964 345.0266901699 0.8975904194 10 354.8064434014 364.8064434014 364.8064434014 356.1474956146 9.7797532315 19.7797532315
75 4.3257964208 349.3524865907 0.6189470917 10 356.1474956146 366.1474956146 364.8064434014 366.1474956146 6.7950090239 16.7950090239
76 6.119766666 355.4722532567 0.8855540979 10 364.8064434014 374.8064434014 374.8064434014 366.1474956146 9.3341901447 19.3341901447
77 8.811780944 364.2840342007 0.8172159728 10 366.1474956146 376.1474956146 374.8064434014 376.1474956146 1.8634614139 11.8634614139
78 7.5527533392 371.8367875399 0.0883532231 5 374.8064434014 379.8064434014 379.8064434014 376.1474956146 2.9696558615 7.9696558615
79 4.0171755382 375.853963078 0.385723508 8 376.1474956146 384.1474956146 379.8064434014 384.1474956146 0.2935325366 8.2935325366
80 7.109799306 382.963762384 0.5092394249 8 382.963762384 390.963762384 390.963762384 384.1474956146 0 8
81 1.5246850578 384.4884474418 0.4737089555 8 384.4884474418 392.4884474418 390.963762384 392.4884474418 0 8
82 1.1539258646 385.6423733064 0.1406968734 5 390.963762384 395.963762384 395.963762384 392.4884474418 5.3213890776 10.3213890776
83 2.1171645678 387.7595378742 0.5811939924 8 392.4884474418 400.4884474418 395.963762384 400.4884474418 4.7289095676 12.7289095676
84 1.6426859812 389.4022238554 0.9277790777 12 395.963762384 407.963762384 407.963762384 400.4884474418 6.5615385286 18.5615385286
85 6.7691854927 396.1714093481 0.6275927108 10 400.4884474418 410.4884474418 407.963762384 410.4884474418 4.3170380936 14.3170380936
86 3.4889026399 399.660311988 0.2337472606 8 407.963762384 415.963762384 415.963762384 410.4884474418 8.303450396 16.303450396
87 1.8944116294 401.5547236174 0.6203257341 10 410.4884474418 420.4884474418 415.963762384 420.4884474418 8.9337238244 18.9337238244
88 3.4841243679 405.0388479853 0.3374260305 8 415.963762384 423.963762384 423.963762384 420.4884474418 10.9249143987 18.9249143987
89 1.2186253127 406.257473298 0.4838877047 8 420.4884474418 428.4884474418 423.963762384 428.4884474418 14.2309741438 22.2309741438
90 8.4940648777 414.7515381757 0.9368409756 12 423.963762384 435.963762384 435.963762384 428.4884474418 9.2122242083 21.2122242083
91 8.5608193391 423.3123575148 0.5795341867 8 428.4884474418 436.4884474418 435.963762384 436.4884474418 5.176089927 13.176089927
92 4.2688848901 427.5812424048 0.8607823147 10 435.963762384 445.963762384 445.963762384 436.4884474418 8.3825199791 18.3825199791
93 8.1472838071 435.728526212 0.7103619357 10 436.4884474418 446.4884474418 445.963762384 446.4884474418 0.7599212298 10.7599212298
94 3.1785510985 438.9070773104 0.1176874673 5 445.963762384 450.963762384 450.963762384 446.4884474418 7.0566850736 12.0566850736
95 2.1861784352 441.0932557456 0.9609589139 12 446.4884474418 458.4884474418 450.963762384 458.4884474418 5.3951916962 17.3951916962
96 2.2141952353 443.3074509809 0.1815122282 5 450.963762384 455.963762384 455.963762384 458.4884474418 7.656311403 12.656311403
97 7.5072583261 450.8147093071 0.7530480278 10 455.963762384 465.963762384 465.963762384 458.4884474418 5.1490530769 15.1490530769
98 6.1848115188 456.9995208259 0.8502182105 10 458.4884474418 468.4884474418 465.963762384 468.4884474418 1.4889266159 11.4889266159
99 0.8384288643 457.8379496902 0.1964568561 5 465.963762384 470.963762384 470.963762384 468.4884474418 8.1258126938 13.1258126938
100 6.2138597653 464.0518094554 0.6440938149 10 468.4884474418 478.4884474418 470.963762384 478.4884474418 4.4366379864 14.4366379864
Summary of Statistics
Number of Waiting 70 Wait Time Range Bin Frequency
Number of Customers 100 0 - 2 2 46
Probability of Waiting 0.7 2 - 4 4 8
Average Waiting Time 3.9547754795 4 - 6 6 15
Maximum Waiting Time 16.9588139998 6 - 8 8 11
Utilization of Quality Inspectors 0.871494395 8 - 10 10 14
Number of Waiting>2 Min 54 10 - 12 12 3
Probability of Waiting>2 Min 0.54 12 - 14 14 0
14 - 16 16 2
16 - 18 18 1
18 - 20 20 0
20 - 22 22 0
22 - 24 24 0
24 - 26 26 0
26 - 28 28 0
28 - 30 30 0
>30 0

Frequency 0 - 2 2 - 4 4 - 6 6 - 8 8 - 10 10 - 12 12 - 14 14 - 16 16 - 18 18 - 20 20 - 22 22 - 24 24 - 26 26 - 28 28 - 30 > 30 46 8 15 11 14 3 0 2 1 0 0 0 0 0 0 0

Alternative Formula for Service Time (Cell H2): IF(G2<$A$7,$B$7,IF(G2<($A$7+$A$8),$B$8, IF(G2<($A$7+$A$8+$A$9), $B$9,$B$10)))