Ch%2012_P3 - Problem 3 Ch 12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Ch%2012_P3 - Problem 3 Ch 12 1 2 3 4 5 6 7 8 9 10 11 12 13...

This preview shows page 1 - 6 out of 53 pages.

Problem 3 Ch 12 Page 1 Chapter 12 Problem 3 Activity Durations Node A B C D E F G H 1 2(A) 3(B,C) 4(D) 5(E) 6(F,G) 7(H) Difference Before #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 0 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? After #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 0 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? simtable #ADDIN? Output Statistics Simulation Results for CH 12_P3 Outputs Before / 7(H) Iterations= 100 Simulation 1 Simulations= 8 Statistics / Cell $P$4 # Input Variables= 9 Minimum 23.02 # Output Variables= 2 Maximum 33.31 Sampling Type= Latin Hypercube Mean 28.4 Runtime= 00:00:49 Standard Deviation 2.24 Variance 5 Summary Statistics Skewness -0.08 Kurtosis 2.8 Cell Name Minimum Mean Maximum Number of Errors 0 Prob Crit Mode 27.89 Q4 (Sim#1) Before/Diffe... 0.01 0.01 0.01 1 5.0% 24.7 Q4 (Sim#2) Before/Diffe... 0.01 0.01 0.01 1 10.0% 25.4 Q4 (Sim#3) Before/Diffe... 0 0 0 0 15.0% 25.81 Q4 (Sim#4) Before/Diffe... 0.01 0.01 0.01 1 Part C 20.0% 26.41 Q4 (Sim#5) Before/Diffe... 0 0 0.01 0.33 25.0% 26.79 Q4 (Sim#6) Before/Diffe... 0 0 0.01 0.33 30.0% 27.39 Q4 (Sim#7) Before/Diffe... 0 0.01 0.01 0.67 35.0% 27.71 Q4 (Sim#8) Before/Diffe... 0.01 0.01 0.01 1 40.0% 27.87 45.0% 28.05 50.0% 28.48 55.0% 28.7 60.0% 29.04 65.0% 29.18 70.0% 29.44 75.0% 29.82 80.0% 30.27 85.0% 30.78 90.0% 31.08 95.0% 32.2 Filter Minimum Filter Maximum Type (1 or 2) # Values Filtered 0 Scenario #1 >75% Scenario #2 <25% Scenario #3 >90% Target #1 (Value)= 30 Target #1 (Perc%)= 76.53442% Part A Target #2 (Value)= 36 Target #2 (Perc%)= 100.00% Part B A B C D E F G H I J K L M N O P Q 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
@RISK Summary Report General Information Workbook Name Ch 12_P3.xls Number of Simulations 8 Number of Iterations 100 Number of Inputs 9 Number of Outputs 2 Sampling Type Latin Hypercube Simulation Start Time 4/13/10 11:49:55 Simulation Stop Time 4/13/10 11:49:55 Simulation Duration 0:00:00 Random Seed 1912114 Total Errors 0 Output and Input Summary Statistics Output Name Output Cell Simulation Minimum Before / 7(H) $P$4 1 23.02 2 23.02 3 23.02 4 23.02 5 23.02 6 23.02 7 23.02 8 23.02 Before / Difference $Q$4 1 0.01 2 0.01 3 0 4 0.01 5 0 6 0 7 0 8 0.01 Input Name Input Cell Simulation Minimum Before / A $B$4 1 4.32 2 4.32 3 4.32 4 4.32 5 4.32 6 4.32 7 4.32 8 4.32 Before / B $C$4 1 4.4 2 4.4 3 4.4 4 4.4 5 4.4 6 4.4 7 4.4 8 4.4 Before / C $D$4 1 1.4
2 1.4 3 1.4 4 1.4 5 1.4 6 1.4 7 1.4 8 1.4 Before / D $E$4 1 1.27 2 1.27 3 1.27 4 1.27 5 1.27 6 1.27 7 1.27 8 1.27 Before / E $F$4 1 0.62 2 0.62 3 0.62 4 0.62 5 0.62 6 0.62 7 0.62 8 0.62 Before / F $G$4 1 1.45 2 1.45 3 1.45 4 1.45 5 1.45 6 1.45 7 1.45 8 1.45 Before / G $H$4 1 3.3 2 3.3 3 3.3 4 3.3 5 3.3 6 3.3 7 3.3 8 3.3 Before / H $I$4 1 1.43 2 1.43 3 1.43 4 1.43 5 1.43 6 1.43 7 1.43 8 1.43 simtable / A $B$8 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8
Maximum Mean Std Dev x1 p1 x2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 33.31 28.4 2.24 24.7 5.0% 32.2 0.01 0.01 0 0.01 5.0% 0.01 0.01 0.01 0 0.01 5.0% 0.01 0 0 0 0 5.0% 0 0.01 0.01 0 0.01 5.0% 0.01 0.01 0 0 0 5.0% 0.01 0.01 0 0 0 5.0% 0.01 0.01 0.01 0 0 5.0% 0.01 0.01 0.01 0 0.01 5.0% 0.01 Maximum Mean Std Dev x1 p1 x2 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 7.41 6 0.6 4.99 5.0% 6.98 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 11.05 7.99 1.3 5.74 5.0% 10.03 2.58 2 0.2 1.67 5.0% 2.31
2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.58 2 0.2 1.67 5.0% 2.31 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 2.81 2 0.3 1.48 5.0% 2.47 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 5.35 3 0.99 1.36 5.0% 4.57 4.47 3 0.6 1.99 5.0% 3.99 4.47 3 0.6 1.99 5.0% 3.99 4.47 3 0.6 1.99 5.0% 3.99 4.47 3 0.6 1.99 5.0% 3.99 4.47 3 0.6 1.99 5.0% 3.99 4.47

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture