Six Sigma DFA DFM Analysis Matrix

Description

Six Sigma spreadsheets for your quality toolbox!

Reviews
Shared by: Jason Cardinal
Categories
Tags
Stats
views:
105
rating:
not rated
reviews:
0
posted:
8/15/2009
language:
English
pages:
0
DFA-DFM Analysis Summary Date Product Part No. 8/30/2000 Rev. 1 Used on Part No. Final Assembly Number of Sub-Assemblies Team Leader Team Members 1 2 3 4 5 6 7 8 Name Name Name Name Name Name Name Name Name Origination Design Manufacturing Quality Finance Purchasing Suppliers 9 10 11 12 13 14 15 16 Name Name Name Name Name Name Name Name Name Origination DFA - Results (Configuration Optimization) SubAssembles Theoretical Min. Parts Standard Parts Mistake Proofing Issues Handling Issues Insertion Issues Further Processing Items Part Count Practical Min. Parts Original/Optimized Configuration Original Configuration Theoretical Part Efficiency Mistake Proofing Index 15 2 4 11 7 Further Processing Index 5 7 Practical Part Efficiency 0.1 Target 3.5 <1 Handling Index 2.5 <1 Insertion Index 3.5 <1 0.3 ? <1 DFM - Results (Production Readiness) DFA Completed 01/22/00 SubAssembly # of Critical Parameters Process Capability Study Completed Percent Capability Studies Completed Number of Total Tooling Total Tooling Tolerance Analysis Required Available Performed Percent of Tooling Completed Percent of Drawings Completed Design Efficiency 2 21 9 42.86% Number of different Mounting and Fastening Hardware Types Screws 1 Nuts 1 C Washers, Lock 1 A 1 D Washers, Flat 1 B 1 E 5 1 1 1 4 2 50.00% 20.00% Assembly Sigma for Assembly RTY Parts Studied 1.333 43.62% Control Signature Page 1 of 6 DFADFMANALYSIS-EN-XLS Assembly Name Ballpoint pen Mistake Proofing Assemble wrong part / omit part Assembled part wrong way around Theoretical Min. Part Nest / Tangle / Stick together Not Standard or non shared part Practical Min. Parts Part Cost (1, 3, 9) Team Leader Parts Handling Hold down required Not easy to see correct orientation Handling aid / two hands Flexible/ Fragile / Sharp / Slippery Difficult to align / locate Insertion Not from above / not straight line Obstructed access / visibility Resistance to insertion Further Processing Screw / Drill / Twist / Rivet / Bend / Crimp Weld / Solder / Glue Paint / Lube / heat / Apply liquid or gas Test / Measure / Adjust Re-orientate workpiece ID Number Quantity Part Description 1 2 3 4 5 1 1.1 1.2 1.3 1.4 1.5 2 2.1 2.2 2.3 3 3.1 3.2 3.3 3.4 6 7 8 9 10 11 12 13 14 15 Total Parts 15 Sub-Assemblies 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Ink cartridge Tip interface Barrel Tip Ink cap Ball bearing Bottom End Tip cover Spring Grip Activation End Upper barrel Clip Plunger Ratcheting mechanism Y Y N N Y N N N N N N N Y Y Y N Y Y N N N N N N Y Y Y Y Y Y Y Y Y Y Y Y 1 1 1 1 1 1 1 1 1 1 1 1 N N N Y N N Y Y N N N Y N N N N N N N Y N N Y Y N N N N N N Y N N Y N N N N Y Y Y N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N Y N N N N N N N N Y N N N Y N N N Y N N N N N N N N N N N N N N Y N N N Y N N Y N Y N N Totals 2 4 11 11 Categories Totals 4 7 3 2 3 5 0 0 1 2 0 7 4 0 0 0 0 0 0 0 Page 2 of 6 DFADFMANALYSIS-EN-XLS Implementation 1 2 3 4 5 Long Term 6 7 8 9 10 1 2 3 4 5 Medium Term 6 7 8 9 10 1 2 3 4 5 Short Term 6 7 8 9 10 Low Medium High Risk Page 3 of 6 DFADFMANALYSIS-EN-XLS http://templatestaff.com Assembly Name # of Critical Parameters Process Capability Study Completed SubAssembly Process Standard Deviation Team Leader Standard Material Number of Processin g Steps Y 4 2 1 Tooling Available for Data Critical Tolerances Tooling Required RTY estimate Part Number Quality Part Description 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 1.1 1.2 1.3 1.5 2.1 2.2 2.3 3 3.1 3.2 3.3 3.4 1 1 1 1 1 1 1 1 1 1 1 1 1 Ink cartridge Tip interface Tip Ink cap Ball bearing Tip cover Spring Grip Activation End Upper barrel Clip Plunger Ratcheting mechanism 1 3 3 3 Y 0.001 0 66.043% Y Y Y 1 3 3 3 Y 0.0005 0 99.998% Y Y Y 3 Totals 13 2 21 Y 9 0.001 0 66.043% 43.616% Hardware Analysis Screws No. 1 2 3 4 5 1 2 3 4 Size 1/4-20 UNC-2B x 1.5 lg Material CRES Drawing Readiness Plating Head Type Qty Drawing Needed Drawings Completed Phil 3 25 5 Percent Complete 20.00% Washers, Flat 1/4 " CRES 6 Page 4 of 6 DFADFMANALYSIS-EN-XLS Washers, Lock 1 2 3 4 1 2 3 4 5 6 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5 1/4" split CRES 3 Nuts 1/4-20 unc-2B Hex Size 3 A 1/-20UNC-25 PEM STUD CRES 6 B t C t D t Page 5 of 6 DFADFMANALYSIS-EN-XLS E 1 2 3 4 5 t Page 6 of 6 DFADFMANALYSIS-EN-XLS

Related docs
Six Sigma
Views: 793  |  Downloads: 104
Value of Six Sigma
Views: 0  |  Downloads: 0
Six Sigma Lean Manufacturing Plan
Views: 95  |  Downloads: 48
Six Sigma Cause & Effect Matrix
Views: 440  |  Downloads: 32
Six Sigma Pugh Matrix
Views: 138  |  Downloads: 24
Six Sigma Participation Matrix
Views: 33  |  Downloads: 17
Six Sigma Pugh Matrix V2
Views: 310  |  Downloads: 32
Six Sigma Software Quality Matrix
Views: 135  |  Downloads: 29
Six Sigma Design Score Matrix
Views: 73  |  Downloads: 15
Six Sigma Morphological Matrix
Views: 80  |  Downloads: 16
Six Sigma Design Concept Matrix
Views: 72  |  Downloads: 31
Six Sigma Template
Views: 2156  |  Downloads: 642
Other docs by Jason Cardinal
Six Sigma Z Table
Views: 102  |  Downloads: 11
Six Sigma Vendor Evaluation
Views: 155  |  Downloads: 24
Six Sigma Toll Gate Road Map
Views: 135  |  Downloads: 9
Six Sigma Toll Gate Checklist
Views: 288  |  Downloads: 29
Six Sigma Test Report
Views: 58  |  Downloads: 14
Six Sigma Test Case Checklist
Views: 181  |  Downloads: 10
Six Sigma Technical Training Plan
Views: 48  |  Downloads: 10
Six Sigma Supplier Evaluation Form
Views: 698  |  Downloads: 78
Six Sigma Sum Squares
Views: 91  |  Downloads: 19
Six Sigma Solution Tree
Views: 86  |  Downloads: 17
Six Sigma Software Quality Matrix Deluxe
Views: 73  |  Downloads: 25
Six Sigma Software Quality Matrix
Views: 135  |  Downloads: 29
Six Sigma Shift & Drift Table
Views: 65  |  Downloads: 15
Six Sigma Sales Report
Views: 76  |  Downloads: 25
Six Sigma Regression Sum
Views: 51  |  Downloads: 11