Selecting the Right KPIs for Your Procurement Dashboard
Introduction:
You can’t manage what you don’t measure – it’s a cliché, but it’s true. The right Key Performance Indicators (KPIs) on your procurement dashboard can provide at-a-glance insight into how well your function is doing and where to improve. But often, companies either drown in too many metrics or focus on the wrong ones. In this article, we’ll discuss how to choose the most relevant KPIs for your procurement team and best practices for structuring your dashboard for clarity and impact. The goal is to track metrics that align with your strategic objectives and drive the right behaviors.
Focus on Strategic Alignment:
First principle: your KPIs should mirror what the business cares about from procurement. So, clarify procurement’s role in your company’s strategy. Is it mainly cost savings to improve margins? Is it ensuring no production downtime (supply continuity)? Supporting innovation? A mix of all?
Let’s assume a balanced view: savings, efficiency, and risk management. We’ll pick KPIs that cover these:
- Financial KPIs: e.g., Cost Savings Achieved, Cost Avoidance, Procurement ROI as discussed earlierrosslyn.ai.
- Operational KPIs: e.g., Cycle Times, Spend Under Management, PO Compliance Rate (what % of spend goes through proper PO process).
- Risk/Quality KPIs: e.g., On-time Delivery %, Supplier Defect Rate, maybe % of spend with preferred suppliers (assuming preferred means vetted quality).
- Strategic KPIs: e.g., Innovation contributions (like number of innovation ideas from suppliers adopted) or Sustainability metrics (if that’s key, like % of spend with sustainable suppliers).
Don’t overload though. A rule of thumb is maybe 5-7 core KPIs on a dashboard. You can have drill-downs to more detail behind them.
Top 5 Must-Have Procurement KPIs: (these align with many org’s priorities)
- Realized Savings (% and $): This is arguably the headline metric for most – how much money did procurement save the company (after implementation, not just negotiated). It can be broken by category or project. Display as YTD against target, plus as % of addressed spend. E.g., “$2M savings achieved YTD, 80% of FY target of $2.5M.”
- Spend Under Management (SUM): The portion of total spend that procurement actively managed. If it’s trending up, good (means less maverick spend). Show as percentage and maybe the $ out of total spend. E.g., “SUM = 85%, up from 70% last year” – a great story if achieved.
- PO Cycle Time (Requisition to Order): Efficiency metric – average days or hours. Possibly segmented by category or priority. If your strategy is to be more agile, you want this visible and improving. E.g., “Average PO cycle: 3.2 days vs goal of 5 days (target met).”
- On-Time Delivery (from Suppliers): Assuming procurement also cares about delivery performance, track the percentage of POs delivered on or before promised date. This often involves collaboration with operations, but procurement can influence through supplier selection and expediting. E.g., “On-time delivery: 95% this quarter (goal 98%).” If below goal, you know to check what’s up with those suppliers.
- Procurement ROI: As earlier, a single figure showing return (savings vs cost). This may be more annual, but a year-to-date ROI can be shown. E.g., “Procurement ROI: 5.4x.” It synthesizes cost-effectiveness of the function.
Other Useful KPIs: (choose based on focus)
- Compliance Rate: If there is a policy to use certain contracts or processes, measure compliance. For example, Contract Compliance (% of spend on contract vs off). If low in certain areas, that’s an actionable insight.
- Supplier Concentration/Risk Index: Perhaps a metric like “% of spend with single-sourced suppliers” or a risk score combining various risk inputs to show supply base risk level.
- Procurement Cycle Time: Not just POs, but strategic project cycle – e.g., how long to complete a sourcing project or to onboard a supplier.
- Internal Satisfaction: maybe through periodic surveys, create a KPI like “Internal Client Satisfaction score: 4.3/5” trending over time.
- Automation Level: e.g., “% of POs that are touchless” (if your system auto-generates POs from requisitions or auto-approves certain).
- Diversity or Sustainability Spend: if relevant, e.g., “% of spend with diverse suppliers” or “CO2 emissions in supply chain reduced X%”.
These are more specialized; include if they matter to company goals.
Designing the Dashboard:
Use visuals:
- A gauge or thermometer for savings vs target works well.
- A pie for Spend Under Management (managed vs unmanaged).
- A line chart for cycle time trending by month (to see improvement or slippage).
- A bar chart for on-time delivery by top 5 suppliers (to pinpoint who’s causing lateness).
Color code: e.g., green if meeting target, red if below. This quick RAG status helps execs scan quickly.
Make it interactive if using a tool like Power BI/Tableau: so you can filter by business unit or category on the fly when presenting. For instance, overall on-time might be 95%, but one plant is 80% – being able to slice that is valuable.
Include brief commentary with KPIs, perhaps in notes: e.g., “Savings YTD lower due to project X delay; expecting catch-up in Q4.” That context prevents misinterpretation.
Avoid Common Pitfalls:
- Vanity Metrics: Don’t include metrics that look good but don’t drive action. E.g., number of POs processed – unless you tie it to efficiency or workload story, it’s just volume. Or “number of suppliers” by itself isn’t a performance measure (though reducing it could be a goal).
- Too Many Metrics: A cluttered dashboard loses focus. The audience needs to know what to pay attention to (if everything is there, they may focus on wrong thing or get overwhelmed). Better to have a concise main dashboard and then supplementary pages for those who want detail.
- Not Updating Regularly: If you show outdated data or miss monthly refreshes, credibility drops. Automate data feeds if possible so it’s always up-to-date with minimal manual effort.
- Misaligned Targets: Ensure you set realistic yet stretching targets for each KPI. If your on-time is 90% and industry best is ~98%, maybe set 95% as goal for year. If targets are either too easy (all green always) or impossible (all red always), they won’t motivate the team or inform management properly.
- No Accountability: Each KPI should have an owner (maybe category managers for savings, procurement ops for cycle time, etc.). In team meetings, review them and assign actions when off-target. Dashboard should lead to “what will we do about this?” discussions.
Example Dashboard Walk-through:
Imagine you’re in a meeting with the COO reviewing the procurement dashboard:
- You show the Savings gauge: It’s at 60% of annual target by mid-year, slightly under the ideal 66%. The gauge is amber. You explain it: “We’re at $3M savings, a bit behind the $3.3M mid-year run-rate. Two big sourcing projects are concluding in Q3 which will likely put us ahead by next update.”
- Spend Under Management pie: 80% managed vs 20% unmanaged. It’s green as it hit the year’s goal of 80%. COO sees that and maybe asks, “What’s in the 20% unmanaged?” You click to show a breakdown (could list top areas of unmanaged spend – maybe legal services, some marketing spend). You discuss plan to tackle those categories through new sourcing initiatives or policies.
- PO Cycle Time line: Shows January was 10 days, steadily improved to 4 days by June after system changes. It’s green compared to target 5 days. That’s a win; you might highlight how interdepartmental coordination improved to achieve it.
- On-Time Delivery bar chart for key suppliers: 4 suppliers are ~98%, but one (supplier C) is 85%. That bar is red. COO: “That’s a problem, what are we doing?” You respond, “Supplier C had issues due to a factory move; we’ve been working closely and they’ve committed to recovery plan. If they don’t improve by next quarter, we are qualifying a backup supplier.” This shows the value of tracking – it triggered action.
- Procurement ROI: It’s shown as 500% (which is 5x). Maybe no target needed, but trending compared to last year (was 400%). It’s green/upwards. That’s a bragging point: “We’ve increased our ROI by doing more with same cost or delivering more savings.”
The COO leaves knowing procurement is largely on track, with a few areas to watch. The dashboard facilitated a focused conversation on performance and next steps, rather than diving into weeds or guessing.
Conclusion:
Selecting the right KPIs is about understanding what outcomes procurement must deliver and what behaviors to encourage. Keep the dashboard user-centric: if it’s for top management, high-level and outcome-focused; if an internal operational dashboard, maybe more granular. Possibly have layers – a summary for execs, detail for procurement team’s use.
Remember that KPIs can evolve. Review annually if some metric is no longer useful or if new business priorities emerge (e.g., suddenly supply chain sustainability becomes core – then you’ll add a KPI for that).
A well-crafted dashboard becomes a decision-making tool, not just a report. It should prompt questions, celebrate successes, and flag issues early. By focusing on a handful of meaningful KPIs and presenting them clearly, you’ll ensure procurement’s performance is transparent and actionable. And when procurement performance is clear, it’s much easier to demonstrate value to the organization – and to continuously improve it.