Raw material part numbers

We also buy a wide variety of materials which may be to multiple
specs (6061 could be bought to ASTM, Federal or Military
specifications). What we came up with for a numbering system is as
follows:
6 digit UNS material designation (A96061 for 6061 aluminum)
2 digit form designator (RD for round, FL for flat bar, PL for
plate...)
Up to 8 digit decimal size designator (1.50, .25X1.00, decimals
rounded to two places)
Finally, a dash alpha (-A, -B) deisgnator to differentiate between
specifications.
Our resulting part number for 1.5" dia 6061 to ASTM-B211 could
be "A96061 RD 1.50 -A, whereas a piece of 1/4" X 1" rectangular bar
to QQ-A-200/8 could be A96061 FL .25X1.00-A.
For the majority of situations, this system has worked very well for
us. Hope this helps.

John Elder
Penn State Tool & Die

--- In vantage@y..., "Diane Rowberry" <diane.rowberry@w...> wrote:
> Hello Groupies,
>
> I am looking for some advice. WPI has identified a need to change
our current method of idenitifying some of the raw materials in our
part master.
We have found that for some of our stock is not defined well enough
in the part number. For example, we use alot of 6061-T6 aluminum in
many different sizes and flavors. I have a part number 6061-T6 1
1/2R for 1 1/2" diameter aluminum rod, but within that part number I
might have purchased some with a 200/8 spec (extruded) and some with
a 225/8 spec (cold drawn).
Most of my customer drawings will call for one or the other and in
our system they are both stored under the same part number so the
only way to know for sure what we have is to go back to the purchase
order. Thank goodness we started including the purchase order number
in the lot number!
I see our biggest problem is the 20 space/character limit of the
part number field. I would like to get an idea from the people in
the group that work with the same sorts of issues - what do you do?
How do you number your raw materials inventory? I thought I
remembered some chatter on the list about this awhile ago, but could
not find it in the archives. Any ideas would be greatly appreciated -
off list is ok unless anyone else is battling the same issue. TIA
>
> Diane Rowberry
> Westwood Precision, Inc.
> (425) 742-7011 ex 43
> (425) 353-8945 Fax
> diane.rowberry@w...
> www.westwoodprecision.com
Hello Groupies,

I am looking for some advice. WPI has identified a need to change our
current method of idenitifying some of the raw materials in our part master.
We have found that for some of our stock is not defined well enough in the
part number. For example, we use alot of 6061-T6 aluminum in many different
sizes and flavors. I have a part number 6061-T6 1 1/2R for 1 1/2" diameter
aluminum rod, but within that part number I might have purchased some with a
200/8 spec (extruded) and some with a 225/8 spec (cold drawn). Most of my
customer drawings will call for one or the other and in our system they are
both stored under the same part number so the only way to know for sure what
we have is to go back to the purchase order. Thank goodness we started
including the purchase order number in the lot number!
I see our biggest problem is the 20 space/character limit of the part number
field. I would like to get an idea from the people in the group that work
with the same sorts of issues - what do you do? How do you number your raw
materials inventory? I thought I remembered some chatter on the list about
this awhile ago, but could not find it in the archives. Any ideas would be
greatly appreciated - off list is ok unless anyone else is battling the same
issue. TIA

Diane Rowberry
Westwood Precision, Inc.
(425) 742-7011 ex 43
(425) 353-8945 Fax
diane.rowberry@...
www.westwoodprecision.com
We use a lot of different sizes and types of tubing. We've tried to make our tubing part numbers descriptive.
An example: 1250X065EEA24000
Where 1250 represents a 1.25" OD tube and 065 is .065" wall thickness, EEA represents a material type, and 24000 is a 240.00" long piece. We've left out the decimal places to conserve space. This works with about 95% of our tubing inventory.


John Rodewald
Sr. CAD Engineer
National Tube Form
A Leggett & Platt Company
Phone: (260) 478-2363 ext. 205
Cell: (260) 348-4891
Fax: (260) 478-1043
<mailto:John.Rodewald@...> John.Rodewald@...

-----Original Message-----
From: Diane Rowberry [mailto:diane.rowberry@...]
Sent: Tuesday, November 19, 2002 3:57 PM
To: vantage@yahoogroups.com
Subject: [vantage] Raw material part numbers

Hello Groupies,

I am looking for some advice. WPI has identified a need to change our
current method of idenitifying some of the raw materials in our part master.
We have found that for some of our stock is not defined well enough in the
part number. For example, we use alot of 6061-T6 aluminum in many different
sizes and flavors. I have a part number 6061-T6 1 1/2R for 1 1/2" diameter
aluminum rod, but within that part number I might have purchased some with a
200/8 spec (extruded) and some with a 225/8 spec (cold drawn). Most of my
customer drawings will call for one or the other and in our system they are
both stored under the same part number so the only way to know for sure what
we have is to go back to the purchase order. Thank goodness we started
including the purchase order number in the lot number!
I see our biggest problem is the 20 space/character limit of the part number
field. I would like to get an idea from the people in the group that work
with the same sorts of issues - what do you do? How do you number your raw
materials inventory? I thought I remembered some chatter on the list about
this awhile ago, but could not find it in the archives. Any ideas would be
greatly appreciated - off list is ok unless anyone else is battling the same
issue. TIA

Diane Rowberry
Westwood Precision, Inc.
(425) 742-7011 ex 43
(425) 353-8945 Fax
diane.rowberry@...
www.westwoodprecision.com





Yahoo! Groups Sponsor


ADVERTISEMENT
<http://rd.yahoo.com/M=240188.2647639.4038785.2225243/D=egroupweb/S=1705007183:HM/A=1321406/R=0/*http://www.e-dealsdaily.com/soundbug/>

<http://us.adserver.yahoo.com/l?M=240188.2647639.4038785.2225243/D=egroupmail/S=:HM/A=1321406/rand=809411245>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
I've fought against descriptive part numbers tooth and nail. Descriptive
part numbers are a disaster waiting to happen. We have hundreds of
different flavors of polymer types. Every numbering system in our company
is defined in procedure and described. In a nut shell we format our numbers
like this XX-XXXXX-XX. The middle five digits are the primary identifier,
the 2 digit Prefix allows to to group broad categories, the 2 digit suffix
helps you identify minor sub groups. We reserve blocks of numbers for
specific purposes. 00-10000-00 to 00-39000-00 are for manufactured
products, 00-40000-00 are for Raw Materials, 00-50000-00 to 00-59999-00 are
for sundry purchased items. If you assume there are 99 numbers and 26
letters available for the Prefix and the same for the suffix and 99999
numbers for the primary identifier, you will never run out of numbers. Plus
there is the advantage of consistency and predictability for use in reports.
Then we use the description line for other descriptive searches. I have our
numbering systems procedure in pdf. If anyone is interested contact me off
list.

Shirley Graver


-----Original Message-----
From: John Rodewald [mailto:john.rodewald@...]
Sent: Tuesday, November 19, 2002 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [vantage] Raw material part numbers

We use a lot of different sizes and types of tubing. We've tried to make
our tubing part numbers descriptive.
An example: 1250X065EEA24000
Where 1250 represents a 1.25" OD tube and 065 is .065" wall thickness, EEA
represents a material type, and 24000 is a 240.00" long piece. We've left
out the decimal places to conserve space. This works with about 95% of our
tubing inventory.


! ;
John Rodewald
Sr. CAD Engineer
National Tube Form
A Leggett & Platt Company
Phone: (260) 478-2363 ext. 205
Cell: (260) 348-4891
Fax: (260) 478-1043
<mailto:John.Rodewald@...> John.Rodewald@...

-----Original Message-----
From: Diane Rowberry [mailto:diane.rowberry@...]
Sent: Tuesday, November 19, 2002 3:57 PM
To: vantage@yahoogroups.com
Subject: [vantage] Raw material part numbers

Hello Groupies,

I am looking for some advice. WPI has identified a need to change our
current method of idenitifying some of the raw materials in our part master.
We have found that for some of our stock is not defined well enough in the
part number. For example, we use alot of 6061-T6 aluminum in many different
sizes and flavors. I have a part number 6061-T6 1 1/2R for 1 1/2" diameter
aluminum rod, but within that part number I might have purchased some with a
200/8 spec (extruded) and some with a 225/8 spec (cold drawn). Most of my
customer drawings will call for one or the other and in our system they are
both stored under the same part number so the only way to know for sure what
we have is to go back to the purchase order. Thank goodness we started
including the purchase order number in the lot number!
I see our biggest problem is the 20 space/character limit of the part number
field. I would like to get an idea from the people in the group that work
with the same sorts of issues - what do you do? How do you number your raw
materials inventory? I thought I remembered some chatter on the list about
this awhile ago, but could not find it in the archives. Any ideas would be
greatly appreciated - off list is ok unless anyone else is battling the same
issue. TIA

Diane Rowberry
Westwood Precision, Inc.
(425) 742-7011 ex 43
(425) 353-8945 Fax
diane.rowberry@...
www.westwoodprecision.com





Yahoo! Groups Sponsor


ADVERTISEMENT
<
http://rd.yahoo.com/M=240188.2647639.4038785.2225243/D=egroupweb/S=170500718
3:HM/A=1321406/R=0/*http://www.e-dealsdaily.com/soundbug/>

<
http://us.adserver.yahoo.com/l?M=240188.2647639.4038785.2225243/D=egroupmail
/S=:HM/A=1321406/rand=809411245>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! <
http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]




Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=240188.2647639.4038785.2225243/D=egroupweb/S=17050071
83:HM/A=1321406/R=0/*http://www.e-dealsdaily.com/soundbug/>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]