Manufacture & Logistics System
Service-order management for an engineering consultancy — every hour logged, every cost known, every overrun flagged before it happens.
- Role
- Product design & full-stack development
- Context
- Internal platform · Knightec Group
- Year
- 2026
- Stack
- Next.js · Supabase · PostgreSQL · TypeScript · Tailwind CSS · Figma
Knightec's service orders used to live in Power Apps and SharePoint. I designed and built the web platform that replaced them: one place where every logged hour turns into real cost, in real time.
Two interfaces, one source of truth
For managers. Dashboards for available hours per service order, client requests, team allocation and real cost — calculated from each person's shift rate and time entries.
For the team. A focused interface just for logging the day's work. Every entry is linked to the right order and cost automatically.
Enforced by the database. Row-Level Security keeps each role in its lane inside Postgres itself, not just in the UI.
Alerts before overruns
Reports cover team utilization, active clients and open orders. Automated routines watch each order's hour limit and raise an alert as it gets close, so leaders can act early and keep clients in the loop.
Under the hood
Next.js with server-side rendering; Supabase for data, auth and real-time updates; and cost aggregations running directly in Postgres, so the numbers stay consistent as new entries come in.
