KPI Library — Core Operational Metrics & Definitions

Purpose

This reference spreadsheet provides consistent, actionable metric definitions to help huddle coaches, data owners, team leads, and improvement facilitators choose KPIs that predict problems and drive priority actions instead of measuring vanity. Use it to align data owners, avoid confused definitions, improve trust in metrics, and make daily huddles more productive.

How to use this spreadsheet

Copy the template into your site or team domain and maintain one row per KPI. For each KPI row capture: category, metric name, short purpose statement, formal definition, numerator/denominator (calculation), collection frequency, recommended target bands (green/yellow/red), common pitfalls, visualization recommendation, suggested owner role, and a short huddle coaching cue (what to ask and what action to assign).

Guidance for choosing KPIs

• Prefer predictive over vanity: Select measures that help you see problems early (e.g., backlog growth rate) rather than metrics that only report a finished outcome without context.
• Limit to the critical few: Start with 5–8 team-level KPIs. Huddle time is limited; use KPIs that trigger clear actions.
• Define ownership and cadence: Every KPI needs an owner who can explain data quality, confirm calculation, and commit to follow-up actions.
• Be explicit about scope: Document whether the KPI is site-level, line-level, shift-level, or product-family-level to avoid mismatched comparisons.

Example KPIs by category

Safety

• TRIR (Total Recordable Incident Rate)
  • Purpose: Track recordable incidents normalized for exposure to work hours.
  • Definition / Calculation: (Number of recordable incidents × 200,000) / Total hours worked in period.
  • Frequency: Monthly
  • Recommended targets: Green ≤ industry benchmark or historical best; Yellow = rising trend; Red = sustained increase.
  • Common pitfalls: Underreporting, inconsistent incident classification, using alone without near-miss measures.
  • Visualization: Trend line with rate per month + overlay of corrective actions and injury reviews.
  • Owner role: EHS Manager / Shift Lead
  • Huddle cue: "Any incidents or near-misses since last huddle? Who is assigned to immediate containment and root cause follow-up?"

Quality

• First Pass Yield (FPY)
  • Purpose: Measure proportion of units passing quality checks first time without rework.
  • Definition / Calculation: (Good units produced without rework) / (Total units entering process step)
  • Frequency: Daily/Shift
  • Targets: Green ≥ target threshold; Yellow = within tolerance; Red = trending down over 3 periods.
  • Pitfalls: Ignoring inspection consistency; counting reworked units as good.
  • Visualization: Bar chart by shift with Pareto of defect types.
  • Owner: Quality Lead / Production Supervisor
  • Huddle cue: "Which defect type is driving FPY loss today? Who will run the containment test and when?"

Delivery

• On-Time Delivery (OTD)
  • Purpose: Measure reliability of delivery commitments to customers.
  • Definition / Calculation: (Number of orders delivered on or before promised date) / (Total orders delivered)
  • Frequency: Weekly / Daily for operations with high cadence
  • Targets: Set to customer expectation or contract SLA; use tolerance bands.
  • Pitfalls: Measuring shipped date vs. promised date mismatch; not excluding cancelled orders.
  • Visualization: Trend with rolling 4-week average and highlighted missed orders with root-cause tags.
  • Owner: Logistics / Customer Service
  • Huddle cue: "Any at-risk orders in the next 48 hours? Who owns escalation and what is the containment plan?"

Productivity

• OEE (Overall Equipment Effectiveness)
  • Purpose: Combined measure of equipment availability, performance, and quality.
  • Definition / Calculation: OEE = Availability × Performance × Quality (each as a %)
  • Frequency: Shift / Daily
  • Targets: Use top-quartile benchmarks by equipment class; track incremental gains.
  • Pitfalls: Poor time-capture rules, inconsistent downtime codes, mixing planned changeovers as unplanned downtime.
  • Visualization: Dashboard showing the three component scores plus top downtime reasons Pareto.
  • Owner: Maintenance / Production Lead
  • Huddle cue: "Top downtime reason yesterday? What immediate action and who owns root cause?"

Maintenance

• MTTR (Mean Time to Repair)
  • Purpose: Measure responsiveness and effectiveness of repairs.
  • Definition / Calculation: Total corrective maintenance time / Number of repairs
  • Frequency: Rolling 30-day
  • Targets: Set by equipment criticality; trend matters more than single value.
  • Pitfalls: Inconsistent start/stop time capture, including logistic delays as repair time.
  • Visualization: Boxplot or trend line with incident list and assigned technicians.
  • Owner: Maintenance Supervisor
  • Huddle cue: "Which asset is contributing most to lost production this week? What is the action plan and target for MTTR improvement?"

Inventory

• Days of Inventory (DOI)
  • Purpose: Measure how long current stock will last at current usage.
  • Definition / Calculation: (On-hand inventory value or units) / (Average daily usage)
  • Frequency: Weekly
  • Targets: Aligned to lead times and service level requirements.
  • Pitfalls: Using inaccurate usage data, ignoring safety stock rules, mixing obsolete items.
  • Visualization: Trend by SKU group with aging bands and exceptions listed.
  • Owner: Inventory Manager / Supply Planner
  • Huddle cue: "Which SKUs are outside target DOI and who is following up with procurement or production?"

Recommended columns for the spreadsheet template

1. Category (safety/quality/delivery/productivity/maintenance/inventory)
2. Metric name
3. Short purpose statement (why this metric matters)
4. Formal definition
5. Numerator / Denominator (calculation)
6. Collection frequency (shift/daily/weekly/monthly)
7. Data source(s) and owner(s)
8. Recommended target bands (Green/Yellow/Red)
9. Visualization recommendation (chart type, filter keys)
10. Common data quality pitfalls
11. Scope and exclusions (what this does NOT include)
12. Suggested owner role
13. Huddle coaching cue (1–2 sentence script)
14. Last reviewed (date) and reviewer

Huddle coaching tips

• Open with the metric that has the highest risk to commitments today. Keep the conversation to facts, immediate containment, owner, and due date.
• Use the huddle cue field in the spreadsheet so coaches can copy the one-liner question verbatim (reduces facilitation friction).
• Escalate only when the team-level containment is insufficient; document escalations in the spreadsheet for trend analysis.
• Rotate metric ownership review periodically to maintain shared understanding but keep numeric ownership stable.

Data governance and maintaining trust

Make metric definitions immutable without a documented review: when a change is needed, record the reason, who approved it, and the effective date. Keep a short change log column in the spreadsheet so downstream dashboards and reports can be reconciled to definition versions.

Next steps and variants

Use this reference as the canonical source of truth. Consider creating local copies for site- or line-level adjustments but preserve a mapping back to the canonical KPI ID. When you adapt targets or scopes, capture the rationale so cross-site comparisons remain meaningful.

Where this is used

Designed for huddle coaches and data owners in Deck 165/1129. Copy and tailor the template to match your operational cadence and systems.