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

Weighted cost by country × grade, 2027

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
DEG10432413.30€93,276,657€225,688
DEG5564550.15€29,948,222€54,436
DEG6890873.75€59,758,741€68,393
DEG71,010986.94€87,575,332€88,734
DEG8972962.03€112,970,958€117,429
DEG9702683.35€108,791,755€159,204
ESG109090.60€15,186,576€167,622
ESG5152148.40€5,951,115€40,102
ESG6261258.30€13,181,393€51,031
ESG7276278.00€18,293,419€65,804
ESG8236229.38€20,011,006€87,238
ESG9186181.52€21,508,588€118,494
FRG10176172.61€39,163,356€226,891
FRG5268259.99€14,314,812€55,059
FRG6386380.88€26,314,202€69,087
FRG7474468.05€41,704,053€89,102
FRG8441435.27€51,284,509€117,823
FRG9289280.48€45,036,635€160,568
GBG10137132.47€29,295,677€221,155
GBG5165161.72€8,658,623€53,539
GBG6268266.17€17,774,193€66,778
GBG7307302.43€26,181,363€86,569
GBG8315311.61€35,728,130€114,657
GBG9232227.78€35,283,040€154,897
ING10142136.13€7,418,431€54,494
ING5200199.40€2,622,697€13,153
ING6304300.52€4,932,721€16,414
ING7341335.22€7,188,585€21,445
ING8358353.95€10,079,076€28,476
ING9201195.58€7,516,495€38,433
NLG107573.62€17,231,999€234,077
NLG5101102.08€5,563,512€54,500
NLG6201198.20€14,033,804€70,806
NLG7175172.95€15,931,885€92,118
NLG8167168.33€20,422,953€121,324
NLG9127123.23€20,339,273€165,047
PLG10219211.64€23,819,321€112,546
PLG5298298.48€8,081,185€27,074
PLG6446434.98€14,762,782€33,939
PLG7496489.57€21,613,385€44,148
PLG8482472.22€27,614,350€58,478
PLG9350344.71€27,290,676€79,170
USG10283277.18€72,191,473€260,447
USG5459453.38€28,118,017€62,018
USG6762747.72€58,415,597€78,125
USG7790788.57€80,292,644€101,821
USG8753732.84€98,772,182€134,780
USG9483474.33€86,799,130€182,992
Total17,44217,140.03€1,638,244,526€95,580

Costing coverage, 2027

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

CountryPosition-monthsUncostedCosted
DE54,8330100.0%
ES14,5260100.0%
FR24,4950100.0%
GB17,1970100.0%
IN18,6850100.0%
NL10,2670100.0%
PL27,5960100.0%
US42,5800100.0%
Total210,1790100.0%
Personnel cost by month, 2027Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M€200M27-0127-0227-0327-0427-0527-0627-0727-0827-0927-1027-1127-12
ActualForecast
Headcount by month, 2027Month-end headcount
17,42517,45017,47517,50017,52517,55017,57527-0127-0227-0327-0427-0527-0627-0727-0827-0927-1027-1127-12

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

Headcount

Month by month, 2027

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

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2027-01Forecast17,54517,172.8017,172.80€136,297,728From the position model
2027-02Forecast17,54717,173.4017,173.40€136,175,983From the position model
2027-03Forecast17,55017,175.9017,175.90€136,134,772From the position model
2027-04Forecast17,55217,176.9017,176.90€135,989,533From the position model
2027-05Forecast17,54017,165.1017,165.10€135,741,991From the position model
2027-06Forecast17,53117,156.8017,156.80€135,399,526From the position model
2027-07Forecast17,52217,147.4017,147.40€135,066,977From the position model
2027-08Forecast17,50717,131.7017,131.70€134,644,186From the position model
2027-09Forecast17,50317,127.5017,127.50€134,349,804From the position model
2027-10Forecast17,48417,108.0017,108.00€133,899,115From the position model
2027-11Forecast17,45617,079.7017,079.70€151,362,047From the position model
2027-12Forecast17,44217,065.1017,065.10€133,182,864From the position model

Year-end forecast bridge, 2027

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

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 2027

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

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

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG554,800 EUR—————2027-01
DEAGENCYG666,400 EUR—————2027-01
DEAGENCYG783,700 EUR—————2027-01
DEAPPRENTICEG518,700 EUR—20.0% of base5.0% of base1,200 a year—2027-01
DECONTRACTORG10220,200 EUR—————2027-01
DECONTRACTORG798,200 EUR—————2027-01
DECONTRACTORG8125,300 EUR—————2027-01
DECONTRACTORG9162,600 EUR—————2027-01
DEFIXED_TERMG541,500 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,500 a year2027-01
DEFIXED_TERMG650,300 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,000 a year2027-01
DEFIXED_TERMG763,400 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,800 a year2027-01
DEFIXED_TERMG880,900 EUR12.0% of base20.0% of base5.0% of base2,250 a year4,900 a year2027-01
DEFIXED_TERMG9104,900 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,300 a year2027-01
DEHOURLYG537,400 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,200 a year2027-01
DEHOURLYG645,200 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,700 a year2027-01
DEHOURLYG757,000 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,400 a year2027-01
DEINTERNG512,500 EUR—————2027-01
DEMANAGED_SERVICEG549,800 EUR—————2027-01
DEMANAGED_SERVICEG660,300 EUR—————2027-01
DEMANAGED_SERVICEG776,100 EUR—————2027-01
DEMANAGED_SERVICEG897,000 EUR—————2027-01
DESALARIEDG10142,100 EUR26.0% of base20.0% of base5.0% of base2,950 a year8,500 a year2027-01
DESALARIEDG541,500 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,500 a year2027-01
DESALARIEDG650,300 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,000 a year2027-01
DESALARIEDG763,400 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,800 a year2027-01
DESALARIEDG880,900 EUR12.0% of base20.0% of base5.0% of base2,250 a year4,900 a year2027-01
DESALARIEDG9104,900 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,300 a year2027-01
ESAGENCYG540,600 EUR—————2027-01
ESAGENCYG649,100 EUR—————2027-01
ESAGENCYG761,900 EUR—————2027-01
ESAPPRENTICEG513,800 EUR—30.0% of base2.0% of base900 a year—2027-01
ESCONTRACTORG10162,900 EUR—————2027-01
ESCONTRACTORG772,700 EUR—————2027-01
ESCONTRACTORG892,700 EUR—————2027-01
ESCONTRACTORG9120,300 EUR—————2027-01
ESFIXED_TERMG530,700 EUR3.0% of base30.0% of base2.0% of base900 a year—2027-01
ESFIXED_TERMG637,200 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2027-01
ESFIXED_TERMG746,900 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2027-01
ESFIXED_TERMG859,800 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2027-01
ESFIXED_TERMG977,600 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2027-01
ESHOURLYG527,700 EUR3.0% of base30.0% of base2.0% of base900 a year—2027-01
ESHOURLYG633,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2027-01
ESHOURLYG742,200 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2027-01
ESINTERNG59,200 EUR—————2027-01
ESMANAGED_SERVICEG536,900 EUR—————2027-01
ESMANAGED_SERVICEG644,600 EUR—————2027-01
ESMANAGED_SERVICEG756,300 EUR—————2027-01
ESMANAGED_SERVICEG871,800 EUR—————2027-01
ESSALARIEDG10105,100 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2027-01
ESSALARIEDG530,700 EUR3.0% of base30.0% of base2.0% of base900 a year—2027-01
ESSALARIEDG637,200 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2027-01
ESSALARIEDG746,900 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2027-01
ESSALARIEDG859,800 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2027-01
ESSALARIEDG977,600 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2027-01
FRAGENCYG551,000 EUR—————2027-01
FRAGENCYG661,700 EUR—————2027-01
FRAGENCYG777,800 EUR—————2027-01
FRAPPRENTICEG517,400 EUR—42.0% of base3.0% of base1,100 a year—2027-01
FRCONTRACTORG10204,800 EUR—————2027-01
FRCONTRACTORG791,400 EUR—————2027-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 2027, EUR per 1 unitSTANDARDBUDGETFORECAST
GBP1.17731.17001.1865
INR0.01060.01050.0106
PLN0.23240.23100.2343
USD0.92870.92300.9360

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.