Rancangan Sistem Stock Opname Berbasis Web pada PT. Exo Drinks Indonesia (Es Teler Sultan Bandung Outlet Ciledug)
Keywords:
Stock Opname, Information System, Inventory Management, Website, Waterfall MethodAbstract
The rapid development of information technology has encouraged companies to improve the effectiveness and efficiency of data management, including inventory management. PT Exo Drinks Indonesia, particularly at the Es Teler Sultan Bandung Ciledug outlet, still conducts stock opname activities using a semi manual process by recording inventory data on personal devices before entering it into the Point of Sales (POS)
system. This process may lead to recording errors, data duplication, reporting delays, and discrepancies between system records and actual physical stock. The purpose of this internship project is to design a web based stock opname system that can improve the effectiveness, efficiency, and accuracy of inventory management processes. The methods applied in this study include observation, interviews, documentation, system requirements analysis, system design, implementation, and testing using the Waterfall development approach. The proposed system provides features for inventory data management, stock-in and stock-out transactions, physical stock recording, automatic stock discrepancy calculations, and real-time reporting. The results indicate that the designed system can support an integrated stock opname process, minimize recording errors, accelerate data processing, and improve inventory information accuracy. The implementation of this system is expected to assist the company in monitoring inventory more effectively and supporting faster and more accurate decision-making processes.
References
Akbar, R., Silvana, M., Hersyah, M. H., & Jannah, M. (2020). Implementation of business intelligence for sales data management using interactive dashboard visualization in XYZ stores. Proceedings of the International Conference on Information Technology and Systems Innovation (ICITSI).
Connolly, T., & Begg, C. (2015). Database systems: A practical approach to design, implementation, and management (6th ed.). Pearson.
Few, S. (2013). Information dashboard design: Displaying data for at-a-glance monitoring (2nd ed.). Analytics Press.
Fajrian, M. R. N., Vroticca, G. A. N., Pratama, A. R., & Wicaksono, M. (2025). Penerapan dashboard business intelligence untuk meningkatkan penjualan mobil: Studi kasus pada perusahaan XYZ. Saturnus: Jurnal Teknologi dan Sistem Informasi, 3(3), 52–60.
Hanifah, S. (2022). Implementasi business intelligence dan prediksi menggunakan regresi linear pada data penjualan dan breakage di PT XYZ. Jurnal Nasional Teknologi dan Sistem Informasi, 8(2), 101–110.
Knaflic, C. N. (2015). Storytelling with data: A data visualization guide for business professionals. Wiley.
Kimball, R., & Ross, M. (2013). The data warehouse toolkit: The definitive guide to dimensional modeling (3rd ed.). Wiley.
Laudon, K. C., & Laudon, J. P. (2020). Management information systems: Managing the digital firm (16th ed.). Pearson.
Power, D. J. (2002). Decision support systems: Concepts and resources for managers. Greenwood Publishing Group.
Putri, N. A., & Karnadi, K. (2025). Implementasi business intelligence untuk analisis data kinerja penjualan menggunakan Power BI. Bulletin of Computer Science Research, 6(1), 20–28.
Ramadhani, Y., Khairina, D. M., & Maharani, S. (2024). Implementasi business intelligence dalam analisa penjualan mobil Mitsubishi menggunakan visualisasi data. Adopsi Teknologi dan Sistem Informasi (ATASI), 3(1), 1–11.
Saptomo, A. B. (2022). Implementasi business intelligence dalam membuat desain dashboard informasi untuk analisis penjualan perusahaan (Skripsi, Universitas Islam Indonesia).
Turban, E., Sharda, R., Delen, D., & King, D. (2021). Business intelligence, analytics, and data science: A managerial perspective (5th ed.). Pearson.
Utomo, F. S. (2024). Sales data visualization to determine business insight using Metabase in a global retail company. Sistemasi: Jurnal Sistem Informasi, 13(4), 1001–1014.
Microsoft. (2025). Sales and marketing sample for Power BI: Take a tour. Microsoft Learn.
