DDMRP in Excel Workshop Agenda

This workshop is intended to teach the basic principles in integrated supply chain planning and the DDMRP method.

We will use a fully functional system with a fictitious manufacturing company to show how a DDMRP system works. You will set up inventory buffers to position against variable demand and then see how they perform with a series of demand scenarios.

You will come away from this workshop with a fully functional DDMRP planning system in Excel- there is not licence or additional cost. With the skills you learn here, you could connect the system to your own data and have a complete integrated planning system working as a pilot or even a live system.

Workshop Agenda

What this course will provide:

  • 2 days of classroom and hands-on training on DDMRP in Excel
  • An overview of DDMRP and integrated supply chain planning concepts
  • A detailed look into our methods and templates for building planning systems in Excel
  • A copy of an unlocked, fully-functional DDMRP planning system in Excel
  • The knowledge of how to connect it with your own data

What this course will NOT provide:

  • Certified training on DDMRP (please visit the Demand-Driven Institute for the CDDP and CDDL courses)
  • Ongoing support for the DDMRP system after the workshop (We can help you at additional cost as a consulting service)

What you will need to bring:

  • A Windows laptop with Microsoft Excel 2007 or higher installed
Day 1 … 09:00   Introductions and Workshop Objectives
09:30 An Overview to Demand-Driven MRP
11:30 The Information Flow of a DDMRP System
12:30 Lunch
13:30 Demonstration of DDMRP System
14:30 How to Set Up Input Files and Operate System
16:00 Looking at the Reports
17:00 End of the day
Day 2 … 09:00 Fast Excel Development Principles
11:00 Exercise 1: Setting up and Running the System
11:30 Exercise 2: Running the System with New Demand Scenarios
12:30 Lunch
13:30 Exercise 3: Setting Up Input Data for a Pilot Deployment
14:00 Exercise 4: Creating Custom Reporting
15:00 Implementation Clinic with Some Real-World Examples
17:00 End of Workshop


Registration is now closed