How to Build a Supply Chain Model in Microsoft Excel

How to Build a 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.    

Learn how to develop an end-to-end multi-echelon supply chain model in Microsoft Excel.

Url: View Details

What you will 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

Rating: 3.55

Level: All Levels

Duration: 2 hours

Instructor: Eric Moore