Hi Gang,
Â
How does Vantage calculate average cost? How far back does it go? Weighted
Average? Does it take the value you there, add the new purchase price and
divide by 2?
Â
Thanks
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
[Non-text portions of this message have been removed]
>How does Vantage calculate average cost? How far back does it go? Weighted
>Average? Does it take the value you there, add the new purchase price and
>divide by 2?
It is a weighted average, but each time the on hand qty drops to zero, the
average is "reset" and the average will start over fresh upon the next receipt.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
The average cost is a weighted average of what is CURRENTLY in stock and
what is added. It ignores all costs for items prior to the items CURRENTLY
in stock. Formula as below:
So it is not really an average cost for the history of the product.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 28, 2002 10:03 AM
To: Vantage Group (E-mail)
Subject: [Vantage] Average Cost
Hi Gang,
Â
How does Vantage calculate average cost? How far back does it go? Weighted
Average? Does it take the value you there, add the new purchase price and
divide by 2?
Â
Thanks
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
[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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
-----Original Message-----
From: Rick Lane [mailto:rickl@...]
Sent: Thursday, March 28, 2002 10:07 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Average Cost
The average cost is a weighted average of what is CURRENTLY in stock and
what is added. It ignores all costs for items prior to the items CURRENTLY
in stock. Formula as below:
So it is not really an average cost for the history of the product.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OHÂ 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 28, 2002 10:03 AM
To: Vantage Group (E-mail)
Subject: [Vantage] Average Cost
Hi Gang,
Â
How does Vantage calculate average cost? How far back does it go? Weighted
Average? Does it take the value you there, add the new purchase price and
divide by 2?
Â
Thanks
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
" HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com/"
HYPERLINK
"http://www.toledometalspinning.com"http://www.toledometalspinning.com
HYPERLINK " HYPERLINK
"http://www.toledometalspinning.com/products_configurator.htm"http://www.tol
edometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( HYPERLINK
"http://www.grisoft.com)."http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
[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:
HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/group
/vantage/files/.Â
(2) To search through old msg's goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/grou
p/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group/v
antage/links
Your use of Yahoo! Groups is subject to HYPERLINK
"http://docs.yahoo.com/info/terms/"http://docs.yahoo.com/info/terms/
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: HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/group
/vantage/files/.Â
(2) To search through old msg's goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/grou
p/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group/v
antage/links
Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/2002
[Non-text portions of this message have been removed]