{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Cover Sheet","Supplier Overview","1.0 Auditchecklist ","2.0 MgmtSysPln","3.0 QualSystems","4.0 ProcessQualityMgmt","5.0 MfgCapImpPro","6.0 SupplyChainMgmt","7.0 PPAP","Summary","History Of Changes"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":14,"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":"Instructions","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[12,1,12,13],[19,1,19,13],[11,1,11,8],[9,1,9,8],[4,12,4,13],[14,1,14,13],[0,1,0,13],[5,1,5,8],[6,1,6,13],[8,1,8,13],[10,1,10,13],[35,1,35,12],[15,1,15,13],[31,1,31,12],[32,1,32,12],[33,1,33,12],[34,1,34,12],[17,1,17,13],[30,1,30,7],[28,1,28,16],[21,1,21,13],[23,1,23,13]]}
[null,"Creation Supplier Requalification Audit"]
[]
[]
[null,"Form Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Go to Summary tab"]
[]
[1,"Enter audit date, supplier name, and supplier # on the Cover Sheet tab. This data will replicate to the applicable remaining locations."]
[]
[2,"The supplier is expected to evaluate and rate themselves for each item along the Audit maturity path using the ratings from 1 to 5."]
[]
[3,"The rating score is to be entered in the box to the right of each item under the heading labeled \"Supplier Rating\"."]
[]
[4,"The rating scores are to be entered as whole numbers only. No partial credit will be recognized."]
[]
[5,"For each item within this Audit, the supplier's maturity path score is based on the supplier's ability to demonstrate that they meet / comply with all expectations listed in the corresponding item requirements box and be able to provide objective evidence of compliance."]
[6,"For each section / page, the total maturity path rating score for all items will appear in the box in the lower right hand corner labeled \"Section Score\"."]
[]
[7,"Identify items requiring improvement and develop a corrective action plan to address deficiencies."]
[]
[8,"Creation will follow the same steps with the supplier and rate the supplier from the customer's perspective. "]
[]
[9,"Scores from the supplier self-assessment and Creation validation assessment will be compared to gain an understanding of differences."]
[]
[null,"The supplier will have a designated time period to develop and address items requiring improvement."]
[]
[]
[]
[]
[null,"Depending on the final score, the supplier may have a designated time period to address and  develop items not meeting Creations expectation and required improvements."]
[]
[null,"PROPRIETARY AND CONFIDENTIAL"]
[null,"·         This document is proprietary to Creation Technologies and not for replication or publication outside Creation Technologies."]
[null,"·         It is understood that unless sanctioned, in writing, by duly authorized officer of the Creation Technologies Legal Affairs Team this information is confidential, and no news release, advertisement or public announcement, or denial or confirmation of the same, concerning any part of the subject matter of this process will be made by any employee."]
[null,"·         The information shall not at any time be disclosed to any third party, including Creation customers, suppliers or representatives thereof, unless sanctioned, in writing, by duly authorized officer of the Creation Technologies Legal Affairs Team. "]
[null,"·         Any information, report or documents referenced within this document shall be deemed and managed as confidential and proprietary unless written guidance to the contrary exits."]
[null,"·         Use, duplication and/or dissemination of the content and/or media contained herein or by virtue of this document may only be sanctioned, in writing, by duly authorized officer of the Creation Technologies Legal Affairs Team."]

{"sheet":"Cover Sheet","index":1,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,2,27,8],[30,1,30,3],[40,1,40,3],[40,5,40,8],[34,1,34,3],[34,5,34,8],[36,1,36,3],[36,5,36,8],[38,1,38,3],[38,5,38,8],[4,2,4,4],[9,6,9,8],[30,5,30,8],[2,0,2,9],[32,1,32,3],[32,5,32,8],[11,2,12,8],[16,2,16,3],[18,6,18,8],[20,2,20,8],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[25,2,25,8],[26,2,26,8]]}
[null,null,null,"CONFIDENTIAL",null,null,null,null,null,null,"Go to Site Overview Tab"]
[]
["Creation Supplier Requalification Audit"]
[]
[null,"Supplier:","<Enter Supplier>"]
[]
[null,"Facility Address:","<Enter address>"]
[]
[]
[null," Supplier Number:","<Enter supplier #>",null,null,"Audit Date: ","<Enter audit date>"]
[]
[null,"Reason for Audit:","____________________________________________________________________________________________________________________________________________________________"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<select>"]
[null,"Creation Average Score:",{"$f":"Summary!E20","v":"TBD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Recommended"]
[null,"Audit Conclusion:","<select>"]
[]
[null,"Follow-up Required:","<select>",null,null,"Follow-up Date: ","<enter date>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<select>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Creation Auditors",null,null,null,"Supplier/Site Management Acknowledgment"]
[]
[null,"<Enter Auditor Names>",null,null,null,"<Enter Mgmt Names & Titles>"]

{"sheet":"Supplier Overview","index":2,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[23,5,23,7],[24,5,24,6],[24,7,24,8],[26,5,26,7],[27,5,27,6],[27,7,27,8],[36,1,36,3],[52,1,52,4],[52,5,52,9],[44,1,44,3],[50,1,50,5],[40,1,40,3],[44,5,44,7],[46,1,46,4],[15,6,15,7],[18,5,18,6],[18,7,18,8],[46,5,46,6],[48,1,48,4],[48,5,48,9],[21,5,21,6],[21,7,21,8],[34,1,34,3],[34,4,34,5],[34,6,34,7],[20,1,20,3],[20,5,20,7],[34,8,34,9],[28,4,28,5],[32,4,32,5],[8,1,8,2],[8,3,8,5],[8,6,8,7],[10,1,10,2],[10,3,10,5],[10,6,10,7],[9,1,9,2],[9,3,9,5],[9,6,9,7],[11,1,11,2],[11,3,11,5],[11,6,11,7],[17,1,17,3],[17,5,17,7],[12,1,12,2],[12,3,12,5],[12,6,12,7],[13,1,13,2],[13,3,13,5],[13,6,13,7],[14,1,14,2],[14,3,14,5],[14,6,14,7],[15,1,15,2],[15,3,15,5],[6,8,7,8],[6,9,7,9],[7,1,7,2],[4,1,4,2],[1,1,1,9],[2,1,2,2],[3,1,3,2],[5,1,5,2],[7,3,7,5],[7,6,7,7]]}
[null,null,null,null,null,"CONFIDENTIAL"]
[null,"Supplier OVERVIEW"]
[null,"Supplier Name:",null,{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"}]
[null,"Address:",null,{"$f":"'Cover Sheet'!C7","v":"<Enter address>"}]
[null,"City, State, Zip Code:",null,{"$f":"'Cover Sheet'!C8","v":0}]
[null,"Creation Supplier #:",null,{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"}]
[null,null,null,null,null,null,null,null,"TIME IN POSITION","YEARS AT COMPANY"]
[null,null,null,"NAME",null,null,"PHONE NO."]
[null,"CEO/President"]
[null,"Quality Control Mgr"]
[null,"Plant Mgr"]
[null,"Production Manager"]
[null,"Engineering Manager"]
[null,"Sales"]
[null,"Supplier Audit Lead"]
[null,"___________________"]
[]
[null,"1. Are you ISO-9001 Certified?",null,null,"<select>","If Yes, Send/submit copy of Certificate."]
[null,null,null,null,null,"If No, Planned Date?"]
[]
[null,"2. Are you AS-9100 Certified?",null,null,"<select>","If Yes, Send/submit copy of Certificate."]
[null,null,null,null,null,"If No, Planned Date?"]
[]
[null,"3. Are you ISO-13485 Certified?",null,null,"<select>","If Yes, Send/submit copy of Certificate."]
[null,null,null,null,null,"If No, Planned Date?"]
[]
[null,"4. Are you CGMP Compliant?",null,null,"<select>","If Yes, Send/submit copy of Certificate."]
[null,null,null,null,null,"If No, Planned Date?"]
[null,"5. When was your company founded?"]
[]
[null,"6. Are you privately owned?",null,null,"<select>"]
[]
[null,"7. Creation % of total business"]
[]
[null,"8. What is the facility size?"]
[]
[null,"9. Number of employees?",null,null,"Salaried"]
[]
[null,null,null,null,"Hourly"]
[]
[null,"10. Percent Employee turnover?",null,null,"Management:",null,"%","Hourly:",null,"%"]
[]
[null,"      What is the current manufacturing capacity percentage?  ______________ %"]
[]
[null,"11. Your current plant utilization?"]
[]
[null,"12. How many shifts/day does your plant normally work?",null,null,null,null,null,"Days/week?"]
[]
[null,"13. What type of products do you manufacture?"]
[null,null,"     "]
[null,"14. Do you currently manufacture parts for the aerospace industry?",null,null,null,null,"<select>",null,"     "]
[]
[null,"15. What are the typical materials with which you work?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"     "]
[null,null,null,null,null,null,null,null,null,null,null,"     "]

{"sheet":"1.0 Auditchecklist ","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,6,5,6],[2,1,2,2],[0,3,0,4],[1,3,1,4],[22,1,22,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[25,1,25,2],[19,1,19,2],[33,1,33,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[26,1,27,2],[21,1,21,2],[24,1,24,2],[10,0,15,0],[10,1,15,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[null,null,"                                                        CONFIDENTIAL",null,null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"}]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"}]
["Section: ","Audit Check List (Yes and No)",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"}]
[null,null,null,null,"Supplier Rating","Creation Rating"]
["Process Control",null,null,null,"Select from Drop down\nyes/no/na","Select from Drop down\nyes/no/na","Quality Audit Notes:\nEnter comments / notes "]
["Documentation"]
["1.1","Is the documentation controlled and the correct revision?",null,"There is a process for document control that includes revision dates.  All accessible controlled documents are at the current revision level, unless identified as Reference Only documents."]
["1.2","Do you follow an Engineering Change/Configuration Management process for document changes?",null,"There is a documented Engineering Change/Configuration Management process for document changes in place for all documents under the supplier's control (e.g., process prints, internal procedures, etc.)."]
["1.3","Does the employee verify all aspects of the process are in place prior to performing the process?  ",null,"There is evidence that employees confirm all aspects of the process are in place prior to performing the process.  This includes verifying calibration and material shelf life, raw material availability, routing sheets, inspection checklists, data recording tools, etc."]
["1.4","Is material quantity verified?",null,"There is evidence that employees verify quantities required and that sufficient raw material is available to manufacture at each process step."]
["1.5","All parts and raw material are properly identified at all times: There are clearly legible tags, labels, and or other identification marks.",null,"Incoming parts/raw material?"]
[null,null,null,"Stocked parts/raw material in production area"]
[null,null,null,"WIP (Work In Process)?"]
[null,null,null,"FG (Finished Goods)?"]
[null,null,null,"Do parts remain properly and clearly identified between steps?"]
[null,null,null,"Nonconforming material clearly marked and segregated?"]
["1.6","Is the tooling, measurement, and test equipment specified in the process documentation the same as what is available at the workstation, and being used?",null,"Tooling, measurement, and test equipment at each work station corresponds to what is called out in the process documentation.  If required equipment is not located at the work station, it is available to the employee and there is evidence that it is being used according to the process documentation."]
["1.7","Are router or traveler steps signed off at the appropriate times, either electronically or on the hard copy?",null,"Evidence is available that all routing steps are signed off at appropriate times according to the routing documentation."]
["1.8","If personally identified approval stamps are used, are they controlled?",null,"Evidence that approval stamps being used for sign-off are controlled and up-to-date is available."]
["1.9","Is time-sensitive material or material with a shelf-life (e.g., Loctite, epoxy, paint, solder flux, No-flux Solder, RTV, rust preventative, etc.) within the expiration date?",null,"There is evidence that time-sensitive parts or material or those having a published or industry standard shelf-life are identified and tracked.  There is evidence that expired material is purged from the system.  There is evidence that all material on site is within its expiration date. How are expiration dates determined or calculated for time sensitive material?"]
["Welding"]
["1.10","If the supplier does welding, does the supplier document weld repairs as applicable?",null,"Written procedure for applying serial number to each part that is welded and stamping each welded part with the welder’s stamp."]
["1.11","Does the supplier 100% inspect weld repairs using PED-qualified NDT procedures and operators?",null,"The supplier’s third-party NDT certification has been pre-approved by Creation. Written procedure for performing NDT inspection on all PED parts which are repair welded, to the requirements of 9943-1061, Note 37."]
["Electro-Static Discharge (ESD)"]
["1.12","Is the area clearly marked that ESD requirements apply?  Is proper equipment available for visitors to the supplier?",null,"All areas where ESD requirements are in place are clearly marked (signs, tape on the floor, paint, etc.).  There is proper equipment available for visitors to use if required."]
["1.13","Are ESD safety measures implemented (e.g., bench/floor mats in place & grounded, plug-ins for grounding wrist straps, etc.)?",null,"There is a documented ESD procedure in place and there is evidence it is being followed."]
["1.14","There is documented evidence that all safety equipment checks are being conducted as required by the published ESD process documents.",null,"Are wrist and/or heel strap checks done?  "]
["1.15",null,null,"Are monthly bench/mat grounding checks done?"]
["Pressure Equipment Directive (PED) Part Requirements"]
["1.16","Is there a procedure for evaluating the Quality Management System certificate for raw materials?",null,"Written procedure for evaluating the QMS certificate of a mill or foundry to Creation or customers' requirements, and assuring that it is on file at Creation before the parts are shipped."]
["1.17","Is there a procedure for evaluating the Material Certificate (Material Test Report - MTR) issued by the raw material manufacturer and providing it with finished parts?",null,"Written procedure for evaluating the MTR for incoming raw material, to the requirements of Creation or it's customers, whichever is applicable.  Evidence that MTR is supplied with every shipment of affected finished parts."]
["1.18","Is there a process to document heat numbers on castings and verify they are reflected on incoming MTR? ",null,"Written procedure to evaluate incoming castings and accompanying MTR to verify that all of the castings are covered by the MTR and that the heat numbers are specifically listed on the MTR."]
["1.19","Is there a procedure to track the heat numbers through the process and supply MTR for the heat numbers with the finished parts? ",null,"Written procedure/process that assures that MTR is supplied with finished parts and that the MTR covers the heat numbers on all the parts."]
["1.20","If gaskets are supplied, does the supplier provide declaration of compliance.",null,"Written procedure for providing Declaration of Compliance."]
[]
[null,null,null,"Section Score YES",{"$f":"COUNTIF(E7:E34, \"YES\")","v":0},{"$f":"COUNTIF(F7:F34, \"YES\")","v":0}]
[null,null,null,"Section Score NO",{"$f":"COUNTIF(E7:E34, \"NO\")","v":0},{"$f":"COUNTIF(F7:F34, \"NO\")","v":0}]
[null,null,null,"Section Score N/A",{"$f":"COUNTIF(E7:E34, \"NA\")","v":0},{"$f":"COUNTIF(F7:F34, \"NA\")","v":0}]

{"sheet":"2.0 MgmtSysPln","index":4,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,6,1,8],[0,6,0,8],[2,6,2,8],[4,9,5,9],[0,3,0,4],[1,3,1,4]]}
[null,null,null,"CONFIDENTIAL",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Section: ","Management Systems and Planning",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ","Organizational Elements","> > > > > > > > > > Quality Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter  comments / notes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[2.1,"Use of the e-Business or Supplier Portal system","○ - No formal use of the e-Business or Supplier Portal system.","○ - Use of e-Business or Supplier Portal for reference only not to plan or drive action.\n","○ - Utilize e-Business or Supplier Portal Applications, Documents, & Performance\n\n","○ - Utilize e-Business or Supplier Portal Scheduling Reports\n","○ - Fully utilize the e-Business or Supplier Portal Center ",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[2.2000000000000002,"Purchase Order Contract Review","○ - There are no procedures for reviewing contracts prior to acceptance.","○ - Procedures are in place to review contracts, but review is not connected to capabilities or capacity.","○ - The contract review process considers complexity, producibility, inspection equipment, price, lead time, capacity, and customer delivery needs.\n○ - Signatures of review and acceptance is required and documented.","○ - Contract review The PO review process must be designed to cover EC print revisions, FAI/PPAP requirements, Special Handling Code changes, etc. ","○ - Changes evaluated by a cross functional team that gives consideration to complexity and producibility, tooling, Work in Process, and FAI/PPAP lead time; based on data.",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[2.2999999999999998,"Commitment to Improvement ","○ - No expressed need and commitment to Continuous Improvement (CI).\n○ - No vision, goals, or milestones for improvement in quality, cost, delivery, lead time, service, and technology.","○ - Expressed commitment to Continuous Improvement goals.\n○ - Documented vision, goals,  milestones & training for improvement.\n○ - Ongoing Vision & nature of change communicated to employees.","○ - Committed to improvement goals are demonstrated.\n○ - Activities in progress in several areas to achieve goals.\n○ - Metrics for improvement are being monitored.\n○ - Beginning cross-functional integration.","○ - Formal continuous improvement program with cross-functional integration.\n○ - Multiple improvement efforts are in progress with demonstrated progress towards goals.\n○ - Formal rewards and recognition program.","○ - Documented multi-year plan and dedicated organizational structure supports continuous improvement.\n○ - CI is self-sustaining and is achieving aggressive improvement goals.",null,null,null,null,null,null,{"$f":"H9","v":0},null,0]
[2.4,"\nTraining","○ - No formal training system.","○ - Training is based upon customer or specification requirements.\n○ - Personnel are adequately trained in policies and procedures of their operations and departments.","○ - Documented formal training is based upon needs assessment and customer or specification requirements.","○ - Documented training program is based upon skill gaps.\n○ - Defined curriculum includes problem solving.\n○ - Personnel are cross trained to multiple job functions.","○ - Training process is based upon needs assessment with employee input.\n○ - Defined curriculum includes career development.                  Company wide training matrix.          ",null,null,null,null,null,null,0,null,0]
[2.5,"Employee communication and Involvement\n","○ - No regular management communication with employees\n○ - Management style is autocratic.  \n.","○ - Management has regularly scheduled meetings with employees and communicates improvement targets and activities.\n.","○ - Operators are aware of customer complaints, scrap, end-of-line failures\n○ - Can demonstrate what they are doing to address reported quality issues","○ - All employees aware of any Quality issues associated with the process they are performing\n○ - All employees understand the company Quality Policy\n○ - Quarterly Management meetings with employees","○ - Daily Management meetings\n○ - Quality Policy is documented and is easily accessible to every employee.  Employees are aware of the Quality Policy and are able to access it\n○ - Evidence of completed or in-process CI projects \n",null,null,null,null,null,null,0,null,0]
[2.6,"Health, Safety, and Environmental (HS & E)","○ - No formal procedures established for  HS & E concerns, including, MSDS, OSHA, EPA, RoHS Directive where applicable.","○ - Documentation available identifying all raw materials, isolatable intermediates and final products on inventory, \"Right to Know\" satisfied, RoHS info available for substances contained in provided product.","○ - Formal procedures, training program and metrics are established but not fully implemented.","○ - Training program implemented with follow-up as required, evidence of compliance with environmental and safety regulations.\n○ - Metrics are posted.\n○ - Management sponsored safety and response teams are formed.","○ - Supplier facilities actively manage/minimize energy consumption. ",null,null,null,null,null,null,0,null,0]
[2.7,"Safety Awareness","○ - Safety training and audits in response to incidents.","○ - Documented periodic safety training.  Audits are on annual basis.","○ - Periodic safety training and audits with management review.","○ - Regular safety training, frequent communication, and audits with management participation.","○ - High visibility of safety performance which is at benchmark levels for industry.   ○ - Safety Incident Reporting System.",null,null,null,null,null,null,0,null,0]
[2.8,"Ethics Compliance Program","○ - No formal ethics compliance program or system in place.","○ - A documented statement regarding ethics compliance is in place and readily available to all employees.","○ - A documented policy and training program regarding ethics compliance has been implemented and includes an annual employee review / certification process.","○ - An ethics compliance program with executive sponsored infrastructure is in place to maintain and monitor compliance.\n○ - The program provides an avenue for violation reporting, investigation, and timely resolution.\n○ - Employees are provided with thorough ethics compliance training.","○ - A formally documented and maintained program with executive oversight is in place and includes responsibilities that are clearly assigned for ethics compliance.\n○ - The program provides an avenue for violation reporting, investigation, and timely resolution.\n○ - Employees are provided with thorough ethics compliance training.\n○ - Expectations and requirements concerning ethics compliance are flowed down to the supply base.",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I15)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N14,\"<=2\")","v":8},null,{"$f":"COUNTIF(P7:P14,\"<=2\")","v":8}]

{"sheet":"3.0 QualSystems","index":5,"n_rows":19,"n_cols":26,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,9,5,9],[0,6,0,8],[1,6,1,8],[2,6,2,8],[2,1,2,2],[0,3,0,4],[1,3,1,4]]}
[null,null,null,"CONFIDENTIAL                                     ",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Section: ","Quality Systems",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ","Organizational Elements","> > > > > > > > > >Quality Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter comments / notes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[3.1,"Quality Systems","○ - No third party quality system registration and may not comply to all of quality system requirements being flowed down by the applicable Creation business site.","○ - Third party registered and will comply with all of the quality system requirements being flowed down by the Creation business site.\n○ - Plan developed to comply to Creation's Supplier Quality Requirements.","○ - ISO-9001 or AS-9100 third party certified.\n○ - Compliant to Creation's Supplier Quality Requirements.","○ - ISO-13485 or AS-9100 third party certified.\n○ - Compliant to Creation's Supplier Quality Requirements.","○ - AS-9100 3rd party certified or cGMP complaint certified.\n○ - Compliant to Creation's Supplier Quality Requirements.\n○ - Carry NADCAP or other certification for all special processes on-site.",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[3.2,"Manufacturing and Quality Engineering Support for Creation of FAI/PPAP\n (Production Part Approval Process)","○ - Supplier is unfamiliar with the FAI/PPAP documentation and process.\n○ - FAIs/PPAPs have never been processed or created at the supplier.","○ - Plans in place to train and provide staff for the processing of FAI/PPAP documentation and process.","○ - Adequate trained staff to support FAI/PPAP documentation unless displaced by production priorities.\n○ - FAIs/PPAPs have been performed for other customers. General FAI/PPAP requirements are understood.\n○ - Creation's FAI/PPAP requirements are understood.","○ - Sufficient trained and \"experienced\" engineering and quality staff to support FAI/PPAP activities and production simultaneously.\n○ - Very \"limited\" disruption to production support.","○ - Demonstrated \"experienced\" engineering and quality staff to support short lead time FAIs/PPAPs and production simultaneously with no disruption to production.\n○ - FAI/PPAP is an \"institutionalized\" part of supplier process.",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[3.3,"Internal Audit Systems","○ - Internal audits of quality system being conducted.\n○ - No evidence of root cause analysis being performed.","○ - Internal audits of quality system being conducted to schedule; Auditors independent of area being audited.\n○ - Auditors have been formally trained.","○ - All quality system elements are being audited according to schedule as defined/documented by the supplier.\n○ - Root cause and corrective actions from internal audits are addressed in a timely manner.","○ - Root cause and corrective actions from internal audits are being addressed with no past due responses.\n○ - Management is on distribution.","○ - Internal audit system consistently identifies opportunities for improvement to procedures and systems which are subsequently acted on by the organization.",null,null,null,null,null,null,0,null,0]
[3.4,"Non-Conforming Material ","○ - Procedure is in place for documenting internal rejects.\n○ - There is minimal tracking and data being analyzed.\n○ - Defect rate is unknown or increasing.","○ - Procedures are in place for segregation, documentation, tracking  and resolving internal rejects.\n○ - All Non-Conforming material located in controlled location with limited access.\n○ - MRB disposition and approval authorities are defined and documented.","○ - Defect rate is known and is stable or improving.\n○ - Internal defects are characterized and posted as metrics visible to the workforce.","○ - Defect data is analyzed and used to drive process improvements.\n○ - Metrics confirm improvements are effective.\n○ - Metrics are posted and managed by individual cells or departments.","○ - Defect data is analyzed and used to drive process improvements (RCCA).\n○ - Metrics are posted and managed by individual cells or departments.\n○ - Gemba walks are being conducted by management to review metrics and discuss with workforce.",null,null,null,null,null,null,0,null,0]
[3.5,"Corrective Action","○ - No procedures are written to identify and control the corrective action process for internal and/or customer complaints.","○ - Direct cause analysis only.\n○ - Corrective action is performed on specific defect only if requested by the customer.","○ - Direct and contributing cause analysis.\n○ - Containment actions are identified and taken on all internal and external rejects.\n○ - Containment includes WIP, Stock, finished product, Customer Location, and In Transit.\n○ - Documented system for customer notification of supplier escapes.","○ - Root cause analysis and corrective action follows a structured, documented approach (five \"why's\", 8D, etc.).\n○ - RCCA training has been completed by all process owners (ME, QE, Planners, Operators, etc.).\n","○ - Evidence can be demonstrated of root cause analysis and corrective action including preventive and systemic actions.                    ○ - FMEAs and Control Plans are updated.     ",null,null,null,null,null,null,0,null,0]
[3.6,"Control of Scrap","○ - No documented process or work instructions are available.","○ - Procedures / work instructions are in place.\n○ - Minimal documentation recorded.\n○ - Disposition and approval authorities are undefined.","○ - All discrepant material is immediately segregated and/or identified by suitable means until disposition.                      ○ - A Non-Conforming Report is generated for discrepant material or product.\n○ - Containment areas are clearly identified and segregated.\n○ - Shop floor paperwork is clearly annotated.","○ - There is evidence that non-conforming and suspect material is properly and clearly identified, segregated from good parts and material, and secured from general access by unauthorized personnel.\n○ - Description of discrepancy is documented.","○ - Material is fully traceable back to the operation and mutilated or segregated as required.\n○ - MRB disposition and approval requires training with traceable records.",null,null,null,null,null,null,0,null,0]
[3.7,"Cost of Poor Quality\n(COPQ)","○ - No significant measures of COPQ.\n○ - Limited trend analysis on an item to item basis.\n○ - Trends and analysis completed only on a macro level.","○ - Costs of scrap, rework and repair collected.\n○ - Analysis on an \"As Required\" basis.\n○ - Limited ability to analyze.\n○ - Some positive trends over short term (<12 months).","○ - Costs automatically collected for customer rejects, scrap, rework, repair, and detection.\n○ - Periodic analysis.\n○ - Positive trends over long term (>1 year).\n○ - Evidence to substantiate improvement.","○ - COPQ automatically collected by internal information system and assignable to products at detail level.\n○ - Data available during manufacturing cycle.\n○ - Positive trends over long term (>1 year).\n○ - Action plans in place with a formal management driven system.","○ - COPQ collected on-line and identifiable to all part levels.\n○ - Analyzed and used to drive improvement process.\n○ - Near zero failure costs with minimal appraisal costs.\n○ - Emphasis on prevention.",null,null,null,null,null,null,0,null,0]
[3.8,"Calibration Control"," ○ - No written procedure requiring periodic calibration of all gauges and other measuring devices.","○ - Written calibration procedures exist for all gauges and other measuring devices.\n○ - Calibration status is indicated on all gauges including employee owned gauges whether used for product acceptance or not.","○ - There are no active past due gauges.\n○ - Calibration standards are traceable to  an appropriate national or industry standards authority (e.g. NIST).\n○ - Quality records indicate gauges are within calibration requirements.","○ - Calibration records indicate gauges are calibrated as prescribed by the written procedure.\n○ - Actual readings are recorded during calibration.\n○ - Automatic notification of gages that are due for calibration.                             ○ - Tooling that is used as Reference Only are clearly labeled.","○ - Calibration procedures define the process for evaluation and control of potential non-conforming product due to Significantly Out of Tolerance gauges.  Ref. ANSI Z540, ISO 10012, and ISO/IEC 17025.",null,null,null,null,null,null,0,null,0]
[3.9,"Quality / Inspection Planning","○ - Inspection planning is performed at or near time of production.\n○ - Planning does not include methods of inspection and does not utilize statistical techniques.","○ - Planning includes methods of inspection and some statistical techniques if required by the customer.\n","○ - Quality / Inspection planning completed at or before manufacturing process design phase.\n○  - Utilization of FMEAs is preferred but not required.","○ - Planning includes detailed control plans, sampling plan, gage selection, gauge R&R, MSA analysis, and Process FMEAs.","○ - Fully integrated system for Advanced Product Quality Planning (APQP) and Control Plans.\n○ - Includes methods, statistics, and mistake proofing by manufacturing using lessons learned and established standards.\n○ - Able to fulfill all requirements of customer requested FAI/PPAP submissions.",null,null,null,null,null,null,0,null,0]
[3.1,"Record Retention -  (General) Detail retention would be based on Certification Body","○ - There are no procedures for record retention.","○ - There are written procedures for record retention including defined minimum retention periods.","○ - Quality records can be maintained for >1 years or other specific customer requirement.","○ - Quality records can be maintained for >5 years and are availably upon customers request within one working day.","○ - Quality records are being maintained for >10 years and are availably upon customers request within one working day via electronic media.",null,null,null,null,null,null,0,null,0]
[3.11,"Traceability System","○ - No system to maintain lot-to-lot traceability.","○ - There is a documented system to maintain internal traceability.","○ - There is a documented system to maintain lot-to-lot traceability from sub-tiers through delivery.\n○ - System transaction made per the stocking procedure  System bin location with actual bin location, etc. can be verified","○ - There is a documented system implemented for all material, including any provided by Creation.","○ - There is a documented system implemented maintaining electronic lot-to-lot traceability and unit-to-unit traceability for all product.",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H17)","v":0},{"$f":"SUM(I7:I17)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N17,\"<=2\")","v":11},null,{"$f":"COUNTIF(P7:P17,\"<=2\")","v":11}]

{"sheet":"4.0 ProcessQualityMgmt","index":6,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,9,5,9],[2,1,2,2],[1,6,1,8],[0,6,0,8],[2,6,2,8],[0,3,0,4],[1,3,1,4],[0,1,0,2]]}
[null,"                       ",null,"CONFIDENTIAL",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Section: ","Process Quality Management",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ","Organizational Elements","> > > > > > > > > >Quality Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter comments / notes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[4.0999999999999996,"Management Commitment\nand Process Control","○ - Process control, including SPC, as appropriate, is only customer driven.  ","○ - Data collection and analysis initiated by supplier on a few key manufacturing processes. ","○ - Regular internal evaluation of process control effectiveness is completed.\n○ - Evidence of internally driven process control improvements can be demonstrated.","○ - Process control methods are focused on process input parameters, variation reduction and mistake proofing.","○ - Industry and internal best practices and lessons learned are documented and used in planning.\n○ - End of line rejections are extremely rare.",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[4.2,"Procedures and Documentation","○ - Process control procedures and work instructions are not documented or controlled.","○ - Process control procedures and work instructions are documented and under revision change control.","○ - Periodic audits are conducted to ensure operators are following work instructions.\n○ - Operators understand how to identify incorrect work instructions and get them corrected.                                ○ - Operators know where to find or access their work instructions.","○ - Process control procedures and work instructions are updated  to ensure work being performed matches work instructions exactly.\n○ - Data collected from all in-process testing performed according to the process documentation is available and is recorded per the process documentation.\n","○ - Procedures and documentation are accurate and being followed.\n○ - They are clear and understandable and can be followed by new operators.\n○ - Adherence to work instructions is being audited.",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[4.3,"Control Plan\n(Documented descriptions of the methods used for controlling production parts and processes)","○ - Some control plans exist and are customer driven only.\n○ - Once completed they are rarely reviewed or updated.","○ - General control plans exist and are reviewed and updated when required.\n○ - Key Characteristics, are not being controlled","○ - For all products, part specific control plans are required, documented and updated.\n○ - Procedures mandate that control plan is reviewed and updated for any process change. \n○ - If the process contains any KEY characteristics, they are being controlled but data is not collected.","○ - Data collected for KEYs per the Control Plan and available for review.  The data shows that KEYs are being monitored and are in control.\n○ - There is evidence that the control plan is a living document with evidence of periodic updates.","○ - Control plans are developed and implemented for all products utilizing Process FMEAs.",null,null,null,null,null,null,0,null,0]
[4.4000000000000004,"Process Change Control","○ - Process steps are defined and documented for control.","○ - Process changes are documented and controlled.\n○ - Evidence of internally driven production reediness review.","○ - Customer Change Notifications submitted as standard practice.","○ - Supplier is adhering to Creation’s PCN (Process Change Notification) process.\n","○ - Evidence that the supplier has followed Creation's PCN process in the past is available (signed PCN form, FAI/PPAP approval based on a PCN, etc.).  No evidence is found that the supplier has not followed the requirements of Creation's PCN process (moving to another facility, process changes, outsourcing, external source changes, etc.).",null,null,null,null,null,null,0,null,0]
[4.5,"Data Collection, Analysis and Continuous Improvement","○ - Sampling inspection used without objective evidence of process capability.\n○ - Process Performance data and variable measurements are recorded but not used","○ - Sampling inspection used with objective evidence of process capability.\n○ - Process Performance data is analyzed by supervisors and management.\n○ - Feedback is provided to operators.","○ - Process Performance data is collected by operators in production.\n○ - Simple analysis performed (e.g. pre-control charts, X bar and R charts).\n○ - Capability studies are performed ","○ - Process capability data is known and used in process development and control plan creation. \n○ - Performance data utilized by operators in real time for fact based decisions.  ","○ - Documented evidence of performance analysis is driven throughout organization for continuous improvement.\n○ - Evidence of process and/or product improvements that have been made, are in-process, or are planned that are associate with the Quality goals and objectives other than those based solely on customer complaints",null,null,null,null,null,null,0,null,0]
[4.5999999999999996,"Final test","\n○ - Limited final test where variable measurements are recorded.","○ - There are documented processes for product inspection and testing,\n","○ - There is evidence that all inspection and testing is being completed based on process documents and inspection plans. ○ - There is evidence that all inspection and testing is being completed in accordance with Creation's requirements. ","○ - Process Performance data is collected by operators in production.\n○ - Final functional test conducted by the supplier (e.g.--leak test, power output, motor function, etc. of an assembly).\n","○ - There are final inspection process to stock the item and is it followed (e.g., packaging audit, opening parts to check for corrosion or damage, etc.)\n○ - There is recorded evidence that second operator checks are performed as required by the process documentation.",null,null,null,null,null,null,0,null,0]
[4.7,"Statistical Process Control\n- Collection of Statistical Data","○ - Supplier does not track or collect statistical data on any of their items.","○ - Supplier does track or collect some statistical data, but on a limited basis.","○ - Supplier collects and tracks statistical data and uses the data collected to improve the process on future work orders.","○ - Supplier collects and tracks statistical data in real time and manually inputs adjustments into the controller offsets to keep the process \"centered\" within the tolerances.","○ - Supplier collects and tracks statistical data in real time with inspection devices connected to controllers that automatically adjust offsets to keep the process \"centered\" within the tolerances.",null,null,null,null,null,null,0,null,0]
[4.8,"Process Improvement\n- Approach and Tools","○ - Process improvement is not defined resulting in random improvements which may not be permanent.","○ - Cross functional approach to problem solving using a defined process for continuous improvement (CI).","○ - Activity is data-driven by company metrics and goals with a cross-functional approach to problem solving using a defined process for CI.","○ - Teams are trained in use of CI tools and are making progress.\n○ - Improvement efforts include administrative processes.\n○ - Emphasis is shifting from reactive to proactive focus.\n○ - Lessons Learned and improvement goals are established.","○ - Company organization is trained and is using appropriate CI tools, including advanced techniques (e.g. Six Sigma and benchmarking).",null,null,null,null,null,null,0,null,0]
[4.9000000000000004,"Internal Key Business Metrics","○ - No Internal metrics are developed (Top COPQ Causes, Top Missed Delivery Causes, internal scrap, etc.).","○ - Internal metrics are developed, and being addressed with action plans.\n○ - Metrics are not posted.","○ - Internal business metrics are established, posted in plant and drill down to cell or department level.","○ - Action register and CI projects developed for top issues driven by leaders.","○ - Action register developed for top issues and driven by cross functional groups. ",null,null,null,null,null,null,0,null,0]
[4.0999999999999996,"Defect Detection","○ - Quality control performs inspection of product.","○ - Operator performs first piece or FA check. \n○ - Quality is responsible for product inspection and acceptance.","○ - Operator performs self-check and in-process inspection per Control Plan or In process inspection sheet.  \n○ - Quality performs first piece check at start-up\n○ - Quality performs final acceptance.","○ - Process control and inspection is driven by certified operators.\n○ - Mistake proofing techniques are identified through reject history and/or PFMEA RPN analysis. ","○ - Process control of key process parameters and product features include closed-loop controls and automation.",null,null,null,null,null,null,0,null,0]
[4.1100000000000003,"Customer Key Business Metrics","○ - No key business metrics are developed (Top COPQ Causes, Top Missed Delivery Causes, etc.)","○ - Key business metrics are developed, and being addressed with action plans.\n○ - Metrics are not posted.","○ - Key business metrics are established and posted in plant.\n○ - Corrective Action Plan is initiated.","○ - Quality and OTD metrics are posted with customer expectation and company goals highlighted.","○ - Quality and OTD metrics posted showing performance to plant and customer expectations.\n○ - RCCA maintained by production work cells.",null,null,null,null,null,null,0,null,0]
[4.12,"  Quality Performance\n- Internal PPM or equivalent\n(Last 6 months)","○ - Not measured or Defects are greater than or equal to 5,000 PPM.","○ - Defects are less than 4,000 PPM.","○ - Defects are less than 2,500 PPM.","○ - Defects are less than 1,000 PPM.","○ - Defects are less than 500 PPM.",null,null,null,null,null,null,0,null,0]
[4.13,"Quality Performance\nto Major customers\n(Last 12 months)","○ - Not tracked or Defects are greater than or equal to 5,000 PPM.","○ - Defects are less than 5,000 PPM.","○ - Defects are less than 3,000 PPM.","○ - Defects are less than 1,000 PPM.","○ - Defects are less than 500 PPM.",null,null,null,null,null,null,0,null,0]
[4.1399999999999997,"Process Control Training","○ - No basic process analysis tools trained","○ - Basic process analysis tools  (e.g. RCCA-8D, SPC, 5-WHY, A3, capability study) training completed by all process owners (ME, QE, Planners, Operators, etc.).\n\n","○ - Process analysis tools (e.g. FMEA) training completed by selected individuals.","○ - Advanced process analysis tools (e.g. DOE, FMEA) training has been completed by all process owners.","○ - Training for process analysis tools is updated regularly for all process owners.",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H20)","v":0},{"$f":"SUM(I7:I20)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N20,\"<=2\")","v":14},null,{"$f":"COUNTIF(P7:P20,\"<=2\")","v":14}]

{"sheet":"5.0 MfgCapImpPro","index":7,"n_rows":18,"n_cols":26,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,9,5,9],[0,3,0,4],[0,6,0,8],[1,3,1,4],[1,6,1,8],[2,1,2,3],[2,6,2,8],[0,1,0,2]]}
[null,null,null,"CONFIDENTIAL",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Section: ","Manufacturing Capability & Improvement Process",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ","Organizational Elements","> > > > > > > > > > Quality Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter comments / notes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[5.0999999999999996,"Manufacturing Engineering Support (New Production)","○ - New production hardware requests are generally not supported by Engineering","○ - Plans in place to provide engineering support for New Production.","○ - Adequate engineering staff to support New Production unless displaced by production priorities.","○ - Sufficient engineering staff to generally support new production hardware and production simultaneously.\n○ - Engineering support to develop processing/programs for new production.","○ - Demonstrated engineering staff to support short lead time new production hardware and production simultaneously.",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[5.2,"Manufacturing  Process  Streamlining and Standardization","○ - Production process not explicitly defined or mapped.","\n○ - Production processes are characterized through mapping\n○ - Routine processes are standardized.\n○ - Cycle time is actively managed.","○ - Focus on elimination of waste in manufacturing\n○ - Routine processes are standardized with methods developed for non-routine processes.","○ - Mistake proofing techniques and FMEA are utilized.\n○ - All processes and methodologies are standardized and documented.","○ - All processes, methodologies and supporting tools are standardized.\n○ - Efforts toward simplifying processes, reducing variation and mistake proofing are showing measurable improvements.",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[5.3,"Lean  Manufacturing ","○ - Batch & queue, push-type manufacturing approach/system with large lots and WIP buildup.\n○ - Typical lot size >6 months demand.","○ - Batch & queue manufacturing approach.\n○ - Parts and/or process families have been identified.\n○ - Manufacturing floor organized to simplify product flow and minimize part handling.\n○ - Typical lot size 3-6 months.","○ - Lot size reduction effort has been implemented.\n○ - Some flow cells are established.\n○ - Constraints have been identified and are being managed.\n○ - Typical lot size 1-2 months.","○ - Pull type manufacturing system initiated with production paced to TAKT time.\n○ - Standard WIP (Kanban) identified and in place.\n○ - Typical lot size 2-4 weeks.","○ - Full implementation of pull type system across all operations in one piece flow or segmented batches.\n○ - Response time is <2 weeks.\n○ - Focus on continuous improvement.",null,null,null,null,null,null,0,null,0]
[5.4,"Preventative Maintenance","○ - Maintenance is performed as needed.\n○ - System is reactive.","○ - Maintenance is performed as symptoms develop.","○ - Maintenance schedule exists.\n○ - Maintenance schedule covers all key equipment.\n○ - Activities are on-time to schedule.","○ - Preventative level is based on history and operator involvement.\n○ - Unplanned downtime is being measured with documented corrective action.","○ - Maintenance is at a predictive level and SPC driven.\n○ - Incapable processes or machines are targeted for improvement or replacement.",null,null,null,null,null,null,0,null,0]
[5.5,"Perishable Tooling Control","○ - Tooling requirements are identified on an as needed basis.","○ - Formal system for tooling requirements.\n○ - Requires manual oversight.","○ - Tooling requirements are integrated into manufacturing planning system and tooling standardization program exists.","○ - Ordering is based upon pull system that may be vendor managed and on-site at supplier (e.g. tool room or vending machines).","○ - Tooling requirements are fully integrated into design of product.",null,null,null,null,null,null,0,null,0]
[5.6,"Tool Life Management","○ - Supplier does not track tool life expectancy or have a tool life management process in place.","○ - Supplier does have limited knowledge of tool life management and is working towards putting a process in place.","○ - Supplier does have a tool life management process in place, but is limited to only their \"High Volume\" items. ","○ - Tool life expectancy is known for most tools within most programs and is controlled by the machine tool controllers based on statistical data.\n○ - Tooling cost for most items are understood.","○ - Tool life expectancy is know for all tools within all programs and is controlled by the machine tool controllers based on statistical data.\n○ - Operators are prompted by the controllers to change tooling as necessary.\n○ - Tooling cost for all items are understood.",null,null,null,null,null,null,0,null,0]
[5.7,"Risk Mitigation","○ - No backup plan for individual machines, so you can keep from missing a customer shipment\n","○ - Undocumented plan for how the process will continue to run in the event of an individual machine failure.","○ - Basic documented plan for how the process will continue to run in the event of an individual machine failure.","○ - There is a documented plan for how the process will continue to run in the event of an individual machine failure.\n○ - The documented plan addresses the process to avoid shutting down a customer's line.                                          ○ - A Disaster Recovery Plan is in place.","○ - An emergency plan is documented that covers meeting customer requirements in the event of a facility-wide emergency (e.g., power failure, facility damage, acts of God, etc.).\n○ - A Disaster Recovery Plan is in place and covers the entire supply chain.                      ",null,null,null,null,null,null,0,null,0]
[5.8,"Housekeeping or 5s+1 (6S)\n(Sorting, Storage, Shining, Standardizing and Sustaining, Safety)","○ - No housekeeping program","○ - Basic general housekeeping.\n○ - No housekeeping audits are conducted.","○ - Good housekeeping, areas well organized.","○ - 5S+1 (6S) Assessment program initiated.\n○ - Fundamentals of organization and housekeeping are practiced and assessed.","○ - Active 5S+1 (6S) program for improvement in place and \"institutionalized\".",null,null,null,null,null,null,0,null,0]
[5.9,"Control of time-sensitive parts or material \n","○ - No time sensitive material(s) management in use","○ - Minimal tracking of time sensitive materials","○ - Evidence time sensitive material is manually tracked and recorded.","○ - Automated system for tracking time-sensitive material with evidence that all material on site is within expiration","○ - Automated control system in use, from incoming to automated alerts for expiration to evidence that expired material is purged from the system.  ",null,null,null,null,null,null,0,null,0]
[5.0999999999999996,"Part Handling and Packaging","○ - Care is taken in handling and protection for work in process, during storage and shipping, but no procedures are in place.","○ -All parts are packaged according to Special Handling Codes shown on the drawing or PO.  This includes all material from incoming parts/raw material through parts shipping to the customer.","○ - Procedures are in place to eliminate damage, contamination and oxidation.\n○ - Procedures cover in-process, storage and shipping.","○ - Work station audits are being conducted to assure handling, protection and packaging procedures are followed.","○ - Defined process planning addresses protection, handling and packaging and prevents damage through all levels of processing including storage and shipment.\n○ - System incorporates customer requirements.",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H17)","v":0},{"$f":"SUM(I7:I16)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N16,\"<=2\")","v":10},null,{"$f":"COUNTIF(P7:P16,\"<=2\")","v":10}]

{"sheet":"6.0 SupplyChainMgmt","index":8,"n_rows":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,9,5,9],[0,3,0,4],[0,6,0,8],[1,3,1,4],[1,6,1,8],[2,6,2,8],[2,1,2,3],[0,1,0,2]]}
[null,null,null,"CONFIDENTIAL",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Section: ","Supply Chain Mgmt",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ","Organizational Elements","> > > > > > > > > > Quality Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter comments / notes ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[6.1,"Sourcing Decisions\n(excluding customer directed sources)","○ - Orders based on quotes.","○ - Quality, delivery and lead time considered when making sourcing decisions.\n","○ - Preferred suppliers identified (ASL) and utilized on a selective basis\n○ - Suppliers are ISO-9001 compliant\n","○ - Quality, delivery and lead time performance as important as price in sourcing decisions (best value).\n○ - Suppliers on ASL receive first opportunity for business.\n","○ - Preferred sub-tiers selected and utilized on >80% of non customer directed sourced parts.\n○ - Supplier Quality, Delivery, and Price data collected and analyzed; Sourcing based on best value analysis.\n",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[6.2,"Sub-tier Quality Performance\n(Last 6 months)","○ - Not tracked or Defects are greater than 5,000 PPM.","○ - Defects are between 4,000 PPM.","○ - Defects are less than 2,500 PPM.","○ - Defects are less than 1,000 PPM.","○ - Defects are 500 PPM.",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[6.3,"Product Acceptance","○ - No or minimal inspection upon receipt.\n○ - Acceptance based mainly on certification review.","○ - Purchase product is inspected to drawing requirements.\n○ - Actual dimensional results are not recorded.","○ - Purchase product is inspected to documented inspection plans.\n○ - Actual dimensional results are recorded.","○ - Purchase product is inspected to documented inspection plans.  \n○ - Actual dimensional results are recorded.\n○ - Sampling is based on process capability results.","○ - Product accepted based on data demonstrating capability.\n",null,null,null,null,null,null,0,null,0]
[6.4,"Process Control \nSub-tier","○ - No evaluation of supplier process control.","○ - Suppliers are selected with no on site evaluation.\n○ - Over-inspection is employed at supplier.\n○ - Special process suppliers selected with no on site evaluation of capability.","○ - Supplier process control is evaluated by on site reviews.\n○ - Supplier Customer metrics (PPM/OTD) used to evaluate risk.\n○ - Some control of special process suppliers through on site review and audits","○ - Supplier process controlled through quality planning requirements (e.g. Control Plan, FMEA, SPC, FAI/PPAP).\n○ - All Special Process meet the definition as shown in ISO-9001.","○ - Early Supplier Involvement (ESI).\n○ - Supplier audit Process and documentation of audits conducted across the supply base to the supplier (Tier 2 to Creation).",null,null,null,null,null,null,0,null,0]
[6.5,"Flow Down Requirements\nand Communications","○ - Minimal information flowed down to suppliers via purchase order.\n○ - No formalized process to ensure complete requirements flow down (e.g. evidence of verbal orders).","○ - A formal process exists that ensures all documents, specifications, and cleanliness requirements needed to supply the product or services are provided at the time of the purchase order.\n○ - The requirements provided were the current revision status at the time of PO issue.\n○ - Creation NDA flow down to sub-tier suppliers","○ - Procedures are in place to define revision change responsibilities when changed by the customer and supports flow down of revised requirements to suppliers.\n○ - Cases can be shown for ITAR and DFAR compliance.","○ - Documents, specifications, and cleanliness requirements are provided to and accessible to suppliers.\n○ - Automatic notification of revision changes.","○ - Documents, specifications, and requirements are available on-line and accessible by suppliers.\n○ - Automatic notification of revision changes.\n○ - System in place for order acknowledgement.",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H11)","v":0},{"$f":"SUM(I7:I11)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N11,\"<=2\")","v":5},null,{"$f":"COUNTIF(P7:P11,\"<=2\")","v":5}]

{"sheet":"7.0 PPAP","index":9,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,8],[4,9,5,9],[0,3,0,4],[0,6,0,8],[1,3,1,4],[1,6,1,8]]}
[null,null,null,"CONFIDENTIAL",null,"Quality Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"}]
[null,null,null,null,null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"}]
["Section: ","PPAP Development & Deployment",null,null,null,"Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"}]
[]
[" ","Organizational Elements","> > > > > > > > > > Maturity Path > > > > > > > > > >",null,null,null,"Premier Supplier Level","Supplier","Creation","Quality Audit Notes:\nEnter comments / notes "]
["Item","and Behaviors",1,2,3,4,5," Rating"," Rating"]
[7.1,"FAI/PPAP\n (First Article Inspection)               (Production Part Approval Process)\n- Understanding","○ - Supplier is unfamiliar with the FAI/PPAP documentation and process.\n○ - FAIs/PPAPs have never been processed or created at the supplier.","○ - General understanding of AIAG FAI/PPAP and elements by limited personnel.\n○ - Some elements of FAI/PPAP being used.","○ - Adequately trained staff to support FAI/PPAP documentation and associated quality planning activities.\n○ - FAIs/PPAPs have been performed for other customers. ○ - General FAI/PPAP requirements are understood.","○ - Sufficiently trained and \"experienced\" engineering and quality staff to support FAI/PPAP  and associated quality planning activities.","○ - Demonstrated \"experienced\" engineering and quality staff to support short lead time FAIs/PPAPs.\n○ - FAI/PPAP is an \"institutionalized\" part of supplier process.",null,null,null,null,null,null,{"$f":"H7","v":0},null,{"$f":"I7","v":0}]
[7.2,"FAI/PPAP                                                 (First Article Inspection)\n (Production Part Approval Process)\n-Deployment / Maintenance","○ - Supplier does not use FAI/PPAP elements as a tool to control production processes.\n○ - Supplier does not have a FAI/PPAP process/procedure","○ - Evidence of FAI/PPAP elements being used to control production processes.\n○ - FAI/PPAP elements not current to existing process.","○ - Procedures in place to drive ongoing update and retention of FAI/PPAP elements.\n○ - Element ownership is clearly documented and understood.\n○ - FAIs/PPAP's are updated based on new part introduction, process change, corrective action, lapse in production.","○ - Most FAI/PPAP records are current and relevant to the existing process.\n○ - FAI/PPAP is deployed for all portions of the supplier's business.\n (i.e. FDA/Aero/Auto/Industrial)","○ - All FAIs/PPAP's are current to the existing process.\n○ - Supplier has FAI/PPAP continuous improvement review",null,null,null,null,null,null,{"$f":"H8","v":0},null,{"$f":"I8","v":0}]
[7.3,"APQP                                              (Advanced Product Quality Planning)","○ - Supplier is unfamiliar with the APQP process.\n","○ - General understanding of APQP and elements by limited personnel.\n○ - Some elements of APQP being used.","○ - Adequate trained staff to support APQP process and documentation.\n○ - APQP has been utilized for other customers. General APQP requirements are understood.","○ - Adequate trained and \"experienced\" engineering and quality staff to support APQP activities.","○ - Demonstrated \"experienced\" engineering and quality staff to support short lead time APQP.\n○ - APQP is an \"institutionalized\" part of supplier process.",null,null,null,null,null,null,0,null,0]
[7.4,"Design Record / Balloon Drawing","○ - No experience","○ - Some drawings ballooned to support only quality inspectors.","○ - Ballooned drawings available to production inspectors.\n","○ - Ballooned drawings available to all people performing inspections.\n○ - Ballooned drawings exist for all unique manufacturing processes. (i.e. Operational drawings, sub-assy)","○ - All applicable specifications ballooned and being used as a tool during inspection.",null,null,null,null,null,null,0,null,0]
[7.5,"Material Certification Results","○ - Material certifications are not reviewed against drawing/Industry standard requirements.","○ - Standard practice to retain & submit material certifications to customer.\n○ - Material certifications are reviewed against customer requirements and industry standard.","○ - Material certifications contain all required information. (i.e. Item, specification, spec rev, date of testing, act.)","○ -  Material certifications are available for all material and special processes.\n○ - File management system exist for certifications.","○ - Supplier fully meets all communicated Creation and customer requirements.",null,null,null,null,null,null,0,null,0]
[7.6,"Performance Test Results","○ - No experience with filling out or submitting to customers","○ - Standard practice to retain & submit material performance records to customer.\n○ - Performance test results maintained.","○ - Performance results contain all required information. (i.e. Item, test specification,  date of testing, Qty tested, results, act.)","○ - Performance certifications are available for items as applicable.","○ -  Supplier fully meets all communicated Creation and customer requirements.",null,null,null,null,null,null,0,null,0]
[7.7,"Process Capability Studies\n- Understanding","○ - Supplier is unfamiliar with process capability Cpk/Ppk..","○ - General understanding of process capability by limited personnel.\n○ - Process control, including SPC, as appropriate, is only customer driven.","○ - Adequate trained staff to support process capability.\n○ - Trained staff understand the inner workings of process variation and how to reduce variation.","○ - Sufficient trained and \"experienced\" engineering and quality staff to support process capability activities.","○ - Process capability is an \"institutionalized\" part of supplier development and on-going process improvement methodology.",null,null,null,null,null,null,0,null,0]
[7.8,"Process Capability\n-Data Collection and Analysis","○ - Sampling inspection used without objective evidence of process capability.\n○ - Process Performance data and variable measurements are recorded.","○ - Sampling inspection used with objective evidence of process capability for only keys.\n○ - Process Performance data is analyzed by supervisors and management.\n○ - Feedback is provided to operators.","○ - Process Performance data is utilized by operators in real time.\n○ - Simple analysis performed (e.g. pre-control charts, X bar and R charts).\n○ - Capability studies are performed by other engineering staff.","○ - Process capability data is known and used in process development and control plan creation. \n○ - Performance data utilized by operators in real time for fact based decisions.  \n○ - Supplier will use Creation FAI form for submission.","○ - Documented evidence of performance analysis is driven throughout organization for continuous improvement.",null,null,null,null,null,null,0,null,0]
[7.9,"Measurement System Analysis\n(MSA/Gage R&R)\n- Understanding","○ - No experience","○ - General understanding of MSA/Gage R&R by limited personnel.\n○ - MSA/Gage R&R only deployed if customer driven.","○ - Strong understanding of MSA/Gage R&R by limited personnel.\n○ - MSA/Gage R&R deployed for key products.","○ - Sufficient trained and \"experienced\" engineering and quality staff to support MSA activities.","○ - MSA is an \"institutionalized\" part of supplier process.",null,null,null,null,null,null,0,null,0]
[7.1,"Process Flow","○ - No experience","○ - Only routers/travelers used for standard flows\n○ - Process Flows are understood but not utilized","○ - Developed for each manufacturing process. (i.e. Receiving through shipping)\n○ - Examples can be shown","○ - Process Flow matches production process.\n○ - Process flow matches flow of control plan and PFMEA.","○ - Currently provides Process Flow's to other customers.\n○ - Process Flow Diagrams are utilized to make improvements.",null,null,null,null,null,null,0,null,0]
[7.11,"Process Control Plan\n-Understanding","○ - No experience","○ - Some personnel have understanding of creation and approach.","○ - Solid knowledge of how to create and maintain.","○ - Formal Training deployed for key personnel.","○ - Training includes all engineering and manufacturing personnel. (FAI/PPAP Team)",null,null,null,null,null,null,0,null,0]
[7.12,"Process Control Plan\n-Utilization","○ - No clear way to monitor each feature from the drawing\n○ - Only using in-process inspection methods as a way of control","○ - In process inspection plans include all dimensional requirements when compared to drawing.\n○ - In-process inspection plans include measurement frequency, gage type & reaction plans for out of tolerance findings. ","○ - Some control plans exist.\n○ - All balloon drawing identified features are shown on the control plan.\n○ - All keys are clearly identified and addressed in the control plan.","○ - All flow downs (including to sub-tiers) are clearly identified and addressed in the control plan. (i.e. Features, specs, testing)\n○ - Keys clearly show a method for maintaining process capability or control is shown.\n○ - Sampling plan justification can be backed up by process capability data for every feature.\n○ - Control plan matches flow of Process Flow and PFMEA.","○ - All additional PO requirements are shown on the control plan by at least one control step\n",null,null,null,null,null,null,0,null,0]
[7.13,"PFMEA\n(Process Failure Mode & Effects Analysis)\n-Understand and Control","○ - No experience","○ - PFMEA's deployed for some key manufacturing processes.","○ - Developed for each manufacturing process.\n○ - PFMEA's are current and match manufacturing process.\n○ - Cross functional team used to develop PFMEA. (Quality, Engineering, Planners, act.)","○ - PFMEA's match flow of Process Flow and PFMEA.\n○ - Include historical escapes to customers.\n○ - Top RPN's show actions being worked to reduce.","○ - Currently provides PFMEA's to other customers\n○ - PFMEA's show evidence of updates based on internal performance issue's",null,null,null,null,null,null,0,null,0]
[7.14,"Measurement System Analysis\n(MSA/Gage R&R)\n- Control","○ - No written procedure requiring periodic MSA (Gage R&R) verification of all gage types.","○ - Written procedure defining gage type and verification frequency exist for MSA (Gage R&R) for all gage types.","○ - Records indicate MSAs are completed as prescribed by the written procedure.\n○ - Actual results are maintained.","○ - MSAs are completed for each key/critical feature from control plan/drawing/inspection record.\n○ - Procedures require all Gages/Equipment for all Key/Critical features are to have acceptable MSA. ","○ - Records indicate MSAs are completed as prescribed by the written procedure.\n○ - Automatic notification of MSAs that are due for update.(maintained in calibration system or something comparable)",null,null,null,null,null,null,0,null,0]
[]
[null,null,null,null,null,null,"Section Score",{"$f":"SUM(H7:H20)","v":0},{"$f":"SUM(I7:I20)","v":0},null,null,null,null,{"$f":"COUNTIF(N7:N20,\"<=2\")","v":14},null,{"$f":"COUNTIF(P7:P20,\"<=2\")","v":14}]

{"sheet":"Summary","index":10,"n_rows":40,"n_cols":33,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,2,3,7],[7,2,7,7],[13,1,13,2],[12,1,12,2],[11,1,11,2],[5,2,5,7],[11,10,11,13],[10,1,10,2],[10,10,10,13],[9,1,9,2],[9,10,9,13],[20,1,20,2],[17,3,18,3],[14,10,14,13],[13,10,13,13],[12,10,12,13],[14,1,14,2],[0,7,0,8],[32,4,32,6],[32,7,32,9],[37,2,37,12],[15,1,15,2],[15,10,15,13],[33,1,33,2],[34,1,34,2],[33,10,33,13],[34,10,34,13],[18,7,21,10],[21,1,21,2],[17,1,17,2],[17,4,18,4],[18,1,18,2],[19,1,19,2]]}
[null,null,null,null,null,null,null,"CONFIDENTIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< Select >"]
[null,"Audit Date:",{"$f":"'Cover Sheet'!G10","v":"<Enter audit date>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unacceptable System [ Do Not Use ]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Risk - [ Immediate Corrective Action or Exit Plan]"]
[null,"Supplier Name:",{"$f":"'Cover Sheet'!C5","v":"<Enter Supplier>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System Meets Minimum Level [Use with Appropriate Development]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced System - Consider Preferred Supplier Relationship"]
[null,"Creation Assigned Supplier #:",{"$f":"'Cover Sheet'!C10","v":"<Enter supplier #>"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Highly Mature System - Consider Partner Relationship"]
[]
["Sec.","Section Title",null,"# of Elements","Supplier Section Score","Supplier Section Average","Supplier N/A","Creation Section Score","Creation Section Average","Creation      N/A\n(validated)","Section Notes",null,null,null,null,"Supplier Risk - # of Elements",null,"Creation Risk - # of Elements"]
[2,{"$f":"'2.0 MgmtSysPln'!B3:D3","v":"Management Systems and Planning"},null,{"$f":"COUNT('2.0 MgmtSysPln'!$A$7:$A$14)","v":8},{"$f":"'2.0 MgmtSysPln'!$H$16","v":0},{"$f":"E11/((COUNT('2.0 MgmtSysPln'!$A$7:$A$14)-COUNTIF('2.0 MgmtSysPln'!$H$7:$H$14,\"N/A\")))","v":0},{"$f":"COUNTIF('2.0 MgmtSysPln'!$H$7:$H$14,\"N/A\")","v":0},{"$f":"'2.0 MgmtSysPln'!$I$16","v":0},{"$f":"H11/((COUNT('2.0 MgmtSysPln'!$A$7:$A$14))-COUNTIF('2.0 MgmtSysPln'!$I$7:$I$14,\"N/A\"))","v":0},{"$f":"COUNTIF('2.0 MgmtSysPln'!I7:I14,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'2.0 MgmtSysPln'!N16","v":8},null,{"$f":"'2.0 MgmtSysPln'!P16","v":8},null,"Sections","Elements",null,null,null,null,null,null,null,null,null,null,null,"Minimum Thresholds met; Development activity per Supply Team guidance."]
[3,{"$f":"'3.0 QualSystems'!B3:D3","v":"Quality Systems"},null,{"$f":"COUNT('3.0 QualSystems'!$A$7:$A$17)","v":11},{"$f":"'3.0 QualSystems'!$H$19","v":0},{"$f":"E12/((COUNT('3.0 QualSystems'!$A$7:$A$17)-COUNTIF('3.0 QualSystems'!$H$7:$H$17,\"N/A\")))","v":0},{"$f":"COUNTIF('3.0 QualSystems'!$H$7:$H$17,\"N/A\")","v":0},{"$f":"'3.0 QualSystems'!$I$19","v":0},{"$f":"H12/((COUNT('3.0 QualSystems'!$A$7:$A$17))-COUNTIF('3.0 QualSystems'!$I$7:$I$17,\"N/A\"))","v":0},{"$f":"COUNTIF('3.0 QualSystems'!I7:I17,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'3.0 QualSystems'!N19","v":11},null,{"$f":"'3.0 QualSystems'!P19","v":11},null,"2,4",{"$f":"COUNT(#REF!,#REF!,'2.0 MgmtSysPln'!$A$7:$A$14,#REF!,'4.0 ProcessQualityMgmt'!$A$7:$A$20)","v":22},null,null,null,null,null,null,null,null,null,null,null,"Minimum Thresholds NOT met; Development Plan with actions assigned to close Element Gaps is required."]
[4,{"$f":"'4.0 ProcessQualityMgmt'!B3:C3","v":"Process Quality Management"},null,{"$f":"COUNT('4.0 ProcessQualityMgmt'!$A$7:$A$20)","v":14},{"$f":"'4.0 ProcessQualityMgmt'!$H$22","v":0},{"$f":"E13/((COUNT('4.0 ProcessQualityMgmt'!$A$7:$A$20)-COUNTIF('4.0 ProcessQualityMgmt'!$H$7:$H$20,\"N/A\")))","v":0},{"$f":"COUNTIF('4.0 ProcessQualityMgmt'!$H$7:$H$20,\"N/A\")","v":0},{"$f":"'4.0 ProcessQualityMgmt'!$I$22","v":0},{"$f":"H13/((COUNT('4.0 ProcessQualityMgmt'!$A$7:$A$20))-COUNTIF('4.0 ProcessQualityMgmt'!$I$7:$I$20,\"N/A\"))","v":0},{"$f":"COUNTIF('4.0 ProcessQualityMgmt'!I7:I20,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'4.0 ProcessQualityMgmt'!N22","v":14},null,{"$f":"'4.0 ProcessQualityMgmt'!P22","v":14},null,"3,5,6,7",{"$f":"COUNT('5.0 MfgCapImpPro'!$A$7:$A$16,'6.0 SupplyChainMgmt'!$A$7:$A$11,#REF!,'3.0 QualSystems'!$A$7:$A$17,#REF!,'7.0 PPAP'!$A$7:$A$19,#REF!)","v":39}]
[5,{"$f":" '5.0 MfgCapImpPro'!B3:C3","v":"Manufacturing Capability & Improvement Process"},null,{"$f":"COUNT('5.0 MfgCapImpPro'!$A$7:$A$16)","v":10},{"$f":"'5.0 MfgCapImpPro'!$H$18","v":0},{"$f":"E14/((COUNT('5.0 MfgCapImpPro'!$A$7:$A$18)-COUNTIF('5.0 MfgCapImpPro'!$H$7:$H$18,\"N/A\")))","v":0},{"$f":"COUNTIF('5.0 MfgCapImpPro'!$H$7:$H$16,\"N/A\")","v":0},{"$f":"'5.0 MfgCapImpPro'!$I$18","v":0},{"$f":"H14/((COUNT('5.0 MfgCapImpPro'!$A$7:$A$16))-COUNTIF('5.0 MfgCapImpPro'!$I$7:$I$16,\"N/A\"))","v":0},{"$f":"COUNTIF('5.0 MfgCapImpPro'!I7:I16,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'5.0 MfgCapImpPro'!N18","v":10},null,{"$f":"'5.0 MfgCapImpPro'!P18","v":10},null,"Total",{"$f":"SUM($U$12:$U$13)","v":61},null,null,null,null,null,null,null,null,null,null,null,"Minimum Thresholds met; No development activity required at this time."]
[6,{"$f":"'6.0 SupplyChainMgmt'!B3:D3","v":"Supply Chain Mgmt"},null,{"$f":"COUNT('6.0 SupplyChainMgmt'!$A$7:$A$11)","v":5},{"$f":"'6.0 SupplyChainMgmt'!$H$13","v":0},{"$f":"E15/((COUNT('6.0 SupplyChainMgmt'!$A$7:$A$11)-COUNTIF('6.0 SupplyChainMgmt'!$H$7:$H$11,\"N/A\")))","v":0},{"$f":"COUNTIF('6.0 SupplyChainMgmt'!$H$7:$H$11,\"N/A\")","v":0},{"$f":"'6.0 SupplyChainMgmt'!$I$13","v":0},{"$f":"H15/((COUNT('6.0 SupplyChainMgmt'!$A$7:$A$11))-COUNTIF('6.0 SupplyChainMgmt'!$I$7:$I$11,\"N/A\"))","v":0},{"$f":"COUNTIF('6.0 SupplyChainMgmt'!I7:I11,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'6.0 SupplyChainMgmt'!N13","v":5},null,{"$f":"'6.0 SupplyChainMgmt'!P13","v":5}]
[7,{"$f":"'7.0 PPAP'!B3:D3","v":"PPAP Development & Deployment"},null,{"$f":"COUNT('7.0 PPAP'!$A$7:$A$20)","v":14},{"$f":"'7.0 PPAP'!$H$22","v":0},{"$f":"E16/((COUNT('7.0 PPAP'!$A$7:$A$19)-COUNTIF('7.0 PPAP'!$H$7:$H$19,\"N/A\")))","v":0},{"$f":"COUNTIF('7.0 PPAP'!$H$7:$H$19,\"N/A\")","v":0},{"$f":"'7.0 PPAP'!$I$22","v":0},{"$f":"H16/((COUNT('7.0 PPAP'!$A$7:$A$19))-COUNTIF('7.0 PPAP'!$I$7:$I$19,\"N/A\"))","v":0},{"$f":"COUNTIF('7.0 PPAP'!I7:I19,\"N/A\")","v":0},null,null,null,null,null,{"$f":"'7.0 PPAP'!N22","v":14},null,{"$f":"'7.0 PPAP'!P22","v":14},null,"Applicable","Elements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Creation",{"$f":"$U$14-(SUM($J$11:$J$16))","v":61}]
[null,null,null,"Creation Scoring","Supplier Scoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier",{"$f":"$U$14-(SUM($G$11:$G$16))","v":61}]
[null,"Audit Results -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H$19=\"* Critical element 3.12 - Ethics Compliance Program requirements NOT met.  This issue MUST be resolved with the supplier in order to achieve gap closure.  Supplier approval ON-HOLD pending resolution.\",1,\"\")","v":""}]
[null,"Overall Total Score:",null,{"$f":"IF(SUM($H$11:$H$16)=0,\"TBD\",SUM($H$11:$H$16))","v":"TBD"},{"$f":"IF(SUM($E$11:$E$16)=0,\"TBD\",SUM($E$11:$E$16))","v":"TBD"}]
[null,"Total Average Score:",null,{"$f":"IF($D$20=\"TBD\",\"---\",$D$20/$U$17)","v":"---"},{"$f":"IF($E$20=\"TBD\",\"---\",$E$20/$U$18)","v":"---"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Supplier Score",null,null,"Creation Score"]
["Sec.","Section Title",null,"# of Elements","Yes","NO","N/A","Yes","NO","N/A","Section Notes"]
[1,{"$f":"'1.0 Auditchecklist '!B3:C3","v":"Audit Check List (Yes and No)"},null,20,{"$f":"'1.0 Auditchecklist '!$E$36","v":0},{"$f":"'1.0 Auditchecklist '!$E$37","v":0},{"$f":"'1.0 Auditchecklist '!$E$38","v":0},{"$f":"'1.0 Auditchecklist '!$F$36","v":0},{"$f":"'1.0 Auditchecklist '!$F$37","v":0},{"$f":"'1.0 Auditchecklist '!$F$38","v":0}]
[]
[]
[]
[]
["COMMENTS"]

{"sheet":"History Of Changes","index":11,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,4,24,5],[0,0,2,0],[0,1,0,5],[1,1,2,2],[1,3,1,5],[2,3,2,5],[23,4,23,5]]}
[null,"CREATION TECHNOLOGIES – Standard Form"]
[null,"Supplier Requalification Audit",null,"Document #C-0003005",null,null,"CONFIDENTIAL"]
[null,null,null,"Rev 0"]
[]
[]
[]
[null,"APPROVALS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HISTORY OF CHANGES"]
[]
["Revision","Author / Revised by","Details of the Changes, Section Number changed and Summary of the Changes","Reason for the Change","Effective Date \n(YYYY-MM-DD) "]
[0,"John Gaspari","Initial release of the document into DocBank.","Initial release","2021-04-21"]