One of the most important questions in project planning is also one of the easiest to get wrong: How much work can our team actually handle?
Looking at headcount alone is not enough. A five-person team working 40 hours per week does not necessarily provide 200 hours of usable project capacity. Meetings, PTO, administrative work, support requests, existing assignments, and other responsibilities all reduce the amount of time available for projects.
This guide shows you how to calculate team capacity for projects using a straightforward process you can apply to individual teams, departments, or multiple projects.
What Is Team Capacity?
Team capacity is the amount of time a team realistically has available to complete planned work during a specific period.
A person's 40-hour workweek may include meetings, internal work, support, training, PTO, and other activities. Capacity planning attempts to identify the portion that can realistically be committed to project work.
The Basic Team Capacity Formula
You can calculate this for each team member and then add the results together to determine total team capacity.
Another useful approach is to use an availability percentage:
For example, if someone works 40 hours per week and approximately 75% of that time can be dedicated to projects:
How to Calculate Team Capacity Step by Step
Decide whether you are calculating capacity by week, sprint, month, quarter, or another planning period.
Determine the normal working hours available for every person during that period.
Remove holidays, PTO, planned leave, training, and other known unavailable periods.
Account for recurring meetings, administration, support, management responsibilities, and operational work.
Combine each person's available project hours to determine total team capacity.
Compare available capacity against planned project hours to identify shortages or unused capacity.
Team Capacity Calculation Example
Imagine a four-person project team. Each person's working schedule and project availability are different.
| Team Member | Working Hours | Project Availability | Project Capacity |
|---|---|---|---|
| Sarah | 40 hrs | 80% | 32 hrs |
| Michael | 40 hrs | 75% | 30 hrs |
| David | 32 hrs | 75% | 24 hrs |
| Jessica | 40 hrs | 70% | 28 hrs |
The team technically works 152 hours per week, but only 114 hours are realistically available for planned project work.
If upcoming projects require 130 hours, the team has a capacity gap:
The team is short by 16 hours. That gives the project manager a chance to adjust scope, dates, assignments, or staffing before making an unrealistic commitment.
How to Calculate Team Utilization
Capacity tells you how much work can be performed. Utilization tells you how much of that capacity has already been allocated.
If your team has 114 hours of available project capacity and 95 hours have already been assigned:
The remaining capacity is 19 hours.
Calculating Capacity Across Multiple Projects
Capacity becomes harder to understand when employees contribute to several projects. Instead of evaluating each project independently, combine all assignments into one capacity view.
| Resource | Capacity | Project A | Project B | Project C | Total Allocated | Remaining |
|---|---|---|---|---|---|---|
| Sarah | 32 | 15 | 10 | 0 | 25 | 7 |
| Michael | 30 | 18 | 8 | 10 | 36 | -6 |
| David | 24 | 8 | 8 | 0 | 16 | 8 |
| Jessica | 28 | 5 | 10 | 8 | 23 | 5 |
How to Calculate Capacity for a Sprint
The same concept can be used for Agile teams. Start with the number of working days in the sprint, subtract unavailable days, then apply a realistic amount of productive project time per day.
For example, a developer has 10 working days in a sprint but will be on PTO for two days:
Repeat the calculation for each team member to estimate total sprint capacity. If your team uses story points, historical velocity can complement capacity calculations rather than replacing them.
What Should Be Included in Team Capacity?
- Normal working hours
- Part-time schedules
- Public holidays
- Vacation and PTO
- Recurring meetings
- Administrative responsibilities
- Support and operational work
- Training
- Existing project assignments
- Planned upcoming assignments
The goal is not to calculate every minute perfectly. The goal is to create a realistic planning baseline that is more useful than simply multiplying headcount by 40 hours.
Common Team Capacity Planning Mistakes
Using headcount instead of availability
Five employees do not automatically equal five full-time project resources. Their actual availability may vary significantly.
Ignoring work outside the project
Support requests, management responsibilities, internal initiatives, and meetings still consume time.
Planning every hour
A plan with no flexibility can quickly become unrealistic when priorities change or unexpected work arrives.
Ignoring cross-project allocations
Shared resources need to be evaluated across every project they support.
Only looking at current capacity
Capacity planning is most useful when it includes upcoming projects and future demand.
Can You Calculate Team Capacity in Excel?
Yes. For smaller teams, an Excel or Google Sheets capacity plan can work well. Create columns for each resource's working hours, availability percentage, project capacity, current allocation, utilization, and remaining capacity.
As teams grow, spreadsheets often become harder to maintain because availability and assignments change continuously across multiple projects.
Calculating Capacity with Resource Planning Software
Resource planning software can make capacity calculations easier by connecting availability directly with project assignments and schedules.
Instead of manually updating several spreadsheets, managers can use a centralized view to understand:
- Who is available for upcoming work
- Who is overallocated
- How projects compete for the same resources
- How much capacity remains by person or team
- Where future resource shortages may occur
- How workload changes when project schedules move
See Team Capacity and Project Work Together
KolApp combines resource scheduling with project management so you can plan availability, allocate people across projects, understand workloads, and spot capacity problems earlier.
Explore KolAppTeam Capacity FAQ
How do you calculate team capacity for a project?
Calculate each person's available project hours after subtracting PTO, holidays, meetings, operational work, and other commitments. Add those individual capacity figures together to determine total team capacity.
What is the formula for team capacity?
A basic formula is working hours minus unavailable time and non-project commitments. You can also multiply working hours by a realistic project availability percentage.
What is the difference between capacity and utilization?
Capacity represents the amount of work a team can realistically perform. Utilization measures how much of that capacity has already been allocated or used.
Should teams be scheduled at 100% capacity?
Scheduling every available hour leaves little flexibility for unexpected work, meetings, support requests, and project changes. A realistic target depends on the type of team and work.
How do you calculate capacity across multiple projects?
Add all project allocations for each shared resource and compare the total with that person's available capacity. This exposes conflicts that may be hidden when projects are viewed independently.
Make Capacity Part of Project Planning
Calculating team capacity does not need to be complicated. Start with real availability, subtract known non-project commitments, total the remaining project hours, and compare them with demand.
The more projects and shared resources you manage, the more valuable a centralized capacity view becomes. It helps turn the question from “Do we think we have enough people?” into “We know exactly how much capacity is available.”