Workforce forecasting: a practical guide for hourly teams

If your scheduling process starts with last week's schedule and ends with a gut check — you're leaving money on the table. Workforce forecasting fixes that. It's the practice of using your sales data, seasonal patterns, and labor targets to predict how many staff hours you need before you ever build a schedule.

Overstaffing a slow Tuesday and understaffing a Saturday rush aren't bad luck. They're what happens without a forecast. This guide gives you a practical framework to get you started.

‍

{{banner-cta}}

‍

TL;DR: How workforce forecasting actually works

Workforce forecasting is the process of using sales data, seasonal trends, and labor targets to predict how many staff hours your business needs — before you build a schedule. Here's how it works:

• Use historical sales data to predict demand by day and shift.
• Set a target labor percentage and convert it into budgeted hours.
• Build your schedule to hit that number — not the other way around.
• Compare scheduled hours against your forecast before you publish.

The result: fewer overstaffed slow days, fewer understaffed rushes, and labor costs you actually control.

What is workforce forecasting — and how does scheduling fit in?

Workforce forecasting is the process of predicting your staffing needs based on data rather than instinct. Instead of copying last week's schedule or going with your gut, you're using real information — past sales, customer traffic patterns, upcoming events, seasonality — to figure out how many people you need and when.

But forecasting alone doesn't get anyone scheduled. That's where the two concepts connect:

• Forecasting answers: How many labor hours do I need to meet expected demand?
• Scheduling answers: Which people cover those hours, and when?

When forecasting and scheduling are connected, your labor costs stop being a surprise. You're building your schedule to hit a target, not building it and hoping the numbers work out.

Here's what that looks like across a couple of industries:

• A restaurant forecasts a busy Friday night based on last month's sales data and a nearby local event. That forecast tells them they need 120 labor hours for the week, with 30 concentrated on Friday evening — so the schedule gets built around that number.
• A medical clinic uses patient booking history to forecast that Tuesday afternoons are consistently their busiest window, and staffs accordingly.

For hourly teams, the stakes are higher than in salaried office environments. You can't absorb extra people on the clock without feeling it in your margins, and you can't under-staff a rush without losing revenue in real time.

Homebase makes it easy to build schedules around your sales forecasts — so your labor targets and your shifts are always working from the same number.

“Schedule communication with the employees works flawlessly with Homebase and that’s a big plus. We publish the schedule and the employee gets the information on their phone. We very rarely have an employee tell us that they didn’t know that they were supposed to work that day.” — Keith Zimmerman, Owner of Plum Creek Farm

Workforce forecasting vs. workforce planning: what's the difference?

These two terms get used interchangeably, but they're doing different jobs:

• Workforce forecasting is short-term and operational. It answers: based on what I expect to happen this week or this month, how many people do I need on shift?
• Workforce planning is longer-term and strategic. It answers: based on where my business is heading, do I need to hire more people, restructure roles, or invest in training?
• Scheduling is the execution layer that turns your forecast into actual shifts, actual names, and actual hours.

For most small businesses, workforce planning happens a few times a year. Workforce forecasting happens every single week.

How to forecast staffing demand using sales data.

This is where forecasting goes from concept to something you can actually use. The math isn't complicated — but having a repeatable process makes all the difference.

Step 1: Forecast your revenue.

Start with your sales history for the same period last year, adjusted for any known variables — a new competitor nearby, a local event, a menu price increase. If you're newer and don't have a full year of data, use the last 4–6 weeks as your baseline. Your goal: a realistic revenue estimate for the upcoming week, broken down by day.

Step 2: Set your target labor percentage

Labor percentage targets vary by industry and business model. According to the National Restaurant Association, food and beverage businesses often aim for somewhere in the 25–35% range, while retail tends to run lower. If you don't have a target yet, start by calculating what you've actually been spending:

Total labor cost ÷ total revenue = your current labor percentage

That's your baseline.

Step 3: Convert your labor budget to hours

Once you know your revenue forecast and labor percentage target, the math is straightforward:

Forecasted revenue × labor percentage = labor budget

Labor budget ÷ average hourly wage = budgeted labor hours

For example: a café forecasts $18,000 in revenue for the week. Their labor target is 30%, giving them a $5,400 labor budget. At an average wage of $15/hour (adjust this for your actual average wage), they can schedule 360 hours for the week. 

That number becomes your scheduling constraint — not a suggestion, but the target you're building toward.

Step 4: Adjust for peak periods

Don't distribute those hours evenly. Use your daily sales breakdown to weight your schedule toward your busiest days and shifts. A few things to factor in before you finalize:

• Which days drive the most revenue? Weight your hours accordingly.
• Are there any one-off events, holidays, or rushes coming up?
• Who has approved PTO or limited availability that week?

Homebase connects your sales data directly to your schedule, so you're always building toward a real labor target — not a guess. Try it free today.

How to compare scheduled hours against labor forecasts

Building a forecast is step one. Checking your schedule against labor forecasts before you publish is where you actually protect your margins. Here's the process:

1. Forecast your required labor hours using the steps above.
2. Build your draft schedule based on availability, roles, and coverage needs.
3. Total your scheduled hours and compare them to your forecast.
4. Adjust before you publish — not after the week is over.

To see how this works in practice, here's an example of a forecasted week vs. a scheduled week for a small restaurant:

• Monday: 42 forecasted hours / 44 scheduled hours / +2 variance
• Tuesday: 38 forecasted hours / 35 scheduled hours / -3 variance
• Wednesday: 40 forecasted hours / 40 scheduled hours / no variance
• Thursday: 48 forecasted hours / 53 scheduled hours / +5 variance
• Friday: 62 forecasted hours / 61 scheduled hours / -1 variance
• Saturday: 70 forecasted hours / 74 scheduled hours / +4 variance
• Sunday: 50 forecasted hours / 48 scheduled hours / -2 variance
• Weekly total: 350 forecasted hours / 355 scheduled hours / +5 variance

A five-hour overage at $15/hour is $75 you didn't plan for. Across 52 weeks, that's $3,900.

When your scheduled hours exceed your forecast, here's how to close the gap before you publish:

• Look at your heaviest days first. That's where overages tend to hide — Thursday and Saturday in the example above.
• Trim shift lengths before cutting headcount. Shortening a closing shift by 30–60 minutes is often less disruptive than removing a person entirely.
• Redistribute, don't just cut. If Tuesday is under by 3 hours and Thursday is over by 5, you may have a coverage opportunity hiding in plain sight.
• Flag it, don't fix it blindly. If the overage is tied to a known event or rush, it may be intentional — just make sure it's a conscious decision, not a scheduling accident.

6 workforce forecasting methods for hourly businesses

There's no single right way to forecast. Most businesses use a combination of these forecasting models depending on the week.

1. Historical trend forecasting

Analyze past sales or traffic data to predict what's coming. Best for businesses with consistent, repeatable patterns — like a neighborhood café that sees the same Monday morning rush week after week.

2. Seasonal forecasting

Adjusts your baseline for predictable seasonal swings. A retail shop knows December looks nothing like August. Build those patterns into your staffing expectations before they sneak up on you.

3. Event-based forecasting

Accounts for one-time or recurring demand spikes — a local festival, a sports game, a wedding block booking. Keep a running log of events that affected your traffic so you can anticipate them next time.

4. Demand-based forecasting

Ties staffing directly to a leading indicator — reservations, online orders, appointment bookings — rather than historical sales alone. A medical clinic with 80 appointments booked for Tuesday doesn't need to guess how busy Tuesday will be.

5. Capacity forecasting

Works backward from your operational limits. How many tables can you turn? How many appointments can one technician handle? Capacity forecasting ensures you're not scheduling more staff than your operation can absorb — or fewer than you need to run at full capacity.

6. Real-time schedule adjustments

Even the best forecast needs to flex. Monitor actual sales against your forecast during the shift and make calls on the fly — cutting a staff member early on a slow night, calling in backup when a lunch rush outpaces the projection.

Common workforce forecasting mistakes that cost you money

Even with the right process, a few common mistakes can quietly drain your labor budget:

• Relying only on last week's schedule. Last week is a starting point, not a forecast. If it was unusually slow or busy, you'll build that distortion right into your next week.
• Ignoring overtime thresholds. An employee hitting unplanned overtime can turn a profitable week into a break-even one. Track hours against thresholds before they're hit, not after.
• Not accounting for PTO and availability. A forecast that assumes full availability and then loses two people to approved time off isn't a forecast — it's a wish.
• Forecasting without POS integration. If your sales data lives in one system and your scheduling in another, you're adding a manual step that invites errors. The closer your data is to your scheduling tool, the more accurate your forecasts will be.
• Overcomplicating it with spreadsheets. A forecast you won't maintain is worse than no forecast at all. Start simple and add complexity as you build the habit.

What to look for in workforce forecasting software

Spreadsheets can get you started, but they don't scale — and they don't alert you when something's about to go wrong. Here's what actually matters when evaluating forecasting and scheduling software for an hourly business.

Sales data and POS integration

Your forecasting is only as good as the data behind it. Look for a tool that pulls sales data directly from your POS — not one that requires manual exports. Ask: does this tool integrate with my current POS, and can I see sales and labor data in the same view?

Labor vs. sales reporting

A tool that shows you "you spent $4,200 on labor this week" is less useful than one that shows you "you spent 31% of revenue on labor, against a 28% target." Ask: can I set a labor percentage target and track my schedule against it in real time?

Auto-scheduling based on demand

The best forecasting tools don't just give you a number — they help you build a schedule around it. Auto-scheduling features use your sales forecast, employee availability, and role requirements to generate a draft schedule already optimized for your labor target.

Overtime alerts and thresholds

Your software should flag employees approaching overtime before you publish the schedule — not after the hours are worked. Ask: does the tool alert me before an employee hits overtime, while I still have time to adjust?

Forecast vs. actual comparison tools

After the week is over, you need to know how close your forecast was. Tools that show forecasted hours vs. actual hours worked help you calibrate future forecasts and catch patterns you'd otherwise miss.

Multi-location support

If you're scheduling more than one location, you need a tool that manages forecasts and schedules across all of them from one dashboard — and helps you spot patterns across locations.

How Homebase connects forecasting and scheduling

For hourly teams, Homebase connects your sales forecast directly to your schedule, so you're not managing two separate systems and hoping they agree.

Here's what that looks like in practice:

• Build schedules aligned with your sales forecasts and labor targets, with labor costs updating in real time as you add or adjust shifts.
• Integrate with top POS systems including Square, Clover, Toast, and Shopify, so your sales data feeds into your scheduling decisions automatically.
• Get alerted before an employee approaches overtime — not when you're already processing payroll.
• See immediately when your scheduled hours are running over your labor target, right from the dashboard.

Managers using Homebase save an average of 5+ hours a week — time that used to go toward rebuilding schedules from scratch, chasing availability, and manually calculating hours. 

Try Homebase free and see how much easier your next weekly schedule can be.

‍

{{banner-cta}}

‍

FAQs: Workforce forecasting and scheduling

What is workforce forecasting?

Workforce forecasting is the process of using historical sales data, seasonal trends, and demand patterns to predict how many staff hours your business needs. For hourly businesses, it's the foundation of labor cost control — replacing gut-feel scheduling with data-driven decisions that protect your margins and improve coverage.

What is forecasting and scheduling?

Forecasting and scheduling are two connected processes: forecasting predicts how many labor hours you need, and scheduling assigns the right people to cover those hours. When the two are aligned, your schedule is built to hit a labor target — not just to fill shifts — which is how hourly businesses control costs without sacrificing coverage.

How do you forecast staffing needs?

To forecast staffing needs, start with your sales forecast, then apply your target labor percentage to calculate a labor budget. Divide that budget by your average hourly wage to get your total budgeted hours. Break those hours across days based on expected demand, and adjust for known variables like events, PTO, or seasonal shifts.

What tools are used for workforce forecasting?

Workforce forecasting tools range from spreadsheets to dedicated software. The most effective tools for hourly businesses integrate directly with POS systems, show labor vs. sales reporting in real time, include auto-scheduling based on demand, and flag overtime before it happens. Homebase covers all of these in one app.

What is the difference between workforce planning and forecasting?

Workforce planning and forecasting serve different timeframes: planning is long-term and strategic — hiring decisions, role structures, business growth — while forecasting is short-term and operational, predicting how many hours you need this week based on expected demand. Scheduling is the execution layer that turns your forecast into actual shifts.

What is data-driven employee scheduling?

Data-driven employee scheduling means building your schedule based on forecasted sales, historical traffic patterns, and labor targets rather than habit. Instead of copying last week's schedule, you work from a budgeted labor hours target — calculated from your revenue forecast — and build your coverage around that number.

How does workforce forecasting reduce labor costs?

Workforce forecasting reduces labor costs by connecting your staffing decisions to real sales data before you publish the schedule. When you know how many hours you need ahead of time, you avoid overstaffing slow periods and prevent unplanned overtime — leading to fewer surprises on your labor cost line week over week.