How to Build a Supply Chain Model in Microsoft Excel
How to Build a Supply Chain Model in Microsoft Excel, available at $24.99, has an average rating of 4, with 16 lectures, based on 130 reviews, and has 946 subscribers.
You will learn about 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 This course is ideal for individuals who are Supply chain professionals or Professionals in manufacturing industries looking to learn more about supply chain management or MBA students or Operations students It is particularly useful for Supply chain professionals or Professionals in manufacturing industries looking to learn more about supply chain management or MBA students or Operations students.
Enroll now: How to Build a Supply Chain Model in Microsoft Excel
Summary
Title: How to Build a Supply Chain Model in Microsoft Excel
Price: $24.99
Average Rating: 4
Number of Lectures: 16
Number of Published Lectures: 16
Number of Curriculum Items: 16
Number of Published Curriculum Objects: 16
Original Price: $19.99
Quality Status: approved
Status: Live
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
- Understand inventory coverage calculations
- Understand multi-echelon supply chain modeling
Who Should Attend
- Supply chain professionals
- Professionals in manufacturing industries looking to learn more about supply chain management
- MBA students
- Operations students
Target Audiences
- Supply chain professionals
- Professionals in manufacturing industries looking to learn more about supply chain management
- MBA students
- Operations students
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.
Course Curriculum
Chapter 1: Modeling a Single Location
Lecture 1: Course Overview & Description of the Conceptual Model
Lecture 2: Modeling a Single Finished Good at a Single Location
Lecture 3: Modeling Multiple Finished Goods at a Single Location
Lecture 4: Balance Equation to Check Model's Integrity
Chapter 2: Modeling Multiple Locations
Lecture 1: Start of a Multi-Echelon Supply Chain Model
Lecture 2: Inventory Valuation & Common Unit of Measure Modeling
Lecture 3: Modeling Finished Goods at a Second Location
Lecture 4: Modeling a Packaging Site
Lecture 5: Determine Inventory Coverage at the Packaging Site
Lecture 6: Modeling a Second Packaging Site
Lecture 7: Determine Inventory Coverage at the Second Packaging Site
Chapter 3: Additional Resources
Lecture 1: Periods of Cover Calculation
Lecture 2: Excel Formula Periods of Cover Calculation
Lecture 3: Excel Multi-level Supply Chain Model Download
Lecture 4: Excel Solver Supply Chain Model Download
Lecture 5: Excel Supply Chain Model Quiz
Instructors
-
Eric Moore
Supply Chain Professional
Rating Distribution
- 1 stars: 9 votes
- 2 stars: 11 votes
- 3 stars: 28 votes
- 4 stars: 42 votes
- 5 stars: 40 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024