Rancang Bangun Sistem Manajemen Gudang Berbasis Web Menggunakan Algoritma FEFO dan Basis Data NoSQL untuk Optimalisasi Akurasi Stok

Abstract

The poInventory management efficiency and data accuracy are critical factors in logistics operations. Classic
issues such as the accumulation of expired goods (dead stock), physical stock discrepancies, and delays in
return handling frequently occur due to manual spreadsheet-based recording methods. This study aims to design
and build a web-based Warehouse Management System (WMS) integrating the Laravel framework with NoSQL
database technology (Firestore) to accelerate data access. The system implements automatic stock allocation
algorithms based on First-Expired-First-Out (FEFO) and First-In-First-Out (FIFO), a capacity validation
feature (Gatekeeper), and a Closed-Loop Return mechanism for return tracking. The testing method employed
black-box testing and operational performance comparative analysis. The results indicate that the system
implementation improved stock accuracy from 85% to 98%. Furthermore, item search time efficiency increased
significantly by 6,000% (from 120 seconds to 2 seconds) due to the NoSQL data structure. The Gatekeeper
feature proved valid in rejecting inbound transactions during overcapacity, while the FEFO algorithm
successfully prioritized the issuance of goods nearing expiration automatically. This study concludes that digital
transformation through WMS can minimize human error and enhance warehouse operational speed in real-time