Capacity Planning with Time Tracking

Overview

Capacity planning uses time tracking data to understand team availability and workload, enabling informed decisions about project staffing, hiring needs, and deadline feasibility. It answers: "Do we have enough people with the right skills to take on this work?"

Key Metrics

Available Capacity

Total hours available for project work:

• Calculation: (Team Size × 40 hours) - (PTO + Holidays + Meetings + Admin)
• Example: 10 people × 40 hours = 400 hours
  • Minus 10% meetings/admin = 360 hours
  • Minus PTO/holidays = 340 hours available

Utilization Rate

Percentage of available time being used:

• Formula: (Assigned Hours / Available Hours) × 100
• Target: 70-85% (allows flexibility for emergencies)
• Red Flag: >90% (burnout risk), <60% (underutilized)

Capacity vs. Demand

• Capacity: What team can deliver
• Demand: What's requested/needed
• Gap: Difference requiring hiring or scope reduction

The Process

1. Calculate Available Capacity

For each team member:

• Scheduled hours (typically 40/week)
• Minus planned time off
• Minus average non-project time (meetings, admin)
• Minus buffer for emergencies (10-15%)

2. Assess Current Allocation

Time tracking reveals:

• Hours already committed to active projects
• Remaining capacity per person
• Skills/roles available vs. committed

3. Forecast Future Demand

Upcoming projects need:

• Estimated hours by role/skill
• Timeline requirements
• Priority level

4. Identify Gaps

Compare capacity vs. demand:

• Overallocated: More work than capacity (need to hire, delay, or descope)
• Underutilized: More capacity than work (opportunity for growth or efficiency concern)
• Skill Mismatch: Wrong skills available for work needed

5. Make Decisions

• Hire contractors/employees to fill gaps
• Delay lower-priority projects
• Reallocate team members
• Adjust project scopes
• Cross-train for skill gaps

Common Scenarios

Scenario 1: New Project Request

Question: Can we take on 200-hour project next month?

Analysis:

• Team has 340 hours available capacity
• Currently allocated: 280 hours
• Remaining: 60 hours
• Decision: No, insufficient capacity. Options:
  • Delay project 1-2 months
  • Hire contractor
  • Descope to 60-hour MVP

Scenario 2: Multiple Deadlines

Question: Can we deliver Projects A, B, C by end of quarter?

Analysis:

• Total hours needed: 500
• Team capacity over period: 420
• Gap: 80 hours (19% short)
• Decision:
  • Extend Project C deadline
  • Or bring in 1 contractor for 8 weeks

Scenario 3: Team Member Leaving

Question: Impact of losing Senior Developer?

Analysis:

• They're allocated 120 hours over next 6 weeks
• No one else has capacity to absorb
• Projects at risk: Projects X, Y
• Decision: Hire replacement immediately or delay Projects X/Y

Tools & Features

Capacity planning tools typically offer:

• Visual capacity heatmaps
• Drag-and-drop resource allocation
• "What-if" scenario modeling
• Skills matrix integration
• Utilization dashboards
• Forecasting based on historical data
• Alerts for overallocation

Popular Tools: Celoxis, Float, Resource Guru, Forecast, Productive.io, Kantata

Benefits

• Prevent Burnout: Avoid overallocating team members
• Maximize Revenue: Ensure billable capacity is utilized
• Realistic Commitments: Don't overpromise to clients
• Informed Hiring: Know when and what skills to hire
• Better Forecasting: Project completion dates based on actual capacity
• Workload Balance: Distribute work evenly across team

Implementation Tips

1. Start Simple: Track utilization for 1 month before complex forecasting
2. Be Conservative: Assume 70% productive capacity, not 100%
3. Account for Everything: Meetings, PTO, admin reduce project time
4. Update Weekly: Capacity planning is ongoing, not one-time
5. Include Skills: Hours available means nothing if wrong skills
6. Communicate: Share capacity constraints with sales/leadership