Workforce Analysis - Minnesota Department of Human Rights

Document Sample
Workforce Analysis - Minnesota Department of Human Rights Powered By Docstoc
					You may use the spreadsheet on the next sheet (see sheet tab below) to prepare your Workforce
Analysis for your State of Minnesota Affirmative Action Plan. We have set up this spreadsheet
with Workforce Analysis sheets for four Departments/Organizational Units with sixteen or fewer
job titles in each department. Please adjust the number and size of these sheets to fit your
company's workforce. If you need assistance with preparing the Workforce Analysis, please call
651.296.5663 or 800.657.3704 and ask to speak with a Compliance Services Officer.

General Requirements for the Workforce Analysis:
1. For every department or organizational unit in your company, prepare a separate Workforce
Analysis sheet.
2. For each department, list all of the job titles in your workforce as they appear in your
company (on job descriptions, union contracts, payroll records, or the like.)
3. For each job title, give information about the job's wage or salary range, the total number of
incumbents, their gender, and their race.
4. Order these job titles by wage or salary range.
For more information about preparing this analysis, consult the Department's How to Develop an
Affirmative Action Plan Manual, or contact the Department.

Once you have completed the Workforce Analysis, print out all of the pages you completed, and
insert them in the appropriate section of your Affirmative Action Plan.
                                                                       Workforce Analysis
                                                                   by Department/Organizational Unit

Department name:                                                                                           Company Name:
Date of Workforce Information:                                                                                   Address:


                                                                                                                        Employees by Minority Status*
                                                                         Employees by Sex
                                             Wage Rate                                                 Male Minority Employees   Female Minority Employees     Total
                                             or Salary   Total       Total Male    Total Female    AI/               NH/  AI/                   NH/           Minority
         Job Title(s)            Job Group    Range    Employees     Employees      Employees      AN      A   B   H OP M AN          A   B   H OP M         Employees
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
Totals                                                     0              0              0             0   0   0    0    0   0   0    0   0    0   0    0        0

*AI/AN=American Indian/Alaskan Native; A=Asian; B=Black or African American; H=Hispanic or Latino; NH/OP=Native Hawaiian or Other Pacific Islander;
 M=people who identify as more than one race (Count each person only once. For example, if a man identifies as being American Indian and Black,
 count him in the "M" column under "Minority Male". Do not count him as one Black man and one American Indian man.)




                                                                          Workforce Analysis                                                                         Page 2
                                                                       Workforce Analysis
                                                                   by Department/Organizational Unit

Department name:                                                                                           Company Name:
Date of Workforce Information:                                                                                   Address:


                                                                                                                        Employees by Minority Status*
                                                                         Employees by Sex
                                             Wage Rate                                                 Male Minority Employees   Female Minority Employees     Total
                                             or Salary   Total       Total Male    Total Female    AI/               NH/  AI/                   NH/           Minority
         Job Title(s)            Job Group    Range    Employees     Employees      Employees      AN      A   B   H OP M AN          A   B   H OP M         Employees
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
Totals                                                     0              0              0             0   0   0    0    0   0   0    0   0    0   0    0        0

*AI/AN=American Indian/Alaskan Native; A=Asian; B=Black or African American; H=Hispanic or Latino; NH/OP=Native Hawaiian or Other Pacific Islander;
 M=people who identify as more than one race (Count each person only once. For example, if a man identifies as being American Indian and Black,
 count him in the "M" column under "Minority Male". Do not count him as one Black man and one American Indian man.)




                                                                          Workforce Analysis                                                                         Page 3
                                                                       Workforce Analysis
                                                                   by Department/Organizational Unit

Department name:                                                                                           Company Name:
Date of Workforce Information:                                                                                   Address:


                                                                                                                        Employees by Minority Status*
                                                                         Employees by Sex
                                             Wage Rate                                                 Male Minority Employees   Female Minority Employees     Total
                                             or Salary   Total       Total Male    Total Female    AI/               NH/  AI/                   NH/           Minority
         Job Title(s)            Job Group    Range    Employees     Employees      Employees      AN      A   B   H OP M AN          A   B   H OP M         Employees
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
Totals                                                     0              0              0             0   0   0    0    0   0   0    0   0    0   0    0        0

*AI/AN=American Indian/Alaskan Native; A=Asian; B=Black or African American; H=Hispanic or Latino; NH/OP=Native Hawaiian or Other Pacific Islander;
 M=people who identify as more than one race (Count each person only once. For example, if a man identifies as being American Indian and Black,
 count him in the "M" column under "Minority Male". Do not count him as one Black man and one American Indian man.)




                                                                          Workforce Analysis                                                                         Page 4
                                                                       Workforce Analysis
                                                                   by Department/Organizational Unit

Department name:                                                                                           Company Name:
Date of Workforce Information:                                                                                   Address:


                                                                                                                        Employees by Minority Status*
                                                                         Employees by Sex
                                             Wage Rate                                                 Male Minority Employees   Female Minority Employees     Total
                                             or Salary   Total       Total Male    Total Female    AI/               NH/  AI/                   NH/           Minority
         Job Title(s)            Job Group    Range    Employees     Employees      Employees      AN      A   B   H OP M AN          A   B   H OP M         Employees
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
                                                                                                                                                                 0
Totals                                                     0              0              0             0   0   0    0    0   0   0    0   0    0   0    0        0

*AI/AN=American Indian/Alaskan Native; A=Asian; B=Black or African American; H=Hispanic or Latino; NH/OP=Native Hawaiian or Other Pacific Islander;
 M=people who identify as more than one race (Count each person only once. For example, if a man identifies as being American Indian and Black,
 count him in the "M" column under "Minority Male". Do not count him as one Black man and one American Indian man.)




                                                                          Workforce Analysis                                                                         Page 5

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:4/16/2010
language:English
pages:5