# Manufacturing KPI Formula and Definitions Reference > Source: https://netray.co/tools/manufacturing-kpi-formula-definitions-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A searchable lookup of the KPI formulas controllers and operations managers argue about, with units, typical ERP source and review cadence. ## Category cost-finance ## Industry Discrete Manufacturing ## Audience - Controller - Operations manager - Plant manager - ERP analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### KPI **Key:** kpi **Type:** text #### Area **Key:** area **Type:** text #### Formula **Key:** formula **Type:** text #### Unit **Key:** unit **Type:** text #### Typical ERP source **Key:** source **Type:** text #### Review cadence **Key:** cadence **Type:** text **Rows:** **Kpi:** Inventory turns **Area:** Inventory **Formula:** Annual COGS / Average inventory value **Unit:** turns per year **Source:** GL COGS, inventory valuation **Cadence:** Monthly **Kpi:** Days inventory outstanding **Area:** Inventory **Formula:** Average inventory value / COGS x days in period **Unit:** days **Source:** GL COGS, inventory valuation **Cadence:** Monthly **Kpi:** Days sales outstanding **Area:** Finance **Formula:** Accounts receivable / Credit sales x days in period **Unit:** days **Source:** AR aging, invoices **Cadence:** Monthly **Kpi:** Days payables outstanding **Area:** Finance **Formula:** Accounts payable / COGS x days in period **Unit:** days **Source:** AP aging, GL COGS **Cadence:** Monthly **Kpi:** Cash conversion cycle **Area:** Finance **Formula:** DIO + DSO - DPO **Unit:** days **Source:** Derived from DIO, DSO, DPO **Cadence:** Monthly **Kpi:** Gross margin percent **Area:** Finance **Formula:** (Revenue - COGS) / Revenue x 100 **Unit:** percent **Source:** GL revenue and COGS **Cadence:** Monthly **Kpi:** Contribution margin **Area:** Finance **Formula:** Revenue - Variable costs **Unit:** currency **Source:** Costing, sales **Cadence:** Monthly **Kpi:** On time delivery **Area:** Delivery **Formula:** Lines shipped on or before promise date / Lines due x 100 **Unit:** percent **Source:** Sales order lines, shipments **Cadence:** Weekly **Kpi:** Fill rate (line) **Area:** Delivery **Formula:** Lines shipped complete from first allocation / Lines ordered x 100 **Unit:** percent **Source:** Sales order lines **Cadence:** Weekly **Kpi:** Order backlog **Area:** Delivery **Formula:** Sum of open order value not yet shipped **Unit:** currency **Source:** Open sales order lines **Cadence:** Weekly **Kpi:** Overall equipment effectiveness **Area:** Production **Formula:** Availability x Performance x Quality **Unit:** percent **Source:** MES, labor and machine reporting **Cadence:** Daily or per shift **Kpi:** First pass yield **Area:** Quality **Formula:** Units passing first time / Units started x 100 **Unit:** percent **Source:** Inspection results, production reporting **Cadence:** Daily **Kpi:** Scrap rate **Area:** Quality **Formula:** Scrap quantity / (Good quantity + Scrap quantity) x 100 **Unit:** percent **Source:** Production completions, scrap transactions **Cadence:** Daily **Kpi:** Schedule attainment **Area:** Production **Formula:** Jobs completed on schedule / Jobs scheduled x 100 **Unit:** percent **Source:** Work orders, routing **Cadence:** Daily or weekly **Kpi:** Manufacturing cycle time **Area:** Production **Formula:** Job finish date - Job release date **Unit:** days **Source:** Work order dates **Cadence:** Weekly **Kpi:** Labor efficiency **Area:** Production **Formula:** Standard hours earned / Actual hours worked x 100 **Unit:** percent **Source:** Labor reporting, routing standards **Cadence:** Weekly **Kpi:** Throughput per labor hour **Area:** Production **Formula:** Units produced / Direct labor hours **Unit:** units per hour **Source:** Production completions, labor **Cadence:** Weekly **Kpi:** Purchase price variance **Area:** Purchasing **Formula:** (Actual price - Standard price) x Quantity received **Unit:** currency **Source:** Receipts, item standard cost **Cadence:** Monthly **Kpi:** Supplier on time delivery **Area:** Purchasing **Formula:** PO lines received by due date / PO lines due x 100 **Unit:** percent **Source:** PO lines, receipts **Cadence:** Monthly **Kpi:** Inventory accuracy **Area:** Inventory **Formula:** Locations counted correctly / Locations counted x 100 **Unit:** percent **Source:** Cycle count results **Cadence:** Monthly **Kpi:** Excess and obsolete percent **Area:** Inventory **Formula:** E&O inventory value / Total inventory value x 100 **Unit:** percent **Source:** Inventory valuation, usage history **Cadence:** Quarterly **Kpi:** Forecast accuracy (MAPE based) **Area:** Planning **Formula:** 100 - Mean absolute percentage error **Unit:** percent **Source:** Forecast and actual demand **Cadence:** Monthly **Kpi:** Warranty cost percent of sales **Area:** Quality **Formula:** Warranty cost / Revenue x 100 **Unit:** percent **Source:** Service claims, GL **Cadence:** Quarterly **Kpi:** Revenue per employee **Area:** Finance **Formula:** Annual revenue / Average headcount **Unit:** currency **Source:** GL revenue, HR headcount **Cadence:** Quarterly **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use this reference **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### Are these the only correct formulas? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms manufacturing kpi formulas, operations kpi list, kpi formula cheat sheet, manufacturing metrics definitions, plant kpi calculation, kpi reference excel, controller kpi list, manufacturing kpi glossary --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json