Tolerancing based on Cpk Data - Spreadsheet Attached

G

gianni

#1
Can anyone please tell me if there is a way to determine what tolerance is required on a specific dimension to acheive a 1.33 Cpk? Is there a cut and dry method to say, for example: P1 = 4.5 Newtons; to hold 1.33 you will need a tolerance of ____? Or, based on the Cpk result of 0.684 you need x amount more tolerance to achieve Cpk 1.33, based on the sample data. Is there a quick calculation to determine this?

EX. P1 = 4.5 Newtons ± .4 Newtons

What will I have to hold to maintain a 1.33 Cpk?
 
Last edited by a moderator:
Elsmar Forum Sponsor
D

Darius

#3
if USL - Mean < Mean - LSL

Cpk = (USL - Mean)/(3*Sigma) => USL = Mean - Cpk *3*Sigma
and if Cpk=1.33 then USL = Mean - 4 * Sigma

if USL - Mean > Mean - LSL

Cpk = (Mean - LSL)/(3*Sigma) => LSL = Mean + Cpk *3*Sigma
and if Cpk=1.33 then LSL = Mean + 4 * Sigma

So (Mean - Cpk *3*Sigma, Mean + Cpk *3*Sigma)

But still, Cpk depends on the sample size so the calculus get harder and depends on wich estiamate do you like: the maximum or the minimum or not less than a fixed Cpk value and the current Cpk.


:ko:
 
D

Darius

#5
Dave, nice worksheet, but the calculus of the standard deviation is total variation estimate, desto ppk not Cpk.
:caution:
 
M

M Greenaway

#6
I thought Cpk was based on the tolerance anyway, hence you need a tolerance to determine Cpk as it is the ratio of the 3 sigma spread to the mean - USL/LSL spread.

However the point about designers actually considering process capability when they dream up a tolerance is absolutely vital. I often think that if they just considered this many of us would be out of work. So much 'poor' quality is designed in through unknown process capability.
 
G

gianni

#7
D.Scott said:
Here is a simple Cpk worksheet that calculates the Cpk and gives you the estimated tolerance needed to meet a given Cpk.

I hope it will help.

Dave
Thanks for the spreadsheet. This will help me very much.
 
D

D.Scott

#8
M Greenaway said:
I thought Cpk was based on the tolerance anyway, hence you need a tolerance to determine Cpk as it is the ratio of the 3 sigma spread to the mean - USL/LSL spread.
:bigwave: How have you been M?

You are right as usual of course but what we are talking about here is a "reverse capability" used to estimate the tolerance needed to meet a given Cpk in production. The method used is only an estimate and does no more than give you a "ballpark" for quoting a job. I guess you could say this is one of those "tools" we often use that is not strictly accurate. The "Gurus" would frown and the "experts" would lower their eyes but it really works wonders when sales or the customer asks "well, what DO you need?"

Nice to see you again.

Dave
 
S
#9
D.Scott said:
:bigwave: How have you been M?

You are right as usual of course but what we are talking about here is a "reverse capability" used to estimate the tolerance needed to meet a given Cpk in production. The method used is only an estimate and does no more than give you a "ballpark" for quoting a job. I guess you could say this is one of those "tools" we often use that is not strictly accurate. The "Gurus" would frown and the "experts" would lower their eyes but it really works wonders when sales or the customer asks "well, what DO you need?"

Nice to see you again.

Dave
Absolutly. Very good "common sense" tool.
 

The Taz!

Quite Involved in Discussions
#10
Hey gang. . .

Am I missing something here?? :confused:

Why are you talking about Cpk for setting a tolerance when Cp is the real measure of the processes capability irregardless of the centering. Centering is an adjustment. You can also look at Cr which is the inverse of Cp.

Cp = (Blue Print Tol. / 6-Sigma), The higher the better.

Cr = (6 Sigma / Blue Print Tol.) = % of Blue Print tolerance, The lower the better.


IMHO, I think you would be better off looking at Cp as the basis. If you want to look at it another way, take your 6-sigma spread (From your process capability study), and multiply it by 1.33. Now you will be challenged to hold the process on target to maintain it. Shoot for 1.67. Ford didn't pick it by chance. That will give you room for natural variation and process movement over the long haul.
 
Thread starter Similar threads Forum Replies Date
L Calibration of Plug Gauges - Tolerancing General Measurement Device and Calibration Topics 1
GoKats78 ASME Y14.5 Dimensioning and Tolerancing - Is there a JIS equivalent to Y14.5? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
D Large, untoleranced radius of 20? - Inspection and Tolerancing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M Zero Tolerancing on True Position using MMC (Maximum Material Condition) Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
V GM Gage and Tooling Tolerancing Standards APQP and PPAP 3
optomist1 Composite Profile Tolerancing Clarification Inspection, Prints (Drawings), Testing, Sampling and Related Topics 21
J Reporting GDT (Geometric Dimensioning and Tolerancing) Bonus Tolerance Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
D Statistical Tolerances in GD&T (Geometric Dimensioning & Tolerancing)? Various Other Specifications, Standards, and related Requirements 31
P (Acme) 29deg stub thread 9TPI - Thread dimensions & tolerancing and root dimension General Measurement Device and Calibration Topics 8
K Basis for Establishing Gage Tolerancing - "Gage Maker's Tolerances" General Measurement Device and Calibration Topics 4
M GD&T (Geometric Dimensioning & Tolerancing) vs. "Standard" Blueprints Manufacturing and Related Processes 11
J Where to find new GD&T (geometric dimensioning and tolerancing) standards? Various Other Specifications, Standards, and related Requirements 2
S Where to find MIL Standard 8A,8B - Used for Dimensioning and Tolerancing Quality Tools, Improvement and Analysis 3
H Geometric Tolerances - International and/or European Geometric Tolerancing Book, Video, Blog and Web Site Reviews and Recommendations 2
M Cast Part with a Flat Base Tolerancing help Misc. Quality Assurance and Business Systems Related Topics 8
U Tolerancing Tool called 'Material Condition Modifier' created by Staneley Parker Misc. Quality Assurance and Business Systems Related Topics 0
K French Automotive Tolerancing Scheme BE-ADD-PLN-01 (possibly a Renault spec) Customer and Company Specific Requirements 2
R Suggest a source? Cheap Online GD&T (Geometric Dimensioning and Tolerancing) Training Training - Internal, External, Online and Distance Learning 1
ScottK Root Sum Square and Statistical Tolerancing help needed Statistical Analysis Tools, Techniques and SPC 5
apestate Is there a separate standard for dimensioning and tolerancing sheet metal work? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 9
K Roll Form Thread Tolerancing - Aluminum castings - Help needed Various Other Specifications, Standards, and related Requirements 6
Q Pin Gage Classifications - Use and tolerancing of Class XXX pin gages General Measurement Device and Calibration Topics 7
J I need a copy of ASME Y14.5m - 1994 - Geometric Dimensioning and Tolerancing Various Other Specifications, Standards, and related Requirements 3
D Is ASME Y.14.5M-1994 - Dimensioning and tolerancing - Required? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
J ANSI 14.5M - Dimensioning and Tolerancing - Where I can buy the standard Various Other Specifications, Standards, and related Requirements 12
L What is Statistical Tolerancing? How to apply it to a product? Statistical Analysis Tools, Techniques and SPC 7
L Geometric Tolerancing and SPC - Calculating position upper and lower control limits Statistical Analysis Tools, Techniques and SPC 36
R Statistical Tolerancing - Monte Carlo simulation in Statistical Tolerancing Statistical Analysis Tools, Techniques and SPC 5
T Controlling Expandable Forms in Paper-Based Document Control System Document Control Systems, Procedures, Forms and Templates 10
M Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
K "World Class Product" based QM. I need advice. Quality Management System (QMS) Manuals 14
S DHF/DMR/MDF for a software-only, cloud-based, single-instance device Medical Information Technology, Medical Software and Health Informatics 2
Sidney Vianna IATF 16949 News Risked Based Audit Day Calculation IATF 16949 - Automotive Quality Systems Standard 2
S Annual Inspection Layout - Based on Customer print ? IATF 16949 - Automotive Quality Systems Standard 8
F IVD registration in EU - Northern Ireland based company EU Medical Device Regulations 0
M Medical device substance based-leachables Other Medical Device Related Standards 2
A API Spec Q1 Purchasing Process - Supplier Reevaluation based on Supplier Risks 5.6.1.4 Oil and Gas Industry Standards and Regulations 17
P Testing cloud-based backups IT (Information Technology) Service Management 7
silentmonkey Rationalising the level of effort and depth of software validation based on risk ISO 13485:2016 - Medical Device Quality Management Systems 10
P Conformity assessment based on a quality management system or production quality assurance EU Medical Device Regulations 3
DuncanGibbons Model-Based procedures and Architecting the QMS as a System Document Control Systems, Procedures, Forms and Templates 2
M IT validation for a paper based MD repair company QMS ISO 13485:2016 - Medical Device Quality Management Systems 6
B Do you use paper or web-based templates for CAPA processes? ISO 13485:2016 - Medical Device Quality Management Systems 3
B How to classify a medical device based on MDR? EU Medical Device Regulations 3
I How to classify a medical device based on FDA? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
D Tolerance definition based on expected Cp/cpk Reliability Analysis - Predictions, Testing and Standards 14
S Risk based internal auditing Internal Auditing 6
G Any good examples of CAPA forms that include a risk based approach? ISO 13485:2016 - Medical Device Quality Management Systems 8
R Expected life span of Medical devices - X-Ray based diagnostic medical devices ISO 13485:2016 - Medical Device Quality Management Systems 6
M HR (Human Resources) based software recommendations Human Factors and Ergonomics in Engineering 2

Similar threads

Top Bottom