Assignment$-2$: Location analysis

Solve the following problem using excel and evaluate the result.

A Fan Manufacturing Company $($FMC$)$ is considering expansion and evaluating where to

locate a new manufacturing plant. The FMC will handle $900$ items of its production to a

main customer at coordinates $(5,10)$ and $600$ items to a second major customer at $,$

$.$ Six plant locations are under consideration:

$A(17,14),B(11,17),C(16,22),D(12,21),E(14,24),F(19,15)$

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 two more plant locations

$G(23,17)$ and $H(12,14)$ and evaluate the result again.