The URL can be used to link to this page

Home My WebLink About062112-R2 - General - Contract - Dearmon Analytics LLCCSC NO 62112-R2 OFFICIAL RECORD CITY SECRETARY FT. WORTH, TX SECOND RENEWAL OF FORT WORTH CITY SECRETARY CONTRACT NUMBER 62112 VENDOR SERVICES AGREEMENT WITH DEARMON ANALYTICS LLC This SECOND RENEWAL OF FORT WORTH CITY SECRETARY CONTRACT NO. 62112 ("Renewal") is made and entered into by and between the City of Fort Worth ("City"), a home -rule municipal corporation of the State of Texas, and Dearmon Analytics LLC ("Vendor"), an Oklahoma limited liability company. WHEREAS, City and Vendor entered in to a contract for certain cost allocation services, the same being Fort Worth City Secretary Contract Number 62112 ("Agreement"); and WHEREAS, the Agreement provides for an initial term and three renewal options of one year each; and WHEREAS, the parties subsequently revised Exhibits A and B in connection with the execution of a first amendment and renewal, the same being Fort Worth City Secretary Contract No. 62112-AlR1; and WHEREAS, the current term expires on September 30, 2026; and WHEREAS, the parties wish to extend the Agreement, as amended, for an additional one-year period. NOW, THEREFORE, City and Vendor agree to renew and extend the Agreement as follows: 1. Fort Worth City Secretary Contract No. 62112, as amended by Fort Worth City Secretary Contract No. 62112-A1R1, is hereby renewed and extended for an additional one- year term, commencing October 1, 2026, and ending September 30, 2027 (the " Renewal Term"). 2. All terms and provisions of Fort Worth City Secretary Contract No. 62112, as amended by Fort Worth City Secretary Contract No. 62112-A1R1, between the City 2026 DEARMON/CFW Renewal Page 1 of 2 and the Vendor shall remain in full force and effect during the Renewal Term unless otherwise amended herein. IN WITNESS WHEREOF, the parties hereto have executed this renewal agreement in multiples for a second Renewal Term to commence on October 1, 2026. CITY OF FORT WORTH: By: Jay Chapa (Sep 29, 2026 15:42:10 CDT) Name: Jesus "Jay" Chapa Title: City Manager Date: APPROVAL RECOMMENDED: By: Christianne Simmons (Sep 29, 2026 15:30:07 CDT) Name: Christianne Simmons Title: Chief Transformation Officer ATTEST: 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: Brady Kirk Title: Assistant Finance Director APPROVED AS TO FORM AND LEGALITY: so�Fon>°°�aa By: aF�s?'i°°o tl °acyn�z asg4 By: Name: Jannette Goodall Title: City Secretary VENDOR: DEARMON ANALYTICS LLC, By: ame:Jacob Dearmon Title: Owner Date: 9/28/202026 Name: Denis McElroy Title: Assistant City Attorney CONTRACT AUTHORIZATION: M&C: N/A OFFICIAL RECORD CITY SECRETARY FT. WORTH, TX 2026 DEARMON/CFW Renewal Page 2 of 2 EXHIBIT A SCOPE OF SERVICES Deliverable 1: Sales Tax Reports Deliverable 1a: Annual 7 -year forecast using long -run annual observations. Provide at least three scenarios or provide a range of possible outcomes. Only for aggregate net payments. First Deliverable Due Date: First draft of 7 -year forecast due January 15 Final Deliverable Due Date: Final draft due February 25 Deliverable 1b: Stress testing exercise for aggregate net payments as an alternative modeling process using either FED's stress testing dataset. Deliverable Due Date: End of the month of April each year Deliverable 1c: Commentary and Presentation Material Deliverable Due Date: As needed basis Deliverable Id: (Up to 10 times per year (by default December, January, February, March, April, May, June, July, August and September (for October, November - and so on -through July allocations -months might be moved around depending on the need)) A. Monthly Sales Tax Forecast — provide month -by -month forecasts. a. Local Economic Conditions Model — need monthly series data b. Multiple models B. Quarterly Sales Tax Forecast — forecast based on quarterly series C. Fiscal Year Forecast for current and next FY based on monthly forecasts D. Monthly Forecasts — approximately 20 or so series (should timely data be made available) E. National, State, Local Economic Indicators — including BLS industry -level local employment and earnings statistics. Other data available upon request. F. Three monthly scenarios: Baseline, Pessimistic, Optimistic. Deliverable Due Date: Targeting 10 calendar days from the date the monthly sales tax data is made available by the Texas Comptroller or by the City of Fort Worth Deliverable le: Brief monthly meeting (as requested by the City with a minimum of a 10 -calendar day advance notice) discussing current economic conditions and forecast. Deliverable Due Date: The City may request meetings and presentations to occur on a more or less frequent basis provided the City gives at least a 10 -calendar day notice subject to scheduling availability Deliverable 2: Franchise Fees: Forecasting with scenarios (optimistic, base, pessimistic) of franchise fee revenues using payment history, economic indicators (gas, cable, minor telecom, any others), and other pertinent data Vendor Services Agreement — Exhibit A Page 3 of 5 A. Quarterly forecasting for use in current year budget management and next year's budget planning Deliverable 3: Optional Additional Services A. Analysis and Forecasting B. Optional analysis upon request and billable at prespecified rate Vendor Services Agreement — Exhibit A Page 4 of 5 EXHIBIT B PRICE SCHEDULE The all-inclusive price for the services as described in Exhibit A is as follows: Deliverable 1 series: $35,000 Deliverable 2 series: $7,500 Deliverable 3 series: dependent on hours (not to exceed a total of $42,500) One third (1/3) of the amounts above will be considered due and payable subject to the following conditions: • The City receives and accepts all deliverables that are scheduled to be due through the end of the month of February each year • Vendor provides an invoice meeting the City's invoicing requirements • Payment will be rendered "net 30" from the date the vendor invoice is received assuming the associated deliverables are accepted by the City The remaining Two-thirds (2/3) of the amounts above will be considered due and payable subject to the following conditions: • The City receives and accepts all remaining deliverables • Vendor provides an invoice meeting the City's invoicing requirements • Payment will be rendered "net 30" from the date the vendor invoice is received assuming the associated deliverables are accepted by the City With respect to "Optional Additional Services — Analysis and Forecasting", any additional analysis and forecasting service(s) outside of those described in deliverables 1 and 2 must be agreed to, in writing, by the City and Vendor. The estimated not -to -exceed amount will be based on an estimated number of hours for each task billed at a rate of $225.00 per hour. Any invoice for "Optional Additional Services — Analysis and Forecasting" will be paid net 30 from the date the vendor invoice is received assuming the associated the deliverable(s) are accepted by the City. Vendor Services Agreement — Exhibit B Page 5 of 5 FORT WORTH® City Secretary's Office Contract Routing & Transmittal Slip Contractor's Name: Dearmon Analytics LLC Subject of the Agreement: Second Renewal of CSC 62112, Vendor will provide analysis and forecasting of Sales and Property Tax receipts M&C Approved by the Council? * Yes ❑ No II If so, the M&C must be attached to the contract. Is this an Amendment to an Existing contract? Yes ❑ No 0 If so, provide the original contract number and the amendment number. Is the Contract "Permanent"? *Yes ❑ No 0 If unsure, see back page for permanent contract listing. Is this entire contract Confidential? *Yes ❑ No 0 If only specific information is Confidential, please list what information is Confidential and the page it is located. Effective Date: October 1, 2026 If different from the approval date. Expiration Date: September 30, 2027 If applicable. Is a 1295 Form required? * Yes ❑ No *If so, please ensure it is attached to the approving M&C or attached to the contract. Project Number: If applicable. N/A *Did you include a Text field on the contract to add the City Secretary Contract (CSC) number? Yes 0 No 0 Contracts need to be routed for CSO processing in the following order: 1. Katherine Cenicola (Approver) 2. Jannette S. Goodall (Signer) 3. Allison Tidwell (Form Filler) *Indicates the information is required and if the information is not provided, the contract will be returned to the department.