Why excess inventory doesn’t prevent stockouts.
A full warehouse does not mean customers can get what they need. The business may have plenty of inventory overall and still be short of the right item, in the right place, at the right time. Solving that problem requires better decisions, not simply more or less stock.
- Written by
- Ronnel Boettcher
- Drafted
- September 3, 2026
- For
- Owners, finance leaders, buyers, and supply chain teams
The total is not what customers experience.
Company-wide inventory can hide the decisions that matter. One product may have years of supply while another loses sales this week. One location may be full while another waits for a transfer. Incoming stock may already be committed even though the ERP still makes it look available.
The useful question is not only “How much inventory do we have?” It is “After accounting for what is arriving and what is already promised, how much of this product will be available where and when customers need it?”
Once the business sees inventory at that level, excess and shortages stop looking contradictory. They are two outcomes of the same planning problem.
A simple example
Suppose a product has 500 units in stock and 200 more arriving, but 300 units are already promised to customers. The business does not have 700 units available for new demand. It has 400. That is the amount the next purchasing decision should begin with.
Low demand · High stock
Cash tied up
Pause or reduce restocking while the existing stock sells.
High demand · High stock
Demand covered
Confirm that the quantity is justified by delivery time and the importance of staying in stock.
Low demand · Low stock
Little cash at risk
Review whether this item needs to be stocked here at all.
High demand · Low stock
Sales at risk
Restock, move available inventory, or use a faster supplier before sales are lost.
Not all excess inventory is the same.
Before cutting purchases, separate the reasons the inventory exists. A blanket reduction can remove useful protection while leaving the real surplus untouched.
Stock for normal demand
Often called cycle inventory
The stock created by the normal size and timing of each purchase or production run. Larger minimum quantities, shipping costs, and supplier discounts can all lead to bigger orders.
Protection against uncertainty
Often called safety inventory
The extra stock held because demand may exceed the forecast or a delivery may arrive late. It reduces the risk of running out, but it also ties up money.
Stock in the wrong place or time
Sent to the wrong location or at the wrong time
Useful products can still become excess when they are held in the wrong location, arrive too early, or were ordered for demand that has since changed.
Stock with little remaining demand
Slow, obsolete, or dead stock
Some inventory is genuinely difficult to sell. But it should not be confused with active products that were simply ordered in excessive quantities or sent to the wrong place.
Five reasonable decisions can create an unreasonable result.
Excess rarely comes from one obviously bad purchase. It builds when individually understandable decisions reinforce one another across many products and planning cycles.
- 01
The order was economical, but too large
A minimum order, full-container target, quantity discount, or fixed delivery cost can make a large purchase look cheaper. The unit price falls, but more cash becomes tied up in stock.
- 02
The plan is older than the decision
Demand, stock, and customer orders change after a long-range plan is approved. If nobody checks the latest numbers before buying, producing, or shipping, the business keeps acting on an old picture.
- 03
Every product receives the same protection
Giving every product the same number of months of stock is simple, but products do not behave the same way. A steady seller, an irregular item, and a new product should not automatically receive the same extra stock.
- 04
Recorded sales understate real demand
A product cannot record a sale while it is unavailable. Quotations, unfilled orders, substitutions, and repeated customer requests can reveal demand that the sales history alone missed.
- 05
The cheapest source is judged only by price
A lower purchase price may come with longer lead times, larger shipments, and less room to correct a mistake. Emergency buying later can erase the apparent saving.
Use long-term and short-term plans together.
Long-term and short-term plans do different jobs in the same system. A longer view gives the business time to secure supply, plan capacity, and buy efficiently. A shorter view helps it respond when demand, stock, or delivery conditions change.
For example, a business might order 10,000 units based on expected demand over the next three months. Weekly updates can then show whether the total plan should change and which stores, branches, or customers now need those units most.
Longer-term plan
Plan for efficiency
Use the longer-term forecast, current inventory, incoming orders, and supplier lead time to secure capacity and purchase or produce at a lower total cost.
Short-term updates
Stay responsive
Use the latest demand, stock, and delivery information to adjust the plan, direct inventory where it is needed, and respond when something changes.
A longer view creates better buying options.
A lower-cost supplier may require an order two or three months before the stock is needed. Without a dependable view of future demand, the business must either commit based on guesswork or wait and buy from a faster, more expensive source.
A reliable 12-week forecast changes that decision. The demand the business can plan with confidence can be ordered earlier from the lower-cost supplier. Short-term updates can then cover unexpected demand, delays, or changes through a faster supplier when needed.
The forecast does not create the price difference. It gives the business enough confidence and time to capture it without blindly over-ordering. The full comparison should still include freight, financing, minimum quantities, the cost of holding stock, delay risk, and the cost of emergency purchases.
Make better inventory decisions every week.
The arithmetic is not the difficult part. The difficult part is keeping the data current, applying the rules consistently, and showing people a recommendation they can understand and improve.
- 01
Start with what is truly available
Count usable stock and stock arriving in time, then subtract what is already promised to customers or assigned elsewhere. A forecast should not create a new order for stock the company effectively already owns.
- 02
Plan for more than one possible outcome
Estimate likely demand and how much it may vary for each product, location, and period. Compare the forecast with the company's current method and with what actually happened before trusting it.
- 03
Choose how much extra stock each product needs
Consider the product's margin, importance, delivery time, supplier reliability, and the cost of running out. These differences can justify holding more protection for some products than others.
- 04
Apply the real purchasing limits
Account for lead times, case sizes, minimum orders, supplier schedules, shelf life, capacity, and budget. The recommendation must fit the way the business actually operates.
- 05
Show people what needs attention
Show buyers the likely shortages, unnecessary purchases, late deliveries, unusual demand, and stock that should be paused or moved. Keep approval with the people responsible.
- 06
Measure both sides of the result
Track products in stock and total inventory together. A policy that cuts stock but creates lost sales has failed; a policy that protects every possible sale with unlimited stock has also failed.
Connect the forecast to the decision.
ToolPlex connects sales, inventory, purchasing, and product data from the systems a company already uses. It builds the forecasts and purchasing rules behind the decision, then gives teams one place to review recommendations and the items that need attention.
In our work, these two parts solve different problems. The forecast shows where demand is likely to appear. Current stock, incoming orders, and customer commitments stop the business from buying or sending more where enough already exists. Both are needed.
Buyers remain in control. They can inspect the assumptions, change a recommendation, and ask questions in plain language. The system records the decision and measures what happened so the next cycle starts with better information.
Read the practical guide to demand and inventory planning →Questions about stockouts and excess inventory.
How can a company have excess inventory and stockouts at the same time?
Inventory can be concentrated in the wrong products, locations, or periods. A large company-wide total does not guarantee that the item a customer wants is available where and when it is needed.
Will a more accurate demand forecast solve the problem?
A better forecast helps, but it is not enough by itself. The decision must also account for stock on hand, stock already ordered, delivery times, minimum quantities, and how often the company is willing to run out.
Should every product have the same safety stock target?
Usually not. Products differ in demand, margin, importance, delivery time, and supplier reliability. The extra stock held for each product should reflect those differences.
Do we need to replace our ERP to improve inventory planning?
Usually not. If the ERP reliably records sales, stock, purchases, and products, ToolPlex can connect those records with forecasting and planning tools without replacing it.
What is a practical place to start?
Choose one recurring purchasing, production, or restocking decision. Work out what stock is truly available, compare the current rule with actual demand, and test whether a better recommendation would reduce shortages or unnecessary stock.
Further reading: Sunil Chopra, Supply Chain Management: Strategy, Planning, and Operation, particularly the chapters on forecasting, cycle inventory, safety inventory, product availability, transportation, and sourcing. The framework above also reflects lessons from ToolPlex planning work on operating data.
Start with one recurring inventory decision.
Choose a purchase, production, or restocking decision where shortages and excess appear together. Test the current rule on your own history, build a better recommendation, and measure both products in stock and total inventory.