Discrete ManufacturingFree referencePDF, Excel, Word exportDiscrete Manufacturing

Manufacturing KPI Formula Reference

People look up the same manufacturing formulas again and again: OEE, first pass yield, turns, takt time. This table collects the standard forms in one place, with the unit and the ERP or MES source that usually feeds each one.

Download:

KPI	Area	Formula	Unit	Typical ERP or MES source
On-time delivery (OTD)	Delivery	Lines shipped on time / lines shipped x 100	%	Shipment lines vs promise date
OTIF	Delivery	Lines on time and in full / lines shipped x 100	%	Shipment lines, ordered vs shipped qty
Order fill rate	Delivery	Quantity shipped from stock / quantity ordered x 100	%	Sales order lines
Backlog	Delivery	Sum of open order line value not yet shipped	currency	Open sales order report
OEE	Flow	Availability x Performance x Quality	%	MES or machine data
Availability	Flow	Run time / planned production time	%	MES downtime log
Performance	Flow	(Ideal cycle time x total count) / run time	%	MES counts and standards
Takt time	Flow	Available production time / customer demand	time per unit	Demand forecast, shift calendar
Cycle time	Flow	Time to complete one unit at a station	time per unit	Routing, MES
Throughput	Flow	Units completed / time period	units per period	Production reporting
Schedule adherence	Flow	Jobs completed on scheduled date / jobs scheduled x 100	%	Work order dates
First pass yield (FPY)	Quality	Units passing first time / units started x 100	%	Inspection or MES counts
Rolled throughput yield	Quality	Product of FPY at each process step	%	Step level inspection
Scrap rate	Quality	Scrap quantity / total quantity produced x 100	%	Production reporting, scrap transactions
Defects per million opportunities (DPMO)	Quality	Defects / (units x opportunities per unit) x 1,000,000	count	Inspection records
Customer returns rate	Quality	Units returned / units shipped x 100	%	Returns and RMA records
Inventory turns	Inventory	Cost of goods sold / average inventory	turns per year	Income statement, inventory valuation
Days inventory outstanding (DIO)	Inventory	Average inventory / COGS x days in period	days	Inventory valuation, COGS
Inventory accuracy	Inventory	Locations counted correct / locations counted x 100	%	Cycle count results
Cash conversion cycle	Finance	DIO + DSO - DPO	days	Inventory, AR and AP balances
Purchase price variance (PPV)	Cost	(Actual price - standard price) x quantity received	currency	Purchase receipts, item standard cost
Labor efficiency	Cost	Standard hours earned / actual hours worked x 100	%	Labor reporting, routings
Gross margin	Finance	(Revenue - COGS) / Revenue x 100	%	General ledger
Supplier on-time delivery	Supply	Receipts on or before due date / receipts x 100	%	Purchase order receipts
Supplier defect rate (PPM)	Supply	Rejected units / received units x 1,000,000	PPM	Receiving inspection
Maintenance MTBF	Maintenance	Operating time / number of failures	hours	Maintenance work orders
Maintenance MTTR	Maintenance	Total repair time / number of repairs	hours	Maintenance work orders

Formulas are standard textbook forms. Your company may define exclusions or windows differently, so record yours in a KPI definition sheet.

Compute these KPIs from your ERP

Optional: we can review which KPIs your ERP data can support and outline the queries.

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

How to use the reference table

Type a KPI name or an area in the search box to filter the table. Each row shows the formula in words, the unit and the typical source system. Export it to Excel or CSV to paste into your own KPI definitions. These are the textbook versions, which are the right starting point for most plants. If your customers or your auditors specify a variant, document it separately rather than editing the standard formula in place.

How the KPIs fit together

Delivery measures show what the customer feels. Flow and quality measures explain why: OEE combines availability, performance and quality, and rolled throughput yield shows how losses compound across steps. Inventory and cash measures show the financial cost of the way you run, linked by the cash conversion cycle. Choose a small set across these areas rather than many in one, so the dashboard shows cause and effect.

OEE = Availability x Performance x Quality
Rolled throughput yield multiplies step yields
Cash conversion cycle = DIO + DSO - DPO

Where the data lives

Delivery and backlog live in sales order and shipment lines. Flow data comes from MES or from labor and production reporting in the ERP. Quality needs inspection results or scrap transactions. Inventory comes from valuation and cycle count tables. Cost variances come from receipts compared with standard cost. Not every ERP stores each in the same way, so confirm the actual table or report once and record it.

Common mistakes

Averaging percentages across plants rather than recomputing from totals, using revenue where the formula wants cost of goods sold, and changing the measurement window without telling anyone. With OEE, mixing planned downtime into availability on one line but not another makes comparison meaningless. Always write the exclusions beside the formula.

Frequently Asked Questions

What is the OEE formula?

OEE is availability multiplied by performance multiplied by quality. Availability is run time over planned production time, performance compares ideal and actual output rates, and quality is good units over total units.

How is first pass yield different from yield?

First pass yield counts only units that passed without rework or retest. Overall yield may include units that passed after rework, so it can look better than FPY and hide hidden factory cost.

What is takt time?

Takt time is available production time divided by customer demand for the same period. It is the pace at which you must produce to meet demand, and it is different from cycle time, which is the time a station actually takes.

Can I add my own KPIs to this table?

This table is read-only. Export it to Excel, add your own rows and use the KPI definition template to record the formula, source and owner for any KPI that is specific to your business.

If you want these KPIs computed from live ERP data by plant and product family, Netray can help build the queries read-only and keep the definitions consistent.

Talk to an Expert Explore More Free Tools

Related Tools

ERP Operations

More Discrete Manufacturing tools

See all

Back to All Tools