Using the Remuneration Modelling Tool

Remuneration Modelling Tool Summary

The purpose of the Remuneration Modelling tool is to provide fast access to key remuneration information. You can model increase and decreases in Salary. You can apply Salary and Bonus increases based on Performance Scores.

The Tool allows you to view information for Employee's around LSL, Sick Leave and Length of Service, Other Costs, Salary Benchmark (available through selecting Salary Increase), Performance Review Scores. You can use the model to apply information to the Employee for Bonus and Salary or your can just use it as a Visualisation option to have a snapshot of the information which has been selected in the Columns.

Modelling Status relates to where the the model is at in terms of processing. The four statuses are: Pending, Submitted, Authorised, Declined.

Model Name is Mandatory. Described the Model.

Apply Salary: reductions to the Model if you are reducing the Compensation for Employees by using the negative Salary feature. You can enter into the system, a Salary Date or Bonus Date which will be used to create new Salary and or Bonus records. Dates can be in the past or in the future. If a date is in the past, it will instantly create new Salary records for those people. Salary Start Date is Mandatory.

Remuneration Model Type: can be based on Pay, Redundancy, Growth, Expansion and Performance.

Created Date is for the date the Rems Model was created.

Salary Benchmark: column can also be used to see if the current Salary for people is in line with the Benchmark which has been recorded against the Job. Bonus Payment Dates and Salary Increase Dates can be different to each other. You can also create different dates for different people if required. If you select Bonus from the Columns option, you will be able to see the last Bonus amount.

Bonus Date/s or Salary Date/s: you are able to either bulk create the Date/s or change them for individual records. This can be done: For Bulk by entering the Date for Salary or Bonus into the field in the Filter area or, Single by entering the date for the new Salary or Bonus, into the individuals record.

Salary or Bonus: column can be entered into the model in bulk or also into a single Employee record. This is done by entering in the Salary for the Employees in the Model, in the top Filter area (Bulk, or by entering the one off amount into the Employee Record/s. Please note that if you are entering negative salary information, all Salaries need to be negative in the model. No Salary records will be created if Salaries are negative.

Columns: can be inserted into the Model by selecting the relevant Column options from the Top Filter area of the Tool.

E-mail Notifications e-mail notifications will send to user who submits and user who authorizes the model when submission and authorisation takes please.

Authorisation process which is built into the Remuneration Modelling Tool, the person that sets up the Model, can send it for Authorisation to a Manager. All Managers will be available in the selection option, when Submit is clicked. A workflow e-mail will be sent to that person. This person can then Authorise / Decline, or send it to another manager for Authorisation. If Authorisation is performed by clicking the Authorisation button, the model will be Authorised and the Salary and Bonus records created based on the dates that are in the model. If the model is a Redundancy model, you will be able to create negative Salary values. Upon authorisation no records will be created from Negative values. If you are using a Payroll integration, and the Payroll integration Supports Salary and Bonus update, this information will be sent from Subscribe-HR to Payroll. You cannot Create and Authorise a Model yourself for the reason of Risk mitigation and compliance. Please note that custom workflows can also be set-up based on specific Authorisation processes, which will only allow certain Managers to Authorise a Model. Workflow e-mails will send to the person Submitting to Model to an Authoriser and also send to the Authoriser and the Submitter, upon Authorisation of the Model of if the Model is NOT authorised.

Budget and Salary Total Information Display will be shown top right of screen. The information in here will vary based on the model. Model Total will show always, based on the SUM off all people in the model and their Salaries. Model Projection Total will show based on increase in Salary if Salary Increase Column is used. If Department Filter is used, Budget information from the Budget Sub Folder will be shown. This information is based on Budget Amount, Current Expenditure and Remainder. This information will be shown along with Total Salary and the Projection.

Creating a Remuneration Model

1. After logging into the Subscribe-HR HCM Platform, under "TOOLS" select "REMUNERATION MODELLING" from the left navigation.
2. Select the [Add New Record] button.
3. Enter the Remuneration Model Name. Ensure that the name is descriptive.
4. Select Model Type from the Dropdown option. E.g. Performance, Data Analysis, Growth, Redundancy. You can create your own options in this Dropdown by updating it in Code Library - Model Type.
5. Select Save at the top of the page.

Setting Filters on a Remuneration Model

1. Open an existing or new Remuneration Model.
2. Create the Name for the Model.
3. Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
4. Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location, Performance Score, Last Salary or Bonus Increase (>6, <12, <18, Never). Individual will allow you to select individual people and insert them into the model.
5. Select the Columns you wish to include in the Model. Salary, Bonus, Performance Score, LSL, Annual Leave. If you select Salary and OR Bonus, you will be able to see the latest Salary and Bonus and that Date they were received. You will also be able to Apply Bulk Salary and Bonus dates or enter individual dates for all of the people in the model. You can also record bulk or individual "Reasons" for Bonus and Salary Increase.
6. Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.

Budget - Using Budgets with the Remuneration Modelling Tool

1. Budget information can be see in the Remuneration Modelling Tool at the top right of the screen.
2. Budgets are set-up based on Departments.
3. Budgets need to be used in Conjunction with Department Filter. Budget Information will only show if the Filter options is based on Departments.
4. Information shown in this section relates to: Department "Budget Amount", "Current Expenditure", "Remainder".
5. These item will be calculates based on the Department, Number of People in the Department, Total Increase in Salary. Bonus Amount.

For more information about Budgets: Setting Up Budgets

Remuneration Model Type

1. Model Types include - Redundancy, Performance, Expansion and Growth.
2. Please note that if Redundancy is selected you can include negative values for Salary. This will not create new Negative Salary records for the Employees after authorisation.

Inserting Columns into the Remuneration Model

1. Once you have defined your Filters, you can insert columns into the model
2. Standard Column include: Salary + - , LSL, Length of Service, Annual Leave, Bonus, Other Cost. Please note that only Redundancy Model type will allow for Negative values for Salary.
3. Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
4. Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location. Individual will allow you to select individual people and insert them into the model.
5. Select the Columns you wish to include in the Model.
6. Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.

Sorting in the Remuneration Model

1. Once the Model is established and data options have been selected using Filters or Individual Option and Columns and been inserted, the information in the model can be sorted based on Highest and Lowest. Select the Column headings to do this. The data will sort based on Highest and Lowest amounts.

Setting Increase - Decrease Rates on Employees for Salary / Bonus

1. Open an existing or new Remuneration Model.
2. Select Salary + - (Increase or Decrease) and or Bonus. You will see fields, Current Salary, Salary Benchmark, Projected Salary, Value Increase as well as Bonus. The Projected Salary Amount value will be the same as the Current Salary until increase amount or value is entered. If Bonus is selected you can enter in a one off amount which can then be changed for each person, or you can select a % increase, for everyone which can also be changed per person. The "Projected Amount" Column will show the current Salary until the Projected amount is calculated based on the increase or decrease options have been entered. If you use negative Salary, all records need to be negative in the model.

Change History - Audit Full Change History

1. After a Model is created and "Saved", any changes in the model will be audited. Including changes to data, removal or inclusion of Columns, Comments, and the Submission - Authorisation process.
2. Audit is performed each time the Model is "Saved" and also through the Submit - Authorisation process.

Applying a Remuneration Model - Submit and Authorise

1. Create or Open an existing Remuneration Model. Including Filters, Columns and Data.
2. Submit and select the Manager you wish to get Authorisation from. Note: the Person who receives will be able to Decline (with Comments - see Audit and Change History Section), Submit to another user for Authorisation or Authorise thenselves.
3. Prior to Authorisation, the Authoriser will be asked if you want to create the records for the people in the model (Salary and or Bonus) upon authorisation. If the Authoriser says "No" the Model will be authorised without the creation of new records for the people in the Model. If you have a Salary Date (Mandatory) or Bonus Date which is in the past, the update will occur instantly. If the date is in the future, the update will create records with the future date as the start date. Salary Increase Reason will be based on what was selected in the Reason Dropdown in the Model. E.g. Performance, Annual Increase. This also applies to the Bonus. Please note that if the Model Type = Redundancy, no negative Salary records will be created. Any negative Salary records will not be created as new records against the Employee. The model for Redundancy or negative Salary will only be recorded in the model, for record keeping purposes, not for updating New Employees records. There is a step in the Authorisation process that will notify the Authoriser that no records will be created for the Employees in the model, upon authorisation of a redundancy model.

Please note that we can add additional Columns to the Modelling Tool on request.