{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover Sheet","Audit","Summary","Tooling Audit Form Sec1","Tooling Audit Form Sec2","Dock Audit","SQE Action Plan Form","Revision History","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":19,"comments":4,"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":"Cover Sheet","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,1,64,2],[64,5,64,7],[62,5,62,7],[62,1,62,2],[21,2,21,4],[23,2,23,4],[50,1,50,3],[49,1,49,3],[32,1,32,9],[34,1,34,3],[34,8,34,9],[37,1,37,3],[35,1,35,3],[42,1,42,3],[43,1,43,3],[45,1,45,3],[41,1,41,3],[46,1,46,3],[47,1,47,3],[59,2,59,7],[50,4,50,5],[49,7,50,9],[48,1,48,3],[58,9,60,9],[44,1,44,3],[29,5,29,7],[0,2,1,8],[6,2,6,4],[16,2,16,4],[18,2,18,4],[6,6,6,7],[8,6,8,7],[21,6,21,7],[23,6,23,7],[8,2,8,4],[38,1,38,3],[39,1,39,3],[40,1,40,3],[36,1,36,3],[11,2,11,4],[13,2,13,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"1K/2K Series"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3K/4K Series"]
[null,null,"PROCESS CONTROL PLAN AUDIT (AT-1927-16)",null,null,null,null,null,null,null,null,null,"5K/6K Series"]
[null,null,null,null,null,null,null,null,null,null,null,null,"8K/9K Series"]
[null,null,null,null,null,null,null,null,null,null,null,null,"EP 40/50 Series"]
[null,"SUPPLIER NAME",null,null,null,null,"SUPPLIER PHONE",null,null,null,null,null,"H3000 (Archive)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TC10 (Obsolete)"]
[null,"ATI VENDOR NO",null,null,null,null,"SUPPLIER LOCATION",null,null,null,null,null,"X200/X1100"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CST"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FracTran"]
[null,"AUDITOR 1",null,null,null,null,null,"AUDITOR PHONE",null,null,null,null,"3040MX"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VAS"]
[null,"AUDITOR EMAIL",null,null,null,null,null,"AUDIT DATE",null,null,null,null,"100/130 S/D"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other (specify below)"]
[null,"AUDITOR 2",null,null,null,null,null,"AUDITOR PHONE"]
[]
[null,"AUDITOR EMAIL",null,null,null,null,null,"AUDIT DATE"]
[]
[]
[null,"PART NUMBER(S)",null,null,null,null,"PART NAME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"d"]
[null,"ENG CHG LEVEL",null,null,null,null,"PRODUCT LINE"]
[]
[]
[null,"TYPE OF AUDIT","  (check one)",null,null,"(check one)"]
[]
[]
[null,"STATUS",null,null,null,{"$f":"IF(G51=\"G\",\"NO FOLLOW-UP DATE REQUIRED\",IF(G51=\"R\",\"PLEASE PROVIDE FOLLOW-UP DATE\",IF(G51=\"Y\",\"NO FOLLOW-UP DATE REQUIRED\",IF(G51=\"NR/NA\",\"FOLLOW-UP DATE\"))))","v":"PLEASE PROVIDE FOLLOW-UP DATE"},{"$f":"IF(E51=\"G\", \"NO FOLLOW-UP DATE REQUIRED\",\"PLEASE PROVIDE FOLLOW-UP DATE\")","v":"PLEASE PROVIDE FOLLOW-UP DATE"},{"$f":"IF(F51=\"G\", \"NO FOLLOW-UP DATE REQUIRED\",\"PLEASE PROVIDE FOLLOW-UP DATE\")","v":"PLEASE PROVIDE FOLLOW-UP DATE"}]
[]
[]
[null,"AUDIT SUMMARY"]
[]
[null,"ELEMENTS",null,null,"POTENTIAL SCORE","AUDIT SCORE","%","STATUS","(Auditor) Red Status Requires Corrective Action & Re-Audit Within 6 Months"]
[null,"TECHNICAL INFORMATION",null,null,{"$f":"IF(G36=\"NR/NA\",\"NR/NA\",Audit!F9)","v":16},{"$f":"(Audit!E9)","v":10},{"$f":"IF(Audit!E9=\"NR/NA\",\"NR/NA\",Audit!E9/Audit!F9)","v":0.625},{"$f":"IF(MIN(Audit!J5:J8)=5,\"NR/NA\",IF(MIN(Audit!J5:J8)=4,\"G\",IF(MIN(Audit!J5:J8)=3,\"Y\",IF(MIN(Audit!J5:J8)=2,\"R\",IF(MIN(Audit!J5:J8)=1,\"R\",IF(MIN(Audit!J5:J8)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C9","v":2},{"$f":"IF(H36=\"NR/NA\",4,IF(H36=\"G\",3,IF(H36=\"Y\",2,IF(H36=\"R\",1))))","v":1}]
[null,"CHANGE CONTROL",null,null,{"$f":"IF(G37=\"NR/NA\",\"NR/NA\",Audit!F15)","v":16},{"$f":"(Audit!E15)","v":10},{"$f":"IF(Audit!E15=\"NR/NA\",\"NR/NA\",Audit!E15/Audit!F15)","v":0.625},{"$f":"IF(MIN(Audit!J11:J14)=5,\"NR/NA\",IF(MIN(Audit!J11:J14)=4,\"G\",IF(MIN(Audit!J11:J14)=3,\"Y\",IF(MIN(Audit!J11:J14)=2,\"R\",IF(MIN(Audit!J11:J14)=1,\"R\",IF(MIN(Audit!J11:J14)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C15","v":2},{"$f":"IF(H37=\"NR/NA\",4,IF(H37=\"G\",3,IF(H37=\"Y\",2,IF(H37=\"R\",1))))","v":1}]
[null,"PROCESS FLOW DIAGRAM",null,null,{"$f":"IF(G38=\"NR/NA\",\"NR/NA\",Audit!F23)","v":24},{"$f":"(Audit!E23)","v":13},{"$f":"IF(Audit!E23=\"NR/NA\",\"NR/NA\",Audit!E23/Audit!F23)","v":0.54166666666666663},{"$f":"IF(MIN(Audit!J17:J22)=5,\"NR/NA\",IF(MIN(Audit!J17:J22)=4,\"G\",IF(MIN(Audit!J17:J22)=3,\"Y\",IF(MIN(Audit!J17:J22)=2,\"R\",IF(MIN(Audit!J17:J22)=1,\"R\",IF(MIN(Audit!J17:J22)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C23","v":4},1]
[null,"PFMEA / PCP",null,null,{"$f":"IF(G39=\"NR/NA\",\"NR/NA\",Audit!F36)","v":44},{"$f":"(Audit!E36)","v":26},{"$f":"IF(Audit!E36=\"NR/NA\",\"NR/NA\",Audit!E36/Audit!F36)","v":0.59090909090909094},{"$f":"IF(MIN(Audit!J25:J35)=5,\"NR/NA\",IF(MIN(Audit!J25:J35)=4,\"G\",IF(MIN(Audit!J25:J35)=3,\"Y\",IF(MIN(Audit!J25:J35)=2,\"R\",IF(MIN(Audit!J25:J35)=1,\"R\",IF(MIN(Audit!J25:J35)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C36","v":6},1]
[null,"STANDARDIZED  OPERATIONS & TRAINING",null,null,{"$f":"IF(G40=\"NR/NA\",\"NR/NA\",Audit!F45)","v":28},{"$f":"(Audit!E45)","v":16},{"$f":"IF(Audit!E45=\"NR/NA\",\"NR/NA\",Audit!E45/Audit!F45)","v":0.5714285714285714},{"$f":"IF(MIN(Audit!J38:J44)=5,\"NR/NA\",IF(MIN(Audit!J38:J44)=4,\"G\",IF(MIN(Audit!J38:J44)=3,\"Y\",IF(MIN(Audit!J38:J44)=2,\"R\",IF(MIN(Audit!J38:J44)=1,\"R\",IF(MIN(Audit!J38:J44)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C45","v":4},1]
[null,"GAGING",null,null,{"$f":"IF(G41=\"NR/NA\",\"NR/NA\",Audit!F56)","v":36},{"$f":"(Audit!E56)","v":21},{"$f":"IF(Audit!E56=\"NR/NA\",\"NR/NA\",Audit!E56/Audit!F56)","v":0.58333333333333337},{"$f":"IF(MIN(Audit!J47:J55)=5,\"NR/NA\",IF(MIN(Audit!J47:J55)=4,\"G\",IF(MIN(Audit!J47:J55)=3,\"Y\",IF(MIN(Audit!J47:J55)=2,\"R\",IF(MIN(Audit!J47:J55)=1,\"R\",IF(MIN(Audit!J47:J55)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C56","v":5},1]
[null,"PROCESS CONTROLS",null,null,{"$f":"IF(G42=\"NR/NA\",\"NR/NA\",Audit!F69)","v":44},{"$f":"(Audit!E69)","v":26},{"$f":"IF(Audit!E69=\"NR/NA\",\"NR/NA\",Audit!E69/Audit!F69)","v":0.59090909090909094},{"$f":"IF(MIN(Audit!J58:J68)=5,\"NR/NA\",IF(MIN(Audit!J58:J68)=4,\"G\",IF(MIN(Audit!J58:J68)=3,\"Y\",IF(MIN(Audit!J58:J68)=2,\"R\",IF(MIN(Audit!J58:J68)=1,\"R\",IF(MIN(Audit!J58:J68)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C69","v":6},1,null," "]
[null,"MANAGEMENT PARTICIPATION",null,null,{"$f":"IF(G43=\"NR/NA\",\"NR/NA\",Audit!F86)","v":60},{"$f":"(Audit!E86)","v":33},{"$f":"IF(Audit!E86=\"NR/NA\",\"NR/NA\",Audit!E86/Audit!F86)","v":0.55000000000000004},{"$f":"IF(MIN(Audit!J71:J83)=5,\"NR/NA\",IF(MIN(Audit!J71:J83)=4,\"G\",IF(MIN(Audit!J71:J83)=3,\"Y\",IF(MIN(Audit!J71:J83)=2,\"R\",IF(MIN(Audit!J71:J83)=1,\"R\",IF(MIN(Audit!J71:J83)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C86","v":7},1]
[null,"CONTAMINATION CONTROL",null,null,{"$f":"IF(G44=\"NR/NA\",\"NR/NA\",Audit!F97)","v":36},{"$f":"(Audit!E97)","v":21},{"$f":"IF(Audit!E97=\"NR/NA\",\"NR/NA\",Audit!E97/Audit!F97)","v":0.58333333333333337},{"$f":"IF(MIN(Audit!J88:J96)=5,\"NR/NA\",IF(MIN(Audit!J88:J96)=4,\"G\",IF(MIN(Audit!J88:J96)=3,\"Y\",IF(MIN(Audit!J88:J96)=2,\"R\",IF(MIN(Audit!J88:J96)=1,\"R\",IF(MIN(Audit!J88:J96)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C97","v":5},1]
[null,"LABELING",null,null,{"$f":"IF(G45=\"NR/NA\",\"NR/NA\",Audit!F107)","v":32},{"$f":"(Audit!E107)","v":20},{"$f":"IF(Audit!E107=\"NR/NA\",\"NR/NA\",Audit!E107/Audit!F107)","v":0.625},{"$f":"IF(MIN(Audit!J99:J106)=5,\"NR/NA\",IF(MIN(Audit!J99:J106)=4,\"G\",IF(MIN(Audit!J99:J106)=3,\"Y\",IF(MIN(Audit!J99:J106)=2,\"R\",IF(MIN(Audit!J99:J106)=1,\"R\",IF(MIN(Audit!J99:J106)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C107","v":4},1]
[null,"LEAK TESTING",null,null,{"$f":"IF(G46=\"NR/NA\",\"NR/NA\",Audit!F116)","v":28},{"$f":"(Audit!E116)","v":16},{"$f":"IF(Audit!E116=\"NR/NA\",\"NR/NA\",Audit!E116/Audit!F116)","v":0.5714285714285714},{"$f":"IF(MIN(Audit!J109:J115)=5,\"NR/NA\",IF(MIN(Audit!J109:J115)=4,\"G\",IF(MIN(Audit!J109:J115)=3,\"Y\",IF(MIN(Audit!J109:J115)=2,\"R\",IF(MIN(Audit!J109:J115)=1,\"R\",IF(MIN(Audit!J109:J115)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C116","v":4},1]
[null,"HEAT TREATING",null,null,{"$f":"IF(G47=\"NR/NA\",\"NR/NA\",Audit!F130)","v":48},{"$f":"Audit!E130","v":30},{"$f":"IF(Audit!E130=\"NR/NA\",\"NR/NA\",Audit!E130/Audit!F130)","v":0.625},{"$f":"IF(MIN(Audit!J118:J129)=5,\"NR/NA\",IF(MIN(Audit!J118:J129)=4,\"G\",IF(MIN(Audit!J118:J129)=3,\"Y\",IF(MIN(Audit!J118:J129)=2,\"R\",IF(MIN(Audit!J118:J129)=1,\"R\",IF(MIN(Audit!J118:J129)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C130","v":6},1]
[null,"DISTRIBUTOR / WAREHOUSE",null,null,{"$f":"IF(G48=\"NR/NA\",\"NR/NA\",Audit!F149)","v":68},{"$f":"Audit!E149","v":41},{"$f":"IF(Audit!E149=\"NR/NA\",\"NR/NA\",Audit!E149/Audit!F149)","v":0.6029411764705882},{"$f":"IF(MIN(Audit!J132:J148)=5,\"NR/NA\",IF(MIN(Audit!J132:J148)=4,\"G\",IF(MIN(Audit!J132:J148)=3,\"Y\",IF(MIN(Audit!J132:J148)=2,\"R\",IF(MIN(Audit!J132:J148)=1,\"R\",IF(MIN(Audit!J132:J148)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"Audit!C149","v":9},1]
[null,"TOOLING AUDIT SECTION 1",null,null,{"$f":"IF(G49=\"NR/NA\",\"NR/NA\",'Tooling Audit Form Sec1'!F10)","v":16},{"$f":"'Tooling Audit Form Sec1'!E10","v":10},{"$f":"IF('Tooling Audit Form Sec1'!E10=\"NR/NA\",\"NR/NA\",'Tooling Audit Form Sec1'!E10/'Tooling Audit Form Sec1'!F10)","v":0.625},{"$f":"IF(MIN('Tooling Audit Form Sec1'!J6:J9)=5,\"NR/NA\",IF(MIN('Tooling Audit Form Sec1'!J6:J9)=4,\"G\",IF(MIN('Tooling Audit Form Sec1'!J6:J9)=3,\"Y\",IF(MIN('Tooling Audit Form Sec1'!J6:J9)=2,\"R\",IF(MIN('Tooling Audit Form Sec1'!J6:J9)=1,\"R\",IF(MIN('Tooling Audit Form Sec1'!J6:J9)=0,\"R\"))))))","v":"R"},"Number of items requiring corrective action:",{"$f":"'Tooling Audit Form Sec1'!C10","v":2},1]
[null,"ELEMENTS TOTAL SCORE: ",null,null,{"$f":"SUM(E36:E49)","v":496},{"$f":"SUM(F36:F49)","v":293},{"$f":"IF(E50=0,\"NR/NA\",F50/E50)","v":0.59072580645161288},"*Auditor Note: RED status on any question requires corrective actions. Follow-up is done on site at the auditor's discretion within 6 months. "]
[null,"AUDIT STATUS",null,null,"Audit status is equal to the lowest color status of the above strategies.",null,{"$f":"IF(MIN(K36:K49)=4,\"NR/NA\",IF(MIN(K36:K49)=3,\"G\",IF(MIN(K36:K49)=2,\"Y\",IF(MIN(K36:K49)=1,\"R\"))))","v":"R"}]
[]
[null,"STATUS FOR INDIVIDUAL QUESTIONS"]
[]
[null,{"$f":"IF(MIN(F44:F53)=3,\"G\", IF(MIN(F44:F53)=2, \"Y\",\"R\"))","v":"R"},"  0 - RED: Element is not in place and no evidence of plans to implement: Corrective Action Required"]
[null,{"$f":"IF(MIN(F46:F54)=3,\"G\", IF(MIN(F46:F54)=2, \"Y\",\"R\"))","v":"R"},"  1 - RED: Element is not in place but a plan to implement is documented: Corrective Action Required"]
[null,{"$f":"IF(MIN(F50:F55)=3,\"G\", IF(MIN(F50:F55)=2, \"Y\",\"R\"))","v":"R"},"  2 - RED: Element is in place but it is not being followed: Corrective Action Required"]
[null,"Y","  3 - YELLOW: Element is satisfactory, but continuous improvement should be applied"]
[null,"G","  4 - GREEN: Element is in place and it is being followed",null,null,null,null,null,null,{"$f":"IF('Tooling Audit Form Sec2'!S16=2,\"Y\",\"N\")","v":"N"}]
[null,"NR/NA","  NR/NA - Didn't Audit / Not Applicable",null,null,null,null,null,"TOOLING AUDIT FORM SECTION 2:"]
[null,null,"Note:  Status and Code entered automatically from audit sheet.."]
[]
[null,null,null,null,null,null,null,null,"DOCK AUDIT COMPLETED:",{"$f":"IF('Dock Audit'!G1=2,\"Y\",\"N\")","v":"N"}]
[null,"Supplier Representative Signature",null,null,null,"ATI Representative Signature"]
[]
[null,"Supplier Representative Signature",null,null,null,"ATI Representative Signature"]

{"sheet":"Audit","index":1,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":false,"merged":[[160,1,181,5],[156,2,156,3],[152,2,152,3],[151,2,151,3],[159,1,159,5],[157,1,157,4],[154,2,154,3],[155,2,155,3],[153,2,153,3],[97,1,97,5],[23,1,23,2],[86,1,86,5],[0,1,1,5],[15,1,15,2],[45,1,45,2],[56,1,56,5],[9,1,9,2],[69,1,69,2]]}
[null,"PROCESS CONTROL PLAN AUDIT"]
[]
[null,"QUESTION","EVIDENCE","COMMENTS","SCORE","R/Y/G"]
[null,"A.  TECHNICAL INFORMATION AVAILABILITY"]
[1,"Are drawings available at the production facility, and do they match the change level on the latest Allison scheduling agreement?","LOOK FOR:\nDrawings, material spec sheets, scheduling agreement\n\nQUESTIONS TO ASK:\nDo you have drawings?\nDo you have math data?",null,1,{"$f":"IF(E5=\"NR/NA\",\"\",IF(E5>3,\"G\",IF(E5>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E5=\"NR/NA\",0,E5)","v":1},{"$f":"IF(E5=\"NR/NA\",5,E5)","v":1},{"$f":"IF(E5=\"NR/NA\",0,4)","v":4},{"$f":"IF(E5=\"NR/NA\",5,E5)","v":1}]
[2,"Do the scheduling agreement, ALLISON drawing, and PPAP warrant revision level match?","LOOK FOR:\nDrawings, scheduling agreement, PPAP warrant\n\nQUESTIONS TO ASK:\nDoes the part number revision level match on the PPAP warrant, scheduling agreement, and Allison drawing?",null,2,{"$f":"IF(E6=\"NR/NA\",\"\",IF(E6>3,\"G\",IF(E6>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E6=\"NR/NA\",0,E6)","v":2},{"$f":"IF(E6=\"NR/NA\",5,E6)","v":2},{"$f":"IF(E6=\"NR/NA\",0,4)","v":4},{"$f":"IF(E6=\"NR/NA\",5,E6)","v":2}]
[3,"Does the supplier retain the full PPAP documentation and part samples as required by AIAG PPAP manual?","LOOK FOR:\nPPAP documentation, either hardcopy or on iPPAP\n\nQUESTIONS TO ASK:\nDo you have the required documentation retained for the PPAP package for part number #######?\nDo you have the master retained samples for part number ########?",null,3,"Y",3,3,4,3]
[4,"Are all technical specifications (TIS, TES, etc.) available and do they match the current revision level on the Supplier Portal?","LOOK FOR:\nPart Drawing/Specification Package\nDocument F-11097 Engineering Specification Revision Listing\nQUESTIONS TO ASK:\nVerify Component Technical Specifications and Sub-System Technical Specification are available for review.",null,4,{"$f":"IF(E8=\"NR/NA\",\"\",IF(E8>3,\"G\",IF(E8>2,\"Y\",\"R\")))","v":"G"},4,4,4,4]
[null,"# Corrective Action Required =",{"$f":"IF(E9=\"NR/NA\",\"NR/NA\",COUNTIF(F5:F8,\"R\"))","v":2},"SCORE / POTENTIAL",{"$f":"IF(H9=20,\"NR/NA\",SUM(G5:G8))","v":10},{"$f":"I9","v":16},{"$f":"SUM(G5:G8)","v":10},{"$f":"SUM(H5:H8)","v":10},{"$f":"SUM(I5:I8)","v":16},{"$f":"SUM(J5:J8)","v":10}]
[null,"B.  CHANGE CONTROL"]
[5,"Do the revision levels for the part agree on the scheduling agreement, PPAP warrant, process flow, PFMEA and process control plan?","LOOK FOR:\n\nQUESTIONS TO ASK:\n",null,1,{"$f":"IF(E11=\"NR/NA\",\"\",IF(E11>3,\"G\",IF(E11>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E11=\"NR/NA\",0,E11)","v":1},{"$f":"IF(E11=\"NR/NA\",5,E11)","v":1},{"$f":"IF(E11=\"NR/NA\",0,4)","v":4},{"$f":"IF(E11=\"NR/NA\",5,E11)","v":1}]
[6,"Does the supplier have a change management system that includes notification to Allison of changes that could require PPAP (reference Table 3.1 in AIAG PPAP manual)?","LOOK FOR:\n1)  Procedure for change management\n2)  Internal controls to make changes only after customer notification and acceptance\n3)  Automated system to generate internal and external notifications when changes are made.\n4)  Evidence of SPCEs completed for changes.\n5)  Evidence of proper execution of the supplier's change management system.\nQUESTIONS TO ASK:\nHow do changes in your processes, inspections, materials or suppliers get managed?\nWhat is the mechanism or process that will require notification to Allison in the event of changes?",null,2,"R",{"$f":"IF(E12=\"NR/NA\",0,E12)","v":2},{"$f":"IF(E12=\"NR/NA\",5,E12)","v":2},{"$f":"IF(E12=\"NR/NA\",0,4)","v":4},{"$f":"IF(E12=\"NR/NA\",5,E12)","v":2}]
[7,"Does the supplier ensure PPAPs are conducted by their sub-tier suppliers on the lower level tiered suppliers?","LOOK FOR:\nSupplier requirements for sub-tier management\nSupplier PPAP procedure\nQUESTIONS TO ASK:\nAsk to see evidence of review of PSWs for sub-tier suppliers",null,3,"Y",3,3,{"$f":"IF(E13=\"NR/NA\",0,4)","v":4},3]
[8,"Does the supplier have a system to manage new releases and changes to documents required by the quality management system (i.e. procedures, control plans, work instructions)","LOOK FOR:\nDocument control procedure\nEvidence of revision control on documents\nSystem or work flow for document release and modification approval/review\nQUESTIONS TO ASK:\nHow do you ensure documents that are changed are reviewed and approved for accuracy?\nWhat system do you use to provide formal review and approval of new or modified documents?",null,4,"G",4,4,{"$f":"IF(E14=\"NR/NA\",0,4)","v":4},4]
[null,"# Corrective Action Required =",{"$f":"IF(E15=\"NR/NA\",\"NR/NA\",COUNTIF(F11:F14,\"R\"))","v":2},"SCORE / POTENTIAL",{"$f":"IF(H15=20,\"NR/NA\",SUM(G11:G14))","v":10},{"$f":"I15","v":16},{"$f":"SUM(G11:G14)","v":10},{"$f":"SUM(H11:H14)","v":10},{"$f":"SUM(I11:I14)","v":16},10]
[null,"C.  PROCESS FLOW DIAGRAM"]
[9,"Is a process flow diagram available?","LOOK FOR:\nProcess flow diagram\nQUESTIONS TO ASK:\nIs the process flow diagram linked to FMEAs, control plan, operator instructions, etc.?",null,1,{"$f":"IF(E17=\"NR/NA\",\"\",IF(E17>3,\"G\",IF(E17>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E17=\"NR/NA\",0,E17)","v":1},{"$f":"IF(E17=\"NR/NA\",5,E17)","v":1},{"$f":"IF(E17=\"NR/NA\",0,4)","v":4},{"$f":"IF(E17=\"NR/NA\",5,E17)","v":1}]
[10,"Does the workflow match the  Process Flow Diagram and is it organized (Follow 5S)?","LOOK FOR:\nProcess flow diagram, operator instruction at workstation\nQUESTIONS TO ASK:\nDoes the material flow / work station match the process flow diagram?",null,2,"R",2,2,4,2]
[11,"Does the process flow diagram include receiving?","LOOK FOR:\nEvidence of receiving process on process flow diagram\nQUESTIONS TO ASK:\nVerify that receiving inspection matches the process flow diagram and what is observed on the shop floor.",null,3,"Y",3,3,{"$f":"IF(E19=\"NR/NA\",0,4)","v":4},3]
[12,"Does the process flow diagram include rework?","LOOK FOR:\nEvidence that known rework processes are identified on the process flow diagram\nQUESTIONS TO ASK:\nAsk supplier what typical rework processes are utilized? \nAsk supplier to show you the rework processes are documented on the process flow diagram and control plan.",null,4,"G",4,4,4,4]
[13,"Does the process flow diagram include gauging/inspection stations?","LOOK FOR:\nProcess flow diagram\nQUESTIONS TO ASK:\nVerify that gauging/inspection matches the process flow diagram and what is observed on the shop floor.",null,1,"R",1,1,4,1]
[14,"Does the Process Flow Diagram include shipping?","LOOK FOR:\nEvidence the shipping process is identified on the process Flow Diagram\nQUESTIONS TO ASK:\nAsk the supplier to show you evidence of the shipping process on the process flow diagram and control plan.",null,2,"R",2,2,4,2]
[null,"# Corrective Action Required =",{"$f":"IF(E23=\"NR/NA\",\"NR/NA\",COUNTIF(J17:J22,\"<3\"))","v":4},"SCORE / POTENTIAL",{"$f":"IF(H23=30,\"NR/NA\",SUM(G17:G22))","v":13},{"$f":"I23","v":24},{"$f":"SUM(G17:G22)","v":13},{"$f":"SUM(H17:H22)","v":13},{"$f":"SUM(I17:I22)","v":24},{"$f":"SUM(J17:J22)","v":13}]
[null,"D.  PFMEA / PCP"]
[15,"Is there a PFMEA available?","LOOK FOR:\nPFMEA  for all part numbers and all operations, especially high risk such as labeling and rework.  Part family PFMEAs are acceptable.\nQUESTIONS TO ASK:\nVerify team members , dates etc. of actual PFMEA.",null,1,{"$f":"IF(E25=\"NR/NA\",\"\",IF(E25>3,\"G\",IF(E25>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[16,"Is there any evidence that it is kept up to date?","LOOK FOR:\nPFMEA change log, meeting minutes, or similar history\nMulti-disciplinary team agenda or other evidence of RPN reduction activities\nDocumentation that frequency and prioritization of reviews is based on customer input, process capability, process changes, AIAG guidelines, etc…  \nQUESTIONS TO ASK:\nVerify that the PFMEA is updated as required & matches the control plan (Review SQN's).\nVerify any current failure modes are present on the PFMEA.",null,2,"R",2,2,4,2]
[17,"Is the PFMEA acceptable:  RPN number calculation is correct, rankings for severity, occurrence and detection match AIAG or Allison recommendations, process operations match the process flow diagram and include special characteristics","LOOK FOR:\nPFMEA Changed Log, Meeting Minutes or similar history\nValid RPN numbers and revision dates with some correlation to known problems (SQNs, etc…)\nSample RPN numbers and ensure rankings are consistent with AIAG or Allison recommendations (i.e. visual detection = xx)\nQUESTIONS TO ASK:\nDo RPN numbers reflect latest AIAG FMEA Manual edition?",null,3,"Y",3,3,4,3]
[18,"Are the RPN numbers consistent?","LOOK FOR:\nPFMEA\nQUESTIONS TO ASK:\nAre consistent rankings being used based for severity, detection, & occurrence",null,4,"G",4,4,4,4]
[19,"Is there a procedure or process for continuous improvement based on RPN /risk reduction?","LOOK FOR:\nPFMEA procedure of continuous improvement\nTop RPN list, tracking charts, management review minutes\nMeeting minutes, worksheets, historic PFMEA's.\nQUESTIONS TO ASK:\nDoes the supplier have a system to identify PFMEA line items for continuous improvement and are action plans identified?",null,1,"R",1,1,4,1]
[20,"Is there a process control plan (PCP) available?","LOOK FOR:\nUpdated process control plan\nQUESTIONS TO ASK:\nVerify current dates, etc. of PCP document.",null,2,"R",2,2,4,2]
[21,"Is the process control plan (PCP) acceptable?  Do the operation steps match the PFMEA and process flow?  Are special characteristics included?   Is GP-12 defined if applicable? ","LOOK FOR:\nPCP, changed log, meeting minutes or similar history that links all documents\nQUESTIONS TO ASK:\nVerify that PFMEA is updated as required and matches the Process Control Plan. ",null,3,"Y",3,3,4,3]
[22,"Are all \"Current Controls\" listed on the PFMEA also detailed on the control plan?","LOOK FOR:\nCurrent controls, callouts on drawing/PCP/PFMEA\nQUESTIONS TO ASK:\nAre current controls listed on the PFMEA and PCP and do they match?",null,4,"G",4,4,4,4]
[23,"Are special characteristics called out on the PCP?","LOOK FOR:\nControl plan, drawing \nQUESTIONS TO ASK:\nVerify special characteristics are addressed on the PCP.",null,1,"R",1,1,4,1]
[24,"Are inspection frequencies and capability data for special characteristics acceptable?","LOOK FOR:\nControl plan, collected data\nCapability studies for high volume parts run in last 3 months\nCapability studies for low volume parts run in last 6 months\nQUESTIONS TO ASK:\nDoes special characteristics data meet the requirements of AT-1927?",null,2,"R",2,2,4,2]
[25,"Are sample sizes and check frequencies for each operation reasonable?","LOOK FOR:\nControl Plan\nQUESTIONS TO ASK:\nIs there a history of failures in spite of existing controls?\nDoes internal data (scrap, rework, FTQ, etc.) suggest sample sizes and frequencies are adequate?",null,3,"Y",3,3,4,3]
[null,"# Corrective Action Required =",{"$f":"IF(E36=\"NR/NA\",\"NR/NA\",COUNTIF(J25:J35,\"<3\"))","v":6},"SCORE / POTENTIAL",{"$f":"IF(H36=55,\"NR/NA\",SUM(G25:G35))","v":26},{"$f":"I36","v":44},{"$f":"SUM(G25:G35)","v":26},{"$f":"SUM(H25:H35)","v":26},{"$f":"SUM(I25:I35)","v":44},{"$f":"SUM(J25:J35)","v":26}]
[null,"E.  STANDARDIZED OPERATIONS & TRAINING"]
[26,"Are proper operator instructions available for each operation?","LOOK FOR:\nOperator Instructions\nInstructions that are located for quick and easy reference. (close to the workstation)\nDocumentation of required PPE, availability, and use at the workstation.\nWork flow diagrams including walk path, standard-in-process stock, material and tools. \nVisuals accurately represent the workstation layout and work sequence.\nQUESTIONS TO ASK:\nVerify that operator instructions are secure and visible to the operator.\nVerify that instructions are to the latest engineering change level.",null,1,{"$f":"IF(E38=\"NR/NA\",\"\",IF(E38>3,\"G\",IF(E38>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[27,"Are Standardized Work instructions detailed enough to run the job properly, including handling of non-conforming parts?","LOOK FOR:\nOperator Instructions\nQUESTIONS TO ASK:\nVerify that operations are being performed as indicated per defined instructions (cycle time, handling of non-conforming material, etc.).  \nDo visuals accurately represent the work station layout and work sequence?",null,2,"R",2,2,4,2]
[28,"Is the Standardized Work being followed?","LOOK FOR:\nStandardized Worksheets\nQUESTIONS TO ASK:\nAre Layered Audits being performed?",null,3,"Y",3,3,4,3]
[29,"Do the operators understand the instructions?","LOOK FOR:\nOperator Instructions\nCompare instructions to actual work performed by operator\nOBSERVE 3 full cycles of the job in station: Verify:\n         That the Major Steps (WHAT),  Key Points (HOW), \n          and Reason (WHY) are followed\nQuality checks are included.\nSpecific tool requirements are listed at the operation. \nVerify critical items such as torque or Customer Safety requirements are specified in the document.\n\nBEST PRACTICE:\nMajor Steps (WHAT), Key Points  (HOW), and Reason (WHY) are properly explained.\nQUESTIONS TO ASK:\nAsk Team Member what or how the Standardized Work Instructions are used.\nAsk the Team Member how they know they have made good part.\nAsk the Team Member to demonstrate use of the gages and the handling of conforming and non-conforming parts.",null,4,"G",4,4,4,4]
[30,"Have the operators been properly trained?","LOOK FOR:\nEvidence that operators are trained in the use of \n   Standardized Work Instructions\nTraining Records\nLayered Audit Checklists\nQUESTIONS TO ASK:\nCertification Training Record or Plan.\nBEST PRACTICE:\n- Chart showing cross training/certification level in a cell such as a flexibility chart.\n- Look for a job rotation plan or log.  How often does team rotate?\n- The number of Team Members certified per station should support the Job Rotation Plan.\n- If it does not, look for a plan such as a Flexibility Chart 2x2 or 4x4 matrix, that shows the status, actual vs. planned  number certified per station that is being used to maintain job rotation.",null,1,"R",1,1,4,1]
[31,"Are instructions for handling Work In Process (WIP) and final product followed throughout the process including repair/rework areas and packaging/shipping?","LOOK FOR:\nWIP Instructions, Final Shipping Instructions\nAre operators using prescribed in-process containers, storage locations, material handling (i.e. lint-free gloves.\nQUESTIONS TO ASK:\nCheck to make sure all Team Members  and material handling personnel are aware of and following WIP instructions.",null,2,"R",2,2,4,2]
[32,"Are all parts and components labeled properly?","LOOK FOR:\nShipping Label, Drawing, Process Control Plan\nInspection Sheets\nQUESTIONS TO ASK:\nDoes the Shipping Label match the Part Print?\nVerify against Control Plan and In-Process Inspection sheets.",null,3,"Y",3,3,4,3]
[null,"# Corrective Action Required =",{"$f":"IF(E45=\"NR/NA\",\"NR/NA\",COUNTIF(J38:J44,\"<3\"))","v":4},"SCORE / POTENTIAL",{"$f":"IF(H45=35,\"NR/NA\",SUM(G38:G44))","v":16},{"$f":"I45","v":28},{"$f":"SUM(G38:G44)","v":16},{"$f":"SUM(H38:H44)","v":16},{"$f":"SUM(I38:I44)","v":28},{"$f":"SUM(J38:J44)","v":16}]
[null,"F.  GAGING"]
[33,"Are all tools and gauges properly identified?","LOOK FOR:\nGage and Tool Certification Records\nQUESTIONS TO ASK:\nVerify tools and gages are to the latest engineering change level and that Preventative Maintenance is as specified.\nEnsure that all ATI or other customer's tags are available on the tooling.",null,1,{"$f":"IF(E47=\"NR/NA\",\"\",IF(E47>3,\"G\",IF(E47>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[34,"Are all gauges within the defined calibration frequency? ","LOOK FOR:\nGage and Tool Certification Records\nVerify gages that are sent outside are within defined calibration frequency.\nQUESTIONS TO ASK:\nCheck to make sure gauges are within calibration. \nVerify that tools and gages are to the latest engineering change level.",null,2,"R",2,2,4,2]
[35,"Does the supplier periodically evaluate families of gages on the control plan?","LOOK FOR:\nGage R&R Documentation\nQUESTIONS TO ASK:\nBest practice is that gauge R&R is done at a  minimum of an annual  basis for all families of gauges on the control plan.",null,3,"Y",3,3,4,3]
[36,"Does the supplier react appropriately to the results of the MSA's?","LOOK FOR:\nGage R&R Documentation\nQUESTIONS TO ASK:\nIf gauge R&R is between 10% and 30% (see latest revision of MSA & PPAP Manuals) has the supplier conducted an evaluation of the results with a cross-functional team?",null,4,{"$f":"IF(E50=\"NR/NA\",\"\",IF(E50>3,\"G\",IF(E50>2,\"Y\",\"R\")))","v":"G"},{"$f":"IF(E50=\"NR/NA\",0,E50)","v":4},{"$f":"IF(E50=\"NR/NA\",5,E50)","v":4},{"$f":"IF(E50=\"NR/NA\",0,4)","v":4},{"$f":"IF(E50=\"NR/NA\",5,E50)","v":4}]
[37,"Do gauges have sufficient operator instructions?","LOOK FOR:\nGauge Instructions \nQUESTIONS TO ASK:\nEnsure that Gauge Instructions are readily available (attached to the gauge is preferable).",null,1,"R",1,1,4,1]
[38,"Is the gaging method proper for the feature being gaged?","LOOK FOR:\nProcess control plan, gaging method, feature tolerances\nQUESTIONS TO ASK:\nSample part features and gaging method.",null,2,"R",{"$f":"IF(E52=\"NR/NA\",0,E52)","v":2},{"$f":"IF(E52=\"NR/NA\",5,E52)","v":2},{"$f":"IF(E52=\"NR/NA\",0,4)","v":4},{"$f":"IF(E52=\"NR/NA\",5,E52)","v":2}]
[39,"Are boundary samples available to operators and in use?","LOOK FOR:\nOperator Instructions\nQUESTIONS TO ASK:\nVerify that supplier has actual boundary samples for review and that they are being used as required.",null,3,"Y",3,3,4,3]
[40,"Verify error proofing devices are being checked to ensure they are working properly","LOOK FOR:\nSupplier error proof verification procedure\nReaction plan when error proofing devices fail the verification\nQUESTIONS TO ASK:\nAsk supplier to provide log sheets to show error proof verification",null,4,{"$f":"IF(E54=\"NR/NA\",\"\",IF(E54>3,\"G\",IF(E54>2,\"Y\",\"R\")))","v":"G"},{"$f":"IF(E54=\"NR/NA\",0,E54)","v":4},{"$f":"IF(E54=\"NR/NA\",5,E54)","v":4},{"$f":"IF(E54=\"NR/NA\",0,4)","v":4},{"$f":"IF(E54=\"NR/NA\",5,E54)","v":4}]
[41,"Are Master Parts available for error proofing devices, are they identified properly (i.e. painted),  and are they in use?","LOOK FOR:\nSet Up Records\nQUESTIONS TO ASK:\nChallenge the Error Proofing system.\nIs there an Error Proofing Verification Plan? Are there Test Parts for Error Proofing.",null,1,"R",1,1,4,1]
[null,"# Corrective Action Required =",{"$f":"IF(E56=\"NR/NA\",\"NR/NA\",COUNTIF(J47:J55,\"<3\"))","v":5},"SCORE / POTENTIAL",{"$f":"IF(H56=45,\"NR/NA\",SUM(G47:G55))","v":21},{"$f":"I56","v":36},{"$f":"SUM(G47:G55)","v":21},{"$f":"SUM(H47:H55)","v":21},{"$f":"SUM(I47:I55)","v":36},{"$f":"SUM(J47:J55)","v":21}]
[null,"G.  PROCESS CONTROLS"]
[42,"Do your supplier's provide evidence of approved material for all components needed for the assembled part?","LOOK FOR:\nCertification/Test Records, Supplier PPAP Packages\nCumulative Control Data\nQUESTIONS TO ASK:\nReview Incoming Inspection Sheets (if available).\nReview Hold or Reject area for Incoming Inspection area.  Are component parts/assemblies on the manufacturing floor approved prior to release?",null,1,{"$f":"IF(E58=\"NR/NA\",\"\",IF(E58>3,\"G\",IF(E58>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[43,"Are controls in place to ensure only approved incoming material is released for production?","LOOK FOR:\nCertification/Test Records, Supplier PPAP Packages\nCumulative Control Data\nQUESTIONS TO ASK:\nReview PPAP data, including interim approvals.\nHow do you indicate that component parts/assemblies on the manufacturing floor are approved for use.",null,2,"R",2,2,4,2]
[44,"When parts require traceability, do controls link component traceability to the final part? ","LOOK FOR:\nTraceability Documents\nQUESTIONS TO ASK:\nLook for Lot Controls, Dimensional Traceability to N.I.S.T.",null,3,"Y",3,3,4,3]
[45,"Where the Process Control Plan calls for SPC is the data properly recorded?","LOOK FOR:\nProcess Control Plan, SPC Records\nQUESTIONS TO ASK:\nLook at actual SPC records and data collection.\nAre all data boxes filled in?\nAre control limits calculated?\nAre there trends/patterns present that would indicate a need to recalculate limits?\nAre the limits actually control limits or are they spec limits?\nDo the control limits exceed the specified tolerances?\nDo the limits indicate the process to be incapable and yet the process is allowed to run?",null,4,"G",4,4,4,4]
[46,"Are the Upper Control Limits (UCL) and Lower Control Limits (LCL) current?","LOOK FOR:\nX-Bar and R Charts\nQUESTIONS TO ASK:\nHow old are the UCL and LCL?",null,1,"R",1,1,4,1]
[47,"Does the data make sense and are reasonable control limits shown?","LOOK FOR:\nRun Charts\nProcess Control Plan\nSPC Records\nQUESTIONS TO ASK:\nLook at actual SPC records.\nAre all data boxes filled in?\nAre control limits calculated?\nAre there trends present that would indicate a need to recalculate limits that have been ignored?\nAre the limits actually control limits or are they spec limits?\nDo the control limits exceed the specified tolerances?\nDo the limits indicate the process to be incapable and yet the process is allowed to run?",null,2,"R",2,2,4,2]
[48,"Where checks are called for in the PCP, are results being properly logged?","LOOK FOR:\nProcess Control Plan\nCheck Sheets (All as described in SWI, JEI, & JES)\nQUESTIONS TO ASK:\nIs operator recording results?",null,3,"Y",3,3,4,3]
[49,"Are suitable actions taken in case of deviations?","LOOK FOR:\nPFMEA\nProcess Control Plan\nCheck Sheets / SPC Data\nColor coding of containers, hold tags\nContainment or non-conforming forms\nSegregation areas\nQUESTIONS TO ASK:\nIs there evidence that all concerns are tracked back to the PFMEA to confirm that the failure mode has been included?\nLook for PFMEA change log cross referenced to SQN log, customer complaint log, voice of the process review, warranty data, etc.\nIs there evidence that controls have been added, or controls/RPNs revised based on concerns.",null,4,"G",4,4,4,4]
[50,"Are the supplier product audits showing acceptable results for Final Product?","LOOK FOR:\nDock and Incoming Audit Sheets, Layered Audits\nQUESTIONS TO ASK:\nDocumented failed parts per shipment.\nDock Audits/Tracking Trends/Discrepant Parts.",null,1,"R",1,1,4,1]
[51,"Does the manufacturing process demonstrate the required capability or performance (Cpk)?","LOOK FOR:\nCpk Studies\nQUESTIONS TO ASK:\nReview current capability records.\nDoes the process demonstrate there required Cpk for special characteristics (per AT-1927)\nIs the process capability too high (over 6) and does the data support such results?",null,2,"R",2,2,4,2]
[52,"Does packaging and material handling protect parts from damage and conform to AT-1700 Packaging Requirements?","LOOK FOR:\nDock and Incoming Audit Sheets\nQUESTIONS TO ASK:\nDoes WIP protection at supplier have adequate protection to protect parts from damage until packed and on carrier?\nIs there evidence that damage observed at assembly center, etc., is present at supplier?\nAre there any SQNs related to Packaging and Handling?\nFor Material handling throughout the entire process, are parts protected from damage?",null,3,{"$f":"IF(E68=\"NR/NA\",\"\",IF(E68>3,\"G\",IF(E68>2,\"Y\",\"R\")))","v":"Y"},3,3,4,3]
[null,"# Corrective Action Required =",{"$f":"IF(E69=\"NR/NA\",\"NR/NA\",COUNTIF(J58:J68,\"<3\"))","v":6},"SCORE / POTENTIAL",{"$f":"IF(H69=55,\"NR/NA\",SUM(G58:G68))","v":26},{"$f":"I69","v":44},{"$f":"SUM(G58:G68)","v":26},{"$f":"SUM(H58:H68)","v":26},{"$f":"SUM(I58:I68)","v":44},{"$f":"SUM(J58:J68)","v":26}]
[null,"H.  MANAGEMENT SYSTEM"]
[53,"Does the supplier execute their safety procedures?","LOOK FOR:\nSafety procedures\nSafety training\nSafety audits\nProper execution of procedures during audit\nQUESTIONS TO ASK:\nWhat are your safety procedures?\nHow often do you perform safety audits?\nHow do you track safety performance?",null,1,{"$f":"IF(E71=\"NR/NA\",\"\",IF(E71>3,\"G\",IF(E71>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E71=\"NR/NA\",0,E71)","v":1},{"$f":"IF(E71=\"NR/NA\",5,E71)","v":1},{"$f":"IF(E71=\"NR/NA\",0,4)","v":4},{"$f":"IF(E71=\"NR/NA\",5,E71)","v":1}]
[54,"Does the supplier have a safety protocol training that is required for visitors to review?","LOOK FOR:\nVisitor safety protocol\nQUESTIONS TO ASK:\nWhat safety training do visitors have to review prior to entry to your facilities?",null,2,"R",{"$f":"IF(E72=\"NR/NA\",0,E72)","v":2},{"$f":"IF(E72=\"NR/NA\",5,E72)","v":2},{"$f":"IF(E72=\"NR/NA\",0,4)","v":4},{"$f":"IF(E72=\"NR/NA\",5,E72)","v":2}]
[55,"Is there a Preventive Maintenance (PM) plan on tools and equipment, and is it followed?","LOOK FOR:\nPM Log\nPFMEA\nQUESTIONS TO ASK:\nVerify PM plan is being followed.\nReview PM Log to verify PM performed according to schedule and procedure.",null,3,"Y",3,3,4,3]
[56,"Is there a critical machine listing, and are critical machine components identified and readily available","LOOK FOR:\nPM procedure\nCritical machine list\nCritical machine replacement parts list\nQUESTIONS TO ASK:\nAsk supplier to review their availability of critical spare parts",null,4,"G",{"$f":"IF(E74=\"NR/NA\",0,E74)","v":4},{"$f":"IF(E74=\"NR/NA\",5,E74)","v":4},{"$f":"IF(E74=\"NR/NA\",0,4)","v":4},{"$f":"IF(E74=\"NR/NA\",5,E74)","v":4}]
[57,"Is there a process for documenting and tracking Downtime, Scrap, and Premium Freight?","LOOK FOR:\nPlant Informational Board\nCurrent Charting of Information\nQUESTIONS TO ASK:\nAre records for Downtime used to manage the business?\nLook for existing charts, data logs, action plans, or similar records that validate the existence of a tracking mechanism.",null,1,"R",1,1,4,1]
[58,"Is there a defined process for documenting and tracking internal and external Problem Reports?","LOOK FOR:\nPlant Informational Board\nCurrent Charting of Information\nEvidence of updated PFMEA and PCP\nBEST PRACTICES:\n- Meetings held every shift.\n- Operators attend meetings.\n- Problem Solving forms for each issue displayed or available in area.\nQUESTIONS TO ASK:\nAre records for Plant Problem Reports used to manage the business?\nLook for existing charts, data logs, action plans, or similar records that validate the existence of a tracking mechanism.",null,2,"R",2,2,4,2]
[59,"Does leadership ensure that out of control conditions are managed?","LOOK FOR:\nSPC Records\nAction Plans\nFast Response Tracking form \nLayered Audit form/results\nQuality Q or equivalent is posted and up to date\nQUESTIONS TO ASK:\nReview SPC data, check to see that there is a system to manage out of control conditions that includes action plans with assigned responsibility.\nAsk someone noted on the action plan to explain their involvement and or responsibility.",null,3,"Y",{"$f":"IF(E77=\"NR/NA\",0,E77)","v":3},{"$f":"IF(E77=\"NR/NA\",5,E77)","v":3},{"$f":"IF(E77=\"NR/NA\",0,4)","v":4},{"$f":"IF(E77=\"NR/NA\",5,E77)","v":3}]
[60,"Are defined Action Plans (AP) followed?","LOOK FOR:\nSPC Records\nAction Plans\nQUESTIONS TO ASK:\nReview plans for timeliness, completeness, and effectiveness.  ",null,4,"G",4,4,4,4]
[61,"Is responsibility for implementation assigned and do people understand their responsibility?","LOOK FOR:\nSPC Records\nAction Plans\nProblem Log\nQUESTIONS TO ASK:\nFrom SPC review, check to see that there is a system to manage out of control conditions that includes action plans with assigned responsibility.\nAsk someone noted on the action plan to explain their involvement and or responsibility.",null,1,"R",1,1,4,1]
[62,"Are problems quickly communicated to people who can help and does the system response meet the supplier's requirements?","LOOK FOR:\nProblem Log\nFast Response meeting minutes or similar\nQUESTIONS TO ASK:\nDoes an escalation process exist to quickly communicate to the appropriate level within the organization and ensure that support and action plans are followed?",null,2,"R",2,2,4,2]
[63,"If more than one shift, does information part passes across shifts?","LOOK FOR:\nShift Log\nFast Response meeting minutes or similar\nQUESTIONS TO ASK:\nLook for shift log/notes.\nAudit records to assure that reported problems and their resolutions are also reported back to the originator.\nLook for evidence of a closed loop on shift problems.",null,3,"Y",3,3,4,3]
[64,"Does an audit system to verify the documented quality, manufacturing and assembly processes exist?","LOOK FOR:\n1) Completed audits at a frequency of once per shift.  Evidence that Team Members, Team Leaders, Group Leaders are all involved in performing audits\n2) Customer Specific checks for past failures. (i.e. Assigned at Fast Response, for SQN or Liaison Report issues, error-proofing verification, etc...)\n3) Workstation Specific check items (Standardized Work, 5S-WPO, Rotation Log, Training, etc..)\n4) System Specific items (Preventative Maintenance, Business Plan reviews, Shop Floor Management standards, etc..) \n5) External supplier audits\nQUESTIONS TO ASK:\nDoes an audit schedule or plan exist?\nIs there a link from audits to Lessons Learned system or equivalent?\nAudit records to assure that reported problems and their resolutions are also reported back to the originator.\n\nBEST PRACTICE:\nLayered Process Audit system.\nCheck that the Audits are verified by the next level Supervisor.  The results are shared with the team.\nNoncompliance's are addressed at regularly scheduled meetings with a countermeasure list with responsibility and dates.",null,4,"G",4,4,4,4]
[65,"Is there a system in place to capture or identify information that will support continuous improvements to all processes?","LOOK FOR:\n1) Completed Corrective action forms.\n2) Continuous improvement team notes and agendas.\n3) Leadership notes or agenda indicating Lesson Learned system is reviewed.\nQUESTIONS TO ASK:\nIs Continuous Improvement, APQP, new parts, Customer re-allocations (tool moves) and RPN Reduction team checklists or notes included in lessons learned database?",null,1,"R",1,1,4,1]
[66,"Do contingency plans exist for an interruption in the supply chain due to internal and external factors?","LOOK FOR:\n1) Identification and evaluation of risks to all processes.\n2) Customer notification process.\n3) Periodic plan review and testing.\nQUESTIONS TO ASK:\nWhat is the plan to maintain production in case of natural disaster, utility interruption, supplier production gap, or labor shortage?\nWhat are the largest risks to the manufacturing process both internal and external?",null,1,{"$f":"IF(E84=\"NR/NA\",\"\",IF(E84>3,\"G\",IF(E84>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E84=\"NR/NA\",0,E84)","v":1},{"$f":"IF(E84=\"NR/NA\",5,E84)","v":1},{"$f":"IF(E84=\"NR/NA\",0,4)","v":4},{"$f":"IF(E84=\"NR/NA\",5,E84)","v":1}]
[67,"Are all applicable statutory and regulatory requirements in addition to all special product and process characteristics cascaded down supply chain to point of manufacture?","LOOK FOR:\n1) List of all requirements and special characteristics.\n2) Notification to supply chain\n3) Acknowledgement from supply chain of receipt of requirements.\nQUESTIONS TO ASK:\nHow are all applicable requirements gathered and documented?\nHow is the supply chain notified of applicable requirements?",null,1,"R",1,1,4,1]
[null,"# Corrective Action Required =",{"$f":"IF(E86=\"NR/NA\",\"NR/NA\",COUNTIF(J71:J83,\"<3\"))","v":7},"SCORE / POTENTIAL",{"$f":"IF(H86=65,\"NR/NA\",SUM(G71:G85))","v":33},{"$f":"I86","v":60},{"$f":"SUM(G71:G85)","v":33},{"$f":"SUM(H71:H85)","v":33},{"$f":"SUM(I71:I85)","v":60},{"$f":"SUM(J71:J85)","v":33}]
[null,"I.  CONTAMINATION CONTROL"]
[68,"Do procedures and work instructions exist for contamination control where appropriate?","LOOK FOR:\nWork Instruction\nControl Plan\nQUESTIONS TO ASK:\nDo the work instructions and/or Control Plan address contamination control?",null,1,{"$f":"IF(E88=\"NR/NA\",\"\",IF(E88>3,\"G\",IF(E88>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[69,"Is in process material adequately protected from contamination?","LOOK FOR:\nWork Instruction, WIP\nQUESTIONS TO ASK:\nReview work instructions for procedures and WIP to determine if in process material is adequately protected.",null,2,"R",2,2,4,2]
[70,"Does dunnage adequately protect parts from contamination?","LOOK FOR:\nWork Instruction\nProduct on Dock\nQUESTIONS TO ASK:\nReview work instructions for procedures and material on the dock to determine if dunnage is providing adequate protection.",null,3,"Y",3,3,4,3]
[71,"Where applicable, is regular PM being performed on washers?","LOOK FOR:\nWasher Equipment, PM Log\nQUESTIONS TO ASK:\nReview PM log against equipment number to determine if adequate maintenance is being performed.",null,4,"G",4,4,4,4]
[72,"When applicable, are washers running at the required parameters?","LOOK FOR:\nWork Instruction, Control Plan, Log Sheet\nQUESTIONS TO ASK:\nAre concentrations, temperatures, etc. running at the required parameters?  Are these checked and logged per the Control Plan frequency?",null,1,"R",1,1,4,1]
[73,"If part requires TIS-5750/5751, is regular analysis being performed?","LOOK FOR:\nWork Instruction, Control Plan, Log Sheet\nQUESTIONS TO ASK:\nAre washdowns being done and logged per the Control Plan frequency?",null,2,"R",2,2,4,2]
[74,"Does the TIS-5750/5751 analysis meet the intent of the spec?","LOOK FOR:\nWork Instruction\nQUESTIONS TO ASK:\nCompare the work instructions to the TIS-5750/5751 spec to insure it is being done properly.",null,3,"Y",3,3,4,3]
[75,"Is there a regular review of TIS-5750/5751 contamination data by leadership?","LOOK FOR:\nReports, data summaries, action plans, continuous improvement programs\nQUESTIONS TO ASK:\nIs the data reviewed?  Who reviews it?  On what frequency?",null,4,"G",4,4,4,4]
[76,"If TIS-5750/5751 results are not favorable, are actions being taken?","LOOK FOR:\nReports, data summaries, action plans, continuous improvement programs\nQUESTIONS TO ASK:\nWhat is done when a point is out of control?  Who is responsible?",null,1,"R",1,1,4,1]
[null,"# Corrective Action Required = ",{"$f":"IF(E97=\"NR/NA\",\"NR/NA\",COUNTIF(J88:J96,\"<3\"))","v":5},"SCORE / POTENTIAL",{"$f":"IF(H97=45,\"NR/NA\",SUM(G88:G96))","v":21},{"$f":"I97","v":36},{"$f":"SUM(G88:G96)","v":21},{"$f":"SUM(H88:H96)","v":21},{"$f":"SUM(I88:I96)","v":36},{"$f":"SUM(J88:J96)","v":21}]
[null,"J. LABELING"]
[77,"Are the latest revisions of AT-1724 (Shipping Parts ID Label Standard) and AT-1700 (ATI Packaging & Identification Reqs) available?\n","LOOK FOR:\nLatest revision of AT-1724 and\nAT-1700, or ready access to the Supplier Quality website\nQUESTIONS TO ASK:\nAre the latest forms of these documents available?",null,1,{"$f":"IF(E99=\"NR/NA\",\"\",IF(E99>3,\"G\",IF(E99>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[78,"Are all bar codes legible? (Not faded, smeared, or poorly printed)\n","LOOK FOR:\nSmeared, faded or otherwise illegible labels on containers.\nQUESTIONS TO ASK:\nAre all bar codes readable?",null,2,"R",2,2,4,2]
[79,"Are all GM references removed from ATI-bound container labels?\n","LOOK FOR:\nGM references on ATI-bound container labels\nQUESTIONS TO ASK:\nAre all containers free of labels with GM references?",null,3,"Y",3,3,4,3]
[80,"Are all old shipping labels removed or sufficiently covered?\n","LOOK FOR:\nUnremoved or uncovered old labels that may conflict with current labeling.\nQUESTIONS TO ASK:\nAre all containers free of conflicting old labeling?",null,4,"G",4,4,4,4]
[81,"Do any certified material labels conflict with or overwhelm the shipping label(s)?\n","LOOK FOR:\nCertified Material labeling\nQUESTIONS TO ASK:\nAre all containers free from being obstructed or overwhelmed by Certified Material labeling?",null,1,"R",1,1,4,1]
[82,"Are parts properly identified and segregated by part number?","LOOK FOR:\nStandardized storage and segregation of material\nQUESTIONS TO ASK:\nAre parts identified, stored and segregated correctly?                      ",null,2,"R",2,2,4,2]
[83,"Is the proper ATI shipping address printed on all shipping labels?\n","LOOK FOR:\nProper ATI Shipping Dock address\nQUESTIONS TO ASK:\nIs the proper ATI Dock printed on the shipping label?",null,3,"Y",3,3,4,3]
[84,"Are all shipping labels the correct type, format, size and placed correctly (REF: AT-1724)?\n","LOOK FOR:\nProper label type (mixed load, master load, etc.)          Improper sized labels, Improperly placed labels                                                       Improperly filled out mixed load, master load or individual part number labels                                                                                                 QUESTIONS TO ASK:\nAre all shipping labels the correct type, format, size and placed correctly (per AT-1724)?",null,4,"G",4,4,4,4]
[null,"# Corrective Action Required = ",{"$f":"IF(E107=\"NR/NA\",\"NR/NA\",COUNTIF(J99:J106,\"<3\"))","v":4},"SCORE / POTENTIAL",{"$f":"IF(H107=40,\"NR/NA\",SUM(G99:G106))","v":20},{"$f":"I107","v":32},{"$f":"SUM(G99:G106)","v":20},{"$f":"SUM(H99:H106)","v":20},32,20]
[null,"K.  LEAK TESTING","(If not required, leave score at \"NR\")"]
[85,"Does method of testing part match drawing requirements?","LOOK FOR:\nLeak Test Equipment, Drawing/Spec Requirement\nQUESTIONS TO ASK:\nIf drawing/spec calls for air/water, is the appropriate test being performed?",null,1,{"$f":"IF(E109=\"NR/NA\",\"\",IF(E109>3,\"G\",IF(E109>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[86,"Are parameters being used meeting specifications?","LOOK FOR:\nPrint/Spec Requirement\nQUESTIONS TO ASK:\nVerify that pressures, times, flow rates, etc. being used match the drawing and spec requirements.",null,2,"R",2,2,4,2]
[87,"Are the chambers tested and required holes vented per blueprint requirements?","LOOK FOR:\nLeak Test Equipment, Drawing/Spec Requirement\nQUESTIONS TO ASK:\nVerify that the correct chambers are being pressurized and that holes are vented if required.  Multiple tests for cross leakage may be required if more than one chamber is being tested.",null,3,"Y",3,3,4,3]
[88,"Is part positively identified when passing leak test?","LOOK FOR:\nLeak Test Equipment\nQUESTIONS TO ASK:\nPart should be stamped when passing leak test.  Automatic stamping is preferred.",null,4,"G",4,4,4,4]
[89,"Is adequate containment maintained for parts failing leak test?","LOOK FOR:\nLeak Test Equipment, Work Instructions\nQUESTIONS TO ASK:\nIs the failed part locked in equipment after failing? If manual operation, is adequate segregation and containment made?  Are parts marked when failing? Are work instructions being followed?",null,1,"R",1,1,4,1]
[90,"Are leak test master samples available and are they adequately protected from contamination?","LOOK FOR:\nMaster Samples\nQUESTIONS TO ASK:\nVerify that master good and bad samples are present.",null,2,"R",2,2,4,2]
[91,"Is leak tester being mastered?","LOOK FOR:\nMaster Samples, Log Sheet\nQUESTIONS TO ASK:\nVerify that log sheet shows masters being run per Control Plan and work instructions. Once per shift at a minimum.",null,3,"Y",3,3,4,3]
[null,"# Corrective Action Required =",{"$f":"IF(E116=\"NR/NA\",\"NR/NA\",COUNTIF(J109:J115,\"<3\"))","v":4},"SCORE / POTENTIAL",{"$f":"IF(H116=35,\"NR/NA\",SUM(G109:G115))","v":16},{"$f":"I116","v":28},{"$f":"SUM(G109:G115)","v":16},{"$f":"SUM(H109:H115)","v":16},28,16]
[null,"L. HEAT TREATING","(If not required, leave score at \"NR\")"]
[92,"Are the latest Allison heat treat specifications on file?","LOOK FOR:\nAsk to see and verify that specifications are to the latest revision.                                                                              QUESTIONS TO ASK:\nHow do they maintain and assure they have the latest specifications on file?",null,1,{"$f":"IF(E118=\"NR/NA\",\"\",IF(E118>3,\"G\",IF(E118>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[93,"Have they completed the annual CQI-9 re-assessment audit? ","LOOK FOR:\nVerify revision date on CQI 9 audit. Review their CQI-9 action plan.\nQUESTIONS TO ASK:\nWhat procedure defines responsibility for completing the annual re-assessment and when it is performed? ",null,2,"R",2,2,4,2]
[94,"Is there a procedure that documents when and how a temperature uniformity survey is completed on a furnace?","LOOK FOR:\nVerify procedure and review a temperature uniformity survey that has been completed per the requirements. \nQUESTIONS TO ASK:\nWhat system is in place to verify that temperature uniformity surveys are always completed on time? Are temperature uniformity surveys completed to CQI-9 or AMS 2750 requirements?",null,3,"Y",3,3,4,3]
[95,"What procedure documents how questionable, deviated, rework or scrap material is handled in their facility?","LOOK FOR:\nVerify the material hold area is identified, proper tagging of material and proper documentation for disposition of material.\nQUESTIONS TO ASK:\nWho has authority to make determination of disposition of material? When does Allison Transmission get contacted?",null,4,"G",4,4,4,4]
[96,"Do laboratory procedures document how to complete lab evaluations for Allison parts?","LOOK FOR:\nLab procedures. Ask to see a lab evaluation completed on an Allison part.\nQUESTIONS TO ASK:\nWhere and for how long  are lab records stored? Could they generate past results if we had a problem in the field?",null,1,"R",1,1,4,1]
[97,"Are inspection requirements being completed and documented?","LOOK FOR:\nInspection documentation.                                         QUESTIONS TO ASK:\nHow are the inspectors trained on the procedures to perform part inspections and the proper method of completing documentation? Is SPC being used for process trending?",null,2,"R",2,2,4,2]
[98,"Are hardness machines clean, level and being  calibrated annually?","LOOK FOR:\nCalibration tags, machine level and clean. Review calibration procedure.\nQUESTIONS TO ASK:\nIf a machine fails annual calibration, what procedure documents what happens?",null,3,"Y",3,3,4,3]
[99,"Are hardness machines being verified per the proper ASTM requirements?","LOOK FOR:\nVerification documentation                                         QUESTIONS TO ASK:\nHow are inspection personnel trained on the procedure to perform inspections and documentation? What happens when a hardness machine does not pass a daily verification?  ",null,4,"G",4,4,4,4]
[100,"Who has responsible for process development and how is heat treat process documentation maintained?","LOOK FOR:\nHeat treat floor process documentation. All process parameters listed on process document.\nQUESTIONS TO ASK:\nWhat procedure controls process documentation, process changes, process change authority and proper sign off of manufacturing floor documentation that operations have been completed?",null,1,"R",1,1,4,1]
[101,"Are temperature instruments and  flows scopes  being calibrated every three months?","LOOK FOR:\nVerify at each furnace that calibrations are up to date.                                        QUESTIONS TO ASK:\nWhat procedure details this activity? Are thermal couples being changed out on a routine scheduled basis?",null,2,"R",2,2,4,2]
[102,"How are heat treat personnel trained and where are the training records stored?","LOOK FOR:\nTraining records. Look for furnace start up, shut down and other safety documentation at each furnace for operate aid.\nQUESTIONS TO ASK:\nSelect a random furnace operator or inspector and ask: How were you trained? How and where is your training documented?",null,3,"Y",3,3,4,3]
[103,"If the supplier uses a sub-tier for any heat treat operation, is the supplier on the Allison approved HT supplier listing?","LOOK FOR:\nEvidence sub-tier suppliers are on the Allison approved HT supplier listing.\nQUESTIONS TO ASK:\nDo you have suppliers that  provide HT for any of our parts?\nAsk the supplier to provide a listing of the sub-tier heat treat suppliers they use for Allison parts.",null,4,"G",{"$f":"IF(E129=\"NR/NA\",0,E129)","v":4},{"$f":"IF(E129=\"NR/NA\",5,E129)","v":4},{"$f":"IF(E129=\"NR/NA\",0,4)","v":4},{"$f":"IF(E129=\"NR/NA\",5,E129)","v":4}]
[null,"# Corrective Action Required =",{"$f":"IF(E130=\"NR/NA\",\"NR/NA\",COUNTIF(J118:J129,\"<3\"))","v":6},"SCORE / POTENTIAL",{"$f":"IF(H130=60,\"NR/NA\",SUM(G118:G129))","v":30},{"$f":"I130","v":48},{"$f":"SUM(G118:G129)","v":30},{"$f":"SUM(H118:H129)","v":30},48,30]
[null,"M. DISTRIBUTOR/WAREHOUSE","(If not required, leave score at \"NR\")"]
[104,"Are actual drawings available at the distributor/warehouse, and do they match the change level on the latest Allison Purchase Order?","LOOK FOR:\nDrawing, Material Spec Sheets, Allison P.O.\nQUESTIONS TO ASK:\nDo you have drawings?",null,1,{"$f":"IF(E132=\"NR/NA\",\"\",IF(E132>3,\"G\",IF(E132>2,\"Y\",\"R\")))","v":"R"},1,1,4,1]
[105,"Is there a log/computer record to confirm inventory movement?","LOOK FOR:\nDocument or database detailing inventory control. \nQUESTIONS TO ASK:\nWhat system is in place to control inventory?",null,2,"R",2,2,4,2]
[106,"Is a first in/first out (FIFO) system in use?","LOOK FOR:\nDocument or database detailing inventory control. \nShipping Label\nQUESTIONS TO ASK:\nHow is inventory managed to ensure FIFO is maintained?",null,3,"Y",3,3,4,3]
[107,"Is the facility secure?","LOOK FOR:\nGates, Key/Badge Coded Doors\nQUESTIONS TO ASK:\nCan anyone from the street walk into your facility?\nAre the factory exits propped open during the summer?",null,4,"G",4,4,4,4]
[108,"Is there an up-to-date quality manual?","LOOK FOR:\nQuality Manual\nQUESTIONS TO ASK:\nDo you have a quality manual?  What system do you have in place to keep it current?",null,1,"R",1,1,4,1]
[109,"Does the quality manual include a procedure for sorting?","LOOK FOR:\nQuality Manual, Sort Logs\nQUESTIONS TO ASK:\nWhat is your procedure for sorting material?  Is it documented?",null,2,"R",2,2,4,2]
[110,"Does the quality manual include a procedure for handling non-conforming material?","LOOK FOR:\nQuality Manual, Material Logs\nQUESTIONS TO ASK:\nWhat is your procedure for handling non-conforming material?  Is it documented?",null,3,"Y",3,3,4,3]
[111,"Does the quality manual include a procedure for storing process control plans or inspection data?","LOOK FOR:\nQuality Manual, Control Plans, Inspection Data\nQUESTIONS TO ASK:\nWhat is your procedure for handling process control plans and inspection data?  Is it documented?",null,4,"G",4,4,4,4]
[112,"Does the quality manual include a flow chart of how the warehouse is notified of problems from their suppliers?","LOOK FOR:\nProblem Log\nFlow Chart\nQUESTIONS TO ASK:\nDoes an escalation process exist to quickly communicate to the appropriate level within the organization and ensure that support and action plans are followed?",null,1,"R",1,1,4,1]
[113,"Is the building condition adequate (Roof leaks, Air & Heating, Floor, etc.)?","LOOK FOR:\nGeneral condition of building and any signs of problems.\nQUESTIONS TO ASK:\nWho handles the building maintenance?  Is the building on a PM schedule?",null,2,"R",2,2,4,2]
[114,"Is there a minimum of one month of inventory on hand?","LOOK FOR:\nDocument or database detailing inventory control. \nQUESTIONS TO ASK:\nWhat system is in place to manage inventory vs. customer requirements?",null,3,"Y",{"$f":"IF(E142=\"NR/NA\",0,E142)","v":3},{"$f":"IF(E142=\"NR/NA\",5,E142)","v":3},{"$f":"IF(E142=\"NR/NA\",0,4)","v":4},{"$f":"IF(E142=\"NR/NA\",5,E142)","v":3}]
[115,"Is PPAP documentation available?","LOOK FOR:\nPSW, Supporting PPAP documentation\nQUESTIONS TO ASK:\nAllison retains only the PSW, show me all of your approved warrants and all of the supporting documents.",null,4,{"$f":"IF(E143=\"NR/NA\",\"\",IF(E143>3,\"G\",IF(E143>2,\"Y\",\"R\")))","v":"G"},4,4,4,4]
[116,"Does the capability exist to load a semi-truck?","LOOK FOR:\nFork Lift, Hand Fork\nQUESTIONS TO ASK:\nHow do you load trucks?  Are your lift operators trained to operate the equipment?",null,1,"R",1,1,4,1]
[117,"Can the Allison online Supplier Quality system be accessed?","LOOK FOR:\nOn-line access\nQUESTIONS TO ASK:\nShow me how you access the SQN system.",null,2,"R",2,2,4,2]
[118,"Can the warehouse re-package parts from sea containers to returnable containers if needed?","LOOK FOR:\n\"Clean\" Area\nQUESTIONS TO ASK:\nHow do you prevent damage/contamination during repackaging?  How do you prevent mixing parts?",null,3,"Y",3,3,4,3]
[119,"Can the warehouse print the appropriate shipping labels when repackaging is needed?","LOOK FOR:\nDocument or database detailing inventory control, Printer\nShipping Label\nQUESTIONS TO ASK:\nWhat system is in place to control inventory and labeling?",null,4,"G",4,4,4,4]
[120,"Can the warehouse prepare the appropriate shipping paperwork (packing slips, bills of lading, etc.)","LOOK FOR:\nDocument or database detailing inventory control, Printer\nShipping Label\nQUESTIONS TO ASK:\nWhat system is in place to control inventory and labeling?",null,1,"R",1,1,4,1]
[null,"# Corrective Action Required =",{"$f":"IF(E149=\"NR/NA\",\"NR/NA\",COUNTIF(J132:J148,\"<3\"))","v":9},"SCORE / POTENTIAL",{"$f":"IF(H149=85,\"NR/NA\",SUM(G132:G148))","v":41},{"$f":"I149","v":68},{"$f":"SUM(G132:G148)","v":41},{"$f":"SUM(H132:H148)","v":41},68,41]
[]
[null,null,"ELEMENT SCORING"]
[null,0,"  0 - Element is not in place and no evidence of plans to implement: Corrective Action Required"]
[null,1,"  1 - Element is not in place but a plan to implement is documented: Corrective Action Required"]
[null,2,"  2 - Element is in place but it is not being followed: Corrective Action Required."]
[null,3,"  3 - YELLOW: Element is satisfactory, but continuous improvement should be applied."]
[null,4,"  4 - GREEN: Element is in place and it is being followed"]
[null,"nr/na","NR/NA - Didn't Audit / Not Applicable"]
[null,"Note: Enter appropriate score based on R Y G score criteria and hit enter.  Correct color will appear in R/Y/G cell."]
[]
[null,"Auditor Comments:"]

{"sheet":"Summary","index":2,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[116,2,116,5],[116,6,116,7],[78,1,78,6],[48,1,48,6],[57,1,57,6],[71,1,71,6],[115,2,115,5],[104,2,104,5],[104,6,104,7],[0,1,0,6],[12,1,12,6],[18,1,18,6],[26,1,26,6],[33,1,33,6],[6,1,6,6],[40,1,40,6],[64,1,64,6],[110,2,110,5],[113,2,113,5],[114,2,114,5],[86,1,86,6],[103,2,103,5],[105,2,105,5],[106,2,106,5],[102,6,102,7],[103,6,103,7],[105,6,105,7],[106,6,106,7],[112,2,112,5],[112,6,112,7],[96,1,96,6],[125,1,125,6],[119,0,119,5],[107,6,107,7],[108,6,108,7],[109,6,109,7],[110,6,110,7],[111,6,111,7],[113,6,113,7],[117,6,117,7],[111,2,111,5],[114,6,114,7],[115,6,115,7],[117,2,117,5],[107,2,107,5],[108,2,108,5],[109,2,109,5]]}
[null,{"$f":"Audit!B4","v":"A.  TECHNICAL INFORMATION AVAILABILITY"}]
[null,"1.  ACTUAL DRAWING",{"$f":"Audit!E5","v":1},"2. Sched. Agree. Revision Level",{"$f":"Audit!E6","v":2},"3. Full PPAP Documentation",{"$f":"Audit!E7","v":3}]
[null,"4. Technical Specifications",{"$f":"Audit!E8","v":4}]
[]
[null,"Score",{"$f":"Audit!E9","v":10},"Potential",{"$f":"Audit!F9","v":16},"Percentage",{"$f":"'Cover Sheet'!G36","v":0.625}]
[]
[null,{"$f":"Audit!B10","v":"B.  CHANGE CONTROL"}]
[null,"5.  Revision Levels Agree",{"$f":"Audit!E11","v":1},"6.  Change Mgmt System",{"$f":"Audit!E12","v":2},"7.  Sub Tier PPAP",{"$f":"Audit!E13","v":3}]
[null,"8.  Document Change Control",{"$f":"Audit!E14","v":4}]
[]
[null,"Score",{"$f":"Audit!E17","v":1},"Potential",{"$f":"Audit!F15","v":16},"Percentage",{"$f":"'Cover Sheet'!G37","v":0.625}]
[]
[null,{"$f":"Audit!B16","v":"C.  PROCESS FLOW DIAGRAM"}]
[null,"9. PFD Available",{"$f":"Audit!E17","v":1},"10. Workplace Match PFD",{"$f":"Audit!E18","v":2},"11. PFD Receiving",{"$f":"Audit!E19","v":3}]
[null,"12. PFD Rework",{"$f":"Audit!E20","v":4},"13. PFD Gauging and Inspection",{"$f":"Audit!E21","v":1},"14.  PFD Shipping",{"$f":"Audit!E22","v":2}]
[]
[null,"Score",{"$f":"Audit!E23","v":13},"Potential",{"$f":"Audit!F23","v":24},"Percentage",{"$f":"'Cover Sheet'!G38","v":0.54166666666666663}]
[]
[null,{"$f":"Audit!B24","v":"D.  PFMEA / PCP"}]
[null,"15. PFMEA Available",{"$f":"Audit!E25","v":1},"16. Evidence PFMEA Up to Date",{"$f":"Audit!E26","v":2},"17. PFMEA Acceptable",{"$f":"Audit!E27","v":3}]
[null,"18. RPN's Consistent",{"$f":"Audit!E28","v":4},"19. Continuous Improvement",{"$f":"Audit!E29","v":1},"20. PCP Available",{"$f":"Audit!E30","v":2}]
[null,"21. PCP Acceptable",{"$f":"Audit!E31","v":3},"22. Controls on PFMEA and PCP",{"$f":"Audit!E32","v":4},"23.  Special Chars. On PCP",{"$f":"Audit!E33","v":1}]
[null,"24.  Inspection Frequencies",{"$f":"Audit!E34","v":2},"25.  Sample Size and Frequency",{"$f":"Audit!E35","v":3}]
[]
[null,"Score",{"$f":"Audit!E36","v":26},"Potential",{"$f":"Audit!F36","v":44},"Percentage",{"$f":"'Cover Sheet'!G39","v":0.59090909090909094}]
[]
[null,{"$f":"Audit!B37","v":"E.  STANDARDIZED OPERATIONS & TRAINING"}]
[null,"26. Proper Operator Instructions",{"$f":"Audit!E38","v":1},"27. Detailed Work Instructions",{"$f":"Audit!E39","v":2},"28. Standardized Work Followed",{"$f":"Audit!E40","v":3}]
[null,"29. Instructions Understood",{"$f":"Audit!E41","v":4},"30. Operators Trained",{"$f":"Audit!E42","v":1},"31. WIP for Final Product",{"$f":"Audit!E43","v":2}]
[null,"32. Parts and Components Label",{"$f":"Audit!E44","v":3}]
[]
[null,"Score",{"$f":"Audit!E45","v":16},"Potential",{"$f":"Audit!F45","v":28},"Percentage",{"$f":"'Cover Sheet'!G40","v":0.5714285714285714}]
[]
[null,{"$f":"Audit!B46","v":"F.  GAGING"}]
[null,"33. Tools and Gauges Identified",{"$f":"Audit!E47","v":1},"34. Gauges Calibrated",{"$f":"Audit!E48","v":2},"35. Periodic Gage MSA",{"$f":"Audit!E49","v":3}]
[null,"36. Reaction to MSA Results",{"$f":"Audit!E50","v":4},"37. Proper Operator Instructions",{"$f":"Audit!E51","v":1},"38.  Gaging Method Proper",{"$f":"Audit!E52","v":2}]
[null,"39. Boundary Samples",{"$f":"Audit!E53","v":3},"40.  Error Proof Verification",{"$f":"Audit!E54","v":4},"41.  Master Parts Available",{"$f":"Audit!E55","v":1}]
[]
[null,"Score",{"$f":"Audit!E56","v":21},"Potential",{"$f":"Audit!F56","v":36},"Percentage",{"$f":"'Cover Sheet'!G41","v":0.58333333333333337}]
[]
[null,{"$f":"Audit!B57","v":"G.  PROCESS CONTROLS"}]
[null,"42. Approved Material List",{"$f":"Audit!E58","v":1},"43. Incoming Material Controls",{"$f":"Audit!E59","v":2},"44. Parts have Traceability",{"$f":"Audit!E60","v":3}]
[null,"45. SPC Data",{"$f":"Audit!E61","v":4},"46. UCL & LCL",{"$f":"Audit!E62","v":1},"47. Reasonable Control Limits",{"$f":"Audit!E63","v":2}]
[null,"48.  PCP Checks",{"$f":"Audit!E64","v":3},"49.  Deviation Actions",{"$f":"Audit!E65","v":4},"50. Product Audits",{"$f":"Audit!E66","v":1}]
[null,"51. Capability Studies",{"$f":"Audit!E67","v":2},"52. Packaging and Handling",{"$f":"Audit!E68","v":3}]
[]
[null,"Score",{"$f":"Audit!E69","v":26},"Potential",{"$f":"Audit!F69","v":44},"Percentage",{"$f":"'Cover Sheet'!G42","v":0.59090909090909094}]
[]
[null,{"$f":"Audit!B70","v":"H.  MANAGEMENT SYSTEM"}]
[null,"53.  Safety Procedure",{"$f":"Audit!E71","v":1},"54.  Visitor Safety Protocol",{"$f":"Audit!E72","v":2},"55.  PM Program",{"$f":"Audit!E73","v":3}]
[null,"56.  Critical Machine Listing",{"$f":"Audit!E74","v":4},"57.  Downtime, Scrap, Prem. Fgt.",{"$f":"Audit!E75","v":1},"58.  Internal/External Prob. Rep.",{"$f":"Audit!E76","v":2}]
[null,"59. Out of Control Conditions",{"$f":"Audit!E77","v":3},"60. Action Plans Followed",{"$f":"Audit!E78","v":4},"61. Implementation Resp",{"$f":"Audit!E79","v":1}]
[null,"62. Problem Communication",{"$f":"Audit!E80","v":2},"63. Information Across all Shifts",{"$f":"Audit!E81","v":3},"64. Layered Audit System",{"$f":"Audit!E82","v":4}]
[null,"65. Continuous Improvement",{"$f":"Audit!E83","v":1}]
[]
[null,"Score",{"$f":"Audit!E86","v":33},"Potential",{"$f":"Audit!F86","v":60},"Percentage",{"$f":"'Cover Sheet'!G43","v":0.55000000000000004}]
[]
[null,{"$f":"Audit!B87","v":"I.  CONTAMINATION CONTROL"}]
[null,"66. Contamination Procedures",{"$f":"Audit!E88","v":1},"67. WIP Protection",{"$f":"Audit!E89","v":2},"68. Adequate Dunnage",{"$f":"Audit!E90","v":3}]
[null,"69. Washer PM",{"$f":"Audit!E91","v":4},"70. Washer Parameters",{"$f":"Audit!E92","v":1},"71.  TIS-5750/5751 Performed",{"$f":"Audit!E93","v":2}]
[null,"72. TIS-5750/5751 Meet Spec.",{"$f":"Audit!E94","v":3},"73. TIS-5750/5751 Results Reviewed",{"$f":"Audit!E95","v":4},"74. TIS-5750/5751 Result Actions",{"$f":"Audit!E96","v":1}]
[]
[null,"Score",{"$f":"Audit!E97","v":21},"Potential",{"$f":"Audit!F97","v":36},"Percentage",{"$f":"'Cover Sheet'!G44","v":0.58333333333333337}]
[]
[null,{"$f":"Audit!B98","v":"J. LABELING"}]
[null,"75.  Latest Labeling Docs",{"$f":"Audit!E99","v":1},"76. Bar Codes Legible",{"$f":"Audit!E100","v":2},"77.  GM Labeling Removed",{"$f":"Audit!E101","v":3}]
[null,"78.  Old Labels Removed",{"$f":"Audit!E102","v":4},"79. Cert. Mat'l Labels",{"$f":"Audit!E103","v":1},"80.  Labeling Process",{"$f":"Audit!E104","v":2}]
[null,"81.  Shipping Address",{"$f":"Audit!E105","v":3},"82.  Correct Label Size/Place",{"$f":"Audit!E106","v":4}]
[]
[null,"Score",{"$f":"Audit!E107","v":20},"Potential",{"$f":"Audit!F107","v":32},"Percentage",{"$f":"'Cover Sheet'!G45","v":0.625}]
[]
[null,{"$f":"Audit!B108","v":"K.  LEAK TESTING"}]
[null,"83. Testing Matches Print",{"$f":"Audit!E109","v":1},"84. Parameters Meet Spec",{"$f":"Audit!E110","v":2},"85. Correct Areas Tested",{"$f":"Audit!E111","v":3}]
[null,"86. Part ID After Test",{"$f":"Audit!E112","v":4},"87. Containment of Failed Parts",{"$f":"Audit!E113","v":1},"88. Leak Test Master Samples",{"$f":"Audit!E114","v":2}]
[null,"89. Leak Tester Mastered",{"$f":"Audit!E115","v":3}]
[]
[null,"Score",{"$f":"Audit!E116","v":16},"Potential",{"$f":"Audit!F116","v":28},"Percentage",{"$f":"'Cover Sheet'!G46","v":0.5714285714285714}]
[]
[null,{"$f":"Audit!B117","v":"L. HEAT TREATING"}]
[null,"90.  Allison Specs",{"$f":"Audit!E118","v":1},"91.  CQI-9 Audit",{"$f":"Audit!E119","v":2},"92. Temp Uniformity Survey",{"$f":"Audit!E120","v":3}]
[null,"93.  Handling Suspect Material",{"$f":"Audit!E121","v":4},"94.  Allison Lab Evaluation",{"$f":"Audit!E122","v":1},"95.  Inspection Requirements",{"$f":"Audit!E123","v":2}]
[null,"96.  Hardness Tester Condition",{"$f":"Audit!E124","v":3},"97.  Hardness Tester Certified",{"$f":"Audit!E125","v":4},"98.  Process Documentation",{"$f":"Audit!E126","v":1}]
[null,"99.  Instrument Calibration",{"$f":"Audit!E127","v":2},"100.  Training",{"$f":"Audit!E128","v":3},"101.  Sub-Tier HT Approved",{"$f":"Audit!E129","v":4}]
[]
[null,"Score",{"$f":"Audit!E130","v":30},"Potential",{"$f":"Audit!F130","v":48},"Percentage",{"$f":"'Cover Sheet'!G47","v":0.625}]
[]
[null,{"$f":"Audit!B131","v":"M. DISTRIBUTOR/WAREHOUSE"}]
[null,"102.  Current Drawing",{"$f":"Audit!E132","v":1},"103.  Inventory Movement",{"$f":"Audit!E133","v":2},"104.  FIFO System",{"$f":"Audit!E134","v":3}]
[null,"105.  Secure Facility",{"$f":"Audit!E135","v":4},"106.  Quality Manual",{"$f":"Audit!E136","v":1},"107.  Sorting Procedure",{"$f":"Audit!E137","v":2}]
[null,"108.  Non-Conforming Procedure",{"$f":"Audit!E138","v":3},"109.  PCP/Data Procedure",{"$f":"Audit!E139","v":4},"110.  Problem Notification",{"$f":"Audit!E140","v":1}]
[null,"111.  Building Condition",{"$f":"Audit!E141","v":2},"112.  Min/Max Inventory Levels",{"$f":"Audit!E142","v":3},"113.  PPAP Documentation",{"$f":"Audit!E143","v":4}]
[null,"114.  Truck Loading",{"$f":"Audit!E144","v":1},"115.  SQN System",{"$f":"Audit!E145","v":2},"116.  Repackage Parts",{"$f":"Audit!E146","v":3}]
[null,"117.  Shipping Labels",{"$f":"Audit!E147","v":4},"118.  Shipping Paperwork",{"$f":"Audit!E148","v":1}]
[]
[null,"Score",{"$f":"Audit!E149","v":41},"Potential",{"$f":"Audit!F149","v":68},"Percentage",{"$f":"'Cover Sheet'!G48","v":0.6029411764705882}]
[]
[null,{"$f":"'Tooling Audit Form Sec1'!B5","v":"N. TOOLING AUDIT SECTION 1"}]
[null,"M1. ATI Tooling Maintenance",{"$f":"'Tooling Audit Form Sec1'!E6","v":1},"M2. Tooling Identification",{"$f":"'Tooling Audit Form Sec1'!E7","v":2},"M3. Tool Life Tracking",{"$f":"'Tooling Audit Form Sec1'!E8","v":3}]
[null,"M4. Repair/Replace Notification",{"$f":"'Tooling Audit Form Sec1'!E9","v":4}]
[]
[null,"Score",{"$f":"'Tooling Audit Form Sec1'!E10","v":10},"Potential",{"$f":"'Tooling Audit Form Sec1'!F10","v":16},"Percentage",{"$f":"'Cover Sheet'!G49","v":0.625}]
[]
[null,null,null,null,null,null,"Score",null,"Potential"]
[{"$f":"'Cover Sheet'!H36","v":"R"},{"$f":"'Cover Sheet'!G36","v":0.625},{"$f":"B1","v":"A.  TECHNICAL INFORMATION AVAILABILITY"},null,null,null,{"$f":"'Cover Sheet'!F36","v":10},null,{"$f":"'Cover Sheet'!E36","v":16}]
[{"$f":"'Cover Sheet'!H37","v":"R"},{"$f":"'Cover Sheet'!G37","v":0.625},{"$f":"B2","v":"1.  ACTUAL DRAWING"},null,null,null,{"$f":"'Cover Sheet'!F37","v":10},null,{"$f":"'Cover Sheet'!E37","v":16}]
[{"$f":"'Cover Sheet'!H38","v":"R"},{"$f":"'Cover Sheet'!G38","v":0.54166666666666663},{"$f":"B7","v":"B.  CHANGE CONTROL"},null,null,null,{"$f":"'Cover Sheet'!F38","v":13},null,{"$f":"'Cover Sheet'!E38","v":24}]
[{"$f":"'Cover Sheet'!H39","v":"R"},{"$f":"'Cover Sheet'!G39","v":0.59090909090909094},{"$f":"B19","v":"D.  PFMEA / PCP"},null,null,null,{"$f":"'Cover Sheet'!F39","v":26},null,{"$f":"'Cover Sheet'!E39","v":44}]
[{"$f":"'Cover Sheet'!H40","v":"R"},{"$f":"'Cover Sheet'!G40","v":0.5714285714285714},{"$f":"B27","v":"E.  STANDARDIZED OPERATIONS & TRAINING"},null,null,null,{"$f":"'Cover Sheet'!F40","v":16},null,{"$f":"'Cover Sheet'!E40","v":28}]
[{"$f":"'Cover Sheet'!H41","v":"R"},{"$f":"'Cover Sheet'!G41","v":0.58333333333333337},{"$f":"B34","v":"F.  GAGING"},null,null,null,{"$f":"'Cover Sheet'!F41","v":21},null,{"$f":"'Cover Sheet'!E41","v":36}]
[{"$f":"'Cover Sheet'!H42","v":"R"},{"$f":"'Cover Sheet'!G42","v":0.59090909090909094},{"$f":"B41","v":"G.  PROCESS CONTROLS"},null,null,null,{"$f":"'Cover Sheet'!F42","v":26},null,{"$f":"'Cover Sheet'!E42","v":44}]
[{"$f":"'Cover Sheet'!H43","v":"R"},{"$f":"'Cover Sheet'!G43","v":0.55000000000000004},{"$f":"B49","v":"H.  MANAGEMENT SYSTEM"},null,null,null,{"$f":"'Cover Sheet'!F43","v":33},null,{"$f":"'Cover Sheet'!E43","v":60}]
[{"$f":"'Cover Sheet'!H44","v":"R"},{"$f":"'Cover Sheet'!G44","v":0.58333333333333337},{"$f":"B58","v":"I.  CONTAMINATION CONTROL"},null,null,null,{"$f":"'Cover Sheet'!F44","v":21},null,{"$f":"'Cover Sheet'!E44","v":36}]
[{"$f":"'Cover Sheet'!H45","v":"R"},{"$f":"'Cover Sheet'!G45","v":0.625},"I.  LABELING",null,null,null,{"$f":"'Cover Sheet'!F45","v":20},null,{"$f":"'Cover Sheet'!E45","v":32}]
[{"$f":"'Cover Sheet'!H46","v":"R"},{"$f":"'Cover Sheet'!G46","v":0.5714285714285714},{"$f":"B72","v":"K.  LEAK TESTING"},null,null,null,{"$f":"'Cover Sheet'!F46","v":16},null,{"$f":"'Cover Sheet'!E46","v":28}]
[{"$f":"'Cover Sheet'!H47","v":"R"},{"$f":"'Cover Sheet'!G47","v":0.625},{"$f":"B79","v":"L. HEAT TREATING"},null,null,null,{"$f":"'Cover Sheet'!F47","v":30},null,{"$f":"'Cover Sheet'!E47","v":48}]
[{"$f":"'Cover Sheet'!H48","v":"R"},{"$f":"'Cover Sheet'!G48","v":0.6029411764705882},{"$f":"B87","v":"M. DISTRIBUTOR/WAREHOUSE"},null,null,null,{"$f":"'Cover Sheet'!F48","v":41},null,{"$f":"'Cover Sheet'!E48","v":68}]
[{"$f":"'Cover Sheet'!H49","v":"R"},{"$f":"'Cover Sheet'!G49","v":0.625},{"$f":"B97","v":"N. TOOLING AUDIT SECTION 1"},null,null,null,{"$f":"'Cover Sheet'!F49","v":10},null,{"$f":"'Cover Sheet'!E49","v":16}]
[{"$f":"'Cover Sheet'!G51","v":"R"},{"$f":"'Cover Sheet'!G50","v":0.59072580645161288},"OVERALL",null,null,null,{"$f":"'Cover Sheet'!F50","v":293},null,{"$f":"'Cover Sheet'!E50","v":496}]
[]
["ELEMENT SCORING"]
[{"$f":"IF(MIN(E109:E119)=3,\"G\", IF(MIN(E109:E119)=2, \"Y\",\"R\"))","v":"R"},"  0 - Element is not in place and no evidence of plans to implement: Corrective Action Required"]
[{"$f":"IF(MIN(E110:E120)=3,\"G\", IF(MIN(E110:E120)=2, \"Y\",\"R\"))","v":"R"},"  1 - Element is not in place but a plan to implement is documented: Corrective Action Required"]
[{"$f":"IF(MIN(E112:E121)=3,\"G\", IF(MIN(E112:E121)=2, \"Y\",\"R\"))","v":"R"},"  2 - Element is in place but it is not being followed: Corrective Action Required."]
["Y","  3 - YELLOW: Element is satisfactory, but continuous improvement should be applied."]
["G","  4 - GREEN: Element is in place and it is being followed"]
["NR/NA","  NR/NA - Didn't Audit / Not Applicable"]
[null,"Note:  Status and Code entered automatically from audit sheet.."]

{"sheet":"Tooling Audit Form Sec1","index":3,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,5],[0,1,0,5],[1,1,1,5]]}
[null,"Allison Transmission, Inc."]
[null,"Supplier Quality Tooling Audit Form Section 1"]
[null,"This audit form is intended for use in review of both Allison Transmission, Inc. (ATI) owned tooling AND Government owned tooling related to contracts between the Government and ATI located at ATI's suppliers facility(ies) and/or sub-tiered suppliers.  The word \"tool\" refers to any piece of ATI or government owned equipment necessary to manufacturing and/or qualify material for supply to ATI (ie. tooling, fixturing, gaging, etc)."]
[]
[null,"N. TOOLING AUDIT SECTION 1","(If not required, leave score at \"NR\")"]
["M1","Is there a process in place to ensure ATI owned tooling is properly maintained?","LOOK FOR:\nPM plan, reaction plan, tool room and tool storage conditions and procedures\nQUESTIONS TO ASK:\nWhat is your method for maintaining customer owned tooling?  \nHow do you determine how long run tools during each production run?\nHow are tools stored when not being used for production?\nNOTE: This applies to government owned tooling as well.",null,1,{"$f":"IF(E6=\"NR/NA\",\"\",IF(E6>3,\"G\",IF(E6>2,\"Y\",\"R\")))","v":"R"},{"$f":"IF(E6=\"NR/NA\",0,E6)","v":1},{"$f":"IF(E6=\"NR/NA\",5,E6)","v":1},{"$f":"IF(E6=\"NR/NA\",0,4)","v":4},{"$f":"IF(E6=\"NR/NA\",5,E6)","v":1}]
["M2","Have ATI owned tools been permanently marked as prescribed in the original tooling P.O.?","LOOK FOR:\nA permanent marking on the tool identifying as ATI property.\nIf tool has multiple sections, cavities, or subcomponents, all must be permanently identified as ATI property.\nNOTE: Governement owned tooling should be permanently identified in accordance with current Federal Acquisition Regulations (FAR) 45.506",null,2,"R",2,2,4,2]
["M3","Is there a process for tracking tool usage, cycle count, estimated tool life remaining, and current condition?","LOOK FOR:\nProduction database, tool life tracking method, tooling responsible engineers\nQUESTIONS TO ASK:\nDo you have a method for tracking total cycles/shots/hits/strokes?  Does this include a delineated amount due to scrap?\nDo you have a method for tracking how often and for how long a tool is run to support production?\nHow was the initial estimated tool life calculated?  Is this number still appropriate?  Do you know the current remaining tool life?\nIs there an in process and last article review of tooling condition?\n",null,3,"Y",3,3,4,3]
["M4","Is there a process for timely notification to ATI in the event major tooling maintenance or replacement is necessary?","LOOK FOR:\nFamiliarity with ATI tool replacement and tooling $ guidelines\nQUESTIONS TO ASK:\nHow do you determine when a tool needs replaced? \nHow much lead time do you provide customers with when tooling replacement is necessary?\nDo you understand the typical lead times to receiving payment from ATI for tooling maintenance and replacement?",null,4,"G",4,4,4,4]
[null,"# Corrective Action Required =",{"$f":"IF(E10=\"NR/NA\",\"NR/NA\",COUNTIF(J6:J9,\"<3\"))","v":2},"SCORE / POTENTIAL",{"$f":"IF(H10=20,\"NR/NA\",SUM(G6:G9))","v":10},{"$f":"I10","v":16},{"$f":"SUM(G6:G9)","v":10},{"$f":"SUM(H6:H9)","v":10},{"$f":"SUM(I6:I9)","v":16},{"$f":"SUM(J6:J9)","v":10}]

{"sheet":"Tooling Audit Form Sec2","index":4,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[14,11,15,11],[14,12,14,16],[7,1,7,8],[8,1,9,8],[10,1,11,8],[12,1,12,8],[14,6,15,6],[14,0,14,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[0,0,0,17],[1,0,1,17],[2,0,3,16],[34,9,34,12],[14,5,15,5],[5,9,8,9],[5,10,8,17],[9,9,11,9],[9,10,11,17],[12,10,12,17],[5,1,6,8],[14,17,15,17],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10]]}
["Allison Transmission, Inc."]
["Supplier Quality Tooling Audit Form Section 2"]
["This audit form is intended for use in review of both Allison Transmission, Inc. (ATI) owned tooling AND Government owned tooling related to contracts between the Government and ATI located at ATI's suppliers facility(ies) and/or\nsub-tiered suppliers.  The word \"tool\" refers to both tooling and gaging equipment.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Good"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poor "]
["      Section 2 Guidelines and Instructions: ",null,null,null,null,null,null,null,null,"Tooling Condition Descriptions:",null,null,null,null,null,null,null,null,"Worn Out"]
["1 - ","The SQE is to inform the ATI Purchasing Capital and Tooling Management group of the vendor being visited so that they may generate the appropriate list.  This list will populate the cells under the gray header. ",null,null,null,null,null,null,null,"Good","The tool is fully functional and in good condition.  (IE: Fixtures must hold part sound and secure. Gages must be certified annually (minimum).  Specific Cutting Tools must be cutting the dimension it's designed for.  Casting tools dimensionally correct with very minimal heat check tracks.  Dies have minimal 'break burr's and cutting sections sharpened regularly. )"]
[]
["2 - ","At a minimum, cells highlighted in red must be completed for each tool reviewed.  "]
["3 - ","If the tooling is not located at the supplier shown in the \"Current Vendor\" cell, then the information requested in the cells under \"Actual, Physical Tool Location\" must be provided."]
[null,null,null,null,null,null,null,null,null,"Poor","The tool is showing some excessive wear. (IE: Fixtures - part moving around while clamped, Gages - difficult to certify, Specific Cutting Tools - not able to cut the dimension its designed for. Dies - excessive break burr, not 'capable' to repeat forms.)"]
["4 - ","If the condition of the tool is noted as anything other than \"Good\", elaboration is required in the Additional Comments cell."]
[]
["5 - ","If pictures of the tooling are attached, note this in the Additional Comments section.",null,null,null,null,null,null,null,"Worn Out","Tool incapable of running a dimensional correct part., >20% scrap, etc"]
[]
["Current Vendor",null,"Part Nbr","PO \nNbr","Asset #","Description of Tool","Acqd \nDate","Line \nItem","# of \ntools","Condition","Date \nLast Used","Remaining\nUseful life","Actual, Physical Tool Location  (If not at current vendor listed)",null,null,null,null,"Additional Comments"]
["Code","Name",null,null,null,null,null,null,null,null,null,null,"Company"," Street  ","City","State","Zip",null,{"$f":"COUNTA(A17,J17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J17=\"Good\",1,IF(J17=\"\",1,IF(R17=\"\",2,1)))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J18=\"Good\",1,IF(J18=\"\",1,IF(R18=\"\",2,1)))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["COMMENTS:"]

{"sheet":"Dock Audit","index":5,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,2,59,3],[0,1,0,5],[1,1,1,5],[2,1,2,5],[3,1,3,3],[5,1,5,3],[57,2,57,3]]}
[null,"Allison Transmission",null,null,null,null,{"$f":"COUNTA(B6)+COUNTA(C56)","v":0},{"$f":"'Cover Sheet'!C22","v":0}]
[null,"Supplier Quality Product  Audit Form",null,null,null,null,null,"Other (specify in Auditor Comments)"]
[null,"Single measurement"]
["Supplier:",{"$f":"'Cover Sheet'!C7","v":0},null,null,"Vendor Code:",{"$f":"'Cover Sheet'!C9","v":0}]
[null,null,null,null,"Date:",{"$f":"'Cover Sheet'!I19","v":"00:00:00"}]
["Part Audited:",null,null,null,"SQE:",{"$f":"'Cover Sheet'!C17","v":0}]
[]
["Dimension","   "]
["Upper Spec"]
["Lower Spec"]
[null,1,2,3,4,5]
[1]
[2,"   "]
[3,"   "]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
["Average",{"$f":"IF(B9=\"\",\"\",AVERAGE(B12:B41))","v":""},{"$f":"IF(C9=\"\",\"\",AVERAGE(C12:C41))","v":""},{"$f":"IF(D9=\"\",\"\",AVERAGE(D12:D41))","v":""},{"$f":"IF(E9=\"\",\"\",AVERAGE(E12:E41))","v":""},{"$f":"IF(F9=\"\",\"\",AVERAGE(F12:F41))","v":""}]
["Max reading",{"$f":"IF(B9=\"\",\"\",MAX(B12:B41))","v":""},{"$f":"IF(C9=\"\",\"\",MAX(C12:C41))","v":""},{"$f":"IF(D9=\"\",\"\",MAX(D12:D41))","v":""},{"$f":"IF(E9=\"\",\"\",MAX(E12:E41))","v":""},{"$f":"IF(F9=\"\",\"\",MAX(F12:F41))","v":""}]
["Min reading",{"$f":"IF(B9=\"\",\"\",MIN(B12:B41))","v":""},{"$f":"IF(C9=\"\",\"\",MIN(C12:C41))","v":""},{"$f":"IF(D9=\"\",\"\",MIN(D12:D41))","v":""},{"$f":"IF(E9=\"\",\"\",MIN(E12:E41))","v":""},{"$f":"IF(F9=\"\",\"\",MIN(F12:F41))","v":""}]
["Range",{"$f":"IF(B9=\"\",\"\",(B43-B44))","v":""},{"$f":"IF(C9=\"\",\"\",(C43-C44))","v":""},{"$f":"IF(D9=\"\",\"\",(D43-D44))","v":""},{"$f":"IF(E9=\"\",\"\",(E43-E44))","v":""},{"$f":"IF(F9=\"\",\"\",(F43-F44))","v":""}]
["Standard Dev (σ)",{"$f":"IF(B9=\"\",\"\",STDEV(B12:B41))","v":""},{"$f":"IF(C9=\"\",\"\",STDEV(C12:C41))","v":""},{"$f":"IF(D9=\"\",\"\",STDEV(D12:D41))","v":""},{"$f":"IF(E9=\"\",\"\",STDEV(E12:E41))","v":""},{"$f":"IF(F9=\"\",\"\",STDEV(F12:F41))","v":""}]
["3σ",{"$f":"IF(B9=\"\",\"\",(B46*3))","v":""},{"$f":"IF(C9=\"\",\"\",(C46*3))","v":""},{"$f":"IF(D9=\"\",\"\",(D46*3))","v":""},{"$f":"IF(E9=\"\",\"\",(E46*3))","v":""},{"$f":"IF(F9=\"\",\"\",(F46*3))","v":""}]
["6σ",{"$f":"IF(B10=\"\",\"\",(B46*6))","v":""},{"$f":"IF(C10=\"\",\"\",(C46*6))","v":""},{"$f":"IF(D10=\"\",\"\",(D46*6))","v":""},{"$f":"IF(E10=\"\",\"\",(E46*6))","v":""},{"$f":"IF(F10=\"\",\"\",(F46*6))","v":""}]
["Pp",{"$f":"IF(B9=\"\",\"\",((B9-B10)/B48))","v":""},{"$f":"IF(C9=\"\",\"\",((C9-C10)/C48))","v":""},{"$f":"IF(D9=\"\",\"\",((D9-D10)/D48))","v":""},{"$f":"IF(E9=\"\",\"\",((E9-E10)/E48))","v":""},{"$f":"IF(F9=\"\",\"\",((F9-F10)/F48))","v":""}]
["Ppu",{"$f":"IF(B9=\"\",\"\",((B9-B42)/B47))","v":""},{"$f":"IF(C9=\"\",\"\",((C9-C42)/C47))","v":""},{"$f":"IF(D9=\"\",\"\",((D9-D42)/D47))","v":""},{"$f":"IF(E9=\"\",\"\",((E9-E42)/E47))","v":""},{"$f":"IF(F9=\"\",\"\",((F9-F42)/F47))","v":""}]
["Ppl",{"$f":"IF(B9=\"\",\"\",((B42-B10)/B47))","v":""},{"$f":"IF(C9=\"\",\"\",((C42-C10)/C47))","v":""},{"$f":"IF(D9=\"\",\"\",((D42-D10)/D47))","v":""},{"$f":"IF(E9=\"\",\"\",((E42-E10)/E47))","v":""},{"$f":"IF(F9=\"\",\"\",((F42-F10)/F47))","v":""}]
["Ppk",{"$f":"IF(B9=\"\",\"\",MIN(B50:B51))","v":""},{"$f":"IF(C9=\"\",\"\",MIN(C50:C51))","v":""},{"$f":"IF(D9=\"\",\"\",MIN(D50:D51))","v":""},{"$f":"IF(E9=\"\",\"\",MIN(E50:E51))","v":""},{"$f":"IF(F9=\"\",\"\",MIN(F50:F51))","v":""}]
[null,null,null,null,null,"Yes"]
["For capability, a minimum of a thirty (30) piece sample should be taken",null,null,null,null,"No"]
[]
[null,"All parameters within spec?"]
[]
[null,"Allison SQE Signature",null,null,"Date"]
[]
[null,"Supplier Signature:",null,null,"Date:"]

{"sheet":"SQE Action Plan Form","index":6,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[15,7,16,7],[15,14,16,14],[13,8,14,13],[15,8,15,13],[24,0,24,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[15,0,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[31,0,31,1],[32,0,32,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[45,0,45,1],[44,0,44,1],[43,0,43,1],[42,0,42,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[41,0,41,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[0,8,0,13],[1,8,1,13],[2,8,2,13],[3,8,3,13],[4,8,4,13]]}
["Supplier",null,{"$f":"'Cover Sheet'!C7","v":0},"Start Date: ",null,null,null,null,"SQE",null,null,null,null,null,{"$f":"'Cover Sheet'!C17","v":0}]
["Location",null,{"$f":"'Cover Sheet'!I9","v":0},"Rev. Date: ",null,null,null,null,"SQE Phone",null,null,null,null,null,{"$f":"'Cover Sheet'!I17","v":0}]
["Commodity",null,null,"Grad Date: ",null,null,null,null," Manager: "]
["Prepared by:",null,null,"Program:",{"$f":"'Cover Sheet'!I24","v":"00:00:00"},null,null,null,"Group:"]
[null,null,null,null,null,null,null,null,"Creativity Team:"]
[]
["\"Color Codes\""]
[null,"G","Green - Task Completed on Time"]
[null,"Y","Yellow - Task May Be Late"]
[null,"R","Red - Task is Late"]
[null,"W","White - Task Re-Timed, No Status"]
[null,"B","Blue - Task Status is Incorrect / Not Updated"]
[null,null,"On Track (Bold Box/No Color)"]
[null,null,null,null,"TOTAL",null,"TOTAL",null,"STATUS"]
[null,null,null,null,{"$f":"COUNTA(E18:E146)","v":0},null,{"$f":"COUNTA(G18:G146)","v":0}]
["ITEM",null,"ACTION ITEM","ACTION LEADER","DATE OPENED","TARGET CLOSE DATE","ACTUAL CLOSE DATE"," LAST UPDATE","STATUS HISTORY",null,null,null,null,null,"COUNTER MEASURES"]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]

{"sheet":"Revision History","index":7,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Date","Description"]
["2009-03-31","Released"]
["2010-04-30","Failure of audit and F/U required for any red elements"]
["2012-01-19","Added new section (I.) with 8 Labeling audits.  Added Vendor Number field on Cover Sheet.   Reworded criteria to Section D, #25."]
["2013-07-18","Integrated QSB and updated other items with Global input"]
["2013-12-02","Coding/Formatting corrections for score calculations"]
["2014-04-01","Additional formatting updates.  Removed DUNS # field.  Updated ATI logo on cover sheet to comply with new corporate branding guidelines.  Added TC10 and H3000 as product line options"]
["2014-04-30","Added ATI tooling audit (two tabs \"Tooling Audit Form Sec1\" and \"Tooling Audit Form Sec2\")"]
["2015-08-20","Significant rewrite.  Several questions added, deleted and reworded.  As a result questions have been renumbered\n\n1)  On cover sheet added summary for new \"change control\" section\n2)  Reworded Q1 to reference scheduling agreement instead of purchase order\n3)  Added Q2 and 3\n4)  Q4 - added detail to ensure supplier technical specifications match what level is on the supplier portal\n5)  Deleted previous Q3 - If the supplier is design responsible, has the DFMEA been used to develop the PFMEA?\n6)  Added section on change control\n7)  Reworded Q10\n8)  Deleted previous Q8 - Does the Process Flow Diagram include scrap?\n9)  Reworded Q17\n10)  Reworded Q21\n11)  Deleted previous Q18 - Does the PCP show consistency?\n12)  Deleted previous Q20 - Are process controls in place in the PCP to address the higher PFMEA Risk Priority Numbers?\n13)  Q23 and 24 - replaced \"PQCs or legacy designations\" with \"special characteristics\"\n14)  Deleted previous Q26 - Is there Standardized Work?\n15)  Deleted previous Q34 - Are tools and gauges requiring outside certification current?\n"]
["2015-08-20","16)  Reworded  Q35 - used to ask if gage R&R was less than 10%.  Reworded to ensure suppliers are periodically performing MSAs and families of gages\n17)  Added Q36\n16)  Reworded Q38"]
[null,"17)  Added Q40"]
[null,"18)  Q41 - added wording to ensure error proofing masters are identified properly"]
[null,"19)  Deleted previous Q50 - Does a Master list of all devices that prevent/detect the manufacture or assembly of nonconforming product exist?"]
[null,"20) Added Q53,54, and 56"]
[null,"21)  Deleted previous Q58- Does the support system respond to the operator?"]
[null,"22)  Deleted previous Q67 - Is washer verification performed?"]
[null,"23)  Q88 - added wording to ensure masters are adequately protected"]
[null,"24)  Added Q101"]
["2016-03-15","1)  Items 23, 24, 51 - replaced PQC, KPC reference with \"special characteristics"]
[null,"2)  Modified worksheet protection password to standard purchasing Excel password"]
[null,"3)  On cover sheet, modified section on type of audit to provide more clarity."]
["2018-02-14","1) Added questions 66 and 67 to address contingency plans and cascade of applicable requirements and characteristics to supply chain.\n2) Adjusted page breaks to accommodate new questions.\n3) Corrected spelling on Audit tab.\n4) increased row heights on audit so all text is visible"]
["2023-02-24","1) Removed Names\n2) Updated formatting"]
["2023-10-24","1) Cover Sheet: Added \"Auditor 1\" and \"Auditor 2\"\n2) Cover Sheet: Updated dropdown list for PLT\n3) Cover Sheet:  Added additional signature line\n3) Updated revision level"]

{"sheet":"Sheet1","index":8,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[0," "]
[1,"PASSED "]
[2,"FOLLOW UP AUDIT"]
[3,"QSB WORKSHOP REQUIRED"]
[4]
["NR"]