Timesheet Capacity & Overhead Analysis

Hours by client and task type, normalized across multi-tag entries to separate delivery work from communication, admin, and chaos overhead.

Total logged hours
--
--
Billable delivery
--
--
Non-billable overhead
--
--
Biggest overhead burden
--
--
Key takeaways
  • Portfolio mix
  • Biggest non-billable burden
  • Billable capacity concentration
  • Client mix
Normalization rule used in this analysis

Overhead: comm*, misc/*, _chaos Billable: design, eng, data, research, other tagged delivery

This makes mixed entries comparable across charts: if one time entry carries multiple tags, its duration is split evenly across those tags before totals are rolled up.
Hours by client: billable delivery vs non-billable overhead
What drives non-billable hours for the highest-burden clients
Billable capacity by task family and task type
Top billable task types consuming capacity
Billable family mix by client
Client scale vs overhead share
Client summary
Client Total hours Billable Overhead Overhead share Dominant billable family Top overhead driver