Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Andean Coal requires locating a new plant to minimize the cost of transportation of the finished product. The new customers are located at the following
Andean Coal requires locating a new plant to minimize the cost of transportation of the finished product. The new customers are located at the following coordinates: C1 = (3, 9), C2 = (6, 3), C3 = (2, 7), C4 = (8, 2), and C5 = (4, 5) . It is known that the cost per unit distance traveled is the same between the new plant and each of the new customers. Additionally, it is projected that the monthly trips between the new plant and the new clients will be respectively: 3, 3, 2, 1 and 1. Using the technique of locating a rectilinear plant, carry out the following: 1- Position each new client in the plane X, Y with their respective weights. 2-Determine the solution for the x coordinate. 3- Determine the solution for the y-coordinate. 4- Locate the optimal location on an X,Y plane where you also show the points from part 1. 5- Determine the total weighted distance from the optimal location. 6- Determine the solution for the coordinates (x, y) by means of a model in SOLVER of Excel. 7- Locate the optimal location found at point 6 on an X,Y plane where the points from part 4 are also shown. 8-Use the model created at point 6 to determine four more points that satisfy the minimum distance weighted total that is in point 5 and place them in an X, Y plane where you also show the points in part 7. Express your conclusions about it. 9- Due to the environmental impact of the coal industry, there are three zones authorized by the Chilean government to locate the new Carbon Andino plant. They meet at A1 = (3, 1), A2 = (5, 8), A3 = (7, 6). If the optimal location found in point 4 does not coincide with any of the industrial zones, in which of these zones should the new plant be located? Use the model created in part 6 to justify your answer, and locate the point on an X,Y plane where you also show the points in part 8.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started