TCSDebtItemSales
ACME TRUCK SERVICING LTD
Summary Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
For no related accounts, from first group to last group, from first account to last account, ordered by account alpha key
All control accounts
For all warehouses
For all franchises
From first group to last group, from first account to last account, analysed by item number, excluding job issues
Item Code & Description
Cost Total
Qty
Margin
Average Price
Sales Total
Account Name
Account
28.31%
1,087.90
1,517.54
8
189.69
11480
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
141605 Brake Drum, 15", 3 Spoke
220.45
2
440.90
399.25
9.45%
142312 Brake Lining Set, COF 0.36
309.15
3
927.45
555.20
40.14%
143320 Service Chamber, Type 20
49.73
3
149.19
133.45
10.55%
43.69%
2,175.37
3,863.20
18
214.62
11520
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
142312 Brake Lining Set, COF 0.36
343.50
10
3,435.00
1,852.96
46.06%
143320 Service Chamber, Type 20
55.25
2
110.50
88.97
19.48%
143324 Service Chamber, Type 24
143330 Service Chamber, Type 30
65.35
2
130.70
105.24
19.48%
145710B Slack Adjuster, 10 Spline
49.75
2
99.50
68.25
31.41%
145728B Slack Adjuster, 28 Spline
43.75
2
87.50
59.95
31.49%
33.41%
1,291.58
1,939.72
10
193.97
11540
Hutt Transport Supplies, P O Box 11-540, Lower Hutt, Wellington 5040
142312 Brake Lining Set, COF 0.36
291.98
6
1,751.88
1,110.42
36.62%
143320 Service Chamber, Type 20
46.96
4
187.84
181.16
3.56%
15.10%
33,018.36
38,888.94
445
87.39
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231
100805 Lamp, L/Range Driving 12V 55W
71.27
5
356.35
325.66
8.61%
100810 Lamp, L/Range Driving 12V 100W
76.08
3
228.24
208.80
8.52%
103100 Lamp, Cab Marker, Clear
10.89
11
119.79
107.80
10.01%
103104 Lamp, Cab Marker, Amber
10.89
7
76.23
68.58
10.04%
103105 Lamp, Cab Marker, Red
10.89
12
130.68
117.60
10.01%
103207 Bulb 24V, Licence Plate
13.78
5
68.90
58.11
15.66%
108120 Battery, 12 Volt 21 Plate
218.27
7
1,527.89
1,220.10
20.14%
108150 Battery, 12 Volt 27 Plate
244.78
5
1,223.90
976.50
20.21%
108200 Battery, 12 Volt 37 Plate
305.77
8
2,446.16
1,954.40
20.10%
114151-S2 Oil Filter, Detroit 8.2
19.86
14
278.04
144.95
47.87%
114152-S2 Oil Filter, Perkins
25.81
18
464.58
316.96
31.77%
117151-S2 Fuel Filter, Detroit 8.2
39.73
13
516.49
265.29
48.64%
117152-S2 Fuel Filter, Perkins
42.44
18
763.92
515.72
32.49%
122103 Exhaust Tubing, 3"
12.91
84
1,084.44
877.25
19.11%
122104 Exhaust Tubing, 4"
14.66
65
952.90
810.71
14.92%
122105 Exhaust Tubing, 5"
20.61
51
1,051.11
864.89
17.72%
122203 Exhaust Clamp, 3"
14.48
18
260.64
197.10
24.38%
122204 Exhaust Clamp, 4"
16.23
24
389.52
286.80
26.37%
122205 Exhaust Clamp, 5"
17.98
12
215.76
179.45
16.83%
Page 1 of 2
Printed on 01 May 2007 at 12:34 PM
TCSDebtItemSales
ACME TRUCK SERVICING LTD
Summary Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
Item Code & Description
Cost Total
Qty
Margin
Average Price
Sales Total
Account Name
Account
15.10%
33,018.36
38,888.94
445
87.39
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231 (Cont.)
141605 Brake Drum, 15", 3 Spoke
226.93
7
1,588.51
1,397.39
12.03%
141607 Brake Drum, 16", 5 Spoke
247.23
14
3,461.22
3,051.99
11.82%
142312 Brake Lining Set, COF 0.36
300.56
13
3,907.28
2,406.80
38.40%
143320 Service Chamber, Type 20
48.34
4
193.36
177.95
7.97%
143324 Service Chamber, Type 24
52.72
8
421.76
418.71
0.72%
143330 Service Chamber, Type 30
57.18
4
228.72
210.47
7.98%
145710B Slack Adjuster, 10 Spline
43.53
4
174.12
136.52
21.59%
145728B Slack Adjuster, 28 Spline
38.28
6
229.68
179.86
21.69%
165151 Detroit 8.2 Waterpump Re-manf
201.25
3
603.75
672.00
-11.30%
165159 Misc Waterpump Re-manf
175.00
1
175.00
120.00
31.43%
197151 Detroit 8.2 Engine Re-manf
15,750.00
1
15,750.00
14,750.00
6.35%
43.40%
979.88
1,731.20
12
144.27
11650
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
114151-S2 Oil Filter, Detroit 8.2
22.70
2
45.40
19.86
56.26%
117151-S2 Fuel Filter, Detroit 8.2
45.40
2
90.80
38.58
57.51%
142312 Brake Lining Set, COF 0.36
343.50
4
1,374.00
740.28
46.12%
143320 Service Chamber, Type 20
55.25
4
221.00
181.16
18.03%
38.23%
3,247.98
5,257.95
83
63.35
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001
108120 Battery, 12 Volt 21 Plate
249.45
1
249.45
174.32
30.12%
114151-S2 Oil Filter, Detroit 8.2
22.70
10
227.00
90.83
59.99%
114152-S2 Oil Filter, Perkins
29.50
8
236.00
119.00
49.58%
122104 Exhaust Tubing, 4"
16.75
10
167.50
124.73
25.53%
122105 Exhaust Tubing, 5"
23.55
6
141.30
101.92
27.87%
122203 Exhaust Clamp, 3"
16.55
2
33.10
23.01
30.48%
122204 Exhaust Clamp, 4"
18.55
2
37.10
25.30
31.81%
142312 Brake Lining Set, COF 0.36
343.50
6
2,061.00
1,030.29
50.01%
143320 Service Chamber, Type 20
55.25
8
442.00
339.77
23.13%
143324 Service Chamber, Type 24
60.25
6
361.50
299.68
17.10%
143330 Service Chamber, Type 30
65.35
10
653.50
500.94
23.35%
145710B Slack Adjuster, 10 Spline
49.75
6
298.50
192.36
35.56%
145728B Slack Adjuster, 28 Spline
43.75
8
350.00
225.83
35.48%
42.37%
459.56
797.50
4
199.38
11900
Wanganui Transport Ltd, P O Box 900, Gonville, Wanganui 4543
142312 Brake Lining Set, COF 0.36
343.50
2
687.00
370.59
46.06%
143320 Service Chamber, Type 20
55.25
2
110.50
88.97
19.48%
Total:
93.10
580
53,996.05
42,260.63
21.73%
Page 2 of 2
Printed on 01 May 2007 at 12:34 PM