Demand forecasting for small teams: plan capacity ahead

Key takeaways

Demand forecasting for a small business means estimating how much work will arrive over the next 8 to 12 weeks so capacity can be arranged before it is needed. A spreadsheet is enough. Use last year's weekly volumes, adjust for known changes, convert to hours, and plan a base case and a high case.

• Forecast 8 to 12 weeks ahead, by week, for each main process.
• Start from last year's volumes and adjust for what you know.
• Convert volume to hours: volume multiplied by handling time.
• Staff the base case with your team and the high case with flexible capacity.

What is demand forecasting?

Demand forecasting is estimating the future volume of customer demand so a business can plan the resources to meet it. For a small firm that means predicting enquiries, orders, bookings or tickets by week, then translating them into the hours of work they create. It turns capacity from a reaction into a plan.

• How outsourcing helps small businesses scale without hiring
• Headcount vs capacity: what a growing business really needs

Why forecast if you are a small team?

Forecast because every way of adding capacity has a lead time. A hire commonly takes 4 to 12 weeks. A managed seat takes about two. Without a forecast, the first sign of rising demand is a backlog, and by then the only options are overtime and apologies.

• Scaling too fast: the warning signs and how to steady it

How do you build a simple forecast?

Build a simple forecast from history, known events and a growth factor. Pull last year's weekly volumes for the process. Mark what you know is coming, such as campaigns, price changes, contract starts and holidays. Apply your current growth rate. The result will be wrong in detail and right enough to plan with.

• 1. Export last year's weekly volumes.
• 2. Add known events to a calendar.
• 3. Apply the year-on-year growth you are seeing now.
• 4. Produce a base case and a high case 20% above it.

• Seasonal and peak customer service cover

How do you turn a forecast into hours?

Turn volume into hours by multiplying it by average handling time. If 400 enquiries a week take 6 minutes each, that is 40 hours. Add about 15% to 20% for peaks within the week, breaks and absence. Compare the total with the hours your team has for that work, and the difference is the capacity gap.

• How to measure team capacity before you outsource
• How many outsourced seats does a small business need?

How should you staff the forecast?

Staff the base case with permanent people and the gap between base and high case with flexible capacity. That way the fixed team is fully used in a normal week, and peaks are met by hours you can add or remove. Agree with a provider in advance how much notice is needed to change hours.

• Scaling an outsourced team up and down: how it works
• Overflow outsourcing: hand off only work above your limit

How accurate does a forecast need to be?

A forecast needs to be accurate enough to choose between options, not exact. Being within 10% to 15% over a month is good for a small business. Review it weekly against actuals and adjust. The discipline of comparing forecast with reality is worth more than a sophisticated model.

• The weekly operations review that keeps a lean team on track

When is forecasting not worth the effort?

Forecasting is not worth much effort where volume is tiny or completely steady. If a process takes five hours a week all year, plan it once and move on. Brand new products have no history either: use a range, watch the first weeks closely and keep capacity flexible until a pattern appears.

• Unpredictable workload? Why fixed staffing struggles

What does this look like in practice?

A pattern we see in UK firms with seasonal demand: the same weeks are frantic every year, and every year they come as a surprise. Putting two years of weekly enquiry counts on one chart usually shows the peaks to within a fortnight, which is enough notice to arrange extra hours before the inbox fills.

• See client work
• BPO Solutions for UK businesses

Demand forecasting checklist

Set this up once and update it weekly.

• Choose the three processes that drive most hours.
• Record weekly volume for each, going back a year.
• Record average handling time for each.
• Mark known events for the next 12 weeks.
• Calculate hours needed for base and high cases.
• Compare with hours available and note the gap.
• Review forecast against actual every week.

• A 90-day plan to scale without adding headcount
• Workforce planning for growth: roles to hire, roles to buy

Next step

Send us a year of weekly volumes for your busiest process. We will help you turn it into a 12-week forecast and a capacity plan.