{"text_format":"1","workbook":"xlsx","n_sheets":57,"sheets":["BOS Header","Instructions","OSA Questionnaire","CA Plan (optional)","Remarks (optional)","2.1a","2.1b","2.1c","2.1d","2.4","2.5a","2.5b","2.7","2.8a","2.8b","2.8c","2.9","2.10a","2.10b","2.12a","2.12b","2.12c","2.12d","2.12e","4.1","4.2","4.3","4.4a","4.4b","4.5a","4.5b","4.5c","4.5d","4.7a","4.7b","4.7c","4.8a","4.8b","4.9","4.10","4.11a","4.11b","4.12","5.1a","5.1b","5.1c","5.1d","5.2","5.3a","5.3b","5.3c","5.5","5.6","6","7a","7b","7c"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":80,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BOS Header","index":0,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,1,8,3],[7,4,8,6],[7,7,8,13],[13,3,13,11],[13,12,13,13],[5,2,5,3],[5,4,5,5],[5,6,5,8],[5,10,5,11],[6,1,6,3],[6,4,6,6],[6,7,6,13],[15,3,15,11],[15,12,15,13],[16,3,16,11],[16,12,16,13],[14,3,14,11],[14,12,14,13],[19,3,19,11],[19,12,19,13],[18,3,18,11],[18,12,18,13],[17,3,17,11],[17,12,17,13]]}
[]
[]
[]
[]
[]
[null,"Title:","OSA Manufacturing Questionnaire",null,"Doc. Number:",null,"GPO-Q TM 0002 - 02",null,null,"Revision:",6,null,"Date:","2018-07-06"]
[null,"Function / Organization:",null,null,"Author(s):",null,null,"Functional Owner/Title:"]
[null,"Supplier Development / Global Procurement",null,null,"David Doom",null,null,"Regional lead SQ&D"]
[]
[]
[]
[]
[]
[null,"Version No.","Date","Description of Changes",null,null,null,null,null,null,null,null,"Name"]
[null,1,"2016-03-10","Initial Release",null,null,null,null,null,null,null,null,"Mitch Gabor"]
[null,2,"2016-05-03","Added auto fill capability to OSA Letter (Supplier Name, Location) , added auto fill capability to Waiver form (Supplier Name), added auto fill capability to remarks tab (Name, Location, date, Auditor, Code, Commodity)",null,null,null,null,null,null,null,null,"Adam Ryley"]
[null,3,"2016-08-03","Buttons added, hide &  unhide, drop boxes updated, Question ID improved, links between questions & drop boxes updated, OSA Letter improved, spell check button removed and placed back, footer updated, mandatory fields identified as purple fields, file protected. Cells will be enlarged automatically (if needed). CA Plan added as optional. ",null,null,null,null,null,null,null,null,"Tony Jamers"]
[null,4,"2017-05-10","Additional functionality (file save name function, remove guidebook); deleted OSA letter and OSA waiver; cosmetic changes (typo errors corrected); protected marco; IR footer added",null,null,null,null,null,null,null,null,"David Doom"]
[null,5,"2018-05-31","Questionnaire has been brought in line with the ISO 9001:2015 and GSQM requirements",null,null,null,null,null,null,null,null,"Kris Koninckx"]
[null,6,"2018-07-09","Resolving some bugs (dropdown / guidebook deletion)",null,null,null,null,null,null,null,null,"David Doom"]

{"sheet":"Instructions","index":1,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[[25,0,25,17],[8,0,8,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[7,0,7,9]]}
["INSTRUCTIONS FOR OSA QUESTIONNAIRE:"]
[]
["*Rating: "]
["5 - Evidence validates full deployment of a systematic process, substantially exceeding customer expectations. No evidence of non-compliance. "]
["4 - Evidence validates deployment of a systematic process, resulting in meeting customer expectations."]
["3 - Evidence validates early stages of deployment or minor lapses of compliance."]
["2 - Evidence of random / incomplete deployment, process improvements required to validate processes."]
["1 - No evidence of deployment of a systematic process."]
["N/A - not applicable to the audited supplier/part/process/question"]
[]
["Column \"B\":"]
["Input all ratings into column \"E\" of the spreadsheet using the dropdown boxes for each individual cell."]
["Column \"B\" scores will be automatically populated. Do NOT leave \"0\" (zero) values in any row of column \"B\"."]
["Do not insert or delete rows, columns, or otherwise modify the structure of the OSA document."]
["Do not modify or expose the hidden cells."]
["Do not leave blank cells in the ratings column (column \"B\" of the OSA). If a question does not apply, write N/A in the respective cell."]
["The questions on blue background do not influence the supplier's OSA score. "]
[]
["Column \"F\":"]
["This column is mandatory to use, to add the information of what is verified on site at the supplier, during the "]
["OSA performed. Looking for WI's/procedure/Control plan, ... decriptions with revision numbers, date of release, "]
["responsible, … "]
["Information is a \"snap shot\" of the OSA performed, this will support re-scoring or colleagues who can step in. "]
[]
["OSA score result."]
["A.     RED/FAIL/Not Approved: indicates an OSA that has an overall score of less than 60% based on the OSA Worksheet (OSA Audit Questionnaire)"]
["B.     YELLOW:"]
["         a.      No sourcing pending Corrective Action(s): indicates an OSA that has an overall score of 60% or higher but lower than 70%. "]
[null,"Based on the OSA Worksheet (OSA Audit Questionnaire)"]
["         b.      Conditional Sourcing with Risk Mitigation: indicates an OSA that has an overall score of 70% or higher but lower than 80%.  "]
[null,"based on the OSA Worksheet (OSA Audit Questionnaire)"]
["C.     GREEN/PASS/Approved: indicates an OSA that has an overall score equal to or above 80%  "]
[null," based on the OSA Worksheet (OSA Audit Questionnaire)"]
[]
["Re-scoring:"]
["In the case of re-scoring of an OSA input all scores in column \"M\" of the spreadsheet."]
["For elements highlighted on yellow background (and the corresponding questions marked with a asterisk)"]
["a corrective action plan is mandatory for scores equal or less than \"3\"."]
[]
["Blue Section Scoring:"]
["The questions on blue background of the OSA can only be scored as R, Y, G."]
["The scoring for the questions in this section will be manually entered in column \"B\"."]
["RED: no evidence available of good deployment, no actions in place"]
["YELLOW: no evidence available of good deployment, actions in place to close the gap"]
["GREEN: evidence of good deployment in place"]
[]
["Color blinds:"]
["Throughout the OSA documents, color-blind users of those documents will refer to the OSA overall status as RED, YELLOW, GREEN "]
["based on the scores mentioned above. For individual OSA questions in the OSA Questionnaire, the questions "]
["will be deemed as \"RED\" for scores 1 and/or 2. “YELLOW” for scores of 3, and “GREEN” for scores of 4 and/or 5."]
[]
[]
[]
["R"]
["Y"]
["G"]
[]
["Whenever you wish to use the 'delete guidebook' function in the excel sheet, you have to use first the file save function."]
["For the file save function, you need to complete the supplier name, supplier location and audit date."]
["Only once you have used the 'file save' function, the 'delete guidebook' function is being activated."]

{"sheet":"OSA Questionnaire","index":2,"n_rows":111,"n_cols":27,"rows_kept":111,"cut":false,"hidden":false,"merged":[[109,6,109,8],[108,6,108,8],[102,2,102,3],[106,6,106,8],[107,6,107,8],[106,2,106,3],[107,2,107,3],[108,2,108,3],[104,1,104,8],[105,1,110,1],[109,2,109,3],[110,2,110,3],[110,6,110,8],[0,10,0,12],[62,2,62,3],[63,2,63,3],[54,2,54,3],[2,11,5,11],[2,8,5,8],[21,2,21,3],[19,2,19,3]]}
[null,null,null,"Manufacturing Onsite Assessment (OSA)",null,null,null,null,null,null,"Corrective Action Plan Implementation Validation",null,null,null,null,0]
[null,null,null,null,null,null,null,null,"OSA Score:","Sum","Acceptable?","OSA Re-Score:","Date","Sum"]
[null,"Supplier Name:","Jemison Metals","CSID:","8071879","Audit Date:","April 17 2019",null,{"$f":"J3/(5*(52-J8))","v":0.80400000000000005},{"$f":"SUM(J12:J79)","v":201},"Y",{"$f":"N3/(5*(52-N8))","v":0.80400000000000005},null,{"$f":"SUM(N12:N79)","v":201}]
[null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,"P"]
[null,"Supplier Location:","Gadsden, AL","Category:","Metal Fabrication","Auditor / Self Assessment:","Mark Hinkefent"]
[null,null,null,null,null,null,null,null,{"$f":"IF(T11>0,\"Yellow Q<4\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(B12:B79, \"*n/a*\")","v":2},null,null,null,{"$f":"COUNTIF(M12:M79, \"*n/a*\")","v":2}]
[]
["GSQM element","Rating","Assessment Questionnaire",null,"Objective Evidence and/or Comments","Further comments/evidence","Action Plan \nand/or Comments \n(if score less than 4)","Due Date","Responsible Person's Name ","Points","Acceptable\nY / N / P","SDE Remarks","Rating","Points"]
[2,null,"General Supplier Requirements"]
["GSQM 2.1a\nISO 4.1 4.2 4.3",{"$f":"IF(E12=\"\",\"\",(IF(ISERROR(MATCH(E12,Quest12,0)),5,(IF(6-(MATCH(E12,Quest12,0))=0,\"N/A\",6-(MATCH(E12,Quest12,0)))))))","v":4},"Does the supplier have and maintain an effective management system? \n(IATF 16949 / ISO 9001 ed. 2015 / ISO 14001 / OHSAS 18001)",null,"Supplier is ISO 9001:2008 or ISO 9001:2015 and ISO 14001 or OHSAS 18001 certified\nor: Supplier has an effective and properly maintained QMS in place, but is not certified","ISO 9001:2015 Latest Certified on 3-11-2019 YTD DPPM is 3483.  OTD YTD is 93%.",null,null,null,{"$f":"B12","v":4},null,null,{"$f":"B12","v":4},{"$f":"M12","v":4}]
["GSQM 2.1b\nISO 9.3",{"$f":"IF(E13=\"\",\"\",(IF(ISERROR(MATCH(E13,Quest13,0)),5,(IF(6-(MATCH(E13,Quest13,0))=0,\"N/A\",6-(MATCH(E13,Quest13,0)))))))","v":4},"Has the top management reviewed the performance regularly versus target? Have actions been defined? \n- Quality Objectives\n- Management review frequency",null,"MRM conducted (preferable once per year), all the Q-objectives are reviewed. Clear agenda & MOM's available. Trends monitored against the targets and also Y-O-Y/ MRM over MRM. Gap Analysis are available for  actions which are past due/off target.","Mgmt Review requirement is annual. 2 Mgmt reviews have been performed in the previous 12 months. Mgmt Reviews are posted online along with minutes and actions from the meeting.",null,null,null,{"$f":"B13","v":4},null,null,{"$f":"B13","v":4},{"$f":"M13","v":4}]
["GSQM 2.1c\nISO 9.2",{"$f":"IF(E14=\"\",\"\",(IF(ISERROR(MATCH(E14,Quest14,0)),5,(IF(6-(MATCH(E14,Quest14,0))=0,\"N/A\",6-(MATCH(E14,Quest14,0)))))))","v":4},"Are systems and internal/external audit results periodically reviewed by management?\n\n\n",null,"Management review including system and audit evaluation minimum once per year, actions implemented - on time closed. ","Internal and external audit results are reviewed at mgmt review. Minutes are available electronically to all employees.",null,null,null,{"$f":"B14","v":4},null,null,{"$f":"B14","v":4},{"$f":"M14","v":4}]
["GSQM 2.1d\nISO 5.3",{"$f":"IF(E15=\"\",\"\",(IF(ISERROR(MATCH(E15,Quest15,0)),5,(IF(6-(MATCH(E15,Quest15,0))=0,\"N/A\",6-(MATCH(E15,Quest15,0)))))))","v":4},"Is there an organization chart with responsibilities assigned? Is the chart up to date and are all functions related to quality and EHS staffed?\n",null,"Organization chart available, chart is up to date, controlled document. It  defines clear, functional responsibilities and escalations. A Quality and HS&E team is present. Customer representative is available to support IR in regards Q & OTD issues.","Org chart is in threads and covers all personnel and functions. Responsibilities are defined in Level 1 quality manual table of responsibilities.",null,null,null,{"$f":"B15","v":4},null,null,{"$f":"B15","v":4},{"$f":"M15","v":4}]
[2.4,null,"Documented Information"]
["GSQM 2.4\nISO 8.5.1",{"$f":"IF(E17=\"\",\"\",(IF(ISERROR(MATCH(E17,Quest17,0)),5,(IF(6-(MATCH(E17,Quest17,0))=0,\"N/A\",6-(MATCH(E17,Quest17,0)))))))","v":4},"* Is the documented information supporting the management system adequate?\n- Work & Process Instructions \n- Standard Operating Procedures\n- External Documents\n- Visual Factory (KPI's, Quality Objectives,…)\n",null,"Paper format or excel based doc database. SOPs have clear def. of responsibility. WI's have clear definition of work flow & responsibilities. Authorized personnel have access to all  relevant docs. Paper visual boards available.","Majority of quality system documentation is electronic (html based). Some visual aids and hardcopy postings exist and are controlled.",null,null,null,{"$f":"B17","v":4},null,null,{"$f":"B17","v":4},{"$f":"M17","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 2.5a\nISO 4.4.1; 4.4.2",{"$f":"IF(E18=\"\",\"\",(IF(ISERROR(MATCH(E18,Quest18,0)),5,(IF(6-(MATCH(E18,Quest18,0))=0,\"N/A\",6-(MATCH(E18,Quest18,0)))))))","v":4}," Is there a process established for the control of records and system documentation?\n· Policy for control of quality records \n· Retention policy or matrix \n· Revision control process for quality documents\n",null,"Master list available, controlled manually. Rev, retention, distribution and control of docs checked. All Records are maintained, locations of rec. defined. \nCustomer docs, SQM, drawings, mat. specs, test specs.; defined and reg. reviewed. ","Yes. QMP 7.5 rev B. Documented Information. All of these requirements are covered. Control of documentation is a level 2 procedure. Master lists exist with revision and retention requirements.",null,null,null,{"$f":"B18","v":4},null,null,{"$f":"B18","v":4},{"$f":"M18","v":4}]
["GSQM 2.5b\nISO 5.1.2",{"$f":"IF(E19=\"\",\"\",(IF(ISERROR(MATCH(E19,Quest19,0)),5,(IF(6-(MATCH(E19,Quest19,0))=0,\"N/A\",6-(MATCH(E19,Quest19,0)))))))","v":4},"How are the customer requirements (such as GSQM, drawings, specs) communicated and cascaded into the organization?\n",null,"All current drawings and spec's available. However, not easily to consulted. Critical features are addressed in CP's /WI's. Drawing notes/spec's requirements are communicated via WI's, MRP system or other means.  The supplier is aware of the GSQM. ","Reviewed during award review and built into the part spec, system generated on every work order. Level 2 procedure exists for this process.",null,null,null,{"$f":"B19","v":4},null,null,{"$f":"B19","v":4},{"$f":"M19","v":4}]
[2.7,null,"Risk Assessment & Contingency Plans"]
["GSQM 2.7\nISO 8.2.1",{"$f":"IF(E21=\"\",\"\",(IF(ISERROR(MATCH(E21,Quest21,0)),5,(IF(6-(MATCH(E21,Quest21,0))=0,\"N/A\",6-(MATCH(E21,Quest21,0)))))))","v":4},"Does the supplier have documented contingency plans to ensure continued operations and satisfy customer requirements? (e.g., utility interruptions, transportation, labor shortage, systems status, supplier-related issues)  Are there adequate backup systems in place?\n",null,"Clear procedure available. Responsibilities defined. Action plans & backups defined.   ","Jemison Metals has a contingency plan document. Last Revision date is 10/10/18.  Word document.",null,null,null,{"$f":"B21","v":4},null,null,{"$f":"B21","v":4},{"$f":"M21","v":4}]
[2.8,null,"Environmental, Health and Safety Compliance"]
["GSQM 2.8a\nISO 7.1.4",{"$f":"IF(E23=\"\",\"\",(IF(ISERROR(MATCH(E23,Quest23,0)),5,(IF(6-(MATCH(E23,Quest23,0))=0,\"N/A\",6-(MATCH(E23,Quest23,0)))))))","v":4},"Does the supplier have a documented commitment by management to provide a safe work environment for employees and does favorable data exist to support this claim?\n",null,"EH&S System in place including training records and MSDS Sheets.  Commitment from management that is demonstrated on the shop floor including posted Safety Statements. 12 months and above without a lost time accident.","Yes. Located in the Quality Policy.",null,null,null,{"$f":"B23","v":4},null,null,{"$f":"B23","v":4},{"$f":"M23","v":4}]
["GSQM 2.8b\nISO 7.1.4",{"$f":"IF(E24=\"\",\"\",(IF(ISERROR(MATCH(E24,Quest24,0)),5,(IF(6-(MATCH(E24,Quest24,0))=0,\"N/A\",6-(MATCH(E24,Quest24,0)))))))","v":4},"Is the supplier aware of and does it abide by all applicable Environmental Health and Safety permits required to conduct operation at the facilities of interest?  \nHow does the supplier organize them self to keep up to date with the changes in applicable legislation?\n",null,"Supplier has a complete EH&S System implemented on-site however they are not certified to the ISO 14000 Standard","Yes. Per the Jemison Health And Safety Program.  Corporate.",null,null,null,{"$f":"B24","v":4},null,null,{"$f":"B24","v":4},{"$f":"M24","v":4}]
["GSQM 2.8c",{"$f":"IF(E25=\"\",\"\",(IF(ISERROR(MATCH(E25,Quest25,0)),5,(IF(6-(MATCH(E25,Quest25,0))=0,\"N/A\",6-(MATCH(E25,Quest25,0)))))))","v":4},"Does the supplier have a system in place to communicate safe handling information (such as Material Safety Data Sheets) for any dangerous substances contained in its facilities and/or products? \n",null,"Supplier has procedure for controlling the MSDS documentation / Certificate for all materials are available. Hazardous Materials are clearly identified.","Located at employee clock in station.",null,null,null,{"$f":"B25","v":4},null,null,{"$f":"B25","v":4},{"$f":"M25","v":4}]
[2.9,null,"Cleanliness of Premises"]
["GSQM 2.9\nISO 7.1.4",{"$f":"IF(E27=\"\",\"\",(IF(ISERROR(MATCH(E27,Quest27,0)),5,(IF(6-(MATCH(E27,Quest27,0))=0,\"N/A\",6-(MATCH(E27,Quest27,0)))))))","v":4},"Are the work areas adequately organized  for the work performed (using 5S or other methods)?  \nDoes the work environment appear safe?\nIn case of laboratories are environmental conditions adequate?\n",null,"Shop floor is well organized and seems suitable to carry out the desired process. Operators are aware of the housekeeping and layout management, without a formal 5S in place. Laboratories have an adequate environment and are properly organized.","Shop is organized and is Adequate for service center. ",null,null,null,{"$f":"B27","v":4},null,null,{"$f":"B27","v":4},{"$f":"M27","v":4}]
["2.10",null,"Training"]
["GSQM 2.10a\nISO 7.2",{"$f":"IF(E29=\"\",\"\",(IF(ISERROR(MATCH(E29,Quest29,0)),5,(IF(6-(MATCH(E29,Quest29,0))=0,\"N/A\",6-(MATCH(E29,Quest29,0)))))))","v":4},"*Has training been provided for each job function / operation according to requirements?  Can a training matrix and current training records be provided for all employees? \n",null,"Training needs are identified by each Function and accordingly training calendar is prepared. 100% compliance to training calendar is evident and feedback of each training is collected and effectiveness is monitored.","Yes. Training matrix reviewed.",null,null,null,{"$f":"B29","v":4},null,null,{"$f":"B29","v":4},{"$f":"M29","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 2.10b\nISO 7.2",{"$f":"IF(E30=\"\",\"\",(IF(ISERROR(MATCH(E30,Quest30,0)),5,(IF(6-(MATCH(E30,Quest30,0))=0,\"N/A\",6-(MATCH(E30,Quest30,0)))))))","v":4},"*Are process operators and inspectors trained on the work instructions for their area? \nIs evidence found during spot-check on the shop floor?\n",null,"If work instructions are displayed in hard form and operator is fully aware of  the process and critical features. Skill matrix and training evidence are available.","All operators received on the job training and evaluated on job performance yearly.  Work instructions are digital and dynamic.",null,null,null,{"$f":"B30","v":4},null,null,{"$f":"B30","v":4},{"$f":"M30","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[2.12,null,"Sub-supplier management"]
["GSQM 2.12a\nISO 8.4.1",{"$f":"IF(E32=\"\",\"\",(IF(ISERROR(MATCH(E32,Quest32,0)),5,(IF(6-(MATCH(E32,Quest32,0))=0,\"N/A\",6-(MATCH(E32,Quest32,0)))))))","v":4},"* Is there a formally documented system used to select and manage suppliers through advanced  evaluation or by review of quality performance?  (Verify if approved suppliers list exists)\nHow do they manage directed suppliers?\n",null,"Supplier has a manual system to track all suppliers including a Approved Supplier List.  Monthly updates are tracked on supplier performance including PPM's, On-Time Delivery and Quality Performance.","Yes per QMP 8.4 rev original New Supplier Availation. We provide quarterly scorecards to our largest mill suppliers. Additionally, we provide the details of the scorecards (bucket performance) and generally meet with the mills to discuss approximately once/year for the largest scored suppliers.",null,null,null,{"$f":"B32","v":4},null,null,{"$f":"B32","v":4},{"$f":"M32","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 2.12b",{"$f":"IF(E33=\"\",\"\",(IF(ISERROR(MATCH(E33,Quest33,0)),5,(IF(6-(MATCH(E33,Quest33,0))=0,\"N/A\",6-(MATCH(E33,Quest33,0)))))))","v":4},"* Does supplier have a process in place to cascade IR GSQM requirements to their suppliers?\n\n",null,"Evidence exists, IR GSQM cascaded to their suppliers. Any prod. or process changes to supply chain (SDR/SPDCR) are communicated. Key supplier metrics are tracked monthly, action's are taken monthly on top supplier issue(s).","Yes.  Communicated on the purchase order.",null,null,null,{"$f":"B33","v":4},null,null,{"$f":"B33","v":4},{"$f":"M33","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 2.12c\nISO 8.4.2",{"$f":"IF(E34=\"\",\"\",(IF(ISERROR(MATCH(E34,Quest34,0)),5,(IF(6-(MATCH(E34,Quest34,0))=0,\"N/A\",6-(MATCH(E34,Quest34,0)))))))","v":4},"Does the supplier request corrective actions for defects found on Supplier's purchased material?  How do they monitor their supplier compliance to this process?\n",null,"Clear Incoming Inspection procedure in place. 8D reports requested on a case-by-case evaluation for Non-Conforming product. Suppliers completion of 8D's is tracked and monitored. Results are available targets defined.","Yes per QMP 10.2  rev B. Corrective actions.Corrective actions / 8D requests presented to suppliers based on occurrence level and severity of non-conformance.",null,null,null,{"$f":"B34","v":4},null,null,{"$f":"B34","v":4},{"$f":"M34","v":4}]
["GSQM 2.12d\nISO 8.4.2",{"$f":"IF(E35=\"\",\"\",(IF(ISERROR(MATCH(E35,Quest35,0)),5,(IF(6-(MATCH(E35,Quest35,0))=0,\"N/A\",6-(MATCH(E35,Quest35,0)))))))","v":4},"* If work is subcontracted to external sources, are there controls to assure the quality of the sub-contracted work?    \nDo they make PPAP of subcontracted processes such as paint, heat treatment? \n                                                     ",null,"Supplier has an Approved Supplier List and all applicable suppliers are evaluated quarterly.  Supplier can show evidence that all subcontracted parts go through the receiving inspection process. Majority of the parts go through a PPAP process.","Limited subcontracted processes. PPAP are done per customer request. Receiving inspection does apply.",null,null,null,{"$f":"B35","v":4},null,null,{"$f":"B35","v":4},{"$f":"M35","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 2.12e\nISO 8.4.2",{"$f":"IF(E36=\"\",\"\",(IF(ISERROR(MATCH(E36,Quest36,0)),5,(IF(6-(MATCH(E36,Quest36,0))=0,\"N/A\",6-(MATCH(E36,Quest36,0)))))))","v":4},"*Are raw materials / purchased components inspected, tested or otherwise verified prior to use?  Is inspection supported by PPAP processes on purchased components?\n",null,"Supplier can show evidence of a good receiving inspection system inplace. Majority of parts have gone through a PPAP approval process","Yes per Receiving Procedure rev 0. Raw materials do go through receiving inspection process. No PPAP on coils from mills.",null,null,null,{"$f":"B36","v":4},null,null,{"$f":"B36","v":4},{"$f":"M36","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4,null,"Advanced Quality Planning"]
["GSQM 4.1\nISO 8.2.3.1 & 8.2.3.2",{"$f":"IF(E38=\"\",\"\",(IF(ISERROR(MATCH(E38,Quest38,0)),5,(IF(6-(MATCH(E38,Quest38,0))=0,\"N/A\",6-(MATCH(E38,Quest38,0)))))))","v":4},"*Does supplier conduct a manufacturing feasibility check prior of quoting business to their customer(s). Can supplier provide evidence of an example? Does supplier apply the same process for changes to part or specifications?\n",null,"Any system available which is providing PFD and preliminary CP (Control Plan), necessary to approve a change or new part implementation, by all involved departments (stake holders). (engineering, purchasing, logistics, production, …)","Quote review utilizes APQP style capability analysis electronically using \"the model\" which includes equipment capability. Cross-functional teams are used as needed at quote stage. Award review takes additional measures per level 2 procedure.",null,null,null,{"$f":"B38","v":4},null,null,{"$f":"B38","v":4},{"$f":"M38","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.2",{"$f":"IF(E39=\"\",\"\",(IF(ISERROR(MATCH(E39,Quest39,0)),5,(IF(6-(MATCH(E39,Quest39,0))=0,\"N/A\",6-(MATCH(E39,Quest39,0)))))))","v":4},"Are Critical Characteristics called out on the PCP, and is appropriate control in place?\nIs Statistical Process Control used for CTQ's or for high severity items as identified on PFMEA?\n",null,"Supplier uses an equivalent document to a control plan like a Shop Router that gives detailed instruct on what to inspect/control including variable data measurements for all critical to quality part characteristics/dimensions.","We rarely have critical characteristics, but we do have some examples where we have individual part control plans that address frequency of inspections and actions for critical characteristics.",null,null,null,{"$f":"B39","v":4},null,null,{"$f":"B39","v":4},{"$f":"M39","v":4}]
["GSQM 4.3\nISO 7.1.5.2",{"$f":"IF(E40=\"\",\"\",(IF(ISERROR(MATCH(E40,Quest40,0)),5,(IF(6-(MATCH(E40,Quest40,0))=0,\"N/A\",6-(MATCH(E40,Quest40,0)))))))","v":4},"Does the supplier conduct Gage R&R, to analyze the variation present in the results of each type of measuring and test equipment system?       \nAre corrective actions taken in case of excessive variation?\n                                   ",null,"Formal Program included all measurement equipment. Statistical studies as gauge R&R as min. are performed periodically and standardization and variation are shown. MSA and SPC are part of the PPAP when applicable (Level 3 and Level 5).","Have performed before as required. Can meet this if required. No exhaustive system in place at this time.",null,null,null,{"$f":"B40","v":4},null,null,{"$f":"B40","v":4},{"$f":"M40","v":4}]
["GSQM 4.4a",{"$f":"IF(E41=\"\",\"\",(IF(ISERROR(MATCH(E41,Quest41,0)),5,(IF(6-(MATCH(E41,Quest41,0))=0,\"N/A\",6-(MATCH(E41,Quest41,0)))))))","v":4},"* Are gages and test / inspection equipment, including customer owned gages and equipment adequately maintained, calibrated, stored and available on the workstations?\nAre the following included in the records:\n· Item identity / Serial No. \n· Date calibrated / inspected \n· Date due for calibration or inspection \n",null,"Excel system; tracking of schedules, sending notes to production areas prior to gauge calibration. All gauges identified. All calibration info available, date of calibration, due date. Calibration history rec.","Excel tracking system. All calibrations are traceable to NIST. Gauges are labeled appropriately and calibration history is available for review.",null,null,null,{"$f":"B41","v":4},null,null,{"$f":"B41","v":4},{"$f":"M41","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.4b\nISO 7.5.1.1",{"$f":"IF(E42=\"\",\"\",(IF(ISERROR(MATCH(E42,Quest42,0)),5,(IF(6-(MATCH(E42,Quest42,0))=0,\"N/A\",6-(MATCH(E42,Quest42,0)))))))","v":4},"* Is there a documented calibration schedule for all measuring equipment and standards and are they adhering to it?   \nIs action taken in the event of calibration failure?\n                       ",null,"Excel system; tracking of schedules, notifications through e-mail. All gauges identified. All calibration info available, date of calibration, due date, ID of person done calibration. Calibration history recorded. Clear procedure in place.","Excel tracking system. All calibrations are traceable to NIST. Gauges are labeled appropriately and calibration history is available for review.",null,null,null,{"$f":"B42","v":4},null,null,{"$f":"B42","v":4},{"$f":"M42","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4.5,null,"Product Approval Process"]
["GSQM 4.5a\nISO 8.6",{"$f":"IF(E44=\"\",\"\",(IF(ISERROR(MATCH(E44,Quest44,0)),5,(IF(6-(MATCH(E44,Quest44,0))=0,\"N/A\",6-(MATCH(E44,Quest44,0)))))))","v":4},"*Does the supplier use PPAP (based on AIAG) as a tool to validate the product and manufacturing process? Does the supplier have evidence of a recent PPAP submission (look for PPAP level 3 or 5 examples)?\n",null,"Documented process in place. PPAP documentation available and in line with AIAG requirements( Level 3 or 5)","PPAP are done per customer request.  Currently supplying per customer requested format including AIAG.",null,null,null,{"$f":"B44","v":4},null,null,{"$f":"B44","v":4},{"$f":"M44","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.5b",{"$f":"IF(E45=\"\",\"\",(IF(ISERROR(MATCH(E45,Quest45,0)),5,(IF(6-(MATCH(E45,Quest45,0))=0,\"N/A\",6-(MATCH(E45,Quest45,0)))))))","v":4},"Does the supplier have a process flow diagram (PFD) in place, representing the complete flow?\n",null,"Supplier has Process Flow Diagrams in place for each product (family) that are adhered to. Including Sub-contractor activities and rework steps, if applicable. ","Yes for each piece of equipment, PFMEAs are process specific.  Can be supplier with PPAP.",null,null,null,{"$f":"B45","v":4},null,null,{"$f":"B45","v":4},{"$f":"M45","v":4}]
["GSQM 4.5c",{"$f":"IF(E46=\"\",\"\",(IF(ISERROR(MATCH(E46,Quest46,0)),5,(IF(6-(MATCH(E46,Quest46,0))=0,\"N/A\",6-(MATCH(E46,Quest46,0)))))))","v":4},"*Is PFMEA used as a tool to mitigate risk? Can supplier show evidence on using PFMEA during the APQP phase? Does the PFMEA correspond to the PFD?\n",null,"Documented procedure in place. P-FMEA available which will be updated systematically. P-FMEA's driven by a cross functional team. PFMEA's updated based on complaints received. PFMEA treated as a controlled document. ","Yes per QMP 10.2 rev A",null,null,null,{"$f":"B46","v":4},null,null,{"$f":"B46","v":4},{"$f":"M46","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.5d\nISO 8.5.1",{"$f":"IF(E47=\"\",\"\",(IF(ISERROR(MATCH(E47,Quest47,0)),5,(IF(6-(MATCH(E47,Quest47,0))=0,\"N/A\",6-(MATCH(E47,Quest47,0)))))))","v":4},"*Are there process control plans (PCP) in place, and in line with the risks identified in PFMEA?  Are the control plans being adhered to?\n",null,"Supplier has control plans in place for each product family that are adhered to. Controls Plans in accordance with AIAG format or travel card indicating the measurement equipment, frequency and what to do in case of a non-conformity","Control plans currently in place for all processes.  Part specific PFEMA's and CP's are provided as requested as part of the PPAP.",null,null,null,{"$f":"B47","v":4},null,null,{"$f":"B47","v":4},{"$f":"M47","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4.7,null,"Product Monitoring"]
["GSQM 4.7a\nISO 8.51",{"$f":"IF(E49=\"\",\"\",(IF(ISERROR(MATCH(E49,Quest49,0)),5,(IF(6-(MATCH(E49,Quest49,0))=0,\"N/A\",6-(MATCH(E49,Quest49,0)))))))","v":"N/A"},"Is there evidence of  control charts leading to actions?\n",null,"Process/ part volumes / commodity does not require use of control charts",null,null,null,null,{"$f":"B49","v":"N/A"},null,null,{"$f":"B49","v":"N/A"},{"$f":"M49","v":"N/A"}]
["GSQM 4.7b\nISO 8.5.1",{"$f":"IF(E50=\"\",\"\",(IF(ISERROR(MATCH(E50,Quest50,0)),5,(IF(6-(MATCH(E50,Quest50,0))=0,\"N/A\",6-(MATCH(E50,Quest50,0)))))))","v":5},"*Are process instructions available at the work station providing clear, complete and useful information to the operator in order to perform their tasks?\n",null,"Electronic Current revision Work instructions are at each work station via computer display.   Work instructions include setup, materials, methods, graphical instructions (as needed), and test & inspection steps necessary for inexperienced worker to successfully accomplish the assigned work task.  Work instructions highlight required actions to inspect previous work station output.","All procedures / Wis readily available at any work station at any time.",null,null,null,{"$f":"B50","v":5},null,null,{"$f":"B50","v":5},{"$f":"M50","v":5},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.7c\nISO 8.5.1",{"$f":"IF(E51=\"\",\"\",(IF(ISERROR(MATCH(E51,Quest51,0)),5,(IF(6-(MATCH(E51,Quest51,0))=0,\"N/A\",6-(MATCH(E51,Quest51,0)))))))","v":4},"* Is a piece part inspected prior to production runs for all processes requiring setups, and are actual readings recorded?\n",null,"Controls in place that assure no production without approved First Piece (where required).  First Piece requirement denoted on control plan.","Per GADS-FAB-001 rev 0 Fabrication FA Inspection Procedure.",null,null,null,{"$f":"B51","v":4},null,null,{"$f":"B51","v":4},{"$f":"M51","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4.8,null,"Change Control"]
["GSQM 4.8a\nISO 8.4.2",{"$f":"IF(E53=\"\",\"\",(IF(ISERROR(MATCH(E53,Quest53,0)),5,(IF(6-(MATCH(E53,Quest53,0))=0,\"N/A\",6-(MATCH(E53,Quest53,0)))))))","v":4},"* Is there a documented process for implementing product or process changes? Does the supplier validate these changes?\n",null,"Manual system in place for all product/process changes.  Manually tracking of all entries, to check all applicable procedures and drawings are revised to reflect the product or process change(s). All changes are validated through internal validation","Yes per GAD-FAB-002 rev 1 Rev-up procedure.  List of customers requiring change notice maintained.  Supplier also has a level 2 procedure for planning of change per ISO 9001:2015 requirements.",null,null,null,{"$f":"B53","v":4},null,null,{"$f":"B53","v":4},{"$f":"M53","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.8b\nISO 8.4.2",{"$f":"IF(E54=\"\",\"\",(IF(ISERROR(MATCH(E54,Quest54,0)),5,(IF(6-(MATCH(E54,Quest54,0))=0,\"N/A\",6-(MATCH(E54,Quest54,0)))))))","v":4},"* Does the supplier communicate product and process changes to the customer?  Can the supplier provide evidence of a process similar to Supplier Process & Design Change Request (SPDCR)?\n",null,"Manual system in place for all change management communication to customer.  Manually tracking of all entries, to check all applicable procedures and drawings are revised and updated correctly. Customer notification is evident where ever applicable.","Yes JDM-100 rev 4 Deviation Request Form.  List of customers requiring change and type of change notice maintained electronically.",null,null,null,{"$f":"B54","v":4},null,null,{"$f":"B54","v":4},{"$f":"M54","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4.9000000000000004,null,"Preventive & Predictive maintenance"]
["GSQM 4.9",{"$f":"IF(E56=\"\",\"\",(IF(ISERROR(MATCH(E56,Quest56,0)),5,(IF(6-(MATCH(E56,Quest56,0))=0,\"N/A\",6-(MATCH(E56,Quest56,0)))))))","v":4},"* Is there a maintenance plan for all equipment and tooling?  Is that plan being adhered to?\n",null,"Manual PM program requires to prints out; Work Orders on a daily, weekly, monthly and annual basis and assign to the appropriate Maintenance Person.  If work orders are not closed on time, a follows up is in place to insure they are conducted.","Reviewed PM process. PM schedule in place and up to date.",null,null,null,{"$f":"B56","v":4},null,null,{"$f":"B56","v":4},{"$f":"M56","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 4.10\nISO 8.5.3",{"$f":"IF(E57=\"\",\"\",(IF(ISERROR(MATCH(E57,Quest57,0)),5,(IF(6-(MATCH(E57,Quest57,0))=0,\"N/A\",6-(MATCH(E57,Quest57,0)))))))","v":"N/A"},"Does the supplier have documented information available and maintains a log of operational data for each IR (when applicable) or customer owned asset (patterns, production tooling's and fixtures, gauges, testing and measurement equipment,...) including, but not limited to:\n- Maintenance history\n- Usage\n- Capability information and capacity Tool changes for perishable tooling or wear components\n- Tool modifications and engineering changes\n",null,"Question is not applicable for this supplier",null,null,null,null,{"$f":"B57","v":"N/A"},null,null,{"$f":"B57","v":"N/A"},{"$f":"M57","v":"N/A"}]
[4.1100000000000003,null,"Identification & Traceability"]
["GSQM 4.11a\nISO 8.5.2",{"$f":"IF(E59=\"\",\"\",(IF(ISERROR(MATCH(E59,Quest59,0)),5,(IF(6-(MATCH(E59,Quest59,0))=0,\"N/A\",6-(MATCH(E59,Quest59,0)))))))","v":4},"Are raw materials / components identified and traceable to test or certification reports?\n· Date Codes　\n· Serial numbers　\n· Certificates of Analysis　\n· Bar coding technology　\nIs FIFO in place?\n",null,"Supplier has a manual receiving system in place with paper records.  All Material Certs including applicable Date Codes, Serial Numbers, and Certificates of Analysis can be produced upon request.","ERP system, Stelplan, provides excellent traceability via tag numbers. Supplier can track back to master tag, mill coil number and PO# with this one piece of information.",null,null,null,{"$f":"B59","v":4},null,null,{"$f":"B59","v":4},{"$f":"M59","v":4}]
["GSQM 4.11b\nISO 8.5.2",{"$f":"IF(E60=\"\",\"\",(IF(ISERROR(MATCH(E60,Quest60,0)),5,(IF(6-(MATCH(E60,Quest60,0))=0,\"N/A\",6-(MATCH(E60,Quest60,0)))))))","v":4},"Is Work In Progress (WIP) properly identified and properly preserved throughout all phases of production? Evidence through spot-check on the shop floor.\n",null,"All WIP-products have a travel card or process card  for each container or each part the is identified and traceable","All material identified and tracked through MTS (Material Tracking System)",null,null,null,{"$f":"B60","v":4},null,null,{"$f":"B60","v":4},{"$f":"M60","v":4}]
["GSQM 4.12\nISO 8.5.4",{"$f":"IF(E61=\"\",\"\",(IF(ISERROR(MATCH(E61,Quest61,0)),5,(IF(6-(MATCH(E61,Quest61,0))=0,\"N/A\",6-(MATCH(E61,Quest61,0)))))))","v":4},"Does the supplier have a plan for proper identification, handling, packaging, storage, protection and preservation of all Ingersoll Rand products and materials?\n",null,"All product have a travel card or process card  for each container or each part the is identified and traceable.","Referance QM-L1-S8 rev A. Operation Sub-Section Preservation.",null,null,null,{"$f":"B61","v":4},null,null,{"$f":"B61","v":4},{"$f":"M61","v":4}]
[5,null,"Non Conforming Product"]
["GSQM 5.1a",{"$f":"IF(E63=\"\",\"\",(IF(ISERROR(MATCH(E63,Quest63,0)),5,(IF(6-(MATCH(E63,Quest63,0))=0,\"N/A\",6-(MATCH(E63,Quest63,0)))))))","v":4},"*Are in-process defects charted and analyzed to detect problem areas and defect trends?  Is in-process and final verification performance data collected, analyzed & charted against year-over-year improvement targets?\n",null,"Limited procedures. Data collected, analyzed for trends, shifts in the process, and improvement year over year. Data is visually displayed, with indication of the performance. Evidence of defect analysis, charting with deployment and actions taken.","Internal DPPMs charted and reported monthly and discussed weekly on devaluation call with Operations and Quality. Management review shows the evaluation of this metric and actions to be taken for top occurrences.",null,null,null,{"$f":"B63","v":4},null,null,{"$f":"B63","v":4},{"$f":"M63","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.1b",{"$f":"IF(E64=\"\",\"\",(IF(ISERROR(MATCH(E64,Quest64,0)),5,(IF(6-(MATCH(E64,Quest64,0))=0,\"N/A\",6-(MATCH(E64,Quest64,0)))))))","v":4},"*Is non-conforming material sufficiently identified and segregated at all stages of the process?\n",null,"Clear procedure in place. Responsibilities defined. Non conforming material will be identified and placed immediately in dedicated areas. ","MRB located in bay 1. Non-Conforming material physically and virtually segregated. ",null,null,null,{"$f":"B64","v":4},null,null,{"$f":"B64","v":4},{"$f":"M64","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.1c",{"$f":"IF(E65=\"\",\"\",(IF(ISERROR(MATCH(E65,Quest65,0)),5,(IF(6-(MATCH(E65,Quest65,0))=0,\"N/A\",6-(MATCH(E65,Quest65,0)))))))","v":4},"*Is it defined who has authority to release and disposition non-conforming material?    \n                                                       ",null,"Clear procedure in place. Responsibilities defined. Follow up on actions defined and taken.  ","Yes per QMP 8.7 rev B. Control of Non-conforming Outputs.",null,null,null,{"$f":"B65","v":4},null,null,{"$f":"B65","v":4},{"$f":"M65","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.1d",{"$f":"IF(E66=\"\",\"\",(IF(ISERROR(MATCH(E66,Quest66,0)),5,(IF(6-(MATCH(E66,Quest66,0))=0,\"N/A\",6-(MATCH(E66,Quest66,0)))))))","v":4},"Is there a notification and containment procedure for when non-conforming material has been shipped?\n",null,"Clear procedure available. Responsibilities defined. Clear follow up available and reported.  ","Yes per QPM-8.7 rev B.",null,null,null,{"$f":"B66","v":4},null,null,{"$f":"B66","v":4},{"$f":"M66","v":4}]
["GSQM 5.2",{"$f":"IF(E67=\"\",\"\",(IF(ISERROR(MATCH(E67,Quest67,0)),5,(IF(6-(MATCH(E67,Quest67,0))=0,\"N/A\",6-(MATCH(E67,Quest67,0)))))))","v":4},"Does the supplier have a system to track Ingersoll Rand SCAR (Supplier Corrective Action Requests) / NCM reports?\nAre common root causes being addressed and resolved?\nDoes supplier apply same tracking on internal defects?\n",null,"Procedure in place by manual control. Field problems tracked, corrective actions defined. Engineering involved to assure design & product improvements.","Yes through customer portals and emails. Depending on the customer.",null,null,null,{"$f":"B67","v":4},null,null,{"$f":"B67","v":4},{"$f":"M67","v":4}]
[5.3,null,"Problem Solving"]
["GSQM 5.3a",{"$f":"IF(E69=\"\",\"\",(IF(ISERROR(MATCH(E69,Quest69,0)),5,(IF(6-(MATCH(E69,Quest69,0))=0,\"N/A\",6-(MATCH(E69,Quest69,0)))))))","v":4},"*Does the organization have a defined process for problem solving leading to root cause identification and elimination?  Examples of problem solving processes are:\n· 5 Why’s\n· 8D\n· Fishbone\n",null,"Clear procedure available. Responsibilities defined. Clear system & tools implemented in regards root cause identification and elimination. Follow up available and reported.  ","5-Y and 8D are used.",null,null,null,{"$f":"B69","v":4},null,null,{"$f":"B69","v":4},{"$f":"M69","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.3b",{"$f":"IF(E70=\"\",\"\",(IF(ISERROR(MATCH(E70,Quest70,0)),5,(IF(6-(MATCH(E70,Quest70,0))=0,\"N/A\",6-(MATCH(E70,Quest70,0)))))))","v":4},"*Is supplier using 8D methodology for internal,  external issues. Is problem solving process defined? Are root causes analyzed and corrective, preventive actions established and carried on? What is the output of problem solving process?\n",null,"Any system available in use with implementing 8D methodology. Corrective and preventive actions are forwarded to CA/PA, lists for all stakeholders. Procedure present at the suppliers QMS. Connection to other documents OK. ","Per QMP 10.2 rev B. Corrective Actions. ",null,null,null,{"$f":"B70","v":4},null,null,{"$f":"B70","v":4},{"$f":"M70","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.3c",{"$f":"IF(E71=\"\",\"\",(IF(ISERROR(MATCH(E71,Quest71,0)),5,(IF(6-(MATCH(E71,Quest71,0))=0,\"N/A\",6-(MATCH(E71,Quest71,0)))))))","v":4},"*What process does the supplier have in place to assure that corrective actions are documented in PFMEA and are leading to updates / revision of the Process control plan ( look at process flow chart as well)? Does supplier update PFMEA with the corrective actions from 8D reports?\n",null,"Documented procedure in place, with clear evidence found in the P-FMEA on the inclusion of customer complaints. Clear evidence on updates of PCP","Yes per QMP 10.2 rev B. Non-conformity and Corrective Action.",null,null,null,{"$f":"B71","v":4},null,null,{"$f":"B71","v":4},{"$f":"M71","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.5",{"$f":"IF(E72=\"\",\"\",(IF(ISERROR(MATCH(E72,Quest72,0)),5,(IF(6-(MATCH(E72,Quest72,0))=0,\"N/A\",6-(MATCH(E72,Quest72,0)))))))","v":4},"*Does the supplier obtain customers' approval from for temporary changes to existing product and processes prior to releasing product for shipment or authorizing production to proceed? \nFor Ingersoll Rand the supplier shall utilize the \"Supplier Deviation Request\" (SDR). \n",null,"Manual excel based tracker system in place for all deviation / concession monitoring. Waiver is get approved from customer and monitoring through manual system","Jemison has a formal deviation request document to be used when needed. We can use customer deviation paperwork as required.",null,null,null,{"$f":"B72","v":4},null,null,{"$f":"B72","v":4},{"$f":"M72","v":4},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["GSQM 5.6",{"$f":"IF(E73=\"\",\"\",(IF(ISERROR(MATCH(E73,Quest73,0)),5,(IF(6-(MATCH(E73,Quest73,0))=0,\"N/A\",6-(MATCH(E73,Quest73,0)))))))","v":4},"Does the manufacturing process improvement continually focus upon control and reduction of variation in product characteristics and manufacturing process parameters?  Do they use:\n· Value Stream Mapping\n· SPC Data \n· Pareto Analysis \n· Capability Studies   \n",null,"Adequate tools for the commodity used - minimum of Pareto analysis used that shows evidence of driving improvements. SDE to make judgment based on commodity and product to what level of tools have to be used.","Pareto analysis and capability studies used in analysis.  Some SPC data utilized as well.",null,null,null,{"$f":"B73","v":4},null,null,{"$f":"B73","v":4},{"$f":"M73","v":4}]
[6,null,"Customer Satisfaction"]
["GSQM 6.0",{"$f":"IF(E75=\"\",\"\",(IF(ISERROR(MATCH(E75,Quest75,0)),5,(IF(6-(MATCH(E75,Quest75,0))=0,\"N/A\",6-(MATCH(E75,Quest75,0)))))))","v":4},"Is there a method of measuring their performance against customer expectations?  Does it include the following:\n· Customer Complaints (SCAR's)\n· On Time Delivery (delivery performance)\n· DPPM (part quality performance)\n· Lead Time \n· Warranty and Field Returns\n- Major Disruptions\n",null,"Performance metrics are Extensive, tangible, readily available and displayed at function and level and are controlled Manually. An indicator of performance against the defined goals must be available for each function. (Manual Display, updated regularly)","Internal and external DPPMs + OTD tracked by location and reported monthly. Additionally, weekly reporting and review at top management staff meetings.",null,null,null,{"$f":"B75","v":4},null,null,{"$f":"B75","v":4},{"$f":"M75","v":4}]
[7,null,"Global Logistics"]
["GSQM 7.0a",{"$f":"IF(E77=\"\",\"\",(IF(ISERROR(MATCH(E77,Quest77,0)),5,(IF(6-(MATCH(E77,Quest77,0))=0,\"N/A\",6-(MATCH(E77,Quest77,0)))))))","v":4},"Does the supplier understand IR logistics chain and forecast? Does the supplier have and maintain clearly defined safety stocks calculation methods?\n",null,"There's the updated customer forecast. The production plan and inventory are corresponding to customer forecast. ","Defined and maintained in FIT",null,null,null,{"$f":"B77","v":4},null,null,{"$f":"B77","v":4},{"$f":"M77","v":4}]
["GSQM 7.0b",{"$f":"IF(E78=\"\",\"\",(IF(ISERROR(MATCH(E78,Quest78,0)),5,(IF(6-(MATCH(E78,Quest78,0))=0,\"N/A\",6-(MATCH(E78,Quest78,0)))))))","v":4},"Are Capacity & production Planning discussed during a daily meeting? Are customer requirements taken into consideration?\n",null,"The capacity and production planning are reviewed daily. Customer requirement are reviewed by appropriate management.","Daily production/shipping call at all locations.",null,null,null,{"$f":"B78","v":4},null,null,{"$f":"B78","v":4},{"$f":"M78","v":4}]
["GSQM 7.0c",{"$f":"IF(E79=\"\",\"\",(IF(ISERROR(MATCH(E79,Quest79,0)),5,(IF(6-(MATCH(E79,Quest79,0))=0,\"N/A\",6-(MATCH(E79,Quest79,0)))))))","v":4},"Detailed capacity plan covers complete process lead time including lead-times of purchases of raw material for production? (Short term) \n\nIs there a Mid/ long term capacity plan? What is time horizon?  Is the suppliers strategic production Business plan aligned with this capacity plan?\n",null,"Clear Procedure in QMS, with weekly monitoring and corrective/preventive actions in place. Clear forecasts to suppliers and capacity assessment","Productivity statistics are tracked and monitored relative to capacity planning. This is a manual process and focus is always on lines/plants that are closest to max capacity.",null,null,null,{"$f":"B79","v":4},null,null,{"$f":"B79","v":4},{"$f":"M79","v":4}]
[null,null,"Environmental Protection"]
["ENV1","G","Does the supplier respond to the Carbon Disclosure Project's Investor Request?",null,"NO",null,null,null,null,null,null,null,{"$f":"IF(B81<>0,B81,\"\")","v":"G"}]
["ENV2","G","Does the supplier have a program for tracking and managing energy use?",null,"NO",null,null,null,null,null,null,null,"G"]
["ENV3","G","Does the supplier have a program for tracking and managing water use?",null,"YES",null,null,null,null,null,null,null,"G"]
["ENV4","G","Does the supplier have a program for tracking and managing hazardous waste? (as locally defined by country laws)",null,"YES",null,null,null,null,null,null,null,"G"]
["ENV5","G","Does the supplier have a program for tracking and managing non-hazardous waste?",null,"YES",null,null,null,null,null,null,null,"G"]
["ENV6","G","Is the supplier's facility located in areas which are considered to be a region of medium high, high or extremely high risk with regard to water availability, according to the WBCSD global water stress map?\n",null,"NO",null,null,null,null,null,null,null,"G"]
[null,null,"Human Rights and Labor Relations",null,null,null,null,null,null,null,null,null,{"$f":"IF(B87<4, \" \", B87)","v":" "}]
["HRI1","G","Does the supplier hire and pay all of its employees at or above the local law requirements including compliance with wages rates, hour law, and legally mandated benefits?\n",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B88<>0,B88,\"\")","v":"G"}]
["HRI2","G","Does the supplier refrain from employing prison or forced labor?",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B89<>0,B89,\"\")","v":"G"}]
["HRI3","G","Does the supplier have any major social controversies, fines or settlements relating to labor, health and safety issues?\n",null,"NO",null,null,null,null,null,null,null,{"$f":"IF(B90<>0,B90,\"\")","v":"G"}]
[null,null,"Cyber Security",null,null,null,null,null,null,null,null,null,{"$f":"IF(B91<4, \" \", B91)","v":" "}]
["CYB1","G","Does the supplier have a fire wall on the IT server system? Subscription in place to keep software updated?",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B92<>0,B92,\"\")","v":"G"}]
["CYB2","G","Does supplier have virus protection system, with subscription and full update, on the computers / servers?",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B93<>0,B93,\"\")","v":"G"}]
["CYB3","G","How would Ingersoll Rand documentation, like drawings and specifications, that we share with the supplier be protected from unauthorized use?\n",null,"They would be stored on a server and have security permissions set up to restrict access. ",null,null,null,null,null,null,null,{"$f":"IF(B94<>0,B94,\"\")","v":"G"}]
[null,null,"Product Compliance",null,null,null,null,null,null,null,null,null,{"$f":"IF(B95<4, \" \", B95)","v":" "}]
["PRO1","G","Are the supplier's products it manufactures free of substances of very high concern, as defined in the European Union's REACH regulations?\nIf no, has the supplier taken all necessary actions to notify its customers?\n",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B96<>0,B96,\"\")","v":"G"}]
["PRO2","G","Are the supplier's products it manufactures in compliance with Hazardous substance regulations such as TSCA and REACH?\n",null,"YES",null,null,null,null,null,null,null,{"$f":"IF(B97<>0,B97,\"\")","v":"G"}]
[null,null,"Miscellaneous "]
["MIS1","G","Is the supplier currently manufacturing or will be manufacturing a new part or product that is different from suppliers' normal production commodity?    Type \"Yes\" or \"No\" in the comments section.",null,"NO",null,null,null,null,null,null,null,{"$f":"IF(B99<>0,B99,\"\")","v":"G"}]
["MIS2","G","Does/will manufacturing of the IR part involve a new type of manufacturing process at this particular supplier facility?  Type \"Yes\" or \"No\" in the comments section.",null,"NO",null,null,null,null,null,null,null,{"$f":"IF(B100<>0,B100,\"\")","v":"G"}]
["MIS3","G","Is this a new plant location or has there been a major facility re-arrangement in the last year?  Type \"Yes\" or \"No\" in the comments section.\n",null,"YES","Addition of sixth laser and third press brake in Q4 2018.",null,null,null,null,null,null,{"$f":"IF(B101<>0,B101,\"\")","v":"G"}]
["MIS4","G","Are there any ISO9001 certification and/or ISO14001 issues outstanding at the manufacturing location or with suppliers?  Type \"Yes\" or \"No\" in the comments section.",null,"NO",null,null,null,null,null,null,null,{"$f":"IF(B102<>0,B102,\"\")","v":"G"}]
[]
[]
[null,"GUIDANCE: TO INCLUDE AT LEAST ONE LEADERSHIP CONTACT AND MINIMUM ONE AUDIT CONTACT and CATEGORY MANAGER."]
[null,"CONTACTS","NAME",null,"TITLE","PHONE ","E-MAIL"]
[null,null,"Brian P. Smith",null,"Quality Manager - Central Region","419-571-0218","bsmith@jemisonmetals.com"]
[null,null,"Stephen Ferree",null,"Territory Manager","336-906-3617","sferree@jemisonmetals.com"]
[null,null,"Rick Rowland",null,"SR VP Quality & Engineering","205-986-6627","rrowland@jemisonmetals.com"]
[null,null,"Harrison Christian",null,"CM","704-655-5615","Harrison.Christian@irco.com",null,null,null,null,"Document Revision:",6]
[null,null,null,null,null,null,null,null,null,null,null,"Release Date:           ","2018-07-09"]

{"sheet":"CA Plan (optional)","index":3,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[[99,3,99,8],[51,3,51,8],[54,3,54,8],[58,3,58,8],[64,3,64,8],[70,3,70,8],[72,3,72,8],[83,3,83,8],[76,3,76,8],[87,3,87,8],[91,3,91,8],[94,3,94,8],[48,3,48,8],[0,4,0,5],[7,3,7,8],[12,3,12,8],[16,3,16,8],[18,3,18,8],[22,3,22,8],[24,3,24,8],[27,3,27,8],[33,3,33,8],[39,3,39,8],[44,3,44,8]]}
[null,null,null,null,"OSA action plan"]
[]
[null,null,null,"Supplier Name:",{"$f":"IF('OSA Questionnaire'!C3=0,\" \",'OSA Questionnaire'!C3)","v":"Jemison Metals"},"CSID:",{"$f":"IF('OSA Questionnaire'!E3=0,\"\",'OSA Questionnaire'!E3)","v":"8071879"}]
[null,null,null,"Supplier Location:",{"$f":"IF('OSA Questionnaire'!C6=0,\" \",'OSA Questionnaire'!C6)","v":"Gadsden, AL"}]
[]
[]
[3,"GSQM element","Status                                    G/Y/R","Assessment Questionnaire","Objective Evidence and/or Comments","Further comments to be given by SDE where needed","Action Plan \nand/or Comments \n(if score less than 4)","Due Date","Responsible Person's Name "]
[null,2,null,"General Supplier Requirements"]
[4,"GSQM 2.1a",{"$f":"IF('OSA Questionnaire'!B12<4,'OSA Questionnaire'!B12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!C12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!E12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!F12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!G12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!H12,\"\")","v":""},{"$f":"IF(C9<4,'OSA Questionnaire'!I12,\"\")","v":""}]
[5,"GSQM 2.1b",{"$f":"IF('OSA Questionnaire'!B13<4,'OSA Questionnaire'!B13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!C13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!E13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!F13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!G13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!H13,\"\")","v":""},{"$f":"IF(C10<4,'OSA Questionnaire'!I13,\"\")","v":""}]
[null,"GSQM 2.1c",{"$f":"IF('OSA Questionnaire'!B14<4,'OSA Questionnaire'!B14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!C14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!E14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!F14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!G14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!H14,\"\")","v":""},{"$f":"IF(C11<4,'OSA Questionnaire'!I14,\"\")","v":""}]
[null,"GSQM 2.1d",{"$f":"IF('OSA Questionnaire'!B15<4,'OSA Questionnaire'!B15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!C15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!E15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!F15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!G15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!H15,\"\")","v":""},{"$f":"IF(C12<4,'OSA Questionnaire'!I15,\"\")","v":""}]
[null,2.4,null,"Documented Information"]
[null,"GSQM 2.4",{"$f":"IF('OSA Questionnaire'!B17<4,'OSA Questionnaire'!B17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!C17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!E17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!F17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!G17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!H17,\"\")","v":""},{"$f":"IF(C14<4,'OSA Questionnaire'!I17,\"\")","v":""}]
[null,"GSQM 2.5a",{"$f":"IF('OSA Questionnaire'!B18<4,'OSA Questionnaire'!B18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!C18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!E18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!F18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!G18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!H18,\"\")","v":""},{"$f":"IF(C15<4,'OSA Questionnaire'!I18,\"\")","v":""}]
[null,"GSQM 2.5b",{"$f":"IF('OSA Questionnaire'!B19<4,'OSA Questionnaire'!B19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!C19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!E19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!F19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!G19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!H19,\"\")","v":""},{"$f":"IF(C16<4,'OSA Questionnaire'!I19,\"\")","v":""}]
[null,2.7,null,"Risk Assessment & Contingency Plans"]
[null,"GSQM 2.7",{"$f":"IF('OSA Questionnaire'!B21<4,'OSA Questionnaire'!B21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!C21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!E21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!F21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!G21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!H21,\"\")","v":""},{"$f":"IF(C18<4,'OSA Questionnaire'!I21,\"\")","v":""}]
[null,2.8,null,"Environmental, Health and Safety Compliance"]
[null,"GSQM 2.8a",{"$f":"IF('OSA Questionnaire'!B23<4,'OSA Questionnaire'!B23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!C23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!E23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!F23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!G23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!H23,\"\")","v":""},{"$f":"IF(C20<4,'OSA Questionnaire'!I23,\"\")","v":""}]
[null,"GSQM 2.8b",{"$f":"IF('OSA Questionnaire'!B24<4,'OSA Questionnaire'!B24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!C24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!E24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!F24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!G24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!H24,\"\")","v":""},{"$f":"IF(C21<4,'OSA Questionnaire'!I24,\"\")","v":""}]
[null,"GSQM 2.8c",{"$f":"IF('OSA Questionnaire'!B25<4,'OSA Questionnaire'!B25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!C25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!E25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!F25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!G25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!H25,\"\")","v":""},{"$f":"IF(C22<4,'OSA Questionnaire'!I25,\"\")","v":""}]
[null,2.9,null,"Cleanliness of Premises"]
[null,"GSQM 2.9a",{"$f":"IF('OSA Questionnaire'!B27<4,'OSA Questionnaire'!B27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!C27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!E27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!F27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!G27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!H27,\"\")","v":""},{"$f":"IF(C24<4,'OSA Questionnaire'!I27,\"\")","v":""}]
[null,"2.10",null,"Training"]
[null,"GSQM 2.10a",{"$f":"IF('OSA Questionnaire'!B29<4,'OSA Questionnaire'!B29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!C29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!E29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!F29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!G29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!H29,\"\")","v":""},{"$f":"IF(C26<4,'OSA Questionnaire'!I29,\"\")","v":""}]
[null,"GSQM 2.10b",{"$f":"IF('OSA Questionnaire'!B30<4,'OSA Questionnaire'!B30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!C30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!E30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!F30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!G30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!H30,\"\")","v":""},{"$f":"IF(C27<4,'OSA Questionnaire'!I30,\"\")","v":""}]
[null,2.12,null,"Sub-supplier management"]
[null,"GSQM 2.12a",{"$f":"IF('OSA Questionnaire'!B32<4,'OSA Questionnaire'!B32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!C32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!E32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!F32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!G32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!H32,\"\")","v":""},{"$f":"IF(C29<4,'OSA Questionnaire'!I32,\"\")","v":""}]
[null,"GSQM 2.12b",{"$f":"IF('OSA Questionnaire'!B33<4,'OSA Questionnaire'!B33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!C33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!E33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!F33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!G33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!H33,\"\")","v":""},{"$f":"IF(C30<4,'OSA Questionnaire'!I33,\"\")","v":""}]
[null,"GSQM 2.12c",{"$f":"IF('OSA Questionnaire'!B34<4,'OSA Questionnaire'!B34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!C34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!E34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!F34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!G34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!H34,\"\")","v":""},{"$f":"IF(C31<4,'OSA Questionnaire'!I34,\"\")","v":""}]
[null,"GSQM 2.12d",{"$f":"IF('OSA Questionnaire'!B35<4,'OSA Questionnaire'!B35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!C35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!E35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!F35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!G35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!H35,\"\")","v":""},{"$f":"IF(C32<4,'OSA Questionnaire'!I35,\"\")","v":""}]
[null,"GSQM 2.12e",{"$f":"IF('OSA Questionnaire'!B36<4,'OSA Questionnaire'!B36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!C36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!E36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!F36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!G36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!H36,\"\")","v":""},{"$f":"IF(C33<4,'OSA Questionnaire'!I36,\"\")","v":""}]
[null,4,null,"Advanced Quality Planning"]
[null,"GSQM 4.1",{"$f":"IF('OSA Questionnaire'!B38<4,'OSA Questionnaire'!B38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!C38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!E38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!F38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!G38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!H38,\"\")","v":""},{"$f":"IF(C35<4,'OSA Questionnaire'!I38,\"\")","v":""}]
[null,"GSQM 4.2",{"$f":"IF('OSA Questionnaire'!B39<4,'OSA Questionnaire'!B39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!C39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!E39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!F39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!G39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!H39,\"\")","v":""},{"$f":"IF(C36<4,'OSA Questionnaire'!I39,\"\")","v":""}]
[null,"GSQM 4.3",{"$f":"IF('OSA Questionnaire'!B40<4,'OSA Questionnaire'!B40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!C40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!E40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!F40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!G40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!H40,\"\")","v":""},{"$f":"IF(C37<4,'OSA Questionnaire'!I40,\"\")","v":""}]
[null,"GSQM 4.4a",{"$f":"IF('OSA Questionnaire'!B41<4,'OSA Questionnaire'!B41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!C41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!E41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!F41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!G41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!H41,\"\")","v":""},{"$f":"IF(C38<4,'OSA Questionnaire'!I41,\"\")","v":""}]
[null,"GSQM 4.4b",{"$f":"IF('OSA Questionnaire'!B42<4,'OSA Questionnaire'!B42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!C42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!E42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!F42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!G42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!H42,\"\")","v":""},{"$f":"IF(C39<4,'OSA Questionnaire'!I42,\"\")","v":""}]
[null,4.5,null,"Product Approval Process"]
[null,"GSQM 4.5a",{"$f":"IF('OSA Questionnaire'!B44<4,'OSA Questionnaire'!B44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!C44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!E44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!F44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!G44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!H44,\"\")","v":""},{"$f":"IF(C41<4,'OSA Questionnaire'!I44,\"\")","v":""}]
[null,"GSQM 4.5b",{"$f":"IF('OSA Questionnaire'!B45<4,'OSA Questionnaire'!B45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!C45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!E45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!F45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!G45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!H45,\"\")","v":""},{"$f":"IF(C42<4,'OSA Questionnaire'!I45,\"\")","v":""}]
[null,"GSQM 4.5c",{"$f":"IF('OSA Questionnaire'!B46<4,'OSA Questionnaire'!B46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!C46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!E46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!F46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!G46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!H46,\"\")","v":""},{"$f":"IF(C43<4,'OSA Questionnaire'!I46,\"\")","v":""}]
[null,"GSQM 4.5d",{"$f":"IF('OSA Questionnaire'!B47<4,'OSA Questionnaire'!B47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!C47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!E47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!F47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!G47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!H47,\"\")","v":""},{"$f":"IF(C44<4,'OSA Questionnaire'!I47,\"\")","v":""}]
[null,4.7,null,"Product Monitoring"]
[null,"GSQM 4.7a",{"$f":"IF('OSA Questionnaire'!B49<4,'OSA Questionnaire'!B49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!C49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!E49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!F49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!G49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!H49,\"\")","v":""},{"$f":"IF(C46<4,'OSA Questionnaire'!I49,\"\")","v":""}]
[null,"GSQM 4.7b",{"$f":"IF('OSA Questionnaire'!B50<4,'OSA Questionnaire'!B50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!C50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!E50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!F50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!G50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!H50,\"\")","v":""},{"$f":"IF(C47<4,'OSA Questionnaire'!I50,\"\")","v":""}]
[null,"GSQM 4.7c",{"$f":"IF('OSA Questionnaire'!B51<4,'OSA Questionnaire'!B51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!C51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!E51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!F51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!G51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!H51,\"\")","v":""},{"$f":"IF(C48<4,'OSA Questionnaire'!I51,\"\")","v":""}]
[null,4.8,null,"Change Control"]
[null,"GSQM 4.8a",{"$f":"IF('OSA Questionnaire'!B53<4,'OSA Questionnaire'!B53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!C53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!E53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!F53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!G53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!H53,\"\")","v":""},{"$f":"IF(C50<4,'OSA Questionnaire'!I53,\"\")","v":""}]
[null,"GSQM 4.8b",{"$f":"IF('OSA Questionnaire'!B54<4,'OSA Questionnaire'!B54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!C54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!E54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!F54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!G54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!H54,\"\")","v":""},{"$f":"IF(C51<4,'OSA Questionnaire'!I54,\"\")","v":""}]
[null,4.9000000000000004,null,"Preventive & Predictive maintenance"]
[null,"GSQM 4.9",{"$f":"IF('OSA Questionnaire'!B56<4,'OSA Questionnaire'!B56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!C56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!E56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!F56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!G56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!H56,\"\")","v":""},{"$f":"IF(C53<4,'OSA Questionnaire'!I56,\"\")","v":""}]
[null,"GSQM 4.10",{"$f":"IF('OSA Questionnaire'!B57<4,'OSA Questionnaire'!B57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!C57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!E57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!F57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!G57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!H57,\"\")","v":""},{"$f":"IF(C54<4,'OSA Questionnaire'!I57,\"\")","v":""}]
[null,4.1100000000000003,null,"Identification & Traceability"]
[null,"GSQM 4.11a",{"$f":"IF('OSA Questionnaire'!B59<4,'OSA Questionnaire'!B59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!C59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!E59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!F59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!G59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!H59,\"\")","v":""},{"$f":"IF(C56<4,'OSA Questionnaire'!I59,\"\")","v":""}]
[null,"GSQM 4.11b",{"$f":"IF('OSA Questionnaire'!B60<4,'OSA Questionnaire'!B60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!C60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!E60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!F60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!G60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!H60,\"\")","v":""},{"$f":"IF(C57<4,'OSA Questionnaire'!I60,\"\")","v":""}]
[null,"GSQM 4.12",{"$f":"IF('OSA Questionnaire'!B61<4,'OSA Questionnaire'!B61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!C61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!E61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!F61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!G61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!H61,\"\")","v":""},{"$f":"IF(C58<4,'OSA Questionnaire'!I61,\"\")","v":""}]
[null,5,null,"Non Conforming Product"]
[null,"GSQM 5.1a",{"$f":"IF('OSA Questionnaire'!B63<4,'OSA Questionnaire'!B63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!C63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!E63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!F63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!G63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!H63,\"\")","v":""},{"$f":"IF(C60<4,'OSA Questionnaire'!I63,\"\")","v":""}]
[null,"GSQM 5.1b",{"$f":"IF('OSA Questionnaire'!B64<4,'OSA Questionnaire'!B64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!C64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!E64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!F64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!G64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!H64,\"\")","v":""},{"$f":"IF(C61<4,'OSA Questionnaire'!I64,\"\")","v":""}]
[null,"GSQM 5.1c",{"$f":"IF('OSA Questionnaire'!B65<4,'OSA Questionnaire'!B65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!C65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!E65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!F65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!G65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!H65,\"\")","v":""},{"$f":"IF(C62<4,'OSA Questionnaire'!I65,\"\")","v":""}]
[null,"GSQM 5.1d",{"$f":"IF('OSA Questionnaire'!B66<4,'OSA Questionnaire'!B66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!C66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!E66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!F66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!G66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!H66,\"\")","v":""},{"$f":"IF(C63<4,'OSA Questionnaire'!I66,\"\")","v":""}]
[null,"GSQM 5.2",{"$f":"IF('OSA Questionnaire'!B67<4,'OSA Questionnaire'!B67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!C67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!E67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!F67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!G67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!H67,\"\")","v":""},{"$f":"IF(C64<4,'OSA Questionnaire'!I67,\"\")","v":""}]
[null,5.3,null,"Problem Solving"]
[null,"GSQM 5.3a",{"$f":"IF('OSA Questionnaire'!B69<4,'OSA Questionnaire'!B69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!C69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!E69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!F69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!G69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!H69,\"\")","v":""},{"$f":"IF(C66<4,'OSA Questionnaire'!I69,\"\")","v":""}]
[null,"GSQM 5.3b",{"$f":"IF('OSA Questionnaire'!B70<4,'OSA Questionnaire'!B70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!C70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!E70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!F70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!G70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!H70,\"\")","v":""},{"$f":"IF(C67<4,'OSA Questionnaire'!I70,\"\")","v":""}]
[null,"GSQM 5.3c",{"$f":"IF('OSA Questionnaire'!B71<4,'OSA Questionnaire'!B71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!C71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!E71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!F71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!G71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!H71,\"\")","v":""},{"$f":"IF(C68<4,'OSA Questionnaire'!I71,\"\")","v":""}]
[null,"GSQM 5.5",{"$f":"IF('OSA Questionnaire'!B72<4,'OSA Questionnaire'!B72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!C72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!E72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!F72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!G72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!H72,\"\")","v":""},{"$f":"IF(C69<4,'OSA Questionnaire'!I72,\"\")","v":""}]
[null,"GSQM 5.6",{"$f":"IF('OSA Questionnaire'!B73<4,'OSA Questionnaire'!B73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!C73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!E73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!F73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!G73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!H73,\"\")","v":""},{"$f":"IF(C70<4,'OSA Questionnaire'!I73,\"\")","v":""}]
[null,6,null,"Customer Satisfaction"]
[null,"GSQM 6.0",{"$f":"IF('OSA Questionnaire'!B75<4,'OSA Questionnaire'!B75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!C75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!E75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!F75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!G75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!H75,\"\")","v":""},{"$f":"IF(C72<4,'OSA Questionnaire'!I75,\"\")","v":""}]
[null,7,null,"Global Logistics"]
[null,"GSQM 7.0a",{"$f":"IF('OSA Questionnaire'!B77<4,'OSA Questionnaire'!B77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!C77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!E77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!F77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!G77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!H77,\"\")","v":""},{"$f":"IF(C74<4,'OSA Questionnaire'!I77,\"\")","v":""}]
[null,"GSQM 7.0b",{"$f":"IF('OSA Questionnaire'!B78<4,'OSA Questionnaire'!B78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!C78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!E78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!F78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!G78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!H78,\"\")","v":""},{"$f":"IF(C75<4,'OSA Questionnaire'!I78,\"\")","v":""}]
[null,"GSQM 7.0c",{"$f":"IF('OSA Questionnaire'!B79<4,'OSA Questionnaire'!B79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!C79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!E79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!F79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!G79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!H79,\"\")","v":""},{"$f":"IF(C76<4,'OSA Questionnaire'!I79,\"\")","v":""}]
[null,null,null,"Environmental Protection"]
[null,"ENV1",{"$f":"'OSA Questionnaire'!B81","v":"G"}]
[null,"ENV2",{"$f":"'OSA Questionnaire'!B82","v":"G"}]
[null,"ENV3",{"$f":"'OSA Questionnaire'!B83","v":"G"}]
[null,"ENV4",{"$f":"'OSA Questionnaire'!B84","v":"G"}]
[null,"ENV5",{"$f":"'OSA Questionnaire'!B85","v":"G"}]
[null,"ENV6",{"$f":"'OSA Questionnaire'!B86","v":"G"}]
[null,null,null,"Human Rights and Labor Relations"]
[null,"HRI1",{"$f":"'OSA Questionnaire'!B88","v":"G"}]
[null,"HRI2",{"$f":"'OSA Questionnaire'!B89","v":"G"}]
[null,"HRI3",{"$f":"'OSA Questionnaire'!B90","v":"G"}]
[null,null,null,"Cyber Security"]
[null,"CYB1",{"$f":"'OSA Questionnaire'!B92","v":"G"}]
[null,"CYB2",{"$f":"'OSA Questionnaire'!B93","v":"G"}]
[null,"CYB3",{"$f":"'OSA Questionnaire'!B94","v":"G"}]
[null,null,null,"Product Compliance"]
[null,"PRO1",{"$f":"'OSA Questionnaire'!B96","v":"G"}]
[null,"PRO2",{"$f":"'OSA Questionnaire'!B97","v":"G"}]
[null,null,null,"Miscellaneous "]
[null,"MIS1",{"$f":"'OSA Questionnaire'!B99","v":"G"}]
[null,"MIS2",{"$f":"'OSA Questionnaire'!B100","v":"G"}]
[null,"MIS3",{"$f":"'OSA Questionnaire'!B101","v":"G"}]
[null,"MIS4",{"$f":"'OSA Questionnaire'!B102","v":"G"}]

{"sheet":"Remarks (optional)","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,12,7],[14,0,18,7],[13,0,13,7],[7,0,7,7],[2,7,5,7]]}
[null,null,null,"Initial OSA Assessment Remarks",null,null,null,"Initial"]
[null,null,null,null,null,null,null,"OSA Score:"]
["Supplier Name:",null,{"$f":"IF('OSA Questionnaire'!C3>0,'OSA Questionnaire'!C3,\" \")","v":"Jemison Metals"},"CSID:",{"$f":"IF('OSA Questionnaire'!E3>0,'OSA Questionnaire'!E3,\" \")","v":"8071879"},"Audit date:",{"$f":"IF('OSA Questionnaire'!G3>0,'OSA Questionnaire'!G3,\" \")","v":"April 17 2019"},{"$f":"'OSA Questionnaire'!I3:I6","v":0.80400000000000005}]
[]
[]
["Supplier Location:",null,{"$f":"IF('OSA Questionnaire'!C6>0,'OSA Questionnaire'!C6,\" \")","v":"Gadsden, AL"},"Commodity:",{"$f":"IF('OSA Questionnaire'!E6>0,'OSA Questionnaire'!E6,\" \")","v":"Metal Fabrication"},"Auditor:",{"$f":"IF('OSA Questionnaire'!G6>0,'OSA Questionnaire'!G6,\" \")","v":"Mark Hinkefent"}]
[]
["Observations / Summary:-"]
[]
[]
[]
[]
[]
["Improvement Opportunities:-"]

{"sheet":"2.1a","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier have and maintain an effective management system? \n(IATF 16949 / ISO 9001 ed.2015 / ISO 14001 / OHSAS 18001)"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.1a  /  ISO 4.1/4.2/4.3/"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Third party certificates on various Management systems:\nIATF 16949 / ISO 9001 ed.2015 / ISO 14001 / OHSAS 18001","- QMS\n- Management Review Meeting","- Validity dates of the different certificates\n- Look for QMS revision(s) / evaluation by the top management to validate QMS is effective."]
[]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier is IATF 16949, ISO 14001 and OHSAS 18001 certified"]
[4,"Supplier is ISO 9001:2008 or ISO 9001:2015 and ISO 14001 or OHSAS 18001 certified\nor: Supplier has an effective and properly maintained QMS in place, but is not certified"]
[3,"Supplier has QMS in place, is not certified and shows minor gaps within the documented information"]
[2,"Supplier has a management system in place and shows major gaps within the documented information"]
[1,"Supplier does not have any management system in place"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.1b","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Has the top management reviewed the performance regularly versus target? Have actions been defined? \n- Quality Objectives\n- Management review frequency"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.1b  ISO 9.3/9.3.1/9.3.2/9.3.3"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Check if the Management's responsibility if defined?\n Is there a fixed frequency and fixed Agenda for Management Review Meeting (MRM)? \nDoes the Agenda Cover the Quality Objectives of each function?","Quality Manual ","Check the MRM Agenda and its linkage to Quality Objectives of each Function. \nCheck if there is a fixed frequency for MRM: Monthly, Quarterly, Half yearly / annually etc."]
[null,"Has the MRM been conducted as per the frequency?\nAre open actions from Previous MRM reviewed?","MRM Plan, MRM Attendance, MRM minutes","Check minutes of last 4 MRM (if conducted) and find out if the MRM was conducted as per the frequency.\nFind out how much time is allotted to each function and gauge if the review is sufficiently done.\nAlso find out that open actions from last MRM are tracked separately by MR/individual Functions and closed within the time line. Check if the closure is monitored against the target date and not from one MRM review to other."]
[null,"Is the MRM effective?","MRM Minutes","Find out if there are any actions which are open for more than 2 MRM.\nCheck if there is positive trend in the targets and if there is adverse trend, analysis of the Gap and commitment from function / Management to close the gap is available?"]
[]
[null,"Scoring Pattern:- "]
[5,"MRM is conducted with a frequency of max. 6 Months and all the Quality Objectives are reviewed extensively. The agenda and minutes are available online in real time. Trends are positive and are monitored against the targets and also Y-O-Y/ MRM over MRM. None of the action from the previous MRMs are past due.\n"]
[4,"MRM conducted (preferable once per year), all the Q-objectives are reviewed. Clear agenda & MOM's available. Trends monitored against the targets and also Y-O-Y/ MRM over MRM. Gap Analysis are available for  actions which are past due/off target."]
[3,"MRM is conducted regularly and agenda is not very clearly defined, there are actions open from previous MRMs which are not closed in due time."]
[2,"MRM is not conducted effectively and no agenda / minutes are available."]
[1,"MRM is not conducted."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.1c","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Are systems and internal/external audit results periodically reviewed by management?\n· Agenda and meeting minutes from the last management review "]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM2.1c  ISO 9.2/9.2.1/9.2.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Are management reviews well defined and effectively conducted.","Quality Dept.","1. Check the procedure for MR, if the frequency, inputs and outputs are clearly defined.\n2. Check the MR plan to see if the frequency follows the requirements in the procedure\n3. Check the latest 2 MR minutes to see if all the inputs and outputs are covered. "]
[null,"Are inputs and outputs of the management review clearly defined and reviewed?","Quality Dept.","The input to management review shall include information on \na) results of audits, \nb) customer feedback, \nc) process performance and product conformity, \nd) status of preventive and corrective actions, \ne) follow-up actions from previous management reviews, \nf) changes that could affect the quality management system\ng) recommendations for improvement.\nThe output from the management review shall include any decisions and actions related to： \na) improvement of the effectiveness of the quality management system and its processes, \nb) improvement of product related to customer requirements, and \nc) resource needs"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Management review including system and audit evaluation with a defined schedule are conducted, close follow up to the effectiveness of the actions implemented, on time action closing tracking. "]
[4,"Management review including system and audit evaluation minimum once per year, actions implemented - on time closed. "]
[3,"Management review including system and audit evaluation minimum once per year, past due actions "]
[2,"Periodically management reviews including system and audit evaluation, not a defined schedule, past due actions or lack of follow up"]
[1,"Management review is not including system or audits evaluation, no evidence of actions implemented as a results of the evaluation."]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.1d","index":8,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Is there an organization chart with responsibilities assigned? Is the chart up to date and are all functions related to quality and EHS staffed?\n"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.1d  ISO 5.3"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Clear Identification of responsibility and chain of command.","QM, HS&E displayed through out various functions.","Check if the Org chart is available as a controlled document and it can be linked to Quality Objectives of each function."]
[null,"Is the escalation evident?","Shop Floor, individual Function","Check if every station has a clearly defined escalation matrix with functional responsibility and contact nos. and it is evident that in crisis situation escalation will be time bound and will happen to the required level in the organization. Example: At machining there can be issues of Material Shortage, Quality Issue , Breakdown etc. expectation is for each type of crisis an escalation matrix for respective function is available."]
[null,"Is IR as a customer in focus and is protected form defective parts?","QM, Org chart","Check if there is Customer Focused support team available for IR."]
[]
[null,"Scoring Pattern:- "]
[5,"Organization chart is available with responsibilities defined up to the bottom or execution level. Escalation is clearly defined, evident and system controlled (automatic trigger). A dedicated team of quality, HS&E and delivery engineers/associates is available ensuring 24x7 support to IR. "]
[4,"Organization chart available, chart is up to date, controlled document. It  defines clear, functional responsibilities and escalations. A Quality and HS&E team is present. Customer representative is available to support IR in regards Q & OTD issues."]
[3,"Organization chart is available but not does not cover all the personnel in the organization and escalation is not evident. Dedicated team is not available specifically for IR."]
[2,"Organization chart is available but responsibility and chain of command is not evident. No team  to support IR."]
[1,"Org chart is not available."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.4","index":9,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[]
[]
[null,"OSA Question","* Is the documented information supporting the management system adequate?\n- Work & Process Instructions \n- Standard Operating Procedures\n- External Documents\n- Visual Factory (KPI's, Quality Objectives,…)\n"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.4  ISO 8.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Look for SOPs, WI,  control of External Docs","Supplier Management System"]
[null,"Look for SOPs, WI,  control of External Docs, Database","Supplier Management System","Does each function have SOPs clearly stating the working method /work flow and is there a clear linkage to WI for each responsibility associated with the function?\nCan there be clear linkage defined between QO, SOP and WI?"]
[null,"Look for integration of management and business systems","Quality Objectives, KPI´s \nMDI, visual factory","Visual factory information shall be current showing the systems that are in place are in regular use posted.\nMetrics regarding productivity, safety, quality shall be current and goals met or actions worked when goals are not met"]
[null,"Customer standards and drawings, external industry standards","File storage locations, PLM system, Sales/Estimating files, Engineering department, business library or website subscription to external standards.","Customer's Testing Standards/ Material Standards, customer's drawings etc. controlled, stored and available? Is there a system sensitive to revision in customer's documents? Is there a timely cross check for any revisions?  Same is applicable for general standards like ASTM, JIS, DIN etc."]
[]
[null,"Scoring Pattern:- "]
[5,"Digital solution in place for doc control with restricted access, personnel resp. for doc. change. SOPs have clear definition of responsibility and authority. WI have clear definition of work flow and responsibilities. Electronic visual boards available with up-to-date information.",null,null,5]
[4,"Paper format or excel based doc database. SOPs have clear def. of responsibility. WI's have clear definition of work flow & responsibilities. Authorized personnel have access to all  relevant docs. Paper visual boards available.",null,null,4]
[3,"SOP's, WI's and External doc's are listed. Linkage can not be established between the SOP, WI, related Internal doc's, forms and  External Doc.'s are not checked regularly. Visual Boards available but minor gaps in updated information regarding KPI's.",null,null,3]
[2,"SOP´s, WI's and  External Documents are available but only as document merely in the records and not practiced.\nNo visual boards available",null,null,2]
[1,"Evidence that Supplier does not use SOP´s Work instruction nor does not manage External Documents.  No visual boards available",null,null,1]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.5a","index":10,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question"," Is there a process established for the control of records and system documentation?\n· Policy for control of quality records \n· Retention policy or matrix \n· Revision control process for quality documents"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.5a  ISO 4.4.1/4.4.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is there a Master List of Docs? \nHow are different documents labeled and controlled?","Quality Manual, SOPs, Records","Look if the master list covers revision control? \nClearly define the  Short Forms (Abbreviations) and check for linkage between all."]
[null,"is the Revision Control and distribution practiced? ","Master list, Issue and Obsolete Records.","Look for evidence of revised SOPs, Formats, QM .\nLook for Document retrieval, Obsolete documents and any evidence of proper disposal of obsolete documents."]
[null,"How is the retention period described? \nAre all records maintained and stored?","Master List, Actual Documents , Records Room","Look for evidence of definition of retention period. \nCheck for availability of old records where retention period is about to expire."]
[null,"Is there a system of defining and maintaining Customers documents?\nDoes Revision change / update in customer's documents trigger a change in Supplier's system?","Record Room, Customer Files, Quality Manual","Look if customer wise records / files are maintained and customer's docs are controlled.\nLook if there is a system by which there is regular check-up for update.\nLook for evidences of change in supplier's system corresponding to change / Revision in Customer's docs."]
[]
[null,"Scoring Pattern:- "]
[5,"If a Master List exists which is available on supplier's Portal / EMS and automatically defines the Revision, Retention, Distribution and control of the documents.\nFlawless system of obsoleting is present and evidence of old document removal  from system is strong.\nRecords are maintained Online as well in hard as a back up and location is effectively defined.\nCustomer Docs. like Supplier Quality Manual, Drawings, Test / material standards etc. are defined and an automated trigger is raised in case of any change in customer's docs."]
[4,"Master list available, controlled manually. Rev, retention, distribution and control of docs checked. All Records are maintained, locations of rec. defined. \nCustomer docs, SQM, drawings, mat. specs, test specs.; defined and reg. reviewed. "]
[3,"Master list, Retention, Revision etc. are controlled but evidence is available of minor non compliance like Obsolete copies available in facility etc. / customer's documents not available per latest revision."]
[2,"Documents are available but not put into practice effectively and merely present in records."]
[1,"No documents available."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.5b","index":11,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[]
[]
[null,"OSA Question","How are the customer requirements (such as GSQM, drawings, specs) communicated and cascaded into the organization?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.5b  ISO 5.1.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Current IR drawings and specifications","Supplier's portal, file server, sales/estimating files","Sample 2-3 different drawings and specifications\nCheck against IR PLM system for revisions"]
[null,"Communication of IR order requirements","Control plans, work instructions, packaging instructions, supplier drawings, MRP System","Verify critical features from drawings are in the control plan;\nVerify a production order or subassembly"]
[null,"GSQM links, awareness","Quality personnel","Verify awareness of the GQSM\nLook for incorporation of the GSQM in supplier's documentation"]
[null,"Nonconforming material due to missed requirements","Nonconforming material system, corrective action system","Any nonconforming material record or return due to missed requirements"]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has all current drawings and specifications necessary to understand the product requirements and all personnel are able to easily retrieve them.  Supplier either works directly from the drawings and specifications, or has transferred all the necessary information to their own drawings, specifications, work instructions and MRP system.  All critical features from IR are included in the suppliers work instructions and/or control plan.  The supplier is aware of the GSQM and has incorporated it into their business operating system."]
[4,"All current drawings and spec's available. However, not easily to consulted. Critical features are addressed in CP's /WI's. Drawing notes/spec's requirements are communicated via WI's, MRP system or other means.  The supplier is aware of the GSQM. "]
[3,"All drawings and spec's are available, some found not stamped or with wrong rev.  Some gaps exist in addressing critical features in the control plan, or drawing notes and specifications at the WI's /MRP system.   The supplier is not aware of the GSQM."]
[2,"Documents are available but not put into practice effectively and merely present in records.  Critical gaps in communicating IR requirements exist which may also have resulted in missed requirements"]
[1,"No documents available, supplier does not have IR drawings and specifications."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.7","index":12,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier have documented contingency plans to ensure continued operations and satisfy customer requirements? (e.g., utility interruptions, transportation, labor shortage, systems status, supplier-related issues)  Are there adequate backup systems in place?"]
[]
[null,"Reference Line no.","GSQM 2.7  ISO 8.2.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? Risk assessment? ","Quality Manual? MOM? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? Verification of the MOM's based on the risk assessment. Conclusions? Actions defined? "]
[null,"Backup possibilities? ","ERP? ","Back up possibilities defined if needed? Fixed and verified? "]
[null,"Instruction(s)? Responsibilities defined? ","Backup plan? Job descriptions? ","If backup plans are available and needed, they should be described and fixed in clear instructions. Who is responsible in case of problems occurring and actions to establish are needed? "]
[]
[null,"Scoring Pattern:- "]
[5,"Clear procedure in place and implemented. Responsibilities defined. Clear action plans available, all backups defined and validated. Backups can start up (support) in a time frame of 8 hours.     "]
[4,"Clear procedure available. Responsibilities defined. Action plans & backups defined.   "]
[3,"No procedure or instructions in place. Backups defined if necessary.  "]
[2,"No procedure in place.  Responsible defined. "]
[1,"No procedure in place.  No actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.8a","index":13,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier have a documented commitment by management to provide a safe work environment for employees and does favorable data exist to support this claim?   "]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.8a ISO 7.1.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a documented EH&S System in place?","EH&S Manual","See if the manual is current and is being used as a living document.  Look for evidence of Safety Committee reviews and or safety meetings with employees.  Look for training records indicating that employees are trained on all applicable EH&S requirements."]
[null,"Does the supplier have a documented Safety Statement from Management?","EH&S Manual","Look for a formal commitment from Management to provide a safe working environment to all employees."]
[null,"Does favorable data exist to support that the supplier is providing a safe work environment for all employees?","Recent Safety inspections/Audits in addition to the Management Review","Review all Safety Audit inspection summations and Action Plans"]
[]
[null,"Scoring Pattern:- "]
[5,"Computerized EH&S System available at all work stations including training records and MSDS Sheets.  Strong commitment from management that is demonstrated on the shop floor including posted Safety Statements. 3 years and above without a lost time accident."]
[4,"EH&S System in place including training records and MSDS Sheets.  Commitment from management that is demonstrated on the shop floor including posted Safety Statements. 12 months and above without a lost time accident."]
[3,"EH&S System in place including training records and MSDS Sheets but lapses in compliance can be found .  Some evidence of Commitment from management to the safety Program. 6 months or less without a lost time accident."]
[2,"Some evidence of a EH&S Program however not followed or implemented."]
[1,"No system / Procedure available."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.8b","index":14,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Is the supplier aware of and does it abide by all applicable Environmental Health and Safety permits required to conduct operation at the facilities of interest?  \nHow does the supplier organize them self to keep up to date with the changes in applicable legislation?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.8b  ISO 7.1.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the Supplier have a certified ISO 14000 Program implemented on-sight?","EH&S Department, HR Department, or ask any member of the Management team to point you in the right direction.","Look for a current ISO 14000 Certificate of Registration from an accredited Registrar "]
[null,"Does the Supplier have a documented but not Certified EH&S System implemented on-sight?","EH&S Department, HR Department, or ask any member of the Management team to point you in the right direction.","Look for a documented EH&S Manual and supporting documentation that the system is being adhered to on a regular basis."]
[null,"Does the Supplier follow all regulatory and state permit requirements?  ","EH&S Department, HR Department, or ask any member of the Management team to point you in the right direction.","Ask for the actual regulatory permits issued by the state or government."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier is certified to ISO 14000 and has a complete EH&S System implemented on-site.  In addition they have favorable results from the last surveillance audit."]
[4,"Supplier has a complete EH&S System implemented on-site however they are not certified to the ISO 14000 Standard"]
[3,"Supplier follows permit requirements for all applicable Environmental Health and Safety concerns however they do not have a formal EH&S System in place."]
[2,"Supplier follows some requirements for Environmental Health and Safety concerns however they show some lapses in compliance"]
[1,"No sign of compliance regarding Environmental Health and Safety requirements."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.8c","index":15,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier have a system in place to communicate safe handling information (such as Material Safety Data Sheets) for any dangerous substances contained in its facilities and/or products?"]
[]
[null,"Reference Line no.(from OSA sheet)","2.8c"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Method to capture Hazardous substances","Quality Manual","Does Supplier have a controlled procedure that guides to identify, contain and announce any hazardous substances which might be a part of the product or manufacturing agent?\nDoes it cover all substances including purchased material of all kinds for manufacturing or its aid in its scope?\nIs IMDS documentation submitted with every PPAP performed?"]
[null,"Hazardous material special storage ","Stores","Is there an exclusive storage room for dangerous substances?\nIs the access controlled? Are the MSDS docs, stored close by? "]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has controlled procedure identifying the hazardous substances and there is evidence that no products can enter the supplier's facilities without a documented MSDS. Plus supplier has a procedure to ensure that every time a new product is developed, MSDS for all components of the product and manufacturing agent are complaint. MSDS is in place/All MSDS are available online on supplier portal or as a copy on share drive."]
[4,"Supplier has procedure for controlling the MSDS documentation / Certificate for all materials are available. Hazardous Materials are clearly identified."]
[3,"Supplier is aware of MSDS requirements but its not followed for 100% of the substances being used facility."]
[2,"Supplier is not fully aware of MSDS req. and is not followed as a procedure."]
[1,"Supplier is not aware nor compliant to MSDS."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.9","index":16,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3],[7,2,9,2]]}
[]
[]
[null,"OSA Question","Are the work areas adequately organized  for the work performed (using 5S or other methods)?  \nDoes the work environment appear safe?\nIn case of laboratories are environmental conditions adequate?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.9   ISO 7.1.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is immediate safety of operators is evident?","Shop Floor and Lab, stock, incoming inspection area, raw material storage.","Check if PPE (Personal Protection Equipment) like Safety Glasses, Safety Shoes, Helmets etc. available at stations as per process requirements.\nCheck if precautions like Sensor Curtains, Double button actuated machines (Ensuring both hands are out of operating area), door closure on CNC machines etc. are present.\nCheck if hazardous chemicals are adequately labeled and securely stored?"]
[null,"Is long term health and safety of operator evident?",null,"Check if adequate illumination is there in the shop floor and lab.\nRegular health check up for eye-sight general health is done at least once per annum as a practice.\nThere is daily/weekly/monthly assessment of safety incidents done in terms of no. of incidents / hours without incident etc.\n"]
[null,"Are work places organized and 5's' is deployed.",null,"Is there a Zone marking done and \"A place for everything and Everything in its place\" evident?\nIs the housekeeping / layout management score captured by methods like radar / spider web chart etc.? "]
[]
[null,"Scoring Pattern:- "]
[5,"Entire shop floor including inspection labs have a defined layout as per 5S guideline and every object has defined place. Regular 5S audits are in place.\nSupplier adopts already the 6S program, covering Safety in addition to the 5S."]
[4,"Shop floor is well organized and seems suitable to carry out the desired process. Operators are aware of the housekeeping and layout management, without a formal 5S in place. Laboratories have an adequate environment and are properly organized."]
[3,"Basic layout is available but is not fully adhered to. Chances of minor lapses like safety measures not functioning etc. are observed."]
[2,"Layout is  available but not followed, floor is slippery, chemicals not stored safely etc."]
[1,"Layout is not available and operators are not provided with PPEs"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.10a","index":17,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Has training been provided for each job function / operation according to requirements?  Can a training matrix and current training records be provided all employees? "]
[]
[null,"Reference Line no.(from OSA sheet)","2.10a / ISO 7.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is there a procedure to identify training needs?\nIs there a mechanism to gather requirements against the visit/Goal/Quality objectives of the organization and correlate with current skill set?","Training SOP, Functional SOPs, Skill matrix","Check if each function submits \"Training need Identification\" to the training coordinator to make the annual training plan.\nCheck if Skill set of each employee is available with respective functions identifying the training needs for each individual."]
[null,"Is there a planned training schedule for the organization and is it adhered to.","Training Calendar/plan","check if month/week wise training calendar/ Training matrix is available and find plan vs actual trainings conducted. "]
[null,"Is there a mechanism to collect feedback for the training and their effectiveness.","Training feedback form, Functional managers feedback ","Check if feedback form each trainee is collected after the training and feedback on effectiveness is collected from trainee's functional manger after a due course of time."]
[]
[null,"Scoring Pattern:- "]
[5,"Training needs and training calendar are centrally controlled on EMS or enterprise portal. 100% compliance to training calendar is evident and feedback of each training is collected and effectiveness is monitored."]
[4,"Training needs are identified by each Function and accordingly training calendar is prepared. 100% compliance to training calendar is evident and feedback of each training is collected and effectiveness is monitored."]
[3,"Training calendar is available but 100% compliance is not available. Feedback is not effectively collected."]
[2,"Training calendar is available but neither it's effective nor followed."]
[1,"No training mechanism is available."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.10b","index":18,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Are process operators and inspectors trained on the work instructions for their area? \nIs evidence found during spot-check on the shop floor?"]
[]
[null,"Reference Line no.(from OSA sheet)","2.10b / ISO 7.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Awareness of the process criticality and methodology.","Interaction with Operator on Shop floor.","Notice from a distance what is being practically done on the process.\nQuestion the operator what process is being done and how is it assured that manufactured part is correct.\nGage by questioning if the operator is aware of the presence of Work Instruction and also the contents."]
[null,"Training Evidence.","Training Records.","Check if a process wise training record or On Job Training record is available. "]
[null,"Skill evaluation.","Skill Matrix","Check if the skill matrix is present and available on the process line and it clearly defines the skill level process wise."]
[]
[null,"Scoring Pattern:- "]
[5,"If the Work Instructions are dynamic and digital in nature and are clearly visible on the process and operator is fully aware of  the process and critical features. Skill Matrix and training evidence are available, system to ensure only skilled operator can be deployed on the station."]
[4,"If work instructions are displayed in hard form and operator is fully aware of  the process and critical features. Skill matrix and training evidence are available."]
[3,"Operators are aware of the Work Instructions and compliance can be found with minor lapses (WI vs Actual)."]
[2,"Work Instructions are not being followed and operator is not aware of the criticality or methodology."]
[1,"No Work instructions are available and operators not trained for the process criticality."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.12a","index":19,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,1,17,3],[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Is there a formally documented system used to select and manage suppliers through advanced  evaluation or by review of quality performance?  (Verify if approved suppliers list exists)\nHow do they manage directed suppliers?\n"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 2.12a/ ISO 8.4.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a documented procedure for supplier selection?","Quality Manual","Review procedure and look for supporting documentation that it is currently being followed."]
[null,"Can they show proof as to how they are managing supplier performance and Quality?","Purchasing department, and Management Review","Look for records of supplier PPM, On-Time delivery, and Quality performance, check if poor performing suppliers are identified and improvement / back up plan for those suppliers is evident."]
[null,"Can they show an Approved Supplier List","Purchasing Department","Review Approved Suppliers List and make sure it is current."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has an electronic system to track all suppliers including a Approved Supplier List that is linked to the suppliers performance.  Monthly updates are added to the system tracking supplier performance including PPM's, On-Time Delivery and Quality Performance."]
[4,"Supplier has a manual system to track all suppliers including a Approved Supplier List.  Monthly updates are tracked on supplier performance including PPM's, On-Time Delivery and Quality Performance."]
[3,"Supplier has a manual system in place to track supplier performance however minor lapses in compliance can be found"]
[2,"Supplier has a system in place to track supplier performance however major lapses in compliance can be found"]
[1,"Supplier has no system in place to track supplier performance."]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.12b","index":20,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,17,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3]]}
[]
[]
[null,"OSA Question","* Does the supplier have a process in place to cascade IR GSQM requirements to their suppliers?"]
[]
[null,"Reference Line no.(from OSA sheet)","2.12b"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Evidence that the supplier has communicated the GSQM aspects to their supply base.","Supply agreements, supplier on-site assessments, PO requirements, PPAP, SDR and SPDCR. ","Any documentation that shows the GSQM was communicated and incorporated into supplier requirements."]
[null,"On-site assessments, supplier self assessments, supplier metrics or scorecards","Management review minutes, MDI boards, supplier quality records, nonconforming material records, supplier corrective action systematic","Recent management review minutes, recent SCAR, any published scorecards or metrics"]
[]
[]
[null,"Scoring Pattern:- "]
[5," The IR GSQM is communicated to their suppliers and evidence exists that key aspects are complied with, including APQP and a solid communication chain for product and process changes.  Recent PPAPs validate the supplier understanding of the key requirements. All subcontracted component have approved PPAP status. Strong evidence of SDR and SPDCR usage. Supplier has active tools in place to track key supplier metrics daily on an MDI board or similar method and takes action at least weekly on top supplier issues. "]
[4,"Evidence exists, IR GSQM cascaded to their suppliers. Any prod. or process changes to supply chain (SDR/SPDCR) are communicated. Key supplier metrics are tracked monthly, action's are taken monthly on top supplier issue(s)."]
[3,"Awareness of GSQM, not cascaded to sub-suppliers. Minor gaps in PPAP, SDR and SPDCR process. Supplier tracks key supplier metrics and takes action periodically  when supplier issues occur."]
[2,"Suppliers are informally monitored, no metrics or goals are established. Continuous improvement is not a priority.  Supplier is not aware of the GSQM Requirements but follows some form of APQP/NPD"]
[1,"Supplier is not aware of the GSQM requirements, process or product changes have occurred that were not communicated to IR, or there is a risk of this happening because a policy does not exist.  "]
["N/A","Question is not applicable for this supplier, supplier only procures raw material or off the shelf commodities."]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.12c","index":21,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier request corrective actions for defects found on Supplier's purchased material?  How do they monitor their supplier compliance to this process?"]
[]
[null,"Reference Line no.","GSQM 2.12c/ ISO 8.4.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure of Incoming inspection? ","Quality Manual? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? "]
[null,"Implementation of the procedure at the incoming \ninspection area?","At the receiving inspection/receiving goods area.","Identification of the material, to be inspected Y/N. Clear labels on OK goods (green) & NOK goods (red). \nReceiving inspection results, linked with the receptions. \nWho is responsible for the inspections? Who is responsible for further actions in case of NOK goods/parts?"]
[null,"Receiving inspection results?","ERP system? ","Clear numbers of OK receptions (parts), rejected deliveries (parts) linked with the supplier(s). Clear view available over time, comparison with previous period (year)? \nPPM Nos.? Actions -> 8D reports linked with rejections?"]
[]
[null,"Scoring Pattern:- "]
[5,"Clear Incoming Inspection procedures in place. Suppliers are always requested to provide 8D reports for every Non-Conforming product. Suppliers' completion of 8D's is tracked and monitored. Results are available targets defined. If targets not met, actions are implemented. "]
[4,"Clear Incoming Inspection procedure in place. 8D reports requested on a case-by-case evaluation for Non-Conforming product. Suppliers completion of 8D's is tracked and monitored. Results are available targets defined."]
[3,"Procedure in place. Corrective actions will be established. Suppliers reaction will not be monitored. No 8D reports are requested (replacement of faulty parts or credit notes)."]
[2,"No procedure in place.  Corrective actions will be defined."]
[1,"No procedure in place.  No corrective actions defined."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.12d","index":22,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* If work is subcontracted to external sources, are there controls to assure the quality of the sub-contracted work?    \nDo they make PPAP of subcontracted processes such as paint, heat treatment?                    "]
[]
[null,"Reference Line no.(from OSA sheet)","2.12d/ ISO 8.4.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the Supplier have an Approved Supplier List and do they track supplier performance on a regular basis?","Purchasing department, Supplier Quality","Look for the Approved Supplier List and make sure supplier performance is evaluated at a minimum quarterly, preferably monthly."]
[null,"Is subcontracted work going through the PPAP process to insure part quality?","Quality Department","Look for signed approved PSW's for parts that are subcontracted out."]
[null,"Does the supplier inspect all work that is subcontracted?","Quality Department","Look for evidence that receiving inspection is performed for all subcontracted work."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has an Approved Supplier List and all applicable suppliers are evaluated monthly.  In addition all critical parts must have PPAP approval and the Supplier must show evidence that all subcontracted parts/work has been through the receiving inspection process"]
[4,"Supplier has an Approved Supplier List and all applicable suppliers are evaluated quarterly.  Supplier can show evidence that all subcontracted parts go through the receiving inspection process. Majority of the parts go through a PPAP process."]
[3,"Supplier has an Approved Supplier List and all applicable suppliers are evaluated no less than once per year.  Supplier can show evidence that all subcontracted parts go through the receiving inspection process. No or limited PPAP process in place."]
[2,"Supplier has an Approved Supplier List.  Supplier can show evidence that most subcontracted parts go through the receiving inspection process with minor lapses in compliance. No PPAP process in place for subcontracted parts"]
[1,"Supplier has no system in place to monitor subcontracted work."]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"2.12e","index":23,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,14,3],[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[]
[null,"OSA Question","*Are raw materials / purchased components inspected, tested or otherwise verified prior to use?  Is inspection supported by PPAP processes on purchased components?"]
[]
[null,"Reference Line no.(from OSA sheet)","2.12e/ ISO 8.4.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Verification of Purchased products & services","For each sub-supplier, the supplier shall establish and implement methods, processes, and systems to verify that all deliverables comply with Ingersoll Rand requirements. \nThe supplier shall complete this verification process prior to use for all deliverables provided to Ingersoll Rand. ","Consistent methods used;\n- Control plans\n- Standard work instructions\n- Regular inspection\n- Functional testing\n- Audits\n- Are sub-contracted processes PPAP'ed, can they provide evidence of this? PSW's? Relevant PPAP Doc's.  "]
[null,"Incoming product quality ","The supplier shall implement a process to ensure the quality of incoming deliverables meets Ingersoll Rand’s requirements.","The process should incorporate standard methods including:\n- Statistical data evaluation from the sub-supplier\n- Performance-based receiving inspection\n- Testing based on approved sampling plans\n- Supplier audits or assessments coupled with documented information of acceptable delivered product quality\n- Part evaluation by an approved laboratory\n- Other methods approved by Ingersoll Rand"]
[]
[null,"Scoring Pattern:- "]
[5,"Incoming Inspection supported by Electronic System (ERP,…). All critical parts have a full PPAP approval, all evidence available.\nREMARK: If raw materials will be verified at a lab, in house or externally, an ISO 17025 certificate is not a must."]
[4,"Supplier can show evidence of a good receiving inspection system inplace. Majority of parts have gone through a PPAP approval process"]
[3,"Supplier can show evidence that all Raw materials and or Purchased components  go through the receiving inspection process. Limited PPAP process"]
[2,"The Supplier can show evidence that most of the Raw materials and/or Purshcased components go through the receiving inspection process with minor lapses in compliance. No PPAP process in place"]
[1,"Supplier has no system in place to monitor and to registrate the verification of  Raw materials and/or Purchased components. No PPAP process in place"]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.1","index":24,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Does supplier conduct a manufacturing feasibility check prior of quoting business to their customer(s). Can supplier provide evidence of an example? Does supplier apply the same process for changes to part or specifications?"]
[]
[null,"New Question ","GSQM 4.1 /ISO8.2.3.1 & 8.2.3.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is the feasibility of all items, tolerances, specifications and characteristics on the drawing, Spec´s ensured, also considering the projected volumes?\n","On-line system, change request sheet or product feasibility review sheets. Available for each part in scope. Check one example. ","Comprehensive list of manufacturing feasibility with the changes and proof of approval or rejection from involved stakeholders. Each single feasibility study available for the (critical) components, signed by the plant stake holders. "]
[null,"Can the product / component be measured and evaluated utilizing equipment which has the required accuracy and the necessary capability (see MSA)?","Detailed control plan(s) and MSA studies available for the critical dimensions and in regards dedicated measuring equipment.  ","Detailed control plan(s), list of measuring equipment, calibration certificates, MSA studies. "]
[null,"Feasibility study procedure available? ","QMS. ","Procedure is present in QMS and maintained and managed, revision, date, responsible, sign off, …"]
[]
[null,"Scoring Pattern:- "]
[5,"Online system is covering the PFD & preliminary CP, necessary to approve a change or new part implementation off all involved departments/stake holders. This system is \"managing\" all; deadlines & responsible approvals. Automatic alerts are made. Clear procedure at QMS.",null,null,5,{"$f":"LEN(B13)","v":269}]
[4,"Any system available which is providing PFD and preliminary CP (Control Plan), necessary to approve a change or new part implementation, by all involved departments (stake holders). (engineering, purchasing, logistics, production, …)",null,null,4,{"$f":"LEN(B14)","v":233}]
[3,"Minor non-compliances with the documentation. Documents not updated properly, actions not followed in some cases. Procedure exists in QMS. ",null,null,3,139]
[2,"Manufacturing feasibility documents are available but not put into practice effectively and merely present in records. Procedure is not existing in QMS.",null,null,2,152]
[1,"No documents available.",null,null,1,23]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.2","index":25,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Are Critical Characteristics called out on the PCP, and is appropriate control in place?\nIs Statistical Process Control used for CTQ's or for high severity items as identified on PFMEA?"]
[]
[null,"Reference Line no.(from OSA sheet)",4.2]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier use AIAG Process Control Plans include variable data measurements for all critical to quality part characteristics/dimensions? ","Production floor. \nEngineering/Quality verifications;\nCritical to Quality Part Characteristics as identified at the IR drawings/specifications.  CTQ's identified by the supplier itself, based on SPC studies. \nCTQ's identified by PFMEA review's -> high severity items. ","Control Plans (according to AIAG) are in use, CTQ's identified with a specific symbol. \nCTQ's related to, or have influence on; \n- Product form, fit or function\n- Compliance to regulations\n- Safety requirements\n- Customer satisfaction"]
[null,"Does the supplier have an equivalent document to a control plan like a Shop Router that gives detailed instruct on what to inspect/control including variable data measurements for all critical to quality part characteristics/dimensions?","Production floor","Audit three work station to insure an equivalent document to a control plan is in place on the manufacturing floor."]
[null,"Can the supplier demonstrate process capability, SPC, for all designated special characteristics? ","QCS, measuring room.","The target process capability for special characteristics shall be (Cp, Cpk, Pp, Ppk):\nPpK; Short-term: greater than or equal to 1.67\nCpK; Long-term: greater than or equal to 1.33\nIf SPC results not met the IR requirements, a 100% inspection should be in place. "]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier uses AIAG Process Control Plans include variable data measurements for all critical to quality part characteristics/dimensions? The supplier can show evidence of a clear link between Process Flow Diagram, Control Plan and PFMEA. SPC results on  time available of the CTQ's. ",null,null,5]
[4,"Supplier uses an equivalent document to a control plan like a Shop Router that gives detailed instruct on what to inspect/control including variable data measurements for all critical to quality part characteristics/dimensions.",null,null,4]
[3,"Supplier uses Control Plans / Shop Routers that show minor lapses in detailed instruct on what to inspect/control including variable data measurements for all critical to quality part characteristics/dimensions.",null,null,3]
[2,"Supplier uses Control Plans / Shop Routers that show major lapses in detailed instruct on what to inspect/control including variable data measurements for all critical to quality part characteristics/dimensions.",null,null,2]
[1,"Supplier does not uses Control Plans / Shop Routers ",null,null,1]
["N/A","Question is not applicable for this supplier",null,null,"N/A"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.3","index":26,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier conduct Gage R&R, to analyze the variation present in the results of each type of measuring and test equipment system?       \nAre corrective actions taken in case of excessive variation?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.3/ ISO 7.1.5.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is Gage R&R a standard practice for new products. ","Gauge room\nQuality Dept.\nPPAP Files","Check if gage R&R is practiced during PPAP as a standard work.\nAudit some PPAP documents and check if all the instruments / gages as per the control plan were covered for gage R&R."]
[null,"Is gage R&R used for regular monitoring of measurement system.","\nQuality Dept.\nEngineering Dept.","Check if Annual Gage R&R plan exists.\nCheck if plan is adhered to.\nCheck if actions like appraiser training / instrument up gradation are evident from failed gage R&R reports."]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic means that show measurement equipment is part of a validated Measure System. Statistical studies are shown that demonstrate measurement variation is standardized and minimized. Users trained and qualified to measure parts as part of PPAP processes and normal manufacturing processes that require SPC evidence. Annual Gage R&R plan exists and is adhered to."]
[4,"Formal Program included all measurement equipment. Statistical studies as gauge R&R as min. are performed periodically and standardization and variation are shown. MSA and SPC are part of the PPAP when applicable (Level 3 and Level 5)."]
[3,"Program in place but missing a few non-critical gauge R@R in PPAP. Measurement variation detected as a result of missing of gauge R&R."]
[2,"No formal program in place. Some measurement equipment pass through gauge R&R studies. No MSA validated. Can't tell if the gauge meet statistical feature."]
[1,"None of the measurement equipment pass through gauge R&R process. No MSA in place."]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.4a","index":27,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Are gages and test / inspection equipment, including customer owned gages and equipment adequately maintained, calibrated, stored and available on the workstations?\nAre the following included in the records:\n· Item identity / Serial No. \n· Date calibrated / inspected \n· Date due for calibration or inspection \nItem identity/Serial No.\nDate calibrated/inspected\nDate due for calibration or inspection\nInitials or stamp of person performing calibration/inspection"]
[]
[null,"Reference Line no.(from OSA sheet)","4.4a"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is Master Gauge list with clear Identification of customer owned gages available","Gauge room\nQuality Dept.\nWorkshop floor","\nPick some random examples of gages and look for their presence in Master List.\nCheck how the trigger for due calibration is generated."]
[null,"If the gauges are calibrated, used and maintained well","Gauge room\nQuality Dept.\nWorkshop floor","1.Cert.mark on gauges, done by random sampling adding main gauges checking \n2.Check if there's system automatic or manual to schedule calibration \n3.Check the calibration record, especially to validation record if sign off, if Qualification stamped, done by random sampling and main gauges checking\n4. check if gages are stored safely and safe handling is evident."]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has a software based master gauge list that tracks calibration schedules and sends automatic notification to the gauge assigned areas prior to gauge needing calibration. All gauges have  an identity/Serial No., Date calibrated/inspected, Date due for calibration or inspection, Initials or stamp of person performing calibration/inspection and a calibration history record. Safe handling of gages is evident like for e.g.. storage in boxes, low humidity chambers, use of gloves while using sensitive gages / instruments."]
[4,"Excel system; tracking of schedules, sending notes to production areas prior to gauge calibration. All gauges identified. All calibration info available, date of calibration, due date. Calibration history rec."]
[3,"Most gages are in the master gauge list and have identity/Serial No., Date calibrated/inspected, Date due for calibration or inspection and a calibration history record."]
[2,"Some gages are in the master gauge list and have identity/Serial No., Date calibrated/inspected, Date due for calibration or inspection and a calibration history record."]
[1,"No gages are in the master gauge list and have identity/Serial No., Date calibrated/inspected, Date due for calibration or inspection and a calibration history record."]
["N/A","There are no gages required to accomplish the work in any work station per the work instructions and Test methods."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.4b","index":28,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Is there a documented calibration schedule for all measuring equipment and standards and are they adhering to it?   \nIs action taken in the event of calibration failure?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.4b/ ISO 7.1.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is there an annual calibration schedule?\nDoes it cover all the gages?","Standards Room\nQuality Department","Check if the Calibration schedule is available.\nCheck the latest addition and crosscheck with the master list."]
[null,"Is the adherence evident?","Standards Room\nQuality Department","Check how is the trigger for calibration is generated- Manual or automatic (software controlled).\nCheck if from the annual schedule a monthly schedule is derived and adhered to. (pick 2-3 sample gages form the line and check for adherence)"]
[null,"Is back up of all gages evident?","Standards Room\nQuality Department","Based on the nature of calibration (in-house or outside lab) find out if back up gages are available for any gage going out for calibration."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has a software based master gauge list tracking calibration schedules and sends automatic notification to the gauge assigned areas prior to gauge needing calibration. All gauges properly identified. Clear procedure in place with clear action in the event of calibration failure.",null,null,{"$f":"LEN(B13)","v":287}]
[4,"Excel system; tracking of schedules, notifications through e-mail. All gauges identified. All calibration info available, date of calibration, due date, ID of person done calibration. Calibration history recorded. Clear procedure in place.",null,null,{"$f":"LEN(B14)","v":239}]
[3,"Most gages are in the master gauge list and have some identification on their current calibration status. Procedure in place but actions on calibration failure not evident.",null,null,{"$f":"LEN(B15)","v":172}]
[2,"Some gages are in the master gauge list and have limited identifcation. Incomplete calibration history record. No procedure in place.",null,null,{"$f":"LEN(B16)","v":133}]
[1,"No gages are in the master gauge list. No identification. No calibration history record. No procedure in place",null,null,{"$f":"LEN(B17)","v":110}]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.5a","index":29,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Does the supplier use PPAP (based on AIAG) as a tool to validate the product and manufacturing process? Does the supplier have evidence of a recent PPAP submission (look for PPAP level 3 or 5 examples)?\n"]
[]
[null,"New OSA question","GSQM 4.5a/ ISO 8.6"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"PPAP documentation","PPAP folders. Soft copies, hard copies. PLM","Verify if a recent PPAP file in available. Check for content, completeness of the documentation, signed PSW (approved, rejected, interim),…"]
[null,"Procedure","QMS","Verify if documented procedure on \"PPAP\" is available, with process in place"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Documented process in place, supported by a PPAP IT solution, possibly linked to a PLM-system",null,null,5]
[4,"Documented process in place. PPAP documentation available and in line with AIAG requirements( Level 3 or 5)",null,null,4]
[3,"Documented process in place. PPAP documentation or similar docs, are only available on customer request",null,null,3]
[2,"No documented process in place. Some PPAP documentation is in place, but is not in line with AIAG requirements",null,null,2]
[1,"No documented process in place. PPAP is not used.",null,null,1]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.5b","index":30,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,1,14,3],[15,1,15,3],[2,1,3,1],[2,2,3,2],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[]
[null,"OSA Question","Does the supplier have a process flow diagram (PFD) in place, representing the complete flow?\n"]
[]
[null,"New OSA question","4.5b"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Process Flow diagram according to or equivalent the template presented at the AIAG. Including sub-contracting. ","QMS.\nPPAP doc's. ","Process Flow Diagram (PDF), includes all the process steps. \nPFD includes sub-contracting. \nPFD includes re-work activities, in house or externally with partners.  \nPFD, controlled document? Responsible, rev, and date up release and update. "]
[null,null,"PFMEA and Control plan(s), based on the PFD. ","All PFD steps available/listed at PFMEA & CP. "]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has Process Flow Diagrams in electronic revision in place, access to PC depends on the responsibilities. PFD including sub-contracting and re-works steps. Electronic linked with PFMEA.   "]
[4,"Supplier has Process Flow Diagrams in place for each product (family) that are adhered to. Including Sub-contractor activities and rework steps, if applicable. "]
[3,"Supplier has Process Flow Diagrams in place for each product family however minor lapses in compliance can be found."]
[2,"Supplier has Process Flow Diagrams in place for each product family however major lapses in compliance can be found."]
[1,"Supplier does not use a Process Flow Diagram.  "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.5c","index":31,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,3],[15,1,15,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Can supplier show evidence on using PFMEA during the APQP phase? \nDoes the PFMEA correspond to the PFD?"]
[]
[null,"New OSA question","4.5c"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"The supplier shall plan Internal reviews during the design and development process and the production launch.","Engineering ","APQP files "]
[null,"The supplier shall evaluate quality risks, costs, lead-times, critical paths and other items as appropriate throughout the entire APQP process","Cross functional team. ","Overview of the risks, corrective actions if needed and due dates and responsible defined.  "]
[null,"The supplier shall Identify potential problems, and product issues.  \n","Cross functional team. ","An analyze of the product and process risk based on the FMEA methodology (template of AIAG). \nThe PFMEA to follow/cover the Process Flow Diagram. "]
[]
[null,"Scoring Pattern:- "]
[5,"Documented procedure in place, supported by a P-FMEA IT solution, linked with clear evidence on updates of PCP and Flow Charts. PFMEA template as available at the AIAG.",null,null,5]
[4,"Documented procedure in place. P-FMEA available which will be updated systematically. P-FMEA's driven by a cross functional team. PFMEA's updated based on complaints received. PFMEA treated as a controlled document. ",null,null,4]
[3,"Documented procedure in place. A P-FMEA is being established during the PPAP phase, but not systematically updated. ",null,null,3]
[2,"No Documented procedure in place. A process risk analysis is being done, but it's not called a P-FMEA. ",null,null,2]
[1,"No documented procedure in place. No P-FMEA in place. ",null,null,1]
[null,0,null,null,0]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.5d","index":32,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3],[15,1,15,3],[7,2,10,2],[8,1,10,1]]}
[]
[]
[null,"OSA Question","*Are there process control plans (PCP) in place, and in line with the risks identified in PFMEA?  Are the control plans being adhered to?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.5d/ ISO 8.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have control plans in place for each product family?  ","Production Shop Floor","Check if control plans are available on the shop floor and in the production."]
[null,"Are the control plans being adhered to?",null,"Check the compliance for the currently running production and also for previous 2 lots."]
[null,null,null,"Are the control plan based on PFMEA, do control plans outline each step of the production in accordance with process flow diagram? "]
[null,null,null,"Are Critical Characteristics identified in the Control Plans and are measuring frequencies in line with the identified risks from the P-FMEA"]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has electronic control plans in place, available at all work stations and are adhered to."]
[4,"Supplier has control plans in place for each product family that are adhered to. Controls Plans in accordance with AIAG format or travel card indicating the measurement equipment, frequency and what to do in case of a non-conformity"]
[3,"Supplier has control plans in place for each product family however minor lapses in compliance can be found. Travel cards with limited details on controls."]
[2,"Supplier has control plans in place for each product family however major lapses in compliance can be found."]
[1,"Supplier does not use Control Plans"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.7a","index":33,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Is there evidence of control chart leading to actions?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.7a/ ISO 8.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is the control chart introduced and used in the process?","Workshop floor (including inspection room or other equivalent place)\nQuality Dept.","If the control charts, e.g. SPC charts and run chart etc. used in process and final inspection?"]
[null,"Is the control chart result used as input or reference for improvement? (pro-active or Post-mortem)","Workshop floor \nQuality Dept.","If there's rapid response to control chart result?\nHow much does it take from control chart to improve the process?"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Control Charts are generated electronically real time with clear reaction plans and evidence of actions taken"]
[4,"Control Charts are generated manually with clear reaction plans and evidence of actions taken"]
[3,"Control Chart procedure not being followed, gaps in deployment"]
[2,"A few control charts being used and not maintained"]
[1,"No control charts being used"]
["N/A","Process/ part volumes / commodity does not require use of control charts"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.7b","index":34,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Are process instructions available at the work station providing clear, complete and useful information to the operator in order to perform their tasks?"]
[]
[null,"Reference Line no.(from OSA sheet)","4.7b/ ISO 8.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Are there Work -/Process instructions available at each work station? ","Operation work station\nInspection work station","To verify the PFD, PFMEA and CP if Work -/Process Instructions are mentioned. \nIf yes, to verify at the shop floor if the Work - /Process Instruction is available. "]
[null,"Are the Work- /Process Instructions clear, complete and useful for the operators. ","Operation work station\nInspection work station","To verify if the Work - / Process Instruction covers all operation content of the working station? \nTo verify if the Work - /Process Instruction is useful and practical,  to guide and instruct the operator, e.g. check the illustration, each step description and main point hint, VAC, ... \n"]
[null,"Are the available Work -/Process Instructions controlled documents? Owner, revision, release date, … ","QMS ","Document control system. And are the operators trained in regards using the Instructions available? Training evidence? "]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic Current revision Work instructions are at each work station via computer display.   Work instructions include setup, materials, methods, graphical instructions (as needed), and test & inspection steps necessary for inexperienced worker to successfully accomplish the assigned work task.  Work instructions highlight required actions to inspect previous work station output."]
[4,"Work instructions are at each work station in paper/binder form. WI's include setup, materials, methods, graphical instructions (as needed), and test & inspection steps necessary for inexperienced worker to successfully accomplish the assigned work task."]
[3,"WI's are at most work stations in paper form.  Most WI's include setup, materials, methods, graphical instructions (as needed), and test & inspection steps,  for inexperienced worker to successfully accomplish the work task. Some steps not covered."]
[2,"Work instructions are either not current revision or not present at many work stations.  The work instructions are missing many work station elements."]
[1,"There are no work instructions present at the work station."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.7c","index":35,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Is a piece part inspected prior to production runs for all processes requiring setups, and are actual readings recorded?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.7c/ ISO 8.5.1"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is there inspection procedure of first off piece / Set up approval and approval criteria is clearly defined in control plan?","Workshop Floor(including inspection room)\nProduction and Quality Dept.","Check if, as a practice, the  set-up approval / Shift start approval is done for all processes and control plan clearly defines the same."]
[null,"Is start of production based on the setup / first piece approval?","Workshop Floor(including inspection room)\nProduction and Quality Dept.","Look for evidence that if the production has started only after set-up / first piece approval.\nLook for instances where first piece was not approved in the first time, has production been withheld?"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Production locked out without approved First Piece (where required).   First Piece results posted in work area with Visual Factory Management (VSM). Results of the last piece are verified to secure the shift."]
[4,"Controls in place that assure no production without approved First Piece (where required).  First Piece requirement denoted on control plan."]
[3,"Some faults in procedure and record keeping.    (i.e., production can continue without approved first piece, results of first piece unknown to line workers). "]
[2,"There are no records to support first piece."]
[1,"No first piece procedure or method in place."]
["N/A","N/A allowed only where no production or tooling is used (i.e., Only Distribution or Warehousing)."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.8a","index":36,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Is there a documented process for implementing product or process changes? Does the supplier validate these changes?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.8a/ ISO 8.2.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a procedure for  product or process changes?","Quality Manual","Look for procedure, Engineering Change Request forms, 30 day postings."]
[null,"Does the supplier have an electron system to manage product or process changes?","Engineering department","Have the supplier show you the system and go through three random examples of product or process changes."]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system with e-mail sign-off for all product or process changes linked to the documentation control system that insures all applicable procedures and drawings are revised to reflect the product or process change. All changes are validated through PPAP."]
[4,"Manual system in place for all product/process changes.  Manually tracking of all entries, to check all applicable procedures and drawings are revised to reflect the product or process change(s). All changes are validated through internal validation"]
[3,"Supplier has a paper system for all product or process changes.  They manually track all entries to make sure that all applicable procedures and drawings are revised to reflect the product or process change however minor lapses in compliance are found"]
[2,"Supplier has a system in place to track product or process changes however major lapses in compliance can be found."]
[1,"Supplier has no system in place."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.8b","index":37,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Does the supplier communicate product and process changes to the customer?  Can the supplier provide evidence of a process similar to Supplier Process & Design Change Request (SPDCR)?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.8b/ ISO 8.2.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a procedure for change management?","Quality manual","Look for procedure, Engineering Change Request forms, 30 day postings and Change management logs."]
[null,"Does the supplier have an electronic system to manage change management communication?","Engineering & manufacturing department","Have the supplier show you the system and go through three random examples of change management communication"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system with e-mail sign-off for all product design or process changes linked to the documentation control system that insures all applicable procedures and drawings are revised to reflect the product or process change communication. Fool-proof system of notification to customer (where ever applicable) exists."]
[4,"Manual system in place for all change management communication to customer.  Manually tracking of all entries, to check all applicable procedures and drawings are revised and updated correctly. Customer notification is evident where ever applicable."]
[3,"Supplier has a paper system for changes communicated to customer.  They manually track changes of all applicable procedures and drawings. Product  design or process changes to communicate with the customer(s). However minor lapses, noticed."]
[2,"Supplier has a system in place to communicate the changes to the customer however major lapses in compliance can be found."]
[1,"Supplier has no system in place."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.9","index":38,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Is there a maintenance plan for all equipment and tooling?  Is that plan being adhered to?"]
[]
[null,"Reference Line no.(from OSA sheet)",4.9000000000000004]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a PM(Preventive Maintenance)(Preventive Maintenance) program in place","Maintenance Department","Look for an electronic and or paper PM(Preventive Maintenance) program "]
[null,"Does the supplier have a PM(Preventive Maintenance) Schedule","Maintenance Department","Look for a schedule including daily, weekly monthly and annual PM(Preventive Maintenance)'s"]
[null,"Does the supplier have document evidence that PM(Preventive Maintenance) has taken place","Maintenance Department","Look for documentation that PM(Preventive Maintenance)'s have been conducted including sign-offs by maintenance people "]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has an electronic PM(Preventive Maintenance) program that automatically prints out PM(Preventive Maintenance) Work Orders on a daily weekly monthly and annual basis.  When work orders are not closed out in a timely manner the system sends out escalation  messages to the assigned person and management."]
[4,"Manual PM program requires to prints out; Work Orders on a daily, weekly, monthly and annual basis and assign to the appropriate Maintenance Person.  If work orders are not closed on time, a follows up is in place to insure they are conducted."]
[3,"Supplier has a manual PM(Preventive Maintenance) program that shows minor lapses in compliance both in the issuing of PM(Preventive Maintenance) Work Orders and the necessary follow-up to insure they are complete."]
[2,"Supplier has a manual PM(Preventive Maintenance) program that shows major lapses in compliance both in the issuing of PM(Preventive Maintenance) Work Orders and the necessary follow-up to insure they are complete."]
[1,"Supplier has no PM(Preventive Maintenance) Program in place. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.10","index":39,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,3],[14,1,14,3],[15,1,15,3],[2,1,3,1],[2,2,3,2],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[]
[null,"OSA Question","Does the supplier have documented information available and maintains a log of operational data for each IR (when applicable) or customer owned asset (patterns, production tooling's and fixtures, gauges, testing and measurement equipment,...) including, but not limited to:\n- Maintenance history\n- Usage\n- Capability information and capacity Tool changes for perishable tooling or wear components\n- Tool modifications and engineering changes"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.10 / ISO 8.5.3"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a operational data for IR owned assets?","Production and Maintenance department","Look for an electronic and or paper record for asset management such as patterns, production tooling, gauges and test equipment's."]
[null,"Does the supplier monitor the tool change frequency based on tool mfg. capacity?","Tool change log ","Look for tool change record which monitor the tool wear, usage and tool modifications."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has an electronic program that captures the tooling information. Tool modifications can easily be reviewed.  When tool changes did not happen system sends out escalation messages to the assigned person and management."]
[4,"Manual tracker on monitoring the tool wear, capacity and change frequency monitoring.  However minor lapses in tool modifications and engineering changes monitoring for IR owned assets"]
[3,"Supplier has a manual record for monitoring the IR owned assets however minor lapses in monitoring the tool wear, change frequency and tooling capacity"]
[2,"Supplier has a manual record for monitoring the IR owned assets however major lapses in monitoring the record"]
[1,"Supplier has not maintained any operation data for IR owned assets"]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.11a","index":40,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,1,17,3],[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Are raw materials / components identified and traceable to test or certification reports?\n· Date Codes　\n· Serial numbers　\n· Certificates of Analysis　\n· Bar coding technology　\nIs FIFO in place?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.11a/ ISO 8.5.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the Supplier have Material Certs for raw materials / Components used in production?","Receiving Department","Go to the receiving department and observe them receive in product.  In addition audit three random receiving records and insure product is received with Material Certs "]
[null,"If the supplier has material Certs do they include Date Codes, Serial Numbers and Bar Coding technology?","Receiving Department","When reviewing the material Certs observe that they include all applicable   Date Codes, Serial Numbers and Bar Coding technology?"]
[null,"Does the supplier have Certificates of Analysis for any third party testing ?\nElectronic / scanning system at receiving inspection area?","Receiving Department","If Third party Certificates of Analysis are required on Raw Materials / Components have the supplier provide the evidence for three random orders."]
[]
[null,"Scoring Pattern:- "]
[5,"Supplier has an electronic receiving system in place with bar Scanning technology.  All Material Certs including applicable Date Codes, Serial Numbers, and Certificates of Analysis are linked to the receiving order and can be shown electronically upon request."]
[4,"Supplier has a manual receiving system in place with paper records.  All Material Certs including applicable Date Codes, Serial Numbers, and Certificates of Analysis can be produced upon request."]
[3,"Supplier has a manual receiving system in place with paper records.  All Material Certs including applicable Date Codes, Serial Numbers, and Certificates of Analysis should be available however minor lapses in compliance can be found."]
[2,"Supplier has a manual receiving system in place with paper records however major lapses in compliance can be found."]
[1,"Supplier has no formal receiving system in place"]
["N/A","Question is not applicable for this supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.11b","index":41,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,16369,16,16371],[16,16373,16,16375],[16,16377,16,16379],[16,16381,16,16383],[16,16345,16,16347],[16,16349,16,16351],[16,16353,16,16355],[16,16357,16,16359],[16,16361,16,16363],[16,16365,16,16367],[16,16321,16,16323],[16,16325,16,16327],[16,16329,16,16331],[16,16333,16,16335],[16,16337,16,16339],[16,16341,16,16343],[16,16297,16,16299],[16,16301,16,16303],[16,16305,16,16307],[16,16309,16,16311],[16,16313,16,16315],[16,16317,16,16319],[16,16273,16,16275],[16,16277,16,16279],[16,16281,16,16283],[16,16285,16,16287],[16,16289,16,16291],[16,16293,16,16295],[16,16249,16,16251],[16,16253,16,16255],[16,16257,16,16259],[16,16261,16,16263],[16,16265,16,16267],[16,16269,16,16271],[16,16229,16,16231],[16,16233,16,16235],[16,16237,16,16239],[16,16241,16,16243],[16,16245,16,16247],[16,16201,16,16203],[16,16205,16,16207],[16,16209,16,16211],[16,16213,16,16215],[16,16217,16,16219],[16,16221,16,16223],[16,16177,16,16179],[16,16181,16,16183],[16,16185,16,16187],[16,16189,16,16191],[16,16193,16,16195],[16,16197,16,16199],[16,16153,16,16155],[16,16157,16,16159],[16,16161,16,16163],[16,16165,16,16167],[16,16169,16,16171],[16,16173,16,16175],[16,16129,16,16131],[16,16133,16,16135],[16,16137,16,16139],[16,16141,16,16143],[16,16145,16,16147],[16,16149,16,16151],[16,16105,16,16107],[16,16109,16,16111],[16,16113,16,16115],[16,16117,16,16119],[16,16121,16,16123],[16,16125,16,16127],[16,16225,16,16227],[16,16081,16,16083],[16,16085,16,16087],[16,16089,16,16091],[16,16093,16,16095],[16,16097,16,16099],[16,16101,16,16103],[16,16057,16,16059],[16,16061,16,16063],[16,16065,16,16067],[16,16069,16,16071],[16,16073,16,16075],[16,16077,16,16079],[16,16033,16,16035],[16,16037,16,16039],[16,16041,16,16043],[16,16045,16,16047],[16,16049,16,16051],[16,16053,16,16055],[16,16009,16,16011],[16,16013,16,16015],[16,16017,16,16019],[16,16021,16,16023],[16,16025,16,16027],[16,16029,16,16031],[16,15985,16,15987],[16,15989,16,15991],[16,15993,16,15995],[16,15997,16,15999],[16,16001,16,16003],[16,16005,16,16007],[16,15961,16,15963],[16,15965,16,15967],[16,15969,16,15971],[16,15973,16,15975],[16,15977,16,15979],[16,15981,16,15983],[16,15937,16,15939],[16,15941,16,15943],[16,15945,16,15947],[16,15949,16,15951],[16,15953,16,15955],[16,15957,16,15959],[16,15913,16,15915],[16,15917,16,15919],[16,15921,16,15923],[16,15925,16,15927],[16,15929,16,15931],[16,15933,16,15935],[16,15889,16,15891],[16,15893,16,15895],[16,15897,16,15899],[16,15901,16,15903],[16,15905,16,15907],[16,15909,16,15911],[16,15865,16,15867],[16,15869,16,15871],[16,15873,16,15875],[16,15877,16,15879],[16,15881,16,15883],[16,15885,16,15887],[16,15841,16,15843],[16,15845,16,15847],[16,15849,16,15851],[16,15853,16,15855],[16,15857,16,15859],[16,15861,16,15863],[16,15817,16,15819],[16,15821,16,15823],[16,15825,16,15827],[16,15829,16,15831],[16,15833,16,15835],[16,15837,16,15839],[16,15793,16,15795],[16,15797,16,15799],[16,15801,16,15803],[16,15805,16,15807],[16,15809,16,15811],[16,15813,16,15815],[16,15769,16,15771],[16,15773,16,15775],[16,15777,16,15779],[16,15781,16,15783],[16,15785,16,15787],[16,15789,16,15791],[16,15745,16,15747],[16,15749,16,15751],[16,15753,16,15755],[16,15757,16,15759],[16,15761,16,15763],[16,15765,16,15767],[16,15721,16,15723],[16,15725,16,15727],[16,15729,16,15731],[16,15733,16,15735],[16,15737,16,15739],[16,15741,16,15743],[16,15697,16,15699],[16,15701,16,15703],[16,15705,16,15707],[16,15709,16,15711],[16,15713,16,15715],[16,15717,16,15719],[16,15673,16,15675],[16,15677,16,15679],[16,15681,16,15683],[16,15685,16,15687],[16,15689,16,15691],[16,15693,16,15695],[16,15649,16,15651],[16,15653,16,15655],[16,15657,16,15659],[16,15661,16,15663],[16,15665,16,15667],[16,15669,16,15671],[16,15625,16,15627],[16,15629,16,15631],[16,15633,16,15635],[16,15637,16,15639],[16,15641,16,15643],[16,15645,16,15647],[16,15601,16,15603],[16,15605,16,15607],[16,15609,16,15611],[16,15613,16,15615],[16,15617,16,15619],[16,15621,16,15623],[16,15577,16,15579],[16,15581,16,15583],[16,15585,16,15587],[16,15589,16,15591],[16,15593,16,15595],[16,15597,16,15599],[16,15553,16,15555],[16,15557,16,15559],[16,15561,16,15563],[16,15565,16,15567],[16,15569,16,15571],[16,15573,16,15575],[16,15529,16,15531],[16,15533,16,15535],[16,15537,16,15539],[16,15541,16,15543],[16,15545,16,15547],[16,15549,16,15551],[16,15505,16,15507],[16,15509,16,15511],[16,15513,16,15515],[16,15517,16,15519],[16,15521,16,15523],[16,15525,16,15527],[16,15481,16,15483],[16,15485,16,15487],[16,15489,16,15491],[16,15493,16,15495],[16,15497,16,15499],[16,15501,16,15503],[16,15457,16,15459],[16,15461,16,15463],[16,15465,16,15467],[16,15469,16,15471],[16,15473,16,15475],[16,15477,16,15479],[16,15433,16,15435],[16,15437,16,15439],[16,15441,16,15443],[16,15445,16,15447],[16,15449,16,15451],[16,15453,16,15455],[16,15409,16,15411],[16,15413,16,15415],[16,15417,16,15419],[16,15421,16,15423],[16,15425,16,15427],[16,15429,16,15431],[16,15385,16,15387],[16,15389,16,15391],[16,15393,16,15395],[16,15397,16,15399],[16,15401,16,15403],[16,15405,16,15407],[16,15361,16,15363],[16,15365,16,15367],[16,15369,16,15371],[16,15373,16,15375],[16,15377,16,15379],[16,15381,16,15383],[16,15337,16,15339],[16,15341,16,15343],[16,15345,16,15347],[16,15349,16,15351],[16,15353,16,15355],[16,15357,16,15359],[16,15313,16,15315],[16,15317,16,15319],[16,15321,16,15323],[16,15325,16,15327],[16,15329,16,15331],[16,15333,16,15335],[16,15289,16,15291],[16,15293,16,15295],[16,15297,16,15299],[16,15301,16,15303],[16,15305,16,15307],[16,15309,16,15311],[16,15265,16,15267],[16,15269,16,15271],[16,15273,16,15275],[16,15277,16,15279],[16,15281,16,15283],[16,15285,16,15287],[16,15241,16,15243],[16,15245,16,15247],[16,15249,16,15251],[16,15253,16,15255],[16,15257,16,15259],[16,15261,16,15263],[16,15217,16,15219],[16,15221,16,15223],[16,15225,16,15227],[16,15229,16,15231],[16,15233,16,15235],[16,15237,16,15239],[16,15193,16,15195],[16,15197,16,15199],[16,15201,16,15203],[16,15205,16,15207],[16,15209,16,15211],[16,15213,16,15215],[16,15169,16,15171],[16,15173,16,15175],[16,15177,16,15179],[16,15181,16,15183],[16,15185,16,15187],[16,15189,16,15191],[16,15145,16,15147],[16,15149,16,15151],[16,15153,16,15155],[16,15157,16,15159],[16,15161,16,15163],[16,15165,16,15167],[16,15121,16,15123],[16,15125,16,15127],[16,15129,16,15131],[16,15133,16,15135],[16,15137,16,15139],[16,15141,16,15143],[16,15097,16,15099],[16,15101,16,15103],[16,15105,16,15107],[16,15109,16,15111],[16,15113,16,15115],[16,15117,16,15119],[16,15073,16,15075],[16,15077,16,15079],[16,15081,16,15083],[16,15085,16,15087],[16,15089,16,15091],[16,15093,16,15095],[16,15049,16,15051],[16,15053,16,15055],[16,15057,16,15059],[16,15061,16,15063],[16,15065,16,15067],[16,15069,16,15071],[16,15025,16,15027],[16,15029,16,15031],[16,15033,16,15035],[16,15037,16,15039],[16,15041,16,15043],[16,15045,16,15047],[16,15001,16,15003],[16,15005,16,15007],[16,15009,16,15011],[16,15013,16,15015],[16,15017,16,15019],[16,15021,16,15023],[16,14977,16,14979],[16,14981,16,14983],[16,14985,16,14987],[16,14989,16,14991],[16,14993,16,14995],[16,14997,16,14999],[16,14953,16,14955],[16,14957,16,14959],[16,14961,16,14963],[16,14965,16,14967],[16,14969,16,14971],[16,14973,16,14975],[16,14929,16,14931],[16,14933,16,14935],[16,14937,16,14939],[16,14941,16,14943],[16,14945,16,14947],[16,14949,16,14951],[16,14905,16,14907],[16,14909,16,14911],[16,14913,16,14915],[16,14917,16,14919],[16,14921,16,14923],[16,14925,16,14927],[16,14881,16,14883],[16,14885,16,14887],[16,14889,16,14891],[16,14893,16,14895],[16,14897,16,14899],[16,14901,16,14903],[16,14857,16,14859],[16,14861,16,14863],[16,14865,16,14867],[16,14869,16,14871],[16,14873,16,14875],[16,14877,16,14879],[16,14833,16,14835],[16,14837,16,14839],[16,14841,16,14843],[16,14845,16,14847],[16,14849,16,14851],[16,14853,16,14855],[16,14809,16,14811],[16,14813,16,14815],[16,14817,16,14819],[16,14821,16,14823],[16,14825,16,14827],[16,14829,16,14831],[16,14785,16,14787],[16,14789,16,14791],[16,14793,16,14795],[16,14797,16,14799],[16,14801,16,14803],[16,14805,16,14807],[16,14761,16,14763],[16,14765,16,14767],[16,14769,16,14771],[16,14773,16,14775],[16,14777,16,14779],[16,14781,16,14783],[16,14737,16,14739],[16,14741,16,14743],[16,14745,16,14747],[16,14749,16,14751],[16,14753,16,14755],[16,14757,16,14759],[16,14713,16,14715],[16,14717,16,14719],[16,14721,16,14723],[16,14725,16,14727],[16,14729,16,14731],[16,14733,16,14735],[16,14689,16,14691],[16,14693,16,14695],[16,14697,16,14699],[16,14701,16,14703],[16,14705,16,14707],[16,14709,16,14711],[16,14665,16,14667],[16,14669,16,14671],[16,14673,16,14675],[16,14677,16,14679],[16,14681,16,14683],[16,14685,16,14687],[16,14641,16,14643],[16,14645,16,14647],[16,14649,16,14651],[16,14653,16,14655],[16,14657,16,14659],[16,14661,16,14663],[16,14617,16,14619],[16,14621,16,14623],[16,14625,16,14627],[16,14629,16,14631],[16,14633,16,14635],[16,14637,16,14639],[16,14593,16,14595],[16,14597,16,14599],[16,14601,16,14603],[16,14605,16,14607],[16,14609,16,14611],[16,14613,16,14615],[16,14569,16,14571],[16,14573,16,14575],[16,14577,16,14579],[16,14581,16,14583],[16,14585,16,14587],[16,14589,16,14591],[16,14545,16,14547],[16,14549,16,14551],[16,14553,16,14555],[16,14557,16,14559],[16,14561,16,14563],[16,14565,16,14567],[16,14521,16,14523],[16,14525,16,14527],[16,14529,16,14531],[16,14533,16,14535],[16,14537,16,14539],[16,14541,16,14543],[16,14497,16,14499],[16,14501,16,14503],[16,14505,16,14507],[16,14509,16,14511],[16,14513,16,14515],[16,14517,16,14519],[16,14473,16,14475],[16,14477,16,14479],[16,14481,16,14483],[16,14485,16,14487],[16,14489,16,14491],[16,14493,16,14495],[16,14449,16,14451],[16,14453,16,14455],[16,14457,16,14459],[16,14461,16,14463],[16,14465,16,14467],[16,14469,16,14471],[16,14425,16,14427],[16,14429,16,14431],[16,14433,16,14435],[16,14437,16,14439],[16,14441,16,14443],[16,14445,16,14447],[16,14401,16,14403],[16,14405,16,14407],[16,14409,16,14411],[16,14413,16,14415],[16,14417,16,14419],[16,14421,16,14423],[16,14377,16,14379],[16,14381,16,14383],[16,14385,16,14387],[16,14389,16,14391],[16,14393,16,14395],[16,14397,16,14399],[16,14353,16,14355],[16,14357,16,14359],[16,14361,16,14363],[16,14365,16,14367],[16,14369,16,14371],[16,14373,16,14375],[16,14329,16,14331],[16,14333,16,14335],[16,14337,16,14339],[16,14341,16,14343],[16,14345,16,14347],[16,14349,16,14351],[16,14305,16,14307],[16,14309,16,14311],[16,14313,16,14315],[16,14317,16,14319],[16,14321,16,14323],[16,14325,16,14327],[16,14281,16,14283],[16,14285,16,14287],[16,14289,16,14291],[16,14293,16,14295],[16,14297,16,14299],[16,14301,16,14303],[16,14257,16,14259],[16,14261,16,14263],[16,14265,16,14267],[16,14269,16,14271],[16,14273,16,14275],[16,14277,16,14279],[16,14233,16,14235],[16,14237,16,14239],[16,14241,16,14243],[16,14245,16,14247],[16,14249,16,14251],[16,14253,16,14255],[16,14209,16,14211],[16,14213,16,14215],[16,14217,16,14219],[16,14221,16,14223],[16,14225,16,14227],[16,14229,16,14231],[16,14185,16,14187],[16,14189,16,14191],[16,14193,16,14195],[16,14197,16,14199],[16,14201,16,14203],[16,14205,16,14207],[16,14161,16,14163],[16,14165,16,14167],[16,14169,16,14171],[16,14173,16,14175],[16,14177,16,14179],[16,14181,16,14183],[16,14137,16,14139],[16,14141,16,14143],[16,14145,16,14147],[16,14149,16,14151],[16,14153,16,14155],[16,14157,16,14159],[16,14113,16,14115],[16,14117,16,14119],[16,14121,16,14123],[16,14125,16,14127],[16,14129,16,14131],[16,14133,16,14135],[16,14089,16,14091],[16,14093,16,14095],[16,14097,16,14099],[16,14101,16,14103],[16,14105,16,14107],[16,14109,16,14111],[16,14065,16,14067],[16,14069,16,14071],[16,14073,16,14075],[16,14077,16,14079],[16,14081,16,14083],[16,14085,16,14087],[16,14041,16,14043],[16,14045,16,14047],[16,14049,16,14051],[16,14053,16,14055],[16,14057,16,14059],[16,14061,16,14063],[16,14017,16,14019],[16,14021,16,14023],[16,14025,16,14027],[16,14029,16,14031],[16,14033,16,14035],[16,14037,16,14039],[16,13993,16,13995],[16,13997,16,13999],[16,14001,16,14003],[16,14005,16,14007],[16,14009,16,14011],[16,14013,16,14015],[16,13969,16,13971],[16,13973,16,13975],[16,13977,16,13979],[16,13981,16,13983],[16,13985,16,13987],[16,13989,16,13991],[16,13945,16,13947],[16,13949,16,13951],[16,13953,16,13955],[16,13957,16,13959],[16,13961,16,13963],[16,13965,16,13967],[16,13921,16,13923],[16,13925,16,13927],[16,13929,16,13931],[16,13933,16,13935],[16,13937,16,13939],[16,13941,16,13943],[16,13897,16,13899],[16,13901,16,13903],[16,13905,16,13907],[16,13909,16,13911],[16,13913,16,13915],[16,13917,16,13919],[16,13873,16,13875],[16,13877,16,13879],[16,13881,16,13883],[16,13885,16,13887],[16,13889,16,13891],[16,13893,16,13895],[16,13849,16,13851],[16,13853,16,13855],[16,13857,16,13859],[16,13861,16,13863],[16,13865,16,13867],[16,13869,16,13871],[16,13825,16,13827],[16,13829,16,13831],[16,13833,16,13835],[16,13837,16,13839],[16,13841,16,13843],[16,13845,16,13847],[16,13801,16,13803],[16,13805,16,13807],[16,13809,16,13811],[16,13813,16,13815],[16,13817,16,13819],[16,13821,16,13823],[16,13777,16,13779],[16,13781,16,13783],[16,13785,16,13787],[16,13789,16,13791],[16,13793,16,13795],[16,13797,16,13799],[16,13753,16,13755],[16,13757,16,13759],[16,13761,16,13763],[16,13765,16,13767],[16,13769,16,13771],[16,13773,16,13775],[16,13729,16,13731],[16,13733,16,13735],[16,13737,16,13739],[16,13741,16,13743],[16,13745,16,13747],[16,13749,16,13751],[16,13705,16,13707],[16,13709,16,13711],[16,13713,16,13715],[16,13717,16,13719],[16,13721,16,13723],[16,13725,16,13727],[16,13681,16,13683],[16,13685,16,13687],[16,13689,16,13691],[16,13693,16,13695],[16,13697,16,13699],[16,13701,16,13703],[16,13657,16,13659],[16,13661,16,13663],[16,13665,16,13667],[16,13669,16,13671],[16,13673,16,13675],[16,13677,16,13679],[16,13633,16,13635],[16,13637,16,13639],[16,13641,16,13643],[16,13645,16,13647],[16,13649,16,13651],[16,13653,16,13655],[16,13609,16,13611],[16,13613,16,13615],[16,13617,16,13619],[16,13621,16,13623],[16,13625,16,13627],[16,13629,16,13631],[16,13585,16,13587],[16,13589,16,13591],[16,13593,16,13595],[16,13597,16,13599],[16,13601,16,13603],[16,13605,16,13607],[16,13561,16,13563],[16,13565,16,13567],[16,13569,16,13571],[16,13573,16,13575],[16,13577,16,13579],[16,13581,16,13583],[16,13537,16,13539],[16,13541,16,13543],[16,13545,16,13547],[16,13549,16,13551],[16,13553,16,13555],[16,13557,16,13559],[16,13513,16,13515],[16,13517,16,13519],[16,13521,16,13523],[16,13525,16,13527],[16,13529,16,13531],[16,13533,16,13535],[16,13489,16,13491],[16,13493,16,13495],[16,13497,16,13499],[16,13501,16,13503],[16,13505,16,13507],[16,13509,16,13511],[16,13465,16,13467],[16,13469,16,13471],[16,13473,16,13475],[16,13477,16,13479],[16,13481,16,13483],[16,13485,16,13487],[16,13441,16,13443],[16,13445,16,13447],[16,13449,16,13451],[16,13453,16,13455],[16,13457,16,13459],[16,13461,16,13463],[16,13417,16,13419],[16,13421,16,13423],[16,13425,16,13427],[16,13429,16,13431],[16,13433,16,13435],[16,13437,16,13439],[16,13393,16,13395],[16,13397,16,13399],[16,13401,16,13403],[16,13405,16,13407],[16,13409,16,13411],[16,13413,16,13415],[16,13369,16,13371],[16,13373,16,13375],[16,13377,16,13379],[16,13381,16,13383],[16,13385,16,13387],[16,13389,16,13391],[16,13345,16,13347],[16,13349,16,13351],[16,13353,16,13355],[16,13357,16,13359],[16,13361,16,13363],[16,13365,16,13367],[16,13321,16,13323],[16,13325,16,13327],[16,13329,16,13331],[16,13333,16,13335],[16,13337,16,13339],[16,13341,16,13343],[16,13297,16,13299],[16,13301,16,13303],[16,13305,16,13307],[16,13309,16,13311],[16,13313,16,13315],[16,13317,16,13319],[16,13273,16,13275],[16,13277,16,13279],[16,13281,16,13283],[16,13285,16,13287],[16,13289,16,13291],[16,13293,16,13295],[16,13249,16,13251],[16,13253,16,13255],[16,13257,16,13259],[16,13261,16,13263],[16,13265,16,13267],[16,13269,16,13271],[16,13225,16,13227],[16,13229,16,13231],[16,13233,16,13235],[16,13237,16,13239],[16,13241,16,13243],[16,13245,16,13247],[16,13201,16,13203],[16,13205,16,13207],[16,13209,16,13211],[16,13213,16,13215],[16,13217,16,13219],[16,13221,16,13223],[16,13177,16,13179],[16,13181,16,13183],[16,13185,16,13187],[16,13189,16,13191],[16,13193,16,13195],[16,13197,16,13199],[16,13153,16,13155],[16,13157,16,13159],[16,13161,16,13163],[16,13165,16,13167],[16,13169,16,13171],[16,13173,16,13175],[16,13129,16,13131],[16,13133,16,13135],[16,13137,16,13139],[16,13141,16,13143],[16,13145,16,13147],[16,13149,16,13151],[16,13105,16,13107],[16,13109,16,13111],[16,13113,16,13115],[16,13117,16,13119],[16,13121,16,13123],[16,13125,16,13127],[16,13081,16,13083],[16,13085,16,13087],[16,13089,16,13091],[16,13093,16,13095],[16,13097,16,13099],[16,13101,16,13103],[16,13057,16,13059],[16,13061,16,13063],[16,13065,16,13067],[16,13069,16,13071],[16,13073,16,13075],[16,13077,16,13079],[16,13033,16,13035],[16,13037,16,13039],[16,13041,16,13043],[16,13045,16,13047],[16,13049,16,13051],[16,13053,16,13055],[16,13009,16,13011],[16,13013,16,13015],[16,13017,16,13019],[16,13021,16,13023],[16,13025,16,13027],[16,13029,16,13031],[16,12985,16,12987],[16,12989,16,12991],[16,12993,16,12995],[16,12997,16,12999],[16,13001,16,13003],[16,13005,16,13007],[16,12961,16,12963],[16,12965,16,12967],[16,12969,16,12971],[16,12973,16,12975],[16,12977,16,12979],[16,12981,16,12983],[16,12937,16,12939],[16,12941,16,12943],[16,12945,16,12947],[16,12949,16,12951],[16,12953,16,12955],[16,12957,16,12959],[16,12913,16,12915],[16,12917,16,12919],[16,12921,16,12923],[16,12925,16,12927],[16,12929,16,12931],[16,12933,16,12935],[16,12889,16,12891],[16,12893,16,12895],[16,12897,16,12899],[16,12901,16,12903],[16,12905,16,12907],[16,12909,16,12911],[16,12865,16,12867],[16,12869,16,12871],[16,12873,16,12875],[16,12877,16,12879],[16,12881,16,12883],[16,12885,16,12887],[16,12841,16,12843],[16,12845,16,12847],[16,12849,16,12851],[16,12853,16,12855],[16,12857,16,12859],[16,12861,16,12863],[16,12817,16,12819],[16,12821,16,12823],[16,12825,16,12827],[16,12829,16,12831],[16,12833,16,12835],[16,12837,16,12839],[16,12793,16,12795],[16,12797,16,12799],[16,12801,16,12803],[16,12805,16,12807],[16,12809,16,12811],[16,12813,16,12815],[16,12769,16,12771],[16,12773,16,12775],[16,12777,16,12779],[16,12781,16,12783],[16,12785,16,12787],[16,12789,16,12791],[16,12745,16,12747],[16,12749,16,12751],[16,12753,16,12755],[16,12757,16,12759],[16,12761,16,12763],[16,12765,16,12767],[16,12721,16,12723],[16,12725,16,12727],[16,12729,16,12731],[16,12733,16,12735],[16,12737,16,12739],[16,12741,16,12743],[16,12697,16,12699],[16,12701,16,12703],[16,12705,16,12707],[16,12709,16,12711],[16,12713,16,12715],[16,12717,16,12719],[16,12673,16,12675],[16,12677,16,12679],[16,12681,16,12683],[16,12685,16,12687],[16,12689,16,12691],[16,12693,16,12695],[16,12649,16,12651],[16,12653,16,12655],[16,12657,16,12659],[16,12661,16,12663],[16,12665,16,12667],[16,12669,16,12671],[16,12625,16,12627],[16,12629,16,12631],[16,12633,16,12635],[16,12637,16,12639],[16,12641,16,12643],[16,12645,16,12647],[16,12601,16,12603],[16,12605,16,12607],[16,12609,16,12611],[16,12613,16,12615],[16,12617,16,12619],[16,12621,16,12623],[16,12577,16,12579],[16,12581,16,12583],[16,12585,16,12587],[16,12589,16,12591],[16,12593,16,12595],[16,12597,16,12599],[16,12553,16,12555],[16,12557,16,12559],[16,12561,16,12563],[16,12565,16,12567],[16,12569,16,12571],[16,12573,16,12575],[16,12529,16,12531],[16,12533,16,12535],[16,12537,16,12539],[16,12541,16,12543],[16,12545,16,12547],[16,12549,16,12551],[16,12505,16,12507],[16,12509,16,12511],[16,12513,16,12515],[16,12517,16,12519],[16,12521,16,12523],[16,12525,16,12527],[16,12481,16,12483],[16,12485,16,12487],[16,12489,16,12491],[16,12493,16,12495],[16,12497,16,12499],[16,12501,16,12503],[16,12457,16,12459],[16,12461,16,12463],[16,12465,16,12467],[16,12469,16,12471],[16,12473,16,12475],[16,12477,16,12479],[16,12433,16,12435],[16,12437,16,12439],[16,12441,16,12443],[16,12445,16,12447],[16,12449,16,12451],[16,12453,16,12455],[16,12409,16,12411],[16,12413,16,12415],[16,12417,16,12419],[16,12421,16,12423],[16,12425,16,12427],[16,12429,16,12431],[16,12385,16,12387],[16,12389,16,12391],[16,12393,16,12395],[16,12397,16,12399],[16,12401,16,12403],[16,12405,16,12407]],"merged_total":20482,"flags":["merged_cut"]}
[]
[]
[null,"OSA Question","Is Work In Progress (WIP) properly identified and properly preserved throughout all phases of production? Evidence through spot-check on the shop floor."]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.11b/ ISO 8.5.2"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is the part identified in the production?","1.the line/machine for the part production\n2.the stop point of production, e.g. transfer area, segregation area and scrap area etc.","Check if container with a travel card or ID/mark in part level"]
[null,"Is the part's status identified in the production","1.travel card or process card whatever for each container or each part\n2.production log, record etc.","Check if steps/processes finished or to be finished in next is definitely marked in card and if the log noting the finished part volume regularly, half or one shift(optional)"]
[null,"Is the line/machine identified as which part is being produced","the line/machine for the part production","Check if the P/N(number and name)is marked on line/machining"]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system that stores serial number, date code, lot number and material certificate if required of all WIP. All raw material has a scan able bar code and finish goods have a scan able bar code the contains serial number, date code, lot number, etc.. System will flag time sensitive materials material and not allow them to be used. In addition, before being taking to the line the raw material is scanned and assigned to a BOM. The finished good has a serial number that is ties to the BOM that has the lot number and date code for all raw material."]
[4,"All WIP-products have a travel card or process card  for each container or each part the is identified and traceable"]
[3,"Some WIP-products have a travel card or process card  for each container or each part is identified with some traceability"]
[2,"Major lapse in WIP-product being identified and traceable. Travel card not always available."]
[1,"There is no system for identification, traceability, preservation and handling of product throughout all phases of production?"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"4.12","index":42,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,16381,16,16383],[16,16357,16,16359],[16,16361,16,16363],[16,16365,16,16367],[16,16369,16,16371],[16,16373,16,16375],[16,16377,16,16379],[16,16333,16,16335],[16,16337,16,16339],[16,16341,16,16343],[16,16345,16,16347],[16,16349,16,16351],[16,16353,16,16355],[16,16309,16,16311],[16,16313,16,16315],[16,16317,16,16319],[16,16321,16,16323],[16,16325,16,16327],[16,16329,16,16331],[16,16285,16,16287],[16,16289,16,16291],[16,16293,16,16295],[16,16297,16,16299],[16,16301,16,16303],[16,16305,16,16307],[16,16261,16,16263],[16,16265,16,16267],[16,16269,16,16271],[16,16273,16,16275],[16,16277,16,16279],[16,16281,16,16283],[16,16237,16,16239],[16,16241,16,16243],[16,16245,16,16247],[16,16249,16,16251],[16,16253,16,16255],[16,16257,16,16259],[16,16213,16,16215],[16,16217,16,16219],[16,16221,16,16223],[16,16225,16,16227],[16,16229,16,16231],[16,16233,16,16235],[16,16189,16,16191],[16,16193,16,16195],[16,16197,16,16199],[16,16201,16,16203],[16,16205,16,16207],[16,16209,16,16211],[16,16165,16,16167],[16,16169,16,16171],[16,16173,16,16175],[16,16177,16,16179],[16,16181,16,16183],[16,16185,16,16187],[16,16141,16,16143],[16,16145,16,16147],[16,16149,16,16151],[16,16153,16,16155],[16,16157,16,16159],[16,16161,16,16163],[16,16117,16,16119],[16,16121,16,16123],[16,16125,16,16127],[16,16129,16,16131],[16,16133,16,16135],[16,16137,16,16139],[16,16093,16,16095],[16,16097,16,16099],[16,16101,16,16103],[16,16105,16,16107],[16,16109,16,16111],[16,16113,16,16115],[16,16069,16,16071],[16,16073,16,16075],[16,16077,16,16079],[16,16081,16,16083],[16,16085,16,16087],[16,16089,16,16091],[16,16045,16,16047],[16,16049,16,16051],[16,16053,16,16055],[16,16057,16,16059],[16,16061,16,16063],[16,16065,16,16067],[16,16021,16,16023],[16,16025,16,16027],[16,16029,16,16031],[16,16033,16,16035],[16,16037,16,16039],[16,16041,16,16043],[16,15997,16,15999],[16,16001,16,16003],[16,16005,16,16007],[16,16009,16,16011],[16,16013,16,16015],[16,16017,16,16019],[16,15973,16,15975],[16,15977,16,15979],[16,15981,16,15983],[16,15985,16,15987],[16,15989,16,15991],[16,15993,16,15995],[16,15949,16,15951],[16,15953,16,15955],[16,15957,16,15959],[16,15961,16,15963],[16,15965,16,15967],[16,15969,16,15971],[16,15925,16,15927],[16,15929,16,15931],[16,15933,16,15935],[16,15937,16,15939],[16,15941,16,15943],[16,15945,16,15947],[16,15901,16,15903],[16,15905,16,15907],[16,15909,16,15911],[16,15913,16,15915],[16,15917,16,15919],[16,15921,16,15923],[16,15877,16,15879],[16,15881,16,15883],[16,15885,16,15887],[16,15889,16,15891],[16,15893,16,15895],[16,15897,16,15899],[16,15853,16,15855],[16,15857,16,15859],[16,15861,16,15863],[16,15865,16,15867],[16,15869,16,15871],[16,15873,16,15875],[16,15829,16,15831],[16,15833,16,15835],[16,15837,16,15839],[16,15841,16,15843],[16,15845,16,15847],[16,15849,16,15851],[16,15805,16,15807],[16,15809,16,15811],[16,15813,16,15815],[16,15817,16,15819],[16,15821,16,15823],[16,15825,16,15827],[16,15781,16,15783],[16,15785,16,15787],[16,15789,16,15791],[16,15793,16,15795],[16,15797,16,15799],[16,15801,16,15803],[16,15757,16,15759],[16,15761,16,15763],[16,15765,16,15767],[16,15769,16,15771],[16,15773,16,15775],[16,15777,16,15779],[16,15733,16,15735],[16,15737,16,15739],[16,15741,16,15743],[16,15745,16,15747],[16,15749,16,15751],[16,15753,16,15755],[16,15709,16,15711],[16,15713,16,15715],[16,15717,16,15719],[16,15721,16,15723],[16,15725,16,15727],[16,15729,16,15731],[16,15685,16,15687],[16,15689,16,15691],[16,15693,16,15695],[16,15697,16,15699],[16,15701,16,15703],[16,15705,16,15707],[16,15661,16,15663],[16,15665,16,15667],[16,15669,16,15671],[16,15673,16,15675],[16,15677,16,15679],[16,15681,16,15683],[16,15637,16,15639],[16,15641,16,15643],[16,15645,16,15647],[16,15649,16,15651],[16,15653,16,15655],[16,15657,16,15659],[16,15613,16,15615],[16,15617,16,15619],[16,15621,16,15623],[16,15625,16,15627],[16,15629,16,15631],[16,15633,16,15635],[16,15589,16,15591],[16,15593,16,15595],[16,15597,16,15599],[16,15601,16,15603],[16,15605,16,15607],[16,15609,16,15611],[16,15565,16,15567],[16,15569,16,15571],[16,15573,16,15575],[16,15577,16,15579],[16,15581,16,15583],[16,15585,16,15587],[16,15541,16,15543],[16,15545,16,15547],[16,15549,16,15551],[16,15553,16,15555],[16,15557,16,15559],[16,15561,16,15563],[16,15517,16,15519],[16,15521,16,15523],[16,15525,16,15527],[16,15529,16,15531],[16,15533,16,15535],[16,15537,16,15539],[16,15493,16,15495],[16,15497,16,15499],[16,15501,16,15503],[16,15505,16,15507],[16,15509,16,15511],[16,15513,16,15515],[16,15469,16,15471],[16,15473,16,15475],[16,15477,16,15479],[16,15481,16,15483],[16,15485,16,15487],[16,15489,16,15491],[16,15445,16,15447],[16,15449,16,15451],[16,15453,16,15455],[16,15457,16,15459],[16,15461,16,15463],[16,15465,16,15467],[16,15421,16,15423],[16,15425,16,15427],[16,15429,16,15431],[16,15433,16,15435],[16,15437,16,15439],[16,15441,16,15443],[16,15397,16,15399],[16,15401,16,15403],[16,15405,16,15407],[16,15409,16,15411],[16,15413,16,15415],[16,15417,16,15419],[16,15373,16,15375],[16,15377,16,15379],[16,15381,16,15383],[16,15385,16,15387],[16,15389,16,15391],[16,15393,16,15395],[16,15349,16,15351],[16,15353,16,15355],[16,15357,16,15359],[16,15361,16,15363],[16,15365,16,15367],[16,15369,16,15371],[16,15325,16,15327],[16,15329,16,15331],[16,15333,16,15335],[16,15337,16,15339],[16,15341,16,15343],[16,15345,16,15347],[16,15301,16,15303],[16,15305,16,15307],[16,15309,16,15311],[16,15313,16,15315],[16,15317,16,15319],[16,15321,16,15323],[16,15277,16,15279],[16,15281,16,15283],[16,15285,16,15287],[16,15289,16,15291],[16,15293,16,15295],[16,15297,16,15299],[16,15253,16,15255],[16,15257,16,15259],[16,15261,16,15263],[16,15265,16,15267],[16,15269,16,15271],[16,15273,16,15275],[16,15229,16,15231],[16,15233,16,15235],[16,15237,16,15239],[16,15241,16,15243],[16,15245,16,15247],[16,15249,16,15251],[16,15205,16,15207],[16,15209,16,15211],[16,15213,16,15215],[16,15217,16,15219],[16,15221,16,15223],[16,15225,16,15227],[16,15181,16,15183],[16,15185,16,15187],[16,15189,16,15191],[16,15193,16,15195],[16,15197,16,15199],[16,15201,16,15203],[16,15157,16,15159],[16,15161,16,15163],[16,15165,16,15167],[16,15169,16,15171],[16,15173,16,15175],[16,15177,16,15179],[16,15133,16,15135],[16,15137,16,15139],[16,15141,16,15143],[16,15145,16,15147],[16,15149,16,15151],[16,15153,16,15155],[16,15109,16,15111],[16,15113,16,15115],[16,15117,16,15119],[16,15121,16,15123],[16,15125,16,15127],[16,15129,16,15131],[16,15085,16,15087],[16,15089,16,15091],[16,15093,16,15095],[16,15097,16,15099],[16,15101,16,15103],[16,15105,16,15107],[16,15061,16,15063],[16,15065,16,15067],[16,15069,16,15071],[16,15073,16,15075],[16,15077,16,15079],[16,15081,16,15083],[16,15037,16,15039],[16,15041,16,15043],[16,15045,16,15047],[16,15049,16,15051],[16,15053,16,15055],[16,15057,16,15059],[16,15013,16,15015],[16,15017,16,15019],[16,15021,16,15023],[16,15025,16,15027],[16,15029,16,15031],[16,15033,16,15035],[16,14989,16,14991],[16,14993,16,14995],[16,14997,16,14999],[16,15001,16,15003],[16,15005,16,15007],[16,15009,16,15011],[16,14965,16,14967],[16,14969,16,14971],[16,14973,16,14975],[16,14977,16,14979],[16,14981,16,14983],[16,14985,16,14987],[16,14941,16,14943],[16,14945,16,14947],[16,14949,16,14951],[16,14953,16,14955],[16,14957,16,14959],[16,14961,16,14963],[16,14917,16,14919],[16,14921,16,14923],[16,14925,16,14927],[16,14929,16,14931],[16,14933,16,14935],[16,14937,16,14939],[16,14893,16,14895],[16,14897,16,14899],[16,14901,16,14903],[16,14905,16,14907],[16,14909,16,14911],[16,14913,16,14915],[16,14869,16,14871],[16,14873,16,14875],[16,14877,16,14879],[16,14881,16,14883],[16,14885,16,14887],[16,14889,16,14891],[16,14845,16,14847],[16,14849,16,14851],[16,14853,16,14855],[16,14857,16,14859],[16,14861,16,14863],[16,14865,16,14867],[16,14821,16,14823],[16,14825,16,14827],[16,14829,16,14831],[16,14833,16,14835],[16,14837,16,14839],[16,14841,16,14843],[16,14797,16,14799],[16,14801,16,14803],[16,14805,16,14807],[16,14809,16,14811],[16,14813,16,14815],[16,14817,16,14819],[16,14773,16,14775],[16,14777,16,14779],[16,14781,16,14783],[16,14785,16,14787],[16,14789,16,14791],[16,14793,16,14795],[16,14749,16,14751],[16,14753,16,14755],[16,14757,16,14759],[16,14761,16,14763],[16,14765,16,14767],[16,14769,16,14771],[16,14725,16,14727],[16,14729,16,14731],[16,14733,16,14735],[16,14737,16,14739],[16,14741,16,14743],[16,14745,16,14747],[16,14701,16,14703],[16,14705,16,14707],[16,14709,16,14711],[16,14713,16,14715],[16,14717,16,14719],[16,14721,16,14723],[16,14677,16,14679],[16,14681,16,14683],[16,14685,16,14687],[16,14689,16,14691],[16,14693,16,14695],[16,14697,16,14699],[16,14653,16,14655],[16,14657,16,14659],[16,14661,16,14663],[16,14665,16,14667],[16,14669,16,14671],[16,14673,16,14675],[16,14629,16,14631],[16,14633,16,14635],[16,14637,16,14639],[16,14641,16,14643],[16,14645,16,14647],[16,14649,16,14651],[16,14605,16,14607],[16,14609,16,14611],[16,14613,16,14615],[16,14617,16,14619],[16,14621,16,14623],[16,14625,16,14627],[16,14581,16,14583],[16,14585,16,14587],[16,14589,16,14591],[16,14593,16,14595],[16,14597,16,14599],[16,14601,16,14603],[16,14557,16,14559],[16,14561,16,14563],[16,14565,16,14567],[16,14569,16,14571],[16,14573,16,14575],[16,14577,16,14579],[16,14533,16,14535],[16,14537,16,14539],[16,14541,16,14543],[16,14545,16,14547],[16,14549,16,14551],[16,14553,16,14555],[16,14509,16,14511],[16,14513,16,14515],[16,14517,16,14519],[16,14521,16,14523],[16,14525,16,14527],[16,14529,16,14531],[16,14485,16,14487],[16,14489,16,14491],[16,14493,16,14495],[16,14497,16,14499],[16,14501,16,14503],[16,14505,16,14507],[16,14461,16,14463],[16,14465,16,14467],[16,14469,16,14471],[16,14473,16,14475],[16,14477,16,14479],[16,14481,16,14483],[16,14437,16,14439],[16,14441,16,14443],[16,14445,16,14447],[16,14449,16,14451],[16,14453,16,14455],[16,14457,16,14459],[16,14413,16,14415],[16,14417,16,14419],[16,14421,16,14423],[16,14425,16,14427],[16,14429,16,14431],[16,14433,16,14435],[16,14389,16,14391],[16,14393,16,14395],[16,14397,16,14399],[16,14401,16,14403],[16,14405,16,14407],[16,14409,16,14411],[16,14365,16,14367],[16,14369,16,14371],[16,14373,16,14375],[16,14377,16,14379],[16,14381,16,14383],[16,14385,16,14387],[16,14341,16,14343],[16,14345,16,14347],[16,14349,16,14351],[16,14353,16,14355],[16,14357,16,14359],[16,14361,16,14363],[16,14317,16,14319],[16,14321,16,14323],[16,14325,16,14327],[16,14329,16,14331],[16,14333,16,14335],[16,14337,16,14339],[16,14293,16,14295],[16,14297,16,14299],[16,14301,16,14303],[16,14305,16,14307],[16,14309,16,14311],[16,14313,16,14315],[16,14269,16,14271],[16,14273,16,14275],[16,14277,16,14279],[16,14281,16,14283],[16,14285,16,14287],[16,14289,16,14291],[16,14245,16,14247],[16,14249,16,14251],[16,14253,16,14255],[16,14257,16,14259],[16,14261,16,14263],[16,14265,16,14267],[16,14221,16,14223],[16,14225,16,14227],[16,14229,16,14231],[16,14233,16,14235],[16,14237,16,14239],[16,14241,16,14243],[16,14197,16,14199],[16,14201,16,14203],[16,14205,16,14207],[16,14209,16,14211],[16,14213,16,14215],[16,14217,16,14219],[16,14173,16,14175],[16,14177,16,14179],[16,14181,16,14183],[16,14185,16,14187],[16,14189,16,14191],[16,14193,16,14195],[16,14149,16,14151],[16,14153,16,14155],[16,14157,16,14159],[16,14161,16,14163],[16,14165,16,14167],[16,14169,16,14171],[16,14125,16,14127],[16,14129,16,14131],[16,14133,16,14135],[16,14137,16,14139],[16,14141,16,14143],[16,14145,16,14147],[16,14101,16,14103],[16,14105,16,14107],[16,14109,16,14111],[16,14113,16,14115],[16,14117,16,14119],[16,14121,16,14123],[16,14077,16,14079],[16,14081,16,14083],[16,14085,16,14087],[16,14089,16,14091],[16,14093,16,14095],[16,14097,16,14099],[16,14053,16,14055],[16,14057,16,14059],[16,14061,16,14063],[16,14065,16,14067],[16,14069,16,14071],[16,14073,16,14075],[16,14029,16,14031],[16,14033,16,14035],[16,14037,16,14039],[16,14041,16,14043],[16,14045,16,14047],[16,14049,16,14051],[16,14005,16,14007],[16,14009,16,14011],[16,14013,16,14015],[16,14017,16,14019],[16,14021,16,14023],[16,14025,16,14027],[16,13981,16,13983],[16,13985,16,13987],[16,13989,16,13991],[16,13993,16,13995],[16,13997,16,13999],[16,14001,16,14003],[16,13957,16,13959],[16,13961,16,13963],[16,13965,16,13967],[16,13969,16,13971],[16,13973,16,13975],[16,13977,16,13979],[16,13933,16,13935],[16,13937,16,13939],[16,13941,16,13943],[16,13945,16,13947],[16,13949,16,13951],[16,13953,16,13955],[16,13909,16,13911],[16,13913,16,13915],[16,13917,16,13919],[16,13921,16,13923],[16,13925,16,13927],[16,13929,16,13931],[16,13885,16,13887],[16,13889,16,13891],[16,13893,16,13895],[16,13897,16,13899],[16,13901,16,13903],[16,13905,16,13907],[16,13861,16,13863],[16,13865,16,13867],[16,13869,16,13871],[16,13873,16,13875],[16,13877,16,13879],[16,13881,16,13883],[16,13837,16,13839],[16,13841,16,13843],[16,13845,16,13847],[16,13849,16,13851],[16,13853,16,13855],[16,13857,16,13859],[16,13813,16,13815],[16,13817,16,13819],[16,13821,16,13823],[16,13825,16,13827],[16,13829,16,13831],[16,13833,16,13835],[16,13789,16,13791],[16,13793,16,13795],[16,13797,16,13799],[16,13801,16,13803],[16,13805,16,13807],[16,13809,16,13811],[16,13765,16,13767],[16,13769,16,13771],[16,13773,16,13775],[16,13777,16,13779],[16,13781,16,13783],[16,13785,16,13787],[16,13741,16,13743],[16,13745,16,13747],[16,13749,16,13751],[16,13753,16,13755],[16,13757,16,13759],[16,13761,16,13763],[16,13717,16,13719],[16,13721,16,13723],[16,13725,16,13727],[16,13729,16,13731],[16,13733,16,13735],[16,13737,16,13739],[16,13693,16,13695],[16,13697,16,13699],[16,13701,16,13703],[16,13705,16,13707],[16,13709,16,13711],[16,13713,16,13715],[16,13669,16,13671],[16,13673,16,13675],[16,13677,16,13679],[16,13681,16,13683],[16,13685,16,13687],[16,13689,16,13691],[16,13645,16,13647],[16,13649,16,13651],[16,13653,16,13655],[16,13657,16,13659],[16,13661,16,13663],[16,13665,16,13667],[16,13621,16,13623],[16,13625,16,13627],[16,13629,16,13631],[16,13633,16,13635],[16,13637,16,13639],[16,13641,16,13643],[16,13597,16,13599],[16,13601,16,13603],[16,13605,16,13607],[16,13609,16,13611],[16,13613,16,13615],[16,13617,16,13619],[16,13573,16,13575],[16,13577,16,13579],[16,13581,16,13583],[16,13585,16,13587],[16,13589,16,13591],[16,13593,16,13595],[16,13549,16,13551],[16,13553,16,13555],[16,13557,16,13559],[16,13561,16,13563],[16,13565,16,13567],[16,13569,16,13571],[16,13525,16,13527],[16,13529,16,13531],[16,13533,16,13535],[16,13537,16,13539],[16,13541,16,13543],[16,13545,16,13547],[16,13501,16,13503],[16,13505,16,13507],[16,13509,16,13511],[16,13513,16,13515],[16,13517,16,13519],[16,13521,16,13523],[16,13477,16,13479],[16,13481,16,13483],[16,13485,16,13487],[16,13489,16,13491],[16,13493,16,13495],[16,13497,16,13499],[16,13453,16,13455],[16,13457,16,13459],[16,13461,16,13463],[16,13465,16,13467],[16,13469,16,13471],[16,13473,16,13475],[16,13429,16,13431],[16,13433,16,13435],[16,13437,16,13439],[16,13441,16,13443],[16,13445,16,13447],[16,13449,16,13451],[16,13405,16,13407],[16,13409,16,13411],[16,13413,16,13415],[16,13417,16,13419],[16,13421,16,13423],[16,13425,16,13427],[16,13381,16,13383],[16,13385,16,13387],[16,13389,16,13391],[16,13393,16,13395],[16,13397,16,13399],[16,13401,16,13403],[16,13357,16,13359],[16,13361,16,13363],[16,13365,16,13367],[16,13369,16,13371],[16,13373,16,13375],[16,13377,16,13379],[16,13333,16,13335],[16,13337,16,13339],[16,13341,16,13343],[16,13345,16,13347],[16,13349,16,13351],[16,13353,16,13355],[16,13309,16,13311],[16,13313,16,13315],[16,13317,16,13319],[16,13321,16,13323],[16,13325,16,13327],[16,13329,16,13331],[16,13285,16,13287],[16,13289,16,13291],[16,13293,16,13295],[16,13297,16,13299],[16,13301,16,13303],[16,13305,16,13307],[16,13261,16,13263],[16,13265,16,13267],[16,13269,16,13271],[16,13273,16,13275],[16,13277,16,13279],[16,13281,16,13283],[16,13237,16,13239],[16,13241,16,13243],[16,13245,16,13247],[16,13249,16,13251],[16,13253,16,13255],[16,13257,16,13259],[16,13213,16,13215],[16,13217,16,13219],[16,13221,16,13223],[16,13225,16,13227],[16,13229,16,13231],[16,13233,16,13235],[16,13189,16,13191],[16,13193,16,13195],[16,13197,16,13199],[16,13201,16,13203],[16,13205,16,13207],[16,13209,16,13211],[16,13165,16,13167],[16,13169,16,13171],[16,13173,16,13175],[16,13177,16,13179],[16,13181,16,13183],[16,13185,16,13187],[16,13141,16,13143],[16,13145,16,13147],[16,13149,16,13151],[16,13153,16,13155],[16,13157,16,13159],[16,13161,16,13163],[16,13117,16,13119],[16,13121,16,13123],[16,13125,16,13127],[16,13129,16,13131],[16,13133,16,13135],[16,13137,16,13139],[16,13093,16,13095],[16,13097,16,13099],[16,13101,16,13103],[16,13105,16,13107],[16,13109,16,13111],[16,13113,16,13115],[16,13069,16,13071],[16,13073,16,13075],[16,13077,16,13079],[16,13081,16,13083],[16,13085,16,13087],[16,13089,16,13091],[16,13045,16,13047],[16,13049,16,13051],[16,13053,16,13055],[16,13057,16,13059],[16,13061,16,13063],[16,13065,16,13067],[16,13021,16,13023],[16,13025,16,13027],[16,13029,16,13031],[16,13033,16,13035],[16,13037,16,13039],[16,13041,16,13043],[16,12997,16,12999],[16,13001,16,13003],[16,13005,16,13007],[16,13009,16,13011],[16,13013,16,13015],[16,13017,16,13019],[16,12973,16,12975],[16,12977,16,12979],[16,12981,16,12983],[16,12985,16,12987],[16,12989,16,12991],[16,12993,16,12995],[16,12949,16,12951],[16,12953,16,12955],[16,12957,16,12959],[16,12961,16,12963],[16,12965,16,12967],[16,12969,16,12971],[16,12925,16,12927],[16,12929,16,12931],[16,12933,16,12935],[16,12937,16,12939],[16,12941,16,12943],[16,12945,16,12947],[16,12901,16,12903],[16,12905,16,12907],[16,12909,16,12911],[16,12913,16,12915],[16,12917,16,12919],[16,12921,16,12923],[16,12877,16,12879],[16,12881,16,12883],[16,12885,16,12887],[16,12889,16,12891],[16,12893,16,12895],[16,12897,16,12899],[16,12853,16,12855],[16,12857,16,12859],[16,12861,16,12863],[16,12865,16,12867],[16,12869,16,12871],[16,12873,16,12875],[16,12829,16,12831],[16,12833,16,12835],[16,12837,16,12839],[16,12841,16,12843],[16,12845,16,12847],[16,12849,16,12851],[16,12805,16,12807],[16,12809,16,12811],[16,12813,16,12815],[16,12817,16,12819],[16,12821,16,12823],[16,12825,16,12827],[16,12781,16,12783],[16,12785,16,12787],[16,12789,16,12791],[16,12793,16,12795],[16,12797,16,12799],[16,12801,16,12803],[16,12757,16,12759],[16,12761,16,12763],[16,12765,16,12767],[16,12769,16,12771],[16,12773,16,12775],[16,12777,16,12779],[16,12733,16,12735],[16,12737,16,12739],[16,12741,16,12743],[16,12745,16,12747],[16,12749,16,12751],[16,12753,16,12755],[16,12709,16,12711],[16,12713,16,12715],[16,12717,16,12719],[16,12721,16,12723],[16,12725,16,12727],[16,12729,16,12731],[16,12685,16,12687],[16,12689,16,12691],[16,12693,16,12695],[16,12697,16,12699],[16,12701,16,12703],[16,12705,16,12707],[16,12661,16,12663],[16,12665,16,12667],[16,12669,16,12671],[16,12673,16,12675],[16,12677,16,12679],[16,12681,16,12683],[16,12637,16,12639],[16,12641,16,12643],[16,12645,16,12647],[16,12649,16,12651],[16,12653,16,12655],[16,12657,16,12659],[16,12613,16,12615],[16,12617,16,12619],[16,12621,16,12623],[16,12625,16,12627],[16,12629,16,12631],[16,12633,16,12635],[16,12589,16,12591],[16,12593,16,12595],[16,12597,16,12599],[16,12601,16,12603],[16,12605,16,12607],[16,12609,16,12611],[16,12565,16,12567],[16,12569,16,12571],[16,12573,16,12575],[16,12577,16,12579],[16,12581,16,12583],[16,12585,16,12587],[16,12541,16,12543],[16,12545,16,12547],[16,12549,16,12551],[16,12553,16,12555],[16,12557,16,12559],[16,12561,16,12563],[16,12517,16,12519],[16,12521,16,12523],[16,12525,16,12527],[16,12529,16,12531],[16,12533,16,12535],[16,12537,16,12539],[16,12493,16,12495],[16,12497,16,12499],[16,12501,16,12503],[16,12505,16,12507],[16,12509,16,12511],[16,12513,16,12515],[16,12469,16,12471],[16,12473,16,12475],[16,12477,16,12479],[16,12481,16,12483],[16,12485,16,12487],[16,12489,16,12491],[16,12445,16,12447],[16,12449,16,12451],[16,12453,16,12455],[16,12457,16,12459],[16,12461,16,12463],[16,12465,16,12467],[16,12421,16,12423],[16,12425,16,12427],[16,12429,16,12431],[16,12433,16,12435],[16,12437,16,12439],[16,12441,16,12443],[16,12397,16,12399],[16,12401,16,12403],[16,12405,16,12407],[16,12409,16,12411],[16,12413,16,12415],[16,12417,16,12419],[16,12373,16,12375],[16,12377,16,12379],[16,12381,16,12383]],"merged_total":20482,"flags":["merged_cut"]}
[]
[]
[null,"OSA Question","Does the supplier have a plan for proper identification, handling, packaging, storage, protection and preservation of all Ingersoll Rand products and materials?"]
[]
[null,"Reference Line no.(from OSA sheet)","GSQM 4.12 / ISO 8.5.4"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is the part identified in the production?","1.the line/machine for the part production\n2.the stop point of production, e.g. transfer area, segregation area and scrap area etc.","Check if container with a travel card or ID/mark in part level"]
[null,"Is the part's status identified in the production","1.travel card or process card whatever for each container or each part\n2.production log, record etc.","Check if steps/processes finished or to be finished in next is definitely marked in card and if the log noting the finished part volume regularly, half or one shift(optional)"]
[null,"Is the line/machine identified as which part is being produced","the line/machine for the part production","Check if the P/N(number and name)is marked on line/machining"]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system that stores serial number, date code, lot number and material certificate if required of all product. All raw materials have a bar code and finish goods have a bar code that contains serial number, date code, lot number, etc.. System will flag time sensitive materials and not allow them to be used. In addition, before being taking to the line the raw material is scanned and assigned to a BOM. The finished good has a serial number that is traceable to the used Raw Material"]
[4,"All product have a travel card or process card  for each container or each part the is identified and traceable."]
[3,"Some product has a travel card or process card  for each container or each part is identified with some traceability."]
[2,"Major lapse in product being identified and traceable. Travel card not always available."]
[1,"There is no system for identification, traceability, preservation and handling of product throughout all phases of production."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.1a","index":43,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[]
[]
[null,"OSA Question","Are in-process defects charted and analyzed to detect problem areas and defect trends?  Is in-process and final verification performance data collected, analyzed & charted against year-over-year improvement targets?      "]
[]
[null,"Reference Line no.","5.1a"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"What the procedure to capture defects data?","Quality Manual","Results/registrations of defects done pro process step, clear description of the failure found? "]
[null,"Is the responsibility of collecting and analyzing data defined?","Procedure\nOrg. Chart","Who collects the data?\nWho interprets the data and decides actions?"]
[null,"How is the performance monitored?","ERP system? \nProcess Documents.\nQuality Objectives","Analysis of the results, actions defined, implemented? Follow up of the effectiveness of the actions implemented.  \nCheck if Y-O-Y trends are monitored?"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Procedure in place to track internal and external failure for corrective actions. The supplier is collecting product performance data from in process and final testing or from inspection. Data is analyzed for trends, shifts in the process, and improvement year over year. Data is visually displayed with a clear indication of the performance. Evidence of defect analysis and charting at point of use, with widespread deployment and actions taken. PPM Goal in the plant."]
[4,"Limited procedures. Data collected, analyzed for trends, shifts in the process, and improvement year over year. Data is visually displayed, with indication of the performance. Evidence of defect analysis, charting with deployment and actions taken."]
[3,"In process defects found, will be analyzed and recorded. No actions defined. "]
[2,"In process found defects, will be scrapped without analyzing. No actions defined. "]
[1,"No system in place."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.1b","index":44,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Is non-conforming material sufficiently identified and segregated at all stages of the process?"]
[]
[null,"Reference Line no.","5.1b"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? ","Quality Manual? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? "]
[null,"Clear labels.","ERP system","Link between the label, PO, supplier, and parts? Location of the goods? "]
[null,"Who is responsible? ",null,"To verify with the area responsible? "]
[]
[null,"Scoring Pattern:- "]
[5,"Clear procedure in place. Responsibilities defined. Non conforming material will be identified properly and locked in cage with minimal ageing. Clear overviews are available of the blocked parts. Actions defined. Monitored every day. Cost of blocked material will be reported, targets defined.  "]
[4,"Clear procedure in place. Responsibilities defined. Non conforming material will be identified and placed immediately in dedicated areas. "]
[3,"No procedure or instructions in place. Non conforming material will be identified, no actions taken. "]
[2,"No procedure in place.  Responsible defined. "]
[1,"No procedure in place.  No corrective actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.1c","index":45,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*Is it defined who has authority to release and disposition non-conforming material?"]
[]
[null,"Reference Line no.","5.1c"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? ","Quality Manual? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? "]
[null,"Who is responsible for identification? Identification on the \nparts, and in the system? Parts blocked no further use possible? ","Receiving inspection? Production/manufacturing? Shipment? \nERP system?","Identification? Parts returned to suppliers/subcontractors? Deviation requests? Parts scrapped? Clear registrations/overview? "]
[null,"Blocked parts, waiting for further use or to be returned or scrapped.","Block area? ","Clear identified block area? And a clear and updated overview of the parts inside with actions defined, responsible and due dates."]
[]
[null,"Scoring Pattern:- "]
[5,"Clear procedure in place. Responsibilities defined. Follow up on actions defined and taken.  Clear targets defined, due dates to \"solve\" the issues. Targets monitored. If targets not being met, actions will be taken. "]
[4,"Clear procedure in place. Responsibilities defined. Follow up on actions defined and taken.  "]
[3,"Procedure in place. Responsibilities defined, no actions taken. "]
[2,"No procedure in place.  Responsible defined. "]
[1,"No procedure in place.  No corrective actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.1d","index":46,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Is there a notification and containment procedure for when non-conforming material has been shipped?"]
[]
[null,"Reference Line no.","5.1d"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? ","Quality Manual? Sales instructions? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? "]
[null,"Communication towards the customer? ","ERP system? ","To verify the communication content based on an example. Follow up and verification? \nAgreements made with the customer? "]
[null,"Who is responsible? ","Quality department? Sales? Plant manager? ","Documents used ? Suppliers feedback? "]
[]
[null,"Scoring Pattern:- "]
[5,"Notification to customer is given out a must and containment is provided at levels."]
[4,"Clear procedure available. Responsibilities defined. Clear follow up available and reported.  "]
[3,"No procedure or instructions in place. Follow up on reporting to the customers available. Targets defined. "]
[2,"No procedure in place. Responsible defined. "]
[1,"No procedure in place. No actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.2","index":47,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the supplier have a system to track Ingersoll Rand SCAR (Supplier Corrective Action Requests) / NCM reports?\nAre common root causes being addressed and resolved?\nDoes supplier apply same tracking on internal defects?"]
[]
[null,"Reference Line no.",5.2]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? ","Quality manual for the procedure? ","Clear overview of field problems registered /accepted"]
[null,"System implemented to register field issues, reported by \ncustomers or service technicians.","ERP or engineering system? ","Way of communication? Who is responsible? Actions defined on the short term and long term. \nProposed improvements checked are tested? \nFeedback of customers/field in regards the improvements implemented?"]
[null,"Investigations done on in warranty returned parts/goods?  ",null,"Corrections actions defined, implemented & closed? "]
[]
[null,"Scoring Pattern:- "]
[5,"Field Return and Corrective Action (FRACAS) or similar electronic system in place. Documented process for field calls and complaints. Data is recorded and analyzed with action items taken. Corrective actions generated with Design Engineering and Manufacturing with root cause analysis. Pareto available on the top issues with year over year improvements. "]
[4,"Procedure in place by manual control. Field problems tracked, corrective actions defined. Engineering involved to assure design & product improvements."]
[3,"Field problems tracked, corrective actions defined and implemented. No product /design improvements will be defined.  "]
[2,"Field problems tracked, NO actions defined. "]
[1,"No system in place in regards field issues and corrective actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.3a","index":48,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Does the organization have a defined process for problem solving leading to root cause identification and elimination?  Examples of problem solving processes are:\n· 5 Why’s\n· 8D\n· Fishbone"]
[]
[null,"Reference Line no.","5.3a"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure in place? ","Quality Manual? ","Controlled doc? Date stamped, initial release, revision(s), history, responsible for the doc, responsible for the release? "]
[null,"Systems applied? ","ERP system? ","Depending on the problem/issue, who has the lead?  \nWhich are the tools in use? "]
[null,"Results before and after if the root cause is defined and preventive actions are implemented?","ERP system? ","Scrap rate, before and after actions implemented? \nPPM numbers?\n8D reports?\nQ-corner info? \nMOM?"]
[]
[null,"Scoring Pattern:- "]
[5,"8D's are used in comprehensive form, Root cause both at occurrence and systemic level are identified and corrective actions are secured. The learning is horizontally deployed throughout the organization."]
[4,"Clear procedure available. Responsibilities defined. Clear system & tools implemented in regards root cause identification and elimination. Follow up available and reported.  "]
[3,"No procedure or instructions in place. No clear problem solving tools implemented. If problems occurring, solved but not system supported.  "]
[2,"No procedure in place.  Responsible defined. "]
[1,"No procedure in place.  No actions defined. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.3b","index":49,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,7,13,14],[19,2,20,3],[2,1,3,1],[2,2,3,2],[2,3,4,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3]]}
[]
[]
[null,"OSA Question","*Is supplier using 8D methodology for internal,  external issues. Is problem solving process defined? Are root causes analyzed and corrective, preventive actions established and carried on? What is the output of problem solving process?"]
[]
[null,"New question ","5.3b"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"8D or problem solving procedure.","QMS system","Coherent procedure with defined tools and stakeholders. Described process."]
[null,"List of preventive and corrective actions.","Records, on-line system.","Look if history is visible. Look if list is communicated to stakeholders. Open and closed corrective/preventive actions. "]
[null,"Investigations done on all parts/cases/goods which trigger problem solving process.  ",null,"Corrective/preventive actions defined, implemented & closed?  Systemic actions on place."]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system in use with implemented 8D methodology. Supporting data/documents available on-line. Corrective and preventive actions automatically listed to CA/PA list. Automatically tracking with alerts for all stakeholders. Procedure at the QMS.",null,null,5,{"$f":"LEN(B13)","v":251}]
[4,"Any system available in use with implementing 8D methodology. Corrective and preventive actions are forwarded to CA/PA, lists for all stakeholders. Procedure present at the suppliers QMS. Connection to other documents OK. ",null,null,4,{"$f":"LEN(B14)","v":222}]
[3,"Internal and external complaints tracked. Actions defined. Minor lapses in root cause analysis and coherence with procedure.\nDocuments not updated properly, actions not followed in some cases. Procedure exists in QMS. Connection to other documents ok. ",null,null,3,{"$f":"LEN(B15)","v":252}]
[2,"Internal and external complaints tracked, no actions defined.",null,null,2,61]
[1,"No documents available.",null,null,1,23]
[null,null,null,null,0]
[null,"Back to the OSA Questionnaire"]

{"sheet":"5.3c","index":50,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","*What process does the supplier have in place to assure that corrective actions are documented in PFMEA and are leading to updates / revision of the Process control plan ( look at process flow chart as well)? Does supplier update PFMEA with the corrective actions from 8D reports?"]
[]
[null,"New OSA question","5.3c"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Customer Complaints, internal corrective actions, supplier complaints, internal complaints","P-FMEA (team), Control Plan(s) and Flow Chart(s)","Look for first release date, version and last update dates. Controlled document?\nReview if actions in P-FMEA are closed and lower RPN scores are achieved"]
[null,"Documented procedure as part of QMS","QMS, procedures","Verify content of the procedure, version, updates,…"]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Documented procedure in place, supported by a P-FMEA IT solution, linked with clear evidence on updates of PCP and Flow Charts",null,null,5]
[4,"Documented procedure in place, with clear evidence found in the P-FMEA on the inclusion of customer complaints. Clear evidence on updates of PCP",null,null,4]
[3,"Documented procedure in place. Not all corrective actions are embedded in the P-FMEA, PCP or Process Flowchart",null,null,3]
[2,"No Documented procedure in place. Minority of corrective actions are leading to updates and revisions of P-FMEA, PCP or Process Flowchart",null,null,2]
[1,"No documented procedure in place. Customer Complaints are not leading to any Corrective Actions. No updates of P-FMEA, PCP or Process Flowchart",null,null,1]
[null,0,null,null,0]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.5","index":51,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","* Does the supplier obtain customers' approval from for temporary changes to existing product and processes prior to releasing product for shipment or authorizing production to proceed? \nFor Ingersoll Rand the supplier shall utilize the \"Supplier Deviation Request\" (SDR). "]
[]
[null,"New OSA question",5.5]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Does the supplier have a procedure for concession or deviation management?","Quality Manual","Look for procedure, Engineering Change Request forms, 30 day postings."]
[null,"Does the supplier have an electronic system to manage deviation / concession for product / process deviations?","Engineering & Production department","Have the supplier show you the system and go through three random examples of product or process changes."]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic system with e-mail sign-off for all concessions / deviations linked to the documentation control system that insures all applicable procedures and drawings are revised to reflect the product or process change. Fool-proof system of notification to customer (where ever applicable) exists.",null,null,5]
[4,"Manual excel based tracker system in place for all deviation / concession monitoring. Waiver is get approved from customer and monitoring through manual system",null,null,4]
[3,"Supplier has a paper system for all deviation / concession monitoring.  They manually track all entries to make sure that all applicable deviation / concession closure time however minor lapses in monitoring the time line.",null,null,3]
[2,"Supplier has a system in place to track product or process changes however major lapses in compliance can be found.",null,null,2]
[1,"Supplier has no system in place.",null,null,1]
[null,0,null,null,0]
[null,"Back to OSA Questionnaire"]

{"sheet":"5.6","index":52,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,3],[16,1,16,3],[2,1,3,1],[2,2,3,2],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[null,"OSA Question","Does the manufacturing process improvement continually focus upon control and reduction of variation in product characteristics and manufacturing process parameters?  Do they use:\n· Value Stream Mapping\n· SPC Data \n· Pareto Analysis \n· Capability Studies   "]
[]
[null,"Reference Line no.(from OSA sheet)",5.6]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is continuous improvement evident in suppliers facility?","General all functions","Check if supplier has a Continuous Improvement as a Quality Objective defined.\nCheck if all functions have the improvement targets and methodologies defined."]
[null,"What are the different tools used for improvement?","All Functions\nContinuous Improvement Cell.","Are tools like Six Sigma, DOE, Capability etc. known to supplier? Is training on these tools Evident? \nAre these tools judiciously used to drive improvement? Are tangible improvement in terms of Quality improvement, cost reduction, Cycle time improvement etc. evident."]
[]
[]
[null,"Scoring Pattern:- "]
[5,"Full tool usage for the commodity and evidence that metrics are impacted by the continual use of the tools.  Deployed across the entire facility and evidence is validated.  Tools used are common languages and the entire organization embraces the tools. Improvement projects like Six Sigma, Lean , TPM, TPS etc. are extensively used and tangible results have been achieved."]
[4,"Adequate tools for the commodity used - minimum of Pareto analysis used that shows evidence of driving improvements. SDE to make judgment based on commodity and product to what level of tools have to be used."]
[3,"Tools in place but gaps in usage - systems work but lack of discipline and minor gaps or lapses seen."]
[2,"Very limited or few tools available but not used or properly used at the point of the issue"]
[1,"Nothing in place and no evidence of activity using any of the tools"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"6","index":53,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,1,17,3],[18,1,18,3],[2,1,3,1],[2,2,3,2],[14,1,14,3],[15,1,15,3],[16,1,16,3]]}
[]
[]
[null,"OSA Question","Is there a method of measuring their performance against customer expectations?  Does it include the following:\n· Customer Complaints (SCAR's)\n· On Time Delivery (delivery performance)\n· DPPM (part quality performance)\n· Lead Time \n· Warranty and Field Returns\n- Major Disruptions"]
[]
[null,"Reference Line no.",6]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Is there a questionnaire forwarded to the customer to fill in. \nOTD? PPM? Lead time? \n","Database, ERP/SAP system, electronic document etc.","Results/feedback received of the customers to check  -> conclusions made, actions defined? "]
[null,"Is there an overview available of the customer complaints \nreceived, follow up on the status? ","MOM management reviews? ","Customer complaints, analyzed? Actions defined? Feedback given (8D reports)? "]
[null,"System implemented to calculate PPM numbers, internal & external PPM? Reporting",null,"PPM numbers analyzed? Actions defined? Scrap analysis? "]
[null,"Is there a  monitoring system implemented for the first pass Yield? ",null,"First pass yield -> results target against the results? Target not met, actions defined? "]
[null,"Or targets defined in regards these matrixes?"]
[]
[null,"Scoring Pattern:- "]
[5,"Performance metrics defined, tangible, readily available and displayed at function and level and are controlled online. An indicator of performance against the defined goals must be available for each Function. Y-O-Y performance monitoring is available (Electronic Display)"]
[4,"Performance metrics are Extensive, tangible, readily available and displayed at function and level and are controlled Manually. An indicator of performance against the defined goals must be available for each function. (Manual Display, updated regularly)"]
[3,"Performance metrics are not extensively defined, minor lapses of compliance with defined goals."]
[2,"Performance metrics are not extensively defined,  performance results out of the defined goals and no evidence of documented actions to drive improvements."]
[1,"Performance is not monitored."]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"7a","index":54,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,1,19,3],[17,1,17,3],[18,1,18,3],[2,1,3,1],[2,2,3,2],[14,1,14,3],[15,1,15,3],[16,1,16,3]]}
[]
[]
[null,"OSA Question","Does the supplier understand IR logistics chain and forecast? Does the supplier have and maintain clearly defined safety stocks calculation methods?"]
[]
[null,"Reference Line no.","7a"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"IR or other customers' volume demanding forecast","Sales dept., Logistic dept., Warehouse or Inventory Management ","Customer forecast document"]
[null,"IR or other customer parts' logistics requirement",null,"Supplier's production plan matching with forecast"]
[null,"IR or other customer parts' logistics plan",null,"Logistics planning"]
[null,"IR or other customers' safety stock requirement, e.g. SOMI (consignment stock). ",null,"Safety stock planning and calculation method etc."]
[null,"Supplier's safety stocks calculation methods",null,"Inventory list"]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic list of main customers' forecast and list in roll. The production plan and inventory are corresponding to customer forecast. Effective safety stock calculation method is applied."]
[4,"There's the updated customer forecast. The production plan and inventory are corresponding to customer forecast. "]
[3,"There's the customer forecast. The production plan and inventory are following customer forecast. "]
[2,"No customer forecast, but there's safety stock, or there's forecast without production plan and inventory."]
[1,"No forecast, no safety stock if necessary."]
["N/A","N/A can only be selected in the case of a new supplier"]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"7b","index":55,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[2,1,3,1],[2,2,3,2],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[]
[]
[null,"OSA Question","Are Capacity & production Planning discussed during a daily meeting? Are customer requirements taken into consideration?"]
[]
[null,"Reference Line no.","7b"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Capacity Plan","Production dept.","Daily meeting minutes or log etc."]
[null,"Production Plan","Planning functional team","Production dept.' s regular capacity study result"]
[null,"Customer requirement introduction","Review with the management ","Periodic Production plan"]
[null,"Q-inputs, rejects, customer complaints",null,"Top management review evidence for capacity"]
[]
[null,"Scoring Pattern:- "]
[5,"Electronic capacity study and monitor tool are applied. Production planning are reviewed daily. Customer requirement, capacity result and production plan are regularly reviewed by appropriate management level."]
[4,"The capacity and production planning are reviewed daily. Customer requirement are reviewed by appropriate management."]
[3,"Capacity and production planning are reviewed, but loss of management review to customer requirement."]
[2,"Capacity or production plan are not updated."]
[1,"No capacity study or production plan. "]
[]
[null,"Back to OSA Questionnaire"]

{"sheet":"7c","index":56,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,1,17,3],[18,1,18,3],[2,1,3,1],[2,2,3,2],[14,1,14,3],[15,1,15,3],[16,1,16,3]]}
[]
[]
[null,"OSA Question","Detailed capacity plan covers complete process lead time including lead-times of purchases of raw material for production? (Short term) \n\nIs there a Mid/ long term capacity plan? What is time horizon?  Is the suppliers strategic production Business plan aligned with this capacity plan?"]
[]
[null,"Reference Line no.","7c"]
[null,"Approach:-"]
[null,"What to look for:- ","Where to look :- ","How Much to look :"]
[null,"Procedure that defines implementation of Capacity plan","QMS + capacity template"]
[null,"Procedure considers mid and long term plan","QMS + capacity template"]
[null,"Level of detail of capacity plan: global/per station","QMS + capacity template"]
[null,"Link with forecast to suppliers and their capacity","ERP tool, link Production/Purchasing/Forecast to suppliers","some examples and potential corrective actions in case of capacity problem"]
[null,"Link with contingency plan"]
[]
[null,"Scoring Pattern:- "]
[5,"Clear Procedure in QMS, Capacity monitored in ERP system,  with weekly monitoring and corrective/preventive actions in place. Clear forecasts to suppliers and capacity assessment. Clear link with contingency plan"]
[4,"Clear Procedure in QMS, with weekly monitoring and corrective/preventive actions in place. Clear forecasts to suppliers and capacity assessment"]
[3,"Clear Procedure in QMS, ad hoc monitoring and corrective in place. Clear forecasts to suppliers and capacity assessment"]
[2,"Procedure in QMS but not fully implemented, no forecast to suppliers"]
[1,"No capacity plan in place"]
[]
[null,"Back to OSA Questionnaire"]