Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management

Authors: Richard L. Lynch

6th Edition

978-0273750925

More Books

Students also viewed these General Management questions

Question

=+10. What are the objectives of sales promotion? Why is it needed?

Answered: 1 week ago