TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Inventory Sales Analysis by Account
For all warehouses
For all franchises
From group I14 to group I14, from first account to last account, ordered by franchise
For the period from 01 Aug 2006 to 31 Aug 2006, for all sales categories
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
30.74%
18,908.34
27,300.00
158.72
172
Franchise: Z - All Makes
141605
Brake Drum, 15", 3 Spoke
11.11%
2,195.89
2,470.31
224.57
11
Each
SI000579
11480 Highways Freight Services Ltd
28 Aug 2006
2
220.45
440.90
399.25
9.45%
MAIN
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
220.45
440.90
399.25
9.45%
MAIN
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
7
226.93
1,588.51
1,397.39
12.03%
MAIN
141607
Brake Drum, 16", 5 Spoke
11.51%
3,487.99
3,941.56
246.35
16
Each
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
2
247.23
494.46
436.00
11.82%
MAIN
SI000578
70784 Foden S106T Reg: NP5589
24 Aug 2006
2
240.17
480.34
436.00
9.23%
MAIN
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
12
247.23
2,966.76
2,615.99
11.82%
MAIN
142312
Brake Lining Set, COF 0.36
42.31%
9,180.24
15,912.59
318.25
50
Each
SI000572
70520 Hino SS330 Reg: SZ1329
04 Aug 2006
2
309.15
618.30
372.07
39.82%
MAIN
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
4
300.56
1,202.24
741.18
38.35%
MAIN
SI000574
70524 Kenworth W124 Reg: SP7725
08 Aug 2006
2
300.56
601.12
370.59
38.35%
MAIN
SI000575
70525 ERF 66CU380E Reg: WK7025
08 Aug 2006
4
300.56
1,202.24
741.19
38.35%
MAIN
SI000576
11520 Hutt Transport Services
18 Aug 2006
10
343.50
3,435.00
1,852.96
46.06%
MAIN
SI000577
11900 Wanganui Transport Ltd
22 Aug 2006
2
343.50
687.00
370.59
46.06%
MAIN
SI000578
70784 Foden S106T Reg: NP5589
24 Aug 2006
4
309.15
1,236.60
740.27
40.14%
MAIN
SI000579
11480 Highways Freight Services Ltd
28 Aug 2006
4
309.15
1,236.60
740.27
40.14%
MAIN
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
4
309.15
1,236.60
740.28
40.14%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
6
343.50
2,061.00
1,030.29
50.01%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
9
300.56
2,705.04
1,665.62
38.43%
MAIN
SR000033
11480 Highways Freight Services Ltd
31 Aug 2006
-1
-309.15
-309.15
-185.07
40.14%
MAIN
143320
Service Chamber, Type 20
16.64%
962.57
1,154.74
52.49
22
Each
SI000572
70520 Hino SS330 Reg: SZ1329
04 Aug 2006
1
49.73
49.73
44.49
10.54%
MAIN
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
2
48.34
96.68
88.97
7.97%
MAIN
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
55.25
110.50
88.97
19.48%
MAIN
SI000577
11900 Wanganui Transport Ltd
22 Aug 2006
2
55.25
110.50
88.97
19.48%
MAIN
SI000578
70784 Foden S106T Reg: NP5589
24 Aug 2006
2
49.73
99.46
88.97
10.55%
MAIN
SI000579
11480 Highways Freight Services Ltd
28 Aug 2006
4
49.73
198.92
177.94
10.55%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
8
55.25
442.00
339.77
23.13%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
2
48.34
96.68
88.98
7.96%
MAIN
SR000033
11480 Highways Freight Services Ltd
31 Aug 2006
-1
-49.73
-49.73
-44.49
10.54%
MAIN
Page 1 of 2
Printed on 01 Sep 2006 at 05:17 PM
TCSWhseSalesAnalysis
ACME TRUCK SERVICING LTD
Detailed Inventory Sales Analysis by Account
Margin
Cost Value
Sales Value
Unit Price
Qty
Customer Account & Name
Date
Invoice
Warehouse
ACCOUNT
ACCOUNT NAME
UNIT
SALES TOTAL
AVERAGE PRICE
MARGIN
QTY
COST TOTAL
30.74%
18,908.34
27,300.00
158.72
172
Franchise: Z - All Makes (Cont.)
143324
Service Chamber, Type 24
8.93%
823.07
903.76
56.49
16
Each
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
60.25
120.50
104.68
13.13%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
6
60.25
361.50
299.68
17.10%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
8
52.72
421.76
418.71
0.72%
MAIN
143330
Service Chamber, Type 30
16.02%
1,237.61
1,473.64
61.40
24
Each
SI000574
70524 Kenworth W124 Reg: SP7725
08 Aug 2006
2
57.18
114.36
105.24
7.97%
MAIN
SI000575
70525 ERF 66CU380E Reg: WK7025
08 Aug 2006
4
57.18
228.72
210.48
7.97%
MAIN
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
65.35
130.70
105.24
19.48%
MAIN
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
58.82
117.64
105.24
10.54%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
10
65.35
653.50
500.94
23.35%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
4
57.18
228.72
210.47
7.98%
MAIN
145710B
Slack Adjuster, 10 Spline
29.40%
465.39
659.18
47.08
14
Each
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
2
43.53
87.06
68.26
21.59%
MAIN
SI000575
70525 ERF 66CU380E Reg: WK7025
08 Aug 2006
2
43.53
87.06
68.26
21.59%
MAIN
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
49.75
99.50
68.25
31.41%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
6
49.75
298.50
192.36
35.56%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
2
43.53
87.06
68.26
21.59%
MAIN
145728B
Slack Adjuster, 28 Spline
29.16%
555.58
784.22
41.27
19
Each
SI000574
70524 Kenworth W124 Reg: SP7725
08 Aug 2006
1
38.28
38.28
29.98
21.68%
MAIN
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
43.75
87.50
59.95
31.49%
MAIN
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
39.38
78.76
59.96
23.87%
MAIN
SI000581
11950 Waikato Transport Ltd
31 Aug 2006
8
43.75
350.00
225.83
35.48%
HAM
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
6
38.28
229.68
179.86
21.69%
MAIN
Total:
172
158.72
27,300.00
18,908.34
30.74%
Page 2 of 2
Printed on 01 Sep 2006 at 05:17 PM