Software Design for Inventory Management Improvement in a Peruvian National University

Authors

  • Linett Velasquez UNIVERSIDAD CIENCIAS Y HUMANIDADES
  • Santiago Rubiños UNIVERSIDAD CESAR VALLEJO
  • Junior Grados UNIVERSIDAD NACIONAL DEL CALLAO
  • Juan Grados UNIVERSIDAD NACIONAL DEL CALLAO
  • Claudia Marrujo UNIVERSIDAD DE CIENCIAS Y HUMANIDADES

DOI:

https://doi.org/10.37385/jaets.v6i1.6225

Keywords:

Inventory management, reliability, university, usability, diseño software

Abstract

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

Download data is not yet available.

Author Biographies

Santiago Rubiños, UNIVERSIDAD CESAR VALLEJO

Doctor en Ingeniería Eléctrica, Magíster en
Ingeniería Eléctrica con mención en Gestión de Sistemas de Energía Eléctrica,
Bachiller de la carrera profesional de ingeniería eléctrica. Egresado con experiencia laboral
en el área de docencia, Proyectos de Ingeniería e Investigación. Magíster en Ingeniería Eléctrica.
Se le puede contactar al correo electrónico: slrubinosjh@unac.edu.pe.

Junior Grados, UNIVERSIDAD NACIONAL DEL CALLAO

Dr. in Electrical Engineering, Master Degree in Engineering Project Management, Bachelor's Degree in Systems Engineering and Computer Science. Graduate with work experience in the area of ​​Teaching, Engineering Projects and Research.
He can be contacted at email: Hgradose@unac.edu.pe.

Juan Grados, UNIVERSIDAD NACIONAL DEL CALLAO

Dr. Juan Herber Grados Gamarra Electrical Engineer graduated from the National
University of Callao, Master in Engineering Project Management. PhD in Administration.
Coordinator of the research center of the Faculty of Electrical and Electronic Engineering at
the National University of Callao, evaluator of research papers by pairs of National and
International events for publication in indexed journals, I have 26 published articles. He can
be contacted at email: jhgradosga@unac.edu.pe.

Claudia Marrujo, UNIVERSIDAD DE CIENCIAS Y HUMANIDADES

Student of systems engineering at the University of Sciences and Humanities, Junior Assistant in the INTILAB research area.

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

Downloads

Published

2024-12-15

How to Cite

Velasquez, L., Rubiños , S. ., Grados , J. ., Grados, J. ., & Marrujo, C. (2024). Software Design for Inventory Management Improvement in a Peruvian National University . Journal of Applied Engineering and Technological Science (JAETS), 6(1), 138–154. https://doi.org/10.37385/jaets.v6i1.6225