That Day, When the CPK Report Came Out, the Entire Room Was Silent for Three Seconds
I remember several years ago, when our new process just went online, the yield was like a rollercoaster, with surprises every day. One morning, the PM came over and asked, "Hey, why is your CPK different from the factory next door? Their numbers are significantly better than ours!" I was stunned on the spot; clearly, my daily reports were all green! After checking, I realized the problem wasn't with the CPK numbers themselves, but with the "time frequency" of our observation.
Where Was the Problem?
Simply put, the reports you scrutinize daily might not reflect the true situation at all. You look at the daily report, see a CPK of 1.33, and feel reassured, but honestly, this could very well be an illusion created by "survivor bias." Daily reports have limited data, making it easy for a few good batches to skew the average upwards, leading to misjudgment. When a problem truly occurs, it might already be several days later, making traceability difficult.
So, the key point is that daily reports alone are not enough; you also need "weekly" and "monthly" reports to complete the perspective. Daily reports help you identify "anomalies," weekly reports help you discern "trends," and monthly reports allow you to assess "overall health."
How Is It Done in Practice?
1. Daily Reports: Catch Anomalies, Numbers Must Be "Real-time" and "Sensitive"
Your daily report KPIs must be able to reflect problems immediately. For example, in a wafer fab, DPMO (Defects Per Million Opportunities) is crucial. I would set a threshold for abnormal DPMO; for instance, if the daily DPMO suddenly jumps from a normal 6210 to 12000, something is definitely wrong. At this point, you should start investigating without waiting for the CPK to drop. Another commonly used daily report metric might be the Wafer Scrap Rate; if the scrap rate for the day is 1.5 times higher than the average of the previous three days, it's a warning sign.
2. Weekly Reports: Observe Trends, Numbers Must Be "Representative"
For weekly reports, you cannot just look at the current week's CPK or DPMO; instead, you need to observe "trends." I would plot the CPK values from the past eight weeks using a trend chart. If this week's CPK is 1.08, it might seem acceptable, but if the previous seven weeks were all above 1.33, then this week's 1.08 indicates a "downward" trend. Although it hasn't reached the red line yet, it's already an amber light. In other words, the KPI design for weekly reports focuses on showing the "rate of change" rather than just a single value.
3. Monthly Reports: Assess Health, Numbers Must Be "Macro"
Monthly reports are for management, and the numbers should be able to comprehensively evaluate the entire month's performance. At this point, macro indicators like Overall Yield and Customer Complaints Count become critical. If the yield consistently stays above 98.5% for three consecutive months, it indicates process stability. However, if customer complaints suddenly increase by 20% this month, even if the yield hasn't dropped, it still signifies potential quality risks. The KPIs for monthly reports primarily focus on "stability" and "long-term goal achievement rate."
Most Common Pitfalls
The biggest pitfall I've encountered is "setting too many KPIs, leading to a loss of focus." In our department's previous reports, the daily report alone had over twenty KPIs, which was dazzling to look at every day. As a result, the actual problem points were drowned in the vast sea of numbers. Frankly, in the end, everyone just looked at the colors; if it was green, everything was fine, and no one bothered to think about the meaning behind the numbers.
Another common pitfall is "only looking at results, not the process." Only fixating on the final yield while ignoring DPMO changes at various intermediate stations. By the time the yield drops, you start investigating from scratch, which is time-consuming and laborious. Frankly, this is like only looking at your final exam grade but never your quiz scores, only to regret it when your grades are a mess.
One Thing You Can Do Today
Re-evaluate your daily/weekly/monthly reports to ensure KPIs are complementary and meaningful.