TCSWhseAged
ACME TRUCK SERVICING LTD
Detailed Aged Inventory Valuation as at 31 Oct 2009
For selected warehouses, for all franchises, from first group to last group, from first account to last account
Report basis FIFO, analysed by monthly periods, ordered by account group
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Total
Qty
Account Name
Account
6 Periods
Department: 10 Warehouse: MAIN - Main-Parts Warehouse
Account Group: I10 - Electrical System
100804
Lamp, Driving 12V 45W
2,281.50
292.50
292.50
585.00
585.00
292.50
39
234.00
100805
Lamp, L/Range Driving 12V 55W
2,213.40
325.50
325.50
651.00
651.00
260.40
34
100810
Lamp, L/Range Driving 12V 100W
1,183.20
348.00
348.00
487.20
17
103100
Lamp, Cab Marker, Clear
264.60
245.00
19.60
27
103104
Lamp, Cab Marker, Amber
58.80
58.80
6
103105
Lamp, Cab Marker, Red
235.20
196.00
39.20
24
103207
Bulb 24V, Licence Plate
141.00
141.00
12
105205
Bulb 12V 55W, Q/H
242.40
50.50
101.00
111.10
24
-20.20
105210
Bulb 12V 100W, Q/H
156.80
56.00
112.00
22.40
14
-33.60
105407
Bulb 24V 70W, Q/H
511.20
213.00
213.00
85.20
36
105410
Bulb 24V 100W, Q/H
372.60
243.00
129.60
23
108701
Fuse 5A, Blade
105.53
10.55
10.55
10.55
10.55
150
63.33
108702
Fuse 7.5A, Blade
121.10
3.50
10.50
10.50
10.50
173
86.10
108705
Fuse 20A, Blade
64.40
3.50
7.00
7.00
7.00
92
39.90
108706
Fuse 25A, Blade
75.60
3.50
7.00
7.00
7.00
108
51.10
108707
Fuse 30A, Blade
65.80
3.50
7.00
7.00
7.00
94
41.30
Total for Electrical System:
8,093.13
747.30
1,480.80
1,253.65
1,978.25
1,491.05
680.15
461.93
Account Group: I11 - Engine Servicing
114151-S2
Oil Filter, Detroit 8.2
1,531.53
814.64
716.89
188
114152-S2
Oil Filter, Perkins
1,699.54
669.11
1,030.43
127
117151-S2
Fuel Filter, Detroit 8.2
1,938.37
1,615.31
323.06
120
117152-S2
Fuel Filter, Perkins
2,388.18
1,011.94
1,376.24
118
119151
Top Hose, Radiator
502.95
125.74
377.21
20
119151-NZ
Radiator, Top Hose (NZ Mod)
740.96
161.08
322.16
257.72
23
119152
Bottom Hose, Radiator
365.76
101.60
264.16
18
Total for Engine Servicing:
9,167.29
388.42
3,393.48
257.72
2,721.00
2,406.67
Account Group: I12 - Exhaust System
122103
Exhaust Tubing, 3"
1,691.50
995.00
497.50
199.00
170
122104
Exhaust Tubing, 4"
1,709.20
1,195.24
513.96
143
122105
Exhaust Tubing, 5"
1,695.00
1,695.00
100
122203
Exhaust Clamp, 3"
689.85
109.50
109.50
109.50
109.50
63
251.85
122204
Exhaust Clamp, 4"
717.00
298.75
239.00
179.25
60
122205
Exhaust Clamp, 5"
801.15
281.11
281.11
238.93
57
Total for Exhaust System:
7,303.70
4,465.10
1,143.57
1,025.18
308.50
109.50
251.85
Page 1 of 3
Printed on 23 Nov 2009 at 10:15 AM
TCSWhseAged
ACME TRUCK SERVICING LTD
Detailed Aged Inventory Valuation as at 31 Oct 2009
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Total
Qty
Account Name
Account
6 Periods
Department: 10 Warehouse: MAIN - Main-Parts Warehouse (Cont.)
Account Group: I14 - Braking System
141605
Brake Drum, 15", 3 Spoke
2,972.95
2,123.54
849.41
14
141607
Brake Drum, 16", 5 Spoke
3,689.92
2,306.20
1,383.72
16
142312
Brake Lining Set, COF 0.36
45,637.81
18,328.44
27,309.37
249
143320
Service Chamber, Type 20
3,114.07
2,256.57
857.50
69
143324
Service Chamber, Type 24
4,147.22
2,658.47
1,488.75
78
143330
Service Chamber, Type 30
3,880.62
2,126.37
1,754.25
73
145710B
Slack Adjuster, 10 Spline
2,004.69
1,359.11
645.58
59
145728B
Slack Adjuster, 28 Spline
1,958.39
1,506.45
451.94
65
Total for Braking System:
67,405.67
32,665.15
34,740.52
Account Group: I16 - Minor Components
163171
Perkins Fuelpump Re-manf
858.35
214.59
429.18
214.58
4
165151
Detroit 8.2 Waterpump Re-manf
990.00
6
990.00
165151-R2
Detroit 8.2 Waterpump Re-Manf
937.50
562.50
375.00
5
165159
Misc Waterpump Re-manf
125.24
125.24
1
165171
Perkins Waterpump Re-manf
699.46
174.87
349.73
174.86
4
Total for Minor Components:
3,610.55
1,077.20
1,153.91
389.44
990.00
3,196.32
1,799.55
40,464.95
3,044.38
38,693.34
6,678.02
95,580.34
Percentage Summary:
6.99%
40.48%
3.19%
3.34%
1.88%
42.34%
100.00%
1,703.78
1.78%
Total for Main-Parts Warehouse:
Department: 10 Warehouse: MAIN-3150 - MAIN Consignment Stock 3150
Account Group: I10 - Electrical System
108120
Battery, 12 Volt 21 Plate
348.60
348.60
2
108150
Battery, 12 Volt 27 Plate
585.90
585.90
3
108200
Battery, 12 Volt 37 Plate
488.60
488.60
2
Total for Electrical System:
1,423.10
1,423.10
1,423.10
1,423.10
Percentage Summary:
100.00%
100.00%
Total for MAIN Consignment Stock 3150:
Department: 10 Warehouse: MAIN-X - Main-Core Returns
Account Group: I16 - Minor Components
C163171
Remanf Fuelpump Core
500.00
2
500.00
C165159
Remanf Waterpump Core
200.00
100.00
2
100.00
C165171
Remanf Waterpump Core
400.00
2
400.00
Total for Minor Components:
1,100.00
100.00
1,000.00
Page 2 of 3
Printed on 23 Nov 2009 at 10:15 AM
TCSWhseAged
ACME TRUCK SERVICING LTD
Detailed Aged Inventory Valuation as at 31 Oct 2009
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Total
Qty
Account Name
Account
6 Periods
100.00
1,100.00
Percentage Summary:
9.09%
100.00%
1,000.00
90.91%
Total for Main-Core Returns:
3,196.32
1,799.55
40,564.95
3,044.38
38,693.34
8,101.12
98,103.44
Percentage Summary:
8.26%
39.44%
3.10%
3.26%
1.83%
41.35%
100.00%
2,703.78
2.76%
Total for department 10 - Parts Department:
Page 3 of 3
Printed on 23 Nov 2009 at 10:15 AM
TCSWhseAged
ACME TRUCK SERVICING LTD
Detailed Aged Inventory Valuation as at 31 Oct 2009
For selected warehouses, for all franchises, from first group to last group, from first account to last account
Report basis FIFO, analysed by monthly periods, ordered by account group
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Total
Qty
Account Name
Account
6 Periods
Department: 20 Warehouse: HAM - Hamilton-Parts Depot
Account Group: I10 - Electrical System
108705
Fuse 20A, Blade
1.40
2
1.40
108707
Fuse 30A, Blade
0.70
1
0.70
Total for Electrical System:
2.10
2.10
Account Group: I11 - Engine Servicing
114151-S2
Oil Filter, Detroit 8.2
15.70
2
15.70
Total for Engine Servicing:
15.70
15.70
Account Group: I14 - Braking System
141605
Brake Drum, 15", 3 Spoke
412.30
412.30
2
141607
Brake Drum, 16", 5 Spoke
224.72
224.72
1
142312
Brake Lining Set, COF 0.36
180.02
180.02
1
143320
Service Chamber, Type 20
43.77
43.77
1
143324
Service Chamber, Type 24
205.57
205.57
4
143330
Service Chamber, Type 30
51.85
51.85
1
145710B
Slack Adjuster, 10 Spline
33.02
33.02
1
145728B
Slack Adjuster, 28 Spline
29.17
29.17
1
Total for Braking System:
1,180.42
1,180.42
1,180.42
1,198.22
Percentage Summary:
98.51%
100.00%
17.80
1.49%
Total for Hamilton-Parts Depot:
Department: 20 Warehouse: HAM-3150 - HAM Consignment Stock 3150
Account Group: I10 - Electrical System
108120
Battery, 12 Volt 21 Plate
522.90
522.90
3
108150
Battery, 12 Volt 27 Plate
390.60
390.60
2
108200
Battery, 12 Volt 37 Plate
732.90
244.30
488.60
3
Total for Electrical System:
1,646.40
634.90
1,011.50
1,011.50
634.90
1,646.40
Percentage Summary:
38.56%
61.44%
100.00%
Total for HAM Consignment Stock 3150:
1,180.42
1,011.50
634.90
2,844.62
Percentage Summary:
22.32%
35.56%
41.50%
100.00%
17.80
0.63%
Total for department 20 - Hamilton Depot:
Page 1 of 1
Printed on 23 Nov 2009 at 10:15 AM