Loading...
HomeMy WebLinkAboutResolution - 2023-R0450 - 6Th Ammendment, PSA Dated May 29, 2018, LP&L & TMG For SOW - 09/12/2023Resolution No. 2023-R0450 Item No. 5.45 September 12, 2023 : �_ 1 1 � WHEREAS, Lubbock Power & Light is the municipally owned electric utility of the City of Lubbock ("LP&L"); WHEREAS, by Professional Services Agreement dated effective June 14, 2018 (the "Original Agreement"), the City of Lubbock, acting by and through Lubbock Power & Light, through action by the Electric Utility Board and the City Council, contracted with TMG Utility Advisory Services, Inc. ("TMG"), to perform professional consulting services related to implementation of various systems for LP&L, as more particularly described in the Original Agreement; WHEREAS, by First Amendment to Professional Services Agreement dated August 20, 2019, Resolution EUB 2019-R0054, and City Council Resolution No. 2019- R0320 ("First Amendment"), LP&L and TMG agreed to amend the Original Agreement as regards certain matters relating to the TMG Utility Forum; WHEREAS, by Second Amendment to Professional Services Agreement dated May 19, 2020, Resolution EUB 2020-R0083, and City Council Resolution No. 2020- R0186 ("Second Amendment"), LP&L and TMG agreed to extend the term and increased the not-to-exceed amount of the Original Agreement, as amended; WHEREAS, by Third Amendment to Professional Services Agreement dated January 19, 2021, Resolution EUB 2021-R0008 and City Council Resolution No. 2021- R0036 ("Third Amendment"), LP&L and TMG agreed to provide for additional support hours necessary to complete the Services and increased the not-to-exceed amount provided for in the Original Agreement, as amended; WHEREAS, by Fourth Amendment to Professional Services Agreement dated Apri120, 2021, Resolution EUB 2021-R00030 and City Council Resolution No. 2021- R0160 ("Fourth Amendment"), the Original Agreement was amended to provide for additional support hours to complete the Services, extend the term, and adjust the compensation paid to TMG for such additional work; WHEREAS, by Fifth Amendment to Professional Services Agreement dated December 15, 2021, Resolution EUB 2021-R0094 and City Council Resolution No. 2022R0026 ("Fifth Amendment"), the Original Agreement was amended to provide for additional hours to complete the Services, extend the term and modify the not-to-exceed amount provided in the Original Agreement; WHEREAS, the Original Agreement, as amended, is in need of further amendment to provide for additional hours for additional work to complete the Services, extend the term, and modify the not-to-exceed amount provided in the Original Agreement, as amended; WHEREAS, LP&L desires to further amend the Original Agreement, as amended, to provide for such matters; and WHEREAS, the City Council of the City of Lubbock desires to authorize the execution of the Sixth Amendment to TMG Advisory Services Professional Services Agreement by the Mayor of the City of Lubbock. NO W, THEREFORE: BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF LUBBOCK: THAT the Mayor of the City of Lubbock BE and is hereby authorized and directed to execute for and on behalf of the City of Lubbock, that certain Sixth Amendment to Professional Services Agreement, by and between LP&L and TMG Utility Advisory Services, Inc., as attached hereto and incorporated herein as though set forth fully herein in detail, and any documents related thereto. Passed by the City Council this 12th day of September, 2023. ATTEST: C tney Paz, City Sec ary APPROVED AS TO CONTENT: TR �, Joe,�'�vy, Chief Administratiy� Officer, LP&L APPROVED AS TO FORM: �H6(-f.���(.li�� Carolyn S llman, Interim General Counsel, LP&L RESOLUTION � WHEREAS, Lubbock Power & Light is the municipally owned electric utility of the City of Lubbock ("LP&L"); WHEREAS, by Professional Services Agreement dated June 14, 2018 (the "Original Agreement"), the City of Lubbock, acting by and through Lubbock Power & Light, through action by the Electric Utility Board and the City Council, contracted with TMG Utility Advisory Services, Inc. ("TMG") to provide services related to the Advanced Metering ]nfrastructure ("AMI"), Customer Information System ("CIS"), Meter Data Management ("MOM") and Mobile Workforce Management ("MWFM") projects {the " Activities" or " Services") as more particularly described in the original �agreement; WHEREAS, by First Amendment to Professional Services Agreement dated August 20, 2019, Resolution EUB 2019-R0054, and City Council Resolution No. 2019- R0320 ("First Amendment"), LP&L and TMG agreed to amend the Original Agreement regarding certain matters relating to the TMG Utility Forum; WHEREAS, by Second Amendment to Professional Services Agreement dated May 19, 2020, Resolution EUB 2020-R0083, and City Council Resolution No. � 2020-R0186 ("Second AmendmenY'), LP&L and TMG agreed to extend the term and • mcreased the not-to-exceed amount of the Original Agreement, as amended; WHEREAS, by Third Amendment to Professional Services Agreement dated January 19, 2021, Resolution EUB 202i-R0008 and City Councif Resolution No. 2021- R0036 {"Third Amendment"), LP&L and TMG agreed to provide for additional support hours necessary to complete the Services and increased the not-to-exceed amount provided for in the Original Agreement, as amended; WHEREAS, by Fourth Amendment to Professional Services Agreement dated Apri120, 2021, Resolution EUB 2021-R0030 and City Council Resolution No. 2021- R0160 ("Fourth Amendment"), the Original Agreement was amended to provide for additionai support hours to complete the Services, extend the term, and adjust the compensation paid to TMG for such additional work; WHEREAS, by Fifth Amendment to Professional Services Agreement dated E.ianuary 11, 2021, Resolution EUB 2021-R0094 and City Council Resolution No. 2022- ; R0026 ("Fifth Amendment"), the Original Agreement was amended to provide for � additional hours to complete the Services, extend the term, and modify the not-to-exceed iamount provided in the Original Agreement, as amended; WHEREAS, LP&L and TMG now desire to further amend the �riginal Agreement, as amended to provide for additional time for TMG to complete the Services, as well as to increase the Not to Exceed ("NTE") amount relating to support services for bug fixes in the live system; WHEREAS, LP&L and TMG now desire to amend the Original Agreement, ' as amended, to address such matters; NOW, THEREFORE: BE IT RESOLVED BY THE ELECTRIC UTILITY BOARD OF THE CITY OF LUBBOCK: THAT the Chair of the Electric Utility Board BE and is hereby authorized and ; directed to execute for and on behalf of the City of Lubbock, acting by and through � Lubbock Power & Light, the municipally owned electric utility of Lubbock, Texas ("LP&L"), that certain Sixth Amendment to Professional Services Agreement, by and between LP&L and TMG Utility Advisory Services, Inc., as attached hereto and �ncorporated herein as though set forth fully herein in detail, and any documents related thereto. BE IT FURTHER RESOLVED BY THE ELECTRIC UTILITY BOARD OF THE CITY OF LUBBOCK: THAT this Resolution shall be null and void if the City Council of the City of Lubbock shall not likewise authorize and direct the Mayor of the City of Lubbock to execute this Fifth Amendment to Professional Services Agreement by and between LP&L and TMG Utility Advisory Services, Inc. within sixty (60) days of the date hereof. Passed by the Electric Utility Board this 15th day of August, 2023. ATTEST: L� L�,► � � �G Jviwen Stafford, Cha' ; � � - - Eddie chulz, oa ecretary APPROVED AS TO CONTENT: Joel y, Chief A m�nis tive Officer, APPR�VED AS TO FORM: Carolyn S lman, Interim General Counsel DocuSlgn Envelope ID OE8A414D-753C-4085-AFA9-682C90E9B119 Resolution No. 2023-R0450 SIXTH AMENDMENT to PROFESSIQNAL SERVICES AGREEMENT This Sixth Amendment to Professional Services Agreement ("Sixth Amendment to Professional Services Agreement"), is entered into this �� day of �, 2023, by and between the City of Lubbock, Texas, a Texas home rule municipal corporation, acting by and through Lubbock Power & Light ("LP&L"), and TMG Utility Advisory Services, Inc. ("TMG") WITNESSETH WHEREAS, by Professional Services Agreement dated June 14, 2018 (the "Original Agreement"), the City of Lubbock, acting by and through Lubbock Power & Light, through action by the Electric Utility Board and the City Council, contracted with TMG Utility Advisory Services, Inc. ("TMG") to provide services related to the Advanced Metering Infrastructure ("AMi"), Customer Information System ("CIS"), Meter Data Management {"MOM") and Mobile Workforce Management ("MWFM") projects (the " Activities" or " Services") as more particulacly described in the Original Agreement; WHEREAS, by First Amendment to Professional Services Agreement dated August 20, 2019, Resofution EUB 2019-R0054, and City Council Resolution No. 2019-R0320 (`'First Amendment"), LP&L and TMG agreed to amend the Original Agreement regarding certain matters relating to the TMG Utility Forum; WHEREAS, by Second Amendment to Professional Services Agreement dated May 19, 2020, Resolution EUB 2020-R0083, and City Council Resolution No. 2020-RO186 {"Second Amendment"), LP&L and TMG agreed to extend the term and increased the not-to-exceed amount of the Original Agreement, as amended; Sixth Amendment to Professional Services Agreement - TMG Utllity Advisory Services, [nc. Page 1 DocuSign Envelope ID OE6A414D-753C-4D85-AFA9-882C90E9B119 WHEREAS, by Third Amendment to Professional Services Agreement dated January 19, 2021, Resolution EUB 2021-R0008 and City Council Resolution No. 2021-R0036 ("Third Amendment"), LP&L and TMG agreed to provide for additional support hours necessary to complete the Services and increased the not-to-exceed amount provided for in the Original Agreement, as amended; WHEREAS, by Fourth Amendment to Professional Services Agreement dated April 20, 202 I, Resolution EUB 2021-R0030 and City Council Resolution No. 202 l-R4160 ("Fourth Amendment"), the Original Agreement was amended to provide for additional support hours to complete the Services, extend the term, and adjust the compensation paid to TMG for such additional work; WHEREAS, by Fifth Amendment to Professional Services Agreement dated January 11, 2021, Resolution EUB 202t-R0094 and City Council Resolution No. 2022-R0026 ("Fifth Amendment"}, the Original Agreement was amended to provide for additional hours to complete the Services, extend the term, and modify the not-taexceed amount provided in the Original Agreement, as amended; WHEREAS, TMG and LP&L have determined that additiona( time and compensation are needed to complete the Services, related to providing consultation on various bug fixes in the live system; WHEREAS, Consultant and LP&L now desire to enter into this Agreement, as amended, providing for such additional time and an increase into the Not to Exceed ("NTE") amount by one hundred eighty seven thousand three hundred and NO/dollars ($187,300); NOW, THEREFORE, for good and valuable consideration, the receipt and su�ciency of which is hereby acknowledged, LP&L and Consultant agree as follows: Sixth Amendment to Pro(essional Servlces Agreement - TMG UNlity Advisory Servlces, laa � Page 2 DocuSign Envelope ID. OE6A414U-753C-4D85-AFA9-662C90E9B119 1. Article II, Services and Compensation, Section C, is deleted in its entirety and hereby replaced with the following: "Except as provided below, the total sum to be paid hereunder shall not exceed, in any circumstance, the sum of six million six hundred seventy nine thousand one hundred twenty six and NOldollars ($6,679,126)." 2. Exhibit A to the Original Agreement is hereby amended to add the additional cost table, identified in Exhibit S of this Sixth Amendment. 3. Except as amended hereby, the terms and conditions of the Original Agreement, as amended, shall remain valid and subsisting as originally provided. IN WITNESS WHEREOF, the pacties have executed this Sixth Amendment to Professional Services Agreement by their duly authorized representatives as of the date first written above. CITY OF LUBBOCK, acting by and through Lubbock Power & Light Joel y, Chief Adminis �ve Officer APPROVED AS TO CONTENT: CI' ar er, Chief Customer Ofiicer Sixth Amendment to Pro[essional Services Agreement - TMG Utllity Advisory Services,lnc. Pape 3 DocuSign Envelope I0: OE6A414D-753C-4D85-AFA9-662C90E8B719 APPROVED AS TO FORM: �(iit� Carolyn Shel an, LP&L Interim General Counsel TMG Utility Advisory Services, Inc. oo��nw ey: �KAI'l0 T/dUA+Lr By: Title: cE Sixth Ameodment to Professional Servlces Agreement - TMG UHlity Advisory Services, lnc. Page 4 DocuSign Envelope 10: OEBA414D-753C-4D85-AFA9-682C90�96118 • � X 1 lt tatement o or OocuSign Envelope Id: OE6A414D-753C-4D85-AFA9-862C90E96119 EXHIBIT 5 tulg �onsultin g Where Business and Technology Intersect STATEMENT OF WORK FOR LP&L CCS Production Issues TMG Consulting 388 Feathergrass Drive 8udo TX 78610 512-993-6331 TMG Utiqty Advisory Services, Inc. � DBA TMG Consuliing Page 1 ot 9 DocuSign Ernelope ID OE6A414D-753C-4D85-AFA9-662C90E98119 , . prt . . � �i Table of Contents TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 5ummaryof �usiness Need .......................................................................................................................... 3 Scopeof Worlc/Services ................................................................................................................................ 3 1. 2. 3. a. 5. ProjectMana�ement ....................................................................................................................... 3 Test Mana�ement and Executan ....................................................................................................4 Organizational Change Management ("OCM"j ...............................................................................4 FunctionalLead ................................................................................................................................ 4 Reporting Lead / Reporting Suppor# .................................................................................................5 6. Technicai / Interface Lead ................................................................................................................ S MTMExtension - Milestone list ....................................................................................................................6 locationof Work ................. .. .......... ............. .............. ...... ............................. ......................................... 7 Pe�iod of Performance .................................................................................................................................. 7 . sumptions.................................................................................................................................................. Risks................... ...... ........... .. .... .... ................ .. ..... . .. ..... . .. .. .. . . .................... . ....................7 Texas Government Code Compliance ........................................................................................................... 7 ProjectTeam ................................................................................................................................................. $ Projecttosts ................................................................................................................................................. 8 Appro�al Signatures ......................................................................................................................................9 TMG Utlity Advisory Services, Inc, � pBA TMG Conwlting Page 2 of 9 DocuSign Ernelope ID: OE6A4140-753C-4U8SA�A9-662C90E98119 r E'ti9 � �. � • ,_� TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 Summary of Business Need The purpose of this Statement of Work {SOW) is to identify and display initial analysis of production issues reported to TMG. TMG staff have estimated both the issues identified as fixed but not closed and issues that are still outstanding and require further analysis, configuration and/or code, testing and support for USS to move the corrections to the Production environment. These services have been requested by the City of Lubbock, Texas, acting by and through Lubbock Power & Light ("LP&L"), and will be delivered by TMG Utility Advisory Services, Inc. DBA TMG Consulting, a Texas corporation ("TMG" or "Consultant"). Scope of Work/Services TMG witl provide the skiils required to correct the requested Production "bugs" and support LP&L in testing the corrections in the LP&L-designated environment and finally, migrating the corrections to the Production environment. TMG will provide, with each bug corrected, a document showing the configuration required and test case screen shots of the TMG testing. These documents wilt serve as guides for LP&L testing as well as Knowledge Transfer to the lP&L USS group. 1. Project Management TMG will provide a Project Manager that will provide project oversight and direction during this Statement of Work. The TMG Project Manager will monitor the tasks and activities assigned to TMG and provide leadership, management, and industry/product expertise. Project Management Activities will include but will not be limited to: 1. Detailed project planning and project auditing 2. Scheduling 3. Monitoring progress against tasks and hou�s 4. Weekly progress reports inciuding task, resource and hours expended 5. Forrnal and informal communication on all relevant events 6. Manage and dotument issues and resolution activities. 7. Provide project advice and recommendations throughout 2. Functional and Technical Expertise TMG wilf utilize both on-shore and off-sho�e resources to resolve the issues detailed below. The staff allocated to this effort will be TMG staff that worked on the LP&L previous SOWs and are knowledgeable in current configuration and customizations. TMG will provide: 1. Design documents that include any configuration, code, or business process change 2. Test Cases with test results for each issue 3. Migration objects that will enable lP&L to t�ansport the correction to an LP&L-designated environment. 4. Support LP&L as they complete pre-production testing. TMG Utility Advisory Services, Inc. � OBA TMG ConsuHing Page 3 of 9 DocuSign EnvelopelD OE6A414D-753C-4D85-AFA9-662C90E98119 ��J� f ti : � ■ I Consumption To Do's � and FA-IMD F • F Bug 38438 ; Billing Issue: Estimated 064 ' Read used in the Previous Bill but the next Bill receives good ' read Bug 35298 � Change Request: Write id9 i Off/Bad Debt j transactions hitting , � � wrong GL accounts Bug 38440 I Adjust IA if the Premise 117 : Type and SP do not � match � � T Bug 34141 � Severance activity is 84 � not starti�g for some 1 accounts/SAs. Bug 34566 To Do Error: Payment 93 Arrang. request monitor error" There were 2 existing elements found � matching" � Bug 35224 j Device �vents: System 98 � discarded Consumer � . � leak Oeteded ; Bug j 226 SOM Activitles � 986 {Reconnects, Enable, � � 8ack to 8acks) Not Working � eug System does not Break 990 PA during Gollection process. Trying to send I � : PA SA to write off. TMG Consulting 388 feothergrass Drive Buda TX 78610 5 i 2-993-633 I "unauthorized SP." VEE Rule "inactive Measurement theck" ; can be configured to do this, report has also been created ! for checking Unassociated Electric Meters with consumption ! {al�eady completed - will be implemented as part of Project CMA CM-55121-VEE Electric 20221208.cma) � i Franco/TMG to configure settings for the Final Replacement VEE rule in o�der to limit the number of UT correction p�ocessor activity that the system creates on these instances where a regular read replaces the estimated read that was used on billing. � Update configurations for Write off/bad Debt, configuring which GL accounts they go to. µ IA update � Issue resolved per bug Error when withdrawing PA on certain accounts, SR already created? SR 3-30544633541: Payment Arrangement Request Encountered Error, seems to only be for 3 accounts Need Oracle to fix this {SR) Conflguration change for creating an FA on leak detection, already completed? Oracle eug Fix (Closed) - Per Crystal Franco already provided s�lution, checking to see if this is a} different issue TMG Uti'ty Advisory Services, Inc. � DBA TMG Consu ting Page 4 of 9 Production Bug Initial Analysis DocuSign Envelope ID: OE6A414D-753C-4085-AFA9-682C90E9B119 i �i a.� �. Bug ` 34393 ' Config: Change duF 26 � billing calc to match ! Comm config � Bug f 29830 } Outage to be added to 67 Di-SIMTO service issue monitor requiring � f — } app�oval � Bug Adjustment to clear ; 946 escheatment account � 8ug � 44161 � Attaching Endpofnts— 91 OR 525 -Endpoint Disposition not updating when install is � complete Bug f 34825 � LPC compounding on 09S ' active and inactive accounts • -- + 8ug LOC: Letter of Credit 20 � from web dces not display the co�rect # of I � late Fees TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 � Adjust Residentia! Duplex billing calculation to match I commercial billing catculation, new calcuiation rules were � added but calculation is still not what they expected. Residential duplex calculation is too much, calculation rules need to be reconfigured ' Configuration change for Di-SIMTD, adding outage � + Creation of an adjustment, ""I need and adjustment � i created so that I can clear off the escheatment account to � ' zero before we start the process for this fiscal year. I need � this adjustment to have no GL affect Screen goes blank when attaching water endpoints, have to cancel/retry several times, and happens randomly/not a consistently rep�oducible bug � t Modification of LPC Algorithm, main issue was resolved ; howeve� there a�e still late payment charges on inactive ; accounts. Lubbock would like late payment charges only ionce after the finai bill. Also, LPC is being overcharged for water, ww, sw, and stormwater {over 5%j on active � accounts for month 3+ + Letter of Credit "does not display the correct number of late fees." The bug appears to be created because Lubbock wants a letter based on the Account level, rather than SA level jif the account has 2 electric SAs, 2 water SAs, and the account gets a late payment charge, onfy 1 letter should be made (?} rather than 4) � -----� I Bug ' 33305 � Cut for non-Pay creates 23 � i another FA when meter �� , status is left on (levy ; Fee) Bug � 35290 � Completion Events: 33 status Completed failed by Enter plug-in )Ol- i TRANPBRO-20 8ug 43950 ? CCS not sending 41 ' information for Water � outbound _ ! communication 510 �. Cut for non-pay creates another FA when the meter is left on, but the actual root issue is kind of confusing � I � The issue with 16s meters, an error occurs when changing out the meter "transition from status Create Completion ! Events to status Completed failed by Enter plug•in (D1 � TranPRBO) -20 _ CCS/OFS issue, CCS not sending informati�n for "water � outbound communication," example shows this during an � "investigate water' meter FA � TMG Utitity Advisory Services, Inc. � D6A TMG Consu�ting Page S of 9 DocuSign Envelope ID OE6A414D-753C-4085-AFA9-862C90E96119 h� r •: � • � '� Bug Configuration Change - 428 Cust of non-pay remote activity- Business Hours i of the Activity Bug � 33336 � Field Activity creates a 45 � duplicate FA if the meter state doesn't � change for CNP Bug r 33326 ' Remote Connect does 72 ! not fai! over to a Field � Activity Bug 33563 ; Create: Customer 75 ; contact for stopped SAs � due to FBC Bug � Available Severance 991 Cut of non-pay remote activity, the Business Hours of the Activity {bottom left corner on one of the screens) it has the hours of 0900 to 1500 hours. Because of this restriction, I would like to explore the question as to whether or not this is causing cuts that are �eleased through the th�ott{e but have not been picked up by the 15 minute job, to go into activity error and do not go to the meter until the following day � Dupiicate FA is created that requires manual completion on � 7 jsome FAs where meter state doesn't change I s. _ .._._____---- --- . Back-to-Back on a Water SP, when it is unable to get a read � � after 3 tries, a meter read FA should be created ; CC and FA were created however Lubbock states in the bug ; ' that the FA (BO-FBC) should be automatically generated during a severance process. Also, the latest test showed � errors related to Read Sequence and outbound response : � � errors but I think that was due to the test e�vironment "Due to SOM not wo�king" SQL query that Lubbock uses for severance appears to not be pulling in all the severances ; E that they are expecting, which is used to determine their ' "daily throttle setting." The belief that "the Severance � Process on all of the activitfes (activities that aren't showing i up] show an Event of "Awaiting Field Activity, Disconnect service for non-payment" CCS se�ds remote disconnect to Itron, the job fails on the Itron side {the meter did not respond in the time allotted,j the meter may or may not have actually disconnected, CCS processes the completion event was successful and transitions the meter to disconnected. CCS should nat t�ansition the completion event to successful if ITRON times out. iMG Consulting 388 feathergrass Drive Buda TX 78610 512-993-6331 Bug � 33324 Completion Event on 71 � Remote Disconnect fo� Failed Jobs 6ug 1055 Eliminate Service Task SIO for Outage Activity Type D1-WTTM�UTEX Error Message Bug 139 i I - .. Tota) to Correct Requested Bugs �$187,300.Q0 TMG Utility Advisory Services, Inc. � DBA TMG Consulting Page 6 of 9 DoaSign Envelope ID: OE8A414D-753C-4D85-AFA9-682C90E98119 M � . i � � Location of Work TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 i"he location of the work will be performed remotely but support will be provided onsite, as needed. TMG will be located where space permits when onsite at LP&L and wfll requfre access to a workspace/conference room and internet access. Period of Performance The project is scheduled from approximately July 2023 through March 2024. Assumptions This section identifies the assumptions upon which the plan and timeline have been established. ■ LP&L personnel are available as required to provide input and migrate bug corrections to ensure that the project progresses according to the timeline. ■ Access to LP&L environment and software will be granted as necessary to perform the work. ■ LP&L will provide Internet access, phone access to contact LP&L employees as required for meetings and questions, meeting space for required meetings and o�ce space. + TMG will review and follow lP&L's security policy and procedures, which will be provided to TMG at the start of the project. RIS�CS Th�oughout the execution of this SOW, TMG will identify risks, issues, and concerns in status reports to LP&L designated resources. Although none a�e expected, if any material risks to the project develop or any assumptions become invalid, TMG will provide timely notification to LP&L. If appropriate, a thange request will be negotiated with LP&L to address the material risk. Texas Government Code Compliance To the extent Chapter 2274, Texas Government Code applies to this agreement, TMG represents and warrants that it is not, and during the term of this agreement will not be (lj owned by or the majority of stock or other ownership interest of TMG will not be held or controlled by (i) individuals who are citizens of China, lran, North Korea, Russia, or a designated country, as defined in Section 2274.0101, Texas Government Code; or (ii) a company or entity, including a governmental entity, that is owned or controlled by citizens of or is directly controlled by the government of China, Iran, North Korea, Russia, or a designated country as defined in Section 2274.0101, Texas Government Code; or {2) headquartered in China, Iran, North Korea, Russia, or a designated country as defined in Section 2274.0101, Texas Government Code. TMG warrants and represents that thls agreement with TMG therefore does not and wifl not violate Texas Government Code Section 2274.0101, et seq. Non-Boycott of Energy Companies. TMG hereby warranis that it is in compliance with Chapter 2z74, Subtitle F, Title 10 of the Texas Government Code by verifying that: (1) it does not boycott energy companies, and (2) it will not boycott energy companies during the term of this Agreement. Non-Discrimtnation against Firearm Entities/Trade Assodations. TMG hereby warrants that it is in compliance with Chapter 2274, SubtitEe F, Title 10 of the Texas Government Code by verifying that: (1} it does not have a practice, policy, guidance, or directive that discriminates against a#irearm entity or firearm trade association, and (2) it witl not discriminate during the term of the contract against a firearm entity or firearm trade association. TMG Utility Advisory Services, InC. � DBA TMG Conwlting Page 7 of 9 DocuSign �nvelope ID: OE6A414D-753C-4085-AFA9-662C90E96119 �;�I a r �-.:. Project Team TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 LP&L's primary contact for support services will be Debra A�doline. As additional projects are defined, additional resources wilf be added. This section identifies the roles and responsibilities of the team. Should a named person become unavailable TMG will replace the named resources with equally skilled/qualified individuals that will be pre-approved by LP&L. Project Costs 2. 3. 4. 5. 6. The services specified above are provided on a time and materials ("T&M") basis; that is, LP&L shall pay TMG for all the time spent performing such services. The hourly rate detailed below includes travel expenses; therefore, travel costs and expenses will not be billed as an additional cost. All fees in this SOW are in US dollars. All hours will be invoiced monthly on the last day of each month. Payment shall be NET Thirty (30) days from the invoice date. TMG will retain the current LP&L rate of $210 for all on-shore �esources and any use of off-shore resources will be billed to LP&L at $65.00 per hour. TMG will provide these services based on the Production Bug Initial Analysis table located above, for a not to exceed of $187,300.00. If the project extends past the months defined or additional bugs are defined, TMG will retain the current LP&L rates but will work with LP&L to develop a Change Order for any additional services required. TMG Ufility Advisory Services, Inc. � DBA TMG ConsuHing Page 8 of 9 DocuS�gn Envelope ID OE6A414D-753C-4D85-AFA9-662C80E96119 . i'A ��.`!u • Signature Approval Signatures IN WITNESS WHEREOF, the parties have taused this SWtement of Work to be executed and represent that the persons whose signatures appear below are duly authorized to execute this Statement of Work. TMG Utility Advisory Services, Inc. DBA TMG Consulting Signature r°o"'�'"d�'� �M.aYtO PJaU�,Y' Name: Pam Glanvill (Please Printj Title: President date: 8/9/2023 Gty of lubbock, Texas, acting by and through Lubbock Power & Light TMG Consulting 388 Feathergrass Drive Buda TX 78610 512-993-6331 Name: � ` � (Please Print� Title: Date Il �.�� � ��1C�nntnl .�o�'�[ �-f�C�� �I�GI ti0ti3 TMG UtiNty Advisory ServiCes, inc. � D6A TMG Conwlting Page 9 ot 9