Versions in file names
The valid recipe is called “final_v3_new.xlsx”. Which version applied to Tuesday's batch is guesswork.
Industries Batch and formulation
When a recipe is more than a list of ingredients.
Wherever material is mixed to a recipe, the same questions come up: which version applied to this batch, what was actually weighed in, and what is the stock afterwards? I built a system for this in the glass industry. Its building blocks carry over to your formulations.
Typical situations
When a conversation makes sense.
Weighing without feedback
The mixing order goes to the scale on paper. What was actually weighed in comes back late or not at all.
Consumption and stock drift apart
Stock levels are updated by hand. At month end the inventory count does not match calculated consumption.
Cost only after the fact
What a batch cost is worked out later in a separate sheet, with whatever prices were at hand.
Building blocks
What I build for it
Recipes with versions
Every change creates a new version with date and reason. Posted batches keep the version they were made with.
Mixing order and batch log
The order to the scale is generated from the valid version. Posting it deducts consumption from stock straight away.
Calculations on the recipe
Key figures, batch size and cost are calculated from the recipe version and stay tied to it.
Corrections with a record
Wrong postings are cancelled or reversed. The original transaction stays visible.
What already runs
Built for the glass industry: W-Make Batch.
Features from W-Make Batch. Demo access is available on request.
See details →- Recipes with versions and raw material master data
- Create and post batch sheets, automatic silo deduction
- Cancellation and reconciliation instead of deletion
- Cost and key figures tied to the recipe version
State of references
I have no public references outside the glass industry in this area yet. In the first call we check how far the existing domain core carries over to your formulations.
Other industries
First call · 30 minutes · free
Tell me where your process gets stuck.
Describe in a few sentences where things get stuck today. You get a reply and an honest assessment within two working days.
Discuss a process in this industry