{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["INST","Supplier","1. Contracts","2 Capability","3 Capacity","4 Inspection","5 SCM","6 Planning & Operations","7 Quality & CI","8 Resources","Risk Scoring"],"not_rendered":{"charts":13,"images":6,"macros":1,"external_links":2,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INST","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,6],[6,1,6,6],[7,1,7,6]]}
[null,"General Instructions for Completing Assessment"]
[1,"Either provide thorough answers/responses to each item or question for all tabs, or describe any included objective evidence."]
[2,"Complete the Strengths, Weaknesses, Opportunities, & Threats (SWOT) analysis fields at the bottom of each tab."]
[]
[null,"Determining Probability, Consequence, and Risk Level"]
[3,"Supplier/Auditor: For each identified risk, determine the probability of occurrence using the criteria illustrated below. Based on the sources of risk, risks are normally categorized as technical, schedule, and cost; other categories may be added (e.g. process, technology, supplier, production, certification, quality, marketing).  Note: Consequences are all preset and shall not be changed, as these reflect the consequenses to Triumph should the item fail."]
[4,"Risks determined to have significant cost or schedule impacts, potentially affecting financial reporting requirements and estimate at completion projections (e.g., EAC risks) are coordinated with the respective leadership and Finance organizations."]
[5,"The risk levels (high, medium, low) are automatically calculated.  The five-by-five risk matrix provides an integrated view of the relationship of probability and consequence."]

{"sheet":"Supplier","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[63,1,63,3],[63,4,63,5],[63,7,63,11],[66,1,69,2],[70,1,73,2],[61,1,61,3],[61,4,61,5],[61,7,61,11],[62,1,62,3],[62,4,62,5],[62,7,62,11],[59,1,59,3],[59,4,59,5],[59,7,59,11],[60,1,60,3],[60,4,60,5],[60,7,60,11],[57,1,57,3],[57,4,57,5],[57,7,57,11],[58,1,58,3],[58,4,58,5],[58,7,58,11],[55,1,55,3],[55,4,55,5],[55,7,55,11],[56,1,56,3],[56,4,56,5],[56,7,56,11],[53,1,53,3],[53,4,53,5],[53,7,53,11],[54,1,54,3],[54,4,54,5],[54,7,54,11],[51,1,51,3],[51,4,51,5],[51,7,51,11],[52,1,52,3],[52,4,52,5],[52,7,52,11],[49,1,49,3],[49,4,49,5],[49,7,49,11],[50,1,50,3],[50,4,50,5],[50,7,50,11],[47,1,47,3],[47,4,47,5],[47,7,47,11],[48,1,48,3],[48,4,48,5],[48,7,48,11],[45,1,45,3],[45,4,45,5],[45,7,45,11],[46,1,46,3],[46,4,46,5],[46,7,46,11],[43,1,43,3],[43,4,43,5],[43,7,43,11],[44,1,44,3],[44,4,44,5],[44,7,44,11],[41,1,41,3],[41,4,41,5],[41,7,41,11],[42,1,42,3],[42,4,42,5],[42,7,42,11],[39,1,39,3],[39,4,39,5],[39,7,39,11],[40,1,40,3],[40,4,40,5],[40,7,40,11],[29,2,29,4],[29,7,29,8],[30,2,30,4],[30,7,30,8],[31,1,32,11],[33,1,33,3],[33,7,35,11],[34,1,34,3],[35,1,35,3],[22,1,22,11],[23,2,23,11],[24,3,24,6],[25,2,25,11],[26,2,26,11],[27,1,28,11],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,9,20,11],[21,2,21,4],[21,6,21,7],[21,9,21,11],[18,2,18,7],[18,9,18,11],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,9,19,11],[15,2,15,4],[15,6,15,7],[16,2,16,4],[16,6,16,7],[17,3,17,5],[17,6,17,7],[12,2,12,7],[12,9,12,11],[13,1,14,7],[13,8,14,11],[6,2,6,7],[6,9,6,11],[7,2,7,4],[7,6,7,7],[7,9,7,11],[9,2,9,7],[0,2,0,4],[1,2,1,4],[3,8,3,9],[4,2,4,7],[4,9,4,11],[5,2,5,7],[5,9,5,11],[10,2,10,7],[11,2,11,7],[11,9,11,11]]}
[null,"Assessment Start Date"]
[null,"Assessment End Date"]
[null,"SCMP 3.3   "]
[null,"Supplier Information",null,null,null,null,null,null,"Triumph Assessor's Information"]
[null,"Formal Supplier Name",null,null,null,null,null,null,"Lead Assessor"]
[null,"Address",null,null,null,null,null,null,"Phone "]
[null,"City",null,null,null,null,null,null,"Email"]
[null,"State/Region",null,null,null,null,null,null,"Truimph Assessment Site"]
[]
[null,"Country",null,null,null,null,null,null,"Supplier Quality System Std.",null,"Exp. Date "]
[null,"Supplier Contact Employee (Incl. Title)",null,null,null,null,null,null,"OASIS ID No.",null,"ID No"]
[null,"Telephone No.",null,null,null,null,null,null,"Additional Quality Approvals"]
[null,"Supplier Contact e-mail",null,null,null,null,null,null,"Nadcap Approvals"]
[null,"Supplier Information",null,null,null,null,null,null,"Customers & Suppliers"]
[]
[null,"Is the suppliers facility owned or leased?",null,null,null,"Mft Sq. Ft.",null,null,"Primary Cust. % of Capacity",null,"%"]
[null,"Total No of Indirect Employees at Site",null,null,null,"No. of Direct:",null,null,"2nd Level Cust. % of Capacity",null,"%"]
[null,"No of Direct Labor Work Shifts",null,"No of Direct Emp. / Shift",null,null,null,null,"3rd Level Cust. % of Capacity",null,"%"]
[null,"Does the supplier utilize a union workforce?",null,null,null,null,null,null,"Triumph Customer for this SOW"]
[null,null,null,null,null,null,null,null,"Customer Program"]
[null,"Percent Booked Capacity for the Next 2 Years",null,null,"Current Capacity",null,null,null,"Triumph Supp. Code (TA No.)"]
[null,"Annual Site Sales",null,null,null,"DUNS ID No.",null,null,"No. of Sub-Tier Suppliers"]
[]
[null,"Statement of Work"]
[null,"Supplier Description",null,"Manufacturer\nOriginal Equipment Manufacturer\nOriginal Component Manufacturer\n",null,null,null,null,"Distributor\nProcessor\nService Provider","Direct\nIndirect",null,"Aerospace\nNon Aerospace"]
[null,"Purpose of the Assessment"]
[null,"Scope of the Assessment"]
[null,"Based on the results of this survey, this supplier has been judged to be capable               /  incapable            to perform the commodity and work scope described above.  \nEnter each name below.  Signed hard copies shall be retained at the Triumph site level as necessary."]
[]
[null,"Triumph Site Quality Management",null,null,null,"Date",null,"Supplier Quality Assessor",null,null,"Date"]
[null,"Triumph Site Supply Chain Management",null,null,null,"Date",null,"1st Supporting Assessor",null,null,"Date"]
[]
[]
[null,"Have Capacity and Load Charts been reviewed?",null,null,null,"YES","NO","* Capacity, load charts, manufacturing plans, and organization charts may be included with this assessment, and stored on the supplier's electronic profile in the Triumph supplier portal."]
[null,"Has the manuf. plan for the Triumph SOW been reviewed?",null,null,null,"YES","NO"]
[null,"Has the Supplier Organization Chart been reviewed?",null,null,null,"YES","NO"]

{"sheet":"1. Contracts","index":2,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,0,41,0],[34,11,35,13],[34,1,35,10],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[32,0,33,0],[41,11,41,17],[22,1,23,1],[38,11,38,17],[41,1,41,10],[26,1,27,1],[24,1,25,1],[37,1,37,9],[22,16,23,17],[32,16,33,17],[27,4,27,13],[26,16,27,17],[29,4,29,13],[24,16,25,17],[32,14,33,15],[30,2,30,13],[22,14,23,15],[28,14,29,15],[26,14,27,15],[24,14,25,15],[20,0,21,0],[20,2,20,13],[24,2,24,13],[23,4,23,13],[34,0,35,0],[21,4,21,13],[34,14,35,15],[34,16,35,17],[26,2,26,13],[28,16,29,17],[30,16,31,17],[30,14,31,15],[30,0,31,0],[22,2,22,13],[27,2,27,3],[28,1,29,1],[29,2,29,3],[28,2,28,13],[31,2,31,3],[31,4,31,13],[16,16,17,17],[18,16,19,17],[20,16,21,17],[14,14,15,15],[20,14,21,15],[16,14,17,15],[18,14,19,15],[2,10,2,11],[5,12,5,17],[14,2,14,13],[13,9,13,10],[13,12,13,13],[14,16,15,17],[12,1,12,3],[11,4,11,8],[12,4,12,8],[10,4,10,9],[13,1,13,8],[10,1,10,3],[15,4,15,13],[10,14,11,17],[12,14,13,15],[11,0,11,3],[12,16,13,17],[14,0,15,0],[14,1,15,1],[15,2,15,3],[40,1,40,9],[37,11,37,13],[40,11,40,12],[38,1,38,10],[32,2,32,13],[33,4,33,13],[32,1,33,1],[33,2,33,3],[25,4,25,13],[23,2,23,3],[16,1,17,1],[17,4,17,13],[16,2,16,13],[17,2,17,3],[30,1,31,1],[16,0,17,0],[18,0,19,0],[25,2,25,3],[18,1,19,1],[19,4,19,13],[21,2,21,3],[20,1,21,1],[19,2,19,3],[18,2,18,13]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 1 \nContract Review and Build Package",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"1A","Does the supplier sufficiently review the requirements related to the product prior to their commitment to supply a product to Triumph (e.g. submission of tenders, acceptance of contracts or orders, acceptance of changes to contracts or orders) and ensures that they have the ability to meet the defined requirements and all risk involved?     This includes sufficient time to do all the necessary steps of design, supplier sourcing, procurement (including sub-tier lead times), manufacture, testing, and delivery.   If there is a new SOW, review FAI flow chart with responsible parties and average time-span identified.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":3},{"$f":"$Q$15","v":0}]
[null,"1B","Are product definition requirements including, product description, specifications, drawings, packaging, special instructions for marking, statement of work, use of special processes, change management or control and other relevant information including (but not limited to) design methodology necessary to deliver product that conforms to customer specifications accessible to the supplier and available for review?",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":4},{"$f":"$Q$17","v":0}]
[null,"1C","Does the contract review include objective evidence that an examination of all:\n       - Triumph terms and conditions including right of entry,\n       - NDA \n       - Technical specifications,\n       - Blueprints or models, \n       - Special quality and procurement requirements, \n       - Approved supplier and processor restrictions, etc.?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":1},{"$f":"$Q$19","v":0}]
[null,"1D","Is there recorded evidence (check sheet, routing sheet, etc.) of a thorough contract review occurring from all functions within the supplier?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":2},{"$f":"$Q$21","v":0}]
[null,"1E","Does the contract review take into account: (1) Any state-of-the-art technologies that may not yet be proven on a production scale, or (2) material availability or long lead times for tooling or equipment to meet specified delivery dates?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":3},{"$f":"$Q$23","v":0}]
[null,"1F","Does the supplier have a full understanding of the manufacturing, processing, handling and delivery requirements of Triumph before initiating its action to comply?  This understanding and its impact should be mutually acceptable to the participants both internally and at Triumph.",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":1},{"$f":"$Q$25","v":0}]
[null,"1G","Before accepting the order has the supplier reviewed its capabilities vs. the requirements of contract to determine if it has or can acquire all necessary capabilities to do the work in accordance with Triumph requirements?  This could include necessary personnel, machines, materials, capacity, infrastructure or other aspects of production or delivery.  ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"1H","Although Triumph may not specify certain requirements such as local environmental regulations, has the supplier established their product realization process to comply with local environmental regulations? ",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":1},{"$f":"$Q$29","v":0}]
[null,"1I","If tooling is required, is it understood who will;\n          Be responsible to pay for the tooling?\n          Be responsible for design of the tooling?\n          Be responsible for the fabrication of the tooling?                                                                                                                                                                                                                                                Does the supplier have the capability to produce tools in-house and if not, are subcontractors identified?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":1},{"$f":"$Q$31","v":0}]
[null,"1J","Does the suppliers processes ensure adequate understanding of any changes and change management requirements when initiated by the supplier or Triumph? This includes change acceptance, status accounting, method, timing, resources, and approval of change.  Changes can include product definition, contractual document terms and conditions, delivery requirements or associated specifications.  There should be a clear understanding between Triumph and supplier as to the definition of a change.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":2},{"$f":"$Q$33","v":0}]
[{"$f":"COUNTA(A15:A34)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P34)","v":2.1},null,{"$f":"AVERAGE(Q15:R34)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$35","v":2.1},{"$f":"$Q$35","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P34,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R34,\"5\")","v":0},null,"max","max"]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,{"$f":"MAX(S15:S34)","v":4},{"$f":"MAX(T15:T34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:O34)","v":10},{"$f":"COUNTA(Q15:Q34)","v":0}]
[]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats",null,null,null,null,null,null,"Yes"]

{"sheet":"2 Capability","index":3,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[40,0,41,0],[40,1,41,1],[40,2,40,13],[40,14,41,15],[41,2,41,3],[41,4,41,13],[18,2,18,13],[18,16,19,17],[36,14,37,15],[24,14,25,15],[26,14,27,15],[28,14,29,15],[29,4,29,13],[31,2,31,3],[33,2,33,3],[38,0,39,0],[37,2,37,3],[37,4,37,13],[38,14,39,15],[28,16,29,17],[38,16,39,17],[30,16,31,17],[34,16,35,17],[36,16,37,17],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[26,1,27,1],[3,10,3,11],[10,14,11,17],[13,1,13,8],[13,9,13,10],[13,12,13,13],[12,14,13,15],[22,1,23,1],[24,1,25,1],[12,16,13,17],[26,2,26,13],[27,2,27,3],[27,4,27,13],[26,16,27,17],[12,1,12,3],[12,4,12,8],[16,2,16,13],[16,16,17,17],[17,2,17,3],[48,1,48,10],[48,11,48,17],[45,1,45,9],[45,11,45,13],[46,1,46,10],[28,1,29,1],[30,1,31,1],[38,1,39,1],[34,1,35,1],[36,1,37,1],[47,1,47,9],[47,11,47,12],[36,2,36,13],[32,16,33,17],[42,1,43,10],[42,11,43,13],[28,2,28,13],[34,2,34,13],[40,16,41,17],[46,11,46,17],[42,14,43,15],[42,16,43,17],[39,2,39,3],[39,4,39,13],[14,0,15,0],[24,16,25,17],[25,2,25,3],[25,4,25,13],[24,2,24,13],[23,2,23,3],[23,4,23,13],[14,1,15,1],[14,2,14,13],[19,2,19,3],[19,4,19,13],[20,2,20,13],[20,16,21,17],[21,2,21,3],[21,4,21,13],[18,14,19,15],[20,14,21,15],[22,14,23,15],[22,0,23,0],[24,0,25,0],[14,14,15,15],[16,14,17,15],[16,0,17,0],[16,1,17,1],[44,0,48,0],[42,0,43,0],[10,1,10,3],[11,4,11,8],[10,4,10,9],[22,16,23,17],[35,2,35,3],[35,4,35,13],[30,2,30,13],[32,1,33,1],[29,2,29,3],[22,2,22,13],[31,4,31,13],[33,4,33,13],[32,2,32,13],[14,16,15,17],[15,2,15,3],[15,4,15,13],[11,0,11,3],[18,0,19,0],[20,0,21,0],[20,1,21,1],[36,0,37,0],[38,2,38,13],[17,4,17,13],[34,14,35,15],[32,14,33,15],[26,0,27,0],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[30,14,31,15],[18,1,19,1]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 2\n Supplier Capability",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"2A","What is the general condition of the facility?  (old, new, clean, dirty, organized, etc)                                                                                                                                                                           Is there a facility maintenance plan that addresses the needs of the building and infrastructure (roofs, electrical, heating and air conditioning in sensitive areas, etc.) ? (Regularly schedule, preventive, as required) ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":3},{"$f":"$Q$15","v":0}]
[null,"2B","Is the condition of each piece of equipment that will be utilized to support the Triumph work scope in adequate working order?                                                                       ",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":4},{"$f":"$Q$17","v":0}]
[null,"2C","Verify capability studies show the suppliers equipment is capable of performing within the tolerances required by the Triumph work scope?  ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":3},{"$f":"$Q$19","v":0}]
[null,"2D","Does the supplier have equipment flexibility so work can easily be moved within the company or to different machines to accommodate new orders, planned maintenance, bottlenecks or machine breakdowns?     Is there a risk mitigation plan for a single point of failure equipment? ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":3},{"$f":"$Q$21","v":0}]
[null,"2E","Does the supplier have a Total Preventative Maintenance or Preventive Maintenance Program in place to ensure all manufacturing and test machines are regularly maintained resulting in consistently low rates of unplanned maintenance and machine downtime?  Ensure TPM or PM schedules are established, easy for operators to comply with and are adhered to with only occasional lapses.   Are spare parts available for critical machines?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":2},{"$f":"$Q$23","v":0}]
[null,"2F","Does the company practice multiple machine manning?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":2},{"$f":"$Q$25","v":0}]
[null,"2G","Are there any bottleneck areas within the suppliers facilities and if so are they well understood and are contingencies in place to address if necessary?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":1},{"$f":"$Q$27","v":0}]
[null,"2H","When post award communication with Triumph is necessary, are effective communication processes are in place?   Who is your portal admisitrator?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":2},{"$f":"$Q$29","v":0}]
[null,"2I","Does the supplier have a project or program management structure in place that is capable to identify and satisfy customer technical requirements so minimal, on-going support is required from Triumph?    ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":2},{"$f":"$Q$31","v":0}]
[null,"2J","Is the suppliers ownership considering any major company restructuring programs (re-organization of key people or facilities) that could affect the product under review?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":1},{"$f":"$Q$33","v":0}]
[null,"2K","Review the suppliers current inventory turn level: \n         >   7 Turns      Excellent \n         6 - 4 Turns     Good\n         3 - 1 Turns     Poor",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$35","v":2},{"$f":"$Q$35","v":0}]
[null,"2L","Does the supplier have an effective IT system and support resources available either internally or under contract? Are IT system data backup procedures in place and capable to safeguard data?   Data can include electronic records or machine programs.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$37","v":2},{"$f":"$Q$37","v":0}]
[null,"2M","Have there have been any major failures of the IT systems in the 12 months?                                                                                                                                                                                               ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$39","v":2},{"$f":"$Q$39","v":0}]
[null,"2N","Do you have or will you have Contolled Unclassified Information (CUI) with any work statement from Triumph or any other customer or supplier? If so, do you have Cybersecurity Maturity Model Certification? If so, at what level of CMMC are you certified? If not, do you intend on getting your CMMC? If so, when and at what level will you be certified?",null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,{"$f":"$O$41","v":4},{"$f":"$Q$41","v":0}]
[null,null,"Evidence Records: "]
[{"$f":"COUNTA(A15:A42)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P42)","v":2.3571428571428572},null,{"$f":"AVERAGE(Q15:R42)","v":{"$error":"#DIV/0!"}},null,"max","max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(S15:S41)","v":4},{"$f":"MAX(T15:T41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P40,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R40,\"5\")","v":0},null,{"$f":"COUNTA(O15:O42)","v":14},{"$f":"COUNTA(Q15:Q42)","v":0}]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]

{"sheet":"3 Capacity","index":4,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[14,1,15,1],[14,2,14,13],[30,0,31,0],[30,1,31,10],[30,11,31,13],[22,0,23,0],[22,1,23,1],[22,2,22,13],[26,1,27,1],[26,2,26,13],[20,1,21,1],[20,2,20,13],[21,2,21,3],[21,4,21,13],[18,1,19,1],[18,2,18,13],[28,0,29,0],[14,0,15,0],[16,0,17,0],[26,0,27,0],[20,0,21,0],[24,0,25,0],[18,0,19,0],[6,12,6,17],[10,14,11,17],[13,1,13,8],[12,14,13,15],[12,16,13,17],[13,9,13,10],[13,12,13,13],[10,1,10,3],[11,4,11,8],[12,1,12,3],[12,4,12,8],[10,4,10,9],[11,0,11,3],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[37,1,37,10],[37,11,37,17],[30,14,31,15],[30,16,31,17],[34,11,34,17],[33,1,33,9],[33,11,33,13],[34,1,34,10],[36,1,36,9],[36,11,36,12],[18,16,19,17],[20,16,21,17],[18,14,19,15],[20,14,21,15],[26,16,27,17],[22,16,23,17],[22,14,23,15],[24,16,25,17],[19,2,19,3],[19,4,19,13],[16,1,17,1],[16,2,16,13],[16,14,17,15],[16,16,17,17],[17,2,17,3],[17,4,17,13],[14,14,15,15],[14,16,15,17],[15,2,15,3],[15,4,15,13],[27,2,27,3],[27,4,27,13],[26,14,27,15],[28,16,29,17],[28,1,29,1],[28,14,29,15],[28,2,28,13],[29,2,29,3],[29,4,29,13],[23,2,23,3],[23,4,23,13],[24,1,25,1],[24,2,24,13],[24,14,25,15],[25,2,25,3],[25,4,25,13]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 3\n Supplier Capacity",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"3A","What is the suppliers process for measuring and analyzing capacity?  Does the capacity plan take into account adequate time for machine downtime, maintenance, factory shutdown as well as unplanned rework and scrap?   Is overtime and absentee rate included in the capacity charts?                                                                                                                                                                                                                                                               ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":3},{"$f":"$Q$15","v":0}]
[null,"3B","Is the facility availability at levels of 85% or above?  Planned and unplanned facility maintenance and down time should not exceed 15%.\n     >   85% - Good   \n     75% to 84% - Fair     \n     < 75% to Not Measured - Poor",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":2},{"$f":"$Q$17","v":0}]
[null,"3C","Are there any environmental or safety issues that could impact capacity?   Does an emergency preparedness plan exist?  Does a disaster recovery plan exist?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":2},{"$f":"$Q$19","v":0}]
[null,"3D","Will significant facility upgrades or additional facility space be required to support the Triumph work scope?",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":4},{"$f":"$Q$21","v":0}]
[null,"3E","What is the company's ability to handle financial stress?  What is the current capital plan?   What is the process of notifying customers if capacity is stressed?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":3},{"$f":"$Q$23","v":0}]
[null,"3F","Are machine capacity studies available?  If so, review capacity study for each machine to be utilized as part of the Triumph work scope to determine if adequate capacity is available to support forecast and rate readiness.  Does the supplier have the machine capacity for the scope of work?  Machine and Process Capacity Ratings:                      \n< 75% - Good         \n 75% to 90% - Fair\n > 90% - Poor\n(Review capacity charts with the projected work scope included and record below.)\n      Work Center 1:\n      Work Center 2:\n      Work Center 3:\n      Work Center 4:\n      Work Center 5:",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":3},{"$f":"$Q$25","v":0}]
[null,"3G","What is the process for loading customer forecasted demand into the capacity planning tool?   What unplanned work is done on these machines & is it included in Machine Load?              ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":2},{"$f":"$Q$27","v":0}]
[null,"3H","Does the supplier have a documented configuration change management procedure?  Can the supplier demonstrate that it can receive, review and respond to design changes in a efficient and effective manner, with cross-functional teams involved in change review?",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":4},{"$f":"$Q$29","v":0}]
[{"$f":"COUNTA(A15:A30)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P30)","v":2.875},null,{"$f":"AVERAGE(Q15:R30)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$31","v":2.875},{"$f":"$Q$31","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P30,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R30,\"5\")","v":0},null,"max","max"]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,{"$f":"MAX(S15:S30)","v":4},{"$f":"MAX(T15:T30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:O30)","v":8},{"$f":"COUNTA(Q15:Q30)","v":0}]
[]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats",null,null,null,null,null,null,"Yes"]

{"sheet":"4 Inspection","index":5,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[14,1,15,1],[26,1,27,1],[42,0,43,0],[42,1,43,10],[42,11,43,13],[16,0,17,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[36,0,37,0],[38,0,39,0],[40,0,41,0],[19,4,19,13],[14,0,15,0],[20,2,20,13],[39,2,39,3],[39,4,39,13],[34,1,35,1],[6,12,6,17],[10,14,11,17],[12,14,13,15],[13,9,13,10],[13,12,13,13],[10,4,10,9],[18,16,19,17],[16,16,17,17],[12,16,13,17],[14,16,15,17],[14,14,15,15],[18,2,18,13],[15,2,15,3],[15,4,15,13],[18,14,19,15],[16,14,17,15],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[28,1,29,1],[21,4,21,13],[10,1,10,3],[11,4,11,8],[19,2,19,3],[11,0,11,3],[12,1,12,3],[12,4,12,8],[18,1,19,1],[13,1,13,8],[14,2,14,13],[16,1,17,1],[17,2,17,3],[17,4,17,13],[16,2,16,13],[22,2,22,13],[20,1,21,1],[22,1,23,1],[4,10,4,11],[36,16,37,17],[24,2,24,13],[26,2,26,13],[31,4,31,13],[30,2,30,13],[33,2,33,3],[33,4,33,13],[29,4,29,13],[28,2,28,13],[36,2,36,13],[28,16,29,17],[26,14,27,15],[37,2,37,3],[37,4,37,13],[36,14,37,15],[20,16,21,17],[24,16,25,17],[22,16,23,17],[32,14,33,15],[20,14,21,15],[24,1,25,1],[34,2,34,13],[21,2,21,3],[34,14,35,15],[28,14,29,15],[30,14,31,15],[25,2,25,3],[25,4,25,13],[23,2,23,3],[23,4,23,13],[22,14,23,15],[24,14,25,15],[40,16,41,17],[32,16,33,17],[38,1,39,1],[40,1,41,1],[40,2,40,13],[38,2,38,13],[35,2,35,3],[35,4,35,13],[27,2,27,3],[27,4,27,13],[38,16,39,17],[36,1,37,1],[41,2,41,3],[30,16,31,17],[31,2,31,3],[29,2,29,3],[41,4,41,13],[32,2,32,13],[32,1,33,1],[26,16,27,17],[40,14,41,15],[30,1,31,1],[34,16,35,17],[38,14,39,15],[49,1,49,10],[49,11,49,17],[42,14,43,15],[42,16,43,17],[46,11,46,17],[45,1,45,9],[45,11,45,13],[46,1,46,10],[48,1,48,9],[48,11,48,12]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 4 \nRec. / In-process and Final Inspection",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"4A","RECEIVING INSPECTION: Verify the process to determine that what was ordered and in what quantities is what was received is verified against the purchase order.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":2},{"$f":"$Q$15","v":0}]
[null,"4B","RECEIVING INSPECTION:  Review to determine how receiving inspectors verify that parts and materials are received from an approved supplier",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":2},{"$f":"$Q$17","v":0}]
[null,"4C","RECEIVING INSPECTION:   Verify the receiving inspection process ensures material test reports and certifications are received and adequately reviewed and has appropriate controls to ensure verification of required data when and as required.    Verify data includes but is not limited to: certificates of conformance, first article inspection reports, etc. are included with shipments as required.   ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":2},{"$f":"$Q$19","v":0}]
[null,"4D","RECEIVING INSPECTION:   Verify that the supplier maintains records of receiving inspections including receiving reports, material certifications, first article records, etc.  Ensure that all records are indexed, readily retrievable and protected from degradation and has the capability to effectively review test reports and material certifications to current specifications and requirements",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":2},{"$f":"$Q$21","v":0}]
[null,"4E","RECEIVING INSPECTION:   Verify that the supplier is capable of effectively reviewing sub-tier first article inspection reports and is not just validating submission of paperwork\n",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":4},{"$f":"$Q$23","v":0}]
[null,"4F","IN PROCESS INSPECTION: Verify that inspections are performed in the final part material condition (hardness, conductivity, etc.) and is verified prior to part finish/coating",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":2},{"$f":"$Q$25","v":0}]
[null,"4G","IN PROCESS INSPECTION: Verify that planning is complete and inspection operations are closed utilizing an inspection stamp",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"4H","IN PROCESS INSPECTION: Ensure that all surface preparation and finish conditions are in accordance with the controlling specifications",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":3},{"$f":"$Q$29","v":0}]
[null,"4I","IN PROCESS INSPECTION: Does the supplier have the necessary inspection equipment and facilities for the work package (i.e. CMM, NDT, portable CMM, borescopes, etc.)?   Review to ensure that tools called out are actually utilized.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":3},{"$f":"$Q$31","v":0}]
[null,"4J","IN PROCESS INSPECTION: If manufacturing self-inspection is utilized, are the operators adequately trained, tested and monitored over time to ensure they remain current to requirement changes and demonstrate continued compliance?  ",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":4},{"$f":"$Q$33","v":0}]
[null,"4K","IN PROCESS INSPECTION: If manufacturing self-inspection is utilized, verify that operators are inspecting only their own work and are not performing inspection for others or other in process or final inspection operations.",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$35","v":4},{"$f":"$Q$35","v":0}]
[null,"4L","FINAL INSPECTION:  Is the supplier capable of successfully completing an AS9102 compliant first article per Triumph requirements?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$37","v":2},{"$f":"$Q$37","v":0}]
[null,"4M","FINAL INSPECTION:  Verify first article Inspection process is completed to AS9102 and ensure that all first article records are indexed, readily retrievable and protected from degradation.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$39","v":2},{"$f":"$Q$39","v":0}]
[null,"4N","FINAL INSPECTION:  Verify that parts are identified properly, processes are in place to ensure that serialization is readily maintained and acceptance stamps affixed as required.  Ensure shipping  documentation is included and final packaging is satisfactory to mitigate damage during transit.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$41","v":3},{"$f":"$Q$41","v":0}]
[{"$f":"COUNTA(A15:A42)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P42)","v":2.7142857142857144},null,{"$f":"AVERAGE(Q15:R42)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$43","v":2.7142857142857144},{"$f":"$Q$43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P42,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R42,\"5\")","v":0}]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,"max","max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(S15:S42)","v":4},{"$f":"MAX(T15:T42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:P42)","v":14},{"$f":"COUNTA(Q15:R42)","v":0}]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"5 SCM","index":6,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":false,"merged":[[48,14,49,15],[52,14,53,15],[26,14,27,15],[28,14,29,15],[30,14,31,15],[32,14,33,15],[34,14,35,15],[14,14,15,15],[16,14,17,15],[22,14,23,15],[18,14,19,15],[20,14,21,15],[30,16,31,17],[31,2,31,3],[31,4,31,13],[22,16,23,17],[23,2,23,3],[23,4,23,13],[18,16,19,17],[19,2,19,3],[19,4,19,13],[20,2,20,13],[20,16,21,17],[21,2,21,3],[21,4,21,13],[24,14,25,15],[28,16,29,17],[29,2,29,3],[29,4,29,13],[34,16,35,17],[35,2,35,3],[35,4,35,13],[14,0,15,0],[14,1,15,1],[14,2,14,13],[14,16,15,17],[15,2,15,3],[15,4,15,13],[16,0,17,0],[16,1,17,1],[16,2,16,13],[16,16,17,17],[17,2,17,3],[17,4,17,13],[18,0,19,0],[18,1,19,1],[18,2,18,13],[22,0,23,0],[22,1,23,1],[22,2,22,13],[24,16,25,17],[32,16,33,17],[26,16,27,17],[56,0,57,0],[56,1,57,10],[56,11,57,13],[24,0,25,0],[36,0,37,0],[38,0,39,0],[40,0,41,0],[42,0,43,0],[44,0,45,0],[46,0,47,0],[48,0,49,0],[50,0,51,0],[52,0,53,0],[54,0,55,0],[37,2,37,3],[37,4,37,13],[38,2,38,13],[26,0,27,0],[26,1,27,1],[26,2,26,13],[30,0,31,0],[34,0,35,0],[38,1,39,1],[55,2,55,3],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[54,1,55,1],[42,1,43,1],[43,2,43,3],[43,4,43,13],[52,1,53,1],[6,12,6,17],[10,14,11,17],[24,2,24,13],[51,2,51,3],[51,4,51,13],[48,16,49,17],[49,2,49,3],[12,14,13,15],[12,16,13,17],[50,1,51,1],[48,1,49,1],[13,9,13,10],[13,12,13,13],[36,2,36,13],[13,1,13,8],[24,1,25,1],[32,1,33,1],[32,2,32,13],[33,2,33,3],[33,4,33,13],[27,2,27,3],[27,4,27,13],[28,1,29,1],[28,2,28,13],[20,1,21,1],[25,2,25,3],[25,4,25,13],[41,4,41,13],[36,16,37,17],[44,2,44,13],[40,16,41,17],[39,2,39,3],[39,4,39,13],[45,4,45,13],[45,2,45,3],[38,16,39,17],[42,16,43,17],[40,2,40,13],[40,14,41,15],[44,14,45,15],[38,14,39,15],[42,14,43,15],[36,14,37,15],[55,4,55,13],[50,16,51,17],[46,2,46,13],[50,14,51,15],[54,14,55,15],[46,14,47,15],[63,1,63,10],[46,1,47,1],[47,2,47,3],[47,4,47,13],[63,11,63,17],[56,14,57,15],[56,16,57,17],[59,11,59,13],[60,1,60,10],[62,1,62,9],[62,11,62,12],[60,11,60,17],[59,1,59,9],[53,2,53,3],[53,4,53,13],[52,2,52,13],[52,16,53,17],[54,16,55,17],[54,2,54,13],[46,16,47,17],[49,4,49,13],[50,2,50,13],[48,2,48,13],[10,1,10,3],[10,4,10,9],[11,4,11,8],[12,1,12,3],[12,4,12,8],[42,2,42,13],[36,1,37,1],[44,1,45,1],[30,1,31,1],[30,2,30,13],[34,1,35,1],[34,2,34,13],[11,0,11,3],[32,0,33,0],[28,0,29,0],[20,0,21,0],[44,16,45,17],[40,1,41,1],[41,2,41,3]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 5 \nSupply Chain Management",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"5A","Does the supplier have a documented supplier management program?  Verify evidence of EFFECTIVE supplier selection, monitoring, and control.  Is there evidence that sub-tier suppliers have gone through some type of documented supplier approval process?  Allowance can be made for customer directed or limited use type sources",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":2},{"$f":"$Q15","v":0}]
[null,"5B","Review the process the supplier utilizes to monitor and manage sub-tier performance (Quality, Delivery, Financial, etc).  Review the frequency of the monitoring process and the suppliers activity with their sub-tier.  Is the management effective?  Also, does the supplier measure supplier performance at the buyer level?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":2},{"$f":"$Q17","v":0}]
[null,"5C","Is the suppliers approved supplier list (ASL) managed and revision controlled?  Is the current version readily available for review by those that require frequent access?",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":1},{"$f":"$Q19","v":0}]
[null,"5D","How does the supplier react and manage supply shortages, poor on time delivery, or quality problems from their sub-tiers.  What is the process for managing underperforming suppliers?  Are sub-tier suppliers on TGI ASL evaluated by supplier?                                                                                                                                                                        ",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":4},{"$f":"$Q21","v":0}]
[null,"5E","Does the supplier periodically reevaluate their sub-tiers to ensure continued quality system approvals and adequate performance?  Does the reevaluation include a review of past performance? ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":3},{"$f":"$Q23","v":0}]
[null,"5F","Does the supplier perform on-site audits of it's sub-tiers with any regularity?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":2},{"$f":"$Q25","v":0}]
[null,"5G","Current Delivery Performance of the supplier's sub-tier suppliers\n                100 - 98 - Good\n                97-95 - Fair\n                95% - Poor\n               Unknown - Very Poor",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"5H","Does the supplier use a limited number of reliable core suppliers, or is their supply base made up of multiple low cost?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":3},{"$f":"$Q$29","v":0}]
[null,"5I","Over the last two years, can the supplier demonstrate that it saves money with its \"core\" suppliers by negotiating long term cost-down agreements rather than just the result of switching to \"cheaper\" suppliers?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":2},{"$f":"$Q$31","v":0}]
[null,"5J","Are long term agreements in place with key/critical sub-tier suppliers and / or material providers?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":3},{"$f":"$Q$33","v":0}]
[null,"5K","Percentage of Supply Base on  Long Term Agreements\n           > 50% - Good\n           50% - 25% - Fair\n           < 25% - Poor",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$35","v":3},{"$f":"$Q$35","v":0}]
[null,"5L","Are forecasts provided to the sub-tier for the contract period?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$37","v":2},{"$f":"$Q$37","v":0}]
[null,"5M","Review orders to determine if parts / materials are ordered within lead time",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$39","v":3},{"$f":"$Q$39","v":0}]
[null,"5N","What processes are in place for the supplier to identify future shortages and for communicating that risk to their customer?                                                                            ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$41","v":2},{"$f":"$Q$41","v":0}]
[null,"5O","Review the process to track raw material, hardware and outside processsing (subcontract) purchase orders for both the supplier and their sub-tiers",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$43","v":2},{"$f":"$Q$43","v":0}]
[null,"5P","How regularly does the supplier update raw material and all other subcontract items lead times and communicate to Triumph?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$45","v":3},{"$f":"$Q$45","v":0}]
[null,"5Q","Can the supplier show evidence of tactics or strategies to address material and part lead-time reductions?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$47","v":2},{"$f":"$Q$47","v":0}]
[null,"5R","Review the manufacturing or processing processes outsourced to determine if there is adequate flow down of requirements and oversight of the sub-tier is adequately documented, staffed and managed.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$49","v":2},{"$f":"$Q$49","v":0}]
[null,"5S","Has the suppliers sub-tier supplier capability been reviewed and judged as adequate for the Triumph scope of work?   ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$51","v":2},{"$f":"$Q$51","v":0}]
[null,"5T","Can the supplier demonstrate the methods utilized to ensure only the use of approved processors occurs when required?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$53","v":2},{"$f":"$Q$53","v":0}]
[null,"5U","Review and record any sole source sub-tier suppliers that may impact the Triumph statement of work.                                                                                                                                             Is there a risk mitigation plan to address potential failures at sole source sub-tier suppliers? ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$55","v":3},{"$f":"$Q$55","v":0}]
[{"$f":"COUNTA(A15:A56)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P56)","v":2.4285714285714284},null,{"$f":"AVERAGE(Q15:R56)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$57","v":2.4285714285714284},{"$f":"$Q$57","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P56,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R56,\"5\")","v":0}]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,"max","max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(S15:S56)","v":4},{"$f":"MAX(T15:T56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:O56)","v":21},{"$f":"COUNTA(Q15:Q56)","v":0}]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"6 Planning & Operations","index":7,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,29,0],[28,1,29,1],[28,2,28,13],[28,14,29,15],[28,16,29,17],[29,2,29,3],[29,4,29,13],[16,16,17,17],[17,2,17,3],[17,4,17,13],[14,16,15,17],[16,14,17,15],[14,14,15,15],[30,0,31,0],[30,1,31,10],[30,11,31,13],[14,0,15,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[26,0,27,0],[26,1,27,1],[16,0,17,0],[16,1,17,1],[16,2,16,13],[15,2,15,3],[15,4,15,13],[24,0,25,0],[22,1,23,1],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[4,10,4,11],[6,12,6,17],[10,14,11,17],[12,14,13,15],[12,16,13,17],[13,1,13,8],[14,2,14,13],[14,1,15,1],[13,9,13,10],[13,12,13,13],[20,16,21,17],[21,2,21,3],[21,4,21,13],[18,1,19,1],[18,16,19,17],[19,2,19,3],[19,4,19,13],[18,2,18,13],[20,2,20,13],[20,1,21,1],[20,14,21,15],[18,14,19,15],[22,16,23,17],[23,2,23,3],[23,4,23,13],[22,2,22,13],[22,14,23,15],[26,16,27,17],[27,2,27,3],[27,4,27,13],[26,2,26,13],[26,14,27,15],[36,1,36,9],[36,11,36,12],[37,1,37,10],[37,11,37,17],[30,14,31,15],[30,16,31,17],[34,11,34,17],[33,1,33,9],[33,11,33,13],[34,1,34,10],[10,1,10,3],[10,4,10,9],[11,4,11,8],[12,1,12,3],[12,4,12,8],[11,0,11,3],[24,1,25,1],[24,2,24,13],[24,14,25,15],[24,16,25,17],[25,2,25,3],[25,4,25,13]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 6 \nPlanning Controls",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"6A","Verify the planning calls out correct raw materials                                                                                                                                                                                                                                                   Verify the planning is of sufficient detail so operators can effectively and correctly complete work required.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":3},{"$f":"$Q$15","v":0}]
[null,"6B","How does the supplier adhere to customer frozen process and key characteristics requirements?    ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":2},{"$f":"$Q$17","v":0}]
[null,"6C","Verify that any sub-tier operations, including processing, are called out in adequate detail.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":3},{"$f":"$Q$19","v":0}]
[null,"6D","Verify operations are stamped individually and in sequence and no mass sign-offs are occurring",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":3},{"$f":"$Q$21","v":0}]
[null,"6E","Verify that the shop floor planning (work order) is serialized, the parts are serialized and are matched to the appropriate parts and the planning is co-located with the parts",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":2},{"$f":"$Q$23","v":0}]
[null,"6F","What is the suppliers process to communicate to Triumph when transitioning a critical process? (i.e., special process being in-loaded or off-loaded; part or part family being transitioned from one source or facility to another, equipment moves within the facility, supplier engineering change process notification, etc.)",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":2},{"$f":"$Q$25","v":0}]
[null,"6G","Verify that any changes to the manufacturing order are authorized as required in the suppliers procedures and any permanent changes are traceable back to the master order",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"6H","Does material appear to be running to delivery commit date or is material ‘late’; review date on router and intended delivery/need date.  What is the overall health of the suppliers schedule commitment to its customers?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":3},{"$f":"$Q$29","v":0}]
[{"$f":"COUNTA(A15:A30)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P30)","v":2.625},null,{"$f":"AVERAGE(Q15:R30)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$31","v":2.625},{"$f":"$Q$31","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P28,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R28,\"5\")","v":0}]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,"max","max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(S15:S30)","v":3},{"$f":"MAX(T15:T30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:P30)","v":8},{"$f":"COUNTA(Q15:Q30)","v":0}]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"7 Quality & CI","index":8,"n_rows":74,"n_cols":20,"rows_kept":74,"cut":false,"hidden":false,"merged":[[60,0,61,0],[60,1,61,1],[60,2,60,13],[60,16,61,17],[61,2,61,3],[61,4,61,13],[60,14,61,15],[53,4,53,13],[52,14,53,15],[54,16,55,17],[55,2,55,3],[50,14,51,15],[58,14,59,15],[56,14,57,15],[48,0,49,0],[50,0,51,0],[56,0,57,0],[57,2,57,3],[57,4,57,13],[44,0,45,0],[44,1,45,1],[44,2,44,13],[44,14,45,15],[64,0,65,0],[64,1,65,1],[64,2,64,13],[64,16,65,17],[65,2,65,3],[65,4,65,13],[62,0,63,0],[62,1,63,1],[62,2,62,13],[62,14,63,15],[32,16,33,17],[33,2,33,3],[33,4,33,13],[20,16,21,17],[28,16,29,17],[29,2,29,3],[29,4,29,13],[24,14,25,15],[30,14,31,15],[26,14,27,15],[22,14,23,15],[32,14,33,15],[20,14,21,15],[28,14,29,15],[24,2,24,13],[24,16,25,17],[25,2,25,3],[25,4,25,13],[36,16,37,17],[37,2,37,3],[37,4,37,13],[46,14,47,15],[40,14,41,15],[42,14,43,15],[38,14,39,15],[34,14,35,15],[36,14,37,15],[42,2,42,13],[40,16,41,17],[44,16,45,17],[45,2,45,3],[45,4,45,13],[66,0,67,0],[66,1,67,10],[66,11,67,13],[62,16,63,17],[63,2,63,3],[63,4,63,13],[64,14,65,15],[48,16,49,17],[48,14,49,15],[54,14,55,15],[58,0,59,0],[58,1,59,1],[58,2,58,13],[58,16,59,17],[59,2,59,3],[59,4,59,13],[56,16,57,17],[50,16,51,17],[51,2,51,3],[51,4,51,13],[52,0,53,0],[52,1,53,1],[53,2,53,3],[52,16,53,17],[24,0,25,0],[41,2,41,3],[42,16,43,17],[41,4,41,13],[43,2,43,3],[40,1,41,1],[46,1,47,1],[47,4,47,13],[38,1,39,1],[38,2,38,13],[38,16,39,17],[39,2,39,3],[39,4,39,13],[43,4,43,13],[47,2,47,3],[34,0,35,0],[34,1,35,1],[34,2,34,13],[34,16,35,17],[35,2,35,3],[35,4,35,13],[42,1,43,1],[46,2,46,13],[24,1,25,1],[36,0,37,0],[36,1,37,1],[36,2,36,13],[32,0,33,0],[32,1,33,1],[32,2,32,13],[38,0,39,0],[49,4,49,13],[56,1,57,1],[50,2,50,13],[56,2,56,13],[52,2,52,13],[49,2,49,3],[55,4,55,13],[54,2,54,13],[54,1,55,1],[54,0,55,0],[40,0,41,0],[42,0,43,0],[46,0,47,0],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[1,1,1,9],[50,1,51,1],[48,2,48,13],[21,4,21,13],[13,12,13,13],[6,12,6,17],[10,14,11,17],[12,14,13,15],[12,16,13,17],[13,1,13,8],[9,9,9,13],[48,1,49,1],[46,16,47,17],[16,2,16,13],[18,2,18,13],[20,2,20,13],[40,2,40,13],[4,0,4,12],[10,1,10,3],[10,4,10,9],[73,1,73,10],[73,11,73,17],[66,16,67,17],[70,11,70,17],[66,14,67,15],[72,1,72,9],[72,11,72,12],[69,1,69,9],[69,11,69,13],[70,1,70,10],[11,4,11,8],[12,1,12,3],[12,4,12,8],[20,1,21,1],[18,1,19,1],[19,2,19,3],[19,4,19,13],[11,0,11,3],[13,9,13,10],[14,1,15,1],[15,2,15,3],[15,4,15,13],[14,0,15,0],[14,2,14,13],[17,2,17,3],[17,4,17,13],[21,2,21,3],[16,1,17,1],[16,0,17,0],[18,0,19,0],[20,0,21,0],[14,16,15,17],[22,0,23,0],[22,1,23,1],[22,2,22,13],[22,16,23,17],[23,2,23,3],[23,4,23,13],[16,16,17,17],[18,16,19,17],[16,14,17,15],[18,14,19,15],[14,14,15,15],[30,0,31,0],[30,1,31,1],[30,2,30,13],[30,16,31,17],[31,2,31,3],[31,4,31,13],[26,0,27,0],[26,1,27,1],[26,2,26,13],[26,16,27,17],[27,2,27,3],[27,4,27,13],[28,0,29,0],[28,1,29,1],[28,2,28,13]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 7 \nOperations",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"7A","Delivered Quality\n   100% - 99.8% total delivered quality in last 12 months - Good\n   99.79% - 99.50 total delivered quality in last 12 months - Fair \n   < 99.49% total delivered defects in last 12 months - Poor",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":2},{"$f":"$Q$15","v":0}]
[null,"7B","In-process Scrap Cost\n      < 1% of sales - Good\n      1%-3% of sales - Fair\n      > 3% of sales - Poor\n      Unknown - Very Poor\nWhat is the #1 factory/quality defect internal to supplier?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":2},{"$f":"$Q$17","v":0}]
[null,"7C","In-process Rework Cost\n   <.05% of sales - Good\n   .06% - 3% of sales - Fair\n   10% of sales - Poor\n   unknown - Very Poor",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":2},{"$f":"$Q$19","v":0}]
[null,"7D","Review the supplier process for reporting process / business performance metrics (Quality, Delivery, Escapes, etc.).  Does the method support continuous improvement actions?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":2},{"$f":"$Q$21","v":0}]
[null,"7E","Are measures and results of manufacturing performance an effective tool for managing the business?  Are key areas measured regularly and current results posted for all employees to routinely review?  Do improvement results support a pattern of consistent improvement?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":2},{"$f":"$Q$23","v":0}]
[null,"7F","Are visual management metrics at each cell/workstation so employees know if they meet their daily schedules and the status of their machine / work cell's quality performance?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":2},{"$f":"$Q$25","v":0}]
[null,"7G","How are internal product rejections measured and communicated to the affected departments / work cells, etc.?  Does the process drive effective corrective action and process improvement?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"7H","Review to determine if the supplier has an active atmosphere of continuous improvement or a formal continuous improvement program",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":2},{"$f":"$Q$29","v":0}]
[null,"7I","Have there been any occurrences of escape notifications to customers over the previous 24 months?  If any notification did occur, are processes are in place to address immediate containment and drive effective corrective action?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":2},{"$f":"$Q$31","v":0}]
[null,"7J","Verify that nonconforming parts / materials / tools are segregated from the production area",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":3},{"$f":"$Q$33","v":0}]
[null,"7K","Review an actual RCCA analysis on a recent non-conforming Triumph part/assembly and has the problem re-occurred or is it resolved?   Does supplier have a MRB archived system?",null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$35","v":4},{"$f":"$Q$35","v":0}]
[null,"7L","Review the quantity of nonconformance submissions to current customers and if there have been instances of customer-approved shipment of non-conforming products in the previous year.",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$37","v":2},{"$f":"$Q$37","v":0}]
[null,"7M","Verify that there is an established calibration process for tooling, gauging, test and measurement equipment and tools are current (within periodic inspection limits), properly identified, in good condition, and identified on planning.     ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$39","v":3},{"$f":"$Q$39","v":0}]
[null,"7N","Review how orders are released and tracked to the shop floor",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$41","v":2},{"$f":"$Q$41","v":0}]
[null,"7O","Review the suppliers process for tracking and reporting the status of raw material, customer WIP and finished goods\n",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$43","v":2},{"$f":"$Q$43","v":0}]
[null,"7P","Is an inventory accuracy process in place?  Does the supplier perform inventories and cycle counts at scheduled frequencies?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$45","v":2},{"$f":"$Q$45","v":0}]
[null,"7Q","Do all facilities, equipment, stores and WIP have defined MRP stock locations?  Verify that stock, raw materials and other products held in the warehouse or point of use are of the proper configuration and are kept in a clean, properly ventilated, temperature controlled (as required) and orderly manner.  Verify there is a system to reliably identify location and quantity of all warehouse contents; and a means for monitoring time limited shelf-life items.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$47","v":3},{"$f":"$Q$47","v":0}]
[null,"7R","Is there is evidence of continuous improvement activities that optimizes production throughput and output, minimizes stock levels and cycle times and which maximizes facility and resource utilization?  Is the flow of material governed by streamlined systems such as Pull, e.g. Kanban, Min-Max, etc.?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$49","v":2},{"$f":"$Q$49","v":0}]
[null,"7S","Does the supplier utilize lean manufacturing principles such as 5S?  Does the supplier have a lean focal within their facility?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$51","v":2},{"$f":"$Q$51","v":0}]
[null,"7T","Is there evidence of problem-solving and continuous improvement activities being widely supported by Management and shop-floor staff who often play the major role in their implementation? ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$53","v":2},{"$f":"$Q$53","v":0}]
[null,"7U","What were the last 2 CI project conducted in operations?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$55","v":2},{"$f":"$Q$55","v":0}]
[null,"7V","Does the durable tooling support the forecasted demand requirements? (Look at specific programs; provide objective evidence).   Is there a tooling repair and management plan in place?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$57","v":3},{"$f":"$Q$57","v":0}]
[null,"7W","Are tools maintained in a secure, organized and clean environment as appropriate for the tooling?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$59","v":2},{"$f":"$Q$59","v":0}]
[null,"7X","Verify that tooling is properly identified, shows QA acceptance stamps, inspection records available and is referenced in production planning",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$61","v":2},{"$f":"$Q$61","v":0}]
[null,"7Y","Verify that there is a tool maintenance schedule or tool maintenance plan.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$63","v":3},{"$f":"$Q$63","v":0}]
[null,"7Z","Verify that tools used for product acceptance show evidence that periodic tool inspections are being performed and inspection records are available.",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$65","v":3},{"$f":"$Q$65","v":0}]
[{"$f":"COUNTA(A15:A66)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P66)","v":2.3461538461538463},null,{"$f":"AVERAGE(Q15:R66)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$67","v":2.3461538461538463},{"$f":"$Q$67","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P66,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R66,\"5\")","v":0},null,"max","max"]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses",null,null,null,null,null,null,{"$f":"MAX(S15:S66)","v":4},{"$f":"MAX(T15:T66)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:P66)","v":26},{"$f":"COUNTA(Q15:R66)","v":0}]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"8 Resources","index":9,"n_rows":52,"n_cols":20,"rows_kept":52,"cut":false,"hidden":false,"merged":[[32,0,33,0],[32,1,33,1],[32,2,32,13],[32,16,33,17],[33,2,33,3],[33,4,33,13],[34,0,35,0],[34,1,35,1],[34,2,34,13],[34,16,35,17],[35,2,35,3],[35,4,35,13],[32,14,33,15],[34,14,35,15],[44,0,45,0],[44,1,45,10],[44,11,45,13],[16,0,17,0],[18,0,19,0],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[30,0,31,0],[38,0,39,0],[40,0,41,0],[42,0,43,0],[30,2,30,13],[31,2,31,3],[18,2,18,13],[18,1,19,1],[40,1,41,1],[38,2,38,13],[43,2,43,3],[40,2,40,13],[43,4,43,13],[42,1,43,1],[36,0,37,0],[1,1,1,9],[14,16,15,17],[16,16,17,17],[16,1,17,1],[11,4,11,8],[12,1,12,3],[12,4,12,8],[14,1,15,1],[14,2,14,13],[15,2,15,3],[15,4,15,13],[17,2,17,3],[17,4,17,13],[14,14,15,15],[16,14,17,15],[0,1,0,5],[0,6,0,9],[2,1,2,5],[2,6,2,9],[39,2,39,3],[31,4,31,13],[39,4,39,13],[13,9,13,10],[13,12,13,13],[10,1,10,3],[10,4,10,9],[6,12,6,17],[10,14,11,17],[12,14,13,15],[12,16,13,17],[13,1,13,8],[30,1,31,1],[38,1,39,1],[16,2,16,13],[23,2,23,3],[23,4,23,13],[19,4,19,13],[26,2,26,13],[28,2,28,13],[24,1,25,1],[26,16,27,17],[27,2,27,3],[27,4,27,13],[22,1,23,1],[24,16,25,17],[25,2,25,3],[25,4,25,13],[22,16,23,17],[22,2,22,13],[24,2,24,13],[26,14,27,15],[24,14,25,15],[22,14,23,15],[41,4,41,13],[26,1,27,1],[28,16,29,17],[29,2,29,3],[29,4,29,13],[28,1,29,1],[42,2,42,13],[40,16,41,17],[41,2,41,3],[42,16,43,17],[30,16,31,17],[38,16,39,17],[36,1,37,1],[36,2,36,13],[36,16,37,17],[37,2,37,3],[37,4,37,13],[28,14,29,15],[40,14,41,15],[42,14,43,15],[30,14,31,15],[38,14,39,15],[36,14,37,15],[51,1,51,10],[51,11,51,17],[44,14,45,15],[44,16,45,17],[48,11,48,17],[47,1,47,9],[47,11,47,13],[50,1,50,9],[50,11,50,12],[48,1,48,10],[18,23,18,25],[18,26,18,31],[19,22,19,25],[19,26,19,30],[20,23,20,25],[20,26,20,30],[11,0,11,3],[20,0,21,0],[20,1,21,1],[20,2,20,13],[20,16,21,17],[21,2,21,3],[21,4,21,13],[18,16,19,17],[19,2,19,3],[14,0,15,0],[20,14,21,15],[18,14,19,15]]}
[]
[null,"Return To Risk Scoring Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplier Name:",null,null,{"$f":"Supplier!C5","v":0},null,null,null,null,null,null,"áRisk Levelsâ",null,null,"Risk Score (1 – 5)\n1 = Low Risk  \n5 = High Risk "]
["Assessment Start Date",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"},null,null,null,null,"Low Risk",null,"Medium Risk",null,"High Risk"]
[null,"Completed By:",null,null,{"$f":"Supplier!C2","v":0},null,null,null,null,1,2,3,4,5,"Consequence of Process Failure",null,"Probability  of Process Failure"]
["Concerns","Section 8 \nResources",null,null,null,null,null,null,null,"Documented evidence of previous actions support effectiveness",null,null,"No documented evidence of previous actions that support effectiveness"]
[null,"8A","Are there sufficient skill sets and manpower in all key functional areas specifically Operations, Manufacturing Engineering, Quality, and Procurement to successfully complete the Triumph SOW?   If no, are plans in place to address any shortfall of resources to address the Triumph work scope?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$15","v":3},{"$f":"$Q$15","v":0}]
[null,"8B","Are critical skills identified and are training plans in place to address training needs in those critical skill areas?  List top 5 critical skills needed for you company. Is subject matter expertise captured and passed on to team?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$17","v":3},{"$f":"$Q$17","v":0}]
[null,"8C","Are skilled resources available in the geographic region?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$19","v":3},{"$f":"$Q$19","v":0}]
[null,"8D","Are operators regularly rotated around the shop and cross-training is highly evident and documented?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$21","v":3},{"$f":"$Q$21","v":0}]
[null,"8E","Is the labor force is stable, highly flexible and engaged? ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$23","v":3},{"$f":"$Q$23","v":0}]
[null,"8F","Do training plans account for ensuring retention of skills (including key owners/personnel)?                                                                                                                                                                                                                                                         ",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$25","v":3},{"$f":"$Q$25","v":0}]
[null,"8G","Are internal resources available to provide and manage any special training required to support the Triumph statement of work?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$27","v":3},{"$f":"$Q$27","v":0}]
[null,"8H","Can all employees can read and speak English?",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$29","v":3},{"$f":"$Q$29","v":0}]
[null,"8I","What is the current percentage of overtime and is it used sparingly as appropriate?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$31","v":2},{"$f":"$Q$31","v":0}]
[null,"8J","Is workforce turnover (separation driven by either Management or by employees, excluding retirees) at 2% - 5% or less within the prior 12 months and is there any risk to the Triumph work statement due to the current turnover rate?   Does a succession plan exist for key owners/personnel?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$33","v":2},{"$f":"$Q$33","v":0}]
[null,"8K","Is the average absentee rate over the last year equal to or lower than 1%, - 2%? ",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$35","v":2},{"$f":"$Q$35","v":0}]
[null,"8L"," Is there a process to increase the current shift patterns or the current manning in each shift if necessary?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$37","v":2},{"$f":"$Q$37","v":0}]
[null,"8M","Have there been any available man-hours lost due to labor disputes in recent years?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$39","v":2},{"$f":"$Q$39","v":0}]
[null,"8N","Does the company have a clear and well-implemented safety policy, and can demonstrate continuous improvement with safety initiatives?",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$41","v":2},{"$f":"$Q$41","v":0}]
[null,"8Ø","Are there key processes of which only limited personnel are capable to perform? (e.g. NDT, Welding, etc.)",null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Evidence Records: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$O$43","v":2},{"$f":"$Q$43","v":0}]
[{"$f":"COUNTA(A15:A44)","v":0},"Total of Section Corrective Actions",null,null,null,null,null,null,null,null,null,"Section Total (Average of Applicable Elements)",null,null,{"$f":"AVERAGE(O15:P44)","v":2.5333333333333332},null,{"$f":"AVERAGE(Q15:R44)","v":{"$error":"#DIV/0!"}},null,{"$f":"$O$45","v":2.5333333333333332},{"$f":"$Q$45","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max","max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(O15:P44,\"5\")","v":0},null,{"$f":"COUNTIF(Q15:R44,\"5\")","v":0},null,{"$f":"MAX(S15:S44)","v":3},{"$f":"MAX(T15:T44)","v":0}]
[null,"Process Strengths",null,null,null,null,null,null,null,null,null,"Process Weaknesses"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(O15:P44)","v":15},{"$f":"COUNTA(Q15:R44)","v":0}]
[null,"Process Opportunities for Improvement",null,null,null,null,null,null,null,null,null,"Process Threats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"Risk Scoring","index":10,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[32,0,32,13],[33,0,33,13],[38,0,38,6],[39,0,39,6],[36,8,36,13],[38,8,38,13],[39,8,39,13],[35,8,35,13],[35,0,35,6],[36,0,36,6],[21,0,21,4],[22,0,22,4],[23,0,23,4],[15,11,15,12],[16,11,16,12],[29,5,29,6],[17,10,17,13],[1,0,1,3],[2,0,2,3],[3,0,3,3],[20,0,20,4],[2,4,2,6],[3,4,3,6],[1,4,1,6],[19,0,19,3],[18,6,18,8],[14,10,14,13],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,5]]}
[]
["Supplier Name:",null,null,null,{"$f":"Supplier!C5","v":0}]
["Assessment Start Date:",null,null,null,{"$f":"Supplier!C1","v":"00:00:00"}]
["Completed By:",null,null,null,{"$f":"Supplier!C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Risk Rating"]
[null,null,null,null,null,null,null,null,null,null,1,3,null,5]
[null,null,null,null,null,null,null,null,null,null,"Low Risk","Moderate Risk",null,"High Risk"]
[]
[null,"Sections",null,null,null,null,"Questions Completed",null,null,"Concerns ","Consequence Section Average","No. of Highest Risk Consequence Scores (5's)","Probability Section Average","No. of Highest Risk Probability Scores (5's)"]
["1.   Contract Review",null,null,null,null,null,{"$f":"'1. Contracts'!$S$39","v":10},"of ",10,{"$f":"'1. Contracts'!$A$35","v":0},{"$f":"'1. Contracts'!$O$35","v":2.1},{"$f":"'1. Contracts'!$O$37","v":0},{"$f":"'1. Contracts'!$Q$35","v":{"$error":"#DIV/0!"}},{"$f":"'1. Contracts'!$Q$37","v":0}]
["2.   Capability",null,null,null,null,null,14,"of ",14,{"$f":"'2 Capability'!$A$43","v":0},{"$f":"'2 Capability'!$O$43","v":2.3571428571428572},{"$f":"'2 Capability'!$O$45","v":0},{"$f":"'2 Capability'!$Q$43","v":{"$error":"#DIV/0!"}},{"$f":"'2 Capability'!$Q$45","v":0}]
["3.   Capacity",null,null,null,null,null,{"$f":"'3 Capacity'!$S$35","v":8},"of ",8,{"$f":"'3 Capacity'!$A$31","v":0},{"$f":"'3 Capacity'!$O$31","v":2.875},{"$f":"'3 Capacity'!$O$33","v":0},{"$f":"'3 Capacity'!$Q$31","v":{"$error":"#DIV/0!"}},{"$f":"'3 Capacity'!$Q$33","v":0}]
["4.   Inspection ",null,null,null,null,null,{"$f":"'4 Inspection'!$S$48","v":14},"of ",14,{"$f":"'4 Inspection'!$A$43","v":0},{"$f":"'4 Inspection'!$O$43","v":2.7142857142857144},{"$f":"'4 Inspection'!$O$45","v":0},{"$f":"'4 Inspection'!$Q$43","v":{"$error":"#DIV/0!"}},{"$f":"'4 Inspection'!$Q$45","v":0}]
["5.   Supply Chain Mgmt",null,null,null,null,null,{"$f":"'5 SCM'!$S$62","v":21},"of ",21,{"$f":"'5 SCM'!$A$57","v":0},{"$f":"'5 SCM'!$O$57","v":2.4285714285714284},{"$f":"'5 SCM'!$O$59","v":0},{"$f":"'5 SCM'!$Q$57","v":{"$error":"#DIV/0!"}},{"$f":"'5 SCM'!$Q$59","v":0}]
["6.   Planning & Operations",null,null,null,null,null,{"$f":"'6 Planning & Operations'!$S$36","v":8},"of ",8,{"$f":"'6 Planning & Operations'!$A$31","v":0},{"$f":"'6 Planning & Operations'!$O$31","v":2.625},{"$f":"'6 Planning & Operations'!$O$33","v":0},{"$f":"'6 Planning & Operations'!$Q$31","v":{"$error":"#DIV/0!"}},{"$f":"'6 Planning & Operations'!$Q$33","v":0}]
["7.   Quality & CI",null,null,null,null,null,{"$f":"'7 Quality & CI'!$S$72","v":26},"of ",26,{"$f":"'7 Quality & CI'!$A$67","v":0},{"$f":"'7 Quality & CI'!$O$67","v":2.3461538461538463},{"$f":"'7 Quality & CI'!$O$69","v":0},{"$f":"'7 Quality & CI'!$Q$67","v":{"$error":"#DIV/0!"}},{"$f":"'7 Quality & CI'!$Q$69","v":0}]
["8.   Resources",null,null,null,null,null,{"$f":"'8 Resources'!$S$50","v":15},"of ",15,{"$f":"'8 Resources'!$A$45","v":0},{"$f":"'8 Resources'!$O$45","v":2.5333333333333332},{"$f":"'8 Resources'!$O$47","v":0},{"$f":"'8 Resources'!$Q$45","v":{"$error":"#DIV/0!"}},{"$f":"'8 Resources'!$Q$47","v":0}]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G20:G27)","v":116},"of ",{"$f":"SUM(I20:I27)","v":116},{"$f":"SUM(J20:J27)","v":0},{"$f":"AVERAGEIF(K20:K27,\"<>#DIV/0!\")","v":2.4974358974358974},{"$f":"SUM(L20:L27)","v":0},{"$f":"AVERAGEIF(M20:M27,\"<>#DIV/0!\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N20:N27)","v":0}]
[]
[null,null,null,null,null,"% of Questions Completed",null,{"$f":"(G28/I28)","v":1}]
[]
[]
["Comments:"]
[]
[]
["Strengths",null,null,null,null,null,null,null,"Weaknesses"]
[]
[]
["Opportunities for Improvement",null,null,null,null,null,null,null,"Threats"]