SOFTWARE DESIGN FOR INVENTORY MANAGEMENT IMPROVEMENT IN A PERUVIAN NATIONAL UNIVERSITY

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. © 2024, INTELLECTUAL RESEARCH AND DEVELOPMENT EDUCATION FOUNDATION (YRPI). ALL RIGHTS RESERVED.