PinkLinq

Blog · Scheduling

How to Build a Weekly Employee Schedule in Under an Hour

A step-by-step way to build a weekly work schedule that covers your busy hours, respects availability and doesn't blow your labor budget.

Most managers spend their Sunday night on the schedule. It doesn't have to take that long. It takes a long time because you're rebuilding the whole thing from memory each week, while holding everyone's availability in your head and checking your phone for texts.

Here's a process that works for a shop, a cafe, a small hotel or a crew. It works on paper, in a spreadsheet or in an app. The order matters more than the tool.

Step 1: Start from your demand, not your people

Before you write down a single name, work out how many people you need and when. Forget who's available for now.

Grab last month's sales or customer counts and look at them by day and by hour. Most businesses have a clear pattern. Maybe Friday from 5 to 8 is a rush and Tuesday morning is dead. Write down how many people each block needs:

BlockMon to ThuFriSatSun
Open to noon2243
Noon to 53454
5 to close3663

You only have to do this once, and then tweak it. Keep it taped to your desk or saved in your schedule template. Holidays and local events get their own version.

Step 2: Set your hours budget

Next, decide how much labor you can afford. Take your expected sales for the week and multiply by your labor goal. If you expect $20,000 in sales and your goal is 28%, you've got $5,600 for labor. Take out roughly 10% for payroll taxes, and divide the rest by your average hourly wage. At $17 an hour, you get about 296 hours.

Now you've got a target. If your demand table adds up to 350 hours, you'll see the problem before you've scheduled anyone. Our labor cost calculator does this math for you.

Step 3: Lock in the fixed pieces

Start with what can't move:

  1. Your key holders and shift leads. Each opening and closing needs someone who can run it.
  2. Approved time off.
  3. People with fixed hours, such as those who only work school hours.
  4. Anyone with a special skill you can't run without, like your only certified forklift driver.

Those shifts go on first. If you can't cover a closing with a key holder, you've got a hiring problem. It's better to find that out now than on Saturday night.

Step 4: Fill in the rest with last week as a starting point

Copy last week and change what's different. Most weeks look about the same, and people like having regular shifts. Predictable hours make it easier for them to plan child care, classes and second jobs, and that's a real reason people stay.

While you fill it in, watch for these:

Step 5: Check it against your numbers

Before you publish, take five minutes to compare:

If you're over budget, cut from the slow times first. Staggered starts help a lot here. Two people starting at 11 and 1 can cover a lunch rush for less than two people on all day.

Step 6: Publish early and stop changing it

Give people as much notice as you can. Two weeks is a good goal, and some cities and states make that a legal requirement for certain employers. Read about predictive scheduling laws to see if you're covered.

Put it in one place, too. A photo in a group text gets lost. A single place everyone checks is what stops the "I didn't know I was working" conversation.

Once it's out, don't keep fiddling with it. Let swaps and open shifts handle changes, with a simple swap policy, so it's not all on you.

A template saves most of the hour

Everything above gets faster when you save your work. Build a normal week once, save it, and next week you're only making changes. You can download our free weekly schedule template if you're working in a spreadsheet.

In PinkLinq, you copy last week with one click, drag shifts around, and see hours and cost beside your sales for each day. Anyone heading into overtime shows up in a list, and when you press Publish, everyone gets their shifts on their phone.

The short version

  1. Work out demand by time block.
  2. Turn your sales goal into an hours budget.
  3. Place key holders, time off and fixed shifts.
  4. Copy last week and adjust it.
  5. Check it against the budget and for overtime.
  6. Publish early, in one place.

The first time takes longer. By the third week, it should take well under an hour.

Bring your team onto one app.

Free for up to 10 people, with every Advanced feature for your first 14 days. Tell us about your team and we’ll set you up — usually the same day.