CN-550000-BE498-W0020100.pdf

STATE OF FLORIDA DEPARTMENT OF TRANSPORTATION

TASK WORK ORDER FOR CONTRACTUAL SERVICES

PROCUREMENT

Consultant:

Address:

Date:

6/30/2018

*Limiting or Estimating/Budgeted Amount.

Distribution:

Task Work Order No.:

Contract No.: Payment FM No.:

BE498 1909701A108, 1909701A101, 1909701A101

$864,187.00

(name) (title) Signature

Brian A. Blanchard, P.E. Assistant Secretary for Engineering and Operations

Other Notes:

An independent assessment of the staff hours and quantities for the proposed services has been performed, and found to be fair, reasonable, and competitive.

(LS1) Lump sum paid at completion

Page 1 Total

Page 2 thru 6 Subtotal

Total

Deliverable 5B/6B

Computer Aid, Inc.

1390 Ridgeview Drive Allentown, PA 18104 Phone: (610) 530-5000

FAX: (610) 530-5298

(To be entered upon execution of T.W.O.)

Brief Task Description:

In accordance with the above referenced contract, you are authorized to perform the tasks detailed in attached Exhibit A (Scope of Services).

Compensation elements are as follows:

Element Description Amount Est*Method of Compensation

The total amount or the limiting amount of the compensation will be:

All services required under this Task Work Order will be completed on or before:

$225,000.00

$225,000.00

Task Work Order No. 3 includes Deliverable 5B and 6B - Data Conversion and Application Development

Signature

Executive Vice President

$225,000.00

$0.00

(name) (title)

Abe Hunter

$225,000.00

Total authorizations to date (including this one):

Departmental Approval:

Consultant Acceptance:

DocuSign Envelope ID: 8EEB18D2-8853-4999-B21C-58C75C2FA73D

4/19/2018

Exhibit A Scope of Service

A-1

The Consultant shall provide the database design, the data conversion plan, and complete a subset of the development activities as referenced in Deliverable 5B and 6B below. This process will be to complete the Database Design, the Data Conversion Plan, and the development and unit test of 5 Administration screens, listed below. The acceptance criteria for each deliverable is also provided below.

Deliverable 5B: Preliminary Data Conversion Description: Completion of data conversion data per the User Requirements. CAI shall iteratively, on an agreed upon schedule, supply the draft versions of this deliverable.

The following elements comprise this deliverable:

1. Validate and finalize Conversion Mapping

2. Validate and finalize Conversion Plan

3. Validate and finalize Data Conversion Test Case Development

4. Final ERWIN Model, including:

a. Logical Data Model

b. Physical Data Model

c. Entity/Attribution Definition Report

d. Data Dictionary

5. Preliminary Data Conversion. (Final Data Conversion will occur during final production implementation).

6. Data Conversion Result Statistics Report

Acceptance Criteria:

1. Conversion Plan is considered complete when all fields from the approved data sources identified in Deliverable 5a are mapped in a spreadsheet to the PDA database field structure approved in Deliverable 5a.

2. ERWIN Model will be considered complete when the model successfully passes the FDOT OIT Database testing tool and OIT approval of the database structure is received.

3. Data Conversion Statistics Report includes the following information:

a. Number of records read and processed

b. Number of duplicate records

c. List of error messages and count

d. Data violations and count. This includes any data that breaks business rules set for the data, e.g., null where null is not allowed, alphanumeric in a numeric only field, data that exceeds expected data length, invalid zip codes, etc.

4. Preliminary Data Conversion will be considered complete when:

a. All records read are processed

b. No duplicate records

c. No error messages or error messages are accepted by FDOT

d. No data violations or data violations are accepted by FDOT

5. Conversion plan is complete, all fields are mapped, and Data conversion pass/fail requirements are documented.

Exhibit A Scope of Service

A-2

Deliverable 6B: Development of Application Components

Description: This deliverable represents the development of application components for the following screens:

1. Admin Data Table (Code Tables)

2. Admin Schedule Screens

3. Admin Vendors

4. Admin Retention

5. Admin Roles

6. Admin Notification

7. My Dashboard Work Underway

8. My Dashboard Search All

9. New Procurement

10. PS Advertisement Info

The following elements comprise this deliverable:

1. Source Code for the screens listed above is loaded into the FDOT Unit Test environment.

2. Test Cases for the screens listed above are documented by CAI, approved by the FAC, and loaded onto the FDOT PDA SharePoint site.

Acceptance Criteria:

1. Test Cases are documented for requirements of each component as detailed in the Deliverable 4 Requirements Document.

2. Unit Testing is completed and accepted by the FDOT PDA Review Team in the

FDOT Unit Test environment.

3. FDOT OIT Reviews listed below are completed and approved:

a. .NET Coding Standards Review

b. Web Application Standards & 508 Compliance Review

c. SQL Review

4. Validation that each program component meets the requirements as detailed in the Deliverable 4 Requirements Document and Screen Design Document.