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 hours on-demand video | 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 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
• Excel
• Supply chain

• 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.
• Linear Programming
• Python

Requirements
♦ Microsoft excel
♦ Basic understanding of supply chain

Course Preview

Description

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.

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.

Who this course is for

• Supply chain • Logistics • Data science • Planners • Python • Optimization • Last mile delivery • Production planning

Student reviews

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