0% found this document useful (0 votes)
287 views11 pages

SP Replacement

This document provides inventory data for various automotive parts at SMCT Group of Companies including ending inventory balances for August and sales quantities for specific parts. It lists over 150 unique part numbers along with descriptions, ending balances, and sales for the month. The parts include items like oil filters, brake pads, o-rings, bolts, shock absorbers, and other common vehicle components.

Uploaded by

Janrey Arcayera
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)
287 views11 pages

SP Replacement

This document provides inventory data for various automotive parts at SMCT Group of Companies including ending inventory balances for August and sales quantities for specific parts. It lists over 150 unique part numbers along with descriptions, ending balances, and sales for the month. The parts include items like oil filters, brake pads, o-rings, bolts, shock absorbers, and other common vehicle components.

Uploaded by

Janrey Arcayera
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/ 11

SMCT Group of Companies (DSM - TAGBI

CPG North Ave., Tagbilaran City, Boho


Product Aging (Detailed) - DSMT

Ending balance
Sales for the
SP-Rep Product Code for the month of
month of August
August

Air filter K6A (FAS 8044) FAS8044 5


Automotive bulb H4 12V 60/55w H4-8411 0 0
Automotive Bulb H4 12V-100/90W 720710110-AUTO12V 16 2
Automotive Bulb H4 12V-60/55W 7207101-AUTO12 21 2
Bando Belt 4PK-890 BELT-4PK890 3
Bando Belt 9.5x820 BELT-9.5X820 4
Bando Belt B-31 w/groove RPF5330 2
Bando Belt 5PK-940 FANBELT-5PK940 4 2
Bearing 32004 BEARING-32004 18 4
Bolt 12x25 12X25-BOLT 28
Bosch Ignition Coil BOSCH-IGNITION-COIL 10
Brake master F6A (w/tube ) scrum 51100-85850 1
Brake master assembly K6A 51110-85860 3
Brake master assembly F6A 7/8 (orion) 51110-85850 4
Brake Pad N5011 (NIKK) BPAD-N5011 8
Brake Pad VA-621K (Suzuki K6 Wagon R) BPAD-VA621K-SWK6 5
Brake Pads VAX-133K 90`.97` (Mazda Bongo) BPADS-VAX133K 1
Brake shoe for Mazda Bongo rear (45mm) VK-351 2
Brake Shoe Rear Kia Bongo VK-350 VK-350 4
Center bolt (for molye) CENTER-BOLT 13
Circuit Flasher Mini Relay 12V FLASH-RELAY-MINI 12V 15
Circuit Halogen Bulb 24V 100/90w CIRCUIT-HB24V-100/90 8 1
Circuit Ignition Coil CRCT-IGNITION-COIL 4
Circuit Sparkplug, Coil 33400-65G02 4
Circuit Temperature sender F6A (small) 34850-82001 3
Conrod Bearing F6A Suzuki 12v (0.25) R658A 4
Corteco Oil Seal 32x47x6 OILSEAL-32X47X6 10
Corteco Oil Seal 35x47x6 OILSEAL-35X47X6 14
Corteco Valve Seal F6A (NOK) CORTECO-VSEAL-F6A 5
Door Handle In-LH (big) 78471-85520-LH 4
Door Handle In-RH (big) 78471-85520-RH 4
Door Handle IN-RH F6A (small) 78481-85000-RH 3
Door Handle Inside-LH F6A (small) 78481-85000-LH 1 1
Expansion Valve 38003 2
FANJK Brake shoe rear K9962 K9962 4
Fuel Filter WFC-208A FUELFIL-WFC-208A 6
Fuel Pump Assembly FPUMP-ASSY 5
Flasher relay 12V 066500-5570 2 1
Gearbox oil seal 22-35-7 OILSEAL-22-35-7 0
Gasket Cement Whiz GSKT-CEMENT-W 13
Goodride Brand New Tire 175 R13 SL305 2
GSK Clutch Cable F5A Scrum 23714-85236 2
GSK Handle Brake Cable HBRAKE CABLE 6
GSK Rock & Pinion Boots (Long) RP-BOOTS-LONG 9 4
Head Gasket K6A RHG-98184 RHG-98184 2
Head Gasket Mazda R2 (RHG-60526) RHG 60526 2
Headlight HEADLIGHT 2
Honda CRV Shock Absorber LH CRV-SHOCK-ABSORBER 1
Hose Clamp 20-32mm HC-2032MM 10
Koito Halogen Bulb 24V 100/90w H4 P43T KOITO-HB24V-100/90 3
Koyo Ball Bearing 6909 6909ZZ 2
Koyo Bearing 46T80603 46T080603 2
Koyo Spindle bearing DAC3562W-10CS51 2
Lift-up Kit Rear for Scrum (shockle) 45200-62003 3
Long Fanbelt (motorcraft) L3TF15909MC 1
Main Bearing F6A Suzuki 12v (0.25) M658A 4
Mitsuba Fanbelt B-42 without Groove FANBELT-B42WOGRV-M 4 1
Mohashi Oil Seal 28X38X10 OS-28X38X10 7
NIssan Vanette Dropside Engine E#LD20636655 NIS-VANENGINE 1
NTN Bearing JPU42-004A-3 JPU42-004A-3 0
Oil Filter BMW Z3 OFILTER-BMW 1
Oil filter C-115 Vic OILFIL-C-115 9
Oil filter C-415 Vic (Honda CRV) OILFIL-C-415 7 1
Oil Filter H5 1017100-ED01 1
Oil Filter M4/M2 1017100-EG01 3
Oil Filter Mercedez Benz OFILTER-MERCEDEZ 1
O-ring 1/2 Standard ORING-1/2-STD 139 4
O-ring 10,00 x 2,50 ORING-10,00X2,50 50
O-ring 10,78 x 2,62 ORING-10,78X2,62 69 6
O-ring 12,00 x 2,00 ORING-12,00X2,00 25
O-ring 12,00 x 2,50 ORING-12,00X2,50 35
O-ring 14,00 x 2,50 ORING-14,00X2,50 7
O-ring 2,90x1,78 ORING-2,90x1,78 50
O-ring 3,69x1,78 ORING-3,69x1,78 50
O-ring 3/8 Ordinary ORING-3/8-ORD 23
O-ring 3/8 x 14 Standard ORING-3/8X14-STD 105 2
O-ring 4,47 x 1,78 O-RING-4,47X1,78 0
O-ring 5,28x1,78 ORING-5,28x1,78 50
O-ring 3/8 x 16 Ordinary ORING-3/8X16-OR 0
O-ring 5/8 Medium ORING-5/8-M 16
O-ring 5/8 Oversize ORING-5/8OS 18
O-ring 5/8 Oversize Large ORING-5/8OS-L 9
O-ring 5/8 Oversize Standard ORING-5/8OS-STD 19
O-ring 5/8 Standard ORING-5/8-STD 6
O-ring 5/8 x 15 Ordinary ORING-5/8X15-ORD 46
O-ring 5/8 x 16 Standard ORING-5/8x16-STD 11 2
O-ring 6,00 x 2,00 ORING-6,00X2,00 10
O-ring 6,07 x 1,78 ORING-6,07X1,78 209
O-ring 7,66 x 1,78 ORING-7,66X1,78 90
O-ring 7,66 x 1,78 Large ORING-7,66X1,78-L 22
O-ring 9,19 x 2,62 ORING-9,19X2,62 65 1
O-ring 9,25 x 1,78 ORING-9,25X1,78 67
Overhauling Gasket K6A (RFS-96054S) RFS 96054S 1
RJZ Clutch disc, DA52 22400-780A80 0
RJZ Sparkplug, Coil 33400-76G00 2
Rubber Boots (4W) TGV-H11 TGV-H11 9
Scrum Door Handle LH D-HANDLE-SCRUM 5
Scrum Door Handle RH D-HANDLE-SCRUM 2
SGP Selector Cable SELECTORCABLE 3
Shock absorber F6A LH- Nitrotech N8833606 2 1
Shock absorber F6A RH- Nitrotech N8833605 0 1
SP Rep- 3rd Brake Light Cover Large 3RD-BRAKE-LIGHTCOVERL 8 7
SP Rep- Automotive Wire #14 AUTOMOTIVE-WIRE#14 243 23
SP Rep- Automotive Wire #16 AUTOMOTIVE-WIRE#16 257 24
SP Rep- Automotive Wire #18 AUTOMOTIVE-WIRE#18 168 15
SP Rep- Battery Clip CLIP-BATTERY 23 11
SP Rep- Bolt 10X15 10X15-BOLT 124
SP Rep- Bolt 10X20 10X20-BOLT 86
SP Rep- Bolt 10X25 10X25-BOLT 67 6
SP Rep- Bolt 10X75 10x75-BOLT 33 15
SP Rep- Bolt 12X20 12X20-BOLT 30
SP Rep- Bolt 12X35 12x35-BOLT 66 1
SP Rep- Bolt 14X1.5X30 14X1.5X30-BOLT 57
SP Rep- Bolt 16X30 16X30-BOLT 244
SP Rep- Bolt 5x10 5x10-BOLT 82 5
SP Rep- Bolt 5x15 5X15-BOLT 77 12
SP Rep- Bolt 5x25 5X25-BOLT 76 44
SP Rep- Bolt 6X15 6X15-BOLT 48 26
SP Rep- Bolt 6X20 6X20-BOLT 58 16
SP Rep- Bolt 6X25 6X25-BOLT 58 9
SP Rep- Bolt 6X30 6X30-BOLT 84 16
SP Rep- Bolt 6X45 Fully Thread 6X45-BOLT FT 21
SP Rep- Bolt 6X45 Half Thread 6X45-BOLT HT 36
SP Rep- Bolt 6X50 6X50-BOLT 62 9
SP Rep- Bolt 8X15 8X15-BOLT 120 2
SP Rep- Bolt 8X20 8X20-BOLT 54 4
SP Rep- Bolt 8X25 8X25-BOLT 61 10
SP Rep- Bolt 8X35 8X35-BOLT 26 4
SP Rep- Bolt 8X45 8x45-BOLT 33 2
SP Rep- Canopy Set SET-BOLT-CANOPY 21 7
SP Rep- Lock Washer 10mm 10MM-LOCK-WASHER 55 19
SP Rep- Lock Washer 6mm 6MM-LOCK-WASHER 205
SP Rep- Lock Washer 8mm 8MM-LOCK-WASHER 66 7
SP Rep- Nut 10mm 10MM-NUT 161 30
SP Rep- Nut 12mm 12MM-NUT 45 1
SP Rep- Nut 14mm 14MM-NUT 82
SP Rep- Nut 5mm 5MM-NUT 56 10
SP Rep- Nut 6mm 6MM-NUT 80 49
SP Rep- Nut 8mm 8MM-NUT 67 16
SP Rep- Plain Washer 10mm 10MM-PLAIN-WASHER 161 42
SP Rep- Plain Washer 14 mm 14MM-PLAIN-WASHER 103
SP Rep- Plain Washer 5mm 5MM-PLAIN-WASHER 590 11
SP Rep- Plain Washer 6mm 6MM-PLAIN-WASHER 102 78
SP Rep- Plain Washer 8mm 8MM-PLAIN-WASH 73 16
SP Rep- Sliding Window for FB Van SLIDING-WINDOW-FBVAN 2
SP Rep- Speaker Wire #18 SPEAKER-WIRE#18 221 20
SP Rep- Stud Bolt STUD-BOLT 49 4
SP-Rep- Tex Screw #1 TEXSCREW #1 72 15
SP Rep- Tex Screw #2 TEXSCREW #2 62
Sparkplug SP-493 AGSF32PM SP-493 AGSF32PM 3
Sparkplug YR7DI30 (bosch) SPLUG-YR7DI30 35 24
SP-Gen-Suz - Air Cleaner Suzuki K6A 13780-78A20 4
SP-Rep Clutch lining AISIN DS-032 22400-78A21 2
SP-Rep Clutch pressure disc AISIN CS-029 22100-78A40 2 1
SP-Rep- MOPAR Oil Filter MO-349 2
SP-Rep- MOPAR Oil Filter MO-409 4
SP-Rep- MOPAR Oil Filter 6803 2204 6803 2204 AB-001 1
SP-Rep- Pilot bearing 6000 (Koyo) 6000ZZCM 6 3
SP-Rep- RSPEC Brake Pad Bongo OLE BPAD-BONGO-OLE 2
SP-Rep- RSPEC Brake Pad Suzuki Every BPAD-SUZEVERY-OOJ 5
SP-Rep- RSPEC Brake Pad Suzuki Landy BPAD-SUZLANDY-LEO 6
SP-Rep- RSPEC Brake Pad Suzuki Scrum BPAD-SUZSCRUM-ERT 3 1
SP-Rep- RSPEC Brake Shoe Bongo RJO BSHOE-BONGO-RJ0 3
SP-Rep- RSPEC Brake Shoe Suzuki Every BSHOE-SUZEVERY-OLB 2
SP-Rep- RSPEC Brake Shoe Suzuki Landy BSHOE-SUZLANDY LBE 1
SP-Rep- RSPEC Brake Shoe Suzuki Scrum BSHOE-SUZSCRUM EAS 5 1
SP-Rep- Sensor, Throttle 8945220130 1
SP-Rep Speedometer Cable 120" F5A 34910-75700 9 5
SP-Rep- Suspension Arm ASA 45200-86024 RH 6
SP-Rep- Suspension Arm Assy 45200-86025 LH 5
SP-Rep- Suspension Arm Assy 45200-86021 LH 3 5
SP-Rep- Suspension Arm Assy 45200-86021 RH 3 6
SP-Rep- Suspension Arm Assy 45200-86026 RH 1 4
SP-Rep- Suspension Arm Assy 45200-86027 LH 3 2
SP-Rep- Valve A/S, Idle S/CTL 222700D020 1
Suzuki P-up CKD (Cabin part only) CKD-CABIN 1
Tail lamp DL-901 LH DL-901 LH 3 1
Tail lamp DL-901 RH DL-901 RH 4 2
Temperature Sender TEMP-SENDER 2
Tension Bearing 6069 226069 6 2
Thermostat Manual A10-6580-057 2 1
THO Oil Seal 40x30x10/13 24780-78A00 3
Thrust Washer Std. F6A T658A 2
Timing belt (Mazda Titan) R2 R201-12-205 3
U-bolt F6A 41411-80201 19
Valve cover gasket (Suzuki Landy) RVC52502 2
Valve Cover Gasket K6A (RVC 12007) RVC 12007 6 1
Valve Seal K6A FB5 0928905012 09289-05012 1
Vic Fuel Filter FC-184 VIC-FC184 3
Vic Oil filter C-517 OILFIL-C517VIC 4
Water Pump (Mazda Bongo) GWMZ-30A 2
Wheel Cyclinder Assy F6A Rr RH 53401-79020 5
Wuerth Automotive Bulb H1 12V 55W WUERTH-AUTOBULBH1-12V55W 7
Wurth Wiper Blade #12 WURTH-WBLADE12 16
Wurth Wiper Blade #14 WURTH-WBLADE14 5
Wurth Wiper Blade #14 WURTH-WBLADE-14 28
Wurth Wiper Blade #15 WURTH-WBLADE15 22
Wurth Wiper Blade #16 WURTH-WBLADE16 12
Wurth Wiper Blade #17 WURTH-WBLADE17 21
Wurth Wiper Blade #18 WURTH-WBLADE18 9
Wurth Wiper Blade #20 WURTH-WBLADE20 14 2
Tie rod end K6A 48810/20-77A00 2
Gasoline float F5A/F6A 34810-79002 2
Head gasket K6A RHG-81184 11141-78F00 1
Piston ring K6A std. TM871895 2
Main bearing K6A std.-Daido M5986A K6A 1
Conrod bearing K6A std.- Daido R5894A K6A 1
Valve seal K6A (09289-09252) 09289-09252 3
Range rover oil filter FT5916/Z1159 1
Oil filter FT8808 FT8808 1
Belt 17x1200 V17x1200 1
Fanbelt 6PK-1890 6PK-1890 2
Fanbelt STPM254-162-94476 STP8M-254-94476 1
Narva Germany H4 12V 60/55w bulb (Blue) 60/55W-H4-NARVA 12V 1
Eagle eye H4 RV 100/90W 100/90W-H4-EAGLE 12V 1
Ford timing belt 978M-6268-AIA 978M-6268 1
Gates timing belt 103YU25.4 S-Latest model DA52 surplu103YU25.4 1
O-ring 1/2 ordinary ORING-1/2-ORD 0
Makita carbon brush #51 (6430647) 6430647 3
Voltage regulator (new era BA# IVR-807) I.VR-807 1
Muffler extension (HJ-666) HJ-666 1
Canopy long size-scrum CAN-LONG-SCRUM
Speaker 5G-5M 150 watts SG-5M 3
Mazda tie rod end (Safety suspension parts ZentanSeike K670-32-2407280 1
Stabilizer lin (Honda) ASL-6340L 51321-SAA-003 ASL-6340L 2
Power transmission belt 9.5x600 9.5x600 1
Corner lamp assy DD51T 218-1510L-U LH DD51T-218-1510L LH 0
Camshaft sensor 12v (surplus) CAMSHAFT12V 2
Gates fanbelt 4PK-950 FANBELT-4PK950 0
Gates timing belt 103T T-BELT103T 2
Gates belt 4pk-940 FANBELT-4PK940 5
Release bearing 23265-81A20 2 1
Rear crankshaft Oil seal 79-99-8 (K6A) 09283-78F00 0 0

Total: 6505 684


roup of Companies (DSM - TAGBILARAN)
CPG North Ave., Tagbilaran City, Bohol
Product Aging (Detailed) - DSMT
September
Qty

Sales for the


Base on Acutal Onhand Purchase for the month of
Remarks month of
system inventory balance September
September

5 5 5

16 11 5 11
21 20 1 20
3 3 3
4 4 4
2 2 2
7 6 1 6 3 pcs new stock
18 18 18
28 28 28
10 10 10
1 1 1
3 2 1 2
4 3 1 3
8 8 8
5 5 5
1 1 1
2 2 2
4 4 4
13 9 -2 2 11
15 15 15
8 8 8
4 4 4
4 4 4
3 3 3
4 3 1 3
10 10 10
14 14 1 1 13
5 5 5
4 4 4
4 4 4
3 3 3
4 4 4 3 pcs new stock
2 2 2
4 3 1 3
6 6 6
5 5 5
8 7 1 7 6 pcs new stocks
3 1 2 1 3 new stocks
13 11 2 11
2 2 2
2 2 2
6 6 6
19 11 8 11 10 pcs new stocks
2 2 2
2 2 2
2 2 2
1 1 1
10 10 10
3 3 3
2 2 2
2 2 2
2 2 2
3 3 3
1 1 1
4 3 1 3
4 4 4
7 7 7
1 1 1

1 1 1
9 9 9
7 7 7
1 1 1
3 3 3
1 1 1
139 140 1 139
50 50 1 1 49
69 82 21 8 61
25 25 25
35 32 3 32
7 7 7
50 48 2 48
50 50 50
23 23 23
105 108 3 105
50 50 50
50 50 50

16 16 16
18 18 18
9 9 9
19 19 19
6 4 2 4
46 46 46
11 10 1 10
10 7 3 7
209 207 1 3 206
140 140 140 50 pcs new stock
22 22 22
65 65 65
67 69 3 1 66
1 1

2 2 2
9 9 9
5 6 1 5
2 4 2 2
3 3 3
2 2 2

8 2 2 8
243 170 73 170
257 221 36 221
168 168 168
23 18 5 18
124 124 124
86 86 86
67 61 6 61
33 22 11 22
30 30 30
66 71 5 66
57 57 57
244 244 244
82 87 10 5 77
77 79 8 6 71
76 67 -1 8 68
48 33 2 17 31
108 74 34 74 50 pcs new stock
58 52 4 10 48
154 64 12 102 52 70 pcs new stock
21 21 21
36 37 1 36
62 63 1 62
120 122 2 120
54 71 17 54
61 57 2 6 55
26 30 4 26
33 31 2 31
21 16 4 9 12
55 48 7 48
205 177 4 32 173
66 61 1 6 60
161 148 7 20 141
45 47 2 45
82 81 1 81
56 52 8 12 44
230 81 3 152 78 150 pcs new stock
67 60 4 11 56
161 60 101 60
103 104 2 1 102
590 578 10 22 568
102 102
73 42 14 45 28
2 2 2 toa sa extension
221 209 1 13 208
49 49 49
72 37 5 40 32
62 62 62
3 3 3
35 20 3 18 17
4 4 4
2 2 2
2 1 1 1
2 2 2
4 4 4
1 1 1
6 6 6
2 2 2
5 3 2 3
6 3 3 3
3 3 3
3 3 3
2 3 1 2
1 1 1
5 3 2 3
1 1 1
9 7 2 7
6 6 6
5 5 5
6 1 5 1
7 2 5 2
4 3 1 3
6 4 2 4
1 1 1
1 1 1
3 2 1 2
4 3 1 3
2 2 2
6 2 4 2
2 2 2
3 3 3
2 2
3 3 3
19 19 19
2 2 2
6 7 1 6
1 1 1
3 3 3
4 4 4
2 2 2
5 5 5
7 7 7
16 16 16
5 5 5
28 28 28
22 22 22
12 12 12
21 21 21
9 9 9
14 14 14
2 1 1 1
2 2 2
1 1 1
2 1 1 1
1 1
1 1 1
3 3 3
1 1 1
1 1 1
1 1 1
2 2 2
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1

3 3 3
1 1 1
1 1 1

3 3 3
1 1 1
2 2 2
1 1 1

2 2 2
1 1 1 1 pc new stock
2 2 2
5 5 5
5 4 1 4 3 pcs new stock
4 4 4 4 pcs new stock

1009 5912
ITEM NOT YET OUT IN
THE SYSTEM (WALA PA
NABAYRAN PERO NA OUT
NA SA ACTUAL )

You might also like