Employment Contract Annual Increment by yka72229

VIEWS: 0 PAGES: 13

More Info
									D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
    1/30/2011



Salary Estimate Model Instructions

Note
         The Analysis ToolPack add-in must be available for this model to work
               Use the following steps if needed:
                     1. Menu >> Tools> Add-Ins
                     2. Check box next to Analysis ToolPack
                     3. Click OK

                  If this does not work contact ITD xtn 2222

Data Input
       Go to the worksheet "Data Input"

         Data is entered, as required, into cells shown as >>

         Error and help messages will appear if incorrect or conflicting data is entered
                (e.g. if the finish date is earlier then the start date)

         Refer to the notes at the bottom of the page

Salary Cost Estimate
       Read the "Assumptions" worksheet to check they are appropriate for the situation

         An example of a completed Data Input is displayed on the following "Example" sheet

         The result of the calculations is displayed at the bottom of the "Data Input" Sheet
                eg Estimated total cost ** = $ 50,000.00

Agreement Based Increases

         Academic & Support Staff

                              Increase       Start Date
                                   2%         5/1/2010
                                   2%        11/1/2010
                         ??                   5/1/2011 Yet to be determined
                         ??                  11/1/2011 Yet to be determined

         SSG Staff
                         Current agreement provides for 3.5%
                         from 1 April plus performace increase




                                                                              470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
G:\HRU Mgmt Team\HR Finances 2007 (PS)\Salary Reports\Salary Estimate Model\[Salary Estimate Model - v18.xls]Example
              4/17/2007

Salary Estimate Model - Data Input
(last update Jan 2011)

* required information
ID Details                                                                                                         Notes
Name                                  Example Only

Employment Details

* Employment Contract                  Continuing (17% Super)

* Start Date (dd/mm/yy)                        01/01/07                                                                1

* Finish Date (dd/mm/yy)                       31/12/07                                                                2

* Average FTE (max 100%)                            50%         from start to finish date                              3

Salary Details
* Starting Annual Salary $             $     50,000.00                                                                 4

Increment Value $
   or
Increment %

Increment Date (dd/mm/yy)                                       first day new rate will apply

Salary Increase 1 value $              $             -
   or
Salary Increase 1 %                                      2%                                                            5

Salary Increase 1 Date                         04/05/07         first day new rate will apply                          6

Salary Increase 2 value $
   or
Salary Increase 2 %                                      2%                                                            5

Salary Increase 2 Date                         02/11/07         first day new rate will apply                          6

Leave Provision Details
* Percentage of accrued annual leave taken during this period                            50%                           7

* Start date at UTS or other complying University                                   01/10/03                           8

Estimated Salary Cost For             Example Only
For the period                                 01/01/07              to             31/12/07

Average FTE =                                        0.5

Estimated Cost Y/E 31/12/07            $     34,077.20

Estimated Cost Y/E 31/12/08            $         251.19

Estimated Total Cost ** =              $     34,328.39


** Note:
This estimate is based on 2007 on-cost rates and several assumptions (refer Assumptions schedule for
details). The total cost estimate will vary from the actual result to the extent the assumptions are not valid.



                                                     470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
Notes
 1 first paid working day
 2 last paid working day - N.B maximum period model can calculate is 12 months
 3 eg working 2 days per week = 0.4 FTE, 3 days per week = 0.6 FTE
 4 annual salary rate that applies on the start date
 5 for SSG positions enter total % including both the fixed and performance based % increases
 6 i.e. fortnightly pay date
 7 eg if 20 days (140 hours) leave is accrued and 10 days (70 hours) will be taken enter 50%.
     Assumes leave is taken at the avg salary rate but is actualy charged at the current rate
     when the leave is actually taken.
 8 long service leave provision is calculated at a different rate depending on length of service -
     in some instances staff can have service with another university included for calculation of
     long service. If this is the case the date should include this pri




                                             470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
              1/30/2011

Salary Estimate Model - Data Input
(last update Jan 2011)

* required information
ID Details                                                                                                     Notes
Name

Employment Details

* Employment Contract                  Continuing (17% Super)

* Start Date (dd/mm/yy)                                                                                          1

* Finish Date (dd/mm/yy)                                                                                         2

* Average FTE (max 100%)                                         from start to finish date                       3

Salary Details

* Starting Annual Salary $                                                                                       4

Allowances, loadings etc $                                                                                       5
   or
Allowances, loadings etc %

Allowance etc Start Date                                         first day allowance will apply

Allowance etc End Date                                           last day allowance will apply if applicable    5a

Increment Value $
   or
Increment %

Increment Date (dd/mm/yy)                                        first day new rate will apply

Salary Increase 1 value $
   or
Salary Increase 1 %                                                                                              6

Salary Increase 1 Date                                           first day new rate will apply                   7

Salary Increase 2 value $
   or
Salary Increase 2 %                                                                                              8

Salary Increase 2 Date                                           first day new rate will apply                   9

Leave Provision Details
* Percentage of accrued annual leave taken during this period                                                   10

* Start date at UTS or other complying University                                                               11

Estimated Salary Cost For                                 0
For the period                                  00/01/00              to            00/01/00

Average FTE =                                      0.00%

Estimated Cost Y/E 31/12/11             $             -

Estimated Cost Y/E 31/12/12             $             -


                                                      470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
Estimated Total Cost ** =        $           -

** Note:
This estimate is based on 2010 on-cost rates and several assumptions (refer Assumptions schedule for
details). The total cost estimate will vary from the actual result to the extent the assumptions are not
valid.

Notes
 1 first paid working day (dd/mm/yy)
 2 last paid working day - N.B maximum period model can calculate is 12 months
 3 eg working 2 days per week = 0.4 FTE, 3 days per week = 0.6 FTE
 4 annual salary rate that applies on the start date
 5 enter total annual allowance value - will not be changed by increments or salary increases
 5a leave blank if allowance etc is ongoing
 6 for SSG positions enter total % including both the fixed and performance based % increases
 7 i.e. fortnightly pay date
 8 for SSG positions enter total % including both the fixed and performance based % increases
 9 i.e. fortnightly pay date
 10 eg if 20 days (140 hours) leave is accrued and 10 days (70 hours) will be taken enter 50%.
     Assumes leave is taken at the avg salary rate but is actualy charged at the current rate
     when the leave is actually taken.
 11 long service leave provision is calculated at a different rate depending on length of service.
     In some cases staff can have service with another university included for calculation of long
     service. If this is the case the date should reflect this prior service.




                                              470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
        1/30/2011



Assumptions

             Staff employed on a continuing basis will receive 17% employer superannuation contribution

             Staff employed on a fixed term basis will receive 9% or 17% employer superannuation contribution

             No long service leave (LSL) will be taken and the accumulated LSL provision is not paid
                  at the finish date

             Percentage (%) annual leave (AL) taken is charged at the average salary rate. In reality it is charged at the
                  current salary rate when the leave is actually taken

             No leave without pay (LWOP) is taken

             No salary packaging arrangement is in place that would affect the the calculation
                 eg salary packaging of a motor vehicle

             No buy-out of annual leave or other off-set option is in effect

             No overtime or penalty rates apply

             Any past accumulation of AL or LSL is funded by exiting leave provisions
                  Note Large leave balances can result in a significant cost increase when
                        salary rate increase. This is not allowed for in this model

             The Treasury 10yr bond rate (used to calculate the LSL provision) remains the same on average
                 as for the previous 12 months




                                                                              470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input                                                                                                                                  List 1                 Con
                    1/30/2011                                                                                                                                                                                                       Fix
                                                                                                                                                                                                             List 2                 Sup
Salary Forecast Model - Forecast                                                                                                                                                                                                    SSG

Staff Data                                                                         = linked data                                                                                                                                                                 Allowance         Base
                                                                FTE       Type 1          Start           First Pay           Start          Finish         Extras                Comm Rate Incr                      Rate Incr      First Pay     Rate Incr     Last Pay      Last Pay
Name                                                                     >>Con/Fix       Salary                 Adj            Date            Date                                 Date Start Date                      Value             Adj     End Date            Adj          Adj
                            0                                   0.00       Con      $      -                   #N/A         0/01/00         0/01/00                      0       0/01/00                      $            -                                          #N/A         #N/A
                                                                                                                                                                                                              $            -
                                                                                                                                                                                                              $            -
                                                                                                                                                                                                              $            -




Rate Increases                  Pay Days >>                 6/01/11           20/01/11       3/02/11       17/02/11         3/03/11        17/03/11        31/03/11             14/04/11        28/04/11              12/05/11       26/05/11        9/06/11      23/06/11      7/07/11     21/07/11      4/08/11     18/08/11       1/09/11      15/09/11      29/09/11      13/10/11      27/10/11      10/11/11      24/11/11       8/12/11      22/12/11       5/01/12      19/01/12       2/02/12      16/02/12       1/03/12      15/03/12      29/03/12      12/04/12      26/04/12      10/05/12      24/05/12       7/06/12      21/06/12       5/07/12      19/07/12       2/08/12      16/08/12      30/08/12      13/09/12      27/09/12      11/10/12      25/10/12       8/11/12      22/11/12       6/12/12      20/12/12       3/01/13      17/01/13
Start Salary                                                   -                  -             -              -               -               -               -                    -               -                     -              -              -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
First pay adjustment                                             0%                 0%            0%             0%              0%              0%              0%                   0%              0%                    0%             0%             0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Last Pay adjustment                                              0%                 0%            0%             0%              0%              0%              0%                   0%              0%                    0%             0%             0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Adj Start Salary                                               -                  -             -              -               -               -               -                    -               -                     -              -              -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Allowances                                                      -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
First pay adjustment                                                0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%        -
Last Pay adjustment                                                 0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%        -
Adj Increment                                                   -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Increment                                                       -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
First pay adjustment                                                0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Last Pay adjustment                                                 0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Adj Increment                                                   -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Salary Increase 1                                               -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
First pay adjustment                                                0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Last Pay adjustment                                                 0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Adj Salary Inc 1                                                -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Salary Increase 2                                               -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
First pay adjustment                                                0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Last Pay adjustment                                                 0%                0%            0%             0%                0%            0%                0%                   0%            0%                     0%             0%            0%            0%           0%           0%           0%           0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%            0%
Adj Salary Inc 2                                                -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Total Salary $                                                  -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
Adjusted Salary $                                               -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -
Hrly Rate $(rounded)                                            -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -

Leave Provisions
AL Days/month                                                                     -                            -                                                 -                                  -                                     -                           -                         -                         -                                         -                           -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                           -
AL M/E Balance                                                                    -                            -                                                 -                                  -                                     -                           -                         -                         -                                         -                           -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                           -
AL Taken                                     0%                                   -                            -                                                 -                                  -                                     -                           -                         -                         -                                         -                           -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                           -
LSL Liab based on Actuarial Report Probability Rates & 10 yr Govt Bond Rate
LSL Days/month
LSL Balance                                                                       -                            -                                                 -                                  -                                     -                           -                         -                         -                                         -                           -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                                         -                           -                           -                           -                           -                           -
LSL Taken


0.00
Details                   Open Bal                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Y/E Total    Y/E Total    Y/E Total
% of Year                                                     1.6%               5.5%          9.3%          13.2%           17.0%           20.8%           24.7%                28.5%           32.3%                 36.2%          40.0%          43.8%         47.7%        51.5%        55.3%        59.2%        63.0%         66.8%         70.7%         74.5%         78.4%         82.2%         86.0%         89.9%         93.7%         97.5%        101.4%        105.2%        109.0%        112.9%        116.7%        120.5%        124.4%        128.2%        132.1%        135.9%        139.7%        143.6%        147.4%        151.2%        155.1%        158.9%        162.7%        166.6%        170.4%        174.2%        178.1%        181.9%        185.8%        189.6%        193.4%        197.3%        201.1%        204.9%              to           to
Pay Dates                                                   6/01/11           20/01/11       3/02/11       17/02/11         3/03/11        17/03/11        31/03/11             14/04/11        28/04/11              12/05/11       26/05/11        9/06/11      23/06/11      7/07/11     21/07/11      4/08/11     18/08/11       1/09/11      15/09/11      29/09/11      13/10/11      27/10/11      10/11/11      24/11/11       8/12/11      22/12/11       5/01/12      19/01/12       2/02/12      16/02/12       1/03/12      15/03/12      29/03/12      12/04/12      26/04/12      10/05/12      24/05/12       7/06/12      21/06/12       5/07/12      19/07/12       2/08/12      16/08/12      30/08/12      13/09/12      27/09/12      11/10/12      25/10/12       8/11/12      22/11/12       6/12/12      20/12/12       3/01/13      17/01/13      31/12/11     31/12/12                 Check
FTE                                                            0.00               0.00          0.00           0.00            0.00            0.00            0.00                 0.00            0.00                  0.00           0.00           0.00          0.00         0.00         0.00         0.00         0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00          0.00                                            s/be 0
Salary                                                         -                  -             -              -               -               -               -                    -               -                     -              -              -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
Adj (eg salary pack,LWOP)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     -            -            -            -
Extras, Allowances                                  Check?               Check?            Check?        Check?         Check?            Check?        Check?               Check?            Check?        Check?                 Check?         Check?        Check?        Check?       Check?       Check?       Check?       Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?        Check?             -            -            -            -
Sub-total                                                       -             -                 -              -                 -             -                 -                    -             -                      -             -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
W/Comp                                                          -             -                 -              -                 -             -                 -                    -             -                      -             -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
P/Tax                                                           -             -                 -              -                 -             -                 -                    -             -                      -             -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
Super (B)                                                       -             -                 -              -                 -             -                 -                    -             -                      -             -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
Parental Lev Prov                                               -             -                 -              -                 -             -                 -                    -             -                      -             -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
On-cost Adj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   -            -            -            -
Sub-total                                                       -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
AL Prov                                                         -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
AL Adj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        -            -            -            -
LSL Prov                                                        -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
LSL Adj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       -            -            -            -
Sub-total                                                       -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              -            -                         -
Total                                                           -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -            -
check s/be 0                                                        -                 -             -              -                 -             -                 -                    -             -                      -              -             -             -            -            -            -            -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -             -            -            -




                                                                                                                                                                                                                                                                                                                                                                                                                                                                      470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
                1/30/2011


Salary Forecast Model - Generic Data
                                                                                                        = data to be manually updated for each year
                                                                                                        = confirm
Current Year                        2011
Days in year                         365
Pay Dates
Date                                          Thu 06 Jan     Thu 20 Jan Thu 03 Feb         Thu 17 Feb       Thu 03 Mar    Thu 17 Mar    Thu 31 Mar    Thu 14 Apr   Thu 28 Apr   Thu 12 May Thu 26 May   Thu 09 Jun Thu 23 Jun   Thu 07 Jul   Thu 21 Jul   Thu 04 Aug   Thu 18 Aug   Thu 01 Sep Thu 15 Sep Thu 29 Sep   Thu 13 Oct   Thu 27 Oct   Thu 10 Nov   Thu 24 Nov Thu 08 Dec   Thu 22 Dec   Thu 05 Jan   Thu 19 Jan    Thu 02 Feb    Thu 16 Feb     Thu 01 Mar     Thu 15 Mar   Thu 29 Mar   Thu 12 Apr   Thu 26 Apr   Thu 10 May   Thu 24 May   Thu 07 Jun   Thu 21 Jun   Thu 05 Jul   Thu 19 Jul   Thu 02 Aug   Thu 16 Aug   Thu 30 Aug   Thu 13 Sep   Thu 27 Sep   Thu 11 Oct   Thu 25 Oct   Thu 08 Nov   Thu 22 Nov Thu 06 Dec   Thu 20 Dec   Thu 03 Jan   Thu 17 Jan
Month                                             Jan 11         Jan 11     Feb 11             Feb 11           Mar 11        Mar 11        Mar 11        Apr 11       Apr 11       May 11     May 11       Jun 11     Jun 11       Jul 11       Jul 11       Aug 11       Aug 11       Sep 11     Sep 11     Sep 11       Oct 11       Oct 11       Nov 11       Nov 11     Dec 11       Dec 11       Jan 12       Jan 12        Feb 12        Feb 12         Mar 12         Mar 12       Mar 12       Apr 12       Apr 12       May 12       May 12       Jun 12       Jun 12       Jul 12       Jul 12       Aug 12       Aug 12       Aug 12       Sep 12       Sep 12       Oct 12       Oct 12       Nov 12       Nov 12     Dec 12       Dec 12       Jan 13       Jan 13
Day number                                        40549          40563       40577              40591           40605         40619         40633         40647        40661         40675      40689       40703      40717       40731        40745          40759        40773        40787      40801      40815       40829        40843        40857        40871       40885        40899       40913        40927          40941         40955         40969          40983        40997        41011        41025         41039        41053       41067        41081       41095        41109          41123        41137        41151        41165        41179       41193        41207        41221        41235       41249        41263       41277        41291

Increment Pay Dates & %
Support Staff
 Coll Agree Date      01 May 11               01 Nov 11          6/01/11        20/01/11      3/02/11          17/02/11       3/03/11     17/03/11     31/03/11     14/04/11      28/04/11   12/05/11    26/05/11     9/06/11    23/06/11      7/07/11      21/07/11      4/08/11     18/08/11    1/09/11   15/09/11    29/09/11     13/10/11      27/10/11    10/11/11    24/11/11      8/12/11    22/12/11
 %                          2.0%                  2.0%                                                                                                                2.50%         2.50%      2.50%       2.50%       2.50%       2.50%        2.50%         2.50%        2.50%        2.50%      2.50%      2.50%       2.50%        4.50%         4.50%       4.50%       4.50%        4.50%       4.50%
SSG                                                                                                                                                                   3.50%         3.50%      3.50%       3.50%       3.50%       3.50%        3.50%         3.50%        3.50%        3.50%      3.50%      3.50%       3.50%        3.50%         3.50%       3.50%       3.50%        3.50%       3.50%
 Perf etc Date         Fri 01 Apr
 % estimate                   6%

Allowances
AL
Prov                               140.0 hrs/yr              >> jan 07 to dec 08                                                            3 pays                                                                                                                                                            3 pays                                                                                                                                                                       3 pays                                                                                                                                                                   3 pays
Mths                            01/01/11                       31/01/11                      28/02/11                                     31/03/11                  30/04/11                 31/05/11                30/06/11                 31/07/11                   31/08/11                           30/09/11                 31/10/11                  30/11/11                 31/12/11                 31/01/12                      29/02/12                                  31/03/12                 30/04/12                   31/05/12                 30/06/12                  31/07/12                   31/08/12                               30/09/12                 31/10/12                  30/11/12                 31/12/12                 31/01/13
Mth Days                                                             31                           28                                           31                        30                       31                      30                       31                         31                                 30                       31                        30                       31                       31                            29                                        31                       30                         31                       30                        31                         31                                     30                       31                        30                       31                       31
Hours / Calendar Mth                                              11.89                        10.74                                        11.89                     11.51                    11.89                   11.51                    11.89                      11.89                              11.51                    11.89                     11.51                    11.89                    11.89                         11.12                                     11.89                    11.51                      11.89                    11.51                     11.89                      11.89                                  11.51                    11.89                     11.51                    11.89                    11.89
Cumm Hrs                                                          11.89                        22.63                                        34.52                     46.03                    57.92                   69.43                    81.32                      93.21                             104.72                   116.61                    128.12                   140.01                   151.90                        163.02                                    174.91                   186.42                     198.31                   209.82                    221.71                     233.60                                 245.11                   257.00                    268.51                   280.40                   292.29


AL On Costs                              Total Renum = A                      Equivalent %          Total                   31/01/11      28/02/11     31/03/11     30/04/11      31/05/11   30/06/11    31/07/11   31/08/11    30/09/11     31/10/11       30/11/11     31/12/11     31/01/12   29/02/12   31/03/12    00/01/00     31/05/12     30/06/12     31/07/12    31/08/12     30/09/12    31/10/12     31/10/12       30/11/12      31/12/12
Continuing                           Con Super = B                                  100 100.0000%                           100.00%       100.00%      100.00%      100.00%       100.00%    100.00%     100.00%    100.00%     100.00%      100.00%        100.00%      100.00%      100.00%    100.00%    100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%       100.00%
Rate Inc Prov                      4.90% Rate Inc Prov = C                           4.9    4.9000%                           4.90%         4.90%        4.90%        4.90%         4.90%      4.90%       4.90%      4.90%       4.90%        4.90%          4.90%        4.90%        4.90%      4.90%      4.90%       4.90%        4.90%        4.90%        4.90%       4.90%        4.90%       4.90%        4.90%          4.90%         4.90%
W/Comp                             0.95% (A+C)                                              0.9966%                           1.00%         1.00%        1.00%        1.00%         1.00%      1.00%       1.00%      1.00%       1.00%        1.00%          1.00%        1.00%        1.00%      1.00%      1.00%       1.00%        1.00%        1.00%        1.00%       1.00%        1.00%       1.00%        1.00%          1.00%         1.00%
P/Tax                              5.50% (A+B+C)                                            6.6718%                           6.67%         6.67%        6.67%        6.67%         6.67%      6.67%       6.67%      6.67%       6.67%        6.67%          6.67%        6.67%        6.67%      6.67%      6.67%       6.67%        6.67%        6.67%        6.67%       6.67%        6.67%       6.67%        6.67%          6.67%         6.67%
Super                             15.64% (A+C)                                      16.4   16.4064%                          16.41%        16.41%       16.41%       16.41%        16.41%     16.41%      16.41%     16.41%      16.41%       16.41%         16.41%       16.41%       16.41%     16.41%     16.41%      16.41%       16.41%       16.41%       16.41%      16.41%       16.41%      16.41%       16.41%         16.41%        16.41%
Parental Lev Prov                  0.00%                                                    0.0000%                           0.00%         0.00%        0.00%        0.00%         0.00%      0.00%       0.00%      0.00%       0.00%        0.00%          0.00%        0.00%        0.00%      0.00%      0.00%       0.00%        0.00%        0.00%        0.00%       0.00%        0.00%       0.00%        0.00%          0.00%         0.00%
                                                                                                             28.9748%        28.97%        28.97%       28.97%       28.97%        28.97%     28.97%      28.97%     28.97%      28.97%       28.97%         28.97%       28.97%       28.97%     28.97%     28.97%      28.97%       28.97%       28.97%       28.97%      28.97%       28.97%      28.97%       28.97%         28.97%        28.97%

Fixed                                 Fix                                           100 100.0000%                         Not
Rate Inc Prov                      4.90%                                             4.9  4.9000%                         Currently
W/Comp                             0.75% (A+B+C)                                          0.9044%                         Used
P/Tax                              6.00% (A+B+C)                                          7.2356%
Super                            14.96% (A+C)                                       15.7 15.6930%
Parental Lev Prov               0.0000%                                                   0.0000%            28.7331%

AL taken estimate                  -140.0 hrs/yr

LSL
LSL Prov < 10 yrs                   30.8 hrs/yr
LSL >= 10 yrs                       77.0 hrs/yr
Mths                           01/01/11     31/01/11            31/01/11        28/02/11     28/02/11          31/03/11     31/03/11      30/04/11     30/04/11     31/05/11      31/05/11   31/05/11    30/06/11    30/06/11    31/07/11     31/07/11      31/08/11     31/08/11     30/09/11   30/09/11   31/10/11    31/10/11     30/11/11      30/11/11    30/11/11    31/12/11     31/12/11    31/01/12     31/01/12       29/02/12       29/02/12        31/03/12     31/03/12     30/04/12    30/04/12     31/05/12      31/05/12     31/05/12    30/06/12     30/06/12     31/07/12     31/07/12      31/08/12     31/08/12     30/09/12     30/09/12     31/10/12    31/10/12     31/10/12      30/11/12    30/11/12    31/12/12     31/12/12    31/01/13     31/01/13
Mth Days                                          31                 31              28           28                31           31            30           30           31            31         31          30          30          31           31            31           31           30         30         31          31           30            30          30          31           31          31           31             29             29              31           31           30          30           31            31           31          30           30           31           31            31           31           30           30           31          31           31            30          30          31           31          31           31
Hours / Calendar Mth        <10 yrs             2.62               2.62            2.36         2.36              2.62         2.62          2.53         2.53         2.62          2.62       2.62        2.53        2.53        2.62         2.62          2.62         2.62         2.53       2.53       2.62        2.62         2.53          2.53        2.53        2.62         2.62        2.62         2.62           2.45           2.45            2.62         2.62         2.53        2.53         2.62          2.62         2.62        2.53         2.53         2.62         2.62          2.62         2.62         2.53         2.53         2.62        2.62         2.62          2.53        2.53        2.62         2.62        2.62         2.62
Hours / Calendar Mth        >= 10 yrs           6.54               6.54            5.91         5.91              6.54         6.54          6.33         6.33         6.54          6.54       6.54        6.33        6.33        6.54         6.54          6.54         6.54         6.33       6.33       6.54        6.54         6.33          6.33        6.33        6.54         6.54        6.54         6.54           6.12           6.12            6.54         6.54         6.33        6.33         6.54          6.54         6.54        6.33         6.33         6.54         6.54          6.54         6.54         6.33         6.33         6.54        6.54         6.54          6.33        6.33        6.54         6.54        6.54         6.54
Cumm Hrs                                        6.54              13.08


LSL On Costs                                 Total Renum = A                  Equivalent %         Total                    31/01/11      28/02/11     31/03/11     30/04/11      31/05/11   31/05/11    31/07/11   31/08/11    30/09/11     31/10/11       30/11/11     31/12/11     31/12/11   31/01/12   29/02/12    31/03/12     30/04/12     31/05/12     30/06/12    31/07/12     31/08/12    30/09/12     31/10/12       30/11/12      31/12/12
Continuing                           Con     Super = B                              100 100.0000%                           100.00%       100.00%      100.00%      100.00%       100.00%    100.00%     100.00%    100.00%     100.00%      100.00%        100.00%      100.00%      100.00%    100.00%    100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%       100.00%
Rate Inc Prov ( C )                4.90%     Rate Inc Prov = C                       4.9   4.9000%                            4.90%         4.90%        4.90%        4.90%         4.90%      4.90%       4.90%      4.90%       4.90%        4.90%          4.90%        4.90%        4.90%      4.90%      4.90%       4.90%        4.90%        4.90%        4.90%       4.90%        4.90%       4.90%        4.90%          4.90%         4.90%
W/Comp                             0.95%     (A+C)                                         0.9966%                            1.00%         1.00%        1.00%        1.00%         1.00%      1.00%       1.00%      1.00%       1.00%        1.00%          1.00%        1.00%        1.00%      1.00%      1.00%       1.00%        1.00%        1.00%        1.00%       1.00%        1.00%       1.00%        1.00%          1.00%         1.00%
P/Tax                              5.50%     (A+B+C)                                       6.2501%                            6.25%         6.25%        6.25%        6.25%         6.25%      6.25%       6.25%      6.25%       6.25%        6.25%          6.25%        6.25%        6.25%      6.25%      6.25%       6.25%        6.25%        6.25%        6.25%       6.25%        6.25%       6.25%        6.25%          6.25%         6.25%
Super (B)                          8.33%     (A+C)                                   8.7   8.7382%                            8.74%         8.74%        8.74%        8.74%         8.74%      8.74%       8.74%      8.74%       8.74%        8.74%          8.74%        8.74%        8.74%      8.74%      8.74%       8.74%        8.74%        8.74%        8.74%       8.74%        8.74%       8.74%        8.74%          8.74%         8.74%
Parental Lev Prov                  0.00%                                                   0.0000%                            0.00%         0.00%        0.00%        0.00%         0.00%      0.00%       0.00%      0.00%       0.00%        0.00%          0.00%        0.00%        0.00%      0.00%      0.00%       0.00%        0.00%        0.00%        0.00%       0.00%        0.00%       0.00%        0.00%          0.00%         0.00%
                                                                                                        20.8848%             20.88%        20.88%       20.88%       20.88%        20.88%     20.88%      20.88%     20.88%      20.88%       20.88%         20.88%       20.88%       20.88%     20.88%     20.88%      20.88%       20.88%       20.88%       20.88%      20.88%       20.88%      20.88%       20.88%         20.88%        20.88%

Fixed                                 Fix                                           100 100.0000%                         Not
Rate Inc Prov                      4.90%                                             4.9  4.9000%                         Currently
W/Comp                             0.75% (A+B+C)                                          0.8309%                         Used
P/Tax                              6.00% (A+B+C)                                          6.6471%
Super                              5.61% (A+C)                                       5.9  5.8849%
Parental Lev Prov               0.0000%                                                   0.0000%            18.2629%




Salary On Costs                          Total Renum = A                      Equivalent %          Total                    6/01/11      20/01/11      3/02/11     17/02/11       3/03/11   17/03/11    31/03/11   14/04/11    28/04/11     12/05/11       26/05/11      9/06/11     23/06/11    7/07/11   21/07/11     4/08/11     18/08/11      1/09/11     15/09/11    29/09/11     13/10/11    27/10/11     10/11/11       24/11/11       8/12/11         22/12/11     5/01/12     19/01/12      2/02/12     16/02/12       1/03/12     15/03/12    29/03/12     12/04/12    26/04/12     10/05/12       24/05/12      7/06/12     21/06/12      5/07/12     19/07/12     2/08/12     16/08/12     30/08/12     13/09/12    27/09/12     11/10/12    25/10/12      8/11/12    22/11/12    6/12/12   20/12/12    3/01/13   17/01/13
Continuing                           Con Super = B                                  100 100.0000%                           100.00%       100.00%      100.00%      100.00%       100.00%    100.00%     100.00%    100.00%     100.00%      100.00%        100.00%      100.00%      100.00%    100.00%    100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%       100.00%          100.00%     100.00%      100.00%      100.00%      100.00%       100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%      100.00%      100.00%      100.00%      100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%     100.00%    100.00%    100.00%    100.00%    100.00%
W/Comp                             0.80% (A+B)                                              0.9360%                           0.80%         0.80%        0.80%        0.80%         0.80%      0.80%       0.80%      0.80%       0.80%        0.80%          0.80%        0.80%        0.80%      0.80%      0.80%       0.80%        0.80%        0.80%        0.80%       0.80%        0.80%       0.80%        0.80%          0.80%         0.80%            0.80%       0.80%        0.80%        0.80%        0.80%         0.80%        0.80%       0.80%        0.80%       0.80%        0.80%          0.80%        0.80%        0.80%        0.80%        0.80%       0.80%        0.80%        0.80%        0.80%       0.80%        0.80%       0.80%        0.80%       0.80%      0.80%      0.80%      0.80%      0.80%
P/Tax                              5.45% (A+B)                                              6.3765%                           5.45%         5.45%        5.45%        5.45%         5.45%      5.45%       5.45%      5.45%       5.45%        5.45%          5.45%        5.45%        5.45%      5.45%      5.45%       5.45%        5.45%        5.45%        5.45%       5.45%        5.45%       5.45%        5.45%          5.45%         5.45%            5.45%       5.45%        5.45%        5.45%        5.45%         5.45%        5.45%       5.45%        5.45%       5.45%        5.45%          5.45%        5.45%        5.45%        5.45%        5.45%       5.45%        5.45%        5.45%        5.45%       5.45%        5.45%       5.45%        5.45%       5.45%      5.45%      5.45%      5.45%      5.45%
Super (B)                         17.00% (A)                                          17   17.0000%                          17.00%        17.00%       17.00%       17.00%        17.00%     17.00%      17.00%     17.00%      17.00%       17.00%         17.00%       17.00%       17.00%     17.00%     17.00%      17.00%       17.00%       17.00%       17.00%      17.00%       17.00%      17.00%       17.00%         17.00%        17.00%           17.00%      17.00%       17.00%       17.00%       17.00%        17.00%       17.00%      17.00%       17.00%      17.00%       17.00%         17.00%       17.00%       17.00%       17.00%       17.00%      17.00%       17.00%       17.00%       17.00%      17.00%       17.00%      17.00%       17.00%      17.00%     17.00%     17.00%     17.00%     17.00%
Parental Lev Prov                  0.60% (A+B)                                              0.7020%                           0.60%         0.60%        0.60%        0.60%         0.60%      0.60%       0.60%      0.60%       0.60%        0.60%          0.60%        0.60%        0.60%      0.60%      0.60%       0.60%        0.60%        0.60%        0.60%       0.60%        0.60%       0.60%        0.60%          0.60%         0.60%            0.60%       0.60%        0.60%        0.60%        0.60%         0.60%        0.60%       0.60%        0.60%       0.60%        0.60%          0.60%        0.60%        0.60%        0.60%        0.60%       0.60%        0.60%        0.60%        0.60%       0.60%        0.60%       0.60%        0.60%       0.60%      0.60%      0.60%      0.60%      0.60%
                                                                                                         25.0145%

Fixed                                 Fix                                           100 100.0000%                           100.00%       100.00%      100.00%      100.00%       100.00%    100.00%     100.00%    100.00%     100.00%      100.00%        100.00%      100.00%      100.00%    100.00%    100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%       100.00%          100.00%     100.00%      100.00%      100.00%      100.00%       100.00%      100.00%     100.00%      100.00%     100.00%      100.00%        100.00%      100.00%      100.00%      100.00%      100.00%     100.00%      100.00%      100.00%      100.00%     100.00%      100.00%     100.00%      100.00%     100.00%    100.00%    100.00%    100.00%    100.00%
W/Comp                             0.80% (A+B)                                            0.8720%                             0.80%         0.80%        0.80%        0.80%         0.80%      0.80%       0.80%      0.80%       0.80%        0.80%          0.80%        0.80%        0.80%      0.80%      0.80%       0.80%        0.80%        0.80%        0.80%       0.80%        0.80%       0.80%        0.80%          0.80%         0.80%            0.80%       0.80%        0.80%        0.80%        0.80%         0.80%        0.80%       0.80%        0.80%       0.80%        0.80%          0.80%        0.80%        0.80%        0.80%        0.80%       0.80%        0.80%        0.80%        0.80%       0.80%        0.80%       0.80%        0.80%       0.80%      0.80%      0.80%      0.80%      0.80%
P/Tax                              5.45% (A+B)                                            5.9405%                             5.45%         5.45%        5.45%        5.45%         5.45%      5.45%       5.45%      5.45%       5.45%        5.45%          5.45%        5.45%        5.45%      5.45%      5.45%       5.45%        5.45%        5.45%        5.45%       5.45%        5.45%       5.45%        5.45%          5.45%         5.45%            5.45%       5.45%        5.45%        5.45%        5.45%         5.45%        5.45%       5.45%        5.45%       5.45%        5.45%          5.45%        5.45%        5.45%        5.45%        5.45%       5.45%        5.45%        5.45%        5.45%       5.45%        5.45%       5.45%        5.45%       5.45%      5.45%      5.45%      5.45%      5.45%
Super (B)                          9.00% (A)                                          9   9.0000%                             9.00%         9.00%        9.00%        9.00%         9.00%      9.00%       9.00%      9.00%       9.00%        9.00%          9.00%        9.00%        9.00%      9.00%      9.00%       9.00%        9.00%        9.00%        9.00%       9.00%        9.00%       9.00%        9.00%          9.00%         9.00%            9.00%       9.00%        9.00%        9.00%        9.00%         9.00%        9.00%       9.00%        9.00%       9.00%        9.00%          9.00%        9.00%        9.00%        9.00%        9.00%       9.00%        9.00%        9.00%        9.00%       9.00%        9.00%       9.00%        9.00%       9.00%      9.00%      9.00%      9.00%      9.00%
Parental Lev Prov                  0.60% (A+B)                                            0.6540%                             0.60%         0.60%        0.60%        0.60%         0.60%      0.60%       0.60%      0.60%       0.60%        0.60%          0.60%        0.60%        0.60%      0.60%      0.60%       0.60%        0.60%        0.60%        0.60%       0.60%        0.60%       0.60%        0.60%          0.60%         0.60%            0.60%       0.60%        0.60%        0.60%        0.60%         0.60%        0.60%       0.60%        0.60%       0.60%        0.60%          0.60%        0.60%        0.60%        0.60%        0.60%       0.60%        0.60%        0.60%        0.60%       0.60%        0.60%       0.60%        0.60%       0.60%      0.60%      0.60%      0.60%      0.60%
                                                                                                             16.4665%

Salary Conversion Factor
Annual to fortnight      26.0893


Validation lists
List 1                      con
                            fix
List 2                      sup
                            ssg




                                                                                                                                                                                                                                                                                                                                                                                                                    470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
   1/30/2011


                                                                                             Check lookup range
UTS Pay Dates
                                                           = linked

    2010       23/12/10
    2011       06/01/11
    2011       20/01/11                  Base First Pay                                      Last Pay
    2011       03/02/11                  Start Date                                          Finish Date
    2011       17/02/11                       00/01/00                                           00/01/00
    2011       03/03/11
    2011       17/03/11                  Start Date = Pay Date?                              Finish Date = Pay Date?
    2011       31/03/11                               No                                                No
    2011       14/04/11
    2011       28/04/11                  Next Pay Date                                       Final Pay Date
    2011       12/05/11                          #N/A                                                  #N/A
    2011       26/05/11
    2011       09/06/11                          #N/A      < Net work days                             #N/A   < Net work days
    2011       23/06/11
    2011       07/07/11                          #N/A      < % of First pay fortnight                  #N/A   < % of last pay fortnight
    2011       21/07/11
    2011       04/08/11
    2011       18/08/11                  Allowance, Loadings etc-First Pay                   Last Pay
    2011       01/09/11                  Start Date
    2011       15/09/11                       00/01/00
    2011       29/09/11
    2011       13/10/11                  Start Date = Pay Date?                              Finish Date = Pay Date?
    2011       27/10/11                               No                                                No
    2011       10/11/11
    2011       24/11/11                  Next Pay Date                                       Final Pay Date
    2011       08/12/11                          #N/A                                                  #N/A
    2011       22/12/11
    2012       05/01/12                          #N/A      < Net work days                      #VALUE!       < Net work days
    2012       19/01/12
    2012       02/02/12                          #N/A      < % of First pay fortnight           #VALUE!       < % of last pay fortnight
    2012       16/02/12
    2012       01/03/12
    2012       15/03/12                  Increment - First Pay
    2012       29/03/12                  Start Date
    2012       12/04/12                       00/01/00
    2012       26/04/12
    2012       10/05/12                  Start Date = Pay Date?
    2012       24/05/12                               No
    2012       07/06/12
    2012       21/06/12                  Next Pay Date
    2012       05/07/12                          #N/A
    2012       19/07/12
    2012       02/08/12                          #N/A      < Net work days
    2012       16/08/12
    2012       30/08/12                          #N/A      < % of First pay fortnight
    2012       13/09/12
    2012       27/09/12
    2012       11/10/12                  Salary Increase 1 - First Pay
    2012       25/10/12                  Start Date
    2012       08/11/12                       00/01/00
    2012       22/11/12

                                                            470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
2012   06/12/12   Start Date = Pay Date?
2012   20/12/12                No
2013   03/01/13
                  Next Pay Date
                          #N/A


                          #N/A      < Net work days

                          #N/A      < % of First pay fortnight


                  Salary Increase 2 - First Pay
                  Start Date
                      00/01/00


                  Start Date = Pay Date?
                               No


                  Next Pay Date
                          #N/A


                          #N/A      < Net work days

                          #N/A      < % of First pay fortnight




                                     470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
   1/30/2011


LSL PROVISION CALCULATION VARIABLES


   YEARS        PROBABILITY                                                                                                       LSL
                                                   DISCOUNT FACTOR (source: http://www.rba.gov.au/statistics/tables/xls/f02dhist.xls) LIABILITY (before On-Costs)
 IN SERVICE       RATES
          0            0.31                        Treasury 10yr bond rate:     31-Oct-05             5.480%                          A      TOTAL HRS
          1            0.48                                                    30-Nov-05              5.380%                          B      HRLY RATE
          2            0.60                                                    31-Dec-05              5.200%                          C*     FUTURE SALARY INCREASES FACTOR              1.049
          3            0.70                                                     31-Jan-06             5.350%                          D      PROBABILITY RATE
          4            0.80                                                    28-Feb-06              5.290%                          E      DISCOUNT FACTOR - GOVT BOND RATE
          5            0.86                                                    31-Mar-06              5.410%
          6            0.90                                                     30-Apr-06             5.700%                     FORMULA = (A * B * C * D) / (1 + E)
          7            0.93                                                    31-May-06              5.710%
          8            0.96                                                     30-Jun-06             5.790%
          9            0.98                                                      31-Jul-06            5.840%                     * For C, current rate used is 1.049
         10            1.00                                                    31-Aug-06              5.670%
         11            1.00                                                    30-Sep-06              5.510%
         12            1.00                                                     31-Oct-06             5.660%
         13            1.00                                                    30-Nov-06              5.590%
         14            1.00                                                    31-Dec-06              5.885%
         15            1.00                                                     31-Jan-07             5.930%
         16            1.00                                                    28-Feb-07              5.685%
         17            1.00                                                    31-Mar-07              5.880%
         18            1.00                                                     30-Apr-07             5.880%
         19            1.00                                                    31-May-07              6.020%
         20            1.00                                                     30-Jun-07             6.260%
         21            1.00                                                      31-Jul-07            6.030%
         22            1.00                                                    31-Aug-07              5.920%
         23            1.00                                                    30-Sep-07              6.155%
         24            1.00                                                     31-Oct-07             6.175%
         25            1.00                                                    30-Nov-07              5.995%
         26            1.00                                                    31-Dec-07              6.325%                                 LSL Start date                                          0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00         0/01/00        0/01/00        0/01/00        0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00       0/01/00        0/01/00
         27            1.00                                                     31-Jan-08             6.085%                                 Current month end date                                  6/01/11       20/01/11       3/02/11       17/02/11       3/03/11       17/03/11       31/03/11       14/04/11       28/04/11       12/05/11       26/05/11       9/06/11       23/06/11       7/07/11       21/07/11       4/08/11       18/08/11       1/09/11       15/09/11        29/09/11       13/10/11       27/10/11       10/11/11       24/11/11       8/12/11       22/12/11       5/01/12       19/01/12       2/02/12       16/02/12       1/03/12       15/03/12       29/03/12       12/04/12       26/04/12       10/05/12       24/05/12       7/06/12       21/06/12       5/07/12       19/07/12       2/08/12       16/08/12       30/08/12       13/09/12       27/09/12       11/10/12       25/10/12       8/11/12       22/11/12       6/12/12       20/12/12       3/01/13       17/01/13
         28            1.00                                                    29-Feb-08              6.210%
         29            1.00                                                    31-Mar-08              6.040%                                 Years Service to Date                                   111.02         111.06        111.09         111.13        111.17         111.21         111.25         111.29         111.32         111.36         111.40        111.44         111.48        111.52         111.55        111.59         111.63        111.67         111.71          111.75         111.78         111.82         111.86         111.90        111.94         111.98        112.01         112.05        112.09         112.13        112.17         112.21         112.24         112.28         112.32         112.36         112.40        112.44         112.47        112.51         112.55        112.59         112.63         112.67         112.70         112.74         112.78         112.82        112.86         112.90        112.93         112.97        113.01         113.05
         30            1.00                                                     30-Apr-08             6.290%
         31            1.00                                                    31-May-08              6.530%
         32            1.00                                                     30-Jun-08             6.450%                     A           Total Hours                                                -              -             -              -             -              -              -              -      #REF!                  -              -             -              -             -              -             -              -             -              -               -              -              -              -              -             -              -             -              -             -              -             -              -              -              -              -              -              -             -              -             -              -             -              -              -              -              -              -              -             -              -             -              -             -              -
          33             1.00                                                    31-Jul-08            6.225%
          34             1.00                                                   31-Aug-08             5.750%                     B           Hrly Rate                                           $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $        -     $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
          35             1.00                                                   30-Sep-08             5.395%
          36             1.00                                                   31-Oct-08             5.175%                     D1          Years Service                                              -              -             -              -             -              -              -              -               -             -              -             -              -             -              -             -              -             -              -               -              -              -              -              -             -              -             -              -             -              -             -              -              -              -              -              -              -             -              -             -              -             -              -              -              -              -              -              -             -              -             -              -             -              -
          37             1.00                                                   30-Nov-08             4.580%
          38             1.00                                                   31-Dec-08             3.990%                     D2          Probability Rate                                          0.31           0.31          0.31           0.31          0.31           0.31           0.31           0.31            0.31          0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31            0.31           0.31           0.31           0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31           0.31           0.31           0.31           0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31           0.31           0.31           0.31           0.31           0.31          0.31           0.31          0.31           0.31          0.31           0.31
          39             1.00                                                   31-Jan-09             4.100%
          40             1.00                                                   28-Feb-09             4.400%                     E           Discount factor                             5.32%       105.32%       105.32%        105.32%       105.32%        105.32%       105.32%        105.32%        105.32%        105.32%        105.32%        105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%         105.32%        105.32%        105.32%        105.32%        105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%        105.32%        105.32%        105.32%        105.32%        105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%        105.32%        105.32%        105.32%        105.32%        105.32%        105.32%       105.32%        105.32%       105.32%        105.32%       105.32%
          41             1.00                                                   31-Mar-09             4.410%
          42             1.00                                                   30-Apr-09             4.570%                                 Base LSL                                            $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
          43             1.00                                                  31-May-09              5.275%
          44             1.00                                                   30-Jun-09             5.515%                     C           Future Salary increas Factor                             1.049          1.049         1.049          1.049         1.049          1.049          1.049          1.049          1.049          1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049           1.049          1.049          1.049          1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049          1.049          1.049          1.049          1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049          1.049          1.049          1.049          1.049          1.049         1.049          1.049         1.049          1.049         1.049          1.049
          45             1.00                                                    31-Jul-09            5.640%
          46             1.00                                                   31-Aug-09             5.405%                                 LSL LIAB + 4.9%                                     $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
          47             1.00                                                   30-Sep-09             5.355%
          48             1.00                                                   31-Oct-09             5.540%                                 P/TAX                                       5.50%   $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
          49             1.00                                                   30-Nov-09             5.230%
          50             1.00                                                   31-Dec-09             5.645%                                 W/COMP                                      0.75%   $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
                                                                                31-Jan-10             5.380%
                                                                                28-Feb-10             5.430%                                 SUPER (49% of LSL taken in service x 17%)   8.33%   $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
                                                                                31-Mar-10             5.760%
                                                                                30-Apr-10             5.710%                                 Total                                               $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      #REF!          $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -       $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -      $       -      $       -      $       -      $       -      $       -      $      -      $       -      $      -      $       -      $      -      $       -
                                                                               31-May-10              5.375%
                                                                                30-Jun-10             5.095%
                                                                                 31-Jul-10            5.195%
                                                                                31-Aug-10             4.765%
                                                                                30-Sep-10             4.960%
                                                                                31-Oct-10             5.205%
                                                                                30-Nov-10             5.405%
                                                                                31-Dec-10             5.570%          5.32%
                                                                                31-Jan-11
                                                                                28-Feb-11
                                                                                31-Mar-11
                                                                                30-Apr-11
                                                                               31-May-11
                                                                                30-Jun-11
                                                                                 31-Jul-11
                                                                                31-Aug-11
                                                                                30-Sep-11
                                                                                31-Oct-11
                                                                                30-Nov-11
                                                                                31-Dec-11
                                                                                31-Jan-12
                                                                                29-Feb-12
                                                                                31-Mar-12
                                                                                30-Apr-12
                                                                               31-May-12
                                                                                30-Jun-12
                                                                                 31-Jul-12
                                                                                31-Aug-12
                                                                                30-Sep-12
                                                                                31-Oct-12
                                                                                30-Nov-12
                                                                                31-Dec-12
                                                                                31-Jan-13
                                                                                28-Feb-13




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       470e10c0-a8f0-4174-b615-f6f2dcff930d.xls
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
           1/30/2011


Notes
Increases up to and including 1-Nov-09 were effective from the first full pay period on or after the date indicated in the table below.
Increases after 1-Nov-09 were effective from the date indicated in the table below.

                                        2%                 2%                    2%           2%           2%           2%           2%
Classification         Step          01-May-10          01-Nov-10             01-May-11    01-Nov-11    01-May-12    01-Nov-12    01-May-13
HEW1                   s1011             37,243             37,988                38,748       39,523       40,314       41,120       41,942
                       s1012             38,087             38,849                39,626       40,418       41,227       42,051       42,892
                       s1013             38,936             39,715                40,509       41,319       42,146       42,989       43,848
HEW2                   s1021             40,203             41,007                41,828       42,664       43,517       44,388       45,276
                       s1022             41,051             41,872                42,710       43,564       44,435       45,324       46,230
                       s1023             42,109             42,951                43,810       44,687       45,580       46,492       47,422
HEW3                   s1031             42,320             43,166                44,030       44,910       45,808       46,724       47,659
                       s1032             43,802             44,678                45,571       46,483       47,413       48,361       49,328
                       s1033             45,284             46,190                47,113       48,056       49,017       49,997       50,997   `
                       s1034             46,766             47,701                48,655       49,628       50,621       51,633       52,666
                       s1035             48,247             49,211                50,196       51,200       52,224       53,268       54,333
HEW4                   s1041             48,669             49,642                50,635       51,648       52,681       53,735       54,809
                       s1042             49,515             50,506                51,516       52,546       53,597       54,669       55,762
                       s1043             50,785             51,801                52,837       53,894       54,972       56,071       57,193
                       s1044             52,057             53,098                54,160       55,243       56,348       57,475       58,625
HEW5                   s1051             52,900             53,958                55,038       56,138       57,261       58,406       59,574
                       s1052             54,171             55,254                56,359       57,486       58,636       59,809       61,005
                       s1053             55,441             56,549                57,680       58,834       60,011       61,211       62,435
                       s1054             57,133             58,276                59,441       60,630       61,843       63,080       64,341
                       s1055             58,826             60,002                61,202       62,426       63,675       64,948       66,247
                       s1056             60,518             61,729                62,963       64,223       65,507       66,817       68,154
HEW6                   s1061             61,365             62,592                63,844       65,121       66,423       67,752       69,107
                       s1062             63,059             64,320                65,606       66,918       68,257       69,622       71,014
                       s1063             64,751             66,046                67,367       68,714       70,089       71,491       72,920
                       s1064             66,442             67,771                69,127       70,509       71,919       73,358       74,825
HEW7                   s1071             67,714             69,068                70,450       71,859       73,296       74,762       76,257
                       s1072             69,405             70,793                72,209       73,653       75,126       76,629       78,161
                       s1073             71,100             72,522                73,973       75,452       76,961       78,501       80,071
                       s1074             72,792             74,247                75,732       77,247       78,792       80,368       81,975
                       s1075             74,908             76,406                77,934       79,493       81,083       82,704       84,359
HEW8                   s1081             76,178             77,702                79,256       80,841       82,458       84,107       85,789
                       s1082             78,295             79,860                81,458       83,087       84,748       86,443       88,172
                       s1083             80,411             82,019                83,660       85,333       87,039       88,780       90,556
                       s1084             82,526             84,176                85,860       87,577       89,329       91,115       92,938
                       s1085             84,642             86,335                88,062       89,823       91,620       93,452       95,321
                       s1086             86,759             88,494                90,264       92,069       93,910       95,789       97,704
HEW9                   s1091             88,875             90,653                92,466       94,315       96,201       98,125      100,088
                       s1092             90,990             92,810                94,666       96,559       98,491      100,461      102,470
                       s1093             93,107             94,969                96,868       98,805      100,782      102,797      104,853
HEW10                  s1101             95,222             97,126                99,069      101,050      103,071      105,132      107,235
D:\Docstoc\Working\pdf\[470e10c0-a8f0-4174-b615-f6f2dcff930d.xls]Data Input
          1/30/2011


Notes
Increases up to and including 1-Nov-09 were effective from the first full pay period on or after the date indicated in the table below.
Increases after 1-Nov-09 are effective from the date indicated in the table below.
Revised salary scale for Associate Lecturer to take effect from the commencement of the first pay period on or after the date of
certification of the Agreement.
* Any Associate Lecturer who is required to carry out full subject coordination duties as part of his or her normal duties,
   or who on appointment holds or during appointment gains a relevant doctoral qualification, will be paid a salary no lower than this point.

** From 1 November 2010, the first salary point in the scales for Levels B, C and D will be removed. Any staff member who is on the first salary point
   in Level B,C or D will automatically move to the next salary point in that scale on 1 November 2010.

                                        2%                2%                 2%            2%           2%           2%              2%
Classification        Step           01-May-10         01-Nov-10          01-May-11     01-Nov-11    01-May-12    01-Nov-12       01-May-13
Level A               Step 1             59,360            60,548             61,759        62,994       64,254       65,539          66,850
                      Step 2             62,405            63,653             64,926        66,225       67,549       68,900          70,278
                      Step 3 *            67,352             68,699            70,073       71,475       72,904        74,362          75,850
                      Step 4              72,297             73,743            75,218       76,722       78,257        79,822          81,418
Level B               Step 1              76,105              **                **           **           **            **              **
                      Step 2              78,961             80,540            82,151       83,794       85,470        87,179          88,923
                      Step 3              81,810             83,446            85,115       86,817       88,554        90,325          92,131
                      Step 4              84,669             86,362            88,089       89,851       91,648        93,481          95,351
                      Step 5              87,519             89,270            91,055       92,876       94,734        96,628          98,561
                      Step 6              90,354             92,162            94,005       95,885       97,803        99,759         101,754
Level C               Step 1              93,169              **                **          **            **           **               **
                      Step 2              95,986             97,906            99,864     101,861       103,899      105,976          108,096
                      Step 3              98,802           100,778            102,794     104,850       106,946      109,085          111,267
                      Step 4             101,618           103,650            105,723     107,838       109,994      112,194          114,438
                      Step 5             104,431           106,520            108,650     110,823       113,039      115,300          117,606
                      Step 6             107,251           109,396            111,584     113,816       116,092      118,414          120,782
Level D               Step 1             111,944             **                 **          **            **           **               **
                      Step 2             115,696           118,010            120,370     122,777       125,233      127,738          130,292
                      Step 3             119,452           121,841            124,278     126,764       129,299      131,885          134,523
                      Step 4             123,206           125,670            128,183     130,747       133,362      136,029          138,750
Level E               Step 1             143,860           146,737            149,672     152,666       155,719      158,833          162,010

								
To top