Workforce Analysis (WFA) Tools
WFA Template Instructions
PDF version, 135 KB - Template Instructions
The Workforce Analysis Template is designed to assist employers in preparing their workforce analysis on the four designated groups. It is made up of five worksheets in one Microsoft Excel workbook. The first four worksheets cover each of the designated groups, while the fifth worksheet summarizes the data.
Note: Information only has to be entered in the first four worksheets which cover each of the four designated groups. The fifth worksheet (Summary) is automatically updated once the other worksheets have been filled out.
Depending on the occupational levels or the geographical areas of recruitment, rows may need to be added or deleted in certain occupational groups. When these changes to the rows are made, please ensure that the affected occupational group's totals in all of the columns still reflect the sum of all of the rows, and the fifth worksheet still reflects the occupational group's totals.
Enter the following information in each of the first four worksheets for each of the designated groups:
- Column B
- Four-digit National Occupational Classification (NOC) codes for Professionals, Semi-Professionals & Technicians, Supervisors: Crafts & Trades, Skilled Sales & Service Personnel, and Skilled Crafts and Trades Workers.
- Column C
- Occupational titles that correspond to the four-digit NOC codes. For example, under Column B enter 0111, and under Column C enter Financial Managers.
- Column D
- Total number of employees in each of the occupational groups and/or NOC codes.
- Column E
- Number of designated group employees in each of the occupational groups and/or NOC codes.
- Column F
- Percentage internal representation data are calculated automatically once Columns D and E are filled out.
- Column G
- Percentage availability from Tables 4 and 5 in the 2011 Employment Equity Data Report produced by Employment and Social Development Canada, Labour Program.
- Column H
- Numbers of designated group's availability or external representation data are calculated automatically once Columns D and G are filled out.
- Column I
- Numerical gap data are calculated automatically once Columns E and H are filled out.
- Column J
- Geographical area where the employer may reasonably be expected to recruit for each of the occupational groups and/or NOC codes.
Note: Cells that are generated with automated formulas appear shaded in the template. If you add or delete a row, please ensure that the shaded cells have been correctly calculated.
WFA Template
XLS version, 91 KB - Blank Workforce Analysis Template
Warning: This page contains wide content. Horizontal scrolling may be necessary.
Women
as of date
| Occupational Group Number | Occupational Group | Occupational Level | Geographical Area of Recruitment |
All Employees # |
Women | ||||
|---|---|---|---|---|---|---|---|---|---|
| Representation | Availability | Gap | |||||||
| # | % | #* | % | #* | |||||
| 1 | Senior Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 2 | Middle & Other Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 3 | Professionals | NOC Occupational Title | National | ||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| 4 | Semi-Professionals & Technicians | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| NOC Occupational Title | Provincial | ||||||||
| 5 | Supervisors | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 6 | Supervisors: Crafts & Trades | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 7 | Administrative & Senior Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 8 | Skilled Sales & Service Personnel | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 9 | Skilled Crafts & Trades Workers | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 10 | Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 11 | Intermediate Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 12 | Semi-Skilled Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 13 | Other Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 14 | Other Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| Grand Total | |||||||||
* Totals may not equal the sum of components due to rounding.
Source: 2011 National Household Survey
Aboriginal Peoples
as of date
| Occupational Group Number | Occupational Group | Occupational Level | Geographical Area of Recruitment |
All Employees # |
Aboriginal Peoples | ||||
|---|---|---|---|---|---|---|---|---|---|
| Representation | Availability | Gap | |||||||
| # | % | #* | % | #* | |||||
| 1 | Senior Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 2 | Middle & Other Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 3 | Professionals | NOC Occupational Title | National | ||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| 4 | Semi-Professionals & Technicians | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| NOC Occupational Title | Provincial | ||||||||
| 5 | Supervisors | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 6 | Supervisors: Crafts & Trades | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 7 | Administrative & Senior Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 8 | Skilled Sales & Service Personnel | NOC Occupational Title | Privincial | ||||||
| NOC Occupational Title | Privincial | ||||||||
| 9 | Skilled Crafts & Trades Workers | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 10 | Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 11 | Intermediate Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 12 | Semi-Skilled Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 13 | Other Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 14 | Other Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| Grand Total | |||||||||
* Totals may not equal the sum of components due to rounding.
Source: 2011 National Household Survey
Persons with Disabilities
as of date
| Occupational Group Number | Occupational Group | Occupational Level | Geographical Area of Recruitment |
All Employees # |
Persons With Disabilities | ||||
|---|---|---|---|---|---|---|---|---|---|
| Representation | Availability | Gap | |||||||
| # | % | #* | % | #* | |||||
| 1 | Senior Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 2 | Middle & Other Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 3 | Professionals | Employment Equity Occupational Group (EEOG) | National | ||||||
| 4 | Semi-Professionals & Technicians | Employment Equity Occupational Group (EEOG) | National | ||||||
| 5 | Supervisors | Employment Equity Occupational Group (EEOG) | National | ||||||
| 6 | Supervisors: Crafts & Trades | Employment Equity Occupational Group (EEOG) | National | ||||||
| 7 | Administrative & Senior Clerical Personnel | Employment Equity Occupational Group (EEOG) | National | ||||||
| 8 | Skilled Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | National | ||||||
| 9 | Skilled Crafts & Trades Workers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 10 | Clerical Personnel | Employment Equity Occupational Group (EEOG) | National | ||||||
| 11 | Intermediate Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | National | ||||||
| 12 | Semi-Skilled Manual Workers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 13 | Other Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | National | ||||||
| 14 | Other Manual Workers | Employment Equity Occupational Group (EEOG) | National | ||||||
| Grand Total | |||||||||
* Totals may not equal the sum of components due to rounding.
Source: 2012 Canadian Survey on Disability
Visible Minorities
as of date
| Occupational Group Number | Occupational Group | Occupational Level | Geographical Area of Recruitment |
All Employees # |
Visible Minorities | ||||
|---|---|---|---|---|---|---|---|---|---|
| Representation | Availability | Gap | |||||||
| # | % | #* | % | #* | |||||
| 1 | Senior Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 2 | Middle & Other Managers | Employment Equity Occupational Group (EEOG) | National | ||||||
| 3 | Professionals | NOC Occupational Title | National | ||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| NOC Occupational Title | National | ||||||||
| 4 | Semi-Professionals & Technicians | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| NOC Occupational Title | Provincial | ||||||||
| 5 | Supervisors | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 6 | Supervisors: Crafts & Trades | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 7 | Administrative & Senior Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 8 | Skilled Sales & Service Personnel | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 9 | Skilled Crafts & Trades Workers | NOC Occupational Title | Provincial | ||||||
| NOC Occupational Title | Provincial | ||||||||
| 10 | Clerical Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 11 | Intermediate Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 12 | Semi-Skilled Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 13 | Other Sales & Service Personnel | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| 14 | Other Manual Workers | Employment Equity Occupational Group (EEOG) | CMA | ||||||
| Employment Equity Occupational Group (EEOG) | CMA | ||||||||
| Grand Total | |||||||||
* Totals may not equal the sum of components due to rounding.
Source: 2011 National Household Survey
as of date
| Occupational Group Number | Occupational Group | All Employees # |
Women | Aboriginal Peoples | Persons with Disabilities | Visible Minorities | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Representation | Availability | Gap | Representation | Availability | Gap | Representation | Availability | Gap | Representation | Availability | Gap | |||||||||||
| # | % | #* | % | #* | # | % | #* | % | #* | # | % | #* | % | #* | # | % | #* | % | #* | |||
| 1 | Senior Managers | |||||||||||||||||||||
| 2 | Middle & Other Managers | |||||||||||||||||||||
| 3 | Professionals | |||||||||||||||||||||
| 4 | Semi-Professionals & Tech. | |||||||||||||||||||||
| 5 | Supervisors | |||||||||||||||||||||
| 6 | Supervisors: Crafts & Trades | |||||||||||||||||||||
| 7 | Admin. & Senior Clerical | |||||||||||||||||||||
| 8 | Skilled Sales & Service | |||||||||||||||||||||
| 9 | Skilled Crafts & Trades | |||||||||||||||||||||
| 10 | Clerical Personnel | |||||||||||||||||||||
| 11 | Intermediate Sales & Service | |||||||||||||||||||||
| 12 | Semi-Skilled Manual Workers | |||||||||||||||||||||
| 13 | Other Sales & Service | |||||||||||||||||||||
| 14 | Other Manual Workers | |||||||||||||||||||||
| Grand Total | 0 | 0 | 0.0% | 0 | 0.0% | 0 | 0 | 0.0% | 0 | 0.0% | 0 | 0 | 0.0% | 0 | 0.0% | 0 | 0 | 0.0% | 0 | 0.0% | 0 | |
* Totals may not equal the sum of components due to rounding.
Sources: 2011 National Household Survey and 2012 Canadian Survey on Disability
Additional References
Page details
- Date modified: