How can you use data analytics to select the best suppliers considering indicators for sustainability and social indicators?

Sustainable sourcing is the process of integrating social, ethical and environmental performance factors when selecting suppliers.

This involves assessing and evaluating suppliers based on a set of sustainability criteria, such as labour rights, health and safety, environmental impact, human rights, and more.

_{Assessment of Suppliers based on Environmental Factors — (Image by Author)}

The aim is to minimize the negative impacts on the environment and maximize the positive social impacts.

Once you established measurable sustainability targets, you can use data analytics to assess suppliers' performances to select the best one to optimize your objective (cost reduction, CO2 emissions) while respecting social and environmental constraints.

Use data analytics to automatically select the best supplier with a mix of economic and environmental constraints

In this article, we will discover how to use data analytics to design an optimal Supply Chain Network to minimize costs and environmental impacts.

Sustainable sourcing KPIs

Scenario: T-shirts Suppliers

Let us take the example used in the previous articles about life cycle assessment and circular economy.

You are a logistic performance manager in an international clothing group that has stores all around the world.

_{Fast Fashion Company Circular Economy — (Image by Author)}

The company is sourcing garments, bags and accessories from factories located in Asia.

Stores are delivered from local warehouses that are directly replenished by factories.

How can you select t-shirt suppliers to minimize your costs while respecting environmental and social constraints?

^{Life Cycle Assessment of Sourcing from Raw Materials to Warehouse Delivery — (Image by Author)}

Carbon emissions

The major indicator that will drive your sustainability roadmap is the carbon footprint of the supply chain.

This can be measured by calculating the total emissions of greenhouse gases such as carbon dioxide, methane, and nitrous oxide.

💡 What should we consider?

• Emissions during the cultivation of the cotton used for your t-shirts
• Emissions from electricity generation and chemicals used for t-shirt production
• Transportation of the finished goods (t-shirt) from the factory to the central distribution centre by sea-freight

^{Formula using Emission Factor for Transportation — (Image by Author)}

With,
E_CO2: emissions in kilograms of CO2 equivalent (kgCO2eq)
W_goods: weight of the goods (Ton)
D: distance from your warehouse to the final destination(km)
F_mode: emissions factor for each transportation mode (kgCO2eq/t.km)

+

Another indicator is the amount of energy consumed by the supplier to produce and deliver products.

It can be measured in terms of the amount of energy used per production unit (called functional units in the Life Cycle Assessment Methodology).

💡 What should we consider?

• Energy consumption for cotton cultivation
• Energy consumption for spinning, weaving and dying
• Energy consumption for transportation

Water usage

As it becomes a scarce resource, new regulations are pushing companies to redesign their processes for water consumption reduction.

With this indicator, you can constrain your sourcing and focus on suppliers that do not affect the local water supply.

💡 What should we consider?

• Water consumption for cotton cultivation
• Water consumption for spinning, weaving and dying

Waste generation

Measuring the amount of waste generated during the production process can help identify areas where waste can be reduced and where more sustainable production methods can be adopted.

💡 What should we consider?

• Solid waste generation during production

📊 How to organize data collection?

If you are a supplier and you need to provide this kind of reporting you can get the support of data analytics tools to automate it.

_{Data Lake for Reporting — (Image by Author)}

A data lake can be used as a central source of unstructured and structured data (databases, excel files, …).

You can implement automated pipelines to extract, process and analyze these data to build reports and provide insights.

Social indicators

They include indicators for labour rights, fair pay, and safe working conditions to assess suppliers’ performance in terms of social sustainability.

You can conduct your own audits or use third-party assessments.

💡 How to Measure it?
In the scorecard below, your company assigns a weight to each of the criteria, which represents the importance of that criteria in the overall evaluation.

_{Example of Score Cards — (Image by Author)}

The auditors calculate a score linked to each criterion to represent the supplier’s performance.

The total score is calculated by multiplying each criteria’s score by its weight and summing the results.

Environmental indicators

They are used to assess if your suppliers are meeting environmental standards focusing on energy efficiency, resource management, chemical usage and greenhouse gas emissions.

💡 How to Measure it?
A similar methodology can be used with the help of a scorecard.

^{Example of Score Cards vione ards  — (Image by Author)}

You can get support from governmental agencies and get checklists to support you in assessing the score for each criterion.

Sourcing network design

At this stage, you have collected information about your suppliers and performed audits with scoring.

You are now ready to use this data to drive decisions, design sourcing and logistics networks to deliver your stores.

_{Supplier Selection Process — (Image by Author)}

We will use an example with dummy data to understand how to implement a data-driven methodology to select your suppliers considering environmental factors.

Problem statement

You want to redefine the Supply Chain Network of your fast fashion retail company for the next 5 years.

You have stores in 5 different markets around the world (USA, Germany, Japan, India and Brazil).

In each market, you can select a supplier to produce your t-shirts and you have the choice to source from abroad.

^{Suppliers Network Design — (Image by Author)}

You would like to select the right set of suppliers to minimize the cost of production and delivery considering

• The demand of each market (million units per month)
• Fixed and variable costs of production in each country
• Transportation costs from the factory to the market by sea freight

^{Total cost of production and delivery — (Image by Author)}

Your overseas suppliers are cheaper but you need to pay high freight costs to deliver to your market.

^{Fixed & Variable Costs by Country of Production — (Image by Author)}

Therefore, you need the support of linear programming to make the tradeoff for outsourcing.

Initial solution: minimize costs

If you define the objective function to minimize the costs, you can easily guess that it will maximize the volume produced in India and Brazil.

💡 Insights

• In this case, the increased freight costs of sourcing overseas are compensated by the low production costs of India and Brazil

Sustainable supply chain

In the context of green transformation, your company is implementing a sustainability roadmap to reduce the environmental impacts of your supply chain.

Therefore, your procurement team has contacted local suppliers in your predominant markets (USA, Japan).

The idea is to redesign the network of suppliers considering

• CO2 emissions from production and transportation
• Energy and water usage for production
• Waste generated by the factories

What would be the impact on your sourcing network?

Test 1: Energy and Water Savings Criterion

Let us experiment what would be the impact of implementing constraints on the average consumption of energy and water per unit produced.

Your suppliers in Germany and Japan have invested to reduce the environmental impact of their operations.

You would like to add the following constraints

• Average water consumption below 3000 L/Unit
• Average energy usage below 685 MJ/Unit

💡 Insights

• The model decided to keep producing in India because of the very competitive costs
• But it has switched from Brazil to Germany to compensate for the impact and reduce the average water consumption of water and energy
• Germany and Japan are localizing their production

Test 2: Add CO2 emissions constraints

Transportation accounts for a large part of the CO2 footprint of your Supply Chain.

Therefore, you would like to reduce the impact of upstream flows by limiting the CO2 emissions of

• Cultivation and Production per unit kg CO2e/Unit
• Transportation by sea freight kg CO2e/Unit
• Total Emissions must be on average below 110 kg CO2e/Unit

💡 Insights

• For the first time, India has the lowest production output
• Brazil is a solution to keep manufacturing costs low while limiting CO2 emissions
• USA suppliers have not invested enough in sustainable production facilities to be retained for the domestic market supply

Conclusion

You can easily add constraints in your model of supplier selection to apply your green transformation initiatives.

In our example, we can see that CO2 emissions constraints can lead to a localization (quasi-localization) of the production to reduce the impact of transportation. 

As you can expect, these additional constraints have an impact on the total costs of production.

These results can trigger strategic discussions to find the right balance between sustainable sourcing and cost reduction.