Inventory Management Information System for Small and Medium Enterprises (SMEs)

Abstract

This study aims to design and develop an inventory management information system and evaluate its effectiveness for small and medium-sized enterprises (SMEs). A purposive sampling method was used to select 15 participants, including information technology experts and SME entrepreneurs. The research instruments consisted of (1) the inventory management information system and (2) the system performance evaluation form. The system was developed using Odoo (Open Source) and was designed to support inventory data storage, order management, product tracking, and status notifications, with PostgreSQL used as the database management system to accommodate business expansion. Data analysis methods included frequency distribution, percentage, mean, and standard deviation.

The results indicate that the system achieved a high level of efficiency (= 4.28, SD = 0.57). Among the key aspects, system accuracy scored the highest (= 4.40, SD = 0.51), followed by system functionality (= 4.34, SD = 0.48), security ( = 4.20, SD = 0.84), and usability ( x= 4.16, SD = 0.45). These findings align with the System Development Life Cycle (SDLC) model, which ensures a well-structured and systematically improvable system. However, further improvements are recommended in enhancing the user interface for better usability and strengthening data security measures to support long-term use and increase system reliability.