Team 2 Week 2 Integrating Case - STUDENT (Autosaved).xlsx -...

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

The preview shows page 3 - 5 out of 8 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,40216,752,248135%
Enter File Name Here#DATA INPUT1110,120.00-1.292120,950.000.113112,250.00-1.014119,980.00-0.025131,870.001.516119,360.00-0.107128,000.001.018108,100.00-1.559120,890.000.1010119,990.00-0.0211129,870.001.25121314151617181920212223242526272829Descriptive Statistics303132Count:11Mean:120125.45Enter Confidence Level:90.0%3334Minimum:108,100.00Median:119990.00Minimum115880.023536Maximum:131,870.00Mode:#VALUE!Mean120125.453738Standard Deviation:7,768.73Skewness:-0.05Maximum124370.893940Coefficient of Variation:6.47%Kurtosis:-0.81(+/-)4245.43941424344454647484950STD DEV'sfrom MEAN012345620000400006000080000100000120000140000160000Distribution of Data Pointsaround the Mean
0Column WMeanPlus 2 Std DevMinus 2 Std Dev
Symmetric ApproximationFor Shape: enter B for Right Beta, T for Triangular, U for Uniform, D for Discrete, N for NormalTriangular, Right Beta, UniformNormal DistributionDiscrete DistributionCost ElementLowMost LikelyHighMeanStd DevValue 1Prob 1Value 2Prob 2Value 3Prob 3ShapeMeanVariance1Material142500017125002000000u1712500275520833332Material O/H7125085625100000u85625688802083Fabrication6489009996001600200t1082900385745150004Assembly/QC132510017850002415000t1841700498969450005Mfg. O/H365190051515107428120t54105106025450203506Eng. Labor6001000.508194000.50d709750120231225007Eng. O/H7501250.5010242500.50d887188187861289068ODC120125.457768.73n120125603531669G&A687060.402

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

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Standard Deviation, Variance, Probability theory, target price

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture