A furniture manufacturer has recently discovered a new market in the US and wants to set up
Fantastic news! We've Found the answer you've been seeking!
Question:
A furniture manufacturer has recently discovered a new market in the US and wants to set up a factory near his suppliers and retailers. The coordinate location, the demand in each market, the required supply from each provider, and the shipping cost for each supply source or market (per ton per mile) are: What should be the coordinates of the new plant? Solve details by Excel
Sources / Markets | S/ Ton Mile Fn | Tons Dn | Coordinates | ||
Xn | Yn | ||||
Sources | Buffalo | 1.90 | 600 | 750 | 1200 |
Virgina | 2.25 | 850 | 200 | 1000 | |
Memphis | 1.45 | 350 | 120 | 800 | |
St. Louis | 3.25 | 800 | 225 | 700 | |
Markets | Atlanta | 2.25 | 550 | 750 | 500 |
Boston | 2.50 | 350 | 425 | 1200 | |
Jacksonville | 1.75 | 250 | 600 | 300 | |
Philadelphia | 1.85 | 275 | 925 | 175 | |
New York | 3.50 | 300 | 800 | 1100 |
Related Book For
Posted Date: