AUTO XYZ – Section 301 Tariff Impact Analyzer

Pass-through: 50%
Total Tariff Paid YTD
$42.5M
↓ 2.3% from last period
Avg Effective Tariff Rate
8.4%
↑ 0.7% from baseline
Avg Vehicle BOM Cost
$18,450
↑ 4.1% from baseline
Gross Margin %
16.8%
↓ 1.2% from baseline

Tariff Cost by HS Chapter and Supplier Country

BOM Cost Composition by Category

Monthly Tariff Cost vs. Gross Margin %

Top Parts by Tariff Burden

Vehicle Profitability Waterfall - Sedan A Premium

Vehicle Profitability by Trim and Region

Tariff Cost Heatmap by Supplier Country

Interactive map would appear here

Click on countries to filter data

Lead Time vs Tariff Rate

Parts Filter

Margin % Distribution by Vehicle and Region

Price Elasticity Impact

Monthly P&L Summary

50%
0%

Custom Tariff Schedule

Δτ Country Add-ons

Scenario Comparison

About & Methodology

Dashboard Purpose

The AUTO XYZ Section 301 Tariff Impact Analyzer is designed to help internal analysts explore and quantify the effects of Section 301 tariffs on our vehicle lineup, parts sourcing, and profitability across various scenarios. All data is synthetic and for demonstration purposes only.

Key Policy Context

  • Section 301 Tariffs: Affect imports by HS code, product category, and country of origin, with recent policy updates including treatment of USMCA content where tariffs apply only to non-U.S. content in qualifying Canada/Mexico vehicles and parts.
  • Duty-free Components: Exempt until a content-specific mechanism is implemented (as per caredge.com).
  • Balanced Trade Targets: Analysts may test alternative tariff schedules per USTR models to simulate macro policy variants (tariffs.inasimonovska.com).

Methodology Highlights

  • USMCA Non-U.S. Content Rule: In the 2025 Update scenario, for vehicles/parts qualifying under USMCA from CA/MX, tariffs are applied only to non-U.S. content share.
  • Balanced Trade Target: Implements a stylized function that calculates incremental tariff add-ons based on bilateral trade deficits to move toward balanced trade.
  • Elasticity and Demand Model: Segment-specific price elasticities (Sedan -1.2, SUV -1.0, Truck -0.8, EV -1.4) affect unit sales based on price pass-through.
  • Risk Scoring: Composite risk based on supplier concentration, China exposure, lead times, and parts criticality.

Technical Implementation

All data is generated client-side using synthetic parameters. The dashboard runs entirely in the browser without external data dependencies. Calculations are reproducible with a deterministic seed.

Data Privacy Notice

This dashboard is a demonstration using synthetic data. Sources referenced for policy context only: caredge.com, tariffs.inasimonovska.com.

Validate Calculations

Part Validation Example

Part: Battery Pack (HS Code: 8507) - Supplier: China

Scenario: 2025 Update (USMCA)

Calculation Steps:

  1. Base unit cost: $3,200
  2. Logistics cost: $128 (4% of unit cost)
  3. HS Code 8507 baseline tariff: 25%
  4. USMCA-eligible part from China: Apply full tariff to non-US content (100%)
  5. Assessed value: $3,200
  6. Tariff amount: $3,200 × 25% = $800
  7. Landed cost: $3,200 + $128 + $800 = $4,128

Verification: Charted tariff burden matches calculated value of $800 for this part across vehicles.

Vehicle Validation Example

Vehicle: SUV B Premium

Scenario: Balanced Trade Target

Calculation Steps:

  1. Base BOM cost: $18,450
  2. Total tariff cost: $1,554 (8.4% effective rate)
  3. Discount: 5% of MSRP ($32,000 → $30,400)
  4. Dealer margin: 12% of $30,400 = $3,648
  5. Variable costs: 7% of MSRP = $2,240
  6. Gross profit: $30,400 - $3,648 - $1,554 - $18,450 - $2,240 = $4,508
  7. Gross margin: $4,508 / $30,400 = 14.8%

Verification: Dashboard gross margin of 14.8% matches our calculated value.

Made with DeepSite LogoDeepSite - 🧬 Remix