Todd
And don't foget to mention whether it is A36, X Ten50, T-1, AR-400, etc.
etc. etc.
It's a nightmare.
Marc L. Durre
Durre Bros. Welding & Machine Shop, Inc.
309-432-2512
mdurre@...
-----Original Message-----
From: Todd Anderson [mailto:
tanderson@...]
Sent: Friday, December 19, 2003 11:37 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Inventory Issue question
Shirley,
Life should always be simple ...
Or, this is one time where I have to disagree.
The company I work for is a steel service center so we get to deal with
raw
material unit of measure issues ALL day long.
Here's a list of the twisted issues we get into:
* We purchase tons of material at a per pound or per hundred weight
price.
How many pc's are involved varies since 20 ft lengths can vary by a bit so
when we receive bundles we have to hand count them to find out how many
pc's
we actually received. ( Can your shop floor min-wage employees count past
10? )
* We also purchase PC's of material at a per pound or per hundred weight
price. Think 14" thick plate 96 x 240 inches. We'll buy 3 pcs and get
billed for whatever they happen to weight. Lot's of trust going on with
this one ...
* Our customers are all over the map. They purchase along the following
lines:
*** Purchase X nbr of pieces - what's the price per pound?
*** Purchase X nbr of pieces - what's the price per inch?
*** Purchase X nbr of pieces - what's the price per sq-in?
*** etc etc etc
Of course when you call us and want to purchase 5 - 20 ft pieces of steel
that weigh 900 lbs total at .2045 cents per pound we CANNOT tell the floor
to ship you 900 lbs ... If we did God only knows how many pcs you might
actually receive.
So we have a PO unit of measure, a stocking unit of measure, a sales
order
unit of measure, and a INVOICING unit of measure. This way we can buy 5
tons, stock 400 pcs, sell you 20 pcs that are 112.345 inches long, and
still
invoice you for $ 0.3452 per lb purchased.
Did I mention that when we ship you and your fellow mfg companies a load
of
steel we have to know how much the whole load will weigh because if it's
more then 50,000 lbs per truck the guys in the little blue hats get
cranky?
To pull it all together we have they following units scattered through the
system:
* Linear code - 1 = linear, 2 = 2 dimensional ( sq inches etc ), 3 = 3
dimensional ( 3" thick plate )
* Size 1, 2, 3, 4 ( Thickness(dia), width, length, wall thickness)
* Pounds per X ( LC-1 = lbs per running inch ) ( LC-2 = lbs per sq inch )
(
LC-3 = Lbs per cubic inch )
And then we have drops ... It does us NO good to know that we have 15,000
lbs of plate in stock. We need to know how many full sheets and how many
drops we have. On the drops we need to know exactly how big they are and
they are NEVER nice sizes like Vantage wants ( 1/2 sheet, 1/4 sheet ).
The last company I worked for was a true mfg company ( textile machines ).
Our steel department was ALWAYS a mess since they used a single unit of
measure for all raw material. In our case it was inches. Problem was you
never knew whether 240 inches was 1 piece 20 ft long or 10 pcs of misc
scrap
that added up to 240 inches none of which was actually long enough to make
what you needed. We frequently found ourselves with no usable raw
material
in stock because of this.
If I HAD to pick one unit of measure it would at least be pcs of raw
material required. As in, you need 0.015 pcs of raw material per parent
part.
But no matter who you please on this issue someone is going to get
screwed.
Make it LBS across the board and you'll never know how many pcs you have
in
stock. Make it PCS and your shop floor operators will have to calculate
inches or pounds. Either way you have not achieved an idiot proof system
....
Ok, so much for this ramble ....
----Original Message-----
From: Shirley Graver [mailto:
shirleyg@...]
Sent: Friday, December 19, 2003 9:45 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Inventory Issue question
Actually, the best way to do this is the one least likely to accepted,
and that is to unify your units of measure. Either pounds or square
feet through the whole system. It eliminates any confusion when
discussing issues. In my opinion, it should be what ever works best in
Vantage. Unfortunately, whoever will have to change will immediately
suffer convulsions at the thought of changing from "their" way.
(REALLY, I've seen it happen). My best suggestion, convince management,
get them to mandate it.
Shirley Graver
Systems Administrator
Rubber Associates Inc.
-----Original Message-----
From: Kelly Wendorff [mailto:
kelly.wendorff@...]
Sent: Friday, December 19, 2003 9:49 AM
To: '
vantage@yahoogroups.com'
Subject: [Vantage] Inventory Issue question
We are starting planning to implement data collection and the advanced
material management(AMM) module on our shop floor. The labor portion
will
be fairly straight forward, but I'm not sure of the best way to issue
the
material.
We purchase our inventory (primarily steel blanks) in pounds. For job
costing, we also use pounds. Currently, the operators give me the
quantify
used per job in sheets and I calculate it into pounds (L x W x Part
Factor)/(Sq. Ft). If the operators are going to issue material to jobs,
they
will need to do this calculation on the floor. We could build an fairly
simple application that could do that, but I would rather have them work
exclusively in Vantage....
Is anyone doing this in Vantage? Can anyone offer a recommendation of
an
efficient way of doing this?
Feel free to contact me off line.
Thanks!
Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
105 SteelCraft Drive
Hartford, WI 53027
262.673.6770
262.673.4380 (Fax)
www.scc-wi.com
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/.
<
http://groups.yahoo.com/group/vantage/files/.>
<
http://groups.yahoo.com/group/vantage/files/
<
http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
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
<
http://groups.yahoo.com/group/vantage/links>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<
http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<
http://docs.yahoo.com/info/terms/ <
http://docs.yahoo.com/info/terms/> >
Service.
Tracking #: BEEA2A669A0FB1479E048A874FE6EB6685A23BAE
[Non-text portions of this message have been removed]
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/.
<
http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<
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
<
http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c5b90kj/M=266841.4316200.5507732.1261774/D=egroup
web/S=1705007183:HM/EXP=1071935142/A=1911857/R=0/*
http://www.lifescapeinc.co
m/picasa/landing.php?capid=222&caId=1986> click here
<
http://us.adserver.yahoo.com/l?M=266841.4316200.5507732.1261774/D=egroupmai
l/S=:HM/A=1911857/rand=641148039>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<
http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
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
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]