This report presents findings from an autonomous 20-iteration data exploration comparing electrified vehicles (ELECTRIC, PHEV, HYBRID) against ICE (PETROL, DIESEL) across Falcon Car Manufacturing's production, quality, service, and revenue dimensions. All numerical claims have been fact-checked and verified against re-derived queries.
Electrified vehicles punch above their weight: With 6 models (vs. 11 ICE), electrified vehicles produce 35.7% of total units (664,546 of 1,863,263) but generate 41.2% of total revenue ($31.79B of $77.16B). The average MSRP of electrified models ($48,739) is 27% higher than ICE ($38,241). The Mercedes EQS alone generates $10.55B in gross revenue potential, making it the single highest-revenue model in the portfolio.
No EV after-sales data exists. All 195 warranty claims, all 888 service jobs, and all ELECTRIC/PHEV defect records are absent from the data warehouse. Only PETROL models have warranty and service data. HYBRID has 83 defect records but no warranty or service records. This makes it impossible to assess EV total cost of ownership from internal data.
Electrified production share is declining, not growing. After peaking at 39.8% in 2022, electrified share fell to 33.5% in 2024. Pure EV production dropped from 48,303 units (2020) to 33,375 (2024) — a 31% decline. This trend runs counter to global industry momentum toward electrification.
Tables explored: V_DAILY_PRODUCTION_SUMMARY (12,945 rows), DIM_VEHICLE_MODEL (18 models, 17 active), FACT_WARRANTY_CLAIMS (195 rows), FACT_DEFECTS (206 rows), FACT_SERVICE_JOBS (888 rows).
Join methodology: Production data joined to model dimensions on both MODEL_NAME and VARIANT to prevent double-counting of models with multiple variants (3 Series, Camry, Civic each have two variants with different engine types).
Strategy: Hypothesis-driven directed exploration with fact-check verification cycle. All claims use correlational language as the data is observational.
Electrified models generate 41.2% of portfolio revenue ($31.79B of $77.16B) from 35.7% of production volume, using just 6 of 17 active model-variants. Revenue per model-variant averages $5.30B for electrified vs $4.12B for ICE — a 29% premium.
| Model | Variant | Engine | MSRP | Units | Revenue ($B) |
|---|---|---|---|---|---|
| Mercedes EQS | EQS 450+ | ELECTRIC | $104,400 | 101,014 | $10.55 |
| BMW X5 | xDrive40i | PETROL | $61,700 | 99,509 | $6.14 |
| Mercedes E-Class | E350 4MATIC | PETROL | $56,750 | 97,235 | $5.52 |
| Toyota RAV4 | Hybrid AWD | HYBRID | $33,275 | 153,264 | $5.10 |
| VW Golf | GTI | PETROL | $30,540 | 158,748 | $4.85 |
| VW ID.4 | Pro S AWD | ELECTRIC | $44,435 | 108,774 | $4.83 |
| BMW 3 Series | 330e Hybrid | PHEV | $47,900 | 98,080 | $4.70 |
| Ford Mustang | GT Premium | PETROL | $42,900 | 106,191 | $4.56 |
| BMW 3 Series | 330i xDrive | PETROL | $44,900 | 97,681 | $4.39 |
| Ford Transit | Cargo Van LWB | DIESEL | $43,195 | 97,967 | $4.23 |
| Ford F-150 | XLT 4x4 | PETROL | $36,080 | 108,446 | $3.91 |
| Honda CR-V | Hybrid AWD | HYBRID | $33,450 | 104,979 | $3.51 |
| VW Tiguan | SE 4Motion | PETROL | $30,895 | 112,343 | $3.47 |
| Toyota Camry | Hybrid XLE | HYBRID | $31,550 | 98,435 | $3.11 |
| Toyota Camry | XSE V6 | PETROL | $30,025 | 96,749 | $2.90 |
| Honda Civic | Sport | PETROL | $23,750 | 115,127 | $2.73 |
| Honda Civic | Hatchback EX | PETROL | $24,500 | 108,721 | $2.66 |
Highlighted rows = electrified models. Revenue = Units Produced x MSRP. Sample: all production 2020-2024. n=1,863,263 total units across 17 active model-variants.
Electrified production share peaked at 39.8% in 2022 and has declined to 33.5% in 2024. Pure EV production (ELECTRIC) dropped 31% from 2020 to 2024. PHEV dropped 21% over the same period. Only HYBRID showed modest resilience, staying in the 63K-79K range.
| Year | Electrified Units | ICE Units | Electrified % | EV Revenue ($M) |
|---|---|---|---|---|
| 2020 | 130,442 | 244,313 | 34.8% | $3,424.9 |
| 2021 | 128,319 | 246,424 | 34.2% | $2,595.8 |
| 2022 | 148,568 | 224,717 | 39.8% | $3,527.4 |
| 2023 | 134,274 | 238,823 | 36.0% | $3,466.9 |
| 2024 | 122,943 | 244,440 | 33.5% | $2,364.1 |
EV Revenue = ELECTRIC engine type only (EQS + ID.4). Electrified includes ELECTRIC + PHEV + HYBRID. n=1,863,263 total units.
OEE, scrap rates, and rework rates are remarkably consistent across all engine types. ELECTRIC models achieve 88.01% OEE with 0.33% scrap — matching PETROL exactly. This indicates the production system handles EV manufacturing without quality penalties. ELECTRIC also has the lowest labor cost per unit at $4.81.
| Engine Type | Model-Variants | Total Units | Avg OEE % | Scrap % | Rework % | Labor $/Unit |
|---|---|---|---|---|---|---|
| PETROL | 10 | 1,100,750 | 88.01 | 0.33 | 2.48 | $4.96 |
| HYBRID | 3 | 356,678 | 88.00 | 0.33 | 2.47 | $4.97 |
| ELECTRIC | 2 | 209,788 | 88.01 | 0.33 | 2.48 | $4.81 |
| PHEV | 1 | 98,080 | 87.92 | 0.33 | 2.45 | $4.87 |
| DIESEL | 1 | 97,967 | 87.89 | 0.32 | 2.47 | $4.84 |
ELECTRIC has the lowest labor cost per unit ($4.81), 3.0% below PETROL ($4.96). n=1,863,263 total units.
The data warehouse contains zero warranty claims, zero service jobs, and zero defect records for ELECTRIC and PHEV models. Only HYBRID (83 defects) and PETROL (123 defects, 195 warranty claims, 888 service jobs) have after-sales data. This gap blocks any EV total-cost-of-ownership analysis.
| Data Source | PETROL | HYBRID | ELECTRIC | PHEV | DIESEL |
|---|---|---|---|---|---|
| Warranty Claims | 195 | 0 | 0 | 0 | 0 |
| Service Jobs | 888 | 0 | 0 | 0 | 0 |
| Defect Records | 123 | 83 | 0 | 0 | 0 |
| Production Records | Yes | Yes | Yes | Yes | Yes |
Instrument EV warranty, service, and quality inspection data pipelines as a prerequisite for any data-driven EV strategy. Without this data, after-sales cost projections for EV expansion must rely on industry benchmarks rather than internal evidence.
HYBRID models show a defect escape rate of 12.0% (10 of 83 defects), compared to 6.5% for PETROL (8 of 123). The escape rate is associated with a higher proportion of DESIGN root-cause defects (24% of all hybrid defects). All 83 hybrid defects belong to the Toyota Camry Hybrid.
| Metric | PETROL | HYBRID |
|---|---|---|
| Total Defects | 123 | 83 |
| Escaped Defects | 8 | 10 |
| Escape Rate | 6.5% | 12.0% |
| Avg Rework Cost | $191.32 | $171.45 |
| Avg Rework Hours | 4.70 | 4.39 |
| CRITICAL Defects | 7 (5.7%) | 5 (6.0%) |
Escape rate = defects that passed undetected through all inspection stages. n=206 total defects. Hybrid defects are solely from Camry Hybrid model.
All four manufacturing plants produce electrified vehicles at a similar mix (34.6–37.7%). No plant specializes in EV production. Stuttgart leads in absolute electrified volume (228,971 units) while Chennai has the highest electrified share (37.7%).
| Plant | Country | EV Units | Hybrid Units | PHEV Units | Total Units | Electrified % |
|---|---|---|---|---|---|---|
| Chennai Vehicle Plant | India | 37,141 | 64,541 | 20,390 | 324,077 | 37.7% |
| Nagoya Main Assembly | Japan | 47,970 | 77,281 | 20,101 | 405,100 | 35.9% |
| Stuttgart Assembly Plant | Germany | 65,350 | 129,206 | 34,415 | 648,058 | 35.3% |
| Detroit Production Hub | USA | 59,327 | 85,650 | 23,174 | 486,028 | 34.6% |
The two pure EV models show contrasting profiles. The Mercedes EQS ($104,400 MSRP) generates 2.18x the revenue of the VW ID.4 ($44,435) despite producing 7% fewer units (101K vs 109K). Both models exhibit production volatility with gaps at individual plants in certain years, suggesting allocation or supply chain challenges.
| Model | Brand | MSRP | Body Style | Units | Revenue ($B) | OEE % | Scrap % | Labor/Unit |
|---|---|---|---|---|---|---|---|---|
| Mercedes EQS | Mercedes | $104,400 | SEDAN | 101,014 | $10.55 | 88.04 | 0.31% | $4.77 |
| VW ID.4 | Volkswagen | $44,435 | SUV | 108,774 | $4.83 | 87.98 | 0.35% | $4.85 |
Close the EV data gap. Instrument warranty claims, service jobs, and quality inspection pipelines for ELECTRIC and PHEV models. Without after-sales cost data, any EV expansion business case will lack critical TCO validation. Priority: EQS and ID.4 warranty tracking.
Investigate the hybrid defect escape rate. At 12% vs 6.5% for PETROL, the HYBRID escape rate is associated with a higher proportion of DESIGN root-cause defects (24%). A targeted quality audit of the Camry Hybrid inspection process is recommended.
Prioritize high-MSRP EV expansion. The EQS demonstrates that premium EVs can be the #1 revenue model in the portfolio ($10.55B). Evaluate adding a second premium EV (e.g., electric SUV in the $80K+ range) to capitalize on the 27% MSRP premium electrified vehicles command over ICE ($48,739 vs $38,241).
Reverse the declining electrified production share. The drop from 39.8% (2022) to 33.5% (2024) runs counter to global EV adoption trends. Set an explicit electrified production target (e.g., 45% by 2027) and allocate plant capacity accordingly. Consider designating one plant as an EV-priority facility.
Leverage EV production efficiency advantage. ELECTRIC models already show the lowest labor cost per unit ($4.81 vs $4.96 PETROL, a 3.0% advantage). As EV production volumes scale, this cost advantage is likely to widen through learning curve effects.
| # | Hypothesis | Result | Surprise |
|---|---|---|---|
| 1 | EV models have different quality profiles | Quality nearly identical across all powertrains | Low |
| 2 | EV production should be growing | No consistent growth; declined in 2024 | High |
| 3 | EV models may have higher labor costs | EVs have LOWEST labor cost ($4.81/unit) | High |
| 4 | EV warranty costs differ from ICE | Zero EV warranty data exists | Very High |
| 5 | EV defect rates differ | Only HYBRID has defects; escape rate 2x PETROL | High |
| 6 | Service patterns differ by engine | Zero EV/HYBRID/PHEV service data | Very High |
| 7 | Hybrid defects concentrated in drivetrain | Evenly distributed across all categories | Medium |
| 8 | Certain plants specialize in EV | All 4 plants produce at similar ~35% mix | Low |
| 9 | Electrified share is increasing | Share DECLINING from 2022 peak (39.8% to 33.5%) | Very High |
| 10 | DESIGN root cause drives hybrid defects | DESIGN is #1 root cause at 24% | Medium |
| 11 | EV production is concentrated in key plants | Distributed but volatile with plant-year gaps | Medium |
| 12 | EV labor efficiency differs | ELECTRIC lowest at $4.81/unit, daily output 202 | High |
| 13 | Revenue ranking by model | EQS is #1 at $10.55B, 4 of top 7 are electrified | Very High |
| 14 | Service types show EV-specific patterns | All service is PETROL; RECALL most common type | Low |
| 15 | Warranty claim types reveal failure patterns | GOODWILL most common (35%), all PETROL | Low |
| 16 | Full revenue ranking with electrified flag | Electrified dominates: EQS #1, RAV4 #4, ID.4 #6 | High |
| 17 | Defect severity differs by powertrain | Similar distribution; HYBRID has more escapes | Medium |
| 18 | Portfolio-level electrified vs ICE economics | 41.2% revenue from 35.7% units, higher MSRP | High |
| 19 | Plant readiness varies for EV expansion | All plants equally ready at ~35% mix | Low |
| 20 | Electrified revenue trend | EV revenue declined 33% from 2022 peak | Very High |
All claims were verified in a dedicated fact-check cycle. One critical cross-population error was discovered and corrected.
| Issue | Type | Description | Resolution |
|---|---|---|---|
| MODEL_NAME join duplication | CROSS-POPULATION | Joining V_DAILY_PRODUCTION_SUMMARY to DIM_VEHICLE_MODEL on MODEL_NAME alone double-counted 3 models (3 Series, Camry, Civic) that have multiple variants | Added VARIANT to join condition. All production numbers, revenue figures, and percentages re-derived. |
| Electrified revenue | NUMERICAL | Original: $39.53B. Corrected: $31.79B | Fixed in all report sections |
| ICE revenue | NUMERICAL | Original: $58.13B. Corrected: $45.37B | Fixed in all report sections |
| PHEV units | NUMERICAL | Original: 195,761. Corrected: 98,080 | 3 Series PETROL variant was included |
| HYBRID units | NUMERICAL | Original: 453,427. Corrected: 356,678 | Camry PETROL variant was included |
| EQS revenue ($10.55B) | VERIFIED | Confirmed: 101,014 x $104,400 = $10.55B | No change needed |
| Defect escape rates | VERIFIED | HYBRID 10/83=12.0%, PETROL 8/123=6.5% | No change needed |
| EV labor cost ($4.81) | VERIFIED | Confirmed as lowest across all engine types | No change needed |
Fact-check status: Cycle 1 found 5 errors (1 cross-population, 4 numerical cascading). All corrected. Cycle 2: 0 errors. Status: CLEAN.