The work is devoted to the analysis of the current state and prospects of modernization of the fuel and energy complex and investments in renewable energy in order to achieve the Sustainable Development Goals in Ukraine, adaptation of an economic and mathematical model adequate to this process, allowing for rational distribution of investments, which in Ukraine plans to attract to development of the energy system and renewable energy as part of the implementation of the strategy “Vectors of Economic Development 2030”, the collection of potential sources of funds for the development and construction of thermal power plants using alternative fuels on the basis of existing heat supply enterprises in Ukraine. In the article it is recommended to use the add-in “Search for a solution” MS Excel for performing calculations according to the proposed deterministic model of a partially integer linear programming problem with boolean variables. As a result of the implementation of the proposed approach, moderate protection of the main producers (network operators) – heat supply utilities will be provided and market conditions for independent producers will be created, the operator will be encouraged to increase the efficiency of its own production.