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 credit quantity & transaction count thresholds
Analysed by ABC code DDEM - Sales Qty & Trn-Value Analysis
Account
Account Name
Rank
Item Qty & Count
Rank Qty & Count
142312
Brake Lining Set, COF 0.36
A
91
22
>50
>20
114151-S2
Oil Filter, Detroit 8.2
B
61
13
>20
>10
117151-S2
Fuel Filter, Detroit 8.2
B
51
12
143320
Service Chamber, Type 20
B
33
13
145710B
Slack Adjuster, 10 Spline
B
22
10
117152-S2
Fuel Filter, Perkins
C
39
7
>10
>5
145728B
Slack Adjuster, 28 Spline
C
32
8
143324
Service Chamber, Type 24
C
30
5
143330
Service Chamber, Type 30
C
27
8
108150
Battery, 12 Volt 27 Plate
C
11
5
122103
Exhaust Tubing, 3"
D
84
1
<10
<5
122104
Exhaust Tubing, 4"
D
76
3
122105
Exhaust Tubing, 5"
D
57
2
114152-S2
Oil Filter, Perkins
D
32
4
122204
Exhaust Clamp, 4"
D
31
4
103100
Lamp, Cab Marker, Clear
D
21
3
103105
Lamp, Cab Marker, Red
D
20
3
122203
Exhaust Clamp, 3"
D
20
2
141607
Brake Drum, 16", 5 Spoke
D
16
3
103104
Lamp, Cab Marker, Amber
D
14
3
122205
Exhaust Clamp, 5"
D
12
1
141605
Brake Drum, 15", 3 Spoke
D
11
3
108120
Battery, 12 Volt 21 Plate
D
8
2
108200
Battery, 12 Volt 37 Plate
D
8
1
103207
Bulb 24V, Licence Plate
D
6
2
100805
Lamp, L/Range Driving 12V 55W
D
5
1
165151
Detroit 8.2 Waterpump Re-manf
D
3
3
100810
Lamp, L/Range Driving 12V 100W
D
3
1
101692
Headlamp Insert, Outer, Q/H
D
2
2
145710A
Slack Adjuster, 10 Spline
D
2
1
101691
Headlamp Insert, Inner, Q/H
D
1
1
119151
Top Hose, Radiator
D
1
1
165159
Misc Waterpump Re-manf
D
1
1
197151
Detroit 8.2 Engine Re-manf
D
1
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:03 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
<5
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:03 PM