KPI library
Inventory and purchasing KPIs: formulas
These KPIs show how much cash is tied up in stock, how reliable suppliers are and how efficiently you produce. The data comes from your ERP, WMS and production records.
20 inventory, purchasing and production KPIs
- Inventory turnoverHow many times a year you sell and replace your average stock.Formula and example
- Days inventory outstanding (DIO)The average number of days stock sits in the warehouse before it is sold.Formula and example
- Stockout rateThe share of active products with zero stock on an average day.Formula and example
- Inventory accuracyThe share of counted items where system stock matches the physical count.Formula and example
- Dead stock percentageThe share of inventory value in products that have not sold for a long time.Formula and example
- Inventory valueThe total value of stock on a given date, usually at cost.Formula and example
- GMROIHow much gross margin each euro of average stock earns in a year.Formula and example
- Fill rateThe share of demand you deliver complete and straight from stock.Formula and example
- Backorder rateThe share of orders that cannot ship straight away and are waiting for stock.Formula and example
- Supplier on-time deliveryThe share of purchase orders a supplier delivers on or before the agreed date.Formula and example
- Purchase price variance (PPV)The difference between the price you paid and the standard or budget price.Formula and example
- Supplier lead timeThe average number of days between placing a purchase order and receiving it.Formula and example
- OEEThe share of planned production time that actually produces good output.Formula and example
- Scrap rateThe share of units produced that are rejected and cannot be reworked.Formula and example
- First pass yield (FPY)The share of units that come out right first time, with no rework or scrap.Formula and example
- Capacity utilisationThe share of available production capacity you actually use.Formula and example
- Production lead timeHow long a production order takes on average from start to completion.Formula and example
- Order cycle timeThe average number of days between a customer placing an order and receiving it.Formula and example
- Days of supplyHow many days your current stock will last at expected demand.Formula and example
- Spend per supplierHow much you buy from each supplier and what share of total spend that is.Formula and example
Further reading
- ResourcesKPI library: 193 KPIs with formulas and examples193 KPIs explained for finance, sales, marketing, e-commerce, inventory, logistics, HR, projects, service and SaaS, with formulas, examples, SQL and DAX.Read more
- ResourcesHow to build a KPI dashboard: steps and examplesA KPI dashboard is an overview of the key figures you use to steer towards your goals, such as revenue, margin, on-time delivery or absenteeism. A good KPI dashboard does not start with the software, but with the decisions it needs to support. You then choose a limited number of KPIs, define them, sketch the dashboard and only then build it.Read more
- SolutionPower BI dashboard portal: share dashboards securelyShare your Power BI dashboards securely in your own portal, with role-based access.Read more
Use AI on your own data. Securely, and without the headache.
In an online demo we show how ENABLE makes your data securely available and how you build on it: describing an app in the AI Builder, plain-language questions, dashboards and APIs. And how we set it up and manage it for you.