TCSSlpnSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Sales Analysis by Salesperson
For all salespersons, for all client managers, for the period from 01 Oct 2006 to 31 Oct 2006, analysed by invoice salesperson
For all warehouses, for all franchises, excluding sales to job accounts, excluding sales to ledger accounts
From first group to last group, from first account to last account, excluding ledger items, ordered by account number
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
Salesperson: 101 - Garry Smith
35
103.48
3,621.83
2,368.48
34.61%
11480 - Highways Freight Services Ltd
12
148.87
1,786.39
1,187.50
33.53%
101692
Headlamp Insert, Outer, Q/H
7.31%
71.50
77.14
77.14
1
Each
SI000587
11480 Highways Freight Services Ltd
09 Oct 2006
1
77.14
77.14
71.50
7.31%
MAIN
108150
Battery, 12 Volt 27 Plate
17.87%
195.30
237.79
237.79
1
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
237.79
237.79
195.30
17.87%
MAIN
114151-S2
Oil Filter, Detroit 8.2
46.37%
10.35
19.30
19.30
1
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
19.30
19.30
10.35
46.37%
MAIN
117151-S2
Fuel Filter, Detroit 8.2
47.11%
20.41
38.59
38.59
1
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
38.59
38.59
20.41
47.11%
MAIN
119151
Top Hose, Radiator
23.77%
24.95
32.73
32.73
1
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
32.73
32.73
24.95
23.77%
MAIN
142312
Brake Lining Set, COF 0.36
40.14%
740.28
1,236.60
309.15
4
Each
SI000589
11480 Highways Freight Services Ltd
19 Oct 2006
4
309.15
1,236.60
740.28
40.14%
MAIN
143320
Service Chamber, Type 20
8.93%
90.58
99.46
49.73
2
Each
SI000589
11480 Highways Freight Services Ltd
19 Oct 2006
2
49.73
99.46
90.58
8.93%
MAIN
145710B
Slack Adjuster, 10 Spline
23.78%
34.13
44.78
44.78
1
Each
SI000589
11480 Highways Freight Services Ltd
19 Oct 2006
1
44.78
44.78
34.13
23.78%
MAIN
12570 - Nationwide Freighters Ltd
22
79.82
1,756.03
1,109.48
36.82%
114151-S2
Oil Filter, Detroit 8.2
47.84%
51.79
99.30
19.86
5
Each
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
5
19.86
99.30
51.79
47.84%
MAIN
117151-S2
Fuel Filter, Detroit 8.2
48.63%
102.05
198.65
39.73
5
Each
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
5
39.73
198.65
102.05
48.63%
MAIN
122204
Exhaust Clamp, 4"
26.37%
47.80
64.92
16.23
4
Each
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
4
16.23
64.92
47.80
26.37%
MAIN
142312
Brake Lining Set, COF 0.36
38.42%
740.28
1,202.24
300.56
4
Each
Page 1 of 2
Printed on 02 Nov 2006 at 11:12 AM
TCSSlpnSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Sales Analysis by Salesperson
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
Salesperson: 101 - Garry Smith (Cont.)
35
103.48
3,621.83
2,368.48
34.61%
12570 - Nationwide Freighters Ltd (Cont.)
22
79.82
1,756.03
1,109.48
36.82%
142312
38.42%
740.28
1,202.24
300.56
4
Brake Lining Set, COF 0.36 (Cont.)
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
4
300.56
1,202.24
740.28
38.42%
MAIN
143330
Service Chamber, Type 30
6.21%
107.26
114.36
57.18
2
Each
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
2
57.18
114.36
107.26
6.21%
MAIN
145728B
Slack Adjuster, 28 Spline
21.24%
60.30
76.56
38.28
2
Each
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
2
38.28
76.56
60.30
21.24%
MAIN
11890 - Transport NZ Ltd
1
79.41
79.41
71.50
9.96%
101692
Headlamp Insert, Outer, Q/H
9.96%
71.50
79.41
79.41
1
Each
SI000585
11890 Transport NZ Ltd
09 Oct 2006
1
79.41
79.41
71.50
9.96%
MAIN
Page 2 of 2
Printed on 02 Nov 2006 at 11:12 AM
TCSSlpnSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Sales Analysis by Salesperson
For all salespersons, for all client managers, for the period from 01 Oct 2006 to 31 Oct 2006, analysed by invoice salesperson
For all warehouses, for all franchises, excluding sales to job accounts, excluding sales to ledger accounts
From first group to last group, from first account to last account, excluding ledger items, ordered by account number
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
Salesperson: 102 - Chris Jones
40
99.24
3,969.42
2,381.66
40.00%
10350 - Davies Transport
11
100.57
1,106.25
657.06
40.60%
101691
Headlamp Insert, Inner, Q/H
20.76%
75.40
95.15
95.15
1
Each
SI000586
10350 Davies Transport
09 Oct 2006
1
95.15
95.15
75.40
20.76%
MAIN
114152-S2
Oil Filter, Perkins
40.31%
70.44
118.00
29.50
4
Each
SI000590
10350 Davies Transport
23 Oct 2006
4
29.50
118.00
70.44
40.31%
MAIN
117152-S2
Fuel Filter, Perkins
40.93%
57.30
97.00
48.50
2
Each
SI000590
10350 Davies Transport
23 Oct 2006
2
48.50
97.00
57.30
40.93%
MAIN
142312
Brake Lining Set, COF 0.36
46.12%
370.14
687.00
343.50
2
Each
SI000590
10350 Davies Transport
23 Oct 2006
2
343.50
687.00
370.14
46.12%
MAIN
143330
Service Chamber, Type 30
17.93%
53.63
65.35
65.35
1
Each
SI000590
10350 Davies Transport
23 Oct 2006
1
65.35
65.35
53.63
17.93%
MAIN
145728B
Slack Adjuster, 28 Spline
31.09%
30.15
43.75
43.75
1
Each
SI000590
10350 Davies Transport
23 Oct 2006
1
43.75
43.75
30.15
31.09%
MAIN
11890 - Transport NZ Ltd
20
85.74
1,714.82
1,076.90
37.20%
114151-S2
Oil Filter, Detroit 8.2
47.83%
51.80
99.30
19.86
5
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
5
19.86
99.30
51.80
47.83%
MAIN
117151-S2
Fuel Filter, Detroit 8.2
48.63%
102.05
198.65
39.73
5
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
5
39.73
198.65
102.05
48.63%
MAIN
122104
Exhaust Tubing, 4"
18.28%
11.98
14.66
14.66
1
Foot
SI000584
11890 Transport NZ Ltd
09 Oct 2006
1
14.66
14.66
11.98
18.28%
MAIN
122204
Exhaust Clamp, 4"
26.37%
11.95
16.23
16.23
1
Each
SI000584
11890 Transport NZ Ltd
09 Oct 2006
1
16.23
16.23
11.95
26.37%
MAIN
142312
Brake Lining Set, COF 0.36
38.42%
740.28
1,202.24
300.56
4
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
4
300.56
1,202.24
740.28
38.42%
MAIN
143320
Service Chamber, Type 20
6.31%
90.58
96.68
48.34
2
Each
Page 1 of 2
Printed on 02 Nov 2006 at 11:12 AM
TCSSlpnSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Sales Analysis by Salesperson
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
Salesperson: 102 - Chris Jones (Cont.)
40
99.24
3,969.42
2,381.66
40.00%
11890 - Transport NZ Ltd (Cont.)
20
85.74
1,714.82
1,076.90
37.20%
143320
6.31%
90.58
96.68
48.34
2
Service Chamber, Type 20 (Cont.)
SI000588
11890 Transport NZ Ltd
16 Oct 2006
2
48.34
96.68
90.58
6.31%
MAIN
145710B
Slack Adjuster, 10 Spline
21.59%
68.26
87.06
43.53
2
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
2
43.53
87.06
68.26
21.59%
MAIN
11900 - Wanganui Transport Ltd
9
127.59
1,148.35
647.70
43.60%
108150
Battery, 12 Volt 27 Plate
30.19%
195.30
279.75
279.75
1
Each
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
1
279.75
279.75
195.30
30.19%
MAIN
114151-S2
Oil Filter, Detroit 8.2
54.36%
41.44
90.80
22.70
4
Each
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
4
22.70
90.80
41.44
54.36%
MAIN
117151-S2
Fuel Filter, Detroit 8.2
55.04%
40.82
90.80
45.40
2
Each
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
2
45.40
90.80
40.82
55.04%
MAIN
142312
Brake Lining Set, COF 0.36
46.12%
370.14
687.00
343.50
2
Each
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
2
343.50
687.00
370.14
46.12%
MAIN
Page 2 of 2
Printed on 02 Nov 2006 at 11:12 AM