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]
At 10:03 AM 3/28/2002 -0500, you wrote:
>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:

((CurrentOnHandQty * CurrentUnitCost)+(IncomingQty * IncomingUnitCost)) /
(CurrentOnHandQty + IncomingQty)

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/
Thanks Wayne and Rick, greatly appreciated.

-----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:

((CurrentOnHandQty * CurrentUnitCost)+(IncomingQty * IncomingUnitCost)) /
(CurrentOnHandQty + IncomingQty)

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/



Yahoo! Groups Sponsor
ADVERTISEMENT
HYPERLINK
"http://rd.yahoo.com/M=217097.1902236.3412362.1261774/D=egroupweb/S=17050071
83:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&site
id=39282504&bfpage=account"
HYPERLINK
"http://us.adserver.yahoo.com/l?M=217097.1902236.3412362.1261774/D=egroupmai
l/S=1705007183:HM/A=999859/rand=661171566"

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]