HomeMy WebLinkAbout5.A. 2007 Pay Equity Compliance Report-Res. No. 6725 A .
City of Shakopee
MEMORANDUM
TO: Mayor and City Council
Mark McNeill, City Administrator
P~
FROM: Kris Wilson, Assistant City Administrato`r'
SUBJECT: 2007 Pay Equity Compliance Report 3~'
DATE: January 24, 2008
Introduction
The City Council is asked to adopt the attached resolution, approving the City's 2007 Pay Equity
Compliance Report and directing staff to submit the report to the State of Minnesota.
Background
In 1984, the State of Minnesota adopted the Local Government Pay Equity Act (M.S. 471.991 to
471.999) requiring local governments to establish equitable compensation relationships for male
and female classes of employees in order to eliminate sex-based wage disparities in public
employment. Local governments across Minnesota are required to file a complex compliance
report with the state's Department of Employee Relations once every three years.
The City of Shakopee is required to report data for calendar year 2007 and must submit its report
to the state no later than January 31, 2008. The data in the report reflects wage levels as of
December 31, 2007 and all employees who worked an average of 14 hours per week and at least
67 calendar days (100 days for full-time students) in 2007.
The report is completed by entering data on the number of male and female employees in each
job class (i.e. Police Officer, Secretary, Lifeguard, etc.), the minimum and maximum monthly
salary for each job class, and the total number of points assigned to the position by our job
evaluation system. This data is entered into a software program provided by the state. The
software then generates a variety of statistical reports and the results of several key statistical
tests used to calculate whether or not we are in compliance with the law.
Based on the reports we have generated through the software and my understanding of the
compliance tests, I expect the City will be found in compliance.
State law requires that our compliance report be approved by the governing body prior to
submission. It also requires us to post a notice informing employees of the report's existence
and ways of obtaining a copy, and to provide a copy to the representatives of each bargaining
unit and to the public library.
Requested Action
The Council is asked to offer Resolution No. 6725, a resolution approving the City of
Shakopee's 2007 Pay Equity Compliance Report, and move its adoption.
RESOLUTION No. 6725
A RESOLUTION APPROVING THE CITY OF SHAKOPEE'S
2007 PAY EQUITY COMPLIANCE REPORT
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SHAKOPEE,
MINNESOTA, that the attached 2007 Pay Equity Compliance Report is hereby approved.
BE IT FURTHER RESOLVED, that the City Administrator is directed to submit the
attached report to the State of Minnesota no later than January 31, 2008, in compliance with the
City's obligations under the Local Government Pay Equity Act (M.S. 471.991 to 471.999).
Adopted in adjourned regular session of the City Council of the City of Shakopee,
Minnesota, held this 29th day of January, 2008.
Mayor of the City of Shakopee
ATTEST:
City Clerk
: Pay Equity Implementation Report
For Department Use Only
Send completed report to:
Pay Equity Coordinator Postmark Date of Report
Department of Employee Relations
200 Centennial Building
658 Cedar Street (651) 259-3761 (Voice) 1043 Jurisdiction ID Number
St. Paul, MN 55155-1603 (651) 282-2699 (TDD)
Part A: Jurisdiction Identification
Jurisdiction: City of Shakopee 129 Holmes St. S. Jurisdiction Type: CITY
Shakopee, MN .55379
Contact: Assistant City Administrator Kris Wilson Phone: (952) 233-9312
Fax: 9522333860
Email: kwilson@ci.shakopee.mn.us
Part B: Official Verification
0 The job evaluation system used measured skill, effort ® No salary ranges/performance differences.
responsibility and working conditions and the same
system was used for all classes of employees. ? Leave blank unless BOTH of the following. apply:
The system used was: Consultant System (Specify ~ a. Jurisdiction does not have a salary range for any job
Describe: Riley, Dettmann and Kelsey class.
b. Upon request, jurisdiction will supply documentation
showing that inequities between male and female
classes are due to performance differences.
® Health Insurance benefits for male and female
classes of comparable value have been evaluated and: Note: Do not include any documentation regarding
performance with this form.
here is a difference ~ and
the maximum salaries reported'nclude the monthly
amount paid by the employer for health insurance
An official notice has been posted at:
bulletin board in City Hall lobby
® Information in this report is complete and accurate.
(prominent location)
informing employees that the Pay Equity Implementation
Report has been filed and is available to employees upon
0 The report includes all classes of employees over request. A copy of the notice has been sent to each exclusive
which the jurisdiction has final budgetary approval representative, if any, and also to the public library.
authority.
The report was approved by:
City Council of the City of Shakopee, MN
(governing body)
John J. Schmitt
(chief elected official)
Part C: Total Payroll Mayor of the City of Shakopee
$8,542,686.00 ~ (title)
? Checking this box indicates legal signature by above official.
is the annual payroll for the calendar year just ended December 31. Date Submitted 01/25/2008
Compliance Report o1i24i2oo~
Jurisdiction: City of Shakopee
129 Holmes St. S.
Contact: Kris Wilson Phone: (952) 233-9312
Assistant City Administrator .
The statistical analysis, salary range and exceptional service pay test results are shown below. Part I is general information from
your pay equity Report data. Parts II, III and IV give you the test results.
For more detail on each test, refer to the guidebook.
I. GENERAL JOB CLASS INFORMATION
Male Female Balanced All Job
Classes Classes Classes Classes
# Job Classes 30 22 4 56
# Employees 62 36 48 146
Avg. Max Monthly
Pay per Employee $5,352.73. $4,773.83 $5,461.98
II. STATISTICAL ANALYSIS TEST Male Female
A. UNDERPAYMENT RATIO= ~ 02.7 Classes Classes
a. # at or above Predicted Pay 16 12
b. # Below Predicted Pay 14 10
c. TOTAL - 30 22
d. % Below Predicted Pay ~ 46.67. 45.45
(b divided by c = d)
* (Result is % of male classes below predicted pay divided by % of female classes below predicted pay) .
B. T -TEST RESULTS
Degrees of Freedom (DF) = 96 Value of T = 0.222
a. Avg. dill. in pay from predicted pay for male jobs = $52
b. Avg. dill. in pay from predicted pay for female jobs = $33
III. SALARY RANGE TEST = 113.74 % (Result is A divided by B)
A. Avg. # of years to max salary for male jobs = 5.07
B. Avg. # of years to max salary for female jobs = 4.45
IV. EXCEPTIONAL SERVICE PAY TEST 0.00
A. % of male classes receiving ESP 6.67
B. % of female classes receiving ESP 0.00
* (if 20% or less, test result will be 0.00)
Job Class Data Entry Verification List city of shakopee
129 Holmes St. S.
LGID: 1043
Case: 2007 Data Status:
Job Class Nbr Nbr Class Jobs Min Mo. Max Mo. Yrs to Max Yrs of Exceptional
Nbr Title Males Females Type Points.- Salary Salary Salary Service Service Pay
1 Lifeguard 0 1 F 270 $1,698.00 $1,998.00 3.00 0
2 Service Desk Attendant 0 2 F 270 $1,698.00 $1,998.00 3.00 0
3 Recreation Leader 1 0 M 275 $1,698:00 $1,998.00 3.00 0
4 Mechanic's Helper 1 0 M 273 $1;940.00 $2,282.00 3.00 0
5 Arena Supervisor 4 1 M 278 $1,940.00. $2,282.00 3.00 0
6 Building Supervisor 1 0 M 281 $1,940.00 $2,282.00 3.00 0
7 Receptionist 0 2 F 278 $2,397.00 $3,776.00 4.00 0
8 Custodian 4 0 M 283 $2,397.00 $3,776.00 4.00 0
9 Community Service Officer 1 3 F 320 $2,637.00 $3,881.00 4.00 0
10 Facilities Maintenance Worker 2 0 M 327 $2,637.00 $4,076.00 4.00 0
11 Mechanic's Apprentice 1 0 M 393 $2,855.00 $4,346.00 7.00 0
12 Office Service Worker 0 2 F 363 $2,900.00 $4,405.00 4.00 0
13 Records Clerk 0 1 F 376 $2,900.00 $4,405.00 4.00 0
14 Police Records Technician 0 2 F 382 $2,900.00. $4,405.00 4.00 0
15 Maintenance Operator 17 0 M 385 $3,078.00 $4,875.00 7.00 0
16 Accounting Clerk 2 0 1 F 390 $3,190.00 $4,768.00 4.00 0
97 Police Records Specialist 0 3 F 400 .$3,190.00 $4,768.00 4.00 0
18 Department Secretary 0 6 F 405 $3,190.00 $4,768.00. 4.00 0
19 Engineering Tech 11 0 1 F 396 $3,190.00 $4,768.00 4.00 0
20 Mechanic 2 0 M 502 $3,461.00 $5,050.00 7.00 0
21 Senior Accounting Clerk 0 1 F 456 $3,509.00 $5,167.00 5.00 0
22 Deputy City Clerk 0 1 F 503 $3,509.00 $5,167,00 5.00 0
23 Executive Secretary 0 1 F 494 $3,509.00 $5,167.00 5.00 0
24 1T Specialist 1 0 M 512 $3,942.00 $5,707.00 5.00 0
25 Graduate Engineer 1 0 M 529 $3,942.00 $5,707.00 5.00 0
26 Engineering Tech III 1 0 M 530 $3,942.00 $5,707.00 5.00 0
27 Communications Coordinator 0 1 F 554 $3,942.00 $4,927.00 5.00 0
28 Human Resources Technician 0 1 F 555 $3,942.00 $5,707.00 5.00 0
29 Police Records Supervisor 0 1 F 559 $3,942.00 $5,707.00 5.00 0
30 Telecommunications Coordinatc 1 0 M 577 $3,942.00 $5,707.00 5.00. 0
Job Class Data Entry Verification List city of snakopee
129 Holmes St. S.
LGID: 1043
Case: 2007 Data Status:
Job Class Nbr Nbr Class Jobs Min Mo. Max Mo. Yrs to Max Yrs of Exceptional
Nbr Title Males Females Type Points Salary Salary Salary Service Service Pay
31 Planner 1 1 0 M 581 $3,942.00 $5,707.00 5.00 0
32 GIS Specialist 1 0 M 570 $3,942.00 $5,707.00 5.00 0
33 Natural Resources Coordinator 1 0 M 590 $4,253.00 $6,097.00 5.00 0
34 Park & Landscape Designer 0 1 F 614 $4,253.00 $6,097.00 5.00 0
35 Engineering Technician 4 2 0 M 61$ $4,253.00 $6,097.00 5.00 0
36 Building Inspector 4 0 M 631 $4,253.00. $6,097.00 5.00 0
37 Fire Inspector 1 0 M 631 $4,253.00 $6,097.00 5.00 0
38 Maintenance Supervisor 3 0 M 640 $4,253.00.: $6,097.00 5.00 0
39 Recreation Supervisor 3 1 B 648 $4,253.00 $6,097.00 5.00 0
40 Police Officer 25 9 B 665 $3,831.00 $5,888.00 4.00 0 LONG/PERF
41 IT Coordinator 0 1 F 708 $4,595.00. $6,519.00: 5.00 0
42 P{anner2 1 1 B 744 $4,595.00 $6,519.00 5.00 0
43 Project Engineer 1 0 M 772 $4,595.00 $6,519.00 5.00 -0
44 Police Sergeant 6 2 B 771 $4,986.00 $7,013.00 4.00 0 LONG/PERF
45 Building Official 1 0 M 784' $5,291.00 $7,393.00 5.00 0
46 Assistant City Administrator 0 1 F 785. $5,291.00 $7,393.00 5.00 0
47 City Clerk 0 1 F 785 $5,291.00. $7,393.00 5.00 0
48 Public Works Superintendent 1 0 M 786 $5,291.00 $7,393.00 5.00 0
49 Assistant City Engineer 1 0 M 813 $5,291.00 $7,393.00 5.00 0
50 .Police Captain 2 0 M 901 $6,034.00 $8,322.00 6.00 0 PERFORMANCE
51 Parks Rec and NR Director 0 1 F 1105 $6,633.00 $9,071.00 6.00 0
52 Finance Director 1 0 M 1133 $6,633.00. $9,071.00 6.00 0
53 Community Dev Director 1 0 M 1148 $6,633.00 $9,071.00 6.00 0
54 PW Director City Engineer 1 0 M 1150. $6,633.00 $9,071.00 6.00 0
55 Chief of Police 1 0 M 1182. $6,633.00 $9,071.00 6.00 0 PERFORMANCE
56 City Administrator 1 0 M 1477 $7,684.00 $10,385.00 6.00 0
Predicted Pay Report for City of Shakopee ov2anoas
129 Holmes St. S.
Case: 2007 Data
Job Male Female Tota! Work Max Mo. Predicted Pay
Nbr Jobs Title Empl Empt Empl Sex Points Salary Pay Difference
1 Lifeguard 0 1 1 F 270 $1,998.00 $2,869.65. $-871..65
2 Service Desk Attendant 0 2 2 F 270 $1,998.00 $2,869.65 $-871.65
3 Recreation Leader 1 0 1 M 275 $1,998.00 $2,942.97 $-944.97'
4 Mechanic's Helper 1 0 1 M 273 $2,282.00 $2,913.46 $-631.46
5 Arena Supervisor 4 1 5 M .278 $2,282.00 $2,987.68 $-705.68
6 Building Supervisor 1 0 1 M 281 $2,282.00 $3,032.39 $-750.39
7 Receptionist 0 2 2 F 278 $3,776.00 $2,987.68 $788.32
8 Custodian 4 0 4 M 283 $3,776.00 $3,061.89 $714.11
9 Community Service Officer 1 3 4 F 320 $3,881.00 $3,610.01 $270.99
10 Facilities Maintenance Worker 2 0 2 M .327- $4,076.00 $3,713.73 ~ $362.27
11 Mechanic's Apprentice 1 0 1 M 393 $4,346.00 $4,642.74 $-296.74
12 Office Service Worker 0 2 2 F 363 $4,405.00 $4,247.54 $157.46.
13 Records Clerk 0 1 1 F 376 $4,405.00 $4,439.79 $-34.79
14 Police Records Technician 0 2 2 f= 382 $4,405.00 $4,528.31 $-123.31
15 Maintenance Operator 17 0 17 M 385 $4,875.00 $4,573.01 $301.99
16 Accounting Clerk 2 0 1 1 F 390 $4,768.00 .$4,647.23.. $120.77
17 Police Records Specialist 0 3 3 F 400 $4,768.00 $4,804.47 $-36.47
18 Department Secretary 0 6 g F 405 $4,768.00 $4,470.21 $297.79
19 Engineering Tech II 0 1 1 F 396 $4,768.00 $4,698.78 $69.22
20 .Mechanic 2 0 2 M 502. $5,050.00 $5,429.15 $-379.15
21 Senior Accounting Clerk 0 1 1 F 456 $5,167.00 .$5,176.28 $-9.28
22 Deputy City Clerk 0 1 1 F 503 $5,167.00. $5,434.07 $-267.07
23 Executive Secretary 0 1 1 F 494 $5,167.00 $5,372.88 $-205.88
24' IT Specialist 1 0 1 M 512 $5,707.00 $5,334.07 $372.93
25 Graduate Engineer 1 0 1 M 529 $5,707.00 $5,506.20 $200.80
26 .Engineering Tech III 1 0 1 M 530 $5,707.00 $5,512.24 $194.76
27 Communications Coordinator 0 1 1 F 554 $4,927.00 $5,653.36.. $-726.36
28 Human Resources Technician 0 1 1 F 555 $5,707.00. $5,659.40. $47.60
29 Police Records Supervisor 0 1 1 F 559 $5,707.00 $5,682.86 $24.14
30 Telecommunications Coordinator 1 0 1 M .577 $5,707.00. $5,788.78 $-81.78
31 Planner 1 1 0 1 M 581 $5,707.00 $5,812.60. $-105.60
32 GIS Specialist 1 0 1 M 570 $5,707.00 $5,747.91. $-40.91
33 Natural Resources Coordinator 1 0 1 M .590 $6,097.00 $5,865.56 $231.44
34 Park & Landscape Designer 0 1 1 F 614 $6,097.00 $6,007.03 $89.97
35 Engineering Technician 4 2 0 2 M 618 $6,097.00 $6,030.49 $66.51
36 Building Inspector 4 0 4 M 631 $6,097.00 $6,081.34 $15.66.
37 Fire Inspector 1 0 1 M 631 $6,097.00 $6,081.34 $15.66
38 Maintenance Supervisor 3 0 3 M 640 $6,097.00 $6,124.90 $-27.90
39 Recreation Supervisor 3 1 4 g 648 $6,097.00 $6,159.77. $-62.77
40 Police Officer 25 9 34 g 665 $5,888.00 $6,298.86 $-410.86
41 IT Coordinator 0 1 1 F 708 $6,519.00. $6,632.74 $-113.74
42 Planner 2 1 1 2 g 744 $6,519.00 $6,868.88 $-349.88
Page 1 of 2
Predicted Pay Report for City of Shakopee ov24rzoos
129 Holmes St. S.
Case: 2007 Data
Job Male Female Total Work Max Mo. .Predicted Pay
Nbr Jobs Titie Empl Empl Empl Sex Points Salary Pay Difference.
43 Project Engineer 1 0 1 p~ 772 $6,519.00 $7,172.66 $-653.66
44 Pofice Sergeant 6 2 g g 771 $7,013.00 $7,169.20 $-156.20
45 Building OfFicial 1 0 1 M 784 $7,393.00 $7,265.77 $127.23
46 Assistant City Administrator 0 1 ~ F 785 $7,393.00 $7,273.76 $119.24
47 City Clerk 0 1 1 F 785 $7,393.00. $7,273.76 $119.24
48 Public Works Superintendent 1 0 1 M 786 $7,393.00 $7,281.76 $111.24
49 Assistant City Engineer 1 0 ~ M 813 $7,393.00 $7,487.74 $-94,74
50 Police Captain 2 0 2 M 901 $8,322.00 $7,757.79 $564.21
51 Parks Rec and NR Director 0 1 ~ F 1.105 $9,071.00 $8,900.47 $170.53
52 Finance Director 1 0 1 M 1133 ~ $9,071.00 $8,963.16 $107.84
53 Community Dev Director ~ 0 ~ M 1148 $9,071.00 $9,033.04 $3~.9s
54 PW Director City Engineer 1 0 1 M 1150 $9,071.00 $9,042.30 $28.70
55 Chief of Police 1 0 1 M 1182 $9,071.00 $9,191.05 $-120.05
56 City Administrator 1 0 1 M 1477 $10,385.00 $10,563.14 $-178.14
Page 2 of 2
Predicted Pay for City of Shakopee
10663
O
9796.5
8930
8063.5
7197
~ ~O
~ 6330.5
5464.
4597.5
3731
2864.5
1998 T
O ~ ~ M ~ ti Mme' O
N M lA C4 1~ CO ~ N M
v
Points
Predicted ~ Female Jobs O Male Jobs Balanced Jobs