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 2031€1.85BNo stored version covers this year
Average FTE (people)17,195.08Position FTE (seats) 17,195.08
Cost per FTE€107.37KTotal cost ÷ average FTE
Ending head count17,467
Engine issues0Every position can be costed
Pay rules in force2164 proposed, not yet approved

Weighted cost by country × grade, 2031

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
DEG10438431.02€109,283,828€253,549
DEG5576567.25€34,947,579€61,609
DEG6886870.82€67,048,122€76,995
DEG71,0251,004.91€100,263,840€99,774
DEG8982970.83€127,985,447€131,831
DEG9723711.67€127,236,457€178,787
ESG108887.27€16,451,922€188,525
ESG5156153.87€7,005,326€45,529
ESG6260254.87€14,638,360€57,435
ESG7279275.30€20,360,484€73,957
ESG8244238.75€23,440,147€98,179
ESG9189185.92€24,760,517€133,181
FRG10172168.28€43,041,144€255,766
FRG5264257.73€16,087,258€62,418
FRG6384379.67€29,625,006€78,029
FRG7471465.13€46,704,637€100,411
FRG8443436.73€58,155,400€133,160
FRG9291285.47€51,537,853€180,539
GBG10137134.62€33,118,694€246,022
GBG5160155.43€9,325,022€59,994
GBG6273268.07€19,920,694€74,312
GBG7297292.85€28,200,036€96,295
GBG8313306.98€39,095,792€127,355
GBG9241238.28€41,023,809€172,164
ING10137133.58€8,092,284€60,579
ING5201199.22€2,912,025€14,617
ING6304297.30€5,419,037€18,228
ING7342336.37€8,006,190€23,802
ING8350345.62€10,873,550€31,461
ING9206202.12€8,623,660€42,667
NLG108180.37€21,145,290€263,110
NLG5103102.22€6,425,117€62,858
NLG6202200.95€16,015,209€79,697
NLG7173170.36€17,617,082€103,412
NLG8165162.32€22,191,054€136,715
NLG9124123.45€22,899,313€185,495
PLG10222217.57€27,248,986€125,244
PLG5287283.52€8,568,192€30,221
PLG6464457.13€17,256,610€37,750
PLG7490484.68€23,823,236€49,152
PLG8478468.37€30,459,892€65,034
PLG9354346.47€30,503,263€88,041
USG10285281.14€81,193,750€288,800
USG5466459.52€31,729,214€69,049
USG6733727.71€63,142,450€86,769
USG7773763.52€86,309,290€113,042
USG8750734.30€110,023,079€149,834
USG9485475.60€96,457,419€202,812
Total17,46717,195.08€1,846,192,565€107,367

Costing coverage, 2031

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

CountryPosition-monthsUncostedCosted
DE55,9450100.0%
ES14,6680100.0%
FR24,4550100.0%
GB17,1380100.0%
IN18,6280100.0%
NL10,2830100.0%
PL27,6950100.0%
US42,2080100.0%
Total211,0200100.0%
Personnel cost by month, 2031Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M€200M31-0131-0231-0331-0431-0531-0631-0731-0831-0931-1031-1131-12
ActualForecast
Headcount by month, 2031Month-end headcount
17,40017,50017,60017,70017,80031-0131-0231-0331-0431-0531-0631-0731-0831-0931-1031-1131-12

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

Headcount

Month by month, 2031

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

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2031-01Forecast17,71017,316.6017,316.60€151,757,025From the position model
2031-02Forecast17,68417,291.0017,291.00€151,681,707From the position model
2031-03Forecast17,66617,273.7017,273.70€151,734,623From the position model
2031-04Forecast17,64617,254.5017,254.50€151,797,179From the position model
2031-05Forecast17,62417,232.7017,232.70€151,911,513From the position model
2031-06Forecast17,59517,204.8017,204.80€151,974,898From the position model
2031-07Forecast17,57017,180.6017,180.60€152,086,166From the position model
2031-08Forecast17,54117,152.5017,152.50€152,224,936From the position model
2031-09Forecast17,52517,136.5017,136.50€152,401,155From the position model
2031-10Forecast17,50817,120.4017,120.40€152,525,213From the position model
2031-11Forecast17,48417,096.9017,096.90€173,478,669From the position model
2031-12Forecast17,46717,080.8017,080.80€152,619,477From the position model

Year-end forecast bridge, 2031

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

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 2031

Average change in base pay per country, for rules that exist in both 2030 and 2031. 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, 2031

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

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG561,700 EUR—————2031-01
DEAGENCYG674,700 EUR—————2031-01
DEAGENCYG794,200 EUR—————2031-01
DEAPPRENTICEG521,000 EUR—20.0% of base5.0% of base1,200 a year—2031-01
DECONTRACTORG10247,800 EUR—————2031-01
DECONTRACTORG7110,600 EUR—————2031-01
DECONTRACTORG8141,100 EUR—————2031-01
DECONTRACTORG9183,000 EUR—————2031-01
DEFIXED_TERMG546,700 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,800 a year2031-01
DEFIXED_TERMG656,600 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,400 a year2031-01
DEFIXED_TERMG771,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,300 a year2031-01
DEFIXED_TERMG891,000 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,500 a year2031-01
DEFIXED_TERMG9118,100 EUR18.0% of base20.0% of base5.0% of base2,600 a year7,100 a year2031-01
DEHOURLYG542,100 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,500 a year2031-01
DEHOURLYG650,900 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,100 a year2031-01
DEHOURLYG764,200 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,900 a year2031-01
DEINTERNG514,000 EUR—————2031-01
DEMANAGED_SERVICEG556,100 EUR—————2031-01
DEMANAGED_SERVICEG667,900 EUR—————2031-01
DEMANAGED_SERVICEG785,600 EUR—————2031-01
DEMANAGED_SERVICEG8109,200 EUR—————2031-01
DESALARIEDG10159,900 EUR26.0% of base20.0% of base5.0% of base2,950 a year9,600 a year2031-01
DESALARIEDG546,700 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,800 a year2031-01
DESALARIEDG656,600 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,400 a year2031-01
DESALARIEDG771,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,300 a year2031-01
DESALARIEDG891,000 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,500 a year2031-01
DESALARIEDG9118,100 EUR18.0% of base20.0% of base5.0% of base2,600 a year7,100 a year2031-01
ESAGENCYG545,700 EUR—————2031-01
ESAGENCYG655,300 EUR—————2031-01
ESAGENCYG769,700 EUR—————2031-01
ESAPPRENTICEG515,600 EUR—30.0% of base2.0% of base900 a year—2031-01
ESCONTRACTORG10183,400 EUR—————2031-01
ESCONTRACTORG781,800 EUR—————2031-01
ESCONTRACTORG8104,400 EUR—————2031-01
ESCONTRACTORG9135,400 EUR—————2031-01
ESFIXED_TERMG534,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2031-01
ESFIXED_TERMG641,900 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2031-01
ESFIXED_TERMG752,800 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2031-01
ESFIXED_TERMG867,300 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2031-01
ESFIXED_TERMG987,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2031-01
ESHOURLYG531,100 EUR3.0% of base30.0% of base2.0% of base900 a year—2031-01
ESHOURLYG637,700 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2031-01
ESHOURLYG747,500 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2031-01
ESINTERNG510,400 EUR—————2031-01
ESMANAGED_SERVICEG541,500 EUR—————2031-01
ESMANAGED_SERVICEG650,200 EUR—————2031-01
ESMANAGED_SERVICEG763,300 EUR—————2031-01
ESMANAGED_SERVICEG880,800 EUR—————2031-01
ESSALARIEDG10118,300 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2031-01
ESSALARIEDG534,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2031-01
ESSALARIEDG641,900 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2031-01
ESSALARIEDG752,800 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2031-01
ESSALARIEDG867,300 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2031-01
ESSALARIEDG987,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2031-01
FRAGENCYG557,400 EUR—————2031-01
FRAGENCYG669,500 EUR—————2031-01
FRAGENCYG787,600 EUR—————2031-01
FRAPPRENTICEG519,600 EUR—42.0% of base3.0% of base1,100 a year—2031-01
FRCONTRACTORG10230,500 EUR—————2031-01
FRCONTRACTORG7102,800 EUR—————2031-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 2031, EUR per 1 unitSTANDARDBUDGETFORECAST
GBP1.16661.17001.1947
INR0.01050.01050.0107
PLN0.23030.23100.2359
USD0.92030.92300.9425

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.