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

Weighted cost by country × grade, 2030

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
DEG10447430.43€106,017,259€246,304
DEG5581566.67€33,924,105€59,866
DEG6898867.73€64,867,658€74,755
DEG71,0431,006.35€97,666,601€97,050
DEG8995964.87€123,667,748€128,171
DEG9736713.52€123,932,835€173,693
ESG109189.37€16,368,732€183,164
ESG5157153.87€6,794,363€44,157
ESG6262257.15€14,324,551€55,705
ESG7282273.63€19,632,197€71,746
ESG8247237.67€22,666,170€95,370
ESG9195186.78€24,147,328€129,280
FRG10175169.94€42,214,399€248,405
FRG5265257.25€15,569,524€60,523
FRG6391381.55€28,919,890€75,796
FRG7476466.97€45,509,123€97,457
FRG8452434.78€56,237,936€129,347
FRG9294284.84€49,936,062€175,312
GBG10139135.63€32,167,836€237,168
GBG5163156.68€9,056,072€57,799
GBG6275266.57€19,064,824€71,520
GBG7300294.06€27,291,158€92,809
GBG8317309.07€37,912,473€122,668
GBG9245237.88€39,480,555€165,966
ING10142135.13€7,892,544€58,406
ING5203200.80€2,828,194€14,085
ING6311299.97€5,268,125€17,562
ING7347340.10€7,800,320€22,935
ING8358349.18€10,586,204€30,317
ING9209201.03€8,265,843€41,117
NLG108380.53€20,577,500€255,515
NLG5104102.30€6,238,236€60,980
NLG6206199.95€15,480,383€77,421
NLG7174169.73€17,058,469€100,502
NLG8168162.17€21,540,830€132,831
NLG9129125.78€22,662,941€180,174
PLG10225217.90€26,292,097€120,661
PLG5293288.43€8,398,646€29,118
PLG6470456.93€16,614,949€36,362
PLG7498486.93€23,055,094€47,348
PLG8481471.53€29,543,377€62,654
PLG9358347.43€29,466,587€84,812
USG10292283.27€78,840,936€278,328
USG5471461.47€30,711,668€66,552
USG6752739.18€61,816,768€83,628
USG7786769.19€83,763,650€108,898
USG8760738.11€106,580,585€144,397
USG9488476.84€93,261,840€195,582
Total17,73417,247.17€1,791,915,189€103,896

Costing coverage, 2030

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

CountryPosition-monthsUncostedCosted
DE55,8700100.0%
ES14,7030100.0%
FR24,4870100.0%
GB17,1860100.0%
IN18,7810100.0%
NL10,2900100.0%
PL27,8360100.0%
US42,5270100.0%
Total211,6800100.0%
Personnel cost by month, 2030Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M€200M30-0130-0230-0330-0430-0530-0630-0730-0830-0930-1030-1130-12
ActualForecast
Headcount by month, 2030Month-end headcount
17,50017,55017,60017,65017,70017,75030-0130-0230-0330-0430-0530-0630-0730-0830-0930-1030-1130-12

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

Headcount

Month by month, 2030

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

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2030-01Forecast17,54217,151.6017,151.60€148,266,536From the position model
2030-02Forecast17,55617,164.7017,164.70€148,064,860From the position model
2030-03Forecast17,57717,184.7017,184.70€147,949,679From the position model
2030-04Forecast17,59417,201.3017,201.30€147,795,256From the position model
2030-05Forecast17,61117,218.1017,218.10€147,589,606From the position model
2030-06Forecast17,61817,224.6017,224.60€147,362,793From the position model
2030-07Forecast17,64417,250.8017,250.80€147,361,699From the position model
2030-08Forecast17,66917,275.8017,275.80€147,292,435From the position model
2030-09Forecast17,68917,295.6017,295.60€147,276,817From the position model
2030-10Forecast17,71617,322.6017,322.60€147,360,036From the position model
2030-11Forecast17,73017,336.0017,336.00€168,042,745From the position model
2030-12Forecast17,73417,340.2017,340.20€147,552,734From the position model

Year-end forecast bridge, 2030

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

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 2030

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

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

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG559,900 EUR—————2030-01
DEAGENCYG672,500 EUR—————2030-01
DEAGENCYG791,400 EUR—————2030-01
DEAPPRENTICEG520,400 EUR—20.0% of base5.0% of base1,200 a year—2030-01
DECONTRACTORG10240,600 EUR—————2030-01
DECONTRACTORG7107,300 EUR—————2030-01
DECONTRACTORG8137,000 EUR—————2030-01
DECONTRACTORG9177,700 EUR—————2030-01
DEFIXED_TERMG545,400 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,700 a year2030-01
DEFIXED_TERMG654,900 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,300 a year2030-01
DEFIXED_TERMG769,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,200 a year2030-01
DEFIXED_TERMG888,400 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,300 a year2030-01
DEFIXED_TERMG9114,600 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,900 a year2030-01
DEHOURLYG540,800 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,400 a year2030-01
DEHOURLYG649,400 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,000 a year2030-01
DEHOURLYG762,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,700 a year2030-01
DEINTERNG513,600 EUR—————2030-01
DEMANAGED_SERVICEG554,400 EUR—————2030-01
DEMANAGED_SERVICEG665,900 EUR—————2030-01
DEMANAGED_SERVICEG783,100 EUR—————2030-01
DEMANAGED_SERVICEG8106,000 EUR—————2030-01
DESALARIEDG10155,200 EUR26.0% of base20.0% of base5.0% of base2,950 a year9,300 a year2030-01
DESALARIEDG545,400 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,700 a year2030-01
DESALARIEDG654,900 EUR5.0% of base20.0% of base5.0% of base1,550 a year3,300 a year2030-01
DESALARIEDG769,300 EUR8.0% of base20.0% of base5.0% of base1,900 a year4,200 a year2030-01
DESALARIEDG888,400 EUR12.0% of base20.0% of base5.0% of base2,250 a year5,300 a year2030-01
DESALARIEDG9114,600 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,900 a year2030-01
ESAGENCYG544,300 EUR—————2030-01
ESAGENCYG653,700 EUR—————2030-01
ESAGENCYG767,600 EUR—————2030-01
ESAPPRENTICEG515,100 EUR—30.0% of base2.0% of base900 a year—2030-01
ESCONTRACTORG10178,000 EUR—————2030-01
ESCONTRACTORG779,400 EUR—————2030-01
ESCONTRACTORG8101,300 EUR—————2030-01
ESCONTRACTORG9131,500 EUR—————2030-01
ESFIXED_TERMG533,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2030-01
ESFIXED_TERMG640,600 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2030-01
ESFIXED_TERMG751,200 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2030-01
ESFIXED_TERMG865,400 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2030-01
ESFIXED_TERMG984,800 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2030-01
ESHOURLYG530,200 EUR3.0% of base30.0% of base2.0% of base900 a year—2030-01
ESHOURLYG636,600 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2030-01
ESHOURLYG746,100 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2030-01
ESINTERNG510,100 EUR—————2030-01
ESMANAGED_SERVICEG540,300 EUR—————2030-01
ESMANAGED_SERVICEG648,800 EUR—————2030-01
ESMANAGED_SERVICEG761,500 EUR—————2030-01
ESMANAGED_SERVICEG878,500 EUR—————2030-01
ESSALARIEDG10114,900 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2030-01
ESSALARIEDG533,600 EUR3.0% of base30.0% of base2.0% of base900 a year—2030-01
ESSALARIEDG640,600 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2030-01
ESSALARIEDG751,200 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2030-01
ESSALARIEDG865,400 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2030-01
ESSALARIEDG984,800 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2030-01
FRAGENCYG555,700 EUR—————2030-01
FRAGENCYG667,400 EUR—————2030-01
FRAGENCYG785,000 EUR—————2030-01
FRAPPRENTICEG519,000 EUR—42.0% of base3.0% of base1,100 a year—2030-01
FRCONTRACTORG10223,800 EUR—————2030-01
FRCONTRACTORG799,800 EUR—————2030-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 2030, EUR per 1 unitSTANDARDBUDGETFORECAST
GBP1.15731.17001.1803
INR0.01040.01050.0106
PLN0.22850.23100.2330
USD0.91300.92300.9311

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.