Weighted average inventory cost
The weighted average unit cost of your purchases and the value of your stock.
How it works
Weighted average cost = Σ(qty × price) / Σ qty. Remaining stock value = remaining units × average cost. Cost of goods sold = units used × average cost.
Results are for guidance only and do not replace professional advice.
Worked example
With the default values:
- Purchases (quantity then unit price, one per line)100 4,20 · 250 3,90 · 80 4,60
- Units sold or used210
you get:
- Weighted average unit cost€4.10
- Remaining stock value€902.00 (220 units)
- Cost of goods sold€861.00
- Total purchased430 units · €1,763.00
Frequently asked questions
How does the “Weighted average inventory cost” tool work?
Weighted average cost = Σ(qty × price) / Σ qty. Remaining stock value = remaining units × average cost. Cost of goods sold = units used × average cost.
What do I need to enter?
Just fill in: purchases, units sold or used. The result updates as you type.
Can you give an example?
Purchases (quantity then unit price, one per line): 100 4,20 · 250 3,90 · 80 4,60; Units sold or used: 210 → Weighted average unit cost: €4.10; Remaining stock value: €902.00 (220 units).
Is this calculator free, and is my data private?
Yes. HOD Calc is completely free with no sign-up. The calculation runs in your browser: nothing you type is sent or stored.