Analytics Studio
Drill-down KPIs, board packs and what-if scenarios computed from the shared demo fact tables — never hardcoded charts.
SYNTHETIC DEMO DATA31 of 39 KPIs liveDeterministic sample calculation · Shared demo fact tables
Demo data. Synthetic demo figures. Not live balances, not bank-confirmed, not connected to QuickBooks or any bank. FX USD/COP 4,185.5 · Demo fixed rate ·
Unified filters
Department and role scope the view only — they never change the underlying figures. · Department/Role: Executive
What-if simulator
Isolated scenario over TRD-26-017. Deterministic deltas only — base data and approved records are never altered.
| Scenario line | Base | Scenario | Delta |
|---|---|---|---|
| Commodity price | $2,277,800 | $2,277,800 | $0 |
| Ocean freight | -$73,800 | -$73,800 | -$0 |
| FX on COP local costs | -$28,500 | -$28,500 | -$0 |
| Payment delay financing | -$14,800 | -$14,800 | -$0 |
| Demurrage event | $0 | -$0 | -$0 |
| Trade margin | $172,200 | $172,200 | $0 |
Assumptions
- Base: TRD-26-017 — 8,200 MT, expected margin $172,200 over estimated costs.
- Freight delta adds directly to ocean freight cost.
- Price delta applies to the full 8,200 MT contract quantity.
- FX delta applies only to the COP-denominated share of local costs (assumed 15% of port & agency).
- Payment delay cost = open invoice $286,000 × 12% annual (demo assumption) × days/360.
- Demurrage days × $12,800/day (DEM-26017 demo rate, before Execution signoff).
- Scenario output is illustrative and never changes authoritative records.
Data freshness & coverage
- Data snapshot date2026-10-30
- FX USD/COP (Demo fixed rate)4,185.5 · 2026-10-30
- 31 of 39 KPIs liveLive
- 8 not yet calculatedNot yet calculated
Missing or stale inputs are shown as gaps, never filled with invented values.
Exceptions panel
- $9,466,900
- 58.8
- 15
- 1
- $311,752
- 3