A carpet manufacturer is interested in locating a plant so as to minimize total distance traveled to four distribution centers The xy coordinates of the four distribution centers are found in the Prob 1 worksheet The maximum distance any distribution center should be away from the plant is 30 miles Create a spreadsheet model that allows the user to find the optimal plant location using the straight line distance from the plant to the distribution centers