Skip to main content

How to build a restaurant schedule from a sales forecast

Forecast sales by hour, turn each hour into a crew count, lay shifts over the curve and check the total against your budget. A step-by-step method with a worked example.

Labor

To build a restaurant schedule, start with a sales forecast for each hour of next week. Turn each hour's forecast into a crew count with a simple staffing guide. Then lay shifts over that curve, add fixed work like opening prep and closing, and check the total hours against your labor budget before you post.

That is the whole method. The rest of this guide shows each step with real numbers for one Friday at Switchback Grill in Provo, plus the mistakes that quietly add hours.

Why build the schedule from a sales forecast?

Most schedules start as last week's schedule with a few names swapped. That feels safe, but it locks in last week's mistakes. If Tuesday afternoons were overstaffed last week, they will be overstaffed next week too.

A forecast flips the order. You decide how busy each hour will be first, then staff to it. That is what staffing to demand means. Guests get a full line at noon, and the store stops paying for a full line at 3 PM.

Step 1: forecast sales by day

Pull the same weekday for the last four weeks from your POS. Average them. Four weeks smooths out one odd day without going so far back that the season has changed.

Then adjust for what you already know. A catering order on the books, a school holiday, a home game, a road closure. Add what is booked, not what you hope for.

Friday sales forecast, Switchback Grill, Provo
Friday, four weeks ago$4,820
Friday, three weeks ago$5,110
Friday, two weeks ago$4,960
Last Friday$5,030
Average of four Fridays$4,980
Catering order booked for Friday$350
Friday forecast$5,330

Leave out a day that was clearly abnormal, like a day the store closed early for a power cut. Average the other three instead.

Step 2: split the day into a sales forecast by hour

A day total does not tell you when to bring people in. Your POS can show each hour's share of a typical Friday. Apply those shares to the walk-in forecast, $4,980 here, to get a sales forecast by hour. The catering order is handled separately, because it is prep work, not line work.

Then turn each hour into a crew count with a staffing guide. A staffing guide is a short table that says how many people the store needs at each level of sales. Provo's looks like this:

  • Under $300 an hour: 4 people
  • $300 to $499: 5 people
  • $500 to $699: 7 people
  • $700 and up: 8 people

Build yours from your own store. Look at hours where ticket times held and nobody was standing around, and note how many people were on. The minimum, 4 here, is the crew the store needs to run every station safely, whatever the sales.

Friday at Provo: forecast sales and crew by hour
10 AM$200, 4 people
11 AM$560, 7 people
12 PM$800, 8 people
1 PM$560, 7 people
2 PM$300, 5 people
3 PM$220, 4 people
4 PM$280, 4 people
5 PM$560, 7 people
6 PM$680, 7 people
7 PM$480, 5 people
8 PM$340, 5 people
Open hours, 10 AM to 9 PM$4,980, 63 hours

Step 3: add opening, closing and prep hours

Selling hours are only part of the day. Add the work that happens with the doors closed:

  • Opening prep, 7 to 10 AM: 3 people, 9 hours
  • Close, 9 to 10:30 PM: 4 people, 6 hours
  • Catering prep for the booked order: 2 hours

That brings Friday to 80 hours: 63 on the floor, 9 for opening, 6 for close and 2 for catering prep. Count salaried managers inside these numbers when they work a station, because they are part of the crew.

Step 4: lay shifts over the curve

Now draw shifts that match the crew counts hour by hour. The trick is staggered start and end times. A schedule where everyone starts at 10 and leaves at 6 is easy to write and expensive to run.

For Provo's Friday, that means:

  • Opening crew starts at 7 and stays through lunch.
  • Two lunch shifts start at 10:30 and 11, and end at 2.
  • One mid shift runs 11 to 7 to bridge the afternoon.
  • Dinner shifts start at 4:30 and 5, and the closers come in at 5.

Schedule breaks into the shifts from the start, so they happen in the quiet hours and nobody has to skip one. Follow your state and city rules for breaks and for minors' hours. A schedule that only works if someone works through a break is a schedule with too few people on it.

Step 5: check the schedule against your labor budget

Before you post, check the total. The quickest check uses sales per labor hour: forecast sales divided by a target gives you the hours the forecast can support.

Budget check for Friday at Provo
Friday forecast$5,330
Target sales per labor hour$64.00
Labor hours the budget allows83
Hours on the draft schedule80
Hours to spare3

Provo's draft fits with 3 hours to spare. There is no need to spend them. If the draft had come in at 95 hours, you would look for the hours where the crew count is above the staffing guide and trim those first.

It is also worth a dollar check. Multiply each hourly shift by that person's pay rate, add them up and divide by forecast sales. That gives you projected hourly labor as a percentage of sales. Keep it separate from fully loaded labor on the P&L, which includes salaries, payroll taxes and benefits. Our guide to labor cost percentage explains the difference.

Step 6: post it early and change it carefully

Post the schedule as early as you can. A week ahead is a common minimum, and two weeks is better. People who can plan their lives stay longer, which is one of the cheapest ways to reduce employee turnover. Some cities and states also have fair workweek rules that require advance notice and pay for changes, so check the rules where your store is.

Once it is posted, leave it alone. If Friday comes in slower than forecast, do not send people home early to protect the number. Note what happened, and put the fix on next week's schedule.

Common restaurant scheduling mistakes

  • Copying last week's schedule instead of starting from a forecast.
  • Forecasting from one week, which turns one rainy Tuesday into a pattern.
  • Forgetting catering orders and known events until the day.
  • Staffing every hour of the day the same, so the afternoon carries the lunch crew.
  • Leaving breaks off the schedule, so they get squeezed in or missed.
  • Cutting hours at the busiest hour to hit a budget. A short lunch line slows speed of service and costs more in lost sales than it saves.
  • Posting at the last minute, which pushes good people toward jobs with steadier hours.
  • Never checking the forecast against what actually happened.

A weekly scheduling habit

Pick a fixed day for each part of the job:

  1. Monday: compare last week's forecast with actual sales by daypart. Note any daypart that was off by more than about 10%.
  2. Tuesday: check the catering book and the local calendar for the week after next.
  3. Wednesday: build the forecast, apply the staffing guide, lay out shifts and run the budget check.
  4. Thursday: post it.

Each Monday review makes the next forecast a little better. After a month, you will know which hours your staffing guide gets wrong, and you can fix the guide itself. When you are ready to go further, our guide to reducing labor cost without hurting service covers the next steps, and growing catering sales is the best way to give a slow afternoon something to do.

Franlever's AI COO reads each store's sales and labor hours from the POS and compares them with the store's own recent weeks. When a run of hours keeps carrying more crew than its orders need, it sends the owner or GM one specific change for next week's schedule. You can see how Franlever works in more detail.

Common questions

How far in advance should a restaurant schedule be posted?
Many operators post at least a week ahead, and two weeks is better for retention. Some cities and states have fair workweek rules that require advance notice and extra pay for last-minute changes, so check the rules where your store is.
How do you forecast sales for a restaurant schedule?
Average the same weekday over the last four weeks, then adjust for anything you know is coming, like catering orders, holidays or a local event. Split the day into hours using that weekday's usual pattern from your POS.
How many employees do I need per shift?
Use a staffing guide that turns forecast sales per hour into a crew count, with a minimum for the hours when the store is quiet. Build it from your own store's busy and slow hours, and adjust it when ticket times or reviews show the line is struggling.
Should I just copy last week's schedule?
No. Last week's schedule fits last week's sales, not next week's. Start from a fresh forecast each week, then reuse shift patterns where they still fit.

General information for restaurant and franchise operators, not legal, tax, accounting or financial advice. Figures in examples are illustrations, not predictions or promises of results. Laws and platform policies change and differ by location, so check the current rules and talk to a qualified advisor about your situation.

Keep reading

All resources