Mastering data challenges and methodology selection for peak performance

As companies increasingly recognize the importance of understanding and mitigating their environmental footprint, the choice of calculation method becomes crucial. In this blog post, we compare two fundamental approaches: the spend-based methodology and the activity-based methodology, highlighting the significance of data availability in shaping this decision. Join us as we navigate the intricate landscape of GHG calculations, aiding you in choosing the right path for your business's sustainability journey.

One of the most significant challenges faced by companies is ensuring the accuracy and availability of data crucial for calculating greenhouse gas (GHG) emissions. A common issue is that data related to consumption, procurement, and production is sourced from disparate ERP systems, lacking consistency and coherence. An issue that we faced recently in the context of calculating scope 3.1 and 3.4 emissions, was that the provided data related to material procurement suffered from three primary issues: lack of harmonization, inconsistency, and crucial missing elements at the product individual levels such as material ids, supplier ids or units of measurements among others.

Methodology

The primary concern stemming from data inconsistency led to the realization that utilizing a singular calculation method for determining GHG emissions would not be the optimal approach. In this scenario, the data could be segregated into two distinct groups based on their characteristics:

  • First group: Procurement information for purchased products/materials featured standard metrics for units of measure such as lt, kg, g, gal.
  • Second group: Procurement information for purchased products/materials featured units of measure like pce, dozen, crate, etc., with no conversion factor to the standard metric unit of measure, and the eur spend amount on procurement was provided. In some cases, no unit of measure was provided, only the eur spent the amount on the procurement.

Each group's data characteristics aligned with the requirements of two different greenhouse gas calculation methodologies, each employing a distinct strategy to quantify and analyze emissions, primarily focusing on operational activities (activity-based) or financial expenditures (spend-based). The first data group met the criteria for the activity-based methodology and the second data group aligned with the spend-based methodology requirements. 

The activity-based methodology provides a more precise and detailed understanding of emissions by directly measuring activities and their associated emissions. Although it requires extensive data collection in terms of emission factors, it is a complex, resource-intensive, and time-consuming process. Conversely, the spend-based methodology is easier and less resource-intensive for gathering emission factor-related data compared to detailed activity-level data. However, it lacks precision compared to activity-based methodologies, relying on assumptions and average emission factors associated with expenditure categories which are at the same time volatile due to impacts of inflation, exchange rates, etc.  These simplified assumptions can lead to either overestimation or underestimation of emissions, as they do not capture specific operational nuances.

Data harmonization

In ideal circumstances, a product purchased from a supplier would include minimal mandatory information such as product identification, supplier identification and purchased amount. Unfortunately, reality often differs, especially when data is pulled from various invoices and erp systems. In this case, a deep analysis of such items is required to understand which assumptions can be used to fill the gaps.

Conclusion

In the realm of sustainability and environmental responsibility, accurately calculating greenhouse gas (GHG) emissions is a critical endeavor for businesses. Our exploration of this blog post has shed light on a prevalent challenge faced by many companies - the struggle with data harmonization. This issue encompasses a lack of standardization, inconsistencies, and crucial missing elements at the individual product level within consumption, procurement, and production data.

Navigating this challenge is one of your key assets with our carbon accounting services.  Instead of a one-size-fits-all approach, we build an individual successful approach for you as part of our carbon maturity assessment service offering. Based on the results, we can offer you the right approach to tackle your carbon accounting strategy, ranging from consulting services where we support you with the carbon footprint calculations and going to implementing a professional carbon accounting solution for automated regular calculations.

In this journey, we've acknowledged that many companies grapple with similar data challenges. Bridging these data gaps necessitates prudent assumptions, resembling puzzle pieces that complete the picture.

SAP Sustainability Footprint Management

SAP Sustainability Footprint Management

Join us in embracing the complexity of GHG calculations, for it is through informed choices and continuous refinement that we pave the way for a greener, more sustainable future. 

Contact our experts

Get the latest news about Emissions Calculation