Propuesta de optimización para auditorías en cuentas core y reestructuración institucional

Abstract

The professional internship was carried out at a Colombian-American services company called Lean Solutions Group, specifically within the Quality Department, in the area responsible for Core accounts in the city of Bogotá. The identified problem was directly related to the implementation of audit protocol development and the department’s lack of progress regarding one of the company’s institutional restructuring objectives, as it had not incorporated quantitative foundations for operational decision-making. Additionally, this newly introduced task lacked a clear methodological framework to determine workload, required time, and the risk of work overload. In response to these operational needs, a data simulation tool was designed in Microsoft Excel, incorporating the Monte Carlo simulation model, with the aim of optimizing processes and supporting decision-making based on quantitative data. The tool integrates both fixed and variable parameters to simulate multiple scenarios, thereby identifying critical situations, average processing times, and the Protocol Workload Overload Index (IRSP). As main results, a tool was developed that enables the anticipation of work overload scenarios, optimization of the protocol proposal development process, and the establishment of a foundation for transitioning the Quality Department toward a quantitative approach, aligning it with the organization’s institutional objectives of continuous improvement.