The Hidden Cost of Manual OTB: Time, Risk, and Missed Decisions

The Hidden Cost of Manual OTB: Time, Risk, and Missed Decisions

In the previous post, we explored why Excel‑based Open-to- Buy becomes a bottleneck—how manual updates, fragmented data, and outdated cadences undermine in‑season decision-making. But the real problem with manual OTB isn’t inefficiency.

It’s the hidden cost.

This article examines the manual Open-to- Buy risks that quietly erode sales, margins, and team effectiveness over the course of a season.

These costs rarely show up as system failures or broken processes. They don’t trigger alarms or appear as a single line item on the P&L. Instead, they quietly erode sales and margins over the course of a season—through lost time, delayed decisions, compounding risk, and exhausted teams.

By the time the impact is visible, the opportunity has already passed.

Time Isn’t Just Spent — It’s Wasted

When teams discuss the cost of manual OTB, they usually focus on the hours spent. “

   “We only refresh it once a week—it’s too time‑consuming.” 

   “It takes half a day to update.” (As mentioned in our second blog, this only occurred if everything was aligned, and that rarely happened). 

But that framing understates the problem. The true cost isn’t the hours spent updating the OTB. It’s the hours not spent thinking, analyzing, and deciding.

In a manual OTB environment:

•  Planning time is consumed by data prep, not insight
• Senior planners act as data processors
•  Meetings revolve around validating numbers instead of debating actions

Highly skilled, highly paid teams spend their time maintaining spreadsheets only to produce a version of the truth that’s already aging by the time it’s reviewed. That’s not just inefficient.
It’s a systematic misallocation of talent.

Delayed Numbers Mean Delayed Decisions

Manual OTB processes introduce an unavoidable lag:

• Actuals must be pulled
• Files must be updated
• Assumptions must be reconciled
•  Versions must be aligned across teams

 Only then is the OTB considered “ready.”

 In today’s retail environment, that delay matters.

• Sales trends don’t wait for Monday updates.
• Vendor lead times don’t pause for reconciliation.
• Opportunities don’t politely reappear next month.

When OTB visibility lags reality:

• Overspend isn’t caught early enough
• Unused budget isn’t unlocked in time
• Course corrections happen after the window of opportunity closes

Teams may believe they’re being disciplined by waiting for clean numbers. In practice, they often make decisions too late or do not make them at all.

The Illusion of Precision

Excel creates a powerful, dangerous sense of confidence.

A spreadsheet with perfectly balanced totals, clean formulas, and decimals carried to two places feels trustworthy; it provides a sense of comfort.  But precision doesn’t equal accuracy.

In a manual OTB:

• Actuals may already be outdated
• Receipt timing may reflect assumptions that no longer hold
• Forecasts may lag real in‑season trend shifts
• Logic may vary subtly between files

The numbers look exact, but they’re resting on a fragile stack of manual inputs and assumptions.

This illusion of precision is often worse than openly imperfect data—because it discourages challenge. Teams trust the spreadsheet, even when instinct says something is off. And by the time reality forces a correction, options are already constrained.

Risk Scales with Frequency

Ironically, as the business demands more frequent OTB updates: weekly vs monthly, risk increases.

Every update introduces:

• Another manual extract
• Another paste
• Another chance for a broken formula or misaligned range

During peak season, speed matters—but speed and manual processes don’t mix.

Under pressure, teams:

• Shorten validation steps
• Reuse prior assumptions
• Patch spreadsheets instead of fixing root issues

Errors rarely announce themselves. They blend in—quietly influencing buying decisions that affect inventory exposure and cash flow weeks later.

And by the time the error becomes visible?  The merchandise is either already on the water or in the air.

The Human Cost No One Talks About

There’s another cost that rarely gets measured: burnout.

Manual OTB processes:

• Create recurring crunch points
• Penalize teams for being thorough instead of fast
• Make planners accountable for errors they didn’t create

Over time, this takes a toll:

• High performers disengage
• Turnover increases
• Institutional knowledge walks out the door.

What’s often dismissed as “just part of the job” becomes a structural drag on morale, retention, and continuity.

When OTB Becomes a Constraint Instead of a Control

OTB exists to enable decision-making—to clarify what’s possible and guide smart trade‑offs.

But in a manual environment, OTB often becomes the opposite:

• Something teams work around
• Something referenced after decisions are made
• Something that slows momentum instead of supporting it

When planners avoid updating OTB because it’s too painful, or buyers stop trusting it because it’s always behind, the control mechanism is effectively gone.

At that point, the business isn’t managing inventory spend—it’s reacting to it.

The root cause isn’t a lack of discipline or expertise. It’s that manual OTB lives outside the systems where decisions are actually made.

When Open-to-Buy exists as a standalone spreadsheet—disconnected from demand signals, receipts, and financial plans—it can only ever react. It can’t guide, alert, or reduce the operational load on the teams responsible for it.

That’s not a behavior issue. It’s a system integration issue.

The Question Isn’t Cost — It’s Capability

Most retailers ask: “What would it cost to move away from Excel?”

A more useful question is:

What is it costing us to stay where we are?

• How many opportunities were missed because the visibility for spending came too late?
• How much talent is tied up maintaining spreadsheets instead of improving performance?
• How much risk is absorbed quietly, season after season?

These costs don’t appear as a single failure. They compound—week after week, season after season.

So, Where Does Your OTB Actually Stand Today?

By this point, most teams recognize the patterns described above.
Manual OTB rarely fails in obvious ways — it quietly becomes harder to keep current, harder to trust, and harder to use as the business accelerates.

What’s less obvious is how exposed your current process actually is.

Two retailers can both be running OTB in Excel — and face very different levels of risk.
The difference isn’t discipline or experience.
It’s how well the operating model fits the speed, scale, and volatility of in‑season execution.

To help teams pressure‑test that reality, we created a short OTB Exposure Check.

It looks at:

• How frequently are plans updated in season
• How much manual effort is required to keep numbers aligned
• How current OTB visibility is when decisions are made
• How much planner time is consumed maintaining tools vs making trade‑offs

It takes less than five minutes and doesn’t require sensitive financial data.

 Check Your OTB Exposure  

Looking Ahead

Manual OTB processes made sense when systems were isolated and planning lived outside of execution. That’s no longer the reality.

 Today, the biggest limitation isn’t access to data—it’s the lack of integration between merchandising, planning, and financial systems. When Open-to-Buy is embedded directly into the MFP, fueled by real-time actuals and aligned forecasts, it stops being a reporting exercise and starts functioning as a decision engine.

This isn’t about eliminating Excel. It’s about removing repetitive, manual work that burns out teams and delays action—so planners can spend their time analyzing trade‑offs, not reconciling versions.

In the next post, we’ll shift from problem to possibility—what Open-to-Buy looks like when it’s system‑integrated, embedded in the MFP, and designed for in‑season execution.

Because when OTB works the way it should, it doesn’t just control spend.
It expands what the business believes is possible.

 And that’s where platforms like daVinci Merchandise Systems begin to matter—not as a replacement for people, but as an operating model that finally works at the speed of retail.