1. Qualica
  2. Qualica User Guide
  3. Templates
  4. VOC Prio
Yellow Belt (Basic Tools)

Templates  

Analytic Hierarchy Process  

Thumbnail Image 1

About Analytic Hierarchy Process

The Analytical Hierarchy Process (AHP) produces a reliable and precise prioritization or ranking of customer requirements or other items.

goal_br

Weight requirements by efficient pairwise comparison

result_br

An AHP returns a Pareto diagram of requirements, with item weights adding up to 100%.

Analytical Hierarchy Process (AHP) for Voice of Customer (VOC) prioritization


Analytical Hierarchy Process (AHP) for Voice of Customer (VOC) prioritization


The AHP module provides an easy way to create the AHP matrices for VOC or any other tree. It calculates importance values and consistency indexes for each sub-matrix. Additional worksheets help to gain data from a questionnaire or fill out the matrices systematically during team sessions.

Inserting an AHP for Functions, Components or any other Tree

If you follow the steps on inserting the AHP component, it will try to link to the VOC tree. You can also link the AHP to any other tree in your project:

  1. 1
    Select the target tree or an item in the target tree on any worksheet in your project.
  2. 2
    Follow the steps to insert the component

Structuring Data

An AHP can only work properly, if the criteria are sorted into groups with nearly equal number of items. For good results, try to find groups with not more than 9 elements each. It is also possible to build groups, subgroups and leaf items or even deeper tree structures.

If you expand the AHP's main worksheet in the project browser, the first sub-worksheet is well suited to do the grouping and sorting of the criteria. Of course, you can also use the Mind Map / Ishikawa component to create the criteria tree.

Worksheets

The AHP Worksheet

The AHP component's main worksheet contains everything to fill out and calculate the AHP prioritization.

en
  1. 1
    Group Selector
    Select the focused group by clicking the drop down button or the scroll buttons
  2. 2
    VOC / Criteria
    This section shows the items inside the selected group
  3. 3
    AHP Matrix
    Enter the comparison values. Clicking into a cell will open a menu to choose from. Use keyboard input 1...9 if the left element is more important or Shift+1...9 if the left element is less important than the top element. Opposite (reciprocal) values are calculated automatically. Press F5 to start calculation. After calculation, items are sorted by importance. This helps to eliminate inconsistencies. Sorting can be changed or stopped using Sort from the Home ribbon.
  4. 4
    Importance in Group
    This section shows the calculated importance in percent for the focused group.
  5. 5
    Bar Chart
    This chart shows the calculated importance as bar graphs. A confidence interval can appear as black line inside each bar.
  6. 6
    Consistency
    This section shows the calculated consistency index. A consistency index of 0 shows that the matrix is completely consistent.
More Worksheets

Need more information? Open questions? Please let us know.

=