{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Audit Questionnaire","Instructions","Change History"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":314,"n_cols":14,"rows_kept":314,"cut":false,"hidden":false,"merged":[[29,1,29,11],[27,1,27,11],[25,1,25,11],[18,4,18,11],[21,0,21,11],[80,8,80,10],[67,1,68,1],[67,11,68,11],[71,1,71,11],[70,8,70,10],[36,2,36,4],[42,1,59,1],[58,2,58,4],[57,2,57,4],[56,2,56,4],[55,2,55,4],[15,3,15,5],[14,3,14,5],[13,3,13,5],[12,3,12,5],[15,8,15,11],[14,8,14,11],[13,8,13,11],[12,8,12,11],[11,8,11,11],[96,8,96,10],[85,8,85,10],[86,8,86,10],[86,2,86,4],[85,2,85,4],[84,2,84,4],[60,2,60,4],[59,2,59,4],[95,2,95,4],[94,2,94,4],[93,2,93,4],[92,2,92,4],[96,2,96,4],[67,5,67,7],[67,8,68,10],[70,5,70,7],[69,1,69,4],[70,2,70,4],[105,8,105,10],[106,8,106,10],[107,8,107,10],[105,2,105,4],[107,2,107,4],[8,3,8,5],[9,3,9,5],[10,8,10,11],[9,8,9,11],[8,8,8,11],[75,8,75,10],[104,8,104,10],[73,8,73,10],[74,8,74,10],[83,8,83,10],[102,2,102,4],[102,5,102,7],[102,8,102,10],[101,8,101,10],[93,8,93,10],[94,8,94,10],[101,1,101,4],[91,1,91,4],[95,8,95,10],[124,1,124,7],[125,1,125,7],[35,1,41,1],[81,2,81,4],[82,2,82,4],[83,2,83,4],[80,1,80,4],[73,2,73,4],[72,1,72,4],[43,2,43,4],[42,2,42,4],[54,2,54,4],[53,2,53,4],[52,2,52,4],[51,2,51,4],[50,2,50,4],[62,1,63,11],[121,1,121,2],[121,4,121,11],[103,8,103,10],[91,8,91,10],[81,8,81,10],[82,8,82,10],[84,8,84,10],[141,11,144,11],[205,11,208,11],[184,1,188,1],[180,3,180,5],[179,3,179,5],[181,6,181,10],[180,6,180,10],[179,6,179,10],[0,0,0,11],[3,0,3,5],[6,0,6,2],[12,0,12,2],[13,0,13,2],[7,6,7,7],[11,3,11,5],[3,6,3,11],[8,6,8,7],[10,6,10,7],[4,6,5,7],[7,3,7,5],[6,3,6,5],[4,3,4,5],[7,8,7,11],[5,8,5,11],[258,2,258,11],[259,2,259,11],[261,2,261,11],[262,2,262,11],[263,2,263,11],[232,11,235,11],[205,2,208,2],[183,6,183,10],[188,6,188,10],[186,6,186,10],[185,6,185,10],[184,6,184,10],[196,6,196,10],[204,3,204,5],[204,6,204,10],[207,6,207,10],[206,6,206,10],[215,6,215,10],[231,3,231,5],[216,3,216,5],[215,3,215,5],[209,3,209,5],[209,6,209,10],[257,2,257,11],[132,3,132,5],[182,3,182,5],[146,3,146,5],[145,3,145,5],[140,3,140,5],[146,6,146,10],[184,2,188,2],[138,6,138,10],[141,2,144,2],[172,3,172,5],[188,3,188,5],[152,3,152,5],[153,3,153,5],[152,6,152,10],[153,6,153,10],[159,6,159,10],[159,3,159,5],[166,6,166,10],[165,6,165,10],[166,3,166,5],[165,3,165,5],[320,2,320,11],[33,1,33,4],[34,2,34,4],[37,2,37,4],[41,2,41,4],[40,2,40,4],[39,2,39,4],[38,2,38,4],[49,2,49,4],[48,2,48,4],[47,2,47,4],[46,2,46,4],[45,2,45,4],[44,2,44,4],[303,2,303,11],[304,2,304,11],[305,2,305,11],[306,2,306,11],[67,2,68,4],[307,2,307,11],[308,2,308,11],[309,2,309,11],[286,3,286,10],[284,1,284,2],[318,2,318,11],[319,2,319,11],[284,3,284,10],[297,1,297,2],[296,1,296,2],[295,1,295,2],[294,1,294,2],[293,1,293,2],[292,1,292,2],[291,1,291,2],[286,1,286,2],[289,3,289,10],[290,3,290,10],[291,3,291,10],[290,1,290,2],[289,1,289,2],[288,1,288,2],[300,1,300,2],[299,1,299,2],[298,1,298,2],[287,1,287,2],[288,3,288,10],[287,3,287,10],[283,3,283,10],[130,2,131,2],[118,1,118,2],[118,4,118,11],[119,1,119,2],[119,4,119,11],[120,1,120,2],[144,3,144,5],[143,3,143,5],[142,3,142,5],[141,3,141,5],[144,6,144,10],[143,6,143,10],[142,6,142,10],[141,6,141,10],[140,6,140,10],[139,6,139,10],[131,6,131,10],[131,3,131,5],[179,11,181,11],[172,6,172,10],[181,3,181,5],[141,1,144,1],[179,2,181,2],[281,1,281,2],[280,1,280,2],[279,1,279,2],[278,1,278,2],[277,1,277,2],[276,1,276,2],[275,1,275,2],[282,3,282,10],[281,3,281,10],[280,3,280,10],[279,3,279,10],[278,3,278,10],[276,3,276,10],[275,3,275,10],[277,3,277,10],[232,1,235,1],[223,3,223,5],[271,1,271,2],[271,3,271,10],[274,1,274,2],[273,1,273,2],[266,2,266,11],[267,2,267,11],[268,2,268,11],[269,2,269,11],[272,1,272,2],[274,3,274,10],[273,3,273,10],[272,3,272,10],[231,6,231,10],[224,6,224,10],[264,2,264,11],[265,2,265,11],[232,2,235,2],[260,2,260,11],[234,6,234,10],[235,6,235,10],[244,6,244,10],[243,6,243,10],[283,1,283,2],[282,1,282,2],[179,1,181,1],[127,0,127,11],[66,0,66,11],[133,3,133,5],[139,3,139,5],[132,6,132,10],[133,6,133,10],[122,1,122,2],[122,4,122,11],[117,1,117,2],[117,4,117,11],[120,4,120,11],[75,2,75,4],[72,8,72,10],[116,1,116,11],[106,2,106,4],[92,8,92,10],[104,2,104,4],[74,2,74,4],[145,6,145,10],[103,2,103,4],[92,5,92,7],[195,6,195,10],[182,6,182,10],[232,6,232,10],[233,6,233,10],[207,3,207,5],[206,3,206,5],[205,3,205,5],[225,3,225,5],[224,3,224,5],[208,6,208,10],[205,6,205,10],[223,6,223,10],[225,6,225,10],[183,3,183,5],[184,3,184,5],[185,3,185,5],[186,3,186,5],[187,3,187,5],[196,3,196,5],[184,11,188,11],[195,3,195,5],[198,6,198,10],[197,6,197,10],[205,1,208,1],[208,3,208,5],[317,2,317,11],[292,3,292,10],[293,3,293,10],[294,3,294,10],[295,3,295,10],[296,3,296,10],[297,3,297,10],[298,3,298,10],[299,3,299,10],[316,2,316,11],[311,2,311,11],[314,2,314,11],[315,2,315,11],[310,2,310,11],[313,1,313,11],[302,1,302,11],[244,3,244,5],[243,3,243,5],[235,3,235,5],[216,6,216,10],[234,3,234,5],[233,3,233,5],[232,3,232,5],[237,3,237,5],[236,3,236,5],[198,3,198,5],[197,3,197,5],[237,6,237,10],[236,6,236,10]]}
["JOHN DEERE JDS-G223i (Indirect Material & Services) SUPPLIER QUALITY SYSTEM QUESTIONNAIRE"]
["V1.0"]
[]
["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,null,"Audit Lead:"]
[]
[null,null,null,null,null,null,"Audit Team Members:"]
[null,null,null,"Quality 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," Environmental System Certification, Registrar & Date of Expiration (ISO 14001):  "]
[]
[null," Health & Safety System Certification, Registrar & Date of Expiration (ISO 18001, SA 8000):   "]
[]
[]
[]
[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,"Compliance","Code of Conduct (Mandatory)",null,null,1,{"$f":"COUNTA(L71)","v":1},null,null,null,null,{"$f":"IF(LEFT(L71,1)=\"n\",\"DOES NOT COMPLY\",IF(LEFT(L71,1)=\"y\",\"COMPLIES\",\"NOT SCORED\"))","v":"COMPLIES"}]
[null,null,"Compliance",null,null,{"$f":"F38","v":20},{"$f":"G38","v":20},{"$f":"H38","v":72},{"$f":"I38","v":54},{"$f":"I37/H37","v":0.75},{"$f":"IF(G37=F37,I37/(G37-2),\"Unanswered Question\")","v":3},{"$f":"IF(ISNUMBER(K37),L38,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"1.  Code of Conduct  ***",null,null,{"$f":"SUM(F39:F42)","v":20},{"$f":"SUM(G39:G42)","v":20},{"$f":"SUM(H39:H42)","v":72},{"$f":"SUM(I39:I42)","v":54},0.75,{"$f":"IF(G38=F38,I38/(G38-2),\"Unanswered Question\")","v":3},{"$f":"IF(ISNUMBER(K38),(IF(COUNTIF(L39:L42,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"A.  Labor and Human Rights",null,null,3,{"$f":"COUNTA(L74:L76)","v":3},{"$f":"F39*4","v":12},{"$f":"SUM(L74:L76)","v":9},0.75,{"$f":"IF(G39=F39,I39/G39,\"Unanswered Question\")","v":3},{"$f":"IF(ISNUMBER(K39),L79,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"B.  Health and Safety",null,null,6,{"$f":"COUNTA(L82:L87)","v":6},24,{"$f":"SUM(L82:L87)","v":18},0.75,3,{"$f":"IF(ISNUMBER(K40),L90,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"C.  Environment",null,null,5,{"$f":"COUNTA(L93:L97)","v":5},{"$f":"(F41-1)*4","v":16},{"$f":"SUM(L94:L97)","v":12},0.75,{"$f":"IF(G41=F41,I41/(G41-1),\"Unanswered Question\")","v":3},{"$f":"IF(ISNUMBER(K41),L100,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"D.  Ethics (Confidential Info. & Intellectual Property)",null,null,6,{"$f":"COUNTA(L103:L108)","v":6},{"$f":"(F42-1)*4","v":20},{"$f":"SUM(L104:L108)","v":15},0.75,{"$f":"IF(G42=F42,I42/(G42-1),\"Unanswered Question\")","v":3},{"$f":"IF(ISNUMBER(K42),L111,\"NOT SCORED\")","v":"COMPLIES"}]
[null,"Quality","Quality",null,null,{"$f":"SUM(F44,F51,F53,F57)","v":35},{"$f":"SUM(G44,G51,G53,G57)","v":35},{"$f":"SUM(H44,H51,H53,H57)","v":140},{"$f":"SUM(I44,I51,I53,I57)","v":105},0.75,3,{"$f":"IF(ISNUMBER(K43),(IF(COUNTIF(L44:L60,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"2.  Quality Planning",null,null,{"$f":"SUM(F45:F50)","v":13},{"$f":"SUM(G45:G50)","v":13},{"$f":"SUM(H45:H50)","v":52},{"$f":"SUM(I45:I50)","v":39},0.75,3,{"$f":"IF(ISNUMBER(K44),(IF(COUNTIF(L45:L50,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"E.  Management Review",null,null,2,{"$f":"COUNTA(L133:L134)","v":2},8,{"$f":"SUM(L133:L134)","v":6},0.75,3,{"$f":"IF(ISNUMBER(K45),L137,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"F.  Quality Planning",null,null,5,{"$f":"COUNTA(L140:L147)","v":5},20,{"$f":"SUM(L140:L147)","v":15},0.75,3,{"$f":"IF(ISNUMBER(K46),L150,\"NOT SCORED\")","v":"COMPLIES"},null," "]
[null,null,"G.  Document Control",null,null,2,{"$f":"COUNTA(L153:L154)","v":2},8,{"$f":"SUM(L153:L154)","v":6},0.75,3,{"$f":"IF(ISNUMBER(K47),L157,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"H.  Product Identification and Traceability",null,null,1,{"$f":"COUNTA(L160:L160)","v":1},4,{"$f":"SUM(L160:L160)","v":3},0.75,3,{"$f":"IF(ISNUMBER(K48),L163,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null," I.  Training",null,null,2,{"$f":"COUNTA(L166:L167)","v":2},8,{"$f":"SUM(L166:L167)","v":6},0.75,3,{"$f":"IF(ISNUMBER(K49),L170,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"J.  Statistical Techniques",null,null,1,{"$f":"COUNTA(L173:L173)","v":1},4,{"$f":"SUM(L173:L173)","v":3},0.75,3,{"$f":"IF(ISNUMBER(K50),L176,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"3.  Process Control",null,null,{"$f":"SUM(F52)","v":4},{"$f":"SUM(G52)","v":4},{"$f":"SUM(H52)","v":16},{"$f":"SUM(I52)","v":12},0.75,3,{"$f":"IF(ISNUMBER(K51),(IF(COUNTIF(L52,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"K.  Process Control",null,null,4,{"$f":"COUNTA(L180:L189)","v":4},16,{"$f":"SUM(L180:L189)","v":12},0.75,3,{"$f":"IF(ISNUMBER(K52),L192,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"4.  Inspection and Testing",null,null,{"$f":"SUM(F54:F56)","v":9},{"$f":"SUM(G54:G56)","v":9},{"$f":"SUM(H54:H56)","v":36},{"$f":"SUM(I54:I56)","v":27},0.75,3,{"$f":"IF(ISNUMBER(K53),(IF(COUNTIF(L54:L56,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null," L.  Inspection and Testing",null,null,4,{"$f":"COUNTA(L196:L199)","v":4},16,{"$f":"SUM(L196:L199)","v":12},0.75,3,{"$f":"IF(ISNUMBER(K54),L202,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"M.  Inspection, Measuring & Test Equipment",null,null,3,{"$f":"COUNTA(L205:L210)","v":3},12,{"$f":"SUM(L205:L210)","v":9},0.75,3,{"$f":"IF(ISNUMBER(K55),L213,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"N.  Quality Audits",null,null,2,{"$f":"COUNTA(L216:L217)","v":2},8,{"$f":"SUM(L216:L217)","v":6},0.75,3,{"$f":"IF(ISNUMBER(K56),L220,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"5.  Nonconformance and Corrective Action",null,null,{"$f":"SUM(F58:F60)","v":9},{"$f":"SUM(G58:G60)","v":9},{"$f":"SUM(H58:H60)","v":36},{"$f":"SUM(I58:I60)","v":27},0.75,3,{"$f":"IF(ISNUMBER(K57),(IF(COUNTIF(L58:L60,\"DOES NOT COMPLY\")>0,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"O.  Control of Nonconforming Product",null,null,3,{"$f":"COUNTA(L224:L226)","v":3},12,{"$f":"SUM(L224:L226)","v":9},0.75,3,{"$f":"IF(ISNUMBER(K58),L229,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"P.  Corrective and Preventive Action",null,null,4,{"$f":"COUNTA(L232:L238)","v":4},16,{"$f":"SUM(L232:L238)","v":12},0.75,3,{"$f":"IF(ISNUMBER(K59),L241,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"Q.  Storage, Packaging, and Preservation",null,null,2,{"$f":"COUNTA(L244:L245)","v":2},8,{"$f":"SUM(L244:L245)","v":6},0.75,3,{"$f":"IF(ISNUMBER(K60),L248,\"NOT SCORED\")","v":"COMPLIES"}]
[null,null,"Total Audit",null,null,{"$f":"SUM(F37,F43,F36)","v":56},{"$f":"SUM(G37,G43,G36)","v":56},{"$f":"SUM(H37,H43)","v":212},{"$f":"SUM(I37,I43)","v":159},0.75,{"$f":"IF(G61=F61,I61/(G61-3),\"Unanswered Question\")","v":3},{"$f":"IF(OR(J61<=0.65,COUNTIF(L36:L60,\"DOES NOT COMPLY\")>0),\"DOES NOT COMPLY\",IF(COUNTIF(L36:L60,\"NOT SCORED\")>0,\"NOT SCORED\",\"COMPLIES\"))","v":"COMPLIES"}]
[]
[null,"***  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 \n      Manager at 90smcompliance@johndeere.com      No business shall be conducted with the supplier until the situation is rectified.  \n***  A supplier must have a score of 2 or greater on each of the questions to be acceptable. \n***  Score as 3 when requirement is met, effectively implemented and documented.   (or if question is not applicable)"]
[]
[]
[]
["Compliance"]
[null,"#","Interview Questions",null,null,"Compliance Scoring Criteria",null,null,"Notes and supporting evidence",null,null,"Score 0-4 0=low"]
[null,null,null,null,null,0,3,4]
[null,"1.  Supplier Code of Conduct"]
[null,"CC01","Supplier has procedures in place designed to ensure that the requirements set out in John Deere’s Supplier Code of Conduct are met?",null,null,"Is  Supplier aware of the Deere code of conduct and know where to locate it? What evidence do they have to meet Deere Supplier Code of Conduct?   (STOP Audit if No)",null,null,null,null,null,"yes"]
[]
[null,"A. Labor and Human Rights",null,null,null,0,3,4,"Notes "]
[null,"LH01","Does the supplier have a policy and process to ensure compliance with applicable laws concerning discrimination in hiring and employment practices?",null,null,"No policy","Have a documented policy.","Have a mature documented policy and no record of any violations.",null,null,null,3]
[null,"LH02","Does the supplier have an accurate system to measure hours worked to ensure conformance with applicable wage and hour labor laws?",null,null,"Anything illegal","Have a system to ensure hours legally worked.","System virtually guarantee's hours are legally worked for all employees.",null,null,null,3]
[null,"LH03","Does the supplier have a system to ensure compliance with the minimum working age prevailing standard? (Minimum working age for John Deere suppliers is 14 years.) ",null,null,"less than14 years old","14-18 years old","Over 18 years old",null,null,null,3]
[]
[null,"Labor and Human Rights Section Average Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L74:L76)),AVERAGE(L74:L76),\"\")","v":3}]
[null,"Labor and Human Rights Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L78),(IF(MIN(L74:L76)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"B. Health and Safety",null,null,null,0,3,4,"Notes "]
[null,"HS01","Is the supplier currently, or at any time during the past 1-3 years, subject to any enforcement action by any governmental authority for non-compliance with safety, or labor requirements at any facility at which products supplied to John Deere are manufactured?",null,null,"Current significant un-resolved violations","Some violations in last 3 years with documented resolution"," No violations in last 5 years",null,null,null,3]
[null,"HS02","Can the supplier demonstrate legal compliance with government environmental, health and safety legislation (through government certificate or registration, 3rd-party audit, etc.)?",null,null,"Company states they are not currently compliant","Clean and has documented compliance certificates or registration through third party audits.","ISO 14001 and OHSAS 18000 certified, facility is very clean",null,null,null,3]
[null,"HS03","Does the supplier have a program to identify and assess potential emergency situations such as weather, fire, or chemical spills and implement emergency plans and procedures?",null,null,"Not in place:\n-Any program\n-Employee training\n-Emergency signs\n-MSDS files.\n-Spill equipment  \n","In Place:\n-Documented program\n-Employee training and records\n-Emergency equipment/signs\n-Spill Equipment","Plus:\n-Mature program\n-Safety committee  \n-All records complete and up to date.  \n-All equipment/signs well maintained",null,null,null,3]
[null,"HS04","Does the supplier have a program to identify, evaluate and control workplace exposures to chemical, biological and physical agents (e.g. chemical fumes, noise, dust, mold) at or below levels established as safe by applicable laws and regulations?",null,null,"Not in place:\n-Any program\n-Employee training\n-Emergency signs\n-MSDS files.\n-Spill equipment  \n","In Place:\n-Documented program\n-Employee training and records\n-Emergency equipment/signs\n-Spill Equipment","Plus:\n-Mature program\n-Safety committee  \n-All records complete and up to date.  \n-All equipment/signs well maintained",null,null,null,3]
[null,"HS05","Does the supplier have a program to identify, evaluate and control safety hazards (e.g. electrical, mechanical, hydraulic, and pneumatic) of workplace equipment and machinery and conditions (e.g. slips, trips, fall hazards, physically demanding work) to prevent injury to workers?",null,null,"Not in place:\n-Any program\n-Employee training\n-Emergency signs\n-MSDS files.\n-Spill equipment  \n","In Place:\n-Documented program\n-Employee training and records\n-Emergency equipment/signs\n-Spill Equipment","Plus:\n-Mature program\n-Safety committee  \n-All records complete and up to date.  \n-All equipment/signs well maintained",null,null,null,3]
[null,"HS06","Does the supplier have a program to provide & require the use of personal protective equipment when safety hazards & workplace exposures can't be controlled by other means?",null,null,"Not in place:\n-Proper personal protection equipment","In Place:\nDocumented program & personal protection equipment provided","Plus:\n-Mature program\n-Complete and up to date records  \n",null,null,null,3]
[]
[null,"Health and Safety Section Average Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L82:L87)),AVERAGE(L82:L87),\"\")","v":3}]
[null,"Health and Safety Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L89),(IF(MIN(L82:L87)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"C. Environment",null,null,null,0,3,4,"Notes "]
[null,"EN01","Supplier manufactures or provides products (to any customer) that contain substances in excess of the amount listed on John Deere’s Restricted Materials List or other substances restricted by applicable laws? ",null,null,"If YES, notify WWSM, Compliance Manager at 90smcompliance@johndeere.com ",null,null,null,null,null,"No"]
[null,"EN02","Supplier has procedures to verify (by inspecting and testing) that no products are supplied to John Deere containing substances in excess of the amounts set forth on John Deere’s Restricted Materials List and/or other substances restricted by applicable laws?",null,null,"Supplier has no procedures or methods to inspect, test or assure these materials do not get into John Deere product in excess of acceptable amounts.","Supplier has procedures and methods to verify that no products are supplied containing substances in excess of acceptable amounts.","Supplier is not using or supplying any products containing restricted materials to any customer as per John Deere's restricted materials list.",null,null,null,3]
[null,"EN03","Is the supplier currently, or at any time during the past 1-3 years, subject to any enforcement action by any governmental authority for non-compliance with environmental requirements at any facility at which products supplied to John Deere are manufactured?",null,null,"Current significant un-resolved violations.  Supplier has not taken any measures to address or correct issues","Some violations in last 1-3 years with documented resolution"," No violations in last 5 years",null,null,null,3]
[null,"EN04","Has the supplier obtained and maintained all environmental permits and registrations that apply to their facilities, operations, and products, including reporting obligations in accordance with applicable laws and regulations?",null,null," Not obtained permits or registrations on file and some special processes on site such as painting or plating","Supplier states that permits or registrations are in place or in application process, but cannot verify or provide evidence.  ","Documented permits and registrations verified.  Supplier provides verification.",null,null,null,3]
[null,"EN05","Are wastes that are stored, treated, or disposed of on-site managed in properly designed facilities that will prevent future environmental impacts?",null,null,"Significant disorder where chemicals and wastes are stored.  Waste stockpiling. Leaking drums near drains. Inability to identify waste.","Some containment. Chemicals/wastes stored to prevent a release to storm or floor drains.  No evidence of spills or staining inside or outside of facility.  Some labeling.","Containment for all waste and chemical storage areas.  Drums or wastes are properly labeled and identified. Supplier has safeguards to prevent releases to storm or floor drains.",null,null,null,3]
[]
[null,"Environment Section Average Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L94:L97)),AVERAGE(L94:L97),\"\")","v":3}]
[null,"Environment Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L99),(IF(MIN(L94:L97)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"D. Ethics ",null,null,null,0,3,4,"Notes"]
[null,"ET01","Does the supplier manufacture or provide products containing Conflict Minerals (CM) as defined by applicable laws?  If yes, has the supplier submitted a Conflict Mineral's declaration to John Deere for the current or previous calendar year?\n\n",null,null,"Score as \"Yes\" if supplier does not provide products containing CM's or has submitted a CM declaration.  \nScore as \"No\" if supplier provides products containing CM's and has NOT submitted a CM's declaration and notify WWSM, Compliance Manager at: 90smcompliance@johndeere.com \n",null,null,null,null,null,"Yes"]
[null,"ET02","Does the supplier have a program to ensure compliance with applicable laws concerning proprietary, confidential & personal information?",null,null,"\"No\" program or procedure","\"Yes\" without documentation","\"yes\" with documentation",null,null,null,3]
[null,"ET03","If the product or manufacturing process is covered by one or more third party's patent or copyright known to the supplier, is the supplier licensed under the patents and copyrights that allow it to lawfully manufacture the product or utilize the manufacturing process?",null,null,"Patented or copyrighted product design or manufacturing process is use without the proper permissions.","Third Party owned","Deere or Supplier Owned",null,null,null,3]
[null,"ET04","Does the supplier have documentation to substantiate that it is properly licensed to use the requisite Intellectual Property Rights?",null,null,"No",null,"Yes, plus documentation",null,null,null,3]
[null,"ET05","Are the licensed Intellectual Property rights applicable in the country where the supplier will produce the product or utilize the manufacturing process and is the duration of the license sufficient to cover the term of the proposed supply agreement?",null,null,"Rights not applicable in the county where the product is produced or the duration of the rights is less than 1 year.","Rights applicable in the county where the product is produced. The duration of the rights is 5-10 years.","Yes, plus documentation and rights are longer than 10 years",null,null,null,3]
[null,"ET06","Is the supplier aware or on notice of any third party Intellectual Property rights which could interfere with the proposed supply agreement? If yes, identify the third party and the Intellectual Property rights involved.",null,null,"Possible third party interference",null,"No third party interference",null,null,null,3]
[]
[null,"Ethics Section Average Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L104:L108)),AVERAGE(L104:L108),\"\")","v":3}]
[null,"Ethics Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L110),(IF(MIN(L104:L108)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"Compliance Category Average Score:",null,null,null,null,{"$f":"IF(ISNUMBER(#REF!),#REF!/#REF!,\"\")","v":""},null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L78,L89,L99,L110)),AVERAGE(L78,L89,L99,L110),\"\")","v":3}]
[null,"Compliance Category compliance:    (Complies = All above sections comply)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L113),(IF(MIN(L74,L75,L76,L82,L83,L84,L85,L86,L87,L94,L95,L96,L97,L104,L105,L106,L107,L108)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[]
[null,"GENERAL SUPPLIER QUALITY 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\")"]
[]
[null,"**  A supplier must have a score of 2 or greater on each of the questions to be acceptable."]
[null,"**  Score each question using a 0 to 4 point scale, where 4 is the best possible score."]
[]
["Quality"]
[null,"2. Quality Planning"]
[null,"E.   Management Review"]
[null,null,"SQM Ref."]
[null,"#",null,"Interview Questions",null,null,"Notes and supporting evidence",null,null,null,null,"Score"]
[null,"MR01",5.6,"Does the supplier's Management, with executive responsibility, review all quality system elements at defined intervals to ensure its continuing suitability and effectiveness?",null,null,null,null,null,null,null,3]
[null,"MR02",5.6,"Are overall performance metrics posted and are improvement goals established? ( e.g: quality PPM, on time delivery of service or product, productivity)",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L133:L134)),AVERAGE(L133:L134),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L136),(IF(MIN(L133:L134)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"F.   Quality Planning",null,null,null,null,"Notes and supporting evidence",null,null,null,null,"Score"]
[null,"QP01",8.1999999999999993,"Are mistake proofing techniques, including facilities, equipment, tooling, and problem resolution, used to ensure quality of service or product?",null,null,null,null,null,null,null,3]
[null,"QP02",7.5,"Are control plans created to assure parts or service are delivered according to requirements?",null,null,null,null,null,null,null,3]
[null,"QP03",7.5,"Are control plans reviewed and updated as appropriate when any of the following occurs:",null,null,null,null,null,null,null,3]
[null,null,null,"-Product or process changes?"]
[null,null,null,"-Processes are found to be unstable or non-capable?"]
[null,null,null,"-Inspection method, frequency, etc., is revised?"]
[null,"QP04",7.2,"Are their internal initiated design or process changes documented, reviewed, and approved by authorized internal personnel before implementation? ",null,null,null,null,null,null,null,3]
[null,"QP05",7.2,"Supplier has a procedure to assure written customer (John Deere) approval or waiver been obtained and documented prior to a design or process change being implemented into production? ",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L140:L147)),AVERAGE(L140:L147),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L149),(IF(MIN(L140:L147)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"G.   Document Control",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"DC01",4.2,"Has supplier established a process to ensure invalid and/ or obsolete documents are promptly removed from all points of use or otherwise assured against unintended use?",null,null,null,null,null,null,null,3]
[null,"DC02",4.2,"Is there timely review, distribution, and implementation of customer provided standards and specifications and changes?  Verify revision levels of drawings or models in use at the supplier where applicable?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L153:L154)),AVERAGE(L153:L154),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L156),(IF(MIN(L153:L154)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"H.  Product Identification and Traceability",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"PT01",7.5,"Is required product identification maintained through all stages of production, assembly, and delivery?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L160:L160)),AVERAGE(L160:L160),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L162),(IF(L160<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"I.  Training",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"TR01",6.1,"Is a documented training plan established that identifies employee basic training needs?",null,null,null,null,null,null,null,3]
[null,"TR02",6.1,"Have employee's basic training needs been fulfilled for the job being performed?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L166:L167)),AVERAGE(L166:L167),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L169),(IF(MIN(L166:L167)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"J.  Statistical Techniques",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"ST01",8.1999999999999993,"Does the supplier use the appropriate quality and statistical tools required to establish, control, and verify product/service quality?  ",null,null,null,null,null,null,null,3]
[]
[null,"Average Sub-section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L173:L173)),AVERAGE(L173:L173),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L175),(IF(MIN(L173:L173)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"3.  Process Control"]
[null,"K.  Process Control",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"PC01",7.5,"Have documented process monitoring and other operator instructions been prepared for all employees?",null,null,null,null,null,null,null,3]
[null,null,null,"-Are they accessible at the workstation? "]
[null,null,null,"-Is there evidence of use?"]
[null,"PC02",7.5,"Does the supplier have a reaction plan for out-of- control conditions? (e.g containment and 100 percent inspection, specific corrective action and timing, responsibility assignment, documented customer approval)",null,null,null,null,null,null,null,3]
[null,"PC03",7.5,"Do operators clearly understand their responsibilities when loss of process control or out of specification conditions exist?",null,null,null,null,null,null,null,3]
[null,"PC04",6.3,"Is production equipment and working environment suitable for manufacturing of specified characteristics?",null,null,null,null,null,null,null,3]
[null,null,null,"-Are production machines and equipment appropriate for the product being produced?"]
[null,null,null,"-Is there documented evidence of process capability?"]
[null,null,null,"-Are production machines and equipment clean and adequately maintained?"]
[null,null,null,"-Is there evidence of a preventive maintenance program?"]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L180:L189)),AVERAGE(L180:L189),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L191),(IF(MIN(L180:L189)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"4. Inspection and Testing"]
[null,"L.  Inspection and Testing",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"IT01",8.1999999999999993,"Does the supplier perform incoming inspection as required by the Control Plan and / or the documented procedures?",null,null,null,null,null,null,null,3]
[null,"IT02",8.1999999999999993,"Does the supplier inspect and test in-process product as required by the Control Plan and / or the documented procedures?",null,null,null,null,null,null,null,3]
[null,"IT03",8.1999999999999993,"Does the supplier carry out final inspection and testing in accordance with the Control Plan and/or documented procedures?",null,null,null,null,null,null,null,3]
[null,"IT04",8.1999999999999993,"Does the supplier assure that no product is released until all activities specified in the documented procedures have been satisfactorily completed and authorized?  Are the associated records maintained and available?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L196:L199)),AVERAGE(L196:L199),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L201),(IF(MIN(L196:L199)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"M.  Inspection, Measuring & Test Equipment",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"TE01",7.6,"Has the supplier identified all inspection measuring and test equipment that can affect product or service quality ?\nAre appropriate measurement systems used for required characteristics (e.g roundness, lobbing, surface finish, software development validation, etc.)?",null,null,null,null,null,null,null,3]
[null,"TE02",7.6,"Is each piece of inspection equipment calibrated:",null,null,null,null,null,null,null,3]
[null,null,null,"-At prescribed intervals?"]
[null,null,null,"-On certified master equipment,traceable to standards?"]
[null,null,null,"-In a controlled environment?"]
[null,"TE03",7.6,"Does the supplier maintain calibration records for inspection measuring and test equipment?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L205:L210)),AVERAGE(L205:L210),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L212),(IF(MIN(L205:L210)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"N.  Quality Audits",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"QA01","5.6\n8.2","Does the supplier have a documented program to perform internal audits of the quality system?",null,null,null,null,null,null,null,3]
[null,"QA02",7.4,"Is there a documented procedure for auditing of the supplier's supply chain quality systems and capabilities?       \n   -Is there evidence that it is being followed?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L216:L217)),AVERAGE(L216:L217),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L219),(IF(MIN(L216:L217)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"5. Non-Conformance and Corrective Action"]
[null,"O.  Control of Nonconforming Product",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"NP01",8.3000000000000007,"Is nonconforming or suspect material  properly identified?\n  -Is it quarantined?\n  -Is  there a defined procedure for review and disposition?",null,null,null,null,null,null,null,3]
[null,"NP02","8.4\n8.5","Does the supplier quantify and analyze nonconforming product, establish a prioritized reduction plan, and track progress to the plan?",null,null,null,null,null,null,null,3]
[null,"NP03",7.2,"Does the supplier obtain customer authorization prior to shipment/delivery, whenever the product or process is different from the current approved process?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L224:L226)),AVERAGE(L224:L226),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L228),(IF(MIN(L224:L226)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"P.  Corrective and Preventive Action",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"CA01",8.5,"Does the supplier use a disciplined problem solving method to address internal and external non-conformances?",null,null,null,null,null,null,null,3]
[null,"CA02",8.5,"Do procedures for corrective action include effective handling of customer complaints and reports of non-conformances?  Do these procedures:",null,null,null,null,null,null,null,3]
[null,null,null,"-Verify corrective action from past Corrective Action Requests?"]
[null,null,null,"-Consider implementation of corrective action on similar products / processes?"]
[null,null,null,"-Consider impact of corrective action on other products / processes?"]
[null,"CA03",8.5,"Do procedures for corrective action include mistake proofing or other preventive action to avoid root cause re-occurrence and verification to ensure effectiveness?",null,null,null,null,null,null,null,3]
[null,"CA04",8.5,"Are returned parts analyzed and are records of this analysis kept and made available upon request?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L232:L238)),AVERAGE(L232:L238),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L240),(IF(MIN(L232:L238)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[null,"Q.  Storage, Packaging & Preservation",null,null,null,null,null,"Notes and supporting evidence",null,null,null,"Score"]
[null,"SP01",7.5,"Have methods to prevent damage or deterioration been provided for the internal handling of production material and are they being followed?",null,null,null,null,null,null,null,3]
[null,"SP02",7.5,"Have methods to prevent damage or deterioration been provided for the shipment/delivery of production and service material and are they being followed?",null,null,null,null,null,null,null,3]
[]
[null,"Average Section Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L244:L245)),AVERAGE(L244:L245),\"\")","v":3}]
[null,"Section Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L247),(IF(MIN(L244:L245)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[]
[null,"Quality Category Average Score:",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AVERAGE(L136,L149,L156,L162,L169,L175,L191,L201,L212,L219,L228,L240,L247)),AVERAGE(L136,L149,L156,L162,L169,L175,L191,L201,L212,L219,L228,L240,L247),\"\")","v":3}]
[null,"Quality Category Compliance:    (Complies = No questions scored less than 2)",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(L251),(IF(MIN(L133,L134,L140,L141,L142,L146,L147,L153,L154,L160,L166,L167,L173,L180,L183,L184,L185,L196,L197,L198,L199,L205,L206,L210,L216,L217,L224,L225,L226,L232,L233,L237,L238,L244,L245)<2,\"DOES NOT COMPLY\",\"COMPLIES\")), \"NOT SCORED\")","v":"COMPLIES"}]
[]
[]
[]
[]
[]
[null,null,"Strengths"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question #",null,"Major Non-conformances",null,null,null,null,null,null,null,"NCCA CAR #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question #",null,"Minor Non-conformances",null,null,null,null,null,null,null,"NCCA CAR #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Opportunities for Improvement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Restrictions and Conclusions"]

{"sheet":"Instructions","index":1,"n_rows":117,"n_cols":3,"rows_kept":117,"cut":false,"hidden":false,"merged":[[78,1,78,2],[83,1,83,2],[0,0,0,2],[2,0,2,2],[4,1,4,2],[14,1,14,2],[16,1,16,2],[35,1,35,2],[65,1,65,2],[69,1,69,2]]}
["JOHN DEERE JDS-G223i (Indirect Material & Services) 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"]
["BACK"]
[null,"This JDS-G223i Supplier Quality System Audit is designed to get information from an existing or a potential supplier to evaluate their quality and code of conduct processes to decide if they are capable to be a supplier for John Deere.  It is designed to be completed during an on-site facility visit.  It is also intended to be a way 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"]
["BACK"]
[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-G223i 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-G223i 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"]
["BACK"]
[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 products or services provided to Deere. This will increase the probability that Supplier improvement activities resulting from the audit are focused in areas of greatest benefit to the Enterprise. "]
[null,"B.","For reaudits, 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"]
["BACK"]
[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.  This information will be made available to Enterprise personnel in the Supplier Evaluation Tracking (SET) respository on JDSN."]
[null,"C.","Nonconformances 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"]
["BACK"]
[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 delivery of a nonconforming product or service.  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 Nonconformances\" section of the audit as well as in the audit report.  Nonconformances should be documented in the Nonconforming Corrective Action (NCCA) System."]
[]
[null,"Minor Nonconformance "]
[null,"A JDS-G223i 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 delivery of nonconforming product or services."]
[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.  Nonconformances 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"]
["BACK"]
[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 queston.  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 56 scaled questions (3 questions are yes/no) with a maximum score of (53)*(4) = 212 points.  When you divide the total score by 212, you have a result in percent.  For example, if the total audit score was 159 points (all questions score  = 3), the  calculated average score expressed in percent is (159)/(212) = 75%."]
[null,"F.","In order to pass this audit, the supplier must meet 2 criterias.  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 of 65% or greater)."]
[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,"Code of Conduct 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 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"]
["BACK"]
[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"]
["BACK"]
[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 nonconformances.  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 nonconformances"]
[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 materials or services 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)"]
["BACK"]
[null,"A.","After completing the audit, please send the file to your quality system coordinator to file in Supplier Evaluation Tracking system located in JD Supply Network. The list of John Deere employees that can file your audit are listed and can be viewed at the following link:  http://www.90.deere.com/suppmgmt/business_processes/strategic_sourcing_process/tools/supplier_evaluation_tracking/supplier_evaluation_tracking_index.htm and selecting Authorized Users for Data Uploading."]
[null,"B.","After completing the survey, please upload the file to the Supplier Evaluation Tracking system located in JD Supply Network.  If you do not have access to the SET system, please contact your manager to gain access."]
[null,"C.","All completed surveys and assessments can be viewed by John Deere employees in Supplier Evaluation Tracking at this link:  http://www.90.deere.com/suppmgmt/business_processes/strategic_sourcing_process/tools/supplier_evaluation_tracking/supplier_evaluation_tracking_index.htm and selecting Web Application."]
[]
[null,null,"Supplier Evaluation Tracking (SET)"]
[null,null,"NCCA System"]

{"sheet":"Change History","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[1,0,1,2]]}
["JOHN DEERE JDS-G223i (Indirect Material & Services) SUPPLIER QUALITY SYSTEM QUESTIONNAIRE"]
[]
["CHANGE HISTORY"]
["Date","Who Made Changes","Reason for Change"]
["2013-07-24","Clementine Uwineza, Wendell Hunt, Andrew Freitag","First Version"]