QFD Template for Excel

15
Title: Legend Author: Θ Strong Relati Date: Ο Moderate Relat Notes: Weak Relatio ┼┼ Strong Positive C Positive Corre Negative Corre Strong Negative C Objective Is To Objective Is To x Objective Is To H Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Row # Max Relationship Value in Row Relative Weight Weight / Importance Our Company Competitor 1 Competitor 2 Competitor 3 Competitor 4 Competitor 5 0 1 2 1 2 3 4 5 6 7 8 9 10 Target or Limit Value Max Relationship Value in Column Weight / Importance Relative Weight Direction of Improvement: Minimize (▼), Maximize (▲), or Target (x) Competitive Analysis (0=Worst, 5=Best) Quality Characteristics (a.k.a. "Functional Requirements" or "Hows") Demanded Quality (a.k.a. "Customer Requirements" or "Whats") Difficulty (0=Easy to Accomplish, 10=Extremely Difficult) Powered by QFD Online (http: Our Company Competitor 2 Competitor 4

Transcript of QFD Template for Excel

Page 1: QFD Template for Excel

Title: Legend

Author: Θ Strong Relationship 9

Date: Ο Moderate Relationship 3

Notes: ▲ Weak Relationship 1

┼┼ Strong Positive Correlation

┼ Positive Correlation

▬ Negative Correlation

▼ Strong Negative Correlation

▼ Objective Is To Minimize

▲ Objective Is To Maximize

x Objective Is To Hit Target

Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Ro

w #

Max

Rel

atio

nsh

ip V

alu

e in

Ro

w

Rel

ativ

e W

eig

ht

Wei

gh

t / I

mp

ort

ance

Our

Com

pany

Com

petit

or 1

Com

petit

or 2

Com

petit

or 3

Com

petit

or 4

Com

petit

or 5

0 1 2 3 4 5

1

2

3

4

5

6

7

8

9

10

Target or Limit Value

Max Relationship Value in Column

Weight / Importance

Relative Weight

Direction of Improvement:Minimize (▼), Maximize (▲), or Target (x)

Competitive Analysis(0=Worst, 5=Best)

Quality Characteristics(a.k.a. "Functional

Requirements" or "Hows")

Demanded Quality (a.k.a. "Customer Requirements" or

"Whats")

Difficulty(0=Easy to Accomplish, 10=Extremely Difficult)

Powered by QFD Online (http://www.QFDOnline.com)

Our Company Competitor 1

Competitor 2 Competitor 3

Competitor 4 Competitor 5

Page 2: QFD Template for Excel

Title: Legend

Author: Θ Strong Relationship 9

Date: Ο Moderate Relationship 3

Notes: ▲ Weak Relationship 1

┼┼ Strong Positive Correlation

┼ Positive Correlation

▬ Negative Correlation

▼ Strong Negative Correlation

▼ Objective Is To Minimize

▲ Objective Is To Maximize

x Objective Is To Hit Target

Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Ro

w #

Max

Rel

atio

nsh

ip V

alu

e in

Ro

w

Rel

ativ

e W

eig

ht

Wei

gh

t / I

mp

ort

ance

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

Target or Limit Value

Max Relationship Value in Column

Direction of Improvement:Minimize (▼), Maximize (▲), or Target (x)

Quality Characteristics (a.k.a. "Hows")

Demanded Quality (a.k.a. "Whats")

Difficulty(0=Easy to Accomplish, 10=Extremely Difficult)

Page 3: QFD Template for Excel

Weight / Importance

Relative Weight Powered by QFD Online (http://www.QFDOnline.com)

Page 4: QFD Template for Excel

Title: Legend

Author: Θ Strong Relationship 9

Date: Ο Moderate Relationship 3

Notes: ▲ Weak Relationship 1

┼┼ Strong Positive Correlation

┼ Positive Correlation

▬ Negative Correlation

▼ Strong Negative Correlation

▼ Objective Is To Minimize

▲ Objective Is To Maximize

x Objective Is To Hit Target

Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Ro

w #

Max

Rel

atio

nsh

ip V

alu

e in

Ro

w

Rel

ativ

e W

eig

ht

Wei

gh

t / I

mp

ort

ance

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

Target or Limit Value

Max Relationship Value in Column

Direction of Improvement:Minimize (▼), Maximize (▲), or Target (x)

Quality Characteristics (a.k.a. "Hows")

Demanded Quality (a.k.a. "Whats")

Difficulty(0=Easy to Accomplish, 10=Extremely Difficult)

Page 5: QFD Template for Excel

Weight / Importance

Relative Weight Powered by QFD Online (http://www.QFDOnline.com)

Page 6: QFD Template for Excel

Title: Legend

Author: Θ Strong Relationship 9

Date: Ο Moderate Relationship 3

Notes: ▲ Weak Relationship 1

┼┼ Strong Positive Correlation

┼ Positive Correlation

▬ Negative Correlation

▼ Strong Negative Correlation

▼ Objective Is To Minimize

▲ Objective Is To Maximize

x Objective Is To Hit Target

Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Ro

w #

Max

Rel

atio

nsh

ip V

alu

e in

Ro

w

Rel

ativ

e W

eig

ht

Wei

gh

t / I

mp

ort

ance

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

Target or Limit Value

Max Relationship Value in Column

Direction of Improvement:Minimize (▼), Maximize (▲), or Target (x)

Quality Characteristics (a.k.a. "Hows")

Demanded Quality (a.k.a. "Whats")

Difficulty(0=Easy to Accomplish, 10=Extremely Difficult)

Page 7: QFD Template for Excel

Weight / Importance

Relative Weight Powered by QFD Online (http://www.QFDOnline.com)

Page 8: QFD Template for Excel

Template Name: Traditional House of QualityVersion: 2.0.346.0Release Date: December 11, 2007

Updated versions of this template (along with other valuable comments and instruction regarding its use) can be obtained at the following location:

http://www.qfdonline.com/templates/

If you have any questions, comments, requests, or suggestions regarding this template, please submit them via the following discussion forum for this template:

http://www.qfdonline.com/templates/comments/

This template was distributed by QFD Online or one of its Template Sponsors. Resale or redistribution of this template by entities other than QFD Online or its Template Sponsors is strictly prohibited. Inquiries about obtaining redistribution rights to QFD Online's

templates can be submitted through the following URL:

http://www.qfdonline.com/templates/template-sponsorship/

Use of this template constitues acceptance of the terms associated with its use, including an understanding that this template is provided "as is" with no warrantees expressed or implied by

QFD Online. For a complete list of the terms associated with the use of this template, please visit:

http://www.qfdonline.com/about/terms-of-use/