Balance industrial process batches across output, by-product and loss

When a process plant blends, reacts, or distils a batch, the physical material leaving the vessel splits across multiple streams: primary packaged product, secondary by-products or recyclable wash heels, laboratory samples, filter cake residue, and vapour condensate. If the ERP batch ticket records only total raw materials charged and primary drums filled, any change in vessel heel retention, by-product recovery, or density conversion looks like a swing in reaction yield. Before automating batch completion or standard-cost variance postings, process and quality owners must define every approved output category in the master formula and reconcile measured weights across all discharge streams.

Why single-output batch tickets distort process manufacturing yield

Discrete assembly work orders count integer pieces, whereas industrial process batches—such as resins, coatings, lubricants, surfactants, and industrial salts—transform bulk liquids, powders, and slurries across vessels, filters, and filling lines. Three recurring data errors prevent standard ERP work orders from closing an accurate batch mass balance:

1. Missing formula output categories for co-products and recycle heels: In process ERPs such as Microsoft Dynamics 365 formula and co-product/by-product management, a master formula must explicitly declare primary output, co-products (which carry inventory value or re-use identity), and by-products or burden waste. When a formula lists only the primary product, operators either leave recoverable flush heels unrecorded on the plant floor or book them as ad-hoc inventory adjustments detached from the originating batch.
2. Mixing volumetric flowmeter readings with gravimetric drum weights: Charging monomer or solvent through a volumetric flowmeter in litres at 32 °C and weighing finished drums on a platform scale in kilograms without applying the specific gravity (kg/L) conversion creates phantom mass gains or losses on every batch.
3. Auto-plugging residual differences into evaporation or filter waste: Many ERP templates compute Waste = Total_Charge - Primary_Output automatically at batch closure. That formula guarantees a "balanced" ledger on paper while hiding leaking transfer valves, unrecorded drums, or uncalibrated load cells.

Under cross-sector transformation traceability principles such as the GS1 Global Traceability Standard, a batch transformation record is complete only when each input lot and quantity reconciles against measured output lots, retained recycle streams, and explicitly bounded measurement uncertainty.

Designing a multi-output batch mass-balance model

This article describes the data, unit-conversion, and governance workflow for batch mass reconciliation; it does not provide chemical reaction instructions, hazardous operating parameters, or environmental discharge authorisations. To make batch yield reporting auditable, configure each master formula version with five distinct mass-balance buckets:

• Input Stream (M_in): Total mass (kg) of all raw materials, catalysts, water, and recycled heel charged to the vessel, derived either directly from calibrated vessel load cells / weigh scales or from volumetric flowmeters multiplied by measured batch density (Volume_L × Density_kg_per_L).
• Output Class 1 — Primary finished product (M_primary): Net mass (kg) of approved primary output filled into drums, IBC totes, or bulk storage tanks.
• Output Class 2 — Recoverable by-product or recycle heel (M_recycle): Net mass (kg) of secondary marketable co-product, recovered solvent distillate, or line-flush heel held in a designated intermediate tank for re-use in a specified subsequent batch family.
• Output Class 3 — Controlled QC and retention samples (M_sample): Mass (kg) drawn for in-process testing, final release inspection, and archive retention samples.
• Output Class 4 — Measured process residue and abatement capture (M_waste_measured): Mass (kg) of weighed filter-press cake, knocked-out condenser water/distillate, and vessel scraping residue transferred to labelled waste containers.
• Unresolved Mass Balance Delta (M_delta): M_delta = M_in − (M_primary + M_recycle + M_sample + M_waste_measured). Each formula version defines an illustrative configured mass-balance tolerance band (for example, ±0.50% of M_in based on combined load-cell and flowmeter uncertainty, subject to site engineering validation). Any batch whose |M_delta| exceeds that band is held in Pending_Mass_Balance_Review rather than auto-closed.

Reconcile multi-stream batch outputs before closing the batch record

Follow the workflow below, or open its complete text version.

Read the complete workflow as text

1. Convert all charged inputs to a common gravimetric kg basis → Record primary packaged product and QC sample weights
2. Record primary packaged product and QC sample weights → Weigh recoverable wash heel, co-product and filter or conde...
3. Weigh recoverable wash heel, co-product and filter or conde... → Calculate unresolved mass delta against configured meter to...
4. Calculate unresolved mass delta against configured meter to... → Close batch within tolerance or escalate variance for engin...

Worked example: 2,500 kg acrylic dispersion batch (BATCH-ACR-2026-042)

Consider an illustrative non-hazardous teaching batch (BATCH-ACR-2026-042) producing a water-based industrial acrylic polymer dispersion under approved formula FRM-ACR-108-v4. All weights, densities, and tolerances below are synthetic data constructed to demonstrate multi-stream mass-balance reconciliation.

Charged inputs (M_in = 2,500.0 kg)

1. Deionised water charge (weigh tank WT-01): 1,150.0 kg.
2. Acrylic monomer pre-emulsion (charged via volumetric meter FM-04): 1,250.0 litres measured at 25 °C with verified specific gravity 0.960 kg/L = 1,200.0 kg. (Note: Before unit normalisation, a naive spreadsheet summed 1,250.0 L directly as 1,250.0 kg, overstating total batch input by 50.0 kg.)
3. Initiator, surfactant, and neutraliser solution (platform scale SC-02): 150.0 kg.

• Total normalised gravimetric input (M_in): 1,150.0 kg + 1,200.0 kg + 150.0 kg = 2,500.0 kg.

Discharged outputs and measured residues

At batch discharge through a bag filter into 200.0 kg net drums, the production operator records the following physical streams:

1. Primary finished product (M_primary): 10 full drums × 200.0 kg + 1 partial drum × 180.0 kg = 2,180.0 kg (87.20% of M_in).
2. Recoverable line-flush and vessel wash heel (M_recycle): 165.0 kg of dilute acrylic wash water pumped into Dedicated Hold Tank HT-WASH-03 (Lot WSH-042, assayed at 18.0% solids for metered re-use in the next dark-tint dispersion batch).
3. In-process and final QC retention samples (M_sample): 10 sample bottles × 0.50 kg = 5.0 kg logged in LIMS (SMP-ACR-042).
4. Measured process residue (M_waste_measured):
   • Condenser overhead distillate collected in receiver pot RP-02: 64.0 kg.
   • Bag-filter coagulum and vessel wall scrapings weighed into Drum WST-042: 28.0 kg.
   • Total measured waste: 64.0 kg + 28.0 kg = 92.0 kg (3.68% of M_in).

Mass-balance reconciliation table (BATCH-ACR-2026-042)

Tracing the residual variance (58.0 kg → 18.0 kg)

1. When the operator first clicks Compute Batch Balance, M_delta equals 2,500.0 kg − 2,442.0 kg = 58.0 kg (2.32%), which exceeds the illustrative configured tolerance band of ±0.50% (±12.5 kg). The system blocks automatic batch closure.
2. Checking the discharge manifold reveals 40.0 kg of finished resin still sitting in the jacketed filter-feed header between the reactor bottom valve and the drum-filling lance. Draining that header via the air-purge line into the partial 11th drum increases M_primary from 2,180.0 kg to 2,220.0 kg (11 full drums × 200.0 kg + 20.0 kg QC/retain drum), raising total accounted mass to 2,220.0 + 165.0 + 5.0 + 92.0 = 2,482.0 kg.
3. The remaining 2,500.0 kg − 2,482.0 kg = 18.0 kg (0.72%) deficit isstill above 12.5 kg (0.50%). Process engineering inspects monomer meter FM-04 and confirms an 18.0 kg positive zero-drift offset since its last strainer cleaning. The 18.0 kg variance is recorded explicitly as Meter_Drift_Variance linked to calibration work order CAL-FM04-2026, rather than falsifying filter-cake waste.

Roles, approval boundaries, and exception controls

Acceptance tests for process batch mass-balance workflows

Summary and next actions

Process batch yield reports become decision-worthy only when every physical stream—primary product, recoverable wash heel, lab samples, and weighed process residue—is measured on a common gravimetric basis and compared against an explicit instrument tolerance band. Disabling automatic waste-plug formulas exposes line holdup and flowmeter drift before they corrupt inventory and waste records.

1. Audit active master formulas to ensure every recoverable co-product, wash heel, sample stream, and measured waste output is defined as an explicit output line rather than left off the batch ticket.
2. Enforce mandatory density (kg/L) conversion on all volumetric flowmeter charges and discharges so batch mass balance is calculated strictly in kilograms.
3. Replace automatic Waste = Input − Output plug rules with a weighed waste entry and an explicit Unresolved_Mass_Delta field gated by a site-validated tolerance band.
4. Require process engineering and quality review before closing any batch whose unresolved mass delta exceeds the configured instrument tolerance band.