Inventory management is essential to sustaining business operations and meeting customer demand. BigBoss Vape Store still manages its inventory manually, which leads to stock discrepancies, delayed replenishment, and difficulty in determining optimal order quantities; sales transactions and order management are likewise not integrated, reducing operational efficiency. This study designs and develops a web-based inventory management system that applies the Economic Order Quantity (EOQ) method to determine the optimal order quantity. The system was developed using the Prototype method and implemented with the CodeIgniter 4 framework, the PHP programming language, a MySQL database, and Unified Modeling Language (UML) for system modeling, and was evaluated using Black Box Testing. The results show that the system manages product, vendor, and vendor-product data, purchase and sales transactions, the shopping cart and checkout process, transfer-proof uploads, and administrator order management. The EOQ implementation determines the economic order quantity, order frequency, and Reorder Point (ROP), and recommends vendors based on purchase price. Testing confirms that all system functions operate as required, indicating that the system can improve inventory management efficiency, support procurement decision-making, and enhance service quality at the Vape Store.
Copyrights © 2026