In the United Copiers service center model, we assumed that the potential locations of service centers are the same as existing customer locations. Change the model so that the customer locations are the ones given, but the only potential service center locations are in Memphis, Houston, Cleveland, Buffalo, Minneapolis, St. Louis, and Kansas City. You can look up the distances from these cities to the customer cities on the Web, or you can make up approximate distances. Use Solver to find the optimal solution.

Distances between cities BuffaloCleveland Houston Kansas City Memphis Minneapolis Saint Louis 1193 297 630 851 1826 1216 953 1457 602 2056 2086 458 532 1366 1521 2532 1384 373 2198 215 2648 2601 640 343 1182 1333 2344 1242 463 463 134 2460 2413 1849 1082 239 1029 1548 1187 1628 1176 1336 1929 2343 1433 510 506 605 1618 1462 1193 1207 842 1807 1837 1318 532 453 1096 1793 1044 1097 1424 769 2091 2287 1396 408 939 915 1926 1789 1202 1342 1642 1964 1656 Boston Chicago Dallas Denver Los Angeles Miami 1 3 New York Phoenix Pittsburgh San Franciscc Seattle 5 6 Distances between cities BuffaloCleveland Houston Kansas City Memphis Minneapolis Saint Louis 1193 297 630 851 1826 1216 953 1457 602 2056 2086 458 532 1366 1521 2532 1384 373 2198 215 2648 2601 640 343 1182 1333 2344 1242 463 463 134 2460 2413 1849 1082 239 1029 1548 1187 1628 1176 1336 1929 2343 1433 510 506 605 1618 1462 1193 1207 842 1807 1837 1318 532 453 1096 1793 1044 1097 1424 769 2091 2287 1396 408 939 915 1926 1789 1202 1342 1642 1964 1656 Boston Chicago Dallas Denver Los Angeles Miami 1 3 New York Phoenix Pittsburgh San Franciscc Seattle 5 6