TCSWhseAged
ACME TRUCK SERVICING LTD
Summary 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 LIFO, analysed by monthly periods, ordered by account group
Total
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Description
Group
6 Periods
Department: 10 Warehouse: MAIN - Main-Parts Warehouse
8,093.13
209.60
158.30
445.80
409.50
553.20
471.30
5,845.43
I10 - Electrical System
9,167.29
622.82
839.91
7,704.56
I11 - Engine Servicing
7,303.70
3,203.36
239.00
3,861.34
I12 - Exhaust System
67,405.67
2,996.41
13,367.78
47,410.94
2,201.50
1,429.04
I14 - Braking System
3,610.55
562.50
589.59
389.46
1,079.00
990.00
I16 - Minor Components
2,672.80
47,964.14
15,095.28
1,675.17
4,367.12
3,975.46
95,580.34
Percentage Summary:
4.16%
4.57%
1.75%
2.80%
50.18%
15.79%
100.00%
19,830.37
20.75%
Total for Main-Parts Warehouse:
Department: 10 Warehouse: MAIN-3150 - MAIN Consignment Stock 3150
1,423.10
244.30
1,178.80
I10 - Electrical System
244.30
1,423.10
Percentage Summary:
17.17%
100.00%
1,178.80
82.83%
Total for MAIN Consignment Stock 3150:
Department: 10 Warehouse: MAIN-X - Main-Core Returns
1,100.00
100.00
1,000.00
I16 - Minor Components
100.00
1,100.00
Percentage Summary:
9.09%
100.00%
1,000.00
90.91%
Total for Main-Core Returns:
2,672.80
48,208.44
15,195.28
1,675.17
4,367.12
3,975.46
98,103.44
Percentage Summary:
4.05%
4.45%
1.71%
2.72%
49.14%
15.49%
100.00%
22,009.17
22.43%
Total for department 10 - Parts Department:
Page 1 of 1
Printed on 23 Nov 2009 at 10:24 AM
TCSWhseAged
ACME TRUCK SERVICING LTD
Summary 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 LIFO, analysed by monthly periods, ordered by account group
Total
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Description
Group
6 Periods
Department: 20 Warehouse: HAM - Hamilton-Parts Depot
2.10
1.40
0.70
I10 - Electrical System
15.70
15.70
I11 - Engine Servicing
1,180.42
637.02
180.02
363.38
I14 - Braking System
180.02
637.72
1.40
1,198.22
Percentage Summary:
0.12%
15.02%
53.22%
100.00%
379.08
31.64%
Total for Hamilton-Parts Depot:
Department: 20 Warehouse: HAM-3150 - HAM Consignment Stock 3150
1,646.40
1,646.40
I10 - Electrical System
1,646.40
1,646.40
Percentage Summary:
100.00%
100.00%
Total for HAM Consignment Stock 3150:
180.02
637.72
1.40
1,646.40
2,844.62
Percentage Summary:
57.88%
0.05%
6.33%
22.42%
100.00%
379.08
13.33%
Total for department 20 - Hamilton Depot:
Page 1 of 1
Printed on 23 Nov 2009 at 10:24 AM
TCSWhseAged
ACME TRUCK SERVICING LTD
Consolidated 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
Warehouse codes
HAM, HAM-3150, MAIN, MAIN-3150, MAIN-X
Report basis LIFO, analysed by monthly periods, ordered by account group
Total
1 Period
2 Periods
3 Periods
4 Periods
5 Periods
7 Periods Plus
Description
Group
6 Periods
11,164.73
1,856.00
158.30
447.20
410.20
797.50
471.30
7,024.23
I10 - Electrical System
9,182.99
622.82
839.91
7,720.26
I11 - Engine Servicing
7,303.70
3,203.36
239.00
3,861.34
I12 - Exhaust System
68,586.09
2,996.41
14,004.80
47,590.96
2,201.50
1,792.42
I14 - Braking System
4,710.55
562.50
589.59
389.46
1,179.00
1,990.00
I16 - Minor Components
2,672.80
48,388.46
15,833.00
1,676.57
4,367.12
5,621.86
100,948.06
Percentage Summary:
5.57%
4.33%
1.66%
2.65%
47.93%
15.68%
100.00%
22,388.25
22.18%
Total:
Page 1 of 1
Printed on 23 Nov 2009 at 10:24 AM