TCSInvTopSales
ACME TRUCK SERVICING LTD
Top 20 Inventory Sales Report
From first group to last group,  for the period from 01 Apr 2003 to 30 Sep 2003,  analysed by account group,  ordered by total sales value
For all warehouses
Account
Account Name
Total Cost
Total Sale
Mar %
Qty
Total Margin
Mar %
Unit Margin
Unit Cost
Unit Sale
Account Group:  I10  -  Electrical System
108200
Battery, 12 Volt 37 Plate
25
333.72
259.33
74.39
22.29%
8,343.11
6,483.25
1,859.86
22.29%
108150
Battery, 12 Volt 27 Plate
17
270.70
206.62
64.08
23.67%
4,601.89
3,512.53
1,089.36
23.67%
108120
Battery, 12 Volt 21 Plate
14
245.00
174.30
70.70
28.86%
3,429.94
2,440.20
989.74
28.86%
100810
Lamp, L/Range Driving 12V 100W
17
81.07
72.30
8.77
10.82%
1,378.17
1,229.10
149.07
10.82%
100805
Lamp, L/Range Driving 12V 55W
13
81.45
66.54
14.91
18.31%
1,058.85
865.07
193.78
18.30%
Total for Electrical System:
86
18,811.96
14,530.15
4,281.81
22.76%
Account Group:  I11  -  Engine Servicing
117152
Fuel Filter, Perkins
82
36.27
18.69
17.58
48.47%
2,973.88
1,532.87
1,441.01
48.46%
117151
Fuel Filter, Detroit 8.2
57
43.01
24.41
18.60
43.25%
2,451.73
1,391.13
1,060.60
43.26%
114152
Oil Filter, Perkins
82
21.94
11.61
10.33
47.08%
1,799.08
952.02
847.06
47.08%
114151
Oil Filter, Detroit 8.2
57
22.56
12.19
10.37
45.97%
1,286.02
695.03
590.99
45.95%
Total for Engine Servicing:
278
8,510.71
4,571.05
3,939.66
46.29%
Account Group:  I12  -  Exhaust System
122103
Exhaust Tubing, 3"
115
14.21
10.82
3.39
23.86%
1,633.65
1,244.59
389.06
23.82%
122104
Exhaust Tubing, 4"
67
15.70
12.41
3.29
20.96%
1,051.97
831.60
220.37
20.95%
122105
Exhaust Tubing, 5"
35
22.54
17.53
5.01
22.23%
788.95
613.41
175.54
22.25%
Total for Exhaust System:
217
3,474.57
2,689.60
784.97
22.59%
Account Group:  I14  -  Braking System
142312
Brake Lining Set, COF 0.36
86
215.46
170.85
44.61
20.70%
18,529.74
14,692.78
3,836.96
20.71%
141607
Brake Drum, 16", 5 Spoke
24
270.78
223.29
47.49
17.54%
6,498.66
5,359.06
1,139.60
17.54%
141605
Brake Drum, 15", 3 Spoke
23
248.07
203.68
44.39
17.89%
5,705.71
4,684.72
1,020.99
17.89%
143330
Service Chamber, Type 30
33
64.06
51.16
12.90
20.14%
2,114.09
1,688.36
425.73
20.14%
143320
Service Chamber, Type 20
32
53.44
43.45
9.99
18.69%
1,710.02
1,390.29
319.73
18.70%
143324
Service Chamber, Type 24
26
63.77
50.36
13.41
21.03%
1,657.89
1,309.33
348.56
21.02%
145710A
Slack Adjuster, 10 Spline
23
36.57
30.86
5.71
15.61%
841.15
709.80
131.35
15.62%
Total for Braking System:
247
37,057.26
29,834.34
7,222.92
19.49%
Account Group:  I19  -  Major Components
197151
Detroit 8.2 Engine Re-manf
12
22,633.33
15,322.92
7,310.41
32.30%
271,600.00
183,875.00
87,725.00
32.30%
Total for Major Components:
12
271,600.00
183,875.00
87,725.00
32.30%
Total 20 largest:
840
339,454.50
235,500.14
103,954.36
30.62%
Total all others:
322
6,601.36
5,189.21
1,412.15
21.39%
Overall Total:
346,055.86
240,689.35
105,366.51
30.45%
1,162
Page 1 of 1
Printed on 22 Dec 2003 at 09:25 AM