MAYOR ALDERMEN Marion Bishop Larry Sawyer Laura Almond MAYOR PRO-TEM Les McDaniel Kara Gilliland GAE 9 Kelli Tudyk GLISHED REGULAR CALLED MEETING OF THE LLANO CITY COUNCIL CITY HALL, 301 WEST MAIN STREET, LLANO, TEXAS 5:30 P.M. MONDAY, JANUARY 6, 2025 AGENDA This notice is posted pursuant to the Texas Open Meetings Act. All agenda items are subject to action. The City Council reserves the right to meet in a closed session on any agenda item should the need arise and if applicable pursuant to authorization by Title 5, Chapter 551, of the Texas Government Code. A. CALL TO ORDER B. PLEDGE OF ALLEGIANCE TO U.S AND TEXAS FLAGS and INVOCATION C. PUBLIC COMMENTS CONCERNING MATTERS NOT ON THE AGENDA (Visitors shall be limited to no more than (3) three minutes to address the Council or at the discretion of the mayor) In accordance with Section 551.042 of the Texas Government Code, an inquiry made at a meeting shall be conducted as follows: (a.) If at a meeting of a governmental body, a member ofthe public or the governmental body inquiries about a subject for which notice has not been given as required by this subchapter, the notice provisions of this subchapter do not apply to: 1. A statement ofs specific information given in response to the inquiry; and 2. A recitation of existing policy in response to the inquiry; and (b.) Any deliberation of or a decision about the subject of the inquiry shall be limited to a proposal to place the subject on the agenda for a subsequent meeting. D. CONSENT AGENDA ITEMS 1. Approve the Llano City Council Regular Meeting Minutes from December 16, 2024, meeting. E. REGULAR AGENDA ITEMS 1. Discussion and possible action regarding the appointment and reappointment of board members to the Planning and Zoning Board. Amy Galloway, Administrative Assistant 2. Discussion and possible action regarding the appointment and reappointment of board members to the Historic Preservation Board. Tony Guidroz, Economic and Community Development Director 3. Discuss and consider awarding a contract to Maquire Iron, Inc. for the water tower painting project to paint L.E.C. and L.L. Ground Storage Tanks. Josh Becker, Director of Water and Wastewater Operations 4. Discussion and possible action regarding an amendment to Ordinance No. 1546 regarding the Budget for FY 2024-2025. Cara Hewitt, Finance Director 5. Discussion and possible action regarding the purchase of upgraded VFD Control Panel, new manifold and hydro tank removal. Marly Mangum, City Manager F. MONTHLY REPORTS G. ADJOURNMENT Ifduring the course ofthe meeting and discussion ofany items covered by this notice, City Council determines that a Closed or Executive session ofthe Council is required, then such closed meeting will be held as authorized by Texas Government Code, Chapter 551, Section 551.071 consultation with counsel on legal matters; 551.072 - deliberation regarding purchase, exchange, lease or value ofreal property; 551.073 - deliberation regarding a prospective gif; 551.074 - personnel matters regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee; 551.076 - implementation ofs security personnel or devices; 551.087 - deliberation regarding economic development negotiation; Sec. 551.089 - deliberation regarding security devices or security audits; andlor other matters as authorized under the Texas Government Code. If a Closed or Executive session is held in accordance with the Texas Government Code as set out above, the City Council will reconvene in Open Session to take action, if necessary, on the items addressed during the Executive Session. Although a quorum ofthe members of other Boards or Commissions may or may not be in attendance, this notice is being posted to meet the requirements of the Texas Open Meetings Act and subsequent opinions of the Texas Attorney General's Office. In compliance with the Americans with Disabilities Act, the City of Llano will provide reasonable accommodations for persons attending City Council meetings. To better serve you, requests should be received 48 hours before the meetings. Please call 325-247-4158 Ext. 107. 1, Kim Wagner, City Secretary, do hereby certify that a copy ofthe. January 6, 2025 Llano City Council agenda was posted on thc City Hall bulletin board, a place convenient and readily accessible to the general public at all times, and to the City's website, www.CiyoLlano.com, in compliance with Chapter 551, Texas Government Code and remained posted continuously for at least seventy-twg (72) hours preceding the scheduled time of said Meeting. Wagpe 1-3-25 4:15p Kim Wagner, TRMC City Secretary Date, and Time Posted 59 REGULAR CALLED MEETING OF THE LLANO CITY COUNCIL CD CITY HALL, 301 WEST MAIN STREET, LLANO, TEXAS 5:30 P.M. MONDAY, DECEMBER 16, 2024 MINUTES Alderpersons Present: Mayor Marion Bishop, Mayor Pro-Tem Kara Gilliland, Les McDaniel, Laura Almond, Larry Sawyer, Kelli Tudyk Officers Present: Marty Mangum, City Manager, Kim Wagner, City Secretary A. CALL TO ORDER Mayor Bishop called the meeting to order at 5:30 p.m. B. PLEDGE OF ALLEGIANCETO U.S AND TEXAS FLAGS and INVOCATION C. EMPLOYEE PRESENTATION- NEW POLICE CHIEF JOHN BAUER D. PROCLAMATION- LLANO JACKET FOOTBALL E. PUBLIC COMMENTS CONCERNING MATTERS NOT ON THE AGENDA (Visitors shall be limited to no more than (3) three minutes to address the Council or at the discretion of the mayor) In accordance with Section 551.042 of the Texas Government Code, an inquiry made at a meeting shall be conducted as follows: (a.) If at a meeting of a governmental body, a member oft the public or the governmental body inquiries about a subject for which notice has not been given as required by this subchapter, the notice provisions of this subchapter do not apply to: 1. A statement of specific information given in response to the inquiry; and 2. A recitation of existing policy in response to the inquiry; and (b.) Any deliberation of or a decision about the subject of the inquiry shall be limited to a proposal to place the subject on the agenda for a subsequent meeting. F. EXECUTIVE CLOSED SESSION 1. The City Council will convene into Executive Session in accordance with the Texas Government Code Section 551.087 deliberations regarding Economic Development Negotiations. 2. The City Council will convene into Executive Session in accordance with the Texas Government Code Section 551.071 to consult with the City Attorney regarding legal matters concerning the litigation The executive session opened at 6:05 p.m. and closed at 6:29 p.m. G. EXECUTIVE OPEN SESSION 1. The City Council will reconvene into Open Session for the discussion and possible action regarding the deliberations regarding Economic Development Negotiations. 2. The City Council will reconvene in Open Session for discussion and possible action regarding legal matters concerning the litigation. No action will be taken. H. CONSENT AGENDA ITEMS 1. Approve the Llano City Council Regular Meeting Minutes from November 18, 2024, meeting. 2. Approve the 2024 fourth quarter report for the Llano Historical Society Hotel/Motel Tax for the Llano Museum. A motion was made by Alderwoman Almond, with a second by Alderman Sawyer to approve the consent agenda items. All in favor, none opposed. Motion carried. I. REGULAR AGENDA ITEMS 1. Discussion and possible action regarding approving a change to the organizational chart adding a third part-time position to the Airport Department. Marty Mangum, City. Manager A motion was made by Alderwoman Almond, with a second by Alderwoman Tudyk, to approve a change to the organizational chart adding a third part- time position to the Airport Department. All in favor, none opposed. Motion carried. 2. Discussion and possible action determining the City ofLlano's procedure for upkeep on improved or paved alleys within the city. Marty. Mangum, City Manager A motion was made by Alderwoman Tudyk to bring back an ordinance to clarify the upkeep on improved or paved alleys within the city. All in favor, none opposed. Motion carried. 3. Discuss and consider proposal from Stigger and Bizzell for City ofLlano 2025- 2029 Capital Improvement Plan Update. Josh Becker, Director of Water and Wastewater Operations A motion was made by Alderwoman Almond, with a second by Alderwoman Gilliland to approve the proposal from Stigger and Bizzell for City of Llano 2025-2029 Capital Improvement Plan Update. All in favor, none opposed. Motion carried. 4. Discussion and Possible Action on a donation to the Boys and Girls Club of the Llano. Natalie Virdell A motion was made by Alderwoman Tudyk, with a second by Alderwoman Almond to donate $1,000 to the Boys and Girls Club and buy a table at the Gala. Alderman McDaniel abstained from the motion. All in favor, none opposed. Motion carried. J. ADJOURNMENT The City Council meeting adjourned at 6:30 p.m. Ifduring the course oft the meeting and discussion ofany items covered by this notice, City Council determines that a Closed or Executive session ofthe Council is required, then such closed meeting will be held as authorized by Texas Government Code, Chapter. 551, Section 551.071 consultation with counsel on legal matters; 551.072 deliberation regarding purchase, exchange, lease or value ofreal property; 551.073 deliberation regarding a prospective gif; 551.074 personnel matters regarding the appointment, employment, evaluation, reassigmment, duties, discipline, or dismissal of a public officer or employee; 551.076 implementation ofs security personnel or devices; 551.087 deliberation regarding economic development negotiation; Sec. 551.089 - deliberation regarding security devices or security audits; and/or other matters as authorized under the Texas Government Code. If a Closed or Executive session is held in accordance with the Texas Government Code as set out above, the City Council will reconvene in Open Session to take action, if necessary, on the items addressed during the Executive Session. Although a quorum oft the members of other Boards or Commissions may or may not be in attendance, this notice is being posted to meet the requirements of the Texas Open Meetings Act and subsequent opinions of the Texas Attorney General's Office. In compliance with the Americans with Disabilities Act, the City of Llano will provide reasonable accommodations for persons attending City Council meetings. To better serve you, requests should be received 48 hours before the meetings. Please call 325-247-4158 Ext. 107. I, Kim Wagner, City Secretary, do hereby certify that a copy ofthel December 16, 2024 Llano City Council agenda was posted on the City Hall bulletin board, a place convenient and readily accessible to the general public at all times, and to the City's website, www.Ciyofllano.com, in compliance with Chapter 551, Texas Government Code and remained posted continuously for at least seventy-two (72) hours preceding the scheduled time of said Meeting. Kim Wagner, TRMC City Secretary Marion Bishop, Mayor City Council Agenda Date: 1-6-25 Agenda Item: E1 E 8 Item/Subject: Discussion and possible action regarding the appointment and/or reappointment of board members to the Planning and Zoning Board. Initiating Departmeny/Presenter: Amy Galloway, Administrative Assistant Recommended Motion: Background/History: Dwain Rogers has decided to not continue in his capacity as Chairman and the seat that Michael Herrera occupies is up for reappointment. Therefore, two members need to be appointed. Findings/Current Activity: Four people have applied to be members of the Planning and Zoning Commission. These people are: Robin Watkins, George Fricke, Michael Herrera and Steve Duncan. Financial Implications: None Associated Information: Agenda Item # E1 e 839 APPLICATION FOR APPOINTMENTTO BOARDS/ COMMISSIONS PLEASE SELECT THE BOARD/COMMISSION THAT YOU ARE INTERESTED IN: PLANNING & ZONING COMMISSION HISTORIC PRESERVATION COMMISSION PARKS & RECREATION ADVISORY BOARD AIRPORT ADVISORY BOARD LLANO ECONOMIC DEVELOPMENT CORPORATION MAIN: STREET: OTHER: NAME: ERickrm Goorqg TRriN (LAST) (FIRST) (MIDDLE) HOME STREET/MAILING. ADDRESS: 703 FlagCcopk CR. LANOTY. 781043 (ZiP) PREFERRED PHONE: CELLI PHONE: 335-249-4439 OCCUPATION/POSTION: Bolaip mawanor BUSINESS CONTACT PHONE: 832-444- 2327 (IF RETIRED, PLEASE INDICATE FORMER OCCUPATION) E-MAIL ADDRESS: pappi - 7Qutlok. FAX NUMBER: com ARE YOU A RESIDENT OF THE CITY OF LLANO? YES NO IF NO, ARE YOU AI RESIDENT OF THE CITY's EXTRA TERRITORIAL, JURISDICTION (ETJ)? YES NO N/A ARE YOU CURRENTLY OR HAVE YOU EVER SERVED ON ANY CITY BOARD OR COMMISSION? YES NO IF YES, PLEASE LIST EACH BOARD AND DATES OF MEMBERSHIP - ADDITIONAL SHEET MAY BE ADDED, IF NEEDED. DESCRIBE ANY QUALIFICATIONS OR EXPERTISE THAT RELATE TO YOUR INTEREST IN SERVING ON A BOARD/COMMISSION. You MAY ATTACH Al RESUME. 6RPRE servodlan aoccetar Pcenidonk Aal LLalo Conmll i Thontor Doord Boro nervpdloa Tho Chgmher Board or aOmont 3 upar 0o aecreiary Gad pAl PyPCCHc, comm ihop 05 Lat Vioe Cpirlor 1 upnr Masibkcgot Boord a DO YOU HAVE ANY RELATIVES THAT WORK FOR THE CITY OF LLANO? YES NO acecetary IF YES, WHAT IS THEIR NAME AND POSITION 1 SIGNATURE: DATE: 4laalay Additional information: Imoved to Llano 12 years ago and immediately fell in love with this town and it's people. I started my "serving journey" small, by selling tickets for Llano Community Theater. I went on to acting, directing, set designer, costume design, and working with the Board of Directors. I then became secretary and then prop coordinator, and then finally to President for 3 years. During my tenure as President and other roles within LCT met many people and built relationships with them. From Llano's City management, all the way to the High School. For two years I worked very closely with the then Drama teacher Caleb Strauss, helping students with credits and Scholarships. Ihave worked for Possibilities for 4- 5 years. During my time there, I have worked with many of Llano's citizens and listened daily to their ideas and opinions on how best to serve Llano. I have been on The Llano Chamber of Commerce Board for 3 years. I quickly took on the role of Secretary taking and sending out the minutes. - have also spear headed the creation and building of the Archives for the Chamber. In doing this I have met several previous Board members and have spoken to them at length on how to best serve our Businesses, and Llano as a whole. As a result I feel I understand businesses and their needs. As a citizen who eventually would like to run for City Council, feel I would best serve our town by having as much knowledge as possible and a complete understanding of our Planning and Zoning Commission is very important. I cannot think of two better people to learn from than Dwain Rogers and Diana Firestone. Both of whom have Llano's best interest at heart all the time. S AUISHED APPLICATION FOR APPOINTMENTTO BOARDS/ COMMISSIONS PLEASE SELECT THE BOARD/COMMISSION THATYOU ARE INTERESTED IN : PLANNING & ZONING COMMISSION HISTORIC PRESERVATION COMMISSION PARKS & RECREATION ADVISORY BOARD D AIRPORT ADVISORY BOARD LLANO ECONOMIC DEVELOPMENT CORPORATION OMAIN: STREET: OOTHER: NAME: Watkins Robin D'Ann (LAST) (FIRST) (MIDDLE) HOME STREET/MAILING ADDRESS: 1105 West Luce Street IF PO Box 221 Llano, TX 78643 (ZIP) 325-248-4148 325-248-4148 PREFERRED PHONE: CELL PHONE: Steger Bizzell 512-930-9412 OCCUPATION/POSITION: Survey Technician BUSINESS CONTACT PHONE: (IF RETIRED, PLEASE INDICATE FORMER OCCUPATION) E-MAIL ADDRESS: mm.ones@nomal.com FAXI NUMBER: ARE YOU A RESIDENT OF THE CITY OF LLANO? YES NO IF NO, ARE YOU A RESIDENT OF THE CITY's EXTRA TERRITORIAL. JURISDICTION (ETJ)? YES NO ON/A ARE YOU CURRENTLY OR HAVE YOU EVER SERVED ON ANY CITY BOARD OR COMMISSIO YES NO IF YES, PLEASE LIST EACH BOARD AND DATES OF MEMBERSHIP - ADDITIONAL SHEET MAY BE ADDED, IF NEEDED. DESCRIBE ANY QUALIFICATIONS OR EXPERTISE THAT RELATE TO YOUR INTEREST IN SERVING ON A BOARD/COMMISSION. You MAY ATTACHAF RESUME. Ihave worked for the County Surveyor for over 12 years, as well as working at the Appraisal District and at a title company. I am very familiar with zoning regulations, rules, and ordinances of multiple municipalities. Id currently work, mostly remote, for Steger Bizzell Engineering, in their survey department. I have over 2 decades DO YOU HAVE ANY RELATIVES THAT WORK FOR THE CITY OF LLANO? YES NO IF YES, WHAT IS THEIR NAME AND POSITION SIGNATURE: GDOK - DATE: 2/13/23 S 9 BISHED APPLICATION FORAPPOINTMENTTO BOARDS/COMMISSIONS PLEASESELECTTHE BOARD/COMMISSION THATYOU ARE INTERESTED IN: EPLANNING & ZONING COMMISSION a HISTORICI PRESERVATION COMMISSION BPARKS & REÇREATION ADVISORY BOARD DAIRPORT ADVISORY BOARD EANO ECONOMIC! DEVELOPMENT CORPORATION OMAINSTREET DOTHER NAME: HERRERA MNHEL SORIe (LAST) (FIRST) (MIDDLE) MOMESME/MAUNBADMES Paz Wayesles 78645 (ZIP) PREFERREDI PHONE: CELLPHONE: G1)449-049 ASSWY: ARTOR OCCUPATON/POsmON: ENSIERE AAERAS.. BUSINESS CONTACT PHONE URETRED,BEASEI INDICATE FORMER OCCUPATION E-MAILADDRESS KREERR. Megclaracasw: NUMBER: ARE YOU Al RESIDENT OF THE CITY OF LLANO? DES ONO IFN NO, ARE YOU Al RESIDENT OF THE CIY'SEXTRA TEAATORALIURSDICTON (ETJ)? OYEs BND ON/A ARE YOU CURRENTLY OR HAVE YOU EVER: SERVED ON ANY CITY BOARD OR COMMISSIOR CES ONO IF YES, PLEASE LIST EACH BOARD ANDI DATES OFI MEMBERSHIP -ADDITONALSHET MAYI BE ADDED, IF NEEDED. ERA aaszx Thasesas GONRNSSIAN Sye s. Kce AS a MAAE SEE 3 & NE) DESCRIBE ANY QUALIFICATIONS OR EXPERTISE THAT RELATE TO YOUR INTEREST IN SERVING ON A BOARD/COMMISSION. You MAY ATTACHARESUME. fSss - Z DO YOU HAVE ANY RELATIVES THAT WORK FOR THE CITY OF LLANO? JyEs ENO IF YES, WHAT IS THEIR NAME AND POSITION Michael O. Herrera, CNU-A, CCTM 907 W. Haynle Street Llano, TX 78643 (915) 449-0493 Cell Herena.0@leloud.com June 27, 2022 Clty of Llano 301 W. Main Street Llano, TX 78643 Re: Planning & Zoning Commission Letter of Interest To Whom It May Concern, Please accept this letter expressing my interest in becoming a member of the City of Llano's Planning and Zoning Commission. My background for the past 40+ years has been in civil engineering, land dovelopment and construction management. After retiring in 2017, I began attending the Otero County Commissioners meetings In Now Mexico where I lived. In 2018, I was approached by two of the Commissioners to consider an appointment to the Planning Commission. After serving one year, I was elected as the Chalrman ofthe Planning Commisslon and served for two years before moving back to Texas. My most recent work experience was as the Assistant Director for Engineering, Planning, Safety, Training and Security for the City of EI Paso's transit system, Sun Metro. - enjoyed bullding each of these departments from the ground up. Iserved as the lialson to City Council, Mass Transit Board, City Committees, Legislative Review Committee, and the Metropolitan Planning Organization. During my tenure with Sun Metro, I acquired my accreditations in the Congress of Now Urbanism (CNU-A) issued by the University of Miami School of Architecture and in Certified Community Transit Managers (CCTM). Major accomplishments included the conceptual design, engineering and construction management of five transit terminals (Including a seven story parking garage located at the University of Texas in EI Paso) and a 151,000+ square foot transit operations center encompassing 37.5 acres; doveloped four major corridors for a bus rapid transit system; and participated in the design/construction of El Paso's street car system. Page 2 Planning and Zoning Commission Letter of Interest June 27, 2022 In San Antonlo, I served the citizens as the City's Master Planner for seven years. My responsibilties included the analysis, reviews and approval of all Master Development Plans, Planned Unit Dovelopments, Major Thoroughfare Plans, Vested Rights and Fair Notice Forms, inside and outside the Extra-Territorial Jurisdiction of the City of San Antonio and all other incorporated cities within Bexar County, for conformity with County, City, State and Federal Regulations. I coordinated with the City Attorney's office, City Departments and other governmental entities such as Mass Transit (VIA), Housing & Urban Development (HUD), City Public Service (CPS), San Antonio Water System (SAWS), Texas Highway Department, and other affected organizations. Prior to the City of San Antonlo position, I served the citizens of Bexar County as an Engineer Associate in the Public Works Department for 14 years. My responsibilities included analyzing, reviewing, and approving all Prellminary Overall Area Development Plans, inside and outside the Extra-Territorial Jurisdiction of the City of San Antonio and all other incorporated cities within Bexar County, for conformity with County, City, State and Federal Regulations. For most of my work career, 1 have been dedicated to public service. I look forward to sharing my work knowledge and ability to solve problems with the citizens of Llano. Please let me know If you need any additional information for the consideration of this appointment. Sincerely yours, Phicbe - / Michael O. Herrera, CNU-A, CCTM MICHAEL O. HERRERA, CNU-A, CCTM ASSISTANT DIRECTOR SUN. METRO ENGINEERING, PLANNING, SAFETY, TRAINING & SECURITY DEPARTMENT DELIVERING QUISIANDINGSEIVICHS Office: (915) 212- 3303 X Cell: 915) 256- 0478 Fax: (915) 212-0124 Hemem.MO@rpsoicasger 10151 Montana*EIP.so,7 1X79925 Cable Channel City 1S-ww.dpmeiaager Steve Duncan 906 Flag Creek Dr Llano, TX 78643 817-201-1923 Steveduncan.mobile@gmail.com Relevant ExpenenceQualicatons Member of the City of Llano Comprehensive Plan Committee Familiar with the City of Llano Ordinances, to include all relevant Zoning Ordinances Previous served on the Planning Commission for Otero County, New Mexico, from 2021-2022, held the position of Secretary. Work History Drug and Alcohol Program Manager/Subrogation Specialist Sun Metro Transit, El Paso, TX Oct 2017-Apr 2018 Manager Oso Rio RV Park, Cloudcroft NM, Oct 2014 - Oct 2022 United States Postal Service Jul 2003 - Oct 2014, retired as Postmaster Mar 1999 - Mar 2001 Director of Operations, Ransom Lawn Service, El Paso, TX Jul 1994 - Jul 1998 United States Air Force (USAF) Operations Superintendent, Ramstein Air Base, Germany Sep 1992. Jul 1994 USAF Non-commissioned Officer-in-Charge Surveillance and Warning Center Operations, Royal Air Force Base Chicksands, England Nov 1991 - Aug 1992 USAF Chief of Mission Analysis, San Vito Air Station, Italy Apr 1988 - Nov 1991 USAF Non-commissioned Officer-in-Charge Mission Analysis, San Vito Air Station, Italy Mar 1985 - Mar 1988 Middle Enlisted Cryptologic Career Advance Program Student, National Security Agency (NSA), Fort Meade Army Post, Maryland Jan 1982 - Feb 1985 USAF Intelligence Analyst, Hickam Air Force Base, Hawaii Oct 1977 - Jan 1981 USAF Intelligence Analyst, Misawa Air Base 3 Japan Associate Degree in Intelligence Analysis, Community College of the Air Force, Mar 1991 Four USAF Meritorious Service Medals, 1988, 1992, 1994, 1998 NATO Medal for support to BosnialHerzegovina operations, 1997 Southern Watch Service Medal for operations in Riyadh, Saudi Arabia 1996 Distinguished graduate of the USAF Non-Commissioned Officers Academy in 1990 Non-Commissioned Officer of the Year, 1989, 6917th Electronic Security Group Air Force Achievement Medal, 1983 Air Force Commendation Medal, 1981 City Council Agenda Date: 1-6-25 Agenda Item: E2 E 89 Item/Subject: Discussion and possible action regarding the reappointment and/or appointment of board members to the Historic Preservation Board. Initiating Department/Presenter: Tony Guidroz, Economic and Community Development Director Recommended Motion: Background/History: Dawn Harris, Joe. Johnson, Wendal Pyles and Richard Smidt are looking for reappointment to the Historic Preservation Board. Findings/Current Activity: Financial Implications: None Associated Information: Agenda Item #E2 CITY COUNCIL AGENDA 1/6/25 Agenda Item: E3 a 59 Item/Subject: Discuss and consider awarding a contract to Maquire Iron, Inc. for the water tower painting project to paint L.E.C. and L.L. Ground Storage Tanks. Initiating Department/Presenter: Josh Becker, Director of Water and Wastewater Operations Recommended Motion: Motion to approve and authorize the mayor to execute the document. Background/History: In 2022 the City of Llano issued Certificates of Obligations which include $3,150,000 for repainting of five water towers. Engineer estimates for painting were $500,000 for Law Enforcement Center and $750,000 for Landon Lane. Findings/Current Activity:Stegger and Bizzell has completed the logistic planning fort taking the ground storage tanks located at Landon Lane and Law Enforcement Center out of service to allow for painting. This project will be done at LEC tower first, and upon completion and back in service, start on to the Landon Lane tower. S&B have gone out for bid, received 6 bids (attached in bid tabulations), and have a recommendation for award. The recommendation is to award to Maquire Iron, Inc. with a bid $182,500 for Law Enforcement Center Ground Storage Tanke and a bid of $411,000 for Landon Lane Ground Storage Tank for a total bid of $593,500. Financial implications: Item is budgeted: 20-51999-621 In the amount of $1,250,000 Associated Information: Letter of Recommendation to Award w/ Bid Tabulation Agenda Item # E3 STEGER - BIZZELL December 19, 2024 Mr. Josh Becker, Director of Operations City of Llano 301 West Main Street Llano, TX 78643 RE: Recommendation of Award Llano Law Enforcement GST and Landon Lane GST Rehabilitation Steger Bizzell Job No. 22963 Mr. Becker: On Wednesday, December 11, 2024, bids were received for the above referenced project. Six (6) contractors submitted acceptable Bids ranging from $593,500.00 to $2,624,500.00. The as-read results indicated that Maguire Iron, Inc. was the low-bidder with a Base Bid of $593,500.00. We have reviewed the as-read low bid package to include the bid form, bid bond, and qualifications summary and find them to be in accordance with the bid requirements. After review of the state of the existing tanks, we believe the majority of the required repairs are captured in the remaining bid items and the amount of Miscellaneous Welding Repairs" will be minimal. Additionally, all miscellaneous repairs will be directed solely by the third party inspector and confirmed with the City prior to construction. As part of the contractor investigation, we contacted the project managers and field inspectors for projects of similar size and scope listed in the bidding contractor's project history. The contacts that responded to our inquiry noted that the contractor in question completed the work on time and within budget and would recommend the Contractor for future work. Based on information gleaned from the investigation, we believe that Maguire Iron, Inc. has sufficiently demonstrated that they are a responsive and responsible contractor for a project of this size and scope and we recommend the City of Llano award the above referenced construction contract to Maguire Iron, Inc. Should you have any questions, please feel free to call me at 512-930-9412 or email me at davs@siegetbzel.com. Sincerely, Samuel H. Davis, P.E. Attachment: Copy of Sealed Bid Tabulation ADDRESS PHONE FAX WEB 1978 S. AUSTIN AVENUE I GEORGETOWN, TX 78626 512. 330. 9412 512. 930. 9416 STEGERBIZZELL. COM TEXAS REGISTERED ENGINEERING FIRM -181 SERVICES ENGINEERS > PLANNERS >> SURVEYORS Preparedby BID TABULATION 12/11/2024 STEGERTIBIZZEIL 22963 City ofl LlanoGST Rehabilitation TBPE FirmF-181 IIMLHEHETEEIGSTE TBaseBid Maguire DAMTank Paintine VBngP Painting Painting llanolandonlane GST BaseBid Maguire DEMTENE MEF Painting VHIEPArnE E NE Painting Item ItemDescription Quantit UniPrice TotalPrice UntPrice TotalPrice UnitPrice TotalPrice UnitPrice TotalP Price UnitPrice TotalPrice UntPite TotalPrice Pumshandictalathbo: materials, supplies, tools, equipment, transportation, anda aputeranestoPResuwy wash at350opsithee entire exteriorsurfacec ofthe tank witha asolutionofehlorines and alternate degreaser andbiodegradabies soaptokilandre remove mold. Rinsew witho cleany water. Mikingr eratiosari ipartTSP alternateto1 16galonsy water, 1part chlorine bleacht to4 4parts water and LS $15,000.00 $15,000.00 $33,850,00 $33,850.00 $12,000.00 $12,000.00 $4,800,00 $4,800.00 $8,000.00 $3,000.00 $90,00000 $30,000.00 E biodegradables soapt tol partv waterasin indicatedi inthe Schedule of Worka atthe eendofthet technical specifications, completeinplace,per. unit: 2 Furiha andinstallallabor, materials, supplies, tools, equipment, transportation, andappurtenancestoR Remove alle exterior coatingsbya abrasive blastingal allisur urfacest to commercialblasto condition! (SSPC Ls $45,000.00 $45,000,00 $71,760.00 $71,760.00 $140,00.00 $140,00.00 $84,000.00 $84,000.00 psuHaMhtAsNihwh. laafatemsemaanpa: perunit: $146.045.00 $146.046.00 $250,00.00 $250,000.00 Eurnisha andi install lall labor, materials, supplies, tools, equipment, transportation, and: appurtenancest to Recoatt tank exteriory rwithanorganicz czinc-riche epoxy primer (Carboline Carburincs e859)anda LS modified Polysiloxane hybrid tope coat (Carboline Carboxane2 2000)ora approvede equalas indcatedint thes Schedule of Workatt ttheendo ofthet technicals specifitations,e completei inplace, per unit: $45,000.00 $45,000.00 $47,840.00 $47,840.00 $45,000.00 $45,000,00 $46000.00 $46,00000 $108,00.00 $108,0.00 $250,00.00 $250,000.00 Furnisha andi installallabor, materials, supplies, tools, equipment, transportation,a anda EPATEMMKEEIPwNNT rubberg gasket, lock, and42'tallgrabb obarsonexisting3 30'x30" "roof hatchas 1_is $3,500.00 $3,500.00 $2,500.00 $2,500.00 $3,000.00 $3,000.00 $7,500.00 $7,500.00 $3,500.00 $3,500.00 $3,000.00 $3,000.00 Indicatedinthes ScheduedfWoratthee mdathawbhalvasfatons .completeinplace, per unit: Furnisha andinstallallabor materials, supplies, tools, equipment, transportation, anda appurten nances to Remove existing safetyctimbcagea andinstalla anew 316stainlessst stelsafetyclimbt tuber rail LS $4,000.00 $4,000.00 $5,000.00 $5,00.00 $6,000.00 $5,000.00 device. Sy:tems shallin include climberhamessy with split lanyandandreharhodks. asindicatedi inthe Schedueafworikatthe eend dofthet technical specifications, completeinplce $5,00.00 $8,00.00 $8,00.00 $10,800.00 $10,800.00 $5,00.00 andinstallallabor, materiali,supplis, toks,e equipment, transportation,a anda lappurtenancestoR Remove existing vent screen andreplacey witha ITMPSPYIMANAANT (PTFE) $700.00 $700.00 gasketas sidaednta.hadies -T completeinplace. perur unit: 1is $500.00 $500.00 $1,000.00 $1,000.00 $1000.00 $1,000.00 $1,350.00 $1,350.00 $2,000.00 $2,000.00 7 Fumish and Instllallabor, materials, supplies, tools, equipment, transportation,a anda appurtenan cestol Installa ahot dipede galvanizedbolta andnuto onthe 24"r manwayl hatch onthe west sidec ofthe 1is $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $800,00 $800.00 $675.00 $675.00 $2,000.00 $200.00 aa:s-sMitw-waNe comahain:h.ruNt Furnisha andi installalll labor, materials, supplies, tools, equipment, transportation, anda appurtenancestor Remove existingi ginteriork laddera randreplacey with new water raccess! laddery withs stainlesssteel Ls cablef fallprotections system. Systemshallincludec cables sleeve and climberk hamessasin indiratedinthes Schedule ofv Worka atthee endofthet technicals spedifications, completei inplace, per unit: $10,200.00 $10,200.00 $15,00.00 $15,000.00 $8,0.00 $8,00.00 $1,00.00 $11,000.00 $8,886.00 $8,886,00 $10,000.00 $10,00.00 9 Furnish andingtallallabor, materials, supplies,t tools, equipment transportation,a andal appurtenancestor Remove interior cosatingbyat abrasive blastingalls surfacesto near white condition. (SSPC-SP1 10)a as s $84,050.00 $84,050.00 $113,160.00 $113,160,00 $40,000.00 $40,000.00 $21670000 $216700.00 indiatedinthes XMAIXEMANA perunit $194,000.00 $194,000.00 $300,000.00 $300,000.00 10 Furnisha andinstallal allabor, materials, supplies, tools, equipment, transportation, anda mputeanastoRecatant: cinteriorv with 1008solids, ovoc, elastomeris, aromatic cpolyurethaneh hybrido coating LS $100,00000 $100,00.00 $95,440.00 $95,440,00 $107,700.00 Carboline Reactamine7 760Joraprovedequl asindicatedinthes Scheduleofworkatt the miathwwehaliyeketon, completeir inplace, perunit: $8,00.00 $80,00.00 $107,700.00 $159,000.00 $159,000.00 $300,000.00 $300,000.00 11 Furnisha andinstallallbor, materiab, supplies, tools, equipment, transportation, anda lappurtenancestoli Install Blingual 10'x14" "Confined Space. EntrybyF Permit Only" signo ay access hatches Ls $750,00 $750,00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 asindicatedinthes. Seheduieofwarkatthee misthkiihilassatws. completeinplace perunit: $1,350.00 $1,350.00 $5,000.00 $5,000.00 12 Fumish andi linstallallabor, materials, supples,t tools, equipment, transportation, ande appurten nancesto DisinfectT Tankasindicatedinthes Scheduleo ofWork the ndo ofthet technical specifications, 1s $2500.00 $2500.00 $2,500.00 $250000 $1,000.00 $1,000.00 52,400.00 $2,400.00 $3,000.00 $3,000.00 $5,000.00 $5,000.00 13 - andi materiabs, supplies, tools, equipment, transportation,a anda putnactomsaVammont temporary shrouding indicated inthe Schedule ofWorka atthe endofthe 1is $100,000.00 $100,000.00 $40,000.00 $40,000.00 technicals Isperifications, comseainke.rent $60,000,00 $60,000.00 $88,00.00 $88,000.00 $45,000.00 $45,000.00 $100,000.00. $100,000.00 Lianolandont Lane GST Total $411,000.00 $429,050.00 $397,000.00 5578,100.00 $684,607.00 51262,000.00 llanolandonlaneG GSTE BidA Alteratives Maguire DaMTank MKPainting Vikingp Painting Blastco NGPainting Item Deseription Quantit UniP Price TotalPice UnitPrice TotalPrike Unepice TotalPrice UnitPrice TotalPrie UnitPrice TotalPrice Unit Pice TotalPrice 3A E linstallallabor, materials, supplies, tools, equipment, transportation, anda appurtenancestor Recoat tank xterior withal Tnemec rior oat ystem indicatedin thes Schedulec ofWorkl 1us $65,00.00 $65,00.00 $47,350.00 $47,350,00 $65,000.00 $50,800.00 $146,000.00 technicals Ispecifitations, completeinplace. perunit $65,00.00 $50,800.00 $146,000.00 $500,000.00 $500,000.00 10A E linstallallabor, materials, supples,t tools, equipment, transportation, anda appurte to Recoat tanki interior withal Tnemec interior coating system as indicatedinthes Schedulec ofWork 1is $90,000.00 $90,00.00 $71,000.00 $71,000.00 $100,0.00 $100,000.00 $58,200.00 $58,200.00 $184,000.00 attheendofthete technialspecifiationse cmaiatainphtsperunt $184,000.00 $600,00.00 $E00,000.00 Lianolandonu LaneGSTA AlternativesT Total $155,000.00 5118,350,00 $165,000.00 $109,000.00 $330,000.00 1100,00000 lamolandonlameGST AlternativeBidT Total 5421,00000 5404,10,00 $437,00.00 5533,400.00 $747,607.00 $1812,00000 Bidform error. Confirmedby! Bidder on 2024-1 12-1 llanoGsT Rehabilitation BIdR Results Maguire DEMTank MKPinting Vilingp Painting Blastco NGPAinting ProjetBaseBidTOrals $593,500,00 $713.350.00 $727,500.00 $923,700.00 $1,089.179.00 $1,834,500.00 Project AlemativeBidT Totas: 5603500.00 $665,670.00 $807,500.00 $855,500.00 $1174.179.00 $2,624,500.00 SAMUEL. H. DAVIS 114913 3 Castn 0 Preparedby BID TABULATION 12/11/2024 STEGERLIBIZZELL 22963 City of Llano GSTF Rehabilitation TBPEF FirmF-181 llanolaw Enforcement GST Base Bid Maguire D&MT Tank MEPANihE VikingPainting Blastco NGPainting Item ItemDescription QuamtuntPise TotalPrice UnitPice TotalPrice UnitPrice TotalPrice UnitPrice TotalPrice UnitPrice TotalPrice UnitPrice TotalPrice Eumisha andir installa alll labor, materials, supplies, tools, equipment, transportation,a andappurtenanceste stoPressurew washat3 3,500psithee entire exterior rsurfaceofthet tanky witha solutiono ofchlorine and TSPa alterated degreaser and biodegradables scaptokill andremove mold. Rinsev with clean water. Maingr ratiosa are 1part +TSP alternateto 16gallons wate ter, part chlorine bleachto4 parts vater and% $10,00.00 $10,000.00 $20,350,00 $20,350.00 $10,00.00 $10,00.00 $2500,00 $2,500.00 $3,000.00 cupbiodegra radable soapto1 1part water rasindicatedint thes Schedule ofWork at the endo ofthe technical specificati ations, completei inplace, peru unit: $3,000.00 $30,000.00 $30,000.00 2 Fumisha andir installallabor, materials, supplies, tool, equipment,t transportation,a anda apputenanastoRemove: eallexteriord coatings by abrasive blastingallsurfacest to commercialk blasto condition (SSPC 1is $22,500.00 $22.500.00 $70,950.00 $70,950.00 sPGasindetedithes hwhadwwmmamsidta: tachnialsserifiations completein inplace. per unit: $100,000.00 $100,000.00 $99,100.00 $99.100.00 $97,045.00 $97,04600 $140,000.00 $140,00.00 Fumishz andir install alllabor, materials, supplies, tools, equipment: transportation,a and appurtenancest stoRecoatta tank exterior withanorganicz zine-r -riche epoxy primer (Carboline Carbozinc 859)a anda modified Polys ysiloxane hybridt topc coat (Carboline Carboxane 2000)or approved equala indicatedinthe! Schedule lork kat the endofthet nicals spedifications, completein place, per unit: $.2,500.00 $22,500.00 $47,300.00 $47,300.00 $45,00.00 $45,00000 $20,900.00 $20,900.00 $68,000.00 $68,00,00 $100,000.00 $100,000.00 Fumnisha andi install alllabor, materials, supplies, tools, equipment, transportation, andappurtenanceste toinstall wide rubbers gasket, lock, and42"tallgrabb barso onexisting 30'x30" roofh hatchas 1s $3,500.00 $3,500.00 $2,00000 $2,000.00 $3,000.00 $3,500.00 Iindkatedinthes ScheduleofWorka atamaiasdww completeinplace. perunit: $3,000.00 $7,500.00 $7,500.00 $3,500.00 $2,000.00 $2,000.00 5 Fumisha andi installallabor, materials, suppies,t tools, ,equipment,t transportation, and appurten ancestoRepairt tank mechanicalle level lindicatort rtorestoref functionfcable,p pulleys,f fioat, etc)asindicated 1Ls $4500.00 $4,500.00 $7,500.00 Inthes sdhalueclWosathende ofthet technicals Isperifrations, cmiktainshafar-st $7,500.00 $2,000.00 $2,000.00 $4,500.00 $4500.00 $7.155.00 $7.155.00 $2,000.00 $2,000.00 6 urnish andir install allla labor, materials, supplies,t tools, equipment, transportation, and appurter nances stoRemove existing vents screens andr replace with EMHMAMASMMAIVON 1s $500.00 $500.00 $1,000.00 eendofthetechnials: Ispediications, completel Inplace, perunit: $1,00.00 $1,00000 $1,00000 $400.00 $400.00 $1,350.00 $1,350.00 $2,000.00 $2,000.00 7 - andi Instalalla labor, materials, supplies, tools, equipment, transportation, and appurtenancestos Sealgap! between tank sketch plate (chime)a and concreter ring gbeamusingCarbolines Semstone 1us $3500.00 $3500.00 $2,000.00 $2,000.00 $3,000.00 $3,000.00 $1,600.00 $8,046.00 $8,046.00 InesaStemal MAAwta-siiN. ehnialspecffationsc completeinplace. perunt $1,500.00 $5,00.00 $5,000.00 8 Furnisha and installalll supplies, tools, equipment, transp portation, and appurte nances toInstall new adder vandlguard asindicated inthe Schedule eofWorka atthee endofthete technical 1is $2,500.00 $2,500.00 $2,500.00 $2,500.00 sAsaReN. $2,00.00 $2,000.00 $3,00.00 $3,000.00 $2025.00 $2,025.00 $6,000.00 $6,000.00 Fumisha andinstallallabor, materials, supplies, tools, equipment,t transportation, and appurtenancest toRemovee existing Esafetydlimbca cage and linstalla new 316s stainless steel safetyetimbtuberal LS device.s Systems shall include chamberh rharness with splitk lanyarda landrebar rhooks asindicatedinthes Schedulecfworkath thee endofthet technicals specifcations, complete place $4,000.00 $4,000.00 $5,000.00 $5,000.00 $6,000.00 $6,000.00 $8,200.00 $8,200.00 $6,750.00 $6,750.00 $10,000.00 $10,00.00 10 Furnish andir linstallallabor, materials, supplies, tools, equipment, transportation, andappurten enancestoRelocater rofhathtoprovider minimum of7" clearancef fromt the centerline ofther rungt tothe is $2.500.00 neareste edgeo ofthehatchasin indicatedin Inthasehasdulacfwekat: the endofthete technieal spedifications complete inplace $2500.00 $3,500.00 $3,500.00 $1,00.00 $1,000.00 $5,000.00 $5,000.00 $6,750.00 $6750,00 $5,000.00 $5,000.00 11 urisha andi installall labor, materials, supplies, tools, equipment, rar ortation, and appurtenancest Remove interior rcoatingbyabrasivet Hiastingalsurtacastonear. rwhiteconditon. (SSPCSP 10)as Ls $50,750.00 $50,750.00 $55,00000 $55,000.00 $80,00.00 ahwsaastaawrssasaaNw completeinple.perv unit: $80,00000 $126,800.00 $125,800.00 $104,000.00 $104,000.00 $100,000.00 $100,000.00 12 Eumisha andi installallabor, materials, supplies, tools, equipment, transportation, and appurtenancest stoRecoattanki interior with h100Ks solids, ovoc,e elastomeric, aromatic polyurethaneh hybridcoating LS (Carboline Reactamine7 760)orapprovede equal asindicatedin inthes Schedule ofv Worka atthee endofthet technicals Ispedifications, completeir inplace, per unit: $50,000.00 $50,000.00 $5670000 $56,700.00 $70,00.00 $70,000.00 $58,600.00 $58,600.00 $85,000,00 $85,00.00 $150,000.00 $150,000.00 13 Furnisha andinstallallabor, materials, supplies, tool, equipment transportation,a andasputenimastointaie Bilingual 10"x14"" "ConfinedSpace. EntrybyP PermitOnly's signon manwaya access hatches 1is $750.00 $750.00 $500.00 $500.00 $500.00 $500.00 $400.00 $400.00 asindkatedinthes - completeinglace. Peru unit: $1.350.00 $1,350.00 $500.00 $500.00 14 Furmish: andir installall labor, materials, supplies, tools, equipment, transportation, andappurtenancest to Disinfect Tank asindicatedinthes Scheduled of Work atthee endofthet technitalsperftetions 1s $2500.00 $2,500.00 $2,500.00 completeinplace. per unit: $2,500.00 $1,000.00 $1,000.00 $2,400.00 $2400.00 $2500.00 $2500.00 $5,000.00 $5,000.00 15 Furnisha andir installalll labor, materials, supplies, tools, equipment, transportation, and Ma--awA Schedule ofWorkat tthee endofthetechnicals Ispecfications, 1s $2,500.00 $2,500.00 $7,500.00 $7,500.00 Icompleteinplece Perunit: $6,00000 $5,00.00 $4,700.00 $4.700.00 $8,100.00 $8,100.00 $15,000.00 $15,000.00 Llanol LawE Enforcemente 6STTotat $182,500.00 $284,300.00 $330,500.00 345,600.00 $404572.00 $572,500.00 LanolawE LABMeEGIBANANE Maguire DEMTank MKPainting VkingPainting Blastco Item NGPainting nemp Deseription umntuntPnte TotalPrice UnitPrice TotalPice UniePrice TotalPite UnmitPrice TotalPrice UntPice TotalPrite UnitPice andi TotalPrice 3A Fumisha linstallallabor, materials, supplies, tools, equipment, transportation, and lappurtenancesto Recoat tank cexterior withal Tnemee exterior coating system asindicatedi inthe ScheduleofWork 1 LS $27500.00 atterndethat technicals IsPecifications completeinplace. per unit: $27,500.00 $47,550.00 $47,550.00 $65,000.00 $65,000.00 $25,00.00 $25,000.00 $94,000.00 $94,000.00 $240,000.00 $240,000.00 12A Furisha andir installal all labor, materials, supplies, tools, equipme ent, transportation, and apputenancestoRecost ttanki interior with aTnemec interior coating system asi indicatedin thes Scheduleofv fWork 1 LS $45,000.00 attheendofthet tachnialsPedfieations. completeinplace. per unit: $45,000.00 $81700.00 $31,700.00 $90,000.00 $90,000.00 $31,000.00 $31,000.00 $81,000.00 $81,000.00 $250,000.00 $250,000.00 LanolawE Enforcement ATEmAEEsT Total: 72,500.00 $79250.00 $155,000.00 156,000.00 $175,00,00 $490,000.00 LlanolawE EnforcementA AlternativeBidT Totall $182,500.00 $259550.00 $370,50000 132,10.00 $426,572.00 $812,500.00 CITY COUNCIL AGENDA 1/6/25 Agenda Item: E4 9 Item/Subject: Discussion and possible action regarding an amendment to Ordinance No. 1546 regarding the Budget for FY 2024-2025. Initiating Department/Presenter: Cara Hewitt, Finance Director Recommended Motion: Move to adopt Ordinance No. 1546 to amend the budget for FY 25. Background/History: Each fund was reviewed by the Finance Director. The amendments are necessary to reflect the actual activity that has occurred in each department and the passage of the comprehensive compensation plan. Findings/Current Activity: Financial Implications: The amendments will have an effect on each fund in the following manner. The General fund will have expenses over revenues of $90,105, the utility fund expenses of revenues of $40,000 and the council restricted fund expenses over revenues of $20,000. Associated Information: Ordinance No 1546 Exhibit "A, B, & C" Agenda Item #E4 CITYOFI LLANO ORDINANCENO. 1546 AN ORDINANCE OF THE CITY OF LLANO APPROVING AND ADOPTING AN AMENDMENT TO THE GENERAL FUND AND UTILITIES FUND BUDGETS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2024, AND ENDING ON SEPTEMBER 30, 2025 WHEREAS, on September 16, 2024, the City Council oft the City ofLlano (Council) adopted Ordinance No. 1537 approving a budget for the current fiscal year beginning October 1, 2024, and ending September 30, 2025; and WHEREAS, the City Council finds and determines it is prudent to amend the budget due to unforeseen conditions that have occurred in the City; and WHEREAS, circumstances have arisen during the fiscal year which have, or will, require the expenditure of additional funds in some of the line items in the budget, and for which there is more than adequate funding in other line items of the budget; and WHEREAS, the City Council now finds it in the best interest of the City of Llano and its residents to amend the adopted budget for the General Fund, Utilities Fund and Council Restricted Fund as set forth in respective Exhibit "A" based on the review and analysis provided by the Finance Director. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF LLANO, TEXAS: I. That the City Council of the City of Llano hereby approves the General Fund and Utilities Fund budget amendments for the current fiscal year beginning October 1, 2024, and ending September 30, 2025, attached hereto as Exhibit "A,B, & C". II. This Ordinance shall take effect and be in force from and after its approval and publication, as may be required by law. III. Should any part of this Ordinance be declared invalid, for any reason, such invalidity shall not affect the remainder oft this Ordinance. III. It is hereby officially found and determined that the meeting at which this Ordinance was passed was open to the public and that public notice oft the time, place, and purpose of said meeting was given as required by the Open Meetings Act, Chapter 551 of the Texas Government Code. ADOPTED AND APPROVED on this 6th day of January, 2025 by a vote of the City Council of the City ofLlano, Texas. Attest: CITY OF LLANO, TEXAS Kim Wagner, City Secretary Marion Bishop, Mayor EXHIBIT A CITY OF LLANO FY 2025 GENERAL: FUND BUDGET AMENDMENT Current Budget Revised Account Code Account Title Budget Amendment Budget Comment REVENUES 4605 Grant Procees 74,000 74,000 Police Dept grant 74,000 TOTAL REVENUES 74,000 74,000 EXPENDITURES POLICE 50300-436 Grant Expense 74,000 74,000 PD grant 74,000 STREETS 10-50800-615 Capital Outlay vehicles 60,000 90,105 150,105 Dump Truck carried over from FY24 90,105 TOTAL EXPENDITURES 60,000 164,105 224,105 REVENUES OVER EXPENDITURES (90,105) EXHIBIT B CITY OF LLANO FY 2025 UTILITY FUND BUDGET AMENDMENT Current Budget Revised Account Code Account Title Budget Amendment Budget Comment REVENUES TOTAL REVENUES EXPENDITURES ELECTRIC 51400-426 Professional Fees 86,000 40,000 126,000 Addtl contractor funds approved 11/18 40,000 TOTAL EXPENDITURES 86,000 40,000 126,000 REVENUES OVER EXPENDITURES (40,000) EXHIBIT C City ofLlano FY 2025 COUNCIL RESTRICTED FUND BUDGET AMENDMENT Current Budget Revised Account Code Account Title Budget Amendment Budget Comment REVENUES EXPENDITURES 22-51325-426 Professional Fees 95,000 20,000 115,000 Cap Improv Plan increase in price approved 12/16 20,000 TOTAL EXPENDITURES 95,000 20,000 115,000 REVENUES OVER EXPENDITURES (20,000) CITY COUNCIL AGENDA 1/6/25 Agenda Item: E5 a Item/Subject: Discussion and possible action regarding the purchase of upgraded VFD Control Panel, new manifold and hydro tank removal. Initiating Department/Presenter Marty Mangum, City Manager Recommended Motion: Background/Hstory: This year we replaced a water well at the golf course that burned out after replacement in less than 24 hours. The replacement pump was covered under warranty; however, it was determined that part of the problem was that our clay valve was faulty. The clay valve allows water pressure to ramp up in the system rather than being high suddenly. With a faulty clay valve, the water pressure hits the system. suddenly causing a water. surge that can damage pumps and pipes. We can obtain a clay valve to replace in our. system, but there is evidently one person in the United States that can program the valve as it is an obsolete method to control water pressure in an irrigation system. Unfortunately, that one person is not responsive to our telephone calls and is showing no interest in helping us program a new clay valve. The new method to control water. surge is by utilizing a Variable Frequency Drive that allows the pumps to ramp up or to increase in velocity gradually. One of the benefits of this method is that it will allow the pumps to run faster or. slower depending on the demand rather than running at 100% power all of the time. This will obviously allow for electrical. savings. Another benefit is savings in personnel cost of repairing water leaks caused by the water surge or hammer when the pumps come on. The total cost of this conversion is $138,698.00. The same system with a total new skid will run $151,637. Findings/Current Activity: Financial Implications: OThere is no financial impact associated with this item. item is budgeted: In the amount of $ (amount in the budget account) XItem is not budgeted: JItem is estimated to generate additional revenue: Associated Information: Agenda Item # E5 Pump Mechanical Technical Services, LLC DATE: 12/19/23 BUYBOARD # 672-22 TO: Scott McDonough /Director of Golf and Allen Hopson / Consultant Reference: Llano River Club / City of Llano *ALL NEW PUMP STATION LESS PUMPS AND MOTORS (re-use customers) PROJECT SITE PARAMETERS Wetwell Depth: N/A Wetwell Dimensions: 72 IN Inlet Condition: WETWELL Supply Power: 480V 3PH 60HZ Pump Station Requirements: 1400 GPM AT 125 PSI AT STATION DISCHARGE SCOPE OF SUPPLY MCI ULI Listed QCZJ Packaged Pump Station Model Number: PPS-N-VT3-1400-125-DV-P-48-3-6 Built Under 1S09001:2015 Certification Main Control Panel Custom Enclosure UL5 508a Listed Control Panel Custom Engineered & Manufactured in Same Facility as Pump Station Watertight UL Type 4 Enclosure 72 IN x 72 IN X 18 IN (HxWxD), Final Panel Size Confirmed in Approval Drawings 12 ga. Mild Steel Construction with Self-Healing Zinc Primer and Superior Outdoor Rated Powder Coated Textured Finish Heavy Duty Concealed Hinge /3 3- Point Latch with Handle (Pad Lock Capable), Easily Removeable Doors and Center Post for Servicing Rigid Steel Backplate with Pure White Powder Coat Stainless Steel Doorstop(s), (Standard on AlL Doors) 12IN Data Pocket Containing AlL Pertinent Panel Documentation and As Built Drawings for Easy in Field Reference Manufactured in the USA Cooling/Heating QTY (1) UL Listed Air Conditioning Unit for Clean, Precise, and Consistent Internal Temperature Regulation for Increased Electrical Component Longevity Main Power 400-Amp Main Fused Disconnect to Protect Valuable and Critical Components from Overloads and Abnormal Supply Power Conditions Industry Leading Short Circuit Current Rating (SCCR) of 100,000 Amps to Impede Catastrophic Failure Type 1 Surge Protection w/Status Indicators for Safeguarding of Electrical System Against Destructive Transient Power Surges Active Incoming Line Phase Monitor W/Primary Fusing for Detection of Voltage Imbalance, Phase Sequence, and Loss of Phase Regulated & Adjustable DC Power Supply for Safe User Operation and Stable Clean Power to Control Processing Components GFCI Outlet for Convenient Laptop Power Robust Industrial Control Power Transformer w/Primary Fusing Pump/Motor Control/Power Control & Power for QTY (2) 60 HP Main Pump/Motor with Dedicated VFD Operation Green lluminated Off/On Switch with Running and Blinking Fault Indication Pump/Motor Running Feedback Wired for Motor Space Heater Variable Frequency Drive Operation High Accuracy Pump/Motor Speed Control Manual VFD Speed Pot Equipped With Input Impedance Per VFD for Smooth, Stable, & Consistent Power Fast Acting Fusing for' VFD Protection VFD Fault with Auto Restart 6-Year Warranty on VFD Including Coverage Against Damages from Momentary Line or Load Anomalies such as Lightning Strikes. Control & Power for QTY (1) 25 HP Jockey Pump/Motor with Dedicated VFD Operation Green lluminated Off/On Switch with Running and Blinking Fault Indication Pump/Motor Running Feedback Wired for Motor Space Heater Variable Frequency Drive Operation High Accuracy Pump/Motor Speed Control Manual VFD Speed Pot Equipped With Input Impedance Per VFD for Smooth, Stable, & Consistent Power Fast Acting Fusing for' VFD Protection VFD Fault with Auto Restart 6-Year Warranty on VFD Including Coverage Against Damages from Momentary Line or Load Anomalies such as Lightning Strikes. Control Features & Hardware MCI MPC Platform Allen Bradley Compactlogix Fast Processing Robust PLC for Self-Sufficient Automatic Operation Allen Bradley 10IN Panelview High Resolution Display with Intuitive Color Operator Control and Monitoring of Critical Processes System "Full Size" Type 4 Operator Control Devices ManuaV/Off/Auto System Control Red lluminated Fault Push Button Blue lluminated Maintenance Light PLC Flow Adjustable Fertigation Run Relay with Dry Contacts System Safeties: Main Inlet Safety Low Level Shutdown w/Auto Reset Low Discharge Pressure Shutdown/Hard Fault High Discharge Pressure Shutdown w/Auto Restart Phase Failure, Imbalance, and Low' Voltage Protection Operation Features Door Device Lamp Test Function Automatic Alternation of Pumps Based on Least Run Time Intelligent Slow Ramp Feature for Automatic Line Fill 3-Year Flow Total Logging DayweekMonthear Pump Run Times Event Log Flow and Station Trending Assignable I/O Multi-Parameter Adjustable Pump Station Lockout Lockout Parameters: "Individualized Day/Time Settings* a Pressure Setpoint/Max D External Input a Max Number of Pumps Allowed D Power Consumption D Max' VFD Speed Lake Level Control Hand/Off/Auto Selector Switch Sensor Included in System Instrumentation Section MCI Remote Cell Monitoring w/1 Year Activation (Cell Service Starts When Equipment Ships from MCI) nSite, MCI's Cloud Based Solution NO SUBSCRIPTION FEE Scheduled Monthly Email with Flow Report in Excel Format Access To One Full Year of Pressure, Flow, Alarms and Event Data Remote Pump Station Disable Feature from Any Smart Device Or PC Factory Support Remote Access to PLC/HMI and VFD for Programming and' Troubleshooting nAlert Manage Maintenance Due Dates for AlL Aspects of Maintenance on Your Pumping Station Warning Light, Display Message and Email Alert When Due Monitor and Report Irregular Operation of Irrigation System, Pump System and Filter System System Instrumentation 316SS Low Level Probe Set with PNR Relay Discharge Pressure Transducer 316SS Multi-output Programmable Pressure Transducer, with Local Display, Protective Display Cap, and Cord Set Submersible Level Transducer 0-34.6' 316SS Level Transducer with Filter, Extra Weight, and 60 FT Cable 41 IN 316SS Pressure Gauges with Full Body 316SS Monolithic Block and Bleed Valves Magmeter 6IN Networkable Magnetic Flowmeter with Local Flow Display, Fertigation Frequency Output Prewired to Panel Terminals, Corrosion Resistant NSF-61 Approved Lining, Flanged Connections, and Precise 0.5% Flow Measurement Accuracy Pump Assemblies QTY (2) 60 HP Vertical Turbine MAIN Pump. To Include: O PUMP & MOTOR EXISTING VALVES 6IN Full 316SS Grooved Pump Discharge solation Valve w/ Lever Actuator Offering Vibration Minimization and Increased Installation/Service Flexibility 61 IN Pump Silent Wafer Check Valves with Corrosion and Abrasion Resistant Fusion Bonded Epoxy, SS Disc, and leavy-Duty Spring to Reduce Hydraulic Shock QTY (1) 25 HP Vertical Turbine JOCKEY Pump. To Include: O PUMP & MOTOR EXISTING VALVES 4 IN Full 316SS Grooved Pump Discharge solation Valve w/ Lever Actuator Offering Vibration Minimization and Increased Installation/Service Flexibility 4 IN Pump Silent Wafer Check Valves with Corrosion and Abrasion Resistant Fusion Bonded Epoxy, SS Disc, and Heavy-Duty Spring to Reduce Hydraulic Shock Station Isolation Valving 61 IN Station Discharge Isolation Butterfly Valve w/Lever Operator, Corrosion- Inhibiting 316SS Disc and EPDM Elastomers, Abrasion Resistant Fusion Bonded Body, and 250PSI Bubble Tight Shutoff Capacity 316SS Threaded Ball Valves, 1.5IN and Below Station Pressure Relief Valve Fusion Bonded Epoxy Cla-Val 50-01 4 IN Station Pressure Relief Valve with Corrosion Mitigating 316SS Internals, Bronze Piloting, Piped to Wet Well with solation Butterfly' Valve w/Lever Operator, SS Disc, EPDM Elastomers, and Bonnet Quick Air Purge Ball Valve Skid Reinforced, Custom, Carbon Steel Pump Skid Fabricated Using Heavy Duty, High Strength Structural Channel, Tubing, and Plate Fully Seal Welded Pump Skid Deck Plate Integral High Thrust Structural Pipe Supports 1-Inch-Thick VT Pump Plate Over Wet Well to Provide Maximum Support and Vibration Dampening During Operation Removeable, Heavy-Duty Wet Well Access Hatch with Stainless Steel Hinges for Serviceability Self-healing, Corrosion Reducing, Zinc Powder Coat Primer Multi-Step, Thermally Cross-Linking, Non-slip Skid Powder Coating for Structural Protection and Operator Safety Corrosion and Wear Resistant Zinc Hardware RAISED PUMP PLATFORM Station Piping Carbon Steel Station Piping Custom Formulated, Electrostatically Adhering, Thermally Cross-Linking, Fusion Bonded Epoxy Coating NSF 61 Certified, Drinking Water Safe, Fusion Bonded Epoxy Coating Extreme Resistance to Corrosive Water and Harsh Chemicals AlL Piping Above 2IN Shall Be Both Internally and Externally Coated Piping Below 2IN shall be 304SS Hose Bibb Connection for Handy, Pressurized Water Access Corrosion and Wear Resistant Zinc Hardware Equipment ONLY PRICE: $ 136,337.00 Freight: $ 2,500.00 PMTS DEMO-SET START $ 12,800.00 Pricing Does NOT Include SALES TAX FOB: Dallas, Texas 50% PRODUCTION DEPOSIT DUE WITH SIGNED ORDER, BALALNCE DUE ON COMPLETION Lead Time: Drawings for Approval: 6Weeks ARO Production: 16 - 18 Weeks ARAD MCI Flowtronex reserves the right to substitute alternate products for any named brand products based on availability. Warranty Items 6-year warranty on Variable frequency drive (Includes Lightning Damage Coverage and Labori to Replace) 6-Year Warranty on ALL COMPONENTS IN ELECTRICAL PANEL, Inclusive of power related damage such as lightning. Includes parts only. 2-year warranty on Station. *CUSTOMER RESPONSIBLE FOR ANY PERMITS IF REQUIRED. *CUSTOMER RESPONSIBLE FOR CRANE SERVICE TO REMOVE EXISTING PUMP AND MOTORS AND RE-INSTALL DUE TO LENGTH. PMTS SCOPE: *PMTS REQUIRES 1 DAY SHUT DOWN FOR CHANGE OUT PROCESS. *PMTS WILL CUT AND REMOVE OBSOLETE PUMP STATION WITH PMTS CRANE *PMTS WILL SET NEW SKID WITH PMTS *PERFORM FULL FLOW TESTING, TUNING AND OWNER TRAINING Seller warrants that the water pumping system or components will be free of defects in Materials and workmanship for 1 year from date of authorized start-up but not later than 15 months from date of invoice; Provided that all installation and operation responsibilities have been properly performed and documented. Seller will provide a replacement part or component during the warranty life This proposal contains equipment that may require costly means to remove or replace based on site conditions. Seller will not accept liability for costs associated with the removal or replacement of equipment in difficult to access locations. This includes but is not limited to the use of diving services, barges, helicopters, or other unusual requirements. Default of any agreement with Seller or; a. The misuse, abuse of the pumping package outside its intended use. b. Failure to perform required maintenance service. C. Pumping water is not suitable for irrigation. d. Exposure to electrolysis erosion. e. Water salinity in excess of 2000 parts per million. f. Water from a reverse osmosis plant without countermeasures in place. g. Water with a Langelier Index less than -0.5 and greater than +1.5 h. The presence of destructive gaseous or chemical solutions in or around the packaged system. 1. Customer driven delays of 6 months or more are subject to a pricing review. 2. The parties explicitly agree that liquidated damages shall not be applicable or accepted in any circumstance arising out of or in connection with the project by Motor Controls Inc. /PMTS. Liquidated damages, penalties, or similar charges imposed for delays, defaults, or any other reason, shall not be considered valid, and the purchasing party expressly waives their rights to seek or enforce such damages against Motor Controls Inc./PMTS unless a written and signed approval from MCI/PMTS has been obtained. 3. The terms contained herein may be modified only by written agreement signed by Buyer and an officer of Seller, PMTS. (If non-taxable please provide tax exempt certificate for the INship-tolN state) **Please fill out fields below and return all pages. ** Date: Total Purchase Amount: Buyers Name: Buyers Signature: Email Order Confirmation To: Requested Ship Date: Deliver To: Delivery Address: City: State: Zip: Delivery Contact Name: Delivery Contact Number: Delivery Contact Email: Attentively, Ric Martinez Sr. Pump Mechanical Technical Services Ric @PMTService.com (512) 743-7867 Billing PO Box 1566 San Marcos, TX 78667 Physical 5185 N. Hwy 123 Seguin, TX 78155 (830) 4317181 Pump Mechanical Technical Services, LLC DATE: 12/05/23 BUYBOARD # 672-22 TO: Scott McDonough Director of Golf and Allen Hopson I Consultant Reference: Llano River Club / City of Llano *ALL VFD CONTROL PANEL UPGRADE TO REPLACE OBSOLETE PANEL PROJECT SITE PARAMETERS Inlet Condition: WETWELL Supply Power: 480V 3PH 60HZ Pump Station Requirements: 1400 GPM AT 125 PSI AT STATION DISCHARGE SCOPE OF SUPPLY Built Under 1S09001:2015 Certification Main Control Panel Custom Enclosure UL 508a Listed Control Panel Custom Engineered & Manufactured in Same Facility as Pump Station Watertight UL Type 4 Enclosure 72 IN X 72 IN X 18 IN (HxWxD), Final Panel Size Confirmed in Approval Drawings 12 ga. Mild Steel Construction with Self-Healing Zinc Primer and Superior Outdoor Rated Powder Coated Textured Finish Heavy Duty Concealed Hinge / 3- Point Latch with Handle (Pad Lock Capable), Easily Removeable Doors and Center Post for Servicing Rigid Steel Backplate with Pure White Powder Coat Stainless Steel Doorstop(s), (Standard on All Doors) 12IN Data Pocket Containing All Pertinent Panel Documentation and As Built Drawings for Easy in Field Reference Manufactured in the USA Cooling/Heating QTY (1)ULI Listed Air Conditioning Unit for Clean, Precise, and Consistent Internal Temperature Regulation for Increased Electrical Component Longevity MainPower 400-Amp Main Fused Disconnect to Protect Valuable and Critical Components from Overloads and Abnormal Supply Power Conditions Industryl Leading Short Circuit Current Rating (SCCR) of 100,000 Amps to Impede Catastrophic Failure Type 1 Surge Protection w/Status Indicators for Safeguarding of Electrical System Against Destructive Transient Power Surges Active Incoming Line Phase Monitor W/Primary Fusing for Detection of Voltage Imbalance, Phase Sequence, and Loss of Phase Regulated & Adjustable DC Power Supply for Safe User Operation and Stable Clean Power to Control Processing Components GFCI Outlet for Convenient Laptop Power Robust Industrial Control Power Transformer w/Primary Fusing Pump/Motor Control/Power Control & Power for QTY (2) 60 HP Main Pump/Motor with Dedicated VFD Operation o Green lluminated Off/On Switch with Running and Blinking Fault Indication Pump/Motor Running Feedback Wired for Motor Space Heater Variable Frequency Drive Operation High Accuracy Pump/Motor Speed Control Manual VFD Speed Pot Equipped With Input Impedance Per VFD for Smooth, Stable, & Consistent Power Fast Acting Fusing for VFD Protection VFD Fault with Auto Restart 6-Year Warranty on VFD Including Coverage Against Damages from Momentary Line or Load Anomalies such as Lightning Strikes. Control & Power for QTY (1) 25 HP Jockey Pump/Motor with Dedicated VFD Operation Green Iuminated Off/On Switch with Running and Blinking Fault Indication Pump/Motor Running Feedback Wired for Motor Space Heater o Variable Frequency Drive Operation High Accuracy Pump/Motor Speed Control Manual VFD Speed Pot Equipped With Input Impedance Per VFD for Smooth, Stable, & Consistent Power Fast Acting Fusing for VFD Protection VFD Fault with Auto Restart 6-Year Warranty on VFD Including Coverage Against Damages from Momentary Line or Load Anomalies such as Lightning Strikes. Control Features & Hardware MCI MPC Platform o Allen Bradley Compactlogix Fast Processing Robust PLC for Self-Sufficient Automatic Operation Allen Bradley 10IN Panelview High Resolution Display with Intuitive Color Operator Control and Monitoring of Critical Processes System "Full Size" Type 4 Operator Control Devices o Manuav/Oft/Auto System Control Red Illuminated Fault Push Button Blue lluminated Maintenance Light PLCI Flow Adjustable Fertigation Run Relay with Dry Contacts System Safeties: o Main Inlet Safety Low Level Shutdown w/Auto Reset o Low Discharge Pressure Shutdown/Hard Fault High Discharge Pressure Shutdown w/Auto Restart Phase Failure, Imbalance, and Low Voltage Protection Operation Features Door Device Lamp Test Function Automatic Alternation of Pumps Based on Least Run Time O Intelligent Slow Ramp Feature for Automatic Line Fill O - 3-Year Flow Total Logging Day/week/Monthear Pump Run Times O Event Log Flow and Station Trending Assignable I/O Mutti-Parameter Adjustable Pump Station Lockout Lockout Parameters: "Individualized Day/Time Settings* o Pressure Setpoint/Max a External Input a Max Number of Pumps Allowed o Power Consumption a Max VFD Speed Lake Level Control O Hand/Off/Auto Selector Switch Sensor Included in System Instrumentation Section MCI Remote Cell Monitoring w/1 Year Activation (Cell Service Starts When Equipment Ships from MCI) nSite, MCI's Cloud Based Solution NO SUBSCRIPTION FEE Scheduled Monthly Email with Flow Report in Excel Format Access To One Full Year of Pressure, Flow, Alarms and Event Data Remote Pump Station Disable Feature from Any Smart Device Or.PC Factory, Support Remote Access to PLC/HMI and VFD for Programming and" Troubleshooting nAlert Manage Maintenance Due Dates for AlL Aspects of Maintenance on Your Pumping Station Warning Light, Display Message and Email Alert When Due Monitor and Report Irregular Operation of Irrigation System, Pump System and Filter System System Instrumentation 316SS Low Level Probe Set with PNR Relay Discharge Pressure Transducer 316SS Multi-output Programmable Pressure Transducer, with Local Display, Protective Display Cap, and Cord Set Submersible Level Transducer 0-34.6' 316SS Level Transducer with Filter, Extra Weight, and 60 FT Cable Equipment ONLY PRICE: $ 84,937.00 Freight: $ 1,500.00 6" FLOW MAG METER $ 5,600.00 PMTS. DEMO-SET. START $ 9,600.00 PMTS CRANE: NO CHARGE Pricing Does NOT Include SALES TAX FOB: Dallas, Texas 50% PRODUCTION DEPOSIT DUE WITH SIGNED ORDER, BALALNCE DUE ON COMPLETION MCI Flowtronex reserves the right to substitute alternate products for any named brand products based on availability. Warranty Items 6-year warranty on Variable frequency drive (Includes Lightning Damage Coverage and Labort to Replace) 6-Year' Warranty on ALL COMPONENTS IN ELECTRICAL PANEL, Inclusive of power related damage such as lightning. Includes parts only. *CUSTOMER RESPONSIBLE FOR ANY PERMITS IF REQUIRED. PMTS SCOPE: *PMTS REQUIRES 1 DAY SHUT DOWN FOR CHANGE OUT PROCESS. *PMTS WILL CUT AND REMOVE OBSOLETE CONTROL PANEL WITH PMTS CRANE *PMTS WILL SET NEW ALL VFD CONTROL PANEL WITH PMTS *PERFORM FULL FLOW TESTING, TUNING AND OWNER TRAINING Seller warrants that the water pumping system or components will be free of defects in Materials and workmanship for 1 year from date of authorized start-up but not later than 15 months from date of invoice; Provided that all installation and operation responsibilities have been properly performed and documented. Seller will provide a replacement part or component during the warranty life This proposal contains equipment that may require costly means to remove or replace based on site conditions. Seller will not accept liability for costs associated with the removal or replacement of equipment in difficult to access locations. This includes but is not limited to the use of diving services, barges, helicopters, or other unusual requirements. Default of any agreement with Seller or; a. The misuse, abuse of the pumping package outside its intended use. b. Failure to perform required maintenance service. C. Pumping water is not suitable for irrigation. d. Exposure to electrolysis erosion. e. Water salinity in excess of 2000 parts per million. f. Water from a reverse osmosis plant without countermeasures in place. g. Water with a Langelier Index less than -0.5 and greater than +1.5 h. The presence of destructive gaseous or chemical solutions in or around the packaged system. 1. Customer driven delays of 6 months or more are subject to a pricing review. 2. The parties explicitly agree that liquidated damages shall not be applicable or accepted in any circumstance arising out of or in connection with the project by Motor Controls Inc. /PMTS. Liquidated damages, penalties, or similar charges imposed for delays, defaults, or any other reason, shall not be considered valid, and the purchasing party expressly waives their rights to seek or enforce such damages against Motor Controls Inc./PMTS unless a written and signed approval from MCI/PMTS has been obtained. 3. The terms contained herein may be modified only by written agreement signed by Buyer and an officer of Seller, PMTS. (If non-taxable please provide tax exempt certificate for the INship-tolN state) **Please fill out fields below and return all pages. ** Date: Total Purchase Amount: Buyers Name: Buyers Signature: Email Order Confirmation To: Requested Ship Date: Deliver To: Delivery Address: City: State: Zip: Delivery Contact Name: Delivery Contact Number: Delivery Contact Email: Attentively, Ric Martinez Sr. Pump Mechanical Technical Services Ric @PMTService.com (512) 743-7867 Billing PO Box 1566 San Marcos, TX 78667 Physical 5185 N. Hwy 123 Seguin, TX 78155 (830) 4317181 Pump Mechanical Technical Services, LLC DATE: 12/05/23 BUYBOARD # 672-22 TO: Scott McDonough /Director of Golf and Allen Hopson I Consultant Reference: Llano River Club / City of Llano Golf Station Pumps Manifold Hydro tank Removal UPGRADE SCOPE OF SUPPLY Station Pressure Relief Valve Fusion Bonded Epoxy Cla-Val 50-01 3IN Station Pressure Relief Valve with Corrosion Mitigating 316SS Internals, Bronze Piloting, Piped to Wetwell with Isolation Butterfly Valve w/Lever Operator, SS Disc, EPDM Elastomers, and Bonnet Quick Air Purge Ball Valve Station Piping Carbon Steel Station Piping 10IN Discharge Manifold 6IN Flowmeter Spool Custom Formulated, Electrostaticaly Adhering, Thermally Cross-Linking, Fusion Bonded Epoxy Coating NSF 61 Certified, Drinking Water Safe, Fusion Bonded Epoxy Coating Extreme Resistance to Corrosive Water and Harsh Chemicals All Piping Above 2IN Shall Be Both Internally and Externally Coated Piping Below 2IN shall be 304SS Hose Bibb Connection for Handy, Pressurized Water Access Corrosion and Wear Resistant Zinc Hardware Lead Time: 16-18 Weeks Following Approved Drawings Deposit: Production Deposit 50%, Balance Based due on completion. Applicable Taxes shall be Added to the Final Order Invoice Amount Unless a Valid Resale Certification has been Provided at the Time of Order or is Already on File. Taxes are Not Included in Preceding Order Prepayments. *50% PRODUCTION DEPOSIT DUE WITH SIGNED ORDER, BALALNCE DUE ON COMPLETION Equipment ONLY PRICE: $ 25,961.00 Freight: $ 1,500.00 PMTS DEMO-SET START $ 9,600.00 PMTS CRANE: NO CHARGE Pricing Does NOT Include SALES TAX FOB: Dallas, Texas MCI Flowtronex reserves the right to substitute alternate products for any named brand products based on availability. Additional Warranty items 2-year warranty on Station CUSTOMER MUST PROVIDE ADEQUATE ACCESS VIA DOORS OR ROOF FOR REMOVAL OF OBSOLETE TANK AND PIPING SKID FOR INSTALL OF NEW MANIFOLD ON PUMP SKID. *CUSTOMER RESPONSIBLE FOR ANY PERMITS IF REQUIRED. PMTS SCOPE: *PMTS REQUIRES 1-2 DAY SHUT DOWN FOR CHANGE OUT PROCESS. *PMTS WILL CUT AND REMOVE OBSOLETE HYDRO TANK AND CLAVALVE WITH PMTS CRANE *PMTS WILL SET NEW MANIFOLD PIPING ASSEMBLY WITH PMTS CRANE FROM EXISTING PUMPS, CV's AND Iso-VALVING TO NEW STATION DISCHARGE ISOLATION VALVE, RE-USING CUSTOMERS PUMPS CHECK VALVES AND ISO VALVES. ADDITONAL EQUIPMENT NOT INCLUDED ABOVE: *NEW PUMP Grooved Iso-Valves, Flanges, Gaskets, hardware for proper individual isolation of pumps as needed. $3,700.00 Seller warrants that the water pumping system or components will be free of defects in Materials and workmanship for 1 year from date of authorized start-up but not later than 15 months from date of invoice; Provided that all installation and operation responsibilities have been properly performed and documented. Seller will provide a replacement part or component during the warranty life This proposal contains equipment that may require costly means to remove or replace based on site conditions. Seller will not accept liability for costs associated with the removal or replacement of equipment in difficult to access locations. This includes but is not limited to the use of diving services, barges, helicopters, or other unusual requirements. Default of any agreement with Seller or; a. The misuse, abuse of the pumping package outside its intended use. b. Failure to perform required maintenance service. C. Pumping water is not suitable for irrigation. d. Exposure to electrolysis erosion. e. Water salinity in excess of 2000 parts per million. f. Water from a reverse osmosis plant without countermeasures in place. g. Water with a Langelier Index less than -0.5 and greater than +1.5 h. The presence of destructive gaseous or chemical solutions in or around the packaged system. 1. Customer driven delays of 6 months or more are subject to a pricing review. 2. The parties explicitly agree that liquidated damages shall not be applicable or accepted in any circumstance arising out of or in connection with the project by Motor Controls Inc. /PMTS. Liquidated damages, penalties, or similar charges imposed for delays, defaults, or any other reason, shall not be considered valid, and the purchasing party expressly waives their rights to seek or enforce such damages against Motor Controls Inc./PMTS unless a written and signed approval from MCI/PMTS has been obtained. 3. The terms contained herein may be modified only by written agreement signed by Buyer and an officer of Seller, PMTS. (lf non-taxable please provide tax exempt certificate for the INship-tolN state) **Please fill out fields below and return all pages. ** Date: Total Purchase Amount: Buyers Name: Buyers Signature: Email Order Confirmation To: Requested Ship Date: Deliver To: Delivery Address: City: State: Zip: Delivery Contact Name: Delivery Contact Number: Delivery Contact Email: Attentively, Ric Martinez Sr. Pump Mechanical Technical Services Ric @PMTService.com (512) 743-7867 Billing PO Box 1566 San Marcos, TX 78667 Physical 5185 N. Hwy 123 Seguin, TX 78155 (830) 4317181 MC/ FLOWITRONEX John S Murtaugh Vice President, Water Products 10661 Newkirk Street Dallas, Texas 75229 M- 469-585-2198 0- 972-247-4440 May 9, 2024 To Whom it may concern: Subject: Sole Source for Flowtronex Pump Stations Flowtronex is the original equipment manufacturer. PMTS is the sole factory authorized service provider for many Southern, Central, Northern and Western Texas regions for Flowtronex Pumping Systems. Regards, John S Murtaugh Vice President, Water Products MCI Flowtronex 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY GENERAL REVENUE 2,401,347.00 187,949.25 343,827.97 14.32 2,057,519.03 FRANCHISE TAXES 102,800.00 19,900.58 4,064.21 3.95 98,735.79 LICENSES AND PERMITS 120,000.00 14,133.50 18,991.07 15.83 101,008.93 JLK EVENTS CENTER 22,500.00 2,464.70 4,714.70 20.95 17,785.30 JLK ARENA 166,500.00 3,668.00 10,447.00 6.27 156,053.00 SWIMMING POOL 25,500.00 0.00 0.00 0.00 25,500.00 GENERAL PARKS 129,900.00 8,960.00 16,786.00 12.92 113,114.00 GOLF COURSE 528,000.00 33,376.60 80,748.93 15.29 447,251.07 LANTEX THEATER 5,000.00 0.00 200.00 4.00 4,800.00 FACILITIES 68,000.00 980.07 3,904.63 5.74 64,095.37 FINANCIAL 1,954,030.00 118,662.44 240,623.46 12.31 1,713,406.54 OTHER 296,400.00 30,144.52 64,817.81 21.87 231,582.19 * TOTAL REVENUES 5,819,977.00 420,239.66 789,125.78 13.56 5,030,851.22 EXPENDITURE SUMMARY CITY COUNCIL 28,930.00 3,437.87 5,333.03 18.43 23,596.97 ADMINISTRATION 1,226,165.00 177,578.90 417,408.13 34.04 808,756.87 COMMUNITY DEVELOP/MAIN ST 113,125.00 8,818.86 17,645.14 15.60 95,479.86 POLICE 1,383,199.00 74,638.35 166,042.69 12.00 1,217,156.31 MUNICIPAL COURT 141,590.00 15,012.57 30,078.07 21.24 111,511.93 CODE ENFORCEMENT 206,180.00 17,686.18 33,039.66 16.02 173,140.34 FIRE DEPARTMENT 163,770.00 6,502.15 29,361.23 17.93 134,408.77 PARKS AND RECREATION 433,925.00 24,374.84 55,086.04 12.69 378,838.96 SWIMMING POOL 69,790.00 206.14 584.88 0.84 69,205.12 BADU RV PARK 5,800.00 26.55 327.49 5.65 5,472.51 ROBINSON RV PARK 47,770.00 2,997.08 6,065.11 12.70 41,704.89 DEPOT MUSEUM 16,050.00 230.88 3,378.76 21.05 12,671.24 JLK ARENA 330,630.00 95,387.97 117,001.46 35.39 213,628.54 LANTEX THEATER 39,165.00 2,799.70 5,292.72 13.51 33,872.28 GOLF COURSE 755,600.00 107,822.37 155,411.15 20.57 600,188.85 STREETS 1,349,590.00 122,044.08 228,924.12 16.96 1,120,665.88 ** * TOTAL EXPENDITURES 6,311,279.00 659,564.49 1,270,979.68 20.14 5,040,299.32 * REVENUES OVER/ (UNDER) EXPENDITURES ( 491,302.00) ( 239,324.83) ( 481,853.90) 98.08 ( 9,448.10) 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE GENERAL REVENUE 4101 PROPERTY TAX M & o 987,947.00 64,888.36 106,930.64 10.82 881,016.36 4102 DELINQUENT TAXES 10,000.00 1,235.58 2,409.16 24.09 7,590.84 4103 PENALTY & INTEREST 10,000.00 305.99 722.64 7.23 9,277.36 4104 OCCUPATION TAXES 10,400.00 0.00 0.00 0.00 10,400.00 4105 CITY SALE ES TAX 1,369,000.00 118,269.06 228,919.92 16.72 1,140,080.08 4107 MIXED DRINK TAX 14,000.00 3,250.26 4,845.61 34.61 9,154.39 TOTAL GENERAL REVENUE 2,401,347.00 187,949.25 343,827.97 14.32 2,057,519.03 FRANCHISE TAXES 4201 CABLE FRANCHISE TAXES 4,400.00 3,151.60 3,151.60 71.63 1,248.40 4203 ELECOMMUNIC A 1 - NS SE 12,800.00 477.47 412.61 3.22 12,387.39 4204 GAS FRANCHISE TAXES 24,000.00 0.00 0.00 0.00 24,000.00 4205 GE CHISE AXES 40,000.00 10,520.41 0.00 0.00 40,000.00 4206 CENTRAL TEXAS ELECTRIC 18,600.00 5,501.10 0.00 0.00 18,600.00 4207 TOWE ER LEASE 3,000.00 250.00 500.00 16.67 2,500.00 TOTAL FRANCHISE TAXES 102,800.00 19,900.58 4,064.21 3.95 98,735.79 LICENSES AND PERMITS 4401 LICENSES DOG 400.00 0.00 0.00 0.00 400.00 4404 ELECTRIC PERMIT FEES 13,400.00 863.84 1,362.44 10.17 12,037.56 4405 MECHZ CAL E R RMIT EES 3,000.00 1,218.81 1,592.68 53.09 1,407.32 4406 PLUMBING PERMIT FEES 5,500.00 772.68 1,198.44 21.79 4,301.56 4410 su ILDING PERMIT FEES 88,000.00 11,028.17 14,638.51 16.63 73,361.49 4411 BOARD PETITIONS 6,500.00 250.00 199.00 3.06 6,301.00 4412 PEDDLER'S PERMIT 300.00 0.00 0.00 0.00 300.00 4413 BURN PERMITS 200.00 0.00 0.00 0.00 200.00 4414 STREET & ALLEY PERMITS 100.00 0.00 0.00 0.00 100.00 4415 PLANS REVIEWS FEES 500.00 0.00 0.00 0.00 500.00 4417 CONTRACTOR REGISTRATION FEE 900.00 0.00 0.00 0.00 900.00 4418 HIGHWAY BANNER FEE 1,200.00 0.00 0.00 0.00 1,200.00 TOTAL LICENSES AND PERMITS 120,000.00 14,133.50 18,991.07 15.83 101,008.93 COMMUNITY DEVELOPMENT JLK EVENTS CENTER 4480 EVENTS CENTER RENTAL 15,000.00 2,464.70 4,714.70 31.43 10,285.30 4481 EVENTS CENTER CONCESSIONS 1,500.00 0.00 0.00 0.00 1,500.00 4483 EVENTS CENTI E R 3EEI R. SALES 6,000.00 0.00 0.00 0.00 6,000.00 TOTAL JLK EVENTS CENTER 22,500.00 2,464.70 4,714.70 20.95 17,785.30 JLK ARENA 4490 ARENA RENTAL 50,000.00 2,550.00 4,750.00 9.50 45,250.00 4491 STALL RENTALS 25,000.00 0.00 375.00 1.50 24, 625.00 4492 HAVINGS ALES 15,500.00 1,053.00 1,258.00 8.12 14,242.00 4493 TRAILER PARKING 20,000.00 0.00 385.00 1.93 19,615.00 4495 AREN NA CONC E - SSIONS 5,000.00 65.00 65.00 1.30 4,935.00 4496 ARENA BEER SALES 8,000.00 0.00 0.00 0.00 8,000.00 4497 ARENA SPONSORS 36,000.00 0.00 0.00 0.00 36,000.00 4498 ARENA MEMBERSHIPS 7,000.00 0.00 320.00 4.57 6,680.00 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND REVENUE ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 4499 JLK PRODUCED EVENTS 0.00 0.00 3,294.00 0.00 3,294.00) TOTAL JLK ARENA 166,500.00 3,668.00 10,447.00 6.27 156,053.00 SWIMMING POOL 4502 SWIMMING POOL ADMISSIONS 13,000.00 0.00 0.00 0.00 13,000.00 4503 SWII M MING POOL CONCESSIONS 5,000.00 0.00 0.00 0.00 5,000.00 4504 SWIMMING POOL PRIVATE PARTIE 3,000.00 0.00 0.00 0.00 3,000.00 4507 SWIMM I POOI L SEASON PASSES 4,500.00 0.00 0.00 0.00 4,500.00 TOTAL SWIMMING POOL 25,500.00 0.00 0.00 0.00 25,500.00 GENERAL PARKS 4510 PARK PAVI I NT S 4,500.00 0.00 0.00 0.00 4,500.00 4511 PORTABLE STAGE RENTAL 400.00 0.00 0.00 0.00 400.00 4512 EVENT ENT RENTAL 500.00 0.00 0.00 0.00 500.00 4513 RAY HOUSE RENTALS 0.00 0.00 100.00 0.00 100.00) 4514 CAMPING EES 1,500.00 20.00 180.00 12.00 1,320.00 4516 BADU RV SPACE RENTALS 12,500.00 600.00 866.00 6.93 11,634.00 4517 O B INSON RV SPACE TALS 110,000.00 8,340.00 15,640.00 14.22 94,360.00 4519 LAUNDROMAT 500.00 0.00 0.00 0.00 500.00 TOTAL ENE AL A S 129,900.00 8,960.00 16,786.00 12.92 113,114.00 GOLF COURSE 4520 GOLF COURSE DRIVING RANGE 22,000.00 1,159.62 3,035.34 13.80 18,964.66 4521 GOLF COURSE A ART RENTALS 132,000.00 8,220.15 20,826.21 15.78 111,173.79 4522 GOLF COURSE MEMBER FEES 82,000.00 6,489.99 14,072.99 17.16 67,927.01 4523 GOLF COURSE GREEN EES 165,000.00 11,664.35 27,707.39 16.79 137,292.61 4524 GOLF COURSE TOURNAMENTS 45,000.00 0.00 0.00 0.00 45,000.00 4526 GOLE MEF R C CHANDISE 16,000.00 682.30 2,130.29 13.31 13,869.71 4527 GOLF COURSE CONCESSIONS 21,000.00 961.07 2,576.87 12.27 18,423.13 4528 GOLE COURSE BOTTLED WATER 0.00 216.00 746.00 0.00 746.00) 4529 GOLF COURSE ALCOHOLIC BEVERAGE 45,000.00 3,983.12 9,653.84 21.45 35,346.16 TOTAL GOLF COURSE 528,000.00 33,376.60 80,748.93 15.29 447,251.07 LANTEX THEATER 4552 FACILITY RENTAL 5,000.00 0.00 200.00 4.00 4,800.00 TOTAL LANTEX THEATER 5,000.00 0.00 200.00 4.00 4,800.00 FACILITIES 4581 AMERICAN TOWE LEASE 19,200.00 46.68 1,734.60 9.03 17,465.40 4582 RISE BROADBAND TOWER LEASE 10,500.00 933.39 1,848.33 17.60 8,651.67 4584 POLE CONTACT FEES 37,000.00 0.00 0.00 0.00 37,000.00 4588 RIVER SAND CONVENIENCE FEES 1,300.00 0.00 321.70 24.75 978.30 TOTAL FACILITIES 68,000.00 980.07 3,904.63 5.74 64,095.37 FINANCIAL 4603 FEES IN LIEU OF TAX-UTIL 960,930.00 78,404.10 160,106.78 16.66 800,823.22 4605 GRANT PROCEEDS 500,000.00 0.00 0.00 0.00 500,000.00 4606 ADM OVERHEAD UTILITIES 483,100.00 40,258.34 80,516.68 16.67 402,583.32 4612 L FIRE IS R RICT CONTRIBUT I 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL FINANCIAL 1,954,030.00 118,662.44 240,623.46 12.31 1,713,406.54 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE OTHER FINANCING SOURCES CAPITAL OUTLAY OTHER 4701 INTEREST ON INVESTMENTS 180,000.00 13,061.91 27,680.92 15.38 152,319.08 4702 FINES 75,000.00 13,299.11 32,910.67 43.88 42,089.33 4703 CEMETERY LOTS 21,000.00 3,385.00 3,720.00 17.71 17,280.00 4705 CEMETERY OPEN & CLOSE FEES 5,400.00 250.00 250.00 4.63 5,150.00 4790 MISCELLANEOUS 15,000.00 148.50 256.22 1.71 14,743.78 TOTAL OTHER 296,400.00 30,144.52 64,817.81 21.87 231,582.19 UNTITLED * TOTAL REVENUE 5,819,977.00 420,239.66 789,125.78 13.56 5,030,851.22 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND CITY COUNCIL DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50100-101 SALARIES 9, 600.00 0.00 800.00 8.33 8,800.00 50100-104 FICA 755.00 0.00 61.20 8.11 693.80 50100-107 CLOTHING 250.00 0.00 0.00 0.00 250.00 50100-115 WORKERS COMPENSATION 25.00 0.00 0.00 0.00 25.00 TOTAL PERSO 01 NAL SERVICES 10,630.00 0.00 861.20 8.10 9,768.80 SUPPLIES 50100-201 OFFICE SUPPLIES 300.00 0.00 0.00 0.00 300.00 50100-205 OPERA Al NAL U S 600.00 0.00 21.88 3.65 578.12 50100-290 MISCELLANEOUS SUPPLIES 300.00 0.00 0.00 0.00 300.00 TOTAL SUPPLIES 1,200.00 0.00 21.88 1.82 1,178.12 MAINTENANCE AND REPAIRS 50100-307 OFFICE EQUIPMENT 2,000.00 0.00 0.00 0.00 2,000.00 TOTAL MA: ANCE AND RE IRS 2,000.00 0.00 0.00 0.00 2,000.00 SERVICES 50100-412 TRAVEL AND TRAINING 8,000.00 3,437.87 4,449.95 55.62 3,550.05 50100-420 DUES, FEES, SHIPS 600.00 0.00 0.00 0.00 600.00 50100-425 ELECTION EXPENSES 3,500.00 0.00 0.00 0.00 3,500.00 50100-426 PROFESSIONAL EES 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL SERVICES 15,100.00 3,437.87 4,449.95 29.47 10,650.05 CAPITAL OUTLAY DEPARTMENT TOTAL 28,930.00 3,437.87 5,333.03 18.43 23,596.97 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND ADMINISTRATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50200-101 SALARIES 375, 800.00 29,230.00 58,578.05 15.59 317,221.95 50200-102 LONGEVITY 900.00 41.54 78.46 8.72 821.54 50200-103 OVERTIME 3,000.00 259.17 290.26 9.68 2,709.74 50200-104 FICA 29,640.00 2,157.42 4,344.58 14.66 25,295.42 50200-105 RETI REMENT 50,030.00 3,776.98 7,567.85 15.13 42,462.15 50200-106 HEALTH INSURANCE 46,720.00 4,735.91 8,629.18 18.47 38,090.82 50200-107 CLOTHING 500.00 0.00 0.00 0.00 500.00 50200-109 LONG TERM DISABILITY 1,210.00 82.79 165.58 13.68 1,044.42 50200-111 VEHI CLE LOWANCE 7,200.00 0.00 500.00 6.94 6, 700.00 50200-115 WORKER'S COMPENSATION 2,230.00 0.00 2,730.67 122.45 500.67) 50200-117 ENTAL INSURANCE 3,640.00 324.50 649.00 17.83 2,991.00 50200-118 LIFE INSURANCE 300.00 21.12 42.24 14.08 257.76 50200-120 L OY E EE NUS 550.00 0.00 0.00 0.00 550.00 TOTAL PERSONAL SERVICES 521,720.00 40,629.43 83,575.87 16.02 438,144.13 SUPPLIES 50200-201 OFFI LC CE ES 3,300.00 637.79 1,186.21 35.95 2,113.79 50200-202 POSTAGE 6,500.00 32.75 532.75 8.20 5,967.25 50200-205 P ATI 5S 2,400.00 115.64 254.38 10.60 2,145.62 50200-290 MEETING/PARTY SUPPLIES 10,000.00 1,752.30 1,852.30 18.52 8,147.70 TOTAL SUP PPLIES 22,200.00 2,538.48 3,825.64 17.23 18,374.36 MAINTENANCE AND REPAIRS 50200-303 EQUIPMENT 200.00 0.00 0.00 0.00 200.00 50200-305 BUILDING AND GROUNDS 10,000.00 56.51 174.03 1.74 9,825.97 50200-306 RED TOP JAIL 15,000.00 0.00 0.00 0.00 15,000.00 50200-307 COPIER LEASE 0.00 590.00 1,180.00 0.00 1,180.00) TOTAL MAINTENANCE AND REPAIRS 25,200.00 646.51 1,354.03 5.37 23,845.97 SERVICES 50200-401 COMMUNICATIONS 17,500.00 1,316.64 2,848.39 16.28 14,651.61 50200-402 ELECTRIC 6,500.00 439.93 904.17 13.91 5,595.83 50200-407 TECHNOLOGY 93,000.00 90,401.85 98,205.35 105.60 ( 5,205.35) 50200-412 TR RA AVEL AND TRA NING 10,000.00 4,678.52 5,872.88 58.73 4,127.12 50200-420 DUES, FEES, AND MEMBERSHI 12,800.00 210.00) 471.10 3.68 12,328.90 50200-426 SIONAL FEES 55,000.00 196.54 14,207.98 25.83 40,792.02 50200-427 LEGAL FEES 75,000.00 5,507.00 13,912.24 18.55 61,087.76 50200-428 TAX APPRA A. SAL DISTI C CT 36,760.00 0.00 0.00 0.00 36,760.00 50200-429 TAX COLLECTION FEE 3,000.00 0.00 500.00 16.67 2,500.00 50200-430 ADVERTISING 7,500.00 366.00 579.50 7.73 6,920.50 50200-434 CONTRACT LABOR 8,000.00 660.00 1,320.00 16.50 6,680.00 50200-471 TRANSFER OUT 112,885.00 29,330.00 29,330.00 25.98 83,555.00 TOTAL SERVICES 437,945.00 132,686.48 168,151.61 38.40 269,793.39 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND ADMINISTRATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 50200-501 INSURANCE PROPERTY 149,100.00 1,078.00 160,500.98 107.65 11,400.98) 50200-503 INSUI JF ANCE BONDS 1,200.00 0.00 0.00 0.00 1,200.00 50200-525 PRINCIPAL RIGHT-TO-USE 7,600.00 0.00 0.00 0.00 7,600.00 50200-526 INTER RES T RIGHT-TO-USE LEA 1,200.00 0.00 0.00 0.00 1,200.00 50200-528 COMMUNITY SUPPORT 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL SUNDRY CHARGES 209,100.00 1,078.00 160,500.98 76.76 48,599.02 CAPITAL OUTLAY 50200-602 BUILDINGS & IMPROVEMENTS 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL CAPI TAL OUTLAY 10,000.00 0.00 0.00 0.00 10,000.00 * DEPARTMENT TOTAL 1,226,165.00 177,578.90 417,408.13 34.04 808,756.87 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND COMMUNITY DEVELOP/MAIN ST DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50250-101 SALARIES 76,540.00 5,886.96 11,773.92 15.38 64,7 766.08 50250-102 LONGEVITY 360.00 23.08 46.16 12.82 313.84 50250-104 FICA 5,890.00 429.87 860.91 14.62 5,029.09 50250-105 RETIREMENT 9,950.00 755.90 1,520.05 15.28 8,429.95 50250-106 HEALTH INSURANCE 12,545.00 1,045.03 2,090.06 16.66 10,454.94 50250-109 LONG TERM DISABILITY 250.00 18.50 37.00 14.80 213.00 50250-115 WORKER'S COMPENSATION 195.00 0.00 0.00 0.00 195.00 50250-117 DENTAL INSURANCE 450.00 37.17 74.34 16.52 375.66 50250-118 LIFE RANCE 60.00 4.80 9.60 16.00 50.40 50250-120 EMPLOYEE BONUS 110.00 0.00 0.00 0.00 110.00 TOTAL R S SONAL EI ERVICES 106,350.00 8,201.31 16,412.04 15.43 89,937.96 SUPPLIES MAINTENANCE AND REPAIRS SERVICES 50250-401 COMMUNICATIONS 775.00 0.00 64.50 8.32 710.50 50250-412 TRAVEL AND TRAINING 3,000.00 617.55 1,018.60 33.95 1,981.40 50250-420 DUES, FEES, AND MEMBERSH I 3,000.00 0.00 150.00 5.00 2,850.00 TOTAL SERVICES 6,775.00 617.55 1,233.10 18.20 5,541.90 * DEPARTMENT TOTAL 113,125.00 8,818.86 17,645.14 15.60 95,479.86 12-26-2024 01:18 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND POLICE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50300-101 SALARIES 703,590.00 51,573.04 104, 992.03 14.92 598,597.97 50300-102 LONGEVITY 1,800.00 129.24 258.48 14.36 1,541.52 50300-103 OVERTIME 20,000.00 1.44 1,050.54 5.25 18,949.46 50300-104 FICA 56,120.00 3,945.27 8,111.98 14.45 48,008.02 50300-105 RETI REMENT 94,700.00 6,671.93 13,718.86 14.49 80,981.14 50300-106 HEALTH INSURANCE 85,580.00 5,760.67 12,881.94 15.05 72,698.06 50300-107 CLOTHING 6,000.00 0.00 0.00 0.00 6,000.00 50300-108 CERTIFICATION 7,000.00 461.54 961.54 13.74 6,038.46 50300-109 LONG TERM ITY 2,210.00 159.44 318.88 14.43 1,891.12 50300-115 WORKER'S COMPENSATION 24,400.00 0.00 15,527.38 63.64 8,872.62 50300-117 DENTAL INSURANCE 5,800.00 405.31 884.96 15.26 4,915.04 50300-118 LIFE INSURANCE 600.00 45.12 90.24 15.04 509.76 50300-120 L OY E EE ONUS 1,100.00 0.00 0.00 0.00 1,100.00 TOTAL PERSONAL SERVICES 1,008,900.00 69,153.00 158,796.83 15.74 850,103.17 SUPPLIES 50300-201 OFFICE ES 1,500.00 9.09 141.65 9.44 1,358.35 50300-202 POSTAGE 400.00 0.00 0.00 0.00 400.00 50300-205 P ERATIO! AL LIES 1,500.00 38.25 38.25 2.55 1,461.75 50300-206 ANIMAL CONTROL 3,500.00 273.00 297.95 8.51 3,202.05 50300-210 FUEL 40,000.00 1,903.36 1,903.36 4.76 38,096.64 TOTAL SUPPLIES 46,900.00 2,223.70 2,381.21 5.08 44,518.79 MAINTENANCE AND REPAIRS 50300-302 VEHICLE MAINTENANCE 16,500.00 850.94 850.94 5.16 15,649.06 50300-303 EQUIPMENT 3,000.00 0.00 0.00 0.00 3,000.00 50300-305 BUILDING AND GROUNDS 2,500.00 0.00 50.00 2.00 2,450.00 50300-307 OFFICE EQUIPMENT 2,000.00 166.00 332.00 16.60 1,668.00 50300-390 MISCELLANEOUS MAINT/REPAI 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL MAINTENANCE AND REPAIRS 25,000.00 1,016.94 1,232.94 4.93 23,767.06 SERVICES 50300-401 COMMUNICATIONS 13,500.00 1,036.08 2,072.16 15.35 11,427.84 50300-402 ELECTF R. I ICITY 4,500.00 285.91 636.83 14.15 3,863.17 50300-407 TECHNOLOGY 9,000.00 0.00 0.00 0.00 9,000.00 50300-412 EL AND TRAINING 9,000.00 922.72 922.72 10.25 8,077.28 50300-420 DUES, FEES, AND MEMBERSHI 1,600.00 0.00 0.00 0.00 1,600.00 50300-426 PROFE S: SIONAL FEES 5,500.00 0.00 0.00 0.00 5,500.00 50300-432 PRISONER BOARD 1,000.00 0.00 0.00 0.00 1,000.00 50300-433 LAW ENFORCEMENT EXPENSE 4,000.00 0.00 0.00 0.00 4,000.00 50300-434 S.0. DISPATCH SERVICES 45,000.00 0.00 0.00 0.00 45,000.00 50300-435 AL ASSA U JI LT INVES SAT 750.00 0.00 0.00 0.00 750.00 50300-436 GRANT EXPENSE 7,500.00 0.00 0.00 0.00 7,500.00 50300-437 OUNTY RADIO I CE: S 5,000.00 0.00 0.00 0.00 5,000.00 50300-450 DEBT ERVICE-INTEREST 1,910.00 0.00 0.00 0.00 1,910.00 50300-450-01 DEBT SER VICE PRINCIPAL 61,600.00 0.00 0.00 0.00 61,600.00 TOTAL SERVICES 169,860.00 2,244.71 3,631.71 2.14 166,228.29 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 10 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND POLICE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 50300-507 INSURANCE POLICE 7,247.00 0.00 0.00 0.00 7,247.00 50300-525 PRINCIPAL RIGHT-TO-USE LE 1,992.00 0.00 0.00 0.00 1,992.00 TOTAL SUNDRY CHARGES 9,239.00 0.00 0.00 0.00 9,239.00 CAPITAL OUTLAY 50300-615 VEHICLES & EQUIPMENT 60,000.00 0.00 0.00 0.00 60,000.00 50300-621 OTHER EQUIPMENT 63,300.00 0.00 0.00 0.00 63,300.00 TOTAL CAPITAL OUTLAY 123,300.00 0.00 0.00 0.00 123,300.00 * DEPARTMENT TOTAL 1,383,199.00 74,638.35 166,042.69 12.00 1,217,156.31 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 11 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND MUNICIPAL COURT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50350-101 SALARIES 88,430.00 7,134.91 14,355.77 16.23 74,074.23 50350-102 LONGEVITY 1,200.00 87.70 175.40 14.62 1,024.60 50350-103 OVERTIME 0.00 9.99 9.99 0.00 9.99) 50350-104 FICA 6,915.00 566.46 1,118.55 16.18 5,796.45 50350-105 RETI REMENT 9,520.00 800.11 1,575.09 16.55 7,944.91 50350-106 HEALTH INSURANCE 8,170.00 680.30 1,360.60 16.65 6,809.40 50350-108 CERTIFICATION 600.00 0.00 0.00 0.00 600.00 50350-109 LONG TERM DISABILITY 230.00 18.50 37.00 16.09 193.00 50350-115 WORKER'S C MPE ENSATIO ON 230.00 0.00 0.00 0.00 230.00 50350-117 DENTAL INSURANCE 685.00 60.32 120.64 17.61 564.36 50350-118 LIFE INSURANCE 60.00 4.80 9.60 16.00 50.40 50350-120 EMPLOYEE BONUS 110.00 0.00 0.00 0.00 110.00 50350-190 LEDC V RTIME 0.00 302.46 302.46 0.00 302.46) TOTAL PERSONAL SERVICES 116,150.00 9,665.55 19,065.10 16.41 97,084.90 SUPPLIES 50350-201 OFF CE ES 650.00 25.00 25.00 3.85 625.00 50350-205 OPERATIONAL SUPPLIES 350.00 0.00 0.00 0.00 350.00 TOTAL SUPE IES 1,000.00 25.00 25.00 2.50 975.00 MAINTENANCE AND REPAIRS 50350-307 OFFICE EQUIPMENT 2,200.00 0.00 149.95 6.82 2,050.05 TOTAL MAINTENANCE AND REPAIRS 2,200.00 0.00 149.95 6.82 2,050.05 SERVICES 50350-401 COMMUNICATIONS 360.00 0.00 30.00 8.33 330.00 50350-407 TECHNOLOGY 7,900.00 0.00 1,200.00 15.19 6,700.00 50350-412 AVEL AND TRAINING 3,200.00 500.00 500.00 15.63 2,700.00 50350-420 DUES, FEES, AND MEMBERSHI 130.00 0.00 0.00 0.00 130.00 50350-421 PRINTING 650.00 0.00 0.00 0.00 650.00 50350-427 LEGAL FEES 10,000.00 4,822.02 9,108.02 91.08 891.98 TOTAL SERVICES 22,240.00 5,322.02 10,838.02 48.73 11,401.98 SUNDRY CHARGES CAPITAL OUTLAY * * DEPARTMENT TOTAL 141,590.00 15,012.57 30,078.07 21.24 111,511.93 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 12 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND CODE ENFORCEMENT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50400-101 SALARIES 92,860.00 7,237.17 14,531.65 15.65 78,328.35 50400-103 OVERTIME 1,000.00 1.31 1.31 0.13 998.69 50400-104 FICA 7,300.00 550.68 1,102.59 15.10 6,197.41 50400-105 RETIREMENT 12,290.00 925.80 1,858.76 15.12 10,431.24 50400-106 HEALTH INSURANCE 16,330.00 1,360.60 2,721.20 16.66 13,608.80 50400-107 CLOTHING 1,440.00 0.00 0.00 0.00 1,440.00 50400-108 CERTIFICATION 1,200.00 0.00 0.00 0.00 1,200.00 50400-109 LONG TERM DISABILITY 300.00 27.97 55.94 18.65 244.06 50400-115 WORKER'S C MPENSATION 2,020.00 0.00 1,767.74 87.51 252.26 50400-117 DENTAL INSURANCE 900.00 74.34 148.68 16.52 751.32 50400-118 LIFE INSURA ANCE 120.00 9.60 19.20 16.00 100.80 50400-120 EMPLOYEE BONUS 220.00 0.00 0.00 0.00 220.00 TO: AL N NAL ICES 135,980.00 10,187.47 22,207.07 16.33 113,772.93 SUPPLIES 50400-201 OFFICE SUPPLIES 500.00 138.34 188.38 37.68 311.62 50400-202 C 0s AGE 100.00 0.00 0.00 0.00 100.00 50400-204 SMALL TOOLS 100.00 0.00 0.00 0.00 100.00 50400-205 OPBRATIONAL U JPPI LIES 100.00 0.00 0.00 0.00 100.00 50400-210 FUEL 2,800.00 107.65 107.65 3.84 2,692.35 TOTAL SUPPLIES 3,600.00 245.99 296.03 8.22 3,303.97 MAINTENANCE AND REPAIRS 50400-302 VEHICLE MAINTENANCE 2,000.00 196.99 196.99 9.85 1,803.01 50400-307 OFFICE EQUIPMENT 800.00 0.00 0.00 0.00 800.00 TOTAL MAINTENANCE AND REPAIRS 2,800.00 196.99 196.99 7.04 2,603.01 SERVICES 50400-401 COMMUNICATIONS 2,000.00 110.09 239.47 11.97 1,760.53 50400-407 TECHNOLOGY 14,000.00 0.00 1,655.00 11.82 12,345.00 50400-412 TRAVEL AND TRAINING 3,500.00 0.00 0.00 0.00 3,500.00 50400-420 DUES, FEES, AND MEMEBERSH 1,000.00 0.00 0.00 0.00 1,000.00 50400-421 PRINTING 300.00 0.00 0.00 0.00 300.00 50400-426 PROF E IC ONAL FEES 27,500.00 0.00 1,499.46 5.45 26, 000.54 50400-427 LEGAL FEES 500.00 0.00 0.00 0.00 500.00 50400-435 CLEAN UP 15,000.00 6,945.64 6,945.64 46.30 8,054.36 TOTAL SERVICES 63,800.00 7,055.73 10,339.57 16.21 53,460.43 SUNDRY CHARGES CAPITAL OUTLAY DEPARTMENT TOTAL 206,180.00 17,686.18 33,039.66 16.02 173,140.34 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 13 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND FIRE DEPARTMENT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50500-101 SALARIES 12, 000.00 923.08 1,846.16 15.38 10,153.84 50500-104 FICA 920.00 70.62 141.24 15.35 778.76 50500-115 WORKERS' COMPENSATION 10,000.00 0.00 5,179.46 51.79 4,820.54 TOTAL PERSONAL SERVICES 22,920.00 993.70 7,166.86 31.27 15,753.14 SUPPLIES 50500-201 OFFICE UPPLIES 1,500.00 0.00 0.00 0.00 1,500.00 50500-204 SMALL TOOLS 1,000.00 0.00 70.04 7.00 929.96 50500-205 OPER I IONAL SUPP I E S 1,500.00 0.00 0.00 0.00 1,500.00 50500-210 FUEL 2,000.00 114.42 114.42 5.72 1,885.58 TOTAL I P P PLIES 6,000.00 114.42 184.46 3.07 5,815.54 MAINTENANCE AND REPAIRS 50500-302 VEHICLE MAINTENANCE 5,000.00 0.00 0.00 0.00 5,000.00 50500-303 EQUIPMENT 25,000.00 0.00 0.00 0.00 25,000.00 50500-305 BUILDING AND GROUNDS 10,000.00 0.00 2,200.00 22.00 7,800.00 50500-317 OFFICE EQUIPMENT 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL MAINTENANCE AND REPAIRS 41,000.00 0.00 2,200.00 5.37 38,800.00 SERVICES 50500-401 COL M NICATIONS 4,000.00 179.98 359.96 9.00 3,640.04 50500-402 ELECTRIC 2,800.00 239.59 516.52 18.45 2,283.48 50500-405 GAS 3,800.00 209.39 403.25 10.61 3,396.75 50500-412 TRAVEL AND TRAINING 5,000.00 0.00 0.00 0.00 5,000.00 50500-420 DUES, FEES, AND MEM 45 B. ERSHI 2,000.00 0.00 0.00 0.00 2,000.00 50500-450 DEBT SERVICE -INTEREST 8,000.00 737.90 1,461.13 18.26 6,538.87 50500-451 DEBT SERVICE-PRINCIPAL 49,250.00 4,027.17 8,069.01 16.38 41,180.99 TOTAL SERVICES 74,850.00 5,394.03 10,809.87 14.44 64,040.13 SUNDRY CHARGES 50500-530 FIREMEN'S PENSION 19,000.00 0.00 9,000.04 47.37 9,999.96 TOTAL SUNDRY CHARGES 19,000.00 0.00 9,000.04 47.37 9,999.96 CAPITAL OUTLAY DEPARTMENT TOTAL 163,770.00 6,502.15 29,361.23 17.93 134,408.77 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 14 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND PARKS AND RECREATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50600-101 SALARIES 234,940.00 14,842.64 29,630.62 12.61 205,309.38 50600-102 LONGEVITY 2,580.00 166.16 327.70 12.70 2,252.30 50600-103 OVERTIME 2,500.00 60.77 300.21 12.01 2,199.79 50600-104 FICA 18,545.00 1,129.26 2,273.10 12.26 16,271.90 50600-105 RETI REMENT 31,350.00 1,939.21 3,901.92 12.45 27,448.08 50600-106 HEALTH INSURANCE 45,200.00 3,085.93 6,171.86 13.65 39,028.14 50600-107 CLOTHING 3,250.00 339.20 640.56 19.71 2,609.44 50600-108 CERTIFICATION 2,400.00 92.32 184.64 7.69 2,215.36 50600-109 LONG TERI M ITY 755.00 54.91 109.82 14.55 645.18 50600-115 WORKER'S COMPENSATION 5,200.00 0.00 5,583.17 107.37 383.17) 50600-117 DENTAL INSURANCE 2,710.00 194.98 389.96 14.39 2,320.04 50600-118 LIFE INSURANCE 300.00 19.20 38.40 12.80 261.60 50600-120 L OY E EE NUS 545.00 0.00 0.00 0.00 545.00 TOTAL PERSONAL SERVICES 350,275.00 21,924.58 49,551.96 14.15 300,723.04 SUPPLIES 50600-201 OFFICE ES 50.00 0.00 0.00 0.00 50.00 50600-204 SMALL TOOLS 500.00 16.84 36.76 7.35 463.24 50600-205 P PERATIONAL ES 7,500.00 0.00 42.97 0.57 7,457.03 50600-206 SPLASH PAD CHEMICALS 6,000.00 0.00 0.00 0.00 6,000.00 50600-210 FUEL 13,800.00 1,008.99 1,008.99 7.31 12,791.01 TOTAL SUPPLIES 27,850.00 1,025.83 1,088.72 3.91 26,761.28 MAINTENANCE AND REPAIRS 50600-302 VEHICLE MAINTENANCE 2,500.00 30.29 790.16 31.61 1,709.84 50600-303 EQUIPMENT 6,000.00 0.00 903.36 15.06 5,096.64 50600-305 BUILDING AND GROUNDS 15,000.00 227.12) 541.99 3.61 14,458.01 50600-306 BALLFIELD MAINTENANCE 15,000.00 0.00 0.00 0.00 15,000.00 50600-307 DOG PARK 1,000.00 0.00 0.00 0.00 1,000.00 50600-308 SPLASH PAD MAINTENANCE 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL MAINTENANCE AND REPAIRS 44,500.00 196.83) 2,235.51 5.02 42,264.49 SERVICES 50600-401 COMMUNICATIONS 2,500.00 163.62 391.74 15.67 2,108.26 50600-402 ELECTRIC 7,500.00 320.52 680.99 9.08 6,819.01 50600-412 EL AND TRAINING 1,200.00 1,137.12 1,137.12 94.76 62.88 50600-420 DUES, FEES, AND MEMBERSH; I 100.00 0.00 0.00 0.00 100.00 TOTAL SERVICES 11,300.00 1,621.26 2,209.85 19.56 9,090.15 SUNDRY CHARGES CAPITAL OUTLAY DEPARTMENT TOTAL 433,925.00 24,374.84 55,086.04 12.69 378,838.96 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 15 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND SWIMMING POOL DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50601-101 SALARIES 30,060.00 0.00 0.00 0.00 30,060.00 50601-103 OVERTIME 1,000.00 0.00 0.00 0.00 1,000.00 50601-104 FICA 2,300.00 0.00 0.00 0.00 2,300.00 50601-115 WORKERS COMPENSATION 680.00 0.00 0.00 0.00 680.00 TOTAL PERSO ONAL SERVICES 34,040.00 0.00 0.00 0.00 34,040.00 SUPPLIES 50601-201 OFFICE SUPPLIES 150.00 0.00 0.00 0.00 150.00 50601-203 o. NCE CONS 3,500.00 0.00 0.00 0.00 3,5 500.00 50601-205 OPERATIONAL SUPPLIES 15,000.00 0.00 0.00 0.00 15,000.00 TOTAL SUPI P PLIES 18,650.00 0.00 0.00 0.00 18,650.00 MAINTENANCE AND REPAIRS 50601-303 EQUIPMENT 2,000.00 0.00 0.00 0.00 2,000.00 50601-305 BUIL ING AND DS 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL MAINTENANCE AND REPAIRS 12,000.00 0.00 0.00 0.00 12,000.00 SERVICES 50601-401 0 JNICATIONS 600.00 43.63 87.26 14.54 512.74 50601-402 ELECTRIC 3,000.00 162.51 497.62 16.59 2,502.38 50601-412 TRAVEL AND TRAINING 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL SERVICES 5,100.00 206.14 584.88 11.47 4,515.12 DEPARTMENT TOTAL * 69,790.00 206.14 584.88 0.84 69,205.12 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 16 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND BADU RV PARK DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES SUPPLIES MAINTENANCE AND REPAIRS 50602-305 BUILDING AND RC o DUNDS 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL MAINTENANCE AND REPAIRS 1,000.00 0.00 0.00 0.00 1,000.00 SERVICES 50602-402 ELECTE IC 1,800.00 26.55 327.49 18.19 1,472.51 50602-436 RV SPACE MGMT FEE-AM LEG I 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL SERVICES 4,800.00 26.55 327.49 6.82 4,472.51 ** DEPARTMENT TOTAL 5,800.00 26.55 327.49 5.65 5,472.51 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 17 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND ROBINSON RV PARK DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50604-101 SALARIES 9, 600.00 737.70 1,475.40 15.37 8,124.60 50604-104 FICA 1,095.00 83.80 159.66 14.58 935.34 50604-115 WOF KERS COMPENSATION 25.00 0.00 0.00 0.00 25.00 TOTAL PERSONAL SERVICES 10,720.00 821.50 1,635.06 15.25 9,084.94 SUPPLIES 50604-201 OFFICE UPPLIES 50.00 26.77 26.77 53.54 23.23 50604-205 OPERATIONAL SUPPLIES 600.00 49.65 57.03 9.51 542.97 TOTAL U IES 650.00 76.42 83.80 12.89 566.20 MAINTENANCE AND REPAIRS 50604-303 EQUIPMENT 400.00 0.00 0.00 0.00 400.00 50604-305 30 I ING AND DS 2,500.00 64.11 102.43 4.10 2,397.57 TOTAL MAINTENANCE AND REPAIRS 2,900.00 64.11 102.43 3.53 2,797.57 SERVICES 50604-401 C NS 5,000.00 345.90 676.80 13.54 4,323.20 50604-402 ELECTRIC 22,000.00 1,305.68 2,592.87 11.79 19,407.13 50604-405 PROPI ANE 2,000.00 0.00 211.40 10.57 1,788.60 50604-407 TECHNOLOGY 500.00 0.00 0.00 0.00 500.00 50604-460 CREDIT CARD FEES 4,000.00 383.47 762.75 19.07 3,237.25 TOTAL SERVICES 33,500.00 2,035.05 4,243.82 12.67 29,256.18 CAPITAL OUTLAY DEPARTMENT TOTAL 47,770.00 2,997.08 6,065.11 12.70 41,704.89 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 18 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND DEPOT MUSEUM DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES SUPPLIES 50605-205 OPERATIONAL SUPPLIES 300.00 0.00 0.00 0.00 300.00 TOTAL SUPPLIES 300.00 0.00 0.00 0.00 300.00 MAINTENANCE AND REPAIRS 50605-305 BUILDING AND ROUNDS 10,400.00 0.00 2,917.00 28.05 7,483.00 TOTAL MAINTENANCE AND REPAIRS 10,400.00 0.00 2,917.00 28.05 7,483.00 SERVICES 50605-401 COMMUNI CATIONS 3,000.00 230.88 461.76 15.39 2,538.24 50605-434 CONTRACT LABOR 2,350.00 0.00 0.00 0.00 2,350.00 TOTAL SE 71 ICES 5,350.00 230.88 461.76 8.63 4,888.24 * DEPARTMENT TOTAL 16,050.00 230.88 3,378.76 21.05 12,671.24 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 19 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND JLK ARENA DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50606-101 SALARIES 125,540.00 7,937.74 15,128.00 12.05 110,412.00 50606-103 OVERTIME 0.00 228.89 390.19 0.00 390.19) 50606-104 FICA 9,620.00 576.64 1,095.52 11.39 8,524.48 50606-105 RETIREMENT 11,710.00 1,044.51 1,984.78 16.95 9,725.22 50606-106 HEALTH INSURAN N ICE 32,900.00 3,421.82 4,102.12 12.47 28,797.88 50606-109 LONG TERM DISABILITY 250.00 36.16 53.12 21.25 196.88 50606-115 WORKER'S COMPENSATION 3,360.00 0.00 3,860.14 114.89 500.14) 50606-117 DENTAL INSURANCE 2,240.00 243.67 280.84 12.54 1,959.16 50606-118 LIFE ANCE 120.00 14.40 19.20 16.00 100.80 50606-120 EMPLOYEE BONUS 220.00 0.00 0.00 0.00 220.00 TOTAL R S SON L EI ERVICES 185,960.00 13,503.83 26,913.91 14.47 159,046.09 SUPPLIES 50606-201 OFFICE SUPPLIES 400.00 6.56 6.56 1.64 393.44 50606-204 SMAI L TOOLS 300.00 0.00 0.00 0.00 300.00 50606-205 OPERTIONAL SUPPLIES 2,700.00 837.06 2,080.65 77.06 619.35 50606-206 SHAY IGS 9,900.00 2,301.75 2,301.75 23.25 7,598.25 50606-209 ALCOHOLIC BEVERAGES 10,220.00 32.11 1,030.49 10.08 9,189.51 50606-210 FUEL 5,000.00 2,768.53 2,768.53 55.37 2,231.47 TOTAL SUPPLIES 28,520.00 5,946.01 8,187.98 28.71 20,332.02 MAINTENANCE AND REPAIRS 50606-302 VEHICLE MAINTENANCE 250.00 0.00 0.00 0.00 250.00 50606-303 EQUIPMENT 8,000.00 58.95 632.42 7.91 7,367.58 50606-305 BUILDING AND GROUNDS 12,000.00 331.03 900.89 7.51 11,099.11 50606-307 OFFICE EQUIPMENT 0.00 41.44 41.44 0.00 41.44) TOTAL MAINTENANCE AND REPAIRS 20,250.00 431.42 1,574.75 7.78 18,675.25 SERVICES 50606-401 COMMUNICATIONS 4,000.00 166.60 319.20 7.98 3,680.80 50606-402 ELECTRICITY 28,000.00 3,701.65 8,185.18 29.23 19,814.82 50606-405 PROPANE 2,400.00 0.00 0.00 0.00 2,400.00 50606-412 TRAVEL & TRAINING 500.00 68.46 68.46 13.69 431.54 50606-420 DUES, FEES, & MEMBERSHIPS 1,000.00 0.00 0.00 0.00 1,000.00 50606-460 CREDIT CARD FEES 0.00 0.00 181.98 0.00 181.98) TOTAL SERVICES 35, 900.00 3,936.71 8,754.82 24.39 27,145.18 CAPITAL OUTLAY 50606-601 CAPITAL OUTLAY 60,000.00 71,570.00 71,570.00 119.28 11,570.00) TOTAL CAPITAL OUTLAY 60,000.00 71,570.00 71,570.00 119.28 11,570.00) * DEPARTMENT TOTAL 330,630.00 95,387.97 117,001.46 35.39 213,628.54 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 20 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND LANTEX THEATER DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50610-101 SALARIES 13,840.00 1,064.00 2,128.00 15.38 11,712.00 50610-104 FICA 1,060.00 81.38 162.76 15.35 897.24 50610-115 WOF KERS COMPENSATION 65.00 0.00 0.00 0.00 65.00 TOTAL PERSONAL SERVICES 14,965.00 1,145.38 2,290.76 15.31 12,674.24 SUPPLIES 50610-201 OFFICE UPPLIES 100.00 0.00 0.00 0.00 100.00 50610-205 OPERATIONAL SUPPLIES 3,500.00 0.00 0.00 0.00 3,500.00 50610-209 ALCOHOLIC BEVE GES 0.00 32.11 64.22 0.00 - 64.22) TOTAL SUPPLIES 3,600.00 32.11 64.22 1.78 3,535.78 MAINTENANCE AND REPAIRS 50610-303 EQUIPMENT 3,500.00 589.00 589.00 16.83 2,911.00 50610-305 BUILDING & GROUNDS 2,500.00 0.00 206.97 8.28 2,293.03 TOTAL MA: IN N TEI NANCE AND A IRS 6,000.00 589.00 795.97 13.27 5,204.03 SERVICES 50610-401 COMMUNICATIONS 2,500.00 216.09 432.18 17.29 2,067.82 50610-402 ELECTRIC 5,000.00 817.12 1,616.01 32.32 3,383.99 50610-405 GAS 3,100.00 0.00 93.58 3.02 3,006.42 50610-407 TECHNOLOGY 500.00 0.00 0.00 0.00 500.00 50610-420 DUES, FEES, & MEMBERSHIPS 1,000.00 0.00 0.00 0.00 1,000.00 50610-430 ADVERTISING 2,500.00 0.00 0.00 0.00 2,500.00 TOTAL SERVICES 14,600.00 1,033.21 2,141.77 14.67 12,458.23 CAPITAL OUTLAY * DEPARTMENT TOTAL 39,165.00 2,799.70 5,292.72 13.51 33,872.28 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 21 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND GOLF COURSE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50650-101 SALARIES 275,000.00 20,396.42 41,125.28 14.95 233,874.72 50650-102 LONGEVITY 1,740.00 87.70 175.40 10.08 1,564.60 50650-103 OVERTIME 3,000.00 20.40 152.21 5.07 2,847.79 50650-104 FICA 21,500.00 1,530.74 3,095.41 14.40 18,404.59 50650-105 RETI REMENT 31,450.00 2,123.02 4,281.02 13.61 27,168.98 50650-106 HEALTH INSURANCE 32,100.00 2,674.74 5,349.48 16.67 26,750.52 50650-107 CLOTHING 1,000.00 0.00 0.00 0.00 1,000.00 50650-108 CERTIFICATION 1,200.00 23.06 46.12 3.84 1,153.88 50650-109 LONG TERM ITY 515.00 46.43 92.86 18.03 422.14 50650-115 NORKERS COMPENSATION 6,800.00 0.00 2,971.08 43.69 3,828.92 50650-117 DEN NTAL INSURANCE 2,420.00 210.33 420.66 17.38 1,999.34 50650-118 LIFE INSURANCE 240.00 14.40 28.80 12.00 211.20 50650-120 L OY E EE NUS 440.00 0.00 0.00 0.00 440.00 TOTAL PERSONAL SERVICES 377,405.00 27,127.24 57,738.32 15.30 319,666.68 SUPPLIES 50650-201 OFFI CE ES 300.00 64.99 64.99 21.66 235.01 50650-202 POSTAGE 200.00 0.00 0.00 0.00 200.00 50650-203-01 FOOD & SNA CKS 7,000.00 0.00 589.97 8.43 6,410.03 50650-203-02 NON ALCOHOLIC BEVERAGES 9,000.00 82.66 1,004.29 11.16 7,995.71 50650-204 SMALL TOOLS 1,000.00 0.00 0.00 0.00 1,000.00 50650-205 OPERATIONAL SUPPLIES 2,000.00 993.07 993.07 49.65 1,006.93 50650-207 PRO SHOP INV ENTORY 15,000.00 0.00 162.03 1.08 14,837.97 50650-209 ALCOHOLIC BEVERAGES 20,000.00 1,802.64 3,752.11 18.76 16,247.89 50650-210 FUEL 6,000.00 597.38 1,869.64 31.16 4,130.36 TOTAL SUPPLIES 60,500.00 3,540.74 8,436.10 13.94 52,063.90 MAINTENANCE AND REPAIRS 50650-302 VEHICLE MAINTENANCE 400.00 0.00 0.00 0.00 400.00 50650-303 EQUIPMENT 15,000.00 0.00 0.00 0.00 15,000.00 50650-305 BUILDING AND GROUNDS 5,400.00 0.00 167.25 3.10 5,232.75 50650-306-01 FERTILIZER 34,000.00 23,080.00 23,080.00 67.88 10,920.00 50650-306-02 CHEMICALS 54,000.00 45,119.58 45,119.58 83.55 8,880.42 50650-306-03 TOP DRES SSING, SAND, SOIL 3,000.00 0.00 0.00 0.00 3,000.00 50650-306-04 IRRIGATION REPAIRS 4,000.00 0.00 0.00 0.00 4,000.00 50650-306-05 IRF IO DN SUPE IES 2,000.00 0.00 0.00 0.00 2, 000.00 50650-306-06 COURSE SUPPLIES 2,000.00 0.00 0.00 0.00 2,000.00 50650-306-07 OVER SEEDING, SOD, RIGS 6,000.00 0.00 2,208.00 36.80 3,792.00 50650-307 MAINTENANCE OF GOLE CARTS 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL MAINTENANCE AND REPI A IRS 127,300.00 68,199.58 70,574.83 55.44 56,725.17 SERVICES 50650-401 COMMUNICATIONS 6,000.00 347.21 672.14 11.20 5,327.86 50650-402 ELECTRICITY 17,500.00 1,207.68 2,365.12 13.51 15,134.88 50650-407 TECHNOLOGY 1,000.00 0.00 0.00 0.00 1,000.00 50650-412 TRAVEL & TRAINING 1,000.00 0.00 460.08 46.01 539.92 50650-416 CART LEASE INTEREST 27,000.00 2,250.00 4,500.00 16.67 22,500.00 50650-417 REN N TAL OF EQUIPMENT 1,500.00 112.50 225.00 15.00 1,275.00 50650-420 DUES FEES AND MEMBERSHIPS 1,800.00 0.00 150.00 8.33 1,650.00 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 22 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND GOLF COURSE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 50650-434 CONTRACT LABOR 49,500.00 4,125.00 8,250.00 16.67 41,250.00 50650-460 CREDIT CARD FEES 9,500.00 912.42 2,039.56 21.47 7,460.44 TOTAL SERVICES 114,800.00 8,954.81 18,661.90 16.26 96,138.10 CAPITAL OUTLAY 50650-615 VEHICLES & EQUIPMENT 75,595.00 0.00 0.00 0.00 75,595.00 TOTAL CAPITAL OUTLAY 75,595.00 0.00 0.00 0.00 75,595.00 * DEPARTMENT TOTAL 755,600.00 107,822.37 155,411.15 20.57 600,188.85 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 23 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND STREETS DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50800-101 SALARIES 206,390.00 11,784.97 25,412.92 12.31 180,977.08 50800-103 OVERTIME 2,500.00 28.87 134.72 5.39 2,365.28 50800-104 FICA 16,200.00 898.42 1,943.68 12.00 14,256.32 50800-105 RETIREMENT 24,190.00 1,534.61 3,334.44 13.78 20,855.56 50800-106 HEALTH INSURANCE 32,660.00 2,990.32 5,980.64 18.31 26,679.36 50800-107 CLOTHING 2,600.00 52.99 52.99 2.04 2,547.01 50800-108 CERTIFICATION 2,400.00 184.60 369.20 15.38 2,030.80 50800-109 LONG TERM DISABILITY 590.00 322.53 362.86 61.50 227.14 50800-115 WORKER'S C MPENSATIO ON 9,680.00 0.00 3,823.20 39.50 5,8 856.80 50800-117 DENTAL INSURANCE 2,700.00 246.30 418.13 15.49 2,281.87 50800-118 LIFE INSURANCE 240.00 110.40 124.80 52.00 115.20 50800-120 EMPLOYEE BONUS 440.00 0.00 0.00 0.00 440.00 TO: 1 A AL ON. NAL ICES 300,590.00 18,154.01 41,957.58 13.96 258,632.42 SUPPLIES 50800-204 SMALL TOOLS 5,000.00 139.99 473.97 9.48 4,526.03 50800-205 DE IONAL ES 10,000.00 116.75 1,081.64 10.82 8,918.36 50800-205-01 STREET REPAIR 15,000.00 0.00 0.00 0.00 15,000.00 50800-205-02 COLD MIX 52,000.00 0.00 5,899.32 11.34 46,100.68 50800-205-03 STREET SIGNAGE 20,000.00 0.00 0.00 0.00 20,000.00 50800-210 FUEL 18,000.00 587.61 1,690.78 9.39 16,309.22 TOTAL SUPPLIES 120,000.00 844.35 9,145.71 7.62 110,854.29 MAINTENANCE AND REPAIRS 50800-302 VEHICLE MAINTENANCE 7,500.00 15.00 324.23 4.32 7,175.77 50800-303 EQUIPMENT 10,000.00 562.85 2,649.88 26.50 7,350.12 50800-304 MACHINERY 32,500.00 6,390.97 8,638.14 26.58 23,861.86 50800-305 BUILDING AND GROUNDS 2,500.00 0.00 12.99 0.52 2,487.01 50800-320 DRAINAGE 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL MAINTENANCE AND REPAIRS 102,500.00 6,968.82 11,625.24 11.34 90,874.76 SERVICES 50800-401 COMMUNICATIONS 3,300.00 67.59 288.92 8.76 3,011.08 50800-402 ELECTRIC 1,000.00 55.86 107.49 10.75 892.51 50800-405 GAS 700.00 86.45 172.90 24.70 527.10 50800-412 EL AND TRAINING 1,000.00 0.00 0.00 0.00 1,000.00 50800-416 RENTAL OF EQUIPMENT 7,500.00 0.00 0.00 0.00 7,500.00 50800-450 DEB SERVICE INTEREST 15,000.00 1,093.58 2,171.62 14.48 12,828.38 50800-450-01 DEBT SERVICE PRINCIPAL 53,000.00 4,351.07 8,717.68 16.45 44,282.32 TOTAL ERVICES 81,500.00 5,654.55 11,458.61 14.06 70,041.39 SUNDRY CHARGES CAPITAL OUTLAY 50800-603 STREETS 85,000.00 317.37 64,601.30 76.00 20,398.70 50800-604 CURBS AND GUTTERS 50,000.00 0.00 30.70 0.06 49,969.30 50800-615 VEHICLES & EQUIPMENT 60,000.00 90,104.98 90,104.98 150.17 30,104.98) 50800-621 OTHER 550,000.00 0.00 0.00 0.00 550,000.00 TOTAL CAPITAL OUTLAY 745,000.00 90,422.35 154,736.98 20.77 590,263.02 DEPARTMENT TOTAL 1,349,590.00 122,044.08 228,924.12 16.96 1,120,665.88 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 24 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND STREETS DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 12-26-2024 01:18 PM CITY OF LLAN o PAGE: 25 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 10 -GENERAL FUND CAPITAL OUTLAY DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY TOTAL EXPENDITURES 6,311,279.00 659,564.49 1,270,979.68 20.14 5,040,299.32 REVENUES OVER/ (UNDER) EXPENDITURES ( 491,302.00) ( 239,324.83) 481,853.90) 98.08 9,448.10) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 15 -INTEREST & SINKING FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY 472,754.00 31,282.80 51,927.40 10.98 420,826.60 TOTAL REVENUES 472,754.00 31,282.80 51,927.40 10.98 420,826.60 EXPENDITURE SUMMARY GOLF COURSE 20,940.00 1,744.93 3,489.86 16.67 17,450.14 SERIES 2017 GO BONDS 445,100.00 0.00 0.00 0.00 445,100.00 ** * TOTAL EXPENDITURES 466,040.00 1,744.93 3,489.86 0.75 462,550.14 REVENUES OVER/ (UNDER) EXPENDITURES 6,714.00 29,537.87 48,437.54 721.44 41,723.54) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 15 -INTEREST & SINKING REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 4101 TAX REVENUE-CURRENT 449,754.00 30,047.37 49,528.31 11.01 400,225.69 4102 TAX REVENUE-DELINQUENT 5,000.00 611.98 1,163.09 23.26 3,836.91 4103 PENALTY & INTEREST 3,000.00 152.13 346.10 11.54 2,653.90 4701 INTEREST 15,000.00 471.32 889.90 5.93 14,110.10 TOTAL 472,754.00 31,282.80 51,927.40 10.98 420,826.60 * TOTAL REVENUE 472,754.00 31,282.80 51,927.40 10.98 420,826.60 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 15 -INTEREST & SINKING GOLF COURSE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES 50650-450 GOLF PROMI SORY NOTE INTE 4,810.00 420.00 843.00 17.53 3,967.00 50650-450-01 DEBT SERVICE PRINCIPAL 16,130.00 1,324.93 2,646.86 16.41 13,483.14 TOTAL SERVICES 20,940.00 1,744.93 3,489.86 16.67 17,450.14 ** * DEPARTMENT TOTAL 20,940.00 1,744.93 3,489.86 16.67 17,450.14 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 15 -INTEREST & SINKING SERIES 2017 GO BONDS DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES SERVICES 50800-435 BOND AGENT FEES 400.00 0.00 0.00 0.00 400.00 50800-450 SERIES 2017 GO INTEREST 99,700.00 0.00 0.00 0.00 99,700.00 50800-450-01 ERIES 2017 GO PRINCIPAL 345,000.00 0.00 0.00 0.00 345,000.00 TOTAL SERVICES 445,100.00 0.00 0.00 0.00 445,100.00 * DEPARTMENT TOTAL 445,100.00 0.00 0.00 0.00 445,100.00 * * TOTAL EXPENDITURES 466,040.00 1,744.93 3,489.86 0.75 462,550.14 * REVENUES OVER/ (UNDER) EXPENDITURES 6,714.00 29,537.87 48,437.54 721.44 41,723.54) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUE 10,561,990.00 803,157.31 1,686,711.40 15.97 8,875,278.60 * TOTAL REVENUES 10,561,990.00 803,157.31 1,686,711.40 15.97 8,875,278.60 EXPENDITURE SUMMARY ADMINISTRATION 854,218.00 59,115.15 123,953.03 14.51 730,264.97 CUSTOMER CONVENIENCE STA 214,010.00 10,699.10 29,389.93 13.73 184, 620.07 SANITATION 801,867.00 64,906.33 129,618.03 16.16 672,248.97 WATER PLANT 904,826.00 43,558.00 132,316.19 14.62 772,509.81 WATER DISTRIBUTION 1,333,554.00 35,224.53 84,073.86 6.30 1,249,480.14 SEWER PLANT 927,155.00 45,467.90 108,479.93 11.70 818,675.07 SEWER COLLECTION 884,965.00 40,910.10 83,288.05 9.41 801,676.95 ELECTRIC 4,626,204.00 360,983.11 786,300.91 17.00 3,839,903.09 CAPITAL OUTLAY 394,723.00 67,803.25 130,427.89 33.04 264,295.11 TOTAL EXPENDITURES 10,941,522.00 728,667.47 1,607,847.82 14.69 9,333,674.18 * REVENUES OVER/ (UNDER) EXPENDITURES ( 379,532.00) 74,489.84 78,863.58 20.78- 458,395.58) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE 4101 ELECTRIC 5,206,840.00 369,535.77 790,576.61 15.18 4,416,263.39 4102 WATER 1,879,000.00 156,134.37 323,436.84 17.21 1,555,563.16 4103 SEWER 1,720,000.00 148,388.77 296,806.63 17.26 1,423,193.37 4104 SANITATION 1,008,000.00 84,399.43 168,881.43 16.75 839,118.57 4106 ADMINISTR. TION UE 80,000.00 6,849.53 13,717.09 17.15 66,282.91 4108 CUSTOMER CONVENIENCE STATION 153,000.00 7,889.10 21,462.90 14.03 131,537.10 4110 ELECTRIC TAP FEES 15,000.00 3,138.50 4,777.00 31.85 10,223.00 4120 WATER TAP FEES 35,000.00 0.00 0.00 0.00 35,000.00 4121 SEWER TAP S 35,000.00 0.00 3,765.00 10.76 31,235.00 4126 CUSTOMER SERVICE INSPECTIONS 650.00 150.00 300.00 46.15 350.00 4127 RECLAIMED WATER SALES 5,000.00 0.00 0.00 0.00 5,000.00 4150 HAY CONTRACT REVENUE 10,000.00 0.00 6,240.00 62.40 3,760.00 4151 ELECTRIC SYSTEMS RADES 2,000.00 623.49 1,315.63 65.78 684.37 4152 TSU LEASE 9,000.00 0.00 750.00 8.33 8,250.00 4220 VA ATE ER TAP EVALUATION 8,000.00 0.00 0.00 0.00 8,000.00 4221 SEWER TAP EVALUATION 8,000.00 0.00 1,000.00 12.50 7,000.00 4627 IT CARD FEE A 7 S 34,000.00 2,743.21 5,643.58 16.60 28,356.42 4701 INTEREST ON INVESTMENTS 350,000.00 23,169.00 47,802.50 13.66 302,197.50 4790 MISCI LANEOUS INCOME 3,500.00 136.14 236.19 6.75 3,263.81 TOTAL REVENUE 10,561,990.00 803,157.31 1,686,711.40 15.97 8,875,278.60 ** * TOTAL REVENUE 10,561,990.00 803,157.31 1,686,711.40 15.97 8,875,278.60 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND ADMINISTRATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51100-101 SALARIES 85,080.00 6,549.05 13,087.49 15.38 71,992.51 51100-103 OVERTIME 5,000.00 300.13 820.96 16.42 4,179.04 51100-104 FICA 6,910.00 505.73 1,027.52 14.87 5,882.48 51100-105 RETIREMENT 11,650.00 876.01 1,782.71 15.30 9,867.29 51100-106 HEALTH INSURANCE 24,620.00 1,208.38 3,259.44 13.24 21,360.56 51100-107 CLOTHING 1,000.00 0.00 0.00 0.00 1,000.00 51100-109 LONG TERM DISABILITY 280.00 22.80 45.60 16.29 234.40 51100-115 WORKER'S COMPENSATION 230.00 0.00 0.00 0.00 230.00 51100-117 DENTAL SURANCE 1,510.00 130.03 260.06 17.22 1,249.94 51100-118 LIFE INSURANCE 120.00 9.60 19.20 16.00 100.80 51100-120 M PI YEE E BONUS 220.00 0.00 0.00 0.00 220.00 TOTAL PERSONAL SERVICES 136,620.00 9,601.73 20,302.98 14.86 116,317.02 SUPPLIES 51100-201 OFFICE LIES 2,000.00 83.34 105.13 5.26 1,894.87 51100-202 POSTAGE 12,500.00 1,146.92 2,279.15 18.23 10,220.85 51100-205 DE AL ES 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL SUPPLIES 15,500.00 1,230.26 2,384.28 15.38 13,115.72 MAINTENANCE AND REPAIRS 51100-307 OFFICE EQUIPMENT 2,500.00 0.00 0.00 0.00 2,500.00 TOTAL MAINTENANCE AND REPAIRS 2,500.00 0.00 0.00 0.00 2,500.00 SERVICES 51100-401 COMMI 10 UNICATIONS 2,400.00 324.79 607.18 25.30 1,792.82 51100-407 TECHNOLOGY 31,000.00 0.00 3,391.55 10.94 27,608.45 51100-412 TRAVEL AND TRAINING 5,000.00 0.00 0.00 0.00 5,000.00 51100-426 PROFESSIONAL FEES 85,048.00 4,299.94 9,692.95 11.40 75,355.05 51100-435 BOND AGENT FEES 2,000.00 0.00 0.00 0.00 2,000.00 51100-450 LNB AUTO METER NOTE I 12,300.00 0.00 0.00 0.00 12,300.00 51100-450-01 LNB - AUTO METER NOTE P 35,300.00 0.00 0.00 0.00 35,300.00 51100-460 CREDIT CARD FEES 34,000.00 2,886.03 5,812.46 17.10 28,187.54 TOTAL SERVICES 207,048.00 7,510.76 19,504.14 9.42 187,543.86 SUNDRY CHARGES 51100-550 FEE IN LIEU OF TAX 9,450.00 514.06 1,244.95 13.17 8,205.05 51100-552 ADM & OTHER OVERHEAD 483,100.00 40,258.34 80,516.68 16.67 402,583.32 TOTAL SUNDRY CHZ IARGES 492,550.00 40,772.40 81,761.63 16.60 410,788.37 CAPITAL OUTLAY EXP 8 * DEPARTMENT TOTAL 854,218.00 59,115.15 123,953.03 14.51 730,264.97 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND CUSTOMER CONVENIENCE STA DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51200-101 SALARIES 52, 050.00 4,050.23 7,993.87 15.36 44,0 056.13 51200-102 LONGEVITY 960.00 64.62 129.24 13.46 830.76 51200-103 OVERTIME 1,500.00 70.94 186.07 12.40 1,313.93 51200-104 FICA 4,180.00 298.00 591.23 14.14 3,588.77 51200-105 RETI REMENT 6,600.00 520.80 1,048.18 15.88 5,551.82 51200-106 HEALTH INSURANCE 12,545.00 1,045.03 2,090.06 16.66 10,454.94 51200-107 CLOTHING 775.00 49.60 89.28 11.52 685.72 51200-109 LONG TERM DISABILITY 160.00 14.47 28.94 18.09 131.06 51200-115 WORKER'S C MPENSATIO N 2,980.00 0.00 2,685.31 90.11 294.69 51200-117 DENTAL INSURANCE 690.00 60.32 120.64 17.48 569.36 51200-118 LIFE INSURA ANCE 60.00 4.80 9.60 16.00 50.40 51200-120 EMPLOYEE BONUS 110.00 0.00 0.00 0.00 110.00 TO: AL NAL C CES 82,610.00 6,178.81 14,972.42 18.12 67,637.58 SUPPLIES 51200-201 OFFICE SUPPLIES 500.00 0.00 14.00 2.80 486.00 51200-204 SMA TOO. 100.00 0.00 30.60 30.60 69.40 51200-205 OPERATIONAL SUPPLIES 100.00 0.00 0.00 0.00 100.00 51200-210 FUEL 1,500.00 25.24 25.24 1.68 1,474.76 TOTAL SUPPLIES 2,200.00 25.24 69.84 3.17 2,130.16 MAINTENANCE AND REPAIRS 51200-303 EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51200-304 MACHINERY 5,000.00 218.25 218.25 4.37 4,781.75 51200-305 BUILE - ING AND GROUNDS 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL MAINTENANCE AND REPAIRS 7,000.00 218.25 218.25 3.12 6,781.75 SERVICES 51200-401 COMMUNICATIONS 2,000.00 179.61 599.22 29.96 1,400.78 51200-402 ELECTRIC 1,200.00 63.93 129.88 10.82 1,070.12 51200-404 DISPOSAL FEES 75,000.00 3,904.86 9,130.31 12.17 65,869.69 51200-407 TECHNOLOGY 1,000.00 0.00 0.00 0.00 1,000.00 51200-426 PROFESSIONAL FEES 25,000.00 0.00 0.00 0.00 25,000.00 51200-460 CREDIT ARD FEES 2,500.00 128.40 370.01 14.80 2,129.99 TOTAL SERVICES 106,700.00 4,276.80 10,229.42 9.59 96, 470.58 SUNDRY CHARGES CAPITAL OUTLAY 51200-602 BUILDINGS AND IMPROVEMENT 15,500.00 0.00 3,900.00 25.16 11,600.00 TOTAL CAPITAL OUTLAY 15,500.00 0.00 3,900.00 25.16 11,600.00 DEPARTMENT TOTAL 214,010.00 10,699.10 29,389.93 13.73 184,620.07 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND SANITATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES 51201-404 DISPOSAL FEES 775,000.00 62,682.43 125,177.79 16.15 649,822.21 TOTAL SERVICES 775, 000.00 62, 682.43 125,177.79 16.15 649,8 822.21 SUNDRY CHARGES 51201-550 IN LIEU OF TAX 26,867.00 2,223.90 4,440.24 16.53 22,426.76 TOTAL SUNDRY CHARGES 26,867.00 2,223.90 4,440.24 16.53 22,426.76 DEPARTMENT TOTAL 801,867.00 64,906.33 129,618.03 16.16 672,248.97 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND WATER PLANT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51300-101 SALARIES 137,560.00 10,814.01 21,578.67 15.69 115, 981.33 51300-102 LONGEVITY 910.00 61.12 122.24 13.43 787.76 51300-103 OVERTIME 19,000.00 1,902.40 2,872.76 15.12 16,127.24 51300-104 FICA 12,370.00 957.71 1,832.86 14.82 10,537.14 51300-105 RETI REMENT 20,890.00 1,671.40 3,231.30 15.47 17,658.70 51300-106 HEALTH INSURANCE 19,305.00 1,397.91 3,006.49 15.57 16,298.51 51300-107 CLOTHING 1,590.00 0.00 181.76 11.43 1,408.24 51300-108 CERTIFICATION 3,850.00 290.38 580.76 15.08 3,269.24 51300-109 LONG TERI M ITY 450.00 28.96 57.92 12.87 392.08 51300-115 WORKER'S COMPENSATION 4,290.00 0.00 4,304.99 100.35 14.99) 51300-117 DENTAL INSURANCE 1,680.00 151.68 305.96 18.21 1,374.04 51300-118 LIFE INSURANCE 100.00 7.60 15.20 15.20 84.80 51300-120 L Y E EE NUS 180.00 0.00 0.00 0.00 180.00 TOTAL PERSONAL SERVICES 222,175.00 17,283.17 38,090.91 17.14 184,084.09 SUPPLIES 51300-201 OFF CE ES 550.00 0.00 153.55 27.92 396.45 51300-202 POSTAGE 50.00 19.26 19.26 38.52 30.74 51300-204 SMALL TOOLS 600.00 0.00 0.00 0.00 600.00 51300-205 OPERATIONAL SUPPLIES 137,500.00 854.32 42,553.13 30.95 94,946.87 51300-210 FUEL 3,000.00 202.34 202.34 6.74 2,797.66 TOTAL SUPPLIES 141,700.00 1,075.92 42,928.28 30.30 98,771.72 MAINTENANCE AND REPAIRS 51300-302 VEHICLE MAINTENANCE 4,500.00 403.79 917.50 20.39 3,582.50 51300-303 EQUIPMENT 85,000.00 10.28 164.69 0.19 84,835.31 51300-305 BUILDING AND GROUNDS 3,500.00 16.93 101.44 2.90 3,398.56 51300-312 BOARDS ON DAM 10,000.00 29.73 29.73 0.30 9,970.27 TOTAL MAINTENANCE AND REPAIRS 103,000.00 460.73 1,213.36 1.18 101,786.64 SERVICES 51300-401 COMMUNICATIONS 6,000.00 393.26 896.13 14.94 5,103.87 51300-402 ELECTRIC 44,000.00 3,456.19 6,524.66 14.83 37,475.34 51300-404 DISE POSAL FEES 35,000.00 2,569.29 5,087.62 14.54 29,912.38 51300-407 TECHNOLOGY 5,000.00 0.00 0.00 0.00 5,000.00 51300-412 EL AND TRAINING 2,375.00 0.00 0.00 0.00 2,375.00 51300-415 TESTING FEES 16,500.00 1,271.44 3,547.92 21.50 12,952.08 51300-416 RENTAL OF EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51300-420 DUES, FEES, AND MEMBERSHI 5,000.00 0.00 75.00 1.50 4,925.00 51300-432 WATE R CONSERVATION PROGRA 500.00 0.00 0.00 0.00 500.00 51300-452 SERIES 2016 WTP INTEREST 32,256.00 0.00 0.00 0.00 32,256.00 51300-452-01 SERIES 2016 WTP PRINCIPAL 60,000.00 0.00 0.00 0.00 60,000.00 51300-453 SERIES 2017 TAX & REV CO' 3,815.00 0.00 0.00 0.00 3,815.00 51300-453-01 SERIES2017 TAX & REV CO'S 8,135.00 0.00 0.00 0.00 8,135.00 TOTAL SERVICES 219,081.00 7,690.18 16,131.33 7.36 202,949.67 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND WATER PLANT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 51300-550 IN LIEU OF TAX 197,295.00 17,048.00 33,952.31 17.21 163,342.69 51300-553 CONTRIBUTION TO SINKING F 21,575.00 0.00 0.00 0.00 21,575.00 TOTAL SUNDRY CHARGES 218,870.00 17,048.00 33, 952.31 15.51 184,917.69 CAPITAL OUTLAY * DEPARTMENT TOTAL 904,826.00 43,558.00 132,316.19 14.62 772,509.81 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND WATER DISTRIBUTION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51325-101 SALARIES 166,110.00 12, 500.55 25,230.59 15.19 140,879.41 51325-102 LONGEVITY 1,600.00 128.08 256.16 16.01 1,343.84 51325-103 OVERTIME 20,000.00 490.42 1,971.54 9.86 18,028.46 51325-104 FICA 14,670.00 945.42 1,979.91 13.50 12,690.09 51325-105 RETI REMENT 24,760.00 1,711.11 3,595.60 14.52 21,164.40 51325-106 HEALTH INSURANCE 30,340.00 2,317.64 5,056.62 16.67 25,283.38 51325-107 CLOTHING 2,250.00 0.00 0.00 0.00 2,250.00 51325-108 CERTIFICATION 3,750.00 259.58 519.16 13.84 3,230.84 51325-109 LONG TERI M ITY 510.00 39.45 78.90 15.47 431.10 51325-115 WORKER'S COMPENSATION 5,100.00 0.00 2,632.50 51.62 2,467.50 51325-117 DENTAL INSURANCE 2,180.00 271.89 471.14 21.61 1,708.86 51325-118 LIFE INSURANCE 140.00 10.80 21.60 15.43 118.40 51325-120 L OY E EE NUS 250.00 0.00 0.00 0.00 250.00 TOTAL PERSONAL SERVICES 271,660.00 18,674.94 41,813.72 15.39 229,846.28 SUPPLIES 51325-201 OFF ICE ES 800.00 0.00 0.00 0.00 800.00 51325-204 SMALL TOOLS 2,500.00 0.00 0.00 0.00 2,500.00 51325-205 OPBRATIONAL U PPI LIES 1,500.00 0.00 214.39 14.29 1,285.61 51325-210 FUEL 15,000.00 390.10 1,493.26 9.96 13,506.74 TOTAL SUPPLIES 19,800.00 390.10 1,707.65 8.62 18,092.35 MAINTENANCE AND REPAIRS 51325-302 VEHICLE MAINTENANCE 13,000.00 52.40 677.27 5.21 12,322.73 51325-303 EQUIPMENT 17,500.00 0.00 425.07 2.43 17,074.93 51325-304 MACHINERY 16,000.00 1,339.19 1,584.86 9.91 14,415.14 51325-305 BUILDING AND GROUNDS 2,500.00 0.00 13.00 0.52 2,487.00 51325-310 UTILITIES 110,000.00 13,257.05 34,988.89 31.81 75,011.11 51325-311 SYSTEM IMPROVEMENTS 15,000.00 0.00 0.00 0.00 15,000.00 51325-320 REPAIR UTILITY STREET CUT 22,000.00 0.00 0.00 0.00 22,000.00 TOTAL MAINTENANCE AND REPAIRS 196,000.00 14,648.64 37,689.09 19.23 158,310.91 SERVICES 51325-401 COMMUNI ATIONS 5,300.00 316.19 767.55 14.48 4,532.45 51325-402 ELECTRIC 13,000.00 982.16 1,883.35 14.49 11,116.65 51325-407 TECHNOLOGY 5,000.00 0.00 0.00 0.00 5,000.00 51325-412 TRAVEL AND TRAINING 3,375.00 212.50 212.50 6.30 3,162.50 51325-416 RENTAL OF EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51325-420 DUES, FEES, AND MEMBERSHI 400.00 0.00 0.00 0.00 400.00 51325-426 PROFESSIONAL FEES 10,650.00 0.00 0.00 0.00 10,650.00 51325-428 WATER TAP EVALUATION 8,000.00 0.00 0.00 0.00 8,000.00 51325-450 SERIES 2022 INTEI EST 182,056.00 0.00 0.00 0.00 182,056.00 51325-450-01 SERIES 2022 PRINCIPAL 425,000.00 0.00 0.00 0.00 425,000.00 51325-451 RIES 2016 INTEREST 32,256.00 0.00 0.00 0.00 32,256.00 51325-451-01 SERIES 2016 PRINCIPAL 60,000.00 0.00 0.00 0.00 60,000.00 51325-453 SERIE! S $2017 TAX & REV CO'S 15,654.00 0.00 0.00 0.00 15,654.00 51325-453-01 SERIES2017 TAX & REV CO'S 33,384.00 0.00 0.00 0.00 33,384.00 51325-454 TWDB SER. IES 2018 B INTERE 11,519.00 0.00 0.00 0.00 11,519.00 51325-454-01 TWDB SERIES 2018 B PRINCI I 40,000.00 0.00 0.00 0.00 40,000.00 TOTAL SE S 846,094.00 1,510.85 2,863.40 0.34 843,230.60 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND WATER DISTRIBUTION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES CAPITAL OUTLAY * DEPARTMENT TOTAL 1,333,554.00 35,224.53 84,073.86 6.30 1,249,480.14 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 10 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND SEWER PLANT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51350-101 SALARIES 121, 960.00 9,523.07 18,857.53 15.46 103,102.47 51350-102 LONGEVITY 310.00 24.24 48.48 15.64 261.52 51350-103 OVERTIME 12,500.00 916.26 2,061.00 16.49 10,439.00 51350-104 FICA 10,600.00 781.32 1,561.81 14.73 9,038.19 51350-105 RETI REMENT 17,900.00 1,372.50 2,755.85 15.40 15,144.15 51350-106 HEALTH INSURANCE 19,305.00 1,397.91 3,006.49 15.57 16,298.51 51350-107 CLOTHING 1,590.00 0.00 248.96 15.66 1,341.04 51350-108 CERTIFICATION 3,550.00 267.32 534.64 15.06 3,015.36 51350-109 LONG TERI M ITY 400.00 28.97 57.94 14.49 342.06 51350-115 WORKER'S COMPENSATION 3,680.00 0.00 1,672.48 45.45 2,007.52 51350-117 DENTAL INSURANCE 1,010.00 85.61 173.81 17.21 836.19 51350-118 LIFE INSURANCE 100.00 7.60 15.20 15.20 84.80 51350-120 L o Y E EE NUS 180.00 0.00 0.00 0.00 180.00 TOTAL PERSONAL SERVICES 193,085.00 14,404.80 30,994.19 16.05 162,090.81 SUPPLIES 51350-201 OFF CE ES 500.00 0.00 0.00 0.00 500.00 51350-202 POSTAGE 50.00 0.00 0.00 0.00 50.00 51350-204 SMALL TOOLS 750.00 0.00 0.00 0.00 750.00 51350-205 OPERATIONAL SUPPLIES 30,000.00 1,165.66 15,257.92 50.86 14,742.08 51350-210 FUEL 4,000.00 137.65) 965.51 24.14 3,034.49 TOTAL SUPPLIES 35,300.00 1,028.01 16,223.43 45.96 19,076.57 MAINTENANCE AND REPAIRS 51350-302 VEHICLE MAINTENANCE 4,500.00 36.74 570.46 12.68 3,929.54 51350-303 EQUIPMENT 70,000.00 1,353.50 7,926.60 11.32 62,073.40 51350-304 MACHINERY 5,000.00 190.42 312.59 6.25 4,687.41 51350-305 BUILDING AND GROUNDS 2,500.00 92.05 248.67 9.95 2,251.33 51350-311 SYSTEM IMPROVEMENTS 15,000.00 0.00 0.00 0.00 15,000.00 TOTAL MAINTENANCE AND REPA AIRS 97,000.00 1,672.71 9,058.32 9.34 87,941.68 SERVICES 51350-401 COMMUNICATIONS 6,000.00 731.74 1,246.63 20.78 4,753.37 51350-402 ELECTRIC 62,000.00 4,6 666.91 8,774.75 14.15 53,225.25 51350-407 TECHNOLOGY 5,000.00 2,230.50 2,230.50 44.61 2,769.50 51350-412 EL AND TRAINING 2,375.00 0.00 97.00 4.08 2,278.00 51350-415 TESTING FEES 35,000.00 912.72 1,627.12 4.65 33,372.88 51350-420 DUES, FEES, AND MEMB RSHI 4,000.00 4,593.30 8,066.83 201.67 ( 4,066.83) 51350-426 PROFESSIONAL FEES 15,000.00 0.00 0.00 0.00 15,000.00 51350-451 SER RI IES 2016 SEWER PLANT I 69,890.00 0.00 0.00 0.00 69,890.00 51350-451-01 SERIES 2016 SEWER PLANT P 130,000.00 0.00 0.00 0.00 130,000.00 51350-453 SERIES 2017 TAX & REV CO' 11,590.00 0.00 0.00 0.00 11,590.00 51350-453-01 SERIES 2017 TAX & REV CO' 24,715.00 0.00 0.00 0.00 24,715.00 51350-454 TWD OB E S 2018 C INTERE 6,650.00 0.00 0.00 0.00 6,650.00 51350-454-01 TWDB SERIES 2018 C PRINCI 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL SEI C CES 402,220.00 13,135.17 22,042.83 5.48 380,177.17 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 11 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND SEWER PLANT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 51350-550 IN LIEU OF TAX 180,600.00 15,227.21 30,161.16 16.70 150,438.84 51350-553 CONTRIBUTION TO SINKING F 18,950.00 0.00 0.00 0.00 18,950.00 TOTAL SUNDRY CHARGES 199,550.00 15,227.21 30,161.16 15.11 169,388.84 CAPITAL OUTLAY CONTRIBUTIONS TO OTHER FUNDS DEPARTMENT TOTAL 927,155.00 45,467.90 108,479.93 11.70 818,675.07 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 12 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND SEWER COLLECTION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51375-101 SALARIES 186,700.00 14,187.61 28,500.79 15.27 158,199.21 51375-102 LONGEVITY 1,600.00 128.08 256.16 16.01 1,343.84 51375-103 OVERTIME 22,500.00 708.12 2,530.86 11.25 19,969.14 51375-104 FICA 16,470.00 1,081.87 2,254.47 13.69 14,215.53 51375-105 RETI REMENT 27,800.00 1,958.67 4,095.98 14.73 23,704.02 51375-106 HEALTH INSURANCE 34,140.00 2,634.12 5,689.58 16.67 28,450.42 51375-107 CLOTHING 2,590.00 0.00 0.00 0.00 2,590.00 51375-108 CERTIFICATION 4,150.00 290.42 580.84 14.00 3,569.16 51375-109 LONG TERI M ITY 580.00 45.31 90.62 15.62 489.38 51375-115 WORKER'S COMPENSATION 5,730.00 0.00 5,265.00 91.88 465.00 51375-117 DENTAL INSURANCE 2,460.00 297.17 521.70 21.21 1,938.30 51375-118 LIFE INSURANCE 160.00 12.40 24.80 15.50 135.20 51375-120 L OY E EE NUS 280.00 0.00 0.00 0.00 280.00 TOTAL PERSONAL SERVICES 305,160.00 21,343.77 49,810.80 16.32 255,349.20 SUPPLIES 51375-201 OFF ICE ES 2,000.00 0.00 0.00 0.00 2,000.00 51375-204 SMALL TOOLS 2,500.00 0.00 0.00 0.00 2,500.00 51375-205 OPBRATIONAL U PPI LIES 5,000.00 428.50 642.90 12.86 4,357.10 51375-210 FUEL 18,000.00 853.96 1,957.13 10.87 16,042.87 TOTAL SUPPLIES 27,500.00 1,282.46 2,600.03 9.45 24,899.97 MAINTENANCE AND REPAIRS 51375-302 VEHICLE MAINTENANCE 13,000.00 52.41 585.65 4.51 12,414.35 51375-303 EQUIPMENT 80,000.00 16.07 746.47 0.93 79,253.53 51375-304 MACHINERY 21,000.00 1,339.21 1,467.74 6.99 19,532.26 51375-305 BUILDING AND GROUNDS 2,500.00 0.00 13.00 0.52 2,487.00 51375-310 UTILITIES 30,000.00 7,513.59 11,755.46 39.18 18,244.54 51375-311 SYSTEM IMPROVEMENTS 40,000.00 0.00 0.00 0.00 40,000.00 51375-314 LIFT STATIONS REBUILDS 20,000.00 0.00 385.80 1.93 19,614.20 51375-320 REPAIR UTILITY STREET CUT 22,000.00 0.00 0.00 0.00 22,000.00 TOTAL MAINTENANCE AND REPA AIRS 228,500.00 8,921.28 14,954.12 6.54 213,545.88 SERVICES 51375-401 COMMUNICATIONS 5,400.00 349.11 839.86 15.55 4,560.14 51375-402 ELECTRIC 10,000.00 314.12 1,602.54 16.03 8,397.46 51375-405 GAS 1,000.00 90.79 180.06 18.01 819.94 51375-407 TECHI IN NOLOGY 5,000.00 0.00 0.00 0.00 5,000.00 51375-412 TRAVEL AND TRAINING 3,875.00 212.50 212.50 5.48 3,662.50 51375-416 RENTAL OF EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51375-420 DUES, FEES, AND MEMBERSHI 500.00 0.00 0.00 0.00 500.00 51375-426 PR o. SIONAL FEE S 10,650.00 0.00 0.00 0.00 10, 650.00 51375-428 SEWER TAP EVALUATION 8,000.00 2,704.00 2,704.00 33.80 5,296.00 51375-450 DEE BT E VICE INTE EST 2,475.00 228.28 464.82 18.78 2,010.18 51375-450-01 DEBT SERVICE PRINCIPAL 60,225.00 4,963.79 9,919.32 16.47 50,305.68 51375-453 SERIES 2017 TAX & REV CO' 6,460.00 0.00 0.00 0.00 6,460.00 51375-453-01 SERIES 2017 TAX & REV CO' 13,770.00 0.00 0.00 0.00 13,770.00 51375-454 TWD B E R RIES 2018 A INTERE 35,950.00 0.00 0.00 0.00 35,950.00 51375-454-01 TWDB SERIES 2018 A PRINCI I 160,000.00 0.00 0.00 0.00 160,000.00 TOTAL SE S 323, 805.00 9,362.59 15,923.10 4.92 307,881.90 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 13 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND SEWER COLLECTION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES CAPITAL OUTLAY * DEPARTMENT TOTAL 884,965.00 40,910.10 83,288.05 9.41 801,676.95 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 14 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND ELECTRIC DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 51400-101 SALARIES 369,340.00 28,835.52 57,179.42 15.48 312,160.58 51400-102 LONGEVITY 2,520.00 180.00 355.38 14.10 2,164.62 51400-103 OVERTIME 31,000.00 3,290.06 6,056.75 19.54 24,943.25 51400-104 FICA 30,900.00 2,335.40 4,596.16 14.87 26,303.84 51400-105 RETI REMENT 52,100.00 4,131.90 8,174.63 15.69 43,925.37 51400-106 HEALTH INSURANCE 61,100.00 5,090.53 10,181.06 16.66 50,918.94 51400-107 CLOTHING 6,260.00 528.31 528.31 8.44 5,731.69 51400-109 LONG TERM DISABILITY 1,190.00 87.54 175.08 14.71 1,014.92 51400-115 WORKER'S C MPE ENSATIO ON 9,950.00 0.00 9,530.14 95.78 419.86 51400-117 DENTAL INSURANCE 4,440.00 402.81 805.62 18.14 3, 634.38 51400-118 LIFE INSURA ANCE 300.00 24.00 48.00 16.00 252.00 51400-120 EMPLOYEE BONUS 550.00 0.00 0.00 0.00 550.00 TO: Z AL AL C CES 569,650.00 44,906.07 97,630.55 17.14 472,019.45 SUPPLIES 51400-201 OFFICE SUPPLIES 200.00 0.00 0.00 0.00 200.00 51400-204 SN 4A TOO. 4,500.00 139.98 139.98 3.11 4,360.02 51400-205 OPERATIONAL SUPPLIES 700.00 5,035.96 5,060.61 722.94 4,360.61) 51400-210 FUEL 15,000.00 1,071.79 1,071.79 7.15 13,928.21 TOTAL SUPPLIES 20,400.00 6,247.73 6,272.38 30.75 14,127.62 MAINTENANCE AND REPAIRS 51400-302 VEHICLE MAINTENANCE 15,000.00 191.55 960.55 6.40 14,039.45 51400-303 EQUIPMENT 2,000.00 600.96 1,380.50 69.03 619.50 51400-304 MACHINERY 200.00 0.00 0.00 0.00 200.00 51400-305 BUILDING AND GROUNDS 10,000.00 5,994.20 6,007.20 60.07 3,992.80 51400-307 TECHNOLOGY 3,500.00 0.00 0.00 0.00 3,500.00 51400-310 UTILITIES 137,000.00 12,013.23 67,065.93 48.95 69,934.07 51400-312 CUSTOMER COMPLIANCE 500.00 0.00 0.00 0.00 500.00 TOTAL MAINTENANCE AND REPAIRS 168,200.00 18,799.94 75,414.18 44.84 92,785.82 SERVICES 51400-401 COMMUNICATIONS 10,500.00 733.96 1,550.42 14.77 8,949.58 51400-402 ELECTRIC 1,000.00 113.03 238.55 23.86 761.45 51400-403 LCRA WHOLESALE 3,040,000.00 221,700.80 477,238.80 15.70 2,562,761.20 51400-404 SOLAR POWER BUYBACH K 18,000.00 907.66 1,896.99 10.54 16,103.01 51400-412 TRAVEL AND TRAINING 13,000.00 7,306.18 8,448.49 64.99 4,551.51 51400-415 TESTING FEES 3,500.00 0.00 2,479.00 70.83 1,021.00 51400-416 RENTAL OF EQUIPEMENT 500.00 0.00 0.00 0.00 500.00 51400-420 DUES, FEES, AND MEME ERSHI 9,000.00 0.00 67.50 0.75 8,932.50 51400-426 PROFESSIONAL FEES 86,000.00 11,028.80 13,101.92 15.23 72,898.08 51400-426-01 LCRA LINE U DY 27,300.00 2,272.91 4,503.81 16.50 22,796.19 51400-450 CADENCE LEASE INTEREST 16,615.00 844.73 1,702.12 10.24 14,912.88 51400-450-01 A DENCE LEASE PRINCIPAL 52,920.00 2,730.37 5,448.08 10.29 47,471.92 51400-455 GOVT CAP POLE TRK INT 7,190.00 0.00 0.00 0.00 7,190.00 51400-455-01 GOVT CAP POLE TRK PRI 35,711.00 0.00 0.00 0.00 35,711.00 TOTAL SERVICES 3,321,236.00 247,638.44 516,675.68 15.56 2,804,560.32 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 15 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND ELECTRIC DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 51400-550 IN LIEU OF TAX 546,718.00 43,390.93 90,308.12 16.52 456,409.88 TOTAL SUNDRY CHARGES 546, 718.00 43,390.93 90,308.12 16.52 456, 409.88 CAPITAL OUTLAY * DEPARTMENT TOTAL 4,626,204.00 360,983.11 786,300.91 17.00 3,839,903.09 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 16 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 20 -UTILITY FUND CAPITAL OUTLAY DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY 51999-601 ADMINISTRATION 95,281.00 0.00 59,867.20 62.83 35,413.80 51999-614 ELECTRIC 194,442.00 0.00 0.00 0.00 194,442.00 51999-616 SEWER COLLECTION 35,000.00 0.00 1,378.72 3.94 33,621.28 51999-617 WATER DISTRIBUTION 70,000.00 1,000.00 2,378.72 3.40 67,621.28 51999-621 BOND NATER TOWER 0.00 807.50 807.50 0.00 807.50) 51999-622 BOND SEWER INVENTORY 0.00 65,995.75 65,995.75 0.00 65,995.75) TOTAL CAPITAL OUTLAY 394,723.00 67,803.25 130,427.89 33.04 264,295.11 * DEPARTMENT TOTAL 394,723.00 67,803.25 130,427.89 33.04 264,295.11 * TOTAL EXPENDITURES 10,941,522.00 728,667.47 1,607,847.82 14.69 9,333,674.18 * REVENUES OVER/ (UNDER) EXPENDITURES - 379,532.00) 74,489.84 78,863.58 20.78- 458,395.58) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 22 -COUNCIL RESTRICTED FUND FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUES 65,000.00 1,410.41 2,909.74 4.48 62,090.26 TOTAL REVENUES 65,000.00 1,410.41 2,909.74 4.48 62,090.26 EXPENDITURE SUMMARY WATER/SEWER 95,000.00 0.00 16,762.63 17.64 78,237.37 CAPITAL OUTLAY 130,100.00 0.00 0.00 0.00 130,100.00 ** * TOTAL XPENDITURES 225,100.00 0.00 16,762.63 7.45 208,337.37 REVENUES OVER/ (UNDER) EXPENDITURES 160,100.00) 1,410.41 13,852.89) 8.65 146,247.11) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 22 -COUNCIL RESTRICTED FUND REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUES 4701 INTEREST 24,000.00 1,410.41 2,909.74 12.12 21,090.26 4999 TRANSFERS IN 41,000.00 0.00 0.00 0.00 41,000.00 TOTAL REVENUES 65,000.00 1,410.41 2,909.74 4.48 62,090.26 *** TOTAL REVENUE 65,000.00 1,410.41 2,909.74 4.48 62,090.26 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 22 -COUNCIL RESTRICTED FUND WATER/SEWER DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES 51325-426 PROFESSIONAL FEES 95,000.00 0.00 16,762.63 17.64 78,237.37 TOTAL SERVICES 95,000.00 0.00 16,762.63 17.64 78,237.37 * DEPARTMENT TOTAL 95,000.00 0.00 16,762.63 17.64 78,237.37 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 22 -COUNCIL RESTRICTED FUND CAPITAL OUTLAY DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY 51999-613 SEWER PLANT 50,000.00 0.00 0.00 0.00 50,000.00 51999-618 WATER PLANT 80,100.00 0.00 0.00 0.00 80,100.00 TOTAL CAPI TAL OUTLAY 130,100.00 0.00 0.00 0.00 130,100.00 ** ** DEPARTMENT TOTAL 130,100.00 0.00 0.00 0.00 130,100.00 * TOTAL EXPENDITURES 225,100.00 0.00 16,762.63 7.45 208,337.37 * REVENUES OVER/ (UNDER) EXPENDITURES ( 160,100.00) 1,410.41 13,852.89) 8.65 146,247.11) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 25 -CHRISTMAS LIGHTING FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY STARRY, STARRY NIGHTS 11,700.00 0.00 0.00 0.00 11,700.00 GENERAL 2,400.00 143.68 299.10 12.46 2,100.90 ** * TOTAL REVENUES 14,100.00 143.68 299.10 2.12 13,800.90 EXPENDITURE SUMMARY STARRY STARRY NIGHTS 17,600.00 2,886.66 2,886.66 16.40 14,713.34 ** * TOTAL EXPENDITURES 17,600.00 2,886.66 2,886.66 16.40 14,713.34 REVENUES OVER/ (UNDER) EXPENDITURES 3,500.00) 2,742.98) 2,587.56) 73.93 912.44) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 25 -CHRISTMAS LIGHTING REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE STARRY, STARRY NIGHTS 4102 PARK COLLECTION BUCKET DONATIO 5,200.00 0.00 0.00 0.00 5,200.00 4103 CONCESSION SALES 2,300.00 0.00 0.00 0.00 2,300.00 4104 PHOTOS WITH ANTA 2,000.00 0.00 0.00 0.00 2,000.00 4109 SNOW DAY 2,000.00 0.00 0.00 0.00 2,000.00 4115 VEND DOR BOOTH RENTAL 200.00 0.00 0.00 0.00 200.00 TOTAL STARRY, STARRY NIGHTS 11,700.00 0.00 0.00 0.00 11,700.00 GENERAL 4701 INTEREST 2,400.00 143.68 299.10 12.46 2,100.90 TOTAL GENERAL 2,400.00 143.68 299.10 12.46 2,100.90 TOTAL REVENUE 14,100.00 143.68 299.10 2.12 13,800.90 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 25 -CHRISTMAS LIGHTING STARRY STARRY NIGHTS DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUPPLIES 50100-203 CONCESSIONS 4,200.00 341.87 341.87 8.14 3,858.13 50100-205 OPERATIONAL SUPPLIES 1,700.00 0.00 0.00 0.00 1,700.00 50100-209 SNOW 7,000.00 0.00 0.00 0.00 7,000.00 50100-210 PHOTO EXPENSE 400.00 0.00 0.00 0.00 400.00 50100-213 OVIE EXPENSE 100.00 0.00 0.00 0.00 100.00 TOTAL SUPPLIES 13,400.00 341.87 341.87 2.55 13,058.13 MAINTENANCE AND REPAIRS 50100-303 DISPLAY MAIN T NCE E 3,000.00 2,538.25 2,538.25 84.61 461.75 50100-305 BUILDING & GROUNDS 1,200.00 6.54 6.54 0.55 1,193.46 TOTAL MAIN N'T TE E NCE AND REPAIRS 4,200.00 2,544.79 2,544.79 60.59 1,655.21 SERVICES CAPITAL OUTLAY DEPARTMENT TOTAL 17,600.00 2,886.66 2,886.66 16.40 14,713.34 TOTAL EXPENDITURES 17,600.00 2,886.66 2,886.66 16.40 14,713.34 REVENUES OVER/ (UNDER) EXPENDITURES ( 3,500.00) 2,742.98) 2,587.56) 73.93 912.44) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 50 -CEMETERY FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUE 900.00 63.09 131.34 14.59 768.66 * TOTAL REVENUES 900.00 63.09 131.34 14.59 768.66 EXPENDITURE SUMMARY EXPENSES 5,000.00 0.00 0.00 0.00 5,000.00 * TOTAL EXPENDITURES 5,000.00 0.00 0.00 0.00 5,000.00 * REVENUES OVER/ (UNDER) EXPENDITURES ( 4,100.00) 63.09 131.34 3.20- 4,231.34) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 50 -CEMETERY REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE 4701 INTE EREST ON INVESTMENTS 900.00 63.09 131.34 14.59 768.66 TOTAL REVENUE 900.00 63.09 131.34 14.59 768.66 ** TOTAL REVENUE 900.00 63.09 131.34 14.59 768.66 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 50 -CEMETERY EXPENSES DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUPPLIES SERVICES CAPITAL OUTLAY 50600-602 BUILDING AND GRO OUNDS 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL CAPITAL OUTLAY 5,000.00 0.00 0.00 0.00 5,000.00 * DEPARTMENT TOTAL 5,000.00 0.00 0.00 0.00 5,000.00 * * TOTAL EXPENDITURES 5,000.00 0.00 0.00 0.00 5,000.00 * REVENUES OVER/ (UNDER) EXPENDITURES ( 4,100.00) 63.09 131.34 3.20- 4,231.34) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 51 -CEMETERY PERPETUAL CARE FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUE 2,000.00 162.08 335.31 16.77 1,664.69 * TOTAL REVENUES 2,000.00 162.08 335.31 16.77 1,664.69 EXPENDITURE SUMMARY EXPENSES 6,500.00 0.00 0.00 0.00 6,500.00 * TOTAL EXPENDITURES 6,500.00 0.00 0.00 0.00 6,500.00 * REVENUES OVER/ (UNDER) EXPENDITURES ( 4,500.00) 162.08 335.31 7.45- 4,835.31) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 51 -CEMETERY PERPETUAL CARE REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE 4701 INTEREST 2,000.00 162.08 335.31 16.77 1,664.69 TOTAL REVENUE 2,000.00 162.08 335.31 16.77 1,664.69 ** TOTAL REVENUE 2,000.00 162.08 335.31 16.77 1,664.69 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 51 -CEMETERY PERPETUAL CARE EXPENSES DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY 50600-602 BUILDING AND ROUNDS 6,500.00 0.00 0.00 0.00 6,500.00 TOTAL CAPITAL OUTLAY 6,500.00 0.00 0.00 0.00 6, 500.00 * DEPARTMENT TOTAL 6,500.00 0.00 0.00 0.00 6,500.00 * * TOTAL EXPENDITURES 6,500.00 0.00 0.00 0.00 6,500.00 REVENUES OVER/ (UNDER) EXPENDITURES ( 4,500.00) 162.08 335.31 7.45- 4,835.31) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 55 -AIRPORT FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUE 1,505,435.00 44,678.07 77,587.75 5.15 1,427,847.25 * TOTAL REVENUES 1,505,435.00 44,678.07 77,587.75 5.15 1,427,847.25 = EXPENDITURE SUMMARY AIRPORT 502,132.00 38,949.07 103,490.45 20.61 398,641.55 CAPITAL OUTLAY 1,000,000.00 0.00 0.00 0.00 1,000,000.00 ** * TOTAL XPENDITURES 1,502,132.00 38,949.07 103,490.45 6.89 1,398,641.55 REVENUES OVER/ (UNDER) EXPENDITURES 3,303.00 5,729.00 25,902.70) 784.22- 29,205.70 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 55 -AIRPORT REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE 4570 FUEL SALES 360,000.00 19,081.38 40,726.06 11.31 319,273.94 4571 HANGER RENT 80, 000.00 4,024.00 10,789.00 13.49 69,211.00 4572 LAND LEASE 500.00 0.00 0.00 0.00 500.00 4574 COVERED PARKING RENT 550.00 72.00 72.00 13.09 478.00 4575 SPECIAL EVENTS 26,500.00 21,500.69 26,000.69 98.12 499.31 4612 TXDOT GRANT 900,000.00 0.00 0.00 0.00 900,000.00 4621 TXDOT RAMP RANT PR ROCEEDS 50,000.00 0.00 0.00 0.00 50,000.00 4999 TRANSFER IN 87,885.00 0.00 0.00 0.00 87,885.00 TOTAL REVENUE 1,505,435.00 44,678.07 77,587.75 5.15 1,427,847.25 * * TOTAL REVENUE 1,505,435.00 44,678.07 77,587.75 5.15 1,427,847.25 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 55 -AIRPORT AIRPORT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE PERSONAL SERVICES 50900-101 SALARIES 64,235.00 6,337.63 12,201.32 18.99 52,033.68 50900-103 OVERTIME 6,500.00 233.73 236.50 3.64 6,263.50 50900-104 FICA 5,420.00 502.71 951.48 17.55 4,468.52 50900-105 RETIREMENT 6,740.00 537.19 1,069.04 15.86 5,670.96 50900-106 HEALTH INSURANCE 16,450.00 1,360.60 1,360.60 8.27 15,089.40 50900-107 CLOTHING 300.00 0.00 0.00 0.00 300.00 50900-109 LONG TERM DISABILITY 130.00 0.00 0.00 0.00 130.00 50900-115 WORKERS COMPENSATION 1,390.00 0.00 0.00 0.00 1,390.00 50900-117 DENTAL NSURANCE 1,100.00 37.17 37.17 3.38 1,062.83 50900-118 LIFE INSURANCE 60.00 24.00 24.00 40.00 36.00 50900-120 N YEE BONUS 110.00 0.00 0.00 0.00 110.00 TOTAL PERSONAL SERVICES 102,435.00 9,033.03 15,880.11 15.50 86,554.89 SUPPLIES 50900-201 OFFICE PE LIES 200.00 139.98 139.98 69.99 60.02 50900-204 SMALL TOOLS 100.00 0.00 0.00 0.00 100.00 50900-205 OPE E IO I NAL S 1,500.00 44.00 121.50 8.10 1,378.50 50900-210 FUEL 1,000.00 55.32 55.32 5.53 944.68 50900-212 AVI TION FUEL 280,000.00 653.69 50,824.38 18.15 229,175.62 50900-213 AVIATION OIL/RETAIL STOCK 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL SUPPLIES 283,800.00 892.99 51,141.18 18.02 232,658.82 MAINTENANCE AND REPAIRS 50900-302 VEHICLE MAINTENANCE 7,800.00 0.00 0.00 0.00 7,800.00 50900-303 EQUIPMENT 7,000.00 1,675.00 6,078.44 86.83 921.56 50900-305 BUILDING AND GROUNDS 50,000.00 8.78 58.78 0.12 49,941.22 TOTAL MAINTENANCE AND REPAIRS 64,800.00 1,683.78 6,137.22 9.47 58,662.78 SERVICES 50900-401 COMMUNICATIONS 5,400.00 569.53 990.67 18.35 4,409.33 50900-402 ELECTRIC 11,000.00 620.82 1,236.35 11.24 9,763.65 50900-416 RENTAL OF EQUIPMENT 500.00 40.00 80.00 16.00 420.00 50900-420 DUES, FEES & MEMBERSHIPS 6,500.00 0.00 0.00 0.00 6,500.00 50900-428 SPEC IAL EVENTS EXPI NSES 23,197.00 26,108.92 28,024.92 120.81 4,827.92) TOTAL SERVICES 46,597.00 27,339.27 30,331.94 65.09 16,265.06 SUNDRY CHARGES 50900-505 INSUR RA ANCE LIABILITY 4,500.00 0.00 0.00 0.00 4,500.00 TOTAL SUNDRY CHARGES 4,500.00 0.00 0.00 0.00 4,500.00 CAPITAL OUTLAY DEPARTMENT TOTAL 502,132.00 38,949.07 103,490.45 20.61 398,641.55 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 55 -AIRPORT CAPITAL OUTLAY DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY 50999-692 GRANT EXPENDITURES 1,000,000.00 0.00 0.00 0.00 1,000,000.00 TOTAL CAPITAL OUTLAY 1,000,000.00 0.00 0.00 0.00 1,000,000.00 * DEPARTMENT TOTAL 1,000,000.00 0.00 0.00 0.00 1,000,000.00 = * * TOTAL EXPENDITURES 1,502,132.00 38,949.07 103,490.45 6.89 1,398,641.55 REVENUES OVER/ (UNDER) EXPENDITURES 3,303.00 5,729.00 25,902.70) 784.22- 29,205.70 END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 62 -HOTEL OCCUPANCY TAX FUND FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY 165,000.00 10,911.58 19,368.06 11.74 145,631.94 TOTAL REVENUES 165,000.00 10,911.58 19,368.06 11.74 145,631.94 EXPENDITURE SUMMARY ADMINISTRATION 171,910.00 2,395.12 2,795.12 1.63 169,114.88 TOTAL EXPENDITURES 171,910.00 2,395.12 2,795.12 1.63 169,114.88 * REVENUES OVER/ (UNDER) EXPENDITURES ( 6,910.00) 8,516.46 16,572.94 239.84- 23,482.94) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 62 -HOTEL OCCUPANCY TAX FUND REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 4106 HOTEL/MOTEL TAX 165,000.00 10,911.58 19,368.06 11.74 145,631.94 TOTAL 165,000.00 10,911.58 19,368.06 11.74 145,631.94 * TOTAL REVENUE 165,000.00 10,911.58 19,368.06 11.74 145,631.94 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 62 -HOTEL OCCUPANCY TAX FUND ADMINISTRATION DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 50200-521 CHAMBER OF COMMERCE 123, 900.00 0.00 0.00 0.00 123,900.00 50200-522 LLANO MUSEUM 23,010.00 0.00 0.00 0.00 23,010.00 50200-523 HOT TAX DISTRIBUTIONS 25,000.00 2,395.12 2,795.12 11.18 22,204.88 TOTAL SUNDRY CHARGES 171,910.00 2,395.12 2,795.12 1.63 169,114.88 * DEPARTMENT TOTAL 171,910.00 2,395.12 2,795.12 1.63 169,114.88 * * TOTAL EXPE ENDITURES 171,910.00 2,395.12 2,795.12 1.63 169,114.88 REVENUES OVER/ (UNDER) EXPENDITURES ( 6,910.00) 8,516.46 16,572.94 239.84- 23,482.94) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 78 -TEXAS WATER DEVELOPMENT B FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUES 25,000.00 2,876.24 5,807.15 23.23 19,192.85 TOTAL REVENUES 25,000.00 2,876.24 5,807.15 23.23 19,192.85 EXPENDITURE SUMMARY SANDSTONE AC LINE 228,810.00 0.00 0.00 0.00 228,810.00 MAIN STREET TRUNK LINE 44,570.00 0.00 0.00 0.00 44,570.00 ** * TOTAL XPENDITURES 273,380.00 0.00 0.00 0.00 273,380.00 REVENUES OVER/ (UNDER) EXPENDITURES 248,380.00) 2,876.24 5,807.15 2.34- 254,187.15) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 78 -TEXAS WATER DEVELOPMENT B REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUES 4701 INTEREST 25,000.00 2,876.24 5,807.15 23.23 19,192.85 TOTAL REVENUES 25,000.00 2,876.24 5,807.15 23.23 19,192.85 * TOTAL REVENUE 25,000.00 2,876.24 5,807.15 23.23 19,192.85 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 78 -TEXAS WATER DEVELOPMENT B SANDSTONE AC LINE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES SUNDRY CHARGES CAPITAL OUTLAY 51325-610 SANDSTONE AC LINE 228,810.00 0.00 0.00 0.00 228,810.00 TOTAL CAPITAL OUTLAY 228,810.00 0.00 0.00 0.00 228,810.00 * DEPARTMENT TOTAL 228,810.00 0.00 0.00 0.00 228,810.00 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 78 -TEXAS WATER DEVELOPMENT B MAIN STREET TRUNK LINE DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES CAPITAL OUTLAY 51375-610 MAIN STREET TRUNK LINE 44,570.00 0.00 0.00 0.00 44,570.00 TOTAL CAPITAL OUTLAY 44,570.00 0.00 0.00 0.00 44,570.00 * DEPARTMENT TOTAL 44,570.00 0.00 0.00 0.00 44,570.00 * * TOTAL EXPE ENDITURES 273,380.00 0.00 0.00 0.00 273,380.00 REVENUES OVER/ (UNDER) EXPENDITURES ( 248,380.00) 2,876.24 5,807.15 2.34- ( 254,187.15) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 80 -PAVING/PARK BOND PROJECTS FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY REVENUE 55,000.00 2,692.38 5,570.09 10.13 49,429.91 * TOTAL REVENUES 55,000.00 2,692.38 5,570.09 10.13 49,429.91 EXPENDITURE SUMMARY PAVING 393,756.00 0.00 0.00 0.00 393,756.00 PAVING PROJECT 50,000.00 0.00 0.00 0.00 50,000.00 ** * TOTAL XPENDITURES 443,756.00 0.00 0.00 0.00 443,756.00 REVENUES OVER/ (UNDER) EXPENDITURES 388,756.00) 2,692.38 5,570.09 1.43- 394,326.09) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 80 -PAVING/PARK BOND PROJECTS REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE 4701 INTEREST 30,000.00 2,692.38 5,570.09 18.57 24,429.91 4999 TRANSFERS IN 25,000.00 0.00 0.00 0.00 25,000.00 TOTAL REVENUE 55,000.00 2,692.38 5,570.09 10.13 49,429.91 *** TOTAL REVENUE 55,000.00 2,692.38 5,570.09 10.13 49,429.91 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 80 -PAVING/PARK BOND PROJECTS PAVING DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SERVICES CAPITAL OUTLAY 50800-610 STREETS 393,756.00 0.00 0.00 0.00 393,756.00 TOTAL CAPITAL OUTLAY 393,756.00 0.00 0.00 0.00 393,756.00 * DEPARTMENT TOTAL 393,756.00 0.00 0.00 0.00 393,756.00 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 80 -PAVING/PARK BOND PROJECTS PAVING PROJECT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUPPLIES SERVICES 51300-426 PROFESSIONAL FEES 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL SERVICES 50,000.00 0.00 0.00 0.00 50,000.00 CAPITAL OUTLAY DEPARTMENT TOTAL 50,000.00 0.00 0.00 0.00 50,000.00 * * TOTAL EXPENDITURES 443,756.00 0.00 0.00 0.00 443,756.00 * REVENUES OVER/ (UNDER) EXPENDITURES ( 388,756.00) 2,692.38 5,570.09 1.43- 394,326.09) END OF REPORT 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 95 -MAIN STREET FINANCIAL SUMMARY ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY 25,600.00 1,308.43 2,114.87 8.26 23,485.13 TOTAL REVENUES 25,600.00 1,308.43 2,114.87 8.26 23,485.13 EXPENDITURE SUMMARY 27,750.00 344.10 1,414.73 5.10 26,335.27 * TOTAL EXPENDITURES 27,750.00 344.10 1,414.73 5.10 26,335.27 * REVENUES OVER/ (UNDER) EXPENDITURES ( 2,150.00) 964.33 700.14 32.56- 2,850.14) 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 95 -MAIN STREET REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 4701 INTE EREST 2,000.00 151.84 315.31 15.77 1,684.69 4704 LANTEX CONCESSION 10,000.00 592.15 1,040.19 10.40 8,959.81 4709 LANTEX TICKET SALES 10,000.00 520.09 715.02 7.15 9,284.98 4716 SPONSORSHIPS 3,000.00 0.00 0.00 0.00 3,000.00 4725 ALCOHOLIC BEVERAGE SALES 600.00 44.35 44.35 7.39 555.65 TOTAL 25,600.00 1,308.43 2,114.87 8.26 23,485.13 * TOTAL REVENUE 25,600.00 1,308.43 2,114.87 8.26 23,485.13 12-26-2024 01:19 PM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 95 -MAIN STREET DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUPPLIES 50100-205 OPERATIONAL SUPPLIES 200.00 0.00 0.00 0.00 200.00 50100-213 LANTEX CONCESSIONS 5,000.00 0.00 0.00 0.00 5,000.00 50100-214 LANTEX FILM EXPENSE 10,000.00 327.00 1,129.48 11.29 8,870.52 TOTAL SUPPLIES 15,200.00 327.00 1,129.48 7.43 14,070.52 MAINTENANCE AND REPAIRS SERVICES 50100-412 AVEL AND NING 2,500.00 0.00 0.00 0.00 2,500.00 50100-461 CREDIT CARD FEES 200.00 17.10 30.72 15.36 169.28 TOTAL ERVICES 2,700.00 17.10 30.72 1.14 2,669.28 SUNDRY CHARGES 50100-505 FACADE IMPROVMENT AWARDS 4,500.00 0.00 0.00 0.00 4,500.00 50100-525 LANTEX R ROFIT SH ING 2,600.00 0.00 254.53 9.79 2,345.47 50100-530 SPECIAL PROJECTS 2,750.00 0.00 0.00 0.00 2,750.00 TOTAL SUNI ORY SES 9,850.00 0.00 254.53 2.58 9,595.47 * * DEPARTMENT TOTAL 27,750.00 344.10 1,414.73 5.10 26,335.27 12-26-2024 01:19 PM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: NOVEMBER 30TH, 2024 95 -MAIN STREET DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE MAINTENANCE AND REPAIRS TOTAL EXPENDITURES 27,750.00 344.10 1,414.73 5.10 26,335.27 REVENUES OVER/ (UNDER) EXPENDITURES ( 2,150.00) 964.33 700.14 32.56- 2,850.14) END OF REPORT