Loading...
04-25-2023 Agenda Packet                               MEETING AGENDA                               City Council              REGULAR SESSION CITY COUNCIL                              April 25, 2023                                   HAL BALDWIN MUNICIPAL COMPLEX COUNCIL CHAMBERS 1400 SCHERTZ PARKWAY BUILDING #4 SCHERTZ, TEXAS 78154 CITY OF SCHERTZ CORE VALUES Do the right thing Do the best you can Treat others the way you want to be treated Work cooperatively as a team     AGENDA TUESDAY, APRIL 25, 2023 at 6:00 p.m.          Call to Order    Opening Prayer and Pledges of Allegiance to the Flags of the United States and State of Texas. (Councilmember Whittaker)   Proclamations  National Library Week April 23-29, 2023 (Mayor Pro-Tem Brown) National Administrative Professionals Appreciation Week April 23-29, 2023 (Councilmember Davis)   City Events and Announcements  Announcements of upcoming City Events (B. James/S. Gonzalez) Announcements and recognitions by the City Manager (S. Williams) Announcements and recognitions by the Mayor (R. Gutierrez)   Hearing of Residents This time is set aside for any person who wishes to address the City Council. Each person should fill out the speaker’s register prior to the meeting. Presentations should be limited to no more than 3 minutes.  All remarks shall be addressed to the Council as a body, and not to any individual member thereof. Any person making personal, impertinent, or slanderous remarks while addressing the Council may April 25, 2023  City Council Agenda                                Page 1     be requested to leave the meeting. Discussion by the Council of any item not on the agenda shall be limited to statements of specific factual information given in response to any inquiry, a recitation of existing policy in response to an inquiry, and/or a proposal to place the item on a future agenda. The presiding officer, during the Hearing of Residents portion of the agenda, will call on those persons who have signed up to speak in the order they have registered.   Consent Agenda Items The Consent Agenda is considered self-explanatory and will be enacted by the Council with one motion. There will be no separate discussion of these items unless they are removed from the Consent Agenda upon the request of the Mayor or a Councilmember.   1.Minutes – Consideration and/or action approving the regular meeting minutes of April 11, 2023. (S.Edmondson/S.Courney)   Discussion and Action Items   2.Ordinance 23-S-02 - Consideration and/or action on a request to rezone approximately 25 acres of land from Pre-Development District (PRE) to Planned Development District (PDD), generally located approximately 2,200 feet southeast of the intersection of Country Club Boulevard and IH-35 access road, also known as a portion of Comal County Property Identification Number 377261 and Guadalupe County Property Identification 63833, City of Schertz, Comal County and Guadalupe County, Texas. (Final Reading) (B. James/ L. Wood/ E. Delgado)   Closed Session   3.The City Council will meet in closed session in accordance with Section 551.072, Texas Government Code deliberation regarding the purchase, exchange, lease, or value of Real Properties for future roadways, roadway extensions, and roadway expansions; city facilities, drainage and detention; and general municipal uses.   Reconvene into Regular Session   Roll Call Vote Confirmation   Information available in City Council Packets - NO DISCUSSION TO OCCUR   4.Quarterly Financial Reports - FY 2022-23 1st Quarter   5.Guadalupe Regional Medical Center Prescription Assistance Program - for Schertz Enrollees Report   April 25, 2023  City Council Agenda                                Page 2     Requests and Announcements  Requests by Mayor and Councilmembers for updates or information from Staff     Requests by Mayor and Councilmembers that items or presentations be placed on a future City Council agenda   Announcements by Mayor and Councilmembers    City and Community Events attended and to be attended City Council Committee and Liaison Assignments (see assignments below) Continuing Education Events attended and to be attended Recognition of actions by City Employees Recognition of actions by Community Volunteers   Adjournment   CERTIFICATION  I, SHEILA EDMONDSON, CITY SECRETARY OF THE CITY OF SCHERTZ, TEXAS, DO HEREBY CERTIFY THAT THE ABOVE AGENDA WAS PREPARED AND POSTED ON THE OFFICIAL BULLETIN BOARDS ON THIS THE 21ST  DAY OF APRIL 2023 AT 5:00 PM, WHICH IS A PLACE READILY ACCESSIBLE TO THE PUBLIC AT ALL TIMES AND THAT SAID NOTICE WAS POSTED IN ACCORDANCE WITH CHAPTER 551, TEXAS GOVERNMENT CODE.    SHEILA EDMONDSON    I CERTIFY THAT THE ATTACHED NOTICE AND AGENDA OF ITEMS TO BE CONSIDERED BY THE CITY COUNCIL WAS REMOVED BY ME FROM THE OFFICIAL BULLETIN BOARD ON _____DAY OF _______________, 2023. TITLE: ______________  This facility is accessible in accordance with the Americans with Disabilities Act. Handicapped parking spaces are available. If you require special assistance or have a request for sign interpretative services or other services, please call 210-619-1030. The City Council for the City of Schertz reserves the right to adjourn into closed session at any time during the course of this meeting to discuss any of the matters listed above, as authorized by the Texas Open Meetings Act. Closed Sessions Authorized: This agenda has been reviewed and approved by the City’s legal counsel and the presence of any subject in any Closed Session portion of the agenda constitutes a written interpretation of Texas Government Code Chapter 551 by legal counsel for the governmental body and constitutes an opinion by the attorney that the items discussed therein may be legally discussed in the closed portion of the meeting considering available opinions of a court of record and opinions of the Texas Attorney General known to the attorney. This provision has been added to this agenda with the intent to meet all elements necessary to satisfy Texas Government Code Chapter 551.144(c) and the meeting is conducted by all participants in reliance on this opinion.     COUNCIL COMMITTEE AND LIAISON ASSIGNMENTS     Mayor Gutierrez Audit Committee Board of Adjustments Investment Advisory Committee Main Street Committee Senior Center Advisory Board-Alternate   Councilmember Davis– Place 1 Interview Committee for Boards and Commissions Main Street Committee - Chair Parks & Recreation Advisory Board Schertz Housing Authority Board Transportation Safety Advisory Commission TIRZ II Board    April 25, 2023  City Council Agenda                                Page 3     Councilmember Watson– Place 2 Audit Committee Library Advisory Board Senior Center Advisory Board Cibolo Valley Local Government Corporation-Alternate   Councilmember Whittaker – Place 3 Audit Committee Historical Preservation Committee Interview Committee for Boards and Commissions Library Advisory Board TIRZ II Board   Councilmember Dahle – Place 4 Cibolo Valley Local Government Corporation Interview Committee for Boards and Commissions Planning & Zoning Commission TIRZ II Board   Councilmember Scagliola – Place 5 Animal Advisory Commission - Alternate Hal Baldwin Scholarship Committee Schertz-Seguin Local Government Corporation    Councilmember Heyward – Place 6 Animal Advisory Commission Audit Committee Building and Standards Commission Economic Development Corporation - Alternate Investment Advisory Committee Main Street Committee Interview Committee for Boards and Commissions-Alternate Senior Center Advisory Board-Alternate   Councilmember Brown – Place 7 Economic Development Corporation Main Street Committee Schertz-Seguin Local Government Corporation - Alternate      April 25, 2023  City Council Agenda                                Page 4     Agenda No. 1.   CITY COUNCIL MEMORANDUM    City Council Meeting:April 25, 2023 Department:City Secretary Subject:Minutes – Consideration and/or action approving the regular meeting minutes of April 11, 2023. (S.Edmondson/S.Courney) Attachments Minutes 04-11-2023  MINUTES REGULAR MEETING April 11, 2023 A Regular Meeting was held by the Schertz City Council of the City of Schertz, Texas, on April 11, 2023, at 6:00 p.m. in the Hal Baldwin Municipal Complex Civic Center Grand Ballroom, 1400 Schertz Parkway, Building #5, Schertz, Texas. The following members present to-wit: Present:Mayor Ralph Gutierrez; Mayor Pro-Tem Tim Brown; Councilmember Mark Davis; Councilmember Michelle Watson; Councilmember Jill Whittaker; Councilmember Michael Dahle; Councilmember David Scagliola; Councilmember Allison Heyward Staff present: City Manager Steve Williams; Deputy City Manager Brian James; Assistant City Manager Sarah Gonzalez; City Attorney Daniel Santee; Deputy City Secretary Sheree Courney          Call to Order Mayor Gutierrez called the meeting to order at 6:00 p.m.   Opening Prayer and Pledges of Allegiance to the Flags of the United States and State of Texas. (Councilmember Davis) Mayor Gutierrez recognized Councilmember Mark Davis who provided the opening prayer and led the Pledges of Allegiance to the Flags of the United States and State of Texas.   Proclamations National Public Safety Telecommunications Week April 9-15, 2023 (Councilmember Scagliola) Councilmember Scagliola presented the National Public Safety Telecommunications Week April 9-15, 2023, Proclamation to Nichole Kuhlmann, Communications Manager, and members of the Schertz 911 Dispatch team. National Animal Care and Control Appreciation Week April 9-15, 2023 (Councilmember Heyward) Councilmember Heyward presented the National Animal Care and Control Appreciation Week April 9-15, 2023, Proclamation to Megan Legunas, Animal Services Manager, and Schertz Animal Services officers.   Presentation 1 Presentation Alicia Sepeda-Stork Presentation Mayor Gutierrez recognized Nichole Kuhlmann, Communications Manager, who provided the following summary for the Stork presentation. It is rare for 911 dispatcher to receive an active labor call. However, on February 7, 2023, Alicia Sepeda, after 21 years as a 911 dispatcher received her first active labor call. Ms. Sepeda assisted with the delivery providing support and professional guidance to keep mom and baby safe. Mom Jasmine, Dad Jobani and baby Jonah were present for the recognition ceremony. Special Olympics Texas presents an award to Schertz Police Department for Polar Plunge (K.Cordova/A. Kraft) Mayor Gutierrez recognized Katrina Cordova, coordinator for Special Olympics. Ms. Cordova thanked the City of Schertz Police Department for their support and participation in the Special Olympic events. She hailed Officer Anna Kraft for her singular efforts raising more than half of the funds by herself and presented her with a gift basket. She then presented Assistant Chief Manny Casas and Lt. Virgil Jones, of the Schertz Police Department, with a plaque for reaching the gold level. Milestone Service Pin Presentations Mayor Gutierrez recognized City Manager Steve Williams who recognized the following employees and presented them with pins for their years of service and thanked them for their dedication and loyalty to the City of Schertz. Carl Quast, Building Inspector, 20 Years of Service Erin Matlock, Civic Center Manager, 20 Years of Service Bruno Sepeda, Facilities Maintenance Crew Supervisor, 25 Years of Service Wes Dailey, Paramedic, 25 Years of Service   City Events and Announcements Announcements of upcoming City Events (B. James/S. Gonzalez) Mayor Gutierrez recognized Deputy City Manager Brian James who provided the following: Saturday, April 22 Ed-ZOO-cation in the Park 10:00 a.m. - 12:00 p.m. Crescent Bend Nature Park JBSA - Fort Sam Houston Open House 2023 12:00 p.m. - 9:00 p.m. 2 Tuesday, April 25 Next Regular City Council Meeting 6:00 p.m. Council Chambers Announcements and recognitions by the City Manager (S. Williams) Mayor Gutierrez recognized City Manager Steve Williams who provided the following: Announced the promotion of Chad Lonsberry to Facilities Manager. Hal Baldwin scholarship applications are due April 28. Lions Club Easter in the Park was a huge success, several hundred kids showed up for the Easter Egg Hunt. Jr. High and High School Fire Academy is June 5-9. Applications are currently being accepted. More information is available on the website. Love Where You Live event will be on April 22, meet at Rock Point Church. More information is available on the website. Announcements and recognitions by the Mayor (R. Gutierrez) Mayor Gutierrez reminded students interested in the Hal Baldwin Scholarship they are required to sign in.   Hearing of Residents This time is set aside for any person who wishes to address the City Council. Each person should fill out the speaker’s register prior to the meeting. Presentations should be limited to no more than 3 minutes. All remarks shall be addressed to the Council as a body, and not to any individual member thereof. Any person making personal, impertinent, or slanderous remarks while addressing the Council may be requested to leave the meeting. Mayor Pro-Tem Brown recognized the following residents: Maggie Titterington, 1730 Schertz Parkway - Provided the following Chamber Updates: HyPer Shred Day was held on April 1st at the Schertz offices. HyPer raised $2,000 for this free event to donate to Operation Comfort. She thanked the citizens of Schertz for coming out to support this event. Ribbon Cuttings New York LIfe Wednesday, April 12 10:00 a.m. 1730 Schertz Parkway Alamo Title Wednesday, April 19 4:00 p.m. Business Education Class - presented by J2 Leadership 3 Business Education Class - presented by J2 Leadership "Finding, Recruiting, and Retaining Quality Staff" Crosspoint Fellowship Church FM 3009 8:00 a.m. - 11:00 a.m. Register online Free Chamber Office Hours Beginning May 1st 8:00 a.m. - 3:00 p.m. Monday - Friday Chamber Staff Updates Welcome to Lauren Dalton, new Special Events Coordinator. Farewell to Carol Lovelady, membership services team member. Coffee with the Chamber Friday, April 28 Selma Offices 7:30 a.m. - 9:00 a.m. Ms. Titterington invited everyone to attend the Coffee at the Chamber at the Selma offices or to stop by the Schertz offices at 1730 Schertz Parkway to say farewell to Ms. Lovelady on April 28th from 1:00 p.m. -5:00 p.m. Graham Wright, 1308 Arroyo Loma, Arroyo Verde subdivision - Mr. Wright stated he is the secretary/treasurer for the Arroyo Verde HOA and was there to address resident concerns with the I-35 Dedicated Transmission Line that will be built next to a number of homes in their subdivision. Concerns include incomplete information regarding the land requested for purchase and have requested multiple times for staff to speak with the HOA regarding the purpose of the transmission line. Mayor Pro-Tem Brown recognized the following residents who spoke regarding the accomplishments and current projects of the Schertz Historical Preservation Committee and their desire to keep the committee from being dissolved or disbanded: Dr. Miguel Vazquez, 9320 Berean Way Barbara Hall, 3020 Pencil Chalk   Consent Agenda Items The Consent Agenda is considered self-explanatory and will be enacted by the Council with one motion. There will be no separate discussion of these items unless they are removed from the Consent Agenda upon the request of the Mayor or a Councilmember. Mayor Gutierrez read Item #1 and Item #2 for the record.   1.Minutes – Consideration and/or action approving the regular meeting minutes of April    4 1.Minutes – Consideration and/or action approving the regular meeting minutes of April 4, 2023. (S.Edmondson/S.Courney)      2.Appointment/Reappointment for Boards/Commissions/Committees (S.Edmondson) Appointment of Mr. Richard Dziewit to the SSLGC Board of Directors Re-appointment of Mayor Ralph Gutierrez, Mayor Pro-Tem Tim Brown, Councilmember Mark Davis, and Councilmember Allison Heyward to the Main Street Committee Mayor Gutierrez asked for a motion to approve Consent Agenda Items 1 and 2.       Moved by Councilmember Allison Heyward, seconded by Councilmember Michael Dahle  AYE: Mayor Pro-Tem Tim Brown, Councilmember Mark Davis, Councilmember Michelle Watson, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember David Scagliola, Councilmember Allison Heyward Passed   Discussion and Action Items   3.Resolution 23-R-36 - Consideration and/or action by the City Council of the City of Schertz, TX approving a Resolution authorizing an Extraterritorial Jurisdiction Agreement with the City of Santa Clara for the release of 4.8 acres of the City of Schertz Extraterritorial Jurisdiction (ETJ). (B. James/L. Wood/E. Delgado) Mayor Gutierrez recognized Ms. Emily Delgado, Planning Manager, who explained that the City of Schertz had been approached by Chesmar Homes LLC, to release 4.8 acres lying within the Schertz Extraterritorial Jurisdiction (ETJ) to Santa Clara. Chesmar Homes purchased a total of 68.22 acres, most of which lies within the Santa Clara ETJ. The release of the 4.8 acres would then become part of the Santa Clara ETJ and the property could be developed under one jurisdiction instead of two. Mayor Guiterrez opened the floor to Council for discussion. Councilmember Scagliola expressed concern with development in ETJ's. There is a stark difference between developments in ETJs vs cities. City has no jurisdiction over development in an ETJ. Councilmembers Whittaker and Dahle expressed support for releasing the 4.8 acres to Santa Clara ETJ.       Moved by Councilmember Michael Dahle, seconded by Mayor Pro-Tem Tim Brown   5  AYE: Mayor Pro-Tem Tim Brown, Councilmember Mark Davis, Councilmember Michelle Watson, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember David Scagliola, Councilmember Allison Heyward Passed   4.Resolution 23-R-37 - Consideration and/or action by the City Council of the City of Schertz, TX, approving a revised Resolution setting the first Monday on or after the first day of Spring each year as "Employee Remembrance Day". (Replacing Resolution 96-R-7.) (S. Williams/C.Simmons) Mayor Gutierrez recognized Ms. Cyndi Simmons, Administrative Assistant for the City Management Office. Ms. Simmons explained this is an update to Resolution 96-R-7 to better reflect the observation of the program today. Mayor Gutierrez asked for a motion to approve Resolution 23-R-37.       Moved by Councilmember Jill Whittaker, seconded by Councilmember Allison Heyward  AYE: Mayor Pro-Tem Tim Brown, Councilmember Mark Davis, Councilmember Michelle Watson, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember David Scagliola, Councilmember Allison Heyward Passed   Workshop   5.IH-35 NEX Project TxDOT Presentation Mayor Gutierrez recognized Daniel Worden, I-35 NEX project manager, TxDOT. Project spans 20 miles from N. Walters Street to FM 1103. The project improves safety and mobility, addresses anticipated increase in traffic growth, reduces travel time, and services regional traffic. Added capacity is via elevated lanes that will be built between existing interstate lanes and the frontage road on both north and southbound sides. The elevated lanes will have two lanes for regular traffic flow and one HOV lane. TxDOT is anticipating 30% of traffic will use the elevated lanes. Mr. Worden turned the presentation over to Mr. Eric Devera, ANC, design-build contractor, who provided an overview of the design-build process. One company designs and builds the project. This streamlines processes, reduces costs and project schedule, provides for the agility to adapt to design obstacles, allows for input from construction team and suppliers during design, and fosters innovation. The design started October 25, 2021, and construction started June 27, 2022. Expected project completion is late 2027. Design-build cost is $1.5 billion.      6.Discussion regarding the Schertz Historical Preservation Committee    6 6.Discussion regarding the Schertz Historical Preservation Committee Workshop. (S.Williams/B.James). Mayor Gutierrez recognized Deputy City Manager Brian James who provided background and challenges facing the Schertz Historical Preservation Committee. City of Schertz does not impose historic regulations, no defined historic district, like most cities with a historic preservation committee who are charged with enforcing city imposed regulations. The Schertz Historic Preservation Committee doesn't have a set focus. The focus of the committee tends to shift with the members and leadership of the committee. There has been significant turnover in the committee members and no clearly defined leadership. Staff recommended releasing the committee from City constraints allowing them to operate more independently. Committee members are concerned that if they are disassociated as a City designated board or commission they will lose funding for projects. Mayor Gutierrez opened the floor to council for discussion. Councilmembers provided feedback on the staff recommendation and the recognition of the challenges faced by the committee. Further discussion with members of the committee were encouraged. It was also suggested they seek alternative options such as corporate sponsors, advice from The Chamber, and establishing themselves as a separate entity with a defined focus. The committee needs to take greater ownership of the mission and maintain a solid defined focus. If they can do that successfully, Councilmembers agreed to allow them to retain their designation as a City Board/Committee provided they can comply with the City's regulations required for such designation.      Roll Call Vote Confirmation Mayor Gutierrez recognized Deputy City Secretary Sheree Courney who provided roll call for Consent Agenda Items 1 - 2, and Agenda Items 3 - 4.   Information available in City Council Packets - NO DISCUSSION TO OCCUR   Requests and Announcements Requests by Mayor and Councilmembers for updates or information from Staff - No requests were made. Requests by Mayor and Councilmembers that items or presentations be placed on a future City Council agenda - No requests were made. Announcements by Mayor and Councilmembers City and Community Events attended and to be attended Councilmember Scagliola attended the Lions Club Easter in the Park event. Councilmember Heyward participated in the Child Abuse Prevention & Awareness Photo with City staff and watched the webinar 'Preparing for ICSC' City Council Committee and Liaison Assignments (see assignments below) Continuing Education Events attended and to be attended - none provided 7 Recognition of actions by City Employees - none provided Recognition of actions by Community Volunteers - none provided   Adjournment Mayor Gutierrez adjourned the meeting at 8:28 p.m.   _______________________________ Ralph Gutierrez, Mayor ATTEST: ____________________________________ Sheila Edmondson, City Secretary 8 Agenda No. 2.   CITY COUNCIL MEMORANDUM    City Council Meeting:April 25, 2023 Department:Planning & Community Development Subject: Ordinance 23-S-02 - Consideration and/or action on a request to rezone approximately 25 acres of land from Pre-Development District (PRE) to Planned Development District (PDD), generally located approximately 2,200 feet southeast of the intersection of Country Club Boulevard and IH-35 access road, also known as a portion of Comal County Property Identification Number 377261 and Guadalupe County Property Identification 63833, City of Schertz, Comal County and Guadalupe County, Texas. (Final Reading) (B. James/ L. Wood/ E. Delgado) BACKGROUND Update from the April 4, 2023 City Council Meeting: At the April 4, 2023 City Council meeting the applicant requested the item be tabled until the April 25, 2023 City Council meeting in order to continue the developers communications with the residents. City Council unanimously approved to table the item to the April 25, 2023 meeting. As a reminder, as of the call of the March 7, 2023 City Council meeting the total percentage of the protested parcel acreage is 26.93%, therefore, the 3/4 vote has been triggered for the City Council.  Update from the March 7, 2023 City Council Meeting: At the March 7, 2023 City Council meeting the applicant requested the item be postponed until the April 4, 2023 City Council meeting. City Council unanimously approved to postpone the item to the April 4, 2023 meeting. As of the call of the March 7, 2023 City Council meeting the total percentage of the protested parcel acreage is 26.93%, therefore, the 3/4 vote has been triggered for the City Council.  Update from February 28, 2023 City Council Meeting: At the February 28th City Council meeting a public hearing was conducted in relation to this item. After the public hearing the City Council voted to approve the proposed zone change to Planned Development District as presented by staff, with the trail to be shown on future plans. The vote was a 4-3 vote with Council Members Heyward, Whittaker, Dahle, and Mayor Gutierrez voting in favor and Council Members Davis, Watson, and Scagliola voting nay.  The applicant is proposing to rezone approximately 25 acres of land from Pre-Development District (PRE) to Planned Development District (PDD) with a base zoning of Townhome District (TH).  Public Notice: One hundred seventeen (117) public hearing notices were mailed to the surrounding property owners on January 13, 2023. At the time of this report (March 20, 2023), staff has received the following responses one (1) neutral, one hundred thirty-five (135) opposed, and thirty-three (33) in favor of the proposed zoned change request. Additionally, staff has received a letter of support from the Scenic Hills HOA. A public hearing notice was published in the "San Antonio Express" on February 8, 2023 prior to the City Council public hearing.  If a proposed zoning change is protested in writing and signed by the owners of at least twenty percent (20%) of the area of the lots or land immediately adjoining the area covered by the proposed zoning (20%) of the area of the lots or land immediately adjoining the area covered by the proposed zoning change or zoning map amendment and extending 200 feet from that area, the proposed change must receive, in order to take effect, the affirmative vote of at least three-fourths (¾) of all members of the City Council according to LGC, Local Government Code § 211.006(d). At the time of this staff report (March 20, 2023) the total percentage of the protested parcel acreage is 26.93%, therefore, the 3/4 vote has been triggered for the City Council.  Proposed Zoning Concept:  The proposed zoning is to Planned Development District (PDD) with a base zoning of Townhome District (TH). The proposed development will be a gated community with no more than 198 units. These will be spread across fifty-one (51) buildings. Six (6) of the proposed buildings would have three (3) units and the remaining forty-five (45) buildings will have four (4) units. Each unit is proposed to be its own townhome and could be sold separately. Each unit will be between 1,300 square feet and 1,400 square feet. Every unit will feature 3 bedrooms, 2.5 baths, an eat in kitchen, two living rooms, a laundry room, an office/flex room, and a covered patio. Additionally, each unit will have its own garage, covered back patio, and a private yard. The proposed development would be maintained by the HOA and is proposed to have 7.52 acres of green space and amenities.  The PDD Design Standards propose to conform with the Townhome District zoning with modifications to the lot width and depth as shown in the table below.     Classification Minimum Lot Size Minimum Yard Setback  Area Square Footage Width Ft. Depth Ft. Front Ft. Side Ft. Rear Ft.  Townhome District Per the Unified Development Code 2,500 25 100 25 10 20 Townhome (Type A)3,045 35 87 25 10, 0 20 Townhome (Type B)2,175 25 87 25 0, 0 20 * Each lot will have a 10-foot side setback if on the end or a zero setback if in the interior, a 25- foot front setback, and a 20-foot rear setback.  Parks and Amenities: The proposed PDD plans to incorporate 7.52 acres of green space and amenities. This would include a pavilion, playground for the community, a concrete walking path. Additionally, a mail center is proposed with a covered pavilion, and additional parking access. There is also a proposed 0.45 acre fenced-in private dog park, a 1.85 acre private picnic / trail / community garden area, 0.30 acre of miscellaneous green spaces and a 4.01 acre open space / easement.  Fire Suppression and Fire Walls: Per the proposed PDD Design Standards due to the proposed reduced side yard setbacks, each townhome is proposed to have fire sprinklers, will require all A/C condensers to be in the rear yard, and exterior walls would be at least a minimum of a 1-hour fire rated.  Parking: Per the proposed PDD Design Standards there are a proposed 654 parking space across the development.   Additional Design Standards Proposed: Per the proposed PDD Design Standards the developer has proposed to create a twenty foot (20') buffer in the rear of the yards associated with the development that are adjacent to the Fairways at Scenic Hills neighborhood. Additionally, the developer will prohibit the placement of any structures, including but not limited to sheds, in the buffer area. In this proposed twenty-foot (20') buffer, the developer will plant one tree in the middle of said buffer.   GOAL The project goal is to rezone approximately 25 acres of land, generally located approximately 2,200 feet southeast of the intersection of Country Club Boulevard and IH-35 access road, also known as a portion of Comal County Property Identification Number 377261 and Guadalupe County Property Identification 63833 from Pre-Development District (PRE) to Planned Development District (PDD).  COMMUNITY BENEFIT It is the City’s desire to promote safe, orderly, efficient development and ensure compliance with the City’s vision of future growth. SUMMARY OF RECOMMENDED ACTION In 2022 the applicant submitted a zone change request to a Planned Development District (PDD) with a base zoning of Apartment/ Multi-Family Residential (R4). That proposal included approximately 220 units to be developed as fourplexes. On September 27, 2022 the City Council was unable to obtain the super majority needed for the approval of that zone change application, which ultimately lead to the application being denied. During the discussion at the September 27, 2022 City Council meeting there were concerns with the proposed density.  Based on the previous City Council feedback the developer has made changes to the proposed PDD to address the concerns presented at the September 27th meeting. Rather than the previously proposed PDD with a base zoning of Apartment/ Multi-Family, the current proposal is for a PDD with a base zoning of Townhome District, which was directly discussed at the City Council meeting. This ultimately reduced the overall density proposed within the development.  The Schertz Sector Plan for Northern Schertz designates the subject property as Single-Family Residential. The Single-Family Residential land use designation encourages the mixture of various residential type development as well as maintaining a walkable neighborhood feel. The proposed rezoning to Planned Development District (PDD), with a base zoning of Townhome District (TH) does conform to the Comprehensive Land Use Plan designation as it would provide a needed mixture of housing type to Schertz. The proposed development would have a maximum of fifty-one (51) buildings consisting of no more than 198 units.  As previously stated, the applicant in September of 2022 proposed to rezone the property to Planned Development District, although that application was ultimately denied as part of that application the applicant was working with the Parks Department in relation to a trail that is shown on the 2017 Schertz Transportation Plan-Trails Network. The previous proposal was to dedicate land within the overhead utility easement to be utilized for a trail that would ultimately be part of the "Great Northern Trail". This proposed trail was shown on the previous concept plan and identified the public walking trail along with private exercise equipment and benches.  The current proposed development no longer accounts for, or proposes the dedication or construction of the walking trail within the overhead electrical easement. Based on the Trails Presentation at the January 10, 2023 City Council meeting, the City Council expressed their desire for trails within the City of Schertz and the importance of requiring trails to be constructed with developments. Based on City Council's desire to have trails and the subject property having an identified trail per the Schertz Transportation Plan-Trails Network, staff feels that the development should be required to dedicate and construct the trail per the plan.    RECOMMENDATION Staff Recommendation:  Staff recommends approval of the proposed zone change to Planned Development District (PDD) with a condition that per the 2017 Schertz Transportation Plan-Trails Network the proposed project would include the trail on all future exhibits and plans and construct the identified trail on the subject tract. Planning and Zoning Commission Recommendation:  The Schertz Planning and Zoning Commission met on January 25, 2023 and voted to recommend that City Council approve the proposed zone change with a condition that the proposed project would include the trail on all future exhibits and plans by a 5-2 vote with Chairman Outlaw and Commissioner McMaster with the nay votes.  Attachments Ord 23-S-02  Exhibit A- Metes and Bounds  Exhibit B- Zoning Exhibit  Exhibit C- PDD Design Standards  Conceptual Plan  Aerial Exhibit  Public Hearing Notice Map  Public Hearing Notice Responses as of 03.07.2023  Scenic Hills HOA Letter of Support  City Council Presentation Slides  ORDINANCE NO. 23-S-02 AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AUTHORIZING THE OFFICIAL ZONING MAP BY REZONING APPROXIMATELY 25 ACRES OF LAND FROM PRE- DEVELOPMENT DISTRICT (PRE) TO PLANNED DEVELOPMENT DISTRICT (PDD), GENERALLY LOCATED APPROXIMATELY 2,200 FEET SOUTHEAST OF THE INTERSECTION OF COUNTRY CLUB BOULEVARD AND IH-35 ACCESS ROAD, ALSO KNOWN AS A PORTION OF COMAL COUNTY PROPERTY IDENTIFICATION 377261 AND GUADALUPE COUNTY PROPERTY IDENTIFICATION 63833, CITY OF SCHERTZ, COMAL AND GUADLAUPE COUNTY, TEXAS WHEREAS, an application to rezone approximately 25 acres of land from Pre- Development District (PRE) to Planned Development District (PDD), generally located approximately 2,200 feet southeast of the intersection of Country Club Boulevard and IH-35 access road, and more specifically described in the Exhibit A and Exhibit B attached herein (herein, the “Property”) has been filed with the City; and WHEREAS, the City’s Unified Development Code Section 21.5.4.D. provides for certain criteria to be considered by the Planning and Zoning Commission in making recommendations to City Council and by City Council in considering final action on a requested zone change (the “Criteria”); and WHEREAS, on January 25, 2023, the Planning and Zoning Commission conducted a public hearing and, after considering the Criteria, made a recommendation to City Council to approve with conditions the requested rezoning according to the development standards set forth in Exhibit C attached herein (the “Development Standards”); and WHEREAS, on February 28, 2023, the City Council conducted a public hearing and after considering the Criteria and recommendation by the Planning and Zoning Commission, determined that the requested zoning be approved as provided for herein. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS THAT: Section 1. The Property as shown and more particularly described in the attached Exhibit A and Exhibit B, is hereby zoned Planned Development District (PDD) Section 2. The Official Zoning Map of the City of Schertz, described and referred to in Article 2 of the Unified Development Code, shall be revised to reflect the above amendment. Section 3. The recitals contained in the preamble hereof are hereby found to be true, and such recitals are hereby made a part of this Ordinance for all purposes and are adopted as a part of the judgment and findings of the Council. Section 4. All ordinances and codes, or parts thereof, which are in conflict or inconsistent with any provision of this Ordinance are hereby repealed to the extent of such conflict, and the provisions of this Ordinance shall be and remain controlling as to the matters resolved herein. Section 5. This Ordinance shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 6. If any provision of this Ordinance or the application thereof to any person or circumstance shall be held to be invalid, the remainder of this Ordinance and the application of such provision to other persons and circumstances shall nevertheless be valid, and the City hereby declares that this Ordinance would have been enacted without such invalid provision. Section 7. It is officially found, determined, and declared that the meeting at which this Ordinance is adopted was open to the public and public notice of the time, place, and subject matter of the public business to be considered at such meeting, including this Ordinance, was given, all as required by Chapter 551, as amended, Texas Government Code. Section 8. This Ordinance shall be effective upon the date of final adoption hereof and any publication required by law. Section 9. This Ordinance shall be cumulative of all other ordinances of the City of Schertz, and this Ordinance shall not operate to repeal or affect any other ordinances of the City of Schertz except insofar as the provisions thereof might be inconsistent or in conflict with the provisions of this Ordinance, in which event such conflicting provisions, if any, are hereby repealed. PASSED ON FIRST READING, the 28th day of February 2023. PASSED, APPROVED and ADOPTED ON SECOND READING, the 4th day of April, 2023. CITY OF SCHERTZ, TEXAS _____________________________ Ralph Gutierrez, Mayor ATTEST: _____________________________ Sheila Edmondson, City Secretary (city seal) COMAL COU N T Y GUADALUPE C O U N T Y COMAL COU N T Y GUADALUPE C O U N T Y 35 ZONE CHANGE EXHIBIT ZONE CHANGE EXHIBIT 1 The Villas at Bluebonnet Ridge A PLANNED DEVELOPMENT DISTRICT City of Schertz January 2023 Table of Contents 1. Planned Development District ----------------- 2 2. PDD Purpose and Intent ------------------------- 2 3. The Property ---------------------------------------- 2-3 4. Parks and Amenities ------------------------------ 3-4 5. Zoning District -------------------------------------- 4 6. Townhome District Zoning ---------------------4-5 7. Homeowners Association and Maintenance ---------------------------------------- 5 8. Architectural Review Comitee ----------------- 6 9. Site Design Standards ---------------------------- 6 10. Fire Suppression and Fire Walls --------------- 6 11. Parking ----------------------------------------------- 6-7 12. Amendments to the Planned Development District (PDD) -------------------- 7 Exhibits A. Meets and Bounds Description B. The Villas at Bluebonnet Ridge C. Zoning Exhibit D. Amenities, Parks, Entry, Mail Station E. Parking Exhibit Per Unit January 2023 Habi Land, LLC. Authored by: Eugenio Murillo 2 The Villas at Bluebonnet Ridge 198 Unit Development on 24.1784 Acres Planned Development District. Understanding there may be circumstances in which a development might not be able to adhere to the strict regulations and design standards set forth in the Schertz Unified Development Code (UDC), the UDC established Article 5, and Section 21.5.10, a Planned Development District (PDD), as an alternative approach to conventional land development. The City of Schertz Unified Development Code as amended will govern development of the property, except for the following statements. PDD Purpose and Intent. The purpose of PDD regulations is to encourage and promote more creative, innovative, and imaginative land development than would be possible under the regulations found in a typical zoning district. The intent is to allow substantial flexibility in planning, design, and development standards in exchange for greater land values and amenities. Enhanced parkland and open space, preservation of natural resources, pedestrian friendly environment, and deviation from the typical traffic patterns are all a result of this allowed flexibility. It is this intrinsic flexibility, in the form of relief from the normal zoning ordinances, design standards, land use densities, and subdivision regulations, that allows for the definition of uses, densities and standards that will permit the alternative planning associated with a PDD and this development known as The Villas at Bluebonnet Ridge. The Property. The location of the subject property is directly west of the Scenic Hills Neighborhood and directly east of The Fairways at Scenic Hills. The current condition of the property creates a unique opportunity for development. The approximately 24.1784-acre site was previously known as part of the Northcliffe Golf Club. The property is bound by Country Club Boulevard to the south, Columbia Drive to the North, and existing single-family neighborhoods to the east and west. 3 Analysis of the property via phase 1 ESA reports, geotechnical reports, and bore samples do not reveal any physical constraints, potential health, or safety hazards. Further evaluation of the tract by the Developer’s engineers has confirmed utilities are available and the property’s demands can be served. The Villas at Bluebonnet Ridge (Exhibit B) is proposed. Such amenities will include both passive and active areas, as well as concrete pathways and crushed granite walking trails. Multi-purposed walkways and sidewalks will provide links between park areas, open spaces, resident units, and amenities. Amenities provided and shown on Exhibit D will include playscapes, picnic tables, and a neighborhood pavilion. All of which, promote a safe and pedestrian friendly environment and overall livable community. Also, Exhibit D will depict the entry gate and landscaping features. Our current concept plan consists of a gated community with no more than 198 units. These units will be spread across 51 buildings. Six building will have 3 units in them, and the remaining forty-five buildings will have each have 4 units. Each unit will be a townhome and can be sold separately. Each unit will be between 1,300 sf and 1,400 sf. Every unit will feature 3 bedrooms, 2.5 baths, an eat in kitchen, two living rooms, a laundry room, an office/flex room, a covered patio, and a one car garage. All buildings will have its own fire sprinkler system meeting NFPA and local code requirements. Each unit will have its own garage, covered back patio, and private yard. This proposed community, will be managed, and maintained by The Villas at Bluebonnet Ridge “HOA”. The community is designed to enhance the overall neighborhood standards by incorporating 7.52 acres of green space and amenities. This includes multiple Private Parks including an open space easement, all of which is outlined in the overall site plan Exhibit B and Exhibit D. Parks & Amenities. The development’s interior private park and amenities as shown on 0.59 acres, are designed to house a pavilion for birthday parties & special events, a playground for the community, and a concrete walking path. The mail center is designed with a covered pavilion, and additional parking access will be provided on 0.32 acres. In addition to the previously mentioned improvements, the development will also feature a 0.45 acre fenced in private dog park, a 1.85-acre private Picnic/Trail/Community 4 Garden area, 0.30 of miscellaneous Green Spaces and a 4.01-acre open space. All the above is shown on Exhibit B and Exhibit D Zoning District. There are circumstances, due to property constraints or external factors, which do not always support the notion that one size fits all especially in applying zoning subdivision codes as such relates to property development. As a planned development, the attached “The Villas at Bluebonnet Ridge” (Exhibit B) as well as this document define the types of uses for this proposed PDD. The plan delineates land use that allows for three and four-unit buildings as well as delineating parks, amenities, and open space. Specifically, UDC Sec. 21.9.7.G would ordinarily require the Developer to install a twenty- foot (20’) landscape buffer adjacent to the property line of the residential use or residentially zoned property. In this case, that would be the Fairways at Scenic Hills neighborhood. The Developer maintains installing this twenty-foot (20’) buffer outside the property boundaries would essentially create an alley between Fairways at Scenic Hills neighborhood and the proposed development. Given the length of the alley, the Developer maintains this could create an area for potential loitering as well as littering. The Developer would propose to create the twenty-foot (20’) buffer in the rear of the yards associated with the development that are adjacent to the Fairways at Scenic Hills neighborhood. The Developer will prohibit the placement of any structures, including but not limited to sheds, in the buffer area through the HOA restrictions. The Developer shall plant one tree in the middle of the twenty -foot (20’) buffer in each yard. The Developer believes in doing both, they have met the spirit of UDC Sec. 21.9.7.G. Townhome District Zoning. The intent of the development is to conform with the Townhome District zoning district but to modify the lot width and depth as follows. Each lot is comprised of at least 3,045 sf or 2,175 sf with a minimum depth of 87-feet. Each lot will have a width of at least 25 feet or 35 feet. There will be 143 lots with a 25-foot width and 55 lots with a 35 foot width. Each area, as shown and identified on Exhibit E. Each lot will have a 10-foot side setback if on the end or a zero setback of in the interior, a 25-foot front setback, and a 20-foot rear setback per the table below. Where residential lots have double frontage, running from one street to another, no access from the rear of the property will be permitted to the street. Only one access point will 5 be permitted from a residential lot, so long as the access is from the front of the lot. All lots with double frontage within that block will have the same restriction and orientation as the lot on either side. Table 21.5.7.A DIMENSIONAL REQUIREMENTS RESIDENTIAL ZONING DISTRICTS Minimum Lot Size and Dimensions Minimum Yard Setback (Ft) Miscellaneous Lot Requirements Code Zoning District Area Sq. Ft. Width Ft. Depth Ft. Front Ft. Side Ft. Rear Ft. Minimum Off-Street Parking Spaces Max Height Ft. Max Imperv Cover Key TH Per UDC Townhome District 2500 25 100 25 10 20 2 35 75% h,j,k,l, m TH (Type A) Townhome District 3,045 35 87 25 10, 0 20 2 35 75% h,j,k,l, m TH (Type B) Townhome District 2,175 25 87 25 0, 0 20 2 35 75% h,j,k,l, m Key: h. Corner lot shall have minimum 15-foot yard setback from street right-of-way. j. Site Plan approval required. k. Swimming pools count toward the maximum impervious cover limitations, unless the swimming pool is equipped with a water overflow device appropriate for such pool, and only if it drains into any pervious surface, in which case the water surface shall be excluded. l. No variances may be permitted to exceed the maximum impervious cover limitations m. Refer to Article 14, section 21.14.3 for additional design requirements Homeowners Association & Maintenance. This development will be gated, and a Homeowners Association (HOA) will be established. The entire development both inside and outside of the gates to include irrigation will be maintained by the HOA’s maintenance crew. This is to include the maintenance of common areas, all front yards, side yards, and back yards. This is also to include landscape buffers as defined in Sec. 21.9.7 Landscaping, and maintaining fences, and/or walls. The HOA’s maintenance crew will have access to all back yards via side gates and interior gates between units. The HOA will have 102 master keyed locks to allow for access to maintain the interior unit’s backyard of each building. An 8-foot masonry wall will be installed along the boundary with The Northcliffe neighborhood. The landscape buffer abutting The Fairways at Scenic Hills will all be maintained by the HOA in its entirety unless agreed upon otherwise with The Fairways at Scenic Hills Homeowners Association. Crushed granite walking trails, concrete pathways, neighborhood amenities, and multi-use paths within the development’s common areas will all be maintained by “The Villas at Bluebonnet Ridge HOA” as well. 6 Architectural Review Committee. The Developer will establish an Architectural Review Committee (ARC) which will be responsible for reviewing and approving construction plans for all residential construction within The Villas at Bluebonnet Ridge. The ARC will consist of members appointed by the Developer until all the property within the Villas at Bluebonnet Ridge has been transferred to an independent third-party purchaser or to the HOA. Construction of residential and community amenities within the Villas at Bluebonnet Ridge shall first be submitted to the ARC for approval and to verify compliance with the terms, conditions, and obligations of the PDD and deed restrictions. The ARC shall review such contemplated construction and shall, if approved, provide verification in a form acceptable to the City by which the ARC verifies that the plan for the contemplated construction complies with the PDD and associated guidelines . Site Design Standards. This proposed development conforms to the Comprehensive Land Plan for orderly and unified development of streets, utilities, neighborhood design, and public land and facilities. Streets, gates, and lighting will be maintained by the HOA. All public utilities will be maintained by the city with easements to be recorded for access and maintenance as detailed in the utility plan provided to the city. Fire Suppression and Fire Walls. Due to the reduced side yard setbacks, each townhome within the Villas as Bluebonnet Ridge will have fire sprinklers, will require all A/C condensers to be in the rear yard, and exterior walls will be at least a minimum of a 1- hour fire rated. Parking. According to UDC Section 21.10.4, each 3-bedroom unit within this development is required to have 2.5 off street parking spaces. Plus, additional guest parking at a ratio of 5% of the required spaces. The intent of the development is to conform to the UDC requirements but to modify the section to allow for garage parking to be counted as part of the required spaces. As noted, and shown in Exhibit E, each 3 - bedroom unit has two driveway parking spaces in addition to one garage parking space for a total of 3 spaces per unit. In addition to the 594 off street parking spaces allocated across the development, there are an additional 16 parking spaces split between the 7 interior parks and mail station and an additional 44 spaces available on street to use as overflow and guest parking. Total parking spaces available are 654. Amendments to the Planned Development District (PDD). Any significant future changes from the established Dimensional Requirements for the approved PDD, which alter the concept of the PDD or increase the density, will cause the plan to be re - submitted for approval by the Planning & Zoning Commission and the City Council, including a new public hearing with applicable fees. Minor changes which do not change the concept or intent of the development shall be approved or denied administratively. The Vias !P !P!P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P!P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P!P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P !P g U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U 34755NOLLEY CARIBBEANPROPERTIES LLC 63838NOLLEY CARIBBEANPROPERTIES LLC 34548NOLLEY CARIBBEANPROPERTIES LLC 1 2 1 8 9 6 N O L L E Y C A R I B B E A N P R O P E R T I E S L L C 63835NOLLEY CARIBBEANPROPERTIES LLC377261HABI LANDLLC 63833HABI LAND LLC 40 7 2 4 40 7 2 3 40 6 0 0 40 6 0 3 3 4 8 0 0 108306 40 6 1 8 40626 40 7 2 0 40608 406 0 5 3 4 8 0 1 3 4 7 9 9 108307 40 7 2 1 40 6 0 2 40 7 2 2 407 1 7 406 0 7 407 1 8 40726 40727 40611 40619 40 6 0 1 40 7 2 5 406 0 4 40 5 9 8 40 5 9 9 406 0 6 108331 117165 117164 117 1 6 2 117 4 3 5 11 7 4 3 6 1 1 7 4 3 7 117434 1171 6 0 1 1 7 4 2 7 117158 117159 116735 1 2 1 9 3 5 1 2 1 9 3 6 117438 1219 2 9 121934 121932 121933 116737 116736 1219 2 8 11 5 7 2 0 11 5 7 1 9 1 2 1 8 9 7 121907 121910 1 1 7 4 3 2 121908 1219 0 9 1 2 1 9 1 2 12 1 9 1 1 117425 11 7 4 3 3 1 1 5 7 2 6 117163 117424 1174 2 6 117 4 2 8 1 2 1 9 1 3 117430 117429 115722 40615 40616 1157231 1 7 4 3 1 11 6 7 3 9 116 7 4 0 116742 40 6 2 1 4 0 5 9 0 40612 11 5 7 2 4 1 1 5 7 2 5 4 0 5 9 1 40 5 9 7 40 5 9 2 40 6 2 9 40 6 2 8 4 0 5 8 9 4 0 5 8 8 40 5 9 6 40623 40 6 2 7 40 5 9 3 40 5 9 4 40 5 9 5 121927 117439 12 1 9 3 0 1 2 1 9 3 1 1 1 7 1 6 1 11673 8 116741 117 4 2 3 40625 40620 40622 40 6 1 3 11572 1 40 6 1 0 40 6 1 7 40 6 0 9 40751 40 6 1 4 Comal County Guadalupe County 1" W L 2" WL 8" WL 8" WL 2" WL 1 2 " W L 6" W L 6" WL 6" W L 8"WL 1 2 " W L 8" WL 2" W L 8" WL 8" WL 6" WL 8 " W L 8 " W L 6" WL 6" WL 8"WL 6" W L 8" WL 10 " W L 6" WL 8 " W L 8" W L 8 " W L 6" W L 6" W L 6" W L 6" W L 6" WL 8 " W L 1 2 " W L 6" WL 6 " W L 6 " W L 6 " W L 6" WL 12" WL 8" WL 8" W L 12 " W L 6" WL 8 " W L 8" WL 8" WL 8"WL 8" WL 2"WL 2"WL 2"WL 2"WL 2"WL 8" W L 8 " W L 8" WL 2" WL 4" WL 4 " W L 12" WL 12" WL 1 2 " W L 2 " W L BEAVER CRK CHER R Y H U R S T STOR M K I N G S T A N D R E W S SE N N E N CV VIST A DR C R O O K E D S T I C K HUN T E R S G L E N PORT C H E S T E R BLACK BUTTE PEBB L E B E A C H BL A C K DI A M O N D C O U N T R Y C L U B B L V D O A K C T SCE N I C D R C Y P R E S S C T MIMOSA C T P E C A N C T ME R I O N WAY ST AND R E W S COLUMBIA BLACK B U T T E TAMAR O N FOX RUN GREENRIDGE G R A Y S O N C L I F F S M O K E Y P L A T T E IH 35 N A C C E S S R D IH 35 N A C C E S S R D TARRA N T HILL WHISP E R KNOL L CHEST N U T C T ELM C T CO V E R S C V GR E E N R I D G E B R O O K L I N E K N O L L W O O D IH 35 N CHARLES T O N FOXBRIA R L N WIMBLED O N D R 3 " P o l y V i n y l C h l o r i d e 8" P V C SDR 3 5 8" P V C S D R 3 5 8 " P V C S D R 3 5 8 " P o l y V i n y l C h l o r i d e 8" Poly Vinyl Chloride 8" P V C SD R 3 5 8 " P V C S D R 2 6 8 " P V C S D R 2 6 8" PVC S D R 2 6 8" PVC SDR 26 8" PVC SDR 35 8 " P V C S D R 3 5 8" P V C S D R 3 5 8" Poly V i n y l C h l o r i d e 8" PVCSDR 35 8" PVC S D R 3 5 8" P V C S D R 3 5 8" PVC SDR 3 5 8" PVC S D R 3 5 8" P V C S D R 3 5 8" P V C S D R 3 5 8" P V C SD R 3 5 8" PVC SDR 3 5 8" PVC S D R 3 5 8" P V C SD R 3 5 8" PVC SDR 35 8" P V C S D R 3 5 8" P V C SD R 3 5 8" PVC S D R 3 5 8 " P V C S D R 3 5 8 " P V C S D R 3 5 8" P V C S D R 3 5 8" PVC SDR 3 5 8" PVCSDR 35 8" PVC S D R 3 5 8" PVC SDR 26 8" PVCSDR 26 8 " P V C S D R 2 6 D - 2 2 4 1 8" P V C SDR 2 6 8" PVCSDR 26 8" P V C S D R 3 5 8" PVC SDR 3 5 8" PVCSDR 35 8" P V C S D R 3 5 8" PVC SDR 3 5 8" P V C S D R 3 5 8" PVC S D R 3 5 8" PVC S D R 3 5 8" P V CSDR 3 5 8" PVC S D R 2 6 8" PVC S D R 3 5 8" PVC SDR 26 8" PV CSDR 3 5 8 " P V C S D R 3 5 8" PVC S D R 3 5 8" Poly Vinyl Chlorid e 10" Pol y V i n y l C h l o r i d e 8 " P V C S D R 3 5 8" Poly Vinyl Chloride 8" P V C SD R 3 5 8" P V C S D R 3 5 8 " P V C S D R 3 5 8" PVC S D R 3 5 8 " P V C S D R 2 6 12" PV C S D R 3 5 8" PVC S D R 3 5 8" PVC SD R 3 5 8" Pol y V i n y l C h l o r i d e 8" Pol y V i n y l C h l o r i d e 10" P V C S D R 3 5 8 " P V C S D R 3 5 8 " P V C S D R 3 5 8 " P o l y V i n y l C h l o r i d e (250' R O W ) ' Freewa y ( I H 3 5 N ) (250' ROW)' F r e e w a y (IH 35 N ) (7 0 ' R O W ) ' R e s i d e n t i a l C o l l e c t o r ( C O U N T R Y C L U B B L V D ) Source: Esri, Maxar, GeoEye, Earthstar Geographics, CNES/Airbus DS, USDA, USGS, AeroGRID, IGN, and the GIS User Community41 Inch = 200 FeetTHE VILLAS ATBLUEBONNET RIDGE(PLPDD20220186)0 200 400 600 800100Feet <all other values> Freeway Principal Arterial Planned Principal Arterial Secondary Arterial Planned Secondary Arterial Secondary Rural Arterial Planned Secondary Rural Arterial Residential Collector Planned Residential Collector Commercial Collector B Planned Commercial Collector B Commercial Collector A Planned Commercial Collector A <all other values> Highways Major Roads Minor Roads Other Cities 1" 2" 3" 4" 6" 8" 10" 12" 16" 18" 20" 24" 30" 36" Schertz Gravity Schertz Pressure Neighboring Gravity Private Pressure 200' Buffer Schertz Municipal Boundary County Boundaries U Hydrant !P Manholes GUADALUPE COUNTY 34548 - COUNTRY CLUB BLVD34755 - 5301 COUNTRY CLUB BLVD34799 - 3522 FOXBRIAR LN34800 - 3521 WIMBLEDON DR34801 - 3517 WIMBLEDON DR40588 - 3628 ELM CT40589 - 3624 ELM CT40590 - 3620 ELM CT40591 - 3604 ELM CT40592 - 3601 ELM CT40593 - 3701 HUNTERS GLEN40594 - 3705 HUNTERS GLEN40595 - 3709 HUNTERS GLEN40596 - 3713 HUNTERS GLEN40597 - 3717 HUNTERS GLEN40598 - 3721 HUNTERS GLEN40599 - 3725 HUNTERS GLEN40600 - 3729 HUNTERS GLEN40601 - 3733 HUNTERS GLEN40602 - 3737 HUNTERS GLEN40603 - 3741 HUNTERS GLEN40604 - 3745 HUNTERS GLEN40605 - 3749 HUNTERS GLEN40606 - 3753 HUNTERS GLEN40607 - 3757 HUNTERS GLEN40608 - 3925 PECAN CT40609 - 3921 PECAN CT40610 - 3917 PECAN CT40611 - 3913 PECAN CT40612 - 3912 PECAN CT40613 - 3908 PECAN CT40614 - 3904 PECAN CT40615 - 3900 PECAN CT40616 - 4025 CYPRESS CT40617 - 4021 CYPRESS CT40618 - 4017 CYPRESS CT40619 - 4013 CYPRESS CT40620 - 4012 CYPRESS CT40621 - 4008 CYPRESS CT40622 - 4004 CYPRESS CT40623 - 4000 CYPRESS CT40625 - GREENRIDGE40626 - CHERRYHURST40627 - 3617 ELM CT40628 - 3613 ELM CT40629 - 3609 ELM CT40717 - 3748 HUNTERS GLEN40718 - 3744 HUNTERS GLEN40720 - 3740 HUNTERS GLEN40721 - 3736 HUNTERS GLEN40722 - 3732 HUNTERS GLEN40723 - 3728 HUNTERS GLEN40724 - 3724 HUNTERS GLEN40725 - 3720 HUNTERS GLEN40726 - 3716 HUNTERS GLEN40727 - 3712 HUNTERS GLEN40751 - GREENRIDGE63833 - COUNTRY CLUB BLVD63835 - 5301 COUNTRY CLUB BLVD63838 - COUNTRY CLUB BLVD115719 - 6117 PORTCHESTER115720 - 6113 PORTCHESTER115721 - 6109 PORTCHESTER115722 - 6105 PORTCHESTER115723 - 6101 PORTCHESTER115724 - 6100 PORTCHESTER115725 - 6104 PORTCHESTER115726 - 6108 PORTCHESTER116735 - 6113 MERION WAY116736 - 6109 MERION WAY116737 - 6105 MERION WAY116738 - 6101 MERION WAY116739 - 6100 MERION WAY116740 - 6104 MERION WAY116741 - 6108 MERION WAY116742 - 6112 MERION WAY117158 - 3683 PEBBLE BEACH117159 - 3679 PEBBLE BEACH117160 - 3675 PEBBLE BEACH117161 - 3669 PEBBLE BEACH117162 - 3672 PEBBLE BEACH117163 - 3674 PEBBLE BEACH117164 - 3678 PEBBLE BEACH117165 - 3684 PEBBLE BEACH117423 - 3700 COLUMBIA117424 - 5709 TUCKATOE117425 - 5705 TUCKATOE117426 - 5701 TUCKATOE117427 - 5700 TUCKATOE117428 - 5704 TUCKATOE117429 - 5708 TUCKATOE117430 - 5712 TUCKATOE117431 - 3714 COLUMBIA117432 - 3718 COLUMBIA117433 - 3722 COLUMBIA117434 - 3726 COLUMBIA117435 - 3730 COLUMBIA117436 - 5709 PELICAN HILLS117437 - 5705 PELICAN HILLS117438 - 5700 PELICAN HILLS117439 - 5704 PELICAN HLS COMAL COUNTY 75381 - 5301 COUNTRY CLUB BLVD108306 - 3807 PEBBLE BEACH108307 - 3811 PEBBLE BEACH108331 - 3808 PEBBLE BEACH121896 - 5301 COUNTRY CLUB BLVD121897 - 3779 COLUMBIA121907 - 3739 COLUMBIA121908 - 3735 COLUMBIA121909 - 3731 COLUMBIA121910 - 3727 COLUMBIA121911 - 3721 COLUMBIA121912 - 3717 COLUMBIA121913 - 3713 COLUMBIA121927 - 5704 PELICAN HLS121928 - 5708 PELICAN HILLS121929 - 5709 MAHOGANY BAY121930 - 5705 MAHOGANY BAY121931 - 5701 MAHOGANY BAY121932 - 5700 MAHOGANY BAY121933 - 5704 MAHOGANY BAY121934 - 5708 MAHOGANY BAY121935 - 3800 COLUMBIA121936 - 3804 COLUMBIA377261 - COLUMBIA 40 7 2 4 40 7 2 3 40 6 0 0 40 6 0 3 3 4 8 0 0 108306 40618 40614 40 6 2 6 40 7 2 0 34755 4075 1 4060 8 406 0 5 3 4 8 0 1 34799 108307 40 7 2 1 40 6 0 2 40 7 2 2 407 1 7 406 0 7 40609 4061 7 4 0 7 1 8 4072 6 40727 40611 40 6 0 1 40 7 2 5 406 0 4 40 5 9 8 40 5 9 9 406 0 6 40610 108331 117165 117164 11716 2 117 4 3 5 11 7 4 3 6 1 1 7 4 3 7 117434 11716 0 117 4 2 7 117158 117159 116735 1 2 1 9 3 5 121936 117438 1219 2 9 12193 4 121932 121933 116737 116736 1219 2 8 11 5 7 2 0 11 5 7 1 9 1 2 1 8 9 7 12190 7 121910 1 1 7 4 3 2 121908 1219 0 9 1 2 1 9 1 2 12 1 9 1 1 117425 11 7 4 3 3 11 5 7 2 6 117163 117424 1174 2 6 1174 2 8 1 2 1 9 1 3 117430 117429 11 5 7 2 1 115722 40615 40616 1157231 1 7 4 3 1 116 7 3 9 1167 4 0 116742 40621 40 5 9 0 4 0 6 1 2 63838 40613 115 7 2 4 1 1 5 7 2 5 4 0 5 9 1 40622 40 5 9 7 4 0 6 2 0 40592 40629 40 6 2 8 40 5 8 9 4 0 5 8 8 40 5 9 6 40623 40 6 2 7 40 5 9 3 40 5 9 4 40 5 9 5 4062534548 63835 121927 75381 117439 63833 377261 121896 11 7 4 2 3 1219 3 0 1 2 1 9 3 1 1 1 7 1 6 1 11673 8 116741 40619 PELICAN HILLS BEAVER CRK CHE R R Y H U R S T STANDREWS SE N N E N C V VISTA D R C R O O K E D S T I C K W HISTLINGSTRAITS H UNTERSGLEN MA H O G A N Y BA Y P O R T C H E S T E R G R A Y S O N C L I F F TU C K A T O E P E B B L E BEACH BL A C K D I A M O N D C O U N T R Y C L U B B L V D B L A C K B U T T E O A K C T C E D A R C T C Y P R E S S C T MIMOSA C T P E C A N C T ME R I O N W A Y S CENIC DR S M O K E Y P O I N TE IH 35 N TAMAR O N GRE E N R I D G E S M O K E Y P L A T T E C H E S T N U T C T E L M CT COLUMBIA B R O O K L I N E C O V E R S C V STOR M K I N G K N O L L W O O D CHARLES T O N FOXBRIA R L N WIMBLED O N D R Comal County Guadalup e County 4 0 400 800 1,200200 Fe e t City of Sche rtz T he V illas at Blue bonne t Ridg e(PLPDD20220186) Proje ct Are a 200' Buffe r County Boundarie s Last Update : Nove m be r 16, 2022 “T he City of Sche rtz provide s this Ge og raphic Inform ation Syste m product "as is" w ithout any e x pre ss or im plie dwarranty of any kind including but not lim ite d to the im plie d warrantie s of m e rchantability and fitne ss for a particular purpose .In no e ve nt shall T he City of Sche rtz be liable for any spe cial, indire ct or conse que ntial dam age s or any dam ag e s w hatsoe ve r arising out of or in conne ctionwith the use of or pe rform ance of the se m ate rials. Inform ation publishe d in this product could include te chnical inaccuracie s or typog raphical e rrors. Pe riodicalchang e s m ay be m ade and inform ation m ay be adde d to the inform ation he re in. T he City of Sche rtz m ay m ake im prove m e nts and/or chang e s in the product(s)de scribe d he re in at any tim e .” City of Sche rtz, GIS Spe cialist: Bill Gardne r, g is@sche rtz.com (210) 619-1185 January 24, 2023 Devin “Buck” Benson Spokesman for HABI, LLC 745 E Mulberry Avenue, Suite 550 San Antonio, Texas 78112 SUBJECT: SHCA support for PLPDD2022 -0186 Dear Buck: Per our previous discussions of the pending HABI development (PLPDD2022 -0186) in Schertz, TX, I am pleased to inform you that the Scenic Hills Community Association, Inc. Board of Directors and membership hereby asserts our support of this planned development. I am pleasantly encouraged by the willingness of your client (HABI, LLC) to engage in fruitful negotiations regarding this development and its effects on our community. I am proud to say that our community has collectively given our board the authority to grant our approval. Further, in my discussions with two other HOA presidents (Northcliffe and Fairways of Scenic Hills), I have been verbally advised that this project (PLPDD2022 -0186) has garnered their approval as well. We look forward to this addition to our neighborhood. Respectfully submitted, Gregory Sebold President, SHCA Board of Directors 4820 Scenic Drive, Schertz, TX 78108 ORDINANCE NO: 23-S-02 25 ACRE ZONE CHANGE FROM PRE-DEVELOPMENT (PRE) TO PLANNED DEVELOPMENT DISTRICT (PDD): THE VILLAS AT BLUEBONNET RIDGE City Council Meeting, April 25, 2023 EMILY DELGADO | PLANNING MANAGER CITY COUNCIL UPDAT E At the April 4, 2023 City Council meeting, the applicant requested for the item to be tabled so they could continue discussions with the residents. City Council unanimously approved to table the item to the April 25, 2023 City Council meeting. A s of the call of the March 7, 2023 City Council meeting the total percentage of the protested parcel acreage is 26.93%, therefore,the 3/4 vote has been triggered for the City Council. SUBJECT PROPERTY As of the call of the March 7, 2023 City Council meeting the total percentage of the protested parcel acreage is 26.93%, therefore,the 3/4 vote has been triggered for the City Council. SUBJECT PROPERTY PROPOSED PDD - The Villa’s at Bluebonnet Ridge The proposed rezone from Pre -Development District is to Planned Development District (PDD) with a base zoning of Townhome District (TH). The proposed development would consist of the following: Gated Community / HOA Maintained 51 buildings 6 buildings with 3 units 45 buildings with 4 units 198 Units Each unit will be its own townhome that could be sold separately Each unit will be between 1,300 square feet and 1,400 square feet 7.52 acres of green space and amenities THE VILLA’S AT BLUEBONNET RIDGE Each lot will have a 10 -foot side setback if on the end or a 0’ setback of in the interior. Proposed: 143 lots with a 25’ width and 55 lots with the 35’ width THE VILLA’S AT BLUEBONNET RIDGE Parks & Amenities: -7.52 acres of green space and amenities -Proposed to include: a pavilion, playground for the community, a concrete walking path, a mail center with covered pavilion and additional parking spaces, a 0.45 acre fenced in private dog park, a 1.85 -acre private picnic / trail / community garden area. A 0.30 of miscellaneous green spaces, and 4.01 acre of open space / easement. Fire Suppression and Fire Walls: -The PDD states the following: “Due to the reduced side yard setbacks, each townhome within the Villas as Bluebonnet Ridge will have fire sprinklers, will require all A/C condensers to be in the rear yard, and exterior walls will be at least a minimum of a 1 -hour fire rated.” THE VILLA’S AT BLUEBONNET RIDGE Additional Design Standards Proposed: -654 parking spaces proposed across the development -8’ masonry wall proposed along boundary with the Northcliffe neighborhood -20’ buffer in the rear yards adjacent to the Fairways at Scenic Hills, this 20’ buffer will include 1 tree in each yard and no structures, including sheds will be permitted CHANGES FROM PREVIOUS PDD PROPOSA L In 2022 the applicant submitted a zone change request for a PDD with a base zoning of Multi -family / Apartments (R -4). The original proposal was for 220 units that would be developed as fourplexes. On September 27, 2022 the application was denied by the City Council. During that meeting the City Council discussed concerns with the proposed density and discussed if the proposal was not apartments but instead townhomes. The new proposal decreases the maximum number of units to 198 and is a townhome product rather than apartments. This change was made based on feedback received at the City Council meeting. CHANGES FROM PREVIOUS PDD PROPOSAL On the application from 2022 it was noted that the applicant was working with the Parks Department in relation to a trail that is shown on the 2017 Schertz Transportation Plan -Trails Network. The proposed PDD indicated that the land would be dedication within the overhead utility easement to be utilized for a portion of the “Great Northern Trail”. The current proposal no longer accounts for or proposes the dedication or construction of the walking trail within the overhead electrical easement. At the January 10, 2023 City Council meeting there was a presentation in relation to trails, where City Council expressed their desire for trails within the City of Schertz and the importance of requiring trails to be constructed with developments. STAFF ANALYSI S The Schertz Sector Plan identifies the subject property as Single -Family Residential which encourages a mixture of residential housing types. The proposed PDD with the base zoning of Townhome would provide for a variety of housing types not currently in the area. Additionally, the change from apartment to townhome is in line with the discussion that occurred at the previous City Council meetings. The current proposal reduces the overall density from the previously proposed zone change. However, based on the City Council discussion on January 10th in relation to the trails, staff feels that the development should be required to dedicate and construct the trail per the 2017 Schertz Transportation Plan -Trails Network. RECOMMENDATION Staff Recommendation: Staff recommends approval of the proposed zone change (Ord. No. 23 -S -02) to Planned Development District (PDD) with a condition that per the 2017 Schertz Transportation Plan –Trails Network the proposed project would include the trail on all future exhibits and plans and construct the identified trail on the subject tract. Planning & Zoning Commission Recommendation: The Schertz Planning and Zoning Commission met on January 25, 2023 and voted to recommend that City Council approve the proposed zone change with a condition that the proposed project would include the trail on all future exhibits and plans by a 5 -2 vote with Chairman Outlaw and Commissioner McMaster with the nay votes. COMMENTS & QUESTIONS Agenda No. 3.   CITY COUNCIL MEMORANDUM    City Council Meeting:April 25, 2023 Department:Executive Team Subject:The City Council will meet in closed session in accordance with Section 551.072, Texas Government Code deliberation regarding the purchase, exchange, lease, or value of Real Properties for future roadways, roadway extensions, and roadway expansions; city facilities, drainage and detention; and general municipal uses. Agenda No. 4.   CITY COUNCIL MEMORANDUM    City Council Meeting:April 25, 2023 Department:Finance Subject:Quarterly Financial Reports - FY 2022-23 1st Quarter BACKGROUND Per the Public Funds Investment Act (PFIA) Section 2256.23 of the Government Code and Section IV Investment Reporting of the City's Adopted Investment Policy and Strategy, Investment Reports will be presented to the City Council no less than quarterly. Quarterly, Staff will submit to council unaudited financial reports as an update on the City's fiscal and budget performance. Some payments that must be recorded in this quarter can occur months after the close of the period. In those cases, staff attempts to estimate the value based on prior year's fiscal performance and current year trends. The Comprehensive Annual Financial Report to be published after the fiscal year-end will include actual revenue and expenses for the accounts estimated in the quarterly financial report. Attachments 1st Qtr Financial Report  1st Qtr Investment Report  CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET General Fund, 101 Total Revenues 44,982,410.00 15,637,771.81 (2,028.64)29,346,666.83 34.76% Total General Government 7,285,543.48 1,591,063.64 960,741.63 4,733,738.21 35.03% Total Public Safety 21,170,928.05 4,226,710.19 1,155,973.14 15,788,244.72 25.42% Total Public Environment 2,587,507.00 361,971.53 158,280.08 2,067,255.39 20.11% Total Parks & Recreation 3,359,965.78 513,831.08 331,376.89 2,514,757.81 25.16% Total Cultural 1,292,795.30 301,566.23 8,954.65 982,274.42 24.02% Total Internal Services 8,083,124.64 1,500,751.64 840,479.74 5,741,893.26 28.96% Total Misc & Projects 1,202,545.68 39,827.29 28,673.25 1,134,045.14 5.70% Total Expenditures 44,982,409.93 8,535,721.60 3,484,479.38 32,962,208.95 26.72% Revenue Over(Under) Expenditures 0.07 7,102,050.21 (3,486,508.02)(3,615,542.12) General Fund, 101 Total Cash in Bank & Investments 20,625,803.36 Special Events Fund, 106 Total Revenues 24,000.00 38,401.74 0.00 (14,401.74)160.01% Total Expenditures 24,000.00 14,667.58 1,500.00 7,832.42 67.36% Revenue Over(Under) Expenditures 0.00 23,734.16 (1,500.00)(22,234.16) Special Events Fund, 106 Total Cash in Bank & Investments 162,454.61 Peg Fund, 110 Total Revenues 944,770.00 15,162.38 0.00 929,607.62 1.60% Total Expenditures 914,770.00 105,072.95 502,435.63 307,261.42 66.41% Revenue Over(Under) Expenditures 30,000.00 (89,910.57)(502,435.63)622,346.20 Peg Fund, 110 Total Cash in Bank & Investments 776,417.31 Water & Sewer, 202 Total Revenues 28,485,858.00 7,801,663.69 0.00 20,684,194.31 27.39% Total Expenditures 26,826,740.63 4,599,189.91 1,773,576.49 20,453,974.23 23.76% Revenue Over(Under) Expenditures 1,659,117.37 3,202,473.78 (1,773,576.49)230,220.08 Water & Sewer, 202 Total Cash in Bank & Investments 10,677,822.95 EMS, 203 Total Revenues 11,982,981.82 3,076,706.85 (570.00)8,906,844.97 25.67% Total Expenditures 11,981,662.41 3,017,913.94 686,548.51 8,277,199.96 30.92% Revenue Over(Under) Expenditures 1,319.41 58,792.91 (687,118.51)629,645.01 EMS, 203 Total Cash in Bank & Investments 957,059.41 Quarterly Statement Schertz, Texas AS OF :December 31, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Drainage, 204 Total Revenues 1,450,073.00 326,536.17 0.00 1,123,536.83 22.52% Total Expenditures 1,439,807.00 308,278.35 28,452.67 1,103,075.98 23.39% Revenue Over(Under) Expenditures 10,266.00 18,257.82 (28,452.67)20,460.85 Drainage, 204 Total Cash in Bank & Investments 638,030.05 Hotel Tax, 314 Total Revenues 648,500.00 174,991.45 0.00 473,508.55 26.98% Total Expenditures 272,915.00 89,600.21 1,334.89 181,979.90 33.32% Revenue Over(Under) Expenditures 375,585.00 85,391.24 (1,334.89)291,528.65 Hotel Tax, 314 Total Cash in Bank & Investments 1,695,057.10 Park, 317 Total Revenues 319,025.00 2,472.02 0.00 316,552.98 0.77% Total Expenditures 125,000.00 0.00 0.00 125,000.00 0.00% Revenue Over(Under) Expenditures 194,025.00 2,472.02 0.00 191,552.98 Park, 317 Total Cash in Bank & Investments 263,994.07 Tree Mitigation, 319 Total Revenues 71,400.00 23,085.51 0.00 48,314.49 32.33% Total Expenditures 70,000.00 2,700.00 2,500.00 64,800.00 7.43% Revenue Over(Under) Expenditures 1,400.00 20,385.51 (2,500.00)(16,485.51) Tree Mitigation, 319 Total Cash in Bank & Investments 728,444.76 Capital Recovery Water, 411 Total Revenues 1,151,500.00 223,467.24 0.00 928,032.76 19.41% Total Expenditures 55,748.00 0.00 36,438.81 19,309.19 65.36% Revenue Over(Under) Expenditures 1,095,752.00 223,467.24 (36,438.81)908,723.57 Capital Recovery Water, 411 Total Cash in Bank & Investments 5,110,151.12 Capital Recovery Sewer, 421 Total Revenues 601,500.00 146,869.47 0.00 454,630.53 24.42% Total Expenditures 64,248.00 1,153.28 76,559.25 (13,464.53)120.96% Revenue Over(Under) Expenditures 537,252.00 145,716.19 (76,559.25)468,095.06 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,434,659.68 Quarterly Statement Schertz, Texas AS OF :December 31, 2022 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) ******************************** 2022 - 2023 ********************************* CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Roadway Impact Fee Area 1, 431 Total Revenues 343,373.00 58,675.35 0.00 284,697.65 17.09% Total Expenditures 93,173.00 52,425.50 52,425.49 (11,677.99)112.53% Revenue Over(Under) Expenditures 250,200.00 6,249.85 (52,425.49)296,375.64 Roadway Impact Fee Area 1, 431 Total Cash in Bank & Investments 812,220.78 Roadway Impact Fee Area 2, 432 Total Revenues 201,600.00 36,290.82 0.00 165,309.18 18.00% Total Expenditures 55,000.00 0.00 0.00 55,000.00 0.00% Revenue Over(Under) Expenditures 146,600.00 36,290.82 0.00 110,309.18 Roadway Impact Fee Area 2, 432 Total Cash in Bank & Investments 600,318.57 Roadway Impact Fee Area 3, 433 Total Revenues 380,050.00 96,251.77 0.00 283,798.23 25.33% Total Expenditures 5,000.00 0.00 0.00 5,000.00 0.00% Revenue Over(Under) Expenditures 375,050.00 96,251.77 0.00 278,798.23 Roadway Impact Fee Area 3, 433 Total Cash in Bank & Investments 1,279,553.01 Roadway Impact Fee Area 4, 434 Total Revenues 3,040.00 95.96 0.00 2,944.04 3.16% Total Expenditures 3,000.00 0.00 0.00 3,000.00 0.00% Revenue Over(Under) Expenditures 40.00 95.96 0.00 (55.96) Roadway Impact Fee Area 4, 434 Total Cash in Bank & Investments 6,149.15 I&S, 505 Total Revenues 8,686,248.00 4,042,358.69 0.00 4,643,889.31 46.54% Total Expenditures 8,686,248.00 800.00 200.00 8,685,248.00 0.01% Revenue Over(Under) Expenditures 0.00 4,041,558.69 (200.00)(4,041,358.69) I&S, 505 Total Cash in Bank & Investments 5,905,967.33 SED Corporation, 620 Total Revenues 10,050,960.00 1,845,507.77 0.00 8,205,452.23 18.36% Total Expenditures 10,050,960.00 371,089.49 17,493.50 9,662,377.01 3.87% Revenue Over(Under) Expenditures 0.00 1,474,418.28 (17,493.50)(1,456,924.78) SED Corporation, 620 Total Cash in Bank & Investments 26,467,812.28 Total Cash in Bank & Investments 83,141,915.54 Quarterly Statement Schertz, Texas AS OF :December 31, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES REVENUE SUMMARY Taxes 32,305,000.00 12,625,561.81 11,359,925.15 12,625,561.81 - 19,679,438.19 39.08 Franchises 2,550,000.00 603,933.57 561,441.05 603,933.57 - 1,946,066.43 23.68 Permits 1,717,800.00 370,354.33 308,416.32 370,354.33 - 1,347,445.67 21.56 Licenses 45,620.00 3,132.50 10,355.00 3,132.50 - 42,487.50 6.87 Fees 2,189,200.00 469,789.84 435,955.63 469,789.84 - 1,719,410.16 21.46 Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32 Inter-Jurisdictional 1,151,352.00 266,342.97 129,221.05 266,342.97 (2,028.64) 887,037.67 22.96 Fund Transfers 4,174,588.00 924,715.06 898,225.09 924,715.06 - 3,249,872.94 22.15 Miscellaneous 839,850.00 371,032.71 506,231.80 371,032.71 - 468,817.29 44.18 TOTAL REVENUES 44,982,410.00 15,637,771.81 14,212,041.77 15,637,771.81 (2,028.64) 29,346,666.83 34.76% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 41,750.00 8,228.64 10,191.30 8,228.64 14.40 33,506.96 19.74 Supplies 1,078.00 25.00 79.95 25.00 75.00 978.00 9.28 City Support Services 54,880.00 9,924.06 20,678.85 9,924.06 18,207.62 26,748.32 51.26 Operations Support 343.00 - - - - 343.00 0.00 Staff Support 31,899.00 5,705.81 10,364.77 5,705.81 200.15 25,993.04 18.51 Professional Services 3,920.00 - - - - 3,920.00 0.00 TOTAL CITY COUNCIL 133,870.00 23,883.51 41,314.87 23,883.51 18,497.17 91,489.32 31.66% CITY MANAGER Personnel Services 1,351,878.00 272,491.69 294,427.80 272,491.69 253.68 1,079,132.63 20.18 Supplies 1,470.00 155.87 320.43 155.87 94.81 1,219.32 17.05 City Support Services 1,960.00 360.00 - 360.00 - 1,600.00 18.37 Staff Support 24,349.08 1,472.99 5,540.17 1,472.99 1,861.76 21,014.33 13.70 Capital Outlay - - - - 44.50 (44.50) - TOTAL CITY MANAGER 1,379,657.08 274,480.55 300,288.40 274,480.55 2,254.75 1,102,921.78 20.06% MUNICIPAL COURT Personnel Services 329,472.00 86,049.44 87,895.72 86,049.44 99.92 243,322.64 26.15 Supplies 1,568.00 80.30 60.00 80.30 194.91 1,292.79 17.55 City Support Services 980.00 159.71 118.68 159.71 76.86 743.43 24.14 Operations Support 1,960.00 - - - - 1,960.00 - Staff Support 7,261.80 744.91 - 744.91 270.00 6,246.89 13.98 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 Court Support 980.00 282.00 132.00 282.00 210.00 488.00 50.20 Professional Services 65,954.00 12,669.50 10,300.00 12,669.50 41,750.00 11,534.50 82.51 Maintenance Services 8,526.00 300.00 450.00 300.00 3,450.00 4,776.00 43.98 Operating Equipment - - - - 179.99 (179.99) - TOTAL MUNICIPAL COURT 416,701.80 100,285.86 98,956.40 100,285.86 46,231.68 270,184.26 35.16% CUSTOMER RELATIONS-311 Personnel Services 120,518.00 30,989.08 31,784.61 30,989.08 39.45 89,489.47 25.75 Supplies 122.50 34.33 17.02 34.33 - 88.17 28.02 Staff Support 421.40 - 32.28 - - 421.40 - TOTAL CUSTOMER RELATIONS-311 121,061.90 31,023.41 31,833.91 31,023.41 39.45 89,999.04 25.66% PLANNING & ZONING Personnel Services 338,774.00 47,247.33 43,452.70 47,247.33 59.55 291,467.12 13.96 Supplies 1,979.60 150.67 240.86 150.67 (8.13) 1,837.06 7.20 City Support Services - - - - 1,166.00 (1,166.00) - Operations Support 243.04 - - - 62.00 181.04 25.51 Staff Support 34,584.20 2,130.12 1,334.70 2,130.12 120.00 32,334.08 6.51 Professional Services 196.00 (10.00) - (10.00) - 206.00 (5.10) Operating Equipment 318.50 - 285.47 - - 318.50 - TOTAL PLANNING & ZONING 376,095.34 49,518.12 45,313.73 49,518.12 1,399.42 325,177.80 13.54% LEGAL SERVICES Operations Support 9,800.00 577.75 - 577.75 - 9,222.25 5.90 Professional Services 127,400.00 8,754.25 4,050.50 8,754.25 2,863.46 115,782.29 9.12 TOTAL LEGAL SERVICES 137,200.00 9,332.00 4,050.50 9,332.00 2,863.46 125,004.54 8.89% CITY SECRETARY Personnel Services 213,949.00 53,084.49 55,155.27 53,084.49 30.01 160,834.50 24.83 Supplies 1,127.00 217.43 235.13 217.43 35.60 873.97 22.45 City Support Services 11,760.00 - 1,920.02 - - 11,760.00 - Operations Support 147.00 100.00 - 100.00 - 47.00 68.03 Staff Support 6,590.50 158.95 1,262.57 158.95 140.95 6,290.60 4.55 TOTAL CITY SECRETARY 233,573.50 53,560.87 58,572.99 53,560.87 206.56 179,806.07 23.02% NON-DEPARTMENTAL City Support Services 925,471.60 422,778.51 370,776.84 422,778.51 214,106.94 288,586.15 68.82 Operations Support 126,420.00 24,715.29 27,293.31 24,715.29 1,519.31 100,185.40 20.75 City Assistance 1,367,603.72 182,250.11 - 182,250.11 544,135.74 641,217.87 53.11 Professional Services 113,802.50 19,537.83 12,978.28 19,537.83 265.00 93,999.67 17.40 Fund Chrgs/Transfrs-Spec Events Fnd 27,756.54 146.72 - 146.72 - 27,609.82 0.53 TOTAL NON-DEPARTMENTAL 2,561,054.36 649,428.46 411,048.43 649,428.46 760,026.99 1,151,598.91 55.03% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 PUBLIC AFFAIRS Personnel Services 348,144.00 82,803.09 89,640.91 82,803.09 95.61 265,245.30 23.81 Supplies 1,078.00 355.98 351.61 355.98 68.93 653.09 39.42 City Support Services 490.00 - - - - 490.00 - Operations Support 47,971.90 2,121.67 6,903.71 2,121.67 - 45,850.23 4.42 Staff Support 7,840.00 147.00 423.32 147.00 2,477.01 5,215.99 33.47 Professional Services 256,760.00 69,389.50 87,408.00 69,389.50 12,482.54 174,887.96 31.89 Operating Equipment 200.00 192.28 - 192.28 - 7.72 96.14 TOTAL PUBLIC AFFAIRS 662,483.90 155,009.52 184,727.55 155,009.52 15,124.09 492,350.29 25.68% ENGINEERING Personnel Services 1,078,273.00 229,479.22 205,032.23 229,479.22 291.46 848,502.32 21.31 Supplies 1,715.00 483.31 163.09 483.31 - 1,231.69 28.18 Utility Services 7,938.00 1,151.30 581.00 1,151.30 - 6,786.70 14.50 Operations Support 147.00 - - - - 147.00 - Staff Support 15,650.60 439.01 75.00 439.01 365.76 14,845.83 5.14 Professional Services 49,000.00 12,988.50 9,293.05 12,988.50 27,962.50 8,049.00 83.57 Operating Equipment 11,122.00 - - - - 11,122.00 - TOTAL ENGINEERING 1,263,845.60 244,541.34 215,144.37 244,541.34 114,098.06 905,206.20 28.38% TOTAL GENERAL GOVERNMENT 7,285,543.48 1,591,063.64 1,391,251.15 1,591,063.64 960,741.63 4,733,738.21 35.03% PUBLIC SAFETY POLICE Personnel Services 9,599,285.00 2,260,339.58 2,391,077.39 2,260,339.58 2,469.80 7,336,475.62 23.57 Supplies 110,150.04 27,452.71 23,578.22 27,452.71 5,434.00 77,263.33 29.86 City Support Services 33,810.00 35,584.78 33,969.74 35,584.78 - (1,774.78) 105.25 Utility Services 302,232.00 31,668.93 27,462.19 31,668.93 732.64 269,830.43 10.72 Operations Support 16,836.40 - 821.80 - 935.00 15,901.40 5.55 Staff Support 267,954.20 20,079.31 26,164.16 20,079.31 27,458.98 220,415.91 17.74 City Assistance 65,170.00 10,014.05 8,952.04 10,014.05 6,686.18 48,469.77 25.63 Professional Services 79,309.44 20,121.59 21,656.91 20,121.59 7,041.66 52,146.19 34.25 Maintenance Services 78,404.90 5,904.30 5,207.50 5,904.30 - 72,500.60 7.53 Operating Equipment 408,115.10 1,211.52 25,351.86 1,211.52 49,641.69 357,261.89 12.46 Capital Outlay 759,439.00 - 5,390.00 - 625,893.41 133,545.59 82.42 TOTAL POLICE 11,720,706.08 2,412,376.77 2,569,631.81 2,412,376.77 726,293.36 8,582,035.95 26.78% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 FIRE RESCUE Personnel Services 6,410,107.00 1,401,153.12 1,527,987.52 1,401,153.12 1,110.15 5,007,843.73 21.88 Supplies 23,083.90 2,725.24 2,488.56 2,725.24 335.71 20,022.95 13.26 Utility Services 145,039.99 17,999.90 14,387.50 17,999.90 115.73 126,924.36 12.49 Operations Support 4,436.46 100.00 1,527.45 100.00 31.00 4,305.46 2.95 Staff Support 222,972.50 30,612.70 22,373.36 30,612.70 18,922.94 173,436.86 22.22 City Assistance 40,227.04 13,071.00 2,483.23 13,071.00 3,761.10 23,394.94 41.84 Professional Services 72,328.00 4,800.00 10,838.86 4,800.00 3,500.00 64,028.00 11.48 Maintenance Services 83,868.40 2,452.58 2,203.18 2,452.58 8,023.66 73,392.16 12.49 Other Costs 9,800.00 11,341.50 - 11,341.50 - (1,541.50) 115.73 Rental/Leasing 26,460.00 - - - - 26,460.00 - Operating Equipment 127,032.00 5,563.76 6,921.69 5,563.76 25,665.53 95,802.71 24.58 Capital Outlay 488,449.00 9,690.00 - 9,690.00 227,760.17 250,998.83 48.61 TOTAL FIRE RESCUE 7,653,804.29 1,499,509.80 1,591,211.35 1,499,509.80 289,225.99 5,865,068.50 23.37% INSPECTIONS Personnel Services 1,091,750.00 230,425.51 254,938.14 230,425.51 314.00 861,010.49 21.13 Supplies 4,998.00 164.48 93.00 164.48 77.72 4,755.80 4.85 Utility Services 8,232.00 1,071.46 1,198.25 1,071.46 - 7,160.54 13.02 Operations Support 833.00 31.00 - 31.00 62.00 740.00 11.16 Staff Support 45,496.50 1,396.80 2,347.44 1,396.80 643.84 43,455.86 4.49 Professional Services 68,600.00 - 600.00 - 61,100.00 7,500.00 89.07 Operating Equipment 7,637.00 - 570.94 - - 7,637.00 - Capital Outlay 43,750.00 - - - 76,121.44 (32,371.44) 173.99 TOTAL INSPECTIONS 1,271,296.50 233,089.25 259,747.77 233,089.25 138,319.00 899,888.25 29.21% NEIGHBORHOOD SERVICES Personnel Services 368,203.00 78,532.42 76,690.18 78,532.42 104.37 289,566.21 21.36 Supplies 8,914.12 149.55 814.51 149.55 286.06 8,478.51 4.89 Utility Services 8,624.00 866.82 480.00 866.82 - 7,757.18 10.05 Operations Support 3,350.62 31.00 - 31.00 - 3,319.62 0.93 Staff Support 29,060.94 1,750.12 891.59 1,750.12 1,744.36 25,566.46 12.02 Professional Services 2,450.00 - - - - 2,450.00 - Maintenance Services 24,700.00 404.46 1,950.00 404.46 - 24,295.54 1.64 Operating Equipment 3,818.50 - 285.47 - - 3,818.50 - TOTAL NEIGHBORHOOD SERVICES 525,121.18 81,734.37 81,111.75 81,734.37 2,134.79 441,252.02 15.97% TOTAL PUBLIC SAFETY 21,170,928.05 4,226,710.19 4,501,702.68 4,226,710.19 1,155,973.14 15,788,244.72 25.42% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 PUBLIC ENVIRONMENT STREETS Personnel Services 1,107,287.00 290,097.51 265,423.63 290,097.51 1,497.11 815,692.38 26.33 Supplies 178,850.00 13,192.18 16,723.52 13,192.18 14,356.90 151,300.92 15.40 City Support Services 5,880.00 564.62 411.45 564.62 901.14 4,414.24 24.93 Utility Services 196,000.00 40,287.78 31,994.77 40,287.78 - 155,712.22 20.55 Staff Support 22,050.00 3,813.81 1,571.78 3,813.81 2,503.78 15,732.41 28.65 Professional Services 30,380.00 - - - - 30,380.00 - Maintenance Services 725,790.00 502.40 2,591.00 502.40 - 725,287.60 0.07 Rental/Lease 4,900.00 848.23 - 848.23 - 4,051.77 17.31 Operating Equipment 6,370.00 12,665.00 2,386.15 12,665.00 - (6,295.00) 198.82 Capital Outlay 310,000.00 - - - 139,021.15 170,978.85 44.85 TOTAL STREETS 2,587,507.00 361,971.53 321,102.30 361,971.53 158,280.08 2,067,255.39 20.11% TOTAL PUBLIC ENVIRONMENT 2,587,507.00 361,971.53 321,102.30 361,971.53 158,280.08 2,067,255.39 20.11% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 975,812.00 210,521.83 191,576.24 210,521.83 262.77 765,027.40 21.60 Supplies 111,443.00 12,709.35 14,100.85 12,709.35 16,619.92 82,113.73 26.32 City Support Services 180,948.40 46,941.33 42,355.74 46,941.33 44,675.84 89,331.23 50.63 Utility Services 250,880.00 16,596.68 32,974.33 16,596.68 30,084.81 204,198.51 18.61 Operations Support 1,960.00 274.25 - 274.25 - 1,685.75 13.99 Staff Support 19,276.60 4,271.09 4,984.33 4,271.09 - 15,005.51 22.16 Professional Services 194,987.08 22,621.60 35,292.90 22,621.60 17,483.75 154,881.73 20.57 Maintenance Services 13,720.00 2,663.50 1,798.72 2,663.50 4,404.05 6,652.45 51.51 Rental/Leasing 9,800.00 1,176.05 1,041.72 1,176.05 1,500.00 7,123.95 27.31 Operating Equipment 72,715.00 2,425.00 8,049.36 2,425.00 12,891.06 57,398.94 21.06 Capital Outlay 480,615.00 15,538.98 - 15,538.98 162,530.19 302,545.83 37.05 TOTAL PARKS DEPARTMENT 2,312,157.08 335,739.66 332,174.19 335,739.66 290,452.39 1,685,965.03 27.08% SWIM POOL Supplies 24,990.00 21.15 - 21.15 1,261.24 23,707.61 5.13 Utility Services 16,170.00 2,573.46 2,571.43 2,573.46 - 13,596.54 15.92 Maintenance Services 539,664.00 72,120.46 97,339.35 72,120.46 36,060.23 431,483.31 20.05 TOTAL SWIM POOL 580,824.00 74,715.07 99,910.78 74,715.07 37,321.47 468,787.46 19.29% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 EVENT FACILITIES Personnel Services 380,583.00 92,150.09 74,759.05 92,150.09 121.03 288,311.88 24.24 Supplies 4,410.00 846.50 469.40 846.50 27.99 3,535.51 19.83 Utility Services 48,588.40 8,528.34 6,029.35 8,528.34 3,394.92 36,665.14 24.54 Operations Support 15,297.80 - 61.72 - - 15,297.80 - Staff Support 4,875.50 576.46 293.44 576.46 - 4,299.04 11.82 Maintenance Services 2,450.00 - 1,633.94 - - 2,450.00 - Operating Equipment 10,780.00 1,274.96 3,491.14 1,274.96 59.09 9,445.95 12.38 TOTAL EVENT FACILITIES 466,984.70 103,376.35 86,738.04 103,376.35 3,603.03 360,005.32 22.91% TOTAL PARKS & RECREATION 3,359,965.78 513,831.08 518,823.01 513,831.08 331,376.89 2,514,757.81 25.16% CULTURAL LIBRARY Personnel Services 993,719.00 238,520.99 251,406.38 238,520.99 219.09 754,978.92 24.02 Supplies 18,130.00 2,621.50 4,024.44 2,621.50 1,316.45 14,192.05 21.72 Utility Services 60,760.00 7,478.54 10,037.46 7,478.54 - 53,281.46 12.31 Operations Support 4,018.00 335.98 253.97 335.98 - 3,682.02 8.36 Staff Support 7,874.30 5,605.51 5,486.35 5,605.51 15.00 2,253.79 71.38 Professional Services 2,254.00 - 2,129.00 - - 2,254.00 - Operating Equipment 176,040.00 47,003.71 47,002.22 47,003.71 7,404.11 121,632.18 30.91 TOTAL LIBRARY 1,292,795.30 301,566.23 320,339.82 301,566.23 8,954.65 982,274.42 24.02% TOTAL CULTURAL 1,292,795.30 301,566.23 320,339.82 301,566.23 8,954.65 982,274.42 24.02% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 1,109,865.00 252,066.77 238,282.56 252,066.77 282.33 857,515.90 22.74 Supplies 8,624.00 457.36 1,328.37 457.36 485.07 7,681.57 10.93 City Support Services 1,128,273.66 113,449.44 171,915.69 113,449.44 94,093.29 920,730.93 18.39 Utility Services 342,896.18 72,202.25 52,288.92 72,202.25 206.95 270,486.98 21.12 Staff Support 87,333.80 4,898.93 1,056.78 4,898.93 11,105.60 71,329.27 18.33 Professional Services 25,970.00 - 1,406.25 - - 25,970.00 - Maintenance Services 14,700.00 546.85 269.90 546.85 - 14,153.15 3.72 Rental/Leasing 3,577.00 1,294.74 1,216.72 1,294.74 - 2,282.26 36.20 Operating Equipment 273,808.00 12,491.64 52,537.65 12,491.64 62,460.73 198,855.63 27.37 TOTAL INFORMATION TECHNOLOGY 3,063,097.64 457,407.98 520,302.84 457,407.98 202,180.47 2,403,509.19 21.53% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 HUMAN RESOURCES Personnel Services 510,089.00 120,584.01 100,281.02 120,584.01 144.03 389,360.96 23.67 Supplies 3,846.00 308.08 134.37 308.08 813.69 2,724.23 29.17 Human Services 173,558.00 34,994.66 38,049.10 34,994.66 59,176.31 79,387.03 54.26 Operations Support 22,390.00 2,023.73 1,949.84 2,023.73 625.11 19,741.16 11.83 Staff Support 38,367.00 13,248.59 13,680.01 13,248.59 8,177.67 16,940.74 55.85 City Assistance 14,700.00 2,049.00 4,855.00 2,049.00 4,920.00 7,731.00 47.41 Professional Services 4,900.00 - - - - 4,900.00 - Operating Equipment 490.00 - - - - 490.00 - TOTAL HUMAN RESOURCES 768,340.00 173,208.07 158,949.34 173,208.07 73,856.81 521,275.12 32.16% FINANCE Personnel Services 699,363.00 175,468.79 183,182.04 175,468.79 210.66 523,683.55 25.12 Supplies 2,646.00 663.83 726.83 663.83 817.71 1,164.46 55.99 Staff Support 4,263.00 486.99 240.00 486.99 39.24 3,736.77 12.34 Professional Sevices 48,216.00 871.01 7,908.09 871.01 - 47,344.99 1.81 Operating Equipment 980.00 - - - - 980.00 - TOTAL FINANCE 755,468.00 177,490.62 192,056.96 177,490.62 1,067.61 576,909.77 23.64% PURCHASING & ASSET MGT Personnel Services 268,812.00 69,139.30 66,560.09 69,139.30 65.89 199,606.81 25.74 Supplies 3,724.00 678.31 390.56 678.31 232.79 2,812.90 24.47 Operations Support 7,497.00 2,424.25 1,299.00 2,424.25 - 5,072.75 32.34 Staff Support 9,947.00 1,697.05 399.00 1,697.05 58.98 8,190.97 17.65 City Assistance 2,290.00 110.00 124.00 110.00 84.00 2,096.00 8.47 Operating Equipment 3,100.00 - - - 1,142.97 1,957.03 36.87 TOTAL PURCHASING & ASSET MGT 295,370.00 74,048.91 68,772.65 74,048.91 1,584.63 219,736.46 25.61% FLEET SERVICE Personnel Services 681,919.00 146,435.08 127,930.41 146,435.08 143.14 535,340.78 21.49 Supplies 211,680.00 33,833.16 29,992.53 33,833.16 34,594.44 143,252.40 32.33 City Support Services 13,720.00 - 2,404.34 - 102.50 13,617.50 0.75 Utility Services 11,760.00 1,561.21 1,109.01 1,561.21 39.00 10,159.79 13.61 Staff Support 37,240.00 4,476.24 512.50 4,476.24 1,854.76 30,909.00 17.00 Maintenance Services 227,360.00 47,268.39 38,782.94 47,268.39 34,732.46 145,359.15 36.07 Operating Equipment 13,720.00 580.22 5,007.38 580.22 1,065.99 12,073.79 12.00 Capital Outlay 46,875.00 - 394.87 - 94,256.40 (47,381.40) 201.08 TOTAL FLEET SERVICE 1,244,274.00 234,154.30 206,133.98 234,154.30 166,788.69 843,331.01 32.22% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 FACILITY SERVICES Personnel Services 879,776.00 222,525.27 206,977.44 222,525.27 257.35 656,993.38 25.32 Supplies 156,785.00 39,145.60 9,833.34 39,145.60 13,691.23 103,948.17 33.70 Utility Services 189,140.00 23,165.78 31,688.37 23,165.78 19,133.74 146,840.48 22.36 Staff Support 20,620.00 3,113.74 1,646.63 3,113.74 2,882.21 14,624.05 29.08 Professional Services 193,904.00 38,184.13 12,416.31 38,184.13 123,951.91 31,767.96 83.62 Maintenance Services 419,440.00 58,307.24 36,814.88 58,307.24 117,928.25 243,204.51 42.02 Rental/Leasing 490.00 - - - - 490.00 - Operating Equipment 3,920.00 - - - 658.00 3,262.00 16.79 Capital Outlay 92,500.00 - - - 116,498.84 (23,998.84) 125.94 TOTAL BUILDING MAINTENANCE 1,956,575.00 384,441.76 299,376.97 384,441.76 395,001.53 1,177,131.71 39.84% TOTAL INTERNAL SERVICE 8,083,124.64 1,500,751.64 1,445,592.74 1,500,751.64 840,479.74 5,741,893.26 28.96% MISC & PROJECTS Project Fund Charges/Transfers 850,000.00 - - - - 850,000.00 - TOTAL PROJECTS 850,000.00 - - - - 850,000.00 0.00% CITY ASSISTANCE City's Assistance to Agencies 326,012.68 37,619.75 49,458.75 37,619.75 23,893.25 264,499.68 18.87 Operating Equipment 13,793.00 2,207.54 - 2,207.54 2,280.00 9,305.46 32.53 TOTAL CITY ASSISTANCE 339,805.68 39,827.29 49,458.75 39,827.29 26,173.25 273,805.14 19.42% SEWER PROJECTS TOTAL SEWER PROJECTS - - - - - - 0.00% COURT - RESTRICTED FUNDS Operating Equipment 12,740.00 - - - 2,500.00 10,240.00 19.62 TOTAL COURT-RESTRICTED FUNDS 12,740.00 - - - 2,500.00 10,240.00 19.62% TOTAL MISC & PROJECTS 1,202,545.68 39,827.29 49,458.75 39,827.29 28,673.25 1,134,045.14 5.70% TOTAL EXPENDITURES 44,982,409.93 8,535,721.60 8,548,270.45 8,535,721.60 3,484,479.38 32,962,208.95 26.72% REVENUE OVER(UNDER) EXPEND.0.07 7,102,050.21 5,663,771.32 7,102,050.21 (3,486,508.02) (3,615,542.12) 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411100 Advalorem Tax-Current 17,965,000.00 9,235,312.50 8,443,209.42 9,235,312.50 - 8,729,687.50 51.41 000-411110 Disable Veterans Assist Pymnt 1,100,000.00 - - - - 1,100,000.00 - 000-411200 Advalorem Tax-Delinquent 50,000.00 93,109.16 14,754.88 93,109.16 - (43,109.16) 186.22 000-411300 Advalorem Tax-P&I 80,000.00 30,628.20 12,977.65 30,628.20 - 49,371.80 38.29 000-411500 Sales Tax Revenue-Gen Fund 13,040,000.00 3,243,209.95 2,870,801.58 3,243,209.95 - 9,796,790.05 24.87 000-411700 Mixed Beverage Tax 70,000.00 23,302.00 18,181.62 23,302.00 - 46,698.00 33.29 TOTAL Taxes 32,305,000.00 12,625,561.81 11,359,925.15 12,625,561.81 - 19,679,438.19 39.08% Franchises 000-421200 Center Point/Entex Energy 120,000.00 21,645.08 22,791.99 21,645.08 - 98,354.92 18.04 000-421220 City Public Service 1,200,000.00 291,226.83 243,299.04 291,226.83 - 908,773.17 24.27 000-421240 Guadalupe Valley Elec Co-op 475,000.00 99,059.28 109,454.20 99,059.28 - 375,940.72 20.85 000-421250 New Braunfels Utilities 80,000.00 20,303.18 15,731.04 20,303.18 - 59,696.82 25.38 000-421300 Time Warner-State Franchise 325,000.00 82,008.00 77,552.15 82,008.00 - 242,992.00 25.23 000-421460 AT&T Franchise Fee 75,000.00 8,363.43 21,637.80 8,363.43 - 66,636.57 11.15 000-421480 Other Telecom Franchise - ROW 100,000.00 35,508.55 27,885.25 35,508.55 - 64,491.45 35.51 000-421500 Solid Waste Franchise Fee 175,000.00 45,819.22 43,089.58 45,819.22 - 129,180.78 26.18 TOTAL Franchises 2,550,000.00 603,933.57 561,441.05 603,933.57 - 1,946,066.43 23.68% Permits 000-431100 Home Occupation Permit 550.00 105.00 175.00 105.00 - 445.00 19.09 000-431205 Bldg Permit-Residential 513,000.00 66,584.00 48,716.50 66,584.00 - 446,416.00 12.98 000-431210 Bldg Permit-Commercial 347,000.00 64,935.20 92,967.00 64,935.20 - 282,064.80 18.71 000-431215 Bldg Permit-General 328,000.00 62,990.00 56,896.00 62,990.00 - 265,010.00 19.20 000-431300 Mobile Home Permit - 25.00 25.00 25.00 - (25.00) - 000-431400 Signs Permit 5,500.00 976.00 644.00 976.00 - 4,524.00 17.75 000-431500 Food Establishmnt Permit 71,000.00 46,280.00 44,540.00 46,280.00 - 24,720.00 65.18 000-431700 Plumbing Permit 123,000.00 21,840.00 17,809.00 21,840.00 - 101,160.00 17.76 000-431750 Electrical Permit 70,000.00 17,440.00 10,600.00 17,440.00 - 52,560.00 24.91 000-431800 Mechanical Permit 60,000.00 10,640.00 7,800.00 10,640.00 - 49,360.00 17.73 000-431900 Solicitor/Peddler Permit 2,000.00 130.00 240.00 130.00 - 1,870.00 6.50 000-431950 Animal/Pet Permit 250.00 - - - - 250.00 - 000-432000 Cert of Occupancy Prmt 9,500.00 2,400.00 2,850.00 2,400.00 - 7,100.00 25.26 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-432100 Security Alarm Permit 43,000.00 4,161.00 6,995.00 4,161.00 - 38,839.00 9.68 000-432300 Grading/Clearing Permit 15,000.00 10,215.50 2,055.38 10,215.50 - 4,784.50 68.10 000-432400 Development Permit 100,000.00 54,754.63 12,231.44 54,754.63 - 45,245.37 54.75 000-435000 Fire Permit 30,000.00 6,878.00 3,872.00 6,878.00 - 23,122.00 22.93 TOTAL Permits 1,717,800.00 370,354.33 308,416.32 370,354.33 - 1,347,445.67 21.56% Licenses 000-441000 Alcohol Beverage License 8,500.00 3,052.50 2,585.00 3,052.50 - 5,447.50 35.91 000-441300 Mobile Home License 120.00 80.00 80.00 80.00 - 40.00 66.67 000-442000 Contractors License 37,000.00 - 7,690.00 - - 37,000.00 - TOTAL Licenses 45,620.00 3,132.50 10,355.00 3,132.50 - 42,487.50 6.87% Fees 000-451000 Municipal Court Fines 525,000.00 88,917.25 98,415.38 88,917.25 - 436,082.75 16.94 000-451010 Texas Motor Carrier Fines 30,000.00 - 11,744.00 - - 30,000.00 - 000-451015 CVE Out of Service 3,000.00 - 800.00 - - 3,000.00 000-451100 Arrest Fee 12,000.00 2,789.05 3,040.77 2,789.05 - 9,210.95 23.24 000-451200 Warrant Fees 53,000.00 9,209.34 12,404.37 9,209.34 - 43,790.66 17.38 000-451340 Judicial Fee-City 300.00 44.28 83.57 44.28 - 255.72 14.76 000-451400 Traffic Fine Costs TTL 6,000.00 1,218.05 1,317.04 1,218.05 - 4,781.95 20.30 000-451510 Juvenile Case Mgmt Fee 3,000.00 368.97 696.40 368.97 - 2,631.03 12.30 000-451520 Truancy Fees 14,000.00 2,923.16 2,978.62 2,923.16 - 11,076.84 20.88 000-451530 Local Municipal Jury Fund 150.00 57.34 57.50 57.34 - 92.66 38.23 000-451600 Technology Fund Fee 13,000.00 2,610.51 2,891.43 2,610.51 - 10,389.49 20.08 000-451700 Security Fee 15,000.00 3,045.56 3,261.95 3,045.56 - 11,954.44 20.30 000-451800 Time Payment Fee-City 4,000.00 881.00 1,004.61 881.00 - 3,119.00 22.03 000-451850 State Fines 10% Service Fee 15,000.00 6,466.11 5,436.72 6,466.11 - 8,533.89 43.11 000-451900 DPS Payment-Local 4,000.00 760.00 1,015.76 760.00 - 3,240.00 19.00 000-452000 Child Safety Fee 5,000.00 993.02 478.76 993.02 - 4,006.98 19.86 000-452100 Platting Fees 54,000.00 14,500.00 20,250.00 14,500.00 - 39,500.00 26.85 000-452200 Site Plan Fee 23,000.00 12,000.00 6,000.00 12,000.00 - 11,000.00 52.17 000-452300 Plan Check Fee 570,000.00 79,227.87 85,868.25 79,227.87 - 490,772.13 13.90 000-452320 Tree Mitigation Admin Fee 15,000.00 - 10,057.50 - - 15,000.00 - 000-452400 BOA/Variance Fees 2,500.00 500.00 1,500.00 500.00 - 2,000.00 20.00 000-452600 Specific Use/Zone Chng Fee 26,450.00 3,500.00 (2,500.00) 3,500.00 - 22,950.00 13.23 000-452710 Zoning Ltr & Dev Rights 2,550.00 900.00 1,500.00 900.00 - 1,650.00 35.29 000-453100 Reinspection Fees 190,000.00 53,325.00 49,525.00 53,325.00 - 136,675.00 28.07 000-453110 Swim Pool Inspection Fee 2,900.00 1,540.00 - 1,540.00 - 1,360.00 53.10 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-453200 Lot Abatement 6,700.00 1,520.00 1,700.00 1,520.00 - 5,180.00 22.69 000-453211 Admin Fee-Inspections 10,000.00 1,100.00 2,000.00 1,100.00 - 8,900.00 11.00 000-453710 Foster Care 500.00 - - - - 500.00 - 000-454200 Pool Gate Admission Fee 22,000.00 - - - - 22,000.00 - 000-454300 Seasonal Pool Pass Fee 4,000.00 - - - - 4,000.00 - 000-456110 Senior Center Memberships 16,000.00 3,178.00 252.00 3,178.00 - 12,822.00 19.86 000-456120 Senior Center Meal Fee 20,000.00 7,627.88 4,823.46 7,627.88 - 12,372.12 38.14 000-456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 - 000-456600 Fire Re-inspection Fee 700.00 100.00 - 100.00 - 600.00 14.29 000-458000 Sale of General Fixed Assets - - 37,572.00 - - - - 000-458110 Sale of Mdse - GovDeals 100,000.00 30,951.45 1,416.00 30,951.45 - 69,048.55 30.95 000-458400 Civic Center Rental Fees 225,000.00 83,702.50 46,013.25 83,702.50 - 141,297.50 37.20 000-458401 Capital Recovery Fee-Civic C - 1,850.00 (600.00) 1,850.00 - (1,850.00) - 000-458402 Civic Center Ancillary Fees - 910.00 250.00 910.00 - (910.00) - 000-458450 North Center Rental Fees 28,000.00 15,300.00 6,956.25 14,925.00 - 13,075.00 53.30 000-458460 Senior Center Rental 7,000.00 1,400.00 - 1,400.00 - 5,600.00 20.00 000-458500 Community Center Rental Fees 40,000.00 22,189.50 12,119.25 22,189.50 - 17,810.50 55.47 000-458501 Community Center Service Fees - - 200.00 - - - - 000-458510 Grand Ballroom Rental Fees - (1,800.00) (18,250.00) (1,800.00) - 1,800.00 - 000-458520 Cut-Off Hall Rental Fees - - 600.00 - - - - 000-458540 Bluebonnet Hall Rental Fees - (900.00) (1,525.00) (900.00) - 900.00 - 000-458550 Pavilion Rental Fees 25,000.00 3,530.00 3,482.50 3,305.00 - 21,695.00 13.22 000-458560 Chamber of Comm Rent 7,800.00 - 1,950.00 - - 7,800.00 - 000-458570 Non-Resident SYSA League 10,000.00 - - - - 10,000.00 - 000-458590 Cancellation Fees-Event Rental 1,500.00 950.00 350.00 950.00 - 550.00 63.33 000-458650 NonResident User Fee-BVYA - 2,540.00 3,530.00 2,540.00 - (2,540.00) - 000-458660 BVYA Utility Reimbursement 15,000.00 6.00 3,912.00 6.00 - 14,994.00 0.04 000-458670 SYSA Utility Reimbursement 7,500.00 - 2,616.29 - - 7,500.00 - 000-458675 Lions Futbol Utility Reimbrsmt 15,000.00 - - - - 15,000.00 - 000-458685 Recreation Programs 1,000.00 - - - - 1,000.00 - 000-458685.001Rec Prgrm-Kickball Leagues 2,600.00 - - - - 2,600.00 - 000-458700 Vehicle Impoundment - 2,970.00 3,380.00 2,970.00 - (2,970.00) - 000-459300 Notary Fee 50.00 18.00 6.00 18.00 - 32.00 36.00 000-459600 Animal Adoption Fee 12,000.00 4,250.00 2,185.00 4,250.00 - 7,750.00 35.42 000-459700 Pet Impoundment Fee 13,000.00 2,457.00 2,188.00 2,457.00 - 10,543.00 18.90 000-459800 Police Reports Fee 5,000.00 1,288.00 1,001.00 1,288.00 - 3,712.00 25.76 TOTAL Fees 2,189,200.00 470,914.84 435,955.63 470,314.84 - 1,718,885.16 21.48% 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Fines 000-463000 Library Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32 TOTAL Fines 9,000.00 2,909.02 2,270.68 2,909.02 - 6,090.98 32.32% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,077.00 - 5,269.44 - - 21,077.00 - 000-473200 City of Seguin-Fire Contract 30,107.00 11,742.18 5,575.52 11,742.18 (2,028.64) 20,393.46 32.26 000-473300 Guadalupe Co-Library 220,000.00 54,288.00 - 54,288.00 - 165,712.00 24.68 000-474200 Library Services-Cibolo 40,000.00 - - - - 40,000.00 - 000-474210 Library Services-Selma 25,000.00 - - - - 25,000.00 - 000-474400 Dispatch Service-Cibolo 160,000.00 - - - - 160,000.00 - 000-474600 School Crossing Guard-Bexar Co 36,000.00 9,841.12 9,284.88 9,841.12 - 26,158.88 27.34 000-474610 School Cross Guard-Guadalupe C 41,000.00 10,732.17 10,963.21 10,732.17 - 30,267.83 26.18 000-474620 School Crossing Guards - Comal 1,900.00 - - - - 1,900.00 - 000-474700 School Officer Funding 551,268.00 179,739.50 91,878.00 179,739.50 - 371,528.50 32.60 000-474750 Crime Victim Liaison Agreement 25,000.00 - 6,250.00 - - 25,000.00 - TOTAL Inter-Jurisdictional 1,151,352.00 266,342.97 129,221.05 266,342.97 (2,028.64) 887,037.67 22.96% Fund Transfers 000-480000 Indirect Costs-EMS 216,994.00 54,248.53 53,185.03 54,248.53 - 162,745.47 25.00 000-480100 Indirect Costs-Hotel/Motel 69,915.00 17,478.75 18,610.78 17,478.75 - 52,436.25 25.00 000-481000 Transfer In - Reserves 1,052,715.00 - - - - 1,052,715.00 - 000-485000 Interfund Charges-Drainage-5%320,073.00 80,018.25 77,002.50 80,018.25 - 240,054.75 25.00 000-486000 Interfund Chrges-Admin W&S 1,493,620.00 373,405.03 369,557.53 373,405.03 - 1,120,214.97 25.00 000-486202 Transfer In-Water&Sewer Fund 4,000.00 - - - - 4,000.00 - 000-486203 Transfer In-EMS 4,000.00 - - - - 4,000.00 - 000-486204 Transfer In-Drainage 1,000.00 - - - - 1,000.00 - 000-487000 Interfund Charges-Fleet 470,050.00 128,454.00 126,377.25 128,454.00 - 341,596.00 27.33 000-488000 Interfund Charges-4B 542,221.00 271,110.50 253,492.00 271,110.50 - 271,110.50 50.00 TOTAL Fund Transfers 4,174,588.00 924,715.06 898,225.09 924,715.06 - 3,249,872.94 22.15% Miscellaneous 000-491000 Interest Earned 25,000.00 32,001.04 1,843.81 32,001.04 - (7,001.04) 128.00 000-491200 Investment Income 150,000.00 108,241.72 9,839.82 117,650.02 - 32,349.98 78.43 000-491900 Unrealized Gain/Loss-CapOne - (3,074.71) (13,105.39) (3,074.71) - 3,074.71 - 000-493120 Donations-Public Library 10,000.00 365.06 536.71 365.06 - 9,634.94 3.65 000-493400 Donations-Animal Control 5,000.00 865.00 1,087.00 865.00 - 4,135.00 17.30 000-493465 Donations-Senior Center 10,000.00 1,562.05 1,497.00 1,562.05 - 8,437.95 15.62 000-493503 Donation-Fire Rescue 1,000.00 150.00 - 150.00 - 850.00 15.00 101 GENERAL FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 000-493618 Donation - Veteran's Memorial 1,250.00 525.00 1,050.00 525.00 - 725.00 42.00 000-493700 July 4th Activities 26,000.00 - - - - 26,000.00 - 000-493701 Proceeds-Holidazzle 12,500.00 10,120.00 14,500.00 10,070.00 - 2,430.00 80.56 000-493704 Moving on Main 4,000.00 - - - - 4,000.00 - 000-493707 Cornhole League 2,000.00 - - - - 2,000.00 - 000-494481 LawEnforcemtOfficersStnd&5,000.00 - - - - 5,000.00 - 000-495100 Mobile Stage Rental Fees - 1,550.00 - 1,550.00 - (1,550.00) - 000-497000 Misc Income-Gen Fund 60,000.00 8,438.66 7,746.02 8,438.66 - 51,561.34 14.06 000-497005 Schertz Magazine Advertising 145,000.00 32,918.75 34,852.50 32,918.75 - 112,081.25 22.70 000-497100 Misc Income-Police 9,000.00 1,805.00 1,646.11 1,805.00 - 7,195.00 20.06 000-497200 Misc Income-Library 3,000.00 1,352.75 650.00 1,352.75 - 1,647.25 45.09 000-497210 Misc Income-Library Copier 14,000.00 3,793.10 3,271.60 3,793.10 - 10,206.90 27.09 000-497300 Misc Income-Animal Control 500.00 630.00 - 630.00 - (130.00) 126.00 000-497400 Misc Income-Streets Dept 50,000.00 10,975.12 10,355.83 10,975.12 - 39,024.88 21.95 000-497500 Misc Income-TML Ins. Claims 25,000.00 15,068.47 830.26 15,068.47 - 9,931.53 60.27 000-497550 Misc Income-TML WC Reimbursmnt 10,000.00 155.01 22,201.62 155.01 - 9,844.99 1.55 000-497600 Misc Income-Vending Mach 1,600.00 411.60 493.60 411.60 - 1,188.40 25.73 000-497610 Misc Income-Muni Court - - 1.80 - - - - 000-498000 Reimbursmnt-Gen Fund 20,000.00 - - - - 20,000.00 - 000-498105 Reimbursmt Police OT-DEA 35,000.00 3,781.29 7,532.01 3,781.29 - 31,218.71 10.80 000-498110 Reimburmnt Fire-Emg Acti-OT 200,000.00 130,039.50 399,401.39 130,039.50 - 69,960.50 65.02 000-498150 Reimbursement - Library 7,000.00 - - - - 7,000.00 - TOTAL Miscellaneous 839,850.00 361,674.41 506,231.80 371,032.71 - 468,817.29 44.18% TOTAL REVENUES 44,982,410.00 15,629,538.51 14,212,041.77 15,638,296.81 (2,028.64) 29,346,141.83 34.76% Cash in Bank Claim on Operating Cash Pool-Checking 4,198,271.05$ Cash in Investments LOGIC Investment-General Fund 13,089,489.07 LOGIC Investment-Equip Replacement 80,488.14 LOGIC Investment-Veh Replacement 542,714.26 LOGIC Investment-Air Condi Replacment 295,349.34 CAPITAL ONE Investment-General Fund 1,405,625.92 CD - Bank of New York 253,122.82 CD - Capital One MCLEAN 253,580.92 CD - Capital One ALLEN 253,580.92 CD - Goldman Sachs 253,580.92 Total Cash in Bank & Investments 20,625,803.36$ GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2022-23 1,012,285 1,191,635 1,032,144 2021-22 1,004,614 1,103,814 826,933 926,859 1,104,306 840,622 803,436 1,090,848 969,440 953,702 1,215,909 1,063,576 2020-21 743,235 894,399 769,523 766,917 1,051,843 776,582 652,217 1,039,235 878,852 881,389 1,342,856 917,603 2019-20 669,061 809,661 729,135 656,810 908,377 953,913 662,240 840,330 708,822 765,963 880,492 847,850 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Sales Tax-General Fund AS OF: March 31, 2020 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2022-23 103,252 1,096,390 8,035,670 2021-22 64,306 790,610 7,588,294 4,069,380 2,505,204 168,170 49,143 82,010 177,339 32,660 40,812 21,138 2020-21 67,176 970,388 6,869,022 3,995,189 2,086,758 244,347 76,381 71,700 174,542 42,752 33,745 130,219 2019-20 181,122 806,033 6,755,473 4,432,940 1,463,522 101,212 72,046 56,463 88,055 48,550 20,479 76,361 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 9,000,000 ADVALOREM TAX Updated report at 5/12/2020 by Maya AS OF: March 31, 2020 NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2022-23 291,227 2021-22 304,524 241,989 261,111 258,456 2020-21 233,351 231,254 273,749 297,978 2019-20 240,156 192,246 261,394 286,756 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 CITY PUBLIC SERVICE 2022-23 2021-22 2020-21 2019-20 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Miscellaneous 24,000.00 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40 TOTAL REVENUES 24,000.00 38,401.74 35,628.89 38,401.74 - (14,401.74) 160.01% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL KICK CANCER 10,000.00 - - - - 10,000.00 - HAL BALDWIN SCHOLARSHIP 14,000.00 14,667.58 14,706.88 14,667.58 1,500.00 (2,167.58) 115.48 TOTAL CULTURAL 24,000.00 14,667.58 14,706.88 14,667.58 1,500.00 7,832.42 67.36% TOTAL EXPENDITURES 24,000.00 14,667.58 14,706.88 14,667.58 1,500.00 7,832.42 67.36% REVENUE OVER(UNDER) EXPEND - 23,734.16 20,922.01 23,734.16 (1,500.00) (22,234.16) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 C I T Y O F S C H E R T Z 106-SPECIAL EVENTS FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Miscellaneous 000-491200 INVESTMENT INCOME - 175.02 2.55 175.02 - (175.02) - 000-492200 KICK CANCER 10,000.00 - - - - 10,000.00 - 000-493621 HAL BALDWIN SCHOLARSHIP 14,000.00 38,080.00 35,626.34 38,080.00 - (24,080.00) 272.00 TOTAL MISCELLANEOUS 24,000.00 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40% TOTAL REVENUES 24,000.00 38,255.02 35,628.89 38,255.02 - (14,255.02) 159.40% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 C I T Y O F S C H E R T Z Cash in Bank Current Claim on Operating Cash Pool-Checking 144,084.05$ Cash in Investments Texas Class- Special Events 18,370.56 Total Cash in Bank & Investments 162,454.61$ SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 90,000.00 15,162.38 20,581.45 15,162.38 - 74,837.62 16.85 Fund Transfers 854,770.00 - - - - 854,770.00 - TOTAL REVENUES 944,770.00 15,162.38 20,581.45 15,162.38 - 929,607.62 1.60% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay 854,770.00 105,072.95 - 105,072.95 502,435.63 247,261.42 71.07 TOTAL MISC & PROJECTS 914,770.00 105,072.95 - 105,072.95 502,435.63 307,261.42 66.41% TOTAL EXPENDITURES 914,770.00 105,072.95 - 105,072.95 502,435.63 307,261.42 66.41% REVENUE OVER(UNDER) EXPEND 30,000.00 (89,910.57) 20,581.45 (89,910.57) (502,435.63) 622,346.20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 110-PEG FUND CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421350 Time Warner - PEG Fee 60,000.00 15,162.38 16,022.29 15,162.38 - 44,837.62 25.27 000-421465 AT&T PEG Fee 30,000.00 - 4,559.16 - - 30,000.00 - TOTAL Franchises 90,000.00 15,162.38 20,581.45 15,162.38 - 74,837.62 16.85% Fund Transfers 000-481000 Transfer In - Reserves 854,770.00 - - - - 854,770.00 - TOTAL Fund Transfers 854,770.00 - - - - 854,770.00 0.00% Miscellaneous TOTAL REVENUES 944,770.00 15,162.38 20,581.45 15,162.38 - 929,607.62 1.60% AS OF: December 31, 2022 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) Cash in Bank Cash Balance 776,417.31$ Total Cash in Bank & Investments 776,417.31$ PEG FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13 Fees 27,487,000.00 7,583,908.83 6,874,051.64 7,583,908.83 - 19,903,091.17 27.59 Fund Transfers 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00 Miscellaneous 448,858.00 175,733.17 91,132.78 175,733.17 - 273,124.83 39.15 TOTAL REVENUES 28,485,858.00 7,801,663.69 7,056,962.75 7,801,663.69 - 20,684,194.31 27.39% EXPENDITURE SUMMARY NON DEPARTMENTAL TOTAL NON DEPARTMENTAL - - - - - - 0.00% BUSINESS OFFICE Personnel Services 568,896.00 128,924.23 144,719.06 128,924.23 188.12 439,783.65 22.70 Supplies 213,090.63 641.62 4,542.78 641.62 571.30 211,877.71 0.57 City Support Services 67,300.00 41,238.36 36,064.69 41,238.36 9,460.00 16,601.64 75.33 Utility Services 11,500.00 1,128.73 1,769.26 1,128.73 - 10,371.27 9.82 Operations Support 120,000.00 20,404.44 24,183.10 20,404.44 92,645.71 6,949.85 94.21 Staff Support 8,700.00 1,151.68 1,190.61 1,151.68 1,430.09 6,118.23 29.68 Professional Services 273,000.00 41,943.69 55,924.18 41,943.69 - 231,056.31 15.36 Maintenance Services 18,700.00 - 1,260.00 - 420.00 18,280.00 2.25 Operating Equipment 600.00 - - - - 600.00 - TOTAL BUSINESS OFFICE 1,281,786.63 235,432.75 269,653.68 235,432.75 104,759.72 941,594.16 26.54% W & S ADMINISTRATION Personnel Services 2,027,484.00 424,941.79 441,870.42 424,941.79 522.22 1,602,019.99 20.98 Supplies 63,000.00 10,615.16 3,456.85 10,615.16 5,575.76 46,809.08 25.70 City Support Services 190,500.00 86,514.49 71,050.71 86,514.49 1,165.02 102,820.49 46.03 Utility Services 3,585,500.00 827,068.86 761,107.02 827,068.86 139.85 2,758,291.29 23.07 Operations Support 10,050.00 1,152.01 1,509.34 1,152.01 - 8,897.99 11.46 Staff Support 43,000.00 4,427.06 3,290.81 4,427.06 2,096.84 36,476.10 15.17 Professional Services 428,400.00 43,693.90 67,546.77 43,693.90 85,656.30 299,049.80 30.19 Fund Charges/Transfers 6,746,368.00 1,278,999.47 1,997,427.13 1,278,999.47 - 5,467,368.53 18.96 Maintenance Services 9,570,200.00 1,125,597.64 1,896,183.30 1,125,597.64 1,083,007.69 7,361,594.67 23.08 Other Costs 40,000.00 36,605.45 36,605.45 36,605.45 - 3,394.55 91.51 Debt Service 2,499,777.00 - - - - 2,499,777.00 - Rental/Leasing 72,275.00 626.56 26,076.94 626.56 19,775.05 51,873.39 28.23 Operating Equipment 7,000.00 4,327.64 485.54 4,327.64 137.39 2,534.97 63.79 Capital Outlay 261,400.00 193,006.13 32,158.31 193,006.13 462,771.65 (394,377.78) 250.87 TOTAL PUBLIC WORKS 25,544,954.00 4,037,576.16 5,338,808.59 4,037,576.16 1,660,847.77 19,846,530.07 22.31% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 MISC & PROJECTS PROJECTS Professional Services - - - - 3,469.00 (3,469.00) - Fund Charges/Transfers - 326,181.00 - 326,181.00 - (326,181.00) - Maintenance Services - - - - 4,500.00 (4,500.00) - TOTAL PROJECTS - 326,181.00 - 326,181.00 7,969.00 (334,150.00) 0.00% SEWER PROJECT TOTAL SEWER PROJECTS - - - - - - 0.00% TOTAL MISC & PROJECTS - 326,181.00 - 326,181.00 7,969.00 (334,150.00) 0.00% TOTAL EXPENDITURES 26,826,740.63 4,599,189.91 5,608,462.27 4,599,189.91 1,773,576.49 20,453,974.23 23.76% ** REVENUE OVER(UNDER)EXPENSES **1,659,117.37 3,202,473.78 1,448,500.48 3,202,473.78 (1,773,576.49) 230,220.08 202-WATER & SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Franchises 000-421490 Cell Tower Leasing 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13 TOTAL Franchises 400,000.00 4,521.69 54,278.33 4,521.69 - 395,478.31 1.13% Permits TOTAL Permits - - - - - - 0.00% Fees 000-455200 Garbage Collection Fee 5,300,000.00 1,477,217.75 1,368,976.75 1,477,217.75 - 3,822,782.25 27.87 000-455600 Fire Line Fees 22,000.00 - - - - 22,000.00 - 000-455700 Recycle Fee Revenue 340,000.00 87,196.79 86,200.63 87,196.79 - 252,803.21 25.65 000-455800 W&S Line Constructn Reimbur 25,000.00 610.00 2,797.00 610.00 - 24,390.00 2.44 000-457100 Sale of Water 12,600,000.00 3,561,877.37 3,047,494.41 3,561,877.37 - 9,038,122.63 28.27 000-457110 Edwards Water Lease 40,000.00 - - - - 40,000.00 - 000-457120 Water Transfer Charge-Selma 15,000.00 - - - - 15,000.00 - 000-457200 Sale of Meters 100,000.00 19,448.77 12,174.55 19,448.77 - 80,551.23 19.45 000-457400 Sewer Charges 8,800,000.00 2,353,485.34 2,282,719.30 2,353,485.34 - 6,446,514.66 26.74 000-457500 Water Penalties 240,000.00 83,622.81 73,064.00 83,622.81 - 156,377.19 34.84 000-458110 Sale of Merchandise - GovDeals 2500.00 - - - - 2,500.00 - 000-459200 NSF Check Fee-Water&Sewer 2,500.00 450.00 625.00 450.00 - 2,050.00 18.00 TOTAL Fees 27,487,000.00 7,583,908.83 6,874,051.64 7,583,908.83 - 19,903,091.17 27.59% Fund Transfers 000-486204 Interfnd Chrg-Drainage Billing 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00 TOTAL Fund Transfers 150,000.00 37,500.00 37,500.00 37,500.00 - 112,500.00 25.00% Miscellaneous 000-490000 Misc Charges 10,500.00 2,681.00 2,963.00 2,681.00 - 7,819.00 25.53 000-491000 Interest Earned 25,000.00 4,386.38 2,842.49 4,386.38 - 20,613.62 17.55 000-491200 Investment Income 100,000.00 82,998.21 996.71 82,998.21 - 17,001.79 83.00 000-497000 Misc Income-W&S 18,000.00 8,003.82 1,008.30 8,003.82 - 9,996.18 44.47 000-498110 Salary Reimb-SSLGC 295,358.00 77,663.76 83,322.29 77,663.76 - 217,694.24 26.29 000-499100 Distribution-GSE Bond Set - - (0.01) - - - - TOTAL Miscellaneous 448,858.00 175,733.17 91,132.78 175,733.17 - 273,124.83 39.15% TOTAL REVENUES 28,485,858.00 7,801,663.69 7,056,962.75 7,801,663.69 - 20,684,194.31 27.39% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 81,485.32$ Cash in Investments Lone Star Investment-Water&Sewer 8,622,710.93 Lone Star Investment-W&S Customer Deposits 323,362.66 Lone Star Investment-W&S Equip Replacement 194,420.88 Lone Star Investment-W&S Veh Replacement 280,858.58 Schertz Bank & Trust-Certificate of Deposit 1,174,984.58 10,596,337.63$ Total Cash in Bank & Investments 10,677,822.95$ WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 7,605,302.40 2,042,198.63 1,881,021.49 2,042,198.63 (570.00) 5,563,673.77 26.84 Inter-Jurisdictional 3,978,179.42 981,329.00 1,248,298.49 981,329.00 - 2,996,850.42 24.67 Fund Transfers 262,000.00 - - - - 262,000.00 - Miscellaneous 137,500.00 53,179.22 117,834.63 53,179.22 - 84,320.78 38.68 TOTAL REVENUES 11,982,981.82 3,076,706.85 3,247,154.61 3,076,706.85 (570.00) 8,906,844.97 25.67% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 6,238,590.00 1,574,533.63 1,577,796.38 1,574,533.63 1,363.60 4,662,692.77 25.26 Supplies 398,525.00 149,830.41 148,141.02 149,830.41 73,386.39 175,308.20 56.01 City Support Services 160,000.00 47,893.78 44,047.12 47,893.78 - 112,106.22 29.93 Utility Services 176,000.00 32,829.37 24,793.11 32,829.37 192.39 142,978.24 18.76 Operations Support 31,500.00 8,295.16 9,520.21 8,295.16 400.00 22,804.84 27.60 Staff Support 88,000.00 28,174.41 26,936.05 28,174.41 13,685.83 46,139.76 47.57 City Assistance 624,989.01 154,789.25 103,517.48 154,789.25 199.00 470,000.76 24.80 Professional Services 125,500.00 33,521.40 63,487.22 33,521.40 39,000.01 52,978.59 57.79 Fund Charges/Transfers 3,145,058.40 918,226.02 818,182.50 918,226.02 - 2,226,832.38 29.20 Maintenance Services 13,000.00 840.00 960.00 840.00 - 12,160.00 6.46 Rental/Leasing 150,000.00 - - - - 150,000.00 - Operating Equipment 120,500.00 12,078.66 4,909.78 12,078.66 23,177.08 85,244.26 29.26 Capital Outlay 710,000.00 56,901.85 517,571.78 56,901.85 535,144.21 117,953.94 83.39 TOTAL PUBLIC SAFETY 11,981,662.41 3,017,913.94 3,339,862.65 3,017,913.94 686,548.51 8,277,199.96 30.92% TOTAL EXPENDITURES 11,981,662.41 3,017,913.94 3,339,862.65 3,017,913.94 686,548.51 8,277,199.96 30.92% ** REVENUE OVER(UNDER) EXPENSES **1,319.41 58,792.91 (92,708.04) 58,792.91 (687,118.51) 629,645.01 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 203-EMS CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-456100 Ambulance/Mileage Transprt Fee 7,248,302.40 1,912,097.34 1,761,969.54 1,912,097.34 - 5,336,205.06 26.38 000-456110 Passport Membership Fees 26,000.00 19,015.00 20,545.00 19,015.00 (20.00) 7,005.00 73.06 000-456120 EMT Class - Fees 140,000.00 48,425.00 44,000.00 48,425.00 (550.00) 92,125.00 34.20 000-456122 CE Class - Fees 20,000.00 - - - - 20,000.00 - 000-456130 Immunization Fees 3,000.00 1,720.00 1,241.50 1,720.00 - 1,280.00 57.33 000-456140 Billing Fees-External 28,000.00 8,222.42 3,936.20 8,222.42 - 19,777.58 29.37 000-456150 Standby Fees 50,000.00 33,772.25 34,679.95 33,772.25 - 16,227.75 67.54 000-456155 Community Services Support 50,000.00 9,290.62 6,157.30 9,290.62 - 40,709.38 18.58 000-456160 MIH Services 40,000.00 9,656.00 8,442.00 9,656.00 - 30,344.00 24.14 000-459200 NSF Check Fee - - 50.00 - - - - TOTAL Fees 7,605,302.40 2,042,198.63 1,881,021.49 2,042,198.63 (570.00) 5,563,673.77 26.84% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 927,934.89 231,983.73 231,983.73 231,983.73 - 695,951.16 25.00 000-474200 JBSA Support 654,777.78 162,705.16 - 162,705.16 - 492,072.62 24.85 000-474300 Cibolo Support 557,333.70 139,333.43 132,260.99 139,333.43 - 418,000.27 25.00 000-475100 Comal Co ESD #6 132,247.05 - 35,952.30 - - 132,247.05 - 000-475200 Live Oak Support 273,764.40 68,441.10 70,060.23 68,441.10 - 205,323.30 25.00 000-475300 Universal City Support 345,554.30 86,388.58 83,971.22 86,388.58 - 259,165.72 25.00 000-475400 Selma Support 186,132.10 46,533.03 45,072.56 46,533.03 - 139,599.07 25.00 000-475500 Schertz Support 725,514.30 181,378.58 173,911.06 181,378.58 - 544,135.72 25.00 000-475600 Santa Clara Support 12,236.00 3,059.00 2,988.26 3,059.00 - 9,177.00 25.00 000-475800 Marion Support 22,684.90 5,671.23 5,340.97 5,671.23 - 17,013.67 25.00 000-475910 TASPP Program 140,000.00 55,835.16 466,757.17 55,835.16 - 84,164.84 39.88 TOTAL Inter-Jurisdictional 3,978,179.42 981,329.00 1,248,298.49 981,329.00 - 2,996,850.42 24.67% Fund Transfers - 000-486000 Transfer In-Reserves 262,000.00 - - - - 262,000.00 - TOTAL Fund Transfers 262,000.00 - - - - 262,000.00 0.00% Miscellaneous 000-491000 Interest Earned 1,500.00 2,244.48 75.03 2,244.48 - (744.48) 149.63 000-491200 Investment Income 4,000.00 6,911.23 111.14 6,911.23 - (2,911.23) 172.78 000-493203 Donations-EMS 2,000.00 455.00 650.00 455.00 - 1,545.00 22.75 000-497000 Misc Income 60,000.00 29,074.38 108,578.96 29,074.38 - 30,925.62 48.46 000-497100 Recovery of Bad Debt 20,000.00 3,834.39 392.58 3,834.39 - 16,165.61 19.17 000-497110 Collection Agency-Bad Debt 50,000.00 10,659.74 8,026.92 10,659.74 - 39,340.26 21.32 TOTAL Miscellaneous 137,500.00 53,179.22 117,834.63 53,179.22 - 84,320.78 38.68% TOTAL REVENUES 11,982,981.82 3,076,706.85 3,247,154.61 3,076,706.85 (570.00) 8,906,844.97 25.67% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 336,826.20$ Cash in Investments EMS-Logic 620,233.21 SR 2017 Ambulance-Logic - Total Cash in Bank & Investments 957,059.41$ C I T Y O F S C H E R T Z CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 204-DRAINAGE CURRENT BUDGET CURRENT PERIOD CURRENT PERIOD CURRENT PERIOD CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY P-1 P-2 P-3 REVENUE SUMMARY Permits 7,000.00 1,400.00 2,000.00 2,400.00 5,800.00 2,250.00 5,550.00 - 1,450.00 79.29 Fees 1,258,500.00 105,514.66 104,883.86 105,356.76 315,755.28 312,530.57 315,500.50 - 942,999.50 25.07 Fund Transfers 182,573.00 - - - - - - - 182,573.00 - Miscellaneous 2,000.00 2,289.38 1,879.94 2,133.91 6,303.23 106.17 5,485.67 - (3,485.67) 274.28 TOTAL REVENUES 1,450,073.00 109,204.04 108,763.80 109,890.67 327,858.51 314,886.74 326,536.17 - 1,123,536.83 22.52% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 525,214.00 34,200.00 50,512.10 38,003.28 122,715.38 102,450.28 129,562.56 147.56 395,503.88 24.70 Supplies 6,950.00 102.75 - 259.64 362.39 62.25 259.64 115.59 6,574.77 5.40 City Support Services 16,000.00 369.81 64.58 373.45 807.84 3,211.39 3,610.49 373.01 12,016.50 24.90 Utility Services 16,900.00 2,884.14 1,903.13 2,972.48 7,759.75 4,668.94 5,630.15 - 11,269.85 33.31 Staff Support 14,000.00 716.09 351.21 776.87 1,844.17 1,727.87 1,594.00 1,429.17 10,976.83 21.59 City Assistance 200.00 - - - - 40.00 - - 200.00 - Professional Services 42,500.00 800.00 23,704.04 - 24,504.04 1,400.00 23,704.04 12,680.00 6,115.96 85.61 Fund Charges/Transfers 575,443.00 47,870.25 47,870.25 47,870.25 143,610.75 143,454.28 143,610.75 - 431,832.25 24.96 Maintenance Services 75,000.00 125.75 - 306.72 432.47 - 306.72 5,726.39 68,966.89 8.04 Other Costs 100.00 105.00 - - 105.00 - - - 100.00 - Operating Equipment 2,500.00 - - - - - - - 2,500.00 - Capital Outlay 165,000.00 - - - - - - - 165,000.00 - TOTAL DRAINAGE 1,439,807.00 87,173.79 124,405.31 90,562.69 302,141.79 257,015.01 308,278.35 20,471.72 1,111,056.93 22.83% PROJECTS Maintenance Services - - - - - 26,517.40 - 7,980.95 (7,980.95) - TOTAL EXPENDITURES 1,439,807.00 87,173.79 124,405.31 90,562.69 302,141.79 283,532.41 308,278.35 28,452.67 1,103,075.98 23.39% ** REVENUE OVER(UNDER) EXPEND 10,266.00 22,030.25 (15,641.51) 19,327.98 25,716.72 31,354.33 18,257.82 (28,452.67) 20,460.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: January 31, 2023 204-DRAINAGE CURRENT BUDGET CURRENT PERIOD CURRENT PERIOD CURRENT PERIOD CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES P-1 P-2 P-3 Permits 000-432400 Floodplain Permit 7,000.00 1,400.00 2,000.00 2,400.00 5,800.00 2,250.00 5,550.00 - 1,450.00 79.29 TOTAL Permits 7,000.00 1,400.00 2,000.00 2,400.00 5,800.00 2,250.00 5,550.00 - 1,450.00 79.29% Fees 000-457500 Drainage Penalties 8,500.00 1,166 705 943.93 2,814.83 2,206.87 2,713.00 - 5,787.00 31.92 000-457600 Drainage Fee 1,250,000.00 104,348 104,179 104,412.83 312,940.45 310,323.70 312,787.50 - 937,212.50 25.02 TOTAL Fees 1,258,500.00 105,514.66 104,883.86 105,356.76 315,755.28 312,530.57 315,500.50 - 942,999.50 25.07% Fund Transfers 000-481000 Transfer In - Reserves 165,000.00 - - - - - - - 165,000.00 - 000-486101 Transfer In - General Fund 17,573.00 - - - - - - - 17,573.00 - TOTAL Funds Transfers 182,573.00 - - - - - - - 182,573.00 0.00% Miscellaneous 000-491000 Interest Earned 500.00 392 616 443.20 1,450.96 28.75 1,469.73 - (969.73) 293.95 000-491200 Investment Income 1,500.00 1,898 1,264 1,690.71 4,852.27 77.42 4,015.94 - (2,515.94) 267.73 TOTAL Miscellaneous 2,000.00 2,289.38 1,879.94 2,133.91 6,303.23 106.17 5,485.67 - (3,485.67) 274.28% TOTAL REVENUES 1,450,073.00 109,204.04 108,763.80 109,890.67 327,858.51 314,886.74 326,536.17 - 1,123,536.83 22.52% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: January 31, 2023 Cash in Bank Claim on Operating Cash Pool-Checking 149,563.99$ Cash in Investments Lone Star Investment-Drainage Maint Fund 488,466.06 Total Cash in Bank & Investments 638,030.05$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: January 31, 2023 314-HOTEL TAX CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 640,000.00 159,485.52 194,668.13 159,485.52 - 480,514.48 24.92 Miscellaneous 8,500.00 15,505.93 334.94 15,505.93 - (7,005.93) 182.42 TOTAL REVENUES 648,500.00 174,991.45 195,003.07 174,991.45 - 473,508.55 26.98% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 0.00 - - - - - - City Support Services 118,000.00 23,942.29 25,826.44 23,942.29 - 94,057.71 20.29 Operations Support 31,000.00 5,561.95 5,284.50 5,561.95 400.00 25,038.05 19.23 Professional Services 4,000.00 180.00 240.00 180.00 540.00 3,280.00 18.00 Fund Charges/Transfers 69,915.00 17,478.75 18,610.78 17,478.75 - 52,436.25 25.00 Maintenance Services 50,000.00 - 29.82 - - 50,000.00 - Operating Equipment - - 1,072.68 - - - - TOTAL NONDEPARTMENTAL 272,915.00 47,162.99 51,064.22 47,162.99 940.00 224,812.01 17.63% TOTAL GENERAL GOVERNMENT 272,915.00 47,162.99 51,064.22 47,162.99 940.00 224,812.01 17.63% MISC & PROJECTS PROJECTS Professional Services - 1,440.00 7,910.00 1,440.00 394.89 (1,834.89) - Maintenance Services - 40,997.22 - 40,997.22 - (40,997.22) - TOTAL PROJECTS - 42,437.22 7,910.00 42,437.22 394.89 (42,832.11) 0.00% TOTAL MISC & PROJECTS - 42,437.22 7,910.00 42,437.22 394.89 (42,832.11) 0.00% TOTAL EXPENDITURES 272,915.00 89,600.21 58,974.22 89,600.21 1,334.89 181,979.90 33.32% REVENUE OVER(UNDER) EXPENDITURE 375,585.00 85,391.24 136,028.85 85,391.24 (1,334.89) 291,528.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 50,459.78$ Cash in Investments Texas Class - Hotel Tax 1,644,597.32 Total Cash in Bank & Investments 1,695,057.10$ HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 AS OF: March 31, 2021 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2022-23 52,572 54,980 47,332 2021-22 65,789 63,938 62,952 58,027 54,614 74,755 70,056 70,014 75,996 75,155 53,940 51,934 2020-21 22,147 18,567 19,948 23,467 28,556 45,098 48,675 51,329 39,397 70,910 62,432 24,529 2019-20 33,124 31,590 29,661 23,382 33,841 20,209 8,643 8,934 13,859 15,559 25,115 29,624 - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 318,000.00 - - - - 318,000.00 - Miscellaneous 1,025.00 2,472.02 40.35 2,472.02 - (1,447.02) 241.17 TOTAL REVENUES 319,025.00 2,472.02 40.35 2,472.02 - 316,552.98 0.77% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25,000.00 - - - - 25,000.00 - Capital Outlay 100,000.00 - - - - 100,000.00 - TOTAL PARKLAND DEDICATION 125,000.00 - - - - 125,000.00 0.00% TOTAL EXPENDITURES 125,000.00 - - - - 125,000.00 0.00% REVENUE OVER(UNDER) EXPEND 194,025.00 2,472.02 40.35 2,472.02 - 191,552.98 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 317-PARK CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458800 Parkland Dedication 318,000.00 - - - - 318,000.00 - TOTAL Fees 318,000.00 - - - - 318,000.00 0.00% Fund Transfers TOTAL Fund Transfers - - - - - - 0.00% Miscellaneous 000-491000 Interest Earned 25.00 82.70 0.30 82.70 - (57.70) 330.80 000-491200 Investment Income 1,000.00 2,389.32 40.05 2,389.32 - (1,389.32) 238.93 TOTAL Miscellaneous 1,025.00 2,472.02 40.35 2,472.02 - (1,447.02) 241.17% TOTAL REVENUES 319,025.00 2,472.02 40.35 2,472.02 - 316,552.98 0.77% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Current Claim on Operating Cash Pool-Checking 13,284.08 Cash in Investments Texas Class- Park Fund 250,709.99 Total in Investment Pool 250,709.99 Total Cash in Bank & Investments 263,994.07 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31 Miscellaneous 1,400.00 6,770.51 104.95 6,770.51 - (5,370.51) 483.61 TOTAL REVENUES 71,400.00 23,085.51 57,097.45 23,085.51 - 48,314.49 32.33% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43 TOTAL TREE MITIGATION 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43% TOTAL EXPENDITURES 70,000.00 2,700.00 13,600.00 2,700.00 2,500.00 64,800.00 7.43% REVENUE OVER(UNDER) EXPEND 1,400.00 20,385.51 43,497.45 20,385.51 (2,500.00) (16,485.51) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 319-TREE MITIGATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-458900 Tree Mitigation 70,000.00 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31 TOTAL Fees 70,000.00 16,315.00 56,992.50 16,315.00 - 53,685.00 23.31% Fund Transfers Miscellaneous 000-491000 Interest Earned 200.00 291.99 17.59 291.99 - (91.99) 146.00 000-491200 Investment Income 1,200.00 6,478.52 87.36 6,478.52 - (5,278.52) 539.88 TOTAL Miscellaneous 1,400.00 6,770.51 104.95 6,770.51 - (5,370.51) 483.61% TOTAL REVENUES 71,400.00 23,085.51 57,097.45 23,085.51 - 48,314.49 32.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking $20,828.45 Cash in Investments MBIA Investment-Tree Mitigation 707,616.31 Total Cash in Bank & Investments $728,444.76 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 1,100,000.00 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93 Miscellaneous 51,500.00 48,212.24 1,848.88 48,212.24 - 3,287.76 93.62 TOTAL REVENUES 1,151,500.00 223,467.24 153,282.88 223,467.24 - 928,032.76 19.41% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Support Services 11,748.00 - - - - 11,748.00 - Professional Services 44,000.00 - 2,877.37 - 36,438.81 7,561.19 82.82 TOTAL NON DEPARTMENTAL 55,748.00 - 2,877.37 - 36,438.81 19,309.19 65.36% MISC & PROJECTS PROJECTS TOTAL MISC & PROJECTS - - - - - - 0.00% TOTAL EXPENDITURES 55,748.00 - 2,877.37 - 36,438.81 19,309.19 65.36% REVENUE OVER(UNDER) EXPENDITURES 1,095,752.00 223,467.24 150,405.51 223,467.24 (36,438.81) 908,723.57 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 411-CAPITAL RECOVERY WATER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455900 Cap Rcvry-Water 1,100,000.00 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93 TOTAL Fees 1,100,000.00 175,255.00 151,434.00 175,255.00 - 924,745.00 15.93% Fund Transfers Miscellaneous - 000-491000 Interest Earned 1,500.00 610.17 52.01 610.17 - 889.83 40.68 000-491200 Investment Income 50,000.00 47,602.07 1,796.87 47,602.07 - 2,397.93 95.2 TOTAL Miscellaneous 51,500.00 48,212.24 1,848.88 48,212.24 - 3,287.76 93.62% TOTAL REVENUES 1,151,500.00 223,467.24 153,282.88 223,467.24 - 928,032.76 19.41% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 123,965.88$ Cash in Investments Lone Star Investment-Capital Recovery Water 4,986,185.24 Total Cash in Bank & Investments 5,110,151.12$ CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76 Miscellaneous 51,500.00 65,680.57 1,663.55 65,680.57 - (14,180.57) 127.54 TOTAL REVENUES 601,500.00 146,869.47 70,618.67 146,869.47 - 454,630.53 24.42% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services - 1,153.28 - - - - - Fund Charges/Transfers 52,500.00 - 4,018.36 1,153.28 76,559.25 (25,212.53) 148.02 TOTAL NON DEPARTMENTAL 64,248.00 1,153.28 4,018.36 1,153.28 76,559.25 (13,464.53) 120.96% MISC & PROJECTS TOTAL EXPENDITURES 64,248.00 1,153.28 4,018.36 1,153.28 76,559.25 (13,464.53) 120.96% REVENUE OVER(UNDER) EXPENDITURES 537,252.00 145,716.19 66,600.31 145,716.19 (76,559.25) 468,095.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 421-CAPITAL RECOVERY SEWER CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 Cap Rcvry-Waste Water 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76 TOTAL Fees 550,000.00 81,188.90 68,955.12 81,188.90 - 468,811.10 14.76% Fund Transfers Miscellaneous 000-491000 Interest Earned 1,500.00 12,283.15 8.54 12,283.15 - (10,783.15) 818.88 000-491200 Investment Income 50,000.00 53,246.48 3,623.90 53,246.48 - (3,246.48) 106.49 000-491900 Unrealize Gain/Loss-Captl One - 150.94 (1,968.89) 150.94 - (150.94) - TOTAL Miscellaneous 51,500.00 65,680.57 1,663.55 65,680.57 - (14,180.57) 127.54% TOTAL REVENUES 601,500.00 146,869.47 70,618.67 146,869.47 - 454,630.53 24.42% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 1,214,685.69$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,577,409.07 Capital One-Investment 642,564.92 Total Cash in Bank & Investments 6,434,659.68$ CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22 Fund Transfers 88,173.00 - - - - 88,173.00 - Miscellaneous 5,200.00 8,125.35 127.42 8,125.35 - (2,925.35) 156.26 TOTAL REVENUES 343,373.00 58,675.35 29,383.92 58,675.35 - 284,697.65 17.09% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 770.21 - - 5,000.00 - TOTAL NON DEPARTMENTAL 5,000.00 - 770.21 - - 5,000.00 0.00% MISC & PROJECTS City Support Services - 8,339.00 - 8,339.00 8,339.00 (16,678.00) - Maintenance Services 88,173.00 44,086.50 - 44,086.50 44,086.49 0.01 100.00 TOTAL MISC & PROJECTS 88,173.00 52,425.50 - 52,425.50 52,425.49 (16,677.99) 118.92% TOTAL EXPENDITURES 93,173.00 52,425.50 770.21 52,425.50 52,425.49 (11,677.99) 112.53% REVENUE OVER(UNDER) EXPENDITURES 250,200.00 6,249.85 28,613.71 6,249.85 (52,425.49) 296,375.64 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 431-ROADWAY IMPACT FEE AREA 1 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455921 CapitalRcvry-RoadwaysSrvAre 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22 TOTAL Fees 250,000.00 50,550.00 29,256.50 50,550.00 - 199,450.00 20.22% Fund Transfers 000-481000 Transfer In - Reserves 88,173.00 - - - - 88,173.00 - TOTAL Fund Transfers 88,173.00 - - - - 88,173.00 0.00% Miscellaneous 000-491000 Interest Earned 200.00 92.59 6.31 92.59 - 107.41 46.30 000-491200 Investment Income 5,000.00 8,032.76 121.11 8,032.76 - (3,032.76) 160.66 TOTAL Miscellaneous 5,200.00 8,125.35 127.42 8,125.35 - (2,925.35) 156.26% TOTAL REVENUES 343,373.00 58,675.35 29,383.92 58,675.35 - 284,697.65 17.09% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 58.36$ Cash in Investments Lone Star Investment-Cap Rec Streets 1 812,162.42 Total Cash in Bank & Investments 812,220.78$ ROADWAY IMPACT FEE AREA 1 CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38 Miscellaneous 1,600.00 5,525.62 65.15 5,525.62 - (3,925.62) 345.35 TOTAL REVENUES 201,600.00 36,290.82 27,600.46 36,290.82 - 165,309.18 18.00% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL City Assistance 50,000.00 - - - - 50,000.00 - Professional Services 5,000.00 - 2,749.18 - - 5,000.00 - TOTAL NON DEPARTMENTAL 55,000.00 - 2,749.18 - - 55,000.00 0.00% TOTAL EXPENDITURES 55,000.00 - 2,749.18 - - 55,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 146,600.00 36,290.82 24,851.28 36,290.82 - 110,309.18 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 432-ROADWAY IMPACT FEE AREA 2 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38 TOTAL Fees 200,000.00 30,765.20 27,535.31 30,765.20 - 169,234.80 15.38% Fund Transfers Miscellaneous 000-491000 Interest Earned 100.00 32.23 5.26 32.23 - 67.77 32.23 000-491200 Investment Income 1,500.00 5,493.39 59.89 5,493.39 - (3,993.39) 366.23 TOTAL Miscellaneous 1,600.00 5,525.62 65.15 5,525.62 - (3,925.62) 345.35% TOTAL REVENUES 201,600.00 36,290.82 27,600.46 36,290.82 - 165,309.18 18.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 28,041.26$ Cash in Investments Lone Star Investment-Cap Rec Streets 2 572,277.31 Total Cash in Bank & Investments 600,318.57$ ROADWAY IMPACT FEE AREA 2 CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47 Miscellaneous 5,050.00 12,001.77 225.10 12,001.77 - (6,951.77) 237.66 TOTAL REVENUES 380,050.00 96,251.77 91,426.10 96,251.77 - 283,798.23 25.33% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 5,000.00 - 2,749.18 - - 5,000.00 - TOTAL NON DEPARTMENTAL 5,000.00 - 2,749.18 - - 5,000.00 0.00% TOTAL EXPENDITURES 5,000.00 - 2,749.18 - - 5,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 375,050.00 96,251.77 88,676.92 96,251.77 - 278,798.23 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 433-ROADWAY IMPACT FEE AREA 3 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47 TOTAL Fees 375,000.00 84,250.00 91,201.00 84,250.00 - 290,750.00 22.47% Fund Transfers Miscellaneous 000-491000 Interest Earned 50.00 129.84 7.66 129.84 - (79.84) 259.68 000-491200 Investment Income 5,000.00 11,871.93 217.44 11,871.93 - (6,871.93) 237.44 TOTAL Miscellaneous 5,050.00 12,001.77 225.10 12,001.77 - (6,951.77) 237.66% TOTAL REVENUES 380,050.00 96,251.77 91,426.10 96,251.77 - 283,798.23 25.33% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 3,851.50$ Cash in Investments Lone Star Investment-Cap Rec Streets 3 1,275,701.51 Total Cash in Bank & Investments 1,279,553.01$ ROADWAY IMPACT FEE AREA 3 CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 3,000.00 - - - - 3,000.00 - Miscellaneous 40.00 95.96 2.03 95.96 - (55.96) 239.90 TOTAL REVENUES 3,040.00 95.96 2.03 95.96 - 2,944.04 3.16% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,000.00 - 2,749.18 - - 3,000.00 - TOTAL NON DEPARTMENTAL 3,000.00 - 2,749.18 - - 3,000.00 0.00% TOTAL EXPENDITURES 3,000.00 - 2,749.18 - - 3,000.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 40.00 95.96 (2,747.15) 95.96 - (55.96) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 434-ROADWAY IMPACT FEE AREA 4 CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Fees 000-455910 CapitalRcvry-RoadwaysSrvAre 3,000.00 - - - - 3,000.00 - TOTAL Fees 3,000.00 - - - - 3,000.00 0.00% Fund Transfers Miscellaneous 000-491000 Interest Earned 10.00 2.32 - 2.32 - 7.68 23.20 000-491200 Investment Income 30.00 93.64 2.03 93.64 - (63.64) 312.13 TOTAL Miscellaneous 40.00 95.96 2.03 95.96 - (55.96) 239.90% TOTAL REVENUES 3,040.00 95.96 2.03 95.96 - 2,944.04 3.16% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking (3,496.87)$ Cash in Investments Lone Star Investment-Cap Rec Streets 4 9,646.02 Total Cash in Bank & Investments 6,149.15$ ROADWAY IMPACT FEE AREA 4 CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 505-TAX I&S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 7,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92 Fund Transfers 814,143.00 - - - - 814,143.00 - Miscellaneous 175,750.00 46,396.37 5,809.03 46,396.37 - 129,353.63 26.40 TOTAL REVENUES 8,686,248.00 4,042,358.69 3,867,561.05 4,042,358.69 - 4,643,889.31 46.54% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84,000.00 800.00 45,293.39 800.00 200.00 83,000.00 1.19 Debt Service 8,602,248.00 - - - - 8,602,248.00 - TOTAL GENERAL GOVERNMENT 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% TOTAL EXPENDITURES 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% ** REVENUE OVER(UNDER) EXPEND - 4,041,558.69 3,822,267.66 4,041,558.69 (200.00) (4,041,358.69) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2022 505-TAX I & S CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUES Taxes 000-411900 Property Tax Revenue 7,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92 TOTAL Taxes 7,696,355.00 3,995,962.32 3,861,752.02 3,995,962.32 - 3,700,392.68 51.92% Fund Transfers 000-481000 Transfer In - Reserves 814,143.00 - - - - 814,143.00 - TOTAL Fund Transfers 814,143.00 - - - - 814,143.00 0.00% Miscellaneous 000-491000 Interest Earned 750.00 1,479.13 21.35 1,479.13 - (729.13) 197.22 000-491200 Investment Income 75,000.00 19,917.24 169.93 19,917.24 - 55,082.76 26.56 000-495020 Contribution From YMCA 100,000.00 25,000.00 - 25,000.00 - 75,000.00 25.00 000-498000 Proceeds From Refunding Debt - - 5,617.75 - - - - TOTAL Miscellaneous 175,750.00 46,396.37 5,809.03 46,396.37 - 129,353.63 26.40% TOTAL REVENUES 8,686,248.00 4,042,358.69 3,867,561.05 4,042,358.69 - 4,643,889.31 46.54% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: December 31 , 2022 505-TAX I & S GENERAL GOVERNMENT CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET NON DEPARTMENTAL Professional Services 101-541500 Paying Agent 4,000.00 800.00 600.00 800.00 200.00 3,000.00 25.00 101-541502 Cost of Bond Issuance 80,000.00 - 44,693.39 - - 80,000.00 - TOTAL Professional Services 84,000.00 800.00 45,293.39 800.00 200.00 83,000.00 1.19% Debt Service 101-555629 Bond-GO 2007 Principal 355,000.00 - - - - 355,000.00 - 101-555629.1 Bond-GO 2007 Interest 71,123.00 - - - - 71,123.00 - 101-555638 Bond-GO 2014 Refund-Principal 775,000.00 - - - - 775,000.00 - 101-555638.1 Bond-GO 2014 Refund-Interest 245,150.00 - - - - 245,150.00 - 101-555640.1 Bond-GO Ref 2015-Interest 37,050.00 - - - - 37,050.00 - 101-555642 Bond-GO SR2016-Principal 255,000.00 - - - - 255,000.00 - 101-555642.1 Bond-GO SR2016-Interest 121,606.00 - - - - 121,606.00 - 101-555643 Bond-TaxableB CO SR2016-Princi 65,000.00 - - - - 65,000.00 - 101-555643.1 Bond-Taxable CO SR2016-Interes 38,388.00 - - - - 38,388.00 - 101-555644 Bond-NonTaxA CO SR2016-Princip 205,000.00 - - - - 205,000.00 - 101-555644.1 Bond-NonTax CO SR2016-Interest 32,469.00 - - - - 32,469.00 - 101-555645 Bond-CO SR2017-Principal 315,000.00 - - - - 315,000.00 - 101-555645.1 Bond-CO SR2017 - Interest 103,400.00 - - - - 103,400.00 - 101-555646 Bond-GO SR2017 - Principal 170,000.00 - - - - 170,000.00 - 101-555646.1 Bond-GO SR2017 - Interest 95,025.00 - - - - 95,025.00 - 101-555647 Bond-GO 2018 Refund- Principal 595,000.00 - - - - 595,000.00 - 101-555647.1 Bond-GO 2018 Refund - Interest 73,617.00 - - - - 73,617.00 - 101-555648 Bond-CO SR2018 - Principal 260,000.00 - - - - 260,000.00 - 101-555648.1 Bond-CO 2018 - Interest 151,263.00 - - - - 151,263.00 - 101-555649 Bond-GO 2018 Ref - Principal 205,000.00 - - - - 205,000.00 - 101-555649.1 Bond-GO 2018 Ref - Interest 172,069.00 - - - - 172,069.00 - 101-555650 Bond-CO 2019-Principal 275,000.00 - - - - 275,000.00 - 101-555650.1 Bond-CO 2019-Interest 106,800.00 - - - - 106,800.00 - 101-555651 Bond-GO 2020-Principal 960,000.00 - - - - 960,000.00 - 101-555651.1 Bond-GO 2020-Interest 174,063.00 - - - - 174,063.00 - 101-555652 Bond-GO 2021 Ref - Principal 350,000.00 - - - - 350,000.00 - 101-555652.1 Bond-GO 2021 Ref - Interest 124,800.00 - - - - 124,800.00 - 101-555653 Bond-CO 2022 - Principal 175,000.00 - - - - 175,000.00 - 101-555653.1 Bond-CO 2022 - Interest 166,525.00 - - - - 166,525.00 - 101-555654 Bond-CO 2022A - Principal 595,000.00 - - - - 595,000.00 - 101-555655 Bond-GO 2022 - Principal 1,333,900.00 - - - - 1,333,900.00 - TOTAL Debt Service 8,602,248.00 - - - - 8,602,248.00 0.00% Other Financing Sources TOTAL EXPENDITURES 8,686,248.00 800.00 45,293.39 800.00 200.00 8,685,248.00 0.01% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2022 Cash in Bank Claim on Operating Cash Pool-Checking 204,445.78$ MBIA Investment- Tax I&S 5,701,521.55 Total Cash in Bank & Investments 5,905,967.33$ TAX I&S CASH IN BANK AND INVESTMENTS AS OF: December 31 , 2022 620-SED CORPORATION CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL Y-T-D ENCUMBRANCE BUDGET BALANCE % OF BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Taxes 6,548,000.00 1,621,603.00 1,435,398.73 1,621,603.00 - 4,926,397.00 24.76 Fund Transfers 3,320,960.00 - - - - 3,320,960.00 - Miscellaneous 182,000.00 223,904.77 5,273.47 223,904.77 - (41,904.77) 123.02 TOTAL REVENUES 10,050,960.00 1,845,507.77 1,440,672.20 1,845,507.77 - 8,205,452.23 18.36% EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,000,079.00 50,000.00 - 50,000.00 - 2,950,079.00 1.67 Fund Charges/Transfers 5,750,000.00 - - - - 5,750,000.00 - TOTAL NONDEPARTMENTAL 8,750,079.00 50,000.00 - 50,000.00 - 8,700,079.00 0.57% MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 141.24 512.61 141.24 110.82 747.94 25.21 City Support Services 20,000.00 4,482.67 1,460.68 4,482.67 - 15,517.33 22.41 Utility Services 2,975.00 49.00 127.17 49.00 - 2,926.00 1.65 Operations Support 437,610.00 35,749.55 31,178.91 35,749.55 15,393.57 386,466.88 11.69 Staff Support 25,775.00 4,451.64 (264.40) 4,451.64 1,737.88 19,585.48 24.01 City Assistance 205,000.00 3,050.00 - 3,050.00 - 201,950.00 1.49 Professional Services 61,300.00 2,028.00 1,872.00 2,028.00 - 59,272.00 3.31 Fund Charges/Transfers 542,221.00 271,110.50 253,492.00 271,110.50 - 271,110.50 50.00 Operating Equipment 5,000.00 26.89 2,179.94 26.89 251.23 4,721.88 5.56 TOTAL ECONO DEVELOPMENT 1,300,881.00 321,089.49 290,558.91 321,089.49 17,493.50 962,298.01 26.03% FM3009 ROAD&BRIDGE EXPANSION TOTAL EXPENDITURES 10,050,960.00 371,089.49 290,558.91 371,089.49 17,493.50 9,662,377.01 3.87% ** REVENUE OVER(UNDER) EXPEND - 1,474,418.28 1,150,113.29 1,474,418.28 (17,493.50) (1,456,924.78) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2022 Cash in Bank Claim on Operating Cash Pool-Checking 317,010.10$ Cash in Investments Texas Class Investment-Economic Development Corp 23,921,120.17 Schertz Bank & Trust-Certificate of Deposit 1,091,353.64 Schertz Bank & Trust-Certificate of Deposit 1,138,328.37 Total Cash in Bank & Investments 26,467,812.28$ SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: December 31, 2022 Agenda No. 5.   CITY COUNCIL MEMORANDUM    City Council Meeting:April 25, 2023 Department:City Secretary Subject:Guadalupe Regional Medical Center Prescription Assistance Program - for Schertz Enrollees Report BACKGROUND The City Council held a Regular City Council meeting on _______________. Attachments GRMC Prescription report  Total number of patients served by the program 1138 Total number of Schertz residents served by the program 19 Total number of prescriptions provided by the program 15337 Retail dollar value of prescriptions provided by the PAP 2,899,498.00$ Retail dollar value of prescriptions provided to Schertz residents by PAP 124,610.40$ Number of prescriptions per Schertz patient per month 3.6 Average prescription retail price (3 month supply) per Schertz patient 910.89$ Average annual retail prescription benefit per Schertz patient 13,116.84$ SOURCES OF PROGRAM FUNDS (ANNUAL) Schertz contribution to the program 5,000.00$ Seguin contribution to the program 5,000.00$ Contributions to program by individuals 8,798.20$ Payments by patients ($15.00/month/patient)97,405.26$ Grants received for the program (United Way)4,500.00$ Other sources of funds (identify sources) -$ 120,703.46$ (376,638.59)$ (255,935.13)$ TOTAL REVENUE TOTAL EXPENSES TOTAL NET Exhibit A Report Information Guadalupe Regional Medical Center Prescription Assistance Program for Schertz Enrollees September 1, 2022 thru February 28, 2023 BENEFIT