TCSDebtMargin
Customer Margin Analysis Summary
ACME TRUCK SERVICING LTD
For selected company, for all locations, for all related account ids
Company code
DTT
For the period from 01 May 2007 to 31 May 2007, 15 selected trade customers, ranked by descending total revenue value
Rank
Margin%
Margin Value
Revenue Value
Margin%
Margin Value
Revenue Value
Customer
Margin Value
Revenue Value
Margin%
Percent
Rank by
------------------------- SALES ------------------------
----------------------- SERVICE -----------------------
------------------------- TOTAL ------------------------
12570 Nationwide Freighters Ltd
1
4,482.05
1,350.44
30.13%
42,981.70
2,437.31
5.67%
47,463.75
3,787.75
7.98%
45.68%
10773 Freightline NZ Ltd
2
1,562.11
570.81
36.54%
8,912.55
2,604.40
29.22%
10,474.66
3,175.21
30.31%
10.08%
R18001 Central Transport Holdings Ltd
3
4,267.25
1,941.85
45.51%
5,254.41
985.13
18.75%
9,521.66
2,926.98
30.74%
9.16%
11950 Waikato Transport Ltd
4
4,870.00
2,169.52
44.55%
4,870.00
2,169.52
44.55%
4.69%
R11520 Hutt Transport Services
5
4,486.55
2,012.55
44.86%
4,486.55
2,012.55
44.86%
4.32%
10215 Coastal Storage & Freight
6
1,426.61
640.00
44.86%
2,695.10
355.25
13.18%
4,121.71
995.25
24.15%
3.97%
11715 N Z Freight Services Ltd
7
4,025.49
1,223.37
30.39%
4,025.49
1,223.37
30.39%
3.87%
11870 Prestige Removals Ltd
8
2,805.45
862.35
30.74%
2,805.45
862.35
30.74%
2.70%
11890 Transport NZ Ltd
9
2,324.79
774.84
33.33%
2,324.79
774.84
33.33%
2.24%
15523 Smiths Transport Ltd
10
1,876.70
737.68
39.31%
1,876.70
737.68
39.31%
1.81%
10350 Davies Transport
11
1,609.60
706.82
43.91%
1,609.60
706.82
43.91%
1.55%
10120 Balmoral Transport Co
12
1,535.35
696.17
45.34%
1,535.35
696.17
45.34%
1.48%
10015 Auckland Storage & Freight Ltd
13
1,503.70
570.39
37.93%
1,503.70
570.39
37.93%
1.45%
11655 Mr T B Robinson
14
1,395.90
577.55
41.37%
1,395.90
577.55
41.37%
1.34%
10725 Frankton Freight
15
1,290.36
598.37
46.37%
1,290.36
598.37
46.37%
1.24%
Total:
39,461.91
15,432.71
39.11%
59,843.76
6,382.09
10.66%
99,305.67
21,814.80
21.97%
95.57%
Percentage of SALES and SERVICE to TOTAL:
39.74%
70.74%
60.26%
29.26%
100.00%
100.00%
Percentage of Overall Total:
89.55%
89.77%
100.00%
100.00%
95.57%
92.54%
Overall Total:
44,064.47
17,190.44
39.01%
59,843.76
6,382.09
10.66%
103,908.23
23,572.53
22.69%
100.00%
Percentage of SALES and SERVICE to TOTAL:
42.41%
72.93%
57.59%
27.07%
100.00%
100.00%
Page 1 of 1
Printed on 21 Jun 2007 at 11:51 AM
TCSDebtMargin
Customer Margin Analysis Details: Company DTT ACME TRUCK SERVICING LTD
ACME TRUCK SERVICING LTD
For selected company, for all locations, for all related account ids
Company code
DTT
For the period from 01 May 2007 to 31 May 2007, including account details
Rank
Margin%
Margin Value
Revenue Value
Margin%
Margin Value
Revenue Value
Customer
Margin Value
Revenue Value
Margin%
------------------------- SALES ------------------------
----------------------- SERVICE -----------------------
------------------------- TOTAL ------------------------
Summary
12570 Nationwide Freighters Ltd
1
4,482.05
1,350.44
30.13%
42,981.70
2,437.31
5.67%
47,463.75
3,787.75
7.98%
10773 Freightline NZ Ltd
2
1,562.11
570.81
36.54%
8,912.55
2,604.40
29.22%
10,474.66
3,175.21
30.31%
R18001 Central Transport Holdings Ltd
3
4,267.25
1,941.85
45.51%
5,254.41
985.13
18.75%
9,521.66
2,926.98
30.74%
11480 Highways Freight Services Ltd
1,792.25
759.01
42.35%
5,254.41
985.13
18.75%
7,046.66
1,744.14
24.75%
11650 Rangitikei Transport Co
1,237.50
591.70
47.81%
1,237.50
591.70
47.81%
11900 Wanganui Transport Ltd
1,237.50
591.14
47.77%
1,237.50
591.14
47.77%
11950 Waikato Transport Ltd
4
4,870.00
2,169.52
44.55%
4,870.00
2,169.52
44.55%
R11520 Hutt Transport Services
5
4,486.55
2,012.55
44.86%
4,486.55
2,012.55
44.86%
11520 Hutt Transport Services
2,107.50
1,076.15
51.06%
2,107.50
1,076.15
51.06%
11540 Hutt Transport Supplies
2,379.05
936.40
39.36%
2,379.05
936.40
39.36%
10215 Coastal Storage & Freight
6
1,426.61
640.00
44.86%
2,695.10
355.25
13.18%
4,121.71
995.25
24.15%
11715 N Z Freight Services Ltd
7
4,025.49
1,223.37
30.39%
4,025.49
1,223.37
30.39%
11870 Prestige Removals Ltd
8
2,805.45
862.35
30.74%
2,805.45
862.35
30.74%
11890 Transport NZ Ltd
9
2,324.79
774.84
33.33%
2,324.79
774.84
33.33%
15523 Smiths Transport Ltd
10
1,876.70
737.68
39.31%
1,876.70
737.68
39.31%
10350 Davies Transport
11
1,609.60
706.82
43.91%
1,609.60
706.82
43.91%
10120 Balmoral Transport Co
12
1,535.35
696.17
45.34%
1,535.35
696.17
45.34%
10015 Auckland Storage & Freight Ltd
13
1,503.70
570.39
37.93%
1,503.70
570.39
37.93%
11655 Mr T B Robinson
14
1,395.90
577.55
41.37%
1,395.90
577.55
41.37%
10725 Frankton Freight
15
1,290.36
598.37
46.37%
1,290.36
598.37
46.37%
Total:
39,461.91
15,432.71
39.11%
59,843.76
6,382.09
10.66%
99,305.67
21,814.80
21.97%
Percentage of SALES and SERVICE to TOTAL:
39.74%
70.74%
60.26%
29.26%
100.00%
100.00%
Page 1 of 1
Printed on 21 Jun 2007 at 11:51 AM