TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Inventory Sales Analysis by Account
For all warehouses
For all franchises
From first group to last group, from first account to last account, ordered by account number
For the period from 01 Aug 2006 to 31 Aug 2006, for all sales categories
Account
Account Name
Unit
Sales Total
Average Price
Margin
Qty
Cost Total
8.61%
325.66
356.35
71.27
5
100805
Lamp, L/Range Driving 12V 55W
Each
Sales to Customers:
5
71.27
356.35
325.66
8.61%
8.52%
208.80
228.24
76.08
3
100810
Lamp, L/Range Driving 12V 100W
Each
Sales to Customers:
3
76.08
228.24
208.80
8.52%
10.01%
107.80
119.79
10.89
11
103100
Lamp, Cab Marker, Clear
Each
Sales to Customers:
11
10.89
119.79
107.80
10.01%
10.04%
68.58
76.23
10.89
7
103104
Lamp, Cab Marker, Amber
Each
Sales to Customers:
7
10.89
76.23
68.58
10.04%
10.01%
117.60
130.68
10.89
12
103105
Lamp, Cab Marker, Red
Each
Sales to Customers:
12
10.89
130.68
117.60
10.01%
15.66%
58.11
68.90
13.78
5
103207
Bulb 24V, Licence Plate
Each
Sales to Customers:
5
13.78
68.90
58.11
15.66%
21.54%
1,394.42
1,777.34
222.17
8
108120
Battery, 12 Volt 21 Plate
Each
Sales to Customers:
8
222.17
1,777.34
1,394.42
21.54%
20.21%
976.50
1,223.90
244.78
5
108150
Battery, 12 Volt 27 Plate
Each
Sales to Customers:
5
244.78
1,223.90
976.50
20.21%
20.10%
1,954.40
2,446.16
305.77
8
108200
Battery, 12 Volt 37 Plate
Each
Sales to Customers:
8
305.77
2,446.16
1,954.40
20.10%
53.06%
246.13
524.34
20.97
25
114151-S2
Oil Filter, Detroit 8.2
Each
Sales to Customers:
24
21.04
505.04
235.78
53.31%
Issues to Jobs:
1
19.30
19.30
10.35
46.37%
37.77%
435.96
700.58
26.95
26
114152-S2
Oil Filter, Perkins
Each
Sales to Customers:
26
26.95
700.58
435.96
37.77%
48.44%
306.10
593.67
39.58
15
117151-S2
Fuel Filter, Detroit 8.2
Each
Sales to Customers:
13
39.73
516.49
265.29
48.64%
Issues to Jobs:
2
38.59
77.18
40.81
47.12%
Page 1 of 3
Printed on 01 Sep 2006 at 05:11 PM
TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Inventory Sales Analysis by Account
Account
Account Name
Unit
Sales Total
Average Price
Margin
Qty
Cost Total
32.49%
515.72
763.92
42.44
18
117152-S2
Fuel Filter, Perkins
Each
Sales to Customers:
18
42.44
763.92
515.72
32.49%
19.11%
877.25
1,084.44
12.91
84
122103
Exhaust Tubing, 3"
Foot
Sales to Customers:
84
12.91
1,084.44
877.25
19.11%
16.51%
935.44
1,120.40
14.94
75
122104
Exhaust Tubing, 4"
Foot
Sales to Customers:
75
14.94
1,120.40
935.44
16.51%
18.92%
966.81
1,192.41
20.92
57
122105
Exhaust Tubing, 5"
Foot
Sales to Customers:
57
20.92
1,192.41
966.81
18.92%
25.07%
220.11
293.74
14.69
20
122203
Exhaust Clamp, 3"
Each
Sales to Customers:
20
14.69
293.74
220.11
25.07%
26.84%
312.10
426.62
16.41
26
122204
Exhaust Clamp, 4"
Each
Sales to Customers:
26
16.41
426.62
312.10
26.84%
16.83%
179.45
215.76
17.98
12
122205
Exhaust Clamp, 5"
Each
Sales to Customers:
12
17.98
215.76
179.45
16.83%
11.11%
2,195.89
2,470.31
224.57
11
141605
Brake Drum, 15", 3 Spoke
Each
Sales to Customers:
9
225.49
2,029.41
1,796.64
11.47%
Issues to Jobs:
2
220.45
440.90
399.25
9.45%
11.51%
3,487.99
3,941.56
246.35
16
141607
Brake Drum, 16", 5 Spoke
Each
Sales to Customers:
14
247.23
3,461.22
3,051.99
11.82%
Issues to Jobs:
2
240.17
480.34
436.00
9.23%
42.31%
9,180.24
15,912.59
318.25
50
142312
Brake Lining Set, COF 0.36
Each
Sales to Customers:
34
324.05
11,017.73
6,215.84
43.58%
Issues to Jobs:
16
305.93
4,894.86
2,964.40
39.44%
16.64%
962.57
1,154.74
52.49
22
143320
Service Chamber, Type 20
Each
Sales to Customers:
19
52.92
1,005.55
829.11
17.55%
Issues to Jobs:
3
49.73
149.19
133.46
10.54%
8.93%
823.07
903.76
56.49
16
143324
Service Chamber, Type 24
Each
Sales to Customers:
16
56.49
903.76
823.07
8.93%
16.02%
1,237.61
1,473.64
61.40
24
143330
Service Chamber, Type 30
Each
Sales to Customers:
16
63.31
1,012.92
816.65
19.38%
Page 2 of 3
Printed on 01 Sep 2006 at 05:11 PM
TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Inventory Sales Analysis by Account
Account
Account Name
Unit
Sales Total
Average Price
Margin
Qty
Cost Total
16.02%
1,237.61
1,473.64
61.40
24
143330
Service Chamber, Type 30 (Cont).
Sales to Customers:
16
63.31
1,012.92
816.65
19.38%
Issues to Jobs:
8
57.59
460.72
420.96
8.63%
29.40%
465.39
659.18
47.08
14
145710B
Slack Adjuster, 10 Spline
Each
Sales to Customers:
12
47.68
572.12
397.13
30.59%
Issues to Jobs:
2
43.53
87.06
68.26
21.59%
29.16%
555.58
784.22
41.27
19
145728B
Slack Adjuster, 28 Spline
Each
Sales to Customers:
16
41.70
667.18
465.64
30.21%
Issues to Jobs:
3
39.01
117.04
89.94
23.15%
-11.30%
672.00
603.75
201.25
3
165151
Detroit 8.2 Waterpump Re-manf
Each
Sales to Customers:
3
201.25
603.75
672.00
-11.30%
31.43%
120.00
175.00
175.00
1
165159
Misc Waterpump Re-manf
Each
Sales to Customers:
1
175.00
175.00
120.00
31.43%
6.35%
14,750.00
15,750.00
15,750.00
1
197151
Detroit 8.2 Engine Re-manf
Each
Sales to Customers:
1
15,750.00
15,750.00
14,750.00
6.35%
Total:
599
95.45
57,172.22
44,657.28
21.89%
Sales to Customers:
560
90.08
50,445.63
40,093.85
20.52%
Issues to Jobs:
39
172.48
6,726.59
4,563.43
32.16%
Page 3 of 3
Printed on 01 Sep 2006 at 05:11 PM