DEVELOPMENT OF A WEB-BASED PLATFORM FOR AUTOMATING AN INVENTORY MANAGEMENT OF A SMALL AND MEDIUM ENTERPRISE
Nowadays, it has been noticed that the majority of businesses manually record and maintain their inventory data in spreadsheets with little to no technological innovation. This has many drawbacks in our contemporary society because it has been demonstrated that successfully monitoring inventories is difficult. This manual method of record keeping was labor-intensive, expensive, and error-prone, and it was unable to guarantee that the inventory remained current due to oversight and internal shrinkage. This study investigates the problems with manual inventory management and creates computerised inventory management software to solve those issues. By creating a computerised inventory management system to help storekeepers make decisions about their stocks, it suggests solutions to the current problems by keeping the records, tracking employee salaries, and updating sales and transactions. To be user-friendly, to accommodate all user requirements, and to adapt to future changes, the system was divided into various modules. The key ideas of the analysis and design methodology for the suggested system were outlined, and they were contrasted with those already in use. They also described how the system was designed and put into use using the MySQL database. The implemented methodology is illustrated with a case study. It is suggested that the computerised system developed in this study replace the manual system of stock recording and processing to make life easier for people, increase effectiveness, efficiency, and improve service delivery. Adopting this software will also reduce unnecessary stress, keep the account current, and simplify their work
Adetokunbo, A. A., & Adenowo, B. A. (2013). Software Engineering Methodologies: A Review of the Waterfall Model and Object-Oriented Approach. International Journal of Scientific & Engineering Research, 4(7), 427-434.
Chassiakos, A., & Sakellaropoulos, S. P. (2008). A Web-based System for Managing Construction Information. Advances in Engineering Software, 39, 865-876.
Chin, A. J., Fang, C. L., & Abd Majid, H. (2009, 2009). The Application of Web-based Inventory Management System for Small and Medium Enterprise (SME/SMI): A Case Study for Hardware and Furniture Industry in Malaysia. 3rd International Conference on Operations and Supply Chain Management, Malaysia.
Database-System. (2019). MySQL 8.0 Reference Manual http://dev.mysql.com/doc/refman/4.1/en/what-is-mysql.html
Delisle, M. (2006). Creating your MySQL Database: Practical Design Tips and Techniques. Packt Publishing Ltd.
Erameha, K. B., & Odoh, B. I. (2021). Design and Implementation of a Web-Based Inventory Control System Using a Small Medium Enterprise (SME) as a Case Study. NIPES Journal of Science and Technology Research, 3(3), 211-219. https://doi.org/10.37933/nipes/3.3.2021.21
Jayanth, S., Poorvi, M. B., & Sunil, M. P. (2016, January 2017). Inventory Management System Using IOT. Proceedings of the First International Conference on Computational Intelligence and Informatics, Singapore.
John, N. E., Etimb, J. J., & Ime, T. U. (2015). Inventory Management Practices and Operational Performance of Flour Milling Firms in Lagos, Nigeria. International Journal of Supply and Operations Management, 1(4), 392-406.
Liu, D. T., & Xu, X. W. (2001). A Review of Web-based Product Data Management Systems. Computers in Industry, 44, 251-262.
Molina, H. G., Ullman, J. D., & Widom, J. (2009). Database Systems, The Complete Book (2nd ed.). Pearson Education Inc.
Muyumba, T., & Phiri, J. (2017). A Web Based Inventory Control System Using Cloud Architecture and Barcode Technology for Zambia Air Force. International Journal of Advanced Computer Science and Applications, 8, 132-142. https://doi.org/10.14569/IJACSA.2017.081117
Nyabwanga, R. N., & Ojera, P. (2012). Inventory Management Practices and Business Performance for Small-Scale Enterprises in Kenya. KCA Journal of Business Management, 4(1), 11-28.
Oballah, D., Waiganjo, E., & Wachiuri, E. W. (2015). Effect of Inventory Management Practices on Organizational Performance in Public Health Institutions in Kenya: A Case Study of Kenyatta National Hospital. International Journal of Education and Research, 3(3), 703-714.
Priniotakis, G., & Argyropoulos, P. (2018). Inventory Management Concepts and Techniques. IOP Conference Series: Materials Science and Engineering, 459(012060). https://doi.org/10.1088/1757-899X/459/1/012060
Singh, D. K. (2013). A Strategic Tool of Inventory Management. International Journal of Engineering Research and Applications, 3(2), 133-136.
Copyright (c) 2022 FUDMA JOURNAL OF SCIENCES
This work is licensed under a Creative Commons Attribution 4.0 International License.
FUDMA Journal of Sciences