TCSWhseInactive
ACME TRUCK SERVICING LTD
Inactive Inventory Analysis by Account as at 31 Mar 2005
For selected warehouses
HAM, MAIN
For all franchises
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, sales 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
4
6
2
913.99
08 Apr 2004
103207
Bulb 24V, Licence Plate
8
93.46
1
1
3
1
93.46
14 Nov 2004
105205
Bulb 12V 55W, Q/H
11
111.10
2
2
111.10
14 Nov 2004
105210
Bulb 12V 100W, Q/H
15
168.00
2
2
2
168.00
29 Mar 2005
105407
Bulb 24V 70W, Q/H
15
213.00
2
2
213.00
14 Nov 2004
105410
Bulb 24V 100W, Q/H
19
307.80
2
2
307.80
23 Jan 2005
108701
Fuse 5A, Blade
17
11.80
1
17
30
6
11.80
05 Apr 2005
108702
Fuse 7.5A, Blade
17
11.90
1
16
30
6
11.90
05 Apr 2005
108705
Fuse 20A, Blade
8
5.60
1
10
24
4
5.60
05 Apr 2005
108706
Fuse 25A, Blade
83
58.10
1
41
14
4
58.10
05 Apr 2005
108707
Fuse 30A, Blade
60
42.00
1
41
12
4
42.00
05 Apr 2005
114151
Oil Filter, Detroit 8.2
12
140.30
2
27
23
2
140.30
14 Nov 2004
114152-S2
Oil Filter, Perkins
27
447.71
2
9
25
2
447.71
29 Mar 2005
117152-S2
Fuel Filter, Perkins
38
992.43
5
11
10
5
992.43
29 Mar 2005
122105
Exhaust Tubing, 5"
100
1,751.07
28
20
12
8
1,751.07
08 Mar 2005
122204
Exhaust Clamp, 4"
40
556.18
4
2
15
16
3
556.18
29 Mar 2005
122205
Exhaust Clamp, 5"
83
1,283.23
7
12
6
1
1,283.23
18 Mar 2005
143330
Service Chamber, Type 30
22
1,082.55
12
2
20
2
1,082.55
29 Mar 2005
Total:
8,190.22
913.99
7,276.23
Page 1 of 1
Printed on 14 Apr 2005 at 12:50 PM