lean &green barge data capture , analysis and first potential update 30/10/2012
DESCRIPTION
Lean &Green Barge Data capture , analysis and first potential Update 30/10/2012. Agenda. Status Data Collection Visualisation flows Opportunity Identification Project Approach. Status Data Collection. - PowerPoint PPT PresentationTRANSCRIPT
Lean &Green BargeData capture, analysis and
first potentialUpdate 30/10/2012
Agenda
• Status Data Collection• Visualisation flows• Opportunity Identification• Project Approach
Status Data CollectionParticipant Source Date received Format Data quality Data status
Overall status
- DE L&G 12-okt Correct Correct In database
- FrieslandCampina L&G18-okt
Text file, converted by TV into right format
Volumes and destination unclear
In database after two iterations with FC
- United Bisquits L&G 15-okt Correct Correct In database
- Bavaria L&G15-okt
Two files with different format
Discrepancies between files, to be checked
In database. Communication ongoing
- Heinz L&G 18-okt Correct Correct In database- Interface L&G Data expected wk 44
- Aviko L&GIndicated to wait until after 30/10 meeting
- Nutricia L&G Aiming for December- Grolsch L&G Learning participant
- V&D L&G12-okt
Text file, converted by TV into right format
Volume unclear, to be checked
In database. Volumes confirmed by V&D 17/10
- Cargill L&G10-okt
Text file, converted by TV into right format
Volume unclear, to be checked
In database. Communication ongoing
- Suikerunie L&G Aiming for December- BaasPLantenservice L&G Aiming for December
- Staples Belgium L&GX X X Will close Belgium facility
- Maxeda/ Brico TV 15-okt Correct Correct In database- Mars L&G- Bureau Binnenvaart L&G 26-okt BVB format Incomplete Data assessment TV
≡ Participating shippers will receive company network analysis and updates on opportunities with growing network
Visualization all Flows
Database key figures;8 shippers119 lanesOver 65.000 shipmentsOver 100.000 TEU
Visualization Benelux Flows
Benelux flows and L&G Shippers
Origin Destination
Shipments
Example Network Analysis Origin Destination
Shipments
Origin Destination Volume % UoM Mode Freight_type Temp_contrFR - VERTOU FR - MEUNG SUR LOIRE 1.378 25% FTL Road FTL 15°-18°CNL - ZAANDAM BE - WILLEBROEK 1.212 22% FTL Road FTL 15°-18°CBE - DISON FR - MEUNG SUR LOIRE 439 8% FTL Road FTL 15°-18°CBE - DISON BE - WILLEBROEK 397 7% FTL Road FTL 15°-18°CFR - BAILLEUL BE - WILLEBROEK 379 7% FTL Road FTL 15°-18°C
5.543Grand Total
Infrastructure
Assumptions;≡ Big volumes in 1 direction
≡ CEMT IV (80 TEU), 1x/wk (approx 4.000 TEU/yr)≡ Balancing flows (even smaller volumes)≡ 45 foot containers considered 2 TEU≡ FTL considered 2 TEU≡ Not all companies disclosed final destination≡ Data received from BVB not included in analysis
Opportunity Identification
Big Flows
Origin Destination Company TEU
Leeuwarden Rotterdam F25a 17.262
Elst Wigan (GB) F45 10.000
Westerbroek Rotterdam F25a 9.240Rotterdam Aduard F47 360
Meppel Rotterdam F25a 7.624Botlek Meppel F43 143
BelgiumOrigin Destination Company TEU
Antwerpen Utrecht F44 3.744
Willebroek Nieuwegein F44 100
Grimbergen Nieuwegein F44 1.748Rotterdam Nieuwegein F47 1.440
Zaandam Willebroek F46 2.424
Utrecht Willebroek F44 660
Amsterdam Willebroek F46 126
Amsterdam Kallo F43 107
GermanyOrigin Destination Company TEU
Utrecht Neuss F44 1.700
Amsterdam Neuss F43 214
Amsterdam Dusseldorf F43 107
Grimbergen Neus F44 1.500
Trade imbalance container flow; NL-DE 2.4 mio ton/DE-NL 8.6 mio tonGerman companies/ flows needed to balance flows
Veghel Outbound
Origin Destination Company TEU
Veghel Rotterdam F25a 9.584
Veghel Rotterdam Bavaria
Veghel Rotterdam Mars
Botlek Veghel F43 36
≡ Missing flows from and to Venlo≡ Ricoh/Sabic/Phillip Morris collaboration≡ UK Flows≡ France/ Spain≡ Scandinavia≡ Eastern Europe
Other opportunities
Project Approach
Collecting DataData cleansingFollow up shippersConversionVisualizationAnalysisLane IdentificationFind add. volumes
Involving ShippersLOIMapping total chainFind add. volumesBusiness CaseLegal framework
Start of pilotOperational mgtMeasuring/monitoringGainsharingCommunity MgtEvaluation