Tariff Scenario Modeling with AI: A Practical Guide for Supply Chain Teams

Supply Chain AI Tools Geopolitical Risk

By Asmaa Gad | 11 min read

New tariffs announced on a Tuesday morning. Your CFO wants the cost impact by Friday. Your sourcing team is scrambling through spreadsheets, trying to figure out which suppliers are affected, what the landed cost changes are, and whether there is a viable alternative source. Sound familiar?

In 2025 and 2026, tariff volatility has become the norm, not the exception. US-China tensions, EU carbon border adjustments, retaliatory duties, nearshoring incentives. The supply chain teams that thrive are the ones who can model scenarios fast enough to make decisions before the next announcement.

AI does not predict tariff policy. But it can dramatically compress the time between “new tariff announced” and “here are our three options with cost implications.” Here is how.

The Tariff Landscape in 2026: Why Scenario Modeling Is No Longer Optional

Trade Development Impact on Procurement Urgency
US-China tariff escalation 10-25% additional duties on electronics, machinery, chemicals, and rare earth materials from Chinese suppliers Active
EU CBAM (Carbon Border Adjustment) Carbon cost added to imports of steel, aluminium, fertilisers, electricity, hydrogen, and cement from non-EU countries 2026 Impact
Nearshoring incentives (USMCA, EU trade deals) Preferential rates for regional sourcing; rules of origin becoming more complex and more valuable Opportunity
Retaliatory and sector-specific tariffs Unpredictable duties on specific product categories that change quarterly or monthly Volatile

The problem is not awareness. Every procurement leader knows tariffs are a risk. The problem is speed. By the time most teams finish their manual impact analysis, the situation has changed again or a competitor has already locked in an alternative supplier.

A 4-Step AI Framework for Tariff Scenario Modeling

1

Map Your Exposure

Upload your supplier master data and spend data into ChatGPT Advanced Data Analysis or Claude. Include: supplier name, country of origin, HS codes (if available), annual spend, and current landed cost. Ask the AI to classify each supplier by tariff exposure based on country of origin and product category.

Prompt: “Analyse the attached supplier spend data. For each supplier, classify tariff risk as High, Medium, or Low based on the country of origin and the current US/EU tariff environment for these product categories. Output a table sorted by annual spend, with columns: Supplier, Country, Product Category, Annual Spend, Tariff Risk Level, Estimated Additional Duty %.”

2

Build Three Scenarios

Ask the AI to model three scenarios against your exposed spend: (A) Status quo with current tariff rates maintained, (B) Escalation scenario with tariffs increasing by 10-15% on high-risk categories, (C) De-escalation or trade deal scenario where preferential rates apply. For each scenario, calculate the total cost impact across your supplier base.

Prompt: “Using the tariff exposure analysis above, model three scenarios for our annual spend: Scenario A (current rates held), Scenario B (escalation: +15% on High-risk, +5% on Medium-risk categories), Scenario C (trade deal: -10% on High-risk, preferential rates on regional suppliers). For each scenario, show: total additional cost, top 5 most affected categories, and the difference between scenarios. Present as a comparison table.”

3

Identify Alternative Sources

For your top 10 most tariff-exposed categories, use Perplexity AI to research alternative sourcing countries and suppliers. Ask it to identify manufacturers in lower-tariff regions (Vietnam, India, Mexico, Turkey, Poland) for your specific product categories, with estimated lead time and quality considerations.

Prompt (Perplexity): “For

, identify manufacturers in Vietnam, India, Mexico, and Turkey that can supply [specifications]. For each country, note: typical lead time, quality certifications available, estimated unit cost range, and any existing free trade agreements with the EU/US that would provide preferential tariff rates.”

4

Build the Decision Brief

Take the scenario analysis and alternative sourcing research and ask Claude to synthesise it into a one-page executive brief. Include the cost exposure under each scenario, the top 5 recommended actions ranked by impact and feasibility, and the timeline for implementing each action.

Prompt (Claude): “Synthesise the following tariff scenario analysis and alternative sourcing research into a one-page executive brief for our CPO. Structure: (1) Exposure Summary in 2 sentences, (2) Scenario Comparison Table, (3) Top 5 Recommended Actions ranked by cost impact and implementation speed, (4) Risk of inaction. Keep it under 500 words. Tone: direct, data-driven, suitable for C-level.”

Worked Example: Electronics Category Tariff Impact

Here is how this plays out in practice. Say you are a European retailer with EUR 12M in annual electronics component spend, with 60% sourced from Chinese manufacturers.

Scenario Impact Summary

SCENARIO A: Status Quo

EUR 840K

Current tariff costs

SCENARIO B: Escalation

EUR 1.92M

+EUR 1.08M additional exposure

SCENARIO C: Diversified

EUR 540K

-EUR 300K vs status quo

Key insight: Shifting just 30% of the Chinese-sourced spend to Vietnamese and Indian manufacturers (identified through Perplexity research) reduces the escalation scenario impact by EUR 650K while adding only 5-7 days to lead time. The diversification also reduces single-country dependency from 60% to 42%.

Nearshoring vs Friendshoring: How AI Helps You Decide

Nearshoring

What it means: Moving supply to geographically closer countries (e.g., EU sourcing from Turkey, Poland, Morocco; US sourcing from Mexico, Costa Rica).

Best for: Reducing lead times, cutting transport emissions, simplifying logistics, and leveraging regional trade agreements.

AI helps by: Modelling total landed cost (price + transport + tariff + lead time cost) for near-shore alternatives vs current sources.

Friendshoring

What it means: Sourcing from geopolitically aligned nations regardless of geography (e.g., US sourcing from India, Japan, South Korea instead of China).

Best for: Reducing political risk, securing preferential trade treatment, building supply chain resilience against sanctions or export controls.

AI helps by: Mapping your supplier base against geopolitical risk indices and identifying suppliers in aligned nations with comparable capabilities.

The Tools You Need (And Most Are Free)

For data analysis: ChatGPT Advanced Data Analysis. Upload your spend file, let it calculate exposure and model scenarios. The code interpreter handles the maths automatically.

For market research: Perplexity AI Pro. Real-time sourced data on alternative suppliers, trade agreements, and tariff rates. Every claim links to a source you can verify.

For executive synthesis: Claude. Feed it all your analysis and alternative sourcing data. Its long context window handles the full dataset, and its reasoning produces nuanced executive briefs.

For monitoring: Set up Google Alerts or an n8n workflow to monitor tariff news for your key categories. Pair with an AI node that summarises the impact whenever a relevant policy change is detected.

Speed Is the Competitive Advantage

In a world of quarterly tariff changes, the team that models scenarios in 48 hours beats the team that takes 3 weeks. AI does not predict trade policy. But it compresses the analysis cycle from weeks to days, giving you time to act before the next disruption hits. The tools are available. The data is in your ERP. The only question is whether you start modeling before or after the next tariff announcement.

Want More Supply Chain Risk Tools?

Our 100 AI Use Cases in Supply Chain book includes dedicated chapters on risk management, geopolitical analysis, and supplier diversification strategies with ready-to-use prompts for each.

Asmaa Gad is the founder of SupplyChain AI Pro, helping procurement and supply chain professionals master AI tools for real work.

Follow on LinkedIn | Subscribe on YouTube

Related Articles

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Cart
Scroll to Top