Avco

[sargon]

Hi,

Can someone pls attach a simple db that calculate average cost (AVCO) of a product, or post a VBA function that calculate the average cost?

thx

 

[Atomic Shrimp]

Based on what kind of data?

 

[gemma-the-husky]

well average cost of something is the total cost of something, dividied ny the quantity of something

now having an inventory system to calculate

a) the quantity in stock is difficult
b) the value of that stock is extraordinarily difficult, whether under avco, or any other cost basis.

so there certainly is not a meaningful simple answer to your question