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

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

Three Point Roll UpLow Obj.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 INPUT1 110,120.00 -1.292 120,950.00 0.113 112,250.00 -1.014 119,980.00 -0.025 131,870.00 1.516 119,360.00 -0.107 128,000.00 1.018 108,100.00 -1.559 120,890.00 0.1010 119,990.00 -0.0211 129,870.00 1.25121314151617181920212223242526272829Descriptive Statistics303132Count:11 Mean:120125.45Enter Confidence Level:90.0%3334Minimum:108,100.00 Median:119990.00Minimum115880.023536Maximum:131,870.00 Mode:#VALUE!Mean120125.453738Standard Deviation:7,768.73 Skewness:-0.05Maximum124370.893940Coefficient of Variation:6.47%Kurtosis:-0.81(+/-)4245.43941424344454647484950STD DEV's from MEAN012345620000400006000080000100000120000140000160000Distribution of Data Points around 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.402916103.836 1240907.27

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture