-
1.52 kB
initial commit
-
237 Bytes
Project goal Build a responsive, interactive web dashboard titled “AUTO XYZ – Section 301 Tariff Impact Analyzer” that helps internal analysts explore and quantify the effects of 301 tariffs on AUTO XYZ’s vehicle lineup, parts sourcing, and profitability across scenarios. Use only synthetic data generated client‑side. No external APIs. Context (embed as static text in an About panel) • Section 301 tariffs affect imports by HS code, product category, and country of origin. Recent policy updates include treatment of USMCA content where tariffs apply only to non‑U.S. content in qualifying Canada/Mexico vehicles and parts, with duty‑free components exempt until a content‑specific mechanism is implemented caredge.com. • Analysts may test alternative tariff schedules or “balanced bilateral trade” targets per USTR models to simulate macro policy variants tariffs.inasimonovska.com. Architecture • Single‑page app with a left sidebar for global filters, a top navbar, main content area with tabbed views: Overview, Models & Pricing, Supply Chain & Parts, Profitability, Scenario Lab, and About/Methodology. • Tech stack: HTML/CSS/JS, a modern charting library (e.g., Plotly or ECharts), a lightweight grid (e.g., Tabulator or ag‑Grid Community), and a client‑side state store (simple Redux‑like object). Export to CSV/PNG and a “Download Report (PDF)” via client‑side print. • Performance: All data generated on load; allow 5–10k rows total without lag. Use web workers if needed for scenario recomputes. Global filters (left sidebar) Date range: FY2023–FY2026 (monthly granularity). Vehicle line: Sedan A, SUV B, Truck C, EV D. Market region: US, Canada, Mexico, EU, UK, APAC. Country of origin (for parts): China, Vietnam, Thailand, India, Germany, Mexico, Canada, US. HS chapters (checkbox list): 8409, 8708, 8507 (batteries), 8542 (semiconductors), 4011 (tires), 8703 (passenger cars). Tariff scenario selector: Baseline 2024, 2025 Update (USMCA non‑U.S. content rule), Aggressive 301+, Balanced Trade Target (USTR Δτ), Custom. Currency: USD default, allow FX toggle (USD, CAD, MXN, EUR). Use static FX rates for simplicity. Synthetic data generation (run on initialization; keep seed for reproducibility) Generate the following tables (arrays of objects). Provide a “Regenerate Data” button to reseed. A) VehiclesMaster • Columns: vehicleId, name, segment, msrpBaseUSD, originMix (map of country: %), usmcaEligible (bool), avgNonUSContentShare (0–1), marginTargetPct, launchYear. • Create 4–6 trims per line (e.g., Sedan A Base, Sedan A Premium, …). B) PartsCatalog • Columns: partId, hsCode, partName, category (e.g., Powertrain, Electronics, Battery, Chassis, Interior, Tires), supplierCountry, unitCostUSD, usmcaEligible (bool), nonUSContentShare (0–1), criticality (1–5), leadTimeDays, co2PerUnitKg. • 300–600 parts, with realistic cost ranges (e.g., semis 15–120 USD, batteries 1,500–6,000 USD, tires 60–180 USD, chassis 400–1,200 USD). C) BOM (Bill of Materials) • Columns: vehicleId, partId, qtyPerVehicle. • Each vehicle uses 120–300 parts; ensure category coverage. EV D relies more on 8507 and 8542. D) SourcingFlows (monthly) • Columns: month (YYYY‑MM), partId, supplierCountry, unitsImported, logisticsCostUSD, port (string), incoterms (FOB/CIF), defectRatePct. • Generate 36 months (2023‑01 to 2025‑12), with seasonality and disruptions. E) SalesDemand (monthly) • Columns: month, vehicleId, region, unitsSold, discountPct, dealerMarginPct. • Add trends: EV D up, Sedan A stable/slightly down, Truck C cyclical, SUV B steady growth. F) TariffSchedule Provide multiple scenario schedules: • Baseline 2024: HS 8409 10%, 8708 7.5%, 8507 25%, 8542 25%, 4011 10%, 8703 vehicle duty 2.5% (where applicable). • 2025 Update (USMCA non‑U.S. content rule applied): For vehicles/parts qualifying under USMCA from CA/MX, apply tariffs only to the non‑U.S. content share; duty‑free parts exempt while awaiting content‑specific application caredge.com. • Aggressive 301+: increase HS 8507 to 35–40%, 8542 to 35%, add 5–10 pp to 8409/8708, tires 15%, vehicle duty unchanged. • Balanced Trade Target (Δτ): implement a function that, given current bilateral deficit by country, calculates an incremental tariff add‑on up to +10 pp, capped, to move toward balanced trade as a stylized proxy of USTR Δτ logic tariffs.inasimonovska.com. • Custom: user‑editable table in the Scenario Lab. Tariff application logic Implement a pure function computeTariffCost(part, supplierCountry, hsCode, scenario, usmcaEligible, nonUSContentShare, value): • Base rate from TariffSchedule by hsCode and scenario. • If scenario == 2025 Update and (supplierCountry in {Canada, Mexico} OR final assembly in CA/MX) AND usmcaEligible == true, apply tariff only to value × nonUSContentShare. If part is duty‑free per schedule, apply 0. • For Balanced Trade Target, add country‑specific Δτ up to cap; show the computed Δτ in a tooltip legend. • Return: effectiveRate, assessedValue, tariffAmountUSD. Cost roll‑ups Part landed cost per unit = unitCostUSD + logisticsCostUSD/unitQtyBatch + tariffAmountUSD. Vehicle BOM cost per unit = sum over parts (qtyPerVehicle × partLandedCost). Gross profit per vehicle = transactionPrice − dealerMargin − discount − BOM cost − other variable costs (assume 5–8% of MSRP). Price pass‑through options: 0%, 25%, 50%, 75%, 100% of incremental tariff costs into MSRP; reflect in demand via elasticity. Elasticity and demand model • Allow a simple constant elasticity per segment: Sedan −1.2, SUV −1.0, Truck −0.8, EV −1.4. • When pass‑through > 0%, recompute unit sales by region with a demand multiplier: units’ = units × (price’/price)^elasticity. • Show sensitivity sliders in Scenario Lab. Emissions and risk • Track co2PerUnitKg from PartsCatalog; vehicle CO2 per unit = sum(qty × co2PerUnitKg). • Risk score per vehicle: weighted sum of (supplier concentration, China share in BOM cost, average lead time, criticality). Display 0–100. UI layout and visuals Top navbar • Title + scenario dropdown + pass‑through slider + “Run Scenario” and “Reset”. Overview tab • KPI tiles: Total tariff paid YTD, Avg effective tariff rate, Avg vehicle BOM cost, Gross margin %, Units sold YTD, CO2 per vehicle, Risk score. • Chart 1: Stacked bar – Total tariff cost by HS chapter and supplier country. • Chart 2: Treemap – BOM cost composition by category. • Chart 3: Line – Monthly tariff cost vs. gross margin %. • Table: Top 20 parts by tariff burden with columns: hsCode, partName, supplierCountry, tariffRate, tariffAmount, landedCost, vehicle coverage. Models & Pricing tab • Chart: Waterfall per vehicle – MSRP base → incremental tariffs → pass‑through → discounts → dealer margin → final transaction price → gross profit. • Table: Vehicle profitability by trim and region (sortable), with conditional formatting. Supply Chain & Parts tab • Map: Tariff cost heatmap by supplier country; click to filter. • Table: Parts list with filters for hsCode, category, supplierCountry, usmcaEligible, nonUSContentShare, effective tariff rate, criticality. • Chart: Lead time vs. tariff rate scatter, bubble size = spend. Profitability tab • Chart: Margin % distribution by vehicle and region across scenarios (selectable). • Chart: Price elasticity impact – units vs. price index curves by segment. • Table: Month‑by‑month P&L summary: revenue, COGS, tariff, gross profit, margin %. Scenario Lab tab • Editable tables: Custom TariffSchedule and Δτ country add‑ons. • Controls: Pass‑through slider, elasticity overrides per segment, toggle USMCA rules on/off, FX sensitivity ±10%. • Outputs: Compare Baseline vs Selected scenario across KPIs, with a small multiples chart set (tariff cost, margin %, units, revenue). • Button: “Save Scenario” to snapshot state and allow quick switching between saved scenarios. About/Methodology tab • Static panel with assumptions, tariff logic explanation, USMCA treatment and non‑U.S. content share approach caredge.com. • Note on Δτ as stylized representation inspired by USTR model tariffs.inasimonovska.com. • Data is fully synthetic and for demonstration only. AUTO XYZ is fictional. Interactivity and UX • All charts respond to global filters; brushing/selection filters other components. • Right‑click any data point to “Trace to Parts” (drills down to contributing parts and vehicles). • Tooltips show formulas for effective tariff calculations and USMCA non‑U.S. content application. • Provide a “What changed?” diff panel after running a scenario to list top drivers by HS code and country. Accessibility and responsiveness • WCAG AA contrast, keyboard navigation, ARIA labels on interactive elements. • Responsive layout for desktop and tablet; collapse sidebar on small screens. Exports • Export tables to CSV; export charts to PNG; “Download Report (PDF)” generates a printable summary with the Overview KPIs, two key charts, and scenario parameters. Testing hooks • Include a “Validate Calculations” modal that randomly samples 5 parts and one vehicle, showing step‑by‑step tariff and landed cost math with totals that reconcile to charts. • Provide a deterministic seed entry to reproduce runs. Sample synthetic parameter ranges (guidance for generator) • avgNonUSContentShare: Canada/Mexico USMCA‑eligible vehicles 0.25–0.45; others 0.55–0.85; EV batteries non‑U.S. share generally higher. • Country mixes: electronics from China/Vietnam/Thailand/India/Germany; batteries from China and domestic; chassis/8708 from Mexico/Canada; tires 4011 from Thailand/Vietnam. • MarginTargetPct: 12–20% by segment; EV initially lower. • Logistics costs: 1–6% of part cost typical; long‑haul Asia higher. • Lead times: semis 45–90 days, batteries 30–60, chassis 20–40, tires 25–45. Data privacy and legal • Data is entirely synthetic. Display a footer note: “This dashboard is a demonstration using synthetic data. Sources referenced for policy context only: caredge.com, tariffs.inasimonovska.com.” Acceptance criteria All tabs render with working charts and tables tied to filters. Tariff calculations reflect USMCA non‑U.S. content logic in the 2025 Update scenario. Scenario Lab recomputes demand, pricing, margins with pass‑through and elasticity. Export and “Validate Calculations” work. App runs offline with no external data calls. End of instructions - Initial Deployment
-
61.9 kB
Project goal Build a responsive, interactive web dashboard titled “AUTO XYZ – Section 301 Tariff Impact Analyzer” that helps internal analysts explore and quantify the effects of 301 tariffs on AUTO XYZ’s vehicle lineup, parts sourcing, and profitability across scenarios. Use only synthetic data generated client‑side. No external APIs. Context (embed as static text in an About panel) • Section 301 tariffs affect imports by HS code, product category, and country of origin. Recent policy updates include treatment of USMCA content where tariffs apply only to non‑U.S. content in qualifying Canada/Mexico vehicles and parts, with duty‑free components exempt until a content‑specific mechanism is implemented caredge.com. • Analysts may test alternative tariff schedules or “balanced bilateral trade” targets per USTR models to simulate macro policy variants tariffs.inasimonovska.com. Architecture • Single‑page app with a left sidebar for global filters, a top navbar, main content area with tabbed views: Overview, Models & Pricing, Supply Chain & Parts, Profitability, Scenario Lab, and About/Methodology. • Tech stack: HTML/CSS/JS, a modern charting library (e.g., Plotly or ECharts), a lightweight grid (e.g., Tabulator or ag‑Grid Community), and a client‑side state store (simple Redux‑like object). Export to CSV/PNG and a “Download Report (PDF)” via client‑side print. • Performance: All data generated on load; allow 5–10k rows total without lag. Use web workers if needed for scenario recomputes. Global filters (left sidebar) Date range: FY2023–FY2026 (monthly granularity). Vehicle line: Sedan A, SUV B, Truck C, EV D. Market region: US, Canada, Mexico, EU, UK, APAC. Country of origin (for parts): China, Vietnam, Thailand, India, Germany, Mexico, Canada, US. HS chapters (checkbox list): 8409, 8708, 8507 (batteries), 8542 (semiconductors), 4011 (tires), 8703 (passenger cars). Tariff scenario selector: Baseline 2024, 2025 Update (USMCA non‑U.S. content rule), Aggressive 301+, Balanced Trade Target (USTR Δτ), Custom. Currency: USD default, allow FX toggle (USD, CAD, MXN, EUR). Use static FX rates for simplicity. Synthetic data generation (run on initialization; keep seed for reproducibility) Generate the following tables (arrays of objects). Provide a “Regenerate Data” button to reseed. A) VehiclesMaster • Columns: vehicleId, name, segment, msrpBaseUSD, originMix (map of country: %), usmcaEligible (bool), avgNonUSContentShare (0–1), marginTargetPct, launchYear. • Create 4–6 trims per line (e.g., Sedan A Base, Sedan A Premium, …). B) PartsCatalog • Columns: partId, hsCode, partName, category (e.g., Powertrain, Electronics, Battery, Chassis, Interior, Tires), supplierCountry, unitCostUSD, usmcaEligible (bool), nonUSContentShare (0–1), criticality (1–5), leadTimeDays, co2PerUnitKg. • 300–600 parts, with realistic cost ranges (e.g., semis 15–120 USD, batteries 1,500–6,000 USD, tires 60–180 USD, chassis 400–1,200 USD). C) BOM (Bill of Materials) • Columns: vehicleId, partId, qtyPerVehicle. • Each vehicle uses 120–300 parts; ensure category coverage. EV D relies more on 8507 and 8542. D) SourcingFlows (monthly) • Columns: month (YYYY‑MM), partId, supplierCountry, unitsImported, logisticsCostUSD, port (string), incoterms (FOB/CIF), defectRatePct. • Generate 36 months (2023‑01 to 2025‑12), with seasonality and disruptions. E) SalesDemand (monthly) • Columns: month, vehicleId, region, unitsSold, discountPct, dealerMarginPct. • Add trends: EV D up, Sedan A stable/slightly down, Truck C cyclical, SUV B steady growth. F) TariffSchedule Provide multiple scenario schedules: • Baseline 2024: HS 8409 10%, 8708 7.5%, 8507 25%, 8542 25%, 4011 10%, 8703 vehicle duty 2.5% (where applicable). • 2025 Update (USMCA non‑U.S. content rule applied): For vehicles/parts qualifying under USMCA from CA/MX, apply tariffs only to the non‑U.S. content share; duty‑free parts exempt while awaiting content‑specific application caredge.com. • Aggressive 301+: increase HS 8507 to 35–40%, 8542 to 35%, add 5–10 pp to 8409/8708, tires 15%, vehicle duty unchanged. • Balanced Trade Target (Δτ): implement a function that, given current bilateral deficit by country, calculates an incremental tariff add‑on up to +10 pp, capped, to move toward balanced trade as a stylized proxy of USTR Δτ logic tariffs.inasimonovska.com. • Custom: user‑editable table in the Scenario Lab. Tariff application logic Implement a pure function computeTariffCost(part, supplierCountry, hsCode, scenario, usmcaEligible, nonUSContentShare, value): • Base rate from TariffSchedule by hsCode and scenario. • If scenario == 2025 Update and (supplierCountry in {Canada, Mexico} OR final assembly in CA/MX) AND usmcaEligible == true, apply tariff only to value × nonUSContentShare. If part is duty‑free per schedule, apply 0. • For Balanced Trade Target, add country‑specific Δτ up to cap; show the computed Δτ in a tooltip legend. • Return: effectiveRate, assessedValue, tariffAmountUSD. Cost roll‑ups Part landed cost per unit = unitCostUSD + logisticsCostUSD/unitQtyBatch + tariffAmountUSD. Vehicle BOM cost per unit = sum over parts (qtyPerVehicle × partLandedCost). Gross profit per vehicle = transactionPrice − dealerMargin − discount − BOM cost − other variable costs (assume 5–8% of MSRP). Price pass‑through options: 0%, 25%, 50%, 75%, 100% of incremental tariff costs into MSRP; reflect in demand via elasticity. Elasticity and demand model • Allow a simple constant elasticity per segment: Sedan −1.2, SUV −1.0, Truck −0.8, EV −1.4. • When pass‑through > 0%, recompute unit sales by region with a demand multiplier: units’ = units × (price’/price)^elasticity. • Show sensitivity sliders in Scenario Lab. Emissions and risk • Track co2PerUnitKg from PartsCatalog; vehicle CO2 per unit = sum(qty × co2PerUnitKg). • Risk score per vehicle: weighted sum of (supplier concentration, China share in BOM cost, average lead time, criticality). Display 0–100. UI layout and visuals Top navbar • Title + scenario dropdown + pass‑through slider + “Run Scenario” and “Reset”. Overview tab • KPI tiles: Total tariff paid YTD, Avg effective tariff rate, Avg vehicle BOM cost, Gross margin %, Units sold YTD, CO2 per vehicle, Risk score. • Chart 1: Stacked bar – Total tariff cost by HS chapter and supplier country. • Chart 2: Treemap – BOM cost composition by category. • Chart 3: Line – Monthly tariff cost vs. gross margin %. • Table: Top 20 parts by tariff burden with columns: hsCode, partName, supplierCountry, tariffRate, tariffAmount, landedCost, vehicle coverage. Models & Pricing tab • Chart: Waterfall per vehicle – MSRP base → incremental tariffs → pass‑through → discounts → dealer margin → final transaction price → gross profit. • Table: Vehicle profitability by trim and region (sortable), with conditional formatting. Supply Chain & Parts tab • Map: Tariff cost heatmap by supplier country; click to filter. • Table: Parts list with filters for hsCode, category, supplierCountry, usmcaEligible, nonUSContentShare, effective tariff rate, criticality. • Chart: Lead time vs. tariff rate scatter, bubble size = spend. Profitability tab • Chart: Margin % distribution by vehicle and region across scenarios (selectable). • Chart: Price elasticity impact – units vs. price index curves by segment. • Table: Month‑by‑month P&L summary: revenue, COGS, tariff, gross profit, margin %. Scenario Lab tab • Editable tables: Custom TariffSchedule and Δτ country add‑ons. • Controls: Pass‑through slider, elasticity overrides per segment, toggle USMCA rules on/off, FX sensitivity ±10%. • Outputs: Compare Baseline vs Selected scenario across KPIs, with a small multiples chart set (tariff cost, margin %, units, revenue). • Button: “Save Scenario” to snapshot state and allow quick switching between saved scenarios. About/Methodology tab • Static panel with assumptions, tariff logic explanation, USMCA treatment and non‑U.S. content share approach caredge.com. • Note on Δτ as stylized representation inspired by USTR model tariffs.inasimonovska.com. • Data is fully synthetic and for demonstration only. AUTO XYZ is fictional. Interactivity and UX • All charts respond to global filters; brushing/selection filters other components. • Right‑click any data point to “Trace to Parts” (drills down to contributing parts and vehicles). • Tooltips show formulas for effective tariff calculations and USMCA non‑U.S. content application. • Provide a “What changed?” diff panel after running a scenario to list top drivers by HS code and country. Accessibility and responsiveness • WCAG AA contrast, keyboard navigation, ARIA labels on interactive elements. • Responsive layout for desktop and tablet; collapse sidebar on small screens. Exports • Export tables to CSV; export charts to PNG; “Download Report (PDF)” generates a printable summary with the Overview KPIs, two key charts, and scenario parameters. Testing hooks • Include a “Validate Calculations” modal that randomly samples 5 parts and one vehicle, showing step‑by‑step tariff and landed cost math with totals that reconcile to charts. • Provide a deterministic seed entry to reproduce runs. Sample synthetic parameter ranges (guidance for generator) • avgNonUSContentShare: Canada/Mexico USMCA‑eligible vehicles 0.25–0.45; others 0.55–0.85; EV batteries non‑U.S. share generally higher. • Country mixes: electronics from China/Vietnam/Thailand/India/Germany; batteries from China and domestic; chassis/8708 from Mexico/Canada; tires 4011 from Thailand/Vietnam. • MarginTargetPct: 12–20% by segment; EV initially lower. • Logistics costs: 1–6% of part cost typical; long‑haul Asia higher. • Lead times: semis 45–90 days, batteries 30–60, chassis 20–40, tires 25–45. Data privacy and legal • Data is entirely synthetic. Display a footer note: “This dashboard is a demonstration using synthetic data. Sources referenced for policy context only: caredge.com, tariffs.inasimonovska.com.” Acceptance criteria All tabs render with working charts and tables tied to filters. Tariff calculations reflect USMCA non‑U.S. content logic in the 2025 Update scenario. Scenario Lab recomputes demand, pricing, margins with pass‑through and elasticity. Export and “Validate Calculations” work. App runs offline with no external data calls. End of instructions - Initial Deployment
-
388 Bytes
initial commit