#Supply Chain Design and Planning with Excel & Python.



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

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.

Excel

Supply chain

Linear Programming

Python

Description

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

English
language

Content

Introduction
Strategic supply chain design
Scale of supply chain
Curriclum
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
Python
Downloading anaconda
Installing Anaconda
Spyder overview
Jupiter Notebook Overview
Python Libraries
Python Fundmentals
Intro
Dataframes
Arithmetic Calculations in python
Lists
Dicts
Arrays
Importing Data in python
Subsetting dataframes
Conditions
Writing functions
Mapping
For loops
For-looping a function
Mapping on a dataframe
For looping on a data frame
Summary
Assignment
Assignment answer 1
Assignment answer 2
Introducing Pulp
Pulp orientation
installing Pulp
Manufacturing Model in pulp
Assignment
Assignment Explanation
Production scheduling Orientation
Production scheduling in python
Defining Constraints
Model Conclusion
Assignment
Assignment Solution
Supply Chain Network Design
Intro
Supply chain network design
Supply chain Design components
warehouse allocation part 1
Warehouse allocation part 2
Developing Variables in python
Objective function facility allocation
Constraints
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
Commentary
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
Conclusion
Capacity Constraints
Adding the Capacity Dimensions
Understanding Model index
For looping on vehicles
Capacity Constraints Display
Farewell and until we meet again

The post Supply Chain Design and Planning with Excel & Python. appeared first on StudyBullet.

LihatTutupKomentar