This study aims to design and develop an application-based cycle count system to support the management of Work in Progress (WIP) material inventory at a wood-door manufacturing company (referred to as PT XYZ) in Majalengka, West Java. The cycle count process currently runs manually: physical stock counts are recorded on paper, re-entered into Microsoft Excel, and then reconciled with the SAP system, a workflow that is time-consuming and prone to human error. The system was developed using the Waterfall model, covering requirement analysis, UML-based design (use case, activity, sequence, and class diagrams), implementation with Flutter and Firebase, black box testing, and deployment. Data were collected through field observation, interviews with counting and inventory staff, and a review of relevant literature. The resulting mobile application allows counting staff to input physical stock data directly, automatically converts material dimensions into volume, area, or weight units, and exports the recorded data to spreadsheet format for reconciliation with SAP. Black box testing confirmed that the core functions of the application performed as expected. Comparative analysis showed that the digital method reduced data-collection time by 49-52% and recap time by 86-93% compared with the manual method across all material categories, indicating that the proposed system improves the speed and accuracy of WIP inventory data management.
Copyrights © 2026