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 account number
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
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%
SI000579
11480 Highways Freight Services Ltd
28 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
Issues to Jobs:
2
220.45
440.90
399.25
9.45%
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
220.45
440.90
399.25
9.45%
MAIN
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%
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
2
247.23
494.46
436.00
11.82%
MAIN
SI000582
12570 Nationwide Freighters Ltd
31 Aug 2006
12
247.23
2,966.76
2,615.99
11.82%
MAIN
Issues to Jobs:
2
240.17
480.34
436.00
9.23%
SI000578
70784 Foden S106T Reg: NP5589
24 Aug 2006
2
240.17
480.34
436.00
9.23%
MAIN
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%
SI000573
12570 Nationwide Freighters Ltd
07 Aug 2006
4
300.56
1,202.24
741.18
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
SI000579
11480 Highways Freight Services Ltd
28 Aug 2006
4
309.15
1,236.60
740.27
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
Issues to Jobs:
16
305.93
4,894.86
2,964.40
39.44%
SI000572
70520 Hino SS330 Reg: SZ1329
04 Aug 2006
2
309.15
618.30
372.07
39.82%
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
SI000578
70784 Foden S106T Reg: NP5589
24 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
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%
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
SI000579
11480 Highways Freight Services Ltd
28 Aug 2006
4
49.73
198.92
177.94
10.55%
MAIN
Page 1 of 3
Printed on 01 Sep 2006 at 05:12 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
16.64%
962.57
1,154.74
52.49
22
143320
Service Chamber, Type 20 (Cont).
Sales to Customers:
19
52.92
1,005.55
829.11
17.55%
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
Issues to Jobs:
3
49.73
149.19
133.46
10.54%
SI000572
70520 Hino SS330 Reg: SZ1329
04 Aug 2006
1
49.73
49.73
44.49
10.54%
MAIN
SI000578
70784 Foden S106T Reg: NP5589
24 Aug 2006
2
49.73
99.46
88.97
10.55%
MAIN
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%
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
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%
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
65.35
130.70
105.24
19.48%
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
Issues to Jobs:
8
57.59
460.72
420.96
8.63%
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
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
58.82
117.64
105.24
10.54%
MAIN
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%
SI000573
12570 Nationwide Freighters Ltd
07 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
Issues to Jobs:
2
43.53
87.06
68.26
21.59%
SI000575
70525 ERF 66CU380E Reg: WK7025
08 Aug 2006
2
43.53
87.06
68.26
21.59%
MAIN
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%
SI000576
11520 Hutt Transport Services
18 Aug 2006
2
43.75
87.50
59.95
31.49%
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
Issues to Jobs:
3
39.01
117.04
89.94
23.15%
SI000574
70524 Kenworth W124 Reg: SP7725
08 Aug 2006
1
38.28
38.28
29.98
21.68%
MAIN
Page 2 of 3
Printed on 01 Sep 2006 at 05:12 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
29.16%
555.58
784.22
41.27
19
145728B
Slack Adjuster, 28 Spline (Cont).
Issues to Jobs:
3
39.01
117.04
89.94
23.15%
SI000580
70793 Ford N1524 Reg: SF9510
30 Aug 2006
2
39.38
78.76
59.96
23.87%
MAIN
Total:
172
158.72
27,300.00
18,908.34
30.74%
Sales to Customers:
136
151.98
20,669.89
14,396.07
30.35%
Issues to Jobs:
36
184.17
6,630.11
4,512.27
31.94%
Page 3 of 3
Printed on 01 Sep 2006 at 05:12 PM