How to Build a Supply Chain Model in Microsoft Excel

Learn how to develop an end-to-end multi-echelon supply chain model in Microsoft Excel.
4.6 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
403 students enrolled
Instructed by Eric Moore Business / Operations
Sale Ends Today!
25% off
Take This Course
  • Lectures 16
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2012 English

Course Description

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.    

What are the requirements?

  • Basic experience using Microsoft Excel

What am I going to get from this course?

  • 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

Who is the target audience?

  • Supply chain professionals
  • Professionals in manufacturing industries looking to learn more about supply chain management
  • MBA students
  • Operations students

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Modeling a Single Location
Course Overview & Description of the Conceptual Model
Modeling a Single Finished Good at a Single Location
Modeling Multiple Finished Goods at a Single Location
Balance Equation to Check Model's Integrity
Section 2: Modeling Multiple Locations
Start of a Multi-Echelon Supply Chain Model
Inventory Valuation & Common Unit of Measure Modeling
Modeling Finished Goods at a Second Location
Modeling a Packaging Site
Determine Inventory Coverage at the Packaging Site
Modeling a Second Packaging Site
Determine Inventory Coverage at the Second Packaging Site
Section 3: Additional Resources
Periods of Cover Calculation

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.

Excel Multi-level Supply Chain Model Download
Excel Solver Supply Chain Model Download
Excel Supply Chain Model Quiz

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Eric Moore, Supply Chain Professional

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.

Ready to start learning?
Take This Course