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 franchise
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%
48.12%
184.60
355.84
29.65
12
Franchise: D - Detroit
114151-S2
Oil Filter, Detroit 8.2
47.61%
62.14
118.60
19.77
6
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
19.30
19.30
10.35
46.37%
MAIN
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.38%
122.46
237.24
39.54
6
Each
SI000583
11480 Highways Freight Services Ltd
09 Oct 2006
1
38.59
38.59
20.41
47.11%
MAIN
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
5
39.73
198.65
102.05
48.63%
MAIN
33.13%
2,183.88
3,265.99
142.00
23
Franchise: Z - All Makes
101692
Headlamp Insert, Outer, Q/H
8.66%
143.00
156.55
78.28
2
Each
SI000585
11890 Transport NZ Ltd
09 Oct 2006
1
79.41
79.41
71.50
9.96%
MAIN
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
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
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
39.29%
1,480.56
2,438.84
304.86
8
Each
SI000589
11480 Highways Freight Services Ltd
19 Oct 2006
4
309.15
1,236.60
740.28
40.14%
MAIN
SI000591
12570 Nationwide Freighters Ltd
26 Oct 2006
4
300.56
1,202.24
740.28
38.42%
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
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
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
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%
33.13%
2,183.88
3,265.99
142.00
23
Franchise: Z - All Makes (Cont.)
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
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 franchise
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%
50.76%
236.11
479.55
29.97
16
Franchise: D - Detroit
114151-S2
Oil Filter, Detroit 8.2
50.95%
93.24
190.10
21.12
9
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
5
19.86
99.30
51.80
47.83%
MAIN
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
50.64%
142.87
289.45
41.35
7
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
5
39.73
198.65
102.05
48.63%
MAIN
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
2
45.40
90.80
40.82
55.04%
MAIN
40.59%
127.74
215.00
35.83
6
Franchise: P - Perkins
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
38.39%
2,017.81
3,274.87
181.94
18
Franchise: Z - All Makes
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
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
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
42.53%
1,480.56
2,576.24
322.03
8
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
4
300.56
1,202.24
740.28
38.42%
MAIN
SI000590
10350 Davies Transport
23 Oct 2006
2
343.50
687.00
370.14
46.12%
MAIN
SI000592
11900 Wanganui Transport Ltd
30 Oct 2006
2
343.50
687.00
370.14
46.12%
MAIN
143320
Service Chamber, Type 20
6.31%
90.58
96.68
48.34
2
Each
SI000588
11890 Transport NZ Ltd
16 Oct 2006
2
48.34
96.68
90.58
6.31%
MAIN
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%
38.39%
2,017.81
3,274.87
181.94
18
Franchise: Z - All Makes (Cont.)
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
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
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
Page 2 of 2
Printed on 02 Nov 2006 at 11:12 AM