Week 2 Integrating Case - INSTRUCTOR Template (1).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.HighMaterial000Material O/H000Fabrication000Assembly/QC000Mfg. O/H000Eng. Labor000Eng. O/H000ODC000Subtotal Cost000G&A000Total Cost000Material and Eng. objectives are avg of high and lowCeiling %=High Position/Objective16,752,248/12,367,402=#DIV/0!Rounds to135%
$-
Enter File Name Here#DATA INPUT1234567891011121314151617181920212223242526272829Descriptive Statistics303132Count:-Mean:#DIV/0!Enter Confidence Level:90.0%3334Minimum:-Median:#VALUE!Minimum#DIV/0!3536Maximum:-Mode:#VALUE!Mean#DIV/0!3738Standard Deviation:#DIV/0!Skewness:Err:502Maximum#DIV/0!3940Coefficient of Variation:#DIV/0!Kurtosis:#DIV/0!(+/-)Err:50241424344454647484950STD DEV'sfrom MEAN00.10.20.30.40.50.60.70.80.91024681012Column 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, D for Discrete, N for NormalTriangular, Right Beta, UniformNormal DistributionDiscrete DistributionCost ElementLowMost LikelyHighMeanStd DevValue 1Prob 1Value 2Prob 2Value 3Prob 3ShapeMeanVariance1MATERIAL14250002000000U1712500275520833332MAT'L O/H71250100000U85625688802083FABRICATION6489009996001600200T1082900385745150004ASSEMBLY/QC132510017850002415000T1841700498969450005MFG O/H365190051515107428120T54105106025450203506ENGINEERING LBR6001000.508194000.50D709750120231225007ENG O/H7501250.5010242500.50D887188187861289068ODC1201267769

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
Summer
Professor
Tony Stout
Tags
Standard Deviation, Variance, Probability theory, target price

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture