A B C D E F G H Name Box Steel Appliances ( x-x) 12 (y-y) 12 (G+H)^.5 N W Factory/ $/Mile Coordinates Distances Customer Fn xn yn (miles) Factory 1 0.9 700 1200 5774.561081 78573.24663 290.4269404 0.95 250 600 276666.0406 102202.2087 615.5227448 3 0.85 225 825 303590.5673 8966.347932 559.0678986 8 Customers A 1.5 600 500 30972.66765 176140.3691 455.0967334 9 B 1.5 1050 1200 75081.18809 78573.24663 391.9877992 10 C 1.5 800 300 576.4545133 384016.6897 620.1557419 11 D 1.5 925 975 22203.8213 3059.107413 158.9431619 12 F 1.5 1000 1080 50180.24138 25699.03905 275.4619401 13 14 Facility Location 15 16 X = 775.9905 17 y= 919.6908 18 19 Cost = 3366.663 20 21 Remark 1: Highlighted cells are looking for inputs 22 23 24 25A B C D E F G H Name Box Steel Appliances ( x-x) 12 (y-y) 12 (G+H)^.5 N W Factory/ $/Mile Coordinates Distances Customer Fn xn yn (miles) Factory 1 0.9 700 1200 5774.561081 78573.24663 290.4269404 0.95 250 600 276666.0406 102202.2087 615.5227448 3 0.85 225 825 303590.5673 8966.347932 559.0678986 8 Customers A 1.5 600 500 30972.66765 176140.3691 455.0967334 9 B 1.5 1050 1200 75081.18809 78573.24663 391.9877992 10 C 1.5 800 300 576.4545133 384016.6897 620.1557419 11 D 1.5 925 975 22203.8213 3059.107413 158.9431619 12 F 1.5 1000 1080 50180.24138 25699.03905 275.4619401 13 14 Facility Location 15 16 X = 775.9905 17 y= 919.6908 18 19 Cost = 3366.663 20 21 Remark 1: Highlighted cells are looking for inputs 22 23 24 25