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.

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