Propuesta de mejora al modelo de margen de utilidad para la empresa Codensa S.A. ESP, con base en la Reglamentación Colombiana (Resolución 015 de 2018) expedida por la Comisión de Regulación de Energía y Gas (Creg)

Abstract

To determine the total profit margin of the company, it is necessary to resort to data from various areas in the company in order to compile them and determine exactly the amount of profit. For this process, the company Enel Codensa uses a series of files modeled in Excel that includes all the variables proposed in Resolution Creg 015 of 2018 (which establishes the methodology for the remuneration of the activity of distribution of electric energy in the Interconnected System ), but in a very complicated way in which it is very difficult to determine the causes of capital variations between months or between years. For the solution of this problem, a model has been proposed that explains in a clear and accurate way, obtaining each of the six major components that directly affect the profit margin, breaking down each of them into increasingly smaller variables, with In order to know which of these variables is the one that can affect me in a greater proportion some component of the profit margin of the company and thus work in it. In addition to this, the percentage changes of the components of the unit cost are explained graphically with respect to the amount they contribute within this profit margin and in this way know the possible losses or gains of each of these components between two dates and directly attack the area of ​​the company that creates difficulties for us.