Suitable control chart to use to monitor Corrective Action Response Time data

U

UK Steve

#1
I'm looking for a suitable control chart to use to monitor the time is takes to respond to a corrective action request.
Historical data (2008) parameters are as follows:

Population - 177
Mean - 6.66 days
Median - 4.93 days
Std Dev - 6.896 days
Range - 4.62 days
Dist - RH Skew (No positive fit in Minitab)

Target - 3 days

There are a number of outliers present in the dataset.

I've looked at the data using various control and time series charts including subgrouping by week /month and am still unsure what is best to use.

I'm also trying the 'baseline' the process using a capability indices but the outliers are proving problematic from a stability standpoint.



I have wonder if one of our Stats experts could give me some guidance as to:
  • the most effective way to 'baseline' this data and
  • what type of control chart would be most suitable to monitor this type of data is the future?
Many thanks in advance
Steve
 

Attachments

Elsmar Forum Sponsor

Statistical Steven

Statistician
Staff member
Super Moderator
#2
Re: Help with Response Time data

Just a few comments about the problem. First, control charting time to respond to a CAR is a terrible statistic. You have a target of 3 days, so does it matter if you miss the target by 1 day or 10 days? If not, then you can use a p-chart to look at percent of CARs that meet target. You can do this on a monthly cycle and use the np limits. Second, time to respond to a CAR is a lag function. So if the CAR was initiated today and I do not respond till September, the control limit would be out of control (theoretically) in September for an event that occurred in July. More importantly, unless you can normalize the time for the volume of CARs, the statistic is not very representative. If the number of CARs per day is charted, you might be able to make sure the process is operating. The 3 day limit is arbitrary. The system might not be capable of meeting the deadline with the current staff levels.

I think you need to look at your metrics and assess the best method for creating a dashboard. You can PM me if you have other questions.
 
#3
Instead of a control chart, use a run chart. You can set the time frame by week/year or month/year. Average the number days to close during each time frame and plot that data. You may also want to plot the maximum time frame above the average line. On the same chart plot your goal of 3 days. This will allow you to show your improvements over time.

When you take improvement action to corrective action response time, make a note on the chart and record the action
 
Thread starter Similar threads Forum Replies Date
D Electronic Document Control System suitable for TS 16949 Requirements Document Control Systems, Procedures, Forms and Templates 2
A The requirement of the PMS plan--suitable indicators and threshold values EU Medical Device Regulations 0
S Two or more predicates suitable? 510K submission US Food and Drug Administration (FDA) 5
M Informational FDA Classifies Suitable Accessories into Class I as Required by the FDA Reauthorization Act of 2017 Medical Device and FDA Regulations and Standards News 0
M Suitable form or questionnaire for approving consultants Document Control Systems, Procedures, Forms and Templates 9
Q Recommendation for a suitable PA on a complaint received Preventive Action and Continuous Improvement 3
D Suitable CE Mark Directives - Product Families CE Marking (Conformité Européene) / CB Scheme 3
S Suitable Protocol for Isolation of Clostridium perfringens Food Safety - ISO 22000, HACCP (21 CFR 120) 2
S PCR suitable for detection of Salmonella Food Safety - ISO 22000, HACCP (21 CFR 120) 1
K Intended Use wording: What is suitable for the instruction manual? EU Medical Device Regulations 4
S Protocol of water activity measurement and suitable instrument Food Safety - ISO 22000, HACCP (21 CFR 120) 1
S Choosing a suitable type of Elisa to Test my Sample Misc. Quality Assurance and Business Systems Related Topics 3
R Is IEC 60601-2-37 suitable for Fetal Doppler Detector? IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
K What kind of people are suitable for Quality Management? Career and Occupation Discussions 12
R Is INMETRO certification suitable for medical device components? IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
R How to decide a suitable contact time from table 23 of IEC 60601-1:2005 IEC 60601 - Medical Electrical Equipment Safety Standards Series 6
M IVD Annex III Path - Suitable Quality System (e.g. ISO 9001, ISO 13485)? EU Medical Device Regulations 2
V What are suitable "Leading Indicators and Metrics" for QA Quality Tools, Improvement and Analysis 7
B What is "Use of suitable production equipment" - ISO 9001 Clause 7.5.1 c) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
W Calculation of % defectives to determine suitable AQL Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
O Chemical composition of plastic compound suitable for manufacturing plastic gears Manufacturing and Related Processes 9
H Can you tell me a suitable "tooling" for Caliper Calibration - ISO 17025 ISO 17025 related Discussions 16
J Measurement Uncertainty (MU) - Genetic Testing Lab - Lack of suitable CRM - ISO 17025 ISO 17025 related Discussions 6
P How do I calculate a suitable sample size for a continuous process Statistical Analysis Tools, Techniques and SPC 4
P Suitable step in my continuous development?? Career and Occupation Discussions 4
M Can this Nonconformance have suitable CAPA (Corrective and Preventive Action) Nonconformance and Corrective Action 9
S Suitable Sterilization Cycle to achieve Sterility Assurance Level of <10-6 ISO 13485:2016 - Medical Device Quality Management Systems 1
F Suitable welding electrode and method of use FMEA and Control Plans 1
V What is an Epoxy suitable for autoclaving? Manufacturing and Related Processes 4
S 5-S Training Material (pictorial/cartoon) type suitable for Operators Training - Internal, External, Online and Distance Learning 8
M Is 6 sigma suitable for ship building where the nature of work is non repetitive? Six Sigma 12
A Can a Gage R&R be used to Determine Suitable Guardband Limits? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
M Suitable SPC tool for Leather Garment / Textile industries Statistical Analysis Tools, Techniques and SPC 2
Jen Kirley A pointed question for the gang - Why I am suitable for a specific position Career and Occupation Discussions 25
I Suitable ISO 9001 Registrar - IT sector engaged in delivering Web based solutions Registrars and Notified Bodies 18
A Are these suitable Quality Objectives? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
C Standard/Specification suitable for an industrial cafeteria? Food Safety - ISO 22000, HACCP (21 CFR 120) 3
W Continuing Professional Development - Can anyone suggest suitable training material Professional Certifications and Degrees 2
B X-R chart - Suitable with method? Tubes and hoses - ID Statistical Analysis Tools, Techniques and SPC 1
S Zero defects - Which sampling procdure is suitable? E.g. ISO2859 Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
E Seeking "Games" Suitable for an Internal Problem Solving Course Nonconformance and Corrective Action 10
Y How to select the most suitable person to be the Management Representative? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 17
V Is an 8D Report suitable as a basis for the effcetiveness of preventive action? Nonconformance and Corrective Action 16
J Quality Training - Types of courses in Quality suitable for lower management staff Training - Internal, External, Online and Distance Learning 12
D Control Number for Class III and IV devices Canada Medical Device Regulations 0
J Document Control Metrics Document Control Systems, Procedures, Forms and Templates 3
I Document Control Software Document Control Systems, Procedures, Forms and Templates 2
T Controlling Expandable Forms in Paper-Based Document Control System Document Control Systems, Procedures, Forms and Templates 10
N ISO 13485 7.3.9 Change control in medical device software ISO 13485:2016 - Medical Device Quality Management Systems 6
C UDI Questions on Control Units Other US Medical Device Regulations 6

Similar threads

Top Bottom