Examples of Configurable Matrices
The examples that follow illustrate the concept of matrices and their intended uses.
Simple Rate Matrix
Use this matrix to determine the compensation rate for a worker based on his department.
| Department ID - Input | Rate (USD per hour) - Output |
|---|---|
|
10012 |
10.00 |
|
10013 |
12.00 |
|
10014 |
14.00 |
|
10015 |
16.00 |
In this example, the single input is the Department of the worker, and the output is the Rate. If a worker is in Department 10012, then the pay rate is 10.00 USD per hour.
Matrix with Two Inputs and One Output
This matrix has two inputs and one output:
| Time with Company (months) - Input | Site Risk - Input | Rate (USD per hour) - Output |
|---|---|---|
|
0–24 |
Low |
10.00 |
|
0–24 |
Medium |
12.00 |
|
0–24 |
High |
14.00 |
|
25–60 |
Low |
12.00 |
|
25–60 |
Medium |
14.00 |
|
25–60 |
High |
15.00 |
|
61–120 |
Low |
14.00 |
|
61–120 |
Medium |
14.00 |
|
61–120 |
High |
16.00 |
|
121–7200 |
Low |
16.00 |
|
121–7200 |
Medium |
17.00 |
|
121–7200 |
High |
18.00 |
In this matrix, the rate is determined by a combination of the time in company and the risk level of the work site. A worker who has been with the company for 50 months and works at a Medium risk site will be compensated at the rate of 14.00 USD per hour.
Market Pay Matrix: Matrix with Multiple Outputs of Different Types
The outputs of a matrix can be of different types, and the following example is a matrix with multiple outputs, one of which is a percentage. You use this matrix to track the compensation rates for a job at various percentiles and different geographical areas. It also tracks rates for standard compensation figures, such as total cash compensation.
In this example, the only input is the geographical area; all other columns are outputs. You can associate this matrix with a specific job code, so that the compensation administrator can track market pay for that job code across different geographical regions.
| Geo- graphy | Currency | Base 25th | Base 50th | Base 75th | Base 100th | Base Market Refer- ence | Variable Target Percent | Mean Total Compen- sation | Total Compen- sation Refer- ence |
|---|---|---|---|---|---|---|---|---|---|
|
NORTH- EST REGION |
USD |
26,000 |
27,00 |
27,500 |
28,000 |
27,000 |
12.00 |
29,000 |
30,000 |
|
MID ATLAN- TIC REGION |
USD |
24,000 |
25,000 |
25,500 |
26,000 |
25,000 |
10.00 |
27,000 |
28,000 |
|
SOUTH- WEST REGION |
USD |
27,000 |
28,000 |
28,500 |
29,000 |
28,000 |
11.00 |
30,000 |
31,000 |
Matrix with Calculated Results
You can embed calculations in the results returned by a matrix. In this example, the matrix returns rates calculated by applying a formula:
| Step - Input | Reference - Output | Percentage to Apply - Output |
|---|---|---|
|
1 |
Base Salary |
5 |
|
2 |
Grade Range Maximum |
90 |
|
3 |
Base Salary |
4 |
For example, if the worker's base salary is 10,000 USD and the worker is on Step 1, then this matrix will return a rate (Base Salary × 5%) = 10,500 USD.
Note:
The system performs the appropriate checks to find the worker's current base salary. The base salary was not stored in the matrix.