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 department
For the period from 01 Aug 2006 to 31 Aug 2006, excluding ledger items, analysed by item franchise
All department codes
Item Code & Description
Cost Total
Qty
Margin
Sales Total
Account Name
Account
Department: 10 - Parts Department
497
48,738.10
39,012.65
19.95%
11480
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
8
1,517.54
1,087.90
28.31%
Franchise: Z - All Makes
8
1,517.54
1,087.90
28.31%
11520
Hutt Transport Services, P O Box 30-520, Lower Hutt, Wellington 5040
18
3,863.20
2,175.37
43.69%
Franchise: Z - All Makes
18
3,863.20
2,175.37
43.69%
11540
Hutt Transport Supplies, P O Box 11-540, Lower Hutt, Wellington 5040
10
1,939.72
1,291.58
33.41%
Franchise: Z - All Makes
10
1,939.72
1,291.58
33.41%
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231
445
38,888.94
33,018.36
15.10%
Franchise: D - Detroit
31
17,148.28
15,832.24
7.67%
Franchise: P - Perkins
36
1,228.50
832.68
32.22%
Franchise: Z - All Makes
378
20,512.16
16,353.44
20.27%
11650
Rangitikei Transport Co, P O Box 165, Bulls, Manawatu 5452
12
1,731.20
979.88
43.40%
Franchise: D - Detroit
4
136.20
58.44
57.09%
Franchise: Z - All Makes
8
1,595.00
921.44
42.23%
11900
Wanganui Transport Ltd, P O Box 900, Gonville, Wanganui 4543
4
797.50
459.56
42.37%
Franchise: Z - All Makes
4
797.50
459.56
42.37%
Department: 20 - Hamilton Parts Depot
83
5,257.95
3,247.98
38.23%
11950
Waikato Transport Ltd, P O Box 1195, Chartwell, Waikato 2001
83
5,257.95
3,247.98
38.23%
Franchise: D - Detroit
10
227.00
90.83
59.99%
Franchise: P - Perkins
8
236.00
119.00
49.58%
Franchise: Z - All Makes
65
4,794.95
3,038.15
36.64%
Total:
21.73%
42,260.63
53,996.05
580
Page 1 of 1
Printed on 03 Apr 2007 at 09:19 AM
TCSDebtSalesAnalysis
ACME TRUCK SERVICING LTD
Customer Sales Analysis Summary
All control accounts
For no related account ids, from first group to last group, from first account to last account
For the period from 01 Aug 2006 to 31 Aug 2006, excluding ledger items, summarised by item number
All department codes
ACCOUNT
ACCOUNT NAME
SALES TOTAL
MARGIN
QTY
COST TOTAL
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
8
1,777.34
1,394.42
21.54%
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
26
550.44
255.64
53.56%
114152-S2
Oil Filter, Perkins
26
700.58
435.96
37.77%
117151-S2
Fuel Filter, Detroit 8.2
15
607.29
303.87
49.96%
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"
75
1,120.40
935.44
16.51%
122105
Exhaust Tubing, 5"
57
1,192.41
966.81
18.92%
122203
Exhaust Clamp, 3"
20
293.74
220.11
25.07%
122204
Exhaust Clamp, 4"
26
426.62
312.10
26.84%
122205
Exhaust Clamp, 5"
12
215.76
179.45
16.83%
141605
Brake Drum, 15", 3 Spoke
9
2,029.41
1,796.64
11.47%
141607
Brake Drum, 16", 5 Spoke
14
3,461.22
3,051.99
11.82%
142312
Brake Lining Set, COF 0.36
44
14,143.61
8,066.54
42.97%
143320
Service Chamber, Type 20
27
1,414.39
1,191.43
15.76%
143324
Service Chamber, Type 24
14
783.26
718.39
8.28%
143330
Service Chamber, Type 30
16
1,012.92
816.65
19.38%
145710B
Slack Adjuster, 10 Spline
12
572.12
397.13
30.59%
145728B
Slack Adjuster, 28 Spline
16
667.18
465.64
30.21%
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%
Total:
21.73%
42,260.63
53,996.05
580
Page 1 of 1
Printed on 03 Apr 2007 at 09:19 AM