TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Customer Sales Analysis
All control accounts
For selected related account ids, from first group to last group, from first account to last account, ordered by related account
Related accounts
R11520, R18001
For the period from 01 Aug 2006 to 31 Aug 2006, excluding ledger items, analysed by item group
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
Related Account Id: R11520 - Hutt Transport Services
28
5,802.92
3,466.95
40.26%
Item Group: I14 - Braking System
28
5,802.92
3,466.95
40.26%
142312 Brake Lining Set, COF 0.36
16
5,186.88
2,963.38
42.87%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
46.06%
1,852.96
3,435.00
10
MAIN
SI000576
18 Aug 2006
10
46.06%
343.50
3,435.00
1,852.96
Hutt Transport Supplies, P O Box 11-540, Lower Hutt, Wellington 5040
11540
36.62%
1,110.42
1,751.88
6
MAIN
SI000616
31 Aug 2006
6
36.62%
291.98
1,751.88
1,110.42
143320 Service Chamber, Type 20
6
298.34
270.13
9.46%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
19.48%
88.97
110.50
2
MAIN
SI000576
18 Aug 2006
2
19.48%
55.25
110.50
88.97
Hutt Transport Supplies, P O Box 11-540, Lower Hutt, Wellington 5040
11540
3.56%
181.16
187.84
4
MAIN
SI000616
31 Aug 2006
4
3.56%
46.96
187.84
181.16
143324 Service Chamber, Type 24
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
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%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
19.48%
105.24
130.70
2
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%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
31.41%
68.25
99.50
2
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%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
31.49%
59.95
87.50
2
MAIN
SI000576
18 Aug 2006
2
31.49%
43.75
87.50
59.95
Related Account Id: R18001 - Central Transport Holdings Ltd
24
4,046.24
2,527.34
37.54%
Item Group: I11 - Engine Servicing
4
136.20
58.44
57.09%
114151-S2 Oil Filter, Detroit 8.2
2
45.40
19.86
56.26%
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
56.26%
19.86
45.40
2
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%
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
57.51%
38.58
90.80
2
MAIN
SI000617
31 Aug 2006
2
57.51%
45.40
90.80
38.58
Item Group: I14 - Braking System
20
3,910.04
2,468.90
36.86%
141605 Brake Drum, 15", 3 Spoke
2
440.90
399.25
9.45%
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
11480
9.45%
399.25
440.90
2
Page 1 of 2
Printed on 03 Apr 2007 at 09:27 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
Related Account Id: R18001 - Central Transport Holdings Ltd (Cont.)
24
4,046.24
2,527.34
37.54%
Item Group: I14 - Braking System (Cont.)
20
3,910.04
2,468.90
36.86%
141605 Brake Drum, 15", 3 Spoke (Cont.)
2
440.90
399.25
9.45%
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301 (Cont.)
11480
9.45%
399.25
440.90
2
MAIN
SI000579
28 Aug 2006
2
9.45%
220.45
440.90
399.25
142312 Brake Lining Set, COF 0.36
9
2,988.45
1,666.07
44.25%
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
11480
40.14%
555.20
927.45
3
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
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
46.12%
740.28
1,374.00
4
MAIN
SI000617
31 Aug 2006
4
46.12%
343.50
1,374.00
740.28
Wanganui Transport Ltd, P O Box 900, Gonville, Wanganui 4543
11900
46.06%
370.59
687.00
2
MAIN
SI000577
22 Aug 2006
2
46.06%
343.50
687.00
370.59
143320 Service Chamber, Type 20
9
480.69
403.58
16.04%
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
11480
10.55%
133.45
149.19
3
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
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
18.03%
181.16
221.00
4
MAIN
SI000617
31 Aug 2006
4
18.03%
55.25
221.00
181.16
Wanganui Transport Ltd, P O Box 900, Gonville, Wanganui 4543
11900
19.48%
88.97
110.50
2
MAIN
SI000577
22 Aug 2006
2
19.48%
55.25
110.50
88.97
Total:
39.14%
5,994.29
9,849.16
52
Page 2 of 2
Printed on 03 Apr 2007 at 09:27 AM