Vantage as a tool crib?

We are looking at setting up an inventory system for are expendable tooling.
Is anyone using Vantage for this? If so would you mind explaining how you
approached it and any problems you ran into. We are thinking of setting up
a warehouse and putting the tools there and using misc issues or qty
adjustments to track the inventory.

Thanks for any suggestions

Jim Carnes
IS Administrator
Kenlee Precision Corp
jcarnes@...
1700 Morrell Park Ave
Baltimore, MD 21230




[Non-text portions of this message have been removed]
Our company does die casting. In order to know what tools are available for
making parts we added the them as a material, quantity of 1 fixed, on the
ABOM and related them to an operation so they would be backflushed when
production is reported. The problem we are having is that they are
backflushed as a percentage of what has been produced of the total job
quantity. We need to be able to track the output of a tool as relates to
pieces produced over a period of time for life of a tool.

Does anyone else have tooling that they use to make a product you are
tracking against a job for usage, life and also to show its availability?
If so can you offer suggestions on how you have worked around this problem?
We use to set the tool up as a material like you did, but we would issue the
part to the job. We determined that we would decrease the cost of the tool
by 50% of its existing value every time it was used. At the end of the job
we would receive the tool back into it's part number and bin to indicate
that it was available for use on the next job. When we received it back
into inventory we received it at 50% of its value at that time. If the tool
broke during a job and had to be replaced we did not issue it back but left
the remaining cost on the job and received the new tool back into inventory
at its current value. So if a new tool cost $500.00, the first time it was
issue to a job the job absorbed $250.00 and it was returned to inventory at
$250.00. The next job received $125.00 and we returned it to inventory at
$125.00, etc. Because of the number of run normally done with a tool and
the life expectancy, for various reasons, The tool was usually consumed by
about the 4th or 5th usage. It was also reasonable to assume that it was
more likely to need replacing the more times it was removed and put back
into service. If your usage is difference you could use a difference
percentage or a fixed dollar amount.

We kept the tool location by bin. The bin represented the location on the
tooling cage. If the bin had 0 in it, the tool was already on a job and
showed as a material shortage during scheduling, which kept us from
scheduling two jobs with the same tool. Hope this was helpful.

Cameron A. Janish
Misha1
866-464-7421
cameron@...
-----Original Message-----
From: Pete Marston [mailto:pmarston@...]
Sent: Tuesday, September 25, 2001 05:44 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Tool Numbers as a Material


Our company does die casting. In order to know what tools are available
for
making parts we added the them as a material, quantity of 1 fixed, on the
ABOM and related them to an operation so they would be backflushed when
production is reported. The problem we are having is that they are
backflushed as a percentage of what has been produced of the total job
quantity. We need to be able to track the output of a tool as relates to
pieces produced over a period of time for life of a tool.

Does anyone else have tooling that they use to make a product you are
tracking against a job for usage, life and also to show its availability?
If so can you offer suggestions on how you have worked around this
problem?



Yahoo! Groups Sponsor
ADVERTISEMENT




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.



[Non-text portions of this message have been removed]
We code the tool number as the first 6 digits of the part description. Our
parts have a 1-1 relationship with the tool set. Usage can then be reported
with a simple RB report. When tools are created an expected number of hits
(metal stamping) before rework or remake is set and written on a part log
(paper) that stays with all other part related info (drawings, etc..).
Eventually we will have this all in on-line documents linked to the part and
be paperless. Coding the tool in the description has the advantage of
making it the search string on sveral screens and it is the tool number more
than the part number that is used in the shop.
-Todd C.

-----Original Message-----
From: Pete Marston [mailto:pmarston@...]
Sent: Tuesday, September 25, 2001 5:44 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Tool Numbers as a Material


Our company does die casting. In order to know what tools are available for
making parts we added the them as a material, quantity of 1 fixed, on the
ABOM and related them to an operation so they would be backflushed when
production is reported. The problem we are having is that they are
backflushed as a percentage of what has been produced of the total job
quantity. We need to be able to track the output of a tool as relates to
pieces produced over a period of time for life of a tool.

Does anyone else have tooling that they use to make a product you are
tracking against a job for usage, life and also to show its availability?
If so can you offer suggestions on how you have worked around this problem?




Yahoo! Groups Sponsor

ADVERTISEMENT




<http://us.adserver.yahoo.com/l?M=168643.1620686.3168692.1261774/D=egroupmai
l/S=1705007183:HM/A=799560/rand=629388537>

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>

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]