Seven procurement KPIs can connect supplier performance, inventory availability and cash decisions. They work only when their units, time windows and baselines are explicit. A dashboard should preserve an original commitment as well as the latest accepted change; otherwise a supplier can appear perfectly on time simply because the promised date keeps moving.
The seven measures
KPI
Calculation
Decision it supports
Purchase price variance
(Baseline unit price − actual unit price) × comparable quantity
Investigate price changes and invoice differences
OTIF
Orders complete within the agreed window ÷ orders due × 100
Review delivery reliability
Lead-time reliability
Distribution of elapsed time from order release to usable receipt
Plan order timing and buffers
Inventory turnover
Period COGS ÷ average inventory at cost
Review stock investment and movement
Days of cover
Read before ordering
A dense operator briefing for teams that need sharper buying, cleaner supplier follow-up, and fewer expensive surprises.
Usable on-hand units ÷ expected daily usage
Identify near-term shortage risk
Cash conversion cycle
DIO + DSO − DPO
Understand inventory, receivable and payable timing
GMROI
Period gross profit ÷ average inventory at cost
Compare gross profit earned against inventory investment
These are operational definitions for this guide. Agree on them with the buyer, receiver and finance owner before comparing locations or suppliers. Targets should follow your service requirements and baseline; there is no universal safe threshold for every restaurant, retailer or manufacturer.
1. Purchase price variance: keep the comparison fair
This guide uses positive PPV for a favorable variance: you paid less than the baseline. Some accounting reports use the opposite sign, so label it.
For an illustrative 100 units ordered at $5 and invoiced at $5.20, PPV is (5 − 5.20) × 100 = −$20. The adverse variance is 4% of the $500 expected spend. It is not automatically a four-percentage-point change in the business's gross margin, whose denominator is revenue.
Use the same unit, currency and scope of charges in both prices. Preserve the original PO price and approved revisions separately. An approved increase may produce no invoice exception while still increasing cost against the original plan. Investigate the cause rather than treating every unfavorable variance as supplier misconduct.
2. OTIF: define the window and the denominator
If 18 of 20 orders due in a period arrive complete within the agreed receiving window, OTIF is 90%. An order that is on time but short fails; an order that is complete but late also fails.
Define treatment of cancellations, split shipments, substitutions and early deliveries before counting. Keep the originally agreed window and later accepted commitments so the report can distinguish reliability against the first promise from performance against a revised plan.
OTIF is not unit fill rate. A 90% OTIF result does not mean 10% of units were missing. It also does not imply that safety stock should increase by 10%. Review the actual shortage and delay patterns, demand and usable backup supply.
3. Lead-time reliability: show the distribution
Track order-release time, expected receipt and actual usable receipt. If inspection holds stock after arrival, include that delay where it affects availability. For partial orders, report first usable receipt and completion separately.
A single average can hide the late tail. Compare a range and suitable percentiles with recent quoted lead times. A new supplier commitment may be more relevant than older history after a route or production change, so investigate before replacing an input mechanically.
The basic reorder point is expected demand during lead time plus safety stock. A model using variable demand, variable lead times or intermittent sales needs corresponding assumptions; a service metric alone does not supply the buffer.
4. Inventory turnover: use a period and a cost basis
An illustrative business with $240,000 of annual COGS and $40,000 average inventory at cost has 6 annual turns. Beginning and ending balances provide a rough average; regular snapshots better represent a seasonal business.
Low turns can reflect overbuying, declining demand, deliberate seasonal stock, high supplier minimums or a slow-moving assortment. High turns can accompany strong sales or insufficient stock. Pair the measure with availability and margin before changing orders.
5. Days of cover: a planning estimate
With 60 usable units and expected usage of 10 units per day, nominal cover is six days. Subtract stock already committed to another purpose where appropriate. Include incoming stock only in a dated projection, not as stock already on the shelf.
Zero recent usage does not create a meaningful infinite-stock recommendation. New, intermittent and seasonal items need a different forecast or a manual planning assumption.
For perishables, project consumption and expected losses through time and respect each lot's actual usable deadline. Multiplying today's stock by a decay factor at expiry and dividing by daily demand is not a general solution for days of cover. A planning decay estimate is not a food-safety rule or permission to use expired stock.
6. Cash conversion cycle: identify which component changed
CCC combines days inventory outstanding, days sales outstanding and days payable outstanding. Use consistent periods and finance-approved balances. Procurement directly affects inventory and supplier terms; customer collections can move independently.
The cash effect depends on the component. For example, reducing inventory by ten days at an annual COGS run rate of $2 million corresponds to approximately $2,000,000 ÷ 365 × 10 = $54,795 less inventory at cost, assuming the run rate remains applicable. A ten-day improvement in customer collections instead uses the relevant credit-sales basis. Do not multiply every CCC movement by COGS.
This is cash released from working capital, not recurring profit. Separate any resulting financing-cost change from the release itself.
7. GMROI: gross profit, not net return
If annual gross profit is $80,000 and average inventory at cost is $40,000, GMROI is 2.0: two dollars of gross profit per dollar of average inventory. This definition matches Shopify's GMROI explanation.
A GMROI below 1.0 means gross profit was below average inventory investment for the period. It does not establish that carrying cost exceeded gross profit; carrying costs and operating expenses must be assessed separately. Compare similar categories and periods, then examine price, mix, cost and turnover together.
Make the review actionable
Start with one supplier and one category. Check ten underlying records against the report before trusting the aggregate. Assign each exception an owner, evidence and next action. Keep a separate list of missing or unverified data so completeness is visible.
LineNow's procurement workflow connects supplier orders, replies and receiving records that support these analyses. Financial measures also depend on finance records and integration scope. Confirm the available reports and inputs in your setup; a connected PO does not by itself establish complete receivables, payables or a verified financial close.
