Wages in this metric should include both basic salary and remuneration as defined in the following ways:
Basic salary: Fixed, minimum amount paid to an employee for performing his or her duties.
Remuneration: Additional amounts paid to a worker. Examples of additional amounts can include those based on years of service, bonuses including cash and equity such as stocks and shares, benefit payments, overtime, time owed, and any additional allowances, such as transportation, living and childcare allowances.
β
To calculate the average gross hourly wage of salaried employees, please follow these steps:
Create a table of only full-time and part-time employees, not including temporary employees or independent contractors, and add their gender into a second column
In a new column, add each employee's total base salary for the reporting period (tip: if you are reporting for only six months, divide the annual salary by two)
In a new column, add the total amount of additional remuneration (e.g., bonuses, equity) for each employee during the reporting period
In a new column, sum the base salary and additional remuneration into a total compensation value
In a new column, divide the total compensation value by the actual or estimated number of hours worked by the employee during the reporting period for the gross hourly wage (tip: full-time employees working 40 hour work weeks for 52 weeks is 2,080 hours, or 26 weeks is 1,040 hours)
Filter for only female employees and then calculate the average gross hourly wage (from the most recently added column) for all female employees in the table
Repeat step 6 for male employees
The ratio of female gross hourly wage to the male hourly wage is the gender wage equity ratio