Average Cost Update Formula Average Cost = (Transaction Value+Current Inventory value) (Transaction Quantity+Current on Hand Quantity)