TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Inventory Sales Analysis by Warehouse
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
Warehouse: HAM - Hamilton Depot
30.12%
174.32
249.45
249.45
1
108120
Battery, 12 Volt 21 Plate
Each
59.99%
90.83
227.00
22.70
10
114151-S2
Oil Filter, Detroit 8.2
Each
49.58%
119.00
236.00
29.50
8
114152-S2
Oil Filter, Perkins
Each
25.53%
124.73
167.50
16.75
10
122104
Exhaust Tubing, 4"
Foot
27.87%
101.92
141.30
23.55
6
122105
Exhaust Tubing, 5"
Foot
30.48%
23.01
33.10
16.55
2
122203
Exhaust Clamp, 3"
Each
31.81%
25.30
37.10
18.55
2
122204
Exhaust Clamp, 4"
Each
50.01%
1,030.29
2,061.00
343.50
6
142312
Brake Lining Set, COF 0.36
Each
23.13%
339.77
442.00
55.25
8
143320
Service Chamber, Type 20
Each
17.10%
299.68
361.50
60.25
6
143324
Service Chamber, Type 24
Each
23.35%
500.94
653.50
65.35
10
143330
Service Chamber, Type 30
Each
35.56%
192.36
298.50
49.75
6
145710B
Slack Adjuster, 10 Spline
Each
35.48%
225.83
350.00
43.75
8
145728B
Slack Adjuster, 28 Spline
Each
Total for Warehouse: Hamilton Depot
83
63.35
5,257.95
3,247.98
38.23%
Warehouse: MAIN - Main Warehouse
8.61%
325.66
356.35
71.27
5
100805
Lamp, L/Range Driving 12V 55W
Each
8.52%
208.80
228.24
76.08
3
100810
Lamp, L/Range Driving 12V 100W
Each
10.01%
107.80
119.79
10.89
11
103100
Lamp, Cab Marker, Clear
Each
10.04%
68.58
76.23
10.89
7
103104
Lamp, Cab Marker, Amber
Each
10.01%
117.60
130.68
10.89
12
103105
Lamp, Cab Marker, Red
Each
15.66%
58.11
68.90
13.78
5
103207
Bulb 24V, Licence Plate
Each
20.14%
1,220.10
1,527.89
218.27
7
108120
Battery, 12 Volt 21 Plate
Each
20.21%
976.50
1,223.90
244.78
5
108150
Battery, 12 Volt 27 Plate
Each
20.10%
1,954.40
2,446.16
305.77
8
108200
Battery, 12 Volt 37 Plate
Each
47.77%
155.30
297.34
19.82
15
114151-S2
Oil Filter, Detroit 8.2
Each
31.77%
316.96
464.58
25.81
18
114152-S2
Oil Filter, Perkins
Each
48.44%
306.10
593.67
39.58
15
117151-S2
Fuel Filter, Detroit 8.2
Each
32.49%
515.72
763.92
42.44
18
117152-S2
Fuel Filter, Perkins
Each
19.11%
877.25
1,084.44
12.91
84
122103
Exhaust Tubing, 3"
Foot
14.92%
810.71
952.90
14.66
65
122104
Exhaust Tubing, 4"
Foot
17.72%
864.89
1,051.11
20.61
51
122105
Exhaust Tubing, 5"
Foot
24.38%
197.10
260.64
14.48
18
122203
Exhaust Clamp, 3"
Each
26.37%
286.80
389.52
16.23
24
122204
Exhaust Clamp, 4"
Each
16.83%
179.45
215.76
17.98
12
122205
Exhaust Clamp, 5"
Each
Page 1 of 2
Printed on 01 Sep 2006 at 05:05 PM
TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Summary Inventory Sales Analysis by Warehouse
Account
Account Name
Unit
Sales Total
Average Price
Margin
Qty
Cost Total
Warehouse: MAIN - Main Warehouse (Cont.)
11.11%
2,195.89
2,470.31
224.57
11
141605
Brake Drum, 15", 3 Spoke
Each
11.51%
3,487.99
3,941.56
246.35
16
141607
Brake Drum, 16", 5 Spoke
Each
41.16%
8,149.95
13,851.59
314.81
44
142312
Brake Lining Set, COF 0.36
Each
12.62%
622.80
712.74
50.91
14
143320
Service Chamber, Type 20
Each
3.48%
523.39
542.26
54.23
10
143324
Service Chamber, Type 24
Each
10.18%
736.67
820.14
58.58
14
143330
Service Chamber, Type 30
Each
24.30%
273.03
360.68
45.09
8
145710B
Slack Adjuster, 10 Spline
Each
24.06%
329.75
434.22
39.47
11
145728B
Slack Adjuster, 28 Spline
Each
-11.30%
672.00
603.75
201.25
3
165151
Detroit 8.2 Waterpump Re-manf
Each
31.43%
120.00
175.00
175.00
1
165159
Misc Waterpump Re-manf
Each
6.35%
14,750.00
15,750.00
15,750.00
1
197151
Detroit 8.2 Engine Re-manf
Each
Total for Warehouse: Main Warehouse
516
100.61
51,914.27
41,409.30
20.24%
Total:
599
95.45
57,172.22
44,657.28
21.89%
Page 2 of 2
Printed on 01 Sep 2006 at 05:05 PM