SCM3202 Topic 6 Assignment
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) |
City |
Latitude |
Longitude |
Tonnes |
€/tonne-km |
|
S1 |
Berlin |
52.51 |
13.39 |
3,400 |
3.00 |
|
M1 |
Hamburg |
53.68 |
10.03 |
2,000 |
3.50 |
|
M2 |
Bremen |
53.31 |
9.19 |
550 |
2.00 |
|
M3 |
Hanover |
52.59 |
9.99 |
500 |
2.00 |
|
M4 |
Leipzig |
51.49 |
12.56 |
500 |
2.00 |
|
M5 |
Dresden |
51.23 |
14.09 |
500 |
2.00 |
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 |
|
S1 |
||||
|
|
|
|
Total |
|
|
|
||||
|
Rate |
Latitude |
Weight |
||
|
€/tonne-km |
y-coordinate |
Tonnes |
||
|
Market |
R |
D |
M |
RM RDM |
|
M1 |
||||
|
M2 |
||||
|
M3 |
||||
|
M4 |
||||
|
M5 |
||||
|
Latitude |
of COG = |
|
Total |
|
|
|
||||
|
Rate |
Longitude |
Weight |
||
|
€/tonne-km |
x-coordinate |
Tonnes |
||
|
Source |
r |
d |
s |
rs rds |
|
S1 |
||||
|
|
|
|
Total |
|
|
|
||||
|
Rate |
Longitude |
Weight |
||
|
€/tonne-km |
x-coordinate |
Tonnes |
||
|
Market |
R |
D |
M |
RM RDM |
|
M1 |
||||
|
M2 |
||||
|
M3 |
||||
|
M4 |
||||
|
M5 |
||||
Total ·
Longitude of COG =
版权所有：编程辅导网 2021 All Rights Reserved 联系方式：QQ:99515681 微信：codinghelp 电子信箱：99515681@qq.com
免责声明：本站部分内容从网络整理而来，只供参考！如有版权问题可联系本站删除。
