Quality Progress - May 2017 - 43

concurrent with the RSPN being greater than the action
threshold value.
A more conservative team approach is to define action
plans for all RSPN values greater than the RPN action
threshold value. Teams might perform sensitivity analysis
using the FMEA tool, similar to analysis using the RSPN/
RPN matrix, simply by data sorting on the new RSPN
column. This approach can identify failure modes with
risk numbers that might be sensitive to particular input
rankings.
Table 6 shows an example of several rows from an
illustrative FMEA sorted by the RPN values from highest
to lowest, using an arbitrary RPN action threshold value
of 100. This example demonstrates several RPN scenarios
for which the sensitivity to inaccurate input rankings might
reverse the team decision from "no action is defensible" to
"action required."
The RSPN value represents the recalculated risk number
when the FMEA team unintentionally makes a worst-case
marginal error while computing the original risk number.
Of course, input rankings can be more than just marginally inaccurate, meaning at times, ranking uncertainty
might be more significant than just marginal. The RSPN
method simply offers a standardized approach to compare
the relative sensitivity of RPN values to potential marginal
errors across multiple failure modes.

MRPN values, for example those with high Sev rankings.
Table 7 illustrates how the RSPN and the MRPN indexes
might be added to existing FMEA templates. These
columns can be hidden when not in use. Augmenting the
FMEA tool in this manner requires very little effort.
Sensitivity analysis has the potential to produce significant benefit by offering additional insight for particular
failure modes that might lead to more effective risk
mitigation.

Eugene R. Bukowski is a senior engineering
manager for General Electric Healthcare in
Noblesville, IN. He has a master's degree in
electrical engineering from Duke University
in Durham, NC, and a master's degree in
manufacturing management from Kettering
University in Flint, MI. A senior member of ASQ,
Bukowski is an ASQ-certified Six Sigma Black Belt.

The Government Excellence System

Calculating for marginal risk

In the context of the RSPN approach, the marginal risk
priority number (MRPN) is the change in magnitude of the
RPN value associated with a +1-unit change to the minimum of the three input rankings. It is simply the difference
between the RSPN value and the RPN value.
The MRPN value easily can be formulated with any
spreadsheet tool. A column for MRPN can be added right
next to the RSPN column in the FMEA template of choice. A
spreadsheet formula for MRPN will resemble:
MRPN = RSPN - RPN
The MRPN value is significant because it represents the
actual magnitude of change in the risk number based on
potential marginal error. For the 10-point scale, it can be
shown that the lowest possible MRPN value is one (1 × 1),
and the highest possible value is 100 (10 × 10).
Data-sorted MRPN values provide another form of sensitivity analysis for FMEA teams. This additional information might
influence teams to further mitigate risk for particular failure
modes. Teams might choose to reconsider the potential effectiveness of action plans for those failure modes with higher

nt
ing
me
age
hap
n
S
a
e
M
ur
Fut
tion
ova
Inn

Innovation

20%

a
end
l Ag
iona
t
a
N
s
tion
unc
in F
ces
a
M
ervi
rs S
a
t
en S nment
Sev
r
ove
rt G
a
Sm

Enablers

20%

Hum
an
Cap
ital
Res
our
ces
&A
Gov
sset
ern
sM
anc
ana
e
gem
ent

Vision
Achievement

60%

Sheikh Khalifa Government Excellence Program (SKGEP)
strives through its mission statement to reach excellent
performance outcomes' of the UAE public sector. SKGEP
has been instrumental in enhancing organizational
system act to induce transformational thinking in
government initiatives, enhancing the culture of
innovation, and shaping the future of Government.

qualityprogress.com ❘ May 2017

QP 43


http://www.skgep.gov.ae http://www.qualityprogress.com

Table of Contents for the Digital Edition of Quality Progress - May 2017

Seen and Heard
Expert Answers
Progress Report
Mr. Pareto Head
Field Notes
Mind the Gaps
Solid Footing
Are These the Same?
New Tricks for an Old Tool
Innovation Imperative
Experience More
Career Coach
Statistics Spotlight
Standard Issues
Marketplace
Footnotes
Back to Basics
Quality Progress - May 2017 - intro
Quality Progress - May 2017 - cover1
Quality Progress - May 2017 - cover2
Quality Progress - May 2017 - 1
Quality Progress - May 2017 - 2
Quality Progress - May 2017 - 3
Quality Progress - May 2017 - 4
Quality Progress - May 2017 - 5
Quality Progress - May 2017 - Seen and Heard
Quality Progress - May 2017 - Expert Answers
Quality Progress - May 2017 - Progress Report
Quality Progress - May 2017 - Mr. Pareto Head
Quality Progress - May 2017 - 10
Quality Progress - May 2017 - 11
Quality Progress - May 2017 - Field Notes
Quality Progress - May 2017 - 13
Quality Progress - May 2017 - 14
Quality Progress - May 2017 - 15
Quality Progress - May 2017 - Mind the Gaps
Quality Progress - May 2017 - 17
Quality Progress - May 2017 - 18
Quality Progress - May 2017 - 19
Quality Progress - May 2017 - 20
Quality Progress - May 2017 - 21
Quality Progress - May 2017 - 22
Quality Progress - May 2017 - 23
Quality Progress - May 2017 - Solid Footing
Quality Progress - May 2017 - 25
Quality Progress - May 2017 - 26
Quality Progress - May 2017 - 27
Quality Progress - May 2017 - 28
Quality Progress - May 2017 - 29
Quality Progress - May 2017 - Are These the Same?
Quality Progress - May 2017 - 31
Quality Progress - May 2017 - 32
Quality Progress - May 2017 - 33
Quality Progress - May 2017 - 34
Quality Progress - May 2017 - 35
Quality Progress - May 2017 - New Tricks for an Old Tool
Quality Progress - May 2017 - 37
Quality Progress - May 2017 - 38
Quality Progress - May 2017 - 39
Quality Progress - May 2017 - 40
Quality Progress - May 2017 - 41
Quality Progress - May 2017 - 42
Quality Progress - May 2017 - 43
Quality Progress - May 2017 - Innovation Imperative
Quality Progress - May 2017 - 45
Quality Progress - May 2017 - 46
Quality Progress - May 2017 - Career Coach
Quality Progress - May 2017 - 48
Quality Progress - May 2017 - 49
Quality Progress - May 2017 - Statistics Spotlight
Quality Progress - May 2017 - 51
Quality Progress - May 2017 - 52
Quality Progress - May 2017 - 53
Quality Progress - May 2017 - Standard Issues
Quality Progress - May 2017 - 55
Quality Progress - May 2017 - 56
Quality Progress - May 2017 - 57
Quality Progress - May 2017 - Marketplace
Quality Progress - May 2017 - 59
Quality Progress - May 2017 - Footnotes
Quality Progress - May 2017 - 61
Quality Progress - May 2017 - 62
Quality Progress - May 2017 - 63
Quality Progress - May 2017 - Back to Basics
Quality Progress - May 2017 - cover3
Quality Progress - May 2017 - cover4
http://www.nxtbook.com/naylor/ASQM/ASQM0719
http://www.nxtbook.com/naylor/ASQM/ASQM0619
http://www.nxtbook.com/naylor/ASQM/ASQM0519
http://www.nxtbook.com/naylor/ASQM/ASQM0419
http://www.nxtbook.com/naylor/ASQM/ASQM0319
http://www.nxtbook.com/naylor/ASQM/ASQM0219
http://www.nxtbook.com/naylor/ASQM/ASQM0119
http://www.nxtbook.com/naylor/ASQM/ASQM1218
http://www.nxtbook.com/naylor/ASQM/ASQM1118
http://www.nxtbook.com/naylor/ASQM/ASQM1018
http://www.nxtbook.com/naylor/ASQM/ASQM0918
http://www.nxtbook.com/naylor/ASQM/ASQM0818
http://www.nxtbook.com/naylor/ASQM/ASQM0718
http://www.nxtbook.com/naylor/ASQM/ASQM0618
http://www.nxtbook.com/naylor/ASQM/ASQM0518
http://www.nxtbook.com/naylor/ASQM/ASQM0418
http://www.nxtbook.com/naylor/ASQM/ASQM0318
http://www.nxtbook.com/naylor/ASQM/ASQM0218
http://www.nxtbook.com/naylor/ASQM/ASQM0118
http://www.nxtbook.com/naylor/ASQM/ASQM1217
http://www.nxtbook.com/naylor/ASQM/ASQM1117
http://www.nxtbook.com/naylor/ASQM/ASQM1017
http://www.nxtbook.com/naylor/ASQM/ASQM0917
http://www.nxtbook.com/naylor/ASQM/ASQM0817
http://www.nxtbook.com/naylor/ASQM/ASQM0717
http://www.nxtbook.com/naylor/ASQM/ASQM0617
http://www.nxtbook.com/naylor/ASQM/ASQM0517
http://www.nxtbook.com/naylor/ASQM/ASQM0417
http://www.nxtbook.com/naylor/ASQM/ASQC12518
http://www.nxtbook.com/naylor/ASQM/ASQM0317
http://www.nxtbook.com/naylor/ASQM/ASQM0217
http://www.nxtbook.com/naylor/ASQM/ASQM0117
http://www.nxtbook.com/naylor/ASQM/ASQM1216
http://www.nxtbook.com/naylor/ASQM/ASQM1116
http://www.nxtbook.com/naylor/ASQM/ASQM1016
http://www.nxtbook.com/naylor/ASQM/ASAC0016
http://www.nxtbook.com/naylor/ASQM/ASQM0916
http://www.nxtbook.com/naylor/ASQM/ASQA0016
http://www.nxtbook.com/naylor/ASQM/ASQM0816
http://www.nxtbook.com/naylor/ASQM/ASQM0716
http://www.nxtbook.com/naylor/ASQM/ASQM0616
http://www.nxtbook.com/naylor/ASQM/ASQM0516
http://www.nxtbook.com/naylor/ASQM/ASQM0416
http://www.nxtbook.com/naylor/ASQM/ASQM0316
http://www.nxtbook.com/naylor/ASQM/ASQM0216
http://www.nxtbook.com/naylor/ASQM/ASQM0116
http://www.nxtbook.com/naylor/ASQM/ASQM1215
http://www.nxtbook.com/naylor/ASQM/ASQM1115
http://www.nxtbook.com/naylor/ASQM/ASQM1015
http://www.nxtbook.com/naylor/ASQM/ASQM0915
http://www.nxtbook.com/naylor/ASQM/ASQM0815
http://www.nxtbook.com/naylor/ASQM/ASQM0715
http://www.nxtbook.com/naylor/ASQM/ASQM0615
http://www.nxtbook.com/naylor/ASQM/ASQM0515
http://www.nxtbook.com/naylor/ASQM/ASQM0315
http://www.nxtbook.com/naylor/ASQM/ASQM0215
http://www.nxtbook.com/naylor/ASQM/ASQM0115
http://www.nxtbook.com/naylor/ASQM/ASQM1214
http://www.nxtbook.com/naylor/ASQM/ASQM1114
http://www.nxtbook.com/naylor/ASQM/ASQM1014
http://www.nxtbook.com/naylor/ASQM/ASQM0914
http://www.nxtbook.com/naylor/ASQM/ASQM0814
http://www.nxtbook.com/naylor/ASQM/ASQM0714
http://www.nxtbook.com/naylor/ASQM/ASQM0614
http://www.nxtbook.com/naylor/ASQM/ASQM0514
http://www.nxtbook.com/naylor/ASQM/ASQM0414
http://www.nxtbook.com/naylor/ASQM/ASQM0314
http://www.nxtbook.com/naylor/ASQM/ASQM0214
http://www.nxtbook.com/naylor/ASQM/ASQM0114
http://www.nxtbook.com/naylor/ASQM/ASQM1213
http://www.nxtbook.com/naylor/ASQM/ASQM1113
http://www.nxtbook.com/naylor/ASQM/ASQM1013
http://www.nxtbook.com/naylor/ASQM/ASQM0913
http://www.nxtbook.com/naylor/ASQM/ASQM0813
http://www.nxtbook.com/naylor/ASQM/ASQM0713
http://www.nxtbook.com/naylor/ASQM/ASQM0613
http://www.nxtbook.com/naylor/ASQM/ASQM0513
http://www.nxtbook.com/naylor/ASQM/ASQM0413
http://www.nxtbook.com/naylor/ASQM/ASQM0313
http://www.nxtbook.com/nxtbooks/naylor/ASQM0213
http://www.nxtbook.com/nxtbooks/naylor/ASQM0113
http://www.nxtbook.com/nxtbooks/naylor/ASQM1212
http://www.nxtbook.com/nxtbooks/naylor/ASQM1112
http://www.nxtbook.com/nxtbooks/naylor/ASQM1012
http://www.nxtbook.com/nxtbooks/naylor/ASQM0912
http://www.nxtbookMEDIA.com