Case study 07 — Live operations screen

Warehouse TV Dashboard

A warehouse floor needs one screen that answers who is working where, right now — readable from across the room, refreshing on its own, and never requiring anyone to touch it. Everything that changes that answer belongs somewhere else entirely.

Next.js
React
TypeScript
Firestore
ExcelJS

Warehouse floor dashboard showing sectors, staffing and active tasks

The problem

Team leads cannot see current staffing without walking the floor. Reassignment happens verbally and does not stick. Task state gets lost, and with it the employee history that reporting depends on — so producing a report means reconstructing the week from memory.

What we built

A public dashboard built for a wall-mounted screen, and a separate admin area for the people who change what it shows. The dashboard carries sector columns, live assignments, task cards and a ten-second refresh. The admin panel handles assignment, employees, completed tasks and export.

How it works

Presentation mode, built for a screen nobody touches
A dedicated full-screen sector view with large typography and clear colour coding, laid out for visibility and contrast on a wall-mounted display running around the clock. Sectors switch in seconds.
Employees and tasks in the same sector view
Who is working in a sector and what is pending there appear together rather than on separate screens, with high-priority tasks highlighted and their ownership named. The view refreshes itself every ten seconds.
Reassignment in seconds
The admin task assignment screen shows total employees, active assignments, departments and unassigned staff, and allows one-click rebalancing with live assignment totals — so a lead can move people without leaving a single control screen.
Completed work stays auditable
Every finished task keeps its timestamps, ownership and logged time entries, reviewable by department, with completion history showing when work started, when it finished and how long it took. Records can be reopened or permanently removed — deliberately, and by someone accountable.
Nine exports, not one
Current assignments, assignment history, employee directory, task register, completed tasks, task activity log, employee task history, a multi-sheet Excel workbook, a daily visual dashboard and a daily staffing summary — as CSV or XLSX, filterable by date range.
Every export is a leadership-ready workbook
Exports roll summary metrics, the daily operations trend, a department snapshot of staffing and workload, the current assignment board and task register highlights into one structured workbook — so reporting does not require anyone to touch the database.

In the product

Full-screen presentation mode showing a single sector — Readable from a distance, built for a wall-mounted screen.

Sector view combining assigned employees and active task cards — Employees and tasks in one sector-specific screen.

Admin task assignment screen with active assignment list — Allocate and rebalance from a single control screen.

Completed tasks view with timestamps, duration and reopen controls — Finished work keeps its timestamps and its owner.

Export panel offering nine download formats — Nine exports, CSV or XLSX, filterable by date range.

Generated operations workbook with summary metrics and department snapshot — Each export arrives as a structured workbook.

Outcome

The floor gets one live screen it can trust, managers get the controls and the history behind it, and reporting comes out as a workbook rather than a database query.

Have a system like this in mind?

Tell us the workflow you are trying to fix and we will tell you what it would take to build.

Start a conversation

How it works

Presentation mode, built for a screen nobody touches

A dedicated full-screen sector view with large typography and clear colour coding, laid out for visibility and contrast on a wall-mounted display running around the clock. Sectors switch in seconds.

Employees and tasks in the same sector view

Who is working in a sector and what is pending there appear together rather than on separate screens, with high-priority tasks highlighted and their ownership named. The view refreshes itself every ten seconds.

Reassignment in seconds

The admin task assignment screen shows total employees, active assignments, departments and unassigned staff, and allows one-click rebalancing with live assignment totals — so a lead can move people without leaving a single control screen.

Completed work stays auditable

Every finished task keeps its timestamps, ownership and logged time entries, reviewable by department, with completion history showing when work started, when it finished and how long it took. Records can be reopened or permanently removed — deliberately, and by someone accountable.

Nine exports, not one

Current assignments, assignment history, employee directory, task register, completed tasks, task activity log, employee task history, a multi-sheet Excel workbook, a daily visual dashboard and a daily staffing summary — as CSV or XLSX, filterable by date range.

Every export is a leadership-ready workbook

Exports roll summary metrics, the daily operations trend, a department snapshot of staffing and workload, the current assignment board and task register highlights into one structured workbook — so reporting does not require anyone to touch the database.

In the product