Stratégiaváltás a szállítmányozásban, lokálisról regionálisra váltás
2014
esettanulmány Xylem EMEA 2014 Hoffman Árpád
Tematika
•Vállalati háttér •Az elmúlt 2 év szállítmányozási akciói - lokális •2014 paradigma váltás – regionális
2
This is Xylem • A leading global water technology provider • Nearly $4 billion in revenues • 12,500 global employees • We devote our technology, time and talent to advance the smarter use of water
2/8/2013
Xylem: A Company Overview
We Span the Entire Cycle of Water
2/8/2013
Xylem: A Company Overview
Unmatched Global Presence in Our Industry
12,500 employees … 360 global locations … doing business in 150+ countries 2/8/2013
Xylem: A Company Overview
Unique Global Assets • Industry-leading positions
Leading Brands, including …
• Leading brands and technologies • Diverse product portfolio • World-class distribution channels • Diverse customer base
Diverse Customer Base, including …
• Robust aftermarket opportunities
An unrivaled advantage 2/8/2013
Xylem: A Company Overview
2011 szállítási költség havi bontásban
Sum of Est Value of invoice LCE(HUF) Month of delivery January February March April May June July August Szeptember (blank) Július Május Október November December Január Grand Total
Carrier Bi-Ka 150 486 752 428 1 171 051 1 855 076 1 484 881 930 274 1 316 338 1 239 453 2 147 018 188 791 243 513 2 618 718 2 592 228
16 690 254
780 megbízás 206 beszállító 8 fuvarozó 115 millió Ft fuvarköltség
7
DHL
Expeditors Lukács Pál Mózes János SEV 162 180 255 000 1 966 530 637 600 520 000 3 762 575 115 000 5 865 292 85 000 5 159 748 0 3 300 422 0 6 379 888 0 12 693 829 50 000 60 000 9 023 580 190 000 60 000 60 000 923 082 2 300 923 5 329 123 70 000 0 2 239 224 15 456 914 0 1 972 250 466 213 23 159 093 72 461 626 1 522 600 580 000 2 729 807 2 447 715 2 544 847 1 980 116 1 681 881 911 942 1 330 292 1 960 479 2 321 030 18 058 692 781
UPS 322 860 225 181
548 041
Ceva Logistics Grand Total 3 297 473 6 647 132 7 818 654 9 785 483 218 000 8 544 510 5 142 638 9 026 517 205 100 16 208 861 13 681 627 266 849 996 293 923 082 10 318 764 20 288 367 1 972 250 466 213 218 000 205 100 115 384 713
2012 szállítási költség havi bontásban
Összeg / Est ValueCarrier of invoice LCE Month of delivery Bi-Ka CEVA Logistics DHL 1 1 391 307 72 332 2 1 441 925 3 1 405 808 4 1 453 790 110 435 5 1 001 082 6 906 999 7 1 324 272 8 1 857 265 9 1 357 106 10 2 493 955 620 571 11 116 814 12 290 027 Grand Total 15 040 349 803 338
2 008 571 1 870 398 1 621 960 1 510 054 1 855 076 1 893 381 1 813 487 2 248 253 2 417 892 5 184 910 0 22 423 981
980 megbízás 207 beszállító 10 fuvarozó 83 millió Ft fuvarköltség
8
DOR-CEL Expeditors FedEx 568 802 2 637 854 351 042 2 537 922 2 109 184 1 673 804 2 586 806 2 495 573 3 567 979 2 706 166 3 172 935 9 487 430 123 018 919 844
33 098 672
Lukács Pál Mózes János UPS 130 000 180 000
869 538 548 287 624 088 430 213 0 2 472 126
0
130 000
180 000
Sev Stante
264 575 429 515 600 251 11 269 0 1 305 610
Grand Total 6 808 866 6 381 286 5 136 953 4 748 083 5 442 964 5 295 954 6 705 738 675 851 8 621 649 977 335 8 903 070 2 523 505 21 534 710 2 438 641 3 119 955 0 290 027 6 615 332 82 989 252
2013 szállítási költség havi bontásban
Összeg Carrier / Net Value of invoice LCE Month Bi-KA of delivery Carry-Er Bt. Ceva DHL DPD Expeditors FedEx Sev Stante UPS TNT Mózes J Lukács DHLExpress Grand Total 1 1 816 340 260 740 1 912 198 3 591 009 1 060 206 1 559 344 3 308 781 8 902 13 517 520 2 709 025 261 050 2 111 031 4 070 837 495 832 858 904 313 589 019 6 248 862 3 1 394 709 35 105 2 334 974 19 871 1 464 207 785 778 1 370 534 1 094 917 8 500 095 4 1 010 710 135 038 101 499 2 364 774 4 840 3 166 462 406 505 1 496 720 1 073 318 9 759 866 5 831 046 1 519 261 15 011 3 769 669 806 256 790 857 1 368 532 5 423 9 106 056 6 991 215 1 838 999 7 344 1 951 341 677 180 903 966 1 122 268 14 554 7 506 867 7 1 016 618 2 524 730 8 854 2 340 648 784 866 1 476 804 1 548 467 9 700 987 8 1 011 548 1 822 846 2 486 5 085 481 895 485 1 121 625 1 807 643 11 747 114 9 1 052 209 2 702 798 1 243 2 205 703 1 073 277 1 731 655 1 104 380 23 592 10 721 9 905 579 10 1 484 255 2 109 338 4 104 1 505 614 715 466 1 179 843 1 076 209 494 750 8 569 579 11 126 352 2 964 99 106 698 165 588 822 594 786 306 000 4 000 2 420 194 12 39 582 35 497 75 079 Grand Total 11 317 675 691 933 101 499 21 406 884 70 787 26 016 735 8 736 042 13 124 484 14 723 817 32 494 800 750 4 000 30 698 97 057 799
1318 megbízás 207 beszállító 13 fuvarozó 97 millió Ft fuvarköltség
9
2013 Tengeri szállítási költség az áru érték viszonylatában.
Mode: SEA Vendor CHINA METAL INTERNATIONALE Zheijang Baisida YUYAO ANLIAN ELECTRONICS LTD CHINA BCEL ENGINEERING Ningbo A-Line Cable & Wire Co Ltd SPCB Mass Advance WISE EXCEL LIMITED QINGDAO GLORY UNIT TRADE LTD. DATAFIELD INDUSTRIAL HK LTD HENAN MACHINERY Foyou Weiken Uniwell Végösszeg
10
Összeg / Value of Cargo(HUF) 73 060 588,11 92 895 594,71 24 426 321,59 5 203 374,45 1 277 533,04 6 430 462,56 3 058 370,04 3 914 444,93 1 180 176,21 845 814,98 788 546,26 471 024,23 956 559,47 5 785 242,29 220 294 052,86
Összeg / Net Value of invoice Összeg / Customs LCE(HUF) value(HUF) 3 845 134,00 1 180 352,00 2 603 021,00 2 327 152,00 2 106 848,00 911 718,00 434 483,00 139 367,00 298 216,00 47 335,00 203 518,00 151 104,00 104 295,00 141 404,00 1 032 218,00 107 646,00 33 452,00 101 883,00 32 009,00 79 222,00 827 554,00 65 778,00 422 176,00 48 629,00 48 290,00 10 235 176,00 7 057 628,00
% 5% 3% 9% 8% 23% 3% 5% 4% 9% 12% 10% 14% 5% 1% 5%
phased out
phased out phased out phased out phased out
2013 Légi szállítási költség az áru érték viszonylatában.
Mode: AIR Vendor Hoover Uniwell Coilmaster Electronics Co., Ltd. Weiken CHINA METAL INTERNATIONALE SPCB Zheijang Baisida YUYAO ANLIAN ELECTRONICS LTD CHINA BCEL ENGINEERING HENAN MACHINERY Megacorp Mass Advance PARKER OVERSEAS SHENZEN CIT ELEKTRONICS MAT L Elka CTC Coils Hollyland Electronics Zheijang Kaiven Végösszeg
11
Összeg / Value of Cargo(HUF) Összeg / Net Value of transportation invoice LCE Összeg / Customs value(HUF) 45 988 325,99 1 464 940,00 2 374 379,00 13 249 837,00 1 223 965,00 7 239 317,18 602 137,00 1 348 822,00 6 608 751,10 605 968,00 1 922 826,00 4 574 537,44 2 835 781,00 109 287,00 4 320 511,01 416 889,00 3 480 594,71 1 714 578,00 105 073,00 3 044 977,97 723 220,00 522 847,00 2 626 154,19 647 573,00 74 010,00 2 425 110,13 3 107 823,00 81 885,00 2 312 907,49 193 529,00 462 555,07 126 172,00 18 136,00 231 859,03 73 530,00 327 928,00 227 438,33 69 800,00 165 947,14 43 205,00 6 169,00 149 779,74 45 076,00 6 618,00 135 682,82 22 789,00 3 442,00 132 158,59 47 027,00 97 376 444,93 13 964 002,00 6 901 422,00
% 3% 9% 8% 9% 62% 10% 49% 24% 25% 128% 8% 27% 32% 31% 26% 30% 17% 36% 14%
all new samples
all new samples changed to SEA phased out phased out phased out reallocated to EU phased out
Közút 2013 tender Ajánlatkérési szempontok a szállítási struktúra alapján
Cegled
Altavilla Vicentina Castelgomberto/Trissino Fellbach Viernheim Wernau Winnenden
12
Grossostheim Montecchio Maggiore Stockerau Cegled Cegled Cegled Cegled Cegled Cegled
Közút 2013 tender Súlyozási szempontok a szállítások mennyisége alapján
Number of Shipments Inbound/Outbound
Route
Route Postals
101-250
251-500
501-1000
1001-1500
1501-2000
2001-2500
2501-3000
3001-3500
Grand Total
Inbound
Italy -> Hungary
36077 -> 2700
32
56
93
37
15
9
6
8
325
Inbound
Italy -> Hungary
36070 -> 2700
3
4
1
Inbound
Germany -> Hungary
71364 -> 2700
Inbound
Germany -> Hungary
73243 -> 2700
Inbound
Germany -> Hungary
70736 -> 2700
13
Inbound
Germany -> Hungary
68519 -> 2700
1
Outbound
Hungary -> Germany
2700 -> 63762
Outbound
Hungary -> Italy
2700 -> 36075
2
Outbound
Hungary -> Austria
2700 -> 2000
7
Inbound/Outbound
Route
Route Postals
w.101-250
w.251-500
w.501-1000
Inbound
Italy -> Hungary
36077 -> 2700
193
383
724
Inbound
Italy -> Hungary
36070 -> 2700
141
323
545
Inbound
Germany -> Hungary
71364 -> 2700
Inbound
Germany -> Hungary
73243 -> 2700
Inbound
Germany -> Hungary
70736 -> 2700
179
Inbound
Germany -> Hungary
68519 -> 2700
150
Outbound
Hungary -> Germany
2700 -> 63762
Outbound
Hungary -> Italy
2700 -> 36075
235
Outbound
Hungary -> Austria
2700 -> 2000
193
7
3
1
22
14
14
1
11
9
24 8 1
2
3
1
3
5
100
1
1
11
9
5
7
6
55
6
10
2
2
2
1
41
w.1001-1500
w.1501-2000
w.2001-2500
w.2501-3000
w.3001-3500
Grand Total
1214
1734
2222
2655
3238
832
Avg. Weight per Shipment
13
420
738
1800
191
1190
1190
1020
561
356
237 69 1000
1500
1873
2400
2900
3420
6070
300
1000
1353
1757
2440
2669
3300
2700
377
730
1200
1803
2350
3500
712
Előzetes értékelés az ajánlatok alapján (a szállítási volumenek alapján súlyozott érték ) Spend 2013 (Shipments <3500 kg)
Forwarder Current
Forwarder Best Quote
% Diff vs current prices
Indicative Saving
Cegled -> Grossostheim
8,515
2
1
-28%
-2,384
Cegled -> Montecchio Maggiore
14,819
4
1
-5%
-741
DSV/Sev Stante charge lowest prices but is not meeting requested lead time – further evaluation needed
Cegled -> Stockerau
7,099
4
1
+11%
+781
DHL Freight charges lowest prices but is not meeting requested lead time
Altavilla Vicentina -> Cegled
48,531
3
3
+2%
+971
Castelgom.Trissino -> Cegled
3,532
4
3
-55%
-1,943
Fellbach -> Cegled
2,303
2
2
-18%
-415
Viernheim -> Cegled
1,721
2
2
?
?
Wernau -> Cegled
3,579
2-4
2
-52%
-537
Winnenden -> Cegled
4,614
4
3
-36%
-1,661
DHL Freight is also an alternative (2%) higher compared to DSV / Schenker
-6%
-5,929
Target set at 4%
Route
14
Grand Total
94,713
Comment
8 ajánlat összegzése: Cél/Indító állomás- Cegléd útvonal
Route Cegled -> Grossostheim
FTLs Current Set-up 2013 (Y/N) Forwarder Price DHL 980 1080* 1045 Y Freight
Cegled -> Montecchio Maggiore
Y
Cegled -> Stockerau
N
Altavilla Vicentina -> Cegled
Y
Castelgom.Trissino -> Cegled
Bi-Ka
1185
% Price Change
Forwarder
1180 1250 1150 1070
1045
+6.6%
DHL Freight
950
1150
890
850
750
+/-0%
Bi-Ka
530
670
550
440
440 -3.5%
Bi-Ka
980*
880
450
499
595*
820
925
890
850
950
1150
950
850
820
N
820
925
890
850
950
1150
950
860
950
Fellbach -> Cegled
N
1080
1060 1140
1080 1200
900
930
900
Viernheim -> Cegled
N
1100
1130 1140
1080 1250
950
950
900
Wernau -> Cegled
N
1050
1040 1140
980
1200
900
930
820
Winnenden -> Cegled
N
1050
1060 1140
1020 1200
900
930
820
850
850
Best Quote
750
Sev. Stante
750
Received Quotes
Zöld=kedvező, Piros=kedvezőtlen
15
Teljes rakomány kalkuláció: Cegled -> Grossostheim. Current Prices
Dep. City Cegled
Received Quotations
Arrival City
Forwarder
Grossostheim DHL Freight
980
Price
Best quote vs. current Price
Requested Lead Time
Provided Lead time
Latest Booking Time
1,080
+10%
2 days
3 days
1 day
1,045
+7%
2 days
2 days
1,185
+21%
2 days
2 days
Grossostheim
1,180
+20%
2 days
2 days
2 days
Cegled
Grossostheim
1,250
+28%
2 days
2 days
2 days
Cegled
Grossostheim
1,150
+17%
2 days
2 days
Cegled
Grossostheim
1,070
+9%
2 days
2 days
Dep. City
Arrival City
Cegled
Grossostheim
Cegled
Grossostheim
Cegled
Grossostheim
Cegled
Grossostheim
Cegled
Forwarder
DHL Freight
• Szállítási idő OK. • DHL árat emel, 6.6%, de a legolcsóbb marad
16
Price
1-2 days
Teljes rakomány kalkuláció : Cegled - Montecchio Maggiore. Current Prices
Received Quotations
Dep. City
Arrival City
Forwarder
Price
Cegled
Montecchio
Bi-Ka
750
Dep. City
Arrival City
Forwarder
Price
Cegled
Montecchio
BI-KA
750
+/-0%
Cegled
Montecchio
980
Cegled
Montecchio
Cegled
Montecchio
Cegled
Provided Lead time
Latest Booking Time
2 days
1-2 days
1 day
+31%
2 days
3 days
880
+17%
2 days
2 days
850
+13%
2 days
2 days
1-2 days
Montecchio
950
+27%
2 days
2 days
2 days
Cegled
Montecchio
1,150
+53%
2 days
2 days
2 days
Cegled
Montecchio
890
+19%
2 days
1-2 days
Cegled
Montecchio
850
+13%
2 days
2 days
SEV
DSV
• Szállítási idő rendben • BI-KA , DSV és SEV ajánlatok kedvezőbbek
17
Quote vs. current Requested Price Lead Time
1-2 days
Teljes rakomány : Altavilla Vicentina - Cegled. Current Prices
Received Quotations
Dep. City Altavilla Vicentina
Arrival City
Forwarder
Price
Cegled
Sev Stante
850
Dep. City Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina Altavilla Vicentina
Arrival City
Forwarder
Price
Cegled
BI-KA
820
-4%
Cegled
925
Cegled
Provided Lead time
Latest Booking Time
2 days
1-2 days
1 day
+13%
2 days
3
890
-4%
2 days
2
850
-4%
2 days
2 days
1-2 days
Cegled
950
+12%
2 days
2 days
2 days
Cegled
1150
+21%
2 days
2 days
2 days
Cegled
950
-17%
2 days
1-2
Cegled
850
-11%
2 days
2
Cegled
Sev Stante
• BI-KA a legjobb (-4% a jelenlegi Sev Stante árhoz)
18
Quote vs. current Requested Price Lead Time
1-2
Részrakomány szimuláció: Cegled -> Grossostheim. Current Prices
Carrier DHL Freight
Carrier DHL Freight
M&M
RFQ Simulation Avg. Weight per
Shipment 2013 No’ of Shipments 2013 Baseline DHL Freight
M&M
• •
19
Total Spend 2013 (Shipments <3500KG) 8,515
101-250 Kg 75
251-500 Kg 110
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 182 270 375 434 523 570
101-250 Kg
251-500 Kg
(per Kg) 0.90 0.36* 5.35
(per Kg) 0.80 0.24* 2.15
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 2 days 3 days 0.60 0.40 0.30 0.27 0.25 0.24 2 days 3 days 0.21* 0.18* 0.16* 0.15 0.14 0.10* 1.08 0.77 0.52 0.39 0.47 0.39 2 days 2 days
0.6 1.45 0.55 0.36*
0.37 0.63 0.4 0.31
0.38 0.29 0.34 0.23
0.35 0.19 0.31 0.19
0.35 0.16* 0.28 0.17
0.35 0.14* 0.25 0.18
0.35 0.12* 0.19 0.16
0.24 0.10* 0.16 0.15
1,000
1,500
1,873
2,400
2,900
3,420
1
2
3
1
3
5
182 600 210 1,080
540 1,200 540 2,310
1,125 1,686 899 2,922
434 648 360 936
1,569 2,175 1,218 4,089
2,850 4,104 1,710 6,669
Grand Total 6,700 10,413 4,937 18,006
380 290 340 230
1,050 570 930 570
1,967 899 1,574 955
840 336 600 432
3,045 1,044 1,653 1,392
4,104 1,710 2,736 2,565
11,386 4,849 7,833 6,144
M&M és DHL Freight a kedvező ezen az útvonalon M&M megtakarítás 28%
2 days 2 days 2 days 2 days
3-4 days 2 days 2-3 days 2-4 days
% Diff vs current prices +55% -26% +169% +70% -28% +17% -8%
Részrakomány szimuláció : Cegled -> Montecchio Maggiore. Current Prices
Carrier Bi-Ka
Carrier
Sev Stante M&M DSV
RFQ Simulation Avg. Weight per
Shipment 2013 No’ of Shipments 2013 Baseline
Sev Stante M&M DSV
• • •
20
Total Spend 2013 (Shipments <3500KG) 14,819
101-250 Kg 150
251-500 Kg 180
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 220 260 320 360 420 460
101-250 Kg
251-500 Kg
(per Kg) 0.7 0.43 4.26 0.30* 0.64 1.5 0.64 0.36
(per Kg) 0.4 0.28 1.71 0.20* 0.49 0.65 0.45 0.30
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 2 days 2 days 0.3 0.22 0.19 0.17 0.16 0.15 2 days 5 days 0.25 0.21 0.2 0.18 0.17 0.16 0.86 0.66 0.44 0.33 0.35 0.29 2 days 2 days 0.18* 0.17* 0.16* 0.15* 0.14 0.12 2 days 3 days 0.45 0.42 0.42 0.42 0.39 0.26 2 days 3-4 days 0.3 0.2 0.17 0.15* 0.13* 0.11 2 days 2 days 0.37 0.34 0.29 0.27 0.2 0.1 2 days 3-4 days 0.26 0.21 0.17 0.15 0.13* 0.1 2 days 2-4 days
235
300
1,000
1,353
1,757
2,440
2,669
3,300
2
1
1
11
9
5
7
6
300 329 202 2002 141 301 705 301 169
180 120 84 513 60 147 195 135 90
220 300 250 860 180 450 300 370 260
2,860 3,275 3,126 9,825 2,531 6,253 2,977 5,062 3,126
2,880 3,004 3,162 6,956 2,530 6,640 2,688 4,585 2,688
1,800 2,074 2,196 4,026 1,830 5,124 1,830 3,294 1,830
2,940 2,989 3,176 6,538 2,615 7,285 2,428 3,736 2,428
2,760 2,970 3,168 5,742 2,376 5,148 2,178 1,980 1,980
Grand Total 13,940 15,061 15,364 36,463 12,263 31,348 13,302 19,462 12,572
Sev. Stante ajánlat kedvező (-12%), de a szállítási idő 3 nap M&M megtakarítás 5%, DSV megtakarítás 10%, de a szállítási idő 2-4 nap, egyenlőre nem kalkulálható csak 4-el
% Diff vs current prices +8% +10% +162% -12% 125% -5% +40% -10%
Részrakomány szimuláció : Cegled -> Stockerau. Current Prices
Carrier BI-KA
Carrier BI-KA DHL Freight
M&M DSV
RFQ Simulation
Avg. Weight per Shipment 2013 No’ of Shipments 2013 Baseline DHL Freight
DSV
251-500 Kg 160
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 180 230 250 300 330 370
101-250 Kg
251-500 Kg
(per Kg) 0.7 0.36* 2.82
(per Kg) 0.47 0.2* 1.14
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) Time Time 1 days 1 days 0.37 0.2 0.17 0.15 0.13 0.12 0.16* 0.12* 0.11* 0.1* 0.09 0.08* 1 days 2-3 days 0.57 0.43 0.29 0.22 0.24 0.2 1 days 2 days
0.5 1.2 0.47 0.55
0.36 0.55 0.32 0.36
0.32 0.25 0.25 0.23
0.3 0.15 0.23 0.15
0.32 0.13 0.2 0.12
0.32 0.11 0.18 0.1*
193
377
730
1,200
1,803
2,350
3,500
7
6
10
2
2
2
1
980
960
1,800
460
500
600
370
Grand Total 5,670
946 486 3,810
1,062 452 2,576
2,701 1,168 4,161
480 288 1,032
613 397 1,045
705 470 1,034
455 315 840
6,962 3,576 14,499
+23% -37% +156%
678 1,621 635 743
814 1,243 723 814
2,336 1,825 1,825 1,679
720 360 552 360
1,154 469 721 433
1,504 517 846 470
980 280 490 280
8,183 6,315 5,792 4,778
+44% +11% +2% -16%
0.28 0.08 0.14 0.08*
• DHL a legjobb ajánlat (-37%), de a 2-3 nap nem elfogadható egyenlőre • DSV megtakarítás szintén magas (-16%)
21
Total Spend 2013 (Shipments <3500KG) 7,099
101-250 Kg 140
0.15 0.08* 0.1 0.08*
1 days 1 days 1 days 1 days
2-3 days 1 days 2-3 days 1-3 days
% Diff vs current prices
Részrakomány szimuláció : Altavilla Vicentina -> Cegled. Current Prices Carrier Sev Stante
Carrier
Sev Stante M&M DSV
RFQ Simulation
Avg. Weight per Shipment 2013 No’ of Shipments 2013 Baseline
Schenker Sev Stante M&M DSV
101-250 Kg 251-500 Kg (Per100kg) (Per100kg)
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg (Per100kg) (Per100kg) (Per100kg) (Per100kg) (Per100kg) (Per100kg)
19 (45 Min Cost)
19
101-250 Kg
251-500 Kg
(per Kg) 0.70 0.32 1.67 0.3* 0.64 1.5 0.64 0.39
(per Kg) 0.40 0.29 0.65 0.2* 0.49 0.65 0.47 0.32
193
383
724
1,214
1,734
2,222
2,655
3,238
32
56
93
37
15
9
6
8
1,440 4,324 1,977 10,315 1,853 3,953 9,265 3,953 2,409
4,075 8,580 6,220 13,942 4,290 10,510 13,942 10,081 6,864
11,445 20,197 17,504 24,910 12,118 30,296 20,197 26,256 16,831
7,634 8,981 9,879 10,328 7,634 20,207 8,981 15,717 9,879
4,421 4,681 5,201 4,421 4,161 10,922 4,421 8,061 4,941
2,999 3,199 3,799 2,799 2,999 8,398 2,999 3,799 2,999
2,390 2,230 2,867 2,071 2,230 6,213 2,071 2,549 2,071
3,367 3,367 3,626 2,849 3,108 6,734 2,849 3,885 2,590
17
17
17
15
15
Total Spend 2013 (Shipments <3500KG)
13
48,531
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 3 days 3 days 0.30 0.20 0.18 0.16 0.14 0.13 3 days 4 days 0.26 0.22 0.2 0.19 0.18 0.14 3 days 3 days 0.37 0.23 0.17 0.14* 0.13* 0.11 0.18* 0.17* 0.16* 0.15 0.14 0.12 3 days 3 days 0.45 0.45 0.42 0.42 0.39 0.26 3 days 3-4 days 0.30 0.20 0.17 0.15 0.13* 0.11 3 days 3 days 0.39 0.35 0.31 0.19 0.16 0.15 3 days 4 days 0.25 0.22 0.19 0.15 0.13* 0.10* 3 days 2-4 days
Grand Total 37,771 55,559 51,074 71,636 38,394 97,233 64,726 74,302 48,584
• Sev. Stante (+2% a jelenlegi árhoz), DSV, M&M és Schenker szintén jó 2000Kg felett
22
% Diff vs current prices +47% +35% +90% +2% +157% +71% +97% +29%
Részrakomány szimuláció : Castelgom.Trissino -> Cegled. Current Prices
Carrier Bi-Ka (Collection)
Carrier
Sev Stante
Avg. Weight per Shipment 2013 No’ of Shipments 2013 Baseline
Sev Stante
251-500 Kg 180
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 500 250 300 350 400 450
101-250 Kg
251-500 Kg
(per Kg) 0.7 0.32 1.67 0.30* 0.64 1.5 0.64 0.39
(per Kg) 0.4 0.29 0.65 0.20* 0.49 0.65 0.47 0.32
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 3-4 days 3-4 days 0.3 0.2 0.18 0.16 0.14 0.13 0.26 0.22 0.2 0.19 0.18 0.14 3-4 days 4 days 0.37 0.23 0.17 0.14* 0.13* 0.11 3-4 days 3 days 0.18* 0.17* 0.16* 0.15 0.14 0.12 3-4 days 3 days 0.45 0.45 0.42 0.42 0.39 0.16 3-4 days 3-4 days 0.3 0.2 0.17 0.15 0.13* 0.11 3-4 days 3-4 days 0.39 0.35 0.31 0.19 0.16 0.15 3-4 days 4 days 0.25 0.22 0.19 0.15 0.13* 0.10* 3-4 days 2-4 days
141
323
545
1,800
3
4
1
1
399 295 135 705 127 270 633 270 165
720 516 374 839 258 632 839 606 413
250 164 142 202 98 245 164 213 136
350 324 360 306 288 756 306 558 342
• Sev. Stante a legjobb (-55%)
23
Total Spend 2013 (Shipments <3500KG) 3,532
101-250 Kg 133
Grand Total 1,719 1,299 1,011 2,051 771 1,903 1,941 1,647 1,056
% Diff vs current prices -24% -41% +19% -55% +11% +13% -4% -39%
Részrakomány szimuláció : Fellbach -> Cegled. Current Prices
Carrier DHL Freight
Carrier DHL Freight
DSV
RFQ Simulation Avg. Weight per
Shipment 2013 No’ of Shipments 2013 Baseline
DHL Freight
DSV
251-500 Kg 109
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 468 182 249 308 369 425
101-250 Kg
251-500 Kg
(per Kg) 0.85 0.36* 0.44
(per Kg) 0.8 0.24* 0.25
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 3-4 days 3-4 days 0.45 0.25 0.25 0.28 0.27 0.25 3-4 days 3 days 0.21* 0.18* 0.16* 0.15 0.14 0.10* 0.25 0.18* 0.16* 0.15 0.14 0.14 3-4 days 3-4 days
0.59 1.4 0.46 0.36*
0.36 0.6 0.33 0.31
179
356
13
9
975 1,976 837 1,023
981 2,560 768 800
Grand Total 1,956 4,536 1,605 1,823
1,372 3,255 1,070 837
1,152 1,920 1,056 992
2,524 5,175 2,126 1,829
0.38 0.28 0.27 0.22
0.35 0.19 0.25 0.18*
0.35 0.16* 0.22 0.16*
0.35 0.14* 0.16 0.14*
• DHL Freight a legjobb, a kg alapú számlázással, megtakarítás: 18%
24
Total Spend 2013 (Shipments <3500KG) 2,303
101-250 Kg 75
0.35 0.12* 0.14 0.13
0.22 0.10* 0.13 0.12
3-4 days 3-4 days 3-4 days 3-4 days
3-4 days 3-4 days 2-3 days 2-4 days
% Diff vs current prices +132% -18% -7% 29% +165% +9% -6%
Részrakomány szimuláció : Viernheim -> Cegled. Current Prices
Carrier DHL Freight
Quoted Prices Carrier DHL Freight
251-500 Kg
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg
101-250 Kg
251-500 Kg
(per Kg) 0.9 0.37 0.44
(per Kg) 0.8 0.23* 0.25
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) Time Time 3-4 days 3-4 days 0.5 0.3 0.28 0.26 0.29 0.26 0.20* 0.18* 0.15* 0.14* 0.13 0.10* 3-4 days 3 days 0.25 0.18* 0.16 0.15 0.14 0.14 3-4 days 3-4 days
0.6 1.45 0.52 0.36*
0.37 0.63 0.38 0.31
RFQ Simulation Avg. Weight per
Shipment 2013 No’ of Shipments 2013 Baseline DHL Freight
• DHL Freight a legkedvezőbb
25
Total Spend 2013 (Shipments <3500KG) 1,721
101-250 Kg
0.38 0.29 0.31 0.24
0.35 0.19 0.29 0.2
0.35 0.16 0.26 0.17
0.35 0.14* 0.14* 0.15
0.35 0.12* 0.12* 0.14
0.22 0.10* 0.11 0.13
3-4 days 3-4 days 3-4 days 3-4 days
3-4 days 3-4 days 2-3 days 2-4 days
1
Grand Total
% Diff vs current prices
2,560 768 800
2,560 768 800
1,152 1,920 1,056 992
1,152 1,920 1,056 992
150
Részrakomány szimuláció : Wernau -> Cegled. Current Prices
Carrier DHL Freight Bi-Ka (Collection)
Quoted Prices Carrier DHL Freight Schenker
251-500 Kg 109 280
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 468 182 249 308 369 425 320 350 400 550 600 720
101-250 Kg
251-500 Kg
(per Kg) 0.85 0.39 0.44
(per Kg) 0.75 0.25* 0.25*
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 3-4 days 3-4 days 0.45 0.25 0.25 0.28 0.27 0.25 3-4 days 3 days 0.22* 0.19 0.17 0.16 0.14 0.11 0.25 0.18* 0.16* 0.15 0.14 0.14 3-4 days 3-4 days
0.59 1.4 0.47 0.36*
0.36 0.6 0.34 0.31
0.38 0.28 0.28 0.22*
0.35 0.19 0.26 0.18*
420
738
1,020
5
3
1
DHL Freight Schenker
1,618 2,205 735 735
960 997 487 554
350 255 194 184
Grand Total 2,928 3,457 1,416 1,472
DSV
1,058 1,764 1,000 911
842 620 620 487
357 194 265 184
2,257 2,578 1,885 1,582
DSV
RFQ Simulation Avg. Weight per DHL Shipment 2013 No’ of DHL Shipments 2013 Avg. Weight per BIKA Shipment 2013 No’ of BI-KA Shipments 2013 Baseline
0.35 0.16* 0.23 0.16*
0.35 0.14* 0.16 0.14*
0.35 0.12* 0.14 0.13
0.19 0.10* 0.13 0.12
3-4 days 3-4 days 3-4 days 3-4 days
3-4 days 3-4 days 2-3 days 2-4 days
420 2
• DHL Freight és Schenker a befutó a valós igények alapján
26
Total Spend 2013 (Shipments <3500KG) 2,854 725
101-250 Kg 75 220
% Diff vs current prices 18% -52% -50% -23% -12% -36% -46%
Részrakomány szimuláció : Winnenden -> Cegled. Current Prices
Carrier Bi-Ka (Collection)
Carrier
Schenker
DSV Avg. Weight per Shipment 2013 No’ of Shipments 2013 Baseline DHL Freight Schenker
DSV
251-500 Kg 148
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg 252 337 407 477 600 720
101-250 Kg
251-500 Kg
(per Kg) 0.85 0.39 0.44
(per Kg) 0.75 0.25* 0.25*
0.59 1.4 0.46 0.36*
0.36 0.6 0.33 0.31
501-1000 1001-1500 1501-2000 2001-2500 2501-3000 3001-3500 Kg Kg Kg Kg Kg Kg Requested Lead Provided Lead Time Time (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) (per Kg) 3-4 days 3-4 days 0.45 0.25 0.25 0.28 0.27 0.25 3-4 days 3 days 0.22* 0.19 0.17 0.16 0.14 0.11 0.25 0.18* 0.16* 0.15 0.14 0.14 3-4 days 3-4 days 3-4 days 0.38 0.35 0.35 0.35 0.35 0.20 3-4 days 3-4 days 0.28 0.19 0.16* 0.14* 0.12* 0.10* 3-4 days 3-4 days 0.27 0.25 0.22 0.16 0.14 0.13 3-4 days 2 days 0.22* 0.18* 0.16* 0.14* 0.13 0.12 3-4 days 2-4 days 1,190 14 4,718 4,165 3,165 2,999 0 5,831 3,165 4,332 2,999
• Schenker és DSV a legjobbak ebben a kategóriában
27
Total Spend 2013 (Shipments <3500KG) 4,614
101-250 Kg 100
Grand Total 4,718 4,165 3,165 2,999 5,831 3,165 4,332 2,999
% Diff vs current prices -12% -33% -36% +24% -33% -8% -36%
Összefoglalás Tekintve, hogy a tender az EU 17 gyáregységére szólt, míg jelen analízis csak a Magyarországi vonatkozásokat emeli ki, a döntés nem 100%-ban az analízis eredményét tükrözi. Jelen analízis súlyozott eredménye alapján a jelöltek: •DHL Freight •SEV Stante •Bi-KA
Kérdések?
28