Six Sigma Tools for continuous quality improvement

 

House of Quality template

aka Quality Functional Deployment Matrix

QFD House of Quality template with all the power and familiarity of Microsoft Excel

Purposes of QFD Quality Functional Deployment

  1. To translate potentially vague customer desires into observable, measurable
    Functional Requirements for a deliverable product or service.
  2. To provide a guiding structure for a cross-functional product development team to rapidly design and deploy new products and services in a fraction of the time required by traditional methods.

The first thing to notice about the

Systems2win QFD template

is that it can be huge or tiny —
easily scaling to the size you need...

QFD template

Sample House of Quality QFD Example

Your QFD Excel template
for quality function deployment

is esaily scaled to analyze up to 50 customer demands, 50 performance measures,
4 customer segments, and 5 competitors on a single chart.

In the rare event that you need more than that, you can use multiple sheets (perhaps for different customer segments)
to analyze unlimited customer demands and performance measures for unlimited customer segments and competitors.

Your House of Quality Excel template
comes with excellent training

to get your design team started

and to take your customer-centric designs to new levels

to mercilessly crush your (less competent) competitors

Bookmark = Training

House of Quality

Training & Demo Videos

 

Contents of this training page

 

QFD videos

 

Additional training
relevant to this template

The Sample and Help worksheets of every template
always contain training relevant to THAT template

 

 

 

Also see the rest of the Six Sigma tools
that come with your QFD template


Video Help

House of Quality Video 1:
Introduction to QFD
& Cause and Effect Matrix

 

QFD Training Video 2:
Correlations

 

QFD Training Video 3:
Calculations and Analysis

 

QFD Training Video 4:
The 4 Phases of QFD


Bookmark = start

How to get started using your

House of Quality QFD template

Before getting started

Launch your team using the same methods and templates
that you use to launch any team for any type of process improvement.

Before taking on an advanced six sigma tool like this House of Quality template,

every team member should complete the foundational New User Training
to learn the basic features that are common to
every one of your 150+ Systems2win templates for process improvement.

Measurement Selection Matrix

Cause and Effect Matrix template

Are you sure this deserves House of Quality analysis?

The bottom line question answered by QFD analysis is:

"Which Performance Measures will the design team select to improve?"

For smaller companies and/or less complex offerings...

your Measurement Selection Matrix (MeasuresSelect.xlsx)
and Cause and Effect Matrix templates (CauseEffect.xlsx)
can often be used to arrive at a similar answer to the same question
with a lot less effort and money.

You should only bring out your "big gun" House of Quality template

for multi-million dollar product or service offerings
that are used by diverse types of customers
perhaps competing against diverse (fierce) competitors

Find and open your template

Excel Ribbon bar > Systems2win menu

Find and open your
House of Quality QFD template

(QFD.xlsx)

in the same way that you find and open
your other 150+ Systems2win templates.

If you don't yet own a license,
you can download your free trial now.

This is one of the only Systems2win templates
that requires you to enable macros.

Save your working document

following the usual document storage and naming conventions established by your leaders

Open a Blank Sheet

Systems2win menu > Open a Blank Sheet

When you're ready to start doing your own real work...

click the button to 'Open a Blank Sheet'

Excel Ribbon bar > Systems2win tab > Open a Blank Sheet

This blank sheet is where you will do your real work

(not on the Sample sheet)

Rename your new sheet.

Personalize your drop down lists

Even if your leaders have already personalized the DV sheet in your master template
so that you are starting with typical drop down lists for YOUR company,

you still might want to edit some of those drop down lists for your unique QFD.

QFD rating scales

User-defined Scales

Many (most?) teams will simply use the default rating scales
that come pre-defined with your QFD template.

If, however, you choose to personalize any of your rating scales,
then be sure to change both:

  1. The drop down lists on the DV sheet, and
  2. The text boxes in the lower right section of your QFD template

to provide visibility of your rating scales
to users of your printed House of Quality Matrix

Rather than editing an existing text box, you might replace it with a User Help Text Box, so that the Personalization Upgrade Utility will automatically find and transfer your personalizations each time that you upgrade.

Personalize your master template

If you find that your teams are making the same changes to your template
every time that they start a new QFD project,

then your leaders can personalize your master template
in ways that your personalizations will be automatically found and transferred to your new upgraded master template every time that you upgrade.

(In the same ways that you can personalize every one of your Systems2win templates,
that all have consistent, standardized features for faster learning, and less wasted time)

Personal art

Your personalizations
get found and transferred
each time you upgrade

Easily personalized

Because it is written using Microsoft Excel, your qfd template
can be easily personalized with custom formulas and
individualized approaches to all four phases of QFD.

Like every Systems2win Excel template, the House of Quality template is editable and customizable, and comes with extensive online training,
so that your Six Sigma team members can devote their valuable time to actually performing QFD analysis and problem solving

rather than 'inventing a deployment template'


Bookmark = phases

Your House of Quality template
supports all 4 phases of QFD

QFD 4 phases QFD ribbon menu

In the Systems2win menu in the Excel Ribbon bar...
when you select '4 Phase QFD Wizard', it...

  • Generates a new sheet for the next phase of QFD
  • Auto-populates the rows of the next sheet with the data from the columns of the previous one
  • Re-labels the rows and columns — with correct pop-up help
  • Correctly removes the elements that are not relevant to the next phase
    (e.g., competitor analysis, top of house...)

Bookmark = phase1

QFD Phase 1) Performance Requirements

The first phase of QFD
(which is often the only phase deployed by a design team)

provides a system for translating potentially vague customer desires
into prioritized, observable, measurable functional requirements
for design specifications for a deliverable product or service.

Start by gathering Voice of the Customer Data

Critical To Quality template

VOC Kano template

Your Systems2win templates include an entire suite of tools
that your team will find useful for

Learn more about your Voice of the Customer templates

Translate Voice of the Customer

Translate the Voice of the Customer
into "engineering speak" functional requirements

using your Voice of the Customer Translation template (VOC-Kano.xlsx)

Transcribe your Voice of the Customer data

Transcribe your data from your Voice of the Customer Translation template
to your QFD Phase 1 worksheet.

Demanded Qualities

This is the Voice of the Voice of the Customer — translated into Demanded Qualities

Enter your Demanded Qualities into the header cells for each row in the primary section of your QFD template.

Do not use word wrap — so that your charts will stay aligned with your rows.

Performance Measures

These are your functional requirements — translated into Performance Measures

Enter your Performance Measures into the header cells for each column in the primary section of your QFD template.

Desired Direction of Measure

Use the drop down list to clarify for each Performance Measure:

▲ Higher number is better
▼ Lower number is better
O Target is best

Bookmark = resize

Resize

House of Quality buttons in the Systems2win menu

To resize your House of Quality template...

Simply select 'Change # Rows and Columns'
in your Systems2win menu
in the ribbon bar near the top of Excel.

Yes, it will even resize the roof of the house
for your desired number of columns!!!

To move, add, or remove rows or columns,

see Advanced Training.

Complete the left wing of the QFD — Importance for Typical Customer

Note: It is important to complete the left wing section of your QFD first,
because some bottom wing calculations require a non-blank value for Composite Importance

Description of Typical Customer

Use the text box to clarify how your team defines your "typical customer".

QFD dropdowns

Many of the cells in your QFD template
use drop down lists to to easily choose values
from the lists that you define on your DV sheet

Tip: In addition to your typical customer, you can also optionally analyze additional customer segments in the Competitive Analysis section (in the right wing of your House of Quality template)

Importance

This is the Importance to your most common Typical Customer

that your team described in the text box on your QFD.

Use the drop down list

to choose a numeric value
for each Demanded Quality.

Like every Systems2win template,

all drop down lists are defined on the DV sheet.

You can define any scale that you want,
(as long as higher numbers are better)
but most teams use the default scale of:

0 Not at all important (should probably delete)
to 5 Extremely Important

Importance %

This auto-calculates, so that the sum always equals 100%

Customer Satisfaction

The Customer Satisfaction Rating System that you define on the DV sheet,
will be used in the drop down lists for both:

  1. Customer Evaluation of Our Offering

    Typical customer's current level of satisfaction with our offering

  2. Target Level of Satisfaction

    Design Team's decision for the level of customer satisfaction to design the product to meet

Again... you can define any scale that you want,
(as long as higher numbers are better)
but most teams use the default scale of:

0 Disappointed
to 5 Extremely Satisfied

Be sure that your scale numbers and descriptions match the numbers and descriptions that you used in your customer survey.

Or if you did customer interviews, make sure that they match the scale numbers and descriptions that you defined when your team prepared for those interviews using your Operational Definitions template (Op_Def.xlsx).

Ratio of Improvement

"How much do we need to improve?"

Ratio of Improvement = Target Level of Satisfaction / Customer Evaluation of Our Offering

Sales Points

Usually leave blank

Some companies allow Sales to skew the weighting factors for no more than 3 rows:

1.5 = Demanded Qualities that will differentiate this product from the competition.

1.2 = Important selling point

Composite Importance

Composite Importance = Importance * Ratio of Improvement * Sales Points

Composite Importance %

This auto-calculates, so that the sum always equals 100%

Complete the center section — Relationships

House of Quality relationships

Relationship Correlation

In the center of your House of Quality template,

use the drop down list for each cell
to choose the level of correlation between
each Demanded Quality (row)
and Performance Measure (column).

Your team can define any scale that you want,
(as long as higher numbers are higher correlation)
but most teams use the default scale of:

Blank = Not yet determined (your team hasn't yet decided)
. (period) = No correlation (your team has concluded that there is no correlation)
1 = Low correlation
3 = Medium correlation
9 = High correlation

Weighted Total Importance

Weighted Total Importance = The sum of the column's Relationship Correlation Ratings x Composite Importance ratings (rounded up to the nearest whole number).

Tip: If Composite Importance is blank, that row will not be included in this calculation!!!

% Total Importance

This auto-calculates, so that the sum always equals 100%

Complete the roof — Correlations

House of Quality template

Roof Correlation symbols

When you select any cell in the roof of the House of Quality,
it will instantly highlight the two correlated columns.

And from the drop down list, you can define how these two Performance Measures reinforce or conflict with each other.

▲▲ Strong Reinforcement
▲ Reinforcement
(blank) No Correlation
▼ Trade-off Conflict
▼▼ Strong Conflict

Tip: Yes, your team can replace these drop down choices on the DV sheet, but why? These are pretty visual and intuitive symbols, aren't they?

Optional right wing — Customer Types and Competitors

House of Quality competitor charts

You can hide unused columns,
or unhide columns for optional analysis

of how your different types of customers perceive your product as compared to your competitors.

Use the simple drop down lists
to change the charts to show your different:

  1. Customer Types
  2. Competitors

Complete the bottom section — Performance Analysis

QFD bottom section

Optional Data

You can have unlimited rows and columns of optional data,

and you have all the power of familiar Microsoft Excel
to add your own optional formulas, analyses, and/or charts.

Measured Performance

Use this section to validate

that scientifically observed results for each Performance Measure produce results that match up with customer ratings of our offering vs. competitors.

If they don't match,

then maybe tests aren't measuring what the customer really wants.

Desired Targets

To choose which targets are worthy of engineering resources,

take into consideration the weight of importance, Kano Analysis, difficulty, and current capability as compared to competitors

 

Kano Analysis

Kano Analysis

See Kano Analysis training
for your Voice of the Customer Translation template.

(blank) The customer is indifferent to this feature
▼ Dissatisfier
▲ Satisfier
♥ Delighter

Difficulty

Difficulty to get from the current level of performance to your desired level of performance.

Your team can define any scale that you want,
(as long as higher numbers are more difficult)
but most teams use the default scale of:

0 Almost no effort required, to
5 Huge, time-consuming, expensive project

Capability

Current capability to deliver your chosen level of target performance.

The higher the number, the more capable you are to deliver.

There are several popular scales for Capability.

Perhaps use simple 0-5 scale.

Perhaps use Cp index. (ratio of specification to manufacturing sigma)

Perhaps use Cpk index. (process sigma to nearest spec / 3)

Selected to Improve

The very bottom row of your House of Quality Template is where your team makes it's final decisions.

All of this work... all of this analysis... comes down to this one row of bottom-line decisions:

"Where will we focus our attention?"

Drop down choices for these bottom line decisions:

X = Selected to improve
(conditional formatting will highlight the X in bold red)

. (period) = No special effort planned for this column of Performance Measure

(blank) = The team has not yet decided


Bookmark = advanced

Advanced Training

to move, add, or remove rows or columns

House of Quality buttons in the Systems2win menu

It is important to understand that when you use the feature to
'Change Number of Rows & Columns'...

in the Systems2win menu in the Excel ribbon bar >>>>>

it hides rows and columns; it does not delete them.

There are always 50 rows and 50 columns in the main section.

To avoid messing things up...

it is very important to never insert or delete rows or columns in the main section of your QFD workbook.

You must instead follow these special instructions... (below)

If you want to Move a Row in the main section

  1. Unprotect the sheet
  2. Use Shift Down and Move to move entire rows
  3. Reprotect the sheet

If you want to Add a Row between existing rows in the main section

Never add or delete rows or columns in the main section

  1. To increase the number of rows, use Systems2win menu > Change # Rows and Columns
  2. Unprotect the sheet
  3. Select blank row(s), then use Shift Down and Move to move entire rows where you want them
  4. Reprotect the sheet

If you want to Remove a Row between existing rows in the main section

Never add or delete rows or columns in the main section

  1. Unprotect the sheet
  2. Select the row(s) you want to remove, then use Shift Down and Move to move entire rows
    to the bottom of the main section
  3. To reduce the number of rows, use Systems2win menu > Change # Rows and Columns

    This will also delete the data from the bottom rows that get hidden, and will reprotect your sheet.

If you want to Move a Column in the main section

Do not move an entire column

  1. Back up your workbook (just in case)
  2. Select all of the cells in the column beneath the red roof

    (starting with the thin gold line just below the red roof,
    and ending with the thin gold line at the very bottom, just below the 'Selected To Improve' row)

  3. Copy (Ctrl+C)
  4. Select the cell in the thin gold line just below the roof for the column where you want to paste
  5. Paste (Ctrl+V)

Tips:

You might need to play the "shuffle" game... temporarily copying to a blank column.

You can copy & paste more than one column at a time
as long as you don't try to paste within any portion of the same highlighted area from which you just copied.

If you want to Add a Column between existing columns in the main section

Never add or delete rows or columns in the main section

  1. To increase the number of columns, use Systems2win menu > Change # Rows and Columns
  2. Use the special instructions (above) to move columns where you want them

If you want to Remove a Column between existing columns in the main section

Never add or delete rows or columns in the main section

  1. Use the special instructions (above) to move your unwanted columns to the right end of the main section
  2. To reduce the number of columns, use Systems2win menu > Change # Rows and Columns

    This will also delete the data from the columns on the far right that get hidden, and will reprotect your sheet.


Bookmark = phase2

QFD Phase 2) Product or Service Design

The purpose of Phase 2 is to evaluate and choose between
alternative product designs to meet the Performance Requirements chosen in Phase 1.

House of Quality buttons in the Systems2win menu

When you have completed your Phase 1 worksheet,

click the button in the Systems2win menu
for '4 Phase QFD Wizard', and select Phase 2.

This will auto-generate a new sheet
that is formatted for Phase 2 QFD:

Decision PICK Matrix template

Decision Making

Phase 2 is when your team might also use your decision making templates

Most poplularly, you might use your Decision PICK Matrix template

perhaps with the special rating scale of a Pugh Matrix


Bookmark = phase3

QFD Phase 3) Process Design

The purpose of Phase 3 is to define the Critical to Satisfaction parameters needed to physically produce and/or deliver the product or service in ways that reliably meet or exceed the design specifications.

QFD 4 phases

When you have completed your Phase 2 worksheet,

click the button in the Systems2win menu
for '4 Phase QFD Wizard', and select Phase 3.

This will auto-generate a new sheet that is formatted for Phase 3 QFD:


Bookmark = control

QFD Phase 4) Process Control and Quality Control

The purpose of the fourth phase of QFD is to define process and quality controls for each step of the process.

When you have completed your Phase 3 worksheet,

click the button in the Systems2win menu
for '4 Phase QFD Wizard', and select Phase 4.

This will auto-generate a new sheet that is formatted for Phase 4 QFD:

 

Tips

Every company has very different measures for Phase 4 QFD process controls.

You can use everything you know about familiar Microsoft Excel
to personalize your template for your unique column headers.

Some teams choose to use their Control Plan template to serve as the 4th phase of QFD.

 

Relationship between QFD and FMEA

Illustration courtesy of Strategic Quality

Learn more about FMEA.


Bookmark = Reading

Suggested Reading and Resources

         

Tip: The FMEA Control Plan can often serve as the 4th phase of QFD

More Suggested Reading


This House of Quality Excel template comes with
many other useful Six Sigma tools and DFSS Tools

 

and is priced low enough to empower every team member

 

 

 

Download free trial
House of Quality template

 

 

 

 

This QFD template comes with many other useful
Six Sigma tools

Own yours now

 

 

 

 

 

 

 

 

 

 

 

 

Your Systems2win templates come with Training & Videos to help you get the most from your process improvement tools

 

 

 

Languages

Every Systems2win
Excel template is available
in ANY language

Spanish:
Casa de la calidad
matriz de despliegue funcional de calidad

French:
Maison de qualité
déploiement fonctionnel
de qualité

Portuguese:
Casa de Qualidade Implementação Funcional
de Qualidade

German:
Funktionale Qualitätsoptimierung

Chinese:
质量屋 质量功能部署矩阵

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Your Systems2win templates come with free New User Training to quickly learn features that are common to all 150+ templates

 

 

 

Join a free live webinar

 

 

 

One huge benefit of owning your Systems2win templates is Support when you need it