All calculations must be executed via MS Excel formulas. Submit both the MS Word and MS Excel files.

x

yy

x

Using the center of gravity method, identify the centralized location.

x$=$ y$=$

Using the weighted center of gravity method, identify the centralized location.$12345678910$

$12345678910$

$6$

$11$

$12$

$9$

$10$

$14$

$17$x$=$ y$=$

Distance from Centralized Location Facility Rent, Insurance, etc. $($$$)$ Labor Cost $($$$)$

$0\mathrm{.}630\mathrm{.}310\mathrm{.}17$

$1068977$

Using the weighted factor method, what is the optimal location, A$,$ B or C$?$ Why?