Employee Vacancy Rate Calculator & Formula

This calculator works out your employee vacancy rate: the percentage of budgeted or funded positions that are currently unfilled. You enter the number of open positions and the total number of budgeted positions (occupied plus open), and you get the vacancy rate as a percentage, along with the number of filled positions. The result helps HR teams and managers gauge staffing gaps and plan recruitment.

Formula

The vacancy rate is the number of open positions divided by the total number of budgeted (or authorized) positions, multiplied by 100 to get a percentage.

Vacancy Rate (%) = (Open Positions ÷ Total Budgeted Positions) × 100

Where:

• Open Positions – positions that are currently unfilled and actively budgeted (counted in the total).
• Total Budgeted Positions – the sum of filled and open positions that your organization has funding or approval for.

For example, if you have 5 open positions out of 100 total budgeted positions, the vacancy rate is (5 ÷ 100) × 100 = 5%.

Worked Example

Using the default values from the calculator (5 open positions, 100 total budgeted positions):

1. Divide open positions by total positions: 5 ÷ 100 = 0.05
2. Multiply by 100 to get the percentage: 0.05 × 100 = 5%
3. The calculator also shows filled positions: 100 – 5 = 95

So the vacancy rate is 5%, and there are 95 filled positions. This matches the calculator’s output.

Why the Vacancy Rate Matters

The vacancy rate is a key HR metric. It tells you how much of your approved workforce is actually in place. A low rate (under 5%) often indicates a stable workforce, while a high rate (above 10-15%) can signal recruitment difficulties, high turnover, or budget constraints that leave positions unfilled.

Organizations use this metric to:

• Plan recruitment and hiring budgets.
• Identify departments or roles with chronic staffing gaps.
• Benchmark against industry averages (though these vary widely by sector and region).
• Assess the impact of turnover on productivity and workload.

It’s important to note that the vacancy rate is a snapshot. It changes daily as people are hired, leave, or as positions are added or removed from the budget.

How to Use the Vacancy Rate Calculator

To get an accurate result, you need two numbers:

1. Open positions – count every unfilled position that is currently funded or budgeted. This includes roles that are vacant due to resignation, termination, new headcount approval, or parental leave (if the position is still budgeted). Do not include positions that have been eliminated or frozen unless they are still in the budget.
2. Total budgeted positions – the total number of positions your organization has approved, whether filled or open. This is often found in your HR system or budget documents.

Enter both numbers, and the calculator gives you the vacancy rate and the number of filled positions. You can also use it in reverse: if you know the vacancy rate and total positions, you can solve for open positions.

Common Mistakes and How to Avoid Them

One frequent error is mixing up “open” and “unfilled” positions. For example, a position that is temporarily covered by a contractor or overtime is still open in the budget. Another mistake is using the number of employees on payroll instead of the number of budgeted positions. If you have 100 employees but 110 budgeted positions, the vacancy rate is 10/110 = 9.09%, not 0%.

Also, be consistent with the time period. If you are measuring monthly, use the number of open positions at the end of the month. If you are measuring quarterly, use the average or the end-of-quarter count. Mixing time periods can make the rate misleading.

Rounding can also cause small discrepancies. The calculator rounds to two decimal places, but if you are comparing to a report that rounds to whole numbers, you may see a 0.01% difference.

Limitations of the Vacancy Rate

The vacancy rate is a simple ratio, but it has limitations. It does not tell you:

• How long a position has been vacant – a 5% rate could mean one position open for a year or five positions open for a month.
• The difficulty of filling the role – a vacant software engineer is not the same as a vacant retail associate.
• The impact on productivity – some vacancies cause more disruption than others.
• Whether the budgeted number is appropriate – the rate is only as good as the budget behind it.

For a deeper analysis, combine the vacancy rate with other metrics like time-to-fill, cost-per-hire, and turnover rate.

Vacancy Rate vs. Turnover Rate

People often confuse vacancy rate with turnover rate, but they measure different things.

Turnover rate is the percentage of employees who leave the organization over a period (usually a year). It is calculated as (number of separations ÷ average number of employees) × 100. Turnover is a flow: it measures movement out of the organization.

Vacancy rate is a stock: it measures how many positions are empty at a point in time. High turnover can lead to high vacancy, but not always. If you hire quickly, turnover can be high while vacancy stays low. Conversely, you can have low turnover but high vacancy if you are not hiring for open roles.

Frequently Asked Questions

What is a good vacancy rate?

There is no universal “good” rate. It varies by industry and region. In general, a rate below 5% is considered healthy, while 10% or higher often indicates staffing challenges. However, some sectors like healthcare or tech may routinely run higher due to skill shortages.

Should I include positions that are on hold or frozen?

No. If a position is not actively budgeted or approved to be filled, do not include it in either the open or total count. The vacancy rate should reflect positions you are actually trying to fill.

Can I calculate vacancy rate for a specific department?

Yes. Use the same formula with the department’s open and total budgeted positions. This can help identify which teams are understaffed.

How often should I calculate the vacancy rate?

Most organizations calculate it monthly or quarterly. Monthly gives a more current view but can be noisy; quarterly smooths out short-term fluctuations. Choose a cadence that matches your HR reporting cycle.

What if my total budgeted positions change during the year?

That’s normal. As budgets are approved or cut, the total changes. Always use the current total for the period you are measuring. If you are comparing over time, note the denominator changes.

Does the vacancy rate include positions filled by contractors or temporary workers?

No. Contractors and temps are not employees in the budgeted headcount. If you use them to cover a vacancy, the position is still open and should be counted as vacant.

Related

• Employee Cost Calculator Australia: Real Cost per Hour
• Gal per Minute to Liters: Flow Rate Converter
• Employee and Employer NI Calculator: How It Works

in open | Open positions | positions | 5 | 0
in total | Total budgeted positions | positions | 100 | 1
out rate | Vacancy rate | % | (open / total) * 100 | 2
out filled | Filled positions | positions | total - open | 0