Manufacturing KPI Formula and Definitions Reference
Most KPI arguments in a management meeting are really definition arguments. This reference lists the formulas for the manufacturing and finance KPIs controllers and operations managers use most, with the unit, the ERP data that normally feeds each one, and a sensible review cadence.
| KPI | Area | Formula | Unit | Typical ERP source | Review cadence |
|---|---|---|---|---|---|
Inventory turns | Inventory | Annual COGS / Average inventory value | turns per year | GL COGS, inventory valuation | Monthly |
Days inventory outstanding | Inventory | Average inventory value / COGS x days in period | days | GL COGS, inventory valuation | Monthly |
Days sales outstanding | Finance | Accounts receivable / Credit sales x days in period | days | AR aging, invoices | Monthly |
Days payables outstanding | Finance | Accounts payable / COGS x days in period | days | AP aging, GL COGS | Monthly |
Cash conversion cycle | Finance | DIO + DSO - DPO | days | Derived from DIO, DSO, DPO | Monthly |
Gross margin percent | Finance | (Revenue - COGS) / Revenue x 100 | percent | GL revenue and COGS | Monthly |
Contribution margin | Finance | Revenue - Variable costs | currency | Costing, sales | Monthly |
On time delivery | Delivery | Lines shipped on or before promise date / Lines due x 100 | percent | Sales order lines, shipments | Weekly |
Fill rate (line) | Delivery | Lines shipped complete from first allocation / Lines ordered x 100 | percent | Sales order lines | Weekly |
Order backlog | Delivery | Sum of open order value not yet shipped | currency | Open sales order lines | Weekly |
Overall equipment effectiveness | Production | Availability x Performance x Quality | percent | MES, labor and machine reporting | Daily or per shift |
First pass yield | Quality | Units passing first time / Units started x 100 | percent | Inspection results, production reporting | Daily |
Scrap rate | Quality | Scrap quantity / (Good quantity + Scrap quantity) x 100 | percent | Production completions, scrap transactions | Daily |
Schedule attainment | Production | Jobs completed on schedule / Jobs scheduled x 100 | percent | Work orders, routing | Daily or weekly |
Manufacturing cycle time | Production | Job finish date - Job release date | days | Work order dates | Weekly |
Labor efficiency | Production | Standard hours earned / Actual hours worked x 100 | percent | Labor reporting, routing standards | Weekly |
Throughput per labor hour | Production | Units produced / Direct labor hours | units per hour | Production completions, labor | Weekly |
Purchase price variance | Purchasing | (Actual price - Standard price) x Quantity received | currency | Receipts, item standard cost | Monthly |
Supplier on time delivery | Purchasing | PO lines received by due date / PO lines due x 100 | percent | PO lines, receipts | Monthly |
Inventory accuracy | Inventory | Locations counted correctly / Locations counted x 100 | percent | Cycle count results | Monthly |
Excess and obsolete percent | Inventory | E&O inventory value / Total inventory value x 100 | percent | Inventory valuation, usage history | Quarterly |
Forecast accuracy (MAPE based) | Planning | 100 - Mean absolute percentage error | percent | Forecast and actual demand | Monthly |
Warranty cost percent of sales | Quality | Warranty cost / Revenue x 100 | percent | Service claims, GL | Quarterly |
Revenue per employee | Finance | Annual revenue / Average headcount | currency | GL revenue, HR headcount | Quarterly |
Formulas are common textbook definitions. Your company may define a KPI differently (for example fill rate by units instead of lines). Write down your definition before publishing a dashboard.
Want these KPIs computed straight from your ERP?
Optional: send us your ERP and we will show how a read-only layer can produce these KPIs with the query visible.
Optional. The tool and every export work without this. No spam.
How to use this reference
Search by KPI name, area or ERP source, then copy the formula into your KPI definition document. Export the filtered table to Excel to start a KPI catalogue. For each KPI you adopt, add an owner, a target, the exact filter rules (which order types, which plants) and the date field used. The table gives the common starting point, not your final definition.
- Filter by area to build a plant, finance or supply chain scorecard
- Use the ERP source column to find which tables or reports to query
- Keep one definition per KPI and publish it next to the dashboard
Where definitions diverge
Inventory turns can use COGS or sales in the numerator, and average inventory can be a two point or twelve point average. On time delivery can compare to the customer request date, the promise date or the original quote date, and can count lines, orders or value. Fill rate can be measured by line, unit or order. Pick one and state it, because switching mid year makes trends meaningless.
Reading the cadence column
Fast KPIs such as scrap rate, schedule attainment and OEE are useful daily because the shop floor can still act on them. Financial ratios such as DIO and gross margin only settle after close, so a monthly rhythm is enough. Reviewing a slow KPI daily only adds noise. A KPI nobody can influence within its review period should move to a longer cadence.
Common mistakes
Averaging percentages across plants instead of recomputing from totals, mixing currencies without a fixed rate, including intercompany sales, and counting partial shipments as late or on time inconsistently are the usual causes of numbers that fail audit. Always compute ratios from summed numerators and denominators.
Frequently Asked Questions
Are these the only correct formulas?
No. They are common definitions. Industry, customer contracts and accounting policy can change them, for example using sales instead of COGS for turns. What matters is writing down one definition and applying it consistently.
Which KPIs should a controller track first?
Gross margin, DIO, DSO, DPO and the cash conversion cycle give a quick view of working capital. Add inventory turns and purchase price variance for manufacturers, then operational KPIs the plant already measures.
How many KPIs are too many?
A plant dashboard rarely stays useful beyond about 8 to 12 measures. More than that and no one owns them. Keep a catalogue of all definitions but show only the few that drive decisions this period.
Can I export this list?
Yes. The table exports to Excel, CSV and PDF, so you can use it as the starting point of a KPI catalogue and add owners, targets and ERP report names.
If these KPIs live in several ERP reports and spreadsheets, Netray can build one governed set of definitions over your ERP data, read-only and on your own infrastructure.
Related Tools
Manufacturing Cost Variance Types Reference
A searchable table of purchase, material, labor, overhead and revenue variances with formulas, owners and first checks.
ERP OperationsERP KPI Governance Maturity Assessment
Score how consistent, documented and trusted your KPIs are, and get next steps matched to your maturity band.
Costing & FinancePrice, Volume and Cost Margin Variance Calculator
Enter budget and actual units, price and unit cost to see how much of the margin gap came from price, volume and cost.
ERP OperationsERP Report Specification Template
A clean specification document for requesting a report from IT or a consultant, covering purpose, filters, calculations and acceptance tests.
More Costing & Finance tools
See all- Month End Reporting Readiness Checklist for Manufacturers
- OEE Improvement Value Calculator
- Improve OEE vs Buy a New Machine Calculator
- Six Sigma Project Savings Tracker Worksheet
- Should Cost Model Worksheet for Machined Parts
- Quote Assumptions and Exclusions Template
- Tooling and NRE Amortization Quote Worksheet
- Subcontract and Outside Processing Cost Worksheet
- Overhead Cost Pool Allocation Worksheet