How to Build a Supply Chain Model in Microsoft Excel
3.8 (37 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.
475 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to Build a Supply Chain Model in Microsoft Excel to your Wishlist.

Add to Wishlist

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.
3.8 (37 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.
475 students enrolled
Created by Eric Moore
Last updated 7/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
  • Understand inventory coverage calculations
  • Understand multi-echelon supply chain modeling
View Curriculum
Requirements
  • Basic experience using Microsoft Excel
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.    

Who is the target audience?
  • Supply chain professionals
  • Professionals in manufacturing industries looking to learn more about supply chain management
  • MBA students
  • Operations students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:55:36
+
Modeling a Single Location
4 Lectures 42:15


Modeling Multiple Finished Goods at a Single Location
17:57

Balance Equation to Check Model's Integrity
03:50
+
Modeling Multiple Locations
7 Lectures 01:08:42
Start of a Multi-Echelon Supply Chain Model
10:03

Inventory Valuation & Common Unit of Measure Modeling
11:29

Modeling Finished Goods at a Second Location
13:24

Modeling a Packaging Site
13:55

Determine Inventory Coverage at the Packaging Site
04:55

Modeling a Second Packaging Site
11:19

Determine Inventory Coverage at the Second Packaging Site
03:37
+
Additional Resources
5 Lectures 04:17
Periods of Cover Calculation
03:11

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 Formula Periods of Cover Calculation
00:38

Excel Multi-level Supply Chain Model Download
00:03

Excel Solver Supply Chain Model Download
00:11

Excel Supply Chain Model Quiz
00:12
About the Instructor
Eric Moore
3.8 Average rating
37 Reviews
475 Students
1 Course
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.