Question: Solve the following problem using excel and evaluate the result. ( Location Analysis ) A Modern Manufacturing Company ( MMC ) is considering expansion and

Solve the following problem using excel and evaluate the result. (Location Analysis)
A Modern Manufacturing Company (MMC) is considering expansion and evaluating where
to locate a new manufacturing plant. The MMC will handle 300 items of its production to a
main customer at coordinates (5,10) and 200 items to a second major customer at (13,
. Five plant locations are under consideration:
A(7,4),B(11,17),C(18,13),D(30,20),E(32,24)
If we use rectilinear distance, which location will minimize total load-distance for MMC?
Moreover, on the second sheet of excel file (in same file), add one more plant location
F(33,17) and evaluate the result again.
 Solve the following problem using excel and evaluate the result. (Location

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 Databases Questions!