weighted average formular
I am looking for a formula to tell me the quanity to buy given the following.
I want to buy something at 3 or more different prices. I want the average
cost as we increase in price to be $1.00 below the purchased price. I want
to know how many I have to buy to bring the average up to $1.00 below the
purchase price and continue to do this as we make the next purchases at the
next higher price we choose.
|