Batch Yield and Material Reconciliation Calculator
Yield at every stage and every printed piece accounted for, against your limits.
Try before you buy.
- Free preview: the method, the limits that apply and the verdict for your input; computed figures stay hidden until the pass.
- Locked until you unlock it: download, copy and print.
- Unlock: Premium pass, ₹799 for 30 days or ₹249 for 1 week, a one-time payment that never renews. Unlock: Premium pass, $19.99 for 30 days or $7.99 for 1 week, a one-time payment that never renews.
Ways to unlock shows how to get the full result.
Printing this result is locked in the free preview.
Yield and reconciliation report
Locked in the free preview. Opens the ways to unlock this result.
Locked in the free preview. Batch runs unlock with a pass.
Locked in the free preview. Query results unlock with a pass.
About the Batch Yield and Material Reconciliation Calculator
Works out the actual yield and the percentage of theoretical yield at every stage of a batch — granulation, blending, compression, coating, filling, packing — with the process loss and how much of it the samples and recorded rejects account for, and compares each yield with the minimum and maximum percentages of your master production record. It then reconciles every printed and packaging material: labels, cartons, leaflets and printed foil, with issued = used + damaged + returned + destroyed + specimens, and the quantity used against the packs finished.
Anything outside its limits is flagged as a discrepancy to investigate, the way 21 CFR Part 211 asks. Without a pass it shows a free preview: the method, the limits and every verdict, with the computed yields and reconciliations hidden; the figures, the PDF, the XLSX file, the printed copy and the copied text unlock with a Premium pass.
How to use it
- Enter each stage of the batch in its own unit, with its theoretical yield (what it would give with no loss) and its actual yield.
- Add the samples taken and the rejects or waste recorded at that stage, and the yield limits from the master production record.
- For each printed or packaging material, enter what was issued and where it went: used on the product, damaged, returned to stores, destroyed (coded excess) and kept as specimens.
- Add the difference allowed for each material, its quantity per finished pack and the number of finished packs, so the labelling used can be compared with the product finished.
- Read the verdict and the checks. Without a pass the report stays a free preview with its figures hidden; the PDF, XLSX, print and copy unlock with a Premium pass.
Examples
Theoretical 196,750 tablets · actual 194,200 · samples 450 · rejects 1,600 · limits 97.0–100.5%
Yield 98.70% (within) · process loss 2,550 tablets · 500 tablets unaccounted for (0.25%)
194,200 ÷ 196,750 × 100 = 98.70%; 196,750 − 194,200 − 450 − 1,600 = 500.
Theoretical 120.000 kg · actual 118.20 kg · samples 0.15 kg · sieve oversize 0.30 kg · limits 98.0–100.5%
Yield 98.50% (within) · loss 1.80 kg, of which 1.35 kg unaccounted for
Issued 25.00 kg · used 21.80 · set-up waste 0.95 · returned 2.10 · destroyed 0.10 · specimens 0.02 · limit ±0.5%
24.97 kg accounted for · 0.03 kg short (0.12%) · reconciled
Issued 2,000 · used 1,925 · damaged 5 · returned 50 · destroyed 10 · specimens 2 · limit ±0.1%
1,992 accounted for · 8 labels missing (0.40%) · investigate
Common uses
- Production officers completing the yield and reconciliation pages of a batch manufacturing or packaging record.
- Quality assurance reviewing a batch record before release, with the discrepancies to investigate listed.
- Packaging supervisors reconciling labels, cartons, leaflets and printed foil at the end of a packing run.
- Trend reviews of yields and losses across stages.
Theoretical yield, actual yield and their percentage
21 CFR Part 210, section 210.3(b), defines them: the theoretical yield is the quantity that would be produced at a phase of manufacture, processing or packing, based on the quantity of components used, with no loss or error; the actual yield is the quantity actually produced at that phase; and the percentage of theoretical yield is the ratio of the actual to the theoretical yield at the same phase, as a percentage.
- yield % = actual ÷ theoretical × 100
- process loss = theoretical − actual
- unaccounted loss = theoretical − (actual + samples + rejects), the part of the loss that no record explains
What the rules require
- Section 211.103: actual yields and percentages of theoretical yield are determined at the end of each appropriate phase of manufacturing, processing, packaging or holding, and the calculation is verified independently by a second person (or by one person when automated equipment did it).
- Section 211.186(b)(7): the master production record states the theoretical yield with the maximum and minimum percentages beyond which an investigation is required.
- Section 211.125(c): the quantities of labelling issued, used and returned are reconciled, and a difference between the drug product finished and the labelling issued outside narrow preset limits, based on historical operating data, is evaluated and investigated. Cut or roll labelling is exempt when electronic or electromechanical equipment examines 100% of it for correct labelling (section 211.122(g)(2)); a visual 100% check does not waive it.
- Section 211.125(d): all excess labelling bearing lot or control numbers is destroyed.
- Section 211.192: any unexplained discrepancy, including a yield outside the master record’s percentages, is thoroughly investigated, the investigation extended to other batches that may be affected, and recorded with its conclusions.
These are the United States rules; other regulators have equivalent requirements. Follow your own approved procedures.
Reconciling printed materials
Every printed piece issued for a batch must be accounted for: issued = used + damaged + returned + destroyed + specimens. A shortfall can mean labels left on the line, in another batch or in the bin; an excess usually means a counting or recording error. Set the difference allowed for each material from your own historical operating data, as section 211.125(c) asks, and compare the quantity used with the packs finished, so that a label missing from the product shows up too.
Limitations
- A calculation aid: the yield limits and reconciliation limits are those of your master production record, and the signed batch record remains the record.
- It does not set or justify limits; 21 CFR 211.125(c) expects narrow limits based on your historical operating data.
- Each stage is worked out on its own theoretical yield; enter the theoretical quantity of each stage as your master record defines it.
- It is not a validated computerised system for GMP records.
Privacy
On this device; its files download once
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot. Only the PDF and XLSX exports load their engines and fonts from this site the first time; your batch figures never leave this browser.
Frequently asked questions
What do I get without a pass?
Without a pass, Batch Yield and Material Reconciliation Calculator shows the method, the limits that apply and the verdict for your input; computed figures stay hidden until the pass. Until you unlock it, the result can’t be downloaded, copied or printed. A Premium or Ultimate pass, a one-time payment that never renews, unlocks the full result. The pricing page lists the passes and their prices.
What does the free preview show?
Your quantities, the limits and every verdict — within the limits, or investigate — with the checks in words. The computed figures (the yields, the losses, the quantities accounted for, the differences and the reconciliation percentages) show as “•••”; they, the PDF, the XLSX file, the printed copy and the copied text unlock with a Premium pass.
How do I calculate the percentage yield of a batch?
Divide the actual yield by the theoretical yield of the same stage and multiply by 100: 194,200 tablets from a theoretical 196,750 is 98.70%. Compare it with the minimum and maximum percentages in the master production record.
What is the difference between process loss and unaccounted loss?
Process loss is everything the stage did not deliver: theoretical − actual. Part of it is accounted for by samples taken and rejects or waste weighed and recorded; what remains is unaccounted for, and is the part an investigation looks at first.
Is reconciliation needed for roll labels?
Under 21 CFR 211.125(c), labelling reconciliation is waived for cut or roll labelling when a 100% examination for correct labelling is performed in accordance with 211.122(g)(2), that is, by appropriate electronic or electromechanical equipment; a visual 100% inspection of hand-applied labels does not waive it. The calculator still shows the difference and marks it as waived.