課程資料
報名日期
全年招生
課程級別
學習模式
修業期
1 小時 55 分鐘
教學語言
英語
授課導師
Eric Moore
評分
19次瀏覽
課程簡介
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.
課程章節
- 3 個章節
- 16 堂課
- 第 1 章 Modeling a Single Location
- 第 2 章 Modeling Multiple Locations
- 第 3 章 Additional Resources
課程內容
- 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
此課程所涵蓋的技能
評價
-
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.
