A deep hole drilling operation without a quality dashboard does not know its scrap rate, does not know its tool cost per part, and does not know whether its quality is improving or degrading. The management team meets every morning and discusses the same problems without data — because the data is scattered across inspection reports, tooling logs, and shift reports that nobody has time to aggregate. A quality dashboard collects the essential metrics automatically, displays them in real time, and trends them over time — so the team can focus on solving problems instead of finding data.
Essential KPIs
Quality KPIs
| KPI | Definition | Formula | Target (Typical) | Review Frequency |
|---|
| Scrap rate | Percentage of parts scrapped due to defects | (Scrapped parts / Total parts produced) × 100 | < 2% | Daily |
| Rework rate | Percentage of parts requiring rework | (Reworked parts / Total parts produced) × 100 | < 3% | Daily |
| First-pass yield (FPY) | Percentage of parts passing inspection first time without rework | (Passed first time / Total parts inspected) × 100 | > 95% | Daily — per part number |
| Overall equipment effectiveness (OEE) | Availability × Performance × Quality | OEE = A × P × Q | > 85% (world-class) | Daily — shift |
| Cp (process capability index) | Process capability relative to tolerance | (USL − LSL) / (6 × σ) | > 1.33 | Weekly — per feature |
| Cpk (process capability index — centered) | Process capability accounting for centering | Min[(USL − μ)/(3σ), (μ − LSL)/(3σ)] | > 1.33 | Weekly — per feature |
| PPM defect rate | Defective parts per million produced | (Defective parts / Total produced) × 1,000,000 | < 10,000 PPM (1%) | Monthly |
| Hole diameter capability | Cp/Cpk for hole diameter tolerance | Per Cp/Cpk formula | Cpk > 1.33 | Weekly — per hole size |
| Surface finish capability | Ra/Cp for surface finish spec | Per Cp formula | Cp > 1.33 | Weekly — per material |
Production KPIs
| KPI | Definition | Formula | Target (Typical) | Review Frequency |
|---|
| Cycle time | Time from cycle start to cycle end per part | Total production time / Parts produced | Per part spec ± 10% | Per part — daily average |
| Throughput | Parts produced per unit time | Parts produced / Production time | Per production plan | Daily |
| OEE — Availability | Ratio of actual production time to planned production time | (Operating time / Planned production time) × 100 | > 90% | Daily — shift |
| OEE — Performance | Ratio of ideal cycle time to actual cycle time | (Ideal cycle time × parts produced) / Operating time × 100 | > 95% | Daily — shift |
| OEE — Quality | Ratio of good parts to total parts | (Good parts / Total parts produced) × 100 | > 99% | Daily — shift |
| KPI | Definition | Formula | Target (Typical) | Review Frequency |
|---|
| Tool life — average | Average number of holes per tool | Total holes produced / Number of tools consumed | Per tool spec ± 20% | Weekly — per tool type |
| Tool life — standard deviation | Variation in tool life | Standard deviation of holes per tool | < 20% of mean | Weekly — per tool type |
| Tool cost per part | Cost of tooling consumed per good part produced | Total tool cost / Good parts produced | Per budget | Monthly |
| Tool change frequency | Number of tool changes per shift or day | Count of tool changes | Per production plan | Daily |
| Tool breakage rate | Number of tools broken per parts produced | Broken tools / Total parts × 100 | < 0.5% | Weekly |
Maintenance KPIs
| KPI | Definition | Formula | Target (Typical) | Review Frequency |
|---|
| Mean time between failures (MTBF) | Average operating time between unplanned stops | Total operating hours / Number of unplanned stops | Target per machine + improving | Monthly |
| Mean time to repair (MTTR) | Average time to restore machine after failure | Total repair hours / Number of repairs | < 2 hours (mechanical) | Monthly |
| Unplanned downtime % | Percentage of total time lost to unplanned stops | (Unplanned downtime / Total available time) × 100 | < 5% | Daily |
| PM completion rate | Percentage of scheduled PM tasks completed on time | (PM completed on time / PM scheduled) × 100 | > 95% | Weekly |
| Maintenance cost per operating hour | Cost of maintenance per hour of operation | Total maintenance cost / Operating hours | Per budget | Monthly |
Dashboard Design
Design Principles
| Principle | Description | Application |
|---|
| Visual hierarchy | Most important KPIs at top — largest display — most prominent | Scrap rate — OEE — throughput at top of dashboard |
| Real-time vs historical | Real-time for actionable metrics — trends for strategic metrics | Real-time: scrap count, downtime. Trend: scrap rate trend, tool life trend |
| Drill-down capability | Click from summary to detail — from machine-level to part-level | Click OEE → see A, P, Q components → click downtime → see downtime reasons |
| Role-based views | Different KPIs for operator, supervisor, manager, executive | Operator: cycle time, scrap. Manager: OEE, Cp, cost per part |
| Exception highlighting | Red/green/yellow for KPI status — attention to out-of-range | Red when scrap > 5%, yellow when 2–5%, green when < 2% |
| Trend display | Show direction — not just current value | Sparkline or mini-chart next to each KPI value |
| Time period selection | View by shift, day, week, month, custom range | Default: today. Options: this week, this month, custom |
| Minimal data entry | Automate data collection where possible — reduce manual entry | Machine interfaces for cycle time — CMM interface for quality data |
Dashboard Layout — Example
| Zone | Position | Content | Update Frequency |
|---|
| Header | Top — full width | Date — shift — machine name — operator | Per shift |
| KPI row 1 | Upper row — 4 large tiles | OEE — Scrap rate — Throughput (today) — First-pass yield | Real-time or per part |
| KPI row 2 | Second row — 4 medium tiles | Tool cost/part — MTBF — Cp/Cpk (primary feature) — Cycle time | Daily (recalculate) |
| Trend charts | Center — 2 charts | Scrap rate trend (30 days) — OEE trend (30 days) | Update daily |
| Downtime breakdown | Lower left — pie or bar chart | Downtime by category (mechanical, electrical, coolant, tooling, other) | Per event |
| Defect Pareto | Lower right — bar chart | Defects by type (oversize, undersize, surface, straightness, other) | Per part — daily |
| Bottom bar | Bottom — full width | Action items — recent events — alerts | Real-time |
Data Collection Methods
| Data Type | Collection Method | Automation Level | Accuracy | Implementation Effort |
|---|
| Cycle time | PLC/Machine control interface | Fully automatic | ± 1 second | High — requires machine communication |
| Part count — good | Manual entry or sensor | Semi-automatic (sensor) or manual | High with sensor — variable with manual | Moderate (sensor) — Low (manual) |
| Part count — scrap | Manual entry or CMM interface | Semi-automatic | High | Low–Moderate |
| Downtime — duration | PLC or manual entry | Semi-automatic | High with PLC | Moderate |
| Downtime — reason category | Manual entry (operator selects from list) | Manual | Moderate — depends on operator | Low |
| Tool life — holes per tool | Manual count or sensor | Semi-automatic | Moderate | Low–Moderate |
| Tool life — tool changes | Manual entry or tool management system | Semi-automatic | High with tool management system | Moderate |
| Inspection data — diameter | CMM or air gauge (automatic data output) | Fully automatic | High | High — requires data integration |
| Inspection data — surface finish | Profilometer (manual) | Manual | Moderate | Low |
| Coolant parameters | PLC or sensor interface | Fully automatic | High | High |
| Machine alarms | PLC interface | Fully automatic | High | High |
Recommended Data Collection Approach
| Maturity Level | Data Collection Method | Accuracy | Cost | Best For |
|---|
| Level 1 — Basic | Manual logbook — spreadsheet | Low — operator dependent | Very low | Small shops — single machine — starting out |
| Level 2 — Standard | Spreadsheet with manual entry + some automated data | Moderate | Low | Medium shops — spreadsheet-literate staff |
| Level 3 — Automated | PLC data collection + manual quality data entry | High | Moderate | Production shops — need reliable OEE data |
| Level 4 — Integrated | Full MES integration — automatic data from all sources | Very high | High | Large shops — multiple machines — enterprise reporting |
| Platform | Cost | Setup Effort | Features | Best For |
|---|
| Spreadsheet (Excel, Google Sheets) | Low (license cost only) | Low — template creation | Manual entry — basic charts — limited automation | Starting out — small shops — simple tracking |
| BI tool (Power BI, Tableau, Grafana) | Moderate ($10–$50/user/month) | Moderate — requires setup | Automated data import — rich visualization — drill-down — sharing | Medium to large shops — automated data collection |
| MES system (Manufacturing Execution System) | High ($5,000–$50,000+ setup + per-machine fee) | High — requires integration | Full data collection — real-time dashboard — production tracking — traceability | Production shops — multi-machine — need traceability |
| Custom-built (web app) | High (development cost) | High — full custom development | Tailored exactly to needs — any functionality — ongoing maintenance | Unique requirements — existing development team |
| Machine manufacturer's system | Moderate–High (per machine or subscription) | Moderate — machine-specific | Pre-configured for machine — limited customization | Single manufacturer machines — OEM solution |
KPI Target Setting
| KPI | Baseline Method | Initial Target | Improvement Target | Stretch Target |
|---|
| Scrap rate | Average of last 3 months | 50% reduction from baseline | < 2% | < 1% |
| First-pass yield | Average of last 3 months | 95% | 97% | 99% |
| OEE | Average of last 3 months | 75% | 80% | 85% |
| Tool cost per part | Average of last 3 months | 10% reduction | 20% reduction | 30% reduction |
| Cp/Cpk | Current calculated value | 1.33 | 1.50 | 1.67 |
| MTBF | Average of last 6 months | 25% improvement | 50% improvement | 100% improvement |
| MTTR | Average of last 6 months | < 3 hours | < 2 hours | < 1 hour |
| PM completion rate | Current rate | 90% | 95% | 98% |
Review Frequency and Action Triggers
| KPI | Review Frequency | Who Reviews | Action Trigger | Response When Triggered |
|---|
| Scrap rate — daily | Daily — shift handover | Supervisor — operator | > 5% in a single shift | Immediate investigation — stop machine if needed |
| Scrap rate — trend | Weekly — production meeting | Supervisor — manager | Rising trend over 3 days | Root cause analysis — corrective action plan |
| OEE | Daily — shift handover | Supervisor — maintenance | < 70% | Identify primary loss — create recovery plan |
| Tool life — variation | Weekly | Tooling engineer — supervisor | SD > 25% of mean | Investigate coolant, material, or parameter variation |
| Cp/Cpk | Weekly — per feature | Quality engineer | Cpk < 1.33 | Process adjustment required — 100% inspection until resolved |
| PM completion | Monthly | Maintenance manager | < 90% | Review workload — adjust PM schedule — add resources |
| MTBF | Monthly | Maintenance manager — plant manager | Decreasing trend over 2 months | Root cause analysis — reliability improvement project |
| MTTR | Monthly | Maintenance manager | > 3 hours average | Review repair procedures — training — spare parts availability |
FAQ
What are the most important KPIs for deep hole drilling quality?
The most important KPIs for deep hole drilling: scrap rate (percentage of parts scrapped — the ultimate quality metric — track daily by machine and part number — target < 2%). First-pass yield (percentage of parts passing inspection without rework — measures process stability — target > 95%). Cp and Cpk (process capability indices — Cp measures the process spread relative to the tolerance — Cpk also accounts for centering — target > 1.33 for critical features like hole diameter and straightness — Cpk < 1.0 means the process is not capable of holding the tolerance). Tool cost per part (total tool cost divided by good parts produced — trend over time — increasing tool cost often indicates a process problem before it shows up as scrap). OEE (Overall Equipment Effectiveness — Availability × Performance × Quality — the single best metric for overall production efficiency — target > 85%). Start with scrap rate and Cpk — add OEE and tool cost as the data collection infrastructure matures.
How do I set up a quality dashboard for a deep hole drilling machine?
To set up a quality dashboard: identify the essential KPIs (start with 5–8 key metrics — scrap rate, throughput, OEE, tool life, Cp/Cpk, downtime — do not try to track everything at once). Determine data sources (which data can be collected automatically from the machine PLC or CMM, and which must be entered manually — automate the data you can, minimize manual entry). Choose a platform (start with a spreadsheet if you are new to dashboards — move to Power BI or Tableau when you have consistent data and need automated updates). Design the layout (most important KPIs at top — trends in the center — breakdown charts at bottom — use red/yellow/green status indicators). Set baselines and targets (collect 1–3 months of data to establish baselines — set initial targets based on those baselines — do not set arbitrary targets without data). Establish a review cadence (daily — shift handover review of scrap and OEE. Weekly — production meeting review of all KPIs. Monthly — management review of trends and improvement projects).
How do I collect data for quality KPIs without an automated system?
Without an automated system, use a structured manual data collection approach: create a shift report form (paper or digital — operator fills in: parts produced, good parts, scrap parts with reason code, cycle time for sample parts, downtime events with duration and reason, tool changes). Collect tooling data (operators record: tool installed, tool removed, holes run on each tool — a simple logbook or spreadsheet per machine). Collect inspection data (inspector records: measured values for critical features — diameter, depth, surface finish — on a data sheet or spreadsheet — record measured values, not just pass/fail — measured values are needed for Cp/Cpk calculation). Enter all data into a central spreadsheet daily (dedicate 15–20 minutes per day for data entry — this is the most commonly skipped step — assign responsibility to a specific person). Calculate KPIs weekly (use formulas in the spreadsheet to calculate scrap rate, FPY, tool life, etc. — add trend charts monthly). The most important thing is consistency — manual data collection is better than no data, but only if it is done every day without fail.
How often should quality KPIs be reviewed?
Review frequency by KPI type: daily (shift handover) — scrap rate (actual vs target), throughput (actual vs plan), OEE (actual vs target), downtime events (any significant event), cycle time (any variation from standard). Weekly (production meeting) — scrap rate trend (not just today's value — look at the 7-day trend), tool life (actual vs expected by tool type), Cp/Cpk (by critical feature — any capability below 1.33), rework rate (trend — not just point value). Monthly (management review) — all KPIs with monthly trend charts, tool cost per part (trend — compare to budget), MTBF and MTTR (trend — reliability improvement), PM completion rate (compliance with schedule), improvement project status (actions taken and results). The daily review is the most important — it catches problems immediately. The weekly review identifies developing trends. The monthly review drives strategic improvement. If you only review KPIs monthly, you are reacting to problems that have been developing for weeks.
What is a good OEE target for a deep hole drilling machine?
For a deep hole drilling machine: world-class OEE = 85% (Availability > 90% × Performance > 95% × Quality > 99% = 85%). Typical OEE for a well-maintained machine in a production environment = 70–80%. Low OEE < 60% (significant improvement opportunity — typically driven by high downtime, slow cycles, or high scrap). Set initial OEE target based on current performance plus 5–10 percentage points — achievable within 3–6 months with focused improvement. The OEE breakdown identifies where to focus: Low Availability (high downtime — reduce by improving PM, reducing MTTR, reducing setup time). Low Performance (slow cycles — reduce by optimizing parameters, reducing machine acceleration/deceleration, reducing idle time). Low Quality (high scrap — reduce by improving process capability, reducing tool wear variation, stabilizing coolant conditions). Track OEE components separately — a 75% OEE with 95% A, 85% P, 93% Q requires a different improvement strategy than 75% OEE with 80% A, 95% P, 99% Q.
A quality dashboard replaces anecdotal management with data-driven decision making for deep hole drilling operations. Start with the essential KPIs — scrap rate, OEE, and tool cost per part — and add KPIs as the data collection infrastructure matures. Build the dashboard in layers — daily metrics at the top for quick review, trends in the middle for pattern recognition, and detailed breakdowns at the bottom for root cause analysis. Review daily for immediate problems, weekly for developing trends, and monthly for strategic improvement. A good quality dashboard does not just display data — it drives action. This article reflects industry practice as of 2026.
