The spreadsheet below can be used to cost the common classifications (Professional, Academic and English Language Centre Staff) within the University for any period between 2007 and 2018.

Rates are as per the current Enterprise Bargaining Agreements and any future awarded payrises contained within.

NB: Some functions in the worksheet below may require the Analysis Toolpack to be installed as an add-in to your Microsoft Excel application.

Download / Open Salary Costing Worksheet

How to use the costing worksheet

To calculate a salary costing follow the simple steps below:

• Click on the link above to open or download a copy of the spreadsheet.
• Enter the start and end dates for the costing.
• Select the Classification and Step that you need from the pull down menu.
• Enter the fraction of the appointment.
• The default set-up is to assume that the appointment is against Operating Subledger (OP), if the position is to be funded from Research Subledger (RT) select the appropriate radio button.
• The default set-up is to include superannuation at the maximum rate of 17% but the selection can be changed to cost the appointment at 9%.
  

Please note:

• These calculations are estimates only and actual costs may vary from those actually incurred.
• The salary estimates are the estimated cost during the period entered. This is not the same as the pa rates of pay as per the EBA agreements noted above. To reconcile the two, the pa salary rate need to be converted to a daily rate (pa rate divided by 26.0893 divided by 10) this figure then needs to be multiplied by the number of paid days between the dates in the costing. This spreadsheet replicates the calculations produced by the University's Human Resource Management System.

Research Subledger

Staffing appointments funded under TechOne projects in the Research Subledger (RT) do not incur salary on-costs associated with the Central Leave Provision Levy and thus have a different total cost. Details of the salary on-costs are available on the Salary On-cost web page.