Page 342 - Six Sigma Demystified

322 Six SigMa DemystifieD

Prioritization Matrix

Excel

Using Green Belt XL Add-On
Use New Chart\Prioritization Matrix. Enter the Options and Criteria. Enter into
the resulting Criteria Weighting Matrix the score for each paired comparison.
Enter into each of the resulting Options Rating Matrices the score for each
paired comparison (for the selected criterion). The Summary Matrix is auto-
matically updated with the results based on the completed options and criteria
matrices.

Consensus-Criteria Method
The full analytical method can be quite time-consuming, particularly as the
number of options grows. The consensus-criteria method is an alternate tech-
nique that streamlines the analysis. In this method, we again start by specifying
the options and the criteria, and then we compare the criteria. The criteria rat-
ing is done simply by distributing 100 percent across the criteria, with the
highest weights given to more important criteria. See Figure F.28. You may find
it useful to think of distributing a hundred dollars, giving the most money to
the more important criterion.
Each option then is compared against the criteria with a simple weighting

scale, such as 1 to 3, 1 to 5, or 1 to 10, with the largest value assigned to the
best option. Figure F.29 shows the options rating matrix using the 1 to 3 scale.
Peter, Jessie, and Adrianne achieved the highest scores in this example.
The final score for each option then is obtained in the summary matrix
by multiplying the scores for each criterion by the criterion weight. See
Figure F.30.

Interpretation

The final weighted score indicates the prioritization you should assign to each
option. The higher the score, the greater is the priority.