Lafferty - Customer 1 5 10 200 Customer 2 10 5 150 Customer...

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

View Full Document Right Arrow Icon
X-coordinate-coordinate Annual shipments Customer 1 5 10 200 Customer 2 10 5 150 Customer 3 0 12 200 Customer 4 12 0 300 WAREHOUSE LOCATION MODEL The Lafferty Company wants to locate a warehouse from which it will ship products to four costomers. The location (in the x-y plane) of the four customers and the number of shipments per year needed by each customer are given in the table below. (All locations are in miles, relative to the point x=0 and y=0). A single warehouse must be used to servise all of the customers. Latterty wants to determine the location of the warehouse that minimizes the total distance traveled from the warehouse to the customers.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exhibit 16 Lafferty facility location model Customer data X-coordinate Y-coordinate Annual shipments
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Customer 1 5 10 200 Customer 2 10 5 150 Customer 3 12 200 Customer 4 12 300 Warehouse location X-coordinate Y-coordinate 21.290 23.487 Customer distances from warehouse Customer 1 21.149 Customer 2 21.662 Customer 3 24.192 Customer 4 25.258 Total annual distance 19894.793 Testing optimality Is this solution optimal? Test it yourself. Click on the left button to generate a "random" set of starting values for the changing cells. Then click on the right button to run Solver. Does it always take you to the same solution? Range names used: Shipments - E5:E8 Location - B11:C11 Distances - B14:B17 TotDistance - B19 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27...
View Full Document

This note was uploaded on 05/31/2009 for the course MBA 4500 taught by Professor Eyupcetin during the Spring '09 term at Istanbul Technical University.

Page1 / 2

Lafferty - Customer 1 5 10 200 Customer 2 10 5 150 Customer...

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

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