Challenge
Each process maintained its own Excel progress sheet, leading to version chaos, transcription errors, and over 40 hours of monthly aggregation work. Sales and shop floor saw different numbers, causing late discovery of delivery delays.
Approach
Built a unified web application connecting orders, processes, progress, and shop-floor entries on the Lays-Lop framework in ~2.5 months. Top priority: a tablet-friendly UI allowing shop-floor staff to log progress in three taps.
Implementation
Supabase Realtime ensures shop-floor entries immediately reflect on management and sales dashboards. An Excel import feature preserved existing operational knowledge during migration. BI dashboards built in-house with Recharts and Supabase Views.
Results
Monthly aggregation effort dropped from 40 hours to 6, and progress meetings shrank by 60%. Critically, early detection of process delays raised on-time delivery from 92% to 98%.