Completed By: At the top left-hand corner of the worksheet; please enter the name of the individual completing the worksheet and their phone number.
Column L – No Increase Reason Code – Data Entry Options: You must place one of the following codes in Column L if you are not recommending a fully satisfactory increase for an employee.
Code A – Person is ineligible because their work in FY23 was not fully satisfactory. (Please be prepared to provide an unsatisfactory review/evaluation, if requested.)
Code B – Person is ineligible because they left/retired before the effective date(s).
Code C – Person is in another department.
Code D – Person is ineligible for some other reason.
Column M – Proposed Fully Satisfactory Percentage Increase: Is pre-populated with a 2% increase for each eligible employee position.
Column N – Raw Annualized Dollar Amount of Fully Satisfactory Increase: Column N automatically calculates the annual dollar amount of the increase based on the input in column M. Please remember that this is an annualized amount based on 1.0 FTE. Banner will pro-rate this amount if the employee’s appointment is less than 1.0 FTE.
Columns O – Total Percent Increase, Adjusted to be Divisible by 9 or 12 Months: Column O takes the value of Column M and adjusts it to produce a total percentage increase that creates a dollar amount that is divisible by 9 or 12 months, based on the employee’s appointment basis (Column J).
Column P – Estimated Annualized Dollar Amount of Total Increase, Adjusted to be Divisible by 9 or 12: Column P reflects the amount in Column N, adjusted to be divisible by 9 or 12 months (Column J). This is an estimated amount before final adjustments made by the OSU Budget Office.
Column Q – Estimated Annual Salary Rate, rounded up and divisible by 9 or 12 Months.
Column R – Department Remarks: Please use this column to indicate any conditions that affect your decision.
Columns S and T - Department Use Only: The Department Use Only section (Columns S and T) was added to the worksheets at the request of several key representatives as a tool to assist in budgeting and ensuring fiscal controls. Please be aware that these columns do not have an impact on other worksheet calculations, nor will Human Resources or Payroll utilize this information in administering the faculty salary increases. You may elect to use or not use this section of the worksheet.
Columns S and T include an employee’s current appointment FTE (%) as of May 2, 2023 and calculate monthly actual gross salary rate based on appointment basis (9 or 12) and appointment percent. You may change these columns, though any changes will not be reflected in the columns to the left. Column T is based on Column Q. If you change the appointment percent (Column S), the monthly actual (Column T) will recalculate, based on the annualized salary rate in Column Q.
Increase Summary Section: At the bottom (or on the last page) of the worksheet, you will find a summary section. This is a tool to assist you in determining the total dollar amount for distribution.
#1 - Total Base Salary Amount for Eligible Employees: This amount is the total of Column K (Annual Full-Time Salary Rate as of 05/02/23). It is adjusted automatically based on entries in Column L (No Increase Codes). The total annual salary base excludes Sabbaticals and Tenured Appointment Placeholder positions.
#2 – 3% Annual Salary Available within the Salary Increase Pool: This cell calculates the 3% available for the awarding of salary increases. Changes in #1 – Total Annual Salary Base amount will automatically be accounted for in this cell.
#3 – Sum of Proposed Increases in Column P: The sum of the salary increases from column P (excludes placeholders coded “TP” in R-Department Remarks)
#4 - Amount Over/Under Distributed: Shows the dollars remaining.
#5 – Percent Distributed Above: Percent distributed (target equals 3%).