1.1. 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.
1.2. How much ground space is needed for each warehouse assuming block storing of pallets?
209 5056 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 4076 Poznan 50% Bologna 40% Cincinatti 40% Riberao Preto 40% Linkoping 50% Mannheim Prague Lyon 40% Charlotte 30% Brasilia 30% Paris 40% Zagreb 20% Memphis 30% 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 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 2 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 to port 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 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 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 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 209 5056 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 4076 Poznan 50% Bologna 40% Cincinatti 40% Riberao Preto 40% Linkoping 50% Mannheim Prague Lyon 40% Charlotte 30% Brasilia 30% Paris 40% Zagreb 20% Memphis 30% 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 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 2 Banana 10,00% Costa Rica Puerto Limon $60,00 $50,00 1 to port 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 EU North Hamburg EU West Rotterdam EU East Hamburg EU South Genua North America New Jersey South America Santos (Brazil) 1 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
