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,  ordered by sales quantity
For all warehouses
Account
Account Name
Total Cost
Total Sale
Mar %
Qty
Total Margin
Mar %
Unit Margin
Unit Cost
Unit Sale
122103
Exhaust Tubing, 3"
115
14.21
10.82
3.39
23.86%
1,633.65
1,244.59
389.06
23.82%
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%
114152
Oil Filter, Perkins
82
21.94
11.61
10.33
47.08%
1,799.08
952.02
847.06
47.08%
117152
Fuel Filter, Perkins
82
36.27
18.69
17.58
48.47%
2,973.88
1,532.87
1,441.01
48.46%
122104
Exhaust Tubing, 4"
67
15.70
12.41
3.29
20.96%
1,051.97
831.60
220.37
20.95%
114151
Oil Filter, Detroit 8.2
57
22.56
12.19
10.37
45.97%
1,286.02
695.03
590.99
45.95%
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%
122204
Exhaust Clamp, 4"
44
17.10
13.92
3.18
18.60%
752.26
612.37
139.89
18.60%
122203
Exhaust Clamp, 3"
39
15.83
12.42
3.41
21.54%
617.33
484.54
132.79
21.51%
122105
Exhaust Tubing, 5"
35
22.54
17.53
5.01
22.23%
788.95
613.41
175.54
22.25%
103104
Lamp, Cab Marker, Amber
34
12.14
9.66
2.48
20.43%
412.70
328.48
84.22
20.41%
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%
103100
Lamp, Cab Marker, Clear
31
12.11
9.46
2.65
21.88%
375.35
293.27
82.08
21.87%
143324
Service Chamber, Type 24
26
63.77
50.36
13.41
21.03%
1,657.89
1,309.33
348.56
21.02%
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%
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%
145710A
Slack Adjuster, 10 Spline
23
36.57
30.86
5.71
15.61%
841.15
709.80
131.35
15.62%
103105
Lamp, Cab Marker, Red
21
12.09
9.59
2.50
20.68%
253.97
201.32
52.65
20.73%
Total 20 largest:
936
59,797.26
45,498.22
14,299.04
23.91%
Total all others:
226
286,258.60
195,191.13
91,067.47
31.81%
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:23 AM