Master multi-echelon supply chain modeling in Excel. Learn to create, plan, and analyze inventory coverage, value, and production planning effectively.
In this course, you'll dive into creating a multi-echelon supply chain model using Excel. We start with the big picture in PowerPoint and then get hands-on with data, inventory, and planning in Excel. It's all about understanding how to make supply chains work smoothly!
Learn how to develop an end-to-end multi-echelon supply chain model in Microsoft Excel.
A detailed demonstration of the development of a multi-echelon supply chain model in Microsoft Excel is provided. First, the conceptual model for the supply chain is explained and developed in Microsoft PowerPoint. The monthly bucketed supply chain model is then developed in Microsoft Excel starting with a blank workbook. Inventory coverage, inventory value, replenishment planning, production planning, etc is covered at multi-levels of the supply chain. The student should leave the course with an understanding of the key requirements for modeling a supply chain as well as how to create a model in Excel.
Understand & develop the supply chain conceptual model
Understand the static & dynamic data required for the model
Develop a monthly bucket supply chain model in Microsoft Excel
4 Lectures
7 Lectures
Supply chain professional with 15 years of software, manufacturing & supply chain management experience. B.S. in Electrical Engineering from Drexel University and MBA from Villanova University. Over the years, I've found that there is a significant lack of training resources for supply chain management. Available training is either too academic or not specific to supply chain management. This is what...
It is not covering core Supply Chain modelling constraints and not covering supply side. It is very simple model and don't really need coaching, if someone knows basics of supply chain. Supply chain is model is useful when you cover multi enterprise multi echelon inventory and not a single manufacturing facility and so on.
Missing an explanation of a key component of the class. References other materials that are not covered during this class. Incomplete.
no code for POC shared.
class was good , but too fast for me
Use of the POC custom coding is annoying. Should have covered what it was specifically either before starting the sheet, or at that moment where it became necessary. Without it, the sheet ends up incomplete on the Student-side, although still useful.
Many assumptions to have a very simplified model
Grundsätzlich gute Einführung in das Thema Supply Chain Modellierung mit Excel. Man merkt auch, dass der Dozent grundsätzlich Ahnung hat. Allerdings verschwendet er gut 80% der Zeit damit immer wieder die gleichen Formeln und Formate zu kopieren. Der eigentliche Inhalt hätte in einem Bruchteil der Zeit rübergebracht werden können. So war es extrem langweilig.
Lucid explanation
very basic
Your email address will not be published. Required fields are marked *
Tamilselvan.d
No, So I think of already course in available in learning to easy methods