Supply Chain Design and Planning with Excel & Python.

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

4.35 (69 reviews)


11.5 hours


Mar 2021

Last Update
Regular Price

Exclusive  Offer
Unlimited access to 30 000 Premium SkillShare courses

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


Anish10 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.

Farshid24 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.

Erwin3 April 2021

Overall well made; at times the structure of the texts, the Excels & Python code could be more streamlined

Noof25 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

JK6 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.

Farooq25 December 2020

I have covered first 4 section. The course is well designed and is delivered in easy to understand manner.

Matthew9 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.


Udemy ID


Course created date


Course Indexed date
Course Submitted by