QFD Analysis Example

QFD Analysis Example

Problem Statement

Perform a QFD analysis for a consulting company based on the following needs.

Customer Needs

CTQ Measures

Cost

Quality of Workforce

Quality

Number of Consultants

Delivery

Incentive Structure

Support

Standardized Documents

How to perform analysis

Step 1: Open Sigma Magic
  1. Click on the Sigma Magic button on the Excel toolbar.
  2. Click on the New button to create a new project.
Step 2: Add the analysis template
  1. Click on the Tool Wizard to add the analysis template.
  2. Click on Project and then QFD Analysis.


Step 3: Specify analysis options
A new worksheet will be added to your workbook. Analysis Setup will be automatically opened, in the setup tab specify the following details.



If you need to make changes to the charts, specify the optional settings in the Charts tab.

 Labels:

  • Add a title for the chart.
  • Label the X-axis and Y-axis appropriately.

Appearance:

  • Adjust colors, font sizes, or other visual elements as needed.
  • Enable/disable gridlines or background shading.


Step 4: Enter the details in worksheet
Click Create, the worksheet will created and then enter all the details. A sample is provided below:




Click the Verify tab to ensure all the inputs are okay and shown in a green checkmark.



Step 5: Generate analysis result
Click Analyze and then click Compute Outputs to get the final results



Interpreting Results

1. Customer Needs & Priorities
  1. The table displays four major customer requirements along with their respective weightages:
  2. Low Cost (Weight: 3)
  3. Good Quality (Weight: 9)
  4. Fast Delivery (Weight: 3)
  5. Long-Term Support (Weight: 4)
  6. Good Quality is the most significant requirement (with a weightage of 9), meaning it is the biggest driver for the satisfaction of customers.
2. Technical Requirements & Competitive Analysis
  1. The columns include different technical parameters, such as the quality of the workforce, number of consultants, machine structure, standardized documents, and workflow.
  2. For each technical requirement, a target specification is used to map it against customer needs.
  3. Competitive analysis compares the current status of the company with Competitor A, B, C, and D to understand relative positioning. In case the competitors score higher on aspects such as good quality and long-term support, the company needs to work on these areas to get an edge over them.
3. Critical-to-Quality (CTQ) Importance Chart Analysis
  1. The CTQ 1 parameter has the highest importance score (~90), meaning it greatly affects customer satisfaction.
  2. CTQ 3 & CTQ 4 also have moderate scores, while CTQ 2 has a very low score, meaning it might not be as critical.
  3. The company should focus on CTQ 1 & CTQ 3, as they have high importance for customers.
4. Risk Importance Chart Analysis
  1. The risk score is the highest for CTQ 1 & CTQ 2, which means they are the most difficult to implement.
  2. CTQ 3 has the lowest risk, meaning it is easier to implement and improve.
  3. A strategic approach should be taken to mitigate risks associated with CTQ 1 & CTQ 2 while leveraging the easier implementation of CTQ 3.

    • Related Articles

    • QFD analysis frequently asked questions

      What is QFD (Quality Function Deployment) QFD is a structured method used to capture customer requirements and translate them into technical specifications to ensure the final product or service meets customer expectations. What are the key benefits ...

    • QFD Analysis Overview

      What is QFD? Quality Function Deployment (QFD) is a structured approach to translating customer requirements (Voice of the Customer - VOC) into specific technical features and actions at different stages of product or service development. It ensures ...

    • Correspondence Analysis Example

      Problem Statement We have collected data on several people's eye and hair color. Use correspondence analysis to determine if there is any correspondence between the two. How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic button ...

    • SMED Analysis Example

      Problem Statement Create a SMED analysis for reducing the changeover time for planes between two flights. # Description 1 Check if all personnel are present 2 Security check 3 Gather all tools & supplies 4 Cleanup plane 5 Refurbish plane 6 Clean ...

    • Waste Analysis Example

      Problem Statement Select a process and create the waste analysis for each step in the process. How to perform Analysis Step 1: Open Sigma Magic Click on the Sigma Magic button on the Excel toolbar. Click on the New button to create a new project. ...