| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 # 1 | Employee # 2 | Employee # 3 | Employee # 4 | Group 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 | E | UCPath Position FTE (%) | ||||||||||||||||||||||||
19 | F | Total Salary | 0 | 0 | 0 | 0 | ||||||||||||||||||||
20 | BENEFITS | |||||||||||||||||||||||||
21 | G | Composite 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 | N | Total 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 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
33 | ||||||||||||||||||||||||||
34 | BILLABLE HOUR CALCULATION | |||||||||||||||||||||||||
35 | R | Annual Working Hours | Yearly Standard: 2,088 hours | 0 | 0 | 0 | 0 | |||||||||||||||||||
36 | S | Holiday Hours[1] | Yearly Standard: 14 days = 112 hours | |||||||||||||||||||||||
37 | T | Vacation Hours[1] | Base on employee's projected leave taken | |||||||||||||||||||||||
38 | U | Sick Hours[1] | Yearly Standard: 12 days = 96 hours | |||||||||||||||||||||||
39 | V | Administrative Time[1] | ||||||||||||||||||||||||
40 | W | Total 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 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
46 | ||||||||||||||||||||||||||
47 | HOURLY RATE CALCULATION | TOTAL SALARY AND BENEFITS DEVOTED TO ACTIVITY | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
48 | DIVIDED BY BILLABLE HOUR ON RECHARGE | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
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 | ||||||||||||||||||||||||||