Purpose – Data management at PT Paluta Inti Sawit (PT PIS) currently faces efficiency constraints due to fragmented operational data for Fresh Fruit Bunches (FFB), Crude Palm Oil (CPO), and Kernel (PK) stored in scattered spreadsheets. This study aims to design and build an integrated web-based dashboard to centralize monitoring and automate production reporting.Methods – The research employs an applied system development and functional validation design following the Waterfall System Development Life Cycle (SDLC). The system was developed using the Laravel framework and MySQL database, with ApexCharts for near-real-time interactive visualization after data ingestion.Findings – The developed dashboard successfully integrates multi-departmental production data into a single source of truth. Key features include an automated Excel/CSV parser with conflict resolution (skip/overwrite), a two-level role-based verification system (Staff and Manager), and near-real-time KPI tracking for Oil Extraction Rate (OER) and Kernel Extraction Rate (KER) upon data approval. Research implications – This system accelerates the daily reporting cycle and supports data integrity through a digital audit trail, assisting rapid, data-driven managerial decisions.Originality – Unlike previous studies that focus on mobile-only reporting, this system provides a mill-level integrated prototype for synchronized FFB reception and processing yield analytics, minimizing manual recapitulation errors.
Copyrights © 2026