TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed 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
Margin
Cost Value
Sales Value
Unit Price
Qty
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
SALES TOTAL
MARGIN
QTY
COST TOTAL
ITEM CODE & DESCRIPTION
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%
MAIN
SI000579
28 Aug 2006
2
9.45%
220.45
440.90
399.25
142312 Brake Lining Set, COF 0.36
3
927.45
555.20
40.14%
MAIN
SI000579
28 Aug 2006
4
40.14%
309.15
1,236.60
740.27
MAIN
SR000033
31 Aug 2006
-1
40.14%
-309.15
-309.15
-185.07
143320 Service Chamber, Type 20
3
149.19
133.45
10.55%
MAIN
SI000579
28 Aug 2006
4
10.55%
49.73
198.92
177.94
MAIN
SR000033
31 Aug 2006
-1
10.54%
-49.73
-49.73
-44.49
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%
MAIN
SI000576
18 Aug 2006
10
46.06%
343.50
3,435.00
1,852.96
143320 Service Chamber, Type 20
2
110.50
88.97
19.48%
MAIN
SI000576
18 Aug 2006
2
19.48%
55.25
110.50
88.97
143324 Service Chamber, Type 24
MAIN
SI000576
18 Aug 2006
2
13.13%
60.25
120.50
104.68
MAIN
SR000035
31 Aug 2006
-2
13.13%
-60.25
-120.50
-104.68
143330 Service Chamber, Type 30
2
130.70
105.24
19.48%
MAIN
SI000576
18 Aug 2006
2
19.48%
65.35
130.70
105.24
145710B Slack Adjuster, 10 Spline
2
99.50
68.25
31.41%
MAIN
SI000576
18 Aug 2006
2
31.41%
49.75
99.50
68.25
145728B Slack Adjuster, 28 Spline
2
87.50
59.95
31.49%
MAIN
SI000576
18 Aug 2006
2
31.49%
43.75
87.50
59.95
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%
MAIN
SI000616
31 Aug 2006
6
36.62%
291.98
1,751.88
1,110.42
143320 Service Chamber, Type 20
4
187.84
181.16
3.56%
MAIN
SI000616
31 Aug 2006
4
3.56%
46.96
187.84
181.16
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%
MAIN
SI000582
31 Aug 2006
5
8.61%
71.27
356.35
325.66
100810 Lamp, L/Range Driving 12V 100W
3
228.24
208.80
8.52%
MAIN
SI000582
31 Aug 2006
3
8.52%
76.08
228.24
208.80
103100 Lamp, Cab Marker, Clear
11
119.79
107.80
10.01%
MAIN
SI000582
31 Aug 2006
11
10.01%
10.89
119.79
107.80
Page 1 of 4
Printed on 03 Apr 2007 at 09:22 AM
TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Customer Sales Analysis
Margin
Cost Value
Sales Value
Unit Price
Qty
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
SALES TOTAL
MARGIN
QTY
COST TOTAL
ITEM CODE & DESCRIPTION
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231 (Cont.)
445
38,888.94
33,018.36
15.10%
103104 Lamp, Cab Marker, Amber
7
76.23
68.58
10.04%
MAIN
SI000582
31 Aug 2006
7
10.04%
10.89
76.23
68.58
103105 Lamp, Cab Marker, Red
12
130.68
117.60
10.01%
MAIN
SI000582
31 Aug 2006
12
10.01%
10.89
130.68
117.60
103207 Bulb 24V, Licence Plate
5
68.90
58.11
15.66%
MAIN
SI000582
31 Aug 2006
5
15.66%
13.78
68.90
58.11
108120 Battery, 12 Volt 21 Plate
7
1,527.89
1,220.10
20.14%
MAIN
SI000582
31 Aug 2006
7
20.14%
218.27
1,527.89
1,220.10
108150 Battery, 12 Volt 27 Plate
5
1,223.90
976.50
20.21%
MAIN
SI000582
31 Aug 2006
5
20.21%
244.78
1,223.90
976.50
108200 Battery, 12 Volt 37 Plate
8
2,446.16
1,954.40
20.10%
MAIN
SI000582
31 Aug 2006
8
20.10%
305.77
2,446.16
1,954.40
114151-S2 Oil Filter, Detroit 8.2
14
278.04
144.95
47.87%
MAIN
SI000582
31 Aug 2006
14
47.87%
19.86
278.04
144.95
114152-S2 Oil Filter, Perkins
18
464.58
316.96
31.77%
MAIN
SI000582
31 Aug 2006
18
31.77%
25.81
464.58
316.96
117151-S2 Fuel Filter, Detroit 8.2
13
516.49
265.29
48.64%
MAIN
SI000582
31 Aug 2006
13
48.64%
39.73
516.49
265.29
117152-S2 Fuel Filter, Perkins
18
763.92
515.72
32.49%
MAIN
SI000582
31 Aug 2006
18
32.49%
42.44
763.92
515.72
122103 Exhaust Tubing, 3"
84
1,084.44
877.25
19.11%
MAIN
SI000582
31 Aug 2006
84
19.11%
12.91
1,084.44
877.25
122104 Exhaust Tubing, 4"
65
952.90
810.71
14.92%
MAIN
SI000582
31 Aug 2006
65
14.92%
14.66
952.90
810.71
122105 Exhaust Tubing, 5"
51
1,051.11
864.89
17.72%
MAIN
SI000582
31 Aug 2006
51
17.72%
20.61
1,051.11
864.89
122203 Exhaust Clamp, 3"
18
260.64
197.10
24.38%
MAIN
SI000582
31 Aug 2006
18
24.38%
14.48
260.64
197.10
122204 Exhaust Clamp, 4"
24
389.52
286.80
26.37%
MAIN
SI000582
31 Aug 2006
24
26.37%
16.23
389.52
286.80
122205 Exhaust Clamp, 5"
12
215.76
179.45
16.83%
MAIN
SI000582
31 Aug 2006
12
16.83%
17.98
215.76
179.45
141605 Brake Drum, 15", 3 Spoke
7
1,588.51
1,397.39
12.03%
MAIN
SI000582
31 Aug 2006
7
12.03%
226.93
1,588.51
1,397.39
141607 Brake Drum, 16", 5 Spoke
14
3,461.22
3,051.99
11.82%
MAIN
SI000573
07 Aug 2006
2
11.82%
247.23
494.46
436.00
MAIN
SI000582
31 Aug 2006
12
11.82%
247.23
2,966.76
2,615.99
142312 Brake Lining Set, COF 0.36
13
3,907.28
2,406.80
38.40%
MAIN
SI000573
07 Aug 2006
4
38.35%
300.56
1,202.24
741.18
MAIN
SI000582
31 Aug 2006
9
38.43%
300.56
2,705.04
1,665.62
Page 2 of 4
Printed on 03 Apr 2007 at 09:22 AM
TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Customer Sales Analysis
Margin
Cost Value
Sales Value
Unit Price
Qty
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
SALES TOTAL
MARGIN
QTY
COST TOTAL
ITEM CODE & DESCRIPTION
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231 (Cont.)
445
38,888.94
33,018.36
15.10%
143320 Service Chamber, Type 20
4
193.36
177.95
7.97%
MAIN
SI000573
07 Aug 2006
2
7.97%
48.34
96.68
88.97
MAIN
SI000582
31 Aug 2006
2
7.96%
48.34
96.68
88.98
143324 Service Chamber, Type 24
8
421.76
418.71
0.72%
MAIN
SI000582
31 Aug 2006
8
0.72%
52.72
421.76
418.71
143330 Service Chamber, Type 30
4
228.72
210.47
7.98%
MAIN
SI000582
31 Aug 2006
4
7.98%
57.18
228.72
210.47
145710B Slack Adjuster, 10 Spline
4
174.12
136.52
21.59%
MAIN
SI000573
07 Aug 2006
2
21.59%
43.53
87.06
68.26
MAIN
SI000582
31 Aug 2006
2
21.59%
43.53
87.06
68.26
145728B Slack Adjuster, 28 Spline
6
229.68
179.86
21.69%
MAIN
SI000582
31 Aug 2006
6
21.69%
38.28
229.68
179.86
165151 Detroit 8.2 Waterpump Re-manf
3
603.75
672.00
-11.30%
MAIN
SI000582
31 Aug 2006
3
-11.30%
201.25
603.75
672.00
165159 Misc Waterpump Re-manf
1
175.00
120.00
31.43%
MAIN
SI000582
31 Aug 2006
1
31.43%
175.00
175.00
120.00
197151 Detroit 8.2 Engine Re-manf
1
15,750.00
14,750.00
6.35%
MAIN
SI000582
31 Aug 2006
1
6.35%
15,750.00
15,750.00
14,750.00
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%
MAIN
SI000617
31 Aug 2006
2
56.26%
22.70
45.40
19.86
117151-S2 Fuel Filter, Detroit 8.2
2
90.80
38.58
57.51%
MAIN
SI000617
31 Aug 2006
2
57.51%
45.40
90.80
38.58
142312 Brake Lining Set, COF 0.36
4
1,374.00
740.28
46.12%
MAIN
SI000617
31 Aug 2006
4
46.12%
343.50
1,374.00
740.28
143320 Service Chamber, Type 20
4
221.00
181.16
18.03%
MAIN
SI000617
31 Aug 2006
4
18.03%
55.25
221.00
181.16
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%
HAM
SI000581
31 Aug 2006
1
30.12%
249.45
249.45
174.32
114151-S2 Oil Filter, Detroit 8.2
10
227.00
90.83
59.99%
HAM
SI000581
31 Aug 2006
10
59.99%
22.70
227.00
90.83
114152-S2 Oil Filter, Perkins
8
236.00
119.00
49.58%
HAM
SI000581
31 Aug 2006
8
49.58%
29.50
236.00
119.00
122104 Exhaust Tubing, 4"
10
167.50
124.73
25.53%
HAM
SI000581
31 Aug 2006
10
25.53%
16.75
167.50
124.73
122105 Exhaust Tubing, 5"
6
141.30
101.92
27.87%
HAM
SI000581
31 Aug 2006
6
27.87%
23.55
141.30
101.92
Page 3 of 4
Printed on 03 Apr 2007 at 09:22 AM
TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Customer Sales Analysis
Margin
Cost Value
Sales Value
Unit Price
Qty
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
SALES TOTAL
MARGIN
QTY
COST TOTAL
ITEM CODE & DESCRIPTION
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001 (Cont.)
83
5,257.95
3,247.98
38.23%
122203 Exhaust Clamp, 3"
2
33.10
23.01
30.48%
HAM
SI000581
31 Aug 2006
2
30.48%
16.55
33.10
23.01
122204 Exhaust Clamp, 4"
2
37.10
25.30
31.81%
HAM
SI000581
31 Aug 2006
2
31.81%
18.55
37.10
25.30
142312 Brake Lining Set, COF 0.36
6
2,061.00
1,030.29
50.01%
HAM
SI000581
31 Aug 2006
6
50.01%
343.50
2,061.00
1,030.29
143320 Service Chamber, Type 20
8
442.00
339.77
23.13%
HAM
SI000581
31 Aug 2006
8
23.13%
55.25
442.00
339.77
143324 Service Chamber, Type 24
6
361.50
299.68
17.10%
HAM
SI000581
31 Aug 2006
6
17.10%
60.25
361.50
299.68
143330 Service Chamber, Type 30
10
653.50
500.94
23.35%
HAM
SI000581
31 Aug 2006
10
23.35%
65.35
653.50
500.94
145710B Slack Adjuster, 10 Spline
6
298.50
192.36
35.56%
HAM
SI000581
31 Aug 2006
6
35.56%
49.75
298.50
192.36
145728B Slack Adjuster, 28 Spline
8
350.00
225.83
35.48%
HAM
SI000581
31 Aug 2006
8
35.48%
43.75
350.00
225.83
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%
MAIN
SI000577
22 Aug 2006
2
46.06%
343.50
687.00
370.59
143320 Service Chamber, Type 20
2
110.50
88.97
19.48%
MAIN
SI000577
22 Aug 2006
2
19.48%
55.25
110.50
88.97
Total:
21.73%
42,260.63
53,996.05
580
Page 4 of 4
Printed on 03 Apr 2007 at 09:22 AM