{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["notes","Allegion Assesment Instructions","Scoring"," OSA Questions","Score Sheet","RAIL FOR YELLOW OR RED","Revision record","Photos (optional)"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"notes","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Questions in Grey boxes are repeats in each area and should be rated in each area audited"]
[null,null,"Notes column is for added data for the question and explanations as needed"]
[null,null,"if Procedure is Y, then it is a requirement. If they do the task but don’t have a formal document it is an automatic 3 or lower"]
[null,null,"C and M denote critical and maturity questions"]
[null,null,"primary commodity is new on first page and is a drop down"]

{"sheet":"Allegion Assesment Instructions","index":1,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,1,26,8],[29,1,29,8],[31,1,31,8],[21,2,21,4],[21,5,21,6],[21,7,21,8],[22,2,22,4],[22,5,22,6],[22,7,22,8],[19,2,19,4],[19,5,19,6],[19,7,19,8],[20,2,20,4],[20,5,20,6],[20,7,20,8],[17,2,17,4],[2,1,3,8],[5,1,6,1],[5,2,6,5],[8,1,9,1],[8,2,9,5],[10,7,10,8],[11,2,11,5],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[13,7,13,8]]}
[null,null,null,null,null,null,null,null,null,"a"]
[]
[null,"On-Site Assessment Cover Page"]
[]
[null,null,null,null,null,null,null,"Rev. 3.1","December 18, 2017"]
[null,"Supplier Name:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Commodity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEARINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASTINGS - DIE"]
[null,"Location:  ",null,null,null,null,null,"Overall Rating","MIN Score",null,null,null,null,null,null,"CASTINGS - INVESTMENT"]
[null,null,null,null,null,null,null,{"$f":"' OSA Questions'!T9","v":0},{"$f":"MIN(' OSA Questions'!T4:T8)","v":0},null,null,null,null,null,null,"CASTINGS - SAND"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H10>=0.7,I10>2),\"PASS\",IF(H10>=0.45,\"CONDITIONAL\",IF(H10<0.45,\"FAIL\",\"\")))","v":"FAIL"},null,null,null,null,null,null,null,"ELECTRONICS"]
[null,"Allegion on-site auditor:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"EXTRUSIONS"]
[null,null,null,null,null,null,null,"Primary Commodity",null,null,null,null,null,null,null,"FASTENERS"]
[null,null,"Critical Dates",null,null,null,null,null,null,null,null,null,null,null,null,"FINISHING/POLISHING"]
[null," Supplier Profile Date Received:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"FORGINGS"]
[null," On-Site Survey Date:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"GASKETS/SEALS/O-RINGS"]
[null," Corrective Action Plan Due:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERCOMPANY"]
[null," On-site Verification Date:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"NON-FERROUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON-FERROUS"]
[null,"Others in attendance:  ","Name",null,null,"Title",null,"Email",null,null,null,null,null,null,null,"OEM - CLOSERS"]
[null,"(insert lines as required)  "," ",null,null," ",null," ",null,null,null,null,null,null,null,"OEM - CYLINDERS"]
[null,null," ",null,null," ",null," ",null,null,null,null,null,null,null,"OEM - HARDWARE"]
[null,null," ",null,null," ",null," ",null,null,null,null,null,null,null,"OEM - KRYPTONITE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OEM - LOCKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PACKAGING"]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PLASTICS"]
[null,"The On-Site Supplier Assessment is divided into multiple elements  where the supplier is evaluated for compliance to basic Quality System Standards based on ISO 9001:2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"POWDERED METALS"]
[null,"The questions are two categories that are defined as critical in nature and the second a measure of the maturity of the supplier.",null,null,null,null,null,null,null,null,null,null,null,null,null,"ROLL FORMING"]
[null,"The questions are designed to follow the manufacturing process and lead into the support functions.",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCREW MACHINE"]
[null,"Please review all comments within each element for further clarification of field expectations.  All comments are indicated by a red triangle located in the upper right hand corner of a field.  You can review a comment by placing the mouse pointer over the cell that requires information. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"SPRINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPRINGS"]
[null,"Suppliers found deficient on critical questions will be allowed to develop an improvement plan and submit to Allegion Supplier Quality for review and approval.  This plan should be concise and address the core element(s) found to be lacking.  It must include milestones and plan for revaluation by Allegion.",null,null,null,null,null,null,null,null,null,null,null,null,null,"STAMPINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEEL"]

{"sheet":"Scoring","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,3,1]]}
[]
[]
[null," EVALUATION SCORING CRITERIA"]
[null,null,"SCORE"]
[null,"Supplier is not familiar with the requirements of the core competency.",0]
[]
[null,"Supplier is knowledgeable of the requirements of the core competency, but has no evidence of source documentation, planning, or implementation",1]
[]
[null,"Supplier is knowledgeable of the requirements, and skilled in the use and implementation of the core competency.  Supplier implementation of the core competency is less than 50% and planning documentation exists for complete (100%) implementation.",2]
[]
[null,"Supplier is knowledgeable of the requirements, and skilled in the use and implementation of the core competency.  Supplier implementation of the core competency is greater than 50% but less than 75%, and planning documentation exists for complete (100%) implementation.",3]
[]
[null,"Supplier is knowledgeable of the requirements, and skilled in the use and implementation of the core competency.  Supplier implementation of the core competency is greater than 75% but less than 100%, and planning documentation exists for continuous improvement.",4]
[]
[null,"Supplier is knowledgeable of the requirements, and proficient in the use and implementation of the core competency.  Supplier implementation of the core competency in typical areas of focus is 100%. Supplier demonstrates innovative use and benefit of the core competency beyond the typical area of focus.",5]
[]
[null,"If the item is not applicable or not audited at the time, please enter NA in the check box. This will re-set the parameters for the audit score and will not effect the result. \n","NA"]
[]
[null,"All Scores are available via the drop down menu, do not overwrite these options"]

{"sheet":" OSA Questions","index":3,"n_rows":135,"n_cols":23,"rows_kept":135,"cut":false,"hidden":false,"merged":[[122,2,123,2],[127,6,127,10],[122,6,122,10],[123,6,123,10],[123,3,123,5],[122,3,122,5],[124,6,124,10],[0,1,0,2],[112,0,118,0],[1,17,1,19],[49,0,60,0],[80,0,89,0],[90,0,100,0],[101,0,111,0],[61,0,79,0],[131,0,134,0],[1,20,1,22],[1,16,2,16],[1,0,16,0],[17,0,43,0],[44,0,48,0],[124,2,125,2],[126,2,127,2],[120,4,120,10],[120,0,128,0],[124,3,124,5],[126,3,126,5],[126,6,126,10],[125,6,125,10],[125,3,125,5],[127,3,127,5],[128,4,128,10],[131,4,131,10],[132,4,132,10],[133,4,133,10],[134,4,134,10]]}
["Process or \nFunction","Question",null,"Procedure Required?","Notes","Score","Quality Management Systems","Commercial Systems","Materials Systems","Engineering Systems","Leadership"]
["Receiving Materials","1","Does a formal receiving process exist?","Y",null,"N/A","C",null,null,null,null,null,"Scores",null,null,null,null,"Critical Score",null,null,"Maturity Score"]
[null,"2","Are purchase orders matched to material received?",null,null,"N/A",null,null,"C",null,null,null,0,null,null,null,null,"Act","Pos","Min","Act","Pos","Min"]
[null,"3","Are materials kept in acceptable conditions?",null,null,"N/A",null,null,"C",null,null,null,1,null,null,null,"Quality Management Systems",{"$f":"SUMIF(G2:G119,\"C\",F2:F119)","v":0},{"$f":"SUM(IF(G2:G119=\"C\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F2,F5,F9,F10,F19,F21,F24,F30,F39,F40,F45,F49,F52,F62,F68)","v":0},{"$f":"SUMIF(G2:G119,\"M\",F2:F119)","v":0},{"$f":"SUM(IF(G2:G119=\"M\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F6,F7,F8,F11,F12,F20,F22,F23,F29,F36,F37,F46,F55,F63,F65,F66,F67,F71,F72,F73,F76,F77,F78)","v":0}]
[null,"4","Are products identified as acceptable for use with labels or tags?","Y",null,"N/A","C",null,null,null,null,null,2,null,null,null,"Commercial Systems",{"$f":"SUMIF(H2:H119,\"C\",F2:F119)","v":0},{"$f":"SUM(IF(H2:H119=\"C\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F114)","v":0},{"$f":"SUMIF(H2:H119,\"M\",F2:F119)","v":0},{"$f":"SUM(IF(H2:H119=\"M\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F25,F33,F117,F118)","v":0}]
[null,"5","Are blue print revision levels verified against PO and shipper?",null,null,"N/A","M",null,null,null,null,null,3,null,null,null,"Materials Systems",{"$f":"SUMIF(I2:I119,\"C\",F2:F119)","v":0},{"$f":"SUM(IF(I2:I119=\"C\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F3,F4,F18,F26,F27,F50,F51,F103,F105,F109)","v":0},{"$f":"SUMIF(I2:I119,\"M\",F2:F119)","v":0},{"$f":"SUM(IF(I2:I119=\"M\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F13,F31,F32,F34,F48,F53,F54,F102,F104,F106,F107,F108,F110,F111,F112)","v":0}]
[null,"6","Is receiving inspection performed?",null,null,"N/A","M",null,null,null,null,null,4,null,null,null,"Engineering Systems",{"$f":"SUMIF(J2:J119,\"C\",F2:F119)","v":0},{"$f":"SUM(IF(J2:J119=\"C\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F69,F84,F85)","v":0},{"$f":"SUMIF(J2:J119,\"M\",F2:F119)","v":0},{"$f":"SUM(IF(J2:J119=\"M\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F28,F86,F88)","v":0}]
[null,"7","If yes, is skip lot or other methods used ?","Y","Document the method","N/A","M",null,null,null,null,null,5,null,null,null,"Leadership",{"$f":"SUMIF(K2:K119,\"C\",F2:F119)","v":0},{"$f":"SUM(IF(K2:K119=\"C\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F15,F38,F42,F56,F57,F59,F96,F97,F113)","v":0},{"$f":"SUMIF(K2:K119,\"M\",F2:F119)","v":0},{"$f":"SUM(IF(K2:K119=\"M\",IF(ISNUMBER(F2:F119),1,0),0))*5","v":0},{"$f":"MIN(F14,F16,F17,F35,F41,F43,F44,F58,F60,F61,F64,F70,F79,F80,F81,F82,F83,F87,F89,F90,F91,F94,F95,F98,F99,F100,F101,F115,F116,F119)","v":0}]
[null,"8","Do gages used at R.I. have calibration identified?",null,"Record a gage ID for system confirmation","N/A","C",null,null,null,null,null,"N/A",null,null,null,null,{"$f":"SUM(R4:R8)","v":0},{"$f":"S4+S5+S6+S7+S8","v":0},{"$f":"IFERROR(R9/S9,0)","v":0},{"$f":"SUM(U4:U8)","v":0},{"$f":"SUM(V4:V8)","v":0},{"$f":"IFERROR(U9/V9,0)","v":0}]
[null,"9","Are records of the inspection kept?",null,"Do results of inspections drive the skip lot process?","N/A","C"]
[null,"10","Do prints on file at R.I. match current revision levels-internal change control","Y",null,"N/A","M"]
[null,"11","Is traceability from source maintained?",null,null,"N/A","M"]
[null,"12","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",null,null,"N/A",null,null,"M"]
[null,"13","Obtain name and ID for random operator and job being performed to verify with Training records later.",null,null,"N/A",null,null,null,null,"M"]
[null,"14","EHS-any PPE needed? Are exits identified? Fire extinguishers?",null,"Is PPE required and is it used Consistently?","N/A",null,null,null,null,"C"]
[null,"15","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M"]
[null,"16","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["Work In Process","17","Are materials kept in acceptable conditions?",null,null,"N/A",null,null,"C"]
[null,"18","Are products identified as acceptable for use with labels or tags?",null,null,"N/A","C"]
[null,"19","Do work instructions exist at each step in the process?",null,"Are they tied to Control Plans?","N/A","M"]
[null,"20","Use the work instruction to verify gages used, frequency and steps of the process.",null,null,"N/A","C"]
[null,"21","Does a control plan exist? Does it match actual practice?",null,"Is a Reaction plan identified?","N/A","M"]
[null,"22","Have all special or critical characteristics been identified on the Process Control Plan and is SPC used to control process?",null,null,"N/A","M"]
[null,"23","Are gages in calibration?",null,"Record a gage ID for system confirmation","N/A","C"]
[null,"24","Are quick changeover practices being utilized and measured? If applicable.",null,null,"N/A",null,"M"]
[null,"25","Is the status of the parts obvious, i.e. scrap, rework or acceptable? ",null,null,"N/A",null,null,"C"]
[null,"26","Is scrap and rework segregated from WIP? Non Conforming and questionable product segregated?",null,null,"N/A",null,null,"C"]
[null,"27","Are poke yokes or error-proofing evident",null,null,"N/A",null,null,null,"M"]
[null,"28","Is there a system to verify the proper performance of error-proofing systems (Use of masters, rabbits or golden samples)?","Y",null,"N/A","M"]
[null,"29","Are master parts in use and maintained for all critical appearance items?  N/A for new suppliers.",null,null,"N/A","C"]
[null,"30","is one piece flow used? If not what type is used and why",null,null,"N/A",null,null,"M"]
[null,"31","Have current and potential bottlenecks in the manufacturing process been identified with a contingency plan to improve material flow?",null,null,"N/A",null,null,"M"]
[null,"32","Does the supplier have an active Continuous Improvement process to optimize material, throughput labor, and overhead?",null,null,"N/A",null,"M"]
[null,"33","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",null,null,"N/A",null,null,"M"]
[null,"34","5S status of work areas. Is 5S evident",null,null,"N/A",null,null,null,null,"M"]
[null,"35","Is inspection done in process by operators or offline by QA?",null,null,"N/A","M"]
[null,"36","Are SPC or other statistical methods used in process?",null,null,"N/A","M"]
[null,"37","Are the lighting and environmental controls adequate?",null,null,"N/A",null,null,null,null,"C"]
[null,"38","Are products inspected at end of line, at a minimum?","Y",null,"N/A","C"]
[null,"39","Is Allegion owned tooling identified and properly maintained.","Y",null,"N/A","C"]
[null,"40","Obtain name and ID for random operator and job being performed to verify with Training records later.",null,null,"N/A",null,null,null,null,"M"]
[null,"41","EHS-any PPE needed? Are exits identified? Fire extinguishers?",null,"Is PPE required and is it used Consistently?","N/A",null,null,null,null,"C"]
[null,"42","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M"]
[null,"43","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["External Processes","44","Does the vendor utilize sub suppliers for Allegion products? Such as heat treat or finishing.",null,null,"N/A","C"]
[null,"45","Are the sub suppliers \"certified\" by the supplier?","Y",null,"N/A","M"]
[null,"46","What lab data or process data is received? How is it audited and verified?",null,null,"N/A","M"]
[null,"47","Are parts traceable thru the sub suppliers processes?",null,null,"N/A",null,null,"M"]
[null,"48","Are parts inspected upon return? Are records kept of the inspection?",null,null,"N/A","C"]
["Final Inspection and shipping ","49","How are parts verified as ready for shipment to Allegion?","Y",null,"N/A",null,null,"C"]
[null,"50","How are parts identified as ready for shipment to Allegion?",null,null,"N/A",null,null,"C"]
[null,"51","There shall be a process/method in place to ensure all parts are labeled accurately, at the appropriate time, applied correctly, and identified easily.",null,null,"N/A","C"]
[null,"52","Is ASN or other EDI notice given to Allegion upon shipment?",null,null,"N/A",null,null,"M"]
[null,"53","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",null,null,"N/A",null,null,"M"]
[null,"54","The supplier shall have procedure to ensure packaging is approved by Allegion as part of PPAP.","Y",null,"N/A","M"]
[null,"55","Workers are protected from exposure to significant safety or health hazards within the facility, including offices, operational areas, and company provided housing? Company requires PPE. Instructions are posted and training is required to avoid potential risks. ",null,null,"N/A",null,null,null,null,"C"]
[null,"56","Supplier maintains appropriate fire detection and suppression equipment as well as adequate exits?",null,null,"N/A",null,null,null,null,"C"]
[null,"57","Obtain name and ID for random operator and job being performed to verify with Training records later.",null,null,"N/A",null,null,null,null,"M"]
[null,"58","EHS-any PPE needed? Are exits identified? Fire extinguishers?",null,"Is PPE required and is it used Consistently?","N/A",null,null,null,null,"C"]
[null,"59","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M"]
[null,"60","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["Quality Management","61","Is there a Quality Management system in place to manage all product data and control documentation? (i.e. drawings, FMEA, material specifications, test specifications, UL certifications, etc.) for a 5 rating ISO or TS certification is required","Y",null,"N/A","C"]
[null,"62","If not certified does supplier have an internal audit system?",null,null,"N/A","M"]
[null,"63","Does the supplier have systems in place that support customer defined Metrics? Are these metrics reviewed by upper management? Is there evidence about strategic planning to improve results as needed?",null,null,"N/A",null,null,null,null,"M"]
[null,"64","Does the supplier understand each of the elements required in an Advanced Product Quality Plan (APQP). Are these elements identified and tracked to completion in a Timing Chart? Can the supplier demonstrate the use of Process Flow Chart, FMEA, Control Plans? Are they tied numerically to process system document(s)?",null,null,"N/A","M"]
[null,"65","A Production Part Approval Process is in use and capable of meeting customer's expectations. Allegion 's recognized format, or equivalent, for part submission process is utilized throughout the organization? ",null,null,"N/A","M"]
[null,"66","Does the supplier have an established launch containment plan? Do they understand and can comply if required?",null,null,"N/A","M"]
[null,"67","Does the supplier have approved Part Submission Warrants (PPAP submissions) to the latest print revision level? N/A for new suppliers.",null,null,"N/A","C"]
[null,"68","Does the supplier have the latest print revisions on file? Are CC/SC  selected if applicable? Include a list of Part drawings and revision levels in Supplier profile. N/A for new suppliers.","Y",null,"N/A",null,null,null,"C"]
[null,"69","Does the supplier have a Quality Improvement Plan?",null,null,"N/A",null,null,null,null,"M"]
[null,"70","Does the supplier identify, categorize, and prioritize problems. Does the supplier adapt the proper methodology to the type of problem, and select the appropriate problem solving tools?",null,null,"N/A","M"]
[null,"71","Does the supplier have a process / procedure in place that isolates the effects of known problems from the customer until permanent corrective action is implemented? Is there a process for the collection and utilization of data generated from the containment process?",null,null,"N/A","M"]
[null,"72","Are customer complaints properly documented? Is the implementation of corrective action on track, to date? Is there a formal process to close customer complaints? Are PFMEA, Control Plans, etc., updated as a result of a customer complaint?",null,null,"N/A","M"]
[null,"73","Does the supplier have knowledge of GD&T to the 2009 Standard? Including the ability to measure parts to the standard?",null,null,"N/A","M"]
[null,"74","Does the supplier have CMM capability internally for part measurement? 3D scanning internally or at a validated 3rd party?",null,null,"N/A","M"]
[null,"75","Is there a Continuous Improvement process around Quality for internal and external defects?",null,null,"N/A","M"]
[null,"76","Does the supplier utilize statistical methods to identify, contain, and resolve issues.",null,null,"N/A","M"]
[null,"77","Does the supplier have an active internal process to resolve warranty issues?  N/A if product provided has no warranty",null,null,"N/A","M"]
[null,"78","Does the supplier have a training matrix for all quality employees listing their core competencies?",null,null,"N/A",null,null,null,null,"M"]
[null,"79","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["Engineering Management","80","Does the supplier have an active Continuous Improvement process to optimize material, throughput labor, and overhead?",null,null,"N/A",null,null,null,null,"M"]
[null,"81","Is standardized work the method used to document work processes to improve quality, efficiency, and safety?  ",null,null,"N/A",null,null,null,null,"M"]
[null,"82","Does the supplier participate in cost reduction programs with the Customer? Does the supplier have cost reduction targets established and track performance to plan?",null,null,"N/A",null,null,null,null,"M"]
[null,"83","Does a formal engineering change/sign-off review shall exist to ensure that all changes which affect the materials planning and Logistics process are planned, performed and communicated in a synchronized manner, (e.g., process sign-off sheet with Bill of Material (BOM) review, routing changes, effective dates, notification to suppliers, scheduling, shipping). ","Y",null,"N/A",null,null,null,"C"]
[null,"84","Does the supplier understand applicable industry standards including but not limited to:\nUL, BHMA, CE and AIAG Standards, Control standards, specifications, and incorporate this information into the product design? If design responsible. Max score of 3 if they rely on Allegion to provide standards ",null,null,"N/A",null,null,null,"C"]
[null,"85","Does the supplier have materials and product testing capabilities to assure ongoing conformance to material, legal, and performance specifications?",null,null,"N/A",null,null,null,"M"]
[null,"86","Does the supplier have a process to develop and implement product innovation?",null,null,"N/A",null,null,null,null,"M"]
[null,"87","Does the supplier have a process to develop prototypes?",null,null,"N/A",null,null,null,"M"]
[null,"88","Does the supplier have a training matrix for all engineering employees listing their core competencies?",null,null,"N/A",null,null,null,null,"M"]
[null,"89","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["Human Resources","90","Does the supplier have a proactive health and safety plan?  Do they comply with local laws and regulations?",null,null,"N/A",null,null,null,null,"M"]
[null,"91","Are policies in place that ensure host country legal wages are met or aligned with prevailing industry wage where there are no requirements?",null,null,"N/A",null,null,null,null,"C"]
[null,"92","Are policies in place that prohibit engagement of forced labor, human trafficking, sex acts and withholding of employee identification or immigration documents?",null,null,"N/A",null,null,null,null,"C"]
[null,"93","Sustainability. \nIs there a \"Reduce-Reuse-Recycle\" philosophy/program in place? Is sustainability included in the KPI's and is there a strategy for continuous improvement? ",null,null,"N/A",null,null,null,null,"M"]
[null,"94","Are Environmental, Health and Safety audits conducted annually by internal personnel?  Is there an EHS policy displayed?",null,null,"N/A",null,null,null,null,"M"]
[null,"95","Are the workers are protected from exposure to significant safety or health hazards within the facility, including offices, operational areas, and company provided housing? Company requires PPE. Instructions are posted and training is required to avoid potential risks. ",null,null,"N/A",null,null,null,null,"C"]
[null,"96","Supplier maintains appropriate fire detection and suppression equipment as well as adequate exits?",null,null,"N/A",null,null,null,null,"C"]
[null,"97","Verify with Training records for employees observed on the floor",null,null,"N/A",null,null,null,null,"M"]
[null,"98","Does the supplier have a staff resource plan?",null,null,"N/A",null,null,null,null,"M"]
[null,"99","Does the supplier have a training matrix for all production operators listing their core competencies?",null,null,"N/A",null,null,null,null,"M"]
[null,"100","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
["Material Control and Planning","101","Does the supplier have an understanding of Kanban?  Is Kanban utilized at this facility?",null,null,"N/A",null,null,"M"]
[null,"102","Does the supplier utilize an electronic MRP or ERP system to manage delivery to Allegion and control inventory",null,null,"N/A",null,null,"M"]
[null,"103","The supplier shall have a process to ensure that any potential problems or deviations from the production plan that could impact the customer operation are communicated internally and to the customer as soon as they are identified.",null,null,"N/A",null,null,"M"]
[null,"104","There are systems in place to ensure accurate stock balance of all inventory types (e.g., finished goods, scrap). These stock balance figures are accurately updated in a timely manner.",null,null,"N/A",null,null,"C"]
[null,"105","A set of parameters, (e.g., transport time, lead times, inventory levels, packaging), and internal production requirements, (e.g., supplier constraints, scrap rates set-up times), are integrated into the production planning system automatically and updated at planned intervals.",null,null,"N/A",null,null,"M"]
[null,"106","Customer schedule information is automatically integrated into the supplier's releasing system (Use of a Material Requirements Planning System - MRP) to avoid manual transference of data. Supplier is using a formal (ODETTE/AIAG) electronic communication standard (EDI) or any other web based electronic standard. ",null,null,"N/A",null,null,"M"]
[null,"107","Documented procedures for all customer interface aspects of the Materials Planning and Logistics process exist (e.g., customer order planning, stock control, packaging procedures and transport management). ","Y",null,"N/A",null,null,"M"]
[null,"108","Supplier considers all factors influencing the need for inventory buffers, (e.g., demand variability, process capabilities, internal transport and warehousing situation, customer safety stock requirements, different industrial calendars, etc...). ",null,null,"N/A",null,null,"C"]
[null,"109","There is 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. ",null,null,"N/A",null,null,"M"]
[null,"110","Does the supplier have defined performance measurable for its suppliers? Does the supplier have a process to evaluate and develop their supply base? ",null,null,"N/A",null,null,"M"]
[null,"111","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,"M"]
["Leadership and Compliance","112","Does supplier agree to abide by  Allegion Business Partner Code Of Conduct, as listed on Supplier web portal, 0 or 5 are only scores possible",null,null,"N/A",null,null,null,null,"C"]
[null,"113","Waste Water Discharges, Green House Gas Emissions and site waste generation is managed according to applicable regulations and to minimize impacts to the environment and community? Supplier has record of all environmental impacts and has defined action plans to reduce environmental impact (Including non-recyclable materials).",null,null,"N/A",null,"C"]
[null,"114","Is Preventative Maintenance (PM) evident in the manufacturing process? Are Preventive Maintenance routines completed according to the schedule? Is downtime monitored and are there improvement strategies in place? Does supplier have the minimum requirements in place to execute corrective maintenance?",null,null,"N/A",null,null,null,null,"M"]
[null,"115","Does the strategic plan include sales and growth plan? Does the supplier’s strategic plan drive the operational plan? Is the supplier's strategic plan and operational plan understood and integrated by its operating teams?",null,null,"N/A",null,null,null,null,"M"]
[null,"116","Does the supplier visit customer facilities on an established schedule (Pro-actively)?",null,null,"N/A",null,"M"]
[null,"117","Is there evidence of a Customer Service System?",null,null,"N/A",null,"M"]
[null,"118","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,null,null,"M"]
[]
["Supplier Development",null,"Does the supplier engage in verification activities of their supplier base to identify, assess and manage risk to human trafficking/forced labor and material regulatory compliance?",null,"Comments:"]
[null,null,"Please identify who is responsible for understanding and managing compliance to the following programs:"]
[null,null,"        ∙REACH/RoHS/Prop 65"]
[null,null,null,"Name & Title",null,null,"Email"]
[null,null,"        ∙Conflict Materials"]
[null,null,null,"Name & Title",null,null,"Email"]
[null,null,"        ∙Anti-Human trafficking/Social Responsibility"]
[null,null,null,"Name & Title",null,null,"Email"]
[null,null,"Can the suppler provide a BIP (Business Interruption Plan) that describes their ability to recover from an event - either  naturally caused (e.g. earthquake) or man-made (e.g. explosion) - that causes a lengthy disruption in production?",null,"Comments:"]
[]
[]
["Trade Compliance (Not Applicable for North American Vendors)",null,"Can the supplier confirm that a high security seal is affixed to all loaded containers and trailers? \n\nSeal must meet or exceed the current PAS ISO 17712 standard for high security seals.",null,"Comments:"]
[null,null,"Can the supplier confirm that all containers and trailers under foreign manufacturer control are stored in a secure area to prevent unauthorized access and/or manipulation?\n\nProcedures must be in place for reporting and neutralizing unauthorized entry into containers/trailers or container/trailer storage areas.",null,"Comments:"]
[null,null,"Can the supplier confirm that an employee identification system is in place for positive identification and access control purposes?\n\nEmployees should only be given access to those secure areas needed for the performance of their duties. Company management or security personnel must adequately control the issuance and removal of employee, visitor and vendor identification badges. Procedures for the issuance, removal and changing of access devices (e.g. keys, key cards, etc.) must be documented.",null,"Comments:"]
[null,null,"Can the supplier confirm gates through which vehicles and/or personnel enter or exit are manned and/or monitored? \n\nThe number of gates should be kept to the minimum necessary for proper access and safety.",null,"Comments:"]

{"sheet":"Score Sheet","index":4,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Allegion Audit Scores",null,null,null,null,null,null,null,"Critical Score","Maturity Score"]
[null,"A.","Quality Management Systems",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R4/' OSA Questions'!S4,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U4/' OSA Questions'!V4,0)","v":0}]
[null,"B.","Commercial Systems",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R5/' OSA Questions'!S5,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U5/' OSA Questions'!V5,0)","v":0}]
[null,"C.","Materials Systems",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R6/' OSA Questions'!S6,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U6/' OSA Questions'!V6,0)","v":0}]
[null,"D.","Engineering Systems",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R7/' OSA Questions'!S7,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U7/' OSA Questions'!V7,0)","v":0}]
[null,"E.","Leadership",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R8/' OSA Questions'!S8,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U8/' OSA Questions'!V8,0)","v":0}]
[null,null,"OVERALL LOWEST SCORE",null,null,null,null,null,null,{"$f":"IFERROR(' OSA Questions'!R9/' OSA Questions'!S9,0)","v":0},{"$f":"IFERROR(' OSA Questions'!U9/' OSA Questions'!V9,0)","v":0}]

{"sheet":"RAIL FOR YELLOW OR RED","index":5,"n_rows":123,"n_cols":12,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,5,1,5]]}
[null,null,null,null,null,"RAIL"]
[]
[null,null,null,null,null,"Rolling Action Item List"]
[null,null,null,null,null,null,null,null,null,"Revision Date: ",null,{"$f":"'Allegion Assesment Instructions'!I5","v":"December 18, 2017"}]
["Item #","Functional Area","Question","Score","Maturity","Action","Date Assigned","Responsible Person","Date Due","Date Completed","Status","Status & Comments"]
[1,"Receiving","Does a formal receiving process exist?",{"$f":"' OSA Questions'!$F2","v":"N/A"},{"$f":"' OSA Questions'!$G2","v":"C"},null,null,null,null,null,"G"]
[2,"Receiving","Are purchase orders matched to material received?",{"$f":"' OSA Questions'!$F3","v":"N/A"},{"$f":"' OSA Questions'!I3","v":"C"},null,null,null,null,null,"G"]
[3,"Receiving","Are materials kept in acceptable conditions?",{"$f":"' OSA Questions'!$F4","v":"N/A"},{"$f":"' OSA Questions'!I4","v":"C"},null,null,null,null,null,"G"]
[4,"Receiving","Are products identified as acceptable for use with labels or tags?",{"$f":"' OSA Questions'!$F5","v":"N/A"},{"$f":"' OSA Questions'!$G5","v":"C"},null,null,null,null,null,"G"]
[5,"Receiving","Are blue print revision levels verified against PO and shipper?",{"$f":"' OSA Questions'!$F6","v":"N/A"},{"$f":"' OSA Questions'!$G6","v":"M"},null,null,null,null,null,"G"]
[6,"Receiving","Is receiving inspection performed?",{"$f":"' OSA Questions'!$F7","v":"N/A"},{"$f":"' OSA Questions'!$G7","v":"M"},null,null,null,null,null,"G"]
[7,"Receiving","If yes, is skip lot or other methods used ?",{"$f":"' OSA Questions'!$F8","v":"N/A"},{"$f":"' OSA Questions'!$G8","v":"M"},null,null,null,null,null,"G"]
[8,"Receiving","Do gages used at R.I. have calibration identified?",{"$f":"' OSA Questions'!$F9","v":"N/A"},{"$f":"' OSA Questions'!$G9","v":"C"},null,null,null,null,null,"G"]
[9,"Receiving","Are records of the inspection kept?",{"$f":"' OSA Questions'!$F10","v":"N/A"},{"$f":"' OSA Questions'!$G10","v":"C"},null,null,null,null,null,"G"]
[10,"Receiving","Do prints on file at R.I. match current revision levels-internal change control",{"$f":"' OSA Questions'!$F11","v":"N/A"},{"$f":"' OSA Questions'!$G11","v":"M"},null,null,null,null,null,"G"]
[11,"Receiving","Is traceability from source maintained?",{"$f":"' OSA Questions'!$F12","v":"N/A"},{"$f":"' OSA Questions'!$G12","v":"M"},null,null,null,null,null,"G"]
[12,"Receiving","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",{"$f":"' OSA Questions'!$F13","v":"N/A"},{"$f":"' OSA Questions'!$I$13","v":"M"},null,null,null,null,null,"G"]
[13,"Receiving","Obtain name and ID for random operator and job being performed to verify with Training records later.",{"$f":"' OSA Questions'!$F14","v":"N/A"},{"$f":"' OSA Questions'!K14","v":"M"},null,null,null,null,null,"G"]
[14,"Receiving","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"' OSA Questions'!$F15","v":"N/A"},{"$f":"' OSA Questions'!K15","v":"C"},null,null,null,null,null,"G"]
[15,"Receiving","Is there a daily start up routine?",{"$f":"' OSA Questions'!$F16","v":"N/A"},{"$f":"' OSA Questions'!K16","v":"M"},null,null,null,null,null,"G"]
[16,"Receiving","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F17","v":"N/A"},{"$f":"' OSA Questions'!K17","v":"M"},null,null,null,null,null,"G"]
[17,"Work in Process","Are materials kept in acceptable conditions?",{"$f":"' OSA Questions'!$F18","v":"N/A"},{"$f":"' OSA Questions'!$I$18","v":"C"},null,null,null,null,null,"G"]
[18,"Work in Process","Are products identified as acceptable for use with labels or tags?",{"$f":"' OSA Questions'!$F19","v":"N/A"},{"$f":"' OSA Questions'!$G19","v":"C"},null,null,null,null,null,"G"]
[19,"Work in Process","Do work instructions exist at each step in the process?",{"$f":"' OSA Questions'!$F20","v":"N/A"},{"$f":"' OSA Questions'!$G20","v":"M"},null,null,null,null,null,"G"]
[20,"Work in Process","Use the work instruction to verify gages used, frequency and steps of the process.",{"$f":"' OSA Questions'!$F21","v":"N/A"},{"$f":"' OSA Questions'!$G21","v":"C"},null,null,null,null,null,"G"]
[21,"Work in Process","Does a control plan exist? Does it match actual practice?",{"$f":"' OSA Questions'!$F22","v":"N/A"},{"$f":"' OSA Questions'!$G22","v":"M"},null,null,null,null,null,"G"]
[22,"Work in Process","Have all special or critical characteristics been identified on the Process Control Plan and is SPC used to control process?",{"$f":"' OSA Questions'!$F23","v":"N/A"},{"$f":"' OSA Questions'!$G23","v":"M"},null,null,null,null,null,"G"]
[23,"Work in Process","Are gages in calibration?",{"$f":"' OSA Questions'!$F24","v":"N/A"},{"$f":"' OSA Questions'!$G24","v":"C"},null,null,null,null,null,"G"]
[24,"Work in Process","Are quick changeover practices being utilized and measured? If applicable.",{"$f":"' OSA Questions'!$F25","v":"N/A"},{"$f":"' OSA Questions'!$H$25","v":"M"},null,null,null,null,null,"G"]
[25,"Work in Process","Is the status of the parts obvious, i.e. scrap, rework or acceptable? ",{"$f":"' OSA Questions'!$F26","v":"N/A"},{"$f":"' OSA Questions'!I26","v":"C"},null,null,null,null,null,"G"]
[26,"Work in Process","Is scrap and rework segregated from WIP? Non Conforming and questionable product segregated?",{"$f":"' OSA Questions'!$F27","v":"N/A"},{"$f":"' OSA Questions'!I27","v":"C"},null,null,null,null,null,"G"]
[27,"Work in Process","Are pokeayokes or error-proofing evident",{"$f":"' OSA Questions'!$F28","v":"N/A"},{"$f":"' OSA Questions'!$J$28","v":"M"},null,null,null,null,null,"G"]
[28,"Work in Process","Is there a system to verify the proper performance of error-proofing systems (Use of masters, rabbits or golden samples)?",{"$f":"' OSA Questions'!$F29","v":"N/A"},{"$f":"' OSA Questions'!$G29","v":"M"},null,null,null,null,null,"G"]
[29,"Work in Process","Are master parts in use and maintained for all critical appearance items?  N/A for new suppliers.",{"$f":"' OSA Questions'!$F30","v":"N/A"},{"$f":"' OSA Questions'!$G30","v":"C"},null,null,null,null,null,"G"]
[30,"Work in Process","is one piece flow used? If not what type is used and why",{"$f":"' OSA Questions'!$F31","v":"N/A"},{"$f":"' OSA Questions'!I31","v":"M"},null,null,null,null,null,"G"]
[31,"Work in Process","Have current and potential bottlenecks in the manufacturing process been identified with a contingency plan to improve material flow?",{"$f":"' OSA Questions'!$F32","v":"N/A"},{"$f":"' OSA Questions'!I32","v":"M"},null,null,null,null,null,"G"]
[32,"Work in Process","Does the supplier have an active Continuous Improvement process to optimize material, throughput labor, and overhead?",{"$f":"' OSA Questions'!$F33","v":"N/A"},{"$f":"' OSA Questions'!$H$33","v":"M"},null,null,null,null,null,"G"]
[33,"Work in Process","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",{"$f":"' OSA Questions'!$F34","v":"N/A"},{"$f":"' OSA Questions'!$I$34","v":"M"},null,null,null,null,null,"G"]
[34,"Work in Process","5S status of work areas. Is 5S evident",{"$f":"' OSA Questions'!$F35","v":"N/A"},{"$f":"' OSA Questions'!$K$35","v":"M"},null,null,null,null,null,"G"]
[35,"Work in Process","Is inspection done in process by operators or offline by QA?",{"$f":"' OSA Questions'!$F36","v":"N/A"},{"$f":"' OSA Questions'!$G36","v":"M"},null,null,null,null,null,"G"]
[36,"Work in Process","Are SPC or other statistical methods used in process?",{"$f":"' OSA Questions'!$F37","v":"N/A"},{"$f":"' OSA Questions'!$G37","v":"M"},null,null,null,null,null,"G"]
[37,"Work in Process","Are the lighting and environmental controls adequate?",{"$f":"' OSA Questions'!$F38","v":"N/A"},{"$f":"' OSA Questions'!$K$38","v":"C"},null,null,null,null,null,"G"]
[38,"Work in Process","Are products inspected at end of line, at a minimum?",{"$f":"' OSA Questions'!$F39","v":"N/A"},{"$f":"' OSA Questions'!$G39","v":"C"},null,null,null,null,null,"G"]
[39,"Work in Process","Is Allegion owned tooling identified and properly maintained.",{"$f":"' OSA Questions'!$F40","v":"N/A"},{"$f":"' OSA Questions'!$G40","v":"C"},null,null,null,null,null,"G"]
[40,"Work in Process","Obtain name and ID for random operator and job being performed to verify with Training records later.",{"$f":"' OSA Questions'!$F41","v":"N/A"},{"$f":"' OSA Questions'!K41","v":"M"},null,null,null,null,null,"G"]
[41,"Work in Process","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"' OSA Questions'!$F42","v":"N/A"},{"$f":"' OSA Questions'!K42","v":"C"},null,null,null,null,null,"G"]
[42,"Work in Process","Is there a daily start up routine?",{"$f":"' OSA Questions'!$F43","v":"N/A"},{"$f":"' OSA Questions'!K43","v":"M"},null,null,null,null,null,"G"]
[43,"Work in Process","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F44","v":"N/A"},{"$f":"' OSA Questions'!K44","v":"M"},null,null,null,null,null,"G"]
[44,"External Processes","Does the vendor utilize sub suppliers for Allegion products? Such as heat treat or finishing.",{"$f":"' OSA Questions'!$F45","v":"N/A"},{"$f":"' OSA Questions'!$G45","v":"C"},null,null,null,null,null,"G"]
[45,"External Processes","Are the sub suppliers \"certified\" by the supplier?",{"$f":"' OSA Questions'!$F46","v":"N/A"},{"$f":"' OSA Questions'!$G46","v":"M"},null,null,null,null,null,"G"]
[46,"External Processes","What lab data or process data is received? How is it audited and verified?",{"$f":"' OSA Questions'!$F47","v":"N/A"},{"$f":"' OSA Questions'!$G47","v":"M"},null,null,null,null,null,"G"]
[47,"External Processes","Are parts traceable thru the sub suppliers processes?",{"$f":"' OSA Questions'!$F48","v":"N/A"},{"$f":"' OSA Questions'!$I$48","v":"M"},null,null,null,null,null,"G"]
[48,"External Processes","Are parts inspected upon return? Are records kept of the inspection?",{"$f":"' OSA Questions'!$F49","v":"N/A"},{"$f":"' OSA Questions'!$G49","v":"C"},null,null,null,null,null,"G"]
[49,"Final Inspection & Shipping","How are parts verified as ready for shipment to Allegion?",{"$f":"' OSA Questions'!$F50","v":"N/A"},{"$f":"' OSA Questions'!$I$50","v":"C"},null,null,null,null,null,"G"]
[50,"Final Inspection & Shipping","How are parts identified as ready for shipment to Allegion?",{"$f":"' OSA Questions'!$F51","v":"N/A"},{"$f":"' OSA Questions'!$I$51","v":"C"},null,null,null,null,null,"G"]
[51,"Final Inspection & Shipping","There shall be a process/method in place to ensure all parts are labeled accurately, at the appropriate time, applied correctly, and identified easily.",{"$f":"' OSA Questions'!$F52","v":"N/A"},{"$f":"' OSA Questions'!$G52","v":"C"},null,null,null,null,null,"G"]
[52,"Final Inspection & Shipping","Is ASN or other EDI notice given to Allegion upon shipment?",{"$f":"' OSA Questions'!$F53","v":"N/A"},{"$f":"' OSA Questions'!I53","v":"M"},null,null,null,null,null,"G"]
[53,"Final Inspection & Shipping","The supplier's material flow is designed to support FIFO where applicable. Is it possible to trace back the traceability from finished product to raw material?",{"$f":"' OSA Questions'!$F54","v":"N/A"},{"$f":"' OSA Questions'!I54","v":"M"},null,null,null,null,null,"G"]
[54,"Final Inspection & Shipping","The supplier shall have procedure to ensure packaging is approved by Allegion as part of PPAP.",{"$f":"' OSA Questions'!$F55","v":"N/A"},{"$f":"' OSA Questions'!$G55","v":"M"},null,null,null,null,null,"G"]
[55,"Final Inspection & Shipping","Workers are protected from exposure to significant safety or health hazards within the facility, including offices, operational areas, and company provided housing? Company requires PPE. Instructions are posted and training is required to avoid potential risks. ",{"$f":"' OSA Questions'!$F56","v":"N/A"},{"$f":"' OSA Questions'!K56","v":"C"},null,null,null,null,null,"G"]
[56,"Final Inspection & Shipping","Supplier maintains appropriate fire detection and suppression equipment as well as adequate exits?",{"$f":"' OSA Questions'!$F57","v":"N/A"},{"$f":"' OSA Questions'!K57","v":"C"},null,null,null,null,null,"G"]
[57,"Final Inspection & Shipping","Obtain name and ID for random operator and job being performed to verify with Training records later.",{"$f":"' OSA Questions'!$F58","v":"N/A"},{"$f":"' OSA Questions'!K58","v":"M"},null,null,null,null,null,"G"]
[58,"Final Inspection & Shipping","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"' OSA Questions'!$F59","v":"N/A"},{"$f":"' OSA Questions'!K59","v":"C"},null,null,null,null,null,"G"]
[59,"Final Inspection & Shipping","Is there a daily start up routine?",{"$f":"' OSA Questions'!$F60","v":"N/A"},{"$f":"' OSA Questions'!K60","v":"M"},null,null,null,null,null,"G"]
[60,"Final Inspection & Shipping","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F61","v":"N/A"},{"$f":"' OSA Questions'!K61","v":"M"},null,null,null,null,null,"G"]
[61,"Quality Management","Is there a Quality Management system in place to manage all product data and control documentation? (i.e. drawings, FMEA, material specifications, test specifications, UL certifications, etc.) for a 5 rating ISO or TS certification is required",{"$f":"' OSA Questions'!$F62","v":"N/A"},{"$f":"' OSA Questions'!$G62","v":"C"},null,null,null,null,null,"G"]
[62,"Quality Management","If not certified does supplier have an internal audit system?",{"$f":"' OSA Questions'!$F63","v":"N/A"},{"$f":"' OSA Questions'!$G63","v":"M"},null,null,null,null,null,"G"]
[63,"Quality Management","Does the supplier have systems in place that support customer defined Metrics? Are these metrics reviewed by upper management? Is there evidence about strategic planning to improve results as needed?",{"$f":"' OSA Questions'!$F64","v":"N/A"},{"$f":"' OSA Questions'!$K$64","v":"M"},null,null,null,null,null,"G"]
[64,"Quality Management","Does the supplier understand each of the elements required in an Advanced Product Quality Plan (APQP). Are these elements identified and tracked to completion in a Timing Chart? Can the supplier demonstrate the use of Process Flow Chart, FMEA, Control Plans? Are they tied numerically to process system document(s)?",{"$f":"' OSA Questions'!$F65","v":"N/A"},{"$f":"' OSA Questions'!$G65","v":"M"},null,null,null,null,null,"G"]
[65,"Quality Management","A Production Part Approval Process is in use and capable of meeting customer's expectations. Allegion 's recognized format, or equivalent, for part submission process is utilized throughout the organization? ",{"$f":"' OSA Questions'!$F66","v":"N/A"},{"$f":"' OSA Questions'!$G66","v":"M"},null,null,null,null,null,"G"]
[66,"Quality Management","Does the supplier have an established launch containment plan? Do they understand and can comply if required?",{"$f":"' OSA Questions'!$F67","v":"N/A"},{"$f":"' OSA Questions'!$G67","v":"M"},null,null,null,null,null,"G"]
[67,"Quality Management","Does the supplier have approved Part Submission Warrants (PPAP submissions) to the latest print revision level? N/A for new suppliers.",{"$f":"' OSA Questions'!$F68","v":"N/A"},{"$f":"' OSA Questions'!$G68","v":"C"},null,null,null,null,null,"G"]
[68,"Quality Management","Does the supplier have the latest print revisions on file? Are CC/SC  selected if applicable? Include a list of Part drawings and revision levels in Supplier profile. N/A for new suppliers.",{"$f":"' OSA Questions'!$F69","v":"N/A"},{"$f":"' OSA Questions'!$J$69","v":"C"},null,null,null,null,null,"G"]
[69,"Quality Management","Does the supplier have a Quality Improvement Plan?",{"$f":"' OSA Questions'!$F70","v":"N/A"},{"$f":"' OSA Questions'!$K$70","v":"M"},null,null,null,null,null,"G"]
[70,"Quality Management","Does the supplier identify, categorize, and prioritize problems. Does the supplier adapt the proper methodology to the type of problem, and select the appropriate problem solving tools?",{"$f":"' OSA Questions'!$F71","v":"N/A"},{"$f":"' OSA Questions'!$G71","v":"M"},null,null,null,null,null,"G"]
[71,"Quality Management","Does the supplier have a process / procedure in place that isolates the effects of known problems from the customer until permanent corrective action is implemented? Is there a process for the collection and utilization of data generated from the containment process?",{"$f":"' OSA Questions'!$F72","v":"N/A"},{"$f":"' OSA Questions'!$G72","v":"M"},null,null,null,null,null,"G"]
[72,"Quality Management","Are customer complaints properly documented? Is the implementation of corrective action on track, to date? Is there a formal process to close customer complaints? Are PFMEA, Control Plans, etc., updated as a result of a customer complaint?",{"$f":"' OSA Questions'!$F73","v":"N/A"},{"$f":"' OSA Questions'!$G73","v":"M"},null,null,null,null,null,"G"]
[73,"Quality Management","Does the supplier have knowledge of GD&T to the 2009 Standard? Including the ability to measure parts to the standard?",{"$f":"' OSA Questions'!$F74","v":"N/A"},{"$f":"' OSA Questions'!$G74","v":"M"},null,null,null,null,null,"G"]
[74,"Quality Management","Does the supplier have CMM capability internally for part measurement? 3D scanning internally or at a validated 3rd party?",{"$f":"' OSA Questions'!$F75","v":"N/A"},{"$f":"' OSA Questions'!$G75","v":"M"},null,null,null,null,null,"G"]
[75,"Quality Management","Is there a Continuous Improvement process around Quality for internal and external defects?",{"$f":"' OSA Questions'!$F76","v":"N/A"},{"$f":"' OSA Questions'!$G76","v":"M"},null,null,null,null,null,"G"]
[76,"Quality Management","Does the supplier utilize statistical methods to identify, contain, and resolve issues.",{"$f":"' OSA Questions'!$F77","v":"N/A"},{"$f":"' OSA Questions'!$G77","v":"M"},null,null,null,null,null,"G"]
[77,"Quality Management","Does the supplier have an active internal process to resolve warranty issues?  N/A if product provided has no warranty",{"$f":"' OSA Questions'!$F78","v":"N/A"},{"$f":"' OSA Questions'!$G78","v":"M"},null,null,null,null,null,"G"]
[78,"Quality Management","Does the supplier have a training matrix for all quality employees listing their core competencies?",{"$f":"' OSA Questions'!$F79","v":"N/A"},{"$f":"' OSA Questions'!K79","v":"M"},null,null,null,null,null,"G"]
[79,"Quality Management","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F80","v":"N/A"},{"$f":"' OSA Questions'!K80","v":"M"},null,null,null,null,null,"G"]
[80,"Engineering Management","Does the supplier have an active Continuous Improvement process to optimize material, throughput labor, and overhead?",{"$f":"' OSA Questions'!$F81","v":"N/A"},{"$f":"' OSA Questions'!K81","v":"M"},null,null,null,null,null,"G"]
[81,"Engineering Management","Is standardized work the method used to document work processes to improve quality, efficiency, and safety?  ",{"$f":"' OSA Questions'!$F82","v":"N/A"},{"$f":"' OSA Questions'!K82","v":"M"},null,null,null,null,null,"G"]
[82,"Engineering Management","Does the supplier participate in cost reduction programs with the Customer? Does the supplier have cost reduction targets established and track performance to plan?",{"$f":"' OSA Questions'!$F83","v":"N/A"},{"$f":"' OSA Questions'!K83","v":"M"},null,null,null,null,null,"G"]
[83,"Engineering Management","Does a formal engineering change/sign-off review shall exist to ensure that all changes which affect the materials planning and Logistics process are planned, performed and communicated in a synchronized manner, (e.g., process sign-off sheet with Bill of Material (BOM) review, routing changes, effective dates, notification to suppliers, scheduling, shipping). ",{"$f":"' OSA Questions'!$F84","v":"N/A"},{"$f":"' OSA Questions'!J84","v":"C"},null,null,null,null,null,"G"]
[84,"Engineering Management","Does the supplier understand applicable industry standards including but not limited to:\nUL, BHMA, CE and AIAG Standards, Control standards, specifications, and incorporate this information into the product design? If design responsible. Max score of 3 if they rely on Allegion to provide standards ",{"$f":"' OSA Questions'!$F85","v":"N/A"},{"$f":"' OSA Questions'!J85","v":"C"},null,null,null,null,null,"G"]
[85,"Engineering Management","Does the supplier have materials and product testing capabilities to assure ongoing conformance to material, legal, and performance specifications?",{"$f":"' OSA Questions'!$F86","v":"N/A"},{"$f":"' OSA Questions'!J86","v":"M"},null,null,null,null,null,"G"]
[86,"Engineering Management","Does the supplier have a process to develop and implement product innovation?",{"$f":"' OSA Questions'!$F87","v":"N/A"},{"$f":"' OSA Questions'!$K$87","v":"M"},null,null,null,null,null,"G"]
[87,"Engineering Management","Does the supplier have a process to develop prototypes?",{"$f":"' OSA Questions'!$F88","v":"N/A"},{"$f":"' OSA Questions'!$J$88","v":"M"},null,null,null,null,null,"G"]
[88,"Engineering Management","Does the supplier have a training matrix for all engineering employees listing their core competencies?",{"$f":"' OSA Questions'!$F89","v":"N/A"},{"$f":"' OSA Questions'!K89","v":"M"},null,null,null,null,null,"G"]
[89,"Engineering Management","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F90","v":"N/A"},{"$f":"' OSA Questions'!K90","v":"M"},null,null,null,null,null,"G"]
[90,"Human Resources","Does the supplier have a proactive health and safety plan?  Do they comply with local laws and regulations?",{"$f":"' OSA Questions'!$F91","v":"N/A"},{"$f":"' OSA Questions'!K91","v":"M"},null,null,null,null,null,"G"]
[91,"Human Resources","Are policies in place that ensure host country legal wages are met or aligned with prevailing industry wage where there are no requirements?",{"$f":"' OSA Questions'!$F92","v":"N/A"},{"$f":"' OSA Questions'!K92","v":"C"},null,null,null,null,null,"G"]
[92,"Human Resources","Are policies in place that prohibit engagement of forced labor, human trafficking, sex acts and withholding of employee identification or immigration documents?",{"$f":"' OSA Questions'!$F93","v":"N/A"},{"$f":"' OSA Questions'!K93","v":"C"},null,null,null,null,null,"G"]
[93,"Human Resources","Sustainability. \nIs there a \"Reduce-Reuse-Recycle\" philosophy/program in place? Is sustainability included in the KPI's and is there a strategy for continuous improvement? ",{"$f":"' OSA Questions'!$F94","v":"N/A"},{"$f":"' OSA Questions'!K94","v":"M"},null,null,null,null,null,"G"]
[94,"Human Resources","Are Environmental, Health and Safety audits conducted annually by internal personnel?  Is there an EHS policy displayed?",{"$f":"' OSA Questions'!$F95","v":"N/A"},{"$f":"' OSA Questions'!K95","v":"M"},null,null,null,null,null,"G"]
[95,"Human Resources","Are the workers are protected from exposure to significant safety or health hazards within the facility, including offices, operational areas, and company provided housing? Company requires PPE. Instructions are posted and training is required to avoid potential risks. ",{"$f":"' OSA Questions'!$F96","v":"N/A"},{"$f":"' OSA Questions'!K96","v":"C"},null,null,null,null,null,"G"]
[96,"Human Resources","Supplier maintains appropriate fire detection and suppression equipment as well as adequate exits?",{"$f":"' OSA Questions'!$F97","v":"N/A"},{"$f":"' OSA Questions'!K97","v":"C"},null,null,null,null,null,"G"]
[97,"Human Resources","Verify with Training records for employees observed on the floor",{"$f":"' OSA Questions'!$F98","v":"N/A"},{"$f":"' OSA Questions'!K98","v":"M"},null,null,null,null,null,"G"]
[98,"Human Resources","Does the supplier have a staff resource plan?",{"$f":"' OSA Questions'!$F99","v":"N/A"},{"$f":"' OSA Questions'!K99","v":"M"},null,null,null,null,null,"G"]
[99,"Human Resources","Does the supplier have a training matrix for all production operators listing their core competencies?",{"$f":"' OSA Questions'!$F100","v":"N/A"},{"$f":"' OSA Questions'!K100","v":"M"},null,null,null,null,null,"G"]
[100,"Human Resources","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F101","v":"N/A"},{"$f":"' OSA Questions'!K101","v":"M"},null,null,null,null,null,"G"]
[101,"Material Control & Planning","Does the supplier have an understanding of Kanban?  Is Kanban utilized at this facility?",{"$f":"' OSA Questions'!$F102","v":"N/A"},{"$f":"' OSA Questions'!I102","v":"M"},null,null,null,null,null,"G"]
[102,"Material Control & Planning","Does the supplier utilize an electronic MRP or ERP system to manage delivery to Allegion and control inventory",{"$f":"' OSA Questions'!$F103","v":"N/A"},{"$f":"' OSA Questions'!I103","v":"M"},null,null,null,null,null,"G"]
[103,"Material Control & Planning","The supplier shall have a process to ensure that any potential problems or deviations from the production plan that could impact the customer operation are communicated internally and to the customer as soon as they are identified.",{"$f":"' OSA Questions'!$F104","v":"N/A"},{"$f":"' OSA Questions'!I104","v":"M"},null,null,null,null,null,"G"]
[104,"Material Control & Planning","There are systems in place to ensure accurate stock balance of all inventory types (e.g., finished goods, scrap). These stock balance figures are accurately updated in a timely manner.",{"$f":"' OSA Questions'!$F105","v":"N/A"},{"$f":"' OSA Questions'!I105","v":"C"},null,null,null,null,null,"G"]
[105,"Material Control & Planning","A set of parameters, (e.g., transport time, lead times, inventory levels, packaging), and internal production requirements, (e.g., supplier constraints, scrap rates set-up times), are integrated into the production planning system automatically and updated at planned intervals.",{"$f":"' OSA Questions'!$F106","v":"N/A"},{"$f":"' OSA Questions'!I106","v":"M"},null,null,null,null,null,"G"]
[106,"Material Control & Planning","Customer schedule information is automatically integrated into the supplier's releasing system (Use of a Material Requirements Planning System - MRP) to avoid manual transference of data. Supplier is using a formal (ODETTE/AIAG) electronic communication standard (EDI) or any other web based electronic standard. ",{"$f":"' OSA Questions'!$F107","v":"N/A"},{"$f":"' OSA Questions'!I107","v":"M"},null,null,null,null,null,"G"]
[107,"Material Control & Planning","Documented procedures for all customer interface aspects of the Materials Planning and Logistics process exist (e.g., customer order planning, stock control, packaging procedures and transport management). ",{"$f":"' OSA Questions'!$F108","v":"N/A"},{"$f":"' OSA Questions'!I108","v":"M"},null,null,null,null,null,"G"]
[108,"Material Control & Planning","Supplier considers all factors influencing the need for inventory buffers, (e.g., demand variability, process capabilities, internal transport and warehousing situation, customer safety stock requirements, different industrial calendars, etc...). ",{"$f":"' OSA Questions'!$F109","v":"N/A"},{"$f":"' OSA Questions'!I109","v":"C"},null,null,null,null,null,"G"]
[109,"Material Control & Planning","There is 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. ",{"$f":"' OSA Questions'!$F110","v":"N/A"},{"$f":"' OSA Questions'!I110","v":"M"},null,null,null,null,null,"G"]
[110,"Material Control & Planning","Does the supplier have defined performance measurable for its suppliers? Does the supplier have a process to evaluate and develop their supply base? ",{"$f":"' OSA Questions'!$F111","v":"N/A"},{"$f":"' OSA Questions'!I111","v":"M"},null,null,null,null,null,"G"]
[111,"Material Control & Planning","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F112","v":"N/A"},{"$f":"' OSA Questions'!I112","v":"M"},null,null,null,null,null,"G"]
[112,"Leadership & Compliance","Does supplier agree to abide by  Allegion Business Partner Code Of Conduct, as listed on Supplier web portal, 0 or 5 are only scores possible",{"$f":"' OSA Questions'!$F113","v":"N/A"},{"$f":"' OSA Questions'!$K$113","v":"C"},null,null,null,null,null,"G"]
[113,"Leadership & Compliance","Waste Water Discharges, Green House Gas Emissions and site waste generation is managed according to applicable regulations and to minimize impacts to the environment and community? Supplier has record of all environmental impacts and has defined action plans to reduce environmental impact (Including non-recyclable materials).",{"$f":"' OSA Questions'!$F114","v":"N/A"},{"$f":"' OSA Questions'!$H$114","v":"C"},null,null,null,null,null,"G"]
[114,"Leadership & Compliance","Is Preventative Maintenance (PM) evident in the manufacturing process? Are Preventive Maintenance routines completed according to the schedule? Is downtime monitored and are there improvement strategies in place? Does supplier have the minimum requirements in place to execute corrective maintenance?",{"$f":"' OSA Questions'!$F115","v":"N/A"},{"$f":"' OSA Questions'!K115","v":"M"},null,null,null,null,null,"G"]
[115,"Leadership & Compliance","Does the strategic plan include sales and growth plan? Does the supplier’s strategic plan drive the operational plan? Is the supplier's strategic plan and operational plan understood and integrated by its operating teams?",{"$f":"' OSA Questions'!$F116","v":"N/A"},{"$f":"' OSA Questions'!K116","v":"M"},null,null,null,null,null,"G"]
[116,"Leadership & Compliance","Does the supplier visit customer facilities on an established schedule (Pro-actively)?",{"$f":"' OSA Questions'!$F117","v":"N/A"},{"$f":"' OSA Questions'!H117","v":"M"},null,null,null,null,null,"G"]
[117,"Leadership & Compliance","Is there evidence of a Customer Service System?",{"$f":"' OSA Questions'!$F118","v":"N/A"},{"$f":"' OSA Questions'!H118","v":"M"},null,null,null,null,null,"G"]
[118,"Leadership & Compliance","Are KPIs documented and communicated?",{"$f":"' OSA Questions'!$F119","v":"N/A"},{"$f":"' OSA Questions'!$K$119","v":"M"},null,null,null,null,null,"G"]

{"sheet":"Revision record","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Revision History:"]
[]
[null,"Revision","Date","Description of Change"]
[null,2.2999999999999998,"2017-03-31","Scoring formula updated"]
[null,3,"2017-10-01","complete revision to format, some questions modified/deleted/added"]
[null,3.1,"2017-12-18","Added Supplier Development and Trade Compliance sections"]

{"sheet":"Photos (optional)","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}