SCM$3202$ Topic $6$ Assignment

Student name: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Student ID#: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

A Chinese company wants to set up a manufacturing plant in Germany that purchases raw material from a supplier in Berlin and deliver finished goods to customers in five markets including Hamburg, Bremen, Hanover, Leipzig, and Dresden. The freight rates, weight of raw material and finished goods to be transported, and latitude and longitude of the source and markets are shown in the following table.

Source $($S$)/$ Market $($M$)$ S$1$

M$1$

M$2$

M$3$

M$4$

M$5$

City Berlin Hamburg Bremen Hanover Leipzig Dresden

Latitude $52\mathrm{.}5153\mathrm{.}6853\mathrm{.}3152\mathrm{.}5951\mathrm{.}4951\mathrm{.}23$

Longitude Tonnes

$13\mathrm{.}393,4003\mathrm{.}0010\mathrm{.}032,0003\mathrm{.}50$

$9\mathrm{.}195502\mathrm{.}00$

$9\mathrm{.}995002\mathrm{.}0012\mathrm{.}565002\mathrm{.}0014\mathrm{.}095002\mathrm{.}00$

$/$tonne$-$km

Note: The tonne is a metric unit of mass equal to $1,000$ kilograms. It is also referred to as a metric ton.

Use the Center$-$of$-$Gravity $($COG$)$ method to determine the least$-$cost location for the plant location. Round the answer of latitude and longitude of COG to $2$ decimal places.

You can apply the following formula and templates to perform the calculation.

Rate Latitude Weight $/$tonne$-$km y$-$coordinate Tonnes

Source r d s rs rds S$1$

Total

Rate Latitude Weight $/$tonne$-$km y$-$coordinate Tonnes

Market R D M RM RDM M$1$

M$2$

M$3$

M$4$ M$5$

Latitude of COG $=$

Rate Longitude $/$tonne$-$km x$-$coordinate

Rate Longitude Weight $/$tonne$-$km x$-$coordinate Tonnes

Total

Weight

Tonnes

Source r d s rs rds

S$1$

Market R D M RM RDM M$1$

M$2$

M$3$

Total

M$4$ M$5$

Longitude of COG $=$

Total