071b6600068.pdf

STATE OF MICHIGAN PROCUREMENT

Department Technology, Management and Budget Central Procurement Services 320 S Walnut Street Lansing, MI 48933 P.O. Box 30026, Lansing, MI 48909

CONTRACT CHANGE NOTICE

Change Notice Number 8 to

Contract Number MA071B6600068C

C O

N

TR

AC

TO

R

MIDWESTERN SOFTWARE SOLUTIONS,

LLC

3815 Plaza Drive

Ann Arbor MI 48108

Ben Chen

734-995-0200 bc@ms2soft.com

CV0004251

ST

AT

E

Pr og ra m

M an ag er

Various Various

C on tr ac t Ad m in is tr at or Corbin Montry DTMB

517-5990012

MontryC@michigan.gov

CONTRACT SUMMARY

Traffic Data Management System

INITIAL EFFECTIVE DATE

April 5, 2016

INITIAL EXPIRATION DATE

April 4, 2021

INITIAL AVAILABLE OPTIONS

5 - 1 Year

EXPIRATION DATE BEFORE

April 4, 2028

PAYMENT TERMS

NET 45

DELIVERY TIMEFRAME

N/A

ALTERNATE PAYMENT OPTIONS

P-Card Direct Voucher (PRC) Other

EXTENDED PURCHASING

Yes No

MINIMUM DELIVERY REQUIREMENTS

N/A

DESCRIPTION OF CHANGE NOTICE

OPTION LENGTH OF OPTION EXTENSION LENGTH OF EXTENSION

REVISED EXP. DATE

CURRENT VALUE

$3,144,784.00

VALUE OF CHANGE NOTICE

$167,060.00

ESTIMATED AGGREGATE CONTRACT VALUE

$3,311,844.00

DESCRIPTION

Please note the Program Manager or Contract Administrator may have changed, and are reflected on this Change Notice.

Effective 05/18/2026, the parties hereby agree to add the following Statement of Work requiring the Contractor to create eleven (11) additional customizations or enhancements to Transportation Data Management System (TDMS) for Michigan Department of Transportation's (MDOT) use. This contract is hereby increased by $167,060.00.

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

CHANGE NOTICE NO. 8 TO CONTRACT NO. MA071B6600068C

Program Managers for

Multi-Agency and Statewide Contracts

AGENCY NAME PHONE EMAIL

MDOT Edward Potter 517-335-2942 pottere@michigan.gov

DTMB Jeffrey LaBean 517-719-2250 LabeanJ@michigan.gov

Michigan.gov/MiProcurement

Version 2026-1 1 of 4

STATEMENT OF WORK -

IT CHANGE NOTICE

Project Title:

MDOT – TDMS Phase 3 Enhancement Group 5

Period of Coverage:

4/5/2026 to 4/4/2027

Requesting Department:

Michigan Department of Transportation (MDOT)

Date:

4/6/2026

Agency Project Manager:

Ed Potter

Phone:

517-243-9624

DTMB Project Manager:

Jeffrey LaBean

Phone:

517-243-1743

Brief description of services to be provided:

BACKGROUND:

This Statement of Work is based on the existing contract between the State of Michigan (SOM) and Midwestern Software Solutions, LLC (MS2) – see contract number 071B6600068, with a current expiration date of April 4, 2028. Through this contract, Contractor provides MDOT with a cloud-based software solution, the Transportation Data Management System (TDMS), that allows MDOT to map, manage, and analyze vehicle traffic count data.

PROJECT OBJECTIVE:

This Statement of Work requires Contractor to create eleven (11) additional customizations or enhancements to TDMS for MDOT’s use.

SCOPE OF WORK:

Continue with phase 3 of the TDMS project to make requested enhancements to TDMS.

TASKS:

Technical support is required to assist with the following tasks:

• Provide project schedule and task progression throughout the life of the project

• Facilitate project status meetings and minutes

• Schedule and facilitate design meetings

• Provide design documentation for review and acceptance

• Implement features / functionality based on approved design documentation

• Schedule and support UAT sessions

• Provide support for UAT defect reporting and resolution

• Production deployment of completed features

• End User Training for new features

Version 2026-1 2 of 4

DELIVERABLES:

Deliverables will not be considered complete until the Agency Project Manager has formally accepted them. Deliverables for this project include three phases:

Design Phase, Implementation Phase, and User Acceptance Testing Phase. Each feature can be released when ready as the items are stand alone and not dependent on the others. The development will not begin until the Functional Design Document milestone is approved for each feature. Deliverables for this project include:

Design Phase Milestone:

• Functional Design Document – references the items listed in the other project documents and provides description of each feature or functional requirement. The document will also include a general test script for design validation. Contractor will develop this document with input and review with MDOT. The test script can be used by MDOT to develop their UAT as needed. The Implementation Phase will not begin until MDOT acceptance of the Functional Design Document.

Implementation Phase Milestone:

• Vendor Testing Report – will provide a checklist of each functional requirement and validation that items were tested by Contractor. Contractor will complete all other testing as part of the internal development process. For this project, only functional test verification will be logged and reported by Contractor. The results will be provided as part of the Vendor Testing Report. The UAT phase begins with the delivery of the report and Contractor demonstration of the functions.

User Acceptance Testing Phase Milestone:

• UAT Resolution Report - Once a group of features or all features are completed and tested by Contractor, MDOT will perform the UAT’s and track through the defect logged via Basecamp (same as previous projects). A meeting will be scheduled to demonstrate the function of the features to MDOT. MDOT will then begin UAT testing. During UAT, MDOT testers will review the function using the test cases for each feature. The tester will determine if the feature passed testing or failed testing. If the test passed, the feature is considered accepted and complete. If the test fails, the reasons for the failure must be identified and logged on Basecamp. The MDOT / Contractor team will review together defect to determine if the cause is a training issue, configuration, or actual defect. The team will determine the priority level and severity Level. These priority and severity levels will be used to identify the order of items to be addressed by Contractor. Once the defects are resolved by Contractor, MDOT testers will complete the UAT’s when the feature is ready for testing. Once features pass the UAT or pass with items noted, they will be considered accepted and released to production.

ACCEPTANCE CRITERIA:

Deliverables will not be considered complete until the Agency and DTMB Project Manager have formally accepted them.

Version 2026-1 3 of 4

PROJECT CONTROL AND REPORTS:

The Contractor must conduct a weekly virtual project meeting. Additional project communication, involving requirements clarification, construction, testing, and project schedule and status will take place on the Contractor’s Basecamp project collaboration site.

PAYMENT SCHEDULE:

DTMB will pay Contractor upon receipt of properly completed invoice(s) which shall be submitted to the billing address on the State issued purchase order not more often than monthly. DTMB Accounts Payable area will coordinate obtaining Agency and DTMB Project Manager approvals. All invoices should reflect actual work completed by payment date and must be approved by the Agency and DTMB Project Manager prior to payment. The invoices shall describe and document to the State’s satisfaction a description of the work performed, the progress of the project, and fees.

When expenses are invoiced, receipts will need to be provided along with a detailed breakdown of each type of expense.

Payment shall be considered timely if made by DTMB within forty-five (45) days after receipt of properly completed invoices.

Payment Schedule Milestones:

Milestone Percentage Payment

Design Phase Milestone Acceptance 10% $16,706.00

Implementation Phase Milestone Acceptance 75% $125,295.00

User Acceptance Testing Phase Milestone Acceptance 15% $25,059.00

Total $167,060.00

The enhancements tied to the Milestones and the associated price for each:

Enh No Enhancement Cost

1 Auto Process to Delete WIM Data $17,495.00

2 Map Popup Details-Only Show Full 24 Hr Counts $8,745.00

3 Autopopulate Field Crew Collection Area in NMDS and TCDS $3,500.00

4 Bulk Edit Counts Status & Add New Count Status $48,105.00

5 Bulk Load NMDS Locations (Via User Interface) $26,240.00

6 NMDS Station Notes $10,935.00

7 Auto Populated "MDOT Needs ID" field $5,250.00

8 Add Note Type to Location Notes $20,990.00

9 Enhance Location Note- Adding Notes with files $6,560.00

Version 2026-1 4 of 4

10 Enhance CS Report: Schedule of Operations to include Loc Notes $10,495.00

11 Enhance Map Service Priority with 2 or more services $8,745.00

Total for 11 Enhancements $167,060.00

EXPENSES:

The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.

PROJECT CONTACTS:

The designated Agency Project Manager is:

Ed Potter MDOT – Bureau of Transportation Planning, Inventory and Integration Division Van Wagoner Building 425 W. Ottawa St.

Lansing, MI, 48933 517-243-9624 pottere@michigan.gov

The designated DTMB Project Manager is:

Jeffrey LaBean DTMB - Agency Services supporting MDOT Van Wagoner Building 425 W. Ottawa St.

Lansing, MI 48933 517-243-1743 labeanj@michigan.gov

AGENCY RESPONSIBILITIES:

Review and approval of the deliverables and submitted invoice(s).

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

Contractor will work at their offices. No work is required on site at MDOT.

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

Work hours are not to exceed eight (8) hours a day, forty (40) hours a week. Normal working hours of 8:00 am to 5:00 pm are to be observed unless otherwise agreed to in writing.

No overtime will be permitted.

STATE OF MICHIGAN PROCUREMENT

Department Technology, Management and Budget Central Procurement Services 320 S Walnut Street Lansing, MI 48933 P.O. Box 30026, Lansing, MI 48909

CONTRACT CHANGE NOTICE

Change Notice Number 7 to

Contract Number MA071B6600068C

C O

N

TR

AC

TO

R

MIDWESTERN SOFTWARE SOLUTIONS,

LLC

3815 Plaza Drive

Ann Arbor MI 48108

Ben Chen

734-995-0200 bc@ms2soft.com

CV0004251

ST

AT

E

Pr og ra m

M an ag er

Various Various

C on tr ac t Ad m in is tr at or Corbin Montry DTMB

517-599-0012

MontryC@michigan.gov

CONTRACT SUMMARY

Traffic Data Management System

INITIAL EFFECTIVE DATE

April 5, 2016

INITIAL EXPIRATION DATE

April 4, 2021

INITIAL AVAILABLE OPTIONS

5 - 1 Year

EXPIRATION DATE BEFORE

April 4, 2028

PAYMENT TERMS

NET 45

DELIVERY TIMEFRAME

N/A

ALTERNATE PAYMENT OPTIONS

P-Card Direct Voucher (PRC) Other

EXTENDED PURCHASING

Yes No

MINIMUM DELIVERY REQUIREMENTS

N/A

DESCRIPTION OF CHANGE NOTICE

OPTION LENGTH OF OPTION EXTENSION LENGTH OF EXTENSION

REVISED EXP. DATE

CURRENT VALUE

$3,144,784.00

VALUE OF CHANGE NOTICE

$0.00

ESTIMATED AGGREGATE CONTRACT VALUE

$3,144,784.00

Please note the Program Manager or Contract Administrator may have changed, and are reflected on this Change Notice.

Effective 03/23/2026, the contract is amended to incorporate the below updated ADA Compliance Language. This language replaces, in its entirety, the previous WCAG 2.0 Level AA language. No additional funding is required. All other terms, conditions, specifications and pricing remain the same. Per contractor and agency agreement, and DTMB Central Procurement Services approval.

Updated ADA Compliance Language:

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.

Starting 4/24/2026, 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, must comply with WCAG 2.1 Level AA.

CHANGE NOTICE NO. 7 TO CONTRACT NO. MA071B6600068C

Program Managers for

Multi-Agency and Statewide Contracts

AGENCY NAME PHONE EMAIL

DTMB Jeffrey LaBean 517-243-1743 LabeanJ@michigan.gov

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

Traffic Data Management System

INITIAL EFFECTIVE DATE INITIAL EXPIRATION DATE INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

April 5, 2016 April 4, 2021 5 - 12 Months April 4, 2026

PAYMENT TERMS DELIVERY TIMEFRAME

ALTERNATE PAYMENT OPTIONS EXTENDED PURCHASING

MINIMUM DELIVERY REQUIREMENTS

N/A

P-Card Direct Voucher (PRC) Other Yes No

3815 Plaza Drive

Ann Arbor MI 48108

Ben Chen

734-995-0200 bc@ms2soft.com

CV0004251

MIDWESTERN SOFTWARE

SOLUTIONS, LLC

C O

N

TR

A C

TO

R

Corbin Montry

517-256-9895

DTMB

Various Various montryc@michigan.gov

C ontract

A dm inistrator Program M anagerSTA

TE

N/ANET 45

Change Notice Number 6

Contract Number MA071B6600068C 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

12 Months 2 Years April 4, 2028

$2,842,530.00 $302,254.00 $3,144,784.00

Effective 06/24/2025, this Contract is extended by 24 months, and is increased by $302,254.00. The revised contract expiration date is 04/04/2028.

The following amendment is incorporated into this Contract per attached Statement of Work for customizations or enhancements to the Traffic Count Database System (TCDS) for Michigan Department Of Transportation's (MDOT) use.

Please note the Program Manager has been changed to Jeffrey LaBean.

Please note the Contract Administrator has been changed to Corbin Montry.

All other terms, conditions, specifications, and pricing remain the same. Per contractor and agency agreement, DTMB Central Procurement Services approval, and State Administrative Board approval on 06/24/2025.

AGENCY NAME PHONE EMAIL

DTMB Jeffrey LaBean 517-719-2250 LabeanJ@michigan.gov

Program Managers for

Multi-Agency and Statewide Contracts

CHANGE NOTICE NO. 6 TO CONTRACT NO. MA071B6600068C

MICHIGAN DEPARTMENT OF TECHNOLOGY,

MANAGEMENT AND BUDGET

IT SERVICES

STATEMENT OF WORK

Project Title:

MDOT – TDMS Phase 3 Enhancement Group 4

Period of Coverage:

4/5/2025 to 4/4/2026

Requesting Department:

Michigan Department of Transportation

Date:

4/9/2025

Agency Program Manager:

Ed Potter

Phone:

517-243-9624

DTMB Program Manager:

Jeffrey LaBean

Phone:

517-243-1743

BRIEF DESCRIPTION OF SERVICES TO BE PROVIDED:

The Michigan Department of Transportation is requesting enhancements to existing functionality within the Midwestern Software Solutions (MS2 or Contractor) Transportation Data Management System (TDMS).

The contract will also be extended by two additional years, covering April 5, 2026, to April 4, 2028.

BACKGROUND:

This Statement of Work is based on the existing contract between the State of Michigan (SOM) and Midwestern Software Solutions, LLC (MS2) – see contract number 071B6600068, with a current expiration date of April 4, 2026. Through this contract, Contractor provides MDOT with a cloud-based software solution, the Transportation Data Management System (TDMS), that allows MDOT to map, manage, and analyze vehicle traffic count data.

PROJECT OBJECTIVE:

This Statement of Work requires Contractor to create four additional customizations or enhancements to TDMS for MDOT’s use. The contract will also be extended two years, from April 5, 2026, to April 4, 2028.

SCOPE OF WORK:

Continue with phase 3 of the TDMS project to make requested enhancements to the Traffic Count Database System (TCDS). Enhancements to TDMS and the associated price for each enhancement are listed below:

Item No

Module Functional Description

Notes Cost

1 TCDS Year End Process Enhancement (CDFs)

Add new optional Year End Process (YEP) Step before Class Distribution Clustering step.

$32,801

2 TCDS Agency to Agency (A2A) Tool Improvement

Add the option to pull counts into the system and set the status to Pending QC, then mark QC status according to QC group rules.

$8,747

3 TCDS R&H / TCDS

Integration “On NHS” Attribute Update

Update the Roads & Highways TCDS integration for the attribute “On NHS” for Real Time and On Demand Sync.

$15,307

4 TCDS Count Compare Tool Enhancement

Add label or hover over on graph with Location ID; add “Most Recent Prior Count” dropdown option in the Similar Date Selection; Add “Add All Counts, (Limit of 10)” dropdown option in the Date Range Selection; auto complete on Location ID field (like all other autocomplete fields)

$28,427

4 Enhancements $85,282

Annual Software Maintenance & Support – (4/5/2026 to 4/4/2027) $105,840 Annual Software Maintenance & Support – (4/5/2027 to 4/4/2028) $111,132

Total Two-Year Extension $216,972

TASKS:

Technical support is required to assist with the following tasks:

• Provide project schedule and task progression throughout the life of the project

• Facilitate project status meetings and minutes

• Schedule and facilitate design meetings

• Provide design documentation for review and acceptance

• Implement features / functionality based on approved design documentation

• Schedule and support UAT sessions

• Provide support for UAT defect reporting and resolution

• Production deployment of completed features

• End User Training for new features

DELIVERABLES:

The project will have three phases: Design Phase, Implementation Phase, and User Acceptance Testing Phase. Each feature can be released when ready as the items are stand alone and not dependent on the others. The development will not begin until the Functional Design Document milestone is approved for each feature. Deliverables for this project include:

Design Phase Milestone:

• Functional Design Document – references the items listed in the other project documents and provides description of each feature or functional requirement.

The document will also include a general test script for design validation.

Implementation Phase Milestone:

• Vendor Testing Results Report – will provide a checklist of each functional requirement and validation that items were tested by Contractor. Contractor will complete all other testing as part of the internal development process.

User Acceptance Testing Phase Milestone:

• UAT Resolution Report

Once a group of features or all features are completed and tested by Contractor, MDOT will perform the UAT’s and track through the defect logged via Basecamp (same as previous projects). A meeting will be scheduled to demonstrate the function of the features to MDOT. MDOT will then begin UAT testing. During UAT, MDOT testers will review the function using the test cases for each feature. The tester will determine if the feature passed testing or failed testing. If the test passed, the feature is considered accepted and complete.

If the test failed, the reasons for the failure must be identified and logged on Basecamp.

The MDOT / Contractor team will review together defect to determine if the cause is a training, configuration, or actual defect. The team will determine the priority level and severity Level. These priority and severity levels will be used to identify the order of items to be addressed by Contractor. Once the defects are resolved by Contractor, MDOT testers will complete the UAT’s when the feature is ready for testing. Once features pass the UAT or pass with items noted, they will be considered accepted and released to production.

ACCEPTANCE CRITERIA:

Deliverables will not be considered complete until the Agency and DTMB Project Manager have formally accepted them.

Project Control and Reports:

The Contractor must conduct a weekly virtual project meeting. Additional project communication involving requirements clarification, construction, testing, and project schedule and status will take place on the Contractor’s Basecamp project collaboration site.

PAYMENT SCHEDULE:

DTMB will pay Contractor upon receipt of properly completed invoice(s) which shall be submitted to the billing address on the State issued purchase order not more often than monthly. DTMB Accounts Payable area will coordinate obtaining Agency and DTMB Project Manager approvals. All invoices should reflect actual work completed by payment date and must be approved by the Agency and DTMB Project Manager prior to payment. The invoices shall describe and document to the State’s satisfaction a description of the work performed, the progress of the project, and fees. When expenses are invoiced, receipts will need to be provided along with a detailed breakdown of each type of expense.

Payment shall be considered timely if made by DTMB within forty-five (45) days after receipt of properly completed invoices.

Payment Schedule Milestones:

Milestone Percentage Payment

Design Phase Milestone Acceptance 10% $8,528.20

Implementation Phase Milestone Acceptance 75% $63,961.50

User Acceptance Testing Phase Milestone Acceptance 15% $12,792.30

Total $85,282.00

EXPENSES:

The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.

PROJECT CONTACTS:

The designated Agency Program Manager is:

Ed Potter MDOT – Bureau of Transportation Planning, Inventory and Integration Division Van Wagoner Building 425 W. Ottawa St.

Lansing, MI, 48933 517-243-9624 pottere@michigan.gov

The designated DTMB Program Manager is:

Jeffrey LaBean DTMB - Agency Services supporting MDOT Van Wagoner Building 425 W. Ottawa St.

Lansing, MI 48933 517-243-1743 labeanj@michigan.gov

AGENCY RESPONSIBILITIES:

Review and approval of the deliverables and submitted invoice(s).

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

Contractor will work at their offices. No work is required on site at MDOT.

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

Work hours are not to exceed eight (8) hours a day, forty (40) hours a week. Normal working hours of 8:00 am to 5:00 pm are to be observed unless otherwise agreed to in writing.

No overtime will be permitted.

mailto:pottere@michigan.gov mailto:labeanj@michigan.gov

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 5 to

Contract Number 071B6600068

Various

Robin Lampert bc@ms2soft.com

Ben Chen

Ann Arbor, MI 48108

MIDWESTERN SOFTWARE SOLUTIONS, LLC

CV0004251

734-995-0200

3815 Plaza Drive

(517) 582-2746

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

lampertr1@michigan.gov

$2,450,422.00

April 5, 2016 April 4, 2024

TRAFFIC DATA MANAGEMENT SYSTEM

April 4, 2021

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

☒ 2 1- year ☐ April 4, 2026

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$392,108.00 $2,842,530.00

Effective February 13, 2024, this Contract is exercising the 4th and 5th option years and is increased by $392,108. The revised contract expiration date is April 4, 2026.

Note: When Change Notice 2 added two option years, they were not noted as "initial available options" in the Change Notice summary block. These are the 2 option years being exercised now with $298,700.

Per the attached Statement of Work, the following enhancements to support continued improvement application efficiency and data quality are added with $93,408 funding:

* dynamic links between Roads & Highways and the Traffic Count Database System

* addition of formatted location ID labels to maps

* add a sorting function to location notes

* add custom report to compare commercial percentages between years

* add custom report to validate the Traffic Count Database System with corresponding traffic segments

INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE

DESCRIPTION

CONTRACT SUMMARY

MDOT

Please note the Contract Administrator has been changed to Robin Lampert.

All other terms, conditions, specifications, and pricing remain the same. Per contractor and agency agreement, DTMB Central Procurement Services approval, and State Administrative Board approval on February 13, 2024.

Program Managers for

CHANGE NOTICE NO. 5 TO CONTRACT NO. 071B6600068

Edward Potter 517-335-2942 pottere@michigan.govMDOT

Dave Work 517-719-2250 workd@michigan.govDTMB

Version 2023-1 071B6600068 CN 5 1 of 5

STATEMENT OF WORK -

IT CHANGE NOTICE

Project Title:

MDOT – TDMS Phase 3 Enhancement Group 3

Period of Coverage:

12/1/2023-12/1/2024

Requesting Department:

Michigan Department of Transportation

Date:

10/30/2023

Agency Project Manager:

Ed Potter

Phone:

517-243-9624

DTMB Project Manager:

Dave Work

Phone:

517-719-2250

Brief description of services to be provided:

The Michigan Department of Transportation (MDOT) is requesting enhancements to existing functionality within the Midwestern Software Solutions (MS2 or Contractor) Transportation Data Management System (TDMS).

Additional updates to the Contract to exercise the 2 remaining option years.

BACKGROUND:

This Statement of Work is based on the existing contract between the State of Michigan (SOM) and Midwestern Software Solutions, LLC (MS2), see contract number 071B6600068. Through this contract, Contractor provides MDOT with a cloud-based software solution, called Transportation Data Management System (TDMS), that allows MDOT to map, manage and analyze vehicle traffic count data.

PROJECT OBJECTIVE:

This Statement of Work requires Contractor to create five additional customizations or enhancements to TDMS for MDOT’s use.

SCOPE OF WORK:

Continue with phase 3 of the TDMS project to make requested enhancements to the Non-Motorized Database System, Traffic Count Database System (TCDS), and Highway Performance Monitoring System modules. Enhancements to TDMS and the associated price for each enhancement are listed below:

Version 2023-1 071B6600068 CN 5 2 of 5

Item No

Module Functional Description

Notes Cost

1 TCDS Link R&H to TCDS, Control Section and Ctrl Section MP

A dynamic link between Roads & Highways and TCDS to update location attributes with real-time Control Section and Control Section Milepoint.

$21,038

2 NMDS Add Location ID labels to map

To include Location ID labels to map with predetermined format (XX-

XXXXXN).

$15,147

3 TCDS Enhance Location notes with sort option

Improve location note attribute to include a sorting function.

$15,147

4 TCDS Report to compare previous years percent comparisons

Custom report that compares commercial percentages from one year to the next from a query.

5 HPMS Report to check TCDS attributes against segments

Custom report that validates TCDS Primary station locations with their corresponding traffic segment.

5 Enhancements $93,408

• Provide project schedule and task progression throughout the life of the project

• Facilitate project status meeting and minutes

• Schedule and facilitate design meetings

• Provide design documentation for review and acceptance

• Implement features/ functionality based on approved design documentation

• Provide assistance when MDOT develops test cases

• Provide User Acceptance Testing (UAT) environment

• Schedule and support UAT sessions

• Provide support for UAT defect reporting and resolution

• Production deployment of completed features

• End User Training for new features

DELIVERABLES:

The project will have three phases, Design Phase, Implementation Phase, and User acceptance Testing Phase. Each feature can be released when ready as the items are stand alone and not depend on the others. The development will not begin until the milestone, Functional Design Document is approved. Deliverables for this project include:

Version 2023-1 071B6600068 CN 5 3 of 5

Design Phase Milestone:

• Functional Design Document - references the items listed in the other project documents and provides description of each feature or functional requirement. The document will also include a general test script for design validation.

Implementation Phase Milestone:

• Vendor Testing Results Report - will provide a checklist of each functional requirement and validation that items were tested by Contractor. Contractor will complete all other testing as part of the internal development process.

User Acceptance Testing Phase Milestone:

• UAT Resolution Report

Once a group of features or all features are completed and tested by Contractor, MDOT will perform the UAT’s and track through the defect logged via Basecamp (same as previous projects). A meeting will be scheduled to demonstrate the function of the features to MDOT. MDOT will then begin UAT testing. During UAT, MDOT testers will review the function using the test cases for each feature. The tester will determine if the feature passed testing or failed testing. If the test passed, the feature is considered accepted and complete.

If the test failed, the reasons for the failure must be identified and logged on Basecamp.

The MDOT / Contractor team will review together defect to determine if the cause is a training, configuration, or actual defect. The team will determine the priority level and severity Level. These priority and severity levels will be used to identify the order of items to be addressed by Contractor. Once the defects are resolved by Contractor, MDOT testers will complete the UAT’s when the feature is ready for testing. Once features pass the UAT or pass with items noted, they will be considered accepted and released to production.

ACCEPTANCE CRITERIA:

Deliverables will not be considered complete until the Agency and DTMB Project Manager have formally accepted them.

PROJECT CONTROL AND REPORTS:

The Contractor must conduct a weekly virtual project meeting. Additional project communication involving requirements clarification, construction, testing, and project schedule and status will take place on the Contractor’s Basecamp project collaboration site.

PAYMENT SCHEDULE:

DTMB will pay Contractor upon receipt of properly completed invoice(s) which shall be submitted to the billing address on the State issued purchase order not more often than

Version 2023-1 071B6600068 CN 5 4 of 5 monthly. DTMB Accounts Payable area will coordinate obtaining Agency and DTMB Project Manager approvals. All invoices should reflect actual work completed by payment date and must be approved by the Agency and DTMB Project Manager prior to payment.

The invoices shall describe and document to the State’s satisfaction a description of the work performed, the progress of the project, and fees. When expenses are invoiced, receipts will need to be provided along with a detailed breakdown of each type of expense.

Payment shall be considered timely if made by DTMB within forty-five (45) days after receipt of properly completed invoices.

Payment Schedule Milestones:

Milestone Percentage Payment

Design Phase Milestone Acceptance 25% 23,352.00 Implementation Phase Milestone Acceptance 50% 46,704.00 User Acceptance Testing Phase Milestone Acceptance

25% 23,352.00

Total 100% $ 93,408.00

EXPENSES:

The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.

PROJECT CONTACTS:

The designated Agency Project Manager is:

Name: Ed Potter Department: Transportation Area: Bureau of Transportation Planning, Data Inventory and Integration Division Building/Floor: Murray D. Van Wagoner Building, 3rd Floor Address: 425 W. Ottawa Street City/State/Zip: Lansing, Michigan 48909 Phone Number: 517-243-9624 Email Address: PotterE@michigan.gov

The designated DTMB Project Manager(s) is:

Name: Dave Work Department: DTMB Area: Agency Services supporting MDOT Building/Floor: Murray D. Van Wagoner Building, 3rd Floor Address: 425 W. Ottawa Street City/State/Zip: Lansing, Michigan 48909 Phone Number: 517-719-2250 Email Address: workd@michigan.gov

Version 2023-1 071B6600068 CN 5 5 of 5

AGENCY RESPONSIBILITIES:

Review and approval of the deliverables and submitted invoice(s).

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

Contractor’s office is located at 5200 S. State Rd, Ste 100, Ann Arbor, MI. Work will be performed by Contractor at their office or at the offices assigned to Contractor employees by Contractor.

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

Work hours are not to exceed eight (8) hours a day, forty (40) hours a week. Normal working hours of 8:00 am to 5:00 pm are to be observed unless otherwise agreed to in writing.

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

071B6600068Contract Number

Various

Christopher Martin bc@ms2soft.com

Ben Chen

Ann Arbor, MI 48108

MIDWESTERN SOFTWARE SOLUTIONS, LLC

CV0004251

734-995-0200

3815 Plaza Drive

(517) 643-2833 S

T A

T E

P ro g ram an ag er C o n tract A d m in istrato r

C O

N T

R A

C T

O R

DTMB

martinc20@michigan.gov

$2,356,124.00

April 5, 2016 April 4, 2024

TRAFFIC DATA MANAGEMENT SYSTEM

April 4, 2021

INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

0 - 0 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 4, 2024

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$94,298.00 $2,450,422.00

Effective 9/29/2022, the following amendments are incorporated into this Contract per the attached Statement of Work. This change includes the following:

1. TCDS - Improve A2A pairing with SEMCOG and their agencies. Address inconsistencies between MDOT and SEMCOG in the way traffic stations are created and data is stored to allow more local data to be used in annual HPMS submittal. Cost:

$32,626.00

adjust formatting as needed to keep or create the ability to easily filter in XLS format. Cost: $13,926.00

5. TCDS - Update R&H Fields Integration: Retrieve valus from MDOT’s R&H to populate the “HPMS ID” and “On HPMS” fields in TCDS. Cost: $9,549.00

The Contract is increased by $94,298.00 for MDOT use.

INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE

DESCRIPTION

All other terms, conditions, specifications, and pricing remain the same. Per contractor and agency agreement, DTMB Central Procurement Services approval, and State Administrative Board approval on 9/29/2022.

Program Managers for

CHANGE NOTICE NO. 4 TO CONTRACT NO. 071B6600068

Edward Potter 517-335-2942 pottere@michigan.govMDOT

STATEMENT OF WORK FOR IT CHANGE NOTICES

TDMS Phase 3 Enhancment Group 2

Period of Coverage:

Sept 2022 – August 2023

Requesting Department:

Michigan Department of Transportation

Date:

8-17--2022

Agency Project Manager:

Ed Potter

Phone:

517-243-9624

DTMB Project Manager:

Dave Work

Phone:

517-719-2250

Brief Description of Services to be provided:

BACKGROUND:

This Statement of Work is based on the existing contract between the State of Michigan (SOM) and Midwestern Software Solutions, LLC (MS2), see contract number 071B6600068. Through this contract, MS2 provides MDOT with a cloud-based software solution, called Transportation Data Management System, that allows MDOT to map, manage and analyze vehicle traffic count data.

This Statement of Work requires MS2 to create five additional customizations or enhancements to TDMS for MDOT’s use. Enhancement, which are described in the Scope of Work section, will improve the end user experience and increase efficiency and data quality by accomplishing the following:

• Expand the use of Roads & Highways events to autopopulate TDMS station attributes.

• Enhance consistency in the display of data collected by local agencies and MPOs

• Improve reporting options, and expand the range of available intersection types to improve experience and ease of use by end users.

SCOPE OF WORK:

Continue with phase 3 of the TDMS project to make requested enhancements to the Non-Motorized Database System, Traffic Count Database System, Scheduler Module, and Turning Movement Count Module.

Enhancments to TDMS and the associated price for each enhancements are listed below:

Module Functional Description Notes Cost

1 TCDS Improve A2A pairing with SEMCOG and their agencies. Address inconsistencies between MDOT and SEMCOG in the way traffic stations are created and data is stored to allow more local data to be used in annual HPMS submittal

$32,626

2 Scheduler Direct linking from Scheduler to MDOT’s count and construction map

11 data fields identified by MDOT with filtering by Task Status. Will include both TCDS and NMDS tasks. Overnigh update process.

$14,324

3 TMC TMC Intersection Icons / dropdown.

Expands to range of intersection types

Update signalized field to a dropdown with a fixed list of values. Update advanced search “signalized” field to use new values. Update map to display different icons based on the new values.

$23,873

4 NMDS NMDS Location Information Report:

Expand existing report (or create a new report) to include additional fields and adjust formatting as needed to keep or create the ability to easily filter in XLS format

16 fields identified by MDOT to include in the report

$13,926

5 TCDS Update R&H Fields Integration:

Retrieve valus from MDOT’s R&H to populate the “HPMS ID” and “On HPMS” fields in TCDS

$9,549

5 Enhancments $94,298

• Provide project schedule and task progression throughout the life of the project

• Facilitate project status meeting and minutes

• Schedule and facilitate design meetings

• Provide design documentation for review and acceptance

• Construction based on approved design documentation

• Provide assistance when MDOT develops test cases

• Provide User Acceptance Testing (UAT) environment

• Schedule and support UATsessions

• Provide UAT defect reporting and resolution

• Production deployment of completed milestones

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

Deliverables for this project include:

1. Functional/system design document that addesses the five enhancements noted in the Scope of Work

2. Validation testing report

3. UAT resolution log, which can be in the form of a Basecamp thread

4. Archived basecamp correspondence log

5. Minutes from each formal scheduled meeting

6. Five approved enhancements noted on the Scope of Work in MDOT’s TDMS Production environment

Acceptance criteria for each milestone are as follows:

Design Acceptance Criteria

• Functional/System design approval

• Design Milestone Acceptance Sign-off

Implementation Acceptance Criteria

• Vendor System Acceptance Testing Results

• Implementation Milestone Sign-off

UAT Acceptance Criteria

• UAT Resolution Log

• UAT Milestone Acceptance Sign-off

Project will be deemed to be complete once all six deliverable are accepted by MDOT.

PROJECT CONTROL AND REPORTS:

An updated quarterly project schedule must be submitted to the Agency and DTMB Project Managers throughout the life of this project. Each quarterly schedule must contain information on the percent complete for each item on the schedule.

SPECIFIC DEPARTMENT STANDARDS:

Agency standards, if any, in addition to DTMB standards.

Payment will be made on a satisfactory acceptance of each Milestone basis as noted in the project plan.

Milestones are (1) the completion of the Design Phase, (2) the completion of the Implementation Phase, and

(3) the completion of the UAT Testing Phase. DTMB will pay CONTRACTOR upon receipt of properly completed invoice(s) which shall be submitted to the billing address on the State issued purchase order not more often than monthly. DTMB Accounts Payable area will coordinate obtaining Agency and DTMB Project Manager approvals. All invoices should reflect actual work completed by payment date, and must be approved by the Agency and DTMB Project Manager prior to payment. The invoices shall describe and document to the State’s satisfaction a description of the work performed, the progress of the project, and fees. When expenses are invoiced, receipts will need to be provided along with a detailed breakdown of each type of expense.

Payment shall be considered timely if made by DTMB within forty-five (45) days after receipt of properly completed invoices.

EXPENSES:

The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.

PROJECT CONTACTS:

The designated Agency Project Manager is:

Ed Potter Michigan Department of Transportation Bureau of Transportation Planning, Data Inventory and Integration Division Murry D. Van Wagoner Building, 3rd Floor 425 W. Ottawa Street Lansing, Michigan 48909 517-243-9624 pottere@michigan.gov

The designated DTMB Project Manager is:

Dave Work Department of Technology, Management and Budget

Agency Services MDOT – Public Services and Field Operations Section Murray D. Van Wagoner Building, 3rd Floor 425 W. Ottawa Street Lansing, Michigan 48909 517-719-2250 WorkD@michigan.gov

LOCATION OF WHERE THE WORK IS TO BE PERFORMED:

Consultants office is located at 5200 S. State Rd, Ste 100, Ann Arbor, MI. Work will be preformed by MS2 at their office or at the offices assigned to MS2 employees by MS2.

EXPECTED CONTRACTOR WORK HOURS AND CONDITIONS:

Work hours are not to exceed eight (8) hours a day, forty (40) hours a week. Normal working hours of 8:00 am to 5:00 pm are to be observed unless otherwise agreed to in writing.

PROJECT PLAN AND MILESTONES/MILESTONE PAYMENT AMOUNTS:

Department of Technology, Management, and Budget

525 W. ALLEGAN ST., LANSING, MICHIGAN 48913

P.O. BOX 30026 LANSING, MICHIGAN 48909

CONTRACT CHANGE NOTICE

Change Notice Number 3 to

071B6600068Contract Number

Various

Christopher Martin bc@ms2soft.com

Ben Chen

Ann Arbor, MI 48108

MIDWESTERN SOFTWARE SOLUTIONS, LLC

CV0004251

734-995-0200

3815 Plaza Drive

(517) 643-2833 S

T A

T E

P ro ag er C o n tract A d m in istrato r

C O

N T

R A

C T

O R

DTMB

martinc20@michigan.gov

$2,157,880.00

April 5, 2016 April 4, 2024

TRAFFIC DATA MANAGEMENT SYSTEM

April 4, 2021

INITIAL AVAILABLE OPTIONS EXPIRATION DATE

BEFORE

0 - 0 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 4, 2024

CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE

$198,244.00 $2,356,124.00

Effective 6/18/2021, the following amendments are incorporated into this Contract per attached SOW. This change includes 12 Group One enhancements for Phase Three of the TDMS project. The firm fixed price for these enhancements is $198,244.00.

This Contract is increase by $198,244.00 for MDOT use.

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

INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE

DESCRIPTION

Program Managers for

CHANGE NOTICE NO. 3 TO CONTRACT NO. 071B6600068

Chris Hundt 517-335-4600 hundtc@michigan.govMDOT

STATEMENT OF WORK FOR IT CHANGE NOTICES

TDMS Phase 3 Enhancment Group 1

Period of Coverage:

June 2021 – June 2022

Requesting Department:

Michigan Department of Transportation

Date:

5-04-2021

Agency Project Manager:

Chris Hundt

Phone:

517-230-8710

DTMB Project Manager:

Dave Work

Phone:

517-719-2250

Brief Description of Services to be provided:

BACKGROUND:

This Statement of Work is based on the existing contract between the State of Michigan (SOM) and Midwestern Software Solutions, LLC (MS2), see contract number 071B6600068. Through this contract, MS2 provides MDOT with a cloud-based software solution, called Transportation Data Management System, that allows MDOT to map, manage and analyze vehicle traffic count data.

This Statement of Work requires MS2 to create twelve additional customizations or enhancements to TDMS for MDOT’s use. Enhancements, which are described in the Scope of Work section, will improve the end user experience, and increase efficiency and data quality by accomplishing the following:

• Expand the use of Roads & Highways events to auto-populate TDMS station attributes.

• Link the nonmotorized module to the Scheduler module to permit seamless scheduling for nonmotorized traffic counts.

• Improve search and reporting options, and enhance display of traffic stations in all modules for better end user experiences

SCOPE OF WORK:

Initiate phase 3 of the TDMS project to make requested enhancements to the Non-Motorized Database System, Traffic Count Database System, Scheduler Module, and Turning Movement Count Module. Enhancments to TDMS and the associated price for each enhancements are listed below:

Module Functional Description Notes Cost

1 NMDS &

Scheduler

NMDS Task Creation for Scheduler:

Setup functionaly similiar to existing TCDS for setting up tasks for Scheduler Module. NMDS count locations need a station attribute to designate collection group, count type. Link to open "task scheduler" is needed in NMDS. Need count equipment field as well.

Need to consider Count Type for designating count type to corespond to facility type (Omega

v. Mio, etc). Multiple types of non-intrusitive count equipment may be used. Is there a way to distinguish between the various types.

$98,733

2 TCDS (2) TCDS Speed Reports. Would like to be able to compare average speeds for a group of stations for two different time periods. Add a row that includes the average speed for all sites to the Quarterly Speed Report (combines all "area types" and "FCs"). Average speed for all searched stations could also be added to the Speed Report Multiple Sites report.

2 Mockups provided by MDOT $7,024

3 TCDS (1) Report added to the Volume Balancing Tool.

Mockup provided by Kyle via email 3/11/21

$3,512

4 TMC Map Feature Site: AADTS and/ or AADTs on map. Create an option to display TCDS location IDs on the map in TMC. User should have the option to display AADTs or location ID or both in TMC map.

Provide a feature in TMC and

NMDS

$13,659

5 TMC Feature enhancement when creating TMC intersections. When creating a TMC intersection at least 2 legs or directions must be found.

If a boulevard road is used R&H will pull data and create intersection.

On non-divided roads where one (of two) legs is off PR network (private parking lot) then a more manual process is needed. Can this be streamlined?

MS2 will update the wizard where user will click "next" and it asks "are you sure you want to continue with just 1 route?" and then after the wizard they manually add the leg and its information

$5,463

6 TCDS Access Backup File Naming Feature: The user will be able provide text that will be added to the subjec line of the email that provide the Access Backup file.

Background: Allow access back up files to be named by the requestor so that when multiple access requests are submitted they can be effectively managed by the requestor.

$10,146

7 TCDS Enhance Backup feature: Should be able to request backup that only includes the two way and directional locations (i.e. should have option to exclude lane level data from the request)

$17,561

8 R&H Update R&H Fields Integration:

Need to have "community" field in TCDS, TMC, and NMDS plugged into R&H so that these field will be populated by data in R&H.

$11,707

9 TMC Enhance behavior for editing with a multi-page search results. When search result produce more than one page of locations, and a locaiton is edited, when edit is complete and user is returned to search results, they are returned to page one of the search results.

Should be returned to last page viewed.

$13,659

10 TCDS Enhance TCDS map to Display the location ID and/or AADT on the map for stations that are identifed through the search functions.

Location IDs and/or AADTs appear for surrounding stations

Searched locatoins show a different color and DOES not show AADT/ ID. User selects "locate" button , the map label should be the same as the map settings

$8,195

11 TCDS Enhance search to allow user to query records that were transferred from AtoA.

MS2 will add a wildcard search on the Build Search: Count Source field. Ie A2A* will give anything wil A2a in the name

$3,902

12 R&H Update R&H Fields Integration:

Need to have "route" field in TCDS plugged into R&H so that the field will be populated by data in R&H.

$4,683

12 Enhancments $198,244

• Provide project schedule and task progression throughout the life of the project

• Facilitate project status meeting and minutes

• Schedule and facilitate design meetings

• Provide design documentation for review and acceptance

• Construction based on approved design documentation

• Provide assistance when MDOT develops test cases

• Provide User Acceptance Testing (UAT) environment

• Schedule and support UATsessions

• Provide UAT defect reporting and resolution

• Production deployment of completed milestones

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

Deliverables for this project include:

1. Functional/system design document that addesses the twelve enhancements noted in the Scope of Work

2. Validation testing report

3. UAT resolution log, which can be in the form of a Basecamp thread

4. Archived Basecamp correspondence log

5. Minutes from each formal scheduled meeting

6. Twelve approved enhancements noted on the Scope of Work in MDOT’s TDMS Production environment

Acceptance criteria for each milestone are as follows:

Design Acceptance Criteria

• Functional/System design approval

• Design Milestone Acceptance Sign-off

Implementation Acceptance Criteria

• Vendor System Acceptance Testing Results

• Implementation Milestone Sign-off

UAT Acceptance Criteria

• UAT Resolution Log

• UAT Milestone Acceptance Sign-off

Project will be deemed to be complete once all six deliverable are accepted by MDOT.

PROJECT CONTROL AND REPORTS:

An updated monthly project schedule must be submitted to the Agency and DTMB Project Managers throughout the life of this project. Each monthly schedule must contain information on the percent complete for each item on the schedule.

Payment will be made on a satisfactory acceptance of each Milestone basis as noted in the project plan.

Milestones are (1) the…