Assume you want to open a new business:

Chandu469
HouseofQuality31.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>Assume you want to open a new business:

House of Quality 1

Title: House of Quality
Author: P11016
Date: 18/1/2011
Notes: Second Attempt Using Different Template
Legend
Θ Strong Relationship 9
┼ ▬ ▬
Ο Moderate Relationship 3
┼ ▬ ▬ ┼┼
▲ 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 16 17 18 19 20 21 22 23 24 25
Direction of Improvement: Minimize (▼), Maximize (▲), or Target (x) x ▲ ▲ ▼ ▼ ▼ ▲ ▲ ▲ ▲ x x ▲ ▼ ▼ x ▼ x x Competitive Analysis (0=Worst, 5=Best)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics (a.k.a. "Functional Requirements" or "Hows") Device Contains Complete Nodal Map of Building 9 Number of Identifiable Locations Read Range Error Measurement between ID locations Mean Learning Time Weight Battery Lifetime Navigation Endpoint Precision Location ID Repeatability Repeatability of Directions Correct I/O pins for interface Use same microcontroller as interface team Continuous uptime without crash Latency from navigation to UI update PCB Size Validate Input Prototype with reasonable cost Switch from English to Metric Units Relative Compass Bearing Current Technology (Dog) IR RFID RFID and IR Two RFID Tags RFID and Compass Chart Axis Values
Demanded Quality (a.k.a. "Customer Requirements" or "Whats") 0 1 2 3 4 5
1 9 8.6 9.0 Identifies All Classrooms/Offices Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.98
2 9 8.6 9.0 Identifies All Bathrooms Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.94
3 9 8.6 9.0 Identifies all exits/entrances Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.9
4 9 8.6 9.0 Identifies all stairwells/elevators Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.86
5 9 2.9 3.0 Identifies all Lounges Θ Θ ▲ ▲ Ο Ο ▲ 2 3 4 4 4 4 0.82
6 9 8.6 9.0 Helps get out of room once in Ο Θ Θ Ο ▲ Ο Ο ▲ Ο Θ 5 2 3 3 3 4 0.78
7 9 1.0 1.0 Gives Directions in feet or meters Ο Θ 1 5 5 5 5 5 0.74
8 9 8.6 9.0 Easy to use Θ Ο ▲ ▲ ▲ Ο Ο ▲ Ο Ο Θ 4 3 3 3 3 3 0.7
9 9 8.6 9.0 Portable Θ ▲ Θ Ο ▲ 3 4 4 4 4 4 0.66
10 9 2.9 3.0 Low Power Consumption Θ Ο 5 2 3 2 2 3 0.62
11 9 8.6 9.0 Accurate Directions Ο ▲ Ο Θ Θ Ο Θ ▲ Θ 2 3 4 4 4 5 0.58
12 9 1.0 1.0 Interfaces with other groups Ο ▲ Θ Θ Ο Θ 0 3 3 3 3 3 0.54
13 9 2.9 3.0 Durable Ο Θ Θ Θ 1 2 2 2 3 4 0.5
14 9 8.6 9.0 Device reacts within a couple feet of location Θ Ο Θ Θ Θ Ο ▲ 2 3 3 3 5 3 0.46
15 9 8.6 9.0 Needs hands Free Mode Ο Θ Θ Ο 0 1 3 2 3 3 0.42
16 9 1.0 1.0 System retains Proper Orientation Θ ▲ Θ 5 3 3 4 3 5 0.38
17 9 2.9 3.0 Inexpensive to own ▲ Ο Θ Θ 1 3 4 2 2 4 0.34
18 0.0 0.3
19 0.0 0.26
20 0.0 0.22
21 0.0 0.18
22 0.0 0.14
23 0.0 0.1
24 0.0 0.06
25 0.0 0.02
Target or Limit Value TRUE 65536 locations 3 meters 0% 20 minutes 6 ounces 8 hours 1 meter 99.90% 99.90% TRUE TRUE min 8 hours 250 ms 3"x2" TRUE $500 TRUE TRUE
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult) 3 2 6 8 4 2 8 7 1 3 2 1 3 6 4 2 6 2 3
Max Relationship Value in Column 9 9 9 9 9 9 9 9 9 9 9 9 9 3 9 9 9 9 9 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 471.4 448.6 217.1 180.0 105.7 182.9 52.4 234.3 222.9 111.4 8.6 8.6 60.0 51.4 191.4 146.7 94.3 42.9 285.7 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 15.1 14.4 7.0 5.8 3.4 5.9 1.7 7.5 7.2 3.6 0.3 0.3 1.9 1.7 6.1 4.7 3.0 1.4 9.2 Powered by QFD Online (http://www.QFDOnline.com)
Numeric Values for Relationship Matrix Calculations
1 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
2 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
3 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
4 8.6 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
5 2.9 9 9 1 0 0 0 0 1 3 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0
6 8.6 3 9 9 3 0 0 1 3 3 0 0 0 1 3 0 0 0 0 9 0 0 0 0 0 0
7 1.0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0
8 8.6 0 0 0 0 9 3 0 1 1 1 0 0 3 3 1 3 0 3 9 0 0 0 0 0 0
9 8.6 0 0 0 0 0 9 1 0 0 0 0 0 0 0 9 0 3 0 1 0 0 0 0 0 0
10 2.9 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0
11 8.6 3 1 3 9 0 0 0 9 3 9 0 0 0 0 0 0 1 0 9 0 0 0 0 0 0
12 1.0 0 0 0 0 0 3 1 0 0 0 9 9 0 0 3 9 0 0 0 0 0 0 0 0 0
13 2.9 0 0 0 0 0 0 0 3 9 9 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0
14 8.6 9 3 9 9 0 0 0 9 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
15 8.6 0 0 0 0 3 9 0 0 0 0 0 0 0 0 9 0 3 0 0 0 0 0 0 0 0
16 1.0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 9 0 0 0 0 0 0
17 2.9 0 1 0 0 0 0 3 0 0 0 0 0 0 0 9 0 9 0 0 0 0 0 0 0 0
18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
471.4285714 471.4285714 448.5714286 448.5714286 217.1428571 217.1428571 180 180 105.7142857 105.7142857 182.8571429 182.8571429 52.38095238 52.38095238 234.2857143 234.2857143 222.8571429 222.8571429 111.4285714 111.4285714 8.571428571 8.571428571 8.571428571 8.571428571 60 60 51.42857143 51.42857143 191.4285714 191.4285714 146.6666667 146.6666667 94.28571429 94.28571429 42.85714286 42.85714286 285.7142857 285.7142857 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell. Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.

Data Validation Sources

Min, Max, or Target Options Relationship Between Requirements Options Correlation Options
▼ Θ ┼┼
▲ Ο ┼
x ▲ ▬
▼

House of Quality 2

Title:
Author:
Date:
Notes:
Legend
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ 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
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement: Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics (a.k.a. "Functional Requirements" or "Hows") Satisfaction of Contract Specifications Completion of Project within Time Enhancing Customer/ Owner Satisfaction Motivation and Empowerment of Employees Avoiding Disputes and Claims Performance based on Purpose resource management plant and equipment control of quality of materials process control production and delivery safety material testing application of control charts
Demanded Quality (a.k.a. "Customer Requirements" or "Whats")
1 9 15.1 471.4 Device Contains Complete Nodal Map of Building 9 Θ Ο Ο Θ Ο ▲ ▲ Ο Θ
2 9 14.4 448.6 Number of Identifiable Locations Θ
3 3 7.0 217.1 Read Range Ο
4 3 5.8 180.0 Error Measurement between ID locations Ο
5 1 3.4 105.7 Mean Learning Time ▲
6 9 5.9 182.9 Weight Θ
7 9 1.7 52.4 Battery Lifetime Θ
8 9 7.5 234.3 Navigation Endpoint Precision Θ
9 3 7.2 222.9 Location ID Repeatability Ο
10 3 3.6 111.4 Repeatability of Directions Ο
11 1 0.3 8.6 Correct I/O pins for interface ▲
12 3 0.3 8.6 Use same microcontroller as interface team Ο
13 3 1.9 60.0 Continuous uptime without crash Ο
14 1 1.7 51.4 Latency from navigation to UI update ▲
15 3 6.1 191.4 PCB Size Ο
16 3 4.7 146.7 Validate Input Ο
17 3 3.0 94.3 Prototype with reasonable cost Ο
18 0.0 1.4 42.9 Switch from English to Metric Units
19 0.0 9.2 285.7 Relative Compass Bearing
20 0.0
21 0.0
22 0.0
23 0.0
24 0.0
25 0.0
Target or Limit Value
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 9 3 3 1 1 9 3 3 9 3 1 1 3 9 3 3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 369.4 24.8 17.3 1.7 3.4 52.8 66.8 45.4 136.2 45.7 15.1 15.1 46.2 141.9 18.4 9.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 36.6 2.5 1.7 0.2 0.3 5.2 6.6 4.5 13.5 4.5 1.5 1.5 4.6 14.1 1.8 0.9
Numeric Values for Relationship Matrix Calculations
1 15.1 9 0 0 0 0 0 3 3 9 3 1 1 3 9 0 0 0 0 0 0 0 0 0 0 0
2 14.4 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 7.0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 5.8 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 3.4 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 5.9 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 1.7 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 7.5 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 7.2 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 3.6 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0.3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0.3 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0
13 1.9 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0
14 1.7 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 6.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0
16 4.7 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 3.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0
18 1.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 9.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
369.4070905 369.4070905 24.84718826 24.84718826 17.32885086 17.32885086 1.650366748 1.650366748 3.392420538 3.392420538 52.81173594 52.81173594 66.8398533 66.8398533 45.38508557 45.38508557 136.1552567 136.1552567 45.6601467 45.6601467 15.12836186 15.12836186 15.12836186 15.12836186 46.21026895 46.21026895 141.9315403 141.9315403 18.42909535 18.42909535 9.077017115 9.077017115 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell. Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.

House of Quality 3

Title:
Author:
Date:
Notes:
Legend
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ 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
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement: Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics (a.k.a. "Functional Requirements" or "Hows") Selection of types of material and methods Ensure design in accordance Control construction on the project based on standards Training Programs for Workers and Employees Efficient Safety Programme Effective Procurement system Reward scheme for innovation competitive career progress scheme Setting and Practicing specific standard for construction Determining the deviations corrective measures to reduce variation Standard Improvement with time
Demanded Quality (a.k.a. "Customer Requirements" or "Whats")
1 0.0 36.6 369.4 Satisfaction of Contract Specifications
2 0.0 2.5 24.8 Completion of Project within Time
3 0.0 1.7 17.3 Enhancing Customer/ Owner Satisfaction
4 0.0 0.2 1.7 Motivation and Empowerment of Employees
5 0.0 0.3 3.4 Avoiding Disputes and Claims
6 0.0 5.2 52.8 Performance based on Purpose
7 0.0 6.6 66.8 resource management
8 0.0 4.5 45.4 plant and equipment
9 0.0 13.5 136.2 control of quality of materials
10 0.0 4.5 45.7 process control
11 0.0 1.5 15.1 production and delivery
12 0.0 1.5 15.1 safety
13 0.0 4.6 46.2 material testing
14 0.0 14.1 141.9 application of control charts
15 0.0 1.8 18.4
16 0.0 0.9 9.1
17 0.0
18 0.0
19 0.0
20 0.0
21 0.0
22 0.0
23 0.0
24 0.0
25 0.0
Target or Limit Value
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult)
Max Relationship Value in Column 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight
Numeric Values for Relationship Matrix Calculations
1 36.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 2.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 1.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 5.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 6.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 4.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 13.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 4.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 1.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 1.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 4.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 14.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 1.8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell. Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.

House of Quality 4

Title:
Author:
Date:
Notes:
Legend
Θ Strong Relationship 9
Ο Moderate Relationship 3
▲ 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
Powered by QFD Online (http://www.QFDOnline.com)
Column # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Direction of Improvement: Minimize (▼), Maximize (▲), or Target (x)
Row # Max Relationship Value in Row Relative Weight Weight / Importance Quality Characteristics (a.k.a. "Functional Requirements" or "Hows") smooth operations operation and engineer availability application and othe control charts method of loading materials method of delivering cables monitoring quality audit target workability
Demanded Quality (a.k.a. "Customer Requirements" or "Whats")
1 9 machine specifiactions Θ Θ Ο Θ Θ Θ Θ Θ
2 9 material handling Ο Ο Ο Ο ▲ ▲ Θ Θ
3 9 material availbaility Ο Ο Ο Ο Ο ▲ Ο Θ
4 9 meter system Θ Ο Ο Ο Ο ▲ Ο Θ
5 9 monitoring quality Ο Ο Ο ▲ ▲ ▲ Ο Θ
6 3 testing frequency Ο Ο Ο ▲ ▲ ▲ ▲ Ο
7 3 labour availability Ο ▲ ▲ ▲ ▲ ▲ ▲ Ο
8 9 arrengements Ο Ο Ο ▲ ▲ Θ ▲ Ο
9 9 Setting and Practicing specific standard for construction Θ Θ Ο Ο Ο Ο Ο Ο
10 0.0
11 0.0
12 0.0
13 0.0
14 0.0
15 0.0
16 0.0
17 0.0
18 0.0
19 0.0
20 0.0
21 0.0
22 0.0
23 0.0
24 0.0
25 0.0
Target or Limit Value
Difficulty (0=Easy to Accomplish, 10=Extremely Difficult) 2 6 7 8 9 10 9 1
Max Relationship Value in Column 9 9 3 9 9 9 9 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Weight / Importance 462.8 287.8 285.0 223.7 191.0 143.4 290.5 715.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Relative Weight 17.8 11.1 11.0 8.6 7.3 5.5 11.2 27.5
Numeric Values for Relationship Matrix Calculations
1 0.0 9 9 3 9 9 9 9 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0.0 3 3 3 3 1 1 9 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0.0 3 3 3 3 3 1 3 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0.0 9 3 3 3 3 1 3 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 0.0 3 3 3 1 1 1 3 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 0.0 3 3 3 1 1 1 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 0.0 3 1 1 1 1 1 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 0.0 3 3 3 1 1 9 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 0.0 9 9 3 3 3 3 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Note: the cells in the above row are setup the way that they are because you cannot enter an array formula in a merged cell. Thus, the red cells contain the array formula and the cell beside the red cell displays the vale.

About

Template Sponsors:
Template Name: Traditional House of Quality (Large)
Version: 1.2.15.0
Release Date: January 15, 2008
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/

™

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