Note, if you want this built in google sheets, I can do that for a rate of $120/hr. You will now be able to track the net pipeline to see where headcounts may be relative to model projections and act accordingly.
The reason why this tool is so useful is that often times the planned hires and fires of a company can be hard to keep track of over time. The above four inputs will be queried by formulas so that headcounts can dynamically populate in up to 3 future buckets as well as the 'current' status as of the current day (today function is used to know what date 'current' is).Īlso, if you have current employees, the first set of data inputs will just be 'Add' transactions with a date that is less than or equal to the current date. This template works for startups or an established organization. The user interface is pretty friendly and editable cells are clearly defined from formulas. Additional, a visual stacked bar chart that shows net surplus/shortage by department by time-frame was implemented. The 'model' figures would originate from somewhere else or come directly from some plan that exists already.Ĭolor-coding has been implemented to more easily analyze the data. This expected headcount is then compared against the model projections to figure out if there is expected to be a surplus or shortage of employees in a given department against the model. That transaction will feed into a date-based structure so that the current, 30 day, 60 day, and 90 day projected headcount can be determined by department. This tool has a simple data entry structure so that expected hiring/firing/attrition can be defined as a transaction. Hr human resources headcount planning attrition headcount forecasting hiring firing visualize
Headcount planning template xls free#
Whether you’re trying to analyze your current headcount needs or plan for the future, these free workload analysis downloads will show you several ways to analyze, estimate and. Resource and staff planning is critical for any organization and yet every manager struggles with it. Weighted average cost of capital (wacc) Free MRH Downloads: Headcount Planning and Analysis Templates.