Automated Inventory Management System for Income-Generating Projects

AUTHOR(S)

NICHOLAS KITCH JAMES S. GAJETELA, MSIT

ABSTRACT

— This study aimed to develop an Automated Inventory Management System (AIMS) for the Income Generating Projects (IGP) at Jose Rizal Memorial State University (JRMSU) main campus for the academic year 2023 to 2024. The objective was to transition from a manual to an automated system to enhance operational efficiency, reduce errors, and improve decision-making through accurate and real-time inventory data processing. The ISO/IEC 9126 framework assessed software quality across functionality, reliability, usability, maintainability, security, and acceptability. The Agile Software Development Life Cycle (SDLC) was utilized, employing C# for application development and MySQL for scalable data management. Expert systems were integrated to enhance inventory forecasting accuracy and decision-making through advanced algorithms and real-time analytics. The AIMS scored exceptionally well, with a grand mean of 4.57, indicating an ‘Excellent’ rating across all quality factors: functionality (4.63), reliability (4.55), usability (4.57), maintainability (4.59), and security (4.51). These scores reflect the system’s robustness and alignment with the operational needs of the IGP. The implementation is expected to significantly enhance managing the university’s incomegenerating activities by optimizing tasks and workflows. Recommendations include continuously updating the system with the latest technological advancements, developing comprehensive training programs for users, integrating the system with other institutional systems, and conducting further research to explore long-term impacts on organizational efficiency and scalability. Keywords — Automated Inventory Management System, Income Generating Projects, ISO/IEC 9126, Agile Software Development, Expert Systems