Managing raw material lengths

Yahoo Archive
1
In 9.04, you can create separate UOM's off the base.

An example would be bar stock where the base would be feet or inch and
the other UOM's would be multiples of the base. You can then use a 12'
bar using a UOM of 12FT and return to stock from the job a 4FT piece.
The BASE UOM would be 1FT with another UOM from that same UOM Class.



UOM Class: Length

UOM's:

UOM Code

Description

1 UOM

Operator

Conversion Factor

Base Equivalent

Base UOM

Default UOM

Part Specific

Active

FT

Feet

1 FT

*

1

= 1 FT

True

False

False

True

IN

Inch

1 IN

*

0.0245

= .0245 FT

False

False

False

True

M

Meter

1 M

*

3.2808399

= 3.2808399 FT

False

False

False

True

YD

Yard

1 YD

*

3

= 3 FT

False

False

False

True

12FT

12 foot Lengths (Full Bar)

1 12FT

*

12.0000000

= 12 FT

False

True

False

True

4FT

4 foot Lengths

1 4FT

*

4

= 4 FT

False

False

False

True





Charlie Smith

2W Technologies LLC

www.2WTech.com <http://www.2WTech.com>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Freeman
Sent: Monday, March 15, 2010 3:45 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Managing raw material lengths





Bruce, when you're saying dimensional inventory are you referring to a
concept or something that is available in 9.04?

We're in a similar situation. We have pieces of exotic material that we
don't want to scrap. Vantage may show you how many square inches of a
material you have but does the size of the material enable you to make
the part for the customer?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Butler, Bruce
Sent: Monday, March 15, 2010 12:28 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Managing raw material lengths

From a costing perspective I subscribe to the theory the unusable
material is a consequence of the job therefore should be treated as a
job cost.

I would highly recommend using dimensional inventory. As a general
rule, I would recommend stocking in 1' increments always rounding down.
As another general rule, I would not stock under a 3' remnant unless it
is valuable material.

I would recommend not using additional part numbers especially if you
use engineering methods. The engineering methods will not know about
the new part numbers. When the job is created purchasing will get a
requirement to purchase the full quantity based on the older part number
in engineering.

Sample situation:

12' of material issued to job. 6' cut. Return 6' length as dimensional
length.

I would also advise not using lot numbers. They do not tell the system
anything about the actual quantity. They can further complicate the
issue if you do decide to use dimensional inventory. For every
dimension you stock you would need to reference a lot number. This
could get really cumbersome if you routinely have many lengths from many
lots used on a single job.

Aerospace & government contract machining generally requires heat number
tracking of source materials for DFARs compliance and material
composition tracability. For those reasons lot tracking may be an
additional burden of doing business.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Managing raw material lengths

Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry

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

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





[Non-text portions of this message have been removed]
2
Hello all. This is not a Vantage question per say but I thought I could get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in feet in Vantage. When part of a length is used, the remainder is kept in inventory. However, the left over cuts are often too short to be used in many jobs. This can mislead our purchasing agent, he may see 200 feet of a partular raw material in stock but it could be in lengths too short to use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one for each foot length. I'm curious what others are doing to manage this type of scenerio.

Any advice would be appreciated.

Gerry
3
In V6-V8 you can use dimensional inventories. In E9, you can use the
UOMs and keep it as a different UOM. Such as 12FT, 6FT and 1.5FT.

Determine what your minimum length is and start from there. Anything
below that length you can scrap or keep off the books and use as needed
at $0 cost.



Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 10:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Managing raw material lengths





Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry





[Non-text portions of this message have been removed]
4
We have similar situation, and so we set the material to be lot tracked, and then use lot numbers for each distinct bar.










________________________________
From: schmangy20000 <gloranger@...>
To: vantage@yahoogroups.com
Sent: Mon, March 15, 2010 9:32:07 AM
Subject: [Vantage] Managing raw material lengths


Hello all. This is not a Vantage question per say but I thought I could get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in feet in Vantage. When part of a length is used, the remainder is kept in inventory. However, the left over cuts are often too short to be used in many jobs. This can mislead our purchasing agent, he may see 200 feet of a partular raw material in stock but it could be in lengths too short to use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one for each foot length. I'm curious what others are doing to manage this type of scenerio.

Any advice would be appreciated.

Gerry







[Non-text portions of this message have been removed]
5
Not sure if this would help and we don't particularly use it but maybe
we should, but what about salvage / scrap material?



On each job, per the part material, you can enter a scrap amount and I
think that should take it out of inventory....not sure if it actually
takes it out, but you could play with it in a test environment and see
if that would work.



Then you are not over populating your db with a bunch of goofy part
numbers.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Managing raw material lengths





Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry





[Non-text portions of this message have been removed]
6
On round (typically used in bar feeders) we lot size in multiples of pc/bar yields (or for low activity parts - at least TRY for no less than 1/2 bar yield qty's & attempt to sequence jobs to minimize need to yank partial bars & change collets: 'wheel' family scheduling to reduce setups).

On mill processed products (rectangular bar that requires pre CNC saw cut for vise or tombstone work), it is less of an issue (although we do tend to try & produce in multiples of bar yields if use rates justify it).

In both cases, our operators know when left over shorts are useless lengths so we report labor scrap to consume in WIP.

Bigger problem we've found is (405a) PO entry often doesn't pull in PUM (lbs) IUM (ft) and/or coversion factor so receipts occasionally slip thru that (significantly) throw of inventory o/h.

$h!t catcher reports run every once in a while catch these (and odd - less than full bar o/h's) and can be used to trigger cycle counts.

Rob

--- Original Message ---
From:"schmangy20000" <gloranger@...>
Sent:Mon 3/15/10 10:41 am
To:vantage@yahoogroups.com
Subj:[Vantage] Managing raw material lengths

Hello all. This is not a Vantage question per say but I thought I could get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in feet in Vantage. When part of a length is used, the remainder is kept in inventory. However, the left over cuts are often too short to be used in many jobs. This can mislead our purchasing agent, he may see 200 feet of a partular raw material in stock but it could be in lengths too short to use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one for each foot length. I'm curious what others are doing to manage this type of scenerio.

Any advice would be appreciated.

Gerry
7
That's my concern, I don't want goofy part numbers either. But I can't scrap
pieces that are still long enough to be used in some jobs. And we back
flush, so using Lot Tracking or Track Dimensions is not an option.



Unfortunately, it would appear as though I have to create more part numbers.




Gerry



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Monday, March 15, 2010 11:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Managing raw material lengths





Not sure if this would help and we don't particularly use it but maybe
we should, but what about salvage / scrap material?

On each job, per the part material, you can enter a scrap amount and I
think that should take it out of inventory....not sure if it actually
takes it out, but you could play with it in a test environment and see
if that would work.

Then you are not over populating your db with a bunch of goofy part
numbers.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Managing raw material lengths

Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry

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





[Non-text portions of this message have been removed]
8
Will you ALWAYS have some amount left over from a job that can still be
used?



In that case I can understand. But what about the other jobs? I know
we have some parts this would probably work really well, but I agree,
there are definitely some where it could not work out.



We backflush as well, which is why I have not really gone down this road
yet, but I guess now is better than never.







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerry Loranger
Sent: Monday, March 15, 2010 11:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Managing raw material lengths





That's my concern, I don't want goofy part numbers either. But I can't
scrap
pieces that are still long enough to be used in some jobs. And we back
flush, so using Lot Tracking or Track Dimensions is not an option.

Unfortunately, it would appear as though I have to create more part
numbers.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Monday, March 15, 2010 11:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Managing raw material lengths

Not sure if this would help and we don't particularly use it but maybe
we should, but what about salvage / scrap material?

On each job, per the part material, you can enter a scrap amount and I
think that should take it out of inventory....not sure if it actually
takes it out, but you could play with it in a test environment and see
if that would work.

Then you are not over populating your db with a bunch of goofy part
numbers.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Managing raw material lengths

Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry

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

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





[Non-text portions of this message have been removed]
9
From a costing perspective I subscribe to the theory the unusable
material is a consequence of the job therefore should be treated as a
job cost.



I would highly recommend using dimensional inventory. As a general
rule, I would recommend stocking in 1' increments always rounding down.
As another general rule, I would not stock under a 3' remnant unless it
is valuable material.



I would recommend not using additional part numbers especially if you
use engineering methods. The engineering methods will not know about
the new part numbers. When the job is created purchasing will get a
requirement to purchase the full quantity based on the older part number
in engineering.



Sample situation:



12' of material issued to job. 6' cut. Return 6' length as dimensional
length.



I would also advise not using lot numbers. They do not tell the system
anything about the actual quantity. They can further complicate the
issue if you do decide to use dimensional inventory. For every
dimension you stock you would need to reference a lot number. This
could get really cumbersome if you routinely have many lengths from many
lots used on a single job.


Aerospace & government contract machining generally requires heat number
tracking of source materials for DFARs compliance and material
composition tracability. For those reasons lot tracking may be an
additional burden of doing business.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Managing raw material lengths





Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry





[Non-text portions of this message have been removed]
10
Bruce, when you're saying dimensional inventory are you referring to a concept or something that is available in 9.04?

We're in a similar situation. We have pieces of exotic material that we don't want to scrap. Vantage may show you how many square inches of a material you have but does the size of the material enable you to make the part for the customer?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Butler, Bruce
Sent: Monday, March 15, 2010 12:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Managing raw material lengths



From a costing perspective I subscribe to the theory the unusable
material is a consequence of the job therefore should be treated as a
job cost.

I would highly recommend using dimensional inventory. As a general
rule, I would recommend stocking in 1' increments always rounding down.
As another general rule, I would not stock under a 3' remnant unless it
is valuable material.

I would recommend not using additional part numbers especially if you
use engineering methods. The engineering methods will not know about
the new part numbers. When the job is created purchasing will get a
requirement to purchase the full quantity based on the older part number
in engineering.

Sample situation:

12' of material issued to job. 6' cut. Return 6' length as dimensional
length.

I would also advise not using lot numbers. They do not tell the system
anything about the actual quantity. They can further complicate the
issue if you do decide to use dimensional inventory. For every
dimension you stock you would need to reference a lot number. This
could get really cumbersome if you routinely have many lengths from many
lots used on a single job.

Aerospace & government contract machining generally requires heat number
tracking of source materials for DFARs compliance and material
composition tracability. For those reasons lot tracking may be an
additional burden of doing business.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of schmangy20000
Sent: Monday, March 15, 2010 9:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Managing raw material lengths

Hello all. This is not a Vantage question per say but I thought I could
get some advice on the topic.

We buy a number of raw materials in lengths. We store the material in
feet in Vantage. When part of a length is used, the remainder is kept in
inventory. However, the left over cuts are often too short to be used in
many jobs. This can mislead our purchasing agent, he may see 200 feet of
a partular raw material in stock but it could be in lengths too short to
use in the jobs at hand.

We're tossing around the idea of creating a bunch of part numbers, one
for each foot length. I'm curious what others are doing to manage this
type of scenerio.

Any advice would be appreciated.

Gerry

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



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