Free Download · Resources
KPI Checklist
Procurement & Spend
10 essential procurement KPIs — with definition, formula, sector benchmark values and a concrete Power BI implementation tip. Built for SMEs that want to get a grip on supplier performance, spend control and procurement risk.
10
Procurement
KPIs
KPIs
What this checklist covers
Measuring procurement is more than supplier scores
Work through each KPI and score yourself: are you measuring this already? Is there a dashboard? Is the data source missing? Use the benchmarks as a guide — not as an absolute standard. Every sector, spend volume and supplier structure has its own norms.
5 categories
Cost, Supplier, Quality, Risk and Sustainability — the five pillars of professional procurement management.
Benchmarks per level
Each KPI contains three benchmark values — minimum, good and best-in-class — for SMEs in manufacturing, wholesale and professional services.
Power BI tip per KPI
No theory — a concrete implementation tip: which dimensions, which visualisation, which thresholds — ready to apply in your dashboard immediately.
10 procurement KPIs
Procurement & Spend — the ten KPIs
Click a KPI to see its definition, formula, benchmarks and Power BI implementation tip. The first KPI is open by default.
Cost
Supplier
Quality
Risk
Sustainability
01
Spend Concentration (Supplier Concentration)
The percentage of total procurement spend concentrated among the largest suppliers.
Risk
Definition & why measure it
The percentage of total procurement spend concentrated among the largest suppliers. High concentration increases dependency risk.
If more than 50% of procurement spend sits with three suppliers, a single disruption or insolvency is enough to impact operations. Diversification is not a luxury — it is risk management.
Formula
(Spend with top-N suppliers ÷ Total procurement spend) × 100%Benchmark by risk level
Low risk
< 30%
Average
30–50%
High risk
> 50%
What does this KPI tell you?
Spend concentration is not inherently negative. Strategic concentration with one reliable supplier can yield advantages in pricing and fulfilment priority — provided it is a deliberate choice, backed by a contract.
Power BI implementation tip
Visualise spend per supplier as a treemap or waterfall chart. Flag suppliers above 20% of total spend as 'critical' and link to contract status and identified alternatives.
02
Supplier On-Time In Full (OTIF — Inbound)
The percentage of inbound deliveries received on time and in full per the purchase order.
Supplier
Definition & why measure it
On Time In Full — the percentage of inbound deliveries received both on time and complete in accordance with the purchase order.
Low OTIF forces higher safety stock and emergency orders. Every deviation costs time in the goods-receipt process and disrupts downstream planning.
Formula
(Deliveries on time and in full ÷ Total inbound deliveries) × 100%Benchmark by level
SME minimum
≥ 85%
Good supplier
≥ 92%
Best-in-class
≥ 97%
What does this KPI tell you?
An OTIF of 80% means 1 in 5 deliveries has a problem. At 10 deliveries per week that is two exceptions every week — a structural operational burden that never appears as a separate cost line.
Power BI implementation tip
Rank suppliers by OTIF score each quarter. Red below 85%, amber below 92%, green above 92%. Export as a table for supplier review meetings — data makes negotiation concrete.
03
Average Order Lead Time
The average number of working days between placing a purchase order and receiving the goods.
Supplier
Definition & why measure it
The average number of working days between placing a purchase order and physically receiving the goods at the delivery location.
Longer lead times require higher safety stock and reduce flexibility when demand varies. Insight into actual versus expected lead times directly informs reorder frequency.
Formula
Average of (goods-receipt date − order placement date) in working daysBenchmark by origin
Local / domestic
2–5 days
European
5–15 days
Intercontinental
15–45 days
What does this KPI tell you?
Lead time variability is often more dangerous than average lead time. A supplier averaging 10 days with a range of 5 to 20 days is harder to plan around than one consistently delivering in 14 days.
Power BI implementation tip
Display lead time as a line chart per supplier showing minimum, average and maximum. Wide variation signals capacity constraints or quality issues at the supplier.
04
Purchase Price Variance (PPV)
The percentage deviation of the actual purchase price from the agreed reference or contract price.
Cost
Definition & why measure it
The percentage deviation of the actual purchase price from the agreed reference price or contract price for the same items.
Positive variances (higher than reference) directly erode gross margin. Negative variances are savings that can be reported to management as procurement's contribution to profitability.
Formula
(Actual purchase price − Reference price) ÷ Reference price × 100%Benchmark by deviation
Excellent
< ± 2%
Acceptable
± 2–5%
Concerning
> ± 5%
What does this KPI tell you?
Measuring PPV without a clearly defined reference price is meaningless. Define the baseline first — contract price, prior-period price or market price. That choice determines how results are interpreted.
Power BI implementation tip
Calculate per item and supplier. Display variance as a +/- percentage with threshold markers. Link to contract periods to reveal whether price deviations coincide with contract expiry dates.
05
Spend Under Contract
The percentage of total procurement spend covered by an active, valid contract.
Risk
Definition & why measure it
The percentage of total procurement spend covered by an active, valid contract with a supplier.
Spend outside contract means higher prices, no quality or delivery guarantees, and elevated compliance risk. Every percentage point of additional contract coverage directly reduces operational risk.
Formula
(Spend covered by active contract ÷ Total procurement spend) × 100%Benchmark by level
Low
< 40%
Average SME
40–70%
Best practice
> 70%
What does this KPI tell you?
A contract coverage of 40% means half of all procurement is effectively managed on an ad hoc basis. That costs more, protects less, and provides no negotiating position when suppliers raise prices.
Power BI implementation tip
Show spend per supplier with contract status (active, expired, no contract). Flag expired contracts with their expiry date as an action list for buyers — visibility drives behaviour directly.
06
Days Payable Outstanding (DPO)
The average number of days a company takes to pay its suppliers after receiving an invoice.
Cost
Definition & why measure it
The average number of days a company takes to pay its suppliers after receiving an invoice. Also known as creditor days.
Longer payment terms improve the cash conversion cycle and reduce the need for working capital financing. Paying too early is a silent liquidity leak — money leaving before it needs to.
Formula
(Outstanding accounts payable ÷ Cost of goods sold) × 365 daysBenchmark by level
Too short
< 30 days
Market standard
30–60 days
Well negotiated
> 60 days
What does this KPI tell you?
Optimising DPO is a balancing act: paying too late damages supplier relationships and can lead to fulfilment problems. The optimal DPO is what is contractually agreed — no more, no less.
Power BI implementation tip
Segment payables by payment status: within terms, early and late. Paying too early is at least as relevant as paying late — both cost money or relationships, and both are preventable with the right insight.
07
Spend by Category
The distribution of total procurement spend across purchasing categories based on Pareto logic.
Cost
Definition & why measure it
The distribution of total procurement spend across purchasing categories, based on Pareto logic — comparable to ABC analysis for inventory.
Without categorisation, procurement spend is a black box. Category spend analysis makes it visible where the most money goes and where procurement effort delivers the highest return.
Formula
Spend per category ÷ Total procurement spend × 100% (A = top 20% of categories ≈ 80% of spend)Benchmark by category tier
A-categories
60–70%
B-categories
20–30%
C-categories
< 10%
What does this KPI tell you?
C-categories (many suppliers, little spend) often consume disproportionate buyer time. Consolidating to fewer suppliers per C-category is low-hanging fruit for efficiency and cost reduction.
Power BI implementation tip
Build a spend cube: category on the X-axis, supplier on the Y-axis, spend as colour intensity. This surfaces consolidation opportunities without any complex calculation — ideal as a starting point for procurement reviews.
08
Incoming Rejection Rate
The percentage of goods received that are rejected at inbound inspection.
Quality
Definition & why measure it
The percentage of goods received that are rejected at inbound inspection due to quality, specification or packaging deviations.
Inbound rejections immediately disrupt production or distribution planning. The processing cost of return shipments, reinspection and emergency reorders can be three to five times the value of the rejected goods.
Formula
(Units rejected at inbound inspection ÷ Total units received) × 100%Benchmark by level
Best-in-class
< 0.5%
Acceptable
< 2%
Problematic
> 3%
What does this KPI tell you?
A rejection rate of 2% sounds small — but at 500 inbound order lines per month that is 10 exceptions, each with associated administration, return logistics and replacement orders consuming lead time.
Power BI implementation tip
Categorise rejection reasons: dimensional deviation, visible damage, wrong item, incomplete documentation. Link to supplier and production batch to identify root-cause patterns that would otherwise remain invisible.
09
Realised Procurement Savings
The percentage saving realised relative to the reference price, multiplied by purchase volume.
Cost
Definition & why measure it
The percentage saving realised relative to the reference price, multiplied by the purchase volume in the measurement period.
Realised savings are the most direct measure of procurement's added value. They make procurement performance visible and comparable over time and between buyers.
Formula
(Reference price − Actual price) × Volume ÷ (Reference price × Volume) × 100%Benchmark by annual performance
Minimum
1–2%
Good
2–5%
Excellent
> 5%
What does this KPI tell you?
Measuring savings requires a reliable reference price. Without that foundation, savings are nothing more than an assumption. Define the reference before the year begins — adjusting it afterwards is not credible.
Power BI implementation tip
Show realised savings per buyer and per category, cumulatively over the year. Combine with spend volume per category to identify where savings potential remains untapped.
10
Supplier Sustainability Score
A composite score assessing supplier performance on environmental, social and governance criteria.
Sustainability
Definition & why measure it
A composite score assessing supplier performance on environmental, social and governance criteria, expressed as a weighted percentage.
Regulation such as CSRD is increasingly requiring SMEs to report on their supply chain. A sustainability score makes compliance risks visible before they become obligations.
Formula
Weighted average of supplier scores on environment, social and governance (scale 0–100)Benchmark by maturity level
Basic level
< 40
Adequate
40–70
Leader
> 70
What does this KPI tell you?
A sustainability score is not a destination — it is a starting point for conversation with suppliers. A low score is not an immediate reason to end the relationship, but it is a signal to ask what improvement plans are in place.
Power BI implementation tip
Build a simple supplier assessment form with three to five questions per domain. Display scores per supplier as a heatmap — colour by score, size by spend. This makes priorities immediately visible.
Download all 10 KPIs as PDF
Free — no email address required
Frequently asked questions
Procurement KPIs in Power BI — questions & answers
Which procurement KPIs matter most for an SME dashboard?
For an SME procurement dashboard, supplier OTIF (inbound), purchase price variance and spend under contract are the three most critical KPIs. They directly affect supply security, cost price and the risk profile of the procurement function. Den Otter Solutions implements these three as the standard baseline dashboard for new clients — and builds outward from there based on the specific pain points in the supply chain.
How do I connect my ERP or procurement system to Power BI?
Most SME ERP systems — Microsoft Dynamics, SAP Business One, Exact, AFAS — have a direct Power BI connector or an export route via API or database connection. The connection typically takes 1–3 days depending on data quality and system access. Den Otter Solutions builds the data model on top of that connection, so the procurement KPIs on this page are immediately available as interactive visuals with drilldown by supplier, category and period.
What is a good inbound OTIF score for an SME?
An OTIF score of 92% or above is the standard for a reliable supplier. Best-in-class sits above 97%. Below 85% is structurally concerning — that means at least one in every seven deliveries is not received on time or in full. Den Otter Solutions always measures OTIF per supplier individually, making it clear who is pulling the average down and which conversations need to happen.
How long does it take to build a procurement dashboard in Power BI?
A full procurement dashboard covering these 10 KPIs typically takes 4–6 working days with structured data from a single ERP system, or 7–12 days with multiple procurement systems or a more complex supplier structure. Den Otter Solutions always starts with a Data Start Scan to estimate the build time realistically — and avoid surprises later.
Ready to put these KPIs to work
in your organisation?
Den Otter Solutions builds procurement and spend dashboards for SMEs. From ERP connection to spend analytics dashboard — including all 10 of these KPIs implemented in your own Power BI environment.