Integrating Case - MEDD - Reset.xlsx - Three Point Roll Up...

This preview shows page 1 - 7 out of 13 pages.

Three Point Roll Up - Acquisition Planning Cost Elements Shape Rates Low Obj. High Material U 1,425,000 1,712,500 2,000,000 Material O/H U 5.00% 71,250 85,625 100,000 Fabrication T $ 21.00 648,900 999,600 1,600,200 Assembly/QC T 21 1,325,100 1,785,000 2,415,000 Subtotal Mfg Labor 1,974,000 2,784,600 4,015,200 Mfg. O/H T 185.00% 3,651,900 5,151,510 7,428,120 Eng. Labor D $ 34.00 600,100 709,750 819,400 Eng. O/H D 125% 750,125 887,188 1,024,250 ODC N 115,880 120,126 124,371 Subtotal Cost 8,588,255 11,451,299 15,511,341 G&A U 8.00% 687,060 916,104 1,240,907 Total Cost 9,275,315 12,367,402 16,752,248 Material and Eng. objectives are avg of high and low Ceiling Price % = High Position = 16,752,248 1.354549 Obj Position 12,367,402 Rounds to 135%
ODC (current prices) # DATA INPUT 1 110,120.00 -1.29 2 120,950.00 0.11 3 112,250.00 -1.01 4 119,980.00 -0.02 5 131,870.00 1.51 6 119,360.00 -0.10 7 128,000.00 1.01 8 108,100.00 -1.55 9 120,890.00 0.10 10 119,990.00 -0.02 11 129,870.00 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
) Calculations 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 MATERIAL 1425000 2000000 2 MAT'L O/H 71250 100000 3 FABRICATION 648900 999600 1600200 4 ASSEMBLY/QC 1325100 1785000 2415000 5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture