SBS - The best value in QMS software

Pareto Analysis - Six Sigma - 'Productivity Improvement' project



Dear All,

Greetings !

Hi all,

Could you help me out with Pareto charting. Mine is a 'Productivity Improvement' project. I have listed the reasons for poor productivity, but I am stuck at the 'Define' phase, wherein I need to create a Pareto Chart. I have listed out the 'defects' or "reasons for less productivity" but I am not able to figure out how to give each defect/reason, a number or percentage. That is, what percentage is each defect of the total ?

I am attaching the details of the project, excel sheet 'Define-5-4-2014'. The 'defects/reasons' are under the 'reasons' tab.

Thank you.




Elsmar Forum Sponsor

Bev D

Heretical Statistician
Staff member
Super Moderator
Well, this is a LEAN project not a "Six Sigma" project. that said you are startign OK with a reason list for long cycle. in your case I am assuming that productivity means how many reports are processed in a period of time....

the best - and really only - approach to filling out the pareto is to sit and watch several people do several of these reports o fvarying complexity. time the steps, note the number of defects and reworks and voila! you have your answer of which item contributes the most to long cycle time. You will also come up with more items that contribute to long cycle time than on your list.
Next identify which steps are non-value add, in other words do they do that doesnt' contribute directly to the goal fo their job. can you eliminate these steps?
Thread starter Similar threads Forum Replies Date
M Definition Pareto Analysis (80/20 rule) - Definition of Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 10
K Pareto Analysis for Common Defects - To pareto or not to pareto Quality Tools, Improvement and Analysis 9
S Getting the Right Things Done - A useful way to apply Pareto analysis The Reading Room 1
J How to use CNX? Pareto-Ishikawa-CNX-SOP analysis - PF/CE/CNX/SOP Misc. Quality Assurance and Business Systems Related Topics 5
A How to Subset Pareto Cause in JMP using JSL Software Quality Assurance 4
B Understanding the attached sample Pareto Chart for Customer Complaint Quality Tools, Improvement and Analysis 20
M Minitab Pareto Chart Text Adjustment Using Minitab Software 10
L Pareto question Microsoft Excel Excel .xls Spreadsheet Templates and Tools 6
J How to connect FMEA, Control Plan, G8d, 5Whys and Draw the pareto Nonconformance and Corrective Action 0
V Minitab Pareto - Trying to plot a relation of Count and Cycle Time Using Minitab Software 5
A Does anyone actually do a Pareto of the Top 5 (highest) RPN's of PFMEA? FMEA and Control Plans 8
P Pareto Charts - Analytical tools - Form Attached Quality Tools, Improvement and Analysis 5
W Sorting in Microsoft Excel .xls - I want to create a Pareto Chart Excel .xls Spreadsheet Templates and Tools 21
Q The Pareto Principle - Organizational Change Philosophy, Gurus, Innovation and Evolution 10
L Management Review Minutes and Pareto Charts Management Review Meetings and related Processes 10
J Vital few or highest pareto? Which issue should be the priority? Preventive Action and Continuous Improvement 45
N What does a Pareto chart tell me that a pie chart doesn't? Quality Tools, Improvement and Analysis 12
V Free Quality Tools for drawing Ishikawa Diagram, Pareto Diagram, Histogram, etc. Quality Assurance and Compliance Software Tools and Solutions 7
V Seeking: Free Quality Tools - Ishikawa diagram, Pareto diagram, histogram, etc. Quality Tools, Improvement and Analysis 5
D Pareto vote - Could someone explain the pareto vote process? Quality Tools, Improvement and Analysis 6
I QMS monitoring, measurement, analysis and evaluation requirement - Template ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
S How to perform verification of the Statistical Analysis Software? Qualification and Validation (including 21 CFR Part 11) 3
J Starting a Weibull Analysis: Source on how to perform Weibull Reliability Analysis - Predictions, Testing and Standards 2
V ISO 10360-5: 2020 Gap analysis and Action plan Excel .xls Spreadsheet Templates and Tools 1
Q IATF audit - Root Cause Analysis results IATF 16949 - Automotive Quality Systems Standard 5
B Struggling with using the 5.6 version Ford Capacity Analysis Report APQP and PPAP 5
JoCam MDR Gap Analysis - Consultant fees EU Medical Device Regulations 10
silentmonkey Overall Benefit/Risk Analysis - Risk Management VS Clinical Evaluation ISO 14971 - Medical Device Risk Management 3
Awais Forklift Reliability Analysis Manufacturing and Related Processes 6
T Tactics for Root Cause Analysis Problem Solving, Root Cause Fault and Failure Analysis 4
lanley liao How to correctly understand the bullet list d) of 6.3 Analysis of Data for API Spec Q1 Oil and Gas Industry Standards and Regulations 7
R The term "Benefit Risk Ratio" in EU MDR, do I need to present benefit risk analysis as a RATIO Risk Management Principles and Generic Guidelines 4
B Two excellent examples of process capability analysis from Quality Magazine Capability, Accuracy and Stability - Processes, Machines, etc. 5
D Risk Analysis using Monte Carlo Simulation instead of Scoring and Heat Map Risk Management Principles and Generic Guidelines 2
A Attribute Analysis for colour matching scale Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
M Recurrent event analysis software (python) General Auditing Discussions 2
E Normal Condition Hazards in Risk Analysis ISO 14971 - Medical Device Risk Management 3
M MDSAP and 13485:2016 gap analysis Quality Management System (QMS) Manuals 1
M Gap analysis on ISO 14971:2019 with previous revision ISO 14971 - Medical Device Risk Management 8
M Risk Analysis Flow - Confusion between ISO 14971 and IEC 62304 IEC 62304 - Medical Device Software Life Cycle Processes 8
R ECG Risk Analysis Standards ISO 14971 - Medical Device Risk Management 2
T Root Cause Failure Analysis - Not following Customer packaging Specification Problem Solving, Root Cause Fault and Failure Analysis 9
H ISO 13485:2016 Gap Analysis by NB ISO 13485:2016 - Medical Device Quality Management Systems 7
R Capability analysis - What is going on this chart? Manufacturing and Related Processes 15
adir88 Documenting Risk Control Option Analysis ISO 14971 - Medical Device Risk Management 8
MrTetris Should potential bugs be considered in software risk analysis? ISO 14971 - Medical Device Risk Management 5
K Analysis variation among the lots during cpk calculation. Design and Development of Products and Processes 1
DuncanGibbons Best practice for identifying "items" of parts for DFMEA analysis AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
J Looking for a EU MDR Gap Analysis template EU Medical Device Regulations 6
B Has anyone done an IEC 60601-1 gap analysis to IEC 60335? Medical Device and FDA Regulations and Standards News 4

Similar threads

Top Bottom