Answered step by step
Verified Expert Solution
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
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).
Task: 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.
Region EU EU North EU West EU East North South America America Sum Product South 200g 30.000 50.000 5.000 20.000 100.000 30.000 235.000 500g 10.000 10.000 5.000 9.000 7.000 15.000 56.000 1kg 2.000 3.000 500 1.000 30.000 5.000 41.500 332.500 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 demanda location demand location demand location demand location demand Copenhagen 5096 Venlo 40% Poznan 50% Bologna 40% Cincinatti 40% Riberao Preto 4096 Linkping 50% Mannheim 20% Prague 50% Lyon 4096 Charlotte 3096 Brasilia 30% Paris 40% Zagreb 20 Memphis 3046 Curitiba 30% 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 Cashew 15,00% West Africa Accra $70,00 $45,00 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 2 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 NN Receiving ports per (Sales) Region 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 trucking time (days) port-CW 1 1 1 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 2 2 Freight rates Santos 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 $2.600,00 $2.500,00 $2.300,00 $2.000,00 $1.800,00 Lead times Hamburg Rotterdam Genova New York Santos Port - to - port Melbourne Accra Istanbul Oakland Puerto Limon 37 Days 18 Days 24 Days 33 Days 17 Days 40 Days 18 Days 15 Days 31 Days 14 Days 41 Days 15 Days 12 Days 32 Days 22 Days 38 Days 24 Days 18 Days 14 Days 13 Days 45 Days 13 Days 24 Days 30 Days 17 Days Region EU EU North EU West EU East North South America America Sum Product South 200g 30.000 50.000 5.000 20.000 100.000 30.000 235.000 500g 10.000 10.000 5.000 9.000 7.000 15.000 56.000 1kg 2.000 3.000 500 1.000 30.000 5.000 41.500 332.500 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 demanda location demand location demand location demand location demand Copenhagen 5096 Venlo 40% Poznan 50% Bologna 40% Cincinatti 40% Riberao Preto 4096 Linkping 50% Mannheim 20% Prague 50% Lyon 4096 Charlotte 3096 Brasilia 30% Paris 40% Zagreb 20 Memphis 3046 Curitiba 30% 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 Cashew 15,00% West Africa Accra $70,00 $45,00 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 2 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 NN Receiving ports per (Sales) Region 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 trucking time (days) port-CW 1 1 1 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 2 2 Freight rates Santos 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 $2.600,00 $2.500,00 $2.300,00 $2.000,00 $1.800,00 Lead times Hamburg Rotterdam Genova New York Santos Port - to - port Melbourne Accra Istanbul Oakland Puerto Limon 37 Days 18 Days 24 Days 33 Days 17 Days 40 Days 18 Days 15 Days 31 Days 14 Days 41 Days 15 Days 12 Days 32 Days 22 Days 38 Days 24 Days 18 Days 14 Days 13 Days 45 Days 13 Days 24 Days 30 Days 17 Days
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started