Pharma and life sciences
Findings

Pharmaceutical CDMO · oral solids and liquids · 1 GMP site in Centre-Val de Loire · 290 employeesThis War Map shows how we turn an operational review into an implementation plan. The dates show a possible sequence; the scope and schedule of a real engagement are agreed with you.

Findings

Where work gets held up, who has to step in, and what it costs in this example.

Release queue

About 68 batches wait for certification at any time. Release takes 19 working days on average, against 10 in most quality agreements.

Records go back and forth

Each batch record returns to production 2.4 times on average for documentation corrections before QA can finish its review.

Deviations age

About 38 new deviations a month. 41% close after the 30-day target, and an open deviation blocks certification of the batches it touches.

Client obligations buried in PDFs

35 quality agreements set notification and release rules. Nobody can list them without opening each file.

Illustrative time allocation for 12 interview roles

Record corrections and re-review
27%
Searching records and chasing status
21%
Improvement and client work
20%
Investigations and impact assessments
17%
Required QA checks and sign-offs
15%

These scenario percentages total 100%. They describe the 12 interview roles only, without extrapolating to all 290 employees.

48% of the time goes to correcting and re-reviewing records and to searching and chasing status. Investigations and impact assessments take 17%, required checks and sign-offs 15%. 20% remains for improvement work and clients.

Key Insight: GMP requires review and sign-off, and that 15% stays with qualified people. The target is the rework inside the 48%: records returned for missing entries, and hours spent asking where a batch stands.

SOP vs. Reality

Batch Record Review to QP CertificationSOP: 5 steps → The Reality: 12 steps, 5 handoffs
The SOP
Executed record submitted to QA
QA review
QC results approved
Deviations closed
QP certification
5 steps, linear
The Reality
12
Steps
5
Handoffs
19 working days on average
Cycle time
~27 batches/week
Volume

The written flow has five steps. In practice the record shuttles between QA and production until every entry is complete, while QC and deviation status are checked in two other systems. Certification itself is quick once the file is clean; most of the 19 days are waiting and rework.

The Gap
2.4 correction loops per record on average. Missing signatures, unexplained corrections and missing times make up most queries.
Batch status lives in SAP, LIMS and eQMS. The release tracker is rebuilt by hand from all three.
Corrections are made days after the event, which weakens contemporaneous recording.
Three pharmacists certify every batch. Month-end peaks add days to the queue.
Deviation HandlingSOP: 6 steps → The Reality: 11 steps, 4 handoffs
The SOP
Deviation recorded in eQMS
Immediate impact assessment
Investigation
Root cause and CAPA
QA approval
Closure
6 steps, linear
The Reality
11
Steps
4
Handoffs
47 days on average to closure
Cycle time
~38 deviations/month
Volume

The analysis itself is careful. The time goes into rebuilding facts that already exist in records and logbooks, and into finding out whether the same problem happened before. Every week a deviation stays open, the batches it touches stay out of the certification queue.

The Gap
Similar past cases are found by memory. The same root cause appears under different wording over the years.
Writing the timeline takes longer than analysing it. The facts are spread across the record, logbooks and LIMS.
41% of deviations exceed 30 days. Extension requests add paperwork without adding analysis.
Open deviations hold batches, so deviation aging feeds the release queue directly.
Change Control and Client NotificationSOP: 4 steps → The Reality: 10 steps, 4 handoffs
The SOP
Change request raised
Impact assessment
Approval
Implementation
4 steps, linear
The Reality
10
Steps
4
Handoffs
~1.5 h of impact search per change
Cycle time
~22 changes/month
Volume

The board decides well when the impact list is complete. Building that list depends on the author's memory and on reading PDF agreements one at a time. A missed notification clause surfaces months later, in a client audit.

The Gap
No structured list of which client must be told what, and within how many days.
Affected documents are listed from memory. A second reviewer catches some omissions, at the board meeting.
Two late client notifications in 12 months, both raised as audit observations.
Validation impact is requested by email and tracked in the author's inbox.
Client Document RequestsSOP: 3 steps → The Reality: 8 steps, 3 handoffs
The SOP
Request received
Approved document retrieved
Sent to client
3 steps, linear
The Reality
8
Steps
3
Handoffs
8 working days on average
Cycle time
~55 requests/week
Volume

Every document the client wants already exists in an approved form. The work is finding the right batch, the effective version and the client's own list, then getting QA to look at the pack. The QA check is required; the searching around it is avoidable.

The Gap
Six client portals, each with its own format and upload rules.
Batch status is confirmed by phone because the tracker is out of date by midweek.
Older batches exist only on paper until an archive scan is requested.
Sendings are logged in Excel, so proving what a client received means searching mailboxes.
Key Insight: The four sample comparisons show 140%, 83.3%, 150% and 166.7% more steps, respectively: (actual ÷ documented − 1) × 100. Under GMP some extra steps are required controls; the avoidable ones are correction loops, status chasing and manual searches.

Work that needs attention

Quality AssuranceDocumentation correction loops: 27 records/week × 2.4 loops × 25 min; excludes the first full review27h
Quality AssuranceRelease tracker rebuilt twice a week from SAP, LIMS and eQMS exports, plus reconciliation of copies7.5h
Quality AssuranceDeviation write-ups: 38/month × 2 h searching past cases and drafting = 76 h/month; 76 × 12 ÷ 52 = 17.5 h/week17.5h
Quality SystemsChange control impact search: 22/month × 1.5 h reading agreements and document lists = 33 h/month; 33 × 12 ÷ 52 = 7.6 h/week7.6h
Client ServicesClient document requests: ~55/week × 15 min locating approved versions and assembling packs13.8h
Supplier QualitySupplier file follow-up: expiry checks, reminders and register updates for 240 suppliers11h
Production + SupplyStatus questions to QA about batch release: ~60/week × 5 min5h
All35 quality agreements with client-specific notification and release clauses, held only as PDFsongoing
89.4 person-hours/week across 7 quantified rows; 1 unquantified risk89.4 h
Key Insight: Deviation and change control rows are converted from monthly to weekly hours. The correction row counts only the loops between QA and production, separate from the first full review, which stays as it is. Rows are scoped to avoid double counting, and required GMP review time is excluded from what can be released.

Risk Register

Single Point of FailureCritical
Three certifying pharmacists
Every batch goes through Anne-Sophie and two delegated pharmacists. One absence at month end adds days to the queue. Certification stays with them in every scenario.
GMP ComplianceCritical
Deviation aging
41% of deviations close after 30 days. Aging is among the first indicators an inspector reviews, and open deviations block certification.
Client ObligationsHigh
Late change notifications
Two client notifications went out late in the last 12 months, both found in client audits. Notification clauses differ across 35 quality agreements.
ValidationHigh
Uncontrolled tools near GxP data
Excel trackers already shape release planning. Any new tool must be classified first, then validated under Annex 11 before it supports a GxP decision.
Working-capital timingHigh
€3.1M awaiting certification
68 batches at about €45K each wait for release and invoicing. This is cash timing, distinct from lost revenue.
Data IntegrityHigh
Late corrections on paper records
Entries corrected days after the event weaken contemporaneous recording. Inspectors read correction patterns closely.
Supplier QualityMedium
37 supplier files expired
At least one expired document in 37 of 240 supplier files. Requalification is tracked in a personal Excel register.
Key-Person DependencyMedium
Valérie Hamon, client knowledge
Knows each client's document expectations and portal habits. Requests slow down whenever she is away.
Next Chapter
Implementation plan

Strategy Session · 30 min

A real engagement is scoped in the Strategy Session and may begin with a War Map or a bounded Feasibility Sprint.

Request a Strategy Session