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

• 7
• 100% (2) 2 out of 2 people found this document helpful

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

Three Point Roll Up Low Obj. High Material 1,425,000 1,712,500 2,000,000 Material O/H 71,250 85,625 100,000 Fabrication 648,900 999,600 1,600,200 Assembly/QC 1,325,100 1,785,000 2,415,000 Mfg. O/H 3,651,900 5,151,510 7,428,120 Eng. Labor 600,100 709,750 819,400 Eng. O/H 750,125 887,188 1,024,250 ODC 115,880 120,125 124,371 Subtotal Cost 8,588,255 11,451,298 15,511,341 G&A 687,060 916,104 1,240,907 Total Cost 9,275,315 12,367,401 16,752,248 3,494,350 6,124,323
1.3545487749
Enter File Name Here DATA INPUT 110,120.00 -1.29 120,950.00 0.11 112,250.00 -1.01 119,980.00 -0.02 131,870.00 1.51 119,360.00 -0.10 128,000.00 1.01 108,100.00 -1.55 120,890.00 0.10 119,990.00 -0.02 129,870.00 1.25 Descriptive Statistics Count: 11 Mean: 120125.45 Enter Confidence Level: 90.0% Minimum: 108,100.00 Median: 119990.00 Minimum 115880.02 Maximum: 131,870.00 Mode: #VALUE! Mean 120125.45 Standard Deviation: 7,768.73 Skewness: -0.05 Maximum 124370.89 Coefficient of Variation: 6.47% Kurtosis: -0.81 (+/-) 4245.439 Analysis Notes (editable space below for your notes): STD DEV's from MEAN 0 1 2 3 4 5 6 0 20000 40000 60000 80000 100000 120000 140000 160000 Column W Mean Plus 2 Std Dev Minus 2 Std Dev Distribution of Data Points around the Mean
Symmetric Approximation For Shape: enter B for Right Beta, T for Triangular, U for Uniform, Triangular, Right Beta, Uniform Normal Distribution Discrete Distribution Cost Element Low Most Likely High Mean Std Dev Value 1 Prob 1 Value 2 Prob 2 Value 3 Prob 3 1 Material 1425000 2000000 2 Mat O/H 71250 100000 3 Fabrication 648900 999600 1600200 4 Assembly/QC 1325100 1785000 2415000 5 Mfg. O/H 3651900 5151510 7428120 6 Eng. Labor