TCSWhseInactive
ACME TRUCK SERVICING LTD
Inactive Inventory Analysis by Warehouse as at 31 Mar 2005
For selected warehouses
HAM, MAIN
For all franchises
Warehouse code HAM
From first group to last group, from first account to last account, ordered by account number
Items aged older than 12 months, or nil sales for 6 months, stock age analysed by quarterly periods
Dec 03
Mar 04
Jun 04
Sep 04
Dec 04
Mar 05
& Qty
Stock Value
Qty
Account Name
Account
Current Stock
Aged Stock
Last Sale Date
108200
Battery, 12 Volt 37 Plate
1
244.30
1
244.30
108701
Fuse 5A, Blade
3
2.10
3
1
2.10
22 Jan 2005
108702
Fuse 7.5A, Blade
5
3.50
5
1
3.50
18 Feb 2005
108705
Fuse 20A, Blade
2
1.40
2
1
1.40
22 Jan 2005
108706
Fuse 25A, Blade
3
2.10
3
1
2.10
15 Oct 2004
108707
Fuse 30A, Blade
2
1.40
2
1
1.40
15 Oct 2004
122105
Exhaust Tubing, 5"
15
263.17
15
8
263.17
08 Mar 2005
122203
Exhaust Clamp, 3"
6
74.61
6
2
74.61
18 Feb 2005
122204
Exhaust Clamp, 4"
2
27.85
2
1
27.85
22 Jan 2005
122205
Exhaust Clamp, 5"
4
61.72
4
1
61.72
18 Mar 2005
141605
Brake Drum, 15", 3 Spoke
6
1,231.55
6
2
1,231.55
22 Jan 2005
141607
Brake Drum, 16", 5 Spoke
6
1,354.55
6
3
1,354.55
18 Feb 2005
143320
Service Chamber, Type 20
2
86.71
2
2
86.71
22 Jan 2005
143324
Service Chamber, Type 24
5
261.65
5
2
261.65
18 Feb 2005
143330
Service Chamber, Type 30
2
101.44
2
4
101.44
18 Feb 2005
145710B
Slack Adjuster, 10 Spline
1
31.21
1
1
31.21
15 Oct 2004
145728B
Slack Adjuster, 28 Spline
2
54.94
2
54.94
165151
Detroit 8.2 Waterpump Re-manf
2
280.00
2
280.00
Total for Warehouse:
4,084.20
280.00
3,804.20
Page 1 of 1
Printed on 14 Apr 2005 at 12:48 PM
TCSWhseInactive
ACME TRUCK SERVICING LTD
Inactive Inventory Analysis by Warehouse as at 31 Mar 2005
For selected warehouses
HAM, MAIN
For all franchises
Warehouse code MAIN
From first group to last group, from first account to last account, ordered by account number
Items aged older than 12 months, or nil sales for 6 months, stock age analysed by quarterly periods
Dec 03
Mar 04
Jun 04
Sep 04
Dec 04
Mar 05
& Qty
Stock Value
Qty
Account Name
Account
Current Stock
Aged Stock
Last Sale Date
100805
Lamp, L/Range Driving 12V 55W
14
913.99
14
2
913.99
08 Apr 2004
103207
Bulb 24V, Licence Plate
8
93.46
8
1
93.46
14 Nov 2004
105205
Bulb 12V 55W, Q/H
11
111.10
11
2
111.10
14 Nov 2004
105210
Bulb 12V 100W, Q/H
15
168.00
15
2
168.00
29 Mar 2005
105407
Bulb 24V 70W, Q/H
15
213.00
15
2
213.00
14 Nov 2004
105410
Bulb 24V 100W, Q/H
19
307.80
19
2
307.80
23 Jan 2005
108701
Fuse 5A, Blade
14
9.70
14
6
9.70
05 Apr 2005
108702
Fuse 7.5A, Blade
12
8.40
12
6
8.40
05 Apr 2005
108705
Fuse 20A, Blade
6
4.20
6
4
4.20
05 Apr 2005
108706
Fuse 25A, Blade
80
56.00
80
4
56.00
05 Apr 2005
108707
Fuse 30A, Blade
58
40.60
58
4
40.60
05 Apr 2005
114151
Oil Filter, Detroit 8.2
12
140.30
12
2
140.30
14 Nov 2004
114152-S2
Oil Filter, Perkins
27
447.71
27
2
447.71
29 Mar 2005
117152-S2
Fuel Filter, Perkins
38
992.43
38
5
992.43
29 Mar 2005
122105
Exhaust Tubing, 5"
85
1,487.90
85
8
1,487.90
25 Feb 2005
122204
Exhaust Clamp, 4"
38
528.33
38
3
528.33
29 Mar 2005
122205
Exhaust Clamp, 5"
79
1,221.51
79
2
1,221.51
25 Feb 2005
143330
Service Chamber, Type 30
20
981.11
20
2
981.11
29 Mar 2005
Total for Warehouse:
7,725.54
913.99
6,811.55
Page 1 of 1
Printed on 14 Apr 2005 at 12:48 PM