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.
Example periods of cover calculation using an Excel formula. This is an alternative that some students prefer over the POC macro that is provided in this course.
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 led me to offer training based on actual experience. The goal is to allow participants in the program to focus on what really matters and hit the ground running.