TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Customer Sales Analysis
All control accounts
For all related account ids, from first group to last group, from first account to last account, ordered by related account
For the period from 01 Aug 2006 to 31 Aug 2006, excluding ledger items, analysed by item group
All department codes
Item Code & Description
Cost Total
Qty
Margin
Sales Total
Account Name
Account
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231
445
38,888.94
33,018.36
15.10%
Item Group: I10 - Electrical System
63
6,178.14
5,037.55
18.46%
Item Group: I11 - Engine Servicing
63
2,023.03
1,242.92
38.56%
Item Group: I12 - Exhaust System
254
3,954.37
3,216.20
18.67%
Item Group: I14 - Braking System
60
10,204.65
7,979.69
21.80%
Item Group: I16 - Engine Components
4
778.75
792.00
-1.70%
Item Group: I19 - Major Components
1
15,750.00
14,750.00
6.35%
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001
83
5,257.95
3,247.98
38.23%
Item Group: I10 - Electrical System
1
249.45
174.32
30.12%
Item Group: I11 - Engine Servicing
18
463.00
209.83
54.68%
Item Group: I12 - Exhaust System
20
379.00
274.96
27.45%
Item Group: I14 - Braking System
44
4,166.50
2,588.87
37.86%
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%
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
11520
43.69%
2,175.37
3,863.20
18
Hutt Transport Supplies, P O Box 11-540, Lower Hutt, Wellington 5040
11540
33.41%
1,291.58
1,939.72
10
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%
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
57.09%
58.44
136.20
4
Item Group: I14 - Braking System
20
3,910.04
2,468.90
36.86%
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
11480
28.31%
1,087.90
1,517.54
8
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
11650
42.23%
921.44
1,595.00
8
Wanganui Transport Ltd, P O Box 900, Gonville, Wanganui 4543
11900
42.37%
459.56
797.50
4
Total:
21.73%
42,260.63
53,996.05
580
Page 1 of 1
Printed on 03 Apr 2007 at 09:16 AM