Case study
A $20,000 production system that replaced a factory's paper logs
A 50-person adhesive tape manufacturer ran production reporting on paper. Workers now report pieces, cartons, and pallets per shift from the floor on a four-digit PIN, managers approve through a verification queue, and directors see the numbers without asking anyone for them.
- Result
- $20,000 contract
- Also
- 50-person facility
- Client
- SMART Adhesive Tape
- Year
- 2026
The problem
Paper logs meant the numbers existed but arrived late, incomplete, and impossible to audit. Nobody could answer what a shift had actually produced until someone had typed it up, and by then the day it described was already gone.
What we built
- Three access tiers with different session lengths. Workers get a 15-minute window to correct a report, after which it locks.
- Document numbers issued by the database itself and reset each year, so two shifts reporting at once can never get the same number or skip one.
- A verification queue where managers approve before anything counts as real.
- Four-digit PIN authentication, unique system-wide, with email addresses visible only to directors.
- Dashboards for the directors, with targets set against what the floor is actually producing over time.
The result
- Paper removed from the production reporting process.
- Numbers available the same shift rather than days later.
- An audit trail behind every figure, which paper never gave them.
React 19ViteSupabasePostgresTanStack QueryRecharts
Services used