Quality & InspectionFree calculatorPDF, Excel, Word export

CAPA Backlog Clearance Time Calculator

A growing CAPA backlog is one of the first things an auditor or a management review notices. This calculator uses intake and closure rates to show when, or whether, the backlog clears, and what average cycle time your throughput implies.

Your numbers

records
records/month
18 records/month
records
days

Your procedure target for open to effective close.

Your results

Months to clear backlog
16 months
Shows 0 when closures do not exceed new records, meaning the backlog never clears at this pace.
Backlog in 12 months at current rates
16
Net burn-down per month
4
Positive means the backlog is shrinking.
Implied average cycle time
108 days
Little's law: work in progress divided by throughput.
Gap to target cycle time
18 days
Overdue share of backlog
32.8%

A planning view based on average rates. Real closure rates vary by CAPA complexity and approval cycles.

Save results:

Backlog in 12 months vs closures per month

Sweeps CAPAs closed per month from 5 to 40, holding your other inputs fixed.

CAPA aging dashboard from your data

Optional: talk through building a live CAPA aging and throughput report from your quality records.

Optional. The tool and every export work without this. No spam.

How to use it

Pull three numbers from your quality system for the last quarter: open records, records opened per month and records closed per month. Enter the count of overdue records and your procedure cycle time target. Then move the closure slider to see how much faster you must close to get ahead. Count only CAPA, not every NCR, unless your system treats them as one workflow.

The method behind it

Net burn-down is closures minus intake. Time to clear is backlog divided by net burn-down, and it only exists if net is positive. Average cycle time uses Little's law: work in progress equals throughput times time in system, so time in system is backlog divided by closure rate. It is an average, so a handful of very old records can hide behind a healthy number.

  • Net = closed - opened per month
  • Months to clear = backlog / net
  • Cycle days = backlog / closures per month x 30.4
  • Backlog in 12 months = backlog - 12 x net

How to read the result

If the chart shows the 12 month backlog flat at the current level, you are only treading water. If cycle time is far above your target, the problem is usually approvals and verification of effectiveness, not the investigation itself. Sort the backlog by age and by stage in your system to find where records wait.

Common mistakes

Closing records faster by lowering the bar on effectiveness checks, which brings repeat issues back as new records. Counting containment-only tickets as CAPA. Ignoring that intake can rise after a supplier or process change, so rerun this tool each month with fresh numbers.

Frequently Asked Questions

What is a healthy CAPA cycle time?

It depends on your procedure and the risk class. Many sites target 60 to 120 days for standard records, with faster targets for safety or customer-escape issues. Use your own documented target.

Why does the tool show 0 months to clear?

That means you close fewer records than you open, so the backlog does not clear at current rates. Raise closures or reduce intake by filtering what truly needs a CAPA.

Does Little's law apply to CAPA?

As an average over a stable period, yes. It works best when intake and closure are roughly steady. After a spike in new records, the figure lags reality.

Should overdue records be handled separately?

Yes. Track them as their own queue with owners and dates. The overdue share shown here helps decide whether to run a focused clean-up sprint.

If your CAPA data lives in an ERP quality module or a separate system, we can help build an aging and throughput view that feeds your management review automatically.

Talk to an ExpertExplore More Free Tools

Related Tools

Quality & Inspection

Suspect Lot Sorting and Containment Cost Calculator

Cost and time to 100 percent sort a suspect lot, including defects found, defects likely missed and cost per piece.

Quality & Inspection

Escaped Defect Cost by Detection Stage Calculator

Model the cost of defects by where they are found, and the annual saving from shifting detection earlier.

Quality & Inspection

Pareto Defect Cost Ranking Worksheet

Editable table to log defect types, counts, unit cost and handling time, with extended cost and hours for ranking.

Quality & Inspection

Customer Nonconformance Notification Letter Template

A structured notice to a customer when shipped product may be nonconforming: what, how many, containment and when to expect the root cause.

More Quality & Inspection tools

See all
Back to All Tools