Diseño de dashboard para gestión de riesgos en adquisiciones, ventas y recaudaciones en empresa alimentaria

Abstract

The following project has its objective in the design of an interactive dashboard through a business analytics platform that boosts internal control and the competitive environment in the buying, sales and collection processes of a food developing company. Additionally, the incorporation of key management indicators and warning systems is proposed to improve the efficiency of operations and reduce the risk of irregularities Therefore, it is based on the company’s need to carry out constant supervision, which is related with the new changes of technology and business environment. The methodology applied in the project is set for the situational analysis of the organization and its processes, following lately the evaluation of internal control through the framework COSO ERM 2027. Through this tool, the risks were identified and prioritized to qualify them using the risk matrix. Based on these control tests, the dashboard was designed with the data visualization platform Power BI where it shows the processes mentioned before are integrated into the organization’s ERP system. As a result, it was identified weakness in the actual internal control, risks of the processes and a action plan to mitigate them, including the automations of indicators and early warning systems. The project has a favorable net benefit of USD $4453.237. Keywords: Internal Control, COSO ERM 2027, Power BI, Automation, Risk Management.