Personnel cost, weighted grade cost & rolling forecast
Every figure here is calculated from your positions, pay rules and exchange rates, in EUR. Nothing is typed in. Closed months come from actuals; the rest comes from the position model.
Weighted cost by country × grade, 2028
From the position model. Cost per FTE is total cost divided by average FTE for each cell. The total row is recomputed from the summed cost and FTE, never by averaging averages.
| Country | Grade | Ending HC | Average FTE | Personnel cost | Cost per FTE |
|---|---|---|---|---|---|
| DE | G10 | 437 | 424.78 | €98,647,019 | €232,229 |
| DE | G5 | 568 | 553.40 | €31,120,116 | €56,234 |
| DE | G6 | 881 | 864.18 | €60,883,036 | €70,452 |
| DE | G7 | 1,020 | 987.88 | €90,324,427 | €91,432 |
| DE | G8 | 957 | 947.11 | €114,406,173 | €120,795 |
| DE | G9 | 707 | 687.79 | €112,656,627 | €163,795 |
| ES | G10 | 89 | 88.67 | €15,317,549 | €172,754 |
| ES | G5 | 152 | 150.23 | €6,185,687 | €41,174 |
| ES | G6 | 261 | 253.72 | €13,342,499 | €52,588 |
| ES | G7 | 272 | 267.57 | €18,120,043 | €67,722 |
| ES | G8 | 239 | 231.50 | €20,796,454 | €89,833 |
| ES | G9 | 188 | 180.83 | €22,072,417 | €122,059 |
| FR | G10 | 177 | 172.83 | €40,401,946 | €233,762 |
| FR | G5 | 265 | 260.65 | €14,814,967 | €56,839 |
| FR | G6 | 385 | 376.88 | €26,866,093 | €71,285 |
| FR | G7 | 479 | 468.07 | €42,925,808 | €91,709 |
| FR | G8 | 437 | 428.03 | €52,144,009 | €121,822 |
| FR | G9 | 284 | 279.31 | €46,183,086 | €165,348 |
| GB | G10 | 139 | 134.97 | €30,028,072 | €222,485 |
| GB | G5 | 160 | 153.83 | €8,332,150 | €54,163 |
| GB | G6 | 268 | 262.25 | €17,600,329 | €67,113 |
| GB | G7 | 300 | 298.73 | €26,010,972 | €87,071 |
| GB | G8 | 314 | 306.27 | €35,246,900 | €115,086 |
| GB | G9 | 240 | 231.34 | €36,012,904 | €155,670 |
| IN | G10 | 144 | 137.55 | €7,537,160 | €54,796 |
| IN | G5 | 200 | 196.65 | €2,597,484 | €13,209 |
| IN | G6 | 310 | 297.11 | €4,902,393 | €16,500 |
| IN | G7 | 342 | 334.02 | €7,189,861 | €21,525 |
| IN | G8 | 359 | 348.01 | €9,927,756 | €28,527 |
| IN | G9 | 204 | 197.12 | €7,613,384 | €38,624 |
| NL | G10 | 80 | 76.53 | €18,436,749 | €240,898 |
| NL | G5 | 101 | 97.25 | €5,520,770 | €56,769 |
| NL | G6 | 199 | 196.62 | €14,347,328 | €72,971 |
| NL | G7 | 180 | 172.75 | €16,379,384 | €94,816 |
| NL | G8 | 165 | 162.75 | €20,344,048 | €125,002 |
| NL | G9 | 126 | 123.40 | €20,990,073 | €170,098 |
| PL | G10 | 224 | 216.68 | €24,526,935 | €113,193 |
| PL | G5 | 296 | 291.45 | €7,961,262 | €27,316 |
| PL | G6 | 452 | 440.33 | €15,010,673 | €34,089 |
| PL | G7 | 500 | 488.62 | €21,682,340 | €44,375 |
| PL | G8 | 487 | 476.47 | €27,989,847 | €58,745 |
| PL | G9 | 354 | 343.60 | €27,344,170 | €79,581 |
| US | G10 | 288 | 279.55 | €73,140,456 | €261,636 |
| US | G5 | 462 | 452.10 | €28,253,154 | €62,493 |
| US | G6 | 752 | 737.83 | €57,885,369 | €78,453 |
| US | G7 | 797 | 777.07 | €79,408,564 | €102,190 |
| US | G8 | 741 | 731.22 | €99,157,179 | €135,606 |
| US | G9 | 484 | 470.15 | €86,297,359 | €183,553 |
| Total | 17,466 | 17,055.65 | €1,664,882,976 | €97,615 |
Costing coverage, 2028
How much of the plan carries a cost. A position-month is uncosted when no pay rule or exchange rate applies to it. Every position-month in 2028 is costed.
| Country | Position-months | Uncosted | Costed |
|---|---|---|---|
| DE | 54,803 | 0 | 100.0% |
| ES | 14,372 | 0 | 100.0% |
| FR | 24,364 | 0 | 100.0% |
| GB | 17,028 | 0 | 100.0% |
| IN | 18,571 | 0 | 100.0% |
| NL | 10,153 | 0 | 100.0% |
| PL | 27,678 | 0 | 100.0% |
| US | 42,258 | 0 | 100.0% |
| Total | 209,227 | 0 | 100.0% |
The axis does not start at zero, so the differences are easier to see.
Month by month, 2028
Closed months are actuals. Later months are the forecast from the position model.
| Month | State | Head count | People FTE (actual) | Position FTE (plan) | Personnel cost | Source |
|---|---|---|---|---|---|---|
| 2028-01 | Forecast | 17,447 | 17,069.70 | 17,069.70 | €137,005,689 | From the position model |
| 2028-02 | Forecast | 17,442 | 17,064.80 | 17,064.80 | €136,824,592 | From the position model |
| 2028-03 | Forecast | 17,445 | 17,067.00 | 17,067.00 | €136,715,779 | From the position model |
| 2028-04 | Forecast | 17,438 | 17,059.10 | 17,059.10 | €136,647,183 | From the position model |
| 2028-05 | Forecast | 17,429 | 17,049.20 | 17,049.20 | €136,671,342 | From the position model |
| 2028-06 | Forecast | 17,432 | 17,051.80 | 17,051.80 | €136,895,767 | From the position model |
| 2028-07 | Forecast | 17,421 | 17,041.10 | 17,041.10 | €136,937,995 | From the position model |
| 2028-08 | Forecast | 17,418 | 17,037.80 | 17,037.80 | €137,070,046 | From the position model |
| 2028-09 | Forecast | 17,420 | 17,039.50 | 17,039.50 | €137,345,687 | From the position model |
| 2028-10 | Forecast | 17,428 | 17,046.60 | 17,046.60 | €137,686,376 | From the position model |
| 2028-11 | Forecast | 17,441 | 17,058.50 | 17,058.50 | €156,555,690 | From the position model |
| 2028-12 | Forecast | 17,466 | 17,082.70 | 17,082.70 | €138,526,834 | From the position model |
Year-end forecast bridge, 2028
Against Budget. Closed months use actuals, remaining months the forecast.
No comparison for this year.
Personnel-cost bridge · volume, rate and mix
The cost change against Budget is split into volume (FTE) and rate and mix (cost per FTE). Exchange-rate effects sit inside rate and mix. To isolate them, compare two rate sets: choose one in "Exchange rates used for cost" and see the change.
No comparison available.
How each cost component is built
Read from the approved pay rules in force in 2028.
| Component | Used by | Calculation | Monthly treatment |
|---|---|---|---|
| Base pay | 216 rules | Amount | Spread evenly over 12 months |
| Bonus | 112 rules | Percent of base | Spread evenly over 12 months |
| Additional pay | 14 rules | Fixed a year | Phased by month on 14 rules |
| Employer social | 120 rules | Percent of base | Spread evenly over 12 months |
| Pension | 105 rules | Percent of base | Spread evenly over 12 months |
| Fringe and other | 120 rules | Fixed a year | Spread evenly over 12 months |
Cost-assumption rollover into 2028
Average change in base pay per country, for rules that exist in both 2027 and 2028. 4 proposed rules are waiting for approval.
| Country | Rules compared | Average base change | State |
|---|---|---|---|
| DE | 27 | 3.0% | Approved |
| ES | 27 | 3.0% | Approved |
| FR | 27 | 3.0% | Approved |
| GB | 27 | 3.0% | Approved |
| IN | 27 | 3.0% | Approved |
| NL | 27 | 3.0% | Approved |
| PL | 27 | 3.0% | Approved |
| US | 27 | 3.0% | Approved |
Pay-rule registry, 2028
Each cost resolves by country, worker type and grade, with effective dating. Showing the first 60 of 216 rules.
| Country | Worker type | Grade | Base | Bonus | Employer social | Pension | Fringe | Additional pay | Effective from |
|---|---|---|---|---|---|---|---|---|---|
| DE | AGENCY | G5 | 56,500 EUR | — | — | — | — | — | 2028-01 |
| DE | AGENCY | G6 | 68,300 EUR | — | — | — | — | — | 2028-01 |
| DE | AGENCY | G7 | 86,200 EUR | — | — | — | — | — | 2028-01 |
| DE | APPRENTICE | G5 | 19,200 EUR | — | 20.0% of base | 5.0% of base | 1,200 a year | — | 2028-01 |
| DE | CONTRACTOR | G10 | 226,800 EUR | — | — | — | — | — | 2028-01 |
| DE | CONTRACTOR | G7 | 101,200 EUR | — | — | — | — | — | 2028-01 |
| DE | CONTRACTOR | G8 | 129,100 EUR | — | — | — | — | — | 2028-01 |
| DE | CONTRACTOR | G9 | 167,500 EUR | — | — | — | — | — | 2028-01 |
| DE | FIXED_TERM | G5 | 42,800 EUR | 3.0% of base | 20.0% of base | 5.0% of base | 1,200 a year | 2,600 a year | 2028-01 |
| DE | FIXED_TERM | G6 | 51,800 EUR | 5.0% of base | 20.0% of base | 5.0% of base | 1,550 a year | 3,100 a year | 2028-01 |
| DE | FIXED_TERM | G7 | 65,300 EUR | 8.0% of base | 20.0% of base | 5.0% of base | 1,900 a year | 3,900 a year | 2028-01 |
| DE | FIXED_TERM | G8 | 83,300 EUR | 12.0% of base | 20.0% of base | 5.0% of base | 2,250 a year | 5,000 a year | 2028-01 |
| DE | FIXED_TERM | G9 | 108,000 EUR | 18.0% of base | 20.0% of base | 5.0% of base | 2,600 a year | 6,500 a year | 2028-01 |
| DE | HOURLY | G5 | 38,500 EUR | 3.0% of base | 20.0% of base | 5.0% of base | 1,200 a year | 2,300 a year | 2028-01 |
| DE | HOURLY | G6 | 46,600 EUR | 5.0% of base | 20.0% of base | 5.0% of base | 1,550 a year | 2,800 a year | 2028-01 |
| DE | HOURLY | G7 | 58,800 EUR | 8.0% of base | 20.0% of base | 5.0% of base | 1,900 a year | 3,500 a year | 2028-01 |
| DE | INTERN | G5 | 12,800 EUR | — | — | — | — | — | 2028-01 |
| DE | MANAGED_SERVICE | G5 | 51,300 EUR | — | — | — | — | — | 2028-01 |
| DE | MANAGED_SERVICE | G6 | 62,100 EUR | — | — | — | — | — | 2028-01 |
| DE | MANAGED_SERVICE | G7 | 78,300 EUR | — | — | — | — | — | 2028-01 |
| DE | MANAGED_SERVICE | G8 | 99,900 EUR | — | — | — | — | — | 2028-01 |
| DE | SALARIED | G10 | 146,300 EUR | 26.0% of base | 20.0% of base | 5.0% of base | 2,950 a year | 8,800 a year | 2028-01 |
| DE | SALARIED | G5 | 42,800 EUR | 3.0% of base | 20.0% of base | 5.0% of base | 1,200 a year | 2,600 a year | 2028-01 |
| DE | SALARIED | G6 | 51,800 EUR | 5.0% of base | 20.0% of base | 5.0% of base | 1,550 a year | 3,100 a year | 2028-01 |
| DE | SALARIED | G7 | 65,300 EUR | 8.0% of base | 20.0% of base | 5.0% of base | 1,900 a year | 3,900 a year | 2028-01 |
| DE | SALARIED | G8 | 83,300 EUR | 12.0% of base | 20.0% of base | 5.0% of base | 2,250 a year | 5,000 a year | 2028-01 |
| DE | SALARIED | G9 | 108,000 EUR | 18.0% of base | 20.0% of base | 5.0% of base | 2,600 a year | 6,500 a year | 2028-01 |
| ES | AGENCY | G5 | 41,800 EUR | — | — | — | — | — | 2028-01 |
| ES | AGENCY | G6 | 50,600 EUR | — | — | — | — | — | 2028-01 |
| ES | AGENCY | G7 | 63,800 EUR | — | — | — | — | — | 2028-01 |
| ES | APPRENTICE | G5 | 14,200 EUR | — | 30.0% of base | 2.0% of base | 900 a year | — | 2028-01 |
| ES | CONTRACTOR | G10 | 167,800 EUR | — | — | — | — | — | 2028-01 |
| ES | CONTRACTOR | G7 | 74,900 EUR | — | — | — | — | — | 2028-01 |
| ES | CONTRACTOR | G8 | 95,500 EUR | — | — | — | — | — | 2028-01 |
| ES | CONTRACTOR | G9 | 123,900 EUR | — | — | — | — | — | 2028-01 |
| ES | FIXED_TERM | G5 | 31,600 EUR | 3.0% of base | 30.0% of base | 2.0% of base | 900 a year | — | 2028-01 |
| ES | FIXED_TERM | G6 | 38,300 EUR | 5.0% of base | 30.0% of base | 2.0% of base | 1,150 a year | — | 2028-01 |
| ES | FIXED_TERM | G7 | 48,300 EUR | 8.0% of base | 30.0% of base | 2.0% of base | 1,400 a year | — | 2028-01 |
| ES | FIXED_TERM | G8 | 61,600 EUR | 12.0% of base | 30.0% of base | 2.0% of base | 1,650 a year | — | 2028-01 |
| ES | FIXED_TERM | G9 | 80,000 EUR | 18.0% of base | 30.0% of base | 2.0% of base | 1,900 a year | — | 2028-01 |
| ES | HOURLY | G5 | 28,500 EUR | 3.0% of base | 30.0% of base | 2.0% of base | 900 a year | — | 2028-01 |
| ES | HOURLY | G6 | 34,500 EUR | 5.0% of base | 30.0% of base | 2.0% of base | 1,150 a year | — | 2028-01 |
| ES | HOURLY | G7 | 43,500 EUR | 8.0% of base | 30.0% of base | 2.0% of base | 1,400 a year | — | 2028-01 |
| ES | INTERN | G5 | 9,500 EUR | — | — | — | — | — | 2028-01 |
| ES | MANAGED_SERVICE | G5 | 38,000 EUR | — | — | — | — | — | 2028-01 |
| ES | MANAGED_SERVICE | G6 | 46,000 EUR | — | — | — | — | — | 2028-01 |
| ES | MANAGED_SERVICE | G7 | 58,000 EUR | — | — | — | — | — | 2028-01 |
| ES | MANAGED_SERVICE | G8 | 74,000 EUR | — | — | — | — | — | 2028-01 |
| ES | SALARIED | G10 | 108,300 EUR | 26.0% of base | 30.0% of base | 2.0% of base | 2,200 a year | — | 2028-01 |
| ES | SALARIED | G5 | 31,600 EUR | 3.0% of base | 30.0% of base | 2.0% of base | 900 a year | — | 2028-01 |
| ES | SALARIED | G6 | 38,300 EUR | 5.0% of base | 30.0% of base | 2.0% of base | 1,150 a year | — | 2028-01 |
| ES | SALARIED | G7 | 48,300 EUR | 8.0% of base | 30.0% of base | 2.0% of base | 1,400 a year | — | 2028-01 |
| ES | SALARIED | G8 | 61,600 EUR | 12.0% of base | 30.0% of base | 2.0% of base | 1,650 a year | — | 2028-01 |
| ES | SALARIED | G9 | 80,000 EUR | 18.0% of base | 30.0% of base | 2.0% of base | 1,900 a year | — | 2028-01 |
| FR | AGENCY | G5 | 52,500 EUR | — | — | — | — | — | 2028-01 |
| FR | AGENCY | G6 | 63,600 EUR | — | — | — | — | — | 2028-01 |
| FR | AGENCY | G7 | 80,100 EUR | — | — | — | — | — | 2028-01 |
| FR | APPRENTICE | G5 | 17,900 EUR | — | 42.0% of base | 3.0% of base | 1,100 a year | — | 2028-01 |
| FR | CONTRACTOR | G10 | 210,900 EUR | — | — | — | — | — | 2028-01 |
| FR | CONTRACTOR | G7 | 94,100 EUR | — | — | — | — | — | 2028-01 |
Exchange rates used for cost
You hold 3 sets of exchange rates. The set in use converts every pay currency into EUR for the plan and the forecast. Choose another and the cost recalculates. Stored actuals and the budget keep the rates they were closed with.
| Average rate in 2028, EUR per 1 unit | STANDARD | BUDGET | FORECAST |
|---|---|---|---|
| GBP | 1.1501 | 1.1700 | 1.1639 |
| INR | 0.0103 | 0.0105 | 0.0104 |
| PLN | 0.2271 | 0.2310 | 0.2298 |
| USD | 0.9073 | 0.9230 | 0.9182 |
Currency and version controls
| Control | Setting |
|---|---|
| Reporting currency | EUR |
| Exchange-rate set in use | STANDARD (of STANDARD, BUDGET, FORECAST) |
| Actual closed through | 2026-09 |
| Rate GBP to EUR | 84 months, 2025-01 to 2031-12 |
| Rate INR to EUR | 84 months, 2025-01 to 2031-12 |
| Rate PLN to EUR | 84 months, 2025-01 to 2031-12 |
| Rate USD to EUR | 84 months, 2025-01 to 2031-12 |
| Actual | Actual (demo data) · synthetic |
| Budget | Budget 2026 (demo data) · synthetic |
| Target | Target 2026–2028 (demo data) · synthetic |
| Forecast | Closed actuals plus the remaining plan |
| Business plan | Calculated live from the positions |
| Prior BP | Prior BP 2027–2031 (demo data) · synthetic |
Saved views
Keep this view: the year you are looking at.
No saved views yet. Set the filters, version and month you want, then save the view with a name.
Editors and administrators can save views.