Supplier 20-21 Ppm.
Supplier 20-21 Ppm.
Supplier 20-21 Ppm.
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)
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
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
Rej Qty 5477 89 127 107 52 12 220 149 47 110 4 57 122 147 179 234
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
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
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 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 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
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
RSD 0 0 0 0 0 0 0 31 6 37
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
RSD 0 0 0 0 0 0 0 31 6 37
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 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
RSD 0 0 0 0 0 0 21 46 34 101
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
2 S S TRADER 14 4 28.57
285714.3
300000
250000
200000
150000
100000
50000
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
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
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
120000 112411.1
100000
80000
60000
40000
20000
0.0 NIL
0.0 NIL
0.0 NIL
REJ.QTY
PPM
5643.7
0.0
EMPATHAY HI TECH
TOP 5 SUPPLIER PPM MONTH OF JUNE .-20
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
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
GURU
1
ENTERPRIZES 1087 0 0.00
PROGRESSIVE
2
COMPONENT
11693 0 0.00
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
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
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
0.0 NIL
#DIV/0! NIL
#DIV/0! NIL
#DIV/0! NIL
#DIV/0! NIL
REJ.QTY
PPM
EMPATHAY KALKI