210000000877.pdf

STATE OF MICHIGAN

ENTERPRISE PROCUREMENT

Department of Technology, Management, and Budget 320 S. Walnut Street 2nd Floor Lansing, MI 48933

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

CONTRACT SUMMARY

Safe Drinking Water Information System (SDWIS) and Supporting Systems

INITIAL EFFECTIVE DATE INITIAL EXPIRATION DATE INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

April 28, 2021 April 30, 2026 5 - 12 Months April 30, 2026

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

MINIMUM DELIVERY REQUIREMENTS

P-Card Direct Voucher (PRC) Other Yes No

3370 N. Hayden Road

Scottsdale AZ 85251

Matthew Guthrie

602-885-6197

Matthew.Guthrie@1GEC.com

VS0101351

Global Environmental Consulting, Inc.

C O

N

TR

A C

TO

R

Jarrod Barron

517-249-0406

DTMB

Various Various

Barronj1@michigan.gov

C ontract

A dm inistrator Program M anagerSTA

TE

Change Notice Number 8

Contract Number MA210000000877 to

DESCRIPTION OF CHANGE NOTICE

OPTION EXTENSIONLENGTH OF OPTION LENGTH OF EXTENSION REVISED EXP. DATE

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$3,245,820.35 $0.00 $3,245,820.35

DESCRIPTION

Effective 6/16/2025, the parties reallocate funds from the Data Validation Tool task, which remains on hold pending further clarity on the GEC SaaS product timeline, to support the following activities:

$14,849.14 for continued correction and migration of NC data into the consolidated SDWIS system and $9,170.55 for modifications to the MiLogin authentication process to implement encrypted OIDC (OpenID Connect) authentication.

Further, the parties add the following language to the Contract: "Accessibility Requirements. The State is required to comply with the Americans with Disabilities Act of 1990 (ADA) and has adopted standards and procedures regarding accessibility requirements for websites, applications, content, and electronic documents. Due to a change in the law, the State is required to comply with specific accessibility standards for websites, applications, content and documents. On or before 4/24/2026, and throughout the Term, all websites, applications, software, content, and electronic documents, including but not limited to mobile applications, text, images, sounds, videos, controls, animations, links, and documents (including files in the following formats: PDF, word processing, presentation, and spreadsheet), created, provided, or made available by the Contractor under this Contract related to DWV, RECAP and Data Validator, must comply with WCAG 2.1 Level AA. Further, Contractor must work to achieve SWIFT Surveys compliance as soon as practicable."

All other terms, conditions, specifications and pricing remain the same. Per Contractor, agency, and DTMB Central Procurement approval.

AGENCY NAME PHONE EMAIL

DTMB Laura Brancheau 517-335-1334 BrancheauL@michigan.gov

EGLE Ronda Dastoli 517-242-4114 DastoliR@michigan.gov

Program Managers for

Multi-Agency and Statewide Contracts

CHANGE NOTICE NO. 8 TO CONTRACT NO. MA210000000877

Michigan.gov/MiProcurement

Version 2021-1 1 of 4

STATEMENT OF WORK – IT Change Notice

Project Title:

Contract 210000000877 Change Notice #8 – PWS Data Management

Support

Period of Coverage:

6/1/25-12/31/2025

Requesting Department:

EGLE

Date:

5/27/2025

Agency Project Manager:

Ronda Dastoli

Phone:

(517) 242-4114

DTMB Project Manager:

Laura Brancheau

Phone:

(517) 335-1334

BACKGROUND:

Change Notice 6 included putting efforts on hold for the Data Validation Tool resulting in $118,470.10 contract dollars being available for re-allocation for additional related services.

Efforts to date for the in-scope efforts combining of the Community water System (CWS) and the Noncommunity

Water System (NC) programs has been impacted by a number of factors that have required additional time and efforts to resolve. This has included:

• Since the combination project has been delayed, additional data quality issues were discovered that were added since we did our first round of migrations, and some data have not been able to be migrated into

SDWIS. Additional clean-up of the data will be needed to get all data into SDWIS. Both EGLE and GEC addressed some of the data clean up items prior to the combination, with the movement of funds from the Data Validator Task to the Combination task. The remaining items where additional funding will be needed include:

o Fix issue where lead and copper samples are missing a lab reporting level.

o Fix lead consumer notice schedules, once receive a complete list from EGLE.

o Clean up missing monthly operating report information once examples of missing data are provided by EGLE.

o Clean up lead service line inventory schedules once receive complete list from EGLE.

o Update total coliform sample types so missing results can be migrated to SDWIS, then return to previous sample type.

o Once scripts are run, GEC will compare databases to identify and help correct any remaining data quality errors.

In addition, the MiLogin integration needs to be updated to use encrypted OIDC (OpenID Connect) authentication.

Additional funds are needed to work with the MiLogin team and alter the authentication method.

The financial impact to the project includes:

• Reallocating $14,849.14 from the funds previously designated for the Data Validation tool work—paused in CN#6 until the SaaS product becomes available next fiscal year—to correct remaining data quality errors and migrate the remainder of the NC data into the combined SDWIS database. This task has proven more complex and time-intensive than initially anticipated due to the intricacies of the data sources.

• Similarly, reallocating $9,170.55 from the funds previously designated for the Data Validation tool work to re-authenticate MiLogin using encrypted OIDC (OpenID Connect) authentication protocol.

• The amount remaining in the Data Validator Task is $18,976.02.

Version 2021-1 2 of 4

This is a Change Notice to the existing contract 210000000877.

PROJECT OBJECTIVE:

The objective of this change notice in relationship to the project is to re-allocate funding made available in Change

Notice 6 from putting work on the Data Validation Tool Task on hold to additional efforts for combining the CWS and NC SDWIS database and applications task, and to add a task for MiLogin authentication changes.

SCOPE OF WORK:

The change items in this change notice include:

• Additional time needed to correct data quality errors and finish migrating NC data into the combined version of SDWIS.

• Address additional MiLogin changes, and additional check-in meetings to discuss, and test the implementation of the MiLogin authentication changes in test (QA) and production environments.

Change Item 1 (AKA Task 1)

Description: Additional time is needed to continue correcting and migrating NC data into the combined version of

SDWIS.

Target Due Date: Changed from 5/31/2025 to 7/31/2025.

Impact: No change to the contract funding level is anticipated. This change notice moves funding within the contract. Moves $14,849.14 from the Data Validation tool task to the combining task equates to 100 labor hours at the 2025 SME 3 rate of $148.49.

Planned contractor effort includes:

• 15 hours to write additional scripts to update SDWIS data.

• 55 hours for data migration and QA of migrated data.

• 15 hours for check-in calls and documentation.

• 15 for additional QA checks and data corrections.

Change Item 2 (AKA Task 2)

Description: Adds a task to change the MiLogin authentication method to encrypted OIDC (OpenID Connect) authentication.

Target Due Date: 12/31/2025.

Impact: No change to the contract funding level is anticipated. This change notice moves funding within the contract. Move funding from the Data Validation Tool to change the MiLogin authentication method to OIDC. This assumes 20 hours will be needed at the 2025 SME 3 rate, 20 hours at the Developer 3 rate, and 20 hours at the Senior Project Manager rate will be needed, for a total of $9,170.55.

Planned contractor effort includes:

• 20 labor hours at the 2025 SME 3 rate for coordination with the client, user acceptance testing, and documentation.

• 20 hours at the 2025 Developer 3 rate for the enhancement and QA testing.

• 20 hours at the 2025 Senior Project Manager rate for the enhancement, coordination with the client and developers, and QA.

Version 2021-1 3 of 4

DELIVERABLES:

Deliverables will not be considered complete until the Agency Project Manager has formally accepted them.

Tasks

Deliverable Name Description

MiLogin Authentication Method Change Change the authentication method for MiLogin to

OIDC

ACCEPTANCE CRITERIA:

No change in acceptance criteria from Change Notices 2, 3, 4, 5, 6, and 7.

PROJECT CONTROL AND REPORTS:

No changes to the contract as it relates to<PROJECT CONTROL AND REPORTS>.

SPECIFIC DEPARTMENT STANDARDS:

No changes to the contract as it relates to <SPECIFIC DEPARTMENT STANDARDS>.

PAYMENT SCHEDULE:

No changes to the payment terms and conditions are expected with this Change Notice.

No change in the contract cost is anticipated as a result of Change Notice 8. See the payment table below:

Costs Removed from Data Validation Tool

Change Item No. LOE Labor Cost Other Direct Costs Total Labor

Cost and ODCs

Change Item 1 100.00 $14,849.14 $0.00 $14,849.14

Change Item 2 80.00 $9,170.55 $0.00 $9,170.55

Amount removed from the Data Validation Tool Task 0.00 0.00 -$24,019.70 -$24,019.70

Amount remaining in the Data Validation Tool Task $18,976.02 18,976.02

Total Change in Contract Value 180.00 $24,019.70 -$24,019.70 $0.00

EXPENSES:

No changes to the contract as it relates to <EXPENSES>.

PROJECT CONTACTS:

No changes to the contract as it relates to <PROJECT CONTACTS>.

AGENCY RESPONSIBILITIES:

No changes to the contract as it relates to <AGENCY RESPONSIBILITIES>.

Version 2021-1 4 of 4

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

No changes to the contract as it relates to <LOCATION OF WHERE THE WORK IS TO BE PERFORMED>

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

No changes to the contract as it relates to <EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS>

Department of Technology, Management, and Budget 320 S. Walnut Street 2nd Floor Lansing, MI 48933

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

CONTRACT SUMMARY

Safe Drinking Water Information System (SDWIS) and Supporting Systems

INITIAL EFFECTIVE DATE INITIAL EXPIRATION DATE INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

April 28, 2021 April 30, 2026 5 - 12 Months April 30, 2026

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

MINIMUM DELIVERY REQUIREMENTS

P-Card Direct Voucher (PRC) Other Yes No

3370 N. Hayden Road

Scottsdale AZ 85251

Matthew Guthrie

602-885-6197

Matthew.Guthrie@1GEC.com

VS0101351

Global Environmental Consulting, Inc.

C O

N

TR

A C

TO

R

Jarrod Barron

517-249-0406

DTMB

Various Various

BarronJ1@michigan.gov

C ontract

A dm inistrator Program M anagerSTA

TE

Change Notice Number 7

Contract Number MA210000000877 to

DESCRIPTION OF CHANGE NOTICE

OPTION EXTENSIONLENGTH OF OPTION LENGTH OF EXTENSION REVISED EXP. DATE

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$3,245,820.35 $0.00 $3,245,820.35

DESCRIPTION

Effective 4/24/2025, the parties add and remove the services detailed in the attached PWS Data Management Support statement of work. This is a zero-dollar change, reallocating existing contract funds. All other terms, conditions, specifications and pricing remain the same. Per contractor and agency agreement, and DTMB Central Procurement Services approval.

EGLE Ronda Dastoli 517-242-4114 DastoliR@michigan.gov

Program Managers for

CHANGE NOTICE NO. 7 TO CONTRACT NO. MA210000000877

Contract 210000000877 Change Notice #7 – PWS Data Management Support

Period of Coverage:

1/1/25-5/31/2025

Requesting Department:

EGLE

Date:

4/1/2025

Agency Project Manager:

Ronda Dastoli

Phone:

(517) 242-4114

DTMB Project Manager:

Laura Brancheau

Change Notice 6 included putting efforts on hold for the Data Validation Tool resulting in $118,470.10 contract dollars being available for re-allocation for additional related services.

Efforts to date for the in-scope efforts combining of the Community water System (CWS) and the Noncommunity Water System (NC) programs has been impacted by a number of factors that have required additional time and efforts to resolve. This has included:

• Since the combination project has been delayed, additional data quality issues were discovered that were added since we did our first round of migrations, and some data have not been able to be migrated into SDWIS. Additional clean-up of the data will be needed to get all data into SDWIS. This may take some additional time on GEC's end if MI staff do not have time to address data quality issues. Some of the things we have identified and talked about on our check-in calls include:

o Ex. LCR Scheduled activity differences in descriptions for the same scheduled activity.

o Related to the NC reports-a data comment field was being populated inconsistently, so data quality checks need to be run and data corrected more frequently.

o Migration of many sample results have failed because a less than flag was marked as true, but then there is value in the concentration field.

o Some samples were rejected because the sampling schedule had been deleted (SDWIS will not accept sample values if there is no sampling schedule for the time period in which the sample was collected).

o Additional permitted values were added to SDWIS resulting in additional time needed to transform and migrate data.

• Additionally, there were changes requested to the NC reports well after CN 6 was approved in November of last year. Some of these changes were related to data quality errors that had not been addressed or corrected by the NC program.

• Additional web services changes were requested from EGLE and the MiEHDWIS team.

Much of these changes were related to the CWS and NC programs also needing to be differentiated in MiEHDWIS or needed to have the ability to filter out some information.

Changes to the web services were needed to prepare for combining the SDWIS database.

In addition, the NC program identified the need for additional customization to the SWIFT Surveys so they could more easily be alerted when there is a significant deficiency reported by a local health department during a sanitary survey. This will allow the central NC program staff to have better oversight of the sanitary surveys conducted and ensure quick follow up after a significant deficiency is identified to ensure that deficiencies are addressed and resolved in a timely manner.

This change to SWIFT is estimated to cost $8,967.03.

The financial impact to the project includes:

• Reallocating $66,507.35 from the funds previously designated for the Data Validation tool work—paused in CN#6 until the SaaS product becomes available next fiscal year—to complete the integration of CWS and NC instances of SDWIS. This task has proven more complex and time-intensive than initially anticipated due to the intricacies of the data sources.

• Similarly, reallocating $8,967.03 from the funds previously designated for the Data Validation tool work to customize SWIFT Surveys.

• The amount remaining in the Data Validator Task is $42,995.72.

This is a Change Notice to the existing contract 210000000877.

PROJECT OBJECTIVE:

The objective of this change notice in relationship to the project is to re-allocate funding made available in Change Notice 6 from putting work on the Data Validation Tool Task on hold to additional efforts for combining the CWS and NC SDWIS database and applications task, and to add a task for SWIFT Surveys Customization.

SCOPE OF WORK:

The change items in this change notice include:

• Additional time needed to troubleshoot and investigate data quality errors and changes in the way SDWIS is used by the programs so data can be successfully combined in one version of SDWIS.

• Additional time to change queries, data transformation queries, and time to migrate changes to fix data quality issues is needed.

• Since the project has been extended, check-in meetings with EGLE staff are needed to ensure data quality issues have been addressed.

• Address additional web service changes needed due to the combined databases, and additional check-in meetings to discuss and review the changes is also needed.

Description: Data quality issues were reintroduced since the first migration was completed in July, and additional effort has been needed to investigate and resolve issues before additional data, including sample results, can be migrated. Some changes were requested after Change Notice 6 (listed above in the Background section), so the extra effort is accounted for in this task.

Target Due Date: No change from due date of 5/31/2025.

Impact: No change to the contract funding level is anticipated. This change notice reallocates funding within the contract. Reallocating $66,507.35 from the Data Validation tool task to the combining task equates to 448.5 labor hours, with 440 hours at the 2025 SME 3 rate of $148.49 and

8.5 hours at the 2025 Developer 3 rate of $ 137.78.

Planned contractor effort includes:

• 60 hours for additional QA checks and data corrections prior to the final combination

• 20 hours for check-in calls and documentation

• 20 hours for coordination with the Environmental Protection Agency over Federal reporting data

• 348.5 hours for data migration between the databases

Change Item 2 (AKA Task 2)

Description: Adds a task to add a notification to SWIFT surveys where significant deficiencies are identified so that EGLE NC program staff are able to quickly see and follow up with LHD staff whenever significant deficiencies are identified during a sanitary survey.

Target Due Date: 12/31/2025.

Impact: No change to the contract funding level is anticipated. This change notice moves funding within the contract. Move funding from the Data Validation Tool to add a new task to add a notification to SWIFT Surveys for Michigan. This assumes 30 hours will be needed at the 2025 SME 3 rate, and 30.75 hours at the Developer 3 rate will be needed, for a total of $8,967.03

Planned contractor effort includes:

• 30 labor hours at the 2025 SME 3 rate for coordination with the client and user acceptance testing.

• 32.75 hours at the 2025 Developer 3 rate for the enhancement and QA testing.

DELIVERABLES:

Deliverables will not be considered complete until the Agency Project Manager has formally accepted them.

Custom Notification in SWIFT Surveys Create a custom notification in SWIFT Surveys

No change in acceptance criteria from Change Notices 2, 3, 4, 5, and 6.

PROJECT CONTROL AND REPORTS:

No changes to the contract as it relates to<PROJECT CONTROL AND REPORTS>.

SPECIFIC DEPARTMENT STANDARDS:

No changes to the contract as it relates to <SPECIFIC DEPARTMENT STANDARDS>.

PAYMENT SCHEDULE:

No changes to the payment terms and conditions are expected with this Change Notice.

No change in the contract cost is anticipated as a result of Change Notice 7. See the payment table below:

Costs Removed from Data Validation Tool

Total Labor

Cost and ODCs

Change Item 1 448.5 $66,507.35 $0.00 $66,507.35 Change Item 2 62.75 $8,967.03 $0.00 $8,967.03 Amount removed from the Data Validation Tool Task 0.00 0.00 -$75,474.38 -$75,474.38 Amount remaining in the Data Validation Tool Task $42,995.72 $42,995.72 Total Change in Contract Value 511.25 $75,474.38 -$75,474.38 $0.00

PROJECT CONTACTS:

No changes to the contract as it relates to <PROJECT CONTACTS>.

No changes to the contract as it relates to <LOCATION OF WHERE THE WORK IS TO BE

PERFORMED>

No changes to the contract as it relates to <EXPECTED CONTRACTOR WORK HOURS AND

CONDITIONS>

Department of Technology, Management, and Budget 320 S. Walnut Street 2nd Floor Lansing, MI 48933

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

CONTRACT SUMMARY

Safe Drinking Water Information System (SDWIS) and Supporting Systems

INITIAL EFFECTIVE DATE INITIAL EXPIRATION DATE INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

April 28, 2021 April 30, 2026 5 - 12 Months April 30, 2026

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

MINIMUM DELIVERY REQUIREMENTS

P-Card Direct Voucher (PRC) Other Yes No

3370 N. Hayden Road

Scottsdale AZ 85251

Laurie Potter

603-397-7838

Laurie.Potter@1gec.com

VS0101351

Global Environmental Consulting, Inc.

C O

N

TR

A C

TO

R

Jarrod Barron

517-249-0406

DTMB

Various Various

BarronJ1@michigan.gov

C ontract

A dm inistrator Program M anagerSTA

TE

Change Notice Number 6

Contract Number MA210000000877 to

DESCRIPTION OF CHANGE NOTICE

OPTION EXTENSIONLENGTH OF OPTION LENGTH OF EXTENSION REVISED EXP. DATE

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$3,135,080.27 $110,740.08 $3,245,820.35

DESCRIPTION

Effective 2/6/2025, the parties add $110,740.08 for the services detailed in the attached PWS Data Management Support statement of work. All other terms, conditions, specifications, and pricing remain the same. Per contractor, agency, and DTMB Central Procurement approval.

Internal State Note: Remaining Ad Board funds after this CN: $63,064.41.

EGLE Ronda Page 517-242-4114 PAGER1@michigan.gov

Program Managers for

CHANGE NOTICE NO. 6 TO CONTRACT NO. MA210000000877

Contract 210000000877 Change Notice #6 – PWS Data Management Support

Period of Coverage:

12/1/24-5/31/24

Requesting Department:

EGLE

Date:

11/6/2024

Agency Project Manager:

Ronda Dastoli

Phone:

(517) 242-4114

DTMB Project Manager:

Laura Brancheau

This change notice extends the expected date to combine the Community Water System (CWS) and the Noncommunity Water System (NC) Programs’ instances of SDWIS, and Global Environmental Consulting’s (GEC’s) applications into one version, and provides updated pricing on maintaining two separate versions of SDWIS and GEC applications through May 31, 2025. This is a Change Notice to the existing contract 210000000877.

PROJECT OBJECTIVE:

The objective of this change notice in relationship to the project is to extend the date to combine versions of SDWIS and GEC applications, and to provide updated pricing in relation to the project extension through 4/30/25.

SCOPE OF WORK:

The change items in this change notice include:

• Change the completion date for combining CWS and NC instances of SDWIS from 11/30/24 to 5/31/2025 and add labor hours to the contract.

• Change the completion date for combining CWS and NC instances of RECAP-Reports, RECAP-Dashboard, SWIFT Surveys, and DWV from 11/30/24 to 4/30/2025.

• Change the target end dates, assisting with the LIMS, from 11/30/24 to the end of the project 5/31/2025.

• Provides implementation/licensing costs for Data Validator instead of a custom project and provides a credit to MI for costs already invoiced on the project.

Description: Combine two versions of SWIFT Surveys into one version.

Target Due Date: Changed from 11/30/2024 to 4/30/25.

Impact: Combining the CWS and NCWS SDWIS databases will allow SDWIS administrative tasks to be consolidated between the two units, as well as federal reporting efforts to EPA.

• Includes five months of Year 3 pricing for the CWS Program for SWIFT Surveys for up to 100 users from 12/1/2024 through 4/30/25 or $25,270.83, to be invoiced monthly ($5,054.17 per month).

• Includes five months of Year 3 pricing for the CWS Program for SWIFT Surveys for up to 120 users from 12/1/24 through 4/30/25 or $29,985.04, to be invoiced monthly ($5,997.01 per month)

• Results in a total increase to the contract of $12,516.78.

Description: Combine two versions of RECAP-Reports into one version.

Target Due Date: Changed from 11/30/2024 to 4/30/2025.

Impact:

• Includes five months of Year 4 pricing for the CWS Program for RECAP-Reports for up to 100 users from 12/1/24 to 04/30/25 of $25,585.48, to be invoiced monthly ($5,117.10 per month).

• Includes five months of Year 2 pricing for the NC Program for RECAP-Reports for up to 150 users from 12/1/24 to 4/30/25 of $26,680.30 to be invoiced monthly ($5,336.06 per month).

• Results in a total increase to the contract of $21,942.24.

Change Item 3 (AKA Task 3)

Description: Combine two versions of RECAP-Dashboard and Drinking Water Viewer into one version.

Target Due Date: Changed from 11/30/2024 to 4/30/25.

Impact:

• Includes 5 months of Year 2 pricing for the NC program for RECAP-Dashboard for up to 150 users from 12/1/24 through 4/30/24 of $8,173.59 to be invoiced monthly ($1,634.72 per month).

• Includes 2 months of Year 2 pricing for the CWS program for RECAP-Dashboard for up to 100 users from 12/1/24 through 1/31/25 of $2,739.44 to be invoiced monthly (1,369.72 per month).

• Includes 3 months of Year 3 pricing for the CWS program for RECAP-Dashboard for up to 100 users from 2/1/25 through 4/30/25 of $4,178.76 to be invoiced monthly ($1,392.92 per month).

• Year 2 pricing for DWV for the NC program from 12/1/24 to 4/30/25 for up to 500 users of

$14,358.54 to be invoiced monthly ($2,871.71 per month).

• Includes 2 months of Year 2 pricing for the CWS program for DWV for up to 10 users from

12/1/2024 to 1/31/25 of $3,015.29 to be invoiced monthly ($1,507.65 per month).

• Includes 3 months of Year 3 pricing for the CWS program for DWV for up to 500 users from

2/1/25 to 4/30/25 of $11,038.13 to be invoiced monthly ($3,679.38 per month. If the CWS program elects to not increase the number of users yet, the costs will be reduced accordingly).

• Results in a total increase to the contract of $16,375.61.

Change Item 4 (AKA Task 4)

Description: Update the due date for CN3, Task 1 Combine separate versions of SDWIS/State into one version. The task was delayed by EGLE. This change notice changes the target due date from 11/30/24 to 5/31/2025. The combination is expected to be completed by the end of April 2025, with the month of May set up for any additional testing or corrections that might need to be made. Also adds 400 hours to this task at the SME 3 rate for 2025. This assumes that 50 hours will be used for additional data QA and correction prior to the combination, Target Due Date: Changed from 11/30/24 to 5/31/2025.

Impact: An additional 400 hours at the 2025 SME 3 rate of $148.49 is requested to cover additional check-in calls, documentation, data quality checks, additional testing, additional migration and rework that will be needed due to the delay in the combination. Results in a total cost increase to the contract of $59,396.57.

This includes the following assumptions:

• 50 hours will be needed for additional QA checks and data corrections prior to the final combination

• 20 hours will be needed for check-in calls and documentation

• 20 hours will be needed for coordination with the Environmental Protection Agency over

Federal reporting data

• 20 hours may be needed for any additional web services adjustments that may need to be made because of the combination

• 290 hours will be needed for data migration between the databases

Change Item 5 (AKA Task 5) Description: Change the due date of the Data Validation Tool (Change Notice 3 Task 6) to 12/31/25 and provide EGLE with Implementation and SaaS pricing for the Data Validation Tool. GEC expects the Data Validation Tool to be ready for the production environment by 12/31/2025.

Target Due Date: Changed from 12/31/2025.

• The Data Validator Implementation Fee (License fee) is $48,797.78. GEC has previously invoiced MI EGLE $3,811.44, and will subtract this credit from the Implementation fee, resulting in a total implementation fee of $44,986.34. This fee would be invoiced one time and covers all fees for setting up and configuring the initial data validator instance, and staff training.

• First year of the SaaS for the data validator is expected to be $70,181.21. This could be invoiced monthly from the month MI approves the validator for use in production.

• The total increase to the contract is estimated to be $508.88.

Change Item 6 (AKA Task 6)

Description: Changes the end date of Change Notice 2 Task 2: Transition EGLE LIMS to EDI from 11/30/24 to 5/31/25.

Target Due Date: Changed from 11/30/2024 to 5/31/25.

• Changes the end date of the task to 5/31/25.

DELIVERABLES:

accepted them.

No new deliverables are anticipated.

No change in acceptance criteria from Change Notices 2, 3, 4, and 5.

PROJECT CONTROL AND REPORTS:

No changes to the contract as it relates to<PROJECT CONTROL AND REPORTS>.

SPECIFIC DEPARTMENT STANDARDS:

No changes to the contract as it relates to <SPECIFIC DEPARTMENT STANDARDS>.

PAYMENT SCHEDULE:

No changes to the payment terms and conditions are expected with this Change Notice.

The total change in contract price as a result of Change Notice 6 is a cost increase of $110,740.08.

See the payment table below:

Total Costs for CN 6

Total Labor

Cost and ODCs

Change Item 1 0.00 $0.00 $12,516.78 $12,516.78 Change Item 2 0.00 $0.00 $21,942.24 $21,942.24 Change Item 3 0.00 $0.00 $16,375.61 $16,375.61 Change Item 4 350.00 $59,396.57 $0.00 $59.396.57 Change Item 5 0.00 $0.00 $508.88 $508.88 Change Item 6 0.00 $0.00 $0.00 $0.00

Total 0.00 $59,396.57 $51,343.52 $110,740.08

PROJECT CONTACTS:

No changes to the contract as it relates to <PROJECT CONTACTS>.

No changes to the contract as it relates to <LOCATION OF WHERE THE WORK IS TO BE

PERFORMED>

CONDITIONS>

Department of Technology, Management, and Budget

525 W. ALLEGAN ST., LANSING, MICHIGAN 48913

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

CONTRACT SUMMARY

Safe Drinking Water Information System (SDWIS) and Supporting Systems

INITIAL EFFECTIVE DATE INITIAL EXPIRATION DATE INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

May 1, 2021 April 30, 2026 5 - 12 Months April 30, 2026

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

MINIMUM DELIVERY REQUIREMENTS

P-Card Direct Voucher (PRC) Other Yes No

3370 N. Hayden Road

Scottsdale AZ 85251

Laurie Potter

603-397-7838

Laurie.Potter@1gec.com

VS0101351

Global Environmental Consulting, Inc

C O

N

TR

A C

TO

R

Jarrod Barron

517-249-0406

DTMB

Various Various

BarronJ1@michigan.gov

C ontract

A dm inistrator Program M anagerSTA

TE

Change Notice Number 5

Contract Number MA210000000877 to

DESCRIPTION OF CHANGE NOTICE

OPTION EXTENSIONLENGTH OF OPTION LENGTH OF EXTENSION REVISED EXP. DATE

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$3,058,884.77 $76,195.50 $3,135,080.27

DESCRIPTION

Effective 6/24/2024, the parties add $76,195.50 for the services in the attached statement of work, which extends the expected date to combine the Community Water System (CWS) and the Noncommunity Water System (NC) Programs’ instances of SDWIS, and Global Environmental Consulting’s (GEC’s) applications into one version and provides updated pricing on maintaining two separate version of SDWIS and GEC applications through November 2024. All other terms, conditions, specifications, and pricing remain the same. Per Contractor, Agency and DTMB Central Procurement approval. Remaining Ad Board funds after this change notice: $173,804.49.

EGLE Ronda Page 517-242-4114 PAGER1@michigan.gov

Program Managers for

CHANGE NOTICE NO. 5 TO CONTRACT NO. MA210000000877

Contract 210000000877 Change Notice #5 – FY24 PWS Data Management Support

Period of Coverage:

5/8/24-11/30/24

Requesting Department:

EGLE

Date:

5/8/2024

Agency Project Manager:

Ronda Dastoli

Phone:

(517) 242-4114

DTMB Project Manager:

Laura Brancheau

This change notice extends the expected date to combine the Community Water System (CWS) and the Noncommunity Water System (NC) Programs’ instances of SDWIS, and Global Environmental Consulting’s (GEC’s) applications into one version and provides updated pricing on maintaining two separate version of SDWIS and GEC applications through November 2024.

This is a Change Notice to the existing contract 210000000877.

PROJECT OBJECTIVE:

The objective of this change notice in relationship to the project is to extend the date to combine versions of SDWIS and GEC applications, and to provide updated pricing in relation to the project extension through 11/30/2024. This change notice also removes the Power BI task from the scope of work.

SCOPE OF WORK:

The change items in this change notice include:

• Change the completion date for combining CWS and NC instances of SDWIS, RECAP-Reports, RECAP- Dashboard, SWIFT Surveys, and DWV from 6/30/24 to 11/30/24.

• Change the target end dates for the data validation tool, assisting with the LIMS, CMDP, Bi-Directional Data Flow with MiEHDWIS from 6/30/24 to 11/30/24.

• Remove the Power BI task and apply the remaining funds of $8,117.40 to the combining SDWIS database task (both tasks are time and materials tasks, and not fixed price tasks).

Change Item 1 (AKA Task 1)

Description: Combine two versions of SWIFT Surveys into one version.

Target Due Date: Changed from 6/30/24 to 11/30/2024.

Impact: Combining the CWS and NCWS SDWIS databases will allow SDWIS administrative tasks to be consolidated between the two units, as well as federal reporting efforts to EPA.

• Includes the full Year 2 pricing for the CWS Program for SWIFT

Surveys for up to 100 users from 11/1/2023 through 10/31/2024 or $57,727, to be invoiced monthly.

• Some of the costs are estimated as monthly SaaS costs until the CWS and NCWS SWIFT Survey instances are combined starting on 12/1/2024. NC-only costs cover 10/1/2023 through 11/30/2024, for up to 14 months.

• Costs for CWS SWIFT are also provided monthly, until the CWS and NCWS SWIFT Survey instances are combined as of 12/1/2024. CWS-only costs cover 11/1/2023 through 11/30/2024, for up to 13 months.

• Includes 1 month of year 3 pricing for the CWS Program for SWIFT Surveys for up to 100 users for 11/1- 11/30/2024 or $5.054.17.

• Includes only the full Year 2 pricing for the NC Program for up to 120 users (the NC program began SWIFT Surveys after the CWS program) from 10/1/2023 through 9/30/2024, of $81,929.69 to be invoiced monthly.

• Includes 2 months of Year 3 pricing for the NC Program for up to 120 users for two months, from 10/1/2024 through 11/30/2024 at $11,994.01 to be invoiced monthly.

Change Item 2 (AKA Task 2)

Description: Combine two versions of RECAP-Reports into one version.

Target Due Date: Changed from 6/30/24 to 11/30/2024.

Impact:

• Includes 6 months of Year 4 pricing for the CWS program from 6/1/24 through 11/30/24 or $29,808.33 to be invoiced monthly.

• Includes 8 months of Year 2 pricing for the NC program from 4/1/24 through 11/30/24 or $41,216.46 to be invoiced monthly.

Change Item 3 (AKA Task 3)

Description: Combine two versions of RECAP-Dashboard and Drinking Water Viewer into one version.

Target Due Date: Changed from 6/30/24 to 11/30/2024.

Impact:

• Continuation of Year 1 price for the NC program for RECAP-Dashboard for 7/1/24 through 8/30/24 of

• $2,870.84 to be invoiced monthly.

• Year 2 pricing for the NC program for RECAP-Dashboard for 9/1/24 through

11/30/24 of $4,374.16 to be invoiced monthly.

• Year 2 pricing for the CWS program from 3/1-11/30/24 of $12,327.47 to be invoiced monthly.

• Year 2 pricing for DWV for the NC program from 3/1/24 to 11/30/24 of

$25,845.38 to be invoiced monthly.

• Year 2 pricing for DWV for the CWS program from 3/1/24-11/30/24 of

$13,568.82 to be invoiced monthly.

Description: Update the due date for CN3, Task 1 Combine separate versions of SDWIS/State into one version. The task was delayed by EGLE. This change notice changes the target due date from 6/30/24 to 11/30/24. No additional LOE is currently expected due to the date change. However, EGLE has indicated that they do not need the Power BI Task. The remaining balance of $8,117.40 has been moved to this task.

Target Due Date: Changed from 6/30/24 to 11/30/24 Impact:

• Total cost for this task is estimated to be $231,142.86 when moving the funds from the Power BI task here.

Change Item 5 (AKA Task 5) Description: Remove the Power BI Task from Change Notice 3, Task 4 from the scope of work.

Target Due: N/A, task is no longer needed.

Impact:

• Move remaining funds of $8,117.40 from this task to Change Notice 4, Task 4.

Change Item 6 (AKA Task 6) Description: Change the due date of the Data Validation Tool (Change Notice 3 Task 6) to 11/30/24 Target Due Date: Changed from 6/30/24 to 11/30/24.

Impact:

• Changes the end date of the task to 11/30/24.

Change Item 7 (AKA Task 7) Description: Changes the end date of Change Notice 2 Task 2: Transition EGLE LIMS to EDI to 11/30/24.

Target Due Date: Changed from 6/30/24 to 11/30/2024.

Impact:

• Changes the end date of the task to 11/30/24.

Change Item 8 (AKA Task 8) Description: Changes the end date of Change Notice 2 Task 5: EGLE Bi-Directional Data Flow Between SDWIS and MiEHDWIS to 11/30/2024 Target Due Date: Changed from 6/30/24 to 11/30/2024

• Changes the end date of the task to 11/30/24.

Change Item 9 (AKA Task 9) Description: Changes the end date of Change Notice 3 Task 3, CMDP Transition and Implementation to the end of the contract, 4/30/26.

Target Due Date: 4/30/2026 Background: Changes the end date for the CMDP Transition task to the end of the contract, or 4/30/26.

DELIVERABLES:

accepted them. The only change to deliverables is that the Task 5: Power BI task is being removed from the contract.

Task 5: Power BI Removes this task from CN2 Task 4 and moves remaining funding to Task 4: Combine versions of SDWIS/State.

No change in acceptance criteria from Change Notices 2, 3, and 4.

PROJECT CONTROL AND REPORTS:

No changes to the contract as it relates to<PROJECT CONTROL AND REPORTS>.

No changes to the contract as it relates to <SPECIFIC DEPARTMENT STANDARDS>.

PAYMENT SCHEDULE:

No changes to the payment terms and conditions are expected with this Change Notice. The total change in contract price as a result of Change Notice 5 is $76,195.50. See the payment table below:

Total Costs for CN 5

Change Item No. LOE Labor Cost Other Direct Costs

Total Labor Cost and ODCs

Change Item 1 0.00 $0.00 $11,317.84 $11,317.84

Change Item 2 0.00 $0.00 $31,601.25 $31,601.25

Change Item 3 0.00 $0.00 $33,276.42 $33,276.42

Change Item 4 0.00 $8,117.40 $0.00 $8,117.40

Change Item 5 0.00 -$8,117.40 $0.00 -$8,117.40

Change Item 6 0.00 $0.00 $0.00 $0.00

Change Item 7 0.00 $0.00 $0.00 $0.00

Change Item 8 0.00 $0.00 $0.00 $0.00

Change Item 9 0.00 $0.00 $0.00 $0.00

Total 0.00 $0.00 $76,195.50 $76,195.50

PROJECT CONTACTS:

No changes to the contract as it relates to <PROJECT CONTACTS>.

AGENCY RESPONSIBILITIES:

No changes to the contract as it relates to <AGENCY RESPONSIBILITIES>.

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

No changes to the contract as it relates to <LOCATION OF WHERE THE WORK IS TO BE

PERFORMED>.

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

CONDITIONS>.

CENTRAL PROCUREMENT SERVICES

Department of Technology, Management, and Budget

320 S. WALNUT ST., LANSING, MICHIGAN 48933

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

Change Notice Number 4 to

Contract Number 210000000877

Various

Sarah Platte laurie.potter@1gec.com

Laurie Potter

Scottsdale, AZ 85251

Global Environmental Consulting, Inc

VS0101351

603-397-7838

3370 N. Hayden Road

517-219-2406 S

T A

T E

P ro g ra m

M a n a g e r

C o n tra ct

A d m in istra to r

C O

N T R A C T O

R

DTMB

plattes3@michigan.gov

$2,624,495.77

May 1, 2021 April 30, 2026

SAFE DRINKING WATER INFORMATION SYSTEM (SDWIS) AND SUPPORTING SYSTEMS

April 30, 2026

INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

5 - 1 Year

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

☐ P-Card ☐ PRC ☐ Other ☒ Yes ☐ No

MINIMUM DELIVERY REQUIREMENTS

DESCRIPTION OF CHANGE NOTICE

OPTION LENGTH OF OPTION EXTENSION LENGTH OF EXTENSION REVISED EXP. DATE

☐ ☐ April 30, 2026

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$434,389.00 $3,058,884.77

Effective 9/28/2023, the parties adds the attached Statement of Work for the purpose of transitioning Michigan's Department of Environment, Great Lakes, and Energy from its current systems to the Compliance Monitoring Data Portal (CMDP) and Safe Drinking Water Information System (SDWIS). This will help prepare for the future migration to EPA's cloud hosted version of SDWIS, prepare data for reporting/dashboard purposes and to purchase and deploy additional GEC applications for managing Public Water Supply (PWS) data. The State also adds $434,389.00 in funding to cover the costs of the work that will be completed.

All other terms, conditions, specifications and pricing remain the same. Per Contractor, Agency, DTMB Central Procurement Services and State Administrative Board approval on 9/28/2023.

INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE

DESCRIPTION

CONTRACT SUMMARY

EGLE

Program Managers for

CHANGE NOTICE NO. 4 TO CONTRACT NO. 210000000877

Laura Brancheau 517-335-1334 BrancheauL@michigan.govDTMB

Ronda Page 517-242-4114 PAGER1@michigan.govEGLE

Version 2021-1 1 of 11

Contract 210000000877 Change Notice #4 – FY24 PWS Data Management Support

Period of Coverage:

Fiscal Year 2024

Requesting Department:

EGLE

Date:

7/7/2023

Agency Project Manager:

Ronda Page

Phone:

(517) 242-4114

DTMB Project Manager:

Laura Brancheau

Michigan’s Department of Environment, Great Lakes, and Energy (EGLE)-Drinking Water and Environmental Health

Division (DWEHD) has identified additional Public Water Supply (PWS) program data support needs that can be fulfilled by Global Environmental Consulting (GEC) through a Change Notice to the existing contract 210000000877.

The objective of this change notice in relationship to the project is to seamlessly transition Michigan EGLE from its current systems to the Compliance Monitoring Data Portal (CMDP) and Safe Drinking Water Information System

(SDWIS) State in preparation for future migration to EPA's cloud hosted version of SDWIS, prepare data for reporting/dashboard purposes and to purchase and deploy additional GEC applications for managing Public Water

Supply (PWS) data.

EGLE’s DWEHD currently uses multiple systems for managing Safe Drinking Water Act data:

• SDWIS/State is used for the Community Water Supply (CWS) Program.

• WaterTrack is used for the Noncommunity Water Supply (NCWS) Program, and the NCWS program is in the process of migrating data to a separate version of SDWIS/State.

• WaterChem is a separate database which contains a copy of the State Drinking Water Lab data, as well as Noncommunity data received from private labs which are manually entered into WaterChem via WaterTrack.

• Data for the laboratory certification program are housed in another standalone database.

The change items in this change notice include:

• Replaces two years of SWIFT Surveys costs with revised costs once combining CWS and NC instances of SDWIS and SWIFT.

• Provides updated pricing for combined version of RECAP-Reports, RECEPRECAP-Dashboard, and DWV for the remainder of the contract.

• Changes the target end dates for combining the SDWIS databases, training, the data validation tool, the separate reporting database, and the Power BI Views tasks described in Change Notices 2 and 3.

• Recalculates the expected costs for combining the SDWIS databases, assuming all of that work will be conducted in 2024, using the 2024 SME 3 contract rate.

• Adds a task to continue to assist MI EGLE NC with migration from WaterTrack to SDWIS and training for EGLE NC staff and the LHDs.

After the separate instances of the SDWIS CWS and SDWIS NC databases are combined into one instance of SDWIS, this item changes the SaaS costs for SOM for SWIFT Surveys, RECAP-Reports, RECAP-Dashboard, and DWV. GEC will also need to update project documentation for this change, and will need to work with the MiLogin team, and GEC’s service provider to ensure that any new IP addresses are whitelisted, for both VPN users in the CWS program, and for the local health departments connecting to SDWIS and SWIFT through the F5.

Description: Combine two versions of SWIFT Surveys into one version.

Version 2021-1 2 of 11

Target Due Date: 6/30/2024

Background: The CWS and NC programs currently maintain two separate SaaS agreements for SWIFT Surveys.

This task provides updated pricing for the remaining years of the contract, with one combined SaaS for SOM expected in the last two years of the contract. The CWS Program currently has a SaaS for up to 100 users, and the NC program has a SaaS for up to 150 users. This change notice removes the original contract pricing for SWIFT Surveys for the CWS programs for Years 3 and 4, and creates one SaaS for up to 250 combined users.

GEC Tasks:

Tasks Effort Estimate (in hours)

SWIFT Surveys SaaS No change

Update Existing Project Documentation 9

TOTAL 20

Assumptions:

• The change to expected SaaS costs is provided below.

• GEC will need to update project documentation to reflect IP addresses, and remove references to separate versions of SWIFT Surveys.

• Assumes that the entire program will need to have a SaaS for up to 250 users beginning on 7/1/2024.

• Assumes that the original contract amounts for SWIFT CWS Years 3 and 4 are removed from the original contract funding, and replaced with the costs below.

• Note that only 1 year of SWIFT was quoted for the EGLE NC program with Change Notice 2, so additional costs for Year 2 of SWIFT are also included below for FY 24 for the NC program. The costs are estimated as monthly SaaS costs until the CWS and NCWS SWIFT Survey instances are combined as of 7/1/2024. NC-only costs cover 10/1/2023 through 6/30/2024, for up to 9 months.

• Costs for CWS SWIFT for Year 2 are also provided monthly, until the CWS and NCWS SWIFT Survey instances are combined as of 7/1/2024. CWS-only costs cover 11/1/2023 through 6/30/2024, for up to 8 months.

Impact: Combining the CWS and NCWS SDWIS databases will allow SDWIS administrative tasks to be consolidated between the two units, as well as federal reporting efforts to EPA.

• This task will require an additional 9 labor hours and $1,343.64 in labor costs using the SME 3 rate for 2024 for project documentation updates.

• Removes $59,171 for SWIFT Year 3 for the CWS Program, and $55,596 for SWIFT Year 4 for the CWS Program.

• Includes 8 of the 12 months of Year 2 for the CWS Program for SWIFT Surveys for up to 100 users from 11/1/2023 through 6/30/2024 or $38,181.83 (instead of $57,727), to be invoiced monthly.

• Includes only 9 of the 12 months of SWIFT Surveys for up to 120 users for the NC Program for Year 2 of the contract (the NC program began SWIFT Surveys after the CWS program) from 10/1/2023 through 6/30/2024, of $61,447.27 to be invoiced monthly.

• Includes Year 4 SWIFT SaaS pricing for up to 250 users from 7/1/2024 to 6/30/2025 of $102,573.81 to be invoiced on an annual basis.

• Includes only 10 months of Year 5 SWIFT SaaS pricing for up to 250 users from 7/1/25 through 4/30/2026 of $90,606.87 to be invoiced on an annual basis.

Description: Combine two versions of RECAP-Reports into one version.

Background: The CWS and NC programs currently maintain two separate SaaS agreements for RECAP-Reports (formerly SWIMR). This task provides updated pricing for one combined SaaS for SOM. The CWS Program currently has a SaaS for up to 100 users, and the NC program has a SaaS for up to 120 users. This change notice removes the original contract pricing for RECAP-Reports for the CWS program for Years 4 and 5 and creates one SaaS for up to 250 combined users.

Version 2021-1 3 of 11

• The NC Year 1 SaaS agreement will end at the same time as the CWS Year 3 SaaS agreement ends, so RECAP reports for 5/1/2024-4/30/25 will be invoiced as an annual SaaS, not monthly.

• Assumes that the entire program will need to have a SaaS for up to 220 users beginning on 5/1/2024.

• Assumes that the original contract amounts for RECAP-Reports CWS Years 4 and 5 are removed from the original contract funding, and replaced with the costs below.

• Removes $44,210 for RECAP-Reports Year 4 for the CWS Program, and $45,315 for RECAP-Reports Year 5 for the CWS Program, removing a total of $89,525.

• Includes Year 4 RECAP-Reports SaaS pricing for up to 220 users from 5/1/2024 to 4/30/2025 of $70,656.79 to be invoiced on an annual basis.

• Includes Year 5 RECAP-Reports SaaS pricing for up to 220 users from 5/1/2025 to 4/30/2026 of $72,776.49 to be invoiced on an annual basis.

Change Item 3 (AKA Task 3)

Description: Combine two versions of RECAP-Dashboard and Drinking Water Viewer into one version.

Target Due Date: 6/30/24

Background: The CWS and NC programs currently maintain two separate SaaS agreements for RECAP-Dashboard and Drinking Water Viewer. This task provides updated pricing for one combined SaaS for SOM.

The CWS Program currently has a SaaS for up to 10 users for RECAP-Dashboard, and the NC program has a SaaS for up to 15 users to start with. Prices for RECAP-Dashboard were provided in Change Notice 3, and are provided again below. The CWS and NC programs plan to move to a higher level of users once they review the applications and move into production. The numbers used below to calculate costs assume that both programs will move to a combined higher level of users to accommodate their program staff.

GEC Tasks:

Tasks Effort Estimate (in hours)

RECAP-Dashboard SaaS 0

TOTAL 0

Table A. The SaaS pricing for RECAP−Dashboard (Compliance Manager Dashboard). The yellow highlighted row was used to determine the cost estimates for the combined version of RECAP-Dashboard, and is based on the number of expected RECAP users.

RECAP−Dashboard SaaS FY23 SaaS FY24 SaaS FY25 SaaS FY26

1-5 users $10,865.00 $11,136.63 $11,415.04 $11,700.42

6-10 users $11,395.00 $11,666.63 $11,945.04 $12,230.42

11-15 users $11,925.00 $12,196.63 $12,475.04 $12,760.42

16-20 users $12,455.00 $12,726.63 $13,005.04 $13,290.42

21-25 users $12,985.00 $13,256.63 $13,535.04 $13,820.42

26-50 users $13,515.00 $13,786.63 $14,065.04 $14,350.42

51-75 users $15,105.00 $15,376.63 $15,655.04 $15,940.42

76-100 users $16,165.00 $16,436.63 $16,715.04 $17,000.42

101-125 $17,225.00 $17,496.63 $17,775.04 $18,060.42

126-150 $18,285.00 $18,556.63 $18,835.04 $19,120.42

Version 2021-1 4 of 11

151-200 $19,345.00 $19,616.63 $19,895.04 $20,180.42

201-250 users $20,405.00 $20,676.63 $20,955.04 $21,240.42

251-300 users $21,465.00 $21,736.63 $22,015.04 $22,300.42

301-350 users $22,525.00 $22,796.63 $23,075.04 $23,360.42

351-400 users $23,585.00 $23,856.63 $24,135.04 $24,420.42

Table B. The SaaS pricing for Drinking Water Viewer. The yellow highlighted row was used to determine the cost estimates for the combined version of Drinking Water Viewer.

Authorized Users SaaS FY23 SaaS FY24 SaaS FY25 SaaS FY26

1-5 users $16,400.00 $16,810.00 $17,230.25 $17,661.01

6-10 users $17,220.00 $17,650.50 $18,091.76 $18,544.06

11-15 users $18,860.00 $19,331.50…