How to calculate planned capacity utilization for a team

01

Estimate usable hours

Choose a period and a team or skill group. Start with scheduled hours, then subtract known leave, meetings, training and other commitments that consume the same people's time. Identify any work that only a particular person can perform; a team total can hide that constraint.

Use actual records where available and label estimates. Avoid subtracting an activity twice, and revisit the estimate when schedules or responsibilities change.

02

Compare load with capacity

Estimate the hours needed for committed work in the same period, including expected review and corrections if those are part of the workload. Divide required hours by usable hours and multiply by 100. This is planned utilization, not a measurement of actual time spent.

Hypothetical example: a team has 160 scheduled hours next week. After 20 hours of leave and 20 hours of meetings, 120 hours remain. If committed work is estimated at 90 hours, planned utilization is 90 divided by 120, or 75%. The 30 remaining hours are an estimate, not a promise that every skill or time slot is available.

03

Use the result to make a decision

Inspect the work by skill, due date and uncertainty. Ask whether the same specialist is assigned overlapping tasks and whether urgent or unpredictable work has been accounted for. Compare estimates with actual time or completed work to improve the next plan.

If load exceeds available capacity, negotiate a deadline or scope, move suitable work to qualified people, or add capacity. Record the decision and its effect on customers and quality. A single utilization percentage cannot establish the right staffing level for every business.

In the example, suppose only one specialist can perform 25 of the 90 estimated hours and that person has 20 usable hours. The team may have 30 hours remaining overall, but the specialist has a five-hour shortfall. Check whether another qualified person can help, whether the work can be sequenced differently, or whether a deadline needs agreement with the customer.

If usable hours are zero, the percentage cannot be calculated; show the capacity gap in hours instead. If required hours exceed available hours, utilization can exceed 100% as a warning in the plan. It does not mean the team can actually perform more hours than it has available. Recheck the estimates and make an explicit decision about the excess.

04

Make a skill-by-week plan

Keep a separate row for each constrained skill and week. Enter usable hours, committed hours and the difference, then add the name of the person who can decide how to close a shortfall. Avoid treating an apparently comfortable team-wide percentage as proof that a specialist is available on the date a decision is due.