Online Inventory Management Course & Certification
Inventory Management Expert™
The complete method to reduce stockouts and overstock by 10 to 30%
Regain visibility & control
Get serenity
Your first steps towards mastering Inventory Management
Not sure where to start yet? Try out our free 7 day video training or test yourself!
This test consists of a 10 minute quiz that will evaluate your Inventory Management knowledge. At the end, you’ll know if you need to upgrade your skills and in which area.
Get the free INVENTORY MANAGEMENT EXPERT™ mini-training
The last 4 years have been very intense: Pandemic, transportation crisis, geopolitical tensions, inflation and market volatility…
All those factors impact dramatically supply chains in all industires across the world: we have lived an emotional rollercoaster with big demand and lead time fluctuations
How can we effectively optimize our inventory levels?
Many professionals can’t get their heads out of operations.
Consequently, they don’t know where to start. They wait forever for demand or lead time to stabilize – or they seek to enhance their rigid ERP systems instead of getting their first results in simple tools such as Excel.
The solution is to start being proactive and to get to the point immediately with a structured method:
- Extract and clean data from your ERP/Software to Excel
- Classify your products/suppliers
- Set up inventory replenishment rules depending on your classification
- Reduce your inventory short-term by focusing on the essentials
- Optimize your inventory long-term to have lasting results
- Supply Chain Professionals
- Planning and Forecasting Roles
- Leadership and Management Positions
- Data and Analytics Roles
- Consulting and Expertise Roles
From Foundations to Expert Level
Build the file to regain control over your inventory
FOUNDATIONS LEVEL: Master the 5% of Actions for 40% of Results in 3 Hours
- Edouard teaches you everything you need to know if you start from scratch
- When & How much to order
- Different Inventory Management Policies
- The Essential KPIs
- 9 Essential parameters
- Seasonality in 30 minutes
- Automatic Min/Max Reorder Excel Template
- Simple Automatic dashboard
PROFESSIONAL LEVEL: Master 20% of Actions for 80% of Results in 5 hours
- Uncertainty of demand
- Supplier uncertainty (long lead times)
- ABC XYZ target service rate
- Economic order quantities (EOQ)
- Dynamic order point
- 6 ways to calculate your safety stock (and how to choose the one fitting your business)
- Complete Excel file with dynamic safety stock
- Parameters Optimization
- How to analyze your reorder file (Orders Management)
EXPERT LEVEL: 45-steps Consultant Checklist to go to the next level
- File creation: Data Consolidation & Cleansing
- KPIs, Dashboard & Analysis: How to analyze your dashboard to skyrocket your results
- Order Management: Automatic reorder system to get big short-term gains
- Demand & Forecast: Forecast Review, New Products Review, Stabilizing demand, Reducing product range
- Procurement & Suppliers: MOQ Review, TCO approach, Payment terms, Cash-to-cash cycle
- Logistics & Distribution: stock take, Multi-Echelon Inventory Optimization, storage capacity optimization
- Software & Innovation: automate your file & ERP, tips on using RFID/Blockchain & Machine Learning
- Communication & Action Plan: defining priorities, efficient presentation, empowering teams
“With 15 years of experience in Supply Chain Performance Management, I have held positions as a Supply Chain Manager, S&OP Manager, and Supply Chain Director in various countries and sectors.
Mastering the skill I teach in my methods has allowed me to make better decisions, outperform my colleagues, and advance in my career.”
Check the full course curriculum
Module in the PRO course
Introduction
- Welcome & Instructions
- Why Inventory Management is so important
- How I Became an Expert
- How you will become an Expert
- How to get certified
- Excel version I recommend
Foundation Level (1/2)
- Different Inventory Management Policies
- When to Order
- How Much to Order
- Excel File Introduction (Download)
- Table Structure and Range List
- Finish Goods? Components? Raw Material?
- Data Extraction
- Integrate Data: Sales
- Stock and Transit
- KPIs Availability
- Inventory Turnover
- Slow and Obsolete Stock (SLOB)
- ABC Analysis
- Average Sales (Demand)
- Lead Time
- Lot Size & Minimum Order Quantity (MOQ)
- Min-Max Simple Formula
Foundation Level (2/2)
- Introduction to Seasonality
- Seasonality Coefficient in Excel
- Target Service Level
- Quantity to Order
- Zero values for Min & Max
- Urgent Orders and Transport Optimization
- Dashboard creation (Optional)
- Update and analyze the file
Professional Level (1/2)
- Pro Excel File Introduction (Download)
- ABC XYZ Analysis Introduction
- XYZ Analysis in Excel (Method 1)
- XYZ Analysis: check data points
- Method 2 for XYZ Analysis and more
- Supplier Uncertainty – Average Lead Time
- Cap the Maximum Lead Time
- Supplier and Lead Time Uncertainty Level
- Economic Order Quantity (EOQ) in Excel
- EOQ Limits & Optimization
Professional Level (2/2)
- Safety Stock Introduction
- 6 Methods for Safety Stock
- Choose the right Safety Stock method
- Limits of the Normal Distribution
- Define the Service Target with ABC XYZ
- Reorder Point
- Min Max vs Safety Stock in Excel
- Quantities to Order
- Urgent Orders & When to Order
- Update the File
- Analysis & Parameters Optimization
- Different ERP Methods
Module in the EXPERT course (including PRO)
Expert Level – Introduction & Checklist (1/8)
- Expert Level Introduction (Checklist Download)
- Tips if Excel is too slow
- Get data
- Data consolidation
- Use Power Query to update your file (optional)
- Fix the links error and update the file (optional)
- Data cleansing
Expert Level – KPIs, Dashboard & Analysis (2/8)
- Availability KPIs
- Fill Rate KPIs
- Obsolete Stock & Inventory Accuracy
- Forecast Accuracy KPIs
- Stock Turn per Item (with Forecast)
- ABC Analysis with Forecast
- XYZ Analysis with Forecast Accuracy
- Sales Projection
- Inventory Projection
- Inventory Target and Inventory Gap
- Dashboard creation & update
- Dashboard Analysis & Priorities
Expert Level – Orders & Replenishment (3/8)
- Cancel Orders for discontinued stock
- Reduce discontinued stock
- Cancel or Postpone Orders for Active Items
- Reduce Active Inventory & Extend Duration
- Items blocked check
- Cancel late & early orders
- Reset all manual parameters
- EOQ review
- Safety Stock review
- ABC XYZ target optimization
- Reorder Point & Order Adjustment
Expert Level – Demand & Forecast (4/8)
- Short Term Forecast Review
- Forecast Introduction: When & How many
- Long term forecast review + tool (NEW)
- How to manage New Products (NEW)
- New Products Review in Excel
- Stabilize the Demand
- Reduce the number of items
Expert Level – Procurement & Supplier (5/8)
- Supplier Performance Review
- Supplier MOQ Review
- Improve Payment Terms
- Total Cost of Ownership (TCO) Approach
- Consignment stock
Expert Level – Logistics & Distribution (6/8)
- Inventory Accuracy & Stock Take
- Shortage Management
- Multi-echelon Inventory Optimization
- Reduce the Number of Storage Locations
- Reduce Lead Time
- Keep your Warehouse Full
Expert Level – Automation, Software & Innovation (7/8)
- Keep your Data Clean & Stable
- Automate this File: 3 Solutions
- Keep your Inventory Management Automatic
- Migrate from Excel to a Software (ERP, WMS)
- Use Machine Learning & AI
- Use RFID (Radio-frequency identification)
- Use Blockchain
Expert Level – Communication & Action (8/8)
- Choose your Battles (Actions & Priorities)
- How to Have an Efficient Presentation
- How to master PowerPoint in 10 minutes (Download)
- Create the Presentation Quickly
- Empower your Team
- Go to the Next Level
3 Bonuses
- Survival Kit for a Demand Explosion
- Survival Kit for a Demand Drop
- My 13 Commandments (Download)
Automate with Power Query (Bonus)
- Introduction to Power Query & Fix the links (Download)
- Insert Stock & Transit Tables Automatically
- Remove Column Automatically (Price)
- Clean Automatically
- Append 2 Different Files (Sales)
- Clean and Append 4 Different Files (Orders)
- Update this File and Go to the Next Level
Jan 12, 2024
… “Inventory Management Expert” course, and it exceeded all expectations. The pedagogy used is great… read more
Inventory manager expert
I admit the design of its courses is brilliant followed by a good pedagogy that allows you to learn at your own pace and when you want. … read more
INVENTORY MANAGEMENT EXPERT™
Inventory Management
PRO
Core skills to track and optimize inventory & service levels according to demand and supply
-
Foundation Level: Master the 5% of Actions for 40% of Results in 3 Hours
-
Pro Level: Master 20% of Actions for 80% of Results in 5 hours
-
Official certification to prove your expertise and boost your career
-
Expert Level: 45-step Consultant Checklist
-
1 coaching call with Edouard to get you to the next level
-
Manage a Demand Drop in 6 steps
-
Manage a Demand Explosion in 6 steps
-
Forecast Generator Excel Tool
-
Automate your Inventory Management with Power Query / Power Pivot
-
Amazon Inventory Management Secrets
Inventory Management
PRO+EXPERT
Master Expert tools and methods to reduce stockouts and overstock by 10% to 30%
-
Foundation Level: Master the 5% of Actions for 40% of Results in 3 Hours
-
Pro Level: Master 20% of Actions for 80% of Results in 5 hours
-
Official certification to prove your expertise and boost your career
-
Expert Level: 45-step Consultant Checklist
-
1 coaching call with Edouard to get you to the next level
-
Manage a Demand Drop in 6 steps
-
Manage a Demand Explosion in 6 steps
-
Forecast Generator Excel Tool
-
Automate your Inventory Management with Power Query / Power Pivot
-
Amazon Inventory Management Secrets
This program is aimed at anyone wishing to improve their supply chain skills and inventory management in particular :
-Professionals working in supply chain
-Professionals working in logistics
-Professionals working in procurement
-Professionals working in transport
-Professionals working in finance
-Professionals working in industry / production
-Professionals working in data science / Business Analysts
-Business Analysts
-Supply chain consultants
-Executives (COO, CFO, Directors, VP …)
-Entrepreneurs who need to improve their cashflow, profit and revenue
-And anyone wishing to become an expert in this strategic field
On the other hand, a beginner’s level in Excel (basic functions such as Vlookup, Sum, If …) is useful to rebuild the dashboards quickly (Don’t worry, I record my screen step by step).
It is also important to have a stable Internet connection and Microsoft Excel installed on your computer.
Once you have registered, you will immediately be emailed access to a site reserved exclusively for program members. There you will see videos and downloadable files organized into modules that cover everything you need to know one by one. We’ll get right down to business with simple examples and methods.
We all have different schedules. This is why our program is based on your availability and your desire to improve your skills quickly.
The most motivated members managed to complete this program in less than 7 days from 5 hours of work per day over 5 days.
If you are employed, the average duration to complete this program is 4 to 5 weeks, or 4 hours per week for 5 weeks.
The busiest (Directors, Managers and firefighters from the supply chain 🚒 …) will complete this method in less than 2 months, i.e. 2 hours per week.
My programs are designed to last no more than 20 Hours in total, as I know your time is valuable, that’s why I will go straight to the point.
Each module is broken down into small episodes of less than 10 minutes to allow you to progress quickly and at your own pace. There are 147 in total with plenty of quizzes and exercises to practice and validate your skills.
In addition, you have access to a hundred videos (15 hours) where I share the best questions and answers from my members. This is an exclusive toolkit for my members only (See the “Consultations with Edouard” section)
The resources (videos, tools, downloadable files) will be available immediately after your payment has been confirmed.
You will then have 1 year of guaranteed access to complete the course. By completing the course before this deadline, your access will be extended for 5 years to motivate you to complete the course (most of our member complete this program in less than 5 weeks).
The resources are regularly updated with feedback from our participants and the evolution of tools and trends in Supply Chain and Logistics.
The certificate, Excel and Power Point downloads will be available for life.
You do not necessarily need to have experience in supply chain and logistics. This program will start with an introduction to the main principles before going into more detail on techniques and methods.
Excel 365 is used in this program. The files are compatible with versions 2003, 2007, 2010, 2013, 2016, 2019 and office 365 in English. Otherwise, your version must be compatible with Open Office on the basic formulas. The file is also compatible with Mac, the interface is however slightly different.
- With the Expert formula, you get access to the method in a replay platform, allowing you to go at your rhythm. Some very motivated trainees will go through it in a few days, while others will take a few weeks with less time. I record my screen as I optimize my stock with concrete examples in front of you. Then, all you need to do is repeat my actions with your data. Or you can use mine to practice.
- In addition to your Expert formula, I will record 1 video of personalized coaching after you’ve enrolled to analyze your objectives, blockages, and LinkedIn profile. My goal will be to give you all the advice and tricks you need to boost your performance and career rapidly.
- You also have access to an unlimited video database of the program to allow you to apply the method immediately and be certified in a few weeks.
- In the consulting package, I will train your team (Masterclass by videoconference), and you will get an unlimited review of your work for 90 days. Currently, I’m only taking on one new client per trimester.
After you place your order, you have 60 days to review the course, apply my advice and decide if it meets your expectations.
If you have not progressed, simply send an email to receive a 100% refund.
The only condition to be eligible for a refund is to try the techniques that are revealed in this program. (The only exception is the “Private Consulting” hours which are non-refundable)
If you would like to certify more than one person from your team and receive individual support, please contact us at the bottom of this page. We offer additional bonuses for the registration of several people from the same company.
The program only opens for a few days each year to ensure quality follow-up for old and new members.
When the program opens, you can join today and not start for several weeks or months. Start at your own pace. However, I recommend that you dedicate at least 30 minutes a week to the program to get quick results.
Already an Inventory Management Expert ?