Loading...
HomeMy WebLinkAboutOrdinance 25576-06-2022 ORDINANCE NO. 25576-06-2022 AN ORDINANCE ADJUSTING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE ITS CAPITAL FUND, BY INCREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE FY22 PMIS PROJECT (CITY PROJECT NO. 103782) IN THE AMOUNT OF S177,130.00 AND DECREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE BUSINESS APPLICATIONS-IT PROGRAMMABLE PROJECT(CITY PROJECT NO. P00037) BY THE SAME AMOUNT; PROVIDING FOR A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE OF PRIOR ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT HEREWITH; AND PROVIDING AN EFFECTIVE DATE. BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF FORT WORTH, TEXAS: SECTION 1. That in addition to those amounts allocated to the various City departments for Fiscal Year 2021-2022 in the Budget of the City Manager, there shall also be adjusted estimated receipts and appropriations in the ITS Capital Fund, by increasing estimated receipts and appropriations in the FY22 PMIS project (City Project No.103782) in the amount of $177,130.00 and decreasing estimated receipts and appropriations in the Business Applications-IT Programmable Project(City Project No.P00037)by the same amount. SECTION 2. That should any portion,section or part of a section of this ordinance be declared invalid, inoperative or void for any reason by a court of competent j urisdiction,such decision,opinion or judgment shall in no way impair the remaining portions,sections, or parts of sections of this ordinance,which said remaining provisions shall be and remain in full force and effect. SECTION 3. That this ordinance shall be cumulative of Ordinance 25073-09-2021 and all other ordinances and appropriations amending the same except in those instances where the provisions of this ordinance are in direct conflict with such other ordinances and appropriations,in which instance said conflicting provisions of said prior ordinances and appropriations are hereby expressly repealed. SECTION 4. This ordinance shall take effect upon adoption. APPROVED AS TO FORM AND LEGALITY: CITY SECRETARY Jannette S.Goodall(Jun 30,202210:54 CDT) Jannette S. Goodall ' ' Assistant City Attorney City Secretary rft ADOPTED AND EFFECTIVE:June 28,2022 City of Fort Worth, Texas Mayor and Council Communication DATE: 06/28/22 M&C FILE NUMBER: M&C 22-0517 LOG NAME: 13P RFP 21-0188 PROJECT MANAGEMENT INFORMATION SYSTEM ITS ADK SUBJECT (ALL)Authorize a Purchase Agreement with e-Builder,Inc.,for the Purchase of a Project Management Information System with a Five Year Term with Implementation and Subscription Costs in an Amount of$1,771,300.00 for the First Year and$1,603,080.00 for Years Two Through Five for a Total Five Year Cost of$3,374,380.00 for the Transportation and Public Works,Water, Park and Recreation,and Property Management Departments which will be Managed by the Information Technology Solutions Department and Adopt Attached Appropriation Ordinances and Amend the Fiscal Year 2022 Adopted Budget and Fiscal Years 2022-2026 Capital Improvement Program, and Effect a Portion of Water's Contribution to the Fiscal Years 2022-2026 Capital Improvement Program RECOMMENDATION: It is recommended that the City Council: 1. Authorize a purchase agreement with e-Builder,Inc.,for the Purchase of a Project Management Information System with a five year term with implementation and subscription costs in an amount of$1,771,300.00 for the first year and $1,603,080.00 for years two through five for a total five-year cost of$3,374,380.00 for the Transportation and Public Works,Water, Park and Recreation,and Property Management Departments which will be managed by the Information Technology Solutions Department; 2. Adopt the attached appropriation ordinance adjusting estimated receipts and appropriations in the ITS Captial Fund, by increasing estimated receipts and appropriations in the FY22 PMIS Project(City Project No. 103782)in the amount of$177,130.00,and decreasing estimated receipts and appropriations in the Business Applications-IT Programmable Project(City Project No. P00037)by the same amount; 3. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the Water&Sewer Capital Projects Fund in the amount of$708,520.00 from available funds,for the purpose of funding the FY22 PMIS project(City Project No. 103782)to effect a portion of Water's contribution to Fiscal Years 2022-2026 Capital Improvement Program; 4. Adopt the attached ordinance increasing estimated receipts and appropriations in the Capital Projects Service Fund, in the amount of 1,408,693.00,authorizing the use of net position,for the purpose of transferring to the Capital Project Srvc-Capital Fund; 5. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the Capital Project Srvc—Capital fund in an amount of$523,043.00 transferred from the Capital Projects Service Fund,Capital Projects Svcs Business programmable project(City Project No. P00111); 6. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the Capital Project Srvc—Capital fund in an amount of$885,650.00 transferred from the Capital Projects Service Fund,for the purpose of funding the FY22 PMIS project(City Project No. 103782);and 7. Amend the Fiscal Year 2022 Adopted Budget and Fiscal Years 2022-2026 Capital Improvement Program. DISCUSSION: City of Fort Worth Departments currently utilize several different software programs to manage capital projects. For example,there are separate software programs for budget, payments,scheduling, inspection, bidding,and other management tasks. These separate programs do not interface with each other,thereby causing project management inefficiencies. In addition,these separate programs do not allow Capital Delivery staff to easily monitor and assess the delivery of infrastructure programs by the Departments and citywide. The Capital Delivery team identified this limitation with the current systems and requested that the Information Technology Solutions(ITS) Department and Purchasing assist in identifying a Project Management Information System(PMIS)that would provide a holistic capital management solution. It is anticipated that the PMIS will be utilized by the Transportation and Public Works,Water, Park and Recreation,and Property Management Departments for the management of capital projects. In order to procure a PMIS, Request for Proposal(RFP)21-0188 was advertised in the Fort Worth Star-Telegram for three consecutive Wednesdays beginning on August 11,2021,through August 25,2021. Fifty-Five vendors were solicited and the city received twelve responses. Two of the twelve were deemed non-responsive because of failure to adhere to page and font requirements. An evaluation panel comprised of representatives of the ITS,Water,Transportation and Public Works(TPW), Park and Recreation, and Property Management Departments reviewed and scored the submittals using the Best Value criteria which included: (a)Functionality (b)Technical (c)Approach (d)Company's Expereince (e)Cost of service After the initial evaluations,four of the highest-scoring bidders were required to demonstrate their products. The individual scores were averaged for each of the criteria and the final scores are listed in the following table. Points for pricing is determined as follows: Bidder must receive at least 50%or more of the total available points for technical criteria. Evaluations: Bidders �7�C� Total Score le-Builder,Inc. 30.00 69.56 i Kahua, Inc. IF 6 18.35 58.91 PMTech dba PMWeb (©F6_j©K]29.32 67.32 Procore Technologies, Inc. 7❑7�] E7:]21.97 !70.03 After the demonstrations, Procore Technologies, Inc.,received the highest score;however,the City and ProCore Technologies, Inc., were unable to agree to terms with the use of third party vendors,negotiations were ended. Therefore,in the best interest of the City,the evaluation panel and Purchasing staff,along with the Legal department agreed to move forward with the next highest scoring vendor.The vendor with the second highest score was e-Builder, Inc.As a result,staff recommends entering into a 5-year agreement with e-Builder, Inc. These implementation costs will be funded by the participating departments as depicted below: Year1 Department Description Share of Contract Year 1 Cost Transportation One-Time implementation, Integration, and Public Managed Services, Software Subscription + 50% Test Environment, Data Migration/Integration $885,650.00 Works Costs,Travel Expenses,Archival Services One-Time implementation, Integration, Water Managed Services, Software Subscription + 20/°° $354,260.00 Test Environment, Data Migration/Integration Costs,Travel Expenses,Archival Services One-Time implementation,Integration, Water Managed Services,Software Subscription+ ° Wastewater Test Environment, Data Migration/Integration 20/° $354,260.00 Costs,Travel Expenses,Archival Services One-Time implementation, Integration, Park and Managed Services, Software Subscription+ 0% $0.00 Recreation Test Environment, Data Migration/Integration Costs,Travel Expenses,Archival Services IT Solutions(for One-Time implementation, Integration, Property Managed Services, Software Subscription+ 10% $177,130.00 Management) Test Environment, Data Migration/Integration Costs,Travel Expenses,Archival Services Total Year 1 Contract Cost $1,771,300.00 IT Solutions will be responsible for paying the annual renewal costs using the IT Solutions Operating Budget using the department's funds as follows: Year 2-5 Department IDescription liShare of Contract Per Year Costs Transportation and Public Software Subscription+Test Environment 40% $160,308.00 Works Water Software Subscription+Test Environment 1 $80,154 000 Water Software Subscription+Test Environment 20% $80,154.00 Wastewater Park and Recreation p Software Subscription+Test Environment ° $40,077.00 Property Software Subscri tion+Test Environment 10% Management p [___ $40,077.00 Total Year 2-5 Contract Cost Per Year $400,770.00 In addition to the implementation and renewal costs,funds must be allocated for TPW staff that will assist in the implementation of the PMIS.This is estimated to be 4400 hours at an estimated cost of$523,043.00. The action in this M&C will amend the Fiscal Year 2022 Adopted Budget as approved in connection with Ordinance 25073-09-2021, Section 5. Internal Service Funds,as listed on page 21. Fund/Department FY2022 M&C Budget Revised FY2022 Adopted Authority Adjustment Budget Budget Category Budget Capital Projects Services Fund Revenues-TPW Charge for Services $ $ 14,954,248.00 14,954,248.00 Use of Money&Property $ $ 100,000.00 100,000.00 Use of Fund Balance/Net Position $ $ 38,513.00 38,513.00 Use of Fund Balance/Net Position This M&C $ $ 1,408,693.00 1,408,693.00 Total Revenues $ $ $ 15,092,761.00 1,408,693.00 16,501,454.00 Expenditures-TPW Transportation and Public Works $14,530,924.00 $14,530,924.00 Transfer to General Fund $3,291.00 $3,291.00 Transfer to Vehicle and Equipment Replacement$513,000.00 $513,000.00 Fund Transfer to IT Refresh Capital $45,546.00 $45,546.00 Transfer to Capital Project Service-Capital Fund This M&C $1,408,693.00 $1,408,693.00 Total Expenditures $15,092,761.00 $1,408,693.00 $16,501,454.00 The action in this M&C will amend the Fiscal Year 2022-2026 Capital Improvement program as approved in connection with Ordinance 25073-09- 2021, Section 6. Capital Improvements,as listed on page 22: Capital Fund FY2022 CIP Budget Revised FY2022 Name Project Name Appropriations Authority Adjustment Budget 30112-ITS P00037-Business Capital Fund Applications IT $859,401.00 This M&C ($177,130.00) $682,271.00 30102-Capital P001 11-Capital Project Srvc— Projects Svcs $233,000.00 This M&C $523,043.00 $756,043.00 Capital fund Business It is the practice of the Water Department to appropriate its CIP plan throughout the fiscal year,instead of within the annual budget ordinance,as projects commence,additional funding needs are identified,and to comply with bond covenants.The actions in the M&C will appropriate funds in support of the Water's portion of the City of Fort Worth's Fiscal Years 2022-2026 Capital Improvement Program, as follows: CapitalRevised Project �FY2022 CIPEutho Budget �Na und FY2022 me Name AppropriationsAdjustm]ent' Bud et � 9 103782- 56002- W&S Fiscal Year 2022 Project) Capital Managemenfi$ - ;This M&C $708,520.00 $708,520.00 Projects Information Fund System j Funding is available for appropriation from the Water Department Public Utility department's Unspecified-All Funds of the Water&Sewer Capital Projects Fund,the ITS Other General Government departments Business Applications-IT programmable project within the ITS Capital Fund and the TPW Construction Inspection department's Net position within the Capital Project Service operating Fund for the purpose of funding the FY22 PMIS project. AGREEMENT TERMS:The agreement will be for a five year term with no renewals. BUSINESS EQUITY-A waiver of the goal for Business Equity subcontracting requirement is approved by the DVIN-BE, in accordance with the Business Equity Ordinance, because the purchase of goods or services is from sources where subcontracting or supplier opportunities are negligible. ADMNISTRATIVE CHANGE ORDER:An administrative change order or increase may be made by the City Manager up to the amount allowed by relevant law and the Fort Worth City Code and does not require specific City Council approval as long as sufficient funds have been appropriated. Funding for this project was not included in the FY2022-2026 Capital Improvement Program because the bidding process did not occur until after the development of the FY2022-2026 Capital Improvement Program process.This action in this M&C will amend the Fiscal Years 2022-2026 Capital improvement Program as approved in connection with Ordinance 25073-09-2021. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are currently available in the Unspecified-All Funds project within the W&S Capital Projects Fund,the Business Applications-IT programmable project within the ITS Capital Fund and available in net position within the Capital Projects Service Operating Fund and upon approval of the above recommendations and adoption of the attached appropriation ordinances,funds will be available in the W&S Capital Projects Fund, ITS Capital Fund and Capital Project Srvc-Capital Fund for the FY22 PMIS project to support the approval of the above recommendations and execution of a purchase agreement. Prior to an expenditure being incurred,the IT Solutions Department has the responsibility of verifying the availability of funds. Submitted for City Manager's Office by: Reggie Zeno 8517 Valerie Washington 6192 Originating Business Unit Head: Anthony Rousseau 8338 Kevin Gunn 2015 Additional Information Contact: Cynthia Garcia 8525 Ashley Kadva 2047