HomeMy WebLinkAboutRON TURLEY ASSOCIATES 1C - 2011CLERK OF Cr i wn1""
INSURANCE NOT ON FILE
WORK MAYPROCEED
CLERK OF COUNCIL
DATE: MAY 1 8
2011
THIRD AMENDMENT TO
LICENSE AND SERVICE AGREEMENT
A-2007-058-03
THIS THIRD AMENDMENT TO AGREEMENT is entered into on March 22,
2011, by and between Ron Turley Associates, Inc. ("Licensor") and the City of Santa
Ana, a charter city and municipal corporation organized and existing under the
Constitution and laws of the State of California ("City").
RECITALS:
A. The parties entered into that certain Agreement A-2007-058, dated March 19, 2007,
(hereinafter "said Agreement") by which Licensor has provided license and
maintenance services for City's Fleet Management Application.
B. Said Agreement has been twice amended by the parties, to include additional services
and equipment.
C. In accordance with the terms and conditions of said Agreement, the parties wish to
amend the Scope of Services and Compensation, in order to provide Application
upgrades.
WHEREFORE, in consideration of the covenants contained in said Agreement, and
subject to all the terms and conditions of said Agreement, except those amended in this
First Amendment to Agreement, the parties agree as follows:
1. Section 1, SCOPE OF SERVICES, shall be amended to include an upgrade of the
Parts Inventory Application, as set forth in Exhibit A, attached hereto and
incorporated by this reference.
2. Section 2, COMPENSATION, shall be amended to increase compensation by
$3,200.00, to pay for the upgrade, as set forth in Exhibit A.
3. Except as hereinabove amended, all terms and conditions of said Agreement shall
remain in full force and effect.
IN WITNESS WHEREOF, the parties hereto have executed this First Amendment to
Agreement on the date and year first written above.
ATTEST: CITY OF SANTA ANA
MARIA D. HUIZAR-" DAVID N. REAM
Clerk of the Council City Manager
Additional signatures on next page
APPROVED AS TO FORM:
JOSEPH STRAKA
Interim City Attorney
3
La ra Sheedy
Assistant City Attorney
RON TURLEY ASSOCIATES, INC.
(NAME)
(Title) j r
V ?6e- S i C?e_n f-
RECOMMENDED FOR APPROVAL: CwtS`F0MC'- Se? V j c,--
FRANCISCO GUTIERREZ
Executive Director
Finance and Management
Services Agency
RON TURLEY ASSOCIATES, INC.
FLEET MANAGEMENT SOFTWARE & SUPPORT SERVICES
20823 N. 19th Ave., Suite 4
Phoenix, AZ 85027
Phone: 800-279-0549 • 623-581-2447 Fax: 623-582-1747
Website: www.rtafleet.com Email: rtafleet(aD-rtafleet.com
To: Milanka Radic
City of Santa Ana
Date: 3/10/11
RE: Custom Programming/Modification Quote # BK284
ProiectScope•
Create a sql script to export part transactions posted in the work order module into a csv
file. The scripts will be setup by Santa Ana to run in a sql job scheduler and will also be
available to be run manually (externally from the RTA software). This utility could be
run daily, weekly, monthly, etc.
CSV file name: RTAExportCCYYMMDD.csv
CSV file format with no header record as per attached file provided by the City. Some
minor modifications may be needed prior to final approval.
Transactions will be flagged when exported, and the export will not select any
transactions that have been flagged. The flag will also include the date it was exported.
The extracts are based on transactions. Therefore, if some parts are posted to a work
order, then the extract is run, those parts will be extracted, even though the work order is
still open. If other parts are then posted, those will be extracted in the next run. Two or
more extracts may contain postings from a single work order.
A second script will be created to "unflag" transactions. This utility will need to be
executed manually, and prompt for a date and remove the flag for all that were exported
on that date. The extract script could then be processed in order to extract those records
again.
Notes:
This quote does not include parts posted in the fueling module.
This quote does not include emailing the file.
Proiect Cost and Timeframe:
The cost of this enhancement is 53200. RTA could program this in approximately 10
weeks. We might be able to provide it sooner but I couldn't guarantee this based on our
current workload. This quote is valid for 90 days.
EXHIBIT A
If you would like to approve this project, sign the bottom portion and fax both pages to
(623) 582-1747. Upon your approval, an invoice will be sent to you for the entire
amount, although we do not require payment prior to the enhancement being delivered.
If you have any questions or need the program specifications modified, please call me at
(800) 279-0549 or email to billkiff&afleet.com.
Sincerely,
Bill Kiff
Vice President