Location Planning & Analysis

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

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

$x=$

$y=$

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

$x=$

$y=$

$\backslash$table$[[,,$Location$],[$Distance from Headquarters $($Miles$),$Weight,A$,$B$,$C$],[$Facility Rent, Insurance, etc. $($$$),0\mathrm{.}1,60,98,19],[$Labor Cost $($$$),0\mathrm{.}3,29,17,30],[$Tax Rate $($$$),0\mathrm{.}1,54,93,33],[$Proximity to Airport $($Miles$),0\mathrm{.}1,48,27,47]]$

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