Executive read · current selection
EMEA P&L
P&L bridge
What stands out
Like-for-like markets
Variable margin bridge
Prior → currentVolume and price & mix at the prior VM rate; each cost line = change in its rate (% of gross sales) × current gross sales. Steps add up exactly to the VM change.
Key messages
Change by market
P&L comparison
USDVariance by market
Sorted by size of VM changeVariance by brand
Sorted by size of VM changeScenario setup
Levers · applied in this order to the rest of the year
Add lever
Scenario P&L · full year to operating profit
Base vs scenario · % of net revenueOperating profit bridge
Base → each lever → scenarioKey messages
Impact by market
Impact by brand
Markets compared
Domestic vs Direct Import
Market P&L & health
USDBrand × Market
Operating profit by brand
Brand P&L & health
USD · by brandSelect SKUs
Uses the Market, Channel and Brand filters on the left, plus the Central-costs view. Benchmarks: the SKU's brand and all SKUs in the region in the same filters, closeouts excluded.
Central forecasts
P&L bridge to Variable Margin
Central forecast profitability matrix: gross sales, allowances, cost of goods, royalties, then warehousing and freight. VM = GMR − warehousing − freight. Logistics apply to Domestic only. Submission-based forecasts use the submitted P&L lines instead.
VM change by market
Click a market to focus on it.
Markets
USDSmall figures under a value = change vs the earlier forecast in the comparison (green = better, red = worse). Allowance change: lower is better. Forecasts may cover different sets of markets; the market count is shown in each column header.
Brands
USD · by brandReading the forecast scenarios
▤
Scenarios
Each button picks a forecast scenario for the Current and Compare slots. Small figures under a value show the change versus the comparison scenario.
=
Phased forecasts
Phased forecasts split each forecast by month and fit it to the monthly sales plan; uplift = phased ÷ before phasing. See the Monthly tab.
Comparing different methods
▤
Submission-based forecasts
Some scenarios are consolidated from market submissions rather than built from the central matrix, so their P&L lines are mapped onto the same layout down to variable margin. Central costs and closeouts are excluded.
!
Not always like-for-like
Scenarios built with different methods are not strictly comparable: a change between them mixes a method change with the forecast change.
Nov FC Phased · month by month
Net Revenue by month
Bars = the phased forecast picked above. With Net Revenue selected and no brand filter, the dark tick is the monthly sales plan target and the dashed line is the same forecast before phasing (same SKUs, factor 1). Hover a bar for the numbers.
Monthly P&L
USD · fiscal monthsSame P&L lines as the Central FC tab, split by fiscal month. Price, allowance, cost, royalty and logistics rates are the full-year rates of that forecast applied to each month.
Market × month
Phasing check
Net revenueUplift = phased ÷ before phasing for the month: the volume factor applied to fit the monthly sales plan. Months with a plan but no forecast units cannot be scaled and are left as they are.
Brands by month
Net revenue · peak month highlightedEach brand keeps its share of its market × channel full-year net revenue; only the timing across months moves.
Average SRP by brand and market
Brand × Market average SRP
Average SRP = Σ(units × SKU SRP) ÷ Σ units priced. Each cell is shaded against the same brand’s regional average: amber = the market sells a pricier mix, blue = a cheaper mix. Hover for units, SRP coverage and net price per unit.
Average SRP by brand (EMEA)
Bar = average SRP. Hover a bar for net sales per unit and the share of SRP it represents.
What stands out
Price-band mix
Share of units by SRP band in each market. Because the SRP of a SKU is the same everywhere, differences in average price come from which SKUs each market sells.
Top 20 SKUs by net revenue · EMEA
Ranking within each market
1–5 top 5 in market6–2021–5051+ weak in market– not soldn/c market not in the central forecast
Rank = position of the SKU among all SKUs in that market by net revenue (same Channel and Brand filters). “vs FC1/FC2” = change in regional rank against the other forecast (▲ = moved up).
Net revenue · top 20
What stands out
Insights Engine
Ask a question about the dashboard data in plain English, for example comparing prices, margins, forecasts or SKUs between markets and brands. Answers are written from the dashboard data only. Each answer shows the data it used.
Each question uses your own Claude usage; the first one asks your permission.