Weighted Average Cost (WAV)
The average cost calculated on receipts by taking the existing quantity in the inventory, that is, unissued stock, multiplied by the existing weighted average cost from the item record. The incoming quantity is then multiplied by its actual unit cost. These two values are totalled. The existing quantity balance is then taken plus the incoming quantity. The total value is then divided by the total quantity.
That is:
[ (QTY1 x COST1) + (QTY2 x COST2) ] / (QTY1 + QTY2)
where
QTY1 = existing quantity currently in inventory, that is, unissued stock
COST1 = existing Weighted Average Cost from the item record
QTY2 = incoming quantity
COST2 = incoming actual unit cost
Note: In order to avoid negative average
cost problems, if the inventory quantity used to calculate WAV is negative, WAV is set
to the same value as Latest Actual Cost which is set as normal.