costs - 1 A Forecasting Structural Costs B C D E F G H I J...

This preview shows page 1 - 23 out of 139 pages.

Forecasting Structural Costs Build Prototype #ADDIN? #ADDIN? #ADDIN? Spending Spending Smallest 3 1 2 Event Time Amount Quarter Amount Year Amount Most likely 5 2 2.5 #ADDIN? 1 #ADDIN? 1 #ADDIN? Lower 6.78 Largest 10 4 3.5 Plant built #ADDIN? 2 #ADDIN? 2 #ADDIN? Upper 7.1 Build plant #ADDIN? #ADDIN? #ADDIN? #ADDIN? 3 #ADDIN? 3 #ADDIN? 95% CI mean costs Smallest 4 1 3 #ADDIN? #ADDIN? 4 #ADDIN? 4 #ADDIN? Most likely 6 2 4 #ADDIN? #ADDIN? 5 #ADDIN? Total #ADDIN? Largest 9 3 8 #ADDIN? #ADDIN? 6 #ADDIN? Buy Machinery #ADDIN? #ADDIN? #ADDIN? 7 #ADDIN? Time needed Prob 8 #ADDIN? Name Plant built / Total / Amount 2 0.3 9 #ADDIN? Description Output Output 4 0.6 10 #ADDIN? Cell M6 M9 5 0.1 11 #ADDIN? Minimum 0 2.02 Quarters after Prob 12 #ADDIN? Maximum 3.44 11.94 1 0.5 13 #ADDIN? Mean 1.19 6.94 2 0.4 14 #ADDIN? Std Deviatio 1.35 2.36 3 0.1 15 #ADDIN? Variance 1.82 5.58 Size of expenditure Prob 16 #ADDIN? Skewness 0.3 -0.78 0.5 0.6 Total #ADDIN? Kurtosis 1.18 2.69 1 0.3 Errors Calc 0 0 2 0.1 Mode 0 6.83 5% Perc 0 2.39 10% Perc 0 2.59 15% Perc 0 2.89 20% Perc 0 5.79 25% Perc 0 6.32 30% Perc 0 6.59 35% Perc 0 6.81 40% Perc 0 7.01 45% Perc 0 7.19 50% Perc 0 7.4 55% Perc 0 7.63 60% Perc 2.29 7.81 65% Perc 2.41 8.03 70% Perc 2.51 8.29 75% Perc 2.6 8.54 80% Perc 2.69 8.79 85% Perc 2.8 9.21 90% Perc 2.93 9.48 95% Perc 3.11 9.91 Filter Minimum Filter Maximum Type (1 or 2) # Values Fi 0 0.00% 0 0 0 0 0 0 0 0 0 Scenario #1>75% >75% Scenario #2<25% <25% Scenario #3>90% >90% Target #1 (V ### 2.26 Target #1 (P 2.50% 2.50% Target #2 ( ### 10.33 Target #2 ( 97.50% 97.50% Target #3 (V 0 Target #3 (P 9.35% Time needed for activity Quarters after event where cash outflow occurs Size of expenditure( in billions) Prototype Built Machinery bought Paid for prototype Paid for plant Paid for Machinery A B C D E F G H I J K L M N O P Q R S T U V W X 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 53 54 55
X-Delimiters Series 1 1.19 0 0 0 1 1.78 3.11 0 2 0 3 0 4 0 5 0 6 0 7 0.06 8 0.39 9 0.52 10 0.31 11 0.14 Distrib 0.000 0.200 0.400 0.600 0.800 1.000 1.200 1.400 1.600 1.800 0 0.35 54.56% 0 .35
0 0 0 1.78 0 0 0 1.78 0 1.78 0 0 0.31 1.78 0 0 0.31 0 0 1.78 0.31 0 0.01 1.78 0.63 0 0.01 0 0.63 0 0.01 0 0.63 0 0.01 1.78 0.94 0 0.01 1.78 0.94 0 0.01 0 0.94 0 0.01 0 1.25 0 0.01 1.78 1.25 0 0.02 1.78 1.25 0 0.02 0 1.56 0 0.02 0 1.56 0 0.02 1.78 1.56 0 0.02 1.78 1.88 0 0.02 0 1.88 0 0.02 0 1.88 0.06 0.02 1.78 2.19 0.06 0.03 1.78 2.19 0 0.03 0 2.19 0.39 0.03 0 2.5 0.39 0.03 1.78 2.5 0 0.03 1.78 2.5 0.52 0.03 0 2.81 0.52 0.03 0 2.81 0 0.03 1.78 2.81 0.31 0.03 1.78 3.13 0.31 0.03 0 3.13 0 0.04 0 3.13 0.14 0.04 1.78 3.44 0.14 0.04 1.78 3.44 0 0.04 0 0.04 0
0.04 1.78 0.04 1.78 0.04 0 0.05 0 0.05 1.78 0.05 1.78 0.05 0 0.05 0 0.05 1.78 0.05 1.78 0.05 0 0.06 0 0.06 1.78 0.06 1.78 0.06 0 0.06 0 0.06 1.78 0.06 1.78 0.06 0 0.06 0 0.06 1.78 0.07 1.78 0.07 0 0.07 0 0.07 1.78 0.07 1.78 0.07 0 0.07 0 0.07 1.78 0.08 1.78 0.08 0 0.08 0 0.08 1.78 0.08 1.78 0.08 0 0.08 0 0.08 1.78 0.08 1.78 0.08 0 0.09 0 0.09 1.78 0.09 1.78 0.09 0 0.09 0 0.09 1.78 0.09 1.78 0.09 0 0.1 0 0.1 1.78 0.1 1.78 0.1 0 0.1 0 0.1 1.78
0.1 1.78 0.1 0 0.11 0 0.11 1.78 0.11 1.78 0.11 0 0.11 0 0.11 1.78 0.11 1.78 0.11 0 0.11 0 0.11 1.78 0.12 1.78 0.12 0 0.12 0 0.12 1.78 0.12 1.78 0.12 0 0.12 0 0.12 1.78 0.13 1.78 0.13 0 0.13 0 0.13 1.78 0.13 1.78 0.13 0 0.13 0 0.13 1.78 0.14 1.78 0.14 0 0.14 0 0.14 1.78 0.14 1.78 0.14 0 0.14 0 0.14 1.78 0.14 1.78 0.14 0 0.15 0 0.15 1.78 0.15 1.78 0.15 0 0.15 0 0.15 1.78 0.15 1.78 0.15 0 0.16 0 0.16 1.78 0.16 1.78 0.16 0 0.16 0 0.16 1.78 0.16 1.78
0.16 0 0.17 0 0.17 1.78 0.17 1.78 0.17 0 0.17 0 0.17 1.78 0.17 1.78 0.17 0 0.17 0 0.17 1.78 0.18 1.78 0.18 0 0.18 0 0.18 1.78 0.18 1.78 0.18 0 0.18 0 0.18 1.78 0.19 1.78 0.19 0 0.19 0 0.19 1.78 0.19 1.78 0.19 0 0.19 0 0.19 1.78 0.19 1.78 0.19 0 0.2 0 0.2 1.78 0.2 1.78 0.2 0 0.2 0 0.2 1.78 0.2 1.78 0.2 0 0.21 0 0.21 1.78 0.21 1.78 0.21 0 0.21 0 0.21 1.78 0.21 1.78 0.21 0 0.22 0 0.22 1.78 0.22 1.78 0.22 0 0.22 0 0.22 1.78 0.22 1.78 0.22 0
0.22 0 0.22 1.78 0.23 1.78 0.23 0 0.23 0 0.23 1.78 0.23 1.78 0.23 0 0.23 0 0.23 1.78 0.24 1.78 0.24 0 0.24 0 0.24 1.78 0.24 1.78 0.24 0 0.24 0 0.24 1.78 0.25 1.78 0.25 0 0.25 0 0.25 1.78 0.25 1.78 0.25 0 0.25 0 0.25 1.78 0.25 1.78 0.25 0 0.26 0 0.26 1.78 0.26 1.78 0.26 0 0.26 0 0.26 1.78 0.26 1.78 0.26 0 0.27 0 0.27 1.78 0.27 1.78 0.27 0 0.27 0 0.27 1.78 0.27 1.78 0.27 0 0.28 0 0.28 1.78 0.28 1.78 0.28 0 0.28 0 0.28 1.78 0.28 1.78 0.28 0 0.28 0
0.28 1.78 0.29 1.78 0.29 0 0.29 0 0.29 1.78 0.29 1.78 0.29 0 0.29 0 0.29 1.78 0.3 1.78 0.3 0 0.3 0 0.3 1.78 0.3 1.78 0.3 0 0.3 0 0.3 1.78 0.3 1.78 0.3 0 0.31 0 0.31 1.78 0.31 1.78 0.31 0 0.31 0 0.31 1.78 0.31 1.78 0.31 0 0.31 0 0.31 0 0.31 0 0.31 0 0.32 0 0.32 0 0.32 0 0.32 0 0.32 0 0.32 0 0.32 0 0.32 0 0.33 0 0.33 0 0.33 0 0.33 0 0.33 0 0.33 0 0.33 0 0.33 0 0.34 0 0.34 0 0.34 0 0.34 0 0.34 0 0.34 0
0.34 0 0.34 0 0.34 0 0.34 0 0.35 0 0.35 0 0.35 0 0.35 0 0.35 0 0.35 0 0.35 0 0.35 0 0.36 0 0.36 0 0.36 0 0.36 0 0.36 0 0.36 0 0.36 0 0.36 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.37 0 0.38 0 0.38 0 0.38 0 0.38 0 0.38 0 0.38 0 0.38 0 0.38 0 0.39 0 0.39 0 0.39 0 0.39 0 0.39 0 0.39 0 0.39 0 0.39 0 0.4 0 0.4 0 0.4 0 0.4 0 0.4 0 0.4 0 0.4 0
0.4 0 0.4 0 0.4 0 0.41 0 0.41 0 0.41 0 0.41 0 0.41 0 0.41 0 0.41 0 0.41 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.42 0 0.43 0 0.43 0 0.43 0 0.43 0 0.43 0 0.43 0 0.43 0 0.43 0 0.44 0 0.44 0 0.44 0 0.44 0 0.44 0 0.44 0 0.44 0 0.44 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.45 0 0.46 0 0.46 0 0.46 0 0.46 0 0.46 0 0.46 0

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture