Supply Chain & InventoryFree referencePDF, Excel, Word exportWholesale Distribution

Distribution KPI Formula Reference for Distributors and ERP Reports

Distributors measure the same dozen ideas under slightly different names, and the arguments in a monthly review are usually about definitions, not performance. This reference lists the common distribution KPIs with their formula, unit and the data trap that most often skews them.

Download:

KPI	Formula	Unit	Good direction	Common data trap
Line fill rate	Order lines shipped complete on first ship / total order lines	Percent	Higher	Decide whether partial shipments count as filled
Order fill rate	Orders shipped complete / total orders	Percent	Higher	Much stricter than line fill, do not compare the two
Unit fill rate	Units shipped / units ordered	Percent	Higher	Cancelled quantity must be excluded from the denominator or flagged
On-time in-full (OTIF)	Orders or lines both on time and complete / total	Percent	Higher	Compare against promise date or request date, not both
Inventory turns	Annual cost of goods sold / average inventory at cost	Times per year	Higher	Use average inventory, not a single month-end snapshot
Days of supply	On-hand quantity / average daily usage	Days	Within target band	Seasonal items need a forward-looking usage figure
Days inventory outstanding	Average inventory / COGS x 365	Days	Lower	Includes obsolete stock that distorts the average
GMROI	Gross margin dollars / average inventory at cost	Ratio	Higher	Margin and inventory must cover the same period and items
Gross margin percent	(Sales - cost of goods sold) / sales	Percent	Higher	Rebates and freight treatment change the answer
Markup percent	(Sales - cost) / cost	Percent	Higher	Often confused with margin percent
Dead stock percent	Inventory value with no sale in 12 months / total inventory value	Percent	Lower	Choose the look-back window and keep it fixed
Stockout rate	Demand lines hitting zero available / total demand lines	Percent	Lower	Needs demand captured even when stock was zero
Backorder rate	Backordered lines / total lines ordered	Percent	Lower	Release date matters when you compare periods
Perfect order rate	On time x complete x damage free x correct documents	Percent	Higher	Multiplying four measures drops the result sharply
Return rate	Returned lines or value / shipped lines or value	Percent	Lower	Separate vendor-error returns from customer-choice returns
Days sales outstanding (DSO)	Accounts receivable / credit sales x days in period	Days	Lower	Cash and counter sales must be excluded
Days payable outstanding (DPO)	Accounts payable / COGS x days in period	Days	Within vendor terms	Early-pay discounts change the target
Cash conversion cycle	DIO + DSO - DPO	Days	Lower	All three inputs need the same period basis
Order lines per pick hour	Lines picked / direct picking hours	Lines per hour	Higher	Include only direct labor hours
Cost to serve per order	(Handling + freight + admin cost) / orders	Currency per order	Lower	Allocation rules drive the result
Sales per square foot	Net sales / warehouse or branch square feet	Currency per sq ft	Higher	Use usable selling or storage area consistently
Vendor on-time delivery	Receipts on or before promise date / total receipts	Percent	Higher	Promise date edits after the fact hide misses
Inventory accuracy	Locations matching count / locations counted	Percent	Higher	Tolerance rules differ for high-value items
Carrying cost rate	Capital + storage + insurance + shrink + obsolescence / average inventory	Percent per year	Lower	Many sites forget obsolescence and shrink

Definitions vary by company. Write down your own numerator, denominator and period rules before you publish a KPI, and keep them fixed from month to month.

Want these KPIs computed from your ERP data?

Send us the KPIs you care about and we can show how they could be calculated read-only over your own distribution data.

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

How to use the reference

Search for a KPI name or a word from the formula, then copy the definition into your report specification. Decide the period, the item scope and the treatment of cancelled or returned quantity before anyone builds the report. Write the decision beside the KPI so the next analyst does not redefine it. Export the table to Excel to use as the data dictionary of your dashboard project.

Search by KPI name, formula word or unit
Copy the formula into the report spec
Record the period and scope rule next to each KPI
Review definitions once a year, not every month

Service level versus financial KPIs

Service KPIs such as line fill rate, OTIF and backorder rate describe what the customer felt. Financial KPIs such as GMROI, turns and gross margin describe what the stock cost you. A distributor can push fill rate to the high nineties by overstocking, and the financial KPIs will show the price. Always read one service KPI together with one inventory KPI so that a change in one is checked against the other.

Worked example

A branch has 4,000 order lines in a month and 3,700 ship complete on first ship, so line fill is 92.5 percent. The same branch holds an average of 900,000 in inventory at cost and sells goods with a cost of 5.4 million over the year, so turns are 6.0 and days inventory outstanding is about 61. If gross margin dollars for the year are 1.35 million, GMROI is 1.5. Together these say the branch is serving well but carrying a moderate amount of stock for the margin it earns.

Where the numbers come from in an ERP

Most distribution ERPs hold order lines, shipment confirmations, inventory balances by location and invoice history in separate tables, so each KPI is a join across them. Fill rate needs the requested and shipped quantity on the same line. Turns need a month-end inventory history, which some systems do not keep unless a snapshot job runs. Check that history exists before you promise a trend chart.

Frequently Asked Questions

What is the difference between fill rate and OTIF?

Fill rate measures whether the quantity ordered was available and shipped. OTIF adds a time test, so an order must be complete and also arrive on or before the agreed date. OTIF is always equal to or lower than fill rate for the same orders.

Is GMROI better than inventory turns?

They answer different questions. Turns show how fast stock moves, while GMROI shows how much gross margin each dollar of inventory earns. A slow item with a high margin can have good GMROI and poor turns, so most distributors watch both.

Which period should I use for turns?

Use a trailing twelve months of cost of goods sold over the average of month-end inventory for the same twelve months. Short periods swing with seasons and large receipts, so annualizing one month is risky.

Do these formulas match my ERP standard reports?

Not always. ERP standard reports apply their own rules for cancelled quantity, returns and transfers. Compare one branch and one month by hand against your ERP report before you trust a new dashboard.

If these KPIs live in several ERP screens and spreadsheets today, we can help you build a single read-only view over your own data, with the query shown for every number.

Talk to an Expert Explore More Free Tools

Related Tools

Supply Chain & Inventory

More Supply Chain & Inventory tools

See all

Back to All Tools