KPI算法统计
一， TL9000 返还率
a) 返还率计算公式：
×12100%IRR IRR IRR =
?基本装运周期内的返还数
基本装运周期内的发运数
IRR 基本装运周期内发运数：计算月之前6个月的发货总量(不包括计算月） IRR 基本装运周期内返还数：发货在计算月或之前6个月期间内，并在计算月内返还
的总量。
×12100%YRR YRR YRR =
?基本装运周期内的返还数
基本装运周期内的发运数
YRR 基本装运周期内发运数：计算月之前7~18个月的发货总量.
YRR 基本装运周期内返还数：发货在计算月之前7~18个月期间内，并在计算月内返
还的总量。
×12100%LTR LTR LTR =
?基本装运周期内的返还数
基本装运周期内的发运数
LTR 基本装运周期内发运数：计算月之前19个月之前包括第19个月的期间内的发货总量.
LTR 基本装运周期内返还数：发货在计算月之前19个月并且包括第19个月的期间内，并在计算月内返还的总量。
b) 数据源：PMS 包装出库管理信息系统、Oracle 发货系统报表、Oracle CRC 维修系统与新加坡维修数据库查询报表(GSS: Joy Chen)．
c) Return Rate 计算月的定义：上月25日至本月的24日
二， FPY(First Pass Yield)
1. System Product FPY
a) 计算公式：Products FPY=SMT FPY(%)*Unit TEST FPY(%) b) 数据源：MES 系统
Manufacturing Quality Weekly Report (QD:许剑鹏)
2. EMS Yield
a) 计算公式：EMS Yield Rate=Yield/Input
b) 数据源：UT KPI Report (Foxconn: Huang Yuanba/东信：汪盈）
三，LRR (Lot Reject Rate)
a)计算公式：LRR= Rejected Lots/ Inspected Lots
b)数据源：Oracle系统
IQC Weekly Report(QD:徐海平/余红华)
四，CoPQ (Cost of Poor Quality )
1.Def/Slow moving inventory scrap
a)计算公式：Material Cost=Qty*Unit Cost
b)数据源: UTS Item Product Line Report(Finance: Xiao Xiao)
Write off List (Logistic: Zheng Aiqin, Su Jing)
2.TBU EMS Material Attrition
a)计算公式：UT承担金额=盘亏总金额-EMS赔偿总金额
b)数据源：EMS 工厂盘点月报（Logistics: Zhao Yufang）
3.Stop Line Cost
a)计算公式：Stop Line Cost=Down Time(H)/6*$100
b)数据源：Production Monthly Report（GSC: Qian Huan）
4.Slow moving(excess) Inventory handling cost
a)计算公式：持库成本＝Slow moving库存金额* (年贷款利率/12 + 保险金利率) +
仓库每月管理费用* Slow moving库存金额/ 库存总金额
b)数据源：Inventory Detail List-System Product（GSC: Wu Xiao）
HSTC aging report (Finance: Shelley Jiang)
Logistic Expense report (Finance: Xiao Xiao)
5.UT Rework Cost (Include related labor and material)
a)计算公式：返工成本＝返工工时*每小时的制造工时费＋材料费用
b)数据源：Production rework cost monthly report（GSC: Wu Zhiyong）
制造工时费(Finance:Xiao Xiao)
6.TBU CSD/"e 站式"/ Cost
a)计算公式：TBU CSD/"e 站式"/ Cost＝运费+材料费＋劳务费
b)数据源：Warranty monthly report（Finance: Sharon Yang）
7.CRC Material Cost
a)计算公式：CRC Material Cost＝CRC Repair Qty*Material Unit Cost
b)数据源：CRC维修器件明细单（IT: Lily Song）
UTS Item Product Line Report (Finance: Xiao Xiao)
8.RMA inventory Scrap Cost
a) 计算公式：RMA inventory Scrap Cost ＝Qty*Material Unit Cost b) 数据源：备品备件报废清单（GSS: Joy Chen ）
UTS Item Product Line Report (Finance: Xiao Xiao)
9. Freight for returned the parts from field
a) 计算公式：Freight ＝退货运费＋CRC 维修运费 b) 数据源：CRC 维修运费（Finance ：Sharon Yang ）
退货运费 (Logistic: Li Xiuchun) CRC 维修记录 (CRC: Y u JiaYin)
10. MFG Production RMA Labor Cost
a) 计算公式：RMA Labor Cost ＝RMA Labor （Hrs ）*工时费 b) 数据源：CRC 维修运费（FTE ：Chen Ting ）
11. Int'l COPQ Cost
a) 计算公式：int ’l Warranty Cost
b) 数据源：int ’l Warranty report (Bobby Forbes)
12. Cost Saving
a) 计算公式：累加各条记录金额 b) 数据源：Finance
13. Cost Control
a) 计算公式：累加各条记录金额 b) 数据源：Oracle 系统
五， 可靠性
A. MTBF
∑====n i i g
i )i
π(λN /
/λ：MTBF Q
E QUI P 1
11计算公式 B.
C. 数据源：MIL-HDBK-217F, BOM
六， RoHS Compliance Rate （by module ）
数据源：Agile
计算公式：RoHS Compliance Rate ＝符合RoHS 的模板数量/总的模板数量
步骤如下：
1）输入条件（product line ，description ，q-state ，P/N ，lifecycle ），从Agile 中导出2424开头的Module 清单；
2）整理清单，剔除重复的（00与05/06同时存在的只计05/06，不计00结尾的）； 3）根据描述、Q 状态及P/N 结尾特征，筛选出符合与不符合的器件； 4）根据产品线统计各产品的符合比例；
5）根据统计结果，完成统计报告供相关部门参考。
SQA Team ’s KPI
1、Time To Market Slippage Rate Formula ：Date
G1 Actual -Date G4 Actural Date
G4 Planned -Date G4 Actual Rate Slippage Market To Time =
Data Source ：Master schedule
2、Gate Sign Off Compliance Rate Formula ：Passed
Gates Total #Gates
Signed #Rate Compliance Of f Sign Gate =
Data Source ：Team Track
3、PRP Deliverables Compliance Rate
# Total Deliverables Requested by PRP # Actual Deliverables
Formula ：PRP Deliverables Compliance Rate=
Data Source ：EDOC/PDS
4、Requirement Change Rate
Formula ：Requirement Change Rate=
# Changed SRS Items # Total SRS Items
Data Source ：SRS/TeamTrack
5、Review Defect Density
Formula ：Pages
T otal #Reviewer
by Detected Defects #Density Defect
Review =
Data Source ：TeamTrack/Doc Author
6、Review Efficiency
Formula ：Hours
Total #Pages
Review #Ef f iciency Review =
Data Source ：TeamTrack/Doc Author
7、Review Preparation Time
Formula ：Review Preparation Time=Review Meeting Date-Distribute Review Document Date
Data Source ：TeamTrack/Doc Author
8、Review Defect Rate
Formula ：Hours
Total #Reviewer
by Detected Def ects # Rate Def ect Review =
Data Source ：TeamTrack/Doc Author
9、Productivity (LOC)
Formula ：Productivity (LOC) = (New+Removed+Modified) Line of Code Data Source ：ClearCase
10、Overall Internal Defect Density
Formula ：KLOC
Modified)+Removed +(New Defects
Overall #Density Defect Internal Overall =
Data Source ：ClearCase/TeamTrack
11、Defect Detection Percentage Formula
：
phase
after that and during detected defects T otal #phase
a during detected Defects #Percentage Detection Defect =
Data Source ：ClearCase/TeamTrack
12、Defect Detection Rate
Formula ：def ect
Total #phase
a during detected Def ects #Rate Detection Def ect =
Data Source ：ClearCase/TeamTrack
13、Requirement Test Coverage Rate
Formula ：Requirement Test Coverage Rate=# Covered SRS Items
# Total SRS Items
Data Source ：ST
14、ST Pass Rate Formula ：Case
Executed #Cases
Passed #Rate Pass ST =
Data Source ：ST
15、Rejected Internal MR Rate Formula ：MR
Total #MR
Rejected #Rate MR Internal Rejected =
Data Source ：ClearQuest
16、Internal MR Resolution Time(Day)
Formula ：MR
Resolved #Time
Resolution Total Time(Day) Resolution MR Internal =
Data Source ：ClearQuest
17、Software COPQ
Formula ：Software COPQ = Rework Efforts *7$ Data Source ：ClearQuest
18、Software Rework Efforts
Formula: Software Rework Efforts = # Defects detected during phase1 * coefficient during phase1 + # Defects detected during phase2* coefficient during phase2……+ # Defects detected during phase5 * coefficient during phase5
Data Source ：ClearQuest
19、Resolve Rate of Beta Release Formula ：
Beta
Bef ore MR Submitted Total #Beta
Bef ore R Rejected)M +Duplicated +Closed +Verif ied +Resolved (RFB #Release Beta of Rate Resolve +=
Data Source ：ClearQuest
20：# Unresolved S1/S2 MR of Beta Release Formula ：#（New+Assigned+Failed+Analyzing+InsufficientInfo+Postponed ）S1&S2 MR at beta point
Data Source ：ClearQuest
21、Field MR Resolution Time SLA Compliance Rate Formula ：
period
in this MR Overtime)+(Resolved #period
in this on time MR Resolved #Rate Compliance SLA T ime Resolution MR Field =
Note:
1). Statistic cycle time is 30 days.
2). ‘Overtime MR in this period ’ includes those MR which are not overtime in last period, and become overtime during this period. Data Source ：ClearQuest
22、Field MR Closure Time SLA Compliance Rate Formula ：
period
in this MR Overtime)+(Closed #period
in this on time MR Closed #Rate Compliance SLA T ime Closure MR Field =
Note:
1). Statistic cycle time is 60 days.
2).‘Overtime MR in this period ’ includes those MR which are not overtime in last period, and become overtime during this period. Data Source ：ClearQuest
23、Field MR Resolve Rate Formula ：
MR
Total #MR
Rejected)+Duplicated +Closed +Verif ied +Resolved +(RFB #Rate Resolved MR Field =
Data Source ：ClearQuest
24、Field MR Close Rate
Formula ：MR
Total #MR
Closed #Rate Closed MR Field =
Data Source ：ClearQuest
25、Field MR Leak Rate
Formula ：MR
Field)+(Dev T otal #MR
Field #Rate Leak
MR Field =
Data Source ：ClearQuest
CEM T eam’s
1、Service Request (SR) On Time Response Rate
Formula：
SR On Time Response Rate=On Time Response SR during This Period / Total Response SR during This Period
Note:
For Critical SR, On Time Response means Respond <0.5H
For Major SR, On Time Response means Respond <0.5H
For Minor SR, On Time Response means Respond <2H
Target: 90%
Data Source：Oracle
2、Service Request (SR) On Time Resolved Rate
Formula：
SR On Time Resolving Rate=On Time Resolved SR during This Period / Total Resolved SR during This Period
Note:
For Critical SR, On Time Resolved means Resolved <24H
For Major SR, On Time Resolved means Resolved <72H
For Minor SR, On Time Resolved means Resolved <15Days
Target: 97%
Data Source：Oracle
3、Service Request (SR) On Time Recover Rate
Formula：
SR On Time Recover Rate=On Time Recover SR during This Period / Total Recover SR during This Period
Note:
For Critical SR, On Time Recover means Recover <1H
For Major SR, On Time Recover means Recover <2H
Target: 80%
Data Source：Oracle
4、SR Resolved Rate
Formula：
SR Resolved Rate= Resolved SR during This Period / Total Submit SR during This Period
Data Source：Oracle
5、SR Close Rate
Formula：
SR Close Rate= Closed SR during This Period / Total Submit SR during This Period Data Source：Oracle
Change management
KFE/Mini-KFE项目相关测量指标
项目数量=系统里注册的项目数量累计
数据来源；KFE workflow 后台数据系统
参与率=参与的人次/ 总人数
数据来源；KFE workflow 后台数据系统
关闭率=关闭的项目数量/ 总的项目数量
数据来源：KFE workflow 后台数据系统
Cost saving = 项目产生的收益-投入的费用
数据来源：各项目报告