Software Design for Inventory Management Improvement in a Peruvian National University
DOI:
https://doi.org/10.37385/jaets.v6i1.6225Keywords:
Inventory management, reliability, university, usability, diseño softwareAbstract
The purpose of this study was to design a software to optimize inventory management in the Office of Information Technology and Communications (OTIC) of the Faculty of Industrial Engineering and Systems of the Universidad Nacional del Callao, Peru. The research arose due to the lack of an efficient system that minimizes asset losses and reduces operational errors in the university context, where resource constraints demand sustainable and adaptable solutions. To address this problem, an agile methodological approach was used, implementing the Scrum methodology in the software design, as well as an architecture based on MVC (Model-View-Controller) with technologies such as MySQL, PHP and CodeIgniter. The evaluation of the system included usability surveys to users and an expert judgment, focused on three dimensions: Reliability, Usability and Design. The results of the study showed a high acceptance of the system in terms of ease of use and user satisfaction, highlighting the effectiveness of the modular design for future extensibility and performance improvements. This study provides theoretical value by highlighting the application of agile methodologies in educational environments and highlights the importance of a scalable design to improve inventory management in academic institutions. In practical terms, the implementation of this software offers an adaptable and scalable solution, with potential for replication in other universities, optimizing resource management and strengthening operational efficiency in the educational sector. The main contribution of the study lies in the combination of a flexible and low-cost design, aimed at meeting the specific needs of inventory management in educational environments with budgetary constraints.
Downloads
References
Abiodun E, & Ikuomola A. (2022). An Adaptive Web-Based Inventory Control System for Universities. International Journal of Innovative Research and Development, 11, 32–37. doi.org/10.24940/IJIRD/2022/V11/I12/DEC22009
Abusanna H, Yahaya, N., Megat, M., Mohd, N., Abu, N., Awae, F., Nee, C., & Alsharif, A. (2023). Trends on Using the Technology Acceptance Model (TAM) for Online Learning: A Bibliometric and Content Analysis. International Journal of Information and Education Technology, 13(1), 131–142. doi.org/10.18178/ijiet.2023.13.1.1788
Al-Bashayreh, M., Almajali, D., Altamimi, A., Masa’deh, R., & Al-Okaily, M. (2022). An Empirical Investigation of Reasons Influencing Student Acceptance and Rejection of Mobile Learning Apps Usage. Sustainability (Switzerland), 14(7). doi.org/10.3390/su14074325
Alkelany, O. (2023). Using Relational Database to Effectively Manage and Monitor Institutional Research Activities. Journal of Engineering Research, 7(5), 51–55.
Al-Mamary, Y. H. S., & Al-Shammari, K. K. (2023). Determining factors that can influence the understanding and acceptance of advanced technologies in universities’ teaching and learning. International Journal of Advanced and Applied Sciences, 10(3), 87–95. doi.org/10.21833/IJAAS.2023.03.012
Aluguri, S., Maddiveni, S., Kandibanda, S., Kotakonda, B., & Anusha, M. (2023). RFID Based Inventory Management System. International Journal for Research in Applied Science and Engineering Technology, 11(10), 1363–1369. doi.org/10.22214/ijraset.2023.56210
Anand, A., Kaur, J., Singh, O., & Alhazmi, O. (2021). Optimal Sprint Length Determination for Agile-Based Software Development. Computers, Materials and Continua, 68(3), 3693–3712. doi.org/10.32604/cmc.2021.017461
Azanha, A., Tiradentes A, de Camargo J, & Antoniolli P. (2017). Agile project management with Scrum: A case study of a Brazilian pharmaceutical company IT project. International Journal of Managing Projects in Business, 10(1), 121–142. doi.org/10.1108/IJMPB-06-2016-0054
Benson-Emenike, M., Betrand, C., & Onukwugha, C. (2023). Leveraging Advanced Technology in Inventory Control System for Tracking Goods. Journal of Research in Engineering and Computer Sciences, 1(5), 91–99.
Bontchev, B., & Milanova, E. (2020). On the Usability of Object-Oriented Design Patterns for a Better Software Quality. Cybernetics and Information Technologies, 20(4), 36–54. doi.org/10.2478/cait-2020-0046
Budgen, D. (2020). Software Design: Creating Solutions for Ill-Structured Problems. Chapman and Hall/CRC. doi.org/10.1201/B21883
Damayanti, N., Trisnadewi A, Sanjaya I, & Jayanti S. (2022). The Effect of Information Technology Advancement, Personal Engineering Capabilities, And Accounting Information System User Participation On Accounting Information System Effectiveness. Journal of Governance, Taxation and Auditing, 1(1), 48–54.
Daracan, V., Latayan, R., Padilla, C., & Young, M. (2020, December 18). Designing an Inventory Database Software Suitable for Small Business. 7th IEEE International Conference on Engineering Technologies and Applied Sciences, ICETAS 2020. doi.org/10.1109/ICETAS51660.2020.9484166
Dasaklis, T., Voutsinas, T., Tsoulfas, G., & Casino, F. (2022). A Systematic Literature Review of Blockchain-Enabled Supply Chain Traceability Implementations. In Sustainability (Switzerland) (Vol. 14, Issue 4). MDPI. doi.org/10.3390/su14042439
De Oliveira, P., Da Silva, A., De Moura, E., & De Freitas, R. (2022). Efficient Match-Based Candidate Network Generation for Keyword Queries over Relational Databases. IEEE Transactions on Knowledge and Data Engineering, 34(4), 1735–1750. doi.org/10.1109/TKDE.2020.2998046
Devi R, Varshini, V., Shruthi, T., Nandini, P., & Bhavyasri, L. (2023). Asset Tracking and Management System. International Journal for Research in Applied Science and Engineering Technology, 11(6), 3679–3684. doi.org/10.22214/ijraset.2023.54185
Dhondge, G., Pawar, V., Hadole, T., & Shinde, V. (2023). Android-Based Mobile Application for Operations and Inventory Management. International Journal for Research in Applied Science and Engineering Technology, 11(4), 1370–1373. doi.org/10.22214/ijraset.2023.50372
Dzaky, F., & Kurniawan, D. (2023). Implementasi Metode Agile Framework Scrum dalam Pengembangan Sistem Informasi Manajemen Aset Terpadu Universitas Diponegoro Modul Inventarisasi. Jurnal Masyarakat Informatika, 14(1), 0648.
Fahrudin, N., & Wahyudi, A. (2023). Modeling Inventory Systems Using The User Experience Design Model Method. Journal of Data Science and Information Systems (DIMIS), 1(1), 9–16.
Faludi J, Acaroglu L, Gardien P, Rapela A, Sumter D, & Cooper C. (2023). Sustainability in the Future of Design Education. She Ji: The Journal of Design, Economics, and Innovation, 9, 157–178. doi.org/10.1016/j.sheji.2023.04.004
Fortuna, G., & Gaspar, P. (2022). Implementation of Industrial Traceability Systems: A Case Study of a Luxury Metal Pieces Manufacturing Company. Processes, 10. doi.org/10.3390/pr10112444
Ghashim, I., & Arshad, M. (2023). Internet of Things (IoT)-Based Teaching and Learning: Modern Trends and Open Challenges. Sustainability, 15(21). doi.org/10.3390/su152115656
Hady C, & Kusumo D. (2023). Prediction of a Sprint Delivery’s Capabilities in Iterative-based Software Development. JIPI (Jurnal Ilmiah Penelitian Dan Pembelajaran Informatika), 8(1), 77–83. doi.org/10.29100/jipi.v8i1.3292
Hassan, C., Hammad, M., Uddin, M., Iqbal, J., Sahi, J., Hussain, S., & Ullah, S. (2022). Optimizing the Performance of Data Warehouse by Query Cache Mechanism. IEEE Access, 10, 13472–13480. doi.org/10.1109/ACCESS.2022.3148131
Herdiansah, A. (2021). System Development for Learning Process Monitoring in Private Lesson Institution Using Codeigniter Framework. JISA (Jurnal Informatika Dan Sains), 4, 10–16. doi.org/10.31326/jisa.v4i1.861
Jayapal C, S, G., C, K., & A, J. (2023). Automation of Trace Analysis. 2nd International Conference on Advancements in Electrical, Electronics, Communication, Computing and Automation, ICAECA 2023. doi.org/10.1109/ICAECA56562.2023.10199556
Kedarisetty, S., & Kantheti, B. (2022). Designing Inventory system Utilizing Neural Network in the prediction of Machine Learning-based Design. 7th International Conference on Communication and Electronics Systems, ICCES 2022 - Proceedings, 1058–1061. doi.org/10.1109/ICCES54183.2022.9835853
Kisno, Gultom, S., Purba, S., Darwin, Sumaryanto, & Sherly. (2022, December 9). Agile Methodology in Educational Leadership: Scrum. Proceedings of the 7th Annual International Seminar on Transformative Education and Educational Leadership. doi.org/10.4108/eai.20-9-2022.2324591
Larutama, W., Suyatno, A., Rahmadani A, & Camellia, N. (2023). Information System Design in Warehouse Inventory Control. Journal of Logistics and Supply Chain, 3, 35–44. doi.org/10.17509/jlsc.v3i1.62069
Lievchalermwong, T., & Aunyawong, W. (2022). The mediation effect of inventory management practices on operational performance in public university. International Journal of Health Sciences, 6(S5), 385–396. doi.org/10.53730/IJHS.V6NS5.7847
Lumba, E., & Waworuntu, A. (2021). Implementation of Model View Controller Architecture in Object Oriented Programming Learning. International Journal of New Media Technology), 8(2), 102. doi.org/10.31937/ijnmt.v8i2.2429
Martishin, S., Simonov, V., & Hrapchenko, M. (2023). Databases: Design and development of information systems using MySQL DBMS and go Language. In INFRA-M Academic Publishing LLC. INFRA-M Academic Publishing LLC. doi.org/10.12737/1830834
Matuska, S., Machaj, J., Hutar, M., & Brida, P. (2023). A Development of an IoT-Based Connected University System: Progress Report. Sensors, 23(6). doi.org/10.3390/s23062875
Mesutoglu, C., Stollman, S., & Lopez, I. (2022). Challenge Based Modular Education Upscaled: Piloting and Evaluating an Implementation Procedure. SEFI 2022 - 50th Annual Conference of the European Society for Engineering Education, Proceedings, 2072–2076. doi.org/10.5821/conference-9788412322262.1341
Nurharjadmo, W., Khadija, M., & Wahyuning, T. (2022). Modern No Code Software Development Android Inventory System for Micro, Small and Medium Enterprises. Proceedings - 2022 IEEE International Conference on Cybernetics and Computational Intelligence, CyberneticsCom 2022, 191–195. doi.org/10.1109/CYBERNETICSCOM55287.2022.9865265
Ozkaya, I. (2020). Building Blocks of Software Design. IEEE Software, 2, 3–5. doi.org/10.1109/MS.2019.2959049
Ozkaya, M., & Fidandan, I. (2020). MVCLang: A software modeling language for the model-View-Controller design pattern. Proceedings of the 15th International Conference on Software Technologies, 75–83. doi.org/10.5220/0009571400750083
Pasuksmit, J., Jiang, F., Thornton, K., Friedman, A., Fuksmane, N., Kohout, I., & Connor, J. (2023). Improving Agile Planning for Reliable Software Delivery. Proceedings - 2023 IEEE/ACM 20th International Conference on Mining Software Repositories, MSR 2023, 25–26. doi.org/10.1109/MSR59073.2023.00017
Purwanningrum, D., Khairunnisa, H., Kurnianingtias, M., & Tuwarno, T. (2023). Designing a Web-based application of material and Inventory for Garment Workshop. Journal of Industrial Engineering Management, 8(1), 30–39. doi.org/10.33536/jiem.v8i1.1200
Ramos-Miller, M., & Pacheco, A. (2023). Towards inventory control excellence: An innovative approach based on a web-based platform. F1000Research, 12, 1471. doi.org/10.12688/f1000research.140745.1
Shah, B., Kedia, V., & Kumar, R. (2021). Integrated Vendor-Managed Time Efficient Application to Production of Inventory Systems. Proceedings of the 6th International Conference on Inventive Computation Technologies, ICICT 2021, 275–280. doi.org/10.1109/ICICT50816.2021.9358504
Shinde, S., Karadkhele G, Lohakare P, Shete S, & Vaidya V. (2023). Live Inventory Tracking System Using IOT. International Journal for Research in Applied Science and Engineering Technology, 11(5), 7161–7166. doi.org/10.22214/ijraset.2023.53344
Shinde, S., Lohakare, P., Karadkhele, G., Shete, S., & Vaidya, V. (2023). Industry 4.0 Based Live Inventory Tracking System. International Journal for Research in Applied Science & Engineering Technology (IJRASET), 11, 2321–9653. doi.org/10.22214/ijraset.2023.49697
Singh, S., Kunder, K., Jain, V., & Sagvekar, V. (2022). Inventory Management System for Education Institutions. 5th IEEE International Conference on Advances in Science and Technology, ICAST 2022, 206–209. doi.org/10.1109/ICAST55766.2022.10039520
Vinokur, A., Arsentev, D., & Arzamazov, I. (2023). The concept of a single digital educational platform. Proceedings Volume 12564, 2nd International Conference on Computer Applications for Management and Sustainable Development of Production and Industry (CMSD-II-2022), 12564, 1256402. doi.org/10.1117/12.2669472
Wang, J., & Chen, S. (2022). Design of Enterprise Inventory Management Program Based on Java EE Programming. ACM International Conference Proceeding Series, 936–940. doi.org/10.1145/3573428.3573597
Zayat, W., & Senvar, O. (2020). Framework Study for Agile Software Development Via Scrum and Kanban. International Journal of Innovation and Technology Management, 17(4). doi.org/10.1142/S0219877020300025