Skip to content

Reference & Data Model

Financial performance

KPIs on profit, value, earnings, benefit and return; the basis is the customer order, earning occurrences, cost occurrences, benefit and budgets.

KPI MP PF PG PJ Where Meaning Calculation Display
Profit (actual) („Gewinn“ – „Gesamtgewinn“ / „Aktueller Gewinn“ / „Gewinn“) ✓ ✓ ✓ ✓ MP: Overview › „Kapital & Rendite“, Portfolio comparison „Gewinn / Wert“; PF: Scoreboard › tile 1, Oversight; PG: Scoreboard › earnings card, „Projekt-Gesundheit“; PJ: Scoreboard › „Finanzen“ (trend), basis of ROI and revenue Actual earnings minus actual costs, without benefit Server: Σ earning occurrences − Σ cost occurrences per project. PG: rollup (archived included). PF: rollup excluding archived. MP: organization-wide sum; addition „x % des Kapitals“ = profit ÷ capital employed (view) € compact · tile/column
Business value („Wirtschaftlicher Wert“ / „Business Value“ [MP] / „Wirtschaftl. Portfoliowert“ / „Programmwert“ / „Projektwert“ / „Wert“) ✓ ✓ ✓ ✓ MP: Overview › „Kapital & Rendite“ › bar share, Portfolio comparison (rank, profit/value); PF: Scoreboard › tile 2, Oversight; PG: Scoreboard › strip, „Projekt-Gesundheit“; PJ: Scoreboard › band Order volume plus expected benefit Server, per project: Σ order volume + benefit (project.benefit). PF: rollup (archived included). PG strip: Σ of the project values in the view (all unknown → „—“). MP: organization-wide; fill level = min(100, value ÷ capital employed × 100) € compact · tile/bar; PG matrix: bar relative to the largest project
Profit (business case, current) („Gewinn“) ✓ ✓ ✓ PF: Business Case › tile 4 + table; PG: Business Case › card 4 + list; PJ: Business Case › card „Gewinn“ Current profit per business case logic View. PF total and project rows: actual earnings − actual costs. PJ card: additionally + benefit, only in phase „Erfolgreich Abgeschlossen“. PG card and PG total row: actual earnings + benefit − actual costs, regardless of phase € compact · tile (traffic light < 0 red, = 0 yellow, > 0 green) / column
Expected profit („Erwarteter Gewinn“) ✓ ✓ ✓ PF/PG/PJ: Business Case › card „Gewinn“ (sub „Erwartet“) + table Profit if all earnings and benefit are achieved View: (order volume + benefit) − expected total costs; expected costs = actual + planned (PF/PG aggregate) or actual only (PJ, PG project row) € · tile sub / column; row red < 0
Economic benefit („Wirtschaftlicher Nutzen“) ✓ ✓ ✓ PF: Strategy › table „Nutzen“, Profile, Business Case › tile 2 + table; PG: Scoreboard › earnings card, Profile, Business Case; PJ: Profile › header, Business Case Expected benefit after closing (master data) View: project.benefit; PF/PG Σ over projects excluding archived; 0 → „-“. Tile bar = benefit ÷ (order volume + benefit) € · tile/column
Order volume („Auftragsvolumen“ / „Auftragsvol.“ / „Erwartete Gesamterlöse“ / „Erwartete Erlöse“ / „Erwarteter Umsatz“) ✓ ✓ ✓ PF: Strategy › table, Profile „Erwartete Erlöse“, Business Case; PG: Business Case › list; PJ: Profile › header, Business Case › card „Einnahmen“ (sub „Erwartet“), table Contractually expected earnings View: order volume of the customer order (order.order_volume); PF/PG Σ; without order „–“ € · column/sub
Actual earnings („Ist-Erlöse“ / „Einnahmen“ / „Aktuelle Erlöse“ / „Bisherige Erlöse“ / „Bisher eingegangen“) ✓ ✓ ✓ PF: Business Case › tile 1 + table, Profile; PG: Business Case › card 1 + list; PJ: Business Case › card „Einnahmen“ + table, Profile › customer order Earning occurrences already recorded View: Σ earning occurrences of the order; PF/PG Σ over projects; tile bar = actual earnings ÷ order volume € · tile + bar / column
Planned (outstanding earnings) („Geplant“) ✓ ✓ ✓ PF/PG/PJ: Business Case › table Part of the order volume not yet recorded View: order volume − actual earnings € · column
ROI (business case, expected / current) („ROI“) ✓ ✓ ✓ PF/PG/PJ: Business Case › card „Gewinn“ (sub) Return expected and current View: ROI expected = expected profit ÷ expected total costs; ROI current = current profit ÷ actual costs (each per the level’s business case definition) % · tile sub
Business case bars („Aktuell“ / „Erwartet“: „Kosten“, „Einnahmen“, „Nutzen“, „Gewinn“) ✓ ✓ ✓ PF/PG/PJ: Business Case › chart Actual against expected View. Current: actual costs, actual earnings, benefit only in phase „Erfolgreich Abgeschlossen“ (PG: program phase), current profit. Expected: expected costs, order volume, benefit, expected profit € · stacked bars
Profit trend („Gewinnverlauf“ / „Trends“ – „Monatlicher Gewinn“) ✓ ✓ MP: Overview › card „Trends“; PJ: Scoreboard › „Finanzen“ „Gewinn“ Profit per month Server trend: Σ earnings − Σ costs per month of the occurrence date, not cumulative; legend „Plan“ without data € · line (actual)
Profit / value (bar) („Gewinn / Wert“) ✓ ✓ MP: Portfolio comparison › column; PF: Scoreboard › „Aufsicht“ › column Profit share of the business value per row View from server values: profit ÷ max(1, value) × 100, limited to 0–100. PF program row: profit = server rollup, value = Σ project values of the children in the view Bar + „€ / €“; not comparable across rows
Revenue (derived, scoreboard) („Einnahmen“ / „Erzielte Einnahmen“) ✓ ✓ PG: Scoreboard › earnings card „Einnahmen“; PJ: Scoreboard › band „Erzielte Einnahmen“ Actual earnings, back-calculated from profit and costs Server profit + actual costs of the view; profit unknown → „—“ € compact · tile
Expected total revenue („Erwartete Gesamteinnahmen“) ✓ ✓ PF/PG: Business Case › table Order volume plus benefit View: project row and PF total = order volume + benefit. PG total row: order volume only (tooltip points this out) € · column
Internal interest rate („Interner Zins“) ✓ ✓ PG/PJ: Profile › header data Discount rate (master data) Direct field internal_interest_in_pct, 2 decimals %
Realization („Realisierung“) ✓ Project › Business Case › table Share of earnings already achieved View: actual earnings ÷ order volume × 100 (2 decimals); without order „-“ %
ROI (actual costs) („ROI“) ✓ Project › Scoreboard › ROI card Return on actual costs Server: 100 × (Σ earning occurrences − Σ cost occurrences) ÷ Σ cost occurrences; ÷ 0 → 0. Card bars „Einnahmen vs. Kosten“ from view values % · number + 2 bars; red < 0
Value / ROI (prioritization) („Wert“ / „ROI“) ✓ Portfolio › Strategy › table (+ footer Σ/ROI); Scoreboard › „Balance“ › scatter plot (Y „Wert“) Net value of an element and return on total costs View: expected income = order volume (with an order), otherwise benefit; value = expected income − total costs (prioritization); ROI = value ÷ total costs × 100 („–“ at costs 0; footer 0 %) € compact + % (green > 0 / red)
Total costs (prioritization) („Gesamtkosten“ / „Ges.kosten“) ✓ Portfolio › Strategy › table „Ges.kosten“, costs-vs-benefit bars, radar, scatter plot (bubble size) Cost basis of the prioritization View: project = actual costs; program = actual + planned costs (phase filter „Planung“) € · column / bubble / axis
ROI (portfolio profile) („ROI“) ✓ Portfolio › Profile › quick stats (with „Gewinn“) KPI of the portfolio profile View: profit = actual earnings − cost item budget (not − actual costs); ROI = profit ÷ cost item budget × 100 € + %
Return on capital („Kapitalrendite“) ✓ Overview › „Kapital & Rendite“ › chip 1 Profit per euro of capital employed Server: (Σ earning occurrences − Σ cost occurrences) ÷ Σ budget records; ÷ 0 → 0 Ratio (2 decimals) „von 2,00“ (display scale, not a threshold)
Value-to-capital ratio („Wert-Kapital-Verhältnis“) ✓ Overview › „Kapital & Rendite“ › chip 2 Value per euro of capital employed Server: (Σ order volume + Σ benefit project.benefit) ÷ Σ budget records Ratio (2 decimals)
Earnings waterfall („Erlös-Wasserfall“) ✓ Project › Business Case (only with an order) Earning occurrences chronologically View: earning occurrences sorted by occurrence date € · waterfall
  • „Gewinn“ (profit) has several definitions. Scoreboard profit (server) = earnings − costs without benefit. Business case profit (view) counts the benefit immediately depending on the place (program card, program total row), only from „Erfolgreich Abgeschlossen“ (project card, bar charts) or never (portfolio total, project rows). The portfolio profile subtracts the cost item budget instead of the actual costs. Compare profit figures only within the same view.
  • Business case table (portfolio, program): program and project rows are mirror images for „Erwartete Gesamteinnahmen“ and „Aktueller Gewinn“ (program row without or with benefit, project rows the other way round). The total row is not a column sum.
  • Derived revenue in the scoreboard (server profit + actual costs of the view) can differ from the business case revenue (Σ earning occurrences): with cost occurrences without a cost item, with archived projects in the program rollup, or during recalculation.
  • Archived projects: the portfolio profit excludes them, the portfolio value includes them. Numerator and denominator of „Gewinn / Wert“ therefore rest on different sets of projects.
  • Profile project cards (portfolio, program) and the project header show the order volume under „Wirtschaftlicher Nutzen“ when an order exists.
  • Profit trend: the legend „Plan“ has no data; there is no planned profit series.
  • Value / ROI (prioritization): because „Gesamtkosten“ for projects is actual costs only, but for programs actual + planned, project and program rows are not calculated the same way.