Confidential formulas
ProblemThe formula is the factory’s most valuable knowledge. It should not sit in front of everyone on the production floor.
SolutionA formula opens only for the operator assigned to the job, scaled to that job’s quantity. Ingredients marked confidential are not named to people without permission. No work order can be opened with a formula the chemist has not approved.
Several pack sizes from one batch
ProblemDifferent pack sizes are filled from the same mix. When each size counted all the stock as its own, the numbers ballooned.
SolutionOne card per product: the shared batch weight on top, units per size below. A single work order carries several sizes, and mass comes from each size’s fill weight. If a fill weight does not fit the volume, the system asks before saving.
Lot chain
ProblemA complaint comes in about a batch. Which raw material lot, from which supplier, went into it?
SolutionOne screen leads from the finished lot to the work order, the formula version and the consumed raw material lots. Lots are recorded when a task is accepted, so the view shows recorded links, not assumptions.
FEFO: first expiry, first out
ProblemLots close to expiry stayed on the shelf while newer deliveries were used first.
SolutionConsumption uses the lot that expires first. Expired lots do not count as free stock, and lots nearing expiry trigger a notification every morning.
Quarantine gate
ProblemNobody could tell what was in quarantine; the screen only offered a “release” button.
SolutionThe quarantine queue shows product, shade, lot, quantity, the work order it came from, how many days it has waited and the issue. Goods that have not been released never enter saleable stock.
Duplicate work order gate
ProblemA second work order was opened for the same product on the same order, reserving materials twice.
SolutionWhile an open work order exists for the same order, product and size, a new one cannot be opened. If it is intentional, explicit confirmation is required and recorded in the work order’s notes.