Skip to main content
The Finance module in SIMCEL provides a complete view of your financial performance through the Business Explorer dashboard. Access it by clicking the Biz icon in the sidebar.

​
Business Explorer widgets

​
KPI table

A summary of all performance metrics for the plan with values for each active scenario. Compare scenarios side by side to evaluate financial impact. See the KPI Glossary for the complete list of metrics and formulas.
KPI table widget showing all performance metrics with multiple scenario columns, values, and color-coded differences — green for favorable movements and red for unfavorable movements

​
P&L waterfall chart

A waterfall visualization showing how revenue flows through costs to arrive at net income. Benefits:
  • Breakdown of components - See the incremental effect of each cost component
  • Visualize contributions - Distinguish between positive (revenues) and negative (costs) contributions
  • Performance comparison - Compare across scenarios to identify variances
Click the full-screen icon to expand the waterfall for a detailed view.
P&L waterfall chart showing bars flowing from Gross Sales down through cost deductions to EBIT, with positive bars in green/blue for revenue contributions and negative bars in red for cost deductions

​
Sales and profit evolution chart

A time-series chart comparing Constrained Net Sales In across scenarios. Tracks sales and profit trends over your planning horizon.
Sales and profit evolution line chart showing Constrained Net Sales In trends across multiple scenarios over the planning horizon, with each scenario represented by a distinct colored line

​
KPI tracker table

Select any KPI to be summarized for the selected scenario over time. Track specific KPIs, compare performance across scenarios, and make informed decisions based on trends.
KPI tracker table with a selected KPI displayed across time periods and scenario comparison rows, showing how the chosen metric evolves over the planning horizon for each active scenario

​
Financial KPI structure

SIMCEL calculates financial KPIs following this P&L 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
= DPM (Distribution, Promotion & Medical)
  - Administration
= DPMA
= EBIT (Earnings Before Interest & Tax)

​
Key financial KPIs with formulas

​
Revenue metrics

KPIFormula
Primary Demand ValueSum(DemandValue) where Facility Type = Distributor
Primary Demand VolumeSum(OrderQuantity) where Facility Type = Distributor
Primary Gross Sales ValueSum(ConstrainedSalesInGSV) where Facility Type = Distributor
Primary Trade ExpensesSum(TradeExpense) where Facility Type = Distributor
Primary Net Sales ValuePrimary Gross Sales - Primary Trade Expenses
Secondary Demand ValueSecondary Demand Volume x Listed Price
Secondary Demand VolumeSum(UnconstrainedSalesOut) where Facility Type = Customer
Secondary Gross SalesSum(ConstrainedSalesOutGSV) where Facility Type = Customer
Secondary Trade ExpensesSum(TradeExpense) where Facility Type = Customer
Secondary Net SalesSecondary Gross Sales - Secondary Trade Expenses

​
Cost metrics

KPIFormula
COGSDirect from simulation data
TransportSum(CostMaster) where Group Level 2 = Transport
Storage & HandlingSum(CostMaster) where Group Level 2 = Storage & Handling
PromotionSum(CostMaster) where Group Level 2 = Promotion
Medical AffairsSum(CostMaster) where Group Level 2 = Medical Affairs
AdministrationSum(CostMaster) where Group Level 2 = Administration
Supply Chain CostTransport + Storage & Handling

​
Profitability metrics

KPIFormula
Gross ProfitConstrained Sales In GSV - Trade Expenses - COGS
Gross Margin %Gross Profit / Net FIE Sales x 100
DPMSupply Chain Cost + Promotion + Medical Affairs
DPM %DPM / Net FIE Sales x 100
DPMADPM + Administration
DPMA %DPMA / Net FIE Sales x 100
EBITGross Profit - Transport - Storage & Handling - Promotion - Medical Affairs - Administration
EBIT %EBIT / Net FIE Sales x 100
COGS %COGS / Net FIE Sales x 100

​
Working capital metrics

KPIDescription
Average Inventory ValueSum(Month-End Inventory Volume x COGS) / Number of months
AR (Accounts Receivable)Outstanding customer payments
DSO (Days Sales Outstanding)Average days to collect payment
DIO (Days Inventory Outstanding)Average days of inventory on hand
CCC (Cash Conversion Cycle)DSO + DIO - DPO

​
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
The direction of “favorable” depends on the KPI type. For revenue and profit KPIs (Profit type), an increase is favorable. For cost and expense KPIs (Lost type), a decrease is favorable.