MAYOR ALDERMEN Marion Bishop Larry Sawyer Laura Almond MAYOR PRO-TEM Les McDanicl Kara Gilliland 6 Kelli Tudyk REGULAR CALLED MEETING OF THE LLANO CITY COUNCIL CITY HALL, 301 WEST MAIN STREET, LLANO, TEXAS PRECEDING BOARD OF ADJUSTMENT MEETING 5:30 P.M. TUESDAY,JANUARY 21,2 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. 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. C. PRESENTATION OF EMPLOYEE Cathryn Ray-Excellence and Professionalism D. EXECUTIVE CLOSED SESSION 1. The City Council will convene into Executive Session in accordance with the Texas Government Code Section 551.074 Personnel Matters regarding the Mayor. 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. 3. The City Council will convene into Executive Session in accordance with the Texas Government Code Section 551.072 deliberations regarding the possible acquisition ofr real property. E. EXECUTIVE OPEN SESSION 1. The City Council will reconvene into Open Session for the discussion and possible action regarding Personnel Matters regarding the Mayor. 2. The City Council will reconvene in Open Session for discussion and possible action regarding legal matters. 3. The City Council will reconvene in Open Session for discussion and possible action regarding possible acquisition of real property. F. CONSENT AGENDA ITEMS 1. Approve the Llano City Council Regular Meeting Minutes from January 6, 2025, meeting. 2. Approve the Llano City Council Special Called Meeting Minutes from January 13, 2025, meeting. 3. Approval oft the Fiscal Year 2025 Ist Quarter Investment Report. G. REGULAR AGENDA ITEMS 1. Discussion and possible action to approve Engineering Services Agreement with Freese and Nicholes for Sewer System Condition Assessment Support and authorize the mayor to execute documents. Josh Becker, Director ofWater and Wastewater Operations 2. Discussion and possible action on the approval and awarding of discretionary local Hotel Occupancy Tax Revenues for the 2024/2025 funding cycle as recommended by the Hotel/Motel Funding Committee. Kim Wagner, City Secretary 3. Discussion and possible action to approve Task Order No. 26 Amendment 1 with Steger Bizzell for Water Tower Painting Project. Josh Becker, Director of Water & Wastewater Operations H. MONTHLY REPORTS I. ADJOURNMENT Ifduring the course ofthe meeting and discussion ofany items covered by this notice, Cily 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 of 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, ifnecessary, 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 ofthe. January 21, 2025 Llano City Council agenda was posted on the City Hall bulletin board, a place convenient and readily accessible to the gencral public at all times, and to the City's website, www. CityofLlano.com, in compliance with Chapter 551, Texas Government Code and remained posted continuously for at least seventy-twb (72) hours preceding the scheduled time of said Meeting. Wag H17-34 Kim a:50pr Wagner, TRMC CitylSecretary Date, and Time Posted REGULAR CALLED MEETING OF THE LLANO CITY COUNCIL CITY HALL, 301 WEST MAIN STREET, LLANO, TEXAS 5:30 P.M. MONDAY,JANUARY 6, 2025 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 ALLEGIANCE TO U.S AND TEXAS FLAGS and INVOCATION Reverend Reitmeyer gave the 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 oft 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 ofthis subchapter do not apply to: 1. A statement of specific information given in response to thei 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. AI motion was made by Alderwoman Almond, with a second by Alderwoman Gilliland to approve the consent agenda items. Alli in favor, none opposed. Motion carried. 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 A motion was made by Alderwoman Tudyk, with a second by Alderwoman Gilliland to appoint Brian Maples and George Fricke to the Planning and Zoning Board. All in favor, none opposed. Motion carried. 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 A motion was made by Alderwoman Almond. with a second by Alderwoman Gilliland to approve the reappointment of Dawn Harris, Joe Johnson, Wendal Pyles and Richard Smidt to the Historic Preservation Board. Alli in favor, none opposed. Motion carried. 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 A motion was made by Alderwoman Almond, with a second by Alderwoman Gilliland to award a contract to Maquire Iron, Inc. for the water tower painting project to paint L.E.C. and L.L. Ground Storage Tanks. All in favor, none opposed. Motion carried. 4. Discussion and possible action regarding an amendment to Ordinance No. 1546 regarding the Budget for FY 2024-2025. Cara Hewitt, Finance Director A motion was made by Alderwoman Tudyk, with a second by Alderwoman Gilliland to approve Ordinance No. 1546 regarding the Budget for FY 2024- 2025. All in favor. none opposed. Motion carried. 5. Discussion and possible action regarding the purchase of upgraded VFD Control Panel, new manifold and hydro tank removal. Marty. Mangum, City Manager A motion was made by Alderwoman Tudyk, with a second by Alderman Sawyer to approve up to 160,000 to upgrade the VFD control panel, new manifold and hydro tank removal. All in favor. none opposed. Motion carried. F. MONTHLY REPORTS G. ADJOURNMENT The city council meeting adjourned at 5:48 p.m. Ifduring the course of 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 gift; 551.074 personnel matters regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee; 551.076 implementation of 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, ifnecessary, on the items addressed during the Executive Session. Although a quorum ofthe members ofother Boards or Commissions may or may not be in attendance, this notice is being posted to meet the requirements oft 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 of the January 6, 2025 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.Cilyollamo.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 SPECIAL CALLED MEETING OF THE LLANO CITY COUNCILCITY HALL, 301 WEST MAIN STREET, LLANO, 5:30 P.M. MONDAY,JANUARY 13, 2025 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. 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. C. EXECUTIVE CLOSED SESSION 1. The City Council will convene into Executive Session in accordance with the Texas Government Code Section 551.072 deliberations regarding the possible acquisition of real property. The executive session opened at 5:30 p.m. and closed at 6:32 p.m. D. REGULAR AGENDA ITEMS 1. Discussion and possible action regarding the appointment of a Real Estate Representative to negotiate for the city on a possible real estate transaction. A motion was made by Alderwoman Almond, with a second by Alderwoman Tudyk to name. John Osbourn to negotiate for the city and the possible acquisition of some real property. Four in favor, Alderwoman Gilliland opposed. Motion carried. E. ADJOURNMENT The City Council Meeting adjourned at 6:34 p.m. Ifduring the course of 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 gift; 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; 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, ifnecessary, on the items addressed during the Executive Session. Although a quorum of 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 of the January 21, 2025 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 1/21/25 Agenda Item: Consent a 59 Item/Subject: Approval of the Fiscal Year 2025 1st Quarter Investment Report. Initiating Department/Presenter. Cara Hewitt, Director of Finance Recommended Motion: I - move to approve the First Quarter Investment Report for period ending December 31, 2024. Background/History: The Public Funds Investment Act at Texas Government Code, Section 2256.005 requires the governing body of an investing entity to review its investment policy and investment strategies not less than annually. Provided is the second quarter Investment report. Findings/Current Activity: The First Quarter Investment Report for Fiscal Year 2025 has investment earnings for the quarter of $137,545 with the average yield for all investments at 4.51%. Financial Implications: There is no financial impact associated with this item. Jitem is budgeted: In the amount of $ (amount in the budget account) JItem is not budgeted: Jitem is estimated to generate additional revenue: Associated Information: Attached: 1st Quarter Investment Report Agenda Item # Consent City of Llano Quarterly Investment Report Ending December 31, 2024 Beginning Quarterly Ending Avg Investment Type Descript/Loc Maturity Balance Activity Interest Balance Yield 9/30/2024 12/31/2024 Consolidated Cash Bancorp South Open 1,472,554 (117,614) 8,797 1,363,737 Tax I&S Bancorp South Open 120,649 200,613 1,585 322,847 Electronic Payments Bancorp South Open 55,633 19,495 622 75,750 Norton Cemetery Bancorp South Open 20,144 (0) 194 20,338 Economic Development Corp Bancorp South Open 572,130 72,505 6,018 650,653 FSA&HRA Bancorp South Open 5,607 (4,751) 856 Main Street Bancorp South Open 42,538 745 411 43,694 TWDB Series 2018 Bancorp South Open 103 0 1 104 Christmas Lighting Bancorp South Open 45,874 (9,687) 435 36,622 Main Street Façade Bancorp South Open 5,936 (0) 58 5,994 Subtotai Cadence Bank 2,341,168 161,306 18,121 2,520,596 2.96% Utility Fund Reserve TexPool Open 146,229 0 1,752 147,982 General Fund Operating TexPool Open 582,476 (0) 6,979 589,455 Council Restricted Sinking TexPool Open 30,434 (0) 365 30,799 Series 2022 CO TexPool Open 22,558 200,000 2,667 225,224 RDI Bond Reserve TexPool Open 301,241 3,609 304,850 Economic Development Corp TexPool Open 350,621 (0) 4,201 354,822 Series 2017 General Obligation TexPool Open 689,636 0 8,263 697,899 Subtotal TexPool 2,123,195 200,000 27,836 2,351,030 5.25% Utility Fund Reserve Texas Class Open 1,064,033 0 13,160 1,077,193 General Fund Operating Texas Class Open 2,070,855 (300,000) 24,007 1,794,862 Council Restricted Sinking Texas Class Open 320,705 (0) 3,966 324,671 Series 2022 CO Texas Class Open 4,039,273 (0) 49,957 4,089,230 Subtotal Texas Class 7,494,866 (300,000) 91,090 7,285,956 4.89% Police Benevolent Fund Llanol National Bank Open 2,871 (0) U 2,871 PD Seizure Fund Llano National Bank Open 66 0 66 Subtotal Llano National Bank 2,937 0 2,937 0.05% TOTAL CITY ACCOUNTS 11,962,166 61,306 137,048 12,1 160,519 Cemetery Perpetual Care Cadence Bank Open 130 2 132 Cemetery TexPool Open 41,404 496 41,900 TOTAL AGENCY ACCOUNTS 41,534 498 42,032 4.72% GRAND TOTAL ALL INVESTMENTS 12,003,700 61,306 137,545 12,202,551 4.51% Performance Measures: Benchmark Actual Avg Yield 4.32% 4.51% Benchmark-64 Mo. T-Bill Diversifiçation: Max 100% TexPool 19.61% Texas Class 59.71% Banks 20.68% CD's 0.00% IN a Marty Mangum, City Admirsitrator Finance Director Hislas CarHewitt, Datf CITY COUNCIL AGENDA 1/21/25 Agenda Item: G1 a Item/Subject: Discussion and possible action to approve Engineering Services Agreement with Freese and Nicholes for Sewer System Condition Assessment Support and authorize the mayor to execute documents. Initiating Department/Presenter: Josh Becker, Director of Water and Wastewater Operations Recommended Motion: Motion to approve and authorize the mayor to execute documents. Background/History: The City of Llano has a task order with Stigger & Bizzell to bid and perform a data review on a sewer inspection project. Recently, the city awarded the bid for the inspection portion of this project. The city recently entered into a service agreement with F&N for a water and wastewater map migrations project. Findings/Current Activity: Staff met with S&B and F&N to discuss data sharing between the two firms concerning this project. During this meeting, it was noted that the task order for S&B is billed based on time spent with no set project value. This would allow the city to have S&B do as much or as little on the project as the city desired. F&S has offered to perform the data review, integrate it into the new GIS, and then provide S&B with a list of recommended projects to incorporate into the upcoming CIP. S&B agreed that this would be a much better use for the data collected and allow for future access for easy review. The city received a service agreement proposal from F&N for this project for $199,331.00. There is an estimated $234,000 remaining in the inspection project funds. This project scope will overlap the wastewater portion of the GIS migrations project, allowing some funds from the GIS migration project to be reallocated to GPS mapping water assets, increasing the accuracy of the new maps once finished. Financial Implications: Item is budgeted: 20-51999-622 In the amount of $678,000 less current approvals. Associated Information: Sewer System Condition Assessment Support Proposal Agenda Item # G1 Innovative approaches FREESE Practical results NICHOLS Outstandingservice 9601 McAllister Fwy., Suite 1008 + San Antonio, Texas 78216 + 210-298-3800 + FAX 817-735-7491 www.freese.com January 9, 2025 Exhibit B: Engineering Services City of Llano Sewer System Condition Assessment Support Project Understanding The City of Llano is performing a condition assessment of its sewer system, which includes CCTV inspections of the sewer mains and visual inspections of sewer manholes. The CCTV inspection results will be provided MS Access file formats, which can be associated with the City's sewer GIS. The manhole inspections would be pdf files of inspection forms notated in the field. The condition assessment results will be utilized to identify sewer system improvements to be incorporated into the City's Capital Improvement Plan. Additionally, the City would like to leverage the condition assessment activities to resolve location discrepancies of the sewer manholes and mains. The contractor performing the manhole inspections doesn't have the means to document them digitally or collect survey-grade location data but is willing to do sO if given the means. As part of this project, Freese and Nichols, Inc. (FNI) will develop an ESRI ArcGIS Online Field Maps application using the City's sewer system GIS. The Contractor will use the application to document the manhole inspection findings and collect survey-grade location data for each manhole inspected. The City will be responsible for providing the required hardware to the Contractor. FNI will incorporate the sewer main and manhole inspection results into GIS to update the location of the features and create mapping of the observed defects. FNI will also develop improvement recommendations based on the defects observed during the inspections. Scope of Services Task A. Project Management As part of Task A, FNI will perform general project management tasks including: Prepare monthly invoices, progress reports, and project coordination with the City. Conduct a kick-off meeting with City Staff to discuss project goals, scope, schedule, milestones, and an overview of the proposed sewer manhole inspection application. FNI will prepare and submit meeting minutes to the City for review within two weeks. prepare for and lead six (6) virtual progress meetings with the City to review the project's progress. FNI will prepare and submit meeting minutes to the City for review within two weeks. Task B. Sewer System GIS Updates As part of Task B, FNI will perform GIS tasks including: Revise the alignment and attributes of the City's sewer main and manhole GIS features based on data collected as part of the condition assessment project. Where sewer manholes are found in the field that are not represented in GIS, FNI will create a new sewer manhole and split the existing sewer main in GIS to accurately reflect field conditions. Perform data QA/QC processes to verify connectivity and flow direction of the finalized sewer system updates. FREESE Sewer System Condition Assessment Support MICHOIS 1/9/2025 Page 2 of 3 Publish the GIS updates to the City's ArcGIS Online environment and the sewer system web map. Task C. Sewer Manhole Inspection Application Development As part of Task C, FNI will perform the following GIS application development tasks including: Develop an ESRI Field Maps application to digitally recreate the NASSCO MACP Level 1 inspection form. The application will be associated with the City's sewer system GIS data in City's ArcGIS Online environment. Conduct a training session with the City and its inspection contractor on utilizing the ArcGIS Field Map application. Provide troubleshooting support to the City and the inspection contractor as they use the application to complete inspections in the field. Prepare a training document for the ArcGIS Field Map application setup and training. FNI will submit one (1) electronic PDF copy of the draft document for City's review. Review the draft training documentation with the City during a progress meeting to solicit comments. Finalize the memo based on comments provided by the City and submit one (1) electronic PDF copy of the final document. Task D: Condition Assessment Review & Improvement Recommendations As part of Task D, FNI will perform the following tasks including: Serve as an Advisor to support the City while the Contractor pertorms the condition assessment to ensure the work supports the ongoing GIS project. Perform a QC review of the CCTV and manhole inspection data and coordinate with the contractor on potential discrepancies or issues requiring re-inspection. Summarize observed sewer main and manhole defects based on data provided by the Contractor. Create GIS layers of the observed sewer main and manhole defects and create mapping of the defect locations overlaid on the sewer system. Assign a condition score to the inspected sewer main and manholes based on observed structural defects. Develop renewal improvements for sewer mains and manholes based on the observed defects. Sewer main renewal improvements to be considered include open-cut replacement, point repair, trenchless rehabilitation, and clean. Sewer manhole renewal improvements to be considered include replacement, line, point repair, and clean. FNI will coordinate with the City to define the scenarios where each improvement type is applicable. Review draft sewer system renewal improvements with the City for feedback. Group the proposed sewer system renewal improvements into projects based on improvement type and proximity for inclusion in the City's CIP development process. FNI will assign each project a unique identifier and a priority ranking. Develop GIS layers of the proposed sewer system renewal projects for inclusion in the City's CIP development process. FREESE Sewer System Condition Assessment Support MICHOIS 1/9/2025 Page 3 of 3 Prepare a memorandum summarizing the findings of the condition assessment, renewal improvement development methodology, and prioritized renewal improvement projects. FNI will review the draft memorandum with the City to solicit feedback. Finalize the Sewer System Condition Assessment and Improvement Recommendations memorandum. FNI will submit one electronic file (PDF) to the City for its records. SCHEDULE FNI will complete these tasks within 61 months of receiving Notice To Proceed (NTP) from the City. TOTAL COMPENSATION FNI will provide the identified Basic Services for the lump sum total of One Hundred and Ninety-Nine Thousand Three Hundred and Thirty-Three Dollars ($199,331.00). BASIC SERVICES Task A: Project Management $12,190.00 Task B: Sewer System GIS Update $26,047.00 Task C: Sewer Manhole Inspection App Development $6,386.00 Task D: Condition Assessment Review & Improvement Recommendations $154,708.00 Basic Services Subtotal $199,331.00 CITY COUNCIL AGENDA 1/21/25 Agenda Item: G2 a Item/Subject: Discussion and possible action on the approval and awarding of discretionary local Hotel Occupancy Tax Revenues for the 2024/2025 funding cycle as recommended by the Hotel/Motel Funding Committee. Initiating Department/Presenter: Kim Wagner, City Secretary Recommended Motion: Motion to approve the Hotel Motel Tax funding. Background/History: A meeting was held on January 14, 2025, for presentations by the applicants to the committee. Every applicant was represented at the meeting. The following spreadsheet was used by the committee for scoring applications and contains their collective recommended award amounts. Findings/Current Activity: Anticipated funds available for distribution total $36,000. Recommended awards totaled $36,000 in HOT/MOT funding. Financial Implications: Item is estimated to generate additional revenue Associated Information: Agenda Item # G2 # of Estimat Amount Amount Amount Amount overnight ed Requeste Granted Requested Granted stay 1,2, Rooms EVENT / PROJECT d2024 2024 2025 2025 3,+ Occupi Notes City of Llano Hill Country Grand Stand 7,000 3,000 36,000 Llano Texas Music Fest 6,000 3,000 4,000.00 5,000 3 31,000 Llano Crawfish Open 10,000 3,000 10,000.00 3,000 1-7 AlL 28,000 Llano Fiddle Fest 6,000 2,000 4,000.00 4,000 3 200 24,000 Llano Heritage Days 6,000 3,000 3,000.00 3,500 2 20,500 Dickens of a Christmas 8,000 2,500 5,723.00 6,000 14,500 Llano Main Street(Ladies Night) 4,500 3,000 2,000.00 2,500 1-2 75 12,000 Llano River Chuckwagon 3,500 2,000 3,500.00 4,000 2-3 125 8,000 Llano River Railroad 13,205 3,000 6,000.00 4,000 4,000 Rock N' Riverfest 6,000 3,000 1-2 4,000 Llano Youth Baseball 17,165 2,000 2-3 4,000 Llano Main Street (Buttery's Building) 10,000 1,500 4,000 Llano Outdoor Sports Expo 4,000 4,000 1 0 TOTAL $97,370 $31,000 $42,223 $36,000 Considerations 1 In the case of an event, does the event bring people to town to stay overnight? 2 If SO, how many nights? 3 Ifi it is not an event, does it bring people to town to stay overnight? *4 If the request does not specifically Meet Criteria 1, does it enhance the stay of visitors already staying at hotels? 5 If the request is not for a specific event, what is the probability that it will increase overnight lodging at some point? The funds being awarded are collected by lodging facilities within the city of Llano. This formula may be worth considering as a guidline There are approximately 150 rooms in Llano. If an event fills all rooms for 3 nights, that is the equivalent of 450 beds filled. At approximately $80 per bed, that would gross $36,000. At 7% Hotel Occupancy Tax, and assuming the maximum # of rooms filled, the most an event could contribute to HOT would be $2,520. Using the same formula, a 2 night event might bring in $1,680 and a 1 night event $840 CITY COUNCIL AGENDA 1/21/25 Agenda Item: G3 a Item/Subject: Discussion and possible action to approve Task Order No. 26 Amendment 1 with Steger Bizzell for Water Tower Painting Project Initiating Departmeny/Presenter: Josh Becker, Director of Water & Wastewater Operations Recommended Motion: Motion to approve Task Order 26 Amendment 1 and authorize the mayor to execute. Background/History: The City of Llano contracted with Steger Bizzell in 2022 to conduct a water tower painting evaluation and painting plant. It was determined that all five water towers would need to be repainted over the following two to five years. In September 2022, the city got a C.O. for painting all five water towers. It was determined to first paint the Landon Lane and Law Enforcement Ground Storage tanks. Council approved Task Order No. 26 on 9/18/23. Findings/Current Activity: After awarding the bid for the water tower painting, it was found that the original task order did not include the cost for bypass pumping the towers for to be taken out of service for painting. The task order is set up for a lump sum for setting up the pumping and a daily rate. Staff and S&B estimate approximately 45 days for each tower. This is equal to an estimated $87,717.39 for Landon Lane and $85,347.27 for Law Enforcement Center. The original budget of both towers was $1,252,000. Estimated budget balance will be $420,000 after completions. Financial Implications: Item is budgeted: 20-51999-610 In the amount of $ 3,100,000 (for all water tower painting.) Associated Information: Task Order 26 Amendment 1 Agenda Item #G3 Task Order Project Name: Landon Lane and Law Enforcement Center GST Rehabilitation Engineering Firm Name: Steger Bizzell Task Order No. 26 Amendment 1 To: City of Llano, Texas 301 W. Main Street Llano, TX 78643 General Description of Services or Project: City of Llano ("Owner") intends to perform coating and maintenance operations on the existing Landon Lane 1MG and Law Enforcement Center 300k Ground Storage Tanks. Steger Bizzell ("Engineer") will produce project specifications and provide as-needed construction management for this project. Additionally, Engineer shall coordinate and compensate a competent third-party coating inspector for the duration of the project. Lastly, Engineer shall coordinate and compensate a competent third-party contractor to provide the necessary bypass pumping equipment for the duration of the project. Owner Provided Information or Work: The Owner shall provide the following services or perform the following work: Owner shall provide timely review comments for documents submitted by Engineer; Any existing plans or specifications for the existing tank; Any specifications for previously completed projects similar to the one proposed; and Project inspection and supervision. Any documents or information related to the Work/Services provided by the Owner to the Engineer, including, without limitation, engineering studies, maps, reports, filed data, notes, plans, diagrams, or sketches ("Information"), is and shall remain the property of the Owner, and Engineer shall have no ownership or other interest in same. The Engineer shall deliver to the Owner, if requested, a written itemized receipt for the Information, and shall be responsible for its safe keeping and shall return it to the Owner, upon request, in as good condition as when received, normal wear and tear excepted. Scope of Services: The Engineer shall provide the following services and/or perform the following work: Project Manual (1 month): 1) Prepare a project manual to include the following: a. Standard front end documents, b. Technical specifications for painting/coating of water storage facilities, C. Schedule of work to be performed, and d. Schedule of coatings including manufacturer, preparation standards, and application requirements. City of Llano - Task Order 26 Page 1 of 3 STEGERCIBIZZELL Construction Management (6 months): 1) Assist in the Owner's S selected project Bidding process and provide Bidding documents as required. 2) Prepare and distribute construction documents as required. 3) Assist in the review of bid proposals. 4) Attend Owner's pre-construction meeting. 5) Review contractor's shop drawings, submittals and Requests for Information. 6) Coordinate Coating Inspection through Boswell & Reyes International, LLC. 7) Prepare and issue Change Orders as necessary to modify construction contract scope or specifications. 8) Assist with on-site Field Change Directives as necessary to resolve problems due to unforeseen field conditions. 9) Prepare record drawings from information submitted by the contractor. 10) Attend and conduct a final project walkthrough and prepare the project close-out and punch list. Exclusions: None. Proposed Project Team: Project Engineer/Manager: Samuel H. Davis, P.E. Project Designer: Catherine Manhan, EIT Coating Inspector: Boswell & Reyes International, LLC Owner's S Designated Representative: Josh Becker Work. Schedule: The total time fort the Services to be performed by the Engineer is Seven (7) calendar months for completion ofi this Task Order from date of Approval. Compensation: Percentage of Construction Costs: Engineering Services to be provided for 6% percent of construction cost. The Owner will be billed monthly on a percentage of completion basis. Lump. Sum: Inspection Services to be provided for an amount not to exceed $67,402.50 . The Owner will be billed monthly during the construction phase of the project. Lump. Sum: Establish Bypass Pumping Services at Landon Lane Site to be provided for an amount not to exceed $26,609.64. The Owner will be billed monthly during the construction phase oft the project. Lump Sum: Perform Bypass Pumping Services at Landon Lane Site to be provided for an amount not to exceed $1,357.95 per day. The Owner will be billed monthly during the construction phase of the project. Lump. Sum: Establish Bypass Pumping Services at Law Enforcement Center Site to be provided for an amount not to exceed $24,239.52 The Owner will be billed monthly during the construction phase oft the project. Lump. Sum: Perform Bypass Pumping Services at Law Enforcement Center Site to be provided for an amount not to exceed $1,357.95 per day. The Owner will be billed monthly during the construction phase oft the project. City of Llano Task Order 26 Page 2 of 3 STEGERCIBIZZELL Reimbursable expenses are not included in the above listed fees and will be paid by the Owner, including, but not limited to: postage or other delivery charges, document reproductions, etc. above and beyond initial deliverables. Professional will provide the Owner with reasonable documentation supporting the reimbursable costs and expenses. APPROVED: Owner: Engineer: City of Llano Steger Bizzell By: By: 1A Name: Marion Bishop Name: Samuel H. Davis, P.E. Title: Mayor Title: Senior Engineer Address: 301 W. Main Street Address: 1978 South Austin Ave Council Chambers Georgetown TX, 78626 2nd Floor Llano, TX 78643 Phone: 325-247-4158 Ext. 5 Phone: 512 / U 9412 Fax: E-Mail: E-Mail: avsesteeroizel.con Date: Date: 2025-01-15 City of Llano - Task Order 26 Page 3 of 3 STEGERBIZZELL 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 536, 649.87 880,477.84 36.67 1,520,869.16 FRANCHISE TAXES 102,800.00 250.00 4,314.21 4.20 98,485.79 LICENSES AND PERMITS 120,000.00 4,444.83 23,435.90 19.53 96,564.10 JLK EVENTS CENTER 22,500.00 230.00 4,944.70 21.98 17,555.30 JLK ARENA 166,500.00 3,991.33 14,438.33 8.67 152,061.67 SWIMMING POOL 25,500.00 0.00 0.00 0.00 25,500.00 GENERAL PARKS 129,900.00 7,945.00 24,731.00 19.04 105,169.00 GOLF COURSE 528,000.00 43,234.06 123,982.99 23.48 404,017.01 LANTEX THEATER 5,000.00 200.00 400.00 8.00 4,600.00 FACILITIES 68,000.00 4,611.17 8,515.80 12.52 59,484.20 FINANCIAL 2,028,030.00 116,633.94 357,257.40 17.62 1,670,772.60 OTHER 296,400.00 25,075.50 89,893.31 30.33 206,506.69 * TOTAL REVENUES 5,893,977.00 743,265.70 1,532,391.48 26.00 4,361,585.52 EXPENDITURE SUMMARY CITY COUNCIL 28,930.00 880.84 6,213.87 21.48 22,716.13 ADMINISTRATION 1,226,165.00 82,676.72 500,084.85 40.78 726,080.15 COMMUNITY DEVELOP/MAIN ST 113,125.00 8,457.77 26,102.91 23.07 87,022.09 POLICE 1,457,199.00 96,298.00 262,340.69 18.00 1,194,858.31 MUNICIPAL COURT 141,590.00 20,065.53 50,143.60 35.41 91,446.40 CODE ENFORCEMENT 206,180.00 31,017.70 64,057.36 31.07 142,122.64 FIRE DEPARTMENT 163,770.00 17,576.65 46,937.88 28.66 116,832.12 PARKS AND RECREATION 433,925.00 30,184.47 85,270.51 19.65 348,654.49 SWIMMING POOL 69,790.00 170.64 755.52 1.08 69,034.48 BADU RV PARK 5,800.00 24.46 351.95 6.07 5,448.05 ROBINSON RV PARK 47,770.00 2,377.41 8,442.52 17.67 39,327.48 DEPOT MUSEUM 16,050.00 275.98 3,654.74 22.77 12,395.26 JLK ARENA 330,630.00 14,928.67 131,930.13 39.90 198,699.87 LANTEX THEATER 39,165.00 2,537.51 7,830.23 19.99 31,334.77 GOLF COURSE 755,600.00 41,235.19 196,646.34 26.03 558,953.66 STREETS 1,439,695.00 40,993.50 269,917.62 18.75 1,169,777.38 ** * TOTAL EXPENDITURES 6,475,384.00 389,701.04 1,660,680.72 25.65 4,814,703.28 * REVENUES OVER/ (UNDER) EXPENDITURES ( 581,407.00) 353,564.66 128,289.24) 22.07 ( 453,117.76) 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 408,308.44 515,239.08 52.15 472,707.92 4102 DELINQUENT TAXES 10,000.00 1,197.61 3,606.77 36.07 6,393.23 4103 PENALTY & INTEREST 10,000.00 457.75 1,180.39 11.80 8,819.61 4104 OCCUPATION TAXES 10,400.00 0.00 0.00 0.00 10,400.00 4105 CITY SALE ES TAX 1,369,000.00 124,347.69 353,267.61 25.80 1,015,732.39 4107 MIXED DRINK TAX 14,000.00 2,338.38 7,183.99 51.31 6,816.01 TOTAL GENERAL REVENUE 2,401,347.00 536,649.87 880,477.84 36.67 1,520,869.16 FRANCHISE TAXES 4201 CABLE FRANCHISE TAXES 4,400.00 0.00 3,151.60 71.63 1,248.40 4203 ELECOMMUNIC A 1 - NS SE 12,800.00 0.00 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 0.00 0.00 0.00 40,000.00 4206 CENTRAL TEXAS ELECTRIC 18,600.00 0.00 0.00 0.00 18,600.00 4207 TOWE ER LEASE 3,000.00 250.00 750.00 25.00 2,250.00 TOTAL FRANCHISE TAXES 102,800.00 250.00 4,314.21 4.20 98,485.79 LICENSES AND PERMITS 4401 LICENSES DOG 400.00 0.00 0.00 0.00 400.00 4404 ELECTRIC PERMIT FEES 13,400.00 685.92 2,048.36 15.29 11,351.64 4405 MECHZ CAL E R RMIT EES 3,000.00 101.92 1,694.60 56.49 1,305.40 4406 PLUMBING PERMIT FEES 5,500.00 366.76 1,565.20 28.46 3,934.80 4410 su ILDING PERMIT FEES 88,000.00 2,290.23 16,928.74 19.24 71,071.26 4411 BOARD PETITIONS 6,500.00 1,000.00 1,199.00 18.45 5,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 4,444.83 23,435.90 19.53 96,564.10 COMMUNITY DEVELOPMENT JLK EVENTS CENTER 4480 EVENTS CENTER RENTAL 15,000.00 230.00 4,944.70 32.96 10,055.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 230.00 4,944.70 21.98 17,555.30 JLK ARENA 4490 ARENA RENTAL 50,000.00 800.00 5,550.00 11.10 44,450.00 4491 STALL RENTALS 25,000.00 200.00 575.00 2.30 24,425.00 4492 HAVINGS ALES 15,500.00 110.00 1,368.00 8.83 14,132.00 4493 TRAILER PARKING 20,000.00 100.00 485.00 2.43 19,515.00 4495 AREN NA CONC E - SSIONS 5,000.00 234.00 299.00 5.98 4,701.00 4496 ARENA BEER SALES 8,000.00 693.60 693.60 8.67 7,306.40 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 1-17-2025 09:17 AM CITY OF LLAN O PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 1,853.73 5,147.73 0.00 5,147.73) TOTAL JLK ARENA 166,500.00 3,991.33 14,438.33 8.67 152,061.67 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 10.00 190.00 12.67 1,310.00 4516 BADU RV SPACE RENTALS 12,500.00 325.00 1,191.00 9.53 11,309.00 4517 O B INSON RV SPACE TALS 110,000.00 7,610.00 23,250.00 21.14 86,750.00 4519 LAUNDROMAT 500.00 0.00 0.00 0.00 500.00 TOTAL ENE AL A S 129,900.00 7,945.00 24,731.00 19.04 105,169.00 GOLF COURSE 4520 GOLF COURSE DRIVING RANGE 22,000.00 1,566.18 4,601.52 20.92 17,398.48 4521 GOLF COURSE A ART RENTALS 132,000.00 9,603.70 30,429.91 23.05 101,570.09 4522 GOLF COURSE MEMBER FEES 82,000.00 12,558.00 26,630.99 32.48 55,369.01 4523 GOLF COURSE GREEN EES 165,000.00 9,887.76 37,595.15 22.78 127,404.85 4524 GOLF COURSE TOURNAMENTS 45,000.00 2,537.00 2,537.00 5.64 42,463.00 4526 GOLE MEF R C CHANDISE 16,000.00 1,102.72 3,233.01 20.21 12,766.99 4527 GOLF COURSE CONCESSIONS 21,000.00 2,293.92 4,870.79 23.19 16,129.21 4528 GOLE COURSE BOTTLED WATER 0.00 746.00) 0.00 0.00 0.00 4529 GOLF COURSE ALCOHOLIC BEVERAGE 45,000.00 4,430.78 14,084.62 31.30 30,915.38 TOTAL GOLF COURSE 528,000.00 43,234.06 123,982.99 23.48 404,017.01 LANTEX THEATER 4552 FACILITY RENTAL 5,000.00 200.00 400.00 8.00 4,600.00 TOTAL LANTEX THEATER 5,000.00 200.00 400.00 8.00 4,600.00 FACILITIES 4581 AMERICAN TOWE LEASE 19,200.00 3,374.38 5,108.98 26.61 14,091.02 4582 RISE BROADBAND TOWER LEASE 10,500.00 933.39 2,781.72 26.49 7,718.28 4584 POLE CONTACT FEES 37,000.00 0.00 0.00 0.00 37,000.00 4588 RIVER SAND CONVENIENCE FEES 1,300.00 303.40 625.10 48.08 674.90 TOTAL FACILITIES 68,000.00 4,611.17 8,515.80 12.52 59,484.20 FINANCIAL 4603 FEES IN LIEU OF TAX-UTIL 960,930.00 73,550.40 233,657.18 24.32 727,272.82 4605 GRANT PROCEEDS 574,000.00 0.00 0.00 0.00 574,000.00 4606 ADM OVERHEAD UTILITIES 483,100.00 40,258.34 120,775.02 25.00 362,324.98 4612 AL FIRE R - ICT N NTR RIBUTI 10,000.00 0.00 0.00 0.00 10,000.00 4630 INSURANCE PROCEEDS 0.00 2,825.20 2,825.20 0.00 2,825.20) TOTAL FINANCIAL 2,028,030.00 116,633.94 357,257.40 17.62 1,670,772.60 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 12,750.14 40,431.06 22.46 139,568.94 4702 FINES 75,000.00 10,228.00 43,138.67 57.52 31,861.33 4703 CEMETERY LOTS 21,000.00 225.00 3,945.00 18.79 17,055.00 4705 CEMETERY OPEN & CLOSE FEES 5,400.00 600.00 850.00 15.74 4,550.00 4790 MISCELLANEOUS 15,000.00 1,272.36 1,528.58 10.19 13,471.42 TOTAL OTHER 296,400.00 25,075.50 89,893.31 30.33 206,506.69 UNTITLED * TOTAL REVENUE 5,893,977.00 743,265.70 1,532,391.48 26.00 4,361,585.52 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 800.00 1,600.00 16.67 8,000.00 50100-104 FICA 755.00 61.20 122.40 16.21 632.60 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 861.20 1,722.40 16.20 8,907.60 SUPPLIES 50100-201 OFFICE SUPPLIES 300.00 0.00 0.00 0.00 300.00 50100-205 OPERA Al NAL U S 600.00 19.64 41.52 6.92 558.48 50100-290 MISCELLANEOUS SUPPLIES 300.00 0.00 0.00 0.00 300.00 TOTAL SUPPLIES 1,200.00 19.64 41.52 3.46 1,158.48 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 0.00 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 0.00 4,449.95 29.47 10,650.05 CAPITAL OUTLAY DEPARTMENT TOTAL 28,930.00 880.84 6,213.87 21.48 22,716.13 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,292.01 87,870.06 23.38 287,929.94 50200-102 LONGEVITY 900.00 41.54 120.00 13.33 780.00 50200-103 OVERTIME 3,000.00 29.63 319.89 10.66 2,680.11 50200-104 FICA 29,640.00 2,224.00 6,568.58 22.16 23,071.42 50200-105 RETI REMENT 50,030.00 3,784.11 11,351.96 22.69 38,678.04 50200-106 HEALTH INSURANCE 46,720.00 4,314.62 12,943.80 27.71 33,776.20 50200-107 CLOTHING 500.00 0.00 0.00 0.00 500.00 50200-109 LONG TERM DISABILITY 1,210.00 82.79 248.37 20.53 961.63 50200-111 VEHI CLE LOWANCE 7,200.00 500.00 1,000.00 13.89 6,200.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 973.50 26.74 2,666.50 50200-118 LIFE INSURANCE 300.00 21.12 63.36 21.12 236.64 50200-120 L OY E EE NUS 550.00 541.40 541.40 98.44 8.60 TOTAL PERSONAL SERVICES 521,720.00 41,155.72 124,731.59 23.91 396,988.41 SUPPLIES 50200-201 OFFI LC CE ES 3,300.00 550.06 1,736.27 52.61 1,563.73 50200-202 POSTAGE 6,500.00 500.00 1,032.75 15.89 5,467.25 50200-205 P ATI 5S 2,400.00 147.18 401.56 16.73 1,998.44 50200-290 MEETING/PARTY SUPPLIES 10,000.00 2,636.91 4,489.21 44.89 5,510.79 TOTAL SUP PPLIES 22,200.00 3,834.15 7,659.79 34.50 14,540.21 MAINTENANCE AND REPAIRS 50200-303 EQUIPMENT 200.00 386.95 386.95 193.48 186.95) 50200-305 BUILDING AND GROUNDS 10,000.00 97.87 271.90 2.72 9,728.10 50200-306 RED TOP JAIL 15,000.00 0.00 0.00 0.00 15,000.00 50200-307 COPIER LEASE 0.00 1,105.13 2,285.13 0.00 2,285.13) TOTAL MAINTENANCE AND REPAIRS 25,200.00 1,589.95 2,943.98 11.68 22,256.02 SERVICES 50200-401 COMMUNICATIONS 17,500.00 1,558.98 4,407.37 25.18 13,092.63 50200-402 ELECTRIC 6,500.00 347.45 1,251.62 19.26 5,248.38 50200-407 TECHNOLOGY 93,000.00 33,796.89) 64,408.46 69.26 28,591.54 50200-412 TR RA AVEL AND TRA NING 10,000.00 1,204.68 7,077.56 70.78 2,922.44 50200-420 DUES, FEES, AND MEMBERSHI 12,800.00 1,153.60 1,624.70 12.69 11,175.30 50200-426 SIONAL FEES 55,000.00 5,842.26 20,050.24 36.45 34,949.76 50200-427 LEGAL FEES 75,000.00 1,850.00 15,762.24 21.02 59,237.76 50200-428 TAX APPRA A. SAL DISTI C CT 36,760.00 9,190.00 9,190.00 25.00 27,570.00 50200-429 TAX COLLECTION FEE 3,000.00 0.00 500.00 16.67 2,500.00 50200-430 ADVERTISING 7,500.00 296.25 875.75 11.68 6,624.25 50200-434 CONTRACT LABOR 8,000.00 660.00 1,980.00 24.75 6,020.00 50200-471 TRANSFER OUT 112,885.00 41,790.57 71,120.57 63.00 41,764.43 TOTAL SERVICES 437,945.00 30,096.90 198,248.51 45.27 239,696.49 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 0.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 6,000.00 6,000.00 12.00 44,000.00 TOTAL SUNDRY CHARGES 209,100.00 6,000.00 166,500.98 79.63 42,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 82,676.72 500,084.85 40.78 726,080.15 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 17,660.88 23.07 58,879.12 50250-102 LONGEVITY 360.00 23.08 69.24 19.23 290.76 50250-104 FICA 5,890.00 436.98 1,297.89 22.04 4,592.11 50250-105 RETIREMENT 9,950.00 764.15 2,284.20 22.96 7,665.80 50250-106 HEALTH INSURANCE 12,545.00 1,045.03 3,135.09 24.99 9,409.91 50250-109 LONG TERM DISABILITY 250.00 18.50 55.50 22.20 194.50 50250-115 WORKER'S COMPENSATION 195.00 0.00 0.00 0.00 195.00 50250-117 DENTAL INSURANCE 450.00 37.17 111.51 24.78 338.49 50250-118 LIFE RANCE 60.00 4.80 14.40 24.00 45.60 50250-120 EMPLOYEE BONUS 110.00 108.28 108.28 98.44 1.72 TOTAL R S SONAL EI ERVICES 106,350.00 8,324.95 24,736.99 23.26 81,613.01 SUPPLIES MAINTENANCE AND REPAIRS SERVICES 50250-401 COMMUNICATIONS 775.00 64.50 129.00 16.65 646.00 50250-412 TRAVEL AND TRAINING 3,000.00 0.00 1,018.60 33.95 1,981.40 50250-420 DUES, FEES, AND MEMBERSH I 3,000.00 68.32 218.32 7.28 2,781.68 TOTAL SERVICES 6,775.00 132.82 1,365.92 20.16 5,409.08 * DEPARTMENT TOTAL 113,125.00 8,457.77 26,102.91 23.07 87,022.09 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 53, 808.91 158,800.94 22.57 544,789.06 50300-102 LONGEVITY 1,800.00 129.24 387.72 21.54 1,412.28 50300-103 OVERTIME 20,000.00 628.64 1,679.18 8.40 18,320.82 50300-104 FICA 56,120.00 4,247.64 12,359.62 22.02 43,760.38 50300-105 RETI REMENT 94,700.00 7,033.24 20,752.10 21.91 73,947.90 50300-106 HEALTH INSURANCE 85,580.00 6,076.24 18,958.18 22.15 66,621.82 50300-107 CLOTHING 6,000.00 375.00 375.00 6.25 5,625.00 50300-108 CERTIFICATION 7,000.00 423.08 1,384.62 19.78 5,615.38 50300-109 LONG TERM ITY 2,210.00 159.44 478.32 21.64 1,731.68 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 442.48 1,327.44 22.89 4,472.56 50300-118 LIFE INSURANCE 600.00 45.12 135.36 22.56 464.64 50300-120 L OY E EE ONUS 1,100.00 1,082.80 1,082.80 98.44 17.20 TOTAL PERSONAL SERVICES 1,008,900.00 74,451.83 233,248.66 23.12 775,651.34 SUPPLIES 50300-201 OFFICE ES 1,500.00 0.00 141.65 9.44 1,358.35 50300-202 POSTAGE 400.00 10.45 10.45 2.61 389.55 50300-205 P ERATIO! AL LIES 1,500.00 63.00 101.25 6.75 1,398.75 50300-206 ANIMAL CONTROL 3,500.00 502.47 800.42 22.87 2,699.58 50300-210 FUEL 40,000.00 1,861.63 3,764.99 9.41 36,235.01 TOTAL SUPPLIES 46,900.00 2,437.55 4,818.76 10.27 42,081.24 MAINTENANCE AND REPAIRS 50300-302 VEHICLE MAINTENANCE 16,500.00 120.53 971.47 5.89 15,528.53 50300-303 EQUIPMENT 3,000.00 96.28 96.28 3.21 2,903.72 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 498.00 24.90 1,502.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 382.81 1,615.75 6.46 23,384.25 SERVICES 50300-401 COMMUNICATIONS 13,500.00 1,036.08 3,108.24 23.02 10,391.76 50300-402 ELECTF R. I ICITY 4,500.00 193.73 830.56 18.46 3,669.44 50300-407 TECHNOLOGY 9,000.00 100.00 100.00 1.11 8,900.00 50300-412 EL AND TRAINING 9,000.00 1,772.00 2,694.72 29.94 6,305.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 11,250.00 11,250.00 25.00 33,750.00 50300-435 AL ASSA U JI LT INVES SAT 750.00 0.00 0.00 0.00 750.00 50300-436 GRANT EXPENSE 81,500.00 0.00 0.00 0.00 81,5 500.00 50300-437 OUNTY RADIO I CE: S 5,000.00 4,674.00 4,674.00 93.48 326.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 243,860.00 19,025.81 22,657.52 9.29 221,202.48 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 10 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,457,199.00 96,298.00 262,340.69 18.00 1,194,858.31 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 11 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,051.37 21,407.14 24.21 67,022.86 50350-102 LONGEVITY 1,200.00 87.70 263.10 21.93 936.90 50350-103 OVERTIME 0.00 0.00 9.99 0.00 9.99) 50350-104 FICA 6,915.00 541.51 1,660.06 24.01 5,254.94 50350-105 RETI REMENT 9,520.00 753.31 2,328.40 24.46 7,191.60 50350-106 HEALTH INSURANCE 8,170.00 680.30 2,040.90 24.98 6,129.10 50350-108 CERTIFICATION 600.00 0.00 0.00 0.00 600.00 50350-109 LONG TERM DISABILITY 230.00 18.50 55.50 24.13 174.50 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 180.96 26.42 504.04 50350-118 LIFE INSURANCE 60.00 4.80 14.40 24.00 45.60 50350-120 EMPLOYEE BONUS 110.00 108.28 108.28 98.44 1.72 50350-190 LEDC V RTIME 0.00 0.00 302.46 0.00 302.46) TOTAL PERSONAL SERVICES 116,150.00 9,306.09 28,371.19 24.43 87,778.81 SUPPLIES 50350-201 OFF CE ES 650.00 0.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 0.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 30.00 60.00 16.67 300.00 50350-407 TECHNOLOGY 7,900.00 8,974.38 10,174.38 128.79 2,274.38) 50350-412 AVEL AND TRAINING 3,200.00 534.06 1,034.06 32.31 2,165.94 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 1,221.00 10,329.02 103.29 329.02) TOTAL SERVICES 22,240.00 10,759.44 21,597.46 97.11 642.54 SUNDRY CHARGES CAPITAL OUTLAY * * DEPARTMENT TOTAL 141,590.00 20,065.53 50,143.60 35.41 91,446.40 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 12 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,148.05 21,679.70 23.35 71,180.30 50400-103 OVERTIME 1,000.00 15.04 16.35 1.64 983.65 50400-104 FICA 7,300.00 564.55 1,667.14 22.84 5,632.86 50400-105 RETIREMENT 12,290.00 916.16 2,774.92 22.58 9,515.08 50400-106 HEALTH INSURANCE 16,330.00 1,360.60 4,081.80 25.00 12,248.20 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 83.91 27.97 216.09 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 223.02 24.78 676.98 50400-118 LIFE INSURA ANCE 120.00 9.60 28.80 24.00 91.20 50400-120 EMPLOYEE BONUS 220.00 216.56 216.56 98.44 3.44 TO: AL N NAL ICES 135,980.00 10,332.87 32,539.94 23.93 103,440.06 SUPPLIES 50400-201 OFFICE SUPPLIES 500.00 85.78 274.16 54.83 225.84 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 139.04 246.69 8.81 2,553.31 TOTAL SUPPLIES 3,600.00 224.82 520.85 14.47 3,079.15 MAINTENANCE AND REPAIRS 50400-302 VEHICLE MAINTENANCE 2,000.00 0.00 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 0.00 196.99 7.04 2,603.01 SERVICES 50400-401 COMMUNICATIONS 2,000.00 110.09 349.56 17.48 1,650.44 50400-407 TECHNOLOGY 14,000.00 11,344.00 12,999.00 92.85 1,001.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 9,005.92 10,505.38 38.20 16, 994.62 50400-427 LEGAL FEES 500.00 0.00 0.00 0.00 500.00 50400-435 CLEAN UP 15,000.00 0.00 6,945.64 46.30 8,054.36 TOTAL SERVICES 63,800.00 20,460.01 30,799.58 48.28 33,000.42 SUNDRY CHARGES CAPITAL OUTLAY DEPARTMENT TOTAL 206,180.00 31,017.70 64,057.36 31.07 142,122.64 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 13 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 2,769.24 23.08 9,230.76 50500-104 FICA 920.00 70.62 211.86 23.03 708.14 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 8,160.56 35.60 14,759.44 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 60.17 174.59 8.73 1,825.41 TOTAL I P P PLIES 6,000.00 60.17 244.63 4.08 5,755.37 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 11,099.00 13,299.00 132.99 3,299.00) 50500-317 OFFICE EQUIPMENT 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL MAINTENANCE AND REPAIRS 41,000.00 11,099.00 13,299.00 32.44 27,701.00 SERVICES 50500-401 COL M NICATIONS 4,000.00 179.98 539.94 13.50 3,460.06 50500-402 ELECTRIC 2,800.00 210.11 726.63 25.95 2,073.37 50500-405 GAS 3,800.00 268.62 671.87 17.68 3,128.13 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 704.99 2,166.12 27.08 5,833.88 50500-451 DEBT SERVICE-PRINCIPAL 49,250.00 4,060.08 12,129.09 24.63 37,120.91 TOTAL SERVICES 74,850.00 5,423.78 16,233.65 21.69 58,616.35 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 17,576.65 46,937.88 28.66 116,832.12 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 14 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 16,222.26 45,8 852.88 19.52 189,087.12 50600-102 LONGEVITY 2,580.00 166.16 493.86 19.14 2,086.14 50600-103 OVERTIME 2,500.00 118.43 418.64 16.75 2,081.36 50600-104 FICA 18,545.00 1,266.89 3,539.99 19.09 15,005.01 50600-105 RETI REMENT 31,350.00 2,131.28 6,033.20 19.24 25,316.80 50600-106 HEALTH INSURANCE 45,200.00 3,085.93 9,257.79 20.48 35,942.21 50600-107 CLOTHING 3,250.00 270.32 910.88 28.03 2,339.12 50600-108 CERTIFICATION 2,400.00 92.32 276.96 11.54 2,123.04 50600-109 LONG TERI M ITY 755.00 54.91 164.73 21.82 590.27 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 584.94 21.58 2,125.06 50600-118 LIFE INSURANCE 300.00 19.20 57.60 19.20 242.40 50600-120 L OY E EE NUS 545.00 433.12 433.12 79.47 111.88 TOTAL PERSONAL SERVICES 350,275.00 24,055.80 73,607.76 21.01 276,667.24 SUPPLIES 50600-201 OFFICE ES 50.00 0.00 0.00 0.00 50.00 50600-204 SMALL TOOLS 500.00 126.25 163.01 32.60 336.99 50600-205 P PERATIONAL ES 7,500.00 652.23 695.20 9.27 6,804.80 50600-206 SPLASH PAD CHEMICALS 6,000.00 0.00 0.00 0.00 6,000.00 50600-210 FUEL 13,800.00 867.28 1,876.27 13.60 11,923.73 TOTAL SUPPLIES 27,850.00 1,645.76 2,734.48 9.82 25,115.52 MAINTENANCE AND REPAIRS 50600-302 VEHICLE MAINTENANCE 2,500.00 506.50 1,296.66 51.87 1,203.34 50600-303 EQUIPMENT 6,000.00 64.23 967.59 16.13 5,032.41 50600-305 BUILDING AND GROUNDS 15,000.00 3,084.09 3,626.08 24.17 11,373.92 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 3,654.82 5,890.33 13.24 38,609.67 SERVICES 50600-401 COMMUNICATIONS 2,500.00 228.12 619.86 24.79 1,880.14 50600-402 ELECTRIC 7,500.00 599.97 1,280.96 17.08 6,219.04 50600-412 EL AND TRAINING 1,200.00 0.00 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 828.09 3,037.94 26.88 8,262.06 SUNDRY CHARGES CAPITAL OUTLAY DEPARTMENT TOTAL 433,925.00 30,184.47 85,270.51 19.65 348,654.49 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 15 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 130.89 21.82 469.11 50601-402 ELECTRIC 3,000.00 127.01 624.63 20.82 2,375.37 50601-412 TRAVEL AND TRAINING 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL SERVICES 5,100.00 170.64 755.52 14.81 4,344.48 DEPARTMENT TOTAL * 69,790.00 170.64 755.52 1.08 69,034.48 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 16 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 24.46 351.95 19.55 1,448.05 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 24.46 351.95 7.33 4,448.05 ** DEPARTMENT TOTAL 5,800.00 24.46 351.95 6.07 5,448.05 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 17 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 2,213.10 23.05 7,386.90 50604-104 FICA 1,095.00 83.80 243.46 22.23 851.54 50604-115 WOF KERS COMPENSATION 25.00 0.00 0.00 0.00 25.00 TOTAL PERSONAL SERVICES 10,720.00 821.50 2,456.56 22.92 8,263.44 SUPPLIES 50604-201 OFFICE UPPLIES 50.00 0.00 26.77 53.54 23.23 50604-205 OPERATIONAL SUPPLIES 600.00 48.78 105.81 17.64 494.19 TOTAL U IES 650.00 48.78 132.58 20.40 517.42 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 0.00 102.43 4.10 2,397.57 TOTAL MAINTENANCE AND REPAIRS 2,900.00 0.00 102.43 3.53 2,797.57 SERVICES 50604-401 C NS 5,000.00 269.99 946.79 18.94 4,053.21 50604-402 ELECTRIC 22,000.00 870.12 3,462.99 15.74 18,537.01 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 367.02 1,129.77 28.24 2,870.23 TOTAL SERVICES 33,500.00 1,507.13 5,750.95 17.17 27,749.05 CAPITAL OUTLAY DEPARTMENT TOTAL 47,770.00 2,377.41 8,442.52 17.67 39,327.48 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 18 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 45.10 45.10 15.03 254.90 TOTAL SUPPLIES 300.00 45.10 45.10 15.03 254.90 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 692.64 23.09 2,307.36 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 692.64 12.95 4,657.36 * DEPARTMENT TOTAL 16,050.00 275.98 3,654.74 22.77 12,395.26 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 19 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 3,857.23 18,985.23 15.12 106, 554.77 50606-103 OVERTIME 0.00 186.91 577.10 0.00 577.10) 50606-104 FICA 9,620.00 265.90 1,361.42 14.15 8,258.58 50606-105 RETIREMENT 11,710.00 517.24 2,502.02 21.37 9,207.98 50606-106 HEALTH INSURAN N ICE 32,900.00 2,051.06 6,153.18 18.70 26,746.82 50606-109 LONG TERM DISABILITY 250.00 26.56 79.68 31.87 170.32 50606-115 WORKER'S COMPENSATION 3,360.00 0.00 3,860.14 114.89 500.14) 50606-117 DENTAL INSURANCE 2,240.00 140.42 421.26 18.81 1,818.74 50606-118 LIFE ANCE 120.00 9.60 28.80 24.00 91.20 50606-120 EMPLOYEE BONUS 220.00 108.28 108.28 49.22 111.72 TOTAL R S SON L EI ERVICES 185,960.00 7,163.20 34,077.11 18.32 151,882.89 SUPPLIES 50606-201 OFFICE SUPPLIES 400.00 0.00 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 229.49 2,310.14 85.56 389.86 50606-206 SHAY IGS 9,900.00 0.00 2,301.75 23.25 7,598.25 50606-209 ALCOHOLIC BEVERAGES 10,220.00 32.11 1,062.60 10.40 9,157.40 50606-210 FUEL 5,000.00 92.72 2,861.25 57.23 2,138.75 TOTAL SUPPLIES 28,520.00 354.32 8,542.30 29.95 19,977.70 MAINTENANCE AND REPAIRS 50606-302 VEHICLE MAINTENANCE 250.00 0.00 0.00 0.00 250.00 50606-303 EQUIPMENT 8,000.00 1,317.97 1,950.39 24.38 6,049.61 50606-305 BUILDING AND GROUNDS 12,000.00 3,272.58 4,173.47 34.78 7,826.53 50606-307 OFFICE EQUIPMENT 0.00 0.00 41.44 0.00 41.44) TOTAL MAINTENANCE AND REPAIRS 20,250.00 4,590.55 6,165.30 30.45 14,084.70 SERVICES 50606-401 COMMUNICATIONS 4,000.00 153.44 472.64 11.82 3,527.36 50606-402 ELECTRICITY 28,000.00 2,639.20 10,824.38 38.66 17,175.62 50606-405 PROPANE 2,400.00 0.00 0.00 0.00 2,400.00 50606-412 TRAVEL & TRAINING 500.00 0.00 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 27.96 209.94 0.00 209.94) TOTAL SERVICES 35, 900.00 2,820.60 11,575.42 32.24 24,324.58 CAPITAL OUTLAY 50606-601 CAPITAL OUTLAY 60,000.00 0.00 71,570.00 119.28 11,570.00) TOTAL CAPITAL OUTLAY 60,000.00 0.00 71,570.00 119.28 11,570.00) * DEPARTMENT TOTAL 330,630.00 14,928.67 131,930.13 39.90 198,699.87 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 20 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 3,192.00 23.06 10, 648.00 50610-104 FICA 1,060.00 81.38 244.14 23.03 815.86 50610-115 WOF KERS COMPENSATION 65.00 0.00 0.00 0.00 65.00 TOTAL PERSONAL SERVICES 14,965.00 1,145.38 3,436.14 22.96 11,528.86 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 96.33 0.00 - 96.33) TOTAL SUPPLIES 3,600.00 32.11 96.33 2.68 3,503.67 MAINTENANCE AND REPAIRS 50610-303 EQUIPMENT 3,500.00 540.00 1,129.00 32.26 2,371.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 540.00 1,335.97 22.27 4,664.03 SERVICES 50610-401 COMMUNICATIONS 2,500.00 206.09 638.27 25.53 1,861.73 50610-402 ELECTRIC 5,000.00 317.45 1,933.46 38.67 3,066.54 50610-405 GAS 3,100.00 296.48 390.06 12.58 2,709.94 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 820.02 2,961.79 20.29 11,638.21 CAPITAL OUTLAY * DEPARTMENT TOTAL 39,165.00 2,537.51 7,830.23 19.99 31,334.77 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 21 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,211.68 61,336.96 22.30 213,6 663.04 50650-102 LONGEVITY 1,740.00 87.70 263.10 15.12 1,476.90 50650-103 OVERTIME 3,000.00 15.91 168.12 5.60 2,831.88 50650-104 FICA 21,500.00 1,547.33 4,642.74 21.59 16,857.26 50650-105 RETI REMENT 31,450.00 2,157.40 6,438.42 20.47 25,011.58 50650-106 HEALTH INSURANCE 32,100.00 2,674.74 8,024.22 25.00 24,075.78 50650-107 CLOTHING 1,000.00 0.00 0.00 0.00 1,000.00 50650-108 CERTIFICATION 1,200.00 23.06 69.18 5.77 1,130.82 50650-109 LONG TERM ITY 515.00 46.43 139.29 27.05 375.71 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 630.99 26.07 1,789.01 50650-118 LIFE INSURANCE 240.00 14.40 43.20 18.00 196.80 50650-120 L OY E EE NUS 440.00 433.12 433.12 98.44 6.88 TOTAL PERSONAL SERVICES 377,405.00 27,422.10 85,160.42 22.56 292,244.58 SUPPLIES 50650-201 OFFI CE ES 300.00 0.00 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 926.30 1,516.27 21.66 5,483.73 50650-203-02 NON ALCOHOLIC BEVERAGES 9,000.00 1,015.17 2,019.46 22.44 6,980.54 50650-204 SMALL TOOLS 1,000.00 0.00 0.00 0.00 1,000.00 50650-205 OPERATIONAL SUPPLIES 2,000.00 116.98 1,110.05 55.50 889.95 50650-207 PRO SHOP INV ENTORY 15,000.00 869.43 1,031.46 6.88 13,968.54 50650-209 ALCOHOLIC BEVERAGES 20,000.00 1,571.98 5,324.09 26.62 14,675.91 50650-210 FUEL 6,000.00 25.67 1,895.31 31.59 4,104.69 TOTAL SUPPLIES 60,500.00 4,525.53 12,961.63 21.42 47,538.37 MAINTENANCE AND REPAIRS 50650-302 VEHICLE MAINTENANCE 400.00 0.00 0.00 0.00 400.00 50650-303 EQUIPMENT 15,000.00 35.00 35.00 0.23 14,965.00 50650-305 BUILDING AND GROUNDS 5,400.00 341.57 508.82 9.42 4,891.18 50650-306-01 FERTILIZER 34,000.00 0.00 23,080.00 67.88 10,920.00 50650-306-02 CHEMICALS 54,000.00 0.00 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 376.57 70,951.40 55.74 56,348.60 SERVICES 50650-401 COMMUNICATIONS 6,000.00 476.21 1,148.35 19.14 4,851.65 50650-402 ELECTRICITY 17,500.00 726.58 3,091.70 17.67 14,408.30 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 6,750.00 25.00 20,250.00 50650-417 REN N TAL OF EQUIPMENT 1,500.00 225.00 450.00 30.00 1,050.00 50650-420 DUES FEES AND MEMBERSHIPS 1,800.00 175.00 325.00 18.06 1,475.00 1-17-2025 09:17 AM CITY OF LLAN O PAGE: 22 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 12,375.00 25.00 37,125.00 50650-460 CREDIT CARD FEES 9,500.00 933.20 2,972.76 31.29 6,527.24 TOTAL SERVICES 114,800.00 8,910.99 27,572.89 24.02 87,227.11 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 41,235.19 196,646.34 26.03 558,953.66 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 23 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 13,067.52 38,480.44 18.64 167,909.56 50800-102 LONGEVITY 0.00 39.24 39.24 0.00 39.24) 50800-103 OVERTIME 2,500.00 64.94 199.66 7.99 2,300.34 50800-104 FICA 16,200.00 1,014.58 2,958.26 18.26 13,241.74 50800-105 RETI REMENT 24,190.00 1,706.46 5,040.90 20.84 19,149.10 50800-106 HEALTH INSURANCE 32,660.00 2,256.74 8,237.38 25.22 24,422.62 50800-107 CLOTHING 2,600.00 0.00 52.99 2.04 2,547.01 50800-108 CERTIFICATION 2,400.00 184.60 553.80 23.08 1,846.20 50800-109 LONG TERI M ITY 590.00 39.59 402.45 68.21 187.55 50800-115 WORKER'S COMPENSATION 9,680.00 0.00 3,823.20 39.50 5, 856.80 50800-117 DENTAL INSURANCE 2,700.00 172.19 590.32 21.86 2,109.68 50800-118 LIFE INSURANCE 240.00 12.48 137.28 57.20 102.72 50800-120 L Y E EE NUS 440.00 346.50 346.50 78.75 93.50 TOTAL PERSONAL SERVICES 300,590.00 18,904.84 60,862.42 20.25 239,727.58 SUPPLIES 50800-204 SMAL TOOLS 5,000.00 140.18 614.15 12.28 4,385.85 50800-205 OPERATIONAL SUPPLIES 10,000.00 1,554.44 2,636.08 26.36 7,363.92 50800-205-01 STREE ET REPAIR 15,000.00 0.00 0.00 0.00 15,000.00 50800-205-02 COLD MIX 52,000.00 13,047.19 18,946.51 36.44 33,053.49 50800-205-03 STREET SIGNAGE 20,000.00 0.00 0.00 0.00 20,000.00 50800-210 FUEL 18,000.00 575.56 2,266.34 12.59 15,733.66 TOTAL SUPPLIES 120,000.00 15,317.37 24,463.08 20.39 95,536.92 MAINTENANCE AND REPAIRS 50800-302 VEHICLE MAINTENANCE 7,500.00 309.00 633.23 8.44 6,866.77 50800-303 EQUIPMENT 10,000.00 13.99 2,663.87 26.64 7,336.13 50800-304 MACHINERY 32,500.00 9.98 8,648.12 26.61 23,851.88 50800-305 BUILDING AND GROUNDS 2,500.00 2.65 15.64 0.63 2,484.36 50800-320 DRAINAGE 50,000.00 0.00 0.00 0.00 50,000.00 TOTAL MAINTENANCE AND REPAIRS 102,500.00 335.62 11,960.86 11.67 90,539.14 SERVICES 50800-401 COMMUNI ATIONS 3,300.00 191.47 480.39 14.56 2,819.61 50800-402 ELECTRIC 1,000.00 60.40 167.89 16.79 832.11 50800-405 GAS 700.00 86.45 259.35 37.05 440.65 50800-412 TRAVEL 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-420 DUES, FEES, MEMBERSHIPS 0.00 76.94 76.94 0.00 76.94) 50800-450 DEBT SERVICE INTEREST 15,000.00 1,038.63 3,210.25 21.40 11,789.75 50800-450-01 DEBT SERVICE PRINCIPAL 53,000.00 4,406.02 13,123.70 24.76 39,876.30 TOTAL SE CES 81,500.00 5,859.91 17,318.52 21.25 64,181.48 SUNDRY CHARGES 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 24 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 2024 10 -GENERAL FUND STREETS DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE CAPITAL OUTLAY 50800-603 STREETS 85,000.00 575.76 65,177.06 76.68 19,822.94 50800-604 CURBS AND GUTTERS 50,000.00 0.00 30.70 0.06 49,969.30 50800-615 VEHICLES & EQUIPMENT 150,105.00 0.00 90,104.98 60.03 60,000.02 50800-621 OTHER 550,000.00 0.00 0.00 0.00 550,000.00 TOTAL CAPITAL OUTLAY 835,105.00 575.76 155,312.74 18.60 679,792.26 * DEPARTMENT TOTAL 1,439,695.00 40,993.50 269,917.62 18.75 1,169,777.38 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 25 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,475,384.00 389,701.04 1,660,680.72 25.65 4,814,703.28 REVENUES OVER/ (UNDER) EXPENDITURES ( 581,407.00) 353,564.66 128,289.24) 22.07 453,117.76) END OF REPORT 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 190,582.35 242,509.75 51.30 230,244.25 TOTAL REVENUES 472,754.00 190,582.35 242,509.75 51.30 230,244.25 EXPENDITURE SUMMARY GOLF COURSE 20,940.00 1,744.93 5,234.79 25.00 15,705.21 SERIES 2017 GO BONDS 445,100.00 0.00 0.00 0.00 445,100.00 ** * TOTAL EXPENDITURES 466,040.00 1,744.93 5,234.79 1.12 460,805.21 REVENUES OVER/ (UNDER) EXPENDITURES 6,714.00 188,837.42 237,274.96 534.03 230,560.96) 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 189,072.62 238,600.93 53.05 211,153.07 4102 TAX REVENUE-DELINQUENT 5,000.00 592.10 1,755.19 35.10 3,244.81 4103 PENALTY & INTEREST 3,000.00 222.86 568.96 18.97 2,431.04 4701 INTEREST 15,000.00 694.77 1,584.67 10.56 13,415.33 TOTAL 472,754.00 190,582.35 242,509.75 51.30 230,244.25 * TOTAL REVENUE 472,754.00 190,582.35 242,509.75 51.30 230,244.25 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 416.00 1,259.00 26.17 3,551.00 50650-450-01 DEBT SERVICE PRINCIPAL 16,130.00 1,328.93 3,975.79 24.65 12,154.21 TOTAL SERVICES 20,940.00 1,744.93 5,234.79 25.00 15,705.21 ** * DEPARTMENT TOTAL 20,940.00 1,744.93 5,234.79 25.00 15,705.21 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 5,234.79 1.12 460,805.21 * REVENUES OVER/ (UNDER) EXPENDITURES 6,714.00 188,837.42 237,274.96 534.03 230,560.96) END OF REPORT 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 810,627.90 2,497,339.30 23.64 8,064,650.70 * TOTAL REVENUES 10,561,990.00 810,627.90 2,497,339.30 23.64 8,064,650.70 EXPENDITURE SUMMARY ADMINISTRATION 854,218.00 83,120.01 207,073.04 24.24 647,144.96 CUSTOMER CONVENIENCE STA 214,010.00 6,122.21 35,512.14 16.59 178,497.86 SANITATION 801,867.00 66,539.26 196,157.29 24.46 605,709.71 WATER PLANT 904,826.00 61,639.33 193,955.52 21.44 710,870.48 WATER DISTRIBUTION 1,333,554.00 29,173.88 113,247.74 8.49 1,220,306.26 SEWER PLANT 927,155.00 42,506.97 150,986.90 16.28 776,168.10 SEWER COLLECTION 884,965.00 35,857.53 119,145.58 13.46 765,819.42 ELECTRIC 4,666,204.00 354,277.12 1,140,578.03 24.44 3,525,625.97 CAPITAL OUTLAY 394,723.00 27,536.91 157,964.80 40.02 236,758.20 TOTAL EXPENDITURES 10,981,522.00 706,773.22 2,314,621.04 21.08 8,666,900.96 * REVENUES OVER/ (UNDER) EXPENDITURES ( 419,532.00) 103,854.68 182,718.26 43.55- 602,250.26) 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 390,206.63 1,180,783.24 22.68 4,026,056.76 4102 WATER 1,879,000.00 145,043.10 468,479.94 24.93 1,410,520.06 4103 SEWER 1,720,000.00 148,392.02 445,198.65 25.88 1,274,801.35 4104 SANITATION 1,008,000.00 83,264.62 252,146.05 25.01 755,853.95 4106 ADMINISTR. TION UE 80,000.00 7,262.79 20,979.88 26.22 59,020.12 4108 CUSTOMER CONVENIENCE STATION 153,000.00 6,399.08 27,861.98 18.21 125,138.02 4110 ELECTRIC TAP FEES 15,000.00 2,277.00 7,054.00 47.03 7,946.00 4120 WATER TAP FEES 35,000.00 138.90 138.90 0.40 34,861.10 4121 SEWER TAP S 35,000.00 0.00 3,765.00 10.76 31,235.00 4126 CUSTOMER SERVICE INSPECTIONS 650.00 75.00 375.00 57.69 275.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 0.00 1,315.63 65.78 684.37 4152 TSU LEASE 9,000.00 1,500.00 2,250.00 25.00 6,750.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,638.73 8,282.31 24.36 25,717.69 4701 INTEREST ON INVESTMENTS 350,000.00 23,342.09 71,144.59 20.33 278,855.41 4790 MISCI LANEOUS INCOME 3,500.00 87.94 324.13 9.26 3,175.87 TOTAL REVENUE 10,561,990.00 810,627.90 2,497,339.30 23.64 8,064,650.70 ** * TOTAL REVENUE 10,561,990.00 810,627.90 2,497,339.30 23.64 8,064,650.70 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,657.34 19,744.83 23.21 65,335.17 51100-103 OVERTIME 5,000.00 308.42 1,129.38 22.59 3,870.62 51100-104 FICA 6,910.00 531.22 1,558.74 22.56 5,351.26 51100-105 RETIREMENT 11,650.00 894.74 2,677.45 22.98 8,972.55 51100-106 HEALTH INSURANCE 24,620.00 1,629.72 4,889.16 19.86 19,730.84 51100-107 CLOTHING 1,000.00 0.00 0.00 0.00 1,000.00 51100-109 LONG TERM DISABILITY 280.00 22.80 68.40 24.43 211.60 51100-115 WORKER'S COMPENSATION 230.00 0.00 0.00 0.00 230.00 51100-117 DENTAL SURANCE 1,510.00 130.03 390.09 25.83 1,119.91 51100-118 LIFE INSURANCE 120.00 9.60 28.80 24.00 91.20 51100-120 M PI YEE E BONUS 220.00 216.56 216.56 98.44 3.44 TOTAL PERSONAL SERVICES 136,620.00 10,400.43 30,703.41 22.47 105,916.59 SUPPLIES 51100-201 OFFICE LIES 2,000.00 222.91 328.04 16.40 1,671.96 51100-202 POSTAGE 12,500.00 1,177.21 3,456.36 27.65 9,043.64 51100-205 DE AL ES 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL SUPPLIES 15,500.00 1,400.12 3,784.40 24.42 11,715.60 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 354.65 961.83 40.08 1,438.17 51100-407 TECHNOLOGY 31,000.00 25, 885.36 29,276.91 94.44 1,723.09 51100-412 TRAVEL AND TRAINING 5,000.00 18.75 18.75 0.38 4,981.25 51100-426 PROFESSIONAL FEES 85,048.00 1,839.15 11,532.10 13.56 73,515.90 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,232.22 8,044.68 23.66 25,955.32 TOTAL SERVICES 207,048.00 30,330.13 49,834.27 24.07 157,213.73 SUNDRY CHARGES 51100-550 FEE IN LIEU OF TAX 9,450.00 730.99 1,975.94 20.91 7,474.06 51100-552 ADM & OTHER OVERHEAD 483,100.00 40,258.34 120,775.02 25.00 362,324.98 TOTAL SUNDRY CHARGES 492,550.00 40,989.33 122,750.96 24.92 369,799.04 CAPITAL OUTLAY DEPART T TMENT TOTAL 854,218.00 83,120.01 207,073.04 24.24 647,144.96 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 1,867.57 9,861.44 18.95 42,188.56 51200-102 LONGEVITY 960.00 27.69 156.93 16.35 803.07 51200-103 OVERTIME 1,500.00 25.24) 160.83 10.72 1,339.17 51200-104 FICA 4,180.00 140.81 732.04 17.51 3,447.96 51200-105 RETI REMENT 6,600.00 183.14 1,231.32 18.66 5,368.68 51200-106 HEALTH INSURANCE 12,545.00 418.01 2,508.07 19.99 10,036.93 51200-107 CLOTHING 775.00 39.68 128.96 16.64 646.04 51200-109 LONG TERM DISABILITY 160.00 5.78 34.72 21.70 125.28 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 24.12 144.76 20.98 545.24 51200-118 LIFE INSURA ANCE 60.00 1.92 11.52 19.20 48.48 51200-120 EMPLOYEE BONUS 110.00 86.62 86.62 78.75 23.38 TO: AL NAL C CES 82,610.00 2,770.10 17,742.52 21.48 64,867.48 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.67 50.91 3.39 1,449.09 TOTAL SUPPLIES 2,200.00 25.67 95.51 4.34 2,104.49 MAINTENANCE AND REPAIRS 51200-303 EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51200-304 MACHINERY 5,000.00 0.00 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 0.00 218.25 3.12 6,781.75 SERVICES 51200-401 COMMUNICATIONS 2,000.00 96.38) 502.84 25.14 1,497.16 51200-402 ELECTRIC 1,200.00 55.04 184.92 15.41 1,015.08 51200-404 DISPOSAL FEES 75,000.00 3,254.05 12,384.36 16.51 62,615.64 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 113.73 483.74 19.35 2,016.26 TOTAL SERVICES 106,700.00 3,326.44 13,555.86 12.70 93,144.14 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 6,122.21 35,512.14 16.59 178,497.86 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 64,319.14 189,496.93 24.45 585,503.07 TOTAL SERVICES 775, 000.00 64,319.14 189,496.93 24.45 585,503.07 SUNDRY CHARGES 51201-550 IN LIEU OF TAX 26,867.00 2,220.12 6,660.36 24.79 20,206.64 TOTAL SUNDRY CHARGES 26,867.00 2,220.12 6,660.36 24.79 20,206.64 DEPARTMENT TOTAL 801,867.00 66,539.26 196,157.29 24.46 605,709.71 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,880.15 32,458.82 23.60 105,101.18 51300-102 LONGEVITY 910.00 65.74 187.98 20.66 722.02 51300-103 OVERTIME 19,000.00 1,554.78 4,427.54 23.30 14,572.46 51300-104 FICA 12,370.00 949.41 2,782.27 22.49 9,587.73 51300-105 RETI REMENT 20,890.00 1,650.00 4,881.30 23.37 16,008.70 51300-106 HEALTH INSURANCE 19,305.00 1,413.53 4,420.02 22.90 14,884.98 51300-107 CLOTHING 1,590.00 36.76 218.52 13.74 1,371.48 51300-108 CERTIFICATION 3,850.00 290.38 871.14 22.63 2,978.86 51300-109 LONG TERI M ITY 450.00 28.96 86.88 19.31 363.12 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 457.64 27.24 1,222.36 51300-118 LIFE INSURANCE 100.00 7.60 22.80 22.80 77.20 51300-120 L Y E EE NUS 180.00 171.44 171.44 95.24 8.56 TOTAL PERSONAL SERVICES 222,175.00 17,200.43 55,291.34 24.89 166,883.66 SUPPLIES 51300-201 OFF CE ES 550.00 0.00 153.55 27.92 396.45 51300-202 POSTAGE 50.00 0.00 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 16,134.75 58,687.88 42.68 78,812.12 51300-210 FUEL 3,000.00 198.27 400.61 13.35 2,599.39 TOTAL SUPPLIES 141,700.00 16,333.02 59,261.30 41.82 82,438.70 MAINTENANCE AND REPAIRS 51300-302 VEHICLE MAINTENANCE 4,500.00 9.38 926.88 20.60 3,573.12 51300-303 EQUIPMENT 85,000.00 391.81 556.50 0.65 84,443.50 51300-305 BUILDING AND GROUNDS 3,500.00 40.51 141.95 4.06 3,358.05 51300-312 BOARDS ON DAM 10,000.00 0.00 29.73 0.30 9,970.27 TOTAL MAINTENANCE AND REPAIRS 103,000.00 441.70 1,655.06 1.61 101,344.94 SERVICES 51300-401 COMMUNICATIONS 6,000.00 483.47 1,379.60 22.99 4,620.40 51300-402 ELECTRIC 44,000.00 3,168.53 9,693.19 22.03 34,306.81 51300-404 DISE POSAL FEES 35,000.00 787.07 5,874.69 16.78 29,125.31 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.04 4,818.96 29.21 11,6 681.04 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 5,710.11 21,841.44 9.97 197,239.56 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 16,408.07 50,360.38 25.53 146,934.62 51300-553 CONTRIBUTION TO SINKING F 21,575.00 5,546.00 5,546.00 25.71 16,029.00 TOTAL SUNDRY CHARGES 218,870.00 21,954.07 55, 906.38 25.54 162,963.62 CAPITAL OUTLAY * DEPARTMENT TOTAL 904,826.00 61,639.33 193,955.52 21.44 710,870.48 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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, 705.04 37,935.63 22.84 128,174.37 51325-102 LONGEVITY 1,600.00 128.08 384.24 24.02 1,215.76 51325-103 OVERTIME 20,000.00 1,732.18 3,703.72 18.52 16,296.28 51325-104 FICA 14,670.00 1,078.87 3,058.78 20.85 11,611.22 51325-105 RETI REMENT 24,760.00 1,913.42 5,509.02 22.25 19,250.98 51325-106 HEALTH INSURANCE 30,340.00 2,422.97 7,479.59 24.65 22,860.41 51325-107 CLOTHING 2,250.00 0.00 0.00 0.00 2,250.00 51325-108 CERTIFICATION 3,750.00 259.58 778.74 20.77 2,971.26 51325-109 LONG TERI M ITY 510.00 39.45 118.35 23.21 391.65 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 229.69 700.83 32.15 1,479.17 51325-118 LIFE INSURANCE 140.00 10.80 32.40 23.14 107.60 51325-120 L OY E EE NUS 250.00 243.63 243.63 97.45 6.37 TOTAL PERSONAL SERVICES 271,660.00 20,763.71 62,577.43 23.04 209,082.57 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 403.84 1,897.10 12.65 13,102.90 TOTAL SUPPLIES 19,800.00 403.84 2,111.49 10.66 17,688.51 MAINTENANCE AND REPAIRS 51325-302 VEHICLE MAINTENANCE 13,000.00 141.87 819.14 6.30 12,180.86 51325-303 EQUIPMENT 17,500.00 223.86 648.93 3.71 16,851.07 51325-304 MACHINERY 16,000.00 448.50 2,033.36 12.71 13,966.64 51325-305 BUILDING AND GROUNDS 2,500.00 32.21 45.21 1.81 2,454.79 51325-310 UTILITIES 110,000.00 4,241.50 39,230.39 35.66 70,769.61 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 918.06 918.06 4.17 21,081.94 TOTAL MAINTENANCE AND REPAIRS 196,000.00 6,006.00 43,695.09 22.29 152,304.91 SERVICES 51325-401 COMMUNI ATIONS 5,300.00 451.36 1,218.91 23.00 4,081.09 51325-402 ELECTRIC 13,000.00 962.98 2,846.33 21.89 10,153.67 51325-407 TECHNOLOGY 5,000.00 0.00 0.00 0.00 5,000.00 51325-412 TRAVEL AND TRAINING 3,375.00 56.87 269.37 7.98 3,105.63 51325-416 RENTAL OF EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51325-420 DUES, FEES, AND MEMBERSHI 400.00 37.50 37.50 9.38 362.50 51325-426 PROFESSIONAL FEES 10,650.00 0.00 0.00 0.00 10,650.00 51325-428 WATER TAP EVALUATION 8,000.00 491.62 491.62 6.15 7,508.38 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 2,000.33 4,863.73 0.57 841,230.27 1-17-2025 09:17 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 29,173.88 113,247.74 8.49 1,220,306.26 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 10 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,448.50 28,306.03 23.21 93, 653.97 51350-102 LONGEVITY 310.00 24.24 72.72 23.46 237.28 51350-103 OVERTIME 12,500.00 418.90 2,479.90 19.84 10,020.10 51350-104 FICA 10,600.00 744.63 2,306.44 21.76 8,293.56 51350-105 RETI REMENT 17,900.00 1,305.09 4,060.94 22.69 13,839.06 51350-106 HEALTH INSURANCE 19,305.00 1,413.54 4,420.03 22.90 14,884.97 51350-107 CLOTHING 1,590.00 0.00 248.96 15.66 1,341.04 51350-108 CERTIFICATION 3,550.00 267.32 801.96 22.59 2,748.04 51350-109 LONG TERI M ITY 400.00 28.97 86.91 21.73 313.09 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 259.42 25.69 750.58 51350-118 LIFE INSURANCE 100.00 7.60 22.80 22.80 77.20 51350-120 L o Y E EE NUS 180.00 171.44 171.44 95.24 8.56 TOTAL PERSONAL SERVICES 193,085.00 13,915.84 44,910.03 23.26 148,174.97 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,709.65 16,967.57 56.56 13,032.43 51350-210 FUEL 4,000.00 161.02 1,126.53 28.16 2,873.47 TOTAL SUPPLIES 35,300.00 1,870.67 18,094.10 51.26 17,205.90 MAINTENANCE AND REPAIRS 51350-302 VEHICLE MAINTENANCE 4,500.00 2.38 572.84 12.73 3,927.16 51350-303 EQUIPMENT 70,000.00 223.86 8,150.46 11.64 61,849.54 51350-304 MACHINERY 5,000.00 0.00 312.59 6.25 4,687.41 51350-305 BUILDING AND GROUNDS 2,500.00 0.00 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 226.24 9,284.56 9.57 87,715.44 SERVICES 51350-401 COMMUNICATIONS 6,000.00 629.88 1,876.51 31.28 4,123.49 51350-402 ELECTRIC 62,000.00 4,499.00 13,273.75 21.41 48,726.25 51350-407 TECHNOLOGY 5,000.00 270.00 2,500.50 50.01 2,499.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 765.06 2,392.18 6.83 32,607.82 51350-420 DUES, FEES, AND MEMB RSHI 4,000.00 0.00 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 6,163.94 28,206.77 7.01 374,013.23 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 11 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 2024 20 -UTILITY FUND SEWER PLANT DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D e OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 51350-550 IN LIEU OF TAX 180,600.00 15,555.28 45,716.44 25.31 134,883.56 51350-553 CONTRIBUTION TO SINKING F 18,950.00 4,775.00 4,775.00 25.20 14,175.00 TOTAL SUNDRY CHARGES 199,550.00 20,3 330.28 50,491.44 25.30 149,058.56 CAPITAL OUTLAY CONTRIBUTIONS TO OTHER FU DEPARTMENT TOTAL 927,155.00 42,506.97 150,986.90 16.28 776,168.10 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 12 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,293.30 42,794.09 22.92 143,905.91 51375-102 LONGEVITY 1,600.00 128.08 384.24 24.02 1,215.76 51375-103 OVERTIME 22,500.00 1,871.92 4,402.78 19.57 18,097.22 51375-104 FICA 16,470.00 1,204.51 3,458.98 21.00 13,011.02 51375-105 RETI REMENT 27,800.00 2,141.08 6,237.06 22.44 21,562.94 51375-106 HEALTH INSURANCE 34,140.00 2,649.74 8,339.32 24.43 25,800.68 51375-107 CLOTHING 2,590.00 0.00 0.00 0.00 2,590.00 51375-108 CERTIFICATION 4,150.00 290.42 871.26 20.99 3,278.74 51375-109 LONG TERI M ITY 580.00 45.31 135.93 23.44 444.07 51375-115 WORKER'S COMPENSATION 5,730.00 0.00 5,265.00 91.88 465.00 51375-117 DENTAL INSURANCE 2,460.00 254.97 776.67 31.57 1,683.33 51375-118 LIFE INSURANCE 160.00 12.40 37.20 23.25 122.80 51375-120 L OY E EE NUS 280.00 279.73 279.73 99.90 0.27 TOTAL PERSONAL SERVICES 305,160.00 23,171.46 72,982.26 23.92 232,177.74 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 614.02 1,256.92 25.14 3,743.08 51375-210 FUEL 18,000.00 640.62 2,597.75 14.43 15,402.25 TOTAL SUPPLIES 27,500.00 1,254.64 3,854.67 14.02 23,645.33 MAINTENANCE AND REPAIRS 51375-302 VEHICLE MAINTENANCE 13,000.00 171.82 757.47 5.83 12,242.53 51375-303 EQUIPMENT 80,000.00 1,574.33 2,320.80 2.90 77,679.20 51375-304 MACHINERY 21,000.00 448.50 1,916.24 9.12 19,083.76 51375-305 BUILDING AND GROUNDS 2,500.00 2.66 15.66 0.63 2,484.34 51375-310 UTILITIES 30,000.00 627.95 12,383.41 41.28 17,616.59 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 918.06 918.06 4.17 21,081.94 TOTAL MAINTENANCE AND REPA AIRS 228,500.00 3,743.32 18,697.44 8.18 209,802.56 SERVICES 51375-401 COMMUNICATIONS 5,400.00 348.47 1,188.33 22.01 4,211.67 51375-402 ELECTRIC 10,000.00 788.03 2,390.57 23.91 7,609.43 51375-405 GAS 1,000.00 89.53 269.59 26.96 730.41 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 56.88 269.38 6.95 3,605.62 51375-416 RENTAL OF EQUIPMENT 500.00 0.00 0.00 0.00 500.00 51375-420 DUES, FEES, AND MEMBERSHI 500.00 37.50 37.50 7.50 462.50 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 1,175.63 3,879.63 48.50 4,120.37 51375-450 DEE BT E VICE INTE EST 2,475.00 220.01 684.83 27.67 1,790.17 51375-450-01 DEBT SERVICE PRINCIPAL 60,225.00 4,972.06 14,891.38 24.73 45,333.62 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 7,688.11 23, 611.21 7.29 300,193.79 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 13 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 35,857.53 119,145.58 13.46 765,819.42 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 14 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 29,183.51 86,362.93 23.38 282,977.07 51400-102 LONGEVITY 2,520.00 180.00 535.38 21.25 1,984.62 51400-103 OVERTIME 31,000.00 2,164.22 8,220.97 26.52 22,779.03 51400-104 FICA 30,900.00 2,331.76 6,927.92 22.42 23,972.08 51400-105 RETI REMENT 52,100.00 4,073.65 12,248.28 23.51 39,851.72 51400-106 HEALTH INSURANCE 61,100.00 5,090.53 15,271.59 24.99 45,828.41 51400-107 CLOTHING 6,260.00 0.00 528.31 8.44 5,731.69 51400-109 LONG TERM DISABILITY 1,190.00 87.54 262.62 22.07 927.38 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 1,208.43 27.22 3,231.57 51400-118 LIFE INSURA ANCE 300.00 24.00 72.00 24.00 228.00 51400-120 EMPLOYEE BONUS 550.00 541.40 541.40 98.44 8.60 TO: Z AL AL C CES 569,650.00 44,079.42 141,709.97 24.88 427,940.03 SUPPLIES 51400-201 OFFICE SUPPLIES 200.00 0.00 0.00 0.00 200.00 51400-204 SN 4A TOO. 4,500.00 2.20 142.18 3.16 4,357.82 51400-205 OPERATIONAL SUPPLIES 700.00 102.43 5,163.04 737.58 4,463.04) 51400-210 FUEL 15,000.00 1,244.21 2,316.00 15.44 12,684.00 TOTAL SUPPLIES 20,400.00 1,348.84 7,621.22 37.36 12,778.78 MAINTENANCE AND REPAIRS 51400-302 VEHICLE MAINTENANCE 15,000.00 300.00 1,260.55 8.40 13,739.45 51400-303 EQUIPMENT 2,000.00 400.00 1,780.50 89.03 219.50 51400-304 MACHINERY 200.00 0.00 0.00 0.00 200.00 51400-305 BUILDING AND GROUNDS 10,000.00 0.00 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 6,113.13 73,179.06 53.42 63,820.94 51400-312 CUSTOMER COMPLIANCE 500.00 0.00 0.00 0.00 500.00 TOTAL MAINTENANCE AND REPAIRS 168,200.00 6,813.13 82,227.31 48.89 85,972.69 SERVICES 51400-401 COMMUNICATIONS 10,500.00 1,296.46 2,846.88 27.11 7,653.12 51400-402 ELECTRIC 1,000.00 87.59 326.14 32.61 673.86 51400-403 LCRA WHOLESALE 3,040,000.00 238, 638.54 715,877.34 23.55 2,324,122.66 51400-404 SOLAR POWER BUYBACH K 18,000.00 688.03 2,585.02 14.36 15,414.98 51400-412 TRAVEL AND TRAINING 13,000.00 60.00 8,508.49 65.45 4,491.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 RSHI 9,000.00 0.00 67.50 0.75 8,932.50 51400-426 PROFESSIONAL FEES 126,000.00 16,781.16 29,883.08 23.72 96,116.92 51400-426-01 LCRA LINE DY 27,300.00 2,272.91 6,776.72 24.82 20,523.28 51400-450 CADENCE LEASE INTEREST 16,615.00 832.01 2,534.13 15.25 14,080.87 51400-450-01 A DENCE LEASE PRINCIPAL 52,920.00 2,743.09 8,191.17 15.48 44,728.83 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,361,236.00 263,399.79 780,075.47 23.21 2,581,160.53 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 15 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 2024 20 -UTILITY FUND ELECTRIC DEPARTMENT EXPENDITURES ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE SUNDRY CHARGES 51400-550 IN LIEU OF TAX 546,718.00 38,635.94 128,944.06 23.59 417,773.94 TOTAL SUNDRY CHARGES 546, 718.00 38, 635.94 128,944.06 23.59 417,773.94 CAPITAL OUTLAY * DEPARTMENT TOTAL 4,666,204.00 354,277.12 1,140,578.03 24.44 3,525,625.97 1-17-2025 09:17 AM CITY OF LLAN o PAGE: 16 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 2,154.88 62,022.08 65.09 33,258.92 51999-614 ELECTRIC 194,442.00 16,542.31 16,542.31 8.51 177,899.69 51999-616 SEWER COLLECTION 35,000.00 0.00 1,378.72 3.94 33,621.28 51999-617 WATER DISTRIBUTION 70,000.00 0.00 2,378.72 3.40 67,621.28 51999-621 BOND NATER TOWER 0.00 6,622.13 7,429.63 0.00 7,429.63) 51999-622 BOND SEWER INVENTORY 0.00 2,217.59 68,213.34 0.00 68,213.34) TOTAL CAPITAL OUTLAY 394,723.00 27,536.91 157,964.80 40.02 236,758.20 * DEPARTMENT TOTAL 394,723.00 27,536.91 157,964.80 40.02 236, 758.20 * TOTAL EXPENDITURES 10,981,522.00 706,773.22 2,314,621.04 21.08 8,666,900.96 * REVENUES OVER/ (UNDER) EXPENDITURES - 419,532.00) 103,854.68 182,718.26 43.55- 602,250.26) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 11,742.31 14,652.05 22.54 50,347.95 TOTAL REVENUES 65,000.00 11,742.31 14,652.05 22.54 50,347.95 EXPENDITURE SUMMARY WATER/SEWER 115,000.00 0.00 16,762.63 14.58 98,237.37 CAPITAL OUTLAY 130,100.00 4,852.59 4,852.59 3.73 125,247.41 ** * TOTAL XPENDITURES 245,100.00 4,852.59 21,615.22 8.82 223,484.78 REVENUES OVER/ (UNDER) EXPENDITURES 180,100.00) 6,889.72 6,963.17) 3.87 173,136.83) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,421.31 4,331.05 18.05 19,668.95 4999 TRANSFERS IN 41,000.00 10,321.00 10,321.00 25.17 30,679.00 TOTAL REVENUES 65,000.00 11,742.31 14,652.05 22.54 50,347.95 *** TOTAL REVENUE 65,000.00 11,742.31 14,652.05 22.54 50,347.95 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 115,000.00 0.00 16,762.63 14.58 98,237.37 TOTAL SERVICES 115,000.00 0.00 16,762.63 14.58 98,237.37 * DEPARTMENT TOTAL 115,000.00 0.00 16,762.63 14.58 98,237.37 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 4,852.59 4,852.59 9.71 45,147.41 51999-618 WATER PLANT 80,100.00 0.00 0.00 0.00 80,100.00 TOTAL CAPI TAL OUTLAY 130,100.00 4,852.59 4,852.59 3.73 125,247.41 ** ** DEPARTMENT TOTAL 130,100.00 4,852.59 4,852.59 3.73 125,247.41 * TOTAL EXPENDITURES 245,100.00 4,852.59 21,615.22 8.82 223,484.78 * REVENUES OVER/ (UNDER) EXPENDITURES ( 180,100.00) 6,889.72 6,963.17) 3.87 173,136.83) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 2,343.89 2,343.89 20.03 9,356.11 GENERAL 2,400.00 135.81 434.91 18.12 1,965.09 ** * TOTAL REVENUES 14,100.00 2,479.70 2,778.80 19.71 11,321.20 EXPENDITURE SUMMARY STARRY STARRY NIGHTS 17,600.00 9,655.45 12,542.11 71.26 5,057.89 ** * TOTAL EXPENDITURES 17,600.00 9,655.45 12,542.11 71.26 5,057.89 REVENUES OVER/ (UNDER) EXPENDITURES 3,500.00) 7,175.75) 9,763.31) 278.95 6,263.31 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 469.86 469.86 9.04 4,730.14 4103 CONCESSION SALES 2,300.00 679.03 679.03 29.52 1, 620.97 4104 PHOTOS WITH ANTA 2,000.00 94.00 94.00 4.70 1, 906.00 4109 SNOW DAY 2,000.00 1,101.00 1,101.00 55.05 899.00 4115 VEND DOR BOOTH RENTAL 200.00 0.00 0.00 0.00 200.00 TOTAL STARRY, STARRY NIGHTS 11,700.00 2,343.89 2,343.89 20.03 9,356.11 GENERAL 4701 INTEREST 2,400.00 135.81 434.91 18.12 1,965.09 TOTAL GENERAL 2,400.00 135.81 434.91 18.12 1,965.09 TOTAL REVENUE 14,100.00 2,479.70 2,778.80 19.71 11,321.20 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 63.60 405.47 9.65 3,794.53 50100-205 OPERATIONAL SUPPLIES 1,700.00 1,717.14 1,717.14 101.01 17.14) 50100-209 SNOW 7,000.00 6,206.25 6,206.25 88.66 793.75 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 7,986.99 8,328.86 62.16 5,071.14 MAINTENANCE AND REPAIRS 50100-303 DISPLAY MAIN NCI E 3,000.00 1,660.70 4,198.95 139.97 1,198.95) 50100-305 BUILDING & GROUNDS 1,200.00 0.00 6.54 0.55 1,193.46 TOTAL MAIN NCE AND E EPAIRS 4,200.00 1,660.70 4,205.49 100.13 5.49) SERVICES 50100-460 CREDIT CARD FEES 0.00 7.76 7.76 0.00 7.76) TOTAL SERV VICES 0.00 7.76 7.76 0.00 7.76) CAPITAL OUTLAY * DEPARTMENT TOTAL 17,600.00 9,655.45 12,542.11 71.26 5,057.89 * TOTAL EXPENDITURES 17,600.00 9,655.45 12,542.11 71.26 5,057.89 REVENUES OVER/ (UNDER) EXPENDITURES ( 3,500.00) 7,175.75) 9,763.31) 278.95 6,263.31 END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 62.60 193.94 21.55 706.06 * TOTAL REVENUES 900.00 62.60 193.94 21.55 706.06 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) 62.60 193.94 4.73- 4,293.94) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 62.60 193.94 21.55 706.06 TOTAL REVENUE 900.00 62.60 193.94 21.55 706.06 ** TOTAL REVENUE 900.00 62.60 193.94 21.55 706.06 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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) 62.60 193.94 4.73- 4,293.94) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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.10 497.41 24.87 1,502.59 * TOTAL REVENUES 2,000.00 162.10 497.41 24.87 1,502.59 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.10 497.41 11.05- 4,997.41) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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.10 497.41 24.87 1,502.59 TOTAL REVENUE 2,000.00 162.10 497.41 24.87 1,502.59 ** TOTAL REVENUE 2,000.00 162.10 497.41 24.87 1,502.59 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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.10 497.41 11.05- 4,997.41) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 37,603.41 115,191.16 7.65 1,390,243.84 * TOTAL REVENUES 1,505,435.00 37,603.41 115,191.16 7.65 1,390,243.84 EXPENDITURE SUMMARY AIRPORT 502,132.00 25,987.40 129,477.85 25.79 372,654.15 CAPITAL OUTLAY 1,000,000.00 0.00 0.00 0.00 1,000,000.00 ** * TOTAL XPENDITURES 1,502,132.00 25,987.40 129,477.85 8.62 1,372,654.15 REVENUES OVER/ (UNDER) EXPENDITURES 3,303.00 11,616.01 14,286.69) 432.54- 17,589.69 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 25,832.41 66,558.47 18.49 293,441.53 4571 HANGER RENT 80, 000.00 11,771.00 22,560.00 28.20 57,440.00 4572 LAND LEASE 500.00 0.00 0.00 0.00 500.00 4574 COVERED PARKING RENT 550.00 0.00 72.00 13.09 478.00 4575 SPECIAL EVENTS 26,500.00 0.00 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 37,603.41 115,191.16 7.65 1,390,243.84 * * TOTAL REVENUE 1,505,435.00 37,603.41 115,191.16 7.65 1,390,243.84 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 5,612.01 17,813.33 27.73 46,421.67 50900-103 OVERTIME 6,500.00 0.00 236.50 3.64 6,263.50 50900-104 FICA 5,420.00 437.59 1,389.07 25.63 4,030.93 50900-105 RETIREMENT 6,740.00 531.05 1,600.09 23.74 5,139.91 50900-106 HEALTH INSURANCE 16,450.00 680.30 2,040.90 12.41 14,409.10 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 74.34 111.51 10.14 988.49 50900-118 LIFE INSURANCE 60.00 4.80 28.80 48.00 31.20 50900-120 N YEE BONUS 110.00 108.28 108.28 98.44 1.72 TOTAL PERSONAL SERVICES 102,435.00 7,448.37 23,328.48 22.77 79,106.52 SUPPLIES 50900-201 OFFICE PE LIES 200.00 0.00 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 54.50 176.00 11.73 1,324.00 50900-210 FUEL 1,000.00 40.46 95.78 9.58 904.22 50900-212 AVI TION FUEL 280,000.00 11,518.09 62,342.47 22.27 217,657.53 50900-213 AVIATION OIL/RETAIL STOCK 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL SUPPLIES 283,800.00 11,613.05 62,754.23 22.11 221,045.77 MAINTENANCE AND REPAIRS 50900-302 VEHICLE MAINTENANCE 7,800.00 54.04 54.04 0.69 7,745.96 50900-303 EQUIPMENT 7,000.00 662.07 6,740.51 96.29 259.49 50900-305 BUILDING AND GROUNDS 50,000.00 0.00 58.78 0.12 49,941.22 TOTAL MAINTENANCE AND REPAIRS 64,800.00 716.11 6, 853.33 10.58 57,946.67 SERVICES 50900-401 COMMUNICATIONS 5,400.00 275.30 1,265.97 23.44 4,134.03 50900-402 ELECTRIC 11,000.00 554.76 1,791.11 16.28 9,208.89 50900-416 RENTAL OF EQUIPMENT 500.00 40.00 120.00 24.00 380.00 50900-420 DUES, FEES & MEMBERSHIPS 6,500.00 129.00 129.00 1.98 6,371.00 50900-428 SPEC IAL EVENTS EXPI NSES 23,197.00 5,210.81 33,235.73 143.28 10,038.73) TOTAL SERVICES 46,597.00 6,209.87 36,541.81 78.42 10,055.19 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 25,987.40 129,477.85 25.79 372,654.15 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 25,987.40 129,477.85 8.62 1,372,654.15 REVENUES OVER/ (UNDER) EXPENDITURES 3,303.00 11,616.01 14,286.69) 432.54- 17,589.69 END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 22,462.65 41,830.71 25.35 123,169.29 TOTAL REVENUES 165,000.00 22,462.65 41,830.71 25.35 123,169.29 EXPENDITURE SUMMARY ADMINISTRATION 171,910.00 0.00 2,795.12 1.63 169,114.88 TOTAL EXPENDITURES 171,910.00 0.00 2,795.12 1.63 169,114.88 * REVENUES OVER/ (UNDER) EXPENDITURES ( 6,910.00) 22,462.65 39,035.59 564.91- 45,945.59) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 22,462.65 41,830.71 25.35 123,169.29 TOTAL 165,000.00 22,462.65 41,830.71 25.35 123,169.29 * TOTAL REVENUE 165,000.00 22,462.65 41,830.71 25.35 123,169.29 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 0.00 2,795.12 11.18 22,204.88 TOTAL SUNDRY CHARGES 171,910.00 0.00 2,795.12 1.63 169,114.88 * DEPARTMENT TOTAL 171,910.00 0.00 2,795.12 1.63 169,114.88 * * TOTAL EXPE ENDITURES 171,910.00 0.00 2,795.12 1.63 169,114.88 REVENUES OVER/ (UNDER) EXPENDITURES ( 6,910.00) 22,462.65 39,035.59 564.91- 45,945.59) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,674.85 8,482.00 33.93 16,518.00 TOTAL REVENUES 25,000.00 2,674.85 8,482.00 33.93 16,518.00 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,674.85 8,482.00 3.41- 256,862.00) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,674.85 8,482.00 33.93 16,518.00 TOTAL REVENUES 25,000.00 2,674.85 8,482.00 33.93 16,518.00 * TOTAL REVENUE 25,000.00 2,674.85 8,482.00 33.93 16,518.00 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,674.85 8,482.00 3.41- 256,862.00) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 73,813.61 79,383.70 144.33 24,383.70) * TOTAL REVENUES 55,000.00 73,813.61 79,383.70 144.33 24,383.70) EXPENDITURE SUMMARY PAVING 393,756.00 0.00 0.00 0.00 393,756.00 PAVING PROJECT 50,000.00 71,120.57 71,120.57 142.24 21,120.57) ** * TOTAL XPENDITURES 443,756.00 71,120.57 71,120.57 16.03 372,635.43 REVENUES OVER/ (UNDER) EXPENDITURES 388,756.00) 2,693.04 8,263.13 2.13- 397,019.13) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,693.04 8,263.13 27.54 21,736.87 4999 TRANSFERS IN 25,000.00 71,120.57 71,120.57 284.48 46,120.57) TOTAL REVENUE 55,000.00 73,813.61 79,383.70 144.33 24,383.70) *** TOTAL REVENUE 55,000.00 73,813.61 79,383.70 144.33 ( 24,383.70) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 71,120.57 71,120.57 142.24 21,120.57) TOTAL SERVICES 50,000.00 71,120.57 71,120.57 142.24 21,120.57) CAPITAL OUTLAY DEPARTMENT TOTAL 50,000.00 71,120.57 71,120.57 142.24 21,120.57) * * TOTAL EXPENDITURES 443,756.00 71,120.57 71,120.57 16.03 372,635.43 * REVENUES OVER/ (UNDER) EXPENDITURES ( 388,756.00) 2,693.04 8,263.13 2.13- 397,019.13) END OF REPORT 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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,237.67 3,352.54 13.10 22,247.46 TOTAL REVENUES 25,600.00 1,237.67 3,352.54 13.10 22,247.46 EXPENDITURE SUMMARY 27,750.00 1,643.76 3,058.49 11.02 24,691.51 * TOTAL EXPENDITURES 27,750.00 1,643.76 3,058.49 11.02 24,691.51 * REVENUES OVER/ (UNDER) EXPENDITURES ( 2,150.00) 406.09) 294.05 13.68- 2,444.05) 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 2 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 2024 95 -MAIN STREET REVENUE ANNUAL CURRENT Y-T-D de OF BUDGET ACCT# ACCOUNT NAME BUDGET PERIOD ACTUAL BUDGET BALANCE 4556 AD SALES 0.00 477.45 477.45 0.00 477.45) 4701 INTEREST 2,000.00 153.27 468.58 23.43 1,531.42 4704 LANTEX CONCESSION 10,000.00 442.50 1,482.69 14.83 8,517.31 4709 LANTEX TICKET SALES 10,000.00 72.05 787.07 7.87 9,212.93 4716 SPONSORS SH IIP: S 3,000.00 0.00 0.00 0.00 3,000.00 4725 ALCOHOLIC BEVERAGE SALES 600.00 92.40 136.75 22.79 463.25 TOTAL 25,600.00 1,237.67 3,352.54 13.10 22,247.46 ** * TOTAL REVENUE 25,600.00 1,237.67 3,352.54 13.10 22,247.46 1-17-2025 09:18 AM CITY OF LLAN o PAGE: 3 FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 266.99 266.99 133.50 66.99) 50100-213 LANTEX CONCESSIONS 5,000.00 273.62 273.62 5.47 4,726.38 50100-214 LANTEX FILM EXPENSE 10,000.00 293.74 1,423.22 14.23 8,576.78 TOTAL SUPPLIES 15,200.00 834.35 1,963.83 12.92 13,236.17 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 5.40 36.12 18.06 163.88 TOTAL ERVICES 2,700.00 5.40 36.12 1.34 2,663.88 SUNDRY CHARGES 50100-505 FACADE IMPROVEMENT AWARDS 4,500.00 750.00 750.00 16.67 3,750.00 50100-525 LANTEX PROFIT SH ING 2,600.00 54.01 308.54 11.87 2,291.46 50100-530 SPECIAL PROJECTS 2,750.00 0.00 0.00 0.00 2,750.00 TOTAL SUNI ORY ES 9,850.00 804.01 1,058.54 10.75 8,791.46 * * DEPARTMENT TOTAL 27,750.00 1,643.76 3,058.49 11.02 24,691.51 1-17-2025 09:18 AM CITY OF LLAN o PAGE: FINANCIAL STATEMENT (UNAUDITED) AS OF: DECEMBER 31ST, 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 1,643.76 3,058.49 11.02 24,691.51 REVENUES OVER/ (UNDER) EXPENDITURES ( 2,150.00) 406.09) 294.05 13.68- 2,444.05) END OF REPORT