Rounding Robin

Home › Accounting › Weighted Average Cost Calculator

Weighted Average Cost Calculator

Enter the units in each purchase and the unit cost of each, in the same order, separated by commas.

Weighted average cost per unit$11.278
Total units available
450
Total cost
$5,075.00
Cost of goods sold
$3,383.33
Ending inventory value
$1,691.67
Ending inventory units
150

Formula

Weighted average cost = Total cost of goods available ÷ Total units available
COGS = Units sold × Weighted average cost
Ending inventory = Units remaining × Weighted average cost

How it works

Weighted average spreads the total cost evenly over every unit, so each unit sold and each unit left carries the same cost. It sits between FIFO and LIFO when prices are moving.

Include beginning inventory as the first purchase. This is the periodic method, which averages once for the period; a perpetual moving average recalculates after every purchase and can give a slightly different result.

Worked example

Using the starting figures above (Units per purchase (comma separated): 100, 200, 150; Unit cost per purchase (comma separated): 10, 11, 12.50; Units sold: 300), the calculator returns:

Common questions

When is weighted average a good choice?

When units are interchangeable and tracking individual purchase lots is impractical, such as fuel, grain or small identical parts.

Related calculators

Something look wrong, or missing a calculator you need? Send feedback.

Results are estimates for general information. They are not financial, tax or legal advice. Check important figures with a qualified professional before acting on them.