TCSWhseMaxLvlReview
Account
ACME TRUCK SERVICING LTD
Maximum Stock Level Review as at 28 Feb 2003
From first group to last group,  from first account to last account,  ordered by account group
Warehouse code  HAM
For all warehouses,  all items,  sales history analysed by monthly periods
Account Name
Unit
Min
Max
Pro
Recommended stock levels based on 6 months sales,  1 months minimum cover,  2 months maximum cover
Feb
Jan
Dec
Nov
Oct
Sep
Current Levels
Sales
Sales
Annual
Base
Recommend
Min
Max
Min
Max
Account Group: I12  -  Exhaust System
Exhaust Tubing, 3"
Foot
25
5
4
16
8
10
122103
10
59
43
7
14
Yes
Exhaust Tubing, 4"
Foot
25
4
4
14
8
122104
10
30
30
5
10
Yes
Exhaust Tubing, 5"
Foot
25
3
8
122105
10
15
11
2
4
Yes
Exhaust Clamp, 3"
Each
8
4
2
2
6
4
122203
4
21
18
3
6
Exhaust Clamp, 4"
Each
8
2
2
2
2
122204
4
8
8
1
3
Exhaust Clamp, 5"
Each
8
2
2
122205
4
6
4
1
1
Account Group: I14  -  Braking System
Brake Drum, 15", 3 Spoke
Each
5
3
3
1
2
141605
2
11
9
2
3
Brake Drum, 16", 5 Spoke
Each
5
1
2
141607
2
5
3
1
1
Brake Lining Set, COF 0.36
Each
10
1
2
4
2
5
142312
5
21
14
2
5
Yes
Service Chamber, Type 20
Each
10
4
2
2
2
2
143320
5
14
12
2
4
Service Chamber, Type 24
Each
10
3
4
2
3
143324
5
14
12
2
4
Service Chamber, Type 30
Each
10
3
2
4
2
143330
5
13
11
2
4
Slack Adjuster, 10 Spline
Each
5
2
2
1
2
145710A
2
7
7
**Supersession**
Slack Adjuster, 10 Spline
Each
4
2
2
3
2
145710
2
12
9
***Superseded***
Slack Adjuster, 10 Spline
Each
5
2
2
3
4
3
2
145710A
2
19
16
3
5
Slack Adjuster, 28 Spline
Each
5
3
2
2
1
145728A
2
8
8
**Supersession**
Slack Adjuster, 28 Spline
Each
4
2
2
1
145728
2
9
5
***Superseded***
Slack Adjuster, 28 Spline
Each
5
3
2
4
3
1
145728A
2
17
13
2
4
Page 1 of 1
Printed on 17 Mar 2003 at 03:59 PM

TCSWhseMaxLvlReview
Account
ACME TRUCK SERVICING LTD
Maximum Stock Level Review as at 28 Feb 2003
From first group to last group,  from first account to last account,  ordered by account group
Warehouse code  MAIN
For all warehouses,  all items,  sales history analysed by monthly periods
Account Name
Unit
Min
Max
Pro
Recommended stock levels based on 6 months sales,  1 months minimum cover,  2 months maximum cover
Feb
Jan
Dec
Nov
Oct
Sep
Current Levels
Sales
Sales
Annual
Base
Recommend
Min
Max
Min
Max
Account Group: I10  -  Electrical System
Lamp, L/Range Driving 12V 55W
Each
10
4
6
4
10
100805
5
24
24
4
8
Lamp, L/Range Driving 12V 100W
Each
10
5
4
6
2
8
100810
5
25
25
4
8
Headlamp Insert, Inner, Q/H
Each
10
6
3
2
3
4
101691
5
18
18
3
6
Headlamp Insert, Outer, Q/H
Each
10
4
3
3
2
5
101692
5
19
17
3
6
Lamp, Cab Marker, Clear
Each
10
3
5
2
103100
6
10
10
2
3
Lamp, Cab Marker, Amber
Each
10
5
4
2
5
103104
6
18
16
3
5
Lamp, Cab Marker, Red
Each
10
4
7
3
4
103105
6
20
18
3
6
Bulb 24V, Licence Plate
Each
5
5
1
2
103207
3
8
8
1
3
Bulb 12V 55W, Q/H
Each
12
8
10
2
4
2
5
105205
8
38
31
5
10
Bulb 12V 100W, Q/H
Each
15
8
7
3
2
4
3
105210
10
36
27
5
9
Bulb 24V 70W, Q/H
Each
12
9
1
2
1
2
4
105407
8
28
19
3
6
Bulb 24V 100W, Q/H
Each
15
8
1
3
2
3
2
105410
10
28
19
3
6
Battery, 12 Volt 21 Plate
Each
10
5
4
3
2
5
3
108120
6
33
22
4
7
Battery, 12 Volt 27 Plate
Each
10
9
3
2
3
4
2
108150
6
31
23
4
8
Battery, 12 Volt 37 Plate
Each
10
5
4
3
2
2
3
108200
6
28
19
3
6
Fuse 5A, Blade
Each
10
11
7
6
2
6
108701
5
32
32
5
11
Fuse 7.5A, Blade
Each
10
9
7
5
2
7
108702
5
30
30
5
10
Fuse 20A, Blade
Each
10
8
5
5
2
4
108705
5
24
24
4
8
Fuse 25A, Blade
Each
10
6
5
4
3
108706
5
18
18
3
6
Fuse 30A, Blade
Each
10
6
4
2
3
108707
5
15
15
3
5
Account Group: I11  -  Engine Servicing
Oil Filter, Detroit 8.2
Each
15
8
4
2
114151
10
14
14
2
5
Oil Filter, Perkins
Each
15
6
3
4
114152
10
13
13
2
4
Fuel Filter, Detroit 8.2
Each
15
7
4
4
117151
10
15
15
3
5
Fuel Filter, Perkins
Each
15
9
3
3
117152
10
15
15
3
5
Account Group: I12  -  Exhaust System
Exhaust Tubing, 3"
Foot
50
59
10
8
12
18
122103
30
165
107
18
36
Exhaust Tubing, 4"
Foot
50
51
17
20
26
20
24
122104
30
202
158
26
53
Exhaust Tubing, 5"
Foot
50
40
20
20
16
28
122105
30
158
124
21
41
Exhaust Clamp, 3"
Each
15
16
2
2
4
122203
10
36
24
4
8
Exhaust Clamp, 4"
Each
15
12
2
6
6
4
6
122204
10
48
36
6
12
Exhaust Clamp, 5"
Each
15
10
4
4
4
7
122205
10
40
29
5
10
Page 1 of 2
Printed on 17 Mar 2003 at 03:59 PM

TCSWhseMaxLvlReview
Account
ACME TRUCK SERVICING LTD
Maximum Stock Level Review as at 28 Feb 2003
From first group to last group,  from first account to last account,  ordered by account group
Warehouse code  MAIN
For all warehouses,  all items,  sales history analysed by monthly periods
Account Name
Unit
Min
Max
Pro
Recommended stock levels based on 6 months sales,  1 months minimum cover,  2 months maximum cover
Feb
Jan
Dec
Nov
Oct
Sep
Current Levels
Sales
Sales
Annual
Base
Recommend
Min
Max
Min
Max
Account Group: I14  -  Braking System
Brake Drum, 15", 3 Spoke
Each
10
3
1
4
5
7
4
141605
5
29
24
4
8
Yes
Brake Drum, 16", 5 Spoke
Each
10
4
1
2
5
7
3
141607
5
27
22
4
7
Yes
Brake Lining Set, COF 0.36
Each
20
12
6
9
14
12
8
142312
10
83
61
10
20
Yes
Service Chamber, Type 20
Each
10
6
2
1
6
8
4
143320
5
39
27
5
9
Yes
Service Chamber, Type 24
Each
10
8
5
2
11
6
2
143324
5
42
34
6
11
Yes
Service Chamber, Type 30
Each
10
6
4
2
6
8
5
143330
5
41
31
5
10
Yes
Slack Adjuster, 10 Spline
Each
8
6
3
145710A
4
9
9
**Supersession**
Slack Adjuster, 10 Spline
Each
6
3
4
4
4
145710
2
22
15
***Superseded***
Slack Adjuster, 10 Spline
Each
8
6
3
3
4
4
4
145710A
4
31
24
4
8
Slack Adjuster, 28 Spline
Each
10
4
2
145728A
5
6
6
**Supersession**
Slack Adjuster, 28 Spline
Each
8
4
3
4
3
145728
4
21
14
***Superseded***
Slack Adjuster, 28 Spline
Each
10
4
2
4
3
4
3
145728A
5
27
20
3
7
Account Group: I19  -  Major Components
Detroit 8.2 Engine (Re-manf)
Each
1
3
1
197151
1
4
4
1
1
Yes
Page 2 of 2
Printed on 17 Mar 2003 at 03:59 PM