Copyright © LOCOM Software GmbH, 2015
LOCOM Use Case: Tendermanagement
Use Case: Tender Management | transport logistic munich 2015
Tender management Scenario
European wide industry partner requests a price matrix for given shipment data Tender key information:
• 13,4 mio tons groupage transports • 4,6 mio tons LTL/FTL transports • Outbound shipments from Karlsruhe
Copyright © LOCOM Software GmbH, 2015
Price per zone and weight class
Use Case: Tender Management | transport logistic munich 2015
Tender management Workflow – Data preparation
Geocoding
Copyright © LOCOM Software GmbH, 2015
Distance
Bulkiness
• • • •
Locate your location data Fast & easy Faulty location data will be revised automatically Detection of implausible data
• Using different worldwide distance databases (Map and Guide, EWS, Bing, …) • Including travelling time information, toll calculation • Emissions • Different truck speed profiles
Time Distance Toll 1D 2.066 km 314,68 € 06:06h
• Define individual bulkiness factors for different regions • Calculate chargeable weight for every shipment
Datapreparation preparation Data
Routing
Use Case: Tender Management | transport logistic munich 2015
Costs
Matrix Designer
Evaluation
Tender management Workflow – Routing
Groupage
LTL / FTL
Sender Collection CO Terminal Direct
Linehaul DI Terminal Distribution
Copyright © LOCOM Software GmbH, 2015
Recipient
Data preparation
Routing Routing
Use Case: Tender Management | transport logistic munich 2015
Costs
Matrix Designer
Evaluation
Tender management Workflow – Routing
Possibility to design complex networks Arbitrary number of senders and recipients
•
Complex routing structures via multiple transport layers and hubs
•
Different consolidation rules to combine several shipments on one transport
Copyright © LOCOM Software GmbH, 2015
•
Data preparation
Routing Routing
Use Case: Tender Management | transport logistic munich 2015
Costs
Matrix Designer
Evaluation
Tender management Workflow – Costs
Powerful tariff engine COSTS
Collection
Collection 65,50 € + Handling CO 21,47 € + Linehaul 46,64 € + Handling DI 21,47 € + Distribution 165,89 € ______________________________ Sum
Linehaul
320,97 €
MARGIN
Margin 10% Profit 32,10 € ______________________________
PRIZE
Total Prize
Copyright © LOCOM Software GmbH, 2015
353,07 €
Distribution
Data preparation
Routing
Use Case: Tender Management | transport logistic munich 2015
Costs Costs
Matrix Designer
Evaluation
Tender management Workflow – Matrix Designer
Matrix Designer module calculates freight matrices on the basis of cost information provided with shipment data. Through a mathematical optimization procedure the matrices are adjusted to meet your requirements
The rates of freight matrices can be calculated either per shipment or per any unit of measure (e.g. 100 kg).
Data preparation
Routing
Use Case: Tender Management | transport logistic munich 2015
Cost per measurement
Copyright © LOCOM Software GmbH, 2015
Original cost information from shipment data
Cost per shipment
Distance and Weight
Zones and Weight
Freight Matrix
Zone Matrix
Freight Matrix (relative)
Zone Matrix (relative)
Costs
MatrixDesigner Designer Matrix
Evaluation
Tender management Workflow – Matrix Designer
Automatic offer tariff generation including margin
Matrix Designer results for AT3
Given costs AT3 500
450
450
400
400
350 300
300
Costs [€]
Costs [€]
350 250 200
200 150
150
Copyright © LOCOM Software GmbH, 2015
250
100
100
50
50
0
0
500 1.000 1.500 2.000 2.500 3.000 3.500 4.000 4.500 5.000 5.500 6.000 6.500 7.000
500 1.000 1.500 2.000 2.500 3.000 3.500 4.000 4.500 5.000 5.500 6.000 6.500 7.000
Weight classes [kg]
Weight classes [kg]
Data preparation
Routing
Use Case: Tender Management | transport logistic munich 2015
Costs
MatrixDesigner Designer Matrix
Evaluation
Tender management Workflow – Matrix Designer
Automatic offer tariff generation including margin
400
In total 10% profit
300
Copyright © LOCOM Software GmbH, 2015
200 100
0 Data preparation
2.500 Routing
Use Case: Tender Management | transport logistic munich 2015
5.000
10.000 Costs
MatrixDesigner Designer Matrix
Evaluation
Tender management Workflow – Evaluation
Profit per weight class
Costs and profit per country Sum profit 350
Costs [€] Thousands
Profit [€] Thousands
120 114
100 80
75 60
75
67
40
10 0 250
2 500
45
39
32
20 Copyright © LOCOM Software GmbH, 2015
Sum total costs
73
61
250 200 150
43 33
28
100 50
21
134
120
23 20
17
14
71
63
BE
CH
85
42
42
43
257
234 165
168
151
106
17
22
77
95
LU
NL
175
0 1000
2000
3000
5000
7000
15000
20000
FR
24000
Routing
Use Case: Tender Management | transport logistic munich 2015
AT
CZ
DE
DK
ES
GB
IT
PL
Countries
weight classes [kg]
Data preparation
300
Costs
Matrix Designer
Evaluation Evaluation
PT
Tender management Workflow – Evaluation
FR 7%
PT 15%
AT 6%
% profit per country
BE 3% CH 3%
PL 9%
CZ 4%
DE 5%
NL 5%
LU 3% DK 9% Copyright © LOCOM Software GmbH, 2015
IT 9% ES 9%
GB 13%
Data preparation
Routing
Use Case: Tender Management | transport logistic munich 2015
Costs
Matrix Designer
Evaluation Evaluation
Tender management Summary
Data preparation
Routing
• Geocoding
• FTL / LTL
• Distance
• Groupage
• Bulkiness
Collection Linehaul Distribution • Network design
Costs
• Powerful tariff engine
Copyright © LOCOM Software GmbH, 2015
• Freight or zone matrix
Evaluation
• Map visualization
(absolut/relativ)
• Fast cost calculation • Collection, linehaul, distribution cost • Terminal handling costs
Use Case: Tender Management | transport logistic munich 2015
Matrix Designer
• Mathematical optimization method • Transform partial cost information into a complete matrix
• Data analysis • Cost / profit simulation