ch. 8 qfd template

Instructions

Notes on using the QFD (Quality Function Deployment or House of Quality) template:

All turquoise cells are to be entered by the user. Other values are automatically calculated, and do not need to be altered.

Cells with red marks in the upper right corner have comments, let the mouse hover over these cells to read the comments to further explain the contents of a cell.

This spreadsheet is locked/protected in order to keep the cells with equations from being changed. If a cell need to be altered, the spreadsheet first needs to be unlocked/unprotected. Do this by selecting the workbook you wish to unlock, click on "Tools", highlight "Protection", and select "Unprotect Sheet". The sheet will then be unlocked so alterations can be made.

Begin with the Customer and Design Requirement worksheet. 1. Input a name for your House of Quality 2. Input each customer requirement, an importance rating for that requirement, an evaluation of how well your current process/product meets that requirement, and an evaluation of how well the competition meets that requirement.This information should be gathered from the customer and is often referred to as the Voice of the Customer (VOC). 3. Input the technical requirements of the process/product. These are measureable technical requirements related to the customer requirements. Units for each requirement should be input along with an evaluation of the current process/product and the competition.

Next, go to the HOQ 1A worksheet. 4. Input the strength of the relationship between each customer requirement and each technical requirement (1=weak, 3=medium, 5=strong) in the center of the HOQ. 5. Input the direction of the relationship among technical requirements in the roof of the HOQ.

Finally, go to the HOQ 1B worksheet. 6. Input the desired target specification values.

The final House of Quality can be found on the HOQ 1Final worksheet.

Often this first House of Quality is followed by other matrices. For products, the product target values are translated into parts targets, process targets and production settings. For processes, the process target values are translated into functional requirements, design requirements and key process variables. We have included the process type in this workbook.

Customer and Tech RequirementHouse of Quality for ________Competitive Evaluations (1-5)Customer Requirement #Customer RequirementsRelative Importance (1-5)Our Product/ServiceCompetitor ACompetitor B1Customer requirement55112Customer requirement54113Customer requirement53114Customer requirement51115Customer requirement51116Customer requirement51117Customer requirement111Technical Requirement #Customer Requirement #Technical RequirementsMeasurement UnitOur Product/ServiceCompetitor ACompetitor B1Technical requirementMeasurement Unit5322Technical requirementMeasurement Unit5323Technical requirementMeasurement Unit5324Technical requirementMeasurement Unit1115Technical requirementMeasurement Unit1116Technical requirementMeasurement Unit1117Technical requirementMeasurement Unit1118Technical requirementMeasurement Unit1119Technical requirementMeasurement Unit11110Technical requirementMeasurement Unit11111Technical requirementMeasurement Unit11112Technical requirementMeasurement Unit11113Technical requirementMeasurement Unit11114Technical requirementMeasurement Unit11115Technical requirementMeasurement Unit11116Technical requirementMeasurement Unit11117Technical requirementMeasurement Unit111

HOQ 1AHouse of Quality for ________+Positive or Reinforcing Relationship-Negative or Tradeoff RelationshipRelative Importance or WeightDesign RequirementsTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementOur Service/ProductCompeting Service/Product ACompeting Service/Product BCustomer RequirementsX manufacturerY manufacturerCustomer requirement5511Customer requirement5411Customer requirement5311Customer requirement5111Customer requirement5111Customer requirement5111Customer requirement0111calculations00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Importance Weighting00000000000000000Measurement UnitsMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitOur Value55511111111111111Competitor A33311111111111111Competitor B22211111111111111Target Specification Values

From the customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetThe triangular roof of the house of quality is used to indicate where technical requirements trade-off or reinforce each other. Does improving one requirement result in a decrease (-) of an increase (+) in another requirement? This information can help the design team by making explicit where tradeoffs are needed.From the customer and design requirements worksheet.Calculated on this worksheetFrom the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.Input the strength of the relationship between each customer requirement and each technical requirement.

1 = weak, 3=medium, 5=strong.

HOQ 1A

Our Service/ProductCompeting Service/Product ACompeting Service/Product B

HOQ 1B

Our ValueCompetitor ACompetitor BTarget Specification Values

HOQ 1FinalHouse of Quality for ________000000000000000+Positive or Reinforcing Relationship000000-Negative or Tradeoff Relationship000000000000000000000000000000000000000000000Relative Importance or Weight0000000000000000000000000000000000000000000000000000000000000000000000Design RequirementsTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementOur Service/ProductCompeting Service/Product ACompeting Service/Product BCustomer RequirementsX manufacturerY manufacturerCustomer requirement500000000000000000511Customer requirement500000000000000000411Customer requirement500000000000000000311Customer requirement500000000000000000111Customer requirement500000000000000000111Customer requirement500000000000000000111Customer requirement000000000000000000111Importance Weighting00000000000000000Relative Importance Weighting00000000000000000Measurement UnitsMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitOur Value55511111111111111Competitor A33311111111111111Competitor B22211111111111111Target Specification Values

From the customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetFrom HOQ template-1From the customer and design requirements worksheet.From HOQ template-1 worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From HOQ template -1

HOQ 1Final


Matrix 2


Matrix 3House of Quality for ________000000000000000+Positive or Reinforcing Relationship000000-Negative or Tradeoff Relationship000000000000000000000000000000000000000000000Relative Importance or Weight0000000000000000000000000000000000000000000000000000000000000000000000Technical RequirementsTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementTechnical requirementOur Service/ProductCompeting Service/Product ACompeting Service/Product BCustomer RequirementsX manufacturerY manufacturerCustomer requirement500000000000000000511Customer requirement500000000000000000411Customer requirement500000000000000000311Customer requirement500000000000000000111Customer requirement500000000000000000111Customer requirement500000000000000000111Customer requirement000000000000000000111Importance Weighting00000000000000000Relative Importance Weighting00000000000000000Measurement UnitsMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitMeasurement UnitOur Value55511111111111111Competitor A33311111111111111Competitor B22211111111111111Target Specification Values00000000000000000

From HOQ template-1 worksheet.From the customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetFrom customer and design requirements worksheetFrom HOQ template-1From the customer and design requirements worksheet.From HOQ template-1 worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From the customer and design requirements worksheet.From HOQ template -1

Matrix 3


Matrix 4


Matrix 2Functional RequirementsTechnical RequirementsRelative WeightFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementFunctional RequirementTotalTechnical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Technical requirement00Total0000000000Relative Weight (Priority)0000000000

From HOQ template-2 worksheetFrom HOQ template-1 worksheet.From HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 Final

Matrix 3Design RequirementsFunctional RequirementsRelative WeightDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementDesign RequirementTotalFunctional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Functional Requirement00.00Total0000000000Relative Weight (Priority)0000000000

From Matrix 2From HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 Final

Matrix 4Key Process VariablesDesign RequirementsRelative WeightKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableKey Process VariableTotalDesign Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Design Requirement00.00Total0000000000Relative Weight (Priority)0000000000

From Matrix 3From HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 FinalFrom HOQ 1 Final

ch. 8 qfd template

Documents