# Hiring Dashboard

Connect department hiring plans and attrition to ending headcount, fully-loaded compensation, sales productivity, revenue capacity, and year-one efficiency outputs across five operating departments for budget planning.

- Canonical: https://finamodel.com/excel-dashboard/hiring-model
- Excel download: https://finamodel.com/templates/hiring-model.xlsx

## About this dashboard

The Hiring Dashboard brings the people plan into one 12-month view across Engineering, Sales, Marketing, G&A, and Customer Success. It summarizes starting and ending headcount, net change, year-one hires and attrition, year-one compensation, average annual fully-loaded compensation per head, peak productive Sales headcount, year-one revenue capacity, and the Sales comp to revenue-capacity ratio.

The supporting workbook holds starting headcount, monthly hires, annual base salary, benefits load, monthly attrition, annual sales quota, and a productivity factor. Hires calculates new hires, attrition, and ending headcount. Compensation calculates monthly fully-loaded expense and cumulative cost; Productivity converts productive Sales headcount into monthly and cumulative revenue capacity.

Use the dashboard to review affordability, department mix, workforce growth, and the relationship between Sales investment and modeled revenue capacity. The outputs connect a hiring plan to budget discussions and operating forecasts. Productivity uses the selected factor applied to ending Sales headcount, while compensation reflects ending headcount and loaded salary assumptions.

## What's included

- Starting and ending headcount by department
- Year-one hires and attrition
- Year-one fully-loaded compensation
- Average loaded compensation per head
- Peak productive Sales headcount
- Sales comp to revenue-capacity ratio

## Frequently asked questions

### What does the Hiring Dashboard summarize?

It summarizes starting and ending headcount, net change, year-one hires and attrition, year-one fully-loaded compensation, average loaded compensation per head, peak productive Sales headcount, year-one revenue capacity, and the Sales comp to revenue-capacity ratio.

### Which departments are included?

The dashboard covers Engineering, Sales, Marketing, G&A, and Customer Success. Each department has starting headcount, a monthly hiring plan, salary, benefits load, and attrition assumptions feeding headcount and compensation outputs.

### How is fully-loaded compensation calculated?

Monthly compensation uses ending headcount, annual base salary, and the selected benefits load, divided across the year. The Compensation sheet also provides a total across departments and a cumulative running cost for the 12-month period.

### How does Sales productivity work?

Productive Sales headcount equals ending Sales headcount multiplied by the selected productivity factor. Monthly revenue capacity then applies the annual sales quota across the year, with cumulative capacity available for the year-one summary.

### Can this replace a full operating forecast?

It is a people-cost and Sales-capacity view. Use its headcount, compensation, and revenue-capacity outputs as inputs to a broader budget, cash flow, or three-statement forecast when you need the full operating picture.

## Related dashboards

- [Payroll Forecast Dashboard](https://finamodel.com/excel-dashboard/payroll-forecast)
- [Inventory Forecast Dashboard](https://finamodel.com/excel-dashboard/inventory-forecast)
- [Project Finance Debt Sculpting Dashboard](https://finamodel.com/excel-dashboard/project-finance-sculpting)
- [Marketing Agency Dashboard](https://finamodel.com/excel-dashboard/marketing-agency)