Reference & Data Model
Budget & costs
KPIs on budgets, actual costs, planned costs and budget requests; the basis is cost items, cost occurrences, planned costs, budgets and the budget goal.
| KPI | MP | PF | PG | PJ | Where | Meaning | Calculation | Display |
|---|---|---|---|---|---|---|---|---|
| Actual costs („Ist-Kosten“ / „Aktuelle Gesamtkosten“ / „Ist“ / „Kosten aktuell“ / „Aktuelle Kosten“) | ✓ | ✓ | ✓ | ✓ | MP: Overview › „Fehlgeschlagene Projekte“, „Portfolio-Vergleich“ (costs / budget); PF: Scoreboard (hint „Ist“), Oversight, Budget, Business Case; PG: Scoreboard › budget/earnings card, Budget, Business Case; PJ: Scoreboard › band + „Finanzen“, Budget plan, Business Case | Actual costs booked so far | Server: Σ cost occurrences in the project; PF/MP as rollup over every non-deleted project, failed ones too (archiving changes nothing). View: Σ cost occurrences over the project’s cost items; PG/PF Σ over child projects | € compact · tile/column |
| Budget goal („Budgetziel“) | ✓ | ✓ | ✓ | ✓ | MP: Portfolio comparison › „Budgetziel“; PF: Profile › quick stats, project/program cards, budget tile sub „Ziel“; PG: Profile, Budget › list (row + Σ); PJ: Profile › header, Budget plan (column, sub „Ziel“) | Target budget from the profile; does not enter any table calculation | Direct field budget_goal; Σ row (PG) only over projects with a value, otherwise „-“ |
€ · number |
| Planned costs („Geplante Kosten“ / „Ausstehend“ / „Geplant“) | ✓ | ✓ | ✓ | PF: Budget › tile „Kosten“ (sub „Ausstehend“), list, charts; PG: Scoreboard › budget card „Ausstehend“, Budget; PJ: Scoreboard › „Finanzen“, Budget plan | Planned costs not yet incurred | View: Σ planned costs over cost items. PF/PG aggregates with phase filter „Planung“; individual project rows without. PJ table column „Geplant“ = max(0, planned − actual) per cost item; PJ tile percentage = max(0, planned − actual) ÷ cost item budget | € compact · tile/column | |
| Cost item budget („Kostenarten-Budget“ / „Budget“ / „Geplantes Budget“ / „Working Capital“ [PG]) | ✓ | ✓ | ✓ | PF: Budget › tile „Budget“, list, Profile „Geplantes Budget“; PG: Scoreboard › strip „Working Capital“ + budget card, Budget › list; PJ: Scoreboard › band „Budget“ + „Finanzen“, Budget plan › list | Sum of the budgets stored per cost item | View: Σ budgets of the project’s cost items; PG/PF Σ over child projects. PJ band: 0 → „—“ | € compact · tile/column; PF tile bar = remaining ÷ budget | |
| Remaining budget („Rest-Budget“ / „Budgetabweichung“ [PF tile] / „Abw.“ / „Prognose Restbudget“) | ✓ | ✓ | ✓ | PF: Scoreboard › tile „Budgetabweichung“; PG: Scoreboard › budget card „Restbudget“, Budget › cards „Rest-Budget“ and „Prognose Restbudget“, list; PJ: Budget plan › cards „Rest-Budget“/„Prognose Restbudget“, list | Remaining cost item budget after actual costs | View: cost item budget − actual costs (planned costs are not subtracted); PF/PG Σ over child projects; negative = exceeded | € compact · tile (traffic light < 0 red, = 0 yellow, > 0 green) / column | |
| Forecast costs / expected total costs („Forecast-Kosten“ / „Erwartete Gesamtkosten“) | ✓ | ✓ | ✓ | PF: Budget › tile „Kosten“ + list, Business Case „Kosten“; PG: Business Case › card „Kosten“ (sub „Erwartet“), total row; PJ: Business Case › card „Kosten“ (sub „Erwartet“) | Expected total costs = actual + planned | View, PF/PG aggregate: actual costs + planned costs (phase filter „Planung“). Individual project value (PJ card, PG project row): actual costs only | € compact · tile/column | |
| Budget utilization („Budgetausschöpfung“ / „Budget vs. Ist“ / „Budget · Ist · Ausstehend“ / „Budgetnutzung“) | ✓ | ✓ | ✓ | PF: Budget › list „Budgetnutzung“; PG: Scoreboard › „Projekt-Gesundheit“ „Budget vs. Ist“, budget card; PJ: Scoreboard › „Finanzen“ › bar | Actual and planned share of the cost item budget | View: actual share = min(100, actual ÷ budget × 100); pending share = min(100 − actual %, planned ÷ budget × 100); budget 0 → „—“/„Noch keine Daten“ | Bullet/bar (2 colors) + legend; red if actual > budget (PG matrix: > 100 % red, ≥ 90 % yellow) | |
| Requested („Beantragt“, budget requests) | ✓ | ✓ | ✓ | PF: Budget › tile „Budgetanfragen“ + list; PG: Budget › list; PJ: Budget plan › list | Sum of all budget requests | View: Σ requested amount over all states (including rejected/withdrawn); PF/PG Σ over child projects | € · tile/column | |
| Approved („Genehmigt“) | ✓ | ✓ | ✓ | PF: Budget › tile „Budgetanfragen“ (% approved); PG/PJ: budget list | Sum of approved budget requests | View: Σ requested amount with state „Genehmigt“; does not change the cost item budget automatically | € · tile (bar requested → approved) / column | |
| Cost bar chart (actual costs / planned costs / budget) | ✓ | ✓ | ✓ | PF/PG: Budget › chart (X = project); PJ: Budget plan (X = cost item) | Cost situation per project or cost item | View: per element Σ actual, Σ planned (PF/PG with phase filter „Planung“), Σ cost item budget | € · grouped bars (3 series) | |
| Budget treemap / budget tree („Budget-Treemap“ / „Budgetbaum“) | ✓ | ✓ | ✓ | PF/PG: Budget › „Baum“; PJ: Budget plan › „Baum“ | Distribution of the cost item budget | View: area = budget; PF/PG: project = Σ cost items, children = cost items. PJ per cost item: budget, requested, actual, planned, deviation = budget − (actual + planned), % deviation | € · treemap | |
| Working capital („Working Capital“, budget goals) | ✓ | ✓ | PF: Scoreboard › tile 4 (hint „Ist“); MP: Portfolio comparison › „Kosten / Budget“ (plan basis) | Capital employed in a portfolio as the sum of the project budget goals | Server rollup: Σ budget goal of the portfolio projects with status „Aktiv“ or „Pausiert“ (archiving changes nothing) | € compact · tile | ||
| % deviation („% Abw.“) | ✓ | ✓ | PG: Budget › list; PJ: Budget plan › list + total row | Remaining budget relative to the cost item budget | View: (budget − actual) ÷ budget × 100, 2 decimals; budget 0 → „–“ | %; red < 0 | ||
| Budget deviation („Budgetabweichung“, budget goal) | ✓ | ✓ | PG: Scoreboard › strip; PF: Scoreboard › „Was heute zählt“ (text) + sort weight | Budget goal minus actual costs | Server: budget goal − Σ cost occurrences; PG as rollup over every non-deleted project (archiving changes nothing); negative = exceeded | € compact · tile/text | ||
| Costs / budget („Kosten / Budget“, budget goal basis) | ✓ | ✓ | MP: Portfolio comparison › column; PF: Scoreboard › „Aufsicht“ › column | Actual costs as a percentage of the budget goals | Server values, ratio in the view: actual costs ÷ Σ budget goals; plan 0 → „—“; PF program row Σ children | Bullet bar (capped at 100 %, number real) + „Ist / Plan · x %“; red > 100 %, yellow ≥ 90 % | ||
| Cost trend („Kostenverlauf“, actual / plan over time) | ✓ | ✓ | PF: Budget › chart on the right; PJ: Budget plan (selection Gesamt/Material/Personal/…) | Costs over time | View: points per occurrence date, not cumulative; actual = Σ cost occurrences on the date, plan = Σ planned costs on the date (PF: only projects with phase filter „Planung“); PJ categories filter by cost item | € · lines | ||
| Capital employed („Eingesetztes Kapital“, organization) | ✓ | Overview › „Kapital & Rendite“ › header value + bar basis | Total capital budgeted in the organization | Server: Σ of all budget records of the projects with status „Aktiv“ or „Pausiert“ (table budget, not budget goals; archiving changes nothing) |
€ compact · bar 100 %; 0 → „—“ | |||
| Remaining budget after forecast („Rest-Budget nach Forecast“) | ✓ | Portfolio › Budget › tile 4 + list „Rest-Budget (+%)“ | Remaining budget after actual and planned costs | View: cost item budget − (actual costs + planned costs with phase filter „Planung“); % = remaining ÷ budget | € · tile (traffic light < 0 red / = 0 yellow / > 0 green), column | |||
| Strategic budget adherence („Strategische Budgettreue“) | ✓ | Overview › „Kapital & Rendite“ › chip 3 | Ratio of actual costs to the organization’s total budget | Server: Σ cost occurrences ÷ Σ budget records (organization-wide) | Ratio (2 decimals) + traffic light dot (< 0.9 red, ≤ 1.0 yellow, > 1.0 green) | |||
| Cost breakdown („Kostenaufteilung“) | ✓ | Project › Scoreboard › „Finanzen“ | Actual costs by cost item category | View: Σ actual per cost item category; categories with 0 are omitted | Stacked bar + legend (€) | |||
| Cost positions („Kostenpositionen“, actual / budget per cost item) | ✓ | Project › Scoreboard › „Finanzen“ | Actual against budget per cost item | View: actual = Σ cost occurrences of the cost item, budget = budget of the cost item (otherwise 0) | „€ / €“ list; red if actual > budget |
- Three meanings of „Eingesetztes Kapital“ / „Working Capital“: organization = Σ of the budget records of active and paused projects; portfolio = Σ project budget goals (server); program = Σ cost item budgets (view). The portfolio values therefore do not add up to the organization value. The program tooltip says „Σ Budgetziele“, but Σ cost item budgets is what is calculated.
- Two „Budgetabweichungen“: the portfolio tile is Σ (cost item budget − actual) from the view; the text in „Was heute zählt“ and the sorting use the server value budget goal − actual.
- „Prognose Restbudget“ is identical to „Rest-Budget“ (budget − actual). Planned costs do not enter. Only „Rest-Budget nach Forecast“ (Portfolio › Budget) subtracts planned costs.
- „Erwartete Gesamtkosten“ at project level = actual costs only, although the tooltip says „Ist + geplant“. Only aggregates over several projects add the planned costs. Consequence: the sum of the project rows does not match the total row; this also affects expected profit and ROI (Financial performance).
- Phase filter „Planung“ applies in tiles, total and program rows, not in project rows. This is another reason the column sum can differ from the total row.
- „Geplant“ in the budget plan has three readings: tile value = Σ planned; tile percentage = max(0, planned − actual) ÷ budget; table column = max(0, planned − actual) per cost item. The treemap calculates the deviation as budget − (actual + planned), the list as budget − actual.
- Actual costs server versus view: the server sums all cost occurrences of the project, the view only those reachable via a cost item. Cost occurrences without a cost item appear only in the server value.
- Strategic budget adherence: the tooltip describes „über 1 = Budget überschritten“ (above 1 = budget exceeded), the traffic light dot colors > 1.0 green and < 0.9 red. An overrun appears green.
- Budget tile bar (Portfolio › Budget) shows remaining ÷ budget, not the utilization.
- Archiving does not change any server KPI. Only the status decides which projects count: stock KPIs (budgets, capital) count „Aktiv“ (Active) and „Pausiert“ (Paused); fact KPIs (actual costs, revenue, budget deviation) count every non-deleted project, failed and archived ones too. In the view, archived projects are missing only because they are hidden.