{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Change History","Instructions","Summary","Results","SIDP","A. Leadership - Management","B. Program Execution-Launch","C. Operations - Quality","D. Supply Chain - Purchasing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Change History","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Supplier Assessment Survey Workbook"]
["Revision","Revision Date","Description of Changes"]
["01","16-December-2016","Initial release."]
["02","01-April-2017","Added signature line in Summary tab; \nMade modifications to add issues list to tab SIDP;\nUpdated wording on multiple questions/criteria in tabs A through D to align with new IATF 16949 requirements."]
["03","25-August-2017","Corrected links to www.YFAI.com in column headers on tabs A, B, C and D."]
["04","29-September-2017","Replaced \"IATF 16949\" with \"IATF 16949 or TS 16949\" due recognize the transition period for new standard.\nRemoved % of Sales to YFAI on Summary Tab"]
[null,null,"Removed \"and aware of customer specific requirements\" from A3.1.   "]

{"sheet":"Instructions","index":1,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[[48,0,48,3],[23,0,23,3]]}
[]
[null,"Supplier Assessment Survey\n供应商评审调查及发展计划"]
[]
[]
[null,"Purpose:"]
[null,"The Supplier Assessment Survey(SAS) is used to determine the level of core competencies that are understood and applied and to qualify suppliers for sourcing of future business.    The proper use of the SAS will ensure and promote consistency between activities and personnel determining core competency conformance.SAS是用来决定对核心能力理解和应用的程度，以及供应商对未来业务定点资格的认可，SAS的正确使用将确保和提升活动与个人核心能力符合程度的一致性。"]
[]
[null,"Assessment Method:"]
[null,"The assessment method is a 6 step process:评价方法分6个步骤"]
[]
[null,"Step 1: Supplier Pre-Screen / Self Survey: The Survey is sent out to gather pertinent data and assist in the qualification of the supplier(s).供应商预查/自查：这份调查有助于收集有关的数据以及对供应商资格认可。"]
[]
[null,"Step 2: Review completed self assessment survey. Schedule a conference with supplier to review score and identify evidence requirements for On-Site assessment. This step may be waived if supplier is knowledgeable of assessment process and evidence requirements.完成自我评审调查：与供应商安排一个会议来查看分数以及查看现场评审的证据，如果供应商了解评审的过程和证据要求，这一步可以忽略。"]
[]
[null,"Step 3: Conduct On-Site assessment (if required) to review critical evidence in the form of documentation, quality records, management metrics, etc. On-site assessment will include verification on the plant floor.通过评审文件、质量记录，管理指标等主要证据的形式实施现场评审（如果需要），现场评审包括对工厂车间的验证。"]
[]
[null,"Step 4: Individual questions and overall scoring is scored based on the criteria below.  The overall score is calculated based on a numeric percentage of the individual scores.  Core competency questions are highlighted and have the potential of downgrading the overall score.单项的问题得分以及总的得分是基于以下规则打分的，总的分数计算是根据每个单项得分的数字百分比计算的，核心能力问题是特别强调的，并因此会造成潜在的降级可能。"]
[]
[null,"Step 5:  Supplier is required to develop  a Supplier Individual Development Plant (SIDP) for all Core Competency questions rated (1) and all other questions rated (1).  A supplier SIDP is also required for all questions rated (2) when the overall score is less than 85%.  The SIDP must be submitted within 30 days unless formally agreed to with YFAI Supplier Development.  While not required an SIDP is strongly recommended when scores are greater than 85%.  \n当所有核心能力问题（供应商单项开发计划）评价为（1）以及所有其他问题评价为（1）时，供应商被要求制定一份SIDP。当所有问题评价为（2），总体得分少于85%供应商也要求制定一份SIDP；SIDP必须在30天内提交，除非得到YFAI供应商开发科的书面同意；分数高于85%时供应商被推荐资格认可。"]
[]
[null,"Step 6: Review supplier SIDP and upload completed assessment and action plan to SAS Database. If on-site verification is required schedule assessment and upload documents after completion of verification assessment.评估供应商SIDP，上传完成的评价，以及对SAS数据的执行计划，如果要求去供应商现场对SIDP进行验证的话，在完成现场验证后上传相关文件。"]
[]
[]
["SASDP Evaluation Scoring Criteria供应商评审评价得分准则"]
[]
[null,"INDIVIDUAL QUESTION CRITERIA单项的问题准则","SCORE"]
[null,"Observations indicate high risk - minimal standards, systems in place审核结果显示高风险-几乎没有标准、体系",1]
[]
[null,"Observations indicate moderate risk - standards/systems in place but improvement recommended审核结果显示一般的风险-具有标准、体系，但是需要提升改进",2]
[]
[null,"Observations indicate low/minimal risk - standards/systems appear robust and effective审核结果显示低风险-标准、体系成熟有效",3]
[]
[null,"OVERALL SCORING CRITERIA整体的评分准则"]
[null,"The overall score is calculated based on the numeric percentage of the sum of the scores for individual questions.总体得分是根据所有项单项得分的数字百分比计算的"]
[null,"Individual questions have the same weighting.  单个问题有同样的比重"]
[null,"The overall score will be DOWNGRADED based on the results of the scores for core compentency (*) questions.总得分会根据核心能力（标注*）问题的得分结果来降级"]
[null," - If any one non (*) questions are rated 1 (red), the final audit score will be minimum YELLOW.如果没有问题评为1（红色），最后的评价得分至少为黄色"]
[null," - If >50% of the (*) questions are rated 2 (yellow), the final audit score will be YELLOW.如果大于50%的问题评为2（黄色），最后的评审得分将是黄色。"]
[null," - If any one (*) question are rated 1 (red), the final audit score will be RED.如果任何一个带*问题评为1（红色），最后的评审得分为红色"]
[null,"The overall score will be DOWNGRADED to RED if the supplier fails to submit the Supplier Development Plan (SIDP) within 30 days.\n如果供应商不能在30天内提交SIDP给YFAI，则最后的评审结果降级为红色。"]
[]
[null,"Unacceptable:  Overall Score < 65%: Unacceptable, not recommended for sourcing,  Immediate SIDP required不能接受：总得分<65%：不推荐定点，要求立即实施SIDP。"]
[]
[null,"Conditionally Acceptable: Overall Score  >= 65% < 85%: Conditionally acceptable, SIDP required有条件接受，总得分>=65%<85%：有条件接受，要求SIDP "]
[]
[null,"Acceptable: Overall Score  >= 85% and no red scores: Acceptable, SIDP may be required接受：总得分>=85%，并且无红色项，可能要求SIDP"]
[]
[]
["Specific Form Instructions具体的表格说明"]
[]
[null,"1.  Prior to completing the form you must Enable Macros from the Windows menu. 在完成此表格之前，你必须确保你的Windows菜单具有启用宏的功能。"]
[null,"2.  After completing all of the questions hit the \"Check\" button on the top of the screen on the SIDP to auto-populate  "]
[null,"    the questions that require a Supplier Individual Development Plan.完成所有问题时点击SIDP屏幕上方“检查”按钮，会自动切换到要求对供应商单项开发计划的问题界面。"]

{"sheet":"Summary","index":2,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,0,50,4],[50,5,50,10],[4,7,4,8],[7,0,8,0],[31,3,31,5],[7,7,7,8],[5,7,5,8],[6,7,6,8],[19,5,19,9],[22,5,22,9],[23,5,23,9],[12,1,12,4],[21,1,21,4],[14,1,14,4],[22,1,22,4],[23,1,23,4],[16,1,16,4],[17,1,17,4],[0,1,0,9],[20,5,20,9],[21,5,21,9],[14,5,14,9],[16,5,16,9],[17,5,17,9],[18,5,18,9],[11,1,11,4],[11,5,11,9],[12,5,12,9],[3,0,3,10],[4,1,5,4],[4,0,5,0],[7,1,8,4],[7,9,7,10],[6,1,6,4],[49,0,49,10],[35,7,41,10],[25,7,31,10],[35,3,35,5],[37,3,37,5],[39,3,39,5],[41,3,41,5],[25,0,25,2],[27,0,27,2],[29,0,29,2],[31,0,31,2],[33,0,33,2],[18,1,18,4],[19,1,19,4],[20,1,20,4],[45,5,47,7],[44,0,44,4],[44,5,44,10],[45,0,47,0],[45,2,45,4],[45,9,45,10],[46,2,46,4],[46,9,46,10],[47,2,47,4],[47,9,47,10]]}
[" ","Supplier Assessment Survey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
["Supplier Name\n供应商名称",null,null,null,null,null,null,null,null,"Self Assessment Date  自评审时间"]
[null,null,null,null,null,null,null,null,null,"On-Site Survey Date 现场审核时间"]
["Supplier Vendor Number\n组织代码",null,null,null,null,null,null,null,null,"Corrective Action Plan Due 整改计划到期日"]
["Supplier Location\n地址",null,null,null,null,null,null,null,null,"On-site Verification Date 现场验证时间"]
[]
[]
[]
[null,"Name / Title姓名/职务",null,null,null,"Email邮箱地址",null,null,null,null,"Phone电话"]
["YFAI Auditor\nYFAI审核员 "]
[]
["Supplier Lead Auditor\n供应商主要迎审人员:  "]
[]
["Other Audit Participants\n审核参与人员:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Status\n当前状态","Expiration Date\n到期日","Name of Certifier\n证书名称",null,"Major Products 主要产品"]
["Supplier is ISO 9001 3rd Party Certified?\n是否有ISO9001第三方认证？"]
[]
["Supplier is IATF 16949 or TS 16949   3rd  Party Certified?\n是否IATF 16949 第三方认证？"]
[]
["Supplier is ISO 14001 compliant or Certified?\n是否ISO14001认证？"]
[]
["Other Certifications?其他认证"]
[]
["Sustainability survey completed on YFAI portal?\n是否完成YFAI 外网上的持续调查？",null,null,null,null,null,null,"Major Processes 主要工艺"]
[]
["Facility Size (sq meter, sq ft)设备型号:"]
[]
["# of Employees员工人数:"]
[]
["Age of Facility设备年限:"]
[]
[]
[]
[]
["Yanfeng Interiors On-Site Overall Score\nYFAI 现场评审分数",null,null,null,null,"Supplier Self Assessment Overall Score\n供应商自评分数"]
[{"$f":"Results!J22","v":0},"G","Acceptable, SIDP may be required\n认可",null,null,{"$f":"Results!X22","v":0},null,null,"G","Acceptable, SIDP may be required\n认可"]
[null,"Y","Conditionally acceptable, SIDP required\n带条件认可，需要提交SIDP",null,null,null,null,null,"Y","Conditionally acceptable, SIDP required\n带条件认可，需要提交SIDP"]
[null,"R","Unacceptable,  SIDP required\n不认可，需要提交SIDP",null,null,null,null,null,"R","Unacceptable,  SIDP required\n不认可，需要提交SIDP"]
["Comments leading to decision  综合评定"]
[]
["YFAI Auditor Signature:\nYFAI审核员签名:",null,null,null,null,"Supplier Signature:\n供应商签名:"]

{"sheet":"Results","index":3,"n_rows":79,"n_cols":28,"rows_kept":79,"cut":false,"hidden":false,"merged":[[70,0,70,19],[21,9,21,10],[24,0,24,4],[49,0,49,19],[53,0,53,19],[59,0,59,19],[42,0,42,19],[47,0,47,19],[48,0,48,19],[26,0,26,4],[27,0,27,4],[36,0,36,19],[29,0,29,4],[28,5,28,7],[29,5,29,7],[24,5,24,13],[71,0,71,19],[31,20,31,24],[43,0,43,19],[66,0,66,19],[46,0,46,19],[56,0,56,19],[38,0,38,19],[39,0,39,19],[40,0,40,19],[50,0,50,19],[69,0,69,19],[67,0,67,19],[68,0,68,19],[37,0,37,19],[34,0,34,19],[60,0,60,19],[0,4,0,20],[21,14,21,22],[4,0,4,4],[21,0,21,7],[23,0,23,4],[2,0,2,24],[21,23,21,24],[11,0,11,4],[18,0,18,3],[17,0,17,3],[19,0,19,3],[16,0,16,3],[23,20,23,24],[23,5,23,13],[24,20,24,24],[25,0,25,4],[25,5,25,13],[26,5,26,13],[62,0,62,19],[27,5,27,7],[35,0,35,19],[28,0,28,4],[41,0,41,19],[32,0,32,7],[64,0,64,19],[61,0,61,19],[54,0,54,19],[44,0,44,19],[63,0,63,19],[57,0,57,19],[58,0,58,19],[51,0,51,19],[52,0,52,19]]}
[null,null,null,null,"Supplier Assessment Survey"]
[]
["Individual Question Scores单项问题评分"]
[]
["Supplier Self Assessment Results\n供应商自评分数",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,"POS","Sum","%"]
["A.","Leadership -Management",null,null,null,{"$f":"'A. Leadership - Management'!$F$11","v":0},{"$f":"'A. Leadership - Management'!$F$12","v":0},{"$f":"'A. Leadership - Management'!$F$13","v":0},{"$f":"'A. Leadership - Management'!$F$14","v":0},{"$f":"'A. Leadership - Management'!$F$19","v":0},{"$f":"'A. Leadership - Management'!$F$20","v":0},{"$f":"'A. Leadership - Management'!$F$21","v":0},{"$f":"'A. Leadership - Management'!$F$22","v":0},{"$f":"'A. Leadership - Management'!$F$33","v":0},{"$f":"'A. Leadership - Management'!$F$34","v":0},{"$f":"'A. Leadership - Management'!$F$35","v":0},{"$f":"'A. Leadership - Management'!$F$41","v":0},{"$f":"'A. Leadership - Management'!$F$42","v":0},{"$f":"'A. Leadership - Management'!$F$48","v":0},{"$f":"'A. Leadership - Management'!$F$49","v":0},{"$f":"'A. Leadership - Management'!$F$55","v":0},{"$f":"'A. Leadership - Management'!$F$56","v":0},51,{"$f":"SUM(F6:V6)","v":0},{"$f":"X6/W6","v":0}]
["B.","Program Execution",null,null,null,{"$f":"'B. Program Execution-Launch'!$F$11","v":0},{"$f":"'B. Program Execution-Launch'!$F$12","v":0},{"$f":"'B. Program Execution-Launch'!$F$18","v":0},{"$f":"'B. Program Execution-Launch'!$F$19","v":0},{"$f":"'B. Program Execution-Launch'!$F$20","v":0},{"$f":"'B. Program Execution-Launch'!$F$21","v":0},{"$f":"'B. Program Execution-Launch'!$F$27","v":0},{"$f":"'B. Program Execution-Launch'!$F$28","v":0},{"$f":"'B. Program Execution-Launch'!$F$29","v":0},{"$f":"'B. Program Execution-Launch'!$F$30","v":0},{"$f":"'B. Program Execution-Launch'!$F$31","v":0},null,null,null,null,null,null,33,{"$f":"SUM(F7:P7)","v":0},{"$f":"X7/W7","v":0}]
["C.","Operations - Quality",null,null,null,{"$f":"'C. Operations - Quality'!$F$11","v":0},{"$f":"'C. Operations - Quality'!$F$12","v":0},{"$f":"'C. Operations - Quality'!$F$13","v":0},{"$f":"'C. Operations - Quality'!$F$14","v":0},{"$f":"'C. Operations - Quality'!$F$15","v":0},{"$f":"'C. Operations - Quality'!$F$16","v":0},{"$f":"'C. Operations - Quality'!$F$17","v":0},{"$f":"'C. Operations - Quality'!$F$18","v":0},{"$f":"'C. Operations - Quality'!$F$19","v":0},{"$f":"'C. Operations - Quality'!$F$20","v":0},{"$f":"'C. Operations - Quality'!$F$21","v":0},{"$f":"'C. Operations - Quality'!$F$27","v":0},{"$f":"'C. Operations - Quality'!$F$28","v":0},{"$f":"'C. Operations - Quality'!$F$29","v":0},{"$f":"'C. Operations - Quality'!$F$30","v":0},{"$f":"'C. Operations - Quality'!$F$31","v":0},null,48,{"$f":"SUM(F8:U8)","v":0},{"$f":"X8/W8","v":0}]
["D.","Supply Chain - Purchasing",null,null,null,{"$f":"'D. Supply Chain - Purchasing'!$F$11","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$12","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$13","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$19","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$20","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$26","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$27","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$28","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$29","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$30","v":0},{"$f":"'D. Supply Chain - Purchasing'!$F$31","v":0},null,null,null,null,null,null,33,{"$f":"SUM(F9:P9)","v":0},{"$f":"X9/W9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W6:W9)","v":165},{"$f":"SUM(X6:X9)","v":0},{"$f":"X10/W10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84,0.64]
["Yanfeng Interiors On-Site Results\nYFAI现场评审分数",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,"POS","Sum","%"]
["A.","Leadership -Management",null,null,null,{"$f":"'A. Leadership - Management'!$E$11","v":0},{"$f":"'A. Leadership - Management'!$E$12","v":0},{"$f":"'A. Leadership - Management'!$E$13","v":0},{"$f":"'A. Leadership - Management'!$E$14","v":0},{"$f":"'A. Leadership - Management'!$E$19","v":0},{"$f":"'A. Leadership - Management'!$E$20","v":0},{"$f":"'A. Leadership - Management'!$E$21","v":0},{"$f":"'A. Leadership - Management'!$E$22","v":0},{"$f":"'A. Leadership - Management'!$E$33","v":0},{"$f":"'A. Leadership - Management'!$E$34","v":0},{"$f":"'A. Leadership - Management'!$E$35","v":0},{"$f":"'A. Leadership - Management'!$E$41","v":0},{"$f":"'A. Leadership - Management'!$E$42","v":0},{"$f":"'A. Leadership - Management'!$E$48","v":0},{"$f":"'A. Leadership - Management'!$E$49","v":0},{"$f":"'A. Leadership - Management'!$E$55","v":0},{"$f":"'A. Leadership - Management'!$E$56","v":0},51,{"$f":"SUM(F13:V13)","v":0},{"$f":"X13/W13","v":0}]
["B.","Program Execution",null,null,null,{"$f":"'B. Program Execution-Launch'!$E$11","v":0},{"$f":"'B. Program Execution-Launch'!$E$12","v":0},{"$f":"'B. Program Execution-Launch'!$E$18","v":0},{"$f":"'B. Program Execution-Launch'!$E$19","v":0},{"$f":"'B. Program Execution-Launch'!$E$20","v":0},{"$f":"'B. Program Execution-Launch'!$E$21","v":0},{"$f":"'B. Program Execution-Launch'!$E$27","v":0},{"$f":"'B. Program Execution-Launch'!$E$28","v":0},{"$f":"'B. Program Execution-Launch'!$E$29","v":0},{"$f":"'B. Program Execution-Launch'!$E$30","v":0},{"$f":"'B. Program Execution-Launch'!$E$31","v":0},null,null,null,null,null,null,33,{"$f":"SUM(F14:P14)","v":0},{"$f":"X14/W14","v":0}]
["C.","Operations - Quality",null,null,null,{"$f":"'C. Operations - Quality'!$E$11","v":0},{"$f":"'C. Operations - Quality'!$E$12","v":0},{"$f":"'C. Operations - Quality'!$E$13","v":0},{"$f":"'C. Operations - Quality'!$E$14","v":0},{"$f":"'C. Operations - Quality'!$E$15","v":0},{"$f":"'C. Operations - Quality'!$E$16","v":0},{"$f":"'C. Operations - Quality'!$E$17","v":0},{"$f":"'C. Operations - Quality'!$E$18","v":0},{"$f":"'C. Operations - Quality'!$E$19","v":0},{"$f":"'C. Operations - Quality'!$E$20","v":0},{"$f":"'C. Operations - Quality'!$E$21","v":0},{"$f":"'C. Operations - Quality'!$E$27","v":0},{"$f":"'C. Operations - Quality'!$E$28","v":0},{"$f":"'C. Operations - Quality'!$E$29","v":0},{"$f":"'C. Operations - Quality'!$E$30","v":0},{"$f":"'C. Operations - Quality'!$E$31","v":0},null,48,{"$f":"SUM(F15:U15)","v":0},{"$f":"X15/W15","v":0}]
["D.","Supply Chain - Purchasing",null,null,null,{"$f":"'D. Supply Chain - Purchasing'!$E$11","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$12","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$13","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$19","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$20","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$26","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$27","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$28","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$29","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$30","v":0},{"$f":"'D. Supply Chain - Purchasing'!$E$31","v":0},null,null,null,null,null,null,33,{"$f":"SUM(F16:P16)","v":0},{"$f":"X16/W16","v":0}]
["Category",null,null,null,"  Conclusions / next steps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W13:W16)","v":165},{"$f":"SUM(X13:X16)","v":0},{"$f":"X17/W17","v":0}]
["Unacceptable",null,null,null,"  Indicator < 65%: Unacceptable, not recommended for sourcing,  Immediate SIDP required"]
["Conditionally Accpetable",null,null,null,"  Indicator >= 65% < 85%: Conditionally acceptable, SIDP required "]
["Acceptable",null,null,null,"  Indicator >= 85% and no red scores: Acceptable, SIDP may be required"]
[]
["Yanfeng Interiors On-Site Overall Score\nYFAI现场评审分数",null,null,null,null,null,null,null,null,{"$f":"IF(U73>=1,MIN($Y$11,$Y$17),IF(U74>=8,MIN($X$11,$Y$17),IF(U79=1,MIN($X$11,$Y$17),$Y$17)))","v":0},null,null,null,null,"Supplier Self Assessment Overall Score\n供应商自评分数",null,null,null,null,null,null,null,null,{"$f":"IF(X73>=1,MIN($Y$11,$Y$10),IF(X74>=8,MIN($X$11,$Y$10),IF(X79=1,MIN($X$11,$Y$10),$Y$10)))","v":0}]
[]
["Supplier Name",null,null,null,null,{"$f":"Summary!$B$5","v":0}]
["Supplier Location",null,null,null,null,{"$f":"Summary!$B$8","v":0}]
["Supplier Lead Auditor",null,null,null,null,{"$f":"Summary!$B$15","v":0}]
["YFAI Auditor",null,null,null,null,{"$f":"Summary!$B$13","v":0}]
["Self Assessment Date",null,null,null,null,{"$f":"Summary!$H$5","v":"00:00:00"}]
["On - Site Survey Date",null,null,null,null,{"$f":"Summary!$H$6","v":"00:00:00"}]
["Corrective Action Plan Due:",null,null,null,null,{"$f":"Summary!$H$7","v":"00:00:00"}]
[]
["Sub Section Results / Core Competency Questions"]
["子项结果/核心项问题",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YFAI",null,null,"Supplier"]
["A.  Leadership / Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum","%",null,"Sum","%"]
["A.1 Health and Safety",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E15","v":0},{"$f":"'A. Leadership - Management'!E17","v":0},null,{"$f":"'A. Leadership - Management'!F15","v":0},{"$f":"'A. Leadership - Management'!F17","v":0},2,4,5]
["A.2 Customer Interface",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E29","v":0},{"$f":"'A. Leadership - Management'!E31","v":0},null,{"$f":"'A. Leadership - Management'!F29","v":0},{"$f":"'A. Leadership - Management'!F31","v":0},2,4,5]
["A.3 Capacity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E37","v":0},{"$f":"'A. Leadership - Management'!E39","v":0},null,{"$f":"'A. Leadership - Management'!F37","v":0},{"$f":"'A. Leadership - Management'!F39","v":0},2,4,5]
["A.4 Product and Process Targets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E44","v":0},{"$f":"'A. Leadership - Management'!E46","v":0},null,{"$f":"'A. Leadership - Management'!F44","v":0},{"$f":"'A. Leadership - Management'!F46","v":0},2,4,5]
["A.5 Quality Systems Certifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E51","v":0},{"$f":"'A. Leadership - Management'!E53","v":0},null,{"$f":"'A. Leadership - Management'!F51","v":0},{"$f":"'A. Leadership - Management'!F53","v":0}]
["A.6 Human Resources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E58","v":0},{"$f":"'A. Leadership - Management'!E60","v":0},null,{"$f":"'A. Leadership - Management'!F58","v":0},{"$f":"'A. Leadership - Management'!F60","v":0}]
["Core Competency Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(U42:U45,1)","v":0},null,null,{"$f":"COUNTIF(X42:X45,1)","v":0}]
["A.1.4* Have the supplier passed the additional safety and environmental YFAI China audit and he has the final acceptance consistent with Government requirements ? (Applicable in AP)供应商是否获得相关部门针对安全与环境方面的审核，并取得政府部门的最终批准认可？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E14","v":0},null,null,{"$f":"'A. Leadership - Management'!F14","v":0}]
["A.3.1* Are the necessary personnel resources planned and available for any current or new business? 是否针对现有的或新的业务对人力资源进行了必要的规划？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E33","v":0},null,null,{"$f":"'A. Leadership - Management'!F33","v":0}]
["A.3.2* Are the production resources planned to be in line with current and future customer demands? 是否针对当前的和未来顾客的需要对生产环节进行资源策划？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E34","v":0},null,null,{"$f":"'A. Leadership - Management'!F34","v":0},null,2,4,5]
["A.5.1* Does the supplier carry out quality system audits for the products and processes as planned and address the issues? 供应商是否按照策划的频次针对产品和过程实施质量体系审核，并对审核的结果采取措施？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Leadership - Management'!E48","v":0},null,null,{"$f":"'A. Leadership - Management'!F48","v":0}]
["B. Program Execution / Launch"]
["B.1  Program Management ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E14","v":0},{"$f":"'B. Program Execution-Launch'!E16","v":0},null,{"$f":"'B. Program Execution-Launch'!F14","v":0},{"$f":"'B. Program Execution-Launch'!F16","v":0},2,4,5]
["B.2  Understanding Customer Requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E23","v":0},{"$f":"'B. Program Execution-Launch'!E25","v":0},null,{"$f":"'B. Program Execution-Launch'!F23","v":0},{"$f":"'B. Program Execution-Launch'!F25","v":0}]
["B.3  PPAP Execution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E33","v":0},{"$f":"'B. Program Execution-Launch'!E35","v":0},null,{"$f":"'B. Program Execution-Launch'!F33","v":0},{"$f":"'B. Program Execution-Launch'!F35","v":0}]
["Core Competency Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(U51:U55,1)","v":0},null,null,{"$f":"COUNTIF(X51:X55,1)","v":0}]
["B.1.1* Is the project organization (program management) established and are the task and authorities specified for all team members assuring tracking of APQP, Process sign-off or equivalent requirements and meeting customer timing requirements?是否成立项目小组来管理项目？为保证APQP的有效推进、投产认可（或等效过程）、满足客户进度要求，小组成员的任务和职责权限是否规定？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E11","v":0},null,null,{"$f":"'B. Program Execution-Launch'!F11","v":0}]
["B.2.1* Does the supplier understand applicable customer requirements (including OEM's) ?供应商是否充分理解客户的要求（包括OEM的要求）？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E18","v":0},null,null,{"$f":"'B. Program Execution-Launch'!F18","v":0}]
["B.2.2* Does the supplier have materials and product testing capabilities to assure ongoing conformance to material, legal, and performance specifications?  供应商是否具备材料和产品的测试能力，以确保在材料、法规要求和性能要求的持续符合性？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E19","v":0},null,null,{"$f":"'B. Program Execution-Launch'!F19","v":0}]
["B.2.4* Does the supplier identify appropriate error proofing applications for significant characteristics of the products?    供应商是否针对产品关键特性的控制实施了防错方案？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E21","v":0},null,null,{"$f":"'B. Program Execution-Launch'!F21","v":0}]
["B.3.1* Is a Production Part Approval Process in use and capable of meeting customers expectations ? Is a YFAI recognized format, or equivalent, for part submission process utilized throughout the organization?   PPAP过程是否符合客户期望，且在供应商整个机构内是否应用了YFAI认可的零部件提交形式？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'B. Program Execution-Launch'!E27","v":0},null,null,{"$f":"'B. Program Execution-Launch'!F27","v":0}]
["C. Operations - Quality"]
["C.1  Process Analysis / Production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E23","v":0},{"$f":"'C. Operations - Quality'!E25","v":0},null,{"$f":"'C. Operations - Quality'!F23","v":0},{"$f":"'C. Operations - Quality'!F25","v":0},2,4,5]
["C.2  Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E33","v":0},{"$f":"'C. Operations - Quality'!E35","v":0},null,{"$f":"'C. Operations - Quality'!F33","v":0},{"$f":"'C. Operations - Quality'!F35","v":0}]
["Core Competency Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(U60:U65,1)","v":0},null,null,{"$f":"COUNTIF(X60:X65,1)","v":0}]
["C.1.1* Is the incoming materials process managed properly in order to ensure that the product is manufactured per customer requirements ?   为确保生产的产品满足客户的要求，是否对进料进行了适当的控制？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E11","v":0},null,null,{"$f":"'C. Operations - Quality'!F11","v":0}]
["C.1.2* Are the workstations and test/inspection areas suitable for requirements and ergonomical ? 操作工位和测试检验区域是否符合要求和有利于提高工效？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E12","v":0},null,null,{"$f":"'C. Operations - Quality'!F12","v":0}]
["C.1.3* Can the quality requirements be monitored effectively with the test, inspection and measurements facilities employed (including outside sourcing)?是否采用了适当的测试检验工具对产品质量要求进行了有效地监控（包括外包测试项目）？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E13","v":0},null,null,{"$f":"'C. Operations - Quality'!F13","v":0}]
["C.1.4* Are significant characteristics controlled in production ?在生产过程中是否对关键特性进行了控制？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E14","v":0},null,null,{"$f":"'C. Operations - Quality'!F14","v":0}]
["C.1.5* Does the supplier has a process in place for segregation and containment of rejected parts ? 是否有流程保证对于不合格品进行隔离与遏制？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E15","v":0},null,null,{"$f":"'C. Operations - Quality'!F15","v":0}]
["C.1.6* In case of deviations from product or process requirements, are the causes analyzed and the corrective actions checked for effectiveness ?是否针对产品和过程的偏差，采取有效的原因分析与纠正措施？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C. Operations - Quality'!E16","v":0},null,null,{"$f":"'C. Operations - Quality'!F16","v":0}]
["D. Supply Chain - Purchasing"]
["D.1  Supply Base Management ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'D. Supply Chain - Purchasing'!E15","v":0},{"$f":"'D. Supply Chain - Purchasing'!E17","v":0},null,{"$f":"'D. Supply Chain - Purchasing'!F15","v":0},{"$f":"'D. Supply Chain - Purchasing'!F17","v":0},2,4,5]
["D.2  Electronic Data Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'D. Supply Chain - Purchasing'!E22","v":0},{"$f":"'D. Supply Chain - Purchasing'!E24","v":0},null,{"$f":"'D. Supply Chain - Purchasing'!F22","v":0},{"$f":"'D. Supply Chain - Purchasing'!F24","v":0}]
["D.3  Material Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'D. Supply Chain - Purchasing'!E33","v":0},{"$f":"'D. Supply Chain - Purchasing'!E35","v":0},null,{"$f":"'D. Supply Chain - Purchasing'!F33","v":0},{"$f":"'D. Supply Chain - Purchasing'!F35","v":0}]
["Core Competency Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(U71:U72,1)","v":0},null,null,{"$f":"COUNTIF(X71:X72,1)","v":0}]
["D.1.1* Are only approved / released and quality capable sub-suppliers selected ?是否仅仅批准/同意有质量能力的分供方供货？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'D. Supply Chain - Purchasing'!E11","v":0},null,null,{"$f":"'D. Supply Chain - Purchasing'!F11","v":0},null,2,4,5]
["D.1.3* Is the quality of the out-sourced products and services ensured?  如何确保外协的产品与服务质量？",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'D. Supply Chain - Purchasing'!E13","v":0},null,null,{"$f":"'D. Supply Chain - Purchasing'!F13","v":0},null,2,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U41+U50+U59+U70","v":0},null,null,{"$f":"X41+X50+X59+X70","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50% Rule",{"$f":"COUNTIF(U42:U45,2)+COUNTIF(U51:U55,2)+COUNTIF(U60:U65,2)+COUNTIF(U71:U72,2)","v":0},null,"50% Rule",{"$f":"COUNTIF(X43:X45,2)+COUNTIF(X51:X55,2)+COUNTIF(X60:X65,2)+COUNTIF(X71:X72,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Non-star 1",{"$f":"IF(OR('A. Leadership - Management'!E11=1,'A. Leadership - Management'!E12=1,'A. Leadership - Management'!E13=1,'A. Leadership - Management'!E19=1,'A. Leadership - Management'!E20=1,'A. Leadership - Management'!E21=1,'A. Leadership - Management'!E22=1,'A. Leadership - Management'!E35=1,'A. Leadership - Management'!E41=1,'A. Leadership - Management'!E42=1,'A. Leadership - Management'!E49=1,'A. Leadership - Management'!E55=1,'A. Leadership - Management'!E56=1)=TRUE,1,0)","v":0},null,"Non-star 1",{"$f":"IF(OR('A. Leadership - Management'!F11=1,'A. Leadership - Management'!F12=1,'A. Leadership - Management'!F13=1,'A. Leadership - Management'!F19=1,'A. Leadership - Management'!F20=1,'A. Leadership - Management'!F21=1,'A. Leadership - Management'!F22=1,'A. Leadership - Management'!F35=1,'A. Leadership - Management'!F41=1,'A. Leadership - Management'!F42=1,'A. Leadership - Management'!F49=1,'A. Leadership - Management'!F55=1,'A. Leadership - Management'!F56=1)=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Non-star 1",{"$f":"IF(OR('B. Program Execution-Launch'!E12=1,'B. Program Execution-Launch'!E20=1,'B. Program Execution-Launch'!E28=1,'B. Program Execution-Launch'!E29=1,'B. Program Execution-Launch'!E30=1,'B. Program Execution-Launch'!E31=1)=TRUE,1,0)","v":0},null,"Non-star 1",{"$f":"IF(OR('B. Program Execution-Launch'!F12=1,'B. Program Execution-Launch'!F20=1,'B. Program Execution-Launch'!F28=1,'B. Program Execution-Launch'!F29=1,'B. Program Execution-Launch'!F30=1,'B. Program Execution-Launch'!F31=1)=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Non-star 1",{"$f":"IF(OR('C. Operations - Quality'!E17=1,'C. Operations - Quality'!E18=1,'C. Operations - Quality'!E19=1,'C. Operations - Quality'!E20=1,'C. Operations - Quality'!E21=1,'C. Operations - Quality'!E27=1,'C. Operations - Quality'!E28=1,'C. Operations - Quality'!E29=1,'C. Operations - Quality'!E30=1,'C. Operations - Quality'!E31=1)=TRUE,1,0)","v":0},null,"Non-star 1",{"$f":"IF(OR('C. Operations - Quality'!F17=1,'C. Operations - Quality'!F18=1,'C. Operations - Quality'!F19=1,'C. Operations - Quality'!F20=1,'C. Operations - Quality'!F21=1,'C. Operations - Quality'!F27=1,'C. Operations - Quality'!F28=1,'C. Operations - Quality'!F29=1,'C. Operations - Quality'!F30=1,'C. Operations - Quality'!F31=1)=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Non-star 1",{"$f":"IF(OR('D. Supply Chain - Purchasing'!E12=1,'D. Supply Chain - Purchasing'!E19=1,'D. Supply Chain - Purchasing'!E20=1,'D. Supply Chain - Purchasing'!E26=1,'D. Supply Chain - Purchasing'!E27=1,'D. Supply Chain - Purchasing'!E28=1,'D. Supply Chain - Purchasing'!E29=1,'D. Supply Chain - Purchasing'!E30=1,'D. Supply Chain - Purchasing'!E31=1)=TRUE,1,0)","v":0},null,"Non-star 1",{"$f":"IF(OR('D. Supply Chain - Purchasing'!F12=1,'D. Supply Chain - Purchasing'!F19=1,'D. Supply Chain - Purchasing'!F20=1,'D. Supply Chain - Purchasing'!F26=1,'D. Supply Chain - Purchasing'!F27=1,'D. Supply Chain - Purchasing'!F28=1,'D. Supply Chain - Purchasing'!F29=1,'D. Supply Chain - Purchasing'!F30=1,'D. Supply Chain - Purchasing'!F31=1)=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-star 1",{"$f":"MAX(U75,U76,U77,U78)","v":0},null,"Non-star 1",{"$f":"MAX(X75,X76,X77,X78)","v":0}]

{"sheet":"SIDP","index":4,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,7,4,9],[6,0,6,9],[7,0,7,1],[7,2,7,3],[0,5,0,6],[1,7,1,9],[2,7,2,9],[3,7,3,9]]}
[]
[null,null,null,null,null,null,"Supplier Name",{"$f":"Summary!B5","v":0}]
[null,null,"Supplier Assessment Survey",null,null,null,"Supplier Location",{"$f":"Summary!B8","v":0}]
[null,null,null,null,null,null,"Self Assessment Date",{"$f":"Summary!H5","v":"00:00:00"}]
[null,null,null,null,null,null,"On-Site Survey Date",{"$f":"Summary!H6","v":"00:00:00"}]
[]
["Supplier Individual Development Plan (SIDP)"]
["Primary Area\n问题描述",null,"Score\n评分",null,"Issue List\n问题描述","Action Plan\n行动计划","Resp.\n责任人","Target\n目标","Complete\n完成","Status\n当前状态"]
[null,"A. Leadership - Management 管理评审","YFAI\nResult","Sup.\nResult"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "," "," "," "," "]
[null,null,null,null,null," "," "," "," "," "]
[null,"B. Program Execution-Launch 项目运作 - 投产","YFAI\nResult","Sup.\nResult"]
[null,null,null,null,null,null," "," ",null," "]
[]
[null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "," ",null," "]
[]
[null,"C. Operations - Quality 生产运营 - 质量","YFAI\nResult","Sup.\nResult"]
[null,null,null,null,null,null," "," "," "," "]
[null,null,null,null,null,null," "," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "," ",null," "]
[]
[null,"D. Supply Chain - Purchasing 供应链 - 采购","YFAI\nResult","Sup.\nResult"]
[null,null,null,null,null,null," "," "," "," "]
[null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "," ",null," "]
[]
[null,null,null,null,null,"Road Map Owner: ",null," ","Updated:"]

{"sheet":"A. Leadership - Management","index":5,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[21,0,26,0],[4,4,4,5],[21,1,26,1],[21,4,26,4],[21,5,26,5],[6,3,6,5],[5,3,5,5],[7,0,7,1],[2,2,3,2],[1,4,1,5],[0,4,0,5],[2,4,2,5],[3,4,3,5]]}
[]
[null,null,null,"Supplier Name",{"$f":"Summary!B5","v":0}]
[null,null,"Supplier Assessment Survey","Supplier Location",{"$f":"Summary!B8","v":0}]
[null,null,null,"Self Assessment Date",{"$f":"Summary!H5","v":"00:00:00"}]
[null,null,null,"On-Site Survey Date",{"$f":"Summary!H6","v":"00:00:00"}]
[null,null,null,"YFAI Supplier Standards Manual"]
[null,null,null,"http://www.yfai.com"]
["A.  Leadership / Management",null,"Criteria","Comments","YFAI Result","Supplier Result"]
[]
["A.1  Health and Safety"]
["A.1.1","Does the supplier have a proactive health and safety plan?    供应商是否具有致力于改善健康与安全的计划？","1.  There is an established corporate health and safety policy.   制定公司的健康与安全方针\n2.  There are identifiable and visual health and safety goals and measurements.   可识别的和可视的健康与安全目标与测量方法\n3.  A Health and Safety Champion exists. 指定负责健康与安全的负责人\n4.  Procedures and employee operating instructions (e.g., emergency preparedness, fork lift safety, confined space, lockout/tagout, etc.) exist and are controlled.   具有安全的程序与操作指导文件（应急预案、叉车安全、狭窄的空间、锁定/挂牌等），并受控。\n5.  Internal and external training requirements are established and tracked (e.g., Orientation, on-the-job, first aid, hazardous waste, CPR, etc.).  是否建立针对内部和外部的培训需求，并对执行情况进行跟踪（如，培训、岗位要求、急救、有害物质检测、心肺功能检测等）\n6.  Personal protective equipment is provided and budgeted.  提供人身保护设施的预算。"]
["A.1.2","Does the supplier measure and utilize a safety incident rate?    供应商是否建立并评估了安全事故率？","1.  Incidents are measured (e.g., incidents/100 employees), tracked, and reported.对安全事故进行考量（如，次数/100人）、跟踪和报告。\n2.  Incident investigations are conducted to identify root causes.对安全事故的根本原因进行调查分析。\n3.  Issue corrective actions are implemented and verified.对于问题的纠正措施得到实施与验证。\n4.  Is the factory punished by the governmentdue due to the safety protection this year?本年度工厂是否因安全事件受到政府处罚？"]
["A.1.3","Is there an established audit process for conformance to Health and Safety procedures?  是否已建立了对健康与安全管理符合性进行审核的程序？","1.  There are regular scheduled internal and/or external audits to procedures and operating instructions.按照程序和操作指导书定期开展内部和/或外部的审核。\n2.  There is a regular scheduled management review of progress to goals.针对目标的达成状况定期开展管理评审。\n3.  There is a regular scheduled (minimum annual) review (and update) of the policy and plan.对于方针和计划开展定期（至少每年）评审（和更新）。"]
["A.1.4*","Have the supplier passed the additional safety and environmental YFAI China audit and he has the final acceptance consistent with Government requirements ?\n(Asia & Pacific region specific requirement only) 供应商是否获得相关部门针对安全与环境方面的审核，并取得政府部门的最终批准认可？\n(仅亚太地区有此特殊要求)","1.  The supplier has  a final acceptance of the fire, fire emergency plan is in place and all the requirements related to fire are fulfilled供应商获得最终消防验收；有消防应急计划；所有和消防相关的要求得到满足\n2. The management of hazardous chemical  is done according with Government regulations按照政府法规对危化品进行管理\n3. Industrial waste water / waste gas / noise are in line with national standards工业废水/废气/噪音排放符合国家标准\n4. Emergency / contingency plans are in place制定了紧急/意外事故应急计划"]
[null,null,null,"Actual    ",{"$f":"SUM(E11:E13)","v":0},{"$f":"SUM(F11:F13)","v":0},{"$f":"Instructions!C27","v":1}]
[null,null,null,"Possible    ",12,12,1]
[null,null,null,"Percent    ",{"$f":"E15/E16","v":0},{"$f":"F15/F16","v":0},{"$f":"Instructions!C31","v":3}]
["A.2  Customer Interface System",null,null,null,null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["A.2.1","Does the supplier visit customer facilities or interact with the customer on an established schedule?   供应商是否定期拜访客户或与客户开展定期交流？","1.  The supplier has a customer visitation plan (Supplier visits should be proactive and address quality, delivery, launch and engineering, as well as understanding how their parts are used) for customer visits and communication (phone calls, faxes, email, etc.).  供应商应有针对客户拜访和交流（通过电话、传真、电子邮件等）的实施计划（供应商拜访客户应是积极主动的，并重点针对质量、交付、投产、工程等与客户进行交流，并让客户理解产品的使用方法）。\n2.  The supplier documents (journals, open issues lists, action plans, etc.) and reports results of all visits to management. There is a contact list updated and distributed to the customers  供应商拜访客户后，应将针对管理问题的交流情况形成文件（备忘录、开口问题清单、行动计划等）并报告结果。建立一份最新的联系清单并分发到客户。\n3.  Evidence exists that the data collected by field engineers or representatives is used in the problem solving process, and is the basis for supplier continuous improvement activities.  有证据表明，专业工程师或销售代表将收集来自客户端的数据用于问题解决，并作为供应商持续改进活动的依据。",null,null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["A.2.2","Does the supplier participates in customer satisfaction surveys ?  供应商是否开展顾客满意调查？","1.  The supplier participates in customer satisfaction surveys and is proactively working on improving the business relationship  供应商开展客户满意调查，并积极改进业务关系。\n2.  The supplier has access to Covisint (supplier scorecard, including award criteria) and is aware of the YFAI Supplier Portal  供应商是否能登陆Covisint（供应商记分卡，包括评奖规则），并知道YFAI关于供应商的门户网站。"]
["A.2.3","Does the supplier have a system to support warranty issues?  供应商是否具有支撑质保问题的系统？","1. The supplier has an active internal process to resolve warranty issues - all parts are evaluated to drawing requirements on a regular basis to ensure ongoing compliance, the timeframe not to exceed one year where not included in the control plan.  供应商已建立了针对积极解决质保问题的内部流程--所有基于法律规定的要求得到评估与识别，以确保持续满足要求；在控制计划中没有作出规定的，时间范围不要超过一年。\n2. The supplier has a designated warranty champion who is accountable to customer warranty returns.  供应商要指定一位负责人负责客户质保反馈工作。",null,null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["A.2.4  ","Does the supplier has access and fill the required data into YFAI systems? 供应商是否有途径将数据与YFAI系统进行对接？","1. The supplier has completed the financial information into 3PI system (or provided equivalent information directly to Purchasing)供应商已经完成3PI系统中的财务信息（或者直接向采购提供等价的信息）。",null,null,null,{"$f":"Instructions!C48","v":0}]
[]
[null,null,"2. The supplier has completed the Sustainability page located on the YFAI Supplier portal在YFAI供应商门户网页中供应商已经完成了相应的内容。"]
[null,null,"3. Supplier has uploaded the recent/valid Quality certificates via Taulia system供应商通过Taulia系统登录了最近的/有效的质量认证。"]
[]
[null,null,"http://www.yfai.com"]
[null,null,null,"A.2  Customer Interface System Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E19:E27)","v":0},{"$f":"SUM(F19:F27)","v":0}]
[null,null,null,"Possible    ",12,12]
[null,null,null,"Percent    ",{"$f":"E29/E30","v":0},{"$f":"F29/F30","v":0}]
["A.3  Capacity"]
["A.3.1*","Are the necessary personnel resources planned and available for any current or new business? 是否针对现有的或新的业务对人力资源进行了必要的规划?","1.  A staff matrix should be reviewed with actual names for key functions. Where additional resources are needed for new or transferred projects a recruitment plan should be available and should be completed and inducted before new project kick off   对于主要职能部门的人员配置矩阵应进行评审，如果新项目或者移交项目需要附加人力资源，在项目启动前，应制定完成并实施相应的人员招聘计划。\n2.Personnel performing activities affecting conformity to product and process requirements.\n员工的执行影响产品和流程要求的一致性。\n3.  Change management within the projects meets the customer's specific requirements.  变更管理满足客户的特殊要求\n4.  The operators are able to carry out their tasks and their qualifications are kept up to date   操作人员有能力完成他们的任务，他们的资质认证是有效的。\n5. IMPORTANT: All the key personnel is able to communicate with the customer via an international agreed language on a consistent basis   重要关注点：所有主要的人员均可以通过国际通用的语言与客户进行有效交流。"]
["A.3.2*","Are the production resources planned to be in line with current and future customer demands? 是否针对当前的和未来顾客的需要对生产环节进行资源策划？","1. There is a planning system which continually evaluates available machine capacity taking also in the consideration customer peak demands  考虑到客户产量爬坡的需求，应建立一个策划系统可以持续的评价设备的产能。\n2. There is a clear planning for equipments, packaging, technical installations (Air, Power, etc), surface, etc    应针对设备、包装、技术安装（用气、能源等）、外观等开展明确的策划。\n3. In case of new awarded business a Plant Readiness presentation must be prepared and presented covering all capacity aspects including customer specific requirements.\n为获取新的业务， 必须向客户展示工厂的能力，并且覆盖各方面的能力包括客户特殊需求\n4. Measurement and testing facilities are suitable for planned work (CMM, various testing machinery, etc)  测量和实验设备的配置满足所策划的工作要求（CMM，各种实验设备等等）\n5. Supplier weekly production plan is not overcommitted and overtime is not the normal way of producing required quantities   供应商每周的生产计划没有过量生产，没有将加班生产作为常态来完成客户需求产量。"]
["A.3.3","Are there any contingency/emergency plans in place as well a notification process towards customer and other interested parties ?\n对偶发事件是否有应急预案以及向客户和其他相关方的通知程序？","1. Supplier has a current emergency plan with documented training and conduct contingency plan reviews using a multi-disciplinary team (including top management)   供应商具有文件化的运行的紧急处理计划并使用多方论证团队（包括高层管理人员）进行应急计划审查。\n2. Contingency plans been established to support production in case of force majeure, equipment breakdown, sub supplier line stop, etc    考虑到不可抗力、设备故障、分供方停线等偶发事件的可能出现，应建立应急计划以支持生产 。"]
[null,null,null,"A.3  Capacity Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E33:E35)","v":0},{"$f":"SUM(F33:F35)","v":0}]
[null,null,null,"Possible    ",9,9]
[null,null,null,"Percent    ",{"$f":"E37/E38","v":0},{"$f":"F37/F38","v":0}]
["A.4  Product and Process Targets"]
["A.4.1","Does the supplier have systems in place that support internal and customer defined KPI's? 是否建立了针对内部和顾客关注的KPI系统？","1.  The supplier displays and/or reports easily understood objectives and priorities, visible to all managers and employees, and ensure that all employees are empowered to effectively support the objectives of the Operational Plan. 员工应容易理解目标和主要关注点，对于管理者和员工要做到可视化，以确保所有员工对运作目标实现的有效支持。\n2. There are regular management metric reviews that link to goals   结合目标定期地开展对管理指标的评审。\n3. The supplier has a process to communicate KPI's to customers and sub suppliers if applicable  合适的话，供应商应与客户和分供方就KPIs的制定与达成开展沟通交流。"]
["A.4.2","There is an escalation process established and controlled effectively ? 是否具有事态升级的流程并实施有效控制？","1. The criteria for escalation are specified and responsibilities and authorities are regulated  事态升级的准则应是具体的，并且职责和权限应得到明确。\n2. The effectiveness of escalation is demonstrated by appropriate documentation  事态升级的有效性应通过适当的文件来证实。\n3. If special risks have been identified for technologies, suppliers and supply countries, this must also be taken into account in escalation management  如果在技术层面、供应商和供应国家方面识别出存在特定的风险，也必须纳入事态升级管理予以考虑。"]
[null,null,null,"A.4  Product and Process Targets Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E41:E42)","v":0},{"$f":"SUM(F41:F42)","v":0}]
[null,null,null,"Possible    ",6,6]
[null,null,null,"Percent    ",{"$f":"E44/E45","v":0},{"$f":"F44/F45","v":0}]
["A.5  Quality System Certifications"]
["A.5.1*","Does the supplier carry out quality system audits for the products and processes as planned and address the issues? 供应商是否按照策划的频次针对产品和过程实施质量体系审核，并对审核的结果采取措施？","1. There are multiple types of audits performed: internal, 3rd party, customer, etc  which were conducted and appropriate actions plans exists and up to date   执行多种形式的审核：内部审核、第三方审核、客户审核等，并针对审核结果制定适当的行动计划，对计划执行情况适时跟踪。\n2.  A champion is identified and accountable to performance and the internal auditors have documented qualifications 指定负责人对审核执行情况负责并且内部审计员具有资质的证明。\n3. Internal Manufacturing process audits are planned and conducted to assess process effectiveness for each manufacturing processes according with customer requirements (ex VDA, Formel Q, etc).   按照客户要求对每个内部制造过程进行策划和实施审核来评价过程的有效性（例如VDA、Formel Q等）\nNote: Special processes (ex Heat treatment, painting, plating, etc) requires special assessments.   注：特殊过程（例如热处理、喷涂、电镀等）需要进行专项评审。\n4.  Internal and external action plan performance status is tracked, verified, and reported.  对内部和外部的审核结果采取的行动计划执行状态进行跟踪、验证和报告。\n5.  Evidence of continuous improvement or changes exist through employee suggestions, process improvements or organizational restructuring.  通过员工合理化建议、过程改进或组织机构变更的途径推进持续改进或调整的证据。"]
["A.5.2","Does the Supplier have 3rd party certification for Quality Systems 供应商是否获得第三方的质量体系认证？","1.  Must be compliant to IATF 16949 and ISO 14001  \n必须通过IATF 16949和ISO14001的贯标要求。\n2. The supplier is able to upload current certificates via Taulia system  供应商是否进行过最新的Taulia（Taulia是一家提供B2B交易发票及支付管理SaaS服务的公司）体系认证。    \n3. There is a short term plan to fulfill any missing certifications due to objective reasons (ex: new facility operating less than one year, etc)   由于客观原因（如运行不到一年的新工厂等），工厂无法获得认证的，应制定短期的计划，以满足体系要求。"]
[null,null,null,"A.5  Quality System Certifications Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E48:E49)","v":0},{"$f":"SUM(F48:F49)","v":0}]
[null,null,null,"Possible    ",6,6]
[null,null,null,"Percent    ",{"$f":"E51/E52","v":0},{"$f":"F51/F52","v":0}]
["A.6  Human Resources"]
["A.6.1","Does the supplier have a staff resource plan ? 供应商是否具有人力资源规划？","1.  Overtime is not used as a long-term solution for staffing requirements.  加班不应成为解决人员需求的长期措施。\n2.  A process exists for establishing resource requirements (facilities, technical staffing, operational staffing, etc.) due to increasing (new programs, mergers, acquisitions, etc.) or decreasing organizational sales or market share.  建立根据公司销售额或市场份额的增长（新项目、业务合并、收购等）和降低而调整的资源需求（工厂设施、技术人员配备、操作人员配备等）方面的流程。\n3.  There is a procedure for acquiring additional resources (new facilities, staff, etc.) when needed and there is upper management support when resource needs are justified.  为获取必要的额外资源（新工厂设施、人员等），应建立资源配置流程，并且对于合理的资源需求应得到高层管理者支持。\n4.  Employee retention and succession plans exist for all key personnel.  对于所有关键岗位的员工应建立如何留住和后续接替的方案。\n5.  Benefit and compensation analysis/studies are completed and used to support recruiting and retention activities.   完成效益与补偿分析，并用来支持人员的招聘与留住员工的相关措施。\n6.  Employee evaluations are based on performance to expectations and the supplier way of doing business (training plan and opportunities, job measures, evaluation system, etc.).  根据期望的绩效和供应商自身业务开展的方式(培训计划、机会、工作衡量以及评价系统等等）来评价员工。\n7.  Supplier organization fosters employee satisfaction and commitment to organizational goals by building and supporting open communication, trust, teamwork, leadership, mentoring, and personal improvement.    通过建立和支持开放交流、信任度、团队合作、领导层支持、监督、个人提升等方式培养员工的满意度和对实现组织目标的责任心。"]
["A.6.2","Does the supplier have an effective training and development system?   供应商是否建有有效的培训和开发系统？","1.  Each employee understands the expectations of the position and the impact on customer specific requirements (job description, training matrix and plans, skills, knowledge, competencies, attitude, company values).   每位员工理解其岗位要求和客户特殊要求的影响（工作描述、培训内容与计划、技能、知识、能力、态度、公司价值）\n2.  A training plan and budget exists for each employee, one of the priorities should be customer requirements.  Training plan focus is first on capability gaps identified from the training matrix.  Second focus is employee development above and beyond those skills required for their current responsibilities.  对于每一个员工培训计划和预算优先考虑客户的要求，培训计划首先要考虑相对于培训矩阵中的能力差距，其次再考虑高于或者超出他们当前的责任技能要求。\n3.  The supplier has an active Leadership and Mentoring training program/policy/practice.供应商是否针对培训工作建立了程序、政策和监督执行，并获得领导层的积极支持。\n4.  Effectiveness of the training is measured through a employee skill gap analysis audit prior to, and after the training. 通过对员工培训前后能力管理差距分析审核来评估培训的有效性。\n5.   Successful completion of the training is identified (date) on the employees training matrix. 5. 在员工培训矩阵中能识别出有效完成培训的情况。"]
[null,null,null,"A.6  Human Resources Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E55:E56)","v":0},{"$f":"SUM(F55:F56)","v":0}]
[null,null,null,"Possible    ",6,6]
[null,null,null,"Percent    ",{"$f":"E58/E59","v":0},{"$f":"F58/F59","v":0}]
[]
[null,null,null,"A.  Leadership / Management Total"]
[null,null,null,"Actual    ",{"$f":"E15+E29+E37+E44+E51+E58","v":0},{"$f":"F15+F29+F37+F44+F51+F58","v":0}]
[null,null,null,"Possible    ",{"$f":"E16+E30+E38+E45+E52+E59","v":51},{"$f":"F16+F30+F38+F45+F52+F59","v":51}]
[null,null,null,"Percent    ",{"$f":"E63/E64","v":0},{"$f":"F63/F64","v":0}]
[]
[]
[]
[" "]

{"sheet":"B. Program Execution-Launch","index":6,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,4,0,5],[1,4,1,5],[2,2,3,2],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,3,5,5],[6,3,6,5]]}
[]
[null,null,null,"Supplier Name",{"$f":"Summary!B5","v":0}]
[null,null,"Supplier Assessment Survey","Supplier Location",{"$f":"Summary!B8","v":0}]
[null,null,null,"Self Assessment Date",{"$f":"Summary!H5","v":"00:00:00"}]
[null,null,null,"On-Site Survey Date",{"$f":"Summary!H6","v":"00:00:00"}]
[null,null,null,"YFAI Supplier Standards Manual"]
[null,null,null,"http://www.yfai.com"]
["B. Program Execution / Launch",null,"Criteria","Comments","YFAI Result","Supplier Result"]
[]
["B.1  Program Management "]
["B.1.1*","Is the project organization (program management) established and are the task and authorities specified for all team members assuring tracking of APQP, Process sign-off or equivalent requirements and meeting customer timing requirements?  Is the communication language written or verbal  agreed with the customer?\n是否成立项目小组来管理项目？为保证APQP的有效推进、投产认可（或等效过程）、满足客户进度要求，小组成员的任务和职责权限是否规定？客户是否书面或口头同意沟通的语言？","1. The project management is in a position to meet customer requirements. \nThe project plan has been agreed with the customer  项目管理处于满足客户要求的状态；项目计划与客户达成一致。\n2. Necessary resources are planned and available for the development of the project, each program has a responsible program manager with a cross functional team identified by names (if programs are low volumes, resources can be shared) with regular management review of status  必要的资源要得到策划，并有效支持项目的开发，每一个项目都有一个项目经理，通过指定的人力资源组建跨部门团队（如果项目量纲较少，资源可以共享），定期对项目状态进行管理评审。\n3. The technical personnel with relevant qualifications are provided at the right time by the special departments  由特定的部门在适当的时间指派有相应资历的技术人员。\n4. Resource planning also takes account the sub-suppliers  资源的策划也要考虑到二级供应商。\n5. An escalation process has been established and is controlled effectively, including notifications to the customer  应建立事态升级流程，并且可有效控制，包括对客户的通知。"]
["B.1.2","Can the supplier coordinate engineering design changes in regard to tools, part submission, inventory management, sample runs, etc., using appropriate electronic tools?供应商是否能采用电子工具来对模具、零件提交、清单管理、样件状态等方面的工程更改进行协调？","1.  Supplier has a process for coordinating and documenting customer (YFAI) approval prior to the implementation of any Engineering or Design change.  应建立一个过程，针对工程或设计变更，在实施之前与客户进行协调，并得到客户批准的证据。\n2.  Supplier can show evidence for the ability to coordinate the following with the customer, when initiated by an Engineering Change (whether a running change or with obsolescence):  tooling modifications, process changes, bank build, sample run, and timely part submission.  一旦有工程变更（不管是连续不断地更改，还是否决），供应商有能力就以下事项与客户进行协调：工装模具更改、工艺变更、财务支持、样件制作、零件提交时间。\n3.  The latest authorized drawing and/or any other engineering specifications are on-site at the supplier.  在供应商处有最新认可的图纸和/或其它工程规范。\n4.  The proper engineering change level is being shipped and reflected on the label for any particular part(s).  对于特定的发运零件，在包装和标签上应反映出正确地工程更改状态。\n5.  The control plan does not conflict with the drawing / engineering documents for any particular part(s).  所有特定零件的控制计划内容不应与图纸/工程规范相冲突。\n6.  A formal customer deviation is in place wherever there is a discrepancy between the part being shipped and the drawing and/or other applicable specifications. 无论在被发运的零件与图纸或另外相关的技术规范之间的差异，应获得客户的偏差许可。",null,null,null,{"$f":"Instructions!C27","v":1}]
[null,null,null,"B.1  Program Management Total",null,null,1]
[null,null,null,"Actual    ",{"$f":"SUM(E11:E12)","v":0},{"$f":"SUM(F11:F12)","v":0},{"$f":"Instructions!C31","v":3}]
[null,null,null,"Possible    ",6,6,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Percent    ",{"$f":"E14/E15","v":0},{"$f":"F14/F15","v":0},{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["B.2  Understanding Customer Requirements",null,null,null,null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["B.2.1*","Does the supplier understand applicable customer requirements (including OEM's) and cascade the information to their sub-suppliers ?  供应商是否充分理解客户的要求（包括OEM的要求）并将信息传递至其子供应商？","1.   The supplier is aware of and have access to typical automotive or governmental standards, specifications or guidelines.供应商可获得主流汽车厂和行业的标准、规范和指导文件，并对此比较熟悉。\n2.  The supplier understands the correlation/importance of the standards or specifications to the requirements (environmental, safety, service, warranty, life expectancy, packaging, legal, GD &T, etc.) of the customer and/or consumers end product and utilize them correctly    供应商必须熟悉这些标准和规范与客户要求（环境影响、安全，服务，索赔，设计生命周期，包装，法律，几何尺寸与配合等等）以及终端用户的关联性和重要性，并能合理利用。\n3. The manufacturing feasibility has been assessed based on the basis of the requirements established for the product and process on a cross functional level.   通过跨部门的形式对产品和过程要求进行制造可行性评估。\n4. A launch containment plan is in place accomplished through the deployment of additional (above the intended production process) controls to identify known or potential non-conformities (inspection audits, dimensional measurements with higher frequency, SPC, appearance checks, etc). Supplier can show evidences of understanding and utilizing this concepts (documented procedures, evidence of removal of early temporary controls, training, etc)     建立投产遏制计划，以明确通过实施额外的（高于既定的生产过程控制要求）控制方法来识别已知的或潜在的不合格（检测审核、高频次的尺寸检测、SPC、外观检查等等）；供应商有证据显示理解并实施这些要求（文件化的程序、早期临时控制撤销证据、培训等等）。\n5. Data generated from containment is analyzed and utilized to quickly initiate and verify corrective actions to eliminate the problem.   来自遏制过程的数据得到分析，并且及时用于实施和验证纠正措施，以消除质量问题。"]
["B.2.2*","Does the supplier have materials and product testing capabilities to assure ongoing conformance to material, legal, and performance specifications?  供应商是否具备材料和产品的测试能力，以确保在材料、法规要求和性能要求的持续符合性？","1.   The supplier has an established test budget.  供应商建立了测试预算。\n2.  The supplier has dedicated and adequate equipment and facilities for all test activity.   供应商已经配置了适当的专用测试设备和设施来满足所有测试工作的需要。\n3.  The supplier has a dedicated organization and staff to support testing activities.供应商指定了专门的组织和员工来负责测试工作。\n4.  The supplier has an established procedure for all testing activities, including outsourced testing.  All outsourced testing to be complete by qualified labs.供应商对于所有的测试工作已经建立了程序，包括外包测试项目，所有的外包测试项目应由有资格的实验室完成。\n5.  The supplier has evidence of test documentation including setups, methods, data, and final verification or validation results to requirements.   供应商具有测试文件的证据，包括设置、方法、数据和最终根据要求进行验证和确认的结果。\n6.  The supplier has a process to track, perform, and document ongoing conforming product testing.供应商有程序去追踪、执行，并将正在进行的符合产品的实验结果形成文件。"]
["B.2.3","Is there a proof of conformity to applicable statutory and regulatory requirements in the country of receipt and country of shipment, and if required by the cusotmer annual recertification testing and compliance to regulations, standards, PPAP submissions, etc ?  如果客户有要求，是否能提供证明符合收货国家/地区的适用法定和法规要求 供应商是否能提供关于法规、标准、PPAP提交等符合要求的年度认证证据？","1.   The supplier has a system in place to track validation requirements   供应商有一个系统对认可要求进行跟踪。\n2. The supplier has evidence that they meet all applicable statutory and regulatory requirements in both the country of receipt and country of shipment.\n供应商有证据表明它们符合收货国家和装运国家的所有适用的法定和法规要求。\n"]
["B.2.4*","Does the supplier identify appropriate error proofing applications for product safety / significant characteristics of the products?      供应商是否针对产品安全性/产品关键特性的控制实施了防错方案？","1. Error-proofing (also known as poka-yoke) and mistake-proofing are ways to prevent particular defects from being made and/or to detect defects so as to prevent them from being packed and shipped.  These are typically designed into the process via the PFMEA development.  The supplier can show evidence that these concepts are understood and utilized.  防错系统（也称为POKA-YOKE）是一种方法来避免某种特定的缺陷产生或者发现错误来避免这些缺陷产品被包装发送，这些典型的方法通过PFMEA的开发设计在生产过程当中，供应商应该展示对这些概念已经理解和运用。\n2. Strict final inspection processes are used in order to keep customer complaints low.  Temporary countermeasures to problems are immediately put into place and de-escalation criteria exists.   应通过严格的终检来降低客户的抱怨；对于质量问题的临时解决措施要迅速实施，以降低事态的影响程度。\n3. Employees are empowered to stop the process when a defect or abnormal condition occurs.  当缺陷或者有问题的情况发生时员工有权停止生产。\n 4. Defects are detected before being passed to the next process by operators who perform independent inspection and improvements.  通过自检和改进的方式，在缺陷传到下一个工序前能被操作员工发现。\n 5. Employees have been trained in the process of error proofing and are using \"rabbits\" before the first off part of each shift to prove the efficiency of the poke-yoke.   针对防差错过程当中的要求对员工进行培训，并且在每班首件通过人为的制造错误对防错系统的有效性进行验证。     \n 6. Jidoka (self-inspecting automated machines) and error proofing devices have been developed to build in quality at each step and to prevent defects at their source to prevent occurrence or recurrence.     JIDOKA（自动化自检装置）和防错装置已被开发用来提升每一步的质量，并且在问题的源头预防缺陷的反复发生。"]
[null,null,null,"B.2  Understanding Customer Requirements Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E18:E21)","v":0},{"$f":"SUM(F18:F21)","v":0}]
[null,null,null,"Possible    ",12,12]
[" ",null,null,"Percent    ",{"$f":"E23/E24","v":0},{"$f":"F23/F24","v":0}]
["B.3  PPAP Execution"]
["B.3.1*","Is a Production Part Approval Process in use and capable of meeting customers expectations ? Is a YFAI recognized format, or equivalent, for part submission process utilized throughout the organization?   PPAP过程是否符合客户期望，且在供应商整个机构内是否应用了YFAI认可的零部件提交形式？","1.  There is an established champion who is accountable for PPAP process (customer and sub suppliers) and performance and sufficient resources to manage this activity  指定一个专门人员负责PPAP的过程（包括客户和分供方）和完成情况，并提供充分的资源来管理这项工作。\n     *  Understands customers expectations  理解客户的期望\n     *  Reports process performance to Management   报告过程管理绩效\n     *  Develops continuous improvement plans, Open Issue List exists and is up to date制定持续改进计划，建立开口问题清单并更新\n     *  Include Design Reviews, Management Reviews, Program Reviews, etc with the Customer and internally 和客户以及内部开展设计评审、管理评审、项目评审等\n2.  Employees are trained, knowledgeable, and accountable to the PPAP process and its relationship to the customers expectations.  负责PPAP过程的人员应接受过培训，对此非常熟悉，而且清楚客户关于此过程的要求。\n3. Based on requirements, necessary evidences and releases for various phases should be available   根据要求，应建立必要的证据，并在不同阶段得到有效发布。\n4.  PPAP documents are consistent with and appropriate to the AIAG, automotive, and/or customer formats   PPAP文件应该和AIAG、汽车行业或者客户要求的格式保持一致。\n5. A feasibility study is executed, documented and submitted to the Customer   实施可行性研究，形成文件，并提交给客户。\n6. The process considers milestones for facilities, tools, build events and materials  过程里程碑要考虑设备、模具、建设事项、材料。\n7. Supplier has a communication process in place with sub suppliers and Customer which covers Product design and Engineering data, including changes  供应商应该就产品设计、工程数据、工程更改等和客户以及二级供应商保持交流。"]
["B.3.2","Does the supplier have a system to manage Process Sign Off (PSO) / Run at Rate or other Customer Production Verification Process?   供应商是否实施投产认可/节拍生产或客户其它的生产验证流程？","1.  A pre-production run should be carried out under serial production conditions in order to obtain production approval/release   未获得生产认可批准，应在批量生产条件下进行试生产运行。\n2. Supplier's process is consistent with and capable of understanding and meeting their customers expectations for Process Sign Off (PSO) / Run at Rate or other Customer Production Verification Process.供应商理解客户的期望，其工艺过程包括过程签署、节拍生产，或另外的客户生产验证流程满足客户的期望，与其保持一致。\n3. Supplier uses the appropriate AIAG and/or OEM customer formats 供应商文件提交使用合适的AIAG或者主机厂客户的格式。\n4. Internal process sign-offs are conducted prior to the customer monitored event  内部的过程签署应该在客户最终签署之前完成。"]
["B.3.3","Can the supplier demonstrate knowledge of the Process Flow Diagram? 供应商是否理解并实施过程流程图？","1.  Supplier uses a Process Flow Diagrams that matches the actual production flow laid out for this facility and the document should be updated as project progresses. 供应商的过程流程图应与工厂布局的实际生产流程状态相匹配，并且且根据项目进展对文件进行更新。\n2. Process Flow Chart should include incoming and outgoing goods, inspection, transportation, storage, sub contracted services and alternate paths - rework, repair and back up - and all operations affecting special characteristics should be identified。 过程流程表应该包含进料和出货、检验、运输、储存、外协加工以及附属加工途径-返工、返修、暂存待加工--所有具有操作影响的特殊特性应该得到识别。\n3. PFD should be the starting point and should match PFMEA and Control Plans   过程流程图应作为起始文件并与PFMEA以及控制计划保持一致。"]
["B.3.4","Can the supplier demonstrate knowledge of the FMEA?   供应商是否理解并实施FMEA？","1.  Process FMEA was created through the use of multi-disciplinary team and updated as the project progresses  应通过多功能小组制定PFMEA，并且随着项目的进展得到更新\n2.  PFMEA(s) was created with the use of prevention methods rather than detection methods, high risk priority numbers should be assessed with corrective actions, responsibilities and completion dates and revised accordingly    PFMEA的制定应体现出预防的方式，而不是检测的方式；对于高风险顺序数的项目应制定纠正措施、明确职责和完成时间节点，并按时修订PFMEA版本。\n3.  PFMEA (s) include critical and/or significant characteristics, as well as Customer/supplier identified Key characteristics   PFMEA应该包含重要特性以及客户或者供应商识别的关键特性\n4. Risk numbers for severity, occurrence and detection are based on historical/statistical data and updated as project progresses and corrective actions are laid down根据历史数据或者统计数据来发现严重度、频度和可探测度的风险数，并且随着项目进行适时更新，并制定纠正措施。\n5. Mistake proofing opportunities are initiated to reduce high RPN numbers  对防错方案的考虑可以降低RPN值。"]
["B.3.5","Can the supplier demonstrate knowledge of the Control Plan?  供应商是否理解并实施控制计划？","1.  The Control Plan matches the Process Flow Diagram and PFMEA, derive from them and include annual requalification  控制计划必须基于过程流程表和PFMEA制定，并与其保持一致，内容包含每年的型式试验认证。\n2.  The Control Plans identifies all the gauges and test equipment required for inspection in all production phases, including test frequency. Should be evidences that the gages and test equipment from the CP are accurate, repeatable and reproducible (Gage R&R)   控制计划识别了所有生产阶段的检具和测试设备，包括测试频次，必须有证据表明控制计划中的检具和测试设备的精度是准确的，具有可重复性和再现性（检具 R&R）。\n3. Statistical control methods are documented in the CP控制计划中统计控制方法形成文件。\n4. CP, as well as PFMEA, are updated to address any issues and lessons learned during the production   在整个生产阶段，控制计划和PFMEA的内容、问题和经验得到适时更新。"]
[null,null,null,"B.3  PPAP Execution Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E27:E31)","v":0},{"$f":"SUM(F27:F31)","v":0}]
[null,null,null,"Possible    ",15,15]
[null,null,null,"Percent    ",{"$f":"E33/E34","v":0},{"$f":"F33/F34","v":0}]
[]
[null,null,null,"B. Program Execution / Launch Total"]
[null,null,null,"Actual    ",{"$f":"E14+E23+E33","v":0},{"$f":"F14+F23+F33","v":0}]
[null,null,null,"Possible    ",{"$f":"E15+E24+E34","v":33},{"$f":"F15+F24+F34","v":33}]
[null,null,null,"Percent    ",{"$f":"E38/E39","v":0},{"$f":"F38/F39","v":0}]

{"sheet":"C. Operations - Quality","index":7,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,4,0,5],[1,4,1,5],[2,2,3,2],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,3,5,5],[6,3,6,5]]}
[]
[null,null,null,"Supplier Name",{"$f":"Summary!B5","v":0}]
[null,null,"Supplier Assessment Survey","Supplier Location",{"$f":"Summary!B8","v":0}]
[null,null,null,"Self Assessment Date",{"$f":"Summary!H5","v":"00:00:00"}]
[null,null,null,"On-Site Survey Date",{"$f":"Summary!H6","v":"00:00:00"}]
[null,null,null,"YFAI Supplier Standards Manual"]
[null,null,null,"http://www.yfai.com"]
["C.  Operations / Quality",null,"Criteria","Comments","YFAI Result","Supplier Result"]
[]
["C.1  Process Analysis / Production"]
["C.1.1*","Is the incoming materials process managed properly in order to ensure that the product is manufactured per customer requirements and traceable?   为确保生产的产品满足客户的要求和可追溯性，是否对进料进行了适当的控制？","1. Incoming materials are stored appropriately and transport / packaging arrangements are suitable for the quality of the products including special characteristics  进料得到了适当的储存和转运/包装方式符合产品的质量要求，包括产品特殊特性。\n2. The necessary identifications / records / approvals are available and allocated appropriately to incoming materials and demostrating tracebility to final product. 对于进料进行必要的标识、记录和状态批准，并进行合理地调配，以及对于最终产品可追溯的证明。\n3. Approved inspection plans are implemented for all purchased / directed production material  对所有采购件/直接投入生产的物料按照认可的检验计划实施检验。\n4. All relevant documents regarding quality of supplied production material are available and controlled  对所有与提供的生产用物料相关的质量检验文件应是有效并受控的。"]
["C.1.2*","Are the workstations and test/inspection areas suitable for requirements and ergonomical ? 操作工位和测试检验区域是否符合要求和有利于提高工效？","1. Production operations are checked, approved and the settings / parameters logged and controlled 生产操作要求得到检查和批准；工艺参数得到控制并记录。\n2. Work instructions documents for all employees affecting product quality, including for repair and rework operations (approved by the customer) are available and posted in the language understood by the person responsible to follow them. They include job start up, change over and mistake proofing validation. Also they include a procedure for rejected parts (marking, isolation, production restart, etc)  应保证影响产品质量的人员（包括从事经客户批准的返工返修）所必须的作业指导文件是容易获取的，并使用负责跟踪他们的人所理解的语言展示，这些文件包括如何启动、转换、防错验证，也包括零件拒收的流程（标识、隔离、生产重启等）。\n3. All relevant details listed in the production and test/inspection documents are be based on the current Control Plan, including product safety, significant characteristics 应根据当前控制计划内容将所有相关信息列在生产和测试/检验文件中，包括产品安全性关键特性。\n4. The operators are able to carry out their allotted tasks and their qualifications kept up to date including awareness of customer specific requirements 操作人员有能力完成分配给他们的任务，并且它们的资质是有效的包括对客户特殊要求的认识。\n5. Target requirements for the product and process are set and communicated. Quality and process data are logged in such of way that they can be assessed  设定了产品和工艺过程的目标，并得到了沟通交流。质量和过程数据记录应可以用来对目标进行评价。\n6. Tools, equipment and test / inspection facilities are stored correctly 工装、设备以及测试检验设施得到了正确地保存。\n7. Quality alerts are used at affected process steps to ensure operator awareness of quality issues 在影响较大的过程环节通过质量报警功能来提醒操作人员对质量问题的控制。\n8. Supplier has a process / system to track and manage scheduled and unscheduled downtime  应建立对计划内和计划外的停机时间进行跟踪与管理的流程/机制。"]
["C.1.3*","Can the quality requirements be monitored effectively with the test, inspection and measurements facilities employed (including outside sourcing)?是否采用了适当的测试检验工具对产品质量要求进行了有效地监控（包括外包测试项目）？","1. Supplier has a system in place to identify, qualify and control Measuring and Test equipment 供应商具有一个体系来识别、检定以及管理测量和实验设备。\n2. Operators are trained and qualified for any required measurements and tests, including the use of statistical techniques if needed  应对从事任何必要的测量和试验人员进行培训和资格认证，如果需要的话，还应包括使用统计技术的人员。\n3. All inspection gages and fixtures are stored in a manner that protects them from environmental / handling / storage damage  所有的量检具应得到妥善保存以避免他们受到环境影响、搬运过程、储存环节带来的损坏。\n4. If some measurements / testing, etc is outsourced, the laboratory needs to comply with accreditations required by the Customer 如果有些测量、实验等是外包的，外包实验室必须按照客户要求是经过认证的。",null,null,null,1]
["C.1.4*","Are product safety / significant characteristics controlled in production ?在生产过程中是否对产品安全性/关键特性进行了控制？","1. Significant product characteristics and process parameters are identified in the production Control Plans and monitored systematically per Customer requirements, capability is tracked  关键产品特性和过程特性在生产控制计划中得到识别，并根据客户要求有计划地进行监控，过程能力得到有效跟踪。\n2. Mistake proofing and error proofing are used to control significant characteristics and ensure product integrity通过防错和防呆措施来控制产品关键特性以确保产品的完整性\n3. Records are maintained of non compliances and corrective actions are Customer approved  相关的不符合记录得到了保存，并且纠正措施得到了客户的批准\n4. Supplier has a record retention process that ensures all necessary test, inspection and safety critical records are retained for a defined required period  建立记录保存的流程，规定所有必要的测试、检验和涉及安全的关键记录的保存要求和保存期限。",null,null,null,1]
["C.1.5*","Does the supplier has a process in place for segregation and containment of rejected parts ? 是否有流程保证对于不合格品进行隔离与遏制？","1. The supplier has a system in place preventing the suspect parts to enter production. The flow of materials and parts is secured against mixing / wrong items  供应商应该具有一个系统来预防可疑产品投入生产，以防产品或者材料混装和混料。\n2. A procedure / process is in place to define the steps required to fully contain issues in three primary areas: customer facilities, distribution system and the supplier manufacturing facility / warehouse. 供应商应该有一个程序对以下三个主要区域明确步骤来对问题进行彻底地遏制：客户工厂、分发系统以及供应商制造工厂。\n3. Scrap, rework and setting parts should be kept separately and identified. 报废、返工以及调试零件应该隔开并且标识。\n4. Quarantine stores and quarantine areas must be clearly recognizable and unauthorized access must be prevented. 隔离仓库和区域应容易识别并且防止非授权的发运。\n5.  The organization shall not divert nonconforming product to service or other use without prior customer approval.\n组织不得在未经客户许可的情况下将不一致的产品转移至服务或其他用途。",null,null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
["C.1.6","In case of deviations from product or process requirements, are the causes analyzed and the corrective actions checked for effectiveness ?  是否针对产品和过程的偏差，采取有效的原因分析与纠正措施？","1. The supplier has an effective Problem Resolution process addressing both Customer and Internal issues and documents are reviewed and signed off by the Management  供应商应有针对客户和内部问题的有效解决流程，相关文件得到评审，并按照管理流程进行签署。\n2. A problem solving methodology is be defined (Kepner Tregoe, 8D, 5 Why, is-is not, etc), Quality roadmaps for systemic issues should be used. 问题解决方法应予以明确（是/非矩阵法,8D,5Why,Is-Is not 等等），对于系统化的问题应使用质量路径图的方式解决。\n3. The supplier has a process to categorize the problems (ex design issues, customer issues, process issue, supplier issue, etc)  供应商应该有一个程序来对问题进行分类（例如设计问题，客户端问题，过程问题，供应商问题等）\n4. In case the deviation is accepted by the customer, should be an official Deviation Authorization in place covering a certain period or batch  如果有的偏差客户是可以接受的，应由授权的部门对涉及某个时间段或者某批次的偏差进行认可",null,null,null,1]
["C.1.7","There is a process in place to get customer approval for any changes in the approved product or process ?  对于量产的产品和过程的变更，是否有得到客户认可的流程？","1. Advance notification and written approval prior to all supplier product or process changes or transfers is required. \n在所有供应商产品或过程更改或转移之前，需要提前通知和书面批准。\n2. PPAP's are updated and approved by the Customer (including DA if needed)  PPAP资料得到更新，并且由客户批准（如果需要的话，还应包含设计评审）",null,null,null,1]
["C.1.8","Are the master parts management in place ?是否对标准件进行管理？","1. There is a process to manage / control the master parts in place covering all types of masters (appearance, borderline, rejected, PPAP, etc)   建立覆盖所有类型标准件（外观件、极限件、退货件、PPAP样件等）的管理/控制流程。\n2. The appearance samples are at the latest engineering level and signed off by the customer 外观样件是在最近的工程状态，并有客户签字。\n3. The evaluation equipment is adequately controlled and maintained and the personnel making the appearance evaluation are qualified   评估设施得到了充分控制与维护，从事外观评估的人员得到了资格认证。",null,null,null,1]
["C.1.9","How are the maintenance and overhaul of production facilities / tools controlled ? 如何对生产设备/工装的维护与检修进行控制？","1. The supplier has a Preventive / Predictive  Maintenance system including all production equipment, tooling and support fixtures. The system is able to track specific tools  供应商应该有一个预防性/预测性维护系统包含所有产品设备、模具和支持性设施，这个体系可以追踪到特定的的模具。\n2. The maintenance is completed as scheduled and the frequency is revised due to product issues caused by tooling / equipment wear, lessons learned are considered for new projects  维护保养应按照计划实施，如果由于设备模具的磨损造成产品质量问题，应对维护的频次进行调整，在新项目中应考虑这方面的经验教训。\n3. Supplier has a process / system to recertify a tool after repair but before the production is scheduled修模后，在投入生产前供应商应该有一个流程来对模具进行重新确认。\n4. Are the tools, equipment and test devices stored in a location that is protected from environmental / handling, etc damage ?   模具、设备、测试设备是否存储在合适的位置防止环境影响、操作等带来的破坏。",null,null,null,1]
["C.1.10","Is an active Continuous Improvement process in place to optimize material, throughput labor and overhead ?  是否有致力于优化原材料利用、生产效率的提高和成本控制的持续改进的过程？","1. Scheduled audits are in place to verify the conformance of the product with the requirements   开展有计划的审核，以验证产品要求的符合性。\n2. Methods are developed to evaluate the effectiveness of existing operations and processes which consider the overall work plan, appropriate automation, ergonomics and human factors, operator and line balance, storage and inventory buffer levels 考虑到总的工作计划、自动化程度、人体工学、人力资源因素、操作者以及产线平衡、存储和缓冲库存水平，应制定针对现有的操作和过程的有效性进行评估的方法。\n3. There is a written and clearly communicated strategy for CI with the necessary resources and organization planned and implemented. Projects are structured and continuous, successes, are recognized and expanded throughout the plant  应针对持续改进制定书面的战略并予以传达交流，明确必要的资源，组织策划并实施；持续改进工作应该是有建设性的、持续的、有成效的，并将结果在整个工厂予以传达和推广。\n4. All employees have been trained in the basics of the seven wastes (Overproduction, Waiting, Transportation, Processing, Overstock, Movement and Defect), participates in the identification of wastes in their processes and their feed back is appreciated 所有员工都已经接受了关于7个浪费基本知识（过量生产、浪费、物流、过程、过量库存、移动和缺陷）的培训，在工作过程当中积极参与对浪费的识别，并且他们的建议得到了表扬。\n5.  Evidence of continuous improvement or changes exist through employee suggestions, process improvements or organizational restructuring.  \n通过员工的建议、过程改进或组织的结构调整，建立持续改进或变化的证明。",null,null,null,1]
["C.1.11","Is the supplier PPM level meeting Customer expectations both internally and externally ?  供应商的内外部PPM是否满足客户期望？","1. Supplier key measures includes Customer and Internal PPM   客户和内部的PPM包含在供应商的主要评价指标内。\n2. PPM levels are in line with the requirements and continuous improvement applies PPM水平符合要求并且是可以持续改进的。\n3. PPM measures are clearly posted and triggers corrective actions  PPM评价结果得到明确公布，并由此提出了纠正措施。",null,null,null,1]
[null,null,null,"C.1  Process Analysis / Production Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E11:E21)","v":0},{"$f":"SUM(F11:F21)","v":0}]
[null,null,null,"Possible    ",33,33]
[null,null,null,"Percent    ",{"$f":"E23/E24","v":0},{"$f":"F23/F24","v":0}]
["C.2  Facilities"]
["C.2.1","Is the supplier infrastructure appropriate to produce the required products at the required quality level ? 供应商的基础设施是否适宜，以便生产出符合要求的产品？","1. The work areas and test/inspection stations are ergonomically designed and suitable for requirements and able prevent contamination, damage, mixing, etc   操作区域和测试/检验工作区是否按照人机工程学设计并符合相关要求，防止脏污、损坏、混料等。\n2. The maintenance and overhaul of the machines/facilities controlled on a preventive basis (plant, equipment, machines, tools, etc). There is a process to analyze and optimize downtime   应对机器/设备的保养和大修进行预防性控制（厂房、设备、机器、模具等），应建立减少停工时间的分析流程。\n3. The tools, equipment and inspection devices are stored appropriately   模具、设备、检验设施应得到合理的储存。"]
["C.2.2","Is the storage of the materials appropriate ?  物料的仓储是否适宜？","1. Incoming materials and goods containers must be placed in stores in accordance with their release status so they cannot be damaged or mixed up   来料和物品容器必须存放在它们发货状态的仓库，以防损坏或者混装。\n2. Suspect and quarantined products must be stored securely to prevent access 隔离的产品或者可疑的产品必须安全存放，防止流出。\n3. FIFO and batch traceability should be ensured  先进先出和批次的可追溯性应得到保证。"]
["C.2.3","Is there evidence of the principles of 5S in the manufacturing facility?    是否在生产车间推行5S的管理？   ","1.  All employees are considerate of housekeeping; the plant is generally clear of all unnecessary waste and scrap.  所有员工都关注到了日常的整理工作，工厂对于所有不必要的浪费和废品进行了清晰的识别。\n2.  All caution signs, exits, fire extinguishers and emergency procedures are clearly visible where they are needed.  所有的警惕标志、安全出口、灭火器以及紧急处理程序都是清晰可见的，并处于必要的地方。\n3.  Lines distinguish work areas and paths; tools, in-process inventory and machines are put in logical order.  划线将工作区域和通道分隔出；模具、在制品和设备按照正常的顺序摆放。\n4.  There is \"a place for everything and everything in it's place\"; every container, floor space, tool and part rack is clearly labeled and easily accessed by the user.  每样东西都定置摆放，每个容器、车间空地、工具、料架都清晰贴上标签并且便于使用。\n5.  The plant has reached the fifth 'S' - Systematize.  A '5S' committee regularly rates each area against best 5S practices.  The employees drive the 5S process and recognition is given to the winners.  工厂做到了系统化的5S，5S委员会定期地评比每一个区域，和执行最好的5S区域进行对比，在员工内部开展5S的工作，并对执行优秀者予以表彰。"]
["C.2.4","Is there evidence that Visual Management is the method used in the manufacturing facility to control and simplify work processes?   是否有证据表明采用了可视化方法进行管理，以便控制和简化工作过程？","1.  Employees can detect bad parts and remove them.  员工能识别出不合格品，并对其进行隔离。\n2.  Check sheets showing the top defects are recorded at each station by each operator and analyzed.  Operators can stop the line if a defective unit is found; trouble lights signal when a process or line abnormality occurs.  每个工位的操作人员将主要缺陷记录在检验单上，主要缺陷得到了分析；如果一个缺陷件被发现，操作人员可以停止产线；当生产过程或生产线有异常发生，报警灯会亮起。\n3.  Job training, safety, kaizen, meeting, key measurable, problem solving boards are visible, up to date and showing continuous improvement.  岗位培训、安全、改善、会议、主要指标、问题解决看板应做到可视化、随时得到更新，并且进行持续改进优化。\n4.  Product Quality  (returns, scrap, First Time Capability (FTC), SPC) and Productivity boards are updated immediately for each line or process; operators get immediate feedback on their performance.  产品质量（退货、报废、一次合格率，SPC)和生产日报看板应针对每一条产线和过程及时更新，以便操作人员能够及时了解到他们的产品质量控制绩效。\n5.  Everyone can tell when things are normal or abnormal; they respond at once to abnormalities.  每个人都能判断出情况是否正常，并且对异常情况可以立刻做出反应。"]
["C.2.5","Does the supplier utilize a one-piece flow process where possible?  是否尽可能采用单件流过程？","1.  Workers are adequately trained to do the job they are assigned to do.  是否针对操作人员所分配的工作要求进行必要的培训。\n2.  Part travel distances have been reduced by moving equipment closer together. 设备布局更近使零件搬运距离更短。 \n3.  The machinery and stations are arranged in a \"product\" versus a \"process\" focus.  设备和工位的设置尽量让产品做到专机专用。\n4.  The plant incorporates autonomous machines (self-inspecting - shut down when a abnormality occurs, auto-loading and ejecting).  工厂采用自动化设备（自检，当问题发生时自行关闭，自动装载和弹出）。\n5.  Processes are lined up to facilitate the flow of goods.  All operators are trained and say they are able to do the work at each station in the cell or line.  Machine / man ratios at each job are increasing.  过程安排有序以方便物品流动，所有操作人员接受培训并且让他们知道可以在该生产线或生产单元的每一个工位进行工作，每项工作的机器/人工效率在持续提升。"]
[null,null,null,"C.2  Facilities Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E27:E31)","v":0},{"$f":"SUM(F27:F31)","v":0}]
[null,null,null,"Possible    ",15,15]
[null,null,null,"Percent    ",{"$f":"E33/E34","v":0},{"$f":"F33/F34","v":0}]
[]
[null,null,null,"C. Operations / Quality Total"]
[null,null,null,"Actual    ",{"$f":"E23+E33","v":0},{"$f":"F23+F33","v":0}]
[null,null,null,"Possible    ",{"$f":"E24+E34","v":48},{"$f":"F24+F34","v":48}]
[null,null,null,"Percent    ",{"$f":"E38/E39","v":0},{"$f":"F38/F39","v":0}]

{"sheet":"D. Supply Chain - Purchasing","index":8,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,4,0,5],[1,4,1,5],[2,2,3,2],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,3,5,5],[6,3,6,5]]}
[]
[null,null,null,"Supplier Name",{"$f":"Summary!B5","v":0}]
[null,null,"Supplier Assessment Survey","Supplier Location",{"$f":"Summary!B8","v":0}]
[null,null,null,"Self Assessment Date",{"$f":"Summary!H5","v":"00:00:00"}]
[null,null,null,"On-Site Survey Date",{"$f":"Summary!H6","v":"00:00:00"}]
[null,null,null,"YFAI Supplier Standards Manual"]
[null,null,null,"http://www.yfai.com"]
["D. Supply Chain / Purchasing",null,"Criteria","Comments","YFAI Result","Supplier Result"]
[]
["D.1  Supply Base Management "]
["D.1.1*","Are only approved / released and quality capable sub-suppliers selected ?是否仅仅批准/同意有质量能力的分供方供货？","1. Customer's requirements are taken into account in the supply chain  在供应链中考虑了客户的要求\n2. There are target agreements for delivery and quality performance in place, agreed with sub suppliers and put into operation  针对交付和质量绩效方面的指标，同分供方达成一致并付诸实施。"]
["D.1.2","Does the supplier have a process for the selection, qualification, approval, development and management of their supply base ?   供应商对供应端的选择、认可、批准、开发和管理过程如何实施？","1. There is a system in place and resources to track supplier performance to measurables and data is shared with the suppliers 有一个系统和资源来追踪供应商测量结果和供应商分享的数据。\n2. There is a defined criteria for supplier acceptance before awarding business and for disqualify suppliers based on performance. 在发放业务之前，应针对合格供应商制定接受准则；对于质量表现差的应制定供应商退出的准则。\n3. On site audits to sub suppliers are executed to check conformity to customer requirements. Supplier development plans are implemented for key suppliers and there is evidence of effectiveness  实施对二级供应商的现场评审来检验是否符合客户的要求，对主要供应商实施供应商发展计划，而且具有有效的证据。"]
["D.1.3*","Is the quality of the out-sourced products and services ( include customer-directed sources) ensured?    如何确保外协的产品与服务质量（包括客户指定）？","1. There is personnel qualified for the various tasks and the responsibilities are defined, including the management of APQP activities with sub suppliers  配备具有完成不同任务能力的人员，明确其职责，其工作内容包括对二级供应商的APQP活动的管理\n2. Supplier has a system to ensure the proper management of safety/critical characteristics according with customer requirements and error proofing is in place 供应商具有一个系统来确保按照客户的要求对安全/关键特性进行适当的管理，制定了防错方案。\n3. Incoming goods are stored appropriately  来料储存合理\n4. A structure is in place to ensure that sub contracted critical processes (heat treatment, painting, chroming, etc) are controlled in place on an ongoing basis and included in the Control Plan  有一体系确保二级供应商的关键过程（热处理、喷漆、电镀等）是持续受控的，并且包含在控制计划中。\n5. There is a system in place that detects changes to the sub contracted process.  有一个流程能对二级供应商的变更及时发现。",null,null,null,{"$f":"Instructions!C29","v":2}]
[null,null,null,"D.1  Supply Base Management Total",null,null,{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Actual    ",{"$f":"SUM(E11:E13)","v":0},{"$f":"SUM(F11:F13)","v":0},{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Possible    ",9,9]
[null,null,null,"Percent    ",{"$f":"E15/E16","v":0},{"$f":"F15/F16","v":0}]
["D.2  Electronic Data Management"]
["D.2.1","There is a set of parameters integrated into the production planning system automatically and updated at planned intervals?   是否具有一套自动兼容到生产策划系统的数据并按照既定的时间间隔进行更新？","1. Transport parameters/schedules, lead times (transport and manufacturing), inventory levels, packaging and internal production requirements are included in the system, as well as supplier constrains, scrap rates, reworks and sub supplier data are considered物流参数/计划表，主要时间（物流和生产制造）、库存情况、包装以及内部生产需求包含在系统中，同样供应商报废率、返工件、二级供应商数据也要考虑在内。\n2. FIFO is applied  先进先出得到应用。\n3. The correct contact list and info should be logged in the system  正确的联系清单和信息应记录在系统中。\n4. There is a system in place to manage finished goods, WIP, raw materials, its location (warehouse, workstation, etc), and the material disposition (approved, on-hold, obsolete, etc).需要有一个体系来对成品、在制品，原材料，它们的位置（仓库，加工区域等），以及材料的处置（批准、待处理、隔离等）方面进行管理。"]
["D.2.2","Is the customer schedule information automatically integrated into organization release system to avoid manual input of data (electronic systems as EDI or at minimum temporary WEB EDI)    客户的计划信息是否可以自动兼容到组织的发货系统中，避免手工输入？（电子系统例如EDI或者至少临时WEB EDI)","1.The timing of Material Requirements Planning System (MRP) process should be set to coincide with the receipt of the expected customer requirements  物料需求计划系统的时间进度的设定应该和客户需求所期望的收据一致。\n2. There is a process in place to ensure complete and accurate data content and timely transmission of Advanced Shipping Notice (ASN)  应该有一个程序确保完整的、准确的数据内容，以及提前发运通知的传送。\n3. Supplier has a clearly defined and communicated chain of command for communication of production and shipment schedules on a 24/7 basis  供应商应该就生产和发运日程沟通的指令建立明确的、全天候的沟通渠道。\n4. Cumulated figures are corrected at minimum once per year and the customer is informed in order to do the correction and set CUM to zero in the same time  至少每年对累积指数进行一次调整；为了确保准确性以及同时确保CUM为0，这些必须通知客户。"]
[null,null,null,"D.2  Electronic Data Management Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E19:E20)","v":0},{"$f":"SUM(F19:F20)","v":0}]
[null,null,null,"Possible    ",6,6]
[null,null,null,"Percent    ",{"$f":"E22/E23","v":0},{"$f":"F22/F23","v":0}]
["D.3  Material Management"]
["D.3.1","Are the necessary quantities / production batch sizes of incoming materials available at the right time and at the right place respecting FIFO ?   进料批次大小和安全库存是否合适，并适时定置摆放，遵循先进先出的原则？","1. Supplier has a formal process to plan material flow into the plant 供应商应就如何安排物料流入工厂建立正规的流程。\n2. Incoming materials are stored appropriately to avoid dirt, damage or mix  来料存储可以避免灰尘、损坏以及混装\n3. Transport and packaging arrangements are suitable, especially for special characteristics  物流和包装安排是合适的，尤其考虑产品的特殊特性。\n4. If outside warehouse is used, there are controls in place (inventory tracking, etc) 如果有外部仓库在使用，是否受控（库存跟踪等）\n5. Work in progress inventory is evidentiated 有证据显示库存得到及时更新。\n6. All type of inventory is regularly checked with actions for discrepancies所有产品类型的库存都应针对差异化开展定期核查。"]
["D.3.2","There is a system in place to monitor Logistic KPI's ?    是否建立了针对物流进行监控的KPI?","1. In time delivery to customer, stock turnover, expedite shipments, etc 可以及时发往客户、库存周转、快运等。"]
["D.3.3","Is a system in place to ensure all parts are labeled accurately, at the appropriate time, applied correctly, identified easily and traceable ?    所有零件是否进行了正确地标识，在适当的时候能得到正确地使用，并且容易识别和可追溯？","1. Supplier is capable to use AIAG labeling requirements  供应商可以运用AIAG标签要求。\n2. Scrap, rework and setting parts are kept separate and correctly identified 报废、返工、调试件保持隔离，并且正确标识。"]
["D.3.4","Is there is a process for managing the life cycle of the part : pre production, running changes, balance out and service parts ?    是否有流程对整个生产件周期的管理，包括试生产、量产阶段的变更、产出平衡和售后件？","1. There is a process for building an inventory buffer of current parts prior to production time needed for new model parts approval/evaluation. 应建立一个流程，在批准安排生产新项目零件之前，应对量产的产品建立缓冲库存。\n2. The organization has a process in place to communicate running change and balance-out parts for final production runs to ensure no over-production and outside purchased items are ordered to the piece. 为避免在量产阶段发生变更之前，造成配套零件的过量生产和外协件的过量采购，组织应建立一个过程明确对此进行前期的沟通。\n3. A formal engineering change sign-off review should exist to ensure that all changes which affect materials planning and logistic process are planned, performed and communicated in a synchronized manner  为确保所有影响材料计划和物流进展的更改都得到策划、实施并同步交流，应建立对此更改进行正式签署的评审流程。\n4. BOM (Bill of Materials) is checked before change to be implemented, obsolete material calculated and communicated  在变更实施前BOM清单需要核查，被隔离的物料需要统计和交流。\n5. There is a process to ensure the availability of service/spare parts. 应建立确保售后件/备件可以获取的流程。\n6. Requirements for non-current parts are calculated and ensured for the entire life cycle of the product as required by the customer. 根据客户的需求，应保证断点产品在整个寿命周期的生产需求。"]
["D.3.5","Is there a procedure for packaging development, coordinated with the Product Approval Process ?是否有针对包装方案开发的流程，并与产品批准流程保持一致？","1. The organization has a process and supporting documentation to define standard packaging, (usually reusable container), and back-up packaging (usually expandable containers), and pack size before start of production (e.g., agreements about packaging type and rules for use with customer, involvement of all internal departments connected with the packaging process), including special requirements for overseas packaging 组织有一个程序以及支撑文件在SOP之前来规定标准包装（通常是可重复使用的料箱）以及备用包装（通常是可扩展的容器）和包装尺寸（例如，关于包装类型和使用规则和客户达成协议，与包装相关的内部部门也要参与），包括对于海外包装的特殊要求。"]
["D.3.6","Is there a procedure to ensure that the suppliers, sub-contractors, and logistics providers give warning if there is a risk that requirements cannot be fulfilled; all significant changes are communicated as soon as they are identified ?  是否具有一个流程，确保当供应商、分供方、物流提供商存在不能满足要求的风险时能及时提出预警；所有重大变化一旦被识别能够得到及时沟通？","1. Contingency plans are in place  制定了意外事故应急计划"]
[null,null,null,"D.3  Material Management Total"]
[null,null,null,"Actual    ",{"$f":"SUM(E26:E31)","v":0},{"$f":"SUM(F26:F31)","v":0}]
[null,null,null,"Possible    ",18,18]
[null,null,null,"Percent    ",{"$f":"E33/E34","v":0},{"$f":"F33/F34","v":0}]
[]
[null,null,null,"D. Supply Chain / Purchasing Total"]
[null,null,null,"Actual    ",{"$f":"E15+E22+E33","v":0},{"$f":"F15+F22+F33","v":0}]
[null,null,null,"Possible    ",{"$f":"E16+E23+E34","v":33},{"$f":"F16+F23+F34","v":33}]
[null,null,null,"Percent    ",{"$f":"E38/E39","v":0},{"$f":"F38/F39","v":0}]