Proportion Worksheets - Excel

							                       Administrative Salary Calculation - REVISED 1-8-08



  Instructions. This template allows you to calculate the salary for both department heads and assistant and
  associate deans. Enter the required information in the boxes with the bold borders. The results will appear
  throughout the spreadsheet. The salaries at the bottom of the page show what will happen to salaries over
  time with a 4% annual increase.

  Department Head Calculation Data
  Enter Faculty 9 month Base Salary
  Enter Annual Stipend
  Enter contracted months for summer
  Proportion of Salary Due to:
     AY Salary                                               $0
     Summer Salary                                           $0
     Stipend                                                 $0
                             Total Salary                    $0

  Assistant/Associate Dean Calculation
  Enter Faculty 9 month Base Salary
  Enter 12 month stipend
  Enter Contract length in months
  Proportion of Salary Due to:
     AY Salary                                               $0
     Summer                                                  $0
     Stipend                                                 $0
                             Total Salary                    $0

  Department Head Salary                      Year 1     Year 2     Year 3      Year 4      Year 5      Year 6
  Administrative Salary                            0          0           0           0           0           0
  9 month Faculty Salary                           0          0           0           0           0           0
  AY Base as a percent of DH Salary          #DIV/0!    #DIV/0!   #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!

  Asst/Assoc. Dean Salary                     Year 1     Year 2     Year 3      Year 4      Year 5      Year 6
  Asst/Assoc. Dean Salary                          0          0           0           0           0           0
  9 month Faculty Salary                           0          0           0           0           0           0
  AY Base as a percent of AD Salary          #DIV/0!    #DIV/0!   #DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!




  Department Head Salary Calculation. The following components are added to the AY Base
  salary in this order: (1) Contracted Summer months at .75 their AY Base equivalent (2) Annual
  administrative stipend prorated for the number of months worked. Example: AY Base = 60,000,
  5000 stipend and working 10 months: 60,000 + 60,000/9*.75+5000*10/12= 70,833.

  Assistant/Associate Dean Salary Calculation. The administrative salary is determined by adding
  together two components: (1) Salary as determined by multiplying the faculty member's current
  monthly salary (9 month base) times the number of contracted months (2) An annual stipend
  prorated for the number of contracted months. Example: AY Base = 70,000, stipend =10000,
  11 month contract: 70,000/9*11 +10,000*11/12 = $90,139.




[Path]c74d5457-1ba4-42a9-aea3-2bae295de347.xls