Salary Calculation Worksheet (page 1 of 2)
                             Yellow: Fill in        Blue: Formula (do not fill)        Orange: Result
                                                 Converting Annualized Salary to Hourly Rate
                                                           There are 2080 working hours in a year.
                                                       (52 working weeks * 40 working hours/week)
                              To convert a full-time annualized salary from annual to hourly, divide the fulltime (1.0 FTE) 
                                                               annualized salary by 2080 hours.
                              Annualized Salary                    FTE                                 Hourly Rate
                                    at X FTE
                                                                                                                             #DIV/0!
                                                                                       (Annualized Salary / FTE)/2080
                                                 Calculating New Salary from Reduced Hours
                                   Reduced                    Hourly Rate                               New Salary
                                 Hours/Week
                                                                                                                               $0.00
                                                                                       (Hours per Week / Hourly Rate)*52 
                                                                                       weeks per year
                                             Converting Commensurate FTE / Pay Adjustments
                                    Current                   Current FTE                     Annualized Salary at 1.0 FTE
                              Annualized Salary
                                                                                                                             #DIV/0!
                                                                                       Current Annual Salary / Current FTE
                              Annualized Salary                 New FTE                      Annualized Salary at New FTE
                                   at 1.0 FTE
                                                                                                                               $0.00
                                                                                       Current Annual Salary * Current FTE
                                                Translation of Non Tenure Track Working Hours to FTE
                             https://ehra.hr.ncsu.edu/wp-content/uploads/sites/8/2016/01/TranslationFTE.pdf
                                 Credit Hours 
                                     Taught               Hrs/Wk Effort Equiv                      Corresponding FTE                    % of FT
                                        1                           3                                      0.075                         7.5%
                                        2                           6                                       0.15                         15.0%
                                        3                           9                                      0.225                         22.5%
                                        4                           12                                      0.3                          30.0%
                                        5                           15                                     0.375                         37.5%
                                        6                           18                                      0.45                         45.0%
                                        7                           21                                     0.525                         52.5%
                                        8                           24                                      0.6                          60.0%
                                        9                           27                                     0.675                         67.5%
                                       10                           30                                      0.75                         75.0%
                                       11                           33                                     0.825                         82.5%
                                       12                           36                                      0.9                          90.0%
                                       13                           39                                     0.975                         97.5%
                                      >13                           40                                       1                           100%
        updated: 8/22/2019
                             Salary Calculation Worksheet (page 2 of 2)
                             Yellow: Fill in        Blue: Formula (do not fill)        Orange: Result
                                                 To Determine FTE with Hours Worked/Week
                             Number of Hours                                               FTE
                             Worked / Week                                      (Full Time Equivalent)
                                                                                          0.00
                                                                   Number of hours worked per week / 40 hours
                                                   9-month / 12-month Contract Conversion
                             https://provost.ncsu.edu/administrator-resources/standard-operating-procedures/converting-faculty-salaries-between-fiscal-and-academic-year/
                                                          Conversion from 12-months to 9-months
                                           Current Annualized Salary                             New Annualized Salary
                                               12-Month Contract                                    9-Month Contract
                                                                                                                               $0.00
                                                                                       Current Annual Salary / 1.22
                                                          Conversion from 9-months to 12-months
                                           Current Annualized Salary                             New Annualized Salary
                                               9-Month Contract                                    12-Month Contract
                                                                                                                               $0.00
                                                                                       Current Annual Salary * 1.22
                                   Annual Compensation Calculation Tool for Temporary Staff & Graduate 
                                                           Assistants Paid on the Biweekly Payroll
                             Enter the start date and last day worked along with the total amount to be paid in the yellow high-lighted fields. The tool will 
                             calculate the annual comp rate based on the data entered.
                             Start Date 
                             (MM/DD/YY):                                               Last Day Worked (MM/DD/YY)
                             Number of Week 
                             Days:                                                   0
                             Number of Pay 
                             Periods:                                                0
                             Total to be paid:
                             Biweekly Rate:                                  #DIV/0!
                             Annual Comp Rate:                               #DIV/0!
                              NOTE: The HR System will determine an annualized full-time salary based on the "Annual 
                              Comp Rate" and standard hours entered.  This annualized full-time salary must be greater 
                             than or equal to the minimum salary for the Temporary Exempt (TE) job code entered into 
                                                                        the HR System.  
                             For TE job codes and salary ranges please refer to : 
                             http://www.ncsu.edu/human_resources/hrim/pdf/tempjobcodes.pdf
                 updated: 8/22/2019