LOOP - SIZE - XLSX Valeo

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 67

RFQ FNR COFOR

SCE
058008B
68563523AA Valeo
01
058008B
68563524AA Valeo
01
058008B
68563522AA Valeo
01
loop securization
(replace imposed Transport time and delivery F
safety stock)

Downs
Flexibility TRC -
(transport
time
KM TO full)
VILLE FLOW
PLANT

1
Skawina 106 direct 0.1811965812
1
Skawina 106 direct 0.1811965812
1
Skawina 106 direct 0.1811965812
1 0.5
2.5 1
2.5 2.5
1 0.25
1 0.25
1 0.25
1 0.25
2.5 5
2.5 3
1 0.5
1 1
2.5 4
2.5 4
Supplier need *
Transport time and delivery Frequency Internal PSA Stock
tbc

Downstream Loop - Shipping site to Gliwice


TRV CAD P CAD V In progress In house Supplier plant
(transport (delivery (delivery stock PSA Securization production need
time empty) frequency full) frequency PSA
empty)

1.2
0.1811965812 1 1 0.5
1.2
0.1811965812 1 1 0.5
1.2
0.1811965812 1 1 0.5

1,22 TRUCKS PER DAY every 2 days in case of


with rack mega trailer (96 per
2400*1200*775 truck) 40 empties per
or 0,9 mega trailer day
0.5 1 1 0.5
1 1 1 0.5
2.5 1 1 0.5
0.25 0.5 0.5 0.5
0.25 0.5 0.5 0.5
0.25 1 1 0.5
0.25 1 1 0.5
5 2 2 0.5
3 2 2 0.5
0.5 1 1 0.5
1 0.25 0.25 0.5
4 1 1 0.5
4 1 1 0.5
Downstream Packaging volume
TOTAL qty amortissement (DI)
loopsize (in "RFQ Volume
days) reference"

32
5.062393162393
32
5.062393162393
63
5.062393162393
Transport time and deliver

U
COMMENTAIRES CAPD
Transport time and delivery Frequency

Upstream loop
CAD V TRC TRV MAF TOTAL COMPLETE
upsteam LOOP
loop

0.5 2 2.5 2.5

2.5 2 4.5 4.5


4 2 6 6

2 2 4 4
2 4 6 6 46

2 2 4 4

2 2 4 4

4.25 2 6.25 6.25


3.5 2 5.5 5.5

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
FCLA - awarded supplier

packaging load qty invested unit price amortization amortization allocation


content (racks) (fix and period (years) volume cost per
variable part
costs)

V149 with special layer 101 590 € 2 311,785 0.20 €


60
special rack
490 1,338 € 4 444,653 1.73 €
1900*800*1005 8
special insert -BOX
1800 35 € 1 80,000 0.83 €
400*300*170 4
SPE112
260 382 € 4 444,652 0.27 €
1200*1000*900 32

SPECIAL RACK
106 1,180 € 1 25,546 5.11 €
1900*1200*1005 12

246 1207 4 462900 0.75


RFQ Request for quotation (supplier's feed back)

FCLA and STUDY PROTOTYPES serial tooling A CONT STUDY


RFQ request packaging
for pack costs
(supplier
version)

\\yvsn0003\Pool_SCE\Projets\X250\EPB Prime(Etriers motorisés)-A NO

\\yvsn0003\Pool_SCE\Projets\X250\EPS (DAE) Marion ATTANE - NEX NO

\\yvsn0003\Pool_SCE\Projets\X250\ESC Prime (ESP-bloc hydraulique- NO


\\yvsn0003\P 2 YES 8,000 €

\\yvsn0003\Pool_SCE\Projets\X250\FRONT GRILL X250+_FAC-000212 YES 8,000 €

\\yvsn0003\P 2500 2800 1185 0 YES 8000


YES
YES
PROTOTYPES serial tooling UNIT RACK
packaging PRICE '
costs PSA'
10,000 € 454 € 6,500 €

3,200 € 880 € - €

5000 1000 0 1,052.85 €


10/18/2022 transp
Carole IFFENECKER Supplier need
Flexibility internal need
Tpt full
PACKAGING Empties
SUPPLIER PLANT CUSTOMER PLANT
CODE QUANTITY shipment
IT83 PRATOLAGL GLIWICE 66858B 6 Hyp. 1 : daily r 2.5 1 4
Hyp. 2 : full tr 2.5 1 4

Input data - packaging : L w h h/f qty tare kg


2400 1560 1000 520 6 350
total Weigh full Ton :

Input data - truck load : containers max per truck, volume :


Full 1 8 3 24
Empty 1 8 6 48

container max per truck, Weight :


Full 15
Empty :

CUSTOMER ANNUAL PACKAGING


SUPPLIER PLANT PLANT VOLUMES ADC CODE QUANTITY
Input data - volumes Gliwice :
YEAR 2023
IT83 PRATOLA GL GLIWICE 68000 296 66858B 6
YEAR 2024
IT83 PRATOLA GL GLIWICE 97000 422 66858B 6
YEAR 2025
IT83 PRATOLAGL GLIWICE 78000 340 66858B 6
transport Plant
TOTAL
LOOP
Frenqyency In progress stock plant
Tpt empty Frequency full empty in plant securization
RACK qty RACK qty
for 2023 for 2024
4 1 1 0.5 1.7 15.7 775 1,105
4 1 3 0.5 1.7 17.7 874 1,245

part w.kg
195
1.52

ET PARTS ET EMPTIES

3.3 1.03

4.7 1.47

3.8 1.18
RACK qty
for 2025
890
1,003
TRC 0.5
CAD P 1
PART FNR EC 0.5
? SECU 2.2

fnr usine PSA

flex
2.5
TRV 0.5
CAD V 1
09/11/2021 UPDATE!
rack 41017 10

2400 1900 1495 racks per truck parts per truck


per truck 1 7 2 14 140
trucks per day 4
containers per truck :
6 x 2 x 1
parts per truck
120

peak year : 2024 126401


Prod. Days per year 230
Daily consumption : 550
trucks per day : 5
12
TRC - CAD P CAD V
TRV In house
(transport (delivery (delivery In progress
Flexibility (transport Securization
time frequency frequency stock PSA
time empty) PSA
full) full) empty)

1 0.5 0.5 0.11 0.11 0.5 1.2

Assumption : per truck UNIT COST


36% 4800 1200 1495 10 80 1,600 €
316 2 2 2 8
L/R

64% 4500 1200 1495 10 120 1,500 €


562 3 2 2 12
L/R

26/01/2022 new version : RR RAIL as single component

TRC - CAD P CAD V


TRV In house
(transport (delivery (delivery In progress
Flexibility (transport Securization
time frequency frequency stock PSA
time empty) PSA
full) full) empty)

1 0.3 0.3 0.5 0.5 0.5 1.2


Supplier Downstream
plant TOTAL
production loopsize (in
need days)
Kielce > Gl
3.9 185 km
0,3 > 0,5

trucks per day


4.0

ASSY VERSION !!

4.7

8.6

Supplier Downstream
plant TOTAL
production loopsize (in
need days)

1 5.3
PN Part name ITA PN PSA Part name ENG 1) COFOR sender
FCA

53427126 OSSATURA PORTA 1440358780 00 FRONT DOOR INNER RH 97919


53427156 OSSATURA PORTA 1440358880 00 FRONT DOOR INNER LH 97919
1340567080 ESTERNO PORTA C 1440509980 00 FRT DOOR OUTER/PANEL DOOR RH 97919
1340572080 ESTERNO PORTA C 1440510080 00 FRT DOOR OUTER/PANEL DOOR LH 97919
1340750080 PASSARUOTA ANTE 1440749380 00 FRT PART LH OTR RR WHEEL ARCH 97911
1340752080 PASSARUOTA ANTE 1440748080 00 FRT PART RH OTR RR WHEEL ARCH 97911
1342165080 LONGHERINA CENT 1440363480 00 RIGHT FRONT DOOR CENTRE SIDE MEMBER 97911
1342171080 LONGHERINA CENT 1440510280 00 LEFT FRONT DOOR CENTRE SIDE MEMBER 97911
1343960080 ESTERNO BATTENT 1440414580 00 REAR DOOR OUTER LH WINDOW H3 94164
1343963080 ESTERNO BATTENT 1440414680 00 REAR DOOR OUTER LH VAN H3 94165
1343976080 ESTERNO BATTENT 1440414980 00 REAR DOOR OUTER RH WINDOW H3 94164
1343979080 ESTERNO BATTENT 1440415080 00 REAR DOOR OUTER RH VAN H3 94165
1344007080 INTELAIATURA SX 1440751980 00 LINING HINGED DOOR RR LH PART UPR 94164
1345994080 INTELAIATURA DX 1440748580 00 LINING HINGED DOOR RR RH PART UPR 94164
1346501080 RINFORZO LAT. F 1440339980 00 RR SEAT RH FIX REINF 94164
1347660080 ESTERNO PORTA C 1440363080 00 FRT DOOR OUTER/PANEL DOOR RH 97919
1347662080 ESTERNO PORTA C 1440414280 00 FRT DOOR OUTER/PANEL DOOR LH 97919
1349939080 ESTERNO PORTA C 1440362980 00 FRT DOOR OUTER/PANEL DOOR RH 97919
1349943080 ESTERNO PORTA C 1440414180 00 FRT DOOR OUTER/PANEL DOOR LH 97919
1374186080 RIVESTIMENTOEST 1440359180 00 PANEL HOOD OTR 97919
1374378080 PARAFANGO ANT. 1440352280 00 FENDER/WING FRT RH 97919
1374379080 PARAFANGO ANT. 1440352380 00 FENDER/WING FRT RH 97919
1374389080 PARAFANGO ANT. 1440352680 00 FENDER/WING FRT LH 97919
1374390080 PARAFANGO ANT. 1440352780 00 FENDER/WING FRT LH 97919
1380668080 OSSATURA COFANO 1440661480 00 PANEL HOOD INR 97919
1346531080 RINFORZO LAT. F 0 94164

Before info from Christian P. :


100,000

City sender/Ville Expéditeur ZIP sender /CP Country Supplier name/Raison Sociale Expéditeur ASSUMED VOLUMES PER Packaging
Expéditeur PENETRATION MONTH Code

PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 1.00 8,333 8601
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 1.00 8,333 8601
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.77 6,417 8969
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.77 6,417 8969
TORINO 10135 ITA FCA MIRAFIORI (FCA ITALY) 0.98 8,177 4060
TORINO 10135 ITA FCA MIRAFIORI (FCA ITALY) 0.98 8,177 4060
TORINO 10135 ITA FCA MIRAFIORI (FCA ITALY) 0.98 8,177 4888
TORINO 10135 ITA FCA MIRAFIORI (FCA ITALY) 0.98 8,177 4888
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.00 8 8863
VILLA SANTA LUCIA 3003 ITA FCA CASSINO STAMP (FCA ITALY) 0.04 361 8863
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.00 8 1284
VILLA SANTA LUCIA 3003 ITA FCA CASSINO STAMP (FCA ITALY) 0.04 361 1284
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.04 369 41210
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.04 369 41210
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.16 1,302 4060
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.18 1,500 8969
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.18 1,500 8969
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.05 417 8969
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.05 417 8969
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 1.00 8,333 1271
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.80 6,667 1515
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.20 1,667 1515
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.80 6,667 1517
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 0.20 1,667 1517
PIEDIMONTE S.GERMANO 3030 ITA CASSINO STAMPAGGIO (FCA ITALY) 1.00 8,333 1235
CASSINO 3043 ITA FCA CASSINO STAMP (FCA ITALY) 0.01 109 4060
PACKAGING INFORMATION FCA

Parts per Type of packaging Rack Lenght Rack Width Rack Height VALIDATION Daily consumption
packaging (mm) (mm) (mm)

55 Special Rack 1350 1200 1950 FCA rack c/o PSA 435
55 Special Rack 1350 1200 1950 FCA rack c/o PSA 435
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 335
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 335
200 Standard metallic rack 1450 1100 780 PSA STANDARD
200 Standard metallic rack 1450 1100 780 PSA STANDARD
1900 Standard metallic rack 1450 1100 780 PSA STANDARD
1900 Standard metallic rack 1450 1100 780 PSA STANDARD
35 Special Rack 2385 1200 1300 FCA rack c/o PSA 1
35 Special Rack 2385 1200 1300 FCA rack c/o PSA 19
35 Special Rack 2410 1210 1300 FCA rack c/o PSA 1
35 Special Rack 2410 1210 1300 FCA rack c/o PSA 19
28 SEPCIAL METALLIC RACK 1900 800 760 PSA SPECIAL 20
28 SEPCIAL METALLIC RACK 1900 800 760 PSA SPECIAL 20
800 Standard metallic rack 1450 1100 780 PSA STANDARD
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 79
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 79
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 22
80 Special Rack 1350 1200 1950 FCA rack c/o PSA 22
20 Special Rack 2005 1605 1010 FCA rack c/o PSA 435
40 Special Rack 2400 1005 1450 FCA rack c/o PSA 348
40 Special Rack 2400 1005 1450 FCA rack c/o PSA 87
40 Special Rack 2400 1005 1450 FCA rack c/o PSA 348
40 Special Rack 2400 1005 1450 FCA rack c/o PSA 87
90 Special Rack 2005 1210 805 FCA rack c/o PSA 435
550 Standard metallic rack 1450 1100 780 tbc
rack per truck trucks per day Estimation
supplier need

20 0.40 3
20 0.40 3
20 0.21 3
20 0.21 3

20 0.00 5
20 0.03 5
22 0.00 5
22 0.02 5
63 0.01 5
63 0.01 5

20 0.05 5
20 0.05 5
20 0.01 5
20 0.01 5
24 0.91 2
26 0.33 3
26 0.08 5
26 0.33 3
26 0.08 5
36 0.13 5
PART NAME Part number' condi uc
B-PILLAR INNER ASM - RH PN65 RT032 42
B-PILLAR INNER ASM - LH PN66 RT032 42
SUBASSEMBLY SEGMENT AB 3 - RH PN78 RT036 48
UPPER TRACK ASM RIGHT SLD – H2 - RH PN83 RT043 11
UPPER TRACK ASM RIGHT SLD – H2 - LH PN84 RT044 11
UPPER TRACK ASM RIGHT SLD – H3 - RH PN85 RT045 6
UPPER TRACK ASM RIGHT SLD – H3 - LH PN86 RT046 6
CROSSMEMBER REAR -1 PN96 RT059 90
CROSSMEMBER REAR -1 PN97 RT059 90
TEMP P/N LHD RHD H1 H2

1500 x 800 x 1495 1005 PN65 x x x x


1500 x 800 x 1495 1005 PN66 x x x x
2250 x 800 x 1495 1495 PN78 x x x x
2650 x 1200 x 1495 1495 PN83 x x x
2650 x 1200 x 1495 1495 PN84 x x x
2400 x 1200 x 1495 1495 PN85 x x
2400 x 1200 x 1495 1495 PN86 x x
1350 x 1200 x 1495 1495 PN96 x x
1350 x 1200 x 1495 1495 PN97 x x
H3 L2 L2-S L3 L4 L4+ SC

x x x x x
x x x x x
x
x x x x
x x x x
x x x x x
x x x x x
x x
x x x x
Volume
CMJ pack dimens dimens dimens
DC Van share Volume
moyenne per day ions ions ions
[%]

x 67.52 70,017 305 8 1500 800 1495


x 67.52 70,017 305 8 1500 800 1495
x 13.11 13,595 60 2 2250 800 1495
x 59.16 61,347 267 25 2650 1200 1495
x 59.16 61,347 267 25 2650 1200 1495
x 5.21 5,403 24 4 2400 1200 1495
x 5.21 5,403 24 4 2400 1200 1495
18.82 19,516 85 1 1350 1200 1495
x x 18.82 19,516 85 1 1350 1200 1495
POLMOTORS
KIRCHHOFF
LOOP

LOOP
L w h Pack/truck Truck/day CAD P

9 3 2 54 0.15 1
9 3 2 54 0.15 1
6 3 2 36 0.06 1
5 2 2 20 1.25 1
5 2 2 20 1.25 1
5 2 2 20 0.20 1
5 2 2 20 0.20 1
10 2 2 40 0.03 1
10 2 2 40 0.03 1
27.41
LOOP PROMA ASSUMPTON CARRY OVER FROM ITALY

TRC - CAD P CAD V


TRV In house
(transport (delivery (delivery In progress
Flexibility (transport Securization
time frequency frequency stock PSA
time empty) PSA
full) full) empty)

2.5 3 3 1 1 0.5 2.2


2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
2.5 3 3 1 1 0.5 2.2
Downstrea
Supplier

C/O ITALY
m
plant
TOTAL
production
loopsize (in
need
days)

3 16.2
3 16.2
5 18.2
3 16.2
3 16.2
5 18.2
5 18.2
5 18.2
5 18.2
Volume
NX Assemblies Data
Part name TEMP P/N LHD RHD H1 H2 H3 L2 L2-S L3 L4 L4+ SC DC Van share Volume
Assemblies Number Number Revision
[%]
removed
ASM DASH UPPER - LHD FA00AAJ63584 1375588080 12 PN27 x xATESSA
x x x x x x x x x x 85 126,005
ASM DASH UPPER - RHD FA00AAM55596 1375589080 8 PN28 x x x x x x x x x x x x 15 22,236
ASM ROCKER REAR VAN L2 - RH FA00AAH52565 1371881080 16 PN29 x x x x x x x 27 40,025
ASM ROCKER REAR VAN L2 - LH FA00AAN71911 1379739080 5 PN30 x x x x x x x 27 40,025
ASM ROCKER REAR VAN L3 / L4 - RH FA00AAH52568 1371882080 16 PN31 x x x TYCHY
x x x x x 40 59,296
ASM ROCKER REAR VAN L3 / L4 - LH FA00AAN71915 1379740080 5 PN32 x x x x x x x x 40 59,296
ASM UPPER CROSSMEMBER -1 AGV74130 1343071080 18 PN37 x x x x x x x x x x 79 117,584
Rear D Pillar outer RH H2 FA00AAT35117 1384491080 9 PN44 x x x x x x x x 59 87,699
Rear D Pillar outer LH H2 FA00AAT38092 1384492080 4 PN45 x x x x x x x x 59 87,699
Rear D Pillar outer RH H3 FA00AAT38314 1384493080 9 PN46 x x x x x x x x 5 7,723
Rear D Pillar outer LH H3 FA00AAT39635 1384494080 9 PN47 x x x x x x x x 5 7,723
REINFORCEMENT B-PILLAR UPPER H2 - RH FA00AAJ15579 1372867080 13 PN50 x x x x x x x x 59 87,699
REINFORCEMENT B-PILLAR UPPER H2 - LH FA00ADF90782 53474872 3 PN51 x x x x x x x x 59 87,699
7/15/2021 information from HOLGER BECKER :
Longueur largeur hauteur qty
2250 2400 1005 6

TRUCK
13500 2400 3150
6 1 3 CONT/CAMION PIECES/CAMI camions/jour
18 108 5

ASSY 9 2400x2100x1495

TRUCK
2.4 13.5 3.15
CONT/CAMION PIECES/CAMI camions/jour
1 6 2 12 108

AT4

OU TD
99153 PEAK YEAR SCCR (version from Victoria)
CMJ 431.1

E D emballage

T D AT
U
km to Gliwice
Hlohovec 290
Nitra 317
Liban 339
Namestovo 148
Name Capacity Tare Weight [Length [mm] Width [mm] Height [mm] Height Folded [mm]
RACK 8 155 2400 1350 900 900

Rack/truck 1 10 3 30
Parts/truck 240

450
1.875
wrong figures

2021 2022 2023 2024 2025 2026


project 458 26886 10079 1244
RFQ 366 21509 8063 995

PEAK
CMJ 117
eight Folded [mm]

average X250 + CMJ


TRUCKS PER DAY

2027
UC
SPE FRT GRIL Supplier No SUSTAINABLE 12 1900 x 1200 x 1005 1005
M3 2.3

1900 1200 1005


7 2 3 SRX ! Maybe SRD

cont/ per truc 42


parts per truc 504

Waiting for industrial data !

In SCCR, peak year, volume mentionned is : 20000


CMJ ? 87

Gliwice Total Volumen 31963 2021 2022 2023


466 21204 10262
CMJ (230 days) 92
cont/j 8
M3/j 18

JUST FOR INFO :


241.2

TOTAL Amortization volume


31932 80% 25546
Project Volume Reference from Start of mass production: end of life” volume for X250: 1.884.597 units
2023 2024 2025 2026 2027 2028 2029
X250 97.308 149.357 156635 152.515 147.586 142.455 140.318

RFQ volume Reference from Start of mass Production


2023 2024 2025 2026 2027 2028 2029
X250 77846 119486 125308 122012 118068 113.964 112.255
562720
2030 2031 2032 2033 2034 2035 2036 2037
136.811 132.022 127.401 125.490 122.353 118.071 113.938 22.336

2030 2031 2032 2033 2034 2035 2036 2037


109.448 105.618 101.921 100.392 97.882 94.457 91.151 17.869
volumes from 2020 : Obsolete

2023 2024 2025 2026 2027


yearly vol. 6,434 11,948 14,693 15,356 16,211
daily 27 51 63 65 69

Nouvelle hypothèse de volume à prendre en compte : 56 000 Veh/ an sur 6 ans…


info Wladimir 16/02/2021
année démarrage à confirmer…
56000
243
1500 800 1005 racks per truck parts per truck truck per day
9 3 3 81 1053 0.23

You might also like