France Auto – Turnaround KPI Workbench
BCG | France Auto – KPI Workbench
v1.3 • interactive
fully interactive. Baselines from the case (Year N-1): Desktop €350M @ 6% CR & AOV €100; Mobile €150M @ 2% CR & AOV €91; GM% 25%. Drag sliders to simulate Reset

Mobile Levers

2.0%
€91.0
100%
25.0%
Revenue (Mobile)
€150.0M
Δ €0.0M
Gross Margin € (Mobile)
€37.5M
Δ €0.0M
Sessions (Mobile)
82.4M
baseline

Desktop Levers

6.0%
€100.0
100%
25.0%
Revenue (Desktop)
€350.0M
Δ €0.0M
Gross Margin € (Desktop)
€87.5M
Δ €0.0M
Sessions (Desktop)
58.3M
baseline

Call Center (Handout 6)

Baseline volumes & cost per call from the case; use sliders to simulate deflection via FAQ/chat, better tracking, etc. // Default Data is Year N-1
2.0M
€3.0
3.0M
€1.0
2.0M
€5.0
0.5M
€2.0
Total Calls (M)
7.5M
baseline
Call Center Cost (€M)
€20.0M
baseline
Cost / Order proxy
—
needs orders input

P&L Summary

Profit computed as Total GM€ – Fixed Costs – Call Center Cost. Fixed costs default to case Year N-1 values. // Call Center, Mobile and Desktop levers are at Year N-1 by default
€40.0M
€20.0M
€15.0M
€10.0M
€0.0M
Total Fixed Costs (€M)
€85.0M
baseline
Total GM (€M)
€125.0M
baseline
Profit (€M)
€20.0M
baseline

📊 Totals & Mix

Live recomputation: Revenue = Sessions × AOV × CR · GM€ = Revenue × GM% · Profit = GM€ – Fixed – Call Center.
Total Revenue
€500.0M
Δ €0.0M
Total Gross Margin €
€125.0M
Δ €0.0M
Weighted GM %
25.0%
baseline
Revenue Mix (Desk/Mob)
70% / 30%
baseline

📈 Revenue by Channel — Baseline vs Current

Desktop (Current)
Desktop (Baseline)
Mobile (Current)
Mobile (Baseline)

📉 Conversion Rate — Baseline vs Current

Current
Baseline