{"id":1111,"date":"2025-01-11T07:02:45","date_gmt":"2025-01-11T07:02:45","guid":{"rendered":"https:\/\/mailitics.com\/index.php\/2025\/01\/11\/sustainable-business-strategy-with-data-analytics-ce27180f8ddb\/"},"modified":"2025-01-11T07:02:45","modified_gmt":"2025-01-11T07:02:45","slug":"sustainable-business-strategy-with-data-analytics-ce27180f8ddb","status":"publish","type":"post","link":"https:\/\/mailitics.com\/index.php\/2025\/01\/11\/sustainable-business-strategy-with-data-analytics-ce27180f8ddb\/","title":{"rendered":"Sustainable Business Strategy with Data Analytics"},"content":{"rendered":"<p>    Sustainable Business Strategy with Data Analytics<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n    <!-- no image --><br \/>\n \t<BR><br \/>\n<BR><\/BR><\/p>\n<div>\n<h4>Use data analytics to help companies design and implement strategic sustainability roadmaps to reduce their environmental footprint.<\/h4>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2A_AWULdNSKIY2bPMCZpEyog.png?ssl=1\"><figcaption>Sustainable Business Strategy with Analytics\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Consensus means that everyone agrees to say collectively what no one believes individually.<\/p>\n<p>This quote captures a critical issue many companies face during their strategic green transformation: aligning diverse objectives across teams and departments.<\/p>\n<blockquote><p>Sustainability Team: \u201cWe need to reduce emissions by\u00a030%\u201d.<\/p><\/blockquote>\n<p>Imagine a hypothetical manufacturing company with, at the centre of its business strategy, an <strong>ambitious target of reducing CO2 emissions by\u00a030%.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Illustration of a supply chain flow showing five stages: Factory, Freight, Warehouse, Delivery, and Customers. The icons represent each stage: a factory with a worker, freight involving air and sea transport, a warehouse with stacked boxes, a delivery truck, and a retail store alongside a residential home labeled \u2018Customers\u2019.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2Armn83XaGsA0hsJRVTtZAEg.png?ssl=1\"><figcaption>Value chain of our example\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>The sustainability team&#8217;s challenge is to enforce process changes that may disrupt the activities of multiple departments along the value\u00a0chain.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Illustration of stakeholders involved in sustainability. At the top, a globe with leaves represents sustainability. Below are icons for various roles: a retail store, a finance manager holding a money bag, a warehouse with stored goods, and a logistics manager with a checklist, symbolizing collaboration across departments.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2An9Q3hpndPMMpIW1Wgcsyng.png?ssl=1\"><figcaption>Sustainability Project Steering Committee\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<blockquote><p>How do you secure the approval of multiple stakeholders, that potentially have conflicting interests?<\/p><\/blockquote>\n<p>In this article, we will use this company as an example to illustrate how analytics models can support sustainable business strategy.<\/p>\n<h3>How to Build a Sustainability Roadmap?<\/h3>\n<p>You are a <strong>Data Science Manager<\/strong> in the Supply Chain department of this <strong>international<\/strong> <strong>manufacturing group.<\/strong><\/p>\n<p>Under pressure from shareholders and European regulations, your CEO set ambitious targets for <strong>reducing the environmental footprint by\u00a02030.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Illustration of a sustainability-focused project governance structure. A CEO at the top directs a sustainability initiative represented by a globe with leaves. Below, four stakeholders are involved: retail (a store), finance (a manager with a money bag), warehousing (a warehouse), and logistics (a manager with a checklist), symbolizing collaborative efforts.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2ARKycZzad1XhKu-FMOz0fRA.png?ssl=1\"><figcaption>Stakeholders Involved in the Process\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>The <strong>sustainability department<\/strong> leads a cross-functional transformation program involving multiple departments working together to implement green initiatives.<\/p>\n<h4>Sustainable Supply Chain Network Optimization<\/h4>\n<p>To illustrate my point, I will focus on <strong>Supply Chain Network Optimization.<\/strong><\/p>\n<p>The objective is to redesign the network of factories to meet market demand while optimizing cost and environmental footprint.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Icons representing various factory setups: small retail-like factories and a larger industrial-looking facility, each labeled with varying capacity levels. The illustration highlights different manufacturing setups to compare production capabilities or scale.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/924\/1%2AoKct8eSG_hHzOqpuVK5GvQ.png?ssl=1\"><figcaption>Five Markets of our Manufacturing Company\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>The total demand is<strong> 48,950 units per month, spread across five markets: Japan, the USA, Germany, Brazil,<\/strong> and\u00a0India.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Doughnut chart showing demand distribution by market location. The USA accounts for 57.2%, Japan for 34.7%, India for 3.27%, Brazil for 2.96%, and Germany for 1.84%. The chart visually compares market share for demand distribution.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/600\/1%2AIJPmpIwAePFesf4_nHc9Ag.png?ssl=1\"><figcaption>Demand Distribution per Market\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Markets can be categorized based on customer purchasing power:<\/p>\n<ul>\n<li>\n<strong>High-price markets <\/strong>(USA, Japan and Germany) account for 93.8% of the demand but have <strong>elevated production costs<\/strong>.<\/li>\n<li>\n<strong>Low-price markets <\/strong>(Brazil and India) only account for <strong>6.2%<\/strong> of the demand, but <strong>production costs are more competitive.<\/strong>\n<\/li>\n<\/ul>\n<blockquote><p>What do we want to\u00a0achieve?<\/p><\/blockquote>\n<blockquote><p>Meet the demand at the lowest cost with a reasonable environmental footprint.<\/p><\/blockquote>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Map illustrating supply chain manufacturing sites across the globe. Two views are presented: one highlighting low-capacity sites and another for high-capacity sites. Additional information includes production costs (fixed and variable) and freight costs for delivering goods from factories to markets.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2Ap-6MgEa-cgse119mpbOvvQ.png?ssl=1\"><figcaption>Market Demand vs. Supply Capacity\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>We must decide<strong> where to open factories<\/strong> to balance cost and environmental impacts (CO2 Emissions, waste, water and energy\u00a0usage).<\/p>\n<p><strong>Manufacturing Capacity<br \/><\/strong>In each location, we can open low or high-capacity plants.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Bar chart comparing production capacity by location, with low capacity at 5,000 units per month (blue bars) and high capacity at 15,000 units per month (red bars). Locations include the USA, Germany, Japan, Brazil, and India.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/proxy\/1%2A3vYv1yL1ICWB-yBkMf47rA.png?ssl=1\"><figcaption>Production Capacity per Location\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p><strong>Fixed Production Costs<br \/><\/strong>High-capacity plants have elevated fixed costs but can achieve economies of\u00a0scale.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Bar chart displaying fixed costs by production location and site type. Costs are divided between low-capacity sites (blue bars) and high-capacity sites (red bars). Locations include the USA, Germany, Japan, Brazil, and India, with the USA and Japan showing the highest fixed costs.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2A9Eb65W2cqM78BRGAZpyIjw.png?ssl=1\"><figcaption>Fixed Production Costs\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<blockquote><p>A high-capacity plant in India has lower fixed costs than a low-capacity plant in the\u00a0USA.<\/p><\/blockquote>\n<p>Fixed costs per unit are lower in an Indian high-capacity plant (used at full capacity) than in a US low-capacity factory.<\/p>\n<p><strong>Variable Costs<br \/><\/strong>Variable costs are mainly driven by labour costs, which will impact the competitiveness of a location.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Bar chart illustrating variable costs per unit produced by location. Costs are shown in euros per unit, with the USA and Germany having the highest costs (120 and 130 \u20ac\/unit, respectively), while Brazil and India have the lowest costs (80 and 50 \u20ac\/unit)\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AXL-9eFy4aWikclw5vYs1-w.png?ssl=1\"><figcaption>Production Costs per Location\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>However, we need to add freight delivery rates from the factory to the markets in addition to production costs.<\/p>\n<p>If you move the production (for the North American market) from the USA to India, you will reduce production costs but incur additional freight\u00a0costs.<\/p>\n<blockquote><p>What about the environmental impacts?<\/p><\/blockquote>\n<p>Manufacturing teams collected indicators from each plant to calculate the impact per unit produced.<\/p>\n<ul>\n<li>\n<strong>CO2 emissions<\/strong> of the freight are based on the distance between the plants and their\u00a0markets.<\/li>\n<li>Environmental indicators include CO2 emissions, waste generated, water consumed and energy\u00a0usage.<\/li>\n<\/ul>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Maps comparing the environmental footprints of logistics and manufacturing by country. The left map shows freight emissions routes from factories to markets. The right map highlights CO2 emissions, water usage, waste generation, and energy usage for production in various countries.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AAd--pl8D7OCLckUA0Xf39g.png?ssl=1\"><figcaption>Environmental Footprint of Manufacturing &amp; Logistics\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>We take the average output per unit produced to simplify the\u00a0problem.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Four bar charts showing environmental impacts per production location: (1) Energy usage (MJ\/unit) with India having the highest at 780, (2) Water usage (L\/unit) with India leading at 3,500, (3) CO2 emissions (kgCO2eq\/unit) with India highest at 41, and (4) Waste generation (kg\/unit) with India at 0.78.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/704\/1%2AcDagaGYCmCFtapFwk50XRQ.png?ssl=1\"><figcaption>Environmental Impact per unit produced for each location\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>For instance, producing a single unit in India requires 3,500 litres of\u00a0water.<\/p>\n<p>To summarize these four graphs, high-cost manufacturing locations are \u201cgreener\u201d than low-cost locations.<\/p>\n<p>You can sense the conflicting interests of reducing costs and minimizing environmental footprint.<\/p>\n<blockquote><p>What is the optimal footprint of factories to minimize CO2 Emissions?<\/p><\/blockquote>\n<h4>Data-driven Supply Chain Network\u00a0Design<\/h4>\n<p>If we aim to reduce the environmental impact of our production network, the <strong>trivial answer is to produce only in high-end \u201cgreen\u201d facilities.<\/strong><\/p>\n<p>Unfortunately, this may raise additional questions:<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Illustration of stakeholder concerns in sustainability projects: a retail store questioning costs of goods sold in low-price markets, a financial manager evaluating profitability, a warehouse manager assessing logistics flows, and a logistics worker addressing variable costs in green locations, all connected under a sustainability initiative symbolized by a globe with leaves.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2ASTy3Ln5RIBTsPhawQ03UdA.png?ssl=1\"><figcaption>Steering Committee questions\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<ul>\n<li>\n<strong>Logistics Department: <\/strong>What about the CO2 emissions of transportation for countries that don\u2019t have green facilities?<\/li>\n<li>\n<strong>Finance Team: <\/strong>How much will the overall profitability be impacted if we move to costly facilities?<\/li>\n<li>\n<strong>Merchandising:<\/strong> If you move production to expensive \u201cgreen\u201d locations, what will happen to the cost of goods sold in India and\u00a0Brazil?<\/li>\n<\/ul>\n<p>These are questions that your steering committee may raise when the sustainability team pushes for a specific network\u00a0design.<\/p>\n<p>In the next section, we will simulate each initiative to measure the impact on these KPIs and give a complete picture to all stakeholders.<\/p>\n<h3>Data Analytics for Sustainable Business\u00a0Strategy<\/h3>\n<p><a href=\"https:\/\/towardsdatascience.com\/data-science-for-sustainable-sourcing-a72f2c4db424\">In another article<\/a>, I introduce the model we will use to illustrate the complexity of this exercise with two scenarios:<\/p>\n<ul>\n<li>\n<strong>Scenario 1<\/strong>: your finance director wants to <strong>minimize the overall\u00a0costs<\/strong>\n<\/li>\n<li>\n<strong>Scenario 2<\/strong>: sustainability teams push to <strong>minimize CO2 emissions<\/strong>\n<\/li>\n<\/ul>\n<p>Model outputs will include <strong>financial and operational indicators <\/strong>to illustrate scenarios\u2019 impact on KPIs followed by each department.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Diagram illustrating cost and environmental impact distribution along the supply chain. Costs of goods sold link to retail, production costs link to manufacturing, and logistics costs link to freight and delivery markets. Environmental impacts include production and logistics footprints, managed by the sustainability department.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AgfnSo6RcVkaKD04GPVYpjA.png?ssl=1\"><figcaption>Multiple KPIs involving several departments\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<ul>\n<li>\n<strong>Manufacturing<\/strong>: CO2 emissions, resource usage and cost per\u00a0unit<\/li>\n<li>\n<strong>Logistics<\/strong>: freight costs and emissions<\/li>\n<li>\n<strong>Retail \/ Merchandising<\/strong>: Cost of Goods Sold\u00a0(COGS)<\/li>\n<\/ul>\n<p>As we will see in the different scenarios, each scenario can be favourable for some departments and detrimental for\u00a0others.<\/p>\n<p>Do you imagine a logistic director, pressured to deliver on time at a minimal cost, <strong>accepting the disruption of her distribution chain<\/strong> for a random sustainable initiative?<\/p>\n<blockquote><p>Data (may) help us to find a consensus.<\/p><\/blockquote>\n<h4>Scenario 1: Minimize Costs of Goods\u00a0Sold<\/h4>\n<p>I propose to fix the baseline with a scenario that minimizes the Cost of Goods Sold\u00a0(COGS).<\/p>\n<p>The model found the optimal set of plants to minimize this metric by opening <strong>four factories.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Icons representing manufacturing plants of various sizes and capacities, ranging from small factories to large industrial facilities. Each icon highlights capacity differences and potential production output.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AOsAich_792nQIVc9ourUDw.png?ssl=1\"><figcaption>Manufacturing network for Scenario 1\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<ul>\n<li>\n<strong>Two factories in India<\/strong> (low and high) will supply 100% of the local demand and use the remaining capacity for German, USA and Japanese\u00a0markets.<\/li>\n<li>A <strong>single high-capacity<\/strong> plant in Japan dedicated to meeting (partially) the local\u00a0demand.<\/li>\n<li>\n<strong>A high-capacity<\/strong> factory in Brazil for its market and export to the\u00a0USA.<\/li>\n<\/ul>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Sankey diagram showing supply chain flows from production locations to markets. Japan, India, and Brazil production supply units to markets in Japan, the USA, Germany, Brazil, and India, with flows varying in size to represent volume distribution per market.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AMCTVF7guV9w53JMJWp0bsg.png?ssl=1\"><figcaption>Solution 1 to minimize costs\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<ul>\n<li>\n<strong>Local Production<\/strong>: 10,850 Units\/Month<\/li>\n<li>\n<strong>Export Production<\/strong>: 30,900 Units\/Month<\/li>\n<\/ul>\n<p>With this export-oriented footprint, we have a total cost of <strong>5.68 M\u20ac\/month<\/strong>, including production and transportation.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Stacked bar chart showing the costs of goods sold (COGS) analysis by production location. The chart includes fixed costs (blue) and variable costs (red). The total cost is broken down into Japan (2.07 M\u20ac\/month), Brazil (1.42 M\u20ac\/month), and India (1.52 M\u20ac\/month), with the highest total at 5.68 M\u20ac\/month\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AZHF-yfwAr6BmBOHxEB5yqg.png?ssl=1\"><figcaption>Total Costs Breakdown\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>The good news is that the model allocation is optimal; all factories are used at maximum capacity.<\/p>\n<blockquote><p>What about the Costs of Goods Sold\u00a0(COGS)?<\/p><\/blockquote>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Stacked bar chart showing COGS breakdown by market, highlighting transportation (green), production (red), and fixed costs (blue). Japan has the highest COGS at 4.12 \u20ac\/unit, followed by Germany and the USA, while Brazil and India have the lowest at 80 and 50 \u20ac\/unit respectively.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2A_j1Alm83j_OJ3cQqWghuVQ.png?ssl=1\"><figcaption>COGS Breakdown for Scenario 1\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Except for the Brazilian market, the costs of goods sold are roughly in line with the local purchasing power.<\/p>\n<p>A step further would be to increase <strong>India&#8217;s production capacity<\/strong> or reduce <strong>Brazil&#8217;s factory\u00a0costs<\/strong>.<\/p>\n<blockquote><p>From a cost point of view, it seems perfect. But is it a good deal for the sustainability team?<\/p><\/blockquote>\n<p>The sustainability department is raising the alert as <strong>CO2 emissions are exploding.<\/strong><\/p>\n<p>We have <strong>5,882 (Tons CO2eq) <\/strong>of emissions for <strong>48,950 Units produced.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Bar chart displaying CO2 emissions by market location and source. The USA market has the highest total emissions (4,980 tons CO2eq), with transportation contributing 3,870 tons and production 1,110 tons. Emissions for Brazil, Germany, India, and Japan are significantly lower, with Brazil at 55 tons CO2eq\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AvkAn7h-YpmXmtw380EyEfA.png?ssl=1\"><figcaption>Emissions per Market\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Most of these emissions are due to the <strong>transportation from factories to the US\u00a0market.<\/strong><\/p>\n<p>The top management is pushing to propose a network transformation to <strong>reduce emissions by\u00a030%.<\/strong><\/p>\n<blockquote><p>What would be the impact on production, logistics and retail operations?<\/p><\/blockquote>\n<h4>Scenario 2: Localization of Production<\/h4>\n<p>We switch the model\u2019s objective function to <strong>minimize CO2 emissions<\/strong>.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Icons illustrating a variety of manufacturing site configurations, representing low-capacity and high-capacity factories. The image compares different plant types based on their environmental and operational characteristics.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AXUGmfcg2_SHdIwVHetARGQ.png?ssl=1\"><figcaption>Manufacturing network for Scenario 2\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>As transportation is the major driver of CO2 emissions, the model proposes to open <strong>seven factories<\/strong> to <strong>maximize local fulfilment<\/strong>.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A Sankey diagram depicting production and market flows for different locations. The USA, Germany, Japan, Brazil, and India are shown as production points linked to their respective or export markets with varying unit volumes represented by flow widths.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2Ario7NYLxjseg4eEpyunVjw.png?ssl=1\"><figcaption>Supply Chain Flows for Scenario 2\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<ul>\n<li>\n<strong>Two low-capacity factories in India<\/strong> <strong>and Brazil<\/strong> fulfil their respective local markets\u00a0only.<\/li>\n<li>A <strong>single high-capacity<\/strong> factory in Germany is used for the local market and exports to the\u00a0USA.<\/li>\n<li>We have<strong> two pairs of low and high-capacity plants<\/strong> in Japan and the USA dedicated to local\u00a0markets.<\/li>\n<\/ul>\n<p>From the <strong>manufacturing department&#8217;s point of view<\/strong>, this setup is far from\u00a0optimal.<\/p>\n<p>We have four low-capacity plants in India and Brazil that are <strong>used way below their capacity.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A bar chart comparing variable and fixed costs by production location (USA, Germany, Japan, Brazil, and India). The total cost is prominently displayed, highlighting how fixed and variable costs contribute to overall production costs.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AkEfT2u0NYtQsvMyeHSA0gA.png?ssl=1\"><figcaption>Costs Analysis\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Therefore, fixed costs have more than doubled, resulting in a total budget of <strong>8.7<\/strong> <strong>M\u20ac\/month <\/strong>(versus 5.68 M\u20ac\/month for Scenario\u00a01).<\/p>\n<blockquote><p>Have we reached our target of Emissions Reductions?<\/p><\/blockquote>\n<p>Emissions have dropped from <strong>5,882 (Tons CO2eq) <\/strong>to<strong> 2,136 (Tons CO2eq), <\/strong>reaching the target fixed by the sustainability team.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A bar chart showing CO2 emissions in tons by market (Brazil, Germany, India, Japan, and the USA) with sources split into production and transportation emissions. The USA has the highest combined emissions, with transportation dominating.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AdCUyqeMcA9XJOHbhTWvcBg.png?ssl=1\"><figcaption>Emissions per Market (Scenario 2)\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>However, your CFO and the merchandising team are worried about the <strong>increased cost of sold\u00a0goods<\/strong>.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A stacked bar chart showing the breakdown of the cost of goods sold by market (USA, Germany, Japan, Brazil, and India) into production, transportation, and fixed costs. India and Brazil have the highest COGS due to high fixed and production costs.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2Ana-1MRb_jRwXXAI72RAbvg.png?ssl=1\"><figcaption>New COGS for Scenario 2\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Because output volumes do not absorb the fixed costs of their factories, Brazil and India <strong>now have the highest COGS, <\/strong>going<strong> up to 290.47\u00a0<\/strong>\u20ac\/unit.<\/p>\n<p>However, they remain the markets with the lowest purchasing power.<\/p>\n<blockquote><p>Merchandising Team: \u201cAs we cannot increase prices there, we will not be profitable in Brazil and\u00a0India.\u201d<\/p><\/blockquote>\n<p>We are not yet done. We did not consider the other environmental indicators.<\/p>\n<blockquote><p>The sustainability team would like also to reduce water\u00a0usage.<\/p><\/blockquote>\n<h4>Scenario 3: Minimize Water\u00a0Usage<\/h4>\n<p>With the previous setup, we reached an average consumption of <strong>2,683 kL of Water per unit produced.<\/strong><\/p>\n<p>To meet the regulation in 2030, there is a push to reduce it below <strong>2650\u00a0kL\/Unit.<\/strong><\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Two charts: on the left, a donut chart displaying water usage distribution by country, with Japan leading at 38.8% and the USA at 33.5%. On the right, a bar chart showing water usage per production location, with India using the highest at 3,500 liters per unit.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AWV3oozeJW3_0RWKOWfSdbA.png?ssl=1\"><figcaption>Water Usage for Scenario 2 vs. Unit Consumption\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>This can be done by shifting production to the USA, Germany and Japan while closing factories in Brazil and\u00a0India.<\/p>\n<p>Let us see what the model proposed.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Icons of three types of factories: a small factory, a medium-sized factory, and a large factory with chimneys, representing various production capacities.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AUSCjanaT0d_2fn-HbL0VlQ.png?ssl=1\"><figcaption>Manufacturing network for Scenario 3\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>It looks like the mirrored version of Scenario 1, with a majority of <strong>35,950 units exported<\/strong> and <strong>only 13,000 units locally produced<\/strong>.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A Sankey diagram showing production flows from countries (e.g., Germany, USA, Japan, Brazil, and India) to respective markets, with unit quantities labeled for each flow, highlighting production-to-market supply chains.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AMCF_CABxU8AS9daxuNSHyw.png?ssl=1\"><figcaption>Flow chart for the Scenario 3\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>But now, production is pushed by <strong>five factories in \u201cexpensive\u201d countries<\/strong><\/p>\n<ul>\n<li>Two factories in the USA deliver locally and in\u00a0Japan.<\/li>\n<li>We have two more plants in Germany only to supply the USA\u00a0market.<\/li>\n<li>A single high-capacity plant in Japan will be opened to meet the remaining local demand and deliver to small markets (India, Brazil, and Germany).<\/li>\n<\/ul>\n<blockquote><p>Finance Department: \u201cIt\u2019s the least financially optimal setup you proposed.\u201d<\/p><\/blockquote>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A stacked bar chart showing the costs of goods sold (COGS) analysis by production location. Includes variable costs in red and fixed costs in blue, with total costs highest in the USA at 2.4M\u20ac\/month.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AZWLHzNCyDrw_TjwfC9O29g.png?ssl=1\"><figcaption>Costs Analysis for Scenario 3\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>From a cost perspective, this is the worst-case scenario, as production and transportation costs are exploding.<\/p>\n<p>This results in a budget of <strong>8.89 M\u20ac\/month<\/strong> (versus 5.68 M\u20ac\/month for Scenario\u00a01).<\/p>\n<blockquote><p>Merchandising Team: \u201cUnits sold in Brazil and India have now more reasonable COGS.\u201d<\/p><\/blockquote>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A grouped bar chart illustrating COGS per unit across markets, broken into transportation, production, and fixed costs. Brazil and India show the highest COGS due to higher transportation and production expenses.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AqLCnXfKy5DP_mow3I3SaYw.png?ssl=1\"><figcaption>New COGS for Scenario 2\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>From a retail point of view, things are better than in Scenario 2 as the Brazil and India markets now have COGS in line with the local purchasing power.<\/p>\n<p>However, the logistics team is challenged as we have the majority of volumes for export\u00a0markets.<\/p>\n<blockquote><p>Sustainability Team: \u201cWhat about water usage and CO2 emissions?\u201d<\/p><\/blockquote>\n<p>Water usage is now <strong>2,632 kL\/Unit<\/strong>, below our target of 2,650\u00a0kL.<\/p>\n<p>However, CO2 emissions exploded.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A bar chart showing CO2 emissions by market and source, separating transportation (green) and production (blue). The USA leads in emissions at 2,500 tons, mainly from transportation.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/800\/1%2AGZMcgroaZJ4UXlz8gintDQ.png?ssl=1\"><figcaption>Emissions per Market (Scenario 3)\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>We came back to the Scenario 1 situation with <strong>4,742 (Tons CO2eq) <\/strong>of emissions (versus 2,136 (Tons CO2eq) for Scenario\u00a02).<\/p>\n<p>We can assume that this scenario is satisfying for no\u00a0parties.<\/p>\n<h4>The difficulty of finding a consensus<\/h4>\n<p>As we observed in this simple example, we <em>(as data analytics experts)<\/em> cannot provide the perfect solution that meets every party&#8217;s\u00a0needs.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Three world maps illustrating sustainability scenarios for supply chain networks. Each map represents different setups for factory locations, logistics routes, and corresponding environmental impacts.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AXm9iufNIcxG0eN48pUGkZw.png?ssl=1\"><figcaption>Scenarios and impacts on teams\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Each scenario improves a specific metric to the detriment of other indicators.<\/p>\n<blockquote><p>CEO: \u201cSustainability is not a choice, it\u2019s our priority to become more sustainable.\u201d<\/p><\/blockquote>\n<p>However, these data-driven insights will feed advanced discussions to find a final consensus and move to the implementation.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A diagram with a sustainability team, analytics models powered by Python, and three supply chain maps showing factory locations, logistics routes, and impacts, demonstrating an integrated decision-making process.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2AZf8GwsA8TwAxLSS-9Cnkvw.png?ssl=1\"><figcaption>Data Driven Solution Design\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>In this spirit, I developed this tool to address the complexity of company management and conflicting interests between stakeholders.<\/p>\n<h3>Conclusion<\/h3>\n<p>This article used a simple example to explore the challenges of balancing profitability and sustainability when building a transformation roadmap.<\/p>\n<p>This network design exercise demonstrated how optimizing for different objectives (costs, CO2 emissions, and water usage ) can lead to trade-offs that impact all stakeholders.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A visual representation of optimal outcomes for supply chain decisions: COGS adapted to markets\u2019 purchasing power, low overall cost of production and delivery, local production to minimize logistics costs, and export from low-cost countries to optimize production costs. Includes icons of a store, money bag, warehouse, and worker.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2Am_c4PW9xLZlHVtTrh-RwsA.png?ssl=1\"><figcaption>Conflicting interest among stakeholders\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>These examples highlighted the complexity of achieving consensus in sustainability transitions.<\/p>\n<blockquote><p>As analytics experts, we can play a key role on providing all the metrics to animate discussions.<\/p><\/blockquote>\n<p>The visuals and analysis presented are based on the <strong>Supply Chain Optimization module of a web application I have <\/strong>designed to support companies in tackling these multi-dimensional challenges.<\/p>\n<figure><img decoding=\"async\" alt=\"A webpage snapshot presenting a problem statement for sustainable supply chain optimization. It includes demand distribution across five markets (Japan, USA, Germany, Brazil, and India), a question about network optimization, and an explanation of production costs, plant capacities, and transport expenses with accompanying icons and visuals.\" src=\"https:\/\/cdn-images-1.medium.com\/max\/1024\/0*trczzudFIgyfxxHm\"><figcaption>Demo of the User Interface\u00a0: <a href=\"https:\/\/bit.ly\/try-logigreen-app\">Test it here\u200a<\/a>\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>The module is available for testing here: <a href=\"https:\/\/bit.ly\/try-logigreen-app\">Test the\u00a0App<\/a><\/p>\n<blockquote><p>How to reach a consensus among stakeholders?<\/p><\/blockquote>\n<p>To prove my point, I used <strong>extreme examples in which we set the objective function<\/strong> to minimize CO2 emissions or water\u00a0usage.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"Three world maps illustrating supply chain flows under different scenarios. The maps include color-coded lines representing logistics routes, icons for factories, warehouses, and markets, and environmental sustainability metrics.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/1%2A726HZB_tgsMgeI409l0S5A.png?ssl=1\"><figcaption>Extreme examples used in this case study\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Therefore, we get solutions that are not financially viable.<\/p>\n<p>Using the app, you can do the exercise of keeping the <strong>objective of cost efficiency <\/strong>and<strong> add sustainability constraints<\/strong> like<\/p>\n<ul>\n<li>CO2 emissions per unit produced should be below XX (kgCO2eq)<\/li>\n<li>Water usage per unit\u00a0produced<\/li>\n<\/ul>\n<p>This (may) provide more reasonable solutions that could lead to a consensus.<\/p>\n<blockquote><p>Logistics Operations: We need support to implement this transformation.<\/p><\/blockquote>\n<h4>What\u2019s next?<\/h4>\n<p>Your contribution to the sustainability roadmap can be greater than providing insights for a network design\u00a0study.<\/p>\n<p>In this blog, I shared several case studies using analytics to design and implement sustainable initiatives across the value\u00a0chain.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A diagram explaining a circular economy process for clothing rentals. The steps include rental initiation (Day 1) at a store, customer usage, and return after 14 days. Features icons of clothes, a store, and a person.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/0%2AkRAPTHCJJ350KFUL.png?ssl=1\"><figcaption>Example of initiative: Implement a Circular Economy\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>For instance, you can contribute to implementing a circular economy by estimating the impact of renting products in your\u00a0stores.<\/p>\n<blockquote><p>A circular economy is an economic model that aims to minimize waste and maximize resource efficiency.<\/p><\/blockquote>\n<p>In a detailed case study, I present a model used to simulate the logistics flows covering a scope of 3,300 unique items rented in 10\u00a0stores.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A flowchart showing the parameters used to simulate the circular economy. Includes icons for stores, warehouses, logistics vehicles, rental processes, returned garments, quality checks, and re-distribution for rent or sale.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/0%2AO1VxxpabKkKhxrTO.png?ssl=1\"><figcaption>Simulation Parameters\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>Results show that you can <strong>reduce emissions by 90%<\/strong> for some references in the catalogue.<\/p>\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" alt=\"A bar chart comparing CO2 emissions of garments under circular and linear economic models. The circular model displays significantly lower emissions per garment compared to the linear system.\" src=\"https:\/\/i0.wp.com\/cdn-images-1.medium.com\/max\/1024\/0%2A5qr99wTW4-M585f2.png?ssl=1\"><figcaption>Example of CO2 emissions reductions\u200a\u2014\u200a(Image by Samir\u00a0Saci)<\/figcaption><\/figure>\n<p>These insights can convince the management to invest in implementing the additional logistics processes required to support this\u00a0model.<\/p>\n<p>For more information, have a look at the complete\u00a0article<\/p>\n<p><a href=\"https:\/\/towardsdatascience.com\/data-science-for-sustainability-simulate-a-circular-economy-b6a13d4b0451\">Data Science for Sustainability\u200a\u2014\u200a Simulate a Circular Economy<\/a><\/p>\n<h3>About Me<\/h3>\n<p>Let\u2019s connect on <a href=\"https:\/\/www.linkedin.com\/in\/samir-saci\">LinkedIn<\/a> and <a href=\"https:\/\/x.com\/Samir_Saci_\">Twitter<\/a>. I am a Supply Chain Data Scientist who uses data analytics to improve logistics operations and reduce\u00a0costs.<\/p>\n<p>If you need consulting or advice for your supply chain transformation, contact me via <a href=\"https:\/\/www.logi-green.com\/\">Logigreen Consulting<\/a>.<\/p>\n<p>If you are interested in data analytics and supply chain, please visit my\u00a0website.<\/p>\n<p><a href=\"https:\/\/samirsaci.com\/\">Samir Saci | Data Science &amp; Productivity<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/medium.com\/_\/stat?event=post.clientViewed&amp;referrerSource=full_rss&amp;postId=ce27180f8ddb\" width=\"1\" height=\"1\" alt=\"\"><\/p>\n<hr>\n<p><a href=\"https:\/\/towardsdatascience.com\/sustainable-business-strategy-with-data-analytics-ce27180f8ddb\">Sustainable Business Strategy with Data Analytics<\/a> was originally published in <a href=\"https:\/\/towardsdatascience.com\/\">Towards Data Science<\/a> on Medium, where people are continuing the conversation by highlighting and responding to this story.<\/p>\n<\/div>\n<p> \t<BR><br \/>\n <BR><\/BR><br \/>\n    Samir Saci<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n<a href=\"https:\/\/medium.com\/m\/global-identity-2?redirectUrl=https%3A%2F%2Ftowardsdatascience.com%2Fsustainable-business-strategy-with-data-analytics-ce27180f8ddb\">Go to original source<\/a><br \/>\n \t<BR><br \/>\n <BR><\/BR><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sustainable Business Strategy with Data Analytics Use data analytics to help companies design and implement strategic sustainability roadmaps to reduce their environmental footprint. Sustainable Business Strategy with Analytics\u200a\u2014\u200a(Image by Samir\u00a0Saci) Consensus means that everyone agrees to say collectively what no one believes individually. This quote captures a critical issue many companies face during their strategic [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,83,166,1218,1220,1219],"tags":[845,1222,1221],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-aimldsaimlds","category-data-science","category-hands-on-tutorials","category-logistics","category-supply-chain","category-sustainability","tag-image","tag-samir","tag-sustainability"],"_links":{"self":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/1111"}],"collection":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/comments?post=1111"}],"version-history":[{"count":0,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/1111\/revisions"}],"wp:attachment":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/media?parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/categories?post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/tags?post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}