Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 55 Minute(s)
Language
English
Taught by
Eric Moore
Rating
Course Overview
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.
Course Content
- 3 section(s)
- 16 lecture(s)
- Section 1 Modeling a Single Location
- Section 2 Modeling Multiple Locations
- Section 3 Additional Resources
What You’ll Learn
- 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, Understand inventory coverage calculations, Understand multi-echelon supply chain modeling
Skills covered in this course
Reviews
-
TTamilselvan.D
No, So I think of already course in available in learning to easy methods
-
RRay Chaudoin
Missing an explanation of a key component of the class. References other materials that are not covered during this class. Incomplete.
-
MMichael Mariani
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.
-
JJg999
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.
