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

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

The preview shows page 5 - 7 out of 13 pages.
Three Point Roll Up - Acquisition PlanningCost ElementsRatesLowObj.HighMaterial1,425,0001,712,5002,000,000Material O/H5.00%71,25085,625100,000Fabrication648,900999,6001,600,200Assembly/QC1,325,1001,785,0002,415,000Subtotal Mfg Labor1,974,0002,784,6004,015,200Mfg. O/H185.00%3,651,9005,151,5107,428,120Eng. Labor600,100709,750819,400Eng. O/H125%750,125887,1881,024,250ODC115,880120,125124,371Subtotal Cost8,588,25511,451,29815,511,341G&A8.00%687,060916,1041,240,907Total Cost9,275,31512,367,40216,752,248135%
Enter File Nam#DATA INPUT1110120-1.2921209500.113112,250-1.014119,980-0.0251318701.516119360-0.1071280001.018108100-1.5591208900.1010119990-0.02111298701.25121314151617181920212223242526272829Descriptive Statistics303132Count:11Mean:3334Minimum:108,100.00Median:3536Maximum:131,870.00Mode:STD DEV'sfrom MEAN0123456
37Maximum:131,870.00Mode:38Standard Deviation:7,768.73Skewness:3940Coefficient of Variation:6.47%Kurtosis:41424344454647484950020000400006000080000100000120000140000160000Column WMeanDistribution of Data Points
me Here120125.45Enter Confidence Level:90.0%119990.00Minimum115880.02#VALUE!Mean120125.45
#VALUE!Mean120125.45-0.05Maximum124370.89-0.81(+/-)4245.439Plus 2 Std DevMinus 2 Std Devaround the Mean
Symmetric ApproximationFor Shape: enter B for Right Beta, T for TriangTriangular, Right Beta, UniformNormal DistributionDiscrete DistributionCost ElementLowMost LikelyHighMeanStd DevValue 1Prob 1Value 2Prob 212345678910Position to be Evaluated:Probability of Underrun:Err:502Probability of Overrun:Err:502

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 13 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture