Six Sigma Design Score

Description

Six Sigma spreadsheets for your quality toolbox!

Reviews
Shared by: Jason Cardinal
Categories
Tags
Stats
views:
116
rating:
not rated
reviews:
0
posted:
8/15/2009
language:
English
pages:
0
Technical Specifications Dimensions: (inches) Folded Upright Weight Max Speed Carrying Load Max Angle of Ascent Brake Tire Motor Drive Battery Charge Input Charge Output Recharge Time Range per Charge Length 50 50 30 40 250 7 SigmaScoot - SS1 Width 12 24 Height 10 30 Key Product Features Light Weight yet strong Al alloy Foldable for easy transportation Clean - No grease. No pollution Quiet operation Stable and comfortable Sleek lbs incl battery mph lbs degrees 150lb Load Rear Drum Type 10 X 2 inches Pneumatic 24 Volts DC Timing Belt 12 Volts DC 115/230 Volts AC 24 Volts 4 hours 60 miles 180 Watts 12 A (2) 60/50 Hz DC Technical Specifications Dimensions: (inches) Folded Upright Weight Max Speed Carrying Load Max Angle of Ascent Brake Tire Motor Drive Battery Charge Input Charge Output Recharge Time Range per Charge Length 50 50 35 40 240 6 SigmaScoot - SS2 Width 12 24 Height 10 30 Salient Features Light Weight yet strong Al alloy Foldable for easy transportation Clean - No grease. No pollution Quiet operation Stable and comfortable Sleek Foldable seat (Option) lbs incl battery mph and seat lbs degrees 150lb Load Rear Drum Type 10 X 2 inches Pneumatic 24 Timing Belt 12 115/230 24 4 60 Volts DC Volts DC Volts AC Volts hours miles 180 Watts 12 A (2) 60/50 Hz DC Page 1 of 27 SCORE2-EN-XLS CTQ Parameter Length Finish Economy Comfort Metric Unit inches defects miles/charge minutes Data Type Continuous Attribute Continuous Continuous VOC Target USL 60 0 60 30 LSL 20 Design Output LT/S T ST ST ST ST mean m Std. Dev s 50.0 0.30 70.0 40.0 2.0 DPU 10.0 8.0 Performance Z USL Z LSL 5.0 n/a n/a n/a 15.0 n/a 1.0 1.3 Total DPM 0.3 259,182 158,655 105,650 442,566 RTY 100% 74% 84% 89% 56% Z Bench UDPU LDPU 5.000 2.867E-07 0 0.646 n/a n/a 1.000 n/a 0.15865525 1.250 0.144 n/a 0.10564977 Overall Design Performance Average Performance Total Number of Parameters Avg Defect per parameter Normalized Yield per parameter Avg Parameter ST Sigma 4 135931 86.4% 1.099 Exercise: CTQ Parameter Length Finish Economy Comfort Metric Unit inches defects miles/charge minutes Data Type Continuous Attribute Continuous Continuous VOC Target USL 60 0 60 15 LSL 20 Design Output LT/S T mean m Std. Dev s ST ST ST ST 50.0 0.30 70.0 13.8 2.0 DPU 10.0 4.3 Performance Z USL Z LSL 5.0 n/a n/a n/a 15.0 n/a 1.0 -0.3 Avg Total DPM 0.3 259,182 158,655 610,227 757,061 RTY 100% 74% 84% 39% 24% Z Bench UDPU LDPU 5.000 2.867E-07 0 0.646 n/a n/a 1.000 n/a 0.15865525 -0.280 n/a 0.61022734 -0.697 Overall Design Performance Average Performance Total Number of Parameters Avg DPM per parameter Normalized Yield per parameter Avg Parameter ST Sigma 4 297940 70.2% 0.530 Page 2 of 27 SCORE2-EN-XLS Page 3 of 27 SCORE2-EN-XLS Mean 13.8 20 16 12 19 23 17 12 12 10 8 9 7 18 13 14 17 12 15 Std Dev 4.287 Page 4 of 27 SCORE2-EN-XLS 13 9 Page 5 of 27 SCORE2-EN-XLS Foldable Motorized Scooter Number of sub-components Avg defects/sub-component Avg RTY/sub-component Avg sub-component Sigma 5 6469.982 99.36% 2.487 RSS-1 SIGMASCOOT DPMO 32349.9 RTY 96.82% Z Bench 1.855 30000 RSS-1 Source SigmaScoot Co. SigmaScoot Co. Spyro Gyra Roto Moto Co. Totals Qty 1 1 2 1 5 SIGMASCOOT DPM DPMO 9500 9500 6350 6349.91 4000 8000 8500 8500 Foldable Motorized Scooter Component Name Steering & Fork Assembly Frame & Deck Assembly Wheel & Brake Assembly Motor Assembly Part No. SFA001 FAD002 WAB003 MDA004 Count 20000 32350 10000 0 Count Percent Cum % Steering and Fork Assembly Component Name Fork Steering Tube T-Post Handle Bar Handle Part No. FA007 ST008 TP009 HB010 HA020 SFA001 Source Sigma Foundaries General Tubes General Tubes General Tubes Rubber Products Totals FAD002 Source Sigma Foundaries Sigma Foundaries Board Walk inc Exite Electronics Totals Qty 1 1 1 1 4 Qty 1 1 1 1 2 6 SigmaScoot Co. DPM 2500 1000 1000 1000 2000 DPMO 2500 1000 1000 1000 4000 9500 Sigmascoot Co. DPM DPMO 250 250 300 300 999.9 999.908 4800 4800 Frame and Deck Assembly Component Name Collar Joint Lever Scooter Deck Battery Assembly Part No. FAC001 FAJ002 FSD001 BAT001 6350 Roto Moto Co Motor Assembly Component Name Direct Drive DC Motor Belt Drive Dial Indicator Motor Housing MDA004 Part No. MDC002 BDR004 DIAL009 FWA16 Source Roto Moto Co Roto Moto Co RJ Instruments Sigma Metals Totals Qty 1 1 1 1 4 DPM 2000 1000 500 5000 DPMO 2000 1000 500 5000 S 9000 8000 7000 6000 5000 4000 3000 2000 8500 Count Page 6 of 27 SCORE2-EN-XLS S 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 Wheel and Brake Assembly Component Name Metal Wheel Rubber Tire Brake Assembly Axle Part No. MDC002 BDR004 DIAL009 FWA16 WAB003 Source Spyro Gyra Rubber Products Spyro Gyra Spyro Gyra Totals Qty 1 1 1 1 4 Spyro Gyra DPM 2000 1000 500 500 DPMO 2000 1000 500 500 4000 Defect Count Percent Cum % Count 40 4 4 Seat Assembly Component Name Seat Tube Seat Post Seat RSA002 Part No. RST007 RSP008 RSS009 SigmaScoot Co. Source General Tubes General Tubes Champion Seats Totals RSS-2 Qty 1 1 1 3 DPM 1000 1000 1500 DPMO 1000 1000 1500 3500 SIGMASCOOT Foldable Motorized Scooter w/Seat Number of sub-components Avg defects/sub-component Avg RTY/sub-component Avg sub-component Sigma 6 5974.985 99.40% 2.515 RSS-1 DPMO 35849.9 RTY 96.48% Z Bench 1.809 Foldable Motorized Scooter Component Name Steering & Fork Assembly Frame & Deck Assembly Wheel & Brake Assembly Motor Assembly Seat Assembly Part No. SFA001 FAD002 WAB003 MDA004 RSA002 SIGMASCOOT Qty 1 1 2 1 1 6 DPM DPMO 9500 9500 6350 6349.91 4000 8000 8500 8500 3500 3500 Source Ramscoot Co. Ramscoot Co. Spyro Gyra Roto Moto Co. Ramscoot Co. Totals 35850 Page 7 of 27 SCORE2-EN-XLS http://templatestaff.com Ramscoot SigmaScoot Component Quality 100 30000 80 Count 20000 60 40 10000 or k &F ng l y eri Ste s emb As 0 Count Percent Cum % ly tor Mo semb As 8500 26.3 55.6 Br a l& ee bl y Wh s em As ke k ec &D me l y Fra s em b As 20 0 9500 29.4 29.4 8000 24.7 80.4 6350 19.6 100.0 Scooter Deck Parameter Unit Length Breadth Depth inches inches inches Type Cont Cont Cont Target USL LSL 50 24 1.5 60 30 2 20 20 1 m s Z USL Z LSL 5.0 6.0 3.8 15.0 3.1 6.2 DPM RTY Z Bench UDPU 5.000 3.111 3.814 3.090 2.87E-07 1.12E-09 6.84E-05 50.0 2.0 23.4 1.1 1.62 0.1 0.3 100.0% 931 99.9% 68 100.0% 1,000 99.9% Overall Design Performance Steering & Fork Sub-Component Quality 100 8000 Percent Motor Assembly Su 9000 8000 7000 6000 5000 Page 8 of 27 4000 3000 2000 80 7000 6000 Count Count 60 Percent 5000 4000 3000 2000 SCORE2-EN-XLS 40 20 Steering & Fork Sub-Component Quality 100 8000 Motor Assembly Su 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 80 7000 6000 Count Count 60 40 20 0 le nd Ha rk Fo ar le B nd Ha ng er i St e T e ub t os T-P Percent 5000 4000 3000 2000 1000 0 to r Mo DC Defect Count Percent Cum % Defect Count Percent Cum % g sin ou rH o to M 4000 42.1 42.1 2500 26.3 68.4 1000 10.5 78.9 1000 10.5 89.5 1000 10.5 100.0 5000 58.8 58.8 ec Dir e riv tD 2000 23.5 82.4 Page 9 of 27 SCORE2-EN-XLS LDPU 0 0.000931 3.08E-10 sembly Sub-Component Quality 100 80 60 Page 10 of 27 40 20 Percent SCORE2-EN-XLS sembly Sub-Component Quality 100 80 60 40 20 0 iv Dr r oto CM eD r iv lt D Be e dic l In Dia r at o t ec Dir 2000 23.5 82.4 1000 11.8 94.1 500 5.9 100.0 Page 11 of 27 Percent SCORE2-EN-XLS Assembly Step Steering and Fork Frame and Deck Wheel and Brake Motor Drive Final Assembly Location Source Ramscoot1 Ramscoot2 Spyro Gyra Roto Moto Ramscoot3 # Units/ Product 1 1 2 1 1 MCP Reference RSSF02 RSFD03 SGMD04 RMDR06 RSSS08 Cycle Time Minutes 3 5 5 5 10 Required Labor Process Steps Steering and Fork Assembly Connect handle bar to T-post Insert T-Post into steering tube Attach fork to steering tube Connect handles to bar Frame and Deck Assembly Attach collar to joint lever Connect joint lever to deck Final Assembly Couple steering assembly to collar Mount front wheel and brake Mount rear wheel and brake Connect motor drive to rear wheel Attach battery pack to base Route cables and wires Perform functional tests clearance eccentricity eccentricity tension charge functional angle safety distance force strength location Page 12 of 27 SCORE2-EN-XLS Cost of Material Cost of Labor Page 13 of 27 SCORE2-EN-XLS Steering and Fork Assembly Process Steps/ Process Scorecard Step Process Connect handle bar to T-post Attach fork to steering tube Connect handles to bar 1 1 2 Specifications Process Metric Data Parameter Unit Type angle distance force degrees Cont inch Cont lbs Cont Target USL VOP LT/ mean Std. LSL ST m Dev s 0 0.39 33 1.00 0.10 8.00 0.00 2.00 -2.00 ST 0.40 0.50 0.30 ST 35.00 50.00 20.00 ST Overall Process Performance Average Performance Metrics Total Number of Steps 4 Avg Defect per step 133798 Normalized Yield per step 87% Avg step Sigma 1.1086 Page 14 of 27 SCORE2-EN-XLS Page 15 of 27 SCORE2-EN-XLS Process Performance Scores Z Z Total Yield Z USL LSL DPM RTY Bench UDPU 2.00 2.00 45,500 1.10 0.90 319,726 2.13 1.63 68,875 95% 68% 93% 1.690 0.468 1.484 LDPU 0.0228 0.0228 0.9545 0.1357 0.1841 0.680274 0.0168 0.0521 0.866995 ss Performance 437,042 56% 0.158 56% Page 16 of 27 SCORE2-EN-XLS Avg DPM per Process Avg Process Sigma Seat Assembly Process Process Scorecard Step Connect seat post to tube Attach seat to post Average Performance Metrics Total Number of Steps Avg Defect per step Normalized Yield per step Avg step Sigma Page 17 of 27 SCORE2-EN-XLS Process Scorecard Summary Process Number of Process Steps DPM SigmaScoot Major Processes/Product Steering and Fork Assembly Frame and Deck Assembly Final Assembly Cumulative Scores 1 1 1 3 4 2 5 11 437042 427655 580293 864768 Process RTY 56% 57% 42% 14% Z Bench 0.158 0.182 -0.203 -1.102 Avg Performance Metrics Total Number of Processes 3 Avg DPM per Process 486713 Normalized Yield per Process 51% Avg Process Sigma 0.0333 Total Number of steps 11 Avg DPM per step 166305 Normalized Yield per step 0.8337 Avg Step Sigma 0.9689 Frame and Deck Assembly Process Steps/ Process Metric Process Scorecard Step Process Parameter Unit Attach collar to joint lever Connect joint lever to deck 1 1 strength location lbs inch Specifications Data Type Cont Cont Target USL LSL 300.0 0.3 VOP LT/ mean ST m ST ST 420 0.39 0.50 Overall Process Performance Average Performance Metrics Total Number of Steps 2 Avg Defect per step 243465 Normalized Yield per step 76% Avg step Sigma 0.6952 Solution to Exercise: Process Scorecard Summary Process Number of Process /Product Steps DPM SigmaScoot Major Processes Steering and Fork Assembly Frame and Deck Assembly Seat Assembly Final Assembly B Cumulative Scores Avg Performance Metrics Total Number of Processes 1 1 1 1 4 4 2 2 6 14 437,042 427,655 156,002 599,389 891058 Process RTY 56% 57% 84% 40% 11% Z Bench 0.158 0.182 1.011 -0.252 -1.232 4 Total Number of steps 14 Page 18 of 27 SCORE2-EN-XLS Avg DPM per Process 425488 Normalized Yield per Process 57% Avg Process Sigma 0.1879 Avg DPM per step 146451 Normalized Yield per step 0.8535 Avg Step Sigma 1.0518 Seat Assembly Process Steps/ Process 1 1 Process Metric Parameter Unit distance force inch lb Data Type Cont Cont Specifications VOP LT/ mean ST m ST ST 1.5 75 Process Scorecard Step Connect seat post to tube Attach seat to post Target USL 2.00 LSL 1.00 60.00 Overall Process Performance Average Performance Metrics Total Number of Steps 2 Avg Defect per step 81307 Normalized Yield per step 92% Avg step Sigma 1.3963 Page 19 of 27 SCORE2-EN-XLS Std. Dev s 120.00 0.10 Process Performance Scores Z Z Total Yield Z USL LSL DPM RTY Bench UDPU 1.00 158,655 1.10 0.90 319,726 84% 68% LDPU 1.000 0 0.158655 0.841345 0.468 0.135666 0.18406 0.680274 l Process Performance 427,655 57% 0.182 57% Page 20 of 27 SCORE2-EN-XLS Process Performance Scores Std. Dev s 0.30 10.00 Z Z USL LSL 1.67 1.67 1.50 Total DPM 95,581 66,807 Yield Z RTY Bench UDPU 90% 93% 1.307 1.500 0.04779 LDPU 0.04779 0.904419 0.066807 0.933193 l Process Performance 156,002 84% 1.011 84% Page 21 of 27 SCORE2-EN-XLS Final Assembly Process Process Scorecard Step Couple steering asm to collar Mount wheels and brakes Connect motor drive to wheel Attach battery pack to base Steps/ Process Process Parameter 1 2 1 1 clearance eccentricity tension charge Metric Data Unit Type inch ratio lbs volts Cont Cont Cont Cont Specifications Targ et USL LSL VOP LT/ mean Std. ST m Dev s 0.14 0.00 6.00 24.00 0.02 0.01 1.00 2.00 24 0.15 0.05 ST 0.02 -0.02 ST 7.00 5.00 ST 30.00 20.00 ST Overall Process Performance Average Performance Metrics Total Number of Steps 5 Avg Defect per step 159400 Normalized Yield per step 84% Avg step Sigma 0.9969 Page 22 of 27 SCORE2-EN-XLS Final Assembly Process B Steps/ Process Process Parameter 1 2 1 1 1 clearance eccentricity tension charge location Metric Data Unit Type inch ratio lbs volts inch Cont Cont Cont Cont cont Specifications Targ et USL VOP LT/ mean Std. ST m Dev s Process Scorecard Step Couple steering asm to collar Mount wheels and brakes Connect motor drive to wheel Attach battery pack to base Attach seat assembly LSL 24 0.15 0.05 ST 0.14 0.02 0.02 -0.02 ST 0.00 0.01 7.00 5.00 ST 6.00 1.00 30.00 20.00 ST 24.00 2.00 1 -1 ST 0 0.5 Overall Process Performance Average Performance Metrics Total Number of Steps 6 Avg Defect per step 141408 Normalized Yield per step 86% Avg step Sigma 1.0740 Page 23 of 27 SCORE2-EN-XLS Process Performance Scores Z Z Total Yield Z USL LSL DPM RTY Bench UDPU 0.50 2.00 1.00 3.00 4.50 308,541 2.00 45,500 1.00 317,311 2.00 24,100 69% 95% 68% 98% 42% LDPU 0.500 0.308538 3.4E-06 0.691459 1.690 0.02275 0.02275 0.91107 0.475 0.158655 0.158655 0.682689 1.976 0.00135 0.02275 0.9759 -0.203 42% l Process Performance 580,293 Page 24 of 27 SCORE2-EN-XLS Process Performance Scores Z Z USL LSL Total DPM Yield Z RTY Bench UDPU 69% 95% 68% 98% 95% 40% LDPU 0.50 2.00 1.00 3.00 2.00 ss Performance 4.50 308,541 2.00 45,500 1.00 317,311 2.00 24,100 2.00 45,500 599,389 0.500 0.308538 3.4E-06 0.691459 1.690 0.02275 0.02275 0.91107 0.475 0.158655 0.158655 0.682689 1.976 0.00135 0.02275 0.9759 1.690 0.02275 0.02275 0.9545 -0.252 40% Page 25 of 27 SCORE2-EN-XLS SigmaScoot SS1 Top Level Scorecard Performance Component Process # DPM RTY Z Bench # DPM RTY Z Bench # DPM RTY Z Bench # DPM RTY Z Bench Overall Performance 442566 55.7% 0.144 32350 96.8% 1.855 864768 13.5% -1.102 Length Finish Economy Comfort Steering and Fork Frame and Deck Wheel and Brake Motor Drive 2 442365 55.8% 2 431278 56.9% 0.145 0.173 0.3 100.0% 259182 74.1% 158655 84.1% 105650 89.4% 5.000 0.646 1.000 1.250 1 1 2 1 9500 6350 4000 8500 99.1% 99.4% 99.6% 99.2% 2.347 2.493 2.653 2.388 1 437042 56.3% 1 427655 57.2% 0.158 0.182 Final Assembly Avg Performance 4 249566 75.0% 0.676 4 135931 86.4% 1.099 5 6470 99.4% 2.487 1 580293 42.0% 3 486713 51.3% -0.203 0.033 Page 26 of 27 SCORE2-EN-XLS Top Level Scorecard SigmaScoot SS1 Top Level Scorecard Performance Component Process # DPM RTY Z Bench # DPM RTY Z Bench # DPM RTY Z Bench # DPM RTY Z Bench Overall Performance 442566 55.7% 0.144 35850 96.5% 1.809 891058 10.9% -1.232 Length Finish Economy Comfort Steering and Fork Frame and Deck Wheel and Brake Motor Drive Seat Assembly Final Assembly Avg Performance 2 442365 55.8% 2 431278 56.9% 0.145 0.173 0.3 100.0% 259182 74.1% 158655 84.1% 105650 89.4% 5.000 0.646 1.000 1.250 1 1 2 1 1 9500 6350 4000 8500 3500 99.1% 99.4% 99.6% 99.2% 96.5% 2.347 1 437042 56.3% 2.493 1 427655 57.2% 2.653 2.388 1.809 1 156002 84.4% 1 580293 42.0% 4 486713 51.3% 0.158 0.182 2 185724 81.4% 0.894 1.011 -0.203 0.033 6 201999 79.8% 0.835 4 135931 86.4% 1.099 6 5975 99.4% 2.515 Page 27 of 27 SCORE2-EN-XLS

Related docs
Six Sigma Design Score Matrix
Views: 66  |  Downloads: 14
Six Sigma
Views: 727  |  Downloads: 92
Six Sigma Template
Views: 2103  |  Downloads: 631
What is Six Sigma
Views: 841  |  Downloads: 175
What is Six Sigma
Views: 1346  |  Downloads: 244
what is Six Sigma
Views: 411  |  Downloads: 76
Six Sigma Design Concept Matrix
Views: 60  |  Downloads: 28
Six Sigma DFMEA
Views: 139  |  Downloads: 40
Six sigma
Views: 411  |  Downloads: 123
premium docs
Other docs by Jason Cardinal
Six Sigma Z Table
Views: 87  |  Downloads: 11
Six Sigma Vendor Evaluation
Views: 119  |  Downloads: 19
Six Sigma Toll Gate Road Map
Views: 110  |  Downloads: 7
Six Sigma Toll Gate Checklist
Views: 262  |  Downloads: 25
Six Sigma Test Report
Views: 57  |  Downloads: 14
Six Sigma Test Case Checklist
Views: 159  |  Downloads: 10
Six Sigma Technical Training Plan
Views: 43  |  Downloads: 9
Six Sigma Supplier Evaluation Form
Views: 551  |  Downloads: 61
Six Sigma Sum Squares
Views: 81  |  Downloads: 18
Six Sigma Solution Tree
Views: 74  |  Downloads: 14
Six Sigma Software Quality Matrix Deluxe
Views: 64  |  Downloads: 25
Six Sigma Software Quality Matrix
Views: 111  |  Downloads: 27
Six Sigma Shift & Drift Table
Views: 57  |  Downloads: 14
Six Sigma Sales Report
Views: 69  |  Downloads: 24
Six Sigma Regression Sum
Views: 49  |  Downloads: 10