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, QA
Ranking based on average cost percentages
Analysed by ABC code ACOST - Average Cost-Percent Analysis
Account
Account Name
Rank
Cum %
Value
Val %
Cum Value
142312
Brake Lining Set, COF 0.36
A
14,806
14,806
29.63%
29.63%
141605
Brake Drum, 15", 3 Spoke
A
3,399
18,205
36.43%
6.80%
141607
Brake Drum, 16", 5 Spoke
A
3,053
21,258
42.54%
6.11%
108200
Battery, 12 Volt 37 Plate
A
2,932
24,190
48.41%
5.87%
122105
Exhaust Tubing, 5"
A
2,119
26,309
52.65%
4.24%
122205
Exhaust Clamp, 5"
A
1,779
28,088
56.21%
3.56%
108150
Battery, 12 Volt 27 Plate
A
1,758
29,846
59.72%
3.52%
122104
Exhaust Tubing, 4"
A
1,489
31,335
62.70%
2.98%
108120
Battery, 12 Volt 21 Plate
A
1,394
32,729
65.49%
2.79%
143324
Service Chamber, Type 24
A
1,346
34,075
68.19%
2.69%
143330
Service Chamber, Type 30
A
1,341
35,416
70.87%
2.68%
122204
Exhaust Clamp, 4"
A
1,159
36,575
73.19%
2.32%
122203
Exhaust Clamp, 3"
A
1,117
37,692
75.42%
2.24%
143320
Service Chamber, Type 20
A
1,076
38,768
77.58%
2.15%
122103
Exhaust Tubing, 3"
A
995
39,763
79.57%
1.99%
145710B
Slack Adjuster, 10 Spline
A
979
40,742
81.53%
1.96%
165151
Detroit 8.2 Waterpump Re-manf
B
846
41,588
83.22%
1.69%
117151-S2
Fuel Filter, Detroit 8.2
B
791
42,379
84.80%
1.58%
101692
Headlamp Insert, Outer, Q/H
B
787
43,166
86.38%
1.57%
101691
Headlamp Insert, Inner, Q/H
B
754
43,920
87.89%
1.51%
100810
Lamp, L/Range Driving 12V 100W
B
696
44,616
89.28%
1.39%
117152-S2
Fuel Filter, Perkins
B
659
45,275
90.60%
1.32%
145728B
Slack Adjuster, 28 Spline
C
448
45,723
91.50%
0.90%
119151-NZ
Radiator, Top Hose (NZ Mod)
C
415
46,138
92.33%
0.83%
114151-S2
Oil Filter, Detroit 8.2
C
407
46,545
93.14%
0.81%
114152-S2
Oil Filter, Perkins
C
406
46,951
93.95%
0.81%
119151
Top Hose, Radiator
C
399
47,350
94.75%
0.80%
119152
Bottom Hose, Radiator
C
392
47,742
95.54%
0.78%
100805
Lamp, L/Range Driving 12V 55W
D
326
48,068
96.19%
0.65%
105410
Bulb 24V 100W, Q/H
D
243
48,311
96.67%
0.49%
103104
Lamp, Cab Marker, Amber
D
225
48,536
97.12%
0.45%
103207
Bulb 24V, Licence Plate
D
220
48,756
97.56%
0.44%
103105
Lamp, Cab Marker, Red
D
216
48,972
98.00%
0.43%
103100
Lamp, Cab Marker, Clear
D
196
49,168
98.39%
0.39%
105407
Bulb 24V 70W, Q/H
D
170
49,338
98.73%
0.34%
105210
Bulb 12V 100W, Q/H
D
168
49,506
99.07%
0.34%
105205
Bulb 12V 55W, Q/H
D
121
49,627
99.31%
0.24%
100804
Lamp, Driving 12V 45W
D
59
49,686
99.43%
0.12%
108700
Fuse Kit, 5A - 30A
D
56
49,742
99.54%
0.11%
108701
Fuse 5A, Blade
D
49
49,791
99.64%
0.10%
108702
Fuse 7.5A, Blade
D
45
49,836
99.73%
0.09%
108705
Fuse 20A, Blade
D
39
49,875
99.80%
0.08%
108707
Fuse 30A, Blade
D
39
49,914
99.88%
0.08%
108706
Fuse 25A, Blade
D
37
49,951
99.96%
0.07%
114151
Oil Filter, Detroit 8.2
D
23
49,974
100.00%
0.05%
114152
Oil Filter, Perkins
D
49,974
100.00%
114152-S1
Oil Filter, Perkins
D
49,974
100.00%
117151
Fuel Filter, Detroit 8.2
D
49,974
100.00%
117152
Fuel Filter, Perkins
D
49,974
100.00%
117152-S1
Fuel Filter, Perkins
D
49,974
100.00%
145710
Slack Adjuster, 10 Spline
D
49,974
100.00%
145710A
Slack Adjuster, 10 Spline
D
49,974
100.00%
Page 1 of 2
Printed on 09 Jan 2007 at 11:56 AM
TCSInvABCAnalysis
ABC Analysis Report as at 31 Dec 2006
ACME TRUCK SERVICING LTD
Account
Account Name
Rank
Cum %
Value
Val %
Cum Value
145728
Slack Adjuster, 28 Spline
D
49,974
100.00%
145728A
Slack Adjuster, 28 Spline
D
49,974
100.00%
165159
Misc Waterpump Re-manf
D
49,974
100.00%
169190
Waterpump Core Deposit
D
49,974
100.00%
197151
Detroit 8.2 Engine Re-manf
D
49,974
100.00%
199190
Engine Core Deposit
D
49,974
100.00%
Page 2 of 2
Printed on 09 Jan 2007 at 11:56 AM