Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
How to Build a Supply Chain Model in Microsoft Excel
Rating: 3.6 out of 5(132 ratings)
959 students

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.
Created byEric Moore
Last updated 7/2015
English

What you'll 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

Course content

3 sections • 16 lectures • 1h 55m total length

  • Course Overview & Description of the Conceptual Model4:53
  • Modeling a Single Finished Good at a Single Location15:35
  • Modeling Multiple Finished Goods at a Single Location17:57
  • Balance Equation to Check Model's Integrity3:50

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 this course is for:

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

Report abuse