ACME TRUCK SERVICING LTD
Gross Margin Summary
TCSDocuSInvMargin
For all departments, for the period from 01 Aug 2006 to 31 Aug 2006, analysed by franchise, ordered by salesperson
Excluding inter-company sales, excluding inter-warehouse transfers, excluding promotional activities, excluding warranty activities
Percent
Gross Margin
Cost of Sales
Sales Value
Quantity
Description
Franchise
Salesperson: 101 - Garry Smith
3
96.48
51.16
45.32
46.97%
D
Detroit
35
6,381.53
4,318.36
2,063.17
32.33%
Z
All Makes
Total for Franchises:
38
6,478.01
4,369.52
2,108.49
32.55%
22
715.00
0.00
715.00
100.00%
009.10
Freight Charges
7
196.35
0.00
196.35
100.00%
021.10
Re-Stocking Fees
Total for Ledger Accounts:
29
911.35
0.00
911.35
100.00%
67
7,389.36
4,369.52
3,019.84
40.87%
Total for 101 - Garry Smith:
Salesperson: 102 - Chris Jones
31
17,148.28
15,832.24
1,316.04
7.67%
D
Detroit
36
1,228.50
832.68
395.82
32.22%
P
Perkins
411
27,059.48
20,374.86
6,684.62
24.70%
Z
All Makes
Total for Franchises:
478
45,436.26
37,039.78
8,396.48
18.48%
25
912.50
0.00
912.50
100.00%
009.10
Freight Charges
6
190.50
0.00
190.50
100.00%
021.10
Re-Stocking Fees
Total for Ledger Accounts:
31
1,103.00
0.00
1,103.00
100.00%
509
46,539.26
37,039.78
9,499.48
20.41%
Total for 102 - Chris Jones:
Salesperson: 201 - Terry Williams
10
227.00
90.83
136.17
59.99%
D
Detroit
8
236.00
119.00
117.00
49.58%
P
Perkins
65
4,794.95
3,038.15
1,756.80
36.64%
Z
All Makes
Total for Franchises:
83
5,257.95
3,247.98
2,009.97
38.23%
83
5,257.95
3,247.98
2,009.97
38.23%
Total for 201 - Terry Williams:
Total:
659
59,186.57
44,657.28
14,529.29
24.55%
Page 1 of 1
Printed on 07 Sep 2006 at 09:56 AM