Budget a workforce plan's salary cost
Turn a workforce plan into salary cost by department, month and quarter for a fiscal year, compare it with a draft org chart and download it for finance.
Open a workforce plan and choose Headcount budget. The budget is built from pay, so it appears only for members allowed to see compensation. Anyone else sees no figures at all, not even department totals.
How it's worked out
- Each person on the live org chart costs their pay. Someone with no pay entered costs their role's pay range midpoint.
- Planned hires are each role's target minus its current headcount. They cost the role's pay range midpoint, from the month hiring starts, so a hire starting in the fourth month of the year costs nine months.
- Backfills for expected attrition replace people who leave, so they add no cost.
- Everything is multiplied by the loaded cost: the percentage you set for benefits and taxes on top of pay (25% to start).
- People and planned hires with no pay and no pay range are counted and left out of the totals.
Use it
- Set the loaded cost and the month your fiscal year starts. The fiscal year is named for the year it ends in.
- Set when hiring starts for each role with planned hires.
- Read totals by department, by month and by quarter, and move between fiscal years.
- Compare with a scenario to see the same plan's cost on a draft org chart, by department.
- Download CSV, or Download for Excel (the same file with a marker Excel needs to read accented names). Text that a spreadsheet would treat as a formula is written as plain text.