Supply Chain Design and Planning (Using Excel and Python)

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 follows a learn by doing approach

$14.95 / MONTH SITE SUBSCRIPTION (W/ 14 DAY FREE TRIAL) $149.95 / YEAR SITE SUBSCRIPTION (W/ 14 DAY FREE TRIAL)

Course curriculum

1. Segment - 01 - Supply Chain Design
2. Segment - 02 - Supply Chain Planning
3. Segment - 03 - Curriculum
4. Segment - 04 - Strategic Supply Chain Design - IKEA
5. Segment - 05 -Strategic Supply Chain Design - Zara
6. Segment - 06 - Strategic Supply chain Design - Walmart
7. Segment - 07 - Strategic Supply Chain Design - Dell
8. Segment - 08 - Plan of Attack
9. Segment - 09 - What is supply chain optimization?
10. Segment - 10 - Types of Optimization Problems in Supply Chain
11. Segment - 11 - Mathematical Formulation
12. Segment - 12 - Transportation Problems
13. Segment - 13 - Resource Utilization Demo
14. Segment - 14 - Manufacturing Problem
15. Segment - 15 - Model in Excel
16. Segment - 16 - Assignment
17. Segment - 17 - Assignment Answer
1. Segment - 18 - Production Planning
2. Segment - 19 - Production Scheduling Demonstration
3. Segment - 20 - Production Scheduling in Excel
4. Segment - 21 - Opening Constraints
5. Segment - 22 - Solving the Production Scheduling
6. Segment - 23 - Assignment
7. Segment - 24 - Answer PS
8. Segment - 25 - Global Production Scheduling Assignment
9. Segment - 26 - Answer
10. Segment - 27 - Summary Section 2
1. Segment - 28 - Python History
2. Segment - 29 - Downloading Anaconda
3. Segment - 30 - Installing Anaconda
4. Segment - 31 - Spyder Overview
5. Segment - 32 - Jupiter Overview
6. Segment - 33 - Packages
1. Segment - 34 - Introduction
2. Segment - 35 - Dataframes
3. Segment - 36 - Arithmetic Calculations in Python
4. Segment - 37 - Lists
5. Segment - 38 - Dictionaries
6. Segment - 39 - Arrays
7. Segment - 40 - Importing Data in Python
8. Segment - 41 - Subsetting Dataframes
9. Segment - 42 - Conditions
10. Segment - 43 - Writing Functions
11. Segment - 44 - Mapping
12. Segment - 45 - For Loops
13. Segment - 46 - For-looping a Function
14. Segment - 47 - Mapping on a Dataframe
15. Segment - 48 - For Looping on a Data Frame
16. Segment - 49 - Summary
17. Segment - 50 - Assignment
18. Segment - 51 - Assignment Answer 1
19. Segment - 52 - Assignment Answer 2
1. Segment - 53 - Pulp Orientation
2. Segment - 54 - Installing Pulp
3. Segment - 55 - Manufacturing Model in Pulp
4. Segment - 56 - Assignment
5. Segment - 57 - Assignment Answer
6. Segment - 58 - Production Scheduling Orientation
7. Segment - 59 - Production Scheduling in Python
8. Segment - 60 - Defining Constraints
9. Segment - 61 - Model Conclusion
10. Segment - 62 - Assignment
11. Segment - 63 - Assignment Solution
1. Segment - 64 - Introduction
2. Segment - 65 - Supply Chain Network Design
3. Segment - 66 - Supply Chain Design Components
4. Segment - 67 - Warehouse Allocation Part 1
5. Segment - 68 - Warehouse Allocation Part 2
6. Segment - 69 - Developing Variables in Python
7. Segment - 70 - Objective Function Facility Allocation
8. Segment - 71 - Constraints
9. Segment - 72 - Summary Models
10. Segment - 73 - Model Sensitivity
11. Segment - 74 - Checking Average Distance Vs Number of Warehouses
12. Segment - 75 - DC Extended Model
1. Segment - 76 - Linking Constraints
2. Segment - 77 - Introduction to the Model
3. Segment - 78 - Developing Costs
4. Segment - 79 - Formulating Constraints
5. Segment - 80 - Solving the Model
6. Segment - 81 - Commentary
7. Segment - 82 - Level of Service
8. Segment - 83 - Relaxing DCs Constraints
1. Segment - 84 - Importing Model Data
2. Segment - 85 - Constructing Variables
3. Segment - 86 - Constructing Costs in Model
4. Segment - 87 - Objective Function
5. Segment - 88 - Demand and Flow Constraints
6. Segment - 89 - Linking Constraints
7. Segment - 90 - Solving the Model
8. Segment - 91 - Showing only Variables with Output
9. Segment - 92 - Setting the Service Level
10. Segment - 93 - Relaxing the DC Constraints
11. Segment - 94 - Service Level Constraints
12. Segment - 95 - Binding Constraints
13. Segment - 96 - Assignment
14. Segment - 97 - Assignment Answer 1
15. Segment - 98 - Assignment Answer 2
1. Segment - 99 - Introduction
2. Segment - 100 - Traveling Sales-Man Problem
3. Segment - 101 - Travelling Males Man with ML-rose
4. Segment - 102 - Routing Optimization with or Tools
5. Segment - 103 - Adding Constraints
6. Segment - 104 - Getting the Results of the Solution
7. Segment - 105 - For Looping the Solution
8. Segment - 106 - Conclusion
9. Segment - 107 - What if we remove the distance constraint?
10. Segment - 108 - Capacity Constraints
11. Segment - 109 - Adding the Capacity Dimensions
12. Segment - 110 - Understanding Model index
13. Segment - 111 - For Looping on Vehicles
14. Segment - 112 - Capacity Constraints Display
15. Segment - 113 - Calculating Total Distance and Total Loads
16. Segment - 114 - VRPTW model
17. Segment - 115 - Adding time Dimension
18. Segment - 116 - Setting Time Window Range
19. Segment - 117 - Instantiate Route Start and End
20. Segment - 118 - Getting Routes and Windows
21. Segment - 119 - Mapping the Solution
22. Segment - 120 - Routing Example: Restaurant
23. Segment - 121 - Routing Example Part 2
24. Segment - 122 - Assignment
25. Segment - 123 - Conclusion

About this course

Free
123 lessons
11.5 hours of video content

Supply Chain Design and Planning (Using Excel and Python)

Course curriculum

Module 1: Strategic Supply Chain design

Module 2: Production Planning

Module 3: Installing Anaconda

Module 4: Python Crash Section

Module 5: Introducing Pulp

Module 6: Supply Chain Network Design

Module 7: Advanced Network Modelling in Excel

Module 8: Advanced Network Models with Pulp

Module 9: Route optimization

About this course