Integrating Case_Wei C_Percy J_Shasta B_Tony C_Ranae A_Micah D_V2.xlsx

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

The preview shows page 6 - 8 out of 14 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,700819,400 Used the ODC chart to getEng. O/H750,125887,1251,024,250ODC115,880120,125124,371Subtotal Cost8,588,25511,451,18515,511,341G&A687,060916,0951,240,907Total Cost9,275,31512,367,28016,752,2483,494,300 Labor for Frabrication, Assembly QC and Engin6,124,260 Indirect material OH, MFG OH and Eng OH
median for the objective priceneer Labor
Enter File Nam#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:3334Minimum:108,100.00Median:35STD DEV'sfrom MEAN0123456
36Maximum:131,870.00Mode:3738Standard 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-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 TrianguTriangular, Right Beta, UniformNormal DistributionDiscrete DistributionCost ElementLowMost LikelyHighMeanStd DevValue 1Prob 1Value 2Prob 21Material1425000171250020000002Material OH71250856251000003Fabrication64890099960016002004Assembly/QC1325100178500024150005MFG OH3651900515151074281256Engineering Labor6000000.508194000.507Engineering OH7501250.5010242500.50

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

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Management Concepts
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture