In the present paper a Linear Programming (LP) methodology for the city of Athens, Attica region is implemented trying to identify the energy supply levels based on the energy use, aiming to determine the optimal way for the energy needs to be covered. The final aim was to find the best solution/s to meet the (metropolitan) city's energy needs using Renewable Energy Sources (RES) and additionally implement a techno-economic analysis through a developed tool, in order to find which RES should participate in the city's energy system examining different scenarios focusing not only on the projects' economical success but also on minimizing the cost for the society.