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 2026€1.47B€(29.4)M · (2.0)% against Budget
Average FTE (people)15,836.66Position FTE (seats) 16,235.43
Cost per FTE€92.94KBudget €92.92K
Ending head count17,5702 against Budget
Engine issues0Every position can be costed
Pay rules in force216All approved

Weighted cost by country × grade, 2026

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
DEG10422392.12€86,009,555€219,347
DEG5556514.70€27,143,201€52,736
DEG6893838.63€55,741,359€66,467
DEG71,026954.14€82,330,518€86,288
DEG8984917.54€104,713,628€114,124
DEG9694636.28€98,579,421€154,930
ESG109187.53€14,253,448€162,835
ESG5152136.98€5,360,255€39,131
ESG6265246.12€12,182,277€49,498
ESG7286272.38€17,386,092€63,829
ESG8233218.36€18,528,996€84,856
ESG9185169.14€19,479,942€115,169
FRG10179160.57€35,400,317€220,471
FRG5264242.46€12,885,748€53,146
FRG6388362.70€24,308,831€67,022
FRG7480449.60€38,856,896€86,425
FRG8450423.47€48,258,525€113,961
FRG9288261.78€40,777,955€155,775
GBG10137125.01€26,904,174€215,219
GBG5170152.68€7,896,798€51,720
GBG6276259.73€16,876,738€64,977
GBG7309293.04€24,726,715€84,380
GBG8320305.45€34,154,731€111,818
GBG9232215.43€32,533,727€151,015
ING10142129.84€6,890,470€53,068
ING5205194.40€2,494,186€12,830
ING6315292.85€4,679,522€15,979
ING7346322.65€6,749,547€20,919
ING8365338.60€9,393,965€27,744
ING9199186.73€6,994,886€37,459
NLG107671.95€16,351,743€227,265
NLG510499.28€5,298,971€53,372
NLG6200185.20€12,716,174€68,662
NLG7173161.83€14,470,215€89,414
NLG8178160.35€18,897,975€117,855
NLG9124116.24€18,631,024€160,278
PLG10217202.28€22,163,418€109,566
PLG5312294.88€7,735,436€26,232
PLG6447419.95€13,878,806€33,049
PLG7504474.55€20,408,543€43,006
PLG8487454.18€25,876,650€56,974
PLG9349323.21€24,934,234€77,146
USG10281257.87€65,371,089€253,507
USG5466433.55€26,047,672€60,080
USG6760720.43€54,832,643€76,111
USG7806758.18€75,256,751€99,259
USG8746695.31€91,409,800€131,467
USG9488456.28€81,366,229€178,324
Total17,57016,386.47€1,518,139,796€92,646

Costing coverage, 2026

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

CountryPosition-monthsUncostedCosted
DE52,1510100.0%
ES13,8450100.0%
FR23,3020100.0%
GB16,5560100.0%
IN17,9740100.0%
NL9,7430100.0%
PL26,5520100.0%
US40,7090100.0%
Total200,8320100.0%
Personnel cost by month, 2026Closed months are actuals, later months the forecast. EUR
€0€50M€100M€150M26-0126-0226-0326-0426-0526-0626-0726-0826-0926-1026-1126-12
ActualForecast
Headcount by month, 2026Month-end headcount
15,50016,00016,50017,00017,50018,00026-0126-0226-0326-0426-0526-0626-0726-0826-0926-1026-1126-12

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

Headcount

Month by month, 2026

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

MonthStateHead countPeople FTE (actual)Position FTE (plan)Personnel costSource
2026-01Actual15,80514,759.0415,266.44€111,824,356Closed, from payroll and HR
2026-02Actual15,98414,925.9515,440.73€113,342,887Closed, from payroll and HR
2026-03Actual16,15115,081.0215,601.08€114,765,204Closed, from payroll and HR
2026-04Actual16,32215,239.5515,766.54€116,159,374Closed, from payroll and HR
2026-05Actual16,54415,453.0715,985.30€118,164,991Closed, from payroll and HR
2026-06Actual16,69815,597.1516,134.67€119,541,760Closed, from payroll and HR
2026-07Actual16,85715,748.2616,291.13€120,908,554Closed, from payroll and HR
2026-08Actual17,02815,907.7516,457.14€122,255,235Closed, from payroll and HR
2026-09Actual17,22716,096.6916,650.79€123,844,517Closed, from payroll and HR
2026-10Forecast17,32916,967.1016,967.10€130,344,030From the position model
2026-11Forecast17,43317,066.1017,066.10€148,205,413From the position model
2026-12Forecast17,57017,198.2017,198.20€132,478,060From the position model

Year-end forecast bridge, 2026

Against Budget. Closed months use actuals, remaining months the forecast.

PeriodBudgetForecastDifference
Closed months 2026-01 to 2026-09 (actuals)€1.09B€1.06B€(33.82)M
Remaining months (forecast)€406.61M€411.03M€4.41M
Full year 2026€1.5B€1.47B€(29.4)M

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.

DriverImpact
Volume: more or fewer FTE at Budget cost per FTE€(29.64)M
Rate and mix: cost per FTE, including grade, country and exchange-rate effects€236.56K
Total change against Budget€(29.4)M

Largest departmental changes against Budget

Volume against rate and mixCost change against Budget by department, EUR. Together they equal the total change.
€(20)M€(15)M€(10)M€(5)M€0€5MOperationsFinanceCustomer ServiceHuman ResourcesSupply Chain & …SalesResearch & Deve…Information Tec…
VolumeRate and mix
DepartmentVolumeRate and mixTotal
Operations€(17.73)M€(46.99)K€(17.78)M
Finance€(4.28)M€(57.95)K€(4.34)M
Customer Service€(3.78)M€(37.55)K€(3.82)M
Human Resources€(2.59)M€(75.29)K€(2.67)M
Supply Chain & Logistics€(3.06)M€602.28K€(2.46)M
Sales€2.31M€(342.62)K€1.97M
Research & Development€1.54M€(255.38)K€1.29M
Information Technology€(565.81)K€(324.69)K€(890.5)K
Marketing€(975.38)K€149.18K€(826.2)K
Legal & Compliance€232.45K€(105.32)K€127.12K

How each cost component is built

Read from the approved pay rules in force in 2026.

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 2026

Average change in base pay per country, for rules that exist in both 2025 and 2026.

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

Pay-rule registry, 2026

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

CountryWorker typeGradeBaseBonusEmployer socialPensionFringeAdditional payEffective from
DEAGENCYG553,200 EUR—————2026-01
DEAGENCYG664,400 EUR—————2026-01
DEAGENCYG781,200 EUR—————2026-01
DEAPPRENTICEG518,100 EUR—20.0% of base5.0% of base1,200 a year—2026-01
DECONTRACTORG10213,800 EUR—————2026-01
DECONTRACTORG795,400 EUR—————2026-01
DECONTRACTORG8121,700 EUR—————2026-01
DECONTRACTORG9157,900 EUR—————2026-01
DEFIXED_TERMG540,300 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,400 a year2026-01
DEFIXED_TERMG648,800 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,900 a year2026-01
DEFIXED_TERMG761,500 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,700 a year2026-01
DEFIXED_TERMG878,500 EUR12.0% of base20.0% of base5.0% of base2,250 a year4,700 a year2026-01
DEFIXED_TERMG9101,800 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,100 a year2026-01
DEHOURLYG536,300 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,200 a year2026-01
DEHOURLYG643,900 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,600 a year2026-01
DEHOURLYG755,400 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,300 a year2026-01
DEINTERNG512,100 EUR—————2026-01
DEMANAGED_SERVICEG548,400 EUR—————2026-01
DEMANAGED_SERVICEG658,600 EUR—————2026-01
DEMANAGED_SERVICEG773,800 EUR—————2026-01
DEMANAGED_SERVICEG894,200 EUR—————2026-01
DESALARIEDG10137,900 EUR26.0% of base20.0% of base5.0% of base2,950 a year8,300 a year2026-01
DESALARIEDG540,300 EUR3.0% of base20.0% of base5.0% of base1,200 a year2,400 a year2026-01
DESALARIEDG648,800 EUR5.0% of base20.0% of base5.0% of base1,550 a year2,900 a year2026-01
DESALARIEDG761,500 EUR8.0% of base20.0% of base5.0% of base1,900 a year3,700 a year2026-01
DESALARIEDG878,500 EUR12.0% of base20.0% of base5.0% of base2,250 a year4,700 a year2026-01
DESALARIEDG9101,800 EUR18.0% of base20.0% of base5.0% of base2,600 a year6,100 a year2026-01
ESAGENCYG539,400 EUR—————2026-01
ESAGENCYG647,700 EUR—————2026-01
ESAGENCYG760,100 EUR—————2026-01
ESAPPRENTICEG513,400 EUR—30.0% of base2.0% of base900 a year—2026-01
ESCONTRACTORG10158,200 EUR—————2026-01
ESCONTRACTORG770,600 EUR—————2026-01
ESCONTRACTORG890,000 EUR—————2026-01
ESCONTRACTORG9116,800 EUR—————2026-01
ESFIXED_TERMG529,800 EUR3.0% of base30.0% of base2.0% of base900 a year—2026-01
ESFIXED_TERMG636,100 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2026-01
ESFIXED_TERMG745,500 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2026-01
ESFIXED_TERMG858,100 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2026-01
ESFIXED_TERMG975,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2026-01
ESHOURLYG526,800 EUR3.0% of base30.0% of base2.0% of base900 a year—2026-01
ESHOURLYG632,500 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2026-01
ESHOURLYG741,000 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2026-01
ESINTERNG58,900 EUR—————2026-01
ESMANAGED_SERVICEG535,800 EUR—————2026-01
ESMANAGED_SERVICEG643,300 EUR—————2026-01
ESMANAGED_SERVICEG754,600 EUR—————2026-01
ESMANAGED_SERVICEG869,700 EUR—————2026-01
ESSALARIEDG10102,100 EUR26.0% of base30.0% of base2.0% of base2,200 a year—2026-01
ESSALARIEDG529,800 EUR3.0% of base30.0% of base2.0% of base900 a year—2026-01
ESSALARIEDG636,100 EUR5.0% of base30.0% of base2.0% of base1,150 a year—2026-01
ESSALARIEDG745,500 EUR8.0% of base30.0% of base2.0% of base1,400 a year—2026-01
ESSALARIEDG858,100 EUR12.0% of base30.0% of base2.0% of base1,650 a year—2026-01
ESSALARIEDG975,400 EUR18.0% of base30.0% of base2.0% of base1,900 a year—2026-01
FRAGENCYG549,500 EUR—————2026-01
FRAGENCYG659,900 EUR—————2026-01
FRAGENCYG775,500 EUR—————2026-01
FRAPPRENTICEG516,900 EUR—42.0% of base3.0% of base1,100 a year—2026-01
FRCONTRACTORG10198,800 EUR—————2026-01
FRCONTRACTORG788,700 EUR—————2026-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 2026, EUR per 1 unitSTANDARDBUDGETFORECAST
GBP1.17921.17001.1840
INR0.01060.01050.0106
PLN0.23280.23100.2338
USD0.93030.92300.9341

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.