McGrinsey
← Dashboard
Financial Dashboard
Executive Summary
ABC Analysis
Top Products
Serie Deep Dive
Margin Analysis
Pricing Intelligence
Product Mix

Revenue by WGU (TEUR)

Units by WGU

Margin Distribution

Revenue Concentration (Lorenz/Pareto)

Cumulative Revenue Curve (ABC)

Revenue vs Units (by ABC Class)

ABC by Serie

ABC Classification Table

Top 30 by Units Sold

Top 30 by Revenue (TEUR)

Top 30 by Margin EUR (VK-EP)*Stueck

Aggregated Products Table

Price Waterfall

Price vs Weight (Regression)

Margin per Variant

Revenue per Variant (TEUR)

Lock Variant Analysis

Sockel + EUR/kg Formula

Margin % by WGU

Margin % by Sicherheitsstufe

Total Margin EUR by Serie (Top 30)

Margin % vs Price

Margin % vs Weight

Low Margin Products (<30%)

Margin Opportunity: High Volume + Low Margin

Regression Results per Serie (Sockel + EUR/kg)

Selected Serie Scatter + Regression

Sockelpreis vs Sicherheitsstufe

Grenzkosten Distribution (EUR/kg slopes)

Anomaly Detection (>20% deviation)

Pricing Anomalies Table

Heatmap: Sicherheit x Gewichtsklasse (Units)

Heatmap: Sicherheit x Preisklasse (Units)

Sweet Spot Analysis

Top Lock Codes

Popularity Score (Units * Margin EUR)

Treemap: WGU > Serie > Product (by Revenue)

HT Financial Analyst
Frag mich zu Margen, ABC-Analyse, Pricing oder Produktmix!