Supplier 20-21 Ppm.

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

AC TA

TU RG
AL ET
PP PP
M M
OVERALL SUPPLIERS PPM DETAIL
OVERALL
MONTH Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 (APR-MAR 20)

TOTAL
0 0 0 10117 0 5 10122
REJECTION QTY

TOTAL RECEIVED QTY 279 81719 384737 676564 1248369 1372143 3763810

ACTUAL PPM 0 0 0 14954 0 4 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 2689

TARGET PPM 50 50 50 50 50 50 50 50 50 50 50 50 50

Chart Title
16000
14000
12000
10000
8000
6000
4000
2000
0
43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 OVERALL
(APR-MAR
20)

ACTUAL PPM TARGET PPM


Autoline Inhouse Rejection % vs Sale
OVERALL
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 (APR-MAR
18)

Plot no 5&6 25309 17170 60202 30343 45471 36857 15294 37388 75427 343461

Plot No 8 71183 118785 66530 126974 178286 122934 113844 83920 184382 1066838

Total Rejection
96492 135955 126732 157317 223757 159791 129138 121308 259809 0 0 0 1410299
cost

Total Sale 75125269 73537011 81510761 106102520 111535234 95424932 78910535 129027454 132258508 883432223

Rej % 0.13 0.18 0.16 0.15 0.20 0.17 0.16 0.09 0.20 #DIV/0! #DIV/0! #DIV/0! 0.16

In-House Rejection %
0.25

0.20 0.20
0.20
0.18
0.17 0.16
0.16 0.16
0.15
0.15
0.13

0.10 0.09

0.05

0.00
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 OVERALL
(APR-MAR
18)
IN- HOUSE SALES VS REJECTION %
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Press Shop (Plot 73950 126583 77606 130805 184852 127936 117381 88468 189127 1116709
No. 06,08)

Weld shop 20323 9372 49125 26512 38906 31854 11757 32839 70682 291370

Total Sale 75125269 73537011 81510761 106102520 111535234 95424932 78910535 129027454 132258508 883432223

Press Shop Rej % 0.10 0.17 0.10 0.12 0.17 0.13 0.15 0.07 0.14 #DIV/0! #DIV/0! #DIV/0! 0.13

Weld Shop Rej % 0.03 0.01 0.06 0.02 0.03 0.03 0.01 0.03 0.05 #DIV/0! #DIV/0! #DIV/0! 0.03

In- House Rejection %


0.17
0.18 0.17

0.16 0.15
0.14
0.13
0.14 0.12 0.13

0.12
0.10 0.10
0.10

0.08 0.07
0.06
0.05
0.06
0.03 0.03 0.03
0.04 0.03 0.02 0.03
0.01 0.01
0.02

0.00
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg

Press Shop Rej % Weld Shop Rej %


Customer PPM
OVERALL (APR- Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18
Month MAR 17) Apr-17 May-17 Jun-17
A68763 A68365 A68763 A68365 A68763 A68365 A68763 A68365 A68763 A68365 A68763 A68365

Rej Qty 5477 89 127 107 52 12 220 149 47 110 4 57 122 147 179 234

RSD 1708 0 0 158 71 40 140 0 19 0 10 35 50 96 1 54

Total Rejection qty 6673 89 127 218 102 40 318 149 60 110 11 82 157 214 180 272 0 0

Total Dispatch 9588280 693626 763112 538250 291827 560907 253911 477431 273538 523405 287345 633201 312014 651657 324728 677132

Overall Rej Qty 142 467 170 93 371 452

Overall Dispatch Qty 852734 731342 796943 920546 963671 1001860

Over all PPM 128 166 404 166 639 214 100 385 451

Over all PPM 696 128 166 404 348 71 1252 312 220 210 38 129 503 329 553 401 #DIV/0! #DIV/0!

Target 500 500 400 400 400 400 400 300 300 300 300 200 200 200 200 200 150

1400
Customer PPM

1252
1200

1000

800

600 696
553
500 503
400 500 400 400 400 400 400 220
401
348 329
312 300 300 300 300
404
200 210 200 200 200 200 200
166 150 1
128 129
71
38
0
OVERALL 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160
(APR-MAR
17)
mer PPM
Mar-18 Avg

1656

674

0 2127.8

7262084

#DIV/0! 293

150 200

er PPM

553
503
401
329
00 300 300 293
10 200 200 200 200 200 200
129 150 150
38
43009 43040 43070 43101 43132 43160 Avg
Customer PPM (Super Ace/Venture)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18

Rej Qty 0

RSD 0

Total Rejection qty 0

Total Production 10023

Over all PPM 0

500 500 500 500 500 500 500 500 500 500 500 500
Target

Customer PPM
600

500

400

300

200

100

0 0
Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18
Customer PPM (Load Body - 552370000114)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 27 42 17 3 1 1 0 0 2 93

RSD 0 0 0 0 0 0 0 0 0 0

Total Rejection qty 27 42 17 3 1 1 0 0 2 93

Total Dispatch 1236 1189 1290 875 90 244 118 42 283 5367

Over all PPM 21845 35324 13178 3429 11111 4098 0 0 7067 17328

5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000
Target

Customer PPM
40000

35000 35324

30000

25000
21845
20000
17328
15000
13178
11111
10000
7067
5000
3429 4098

0 0 0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
Customer PPM (Load Body - 552370000130)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 14 1 2 0 3 3 3 5 9 40

RSD 0 0 0 0 0 0 0 2 2 4

Total Rejection qty 14 1 2 0 3 3 3 6 10 43

Total Dispatch 476 150 472 115 617 618 285 1158 990 4881

Over all PPM 29412 6667 4237 0 4862 4854 10526 5527 10505 8769

Target 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

Customer PPM
35000

30000 29412

25000

20000

15000

10000 10526 10505


8769
6667
5000 4862 4854 5527
4237

0 0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
Customer PPM (Load Body - 552370000122)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 29 28 12 4 1 0 2 23 26 125

RSD 0 0 0 0 0 0 0 31 6 37

Total Rejection qty 29 28 12 4 1 0 2 45 30 151

Total Dispatch 1772 1545 755 738 774 619 437 1867 1610 10117

Over all PPM 16366 18123 15894 5420 1292 0 4577 23942 18758 #DIV/0! 14915

Target 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

Customer PPM
30000

25000
23942

20000
18758
18123
16366 15894
15000 14915

10000

5000 5420
4577

1292
0 0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
Overall Customer PPM (Load Body)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 70 71 31 7 5 4 5 28 37 258

RSD 0 0 0 0 0 0 0 31 6 37

Total Rejection qty 70 71 31 7 5 4 5 50 41 284

Total Dispatch 3484 2884 2517 1728 1481 1481 840 3067 2883 20365

Over all PPM 20092 24619 12316 4051 3376 2701 5952 16205 14291 0 0 0 13941

Target 500 500 500 500 500 500 500 500 500 500 500 500 500

Customer PPM
30000

25000 24619

20000 20092

16205
15000
14291 13941
12316
10000

5952
5000
4051
3376
2701

0 0 0 0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
Customer PPM (Load Body - 553784300102)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 6 8 9 4 1 15 4 6 20 73

RSD 0 0 0 0 0 0 14 2 1 17

Total Rejection qty 6 8 9 4 1 15 14 7 21 0 85

Total Dispatch 618 588 561 735 1133 900 999 1047 1242 7823

Over all PPM 9709 13605 16043 5442 883 16667 13814 7068 16667 0 0 0 10853

Target 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

Customer PPM
18000
16667 16667
16000 16043

14000 13814
13605

12000
10853
10000 9709

8000
7068
6000
5442
4000

2000
883
0 0 0 0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
Customer PPM (Ace Plus - 554570000107/103)
Month Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Avg

Rej Qty 2 33 27 17 134 74 44 51 84 466

RSD 0 0 0 0 0 0 21 46 34 101

Total Rejection qty 2 33 27 17 134 74 59 83 108 537

Total Dispatch 159 700 1755 4069 4700 4018 4953 4667 3969 28990

Over all PPM 12579 47143 15385 4178 28511 18417 11851 17827 27160 18513

Target 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

Customer PPM
50000
47143
45000

40000

35000

30000
28511
27160
25000

20000
18417 17827 18513
15000 15385
12579 11851
10000

5000 4178

0
42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 Avg
TOP 5 SUPPLIER PPM MONTH OF SEPT-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

1 MAMTA TRADING 50349 1 0.00

2 S S TRADER 14 4 28.57

3 CHEEMA 15100 0 0.00


4 EMPATHAY 59150 0 0.00
5 HI TECH 35869 0 0.00
Total
Avg.

285714.3
300000

250000

200000

150000

100000

50000

19.9 0.0 0.0


0
MAMTA TRADING S S TRADER CHEEMA EMPATHAY
H OF SEPT-20

PPM MAJOR DEFECTS

19.9 ELEMENT FUSE WIRE

285714.3 CUTTER OVERSIZE

0.0 NIL

0.0 NIL

0.0 NIL

REJ.QTY
PPM

0.0 0.0

EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF AUG .-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

1 SHYAM 38377.7 0 0.00

2 SL FASTNERS 278500 0 0.00

3 UNIQUE 14530 0 0.00


4 EMPATHAY 58773 0 0.00
5 HI TECH 28700 0 0.00
Total
Avg.

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1
0.0 0.0 0.0 0.0
0
SHYAM SL FASTNERS UNIQUE EMPATHAY
H OF AUG .-20

PPM MAJOR DEFECTS

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

REJ.QTY
PPM

0.0 0.0

EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF JULY .-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

1 SHYAM 33888 0 0.00

2 SL FASTNERS 90000 10117 11.24

3 UNIQUE 8310 0 0.00


4 EMPATHAY 20534 0 0.00
5 HI TECH 20731 117 0.56
Total
Avg.

120000 112411.1

100000

80000

60000

40000

20000

0.0 0.0 0.0


0
SHYAM SL FASTNERS UNIQUE EMPATHAY
OF JULY .-20

PPM MAJOR DEFECTS

0.0 NIL

112411.1 BURR FOUND DURING ASSY

0.0 NIL

0.0 NIL

5643.7 SPOKE HOLE MISS

REJ.QTY
PPM

5643.7
0.0

EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF JUNE .-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

1 SHYAM 7090 0 0.00

2 SL FASTNERS 46348 0 0.00

3 CHEEMA 1500 0 0.00


4 EMPATHAY 7116 0 0.00
5 HI TECH 15258 0 0.00
Total
Avg.

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1
0.0 0.0 0.0 0.0
0
SHYAM SL FASTNERS CHEEMA EMPATHAY
OF JUNE .-20

PPM MAJOR DEFECTS

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

REJ.QTY
PPM

0.0 0.0

EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF MAY .-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

GURU
1
ENTERPRIZES 1087 0 0.00
PROGRESSIVE
2
COMPONENT
11693 0 0.00

3 BEST QUALITY 18000 0 0.00


4 EMPATHAY 1100 0 0.00
5 HI TECH 5253 0 0.00
Total
Avg.

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1
0.0 0.0 0.0 0.0
0
GURU ENTERPRIZES PROGRESSIVE COMPONENT BEST QUALITY EMPATHAY
OF MAY .-20

PPM MAJOR DEFECTS

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

0.0 NIL

REJ.QTY
PPM

0.0 0.0

EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF APRIL .-20

SL.NO SUPPLIER NAME INWARD QTY REJ.QTY REJ.%

GURU
1
ENTERPRIZES 200 0 0.00

2 CHEEMA 0 0 #DIV/0!

3 SHYAM 0 0 #DIV/0!

4 EMPATHAY 0 0 #DIV/0!
5 KALKI 0 0 #DIV/0!
Total
Avg.

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1
0.0
0
GURU ENTERPRIZES CHEEMA SHYAM EMPATHAY
OF APRIL .-20

PPM MAJOR DEFECTS

0.0 NIL

#DIV/0! NIL

#DIV/0! NIL

#DIV/0! NIL

#DIV/0! NIL

REJ.QTY
PPM

EMPATHAY KALKI

You might also like