[6.1 or anyone] Consumable Tooling

Bob,

The good news is Vantage 8.0 has changed the decimal precision on qty per
from 5 to 8 decimal places.

The bad news is it still doesn't do you any good because all versions of
vantage truncate the decimal precision at 2 in time phase so any quantity
per smaller than .004 shows up as zero requirements, .005 to .009 round to
.01 and this is where Time Phase starts seeing requirements. Unless you
create your own Time Phase Screens and Reports.


Patrick Winter
sSc Specialty Screw Corporation
Live Network: Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server,
Crystal 8.5.3.975
Test Network: Version: Vantage 8.00.711b, OpenEdge 10.0B01, Windows 2003
Server, Epicor Crystal 10.0.0.533


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
David Roberto
Sent: Friday, July 01, 2005 11:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling

Hello everyone,
Bristol Industries manufactures fasteners for the Aerospace Industries with
a majority of mechanical operations and processes in-house.

Our Vantage 6.1 implementation, not yet live, is operating under an average
cost method. (Projected "go live" within 60 days)

We are removing consumable tool costs from the overhead rates and applying
these costs directly to the job to get a better understanding of this high
impact cost to the part. When purchased, the tools are put to an inventory
account with costs realized when they are issued to the job. The tooling is
combined into kits that are phantom items at each operational sequence in
the BOM for each part. Each phantom has the actual tools required with a
quantity per phantom at an estimated tool life required.
One problem we have encountered is that some of the tooling can be utilized
for long periods of time before having to be replaced. In this situation we
have gone out to the maximum quantity to parent relationship of .00001. We
are still not satisfied with the quantity to parent relationship and have
asked for a zero relationship in its place but have been advised that this
is not possible from a programming standpoint. We have instead gone to
turning off the MRP and purchasing suggestions for these tooling items and
have gained ground by doing this.
The visibility of the tooling needs will be managed using the Vantage
projections of need, the current tool crib min/max system and the
supervisors' experience in tooling usage.

We are looking for additional ideas and suggestions from those who have gone
down the same path in their implementation as well as warnings as to the
pitfalls that lie ahead. We are also willing to share any non-proprietary
information on how our testing proceeds and how well it works after going
live.

Best regards,
Bob Dressendorfer & Dave Roberto
714-990-4121



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Thursday, June 30, 2005 6:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling

Thank you both.
I will take this to the accountant. With luck he will not be able to fill
this one with holes. It looks clean to me, but I am not an accountant.
The
fact that at least one other company is using it lends additional weight
(always good when going to the accountant).
Thanks again for the idea. I will let you know if it flies.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Kennedy, Jim
Sent: Wednesday, June 29, 2005 10:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


Good answer Carl!
We just went live and are using exactly the scenario you mention below.
Using a separate part class that is assigned to an expense account has
worked well.
And, just as you said, adding them to the BOM shows the demand for the
expense items while the PUR-STK transaction diverts the cost to the expense
account.
This does seem to be working well for us.



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: carl.heeder@... [mailto:carl.heeder@...]
Sent: Wednesday, June 29, 2005 6:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


I would think that you could assign them to a Part Class that has an expense
GL code so they are expensed on purchase - no variances no standard cost.

But include them in the BOM so they will show up on the Stock Status but
with Zero value.
usage would deplete the item, purchases would put quantities into inventory
but it would have no effect on costs because usage would be valued at zero $
and inventory GL would never be Debited (increased) because the Pur-STK
transaction would divert the purchase value to an expense account, not to
the inventory GL.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057




Lydia Coffman

<lcoffman@canyonengin To:
"'vantage@yahoogroups.com'" <vantage@yahoogroups.com>

eering.com> cc:

Sent by: Subject: RE:
[Vantage]
[6.1 or anyone] Consumable Tooling
vantage@yahoogroups.c

om





06/29/2005 04:28 PM

Please respond to

vantage









Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would be
done in Vantage. We have tried again and again to explain the cost is not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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







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

<?---- LSpots keywords ?> <?---- HM ADS ?>
YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.







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







[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









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









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
Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics
Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would be
done in Vantage. We have tried again and again to explain the cost is not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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
While I can't provide an answer, I would like to further extend this
question. Is it possible to use some mechanism keep counts of "expense"
items in general in such a manner that consumption is recorded, but the
items carry no inventory value? For example, can you create some sort
of "expense warehouse"? Anyone worked any variation of this? We are
currently implementing V8 and are desperately hoping that we will not
have to run two sets of books, one in a homebrew crib database, the
other in Vantage. Every thing we have tried has resulted in monkeying
around with lots of variances of one sort of another (purchasing, etc.).

Geordie Dukas
CONCOA

Aaron Hoyt wrote:
> Ok,
> Here I come again with a question that may have been answered a hundred
> times while I was not looking.
> I am looking to find a way to track consumable tooling (drill bits that can
> make 100 parts each before they are useless). I would like requirements to
> be known and consumed as it is used.
> I came up with a great plan to have them a part in our system and called out
> in the BOM/Job. This worked great right up until the accountant caught
> wind. He wants tools to be expensed at time of purchase and remain part of
> overhead. He was not fond of my change and sent me back to the drawing
> board (and I even had buy in from Production Control and Engineering).
> Is there another method of making this happen? I thought of setting these
> parts as standard cost $0.00 and letting them hit a purchasing variance at
> time of purchase, but accounting did not like that either. Is there
> anything else. I am afraid I will have to set up an access DB that ties
> partially into Vantage and then track it all there.
> Any thoughts?
> Aaron Hoyt
> Vantage Plastics
>
>
>
> 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
>
>
>
>
>
>
>
I would think that you could assign them to a Part Class that has an expense GL code so they
are expensed on purchase - no variances no standard cost.

But include them in the BOM so they will show up on the Stock Status but with Zero value.
usage would deplete the item, purchases would put quantities into inventory but it would have
no effect on costs because usage would be valued at zero $ and inventory GL would never be
Debited (increased) because the Pur-STK transaction would divert the purchase value to an
expense account, not to the inventory GL.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



Lydia Coffman
<lcoffman@canyonengin To: "'vantage@yahoogroups.com'" <vantage@yahoogroups.com>
eering.com> cc:
Sent by: Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling
vantage@yahoogroups.c
om


06/29/2005 04:28 PM
Please respond to
vantage






Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would be
done in Vantage. We have tried again and again to explain the cost is not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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







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

<?---- LSpots keywords ?> <?---- HM ADS ?>
YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Good answer Carl!
We just went live and are using exactly the scenario you mention below.
Using a separate part class that is assigned to an expense account has
worked well.
And, just as you said, adding them to the BOM shows the demand for the
expense items while the PUR-STK transaction diverts the cost to the expense
account.
This does seem to be working well for us.



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: carl.heeder@... [mailto:carl.heeder@...]
Sent: Wednesday, June 29, 2005 6:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


I would think that you could assign them to a Part Class that has an expense
GL code so they are expensed on purchase - no variances no standard cost.

But include them in the BOM so they will show up on the Stock Status but
with Zero value.
usage would deplete the item, purchases would put quantities into inventory
but it would have no effect on costs because usage would be valued at zero $
and inventory GL would never be Debited (increased) because the Pur-STK
transaction would divert the purchase value to an expense account, not to
the inventory GL.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057




Lydia Coffman

<lcoffman@canyonengin To:
"'vantage@yahoogroups.com'" <vantage@yahoogroups.com>

eering.com> cc:

Sent by: Subject: RE: [Vantage]
[6.1 or anyone] Consumable Tooling
vantage@yahoogroups.c

om





06/29/2005 04:28 PM

Please respond to

vantage









Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would be
done in Vantage. We have tried again and again to explain the cost is not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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







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

<?---- LSpots keywords ?> <?---- HM ADS ?>
YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.







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







[Non-text portions of this message have been removed]
Thank you both.
I will take this to the accountant. With luck he will not be able to fill
this one with holes. It looks clean to me, but I am not an accountant. The
fact that at least one other company is using it lends additional weight
(always good when going to the accountant).
Thanks again for the idea. I will let you know if it flies.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Kennedy, Jim
Sent: Wednesday, June 29, 2005 10:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


Good answer Carl!
We just went live and are using exactly the scenario you mention below.
Using a separate part class that is assigned to an expense account has
worked well.
And, just as you said, adding them to the BOM shows the demand for the
expense items while the PUR-STK transaction diverts the cost to the expense
account.
This does seem to be working well for us.



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: carl.heeder@... [mailto:carl.heeder@...]
Sent: Wednesday, June 29, 2005 6:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


I would think that you could assign them to a Part Class that has an expense
GL code so they are expensed on purchase - no variances no standard cost.

But include them in the BOM so they will show up on the Stock Status but
with Zero value.
usage would deplete the item, purchases would put quantities into inventory
but it would have no effect on costs because usage would be valued at zero $
and inventory GL would never be Debited (increased) because the Pur-STK
transaction would divert the purchase value to an expense account, not to
the inventory GL.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057




Lydia Coffman

<lcoffman@canyonengin To:
"'vantage@yahoogroups.com'" <vantage@yahoogroups.com>

eering.com> cc:

Sent by: Subject: RE: [Vantage]
[6.1 or anyone] Consumable Tooling
vantage@yahoogroups.c

om





06/29/2005 04:28 PM

Please respond to

vantage









Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would be
done in Vantage. We have tried again and again to explain the cost is not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that can
make 100 parts each before they are useless). I would like requirements to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting these
parts as standard cost $0.00 and letting them hit a purchasing variance at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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







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

<?---- LSpots keywords ?> <?---- HM ADS ?>
YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.







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







[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
Hello everyone,
Bristol Industries manufactures fasteners for the Aerospace Industries
with a majority of mechanical operations and processes in-house.

Our Vantage 6.1 implementation, not yet live, is operating under an
average cost method. (Projected "go live" within 60 days)

We are removing consumable tool costs from the overhead rates and
applying these costs directly to the job to get a better understanding
of this high impact cost to the part. When purchased, the tools are put
to an inventory account with costs realized when they are issued to the
job. The tooling is combined into kits that are phantom items at each
operational sequence in the BOM for each part. Each phantom has the
actual tools required with a quantity per phantom at an estimated tool
life required.
One problem we have encountered is that some of the tooling can be
utilized for long periods of time before having to be replaced. In this
situation we have gone out to the maximum quantity to parent
relationship of .00001. We are still not satisfied with the quantity to
parent relationship and have asked for a zero relationship in its place
but have been advised that this is not possible from a programming
standpoint. We have instead gone to turning off the MRP and purchasing
suggestions for these tooling items and have gained ground by doing
this.
The visibility of the tooling needs will be managed using the Vantage
projections of need, the current tool crib min/max system and the
supervisors' experience in tooling usage.

We are looking for additional ideas and suggestions from those who have
gone down the same path in their implementation as well as warnings as
to the pitfalls that lie ahead. We are also willing to share any
non-proprietary information on how our testing proceeds and how well it
works after going live.

Best regards,
Bob Dressendorfer & Dave Roberto
714-990-4121



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Thursday, June 30, 2005 6:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling

Thank you both.
I will take this to the accountant. With luck he will not be able to
fill
this one with holes. It looks clean to me, but I am not an accountant.
The
fact that at least one other company is using it lends additional weight
(always good when going to the accountant).
Thanks again for the idea. I will let you know if it flies.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Kennedy, Jim
Sent: Wednesday, June 29, 2005 10:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


Good answer Carl!
We just went live and are using exactly the scenario you mention below.
Using a separate part class that is assigned to an expense account has
worked well.
And, just as you said, adding them to the BOM shows the demand for the
expense items while the PUR-STK transaction diverts the cost to the
expense
account.
This does seem to be working well for us.



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: carl.heeder@... [mailto:carl.heeder@...]
Sent: Wednesday, June 29, 2005 6:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 or anyone] Consumable Tooling


I would think that you could assign them to a Part Class that has an
expense
GL code so they are expensed on purchase - no variances no standard
cost.

But include them in the BOM so they will show up on the Stock Status
but
with Zero value.
usage would deplete the item, purchases would put quantities into
inventory
but it would have no effect on costs because usage would be valued at
zero $
and inventory GL would never be Debited (increased) because the Pur-STK
transaction would divert the purchase value to an expense account, not
to
the inventory GL.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057




Lydia Coffman

<lcoffman@canyonengin To:
"'vantage@yahoogroups.com'" <vantage@yahoogroups.com>

eering.com> cc:

Sent by: Subject: RE:
[Vantage]
[6.1 or anyone] Consumable Tooling
vantage@yahoogroups.c

om





06/29/2005 04:28 PM

Please respond to

vantage









Aaron:

I have been up this same creek. Accounting doesn't like any of the
possibilities -- although you might try the "put it in a non-nettable
bin"
or in a warehouse of its own. We are looking (sigh) at another software
package called CribWare that tracks all of this, just the way it would
be
done in Vantage. We have tried again and again to explain the cost is
not
the issue -- it's knowing when to order the stuff because you're low.

Any accounting types care to weigh in on this issue?

Lydia


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, June 29, 2005 1:57 PM
To: Vantage Group
Subject: [Vantage] [6.1 or anyone] Consumable Tooling


Ok,
Here I come again with a question that may have been answered a hundred
times while I was not looking.
I am looking to find a way to track consumable tooling (drill bits that
can
make 100 parts each before they are useless). I would like requirements
to
be known and consumed as it is used.
I came up with a great plan to have them a part in our system and called
out
in the BOM/Job. This worked great right up until the accountant caught
wind. He wants tools to be expensed at time of purchase and remain part
of
overhead. He was not fond of my change and sent me back to the drawing
board (and I even had buy in from Production Control and Engineering).
Is there another method of making this happen? I thought of setting
these
parts as standard cost $0.00 and letting them hit a purchasing variance
at
time of purchase, but accounting did not like that either. Is there
anything else. I am afraid I will have to set up an access DB that ties
partially into Vantage and then track it all there.
Any thoughts?
Aaron Hoyt
Vantage Plastics



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







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

<?---- LSpots keywords ?> <?---- HM ADS ?>
YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.







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







[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









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