(CIS331 -SystmMdlngThry) ch10

(CIS331 -SystmMdlngThry) ch10 - Location Problem Revisited...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Location Problem Revisited Decisions x y Location 107.985 37.615 Result Sum 11,390.0 Data Weighted Site x y n x-dist y-dist Distance 1 5 41 12-102.985 3.385 1236.484 2 20 10 20-87.985-27.615 1844.332 3 44 48 15-63.985 10.385 972.330 4 60 58 27-47.985 20.385 1407.650 5 100 4 8-7.985-33.615 276.403 6 138 80 16 30.015 42.385 830.984 7 150 40 10 42.015 2.385 420.829 8 170 18 18 62.015-19.615 1170.782 9 182 2 25 74.015-35.615 2053.457 10 190 56 14 82.015 18.385 1176.709 x y (a) Optimal solution is 107.98 37.62 (b) Objective function is 11,390.0 Location Problem with Two Sites Decisions X Y Dist 1 42.96 48.79 Dist 2 158.00 38.54 Objective Total Weighted Score 7999.50 Data Coordinates Trips Site x y n Dist 1 Dist 2 Min Score 1 2 96 21 62.5 166.2 62.5 1312.5 2 5 41 12 38.7 153.0 38.7 465.0 3 20 10 20 45.1 140.9 45.1 901.5 4 44 48 15 1.3 114.4 1.3 19.7 5 60 58 27 19.4 99.9 19.4 523.0 6 100 4 8 72.5 67.5 67.5 540.0 7 122 94 21 91.1 66.1 66.1 1388.6 8 138 80 16 100.0 46.0 46.0 736.5 9 150 40 10 107.4 8.1 8.1 81.3 10 170 18 18 130.7 23.8 23.8 428.2 11 182 2 25 146.7 43.7 43.7 1092.9 12 190 56 14 147.2 36.5 36.5 510.4 (a) Optimal DC Locations: X Y Dist 1 42.96 48.79 Dist 2 158.00 38.54 (b) Optimal Objective Function: 7999.50 Cost Modeling Check using Excel's Regression Tool (a) Decisions a 635.975 SUMMARY OUTPUT & Objective b 0.387165 1,044,323 Regression Statistics Data Day Output Cost Model Difference Sq. Difference Multiple R 0.924816628 1 5,045 2,542 2589.2-47.2 2,230 R Square 0.855285796 2 6,127 2,812 3008.1-196.1 38,469 Adjusted R Square 0.83719652 3 6,360 2,776 3098.3-322.3 103,906 Standard Error 361.3036745 4 6,645 3,164 3208.7-44.7 1,997 Observations 10 5 7,220 4,102 3431.3 670.7 449,830 6 9,537 4,734 4328.4 405.6 164,538 ANOVA 7 9,895 4,238 4467.0-229.0 52,428 df SS MS F Significance F 8 10,175 4,524 4575.4-51.4 2,640 Regression 1 6172126.8382 6172126.838 47.28137364 0.000127566 9 10,334 4,869 4636.9 232.1 53,853 Residual 8 1044322.761811 130540.3452 10 10,855 4,421 4838.7-417.7 174,432 Total 9 7216449.6 Best model is roughly Cost = 636 + 0.387*(Output) Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Parameters: 635.975 Intercept 635.97454635 476.68703413 1.334155328 0.218880801 -463.268436 1735.217529 -463.268436 1735.217529 0.387164 Output 0.3871650206 0.0563055325 6.87614526 0.000127566 0.257324146 0.517005895 0.257324146 0.517005895 Minimum sum of squared differences is 1,044,323 4,000 5,000 6,000 7,000 8,000 9,000 10,000 11,000 12,000 1,000 2,000 3,000 4,000 5,000 6,000 f(x) = 0.3871650206x + 635.9745463519 R = 0.8552857957 Daily Output Daily Production Cost Cost Modeling Decisions a 592.840 & Objective b 0.386355 2,429.21 Data Day Output Cost Model Difference Abs. Diff....
View Full Document

Page1 / 23

(CIS331 -SystmMdlngThry) ch10 - Location Problem Revisited...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online