Perancangan Sistem Inventori Menggunakan Metode First In First Out (FIFO)

Abstract

This study discusses the design of a web-based inventory system using the First In First Out (FIFO) method at Kios Ardan. The main problem identified is that inventory recording is still done manually, making it prone to clerical errors, data loss, reporting delays, and the accumulation of old stock. The objective of this study is to develop a system capable of systematically recording incoming goods, outgoing goods, storage capacity, cost of goods sold, and ending inventory value. The research methodology followed the Waterfall model, which includes requirements analysis, system design, implementation, and black-box testing. Research data were obtained through interviews with the kiosk owner and transaction records from February 25 through March 31, 2026, covering 35 types of goods, 9 suppliers, and 83 transactions. The results of the implementation show that the system can automatically generate batch IDs based on the arrival date, deduct stock from the oldest batch when an outbound transaction occurs, and update remaining stock and reports in real time. The system also provides a dashboard, warehouse monitoring, FIFO reports, and a FIFO inventory system designed to improve record-keeping accuracy, reduce the risk of damaged or expired goods, and support inventory decision-making in small retail businesses. All eight black-box testing scenarios were deemed successful, and FIFO validation showed that the system’s cost of goods sold (COGS) matched manual calculations, including for transactions that deducted stock from two batches simultaneously, proving that the system is capable of automatically managing cross-batch transactions.