TCSDebtItemSales
ACME TRUCK SERVICING LTD
Detailed Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
For all related account ids, from first group to last group, from first account to last account, ordered by related account
All control accounts
For all warehouses
For all franchises
From first group to last group, from first account to last account, analysed by item group, excluding job issues
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Ref
Date
Invoice
Warehouse
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
Item Group: I10 - Electrical System
98.07
63
6,178.14
5,037.55
18.46%
100805 Lamp, L/Range Driving 12V 55W
71.27
5
356.35
325.66
8.61%
MAIN
SI000582
31 Aug 2006
5
356.35
325.66
8.61%
71.27
100810 Lamp, L/Range Driving 12V 100W
76.08
3
228.24
208.80
8.52%
MAIN
SI000582
31 Aug 2006
3
228.24
208.80
8.52%
76.08
103100 Lamp, Cab Marker, Clear
10.89
11
119.79
107.80
10.01%
MAIN
SI000582
31 Aug 2006
11
119.79
107.80
10.01%
10.89
103104 Lamp, Cab Marker, Amber
10.89
7
76.23
68.58
10.04%
MAIN
SI000582
31 Aug 2006
7
76.23
68.58
10.04%
10.89
103105 Lamp, Cab Marker, Red
10.89
12
130.68
117.60
10.01%
MAIN
SI000582
31 Aug 2006
12
130.68
117.60
10.01%
10.89
103207 Bulb 24V, Licence Plate
13.78
5
68.90
58.11
15.66%
MAIN
SI000582
31 Aug 2006
5
68.90
58.11
15.66%
13.78
108120 Battery, 12 Volt 21 Plate
218.27
7
1,527.89
1,220.10
20.14%
MAIN
SI000582
31 Aug 2006
7
1,527.89
1,220.10
20.14%
218.27
108150 Battery, 12 Volt 27 Plate
244.78
5
1,223.90
976.50
20.21%
MAIN
SI000582
31 Aug 2006
5
1,223.90
976.50
20.21%
244.78
108200 Battery, 12 Volt 37 Plate
305.77
8
2,446.16
1,954.40
20.10%
MAIN
SI000582
31 Aug 2006
8
2,446.16
1,954.40
20.10%
305.77
Item Group: I11 - Engine Servicing
32.11
63
2,023.03
1,242.92
38.56%
114151-S2 Oil Filter, Detroit 8.2
19.86
14
278.04
144.95
47.87%
MAIN
SI000582
31 Aug 2006
14
278.04
144.95
47.87%
19.86
114152-S2 Oil Filter, Perkins
25.81
18
464.58
316.96
31.77%
MAIN
SI000582
31 Aug 2006
18
464.58
316.96
31.77%
25.81
117151-S2 Fuel Filter, Detroit 8.2
39.73
13
516.49
265.29
48.64%
MAIN
SI000582
31 Aug 2006
13
516.49
265.29
48.64%
39.73
117152-S2 Fuel Filter, Perkins
42.44
18
763.92
515.72
32.49%
MAIN
SI000582
31 Aug 2006
18
763.92
515.72
32.49%
42.44
Item Group: I12 - Exhaust System
15.57
254
3,954.37
3,216.20
18.67%
122103 Exhaust Tubing, 3"
12.91
84
1,084.44
877.25
19.11%
MAIN
SI000582
31 Aug 2006
84
1,084.44
877.25
19.11%
12.91
122104 Exhaust Tubing, 4"
14.66
65
952.90
810.71
14.92%
MAIN
SI000582
31 Aug 2006
65
952.90
810.71
14.92%
14.66
122105 Exhaust Tubing, 5"
20.61
51
1,051.11
864.89
17.72%
MAIN
SI000582
31 Aug 2006
51
1,051.11
864.89
17.72%
20.61
Page 1 of 5
Printed on 01 May 2007 at 12:42 PM
TCSDebtItemSales
ACME TRUCK SERVICING LTD
Detailed Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Ref
Date
Invoice
Warehouse
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.)
Item Group: I12 - Exhaust System (Cont.)
15.57
254
3,954.37
3,216.20
18.67%
122203 Exhaust Clamp, 3"
14.48
18
260.64
197.10
24.38%
MAIN
SI000582
31 Aug 2006
18
260.64
197.10
24.38%
14.48
122204 Exhaust Clamp, 4"
16.23
24
389.52
286.80
26.37%
MAIN
SI000582
31 Aug 2006
24
389.52
286.80
26.37%
16.23
122205 Exhaust Clamp, 5"
17.98
12
215.76
179.45
16.83%
MAIN
SI000582
31 Aug 2006
12
215.76
179.45
16.83%
17.98
Item Group: I14 - Braking System
170.08
60
10,204.65
7,979.69
21.80%
141605 Brake Drum, 15", 3 Spoke
226.93
7
1,588.51
1,397.39
12.03%
MAIN
SI000582
31 Aug 2006
7
1,588.51
1,397.39
12.03%
226.93
141607 Brake Drum, 16", 5 Spoke
247.23
14
3,461.22
3,051.99
11.82%
MAIN
SI000573
07 Aug 2006
2
494.46
436.00
11.82%
247.23
MAIN
SI000582
31 Aug 2006
12
2,966.76
2,615.99
11.82%
247.23
142312 Brake Lining Set, COF 0.36
300.56
13
3,907.28
2,406.80
38.40%
MAIN
SI000573
07 Aug 2006
4
1,202.24
741.18
38.35%
300.56
MAIN
SI000582
31 Aug 2006
9
2,705.04
1,665.62
38.43%
300.56
143320 Service Chamber, Type 20
48.34
4
193.36
177.95
7.97%
MAIN
SI000573
07 Aug 2006
2
96.68
88.97
7.97%
48.34
MAIN
SI000582
31 Aug 2006
2
96.68
88.98
7.96%
48.34
143324 Service Chamber, Type 24
52.72
8
421.76
418.71
0.72%
MAIN
SI000582
31 Aug 2006
8
421.76
418.71
0.72%
52.72
143330 Service Chamber, Type 30
57.18
4
228.72
210.47
7.98%
MAIN
SI000582
31 Aug 2006
4
228.72
210.47
7.98%
57.18
145710B Slack Adjuster, 10 Spline
43.53
4
174.12
136.52
21.59%
MAIN
SI000573
07 Aug 2006
2
87.06
68.26
21.59%
43.53
MAIN
SI000582
31 Aug 2006
2
87.06
68.26
21.59%
43.53
145728B Slack Adjuster, 28 Spline
38.28
6
229.68
179.86
21.69%
MAIN
SI000582
31 Aug 2006
6
229.68
179.86
21.69%
38.28
Item Group: I16 - Engine Components
194.69
4
778.75
792.00
-1.70%
165151 Detroit 8.2 Waterpump Re-manf
201.25
3
603.75
672.00
-11.30%
MAIN
SI000582
31 Aug 2006
3
603.75
672.00
-11.30%
201.25
165159 Misc Waterpump Re-manf
175.00
1
175.00
120.00
31.43%
MAIN
SI000582
31 Aug 2006
1
175.00
120.00
31.43%
175.00
Item Group: I19 - Major Components
15,750.00
1
15,750.00
14,750.00
6.35%
197151 Detroit 8.2 Engine Re-manf
15,750.00
1
15,750.00
14,750.00
6.35%
MAIN
SI000582
31 Aug 2006
1
15,750.00
14,750.00
6.35%
15,750.00
38.23%
3,247.98
5,257.95
83
63.35
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001
Item Group: I10 - Electrical System
249.45
1
249.45
174.32
30.12%
108120 Battery, 12 Volt 21 Plate
249.45
1
249.45
174.32
30.12%
Page 2 of 5
Printed on 01 May 2007 at 12:42 PM
TCSDebtItemSales
ACME TRUCK SERVICING LTD
Detailed Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Ref
Date
Invoice
Warehouse
ITEM CODE & DESCRIPTION
COST TOTAL
QTY
MARGIN
AVERAGE PRICE
SALES TOTAL
ACCOUNT NAME
ACCOUNT
38.23%
3,247.98
5,257.95
83
63.35
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001 (Cont.)
Item Group: I10 - Electrical System (Cont.)
249.45
1
249.45
174.32
30.12%
108120 Battery, 12 Volt 21 Plate
249.45
1
249.45
174.32
30.12%
HAM
SI000581
31 Aug 2006
1
249.45
174.32
30.12%
249.45
Item Group: I11 - Engine Servicing
25.72
18
463.00
209.83
54.68%
114151-S2 Oil Filter, Detroit 8.2
22.70
10
227.00
90.83
59.99%
HAM
SI000581
31 Aug 2006
10
227.00
90.83
59.99%
22.70
114152-S2 Oil Filter, Perkins
29.50
8
236.00
119.00
49.58%
HAM
SI000581
31 Aug 2006
8
236.00
119.00
49.58%
29.50
Item Group: I12 - Exhaust System
18.95
20
379.00
274.96
27.45%
122104 Exhaust Tubing, 4"
16.75
10
167.50
124.73
25.53%
HAM
SI000581
31 Aug 2006
10
167.50
124.73
25.53%
16.75
122105 Exhaust Tubing, 5"
23.55
6
141.30
101.92
27.87%
HAM
SI000581
31 Aug 2006
6
141.30
101.92
27.87%
23.55
122203 Exhaust Clamp, 3"
16.55
2
33.10
23.01
30.48%
HAM
SI000581
31 Aug 2006
2
33.10
23.01
30.48%
16.55
122204 Exhaust Clamp, 4"
18.55
2
37.10
25.30
31.81%
HAM
SI000581
31 Aug 2006
2
37.10
25.30
31.81%
18.55
Item Group: I14 - Braking System
94.69
44
4,166.50
2,588.87
37.86%
142312 Brake Lining Set, COF 0.36
343.50
6
2,061.00
1,030.29
50.01%
HAM
SI000581
31 Aug 2006
6
2,061.00
1,030.29
50.01%
343.50
143320 Service Chamber, Type 20
55.25
8
442.00
339.77
23.13%
HAM
SI000581
31 Aug 2006
8
442.00
339.77
23.13%
55.25
143324 Service Chamber, Type 24
60.25
6
361.50
299.68
17.10%
HAM
SI000581
31 Aug 2006
6
361.50
299.68
17.10%
60.25
143330 Service Chamber, Type 30
65.35
10
653.50
500.94
23.35%
HAM
SI000581
31 Aug 2006
10
653.50
500.94
23.35%
65.35
145710B Slack Adjuster, 10 Spline
49.75
6
298.50
192.36
35.56%
HAM
SI000581
31 Aug 2006
6
298.50
192.36
35.56%
49.75
145728B Slack Adjuster, 28 Spline
43.75
8
350.00
225.83
35.48%
HAM
SI000581
31 Aug 2006
8
350.00
225.83
35.48%
43.75
Related Account Id: R11520 - Hutt Transport Services
207.25
28
5,802.92
3,466.95
40.26%
Item Group: I14 - Braking System
207.25
28
5,802.92
3,466.95
40.26%
142312 Brake Lining Set, COF 0.36
324.18
16
5,186.88
2,963.38
42.87%
11520
Hutt Transport Services, P O Box 30-520,
343.50
10
3,435.00
1,852.96
46.06%
142312 Brake Lining Set, COF 0.36
MAIN
SI000576
18 Aug 2006
10
3,435.00
1,852.96
46.06%
343.50
11540
Hutt Transport Supplies, P O Box 11-540,
291.98
6
1,751.88
1,110.42
36.62%
142312 Brake Lining Set, COF 0.36
MAIN
SI000616
31 Aug 2006
6
1,751.88
1,110.42
36.62%
H310806
291.98
143320 Service Chamber, Type 20
49.72
6
298.34
270.13
9.46%
11520
Hutt Transport Services, P O Box 30-520,
55.25
2
110.50
88.97
19.48%
143320 Service Chamber, Type 20
Page 3 of 5
Printed on 01 May 2007 at 12:42 PM
TCSDebtItemSales
ACME TRUCK SERVICING LTD
Detailed Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Ref
Date
Invoice
Warehouse
ITEM CODE & DESCRIPTION
COST TOTAL
QTY
MARGIN
AVERAGE PRICE
SALES TOTAL
ACCOUNT NAME
ACCOUNT
Related Account Id: R11520 - Hutt Transport Services (Cont.)
207.25
28
5,802.92
3,466.95
40.26%
Item Group: I14 - Braking System (Cont.)
207.25
28
5,802.92
3,466.95
40.26%
143320 Service Chamber, Type 20
49.72
6
298.34
270.13
9.46%
11520
Hutt Transport Services, P O Box 30-520,
55.25
2
110.50
88.97
19.48%
143320 Service Chamber, Type 20
MAIN
SI000576
18 Aug 2006
2
110.50
88.97
19.48%
55.25
11540
Hutt Transport Supplies, P O Box 11-540,
46.96
4
187.84
181.16
3.56%
143320 Service Chamber, Type 20
MAIN
SI000616
31 Aug 2006
4
187.84
181.16
3.56%
H310806
46.96
143324 Service Chamber, Type 24
11520
Hutt Transport Services, P O Box 30-520,
143324 Service Chamber, Type 24
MAIN
SI000576
18 Aug 2006
2
120.50
104.68
13.13%
60.25
MAIN
SR000035
31 Aug 2006
-2
-120.50
-104.68
13.13%
-60.25
143330 Service Chamber, Type 30
65.35
2
130.70
105.24
19.48%
11520
Hutt Transport Services, P O Box 30-520,
65.35
2
130.70
105.24
19.48%
143330 Service Chamber, Type 30
MAIN
SI000576
18 Aug 2006
2
130.70
105.24
19.48%
65.35
145710B Slack Adjuster, 10 Spline
49.75
2
99.50
68.25
31.41%
11520
Hutt Transport Services, P O Box 30-520,
49.75
2
99.50
68.25
31.41%
145710B Slack Adjuster, 10 Spline
MAIN
SI000576
18 Aug 2006
2
99.50
68.25
31.41%
49.75
145728B Slack Adjuster, 28 Spline
43.75
2
87.50
59.95
31.49%
11520
Hutt Transport Services, P O Box 30-520,
43.75
2
87.50
59.95
31.49%
145728B Slack Adjuster, 28 Spline
MAIN
SI000576
18 Aug 2006
2
87.50
59.95
31.49%
43.75
Related Account Id: R18001 - Central Transport Holdings Ltd
168.59
24
4,046.24
2,527.34
37.54%
Item Group: I11 - Engine Servicing
34.05
4
136.20
58.44
57.09%
114151-S2 Oil Filter, Detroit 8.2
22.70
2
45.40
19.86
56.26%
11650
Rangitikei Transport Co, P O Box 165, Bu
22.70
2
45.40
19.86
56.26%
114151-S2 Oil Filter, Detroit 8.2
MAIN
SI000617
31 Aug 2006
2
45.40
19.86
56.26%
B310806
22.70
117151-S2 Fuel Filter, Detroit 8.2
45.40
2
90.80
38.58
57.51%
11650
Rangitikei Transport Co, P O Box 165, Bu
45.40
2
90.80
38.58
57.51%
117151-S2 Fuel Filter, Detroit 8.2
MAIN
SI000617
31 Aug 2006
2
90.80
38.58
57.51%
B310806
45.40
Item Group: I14 - Braking System
195.50
20
3,910.04
2,468.90
36.86%
141605 Brake Drum, 15", 3 Spoke
220.45
2
440.90
399.25
9.45%
11480
Highways Freight Services Ltd, P O Box 1
220.45
2
440.90
399.25
9.45%
141605 Brake Drum, 15", 3 Spoke
MAIN
SI000579
28 Aug 2006
2
440.90
399.25
9.45%
220.45
142312 Brake Lining Set, COF 0.36
332.05
9
2,988.45
1,666.07
44.25%
11480
Highways Freight Services Ltd, P O Box 1
309.15
3
927.45
555.20
40.14%
142312 Brake Lining Set, COF 0.36
MAIN
SI000579
28 Aug 2006
4
1,236.60
740.27
40.14%
309.15
MAIN
SR000033
31 Aug 2006
-1
-309.15
-185.07
40.14%
-309.15
11650
Rangitikei Transport Co, P O Box 165, Bu
343.50
4
1,374.00
740.28
46.12%
142312 Brake Lining Set, COF 0.36
MAIN
SI000617
31 Aug 2006
4
1,374.00
740.28
46.12%
B310806
343.50
11900
Wanganui Transport Ltd, P O Box 900, G
343.50
2
687.00
370.59
46.06%
142312 Brake Lining Set, COF 0.36
MAIN
SI000577
22 Aug 2006
2
687.00
370.59
46.06%
343.50
Page 4 of 5
Printed on 01 May 2007 at 12:42 PM
TCSDebtItemSales
ACME TRUCK SERVICING LTD
Detailed Customer Item Sales Report for the period from 01 Aug 2006 to 31 Aug 2006
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Ref
Date
Invoice
Warehouse
ITEM CODE & DESCRIPTION
COST TOTAL
QTY
MARGIN
AVERAGE PRICE
SALES TOTAL
ACCOUNT NAME
ACCOUNT
Related Account Id: R18001 - Central Transport Holdings Ltd (Cont.)
168.59
24
4,046.24
2,527.34
37.54%
Item Group: I14 - Braking System (Cont.)
195.50
20
3,910.04
2,468.90
36.86%
143320 Service Chamber, Type 20
53.41
9
480.69
403.58
16.04%
11480
Highways Freight Services Ltd, P O Box 1
49.73
3
149.19
133.45
10.55%
143320 Service Chamber, Type 20
MAIN
SI000579
28 Aug 2006
4
198.92
177.94
10.55%
49.73
MAIN
SR000033
31 Aug 2006
-1
-49.73
-44.49
10.54%
-49.73
11650
Rangitikei Transport Co, P O Box 165, Bu
55.25
4
221.00
181.16
18.03%
143320 Service Chamber, Type 20
MAIN
SI000617
31 Aug 2006
4
221.00
181.16
18.03%
B310806
55.25
11900
Wanganui Transport Ltd, P O Box 900, G
55.25
2
110.50
88.97
19.48%
143320 Service Chamber, Type 20
MAIN
SI000577
22 Aug 2006
2
110.50
88.97
19.48%
55.25
Total:
93.10
580
53,996.05
42,260.63
21.73%
Page 5 of 5
Printed on 01 May 2007 at 12:42 PM