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.
What can we produce?
ProblemWith the materials on hand, how many units of which product can we make today?
SolutionThe board shows, for each product, how many materials are short at the target quantity and the maximum units possible with stock on hand, taking free stock, quantities reserved for other jobs, approved alternatives and expiry into account. Products added to a basket share materials in order, and work orders are opened from there.
What should we buy?
ProblemThe purchasing plan under-counted large pack sizes, mixed up kilograms and grams, and ignored alternatives and orders already on the way.
SolutionOpen work orders, open order remainders and target stock are combined in one calculation. Units are converted, spare stock of alternatives and incoming purchase orders are deducted, and quantities are rounded up to the supplier’s minimum. A draft purchase order is prepared per supplier; postponed items keep their reason and date.
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.
Hair colour: base batch and shade difference
ProblemKeeping a full formula for every shade means carrying each change in the base into every shade by hand.
SolutionOne shared base formula, plus only the pigment difference per shade. The colours view shows the most kilograms possible per base with stock on hand, which shades are short and a suggested quantity. One work order per base; batches below the minimum size are stopped on the server.