Salary or Clustering Analysis Template

The Salary or Clustering Analysis Template is designed to assist employers in conducting their salary or clustering analysis on the four designated groups. It will facilitate the comparison of the designated group members' salary data with other employees working within the same occupational groups to determine if there is clustering in the lower salary ranges. Comparisons can be made between women and men, Aboriginal peoples and Non-Aboriginal peoples, etc. It will also provide the overall distribution or concentration of the designated group members by occupational groups.

The Template is intended to be used with Forms 2A, 2B and 2C of Schedule VI of the Employment Equity Regulations (Permanent Full-time Employees, Permanent Part-time Employees and Temporary Employees) generated from Employment Equity Computerized Reporting System (EECRS) or documents that contain similar information as set out in these Forms.

The Template is made up of two spreadsheets Salary and Distribution in one Microsoft Excel workbook. Information only has to be entered in the yellow colored fields in the Salary spreadsheet. The data in the Distribution spreadsheet are automatically generated as the Salary spreadsheet is being filled out.

Salary or Clustering Analysis Template (XLS version, 151 KB)

Salary or Clustering Analysis

Occupational Groups	Top & Bottom of Salary Range $	Quarter	All Employees		Women		Men		Aboriginal Peoples		Non-Aboriginal Peoples		Persons with Disabilities		Persons Without Disabilities		Visible Minorities		Non-Visible Minorities
			#	%	#	%	#	%	#	%	#	%	#	%	#	%	#	%	#	%
1. Senior Managers		4
		3
		2
		1
	Total
2. Middle & Other Managers		4
		3
		2
		1
	Total
3. Professionals		4
		3
		2
		1
	Total
4. Semi-Professionals & Technicians		4
		3
		2
		1
	Total
5. Supervisors		4
		3
		2
		1
	Total
6. Supervisors: Crafts & Trades		4
		3
		2
		1
	Total
7. Administrative & Senior Clerical Personnel		4
		3
		2
		1
	Total
8. Skilled Sales & Service Personnel		4
		3
		2
		1
	Total
9. Skilled Crafts & Trades Workers		4
		3
		2
		1
	Total
10. Clerical Personnel		4
		3
		2
		1
	Total
11. Intermediate Sales & Service Personnel		4
		3
		2
		1
	Total
12. Semi-Skilled Manual Workers		4
		3
		2
		1
	Total
13. Other Sales & Service Personnel		4
		3
		2
		1
	Total
14. Other Manual Workers		4
		3
		2
		1
	Total
Total Number of Employees

Distribution

Occupational Groups	All Employees		Women		Men		Aboriginal Peoples		Non-Aboriginal Peoples		Persons with Disabilities		Persons Without Disabilities		Visible Minorities		Non-Visible Minorities
	#	%	#	%	#	%	#	%	#	%	#	%	#	%	#	%	#	%
1. Senior Managers
2. Middle & Other Managers
3. Professionals
4. Semi-Professionals & Technicians
5. Supervisors
6. Supervisors: Crafts & Trades
7. Administrative & Senior Clerical
8. Skilled Sales & Service Personnel
9. Skilled Crafts & Trades Workers
10. Clerical Personnel
11. Intermediate Sales & Service
12. Semi-Skilled Manual Workers
13. Other Sales & Service Personnel
14. Other Manual Workers
Total Number of Employees