Raw Material Part Numbers

My recommendation would be as follows;



1. Devise a part numbering system that includes the Thickness x Width so in your example the part number could be CRBSTL00.250x05.000.

2. Setup the inventory unit of measure (IUM) to 1'.

3. Setup the item to be dimensionally tracked.

4. Setup the dimensional conversions as IUM / Length. So 1'/10' or .1.



This would allow you to issue (1) 10' sheet of CRBSTL00.250X05.000 to job XXXXXX-X-X. You could then return (1) 5' sheet of CRBSTL00.250x05.000 from that same job. However, this time the conversion would be IUM/Length = 1/5 = .2.



You can name your dimensions so when you look at your inventory for that part number you will see you have (1) 5' sheet on hand.



This works well within Time Phase too.



The other problem with issuing a different part could be solved to. For instance if you have (1) 10' sheet of .250" x 10" you know will work you can override the part number when issuing the material. Even if the job XXXXX-X-X calls out CRBSTL00.250x05.000, you can issue CRBSTL00.250x10.000 material against it. Furthermore, if you want to return a remnant the system will know it used the alternative part number, and allow you to return the remnant length.



We have operated with this setup for 6 years, and has worked great.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rachel Holton
Sent: Monday, March 12, 2007 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Raw Material Part Numbers



We are just now starting on our Vantage journey and have hit a roadblock
early on.

We are a manufacturing firm dealing in metal fabrication. We are having a
hard time deciding on how to set up our raw materials as parts. Plates are
our sticking point. For example we purchase ¼" carbon steel in several
plate sizes, for example 5' x 10' & 6' x 12'. We would like to be able to
track our whole sheets but would also like to keep track of drops that may
be ½ sheet or ¼ sheet sizes. The inventory unit of measure has to be square
feet since that is what is pulling from the bill of material. We would like
to be able to view our inventory in sheets by using conversion factors.
Ideally we want to look at one screen and know how many sheets we have of X
material. We don't want to look at total square feet and have to calculate
it.

Seeing the sheets available with the conversion factor only works if we have
a part number for each original sheet size with ½ sheets and such tracked as
dimensional data. This has led to a few obstacles. One main problem with
this is how the material is listed on the BOM. The BOM lists only ¼" plate,
what size sheet we will use for it varies. So the material in the
operations might be a dummy ¼" part number but when it was time to issue
material we'd sub the actual plate size being used.

We have also considered using one part number just for ¼" plate and tracked
all our sheet sizes as the dimensions. The problem with this seems to be
purchasing. We can't create a PO for our dimensional parts, so the sheet
size we would like to order does not get transmitted to the appropriate
parties and receiving is just as difficult.

Lastly we considered tracking our whole sheets as their own part numbers and
returning remnants to another part number. This won't work because if we
issue 3 sheets to a job and want to return a half sheet back, we can't
return the remnant to its own number since that number was not issued
initially.

I apologize if my explanation seems a bit confusing. I'm confused by it a
bit myself. I'm sure we don't operate in some weird way, so there must be
someone who has a similar situation. Are we overlooking the simple
solution? How do you handle raw materials in a similar situation? Any
suggestions would be greatly appreciated!

Rachel Holton

Accounting

Enviroflex Design & Mfg., Inc.

29639 FM 2978

Magnolia, TX 77354

P: (281) 356-6700

F: (281) 356-6772

www.enviroflexmfg.com

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





[Non-text portions of this message have been removed]
We are just now starting on our Vantage journey and have hit a roadblock
early on.



We are a manufacturing firm dealing in metal fabrication. We are having a
hard time deciding on how to set up our raw materials as parts. Plates are
our sticking point. For example we purchase ¼” carbon steel in several
plate sizes, for example 5Â’ x 10Â’ & 6Â’ x 12Â’. We would like to be able to
track our whole sheets but would also like to keep track of drops that may
be ½ sheet or ¼ sheet sizes. The inventory unit of measure has to be square
feet since that is what is pulling from the bill of material. We would like
to be able to view our inventory in sheets by using conversion factors.
Ideally we want to look at one screen and know how many sheets we have of X
material. We donÂ’t want to look at total square feet and have to calculate
it.



Seeing the sheets available with the conversion factor only works if we have
a part number for each original sheet size with ½ sheets and such tracked as
dimensional data. This has led to a few obstacles. One main problem with
this is how the material is listed on the BOM. The BOM lists only ¼” plate,
what size sheet we will use for it varies. So the material in the
operations might be a dummy ¼” part number but when it was time to issue
material weÂ’d sub the actual plate size being used.



We have also considered using one part number just for ¼” plate and tracked
all our sheet sizes as the dimensions. The problem with this seems to be
purchasing. We canÂ’t create a PO for our dimensional parts, so the sheet
size we would like to order does not get transmitted to the appropriate
parties and receiving is just as difficult.



Lastly we considered tracking our whole sheets as their own part numbers and
returning remnants to another part number. This wonÂ’t work because if we
issue 3 sheets to a job and want to return a half sheet back, we canÂ’t
return the remnant to its own number since that number was not issued
initially.



I apologize if my explanation seems a bit confusing. IÂ’m confused by it a
bit myself. IÂ’m sure we donÂ’t operate in some weird way, so there must be
someone who has a similar situation. Are we overlooking the simple
solution? How do you handle raw materials in a similar situation? Any
suggestions would be greatly appreciated!



Rachel Holton

Accounting



Enviroflex Design & Mfg., Inc.

29639 FM 2978

Magnolia, TX 77354

P: (281) 356-6700

F: (281) 356-6772

www.enviroflexmfg.com







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



V8 I assume? We have similar challenges with rolls and their widths. We use Dimension tracking and it provides exactly what you describe. You can stock in one UOM and view all the various sizes in another.



Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rachel Holton
Sent: Monday, March 12, 2007 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Raw Material Part Numbers



We are just now starting on our Vantage journey and have hit a roadblock
early on.

We are a manufacturing firm dealing in metal fabrication. We are having a
hard time deciding on how to set up our raw materials as parts. Plates are
our sticking point. For example we purchase ¼" carbon steel in several
plate sizes, for example 5' x 10' & 6' x 12'. We would like to be able to
track our whole sheets but would also like to keep track of drops that may
be ½ sheet or ¼ sheet sizes. The inventory unit of measure has to be square
feet since that is what is pulling from the bill of material. We would like
to be able to view our inventory in sheets by using conversion factors.
Ideally we want to look at one screen and know how many sheets we have of X
material. We don't want to look at total square feet and have to calculate
it.

Seeing the sheets available with the conversion factor only works if we have
a part number for each original sheet size with ½ sheets and such tracked as
dimensional data. This has led to a few obstacles. One main problem with
this is how the material is listed on the BOM. The BOM lists only ¼" plate,
what size sheet we will use for it varies. So the material in the
operations might be a dummy ¼" part number but when it was time to issue
material we'd sub the actual plate size being used.

We have also considered using one part number just for ¼" plate and tracked
all our sheet sizes as the dimensions. The problem with this seems to be
purchasing. We can't create a PO for our dimensional parts, so the sheet
size we would like to order does not get transmitted to the appropriate
parties and receiving is just as difficult.

Lastly we considered tracking our whole sheets as their own part numbers and
returning remnants to another part number. This won't work because if we
issue 3 sheets to a job and want to return a half sheet back, we can't
return the remnant to its own number since that number was not issued
initially.

I apologize if my explanation seems a bit confusing. I'm confused by it a
bit myself. I'm sure we don't operate in some weird way, so there must be
someone who has a similar situation. Are we overlooking the simple
solution? How do you handle raw materials in a similar situation? Any
suggestions would be greatly appreciated!

Rachel Holton

Accounting

Enviroflex Design & Mfg., Inc.

29639 FM 2978

Magnolia, TX 77354

P: (281) 356-6700

F: (281) 356-6772

www.enviroflexmfg.com

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





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
How do you handle purchasing?

--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Rachel,
>
>
>
> V8 I assume? We have similar challenges with rolls and their
widths. We use Dimension tracking and it provides exactly what you
describe. You can stock in one UOM and view all the various sizes in
another.
>
>
>
> Todd
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Rachel Holton
> Sent: Monday, March 12, 2007 12:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Raw Material Part Numbers
>
>
>
> We are just now starting on our Vantage journey and have hit a
roadblock
> early on.
>
> We are a manufacturing firm dealing in metal fabrication. We are
having a
> hard time deciding on how to set up our raw materials as parts.
Plates are
> our sticking point. For example we purchase ¼" carbon steel in
several
> plate sizes, for example 5' x 10' & 6' x 12'. We would like to be
able to
> track our whole sheets but would also like to keep track of drops
that may
> be ½ sheet or ¼ sheet sizes. The inventory unit of measure has to
be square
> feet since that is what is pulling from the bill of material. We
would like
> to be able to view our inventory in sheets by using conversion
factors.
> Ideally we want to look at one screen and know how many sheets we
have of X
> material. We don't want to look at total square feet and have to
calculate
> it.
>
> Seeing the sheets available with the conversion factor only works
if we have
> a part number for each original sheet size with ½ sheets and such
tracked as
> dimensional data. This has led to a few obstacles. One main
problem with
> this is how the material is listed on the BOM. The BOM lists only
¼" plate,
> what size sheet we will use for it varies. So the material in the
> operations might be a dummy ¼" part number but when it was time to
issue
> material we'd sub the actual plate size being used.
>
> We have also considered using one part number just for ¼" plate
and tracked
> all our sheet sizes as the dimensions. The problem with this seems
to be
> purchasing. We can't create a PO for our dimensional parts, so the
sheet
> size we would like to order does not get transmitted to the
appropriate
> parties and receiving is just as difficult.
>
> Lastly we considered tracking our whole sheets as their own part
numbers and
> returning remnants to another part number. This won't work because
if we
> issue 3 sheets to a job and want to return a half sheet back, we
can't
> return the remnant to its own number since that number was not
issued
> initially.
>
> I apologize if my explanation seems a bit confusing. I'm confused
by it a
> bit myself. I'm sure we don't operate in some weird way, so there
must be
> someone who has a similar situation. Are we overlooking the simple
> solution? How do you handle raw materials in a similar situation?
Any
> suggestions would be greatly appreciated!
>
> Rachel Holton
>
> Accounting
>
> Enviroflex Design & Mfg., Inc.
>
> 29639 FM 2978
>
> Magnolia, TX 77354
>
> P: (281) 356-6700
>
> F: (281) 356-6772
>
> www.enviroflexmfg.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> This e-mail and any attachments may contain confidential and
privileged
> information. If you are not the intended recipient, please notify
the
> sender immediately by return e-mail, delete this e-mail and
destroy any
> copies. Any dissemination or use of this information by a person
other
> than the intended recipient is unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>