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.
- 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
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:
- Weighted average cost per unit: $11.278
- Total units available: 450
- Total cost: $5,075.00
- Cost of goods sold: $3,383.33
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
- Cost of Goods Sold (COGS) CalculatorCalculate cost of goods sold from beginning inventory, purchases and ending inventory, with gross profit when you add revenue.
- Inventory Turnover CalculatorCalculate inventory turnover and days of inventory on hand from cost of goods sold and average inventory.
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.