Every KPI, measure, and threshold that powers The Actionable Insights — with tier, direction, and implementation guidance. Plus: how to connect from basic Excel to fully integrated digital systems.
| Tier | KPI / Metric | What You See at This Tier | Data Elements / Dimensions | UOM | Exceeds | Meets | Partial | Dir |
|---|---|---|---|---|---|---|---|---|
| People | ||||||||
| T3 | Training Completion Rate % required training items completed in period | Site-level training completion vs. requirements | Period, dept, role, training type, completion flag | % | ≥98% | ≥95% | ≥85% | ▲ |
| T3 | On-Time Training Completion % training completed by required due date | Training on-time rate vs. due dates | Period, dept, training type, due date vs. completion | % | ≥98% | ≥95% | ≥85% | ▲ |
| T2 | Training Hours Per Employee Total training hours / headcount in period | Avg training investment per employee | Period, dept, training type, hours | hrs | ≥4.5 | ≥3.5 | ≥2.5 | ▲ |
| T2 | Training Pace Completions to date vs. expected completions at this point in period | Training pace — on track vs. expected cadence | Period, dept, expected vs. actual completions | % | ≥110% | ≥90% | ≥75% | ▲ |
| T1 | Employees with No Due Items (<7 Days) % employees current within 7-day window | % employees with no due/overdue items inside 7 days — suite / dept level | Employee, training items, due dates, suite/dept | % | ≥97% | ≥93% | ≥85% | ▲ |
| T1 | Training Compliance — By Employee Individual compliance flag per employee per suite/role | Compliant / non-compliant by name, role, suite — actionable at line level | Employee name, role, suite, item, due date, status | flag | Compliant | Due <7d | Overdue | ▲ |
| Safety — EHS | ||||||||
| T3 | TRIR Total Recordable Incident Rate — recordable incidents × 200,000 / hrs worked | Site TRIR vs. target — pharma best-in-class <0.5 | Period, incident type, hours worked | rate | ≤0.5 | ≤1.0 | ≤1.5 | ▼ |
| T3 | Days Without Recordable Incident Days since last OSHA recordable | Days since last OSHA recordable incident | Site, last incident date, current date | days | ≥365d | ≥180d | ≥120d | ▲ |
| T3 | EHS Compliance Risk Score Composite: reg compliance 40% + audit closure 35% + open findings risk 25% | Composite compliance risk score — site level | Regulation, audit findings, open actions | score | ≥95% | ≥85% | ≥75% | ▲ |
| T2 | Near Miss / Observation Count Higher = stronger preventive reporting culture | Near miss and safety observation volume — dept level | Period, dept, category (near miss / observation) | # | ≥200 | ≥100 | ≥50 | ▲ |
| T2 | Safety CAPA On-Time Closure % safety CAPAs closed on or before due date | Safety CAPA closure rate vs. due dates | Period, CAPA owner, due date, closure date | % | ≥95% | ≥85% | ≥75% | ▲ |
| T1 | Safety Issues Open — Suite Level Count open actions where Owner = EHS as-of current day — from T1 PSQDC | Open EHS action items by suite — actionable at floor level | Suite, action, owner, due date, open count | count | 0 | 0 | ≥1 | ▼ |
| T1 | 6S Compliance Rate % 6S audit areas passing threshold — area level | 6S audit pass rate by area | Period, area, audit score, pass/fail flag | % | ≥95% | ≥90% | ≥80% | ▲ |
| Quality | ||||||||
| T3 | Right First Time (RFT) % batches released without deviation or rework | Batch quality rate — site level | Period, suite, product, deviation flag | % | ≥97% | ≥93% | ≥87% | ▲ |
| T3 | CAPA On-Time Closure % CAPAs closed on or before due date | CAPA closure rate vs. committed due dates — site level | Period, CAPA type, owner, due date vs. closure date | % | ≥95% | ≥85% | ≥75% | ▲ |
| T3 | Deviation Rate Deviations per batch — lower is better | Deviation frequency vs. batch volume — site level | Period, suite, product, deviation type, batch count | per batch | ≤0.10 | ≤0.20 | ≤0.35 | ▼ |
| T2 | OOX Rate (OOS / OOT) % test results outside specification or trend limits | Out-of-spec and out-of-trend rate by product and test | Period, product, test method, result vs. spec/trend | % | ≤0.5% | ≤1.0% | ≤2.0% | ▼ |
| T2 | Batch Release Cycle Time Days from batch completion to QA release — lower is better | Avg days from end of manufacturing to QA batch release | Product, batch #, completion date, release date | days | ≤14d | ≤21d | ≤30d | ▼ |
| T2 | Change Control On-Time % change controls approved within target cycle time | Change control cycle time vs. target — by type | Period, change type, owner, open date, approval date | % | ≥95% | ≥85% | ≥75% | ▲ |
| T2 | Complaint Rate Customer / product complaints per batch released | Complaint frequency vs. batches released — product level | Period, product, complaint category, batch count | per batch | ≤0.02 | ≤0.05 | ≤0.10 | ▼ |
| T1 | Days Without Deviation — Suite Level Days since last deviation in suite — from T1 PSQDC | Days without DV by suite — actionable at floor level | Suite, last deviation date, current date, days elapsed | days | ≥30d | ≥10d | ≥5d | ▲ |
| T1 | MPR Review OT + RFT % % MPRs both on-time AND right-first-time — from T1 PSQDC | Manufacturing Package Review quality at batch/suite level | Suite, batch, MPR, on-time flag, RFT flag | % | ≥97% | ≥93% | ≥87% | ▲ |
| T1 | MPR Real-Time Review Complete % % MPRs with real-time review steps completed — from T1 PSQDC | MPR real-time review completion by suite and batch | Suite, batch, MPR, RTR_Complete_Flag | % | ≥100% | ≥95% | ≥90% | ▲ |
| Delivery — Supply Chain, Manufacturing, Demand, Procurement, Warehousing & Shipment | ||||||||
| T3 | Perfect Shipment OT + In-Full + Accuracy + Damage Free — all four pillars = 1 | Composite delivery performance — site level | Period, client, shipment #, 4-pillar flags | % | ≥97% | ≥93% | ≥85% | ▲ |
| T3 | On Time Delivery (Manufacturing) % batches completed by planned end date | Batch completion vs. schedule — site level | Period, suite, product, planned vs. actual end date | % | ≥97% | ≥92% | ≥85% | ▲ |
| T3 | Forecast Accuracy 1 − MAPE; higher = more accurate | Site % — plan vs. actual units shipped | Period, product family, $ and unit variance | % | ≥95% | ≥90% | ≥85% | ▲ |
| T3 | Schedule Adherence % WOs completed on or before planned end date | Work order completion vs. planned dates — site level | Period, suite, product, planned vs. actual | % | ≥95% | ≥90% | ≥80% | ▲ |
| T3 | MRP Adherence % MRP actions (PO/WO/PR) executed on time | MRP execution discipline — site level | Period, action type (PO/WO/PR), on-time vs. late | % | ≥95% | ≥90% | ≥80% | ▲ |
| T3 | RTE Index Composite readiness — minimum of 7 milestone factors | Ready-to-Execute composite site readiness | 7 readiness milestones, min score | % | ≥95% | ≥85% | ≥70% | ▲ |
| T3 | Book-to-Bill Ratio Orders booked / billed; >1.0 = pipeline growing | Orders booked vs. billed — site level | Current quarter, rolling 12-month trend | × | ≥1.1× | ≥1.0× | ≥0.9× | ▲ |
| T3 | Capacity Utilization Secured + P75 demand / max capacity | % of site capacity committed to confirmed demand | Suite / line, quarter, available headroom | % | ≥85% | ≥70% | ≥50% | ▲ |
| T3 | Perfect Receipt All 4 pillars: OT + In-Full + Correct PW + Damage Free | Composite receipt performance — site level | Period, supplier, 4-pillar breakdown | % | ≥97% | ≥93% | ≥85% | ▲ |
| T3 | WO Fill Rate % work orders filled on time and in full | Work order fill rate — site level | Period, product, WO #, on-time + in-full flags | % | ≥98% | ≥95% | ≥88% | ▲ |
| T3 | Inventory MOS Months of supply — target 10–14 month sweet spot | Current inventory coverage in months | Period, product family, DOH calculation | MO | 10–14 MO | 8–16 MO | <8 or >20 | ⟷ |
| T2 | OEE Availability × Performance × Quality | Overall Equipment Effectiveness — suite level | Suite, shift, Availability × Performance × Quality | % | ≥83% | ≥70% | ≥55% | ▲ |
| T2 | Batch Cycle Time Actual cycle time vs. target — lower is better | Avg days from batch start to release | Product, suite, batch #, start-to-release days | days | ≤120d | ≤145d | ≤160d | ▼ |
| T2 | Secured Revenue vs. Plan Confirmed backlog / quarterly plan | Confirmed backlog $ vs. quarterly plan | Quarter, product, client, gap to plan | % | ≥105% | ≥95% | ≥85% | ▲ |
| T2 | On Time Shipment % shipments delivered by commit date | Delivery vs. commit date — client level | Client, product, commit date vs. actual ship date | % | ≥98% | ≥95% | ≥88% | ▲ |
| T2 | Order-to-Ship Cycle Time Total days from order release to shipment departure | Avg days from order release to shipment departure | Client, product, order date, ship date | days | ≤8d | ≤8d | ≤9d | ▼ |
| T2 | Dock-to-Stock Time Total dock arrival to QA release — lower is better | Avg hours from dock arrival to QA-released inventory | Period, supplier, material, receive-to-release hours | hrs | ≤36 hrs | ≤48 hrs | ≤72 hrs | ▼ |
| T1 | Schedule Adherence — Suite Level Available hours / required hours from suite hourly schedule — from T1 PSQDC | Suite schedule adherence — actionable at floor level | Suite, shift, available hours, required hours | % | ≥98% | ≥95% | ≥90% | ▲ |
| T1 | Ready to Execute — Suite Level Count open actions with manufacturing impact = 1; 0 = Ready — from T1 PSQDC | Open manufacturing-blocking actions by suite | Suite, action, owner, manufacturing_impact flag, due date | count | 0 | 0 | ≥1 | ▼ |
| T1 | Win Strategy — Deal Detail Full scope, value, competitive position, decision criteria per opportunity | Per-deal pipeline detail — actionable at BD/ops level | Client ID, project #, indication, dosage form, volumes, total contract $ | deal | N/A — Qualitative | — | ||
| Cost / Financial | ||||||||
| T3 | Revenue vs. Plan Actual revenue / budget target | Site revenue actuals vs. budget — period and YTD | Period, product line, client, actuals vs. budget | % | ≥105% | ≥98% | ≥90% | ▲ |
| T3 | EBITDA Margin EBITDA / revenue — operating profitability | EBITDA % vs. target — site and consolidated | Period, P&L components, EBITDA vs. target | % | ≥25% | ≥20% | ≥15% | ▲ |
| T3 | COGS as % of Revenue Total COGS / net revenue — lower is better | COGS efficiency vs. budget | Period, product, COGS components vs. revenue | % | ≤55% | ≤60% | ≤65% | ▼ |
| T3 | Strategic Goals Delivery % strategic goals on track / completed vs. total | % strategic goals on track vs. annual plan | Goal, owner, status, % complete | % | ≥90% | ≥80% | ≥70% | ▲ |
| T3 | CapEx Performance Index Weighted composite: Schedule + Cost + Risk performance vs. plan | CapEx portfolio: % on budget, on schedule, at-risk | Project, approved budget, actual spend, forecast at completion, variance | % | ≥95% | ≥85% | ≥75% | ▲ |
| T3 | Initiatives Delivery % active initiatives on time vs. total portfolio | % initiatives on time, at risk, completed, discontinued | Initiative, owner, planned end, status, value realization | % | ≥90% | ≥80% | ≥70% | ▲ |
| T2 | Scrap as % of Sales Total scrap USD / net revenue — lower is better | Scrap cost as % of revenue | Period, product, scrap USD vs. net revenue | % | ≤0.5% | ≤1.0% | ≤3.0% | ▼ |
| T2 | Spend Performance (Procurement) Budget / actual spend — higher means under budget | Procurement spend vs. budget | Period, category, spend vs. budget | % | ≤95% | ≤105% | ≤115% | ▼ |
| T2 | Savings as % of Sales Realized savings / net revenue | Cost savings realized vs. revenue | Period, initiative, savings $ vs. revenue | % | ≥5.0% | ≥3.5% | ≥2.0% | ▲ |
| T2 | Value Realization Rate Benefits delivered / benefits committed at initiation | Actual benefits realized vs. business case commitment | Initiative, benefit type, committed $, realized $ | % | ≥90% | ≥80% | ≥70% | ▲ |
| T1 | Equipment Downtime % — Suite Level Downtime minutes / (required hours × 60) — from T1 PSQDC | Equipment downtime % by suite — actionable at floor level | Suite, downtime event, minutes, required hours | % | ≤0.1% | ≤0.3% | ≤0.5% | ▼ |
| T1 | Overdue Issues — Suite Level Count open actions past due date — from T1 PSQDC | Open overdue action items by suite | Suite, action, owner, due date, days overdue | count | 0 | 0 | ≥1 | ▼ |
| Innovation — NPI & Strategic Roadmap | ||||||||
| T3 | Pipeline Health Composite: new opportunities, in execution, implementation rate | NPI pipeline health: new opps, in execution, implemented | Program, stage, probability, new / in-execution / implemented counts | % | ≥80% | ≥65% | ≥50% | ▲ |
| T3 | NPI Success Rate % NPI programs launched on time, right first time, and handed off successfully | NPI launch OT % + right first time % + handoff success % | Program, launch date, RFT flag, handoff success flag | % | ≥90% | ≥80% | ≥70% | ▲ |
| T3 | Vitality Index Revenue from products launched in last 3 years / total revenue | Revenue % from products launched in last 3 years | Product, launch year, revenue contribution, total revenue | % | ≥30% | ≥20% | ≥10% | ▲ |
| T2 | NPI Launch On Time % NPI programs launched on or before planned date | NPI programs on time vs. plan | Program, planned launch, actual launch, days variance | % | ≥96% | ≥90% | — | ▲ |
| T2 | Value Realization (NPI) Benefits delivered vs. business case within 12 months of launch | Benefits delivered vs. committed within 12 months post-launch | Program, committed benefit, realized benefit, realization % | $ | ≥Plan | ≥Plan | — | ▲ |
| T2 | Handoff Success Rate % NPI programs with clean commercial handoff — no open items | Clean NPI-to-commercial handoff rate | Program, handoff date, open items count, escalations | % | ≥97% | ≥90% | — | ▲ |
| T1 | Innovation Value Index Weighted composite: Pipeline Health + NPI Success + Value Realization + Vitality Index | Single composite score for innovation performance vs. strategic roadmap | 4 component scores, weights, composite WPI | score | ≥90% | ≥75% | ≥60% | ▲ |
Start with structured Excel imports. Dashboards can be built from weekly/monthly data exports with manual upload workflows — no integration required to get started.
Connect directly to ERP, LIMS, MES, and QMS via API or ODBC. Real-time or near-real-time KPI feeds with governed data definitions and automated refresh.
Full data lake integration with AI-supported insights, anomaly detection, predictive analytics, and automated escalation workflows built on the complete digital architecture above.
The Actionable Insights can be deployed at any point on the digital maturity spectrum — from basic Excel imports to fully integrated SW applications. An assessment of the existing digital architecture identifies gaps, prioritizes integrations by value, and provides a phased implementation roadmap aligned to business priorities.
Inventory all existing data sources, system connections, and manual processes. Identify which KPIs can be automated vs. manual.
Rank integrations by KPI coverage, data quality, and implementation effort. Build the business case for each integration step.
Phased plan: quick wins (Excel/CSV), mid-term (API integrations), long-term (data lake + AI-enabled analytics).
AI readiness in performance intelligence is not primarily a technology question — it is a data governance, process discipline, and organizational readiness question. The maturity model below defines the four levels, what each looks like in practice, and what is required to advance to the next level.
KPIs are tracked in spreadsheets. Data is manually compiled for reviews. Inconsistent definitions. No automated refresh. Insights require interpretation by data owners before each meeting.
Dashboards exist with defined KPIs, owned thresholds, and regular refresh — whether from Excel imports or live connections. Performance is visible. Escalation is defined but still manual.
KPI architecture is governed: ownership, thresholds, escalation rules, action workflows. Tiered dashboards connect site → dept → individual. WPI scores enable cross-metric prioritization. Alerts trigger automatically.
AI-supported key takeaways, trend detection, anomaly flagging, and recommended actions are generated from live data. Predictive analytics anticipate performance risks. The dashboard conversation shifts from "what happened?" to "what should we do?"
Start with an assessment of your current architecture and KPI maturity — or discuss connecting your first dashboard.
Assess KPI Maturity Discuss Your Scope