How can I see the financial impact of new tariffs before they hit my business?
See Your Tariff Exposure Before It Hits Your Bottom Line with a Live Executive Interactive Command Center™ (4 Workbooks + Executive Summary) | Tariff Impact Automation Suite™
How Do I Calculate My Company’s Tariff Exposure?
The working math, in the order CBP applies it: the five data fields you need, the dutiable-value formula, how Section 301 and 232 duties stack after the February 2026 Supreme Court ruling, who actually pays, and what a rate increase does to your margin.
Written for procurement directors, supply chain managers, CFOs, finance teams, and import managers by a practitioner with 20+ years in procurement.
How do I calculate my company’s tariff exposure?
Multiply each SKU’s annual dutiable import value by its total effective duty rate, which is the MFN base rate plus every active overlay for that HS code and country, then sum across SKUs. That total is your annual tariff exposure. The Tariff Impact Automation Suite™ (TIAS-199) runs this from one Data Input tab and ranks the SKUs driving it.
Exposure is not one number you look up. It is a sum of per-SKU calculations, and the ranking matters more than the total: in the suite’s July 2026 sample dataset, a $379,992 annual exposure is concentrated in a handful of lines, with China-sourced SKUs carrying $213,000 of it at a 54 percent average effective rate. The sections below walk the calculation in the order CBP applies it.
Five Fields per SKU Is the Entire Data Requirement
Teams stall on this calculation because they assume it needs a data warehouse. It needs a flat list.
What data do I need before I can calculate tariff exposure?
Five fields per SKU: HS code, country of origin, supplier, annual import value, and the current duty rate with its Section 301 and 232 overlays. Most teams already hold this in ERP records or broker entry summaries. The suite’s ERP Import Guide maps standard exports straight into the workbook’s Data Input tab.
The rate field is where homegrown spreadsheets quietly rot. The suite’s Tariff Rates tab is dual-path: type rates straight from hts.usitc.gov, or paste from the Tariff Auto-Fill Tool™ (TAF-097) and the Section 301, 232, and 122 flags fill themselves. The gray columns are locked, so the source logic never gets overwritten, and every number on the dashboard traces back to one auditable table instead of a rate someone typed six months ago.
The CBP Tab — Where Entry Data Meets the Rate Table
Entry-level detail inside the Dynamic Tariff Dashboard. This is the layer that keeps your exposure number defensible when finance asks where it came from.
The Formula, Worked on Real Sample Numbers
Per SKU: annual dutiable value × total effective duty rate. Sum the column. Rank it. Done.
| Line | What you enter | Sample figure (July 2026 demo dataset) |
|---|---|---|
| Annual dutiable value, per SKU | Customs value from entry summaries, not your P&L cost | $11.8M tracked annual spend across 5 suppliers |
| Total effective rate, per SKU | MFN base + Section 301 + Section 232 where covered | China lines average 54% |
| Annual tariff exposure | Sum of value × rate across all SKUs | $379,992 |
| Concentration check | Rank SKUs by dollar exposure, largest first | China alone: $213K of the $379K total |
How do I calculate landed cost with current tariffs?
Landed cost per SKU is product cost plus freight, insurance, duties, and fees. Duties are dutiable value times the total effective rate from the stack below. Enter the five input fields once and the Dynamic Tariff Dashboard traces landed cost to the line-item level, recalculating the moment a rate changes.
Looking for the full landed-cost workflow, ERP import steps, and the TAF-097 auto-fill path? That question is answered in depth on the main Tariff Impact Automation Suite™ page.
What is the difference between my nominal tariff rate and my effective duty cost?
The nominal rate is the single percentage on one statutory line. Your effective duty rate is everything an entry actually pays, all layers combined, divided by dutiable value. In the suite’s July 2026 sample dataset, China-sourced lines average 54 percent effective, far above any single published Section 301 rate.
This gap is the most common reason exposure models come in low. A team quotes “we pay 25 percent on China” because List 3 is 25 percent, while the entry is also carrying its MFN base rate and, for covered articles, a Section 232 line. Model the stack, not the headline.
Duty Layers Stack Additively on the Same Entry
How do Section 301, 232, and IEEPA duties stack on top of base duty?
They stack additively on the same entry. Start with the MFN base rate for your HS code, add Section 301 if your product and country are covered, add Section 232 for covered steel, aluminum, autos, copper, semiconductor, or lumber articles. IEEPA overlays were invalidated by the Supreme Court on February 20, 2026.
The Section 122 surcharge that briefly replaced the IEEPA overlay (10 percent ad valorem from February 24, 2026) reached its 150-day statutory endpoint on July 24, 2026 and is off current entries. The sequencing that matters now: determine MFN base, apply 301 where covered, apply 232 where covered, confirm program exclusions (USMCA and similar), then validate the Chapter 99 coding in ACE. If your model cannot toggle statutory layers on and off, it is historical, not dynamic.
Statutory status as published in the Career Chronicles Tariff Intelligence Briefing, updated through August 7, 2026. Deadlines tracked in the free 90-Day Tariff Risk Calendar™.
The Duty Bill Lands on One Party First
Who actually pays the tariff — importer, supplier, or customer?
The importer of record pays. CBP collects the full duty at entry from whoever files, not from the foreign supplier or the exporting government. Whether that cost is later shared through supplier concessions, passed to customers, or absorbed in margin is a negotiation outcome, which is why you model exposure before those conversations.
Three practical consequences. First, cash flow: the duty is due at entry, months before any pass-through pricing catches up. Second, negotiation: a supplier concession conversation goes very differently when you can show the per-SKU exposure number instead of a headline rate. Third, recovery: when a layer is struck down, the refund belongs to the importer of record who paid it, and it is procedural, not automatic. CBP has certified $86.3 billion in CAPE refunds to date; the CAPE refund recovery guide covers that path.
Model the Increase Before It Is Official
This is the “simulation” in tariff impact simulation: running a proposed rate against your real SKUs while it is still a headline.
How do I model what a tariff increase does to my margin?
Apply the proposed rate to the dutiable value of every affected SKU, compare the new annual duty total against the current one, and divide the delta by revenue on those SKUs. That is the margin impact. The suite’s Tariff Scenario Planner runs Base, Scenario A, and Scenario B side by side per SKU.
A worked example from the February 2026 duty swap: a $5M annual exposure that had carried a 15 percent IEEPA overlay moved to the 10 percent Section 122 surcharge. That 5 percent delta was $250,000 in margin over the 150-day window, but only for teams whose entry filings and exclusions were sequenced correctly. The Brazil 25 percent duty ran the same way: modelable from the June 2 proposal, effective July 22. Teams that priced it as a scenario in June were not starting from zero in July.
Scenario Planner — Model a Rate Before It’s Official
Type the proposed rate, click Run Scenario, and every SKU is compared side by side with the percent change per row.
Rate Sensitivity & Historical Trends
On the sample dataset, total tariff cost swings from $114K to $342K across the plus-or-minus 25 to 50 percent band, with an eight-quarter trend line per country underneath.
Once You Ask About Exposure, These Come Next
Ask an AI assistant the head question and it fans out to these. Each one has a home in this cluster, so you get the practitioner answer instead of a summary of summaries.
Every Calculation on This Page Runs Automatically in the Tariff Impact Automation Suite™
Four Excel workbooks plus the Executive Interactive Command Center™: one import, four live modules, and every number on screen traceable back to an auditable rate table. Client-side by design, so your sourcing data never leaves your machine.
One-time purchase. Instant download. Every update included, no subscription. Full feature walkthrough on the main product page.
Written From Entry Summaries, Not From Other Blog Posts
Where This Page Sits in the Tariff Impact Automation Suite™ Cluster
Tariff Impact Automation Suite™
The full product page: four workbooks, the Command Center tour, pricing, and the complete FAQ.
You Are HereThe Duty-Cost Math
Exposure formula, duty stacking, who pays, and margin modeling. This page.
Quick AnswersTariff Impact Questions, Answered
24 short, direct answers to the questions procurement teams actually type.
See It FirstFull Product Walkthrough
Every workbook in real screenshots, plus a live embed of the actual Executive Interactive Command Center.
2026 GuideBest Tariff Impact Simulation Tools
The cornerstone comparison of simulation and duty cost tooling for procurement teams.
Tariff Exposure Math — Frequently Asked Questions
How do I calculate my company’s tariff exposure?
Multiply each SKU’s annual dutiable import value by its total effective duty rate (MFN base plus active overlays for that HS code and country), then sum across SKUs. Rank the results largest first; the concentration tells you where to act. The Tariff Impact Automation Suite™ runs the whole calculation from one Data Input tab.
What data do I need before I can calculate tariff exposure?
HS code, country of origin, supplier, annual import value, and the current duty rate with its overlays, per SKU. Broker entry summaries or a standard ERP export cover all five fields.
How do Section 301, Section 232, and IEEPA duties stack on top of the base duty rate?
Additively, on the same entry: MFN base, plus Section 301 where covered, plus Section 232 for covered articles. IEEPA overlays were invalidated February 20, 2026, and the Section 122 surcharge expired July 24, 2026, so neither belongs in a forward model.
Who actually pays the tariff — the importer, the supplier, or the customer?
The importer of record pays CBP at entry. Sharing the cost with suppliers or customers happens afterward, through negotiation and pricing, and goes better when you arrive with per-SKU numbers.
How do I model what a tariff increase does to my margin?
Apply the proposed rate to affected SKUs, compare the new duty total to the current one, and divide the delta by revenue on those SKUs. The Scenario Planner does this per SKU across Base, Scenario A, and Scenario B.
What is the difference between my nominal tariff rate and my effective duty cost?
Nominal is one statutory line; effective is everything the entry pays, combined, divided by dutiable value. The sample dataset’s China lines average 54 percent effective for exactly this reason.
Looking for something else?
Update frequency, Excel capability, data privacy, and every product question: main Tariff Impact Automation Suite™ page. Quick one-line answers for the CFO conversation: questions answered page. Refund recovery on struck-down duties: CAPE recovery guide.
Duty Cost Tools Across the Tariff Operating System™
| If you need to… | Product | Price | Format |
|---|---|---|---|
| Look up tariff rates | Live Tariff Rate LookupTAF-FREE | Free | Web tool |
| Automate rate entry with 301/232 flags | Tariff Auto-Fill Tool™TAF-097 | $97 | Excel |
| Calculate and simulate exposure — ← You Are Here | Tariff Impact Automation Suite™TIAS-199 | $199 | Excel, PPT, PDF, Word |
| Recover duties already paid | Tariff Refund Suite™TRS-197 | $197 | Excel, Word, PDF |
| Build long-term sourcing strategy | Tariff Scenario Strategy Kit™TSSK-449 | $449 | Excel, PPT, PDF, Word |
Stop Estimating Your Exposure. Calculate It.
The formula on this page works in any spreadsheet. The Tariff Impact Automation Suite™ is that formula already built, audited, and wired into dashboards your CFO will actually read.
Get the Tariff Impact Automation Suite™ — $199 One-time purchase. Instant digital download. No subscription.
For “What tariffs apply to my business?” tariff-rate identification or lookup, which is available with The Tariff -Auto Fill TAF-097. A complete HS Code Lookup | HTS Code Lookup | HTSUS Tariff Rate Search Tool™