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 salesperson,  ordered by total sales margin
For all warehouses
Account
Account Name
Total Cost
Total Sale
Mar %
Qty
Total Margin
Mar %
Unit Margin
Unit Cost
Unit Sale
Salesperson:  101  -  Garry Smith
197151
Detroit 8.2 Engine Re-manf
6
21,966.67
15,270.83
6,695.84
30.48%
131,800.00
91,625.00
40,175.00
30.48%
142312
Brake Lining Set, COF 0.36
43
214.95
169.64
45.31
21.08%
9,242.73
7,294.58
1,948.15
21.08%
108200
Battery, 12 Volt 37 Plate
15
333.14
260.88
72.26
21.69%
4,997.13
3,913.20
1,083.93
21.69%
108150
Battery, 12 Volt 27 Plate
11
272.12
205.30
66.82
24.56%
2,993.33
2,258.26
735.07
24.56%
117152
Fuel Filter, Perkins
39
37.05
18.69
18.36
49.55%
1,444.90
728.99
715.91
49.55%
141605
Brake Drum, 15", 3 Spoke
16
245.57
203.61
41.96
17.09%
3,929.16
3,257.69
671.47
17.09%
117151
Fuel Filter, Detroit 8.2
37
42.20
24.19
18.01
42.68%
1,561.25
894.88
666.37
42.68%
141607
Brake Drum, 16", 5 Spoke
7
282.55
220.41
62.14
21.99%
1,977.85
1,542.90
434.95
21.99%
114152
Oil Filter, Perkins
39
22.41
11.62
10.79
48.15%
874.10
453.02
421.08
48.17%
114151
Oil Filter, Detroit 8.2
37
22.59
12.08
10.51
46.53%
836.00
447.02
388.98
46.53%
108120
Battery, 12 Volt 21 Plate
5
249.45
174.30
75.15
30.13%
1,247.25
871.50
375.75
30.13%
122103
Exhaust Tubing, 3"
80
14.24
10.82
3.42
24.02%
1,139.50
865.56
273.94
24.04%
143330
Service Chamber, Type 30
18
62.99
51.64
11.35
18.02%
1,133.84
929.60
204.24
18.01%
143324
Service Chamber, Type 24
14
64.36
49.91
14.45
22.45%
900.97
698.70
202.27
22.45%
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%
143320
Service Chamber, Type 20
15
52.86
42.15
10.71
20.26%
792.85
632.26
160.59
20.25%
165151
Detroit 8.2 Waterpump Re-manf
1
245.00
140.00
105.00
42.86%
245.00
140.00
105.00
42.86%
122104
Exhaust Tubing, 4"
20
15.50
12.40
3.10
20.00%
309.90
248.02
61.88
19.97%
122105
Exhaust Tubing, 5"
10
23.55
17.51
6.04
25.65%
235.50
175.07
60.43
25.66%
100810
Lamp, L/Range Driving 12V 100W
8
77.71
73.43
4.28
5.51%
621.70
587.40
34.30
5.52%
Total for Garry Smith:
434
167,341.81
118,428.72
48,913.09
29.23%
Salesperson:  102  -  Chris Jones
197151
Detroit 8.2 Engine Re-manf
6
23,300.00
15,375.00
7,925.00
34.01%
139,800.00
92,250.00
47,550.00
34.01%
142312
Brake Lining Set, COF 0.36
41
215.72
171.74
43.98
20.39%
8,844.51
7,041.40
1,803.11
20.39%
108200
Battery, 12 Volt 37 Plate
10
334.60
257.01
77.59
23.19%
3,345.98
2,570.05
775.93
23.19%
117152
Fuel Filter, Perkins
43
35.56
18.69
16.87
47.44%
1,528.98
803.88
725.10
47.42%
141607
Brake Drum, 16", 5 Spoke
17
265.93
224.48
41.45
15.59%
4,520.81
3,816.16
704.65
15.59%
108120
Battery, 12 Volt 21 Plate
9
242.52
174.30
68.22
28.13%
2,182.69
1,568.70
613.99
28.13%
114152
Oil Filter, Perkins
43
21.51
11.60
9.91
46.07%
924.98
499.00
425.98
46.05%
117151
Fuel Filter, Detroit 8.2
20
44.52
24.81
19.71
44.27%
890.48
496.25
394.23
44.27%
108150
Battery, 12 Volt 27 Plate
6
268.09
209.05
59.04
22.02%
1,608.56
1,254.27
354.29
22.03%
141605
Brake Drum, 15", 3 Spoke
7
253.79
203.86
49.93
19.67%
1,776.55
1,427.03
349.52
19.67%
143330
Service Chamber, Type 30
15
65.35
50.58
14.77
22.60%
980.25
758.76
221.49
22.60%
114151
Oil Filter, Detroit 8.2
20
22.50
12.40
10.10
44.89%
450.02
248.01
202.01
44.89%
143320
Service Chamber, Type 20
17
53.95
44.59
9.36
17.35%
917.17
758.03
159.14
17.35%
165151
Detroit 8.2 Waterpump Re-manf
1
280.00
140.00
140.00
50.00%
280.00
140.00
140.00
50.00%
122104
Exhaust Tubing, 4"
42
15.67
12.42
3.25
20.74%
658.32
521.47
136.85
20.79%
Page 1 of 2
Printed on 22 Dec 2003 at 09:26 AM

TCSInvTopSales
ACME TRUCK SERVICING LTD
Top 20 Inventory Sales Report
Account
Account Name
Total Cost
Total Sale
Mar %
Qty
Total Margin
Mar %
Unit Margin
Unit Cost
Unit Sale
Salesperson:  102  -  Chris Jones
143324
Service Chamber, Type 24
10
62.64
50.32
12.32
19.67%
626.42
503.23
123.19
19.67%
122103
Exhaust Tubing, 3"
35
14.12
10.83
3.29
23.30%
494.15
379.03
115.12
23.30%
122105
Exhaust Tubing, 5"
25
22.14
17.53
4.61
20.82%
553.45
438.34
115.11
20.80%
100810
Lamp, L/Range Driving 12V 100W
9
84.05
71.30
12.75
15.17%
756.47
641.70
114.77
15.17%
Total for Chris Jones:
376
171,139.79
116,115.31
55,024.48
32.15%
Salesperson:  201  -  Terry Williams
142312
Brake Lining Set, COF 0.36
2
221.25
178.40
42.85
19.37%
442.50
356.80
85.70
19.37%
143324
Service Chamber, Type 24
2
65.25
53.70
11.55
17.70%
130.50
107.40
23.10
17.70%
122104
Exhaust Tubing, 4"
5
16.75
12.42
4.33
25.85%
83.75
62.11
21.64
25.84%
Total for Terry Williams:
9
656.75
526.31
130.44
19.86%
Total 20 largest:
819
339,138.35
235,070.34
104,068.01
30.69%
Total all others:
343
6,917.51
5,619.01
1,298.50
18.77%
Overall Total:
346,055.86
240,689.35
105,366.51
30.45%
1,162
Page 2 of 2
Printed on 22 Dec 2003 at 09:26 AM