Compensation metrics

The following metrics are used primarily in the Compensation analysis reports. See the object definition for details.

Metric/KPI	Description	Formula
Compensation Cost	This is the overall cost of compensation sustained by the company.	Sum([Compensation Cost]) {~}
Avg. Compensation Cost per Employee	See formula to the right.	([Compensation Cost] / Employees)
Compensation Cost to All Functions	Overall compensation cost with no grouping by employee function.	Sum([Compensation Cost]) {~, [Employee Function]}
Compensation Cost to All Locations	Overall compensation cost with no grouping by employee location.	Sum([Compensation Cost]) {~, [Employee Location]}
Compensation Cost to All Profile	Overall compensation cost with no grouping by employee profile.	Sum([Compensation Cost]) {~, [Employee Profile]}
Compensation Cost Contribution to Functions	See formula to the right.	([Compensation Cost] / [Compensation Cost to All Functions])
Compensation Cost Contribution to Locations	See formula to the right.	([Compensation Cost] / [Compensation Cost to All Locations])
Compensation Cost Contribution to Profile	See formula to the right.	([Compensation Cost] / [Compensation Cost to All Profile])
Paid Salary	Compensation cost with conditionality on Compensation Type = Salary.	Sum([Compensation Cost]) {~} <[Base Salary]>
Paid Bonus	Compensation cost with conditionality on Compensation Type = Bonus.	Sum([Compensation Cost]) {~} <[Regular Bonus]>
Awards	Compensation cost with conditionality set on the filter "Awards".	Sum([Compensation Cost]) {~} <Awards>
Bonus Potential	Bonus potential assigned to each employee each year.	Sum([Bonus Potential]) {~}
Annual Salary	Annual salary paid to the employee.	Sum([Annual Salary]) {~}
Avg. Annual Salary per Employee	See formula to the right.	([Annual Salary] / Employees)
Average Annual Salary	Average (function) salary with dimensionality set on Employee.	Avg([Annual Salary]) {~, Employee}
Median Annual Salary	Median (function) salary with dimensionality set on Employee.	Median([Annual Salary]) {~, Employee}
Mode Annual Salary	Mode (function) salary with dimensionality set on Employee.	Mode([Annual Salary]) {~, Employee}
Hourly Rate	Salary rate assigned to each active contractor.	Sum([Salary Rate]) {~, Time} <[Active Contractor]>
Contract Cost	Total cost of the contract. See formula to the right.	(([Hourly Rate] * 8) * [Contract Duration (days)])
Annualized Contract Cost	Total cost over one year. Usually calculated by multiplying the Hourly Rate by a constant. See formula to the right.	((365 * [Hourly Rate]) * 8)
Avg. Annualized Contract Cost per Contractor	See formula to the right.	([Annualized Contract Cost] / Contractors)
Annualized Employee Equivalents	See formula to the right	([Avg. Annualized Contract Cost per Contractor] / [Avg. Annual Salary per Employee])
Industry Mode	Most frequent industry salary or market value assigned to a certain employee level at a certain time (year).	Avg([Level Industry Standard]) {~}
Industry Min Salary	Minimum industry salary related to a certain employee level at a certain time (year).	Min([Level Min Salary]) {~}
Industry Max Salary	Maximum industry salary related to a certain employee level at a certain time (year).	Max([Level Max Salary]) {~}
Industry Max Salary - Annual Salary	See formula to the right.	([Industry Max Salary] - [Annual Salary])
Annual Salary - Industry Min Salary	See formula to the right.	([Annual Salary] - [Industry Min Salary])
Salary to Industry Mode Ratio	See formula to the right.	([Avg. Annual Salary per Employee] / [Industry Mode])
Salary to Industry Mode Variance	See formula to the right.	(([Avg. Annual Salary per Employee] - [Industry Mode]) / [Industry Mode])
Overtime (hours)	Number of hours of overtime worked.	Sum([Extra Hours]) {~}
Employees with Overtime	Number of employees working overtime.	Count(Employee) {~, Time} <[Active Employee (Hist)]>
Non-exempt Employees	Number of non-exempt employees.	Count(Employee) {~, Time} <[Non-Exempt and Active Employee (Hist)]>
Employees with Overtime to all Non-exempt Employees	See formula to the right.	((1.0001 * [Employees with Overtime]) / (1.0001 * [Non-Exempt Employees]))
Average Overtime per Employee (hours)	See formula to the right.	([Overtime (hours)] / [Employees with Overtime])
Hourly Equivalent Salary	Equivalent hourly salary, obtained by dividing the monthly salary by a constant.	(Sum([Compensation Cost]) / (30 * 8)) {~} <[Base Salary]>
Paid Overtime	See formula to the right.	(([Overtime (hours)] * [Hourly Equivalent Salary]) * 1.5)
Paid Overtime Contribution to Monthly Salary	See formula to the right.	([Paid Overtime] / [Paid Salary])
Overtime per Employee (h)	See formula to the right.	([Overtime (hours)] / [Non-Exempt Employees])
Planned Headcount	Target headcount planned by quarter.	Sum([Planned Employees]) {~}
Planned Compensation	Target compensation cost planned by quarter.	Sum([Planned Compensation]) {~}
Planned - Actual Headcount	See formula to the right.	([Planned Headcount] - Employees)
Planned - Actual Compensation	See formula to the right.	([Planned Compensation] - [Compensation Cost])
Planned - Actual Compensation Variance	See formula to the right.	([Planned - Actual Compensation] / [Planned Compensation])
Actual as % Planned Compensation	See formula to the right.	([Compensation Cost] / [Planned Compensation])