Inventory KPI calculator
Calculate average inventory value, turnover, holding duration and capital tied up.
Your result
Enter values or load an example, then calculate.
Formula & assumptions
Average inventory value = (opening value + closing value) ÷ 2 · turnover = cost of goods sold ÷ average inventory value · holding duration = period days ÷ turnover · stock value = quantity × unit cost
Average inventory value: arithmetic mean of opening and closing values for the same period and valuation basis. Frequent snapshots are more accurate for variable stock. Turnover: cost of goods sold and average stock value must be in euros for the same articles and valuation method. Cost of goods sold is not revenue. Holding duration is a calculated average, not an age analysis. Enter days matching your analysis period. Capital tied up: quantity and unit cost refer to the same article; current stock value is not a time average.
Display values are rounded; calculations use no intermediate rounding. Adjust results for indivisible quantities, pack sizes and operational requirements.
Article planning · CSV, history & scenarios
Maintain a shared article dataset, calculate all articles and transfer it explicitly to another calculator. Data stays in this open page; no background saving.
Your article plan
Import CSV or create an article. Then complete model options and calculate all articles.