ACME TRUCK SERVICING LTD
Gross Margin Exceptions
TCSDocuSInvMargin
For all departments, for the period from 01 Aug 2006 to 31 Aug 2006, margins less than 20.00% or greater than 50.00%, ordered by salesperson
Excluding inter-company sales, excluding inter-warehouse transfers, excluding promotional activities, excluding warranty activities
Quantity
Sales Value
Cost of Sales
Gross Margin
Percent
Processed By
Account Number and Name
Invoice Date
Invoice
Salesperson: 101 - Garry Smith
SI000572
37.64%
251.47
416.56
668.03
GCARSON
70520 Hino SS330 Reg: SZ1329
04 Aug 2006
143320 Service Chamber, Type 20
1
49.73
44.49
5.24
10.54%
SI000573
29.04%
546.03
1,334.41
1,880.44
GCARSON
12570 Nationwide Freighters Ltd
07 Aug 2006
141607 Brake Drum, 16", 5 Spoke
2
494.46
436.00
58.46
11.82%
143320 Service Chamber, Type 20
2
96.68
88.97
7.71
7.97%
SI000575
32.81%
498.10
1,019.92
1,518.02
GCARSON
70525 ERF 66CU380E Reg: WK7025
08 Aug 2006
143330 Service Chamber, Type 30
4
228.72
210.48
18.24
7.97%
SI000577
42.37%
337.94
459.56
797.50
GCARSON
11900 Wanganui Transport Ltd
22 Aug 2006
143320 Service Chamber, Type 20
2
110.50
88.97
21.53
19.48%
SI000579
29.79%
558.95
1,317.47
1,876.42
GCARSON
11480 Highways Freight Services Ltd
28 Aug 2006
141605 Brake Drum, 15", 3 Spoke
2
440.90
399.25
41.65
9.45%
143320 Service Chamber, Type 20
4
198.92
177.94
20.98
10.55%
SR000033
36.04%
)
(129.33
)
(229.55
)
(358.88
GCARSON
11480 Highways Freight Services Ltd
31 Aug 2006
143320 Service Chamber, Type 20
(1
)
(49.73
(44.49
(5.24
10.54%
)
)
)
Overall Total for 101 - Garry Smith:
38
6,478.01
4,369.52
2,108.49
32.55%
Exceptions Total for 101 - Garry Smith:
16
1,570.18
1,401.61
168.57
10.74%
Salesperson: 102 - Chris Jones
SI000574
32.89%
247.95
505.81
753.76
GCARSON
70524 Kenworth W124 Reg: SP7725
08 Aug 2006
143330 Service Chamber, Type 30
2
114.36
105.24
9.12
7.97%
SI000576
42.77%
1,703.64
2,280.06
3,983.70
GCARSON
11520 Hutt Transport Services
18 Aug 2006
143320 Service Chamber, Type 20
2
110.50
88.97
21.53
19.48%
143324 Service Chamber, Type 24
2
120.50
104.68
15.82
13.13%
143330 Service Chamber, Type 30
2
130.70
105.24
25.46
19.48%
SI000578
30.34%
551.16
1,265.24
1,816.40
GCARSON
70784 Foden S106T Reg: NP5589
24 Aug 2006
141607 Brake Drum, 16", 5 Spoke
2
480.34
436.00
44.34
9.23%
143320 Service Chamber, Type 20
2
99.46
88.97
10.49
10.55%
SI000580
30.37%
569.18
1,304.72
1,873.90
GCARSON
70793 Ford N1524 Reg: SF9510
30 Aug 2006
Page 1 of 2
Printed on 07 Sep 2006 at 09:25 AM
ACME TRUCK SERVICING LTD
Gross Margin Exceptions
TCSDocuSInvMargin
Quantity
Sales Value
Cost of Sales
Gross Margin
Percent
Processed By
Account Number and Name
Invoice Date
Invoice
Salesperson: 102 - Chris Jones (Cont.)
SI000580
30.37%
569.18
1,304.72
1,873.90
GCARSON
70793 Ford N1524 Reg: SF9510
30 Aug 2006
141605 Brake Drum, 15", 3 Spoke
2
440.90
399.25
41.65
9.45%
143330 Service Chamber, Type 30
2
117.64
105.24
12.40
10.54%
SI000582
56.06%
20,746.54
16,261.96
37,008.50
GCARSON
12570 Nationwide Freighters Ltd
31 Aug 2006
100805 Lamp, L/Range Driving 12V 55W
5
356.35
325.66
30.69
8.61%
100810 Lamp, L/Range Driving 12V 100W
3
228.24
208.80
19.44
8.52%
103100 Lamp, Cab Marker, Clear
11
119.79
107.80
11.99
10.01%
103104 Lamp, Cab Marker, Amber
7
76.23
68.58
7.65
10.04%
103105 Lamp, Cab Marker, Red
12
130.68
117.60
13.08
10.01%
103207 Bulb 24V, Licence Plate
5
68.90
58.11
10.79
15.66%
122103 Exhaust Tubing, 3"
84
1,084.44
877.25
207.19
19.11%
122104 Exhaust Tubing, 4"
65
952.90
810.71
142.19
14.92%
122105 Exhaust Tubing, 5"
51
1,051.11
864.89
186.22
17.72%
122205 Exhaust Clamp, 5"
12
215.76
179.45
36.31
16.83%
141605 Brake Drum, 15", 3 Spoke
7
1,588.51
1,397.39
191.12
12.03%
141607 Brake Drum, 16", 5 Spoke
12
2,966.76
2,615.99
350.77
11.82%
143320 Service Chamber, Type 20
2
96.68
88.98
7.70
7.96%
143324 Service Chamber, Type 24
8
421.76
418.71
3.05
0.72%
143330 Service Chamber, Type 30
4
228.72
210.47
18.25
7.98%
165151 Detroit 8.2 Waterpump Re-manf
3
603.75
672.00
(68.25
(11.30%
)
)
197151 Detroit 8.2 Engine Re-manf
1
15,750.00
14,750.00
1,000.00
6.35%
)
Overall Total for 102 - Chris Jones:
478
45,436.26
37,039.78
8,396.48
18.48%
Exceptions Total for 102 - Chris Jones:
308
27,554.98
25,205.98
2,349.00
8.52%
Salesperson: 201 - Terry Williams
SI000581
38.23%
2,009.97
3,247.98
5,257.95
GCARSON
11950 Waikato Transport Ltd
31 Aug 2006
114151-S2 Oil Filter, Detroit 8.2
10
227.00
90.83
136.17
59.99%
142312 Brake Lining Set, COF 0.36
6
2,061.00
1,030.29
1,030.71
50.01%
143324 Service Chamber, Type 24
6
361.50
299.68
61.82
17.10%
Overall Total for 201 - Terry Williams:
83
5,257.95
3,247.98
2,009.97
38.23%
Exceptions Total for 201 - Terry Williams:
22
2,649.50
1,420.80
1,228.70
46.37%
Overall Total:
599
57,172.22
44,657.28
12,514.94
21.89%
Exceptions Total:
346
31,774.66
28,028.39
3,746.27
11.79%
Page 2 of 2
Printed on 07 Sep 2006 at 09:25 AM