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

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.

CountryGradeEnding HCAverage FTEPersonnel costCost per FTE
DEG10437424.78€98,647,019€232,229
DEG5568553.40€31,120,116€56,234
DEG6881864.18€60,883,036€70,452
DEG71,020987.88€90,324,427€91,432
DEG8957947.11€114,406,173€120,795
DEG9707687.79€112,656,627€163,795
ESG108988.67€15,317,549€172,754
ESG5152150.23€6,185,687€41,174
ESG6261253.72€13,342,499€52,588
ESG7272267.57€18,120,043€67,722
ESG8239231.50€20,796,454€89,833
ESG9188180.83€22,072,417€122,059
FRG10177172.83€40,401,946€233,762
FRG5265260.65€14,814,967€56,839
FRG6385376.88€26,866,093€71,285
FRG7479468.07€42,925,808€91,709
FRG8437428.03€52,144,009€121,822
FRG9284279.31€46,183,086€165,348
GBG10139134.97€30,028,072€222,485
GBG5160153.83€8,332,150€54,163
GBG6268262.25€17,600,329€67,113
GBG7300298.73€26,010,972€87,071
GBG8314306.27€35,246,900€115,086
GBG9240231.34€36,012,904€155,670
ING10144137.55€7,537,160€54,796
ING5200196.65€2,597,484€13,209
ING6310297.11€4,902,393€16,500
ING7342334.02€7,189,861€21,525
ING8359348.01€9,927,756€28,527
ING9204197.12€7,613,384€38,624
NLG108076.53€18,436,749€240,898
NLG510197.25€5,520,770€56,769
NLG6199196.62€14,347,328€72,971
NLG7180172.75€16,379,384€94,816
NLG8165162.75€20,344,048€125,002
NLG9126123.40€20,990,073€170,098
PLG10224216.68€24,526,935€113,193
PLG5296291.45€7,961,262€27,316
PLG6452440.33€15,010,673€34,089
PLG7500488.62€21,682,340€44,375
PLG8487476.47€27,989,847€58,745
PLG9354343.60€27,344,170€79,581
USG10288279.55€73,140,456€261,636
USG5462452.10€28,253,154€62,493
USG6752737.83€57,885,369€78,453
USG7797777.07€79,408,564€102,190
USG8741731.22€99,157,179€135,606
USG9484470.15€86,297,359€183,553
Total17,46617,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.

CountryPosition-monthsUncostedCosted
DE54,8030100.0%
ES14,3720100.0%
FR24,3640100.0%
GB17,0280100.0%
IN18,5710100.0%
NL10,1530100.0%
PL27,6780100.0%
US42,2580100.0%
Total209,2270100.0%
Personnel cost by month, 2028Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M€200M28-0128-0228-0328-0428-0528-0628-0728-0828-0928-1028-1128-12
ActualForecast
Headcount by month, 2028Month-end headcount
17,40017,42017,44017,46017,48028-0128-0228-0328-0428-0528-0628-0728-0828-0928-1028-1128-12

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

Headcount

Month by month, 2028

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

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2028-01Forecast17,44717,069.7017,069.70€137,005,689From the position model
2028-02Forecast17,44217,064.8017,064.80€136,824,592From the position model
2028-03Forecast17,44517,067.0017,067.00€136,715,779From the position model
2028-04Forecast17,43817,059.1017,059.10€136,647,183From the position model
2028-05Forecast17,42917,049.2017,049.20€136,671,342From the position model
2028-06Forecast17,43217,051.8017,051.80€136,895,767From the position model
2028-07Forecast17,42117,041.1017,041.10€136,937,995From the position model
2028-08Forecast17,41817,037.8017,037.80€137,070,046From the position model
2028-09Forecast17,42017,039.5017,039.50€137,345,687From the position model
2028-10Forecast17,42817,046.6017,046.60€137,686,376From the position model
2028-11Forecast17,44117,058.5017,058.50€156,555,690From the position model
2028-12Forecast17,46617,082.7017,082.70€138,526,834From 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.

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 2028

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

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

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG556,500 EUR—————2028-01
DEAGENCYG668,300 EUR—————2028-01
DEAGENCYG786,200 EUR—————2028-01
DEAPPRENTICEG519,200 EUR—20.0% of base5.0% of base1,200 a year—2028-01
DECONTRACTORG10226,800 EUR—————2028-01
DECONTRACTORG7101,200 EUR—————2028-01
DECONTRACTORG8129,100 EUR—————2028-01
DECONTRACTORG9167,500 EUR—————2028-01
DEFIXED_TERMG542,800 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,600 a year2028-01
DEFIXED_TERMG651,800 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,100 a year2028-01
DEFIXED_TERMG765,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,900 a year2028-01
DEFIXED_TERMG883,300 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,000 a year2028-01
DEFIXED_TERMG9108,000 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,500 a year2028-01
DEHOURLYG538,500 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,300 a year2028-01
DEHOURLYG646,600 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,800 a year2028-01
DEHOURLYG758,800 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,500 a year2028-01
DEINTERNG512,800 EUR—————2028-01
DEMANAGED_SERVICEG551,300 EUR—————2028-01
DEMANAGED_SERVICEG662,100 EUR—————2028-01
DEMANAGED_SERVICEG778,300 EUR—————2028-01
DEMANAGED_SERVICEG899,900 EUR—————2028-01
DESALARIEDG10146,300 EUR26.0% of base20.0% of base5.0% of base2,950 a year8,800 a year2028-01
DESALARIEDG542,800 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,600 a year2028-01
DESALARIEDG651,800 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,100 a year2028-01
DESALARIEDG765,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,900 a year2028-01
DESALARIEDG883,300 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,000 a year2028-01
DESALARIEDG9108,000 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,500 a year2028-01
ESAGENCYG541,800 EUR—————2028-01
ESAGENCYG650,600 EUR—————2028-01
ESAGENCYG763,800 EUR—————2028-01
ESAPPRENTICEG514,200 EUR—30.0% of base2.0% of base900 a year—2028-01
ESCONTRACTORG10167,800 EUR—————2028-01
ESCONTRACTORG774,900 EUR—————2028-01
ESCONTRACTORG895,500 EUR—————2028-01
ESCONTRACTORG9123,900 EUR—————2028-01
ESFIXED_TERMG531,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2028-01
ESFIXED_TERMG638,300 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2028-01
ESFIXED_TERMG748,300 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2028-01
ESFIXED_TERMG861,600 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2028-01
ESFIXED_TERMG980,000 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2028-01
ESHOURLYG528,500 EUR3.0% of base30.0% of base2.0% of base900 a year—2028-01
ESHOURLYG634,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2028-01
ESHOURLYG743,500 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2028-01
ESINTERNG59,500 EUR—————2028-01
ESMANAGED_SERVICEG538,000 EUR—————2028-01
ESMANAGED_SERVICEG646,000 EUR—————2028-01
ESMANAGED_SERVICEG758,000 EUR—————2028-01
ESMANAGED_SERVICEG874,000 EUR—————2028-01
ESSALARIEDG10108,300 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2028-01
ESSALARIEDG531,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2028-01
ESSALARIEDG638,300 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2028-01
ESSALARIEDG748,300 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2028-01
ESSALARIEDG861,600 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2028-01
ESSALARIEDG980,000 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2028-01
FRAGENCYG552,500 EUR—————2028-01
FRAGENCYG663,600 EUR—————2028-01
FRAGENCYG780,100 EUR—————2028-01
FRAPPRENTICEG517,900 EUR—42.0% of base3.0% of base1,100 a year—2028-01
FRCONTRACTORG10210,900 EUR—————2028-01
FRCONTRACTORG794,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 unitSTANDARDBUDGETFORECAST
GBP1.15011.17001.1639
INR0.01030.01050.0104
PLN0.22710.23100.2298
USD0.90730.92300.9182

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.