{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Manufacturing","Quality","Technology","Logistic","General","Sustainability","EPC","Assessment  Report"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":11,"defined_names":358,"comments":0,"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":"Manufacturing","index":0,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[51,2,52,2],[53,2,56,2],[24,2,26,2],[27,2,30,2],[31,2,33,2],[34,2,36,2],[57,2,60,2],[61,2,63,2],[37,2,39,2],[40,2,43,2],[44,2,47,2],[48,2,50,2],[64,5,66,5],[61,5,63,5],[48,5,50,5],[40,7,43,7],[64,3,66,3],[61,3,63,3],[57,3,60,3],[64,7,66,7],[61,6,63,6],[64,6,66,6],[57,7,60,7],[57,6,60,6],[51,7,52,7],[61,7,63,7],[53,7,56,7],[44,7,47,7],[48,7,50,7],[53,3,56,3],[51,6,52,6],[44,3,47,3],[48,3,50,3],[51,3,52,3],[40,3,43,3],[53,5,56,5],[48,6,50,6],[40,5,43,5],[44,5,47,5],[34,7,36,7],[7,7,9,7],[37,6,39,6],[27,7,30,7],[3,7,6,7],[13,7,15,7],[16,7,19,7],[37,7,39,7],[3,6,6,6],[7,6,9,6],[10,7,12,7],[31,7,33,7],[20,7,23,7],[24,7,26,7],[27,6,30,6],[20,6,23,6],[24,6,26,6],[31,6,33,6],[34,5,36,5],[24,3,26,3],[16,3,19,3],[31,1,33,1],[1,0,1,3],[17,0,18,0],[24,1,26,1],[7,3,9,3],[8,0,9,0],[12,0,13,0],[13,2,15,2],[15,0,16,0],[16,2,19,2],[20,2,23,2],[20,3,23,3],[0,0,0,3],[3,5,6,5],[7,5,9,5],[10,5,12,5],[13,5,15,5],[10,6,12,6],[13,6,15,6],[3,1,5,1],[10,1,12,1],[13,1,15,1],[3,3,6,3],[10,3,12,3],[13,3,15,3],[3,2,6,2],[7,2,9,2],[10,2,12,2],[64,2,66,2],[34,6,36,6],[57,5,60,5],[40,6,43,6],[53,6,56,6],[44,6,47,6],[16,6,19,6],[51,5,52,5],[27,1,29,1],[31,3,33,3],[27,3,30,3],[53,1,55,1],[34,1,36,1],[40,1,42,1],[51,1,52,1],[34,3,36,3],[37,5,39,5],[37,3,39,3],[37,1,39,1],[16,5,19,5],[20,5,23,5],[24,5,26,5],[27,5,30,5],[31,5,33,5]]}
["Supplier Self Assessment"]
["Manufacturing"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Manufacturing","Process Flow",1,"What best describes in process material handling?",null,10]
[]
[]
[]
[null,null,2,"Which kind of process flow is followed?",null,5]
[]
[]
[null,"Standardized Work",3,"Do the Standard Operation Sheets contain appropriate and complete information?",null,10]
[]
[]
[null,null,4,"Are Standard Operation Sheets easily  to be found at the work station",null,10]
[]
[]
[null,null,5,"What best describes operator training?",null,10]
[]
[]
[]
[null,null,6,"Are Standard Operation Sheets being followed by team members & audited by team leaders?",null,10]
[]
[]
[]
[null,"Capacity",7,"Is capacity determined appropriately?",null,10]
[]
[]
[null,null,8,"Is process capability & performance maintained at levels originally approved by the customer?",null,10]
[]
[]
[]
[null,"Workplace Organization",9,"Is sufficient lights & air circulation available?",null,5]
[]
[]
[null,"5S & Housekeeping",10,"Is the work place properly organized?",null,5]
[]
[]
[null,null,11,"Are parts, tools & equipment arranged in fixed location?",null,10]
[]
[]
[null,"Preventive Maintenance",12,"Is skilled manpower available to carryout machineries maintenance?",null,10]
[]
[]
[]
[null,null,13,"Are preventive & predictive maintenance processes in place for all machineries?",null,10]
[]
[]
[]
[null,null,14,"Are adequate spare parts to maintain the machineries available?",null,10]
[]
[]
["Facility","Tool Room",15,"Are resources available to design tools & gauges?",null,5]
[]
[null,null,16,"Is skilled manpower available to carryout tools / dies / molds maintenance?",null,10]
[]
[]
[]
[null,null,17,"Are preventive & predictive maintenance processes in place for all tools?",null,10]
[]
[]
[]
[null,null,18,"Are adequate spare parts to maintain the tools available?",null,10]
[]
[]
[null,null,19,"Are contingency plans in place for electricity / water / compressed air supply/ Fire?",null,10]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F4:F67)","v":170},{"$f":"SUM(G4:G67)","v":0}]

{"sheet":"Quality","index":1,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[[55,1,58,1],[63,6,66,6],[71,5,72,5],[67,7,70,7],[97,2,98,2],[97,3,98,3],[97,5,98,5],[97,6,98,6],[51,6,54,6],[78,6,80,6],[87,6,89,6],[90,6,92,6],[95,3,96,3],[95,2,96,2],[95,5,96,5],[95,6,96,6],[73,6,74,6],[83,3,86,3],[78,3,80,3],[73,5,74,5],[67,6,70,6],[71,6,72,6],[55,5,58,5],[59,5,62,5],[30,3,33,3],[22,3,25,3],[14,3,17,3],[14,6,17,6],[22,7,25,7],[26,7,29,7],[10,7,13,7],[73,0,74,0],[73,1,74,1],[73,3,74,3],[38,3,41,3],[55,3,58,3],[67,0,69,0],[67,1,70,1],[63,3,66,3],[63,1,66,1],[67,3,70,3],[71,0,72,0],[71,1,72,1],[71,3,72,3],[59,3,62,3],[38,1,41,1],[14,1,16,1],[42,3,45,3],[6,7,9,7],[14,7,17,7],[18,7,21,7],[34,6,37,6],[81,7,82,7],[83,7,86,7],[93,3,94,3],[93,7,94,7],[93,6,94,6],[75,6,77,6],[83,6,86,6],[81,6,82,6],[90,5,92,5],[93,5,94,5],[75,5,77,5],[78,5,80,5],[81,5,82,5],[83,5,86,5],[87,5,89,5],[75,7,77,7],[71,7,72,7],[73,7,74,7],[42,6,45,6],[55,6,58,6],[46,7,49,7],[3,7,5,7],[42,7,45,7],[38,7,41,7],[67,5,70,5],[51,7,52,7],[3,5,5,5],[6,5,9,5],[10,5,13,5],[14,5,17,5],[30,7,33,7],[34,7,37,7],[55,7,58,7],[59,7,62,7],[30,5,33,5],[34,5,37,5],[38,5,41,5],[42,5,45,5],[46,5,49,5],[51,5,54,5],[46,6,49,6],[63,7,66,7],[59,6,62,6],[63,5,66,5],[38,6,41,6],[0,0,0,3],[18,5,21,5],[75,1,94,1],[75,3,77,3],[1,0,1,3],[22,5,25,5],[81,3,82,3],[6,3,9,3],[46,3,48,3],[51,3,54,3],[26,5,29,5],[34,3,37,3],[3,6,5,6],[6,6,9,6],[3,3,5,3],[26,6,29,6],[30,6,33,6],[10,6,13,6],[26,3,29,3],[18,6,21,6],[22,6,25,6],[18,3,20,3],[10,3,12,3]]}
["Supplier Self Assessment"]
["Quality"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Management",null,1," What best represents the suppliers process?",null,5]
[]
[]
[null,null,2,"Formal process is identified to protect pipeline supply chain (MRP, KAN BAN, etc.) and provide safety inventory.  ",null,10]
[]
[]
[]
[null,null,3,"Supplier demonstrates understanding of Process Validation.  ",null,20]
[]
[]
[]
[null,null,4,"Supplier has Material Identification Traceability System supported with current data.",null,10]
[]
[]
[]
[null,null,5,"Tier 1 Supplier has plan on how Tier 2 suppliers will be managed.",null,20]
[]
[]
[]
[null,null,6,"Supplier has Change Management process for  supplier/Material/Process/machine change",null,15]
[]
[]
[]
["Quality",null,7,"Supplier utilizes formal layered audit process on their quality/manufacturing systems.\n(Applicable or GM project )",null,10]
[]
[]
[]
[null,null,8,"Supplier utilizes formal audits focused on quality/manufacturing systems of their suppliers.",null,15]
[]
[]
[]
[null,null,9,"Supplier demonstrates process for Non-Conforming Material management",null,10]
[]
[]
[]
[null,null,10,"Incoming Material Handling System is present (proper tagging, material inspection, documentation).",null,5]
[]
[]
[]
[null,null,11,"Review material identification method used for materials in process (tagging, labeling, and traceability method).",null,5]
[]
[]
[]
[null,null,12,"Supplier demonstrates effective use of PFMEA: quantifies risk, identifies special characteristics for use in Control Plan, takes action to reduce RPNs;",null,15]
[]
[]
[]
[null,null,13,"Is the company currently using RPL instead of RPN ?",null,10]
[null,null,14,"There is linkage between the design record, PFMEA, Control Plan and Operator Instructions, e.g. special characteristics are identified by supplier, effective and understandable controls are specified for affected operators use",null,10]
[]
[]
[]
[null,null,15,"Supplier has process of drawing distribution",null,5]
[]
[]
[]
[null,null,16,"Supplier demonstrates understanding of quality inspection and sampling plan requirements.",null,10]
[]
[]
[]
[null,null,17,"Supplier complies with acceptable measurement system analysis and calibration techniques.",null,10]
[]
[]
[]
[null,null,18,"Usage of statistical methods in process control systems.",null,10]
[]
[]
[]
[null,null,19,"Is supplier experienced in OEM manufacturing. Like GM,VW and so on…",null,10]
[]
[null,null,20,"Supplier is familiar with  AIAG manufacturing standards e.g. MSA, SPC, APQP, FMEA, PPAP",null,10]
[]
[null,"Employee Involvement",21,"Are employees encouraged to get involved in problem solving workshops",null,10]
[]
[]
[null,null,22,"Supplier has an effective employee suggestion program; metrics include no. suggestions/employee/year, percent suggestions implemented by year, improvement in rate of employee suggestions submitted per year, improvement in rate of suggestions implemented per year",null,5]
[]
[]
[null,null,23,"Are employees recognized for their achievements",null,5]
[]
[null,null,24,"Are team meeting areas available, and are performance charts displayed in the area",null,10]
[]
[]
[]
[null,null,25,"Does supplier track PPM level with their current customers?",null,20]
[]
[]
[null,null,26,"What is the internal supplier/facility current PPM?",null,10]
[]
[]
[null,null,27,"Does the supplier support extra-curricular activities, picnics, sports, social service. Etc.",null,3]
[]
[null,null,28,"Does the supplier certified on ISO 9001/ IATF?",null,3]
[]
[null,null,29,"Does the provider implement the value stream map methodology in its processes? Evidence Required",null,3]
[]
[null,null,null,null,null,{"$f":"SUM(F4:F99)","v":284},{"$f":"SUM(G4:G99)","v":0}]

{"sheet":"Technology","index":2,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[40,5,43,5],[8,7,11,7],[12,7,15,7],[8,5,11,5],[16,7,19,7],[8,6,11,6],[12,6,15,6],[16,6,19,6],[16,5,19,5],[20,5,23,5],[55,6,58,6],[40,6,43,6],[24,6,27,6],[36,6,39,6],[28,6,31,6],[32,6,35,6],[44,6,50,6],[51,6,54,6],[55,7,58,7],[44,7,50,7],[40,7,43,7],[20,7,23,7],[28,7,31,7],[24,7,27,7],[51,7,54,7],[36,7,39,7],[32,7,35,7],[55,0,57,0],[44,3,50,3],[55,1,58,1],[55,3,58,3],[40,3,43,3],[40,1,54,1],[5,1,7,1],[36,3,39,3],[3,0,3,3],[5,3,6,3],[12,3,15,3],[16,3,19,3],[20,3,23,3],[8,3,11,3],[8,1,39,1],[0,0,0,3],[5,7,7,7],[44,5,50,5],[51,5,54,5],[55,5,58,5],[24,5,27,5],[28,5,31,5],[32,5,35,5],[36,5,39,5],[5,6,7,6],[20,6,23,6],[24,3,27,3],[32,3,35,3],[28,3,31,3],[5,5,7,5],[12,5,15,5]]}
["Supplier Self Assessment"]
[]
[]
["Technology"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Engineering","Engineering Support",1,"Engineering in sourcing region.",null,7]
[]
[]
[null,"Design Capability/Control",2,"Supplier demonstrates understanding of Design Validation.  ",null,10]
[]
[]
[]
[null,null,3,"Does supplier have any CAD resource? Pls list",null,10]
[]
[]
[]
[null,null,4,"Prior use and knowledge of DFMEA.",null,10]
[]
[]
[]
[null,null,5,"Benchmarking used to develop new designs?"]
[]
[]
[]
[null,null,6,"Are there records of formal documented design reviews by the appropriate internal functions conducted at appropriate stages of design per the design plan?",null,5]
[]
[]
[]
[null,null,7,"Evidence of regular design and development reviews with customers.",null,10]
[]
[]
[]
[null,null,8,"Are design documents and data reviewed and approved by authorized personnel prior to issue?",null,10]
[]
[]
[]
[null,null,9,"Is there a master list (or equivalent) identifying document revision status readily available? ",null,5]
[]
[]
[]
[null,"Validation and methods for identifying and updating issues.",10,"Does supplier have past knowledge and use of validation plans and forms?",null,10]
[]
[]
[]
[null,null,11,"Is the performance testing (that considers and includes as appropriate life, durability, reliability) tracked for timely completion and conformance?",null,10]
[]
[]
[]
[]
[]
[]
[null,null,12,null,null,5]
[null,null,null,"Prototype fabrication capability in house or outsourced."]
[]
[]
["Lessons Learned","Lessons Learned",13,"Does supplier have documented evidence of lessons learned?",null,10]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F6:F59)","v":102},{"$f":"SUM(G6:G59)","v":0}]

{"sheet":"Logistic","index":3,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[50,6,52,6],[53,5,55,5],[53,2,55,2],[53,3,55,3],[53,6,55,6],[27,7,30,7],[35,7,38,7],[31,7,34,7],[43,7,49,7],[39,7,42,7],[3,7,6,7],[23,3,26,3],[7,7,10,7],[3,6,6,6],[11,6,14,6],[11,7,14,7],[19,7,22,7],[19,6,22,6],[23,6,26,6],[23,7,26,7],[7,3,10,3],[11,3,14,3],[7,6,10,6],[3,3,6,3],[15,7,18,7],[31,6,34,6],[35,6,38,6],[31,1,34,1],[43,5,46,5],[43,3,49,3],[31,5,34,5],[43,6,46,6],[27,6,30,6],[15,1,18,1],[19,3,22,3],[23,5,26,5],[39,6,42,6],[39,5,42,5],[39,1,42,1],[15,6,18,6],[15,3,18,3],[35,5,38,5],[31,3,34,3],[27,3,29,3],[27,5,30,5],[35,3,38,3],[19,5,22,5],[39,3,42,3],[0,0,0,3],[3,1,6,1],[50,5,52,5],[27,0,33,0],[3,5,6,5],[7,5,10,5],[11,5,14,5],[15,5,18,5],[43,0,45,0],[1,0,1,3]]}
["Supplier Self Assessment"]
["Logistic"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Logistics",null,1,"What is the lead time for product to AK?",null,10]
[]
[]
[]
[null,null,2,"What is the delivery frequency?",null,10]
[]
[]
[]
[null,null,3,"What is the method of package?",null,10]
[]
[]
[]
[null,null,4,"Is there emergency plan or backup plan?",null,10]
[]
[]
[]
[null,null,5,"Is FIFO and traceability concept implemented?",null,20]
[]
[]
[]
[null,null,6,"Does the supplier/facility have a documented procedure to  regulate customer order internally?",null,10]
[]
[]
[]
[null,null,7,"How is the logistic capability?",null,10]
[]
[]
[]
[null,null,8,"Can you prepare buffer stock in supplier site or set up hub-warehouse for AK? ",null,10]
[]
[]
[]
[null,null,9,"How long time for the buffer stock?",null,10]
[]
[]
[]
[null,null,10,"What is the suppliers current on time delivery percentage for service parts?",null,20]
[]
[]
[]
["Material",null,11,"Is there  any protection for special parts storage?",null,10]
[]
[]
[]
[]
[]
[]
[null,null,12,"What is the inventory turn?",null,5]
[]
[]
[null,null,13,"Does the supplier certified on C TPAT,OEA, BASC or other safety program? Please provide the Certificate Number",null,3]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F4:F56)","v":138},{"$f":"SUM(G4:G56)","v":0}]

{"sheet":"General","index":4,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,0,59,0],[3,1,9,1],[43,1,55,1],[57,3,59,3],[57,5,59,5],[43,3,44,3],[40,0,41,0],[39,5,42,5],[20,3,23,3],[31,5,34,5],[39,1,42,1],[39,3,42,3],[35,1,37,1],[10,1,11,1],[3,5,5,5],[3,3,5,3],[57,6,59,6],[57,7,59,7],[57,2,59,2],[52,5,55,5],[49,3,51,3],[52,3,55,3],[49,2,51,2],[52,2,55,2],[49,5,51,5],[39,6,42,6],[52,6,55,6],[35,7,38,7],[43,6,45,6],[46,6,48,6],[49,6,51,6],[49,7,50,7],[46,7,47,7],[43,7,45,7],[52,7,55,7],[35,6,38,6],[39,7,42,7],[31,7,34,7],[20,7,23,7],[24,7,26,7],[20,6,23,6],[24,6,26,6],[27,6,30,6],[31,6,34,6],[16,6,19,6],[13,3,15,3],[16,3,19,3],[16,7,19,7],[10,5,11,5],[10,3,11,3],[3,7,5,7],[10,7,11,7],[13,7,15,7],[3,6,5,6],[10,6,11,6],[13,6,15,6],[85,3,88,3],[73,3,76,3],[69,3,72,3],[77,3,80,3],[81,3,84,3],[0,0,0,3],[43,5,45,5],[10,0,11,0],[1,0,1,3],[3,0,4,0],[35,5,38,5],[20,5,23,5],[24,5,26,5],[35,3,38,3],[31,3,34,3],[27,5,30,5],[24,3,26,3],[80,1,83,1],[65,3,68,3],[75,1,78,1],[13,5,15,5],[16,5,19,5],[61,3,64,3],[70,1,73,1],[27,3,30,3],[24,1,27,1],[46,3,48,3],[46,5,48,5]]}
["Supplier Self Assessment"]
["General"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Company Ownership","In regard to the Company Profile:  ",1,"Is the company privately held?",null,5]
[]
[]
[null,null,2,"Employee turnover rate?",null,5]
[null,null,3,"How long has the supplier been in the business that they are quoting?",null,5]
[null,null,4,"Does supplier/facility currently provide OEM automotive parts?  ",null,5]
[null,null,5,"What is the financial status of the company?",null,10]
["Tiered Supplier Management",null,6,"What are your payment terms and conditions for tier 2 suppliers?  ",null,5]
[]
[null,null,7,"Does supplier/plant regularly review supplier performance? ",null,10]
[null,null,8,"What is supplier's turn around time for quoting AK product? ",null,10]
[]
[]
[null,null,9,"Does supplier's capacity planning comprehend the maximum capacities of all tiered suppliers?  ",null,10]
[]
[]
[]
[null,null,10,"What are your agreements with your suppliers with regard to providing service parts?  ",null,10]
[]
[]
[]
["Systems","Legal",11,"Is there any pending litigation against the supplier/facility?",null,10]
[]
[]
[null,null,12,"Has the supplier/facility been cited and or fined for failure to comply with any state/federal regulations and or statures in the past 2 years?",null,10]
[]
[]
[]
[null,null,13,"Does the supplier have a process in place to ensure compliance with Secure Data Management to ensure confidential treatment of AK information and documentation?",null,10]
[]
[]
[]
[null,null,14,"Does supplier work to realize production efficiencies in order to share savings with customer?",null,5]
[]
[]
[]
[null,"Finance Books",15,"Are finances properly tracked to ensure a continuous flow of raw material?",null,10]
[]
[]
[]
[null,"Ratios",16,"What is the Debt/Equity ratio?",null,5]
[]
[]
[null,null,17,"Is there a comprehensive employee training program?",null,10]
[]
[]
[null,null,18,"What is the health of Operating Cash Flow?",null,5]
[]
[]
[null,null,19,"Does the  Supplier include within its suppliers individuals, social organizations or community groups usually excluded? Which ones?",null,10]
[]
[]
[]
[null,null,20,"Is there a COVID-19 contingency plan in place? ",null,10]
[null,null,25,"Are procedures available for incident & near miss investigation?",null,10]
[]
[]
[" ",null,null,null,null,{"$f":"SUM(F4:F60)","v":170},{"$f":"SUM(G4:G60)","v":0}]

{"sheet":"Sustainability","index":5,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[51,0,66,0],[57,4,60,4],[34,0,36,0],[57,2,60,2],[57,3,60,3],[57,5,60,5],[57,6,60,6],[57,7,60,7],[61,2,63,2],[61,3,63,3],[61,5,63,5],[61,6,63,6],[61,7,63,7],[53,2,56,2],[53,3,56,3],[53,5,56,5],[53,6,56,6],[53,7,56,7],[51,2,52,2],[51,3,52,3],[51,5,52,5],[51,6,52,6],[51,7,52,7],[44,2,47,2],[44,3,47,3],[44,5,47,5],[44,6,47,6],[44,7,47,7],[48,2,50,2],[48,3,50,3],[48,5,50,5],[48,6,50,6],[48,7,50,7],[40,2,43,2],[40,3,43,3],[40,5,43,5],[40,6,43,6],[40,7,43,7],[37,2,39,2],[37,3,39,3],[37,5,39,5],[37,6,39,6],[37,7,39,7],[34,1,50,1],[34,2,36,2],[34,3,36,3],[34,5,36,5],[34,6,36,6],[34,7,36,7],[31,2,33,2],[31,3,33,3],[31,5,33,5],[31,6,33,6],[31,7,33,7],[3,1,33,1],[20,2,23,2],[20,3,23,3],[20,5,23,5],[20,6,23,6],[20,7,23,7],[27,2,30,2],[27,3,30,3],[27,5,30,5],[27,6,30,6],[27,7,30,7],[24,2,26,2],[24,3,26,3],[24,5,26,5],[24,6,26,6],[24,7,26,7],[13,6,15,6],[13,7,15,7],[15,0,16,0],[16,2,19,2],[16,3,19,3],[16,5,19,5],[16,6,19,6],[16,7,19,7],[17,0,18,0],[10,6,12,6],[3,6,6,6],[3,7,6,7],[7,2,9,2],[7,3,9,3],[7,5,9,5],[7,6,9,6],[7,7,9,7],[10,7,12,7],[0,0,0,3],[1,0,1,3],[3,2,6,2],[3,3,6,3],[3,5,6,5],[8,0,9,0],[10,2,12,2],[10,3,12,3],[10,5,12,5],[12,0,13,0],[13,2,15,2],[13,3,15,3],[13,5,15,5]]}
["Supplier Self Assessment"]
["Sustainability"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Environmental management System","EMS",1,"Has the organization established and maintained an environmental management system?",null,10,null,null,null,null,null,31]
[]
[]
[]
[null,null,2,"Does  your company have formal environmental Policy, wich include a commitmen to legal compliance, continuos measurement and continuos impruvement in environmental performance? Enviromental Policy  coverage ",null,10]
[]
[]
[null,null,3,"Are the following areas coverage by this policy or related processes and wirking procedures? \n\n* Energy consumption and green house gas emmisions\n\n* Water quality and consumption Air quality\n\n* Natural Resource\n\n* Responsible Chemical management",null,10]
[]
[]
[null,null,4,"Does your company have annual objetives an activities according in the areas covered by your environmental policy?",null,10]
[]
[]
[null,null,5,"Which of the following channels dose your company use  to communicate its policy to employees?\nIntranet/meetings, brochurs etc.","  10 Documment  incluidind follow up",10]
[null,null,null,null,"   5- Documment training no follow up"]
[]
[]
[null,null,null,"Does this site have a certified Energy management system?",null,10]
[]
[]
[]
[null,null,6,"Does your facility use restrictes substances or chemical for your production?",null,10]
[]
[]
[null,null,7,"Does this site have procedures to identify and manage substances with restrictions?",null,3]
[]
[]
[]
[null,null,8,"Does your company have a written healt and safety policy in place, which complies with local law, industrial requiremnets an international  standards?",null,10]
[]
[]
["Healt and Safety","Safety",9,"Does this site have a Healt and Safety management system in place",null,10]
[]
[]
[null,null,10,"Are procedures for risk assessment for high risk work activities available?",null,10]
[]
[]
[null,null,11,"Are employees trained on Safety / Health?",null,10]
[]
[]
[]
[null,null,12,"Does your company have a contingency plan in this site",null,10]
[]
[]
[]
[null,null,13,"Does your company have a code of conducte in place",null,10]
[]
[]
["SOCIAL RESPONSIBLE","ETHIC",14,"Do you organise training sessions to enhance the understanding of CSR/ Sustainability?",null,10]
[]
[null,null,15,"On which of the following topics do you organise training sessions?\n\n* Business Ethics\n* Environment\n* Working conditions and human Rights",null,10]
[]
[]
[]
[null,null,16,"\nFor which of the following working conditions and human rights issues does your company have a policy in place?\n\n-Human Rights\n*Child labor and young workers realtion\n*Wages and benefits \n* Working hours\n*Forced or compulsory labor\n*Freedom of assosiation\n*Healt and safety\n*HarassmentNon Discrimination\n*Corruption",null,10]
[]
[]
[]
[null,null,17,"\nDoes the site have a management system to manage working conditions and human rights issues?",null,10]
[]
[]
[null,null,18,"Has your company established requirements on Corporate Social Responsibility (CSR) / Sustainability for your suppliers?",null,5]
[null,null,19,"\nWhat areas are covered by these requirements on Corporate Social Responsibility (CSR) / Sustainability?\n\n• Salaries and benefits\n• Work hours\n• Modern slavery (eg slavery, servitude, forced labor .\n• Freedom of association, including collective bargaining\n• Harassment and non-discrimination\n• Health and security\n• Corruption, extortion and bribery\n• Privacy and data protection\n• Fair competition and antitrust\n• Conflict of interests\n• GHG emissions, energy efficiency and renewable energy\n• Sustainable resource management and waste reduction\n",null,10]
[null,null,20,"What processes does your company have to know if your suppliers meet your requirements?",null,5]
[null,null,null,null,null,{"$f":"SUM(F4:F67)","v":193},{"$f":"SUM(G4:G67)","v":0}]

{"sheet":"EPC","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[3,1,9,1],[3,2,6,2],[3,3,6,3],[8,0,9,0],[3,6,6,6],[3,7,6,7],[7,2,9,2],[7,3,9,3],[7,5,9,5],[7,6,9,6],[7,7,9,7],[3,5,6,5],[16,7,19,7],[10,7,11,7],[12,2,15,2],[12,3,15,3],[12,5,15,5],[12,6,15,6],[12,7,15,7],[10,2,11,2],[10,3,11,3],[10,5,11,5],[10,6,11,6],[16,2,19,2],[16,3,19,3],[16,4,19,4],[16,5,19,5],[16,6,19,6],[20,2,22,2],[20,3,22,3],[20,5,22,5],[20,6,22,6],[20,7,22,7],[32,1,37,1],[32,0,37,0],[10,0,15,0],[10,1,15,1],[24,1,31,1],[24,0,31,0]]}
["Supplier Self Assessment",null,null,null,"Please fill out the threshold column if you are validating a new process line. If you are not validating a new process line, please enter a score of 0 in the score column."]
["Early Production Containment"]
["Category","Sub-Category","Item","Description","Risk Rating Guideline","Possible Pts.","Supplier Pts.","Comments"]
["Supplier Responsibility","EPC",1,"Robust Pre launch Control Plan, the Control plan must include the  EPC",null,3,null,null,null,null,null,31]
[]
[]
[]
[null,null,2,"Does the company have a designated responsible person for the Early Production Containment (EPC) process?",null,3]
[]
[]
["Technical Information Availability","EPC",3,"Drawings and/or picture rich Standardized Work instructions  (latest release level) available at Early Production Containment area with the latest change level",null,3]
[]
[null,null,4,"ave all the required documents been read and understood?\nCG4338 GM1927 03 Supplier Quality Statement of Requirement\n- CG4355 GM 1927 03 SQ Sub Tier Supplier Management Statement of Requirements\n- GM 1927 09 PPAP Action Plan Worksheet\n- GM 1927 28 EPC Procedure  (added - audit developed based on procedure)\n- GM1927 33 Early Production Containment Audit\n- GM 1927 39 Early Containment exit letter template\n- GM 1927 11 APQP worksheet and \n- GM 1927 17 Supplier Quality Processes and Measurements Procedure",null,3]
[]
[]
[]
["Process Validation","EPC",5,"Are redundant 100% checks in place to verify the standard control plan effectiveness? Are Tier 2 pass-thru features 100% checked in Early Production Containment?",null,3]
[]
[]
[]
[null,null,6,"Verify current dates, etc. of Pre launch CP document as a separate documents over and above regular production PCP.",null,3]
[]
[]
[null,null,7,"Training matrix covers all Early Production Containment Operators \nOperators have been trained by qualified staff. \nOperators are independent from normal production.",null,3]
["Quality System Implementation Plan","EPC",8,"Early Production Containment station is located away from normal production line and properly identified using Visual management; adequate lighting; production racks and scrap containers are clearly identified and separated from another.",null,3]
[null,null,9,"Logical flow of material into and out of Early Production Containment being followed.\nSegregation and identification of good, scrap and rework parts.",null,3]
[null,null,10," No rework to be conducted at EPC station.\nRework area should be separate from ALL processes and reworked parts reintroduced into normal production following Independent Repair Confirmation Process. (at  least one station prior to defects creation point)\nAll rework shall be approved by GM\n",null,3]
[null,null,11,"Check to make sure gauges are calibrated.\nVerify tools and gauges are to the latest engineering change level.\nVerify R & R has passed",null,3]
[null,null,12,"Ensure that Gauge Instructions are available at the gauge station.",null,3]
[null,null,13,"Verify Master Parts are of the current Engineering level.",null,3]
[null,null,14,"Inspection sheets should contain: quantity checked, total OK, total not OK, description of failure defect and 5 phase/fast response responsible person",null,3]
[null,null,15,"All parts exiting Early Production Containment have the identification and controls in place to ensure only approved material leaves Early Production Containment area",null,3]
["QUALITY SYSTEM IMPLEMENTATION BY MANAGEMENT","EPC",16,"Look for daily updated I charts, Corrective Action Reports exist for each issue identified in Early Production Containment.\nLook for process to verify all steps from immediate containment through to irreversible corrective action.\nLook for Supplier to be Collecting data to drive continuous improvements. Keep top 5 lists/ P-Charts/Trends and do these identify which documentation for improvements. \n",null,3]
[null,null,17,"Early Production Containment issues are reviewed at the daily Management meeting, including timed with responsibility and documented on Plant informational Board (Fast Response Board).",null,3]
[null,null,18,"Look for shift log/notes/Quality Alert.\nLook for evidence of a closed loop on shift problems, ideally person to person cross over.\nCheck for up to date information board with training records, I-chart, layered audit plan/results, quality emerging issues / high focus areas",null,3]
[null,null,19,"Is there evidence that all Early Production Containment concerns are tracked back to the PCP and PFMEA? Also ensure that for \"fresh found\" issues there is a tracking mechanism with plan to incorporate",null,3]
[null,null,20,"Audit frequency, schedule by auditor, report form or checklist.\nManagement involvement and schedule.",null,3]
[null,null,21,"Verify understanding that failure to execute Early Production Containment , or shipment of a single defect during Early Production Containment period, will result in immediate CS1.  CS2 will follow CS1 if not effective in stopping the flow of defects. ",null,3]
[null,null,null,null,null,{"$f":"SUM(F24:F38)","v":45},{"$f":"SUM(G24:G38)","v":0}]

{"sheet":"Assessment  Report","index":7,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,3,2,10],[5,1,5,12],[7,1,7,3],[7,4,7,7],[7,8,7,9],[7,10,7,12],[0,0,2,2],[12,10,13,10],[12,11,13,11],[12,12,13,12],[13,5,13,7],[8,1,8,3],[8,4,8,7],[9,1,9,3],[9,4,9,7],[10,1,10,3],[10,4,10,7],[8,8,9,9],[8,10,9,12],[10,8,10,9],[10,10,10,12],[47,3,47,9],[51,1,51,9],[32,1,32,7],[39,1,44,12],[48,1,49,9],[48,11,48,12],[49,10,49,12],[53,11,53,12],[54,10,54,12],[0,11,2,12],[24,2,24,3],[20,2,20,4],[21,2,21,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[12,8,13,8],[12,9,13,9],[30,1,30,4],[30,5,30,7],[53,1,54,9],[33,1,33,4],[33,5,33,7],[52,1,52,2],[24,4,24,5],[52,3,52,8],[27,4,27,5],[28,4,28,5],[25,4,25,5],[26,4,26,5],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[46,1,46,9],[47,1,47,2]]}
[null,null,null,"SUPPLIER  SELF ASSESSMENT AUDIT (SAA)"]
[]
[]
[]
[]
[null,"Assessment Report"]
[]
[null,"Supplier Name:",null,null,null,null,null,null,"Date of Assessment:"]
[null,"Supplier Location:",null,null,null,null,null,null,"Auditors Name (s):"]
[null,"Supplier Email:"]
[null,"Supplier Phone:",null,null,null,null,null,null,"Lead Auditor Phone And Email:"]
[]
[null,null,null,null,null,null,null,null,"Documentation NOT developed and poorly implemented","Significant Deficiencies","Minor Deficiencies","Satisfactory","Good with proven Continuous Improvement"]
[null,null,null,null,null,"Points"]
[null,"NO.","Element Description",null,null,"Possible Pts.","Supplier Pts.","Percentage","0%<25%","25%<50%","50%<70%","70%<90%","90%-100%"]
[null,1,"Manufacturing",null,null,{"$f":"Manufacturing!F68","v":170},{"$f":"Manufacturing!G68","v":0},{"$f":"G16/F16","v":0},{"$f":"IF(H16=\"\",\"\",IF(H16<25%,\"X\",\"\"))","v":"X"},{"$f":"IF(AND(H16>=25%,H16<50%),\"X\",\"\")","v":""},{"$f":"IF(AND(H16>=50%,H16<70%),\"X\",\"\")","v":""},{"$f":"IF(AND(H16>=70%,H16<90%),\"X\",\"\")","v":""},{"$f":"IF(AND(H16>=90%,H16<=100%),\"X\",\"\")","v":""}]
[null,2,"Quality",null,null,{"$f":"Quality!F100","v":284},{"$f":"Quality!G100","v":0},{"$f":"G17/F17","v":0},{"$f":"IF(H17=\"\",\"\",IF(H17<25%,\"X\",\"\"))","v":"X"},{"$f":"IF(AND(H17>=25%,H17<50%),\"X\",\"\")","v":""},{"$f":"IF(AND(H17>=50%,H17<70%),\"X\",\"\")","v":""},{"$f":"IF(AND(H17>=70%,H17<90%),\"X\",\"\")","v":""},{"$f":"IF(AND(H17>=90%,H17<=100%),\"X\",\"\")","v":""}]
[null,3,"Technology",null,null,{"$f":"Technology!F60","v":102},{"$f":"Technology!G60","v":0},0,"X","","","",""]
[null,4,"Logistic",null,null,{"$f":"Logistic!F57","v":138},{"$f":"Logistic!G57","v":0},0,"X","","","",""]
[null,5,"General",null,null,{"$f":"General!F61","v":170},{"$f":"General!G61","v":0},0,"X","","","",""]
[null,6,"Sustainability",null,null,{"$f":"Sustainability!F68","v":193},{"$f":"Sustainability!G68","v":0},0,"X","","","",""]
[null,7,"Early Production Containment",null,null,{"$f":"EPC!F39","v":45},{"$f":"EPC!G39","v":0},0,"X","","","",""]
[]
[]
[null,null,"Overall Score Range",null,"Rating"]
[null,null,"≥ 92",null,"A Supplier"]
[null,null,"≥ 86",null,"AB Supplier"]
[null,null,"≥ 75",null,"B Supplier"]
[null,null,"< 75",null,"C Supplier"]
[]
[null,"Overall Performance",null,null,null,{"$f":"SUM(G16:G22)/SUM(F16:F22)","v":0}]
[]
[]
[null,"Suplier Grade",null,null,null,{"$f":"IF(AND(F31>=90%,F31<=100%),\"A Supplier\",IF(AND(F31>=70%,F31<90%),\"AB Supplier\",IF(AND(F31>=50%,F31<70%),\"B Supplier\",IF(F31<50%,\"C Supplier\",\"\"))))","v":"C Supplier"}]
[]
[]
[]
[]
[]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[null,"Sourcing Buyer Approval"]
[null,"Name:",null,null,null,null,null,null,null,null,"Approve",null,"Reject"]
[null,"Signature:",null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Supplier Development Approval"]
[null,"Name:",null,null,null,null,null,null,null,null,"Approve",null,"Reject"]
[null,"Signature:",null,null,null,null,null,null,null,null,"Date:"]