Warehousing and Distribution management
Sheet1
| Questions: Q1) In case the Rectilinear distance is considered, find the optimal coordinates (X,Y) of new facility. Q2) Show and label the existing locations and the optimal location of new facility on a scatter chart. | |||||
| Full Name Member 1: | |||||
| Full Name Member 2: | |||||
| Full Name Member 3: | |||||
| Existing Facility | Annual Demand in tons (Di) | Annual Cost per mile per ton ($) | Coordinate location of each facility | x-coordinate | y-coordinate |
| A | 250 | 25 | (40,20) | ||
| B | 440 | 10 | (50,25) | ||
| C | 380 | 25 | (70,65) | ||
| D | 290 | 15 | (25,65) | ||
| Optimal x | |||||
| Optimal y |
Xi
Yi