Loading...
2.1 Pay Equity Report 1-29-2024Elk River Municipal Utilities UTILITIES COMMISSION MEETING TO: FROM: ERMU Commission Mark Hanson — General Manager MEETING DATE: AGENDA ITEM NUMBER: January 29, 2024 2.1 SUBJECT: 2024 Pay Equity Report Filing ACTION REQUESTED: Approve 2024 pay equity report filing, per state requirements. BACKGROUND: The Local Government Pay Equity Act, M.S. 471.991-471.999 and Minnesota Rules, Chapter 3920 require local jurisdictions to submit a pay equity report to the State of Minnesota every three years. The basis of the reporting requirement is to ensure that male and female employees are fairly compensated for comparable work. To determine this pay equity, jobs are assigned a point value that is compared to the gender and wage of the employee(s) and a statistical analysis is performed. The filing requirement is done online (which is also where the statistical analysis is performed) and is summarized in a one -page Compliance Report, which needs to be brought to the governing body for approval. 2021 was the last time that we filed, and our 2024 report is due January 31, 2024, which reports payroll information as of December 31, 2023. DISCUSSION: There are two statistical tests used to determine compliance, an Underpayment Ratio, and a T- test. To be in compliance, an Underpayment Ratio of 80.00 or above must be met. If this ratio is too low, a low enough T-test result must be met in order to be in compliance. Our calculated Underpayment Ratio is 145.8333, and our T-test result is 0.279 (which needs to be lower than 1.684). We are in compliance with both tests. We have been monitoring compliance throughout 2021, 2022, and 2023 with the Wage and Benefits Committee. Attached are the 2024 Implementation Report, 2024 Compliance Report, and the 2024 Predicted Pay Chart we will file; as well as a copy of the Notice we are required to post. Approval from the governing body is required to submit a report, and so the report and action request is presented here for such approval. ATTACHMENTS: • 2024 Pay Equity Implementation Report • 2024 Pay Equity Compliance Report • 2024 Pay Equity Predicted Pay Chart • 2024 Pay Equity Notice Posting Page IofI HANDOUT AT MEETING - Calculation Revision �i Elk River Municipal Utilities UTILITIES COMMISSION MEETING TO: FROM: ERMU Commission Mark Hanson —General Manager MEETING DATE: AGENDA ITEM NUMBER: January 29, 2024 2.1 SUBJECT: 2024 Pay Equity Report Filing ACTION REQUESTED: Approve 2024 pay equity report filing, per state requirements. BACKGROUND: The Local Government Pay Equity Act, M.S. 471.991-471.999 and Minnesota Rules, Chapter 3920 require local jurisdictions to submit a pay equity report to the State of Minnesota every three years. The basis of the reporting requirement is to ensure that male and female employees are fairly compensated for comparable work. To determine this pay equity, jobs are assigned a point value that is compared to the gender and wage of the employee(s) and a statistical analysis is performed. The filing requirement is done online (which is also where the statistical analysis is performed) and is summarized in a one -page Compliance Report, which needs to be brought to the governing body for approval. 2021 was the last time that we filed, and our 2024 report is due January 31, 2024, which reports payroll information as of December 31, 2023. DISCUSSION: There are two statistical tests used to determine compliance, an Underpayment Ratio, and a T- test. To be in compliance, an Underpayment Ratio of 80.00 or above must be met. If this ratio is too low, a low enough T-test result must be met in order to be in compliance. Our calculated Underpayment Ratio is 167.39, and our T-test result is -0.041 (which needs to be lower than 1.684). We are in compliance with both tests. We have been monitoring compliance throughout 2021, 2022, and 2023 with the Wage and Benefits Committee. Attached are the 2024 Implementation Report, 2024 Compliance Report, and the 2024 Predicted Pay Chart we will file; as well as a copy of the Notice we are required to post. Approval from the governing body is required to submit a report, and so the report and action request is presented here for such approval. ATTACHMENTS: • 2024 Pay Equity Implementation Report • 2024 Pay Equity Compliance Report • 2024 Pay Equity Predicted Pay Chart • 2024 Pay Equity Notice Posting Page 1 of 1 ryrMANAGEMENT AND BUDGET Minnesota Pay Equity Management System - Elk River Municipal Utilities(24-No Submission) Home Utilities Go To Log Out Pay Equity Implementation Form Information entered on this page is not submitted until you click "sign and submit." This page may be printed and shared with your governing body for approval. After you receive approval, you will need to come back to this page, complete the necessary information, then click "sign and submit." Part A: Jurisdiction Identification Jurisdiction: Elk River Municipal Utilities 13069 Orono Parkway Elk River Contact: Name Title Mark Hanson General Manager Megan Zachman HR Generalist Part B: Official Verification 1. The job evaluation system used measured skill, effort responsibility and working conditions and the same system was used for all classes of employees. The system used was: Consultant's System (specify) v Describe below if the job evaluation system used is: "The same as last year', "A new system', "A substantially modified system from last year", or another descriptor not listed here: (*less than 240 characters) Riley Dettmann & Kelsey, LLC Job Evaluation System. This is the same system as was used in the prior year. 2. Health Insurance benefits for male and female classes of comparable value have been evaluated and There is no difference v � and female classes are not at a disadvantage. Part C: Total Payroll Jurisdiction Type: UTI- - Utility Phone Email 763-441-2020 mhanson@ermumn.com 763-441-2020 mzachman@ermumn.com 3. An official notice has been posted at: Elk River Municipal Utilities (prominent location) (*less than 60 characters) informing employees that the Pay equity Implementation Report has been filed and is available to employees upon request. A copy of the notice has been sent to each exclusive representative, if any, and also to the public library. The report was approved by: l Elk River Municipal Utilities (governing body) (*less than 60 characters) John Dietz (chief elected official)(*less than 60 characters) Commission Chair (title) (*less than 60 characters) 0 Checking this box indicates the following: signature of chief elected official approval by governing body all information is complete and accurate, and all employees over which the jurisdiction has final budgetary authority are included $4612176.84 is the annual payroll for the calendar year just ended December 31. Save Changes Sign & Submit Return to Test Results We have worked to ensure this product is accessible and compliant with the standard WCAG 2.0 level AA. We have tested accessibility using the JAWS software from Freedom Scientific. We found it to work correctly for us. If you find errors in accessibility, please let us know at pay.equityC&state.mn.us so that we can follow up. Thank you. HANDOUT AT MEETING - Calculation Revision MMANAGEMENT AND BUDGET Pay Equity Implementation Report Part A: Jurisdiction Identification Jurisdiction: Elk River Municipal Utilities 13069 Orono Parkway PO Box 430 Elk River, MN 55330 Contact: Megan Zachman Contact: Mark Hanson Jurisdiction Type: Utility Phone: (763) 441-2020 E-Mail: mzachman@ermumn.c om Phone: (763) 441-2020 E-Mail: mhanson@ermumn.co m Part B: Official Verification 1. The job evaluation system used measured skill, effort responsibility and working conditions and the same system was used for all classes of employees. The system was used: Consultant Description: Riley Dettmann & Kelsey, LLC Job Evaluation System. This is the same system as was used in the prior year. 2. Health Insurance benefits for male and female classes of comparable value have been evaluated and: There is no difference and female classes are not at a disadvantage. Part C: Total Pa roll $4612176.84 is the annual payroll for the calendar year just ended December 31. 3. An official notice has been posted at: Elk River Municipal Utilities (prominent location) informing employees that the Pay Equity Implementation Report has been filed and is available to employees upon request. A copy of the notice has been sent to each exclusive representative, if any, and also to the public library. The report was approved by: Elk River Municipal Utilities (governing body) John Dietz (chief elected official) Commission Chair (title) [ ] Checking this box indicates the following: - signature of chief elected official - approval by governing body - all information is complete and accurate, and - all employees over which the jurisdiction has final budgetary authority are included Date Submitted:1/26/2024 Page 1 of 1 1/29/2024 9:09:43 AM MMANAGEMENT AND BUDGET Jurisdiction: Elk River Municipal Utilities 13069 Orono Parkway PO Box 430 Elk River, MN 55330 Contact: Megan Zachman Compliance Report Phone: (763) 441-2020 Report Year: 2024 Case: 3 - 2024 Jan (Private (Jur Only)) E-Mail: mzachman@ermumn.c om 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 11, III and IV give you the test results. For more detail on each test, refer to the Guide to Pay Equity Compliance and Computer Reports. I. GENERAL JOB CLASS INFORMATION Male Classes Female Classes Balanced Classes All Job Classes # Job Classes 24 10 0 34 # Employees 34 13 0 47 Avg. Max Monthly Pay per employee 8591.20 6954.40 8138.46 II. STATISTICAL ANALYSIS TEST A. Underpayment Ratio = 145.8333 Male Classes Female Classes a. # At or above Predicted Pay 10 6 b. # Below Predicted Pay 14 4 c.TOTAL 24 10 d. % Below Predicted Pay (b divided by c = d) 58.33 40.00 *(Result is % of male classes below predicted pay divided by % of female classes below predicted pay.) B. T-test Results Degrees of Freedom DF = 45 Value of T a. Avg. diff. in pay from predicted pay for male jobs = 4 b. Avg. dill. in pay from predicted pay for female jobs = -23 III. SALARY RANGE TEST = 100.00 (Result is A divided by B) A. Avg. # of years to max salary for male jobs = 5.00 B. Avg. # of years to max salary for female jobs = 5.00 IV. EXCEPTIONAL SERVICE PAY TEST = 144.00 (Result is B divided by A) A. % of male classes receiving ESP = 20.83 B. % of female classes receiving ESP = 30.00 *(If 20% or less, test result will be 0.00) Page 1 of 1 1/26/2024 11:58:49 AM HANDOUT AT MEETING - Calculation Revision MMANAGEMENT AND BUDGET Jurisdiction: Elk River Municipal Utilities 13069 Orono Parkway PO Box 430 Elk River, MN 55330 Contact: Megan Zachman Compliance Report Phone: (763) 441-2020 Report Year: 2024 Case: 3 - 2024 Jan (Private (Jur Only)) E-Mail: mzachman@ermumn.c om 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 11, III and IV give you the test results. For more detail on each test, refer to the Guide to Pay Equity Compliance and Computer Reports. I. GENERAL JOB CLASS INFORMATION Male Classes Female Classes Balanced Classes All Job Classes # Job Classes 23 11 0 34 # Employees 33 14 0 47 Avg. Max Monthly Pay per employee 8641.00 6914.67 8126.77 II. STATISTICAL ANALYSIS TEST A. Underpayment Ratio = 167.3913 Male Classes Female Classes a. # At or above Predicted Pay 9 7 b. # Below Predicted Pay 14 4 c.TOTAL 23 11 d. % Below Predicted Pay (b divided by c = d) 60.87 36.36 *(Result is % of male classes below predicted pay divided by % of female classes below predicted pay.) B. T-test Results Degrees of Freedom DF = 45 Value of T = -0.041 a. Avg. diff. in pay from predicted pay for male jobs = 4 b. Avg. dill. in pay from predicted pay for female jobs = 7 III. SALARY RANGE TEST = 100.00 (Result is A divided by B) A. Avg. # of years to max salary for male jobs = 5.00 B. Avg. # of years to max salary for female jobs = 5.00 IV. EXCEPTIONAL SERVICE PAY TEST = 0.00 (Result is B divided by A) A. % of male classes receiving ESP = 17.39 B. % of female classes receiving ESP = 27.27 *(If 20% or less, test result will be 0.00) Page 1 of 1 1/29/2024 9:06:29 AM MANAGEMENT AND BUDGET 20000 15000 10000 11 50nn 190 Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan 380 570 760 950 1140 1330 1520 1710 1900 Points Male Jobs Female Jobs 49 Balanced Jobs — Predicted Pay ---- Line Continuation (Min) ---- Line Continuation (Max) Page 1 of 3 1/26/2024 12:03:13 PM MANAGEMENT AND BUDGET Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan Job Nbr Job Title Nbr Males Nbr Females Non- Binary Total Nbr Job Type Job Points Max Mo Salary Predicted Pay Pay Difference 40 Water Utility Worker 1 0 0 1 Male 332 4661.7700 4655.5231 6.2469 2 Customer Service Representativ 0 4 0 4 Female 369 4970.2400 4994.0728 -23.8328 42 Inventory & Procurement Asst 1 0 0 1 Male 426 5337.6400 5515.9020 -178.2620 29 Locator 2 0 0 2 Male 450 5845.4100 5735.7158 109.6942 3 Accts Payable & Payroll Specia 0 1 0 1 Female 459 5845.4100 5817.9176 27.4924 45 Billing Specialist 0 1 0 1 Female 459 5845.4100 5817.9176 27.4924 46 Credit & Collections Specialis 0 1 0 1 Female 459 5845.4100 5817.9176 27.4924 32 Communications & Admin Coordin 1 0 0 1 Male 503 6398.2400 6220.2871 177.9529 27 Bore Rig Operator 1 0 0 1 Male 526 6398.2400 6432.2193 -33.9793 5 Water Operator 3 0 0 3 Male 536 6398.2400 6524.0974 -125.8574 9 Electric Technician 1 0 0 1 Male 569 7008.2500 6860.3786 147.8714 8 Accountant 0 1 0 1 Female 609 7677.1900 7345.0650 332.1250 39 Human Resources Generalist 0 1 0 1 Female 613 7677.1900 7393.3436 283.8464 28 GIS/Mapping Technician 0 1 0 1 Female 617 7677.1900 7441.6222 235.5678 43 Water Operations Foreperson 0 1 0 1 Female 666 7677.1900 8002.0517 -324.8617 38 Lead Bore Rig Operator 1 0 0 1 Male 670 7677.1900 7986.0685 -308.8785 4 Inventory & Procurement Forepe 1 0 0 1 Male 674 7677.1900 8041.4465 -364.2565 26 Electrician/Electrical Technic 1 0 0 1 Male 674 7677.1900 8041.4465 -364.2565 47 Substation Apparatus Technicia 1 0 0 1 Male 682 8401.5800 8167.3622 234.2178 12 Lineperson 4 0 0 4 Male 740 9127.7100 8836.0351 291.6749 37 IT/OTTechnician 1 0 0 1 Male 750 8401.5800 8962.6734 -561.0934 41 Governance & Comms Mgr 1 0 0 1 Male 755 8862.5600 8992.4622 -129.9022 14 Lead Lineperson 5 0 0 5 Male 782 9677.0700 9296.3764 380.6936 15 Conservation & Key Accts Mgr 1 0 0 1 Male 813 8862.5600 9559.9869 -697.4269 16 Field Crew Foreperson 1 0 0 1 Male 813 9288.8800 9559.9869 -271.1069 31 Line Crew Foreperson 1 0 0 1 Male 884 10067.0000 9621.6601 445.3399 18 Water Superintendent 1 0 0 1 Male 990 9635.4800 9815.3041 -179.8241 17 Technical Services Superintend 1 0 0 1 Male 1129 10219.5000 10578.2116 -358.7116 33 Finance Manager 0 1 0 1 Female 1205 10219.5000 10804.5458 -585.0458 19 Electric Superintendent 1 0 0 1 Male 1229 10964.6900 10950.8411 13.8489 36 Engineering Manager 1 0 0 1 Male 1279 10964.6900 11255.5892 -290.8992 44 Administrations Director 0 1 0 1 Female 1361 12061.6800 12285.7541 -224.0741 Page 2 of 3 1/26/2024 12:03:13 PM MANAGEMENT AND BUDGET Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan Job Nbr Job Title Nbr Nbr Non- Total Job Type Job Max Mo Salary Predicted Pay Pay Difference Males Females Binary Nbr Points 35 Operations Director 1 0 0 1 Male 1369 12061.6800 12371.1079-309.4279 21 General Manaeer 1 0 0 1 Male 1662 15752.9700 15505.7268 247.2432 Job Number Count: 34 Page 3 of 3 1/26/2024 12:03:13 PM MIMANAGEMENT AND BUDGET Posting date: Jurisdiction Name: Elk River Municipal Utilities NOTICE: 2024 Pay Equity Report This jurisdiction is submitting a pay equity implementation report to Minnesota Management & Budget as required by the Local Government Pay Equity Act, Minnesota Statutes 471.991 to 471.999. The report must be submitted to the department by January 31, 2024. The report is public data under the Minnesota Government Data Practices Act, Minnesota Statutes, Chapter 13. That means that the report is available to anyone requesting this information. This notice is being sent to all union representatives (if any) in this jurisdiction. In addition, this notice must remain posted in a prominent location for at least 90 days from the date the report was submitted. For more information about this jurisdiction's pay equity program, or to request a copy of the implementation report, please contact: Megan Zachman 13069 Orono Parkway (763) 441-2020 (Local contact person's name, address, telephone) For more information about the state pay equity law, you may contact the Pay Equity Office at: pay.equity(a-)-state.mn.us Pay Equity Office Minnesota Management & Budget 400 Centennial Office Building 658 Cedar Street St. Paul, MN 55155 MANAGEMENT AND BUDGET 20000 15000 10000 5000 190 HANDOUT AT MEETING - Calculation Revision Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan 380 570 760 950 1140 1330 1520 1710 1900 Points Male Jobs Female Jobs • Balanced Jobs — Predicted Pay ---- Line Continuation (Min) ---- Line Continuation (Max) Page 1 of 3 1/29/2024 9:09:08 AM HANDOUT AT MEETING - Calculation Revision MANAGEMENT AND BUDGET Job Class Data Entry Verification List Case: 2024 Jan Elk River Municipal Utilities LGID: 22 Job Nbr Class Title Nbr Males Nbr Females Non- Binary Class Type Jobs Points Min Mo Salary Max Mo Salary Yrs to Max Salary Yrs of Service 40 Water Utility Worker 1 0 0 M 332 3264.97 4661.77 5.00 0.00 2 Customer Service Representativ 0 4 0 F 369 3479.86 4970.24 5.00 0.00 42 Inventory & Procurement Asst 1 0 0 M 426 3736.35 5337.64 5.00 0.00 29 Locator 2 0 0 M 450 4096.81 5845.41 5.00 0.00 3 Accts Payable & Payroll Specia 0 1 0 F 459 4096.81 5845.41 5.00 0.00 45 Billing Specialist 0 1 0 F 459 4096.81 5845.41 5.00 0.00 46 Credit & Collections Specialis 0 1 0 F 459 4096.81 5845.41 5.00 0.00 32 Communications & Admin Coordin 0 1 0 F 503 4483.27 6398.24 5.00 0.00 27 Bore Rig Operator 1 0 0 M 526 4483.27 6398.24 5.00 0.00 5 Water Operator 3 0 0 M 536 4483.27 6398.24 5.00 0.00 9 Electric Technician 1 0 0 M 569 4902.66 7008.25 5.00 0.00 8 Accountant 0 1 0 F 609 5370.57 7677.19 5.00 0.00 39 Human Resources Generalist 0 1 0 F 613 5370.57 7677.19 5.00 0.00 28 GIS/Mapping Technician 0 1 0 F 617 5370.57 7677.19 5.00 0.00 43 Water Operations Foreperson 0 1 0 F 666 5370.57 7677.19 5.00 0.00 38 Lead Bore Rig Operator 1 0 0 M 670 5370.57 7677.19 5.00 0.00 26 Electrician/Electrical Technic 1 0 0 M 674 5370.57 7677.19 5.00 0.00 4 Inventory & Procurement Forepe 1 0 0 M 674 5370.57 7677.19 5.00 0.00 47 Substation Apparatus Technicia 1 0 0 M 682 5881.80 8401.58 5.00 0.00 12 Lineperson 5 0 0 M 740 6389.57 9127.71 5.00 0.00 37 IT/OTTechnician 1 0 0 M 750 5881.80 8401.58 5.00 0.00 41 Governance & Comms Mgr 1 0 0 M 755 6205.87 8862.56 5.00 0.00 14 Lead Lineperson 4 0 0 M 782 6770.83 9677.07 5.00 0.00 15 Conservation & Key Accts Mgr 1 0 0 M 813 6205.87 8862.56 5.00 0.00 16 Field Crew Foreperson 1 0 0 M 813 6507.42 9288.88 5.00 0.00 31 Line Crew Foreperson 1 0 0 M 884 8555.82 10067.00 5.00 0.00 18 Water Superintendent 1 0 0 M 990 8184.96 9635.48 5.00 0.00 17 Technical Services Superintend 1 0 0 M 1129 8684.06 10219.50 5.00 0.00 33 Finance Manager 0 1 0 F 1205 8684.06 10219.50 5.00 0.00 19 Electric Superintendent 1 0 0 M 1229 9321.81 10964.69 5.00 0.00 36 Engineering Manager 1 0 0 M 1279 9321.81 10964.69 5.00 0.00 Exceptional Service Pay Longevity Longevity Longevity Longevity Longevity Longevity Page 1 of 2 1/29/2024 9:08:01 AM MANAGEMENT AND BUDGET HANDOUT AT MEETING - Calculation Revision Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan Job Nbr Job Title Nbr Males Nbr Females Non- Binary Total Nbr Job Type Job Points Max Mo Salary Predicted Pay Pay Difference 40 Water Utility Worker 1 0 0 1 Male 332 4661.7700 4646.7058 15.0642 2 Customer Service Representativ 0 4 0 4 Female 369 4970.2400 4982.6192 -12.3792 42 Inventory & Procurement Asst 1 0 0 1 Male 426 5337.6400 5500.3850 -162.7450 29 Locator 2 0 0 2 Male 450 5845.4100 5718.4871 126.9229 3 Accts Payable & Payroll Specia 0 1 0 1 Female 459 5845.4100 5800.0488 45.3612 45 Billing Specialist 0 1 0 1 Female 459 5845.4100 5800.0488 45.3612 46 Credit & Collections Specialis 0 1 0 1 Female 459 5845.4100 5800.0488 45.3612 32 Communications & Admin Coordin 0 1 0 1 Female 503 6398.2400 6198.0395 200.2005 27 Bore Rig Operator 1 0 0 1 Male 526 6398.2400 6410.0997 -11.8597 5 Water Operator 3 0 0 3 Male 536 6398.2400 6502.0333 -103.7933 9 Electric Technician 1 0 0 1 Male 569 7008.2500 6846.3924 161.8576 8 Accountant 0 1 0 1 Female 609 7677.1900 7308.5813 368.6087 39 Human Resources Generalist 0 1 0 1 Female 613 7677.1900 7359.4362 317.7538 28 GIS/Mapping Technician 0 1 0 1 Female 617 7677.1900 7410.2911 266.8989 43 Water Operations Foreperson 0 1 0 1 Female 666 7677.1900 8003.3281 -326.1381 38 Lead Bore Rig Operator 1 0 0 1 Male 670 7677.1900 7993.9095 -316.7195 4 Inventory & Procurement Forepe 1 0 0 1 Male 674 7677.1900 8048.8694 -371.6794 26 Electrician/Electrical Technic 1 0 0 1 Male 674 7677.1900 8048.8694 -371.6794 47 Substation Apparatus Technicia 1 0 0 1 Male 682 8401.5800 8176.0405 225.5395 12 Lineperson 5 0 0 5 Male 740 9127.7100 8836.7754 290.9346 37 IT/OTTechnician 1 0 0 1 Male 750 8401.5800 8959.7118 -558.1318 41 Governance & Comms Mgr 1 0 0 1 Male 755 8862.5600 8987.4491 -124.8891 14 Lead Lineperson 4 0 0 4 Male 782 9677.0700 9283.7096 393.3604 15 Conservation & Key Accts Mgr 1 0 0 1 Male 813 8862.5600 9532.5343 -669.9743 16 Field Crew Foreperson 1 0 0 1 Male 813 9288.8800 9532.5343 -243.6543 31 Line Crew Foreperson 1 0 0 1 Male 884 10067.0000 9609.4662 457.5338 18 Water Superintendent 1 0 0 1 Male 990 9635.4800 9815.3041 -179.8241 17 Technical Services Superintend 1 0 0 1 Male 1129 10219.5000 10578.2116 -358.7116 33 Finance Manager 0 1 0 1 Female 1205 10219.5000 10804.5458 -585.0458 19 Electric Superintendent 1 0 0 1 Male 1229 10964.6900 10950.8411 13.8489 36 Engineering Manager 1 0 0 1 Male 1279 10964.6900 11255.5892 -290.8992 44 Administrations Director 0 1 0 1 Female 1361 12061.6800 12285.7541 -224.0741 Page 2 of 3 1/29/2024 9:09:08 AM MANAGEMENT AND BUDGET HANDOUT AT MEETING - Calculation Revision Predicted Pay Report for: Elk River Municipal Utilities Case: 2024 Jan Job Nbr Job Title Nbr Nbr Non- Total Job Type Job Max Mo Salary Predicted Pay Pay Difference Males Females Binary Nbr Points 35 Operations Director 1 0 0 1 Male 1369 12061.6800 12371.1079-309.4279 21 General Manaeer 1 0 0 1 Male 1662 15752.9700 15505.7268 247.2432 Job Number Count: 34 Page 3 of 3 1/29/2024 9:09:08 AM MANAGEMENT HANDOUT AT MEETING - Calculation Revision AND BUDGET Job Class Data Entry Verification List Case: 2024 Jan Elk River Municipal Utilities LGID: 22 Job Nbr Class Title Nbr Nbr Non- Class Jobs Min Mo Max Mo Salary Yrs to Max Salary Yrs of Exceptional Service Pay Males Females Binary Type Points Salary Service 44 Administrations Director 0 1 0 F 1361 10225.8 12061.68 5.00 0.00 9 35 Operations Director 1 0 0 M 1369 10225.8 12061.68 5.00 0.00 Longevity 9 21 General Manager 1 0 0 M 1662 13389.1 15752.97 5.00 0.00 6 Job Number Count: 34 Page 2 of 2 1/29/2024 9:08:01 AM