Supply Chain Design and Planning with Excel & Python.
- Description
- Curriculum
- FAQ
- Reviews
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!
Haytham
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.”
Djamel BOUREMIZ
Purchasing Manager at Mineral Circles Bearings
-
1Supply chain DesignVideo lesson
-
2Supply Chain PlanningVideo lesson
-
3CurriclumVideo lesson
-
4Strategic supply chain design-IkeaVideo lesson
-
5Strategic Supply chain Design- ZaraVideo lesson
-
6Strategic supply chain design- WalmartVideo lesson
-
7Strategic Supply chain design- DellVideo lesson
-
8Plan of attackVideo lesson
-
9What is supply chain optimizationVideo lesson
-
10Types of Optimization Problems in supply chainVideo lesson
-
11Mathematical formulationVideo lesson
-
12Transportation problemsVideo lesson
-
13Resource utilization DemoVideo lesson
-
14Manufacturing ProblemVideo lesson
-
15Model in ExcelVideo lesson
-
16AssignmentVideo lesson
-
17Assignment AnswerVideo lesson
-
18Production PlanningVideo lesson
-
19Production scheduling demonstrationVideo lesson
-
20Production Scheduling in excelVideo lesson
-
21Opening constraintsVideo lesson
-
22Solving the production schedulingVideo lesson
-
23AssignmentVideo lesson
-
24Answer PSVideo lesson
-
25Global Production scheduling assignmentVideo lesson
-
26AnswerVideo lesson
-
27Summary Section 2Video lesson
-
34IntroVideo lesson
-
35DataframesVideo lesson
-
36Arithmetic Calculations in pythonVideo lesson
-
37ListsVideo lesson
-
38DictsVideo lesson
-
39ArraysVideo lesson
-
40Importing Data in pythonVideo lesson
-
41Subsetting dataframesVideo lesson
-
42ConditionsVideo lesson
-
43Writing functionsVideo lesson
-
44MappingVideo lesson
-
45For loopsVideo lesson
-
46For-looping a functionVideo lesson
-
47Mapping on a dataframeVideo lesson
-
48For looping on a data frameVideo lesson
-
49SummaryVideo lesson
-
50AssignmentVideo lesson
-
51Assignment answer 1Video lesson
-
52Assignment answer 2Video lesson
-
53Pulp orientationVideo lesson
-
54installing PulpVideo lesson
-
55Manufacturing Model in pulpVideo lesson
-
56AssignmentVideo lesson
-
57Assignment ExplanationVideo lesson
-
58Production scheduling OrientationVideo lesson
-
59Production scheduling in pythonVideo lesson
-
60Defining ConstraintsVideo lesson
-
61Model ConclusionVideo lesson
-
62AssignmentVideo lesson
-
63Assignment SolutionVideo lesson
-
64IntroVideo lesson
-
65Supply chain network designVideo lesson
-
66Supply chain Design componentsVideo lesson
-
67warehouse allocation part 1Video lesson
-
68Warehouse allocation part 2Video lesson
-
69Developing Variables in pythonVideo lesson
-
70Objective function facility allocationVideo lesson
-
71ConstraintsVideo lesson
-
72Summary modelsVideo lesson
-
73Model senstivityVideo lesson
-
74Checking average distance Vs number of warehousesVideo lesson
-
75DC extended ModelVideo lesson

External Links May Contain Affiliate Links read more