XBB - Forecast - Dec23th2022 - SGI

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

NOVO

PN 202317 202318 202319


886517859R 3964560 FRAME_RR_BACK_REST - encosto traseiro 95
873519674R 3966559 FRM ASM_FC_LH - assento esquerdo
876514220R 3966612 FRM ASM_FB_LH_XBB - encosto esquerdo
873018824R 3966560 FRM ASM_FC_RH - assento direito
876011214R 3966613 FRM ASM_FB_RH_XBB - encosto direito
874014902R 3966617 RCL ADJ ASM_RH
874510696R 3966616 RCL ADJ ASM_LH
875361812R 3967510 TOWEL_BAR
883461154R 3966207 LOCK ASSY LH
883466865R 3966206 LOCK ASSY RH
875522790R 3972329 SLIDE_INN_LH_XBB 488 1980 2444
875519165R 3972328 SLIDE_OTR_LH_XBB 488 1980 2444
875019086R 3972330 SLIDE_OTR_RH_XBB 488 1980 2444
875024052R 3972331 SLIDE_INN_RH_XBB 488 1980 2444

# Confidential C
202320 202321 202322 202323 202324 202325 202326 202327 202328
2359 2344 2436 1970 2389 2075 1426 1241 1238
1980 2436 1970 2389 2075 1426 1241 1238
1980 2436 1970 2389 2075 1426 1241 1238
1980 2436 1970 2389 2075 1426 1241 1238
95 2360 1970 2389 2075 1426 1241 1238
1980 2440 1970 2390 2070 1430 1240 1240
1980 2440 1970 2390 2070 1430 1240 1240
16 352 1680 2480 2480
22 220 1012 1232 1254
22 220 1012 1232 1254
2452 2344 2436 1968 2392 2072 1428 1240 1240
2452 2344 2436 1968 2392 2072 1428 1240 1240
2452 2344 2436 1968 2392 2072 1428 1240 1240
2452 2344 2436 1968 2392 2072 1428 1240 1240

# Confidential C
PN Description Supplier Qtty per car

Necessity
3966256 RISER RR OTR FC XBB - SGI 2
3966264 SUBMARINE_PIPE SUB ASM XBB - SGI 2
3966274 RISER RR INN SUB ASM_FC_LH XBB - SGI 1
3966275 RISER RR INN SUB ASM_FC_RH XBB - SGI 1
3966280 SIDE BRKT_SUB_ASM_FC_LH XBB - SGI 1
3966281 SIDE BRKT_SUB_ASM_FC_RH XBB - SGI 1
3966287 SIDE_BRKT_SUB_ASM_INN_LH XBB - SGI 1
3966288 SIDE_BRKT_SUB_ASM_INN_RH XBB - SGI 1
3966294 SIDE_BRKT_SUB_ASM_OUT_LH XBB - SGI 1
3966295 SIDE_BRKT_SUB_ASM_OUT_RH XBB - SGI 1
3966598 SIDE BRKT SUB ASM_FB_LH XBB - SGI 1
3966599 SIDE BRKT SUB ASM_FB_RH XBB - SGI 1
3966606 FB_FREE_HINGE_BRKT_SUB_ASM_LH XBB - SGI 1
3966607 FB_FREE_HINGE_BRKT_SUB_ASM_RH XBB - SGI 1
Necessity
3963142 MAIN PIPE XBB XBB - SGI 1
3963143 LWR_PIPE XBB - SGI 1
3964421 BRKT LOCK ASM_2NDB FRM RH XBB - SGI 1
3964422 BRKT LOCK ASM_2NDB FRM LH XBB - SGI 1
3964437 BRKT_HEADREST_FREE XBB - SGI 3
3964438 BRKT_HEADREST_LOCK XBB - SGI 3
3964522 ESCUT_BRKT_SUB_ASM XBB - SGI 1
3964534 RETRACTOR_BRKT_SUB_ASM XBB - SGI 1
3964537 VERTICAL_SQUARE_PIPE_UPR XBB - SGI 2
3964538 VERTICAL_SQUARE_PIPE_LWR XBB - SGI 2
3964539 HORIZONTAL_SQUARE_PIPE XBB - SGI 1
3964550 VERTICAL_CTR_JOINT XBB - SGI 2
3964551 HORIZONTAL_SIDE_JOINT XBB - SGI 2
3964554 HINGE_PIN_XBB XBB - SGI 2
Necessity
3967510 TOWEL_BAR XBB - SGI 2

# Confidential C
Safety Stock at Safety Stock at
Need 2023 Shipments Faurecia= 417 Faurecia= 417 Need 2023 + Purchase request
cars X 25 days cars X 25 days safety Stock
(parts) (pallets)
86342 10425 461
172684 25 20850 4 193534 204000
172684 38 20850 24 193534 195300
86342 41 10425 15 96767 97300
86342 41 10425 15 96767 97300
86342 30 10425 11 96767 97920
86342 30 10425 11 96767 97920
86342 33 10425 5 96767 101400
86342 33 10425 5 96767 101400
86342 27 10425 7 96767 97600
86342 27 10425 7 96767 97600
86342 40 10425 15 96767 97200
86342 40 10425 15 96767 97200
86342 31 10425 4 96767 98000
86342 31 10425 4 96767 98000
88796
88796 42 10425 194 99221 99252
88796 33 10425 16 99221 99750
88796 22 10425 6 99221 99960
88796 22 10425 6 99221 99960
266388 34 31275 5 297663 302640
266388 34 31275 5 297663 302640
88796 23 10425 3 99221 101400
88796 36 10425 5 99221 100000
177592 25 20850 6 198442 201600
177592 42 20850 5 198442 201600
88796 35 10425 21 99221 99450
177592 39 20850 5 198442 202500
177592 40 20850 10 198442 200200
177592 25 29190 5 206782 208800
80864
161728 34 20850 27 182578 183200

# Confidential C
SHIPMENT forecast

STATUS W1 W2 W3 W4 W5 W6 W7 W8 W9 W10

95 2359 2344
OK 6800 6800 6800 6800 6800
OK 4500 4500 4500 4500 4500 5400
OK 2100 2100 2100 2100 2100 2800
OK 2100 2100 2100 2100 2100 2800
OK 2880 2880 2880 2880 2880
OK 2880 2880 2880 2880 2880
OK 2600 2600 2600 2600 2600 5200
OK 2600 2600 2600 2600 2600 5200
OK 4800 3200 3200 3200
OK 4800 3200 3200 3200
OK 2160 2160 2160 2160 2160 2880
OK 2160 2160 2160 2160 2160 2880
OK 2800 2800 2800 2800 2800
OK 2800 2800 2800 2800 2800
95 2359 2344
OK 2106 2106 2106 2106 2106 2430 2322
OK 3990 3325 3325 2660 2660
OK 4080 4080 4080 4080
OK 4080 4080 4080 4080
OK 7760 7760 7760 7760 7760 7760
OK 7760 7760 7760 7760 7760 7760
OK 3900 3900 3900 3900
OK 2500 2500 2500 2500 2500 2500 2500
OK 7200 7200 7200 7200 7200
OK 4200 4200 4200 4200 8400 4200 4200
OK 3570 3570 3570 2550 2550
OK 4500 4500 4500 4500 4500 4500 4500
OK 4400 4400 4400 4400 4400 4400 4400
OK 7200 7200 7200 7200 7200 7200

OK 5600 5600 5600 4800

# Confidential C
ast

W11 W12 W13 W14 W15 W16 W17 W18 W19 W20 W21 W22

2436 1970 2389 2075 1426 1241 1238 1314 1317 1646 1646 1646
6800 6800 6800 6800 6800 6800
5400 4500 4500 4500 4500 4500 4500 4500 4500
2800 2100 2800 2100 2100 2100 2100 2100 2100
2800 2100 2800 2100 2100 2100 2100 2100 2100
2880 2880 2880 2880 2880 3840 2880
2880 2880 2880 2880 2880 3840 2880
2600 2600 2600 2600 2600 2600 2600
2600 2600 2600 2600 2600 2600 2600
3200 3200 3200 3200 3200 3200 3200
3200 3200 3200 3200 3200 3200 3200
2880 2880 2880 2880 2880 2880 2880
2880 2880 2880 2880 2880 2880 2880
2800 2800 2800 2800 2800 2800 2800 2800
2800 2800 2800 2800 2800 2800 2800 2800
2436 1970 2389 2075 1426 1241 1238 1314 1317 1646 1646 1646
2430 2106 2214 2106 2106 2106 2106 2106 2106 2106
2660 3990 3990 2660 3325 2660 2660
4080 4080 4080 4080 4080
4080 4080 4080 4080 4080
7760 7760 7760 7760 7760 7760 7760 7760
7760 7760 7760 7760 7760 7760 7760 7760
3900 3900 3900 3900 3900 3900
2500 2500 2500 2500 2500 2500 2500 2500
7200 7200 7200 7200 7200
4200 4200 4200 4200 4200 4200 4200 4200 4200
2550 2550 2550 2550 2550 2550 2550 2550
4500 4500 4500 4500 4500 4500 4500 4500 4500
6600 4400 4400 4400 4400 4400 4400 4400 4400
7200 7200 7200 7200 7200 7200
16 352 1680 2480 2480 2640 2624 1646 1646 1646
4800 4800 4800 4800 4800 4800 4800 4800

# Confidential C
W23 W24 W25 W26 W27 W28 W29 W30 W31 W32 W33 W34

1646 1646 2510 2510 2510 2510 2477 2477 2477 2477 2399 2399
6800 6800 6800 6800 6800 6800 6800 6800
4500 4500 4500 4500 4500 4500 4500 4500 4500 5400 4500 4500
2100 2100 2100 2100 2100 2800 2800 2100 2800 2100 2800 2100
2100 2100 2100 2100 2100 2800 2800 2100 2800 2100 2800 2100
3840 3840 2880 2880 2880 2880 2880 2880 2880
3840 3840 2880 2880 2880 2880 2880 2880 2880
2600 2600 2600 2600 2600 2600 2600 2600 2600 2600 2600
2600 2600 2600 2600 2600 2600 2600 2600 2600 2600 2600
3200 3200 3200 3200 3200 3200 3200 3200
3200 3200 3200 3200 3200 3200 3200 3200
2880 2880 2880 2880 2880 2880 2880 2880 2880 2880
2880 2880 2880 2880 2880 2880 2880 2880 2880 2880
2800 2800 2800 2800 2800 2800 2800 2800 2800 2800
2800 2800 2800 2800 2800 2800 2800 2800 2800 2800
1646 1646 2510 2510 2510 2510 2477 2477 2477 2477 2399 2399
2106 2538 2484 2538 2484 2484 2484 2484 2484 2376 2430
2660 2660 3325 2660 2660 2660 2660 2660 2660 2660
4080 4080 4080 4080 4080 4080 4080
4080 4080 4080 4080 4080 4080 4080
7760 7760 7760 7760 7760 7760 7760 7760 7760 7760 7760
7760 7760 7760 7760 7760 7760 7760 7760 7760 7760 7760
3900 3900 3900 3900 3900 3900 3900
2500 2500 2500 2500 2500 2500 2500 2500 2500 2500 2500
7200 7200 7200 7200 7200 7200 7200 7200
4200 4200 4200 4200 8400 4200 4200 4200 4200 8400 4200 4200
2550 2550 2550 2550 2550 2550 2550 2550 2550 2550 2550
4500 4500 4500 4500 4500 4500 4500 4500 9000 4500 4500 4500
4400 4400 4400 4400 4400 4400 4400 4400 6600 4400 4400 4400
7200 7200 7200 7200 7200 7200 7200
1646 1646 2510 2510 2510 2510 2477 2477 2477 2477 2399 2399
4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800

# Confidential C
SHIPMENT

W35 W36 W37 W38 W39 W40 W41 W42 W43 W44 W45 W46

2399 2399 2399 1307 1307 1307 1307 1307 1307 1307 1307 2477
6800 6800 6800 6800 6800 6800
5400 4500 4500 4500 4500 4500 4500 4500 4500
2800 2100 2800 2100 2100 2100 2100 2100 2100
2800 2100 2800 2100 2100 2100 2100 2100 2100
2880 2880 2880 2880 2880 2880 2880
2880 2880 2880 2880 2880 2880 2880
2600 2600 2600 2600 2600 2600 2600 2600
2600 2600 2600 2600 2600 2600 2600 2600
3200 3200 3200 3200 3200 3200 3200
3200 3200 3200 3200 3200 3200 3200
2880 2880 2880 2880 2880 2880 2880
2880 2880 2880 2880 2880 2880 2880
2800 2800 2800 2800 2800 2800 2800
2800 2800 2800 2800 2800 2800 2800
2399 2399 2399 1307 1307 1307 1307 1307 1307 1307 1307 2477
2376 2376 2430 2106 2106 2106 2106 2106 2376
2660 3325 2660 2660 2660 2660 2660
4080 4080 4080 4080 4080
4080 4080 4080 4080 4080
7760 7760 7760 7760 7760 7760 7760 7760
7760 7760 7760 7760 7760 7760 7760 7760
3900 3900 3900 3900 3900
2500 2500 2500 2500 2500 2500 2500 2500
7200 7200 7200 7200 7200 7200
4200 4200 4200 4200 4200 4200 4200 4200 4200
2550 2550 2550 2550 2550 2550 2550 2550
4500 4500 4500 4500 4500 4500 4500 4500 4500
6600 4400 4400 4400 4400 4400 4400 6600 6600
7200 7200 7200 7200 7200 7200
2399 2399 2399 1307 1307 1307 1307 1307 1307 1307 1307 2477
4800 4800 4800 4800 4800 4800 4800 4800 4800

# Confidential C
MOQ PARTS

W47 W48 W49 W50 W51 W52 MOQ parts MOQ paletts Parts/ Parts/box
palett

2477 2477 2477 2685 2685 2685


6800 6800 6800 6800 6800 6800 1 6800 68
4500 4500 4500 5400 5400 5400 4500 5 900 15
2100 2800 2100 2800 2800 2800 2100 3 700 14
2100 2800 2100 2800 2800 2800 2100 3 700 14
2880 2880 2880 2880 2880 2880 3 960 16
2880 2880 2880 2880 2880 2880 3 960 16
2600 2600 2600 2600 2600 2600 2600 1 2600 52
2600 2600 2600 2600 2600 2600 2600 1 2600 52
3200 3200 3200 3200 3200 2 1600 16
3200 3200 3200 3200 3200 2 1600 16
2880 2880 2880 2880 2880 2160 3 720 16
2880 2880 2880 2880 2880 2160 3 720 16
2800 2800 2800 2800 2800 2800 1 2800 70
2800 2800 2800 2800 2800 2800 1 2800 70
2477 2477 2477 2685 2685 2685
2484 2484 2484 2700 2646 2700 2106 39 54 54
2660 2660 2660 2660 4655 2660 4 665 665
4080 6120 4080 4080 2 2040 34
4080 6120 4080 4080 2 2040 34
7760 7760 7760 7760 7760 7760 7760 1 7760 97
7760 7760 7760 7760 7760 7760 7760 1 7760 97
3900 3900 3900 3900 3900 1 3900 39
2500 2500 2500 2500 2500 2500 2500 1 2500 25
7200 7200 7200 7200 7200 2 3600 60
8400 4200 4200 4200 4200 8400 4200 1 4200 42
2550 3060 3060 3060 3060 2550 5 510 510
4500 4500 4500 4500 4500 9000 4500 1 4500 45
6600 6600 6600 6600 4400 2 2200 110
7200 7200 7200 7200 7200 1 7200 180
2477 2477 2477 2685 2685 2685
4800 4800 6400 6400 4800 4800 6 800 16

# Confidential C

You might also like