|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-build-a-supply-chain-model-in-microsoft-excel/
课程评论：没有评论
**课程名称:** 如何在 Microsoft Excel 中构建供应链模型 **课程概述:** 本课程将详细演示如何在 Microsoft Excel 中开发一个多级供应链模型。课程首先会介绍并构建供应链的概念模型（使用 PowerPoint），然后从一个空白的工作簿开始，逐步在 Microsoft Excel 中创建月度分档的供应链模型。课程内容涵盖多级供应链的库存覆盖率、库存价值、补货计划、生产计划等关键要素。学完本课程后，学员将能够理解构建供应链模型所需的主要要求，并掌握在 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.
