Personnel cost forecast with scenario switches

Name: Personnel cost forecast with scenario switches
Description: A driver-based bottom-up model: base pay, collective agreement increases, vacancy timing, employer contributions and provisions — with three scenarios on one switch.

A driver-based bottom-up model: base pay, collective agreement increases, vacancy timing, employer contributions and provisions — with three scenarios on one switch.

Excel (advanced)13 Personnel cost planning and scenariosExpert38 min

The recording for this walkthrough is being published — the files below already contain the full model.

What you will build

01Separate inputs, logic and output the way controllers audit it
02Time-phase vacancies and planned hires by month
03Bridge plan vs. actual with a variance waterfall

Dataset used

Cost-centre level salary bands, employer contribution rates and a hiring plan.