Department Gross Production Marketing HR

/Head Revenue cost Expense Expense

Task
Gross Production Marketing HR
Scenario Profit
Revenue cost Expense Expense
1 180.89 69.59 48.70 34.38 28.22
2 173.75 73.06 21.31 35.69 43.70
3 203.45 71.42 32.12 49.83 50.08
4 188.37 72.66 29.10 40.54 46.07
5 162.58 86.24 27.10 37.52 11.72
6 183.07 81.81 16.71 53.29 31.26
7 156.39 79.68 39.11 42.03 (4.42)
8 174.90 81.65 43.23 36.75 13.27 Step 1
Now, you will manually create 100 simulated
9 randomly generate values for Gross Revenue,
140.35 45.11 24.87 44.75 25.62 distributions. You will then calculate the prof
10 210.72 76.72 37.36 27.24 69.39
11 181.73 74.15 17.58 36.98 53.03
12 161.90 46.77 26.51 34.92 53.70 Step 2
13 182.98 62.33 29.73 36.12 54.79 Use of [Link] and [Link] Excel
14 148.94 84.58 23.87 55.54 (15.05) [Link]
15 200.37 74.21 17.76 54.34 54.06
16 155.91 54.76 26.04 55.10 20.01
17 196.20 79.40 27.77 39.67 49.35 Step 3
18 139.82 62.72 16.12 33.48 27.51 You should use, [Link] function here, to
19 165.99 61.93 32.18 47.40 24.47 with fixed, mean and std dev. I have drawn on
20 148.94 73.81 20.74 60.26 (5.87) cost components, and calculate the correspond
21 165.22 86.75 42.35 42.14 (6.02)
22 173.10 66.00 21.27 37.98 47.85
23 197.25 79.71 24.53 41.68 51.32 Step 4
24 201.83 61.95 31.68 53.18 55.02 Finally, As mentioned we are rather concerned
25 158.36 60.22 28.26 40.88 28.99 value). Draw the histogram and fill the follow
26 resume our next class from this point.
143.26 78.76 35.70 32.15 (3.35)
27 158.38 76.64 35.67 43.59 2.48
28 158.84 75.01 20.65 53.06 10.11 Minimum Profit
29 149.08 81.11 31.25 39.26 (2.54) Maximum Profit
30 183.97 60.43 34.81 44.65 44.09 Mean
31 181.44 72.04 31.34 39.91 38.16 Median
32 170.91 68.58 28.41 36.97 36.96 Std Dev
33 176.34 70.35 35.24 26.93 43.81
34 169.44 71.92 24.48 39.06 33.99 P(X>=50) (61.02)
35 156.18 60.02 28.35 41.26 26.55 0.884562
36 164.49 68.40 42.59 31.63 21.87
37 179.70 87.72 18.62 28.11 45.26
38 159.77 87.14 27.44 44.96 0.23
39 146.05 69.56 24.22 36.90 15.37
40 167.73 75.37 13.95 39.78 38.63
41 183.97 75.11 29.81 27.43 51.63
42 182.18 58.82 46.12 56.01 21.22
43 196.99 83.02 31.28 36.93 45.76
44 198.79 72.04 35.24 46.18 45.33
45 173.69 71.48 35.82 43.85 22.55
46 175.11 61.23 35.41 29.51 48.96
47 164.97 61.48 26.16 43.67 33.66
48 134.10 64.10 20.18 33.93 15.89
49 187.56 66.51 25.61 19.12 76.31
50 193.94 89.22 35.10 25.59 44.02
51 186.84 50.89 41.34 42.69 51.92
52 190.36 69.64 33.10 32.30 55.33
53 151.94 77.34 27.67 42.63 4.31
54 151.49 75.70 39.86 51.96 (16.03)
55 182.22 70.34 37.32 26.11 48.45
56 164.86 73.00 25.07 38.45 28.34
57 171.68 82.07 15.66 32.40 41.56
58 177.25 69.29 30.11 42.52 35.34
59 167.52 56.55 41.13 42.86 26.99
60 141.58 69.54 36.65 45.46 (10.07)
61 205.34 51.89 26.78 52.82 73.84
62 164.54 56.26 28.72 48.63 30.93
63 152.68 68.82 22.25 45.88 15.73
64 158.42 49.20 27.88 31.42 49.93
65 166.66 61.98 23.85 63.55 17.27
66 179.39 81.14 16.82 35.70 45.74
 67 179.18 79.63 24.51 43.40 31.63
68 195.57 94.02 37.38 44.93 19.23
69 181.93 67.79 23.15 41.14 49.85
70 161.52 61.06 34.59 37.19 28.69
71 183.72 76.61 32.40 35.19 39.52
72 177.52 96.14 44.80 39.87 (3.29)
73 163.19 65.70 32.01 44.45 21.03
74 144.40 69.00 32.46 36.70 6.25
75 153.33 72.34 26.13 32.61 22.25
76 181.00 53.21 30.57 48.60 48.62
77 174.73 78.58 26.00 45.99 24.17
78 170.49 73.26 28.69 47.02 21.52
79 179.52 84.92 27.25 48.83 18.51
80 183.55 53.91 34.31 51.35 43.98
81 200.59 62.34 36.63 53.86 47.76
82 194.27 83.62 39.84 45.38 25.43
83 169.20 85.21 38.55 41.33 4.11
84 178.33 53.30 30.18 42.09 52.76
85 178.33 83.40 30.14 66.20 (1.41)
86 154.30 51.48 27.52 44.88 30.42
87 195.87 62.86 35.45 46.77 50.79
88 139.75 69.09 16.55 41.50 12.60
89 179.28 75.34 31.79 42.08 30.07
90 164.03 72.84 42.57 41.14 7.49
91 173.84 78.81 39.36 25.97 29.71
92 172.46 69.13 24.46 37.89 40.99
93 202.50 80.11 32.91 30.79 58.68
94 150.34 63.35 31.58 32.23 23.18
95 175.03 72.25 22.52 39.34 40.91
96 129.57 69.43 29.24 38.65 (7.74)
97 196.77 67.12 39.53 46.39 43.73
98 164.50 79.23 28.12 51.61 5.54
99 192.48 79.69 30.71 35.55 46.52
100 184.03 73.35 39.18 36.08 35.41
101 135.82 83.58 23.42 36.42 (7.60)
102 168.61 59.62 40.31 41.23 27.44
103 152.40 86.02 28.30 42.60 (4.52)
104 192.73 64.46 31.98 44.64 51.65
105 173.96 63.12 34.23 43.73 32.88
106 164.21 55.17 26.42 45.30 37.32
107 172.52 83.29 36.76 34.54 17.93
108 202.92 65.24 16.15 24.17 97.36
109 180.41 43.70 24.69 41.21 70.80
110 174.24 72.04 41.31 38.44 22.44
111 166.48 72.33 26.54 30.89 36.72
112 141.50 73.35 41.27 38.83 (11.95)
113 186.58 57.15 30.21 29.87 69.36
114 168.16 53.78 32.86 38.86 42.66
115 193.87 68.12 36.79 41.01 47.95
116 170.39 54.22 19.17 48.19 48.81
117 188.50 66.00 29.39 39.50 53.61
118 180.89 75.76 33.09 26.47 45.57
119 141.44 80.56 22.38 59.88 (21.39)
120 190.55 60.98 25.29 34.15 70.12
121 213.86 48.80 24.28 43.16 97.63
122 184.51 76.63 35.88 43.57 28.44
123 179.60 59.02 32.07 39.34 49.16
124 139.91 82.39 24.47 33.77 (0.72)
125 177.00 78.72 20.88 43.49 33.90
126 181.86 71.10 31.19 41.33 38.24
127 128.52 68.35 34.95 36.74 (11.52)
128 212.18 70.90 25.13 56.67 59.48
129 181.65 88.80 29.34 49.82 13.69
130 188.14 74.41 27.83 27.72 58.18
131 174.61 58.55 25.50 50.48 40.08
132 191.58 62.75 29.77 42.72 56.33
133 171.83 72.12 27.74 44.92 27.04
134 178.06 58.31 26.35 47.45 45.95
135 154.59 60.07 22.60 53.79 18.13
136 189.07 74.34 12.79 48.59 53.35
137 127.53 70.38 28.08 50.52 (21.44)
138 184.94 55.11 38.78 37.82 53.23
139 186.93 83.26 36.93 43.52 23.22
140 149.61 72.56 14.59 43.76 18.70
141 176.99 68.37 16.33 29.94 62.35
142 123.28 66.47 35.94 42.98 (22.12)
143 124.13 63.25 43.59 47.24 (29.94)
144 141.71 60.48 25.09 39.43 16.71
145 164.66 63.48 25.37 34.93 40.89
146 147.15 83.36 32.45 24.63 6.71
147 171.16 88.22 35.27 54.97 (7.31)
148 169.65 77.22 35.27 37.89 19.28
149 163.65 72.42 20.52 46.61 24.11
150 162.30 46.85 29.01 48.44 37.99
151 172.13 70.54 30.04 41.22 30.32
152 152.66 72.38 21.50 32.92 25.87
153 178.27 75.30 32.55 25.85 44.57
154 141.17 81.92 25.40 61.71 (27.85)
155 149.86 78.92 37.71 31.70 1.52
156 164.43 61.79 31.55 31.10 39.99
157 173.23 77.17 25.87 35.47 34.72
158 171.12 74.32 25.50 39.18 32.11
159 181.34 60.04 18.83 39.32 63.14
160 154.17 70.59 28.32 38.96 16.30
161 193.96 72.40 43.26 34.61 43.70
162 162.13 86.41 38.24 47.09 (9.62)
163 143.51 65.89 32.77 33.61 11.25
164 166.20 63.82 29.61 35.85 36.91
165 155.07 78.66 30.32 36.33 9.75
166 179.83 73.48 22.85 43.02 40.48
167 165.22 65.79 37.69 40.35 21.39
168 168.49 82.06 21.91 43.48 21.04
169 172.89 71.22 20.63 32.53 48.51
170 161.59 77.40 35.74 36.72 11.73
171 145.40 67.32 14.98 37.55 25.55
172 204.85 79.38 10.87 47.27 67.32
173 172.62 76.87 26.34 44.75 24.65
174 162.76 66.89 25.92 45.65 24.30
175 153.71 69.45 33.44 38.44 12.38
176 178.11 63.42 12.52 38.36 63.81
177 183.01 81.25 42.32 39.17 20.28
178 153.78 62.84 15.49 46.45 29.01
179 172.70 66.97 33.55 22.78 49.41
180 173.60 66.25 26.45 47.99 32.90
181 163.65 72.87 37.65 41.15 11.98
182 165.20 58.22 36.99 46.86 23.12
183 193.84 69.99 27.71 49.70 46.44
184 147.49 76.16 21.37 46.51 3.45
185 165.27 51.62 28.05 38.74 46.86
186 202.66 68.73 19.17 27.57 87.19
187 183.12 73.49 26.79 40.92 41.92
188 168.20 79.18 27.39 47.35 14.28
189 158.74 70.93 42.84 40.80 4.17
190 195.17 69.14 26.69 26.44 72.89
191 200.84 67.74 39.80 37.78 55.52
192 164.17 76.74 26.25 43.79 17.39
193 179.15 82.26 38.28 43.15 15.46
194 178.40 62.59 21.17 34.18 60.45
195 186.94 88.18 22.58 44.45 31.74
196 144.86 83.77 27.52 32.70 0.87
197 169.32 94.78 53.70 30.65 (9.81)
198 157.36 73.94 27.41 32.69 23.33
199 173.83 68.75 45.58 38.99 20.51
200 159.01 51.10 29.46 32.76 45.69
201 199.28 68.86 22.22 47.47 60.73
202 155.64 57.40 49.71 43.22 5.30
203 179.37 77.86 28.68 40.12 32.72
204 151.01 73.54 41.03 45.27 (8.83)
205 170.89 76.49 43.35 37.50 13.55
206 179.21 71.16 19.93 37.58 50.54
207 182.78 66.10 10.81 51.66 54.20
208 167.38 74.23 34.87 40.27 18.01
209 177.30 64.62 37.23 27.06 48.39
210 158.35 74.50 27.10 31.66 25.08
211 194.15 68.78 22.58 53.33 49.45
212 185.89 76.71 35.62 31.20 42.37
213 171.36 69.64 26.05 26.92 48.75
214 182.27 52.51 42.13 40.45 47.18
215 203.52 68.96 35.12 44.50 54.94
216 166.09 57.99 44.14 28.93 35.02
217 190.66 59.88 27.45 44.51 58.82
218 182.98 69.51 22.57 50.33 40.57
219 193.77 64.92 38.60 42.98 47.27
220 186.37 88.20 25.47 24.19 48.51
221 202.21 77.78 23.17 51.48 49.77
222 184.59 53.29 33.05 31.73 66.51
223 142.27 73.17 30.00 47.33 (8.23)
224 177.81 63.57 39.01 44.81 30.42
225 133.39 38.81 41.84 51.45 1.28
226 165.92 68.28 36.61 47.07 13.96
227 140.70 84.36 24.34 52.86 (20.86)
228 178.50 70.42 35.89 36.73 35.47
229 167.94 81.27 26.65 27.88 32.15
230 213.03 72.02 35.85 42.61 62.55
231 177.06 75.56 22.34 32.24 46.91
232 182.04 65.07 20.06 46.05 50.85
233 205.16 68.27 26.58 62.50 47.82
234 175.93 54.59 23.97 51.58 45.79
235 173.47 91.93 38.71 43.26 (0.42)
236 175.44 64.47 21.49 40.36 49.12
237 138.79 70.45 32.16 38.61 (2.42)
238 151.44 71.24 43.24 45.08 (8.12)
239 144.69 67.01 42.54 48.20 (13.06)
240 189.16 68.64 53.42 36.73 30.36
241 208.86 72.73 44.12 31.83 60.17
242 172.02 88.15 30.38 33.76 19.73
243 134.71 81.81 25.67 35.12 (7.89)
244 154.43 86.66 41.40 36.60 (10.24)
245 181.22 63.38 38.67 41.91 37.25
246 178.91 62.91 24.75 40.08 51.16
247 163.98 44.34 16.20 31.36 72.09
248 165.12 85.73 33.48 47.85 (1.93)
249 181.29 66.57 39.50 48.58 26.64
250 224.50 78.06 44.36 38.41 63.66
251 183.58 62.76 38.59 22.91 59.32
252 163.99 84.05 27.39 37.68 14.87
253 167.56 60.27 34.85 34.57 37.87
254 175.91 71.62 29.03 20.69 54.57
255 157.53 60.22 19.17 31.07 47.07
256 176.36 75.11 32.46 44.36 24.44
257 170.49 63.29 24.62 30.86 51.72
258 201.01 80.39 38.19 44.26 38.18
259 134.35 78.29 31.36 34.35 (9.65)
260 196.45 69.04 17.60 40.67 69.15
261 178.61 70.27 -3.26 52.71 58.88
262 164.30 57.81 27.06 37.04 42.40
263 169.42 75.42 41.28 58.54 (5.82)
264 169.58 56.42 18.61 55.26 39.29
265 161.56 65.24 25.01 22.91 48.41
266 189.38 53.81 26.25 33.75 75.57
267 150.26 60.02 34.76 39.07 16.40
268 145.83 67.71 31.70 24.94 21.48
269 213.56 57.08 34.59 36.50 85.38
270 134.75 67.71 35.89 36.84 (5.69)
271 174.70 88.84 15.87 46.36 23.63
272 166.05 56.66 29.65 32.74 47.01
273 176.86 72.85 24.53 36.86 42.62
274 175.46 76.42 24.33 40.47 34.25
275 157.43 77.79 33.83 46.91 (1.10)
276 196.75 57.20 35.47 20.49 83.60
277 168.97 91.03 11.27 34.37 32.30
278 156.04 66.22 46.26 28.33 15.23
279 165.07 75.93 30.58 34.18 24.38
280 155.32 60.39 29.09 44.42 21.42
281 213.35 65.58 24.74 42.92 80.11
282 136.69 68.24 41.73 57.95 (31.23)
283 201.87 56.24 51.39 37.66 56.58
284 163.01 57.20 18.28 25.20 62.34
285 164.51 52.06 33.02 33.56 45.87
286 172.07 70.24 35.85 33.33 32.66
287 153.42 78.62 26.75 40.80 7.25
288 168.63 76.16 44.49 20.94 27.04
289 150.29 39.85 30.54 35.27 44.64
290 138.43 65.30 27.40 44.75 0.98
291 201.52 66.88 19.67 32.06 82.91
292 174.85 76.35 22.58 47.05 28.87
293 132.89 69.66 14.00 41.92 7.31
294 161.78 53.65 26.98 39.23 41.92
295 166.18 56.76 36.49 40.89 32.03
296 216.02 76.00 21.07 33.95 85.01
297 161.67 100.43 44.33 57.47 (40.56)
298 168.18 64.30 24.09 37.97 41.81
299 152.86 52.43 31.10 30.91 38.42
300 164.77 66.44 21.38 36.73 40.22
301 176.74 78.65 29.76 22.13 46.20
302 158.51 80.41 28.16 34.79 15.16
303 182.30 66.98 26.24 38.69 50.39
304 176.50 74.75 18.26 41.34 42.15
305 169.18 75.71 19.90 35.11 38.47
306 175.34 64.27 23.06 47.15 40.85
307 164.81 80.35 21.42 51.03 12.01
308 154.32 77.49 38.94 33.61 4.29
309 176.69 79.38 49.33 50.31 (2.33)
310 206.32 71.42 56.42 60.66 17.82
311 155.36 86.39 30.36 41.91 (3.31)
312 171.08 59.26 27.21 41.06 43.56
313 178.95 53.62 39.62 31.86 53.85
314 170.98 73.31 30.27 25.20 42.21
315 169.21 62.76 27.72 29.79 48.94
316 182.71 79.98 34.99 37.56 30.18
317 166.01 61.43 24.05 37.71 42.82
318 159.66 86.26 35.87 35.60 1.94
319 143.57 52.51 39.92 37.14 14.00
320 177.75 75.39 27.29 43.15 31.92
321 159.99 63.05 34.97 54.58 7.39
322 161.78 63.68 25.30 37.42 35.37
323 150.67 73.07 17.38 43.31 16.90
324 162.05 74.88 19.80 48.15 19.22
325 169.43 75.17 45.56 31.54 17.16
326 165.44 62.25 25.78 25.89 51.53
327 189.65 57.11 25.81 37.91 68.82
328 190.93 87.51 30.25 36.65 36.52
329 149.58 76.92 21.41 27.85 23.39
330 170.93 74.77 32.07 33.51 30.58
331 135.08 58.13 28.01 52.17 (3.23)
332 159.54 62.71 21.57 47.44 27.83
333 175.50 80.67 28.67 39.58 26.57
334 156.99 67.06 34.30 46.80 8.83
335 162.09 81.67 26.46 33.59 20.36
336 176.64 77.64 41.98 36.46 20.56
337 139.96 78.58 20.25 21.65 19.48
338 181.66 55.44 13.02 42.46 70.75
339 154.20 71.91 27.18 38.86 16.26
340 177.87 69.28 37.24 47.91 23.43
341 184.14 83.92 22.62 37.30 40.30
342 178.47 70.65 25.25 30.41 52.16
343 176.70 71.84 25.60 57.78 21.49
344 186.60 96.41 36.78 33.84 19.57
345 157.62 63.46 22.82 40.26 31.09
346 156.03 79.89 41.07 36.20 (1.13)
347 137.86 61.43 18.74 38.66 19.02
348 176.29 59.85 31.60 35.55 49.29
349 150.20 72.76 22.47 47.55 7.42
350 169.53 48.62 31.16 28.10 61.65
351 127.18 63.42 13.96 42.67 7.13
352 124.16 75.24 33.42 40.06 (24.56)
353 161.51 74.46 35.30 39.16 12.59
354 197.54 64.17 33.55 35.74 64.09
355 183.46 60.23 16.40 43.27 63.55
356 156.22 57.80 15.24 43.89 39.29
357 169.51 76.40 33.03 38.48 21.60
358 145.40 78.91 32.09 55.54 (21.15)
359 174.82 54.03 28.27 50.92 41.60
360 164.46 81.24 29.29 29.44 24.49
361 143.80 72.09 37.59 48.57 (14.44)
362 152.88 65.76 33.71 45.50 7.92
363 167.61 73.16 17.79 34.69 41.98
364 202.14 83.11 28.01 38.26 52.76
365 187.30 78.20 24.97 43.05 41.07
366 190.68 72.50 24.97 37.87 55.34
367 142.40 81.23 26.67 36.49 (1.98)
368 149.62 98.40 22.34 56.51 (27.62)
369 169.89 63.66 27.73 43.89 34.60
370 164.99 73.92 25.98 46.33 18.75
371 176.69 67.20 27.68 48.03 33.78
372 191.30 56.73 31.88 33.00 69.69
373 156.90 78.46 24.68 23.40 30.36
374 177.72 74.20 22.15 44.97 36.40
375 164.93 72.38 32.84 29.40 30.31
376 153.68 57.45 23.90 36.76 35.57
377 164.84 60.66 27.71 33.09 43.37
378 175.35 63.90 26.84 55.74 28.87
379 155.38 95.20 33.69 26.95 (0.46)
380 163.46 91.91 29.88 43.97 (2.31)
381 126.19 60.55 30.30 29.46 5.88
382 150.49 51.29 35.20 43.44 20.56
383 187.11 74.21 19.27 32.74 60.89
384 191.02 86.62 20.91 31.58 51.91
385 190.64 76.43 22.64 26.07 65.50
386 155.52 78.77 37.79 52.52 (13.57)
387 170.52 81.22 28.87 45.95 14.49
388 201.43 60.42 26.53 26.00 88.48
389 141.63 61.53 25.00 29.71 25.39
390 153.71 50.15 33.92 42.53 27.11
391 219.96 79.33 22.47 40.25 77.92
392 175.20 65.89 31.00 42.79 35.53
393 173.21 65.18 33.80 40.04 34.19
394 149.48 77.14 35.03 39.30 (1.99)
395 180.33 75.73 39.12 39.30 26.18
396 154.36 71.05 39.88 24.10 19.33
397 144.18 70.49 25.38 46.77 1.54
398 193.19 72.92 29.45 34.78 56.04
399 169.48 80.07 29.16 37.84 22.40
400 150.15 70.73 18.21 27.84 33.37
401 188.43 82.08 14.04 54.89 37.43
402 167.71 68.51 27.70 38.27 33.24
403 182.57 61.20 41.15 33.46 46.76
404 144.51 57.89 22.16 28.61 35.85
405 165.84 65.32 37.56 50.11 12.85
406 178.46 80.55 23.29 30.90 43.72
407 169.38 64.43 27.65 29.62 47.68
408 188.40 71.37 36.85 34.29 45.89
409 160.07 70.78 34.52 29.08 25.70
410 166.84 58.08 26.88 38.42 43.46
411 165.66 62.21 42.67 44.05 16.73
412 173.89 77.01 20.11 48.81 27.97
413 205.27 86.95 28.06 42.53 47.73
414 173.50 60.60 27.88 45.77 39.25
415 185.78 51.59 23.63 55.35 55.20
416 169.12 62.60 36.24 53.34 16.95
417 151.53 70.50 20.27 44.81 15.94
418 180.90 80.69 31.04 31.12 38.05
419 174.84 69.02 24.02 44.72 37.08
420 183.76 88.92 32.94 34.42 27.48
421 166.93 61.37 36.61 40.15 28.80
422 198.09 71.41 30.48 35.95 60.26
423 181.36 59.08 17.61 45.63 59.03
424 179.35 66.61 22.22 37.54 52.98
425 169.20 71.60 19.81 45.15 32.64
426 156.10 70.39 16.35 40.10 29.26
427 171.54 69.21 42.35 46.81 13.16
428 153.78 59.78 32.88 68.65 (7.53)
429 174.26 54.02 17.59 36.29 66.36
430 146.24 58.87 37.37 42.41 7.59
431 167.08 61.64 28.68 38.48 38.27
432 179.39 79.24 25.89 35.74 38.52
433 169.24 65.62 37.19 41.66 24.77
434 150.42 66.14 14.09 18.50 51.69
435 186.95 69.05 13.42 31.22 73.27
436 165.32 53.33 35.77 47.09 29.12
437 177.64 82.38 21.57 42.15 31.54
438 153.61 74.07 27.10 24.74 27.70
439 158.15 50.55 29.12 48.67 29.82
440 191.08 86.23 32.30 40.06 32.49
441 167.13 67.50 24.01 38.26 37.37
442 187.88 86.15 35.82 53.31 12.59
443 165.52 67.06 32.43 46.64 19.40
444 130.54 62.94 22.79 32.52 12.31
445 157.44 85.13 38.66 32.97 0.69
446 180.58 66.62 29.50 42.27 42.19
447 178.63 59.32 34.12 33.20 51.99
448 130.37 65.28 33.34 48.67 (16.92)
449 140.65 69.17 45.26 39.72 (13.49)
450 162.65 74.94 17.71 31.44 38.56
451 183.47 70.15 29.22 28.89 55.21
452 162.54 63.88 13.10 32.05 53.51
453 196.24 65.79 35.79 44.12 50.54
454 171.04 73.19 25.25 47.62 24.98
455 196.16 67.02 39.23 45.25 44.65
456 176.26 67.11 27.01 49.12 33.01
457 178.75 57.95 28.67 45.67 46.46
458 165.36 70.88 28.46 31.64 34.37
459 161.88 49.76 21.28 37.14 53.70
460 174.68 69.60 32.71 41.42 30.95
461 163.73 60.99 27.96 38.37 36.40
462 161.65 82.43 32.44 49.26 (2.48)
463 175.64 83.32 32.16 41.25 18.91
464 201.26 62.26 35.80 43.13 60.06
465 156.83 65.61 33.85 45.36 12.02
466 188.09 62.97 26.10 41.20 57.80
467 187.60 72.75 17.77 50.57 46.51
468 189.05 84.17 39.98 25.77 39.13
469 206.12 62.59 28.59 58.06 56.88
470 142.81 70.12 34.50 35.75 2.45
471 157.66 64.55 30.91 58.30 3.90
472 193.77 61.12 26.69 43.04 62.91
473 190.02 60.23 26.67 37.06 66.06
474 114.19 73.35 31.10 36.16 (26.42)
475 182.33 61.49 35.60 40.42 44.83
476 184.02 64.63 30.43 41.80 47.17
477 171.96 80.90 33.60 45.59 11.86
478 149.16 71.48 45.08 47.92 (15.33)
479 191.01 62.54 34.99 35.41 58.07
480 225.07 59.75 26.04 44.55 94.74
481 207.90 72.84 20.09 35.10 79.88
482 168.66 60.45 33.28 38.95 35.98
483 155.89 82.90 28.89 34.25 9.85
484 141.44 65.47 32.81 31.56 11.60
485 144.37 48.53 11.27 32.62 51.95
486 187.61 67.58 31.27 51.89 36.86
487 159.53 80.32 23.80 41.73 13.68
488 175.58 76.42 21.30 30.73 47.13
489 160.48 64.90 13.75 37.58 44.25
490 129.47 68.46 12.88 17.69 30.44
491 191.07 54.89 30.80 16.77 88.61
492 151.01 72.53 37.73 31.38 9.37
493 148.11 80.22 19.06 39.69 9.14
494 144.15 66.97 19.18 34.30 23.70
495 166.25 59.94 24.85 45.73 35.73
496 186.10 59.38 25.26 48.66 52.80
497 175.67 76.38 28.76 36.14 34.40
498 110.20 88.06 29.56 37.96 (45.37)
499 166.47 70.80 25.89 40.26 29.51
500 150.22 91.63 35.32 37.74 (14.47)
 This chart isn't available in your version of Exce

lly create 100 simulated scenarios for the next quarter. In each scenario, you will Editing this shape or saving this workbook into
lues for Gross Revenue, Production, Marketing, and HR based on their normal will permanently break the chart.
ill then calculate the profit for each scenario/trial.

T and [Link] Excel Fucntions appropriately, Watch the following short video,
[Link]/watch?v=B1PY6hTtpmc

[Link] function here, to draw random instances from a given (Normal) distribution
std dev. I have drawn one instance for Gross Revenue, you can do the same for other
calculate the corresponding profits.
d we are rather concerned about the distribution of profits, rather than a single (expected
ogram and fill the following table. Jot down your managerial observations. We will
from this point.

(45.37)
97.63
30.97
30.67
24.23
 lable in your version of Excel.

or saving this workbook into a different file format