Web-Based Smart Inventory System Using the FIFO Method for Optimizing Stock and Sales Management in Warung Madura

This study focuses on the design, implementation, and assessment of a web-based intelligent inventory and sales management system employing the First In, First Out (FIFO) method to enhance stock precision, operational efficiency, and data visibility in microenterprises such as Warung Madura. These small-scale retailers generally depend on manual record-keeping, leading to data inconsistencies, reporting delays, and revenue losses due to chaotic inventory management. The study applies the Rapid Application Development (RAD) methodology to facilitate agile and iterative software creation, ensuring consistent alignment with user requirements through recurrent feedback loops. The system was built using PHP with the CodeIgniter 4 framework, MySQL for database management, and modeled using Unified Modeling Language (UML) diagrams to describe its structure. Evaluation results indicate strong system reliability: Black Box testing confirmed that every module functioned correctly, while User Acceptance Testing (UAT) involving 21 participants produced an overall satisfaction rate of 80.67%, categorized as Good. Furthermore, the integration of FIFO-based logic enhanced the accuracy of stock recording and the speed of report generation, leading to a 40% reduction in manual errors compared to traditional bookkeeping methods. This study promotes the digital transformation of microenterprises by introducing an efficient inventory management solution that integrates accounting-based inventory control within an accessible web platform. In subsequent development stages, priority will be given to integrating mobile and cloud technologies to improve system accessibility, extend usability across diverse retail environments, and encourage broader implementation.