TCSInvSalesPerf
ACME TRUCK SERVICING LTD
Sales Performance Analysis as at 31 May 2007
For selected company ATS
For all product majors, for all product groups
GM %
Sales
Margin
Qty
Margin
GM %
Sales
Qty
Margin
Sales
GM %
Qty
Margin
GM %
Sales
Qty
-------- FORECAST TO YEAR END --------
---------- TARGET TO YEAR END ----------
--------- ACTUAL YEAR TO DATE ---------
--------- TARGET YEAR TO DATE ---------
Ordered by inventory account group
ANALYSIS BY PRODUCT
Account Group Code & Description
10
2,000
1,734
10.58%
16,393
59
1,200
10.00%
12,000
60
296
10.59%
2,796
10
200
10.00%
I16 - Minor Components
2
38,000
17,591
15.58%
112,875
6
34,200
15.00%
228,000
12
3,000
15.58%
19,250
1
5,700
15.00%
I19 - Major Components
12
40,000
14.75%
5,900
11
22,046
14.95%
3,296
72
240,000
14.75%
35,400
65
129,268
14.95%
19,325
Total for Component Units:
280
10,000
11,676
19.86%
58,788
1,595
12,000
20.00%
60,000
1,680
1,991
19.86%
10,026
272
2,000
20.00%
I10 - Electrical System
500
16,000
54,531
52.62%
103,635
3,102
48,000
50.00%
96,000
3,000
9,300
52.62%
17,674
529
8,000
50.00%
I11 - Engine Servicing
200
4,000
4,726
24.74%
19,105
1,114
6,600
27.50%
24,000
1,200
806
24.74%
3,258
190
1,100
27.50%
I12 - Exhaust System
320
40,000
111,210
39.56%
281,099
1,724
96,000
40.00%
240,000
1,920
18,966
39.56%
47,939
294
16,000
40.00%
I14 - Braking System
1,300
70,000
38.71%
27,100
1,285
78,897
39.37%
31,063
7,800
420,000
38.71%
162,600
7,535
462,627
39.37%
182,143
Total for Service Parts & Spares:
1,312
110,000
30.00%
33,000
1,296
100,943
34.04%
34,359
7,872
660,000
30.00%
198,000
7,600
591,895
34.04%
201,468
PRODUCT TOTALS:
Page 1 of 1
Printed on 21 May 2008 at 03:41 PM