The Duty-to-Dollars Gap
The minute a new duty rate lands you know the questions that matter are not what your supply chain risk dashboard answers.
It's eight in the morning at a Tier-1 electronics OEM. Overnight a ten point surcharge stacked on top of the 25 percent Section 301 duties already on your Chinese components and the combined rate now reads 35 percent. Your risk platform says high risk alert and your compliance database confirms the HTS codes carry the new number.
Your planning system still shows a third-quarter forecast built on last month's bill of materials. Three platforms all agree something expensive just happened.
Not one of them tells you what it is going to cost your company.
Here is what it costs. You move roughly$120 million a year of Chinese sourced components across the affected part numbers. That ten point surcharge is $12 million dollars in new duty a year, $3 million of it this quarter and unless you reprice, or resource, every dollar lands on operating profit and $3 million dollars are gone.
By nine the board wants the exact dollar hit to margin by Q3 if pricing holds where it is. They also want to know how many open positions freeze to cover it.
Mark Zetter
These two numbers are what you will be measured on and if the figure you give is wrong, it is your forecast that missed, in front of the people who approve your budget.
Your platform reported the event. Producing the answer is still yours.
Things could unfold differently. You open one screen and the new duty is already rolled through every affected BOM line item, priced against your real volumes, and turned into a dollar figure and a headcount number you can defend.
You walk into your nine o'clock with the answer.
Somewhere a competitor is doing exactly that...repricing and reallocating this afternoon, while you are still assembling the number by hand.
The distance between who can answer today and who answers next week is equal to capturing opportunity.
Your visibility layer, the Everstream-class of platform, was built to tell you the warehouse is on fire and it does that well with live alerts and event tracking that reach you before the news does. The cost of that fire in dollars was never something it was built to calculate.
Your compliance layer, Descartes CustomsInfo and databases like it, gives you clean duty rates and HTS lookups so shipments clear customs without a hold, and it is very good at doing that. Ask it which alternate supplier in Vietnam or Mexico protects your dollars once everything is counted, and it has nothing to say.
Your planning layer, Anaplan or Kinaxis, hands you a powerful and flexible model, an empty framework you can build almost anything inside. The morning calls for a framework that already understands how an electronics tariff moves through a multi-tier bill of materials into a dollar figure, and empty is the condition it starts in.
Each of these tools is excellent at the job it was designed for. The job in front of you this morning was designed into none of them.
Call this missing piece the duty-to-dollars gap, the distance between knowing the rate and knowing what it does to your bottom line.
Mark Zetter
Everyone in the building can see the rate within minutes. Turning it into a number you can act on is the part no system platform does for you.
Consider moving one production line from Suzhou into Guadalajara. The duty difference is easy math, and it is the only part your systems hand you cleanly. The real number reaches much further. A new duty rarely strikes the finished good. It strikes a sub component three levels down in the bill of materials, and that cost has to be rolled back up through every assembly that carries it. The volume rebate tiers you negotiated last year reset the moment you split your buying across two regions to de risk it. Re-qualification and production part approval process (PPAP) on the new source push the real saving two quarters out, so the relief the board wants this quarter arrives on a later one.
Your compliance system knows the rate. Your planning system knows the volume. Nothing between them multiplies the two into a dollar answer on its own, so the number gets walked from one screen to the next by hand, usually by you or by the analyst two doors down.
Which is where your answer actually gets made. After the seven and eight figure sums your company spent on the brand name platforms, the real model of your tariff exposure lives in a spreadsheet.
People call it the master tariff file. It is the one place where duty rates, labor cost, and the real bill of materials sit in the same grid and produce a number your finance team will act on. One senior analyst keeps it running and that person knows which tab feeds which, which cell is a hard code vs which is formula, and why the third quarter forecast reads the way it does.
Sit with what this means for your company, for your career.
The number you carry into the board meeting, the one your credibility rides on, is produced by a single non-versioned Excel file maintained by one person, from memory. You are blind if they are on vacation the morning a rate changes. In most instances there is no backup owner, no second set of eyes, and no audit trail behind the figure you are about to commit to.
A seven figure decision, riding on one file and one person's memory.
Why does a spreadsheet survive in a supply chain that has spent so heavily to retire it? Because tier-1 platforms that promise to replace it take 12 to 18 months to implement and a tariff arrives in a single morning.
Set those two clocks next to each other and a fast, fragile file that answers the board today is the rational thing for a capable team to keep alive. It is what people build when the engine they need does not yet exist.
So notice the real asymmetry the next time a tariff alert triggers. The duty rate reaches every corner of your company within a few minutes. The dollar figure it creates, the one number anyone actually needs, still takes days, one analyst, and one spreadsheet to produce.
Until that gap closes the rate will always travel faster than your answer, and the board will be waiting on the wrong side of it.
______________________________________________________
About
What matters when formulating contract electronic strategy? How do you identify supplier profit centers and what are you doing to protect against margin erosion for your outsourcing programs? Why do provider capabilities often not match capabilities they claim? How are you benchmarking your supply chain against competitors?
I’ve spent 25+ years in contract electronics industry setting up contract electronic divisions and running operations, protecting EMS program profits, manufacturing capacity M&A and more. I run a technology solutions firm. A lot of times this means asking the right questions.
______________________________________________________