Sixty procurement measures, each with the four things that decide whether a KPI survives contact with a supplier, a stakeholder or a CFO: the exact definition, the source system, the target range, and an honest account of how the number can be made to look better without anything improving.
Most procurement KPI material lists metrics. Listing them is the easy part. A KPI without a measurement method is not a measure – it is an argument scheduled for the next review meeting.
WHAT MAKES THIS DIFFERENT
Every one of the sixty carries a gaming risk and a countermeasure. Spend under management, with the definition quietly widened until everything counts as managed. PO compliance, with retrospective orders counted as compliant. Price file compliance, checked only on the easy contracts. Savings realisation rate, held high by revising the plan downward. None of these require anyone to state a falsehood, which is exactly why they are so common – and why naming them in your own documentation earns trust rather than inviting doubt.
WHAT IS INCLUDED
Primary document – a 15-slide guide covering the five parts of a usable KPI, the twelve to report if you only report twelve, the leading-against-lagging design matrix, the four mechanisms of definitional drift, typical starting positions for a mid-sized organisation, how to cascade from function to category to individual without creating perverse incentives, the three-audience reporting rhythm, and what finance accepts against what it quietly discounts.
Working files, all unlocked with live formulas:
Procurement KPI Library (Excel) – all sixty measures across value, coverage, compliance, process, supplier and risk, sustainability and people. Definition, formula, source system, frequency, typical target, leading or lagging, gaming risk and countermeasure. Mark the ones you will report and the selection check tells you whether your pack is balanced, how many are leading, and how many areas you have covered.
Procurement KPI Dashboard (Excel) – twelve measures on one page, pre-loaded with the starting twelve. Enter target, actual and prior period; direction-aware status, variance and trend are calculated, including for measures where lower is better.
KPI Cascade Model (Excel) – each function measure mapped to its category and individual equivalents, with the controllability test applied, the perverse behaviour it can create, and the counter-measure to pair it with.
KPI Data Readiness Assessment (Excel) – before you choose measures, establish which you can honestly source today. Scored on data existence, reliability and automatability, with a reading that tells you whether to report it now, report it with a caveat, or fix the source first.
KPI Definition Handbook (Word) – nineteen pages, all sixty written out in full. Designed to be published as the appendix of your first reporting pack, which is what prevents every later argument.
Reporting Pack Design Guide (Word) – three audiences, three packs, three rhythms, with the page structure for each and the seven common failures.
How Procurement KPIs Get Gamed (Word) – the four mechanisms of definitional drift, the ten measures most exposed, and the annual definition review.
Target Setting Guide (Word) – the six-step sequence for setting a first target you can defend, the three ways targets go wrong, and how to use a benchmark without being caught by one.
WHO IT IS FOR
Heads of procurement building or rebuilding a reporting pack. Category managers being measured and wanting to understand on what. Finance business partners who validate procurement numbers. Consultants designing a performance framework for a client.
WHAT THIS IS NOT
It is not a benchmark database. The targets are typical positions for a mid-sized organisation with a functioning procurement team, offered as a starting point for the conversation and labelled as such. The correct target is your own measured baseline plus a movement, and the guide explains why.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Key Performance Indicators, Procurement Strategy PowerPoint Slides: Procurement KPI Library and Dashboard - 60 Measures PowerPoint (PPTX) Presentation Slide Deck, Davide Sferrazza
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more. |