Global XYZ Group (demo company)All departments · all countries
Cost & forecast

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.

Forecast cost 2029€1.75BNo stored version covers this year
Average FTE (people)17,102.47Position FTE (seats) 17,102.47
Cost per FTE€102.18KTotal cost ÷ average FTE
Ending head count17,535
Engine issues0Every position can be costed
Pay rules in force2164 proposed, not yet approved

Weighted cost by country × grade, 2029

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.

CountryGradeEnding HCAverage FTEPersonnel costCost per FTE
DEG10439427.43€102,217,091€239,142
DEG5577563.28€32,707,908€58,067
DEG6872852.33€61,816,817€72,527
DEG71,023993.83€93,514,866€94,095
DEG8971946.82€117,789,250€124,404
DEG9722703.06€118,645,150€168,756
ESG108887.33€15,528,417€177,806
ESG5156153.30€6,538,328€42,651
ESG6264257.78€13,968,542€54,187
ESG7277271.17€18,923,383€69,785
ESG8242236.38€21,881,895€92,570
ESG9191184.45€23,177,875€125,659
FRG10175171.25€41,271,727€241,003
FRG5262254.57€14,937,019€58,676
FRG6388377.38€27,746,726€73,524
FRG7477471.27€44,529,255€94,488
FRG8445430.18€54,028,829€125,595
FRG9290278.97€47,497,081€170,261
GBG10139136.47€32,395,528€237,388
GBG5161155.02€8,979,619€57,927
GBG6269263.65€18,891,258€71,653
GBG7298291.10€27,048,368€92,918
GBG8319308.00€37,852,147€122,897
GBG9238232.95€38,678,371€166,037
ING10143136.26€7,962,294€58,435
ING5203199.32€2,807,438€14,085
ING6307296.17€5,208,393€17,586
ING7342334.42€7,677,620€22,958
ING8360350.13€10,627,582€30,353
ING9203198.70€8,177,228€41,154
NLG108078.95€19,584,259€248,059
NLG510399.73€5,874,202€58,899
NLG6202197.70€14,864,848€75,189
NLG7174173.28€16,928,969€97,695
NLG8164160.53€20,695,797€128,919
NLG9126121.90€21,338,196€175,047
PLG10223216.18€26,105,362€120,756
PLG5295289.98€8,452,770€29,150
PLG6459447.08€16,260,646€36,371
PLG7497487.83€23,117,257€47,388
PLG8482471.49€29,543,268€62,659
PLG9352343.63€29,169,388€84,885
USG10286279.30€77,807,924€278,582
USG5467454.87€30,319,456€66,656
USG6756739.97€61,936,784€83,702
USG7790777.08€84,668,561€108,957
USG8750725.04€104,916,759€144,704
USG9488474.93€92,946,643€195,705
Total17,53517,102.47€1,747,557,096€102,182

Costing coverage, 2029

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 2029 is costed.

CountryPosition-monthsUncostedCosted
DE55,0840100.0%
ES14,5970100.0%
FR24,3480100.0%
GB17,0290100.0%
IN18,6450100.0%
NL10,1860100.0%
PL27,6700100.0%
US42,3050100.0%
Total209,8640100.0%
Personnel cost by month, 2029Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M€200M29-0129-0229-0329-0429-0529-0629-0729-0829-0929-1029-1129-12
ActualForecast
Headcount by month, 2029Month-end headcount
17,44017,46017,48017,50017,52017,54029-0129-0229-0329-0429-0529-0629-0729-0829-0929-1029-1129-12

The axis does not start at zero, so the differences are easier to see.

Headcount

Month by month, 2029

Closed months are actuals. Later months are the forecast from the position model.

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2029-01Forecast17,46717,083.1017,083.10€142,943,129From the position model
2029-02Forecast17,45717,073.5017,073.50€143,209,484From the position model
2029-03Forecast17,46517,080.6017,080.60€143,525,563From the position model
2029-04Forecast17,47717,092.2017,092.20€143,885,182From the position model
2029-05Forecast17,47417,088.6017,088.60€144,107,777From the position model
2029-06Forecast17,47417,088.4017,088.40€144,277,354From the position model
2029-07Forecast17,48617,100.8017,100.80€144,392,439From the position model
2029-08Forecast17,49117,104.6017,104.60€144,442,939From the position model
2029-09Forecast17,50017,112.9017,112.90€144,413,198From the position model
2029-10Forecast17,51417,126.1017,126.10€144,463,317From the position model
2029-11Forecast17,52417,134.5017,134.50€163,690,918From the position model
2029-12Forecast17,53517,144.3017,144.30€144,205,795From the position model

Year-end forecast bridge, 2029

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 2029.

ComponentUsed byCalculationMonthly treatment
Base pay216 rulesAmountSpread evenly over 12 months
Bonus112 rulesPercent of baseSpread evenly over 12 months
Additional pay14 rulesFixed a yearPhased by month on 14 rules
Employer social120 rulesPercent of baseSpread evenly over 12 months
Pension105 rulesPercent of baseSpread evenly over 12 months
Fringe and other120 rulesFixed a yearSpread evenly over 12 months

Cost-assumption rollover into 2029

Average change in base pay per country, for rules that exist in both 2028 and 2029. 4 proposed rules are waiting for approval.

CountryRules comparedAverage base changeState
DE273.0%Approved
ES273.0%Approved
FR273.0%Approved
GB273.0%Approved
IN273.0%Approved
NL273.0%Approved
PL273.0%Approved
US273.0%Approved

Pay-rule registry, 2029

Each cost resolves by country, worker type and grade, with effective dating. Showing the first 60 of 216 rules.

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG558,100 EUR—————2029-01
DEAGENCYG670,400 EUR—————2029-01
DEAGENCYG788,800 EUR—————2029-01
DEAPPRENTICEG519,800 EUR—20.0% of base5.0% of base1,200 a year—2029-01
DECONTRACTORG10233,600 EUR—————2029-01
DECONTRACTORG7104,200 EUR—————2029-01
DECONTRACTORG8133,000 EUR—————2029-01
DECONTRACTORG9172,500 EUR—————2029-01
DEFIXED_TERMG544,100 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,600 a year2029-01
DEFIXED_TERMG653,300 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,200 a year2029-01
DEFIXED_TERMG767,200 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,000 a year2029-01
DEFIXED_TERMG885,800 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,100 a year2029-01
DEFIXED_TERMG9111,300 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,700 a year2029-01
DEHOURLYG539,600 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,400 a year2029-01
DEHOURLYG648,000 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,900 a year2029-01
DEHOURLYG760,500 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,600 a year2029-01
DEINTERNG513,200 EUR—————2029-01
DEMANAGED_SERVICEG552,900 EUR—————2029-01
DEMANAGED_SERVICEG664,000 EUR—————2029-01
DEMANAGED_SERVICEG780,700 EUR—————2029-01
DEMANAGED_SERVICEG8102,900 EUR—————2029-01
DESALARIEDG10150,700 EUR26.0% of base20.0% of base5.0% of base2,950 a year9,000 a year2029-01
DESALARIEDG544,100 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,600 a year2029-01
DESALARIEDG653,300 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,200 a year2029-01
DESALARIEDG767,200 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,000 a year2029-01
DESALARIEDG885,800 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,100 a year2029-01
DESALARIEDG9111,300 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,700 a year2029-01
ESAGENCYG543,000 EUR—————2029-01
ESAGENCYG652,100 EUR—————2029-01
ESAGENCYG765,700 EUR—————2029-01
ESAPPRENTICEG514,700 EUR—30.0% of base2.0% of base900 a year—2029-01
ESCONTRACTORG10172,900 EUR—————2029-01
ESCONTRACTORG777,100 EUR—————2029-01
ESCONTRACTORG898,400 EUR—————2029-01
ESCONTRACTORG9127,600 EUR—————2029-01
ESFIXED_TERMG532,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2029-01
ESFIXED_TERMG639,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2029-01
ESFIXED_TERMG749,800 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2029-01
ESFIXED_TERMG863,500 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2029-01
ESFIXED_TERMG982,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2029-01
ESHOURLYG529,300 EUR3.0% of base30.0% of base2.0% of base900 a year—2029-01
ESHOURLYG635,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2029-01
ESHOURLYG744,800 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2029-01
ESINTERNG59,800 EUR—————2029-01
ESMANAGED_SERVICEG539,100 EUR—————2029-01
ESMANAGED_SERVICEG647,400 EUR—————2029-01
ESMANAGED_SERVICEG759,700 EUR—————2029-01
ESMANAGED_SERVICEG876,200 EUR—————2029-01
ESSALARIEDG10111,500 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2029-01
ESSALARIEDG532,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2029-01
ESSALARIEDG639,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2029-01
ESSALARIEDG749,800 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2029-01
ESSALARIEDG863,500 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2029-01
ESSALARIEDG982,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2029-01
FRAGENCYG554,100 EUR—————2029-01
FRAGENCYG665,500 EUR—————2029-01
FRAGENCYG782,500 EUR—————2029-01
FRAPPRENTICEG518,400 EUR—42.0% of base3.0% of base1,100 a year—2029-01
FRCONTRACTORG10217,200 EUR—————2029-01
FRCONTRACTORG796,900 EUR—————2029-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 2029, EUR per 1 unitSTANDARDBUDGETFORECAST
GBP1.19211.17001.2112
INR0.01070.01050.0109
PLN0.23540.23100.2391
USD0.94050.92300.9555

Currency and version controls

ControlSetting
Reporting currencyEUR
Exchange-rate set in useSTANDARD (of STANDARD, BUDGET, FORECAST)
Actual closed through2026-09
Rate GBP to EUR84 months, 2025-01 to 2031-12
Rate INR to EUR84 months, 2025-01 to 2031-12
Rate PLN to EUR84 months, 2025-01 to 2031-12
Rate USD to EUR84 months, 2025-01 to 2031-12
ActualActual (demo data) · synthetic
BudgetBudget 2026 (demo data) · synthetic
TargetTarget 2026–2028 (demo data) · synthetic
ForecastClosed actuals plus the remaining plan
Business planCalculated live from the positions
Prior BPPrior 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.