The "Shadow Excel" Reality: Why Black-Box AI is Failing Your Demand Planners

Written by Daniel Šlikas, Head of Operations at SDG Group USA

Phantom demand is the silent killer of the P&L. We’re told that AI will solve everything, but the reality is that current models still can’t separate a planned promotional lift or a random viral trend from the true baseline. The system overreacts, your black-box AI panics, and suddenly you’re ordering six months of raw materials right before the trend dies. The result? Out-of-stocks on one side, massive waste on the other.

This "Signal-to-Execution Gap" isn’t theoretical; it’s where companies bleed margin every single day.

Real-World Blind Spots

Throughout my career, I’ve watched the same "black box" traps play out across industries:

• The Viral Trap: I’ve seen heritage brands hit by a sudden 400% viral spike that their AI interpreted as a permanent shift in consumer behavior. The system over-indexed on specialty glass and resins just as the trend evaporated, leaving the company with safety stock levels 3x higher than actual demand. The fallout? Deep-discount liquidations that gutted their brand equity.

   

• The Lead-Time Ghost: I’ve watched AI engines that "learned" during the supply chain chaos of a few years ago continue to hold 12-month lead times in their logic—even as ports cleared and actual lead times dropped back to 4 weeks. In today’s high-interest-rate environment, that’s a multi-million dollar cash-flow chokehold that Finance can't explain until the warehouse hits 110% capacity.

• The Cannibalization Blind Spot: A major player ran a massive promotion on "Flavor A." The AI saw the lift and screamed "Growth!", failing to realize it was simply stealing 40% of the sales from "Flavor B." The system kept production high for both, leading to a massive SLOB (Slow-Moving and Obsolete) write-off three months later. The "demand signal" was just an internal shift, not market expansion.

Breaking the "Shadow Excel" Cycle

When demand planners get burned by a black box no one understands, they lose trust. They go right back to overriding the system and running the business out of a "Shadow Excel" file anyway.

You don't need more buzzwords; you need a signal-driven loop with explainable forecasting that your team actually trusts.

More importantly, you need a system that isn't an operational straitjacket. I’ve seen companies lose a $20M sales opportunity because their automated workflow was too slow to recognize a competitor’s supply failure. Real agility requires a solution dynamic enough to allow for a "fast-track" when a high-stakes deal hits the desk.

A Straight-Talk Approach

We don’t bring a "one-size-fits-all" fantasy. We’ve built a demand engine tailored to your company’s specific maturity and operational needs. It connects demand directly to the production floor without the operational chaos, ensuring you can move at the speed of the retailer without flying blind.

If we don’t bridge this gap, we stay trapped in the same loop—constantly explaining warehouse write-offs, paying the "Panic Tax" of expedited freight, and missing sales targets.

I’m not bringing a pitch deck; I’m bringing the math on how to balance a standardized process with a tailored, scalable solution. Let’s have a straight-talk conversation and look at the logic to see if it fits your current decision cycles. Connect with us here.