Supply Chain & InventoryFree referencePDF, Excel, Word export

Procurement KPI Formulas and Definitions

Procurement teams are judged on a handful of ratios, but each one hides a definition choice. This reference lists the common KPIs with a plain formula, the unit, which direction is good and the ERP data needed to compute it.

Download:

KPI	Formula	Unit	Good direction	ERP data needed
On-time delivery (OTD)	PO lines received on or before promise date / PO lines due in period	%	Higher	PO line promise date, receipt date
In-full delivery (IF)	PO lines received at or above ordered quantity within tolerance / lines due	%	Higher	PO line quantity, received quantity
OTIF	Lines both on time and in full / lines due in period	%	Higher	Promise date, receipt date, quantities
Purchase price variance (PPV)	(Actual price - standard price) x quantity received	currency	Lower (negative is favourable)	PO price, item standard cost, receipt quantity
PPV percent	PPV / (standard price x quantity received) x 100	%	Lower	Same as PPV
Spend under management	Spend covered by contracts or managed categories / total addressable spend x 100	%	Higher	Spend by category, contract flag
Contract compliance	Spend on contracted suppliers and prices / spend in contracted categories x 100	%	Higher	PO lines, contract or agreement reference
Maverick (off-contract) spend	Spend with no PO or contract / total spend x 100	%	Lower	Invoices without PO, spend by supplier
Hard cost savings	(Previous price - new price) x annual volume	currency	Higher	Price history, volume forecast
Cost avoidance	(Supplier's requested price - negotiated price) x annual volume	currency	Higher (report separately from savings)	Quotes, final price, volume
Requisition to PO cycle time	Average days from approved requisition to PO issue	days	Lower	Requisition and PO timestamps
PO cycle time	Average days from PO creation to PO release or approval	days	Lower	PO created and released dates
Purchase order lines per buyer	PO lines issued in period / number of buyers	lines	Balanced workload	PO lines, buyer ID
Three-way match rate	Invoices matching PO and receipt without exception / invoices processed x 100	%	Higher	Invoice match status
Supplier defect rate (PPM)	Rejected pieces / pieces received x 1,000,000	PPM	Lower	Receiving inspection results
Supplier lead time	Average days from PO date to receipt date	days	Lower and stable	PO date, receipt date
Lead time variability	Standard deviation of actual lead time per supplier or item	days	Lower	PO date, receipt date history
Spend concentration	Spend with top N suppliers / total spend x 100	%	Depends on risk policy	Spend by supplier
Supplier count per category	Count of active suppliers with spend in the category	count	Lower within risk limits	Vendor master, spend
Days payable outstanding (DPO)	Average accounts payable / cost of goods sold x days in period	days	Higher within terms	AP balance, COGS
Early payment discount capture	Discounts taken / discounts available x 100	%	Higher	Invoice terms, payment date
Expedite rate	PO lines expedited or air freighted / PO lines received x 100	%	Lower	Expedite flag, freight mode
Cost of procurement	Procurement department cost / total spend managed x 100	%	Lower	Departmental cost, spend
Perfect order rate	Orders on time, in full, damage free and with correct documents / total orders x 100	%	Higher	Receipt, quality and document flags

Definitions vary by company. Write the exact formula, the period and the data source next to every KPI you publish, and report savings and cost avoidance separately.

KPI queries for your ERP

Optional: send us your ERP and we will outline how each KPI maps to your purchasing tables.

Optional. The tool and every export work without this. No spam.

How to use the list

Search for the KPI you must report, copy the formula into your reporting tool, and check that every data field exists in your ERP. Agree the definition with finance before the first report, because a metric that changes meaning each quarter is worthless. Choose six to ten KPIs across four groups: delivery, cost, quality and process efficiency. Too many KPIs dilute buyer attention.

Delivery: OTD, IF, OTIF, lead time and variability
Cost: PPV, savings, cost avoidance, early payment capture
Quality: PPM, three-way match rate, perfect order rate
Process: cycle times, maverick spend, spend under management

Definition traps to avoid

OTD depends on which date you measure against: the original request date, the supplier's confirmed date or a re-promised date. Measuring against a date the supplier chose last week makes performance look better than your plant experienced. PPV depends on how standard cost is set, so a stale standard produces noise unrelated to buying skill. Savings should be counted against a documented baseline, and cost avoidance should never be added into the savings total reported to finance.

Turning KPIs into action

A KPI is useful only if someone owns a response when it moves. Set a threshold, a named owner and a review rhythm for each. A rising expedite rate with stable OTD often means buyers are hiding late supply by paying for freight. A falling three-way match rate points to receiving discipline or price file errors, not to supplier behaviour. Pair price metrics with delivery and quality so that a cheaper supplier is not rewarded for worse performance.

Frequently Asked Questions

What is the difference between cost savings and cost avoidance?

Savings are a reduction from the price you paid before, so they show up in the budget. Cost avoidance is the increase you prevented, for example negotiating a supplier's requested ten percent rise down to three. Finance rarely accepts avoidance as savings, so report the two separately.

How do I calculate OTIF?

Count PO lines received on or before the promise date and at or above the ordered quantity within tolerance, then divide by all lines due in the period. A line that fails either test counts as a miss. Agree the tolerance window and which date you measure against before publishing.

What is a good maverick spend percentage?

It depends on category and industry, so avoid chasing a universal number. Many teams track it by trend and target the largest off-contract categories first. Some off-PO spend, such as utilities, is legitimate, so exclude those categories from the denominator and document the rule.

Which KPIs matter most for a small buying team?

Start with OTIF, PPV percent, expedite rate and requisition to PO cycle time. They are cheap to compute from standard ERP data and cover delivery, cost and process. Add supplier PPM and spend under management once the first four are trusted.

If these KPIs are rebuilt in spreadsheets every month, Netray can help compute them directly from your ERP purchasing tables with the query shown and role-based access.

Talk to an Expert Explore More Free Tools

Related Tools

Supply Chain & Inventory

More Supply Chain & Inventory tools

See all

Back to All Tools