TCSInvABCAnalysis
ABC Analysis Report as at 31 Dec 2006
ACME TRUCK SERVICING LTD
For control account 150 - Inventory Master Control
From warehouse codes
MAIN, HAM
Ranking based on 6 months Out transaction nett quantity thresholds
Analysed by ABC code SDEM - Sales Tran Qty-Value Analysis
Account
Account Name
Rank
Item Qty & Count
Rank Qty & Count
142312
Brake Lining Set, COF 0.36
A
90
>50
122103
Exhaust Tubing, 3"
A
84
122104
Exhaust Tubing, 4"
A
76
114151-S2
Oil Filter, Detroit 8.2
A
61
122105
Exhaust Tubing, 5"
A
57
117151-S2
Fuel Filter, Detroit 8.2
A
51
117152-S2
Fuel Filter, Perkins
B
39
>20
114152-S2
Oil Filter, Perkins
B
32
143320
Service Chamber, Type 20
B
32
145728B
Slack Adjuster, 28 Spline
B
32
122204
Exhaust Clamp, 4"
B
31
143324
Service Chamber, Type 24
B
30
143330
Service Chamber, Type 30
B
27
145710B
Slack Adjuster, 10 Spline
B
22
103100
Lamp, Cab Marker, Clear
B
21
103105
Lamp, Cab Marker, Red
B
20
122203
Exhaust Clamp, 3"
B
20
141607
Brake Drum, 16", 5 Spoke
C
16
>10
103104
Lamp, Cab Marker, Amber
C
14
122205
Exhaust Clamp, 5"
C
12
141605
Brake Drum, 15", 3 Spoke
C
11
108150
Battery, 12 Volt 27 Plate
C
10
108120
Battery, 12 Volt 21 Plate
D
8
<10
108200
Battery, 12 Volt 37 Plate
D
8
103207
Bulb 24V, Licence Plate
D
6
100805
Lamp, L/Range Driving 12V 55W
D
5
100810
Lamp, L/Range Driving 12V 100W
D
3
165151
Detroit 8.2 Waterpump Re-manf
D
3
101692
Headlamp Insert, Outer, Q/H
D
2
145710A
Slack Adjuster, 10 Spline
D
2
101691
Headlamp Insert, Inner, Q/H
D
1
119151
Top Hose, Radiator
D
1
165159
Misc Waterpump Re-manf
D
1
197151
Detroit 8.2 Engine Re-manf
D
1
100804
Lamp, Driving 12V 45W
D
105205
Bulb 12V 55W, Q/H
D
105210
Bulb 12V 100W, Q/H
D
105407
Bulb 24V 70W, Q/H
D
105410
Bulb 24V 100W, Q/H
D
108700
Fuse Kit, 5A - 30A
D
108701
Fuse 5A, Blade
D
108702
Fuse 7.5A, Blade
D
108705
Fuse 20A, Blade
D
108706
Fuse 25A, Blade
D
108707
Fuse 30A, Blade
D
114151
Oil Filter, Detroit 8.2
D
114152
Oil Filter, Perkins
D
114152-S1
Oil Filter, Perkins
D
117151
Fuel Filter, Detroit 8.2
D
117152
Fuel Filter, Perkins
D
117152-S1
Fuel Filter, Perkins
D
119151-NZ
Radiator, Top Hose (NZ Mod)
D
Page 1 of 2
Printed on 09 Jan 2007 at 12:00 PM
TCSInvABCAnalysis
ABC Analysis Report as at 31 Dec 2006
ACME TRUCK SERVICING LTD
Account
Account Name
Rank
Item Qty & Count
Rank Qty & Count
<10
119152
Bottom Hose, Radiator
D
145710
Slack Adjuster, 10 Spline
D
145728
Slack Adjuster, 28 Spline
D
145728A
Slack Adjuster, 28 Spline
D
169190
Waterpump Core Deposit
D
199190
Engine Core Deposit
D
Page 2 of 2
Printed on 09 Jan 2007 at 12:00 PM