Desarrollo de un Algoritmo Automatizado para la Generación de Reportes de Ventas en la Escuela de Gastronomía El Gran Chef de Villavicencio a través del lenguaje de programación PYTHON.

Abstract

The El Gran Chef Culinary School, located in Villavicencio, has experienced difficulties in managing its financial information due to the manual generation of sales reports. This process involved long execution times, a high administrative workload, and a significant risk of human error, ultimately affecting strategic decision-making and operational efficiency. In response to this issue, the development of an automated algorithm for generating sales reports was proposed, using the Python programming language as the primary tool. The main objective of this project was to design and implement a technological solution capable of processing, analyzing, and visualizing financial data accurately, quickly, and in real time. An observational and applicative methodology was adopted, which included the collection of historical data, the design of the algorithm's logical flow, the construction of the code in Google Colab, and validation through tests using real information provided by the institution. The results showed a reduction of more than 85% in report generation time, as well as a significant improvement in data accuracy and the visualization of key performance indicators. A user manual was also developed, allowing administrative staff to be trained and effectively adopt the system, ensuring its sustainability. This proposal demonstrates the potential of data science–driven automation to enhance financial management in educational institutions.