Help

profilekesfin
hw3_answer_sheet-wi-2015-v2-2.xlsx

P1

Hoylake Rescue Squad
Probability of Time between calls Simulation
P(x) Cumulative Time between calls RN Time between calls Cumulative clock
0.05 0 1
0.1 0.05 2
0.3 0.15 3
0.3 0.45 4
0.2 0.75 5
0.05 0.95 6
1
EV =
Average Time =

P2

Petroco service
Simulation
Probability Cumulative Time between arrival (min)
0.25 0 1 Counts RN Time between calls RN Time between calls Cumulative clock
0.3 0.25 2 1
0.35 0.55 3 2
0.1 0.9 4 3
1 4
5
a. Avg Arrival time 6
b. Avg. arrival time 7
8
Compare a. and b. 9
10
11
12
13
14
15
16
17
18
19
20

P3

Dynaco Manufacturing
Probability breakdown per week Simulation
P(x) Cumulative Breakdown Week RN Breakdowns
0.05 0 0 1
0.15 0.05 1 2
0.2 0.2 2 3
0.3 0.4 3 4
0.25 0.7 4 5
0.05 0.95 5 6
1 7
8
9
Simulated avg. breakdown 10
Average breakdowns = 11
12
13
14
15
16
17
18
19
20

P4

Sun Visor or Umbrella?
Simulation
P(x) Cumulative Sun Visor Week RN SunVisor ($) RN Umbrella ($)
0.3 0 -500 1
0.15 0.3 -200 2
0.55 0.45 1500 3
1 4
5
6
P(x) Cumulative Umbrella 7
0.3 0 2000 8
0.15 0.3 0 9
0.55 0.45 -900 10
1 11
12
13
14
15
16
17
18
19
20
Average

P6

Dynaco Manufacturing
Repair Time Simulation
P(x) Cumulative Repair (hrs) Week RN Repair time (hours)
0.25 0 1 1
0.55 0.25 2 2
0.2 0.8 3 3
1 4
5
6
Simulated avg. repair time 7
8
9
10
11
12
13
14
15
16
17
18
19
20