Loading the dataset…
Net revenue phasing
The shape of the year across all four scenarios. The shaded months are still open: the actual line stops at the close and only the forecast continues to December. Dimensional filters apply here, but the period slicer does not — a phasing chart cut to eight months is no longer a phasing chart.
Why the result moved
Who is driving the gap
The P&L
The full ladder against the selected comparison. Rows with a + open into the lines that make them up. Nothing below net revenue is stored in the dataset: every subtotal is derived from the structure the data carries.
Commercial
The gross-to-net story, on the same slicers and the same drill path. Four analyses go here:
- Gross-to-net waterfall — where the list price goes before it reaches the top line, split into on-invoice discounts, promotional and other trade spend, and returns.
- Price, volume and mix bridge — how much of the revenue movement is more cases, a different blend of them, a different list price, and a different discount.
- Realisation per case — list against gross against net price by channel, which is the gross-to-net ratio expressed in a unit a commercial team can argue about.
- Promotional return — pressure against ROI, sized by spend. Below 1.0 a promotion gives away more margin than it earns back, and in this dataset that ranges from 0.27 in Dairy to 0.82 in Personal Care.
Portfolio
Who and what, rather than how much. Two analyses go here:
- Contribution map — every customer plotted by size against contribution margin, which is where the Discount channel stops looking like growth.
- Market share — ours against the category market, actual against plan. It is the only view that separates a soft market from lost competitiveness.