Next Article in Journal
Selection of the Electric Drive for the Wood Waste Compacting Unit
Next Article in Special Issue
Maximum Power Point Tracking for Photovoltaic Systems Operating under Partially Shaded Conditions Using SALP Swarm Algorithm
Previous Article in Journal
Numerical Study on Infrared Radiation Characteristics of Stealth Coating for Turbofan Engine Tail Nozzle
Previous Article in Special Issue
Optimal Allocation of Renewable Energy Sources and Battery Storage Systems Considering Energy Management System Optimization Based on Fuzzy Inference
 
 
Font Type:
Arial Georgia Verdana
Font Size:
Aa Aa Aa
Line Spacing:
Column Width:
Background:
Article

Big Data Analysis for Optimising the Decision-Making Process in Sustainable Energy Action Plans: A Multi-Criteria Evaluation Approach Applied to Sicilian Regional Recovery and Resilience Plans

by
Umberto Di Matteo
1,* and
Sofia Agostinelli
2
1
Department of Engineering Sciences, Università degli Studi Guglielmo Marconi, 00193 Rome, Italy
2
CITERA Research Centre, Sapienza University of Rome, 00196 Rome, Italy
*
Author to whom correspondence should be addressed.
Energies 2022, 15(20), 7487; https://doi.org/10.3390/en15207487
Submission received: 8 September 2022 / Revised: 24 September 2022 / Accepted: 30 September 2022 / Published: 11 October 2022

Abstract

:
Keeping the global temperature rise below 2 degrees Celsius, as foreseen by the Paris Agreement, requires a new global roadmap for the energy transition. For this reason, the European Commission decided to directly involve local municipalities in reaching these objectives through multilevel, bottom-up actions for sustainable energy. The Covenant of Mayors is a very concrete demonstration of this trend of development and adoption of sustainable energy action plans (SEAP), rethinking the way cities operate and bringing them closer to energy self-sufficiency, with measures favouring local economic development and improving citizens’ quality of life. The numerous RES/RUE actions included in SEAPs at the regional level have led both to the request for huge funding and to increased complexity for regional managers to identify the best projects to be financed. To manage the multitude of data (emissions, energy consumption, cost, etc.) present in the SEAPs at a regional level, a web-based platform called Lex-energetica was developed. In this context, this paper aims to present a participatory supportive framework for the decision-making process involved in financing the SEAPs’ actions, considering the selection of sustainable Renewable Energy Sources (RES) and Rational Use of Energy (RUE) technologies. This study proposes a methodology based on two macro-phases: the first phase consists of a ranking evaluation of categories of areas of intervention based on the analytic hierarchy process, while the second identifies nine criteria, according to the domains corresponding to the three pillars of sustainability, to compare the most appropriate RES/RUE actions.

1. Introduction

The ongoing negotiations on climate within the United Nations Framework Convention on Climate Change (UNFCCC) have highlighted that to keep the global temperature increase to well below 2 °C, an extraordinary effort by all states is needed to review their NDCs (Nationally Determined Contributions). This extraordinary effort must be concretised in ambitious political plans by the various states, mainly focused on mitigation policies that decrease the concentration of greenhouse gases in the atmosphere [1]. Investing in sustainable energy systems allows the reduction of burdens on the environment and consequently provides an effective instrument for fighting climate change. To address the current energy challenges, a clear energy policy must be developed at all levels. Municipal policies have frequently been ignored due to the greater emphasis given at the centralised level [2].
However, to achieve the goal of containing the temperature growth, an improvement in the commitments by governments is not enough. The active involvement of the so-called “non-governmental actors” is also essential, including regions, cities, companies, and organisations of the civil society.
The EU has played a leading role at a global level in contrasting climate change since 1990, especially in 2008 with the launch of the largest movement named “Covenant of Mayors” for local climate and energy actions. This movement aims to engage and support mayors to reach the EU climate and energy targets.
The Covenant of Mayors initiative is focused on the adoption of the Sustainable Energy Action Plan (SEAP). This initiative has grown over the years and today brings together over 10,000 local and regional authorities, involving over 300 million citizens in 61 countries. In 2014, the EU launched Mayors Adapt, another initiative based on the same principles as the Covenant of Mayors but focused on adapting to climate change. With the Mayors Adapt, local governments have been invited to demonstrate leadership in adapting their territory to climate change, supporting them in developing and implementing local adaptation strategies.
In 2015, the two initiatives—Covenant of Mayors and the Mayors Adapt—were officially joined together, creating the new “Covenant of Mayors for Climate & Energy (SECAP)”. This represents the largest movement of local governments to actively support the implementation of the EU objective of reducing greenhouse gas emissions. The local authorities now pledge to support the adoption of an integrated approach to mitigate and adapt to climate change and to guarantee all safe access to sustainable energy.
Over the years, Italy has introduced several initiatives aimed at systematising the commitment of cities to reduce climate-altering emissions [3]. The Sicily region, for instance, has financed two initiatives to raise awareness among local authorities of the Covenant of Mayors and the drafting of SEAPs since 2014. To date, 364 Sicilian municipalities have joined the Covenant of Mayors, equal to 93.3% of the total, but only 271 (74.2%) have completed the approval process with the Covenant of Mayors. This figure indicates a success for the Sicilian region, which is second only to the Andalucía Region among the coordinators of the pact, representing an example of excellence in Europe.
From the analyses conducted on the SEAPs of the province of Messina, a large volume of structured and unstructured data emerges [4,5]. This data includes consumption and type of energy sources, specific and total CO2 emissions, predictive scenarios, categories of intervention, descriptions of numerous energy savings actions and RES (Renewable Energy Sources) plant projects, and technical and economic parameters of the reduction actions. Another emerging fact is that most of the projects planned by local authorities to reduce CO2 emissions are without financial coverage, in correspondence with the item “Financing” on each Action sheet, the desire to acquire financial resources from the State or the European Commission is often declared, or alternatively to resort to financing through third parties or to contracts with the E.S.C.O. (Energy Service Companies). In this context, national or regional authorities must identify on the one hand which categories of action envisaged by the Covenant of Mayors to prefer, and on the other hand, select—for each category of action—the best projects presented in the SEAPs, to achieve the planned long-term CO2 reduction objectives; this a typical decision-making problem.
Furthermore, the COVID-19 pandemic has taken place, causing a serious shock to the European and world economy, with a strong impact on the global energy system and CO2 emissions. We are at a turning point, in which it is necessary to drive the recovery by directing investments in the medium term towards the decarbonisation of the production system. This crisis must therefore constitute a challenge for the economy of European countries and to improve the living conditions of citizens. it is extremely important not to undermine the efforts made to date toward sustainable development, but rather to take the great opportunity offered by the Next-Generation-EU plan (also known in Italy as the Recovery fund) to strengthen the energy transition required by the EU.
To benefit from the Recovery and Resilience Facility, national or regional authorities should select and invest in projects in line with the green transition [3]. With the implementation of SEAPs sustainable projects, local authorities will increase local job creation and will grow their economic potential and social resilience.
This paper aims to present a two-macro-phase methodology—based on transparent multicriteria decision support—in order to support both regional authorities for the allocation of resources in the various action fields envisaged for CO2 emission reduction and to help regional managers to identify the best technological projects to be financed. The developed methodology incorporates two levels: (i) at the first level, it has developed the decision-making criteria weights to rank the several categories of actions for CO2 emission reduction; (ii) at the second level, multicriteria decision support is developed, to evaluate the ranking of CO2 reduction local eligible technological projects. Particularly, the target sectors of this study are public transport and urban mobility, public and private buildings, industrial equipment, and facilities. The rest of the paper is structured as follows: the next section provides a literature review concerning the analysis of the most used and reliable planning approaches. Section 3 presents an extensive description of the methodological approach used, while in the next section, the results of the pilot assessment of the proposed methodological approach to a “real” case in the province of Messina (Italy) are presented and discussed.

2. Literature Review

As above mentioned, to achieve the targets called the 20-20-20 package, the European Commission launched the Covenant of Mayors to support the efforts of local authorities in the implementation of the strategy to fight climate change and energy efficiency [6]. Water and energy conservation, sustainable transportation, and low emission technology are among the main variables playing a key role in the transformation towards climate-resilient economic growth [7,8,9]. The successful development of a Sustainable Energy Action Plan (SEAP) by the local authorities [10] constitutes an important decision-making problem as well as one of the main challenges for the implementation of sustainable energy planning. Both academic and practitioner studies show that in this context the choice of the most convenient and appropriate method of analysis is crucial since the local managers have to identify the most suitable fields of actions and opportunities for implementing their long-term CO2 reduction target before making their investment strategies [11,12]. In the renewable energy literature, multi-attribute decision-making (MADM) methods have been widely used for different purposes: (1) as evaluation of sustainable energy policies [13,14,15,16], (2) as a selection of the most sustainable energy source for electricity generation, (3) as evaluation of renewable energy sources, and (4) as identification of the best site for an energy facility among possible alternatives identified. These methods represent systematic procedures that define how the information on a single attribute is processed to support the decision of the best possible choice among the existing alternatives. MADM methods deal with the evaluation and selection of different alternatives under multiple criteria that may be conflicting with each other. The recent work of Ilbhar et al. (2019) [17] presents a review of about 150 studies implementing MADM methods in the domain of sustainable energy, providing details on the specific purposes of these methods that can be used and in the presence of which specific factors they can be preferred. Based on the given classification, the most common MADM methods in the literature are classified as (i) methods based on the pairwise comparison—e.g., Analytic Hierarchy Process (AHP) [18], Analytic Network Process (ANP), Decision Making Trial and Evaluation Laboratory Model (DE-MATEL); (ii) methods based on scoring—e.g., Technique for Order of Preference by Similarity to Ideal Solution (TOPSIS); and (iii) methods based on outranking—e.g., ELimination Et Choix Traduisant la REalité (ELECTRE) and Preference Ranking Organization Method for Enrichment Evaluations (PROMETHEE).
For instance, in the study of Dall’O et al. (2013) [19], a methodology is presented to support the municipalities for the preparation of SEAP. This study is based on a multi-criteria methodology in which the authors focused on the actions needed for the refurbishment of the existing building stock to improve their energy and environmental quality. A diagram is shown in which the actors involved are shown on the left-hand side, while on the right-hand side data from some different information sources are reported. The different steps of the proposed methodology can be divided into two macro-phases: in the first macro-phase, the energy data are acquired and processed for identifying mitigation actions, and multi-criteria analysis is applied in the second macro-phase. To apply this methodology, we need a working group of energy and environmental audit experts but also multi-criteria analysis experts. First, the requested data of existing urban scale buildings can be easily provided by the Municipality Technical Department through its archives or cadasters. Afterwards, a field survey must be organised to observe and define the thermo-physical characteristics of building stock. Once all the data requested by the methodology are acquired, the energy retrofit interventions that are feasible from a technical, legal, and economic point of view can be identified.
Another example of a multi-criteria approach is that described by Marinakis et al. (2017) [12]. This paper illustrates a participatory methodology to support local authorities in the implementation of sustainable energy planning. This methodology consists of two main levels: the first involves the development of RES and RUE action scenarios for local authorities and interventions for citizens. First, a design of alternative scenarios is carried out based on the development of RES/RUE actions in the different sectors of interest based on selected criteria. Through a participatory approach, feasible scenarios for the local community are filtered using an aspiration level. In the second level, direct and transparent multi-criteria decision support is introduced to evaluate the feasible scenarios. A multi-criteria ordinal regression methodology is implemented to estimate the best and worst possible scenarios.
In addition, Delponte et al. (2017) [20], analysing the case of a SEAP implemented in the Italian city of Genova, noted that to obtain operational monitoring of the SEAP and then favour an effective environmental energy policy at the local level, it is necessary to deepen the cost-benefit analysis of the interventions proposed in the plan, deepening their economic feasibility.
Furthermore, Howick et al. (2017) [21] proposed a risk identification and quantification procedure for the Northern Isles New Energy Solutions (NINES) project. The project foresees to monitor the effectiveness of the plan through interviews with workshop participants and project managers.
Cinelli et al. (2014) [22] presented the performance of five multi-criteria decision analysis (MCDA) methods (i.e., MAUT, AHP, PROMETHEE, ELECTRE, and DRSA). These methods have been chosen because they are suitable for following sustainability assessments that offer flexibility and the possibility of facilitating dialogue between stakeholders, analysts, and scientists. The performance of the methods was assessed based on ten main criteria that sustainability assessment tools should meet. The criteria taken into consideration are the following: ease of use, implementation of the life cycle, management of uncertainty, and computerisation.
Furthermore, the recent study by de Oliveira Neto et al. (2018) [23] proposed a framework of actions toward strong sustainability (SS), based both on the replacement of non-renewable natural resources with renewable ones and on the efficient use of resources, to preserve the environmental, economic, and social capital. The authors identified eight key actions, constituting their conceptual framework, which can be used in the multi-criterion analysis. The eight actions are: to increase the efficiency of resource consumption; limit the consumption of renewable resources according to their regeneration rates; reduce greenhouse gas emissions; reuse waste as input in other processes; replace toxic inputs with organic materials; replace non-renewable energy resources with renewable alternatives; increased convenience of basic items; and increase sustainable producibility.
Based on the literature reviewed in this section and the experiences of the authors [14], the present paper aims to empirically develop and assess a multi-attribute decision-making method suitable for the in-depth analysis of mitigation actions of several Sustainable Energy Action Plans. Such methodology is described in the following sections.

3. Material and Methods

To better support national and regional authorities in selecting the most appropriate and effective key actions of the SEAP for reducing CO2, this study proposes an integrated approach that consists of a two-level decision support system process. The first one consists of the Analytical Hierarchy Process (AHP), which requires the identification of the weights for each categorisation of the SEAPs actions. The second one, based on multi-criteria decision analysis, requires the identification of utility functions and weights covering the three sustainability pillars, assembled in a unique synthesising ratio of scale preferences [24,25], with the additive and multiplicative aggregations model [26].
A flowchart of the integrated methodology adopted, combining both the AHP method and the MCDA process, is presented in Figure 1.
The proposed methodology represents an effective tool for dealing with complex decision-making circumstances and may aid the decision makers to set priorities and take the best decisions.
Sustainability assessments of SEAP projects require many types of information, parameters, and uncertainties. Thus, multi-criteria decision analysis (MCDA) represents a suitable method to perform sustainability evaluations as a result of its flexibility and the possibility of facilitating the dialogue between stakeholders, analysts, and experts. Given its nature, it perfectly suits the SEAP key actions aimed at improving the energetic and environmental quality of human activities occurring in the local authority territory. As shown in Figure 1, all the activities included in the methodology can ideally be split into two macro-phases, as described in the following paragraphs.

3.1. Level I—Ranking Evaluation of Categories of Areas of Intervention Based on Analytic Hierarchy Process

The process starts from the set of criteria concerning the categories of areas of intervention [27,28]. Through a hieratic process, a weight for each criterion is generated by the decision maker according to the pairwise comparisons of the criteria. Therefore, the authors required a working group including not only energy and environmental experts but also experts in the planning and development of the territory. The use of the AHP, developed by Saaty (2013) [29], is illustrated below.
The first step requires modelling the decision problem as a hierarchy and constructing a pairwise comparison matrix. Next, the pairwise comparisons of experts of the working group need to be obtained, thus determining the global score for each criterion. The priorities of each factor in terms of its contribution to the objective are calculated through eigenvalues and eigenvectors of each pairwise comparison matrix.
The final stage consists of calculating a Consistency Ratio (CR) to measure how consistent the judgments have been about samples of purely random judgments. The use of AHP allows for the calculation of the inconsistency index. This value is obtained from the ratio of the decision maker’s inconsistency and randomly generated index. The value of CR allows the decision maker to assess that the judgments are consistent and that the final decision is well made. In case of results of a higher value of the inconsistency index, a new re-evaluation of pairwise comparisons of decision makers is required. Thus, with this type of approach, the results obtained are reliable.
Finally, the elements of the consolidated decision matrix (all participants/experts) are calculated as the weighted geometric mean of all individual workgroup participants. This part of the methodology allows for distribution, in a transparent and traceable way, of the sums allocated by the national/regional/local authorities on the different categories of areas intervention.

3.2. Level II—Sustainability Evaluations of SEAP’s Projects

In the evaluation of projects, the “business as usual” approach considers only the economic aspects. In several cases, this strategy is the most cost-effective related to CO2 reduction projects. However, better, and more comprehensive, approaches to financing these projects should rely on a complete sustainability assessment through a concrete and operational approach that defines and derives the building blocks of sustainability to make this concept operational.
To compare the different key actions proposed, a multiplicity of aspects must be considered: from economic and social issues to technological, environmental, and energy issues. This systematic approach is of greater complexity since it requires knowledge about all the different aspects as well as the consequences of the key actions. Yet, the final result will be more consistent with local policies to promote workers’ interests. Thus, we developed a multi-criteria decision analysis (MCDA) model based on the environmental, economic, and social pillars. This methodology provides a ranking for all the SEAP’s key actions proposed, including both the criteria and the preference system (weights) given by the expert panel. The proposed methodology is described in detail below.
Once it is established that the decision-making process is based on the three pillars of sustainability, we identify appropriate criteria for the decision process. The criteria selection must be consistent with the indicators proposed by the Covenant of Mayors (CoM). These indicators are ‘structurally independent’—namely, the range of possible ratings of a criterion is independent of (i.e., not constrained by) ratings of other criteria (even if the criteria are correlated), and vice versa. Furthermore, these criteria must be relevant to decision-makers of regional authorities. To that end, for each sustainable alternative (environmental, economic, social), three indicators are defined, which form the final set of nine evaluation criteria that satisfy the following requirements: monotony; exhaustiveness; cohesiveness; and non-redundancy.
The third step involves scoring the SEAP’s proposed actions on the selected criteria, that is, converting each action performed on each criterion into a numerical score. The scores are normalised so the lowest performance on the criterion gets a score of zero (0) and the highest performance gets a score of one (1).
The fourth step consists of carrying out a weighting of the criteria through the analytic hierarchy process (AHP method), which indicates the relative importance that expert panels give to the indicators of the three pillars that have been chosen. The final step of the developed methodology consists of calculating the “total scores”. Each action’s scores on the criteria are multiplied by the identified weights, and then the weighted scores are summed across the criteria to obtain each SEAP’s action total score.

3.2.1. Level II—Criteria Selection

As mentioned above, the nine selected criteria have been selected according to the domains corresponding to the three pillars of sustainability (Table 1). The criteria selection aims to choose comprehensible, meaningful, and controllable criteria, which make it possible to verify the relevance and effectiveness in evaluating the three dimensions of sustainable development of the individual projects presented. The selected criteria meet the following requirements: monotony, completeness, cohesion, and non-redundancy. Furthermore, the selected criteria are preferentially independent. This means that, for instance, the trade-offs between criteria gi and gj are not dependent on the values of the rest of the criteria. More specifically, the hypothesis needed to validate an additive value function for a given decision maker (DM) is the preferential independence of all the criteria.
Particularly, the criteria identified are the following:
In more detail, the identified criteria are the following.

3.2.2. Social Criteria

c1—Risk of Failure

Allocating sums to project actions still in an embryonic state represents a condition of high risk of failure and social damage to the community. With this criterion, the authors want to weigh the progress of the interventions planned by the public administration (PA) in such a way as to prefer the financing of actions already supported by a planning and study process. Therefore, a high score will be attributed to those actions that result in a more advanced level of design. Two risk scales have been developed: one for structural projects (see Table 2) and the other for knowledge development, training, and planning activities. The judgment scale is as follows:

c2—Average Lifetime Employment Impact of SEAP Actions

This criterion reflects the impact on the social dimension regarding the creation of new jobs. In this criterion, two macro-categories of employment are identified: manufacturing, construction, installation (the most intensive employment area), and operating/maintenance (which last for the entire project’s lifetime) [30,31,32,33,34]. The criterion aims to assess whether the SEAP’s project actions to be carried out can have effects on employment.
The performance of this criterion is assigned based on a 5-Point qualitative scale (Table 3), namely: “very low” (lower than 1 n.jobs./M EUR investment), “low” (higher than 1 and lower than 3), “medium” (higher than 3 and lower than 6), “ high” (higher than 6 and lower than 15) and “very high” (higher than 15 n.jobs/M EUR investment).
The scores were assigned as follows:

c3—Third Party Equity Financing

This criterion aims to reward the financial participation of third parties in the implementation of the action. It is consistent with the criterion of efficiency and usefulness as the reduction of public funding involves the maximisation of the number of projects that can be financed, and, consequently, of the energy-saving objectives envisaged by the SEAP.
The score is assigned in direct proportion to the participation fee by Third Parties according to the following formula:
T P E F j = % T P E F j M a x % T P E F
%TPEFj is the % of third-party equity financing of the j-th project.
Max|%TPEF| is the maximum value of third-party equity financing of all the Municipality actions.
The higher the Third-Party Equity Financing of the examined action, the higher its performance for this criterion.

3.2.3. Economic Criteria

c4—Ratio Cost Investment/Energy Saving

This criterion aims to reward those interventions that have a minimum ratio between the IC investment cost of the j-th project (EUR) and the energy saving ESj (kWh) estimated over the technical life of the intervention.
R C I j = 1 I C E S j M i n I C E S   M a x I C E S M i n I C E S    
IC is the investment cost of the project j-th (EUR).
ES is the energy saving of the j-th project (kWh) estimated over the technical life of the intervention.
Min|(IC/ES)| is the lowest of all Investment Cost/Energy Saving ratios.
Max|(IC/ES)| is the maximum value of all Cost Investment/Energy Saving ratios.
The lower the ratio (Investment Cost/Energy Saving) of the examined action, the higher its performance for this criterion.

c5—Price Variance in Standard Cost Accounting

This criterion defines the range of variation of the considered cost driver and is aimed at comparing the costs incurred in the different projects to achieve a specific goal.
For each categorisation area, the estimated Price Variance in the standard Cost Accounting can be calculated with the following equation:
V C A j k = 1 I C j 0.85 × I C s t d , k I C m a x , k 0.85 × I C s t d , k          
ICj is the cost of investment per ton of CO2 of the j-th project in the k-th categorisation action (EUR/ton).
ICstd,k is the standard cost per ton of CO2 of investment in the k-th categorisation action.
All the costs are presented in Table 4.
ICmax,k: is the maximum cost of investment per ton of CO2 of projects in the k-th categorisation action (EUR/ton).

c6—Investment Cost for the Municipality (Quantitative Criterion)

The economic magnitude expresses the cost of the implementation of actions by the local authorities. This cost may include actions in categorisation areas. The estimated investment cost for the municipality can be calculated by the following equation:
I C M j = 1 I C I N H j M i n I C I N H   M a x I C I N H M i n I C I N H          
ICj: is the investment cost due to the implementation of the j-th action by the local authorities.
INH is the total number of inhabitants of the Municipality.
Min|(IC/INH)| is the lowest value of all the investments for the Municipality.
Max|(IC/INH)| is the maximum value of all the investment costs for the Municipality.
The lower the ICMj ratio of the examined action, the higher its performance for this criterion.

3.2.4. Environmental Criteria

c7—% Energy Reduction—(Quantitative Criterion)

This criterion estimates the % of energy reduction (kWh) that will be achieved through the implementation of the proposed action.
The calculation of this criterion is based on the following data:
  • Development of the baseline year energy inventory, namely, the benchmark year against which the achievements of the energy reductions are measured.
  • Estimation of the total energy reduction of the proposed action using the calculations for the energy saving and production.
And can be obtained with the following equation:
E R j = E R r e d j E R r e d b a s e M a x E R r e d j E R r e d b a s e
ERj: energy reduction index due to the implementation of the j-th action.
ERredj: the total amount of energy reduction due to the implementation of the j-th action (kWh).
ERred-base: total energy reduction in the baseline year (kWh).
M a x E R r e d j E R r e d b a s e is the maximun value of the energy reduction index.
The higher the energy reductions of the examined action, the higher its performance for this criterion.

c8—% CO2 Emission Reduction—(Quantitative Criterion)

This criterion estimates the % of reduction of the CO2 emissions that will be achieved through the implementation of the proposed action.
The calculation of this criterion is based on the following data:
  • Development of the baseline year emission inventory, namely, the benchmark year against which the achievements of the emission reductions are measured.
  • Estimation of the total CO2 emissions reduction of the proposed action using the calculations for the energy saving and the related emissions factors.
And can be obtained with the following equation:
C O 2 j = C O 2 r e d j C O 2 r e d b a s e M a x C O 2 r e d j C O 2 r e d b a s e    
CO2j: CO2 emissions reduction index due to the implementation of the j-th action (%).
CO2redj: the total amount of CO2 emissions reduction due to the implementation of the j-th action (tCO2).
CO2red-base: total CO2 emissions reduction in the baseline year (tCO2).
The higher the emissions reduction of the examined action, the higher its performance for this criterion.

c9—CO2 Emissions Reduction Cost (Quantitative Criterion—€/ton)

This criterion estimates the cost of reduction of the CO2 emissions [35] that will be achieved through the implementation of the action proposed.
This criterion can be calculated by the following equation:
R C C O 2 , j = 1 I C C O 2 r e d j M i n I C C O 2 r e d   M a x I C C O 2 r e d M i n I C C O 2 r e d
R C C O 2 = I C j C O 2 r e d j
ICj is the cost of investment of the j-th project in the k-th categorisation action.
CO2redj: the total amount of CO2 emissions reduction due to the implementation of the j-th action (tCO2).
Min|(IC/(CO2red)| is the lowest value of all the CO2 Emissions Reduction Costs.
Max|(IC/(CO2red)|is the maximum value of all CO2 Emissions Reduction Costs.
The lower the cost of the emissions reduction in the examined action, the higher its performance for this criterion.

4. Data Source—Province of Messina SEAPs In-Depth Analysis

Following the awareness-raising initiatives carried out by the Region of Sicily, 68 out of 108 municipalities of the Province of Messina have adopted a SEAP, involving 511,373 inhabitants, equal to approximately 78% of the population of the entire Province (649,824 inhabitants) (see Figure 2).
All the data analysed came from the SEAPs in the province of Messina and have been collected in the “LEXenergetica” web portal, a web-based tool designed for the management and monitoring of energy balances and CO2 emissions. The software platform enables the following activities:
  • To build the basic inventory of CO2 emissions—Baseline Emission Inventory (BEI), and subsequent updating of the inventories—Monitoring Emission Inventory (MEI), both in terms of final energy consumption and CO2 emissions detailed by year and sector;
  • To visualise, through graphs and tables, the consumption and CO2 emissions of the BEI and subsequent years (absolute or per capita), as well as the production of local electricity and heat in the BEI’s reference year and subsequent years;
  • To identify and monitor the objective in terms of CO2 emissions reduction through the construction of the Action Plan and its monitoring through a GANTT Diagram;
  • To periodically check the percentage of achievement of the objective during the implementation phase of the SEAP through special web dashboards.
The platform allows also to group and extrapolate large amounts of data to calculate the potential energy savings or greenhouse gas reductions per type of intervention. For only the province of Messina, this means analysing over 10,000 data points and 1800 projects for CO2 reductions, energy efficiency, etc.
Based on the analysis of the data from the BEI, referring to the benchmark year 2011 (64 municipalities out of the total of 68 in the province of Messina), the overall emissions of greenhouse gases amount to 1,237,971.29 tCO2/year, equal to about 20% of those estimated for the Sicilian Region (6,175,145 tCO2/year).
CO2 emissions, deriving from electricity consumption, are equal to 659,726.6 tCO2 (51.9%), while those deriving from thermal energy consumption are 612,197.7 (48.1%). The distribution of CO2 emissions in the various sectors is as follows.
In the provincial territory, as shown in Table 5, the most contributing sectors to greenhouse gas emissions are public and private transport (28.04%), residential buildings (32.76%), the tertiary sector (18.76%), and industry (15.05%). The sum of all consumption by local authorities, on the other hand, only accounts for about 5%, while agriculture, fishing, and forestry represent 0.5%. Figure 3 shows the distribution of energy consumption of the municipalities of the province of Messina for the benchmark year 2011.
As shown in Table 6, the energy consumption of the municipalities in the analysed sample amounts to 3,999,757.68 MWh per year.
As shown in Table 7, the analysis of emissions corresponding to fuel consumption shows a clear prevalence of electricity consumption (49.1%) and consumption of natural gas (14.3%), diesel and heating oil (18.7%), and gasoline (11.5%); these are followed by consumption of LPG (2.8%), other fossil fuels (2.2%), and coking coal (0.6%).
While from the analysis of the SEAP data the city of Messina shows the greatest impact on the consumption of the province, with a share of 41.55%, in terms of per capita consumption, the highest value concerns the municipality of Pace del Mela, with 9.36 tCO2 per inhabitant (Figure 4). This value is very high if compared to the ones of other cities, generally between 2 and 4 tCO2/inhabitant; it could be due to the inclusion in the BEI of data relating to emissions from the Emission Trading System (ETS) industries, located in this important production site.
As for the local production of electricity, the SEAP study reports an estimation of the amount of electricity generated by photovoltaic systems of 26.2 GWh/year, corresponding to 1.9% of the electricity needs of the municipalities of the analysed sample (1381.1 GWh/year). The production of electricity from photovoltaic sources reported in the SEAPs equals 26.2 GWh/year and represents 96.7% of the total provincial production, based on what is indicated in the statistical yearbook of the GSE for the benchmark year 2011 (i.e., 27.1 GWh/year).

Analysis of the Interventions Proposed in the SEAPs of the Province of Messina

The objective of reducing greenhouse gas emissions by 21.29% by 2020 [36], which was envisaged in the SEAPs of the municipalities of the Province of Messina under consideration, can be achieved through the implementation of 1851 actions whose cost amounts to approximately EUR 2 billion. It is worth noting that almost 89% of the costs are ascribed to actions of private individuals, while only 11% relate to public administration actions.
The private and commercial transport sector, with an amount of EUR 1146 billion, represents 55.9% of the total estimated costs. This datum explains why transport is perceived as one of the most important problems to be solved, even though its weight on the balance of emissions is equal to 16.54% of those referring to the entire provincial territory. The resources requested by local authorities amounted to EUR 224,045 million (10.93%); investments in the residential sector amounted to EUR 524,269 million (25.6%), while those necessary for local energy production amounted to EUR 132,850 million (6.5%).
Table 8 shows the breakdown of the costs of the various actions proposed by the SEAPs.
In Table 9, the costs of the CO2 reduction actions proposed in the SEAPs divided by category of actions are shown.
The interventions proposed in the SEAPs, in terms of CO2 reduction [37], are strongly concentrated on the efficiency of private and commercial transport, residential buildings, and local authorities. If we do not consider the investments envisaged by private individuals for the replacement of old means of transport with more efficient ones—equal to approximately EUR 1146 billion, mainly linked to government incentives for low-emission cars and improvements in the country’s economic conditions—the greatest investments are foreseen in the residential sector (25.6%) and the production of electricity from photovoltaic sources (5.3%).
Concerning the efficiency and modernisation of buildings and implants of local authorities, the SEAPs focus mainly on the reduction of electricity consumption: in figures, 105,865.34 MWh/year for buildings and public lighting, for an overall total of 20,728.75 MWh/year. The Local Authorities, from the sample of the Province of Messina, have planned investments for the energy efficiency of public lighting systems and the production of electricity from renewable sources, for EUR 145,246,228.67, equal to 47.5% of the financial resources foreseen by the SEAPs for this sector (Figure 5, Table 10). A cost of EUR 21,405,790 is foreseen for the replacement of the most polluting municipal means of transport with others with low emissions; while for training activities, citizens’ awareness, involvement of stakeholders, strategic planning and the other remaining actions, the sum of EUR 8,704,712 is foreseen. In this regard, the local authorities included in the sample of the Province of Messina have planned investments for the energy efficiency of public lighting systems and the production of electricity from renewable sources for EUR 145,246 million, equal to 47.5% of the financial resources foreseen by the SEAPs in this sector (Table 10). The amount of EUR 21,405 million is foreseen for the replacement of the most polluting municipal means of transport with more efficient ones; while for activities of training, citizens’ awareness, involvement of stakeholders, strategic planning, and the remaining actions, the sum of EUR 8704 million was estimated.
The production of electricity from photovoltaic systems was expected to produce 43,290.23 MWh/year by 2020, equal to 40.9% of the overall electricity requirement for municipal buildings and plants. The resources provided in the Action Plans for the construction of plants that use renewable energy sources, such as solar, wind, hydroelectric, and geothermal energy, amount to approximately EUR 132,850 million (Table 11); photovoltaic systems are the ones that attract the greatest interest, followed by geothermal heat pumps and micro-wind power.
However, by analysing the SEAPs, it emerges that most of the projects planned by Local Authorities do not have financial coverage; in fact, the intention to acquire financial resources from the State or the European Commission is often declared under the heading “Financing” of each Action sheet. Alternatively, the documents mention the possibility of financing through third parties or contracts with Energy Service Companies (ESCo). From this first analysis, we highlighted the complexity and the great variability of data to be considered in the decision-making process [38]. The choices made by public administrations derive from complex hierarchical comparisons between alternative options, which are often based on conflicting criteria and the need for a clear holistic vision by public decision makers.

5. Pilot Appraisal—Messina Province SEAPs

The proposed methodology has been applied to the SEAPs of Messina Province. The first step in the double-decision support system process is to assess the best possible categories of areas of intervention through an application of the AHP method.

5.1. Best Categories Evaluation for Areas of Intervention Based on the Analytic Hieratic Process

The guidelines on Sustainable Energy Action Plan and Monitoring report the categorisation of the actions: in particular, the following eight categories of intervention are identified in Table 12:
To determine the weights related to the eight categories of areas of intervention, the procedure contemplates a hierarchy which follows the AHP method. In particular, the hierarchy provides that every decision maker (or typology of decision makers) shall assess the importance of the criteria by comparing them in pairs. In general, it should not be difficult to estimate the decision-making power of the various parties involved according to the level of responsibility related to the subjects. Each decision maker can make quite simple judgments by comparing from time to time the importance of just two criteria as well as the final weights, which will be assigned to the criteria as an average of values given by the different decision makers.
A specific pairwise comparison (questionnaire) has been drawn up just to involve different types of decision makers regarding the assignment of weights to these eight categories of areas of intervention. The comparison is made by assigning numerical values to express the strength of the preference of one factor over the other, as shown in Table 13.
The question asked to the expert panels concerning the different factors is: “What is the relative importance of each factor in selecting the most preferred alternative?”. The questionnaire was sent to a work group formed by several experts (i.e., Directors and Heads of Units of regional and national authorities; university professors and researchers; stakeholders; energy managers).
According to the opinions collected, it was possible to apply the AHP method to calculate the weights of the criteria starting from the matrix of pairwise comparison of criteria related to each decision maker.
As shown in Table 14, we have calculated the weights of the criteria, which were used in the case study, applying a recombination matrix, specified by the methodology.

5.2. Evaluation of the Best Sustainable Criteria Based on the Analytic Hieratic Process

The second step in the double-decision support system process is to assign weights criteria to the nine decisional criteria considered through an analytic hieratic process (AHP).
The nine decisional criteria considered are:
(C1) Risk of failure; (C2) Average lifetime employment impact of SEAP actions; (C3) Third Party Equity Financing; (C4) Investment Cost Ratio/Energy Saving; (C5) Price Variance in standard Cost Accounting; (C6) Investment Cost for the Municipality; (C7) % Energy reduction; (C8) % CO2 Emission Reduction; and (C9) CO2 Emissions Reduction Cost.
Specific pairwise comparisons (through a structured questionnaire) were drawn up just to involve different types of decision makers in the assignment of weights to these criteria. The questionnaire was sent to experts and insiders (e.g., Public Administration managers, innovation managers, university professors, and environmental issues researchers). By the Data Protection Code, the questionnaire was anonymous. To determine the weights related to the nine decisional criteria of intervention, the procedure contemplates a hierarchy which follows the AHP proposed method. Particularly, the hierarchy allows each decision maker (or typology of decision makers) to assess the importance of the criteria by comparing them in pairs. Every decision maker can make quite simple judgments by comparing from time to time the importance of just two criteria. Thus, the final weights assigned to the criteria will be an average of values given by the different decision makers.
Thanks to the opinions collected, it was possible to apply the AHP method to calculate the weights of the criteria starting from the matrix of pairwise comparisons of criteria related to each decision maker.
As shown in Table 15, we have calculated the weights of the criteria which were used in the case study by applying a recombination matrix, as specified in the methodology.

5.3. Discussion on the Applied Methodology

The application of the methodology described above to a practical case study (i.e., a SEAP of the province of Messina) contributes to the advancement of two different research areas: on the one hand, the theoretical development of criteria interactions in MCDA; on the other hand, to practically obtain the most appropriate selection of RES/RUE actions to support the regional authorities in the implementation of their SEAPs.
Compared to the studies cited in the literature review [12,13,19], this methodology aims to develop and assess a multi-attribute decision-making method suitable for the in-depth analysis of mitigation actions of several SEAPs. This methodology does not provide a ranking of ideal scenarios of sustainable projects in the field of CO2 reduction or energy efficiency but wants to give a suitable tool to the local authorities’ managers to help them in their work to decide the best projects to be financed.

5.3.1. Target of Evaluation of Best Categories for the Area of Intervention

From the results obtained, the decision makers agree that it is a priority to finance projects on the expenditure lines relating to the following categories of actions, in the order proposed below: (1) Transport, (2) Territorial planning, (3) Municipal, Residential, Tertiary buildings, equipment/facilities. Only in 4th place is it considered important to allocate financial resources to local electricity production projects. Another important element from this study emerges, the marginal influence of the actions on the involvement of stakeholders and citizens, which is positioned at number (8).

5.3.2. Target of Evaluation of Sustainability Criteria

The resulting scenario from the expert panel choices shows an equal orientation towards the most energy-saving and CO2 reduction actions. Furthermore, the panel assigned the highest importance to labour impact among the social and economic criteria, locating them in the middle-height priority rank (third place in the rank). The criteria assessing CO2 Emissions Reduction Cost and technical reliability of actions (Risk of failure) are associated with a medium priority rank (4th place in the rank). The other economic criteria, such as Third-Party equity financing or Ratio Cost Investment/Energy Saving or Price Variance in standard Cost Accounting, are associated with a low priority rank.
The outcomes of the distillation procedure confer the final order for this decisional scenario. Each category of intervention area is defined as the area with the best design alternatives. These design alternatives represent the actions that fulfil the objectives that the decision maker has fixed.
A milestone will be the first monitoring phase in the next two years to realise if the promised targets will be achieved soon and in an expected way.
To sum up, the proposed methodology can help the regional authorities to identify the categories of intervention areas to allocate the financial resources, and then select the best design alternatives to improve integration in urban energy systems associated with GHG emission reduction.

6. Conclusions

This study presents a methodology based on a multi-criteria decision divided into two macro-phases. The first phase allows a ranking evaluation of the eight categories of criteria on provided SEAP actions based on the analytic hieratic process. The second phase assigns the weights to the nine decisional criteria, based on the three pillars of sustainability, considered through an analytic hierarchy process. The application of this methodology to the SEAPs targets of 64 municipalities of Messina province will lead to evaluating the ranking of CO2 reduction of local eligible technological projects. This methodology will be applied to over 1800 strategic actions that have been identified for the reduction of greenhouse gases and energy efficiency.
This methodology also encourages debate and confrontation of criteria among expert group members and can result in a driving factor for the encouragement and addressing of sustainable development at the local level. Consequently, it is possible to assert that objectives derived from the CoM for the development and adoption of sustainable energy action plans (SEAP) can be achieved at the regional level.
As per the current limitations, there are still no objective data about the actual implementation of the analysed SEAPs. An interesting follow-up phase to this research would be the monitoring phase in the next years to assess if the promised targets will be achieved in the expected way and time.

Author Contributions

Conceptualisation, U.D.M.; methodology, U.D.M.; software, U.D.M.; validation, U.D.M.; formal analysis, U.D.M. and S.A.; investigation, U.D.M. and S.A.; resources, U.D.M.; data curation, U.D.M. and S.A.; writing—original draft preparation, U.D.M.; writing—review and editing, S.A.; visualisation, S.A.; supervision, U.D.M.; project administration, U.D.M. All authors have read and agreed to the published version of the manuscript.

Funding

This research received no external funding.

Data Availability Statement

Acknowledgments

Authors would like to thank Antonio Mazzon for his contribution in supplying and analysing data.

Conflicts of Interest

The authors declare no conflict of interest.

References

  1. Yang, L.; Wang, X.-C.; Dai, M.; Chen, B.; Qiao, Y.; Deng, H.; Zhang, D.; Zhang, Y.; de Almeida, C.M.V.B.; Chiu, A.S.; et al. Shifting from fossil-based economy to bio-based economy: Status quo, challenges, and prospects. Energy 2021, 228, 120533. [Google Scholar] [CrossRef]
  2. Kostevšek, A.; Petek, J.; Klemeš, J.J.; Varbanov, P. Municipal energy policy constitution and integration process to establish sustainable energy systems—A case of the Slovenian municipality. J. Clean. Prod. 2016, 120, 31–42. [Google Scholar] [CrossRef]
  3. Peschi, E.; Caputo, A.; Di Cristofaro, E.; Colaiezzi, M.; Pantaleoni, M.; Vitullo, M.; Gaeta, M. La strategia italiana di lungo termine sulla riduzione delle emissioni di gas serra: Scenari emissivi e trend storici. Ing. dDell’ambiente 2021, 8, 3. [Google Scholar]
  4. Dipartimento dell’Energia—Osservatorio Regionale e Ufficio Statistico per l’Energia. Rapporto Energia 2015. Monitoraggio sull’Energia in Sicilia. Available online: https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwjuuMjeqdX6AhWRzDgGHXRgCf4QFnoECBAQAQ&url=http%3A%2F%2Fwww.catastoenergetico.regione.sicilia.it%2FD%2FNEWS%2FRapporto%2520Energia%25202015.pdf&usg=AOvVaw181ysfjgNgzZIhygg7X_uA (accessed on 9 March 2022).
  5. Regione Siciliana, Assessorato Regionale dell’Energia e dei Servizi di Pubblica Utilità, Dipartimento dell’Energia. Aggiornamento Piano Energetico Ambientale della Regione Siciliana—PEARS 2030—RAPPORTO PRELIMINARE. 2019. Available online: https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwjC07uXq9X6AhUBU3wKHezDCCMQFnoECBAQAQ&url=https%3A%2F%2Fpti.regione.sicilia.it%2Fportal%2Fpage%2Fportal%2FPIR_PORTALE%2FPIR_LaStrutturaRegionale%2FPIR_AssEnergia%2FPIR_DipEnergia%2FPIR_Areetematiche%2FPIR_Altricontenuti%2FPIR_PianoEnergeticoAmbientaledellaRegioneSicilianaPEARS%2Frapporto%2520preliminare%2520di%2520VAS%2520rev_16_7_19%2520(1).pdf&usg=AOvVaw2mGjJhWZflmtXbIFtORw_b (accessed on 20 July 2022).
  6. Coelho, S.; Russo, M.; Oliveira, R.; Monteiro, A.; Lopes, M.; Borrego, C. Sustainable energy action plans at city level: A Portuguese experience and perception. J. Clean. Prod. 2018, 176, 1223–1230. [Google Scholar] [CrossRef] [Green Version]
  7. Lee, C.T.; Hashim, H.; Ho, C.S.; Van Fan, Y.; Klemeš, J.J. Sustaining the low-carbon emission development in Asia and beyond: Sustainable energy, water, transportation and low-carbon emission technology. J. Clean. Prod. 2017, 146, 1–13. [Google Scholar] [CrossRef] [Green Version]
  8. Berghia, S. Energy planning for metropolitan context: Potential and perspectives of Sustainable energy action plans (SEAPs) of three Italian big cities. Energy Procedia 2016, 101, 1072–1078. [Google Scholar] [CrossRef]
  9. Cinocca, A.; Santini, F.; Cipollone, R. Monitoring methodologies and tools for the Sustainable Energy Action Plans to support the Public Administration. Energy Procedia 2018, 148, 758–765. [Google Scholar] [CrossRef]
  10. Gagliano, A.; Nocera, F.; D’Amico, A.; Spataru, C. Geographical Information System as Support Tool for Sustainable Energy Action Plan. Energy Procedia 2015, 83, 310–319. [Google Scholar] [CrossRef] [Green Version]
  11. Hilorme, T.; Zamazii, O.; Judina, O.; Korolenko, R.; Melnikova, Y. Formation of risk mitigating strategies for the implementation of projects of energy saving technologies. Acad. Strateg. Manag. J. 2019, 18, 1–6. [Google Scholar]
  12. Marinakis, V.; Doukas, H.; Xidonas, P.; Zopounidis, C. Multicriteria decision support in local energy planning: An evaluation of alternative scenarios for the Sustainable Energy Action Plan. Omega 2017, 69, 1–16. [Google Scholar] [CrossRef]
  13. Beccali, M.; Cellura, M.; Mistretta, M. Decision-making in energy planning. Application of the Electre method at regional level for the diffusion of renewable energy technology. Renew. Energy 2003, 28, 2063–2087. [Google Scholar] [CrossRef]
  14. Nastasi, B.; Di Matteo, U. Solar Energy Technologies in Sustainable Energy Action Plans of Italian Big Cities. Energy Procedia 2016, 101, 1064–1071. [Google Scholar] [CrossRef]
  15. Pohekar, S.; Ramachandran, M. Application of multi-criteria decision making to sustainable energy planning—A review. Renew. Sustain. Energy Rev. 2004, 8, 365–381. [Google Scholar] [CrossRef]
  16. Siskos, E.; Askounis, D.; Psarras, J. Multicriteria decision support for global e-government evaluation. Omega 2014, 46, 51–63. [Google Scholar] [CrossRef]
  17. Ilbahar, E.; Cebi, S.; Kahraman, C. A state-of-the-art review on multi-attribute renewable energy decision making. Energy Strat. Rev. 2019, 25, 18–33. [Google Scholar] [CrossRef]
  18. Teknomo, K. Analytic Hierarchy Process (AHP) Tutorial. Available online: http://people.revoledu.com/kardi/tutorial/AHP/AHP.htm (accessed on 1 April 2015).
  19. Dall’O’, G.; Norese, M.F.; Galante, A.; Novello, C. A Multi-Criteria Methodology to Support Public Administration Decision Making Concerning Sustainable Energy Action Plans. Energies 2013, 6, 4308–4330. [Google Scholar] [CrossRef] [Green Version]
  20. Delponte, I.; Pittaluga, I.; Schenone, C. Monitoring and evaluation of Sustainable Energy Action Plan: Practice and perspective. Energy Policy 2017, 100, 9–17. [Google Scholar] [CrossRef]
  21. Howick, S.; Ackermann, F.; Walls, L.; Quigley, J.; Houghton, T. Learning from mixed OR method practice: The NINES case study. Omega 2017, 69, 70–81. [Google Scholar] [CrossRef] [Green Version]
  22. Cinelli, M.; Coles, S.R.; Kirwan, K. Analysis of the potentials of multi criteria decision analysis methods to conduct sustainability assessment. Ecol. Indic. 2014, 46, 138–148. [Google Scholar] [CrossRef] [Green Version]
  23. Neto, G.C.D.O.; Pinto, L.F.R.; Amorim, M.P.C.; Giannetti, B.F.; de Almeida, C.M.V.B. A framework of actions for strong sustainability. J. Clean. Prod. 2018, 196, 1629–1643. [Google Scholar] [CrossRef]
  24. Keeney, L.R.; Raiffa, H. Decisions with Multiple Objectives: Preferences and Value Tradeoffs; Cambridge University Press: Cambridge, UK, 1993. [Google Scholar]
  25. Dyer, J.S. MAUT—Multiattribute Utility Theory. In Multiple Criteria Decision Analysis: State of the Art Surveys; Springer: New York, NY, USA, 2005; pp. 265–292. [Google Scholar]
  26. De Montis, A.; De Toro, P.; Droste-Franke, B.; Omann, I.; Stagl, S. Assessing the quality of different MCDA methods. In Alternatives for Environmental Valuation; Getzner, M., Getzner, M., Spash, C., Spash, C., Stagl, S., Eds.; Routledge: Abingdon, UK, 2005; pp. 99–133. [Google Scholar]
  27. Covenant of Mayors. Linee Guida per la Presentazione del PAES e dei Rapporti di Monitoraggio; Versione 1.0 (Maggio); Publications Office of the European Union: Luxembourg, 2014. [Google Scholar]
  28. Neves, A.; Blondel, L.; Brand, K.; Hendel Blackford, S.; Rivas Calvete, S.; Lancu, A.; Melica, G.; Koffi Lefeivre, B.; Zancanella, P.; Kona, A. The Covenant of Mayors for Climate and Energy Reporting Guidelines; European Commission, Joint Research Centre, Publications Office: Sevilla, Spain, 2017. [Google Scholar] [CrossRef]
  29. Saaty, T.L. The Modern Science of Multicriteria Decision Making and Its Practical Applications: The AHP/ANP Approach. Oper. Res. 2013, 61, 1101–1118. [Google Scholar] [CrossRef]
  30. Cambridge Econometrics. Assessing the Employment and social Impact of Energy Efficiency; Cambridge Econometrics: Cambridge, UK, 2015. [Google Scholar]
  31. FEACO. Survey of the European Management Consultancy FEACO 2018/2019. 2019. Available online: https://feaco.org/sites/default/files/sitepagefiles/Feaco.Survey%202018-2019.pdf (accessed on 20 July 2022).
  32. International Labour Office (ILO). Skills and Occupational Needs in Renewable Energy; ILO: Geneva, Switzerland, 2011. [Google Scholar]
  33. Unioncamere. Previsioni dei Fabbisogni Occupazionali e Professionali in Italia a Medio Termine (2021–2025); Unioncamere Excelsior: Milan, Italy, 2021. [Google Scholar]
  34. Chiesa, F.V.; Frattini, M. Chiesa Valutazione Tecnico-Economica delle Soluzioni per L’efficienza Energetica Negli Edifici Della Pubblica Amministrazione, Report RdS/PAR2013/111. Available online: https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwjtzszxrNX6AhWBFbcAHTPMCYoQFnoECAgQAQ&url=https%3A%2F%2Fwww.enea.it%2Fit%2FRicerca_sviluppo%2Fdocumenti%2Fricerca-di-sistema-elettrico%2Fedifici-pa%2F2013%2Frds-par2013-111.pdf&usg=AOvVaw2zsCMRAFru1YCjDtgTVwJQ (accessed on 20 July 2022).
  35. World Bank Group. State and Trends of Carbon Pricing 2019; License: CC BY 3.0 IGO; World Bank: Washington, DC, USA, 2019; Available online: https://openknowledge.worldbank.org/handle/10986/31755 (accessed on 20 July 2022).
  36. Di Matteo, U.; Pezzimenti, P.M.; Astiaso Garcia, D. Methodological Proposal for Optimal Location of Emergency Operation Centers through Multi-Criteria Approach. Sustainability 2016, 8, 50. [Google Scholar] [CrossRef] [Green Version]
  37. Doukas, H.; Papadopoulou, A.; Savvakis, N.; Tsoutsos, T.; Psarras, J. Assessing energy sustainability of rural communities using Principal Component Analysis. Renew. Sustain. Energy Rev. 2012, 16, 1949–1957. [Google Scholar] [CrossRef]
  38. Agostinelli, S.; Cumo, F.; Guidi, G.; Tomazzoli, C. Cyber-Physical Systems Improving Building Energy Management: Digital Twin and Artificial Intelligence. Energies 2021, 14, 2338. [Google Scholar] [CrossRef]
Figure 1. The logical framework of the proposed integrated methodology.
Figure 1. The logical framework of the proposed integrated methodology.
Energies 15 07487 g001
Figure 2. Territorial area covered by the SEAP in the province of Messina.
Figure 2. Territorial area covered by the SEAP in the province of Messina.
Energies 15 07487 g002
Figure 3. Energy consumption distribution by sector (2011).
Figure 3. Energy consumption distribution by sector (2011).
Energies 15 07487 g003
Figure 4. Per capita CO2 emission (tCO2/inh) in Messina’s province.
Figure 4. Per capita CO2 emission (tCO2/inh) in Messina’s province.
Energies 15 07487 g004
Figure 5. SEAP resources for Public Administration.
Figure 5. SEAP resources for Public Administration.
Energies 15 07487 g005
Table 1. Selected Criteria.
Table 1. Selected Criteria.
DimensionsCriteriaUnit
Socialc1—Risk of failureVery High, High, Medium, Low
c2—average lifetime employment impact of SEAP actionsVery High, High, Medium, Low, Very Low
c3—Third Party Equity Financing%
Economicc4—Ratio Cost Investment/Energy SavingEUR/kWh
c5—Price Variance in standard Cost Accountingnumber
c6—Investment Cost for the Municipality EUR/inh
Environmentalc7—% Energy reduction%
c8—% CO2 Emission Reduction%
c9—CO2 Emissions Reduction CostEUR/ton
Table 2. Structural project failure risk.
Table 2. Structural project failure risk.
Structural ProjectsScaleScoreKnowledge Development. Training/
Awareness Raising. Planning
ScaleScore
Feasibility studyVery High0.0
Preliminary designHigh0.5
Final designMedium0.7Pre-Feasibility studyMedium0.7
Construction designLow1.0Preliminary designLow1.0
Table 3. The employment impact of SEAP actions.
Table 3. The employment impact of SEAP actions.
SEAP’s Project Actions TypeNew Jobs/M EUR InvestmentScaleScore
Advice, training 0–1Very Low0.00
Energy Audit, Analysis, Study, Plan1–3Low0.25
Biomass/wind Plant3–6Medium0.50
Solar PV Plant6–15High0.75
Building Retrofitting, Mobility, Street lighting>15Very High1.00
Table 4. The standard cost of investment.
Table 4. The standard cost of investment.
Types of ActionStandard Cost (EUR/ton CO2)
Public buildings refurbishment13,200.00
Energy efficiency interventions for public lighting systems1750.00
Energy efficiency interventions for public school buildings2600.00
Refurbishment and energy requalification of private houses and hotels2600.00
Energy efficiency in the industrial electrical sector2400.00
Energy efficiency in the industrial thermal sector1650.00
Combined heat and power (CHP)3000.00
Table 5. CO2 emissions by sector.
Table 5. CO2 emissions by sector.
SectortCO2/year%
Municipal buildings, equipment/facilities32,955.682.66%
Public lighting26,394.672.13%
Tertiary (non-municipal) buildings, equipment/facilities232,195.7518.76%
Residential buildings405,498.8632.76%
Industry (non-ETS)186,364.9615.05%
Agriculture, Forestry, Fisheries5817.490.47%
Municipal fleet1668.540.13%
Public transport5093.990.42%
Private and commercial transport341,981.3527.62%
Total1,237,971.29100.00%
Table 6. Energy consumption distribution (MWh/year).
Table 6. Energy consumption distribution (MWh/year).
SectorMWh/y%
Municipal buildings, equipment/facilities150,622.773.77%
Tertiary (non-municipal) buildings, equipment/facilities580,938.3114.52%
Residential buildings1,307,580.9132.69%
Industry (non-ETS)594,399.8714.86%
Agriculture, Forestry, Fisheries20,137.510.50%
Public, private, and commercial transport 1,346,078.3133.66%
Total3,999,757.68100.00%
Table 7. CO2 Emissions by fuels.
Table 7. CO2 Emissions by fuels.
FuelstCO2%
Electricity617,470.9849.9%
Natural gas176,629.8214.3%
Diesel fuel222,569.7618.0%
Liquefied Petroleum Gases (LPG)34,178.922.8%
Gasoline142,945.9511.5%
Other fossil fuels26,948.272.2%
Biomass556.090.0%
Coal coke7639.510.6%
Fuel oil403.950.0%
Heating oil8628.040.7%
Total1,237,971.29100.00
Table 8. Resource allocation SEAP actions.
Table 8. Resource allocation SEAP actions.
TypeMWhtCO2EURCost%
A1. Municipal, residential, tertiary buildings, equipment/facilities
A 1.1—Municipal buildings, equipment/facilitiesPA105,865.3431,642.33130,545,951.896.368%
A 1.2—Tertiary (non-municipal) buildings, equipment/facilitiesP21,382.359035.137,492,150.000.365%
A 1.3—Residential buildingsP211,947.3361,964.09524,269,076.2525.574%
A 1.4—Public lightingPA20,728.759013.9437,249,003.671.817%
A 1.5—Industries non-ETSP15,007.295336.227,799,507.000.380%
A2. Transport
A 2.1—Municipal fleetPA3042.00869.8921,405,790.001.044%
A 2.2—Public transportPA34,150.798853.5425,184,900.001.229%
A 2.3—Private and commercial transportP161,279.6343,592.211,146,133,700.0055.908%
A3. Local electricity production
A 3.1—Hydroelectric powerP1066.01482.121,670,725.710.081%
A 3.2—Wind powerP1441.581833.5914,473,000.000.706%
A 3.3—PhotovoltaicsP43,290.2332,792.23107,997,225.005.268%
A 3.4—Combined Heat and Power P1026.782112.342,960,000.000.144%
A 3.5—Other local electricity production P4560.001710.645,750,000.000.280%
A4. Local heat/cold production
A 4.1—Combined Heat and PowerP0.000.000.000.000%
A 4.2—District heatingP0.000.000.000.000%
A 4.3—CHP Plants P1351.301161.207,452,550.000.364%
A5. Territorial planning
A 5.1—Urban planning and regulationsPA17,341.583820.243,838,500.000.187%
A 5.2—Transport and mobility planningPA1981.66568.501,283,000.000.063%
A 5.3—Standards for refurbishment and new developmentPA67,636.0514,494.04366,500.000.018%
A6. Public procurement of products and services
A 5.1—Energy efficiency requirements/standards PA1030.99358.2836,000.000.002%
A 5.2—Renewable energy requirements/standards PA144.2283.3732,912.000.002%
A 5.3—Other model of public procurement and servicesPA2934.022113.9661,500.000.003%
A7. Working with the citizens and stakeholders
A 7.1—Advisory services PA0000.000%
A 7.2—Financial support and grantsPA1475.94427.2244,000.000.002%
A 7.3—Awareness raising and local networkingPA47,065.2516,268.831,251,200.000.061%
A 7.4—Other stakeholder involvementPA26,575.3514,284.74103,500.000.005%
A 7.5—Training and educationPA359.30152.11212,600.000.010%
A8. Other
A 8.1—Waste managementPA340.00306.0260,100.000.003%
A 8.1—OtherPA633.20286.63630,000.000.031%
A 8.2—AgriculturePA59.18201,740,000.000.085%
Total 793,716.12263,583.412,050,043,391.52100.000%
“PA” stands for public administration, and “P” for private.
Table 9. Funding is required for SEAP Actions.
Table 9. Funding is required for SEAP Actions.
Category of Action AEUR%
A1Municipal, Residential, Tertiary buildings, equipment/facilitiesEUR 707,355,688.8134.50%
A2TransportEUR 1,192,724,390.00 58.18%
A3Local electricity productionEUR 132,850,950.71 6.48%
A4 Local heat/cold productionEUR 7,452,550.00 0.36%
A5Territorial planningEUR 5,488,000.00 0.27%
A6Public procurement of products and servicesEUR 130,412.00 0.01%
A7Involvement of stakeholders and citizensEUR 1,611,300.00 0.08%
A8OtherEUR 2,430,100.00 0.12%
TotalEUR 2,050,043,391.52100.00%
Table 10. SEAP resources for Public Administration.
Table 10. SEAP resources for Public Administration.
Public SectorsEUR%
Municipal buildings, equipment/facilities130,545,951.8942.68%
Public lighting37,249,003.6712.18%
Municipal fleet21,405,790.007.00%
Training, awareness, and involvement of stakeholders1,251,200.000.41%
Strategic target setting and planning, sustainable building regulations, green public procurement5,023,412.001.64%
Other2,430,100.000.79%
PV energy production plants107,997,225.0035.30%
Total305,902,682.56100.00%
Table 11. Economic budget for SEAPs RES plants.
Table 11. Economic budget for SEAPs RES plants.
Energy SourceEUR%
A 3.1—Hydro energyEUR 1,670,725.71 1.26%
A 3.2—Wind energyEUR 14,473.000.0010.89%
A 3.3—PV energyEUR 107,997,225.00 81.29%
A 3.4—Combined Heat and PowerEUR 2,960,000.00 2.23%
A 3.5—Other energy plantsEUR 5,750,000.00 4.33%
TotalEUR 132,850,950.71 100.00%
Table 12. Categorisation of the actions.
Table 12. Categorisation of the actions.
CategorisationArea of Intervention
A1Municipal, Residential, Tertiary buildings, equipment/facilities
A2Transport
A3Local electricity production
A4Local heat/cold production
A5Territorial planning
A6Public procurement of products and services
A7Involvement of stakeholders and citizens
A8Other sectors
Table 13. Factors’ preference possible choices for decision makers.
Table 13. Factors’ preference possible choices for decision makers.
ValueInterpretation
1Both compared elements contribute equally to achieving the goal.
3Opinions and experiences gently prefer one element over another.
5Opinions and experiences strongly prefer one element over another.
7Opinions and experiences very strongly prefer one element over another.
9Opinions and experiences completely prefer one element over another.
2, 4, 6, 8It is used to express an intermediate level of preference.
Table 14. Weighted scores matrix.
Table 14. Weighted scores matrix.
CriterionWeights+/−
1A1Municipal, Residential, Tertiary buildings, equipment/facilities16.7%7.9%
2A2Transport30.0%11.9%
3A3Local electricity production9.4%5.2%
4A4Local heat/cold production6.9%2.9%
5A5Territorial planning27.5%11.2%
6A6Public procurement of products and services 3.4%2.3%
7A7Involvement of stakeholders and citizens1.9%1.2%
8A8Other sectors4.2%2.3%
Table 15. Weighted scores’ matrix.
Table 15. Weighted scores’ matrix.
CriterionWeights+/−
1C1Risk of failure11.4%4.5%
2C2Average lifetime employment impact of SEAP actions19.8%6.0%
3C3Third Party Equity Financing1.7%0.4%
4C4Ratio Cost Investment/Energy Saving3.9%1.7%
5C5Price Variance in standard Cost Accounting1.6%0.6%
6C6Investment Cost for the Municipality 3.9%1.7%
7C7% Energy reduction22.5%7.3%
8C8% CO2 Emission Reduction22.5%7.3%
9C9CO2 Emissions Reduction Cost12.7%4.6%
Publisher’s Note: MDPI stays neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Share and Cite

MDPI and ACS Style

Di Matteo, U.; Agostinelli, S. Big Data Analysis for Optimising the Decision-Making Process in Sustainable Energy Action Plans: A Multi-Criteria Evaluation Approach Applied to Sicilian Regional Recovery and Resilience Plans. Energies 2022, 15, 7487. https://doi.org/10.3390/en15207487

AMA Style

Di Matteo U, Agostinelli S. Big Data Analysis for Optimising the Decision-Making Process in Sustainable Energy Action Plans: A Multi-Criteria Evaluation Approach Applied to Sicilian Regional Recovery and Resilience Plans. Energies. 2022; 15(20):7487. https://doi.org/10.3390/en15207487

Chicago/Turabian Style

Di Matteo, Umberto, and Sofia Agostinelli. 2022. "Big Data Analysis for Optimising the Decision-Making Process in Sustainable Energy Action Plans: A Multi-Criteria Evaluation Approach Applied to Sicilian Regional Recovery and Resilience Plans" Energies 15, no. 20: 7487. https://doi.org/10.3390/en15207487

Note that from the first issue of 2016, this journal uses article numbers instead of page numbers. See further details here.

Article Metrics

Back to TopTop