header-left
File #: 1538-2021    Version: 1
Type: Ordinance Status: Passed
File created: 6/7/2021 In control: Finance Committee
On agenda: 7/12/2021 Final action: 7/15/2021
Title: To authorize the Director of Finance and Management, on behalf of the Fleet Management Division, to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., for fleet management software, hardware and related services; to authorize the expenditure of $829,400.00 from the Fleet Management Operating Fund; to authorize a waiver of relevant provisions of Chapter 320 of the Columbus City Codes; and to declare an emergency. ($829,400.00)
Attachments: 1. Ord 1538-2021 Assetworks Legislation Template.pdf, 2. Assetworks-Waiver Form.pdf

Explanation

 

Background:   This ordinance authorizes the Director of Finance and Management, on behalf of the Fleet Management Division (herein referred to as “City”), to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., (herein referred to as “Contractor”) for fleet management software, hardware and related services.  The City currently uses Contractor’s FleetFocus System which integrates with the Verizon Networkfleet Telematics solution, and the Parties wish to restate the terms and conditions applicable to the provision of AssetWorks’ proprietary products including Software as a Service (“SaaS”), hardware, and third party GPS/telematics equipment and associated, recurring hosting, maintenance, and subscription services (together “Services”).

The Contractor has the necessary experience and expertise to provide said service.  The previous agreement, entered on May 29, 1997, was most recently renewed by authority of ordinance 1110-2020, passed June 15, 2020; expiring on June 30, 2021. This contract renews the current services, while updating the terms and conditions to reflect upgrades in the services provided, to streamline the various components of the contract, and to include disentanglement language.

This contract will provide for annual software maintenance and support, as well as GPS/AVL service costs, vendor hosting fees, hardware installs, and software upgrades.  The term of this Contract shall be from July 1st, 2021 to June 30th, 2022, with the ability for the City to renew for successive one-year terms.  The first year of the contract will be for at a total cost of $829,400.00. The City has published a Best Value Procurement to contract for these services, with an estimated start date of July 1, 2023.

 

AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., is the vendor who currently provides a software platform for Fleet, Fuel and GPS databases, which are interfaced with each other to provide comprehensive management, analysis, and tracking functionality.  AssetWorks also provides professional services to support system upgrades and training and they are PCI compliant and manage the retail compressed natural gas (CNG) fuel transactions through the fuel application. 

 

The FleetFocus module/application provides a management system utilized by the Fleet Management Division to bill, manage, monitor and analyze all fleet maintenance related data.  Also, FleetFocus provides software accountability by tracking city-owned fleet equipment such as refuse trucks, fire apparatus, compost graders and various on road vehicles to support daily operational requirements.  The system also allows for the collection and management of fleet maintenance and usage data on a citywide basis.

 

Due to the critical nature of the fleet software platform required by the Division of Fleet Management, we respectfully request that the competitive bidding provisions of the Columbus City Codes be waived to continue this relationship with the existing provider while the City competitively selects a fleet software provider through a Best Value Procurement currently in process.  In addition, to ensuring continuity of Fleet operations, this contract contains cost savings, updated terms and conditions to reflect upgrades in services, and disentanglement language.

 

Emergency action is requested to ensure that services can continue without interruption.

 

Fiscal Impact: This legislation authorizes an expenditure of $829,400.00 from the Fleet Management Operating Fund with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc. for the enterprise software platform for Fleet, Fuel and GPS databases. The Fleet Management Division budgeted $900,000.00 within the Fleet Operating Fund for this service in 2020.  In 2019, $944,283.75 was expended for this software program. In 2018, $916,593.00 was expended for these services.

 

Title

 

To authorize the Director of Finance and Management, on behalf of the Fleet Management Division, to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., for fleet management software, hardware and related services; to authorize the expenditure of $829,400.00 from the Fleet Management Operating Fund; to authorize a waiver of relevant provisions of Chapter 320 of the Columbus City Codes; and to declare an emergency. ($829,400.00)

 

Body

 

 

WHEREAS, this ordinance authorizes the Director of Finance and Management, on behalf of the Fleet Management Division, to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., for fleet management software, hardware and related services; and

 

WHEREAS, AssetWorks and its enterprise suite of FleetFocus applications provides a management system utilized by the Fleet Management Division to bill, manage, monitor and analyze all fleet maintenance related data, in addition to the ability to provide accountability with tracking an unlimited number of city-owned fleet equipment vehicles to support the daily operational requirements of city government; and

 

WHEREAS, the Fleet Management Division respectfully requests that the competitive bidding provisions of the Columbus City Codes be waived to ensure the continuity of Fleet operations while the City competitively selects a fleet software provider; and

 

WHEREAS, it is necessary to authorize the expenditure of $829,400.00 from the Fleet Management Operating Fund; and

WHEREAS, an emergency exists in the usual daily operation of the Department of Finance and Management, Fleet Management Division, in that it is immediately necessary to authorize the Director to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., so that fleet management software, hardware and related services can continue without interruption, thereby preserving the public health, peace, property, safety, and welfare; NOW, THEREFORE,

BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:

 

SECTION 1:                     That the Director of Finance and Management, on behalf of the Fleet Management Division, is hereby authorized to enter into contract with AssetWorks LLC, a subsidiary of Trapeze Software Group, Inc., for fleet management software, hardware and related services, for a period of one year with annual renewal options.

   

SECTION 2:                     That the expenditure of $829,400.00, or so much thereof as may be necessary in regard to the action authorized in Section 1, be and is hereby authorized in the Fleet Management Operating Fund 5200, Subfund 520001 in Object Class 03, per the accounting codes in the attachment to this ordinance.

 

See Attached File: Ord 1538-2021 Legislation Template.xls

 

SECTION 3.                     That the monies in the foregoing Sections shall be paid upon order of the Director of Finance and Management and that no order shall be drawn or money paid except by voucher, the form of which shall be approved by the City Auditor.

SECTION 4.                     That the relevant sections of Columbus City Code Section 329 are hereby waived.

SECTION 5.                     That the funds necessary to carry out the purpose of this ordinance are hereby deemed appropriated and the City Auditor shall establish such accounting codes as necessary.

 

SECTION 6.                     That the City Auditor is authorized to make any accounting changes to revise the funding source for all contracts or contract modifications associated with this ordinance.

 

SECTION 7.                     That for reasons stated in the preamble hereto, which is hereby made a part hereof, this ordinance is hereby declared an emergency measure and shall take effect and be enforced from and after its passage and approval by the Mayor, or ten days after passage if the Mayor neither approves nor vetoes the same.