It shows up as too much inventory in the wrong SKUs, too little inventory in the right ones, rush freight that should never have happened, suppliers no one mapped beyond tier 1, and software projects that cost a fortune without changing daily decisions.
That is why supply chain problems are so dangerous for companies in the $50 million to $1 billion range. They are big enough for complexity to hurt, but usually not big enough to absorb enterprise-scale waste.
The good news is that most of the damage comes from a handful of fixable operating mistakes. Below are the five we see most often, why they are expensive, and how mid-market brands can correct them without launching a bloated transformation program.
Planning on spreadsheets and disconnected teams
This is still far more common than most executives want to admit. McKinsey reports that close to three-quarters of supply chain functions still rely on spreadsheets for planning. At the same time, 90% of executives plan to implement a new planning solution within five years — meaning leaders know the current state is broken, but many organizations are still living with it today.
Why It Gets Expensive
When planning lives in spreadsheets: sales, operations, procurement, and finance work from different assumptions. Teams react late to demand changes. Exceptions get buried until they become expedites or stockouts. Forecast error compounds across purchasing, production, and distribution.
For a $200M brand, a few points of avoidable stockouts can mean millions in lost revenue. A few weeks of excess inventory can tie up millions in cash and trigger markdowns later.
What Good Operators Do Instead
- Create one decision-making cadence across demand, supply, and inventory
- Segment SKUs by volatility, margin, and service criticality
- Define exception thresholds so teams work the few issues that matter
- Use AI and automation selectively, where the data and process are ready
McKinsey found that AI-enabled planning in consumer goods can drive up to 4% revenue uplift, 20% lower inventory, and 10% lower supply chain costs when paired with process redesign.
Practical Fix
Don’t start by buying a massive new platform. Start by answering: Which planning decisions are made too late? Which metrics drive those decisions? Which data feeds are trusted enough to automate the first use case?
The first win is usually better exception management, clearer ownership, and faster replanning in a few high-value categories.
Measuring inventory as a total number instead of a portfolio
Many companies tell themselves inventory is “fine” because the top-line number looks stable. That’s misleading. You can have too much inventory overall and still be out of stock on the exact items your customers want — paying carrying costs, taking markdowns, and disappointing customers at the same time.
Target’s 2022 inventory correction is a useful public reminder. The company announced additional markdowns, canceled orders, and other actions to remove excess inventory — later disclosures showed how heavily profitability was pressured by clearance activity.
Why It Gets Expensive
Cash gets trapped in slow-moving stock. Margin gets hit when that stock is liquidated. Service levels drop because the wrong inventory was funded. Mid-market brands feel this more because they have less room to hide working-capital mistakes.
What Good Operators Do Instead
- Re-segment inventory by demand behavior, margin profile, and service promise
- Set service levels intentionally instead of treating all SKUs the same
- Separate hero items, seasonal bets, long-tail items, and strategic buffer stock
- Build replenishment logic around channel and node, not just total demand
In practical terms, this means treating inventory as a portfolio allocation problem, not a warehouse occupancy problem.
Practical Fix
Run an inventory policy reset: identify SKUs creating the most excess stock, identify SKUs creating the most lost sales, compare current stocking logic with actual demand behavior, and redesign reorder points and minimum order quantities.
Focus on the categories where margin, lead time, and volatility interact badly — that is usually where the hidden cash sits.
Treating suppliers as transactions, not a network
Most teams know their direct suppliers. Far fewer understand their sub-tier dependencies, logistics chokepoints, or shared failure points. BCI’s 2024 Supply Chain Resilience Report found that 43.6% of organizations experienced disruption due to third-party failures, while only 17.1% mapped critical suppliers down to tier 4 and beyond.
Why It Gets Expensive
Critical subcomponents become single points of failure. Teams discover concentration risk too late. Alternate sourcing takes months instead of days. Customer commitments get missed because the real bottleneck sat upstream.
This is especially painful in automotive, FMCG, and branded consumer goods with concentrated supplier footprints.
What Good Operators Do Instead
- Map critical suppliers deeper than tier 1
- Identify components and materials with no viable substitute
- Score suppliers on continuity, quality, geography, financial health, and compliance
- Build response playbooks before the disruption, not during it
McKinsey’s 2024 survey shows 73% of companies report progress on dual sourcing, and 60% are acting to regionalize supply chains. Resilience is no longer optional.
Practical Fix
Pick the top 20 suppliers or components by revenue risk, not spend. Then answer: Where is the real choke point? What happens if that supplier fails for 30 days? Do we have a qualified alternative?
Most mid-market companies need a disciplined mapping sprint and an owner for the output, not a giant risk platform.
Buying software before fixing process
This is one of the most expensive traps in supply chain transformation. A company decides the answer is a new planning platform, ERP module, control tower, or AI layer — before the team has agreed on decision rights, process design, KPI logic, or rollout priorities.
McKinsey reports that 60% of supply-chain-planning IT implementationseither take more time or money than expected or don’t achieve anticipated business outcomes. Companies average 2.8 years from vendor selection to complete rollout. Even less-complex CPG companies can spend about $17.5 million on a new planning system.
Why It Gets Expensive
No one agrees on what the process should be. The data model reflects current confusion. The implementation tries to solve everything at once. Adoption is treated as training, not operating-model change. The result: high spend, low trust, and limited value capture.
What Good Operators Do Instead
- Design the target planning and decision process first
- Define 2-3 priority use cases before broader rollout
- Tie the business case to a short list of operational outcomes
- Roll out in stages based on measurable value
A platform can be the right answer. It is just rarely the first answer.
Practical Fix
Before selecting any supply chain software, lock five items: the decision that needs to improve, the KPI that proves it improved, the process owner, the data source of truth, and the first pilot scope. If those are unclear, the project isn’t ready.
Treating nearshoring and sustainability as side projects
In many companies, regional sourcing, tariff exposure, supplier compliance, and sustainability reporting still sit in separate conversations. That is a mistake — these are now part of the same operating problem.
CDP and BCG reported that corporate supply chain Scope 3 emissions are on average 26 times larger than direct operational emissions. Meanwhile, many brands are shifting toward multi-shoring rather than pure nearshoring — the landscape is more nuanced than headlines suggest.
Why It Gets Expensive
Sourcing decisions ignore resilience and compliance tradeoffs. Companies underestimate total landed cost. Supplier risk gets hidden until a customer or regulator asks. Teams chase “local” moves that don’t actually improve economics.
What Good Operators Do Instead
- Evaluate sourcing moves with total landed cost plus resilience cost
- Add traceability and supplier data to sourcing decisions early
- Integrate sustainability requirements into procurement scorecards
- Treat regionalization as a portfolio decision, not a slogan
Practical Fix
Pick one strategic category and model three scenarios: current-state sourcing, partial regionalization, and diversified multi-shoring. Compare them on gross margin, working capital, lead time, disruption risk, and customer/compliance requirements.
That one exercise usually reveals whether the current network is actually fit for the next three years.
What to Do in the Next 90 Days
Find the cash leak — quantify where inventory, expedites, markdowns, and service failures are destroying margin.
Map the real risk — identify the suppliers, components, and logistics lanes that could shut down revenue fastest.
Reset planning discipline — tighten cadence, metrics, ownership, and exception management before expanding tools.
Prioritize one high-value use case for AI or automation — demand sensing, supplier-risk alerts, or replenishment exceptions.
Treat network design, resilience, and sustainability as one decision set — if they stay separate, your strategy stays fragmented.
The Atelier Supply Co Point of View
The biggest mistake mid-market brands make is assuming they need either a giant consulting firm or a giant software program. Usually they need neither.
They need a craftsman — a partner who can identify the highest-value supply chain failures, design a tailor-made operating model, and help the team execute practical fixes quickly.
That is where Atelier Supply Co fits. We don’t recycle frameworks or force-fit someone else’s playbook onto your operation. We craft bespoke solutions around your products, your markets, your margins, and the way your team actually works.
Your supply chain, by design.
Sources
- McKinsey, To improve your supply chain, modernize your supply-chain IT, 2021
- McKinsey, Better supply-chain planning with AI and machine learning, 2021
- McKinsey, Harnessing the power of AI in distribution operations, 2024
- The BCI, Supply Chain Resilience Report, 2024
- McKinsey, Global Supply Chain Leader Survey, 2024
- CDP & BCG, Scope 3 supply chain emissions, 2024
- Kearney, 2025 Reshoring Index
- QIMA, 2025 Q1 Barometer
Related Insights
What Is S&OP and Why Most Mid-Market Companies Get It Wrong
S&OP is the #1 process gap in mid-market companies. Five reasons most companies fail — and a practical framework for getting it right.
Read articleBuilding a Resilient Supplier Network
73% of companies experienced supply disruption in the last 2 years. A 5-step framework for APAC brands.
Read articleHow to Choose Supply Chain Software Without Wasting $2M
60% of supply chain IT implementations fail or overrun. Here are the three mistakes mid-market companies make.
Read articleThe Real Cost of Nearshoring
China+1 strategies are accelerating, but unit cost savings rarely tell the full story.
Read articleSupply Chain Health Check
Score your supply chain across 10 critical indicators. Identify your biggest gaps in under 5 minutes.
Take the Free Assessment