Billable Hours Matrix 2.0 Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQR
1
(Blue cells contain inputs that could be adjusted)
2
Monthly costs$30,000.00
3
Target effective billing rate$20.00<< The calculations below assume all client-related hours are counted as billable, and that "unbillable" hours simply affect this rate.
4
Hours per week40
5
6
Weekly hours allocations
7
Maximum UtilizationRealistic Utilization
8
StaffPositionWkly hrsBillable utilization rateUnbillable hrsBillable hrsPTOClient/sales unbillable travelPresentation prepConferencesInternal meetingsD.O contributionsBlogging, sales & marketingAdditional undirected, unbillable hrsInternal projectsTotal unbillable hrsBillable hrsBillable utilization rate
9
Marvin GayeCEO400%4004.64.08.04.06.00.010.003.440.020.00%
10
Brenda Holloway
Operations director
400%4004.60.02.04.06.00.00.0914.440.020.00%
11
Gladys KnightTechnical director4030%28124.60.00.04.04.00.010.004.627.2212.832%
12
Martha ReevesCreative director4030%28124.60.02.04.04.00.010.003.428.0212.030%
13
Smokey RobinsonSales director400%4004.64.04.04.02.00.020.001.540.12-0.10%
14
David RuffinDesigner4070%12284.60.01.01.52.00.03.00012.1227.970%
15
Diana RossDesigner4070%12284.60.01.01.52.00.03.00012.1227.970%
16
Tammi TerrellSolutions Architect4070%12284.61.00.01.52.00.02.00112.1527.870%
17
Mary WellsSolutions Architect 4070%12284.61.00.01.52.00.02.00112.1527.870%
18
Stevie WonderEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
19
Syreeta WrightEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
20
Bobby DarinEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
21
Michael JacksonEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
22
Rick JamesEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
23
Mary WilsonEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
24
Erykah BaduEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
25
Teena MarieEngineer4080%8324.60.00.01.51.52.00.0009.6530.376%
26
Sam HarrisProject Manager400%4004.61.00.01.54.00.00.020940.15-0.20%
27
Brian McKnightProject Manager400%4004.61.00.01.54.00.00.020940.12-0.10%
28
Lionel RichieMarketing400%4004.61.08.03.04.00.016.003.440.020.00%
29
New Hire Engineer4080%8324.60.00.01.51.52.00.0009.6530.376%
30
New Hire Engineer4080%8324.60.00.01.51.52.00.0009.6530.376%
31
New Hire Engineer4080%8324.60.00.01.51.52.00.0009.6530.376%
32
432488450.39469.6
33
34
Below calculations are for current team only - "new hires" have been excluded
35
Revenue projections with current team configurationAdditional findings with current team configuration
36
WeeklyMonthlyAnnuallyWeeklyMonthlyAnnually
37
Max revenue$9,408.00$40,454.40$489,216.00Internal meetings (hrs)54.0232.22,808.0
38
Max profit$2,431.26$10,454.40$125,452.80D.O contributions16.068.8832.0
39
Max profit margin26%
Client/sales unbillable travel
13.055.9676.0
40
Realistic revenue$9,085.66$39,068.34$472,454.40Presentation prep, conferences, blogging, S&M146.4629.67,614.0
41
Realistic profit$2,108.92$9,068.34$108,820.14Realistic billable hours378.61,627.819,685.6
42
Realistic profit margin23%Billable utilization - all staff51%
43
Realistic billable hours dev team311.21338.416060.3
44
Maximum billable dev team324.01393.216718.4
Loading...
Main menu