One of the counter-intuitive rules of inventory management is that after a sudden drop in sales (like the one many of our clients are experiencing) inventory on-hand will rapidly increase before falling back below its original level. This is because vendor purchase orders are, to some extent, created to replace future sales that are going to occur during leadtime. If sales during leadtime are lower than expected, there will be more inventory remaining on the shelf when receipts arrive, leading to excess stock.
The chart below shows a hypothetical client that has around $1MM in weekly COGS, and typically has $4MM in inventory, with another $4MM in open POs not yet received. Leadtime is 2 weeks. At week 3, we’ve modeled a 25% sales drop. We assumed that the drop was immediately detected and that inventory targets (and thus purchasing) were immediately reduced:
Note that despite a drop to zero purchasing as we attempt to draw down the inventory, dollars on hand increases 12.5% to $4.5MM before finally starting to fall.
Had vendor leadtime been longer, the increase in inventory would be proportionally larger. For example, if this was an overseas vendor with a 12 week leadtime instead of the 2 week leadtime modeled, inventory would continue to build by $250k per week to a total of $7MM, a 75% increase! That increase will happen regardless of reductions in purchasing, because all of that excess stock was already on order when the sales drop occurred.
There are a few ways to minimize the damage from rising inventory value if there is a sudden drop in sales:
Contact us to learn more.
Introduction In the aerospace MRO sector, operational efficiency is paramount. Downtime is costly, and delays in maintenance or repair can have significant ripple effects. Further, the aerospace industry requires stricter quality control and compliance with government regulations. For example, aerospace
Managing shelf life and obsolescence represents a critical challenge for aerospace MRO (Maintenance, Repair, and Overhaul) providers, often leading to significant inventory loss. Without robust strategies in place, these organizations can experience significant financial drains due to expired or outdated
As the prospect of new import tariffs emerges in 2025, organizations must proactively adopt strategies to mitigate potential risks and strengthen the efficiency of their global supply chains, which are vital for keeping aircraft operational. Recommended strategies Drawing on lessons
Get updates on the latest news across all core inventory-related processes.
Subscribe now!
Your email is safe with us, we dont spam.
