0% found this document useful (0 votes)
27 views16 pages

Sheet Metal Stock Details

Uploaded by

jmmshah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
27 views16 pages

Sheet Metal Stock Details

Uploaded by

jmmshah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 16

Sr.no.

Details
1 As on date can produce Areca Nut Compact - 24. or Normal Areca Nut 16 nos.
2 525 Fender 20 sets available with CPP and 13 Nos. Bonnet can paint in CPP
3 After receipt of OIB Fender can start 4DI as Bonnet with CPP already started.
4 After 36 nos. 3DI can start with CPP
5 536 Fender to use in 525 Deviation
Total Value 5,187,199 1,250,798 6,437,998 3,653,066
Physical Stock of Painted Sheet Metal in Plant as on 14.09.2024 Physical Stock of P
Sr.no. Gromax For Inspection Nok Total For Inspection
1 Areca Nut Hood 50 9 59 24
3 3DI Hood 51 6 57 32
4 4DI Hood 6 15 21 1
5 Areca Nut Fender LH 41 13 54 55
6 Areca Nut Fender RH 40 16 56 55
7 3DI-4DI Trakstar Fender Lh 121 14 135 102
8 3DI-4DI Trakstar Fender Rh 122 16 138 106
9 Scuttle 67 30 97 22
10 H60 Hood 49 4 53 27
11 H60 Fender Lh 44 4 48 27
12 H60 Fender Rh 51 4 55 34
13 4WD Fender Lh 9 9 5
14 4WD Fender Rh 9 9 5
15 H60 Scuttle 63 15 78 41
16
525 Hood 22 3 25 22
17 525 Fender Lh 16 16 16
18 525 Fender Rh 16 16 16
19 536 Hood 15 15 8
20 536 Fender Lh 50 50 43
21 536 Fender Rh 50 50 43
Total 874 167 1041 684

Sr.no. FD Ok Nok Total For Inspection


1 265 Orchard Hood 107 89 196 139
2 265 Orchard Fender Lh 121 14 135 11
3 265 Orchard Fender Rh 122 16 138 12
4 265 Orchard Scuttle 157 42 199 163
5 Orchard Compact Hood 0 0 0 54
6 255 Hood 73 1 74 27
7 255 Scuttle 33 3 36 10
8 255 Fender Lh 73 73 26
9 255 Fender Rh 73 73 26
Total 759 165 924 468
1,149,852 4,802,918 776,037
Physical Stock of Painted Sheet Metal in Plant as on 24.09.2024
Nok Total New CPP Remarks Gromax
6 30 16 Hood
4 36 8 Fender Set
7 8 22 Scuttle
13 68 24 Total
16 71 25
13 115 0
16 122 0 FD
11 33 74 Hood
4 31 0 2nd Priority Fender Set
4 31 0 2nd Priority Scuttle
4 38 0 2nd Priority Total
9 14 0 2nd Priority
9 14 0 2nd Priority
15 56 0 2nd Priority
25 13 CED to be painted 2
3 2 Orange
16 23 3 Orange 20 Blue
16 23 3 Orange 20 Blue
8 0 2nd Priority
43 0 2nd Priority
43 0 2nd Priority
134 818 246

Nok Total New CPP


89 228
45 56 10
36 48 33
42 205
54
27
4 14
26
26
216 684 43
4,802,918
Data
Model Sum of For Inspection2 Sum of Not OK2 Sum of For Inspection3
255 - Bonnet 27
255 - Fender LH 26
255 - Fender RH 26
255 - Scuttle 10 4
265 Orchard - Bonnet 139 89
265 Orchard - Fender LH 11 45 10
265 Orchard - Fender RH 12 36 33
265 Orchard - Scuttle 163 42
525 - Bonnet 22 3 3
525 - Fender LH 16 23
525 - Fender RH 16 23
Hindustan - Bonnet 27 4
Hindustan - Fender LH 27 4
Hindustan - Fender RH 34 4
Hindustan - Scuttle 41 15
Hindustan 4WDLT - Fender LH 5 9
Hindustan 4WDLT - Fender RH 5 9
Tracstar-Areca Nut - Bonnet 24 6 45
Trakstar - OIB Fender LH 102 13 0
Trakstar - OIB Fender RH 106 16 0
Trakstar - Scuttle 22 11 74
Trakstar-3DI Bonnet 32 4 8
Trakstar-4DI - Bonnet 1 7 22
Trakstar-Areca Nut - Fender LH 55 13 24
Trakstar-Areca Nut - Fender RH 55 16 25
Total Result 1004 350 290
Sheet Metal Stock

Sr.no. Componant MAT_TEXT Buyer Color

1 455313R00 NEW LIGHT BLUE PAINTED BONNET ASSLY 3DI Tanmay Blue
2 605350R00 NEW LIGHT BLUE PAINTED BONNET ASSLY -4DI Tanmay Blue
0B315594R00 PAINTED BLUE HOOD ASSEMBLY - ORCHD Tanmay Blue
3
4 455708R00 NEW LIGHT BLUE PAINTED DASHBOARD ASSY Tanmay Blue
5 0B315594R01 PAINTED YELLOW HOOD ASSEMBLY - ORCHD Tanmay Yellow
6 605350R01 NEW YELLOW BONNET ASSLY 4DI Tanmay Yellow
7 455708R01 NEW YELLOW DASHBOARSD ASSY Tanmay Yellow
8 455528R00 NEW LIGHT BLUE PAINTED FENDER ASSLY LH Tanmay Blue
9 455529R00 NEW LIGHT BLUE PAINTED FENDER ASSLY RH Tanmay Blue
10 455528R01 NEW YELLOW OIB FENDER -LH Tanmay Yellow
11 455529R01 NEW YELLOW OIB FENDER - RH Tanmay Yellow
12 0C315411R00 FENDER ASSEMBLY (LEFT) - PAINTED BLUE Tanmay Blue
13 0C315412R00 FENDER ASSEMBLY (RIGHT) - PAINTED BLUE Tanmay Blue
14 0D315411R00 FENDER ASSEMBLY (LEFT) - PAINTED YELLOW Tanmay Yellow
15 0D315412R00 FENDER ASSEMBLY (RIGHT) - PAINTED YELLOW Tanmay Yellow
16 007637327V92 HOOD & RADIATOR GRILL ASSY COMPLETE 265 Nilkanth Red
17 0P7904248B92 FUEL TANK COMPLETE WITH SCUTTLE Nilkanth Red
18 0B315412R00 FENDER ASSLY ARECA NUT (SD) - RIGHT- RED Tanmay Red
19 0B315411R00 FENDER ASSLY ARECA NUT (SD)-LEFT- RED Tanmay Red
20 0B605347R00 PAINTED YELLOW SINGLE PIECE HOOD. Nilkanth Yellow
21 0B605349R00 PAINTED YELLOW SCUTTLE ASSLY Nilkanth Yellow
22 0B605509R00 PAINTED YELLOW FENDER RH (ARJUN) 4DI Nilkanth Yellow
23 0B605510R00 PAINTED YELLOW FENDER LH (ARJUN) 4DI Nilkanth Yellow
24 0BP793120K PAINTED YELLOW FENDER ASSY - LEFT Nirav Yellow
25 0BP793125J PAINTED YELLOW FENDER ASSY - RIGHT Nirav Yellow
26 0B315599R00 PAINTED HOOD ASSY TS 525 NIrav Blue
27 0B7649026Y91 PAINTED BLUE FENDER ASSLY LH FOR TS 525 Tanmay Blue
28 0B7649027Y91 PAINTED BLUE FENDER ASSLY RH FOR TS 525 Tanmay Blue
29 005557851R94 HOOD AND RADIATOR GRILL HSG CPTE. Nilkanth Red
30 007904249B92 FUEL TANK COMPLETE WITH SCUTTLE (475 BP) Nilkanth Red
31 007531805B12 FENDER CPTE RH Nilkanth Red
32 007531808B12 FENDER SEAT CPTE LH Nilkanth Red
Model Supplier Name Bare Part Rate

Trakstar-3DI Bonnet Bhurjee / EIC 3,570.49


Trakstar-4DI - Bonnet Bhurjee / EIC 3,717.88
Tracstar-Areca Nut - Bonnet
Bhurjee / EIC 3,491.34
Trakstar - Scuttle Bhurjee / EIC 1,007.13
Tracstar-Areca Nut - Bonnet Bhurjee / EIC 3,491.34
Trakstar-4DI - Bonnet Bhurjee / EIC 3,717.88
Trakstar - Scuttle Bhurjee / EIC 1,007.13
Trakstar - OIB Fender LH Auto Comp Panse/EIC 3,198.84
Trakstar - OIB Fender RH Auto Comp Panse/EIC 3,208.00
Trakstar - OIB Fender LH Auto Comp Panse/EIC 3,198.84
Trakstar - OIB Fender RH Auto Comp Panse/EIC 3,208.00
Trakstar-Areca Nut - Fender LH Kansal/EIC 1,644.70
Trakstar-Areca Nut - Fender RH Kansal/EIC 1,644.70
Trakstar-Areca Nut - Fender LH Kansal/EIC 1,644.70
Trakstar-Areca Nut - Fender RH Kansal/EIC 1,644.70
265 Orchard - Bonnet MAHINDRA CIE AUTOMOTIVE LTD. 3,315.14
265 Orchard - Scuttle MAHINDRA CIE AUTOMOTIVE LTD. 2,099.56
265 Orchard - Fender RH Kansal/EIC 1,644.70
265 Orchard - Fender LH Kansal/EIC 1,644.70
Hindustan - Bonnet Ajwa Motors/EIC 4,243.90
Hindustan - Scuttle Ajwa Motors/EIC 2,525.51
Hindustan - Fender RH MCIE Nagpur/EIC 3,993.70
Hindustan - Fender LH MCIE Nagpur/EIC 4,186.01
Hindustan 4WDLT - Fender LH May Steel/EIC 3,328.64
Hindustan 4WDLT - Fender RH May Steel/EIC 3,329.22
525 - Bonnet Rise Spare/EIC 2,144.73
525 - Fender LH Auto Comp Panse/EIC 694.02
525 - Fender RH Auto Comp Panse/EIC 748.63
255 - Bonnet MAHINDRA CIE AUTOMOTIVE LTD. 3,111.19
255 - Scuttle MAHINDRA CIE AUTOMOTIVE LTD. 2,972.45
255 - Fender RH MAHINDRA CIE AUTOMOTIVE LTD. 3,680.36
255 - Fender LH MAHINDRA CIE AUTOMOTIVE LTD. 3,671.09
Total Value 5,187,199 1,250,798

For
Gromax For
Painting Rate Total Rate Inspectio Not OK Not OK
Total Inspection
n

1,596.92 5,167.41 51 6 57 263,537.91 31,004.46


1,635.50 5,353.38 4 14 18 21,413.52 74,947.32

1,550.66 5,042.00 48 9 57 242,016.00 45,378.00


479.71 1,486.84 64 24 88 95,157.76 35,684.16
1,754.60 5,245.94 2 2 10,491.88 -
1,818.45 5,536.33 2 1 3 11,072.66 5,536.33
515.22 1,522.35 3 6 9 4,567.05 9,134.10
1,511.26 4,710.10 117 13 130 551,081.70 61,231.30
1,491.10 4,699.10 121 16 137 568,591.10 75,185.60
1,710.01 4,908.85 4 1 5 19,635.40 4,908.85
1,687.20 4,895.20 1 1 4,895.20 -
656.89 2,301.59 38 13 51 87,460.42 29,920.67
656.89 2,301.59 33 16 49 75,952.47 36,825.44
743.28 2,387.98 3 3 7,163.94 -
743.28 2,387.98 7 7 16,715.86 -
3,315.14 107 89 196 354,719.98 295,047.46
638.66 2,738.22 157 42 199 429,900.54 115,005.24
733.50 2,378.20 77 36 113 183,121.40 85,615.20
733.50 2,378.20 76 45 121 180,743.20 107,019.00
1,641.60 5,885.50 49 4 53 288,389.50 23,542.00
775.20 3,300.71 63 15 78 207,944.73 49,510.65
1,915.21 5,908.91 51 4 55 301,354.41 23,635.64
1,915.21 6,101.22 44 4 48 268,453.68 24,404.88
1,869.60 5,198.24 9 9 - 46,784.16
1,869.60 5,198.82 9 9 - 46,789.38
1,102.45 3,247.18 22 3 25 71,437.96 9,741.54
469.21 1,163.23 16 16 18,611.68 -
489.23 1,237.86 16 16 19,805.76 -
3,111.19 73 1 74 227,116.87 3,111.19
639.40 3,611.85 33 3 36 119,191.05 10,835.55
3,680.36 73 73 268,666.28 -
3,671.09 73 73 267,989.57 -
24.9.24

6,437,998 Existing Process New CPP Process

For
Gromax Total
Inspectio Not OK Total For Inspection Remarks
Value
n

294,542 32 4 36 8
96,361 6 6 22

22 6 28 45 29 - Compact & 16 -
287,394 Normal Areca Nut
130,842 20 5 25 74
10,492 2 2
16,609 1 1 2
13,701 2 6 8
612,313 99 13 112 0
643,777 106 16 122 0
24,544 3 3
4,895 0 0
117,381 52 13 65 24
112,778 48 16 64 25
7,164 3 3
16,716 7 7
649,767 139 89 228
544,906 163 42 205
268,737 12 36 48 33
287,762 11 45 56 10
311,932 27 4 31
257,455 41 15 56
324,990 34 4 38
292,859 27 4 31
46,784 5 9 14
46,789 5 9 14
81,180 22 3 25 3 3 Orange
18,612 16 16 23 3 Orange
19,806 16 16 23 3 Orange
230,228 27 27
130,027 10 4 14
268,666 26 26
267,990 26 26
5,578,955 3,653,066 1,149,852 4,802,918 776,037

New CPP Part


For Value of Old
Total Value Not OK Value with
Inspection Parts
existing rate

227,366 165,357 20,670 186,027 41,339


149,895 - 32,120 32,120 117,774

368,066 110,924 30,252 141,176 226,890


147,197 29,737 7,434 37,171 110,026
10,492 10,492 - 10,492 -
11,073 5,536 5,536 11,073 -
12,179 3,045 9,134 12,179 -
527,531 466,300 61,231 527,531 -
573,290 498,105 75,186 573,290 -
14,727 14,727 - 14,727 -
- - - - -
204,842 119,683 29,921 149,603 55,238
204,842 110,476 36,825 147,302 57,540
7,164 7,164 - 7,164 -
16,716 16,716 - 16,716 -
755,852 460,804 295,047 755,852 -
561,335 446,330 115,005 561,335 -
192,634 28,538 85,615 114,154 78,481
156,961 26,160 107,019 133,179 23,782
182,451 158,909 23,542 182,451 -
184,840 135,329 49,511 184,840 -
224,539 200,903 23,636 224,539 -
189,138 164,733 24,405 189,138 -
72,775 25,991 46,784 72,775 -
72,783 25,994 46,789 72,783 -
90,921 71,438 9,742 81,180 9,742
45,366 18,612 - 18,612 26,754
48,277 19,806 - 19,806 28,471
84,002 84,002 - 84,002 -
50,566 36,119 14,447 50,566 -
95,689 95,689 - 95,689 -
95,448 95,448 - 95,448 -
1
1 0 0 1 1 5 6 0
6 6 0 6 0 6 0 6 0
6 0 6 8 -2 0 -2 0 -2
0 -2 0 -2 0 -2 0 -2
Data
Model Sum of For Inspection Sum of Not OK
255 - Bonnet 73 1
255 - Fender LH 73
255 - Fender RH 73
265 Orchard - Bonnet 107 89
265 Orchard - Fender LH 76 45
265 Orchard - Fender RH 77 36
265 Orchard - Scuttle 157 42
525 - Bonnet 22 3
525 - Fender LH 16
525 - Fender RH 16
Hindustan - Bonnet 49 4
Hindustan - Fender LH 44 4
Hindustan - Fender RH 51 4
Hindustan - Scuttle 63 15
Hindustan 4WDLT - Fender LH 9
Hindustan 4WDLT - Fender RH 9
Tracstar-Areca Nut - Bonnet 50 9
Trakstar - OIB Fender LH 121 14
Trakstar - OIB Fender RH 122 16
Trakstar - Scuttle 67 30
Trakstar-3DI Bonnet 51 6
Trakstar-4DI - Bonnet 6 15
Trakstar-Areca Nut - Fender LH 41 13
Trakstar-Areca Nut - Fender RH 40 16
255 - Scuttle 33 3
Total Result 1428 383

You might also like