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.