Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As logistics manager of Finn you are introducing central warehouse facilities that will supply regional warehouses in each (sales) region in order to lower the

image text in transcribedimage text in transcribed

As logistics manager of Finn you are introducing central warehouse facilities that will supply regional warehouses in each (sales) region in order to lower the inventory (cost) and improve the delivery service to the customers. You also must make suggestions for an inbound transport budget (supplier to central warehouse facility). 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.

2. Calculate the amount of inventory that needs to be kept assuming a safety stock of 10 days of supply plus an average cycle stock that equals 1,5 times the replenishment time (transport time from vendor to central warehouse). Find out port-to-port lead times on searates.

3. Based on the data given in subsection 2 (Procurement) and the data given below calculate the volume of cargo that needs to be moved from any point of origin to any point of destination (in no. containers/trucks) and the total budget for transport needed. 4. How much groundspace is needed for each warehouse assuming block storing of pallets?

5) Lecture: Global Sourcing & Logistics Part: Logistics Management (17 points) As logistics manager of Finn you are introducing central warehouse facilities that will supply regional warehouses in each (sales) region in order to lower the inventory (cost) and improve the delivery service to the customers. You also must make suggestions for an inbound transport budget (supplier to central warehouse facility). 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. 2. Calculate the amount of inventory that needs to be kept assuming a safety stock of 10 days of supply plus an average cycle stock that equals 1,5 times the replenishment time transport time from vendor to central warehouse). Find out port-to-port lead times on Find distances at Seaport 3. Based on the data given in subsection 2 (Procurement) and the data given below calculate the volume of cargo that needs to be moved from any point of origin to any point of destination (in no. containers/trucks) and the total budget for transport needed. 4. How much groundspace is needed for each warehouse assuming block storing of pallets? The following data is given: Pallet weight: 650 kg/ per pallet; pallet size: 1,20 x 0,80 m; 30 pallets fit into a container or a truck Demand as per sales in each region EU North EU West EU East EU South North America South America location demand location demand" location demand location demand location demand location demand" Copenhagen 50% Venlo 40% Poznan 50% Bologna 40% cincinatti 40% Riberao Preto 40% Linkping 50% Mannheim 20% Prarue 50% Lyon Charlotte 3096 Brasilia 30% Paris 40% Zagreb 2096 Memphis 3096 Curitiba 3096 in % of total sales per region Ingredients Ingredients Vendor Departure Logistics costs at Trucking time departure (days) vendor- Mix Country Port trucking Port handling port to port per container Hazel 15,00% Turkey Istanbul $110,00 $70,00 1 Macadamia 15,00% Australia Melbourne $280,00 $95,00 2 Cashew 15,00% West Africa Accra $70,00 $45,00 2 Raisins 20,00% Turkey Istanbul $110,00 $70,00 2 Cranberries 20,00% USA Oakland $220,00 $110,00 2 Chocolate 5,00% USA Oakland $220,00 $110,00 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 4096 N Receiving ports per (Sales) Region trucking time (days) port-cw 1 Logistics costs at destination Port handling per trucking port- container central WH $130,00 $160,00 $120,00 $160,00 $120,00 $160,00 $90,00 $120,00 $110,00 $220,00 $90,00 $140,00 1 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 1 2 2 Freight rates Melbourne Accra Istanbul Oakland Puerto Limon Hamburg $2.500,00 $3.100,00 $2.500,00 $2.400,00 $1.900,00 Sea freight per 40' Container (in $) to Rotterdam Genova New York $2.400,00 $1.900,00 $2.600,00 $3.000,00 $2.900,00 $3.400,00 $2.400,00 $1.200,00 $2.100,00 $2.200,00 $2.400,00 $1.800,00 $1.900,00 $2.000,00 $1.500,00 Santos $2.600,00 $2.500,00 $2.300,00 $2.000,00 $1.800,00 lead times sea freight Rotterdam Genova Hamburg New York Santos ? ? ? Lead times port-to-port Melbourne Accra Istanbul Oakland Puerto Limon ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 5) Lecture: Global Sourcing & Logistics Part: Logistics Management (17 points) As logistics manager of Finn you are introducing central warehouse facilities that will supply regional warehouses in each (sales) region in order to lower the inventory (cost) and improve the delivery service to the customers. You also must make suggestions for an inbound transport budget (supplier to central warehouse facility). 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. 2. Calculate the amount of inventory that needs to be kept assuming a safety stock of 10 days of supply plus an average cycle stock that equals 1,5 times the replenishment time transport time from vendor to central warehouse). Find out port-to-port lead times on Find distances at Seaport 3. Based on the data given in subsection 2 (Procurement) and the data given below calculate the volume of cargo that needs to be moved from any point of origin to any point of destination (in no. containers/trucks) and the total budget for transport needed. 4. How much groundspace is needed for each warehouse assuming block storing of pallets? The following data is given: Pallet weight: 650 kg/ per pallet; pallet size: 1,20 x 0,80 m; 30 pallets fit into a container or a truck Demand as per sales in each region EU North EU West EU East EU South North America South America location demand location demand" location demand location demand location demand location demand" Copenhagen 50% Venlo 40% Poznan 50% Bologna 40% cincinatti 40% Riberao Preto 40% Linkping 50% Mannheim 20% Prarue 50% Lyon Charlotte 3096 Brasilia 30% Paris 40% Zagreb 2096 Memphis 3096 Curitiba 3096 in % of total sales per region Ingredients Ingredients Vendor Departure Logistics costs at Trucking time departure (days) vendor- Mix Country Port trucking Port handling port to port per container Hazel 15,00% Turkey Istanbul $110,00 $70,00 1 Macadamia 15,00% Australia Melbourne $280,00 $95,00 2 Cashew 15,00% West Africa Accra $70,00 $45,00 2 Raisins 20,00% Turkey Istanbul $110,00 $70,00 2 Cranberries 20,00% USA Oakland $220,00 $110,00 2 Chocolate 5,00% USA Oakland $220,00 $110,00 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 4096 N Receiving ports per (Sales) Region trucking time (days) port-cw 1 Logistics costs at destination Port handling per trucking port- container central WH $130,00 $160,00 $120,00 $160,00 $120,00 $160,00 $90,00 $120,00 $110,00 $220,00 $90,00 $140,00 1 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 1 2 2 Freight rates Melbourne Accra Istanbul Oakland Puerto Limon Hamburg $2.500,00 $3.100,00 $2.500,00 $2.400,00 $1.900,00 Sea freight per 40' Container (in $) to Rotterdam Genova New York $2.400,00 $1.900,00 $2.600,00 $3.000,00 $2.900,00 $3.400,00 $2.400,00 $1.200,00 $2.100,00 $2.200,00 $2.400,00 $1.800,00 $1.900,00 $2.000,00 $1.500,00 Santos $2.600,00 $2.500,00 $2.300,00 $2.000,00 $1.800,00 lead times sea freight Rotterdam Genova Hamburg New York Santos ? ? ? Lead times port-to-port Melbourne Accra Istanbul Oakland Puerto Limon

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions