Please use any outside source (eg standard cargo price, fuel price etc.) to determine the Cost of Goods and expenses.

Then use Central of Gravity method to determine the optimal location for both regions to ship effectively.

Please show excel and complete work.

APPENDIX ONE International Customer Locations City Busan, South Korea Guangzhou, China Ningbo-Zhoushan, China Shenzhen, China Singapore Annual Freight Volume (kgs) 500,000 750,000 2,000,000 250,000 1,000,000 Annual Revenue (d) 1,000,000 1,500,000 4,000,000 500,000 2,000,000 Annual Profit (d) 60,000 90,000 240,000 30,000 120,000 City Lagos, Nigeria Beira, Mozambique Dar Es Salaam, Tanzania Mombasa, Kenya Durban, South Africa Annual Freight Volume (kgs) 500,000 1,000,000 750,000 2,000,000 250,000 Annual Revenue ($) $1,000,000 $2,000,00 $1,500,000 $4,000,000 $500,000 Annual Profit ($) $60,000 $120,000 $90,000 $240,000 $30,000 APPENDIX ONE International Customer Locations City Busan, South Korea Guangzhou, China Ningbo-Zhoushan, China Shenzhen, China Singapore Annual Freight Volume (kgs) 500,000 750,000 2,000,000 250,000 1,000,000 Annual Revenue (d) 1,000,000 1,500,000 4,000,000 500,000 2,000,000 Annual Profit (d) 60,000 90,000 240,000 30,000 120,000 City Lagos, Nigeria Beira, Mozambique Dar Es Salaam, Tanzania Mombasa, Kenya Durban, South Africa Annual Freight Volume (kgs) 500,000 1,000,000 750,000 2,000,000 250,000 Annual Revenue ($) $1,000,000 $2,000,00 $1,500,000 $4,000,000 $500,000 Annual Profit ($) $60,000 $120,000 $90,000 $240,000 $30,000