Share

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus convallis sem tellus, vitae egestas felis vestibule ut.

Error message details.

Reuse Permissions

Request permission to republish or redistribute SHRM content and materials.

Vacancy Rate and Cost Calculation Spreadsheet




​This spreadsheet contains formulas to calculate an organization's vacancy rate resulting from both employee turnover and the addition of new positions. It also calculates the vacancy cost of having work completed in the absence of the former employee or employees, less wages and benefits that are not being paid for the vacant position. These formulas can be used to calculate these rates for one position, a class code, a division or the entire organization. 

Advertisement

​An organization run by AI is not a futuristic concept. Such technology is already a part of many workplaces and will continue to shape the labor market and HR. Here's how employers and employees can successfully manage generative AI and other AI-powered systems.

Advertisement