Web-Based Coffee Inventory Application
Case Study on One of The Coffee Shop in Sukabumi
DOI:
https://doi.org/10.55208/xbbys974Keywords:
Web-based Application, Inventory Management, Coffee Shop, Sukabumi, Case StudyAbstract
This study aims to gain insights into the inventory requirements of a coffee shop, develop and deploy a web-based application to enhance inventory management efficiency and assess the effects of this implementation on the coffee shop's operational processes. The methodology employed encompasses a blend of qualitative and quantitative techniques for data collecting, encompassing interviews, observations, and system testing. These methods are utilized to develop a comprehensive comprehension of the current inventory system and evaluate the efficacy of the recently built web application.
The findings indicate that implementing the application resulted in a substantial enhancement in inventory management. This condition was achieved through the provision of real-time inventory tracking, a reduction in errors associated with manual recording, and an overall improvement in operational efficiency. The coffee shop workers responded positively to the product, highlighting its user-friendly nature and time-saving capabilities.
Nevertheless, the study posits that forthcoming research should contemplate integrating elements such as predictive analytics to enhance stock management capabilities and develop a mobile iteration to augment flexibility and user-friendliness. This study provides additional evidence to reinforce the importance of implementing digital transformations in small-scale enterprises to address prevalent operational obstacles.
References
Based on the comprehensive study of the gathered data and the subsequent discourse on the identified issues, it is possible to derive the following conclusions:
The Inventory Information System of a coffee shop corporation located in Sukabumi is developed utilizing the PHP MyAdmin and Macromedia Dreamweaver software applications, with the assistance of a MySQL database. The system functions on a computer with various data, including product information, incoming product data, customer data, order details, and sales records.
The Inventory Application can streamline the process of documenting the arrival and departure of products, hence enhancing the accessibility of inventory stock information. Additionally, the application is equipped with a function that allows for the generation of reports, facilitating the preparation of reports in a timely, precise, and effective manner.
Proposed Recommendations
The suggested course of action for enhancing the effectiveness of this independent Inventory Information System is to transform it into a client-server architecture.
REFERENCES
Andriani, A., & Andry, J. F. (2023). Designing a Web-Based Inventory Application at General Steel Supplier Using Extreme Programming Method. CogITo Smart Journal, 9(1), 15–27. https://doi.org/10.31154/cogito.v9i1.479.15-27
Chowdhury, S., & Nanda, A. K. (2018). A new lifetime distribution with applications in inventory and insurance. International Journal of Quality & Reliability Management, 35(2), 527–544. https://doi.org/10.1108/IJQRM-12-2016-0227
Crawford, R. H., Bontinck, P.-A., Stephan, A., Wiedmann, T., & Yu, M. (2018). Hybrid life cycle inventory methods – A review. Journal of Cleaner Production, 172, 1273–1288. https://doi.org/10.1016/j.jclepro.2017.10.176
Drake, M. J., & Atkins, R. D. (2021). An inquiry‐based, partial information exercise for teaching inventory management. Decision Sciences Journal of Innovative Education, 19(4), 241–249. https://doi.org/10.1111/dsji.12236
Ferrari, A. M., Volpi, L., Settembre-Blundo, D., & García-Muiña, F. E. (2021). Dynamic life cycle assessment (LCA) integrating life cycle inventory (LCI) and Enterprise resource planning (ERP) in an industry 4.0 environment. Journal of Cleaner Production, 286, 125314. https://doi.org/10.1016/j.jclepro.2020.125314
Prakash, G., Singh, P. K., & Yadav, R. (2018). Application of consumer style inventory (CSI) to predict young Indian consumer’s intention to purchase organic food products. Food Quality and Preference, 68, 90–97. https://doi.org/10.1016/j.foodqual.2018.01.015
Puspita, F. M., Primadani, N. A., & Susanti, E. (2020). Application of Material Requirement Planning with ARIMA Forecasting and Fixed Order Quantity Method in Optimizing the Inventory Policy of Raw Materials of Sederhana Restaurant in Palembang. Proceedings of the 5th Sriwijaya Economics, Accounting, and Business Conference (SEABC 2019). https://doi.org/10.2991/aebmr.k.200520.014
S Pasaribu, J. (2021). Development of a Web Based Inventory Information System. International Journal of Engineering, Science and Information Technology, 1(2), 24–31. https://doi.org/10.52088/ijesty.v1i2.51
Shi, J., Rozas, H., Yildirim, M., & Gebraeel, N. (2023). A stochastic programming model for jointly optimizing maintenance and spare parts inventory for IoT applications. IISE Transactions, 55(4), 419–431. https://doi.org/10.1080/24725854.2022.2127164
Singh, D., & Verma, A. (2018). Inventory Management in Supply Chain. Materials Today: Proceedings, 5(2), 3867–3872. https://doi.org/10.1016/j.matpr.2017.11.641
Soysal, M., Çimen, M., Belbağ, S., & Toğrul, E. (2019). A review on sustainable inventory routing. Computers & Industrial Engineering, 132, 395–411. https://doi.org/10.1016/j.cie.2019.04.026
Supriyanto, S., Fitri, I., & Nurhayati, N. (2022). Aplikasi Inventory Peralatan Mekanik Unit BRT UNAS Berbasis Web Menggunakan Metode Black-Box dan White-Box Testing. Jurnal JTIK (Jurnal Teknologi Informasi Dan Komunikasi), 6(2), 224–233. https://doi.org/10.35870/jtik.v6i2.409
Taufik, A. (2021). Sistem Informasi Inventory (SITORY) Berbasis Web Dengan Metode Framwork For The Application System Thinking (FAST ). JATISI (Jurnal Teknik Informatika Dan Sistem Informasi), 8(2), 859–869. https://doi.org/10.35957/jatisi.v8i2.930
Wibowo, A. W., Kusmintarti, A., & Eltivia, N. (2022). ANALYSIS AND DESIGN OF INVENTORY ACCOUNTING INFORMATION SYSTEM APPLICATIONS TO IMPROVE INTERNAL CONTROL IN MSMEs FILO CR MALANG. International Journal of Multidisciplinary Research and Literature, 1(6), 660–669. https://doi.org/10.53067/ijomral.v1i6.77
Downloads
Additional Files
Published
Issue
Section
License
Copyright (c) 2023 Alifadillah, Haris Supriatna (Author)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
