{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Allegion Assesment Instructions","Scoring","Supplier Leadership Questions","Supplier Self Assessment","Allegion OSA","Allegion OSA Scoring","OSA RAIL FOR YELLOW OR RED","Photos (optional)","Revision record"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Allegion Assesment Instructions","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,2,18,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],[16,2,16,4],[17,2,17,4],[4,7,4,8],[15,2,15,4],[11,7,11,8],[14,7,14,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[20,2,20,4],[20,5,20,6],[20,7,20,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],[23,2,23,4],[23,5,23,6],[23,7,23,8],[38,1,38,8],[34,1,34,8],[33,1,33,8],[36,1,36,8],[37,1,37,8]]}
[null,null,null,null,null,null,null,null,null,"a"]
[]
[null,"Supplier Assessment Cover Page and Instructions"]
[]
[null,null,null,null,null,null,null,"Rev. F, January 20, 2022"]
[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 Critical Rating","MIN Score",null,null,null,null,null,null,"CASTINGS - INVESTMENT"]
[null,null,null,null,null,null,null,{"$f":"'Allegion OSA'!T12","v":0},{"$f":"MIN('Allegion OSA'!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),\"OSA PASS\",IF(H10>=0.45,\"OSA CONDITIONAL\",IF(H10<0.45,\"OSA FAIL\",\"\")))","v":"OSA FAIL"},null,null,null,null,null,null,null,"ELECTRONICS"]
[null,"Allegion on-site auditor:  ",null,null,null,null,null,{"$f":"IF(AND('Allegion OSA'!AA12>=0.6,'Allegion OSA'!Z12>2),\"EHS PASS\",\"EHS REVIEW\")","v":"EHS REVIEW"},null,null,null,null,null,null,null,"EXTRUSIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FASTENERS"]
[null,null,"Critical Dates",null,null,null,null,"Primary Commodity",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,"Leadership QA + Self Assessment Date Received:          "]
[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 for OSA:  ","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,null,null,null,"OEM - CYLINDERS"]
[null,null,null,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,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,"Allegion's Supplier Assessment is broken down in 3 sections: "]
[null,"     - Supplier Leadership Questions"]
[null,"     - Supplier Self Assessment"]
[null,"     - Allegion On-Site Assessment"]
[null,"Supplier Leadership, Organization and Regulatory Questions are to document the supplier's current state and culture related to Compliance, Cybersecurity, and C-TPAT (if applicable).  Allegion will review responses and determine if any further information is needed prior to the on-site assessment.  "]
[null,"The Supplier Self Assessment consists of the exact same questions that Allegion will ask during their OSA, and is used to ensure the supplier knows and understands what will be audited by Allegion.  This also provides us with a baseline to which we can compare Allegion's results.  See below for more details on how this assessment is structured. "]
[null,"The Allegion On-Site Assessment consists of an Allegion representative being onsite at the manufacturing location where the planned Allegion production would occur.  "]
[null,"The Supplier Self-Assessment and the Allegion On-Site Supplier Assessment are identical and are 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,"All questions are in split into one of two categories:\n(1) Questions that are defined as critical (C) in nature and (2) questions that measure maturity (M) 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 then 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,"OSA Pass / Fail criteria is based solely on the score of critical questions using the following scale:\nAverage critical score > 70% = Pass \nAverage critical score between 46% to 69% = Conditional  \nAverage critical score < 45% = Fail ",null,null,null,null,null,null,null,null,null,null,null,null,null,"STAMPINGS"]
[null,"Suppliers found deficient on critical questions with a Conditional rating may be requested 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 a plan for revaluation by Allegion.",null,null,null,null,null,null,null,null,null,null,null,null,null,"STEEL"]

{"sheet":"Scoring","index":1,"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":"Supplier Leadership Questions","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,10],[4,6,4,10],[5,3,5,5],[5,6,5,10],[6,2,7,2],[6,3,6,5],[6,6,6,10],[7,3,7,5],[7,6,7,10],[4,2,5,2],[4,3,4,5],[12,4,12,10],[9,4,9,10],[23,0,27,0],[23,4,23,10],[24,4,24,10],[25,4,25,10],[27,4,27,10],[12,0,20,0],[1,0,9,0],[8,4,8,10],[2,2,3,2],[2,3,2,5],[2,6,2,10],[3,3,3,5],[3,6,3,10],[20,4,20,10],[26,4,26,10],[19,4,19,10],[13,4,13,10],[14,4,14,10],[17,4,17,10],[15,4,15,10],[18,4,18,10]]}
[null,"Supplier Leadership Questions"]
["Compliance + Emergency Preparedness",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,"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,"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:"]
[]
[]
["Cybersecurity",null,"Does your company have an Information Technology (IT) department or dedicated personnel (internal or external) focused and actively working on cybersecurity risk?",null,"Please describe the structure of your IT security team here:"]
[null,null,"Does your company have a security awareness program for employees?",null,"Comments:"]
[null,null,"Is there a recovery plan in place for cybersecurity incidents?",null,"If 'Yes', document details of this plan here:  "]
[null,null,"Do you secure proprietary information from Allegion?",null,"Comments:"]
[null,null,"Please answer the following questions related to employee laptops and equipment:  "]
[null,null,"Is there a procedure to identify and thwart phishing attacks?",null,"Comments:"]
[null,null,"Are there firewalls, anti-spyware and anti-virus software installed on all computers?",null,"Comments:"]
[null,null,"Is there a monitored and standard process for handling and tracking employee laptops?",null,"Comments:"]
[null,null,"List any security certifications held by your company",null,"Document accordingly:"]
[]
[]
["CTPAT Supply Chain Security (Not Applicable to US suppliers)",null,"SEALS: 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,"CONTAINER/TRAILER SECURITY: 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,"ACCESS CONTROL: 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,"ACCESS CONTROL: 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:"]
[null,null,"AGRICULTURAL SECURITY: Does the supplier have written procedures designed to prevent visible pest contamination? \nKey points: Cargo staging areas, and the immediate surrounding areas, must be inspected on a regular basis to ensure these areas remain free of visible pest contamination.   ",null,"Comments:"]

{"sheet":"Supplier Self Assessment","index":3,"n_rows":119,"n_cols":28,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,0,16,0],[1,16,2,16],[1,17,1,19],[1,20,1,22],[9,16,11,16],[9,17,9,19],[9,20,9,22],[90,0,100,0],[101,0,111,0],[112,0,118,0],[9,23,9,26],[17,0,43,0],[44,0,48,0],[49,0,60,0],[61,0,79,0],[80,0,89,0]]}
["Process or \nFunction","Question",null,"Procedure Required?","Notes","Score","Quality Management Systems","Commercial Systems","Materials Systems","Engineering Systems","Leadership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical or Mature"]
["Receiving Materials","1","Does a formal receiving process exist?","Y",null,"N/A","C",null,null,null,null,null,"Scores","Scores","Critical EHS designation",null,null,"Critical Score",null,null,"Maturity Score",null,null,null,null,null,null,{"$f":"IF(OR(G2=\"C\",H2=\"C\",I2=\"C\",J2=\"C\",K2=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[null,"2","Are purchase orders matched to material received?",null,null,"N/A",null,null,"C",null,null,null,0,0,null,null,null,"Actual","Possible","Min","Actual","Possible","Min",null,null,null,null,{"$f":"IF(OR(G3=\"C\",H3=\"C\",I3=\"C\",J3=\"C\",K3=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[null,"3","Are materials kept in acceptable conditions?",null,null,"N/A",null,null,"C",null,null,null,1,5,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,null,null,null,{"$f":"IF(OR(G5=\"C\",H5=\"C\",I5=\"C\",J5=\"C\",K5=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[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,null,null,null,"Mature"]
[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,null,null,null,"Mature"]
[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":5},{"$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,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"9","Are records of the inspection kept?",null,"Do results of inspections drive the skip lot process?","N/A","C",null,null,null,null,null,null,null,null,null,"TOTALS","Critical Score",null,null,"Maturity Score",null,null,"EHS Score\n(14, 41, 55, 56, 58, 91, 92, 112, 113)",null,null,null,"Critical"]
[null,"10","Do prints on file at R.I. match current revision levels-internal change control","Y",null,"N/A","M",null,null,null,null,null,null,null,null,null,null,"Actual","Possible","%","Actual","Possible","%","Actual","Possible","Min","%","Mature"]
[null,"11","Is traceability from source maintained?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R4:R8)","v":0},{"$f":"S4+S5+S6+S7+S8","v":5},{"$f":"IFERROR(R12/S12,0)","v":0},{"$f":"SUM(U4:U8)","v":0},{"$f":"SUM(V4:V8)","v":0},{"$f":"IFERROR(U12/V12,0)","v":0},{"$f":"SUMIF(O2:O124,\"CE\",F2:F124)","v":0},{"$f":"SUM(IF(O2:O124=\"CE\",IF(ISNUMBER(F2:F124),1,0),0))*5","v":5},{"$f":"MIN(F15,F42,F56,F57,F59,F92,F93,F113,F114)","v":0},{"$f":"IFERROR(X12/Y12,0)","v":0},"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"15","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"19","Do work instructions exist at each step in the process?",null,"Are they tied to Control Plans?","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"20","Use the work instruction to verify gages used, frequency and steps of the process.",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"21","Does a control plan exist? Does it match actual practice?",null,"Is a Reaction plan identified?","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"23","Are gages in calibration?",null,"Record a gage ID for system confirmation","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"24","Are quick changeover practices being utilized and measured? If applicable.",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"25","Is the status of the parts obvious, i.e. scrap, rework or acceptable? ",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"26","Is scrap and rework segregated from WIP? Non Conforming and questionable product segregated?",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"27","Are poke yokes or error-proofing evident",null,null,"N/A",null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"30","is one piece flow used? If not what type is used and why",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"34","5S status of work areas. Is 5S evident",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"35","Is inspection done in process by operators or offline by QA?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"36","Are SPC or other statistical methods used in process?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"37","Are the lighting and environmental controls adequate?",null,null,"N/A",null,null,null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"38","Are products inspected at end of line, at a minimum?","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"39","Will Allegion owned tooling be identified and properly maintained?  \nIs current customer owned tooling identified and maintained?","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"42","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["External Processes","44","Does the vendor utilize sub suppliers for Allegion products? Such as heat treat or finishing.",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"45","Are the sub suppliers \"certified\" by the supplier?","Y",null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"46","What lab data or process data is received? How is it audited and verified?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"47","Are parts traceable thru the sub suppliers processes?",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"48","Are parts inspected upon return? Are records kept of the inspection?",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
["Final Inspection and shipping ","49","How are parts verified as ready for shipment to Allegion?","Y",null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"50","How are parts identified as ready for shipment to Allegion?",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"52","Is ASN or other EDI notice given to Allegion upon shipment?",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"54","The supplier shall have procedure to ensure packaging is approved by Allegion as part of PPAP.","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"59","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"62","If not certified does supplier have an internal audit system?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G69=\"C\",H69=\"C\",I69=\"C\",J69=\"C\",K69=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[null,"69","Does the supplier have a Quality Improvement Plan?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"75","Is there a Continuous Improvement process around Quality for internal and external defects?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"76","Does the supplier utilize statistical methods to identify, contain, and resolve issues.",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"86","Does the supplier have a process to develop and implement product innovation?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"87","Does the supplier have a process to develop prototypes?",null,null,"N/A",null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"97","Verify with Training records for employees observed on the floor",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"98","Does the supplier have a staff resource plan?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"111","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,0,null,null,null,null,"C",null,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"116","Does the supplier visit customer facilities on an established schedule (Pro-actively)?",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"117","Is there evidence of a Customer Service System?",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]

{"sheet":"Allegion OSA","index":4,"n_rows":119,"n_cols":28,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,1,0,2],[9,17,9,19],[9,20,9,22],[9,23,9,26],[1,20,1,22],[1,16,2,16],[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],[1,0,16,0],[17,0,43,0],[44,0,48,0],[9,16,11,16]]}
["Process or \nFunction","Question",null,"Procedure Required?","Notes","Score","Quality Management Systems","Commercial Systems","Materials Systems","Engineering Systems","Leadership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical or Mature"]
["Receiving Materials","1","Does a formal receiving process exist?","Y",null,"N/A","C",null,null,null,null,null,"Scores","Scores","Critical EHS designation",null,null,"Critical Score",null,null,"Maturity Score",null,null,null,null,null,null,{"$f":"IF(OR(G2=\"C\",H2=\"C\",I2=\"C\",J2=\"C\",K2=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[null,"2","Are purchase orders matched to material received?",null,null,"N/A",null,null,"C",null,null,null,0,0,null,null,null,"Actual","Possible","Min","Actual","Possible","Min",null,null,null,null,{"$f":"IF(OR(G3=\"C\",H3=\"C\",I3=\"C\",J3=\"C\",K3=\"C\"),\"Critical\",\"Mature\")","v":"Critical"}]
[null,"3","Are materials kept in acceptable conditions?",null,null,"N/A",null,null,"C",null,null,null,1,5,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,"N/A",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,null,null,null,"Critical"]
[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,null,null,null,"Mature"]
[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,null,null,null,"Mature"]
[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":5},{"$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,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"9","Are records of the inspection kept?",null,"Do results of inspections drive the skip lot process?","N/A","C",null,null,null,null,null,null,null,null,null,"TOTALS","Critical Score",null,null,"Maturity Score",null,null,"EHS Score\n(14, 41, 55, 56, 58, 91, 92, 112, 113)",null,null,null,"Critical"]
[null,"10","Do prints on file at R.I. match current revision levels-internal change control","Y",null,"N/A","M",null,null,null,null,null,null,null,null,null,null,"Actual","Possible","%","Actual","Possible","%","Actual","Possible","Min","%","Mature"]
[null,"11","Is traceability from source maintained?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R4:R8)","v":0},{"$f":"S4+S5+S6+S7+S8","v":5},{"$f":"IFERROR(R12/S12,0)","v":0},{"$f":"SUM(U4:U8)","v":0},{"$f":"SUM(V4:V8)","v":0},{"$f":"IFERROR(U12/V12,0)","v":0},{"$f":"SUMIF(O2:O124,\"CE\",F2:F124)","v":0},{"$f":"SUM(IF(O2:O124=\"CE\",IF(ISNUMBER(F2:F124),1,0),0))*5","v":5},{"$f":"MIN(F15,F42,F56,F57,F59,F92,F93,F113,F114)","v":0},{"$f":"IFERROR(X12/Y12,0)","v":0},"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"15","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"19","Do work instructions exist at each step in the process?",null,"Are they tied to Control Plans?","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"20","Use the work instruction to verify gages used, frequency and steps of the process.",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"21","Does a control plan exist? Does it match actual practice?",null,"Is a Reaction plan identified?","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"23","Are gages in calibration?",null,"Record a gage ID for system confirmation","N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"24","Are quick changeover practices being utilized and measured? If applicable.",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"25","Is the status of the parts obvious, i.e. scrap, rework or acceptable? ",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"26","Is scrap and rework segregated from WIP? Non Conforming and questionable product segregated?",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"27","Are poke yokes or error-proofing evident",null,null,"N/A",null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"30","is one piece flow used? If not what type is used and why",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"34","5S status of work areas. Is 5S evident",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"35","Is inspection done in process by operators or offline by QA?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"36","Are SPC or other statistical methods used in process?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"37","Are the lighting and environmental controls adequate?",null,null,"N/A",null,null,null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"38","Are products inspected at end of line, at a minimum?","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"39","Will Allegion owned tooling be identified and properly maintained?  \nIs current customer owned tooling identified and maintained?","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"42","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["External Processes","44","Does the vendor utilize sub suppliers for Allegion products? Such as heat treat or finishing.",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"45","Are the sub suppliers \"certified\" by the supplier?","Y",null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"46","What lab data or process data is received? How is it audited and verified?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"47","Are parts traceable thru the sub suppliers processes?",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"48","Are parts inspected upon return? Are records kept of the inspection?",null,null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
["Final Inspection and shipping ","49","How are parts verified as ready for shipment to Allegion?","Y",null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"50","How are parts identified as ready for shipment to Allegion?",null,null,"N/A",null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"52","Is ASN or other EDI notice given to Allegion upon shipment?",null,null,"N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"54","The supplier shall have procedure to ensure packaging is approved by Allegion as part of PPAP.","Y",null,"N/A","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"59","Is there a daily start up routine?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"62","If not certified does supplier have an internal audit system?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G67=\"C\",H67=\"C\",I67=\"C\",J67=\"C\",K67=\"C\"),\"Critical\",\"Mature\")","v":"Mature"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"69","Does the supplier have a Quality Improvement Plan?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"75","Is there a Continuous Improvement process around Quality for internal and external defects?",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"76","Does the supplier utilize statistical methods to identify, contain, and resolve issues.",null,null,"N/A","M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"86","Does the supplier have a process to develop and implement product innovation?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"87","Does the supplier have a process to develop prototypes?",null,null,"N/A",null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[null,"97","Verify with Training records for employees observed on the floor",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"98","Does the supplier have a staff resource plan?",null,null,"N/A",null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"111","Are KPIs documented and communicated?",null,"Are actions being driven in support of the KPIs/Metrics?","N/A",null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
["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,0,null,null,null,null,"C",null,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,"CE",null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"116","Does the supplier visit customer facilities on an established schedule (Pro-actively)?",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[null,"117","Is there evidence of a Customer Service System?",null,null,"N/A",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mature"]

{"sheet":"Allegion OSA Scoring","index":5,"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('Allegion OSA'!R4/'Allegion OSA'!S4,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U4/'Allegion OSA'!V4,0)","v":0}]
[null,"B.","Commercial Systems",null,null,null,null,null,null,{"$f":"IFERROR('Allegion OSA'!R5/'Allegion OSA'!S5,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U5/'Allegion OSA'!V5,0)","v":0}]
[null,"C.","Materials Systems",null,null,null,null,null,null,{"$f":"IFERROR('Allegion OSA'!R6/'Allegion OSA'!S6,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U6/'Allegion OSA'!V6,0)","v":0}]
[null,"D.","Engineering Systems",null,null,null,null,null,null,{"$f":"IFERROR('Allegion OSA'!R7/'Allegion OSA'!S7,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U7/'Allegion OSA'!V7,0)","v":0}]
[null,"E.","Leadership",null,null,null,null,null,null,{"$f":"IFERROR('Allegion OSA'!R8/'Allegion OSA'!S8,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U8/'Allegion OSA'!V8,0)","v":0}]
[null,null,"OVERALL LOWEST SCORE",null,null,null,null,null,null,{"$f":"IFERROR('Allegion OSA'!R12/'Allegion OSA'!S12,0)","v":0},{"$f":"IFERROR('Allegion OSA'!U12/'Allegion OSA'!V12,0)","v":0}]

{"sheet":"OSA RAIL FOR YELLOW OR RED","index":6,"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":"00:00:00"}]
["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":"'Allegion OSA'!$F2","v":"N/A"},{"$f":"'Allegion OSA'!$G2","v":"C"},null,null,null,null,null,"G"]
[2,"Receiving","Are purchase orders matched to material received?",{"$f":"'Allegion OSA'!$F3","v":"N/A"},{"$f":"'Allegion OSA'!I3","v":"C"},null,null,null,null,null,"G"]
[3,"Receiving","Are materials kept in acceptable conditions?",{"$f":"'Allegion OSA'!$F4","v":"N/A"},{"$f":"'Allegion OSA'!I4","v":"C"},null,null,null,null,null,"G"]
[4,"Receiving","Are products identified as acceptable for use with labels or tags?",{"$f":"'Allegion OSA'!$F5","v":"N/A"},{"$f":"'Allegion OSA'!$G5","v":"C"},null,null,null,null,null,"G"]
[5,"Receiving","Are blue print revision levels verified against PO and shipper?",{"$f":"'Allegion OSA'!$F6","v":"N/A"},{"$f":"'Allegion OSA'!$G6","v":"M"},null,null,null,null,null,"G"]
[6,"Receiving","Is receiving inspection performed?",{"$f":"'Allegion OSA'!$F7","v":"N/A"},{"$f":"'Allegion OSA'!$G7","v":"M"},null,null,null,null,null,"G"]
[7,"Receiving","If yes, is skip lot or other methods used ?",{"$f":"'Allegion OSA'!$F8","v":"N/A"},{"$f":"'Allegion OSA'!$G8","v":"M"},null,null,null,null,null,"G"]
[8,"Receiving","Do gages used at R.I. have calibration identified?",{"$f":"'Allegion OSA'!$F9","v":"N/A"},{"$f":"'Allegion OSA'!$G9","v":"C"},null,null,null,null,null,"G"]
[9,"Receiving","Are records of the inspection kept?",{"$f":"'Allegion OSA'!$F10","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F11","v":"N/A"},{"$f":"'Allegion OSA'!$G11","v":"M"},null,null,null,null,null,"G"]
[11,"Receiving","Is traceability from source maintained?",{"$f":"'Allegion OSA'!$F12","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F13","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F14","v":"N/A"},{"$f":"'Allegion OSA'!K14","v":"M"},null,null,null,null,null,"G"]
[14,"Receiving","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"'Allegion OSA'!$F15","v":"N/A"},{"$f":"'Allegion OSA'!K15","v":"C"},null,null,null,null,null,"G"]
[15,"Receiving","Is there a daily start up routine?",{"$f":"'Allegion OSA'!$F16","v":"N/A"},{"$f":"'Allegion OSA'!K16","v":"M"},null,null,null,null,null,"G"]
[16,"Receiving","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F17","v":"N/A"},{"$f":"'Allegion OSA'!K17","v":"M"},null,null,null,null,null,"G"]
[17,"Work in Process","Are materials kept in acceptable conditions?",{"$f":"'Allegion OSA'!$F18","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F19","v":"N/A"},{"$f":"'Allegion OSA'!$G19","v":"C"},null,null,null,null,null,"G"]
[19,"Work in Process","Do work instructions exist at each step in the process?",{"$f":"'Allegion OSA'!$F20","v":"N/A"},{"$f":"'Allegion OSA'!$G20","v":"C"},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":"'Allegion OSA'!$F21","v":"N/A"},{"$f":"'Allegion OSA'!$G21","v":"C"},null,null,null,null,null,"G"]
[21,"Work in Process","Does a control plan exist? Does it match actual practice?",{"$f":"'Allegion OSA'!$F22","v":"N/A"},{"$f":"'Allegion OSA'!$G22","v":"C"},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":"'Allegion OSA'!$F23","v":"N/A"},{"$f":"'Allegion OSA'!$G23","v":"M"},null,null,null,null,null,"G"]
[23,"Work in Process","Are gages in calibration?",{"$f":"'Allegion OSA'!$F24","v":"N/A"},{"$f":"'Allegion OSA'!$G24","v":"C"},null,null,null,null,null,"G"]
[24,"Work in Process","Are quick changeover practices being utilized and measured? If applicable.",{"$f":"'Allegion OSA'!$F25","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F26","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F27","v":"N/A"},{"$f":"'Allegion OSA'!I27","v":"C"},null,null,null,null,null,"G"]
[27,"Work in Process","Are pokeayokes or error-proofing evident",{"$f":"'Allegion OSA'!$F28","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F29","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F30","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F31","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F32","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F33","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F34","v":"N/A"},{"$f":"'Allegion OSA'!$I$34","v":"M"},null,null,null,null,null,"G"]
[34,"Work in Process","5S status of work areas. Is 5S evident",{"$f":"'Allegion OSA'!$F35","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F36","v":"N/A"},{"$f":"'Allegion OSA'!$G36","v":"M"},null,null,null,null,null,"G"]
[36,"Work in Process","Are SPC or other statistical methods used in process?",{"$f":"'Allegion OSA'!$F37","v":"N/A"},{"$f":"'Allegion OSA'!$G37","v":"M"},null,null,null,null,null,"G"]
[37,"Work in Process","Are the lighting and environmental controls adequate?",{"$f":"'Allegion OSA'!$F38","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F39","v":"N/A"},{"$f":"'Allegion OSA'!$G39","v":"C"},null,null,null,null,null,"G"]
[39,"Work in Process","Is Allegion owned tooling identified and properly maintained.",{"$f":"'Allegion OSA'!$F40","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F41","v":"N/A"},{"$f":"'Allegion OSA'!K41","v":"M"},null,null,null,null,null,"G"]
[41,"Work in Process","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"'Allegion OSA'!$F42","v":"N/A"},{"$f":"'Allegion OSA'!K42","v":"C"},null,null,null,null,null,"G"]
[42,"Work in Process","Is there a daily start up routine?",{"$f":"'Allegion OSA'!$F43","v":"N/A"},{"$f":"'Allegion OSA'!K43","v":"M"},null,null,null,null,null,"G"]
[43,"Work in Process","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F44","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F45","v":"N/A"},{"$f":"'Allegion OSA'!$G45","v":"C"},null,null,null,null,null,"G"]
[45,"External Processes","Are the sub suppliers \"certified\" by the supplier?",{"$f":"'Allegion OSA'!$F46","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F47","v":"N/A"},{"$f":"'Allegion OSA'!$G47","v":"M"},null,null,null,null,null,"G"]
[47,"External Processes","Are parts traceable thru the sub suppliers processes?",{"$f":"'Allegion OSA'!$F48","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F49","v":"N/A"},{"$f":"'Allegion OSA'!$G49","v":"C"},null,null,null,null,null,"G"]
[49,"Final Inspection & Shipping","How are parts verified as ready for shipment to Allegion?",{"$f":"'Allegion OSA'!$F50","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F51","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F52","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F53","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F54","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F55","v":"N/A"},{"$f":"'Allegion OSA'!$G55","v":"C"},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":"'Allegion OSA'!$F56","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F57","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F58","v":"N/A"},{"$f":"'Allegion OSA'!K58","v":"M"},null,null,null,null,null,"G"]
[58,"Final Inspection & Shipping","EHS-any PPE needed? Are exits identified? Fire extinguishers?",{"$f":"'Allegion OSA'!$F59","v":"N/A"},{"$f":"'Allegion OSA'!K59","v":"C"},null,null,null,null,null,"G"]
[59,"Final Inspection & Shipping","Is there a daily start up routine?",{"$f":"'Allegion OSA'!$F60","v":"N/A"},{"$f":"'Allegion OSA'!K60","v":"M"},null,null,null,null,null,"G"]
[60,"Final Inspection & Shipping","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F61","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F62","v":"N/A"},{"$f":"'Allegion OSA'!$G62","v":"C"},null,null,null,null,null,"G"]
[62,"Quality Management","If not certified does supplier have an internal audit system?",{"$f":"'Allegion OSA'!$F63","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F64","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F65","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F66","v":"N/A"},{"$f":"'Allegion OSA'!$G66","v":"C"},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":"'Allegion OSA'!$F67","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F68","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F69","v":"N/A"},{"$f":"'Allegion OSA'!$J$69","v":"C"},null,null,null,null,null,"G"]
[69,"Quality Management","Does the supplier have a Quality Improvement Plan?",{"$f":"'Allegion OSA'!$F70","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F71","v":"N/A"},{"$f":"'Allegion OSA'!$G71","v":"C"},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":"'Allegion OSA'!$F72","v":"N/A"},{"$f":"'Allegion OSA'!$G72","v":"C"},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":"'Allegion OSA'!$F73","v":"N/A"},{"$f":"'Allegion OSA'!$G73","v":"C"},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":"'Allegion OSA'!$F74","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F75","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F76","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F77","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F78","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F79","v":"N/A"},{"$f":"'Allegion OSA'!K79","v":"M"},null,null,null,null,null,"G"]
[79,"Quality Management","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F80","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F81","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F82","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F83","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F84","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F85","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F86","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F87","v":"N/A"},{"$f":"'Allegion OSA'!$K$87","v":"M"},null,null,null,null,null,"G"]
[87,"Engineering Management","Does the supplier have a process to develop prototypes?",{"$f":"'Allegion OSA'!$F88","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F89","v":"N/A"},{"$f":"'Allegion OSA'!K89","v":"M"},null,null,null,null,null,"G"]
[89,"Engineering Management","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F90","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F91","v":"N/A"},{"$f":"'Allegion OSA'!K91","v":"C"},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":"'Allegion OSA'!$F92","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F93","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F94","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F95","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F96","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F97","v":"N/A"},{"$f":"'Allegion OSA'!K97","v":"C"},null,null,null,null,null,"G"]
[97,"Human Resources","Verify with Training records for employees observed on the floor",{"$f":"'Allegion OSA'!$F98","v":"N/A"},{"$f":"'Allegion OSA'!K98","v":"M"},null,null,null,null,null,"G"]
[98,"Human Resources","Does the supplier have a staff resource plan?",{"$f":"'Allegion OSA'!$F99","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F100","v":"N/A"},{"$f":"'Allegion OSA'!K100","v":"M"},null,null,null,null,null,"G"]
[100,"Human Resources","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F101","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F102","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F103","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F104","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F105","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F106","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F107","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F108","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F109","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F110","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F111","v":"N/A"},{"$f":"'Allegion OSA'!I111","v":"M"},null,null,null,null,null,"G"]
[111,"Material Control & Planning","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F112","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F113","v":0},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F114","v":"N/A"},{"$f":"'Allegion OSA'!$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":"'Allegion OSA'!$F115","v":"N/A"},{"$f":"'Allegion OSA'!K115","v":"C"},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":"'Allegion OSA'!$F116","v":"N/A"},{"$f":"'Allegion OSA'!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":"'Allegion OSA'!$F117","v":"N/A"},{"$f":"'Allegion OSA'!H117","v":"M"},null,null,null,null,null,"G"]
[117,"Leadership & Compliance","Is there evidence of a Customer Service System?",{"$f":"'Allegion OSA'!$F118","v":"N/A"},{"$f":"'Allegion OSA'!H118","v":"M"},null,null,null,null,null,"G"]
[118,"Leadership & Compliance","Are KPIs documented and communicated?",{"$f":"'Allegion OSA'!$F119","v":"N/A"},{"$f":"'Allegion OSA'!$K$119","v":"M"},null,null,null,null,null,"G"]

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

{"sheet":"Revision record","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"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,"B","2017-12-18","Added Supplier Development and Trade Compliance sections"]
[null,"C","2020-11-30","Changed Trade Compliance to C-TPAT, added Critical / Mature slicer"]
[null,"D","2021-11-02","Created tab specifically for supplier self assessment, as well as tab specifically for leadership questions.  Removed these leadership questions from Allegion OSA Questions tab"]
[null,"E","2021-12-20","Broke out CTPAT section and Supplier Development sections from bottom of 'Allegion OSA' tab and created new tab for 'Supplier Leadership Question'\n- also added Cybersecurity questions to this new tab\n- updated wording in each of the CTPAT questions\n\nCreated new tab specifically for supplier self assessment so we can store their self assessment and our OSA results together\n\nAdded pass / fail criteria description to Allegion Assessment Instructions tab\nUpdated description of 'Overall Rating' on this tab to 'Overall Critical Rating' as well\n\nUpdated instructions to reflect changes listed above\n\nAdded EHS 'rating' to draw attention to specific safety related questions - these are noted in the OSA itself\n\nChanged 9 questions from 'mature' to 'critical' to reflect ALLE's growth in supplier maturity\n(19, 21, 54, 65, 70, 71, 72, 90, 114)\nMade Q112 only able to be scored a 0 or 5\nChanged wording in Q39 from Allegion owned tooling to \"customer and / or Allegion owned\"\n\nDeleted 'notes' tab"]
[null,"F","2022-01-20","Corrections to Mature and Critical questions referenced in Rev E"]