{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Audit Questionnaire","Instructions","Change History"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Audit Questionnaire","index":0,"n_rows":202,"n_cols":14,"rows_kept":202,"cut":false,"hidden":false,"merged":[[132,6,132,11],[119,6,119,11],[82,1,82,10],[114,6,114,11],[123,6,123,11],[124,6,124,11],[130,6,130,10],[88,1,89,1],[122,6,122,10],[111,1,112,1],[118,3,118,5],[118,6,118,11],[81,6,81,11],[57,0,57,12],[58,1,59,1],[58,2,59,5],[58,6,59,11],[58,12,59,12],[61,3,61,5],[61,6,61,11],[62,3,62,5],[62,6,62,11],[70,6,70,10],[71,3,71,5],[71,6,71,11],[72,3,72,5],[72,6,72,11],[73,3,73,5],[73,6,73,11],[74,3,74,5],[74,6,74,11],[75,3,75,5],[75,6,75,11],[76,3,76,5],[45,1,45,7],[47,1,47,12],[46,1,46,12],[87,0,87,12],[90,6,90,10],[91,3,91,5],[91,6,91,11],[90,1,90,5],[80,3,80,5],[80,6,80,11],[81,3,81,5],[63,3,63,5],[63,6,63,11],[64,3,64,5],[64,6,64,11],[65,3,65,5],[65,6,65,11],[66,3,66,5],[66,6,66,11],[67,3,67,5],[67,6,67,11],[76,6,76,11],[88,6,89,11],[88,2,89,5],[30,1,33,1],[30,2,30,4],[31,2,31,4],[31,11,31,12],[32,2,32,4],[32,11,32,12],[33,2,33,4],[33,11,33,12],[149,2,149,12],[148,2,148,12],[134,3,134,5],[102,3,102,5],[126,3,126,5],[115,3,115,5],[123,3,123,5],[125,6,125,11],[126,6,126,11],[92,3,92,5],[92,6,92,11],[93,3,93,5],[93,6,93,11],[97,3,97,5],[97,6,97,11],[98,3,98,5],[205,2,205,12],[204,2,204,12],[199,2,199,12],[202,2,202,12],[203,2,203,12],[198,2,198,12],[201,1,201,12],[190,1,190,12],[197,2,197,12],[186,1,186,2],[169,1,169,2],[152,1,152,2],[155,1,155,2],[154,1,154,2],[150,2,150,12],[110,0,110,12],[125,3,125,5],[143,2,143,12],[140,2,140,12],[133,3,133,5],[124,3,124,5],[114,3,114,5],[173,1,173,2],[172,1,172,2],[153,1,153,2],[168,1,168,2],[167,1,167,2],[166,1,166,2],[165,1,165,2],[164,1,164,2],[163,1,163,2],[156,1,156,2],[132,3,132,5],[206,2,206,12],[207,2,207,12],[208,2,208,12],[28,1,28,4],[29,2,29,4],[35,2,35,4],[37,2,37,4],[36,2,36,4],[191,2,191,12],[192,2,192,12],[193,2,193,12],[194,2,194,12],[195,2,195,12],[196,2,196,12],[185,1,185,2],[184,1,184,2],[183,1,183,2],[182,1,182,2],[181,1,181,2],[177,1,177,2],[176,1,176,2],[171,1,171,2],[175,1,175,2],[174,1,174,2],[0,0,0,12],[2,0,2,5],[5,0,5,2],[11,0,11,2],[12,0,12,2],[6,6,6,7],[10,3,10,5],[2,6,2,12],[7,6,7,7],[9,6,9,7],[3,6,4,7],[4,8,4,12],[6,8,6,12],[7,8,7,12],[8,8,8,12],[9,8,9,12],[10,8,10,12],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[3,3,3,5],[5,3,5,5],[88,12,89,12],[34,1,37,1],[39,2,39,4],[38,2,38,4],[41,2,41,4],[40,2,40,4],[38,1,41,1],[34,2,34,4],[51,1,51,2],[51,4,51,12],[52,1,52,2],[52,4,52,12],[53,1,53,2],[55,1,55,2],[53,4,53,12],[49,1,49,12],[42,2,42,4],[50,1,50,2],[50,4,50,12],[48,1,48,7],[54,1,54,2],[55,4,55,12],[54,4,54,12],[77,1,77,10],[29,11,29,12],[30,11,30,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[42,11,42,12],[41,11,41,12],[40,11,40,12],[134,6,134,11],[133,6,133,11],[127,6,127,11],[127,3,127,5],[111,12,112,12],[98,6,98,11],[96,6,96,10],[103,6,103,11],[104,3,104,5],[104,6,104,11],[111,2,112,5],[111,6,112,11],[101,6,101,10],[101,1,101,5],[96,1,96,5],[102,6,102,11],[103,3,103,5],[131,3,131,5],[131,6,131,11],[116,3,116,5],[116,6,116,11],[117,3,117,5],[117,6,117,11],[119,3,119,5],[145,2,145,12],[146,2,146,12],[147,2,147,12],[141,2,141,12],[142,2,142,12],[144,2,144,12],[171,3,171,11],[173,3,173,11],[153,3,153,11],[152,3,152,11],[157,3,157,11],[169,3,169,11],[167,3,167,11],[168,3,168,11],[172,3,172,11],[156,3,156,11],[155,3,155,11],[154,3,154,11],[186,3,186,11],[174,3,174,11],[175,3,175,11],[176,3,176,11],[177,3,177,11],[178,3,178,11],[179,3,179,11],[180,3,180,11],[181,3,181,11],[182,3,182,11],[183,3,183,11],[13,3,13,5],[12,3,12,5],[11,3,11,5],[24,1,24,12],[20,0,20,12],[11,8,11,12],[12,8,12,12],[13,8,13,12],[17,5,17,12],[14,8,14,12],[14,3,14,5],[188,3,188,11],[178,1,178,2],[179,1,179,2],[180,1,180,2],[157,1,157,2],[160,3,160,11],[158,3,158,11],[159,3,159,11],[161,3,161,11],[162,3,162,11],[163,3,163,11],[164,3,164,11],[165,3,165,11],[166,3,166,11],[158,1,158,2],[159,1,159,2],[161,1,161,2],[187,3,187,11],[162,1,162,2],[160,1,160,2],[188,1,188,2],[187,1,187,2],[184,3,184,11],[185,3,185,11]]}
["JOHN DEERE JDS-G223 PRODUCT ENGINEERING ADDENDUM QUESTIONNAIRE"]
["V2.2"]
["Supplier Information",null,null,null,null,null,"Audit Information"]
[null,"JD Number:",null,null,null,null,"Supplier Qualification System Audit Number:"]
[]
["Name:"]
[null,null,"Address:",null,null,null,"Actual Audit Date(s):"]
[null,null,null,null,null,null,"Audit Lead:"]
[]
[null,null,null,null,null,null,"Audit Team Members:"]
[null,null,null,"Engineering Contact:"]
["Name:"]
["Position:",null,null,null,null,null,null,"Other Team Participants:"]
[null,null,"Phone No.:"]
[null,null,"E-Mail:"]
[]
[]
[null,null,null,"Process(es) / Product(s) Audited:  "]
[]
[]
["Registration Certifications"]
[null,"  Note:  Secure copy of certification(s) if not provided in advance and upload into Supplier Qualification System certification storage"]
[]
[null," Quality System Certification, Registrar, & Date of Certificate Expiration (ISO, QS, ISO/TS, etc.):"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Audit Summary"]
[null,"Category","Section",null,null,"Number of Questions","Answered Questions","Maximum Points","Achieved Points","Percent Achieved","Avg. Score","Compliance"]
[null,"Prod Dev","Product Development ",null,null,{"$f":"SUM(F32:F34)","v":15},{"$f":"SUM(G32:G34)","v":0},{"$f":"SUM(H32:H34)","v":60},{"$f":"SUM(I32:I34)","v":0},{"$f":"I31/H31","v":0},{"$f":"IF(G31=F31,I31/G31,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(K31),(IF(COUNTIF(L32:L34,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"1.  Product Development Planning",null,null,7,{"$f":"COUNTA(M62:M68)","v":0},{"$f":"F32*4","v":28},{"$f":"SUM(M62:M68)","v":0},0,"?",{"$f":"IF(ISNUMBER(K32),M70,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"2.  Product Development Demonstration",null,null,6,{"$f":"COUNTA(M72:M77)","v":0},24,{"$f":"SUM(M72:M77)","v":0},0,"?",{"$f":"IF(ISNUMBER(K33),M79,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"3.  Product Development Planning",null,null,2,{"$f":"COUNTA(M81:M82)","v":0},8,{"$f":"SUM(M81:M82)","v":0},0,"?",{"$f":"IF(ISNUMBER(K34),M84,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,"Rel Eng","Reliability Engineering",null,null,{"$f":"SUM(F36:F38)","v":8},{"$f":"SUM(G36:G38)","v":0},32,0,{"$f":"I35/H35","v":0},"?",{"$f":"IF(ISNUMBER(K35),(IF(COUNTIF(L36:L38,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"1. Reliability Engineering Planning",null,null,3,{"$f":"COUNTA(M92:M94)","v":0},{"$f":"F36*4","v":12},{"$f":"SUM(M92:M94)","v":0},0,"?",{"$f":"IF(ISNUMBER(K36),M96,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"2. Reliability Engineering Demonstration",null,null,2,{"$f":"COUNTA(M98:M99)","v":0},8,{"$f":"SUM(M98:M99)","v":0},0,"?",{"$f":"IF(ISNUMBER(K37),M101,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"3. Reliability Engineering Monitoring",null,null,3,{"$f":"COUNTA(M103:M105)","v":0},12,{"$f":"SUM(M103:M105)","v":0},0,"?",{"$f":"IF(ISNUMBER(K38),M107,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,"V&V","Validation and Verification",null,null,{"$f":"SUM(F40:F42)","v":15},{"$f":"SUM(G40:G42)","v":0},{"$f":"SUM(H40:H42)","v":60},0,{"$f":"I39/H39","v":0},{"$f":"IF(G39=F39,I39/G39,\"?\")","v":"?"},{"$f":"IF(ISNUMBER(K39),(IF(COUNTIF(L40:L42,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"1. Validation and Verification Planning",null,null,6,{"$f":"COUNTA(M115:M120)","v":0},{"$f":"F40*4","v":24},{"$f":"SUM(M115:M120)","v":0},0,"?",{"$f":"IF(ISNUMBER(K40),M122,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"2. Validation and Verification Development",null,null,5,{"$f":"COUNTA(M124:M128)","v":0},20,{"$f":"SUM(M124:M128)","v":0},0,"?",{"$f":"IF(ISNUMBER(K41),M130,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"3. Validation and Verification Monitoring",null,null,4,{"$f":"COUNTA(M132:M135)","v":0},16,{"$f":"SUM(M132:M135)","v":0},0,"?",{"$f":"IF(ISNUMBER(K42),M137,\"NOT SCORED\")","v":"NOT SCORED"}]
[null,null,"Total Audit",null,null,{"$f":"SUM(F31,F35,F39)","v":38},{"$f":"SUM(G31,G35,G39)","v":0},{"$f":"H31+H35+H39","v":152},{"$f":"SUM(I31,I35,I39)","v":0},0,{"$f":"IF(G43=F43,I43/(G43),\"?\")","v":"?"},{"$f":"IF(OR(J43<=0.65,COUNTIF(L31:L42,\"DOES NOT COMPLY\")>0),\"DOES NOT COMPLY\",IF(COUNTIF(L31:L42,\"NOT SCORED\")>0,\"NOT SCORED\",\"COMPLIES\"))","v":"DOES NOT COMPLY"}]
[]
[null,"There are 36 total questions. They are scored \"0-4\" for a maximum of 144 points"]
[null,"Each question is scored using a 0 to 4 point scale, where 4 is the best possible score."]
[null,"A supplier must have a score of 2 or greater on each of the questions to be acceptable. Scores of 2 or less require corrective action."]
[null,"A score of 3 indicates the requirement is met, effectively implemented and documented.   It is also used if a question is not applicable."]
[null," "]
[null,"GENERAL SUPPLIER RATING CRITERIA"]
[null,"Rating",null,"Score **","Ability to meet requirement in question:"]
[null,"Does Not Comply",null,0,"Requirement is not met.  There is no evidence of implementation or documentation (major non-conformance)."]
[null,"Does Not Comply",null,"1","Requirement is partially met but there are major inconsistencies in implementation or documentation (major nonconformance)."]
[null,"Complies",null,2,"Requirement is met but there are minor inconsistencies in implementation or documentation, or is in the early phases and only preliminary evidence of implementation effectiveness exists (minor nonconformance)."]
[null,"Complies",null,3,"Requirement is met, effectively implemented and fully documented.   (or if question is not applicable)"]
[null,"Complies",null,4,"The supplier's processes or actions virtually guarantees that a non-conformance can NEVER happen.  They are fully compliant in all instances to following the defined process. (i.e. \"World Class\")"]
[]
["Product Development"]
[null,"#","Interview Questions",null,null,null,"Notes and supporting evidence",null,null,null,null,null,"Score 0-4 0=low"]
[]
[null,"A. Product Development Planning",null,null,null,null,null,null,null,null,null,null,"Score"]
[null,1," ","How is customer application data collected and managed for products?"]
[null,2," ","What is your strategy for Research & Development of new technology? "]
[null,3," ","How do you measure program risk / readiness?"]
[null,4," ","How do you benchmark your product performance and value against competitors? "]
[null,5," ","How are teams identified and used to develop new products?"]
[null,6," ","What skill sets and training are required for the product development team?"]
[null,7," ","What is your process for identifying improvement opportunities?"]
[null,"Product Development Planning Average Section Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M62:M68)),AVERAGE(M62:M68),\"\")","v":""}]
[null,"Product Development Planning Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M69),(IF(MIN(M62:M68)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"B. Product Development Demonstration",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,8," ","How do you turn customer requirements into product design parameters and specifications? "]
[null,9," ","How are design analysis and computer aided engineering resources utilized? "]
[null,10," ","What is your process for creation of product design standards and procedures?"]
[null,11," ","How do you verify your product will perform at the extreme limits of its specified operating conditions?"]
[null,12," ","How does your process enable earlier identification of issues during new product development?"]
[null,13," ","What is your process for developing and providing prototype parts to the customer?"]
[null,"Product Development Deployment Section Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M72:M77)),AVERAGE(M72:M77),\"\")","v":""}]
[null,"Product Development Deployment Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M78),(IF(MIN(M72:M77)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"C. Product Development Monitoring",null,null,null,null,null," ",null,null,null,null,"Score"]
[null,14," ","What types of reviews are conducted during product development, who is included, and how frequently do they occur?"]
[null,15," ","How do you update your design processes and procedures based on lessons learned from programs? "]
[null,"Product Development Monitoring Section Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M81:M82)),AVERAGE(M81:M82),\"\")","v":""}]
[null,"Product Development Monitoring Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M83),(IF(MIN(M81:M82)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"Product Development Category Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M69,M78,M83)),AVERAGE(M69,M78,M83),\"\")","v":""}]
[null,"Product Development Category Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M85),(IF(MIN(M82,M81,M77,M76,M75,M74,M73,M72,M68,M67,M66,M65,M64,M63,M62)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[]
["Reliability Engineering"]
[null,"#","Interview Questions",null,null,null,"Notes and supporting evidence",null,null,null,null,null,"Score 0-4 0=low"]
[]
[null,"D.   Reliability Engineering Planning",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,16," ","What is your process for understanding the customer reliability requirements?",null,null," "]
[null,17," ","How do you determine that customer's reliability requirements are achievable?",null,null," "]
[null,18," ","What reliability planning is conducted to ensure that customers requirements are demonstrated during the product life cycle?"]
[null,"Reliability Engineering Section Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M92:M94)),AVERAGE(M92:M94),\"\")","v":""}]
[null,"Reliability Engineering Planning Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M95),(IF(MIN(M92:M94)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"E. Reliability Engineering Demonstration",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,19," ","What reliability methods and tools do you use (FMEA, Life Data Analysis, Accelerated Life Testing, etc.), and when are they applied? "]
[null,20," ","How are reliability goals allocated to your key sub-tier suppliers?"]
[null,"Reliability Engineering Demonstration Section Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M98:M99)),AVERAGE(M98:M99),\"\")","v":""}]
[null,"Reliability Engineering Demonstration Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M100),(IF(MIN(M98:M99)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"F. Reliability Engineering Monitoring",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,21," ","What metrics and goals are used for tracking reliability during the different stages of development and use?",null,null," "]
[null,22," ","How do you collect and analyze reliability data during product development, production, and useful life to assure the goals are met?"]
[null,23," ","What is the process for failure reporting and corrective action, and how do communicate these to the customer? "]
[null,"Reliability Engineering Monitoring Section Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M103:M105)),AVERAGE(M103:M105),\"\")","v":""}]
[null,"Reliability Engineering Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M106),(IF(MIN(M103:M105)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"Reliability Engineering Category Average Score:",null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),#REF!/#REF!,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M95,M100,M106)),AVERAGE(M95,M100,M106),\"\")","v":""}]
[null,"Compliance Category compliance:    (Complies = All above sections comply)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M108),(IF(MIN(M105,M104,M103,M99,M98,M94,M93,M92)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[]
["Verification and Validation"]
[null,"#","Interview Questions",null,null,null,"Notes and supporting evidence",null,null,null,null,null,"Score 0-4 0=low"]
[]
[null,"G. Verification and Validation Planning"]
[null,24," ","What is the reporting structure for the organization responsible for verification and validation of design requirements? "]
[null,25," ","What is your process for developing a design verification and validation plan?"]
[null,26,null,"How do you ensure independent review of the Functional Safety verification and validation plan?"]
[null,27,null,"How do you evaluate your test resources (equipment, facilities, external labs, sub-tier suppliers) to assure the needs of the test plan can be met? "]
[null,28,null,"How do you manage your test priorities between customers? "]
[null,29,null,"How do you evaluate need for investments in future design verification and validation capabilities and growth?"]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M115:M120)),AVERAGE(M115:M120),\"\")","v":""}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M121),(IF(MIN(M115:M116)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"H. Verfication and Validation Demonstration",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,30,null,"What metrics are being tracked during execution of the design verification and validation plan to demonstrate you meet the customer requirements of the product?"]
[null,31,null,"How do you interact with outside testing sources, when required?"]
[null,32,null,"What is your process to document, update and control procedures and work instructions for design verification and validation activities?"]
[null,33,null,"How is component level testing/analysis used to minimize field test to verify component life requirements?"]
[null,34,null,"How is the design verification and validation process applied to current product improvements, product updates and revisions?"]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M124:M128)),AVERAGE(M124:M128),\"\")","v":""}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M129),(IF(MIN(M124:M128)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"I. Verfication and Validation Monitoring",null,null,null,null," ",null,null,null,null,null,"Score"]
[null,35,null,"How is the design verification and validation plan executed, and how much is completed prior to production release?"]
[null,36,null,"How do you ensure independent review of the results of the Functional Safety verification and validation activities?"]
[null,37,null,"How do you communicate design verification and validation results to your customers, demonstrating that they meet end use requirements?"]
[null,38,null,"What is your document retention policy for design verification and validation test results?"]
[null,"Verificaton and Validation Monitoring Average Section Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M132:M135)),AVERAGE(M132:M135),\"\")","v":""}]
[null,"Verification and Validation Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M136),(IF(MIN(M131:M135)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[null,"Verificaton and Validation Category Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(M121,M129,M136)),AVERAGE(M121,M129,M136),\"\")","v":""}]
[null,"Verification and Validation Category Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M138),(IF(MIN(M135, M134, M132, M128, M127, M126, M125, M124, M120, M118, M117, M116, M115)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"NOT SCORED"}]
[]
[null,null,"Strengths"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question #",null,"Major Non-conformances",null,null,null,null,null,null,null,null,"CAR #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question #",null,"Minor Non-conformances",null,null,null,null,null,null,null,null,"CAR #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Opportunities for Improvement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Restrictions and Conclusions"]

{"sheet":"Instructions","index":1,"n_rows":103,"n_cols":3,"rows_kept":103,"cut":false,"hidden":false,"merged":[[71,1,71,2],[76,1,76,2],[0,0,0,2],[1,0,1,2],[3,1,3,2],[13,1,13,2],[14,1,14,2],[31,1,31,2],[59,1,59,2],[62,1,62,2]]}
["JOHN DEERE JDS-G223 SUPPLIER QUALITY SYSTEM QUESTIONNAIRE"]
["INSTRUCTIONS"]
["Select the category that you would like to review."]
["1.","Audit Purpose"]
["2.","Pre-Audit Survey"]
["3.","Audit Planning"]
["4.","Conducting the Audit"]
["5.","Audit Scoring Definitions"]
["6.","Audit Scoring"]
["7.","Scoring Scale"]
["8.","Completing the Audit"]
["9.","Storing the Audit"]
[]
["1.","Audit Purpose"]
[null,"This JDS-G223 Supplier Quality System Audit is designed to get information from an existing or a potential supplier to evaluate their quality and compliance processes to determine if they are capable to be a supplier for John Deere.  It is designed to be completed during an on-site facility visit.  It can  also be used to communicate Deere's expectations to an existing or a potential supplier."]
[null,"This Supplier Quality System Audit Process has the following objectives:"]
[null,"A.","Evaluate new and existing Supplier’s ability to effectively execute quality processes required by the John Deere Supplier Quality Manual (JDS-G223) and compliance to the Supplier Code of Conduct."]
[null,"B.","Facilitate an understanding of the JDS-G223 and Supplier Code of Conduct requirements by using them as audit standards."]
[null,"C.","Facilitate improvement in a Supplier's quality system by driving corrective action in areas of nonconformance."]
[null,"D.","Provide Supplier Code of Conduct notification of noncompliance."]
[null,"E.","Provide input regarding Supplier's performance to the Enterprise."]
[null,"F.","Audit results will be used to objectively evaluate Suppliers and assist in facilitating Supplier Selection and Development.  Audit results will also be used to improve the Enterprise supply base."]
[]
["2.","Pre-Audit Survey"]
[null,"A.","Deere supply management organizations should use some form of Pre-Audit Survey to screen potential suppliers.  While the specific content of the Pre-Audit Survey may vary by unit and product, the survey should be comprised of questions pulled from the Supplier Profile Survey Questionnaire.  Questions pulled for the Pre-Audit Survey are to retain the original question number."]
[null,"B.","A Pre-Audit Survey should be conducted prior to a supplier site visit.  This is done by sending the survey questionnaire to the supplier for a self-assessment.  The survey results are then reviewed for adequacy prior to planning a site visit or audit."]
[null,"C.","The Supplier Profile Survey and JDS-G223 Supplier Quality System Audit Questionnaire were developed as tools to assist in providing a consistent view of supplier capabilities.  They do not cover product-specific questions such as design, manufacturing, quality, or performance characteristics.  Product / process specific topics must be addressed as needed by technically competent auditors."]
[" ","D.","When an on-site quality system audit is conducted, the JDS-G223 Supplier Quality System Audit Questionnaire should be used. "]
[null,"E.","Use the Process(es) / Product(s) Audited area on the Audit Questionnaire header to indicate which products or processes were specifically covered during the audit."]
[]
["3.","Audit Planning"]
[null,"One of the objectives of the Quality System Audit is to improve Supplier performance.  Since limited audit resources are available the auditor should strive to focus the audit in areas that offer the greatest opportunity for improvement.  Several suggestions in this regard follow:"]
[null,"A.","Whenever possible, the audit should focus on the production of Deere parts that represent both a significant portion of the purchased material and a family of significance.  However, major quality issues with the Supplier should take priority to volume.  This will increase the probability that Supplier improvement activities resulting from the audit are focused in areas of greatest benefit to the Enterprise.  For example, one of the audit outcomes may be to identify Key Characteristics.  If this is undertaken, it should be on part families that are significant in terms of issues and/or volume."]
[null,"B.","Corrective action requests, reject, and deviation history should be reviewed prior to the audit so that verification of Supplier corrective action can be established.  Assessment of Supplier corrective action processes using specific examples is preferred to a general review of the Supplier's corrective action process."]
[null,"C.","The Supplier's quality procedures should be reviewed prior to a Supplier site visit."]
[]
["4.","Conducting the Audit"]
[null,"A.","Evidence is required to  justify assessment observations and findings, antidotal information is not sufficient."]
[null,"B.","During the audit, notes should be made in the auditor's note areas to support both positive and negative findings."]
[null,"C.","Nonconformance's should be discussed during the audit as they are identified.  Address containment if there are issues concerning the production of nonconforming material."]
[]
["5.","Audit Scoring Definitions"]
[null,"Major Nonconformance"]
[null,"A.","The absence or total breakdown of a system to meet a JDS-G223 requirement.  A number of nonconformities against one requirement which, when combined, can represent a total breakdown of the system and thus be considered a major nonconformity."]
[null,"B.","Any nonconformance that would result in the probable shipment of a nonconforming product.  A condition that may result in a failure or that materially reduces the usability of the products or services for their intended purpose."]
[null,"C.","A nonconformance that judgment and experience indicates is likely either to result in the failure of the quality system or to materially reduce its ability to assure controlled processes and products."]
[null,"D.","Major non-conformances should have the findings documented in the \"Major Nonconformance's\" section of the audit as well as in the audit report.  Nonconformance's should be documented in the Nonconforming Corrective Action (NCCA) System."]
[]
[null,"Minor Nonconformance "]
[null,"A JDS-G223 nonconformance that judgment and experience indicates is not likely to:"]
[null,"A.","result in the failure of the quality system, or"]
[null,"B.","reduce its ability to assure controlled processes, or "]
[null,"C.","result in the probable shipment of nonconforming product."]
[null,"It may be either:"]
[null,"D.","a failure in some part of the supplier's documented quality system relative to JDS-G223, or"]
[null,"E.","one or more observed lapses in following a requirement of the company's quality system."]
[null,"F.","Minor non-conformances should have the findings documented in the \"Minor Nonconformance\" section of the audit as well as in the audit report.  Nonconformance's should be documented in the Nonconforming Corrective Action (NCCA) System."]
[]
[null,"Opportunity for Improvement "]
[null,"An observed situation which is NOT a major or minor nonconformity, but where results achieved are not world class.  These opportunities shall be recorded in the final audit report."]
[]
["6.","Audit Scoring"]
[null,"The audit is scored as follows:"]
[null,"A.","Every question must be scored using a 0 to 4 point scale, where 4 is the best possible score.  Whole numbers are to be used.  See Scoring Scale."]
[null,"B.","The section scores are rounded to tenths, and determined by calculating an average of the questions scored from that section."]
[null,"C.","The category ratings are rounded to tenths, and are determined by calculating an average of all the questions scored in that category.  To be acceptable, a supplier MUST receive two or above on each question.  If one or more of the question ratings fall below two, the final category rating will be DOES NOT COMPLY."]
[null,"D.","The overall numeric rating is an average for each of the sections covered in the audit and an overall ranking of COMPLIES or DOES NOT COMPLY.   The overall rating is an average rating based on the section ratings.  To be acceptable, a supplier MUST receive two or above on each question.  If any question is scored less than two, the overall rating will be DOES NOT COMPLY.  "]
[null,"E.","The final audit score is expressed as a percentage.  There are 72 scaled questions (3 questions are yes/no) with a maximum score of (72)*(4) = 288 points.  When you divide the total score by 288, you have a result in percent.  For example, if the total audit score was 216 points (all questions score  = 3), the  calculated average score expressed in percent is (216)/(288) = 75%."]
[null,"F.","In order to pass this audit, the supplier must meet 2 criteria's.  Criteria 1: Overall score of 65% or greater.  Criteria 2: All questions must score a 2 or greater.  NOTE: If a supplier scores a 2 on all questions, this will result in a overall score of 50% (which is not a passing score)"]
[null,"G.","The scores allow effective evaluation of the Supplier and also identifies the Supplier’s strengths and weaknesses."]
[]
[null,"Quality Category:  Determination of compliance with requirements of JDS-G223 Supplier Quality Manual:"]
[null,"H.","Compliance to the requirements identified in the John Deere Supplier Quality Manual is evaluated for each audit question and for the overall audit.  A rating of “Complies” or “Does Not Comply” will result."]
[null,"I.","Any major nonconformance on any question will result in a Section ranking of DOES NOT COMPLY and an overall audit ranking of DOES NOT COMPLY."]
[null,"J.","Any major nonconformance (score of  0 or 1) or minor nonconformance (score of 2)  on any question will require the issuance of a Corrective Action Request to the Supplier."]
[]
[null,"Compliance Category:  Determination of compliance with requirements of the Supplier Code of Conduct:"]
[null,"K.","Scores of 0 or 1 on any Code of Conduct question results in failure of the audit and must be reported by the Lead Auditor to:  WWSM, Compliance Manager at 90smcompliance@johndeere.com      No business shall be conducted with the supplier until the situation is rectified. "]
[null,"L.","If the first Code of Conduct question is a \"No\"; audit should be terminated.   Lead Auditor must report to:  WWSM, Compliance Manager at 90smcompliance@johndeere.com  "]
[]
["7.","Scoring Scale"]
[null,"Mark the score for each question in the questionnaire as follows:"]
[null,"SCORE","ABILITY TO MEET REQUIREMENT"]
[null,0,"Requirement is not met.  There is no evidence of implementation or documentation (major non-conformance)."]
[null,1,"Requirement is partially met but there are major inconsistencies in implementation or documentation (major nonconformance)."]
[null,2,"Requirement is met but there are minor inconsistencies in implementation or documentation, or is in the early phases and only preliminary evidence of implementation effectiveness exists (minor nonconformance)."]
[null,3,"Requirement is met and effectively implemented and fully documented or if question is not applicable."]
[null,4,"The supplier's processes or actions virtually guarantees that a non-conformance can NEVER happen.  They are fully compliant in all instances to following the defined process. (i.e. \"World Class\")"]
[]
["8.","Completing the Audit"]
[null,"A.","The audit report and / or scoring should be completed and shared with the Supplier before departure if possible.  At a minimum, the Supplier should be advised of any nonconformance's.  Containment should be addressed if there are issues concerning the production of nonconforming material. "]
[null,"B.","During the audit, provide the supplier feedback during a closing meeting.  Follow-up with the final written report within two weeks."]
[null,"C.","Complete comment areas on the audit form to summarize:"]
[null,null,"     Supplier strengths"]
[null,null,"     Supplier major and minor nonconformance's"]
[null,null,"     Supplier opportunities for improvement"]
[null,null,"     Restrictions and Conclusions"]
[null,"D.","Open a Nonconformance Corrective Action (NCCA) request for the supplier on each major and minor nonconformity.  Provide the NCCA number in the final report."]
[null,"E.","Use the Restrictions and Conclusions section of the Supplier Audit to indicate which products were specifically approved, rejected, or not covered during the audit, and provide a brief summary supporting the supplier rating."]
[]
["9.","Storing the Audit (Deere Internal Use)"]
[null,"A.","After completing the audit, upload the completed audit into the Supplier Qualification System."]
[null,null,"NCCA System"]

{"sheet":"Change History","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,0,2,3],[1,0,1,3]]}
["JOHN DEERE PRODUCT ENGINEERING QUESTIONNAIRE"]
[]
["CHANGE HISTORY"]
["Date","Division","Who Made Changes","Reason for Change"]
["2021-07-08","A&T","Langness Jeffrey S","A cross-functional team consisting of Enterprise Functional Safety, Large Tractor and ISG representatives has reviewed and updated the Product Engineering Questionnaire within the Product Engineering Assessment process to include supplier assessment elements mandated by Functional Safety Standards such as but not limited to ISO25119 and ISO26262. These changes enable John Deere to assess a potential supplier’s Functional Safety Management System, processes and execution. The need for procedural and system changes to the supplier assessment process was identified during a “Three-legged-five-why” analysis of a near miss involving a functional safety related system.\n\nQuestions Added:\nQuestion 26: How do you ensure independent review of the Functional Safety verification and validation plan?\nQuestion 36: How do you ensure independent review of the results of the Functional Safety verification and validation activities?"]
["2021-08-19","ETEC","Mayur Jagtap","Updated Question 32 to provide clarify and alignment with Likert\n\nWas: How do you execute procedures and work instructions for design verification and validation activities?\n\nChange: What is your process to document, update and control procedures and work instructions for design verification and validation activities?"]