Question

Please fulfill the following tasks:

1.   Find the best location for a central warehouse (CW) in each region using the center of gravity method based on the data given below (using longitude and latitude of each regional WH location.

Demand as per sales in each region
EU North		EU West		EU South		North America		South America
Location	Demand*	Location	Demand*	Location	Demand*	Location	Demand*	Location	Demand*
Copenhagen	50%	Venlo	40%	Pozman	50%	Cincinatti	40%	Riberao Preto	40%
Linkoping	50%	Mannheim	20%	Prague	50%	Charlotte	30%	Brasilia	30%
		Paris	40%			Memphis	30%	Curitiba	30%

*in % of total sales per region

Answer 1

EU North
Location	Demand*	X	Y
Copenhagen	50%	55.676	12.568
Linkoping	50%	58.411	15.621
	CW location -->	57.043	14.095
EU West
Location	Demand*	X	Y
Venlo	40%	51.373	6.173
Mannheim	20%	49.487	8.466
Paris	40%	48.857	2.352
	CW location -->	49.989	5.103
EU South
Location	Demand*	X	Y
Pozman	50%	52.406	16.925
Prague	50%	50.076	14.438
	CW location -->	51.241	15.682
North America
Location	Demand*	X	Y
Cincinatti	40%	39.103	84.512
Charlotte	30%	35.227	80.843
Memphis	30%	35.150	90.049
	CW location -->	36.754	85.072
South America
Location	Demand*	X	Y
Riberao Preto	40%	21.170	47.810
Brasilia	30%	15.827	47.922
Curitiba	30%	25.429	49.267
	CW location -->	20.845	48.281