P&L Waterfall

The P&L Waterfall widget displays the different revenues and costs up to the Constrained Net Sales In in a waterfall format. It helps you with:

Breakdown of components: Shows the incremental effect of each component on the final net income.
Visualizing contributions: Distinguishes between positive contributions (revenues) and negative contributions (costs and expenses) to the overall financial outcome.
Facilitating decision making: Isolates and visualizes the impact of individual P&L components.
Performance comparison: Compares various scenarios to identify variances.

P&L waterfall chart showing revenues and costs as incremental bars building up to Constrained Net Sales In — The P&L Waterfall widget in the Business Explorer

P&L structure

SIMCEL cascades financial KPIs down this waterfall:

Primary Gross Sales Value (Constrained Sales In GSV)
  - Primary Trade Expenses
= Primary Net Sales Value (Net FIE Sales)
  - COGS (Distributor COGS)
= Gross Profit
  - Transport
  - Storage & Handling
= (Supply Chain Cost)
  - Promotion
  - Medical Affairs
= D-P-M (Distribution, Promotion & Medical)
  - Administration
= D-P-M-A
= EBIT (Earnings Before Interest & Tax)

See KPI Table for the formula behind each line.

Scenario comparison

The Business Explorer highlights differences between scenarios using color coding:

Green — favorable movement (higher revenue, lower costs)
Red — unfavorable movement (lower revenue, higher costs)

% Difference = ((Scenario Value - Active Scenario Value) / |Active Scenario Value|) x 100

Full screen view

To enable the full screen view for this widget, click the full screen button.

Getting Started

Demand Planning

Stock In Trade

Supply Simulation

Business Explorer

Tools

Collaboration

Carbon

Reference

P&L structure

Scenario comparison

Full screen view

​P&L structure

​Scenario comparison

​Full screen view

P&L structure

Scenario comparison

Full screen view