University of San Diego
Budget for Fiscal Year 2012
2011 - 2012 Salary Worksheet
C D E F G H I J K L M N O P Q R S T U V W X Y
Do not Do not Do not Do not Do not Do not Do not Change, Do not
Reference Data
Change Data Change Data Change Data Change Data Change Data Change Data Input Except When Change Data
Current Information Obtained from HR Records Input Column
as of March 1, 2011
in this in this in this in this in this in this Column Recording in this
Column Column Column Column Column Column Pooled Salaries Column
Institutional
Adjustments made
by B & T i.e., 2011 - 2012
Permanent Non- Salary
Instructional Submitted
Salary Reduction, by Org
Current Sabbatical Funds Board (Monthly for 2011 - 2012
Actual 2010 - 2011 Allocation, Revised Approved Preliminary Adjustments Adjusted 2011 ADMIN & Annual Salary
Position GL Account BB Based Current Annual Beg. Base Positions Brought 2010 - 2011 Salary 2011 - 2012 Between Salary - 2012 Base FAC, Hourly Submitted by
Project Position Description Number Number Position Full Name Asg No Classification Std Work Hrs Pay Rate Costing Proportion Salary Budget to MIN, etc. Base Budget Increment Base Budget Lines Budget for STAFF) Org Benefits Burden Comments
When recording your changes make sure that column G has a value Do not change the data in this
Printing Layout: Information in this section was extracted Do not change the data in this To be used to submit new salaries.
of "Y" for Benefit Based or "N" for Non-benefit Based - The benefit column. This is the calculated
Paper Size - Legal Columns H through N: directly from HR records as of March 1, Column O: column, it represents the 2010 - Column R: Column V: Enter monthly or hourly rates as
burden calculation in Column X is based on the designator populated merit increase on each
Orientation - Landscape 2011. 2011 Base Budget. applicable in column V.
in column G budgeted position.
Used for reductions in your
This section is new to this version of our If changes need to be made to employees' details make sure to Do not change the data in this Salary rates entered in Column V are
Represent the 2010 - 2011 Base Base Budget as part of the
Salary Worksheet. It represents information provide full details since this information will be forwarded to HR column. This represents your annualized in colum W using
Columns A through G: Budget for your area as it Columns H through N: Column P: permanent labor reduction Column S: Columns V & W:
about the person currently holding the to populate new salary information. This informations is also used revised base budget adjusted employee details provided in
relates to positions Budgeted. plan and sabbatical funds
position in Column E. to annualize budgeted salaries in Column W. for merit increase. columns I though M.
adjustments.
Other changes between salary lines can be shown in To be used to reflect workforce Use this column to submit salaries
Column P, such as permanent salary transfers Column T: restructuring for the new fiscal Column W: for pooled positions, student wages,
requested from the Budget & Treasury office. year. OT, etc.
Do not change the data in this
Do not change the data in this
column. The total in this
Do not change the data in this column. It contains a formula which
Column Q: column is used to calculate Column U: Column X:
column. calculates benefits on the annualized
merit increase - adjusted for
salary in column W.
FWS/CWO wages.
D:\Docstoc\Working\pdf\3848124d-ac49-47a2-bd74-bed2609b6ba8.xlsx
SALARY