ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
HOURLY RATE TEMPLATE - this form can be used to formulate an hourly labor rate that consists of only labor costs
2
Department Name:
COMPLETE GRAY SHADED FIELDS
INSERT COLUMNS FOR ADDITIONAL PERSONNEL AS NECESSARY
3
Center Name:
4
Recharge Fund Number:
5
6
7
Rate calculations based on a per hour of labor service unit should only reflect the employee's billable time. The estimate of billable hours used in calculating recharge rates is determined by deducting vacation, holiday, and sick hours usage from available working hours. Also deducted are administrative hours used for items such as training, general maintenance, clean-up, etc. The billable hours are those hours that are expected to be rechargable.
8
This calculation can be used when a group rate is charged to users
9
10
11
Employee # 1Employee # 2Employee # 3Employee # 4Group Rate
12
A
Name [This information will only used by B&P. This row will be hidden for presentation purposes]
13
B
Job Code & Job Title [This information will only used by B&P. This row will be hidden for presentation purposes]
14
15
SALARY
16
C
Annualized Salary Rate [equivalent to full FTE]
17
D
Projected Annualized Merit and/or Range Adj ($) [equivalent to full FTE]*
*Enter Effective Date Here
18
EUCPath Position FTE (%)
19
FTotal Salary0000
20
BENEFITS
21
GComposite Benefit Rate (%)
22
H
Vacation Leave Assessment (%) [do not include if center receives revenue federal fund sources]
23
I
UCRP Interest Expense Assessment (%) [do not include if center receives revenue federal fund sources]
24
J Composite Benefit Rate Cost ($) - - - -
25
K Vacation Leave Assessment Cost ($) - - - -
26
L
UCRP Interest Expense Assessment Cost ($)
- - - -
27
M
Vacation Leave Credit ($) [do not include if center receives revenue federal fund sources]
0 0 0 0
28
NTotal Benefits - - - -
29
30
O
TOTAL SALARY AND BENEFITS FOR EACH POSITION
- - - -
31
P
MULTIPLIED BY % EFFORT DEVOTED TO RECHARGE ACTIVITY
32
Q
EQUALS TOTAL SALARY AND BENEFITS DEVOTED TO ACTIVITY
0000
33
34
BILLABLE HOUR CALCULATION
35
RAnnual Working Hours Yearly Standard: 2,088 hours0000
36
SHoliday Hours[1]Yearly Standard: 14 days = 112 hours
37
TVacation Hours[1]Base on employee's projected leave taken
38
USick Hours[1]Yearly Standard: 12 days = 96 hours
39
VAdministrative Time[1]
40
WTotal Annual Billable Hours for Each Position 0 0 0 0
41
42
43
TOTAL ANNUAL BILLABLE HOURS FOR EACH POSITION
0 0 0 0
44
MULTIPLIED BY % EFFORT ON RECHARGE ACTIVITY
45
EQUALS TOTAL BILLABLE HOURS ON RECHARGE
0000
46
47
HOURLY RATE CALCULATION
TOTAL SALARY AND BENEFITS DEVOTED TO ACTIVITY
00000
48
DIVIDED BY BILLABLE HOUR ON RECHARGE00000
49
EQUALS HOURLY RECHARGE RATE WITHOUT OVERHEAD
$0.00$0.00$0.00$0.00$0.00
50
51
OVERHEAD MARKUP %[2]
52
HOURLY RECHARGE RATE W/ OH$0.00$0.00$0.00$0.00$0.00
53
54
NON-UNIVERSITY DIFFERENTIAL MARKUP %[3]
55
HOURLY RECHARGE RATE FOR EXTERNAL USERS
$0.00$0.00$0.00$0.00$0.00
56
57
[1]Amounts are to be based on the employee's actual eligibility and accruals. Please contact Human Resources or Academic Personnel with questions regarding eligibility and accruals. A description of the activities included within non-billable hours (holiday, vacation, sick and administrative time) must be included within the rate proposal to support the billable time calculation.
58
[2]If overhead is applied, provide a detailed calculcation as supporting documentation.
59
[3] Must be equal, at a minimum, to campus standard NUD rate of 55.5%. Should be increased based on what the market will bear.
60
61
INSTRUCTIONS:
62
Department to complete gray shaded fields. Insert columns for additional personnel as necessary
63
A
Enter the Employee's name or identifying information
64
B
Enter the Employee's Title Code, Job Title and Union [format example: 4722 - Blank Asst 3 (CX)]
65
C
Enter the annualized salary for each position at full FTE amount. For example, a .50 FTE position making $40k will be entered as $80k.
66
D
Enter the projected annualized merit and/or range adjustment amount for each position and effective date. Check union agreements and department records.
67
E
Enter the UCPath FTE % for each position. For example, a .50 FTE position in UCPath will be entered as 50%.
68
F
Equals the annual salary for each position
69
G
Enter the Composite Benefit Rate (CBR) for each position
70
Information on CBR rates can be found here: https://bap.ucsb.edu/budget/composite-benefit-rates/rate-tables
71
H
Enter the Vacation Leave Assessment rate for each position. Do not include VLA in rate calculation if program charges federal fund sources.
72
Information on VLA rates can be found here: https://bap.ucsb.edu/budget/composite-benefit-rates/rate-tables
73
I
Enter the UCRP Supplemental Interest Assessment rate for each position that contributes to the UCRP retirement plan (not Choice plan). Do not include UCRP in rate calculation if program charges federal fund sources.
74
Information on UCRP Supplemental Interest Assessment rates can be found here: https://bap.ucsb.edu/budget/composite-benefit-rates/rate-tables
75
J
Composite Benefit Rate Cost is a formula. It multiplies CBR % by Total Salary less vacation taken to get the CBR cost for each position
76
K
Vacation Leave Assessment Cost is a formula. It multiplies VLA % by Total Salary less vacation taken to get the Vacation Leave Assessment cost for each position
77
L
UCRP Interest Assessment Cost is a formula. It multiplies UCRP % by Total Salary to get the UCRP Interest Assessment cost for each position
78
M
Vacation Leave Credit is a formula. It multiplies the number of vacation hours taken by the employee's hourly rate. This amount is credited to Sub 6 of the recharge fund from the campus leave accrual account. Do not include Vacation Leave Credit in rate calculation if program charges federal fund sources.
79
N
Equals the annual benefits for each position
80
O
Total Salary and Benefits for Each Position is a formula. It adds Total Salary and Total Benefits for each position.
81
P
Enter the percent of effort each employee is dedicated to the recharge
82
Q
Total Salary and Benefits Devoted to Activity is a formula. It multiplies Total Salary and Total Benefits for Each Position by Effort Devoted to Recharge Activity to get the total salary and benefits devoted to activity.
83
R
Annual Working Hours is a formula. It multiplies the annual standard working hours of 2,088 by the position FTE.
84
S
Enter Holiday Leave hours to be deducted from the Annual Working Hours. Provide amounts based on employee's actual eligibility.
85
Yearly standard is 112 hours (14 days)[1]. More information on holiday pay can be located here: https://www.hr.ucsb.edu/paid-unpaid-timeoff-resources
86
T
Enter Vacation Leave hours to be deducted from the Annual Working Hours. Provide amounts based on historical, actual data, if available. If actual is not available, base vacation hours on annual hours earned at time of hire.
87
Yearly standard for Professional Support Staff (PSS) with less than 10 years of service is 120 hours (15 days)[1]. More information on accrual amounts can be located here: https://www.hr.ucsb.edu/paid-unpaid-timeoff-resources
88
U
Enter Sick Leave hours to be deducted from the Annual Working Hours. Provide amounts based on the employee's actual maximum accrual amount for the year.
89
Yearly standard is 96 hours (12 days)[1]. More information on accrual amounts can be located here: https://www.hr.ucsb.edu/paid-unpaid-timeoff-resources
90
V
Enter Administrative Time to be deducted from the Annual Working Hours. Provide an estimation that can be supported [e.g. use half an hour for breaks per day, one hour of prepartion time per day].
91
W
Equals the Billable Hours for each FTE [Annual Working Hours (R) less Non-Billable Hours (S through V)]
92
93
94
95
96
97
98
99
100