Designing an Inventory Management System for Xania Jaya Msme
This study aims to evaluate the existing inventory management system and to design an effective Microsoft Excel-based inventory management information system for Xania Jaya MSME (Micro, Small, and Medium Enterprise). This research was prompted by problems faced by the MSME, such as conventional manual recording, frequent stock discrepancies, stockouts, and the accumulation of unsold products leading to expiration. This study employed a descriptive qualitative approach. The data sources included primary data obtained from interviews and direct observations, as well as secondary data from transaction documents such as purchase and sales invoices at Xania Jaya MSME. The findings indicated that the previously implemented manual system was inefficient and prone to recording errors. As a solution, this research designs a prototype of an inventory management application developed using Microsoft Excel with Visual Basic for Applications (VBA), which applies the First-In, First-Out (FIFO) method for inventory valuation. The designed application is capable of systematically managing incoming and outgoing goods data, automatically calculating the profit, and providing real-time stock reports. The implementation of this system is expected to assist Xania Jaya MSME in improving data accuracy, enhancing time efficiency, and supporting faster and more precise decision-making.