{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form","Detail questions (if needed)","SPSO Action Item List"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"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":"Form","index":0,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,2,33,3],[35,2,35,3],[9,11,9,14],[41,10,41,12],[3,11,3,14],[5,11,5,14],[7,11,7,14],[3,4,3,8],[5,4,5,8],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[51,4,51,8],[53,4,53,8],[49,4,49,8],[7,4,7,8],[9,4,9,8],[45,4,45,8],[47,4,47,8]]}
[null,null,null,null,null,null,null,null,"Supplier Process Sign-Off Summary"]
[]
[]
[null,null,null,"Program Model Yr./Name: ",null,null,null,null,null,null,"Date of SPSO: "]
[]
[null,null,null,"Part/Assembly Name: ",null,null,null,null,null,null,"GHSP User Site: "]
[]
[null,null,null,"Part #: ",null,null,null,null,null,null,"Part Rev Level: "]
[]
[null,null,null,"Supplier Name: ",null,null,null,null,null,null,"Revision Date:"]
[]
[]
[null,"Document ",null," Implemented"]
[]
[null,"G/Y/R",null,"G/Y/R",null,null,"Requirement"]
[1,null,null,null,"Plant Layout & Process Flow Diagram complete"]
[2,null,null,null,"Design and Process FMEA complete (as applies)"]
[3,null,null,null,"Product Control Plan available"]
[4,null,null,null,"Purchased Components Readiness / Sub-supplier Part Submission complete"]
[5,null,null,null,"Product Specifications/Drawings/Blueprints available"]
[6,null,null,null,"Tooling, Equipment, and Fixtures identified"]
[7,null,null,null,"Operators Trained and Instructions available"]
[8,null,null,null,"Parts Handling Plan available"]
[9,null,null,null,"Parts Packaging/Shipping Specifications available"]
[10,null,null,null,"Key Quality Systems demonstrated"]
[11,null,null,null,"Containment Plan available"]
[12,null,null,null,"Preventive Maintenance plans established"]
[13,null,null,null,"Gage & Check Fixture R&R studies completed "]
[14,null,null,null,"Production Validation complete (as applies)"]
[15,null,null,null,"Line Speed and Capacity verified"]
[16,null,null,null,"Materials Readiness demonstrated"]
[]
[null,null,null,null,null,null,null,null,null,null,"Line Speed and Yield"]
[null,null,null,null,null,null,null,null,"# of Good parts built",null,null,"(A)"]
[null,null,null,null,null,null,null,null,"# of Total parts built",null,null,"(B)"]
[null,null,null,null,null,null,null,null,"Total run time, min.",null,null,"(C)"]
[null,null,null,null,null,null,null,null,"Build Rate, min/pc (=C/A)",{"$f":"J36/J34","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Yield, % (=A/B * 100)",{"$f":"(J34/J35)*100","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,"Y/N"]
[null,null,null,null,null,"Onsite revisit required?",null,null,null,"Date Planned:"]
[]
["Approvals"]
[]
[null,null,null,"GHSP SDE:",null,null,null,null,null,null,"GREEN"," - Element complete"]
[]
[null,null,null,"Supplier's Quality Eng:",null,null,null,null,null,null,"YELLOW"," - Not complete, but little risk"]
[]
[null,null,null,"Supplier's Project Mgr:",null,null,null,null,null,null,"RED"," - Element not complete"]
[]
[null,null,null,"Other Approvals:"]

{"sheet":"Detail questions (if needed)","index":1,"n_rows":166,"n_cols":5,"rows_kept":166,"cut":false,"hidden":false,"merged":[[4,3,4,4],[2,3,2,4]]}
[null,null,"Supplier PSO  - Detailed Questions"]
[]
[null,null,{"$f":"Form!D4","v":"Program Model Yr./Name: "},{"$f":"Form!E4","v":0}]
[]
[null,null,{"$f":"Form!D10","v":"Supplier Name: "},{"$f":"Form!E10","v":0}]
[]
[null,null,{"$f":"Form!K4","v":"Date of SPSO: "},{"$f":"Form!L4","v":"00:00:00"}]
[null,"1.","Plant Layout and Process Flow Diagram"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$8","v":"1."},"1","Is there a dated copy of the current floor plan readily available?"]
[{"$f":"B$8","v":"1."},"2","Does the floor plan identify the following:\n  All required assembly, process and inspection stations?\n  Locations for all raw material, work in process (WIP) and finished product?"]
[{"$f":"B$8","v":"1."},"3","Are process flowcharts dated and current?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$8","v":"1."},"4","Does the actual material and production flow follow the process flowchart?"]
[{"$f":"B$8","v":"1."},"5","Does each workstation provide adequate lighting and sufficient space to promote effective working conditions?"]
[{"$f":"B$8","v":"1."},"6","Are inspection point locations effective in preventing shipment of nonconforming products and clearly identified?"]
[{"$f":"B$8","v":"1."},"7","Is there an identified area for nonconforming material, segregated from the manufacturing area?"]
[{"$f":"B$8","v":"1."},"8","Is the procedure to re-qualify all reworked/repaired material being followed?"]
[null,"2.","Design and Process FMEA"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[null,null,"DFMEA  (If Supplier is Design responsible)"]
[{"$f":"B$19","v":"2."},1,"Does the DFMEA have the correct Part #, Revision Level, Orig. Date and Rev. Date?"]
[{"$f":"B$19","v":"2."},2,"Does the DFMEA include all functional specifications, appearance specifications, CC/SCs and Star dimensions as defined by GHSP drawings?"]
[{"$f":"B$19","v":"2."},3,"Are there RPN calculations for each failure mode and recommended actions for high risk RPN's"]
[null,null,"PFMEA "]
[{"$f":"B$19","v":"2."},4,"Does the PFMEA include all GHSP and internal CC/SCs and Star dimensions as defined by GHSP drawings?"]
[{"$f":"B$19","v":"2."},5,"Are there RPN calculations for each failure mode and recommended actions for high risk RPNs"]
[{"$f":"B$19","v":"2."},6,"Does the PFMEA follow the process flow?"]
[{"$f":"B$19","v":"2."},7,"Does the PFMEA address all rejections from PTR's or lessons learned and RPN's calculated?"]
[null,"3.","Production Control Plan"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$30","v":"3."},1,"Does the Control Plan have the correct Part #, Revision Level, Orig. Date and Rev. Date?"]
["3.",2,"Does the control plan follow the process flowchart?"]
["3.",3,"Does the Control Plan include the following: Incoming Inspection, In-process Inspection & Controls, Final Part Audit, Pre-Launch Containment Requirements, and annual submissions?"]
["3.",4,"Does the Control Plan include all the CC/SC's and Star dimensions as defined by GHSP drawings?"]
["3.",5,"Are appropriate potential failure modes, as identified in the PFMEA, addressed through the control plan? "]
["3.",6,"Does Control Plan include both gage and test requirements?\n(including quantity, frequency, and required specifications?)"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$30","v":"3."},7,"Are all controls (including SPC), identified on the PFMEA and Control Plan, being used in the production process?"]
[{"$f":"B$30","v":"3."},8,"Are all controls verified on a periodic basis to ensure desired results?"]
[{"$f":"B$30","v":"3."},9,"Are all the elements of the control plan being followed?"]
[null,"4.","Purchased Components Readiness / Sub-supplier Part Submission Process"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$42","v":"4."},1,"Does the supplier have a Bill of Mateiral?"]
[{"$f":"B$42","v":"4."},2,"For each component/supplier with long lead times, do you have an action plan to ensure that adequate material is available to support GHSP's production needs?"]
[{"$f":"B$42","v":"4."},3,"Are current specifications available for supplied material?"]
[{"$f":"B$42","v":"4."},4,"Has an acceptable certification program for incoming material been implemented?"]
[{"$f":"B$42","v":"4."},5,"Are there approved Sub-supplier PPAP packages available for ALL Supplier-purchased components?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$42","v":"4."},6,"Are controls in place to isolate and inspect incoming material? (as determined by projected incoming quality levels) "]
[{"$f":"B$42","v":"4."},7,"Is there an effective lot traceability system in place?"]
[null,"5.","Product Specifications & Drawings"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$52","v":"5."},1,"Is the current revision of the GHSPs' specification(s) on hand?"]
[{"$f":"B$52","v":"5."},2,"Are specifications reflected on drawings correctly?"]
[{"$f":"B$52","v":"5."},3,"Are there any GHSP customer specification(s) on hand and are they the latest revision level?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS - None"]
[null,"6.","Tooling, Equipment & Fixtures Identified"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$58","v":"6."},1,"Has a GHSP tooling and gage sketch form been completed and approved?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$58","v":"6."},2,"Is all equipment, gauging and tooling the same as will be used in production? "]
[{"$f":"B$58","v":"6."},3,"Are all tools, equipment and fixtures clearly identified with a number, and with \"Property of ____________\"?"]
[null,"7.","Operator Training & Instructions"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$64","v":"7."},1,"Has a  staffing plan been developed to cover launch acceleration and full production requirements?"]
["7.",2,"Have all support personnel been identified and has this been communicated to the manufacturing team?"]
["7.",3,"Have all off-line job responsibilities been identified and assigned to qualified team members?"]
["7.",4,"Have production trainers been identified for each shift?"]
["7.",5,"Has a training matrix been set up to track team member training on these procedures?"]
["7.",6,"Is a system in place to certify & re-certify operators?"]
["7.",7,"Is a system in place to verify operator training on gages, visual aids, and operator instructions?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$64","v":"7."},8,"Are there set-ups, instructions and verification checklists posted for all equipment and operations?  Are they being followed?"]
[{"$f":"B$64","v":"7."},9,"Are visual aids (including appropriate boundary samples) and operator instructions readily accessible by the operators at each station and being followed?"]
[{"$f":"B$64","v":"7."},"10","Are visual aids dated, approved & current?"]
[{"$f":"B$64","v":"7."},11,"Are inspection gages and gage instructions readily available?"]
[{"$f":"B$64","v":"7."},12,"Are rework and repair procedures in place and being followed?"]
[null,"8.","Parts Handling Plan"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$79","v":"8."},1,"Have the handling and storage requirements of material, including delicate components, been reviewed? "]
[{"$f":"B$79","v":"8."},2,"Are orders in place on components & packaging to support on-time production requirements?                      "]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$79","v":"8."},3,"Is the storage of material adequate to protect it from environmental factors?"]
[{"$f":"B$79","v":"8."},4,"Is the storage location for components organized, monitored, and properly labled?"]
[{"$f":"B$79","v":"8."},5,"Have controls been established to eliminate the potential for an operation to contaminate or mix similar products?"]
[{"$f":"B$79","v":"8."},6,"Is the access to components limited to authorized personnel?"]
[null,"9.","Parts Packaging/Shipping Specifications"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$88","v":"9."},1,"Has adequate protective packaging for finished product been defined?"]
["9.",2,"Have records of test shipping containers and trips been documented?  (if applicable)"]
["9.",3,"Does the label meet GHSP requirements?"]
["9.",4,"Have you completed and submitted GHSP Packaging Sketch Forms for all components?"]
["9.",5,"Is your system ready to send Advance Ship Notices (ASN) for these parts?"]
[{"$f":"B$88","v":"9."},6,"Has the supplier been set up in the GHSP SV system (if a new supplier) and has training been completed with the supplier?"]
["9.",7,"Has the shipping system been established to include:\n 1) Ship to Location\n 2) Shipment Frequency & Window\n 3) Primary Carrier\n 4) Expedite Carrier\n 5) Container Return/Maintenance for returnables\n 6) Saturday <Weekend?> Shipments\n 7) Freight Ownership & Payment\n 8) Production Label Formats"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$88","v":"9."},8,"Is packaging approved by the GHSP Packaging Engineer?"]
[{"$f":"B$88","v":"9."},9,"Does labeling of production packaging meet standards?"]
[null,"10.","Key Quality Systems"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$100","v":"10."},1,"Has pilot build data been collected and stored?"]
["10.",2,"Is there a returned material authorization (RMA) process in place?"]
["10.",3,"Is there a procedure to re-qualify all reworked/repaired material?"]
["10.",4,"Are systems in place for continuous data collection to drive process improvement for this part?"]
["10.",5,"Does the problem solving system incorporate the 8-D, or like processes (I.E.  Customer specific methods; 7-Step, 5 Phase, etc.)?"]
[{"$f":"B$100","v":"10."},6,"Are all part-specific 8D's which impact this product resolved?"]
["10.",7,"Have all lessons learned been communicated by GHSP for like or similar parts?"]
[" ",null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$100","v":"10."},8,"Is the system being followed to ensure the correct revision level is in place for all engineering documents? (Specifications, PFMEA, Control Plans, Setup Sheets, Operator Instructions, Visual Aids)"]
[{"$f":"B$100","v":"10."},9,"Are all \"Master Good / Master Bad\" samples available on line?  Are they signed & dated?                                                                                  "]
[{"$f":"B$100","v":"10."},10,"Are trends and out of control situations being noted and corrected?"]
[null,"11.","Containment Plan "]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$113","v":"11."},1,"Are there procedures in place to protect customer in the event of 'Customer Complaint' or PTR?"]
[{"$f":"B$113","v":"11."},2,"Do these procedures ensure complete isolation of suspect material, at both customer and supplier locations?  At transportation and storage locations? "]
[{"$f":"B$113","v":"11."},3,"Do Containment procedures drive/trigger problem solving?"]
[{"$f":"B$113","v":"11."},4,"Is the containment plan adequate to launch a defect-free product?"]
[{"$f":"B$113","v":"11."},5,"Is there a Plant Contingency Plan written?"]
[" ",null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$113","v":"11."},6,"Are the containment audit(Safe Launch, GP12, Etc.) instructions in place and being followed?  Posted at the station/process where the inspection takes place?  (Instructions clearly visible.  Non-conforming parts should be clearly marked as such and segregated, until the audit has been completed.)"]
[{"$f":"B$113","v":"11."},7,"Are there Labeling and Scanning instructions available?    If necessary check for instructions regarding handling of parts prior to containment."]
[{"$f":"B$113","v":"11."},8,"Are the Final Part Audit Instructions written and approved?"]
[{"$f":"B$113","v":"11."},9,"Is the team tracking the production builds and Containment audit results on the Launch Containment Chart?  Are the issues being resolved?"]
[null,"12.","Preventive Maintenance Plans"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$125","v":"12."},1,"Has a preventive maintenance system been established for each piece of equipment?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$125","v":"12."},2,"Is the preventive maintenance system being followed?"]
[{"$f":"B$125","v":"12."},3,"Is there an adequate supply of perishable tooling available in house?"]
[{"$f":"B$125","v":"12."},4," Are all \"Master Good / Master Bad\" samples on the Preventative Maintenance schedule?                                                                                  "]
[null,"13.","Gage & Check Fixture Evaluation"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$132","v":"13."},1,"Have all functional gages been dimensionally certified?"]
["13.",2,"Were gage R&R's performed and acceptable (<10%) on all variable data measuring instruments? (ref. AIAG \"Measurement Systems Analysis\" manual)"]
["13.",3,"Were gage R&R's performed and acceptable (ref. AIAG \"Measurement Systems Analysis\" manual) on all attribute measuring instruments? (if required)"]
["13.",4,"Are procedures in place to calibrate test & measurement equipment on a regular basis?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$132","v":"13."},5,"Are identified master good & master bad parts in place for the build?"]
[{"$f":"B$132","v":"13."},6,"Are all gages and test equipment properly calibrated and traceable to a known standard?"]
[{"$f":"B$132","v":"13."},7,"Are Engineering Change levels and calibration dates clearly called out on all gages?"]
[{"$f":"B$132","v":"13."},8,"Do gages and test fixtures properly locate the part (ref. part drawing) and check necessary part features?"]
[{"$f":"B$132","v":"13."},9,"Are procedures being followed to calibrate test & measuring equipment on a regular basis?"]
[null,"14.","Product Validation Complete"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$144","v":"14."},1,"Is Design Validation and Production Validation data present for all items requiring validation? "]
[{"$f":"B$144","v":"14."},2,"Has all the validation data been analyzed with acceptable results?"]
[{"$f":"B$144","v":"14."},3,"If any items in 14.2 are not acceptable has a deviation been requested and approved from GHSP?"]
[{"$f":"B$144","v":"14."},4,"Are all specifications and measurement method(s) agreed among GHSP and the supplier?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$144","v":"14."},5,"Is the validation equipment capable of performing all the tasks required to test product to GHSP product validation specifications?"]
[null,"15.","Line Speed & Capacity Verified"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$152","v":"15."},1,"Has a machine process capability study been done and documented on all pieces of equipment?"]
["15.",2,"Are projected ramp-up and peak demands known?"]
["15.",3,"Has your manufacturing capacity plan been formulated to accommodate schedule changes?"]
["15.",4,"Has there been a successful Run @ Rate performed to GHSP capacity requirements and submitted to the Buyer?"]
["15.",5,"Have contingency plans/ safety stock been established to support production for 2 days in the event of equipment breakdown or force majeure?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS"]
[{"$f":"B$152","v":"15."},6,"Is capacity sufficient to meet GHSP peak production demands?"]
[{"$f":"B$152","v":"15."},7,"Do the number of acceptable pieces coming off the end of line meet or exceed production requirements?"]
[null,"16.","Materials Readiness Demonstrated"]
[null,null,"DOCUMENTATION QUESTIONS","STATUS (G/Y/R)","Comments"]
[{"$f":"B$162","v":"16."},1,"Have all purchased components been released and inventory in place?"]
[{"$f":"B$162","v":"16."},2,"Is cycle count frequency for components, WIP and finished goods appropriate for this product?"]
[null,null,"IMPLEMENTATION / PROCESS QUESTIONS - None"]

{"sheet":"SPSO Action Item List","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[28,4,28,5],[29,4,29,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[7,4,7,5],[5,3,5,4],[2,6,2,7],[3,6,3,7],[4,6,4,7],[2,3,2,4],[3,3,3,4],[4,3,4,4]]}
[null,null,null,"SPSO Action Item List"]
[]
[null,null,"Program Name: ","(Customer, model yr, name)",null,"Program #: "]
[null,null,"Part Name: ",null,null,"Rev. Level: "]
[null,null,"Part Number:",null,null,"Last rev. date: "]
[null,null,"Date of Review: "]
[null,null,null,null,null," "]
[null,"Quest. #","Issue","Person Responsible","Corrective Action Plan",null,"Target due date","Completion date"]