Quality Analysis Tools

Pareto Chart Excel Template | Download format

by
Pareto Chart Excel Template

Pareto Chart Excel Template | Step by Step guide of template usages:-

Hi Readers! In this article, we have discussed on Pareto Chart Excel Template with a manufacturing example. and also you can learn here, the Pareto chart principle (80/20 rule). if you would like to download our excel template or format then, go through the below link.

Download–Pareto chart Excel Template.

Pareto Chart Excel Template

[Figure 1]

How to Use Pareto Chart Excel Template:

After downloading, the above Pareto Chart Excel Template Carefully read the Note and red highlighted box marked in excel.

Note 1:- White cells are only changed values. The sky colour cells will automatically calculate based on the formula within the cells.

Note 2:- Starting from the top, enter the name of causes into the table below in descending order (Largest to Smallest Values)

Example of Pareto chart:

Let us have ten causes as Damage, Crack, Shrinkage, Short-run, Blowhole, Pin-hole, Extra Metal, Sand-wash, Rough Surface, Low hardness, and High elongation.

Causes Rejection Quantity
Damage 23
Shrinkage 20
Crack 11
Short-run 7
Blow-hole 8
Extra Metal 5
Sand wash 6
Rough surface 3
Low hardness 4
High elongation 1

Now you have to do the sorting of Rejection Quantity in Descending order (Largest to smallest value)

Descending order of Rejection Quantity of above causes are,-

Causes Rejection Quantity
Damage 23
Shrinkage 20
Crack 11
Blow-hole 8
Short-run 7
Sand wash 6
Extra Metal 5
Low hardness 4
Rough surface 3
High elongation 1

Now directly we have to enter the name of causes and Rejection quantity (After sorting the value in descending order) into white cells of the Excel template sheet. After entering the values the Pareto chart will look like as below.

Pareto chart example

DOWNLOAD EXCEL TEMPLATE

DOWNLOAD 7QC TOOLS TEMPLATE

Pareto Principle (80/20 Rule):-

The 80/20 Rule or Pareto Principle is the most important part of Pareto Analysis. The rule 80/20 says that 80% of the effects come from 20% of the causes.

In Italy, Vilfredo Pareto has originally observed that 20% of people were owned 80% of the land. This principle was applied to quality control and favoured the use of the statement of phrase, which is “The Vital few and useful many” to define the 80/20 rule in the 20th century by Dr. Joseph M. Juran. Nowadays this principle is so popular and very useful in describing the contribution of the causes.

Understanding of Principle:-

Let’s get started with this principle, and how it is applicable in different sectors like manufacturing and non-manufacturing unit or service sectors. This principle is not limited to any particular sector or unit’s problems or defects to identify the contribution. It will help you to resolve 80% of problems/causes/defects among the 100% of problems.  

How this principle is related to the different fields: – (Example)-

  • Filed failure (for example (a)-80% of the field failure comes from 20% of the Causes.
    (b)-80% of the field failure comes from 20% of the Customer).
  •  80% of the results come from 20% of the Team.
  • Risk Management (e.g. 80% of the Risk comes from 20% of the Causes).

Let us have ten types of Causes and individual causes having a number of defects. Now we need to work on merely an 80% contribution to resolve the problem. But the things are how to identify the causes those are coming under the 80% contribution. So to identify the contribution we need to use the Pareto chart for knowing the contribution. So I would recommend you to download the above Pareto Chart Excel Template then, follow the steps and identify the contribution.

Advantages of Pareto Chart:

1. Production Optimisation.

2. Rejection Reduction.

3. Cost of Poor Quality Reduction.

4. Quality level Improvement.

5. Product Performance Improvement

6. Customer satisfaction Enhancement.

7. Rework cost reduction.

Etc.

The Pareto chart is the most commonly used tool in manufacturing industries, I remember when I was working in the quality department, how frequently I used this tool in our daily quality issue analysis. I used this tool on a daily line rejection analysis, as well as in different types of QA or QC projects like quality circle projects, SGA projects, Six Sigma projects, etc. With the help of the Pareto chart, you can easily visualize the defect’s contribution and accordingly, you can do an analysis of the majority contribution for improvement.

FAQ:

The Pareto chart is one of the commonly used 7 QC tools in manufacturing industries.

Similar Articles:

Histogram Example | Foundry Industries Examples.

Histogram Template with example | Download.

How to plot Histogram in Excel (Step by step guide with example)

SPC Format |DOWNLOAD Excel Template of SPC Study

7QC Tools for Problem Solving | What are 7 QC Tools

Root Cause Analysis | 8 Steps of RCA

More on TECHIEQUALITY

Thanks for reading…Keeps Visiting Techiequality.Com

Popular Post:

Fishbone Diagram Template With Example

by
Fishbone Diagram Template

Fishbone Diagram Template With Example | Download Template

Download the Fishbone Diagram Template by clicking on the below link. Fishbone Diagram will help you to represent the Potential Causes of a Problem.

DOWNLOAD the Cause & Effect Diagram / Fishbone Diagram.

How to Use Fishbone Diagram Template:

Fishbone Diagram Template

[Figure-1]

Step-1: Download the Fishbone Diagram Template (Link is given at the top)

Step-2: Enter the Name of the Problem in the Red Highlighted Box, marked in the Excel template (e.g. refer to the above Figure-1 for easy understanding)

Step-3: Identify and then enter the Potential causes in the Sky color box in the Excel template under Man, Machines, Material, Method, Measurement, and Environment. 

How to Identify the Potential Causes of a Problem:

Step-1: To make a CFT Team (Cross-Functional team). Members of CFT should be from different and different processes/areas or departments. E.g. someone from production, Quality, technical, R&D, Maintenance, etc.

Step-2: Individually identify the Causes through Brainstorming.

Step-3:  Before you identify the causes by all team members, you have to list up all causes without any repetition. Next, all members of the team should sit together to identify the new causes through Brainstorming. And finally, do the list up of all causes identify by individual and team.

Step-4: Represent all potential causes in the Cause and Effect Diagram Template or Fishbone Diagram Template or Ishikawa Diagram Template.

Step-5: Identify the Significant Causes with the help of Hypothesis testing.

Step-6: Do the Root cause analysis with the help of Why- why Analysis to identify the Root Cause

Step-7: Take Corrective and Preventive Action on the Root cause.

Example-1: Casting Shrinkage Problem.

I have taken a Problem from the Iron casting Process as Shrinkage. Here I need to represent the Potential causes of Shrinkage in the Fishbone Diagram Template or Cause and Effect Diagram Template or the Ishikawa Diagram template. First of all, I made a CFT team considering the members from the production process, quality, Development, and Maintenance Department.

Instructed all members to identify the Potential cause relevant to their work function in individually through Brainstorming. Next, collect all Potential causes. And then call a meeting for further identification of Causes together with all members through Brainstorming. List up all Causes and represent those in the Fishbone Diagram Template, just like the below figure.  

Fishbone Diagram Example
Example-2: Casting Blow-hole Problem:

Below are the potential causes that may cause the blow-hole problem in raw casting products;

  • Improper manual core spray.
  • Improper manual mould spray.
  • Unskilled operators.
  • Core curing time is not validated w.r.t season.
  • Core curing m/c burner problem.
  • LP gas regulator issue.
  • Electric heater -heating issue.
  • Mould spray gun damage.
  • No deslagging.
  • Wet core used.
  • Low permeability.
  • Extremely high sand strength.
  • No venting system.
  • High moisture.
  • Core used without treatment.
Fishbone Diagram Template
Benefits of Fishbone Diagram:
  • It represents and displays the relationship of potential causes w.r.t Problem: – All Possible causes will represent them under which category among the man, machines, method, measurement, material, and environment.
  • Accumulate the possible Reasons in a single diagram: – It will be very difficult to resolve the problem without any idea of the Possible or Potential causes of any problem. So this diagram will show you all the causes simultaneously.
  • Involvement in Brainstorming: – It will help you to boost and structure the brainstorming to identify the possible causes or reasons.
  • It will help you to maintain the team focus to achieve the common goal: – As you know the team mission is to achieve the common goal means to identify the possible causes or reasons. All team members will identify the Causes or Reasons individually and together in a team to list-up the possible causes.

How to plot Ishikawa or cause and effect diagram of customer complaint:

first of all, download the cause and effect diagram template or Ishikawa diagram template from the given above link (at the top) and then follow the below steps. As per my own experience regarding the preparation of cause and effect diagrams related to customer complaints. at first, when I received a customer complaint, I just tried to understand the nature and type of problem and immediately called for a meeting for initial problem understanding with team members. Once it’s understood by all the team members, then we form a special team for 8D or CAPA formation.

Before doing the why-why analysis we have to identify the potential causes by using popular tools i.e. fishbone or cause & effect or Ishikawa diagram. To do so, the individual team members should identify the potential cause w.r.t customer complaints, Once you collect the all identified potential causes by individual members, then you have to plot the final fishbone diagram to keep in your mind with the repeated potential causes. when you choose to form the team at that time members should be in CFT of that process where the customer problem is related.

More on TECHIEQUALITY