TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Consolidated 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 group
For the period from 01 Aug 2006 to 31 Aug 2006, for all sales categories
Warehouse
Sales Total
Average Price
Margin
Qty
Cost Total
64
100.43
6,427.59
5,211.87
18.91%
Account Group: I10 - Electrical System
30.12%
174.32
249.45
249.45
1
HAM
Hamilton Depot
18.46%
5,037.55
6,178.14
98.07
63
MAIN
Main Warehouse
84
30.74
2,582.51
1,503.91
41.77%
Account Group: I11 - Engine Servicing
54.68%
209.83
463.00
25.72
18
HAM
Hamilton Depot
38.94%
1,294.08
2,119.51
32.11
66
MAIN
Main Warehouse
274
15.82
4,333.37
3,491.16
19.44%
Account Group: I12 - Exhaust System
27.45%
274.96
379.00
18.95
20
HAM
Hamilton Depot
18.67%
3,216.20
3,954.37
15.57
254
MAIN
Main Warehouse
172
158.72
27,300.00
18,908.34
30.74%
Account Group: I14 - Braking System
37.86%
2,588.87
4,166.50
94.69
44
HAM
Hamilton Depot
29.46%
16,319.47
23,133.50
180.73
128
MAIN
Main Warehouse
4
194.69
778.75
792.00
-1.70%
Account Group: I16 - Engine Components
-1.70%
792.00
778.75
194.69
4
MAIN
Main Warehouse
1
15,750.00
15,750.00
14,750.00
6.35%
Account Group: I19 - Major Components
6.35%
14,750.00
15,750.00
15,750.00
1
MAIN
Main Warehouse
Total:
599
95.45
57,172.22
44,657.28
21.89%
Page 1 of 1
Printed on 01 Sep 2006 at 05:08 PM