DESIGN AND IMPLEMENTATION OF AN INVENTORY MANAGEMENT SYSTEM: A CASE STUDY OF JTMK KIOSK, POLITEKNIK UNGKU OMAR

Abstract

Inventory management is vital to ensure smooth operations and business sustainability, especially for small and medium sized enterprises (SMEs). However, many SMEs often rely on manual tools like Microsoft Excel, as these methods tend to be error prone, inefficient and lack data driven insights. This study aims to develop a web-based inventory management system using the Agile methodology, allowing for iterative design, continuous feedback, and flexible adaptation to user requirements throughout the development cycle. MySQL was used for structured data storage, and Visual Studio for system development featuring real-time stock tracking, price monitoring, automated commission calculations, and report generation. Results showed after the implementation of this system at JTMK Kiosk, Politeknik Ungku Omar, which demonstrated significant improvements in operational efficiency, including
reducing manual errors, faster data updates, improved stock visibility, and an intuitive user interface, while also enabling remote
data access. In conclusion, the system successfully meets its objective of delivering a simplified, cost effective inventory solution
for SMEs seeking to transition from manual processes to more efficient digital management, with opportunities for future
improvision to tackle its current limitations.