TCSDebtPriceAnalysis
ACME TRUCK SERVICING LTD
Debtor Inventory Pricing Analysis
Control account 130
For all account groups, for all business groups, for all locations, ordered by account alpha key
For prices effective to 31 Mar 2006
Item Code
ACC GRP
LOCATION
BUS GRP
ACCOUNT NAME & ADDRESS
ACCOUNT
Description
Unit
Price Code &
FX
Price Value
From Date
To Date
Sell Price
Unit Cost
Margin
Amount
10695
Mr R G Edwards, 69 Short Street, Mount Roskill, Auckland 1004
D30
NTH
114152-S2
Oil Filter, Perkins
Each
R
5.00%
28.03
14.88
46.92%
29.50
117152-S2
Fuel Filter, Perkins
Each
R
5.00%
46.08
24.13
47.62%
48.50
10773
Freightline NZ Ltd, P O Box 14-107, Panmure, Auckland 1134
D20
NTH
114151-S2
Oil Filter, Detroit 8.2
Each
R
15.00%
01 Jul 2005
30 Jun 2006
19.30
9.08
52.93%
22.70
Qty
Action
Break Value
18.33
9.08
50.45%
5
5%
UseValue
17.37
9.08
47.70%
10
10%
UseValue
117151-S2
Fuel Filter, Detroit 8.2
Each
R
15.00%
01 Jul 2005
30 Jun 2006
38.59
18.17
52.92%
45.40
Qty
Action
Break Value
36.66
18.17
50.44%
5
5%
UseValue
34.73
18.17
47.69%
10
10%
UseValue
142312
Brake Lining Set, COF 0.36
Each
R
15.00%
30 Jun 2006
291.98
172.00
41.09%
343.50
11480
Highways Freight Services Ltd, P O Box 148, Palmerston North 5301
D10
CEN
114151-S2
Oil Filter, Detroit 8.2
Each
R
20.50
31 Mar 2006
20.50
9.08
55.69%
22.70
117151-S2
Fuel Filter, Detroit 8.2
Each
R
40.75
31 Mar 2006
40.75
18.17
55.42%
45.40
142312
Brake Lining Set, COF 0.36
Each
R
320.00
31 Mar 2006
320.00
172.00
46.25%
343.50
12570
Nationwide Freighters Ltd, Private Bag, Henderson, Auckland 1231
D20
NTH
114151-S2
Oil Filter, Detroit 8.2
Each
R
20.00%
18.16
9.08
49.98%
22.70
Qty
Action
Break Value
16.34
9.08
44.43%
10
10%
UseValue
117151-S2
Fuel Filter, Detroit 8.2
Each
R
20.00%
36.32
18.17
49.98%
45.40
Qty
Action
Break Value
32.69
18.17
44.42%
10
10%
UseValue
142312
Brake Lining Set, COF 0.36
Each
R
20.00%
274.80
172.00
37.41%
343.50
Qty
Action
Break Value
247.32
172.00
30.45%
10
10%
UseValue
11715
N Z Freight Services Ltd, Private Bag, Mount Albert, Auckland 1003
D20
NTH
114151-S2
Oil Filter, Detroit 8.2
Each
R
19.95
30 Jun 2006
19.95
9.08
54.47%
22.70
117151-S2
Fuel Filter, Detroit 8.2
Each
R
38.95
30 Jun 2006
38.95
18.17
53.35%
45.40
142312
Brake Lining Set, COF 0.36
Each
R
315.50
30 Jun 2006
315.50
172.00
45.48%
343.50
Page 1 of 1
Printed on 17 Feb 2006 at 04:06 PM