BRN Production Tracker.
A manufacturing execution system connecting floor input, live production monitoring and scheduled reporting.
A connected production workflow.
- Previous process
- Output and defects were recorded on paper, then consolidated by hand at the end of a shift.
- Implemented workflow
- Shared floor input, live monitoring for supervisors and scheduled reports keep the production records connected.
- Current stage
- Internal implementation. Operational adoption and production-volume figures are not published.

PRODUCT PREVIEW
Business system
Line operators (tablet input), production supervisors (live dashboard + reporting), factory TV displays for line-level monitoring, and admin staff managing brands, orders, and line accounts.
Internal
01 / The product
BRN Production Tracker connects line-level output and defect records with a shared supervisor dashboard. Operators enter production data from the floor, while live displays and scheduled reports bring the same records into daily review.
Multi-line contract manufacturing with several orders in parallel. Pace-to-target visibility and consistent defect reporting help teams review production against shipment schedules.
The problem
Line output and defect data were recorded on paper and consolidated by hand at end of shift, so supervisors had no real-time visibility into which lines were on pace, and daily/monthly reports took manual compilation instead of being generated automatically.
02 / How it works
- 01Operator setup (brand → order → operator name → target)
- 02Real-time OK/defect entry → optimistic sync (online) or IndexedDB queue (offline)
- 03Live display refresh via Supabase Realtime
- 04Supervisor dashboard aggregation
- 05Automated daily Excel report by email
Key features
- Per-line tablet input with offline-first sync (IndexedDB) and idempotent writes
- Live TV display per line: hourly pace, cumulative output, order progress, automatic break-time overlay
- Supervisor dashboard: all-line pace status, reject-rate heatmap, daily/monthly Excel export
- Manual reconciliation against system-recorded output, with reconciliation records and adjustment traceability
- AI-assisted Excel PO import supporting multiple brand-specific spreadsheet formats
- Role-based access: per-line operator login, PIN-protected displays and dashboard, admin auth
- Scheduled automated email reporting with delivery logs
03 / Development
Development & AI
The Excel PO importer uses Claude through OpenRouter for chunked extraction of brand-specific spreadsheet formats, with a maintained style and colour catalogue as a matching reference. Production counts and reporting remain application logic.
Engineering considerations
Keeping the live TV display perfectly in sync with floor input in real time without race conditions, using a broadcast-first model with a database fallback if a broadcast is missed. Also building an import pipeline flexible enough to handle several brands' inconsistent PO spreadsheet formats without manual re-templating each time.
Technology
04 / Current stage
Built for a team’s internal operations; not offered as a public app. The case study explains its scope and limits.
An internal production-tracking implementation with floor input, live monitoring, reconciliation and reporting. The system provides an integration point for the broader SIMS workflow. Operational adoption and production-volume figures are not published.
BRN Production Tracker
Manufacturing execution / 2026Product views
Need a workflow like this?
Share how your team works today and what needs to connect. We can discuss a custom web app, business system or automation shaped around that process.