Integrating Case - MEDD - Student(1).xlsx - Three Point...

Three Point Roll Up - Acquisition Planning
Cost Elements
Rates Low Obj. High
Material 1,425,000 1,712,500 2,000,000
Material O/H 5.00% 71,250 85,625 100,000
Fabrication 648,900 999,600 1,600,200
Assembly/QC 1,325,100 1,785,000 2,415,000
Subtotal Mfg Labor 1,974,000 2,784,600 4,015,200
Mfg. O/H 185.00% 3,651,900 5,151,510 7,428,120
Eng. Labor 600,100 709,750 819,400
Eng. O/H 125% 750,125 887,188 1,024,250
ODC 115,880 120,125 124,371
Subtotal Cost 8,588,255 11,451,298 15,511,341
G&A 8.00% 687,060 916,104 1,240,907
Total Cost 9,275,315 12,367,402 16,752,248 135%

Enter File Nam
# DATA INPUT
1 110120 -1.29
2 120950 0.11
3
112,250
-1.01
4 119,980 -0.02
5 131870 1.51
6
119360
-0.10
7 128000 1.01
8 108100 -1.55
9
120890
0.10
10 119990 -0.02
11 129870 1.25
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Descriptive Statistics
30
31
32
Count: 11 Mean:
33
34
Minimum: 108,100.00 Median:
35
36
Maximum: 131,870.00 Mode:
STD DEV's
from MEAN
0
1
2
3
4
5
6

37
Maximum: 131,870.00 Mode:
38
Standard Deviation: 7,768.73 Skewness:
39
40
Coefficient of Variation: 6.47% Kurtosis:
41
42
43
44
45
46
47
48
49
50
0
20000
40000
60000
80000
100000
120000
140000
160000
Column W Mean
Distribution of Data Points

me Here
120125.45 Enter Confidence Level: 90.0%
119990.00 Minimum 115880.02
#VALUE! Mean 120125.45

#VALUE! Mean 120125.45
-0.05 Maximum 124370.89
-0.81 (+/-) 4245.439
Plus 2 Std Dev Minus 2 Std Dev
around the Mean

Symmetric Approximation For Shape: enter B for Right Beta, T for Triang
Triangular, Right Beta, Uniform Normal Distribution Discrete Distribution
Cost Element Low Most Likely High Mean Std Dev Value 1 Prob 1 Value 2 Prob 2
1
2
3
4
5
6
7
8
9
10
Position to be Evaluated:
Probability of Underrun: Err:502
Probability of Overrun: Err:502