Question: I need to know the work behind these answers. (Excel equations will do fine) Rauschenberg Manufacturing is investigating which locations would best position its new

I need to know the work behind these answers.I need to know the work behind these answers. (Excel equations will do fine)

Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location A B C Coordinates (miles) (300,100) (300,200) (300,300) Deliveries per day 4 5 2 a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location B yields the smallest load-distance score of 600.0 (Enter your response rounded to one decimal place.) b. Which of these locations is best, based on rectilinear distances? Location B is the best, yielding a load-distance score of 600 (Enter your response as a whole number.) c. What are the coordinates of the center of gravity? The center of gravity is x = 300.0 miles, y = 181.8 miles. (Enter your responses rounded to one decimal place.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!