Client work · Factory records
A factory that ran on twelve spreadsheets now runs on one system.
| Batch | Weighed (kg) | Formula | Carried to Reg 07 | Note | |
|---|---|---|---|---|---|
| 4 | B-1041 | 1 240 | =C4*0.97 | ? | copied |
| 5 | B-1042 | 980 | =C5*0.97 | 1 202 | check |
| 6 | B-1043 | 1 115 | =C6*0.97 | ||
| 7 | B-1044 | 1 060 | =C7*0.97 | 1 031 | copied |
| 8 | B-1045 | =C8*0.97 | missing | ||
| 9 | B-1046 | 1 302 | =C9*0.97 | ? |
- B-1041Approved · shift lead
- B-1042Approved · production manager
- B-1043Waiting for approval
- B-1044Approved · shift lead
Illustrations with invented values — not the client’s software or data.
The problem
Production was tracked across twelve linked Excel workbooks. Weighing records required by the tax authority were filled in by hand, batch after batch, and month-end meant copying numbers between tabs.
What we built
One production system that follows each batch through all six stages of their process, with fifteen built-in reports in two languages. Every stock movement waits for a named person to approve it.
What changed
Twelve workbooks kept in sync by handOne shared system for the whole processStock figures anyone could overwriteEvery stock movement approved by a named personInspection meant opening someone’s spreadsheetA one-click snapshot ready for the inspector
People approve every change to stock before it counts.
Delivered in about eleven weeks. These are shipped capabilities; time or cost savings were not measured.
The starting point
The factory ran on colour-coded Excel workbooks: yellow cells for hand-typed facts, white cells for formulas only their author fully understood.
Every tax-mandatory weighing protocol was filled in by hand, batch after batch. Month-end meant copying numbers between tabs and hoping nothing drifted.
The tax authority can ask for the current state at any moment. The honest answer was a spreadsheet open on someone's laptop.
The delivery record
What we found, what we built, and where an accountable person stays in control.
- What we found
Twelve linked Excel registers and hand-filled weighing protocols carrying six production stages
observed- What we built
A ledger-backed production system: six stages, 51 screens, 15 reports, in two languages
working- Human control
Every stock-affecting movement waits for a named approval before it touches a balance
human- Inspection
A one-click snapshot of current state, built for the moment an inspector asks
working- Delivery
Built and handed over in about eleven weeks, with an operations manual and an acceptance script
delivered- Measured savings
Not published. We only publish numbers someone has actually measured.
policy
Client and employer names, identifying details and proprietary screens are withheld. The illustrations above use invented values. This larger engagement is separate from the five-day free proof.
Read the expert assessments story →
Your project doesn’t need to start this big.
We start with one workflow and a working proof in five days — $0 for selected workflows, no commitment.