Department Mix
Hours by Department
Selected year
Billed Revenue by Department
Selected year
Headcount Mix
120 active employees
Cost vs Bill Rate
Avg by department
Hours per FTE
Total hours ÷ headcount, by dept
Department Detail
Department Performance
Filtered by department selection.
| # | Department | Headcount | Hours (M) | Billed | Avg Margin | Cost Rate | Bill Rate | Bill/Hour |
|---|
Source: FACT_PROJECTS × DIM_EMPLOYEE. Total headcount 120 (42 Creative · 24 Strategy · 24 Production · 18 Media · 12 Account). Hours/FTE estimate uses HOURS_ACTUAL ÷ headcount; no PTO/holiday adjustment in source. Reconciles to VALIDATION_BENCHMARKS.md.