Labor Forecasting: How to Forecast Staffing Needs for 2027 (Free Template)
Build the schedule once, share it with everyone. Who’s working, who’s out and who swapped, all in one view.
14 days free. No credit card needed. Cancel anytime.
Quick Answer
Labor forecasting is estimating how many employee hours, and how many people, you will need in each future period to meet demand. To forecast staffing needs for 2027, pull last year's actual hours and demand (sales, orders, jobs or customers), calculate how many labor hours each unit of demand takes, apply your 2027 demand forecast by month or week, add time for training, meetings and time off, then compare required hours to the hours your current team can work. The gap tells you when to hire, add part-time help or cut hours. Copy the free labor forecast template below.
Labor forecasting is how you find out in January that you'll be short-staffed in June, instead of finding out in June. Most small businesses schedule week by week, which works until a busy season, a big contract or a wave of vacations hits all at once. A labor forecast looks ahead and answers a simple question: how many hours of work will we need, and do we have the people to cover them?
This guide walks through how to forecast staffing needs for 2027 using data you already have: last year's hours from your time clock, your sales or job volume and your PTO calendar. You'll get a step-by-step method, a worked example, the common mistakes to avoid and a free labor forecast template you can copy into a spreadsheet.
What Is Labor Forecasting?
Labor forecasting, also called workforce forecasting or staffing forecasting, estimates the labor hours a business will need over a future period, usually by month or week, and turns those hours into headcount and schedules. It sits between two other planning tools. A labor budget sets how much you can spend on labor, and a schedule assigns specific people to specific shifts. The forecast connects them: it tells you how many hours the work requires so you can check whether the budget is realistic and the schedule is possible.
| Tool | Answers | Time frame |
|---|---|---|
| Labor forecast | How many hours and people will we need? | Months to a year ahead |
| Labor budget | How much can we spend on labor? | Year, quarter or month |
| Minimum staffing level | How many people must be on each shift? | Per shift |
| Work schedule | Who works when? | One to four weeks |
Why Forecast Staffing Needs for 2027?
- Hire before you're desperate. Hiring and training take weeks. A forecast tells you when to start.
- Control overtime. Overtime is often the cost of not seeing demand coming.
- Avoid overstaffing. Slow months cost money when you schedule the same as busy ones.
- Plan time off. You can approve vacations confidently when you know which weeks have room.
- Set a realistic labor budget. The budget should come from the work, not from last year plus a percentage.
- Protect your people. Chronic understaffing leads to burnout and turnover, which makes the next forecast even harder.
The Data You Need for a Labor Forecast
You don't need special software to start. You need a year of history and a reasonable guess about next year. The more accurate your time records, the better your forecast.
| Data | Where it comes from | Why it matters |
|---|---|---|
| Actual hours worked by week or month | Time clock reports | The baseline for how much labor the work took |
| Hours by role, department or job | Time clock with job or department codes | Different work needs different people |
| Demand driver | Sales, orders, tickets, jobs, patients, rooms, customers | Labor follows demand |
| Overtime hours | Time clock overtime report | Shows where you were already short |
| Time off taken | PTO records and vacation calendar | Hours employees were paid but not working |
| Turnover and hiring dates | HR records | Shows gaps when positions were open |
| Known 2027 changes | Owners and managers | New locations, contracts, hours, price changes |
If your hours are on paper time cards or in several places, start by getting one clean number of hours worked per week for the last year. Even a rough baseline is better than guessing. For tracking hours by department, see the labor distribution report guide.
How to Forecast Staffing Needs in 7 Steps
1. Choose your demand driver
Pick the one number that most closely drives your labor. For a restaurant it's covers or sales. For a warehouse it's orders or units shipped. For a cleaning company it's jobs or square feet. For a service shop it's work orders. If you can't find one, use sales; it's rarely perfect but usually close.
2. Calculate your labor standard
A labor standard is the number of labor hours needed per unit of demand. Divide last year's productive hours by last year's demand for the same period. For example, if your crew worked 9,600 hours and completed 1,200 jobs, your standard is 8 labor hours per job. Calculate it by month if your work changes with the season, because a winter job and a summer job may not take the same time.
Labor standard = productive hours worked ÷ units of demand
Required hours = forecast demand × labor standard
3. Forecast 2027 demand
Start with last year's demand by month and adjust for what you know: growth trends, signed contracts, price changes, new locations, lost customers and marketing plans. Keep it simple and write down every assumption. A forecast you can explain is more useful than a precise one you can't.
4. Convert demand into required hours
Multiply each month's forecast demand by your labor standard. Add fixed hours that don't change with demand, like opening and closing, a manager on duty or a front desk that must be staffed regardless of traffic. Your minimum staffing levels set the floor; required hours should never drop below it.
5. Add non-productive time
Employees aren't working on demand every hour they're paid. Add hours for training, meetings, onboarding new hires, travel between jobs and paid breaks if you pay for short breaks. Then account for time off: vacation, sick days and holidays. A common mistake is to forecast productive hours and then schedule exactly that, leaving no room for anyone to be out.
6. Compare required hours to available hours
Available hours are what your current team can realistically work: each employee's scheduled hours, minus planned time off. Subtract available hours from required hours for each month. A positive number is a gap you'll need to cover with hiring, part-time help, overtime or a temp agency. A negative number means you're overstaffed and may need to cut hours or move people.
7. Turn the gap into a staffing plan
Divide the gap by the hours one employee typically works in that period to get headcount. If June needs 640 more hours and a full-time employee works about 173 hours a month, you need roughly 3.7 more full-time equivalents, which might be two full-time hires plus two part-time seasonal workers. Then work backward: if hiring and training take six weeks, you need to post jobs by mid-April.
Worked Example: A Landscaping Company Forecasts 2027
A landscaping company has 10 crew members. Last year, crews worked 16,800 productive hours and completed 2,100 jobs, a labor standard of 8 hours per job. For 2027, the owner expects 10% growth and has signed a new commercial contract that adds about 30 jobs a month from April through October.
| Month | 2026 jobs | 2027 forecast jobs | Required hours (× 8) | + non-productive (10%) | Available hours | Gap |
|---|---|---|---|---|---|---|
| January | 60 | 66 | 528 | 581 | 1,200 | -619 |
| April | 230 | 283 | 2,264 | 2,490 | 1,560 | +930 |
| June | 280 | 338 | 2,704 | 2,974 | 1,600 | +1,374 |
| August | 260 | 316 | 2,528 | 2,781 | 1,440 | +1,341 |
| November | 120 | 132 | 1,056 | 1,162 | 1,520 | -358 |
The forecast shows the company is short more than 1,300 hours in June and August, which is roughly seven to eight full-time equivalents. Even with heavy overtime, 10 people can't cover it. The owner plans to hire four seasonal crew members by March, add two part-time helpers for peak months and limit vacation from June through August. In January and November, available hours exceed required hours, so those are the months to schedule training, equipment maintenance and approve longer vacations.
Free Labor Forecast Template
Copy this template into Excel or Google Sheets. Fill in one row per month (or per week for more detail). The formulas are written as instructions so you can build them in any spreadsheet.
| Month | Last year demand | Forecast demand | Labor standard (hrs per unit) | Required hours (demand × standard) | Fixed hours | Non-productive hours | Total required hours | Team available hours | Planned PTO hours | Net available hours | Gap (required − net available) | FTEs needed (gap ÷ hrs per FTE) | Plan |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| January | |||||||||||||
| February | |||||||||||||
| March | |||||||||||||
| April | |||||||||||||
| May | |||||||||||||
| June | |||||||||||||
| July | |||||||||||||
| August | |||||||||||||
| September | |||||||||||||
| October | |||||||||||||
| November | |||||||||||||
| December |
2027 Labor Forecast Assumptions
Demand driver: [sales / orders / jobs / customers]
Baseline period: [Jan–Dec 2026]
Labor standard: [X] hours per [unit], calculated from [source]
Growth assumption: [X]% because [reason]
Known changes: [new contract, new location, price change, lost customer]
Hours per FTE: [X] hours per month
Non-productive time: [X]% for training, meetings and travel
Time off: [X] hours per employee per year, heaviest in [months]
Hiring lead time: [X] weeks from posting to fully trained
Review date: [monthly / quarterly], owner: [name]
Forecasting Methods: Which One Fits Your Business?
| Method | How it works | Best for | Limitation |
|---|---|---|---|
| Last year plus growth | Last year's hours × growth rate | Stable businesses | Repeats last year's mistakes |
| Labor standard (driver-based) | Forecast demand × hours per unit | Most small businesses | Needs a clear demand driver |
| Moving average | Average of recent weeks to predict the next | Short-term weekly scheduling | Misses seasonal swings |
| Seasonal index | Each month's share of the annual total | Seasonal businesses | Needs at least one, ideally two, years of data |
| Interval forecasting | Demand by hour or 15-minute block | Call centers, restaurants, retail floors | More data and time to build |
Most small businesses get the best results from the labor standard method, adjusted with a seasonal index. It's simple enough to update monthly and accurate enough to make hiring decisions.
Seasonality, Holidays and Time Off
Seasonal patterns are often the biggest driver of a staffing gap. Look at each month's share of last year's total demand. If June was 12% of the year and January was 4%, you need three times the labor in June, and your forecast should show that. Also account for the calendar itself: months with more workdays, holidays when you're closed and weeks when many employees take vacation. See how many working days are in 2027 for monthly workday counts.
Time off is easy to forget. If each full-time employee takes 15 days of vacation and holidays plus a few sick days, that's close to 150 hours a year per person that the schedule must cover with someone else. Spread across a 10-person team, that's nearly a full-time employee's worth of hours. For seasonal hiring, see the complete guide to seasonal hiring.
Predictive Scheduling Laws Make Forecasting More Important
Some states and cities have predictive scheduling, or fair workweek, laws that require certain employers to post schedules in advance and may require extra pay for late changes. For example, Oregon requires covered retail, hospitality and food service employers with at least 500 employees worldwide to provide written schedules at least 14 calendar days in advance. If you operate in a city or state with these rules, a reliable forecast helps you publish accurate schedules on time and avoid costly last-minute changes. Check your local labor department for the rules that apply to you, and see how far in advance you should post work schedules.
Common Labor Forecasting Mistakes
- Using scheduled hours instead of actual hours. Schedules show the plan; time clock data shows what the work really took.
- Forgetting overtime. If last year needed 800 overtime hours, your baseline was already short.
- Ignoring open positions. Months when a role was vacant make the work look like it needed fewer hours.
- Forecasting once a year. Update monthly with actuals; the forecast should get better as the year goes on.
- One number for the whole business. Forecast by role or department; a surplus of servers doesn't fix a shortage of cooks.
- No room for time off. A forecast that assumes 100% availability guarantees overtime.
- Hiring too late. The gap shows up in the month of need; the hiring starts weeks earlier.
Forecast vs. Actual: Keep It Honest
A forecast gets better only when you compare it to what happened. At the end of each month, put forecast hours next to actual hours worked and actual demand. If actual hours per unit are higher than your standard, find out why: new employees still learning, a process problem, equipment issues or simply a standard that was too optimistic. Then adjust the rest of the year. See scheduled vs. actual hours for how to track the difference week by week.
| Metric | Formula | What it tells you |
|---|---|---|
| Forecast accuracy | 1 − |actual − forecast| ÷ actual | How close the forecast was |
| Hours per unit | Actual hours ÷ actual demand | Whether productivity matched the standard |
| Overtime % | Overtime hours ÷ total hours | Whether you were short-staffed |
| Labor cost % | Labor cost ÷ revenue | Whether staffing matched the budget |
Who Should Own the Labor Forecast?
In a small business, the owner or operations manager usually owns the forecast, with input from each department lead. Department leads know what's coming: a big order, a retiring employee, a new piece of equipment that will speed things up. The owner knows the financial side: growth targets, contracts and budget. A 30-minute monthly review with both, looking at forecast versus actual and the next three months, is usually enough to keep it accurate.
Spreadsheet Forecast or Software?
A spreadsheet is a perfectly good place to build and run a labor forecast, especially when one person owns it. The challenge is the input: pulling actual hours by month, role and job from wherever they live, and matching them to time off and schedules. When hours, PTO and schedules come from the same system, the forecast takes minutes to update instead of an afternoon of copying and pasting.
Final Thoughts
Labor forecasting doesn't have to be complicated. Pick a demand driver, calculate how many hours each unit of work takes, apply your 2027 demand forecast, add room for training and time off and compare it to the hours your team can actually work. The gaps tell you when to hire, when to bring in seasonal help and when to approve vacation. Update it monthly with real numbers and it becomes one of the most useful tools you have.
Forecast Staffing Needs With Updoot
A good forecast starts with accurate hours. Updoot's employee time clock records actual hours by employee, job and location, with an overtime dashboard and reports you can export to build your forecast. The PTO calendar shows planned time off and capacity by day, so you can see available hours before you approve more vacation, and advanced scheduling lets you build, suggest and swap shifts by job, location and capacity once you know how many people each week needs.
Projects and job tracking show how many hours each job really took, which is the labor standard your forecast depends on. See the Updoot pricing page for current plans, and start a free trial to test it with your team.
Sources
Related Reading