Shyfter

Staffing Plan Template: A Free, Filled-In Example for Shift-Based Teams

Marie Altieri
By Marie AltieriHR Customer Success Manager · LinkedIn
Published on
Open weekly planner next to a laptop on a white desk, ready to build a staffing plan

Summer is eight weeks away, your best server just handed in their notice, and the owner wants to know how many people to hire. A schedule can’t answer that question because it only covers next week. A staffing plan can, as long as it’s built on hours rather than gut feeling.

Below is a staffing plan template you can copy into Excel or Google Sheets, already filled in for a real-world case, plus the math behind every column.

What is a staffing plan, and how is it different from a schedule?

A staffing plan answers one question: how many hours of work, by role, will you need over the coming months, and how will you cover them? It looks one to four quarters ahead. The schedule comes later and puts names on shifts for one or two weeks.

Think of it this way. The staffing plan decides that you need nine full-time equivalents on the floor in July. The shift schedule decides that Emma closes on Saturday and Luis opens on Sunday.

There’s also a bigger cousin, strategic workforce planning, which deals with skills, succession and three-year headcount targets. If that’s what you’re after, our guide to strategic workforce planning in HR covers it. This template is the operational version: one season, one site, hours and dollars.

The staffing plan template (filled in)

Here’s the plan a 110-seat bistro in Denver, Colorado, built in April for its summer quarter, June to August. Full time is 40 hours a week. The figures are for a typical peak week, and the hourly rates are the bistro’s own loaded costs (wage plus payroll taxes), not market averages.

RoleHours needed / weekFTE needed (÷ 40)FTE on payrollGapHow to close itAdded cost / weekReady by
Servers3609.07.2+1.8Hire 2 part-timers at 28 h, add 16 h for current staff72 h × $22 = $1,584May 15
Bartenders1203.03.00No change$0-
Line cooks2807.06.0+1.0Hire 1 full-time cook40 h × $26 = $1,040May 1
Prep and dish1604.04.5-0.5Don’t replace the dishwasher leaving in June$0June 1
Hosts802.01.5+0.51 summer hire at 20 h20 h × $18 = $360May 25
Total1,00025.022.2+2.8$2,984

Over a 13-week summer, that’s $38,792 of extra labor. The owner can now hold that number against the forecast sales for the same months, which is exactly the conversation a staffing plan is supposed to start.

Notice the “Ready by” column. A line cook needs about two weeks on the line before they can hold a station alone on a Saturday, so the hire has to land in early May, not on June 1. Most staffing plans we see forget this column, and that’s where summer goes wrong.

How to fill in each column

Copy the table headers into a spreadsheet, one row per role, and work left to right:

  • Hours needed / week: what demand requires, built hour by hour (see the next section). Never copy last year’s schedule here, because last year’s schedule includes last year’s mistakes.
  • FTE needed: hours divided by your full-time week. Use the same base everywhere; the FTE calculator explains why 40, 37.5 and 38 hours give different answers.
  • FTE on payroll: contracted hours of the people who will actually be there, minus anyone already leaving.
  • Gap: needed minus on payroll. Positive means hire or add hours, negative means hold or reallocate.
  • How to close it: hire, extend part-timers, cross-train, use seasonal workers, or accept some overtime.
  • Added cost / week: added hours times the loaded hourly rate for that role.

In Google Sheets, with hours needed in column B, the full-time week in cell K1 and FTE on payroll in column D, the formulas are =B2/$K$1 for FTE needed and =C2-D2 for the gap. That’s the whole engine.

How do you calculate how many staff you need?

Start from demand, not from the roster. For a restaurant, demand means forecast covers per hour; for a shop, it’s transactions or footfall; for a hotel, rooms to clean. Then apply a labor standard: how much work one person handles in an hour.

The Denver bistro uses its own standard of one server per 20 covers an hour. Here’s its Saturday:

Time slotForecast covers per hourServers needed (÷ 20, rounded up)Server hours
11 am - 12 pm3022
12 pm - 1 pm8555
1 pm - 2 pm7044
2 pm - 5 pm2013
5 pm - 6 pm4022
6 pm - 7 pm9555
7 pm - 8 pm12066
8 pm - 9 pm11066
9 pm - 10 pm6033
10 pm - 11 pm2522
Saturday totalpeak: 638

Two numbers come out of that table, and you need both. The total, 38 server hours, feeds the staffing plan. The peak, six servers at the same time, tells you how many different people you need available on a Saturday night, however the hours add up.

Repeat the exercise for the other six days and the server line reaches 360 hours a week. That’s the figure in the template.

One trap. If six servers are needed at 7 pm but only two at 5 pm, you don’t need six people working nine-hour shifts; you need staggered starts. Plans that skip the hourly view tend to overstate hours, because every shift gets drawn from opening to close.

How much buffer should a staffing plan include?

The template above assumes everyone shows up and nobody quits. Neither is true.

Start with time off. Look at last year’s ratio of hours lost to vacation, sick days and no-shows against hours planned. If the bistro loses 8% of its planned hours that way, it divides its needs by 0.92: 1,000 hours become 1,087, and 25 FTE becomes 27.2. Two extra people, just to stand still.

Then there’s turnover, and in hospitality it’s brutal. According to the Bureau of Labor Statistics JOLTS survey, the seasonally adjusted quits rate in accommodation and food services was 3.6% in August 2026, against 2.9% in retail trade and 1.9% for all nonfarm jobs. That’s a monthly rate. On a 30-person restaurant team, 3.6% a month works out to about one resignation a month and roughly 13 over a year.

So a staffing plan needs a hiring rhythm, not a single hiring wave. If you lose one person a month and it takes three weeks to recruit and two to train, you should always have one candidate in the pipeline. Waiting for the resignation letter means running short for five weeks every time.

Is there a magic percentage? No. But here’s what we tell restaurant groups when they ask at Shyfter: measure your own shrinkage over the last 12 months before you trust any benchmark, including ours. The two figures that matter are already in your schedule and your time clock.

The seasonal view: one row per quarter

Some businesses don’t have a peak week. They have a peak season. For them, the useful template has one row per quarter instead of one row per role.

Take a 64-room hotel in Bruges. Its housekeeping standard is 30 minutes per occupied room, and full time in Belgium is generally 38 hours a week:

QuarterAverage occupancyRooms per dayHousekeeping hours / weekFTE needed (÷ 38)Core teamGap
Q155%35.2123.23.23.20
Q275%48.0168.04.43.2+1.2
Q390%57.6201.65.33.2+2.1
Q465%41.6145.63.83.2+0.6

The hotel sizes its permanent team on the quietest quarter and covers the rest with flexible hours. In the summer, a gap of 2.1 FTE is about 80 hours a week, or 1,040 hours over 13 weeks.

In Belgium, students are the obvious answer, with a catch only local managers tend to know. Each student has a quota of 650 hours a year at reduced social contributions, and that quota is shared across every employer they work for. Two students could cover the Bruges summer on paper, at 520 hours each. But if one of them already worked 300 hours in a supermarket in the spring, the plan breaks in mid-August. Check the remaining quota before you count on anyone.

A staffing plan is a budget document, but a few legal thresholds move with your headcount and should sit right next to it:

  • ACA employer mandate (US): an employer that averaged at least 50 full-time employees, including full-time equivalents, over the prior year is an applicable large employer under IRS rules. A summer hiring wave can push you over for the following year.
  • Predictive scheduling (Oregon and several cities): in Oregon, retail, hospitality and food service employers with 500 or more employees worldwide must post schedules 14 days in advance and respect a 10-hour rest period between shifts. Your plan has to be ready before that window opens.
  • Student work (Belgium): 650 hours per student per calendar year at reduced contributions, all employers combined.
  • Full-time base (Belgium): generally 38 hours a week, which changes every FTE figure if you compare Belgian sites with US ones.

None of this replaces advice from your accountant or employment lawyer. It just keeps the plan honest.

From spreadsheet to schedule

A spreadsheet is fine for building the plan. It struggles with the follow-up: checking every week whether reality matches it. The hours you need live in your schedule, the hours you got live in your time clock, and the cost lives in payroll. Three files, three versions of the truth.

That’s the gap Shyfter closes. When you build shifts in Shyfter’s staff scheduling, the cost of each shift shows up as you plan it, so you can see straight away whether next week fits the budget your staffing plan set. Smart Analytics then compares planned hours, actual hours and costs by period, team or location. If the Denver bistro’s server line drifts from 360 to 410 hours in July, it shows up in week two, not at the end of the quarter.

And if the plan shows that labor is growing faster than sales, check your labor cost percentage before you hire anyone.

Want to see your planned and actual hours side by side for one of your sites? Book a free demo of Shyfter and we’ll build the comparison with you.

Frequently asked questions

What should a staffing plan include?

At minimum, one row per role with the hours needed, the FTE needed, the FTE already on payroll and the gap between the two. Add how you’ll close each gap, the added weekly cost and the date the new people must be ready. A buffer for time off and turnover makes it realistic.

How often should you update a staffing plan?

Build it once per season or quarter, then check it every week against actual hours worked. Update it whenever demand changes significantly, someone resigns, or a new site opens. A plan that’s only reviewed once a year is usually wrong by the second month.

What’s the difference between a staffing plan and a work schedule?

A staffing plan works in hours and FTE over several months and decides how many people you need. A work schedule works in named shifts over one or two weeks and decides who works when. The schedule should stay within the hours and budget the staffing plan sets.

Can I build a staffing plan in Excel or Google Sheets?

Yes. One column for hours needed, one for FTE needed, one for FTE on payroll and a simple subtraction for the gap is all it takes. The hard part is keeping it current, because the actual hours sit in your schedule and time clock, not in the spreadsheet.

All about: Schedule management →

Ready to transform your workforce management?

Shyfter is more than a scheduling tool. It's a complete workforce management solution designed to save you time.

Request a demo