HomeMy WebLinkAboutContract 48757-A4 CITY SECRETARY
�ECE
IV L CONTRACT NO.
. qV5� _��
E81 4 2020
�',VOF$�'1 A 0 FOURTH AMENDMENT TO
FORT WORTH CITY SECRETARY CONTRACT NO. 48757
This Fourth Amendment to Fort Worth City Secretary Contract No. 48757 ("Fourth
Amendment") is made between the City of Fort Worth ("Fort Worth"), a municipal corporation
and Data Transfer Solutions, LLC, a State of Florida limited liability company ("Vendor"). Fort
Worth and Vendor are collectively referred to herein as "Parties."
WHEREAS,the Parties entered into an Agreement identified as Fort Worth City Secretary
Contract No. 48757 beginning February 17, 2017 (the "Agreement'); and
WHEREAS, on or about September 25, 2017, the Parties subsequently amended the
Agreement via CSC No. 48757-Al to include changes in Property Management Field Data
Collection deliverable; and
WHEREAS, on or about January 31, 2018, the Parties subsequently amended the
Agreement via CSC No. 48757-A2 to include a Field Data Validation and Condition Assessment
deliverable to be provided by Data Transfer Systems (DTS) at a cost of$274,061.70.
WHEREAS, on or about August 24, 2018, the Parties subsequently amended the
Agreement via CSC No. 48757-A3 to include 14 additional days of training and support for TPW
Traffic Engineering deliverable to be provided by Data Transfer Systems (DTS) at a cost of
$21,000.
WHEREAS,it is the collective desire of the Parties to amend the Agreement to expand the
scope of work for Park and Recreation Park Operations Dynamic Reports deliverable to be
provided by Data Transfer Solutions (DTS) at a cost of$17,600.
NOW THEREFORE,known by all these present, Fort Worth and Vendor, acting herein by
the through their duly authorized representatives, agree to the following terms, which amend the
Agreement as follows:
1. The Agreement is hereby amended by adding Exhibit A, attached to this Fourth
Amendment, as additional items to Exhibit A of the Agreement.
2. The Agreement is hereby amended by deleting and replacing in its entirety Section
3. Compensation, in the Agreement as follows:
City shall pay Consultant an amount not to exceed $17,600.00 in accordance with
the provisions of this Agreement and Exhibit "B," Payment Schedule, which is
attached hereto and incorporated herein for all purposes. Consultant shall not
perform any additional services for the City not specified in this Agreement unless
the City requests and approves in writing the additional costs for such services.The
City shall not be liable for any additional expenses of Consultant not specified by
this Agreement unless City first approves such expenses in writing.The City agrees
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 1 of 7
to pay all invoices of Consultant within thirty (30) days of receipt of such invoice.
Consultant may charge interest on late payments not to exceed one percent (1%).
3. All other terms,provisions,conditions,covenants and recitals of the Agreement not
expressly amended herein shall remain in full force and effect.
[Signature Page Follows]
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 2 of 7
Executed effective as of the date signed by the Assistant City Manager below.
FORT WORTH:
City of Fort o Contract Compliance Manager:
By signing I acknowledge that I am the person
By: responsible for the monitoring and administration
Name: Kevin Gu i of this contract, including ensuring all
Title: Assistant City Manager performance and reporting requirements.
Date: ;/
By:
Name: L�
Approval o men ed: Title: Sr.Manager, IT Solutions
By: Approved as to Form and Legality:
Name: Sandra Youn b o0
Title: Assistant or,Park and Recreation By:
By: Name: John B. Stro
Name: Roger Wright Title: Assistant City Attorney
Title: Director, IT Solutions
Contract Authorization:
:O� FART &C:
Attest:
t A. O
By: :—I
Name: W6 Ktog
Title: City Secretary *•'•L• �-
VENDOR:
Data Transfer Salutions LLC
By:
Namc: M I on Ibaugn
Title: CFO
Date: Z. d +.
OFFICIAL RECORD
CITY SECRETARY
FT WORTH, TX
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 3 of 7
Exhibit A
a) Overview.
a. Scope. This document is Amendment Number 4 to City Secretary Contract
number 48757 Professional Services Agreement with Data Transfer Solutions,
LLC 9DTS) and describes additional scope requested by Park and Recreation
Park Operations (ParkOps) to include delivery of ten (10) specialized reports
requiring additional DTS labor at a cost of$17,600.
b. Out of Scope. Refer to Master SOW.
b) Objective. Enterprise Asset Management(EAM) VUEWorks implementation is
described in City of Fort Worth Statement of Work(SOW) approved and dated February
14, 2017. The SOW included VUEWorks implementation services for Park and
Recreation Trades with project pricing and scope quoted as a single implementation
comprising a 60-day effort at a cost of$188,295. During Trades implementation, Park
and Recreation Park Operations requested to be included in scope for Service Requests,
Work Orders, and MobileVUE. All deliverables were met, and following project
acceptance,Park Operations identified the need for customized Dynamic Reports
requiring development expertise beyond basic staff report training included as a Vendor
deliverable. Due to resource constraints, IT Solutions does not have available staff to
assign to this effort within the near term, and will instead contract this work to Vendor
using remaining EAM capital project funds:
a. Project: 100755
b. Fund: 33005
c. Department: 0040419
d. CF 1 Activity 000240
e. Budget Year 9999
c) Customer Required Dates. Refer to section 3.0, Project Schedule
d) Customer Point of Contact. Request was made by Sandra Youngblood, Assistant Park
and Recreation Director.
e) Initial Requirements. As described in the February 14, 2017 City of Fort Worth
VUEWorks Statement of Work, VUEWorks implementation scope and pricing for Park
and Recreation included these activities:
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 4 of 7
Exhibit A
a. Sprint 1 —GIS linking of all Assets
b. Sprint 2—Service Requests, Work Orders, MobileVUE Configuration
c. Sprint 3 —Reporting
d. Sprint 4—Data conversion and Work Order Migration (Trades)
e. Sprint 5—Administrator and User Training
f. Sprint 6—Testing/Validation/Acceptance
f) Scope for this Amendment.
a. Labor reports:
i. Total hours recorded by employee, activity, date range and location
ii. Total hours recorded by district, activity,date range and location
iii. Total hours recorded by location(park sites, libraries, etc.)
iv. Total hours recorded by activity and location (how long is it taking to
mow, litter collection, etc. in specific locations)
b. Work Order reports:
i. Total work orders completed by location(Summary with detail drop
down)
ii. Total work orders performed during set date range (Summary with detail
drop down)
iii. Total work orders completed by activity(Summary with detail drop
down)
c. Efficiency reports:
i. Percentage of total labor hours available versus total labor hours recorded
(work actually done)
ii. Percentage of total labor hours recorded by activity(percentage of time
used for litter, mowing, etc.)
iii. Vehicle/Equipment usage: total hours per unit, percentage of time used
based on 2080 hours per year
d. Vendor estimates the following additional cost to produce these reports:
iTask Hours Fee
Report Requirements Documentation 5 $ 1,000.00
Report Production 60 $12,000.00
Review Draft Reports w/Client S� 1,000.00
Finalize&Deiiever Reports 10 $ 2,000.00
-74
QC&Project Management 8' $ 1,600.00
$17,600.00
g) PreliminM Schedule.
Task Target Start Target Completion
Document Report Requirements Feb 3, 2020 Feb 7, 2020
Develop Reports Feb 10, 2020 Feb 21, 2020
Review Draft Reports with Client Feb 24,2020 Feb 26, 2020
PARD Reports Testing Feb 27, 2020 March 6,2020
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 5 of 7
Exhibit A
Finalize&Deliver Reports J March 9, 2020 March 11, 2020
Acceptance March 12, 2020 March 12,2020
h) Impact Assessment.
a. High-Level IT Solutions Division Involvement
i. Project Intake and general oversight
ii. Assist with promoting reports to production environment as necessary
iii. Ongoing VUEWorks Enterprise Asset Management System support
i) Success Criteria.
a. ParkOps reporting requirements are documented by Vendor and approved by
Michael Tovar.
i. Dynamic Reports are built in TEST and PROD according to approved
requirements.
ii. Reports are formatted per the documented requirements.
iii. Reports are accessible from the ParkOps VUEWorks instance under
Work Orders, Find/Manage/Report.
iv. ParkOps personnel can filter for desired data sets and run reports to
generate results.
v. Reports are generated without errors, and standard supported features are
functional: copy, edit,print, save as, etc
j) Assumptions.
a. ParkOps and Vendor will commit the appropriate resources to meet the project
schedule.
b. ParkOps subject matter experts that participate in the project will be
knowledgeable in the areas needed and will be able to provide the necessary
information during the meetings scheduled.
c. Assigned Action Items will be completed within a reasonable timeframe to allow
the project to stay on schedule. Action Items will be completed thoroughly to the
extent that they do not require significant follow up in order to produce the actual
completion.
d. Project resources will respond in a timely manner to meeting invitations, requests
for information,testing feedback, and project acceptance.
e. Scope will not exceed what has been outlined in this document without an
approved change request and estimate of additional cost if applicable. Requests
for additional reports or for reporting capabilities in addition to what is described
in this document will be managed as a change request and estimated as separate
effort.
f. ITS funding commitment will not exceed $17,600. Any additional costs
associated with approved scope changes will be the responsibility of ParkOps.
g. Reports will be developed for data currently residing in the production Work
Order module and will not require data correction, normalization, upload,
integration, or migration from another system.
k) Risks/Dependencies.
a. Report Data Accuracy. Reliable, accurate, and complete work order data must be
populated in VUEWorks to generate reliable, accurate reports. Reports that meet
the success criteria but do not provide expected results due to missing or
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 6 of 7
Exhibit A
inaccurate ParkOps data are considered to be working as designed, and will not
be cause for withholding payment. Vendor will assist with troubleshooting
unsatisfactory results, and ParkOps will be responsible for correcting any data
discrepancies to generate desired results.
Fourth Amendment to Fort Worth City Secretary Contract No.48757 Page 7 of 7