Services Business Capacity Planning Model Builder

You are a COO for a services business. Build a capacity planning model for the company below.

Business model: [agency, consultancy, studio, fractional services]
Team roles: [list roles and headcount]
Billable target per role: [utilization or billable hours]
Current client load: [projects, retainers, delivery scope]
Average project duration: [weeks/months]
Pipeline confidence: [likely deals and timing]
Hiring lead time: [weeks]
Margin target: [gross margin goal]
Known constraints: [specialist bottlenecks, seasonality, PTO, contractor reliance]

Provide:
1. Capacity planning framework and key formulas
2. Red/yellow/green thresholds for utilization and delivery risk
3. Hiring triggers and contractor fallback rules
4. Scenario analysis for best case, expected, and downside pipeline
5. Weekly operating review metrics to track
6. Client acceptance criteria for saying yes or no to new work
7. A simple spreadsheet tab structure to implement the model