← SYSTEMS & AUTOMATIONManufacturing execution / Internal / 2026

BRN Production Tracker.

A manufacturing execution system connecting floor input, live production monitoring and scheduled reporting.

BRN Production Tracker product preview

PRODUCT PREVIEW

TYPE

Business system

BUILT FOR

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.

CURRENT STAGE

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

  1. 01Operator setup (brand → order → operator name → target)
  2. 02Real-time OK/defect entry → optimistic sync (online) or IndexedDB queue (offline)
  3. 03Live display refresh via Supabase Realtime
  4. 04Supervisor dashboard aggregation
  5. 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

Next.js 14 (App Router)React 18JavaScriptTailwind CSS 3Supabase (self-hosted PostgreSQL & Realtime)IndexedDB (offline queue)RechartsExcelJS & SheetJSClaude via OpenRouter (PO import)NodemailerDocker & Nginx

04 / Current stage

Internal

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.

Explore systems & automation
LET’S MAKE SOMETHING

A good problem
is a good start.

A product idea. A workflow. A photography or design brief.
Bring the context. We’ll start there.