How to Track Backlog and Capacity Before Your Schedule Breaks
Sales has a great month.
The pipeline is full.
Quotes are being approved.
Everyone is happy.
Then operations looks at the calendar and realises:
There is nowhere to put the work.
Jobs start getting pushed back.
Customers wait longer.
Technicians get overloaded.
And the business only discovers the capacity problem after it has already sold too much work.
Backlog should not just tell you how much work you have.
It should tell you whether you can actually deliver it.
Start With Approved Work
Not every quote belongs in your operational backlog.
A useful backlog normally begins when work has genuinely been won.
For example:
Quote Approved
or:
Deposit Received
or:
Contract Signed
That gives you the work operations should reasonably expect to deliver.
You can then measure it in:
- jobs,
- labour hours,
- days of work,
- revenue,
- or another unit that makes sense for the business.
Convert Backlog Into Workload
Ten jobs does not tell you much if one takes two hours and another takes two weeks.
A better measure might be:
Approved Labour Hours
For example:
Current Backlog: 1,200 labour hours
Now compare that against what the team can actually deliver.
Calculate Available Capacity
Suppose you have:
8 technicians
Each has roughly:
32 productive hours available per week
after allowing for travel, admin and other non-job time.
That gives you:
256 productive hours per week.
With 1,200 hours of approved work, you have roughly:
4.7 weeks of backlog.
That is much more useful than simply saying:
“We have 38 jobs waiting.”
Look Ahead by Week
Capacity becomes even more useful when you forecast it.
For example:
Week 1
Available: 256 hours
Committed: 240 hours
Week 2
Available: 256 hours
Committed: 310 hours
Week 3
Available: 256 hours
Committed: 335 hours
Now you can see the problem forming before the schedule physically runs out of space.
Include Work That Is Not Ready Yet
Some approved jobs cannot be scheduled immediately.
They may be waiting for:
- materials,
- customer selections,
- permits,
- site readiness,
- deposits,
- or internal approval.
Keep those jobs visible separately.
For example:
Ready to Schedule: 420 hours
Waiting for Materials: 360 hours
Waiting on Customer: 180 hours
Other Approved Backlog: 240 hours
That helps operations understand both today's workload and what is about to arrive.
Watch for Backlog Growth
A healthy backlog may be desirable.
A growing backlog can also indicate a capacity problem.
Suppose:
Four weeks ago: 3.2 weeks backlog
Today: 5.8 weeks backlog
If sales volume has increased but delivery capacity has not, waiting times will probably continue growing.
That trend is more useful than one snapshot.
Track Capacity by Skill
Not every technician can perform every job.
You may have plenty of total labour hours available but still lack the right capacity.
For example:
General technicians: plenty available
Qualified installers: fully booked for 5 weeks
That bottleneck can delay a specific category of work even while the rest of the team appears underutilised.
Track important skills separately where necessary.
Include Leave and Known Downtime
Nominal headcount is not real capacity.
If three technicians are on leave next week, capacity changes.
The same applies to:
- training,
- public holidays,
- vehicle downtime,
- internal meetings,
- or planned non-chargeable work.
Your forecast should reflect what the team can realistically deliver.
Use Capacity to Inform Sales
This information should not live only with operations.
Sales may need to know:
Current lead time: 2 weeks
or:
Installation backlog: 6 weeks
or:
Earliest available start: 17 November
That allows customers to receive realistic expectations before they approve the work.
The goal is not to stop selling.
It is to sell with visibility.
Surface the Problem Before Customers Feel It
A useful dashboard might show:
Backlog: 1,200 hours
Available next 4 weeks: 1,024 hours
Capacity Gap: 176 hours
Now management has time to respond.
You might:
- move non-urgent work,
- hire temporary labour,
- increase subcontractor capacity,
- adjust sales lead times,
- change crew allocation,
- or prioritise higher-value jobs.
That is much better than discovering the problem because customers start complaining.
Start With the Next Four Weeks
Take all approved jobs waiting to be completed.
Estimate the labour required.
Then calculate the realistic capacity of the team over the next four weeks.
Compare:
Work Required
against:
Capacity Available
If the numbers do not fit, your schedule already has a future problem.
At 5M Consulting, we help trade and service businesses connect sales, scheduling and operational data so workload and capacity become visible before the calendar breaks.
Winning more work is good.
Knowing whether you can deliver it is better.