Headcount and capacity planning for a 5,000+ person organization
A digital sports entertainment company plans resource allocation and capacity across engineering and product teams of more than 5,000 employees in Airtable. People Operations and Finance model virtual profit-and-loss views by team and track headcount against project demand, replacing spreadsheet-based workforce models with one shared system for workforce planning decisions.
The problem
Workforce models lived in spreadsheets that grew harder to maintain as the engineering and product organization scaled past 5,000 employees. Cost and capacity tradeoffs at the team level were nearly invisible without manually stitching data together.
Reconciling headcount, project demand, and financial data meant pulling from a data warehouse and an HR system by hand each cycle. When leadership needed to reprioritize, the manual reconciliation slowed the response.
What they built
People Operations, Finance, Engineering, and Product now share a single Airtable system that tracks headcount and capacity across teams, models virtual profit-and-loss views by team, and forecasts demand against capacity.
The base draws from the data warehouse, the issue tracker, the HR system, and the financial planning tool, plus team messaging, a legacy work-management tool being phased out, and the procurement and IT service management platforms that touch resourcing decisions.
The outcome
Capacity and cost visibility is now available in real time at the team level, which gives leadership a faster path to workforce planning decisions than the old spreadsheet models allowed.
Scenario modeling for reprioritization requests runs in the shared base instead of a fresh spreadsheet each time, cutting the manual reconciliation effort that used to slow every planning cycle.
Inside the solution
Resource & Capacity Planning
People & Talent Operations
- Headcount and capacity tracking across engineering and product teams
- Virtual P&L modeling by team
- Demand-vs-capacity forecasting
- Workforce planning scenario modeling
- Spreadsheet-based workforce models that were difficult to maintain at scale
- Limited visibility into team-level cost and capacity tradeoffs
- Manual reconciliation across data warehouse and HR system sources
- Slow response to reprioritization requests
- Real-time capacity and cost visibility for workforce planning
- Faster scenario modeling for leadership decisions
- Reduced manual reconciliation effort
- Scalable model supporting a large distributed workforce
- People Operations
- Finance
- Engineering
- Product
- Data warehouse
- Issue tracker
- HR system
- Legacy work-management tool
- Team messaging
- Financial planning tool
- Procurement platform
- IT service management tool
Resource & Capacity Planning (Engineering/Product)
Track headcount, capacity, and project demand for every engineering and product team in one place, then model virtual P&L by team and test reprioritization scenarios against live data instead of rebuilding a spreadsheet each cycle. Rollups turn allocations into instant capacity-gap and cost signals, automations seed scenario baselines and email a weekly capacity digest, and Airtable AI columns draft the P&L read, staffing-risk assessment, and leadership scenario briefing.
From spreadsheet models to a shared planning system
Copy the templates
Connect the data sources
Model scenarios in place
FAQ
Frequently asked questions
Headcount and role records link to teams and projects, so demand-versus-capacity views roll up automatically instead of requiring a fresh spreadsheet rebuild for each team or cycle.
Each team gets a modeled view of cost against output inside the same base that tracks headcount and capacity, giving Finance and People Operations a consistent lens for workforce decisions.
A connected Airtable system that pulls from the HR system, the data warehouse, and the issue tracker, so headcount, financial, and project data reconcile in one place instead of being stitched together by hand.
Scenario modeling happens directly in the shared base, so leadership can test a reprioritization against current headcount and capacity data without waiting on a manual reconciliation cycle.
Not for the core workforce planning workflows. The structured headcount and capacity data built here is a foundation other AI-enabled workflows across the organization can draw from.