Supply Chain Design and Planning with Excel & Python.

Learn transport network design, Last mile delivery and Production scheduling with excel & Python.

4.41 (88 reviews)
11.5 hours
Mar 2021
last update
regular price

What you will learn

Master supply chain analytics

Learn how to increase service level while minimizing cost analytically for transportation and production.

Learn how to design supply chain networks.

Add optimization to your Supply chain and Data science skills

Learn how Uber, DHL, Fedex and Amazon schedule their shipments.

Leverage the power of Pulp and OR tools

Introductory section on Python if you are not familiar with Python

Tackle supply chain problems with optimization

Production scheduling

Routes scheduling for shipments

Resource utilization.

Integration of service level.


Supply chain

Linear Programming



Python Crash section included!

If you are working in supply planning, logistics, strategic design, and operational planning, making full use of open source technologies such as the widely popular Python is a guarantee for supply chain excellence through this era of digital transformation.

Top companies manage their supply chain by having a clear focus on planning allocation of suppliers, manufacturing facilities, warehouses, and retailers. and as long as a company or an NGO is delivering products, then for sure, there is a supply chain.

And in this course, we focus on strategic and operational supply chain planning using optimization which by itself is one of the biggest disciplines used in almost all business, engineering, and data industries.

As a supply chain and logistics professional in this modern age, having analytical skills, know-how, and a data science coding language is imperative for the success and progress of one's supply chain career.

The course will take you to step by step on understanding optimization problems in supply-chain that can help you make strategic and tactical supply-chain decisions effectively. As always, our courses are highly practical and follows a learn by doing approach.

After this course we will be able to:

1- Understand the basics of python.

2- Understand linear programming.

3- Work with python library Pulp for linear programming.

4- Maximize the profit of our business given the resources available.

5- Implement production scheduling to minimize cost in excel and python.

6- Decide on the optimal location of facilities.

7- Develop Optimization problems Masterfully in excel and python.

8- Optimize the flow of the supply chain network.

9- Optimize the design of the supply chain network.

10-  Develop your supply chain network with the service level in mind.

11- Understand the sensitivity and the binding constraints of your supply chain decisions.

12- Route optimization for logistical Flows with OR tools.

Course Design

the course is designed as experiential learning Modules, the first couple of modules are for understanding optimization and python followed by supply chain applications using optimization.Don't worry if you don't know python, there are is a python fundamental section in the course to get you up and running with python.

Looking forward to seeing you inside and hope you enjoy the class.

Happy Supply Chain mining!


Rescale Analytics

Feedback from Clients and Training:

"In Q4 2018, I was fortunate to find an opportunity to learn R in Dubai, after hearing about it from indirect references in UK.

I attended a Supply Chain Forecasting & Demand Planning Masterclass conducted by Haitham Omar and the possibilities seemed endless. So, we requested Haitham to conduct a 5-day workshop in our office to train 8 staff members, which opened us up as a team to deeper data analysis. Today, we have gone a step further and retained Haitham, as a consultant, to take our data analysis to the next level and to help us implement inventory guidelines for our business. The above progression of our actions is a clear indication of the capabilities of Haitham as a specialist in R and in data analytics, demand planning, and inventory management."

Shailesh Mendonca

Commercial lead-in Adventure AHQ- Sharaf Group

“ Haytham mentored me in my Role of Head of Supply Chain efficiency. He is extremely knowledgebase about the supply concepts, latest trends, and benchmarks in the supply chain world. Haytham’s analytics-driven approach was very helpful for me to recommend and implement significant changes to our supply chain at Aster group”

Saify Naqvi

Head of Supply Chain Efficiency

“I participated in the training session called "Supply Chain Forecasting & Management" on December 22nd 2018. This training helped me a lot in my daily work since I am working in Purchase Dpt. Haytham have the pedagogy to explain us very difficult calculations and formula in a simple way. I highly recommend this training.”


Purchasing Manager at Mineral Circles Bearings


Supply Chain Design and Planning  with Excel & Python.Supply Chain Design and Planning  with Excel & Python.Supply Chain Design and Planning  with Excel & Python.Supply Chain Design and Planning  with Excel & Python.


Strategic supply chain design
Scale of supply chain
Plan of attack
What is supply chain optimization
Types of Optimization Problems in supply chain
Mathematical formulation
Transportation problems
Resource utilization Demo
Manufacturing Problem
Model in Excel
Production scheduling demonstration
Production Scheduling in excel
Opening constraints
Solving the production scheduling
Summary Section 1
Installing Anaconda
Downloading anaconda
Installing Anaconda
Spyder overview
Jupiter Notebook Overview
Python Libraries
Python Fundmentals
Arithmetic Calculations in python
Importing Data in python
Subsetting dataframes
Writing functions
For loops
For-looping a function
Mapping on a dataframe
For looping on a data frame
Assignment answer 1
Assignment answer 2
Introducing Pulp
Pulp orientation
installing Pulp
Manufacturing Model in pulp
Assignment Explanation
Production scheduling Orientation
Production scheduling in python
Defining Constraints
Model Conclusion
Assignment Solution
Supply Chain Network Design
Supply chain network design
Supply chain Design components
warehouse allocation part 1
Warehouse allocation part 2
Developing Variables in python
Objective function facility allocation
Summary models
Model senstivity
Checking average distance Vs number of warehouses
DC extended slides
Advanced Network Modelling in Excel
Linking Constraints
Intro to the model
Developing Costs
formulating constraints
Solving the model
Level of service
Relaxing DCs Constraints
Extended model with pulp
Importing model data
Constructing Variables
Constructing costs in model
Objective function
Demand and flow constraints
Linking constraints
Solving the model
Setting the service level
Relaxing the DC constraints
Service level constraints
Binding Constraints
Route optimization
Traveling Sales-man problem
Travelling sales man with ml-rose
Routing optimization with OR tools
Adding Constraints
Capacity Constraints
Adding the Capacity Dimensions
Understanding Model index
For looping on vehicles
Capacity Constraints Display
Farewell and until we meet again


15 July 2021
It's very useful for me as Industrial Engineering student who passionate with data science and supply chain analytics
10 May 2021
Worthless videos are not complete changes codes and leaves explanation half way. At the end if any small changes are made such as adding excel file to the program it gives 0 as the final answer.
24 April 2021
This course was great for me. I really enjoyed learning the content. I tried to solve the assignments all by myself and checked the answers after that. The course also boasts good resources that helped me to learn more and more.
3 April 2021
Overall well made; at times the structure of the texts, the Excels & Python code could be more streamlined
25 March 2021
Useful course especially if you work in a business or you want to start up new one, information in each episode linked together to provide you with a rich information about the Supply Chain Design .. Thank you Haytham
6 February 2021
Thank you for teaching and sharing the supply chain problem using Python. I used to model the optimization problem on GAMS which needs a license fee. Executing the optimization problem on python gives me an advantage as freeware with open source.
25 December 2020
I have covered first 4 section. The course is well designed and is delivered in easy to understand manner.
9 December 2020
The course is a bit unorganized as far as being a student who has to take notes as well as keep up with the problem-solving formulas and the point that is trying to be made.



Supply Chain Design and Planning  with Excel & Python. - Price chart


Supply Chain Design and Planning  with Excel & Python. - Ratings chart

Enrollment distribution

Supply Chain Design and Planning  with Excel & Python. - Distribution chart


10/13/2021100% OFF
udemy ID
course created date
course indexed date
course submited by