View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=Total price you paid /total number of widgets

=15300/15000

=1.02


Regards,

Peo Sjoblom

"Inventory Question" wrote:

I want to calculate a new average price on inventory each time I add new
product. For example if I buy 10,000 widgets at $1.08 per widget and then I
buy another 5,000 widgets at .90, what is my current average price per widget?