ABCDEFG
1
Unit Price Staffing Rate Calculator
2
3
To use this Calculator, insert applicable data into the Highlighted Cells. The sheet will automatically calculate results based on entered data.

Calculation:
Current Rate of Pay x (1 + Prorated Raise) = Escalated Rate
Escalated Rate x (1 + Consultant Overhead Rate) = Subtotal Labor and OH
Subtotal Labor and OH x (1 + Fixed Fee Rate) = Subtotal DL, OH, & FF ... aka... Final Proposed Rate / Loaded Labor Rate (if no FCCM)

IF APPLICABLE:
Escalated Rate x FCCM rate = FCCM Cost
Subtotal DL, OH, & FF + FCCM Cost = Total DL, OH, FF, and FCCM Cost ... aka... Final Proposed Rate / Loaded Labor Rate (with FCCM
)
4
5
Current Rate (Current Direct Labor)
$ 70.00
(Individual Current Labor Rate)
6
Prorated Raise %0%
(Individual raise % or Multi-Year Prorated Raise% - If none, Enter 0)
7
Escalated Rate$70.00
8
9
Overhead Rate81.90%
(from Financial Screening Active on Consultant Selection Date)
10
Overhead Rate for Calculation
$ 1.8190
11
Subtotal Labor and OH
$ 127.33
12
13
Fixed Fee Rate12.0%
(Negotiated with UDOT PM)
14
Fixed Fee Rate for Calculation
$ 1.12
15
Subtotal DL, OH, & FF
$ 142.61
Final Proposed Rate / Loaded Labor Rate (if no FCCM)
16
17
FCCM Rate (as a Decimal) (If Applicable)
0
(from Financial Screening Active on Consultant Selection Date)
18
FCCM Cost $ -
19
Total DL, OH, FF, and FCCM Cost
$ 142.61
Final Proposed Rate / Loaded Labor Rate (with FCCM)
20
21
* It is the consultant's responsibility to ensure the accuracy of all calculations. Consultant Services is not responsible for any errors in labor rates resulting from the use of this tool.
22
** Per FAR 31.205-6, an engineering consultant is permitted to charge reasonable compensation to government contracts. Reasonableness as defined in FAR 31.201-3 is A cost that in its nature and amount, does not exceed that which would be incurred by a prudent person in the conduct of competitive business. The burden of proof shall be upon the contractor to establish that any cost is reasonable and therefore allowable per FAR 31.201-2.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100