1300154.pdf
PDF 4 MB Posted
- Contract number
- MA071B1300154C
- Issued by
- Michigan
About this file
This document is a state contract between the State of Michigan, specifically the Michigan State Police (MSP) Forensic Science Division, and The Computer Solution Company of Virginia, Inc. (doing business as Forensic Advantage Systems), for a Laboratory Case Management System (LCMS). The contract involves software licensing, maintenance, and support services for the state's forensic science laboratories, with the Michigan Department of Technology, Management and Budget (DTMB) serving as the contracting agency.
The contract covers maintenance and support for Forensic Advantage software, including client and server licenses, with a total project cost of $1,010,675.00 over an initial five-year term from January 1, 2011 to December 31, 2015. The agreement includes 250 client licenses and 9 server licenses, with annual maintenance costs and the option to purchase up to $500,000 in additional services. The contract includes five one-year renewal options and provides for ongoing software maintenance, technical support, and potential future enhancements for the Michigan State Police Forensic Science Division's seven laboratories and three satellite locations. The pricing is based on a 22% maintenance rate, with provisions for emergency availability and potential additional licenses, services, and training.
View the file
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Michigan.gov/MiProcurement
Version 2021-2 1 of 1
Funding Allocation for Optional Time & Materials Services
Contract No. 071B1300154
Laboratory Case Management System
Upon request, Contractor will provide hourly rate services to the State at the labor rates already stated in the Contract up to the totals shown for the periods below.
Note: Items highlighted in yellow denote revisions made via Change Notice No. 18, effective 7/2/25.
Term Cost
Base Contract Years
September 1, 2021 – December 31, 2021 $15,000
January 1, 2022 – December 31, 2022 $15,000
January 1, 2023 – December 31, 2023 $15,000
January 1, 2024 – December 31, 2024 $15,000
January 1, 2025 – December 31, 2025 $60,000
Base Years Subtotal $120,000
Option Years
January 1, 2026 – December 31, 2026 $15,000
January 1, 2027 – December 31, 2027 $15,000
January 1, 2028 – December 31, 2028 $15,000
January 1, 2029 – December 31, 2029 $15,000
January 1, 2030 – December 31, 2030 $15,000
Option Years Subtotal $75,000
TOTAL $195,000
STATE OF MICHIGAN
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 17 to
Contract Number 071B1300154
Various
Jarrod Barron dromig@forensicadvantage.com
David Romig
Midlothian, VA 23113
THE COMPUTER SOLUTION COMPANY OF VA INC.
CV0059413
804-794-3491
1525 Hugeunot Road
(517) 249-0406 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
barronj1@michigan.gov
$2,266,711.41
January 1, 2011 December 31, 2025
LABORATORY CASE MANAGEMENT SYSTEM
December 31, 2015
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
☐ ☐ December 31, 2025
CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE
$146,925.00 $2,413,636.41
Effective 6/20/2023, the parties add $146,925.00 for the worksheets conversion services detailed in the attached statement of work. All other terms, conditions, specifications, and pricing remain the same. Per Contractor, Agency, DTMB Central Procurement and State Administrative Board approval.
Remaining Ad Board funds after this CN: $749,999.99
INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE
DESCRIPTION
CONTRACT SUMMARY
MSP
AGENCY NAME PHONE EMAIL
Multi-Agency and Statewide Contracts
Program Managers for
CHANGE NOTICE NO. 17 TO CONTRACT NO. 071B1300154
John Bowen 517-284-3486 BowenJ1@michigan.govMSP
Jim Coggin 517-243-5265 cogginj@michigan.govDTMB
MICHIGAN DEPARTMENT OF TECHNOLOGY,
MANAGEMENT AND BUDGET
IT SERVICES
STATEMENT OF WORK
Project Title:
Worksheets, Phase II
Period of Coverage:
Requesting Department:
Date:
Agency Project Manager:
Insp. John Bowen
Phone:
517-512-5144
DTMB Project Manager:
Phone:
PROJECT OBJECTIVE:
The Michigan State Police (MSP) requests the continued Creation of Worksheets, Lab Report, and Metric Report worksheets in FAS's Crime Lab system (LIMS). This is a continuation of the work started in Change Notice 15 of Contract Number 071B1300154.
SCOPE OF WORK:
The scope of the project is for the conversion of worksheets. The contractor will provide the following services:
All Professional Services will be provided remotely and provided during business hours 8 am EST to 5 pm
EST
• Project Management
• Project Kick off
• Review and Execute the Creation of Worksheets, Lab Report, and Metric Report as outlined in the
Phase II Documents zip file, which the parties incorporate herein by reference.
Worksheet design mockup, Design, Print Preview, and Logic Coding:
o Trace Evidence o Toxicology Drugs o CODIS o Questioned Documents o Crime Scene o Blood Pattern Analysis o Polygraph o “Not Analyzed” Cases
Creation of Lab Report Summary Activities, including Specification, XSLT Conversion to SQL, Template, Validation, and Installation:
o Firearms o Blood Alcohol o Latent Prints o Controlled Substance
Metric Reports Summary Activities, including DataMiner, WSExtract, and Latent Report development as follows:
o Specification o Development o Validation o Installation
• Description of Metric Reports Work o Review and Plan how DataMiner functions (XSLT/SSRS reports) o Review the .NET code for DataMiner o Verify worksheet fields are being collected o Verify fields for the Submission by Agency report are being collected.
o Determine any calculations being performed in the worksheets o Identify method for seamless transition between both reporting requirements o Review how WSExtract functions (XSLT/SSRS reports) o Review the .NET code for DataMiner o Verify worksheet fields are being collected o Identify any calculations being performed in the worksheets o Identify method for seamless transition between both reporting requirements o Development o Create new DataMiner report procedures and associated SQL job to drop data in the existing tables to use existing reports o Create new WSExtract report procedures and associated SQL job to drop data in the existing tables to use existing reports o Create new/update procedures for the SSRS Latent Report.
o In the controlled substance discipline.
o Close the project
PROJECT ASSUMPTIONS AND CONDITIONS:
o MSP will have to be running Forensic Advantage v20.0 or above o MSP will be responsible for the installation of the SSRS Report Designer on the Production
Report server o MSP will be responsible for providing the Stage environment for installation and testing of
Worksheets and Reports o Estimate includes work required for Trace Evidence, Toxicology Drugs, CODIS, Questioned
Documents, Crime Scene, Blood Pattern Analysis, Polygraph, Not Analyzed. Worksheets and Reports based on review of MSP Crime Lab requested features. Documents reviewed are included as zip file provided with this scope of work. Further requests or changes in addition to those agreed upon within attached zip file will require a change order. Further requests or changes in addition to this Attachment may require a contract change notice.
DELIVERABLES:
Deliverables will not be considered complete until the DTMB and Agency Project Managers have formally accepted them. Deliverables for this project include:
Task Task Name Deliverable(s)
Task 0 Project Management • Ongoing Project Management Task 1 Project Initiation/Kickoff Meeting • Kickoff Meeting Minutes and Next steps Task 2 Worksheets & Report Review • Worksheets Approval Forms
• Reports Approval Document Task 3 Worksheets & Report Execution • Worksheets & Reports Completion
• Assistance to MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout of all worksheets and reports into production
Task 4 Closing Task • Certificate of Completion Delivery
PROJECT PHASES & RESPONSIBILITIES:
PROJECT MANAGEMENT PHASE
Task 0: Project Management FAS State Provide oversight, definition, tracking, and guidance to ensure successful delivery of the State's project following this SOW.
X
Schedule all FAS staff and subcontractor (if any) support to ensure project progress and completion following the project schedule.
Manage the expectations of the Stakeholder Management Team (herein defined as key State representatives, sponsors, stewards, third parties, and others), project team, end-users, and the general public regarding the tasks to be completed on the project.
Coordinate and facilitate all State staff and third-party (vendors and/or agencies) support to ensure project progress and completion following the SOW and project schedule.
Review and Manage Payment Terms X X Deliverables: 1. Provide Definition and Tracking
2. Review and Manage Payment Terms
INITIATE AND ENVISION PHASE
Task 1: Project Kickoff Meeting FAS State State and FAS will conduct a kickoff meeting. The objective of this meeting will be to scope, timeline, and the following upcoming activities for the project.
Kickoff is not to be delayed more than 30 days from contract signing unless mutually agreed.
Establish a clear chain of communication, escalation, and authority. X X Deliverables: 1. Kickoff Meeting Minutes and Next steps
PLANNING PHASE
EXECUTION PHASE
Task 3: Worksheets & Reports Execution FAS State During this task, FAS will execute the work for the worksheets and reports as agreed in in the approval forms and documents: Worksheet & Report Review – this work will occur in the Stage Environment.
The State will support this activity by being available for any questions and/or follow-ups needed.
At delivery of the worksheets and reports that will have different timelines according to a schedule, State will test the deliverables and provide any feedback in ten (10) business days unless otherwise agreed. FAS will follow the same timeline as needed.
FAS will make corrections and resubmit for testing in ten (10) business days unless otherwise agreed.
FAS will assist MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout all worksheets and reports
Deliverables: 1. Worksheets & Reports Completion in Stage 2. FAS will assist MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout of all worksheets and reports – rollout to production will not prevent this task completion.
Task 2: Worksheets & Report Review FAS State During this task, FAS will work with State to review and validate the activities to complete for the conversion of worksheets. This will include:
• Analyze and detail the configurations for the Worksheets (screens accessed by analysts) and mockup of the worksheet(s) in pdf format based on the rough sketch provided by State. Mockup imitates provided rough sketch and resembles closest to how the worksheet will look once the design is completed, basically creating a blueprint for the appropriate worksheets. (FAS)
• FAS provides logic documentation based on the result statements provided.
• After reviewing the mockup (including edits), State approves the design by signing Worksheet Design Acceptance Form. See Attachment A.
After completing the prior task, State provides a list of result statements (canned statements) that need to be generated from data entered to the worksheet and instructions on what field triggers those statements.
During this task, FAS will work with State to review and agree to the scope of the needed reports. They will be documented in an encompassing Report Approval Document for State Approval.
After the prior task is completed, State approves the Report Approval Document. X Deliverables: 1. Worksheet Design Acceptance Forms (Wireframes)
2. Reports Approval Document
STABILIZING PHASE
Task 4: Closing Tasks FAS State
Execution of a Certificate of Completion (COD): FAS will deliver a certificate of delivery for the Scope of Work completed. Any worksheets and/or reports to move to production by the State will not prevent the closure and invoicing of this project.
Deliverables: Certificate of Completion Delivery
ACCEPTANCE CRITERIA:
Acceptance criteria for the deliverables include:
• Worksheets for the Trace Evidence, Toxicology Drugs, CODIS, Questioned Documents, Crime Scene, Blood Pattern Analysis, Polygraph, Not Analyzed are confirmed to be functioning as required by the FSD SME staff for those areas.
• The worksheet results are exported to the results of analysis report and pass review by the FSD SME staff.
• The worksheet publishes without error and generates a PDF copy stored within the Object Repository in FA.
• The management/metrics reports affected by the updated worksheets are confirmed to run and return accurate data.:
PROJECT CONTROL AND REPORTS:
A bi-weekly progress report must be submitted to the Agency and DTMB Project Managers throughout the life of this project. This report may be submitted with the billing invoice. Each bi-weekly progress report must contain the following:
• Accomplishments: Indicate what was worked on and what was completed during the current reporting period.
• Funds: Indicate the amount of funds expended during the current reporting period, and the cumulative total to date for the project.
SPECIFIC DEPARTMENT STANDARDS:
Agency standards, if any, in addition to DTMB standards.
PAYMENT SCHEDULE:
The contractor may invoice State following the table below, adhering to the invoicing process detailed in the Contract terms.
Payment Task Number and Name Amount Payment 1 Upon completion of of the Project Kickoff Meeting $44,078 Payment 2 Upon the approval of the Worksheet forms (Wireframes) and approval of the Reports $37,731
Payment 3 Upon Installation of the Worksheets and Reports into the MSP STAGE environment
$29,385
Payment 4 Upon installation into the PROD environment $36,731
Total $146,925
EXPENSES:
There is NO travel included in this project. Therefore, there is no expectation for the State to pay for any travel expenses, including hotel, mileage, meals, parking, etc.
PROJECT CONTACTS:
The designated Contractor contacts are:
ROLE RESPONSIBILITIES POC(s) Contact Information
Project Executive Sponsor
Escalation point for issues that arise beyond the project level • Director of
Operations
Nellie De Los Santos ndelossanto@forensicadvantag e.com
Manager
The project manager will be the primary point of contact and responsible for the management of this SOW and associated FAS Deliverables
Project Manager Rubin Rajkarnikar rrajkarnikar@forensicadvantag e.com
Sales Executive The sales executive will be the point of contact for any questions about the sale and future change orders
Sales Executive Brent Smith BSmith@forensicadvantage.com
Technical Services Team
The Technical Team is responsible for data migrations, Software, Interface Installation, and Deployments.
Technical Team Rubin Rajkarnikar rrajkarnikar@forensicadvantage.
com Scott Cromwell Scromwell@Forensicadvantage.c om
Application Consultant /Business Systems Analyst Team
Through the implementation, Application Consultants and/or Business Systems Analyst will be assigned to review existing processes and consult on how to best implement the systems in Operations; this includes reviewing current practices, data, and/or internal procedures. This team will also be the team that will provide training and cutover support on the applications being deployed
Application Consultants/ Business Systems Analyst
Karen Keller kkeller@cforensicadvantage.com mailto:ndelossanto@forensicadvantage.com mailto:ndelossanto@forensicadvantage.com mailto:rrajkarnikar@forensicadvantage.com mailto:rrajkarnikar@forensicadvantage.com mailto:BSmith@forensicadvantage.com mailto:Scromwell@Forensicadvantage.com mailto:Scromwell@Forensicadvantage.com mailto:kkeller@cforensicadvantage.com
Customer Success Team
Following go-live, you will be assigned a FAS Customer Success Manager who will be your "go- to" resource for questions, issues, additional training, and onsite support as required.
Director of Operations
Customer Success
Nellie De Los Santos ndelossanto@forensicadvantag e.com
Lori Ohrt LOhrt@forensicadvantage.com
The designated Agency Program Manager is:
Wayne Williams Forensic Science Division - Administration MSP Lansing Laboratory 7320 N. Canal Rd. Lansing, MI 48823 517-242-2778 WilliamsW6@michigan.gov
The designated DTMB Program Manager is:
To be determined
LOCATION OF WHERE THE WORK IS TO BE PERFORMED:
Contractor staff will work remotely.
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 Eastern Time are to be observed unless otherwise agreed to in writing.
HARDWARE
Not Applicable – No hardware is needed for this project.
mailto:ndelossanto@forensicadvantage.com mailto:ndelossanto@forensicadvantage.com mailto:LOhrt@forensicadvantage.com mailto:WilliamsW6@michigan.gov
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 16 to
071B1300154Contract Number
Various
Jarrod Barron dromig@forensicadvantage.com
David Romig
Midlothian, VA 23113
THE COMPUTER SOLUTION COMPANY OF VA INC.
CV0059413
804-794-3491
1525 Hugeunot Road
(517) 249-0406 S
T A
T E
P ro g 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
barronj1@michigan.gov
$2,064,065.35
January 1, 2011 December 31, 2025
LABORATORY CASE MANAGEMENT SYSTEM
December 31, 2015
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
☐ ☐ December 31, 2025
CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE
$202,646.06 $2,266,711.41
Effective 12/16/2022, the parties add $202,646.06: $79,776.30 for the BrAD Module Maintenance costs detailed in the attached cost tables and $122,869.76 for the CMI 9000 instrument data interface services detailed in the attached statement of work. All other terms, conditions, specifications, and pricing remain the same. Per Contractor, Agency, and DTMB Central Procurement approval.
INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE
DESCRIPTION
Program Managers for
CHANGE NOTICE NO. 16 TO CONTRACT NO. 071B1300154
Gordon Mayes 517-204-8026 MayesG1@michigan.govDTMB
Contract Change Notice 16 Costs
BrAD Module Maintenance
BrAD Interface SOW & Maint.
PROJECT 78,390.00
MAINT.
FY2023 4,658.00
FY2024 4,890.90
FY2025 5,135.45
FY2026 14,437.50 5,392.22
FY2027 15,159.38 5,661.83
FY2028 15,917.34 5,944.92
FY2029 16,713.21 6,242.17
FY2030 17,548.87 6,554.27
TOTAL $79,776.30 $122,869.76 $202,646.06
CMI 9000 Instrument data Interface for FA BrAD Software
Phone:
517-512-5144
DTMB Project Manager:
Anwar Raja
734-377-4494
BACKGROUND:
The Michigan State Police (MSP) is legislatively mandated to manage the fleet of breath alcohol measurement devices which are deployed in county jails and other locations around the State. These instruments need regular maintenance, service, and related record-keeping to meet legal requirements and assist in the investigation of drunk driving complaints. MSP employs the Forensic Advantage Systems (FAS) Breath Alcohol Database application (BrAD) to track and store records from deployed breath alcohol instruments.
MSP has engaged in the purchase of a new model of Breath Alcohol Instrument, namely the CMI 9000.
This instrument will be deployed around the state as a replacement for the current Intoxylizer instrument.
For this, a new software Interface between the CMI 9000 and the FA BrAD software is needed.
PROJECT OBJECTIVE:
Develop and deploy the FA BrAD Publish Utility, customized for the CMI I9000 Cobra V5 data import interface. Integrate the FA BrAD software with the new instruments as they are deployed statewide.
SCOPE OF WORK:
The scope of the project is for the development and deployment of the CMI I9000 Cobra V5 data import interface. This interface will provide an efficient way to transfer data from the CMI Cobra V5 software to the BrAD software/database.
Contractor will provide the following products:
Products Forensic Advantage® Breath Alcohol Database application (BrAD)
Interfaces, Ancillaries and/or Custom work included on this project Import CMI 9000 Instrument data exported from the instrument via CMI Cobra V5.
Professional Services include the following – remote unless otherwise noted: When on-site, the services will be provided during business hours 8 A.M. EST to 5 P.M. EST
• Project Kick off and Business process review
• Configuration services for:
o Instruments, Resources, Service Tickets & Trouble Calls for CMI I9000’s
• Stage the following environments:
o Deployment/Stage o Testing o Production
• Data Loading for: (This will be limited to a one time loading with the expectation that Michigan will maintain the data after the 1st loading of the data) o Initial Test Instruments and Instrument Resources
• Develop interface with CMI I-9000 instrument via CMI Cobra V5 instrument communication service; this development is limited to:
o Import CMI I9000 data from the CMI Cobra V5 instrument communication service.
• Initial report development over CMI I9000 data - 5 reports included. (Any other reports will require a change order).
• System training CMI I9000 implementation; limited to:
o Training- Train the Trainer (1 day, 8 users max)
• Deployment of FA BrAD Solution o Deployment to Stage Environment o Deployment to Testing Environment o Testing and remediation following deployment
• Production Cutover Preparation, Cutover and Support up to one business (1) day during business hours.
• Closing Tasks.
Details for all tasks are described below in “PROJECT PHASES AND RESPONSIBILITIES”.
PROJECT CONDITIONS:
The State may elect not to move the system to production once FAS completes the installation into Stage and the Staging system is operational. If the move to production does not occur three (3) months after FAS has completed all tasks listed above except for the Cutover and Closing Tasks; two actions can occur:
1. FAS will discuss with DTMB additional project management services to support timeline extension and execute a Contract Change Notice OR
2. FAS will execute the Certificate of Delivery and will close the project deeming all deliverables accepted and will collect all payments; with the commitment that when DTMB is ready to put the application into production, remote support will be provided up to 1 day. This option may only occur after the State has formally approved the deliverables .
LOCATION OF WHERE THE WORK IS TO BE PERFORMED:
Contractor staff will work remotely.
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.
DELIVERABLES:
Deliverables will not be considered complete until the Agency Project Manager has formally accepted them. Deliverables for this project include:
Task 0 Project Management 1. Ongoing Project Management
Task 1 Project Initiation/Kickoff Meeting 2. Kickoff Meeting and Next steps
3. Establishment of Core Team
4. Project Schedule
5. Business Process Review
Task 2 Project Requirements Review, Configuration Process and Review of Conversion
6. Configuration document, reports, and one-time upload approvals
Task 3 Stage, Configuration and
Integration of BrAD
7. Install and Configure Application.
8. Completion of Reports
9. Data Migration
Task 4 Interfaces 10. Installed Interfaces (in Stage) Task 5 Training 11. Training Program Completed Task 6 Go-Live 12. Cutover Readiness Plan
13. Application(s) placed in production use Task 7 Closing Task 14. Certificate of Completion Delivery
PROJECT PHASES & RESPONSBILITIES:
Provide oversight, definition, tracking, and guidance of the project to ensure successful delivery of the State’s project in accordance with this SOW.
Enforce and administer the Agreement and SOW inclusive of any project change orders and invoices.
X
Schedule all FAS staff and subcontractor (if any) support to ensure project progress and completion in accordance with the project schedule.
Manage the expectations of the Stakeholder Management Team, (herein defined as key State representatives, sponsors, stewards, third parties, and others), project team, end users, and general public regarding the tasks to be completed on the project.
Coordinate and facilitate all State staff and third party (vendors and/or agencies) support to ensure project progress and completion in accordance with the SOW and project schedule.
Review and Manage Payment Terms in accordance with Attachment A. Milestone Payment Terms
X X
Deliverables: Ongoing Project Management
Task 1: Project Initiation/Kickoff Meeting FAS State State and FAS will conduct kickoff meeting according to agreed agenda. Kickoff is not to be delayed more than 30 days from contract signing unless mutually agreed.
Conduct a formal review of the signed agreement and business process review. Any deviations from the signed SOW will be handled via Change Order.
Establish a State Core Team that will be able to participate during the project in accordance to the schedule and be able to make decisions on behalf of State on how the system is to be set up, used, trained and deployed. This team should also have the capability to bring other staff as needed for a particular skill need.
Review the process, agenda, resource, and scheduling requirements for the next upcoming activities for the project.
X X
Agree to the proposed Project Schedule. All Dates and Resources are subject to change based on State’s and FAS availability. X X
Deliverables: 1. Kickoff Meeting and Next steps 2. Establishment of Core Team 3. Project Schedule 4. Business Process Review
Task 2: Project Requirements Review, Configuration Process and Review of Conversion FAS State
FAS will perform a walkthrough of BrAD and collect configuration information for:
o CMI I9000 Test Instruments, Resources, Service Tickets & Trouble Calls
FAS will work with the State to define report requirements and obtain approval of five custom reports to be provided by FAS
X X
FAS will work with the State to plan the provision of a one-time successful upload of the data and will obtain approval.
• CMI I9000 Test Instrument Resources
State’s Core Team and/or appropriate staff will review the configuration document, reports and one-time upload and will provide approval in accordance to an agreed timeline.
Deliverables: 1. Configuration document, reports and one-time upload approvals
Task 3: Stage, Configuration and Integration of BrAD FAS State
FAS will Stage the following environments:
o Deployment o Testing o Production
• FAS will configure and stage BrAD in the Configuration services for:
o CMI I9000 Test Instruments, Resources, Service Tickets & Trouble Calls in accordance with what is agreed in Task 3.
FAS will complete the reports in accordance with what is agreed in Task 3. X
FAS will perform the one-time upload of data in accordance with what is agreed in Task 3. X
FAS will provide a PDF Import capability into the CMI Communication Service
X
FAS will provide the latest Administration and User Guide documentation for BrAD
Deliverables: 1. Install and Configure Application. 2. Completion of Reports 3. Data Migration
Task 4: Interfaces FAS State FAS will develop an interface with new CMI I9000’s via CMI Cobra v5 communication service this development is limited to the scope described in section 3.
Take ownership and responsibility for all interface hardware, software licenses, modifications, or additions to any systems not supplied, installed, tested, or licensed by FAS. Any delays to the Project, however caused, will necessarily push the timeline for completion of this particular task out, and therefore, will require a Change Order for a project extension.
Act as the single point of contact between agencies and/or third party vendors not contracted to FAS but required to support all interfaces.
Provide FAS with the physical connections for each interface, to allow FAS to test the functionality of each interface at the time of software installation. If the interfaces are currently in operation, it is the
State’s responsibility to disconnect each of the interfaces from the operational environment to facilitate interface testing.
Deliverables: 1. Installed Interfaces in Stage
Task 5: Training FAS State
FAS will provide training as follows:
• Training- Train the Trainer on CMI I9000 | FA BrAD interface (1 day, 8 users max)
State will be responsible for staff training X
Deliverables: Training Program Completed
Task 6: Go-Live FAS State
FAS will work with the State to create a cutover readiness for operational use of the system.
Execute a go/no-go meeting with the Agency in conformance with the project schedule against the Cutover Readiness Plan. X X
Bring products to operational use and monitor the products, ancillaries, and interfaces up to three (3) days remote (cutover hours will be during State’s business hours unless otherwise agreed in the Implementation Plan) this includes the preparation day. Any Cutover delays resulting from or related to State cause shall be supported via remote access rather than onsite.
At Cutover, begin using the products and notify FAS of any issues in accordance with the Cutover Readiness Plan.
Deliverables: 1. Cutover Readiness Plan 2. Application(s) placed in production use
Task 7: Closing Tasks FAS State Turnover Meeting: Arrange and perform a turnover meeting to review the Project and any open issues as outlined on a turnover document with the State, and FAS Success Manager
Execution of a Certificate of Completion (COD): FAS will deliver a certificate of delivery that will list that all components in Section 3 has been installed, trained and cutover unless otherwise noted via change orders. This COD will serve as the Agency’s sign off and acceptance of the project. This certificate will be sent to State/Agency with a request to highlight any exceptions and/or disagreement from completion in five
(5) Business Days from delivery of the COD. If FAS does not receive any sign off and/or notifications from State/Agency the project will deemed accepted and close after such five (5) Business Days.
PAYMENT SCHEDULE:
Contractor may invoice State in accordance to the table below. 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 the DTMB within forty-five (45) days after receipt of properly completed invoices.
Payment Task Number and Name Amount Payment 1 Upon completion of project Kickoff meeting and Business
Process Review to occur within 30 days from contract signing $39,195
Payment 2 Upon Completion of 1st Software product and\or interface installation on State Stage environment
$31,356
Payment 3 At Go-Live, or no later than 180 days after Payment number 2, whichever is less
$7,839
Project Total $78,390
Dates CMI Interface Maintenance Amount Year 1 Year 1 Maintenance period will start with completed installation of the product in the stage environment. $4,658.00 Year 2 Year 2 Maintenance will start at conclusion of year 1. $4,890.90 Year 3 Year 3 Maintenance will start at conclusion of year 2. $5,135.45 Year 4 Year 4 Maintenance will start at conclusion of year 3. $5,392.22 Year 5 Year 5 Maintenance will start at conclusion of year 4. $5,661.83 Year 6 Year 6 Maintenance will start at conclusion of year 5. $5,944.92 Year 7 Year 7 Maintenance will start at conclusion of year 6. $6,242.17 Year 8 Year 8 Maintenance will start at conclusion of year 7. $6,554.27 Maintenance Total $44,479.76
Project $78,390 Maintenance $44,479.76 Statement of Work Total 122,869.76
The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.
HARDWARE:
FA BrAD implements a form of Service Oriented Architecture operating on a Windows 10 client, Windows 2016 or later application server with access to a Microsoft SQL Server database. FA BrAD does not require exclusive access to these hardware resources.
FUNCTIONALITY CHANGES:
This project will deliver a set of products including:
• FA BrAD version 20.2 or later
• FA BrAD Publish Utility with the customized to CMI I9000 Cobra V5 data import interface
Such products will not be customized, modified, altered, added, or changed by FAS at the State’s request other than as specifically identified and priced in this statement of work or subsequently issued Contract Change Notice.
PROJECT CONTROL AND REPORTS:
A bi-weekly progress report must be submitted to the Agency and DTMB Project Managers throughout the life of this project. This report may be submitted with the billing invoice. Each bi-weekly progress report must contain the following:
1. Accomplishments: Indicate what was worked on and what was completed during the current reporting period.
SPECIFIC DEPARTMENT STANDARDS:
Agency standards, if any, in addition to DTMB standards.
EXPENSES:
The State will NOT pay for any travel expenses, including hotel, mileage, meals, parking, etc.
Project Executive Sponsor
Escalation point for issues that arise beyond the project level
Vice-President – Forensic Advantage
Director – Operations
David Romig, II dromig@forensicadvantage.com
Nellie De Los Santos ndelossantos@harriscomputer.com
Project Manager The project manager will be the primary point of contact and responsible for the management of this SOW and associated FAS Deliverables
Project Manager Michael Sturgeon MSturgeon@harriscomputer.com
Sales Executive The sales executive will be the point of contact for any questions about the sale and future change orders
Sales Executive
Brent Smith BSmith@forensicadvantage.com
Technical Services Team
The Technical Team is responsible for data migrations, Software, Interface Installation, and Deployments.
Technical Team
Dave Romig Sr.
dromig2@forensicadvantage.com Rick Matherly Rmatherly@Forensicadvantage.com
Application Consultant /Business Systems Analyst Team
Through the implementation, Application Consultants and/or Business Systems Analyst will be assigned to review existing processes and consult in how to best implement the systems in Operations; this includes review of current practices, data, and/or internal processes. This team will also be the team that will provide training and cutover support on the applications being deployed
Application Consultants/ Business Systems Analyst
Karen Keller kkeller@cforensicadvantage.com mailto:dromig@forensicadvantage.com mailto:ndelossantos@harriscomputer.com mailto:MSturgeon@harriscomputer.com mailto:BSmith@forensicadvantage.com mailto:dromig2@caliberpublicsafety.com mailto:Rmatherly@Forensicadvantage.com
State Support Services Team
Following go-live, you will be assigned a FAS Customer Success Manager who will be your “go-to” resource for questions, issues, additional training, and onsite support as required. While you are always free to call our main Customer support number, your Customer Success Manager will serve as a direct resource to support your day-to-day FAS needs.
Director – Operations
Customer Success
Nellie De Los Santos ndelossantos@harriscomputer.com
Lori Ohrt lohrt@caliberpublicsafety.com
Michigan State Police Forensic Science Division - Administration MSP Lansing Laboratory 7320 N. Canal Rd.
Lansing, MI 48823 517-512-5144 517-636-4470 bowenj1@michigan.gov
Anwar Raja Department of Technology, Management & Budget
RajaA1@michigan.gov mailto:ndelossantos@harriscomputer.com mailto:lohrt@caliberpublicsafety.com
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 15 to
071B1300154Contract Number
Various
Jarrod Barron david.romig@thincit.com
David Romig
Midlothian, VA 23113
THE COMPUTER SOLUTION COMPANY OF VA INC.
CV0059413
804-794-3491
1525 Hugeunot Road
(517) 249-0406 S
T A
T E
P ro g 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
barronj1@michigan.gov
$1,902,965.35
January 1, 2011 December 31, 2025
LABORATORY CASE MANAGEMENT SYSTEM
December 31, 2015
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
☐ ☐ December 31, 2025
CURRENT VALUE VALUE OF CHANGE NOTICE ESTIMATED AGGREGATE CONTRACT VALUE
$161,100.00 $2,064,065.35
Effective 5/6/2022, the parties add $161,100.00 for the worksheets conversion services detailed in the attached statement of work. All other terms, conditions, specifications, and pricing remain the same. Per Contractor, Agency, and DTMB Central Procurement approval.
Internal State Note: $177,719.64 remaining Ad Board funds after this CN.
INITIAL EXPIRATION DATEINITIAL EFFECTIVE DATE
DESCRIPTION
Program Managers for
CHANGE NOTICE NO. 15 TO CONTRACT NO. 071B1300154
MICHIGAN DEPARTMENT OF TECHNOLOGY, MANAGEMENT AND BUDGET IT SERVICES (DTMB)
CALIBER PUBLIC SAFETY|FORENSIC ADVANTAGE
Worksheets
Phone:
517-284-3486
DTMB Project Manager:
Anwar Raja
Phone:
Quote Reference: #Q02841 dated 01/18/22
PROJECT OBJECTIVE:
The Michigan State Police (MSP) requests the Creation of Worksheets, Lab Report, and Metric Report worksheets in FAS's Crime Lab system (LIMS).
SCOPE OF WORK:
The scope of the project is for the conversion of worksheets. The contractor will provide the following services:
All Professional Services will be provided remotely and provided during business hours 8 am EST to 5 pm EST
• Project Management
• Project Kick off
• Review and Execute the Creation of Worksheets, Lab Report, and Metric Report as outlined in
Attachment A. Summary Worksheet, Lab Report, and Metric Report activities for:
Worksheets:
o Firearms o Blood Alcohol o Latent Prints Processing o Latent Prints ACE with Processing o Controlled Substance
Creation of Lab Reports associated with worksheet changes in:
o Firearms
Statement of Work for Michigan State Police Crime Lab | Worksheet Conversion Quote: Q02841 dated 2022-01-18 o Blood Alcohol o Latent Prints o Controlled Substance
Creation of Metric Reports associated with worksheet changes in:
o Firearms o Blood Alcohol o Latent Prints o Controlled Substance
• Assist MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline
• Close the project
PROJECT ASSUMPTIONS AND CONDITIONS:
• MSP will have to be running Forensic Advantage v20.0 or above
• MSP will be responsible for the installation of the SSRS Report Designer on the Production
Report server
• MSP will be responsible for providing the Stage environment for installation and testing of
Worksheets and Reports
• Estimate includes work required for Firearms, Blood Alcohol, Latent Print – Processing, Latent
Print – ACE and Processing and Controlled Substance Worksheets and Reports based on a review of MSP Crime Lab requested features following Attachment A. Summary Worksheet, Lab Report, and Metric Report activities. Further requests or changes in addition to this Attachment may require a contract change notice.
• This project does not include:
o RTI reporting interface o Submission by Agency Report (see ticket 404520 for further information)
Deliverables will not be considered complete until the DTMB and Agency Project Managers have both formally accepted them. Deliverables for this project include:
Task 1 Project Initiation/Kickoff Meeting 2. Kickoff Meeting Minutes and Next steps Task 2 Worksheets & Report Review 3. Worksheets Approval Forms
4. Reports Approval Document Task 3 Worksheets & Report Execution 5. Worksheets & Reports Completion
6. Assistance to MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout of all worksheets and reports into production
Task 4 Closing Task 7. Certificate of Completion Delivery
PROJECT PHASES & RESPONSIBILITIES:
Provide oversight, definition, tracking, and guidance to ensure successful delivery of the State's project following this SOW.
Schedule all FAS staff and subcontractor (if any) support to ensure project progress and completion following the project schedule.
Manage the expectations of the Stakeholder Management Team (herein defined as key State representatives, sponsors, stewards, third parties, and others), project team, end-users, and the general public regarding the tasks to be completed on the project.
Coordinate and facilitate all State staff and third-party (vendors and/or agencies) support to ensure project progress and completion following the SOW and project schedule.
Review and Manage Payment Terms X X
INITIATE AND ENVISION PHASE
Task 1: Project Kickoff Meeting FAS State State and FAS will conduct a kickoff meeting. The objective of this meeting will be to scope, timeline, and the following upcoming activities for the project.
Kickoff is not to be delayed more than 30 days from contract signing unless mutually agreed.
Deliverables: 1. Kickoff Meeting Minutes and Next steps
During this task, FAS will work with State to review and validate the activities to complete for the conversion of worksheets according to Attachment A. Summary Worksheet, Lab Report, and Metric Report activities. This will include:
• Analyze and detail the configurations for the Worksheets (screens accessed by analysts) and mockup of the worksheet(s) in pdf format based on the rough sketch provided by State. Mockup imitates provided rough sketch and resembles closest to how the worksheet will look once the design is completed, basically creating a blueprint for the appropriate worksheets. (FAS)
• FAS provides logic documentation based on the result statements provided.
• After reviewing the mockup (including edits), State approves the design by signing Worksheet Acceptance Form. Attachment B. Worksheet Design Acceptance Form
After completing the prior task, State provides a list of result statements (canned statements) that need to be generated from data entered to the worksheet and instructions on what field triggers those statements.
After reviewing the logic documentation (including edits), State approves the logic documentation by signing Worksheet Logic Acceptance Form. Attachment C.
Worksheet Logic Approval Form
X
During this task, FAS will work with State to review and agree to the scope of the needed reports following Attachment A – Worksheets Activities Summary. They will be documented in an encompassing Report Approval Document for State Approval.
X X
After the prior task is completed, State approves the Report Approval Document. X
Deliverables: 1. Worksheets Approval Forms (Wireframes)
2. Reports Approval Document
EXECUTION PHASE
Task 3: Worksheets & Reports Execution FAS State During this task, FAS will execute the work for the worksheets and reports as agreed in Task 2: Worksheet & Report Review – this work will occur in the Stage Environment.
X X
The State will support this activity by being available for any questions and/or follow-ups needed.
X
At delivery of the worksheets and reports that will have different timelines according to a schedule, State will test the deliverables and provide any feedback in ten (10) business days unless otherwise agreed. FAS will follow the same timeline as needed.
X
FAS will make corrections and resubmit for testing in ten (10) business days unless otherwise agreed.
X
FAS will assist MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout all worksheets and reports
X X
Deliverables: 1. Worksheets & Reports Completion in Stage 2. FAS will assist MSP LIMS Administrator and SME in setting up Resource Manager in Controlled Substance Discipline and rollout of all worksheets and reports – rollout to production will not prevent this task completion.
Task 4: Closing Tasks FAS Sta te
Execution of a Certificate of Completion (COD): FAS will deliver a certificate of delivery for the Scope of Work completed. Any worksheets and/or reports to move to production by the State will not prevent the closure and invoicing of this project.
X X
Deliverables: Certificate of Completion Delivery
ACCEPTANCE CRITERIA:
Acceptance criteria for the deliverables include:
1. Worksheets for the Firearms, Blood Alcohol, Latent Print – Processing, Latent Print – ACE and Controlled Substances are confirmed to be functioning as required by the FSD SME staff for those areas.
2. The worksheet results are exported to the results of analysis report and pass review by the FSD SME staff.
3. The worksheet publishes without error and generates a PDF copy stored within the Object Repository in FA.
4. The management/metrics reports affected by the updated worksheets are confirmed to run and return accurate data.
PROJECT CONTROL AND REPORTS:
A bi-weekly progress report must be submitted to the Agency and DTMB Project Managers throughout the life of this project. This report may be submitted with the billing invoice. Each bi-weekly progress report must contain the following:
1. Accomplishments: Indicate what was worked on and completed during the current
The contractor may invoice State following the table below. DTMB will pay CONTRACTOR upon State’s formal acceptance of deliverables as stated below and 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 the payment date and approved by the Agency and DTMB Project Manager prior to payment. The invoices shall describe and document a description of the work performed, the project's progress, and fees to the State's satisfaction. 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 the DTMB within forty-five (45) days after receipt of properly completed invoices.
Payment Task Number and Name Amount Payment 1 Upon completion of Task 1 $30,000 Payment 2 Acceptance of Task 2 Deliverables $62587 Payment 3 Acceptance of Task 3 Deliverables. Worksheets & Reports
Review $52313
Payment 4 Acceptance of Task 4 Deliverables. Worksheets & Reports Execution into production.
$16,200
Total $161,100
There is NO travel included in this project. Therefore, there is no expectation for the State to pay for any travel expenses, including hotel, mileage, meals, parking, etc.
Executive Sponsor
Escalation point for issues that arise beyond the project level
• Vice-President of Professional Services
• Professional
Services Director
Diva Mayeau dmayeau@caliberpublicsafety.co m
Chad Brymer cbrymer@caliberpublicsafety.co m
Project Manager
The project manager will be the primary point of contact and responsible for the management of this SOW and associated FAS Deliverables
Project Manager Darren Hibbard jhibbard@caliberpublicsafety.co
Sales Executive The sales executive will be the point of contact for any questions about the sale and
Technical Services Team
The Technical Team is responsible for data migrations, Software, Interface Installation, and Deployments.
Rubin Rajkarnikar rrajkarnikar@forensicadvantage.
com Scott Cromwell Scromwell@Forensicadvantage.c om
Application Consultant /Business Systems Analyst Team
Through the implementation, Application Consultants and/or Business Systems Analyst will be assigned to review existing processes and consult on how to best implement the systems in Operations; this includes reviewing current practices, data, and/or internal procedures. This team will also be the team that will provide training and cutover support on the applications being deployed
Application Consultants/ Business Systems Analyst
State Support
Following go-live, you will be assigned a FAS State Success Manager who will be your "go-to" resource for questions, issues, additional training, and onsite support as required.
Vice-President of State Support
State Success Manager
Derek Smith dsmith@caliberpublicsafety.com
TBD
mailto:dmayeau@caliberpublicsafety.com mailto:dmayeau@caliberpublicsafety.com mailto:cbrymer@caliberpublicsafety.com mailto:cbrymer@caliberpublicsafety.com mailto:jhibbard@caliberpublicsafety.com mailto:jhibbard@caliberpublicsafety.com mailto:BSmith@forensicadvantage.com mailto:rrajkarnikar@ mailto:Scromwell@Forensicadvantage.com mailto:Scromwell@Forensicadvantage.com mailto:dsmith@caliberpublicsafety.com
While you are always free to call our main State support number, your State Success Manager will serve as a direct resource to support your day-to-day FAS needs.
Wayne Williams Forensic Science Division - Administration MSP Lansing Laboratory 7320 N. Canal Rd.
Lansing, MI 48823 517-242-2778 WilliamsW6@michigan.gov
To be determined
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 Eastern Time are to be observed unless otherwise agreed to in writing.
Not Applicable – No hardware is needed for this project.
Attachment A – Summary Worksheet, Lab Report, and Metric Report activities
Worksheet Conversion Summary Activities:
Firearms, Blood Alcohol, Latent Print – Processing, Latent Print – ACE and Processing and Controlled Substance
• Design Mockup
• Design
• Print Preview
• Logic Coding
Lab Report(s) Summary Activities:
Firearms, Blood Alcohol, Latent Prints, Controlled Substances
• Specification
• XSLT Conversion to SQL
• Template
• Validation
• Installation
Metric Report Summary Activities:
• DataMiner
• WSExtract
• Latent Report
• Specification
• Development
• Validation
• Installation
Description of Metric Reports Work
• Review and Plan how DataMiner functions (XSLT/SSRS reports) o Review the .NET code for DataMiner o Verify worksheet fields are being collected o Verify fields for the Submission by Agency report are being collected.
o Determine any calculations being performed in the worksheets o Identify method for seamless transition between both reporting requirements
• Review how WSExtract functions (XSLT/SSRS reports) o Review the .NET code for DataMiner o Verify worksheet fields are being collected o Identify any calculations being performed in the worksheets o Identify method for seamless transition between both reporting requirements
• Development o Create new DataMiner report procedures and associated SQL job to drop data in the existing tables to use existing reports o Create new WSExtract report procedures and associated SQL job to…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .