>
Salaried Employee
A
B
C
D
E
F
G
H
1
2
Professional Services Billable
Rate Calculator (Salaried Employee)
3
4
Yearly
Monthly
Weekly
Hourly
Portion of Rate
5
1. Salary
$
55,000
$ 4,583
$ 1,058
$ 26.44
$ 40.76
6
7
2. Benefits
19.71%
$ 10,840
$ 903
$ 208
$ 5.21
$ 8.03
8
Medical & Vision Insurance
5%
$ 3,000
$ 250
$ 58
$ 1.44
$ 2.22
9
Dental Insurance
1%
$ 600
$ 50
$ 12
$ 0.29
$ 0.44
10
Disability & Life Insurance
0%
$ 240
$ 20
$ 5
$ 0.12
$ 0.18
11
Transportation
1%
$ 600
$ 50
$ 12
$ 0.29
$ 0.44
12
Training & Education
4%
$ 2,000
$ 167
$ 38
$ 0.96
$ 1.48
13
IRA/401K Matching Contributions
3%
$ 1,650
$ 138
$ 32
$ 0.79
$ 1.22
14
Bonus
5%
$ 2,750
$ 229
$ 53
$ 1.32
$ 2.04
15
16
3. Taxes
9.73%
$ 5,350
$ 446
$ 103
$ 2.57
$ 3.96
17
FICA & Medicare
7.65%
$ 4,208
$ 351
$ 81
$ 2.02
$ 3.12
18
Disability Insurance
6.12%
$ 127
$ 11
$ 2
$ 0.06
$ 0.09
19
Unemployment Insurance
3.36%
$ 1,015
$ 85
$ 20
$ 0.49
$ 0.75
20
21
Total Compensation
1.29
$ 71,190
$ 5,932
$ 1,369
$ 34.23
$ 52.76
22
23
4. Overhead Contribution
60%
$ 42,714
$ 3,559
$ 821
$ 20.54
$ 31.66
24
25
Total Personnel Cost
2.07
$ 113,903
$ 9,492
$ 2,191
$ 54.77
$ 84.41
26
27
5. Profit
20%
$ 22,781
$ 1,898
$ 438
$ 10.95
$ 16.88
28
29
Total Revenue Target
2.49
$ 136,684
$ 11,390
$ 2,629
$ 65.72
$ 101.30
30
31
6. Available Hours
1,836
152.99
35.31
7.06
32
Total Hours
2,080
173.32
40.00
8.00
33
Vacation
80
6.67
1.54
0.31
34
Sick Time
40
3.33
0.77
0.15
35
Holidays
64
5.33
1.23
0.25
36
Training
60
5.00
1.15
0.23
37
38
7. Utilization Rate
75.0%
1,560
129.99
30.00
6.00
39
Utilization Rate (Effective)
66.2%
1,377
114.74
26.48
5.30
40
41
8. Billable Rate
98.0%
1,529
127.39
29.40
5.88
42
Billable Rate (Effective)
64.9%
1,349
112.45
25.95
5.19
43
44
Hourly Rate
$ 101.30
45
46
What
Happens to Profit if?
47
Hourly Rate Changes to:
$ 105.00
$ 23,828
$ 1,986
$ 458
$ 11.5
48
Utilization Rate Changes to:
77.5%
$ 4,556
$ 380
$ 88
$ 2.2
49
50
51
Contractor
A
B
C
D
E
F
G
H
1
2
Professional Services Billable
Rate Calculator (Contractor)
3
4
Yearly
Monthly
Weekly
Hourly
Portion of Rate
5
1. Salary
$ 124,704
$ 10,392
$ 2,400
$
60.00
$ 60.00
6
7
2. Benefits
0.00%
$ -
$ -
$ -
$ "-"
$ "-"
8
Medical & Vision Insurance
0%
$ -
$ -
$ -
$ "-"
$ "-"
9
Dental Insurance
0%
$ -
$ -
$ -
$ "-"
$ "-"
10
Disability & Life Insurance
0%
$ -
$ -
$ -
$ "-"
$ "-"
11
Transportation
0%
$ -
$ -
$ -
$ "-"
$ "-"
12
Training & Education
0%
$ -
$ -
$ -
$ "-"
$ "-"
13
IRA/401K Matching Contributions
0%
$ -
$ -
$ -
$ "-"
$ "-"
14
Bonus
0%
$ -
$ -
$ -
$ "-"
$ "-"
15
16
3. Taxes
0.00%
$ -
$ -
$ -
$ "-"
$ "-"
17
FICA & Medicare
0.00%
$ -
$ -
$ -
$ "-"
$ "-"
18
Disability Insurance
0.00%
$ -
$ -
$ -
$ "-"
$ "-"
19
Unemployment Insurance
0.00%
$ -
$ -
$ -
$ "-"
$ "-"
20
21
Total Compensation
1.00
$ 124,704
$ 10,392
$ 2,398
$ 59.96
$ 59.96
22
23
4. Overhead Contribution
60%
$ 74,822
$ 6,235
$ 1,439
$ 35.98
$ 35.98
24
25
Total Personnel Cost
1.60
$ 199,526
$ 16,627
$ 3,837
$ 95.93
$ 95.93
26
27
5. Profit
20%
$ 39,905
$ 3,325
$ 767
$ 19.19
$ 19.19
28
29
Total Revenue Target
1.92
$ 239,432
$ 19,953
$ 4,605
$ 115.12
$ 115.12
30
31
6. Available Hours
2,080
173.32
40.00
8.00
32
Total Hours
2,080
173.32
40.00
8.00
33
Vacation
-
0.00
0.00
0.00
34
Sick Time
-
0.00
0.00
0.00
35
Holidays
-
0.00
0.00
0.00
36
Training
-
0.00
0.00
0.00
37
38
7. Utilization Rate
100.0%
2,080
173.32
40.00
8.00
39
Utilization Rate (Effective)
100.0%
2,080
173.32
40.00
8.00
40
41
8. Billable Rate
100.0%
2,080
173.32
40.00
8.00
42
Billable Rate (Effective)
100.0%
2,080
173.32
40.00
8.00
43
44
Hourly Rate
$ 115.12
45
46
What
Happens to Profit if?
47
Hourly Rate Changes to:
$ 125.00
$ 20,548
$ 1,712
$ 395
$ 9.9
48
Utilization Rate Changes to:
95.0%
$ (11,972)
$ (998)
$ (230)
$ (5.8)
49
50
51
search
