Potency-based consumption: keep active quantity separate from the stock issue

A formula can require a constant amount of an active constituent while the physical quantity of an ingredient changes from lot to lot. If the stock ledger records the active amount instead of the material actually issued, inventory can be wrong even though the formulation calculation is sound. Preserve both quantities and the relationship between them.

Microsoft's Dynamics 365 batch-balancing documentation describes calculating ingredient quantities from the active-ingredient concentration of selected batches. It distinguishes active, compensating and filler ingredients. Those software concepts support the recordkeeping discussion here; they do not establish that a particular chemical, food or other formulation is safe or technically acceptable.

The qualified production and quality owners must approve the formula, concentration basis, allowable ingredients and released lots. Finance should receive those decisions as inputs. An accountant or bookkeeper should not change a recipe or authorize use of a questionable lot to make the material quantities reconcile.

Retain the batch or lot identifier, test reference, result date, concentration value and measurement basis. A percentage by mass is different from a percentage by volume or an activity measure expressed in other units. The formula and result need a technically supported conversion before they can share a calculation.

For the simple examples below, all concentrations are mass fractions on a consistent basis. A value of 40% means 0.40 kilograms of the specified active constituent per kilogram of the ingredient. This assumption avoids density and other formulation issues that would require additional specialist inputs.

Keep the product's planning or target concentration separate from the measured concentration for the selected lot. A default may be useful for estimating a future purchase, but it should not silently replace an available approved lot result. Record which value the actual production calculation used.

Check the identity link through receiving, testing, storage and picking. A correct certificate attached to the wrong internal lot can produce a plausible but unsupported issue quantity. Supplier lot numbers and internal batch numbers should have an explicit mapping when they differ.

Assume a hypothetical approved production batch requires 30 kilograms of an active constituent. A released ingredient lot contains 40% of that constituent by mass. The physical requirement is 30 divided by 0.40, or 75 kilograms of the ingredient. The check is 75 times 0.40, which returns the required 30 kilograms.

If an otherwise approved alternative lot is 50% active, the same requirement uses 60 physical kilograms. The 15-kilogram difference reflects the concentration basis. It is not automatically a process saving, a shortage or a quantity that should be removed from the receipt record.

In a deliberately simplified 200-kilogram formulation containing only this ingredient and an approved neutral filler, the first case would require 125 kilograms of filler and the second 140 kilograms. Both total 200 kilograms. Real formulas can contain other ingredients and compensating relationships, which must come from the approved formulation rather than this example.

Show the active target, selected lot result, calculated physical quantity and approved rounding separately. If equipment can dispense only to a particular resolution, the qualified owner must assess the resulting formulation effect. Finance should preserve that approved quantity rather than imposing currency-style rounding on a technical measure.

A production order may use more than one eligible lot of the same ingredient. Calculate the contribution of each lot from its own quantity and approved concentration. An unweighted average percentage can give the wrong answer when the physical quantities differ.

For a hypothetical issue, 50 kilograms from a 40% lot contribute 20 kilograms of active constituent. Another 20 kilograms from a 50% lot contribute ten kilograms. Together, 70 physical kilograms provide the required 30 active kilograms. The effective concentration is approximately 42.86%, calculated as 30 divided by 70.

The simple average of 40% and 50% is 45%. Applying that to the 70-kilogram physical issue would claim 31.5 active kilograms, overstating the supported amount by 1.5 kilograms. Keep lot-level detail so a reviewer can reconstruct the contribution rather than relying on a blended percentage with no quantity weighting.

Check that the selected lots actually reached the production order. A warehouse substitution can invalidate the balancing calculation even when the total kilograms delivered remain unchanged. Route the substitution to the authorized technical process before updating the accounting explanation.

Inventory movements should preserve the material unit used by the stock record. In the first example, issuing 75 kilograms reduces physical inventory by 75 kilograms. Posting only the 30-kilogram active quantity would leave 45 kilograms in the ledger that are no longer physically present.

Reconcile opening quantity, receipts, physical issues, returns and closing quantity by lot. Keep the active-quantity calculation as linked information. A revaluation or analytical conversion should not create or remove physical stock merely because the concentration differs from the planning target.

Record staged material and unused returns separately from consumption. If 80 kilograms were delivered to the work area but five were returned unused, the physical consumption is 75 kilograms, subject to the full movement evidence. Do not treat both the staging transfer and the later consumption entry as two issues from company inventory.

For partially used containers, retain the approved measurement of what remains and its lot identity. A container-count estimate may not establish the actual kilograms available. Assign uncertain quantities to the appropriate count or measurement follow-up rather than solving them by changing the potency percentage.

At an illustrative carrying cost of $8 per physical kilogram, the 75-kilogram issue carries $600 under a simple constant-cost assumption. Dividing that amount by the 30 active kilograms gives $20 per active kilogram for analysis. The two unit costs describe different denominators and should be labeled accordingly.

That analytical ratio does not authorize a new inventory valuation policy. The accounting owner determines the treatment of purchase costs, production costs and variances. Provide the physical quantity, lot result and approved formulation so the owner can distinguish concentration effects from price differences and actual process losses.

Compare actual consumption with the lot-specific balanced requirement, not only the nominal formula. If the nominal estimate expected 60 kilograms at 50% and the approved selected lot required 75 at 40%, the extra 15 kilograms are explained by potency. Additional unexplained consumption beyond the balanced quantity is a separate investigation.

Keep finished-output testing and production yield evidence distinct. Delivering the planned active quantity to a batch does not prove that the finished product meets its specification or that all material became accepted output. Those conclusions require the relevant production and quality records.

If an approved concentration result changes, preserve the former value, replacement result, authorization and affected lots. Identify which batches were planned, released or already completed using the earlier result. Do not overwrite historical source data in a way that makes prior calculations appear to have used the new value.

The technical owner must decide the product and quality implications. Finance can then assess the resulting stock corrections, production-cost changes or other accounting effects. A spreadsheet recalculation alone cannot resolve whether material already manufactured remains acceptable.

Test an outsourced inventory or costing service with a single-lot case, a mixed-lot case and an unused return. The provider should reconcile both physical and active quantities while preserving the technical approval boundary. The accepted deliverable should explain every stock movement without confusing a concentration adjustment with material that was bought, moved or consumed.