Loading...
HomeMy WebLinkAboutContract 55468-R3Contract Renewal Page 1 of 2 CITY OF FORT WORTH CONTRACT RENEWAL NOTICE January 24, 2025 Chad Wade Insight Global, LLC 4170 Ashford Dunwoody Road, Suite 220 Atlanta, Georgia 30319 Re:Contract Renewal Notice Contract No. CSC No. 55468 (the “Contract”) Renewal Term No. 3: March 20, 2025 to March 19, 2026 The above referenced Contract with the City of Fort Worth expires on March 19, 2025 (the “Expiration Date”). Pursuant to the Contract, contract renewals are at the sole option of the City. This letter is to inform you that the City is exercising its right to renew the Contract for an additional one (1) year period, which will begin immediately after the Expiration Date. All other terms and conditions of the Contract remain unchanged.Please return this signed acknowledgement letter, along with a copy of your current insurance certificate, to the address set forth below, acknowledging receipt of the Contract Renewal Notice. Failure to provide a signed acknowledgment does not affect the renewal. Please log onto PeopleSoft Purchasing at http://fortworthtexas.gov/purchasing to ensure that your company information is correct and up-to-date. If you have any questions concerning this Contract Renewal Notice, please contact me at the telephone number listed below. Sincerely, Tim Shidal Sr. IT Business Planner, Water IT Fort Worth Water Department (817) 392-8527 Contract Renewal Page 2 of 2 ACCEPTED AND AGREED: CITY: CITY OF FORT WORTH By: ___________________________ Name: William Johnson Title: Assistant City Manager Date: ___________________________ APPROVAL RECOMMENDED: By: ______________________________ Name: Christopher Harder Title: Water Director ATTEST: By: ______________________________ Name: Jannette Goodall Title: City Secretary CONTRACT COMPLIANCE MANAGER: By signing I acknowledge that I am the person responsible for the monitoring and administration of this contract, including ensuring all performance and reporting requirements. By: ______________________________ Name: Homero Garza Title: IT Manager, Water Department APPROVED AS TO FORM AND LEGALITY: By: ______________________________ Name: Hye Won Kim Title: Assistant City Attorney CONTRACT AUTHORIZATION: M&C: 23-0119 VENDOR: INSIGHT GLOBAL, LLC By: ______________________________ Name: Chad Wade Title: Senior Account Manager Date: ______________________________ 11/19/2020 M&C Review CITY COUNCIL AGENDA F�RT� II DATE: 6/16/2020 REFERENCE **M&C 20- LOG NAME: 13PAMEND STAFF AUGMENTATION NO.: 0410 M&C C-28999 04 ADK CODE: P TYPE: CONSENT PUBLIC NO HEARING: SUBJECT: Authorize Amendments to Professional Services Agreements with SRB Systems Inc., Abacus Technical Services LLC, Luna Data Solutions, Inc., APEX Systems LLC, Insight Global LLC, TEKsystems, Inc., GTS Technology Solutions, Inc., and Kforce, Inc. for Staff Augmentation Services in the Amount of $300,000.00, for a New Annual Total of $2,400,000.00, for the Information Technology Solutions Department (ALL COUNCIL DISTRICTS) RECOMMENDATION: It is recommended that the City Council authorize amendments to Professional Services Agreements with SRB Systems Inc., Abacus Technical Services LLC, Luna Data Solutions, Inc., APEX Systems LLC, Insight Global LLC, TEKsystems, Inc., GTS Technology Solutions, Inc., and Kforce, Inc. for staff augmentation services in the amount of $300,000.00, for a new total of $2,400,000.00, for the Information Technology Solutions Department. (ALL COUNCIL DISTRICTS) DISCUSSION: Temporary personnel are recruited from the staffing agencies to assist in the development and implementation of specialized technology projects and to use as temporary backfills for staffing vacancies. On November 1, 2016, City Council approved Mayor and Council Communication (M&C) C-27983, authorizing the execution of Professional Service Agreements with staff augmentation vendors APEX Systems, Sentari Technologies, Inc., TEKsystems, Inc., and Kforce, Inc.. in the annual amount of $2,100,000.00. M&Cs C-28636 and C-28999 were subsequently executed to add additional vendors SRB Systems Inc, Insight Global LLC, and Luna Data Solutions, Inc. as authorized vendors, increasing the opportunity of receiving competitive pricing. Sentari Technologies, Inc. merged with Abacus Technical Services LLC in November, 2016. The annual spending authority was increased by $100,000.00 in April of 2020 using an Administrative Change Order allowed per M&C C-28999 for a total annual amount of $2,200,000.00. The Water Department is implementing a specialized technology project requiring the use of temporary personnel. This increased capacity was not factored into the original total spend amount therefore an increase authority is needed. The Water Utility MyH2O initiative represents a utility-wide transformation of Fort Worth's Water business. This program implements new automated metering infrastructure (AMI) technology to enhance water delivery, support conservation, and improve the customer experience. Phase II of the MyH2O program launches projects identified during future state process discovery and requirements workshops identified during Phase I. Current staff must be augmented with contract staff in order to complete approved projects and to maintain current levels of support. Current state support includes daily maintenance and support tasks, previously approved projects, and ongoing ad-hoc support. Additional funds authorized by this M&C will be used to support the progress of this project. These agreements serve ALL COUNCIL DISTRICTS. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are available in the current operating budget, as previously appropriated, in the Water & Sewer Fund to support approval of the above recommendation and execution of the amendments. Prior to any expenditure being incurred, the Water Department has the responsibility to validate the availability of funds. BQN\\ apps.cfwnet.org/council_packet/mc_review.asp?ID=27979&councildate=6/16/2020 1 /2 11 /19/2020 M&C Review TO Fund Department Account Project Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Submitted for City Manager's Office by_ Originating Department Head: Additional Information Contact: ATTACHMENTS Jay Chapa (5804) Valerie Washington (6192) Reginald Zeno (8517) Cynthia Garcia (8525) Ashley Kadva (2047) apps.cfwnet.org/council_packet/mc_review.asp?ID=27979&councildate=6/16/2020 2/2 CITY COUNCIL AGENDA Create New From This M$C DATE: CODE 2/2/2021 REFERENCE NO.. P TYPE: **M&C 21- 0084 CONSENT LOG NAME: PUBLIC HEARING: FORT��'URTH -��- 13P STAFF AUGMENTATION ITS AND WATER ADK NO SUBJECT: (ALL)Authorize the Execution ofAgreements with SRB Systems Inc., Luna Data Solutions, Inc., Insight Global LLC, TEKsystems, Inc., GTS Technology Solutions, Inc., and Apex Systems, LLC for Staff Augmentation Services in the Annual Amount of $2,550,000.00 Using Various Cooperatives and Ratify Expenditures in the Amount of $100,000.00 for the Information Technology Solutions and Water Departments RECOMMENDATION: It is recommended that the City Council authorize the execution of agreements with SRB Systems Inc., Luna Data Solutions, Inc., Insight Global LLC, TEKsystems, Inc., GTS Technology Solutions, Inc., and Apex Systems, LLC for staff augmentation services in the annual amount of $2,550,000.00 using various cooperatives and ratify expenditures in the amount of $100,000.00 for the Information Technology Solutions and Water Departments. DISCUSSION: On November 1, 2016, City Council approved Mayor and Council Communication (M&C) C-27983, authorizing the execution of Professional Service Agreements (Agreements) with staff augmentation vendors in the annual amount of $2,100,000.00. M&Cs C-28636 and C-28999 were subsequently executed to add additional vendors, increasing the opportunity of receiving competitive pricing. The annual spending authority was increased by $300,000.00 in June of 2020 via M&C 20-0410 for a total annual amount of $2,400,000.00 to support the implementation of the Water Department's MyH2O initiative. The purpose of these Agreements is to add staff augmentation vendors for the Information Technology Solutions (ITS) and Water Departments to have Agreements in place to assist in the development and implementation of technology projects and to use as temporary backfills for staffing vacancies. When augmentation services are needed, individual recruitments are sent to each vendor to ensure that the City receives competitive pricing and qualified candidates. Upon approval of this M&C, the funds will be distributed between the ITS and Water Departments as fol lows: Information Technology Solutions $2,100,000.00 Water $450,000.00 The previously utilized DIR cooperative contracts have expired and the vendors have been awarded new contracts. This action seeks to replace the existing M&Cs to allow for continued services. The following cooperative contracts will be utilized for the respective vendors: Vendor Insight Global SRB Systems, Inc. Luna Data Solutions, Inc. TEKSystems, Inc. GTS Technology Solutions, Inc. Contract No. GS-35F-0247Y DI R-CPO-4589 DI R-CPO-4582 DI R-CPO-4638 DI R-CPO-4526 Contract Expiration March 19, 2022 August 31, 2024 August 31, 2024 August 31, 2024 August 31, 2024 Apex Systems, LLC DIR-CPO-4521 August 31, 2024 It is requested that City Council ratify expenditures in the amount of $100,000.00. In anticipation of a new M&C, ITS staff executed a contract with TekSystems, Inc. in the amount of $100,000.00. A contractor, engaged through TekSystems under their previous DIR cooperative contract, has been assigned to high priority tasks for the Human Capital Management (HCM) system payroll task initiative. To ensure that the progress of the project was not impacted, the contract was executed to allow for continued services. In order for these Agreements to align with the City's fiscal year, adoption of this Mayor and Council Communication (M&C) technically authorizes (i) a series of Purchase Agreements, each of which will align to the terms of the respective cooperative contract to ensure legal authority exists for the contract, and (ii) an annual spend amount, future years of which would be subject to City Council appropriation. In the event that a cooperative contract is not renewed, staff would cease purchasing at the end of the last Purchase Agreement coinciding with the valid cooperative contract. If the City Council were to not appropriate funds for a future year, staff would stop making purchases when the last appropriation expires, regardless of whether the then-current Purchase Agreement has expired. The City initially use these cooperative contracts to make purchases authorized by this M&C. The cooperative contracts expire on various dates. If a cooperative contract is extended, this M&C authorizes the City to purchase similar services under the extended contracts. If a cooperative contract is not extended, but a new cooperative contract is executed with the respective vendor with substantially similar terms as the previous cooperative contract, this M&C authorizes the City to purchase the services under the new cooperative contract. COOPERATIVE PURCHASE - State law provides that a local government purchasing an item under a Cooperative Purchasing Agreement satisfies any state law requiring that the local government seek competitive bids for the purchase of the item. The contract was competitively bid to increase and simplify the purchasing power of government entities across the State of Texas. M/WBE - An MBE/SBE goal is not assigned when purchasing from an approved purchasing cooperative or public entity. ADMINISTRATIVE 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. AGREEMENT TERM: Upon City Council's approval, the initial term of these Agreements shall commence upon final execution of the Professional Services Agreements and expire in accordance with the terms and conditions of the respective cooperative agreement. The Agreements may be renewed up to five (5) additional one-year terms. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are available in the current operating and capital budgets, as previously appropriated, in the participating departments' Operating Funds to support the approval of the above recommendations and execution of the contracts. Prior to any expenditure being incurred, the participating departments have the responsibility to validate the availability of funds. BQN\\ TO Fund Department Account rProject Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Fund Department Account Project Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Submitted for City Manager's Office by_ Jay Chapa (5804) Valerie Washington (6192) Originating Department Head: Kevin Gunn (2015) Reginald Zeno (8517) Additional Information Contact: ATTACHMENTS Cynthia Garcia (8525) Ashley Kadva (2047) FID Table - Staff Augmentation Services.xlsx (CFW Internal) Form 1295 Certificate 100698889 SRB systems.pdf (CFW Internal) Form 1295 Certificate 100703294 TekSvstems.pdf (CFW Internal) Form 1295 Certificate Apex Svstems.pdf (CFW Internal) 1 /5/22, 4:18 PM CITY COUNCIL AGENDA Create New From This M&C DATE: 6/22/2021 REFERENCE**M&C 21- LOG NAME: 13P AMEND 21-0084 STAFF NO.: 0456 AUGMENTATION ITS ADK CODE: P TYPE: CONSENT PUBLIC NO HEARING: ��RT�'�ORTII -�~- SUBJECT: (ALL) Authorize an Amendment to the Term of M&C 21-0084 and Increase the Annual Amount by $400,000.00 for Staff Augmentation Services using Cooperative Contracts for a Revised Term Amount of $2,950,000.00 with Two Annual Renewal Options for the Information Technology Solutions and Water Departments RECOMMENDATION: It is recommended that the City Council authorize an amendment to the term of M&C 21-0084 and increase the annual amount by $400,000.00 for staff augmentation services using cooperative contracts for a revised term amount of $2,950,000.00 with two annual renewal options for the Information Technology Solutions and Water Departments. DISCUSSION: On February 2, 2021, City Council approved Mayor and Council Communication (M&C) 21-0084 for the purpose of replacing the existing M&C authorization and to consolidate the four awards. Historically, utilized vendors have been awarded new cooperative contracts requiring new authorization for continued services. The previous M&Cs approved are C-27983, C-28636, C-28999, and 20-0410. The targeted outcome of M&C 21-0084 was to begin utilizing a refreshed $2.1 million authorization upon approval of City Council to ensure there were no interruptions to ongoing and upcoming projects. It is now a concern that the authorization period of 21-0084 overlapped the term of the previous M&C's authority could lead to an inadvertent overspend. Additionally, it is a concern that the "replacemenY' language in M&C 21-0084 retroactively impacted the historic approval. Temporary personnel are recruited from the staffing agencies to assist in the development and implementation of specialized technology projects. This includes ongoing operational needs, implementations of new capital funded projects, and the improvement of vital City services, to include cyber security and ERP projects. In addition to operational and capital efforts, the Information Technology Services (ITS) Department would like to have these contracts available for any projects needs that arise with the configuration of the new City Hall building. Therefore, ITS is recommending increasing their annual authorization by $400,000.00. Staff augmentation requirements are identified by the reporting IT Manager/Executive based on need and available budget. Recruitments are sent to each available contracted vendor and are provided an equal opportunity to respond with qualified candidates. Applicants are submitted to the hiring manager on a first in / first out basis and the recruitment is completed once a suitable candidate has been identified. The total of the new requested authorization amount of $2,500,000.00 for the ITS Department and $450,000.00 for the Water Department will become effective upon City Council approval and will be available for use through August 31, 2022. Throughout the next year, the ITS Department plans to evaluate the utilized vendors and will request a new authorization package in 2022. Vendors are given an equal opportunity to earn a minimum of 10\% of the awarded expenditures on an as- needed basis. No specific amount is guaranteed. From July 31, 2020 through February 2021, Insight Global was the only vendor contract available while M&C 21-0084 was being prepared therefore a disproportionate spend was utilized with Insight Global. Vendors authorized by this request are as follows. The vendors selected provide the best overall value. Existing City Secretary Contracts will be amended to reflect the term and compensation language changes as needed. M&C Review apps.cfwnet.org/council_packet/mc_review.asp?ID=29006&councildate=6/22/2021 1 /3 1 /5/22, 4:18 PM I Vendor TekSystems Apex Systems Luna Data Insight Global Cooperative Contract DIR-CPO-4638 DI R-CPO-4521 DIR-CPO-4582 GS-35F-0247Y M&C Review Cooperative Contract Expiration Date August 31, 2024 August 31, 2024 August 31, 2024 March 19, 2032 City Secretary Contract 54907 55409 54782 51991 The Water Department was included on approval 21-0084 for an annual authorization of $450,000.00. ITS proposes that the initial term of their agreement, beginning March 26, 2021, expire and renew upon City Council approval to align with the restructuring of the ITS agreements. DIR-CPO-TMP-445 was published on 4/16/2020 and responses were due on 6/11/2020 Agreement Term: Upon City Council's approval, the term will become effective and expire on August 31, 2022. The existing Vendor Service Agreements will be amended to reflect the new expiration date of August 31, 2022. Agreements will renew on September 1 thereafter. Renewal Terms: The Agreements may be renewed annually with a final expiration date of August 31, 2024. The renewals do not require specific City Council approval as long as sufficient funds have been appropriated. Administrative 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. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that upon approval of the recommendations, funds are available in the current operating budget, as appropriated, of the General, ITS Capital and Water & Sewer Funds and that, prior to an expenditure being made, the participating department has the responsibility to validate the availability of funds. BQN\\ TO Fund Department Account Project Program Activity Budget ID � ID � � Year Fund Department Account Project Program Activity Budget ID ID Year Submitted for City Manager's Office by_ Originating Department Head: Additional Information Contact: ATTACHMENTS Jay Chapa (5804) Valerie Washington (6192) Reginald Zeno (8517) Kevin Gunn (2015) Cynthia Garcia (8525) Ashley Kadva (2047) Reference # Amount Chartfield 2� Reference # Amount Chartfield 2) apps.cfwnet.org/council_packet/mc_review.asp?ID=29006&councildate=6/22/2021 2/3 1 /5/22, 4:18 PM M&C Review 13P AMEND 21-0084 STAFF AUGMENTATION ITS ADK funds availability.docx (Public) Copy of FID Table Staff Augmention 5.26.21.2.xlsx (CFW Internal) Form 1295 Certificate 100778241 - Apex.pdf (CFW Internal) Form 1295 Certificate 100779969.pdf (CFW Internal) Form 1295 Certificate 100778575 Teksystems.pdf (CFW Internal) Luna Data.pdf (CFW Internal) apps.cfwnet.org/council_packet/mc_review.asp?ID=29006&councildate=6/22/2021 3/3 1 /5/22, 4:17 PM CITY COUNCIL AGENDA Create New From This M&C M&C Review DATE: 9/28/2021 REFERENCE **M&C 21- LOG NAME: NO.: 0733 CODE: P TYPE: CONSENT PUBLIC HEARING: 13P AMEND 21-0456 STAFF AUGMENTATION MG �C�7 ��RT�'�ORTII -�~- SUBJECT: (ALL) Authorize an Amendment to the Term of M&C 21-0456 and Increase the Annual Amount by $358,000.00 for Staff Augmentation Services using Cooperative Contracts for a Revised Term Amount of $3,308,000.00 with Two Annual Renewal Options for the Information Technology Solutions Department RECOMMENDATION: It is recommended that the City Council authorize an amendment to the term of M&C 21-0456 and increase the annual amount by $358,000.00 for staff augmentation services using cooperative contracts for a revised term amount of $3,308,000.00 with two annual renewal options for the Information Technology Solutions Department. DISCUSSION: On June 22, 2021, City Council approved Mayor and Council Communication (M&C) 21-0456 increasing the annual amount of the previous Mayor and Council Communication (M&C) 21-0084. Temporary personnel are recruited from the staffing agencies to assist in the development and implementation of specialized technology projects. ITS is recommending increasing the annual authorization by $358,000.00 to address the payroll solution implementation with the Police and Fire Department. Staff augmentation requirements are identified by the reporting IT Manager/Executive based on need and available budget. Recruitments are sent to each available contracted vendor and are provided an equal opportunity to respond with qualified candidates. Applicants are submitted to the hiring manager on a first in / first out basis and the recruitment is completed once a suitable candidate has been identified. The total of the new requested authorization amount of $2,858,000.00 for the ITS Department and $450,000.00 for the Water Department will become effective upon City Council approval and will be available for use through August 31, 2022. Throughout the next year, the ITS Department plans to evaluate the utilized vendors and will request a new authorization package in 2022. Vendors are given an equal opportunity to earn a minimum of 10\% of the awarded expenditures on an as-needed basis. No specific amount is guaranteed. Vendors authorized by this request are as follows. The vendors selected provide the best overall value. Existing City Secretary Contracts will be amended to reflect the term and compensation language changes as needed. Vendor Cooperative Contract Cooperative Contract City Secretary Expiration Date Contract TekSystems DIR-CPO-4638 August 31, 2024 54907 Apex Systems DIR-CPO-4521 August 31, 2024 55409 Luna Data DIR-CPO-4582 August 31, 2024 54782 Insight Global GS-35F-0247Y March 19, 2032 51991 Renewal Terms: The Agreements may be renewed annually with a final expiration date of August 31, 2024. The renewals do not require specific City Council approval as long as sufficient funds have been appropriated. apps.cfwnet.org/council_packet/mc_review.asp?ID=29281 &councildate=9/28/2021 1 /2 1 /5/22, 4:17 PM M&C Review Administrative 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. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that upon approval of the recommendations, funds are available in the current operating budget, as appropriated, of the General Fund and ITS Capital Fund and that, prior to an expenditure being made, the participating department has the responsibility to validate the availability of funds. BQN\\ TO Fund Department Account Project Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Fund Department Account Project Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Submitted for City Manager's Office by_ Originating Department Head: Additional Information Contact: ATTACHMENTS Apex Systems LLC.pdf (CFW Internal) Apex Systems.pdf (CFW Internal) Insight Global LLC.pdf (CFW Internal) Insight Global.pdf (CFW Internal) Luna Data Solutions Inc.pdf (CFW Internal) Luna Data.pdf (CFW Internal) TekSystems Inc.pdf (CFW Internal) TekSystems Inc.pdf (CFW Internal) Jay Chapa (5804) Valerie Washington (6192) Reginald Zeno (8517) Kevin Gunn (2015) Cynthia Garcia (8525) Michelle Green (2058) apps.cfwnet.org/council_packet/mc_review.asp?ID=29281 &councildate=9/28/2021 2/2 6/15/22, 10:39 AM CITY COUNCIL AGENDA Create New From This M&C ��RT�'�ORTII -�~- DATE: 6/14/2022 REFERENCE **M&C 22- LOG NAME: 13P AMEND M&C 21-0733 STAFFING NO.: 0444 AUGMENTATION CODE: P TYPE: CONSENT PUBLIC NO HEARING: SUBJECT: (ALL) Authorize an Amendment to Staff Augmentation Agreements with Various Contractors Using Cooperative Contracts to Increase the Annual Amount by $1,066,000.00 for a New Total of Up to $4,374,000 for the Neighborhood Wi-Fi Project Managed by the IT Solutions Department and Neighborhood Services Department as well as the UKG Payroll Project Managed by Human Resources, IT Solutions Department, and Financial Management Services Department RECOMMENDATION: It is recommended that the City Council authorize an amendment to Staff Augmentation Agreement with various contractors using Cooperative Contracts to increase the annual amount by $1,066,000.00 for a new total of up to $4,374,000 for the Neighborhood Wi-Fi Project managed by the IT Solutions Department and Neighborhood Services Department as well as the UKG Payroll Project managed by the IT Solutions Department, Human Resources Department, and Financial Management Services Department. DISCUSSION: Technology Staff Augmentation provides temporary personnel which are recruited from the staffing agencies to assist in the development and implementation of specialized technology projects. On June 22, 2021, the City Council consolidated 4 previously approved M&Cs for Technology Staff Augmentation and approved using two Cooperative Agreements with four Vendors for Technology Staff Augmentation Services for an amount up to $2,950,000 for the Information Technology (IT) Department and the Water Department. (M&C 21-0456). The Vendors and the Cooperative Agreements are shown on the table below. In order to select the temporary technology staff, the staffing requirements are identified by the IT Department. Recruitments are sent to the Vendors listed below and the Vendors are given equal opportunity to respond with qualified candidates. Vendors are given an eqaul amount opportunity to earn a minmum of ten percent of the awarded expenditures on an as-needed basis. No specific amount is gauranteed. On September 28, 2021, City Council approved increasing the amount by $358,000 to a new total amount of up to $3,308,000 for IT Solutions for the Payroll Solution Implementation for Police and Fire. (M&C 21-0733) Information Technology Solutions Department (ITS) is recommending increasing the annual authorization by $1,066,000.00 for a total of $4,374,000 for the following projects: Support the ongoing Neighborhood WiFi Project $832,000.00 Support the UKG Payroll Project $234,000.00 Human Resource Department $115,000.00 Financial Management Department $119,000.00 The Human Resources Department and Financial Management Department amounts will fall under the UKG Payroll Project. Vendor TekSystems Cooperative Contract DIR-CPO-4638 Cooperative Contract Expiration Date August 31, 2024 M&C Review apps.cfwnet. org/cou nci I_packet/mc_review. asp? I D=29997&cou ncildate=6/14/2022 1/2 6/15/22, 10:39 AM Apex Systems Luna Data Insight Global DIR-CPO-4521 DIR-CPO-4582 GS-35F-0247Y August 31, 2024 August 31, 2024 March 19, 2032 FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are available in the current operating and capital budgets, as previously appropriated, in the Grants Operating Federal Fund and the ITS Capital Fund for the American Rescue Plan Act and Public Safety Payroll Solution projects to support the approval of the above recommendation and amendent to the contract. Prior to any expenditure being incurred, the Information Systems Department has the responsibility to validate the availability of funds. BQN\\ TO Fund Department ID FROM Fund Department ID Account Account M&C Review Project Program Activity Budget Reference # ID Year IChartfield 2' Project Program Activity Budget Reference # ID Year (Chartfield 2; Submitted for City Manager's Office by_ Originating Department Head: Additional Information Contact: Reginal Zeno (8517) Valerie Washington (6192) Anthony Rousseau (8338) Kevin Gunn (2015) Cynthia Garcia (8525) Ashley Kadva (2047) ATTACHMENTS 13P AMEND M7C 21-0733.docx (CFW Internal) Apex Form 1295 Certificate 100868202.pdf (CFW Internal) Apex sams 2.14.22.PNG (CFW Internal) Copy of FID Table Staff Augmentation 1-12 updated 3-14 (002).xlsx (CFW Internal) Form 1295 Certificate 100483586 (CG FE 2.8.22),pdf (CFW Internal) Form 1295 Certificate 100867494.pdf (CFW Internal) Insight Global, LLC.PNG (CFW Internal) Luna Data Form 1295.pdf (CFW Internal) Luna Data Solutions, INc. sams.PNG (CFW Internal) Teksystems, Inc.PNG (CFW Internal) Amount Amount apps.cfwnet.org/council_packet/mc_review.asp?ID=29997&councildate=6/14/2022 2/2 CITY COUNCIL AGENDA Create New From This M$C DATE: CODE 2/14/2023 REFERENCE NO.. C TYPE: **M&C 23- 0119 CONSENT LOG NAME: PUBLIC HEARING: 60AMEND STAFF AUGMENTATION NO FORT��'URTH -��- SUBJECT: (ALL) Authorize Execution of the Third Amendment to City Secretary Contract No. 55468 with Insight Global, LLC to Increase StaffAugmentation Services by an Additional $250,000.00 for the Water Department for a Revised Total Amount of $800,000.00 � RECOMMENDATION: It is recommended that the City Council authorize the execution of the third amendment to City Secretary Contract No. 55468 with Insight Global, LLC to increase staff augmentation services by an additional $250,000.00 for the Water Department's CIS utility billing system replacement project and additional temporary staffing backfills for a revised total amount of $800,000.00. DISCUSSION: The Water Department currently utilizes an agreement with Insight Global, LLC, to assist in the development and implementation of technology projects and to use as temporary backfills for staffing vacancies. The current agreement, obtained using General Services Administration (GSA) Contract No. GS-35F-0247Y, under City Secretary Contract (CSC) No. 55468 was approved on Mayor and Council Communication 21-0084. Water now needs additional resources for temporary staffing backfills and the CIS utility billing system replacement project, for the added cost of $250,000.00, increasing the not to exceed amount of CSC 55468 from $550,000.00 to $800,000.00. PRICE ANALYSIS - The prices were obtained using General Services Administration Contract No. GS-35F-0247Y. The GSA contract offers fixed discounts for these services. Water Information Technology staff has reviewed the pricing and determined it to be fair and reasonable. COOPERATIVE PURCHASE - State law provides that a local government purchasing an item under a Cooperative Purchasing Agreement satisfies any state law requiring that the local government seek competitive bids for the purchase of the item. GSA contracts were competitively bid to increase and simplify the purchasing power of government entities. Funding is budget in the Other Contractual Services account of the Water Department's Water & Sewer Fund. FISCAL INFORMATION/CERTIFICATION: The Director of Finance certifies that funds are available in the current operating budget, as previously appropriated, in the Water & Sewer Fund to support the approval of the above recommendation and execution of the amendment to the contract. Prior to any expenditure being incurred, the Water Department has the responsibility to validate the availability of funds. Fund Department Account Project Program Activity Budget Reference # Amount ID ID Year (Chartfield 2) Submitted for City Manager's Office by_ Originating Department Head: Additional Information Contact: ATTACHMENTS Dana Burghdoff (8018) Chris Harder (5020) Charmaine Baylor (6629) 60AMEND STAFF AUGMENTATION funds availabilitv,pdf (CFW Internal) 60AMEND STAFF AUGMENTATION FID Table (SPadar Edit 1.11.23).xlsx (CFW Internal) Routing and Transmittal Slip Water Department DOCUMENT TITLE: Insight Global - Third Renewal M&C: CPN: CSO: 55468 DOC #: TO: Initials Rick Lisenbee – Approver Vendor: Chad Wade, Insight Global Chad.Wade@InsightGlobal.com Homer Garza – Contract Compliance Manager Shane Zondor – Approver Jan Hale – Approver Christopher Harder – Signer Hye Won Kim – Signer for Legal William Johnson – Signer Ron Gonzales – Approver Jannette Goodall – Signer Allison Tidwell – Form Filler Tim Shidal – Acceptor Needs to be notarized: YES × NO Action Required: As Requested For Your Information × Signature/Routing and/or Recording Comment File FOR CMO USE ONLY: Routing to CSO x YES NO EXPLANATION Attached is the Third Renewal to CSC 55468 as authorized under Amendment 2. This agreement between Insight Global and the Water Department provides professional consulting services for the purpose of staff augmentation, contractor-to-permanent placements, and specific contractor project duties. Total annual spending authorization will not exceed $800,000. Purchase orders will be issued as needed for each contractor. Please approve/sign the renewal letter via Adobe Sign. If you have any questions or concerns, please contact me or call Homer Garza at (817) 392-8633. Tim Shidal Sr. IT Business Planner, Water IT Fort Worth Water Department 200 Texas Street Fort Worth, Texas 76102 (817) 392-2515 tim.shidal@fortworthtexas.gov SUMMARY OF INSIGHT GLOBAL CONTRACT FOR WATER IT WATER BEGINS USING ITS CONTRACT WITH INSIGHT GLOBAL: M&C 20-0410 dated 6/16/2020 authorized Water-specific staff augmentation funding of $300,000 via existing ITS contracts. Water leveraged the existing ITS contract with Insight Global via a GSA cooperative. ORIGINAL WATER CONTRACT: M&C 21-0084 dated 2/2/2021 resolved conflicts in funding allocation between ITS and Water by designating $450,000 for Water-specific staff augmentation. On the advice of Purchasing, a separate contract CSC 55468 was executed 03/26/2021 by the Water Department as a GSA Coop Purchase for $450,000 and set to expire 03/18/2022 in accordance with the GSA term. PSK 12957 was created for $450,000. M&C 21-0456 dated 6/22/2021 consolidated the 4 previous M&C approvals for staff augmentation contracts. It also ratified the expenditures that were disproportionately applied against the Insight Global contracts due to the coop expirations of the other staff augmentation vendor agreements. This M&C aligned the cooperative agreement terms for the Insight Global contracts to coincide with the GSA expiration of 3/19/2032 and authorized renewals. M&C 21-0733 dated 9/28/2021 added funding authorization for additional ITS needs and restated the authorized $450,000 for Water. AMENDMENT 1: CSC 55468-A1 executed on 01/13/2022 added the administrative money of $100,000 to the Insight Global contract for Water for a new PSK 12957 total of $550,000. M&C 22-0444 dated 6/14/2022 authorized funding for contract increases to cover additional projects and repeated the cooperative contract expiration dates. This M&C references the prior M&C 21-0456 that authorized a separate Water contract. AMENDMENT 2: CSC 55468-A2 executed on 06/27/2022 extended the original contract expiration date to 03/19/2023 to coincide with the renewed GSA and also added 9 1-year renewals up to 2032 per the GSA. This added another $550,000 to the original PSK for a new PSK 12957 total of $1,100,000. AMENDMENT 3: M&C 23-0119 dated 2/14/2023 authorized an increase of $250,000 in the Water spending authorization for a new total of $800,000 to cover staffing backfills and support the CIS utility billing system replacement project. CSC 55468-A3 executed on 2/20/2023 added $250,000 to increase the total annual spending authorization to $800,000 ($450,000 + $100,000 +$250,000 = $800,000). Adding the $250,000 to the existing PSK 12957 changed the total PSK amount to $1,350,000 as broken down below: $450,000 original year 1 amount + $100,000 added to year 1 = $550,000 total $550,000 for year 2 amount added = $1,100,000 total $250,000 amended = $1,350,000 total spend RENEWAL 1: Using the authorization provided by M&C 21-0456 to add renewals and Amendment 2 that added 9 renewals, CSC 55468-R1 was approved by the Assistant City Manager on 3/20/2023 to add another year to the Insight Global contract for Water. RENEWAL 2: Using the authorization provided by M&C 21-0456 to add renewals and Amendment 2 that added 9 renewals, CSC 55468-R2 adds another year to the Insight Global contract for Water. RENEWAL 3: Using the authorization provided by M&C 21-0456 to add renewals and Amendment 2 that added 9 renewals, CSC 55468-R3 adds another year to the Insight Global contract for Water.