A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
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 Rate | 81.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 Rate | 12.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 |