A customer reorders a custom color, but the prior batch record shows three corrections after the starting formula missed the target. Which numbers should production use now?
Repeating the untouched starting formula may repeat the same correction work. Copying only the final totals can hide why the changes were made, which materials changed, and how the color was judged. A reliable custom paint color reorder begins by reconciling the approved batch history into a proposed final formula, then checking whether that formula is ready to become a controlled revision.
The goal is not to erase adjustments. It is to turn a successful, documented result into a clearer starting point for the next run while preserving the evidence behind it.
Start with the approved prior batch
Do not begin with the newest spreadsheet, a color name, or an operator’s memory. Identify the exact prior batch the customer accepted. Confirm its batch ID, customer or product reference, formula version, batch size, material lots, final approval, and the physical or measured sample used for comparison.
“Approved” needs context. Record the dated drawdown, spray-out panel, coated part, retained sample, or instrument target plus the application and viewing conditions. A final paint formula is useful only when the next team can judge the result by the same method.
If the prior batch lacks formal approval, resolve the acceptance record before building the reorder around it.
Reconcile the starting formula with every adjustment
Create a worksheet with one row for each colorant or pigment. Show:
- the original target quantity;
- every added or removed amount in sequence;
- the reason for each custom color batch adjustment;
- the mix and test step that followed;
- the final quantity in the approved batch; and
- the material identity and lot used.
Keep the events visible. Do not replace “240 grams plus 6 grams” with “246 grams” and discard the path. These custom color batch adjustments remain part of the source history even when the total becomes a proposed target.
Use one unit of measure throughout the reconciliation. Check that additions, returns, samples, spills, and waste are not being confused with pigment that remained in the batch. The colorant total must be mathematically complete before anyone draws a new pigment ratio from it.
Worked example: turn three corrections into one final formula
Suppose the approved 20-kilogram batch started with:
- 240 grams white colorant;
- 36 grams yellow colorant; and
- 12 grams black colorant.
The first drawdown was too dark, so the operator added 6 grams of white. The second comparison was still too cool, so 2 grams of yellow was added. The final check needed 1.5 grams of black before the named reviewer approved the result.
The reconciliation is:
| Colorant | Starting target | Adjustments | Reconciled final amount |
|---|---|---|---|
| White | 240 g | +6 g | 246 g |
| Yellow | 36 g | +2 g | 38 g |
| Black | 12 g | +1.5 g | 13.5 g |
| Total | 288 g | +9.5 g | 297.5 g |
Those final amounts are a better candidate for the next starting formula than the untouched 288-gram package. They are not proof that the next batch will pass without review. The previous correction may have responded to a particular pigment lot, base lot, mixer, temperature, or measurement issue.
Preserve the original targets and adjustments in batch history and the reconciled 246 g, 38 g, and 13.5 g quantities in the proposed revision.
Decide what belongs in a new master formula
One successful corrected batch does not automatically authorize a new master. Review why each correction was needed.
A lasting revision may be reasonable when records are complete, materials and process are representative, the arithmetic reconciles, the test method is controlled, and an authorized person reviews the change. Keep a one-run note when a correction addressed a temporary lot difference, incorrect starting weight, or equipment problem.
Give any approved revision a new version number and effective date. Record its source batch, reason for change, reviewer, and the prior version it replaces. Older production records must continue to point to the formula versions they actually used.
The guide to clear custom-color formula notes explains the broader record set around pigments, actual quantities, adjustments, and approvals.
Recheck scale, materials, and test conditions
Before scaling the reconciled formula to the reorder quantity, compare the conditions that can change the result:
- base product and base lot;
- pigment or colorant supplier, item, and lot;
- scale resolution and rounding method;
- mixer, vessel, speed, time, and batch geometry;
- substrate, application method, film thickness, and cure time; and
- approved sample and viewing or instrument conditions.
Pigment ratios help calculate a starting point; they do not guarantee batch consistency. If 20 kilograms becomes 50, scale from the reconciled amounts, retain appropriate precision, and document targets and actual additions.
If another trained person will make the reorder, run the custom paint formula handoff test before a high-value deadline depends on the record.
Use a preflight before committing the repeat order
A repeat-order preflight should answer six questions:
- Which approved prior batch is the source?
- Do all starting quantities and adjustments reconcile?
- Has the proposed final formula been reviewed and versioned?
- Are the required material lots, equipment, and measurement tools available?
- Can the team reproduce the same test and approval method?
- Who can approve the first sample and authorize full production?
If any answer is unclear, expose it before promising quantity and delivery. Rebuilding the formula during production adds labor, test cycles, material use, and schedule risk that the quote may not cover.
Preserve both the source history and approved revision
The new formula should point back to the approved source batch. The new production run should point to the new formula version. That creates a clean record chain without rewriting either event.
If the reorder needs another correction, capture it as a new batch event. Do not silently change the proposed formula totals. Review the new evidence after the run, then decide whether another controlled revision is warranted.
For a field-by-field way to connect pigment lots, formula versions, batches, quality decisions, and finished containers, use the ink and coatings record-flow map.
Kerno can help connect formula versions, material lots, production records, costing, and quality checks. In any system, preserve what happened, approve what should happen next, and keep the records connected.
Practical takeaway
For one real custom paint color reorder, identify the approved source batch and reconcile every colorant from the original target through each correction to the final approved amount. Confirm the arithmetic, material identity, test method, and reason for each change.
Then decide whether the result supports a controlled master formula or a one-run note. Version the decision, run a preflight, and preserve the source history. The second order should start from evidence.
Should production use the original formula or the adjusted batch record?
Use the approved batch history to reconcile a proposed final formula, then follow the business’s review and version-control process. Do not blindly repeat the original targets or treat unreviewed final totals as a new master.
Should final pigment amounts be converted to percentages?
Percentages can help compare and scale formulas, but keep the actual approved quantities, batch size, units, and adjustment history. Record the percentage basis clearly.
What if the pigment supplier or lot changed before the reorder?
Treat the change as a review point. Confirm identity and suitability, prepare a controlled sample, and compare it with the same approved reference before committing the full run.
Does one successful adjusted batch automatically become the new master formula?
No. Determine why the corrections were needed, confirm complete records and repeatable conditions, and require authorized review before issuing a new formula version.
