{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instruction","Supplier Key Information","Audit Form","Corrective Action","Scoring Summary "],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":2,"defined_names":32,"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":"Instruction","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,5,9,6],[9,7,9,8],[12,0,12,1],[11,0,11,1],[0,0,3,8],[15,0,15,1],[15,3,15,4],[15,5,15,6],[15,7,15,8],[12,5,12,6],[11,3,11,4],[12,3,12,4],[13,3,13,4],[13,0,13,1],[14,3,14,4],[7,0,7,8],[9,0,9,1],[5,0,5,1],[5,2,5,8],[9,3,9,4],[13,5,13,6],[14,5,14,6],[14,0,14,1],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[11,5,11,6]]}
["Supplier On-Site Assessment Instructions\nJF-PU-05, Revision 14.12.1 (December 3, 2014)"]
[]
[null,null,null,null,null,null,null,null,null,null,"0- No Evidence"]
[]
[]
["Instructions",null,"1. Send this form to selected supplier. INSTRUCTIONS FOR SUPPLIER:  and ask to complete the SUPPLIER KEY INFORMATION tab  and the self assessment and record the findings in the \"Supplier\" column on the AUDIT FORM tab. All sections must be filled-out, regardless of applicability. Sections and questions that do not apply will be identified with the \"N/A\" label.\n\n2. Upon return of the completed assessment, the Purchasing Manager and the Quality Manager review the data, request any clarifications, and then, as applicable, prepares for the on-site evaluation.\n\n3. The Purchasing Manager assembles an appropriate audit team, ideally consisting of representatives from, as required, Quality Assurance, Design Engineering, Operations, and Purchasing, and schedules the on-site assessment.\n\n4. The team evaluates the supplier by asking the questions on the tab Audit Form and scores each question based on the evidence observed. Scoring is recorded in the \"Jackson\" column of the audit sheet in accordance with the Audit Scoring Definitions shown below.\n\n5. At the completion of the assessment, scores are compiled for both the individual sections of the audit and an overall result. These results are shown in the tab Scoring Summary.\n\n6. A corrective action sheet is included in the audit materials to address any deficiencies identified in the audit. The sheet can also be used at the team's discrection to catalogue any other further reqired actions related to sourcing decisions. The Quality Manager shall assigned Non-Conformance Reports and NCR numbers to each corrective action and will work with the Purchasing Manager to achieve resolution.\n\n7. Once the audit process is finished and this document is complete, a pdf copy will be forwarded to the supplier, the Jackson Quality Manager and the Jackson Purchasing Manager. The master pdf copy will be maintained on the Jackson Purchasing Server in the SUPPLIER ASSESSMENT folder. File name should be set in the following format: Supplier Name - \"Audit\" - Completed Date.pdf. Records shall be maintained in accordance with JP-QA-02, Control of Records Procedure."]
[]
["Audit Scoring Definitions "]
[]
["Score",null,"Segmentation","Documentation",null,"Implementation",null,"Results"]
[]
[3,null,"Strategic","Full documentation with  no missing requirements",null,"Full execution. No non-conformances",null,"Evidence to support full understanding and implementation"]
[2,null,"Preferred","Substantial documentation with some missing requirements",null,"Execution evident with limited non-conformances",null,"Evidence supports understanding of requirement with partial execution"]
[1,null,"Maintain","Limited documentation",null,"Limited execution with major non-conformances",null,"Limited evidence of requirement"]
[0,null,"Unacceptable","No documentation",null,"No evidence of implementation",null,"Element required but no evidence of execution or understanding"]
["N/A",null,"N/A","Not Required",null,"Not Required",null,"Element not required"]

{"sheet":"Supplier Key Information","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[37,0,37,8],[0,0,3,8],[5,0,5,2],[5,3,5,8],[6,0,6,2],[6,3,6,8],[32,0,32,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,2],[27,5,27,7],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[31,0,31,2],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,8],[10,2,10,3],[11,2,11,3],[12,2,12,3],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[11,0,11,1],[12,0,12,1],[9,0,9,1],[10,0,10,1],[9,2,9,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[15,0,15,3],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[33,0,33,3],[8,0,8,8],[34,0,34,1],[34,2,34,3],[35,0,35,1],[35,2,35,3],[21,5,21,7],[23,0,23,2],[23,5,23,6],[23,7,23,8],[25,0,25,3],[26,0,26,1],[26,2,26,3],[25,5,25,8],[26,5,26,7],[15,5,15,8],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,0,21,1],[16,2,16,3],[17,2,17,3],[42,6,42,8],[43,6,43,8],[33,5,33,8],[34,5,34,8],[44,0,47,8],[49,0,50,3],[49,4,49,5],[49,6,49,8],[42,0,42,2],[43,0,43,2],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5],[38,6,38,8],[38,3,38,5],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[39,6,39,8],[40,6,40,8],[41,6,41,8],[58,0,58,8],[59,0,59,8],[60,0,86,8],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1]]}
["Supplier On-Site Assessment\n Supplier Key Information\nJF-PU-05, Revision 14.12.1 (December 3, 2014)"]
[]
[]
[]
[]
["Company Name"]
["Company Address"]
[]
["Contacts"]
["Titles",null,"Name",null,"Phone Number",null,"E-Mail Address"]
["Sales Contact"]
["President/CEO"]
["Financial Officer"]
["Quality Manager"]
[]
["General Information",null,null,null,null,"Key Customers"]
["Date of Establishment",null,null,null,null,"Customer Name",null,null,"% Business"]
["Head Office Location"]
["Location of Incorporation"]
["# of Locations"]
["Facility Square Footage"]
["Fiscal Year Ending"]
[]
["Listed in Dun & Bradstreet?",null,null,null,null,"D&B Number?"]
[]
["Ownership",null,null,null,null,"Key Suppliers"]
["Public or Private?",null,null,null,null,"Supplier Name",null,null,"% Business"]
["If Private, Name of Owner(s)"]
[]
[]
["Minority Owned?"]
["Union Workforce?"]
["If Yes, Union Name"]
[null,null,null,null,null,"Federal Tax ID Number"]
["Contract Expiration"]
["Last Work Stoppage?"]
[]
["Manpower (Please provide the number of employees by area)"]
["Area",null,null,"Number of Employees",null,null,"Average Length of Tenure"]
["Management/Office Personnel"]
["Product Design/Engineering"]
["Manufacturing"]
["Quality"]
["Other"]
["Supplier On-Site Assessment\n Supplier Key Information\nJF-PU-05, Revision 14.12.1 (December 3, 2014)"]
[]
[]
[]
[]
["Capital Investment (in 1,000 USD)",null,null,null,"Actual",null,"Plan"]
[null,null,null,null,"[Enter Year]","[Enter Year]","[Enter Year]","[Enter Year]","[Enter Year]"]
["Business & Facilities"]
["Machinery & Equipment"]
["Tooling"]
["Office Furniture"]
["Other"]
["Total Investment"]
[]
["Continuous Improvement"]
["What major improvements have you recently implemented and what are your next steps?"]

{"sheet":"Audit Form","index":2,"n_rows":176,"n_cols":11,"rows_kept":176,"cut":false,"hidden":false,"merged":[[82,1,82,4],[82,7,82,8],[87,1,87,4],[87,7,87,8],[92,0,92,4],[90,1,90,4],[90,7,90,8],[92,7,92,8],[171,1,171,4],[171,7,171,8],[84,1,84,4],[84,7,84,8],[85,1,85,4],[85,7,85,8],[88,1,88,4],[88,7,88,8],[86,1,86,4],[86,7,86,8],[120,1,120,4],[119,1,119,4],[112,1,112,4],[112,7,112,8],[118,1,118,4],[118,7,118,8],[94,1,94,4],[94,7,94,8],[83,1,83,4],[83,7,83,8],[89,1,89,4],[89,7,89,8],[99,1,99,4],[131,7,131,8],[134,7,134,8],[121,1,121,4],[126,1,126,4],[127,1,127,4],[132,1,132,4],[121,7,121,8],[126,7,126,8],[127,7,127,8],[122,7,122,8],[119,7,119,8],[101,0,101,4],[101,7,101,8],[104,1,104,4],[102,7,102,8],[93,7,93,8],[91,1,91,4],[160,7,160,8],[161,7,161,8],[162,7,162,8],[163,7,163,8],[164,7,164,8],[165,7,165,8],[166,7,166,8],[173,7,173,8],[172,7,172,8],[54,0,54,4],[52,1,52,4],[52,7,52,8],[64,1,64,4],[64,7,64,8],[65,1,65,4],[105,7,105,8],[106,7,106,8],[167,7,167,8],[153,1,153,4],[77,7,77,8],[78,1,78,4],[79,1,79,4],[81,7,81,8],[148,7,148,8],[154,7,154,8],[155,7,155,8],[159,7,159,8],[65,7,65,8],[76,7,76,8],[107,7,107,8],[157,7,157,8],[158,7,158,8],[79,7,79,8],[75,1,75,4],[75,7,75,8],[67,1,67,4],[67,7,67,8],[66,7,66,8],[70,1,70,4],[70,7,70,8],[71,1,71,4],[66,1,66,4],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[139,7,139,8],[142,7,142,8],[145,7,145,8],[141,7,141,8],[144,7,144,8],[73,7,73,8],[74,7,74,8],[80,7,80,8],[78,7,78,8],[100,7,100,8],[99,7,99,8],[91,7,91,8],[5,0,5,8],[8,0,8,1],[6,7,6,8],[7,7,7,8],[9,7,9,8],[13,7,13,8],[14,7,14,8],[21,1,21,4],[20,7,20,8],[21,7,21,8],[19,0,19,4],[9,2,9,3],[15,7,15,8],[16,7,16,8],[15,2,15,3],[6,0,6,1],[7,0,7,1],[9,0,9,1],[16,2,16,3],[6,2,6,3],[7,2,7,3],[13,2,13,3],[14,2,14,3],[22,1,22,4],[23,7,23,8],[12,0,12,8],[13,0,13,1],[14,0,14,1],[47,1,47,4],[37,0,37,4],[42,1,42,4],[40,1,40,4],[41,1,41,4],[39,7,39,8],[23,1,23,4],[20,1,20,4],[19,7,19,8],[22,7,22,8],[42,7,42,8],[44,1,44,4],[44,7,44,8],[46,0,46,4],[46,7,46,8],[47,7,47,8],[36,7,36,8],[43,7,43,8],[40,7,40,8],[41,7,41,8],[35,1,35,4],[36,0,36,4],[53,1,53,4],[50,1,50,4],[100,1,100,4],[72,1,72,4],[77,1,77,4],[68,1,68,4],[69,1,69,4],[55,0,55,4],[59,1,59,4],[96,1,96,4],[76,1,76,4],[81,1,81,4],[80,1,80,4],[97,1,97,4],[93,0,93,4],[71,0,91,0],[56,0,69,0],[48,1,48,4],[51,1,51,4],[49,1,49,4],[73,1,73,4],[74,1,74,4],[28,7,28,8],[30,1,30,4],[30,7,30,8],[24,0,24,4],[27,1,27,4],[25,7,25,8],[27,7,27,8],[45,7,45,8],[32,1,32,4],[29,1,29,4],[29,7,29,8],[34,7,34,8],[35,7,35,8],[31,1,31,4],[33,7,33,8],[31,7,31,8],[45,0,45,4],[32,7,32,8],[37,7,37,8],[38,1,38,4],[38,7,38,8],[26,1,26,4],[25,0,25,4],[34,1,34,4],[175,0,175,4],[133,1,133,4],[172,1,172,4],[142,0,142,4],[151,0,151,4],[148,1,148,4],[144,1,144,4],[161,1,161,4],[162,1,162,4],[163,1,163,4],[164,1,164,4],[165,1,165,4],[140,1,140,4],[150,0,150,4],[154,1,154,4],[155,1,155,4],[135,7,135,8],[157,1,157,4],[158,1,158,4],[159,1,159,4],[115,1,115,4],[168,1,168,4],[169,1,169,4],[39,1,39,4],[58,1,58,4],[160,1,160,4],[43,1,43,4],[56,1,56,4],[57,1,57,4],[105,1,105,4],[106,1,106,4],[102,0,102,4],[103,1,103,4],[107,1,107,4],[48,7,48,8],[50,7,50,8],[53,7,53,8],[49,7,49,8],[51,7,51,8],[152,7,152,8],[175,7,175,8],[54,7,54,8],[110,7,110,8],[95,1,95,4],[141,0,141,4],[130,1,130,4],[131,1,131,4],[137,7,137,8],[125,1,125,4],[128,1,128,4],[138,7,138,8],[108,1,108,4],[109,1,109,4],[117,0,117,4],[122,1,122,4],[146,1,146,4],[136,0,136,4],[145,1,145,4],[139,1,139,4],[136,7,136,8],[110,0,110,4],[116,0,116,4],[123,0,123,4],[135,0,135,4],[140,7,140,8],[111,7,111,8],[113,7,113,8],[114,7,114,8],[137,1,137,4],[138,1,138,4],[124,0,124,4],[63,7,63,8],[130,7,130,8],[98,1,98,4],[96,7,96,8],[97,7,97,8],[98,7,98,8],[71,7,71,8],[95,7,95,8],[125,7,125,8],[72,7,72,8],[133,7,133,8],[63,1,63,4],[132,7,132,8],[111,0,111,4],[113,1,113,4],[114,1,114,4],[134,1,134,4],[171,0,174,0],[156,1,156,4],[156,7,156,8],[143,1,143,4],[143,7,143,8],[174,1,174,4],[166,1,166,4],[167,1,167,4],[152,1,152,4],[173,1,173,4],[160,0,169,0],[149,1,149,4],[147,1,147,4],[170,1,170,4],[153,7,153,8],[146,7,146,8],[147,7,147,8],[150,7,150,8],[151,7,151,8],[149,7,149,8],[168,7,168,8],[169,7,169,8],[170,7,170,8],[174,7,174,8],[2,3,2,6],[129,7,129,8],[68,7,68,8],[69,7,69,8],[124,7,124,8],[115,7,115,8],[108,7,108,8],[120,7,120,8],[117,7,117,8],[103,7,103,8],[104,7,104,8],[128,7,128,8],[116,7,116,8],[60,1,60,4],[61,1,61,4],[61,7,61,8],[62,1,62,4],[62,7,62,8],[129,1,129,4],[109,7,109,8],[123,7,123,8],[24,7,24,8],[26,7,26,8],[28,1,28,4]]}
[]
[null,null,null,null,"Supplier On-Site Assessment"]
[null,null,null,"JF-PU-05, Revision 14.12.1 (December 3, 2014)",null,null,null,"Supplier Score",{"$f":"SUM(F21:F24,F27:F36,F39:F45,F48:F54,F57,F62,F71,F79,F95:F101,F104:F110,F113:F116,F119:F123,F126:F135,F138:F141,F144:F150,F153:F160,F171)/(COUNT(F21:F24,F27:F36,F39:F45,F48:F54,F57,F62,F71,F79,F95:F101,F104:F110,F113:F116,F119:F123,F126:F135,F138:F141,F144:F150,F153:F160,F171)*3)","v":{"$error":"#DIV/0!"}},null,"0- No Evidence"]
[null,null,null,null,null,null,null,"Jackson Score",{"$f":"SUM(G21:G24,G27:G36,G39:G45,G48:G54,G57,G62,G71,G79,G95:G101,G104:G110,G113:G116,G119:G123,G126:G135,G138:G141,G144:G150,G153:G160,G171)/(COUNT(G21:G24,G27:G36,G39:G45,G48:G54,G57,G62,G71,G79,G95:G101,G104:G110,G113:G116,G119:G123,G126:G135,G138:G141,G144:G150,G153:G160,G171)*3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"1- Limited Evidence"]
["Supplier Information",null,null,null,null,null,null,null,null,null,"2- Evidence and Documentation"]
["Supplier Name:",null,null,null,null,null,"Vendor ID #:",null,null,null,"3- Item Executed with Evidence"]
["Plant Location:",null,null,null,null,null,"Phone #:"]
[]
["Supplier Contact:",null,null,null,null,null,"Supplier E-Mail:"]
[]
[]
["Audit Information",null,null,null,null,null,null,null,null,null,"N/A"]
["Lead Name:",null,null,null,null,null,"Auditor Name:",null,null,null,0]
["Lead E-Mail:",null,null,null,null,null,"Auditor E-Mail:",null,null,null,1]
["Lead Phone:",null,null,null,null,null,"Auditor Phone:",null,null,null,2]
["Audit Date:",null,null,null,null,null,"Cooper Division:",null,null,null,3]
[]
[]
["1. Customer Satisfaction",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["1.1","There is a process in place for determining customer satisfaction that is updated at regular intervals."]
["1.2","Metrics monitoring customer satisfaction are understood and tracked (examples include customer returns, warranty, on-time delivery)."]
["1.3","There are projects and programs in place to improve customer satisfaction, with corrective actions addressed, and a closed-loop review system progress"]
["1.4","Customer dedicated service group with multifunctional team has been established for key accounts"]
["Customer Satisfaction Section Score:",null,null,null,null,{"$f":"SUM(F21:F24)/(3*COUNT(F21:F24))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G21:G24)/(3*COUNT(G21:G24))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"COUNT(F21:F24)","v":0}]
["2. Quality System",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["2.1","Do you have a quality system registered to a recognized standard?"]
["2.2","There are regular, periodic  Management Reviews to verify the effectiveness of the quality system."]
["2.3","Each department has  goals that are defined and measured and focus on the use quality policy, objectives, audit results, analysis of data, corrective / preventive actions"]
["2.4","Management regularly reviews  the status of the Preventive Maintenence completion to plan.  Management reviews corrective action plans to ensure any backlog (past due) maintenance has a plan to become current to the PM schedule."]
["2.5","Internal audit frequency is modified based on non-conformance trends."]
["2.6","Internal audits are available to verify that the quality system is being followed."]
["2.7","A formal business/manufacturing system is in place ( Capacity Planning, Shop Floor Control, ERP, etc.)"]
["2.8","Proactive notification of issues which could affect delivery or quality are documented and performed"]
["2.9","Does the Supplier have a process for final product identification, including bar code, if required."]
["2.10","Does the supplier obtain customer waiver (concession/deviation) prior to further processing when the product/process is different from what is approved? And are shipping containers properly identified when this occurs?"]
["Quality System Section Score:",null,null,null,null,{"$f":"SUM(F27:F36)/(3*COUNT(F27:F36))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G27:G36)/(3*COUNT(G27:G36))","v":{"$error":"#DIV/0!"}}]
["3. Business System ",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["3.1","A Customer-focused strategy has been developed and deployed to ensure business portfolio diversity"]
["3.2","Is there evidence and use of tools like  Electronic Data Interface (EDI), Request For Quote (RFQ), Advanced Planning and Scheduling (APS) ?"]
["3.3","Have contingency plans been prepared to satisfy customer requirements in the event of an emergency such as utility interruptions, labor shortages, key equipment failures, and field returns?"]
["3.4","Is there a process to address product liability / recall issues?"]
["3.5"," Does the supplier have a long-term plan for sustainability, including a system in place to identify key business and product risks and opportunities?"]
["3.6","Are the Purchase Orders reviewed for commitment to qty, price, delivery date, delivery method, and any additional special requirements or instructions?  If any differences arises the differences are resolved prior to acceptance of the order."]
["3.7","Personnel performing specific tasks shall be qualified on the basis of appropriate education, training, and/or experience."]
["Business System Section Score:",null,null,null,null,{"$f":"SUM(F39:F45)/(3*COUNT(F39:F45))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G39:G45)/(3*COUNT(G39:G45))","v":{"$error":"#DIV/0!"}}]
["4. EHS and Risk Management",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["4.1","An effective process for EHS is formally defined, well documented and understood with systematic root cause investigation and tracked corrective actions for all EHS defects "]
["4.2","A well documented and understood effective process is in place, that requires formal risk assessment upon change or initial set-up of equipment. "]
["4.3","Knowledge of each waste stream, final location, regulatory permit states of the disposal site, and quantity involved."]
["4.4","Does the company comply with OSHA or other applicable safety and health regulations, specifically in the use of Personal Protection Equipment?"]
["4.5","Procedures in place for hazardous substance control"]
["4.6","Emergency Action and Disaster Recovery Plans established and in place"]
["4.7","All governing requirements are effectively in place (i.e. RoHS, UL/ETL, NSF, Conflict Materials, WEEE) and all materials are approved under applicable requirements."]
["EHS and Risk Management Section Score:",null,null,null,null,{"$f":"SUM(F48:F54)/(3*COUNT(F48:F54))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G48:G54)/(3*COUNT(G48:G54))","v":{"$error":"#DIV/0!"}}]
["5. New Product Development",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["New Product Development Questions\nDESIGN RESPONSIBLE SUPPLIERS","A formalized New Product Introduction process has been established for new product development projects:\n"]
[null,"- Process identifies key milestones and tollgates   "]
[null,"- Includes evidence of training on the process"]
[null,"- Documented inputs/outputs for each critical phase"]
[null,"-Process shows evidence of Advanced Product Quality Planning techniques (APQP)"]
[null,"There is a process in place to ensure key elements of the Product Design and Development are performed:"]
[null,"- Engineering drawings & spec.  "]
[null,"- Design for Manufacturability and Assembly  "]
[null,"- DFMEA"]
[null,"-Development of Prototypes"]
[null,"- Design review and verification  "]
[null,"- Material spec.  "]
[null,"- Drawing & spec changes  "]
[null,"- Evidence of design validation testing and confirmation"]
[null,"Process in place to ensure key elements of the process design, development and validation  are performed: "]
["New Product related questions","- Product / Process quality review"]
[null,"- Floor Plan Layout "]
[null,"- Packaging standards and spec "]
[null,"- Preventive Maintenance Planning"]
[null,"- Process Capability Study "]
[null,"- Testing and Measurement"]
[null,"- Production validation testing  "]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
[null,null,null,null,null,"N/A","N/A"]
["New Product Development Section Score:",null,null,null,null,{"$f":"SUM(F57,F62,F71,F79)/(3*COUNT(F57,F62,F71,F79))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G57,G62,G71,G79)/(3*COUNT(G57,G62,G71,G79))","v":{"$error":"#DIV/0!"}}]
["6. Purchasing and Sub-Supplier Management",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["6.1","Purchase Order's are used to communicate product requirements to sub-suppliers to ensure the requirements are understood and can be met. Differences are resolved prior to acceptance of the order."]
["6.2","Quality requirements are communicated to the sub-suppliers"]
["6.3","Product  and capacity requirements are understood throughout the facility and supply chain"]
["6.4","Sub-supplier performance is evaluated on a regular basis"]
["6.5","A vendor approval process is employed."]
["6.6","Sub-suppliers are required to submit first articles samples prior to acceptance."]
["6.7","Material certification is employed."]
["Purchasing and Sub-Supplier Management Section Score:",null,null,null,null,{"$f":"SUM(F95:F101)/(3*COUNT(F95:F101))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G95:G101)/(3*COUNT(G95:G101))","v":{"$error":"#DIV/0!"}}]
["7. Production Control and Planning",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["7.1","Is Statistical Process Control being used?"]
["7.2","Utilization of  product control plans with inspection requirements and identification of key product/process characteristics"]
["7.3","Process set up verification is used and documented"]
["7.4","The supplier has and maintains a system for traceability on individual product or batches as\nrequired."]
["7.5","Inspections based on appropriate sampling plans and are sufficient to detect product nonconformance. Do the inspection items on the inspection plan meet Customer requirement?"]
["7.6","An Incoming Inspection process is in place."]
["7.7","Is there evidence of in-process checks, including  final inspection, to validate the manufacturing process and the packaging requirements? "]
["Production Control and Planning Section Score:",null,null,null,null,{"$f":"SUM(F104:F110)/(3*COUNT(F104:F110))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G104:G110)/(3*COUNT(G104:G110))","v":{"$error":"#DIV/0!"}}]
["8. Change Management",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["8.1","An effective change control process is formally defined, well documented and understood.   Strict advance customer notification process is followed, prior to executing the change."]
["8.2","There is a drawing change control system that also provides access to latest revisions for use by employees as required."]
["8.3","Does the supplier have a process to assure the timely review, distribution and implementation of all customer engineering standards/specifications and changes including a record of the date on which each change is implemented in production"]
["8.4","Is there a process to ensure parts, product, and materials comply with environment and regulatory requirements"]
["Change Management Section Score:",null,null,null,null,{"$f":"SUM(F113:F116)/(3*COUNT(F113:F116))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G113:G116)/(3*COUNT(G113:G116))","v":{"$error":"#DIV/0!"}}]
["9. Inventory Control and Housekeeping",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["9.1","Is there a warehouse management system in place that uses formal inventory control systems like First in First Out (FIFO)? "]
["9.2","Are materials kept within a controlled environment?"]
["9.3","There is a process for continuous improvement in the areas of cleanliness and organizations (i.e 5S)."]
["9.4","Finished and released product/containers are properly labeled and identified"]
["9.5","Work instructions contain steps/comments about area and/or part cleanliness where applicable."]
["Inventory Control and Housekeeping Section Score:",null,null,null,null,{"$f":"SUM(F119:F123)/(3*COUNT(F119:F123))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G119:G123)/(3*COUNT(G119:G123))","v":{"$error":"#DIV/0!"}}]
["10. Corrective Action and Control of Non-Conforming Product",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["10.1","A corrective action procedure exists and is followed for internal quality issues "]
["10.2","A corrective action procedure exists and is followed for  supplier quality problems"]
["10.3","A corrective action procedure exists and is followed for customer issues."]
["10.4","Problem solving is done in cross-functional teams, using a disciplined problem solving process (e.g. 8D or 7D)?"]
["10.5","Root Cause analysis and corrective action response are completed within agreed upon time frame."]
["10.6","Nonconforming material is identified and controlled to prevent its use or shipment to customers in receiving, in-process, outgoing and customer returns"]
["10.7","Returned material is analyzed for determination of cause for rejection and initiation of corrective action"]
["10.8","Corrective actions are verified for suitability and effectiveness at some interval after implementation?"]
["10.9","Incoming Quality Operator follows a reaction plan if raw material or purchased part is found to be out of specification."]
["10.10","Reworked material is re-qualified prior to use or shipment"]
["Corrective Action and Control of Non-Conforming Product Section Score:",null,null,null,null,{"$f":"SUM(F126:F135)/(3*COUNT(F126:F135))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G126:G135)/(3*COUNT(G126:G135))","v":{"$error":"#DIV/0!"}}]
["11. Continuous Improvement",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["11.1","Does the supplier use management reviews to guide and track continuous improvement projects. "]
["11.2","There is a documented plan/schedule for continuous improvement."]
["11.3","The supplier implements a standardized method of continuous improvement activity (i.e. Kaizen, Poka Yoke)."]
["11.4","The supplier plans for continuous improvement as it relates to the evaluation of the effectiveness of the quality systems."]
["Continuous Improvement Section Score:",null,null,null,null,{"$f":"SUM(F138:F141)/(3*COUNT(F138:F141))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G138:G141)/(3*COUNT(G138:G141))","v":{"$error":"#DIV/0!"}}]
["12. Measurement and Test",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["12.1","Is there a calibration program in place for critical tools and instruments?"]
["12.2","Does the supplier evaluate the  impact on the product when an out-of calibration issue is identified? Reaction plans are identified and followed."]
["12.3","Calibration records are maintained and easily accessible?"]
["12.4","If the measuring devices are calibrated internally, a qualified internal calibrator is a must. The calibrating methods and instructions for internally-calibrated devices shall be documented. "]
["12.5","Master gages / standards are traceable to a recognized national / international standard. \n(for example:  NIST) "]
["12.6","Calibration status readily available to operators. The expiration date of the calibration is shown. \n\n"]
["12.7","The appropriate  precision of the gage based upon print tolerances is determined."]
["Measurement and Test Section Score:",null,null,null,null,{"$f":"SUM(F144:F150)/(3*COUNT(F144:F150))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G144:G150)/(3*COUNT(G144:G150))","v":{"$error":"#DIV/0!"}}]
["13. Process Walk",null,null,null,null,"Supplier","Jackson","Observations / Evidence"]
["13.1","Process work instructions are documented, up-to-date, available to operators, and are being followed."]
["13.2","Setup and operating parameters are documented and utilized as specified."]
["13.3","Required tools and inspection equipment are identified for each operation and are utilized as specified."]
["13.4","Each setup is qualified prior to the start of production as required and critical parameters are identified, reviewed and approved."]
["13.5","Repaired production tooling is qualified prior to production use and results documented. "]
["13.6","Is there a culture of \"pride in workmanship\" by the employees? Are employees actively engaged in maintaining a safe, effective work environment?"]
["13.7","Material identification, acceptance status, and control of non-conforming material is maintained throughout the manufacturing process and while product is in storage."]
["13.8","There are control plans that exist for each part number/process, that include the following:"]
[null,"- Standard for approval and rejection"]
[null,"- Signature and date"]
[null,"- Reaction plans for out of control conditions"]
[null,"- Characteristics to be inspected and/or tested"]
[null,"- Engineering revision level"]
[null,"- Sample size and frequency of observations"]
[null,"- Methodology and tools to be used for inspection and/or test"]
[null,"All inspections are completed, per the control plan, before inventory (stores) or shipping and include records of appropriate product characteristics.   "]
[null,"Are the basic statistical methods widely used to measure the process / product, such as checklist, histogram, trends chart and etc., where applicable."]
[null,"Where statistical methods are utilized for control of key characteristics and process parameters\n- Evaluate how they are chosen\n- Define what are the statistical methods used\n- Determine if the appropriate level of control is established\n\n\n"]
["13.9","Where the Process Control Plan calls for SPC,"]
[null,"- Is the data properly recorded?"]
[null,"- Does the data make sense and are reasonable control limits shown?"]
[null,"- Are out of control points noted with the corrective action taken?"]
[null,"- Does the manufacturing process demonstrate the required capability or performance?"]
["Process Walk Section Score:",null,null,null,null,{"$f":"SUM(F153:F160,F171)/(3*COUNT(F153:F160,F171))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G153:G160,G171)/(3*COUNT(G153:G160,G171))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Corrective Action","index":3,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,0,5,1],[5,2,5,3],[5,7,5,8],[2,0,2,8],[1,0,1,8],[3,0,3,8],[4,0,4,1],[4,2,4,3],[4,7,4,8],[14,2,14,3],[14,7,14,8],[18,5,18,6],[18,2,18,3],[6,0,6,1],[7,0,7,1],[7,2,7,3],[7,7,7,8],[10,0,10,8],[11,0,11,1],[11,2,11,3],[11,7,11,8],[12,0,12,1],[12,2,12,3],[12,7,12,8],[13,2,13,3],[13,7,13,8],[30,2,30,3],[30,5,30,6],[31,2,31,3],[27,2,27,3],[27,5,27,6],[28,2,28,3],[28,5,28,6],[31,5,31,6],[29,2,29,3],[29,5,29,6],[26,2,26,3],[26,5,26,6],[20,2,20,3],[21,2,21,3],[21,5,21,6],[22,5,22,6],[23,2,23,3],[22,2,22,3],[24,2,24,3],[23,5,23,6],[24,5,24,6],[25,2,25,3],[25,5,25,6],[19,2,19,3],[19,5,19,6],[20,5,20,6]]}
[]
["Supplier On-Site Assessment\nCorrective Action Form"]
["JF-PU-05, Revision 14.12.1 (December 3, 2014)",null,null,null,null,null,null,null,null,null,"1- Limited Evidence"]
["Supplier Information",null,null,null,null,null,null,null,null,null,"2- Evidence and Documentation"]
["Supplier Name:",null,{"$f":"'Audit Form'!C7:D7","v":0},null,null,null,"Vendor ID #:",{"$f":"'Audit Form'!H7:I7","v":0},null,null,"3- Item Executed with Evidence"]
["Plant Location:",null,{"$f":"'Audit Form'!C8:D8","v":0},null,null,null,"Phone #:",{"$f":"'Audit Form'!H8:I8","v":0}]
[]
["Supplier Contact:",null,{"$f":"'Audit Form'!C10:D10","v":0},null,null,null,"Supplier E-Mail:",{"$f":"'Audit Form'!H10:I10","v":0}]
[]
[]
["Audit Information",null,null,null,null,null,null,null,null,null,"N/A"]
["Lead Name:",null,{"$f":"'Audit Form'!C14:D14","v":0},null,null,null,"Auditor Name:",{"$f":"'Audit Form'!H14:I14","v":0},null,null,0]
["Lead E-Mail:",null,{"$f":"'Audit Form'!C15:D15","v":0},null,null,null,"Auditor E-Mail:",{"$f":"'Audit Form'!H15:I15","v":0},null,null,1]
["Lead Phone:",null,{"$f":"'Audit Form'!C16:D16","v":0},null,null,null,"Auditor Phone:",{"$f":"'Audit Form'!H16:I16","v":0},null,null,2]
["Audit Date:",null,{"$f":"'Audit Form'!C17:D17","v":0},null,null,null,"Cooper Division:",{"$f":"'Audit Form'!H17:I17","v":0},null,null,3]
[]
[]
[]
["No.","Item","Non-Conformance",null,"NCR Number","Responsibility",null,"Due Date","Verification Date and Comments"]
["1"]
["2"]
["3"]
["4"]
["5"]
["6"]
["7"]
["8"]
["9"]
["10"]
["11"]
["12"]
["13"]

{"sheet":"Scoring Summary ","index":4,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[62,3,62,8],[61,2,62,2],[61,3,61,8],[63,3,63,8],[67,3,67,8],[68,3,68,8],[64,3,64,8],[69,3,69,4],[69,0,69,1],[67,0,68,1],[67,2,68,2],[65,0,66,1],[65,3,65,8],[65,2,66,2],[63,0,64,1],[63,2,64,2],[66,3,66,8],[11,0,11,8],[12,0,12,1],[13,0,13,1],[21,4,22,4],[21,5,21,7],[21,8,22,8],[19,0,19,8],[40,5,40,7],[40,4,41,4],[40,8,41,8],[57,0,57,8],[59,0,59,1],[59,3,59,8],[60,0,60,8],[61,0,62,1],[38,0,38,8],[8,0,8,1],[0,0,0,8],[4,0,4,8],[5,0,5,1],[6,0,6,1],[7,0,7,1],[5,7,5,8],[6,7,6,8],[8,7,8,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[5,2,5,3],[6,2,6,3],[8,2,8,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[1,3,1,5],[14,0,14,1],[15,0,15,1],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[15,2,15,3]]}
["Supplier On-Site Assessment Summary"]
[null,null,null,"JF-PU-05, Revision 14.12.1 (December 3, 2014)",null,null,null,"Supplier Score",{"$f":"SUM(F24:F36)/SUM(G24:G36)","v":{"$error":"#DIV/0!"}},null,"0- No Evidence"]
[null,null,null,null,null,null,null,"Jackson Score",{"$f":"SUM(F43:F55)/SUM(G43:G55)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"1- Limited Evidence"]
["Supplier Information",null,null,null,null,null,null,null,null,null,"2- Evidence and Documentation"]
["Supplier Name:",null,{"$f":"'Audit Form'!C7","v":0},null,null,null,"Vendor ID #:",{"$f":"'Audit Form'!H7:I7","v":0},null,null,"3- Item Executed with Evidence"]
["Plant Location:",null,{"$f":"'Audit Form'!C8","v":0},null,null,null,"Phone #:",{"$f":"'Audit Form'!H8:I8","v":0}]
[]
["Supplier Contact:",null,{"$f":"'Audit Form'!C10","v":0},null,null,null,"Supplier E-Mail:",{"$f":"'Audit Form'!H10:I10","v":0}]
[]
[]
["Audit Information",null,null,null,null,null,null,null,null,null,0]
["Division :",null,{"$f":"'Audit Form'!C14","v":0},null,null,"Auditor Name:",null,{"$f":"'Audit Form'!H14:I14","v":0},null,null,1]
["Commodity Family:",null,{"$f":"'Audit Form'!C15","v":0},null,null,"Auditor E-Mail:",null,{"$f":"'Audit Form'!H15:I15","v":0},null,null,2]
["Product Type:",null,{"$f":"'Audit Form'!C16","v":0},null,null,"Auditor Phone:",null,{"$f":"'Audit Form'!H16","v":0}]
["Audit Date:",null,{"$f":"'Audit Form'!C17:D17","v":0},null,null,"Cooper Division:",null,{"$f":"'Audit Form'!H17","v":0},null,null,3]
[]
[]
[]
["Initial (Self) Assessment Summary"]
[]
[null,null,null,null,"Section","Points",null,null,"Score"]
[null,null,null,null,null,"Total","Possible","Percentage"]
[null,null,null,null,"Customer Satisfaction",{"$f":"SUM('Audit Form'!F21:F24)","v":0},{"$f":"(3*COUNT('Audit Form'!F21:F24))","v":0},{"$f":"F24/G24","v":{"$error":"#DIV/0!"}},{"$f":"H24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Quality System",{"$f":"SUM('Audit Form'!F27:F36)","v":0},{"$f":"(3*COUNT('Audit Form'!F27:F36))","v":0},{"$f":"F25/G25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Business System",{"$f":"SUM('Audit Form'!F39:F45)","v":0},{"$f":"(3*COUNT('Audit Form'!F39:F45))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"EHS and Risk Management",{"$f":"SUM('Audit Form'!F48:F54)","v":0},{"$f":"(3*COUNT('Audit Form'!F48:F54))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"New Product Development",{"$f":"SUM('Audit Form'!F57,'Audit Form'!F62,'Audit Form'!F71,'Audit Form'!F79)","v":0},{"$f":"(3*COUNT('Audit Form'!F57,'Audit Form'!F62,'Audit Form'!F71,'Audit Form'!F79))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Purchasing and Sub-Suplier Management",{"$f":"SUM('Audit Form'!F95:F101)","v":0},{"$f":"(3*COUNT('Audit Form'!F95:F101))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Production Control and Planning",{"$f":"SUM('Audit Form'!F104:F110)","v":0},{"$f":"(3*COUNT('Audit Form'!F104:F110))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Change Management",{"$f":"SUM('Audit Form'!F113:F116)","v":0},{"$f":"(3*COUNT('Audit Form'!F113:F116))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Inventory Control and Housekeeping",{"$f":"SUM('Audit Form'!F119:F123)","v":0},{"$f":"(3*COUNT('Audit Form'!F119:F123))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Corrective Action and Non-Conforming Prod.",{"$f":"SUM('Audit Form'!F126:F135)","v":0},{"$f":"(3*COUNT('Audit Form'!F126:F135))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Continuous Improvement",{"$f":"SUM('Audit Form'!F138:F141)","v":0},{"$f":"(3*COUNT('Audit Form'!F138:F141))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Measure and Test",{"$f":"SUM('Audit Form'!F144:F150)","v":0},{"$f":"(3*COUNT('Audit Form'!F144:F150))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Process Walk",{"$f":"SUM('Audit Form'!F153:F160, F171)","v":0},{"$f":"(3*COUNT('Audit Form'!F153:F160,F171))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["Jackson Assessment Summary"]
[]
[null,null,null,null,"Section","Points",null,null,"Score"]
[null,null,null,null,null,"Total","Possible","Percentage"]
[null,null,null,null,"Customer Satisfaction",{"$f":"SUM('Audit Form'!G21:G24)","v":0},{"$f":"(3*COUNT('Audit Form'!G21:G24))","v":0},{"$f":"F43/G43","v":{"$error":"#DIV/0!"}},{"$f":"H43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Quality System",{"$f":"SUM('Audit Form'!G27:G36)","v":0},{"$f":"(3*COUNT('Audit Form'!G27:G36))","v":0},{"$f":"F44/G44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Business System",{"$f":"SUM('Audit Form'!G39:G45)","v":0},{"$f":"(3*COUNT('Audit Form'!G39:G45))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"EHS and Risk Management",{"$f":"SUM('Audit Form'!G48:G54)","v":0},{"$f":"(3*COUNT('Audit Form'!G48:G54))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"New Product Development",{"$f":"SUM('Audit Form'!G57,'Audit Form'!G62,'Audit Form'!G71,'Audit Form'!G79)","v":0},{"$f":"(3*COUNT('Audit Form'!G57,'Audit Form'!G62,'Audit Form'!G71,'Audit Form'!G79))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Purchasing and Sub-Supplier Management",{"$f":"SUM('Audit Form'!G95:G101)","v":0},{"$f":"(3*COUNT('Audit Form'!G95:G101))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Production Control and Planning",{"$f":"SUM('Audit Form'!G104:G110)","v":0},{"$f":"(3*COUNT('Audit Form'!G104:G110))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Change Management",{"$f":"SUM('Audit Form'!G113:G116)","v":0},{"$f":"(3*COUNT('Audit Form'!G113:G116))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Inventory Control and Housekeeping",{"$f":"SUM('Audit Form'!G119:G123)","v":0},{"$f":"(3*COUNT('Audit Form'!G119:G123))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Corrective Action and Non-Conforming Prod.",{"$f":"SUM('Audit Form'!G126:G135)","v":0},{"$f":"(3*COUNT('Audit Form'!G126:G135))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Continuous Improvement",{"$f":"SUM('Audit Form'!G138:G141)","v":0},{"$f":"(3*COUNT('Audit Form'!G138:G141))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Measure and Test",{"$f":"SUM('Audit Form'!G144:G150)","v":0},{"$f":"(3*COUNT('Audit Form'!G144:G150))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Process Walk",{"$f":"SUM('Audit Form'!G153:G160,G171)","v":0},{"$f":"(3*COUNT('Audit Form'!G153:G160,G171))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["On-Site Assessment Scoring "]
[]
["Overall Score",null,"Segmentation","Description"]
[]
["All Green\n>79%",null,"Level 1- Strategic","Current Supplier: Supplier is currently performing at a Level 1 - Recommend strongly"]
[null,null,null,"New Supplier: Performance is consistent with Level 1 performance - Recommend strongly"]
["60-79%",null,"Level 2 - Preferred","Current Supplier: Not currently performing at a Level 1 but has the potential with minimal improvements. Existing business can continue and the supplier can be considered for new business - Recommend with Corrective Actions"]
[null,null,null,"New Supplier: Has the potential to perform at a Level 1 with minimal improvements required - Recommend with Corrective Actions"]
["40-59%",null,"Level 3 - Maintain","Current Supplier: Corrective actions are needed for the supplier to improve performance. During this time, business can continue  upon review of corrective actions - Not Recommended - Source with Risk"]
[null,null,null,"New Supplier: Significant corrective actions needed to bring the performance to an acceptable level -  Not Recommended - Source with Risk"]
["< 39%",null,"Level 4 - Non-Performing","Current Supplier: Performance not consistent with minimum standards. Not Recommended for New Business. A corrective action plan must be provided and implemented within 60 days. Failure wil result in alternative site sourcing"]
[null,null,null,"New Supplier: No new business will be awarded. Not Recommended - Do Not Source"]