Identification No.
Instrument
Item Qty (Pcs) Specification
Sample Size (Nos) Operation
Data Co
Sr. No. 1 2 3
X Bar #DIV/0! #DIV/0! #DIV/0!
X (Max) 0 0 0
X (Min) 0 0 0
Range 0 0 0
UCL (X - Bar) #DIV/0! #DIV/0! #DIV/0!
LCL (X - Bar) #DIV/0! #DIV/0! #DIV/0!
UCL (R - Bar) 0 0 0
LCL (R - Bar) 0 0 0
Process Capability Stu
Process Capability #DIV/0!
C pu #DIV/0!
C pl #DIV/0!
Process Capability Index (Cpk) #DIV/0!
X Bar Chart
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
1 2 3 4 5 6 7
X Bar Value UCL LCL
Process Capability Calculation
Least Count USL Date
Machine LSL Shift
Benchmark
No of Decimals Study Done By
Measurement
Data Collection
4 5 6 7 8
Calculation of X Bar & Range Data
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Control Limit Calculation
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0
0 0 0 0 0
Process Capability Study & Quality Condition
Quality Condition Cp Quality Condition
Super Excellent Cp ≥ 2.00 Excellence
Excellent 1.67 ≤ Cp < 2.00 Satisfactory
Satisfactory 1.33 ≤ Cp < 1.67 Capable
Capable 1.00 ≤ Cp < 1.33 Inadequate
Inadequate 0.67 ≤ Cp < 1.00
Poor Cp < 0.67
Graph of X bar & R Chart with Control Limit
Chart
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
6 7 8 9 10 1 2 3 4
UCL LCL RB
Date Comments
Shift
Current Punching Process Works on Satisfactory
level. (Capability & Its Index)
Study Done By
Standard Data For Control Chart Constant
9 10 Sample D2 A2 D4 D3
2 1.128 1.88 3.267 0
3 1.693 1.023 2.574 0
4 2.059 0.729 2.282 0
5 2.326 0.577 2.114 0
6 2.534 0.483 2.004 0
#DIV/0! #DIV/0! X - Bar #DIV/0! No. of Non Conforming Parts
0 0 X max 0 0
0 0 X min 0 Standard Deviation (S)
0 0 R - Bar 0 #DIV/0!
#DIV/0! #DIV/0! U.C.L.X = #DIV/0!
#DIV/0! #DIV/0! L.C.L.X = #DIV/0!
0 0 U.C.L.R = 0
0 0 L.C.L.R = 0
Quality Condition Cpk
Excellence Cpk < 2.00
Satisfactory Cpk < 1.50
Capable Cpk < 1.33
Inadequate Cpk < 1.00
R - Chart
2 3 4 5 6 7 8 9 10
R Bar Value LCL UCL
Identification No. Instrument
Item Qty (Pcs) Specification
Sample Size (Nos) Operation
Da
Sr. No. 1 2 3
10
X Bar #DIV/0! #DIV/0! #DIV/0!
X (Max) 0 0 0
X (Min) 0 0 0
Range 0 0 0
UCL (X - Bar) #DIV/0! #DIV/0! #DIV/0!
LCL (X - Bar) #DIV/0! #DIV/0! #DIV/0!
UCL (R - Bar) 0 0 0
LCL (R - Bar) 0 0 0
Process Capability
Process Capability #DIV/0!
C pu #DIV/0!
C pl #DIV/0!
Process Capability Index (Cpk) #DIV/0!
X Bar Chart
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
1 2 3 4 5 6 7
X Bar Value UCL LCL
Process Capability Calculation
Least Count USL Date
Machine LSL Shift
No of Decimals Benchmark Measurement Study Done By
Data Collection
4 5 6 7 8
Calculation of X Bar & Range Data
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Control Limit Calculation
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0
0 0 0 0 0
Process Capability Study & Quality Condition
Quality Condition Cp Quality Condition
Super Excellent Cp ≥ 2.00 Excellence
Excellent 1.67 ≤ Cp < 2.00 Satisfactory
Satisfactory 1.33 ≤ Cp < 1.67 Capable
Capable 1.00 ≤ Cp < 1.33 Inadequate
Inadequate 0.67 ≤ Cp < 1.00
Poor Cp < 0.67
Graph of X bar & R Chart with Control Limit
ar Chart
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
5 6 7 8 9 10 1 2 3
alue UCL LCL
Date Comments
Shift
Current Punching Process Works on Satisfactory
level. (Capability & Its Index)
Study Done By
Standard Data For Control Chart Constant
9 10 Sample D2 A2 D4 D3
2 1.128 1.88 3.267 0
3 1.693 1.023 2.574 0
4 2.059 0.729 2.282 0
5 2.326 0.577 2.114 0
6 2.534 0.483 2.004 0
7 2.704 0.419 1.924 0.076
8 2.847 0.373 1.864 0.136
9 2.97 0.337 1.816 0.184
10 3.078 0.308 1.777 0.223
#DIV/0! #DIV/0! X - Bar #DIV/0! No. of Non Conforming Parts
0 0 X max 0 0
0 0 X min 0 Standard Deviation (S)
0 0 R - Bar 0 #DIV/0!
#DIV/0! #DIV/0! U.C.L.X = #DIV/0!
#DIV/0! #DIV/0! L.C.L.X = #DIV/0!
0 0 U.C.L.R = 0
0 0 L.C.L.R = 0
Quality Condition Cp
Excellence Cpk < 2.00
Satisfactory Cpk < 1.50
Capable Cpk < 1.33
Inadequate Cpk < 1.00
R - Chart
2 3 4 5 6 7 8 9 10
R Bar Value LCL UCL