Robust Supply Chain Networks with Monte Carlo Simulation
Learn how Monte Carlo simulation can help design a robust supply chain network considering demand fluctuations.
Supply chain optimization uses data analytics to find an optimal combination of factories and distribution centres to meet customers' demands.
As a data scientist, how can you support Supply Chain Network Optimization with Python?
The core structure of many software and solutions in the market is a Linear Programming Model.
Some of these models find the proper allocation of factories to meet the demand and minimize the costs, assuming a constant demand.
What happens if the demand is fluctuating?
Your network may lose robustness, especially if the demand is seasonal (e-commerce, cosmetics, fast fashion).
In this article, we will develop a straightforward methodology for designing a Robust Supply Chain Network using Monte Carlo simulation with Python.
SUMMARY
I. Supply Chain Network Design
Find the right allocation of factories to meet a global demand
II. Problem Statement
What happens if your demand is fluctuating?
1. Limits of the initial solution
Understand the robustness of the initial solution
2. Methodology of simulation
Simulate 50 scenarios based on a normal distribution of the demand
3. Analyze the results
What are the different combinations of solutions?
4. Final Solution
The most robust combination?
III. Conclusion & Next Steps
1. Move Towards a Sustainable Supply Chain
Implement objective functions aiming to reduce carbon footprint
2. #GenAI: Improve the User Interface with GPT
A GPT agent that would answer questions using the simulation model
3. Automate PowerPoint Report Generation with Python
Share your insights in a slides generated automatically with PythonMethodology of Supply Chain Network Design
Global Supply Chain Network
As the Head of Supply Chain Management of an international manufacturing company, your boss wants to redefine the Supply Chain Network for the next five years.
How can you support her with data analytics?
Demand
It starts with the demand from your customers in 5 different markets (Brazil, USA, Germany, India and Japan).
US market is driving more than half of the demand.
Supply Capacity
You can open factories in the five markets. There is a choice between low and high-capacity facilities.
Example: Low Capacity factories in the USA can produce 500,000 units/month.
Fixed Costs
If you open a facility you have fixed costs to add to your budget (Electricity, Real Estate, CAPEX, …).
High-capacity plants in India have lower fixed costs than low-capacity plants in the USA.
Variable Costs
Fixed Costs + Variable Costs = Total Costs of Production
Freight Costs
Costs to ship a container from Country XXX to Country YYY.
Total Cost
The total cost to produce and ship products to the market.
Based on the demand of the markets, where do I need to open factories?
Linear Programming Model
This classic linear programming problem has objective functions, constraints, and parameters.
Manufacturing Footprint
Where do I need to open locations?
You must open four locations in Brazil, the USA, Japan and India. Except in Brazil, all these locations are high-capacity plants.
Products Flows
How many units are produced by factory YYY for Market XXX?
Japan's factories produce only for the local market, while Brazil and India are mainly driven by export demand.
🏫 Discover 70+ case studies using analytics for supply chain optimization 🏭, sustainability🌳and business optimization 🏪 in this: Cheat Sheet
Problem Statement
This solution has been implemented assuming a constant demand in the markets.
Limits of the initial solution
What could be the impact if we have +10% in Japan and +20% in the US?
By looking at the utilization rates, you can easily guess that your current footprint will not be able to adapt to this surge of demand.
Methodology of Simulation
We cannot rely on a single solution and expect our network to absorb the demand throughout the year.
Usually, these parameters are calculated based on the yearly sales average.
Let’s simulate this demand variability and see the impact on the network design.
Generate 50 scenarios
We will assume that the demand is following a normal distribution with a coefficient of variation CV = 0.5. (You can adapt the distribution to your needs)
You now have a matrix of 50 columns representing your 50 different scenarios.
Optimal Solution for Each Scenario
What is the optimal combination for each scenario?
- India always has at least 1 facility open
- Scenario 16 needs all facilities to be open because of a peak in the US demand
- Scenario 12 only needs 2 LOW capacity facilities in Brazil and India
Distribution of the optimal combinations
Do we have combinations that appear more frequently than others?
After removing duplicates, we have 16 unique combinations
Which combination seems the most robust?
The combination C2 (High/Low plants in India and Brazil + 1 High plant in Japan) appears the most. C2, C6 and C10 closely follow this combination.
Final Solutions
It is challenging to draft a clear conclusion, but if we choose the safe solution, we must take the C2 combination.
As it maximizes the footprint in countries with low production costs, we will meet the demand for most scenarios.
You can find the source code with dummy data on my GitHub
If you prefer to watch, have a look at the video of this article
Next Steps
There is no perfect solution for this problem, as we must balance securing the supply and reducing costs.
What if we want to reduce costs and minimize CO2 emissions?
As the demand for transparency in sustainable development increases, including environmental parameters in our model is no longer an option.
Sustainable supply chain optimization is an approach to network design that combines cost-effectiveness with environmental responsibility.
This topic is increasingly relevant as organizations are pressured to reduce their carbon footprint by reshaping their supply chain networks.
As a data scientist, how can I support my company?
Have a look at these operational cases to understand more,
Have you heard about Generative AI?
Improve the User Interface with GPT
We can use large language models to enhance the user experience by creating an agent who interacts, answers questions, and challenges assumptions.
In this first article, I share my explorative journey of LLMs by showing how I designed a LangChain SQL agent connected to a database.
This automated “supply chain control tower” was able to answer basic and advanced questions by querying the database:
- How many shipments have been delivered in the first week?
- How many are delayed? What are the reasons?
This solution can drive discussions around the target for stock service level and production costs.
Now that we have a set of candidates for the potential BEST solution, we can ask the agent to test them on our 50 scenarios.
- What is the total cost for each scenario?
- What is the percentage of demand produced by our facilities?
Users can adjust assumptions and parameters using natural languages and conduct interactive brainstorming sessions with the agent.
To learn more about the prototypes of GPT-powered agents I designed, have a look at these two articles.
How will you share the insights?
Automate PowerPoint Slide Creation with Python
If we assume that you are in the corporate world, you will probably prepare PowerPoint presentations to present the conclusion of your study.
Can we automate this boring manual task?
Yes! You’re lucky.
In another article, I shared a simple approach to generate PowerPoint slides using the Python-pptx library automatically.
This example is based on a distribution planning report I had to generate in my previous position.
- Generate graphs and comments using data extracted and processed from multiple sources.
- Create PowerPoint slides with Python-pptx
- Include the graphs and comments in the slides
This workflow can be easily adapted to the Supply Chain Network optimisation algorithm presented here.
If you want to include it in your workflow, check the article below 👇
About Me
Let’s connect on Linkedin and Twitter. I am a Supply Chain Engineer who uses data analytics to improve logistics operations and reduce costs.
For consulting or advice on analytics and sustainable supply chain transformation, feel free to contact me via Logigreen Consulting.
If you are interested in Data Analytics and Supply Chain, look at my website.
💌 New articles straight in your inbox for free: Newsletter
📘 Your complete guide for Supply Chain Analytics: Analytics Cheat Sheet
