Supply Chain Design and Planning with Excel & Python

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

This course includes:
11.5 total hours | 49 downloadable resources | Full lifetime access | Access on mobile and TV | Certificate of completion

What you’ll learn

• Master supply chain analytics

• Learn how to design supply chain networks.

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

• Introductory section on Python if you are not familiar with Python

• Production scheduling

• Resource utilization.

• Excel

• Linear Programming

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

• Add optimization to your Supply chain and Data science skills

• Leverage the power of Pulp and OR tools

• Tackle supply chain problems with optimization

• Routes scheduling for shipments

• Integration of service level.

• Supply chain


♦ Microsoft excel

♦ Basic understanding of supply chain


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.

What you will get

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.

Course Preview

Who this course is for

Supply chain | Logistics | Data science | Planners | Python | Optimization

Course Content