CPO Case Story · Supply Chain Risk

Tariff Shock Survival: Modeling 200 Supplier Scenarios in 48 Hours

When new tariffs hit overnight, a Tier-1 automotive supplier had two days to brief the board. We turned three months of fragmented sourcing data into a live scenario engine—and a €23M mitigation plan.

48h

From data chaos to board-ready scenarios

€23M

Mitigated exposure year one

200+

Suppliers modeled, country by country

Tariff Scenario Engine

SCENARIO MODE

Adjust tariff rates by country

Drag sliders →

Annual Exposure

€38.4M

across 142 suppliers

Margin Impact

−3.8 pp

on EBIT line

Critical Suppliers

need action

China

25%

Mexico

10%

Germany

Vietnam

15%

India

Top suppliers by tariff exposure

Sorted by impact →

€11.2M

Top 10 exposure

Critical risk

68%

Single-source

Shenzhen Precision CastingsEngine brackets · Single-source

€2.4M

Guangzhou Wire Harness LtdCable assemblies · Dual-source

€1.9M

Monterrey Stamping Co.Body panels · Single-source

€1.6M

Hanoi Electronics Mfg.PCB assemblies · Single-source

€1.4M

Suzhou Plastics GroupInterior trim · Dual-source

€1.1M

Pune Forging IndustriesTransmission parts · Multi-source

€0.7M

Mitigation path · top 3 actions

Swap recommendations →

Recommended strategy

Re-source 18% of CN spend to VN/MX over 9 months

Current

Shenzhen Precision

Tariff load: €2.4M/yr Lead: 8 wks

Alternative −€1.7M

Hai Phong Castings

Qualified · ISO 9001 Lead: 10 wks

Current

Guangzhou Wire

Tariff load: €1.9M/yr Lead: 6 wks

Alternative −€1.3M

Tijuana Harness Co.

Existing partner · USMCA Lead: 4 wks

Current

Hanoi Electronics

Tariff load: €1.4M/yr Lead: 12 wks

Alternative −€0.9M

Bangalore PCB Ltd

Qualification: 14 wks Lead: 10 wks

📋 Strategic Blueprint Based on Real-World Scenarios

This case story illustrates a recurring challenge for manufacturers exposed to shifting trade policy. The architecture and quantified outcomes reflect our proven approach to procurement risk modeling. Worried your sourcing data can’t answer “what if” fast enough? Let’s build your Tariff Response Cockpit →

The Challenge

The Question No Sourcing Team Could Answer Overnight

A Tier-1 automotive supplier with €620M annual spend across 200+ suppliers watched the news on a Sunday evening: a new 25% tariff on a major sourcing country would take effect within 90 days. Monday morning, the CFO and CPO sat in the same meeting with one question: “What does this actually cost us, and where do we move first?”

The honest answer was: nobody knew. Sourcing data lived in three ERPs (one regional SAP, one Oracle, one legacy AS/400), supplier country-of-origin was a free-text field, single-source vs. multi-source status was tracked in a separate Excel maintained by one person, and contracts were scanned PDFs in SharePoint.

The board wanted answers in 48 hours. The team estimated it would take three weeks of manual work just to consolidate the baseline.

The Breaking Point

Tuesday afternoon, the procurement team presented a first estimate using the legacy Excel templates: “Exposure between €15M and €60M, plus or minus.” A range so wide it was useless for decision-making.

The CEO’s response was direct: “I cannot brief the board on a range that wide. I need a defensible number by Thursday morning. And I need to know which suppliers to call first.” The team had 36 hours.

Project Approach

From Three ERPs to One Scenario Engine in 48 Hours

The breakthrough was treating this as a data engineering problem, not a procurement project. Our team had previously built unified spend models for the client’s BI platform. The same pipelines, with two new dimensions—country of origin and tariff schedule—could deliver scenario modeling within hours, not weeks.

1. Rapid Data Consolidation

Pulled supplier master data from all three ERPs into Azure Data Lake using existing pipelines. Enriched with country of origin from customs declarations and contract metadata extracted from PDFs via Azure AI Document Intelligence. Single supplier record in 14 hours.

2. Tariff Schedule Model

Built a parameterized HS-code-to-tariff mapping in Synapse, covering the affected country plus six alternative sourcing regions. Every PO line could now be re-priced under any tariff scenario in seconds.

3. Scenario Engine in Power BI

Delivered an interactive Power BI cockpit: sliders for tariff rates by country, automatic recalculation of total exposure, supplier-level drill-down, and presets for “moderate”, “severe”, and “trade war” scenarios. Ready for the Thursday board call.

4. Mitigation Recommendation Layer

Cross-referenced exposed suppliers with an internal database of qualified alternatives. The system suggested concrete re-sourcing paths—each annotated with lead time, certification status, and expected savings—turning analysis into an executable action plan.

The Technology Stack

Speed mattered more than novelty. Every component was already proven in the client’s environment—we composed the response from existing building blocks rather than introducing new tooling under time pressure.

Data Consolidation

Azure Data Factory pipelines from SAP, Oracle, and AS/400 into Azure Data Lake

Contract Extraction

Azure AI Document Intelligence for HS codes, country of origin, and contract terms

Scenario Modeling

Azure Synapse parameterized tariff calculations, multi-scenario re-pricing

Interactive Cockpit

Power BI with what-if parameters, drill-through, and mitigation recommendation layer

Project Outcomes

Board-Ready Answers in 48 Hours, Action Plan in 7 Days

Exposure modeled in 48 hours, not 3 weeks

€23M annual exposure mitigated

Defensible numbers, not ranges

Permanent scenario engine, ready next time

“In a tariff shock, the company with the best data wins. Not the biggest, not the cheapest—the one that can answer ‘what if’ in hours instead of weeks. We don’t build crystal balls. We build the plumbing so when the next shock comes, you already know which call to make first.”

Justyna

PMO Manager, Multishoring

Summary

A Defensive Scramble Became a Strategic Capability

The 48-hour sprint produced more than a board presentation. The Tariff Scenario Engine is now a permanent part of the client’s procurement operating model. Every new sourcing decision is run through it. Every quarter, the model is refreshed with the latest tariff schedules from six jurisdictions.

When the next policy shift hit eight months later, the same team answered the same question in under four hours—and walked into the board meeting with three pre-modeled mitigation paths. The crisis became a competitive moat.

contact

Thank you for your interest in Multishoring.

We’d like to ask you a few questions to better understand your IT needs.

Justyna PMO Manager

Signed, sealed, delivered!

Await our messenger pigeon with possible dates for the meet-up.