Skip to content

Which version of the batch list is correct?

Coming up: stock by batch, with best-before date
Today

A spreadsheet for everything.

More explanation

Supplier batches in one file, production in another, expiry dates in a third. Each part may be correct, but the whole has to be pieced together every time.

Who knows which version is correct?
Quality managerKnows all the spreadsheets
Indispensable
ProductionWorks with last week's list
Outdated
PurchasingRetypes batches from the packing slip
Double work
Colleague covering an absenceCannot find the right version
Stuck
Follow-up works, but depends on one person
The impact

Everything depends on one person.

More explanation

Every change is retyped. With absence, growth or an extra standard, it starts to crack.

Record it once, by whoever does the work.
The solution

Record it once, by whoever does the work.

More explanation

Whoever receives the goods records batch and best-before date. Whoever produces gets batch and best-before date on the finished product from the system.

Stock is a batch with a date.
How it works

Stock is a batch with a date.

More explanation

For each stock line you see batch, best-before date and location, and you search directly by batch number.

Everyone reads the same stock.
The result

Everyone reads the same stock.

More explanation

Purchasing, production and quality look at the same movements. The knowledge is in the system, not in one person's head.

Less retyping. One truth for the shop floor.

Do you recognise this in your organisation?

Yes, definitelyA littleNot for us
See one stock list with batch and best-before date in a demo
Other stories
Which products contain that batch of couverture? ›Where is the incoming inspection for that delivery? ›Who calculates the best-before date on the box? ›
‹ Previous1 / 5Next ›

In short

The problem
A separate spreadsheet per supplier, per batch and per check. Only your quality manager knows which version is correct.
The solution
Goods-in with batch and best-before date, production and stock by batch are in one system. Everyone reads the same stock.
Features used
Goods-in, production and stock by batch.
Who it is for
Food companies that work with Excel lists today.
In the demo
The route from purchasing through goods-in and production to stock by batch.
Background to this storyWhat food manufacturers tell us, and what you will see of it in the demo.
"A separate spreadsheet per supplier, per batch and per check. Which version is correct, really only our quality manager knows."
IRPIn the process
Work step
Goods-in, production and stock
Needed
Batch and best-before date
Supplied by
Whoever receives and whoever produces
When
As part of the work itself
Next
Everyone reads the same stock by batch

Goods-in with batch and best-before date, production and stock by batch in one system, followed from purchasing to stock (demo environment).

Explore further
See the real screens →← Back to all challenges