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