Sistema de Información para Dinamizar la Gestión comercial de un restaurante con la metodología ágil SCRUM

Andrés Benjamín Rojas-Alza; Luis Adonis Chávez-Cerna; Juan Pedro Santos-Fernández; José Alberto Gómez-Ávila; Marcelino Torres-Villanueva

Authors

Rojas-Alza Andrés Benjamín Escuela de Ingeniería de Sistemas, Universidad Nacional de Trujillo. Trujillo, Perú. https://orcid.org/0009-0006-3656-8660
Chávez-Cerna Luis Adonis Escuela de Ingeniería de Sistemas, Universidad Nacional de Trujillo. Trujillo, Perú. https://orcid.org/0009-0003-4230-378X
Santos-Fernández Juan Pedro Departamento de Ingeniería de Sistemas, Universidad Nacional de Trujillo. Trujillo, Perú. https://orcid.org/0000-0002-8882-9256
Gómez-Ávila José Alberto Departamento de Ingeniería de Sistemas, Universidad Nacional de Trujillo. Trujillo, Perú. https://orcid.org/0000-0002-5117-0873
Torres-Villanueva Marcelino Departamento de Ingeniería de Sistemas, Universidad Nacional de Trujillo. Trujillo, Perú. https://orcid.org/0000-0002-9797-1510

Keywords:

information system, agile methodologies, scrum, web development, business management

Abstract

The article presents an innovative approach to improve sales and purchasing management in a restaurant. The information system developed is based on the agile SCRUM methodology, resulting in a software that allows a continuous and efficient management of orders and real-time monitoring of inventory levels. The system was developed using tools such as Laravel, MySQL, JMeter; and integrated Laravel libraries were implemented for database management and API authentication. The system also has a purchasing module to carry out all operations with suppliers and third parties. The implementation of the system aims to reduce lead times, improve customer service management and reduce losses due to out-of-stock and excess inventory. The main objective is to directly optimize the current sales and purchasing management systems and processes at the Big Ben restaurant, keeping its processes more efficient, complete and secure. The design of an information system using agile methodologies is considered as a standard but innovative solution in the field of efficiency and profitability of business in the corporate sector, especially focused on culinary businesses.

Keywords: information system, agile methodologies, scrum, web development, business management.

Downloads

Download data is not yet available.

References

Alami, A., & Krancher, O. (Setiembre de 2022). How Scrum adds value to achieving software quality? Empirical Software Engineering, 27. doi: https://doi.org/10.1007/s10664-022-10208-4

Alsharari, A. S., Wan, W. M., Letchmunan, S., & Mohammed, B. A. (2023). A Review of Agile Methods for Requirement Change Management in Web Engineering. International Conference on Smart Computing and Application, ICSCA. doi: https://doi.org/10.1109/ICSCA57840.2023.10087734

Arias, R., Nalvarte, K., & Andrade, L. (2021). Design of a Web System to Optimize the Logistics and Costing Processes of a Chocolate Manufacturing Company. International Journal of Advanced Computer Science and Applications (IJACSA), 12(8), 860-866. doi: https://doi.org/10.14569/IJACSA.2021.0120897

Barbareschi, M., Barone, S., & Carbone, R. (Julio de 2022). Scrum for safety: an agile methodology for safety-critical software systems. Software Quality Journal, 30, 1067-1088. doi: https://doi.org/10.1007/s11219-022-09593-2

Breyter, M. (2022). AGILE PRODUCT AND PROJECT MANAGEMENT: A STEP-BY-STEP GUIDE TO BUILDING THE RIGHT PRODUCTS RIGHT. In Agilec Product and Project Management: a Step-By-Step Guide to Building the Right Products Right (1 ed.). Apress Media LLC. doi: https://doi.org/10.1007/978-1-4842-8200-7

Campaña, X. (2019). ITConsultors. Obtenido de https://www.itconsultors.com/metodologia-scrum

Fitriawati M., L. R. (2018). Design of the Information System for Kindergarten Learning Plan used Scrum Methodology. IOP Conference Series: Materials Science and Engineering, 407. doi: https://doi.org/10.1088/1757-899X/407/1/012131

García A., P. A. (2023). Design of a Web Application to Increase the Sales of the Company Neverland in Lima, Peru. International Journal of Engineering Trends and Technology, 71(4), 387-402. doi: https://doi.org/10.14445/22315381/IJETT-V71I4P234

Hema, V., Thota, S., Kumar, S., Padmaja, C., & Mahender, K. (2020). Scrum: An Effective Software Development Agile Tool. IOP Conference Series: Materials Science and Engineering, 961. doi: https://doi.org/10.1088/1757-899X/981/2/022060

Hendra, Y. A. (2018). Web-based Usability Measurement for Student Grading Information System. Procedia Computer Science, 135, 238-247. doi: https://doi.org/10.1016/j.procs.2018.08.171

Huacre K., D. A. (2021). E-commerce System for the Sales Process in the Company: A Systematic Review. Journal of System and Management Sciences, 11(4), 113-126. doi: https://doi.org/10.33168/JSMS.2021.0406

Junker, T., Bakker, A., Derks, D., & Molenaar, D. (2022). Agile work practices: measurement and mechanisms. European Journal of Work and Organizational Psychology, 32(1), 1-22. doi: https://doi.org/10.1080/1359432X.2022.2096439

Kammergruber, R., & Durner, J. (2018). Laboratory information system and necessary improvements in function and programming. Journal of Laboratory Medicine, 42(6), 277-287. doi: https://doi.org/10.1515/labmed-2018-0317

León, B., Mendoza, C., Delgado, A., & Enrique, H. (2021). A mobile mapping system of all industrial oxygen sales locations and free locations in Lima - Peru. International Journal of Engineering Trends and Technology, 69(4), 76-80. doi: https://doi.org/10.14445/22315381/IJETT-V69I4P211

Palyus T., A. A. (2023). Design and Build Inventory Management Information System. Journal Geuthee of Engineering and Energy, 2(1), 18-30. doi: https://doi.org/10.52626/joge.v2i1.15

Power W., S. D. (2022). Scrum Complementing Last Planner System – a Case Study. 30th Annual Conference of the International Group for Lean Construction (IGLC), 175-186. doi: https://doi.org/10.24928/2022/0120

Rahman H. U., R. M. (2021). Making the Sourcing Decision of Software Maintenance and Information Technology. 9, 11492-11510. doi: https://doi.org/10.1109/ACCESS.2021.3051023

Rahmat R. F., Z. E. (2020). Facial Recognition-Based Automatic Door Access System Using Extreme Learning Machine. IOP Conference Series: Science and Engineering, 851, 1-8. doi: https://doi.org/10.1088/1757-899x/851/1/012065

Sankhe, M. P. (2022). Review of an Agile Software Development Methodology with SCRUM & Extreme Programming. Proceedings of 2022 IEEE International Conference on Current Development in Engineering and Technology, CCET 2022. doi: https://doi.org/10.1109/CCET56606.2022.10080640

Saputra, N., Nonsi, M., & Purnama, R. (2021). The Development of Web-Based Correspondence Information Systems in University Using Scrum. Journal of Physics: Conference Series, 1823. doi: https://doi.org/10.1088/1742-6596/1823/1/012058

Sasmito G., N. M. (2019). Development of Web-Based Application in Population Administration System Using Scrum Framework. International Journal of Web Applications, 11(4), 125-135. doi: https://doi.org/10.6025/ijwa/2019/11/4/125-135

Thiele H., W. S. (2020). A SCRUM AGILE INTEGRATED DEVELOPMENT FRAMEWORK. Proceedings of the Design Society: DESIGN Conference, 747-756. doi: https://doi.org/10.1017/dsd.2020.9

Wan D. W., A. A. (2019). A point-of-sale system for measuring sales performance. International Journal of Advanced Trends in Computer Science and Engineering, 8(1.5), 151-155. doi: https://doi.org/10.30534/ijatcse/2019/3081.52019

Wulansari A., K. S. (2022). E-commerce Website Development Using Scrum Methods on Small Business. Ijconsist Journals, 3(2), 1-5. doi: https://doi.org/10.33005/ijconsist.v3i2.69