HR tools built by a senior HR executive · United States

Published standard  ·  Assessments  ·  Contact

HR calculator

Shift Staffing Planner

Turn the coverage you have to provide into the headcount it takes to staff it. Set time off once and list each post.

FormatCalculator
Contents4 PDF guides, 1 Excel workbook
UseDownload and keep

$29

  • Editable operating files, not a subscription
  • Immediate access through the secure TrueStep HR store
  • Built and reviewed under the published TrueStep HR standard

Digital products carry a 30-day money-back guarantee. General HR information, not legal advice.

Need it working, not sitting in Downloads?

Add a one-hour setup session · $149

Bring the purchased tool and your live situation. A TrueStep HR practitioner helps you set the inputs, make the first decisions, and leave with a usable next step.

See the Setup Session →

What this closes

A practical system that moves the decision into real work.

Describe the coverage you have to hold. The planner returns the number of employees it takes to staff it, with absence and turnover allowed for.

DecisionControl labor cost
IndustryCross-industry
Files4 PDF guides, 1 Excel workbook
ReviewBuilt to the published release checks; sources and change notes sit beside the catalog.

What is inside

Every file in the download, by name.

Taken from the kit’s own Start Here guide, so what you see here is what you open after checkout.

Excel · useShift Staffing Planner: 5 tabs: Start Here, Shift Planner, Benchmark, Summary, and Notes.
PDF · printQuick Reference: the whole workbook on one page: what each tab is for, what you enter, and how to read the result.
PDF · readUsing This Workbook in Google Sheets: how to upload the file to Google Sheets and exactly what to check afterward.
PDF · keepTrueStep HR Product License: what you may and may not do with the files you purchased.

How to use it

What this workbook does

This workbook turns the coverage you have to provide into the headcount it takes to deliver it. Coverage is how many people must be working at once. Staffing is higher, because everyone takes holidays, PTO, sick days, and training time, so it takes more than one employee to keep one post filled around the clock. It works out how many hours one employee really works in a year, then sizes each post with the standard relief factor method and totals the people you need across the whole operation.

Your first 15 minutesOpen the Shift Staffing Planner workbook in Microsoft Excel or a free equivalent such as LibreOffice. The first tab, Start Here, walks you through every tab. On the Shift Planner tab, set the per-employee availability once: contracted hours, weeks, holidays, PTO, sick, and training days, and hours per day. Hours worked per employee calculates from these. Edit only the amber cells; the white cells calculate for you.
Shift Staffing Planner — the Start Here guide from the download, listing every file and the order to use them.

Before you buy

Clear answers to the practical questions.

The point of a product page is to let you judge the work before checkout.

What exactly do I receive?

4 PDF guides, 1 Excel workbook, each one named in the What is inside section above. The purchase is a download, not a subscription, and the files are yours to keep.

Are these the real screenshots?

Yes. The preview images on this page are taken from the current deliverable, so you can judge the structure and writing before buying.

Can I use the files in my business?

The files are designed to be edited for your own internal operations. Review the included license and have legal counsel check decisions that require jurisdiction-specific advice.

What if I need help applying it?

Use the $149 Setup Session for one hour of implementation help on this tool. TrueStep HR does not offer broader consulting engagements. For a legal question, use qualified counsel.

Extend the system

Build on this decision.

These products address the next connected step in the same situation, operating method, or industry.

Employee Cost Calculator — the 5 files in this download shown as a stack of real pages: Excel + PDF, 14 pages in all.
CalculatorTSHR-001

Employee Cost Calculator

See what an employee costs in full, not just the salary. The workbook adds payroll taxes, benefits, workers’ comp, paid time off, and overhead. It then gives you the fully loaded annual cost, the cost per month, and the real hourly rate.

Labor Burden Rate Calculator — the 5 files in this download shown as a stack of real pages: Excel + PDF, 19 pages in all.
CalculatorTSHR-002

Labor Burden Rate Calculator

Turn a salary into the number you can price and bid against: the fully burdened hourly cost and the multiplier on base pay. Set each employer cost, and the workbook divides the all-in cost across the productive hours you really get.