FTE Headcount Planner

Turn each team’s workload into the headcount you need. Enter annual volume and current staff, and the workbook returns required FTE on real productive hours, the staffing gap, and a hiring plan and budget that separate the gap from attrition.

A working model, not a blank grid

Set working time once (hours per week, working weeks, holidays, PTO, sick days, hours per day, on-task utilization), then list each team with its annual volume, the hours one unit takes, and current staff. The workbook builds productive hours per FTE, about 1,627 in the worked example, then returns required FTE, the staffing gap, and the hires needed, team by team with a running total. A one-page Summary rounds the requirement to whole people, splits the open staffing gap from attrition replacement, and prices the plan at current and full staffing from a fully loaded cost per FTE. A Benchmark tab holds working-time and turnover figures from BLS and the IRS, and it opens on a worked example so the logic is clear before you change anything.

Paid hours are not capacity and the gap is not the whole hire

Two shortcuts get headcount wrong. The first plans on the 2,080-hour paid year, as if a head delivered every paid hour; real capacity is the productive hours left after time off, then after the share of the day spent in meetings, training, and admin, well short of the paid total. The second sizes the gap between need and headcount and stops there; attrition replacement is the hiring turnover forces regardless of the gap, so a team that is short and also losing people has to do both, and total hires run above the net gap. Sizing each team on its own demand, rather than one blended ratio, shows where to add people first.

Built for

• An HR or talent leader building a headcount plan for the year who needs to show the work behind each number before taking it to finance.
• A finance or operations partner pressure-testing a hiring request, who wants required FTE tied to workload and a budget at current versus full staffing.
• An owner or department head who senses a team is stretched and wants a defensible headcount figure rather than a running argument about being short.

If you are looking for staffing a daily or shift schedule where coverage needs a relief factor, the Shift Staffing Planner sizes that. To decide whether to cover one known gap with overtime or a new hire, see the Overtime vs New Hire Planner.

Before you buy

What format is it, and can I edit it?

It is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep; add teams by inserting rows, and duplicate the file to plan a division on its own. Checkout delivers an instant download link, with the same link emailed on your receipt.

What does the paid workbook do that a free calculator does not?

This workbook plans every team in one place and adds the budget: a fully loaded cost per FTE turned into the cost at current staffing, the cost at full staffing, and the added spend to staff the work fully. It is a file you keep, with open formulas, so you set the assumptions to your operation, rerun it as demand moves, and hand the Summary to leadership. A quick browser tool sizes one team; this plans every team and prices the plan.

How do I estimate annual volume and hours per unit?

Use whatever unit a team measures its work in: tickets, orders, cases, accounts, or hours of demand. Annual volume is how many units the team handles in a year, and hours per unit is the average time one takes, which a sample of recent work or a team lead can give you. If a team has no countable unit, enter its demand directly in hours and set hours per unit to one.

What is the refund policy?

Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms. Questions? Email support@truestephr.com.

These are planning estimates, and the working-time assumptions drive them. Set them to your operation, keep the annual volumes honest, and treat the output as a directional figure for sizing headcount.

How the download works

Your files arrive as a single ZIP download, best opened on a computer: save it, extract it (right-click and Extract All on Windows, double-click on a Mac), and open the Start Here file first. PDFs open in any reader, and the editable files work in Microsoft Word and Excel or their free equivalents, including LibreOffice and Google Docs and Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.

Scope

This tool is a planning and analysis model. Its outputs depend entirely on the inputs and assumptions you enter, and they are estimates for decision support, not accounting, tax, or legal conclusions. It is not legal, tax, or financial advice, and it is not a substitute for qualified counsel on your specific situation. Check the assumptions against your own data and have any decision with pay, headcount, or separation consequences reviewed against applicable law before you act on it.