Week 2 Integrating Case - STUDENT.xlsx - Three Point Roll...

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

The preview shows page 3 - 5 out of 7 pages.
Three Point Roll UpLowObj.HighMaterial1,425,0001,712,5002,000,000Material O/H71,25085,625100,000Fabrication648,900999,6001,600,200Assembly/QC1,325,1001,785,0002,415,000Mfg. O/H3,651,9005,151,5107,428,120Eng. Labor600,100709,750819,400Eng. O/H750,125887,1881,024,250ODC115,880120,125124,371Subtotal Cost8,588,25511,451,29815,511,341G&A687,060916,1041,240,907Total Cost9,275,31512,367,40116,752,2483,494,3506,124,323
1.3545487749
Enter File Name HereDATA INPUT110,120.00-1.29120,950.000.11112,250.00-1.01119,980.00-0.02131,870.001.51119,360.00-0.10128,000.001.01108,100.00-1.55120,890.000.10119,990.00-0.02129,870.001.25Descriptive StatisticsCount:11Mean:120125.45Enter Confidence Level:90.0%Minimum:108,100.00Median:119990.00Minimum115880.02Maximum:131,870.00Mode:#VALUE!Mean120125.45Standard Deviation:7,768.73Skewness:-0.05Maximum124370.89Coefficient of Variation:6.47%Kurtosis:-0.81(+/-)4245.439Analysis Notes (editable space below for your notes):STD DEV'sfromMEAN0123456020000400006000080000100000120000140000160000Column WMeanPlus 2 Std DevMinus 2 Std DevDistribution of Data Pointsaround the Mean
Symmetric ApproximationFor Shape: enter B for Right Beta, T for Triangular, U for Uniform,Triangular, Right Beta, UniformNormal DistributionDiscrete DistributionCost ElementLowMost LikelyHighMeanStd DevValue 1Prob 1Value 2Prob 2Value 3Prob 31Material142500020000002Mat O/H712501000003Fabrication64890099960016002004Assembly/QC1325100178500024150005Mfg. O/H3651900515151074281206

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 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Standard Deviation, Working Capital, contracting officer

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture