Check ingredient moisture before reconciling food-process water
A food processor receives a batch record, two ingredient moisture reports and a finished-product result. One percentage has been copied without its basis. The resulting water account disagrees with the completed production records, even though all the ingredient weights are correct. Resolve the meaning of that field before looking for a physical loss.
This guide is for reporting coordinators working with production, quality and utilities record owners. Its fictional case separates moisture arriving in ingredients, water actually dosed at the plant and the water measured in finished material. The outcome is a documented correction and a bounded handover, without changing a formulation or an operating procedure.
Choose the records that belong to the batch
The invented batch P44 was completed on 12 June 2026. Its selected account begins when ingredients A17 and B09 are issued and ends when the finished material is weighed. Every mass is net of packaging and uses kilograms. There is no opening or closing work in progress, rework, other ingredient, solids loss or unlisted flow. An independently supported evaporation record is supplied; it is not a balancing plug.
For this teaching exercise, the authorised specialist has confirmed that each moisture result represents the named material at the stated measurement stage, uses a suitable method and can be applied to its linked mass. Quantities are exact inputs for arithmetic. Real records require their own review of sample coverage, method, timing and uncertainty; this guide gives no sampling or testing instructions.
Keep the issued-material weights, moisture-report headers, completed dosing entry and finished-output record together. Link them by batch and material references rather than matching similar file names. Retain the effective recipe version as context, while preserving actual additions in their own fields. Only the authorised owner should supply or interpret confidential production records.
Read the percentage with its stated basis
FAO’s moisture-basis explanation distinguishes water relative to total moist mass from water relative to dry matter. These invented records apply that established distinction.
A17: 600 kg issued; MA reports 50% wet-basis moisture. Water = 300 kg; dry matter = 300 kg.
B09: 400 kg issued; MB reports 60% dry-basis moisture, meaning 0.60 kg water per kilogram dry matter.
B09: dry matter = 400 ÷ 1.60 = 250 kg; water = 250 × 0.60 = 150 kg.
Treating MB as wet-basis moisture gives 240 kg water, overstating it by 90 kg and understating dry matter equally.
The intake weight has not changed. Correct the copied basis and derived fields, keeping MB and the previous calculation identifiable. Do not revise a supplier’s original report or relabel the excess as a spill. The issue is the reporting worksheet’s interpretation, under the explicit measurement assumptions above.
Connect the ingredient account to the recorded addition
Completed dosing entry D44 records 200 kg of water added to P44. The ingredients carry 450 kg water and 550 kg dry matter. After D44, input totals 1,200 kg, including 650 kg water. These totals describe this batch account, not a facility reporting metric.
F44: 1,100 kg finished material; 50% wet-basis moisture gives 550 kg water and 550 kg dry matter.
The separately supported evaporation entry E44 is 100 kg water. Total mass closes at 1,200 = 1,100 + 100. Water closes at 650 = 550 + 100; dry matter is unchanged. These checks agree under the stated assumptions; they do not validate a real laboratory method or prove that a factory has no losses.
Preserve the executed version and the actual entry
The completed batch record identifies recipe R7. For this invented batch size, R7’s planned addition is 190 kg. A later R8 planning sheet lists 220 kg, but its effective date is 20 June. The P44 entry D44 remains 200 kg. These are documentary facts supplied by the scenario, not directions for making a food product.
The actual-versus-R7 difference is 200 − 190 = 10 kg. Comparing D44 with R8 instead would show 200 − 220 = −20 kg and answer the wrong version question. Replacing D44 with either planned value would also change the physical account without evidence that the recorded addition changed.
Carry the 10 kg difference to the authorised production owner with the executed version and the original entry. This exercise makes no judgment about acceptability, cause, product disposition or a permitted tolerance. Do not adjust the plant, issue a revised recipe or infer a quality failure from a reporting comparison. Record the owner’s explanation separately when available.
Keep the batch figures beside the plant supply record
A separate record M12 measures 2,000 kg of incoming supply water for the selected plant area on 12 June. Its documented coverage includes D44 and the area’s other uses. A linked subrecord identifies D44’s 200 kg inside M12. Adding the dosing entry to the incoming supply would count that addition twice.
The remaining 1,800 kg is outside D44’s subrecord; its destinations are not established here. Existing cleaning, washing, utility and relevant storage records would help explain it. The batch worksheet cannot allocate that remainder merely because a list of water-using activities exists. Keep the whole 2,000 kg record intact and retain the unallocated portion.
The finished-material result cannot replace D44 or M12. P44 also received moisture inside A17 and B09, outside M12’s measured supply route, and has a separately recorded departure. No upstream crop irrigation, supplier water footprint or assumed density conversion enters this mass account. It establishes no litre-per-product ratio or water-saving result.
GRI 303 includes produced water among withdrawal sources; its glossary covers water entering through extraction, processing or use of raw materials that the organisation must manage. Therefore, being outside M12 does not establish exclusion from a formal withdrawal disclosure. The reporting owner must assess the applicable boundary and method separately.
Leave a missing header unresolved
If only the number 60 survives in an export, obtain MB’s original header or the issuer’s documented clarification before selecting a calculation. Keep B09’s 400 kg weight and its batch link as supported records. Leave the composition result pending. Agreement with the finished-output total is not permission to choose whichever interpretation makes the spreadsheet close.
Likewise, do not extend MA to another ingredient lot or use F44 for material weighed before a different process stage. Ask the quality owner which existing report covers the selected quantity. If it cannot be established, narrow the result to the supported records and identify what remains unavailable. Do not manufacture a representative value from an unrelated certificate.
Hand over the correction and the open decision
The review pack should contain P44, the A17 and B09 issue entries, MA and MB with their headers, D44, F44, E44 and M12’s coverage note. Include the executed R7 reference and the later R8 effective date. Show the corrected composition calculation beside its previous version, with the reason for change and the owner who checked the source interpretation.
The reviewer should be able to reproduce the batch account and identify the separate 10 kg planning difference. Keep any unanswered production explanation open even when the mass check closes. A signed reporting worksheet does not authorise a food-safety decision, recipe change, water reuse, equipment adjustment or discharge decision.
Source reference
FAO, Farm structures in tropical climates, 1988, chapter 9, Moisture Content.
GRI 303: Water and Effluents 2018, Disclosure 303-3 and glossary, produced water.
To discuss preparing a food-processing records handover, contact Nitium Advisory with a non-confidential outline of the evidence and unresolved questions.
Primary sources checked 14 October 2026. All materials, records and quantities are fictional. This is reporting-preparation guidance, not a food recipe, operating procedure, safety assessment, legal opinion or independent assurance.
Comments