The URL can be used to link to this page

03-22-2022 Agenda with backupMEETING AGENDA City Council REGULAR SESSION CITY COUNCIL March 22, 2022 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 treats Work cooperatively as a tea CITY COUNCIL HEAD SHOTS TS AT 4:30 P.M. AND OUP PHOTO Arlo' 5:30 P.M. Prior to the Regular Meeting City Council will hold its regularly scheduled eeting at :00 p.m., Tuesday, March 22, 2022, at the City Council Chambers. In lieu of attending the ineeling in Person, residents will have the opportunity to watch the meeting via live stream on the City's y'ooT be Channel. Call to Order Opening Prayer and Pledges of Allegiance to the Flags of the United States and State of Texas. (Councilmember Dahle) Presentations • Proclamation recognizing Alcohol Awareness Month. (A. Heyward) City Events and Announcements • Announcements of upcoming City Events (B. James /C. Kelm/S. Gonzalez) • Announcements and recognitions by the City Manager (M. Browne) • Announcements and recognitions by the Mayor (R. Gutierrez) March 22, 2022 City Council Agenda Page 1 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. 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 regarding the approval of the minutes of the meeting of the regular meeting of March 8, 2022. (B. Dennis) 2. Ordinance No. 22 -G -14 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas amending Chapter 66, Police - Articles I and Il of the Code of Ordinances of the City of Schertz, Texas to provide for the establishment of the City of Schertz Police Department; establishing the position of Chief of Police and providing for the employment of Police Officers; prescribing the qualifications, duties and responsibilities of the Chief of Police and Police Officers establishing the jurisdictional boundaries of the department; providing a savings clause, and providing an effective date. Final Reading (C. Kelm/M. Bane) 3. Resolution No. 22 -R -34 - Consideration and /or action approving a Resolution by the City Council of the City of Schertz, Texas approving the renewal of existing three -year support agreement for ARCGIS mapping software supplied by Environmental Systems Research Institute, Inc. (ESRI). (B. James /M. Clauser) 4. Resignations and Appointments to Boards / Commissions /Committees - Consideration and /or action regarding the resignations and appointments to various Boards /Commissions /Committees (Council /S. Edmondson) • Resignation of Mr. Margarito Banales from the Schertz Library Advisory Board Discussion and Action Items 5. Resignation - Consideration and/or action regarding the acceptance of the Retirement Resignation letter from City Manager Dr. Mark Browne. March 22, 2022 City Council Agenda Page 2 6. Ordinance No. 22 -T -16 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas authorizing an adjustment to the FY 2021/2022 budget to allocate funds for the Schertz Council Facilities Audio and Video Systems Upgrade Project in the amount of $451,686.00 First Reading (B. James/ M. Clauser) 7. Ordinance No. 22 -T -17- Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas authorizing an adjustment to the FY 2021/2022 City of Schertz budget to provide an additional $65,835.00 from the dedicated PEG fund for the Master Communication Plan. First Reading (B. James/M. Clauser) Public Hearings 8. Ordinance No. 22 -S -11 - Conduct a public hearing and consideration and /or action on a request to rezone approximately 9 acres of land from General Business District (GB) and Pre - Development District (PRE) to General Business District (GB) and General Business District -2 (GB -2), generally located approximately 3,000 feet east of the intersection of Schwab Road and IH -35 access road, also known as a portion Coma]. County Property Identification Number 78178, City of Schertz, Comal County, Texas. First Reading (B. James /M. Harrison) Roll Call Vote Confirmation Workshop 9. Discussion on the Main Street Vision and Challenges including parking and nonconfoming uses. 10. Discussion regarding the Joint Base San Antonio Randolph Joint Land Use Study Land Use Study and Air Installation Compatible Use Zones Study Recommendations compatible land uses and development restrictions. Closed Session 11. The City Council will meet in closed session in accordance with Section 551.074 of the Texas Government Code to discuss the direction to fill the City Manager vacancy. Reconvene into Regular Session 12. Take any action based on discussions held in Closed Session under Agenda Item 11. Roll Call Vote Confirmation March 22, 2022 City Council Agenda Page 3 Information available in City Council Packets - NO DISCUSSION TO OCCUR 13. Quarterly Financial Reports Requests and Announcements . Announcements by the City Manager. • 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, DEPUTY 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 18th DAY OF MARCH 2022 AT 3:30 P.M., 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 EWONDSON 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 , 2022. 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 March 22, 2022 City Council Agenda Page 4 Mayor Gutierrez Councilmember Scagliola — Place 5 Audit Committee Animal Advisory Commission - Alternate Investment Advisory Committee Cibolo Valley Local Government Corporation - Alternate Main Street Committee Hal Baldwin Scholarship Committee Interview Committee for Boards and Commissions - Alternate Schertz- Seguin Local Government Corporation Councilmember Davis— Place 1 Councilmember — Place 2 Vacant Interview Committee for Boards and Commissions Main Street Committee - Chair Schertz Housing Authority Board TIRZ II Board Councilmember Whittaker — Place 3 Councilmember Dahle — Place 4 Audit Committee Cibolo Valley Local Government Corporation Interview Committee for Boards and Commissions Interview Committee for Boards and Commissions TIRZ II Board TIRZ II Board Councilmember Heyward — Place 6 Councilmember Brown — Place 7 Animal Advisory Commission Main Street Committee Audit Committee Schertz- Seguin Local Government Corporation - Alternate Investment Advisory Committee Main Street Committee March 22, 2022 City Council Agenda Page 5 Agenda No. 1. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: City Secretary Subject: Minutes — Consideration and /or action regarding the approval of the minutes of the meeting of the regular meeting of March 8, 2022. (B. Dennis) BACKGROUND The City Council held a Regular City Council meeting on March 8, 2022. RECOMMENDATION Recommend Approval. Attachments 03 -08 -2022 Draft Minutes DRAFT MINUTES REGULAR MEETING March 8, 2022 A Regular Meeting was held by the Schertz City Council of the City of Schertz, Texas, on March 8, 2022, at 6:00 p.m. in the Hal Baldwin Municipal Complex Council Chambers, 1400 Schertz Parkway, Building #4, Schertz, Texas. The following members present to -wit: Present: Mayor Ralph Gutierrez; Mayor Pro -Tem David Scagliola; Councilmember Mark Davis; City Council Place 2 - Vacant; Councilmember Jill Whittaker; Councilmember Michael Dahle; Councilmember Allison Heyward; Councilmember Tim Brown City City Manager Dr. Mark Browne; Assistant City Manager Brian James; Assistant City Manager Charles Staff: Kelm; City Attorney Daniel Santee; City Secretary Brenda Dennis 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 Whittaker) Councilmember Whittaker provided the opening prayer followed by the Pledges of Allegiance to the Flags of the United States and the State of Texas. Mayor Gutierrez reminded the Students who were participating in the Hall Baldwin Scholarship Program, to make sure that they sign the sheet in the back. Mayor Gutierrez also stated that those who are watching on -line to please make sure that they contact Sarah Gonzalez at 210 - 619 -1015 to receive credit. Presentations . Proclamation recognizing Schertz Knights of Columbus Day. Mayor Gutierrez recognized Members of the Schertz Knights of Columbus who were present and came forward accepting the Proclamation recognizing Schertz Knights of Columbus Day. Mr. Javier Espinada thanked the City for the recognition and stated they enjoy supporting the community and giving back to the community. He stated that on the 20th they will be celebrating with all members what has happened over the last 50 years. Mayor Gutierrez thanked the Knights of Columbus members for giving back to the community, they have contributed in so many ways. The COVID -1.9 Shot Clinic, the excellent Fish Fries on Fridays, etc. City Events and Announcements • Announcements of upcoming City Events (B. James /C. Kelm /S. Gonzalez) Mayor Gutierrez recognized Assistant City Manager Charles Kelm who provided the following upcoming events: Saturday, March 19th Breakfast with the Heat 9:00 AM — 11:00 AM Schertz YMCA The event will be on the splash pad. Bring your families and your smiles! Tuesday, March 22nd Next regular scheduled Council meeting, 6:00 PM, Council Chambers Friday, March 25th Pre - Budget Retreat 8:30 AM -5:00 PM Fire Station #3 • Announcements and recognitions by the City Manager (M. Browne) Mayor Gutierrez recognized City Manager Dr. Mark Browne who showed a photo of the Leadership Team which consists of the City Department Heads and the Executive Management Team from the City Managers office. He stated we gathered for a Retreat on Thursday and Friday, starting with a walk at Heritage Oaks Park - beautiful park and beautiful day. He stated it was a very good retreat which included talking about team building and how to move forward as a team. The frank conversations were great and everyone got a lot of out of it. He is very optimistic about the future of our team and appreciated everyone's input. It was a very successful event. • Announcements and recognitions by the Mayor (R. Gutierrez) Mayor Gutierrez stated that this past weekend we had the Kick Cancer Wilenchik Walk /Run for Life event. He thanked all the residents who participated in supporting the cause. He stated he has a special presentation and called Mr. Brian James, Assistant City Manager and presented him with his medal. Mayor Gutierrez stated that he received 2nd place in his age group. Mayor also presented Councilmember Michael Dahle with his medal who received 1 st place in his age group. Mr. James stated that there were two in his age group. Mayor Gutierrez also stated that he had the honor of attending a special birthday celebration for Mr. Raymond Flores and his 100th birthday celebration. Mr. Flores shared some great stories. 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 Scagliola recognized the following who spoke: • Mr. Daniel Jameson, 1048 Richmond Drive who came forward stating that he was picking someone up on Ray Corbett Drive and was unable to see the street sign because it was not visible. He requested that N the sign be brightened up for better visibility. He stated that there are several other signs that are not visible and suggested that they get painted and that this could be a project. • Ms. Maggie Titterington, 1730 Schertz Parkway who came forward providing the following Chamber Updates: • Thank you for ribbon cutting attendance and support in Live Oak. • Heb kick -off to The Taste- area restaurants seeing more traffic • Updates to visitor center landscaping- thank you to City for doing this, it's looking great • Requested White letters of support- if City has issues they want brought up to our State Representatives, please give to her before April 12th • Leadership CORE- class project is the Schertz Animal Facility. Will raise funds and donations and present at July luncheon. • Mr. Bobby Jones, 1.2406 Guy Guisborne, who spoke about the drainage ditch issues behind his home, he provided photographs of the issues. Mayor directed Mr. Jones to Public Works Director Suzanne Williams to discuss. • Ms. Judy Goldick and Mr. Jerry Goldick, 807 Main Street, who address the Council again on the serious parking issues on Main Street. The parking issues are affecting businesses on Main. Street and suggested a variance to park behind the fence. As a point of record, Mayor and City Manager stated that the Main Street Committee is looking into these issues. 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 the following into record: 1. Minutes — Consideration and/or action regarding the approval of the minutes of the meeting of regular meeting of March 1, 2022. (B. Dennis) 2. Resolution No. 22 -R -28 - Consideration and /or action approving a Resolution by the City Council of the City of Schertz, Texas authorizing the City Manager to enter into a job order contract with Sullivan Contracting Services to complete the Civic Center HVAC Replacement Project. (C. Kelm /S. Williams /S. McClelland) 3. Ordinance No. 22 -T -09 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas, authorizing an adjustment to the Fiscal Year 2021 -2022 Budget to provide funding for the Civic Center HVAC Replacement Project, repealing all ordinances or parts of ordinances in conflict with this ordinance; and providing an effective date. (Final Reading) (C. Kelm /S. Williams /S. McClelland) 4. Ordinance No. 22 -T -10 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas, authorizing an adjustment to the Fiscal. Year 2021 -2022 Budget, of $570,000, to provide funding for the purchase of property currently owned by Guadalupe Basin River Authority (GBRA), repealing all ordinances or parts of ordinances in conflict with this ordinance; and providing an effective date. (Final Reading) (C. Kelm/S. Williams) 3 5. Resolution No. 22 -R -33 - Consideration and/or action approving a Resolution by the City Council of the City of Schertz, Texas authorizing the City Manager to enter into a contract to purchase 3.4096 acres of property currently owned by Guadalupe Blanco River Authority (GBRA) at 22330 IH -35 North, Schertz, Texas. (C. Kelm /S. Williams) 6. Resolution No. 22 -R -32 - Consideration and /or action approving a Resolution by the City Council of the City of Schertz, Texas authorizing the extension of the Independent Audit Services Contract for two years with Patillo, Browne, and Hill. (M. Browne /J. Walters /B. Martin) 7. Resignations to Boards /Commissions /Committees - Consideration and/or action regarding resignations to various Boards /Commissions /Committees. (Council/B. Dennis) • Resignation of Mr. Mateo Garcia - Transportation Safety Advisory Commission 8. Resolution No. 22 -R -26 — Consideration and /or action approving a Resolution by the City Council of the City of Schertz, Texas, authorizing a contract with Fuquay, Inc. relating to the Crest Oak Wastewater Upsize and authorizing the budget expenditures for the project. (B. James /K. Woodlee /J. Shortess) Mayor Gutierrez asked Council if there were any items the wished removed for separate action. As there were none, Mayor Gutierrez called for a motion to approve Consent Agenda items l through 8. Moved by Councilmember Allison Heyward, seconded by Councilmember Michael Dahle to approve consent agenda items 1 through 8. AYE: Mayor Pro -Tem David Scagliola, Councilmember Mark Davis, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember Allison Heyward, Councilmember Tim Brown Passed Discussion and Action Items 9. Resolution No. 22 -R -31- Consideration and/or action approving a Resolution by the City Council of the City of Schertz, Texas accepting the Comprehensive Annual Financial Report - CAFR Fiscal Year 2020 -21. (M. Browne /J. Walters) Mayor Gutierrez recognized Finance Director James Walters and Assistant Finance Director Babett Martin who introduced Mr. Clayton Rodgers with Patillo, Brown and Hill, LLP, who provided information regarding their responsibilities to the audit. He provided a brief presentation regarding the Comprehensive Annual Financial Report and stated that everything was good, the City was in compliance, and they offered an Unmodified Opinion, which is the highest rating the City can receive. He also provided information that was required this year regarding on the Single Audit Report. Mr. Rodgers thanked the Finance Department Staff and others who assisted in the gathering of the information. Mr. Rodgers addressed questions from Council. Mayor Gutierrez called for a motion to approve Resolution No. 22 -R -31 accepting the Comprehensive Annual Report - CAFR Fiscal Year 2020 -21. Moved by Councilmember Jill Whittaker, seconded by Councilmember Allison Heyward to approve Resolution No. 22 -R -31. 4 AYE: Mayor Pro -Tem David Scagliola, Councilmember Mark Davis, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember Allison Heyward, Councilmember Tim Brown Passed 1.0. Ordinance No. 22 -G -14 - Consideration and/or action approving an Ordinance by the City Council of the City of Schertz, Texas amending Chapter 66, Police - Articles I and II of the Code of Ordinances of the City of Schertz, Texas to provide for the establishment of the City of Schertz Police Department; establishing the position of Chief of Police and providing for the employment of Police Officers; prescribing the qualifications, duties and responsibilities of the Chief of Police and Police Officers establishing the jurisdictional boundaries of the department; providing a savings clause, and providing an effective date. First Reading (C. Kelm /M. Bane) Mayor Gutierrez recognized Interim Police Chief Marc Bane who provided a brief presentation regarding the proposed changes. He stated the City of Schertz Police Department is pursuing a "Recognized" status from the Texas Police Chiefs Association's Law Enforcement Best Business Practices Recognition Program. The standards of the Recognition Program require specific language creating a police department and the authority and responsibility of both Officers and the Chief of Police than the current language. The proposed amended ordinance will meet the criteria as set forth Texas Police Chiefs Association's Law Enforcement Best Business Practices Recognition Program. He stated the Texas Chiefs of Police Law Enforcement Recognition Program is a voluntary process where police agencies in Texas prove their compliance with 166 Texas Law Enforcement Best Practices. Being "Recognized" means that a police agency has proven that it meets or exceeds all the identified Best Practices for Texas Law Enforcement. These Best Practices cover aspects of law enforcement operations such as use of force, protection of citizen rights, pursuits, property and evidence management, and patrol and investigative operations. Approving the changes to this ordinance is one step closer to obtaining Best Practices Recognition. Staff recommends approval of amending Chapter 66 Police Articles I and II of the Code of Ordinances. Chief Bane addressed questions from Council. Mayor Gutierrez called for a motion to approve Ordinance No. 22 -G -14 on first reading. Moved by Councilmember Allison Heyward, seconded by Councilmember Jill Whittaker to approve Ordinance No. 22 -G -14 on first reading. AYE: Mayor Pro -Tem David Scagliola, Councilmember Mark Davis, Councilmember Jill Whittaker, Councilmember Michael Dahle, Councilmember Allison Heyward, Councilmember Tim Brown Passed Roll Call Vote Confirmation Mayor Gutierrez recognized City Secretary Brenda Dennis who provided the roll call vote confirmation for Consent Agenda. items 1 through 8 and Agenda items 9 & 10. Information available in City Council Packets - NO DISCUSSION TO OCCUR Mayor Gutierrez stated that Agenda Item I 1 is an informational only item and was provided in the Council packets and can be viewed as well on the City website. 5 It. Monthly Update - on Major Projects in progress /CIP. (B. James /K. Woodlee) Requests and Announcements • Announcements by the City Manager. City Manager Dr. Browne thanked Mr. James Walters and Ms. Babett Martin on the great work they did to get the Audit completed. They did a tremendous amount of work, and it is one of the biggest efforts for the year for the Finance Department. Outstanding work this year! • Requests by Mayor and Councilmembers for updates or information from staff. None at this time. • Requests by Mayor and Councilmembers that items or presentations be placed on a future City Council agenda. No items requested. • Announcements by Mayor and Councilmembers Mayor Pro -Tern Scagliola attended the Kick Cancer event - staff did a great job setting it up, the BVYA Opening Day Celebration where Mayor Boyle of Cibolo threw out the softball, and he was able to throw out the hard ball for the event. He didn't embarrass the City. Councilmember Davis stated that he attended the Schertz Housing Authority meeting Monday. Councilmember Whittaker stated she attended the BVYA Opening Day Parade Celebration, the Ribbon cutting in the City of Live Oak and mentioned there were several cities there celebrating the opening. Feels good that all the cities support the businesses. Councilmember Dahle stated he attended the Kick Cancer event and thanked his dog Maverick for dragging him along for such a great time to finish the race. Councilmember Heyward stated she attended the Ribbon Cutting event in Live Oak and also mentioned it was great to see so many cities out participating, even representatives from At Home attended, she also attended the Guadalupe County Collation for Drug Addiction and Alcohol. Councilmember Brown stated he attended the Kick Cancer event and thanked the Parks and Recreation department for the great work in setting it up. Adjournment Mayor Gutierrez adjourned the meeting at 6:51 p.m. Ralph. Gutierrez, Mayor r.Vw Brenda Dennis, City Secretary 6 Agenda No. 2. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Police Department Subject: Ordinance No. 22 -G -14 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas amending Chapter 66, Police - Articles I and 11 of the Code of Ordinances of the City of Schertz, Texas to provide for the establishment of the City of Schertz Police Department; establishing the position of Chief of Police and providing for the employment of Police Officers; prescribing the qualifications, duties and responsibilities of the Chief of Police and Police Officers establishing the jurisdictional boundaries of the department; providing a savings clause, and providing an effective date. Final Reading (C. Kelm /M. Bane) BACKGROUND The City of Schertz Police Department is pursuing "Recognized" status from the Texas Police Chiefs Association's Law Enforcement Best Business Practices Recognition Program. The standards of the Recognition Program require specific language creating a police department and the authority and responsibility of both Officers and the Chief of Police than the current language. The proposed amended ordinance will meet the criteria as set forth Texas Police Chiefs Association's Law Enforcement Best Business Practices Recognition Program. City Council approved this on first reading at their meeting of March 8, 2022. GOAL To have City Council amend Chapter 66 Police Articles I and II, formally providing for the establishment of the Police Department by the enactment of this ordinance. COMMUNITY BENEFIT The Texas Chiefs of Police Law Enforcement Recognition. Program is a voluntary process where police agencies in Texas prove their compliance with 166 Texas Law Enforcement Best Practices. Being "Recognized" means that a police agency has proven that it meets or exceeds all the identified Best Practices for Texas Law Enforcement. These Best Practices cover aspects of law enforcement operations such as use of force, protection of citizen rights, pursuits, property and evidence management, and patrol and investigative operations. Approving the changes to this ordinance is one step closer to obtaining Best Practices Recognition. SUMMARY OF RECOMMENDED ACTION Amend Chapter 66 Police Articles I and II of the Code of Ordinances of the City of Schertz. FISCAL IMPACT There is no fiscal impact to the City or Department. RECOMMENDATION Amend Chapter 66 Police Articles I and II of the Code of Ordinances of the City of Schertz, and approve Ordinance No. 22 -G -14 on final reading. Attachments Ordinance NO. 22 -G -14 Final ORDINANCE NO. 22 -G -14 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AMENDING CHAPTER 66, ARTICLES I AND II OF THE CODE OF ORDINANCES, CITY OF SCHERTZ, TEXAS TO PROVIDE FOR THE ESTABLISHMENT OF THE CITY OF SCHERTZ POLICE DEPARTMENT; ESTABLISHING THE POSITION OF CHIEF OF POLICE AND PROVIDING FOR THE EMPLOYMENT OF POLICE OFFICERS; PRESCRIBING THE QUALIFICATIONS, DUTIES AND RESPONSIBILITIES OF THE CHIEF OF POLICE AND POLICE OFFICERS ESTABLSHING THE JURISDICTIONAL BOUNDARIES OF THE DEPARTMENT; PROVIDING A SAVINGS CLAUSE, AND PROVIDING AN EFFECTIVE DATE. WHEREAS, pursuant to Texas Local Government Code Section 341.003 a home - rule municipality may provide for the establishment of a police department; and WHEREAS, pursuant to such authority the City of Schertz, Texas has previously established a police department, the head of which is the Chief of Police of the City of Schertz; and WHEREAS, The City of Schertz Police Department is pursuing "Recognized" status from the Texas Police Chiefs Association's Law Enforcement Best Business Practices Recognition Program, and WHEREAS, the standards of the Recognition Program require explicit language creating a police department and the authority and responsibility of both. Officers and the Chief of Police; and WHEREAS, the City Council desire to formally provide for the establishment of the Police Department by the enactment of this ordinance. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF SCHERTZ, TEXAS: Section 1. Chapter 66 Police Articles I and II of the City Code of the City of Schertz Texas is hereby amended as set forth in the attached Exhibit A. Section 2. 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 City Council. Section 3. All ordinances, 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 4. This Ordinance shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. 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 Council hereby declares that this Ordinance would have been enacted without such invalid provision. Section 6. 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 subjectmatter of the public business to be considered at such meeting, including this Ordinance, was given, all as required by Chapter 551, Texas Government Code, as amended. Section 7. This Ordinance shall be in force and effect from and after its final passage, and it is so ordained. BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS, THAT THIS ORDINANCE WAS PASSED and APPROVED on first reading this the 8th day of March, 2022. PASSED, APPROVED and ADOPTED on second reading this the day of , 2022. Ralph Gutierrez, Mayor ATTEST: Brenda Dennis, City Secretary (CITY SEAL) CHAPTER 66 POLICE ARTICLE I AND II ARE HEREBY AMENDED AS SET FORTH BELOW [Deletions are shown as strikethrough and additions are shown as underscore] Chapter 66 POLICE ARTICLE L IN GENERAL Sec. 66 -1. Establishment of police department; jurisdiction. There is herebv established a police department for the Citv of Schertz. The police department shall be composed of the Chief of Police and such other police officers and employees as the city council may provide. The jurisdiction of the police department shall be the corporate limits of the City and that propertlying outside the city limits, which is owned by the City. When outside the jurisdictional limits of the City, police officers of the City of Schertz shall have and may exercise such authority and powers as may be granted to them as peace officers under the constitution and laws of the State of Texas and of the United States. Page 3 of 6 I �61 Mw �ililillm�� 11 WIN IV NA Sec. 66 -1. Establishment of police department; jurisdiction. There is herebv established a police department for the Citv of Schertz. The police department shall be composed of the Chief of Police and such other police officers and employees as the city council may provide. The jurisdiction of the police department shall be the corporate limits of the City and that propertlying outside the city limits, which is owned by the City. When outside the jurisdictional limits of the City, police officers of the City of Schertz shall have and may exercise such authority and powers as may be granted to them as peace officers under the constitution and laws of the State of Texas and of the United States. Page 3 of 6 Sec. 66 -2. Chief of Police. The Chief of Police shall be appointed by the City Manager and be in charge of the police department. The Chief of Police shall organize the Department in conformity withthe laws ofthe state and ordinances oftheCity. The Chiefof Police may promulgate policies, procedures, rules, directives and orders for the administration of the department, including, but not limited to discipline within the Department. Sec. 66 -3. Qualifications, appointment and powers of police officers. (a) All police officers of the City of Schertz shall be appointed, promoted, disciplined and removed inaccordance withthe provisions of the City of Schertz Police Department Standard Operating Procedures and the City of Schertz Personnel Policy, as amended. No person may be appointed or continue to serve as a police officer who does not comply with the licensing requirements of the Texas Commission on I.aw Enforcement. (b) Police officers of the City shall possess such power and authority as is ivgtopeace officers under the laws of the State of Texas and the ordinances of the City. (c) All personnel of the police department shall be bound by the most current directives, orders, rules, regulations, policies and procedures of the Schertz Police Department and City of Schertz. Failure to abide thereby shall subject the violating personnel to such disciplinary action as may be determined by the Chief of Police and / or City Management within the limits of state law and city ordinance. Secs. 66 -4 66 -20. Reserved. ARTICLE II. RESERAIE PO ICEM RESERVED C S'�6RSM"I I .4 Mill W milli NIT C S'�6RSM"I I See. 66 22. Training. - the -- - -- The - - - - thfough the be fe eity . eity managef, aeting ehief of poliee, shall fesponsible enswing that the polieies and fules of the f6fee pfoee"fes. are adhefed to, and for- the development of tr-ainin pfogfams and opefating 1976 14; OFd. No. 79 G 13, W, 7 17 979) (Code —§4 § Tex. Loeal standards, G ovemmenEo de, 34.raj. Page 5 of 6 - -- -- -- -- - -- - .. N ON .- ..- .- -- - - - - 1074 9 1 - - - . . ri , - . - Page 5 of 6 Page 6 of 6 1*041,111,im I CHAPTER 66 POLICE ARTICLE I AND 11 ARE HEREBY AMENDED AS SET FORTH BELOW 0 Ak' N.- Sec. 66-2. Chief of Police. The Chief of Pblice shall be appointed by the City Manager and be in charge of the poli(s andordinancesoittiu-mity. I ftel't-netotfolice may promulgate policies, procedures, rules, directives ar,-� orders for the administration of the department, including, but not limited to discipline within Di-,partment. . EMISMA111 � 11AYCKU (a) All police officers of the City of Schertz shall be appointed, promoted, disciplined and removed in accordance withthe provisions of the City of Schertz Police Department Standard Operating Procedures and the City of Schertz Personnel Policy, as amended. No person may be appointed or continue to serve as a police officer who does not comply with the licensing requirements ofthe Texas Commission on l.aw Enforcement. 01H 01 (c) All personnel of the police department shall be bound by the most current directives, orders, rules, regulations, policies and procedures of the Schertz Police Department and City of Schertz. Failure to abide thereby shall subject the violating personnel to such disciplinary action as may be determined by the Chief of Police and / or City Management within the limits of state law and city ordinance. Agenda No. 3. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Information Technology Subject: Resolution No. 22 -R -34 - Consideration and /or action approving a Resolution by the City Council of the City of Schertz, Texas approving the renewal of existing three -year support agreement for ARCGIS mapping software supplied by Environmental Systems Research Institute, Inc. (ESRI). (B. James /M. Clauser) BACKGROUND The City of Schertz has used the ARCGIS mapping software to support a wide variety of City activities including Public Safety, Economic Development, Planning and Developments Services, Engineering, Utility Billing, Public Works, etc. The system has been in place since the creation of the GIS department in 2010 and ESRI is the sole source supplier of this system. GOAL The goal for this action is to renew the three -year support agreement for this software. This application serves as the back -end geographical database for first responders, developers, inspections, utilities management, and more. Renewal of the three -year support agreement with ESRI will allow the City to benefit from the enhanced web services offered by ESRI as well as allowing the City to deploy the application to the enterprise for a reduced per -user licensing cost versus purchasing individuallicenses. COMMUNITY BENEFIT Ongoing use of this software serves many of the City's departments by managing, verifying and updating geographical data. This data is used daily by public safety to update addressing and locations for dispatching first responders. It also provides accurate up -to -date maps for planning and development activities, providing accurate location data for water meters, utility lines, storm water management, etc. SUMMARY OF RECOMMENDED ACTION The Staff recommends that the Council approve the attached agreement extending support for this mission - critical system for another three years. FISCAL IMPACT This expenditure is a budgeted item and is included in the annual budget request for the Information Technologies Dept. The cost is $38,750 per year or $116,250 for 3 years. RECOMMENDATION The Staff recommends that the Council approve the attached agreement extending support for this mission - critical system for another three years. Attachments ESRI Renewal Agreement Res 22 R 34 SCIENCE OF esr i WHrW 380 New York Street 909.79].285] eshzom Redlands, California 92373-8100 USA info@esri.com "THIS PURCHASE ORDER IS GOVERNED BY THE TERMS AND CONDITIONS OF THE ESRI SMALL MUNICIPAL AND COUNTY GOVERNMENT EA, AND ADDITIONAL TERMS AND CONDITIONS IN THIS PURCHASE ORDER WILL NOT APPLY" Y �� Y �� THE SCIENCE eksri � O a HE m RESOLUTION NO. 22 -R -34 A RESOLUTION BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AUTHORIZING A RENEWAL OF A SOFTWARE MAINTENANCE AGREEMENT WITH ENVIRONMENTAL SYSTEMS RESEARCH INSTITUTE, INC. FOR GIS SOFTWARE, AND OTHER MATTERS IN CONNECTION THEREWITH WHEREAS, the City of Schertz (the "City ") previously entered into a software maintenance agreement with Environmental Systems Research Institute, Inc. for GIS mapping software in 2019, the City desires to renew the maintenance agreement for another three -year term; and WHEREAS, the cost of a three -year Small Municipal and County Government Enterprise Agreement (SGEA) is $38,750 per year, or $116,250 for three years; and WHEREAS it is of benefit to the City to renew the agreement because it will provide a lower cost per unit for licensed software, there will be substantially reduced administrative and procurement expenses, and software support will allow departments to function more efficiently; now, therefore, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS THAT: Section 1. The City Council hereby authorizes the City Manager to execute and deliver the Agreement in substantially the form set forth on Exhibit A. Section 2. The recitals contained in the preamble hereof are hereby found to be true, and such recitals are hereby made a part of this Resolution for all purposes and are adopted as a part of the judgment and findings of the City Council. Section 3. All resolutions, or parts thereof, which are in conflict or inconsistent with any provision of this Resolution are hereby repealed to the extent of such conflict, and the provisions of this Resolution shall be and remain controlling as to the matters resolved herein. Section 4. This Resolution shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. If any provision of this Resolution or the application thereof to any person or circumstance shall be held to be invalid, the remainder of this Resolution and the application of such provision to other persons and circumstances shall nevertheless be valid, and the City Council hereby declares that this Resolution would have been enacted without such invalid provl Is l On. Section 6. It is officially found, determined, and declared that the meeting at which this Resolution 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 Resolution, was given, all as required by Chapter 551, Texas Government Code, as amended. Section 7. This Resolution shall be in force and effect from and after its final passage, and it is so resolved. PASSED AND ADOPTED, this 22nd day of March 2022. CITY OF SCHERTZ, TEXAS Ralph Gutierrez, Mayor ATTEST: Brenda Dennis, City Secretary (CITY SEAL) Exhibit A Agenda No. 4. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: City Secretary Subject: Resignations and Appointments to Boards / Commissions /Committees - Consideration and/or action regarding the resignations and appointments to various Boards /Commissions /Committees (Council/S. Edmondson) • Resignation of Mr. Margarito Banales from the Schertz Library Advisory Board BACKGROUND City Secretary's office has received notice of the resignation of Mr. Margorito Banales of the Schertz Library Advisory Board. City Secretary's office received a letter from Ms. Patti. Paulson, Board Chair of the Schertz Library Advisory Board updating the status of Mr. Banales. Staff recommends accepting the resignation of Mr. Margorito Banales. Attachments 03 -07 -2022 Library update COMMUNrrY SCHERTZ PUBLIC LIBRARY SEWICE MELISSA UHLHORN SCHIERTZ I OPPORTUN17Y LIBRARYDIRECTOR Patti Paulson, Board Chair M,-�j 798 Schertz Parkway Schertz, Tx 78154 A 210.619.1700 schertfibrary.orLj Agenda No. 5. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: City Secretary Subject: Resignation - Consideration and /or action regarding the acceptance of the Retirement Resignation letter from City Manager Dr. Mark Browne. BACKGROUND On March 4, 2022, the Mayor and City Council received a Retirement Resignation letter from City Manager Dr. Mark Browne. In his letter he stated he is retiring from his position as City Manager and his last duty day will be November 23, 2022, with accrued leave, the final date of employment would be January 2, 2023. City Council will formally accept his Retirement Resignation. Attachments Dr. Browne Retirement .19 1 �- 111�4 M .1 MWIll FIEN—AMUT-TTIT, 1�� = E�� $� I am letting you know of my intent to retire as the City Manager of the City of Schertz. It has been my honor to serve as the City Manager. I believe the City has accomplished a great deal during my tenure and is well positioned for the future. It is simply time for me to retire. new police chief, improving morale and teamwork among our departmental leadership team, 2nd seeing through the first class of the Emerging Leaders Program. Therefore, I am requesting November 23, 2022 as my last day of service. This should give council plenty of time to find a successor. I will give full attention to accomplishing as much as possible in the next few months and make the transition as seamless as possible. Agenda No. 6. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Information Technology Subject: Ordinance No. 22 -T -16 - Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas authorizing an adjustment to the FY 2021/2022 budget to allocate funds for the Schertz Council Facilities Audio and Video Systems Upgrade Project in the amount of $451,686.00 First Reading (B. James/ M. Clauser) BACKGROUND The City of Schertz Council Chambers was renovated for its current use nearly 20 years ago. At that time the video and audio systems installed were state of the art. Since that time a few upgrades were made to the sound system to improve overall sound quality in the main room, but no major improvements were made to either the sound system or the video systems to accommodate changing technologies and the need to support remote / virtual meetings as allowed by state law. There is a need to improve the quality of recordings for broadcasting meetings on the internet and on the planned Schertz Public Access channel as provided for by our cable providers. Working with various stakeholders the staff issued an RFP for improvements to the audio and video systems in the Council Chambers Main Room. Three proposals were submitted. The selected bid is in the amount of $451,686.00. This ordinance will adjust the dedicated PEG fund to provide funding for this project. GOAL This ordinance will provide funding to allow the City staff to upgrade the council meeting facility to improve the quality of live and recorded meetings on both the internet and on the planned cable channel, streamline management of Council meeting minutes, allow for electronic voting, etc. COMMUNITY BENEFIT Allocating the funds needed to perform this upgrade will improve the quality of live and recorded meetings on both the internet and on the planned cable channel. The new systems will better support meetings where there is a need for virtual and / or remote attendance by Council Members, Staff and others presenting agenda -based information to the Council. In addition, the new system will create the option to streamline the presentation and posting of meeting minutes, allow Council and others using the facility to record votes electronically and improve communications by giving Board and Council Members additional tools to watch presentations, ask questions and provide feedback. SUMMARY OF RECOMMENDED ACTION Staff recommends that Council approves Ordinance No. 22 -T -16 adjusting the FY 2021/2022 PEG fund budget in the amount of $451,686.00 FISCAL IMPACT Funding will be provided by using the City's Federally mandated PEG (Public Education and Government) fund. The current balance of the fund is more than sufficient to accommodate this project. I R DEVIVI1►l1MIN 17 111 [112 Staff recommends that Council approval Ordinance 22 -T -16 authorizing the adjustment to the FY 21122 PEG Fund budget for the Schertz Council Facilities Audio and Video Systems Upgrade Project. Attachments Ord 22 T 16 ORDINANCE NO. 22-T-16 AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AUTHORIZING AN ADJUSTMENT TO THE FISCAL YEAR 2021- 2022 BUDGET TO PROVIDE ADDITIONAL FUNDING FOR UPGRADES TO THE COUNCIL CHAMBERS AUDIO AND VIDEO MANAGEMENT SYSTEMS PROJECT, REPEALING ALL ORDINANCES OR PARTS OF ORDINANCES IN CONFLICT WITH THIS ORDINANCE: AND PROVIDING AN EFFECTIVE DATE. (First Reading) WHEREAS, pursuant to Ordinance 21 -T -38, the City Council of Schertz, Texas, (the "City ") adopted the budget for the City for the fiscal year 2021 -2022 (the "Budget "), which provides funding for the City's operations throughout the 2021 -2022 fiscal year; and WHEREAS, It was determined that the council chambers facility is in need of upgrades to the audio and video control systems in order to meet the new requirements for virtual and remote attendance in City meetings, as well as provide high quality recordings of City government meetings for broadcast on the City's planned PEG channel, as well as for re- broadcast on the City's web portal; and, WHEREAS, the City staff released Request for Bids (RFB) for upgrading the audio and video systems in the council chambers in order to meet new requirements for virtual and remote attendance, as well as providing high quality recordings of City government meetings for broadcast on the City's planned PEG channel, as well as for rebroadcast on the City's web portal and, WHEREAS, RFP's were received and reviewed by staff, and TROX, Inc. of San Antonio, Texas was selected as the best value by submitting a bid in the amount of $451,686.00 and, WHEREAS, the City Staff is requesting the City to authorize a budget amendment to allocate $451,686.00 from the dedicated PEG fund to the City of Schertz general fund for the upgrades to the Council chamber facilities; and, WHEREAS, the current balance of the PEG Fund stands at approximately $987,000.00 with an additional PEG funds expected to be more than sufficient to cover the balance required over the rest of the current FY, and that should additional PEG funding not meet expectations any difference will be taken from the City's reserves. WHEREAS, City Staff recommends that the City Council of the City adjust the Budget and approve the ordinance. BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS THAT: Section 1. The City shall amend the FY 2021 -2022 Adopted Budget to allocate $451,686.00 to the City of Schertz general fund for upgrades to the council chambers facilities. Section 2. 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 City Council. Section 3. All ordinances, 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 4. This Ordinance shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. 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 applicationof such provision to other persons and circumstances shall nevertheless be valid, and the City Council hereby declares that this Ordinance would have been enacted without such invalid provision. Section 6. 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 subj ectmatter of the public business to be considered at such meeting, including this Ordinance, was given, all as required by Chapter 551, Texas Government Code, as amended. Section 7. This Ordinance shall be in force and effect from and after its final passage, and it is so ordained. PASSED AND ADOPTED, on first reading this 22nd day of March, 2022. PASSED AND ADOPTED, on second and final reading this 5th day of April, 2022. CITY OF SCHERTZ, TEXAS Ralph Gutierrez, Mayor ATTEST: Brenda Dennis, City Secretary (CITY SEAL) Agenda No. 7. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Information Technology Subject: Ordinance No. 22 -T -17- Consideration and /or action approving an Ordinance by the City Council of the City of Schertz, Texas authorizing an adjustment to the FY 2021/2022 City of Schertz budget to provide an additional $65,835.00 from the dedicated PEG fund for the Master Communication Plan. First Reading (B. James /M. Clauser) BACKGROUND The planned communications network will create the infrastructure needed to provide citizens and neighboring communities with access to the various community assets, governmental actions and other event and sites of interest through live and recorded streaming to a Public Education and Government channel (known as a PEG channel). Funding is made available through the use of PEG funds as allowed by Federal law regarding the use of PEG funds, and supplemented with funding from the ARP program recently passed by Congress in 2021. This ordinance will increase the budgeted amount for this project to $565,835.00 GOAL To provide additional funding authorization to allow the City staff install a City -wide communications network based on a combination of wireless and wired technologies that will connect all existing City assets while providing a cost - effective path for adding additional sites as required. Taking advantage of greater efficiencies offered by using high -speed wireless systems, we can effectively manage and monitor remote sites such as lift stations, pumping stations and water towers. In addition, we can use the proposed City -wide network to provide timely, targeted information to field staff wherever and whenever it's needed by leveraging existing mobile technologies to safely and securely access City data resources directly from the field. Finally, with the addition of secured, high- speed wireless connectivity, Public Safety personnel can respond more effectively to situations as well as allow them to submit reports, update databases, etc. from the field. COMMUNITY BENEFIT There are several direct benefits realized by deploying the network as proposed: 1. By deploying and managing the network internally, as opposed to outsourcing our communications needs, the City will save more than $1 million over the anticipated life span of the system (10 years) 2. Using wireless technologies to connect City assets directly is the most cost - effective way to knit the City together in a resilient, reliable network. This network, as proposed would be capable of expansion as needed with a minimal investment. New nodes can be added by merely adding low -cost high -speed radios at the site and pointing them at the closest collection point. 3. Using existing mobile technologies over a City -owned secure City -wide network means providing real -time access to City resources by field staff. This ensures that they can stay in field longer, reducing travel time, fuel costs, vehicle wear and tear, etc. Staff can access email, access and modify information residing in systems such as InCode, Court, CAD /RMS, submit reports, print, etc. using this proposed network. 4. The ability to remotely manage and secure City assets allows City staff to focus on taking care of business as opposed to having to visit each site manually to perform inspections, etc. This network will provide high -speed connectivity to areas such as parks, playgrounds and other remote City sites creating a platform for enhanced security monitoring and providing greater safety for our residents. SUMMARY OF RECOMMENDED ACTION Staff recommends that Council adjusts the FY 2021/2022 FY budget dedicated PEG fund by allocating an additional $65,835.00 FISCAL IMPACT Staff has identified available funding by applying available "PEG" funds and supplementing this with funding from the ARP funds provided by Congress in 2021. The PEG fund is a dedicated fund that comes from fees paid to the City annually by the cable companies, and is designed to provide funding to municipalities to build the communications infrastructures needed to support the creation of content and other systems needed to manage the City's planned PEG channel. Currently, the fund has a balance of more than $900K. This fund is replenished annually by approximately $70K — $80K. The City will apply $150,000 from the ARP fund and the balance from the PEG funds. The current FY budget allocated $350,000 to this project. Estimates show that an additional $65,835.00 will need to be allocated to complete the project as designed. It is expected that the deployment will take place during the current FY and continue into the next FY and that funding from the PEG fund for the upcoming FY will be included in the 2022 -2023 budget presented to Council later this year. RECOMMENDATION Staff recommends that Council adjusts the FY 2021/2022 FY budget dedicated PEG fund by allocating an additional $65,835.00 Attachments Ord 22 T 17 Master Communications ORDINANCE NO. 22-T-17 AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AUTHORIZING AN ADJUSTMENT TO THE FISCAL YEAR 2021- 2022 BUDGET TO PROVIDE ADDITIONAL FUNDING FOR THE MASTER COMMUNICATIONS NETWORK PROJECT, REPEALING ALL ORDINANCES OR PARTS OF ORDINANCES IN CONFLICT WITH THIS ORDINANCE; AND PROVIDING AN EFFECTIVE DATE. (First Reading) WHEREAS, pursuant to Ordinance 21 -T -38, the City Council of Schertz, Texas, (the "City ") adopted the budget for the City for the fiscal year 2021 -2022 (the "Budget "), which provides funding for the City's operations throughout the 2021 -2022 fiscal year; and WHEREAS, the Budget allocated $350,000 from the dedicated PEG fund and $150,000 from the ARP funds to fund the city -wide master communications network for a total of $500,000, WHEREAS, the cost proposal for phases 1 through 4 submitted by Scientel, LLC of Aurora Il in the amount of $565,835.00 was reviewed and approved by staff, WHEREAS, the City Staff is requesting the City to authorize a budget amendment to allocate an additional $65,835.00 from the FY 2021 / 2022 dedicated PEG fund to complete phases 1 through 4 of the Master Communications Network Project and, WHEREAS, the current balance of the PEG Fund stands at approximately $987,000.00 with an additional PEG funds expected to be more than sufficient to cover the balance required over the rest of the current FY, and that should additional PEG funding not meet expectations any difference will be taken from the City's reserves. WHEREAS, City Staff recommends that the City Council of the City adjust the Budget and approve the ordinance. BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS Section 1. The City shall amend the FY 2021 -2022 Adopted Budget to allocate an additional $65,835.00 from the City of Schertz PEG fund for implementation of phases 1 through 4 of the Master Communications Network Project. Section 2. 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 City Council. Section 3. All ordinances, 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 4. This Ordinance shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. 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 applicationof such provision to other persons and circumstances shall nevertheless be valid, and the City Council hereby declares that this Ordinance would have been enacted without such invalid provision. Section 6. 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 subj ectmatter of the public business to be considered at such meeting, including this Ordinance, was given, all as required by Chapter 551, Texas Government Code, as amended. Section 7. This Ordinance shall be in force and effect from and after its final passage, and it is so ordained. PASSED AND ADOPTED, on first reading this 22 t day of March, 2022. PASSED AND ADOPTED, on second and final reading this 5th day of April, 2022. CITY OF SCHERTZ, TEXAS Ralph Gutierrez, Mayor ATTEST: Brenda Dennis, City Secretary (CITY SEAL) Agenda No. 8. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Planning & Community Development Subject: Ordinance No. 22 -S -11 - Conduct a public hearing and consideration and /or action on a request to rezone approximately 9 acres of land from General Business District (GB) and Pre - Development District (PRE) to General Business District (GB) and General Business District -2 (GB -2), generally located approximately 3,000 feet east of the intersection of Schwab Road and IH -35 access road, also known as a portion Comal County Property Identification Number 78178, City of Schertz, Comal County, Texas. First Reading (B. James /M. Harrison) BACKGROUND Owner: I -35 Investments Properties, LP Applicant: Southern Tire Mart Three (3) public hearing notices were mailed to the surrounding property owners within two hundred feet (200') of the subject property on January 28, 2022, with a public hearing notice published in the "San Antonio Express" on March 2, 2022, prior to the City Council public hearing. At the time of this staff report Staff has received one (1) response that is neutral to the zoning request. GOAL The goal is to rezone approximately 9 acres of land from General Business District (GB) and Pre - Development District (PRE) to General Business District (GB) and General Business District -2 (GB2). COMMUNITY BENEFIT The community benefit is to promote safe, orderly, efficient development and bring about the City's vision of future growth. SUMMARY OF RECOMMENDED ACTION The applicant is requesting to rezone the approximately 9 acres of land from General Business District (GB) and Pre - Development District (PRE) to General Business District (GB) and General Business District -2 (G132). The 9 acre tract is a portion of the remaining approximately 114 acre tract. The Comprehensive Land Use Plan (CLUP), through the Future Land Use Plan and Northern Schertz Sector Plan, designates this subject property as Commercial Campus and Agricultural Conservation. The objective of the Commercial Campus land use designation is intended to accommodate the development of lower intensity commercial and office uses that utilize a variety of mostly office, flex - office, light industrial, and creating a campus like environment. Agricultural Conservation land use designation is to have the rural /agricultural type development and minimum open space of 70 %. In the Schertz Sector Plan it states under the Agricultural Conservation land use designation that "The community's vision for this area may also evolve over time and should be reevaluated based on market trends and community desires during future planning efforts ". The property is 1,100 feet deep with approximately 750 feet of Commercial Campus land use designation and approximately 350 feet of Agricultural Conversation land use designation. This creates a challenge with the property owner that the land is spilt between two land use designations as it poses the issue of how they are able to develop the property. If we held firm to the land use designation boundaries the back portion that is under Agricultural Conservation would not be developed and would have access limitations as it will be cut off from I -35. The boundary between the two land use designations are often generalized locations unless there is a physical feature that sets the boundary such as a roadway or a drainage area. The intention with the current land use designations is to not have a hard, fast line on the property, but to instead flex the designation lines, which is good planning practices, to things like property lines, built features or natural features. • Comprehensive Plan Goals and Objectives: The proposed rezoning of this property to General Business District (GB) and General Business District -2 (GB2) is in conformance with the Comprehensive Land Use Plan as it will support the office and light industrial uses set forth in the General Business District (GB) and General Business District -2 (G132). Within the 2002 Comprehensive Land Use, under Key Features of the Land Use Plan, it states that "Classifying significant acreage within the ETJ as rural development to preserve environmental resources and maintain a reserve of vacant land and open space outside the incorporated City. As development matures in this area higher density land use may be considered ". In keeping that in mind the property only has 350 feet of agricultural conservation land use identified on their property, but when looking at the overall picture beyond the property boundary, there is still 2,200 feet of agricultural conservation remaining. • Impact of Infrastructure: The proposed zone change would have to route water and sewer from Schwab Road to their property. There is water and sewer located along the right -of -way of Schwab Road and would be taken from this area to the subject property. • Impact of Public Facilities /Services: The proposed zone change would have minimal impact on public services, such as schools, fire, police and parks, and would have an increase in service area for water and sewer. • Compatibility with Existing and Potential Adjacent Land Uses: The subject property is surrounded by several parcels that are zoned General Business District (GB), which are in line with maintaining the lower intensity along the frontage of IH 35 and pushing the light industrial away from IH 35. FISCAL IMPACT None RECOMMENDATION The property has the land use designations, under the Schertz Sector Plan for Northern Schertz, as Commercial Campus and Agricultural Conservation. The Commercial Campus land use designation encourages the development of lower intensity commercial, office, flex - office, and light industrial uses. The Agricultural Conservation land use designation is intended to maintain the rural /agricultural uses. The land use designation lines that illustrate approximately 750 feet of Commercial Campus land use designation and approximately 350 feet of Agricultural Conservation land use designation has created this hard and fast line on the property, which leaves the property owner to determine how to develop accordingly. However, this line is not intended to split a property the way that it has. The concept for this area, where you take the railroad tracts and Interstate Highway 35 and notice the trend of commercial along the frontage and agricultural conservation along the back, but then determining whether we want it to be 400 feet, 700 feet, or 1,000 feet. Good planning practices are that we generally try to use property lines, built features, or natural features instead of using hard fast lines. Therefore, with the information provided the rezoning to maintain the General Business District (GB) along the IH -35 frontage and have the General Business District -2 (G132) in the back meets the intention of the Comprehensive Land Use Plan as identified under the Commercial Campus land use designation. Staff feels that rezoning the portion of the property to General Business District -2 (GB2) does not negatively impact the larger area left Agricultural. Conservation nor does adjusting the zoning boundary line of the General Business District (GB) to still maintain that lighter intensity commercial along IH 35. Therefore, staff recommends approval of the requested zone change for approximately 9 acres to General Business :District (GB) and General Business District -2 (GB2). The Planning and Zoning Commission held a public hearing on February 9, 2022, where they made a recommendation of approval to the City Council with a vote of 7 -0. Attachments 1662_Ordinance 22 -5 -11 I -35 Rezoning Rezone Exhibit Aerial Map Public Hearing Notice Map Public Hearing Notice Response ORDINANCE NO. 22-S-11 AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AMENDING THE OFFICIAL ZONING MAP BY REZONING APPROXIMATELY 9 ACRES OF LAND TO GENERAL BUSINESS DISTRICT AND GENERAL BUSINESS DISTRICT -2, GENERALLY LOCATED 3,000 FEET EAST OF THE INTERSECTOIN OF SCHWAB ROAD AND IH -35 ACCESS ROAD, ALSO KNOWN AS COMAL COUNTY PROPERTY IDENTIFICATION NUMBER, 78178, COMAL COUNTY, TEXAS. WHEREAS, an application to rezone approximately 9 acres of land located 3,000 feet east of the intersection of Schwab Road and IH -35 access road, also known as Comal County Property Identification Number 78178, and more specifically described in the Exhibit A 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 February 9, 2022, the Planning and Zoning Commission conducted a public hearing and, after considering the Criteria, made a recommendation to City Council to approve the requested rezoning; and WHEREAS, on March 22, 2022, 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. BE IT ORDAINED 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, is hereby zoned General Business District (GB) and General Business District -2 (G132). 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. Approved on first reading the 22nd day of March 22, 2022. PASSED, APPROVED AND ADOPTED on final reading the 5th day of April, 2022. Ralph Gutierrez, Mayor ATTEST: Brenda Dennis, City Secretary (SEAL OF THE CITY) ENGINEERING + SURVEYING EXHIBIT "A" A METES AND BOUNDS DESCRIPTION OF A 9.000 ACRES OF LAND 119133 Jones Maksberger Road Suite 102 San Antonio, T3; 78216 wvvw.upengineering.com A metes and bounds description of a 9.000 acre (392,043 sq. ft.) tract of land, out of 113.93 acre tract, recorded in Document No. 200806006653, Official Public Records of Comal County, Texas (O.P.R.C.C.T.), being situated in the C M Gahagan JR Survey No. 258, Abstract No. 182, situated in Comal County, Texas, being more particularly described as follows: BEGINNING: at a found 1/2" iron rod, on the southernmost corner of a 86.75 acre tract, recorded in Document No. 9806003256, (O.P.R.C.C.T.), being a point on the northeast boundary line of a 82.06 acre tract, recorded in Volume 84, Pages 491 -492, (O.P.R.C.C.T.), the west corner of the aforementioned 113.93 acre tract, and the herein described tract, having a State Plane Grid Coordinate NAD 83, Texas South Central Zone, (N: 13,783,658.43, E: 2,220,663.96); THENCE: North 45 °22'03" East, departing the northeast line of the aforementioned 82.06 acre tract, along and with the southeast line of 86.75 acre tract, a distance of 375.21 feet to a set 1/2" iron rod with a plastic green cap marked "UP ENG & SURVEY ", the north corner of the herein described tract; THENCE: South 30 °05'25" East, departing the southeast line of the aforementioned 86.75 acre tract, a distance of 1,108.88 feet to a set 1/2" iron rod with a plastic green cap marked "UP ENG & SURVEY ", on the north right of way line of Interstate Highway 35, a variable width right -of -way (minimum 300' width), the east corner of the herein described tract, from which a found 1/2" iron rod, bears North 54'21'11" East, a distance of 1,224.37 feet for reference; THENCE: South 54 °21' 11" West, along and with the north right of way line of Interstate Highway 35, a distance of 364.91 feet to a set 1 /2" iron rod with a plastic green cap marked "UP ENG & SURVEY ", the east corner of 82.06 acre tract, the south corner of the herein described tract; THENCE: North 30 °05'25" West, departing the north right of way line of Interstate Highway 35, along and with the northeast line of 82.06 acre tract, a distance of 1,050.00 feet to the POINT OF BEGINNING and containing 9.000 acres (392,043 sq. ft.) more or less. Notes: 1) Bearings shown hereon are grid bearings of the Texas State Plane Coordinate System, South Central Zone (4204), NAD83, US Survey Feet. 2) Record information shown hereon is based upon a public records search performed by UP Engineering + Surveying. Owner name shown as provided. Record volume and page noted document provided by others. 3) Date of Survey: 12/16/2021 UP Engineering + Surveying 11903 Jones Maltsberger Rd. Suite 102 San Antonio, Texas 78216 TBPELS Firm No. 1.0194606 / OF r � \STS ADRIAN E. -REYES Page 1 of 1 rrn +» Page 1 of 1 Owner: 135 Investment PROJECT NO 31033 2LL1,RED A REYES_. MIKIINs":L FfijOCREPNL W SANC!j-'j_ L'NEU WORK DATE 12/16/21,21_ LP Address: 61 Pipers Walk Sugar Land, Texas 77479 Phone #: (210) 960-2750 Property Owners within 200 feet Property within 200 Feet #1: Land Use: Vacant Zoning: Partially Zoned GB, Partially Zoned DVL Subdivision Name: A-182 SUR -258 C M GAHAGAN, Acres 45.063 Owner Name: Howard & Alice Schaefer Property Address: 0 S IH 35 Schertz, Texas Property ID: 75468 Recording Information: 9606025648 PROPERTY LINE 82.06 ACRE 7 ACT NOCPNI T N- NO, '94E06071606 VOL. 84 PG, 49',. -192 0,P.R,r C.F, Land Use: Vacant Zoning: Out of City Limits (DVL) Subdivision Name: A-182 SUR 258 U C M GAHAGAN, Acres 7.96 Owner Name: Sandra Reeh Property Address: 0 FM 482 New Braunfels, Texas Property ID: 75480 Recording Information: 0806003256 PREPARED FCIT SCALE: 1"=100' DUFF RE-AL ESTA-1E, LLC � M '111 -- 100 75-6 —100 2EBEA DING PORTION OF 113.93 ACRE TRACT MENT NO 200806006652 O'P R.C. C, 1, LFGEND IRA IN'. IF, (", 1— ) 0 . '/C MEN OCC NN— O'N".. O N DID .11 117 NF I ARD D ."'LAT' ANF." TOPIRMEE IRD—E P-1 MIT RVO .1 -1 PRINT OF REFERENCE ca A A F.1 I IA IE I U IS I I C 'EDA'S' "If SO A 'U"' T Z� D Cl EMA AND `111 HAL—A DIF MBIT cou— EIIS C—El Co-ty, —e x.5 FIN E E DESCRIPTION N�D RPF"R" I', R LO, U., 11:PA 1. " "A"I" IQ I., I IF,, I P, 1 "111101 — PI D"11 RN111 'KI ZLEDUIKP 1HUILLI IIII OEPI 01 —E1AS( L1JF1 IAF) — STIUA -1 NIN OR' 'N(1( 'I, SO '11-F 111 DO, II:. SIT I' I' IOICTI, 11111 FOR NXILIVID: Al A MILIN 12' E111 E01 , DI INIF I'll 'I ICIIIOSI ("HIM, OF I L6 11 YCID 1FAA'I FICIADIII 11 HOKIIIIINIF ", 1— Ii -, RIIIF LAID" On ENE N)lZIIIIA.il13()1\I)AR1 Ni.OJ'A FIT 1'— 112 0 THATRIIN �LFEIIN IIYFI�.W. IHENCD OKIL I5;O'FS EASY. "'L "' 'O ITT III Y LPAST "'U" �)E THE IT OR ONED 201 ACE T— I, ILONC, III TO FIT HIF EO-R—T LINE . 9(—A(RFTN1-A NISUANChOF.—I IIE T I'll 11 11" 11 11 1 EF "B' . 11 HN, F'111 AIN 'DEAST'11H1'1'1'�E L;IT'LIUARN'11 I, FIG I, ILHEIDB! -UTL 14)-25' FAST, 1) YITAR I INC TIRE SOUPWAST I REF OF 1 iC1 \ITNHO 'F[D AS 71 AT Rl� TRAI H I UISTA— (11 A-8 FLFT 10 A ALL 1,2' fRON LOR WITH A ITLAI111 ON III i I, "UP UDI; & SURVEY ; ON THL NOIIA OU 11 ILID-1,� A NETO I.TITI" IDIT, 1) 011IT 1111 TIII F11111, PLIALT III VIAY I III, OF FIT III :�;(WWAI IS, AT( AD AND LFILIH III � NORDIPAST LINF OF EIR, N(Cr -11A(1. I 11ALR L, �; LR 1111H 11+1 TO ILIF LFRII OD .—IIII(s AND (1111—Al A, L. 11 (31, IQ, I I I III IaI R 1 111 GENERAL NOTES. I 111TRIN-1 F—A DIONFRINIA UIALL.IF I NO, 20E8060061. ONDOIRL ACB-11 RECORDS OF .— COUNTY, 11 — I, FEARING BASIS - 1E— .111 ALTIS COORDINATE SMEA, FMIH IFEUNI EON= NORTH ANERCAN DATUM OF ISEL (2011), JS - SURVEY MM 1 5—EC PROPERTY COICTEND ADS) (39-43 FELT I ACRE TRACT OUT OF A 113 'EFTEMBER 10, 2021 A' 8'. M A M 4 I'DWIDED BY ALA MO TIRE COMPANY B. N.100.y..,Fl..dpl.in..it..nthi.p,.p.fty. 6. Firt4OO feet ,fPrp,rty,h,litmainz,n,dGB,appmximately3.34acres. 7. Remaining Property shall be —I GB-2, approximately ERIE -- (YEITIRCATION 1 IT D, REAL ILSTATE, LLC. THAT HE I$ MLY J� FLESSIDNED HEREBY ET TO ILLIT ,EED PERFESSLOOLD ALLO SH— OF THE STATE OF TEXAS, AND FIERTHER it THIS PIA' r OF EUWEY ADD SHE PRELEMY DESCRIPTLON SET FORTH HEREON TPAS BEEN PRE} IALE A HFA. Al -.1 AN 11A ORO 0 G1 TO SP ANR/.R OEFUAYAFA .111S .1 D"PERVISION A D TO THE SERT CF My III NO VISIBLE ENCROACHMENTS H"i BEEN FEDER EXCEPT AS NOTED ON THE HDRMDW. SUNCY' THIS IUDEEY SHUSHAN— COMPLIES WITH TIE CLI TEXAS SOCIM OF EFLOALOSOMI, SURF ORS STAFFEARDS AND SPECTICNIONS FOR A SPLELFICAFOES MR A TOAS CATORCRY 11, 101FIKIN 1, IRA 111E SHIANI, ENGINEERING + SURVEYING 1 of 1 LAND DEC. 22, 2021 A too A yx ISNJ y Land Title Sur✓cy of a 9.000 Acre (392,043 Sq. Ft.) Tract C—El Co-ty, —e x.5 FIN E E DESCRIPTION N�D RPF"R" I', R LO, U., 11:PA 1. " "A"I" IQ I., I IF,, I P, 1 "111101 — PI D"11 RN111 'KI ZLEDUIKP 1HUILLI IIII OEPI 01 —E1AS( L1JF1 IAF) — STIUA -1 NIN OR' 'N(1( 'I, SO '11-F 111 DO, II:. SIT I' I' IOICTI, 11111 FOR NXILIVID: Al A MILIN 12' E111 E01 , DI INIF I'll 'I ICIIIOSI ("HIM, OF I L6 11 YCID 1FAA'I FICIADIII 11 HOKIIIIINIF ", 1— Ii -, RIIIF LAID" On ENE N)lZIIIIA.il13()1\I)AR1 Ni.OJ'A FIT 1'— 112 0 THATRIIN �LFEIIN IIYFI�.W. IHENCD OKIL I5;O'FS EASY. "'L "' 'O ITT III Y LPAST "'U" �)E THE IT OR ONED 201 ACE T— I, ILONC, III TO FIT HIF EO-R—T LINE . 9(—A(RFTN1-A NISUANChOF.—I IIE T I'll 11 11" 11 11 1 EF "B' . 11 HN, F'111 AIN 'DEAST'11H1'1'1'�E L;IT'LIUARN'11 I, FIG I, ILHEIDB! -UTL 14)-25' FAST, 1) YITAR I INC TIRE SOUPWAST I REF OF 1 iC1 \ITNHO 'F[D AS 71 AT Rl� TRAI H I UISTA— (11 A-8 FLFT 10 A ALL 1,2' fRON LOR WITH A ITLAI111 ON III i I, "UP UDI; & SURVEY ; ON THL NOIIA OU 11 ILID-1,� A NETO I.TITI" IDIT, 1) 011IT 1111 TIII F11111, PLIALT III VIAY I III, OF FIT III :�;(WWAI IS, AT( AD AND LFILIH III � NORDIPAST LINF OF EIR, N(Cr -11A(1. I 11ALR L, �; LR 1111H 11+1 TO ILIF LFRII OD .—IIII(s AND (1111—Al A, L. 11 (31, IQ, I I I III IaI R 1 111 GENERAL NOTES. I 111TRIN-1 F—A DIONFRINIA UIALL.IF I NO, 20E8060061. ONDOIRL ACB-11 RECORDS OF .— COUNTY, 11 — I, FEARING BASIS - 1E— .111 ALTIS COORDINATE SMEA, FMIH IFEUNI EON= NORTH ANERCAN DATUM OF ISEL (2011), JS - SURVEY MM 1 5—EC PROPERTY COICTEND ADS) (39-43 FELT I ACRE TRACT OUT OF A 113 'EFTEMBER 10, 2021 A' 8'. M A M 4 I'DWIDED BY ALA MO TIRE COMPANY B. N.100.y..,Fl..dpl.in..it..nthi.p,.p.fty. 6. Firt4OO feet ,fPrp,rty,h,litmainz,n,dGB,appmximately3.34acres. 7. Remaining Property shall be —I GB-2, approximately ERIE -- (YEITIRCATION 1 IT D, REAL ILSTATE, LLC. THAT HE I$ MLY J� FLESSIDNED HEREBY ET TO ILLIT ,EED PERFESSLOOLD ALLO SH— OF THE STATE OF TEXAS, AND FIERTHER it THIS PIA' r OF EUWEY ADD SHE PRELEMY DESCRIPTLON SET FORTH HEREON TPAS BEEN PRE} IALE A HFA. Al -.1 AN 11A ORO 0 G1 TO SP ANR/.R OEFUAYAFA .111S .1 D"PERVISION A D TO THE SERT CF My III NO VISIBLE ENCROACHMENTS H"i BEEN FEDER EXCEPT AS NOTED ON THE HDRMDW. SUNCY' THIS IUDEEY SHUSHAN— COMPLIES WITH TIE CLI TEXAS SOCIM OF EFLOALOSOMI, SURF ORS STAFFEARDS AND SPECTICNIONS FOR A SPLELFICAFOES MR A TOAS CATORCRY 11, 101FIKIN 1, IRA 111E SHIANI, ENGINEERING + SURVEYING 1 of 1 LAND DEC. 22, 2021 \ �9 \ . � �® � FM 482 s* y« gp . m 3 N ° (78178) IH35N (56) * # 2 yf � f® � ® § « A y c 7 yy4» e f { SCHHEIRTZ mm TY� 6 6wR mV ' - - �� Agenda No. 9. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Executive Team Subject: Discussion on the Main Street Vision and Challenges including parking and nonconfoming uses. BACKGROUND For a number of years the City has been working to redevelop Main Street. This includes bond funding, grants to incentivize reinvestment, events, etc. The engineering consultant has developed options for various elements and staff is working to identify a funding and timing plan. The area has been dealing with challenges associated with on street parking, particularly from auto repair businesses. Staff has been exploring all options for moving the vision of Main Street forward. The purpose of this workshop is to update Council and discuss potential options to move forward. Agenda No. 10. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: Executive Team Subject: Discussion regarding the Joint Base San Antonio Randolph Joint Land Use Study Land Use Study and Air Installation Compatible Use Zones Study Recommendations compatible land uses and development restrictions. . Ll In 2015 the Joint Base San Antonio Randolph (JBSA- Randolph) Joint Land Use Study (JLUS) was completed. The document is joint effort between JBSA- Randolph and surrounding cities and counties. It was undertaken in an effort to guide planning and development in local jurisdictions surrounding JBSA- Randolph. The JBSA- Randolph Air Installations Compatible Use Zones (AICUZ) which was completed in 2017 has the basic objective of achieving compatible uses of public and private Land in the vicinity of JBSA - Randolph. The City has incorporated some of the recommendations into Schertz' plans, regulations and ordinances. Much of the land in the Air Impact Compatible Use Zones (AICUZ) is already zoned and some of it is platted and developed. This creates additional challenges in trying to achieve compatibility. The intended focus of this discussion are land use and floor area restrictions due to compatibility and noise. Agenda No. 11. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: City Secretary Subject: The City Council will meet in closed session in accordance with Section 551.074 of the Texas Government Code to discuss the direction to fill the City Manager vacancy. Agenda No. 12. CITY COUNCIL MEMORANDUM City Council March 22, 2022 Meeting: Department: City Secretary Subject: Take any action based on discussions held in Closed Session under Agenda Item 11. City Council Meeting: Department: Subject: tRM) ;ce1 z1In 0 7 CITY COUNCIL MEMORANDUM March 22, 2022 Finance Quarterly Financial Reports Agenda No. 13. 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 Reports Quarterly t t t SchertZ, Texas CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (i.INA1.1Di,.i.ED) A S O :Decennber 31,2021 , . 7021 2022 24,000.00 CURRENT BUDGET CURRENT T Y-T -D Y I', -. RR i°UAL ENCUMBR BUDGET BALANCE 100% OF BUDGET General Fund, 101 24,000.00 14,706.88 0.00 9,293.12 Total Revenues 41,490,207.00 14,215,180.99 0.00 27,275,026.01 34.26% Total General Government 7,113,358.00 1,423,086.93 301,004.80 5,389,266.27 24.24% Total Public Safety 18,411,831.54 4,694,040.28 2,125,982.91 11,591,808.35 37.04% Total Public Environment 2,037,970.00 335,729.56 191,127.41 1,511,113.03 25.85% Total Parks & Recreation 2,748,554.00 534,461.27 76,226.71 2,137,866.02 22.22% Total Cultural 1,163,373.00 334,629.02 6,029.40 822,714.58 29.28% Total Internal Services 7,722,891.00 1,493,334.92 715,579.93 5,513,976.15 28.60% Total Misc & Projects 2,292,230.00 49,458.75 2,500.00 2,240,271.25 2.27% Total Expenditures 41,490,207.54 8,864,740.73 3,418,451.16 29,207,015.65 29.61% Revenue Over(Under) Expenditures 1 0.54 5,350,440.26 (3,418,451.16) (1,931,989.64) General Fund, 101 Total Cash in Bank & Investments 1 20,425,081.02 Special Events Fund, 106 Total Revenues 24,000.00 35,628.89 0.00 (11,023.39) 148.45% Total Expenditures 24,000.00 14,706.88 0.00 9,293.12 61.28% Revenue Over(Under) Expenditures 0.00 20,922.01 0.00 (20,922.111) Special Events Fund, 106 Total Cash in Bank & Investments 141,768.82 Peg Fund, 110 OEM Total Revenues 350,000.00 20,581.45 0.00 329,418.55 5.88% Total Expenditures 350,000.00 0.00 0.00 350,000.00 0.00% Revenue Over(Under) Expenditures 0.00 20,581.45 0.00 (20,531.45) Peg Fund, 110 Total Cash in Bank & Investments 967,035.50 Water & Sewer, 202 Total Revenues 28,758,723.00 7,056,962.75 0.00 21,701,760.25 24.54% Total Expenditures 25,921,362.00 5,635,350.61 1,336,527.56 18,949,483.83 26.90% Revenue Over(Under) Expenditures 2,837,361.00 1,421,612.14 (1,336, 527.53) 2,752,276.42 Water & Sewer, 202 Total Cash in Bank & Investments 1 1 6,991,637.34 Capital Recovery Water, 411 Total Revenues 1,116,000.00 153,282.88 0.00 962,717.12 13.74% Total Expenditures 51,000.00 2,877.37 78,417.12 (30,294,49) 159.40% Revenue Over(Under) Expenditures 1,065,000.00 150,405.51 (78,417,12) 993,011.61 Capital Recovery Water. 411 Total Cash in Bank & Investments 1 8.407.270.31 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUMTED) Quarterly Statement AS O Decernber 31, 2021 Schertz, Texas nnzz 2021 - 2022 n. CURRENT CURRENT Y-T-D BUDGET 100% OF BUDGET Y-T-D ACTUAL ENCUMBR BALANCE BUDGET EMS, 203 Total Revenues 11,794,594.14 3,247,154.61 0.00 8,547,439.53 27,53% Total Expenditures 11,736,093.61 3,396,790.65 456,642.16 7,882,660.80 32.83% Revenue Over(Under) Expenditures 58,500.53 (149,636,04) (456,642,16) 664,778.73 EMS, 203 Total Cash in Bank & Investments 970,564.99 Drainage, 204 ON Total Revenues 1,284,229.00 314,886.74 0.00 969,342.26 24.52% Total Expenditures 1,272,024.00 289,985.61 26,685.11 955,353.28 24.90% Revenue Over(Under) Expenditures 12,205.00 24,901.13 (26,685.11) 13,988.98 Drainage, 204 Total Cash in Bank & Investments 418,882.34 Hotel Tax, 314 Total Revenues 1,675,250.00 195,003.07 0.00 1,480,246.93 11.64% Total Expenditures 1,579,797.00 58,974.22 133,847.56 1,386,975.22 12.21% Revenue Over(Under) Expenditures 95,453.00 136,028.85 (133,847.56) 93,271.71 Hotel Tax, 314 Total Cash in Bank & Investments 2,372,801.86 Park, 317 Total Revenues 319,025.00 40.35 0.00 318,984.65 0.01% Total Expenditures 125,000.00 OM 0.00 125,000.00 0.00% Revenue Over(Under) Expenditures 194,025.00 40.35 0.00 193,984.65 Park, 317 Total Cash in Bank & Investments 287,057.71 Tree Mitigation, 319 Total Revenues 71,400.00 57,097.45 0.00 14,302.55 79.97% Total Expenditures 'Revenue 70,000.00 13,600.00 2,700.00 53,700.00 23.29% Over(Under) Expenditures 1,400.00 43,497.45 (2,700,00) ITree Mitigation, 319 Total Cash in Bank & Investments 691,392.66 Capital Recovery Water, 411 Total Revenues 1,116,000.00 153,282.88 0.00 962,717.12 13.74% Total Expenditures 51,000.00 2,877.37 78,417.12 (30,294,49) 159.40% Revenue Over(Under) Expenditures 1,065,000.00 150,405.51 (78,417,12) 993,011.61 Capital Recovery Water. 411 Total Cash in Bank & Investments 1 8.407.270.31 1 &S, 505 Total Revenues 7,434,862.00 3,867,561.05 0.00 3,567,300.95 52.02% Total Expenditures REVENUE AND EXPENSE REPORT (U 1 1;UM"1ED) 1,982,996.88 Quarterly Statement 30.38% AS OF 0ecrrnb r 31, 2021 757,947.00 3,822,267.66 c (1,081,323.73) 2021 2022 .p , 4,909,644.33 CURRENT CURRENT Y -T -D BUDGET 100% OF BUDGET YNT-D ACTUAL ENCUMBR BALANCE BUDGET Capital Recovery Sewer, 421 21.22% Total Expenditures 5,540,707.00 290,558.91 22,441.66 Total Revenues 660,250.00 70,583.52 0.00 589,666.48 10.69% Total Expenditures 55,500.00 4,018.36 97,902.49 (46,420.85) 183.64% Revenue Over(Under) Expenditures 604,750.00 66,565.16 (97,902,49) 636,087.33 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 178,435.38 1 &S, 505 Total Revenues 7,434,862.00 3,867,561.05 0.00 3,567,300.95 52.02% Total Expenditures 6,676,915.00 45,293.39 1,982,996.88 4,648,624.73 30.38% Revenue Over(Under) Expenditures 757,947.00 3,822,267.66 (1,982,196.88) (1,081,323.73) 1 &S, 505 Total Cash in Bank & Investments 4,909,644.33 SED Corporation, 620 Total Revenues 6,789,000.00 1,440,672.20 0.00 5,348,327.80 21.22% Total Expenditures 5,540,707.00 290,558.91 22,441.66 5,227,706.43 5.65% Revenue Over(Under) Expenditures 1,248,293.00 1,150,113.29 (22,441.86) 120,621.37 SED Corporation. 620 Total Cash in Bank & Investments 21.931.784.88 Total Cash in Bank & Investments 68,693,357.14 CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 CURRENT CURRENT yf-D BUDGET % 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET REVENUES REVENUE SUMMARY Texan 27.845.000.00 11.359.925.15 10.563.282.53 11.359.92515 - 16.485.074.85 40.80 Franchises 2.327.000.00 501.441.05 548.228.60 561.441.05 - 1.765.558.95 24.13 PonnUo 1.718.150.00 308.416.32 410.00042 308.410.32 - 1.400.733.08 17.95 Lioannao 49.320.00 10.355.00 11.270.00 10.355.00 - 38.985.00 21.00 Fees 2.232.459.00 435.955.03 451.845.34 435.955.63 - 1.796.503.37 18.53 Fines 8.000.00 2.270.88 1.208.98 2.270.68 - 8.720.32 2523 Inter-Jurisdictional 000.508.00 129.221.05 123.755.48 129.221.05 - 881.376.95 13.04 Fund Transfers 5.012.830.00 808.225.00 812.011J8 898.225.09 - 4.714.404.91 16.00 K4inoeUonooun 70005000 509,371.02 10528078 509,371.02 - 10887898 72.14 TOTALREVENUES 41,490,207.00 14,215,180.99 13,027,763.91 14,215,180.99 - 27,275,026.01 34.26% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 38.102.00 10.191.30 10.107.07 10.101.30 1440 27.898.30 2879 Supplies 750.00 70.05 139.40 79.05 200.00 470D5 37.33 City Support Services 55.500.00 20.878.85 36.998.85 20.87835 2.188.00 32.632.25 41.20 Operations Support 300.00 - 23.50 - - 300.00 0.00 Staff Support 28.600.00 10.364.77 0.203.55 10.38477 320.15 17.015.08 37.36 Professional Services 6,000.00 - - - - 8.000.00 0.00 TOTAL CITY COUNCIL 129,25200 41,314.87 56,622.37 41,31487 2,723.45 85,213.68 34,07% CITY MANAGER Personnel Services 1.260.763.00 301.848.98 314.144.50 301.848.98 - 958.914.02 23.94 Supplies 2.000.00 320.43 115.81 320.43 - 1.679.57 18.02 City Support Services 2.000.00 - - - - 2.000.00 - Operations Support 50.00 - - - - 50.00 - Staff Support 24`775.00 5.540.17 2.145.00 5.540.17 740.60 18.494.23 25.35 Professional Services 13`641.21 - - - - 13.641.21 - Operating Equipment - - 1.200.00 - - - - Capital Outlay 44.000.00 - - - 43.581.78 418.22 09.05 TOTAL CITY MANAGER 1,347,229.21 307,709.58 317,605.40 307,709.58 44,322.38 995,197.25 26.13% MUNICIPAL COURT Personnel Services 306.228.00 93.058.28 81.000.14 93.058.28 - 213.108.72 30.39 Supplies 1.500.00 60.00 424.88 60.00 104.87 1.335.03 11.00 City Support Services 500.00 118.08 123.86 118.68 - 381.32 2374 Operations Support 2.000.00 - - - - 2.000.00 - CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 CURRENT CURRENT yf-D BUDGET % 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET Staff Support 6.910.00 - 74.89 - 354.83 8.555.37 5.13 Court Support 3.000.00 132�00 - 132.00 - 2.868.00 4.40 Professional S*mioon 61.700.00 10.300�00 9.132.50 10.300.00 53.000.00 (2.500.00) 104.05 Maintenance Services 3.000.00 450�00 550.00 450.00 1.800.00 750.00 75.00 Operating Equipment 400000 400000 TOTAL MUNICIPAL COURT 388,838.00 104,11&96 91,306.28 104,118.96 56,159.60 228,559.44 4122% CUSTOMER RELATIONS-311 Personnel Services 118.705.00 35.011�21 30.889.96 35.011.21 ' 81.69379 30.00 Supplies 100.00 17.02 12.47 17.02 - 82.98 17.02 Staff Support 43000 3228 6604 32.28 39772 751 TOTAL CUSTOMER RELATIONS-311 117,235.00 35,060.51 30,969.37 35,060.51 - 82,174.49 29.91% PLANNING &ZON|NG Personnel Services 289.789.00 46.033.98 54.585.83 46.033.98 ' 243.735.02 15.89 Supplies 2.020D0 240�88 13829 240.88 (4718) 1.828.32 0.50 Operations Support 248.00 - 7.80 - - 248.00 - Staff Support 33.939.00 1.33470 632.00 1.334.70 100.00 32.504.30 4.23 Professional Services 400.100.00 - 5.00 - - 400.100.00 - Operating Equipment 163900 28547 607583 28547 135353 1742 TOTAL PLANNING & ZONING 727,715.00 47,89501 61,42455 47,89501 52.82 679,767.17 6.59% LEGAL SERVICES Operations Support 10.000.00 - 2.258.01 - 295.00 9.705D0 2.05 Professional Services 130.000.00 4.050.50 16.081.05 4.050.50 125.949.50 3.12 TOTAL LEGAL SERVICES 140,000.00 4,05050 19,23796 4,05050 29500 135,654.50 3.10% CITY SECRETARY Personnel Services 197.500.00 56.768.57 52.548.05 56.788.57 - 140.740.43 28.74 Supplies 1.150.00 235.13 409.65 235.13 35.60 870.27 23.54 City Support Services 10.000.00 1.920.02 - 1.920.02 - 8.070.90 18.20 Operations Support 150.00 - - - - 150.00 - Staff Support 8.450.00 1.282.57 982.40 1.262.57 - 5.187.43 10.57 Operating Equipment 1.000.00 - - - - 1.000.00 - TOTAL CITY SECRETARY 216,259.00 60,186.29 53,939.00 60,186.29 35.60 156,037.11 27.85% NON-DEPARTMENTAL City Support Services 856.310.79 370.778.84 322.616.42 370.776.84 176.010.54 308.523.41 63.85 Operations Support 140.000.00 27.293.31 38.344.62 27.293.31 1.408.82 111.287.87 20.50 City Assistance 1.315.645.00 - 186.702.17 - - 1.315.645.00 - Professional Services 88.775.00 12.978.28 25.030.53 12.978.28 300.00 75.486.72 14.90 Fund Chrgs/Tmnahn-Spec Events Fnd 27.879.00 - - - - 27.878.00 - CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 ENGINEERING Personnel Services CURRENT CURRENT 211.00.53 206.077.07 yf-D BUDGET % 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET Capital Outlay 0.00 - - - - - - TOTAL NON-DEPARTMENTAL 2,428,709.79 411,048.43 572,753.74 411,048A3 177,719.36 1,839,942.00 24,24% PUBLIC AFFAIRS Utility Services 5.500.00 738.00 581.00 1.035.40 28.082.36 581.00 Personnel Services 325.481.00 94.803.47 83.183.80 94.803.47 - 230.877.53 29.13 Supplies 1.100.00 351�61 420.61 351.61 28.88 719.71 34.57 City Support Services 1.000.00 - - - ' 1.000.00 - Operations Support 48.235.00 8.90171 749.13 6.003.71 - 41.33129 14.31 Staff Support 11.170.00 42132 35.84 423.32 125.01 10.620.77 4.02 Professional Services 271.500.00 87.40&00 44.695.78 87.408.00 4.000.00 180.092.00 33.87 TOTAL PUBLIC AFFAIRS 658,486.00 189,890.11 129,084,74 189,890.11 4,154.59 464,441.30 29.47% ENGINEERING Personnel Services 879�09.00 2/05.610.21 211.00.53 206.077.07 - 211.700.53 28.32 ' 667.08.47 24.07 23.578.22 Supplies 2.750.00 2,399.74 163.09 100.30 City Support Services 163.09 33.069.74 - 2.586.91 5.93 - City Support Services 1.265.00 Utility Services - - 26.050.42 - - - 1.285.00 14.21 - Utility Services 5.500.00 738.00 581.00 1.035.40 28.082.36 581.00 Staff Support - 4.919.00 10.56 21.768.41 Operations Support 150.00 117.226.97 - - 60.300.00 - 678.55 - 150.00 - - Staff Support 18.045.00 85.266.20 75.00 557.82 21.650.91 75.00 54.285,41 200.00 15.770.00 171 77.305.00 Professional Somi000 53.115.00 5.20.50 9.203.05 - 7.74 0.293.05 192.687.60 15.342.00 28.479.05 46.38 25.351.86 Operating Equipment 1 4OOOO 2818 Capital Outlay 2578381 5,390.00 5,600.56 5,390.00 1,400.00 146,934.03 72.92 PUBLIC SAFETY POLICE Personnel Services 8.812.715.00 2/05.610.21 2.300.852.23 2.405.81921 - 6.317.005.79 28.32 Supplies 110,557.01 23.578.22 5J10.69 23,578.22 2,399.74 84.579.95 23.50 City Support Services 26.500.00 33.069.74 32.020.24 33.969.74 - (7.469.74) 12810 Utility Services 193.200.00 27.48219 26.050.42 27,46219 - 165.737.81 14.21 Operations Support 30,316.00 821.80 738.00 821.80 411.84 28.082.36 4.07 Staff Support 164.030.83 26.16410 21.768.41 28.16416 20.039.70 117.226.97 28.53 City Assistance 60.300.00 8.952.04 678.55 8.952.04 - 51.347.96 14.85 Professional Services 85.266.20 21.856.81 21.317.30 21.650.91 8.313.88 54.285,41 36.32 Maintenance Services 77.305.00 5.207.50 8.588.99 5.20.50 775.00 71.322.50 7.74 Operating Equipment 192.687.60 25.351.86 78.348.79 25.351.86 28.959.47 138.376.27 2818 Capital Outlay 542,637.00 5,390.00 5,600.56 5,390.00 390,312.97 146,934.03 72.92 TOTAL POLICE 10,295,515.54 2,674,173.63 2,598,674.18 2,674,173.63 452,812.60 7,168,529.31 30.37% FIRE RESCUE CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 PUBLIC ENVIRONMENT STREETS Personnel Services 1,009,600.00 280,050.89 221,044.19 280,050.89 1,149.57 728,399.54 27.85 CURRENT CURRENT yf-D BUDGET % 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET Personnel Services 5.536.077.00 1.507.284A3 1.567.846.12 1.597.284.13 - 3.939.392.87 28.85 Supplies 22.555.00 2.48&56 516.19 2.488.56 633.22 19.433.22 13.84 Utility Services 80.000.00 14.387�50 14.108.52 14.387.50 - 85.812.50 17.98 Operations Support 4.527.00 1.527A5 157.73 1.527.45 - 2.099.55 33.74 Staff Support 205.772.00 22.37136 9.888.42 22.373.36 38.305.94 145.092.70 29.49 City Assistance 25.108.00 2.48323 878.09 2.483.23 3.781.10 18.953.67 24.78 Professional Services 63.600.00 10.83&86 14.102.43 10.838.86 - 52.761.14 17.04 Maintenance Services 81.500D0 2.20118 17.306.84 2.203.18 3.375.68 75.921.14 6.85 Other Costs 10.000D0 - 5.078.41 - - 10.000.00 - Rental/Leasing 27.000D0 - - - - 27.000.00 - Operating Equipment 120.000D0 6.921�89 47.354.82 8.921.69 2.990.09 110.078.32 827 Capital Outlay 473.837.00 - 385.00 - 1.572.050.81 (1.000.313.81) 332.10 TOTAL FIRE RESCUE 6,650,466.00 1,660,50796 1,677,62037 1,660,507.96 1,622,026.74 3,367,931.30 49.36% INSPECTIONS Personnel Services 961.954D0 288.27475 235.831.42 268.27475 ' 803.670.25 27.89 Supplies 5.100.00 93.00 201.10 93D0 - 5.007.00 1.82 Utility Services 8.400.00 1.198.25 1.03771 1.18825 - 7.20175 14.26 Operations Support 850.00 - - - - 850.00 - Staff Support 41.446.00 2.347.44 475.52 2.347.44 627.57 38.470.99 7.18 Professional Services 70.000.00 600.00 15.400.00 600.00 48.400.00 21.000.00 70.00 Operating Equipment 650.00 570.84 - 570.94 - 79.06 87.84 Capital O U 2738100 TOTAL INSPECTIONS 1,088,400.00 273,084.38 280,326.75 273,084.38 49,02757 766,288.05 29.59% NEIGHBORHOOD SERVICES Personnel Services 312.204.00 81.85274 - 81.852.74 - 230.44126 26.21 Supplies 4.510.00 814.51 - 814.51 - 3.704.40 18.02 Utility Services 15.000.00 480.00 - 480.00 - 14.520.00 3.20 Operations Support 3.419.00 - - - - 3.418.00 - Staff Support 23.383.00 801.59 - 891.58 516.00 21.885.41 8.02 Professional Services 2.500.00 - - - - 2.500.00 - Maintenance Services 16.000.00 1.850.00 - 1.950.00 1.600.00 12.450.00 22.19 Operating Equipment 325.00 28547 - 285.47 - 38.53 87.84 PUBLIC ENVIRONMENT STREETS Personnel Services 1,009,600.00 280,050.89 221,044.19 280,050.89 1,149.57 728,399.54 27.85 CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 PARKS & RECREATION CURRENT CURRENT yf-D BUDGET % 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET Supplies 167.050.00 16.72152 28.205.19 16.723.52 11.064J8 140.181.70 18.55 City Support Services 6.000.00 411A5 - 411.45 453.10 5.135.45 14.41 Utility Services 180.600.00 31.99477 31.720.37 31.904.77 - 148.805.23 17.72 Staff Support 22.120.00 1.571�78 2.159.19 1.571.78 389.20 20.159.02 8.87 Professional Services 20.000.00 - 530.00 - 7.536.10 12.463.90 37.88 Maintenance Services 396.500.00 2.591�00 58.780.50 2.591.00 12.204.40 381.814.80 375 Rental/Lease 5.000.00 - - - - 5.000.00 - Operating Equipment 71.000D0 2.388�15 1.050.64 2.386.15 (1.804.07) 70.418.82 0.82 Capital Outlay 159.200.00 - - - 100.045.23 (845.23) 100.53 PARKS & RECREATION PARKS DEPARTMENT Personnel Services 758.970.00 202.00.92 154.806.40 202.008.92 - 556.961.08 26.62 Supplies 113.148.00 14.100,85 25.804.34 14.100.85 5.457.58 93.589.57 17.29 City Support Services 136.000.00 42.355.74 50.534.99 42.355.74 5.256.74 88.387.52 35.01 Utility Services 246.000.00 32.074.33 35.325.87 32.974.33 12.281.01 200.744.86 18.40 Operations Support 2.000.00 - 122.02 - - 2.000.00 - Staff Support 19.870.00 4.084.33 2.380.35 4.984.33 - 14.685.87 25.34 Professional Services 147.946.00 35.202.90 27.214.30 35.292.00 - 112.653.10 23.88 Maintenance Services 14.000.00 1.70872 53.502.81 1.790.72 2.945.15 9.256.13 33.88 Rental/Leasing 10.000.00 1.04172 2.040.02 1.041.72 882.04 8.005.34 18.05 Operating Equipment 65.000.00 8.049.30 7.950.08 8.040.36 3.980.30 52.964.25 18.52 Capital Outlay 280.997.00 40.587.00 240.410.00 14.44 TOTAL PARKS DEPARTMENT 1,793,731.00 342,606.87 359,790.78 342,606.87 71,376.81 1,379,747.32 23.08% SWIM POOL Supplies 25.500.00 - 22.36 - 2.880.00 22.020.00 11.28 Utility Services 16.500.00 2.57143 2.388.02 2.571.43 54370 13.384.87 18.88 Maintenance Services 527.878.00 97.339.35 81.589.98 87.339.35 - 430.538.65 18.44 TOTAL SWIM POOL 569,878.00 99,910.78 84,000.36 99,910.78 3,423.70 466,543.52 18A3% EVENT FACILITIES Personnel Services 284.722.00 79.984.63 51.148.80 79.964.63 - 204.757.37 28.09 Supplies 6.150.00 40940 1.079.83 40840 29823 5.382.37 12.48 Utility Services 48.600.00 6.029.35 4.516.86 8.028.35 - 42.570.65 12.41 Operations Support 15.808.00 6172 1.808.64 8172 - 15.840.28 0.39 Staff Support 4.805.00 293.44 191.56 293.44 152.88 4.418.68 8.17 Maintenance Services 12`700.08 1.633.94 - 1.633.94 - 11.066.06 12.87 1[M GENERAL FUND Operating Equipment CULTURAL LIBRARY Personnel Services Supplies Utility Services Operations Support Staff Support Professional Services Operating Equipment INTERNAL SERVICE INFORMATION TECHNOLOGY CITY OFSCHERTZ REVENUE AND EXPENSE REPORT (UNAUDKED) AS OF: December 31, 2021 CURRENT CURRENT yf-D BUDGET % BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTU&L *wouMomxmoe BALANCE BUDGET 12.000.00 3.481.14 720.00 3.491.14 975.08 7.533.77 3722 904.388.00 268.695.58 229.105.91 268.605.58 - 635.690.42 29.71 15,000.00 4.024,44 4,827.05 4,024.44 194.25 10,01.31 2812 70,000.00 10.037.46 5.326.69 10,037.46 - 59,982.54 14.34 5.900.00 253.97 587.08 253.97 - 5.848.03 4.30 7.025.00 5.486.35 320.18 5.486.35 - 1.538.65 78.10 3.300.00 2.129.00 1.655.96 2.120.00 - 1.171.00 64.52 157.782.00 44.002.22 37.400.83 44.00222 5.835.15 107.924.63 31.50 Personnel Services 016.558.00 247.854.80 218.268.88 247.854.80 - 668.703.20 27.04 Supplies 8.300.00 1.328.37 1.162.86 1.328.37 941.25 8.030.38 27.34 City Support Services 1.024.097.00 174.015.69 181.856.0 174.915.69 90.00.96 759.172.35 25.87 Utility Services 367�65.00 52.288.92 52.359.62 52.288.92 33.376.00 281.00.08 23.31 Staff Support 69700.00 1.05678 117.01 1,058.78 1.158.81 87,484,41 318 Professional Services 38.075.00 1.406.25 - 1,408.25 - 36.668.75 3.69 Maintenance Services 10.000.00 280.90 7.182.61 289.80 - 0.730.10 2.70 Rental/Leasing 3.650.00 1.21872 912.54 1.216.72 - 2.433.28 33.33 Operating Equipment 2SA504 OO 52 53785 46,430 .69 52,537.65 5575880 1G1 28746 40.17 TOTAL INFORMATION TECHNOLOGY 2,707,439.00 532,87508 486,291.04 532,875.08 181,243.91 1,993,32001 26.38% HUMAN RESOURCES Personnel Services 468.069.00 105.443.58 115.028.96 105.443.58 11.282.62 351.332.80 24.94 Supplies 2.700.00 134.37 182.10 134.37 - 2.565.83 4.98 Human Services 215.400.00 38.049.10 52.627.43 38.049.10 57.10523 120.245.67 44.18 Operations Support 5.500.00 1.949.84 2.433.84 1.949.84 - 3.550.18 35.45 Staff Support 41`150.00 13.680.01 13.303.30 13.680.01 2.10422 25.365J7 38.36 City Assistance 10`000.00 4.855.00 1.885.00 4.855.00 990.00 4.155.00 58.45 Professional Services 5.000.00 - - - - 5.000.00 - Operating Equipment 500.00 513.31 500.00 TOTAL HUMAN RESOURCES 748,319.00 164,111.90 186,073.94 164,111.90 71,492.07 512,715.03 31.48% J 10 F-11 0 [a]� CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 FACILITY SERVICES Personnel Services CURRENT CURRENT 213,475.64 216,979.90 Y -T -D BUDGET % OF 101 GENERAL FUND BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Personnel Services 656,579.00 192,216.52 170,470.62 192,216.52 - 464,362.48 29.28 Supplies 2,700.00 726.83 801.09 726.83 - 1,973.17 26.92 Staff Support 6,740.00 240.00 864.00 240.00 - 6,500.00 3.56 Professional Sevices 38,700.00 7,908.09 909.82 7,908.09 - 30,791.91 20.43 Operating Equipment 250.00 - 336.08 - - 250.00 - TOTAL FINANCE 704,969.00 201,091.44 `` 173,381.61 201,091.44 - 503,877.56 28.52% PURCHASING & ASSET MGT 6,000.00 - - - - 6,000.00 - Personnel Services 237,179.00 70,432.01 63,361.41 70,432.01 - 166,746.99 29.70 Supplies 3,600.00 390.56 34.58 390.56 231.19 2,978.25 17.27 Operations Support 7,550.00 1,299.00 1,299.00 1,299.00 517.00 5,734.00 24.05 Staff Support 6,785.00 399.00 375.38 399.00 825.95 5,560.05 18.05 City Assistance 2,000.00 124.00 162.00 124.00 445.00 1,431.00 28.45 Operating Equipment 600.00 - - - - 600.00 - TOTAL PURCHASING & ASSET MGT 257,714.00 72,644.57 65,232.37 72,644.57 2,01(9.14 183,050.29 28.97% FLEET SERVICE Personnel Services 560,458.00 135,028.93 137,221.56 135,028.93 - 425,429.07 24.09 Supplies 216,700.00 29,992.53 37,837.11 29,992.53 11,839.53 174,867.94 19.30 City Support Services 15,000.00 2,404.34 2,357.20 2,404.34 - 12,595.66 16.03 Utility Services 11,500.00 1,109.01 1,634.84 1,109.01 - 10,390.99 9.64 Staff Support 32,500.00 512.50 4,317.96 512.50 649.31 31,338.19 3.57 Maintenance Services 234,953.00 38,782.94 62,404.77 38,782.94 16,394.38 179,775.68 23.48 Operating Equipment 14,000.00 5,007.38 4,737.94 5,007.38 2,756.18 6,236.44 55.45 Capital Outlay 221,000.00 394.87 - 394.87 183,327.79 37,277.34 83.13 TOTAL FLEET SERVICE 1,306,111.00 213,232.50 250,511.38 213,232.50 214,967.19 877,911.31 32.78% FACILITY SERVICES Personnel Services 820,939.00 216,979.90 213,475.64 216,979.90 - 603,959.10 26.43 Supplies 159,500.00 9,833.34 10,228.44 9,833.34 4,439.13 145,227.53 8.95 City Support Services 5,000.00 - - - - 5,000.00 - Utility Services 186,000.00 31,688.37 26,404.32 31,688.37 - 154,311.63 17.04 Staff Support 18,400.00 1,646.63 706.00 1,646.63 634.25 16,119.12 12.40 Professional Services 160,000.00 12,416.31 15,216.62 12,416.31 136,579.41 11,004.28 93.12 Maintenance Services 610,000.00 36,814.88 51,367.16 36,814.88 78,083.33 495,101.79 18.84 Rental /Leasing 500.00 - - - - 500.00 - Operating Equipment 6,000.00 - - - - 6,000.00 - Capital Outlay 32,000.00 - - - 26,121.50 5,878.50 81.63 101 GENERAL FUND MISC & PROJECTS Project CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT Y -T -D BUDGET % OF BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fund Charges/Transfers 1,645,112.00 - - - - 1,645,112.00 - TOTAL PROJECTS '` 1,645,112.00 - - - - 1,645,112.00 0.00% CITY ASSISTANCE City's Assistance to Agencies 332,666.00 49,458.75 52,420.92 49,458.75 - 283,207.25 14.87 Operating Equipment 10,000.00 - - - - 10,000.00 - TOTAL CITY ASSISTANCE 342,666.00 49,458.75 52,420.92 49,458.75 - 293,207.25 14.43 %? SEWER PROJECTS Fund Charges /Transfers 285,000.00 - - - - 285,000.00 - TOTAL SEWER PROJECTS 285,000.00 285,000.00 0.00 % COURT - RESTRICTED FUNDS Operating Equipment 19,452.00 - - - 2,500.00 16,952.00 12.85 101 GENERAL FUND REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET Taxes Bldg Permit - General 350,000.00 56,896.00 79,184.00 56,896.00 - 293,104.00 16.26 000-411100 Advalorem Tax - Current 15,420,000.00 8,443,209.42 7,906,585.67 8,443,209.42 - 6,976,790.58 54.75 000-411110 Disable Veterans Assist Pymnt 1,100,000.00 - - - - 1,100,000.00 - 000- 411200 Advalorem Tax - Delinquent 50,000.00 14,754.88 32,941.15 14,754.88 - 35,245.12 29.51 000 - 411300 Advalorem Tax -P &I 70,000.00 12,977.65 15,014.07 12,977.65 - 57,022.35 18.54 000 - 411500 Sales Tax Revenue -Gen Fund 11,135,000.00 2,870,801.58 2,599,173.29 2,870,801.58 - 8,264,198.42 25.78 000 - 411600 Bingo Tax - - - - - - - 000- 411700 Mixed Beverage Tax 70,000.00 18,181.62 9,568.35 18,181.62 - 51,818.38 25.97 TOTAL Taxes 27,845,000.00 11 359,925.15 10,563,282.53 11,359,925.15 - 16,485,074.85 40.80% Franchises 11.47 000 - 431900 Solicitor /Peddler Permit 2,000.00 240.00 120.00 000 - 421200 Center Point/Entex Energy 94,000.00 22,791.99 22,545.08 22,791.99 - 71,208.01 24.25 000 - 421220 City Public Service 980,000.00 243,299.04 233,351.20 243,299.04 - 736,700.96 24.83 000 - 421240 Guadalupe Valley Elec Co -op 460,000.00 109,454.20 96,751.57 109,454.20 - 350,545.80 23.79 000 - 421250 New Braunfels Utilities 70,000.00 15,731.04 15,948.89 15,731.04 - 54,268.96 22.47 000 - 421300 Time Warner -State Franchise 325,000.00 77,552.15 83,699.78 77,552.15 - 247,447.85 23.86 000 - 421460 AT &T Franchise Fee 100,000.00 21,637.80 11,69831 21,637.80 - 78,362.20 21.64 000 - 421480 Other Telecom Franchise - ROW 130,000.00 27,885.25 38,515.31 27,885.25 - 102,114.75 21.45 000 - 421500 Solid Waste Franchise Fee 168,000.00 43,089.58 45,718.46 43,089.58 - 124,910.42 25.65 TOTAL Franchises 2,327,000.00 561,441.05 548,228.60 561,441.05 - 1,765,558.95 24.13 %' Permits 000 - 431100 Home Occupation Permit 525.00 175.00 420.00 175.00 - 350.00 33.33 000 - 431205 Bldg Permit - Residential 601,400.00 48,716.50 129,898.50 48,716.50 - 552,683.50 8.10 000 - 431210 Bldg Permit - Commercial 250 000.00 92 967.00 50 456.00 92 967.00 - 157 033.00 37.19 000 - 431215 Bldg Permit - General 350,000.00 56,896.00 79,184.00 56,896.00 - 293,104.00 16.26 000 - 431300 Mobile Home Permit 375.00 25.00 300.00 25.00 - 350.00 6.67 000 - 431400 Signs Permit 5,000.00 644.00 1,486.00 644.00 - 4,356.00 12.88 000 - 431500 Food Establishmnt Permit 70,000.00 44,540.00 56,250.00 44,540.00 - 25,460.00 63.63 000 - 431700 Plumbing Permit 130,000.00 17,809.00 33,572.00 17,809.00 - 112,191.00 13.70 000 - 431750 Electrical Permit 75,000.00 10,600.00 21,440.00 10,600.00 - 64,400.00 14.13 000 - 431800 Mechanical Permit 68,000.00 7,800.00 14,780.00 7,800.00 - 60,200.00 11.47 000 - 431900 Solicitor /Peddler Permit 2,000.00 240.00 120.00 240.00 - 1,760.00 12.00 000 - 431950 Animal /Pet Permit 250.00 - - - - 250.00 - 000- 432000 Cert of Occupancy Prmt 7,600.00 2,850.00 1,050.00 2,850.00 - 4,750.00 37.50 000 - 432100 Security Alarm Permit 43,000.00 6,995.00 6,975.00 6,995.00 - 36,005.00 16.27 000 - 432300 Grading /Clearing Permit 10,000.00 2,055.38 2,450.00 2,055.38 - 7,944.62 20.55 000 - 432400 Development Permit 75,000.00 12,231.44 7,394.42 12,231.44 - 62,768.56 16.31 000 - 435000 Fire Permit 30,000.00 3,872.00 4,224.50 3,872.00 - 26,128.00 12.91 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 101 GENERAL FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES TOTAL Permits 1,718,150.00 308,416.32 410,000.42 308,416.32 - 1,409,733.68 17.95% Licenses 000 - 441000 Alcohol Beverage License 8,200.00 2,585.00 2,540.00 2,585.00 - 5,615.00 31.52 000 - 441300 Mobile Home License 120.00 80.00 80.00 80.00 - 40.00 66.67 000 - 442000 Contractors License 41,000.00 7,690.00 8,650.00 7,690.00 - 33,310.00 18.76 000 - 444000 Pet License - - - - - - - TOTAL Licenses 49,320.00 10,355.00 11,270.00 10,355.00 - 38,965.00 21.00% Fees 000 - 451000 Municipal Court Fines 625,000.00 98,415.38 99,424.57 98,415.38 - 526,584.62 15.75 000 - 451010 Texas Motor Carrier Fines - 11,744.00 - 11,744.00 - (11,744.00) - 000- 451015 CVE Out of Service - 800.00 - 800.00 - (800.00) 000 - 451100 Arrest Fee 21,300.00 3,040.77 4,082.08 3,040.77 - 18,259.23 14.28 000-451110 Expunction Fee 100.00 - - - - 100.00 - 000- 451200 Warrant Fees 67,400.00 12,404.37 8,014.27 12,404.37 - 54,995.63 18.40 000 - 451220 Officer Jury Fee 200.00 - - - - 200.00 - 000- 451310 Restitution Fee -Local 100.00 - - - - 100.00 - 000- 451320 Civil Justice Fee -Court - - - - - - - 000- 451340 Judicial Fee -City 1,524.00 83.57 83.11 83.57 - 1,440.43 5.48 000 - 451400 Traffic Fine Costs TTL 9,924.00 1,317.04 1,964.45 1,317.04 - 8,606.96 13.27 000 - 451510 Juvenile Case Mgmt Fee 12,768.00 696.40 697.56 696.40 - 12,071.60 5.45 000 - 451520 Truancy Fees 13,584.00 2,978.62 3,761.25 2,978.62 - 10,605.38 21.93 000 - 451530 Local Municipal Jury Fund 225.00 57.50 73.15 57.50 - 167.50 25.56 000 - 451600 Technology Fund Fee 19,452.00 2,891.43 3,520.00 2,891.43 - 16,560.57 14.86 000 - 451700 Security Fee 18,900.00 3,261.95 4,030.53 3,261.95 - 15,638.05 17.26 000 - 451800 Time Payment Fee -City 4,140.00 1,004.61 360.78 1,004.61 - 3,135.39 24.27 000 - 451850 State Fines 10% Service Fee 32,612.00 5,436.72 9,084.44 5,436.72 - 27,175.28 16.67 000 - 451900 DPS Payment -Local 5,052.00 1,015.76 604.00 1,015.76 - 4,036.24 20.11 000 - 452000 Child Safety Fee 5,880.00 478.76 1,911.48 478.76 - 5,401.24 8.14 000 - 452100 Platting Fees 54,000.00 20,250.00 6,000.00 20,250.00 - 33,750.00 37.50 000 - 452200 Site Plan Fee 23,000.00 6,000.00 4,500.00 6,000.00 - 17,000.00 26.09 000 - 452300 Plan Check Fee 600,000.00 85,868.25 113,113.25 85,868.25 - 514,131.75 14.31 000 - 452320 Tree Mitigation Admin Fee 15,000.00 10,057.50 38,640.00 10,057.50 - 4,942.50 67.05 000 - 452400 BOA/Variance Fees 2,500.00 1,500.00 - 1,500.00 - 1,000.00 60.00 000 - 452600 Specific Use /Zone Chng Fee 26,450.00 (2,500.00) 6,000.00 (2,500.00) - 28,950.00 (9.45) 000 - 452710 Zoning Ltr & Dev Rights 2,550.00 1,500.00 600.00 1,500.00 - 1,050.00 58.82 000 - 453100 Reinspection Fees 190,000.00 49,525.00 51,875.00 49,525.00 - 140,475.00 26.07 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 101 GENERAL FUND REVENUES CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D ENCUMBRANCE BUDGET BALANCE % OF BUDGET 000 - 453110 Swim Pool Inspection Fee 2,500.00 - - - - 2,500.00 - 000- 453200 Lot Abatement 5,000.00 1,700.00 1,400.00 1,700.00 - 3,300.00 34.00 000 - 453211 Admin Fee - Inspections 10,000.00 2,000.00 600.00 2,000.00 - 8,000.00 20.00 000 - 453310 Misc Inspection Fees - - - - - - - 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 - 252.00 - 252.00 - (252.00) - 000- 456120 Senior Center Meal Fee 20,000.00 4,823.46 7,654.29 4,823.46 - 15,176.54 24.12 000 - 456500 HAZ MAT Fees 5,000.00 - - - - 5,000.00 - 000- 456600 Fire Re- inspection Fee 750.00 - - - - 750.00 - 000- 458000 Sale of General Fixed Assets - 37,572.00 - 37,572.00 - (37,572.00) - 000- 458100 Sale of Merchandise - - 30.00 - - - - 000- 458110 Sale of Mdse - GovDeals 100,000.00 1,416.00 24,285.00 1,416.00 - 98,584.00 1.42 000 - 458400 Civic Center Rental Fees 140,000.00 46,013.25 1,725.00 46,013.25 - 93,986.75 32.87 000 - 458401 Capital Recovery Fee -Civic C - (600.00) 550.00 (600.00) - 600.00 - 000- 458402 Civic Center Ancillary Fees - 250.00 - 250.00 - (250.00) - 000- 458450 North Center Rental Fees 18,000.00 6,956.25 2,500.00 6,956.25 - 11,043.75 38.65 000 - 458460 Senior Center Rental 7,000.00 - - - - 7,000.00 - 000- 458500 Community Center Rental Fees 25,000.00 12,119.25 3,635.00 12,119.25 - 12,880.75 48.48 000 - 458501 Community Center Service Fees - 200.00 100.00 200.00 - (200.00) - 000- 458510 Grand Ballroom Rental Fees - (18,250.00) 7,612.50 (18,250.00) - 18,250.00 - 000- 458520 Cut -Off Hall Rental Fees - 600.00 2,831.25 600.00 - (600.00) - 000- 458530 Conference Hall Rental Fees - - 506.25 - - - - 000- 458540 Bluebonnet Hall Rental Fees - (1,525.00) 3,693.75 (1,525.00) - 1,525.00 - 000- 458550 Pavilion Rental Fees 20,000.00 3,482.50 1,925.00 3,482.50 - 16,517.50 17.41 000 - 458551 Equipment Rentals -Parks - - - - - - - 000- 458560 Chamber of Comm Rent 7,800.00 1,950.00 1,950.00 1,950.00 - 5,850.00 25.00 000 - 458570 Non- Resident SYSA League 10,000.00 - - - - 10,000.00 - 000- 458580 HOA Meeting Rental Fees - - 225.00 - - - - 000- 458581 Funeral Reception Rental Fees - - 225.00 - - - - 000- 458582 Quality of Life Rental Fees - - 1,500.00 - - - - 000- 458590 Cancellation Fees -Event Rental - 350.00 550.00 350.00 - (350.00) - 000- 458650 NonResident User Fee -BVYA 10,000.00 3,530.00 7,080.00 3,530.00 - 6,470.00 35.30 000 - 458660 BVYA Utility Reimbursement 15,000.00 3,912.00 7,838.38 3,912.00 - 11,088.00 26.08 000 - 458670 SYSA Utility Reimbursement 7,500.00 2,616.29 - 2,616.29 - 4,883.71 34.88 000 - 458675 Lions Futbol Utility Reimbrsmt 15,000.00 - 3,516.00 - - 15,000.00 - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 101 GENERAL FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES 000 - 458685 Recreation Programs 1,000.00 - - - - 1,000.00 - 000- 458685.05 Rec Prgrm- Kickball Leagues 2,600.00 - - - - 2,600.00 - 000- 458700 Vehicle Impoundment 11,000.00 3,380.00 2,640.00 3,380.00 - 7,620.00 30.73 000 - 459200 NSF Check Fee 100.00 - - - - 100.00 - 000- 459300 Notary Fee 48.00 6.00 36.00 6.00 - 42.00 12.50 000 - 459400 Maps,Copies,UDC & Misc Fees - - - - - - - 000- 459600 Animal Adoption Fee 9,000.00 2,185.00 1,940.00 2,185.00 - 6,815.00 24.28 000 - 459700 Pet Impoundment Fee 7,000.00 2,188.00 2,119.00 2,188.00 - 4,812.00 31.26 000 - 459800 Police Reports Fee 5,000.00 1,001.00 1,038.00 1,001.00 - 3,999.00 20.02 TOTAL Fees - 2,232,459.00 435,955.63 451,845.34 435,955.63 - 1,796,503.37 19.53% Fines 000 - 463000 Library Fines 9,000.00 2,270.68 1,208.98 2,270.68 - 6,729.32 25.23 TOTAL Fines 9,000.00 2,270.68 1,208.98 2,270.68 - 6,729.32 25.23% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077.00 5,269.44 15,808.32 5,269.44 - 15,807.56 25.00 000 - 473200 City of Seguin -Fire Contract 30,107.00 5,575.52 8,36128 5,575.52 - 24,531.48 18.52 000 - 473300 Guadalupe Co- Library 217,000.00 - 67,730.32 - - 217,000.00 - 000- 473400 Randolph AFB - Animal Control - - - - - - - 000- 474200 Library Services - Cibolo 40,000.00 - - - - 40,000.00 - 000- 474210 Library Services -Selma 26,000.00 - - - - 26,000.00 - 000- 474400 Dispatch Service - Cibolo 160,000.00 - - - - 160,000.00 - 000- 474600 School Crossing Guard -Bexar Co 36,000.00 9,284.88 8,998.48 9,284.88 - 26,715.12 25.79 000 - 474610 School Cross Guard - Guadalupe C 41,000.00 10,963.21 10,355.08 10,963.21 - 30,036.79 26.74 000 - 474620 School Crossing Guards - Comal 1,900.00 - - - - 1,900.00 - 000- 474700 School Officer Funding 367,514.00 91,878.00 - 91,878.00 - 275,636.00 25.00 000 - 474750 Crime Victim Liaison Agreement 50,000.00 6,250.00 12,500.00 6,250.00 - 43,750.00 12.50 TOTAL Inter - Jurisdictional 990,598.00 129,2211.05 123;755.48 129,221.05 - 861,376.95 1104% Fund Transfers 000 - 480000 Indirect Costs -EMS 212,740.00 53,185.03 44,775.00 53,185.03 - 159,554.97 25.00 000 - 480100 Indirect Costs -Hotel /Motel 74,443.00 18,610.78 18,607.03 18,610.78 - 55,832.22 25.00 000 - 481000 Transfer In - Reserves 2,289,008.00 - - - - 2,289,008.00 - 000- 485000 Interfund Charges- Drainage -5% 308,010.00 77,002.50 60,778.50 77,002.50 - 231,007.50 25.00 000 - 486000 Interfund Chrges -Admin W &S 1,478,230.00 369,557.53 346,249.97 369,557.53 - 1,108,672.47 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 - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 101 GENERAL FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES 000 - 487000 Interfund Charges -Fleet 505,509.00 126,377.25 90,166.78 126,377.25 - 379,131.75 25.00 000 - 488000 Interfund Charges -413 506,984.00 253,492.00 252,334.50 253,492.00 - 253,492.00 50.00 000 - 489000 Transfer In 203,706.00 - - - - 203,706.00 - TOTAL Fund Transfers 5,612,630.00 898,225.09 812,91118 898,225.09 - 4,714,404.91 16.00 % &" Miscellaneous 000 - 491000 Interest Earned 15,000.00 1,843.81 1,690.16 1,843.81 - 13,156.19 12.29 000 - 491200 Investment Income 120,000.00 7,538.39 20,083.34 7,538.39 - 112,461.61 6.28 000 - 491900 Unrealized Gain /Loss- CapOne - (7,719.74) (8,112.91) (7,719.74) - 7,719.74 - 000- 493000 Donations - Others - - - - - - - 000- 493120 Donations - Public Library 10,000.00 536.71 101.65 536.71 - 9,463.29 5.37 000 - 493400 Donations - Animal Control 5,000.00 1,087.00 1,735.00 1,087.00 - 3,913.00 21.74 000 - 493401 Donations -A /C Microchip - 55.00 315.00 55.00 - (55.00) - 000- 493460 Donations- Parks 10,000.00 - - - - 10,000.00 - 000- 493465 Donations - Senior Center 10,000.00 1,497.00 - 1,497.00 - 8,503.00 14.97 000 - 493503 Donation -Fire Rescue 1,000.00 - 400.00 - - 1,000.00 - 000- 493618 Donation - Veteran's Memorial 1,250.00 1,050.00 900.00 1,050.00 - 200.00 84.00 000 - 493700 July 4th Activities 26,000.00 - - - - 26,000.00 - 000- 493701 Proceeds - Holidazzle 12,500.00 14,500.00 3,290.00 14,500.00 - (2,000.00) 116.00 000 - 493704 Moving on Main 4,000.00 - - - - 4,000.00 - 000- 493707 Cornhole League - - - - - - - 000- 494481 LawEnforcemtOfficersStnd& 5,000.00 - - - - 5,000.00 - 000- 494482 Grants - Police, Fire, Gen Fund 12,500.00 - 541.11 - - 12,500.00 - 000- 495100 Mobile Stage Rental Fees - - - - - - - 000- 497000 Misc Income -Gen Fund 50,000.00 7,746.02 13,358.64 7,746.02 - 42,253.98 15.49 000 - 497005 Schertz Magazine Advertising 140,000.00 34,852.50 36,461.62 34,852.50 - 105,147.50 24.89 000 - 497100 Misc Income - Police 9,000.00 1,646.11 3,92192 1,646.11 - 7,353.89 18.29 000 - 497200 Misc Income - Library 3,000.00 650.00 469.25 650.00 - 2,350.00 21.67 000 - 497210 Misc Income - Library Copier 15,000.00 3,271.60 1,127.50 3,271.60 - 11,728.40 21.81 000 - 497300 Misc Income - Animal Control 800.00 - 150.00 - - 800.00 - 000- 497400 Misc Income - Streets Dept 50,000.00 10,355.83 2,976.00 10,355.83 - 39,644.17 20.71 000 - 497460 Misc Income -Parks - - - - - - - 000- 497500 Misc Income -TML Ins. Claims 25,000.00 830.26 1,444.45 830.26 - 24,169.74 3.32 000 - 497550 Misc Income -TML WC Reimbursmnt 10,000.00 22,201.62 3,549.48 22,201.62 - (12,201.62) 222.02 000 - 497600 Misc Income - Vending Mach 2,500.00 493.60 91.38 493.60 - 2,006.40 19.74 000 - 497610 Misc Income -Muni Court - 1.80 - 1.80 - (1.80) - 000- 498000 Reimbursmnt -Gen Fund 20,000.00 - - - - 20,000.00 - 000 - 498100 Reimburmnt Fire - Training CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 101 GENERAL FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES 000 - 498105 Reimbursmt Police OT -DEA 35,000.00 7,532.01 11,766.53 7,532.01 - 27,467.99 21.52 000 - 498107 Reimbrsmnt - Police OT- Events - - - - - - - 000- 498110 Reimburmnt Fire -Emg Acti -OT 100,000.00 399,401.39 - 399,401.39 - (299,401.39) 399.40 000 - 498150 Reimbursement - Library 13,000.00 - 8,598.66 - - 13,000.00 - CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool- Checking Cash in Investments LOGIC Investment - General Fund LOGIC Investment -Equip Replacement LOGIC Investment -Veh Replacement LOGIC Investment -Air Condi Replacment CAPITAL ONE Investment - General Fund CD - Bank of New York CD - Capital One MCLEAN CD - Capital One ALLEN CD - Goldman Sachs $ 2,933,122.68 13,082,872.99 79,116.91 533,468.20 290, 317.50 1,460,486.34 249,000.00 249,000.00 249,000.00 249,000.00 Total Cash in Bank & Investments $ 20,425,081.02 Sales Tax-General Fund ADVALOREM TAX CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CITY orsc*snrZ CURRENT CURRENT PRIOR YEAR Y-T{] ,�o Y-TD ACTUAL BUDGET % 106'SPEC|#LEVE0TS FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Miscellaneous 24.000.00 35.628.89 38.532.09 35.028.89 - (11.628.80) 148.45 TOTALREVENUES 24,000.00 35,62&89 28,53209 35,62&89 (11,628.89) 148.45% EXPENDITURE SUMMARY GENERAL GOVERNMENT CULTURAL� KICK CANCER 10.000.00 - - - - 10.000.08 - HALBALDVV|NSCHOLARSHIP 14'000.80 14.708.88 12.888.35 14.706.88 - (706.88) 105.05 CITY OF SCHERTZ 106 - SPECIAL EVENTS FUND REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: Decmber 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D Y -T -D BUDGET % OF BUDGET QUARTER ACTUAL ENCUMBRANCE BALANCE BUDGET Miscellaneous 000 - 491200 Investment Income - 2.55 7.09 2.55 - (2.55) - 000- 492200 Kick Cancer 10,000.00 - - - - 10,000.00 - 000- 493621 Hal Baldwin Scholarship 14,000.00 35,626.34 28,525.00 35,626.34 - (21,626.34) 254.47 000 - 497000 Misc Income - Special Events - - - - - - - SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: September 30, 2021 CITY OF SCHERTZ Cash in Bank Current Claim on Operating Cash Pool- Checking $ 123,717.97 Cash in Investments Texas Class- Special Events 18,050.85 Total Cash in Bank & Investments $ 141,768.82 qcTw.v2m 3 I I a, a CITY PUBLIC SERVICE ME CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 110 -PEG FUND BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 110,000.00 20,581.45 20,977.62 20,581.45 - 89,418.55 18.71 Fund Transfers 240,000.00 - - - - 240,000.00 - TOTAL REVENUES 350,000M 20,581.45 20,077.62 20,581 ;45 329,418.55 5.88° EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental MISC & PROJECTS Projects Capital Outlay - - - - - - - 110-PEG FUND REVENUES CITY O F S C H E R T Z REVENUE REPORT (UNAUDKED) AS OF: December 31, 2021 CURRENT CURRENT v�� BUDGET 96DF PR0RYEAR Y��) YT-DACTUAL BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET Franchises 000-421350 TimeVVarner - PEGFaa 60.000.00 18.022.29 15.560.70 18.022.29 - 43.977J1 28.70 000-421485 AT&T PEG Fee 50.000.00 4.558.18 5.416.92 4.550.16 - 45.440.84 9.12 TOTAL Franchises 110,000.00 20,581.45 20,977.62 20,581 A5 - 89,418.55 18.71% Fund Transfers 000-481000 Tnanafer|n - Reaerveo 240.000.00 - - - - 240.000.00 - Miscellaneous TOTALREVENUES 350,000.00 20,581.45 20,977.62 20,581.45 329,418.55 5.88% PEG FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Cash Balance $ 967,035.50 Total Cash in Bank & Investments $ 967,035.50 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31. 2021 CURRENT CURRENT Y -T -D BUDGET % OF 202 -WATER & SEWER BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Franchises 304,487.00 54,278.33 15,778.09 54,278.33 - 250,208.67 17.83 Permits - - - - - - - Fees 27,485,000.00 6,874,051.64 5,994,906.21 6,874,051.64 - 20,610,948.36 25.01 Fund Transfers 526,000.00 37,500.00 36,600.00 37,500.00 - 488,500.00 7.13 Miscellaneous 443,236.00 91,132.78 50,305.95 91,132.78 - 352,103.22 20.56 TOTAL REVENUES 28,758;72100 7,056,962:75 6,697,590,25 7,056,96275 21,704,760.25 24.54% EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges /Transfers - - 19,745.69 - - - - TOTAL NON! DEPARTMENTAL 19,745:69 - - 0.00% BUSINESS OFFICE Personnel Services 547,378.00 156,334.82 134,141.75 156,334.82 - 391,043.18 28.56 Supplies 185,100.00 4,542.78 431.65 4,542.78 240.90 180,316.32 2.58 City Support Services 68,500.00 36,064.69 - 36,064.69 - 32,435.31 52.65 Utility Services 9,400.00 1,769.26 2,255.29 1,769.26 - 7,630.74 18.82 Operations Support 102,500.00 24,183.10 21,746.24 24,183.10 - 78,316.90 23.59 Staff Support 6,400.00 1,190.61 337.95 1,190.61 58.94 5,150.45 19.52 Professional Services 259,000.00 55,924.18 48,013.56 55,924.18 - 203,075.82 21.59 Maintenance Services 5,040.00 1,260.00 1,680.00 1,260.00 3,780.00 - 100.00 Operating Equipment - - - - - - - TOTAL BUSINESS OFFICE 1,247,318.00 281,269.44 208,606.44 281,269.44 62,404.34 = 903,644.22 27.55 %< W & S ADMINISTRATION Personnel Services 1,951,955.00 457,143.00 497,538.47 457,143.00 - 1,494,812.00 23.42 Supplies 62,000.00 3,456.85 1,675.11 3,456.85 1,944.43 56,598.72 8.71 City Support Services 178,500.00 71,050.71 66,053.46 71,050.71 500.00 106,949.29 40.08 Utility Services 3,573,200.00 761,107.02 848,996.96 761,107.02 81.18 2,812,011.80 21.30 Operations Support 12,050.00 1,509.34 1,397.40 1,509.34 31.00 10,509.66 12.78 Staff Support 43,000.00 3,290.81 7,156.01 3,290.81 162.38 39,546.81 8.03 City Assistance 250.00 40.00 - 40.00 - 210.00 16.00 Professional Services 476,970.00 67,546.77 20,268.79 67,546.77 6,235.00 403,188.23 15.47 Fund Charges /Transfers 6,825,826.00 1,997,427.13 1,953,535.19 1,997,427.13 - 4,828,398.87 29.26 Maintenance Services 9,247,240.00 1,896,183.30 1,431,501.81 1,896,183.30 189,002.19 7,162,054.51 22.55 Other Costs 38,500.00 36,605.45 - 36,605.45 - 1,894.55 95.08 Debt Service 1,518,553.00 - - - 908,937.50 609,615.50 59.86 Rental /Leasing 4,000.00 26,076.94 26,060.14 26,076.94 17,000.00 (39,076.94) 1,076.92 Operating Equipment 9,000.00 485.54 - 485.54 - 8,514.46 5.39 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31. 2021 CURRENT CURRENT Y -T -D BUDGET % OF 202 -WATER & SEWER BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY Capital Outlay 163,000.00 32,158.31 - 32,158.31 142,260.54 (11,418.85) 107.01 TOTAL PUBLIC WORKS 24,104,044.00 5,354,081.17 4,854,183.34 5,354,081.17 1,266,154.22 17,483,808.61 27.47 %': MISC & PROJECTS PROJECTS Professional Services 0.00 - 2,117.50 - 3,469.00 (3,469.00) - Maintenance Services 0.00 - 226,024.86 - 4,500.00 (4,500.00) - Rental /Leasing 570,000.00 - - - - 570,000.00 - TOTAL PROJECTS 570,000.00 r 228,142.36 - 7,969.00 562,031.00 1.40% SEWER PROJECT Professional Services Fund Charges /Transfers CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31. 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 202 -WATER & SEWER BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES Franchises 000 - 421490 Cell Tower Leasing 304,487.00 54,278.33 15,778.09 54,278.33 - 250,208.67 17.83 TOTAL Franchises 304,487.00 54,278.33 15,778.09 54,278.33 - 250,208 67 17.83% Permits 000 - 436010 Network Nodes 0.00 - - - - - TOTAL Permits 0.00 0.00 %' Fees 000 - 455200 Garbage Collection Fee 5,300,000.00 1,368,976.75 1,199,212.79 1,368,976.75 - 3,931,023.25 25.83 000 - 455600 Fire Line Fees - - - - - - - 000- 455700 Recycle Fee Revenue 345,000.00 86,200.63 72,123.22 86,200.63 - 258,799.37 24.99 000 - 455800 W &S Line Constructn Reimbur 25,000.00 2,797.00 6,658.00 2,797.00 - 22,203.00 11.19 000 - 457100 Sale of Water 12,600,000.00 3,047,494.41 2,777,159.58 3,047,494.41 - 9,552,505.59 24.19 000 - 457110 Edwards Water Lease 40,000.00 - - - 40,000.00 - 000- 457120 Water Transfer Charge -Selma 30,000.00 - 13,881.72 - - 30,000.00 - 000- 457200 Sale of Meters 120,000.00 12,174.55 29,328.06 12,174.55 - 107,825.45 10.15 000 - 457400 Sewer Charges 8,770,000.00 2,282,719.30 1,896,117.84 2,282,719.30 - 6,487,280.70 26.03 000 - 457500 Water Penalties 250,000.00 73,064.00 100.00 73,064.00 - 176,936.00 29.23 000 - 458110 Sale of Merchandise - GovDeals 2500.00 - - - - 2,500.00 - 000- 459200 NSF Check Fee -Water &Sewer 2,500.00 625.00 325.00 625.00 - 1,875.00 25.00 TOTAL Fees 27,485,000.00 6,874,051.64 5,994,906.21 6,874,051.64 ! - 20,610,948.36 25.01% Fund Transfers 000 - 486000 Transfer In - Reserves 91,000.00 - - - - 91,000.00 - 000- 486204 Interfnd Chrg- Drainage Billing 150,000.00 37,500.00 36,600.00 37,500.00 - 112,500.00 25.00 000 - 486406 Transfer In - Pblc Imprvmnt 0.00 - - - - - - TOTAL 'Fund Transfers = 526,000.00 37;500.00 36,600.00 37,500.00 - 488,500.00 7.13 % Miscellaneous 000 - 490000 Misc Charges 10,500.00 2,963.00 50.00 2,963.00 - 7,537.00 28.22 000 - 491000 Interest Earned 20,000.00 2,842.49 2,177.00 2,842.49 - 17,157.51 14.21 000 - 491200 Investment Income 90,000.00 996.71 3,143.63 996.71 - 89,003.29 1.11 000 - 495013 Capital Contribution -W &S 0.00 - - - - - - 000- 496000 Water Construction Reserve Acc 0.00 - - - - - - 000- 497000 Misc Income -W &S 25,000.00 1,008.30 10,320.79 1,008.30 - 23,991.70 4.03 000 - 498110 Salary Reimb -SSLGC 297,736.00 83,322.29 34,614.53 83,322.29 - 214,413.71 27.99 000 - 499100 Distribution -GSE Bond Set - (0.01) - (0.01) - 0.01 - TOTAL 'Miscellaneous 443,236.00 91,132.78 50,305.95 91,132.78 352,10122 20.56% TOTAL REVENUES 28,758,723.00 7,056,962.75 6,097,590.25 7,056 962.75 - 21,701,760.25 24.54% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 :.N. Claim on Operating Cash Pool- Checking Cash in Investments Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Schertz Bank & Trust - Certificate of Deposit $ 309,181.63 4,734,695.84 317,599.74 190,955.92 275,853.14 1,163, 351.07 $ 6,682,455.71 Total Cash in Bank & Investments $ 6,991,637.34 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31. 2021 203 -EMS FINANCIAL SUMMARY CURRENT BUDGET CURRENT QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D ENCUMBRANCE BUDGET BALANCE % OF BUDGET REVENUE SUMMARY Fees 6,545,489.60 1,881,021.49 1,586,686.67 1,881,021.49 - 4,664,468.11 28.74 Inter - Jurisdictional 3,985,932.54 1,248,298.49 1,445,671.54 1,248,298.49 - 2,737,634.05 31.32 Fund Transfers 1,088,672.00 - - - - 1,088,672.00 - Miscellaneous 174,500.00 117,834.63 27,276.30 117,834.63 - 56,665.37 67.53 TOTAL' REVENUES 11,794,594.14 3,247,154.61 3,059,634 51 3,247,154.61 8,547,439.53 27.53% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 5,576,958.00 1,634,724.38 1,314,098.70 1,634,724.38 - 3,942,233.62 29.31 Supplies 387,250.00 148,141.02 55,841.99 148,141.02 10,455.78 228,653.20 40.95 City Support Services 138,000.00 44,047.12 39,073.05 44,047.12 - 93,952.88 31.92 Utility Services 106,000.00 24,793.11 20,980.97 24,793.11 1,255.97 79,950.92 24.57 Operations Support 40,000.00 9,520.21 9,913.75 9,520.21 593.70 29,886.09 25.28 Staff Support 73,265.00 26,936.05 5,920.06 26,936.05 4,085.66 42,243.29 42.34 City Assistance 626,989.01 103,517.48 155,226.25 103,517.48 51,886.75 471,584.78 24.79 Professional Services 123,500.00 63,487.22 36,228.54 63,487.22 39,000.01 21,012.77 82.99 Fund Charges /Transfers 2,663,735.60 818,182.50 622,172.37 818,182.50 - 1,845,553.10 30.72 Maintenance Services 13,000.00 960.00 960.00 960.00 - 12,040.00 7.38 Other Costs 0.00 - - - - - - Debt Service 118120.00 - - - - 118,120.00 - Rental /Leasing 150,000.00 - - - - 150,000.00 - Operating Equipment 115,298.00 4,909.78 9,090.87 4,909.78 2,174.74 108,213.48 6.14 Capital Outlay 1,603,978.00 517,571.78 254,745.00 517,571.78 347,189.55 739,216.67 53.91 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31. 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 203 -EMS BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES Fees 000 - 456100 Ambulance /Mileage Transprt Fee 6,206,889.60 1,761,969.54 1,478,585.98 1,761,969.54 - 4,444,920.06 28.39 000 - 456110 Passport Membership Fees 28,000.00 20,545.00 19,640.00 20,545.00 - 7,455.00 73.38 000 - 456120 EMT Class - Fees 137,500.00 44,000.00 30,250.00 44,000.00 - 93,500.00 32.00 000 - 456122 CE Class - Fees 24,000.00 - 2,318.77 - - 24,000.00 - 000- 456130 Immunization Fees 3,000.00 1,241.50 1,336.40 1,241.50 - 1,758.50 41.38 000 - 456140 Billing Fees - External 26,000.00 3,936.20 5,551.22 3,936.20 - 22,063.80 15.14 000 - 456150 Standby Fees 30,000.00 34,679.95 29,320.20 34,679.95 - (4,679.95) 115.60 000 - 456155 Community Services Support 50,000.00 6,157.30 10,344.10 6,157.30 - 43,842.70 12.31 000 - 456160 MIH Services 40,000.00 8,442.00 9,315.00 8,442.00 - 31,558.00 21.11 000 - 459200 NSF Check Fee 100.00 50.00 25.00 50.00 - 50.00 50.00 TOTAL Fees 6,545,489.60 1,881,021.49 1,586,686.67 1,881,021.49 - 4,664,468.11 28.74 %l Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 927,934.89 231,983.73 309,311.64 231,983.73 - 695,951.16 25.00 000 - 474200 JBSA Support 635,706.00 - - - - 635,706.00 - 000- 474300 Cibolo Support 529,043.95 132,260.99 236,557.62 132,260.99 - 396,782.96 25.00 000 - 475100 Coma] Co ESD #6 148,870.54 35,952.30 33,554.48 35,952.30 - 112,918.24 24.15 000 - 475200 Live Oak Support 280,240.92 70,060.23 123,127.92 70,060.23 - 210,180.69 25.00 000 - 475300 Universal City Support 335,884.88 83,971.22 160,783.02 83,971.22 - 251,913.66 25.00 000 - 475400 Selma Support 180,290.22 45,072.56 85,720.50 45,072.56 - 135,217.66 25.00 000 - 475500 Schertz Support 695,644.24 173,911.06 333,524.34 173,911.06 - 521,733.18 25.00 000 - 475600 Santa Clara Support 11,953.03 2,988.26 5,727.60 2,988.26 - 8,964.77 25.00 000 - 475800 Marion Support 21,363.87 5,340.97 9,187.38 5,340.97 - 16,022.90 25.00 000 - 475910 TASPP Program 219,000.00 466,757.17 148,177.04 466,757.17 - (247,757.17) 213.13 TOTAL Inter-Jurisdictional 3,985,932.54 1,248,298.49 1,445,671,54 1,248,298.49 - 2,737,634.05 31.32 %r Fund Transfers - 000- 486000 Transfer In- Reserves 755,172.00 - - - - 755,172.00 - TOTAL 'Fund Transfers 1,088,672.00 - - - - 1,088,672.00 0.00% Miscellaneous 000 - 491000 Interest Earned 2,500.00 75.03 157.00 75.03 - 2,424.97 3.00 000 - 491200 Investment Income 5,000.00 111.14 389.20 111.14 - 4,888.86 2.22 000 - 493203 Donations -EMS 2,000.00 650.00 865.00 650.00 - 1,350.00 32.50 000 - 497000 Misc Income 75,000.00 108,578.96 2,248.00 108,578.96 - (33,578.96) 144.77 000 - 497100 Recovery of Bad Debt 20,000.00 392.58 6,210.17 392.58 - 19,607.42 1.96 000 - 497110 Collection Agency -Bad Debt 70,000.00 8,026.92 17,406.93 8,026.92 - 61,973.08 11.47 TOTAL Miscellaneous 174,500.00 117,834;63 27,276;30 117,834.63 - 56,66537 67.53% TOTAL'`REVENUES 11,794,594.14 3,247,154.61 3,059,634.5'1 3,247,154.61 - 8,547,439.53 27.53 %d CITY OF SCHERTZ CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool- Checking Cash in Investments EMS -Logic SR 2017 Ambulance -Logic $ 323,014.28 647,538.60 12.11 Total Cash in Bank & Investments $ 970,564.99 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 EXPENDITURE SUMMARY CURRENT CURRENT Y -T -D BUDGET % OF 204 - DRAINAGE BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY DRAINAGE REVENUE SUMMARY Personnel Services 467,657.00 108,903.48 116,190.36 Permits 4,000.00 2,250.00 800.00 2,250.00 - 1,750.00 56.25 Fees 1,260,000.00 312,530.57 269,888.10 312,530.57 - 947,469.43 24.80 Fund Transfers 17,229.00 - - - - 17,229.00 - Miscellaneous 3,000.00 106.17 361.11 106.17 - 2,893.83 3.54 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 467,657.00 108,903.48 116,190.36 108,903.48 - 358,753.52 23.29 Supplies 6,000.00 62.25 1,099.61 62.25 - 5,937.75 1.04 City Support Services 35,000.00 3,211.39 3,117.27 3,211.39 380.71 31,407.90 10.26 Utility Services 14,700.00 4,668.94 4,078.42 4,668.94 - 10,031.06 31.76 Operations Support 1,050.00 - - - - 1,050.00 - Staff Support 13,700.00 1,727.87 922.48 1,727.87 260.41 11,71 1.72 14.51 City Assistance 500.00 40.00 - 40.00 - 460.00 8.00 Professional Services 58,500.00 1,400.00 58.50 1,400.00 - 57,100.00 2.39 Fund Charges /Transfers 574,817.00 143,454.28 140,019.76 143,454.28 - 431,362.72 24.96 Maintenance Services 83,000.00 - 1,836.51 - 4,160.00 78,840.00 5.01 Other Costs 100.00 - - - - 100.00 - Debt Service - - - - - - - Rental /Leasing 500.00 - - - - 500.00 - Operating Equipment 2,500.00 - - - - 2,500.00 - CapitalOutlay 14,000.00 - - - 13,903.04 96.96 99.31 TOTAL DRAINAGE 1,272,024`.00 263,468.21 267,322.91 263,468.21 18,704.16 989,851.63 22.18 %'' PROJECTS Professional Services - - - - - - - Maintenance Services - 26,517.40 (8,000.00) 26,517.40 7,980.95 (34,498.35) - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31. 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 204 - DRAINAGE BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES Permits 000 - 432400 Floodplain Permit 4,000.00 2,250.00 800.00 2,250.00 - 1,750.00 56.25 TOTAL Permits 4,000.00 2,250.00 800.00 2,250.00 1,750.00 56.25 %' Fees 000 - 457500 Drainage Penalties 10,000.00 2,206.87 - 2,206.87 - 7,793.13 22.07 000 - 457600 Drainage Fee 1,250,000.00 310,32170 269,888.10 310,323.70 - 939,676.30 24.83 000 - 458110 Sale of Merchandise - GovDeals - - - - - - - TOTAL Fees 1,260,000.00 312,530.57 269,888.10 312,530.57 - 947,469.43 24.80% Fund Transfers 000 - 481000 Transfer In - Reserves - - - - - - - 000- 486100 Transfer In 17,229.00 - - - - 17,229.00 - 000- 486202 Transfer In -Water &Sewer Fund - - - - - - - 000- 486405 Transfer -In Grant Fund - - - - - - - TOTAL Funds Transfers 17,229.00 - - - - 17,229.00 0.00 %.! Miscellaneous 000 - 491000 Interest Earned 1,000.00 28.75 19.77 28.75 - 971.25 2.88 000 - 491200 Investment Income 2,000.00 77.42 341.34 77.42 - 1,922.58 3.87 000 - 493204 Donations- Drainage Projects - - - - - - - 000- 494495 Other Financing - Capital Lease - - - - - - - 000- 495000 Grant Reimbursement - - - - - - - 000- 495013 Capital Contributions - Drainage - - - - - - - 000- 497000 Misc Income - Drainage 0.00 - - - - - - 000- 497100 MISC INCOME -SCRAP METAL,' 0.00 - - - - - - 000 - 498300 Reimburmnt -City Property DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 _.t t . .. Claim on Operating Cash Pool- Checking $ 37,582.57 Cash in Investments Lone Star Investment - Drainage Maint Fund 381,299.77 Total Cash in Bank & Investments $ 418,882.34 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 EXPENDITURE SUMMARY CURRENT CURRENT vT-D BUDGET % 314-HOTEL TAX BUDGET QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL ewouMoRxmos BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Supplies 0l0 ' ' Taxes 520.000.00 194.600.13 05.244.04 194.000.13 - 325.531.07 3744 Fund Transfers 1.150.000.00 - - - - 1.150.000.00 - Miscellaneous 5.250.00 334.94 820.37 334.94 - 4.915.06 6.38 EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 0l0 ' ' City Support Services 112�66.00 25.826.44 24.583.02 25.82644 86.630.56 22.96 Operations Support 31.000.00 5.28450 4.180.00 5.284.50 4.200.00 21.515.50 30.60 Professional Services 3.500.00 240.00 240.00 480.00 2.780.00 20.57 FundChangao/Trandbm 74.443.00 18.01078 18.007.03 18.610J8 55.83222 25.00 Maintenance Services 50.000.00 29.82 55.023.60 29.82 45.348.81 4.021.37 8070 Operating Equipment 44.888.00 1.072.68 - 1.072.08 44.78775 (872.43) 10217 Capital Outlay 20000.00 - - - - 20.800.00 - TOTAL NONDEPARTMENTAL 336,297.00 51,064.22 102,999.65 51,064.22 94,816.56 190,416.22 43.38% TOTAL GENERAL GOVERNMENT 336,297.00 51,064.22 102,999.65 51,064.22 94,816.56 190,416.22 43.38% M|GC&PROJECTS PROJECTS Professional Services 93.500D0 7.910.00 - 7.910.00 39.031.00 40.559.00 5020 TOTAL PROJECTS 1,243,500.00 7,910.00 7,910.00 39,031.00 1,196,559.00 3.77% HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 _.t t . .. Claim on Operating Cash Pool- Checking $ 107,527.06 Cash in Investments Texas Class - Hotel Tax 2,265,274.80 Total Cash in Bank & Investments $ 2,372,801.86 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 HOTEL OCCUPANCY TAX OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ,*.2021-22 65,789 63,938 62,952 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 8fi43 8,934 13,859 15,559 25J15 29,624 2018-19 44,431 43,858 40,307 38,034 41,886 55,316 44,285 43,642 36,501 44,160 34,532 36,619 2017-18 37,415 38,911 30,706 31,786 48,161 52,784 52,258 53,747 50,639 58,448 46,800 36,619 CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: December 31, 2021 317-PARK FINANCIAL SUMMARY CURRENT BUDGET CURRENT Y-T-D QUARTER PRIOR YEAR Y-T-D Y-T-D ACTUAL smouMBRxmcE BUDGET BALANCE Y6OF BUDGET REVENUE SUMMARY Fees 318.000.00 - - - - 318.000.00 - Fund Transfers - - - - - - - K4iooaUanoouo 1.025.00 4035 114.87 40.35 - 084.65 3.04 TOTAL REVENUES 319,02500 4035 114.67 40.35 318,984.65 0.01% EXPENDITURE SUMMARY NON DEPARTMENTAL PARKLAND DEDICATION Professional Services 25.000D0 - - - - 25.000.00 - Capital Outlay 100.000�00 - - - - 100.000.00 - 317 -PARK REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D ENCUMBRANCE BUDGET % OF BUDGET QUARTER BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 318,000.00 - - - - 318,000.00 TOTAL Fees 318,000.00; - - - - 318,000.00 0.00 %a Fund Transfers 000 -48100 Transfer In- Reserves - - - - - - - TOTAL Fund Transfers - - - - 0.00 % Miscellaneous 000 - 491000 Interest Earned 25.00 0.30 3.16 0.30 - 24.70 1.20 000 - 491200 Investment Income 1,000.00 40.05 111.51 40.05 - 959.95 4.01 000 - 493700 Donations 0.00 - - - - - - PARKFUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Current Claim on Operating Cash Pool-Checking 859.21 Cash in Investments Texas Class- Park Fund Total in Investment Pool 9.0M. 286,198.50 Total Cash in Bank & Investments 287,057.71 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT Y -T -D BUDGET % OF 319 -TREE MITIGATION BUDGET QUARTER PRIOR YEAR Y -T -D Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 70,000.00 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42 Miscellaneous 1,400.00 104.95 237.54 104.95 - 1,295.05 7.50 TOTAL REVENUES 71400,.01 57,1}97.45 219097,54 57,097.45 - 14,3012.55 79.0 EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services 70,000.00 13,600.00 2,925.00 13,600.00 2,700.00 53,700.00 23.29 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D ENCUMBRANCE BUDGET % OF 319 -TREE MITIGATION BUDGET QUARTER BALANCE BUDGET REVENUES Fees 000 - 458900 Tree Mitigation 70,000.00 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42 TOTAL Fees 70;000.00 56,992.50 218,960.00 56,992.50 - 13,007.50 81.42% Fund Transfers Miscellaneous 000 - 491000 Interest Earned 200.00 17.59 7.19 17.59 - 182.41 8.80 000 - 491200 Investment Income 1,200.00 87.36 230.35 87.36 - 1,112.64 7.28 000 - 497000 Misc Income - - - - - - TOTAL Miscellaneous `s 1,400.00 104.95 237.54 104.95 - 1,295 05 7.50 %< TOTAL REVENUES 71,400.00 57,097.45 219,197.54 57,097.45 ? - 14,302.55 79.97 % >s TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool- Checking $37,952.67 Cash in Investments MBIA Investment -Tree Mitigation 653,439.99 Total Cash in Bank & Investments $691,392.66 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31. 2021 MISC & PROJECTS PROJECTS Fund Charges/Transfers CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 411 - CAPITAL RECOVERY WATER BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 1,100,000.00 151,434.00 324,207.00 151,434.00 - 948,566.00 13.77 Miscellaneous 16,000.00 1,848.88 3,504.90 1,848.88 - 14,151.12 11.56 TOTAL REVENUES 1,116,000.00 153,282.88 ... 327,711.9(} 153,282.88 . .... 962,717.12 13,74% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 51,000.00 2,877.37 - 2,877.37 78,417.12 (30,294.49) 159.40 TOTAL NON DEPARTMENTAL ! 51,000.00 2,877.37 - 2,877.37 78,417.12 (30,294.49) 159.40 %; MISC & PROJECTS PROJECTS Fund Charges/Transfers CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 411 - CAPITAL RECOVERY WATER BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET REVENUES Fees 000 - 455900 Cap Rcvry-Water 1,100,000.00 151,434.00 324,207.00 151,434.00 - 948,566.00 13.77 TOTAL Fees 1,100,000.00 151,434.00 324,207 00 151,434.00 - 948,566.00 13.77 %< Fund Transfers Miscellaneous - 000- 491000 Interest Earned 1,000.00 52.01 64.50 52.01 - 947.99 5.2 000 - 491200 Investment Income 15,000.00 1,796.87 3,440.40 1,796.87 - 13,203.13 11.98 TOTAL Miscellaneous 16,000.00 1,848.88 3,504`90 1,848.88 - 14,151.`12 11.56% TOTAL REVENUES 1,116,000.00 153,282.88 327,711.90 153,282.88 - 962,717.12 13.74 %! CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool- Checking $ 21,343.64 Cash in Investments Lone Star Investment - Capital Recovery Water 8,385,926.67 Total Cash in Bank & Investments $ 8,407,270.31 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 183.64 Fund Charges /Transfers - - - - - - - TOTAL NON DEPARTMENTAL 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 1`83.64% MISC & PROJECTS CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF 421 - CAPITAL RECOVERY SEWER BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET FINANCIAL SUMMARY REVENUE SUMMARY Fees 600,000.00 68,955.12 174,222.60 68,955.12 - 531,044.88 11.49 Miscellaneous 60,250.00 1,628.40 3,110.78 1,628.40 - 58,621.60 2.70 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 183.64 Fund Charges /Transfers - - - - - - - TOTAL NON DEPARTMENTAL 55,500.00 4,018.36 1,138.38 4,018.36 97,902.49 (46,420.85) 1`83.64% MISC & PROJECTS 421 - CAPITAL RECOVERY SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF BUDGET QUARTER ENCUMBRANCE BALANCE BUDGET Fees 000 - 455910 Cap Rcvey -Waste Water 600,000.00 68,955.12 174,222.60 68,955.12 - 531,044.88 11.49 TOTAL Fees 600,000.00 68,955.12 174,222.60 68,955.12 '' - 531,044.88 11.49% Fund Transfers Miscellaneous 000 - 491000 Interest Earned 250.00 8.54 50.08 8.54 - 241.46 3.42 000 - 491200 Investment Income 60,000.00 2,958.00 9,429.91 2,958.00 - 57,042.00 4.93 000 - 491900 Unrealize Gain /Loss -Captl One 0.00 (1,338.14) (6,369.21) (1,338.14) - 1,338.14 - TOTAL Miscellaneous ` 60,250.00 1,628.40 3,110.78 1,628.40 58,621.60 210 %' TOTAL REVENUES 660,250.00 70,583.52 177,33338 70,583.52 - 589,666.48 10.69% CAPITAL RECOVERY SEWER Cash in Investments Lone Star Investment - Capital Recovery Sewer 5,998,320.70 Capital One - Investment 1,829,441.70 Total Cash in Bank & Investments $ 178,435.38 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 . 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF BUDGET 505 -TAX I &S BUDGET QUARTER ENCUMBRANCE BALANCE FINANCIAL SUMMARY REVENUE SUMMARY Taxes 7,329,862.00 3,861,752.02 3,783,422.72 3,861,752.02 - 3,468,109.98 52.69 Fund Transfers - - - - - - - Miscellaneous 105,000.00 5,809.03 25,393.68 5,809.03 - 99,190.97 5.53 TOTAL REVENUES 7,434,862.00 3,867,561.05 3,808,816.40 3,867,561.05 - 3,567,360.95 52.02% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 50,000.00 45,293.39 174,999.52 45,293.39 - 4,706.61 90.59 Debt Service 6,626,915.00 - - - 1,982,996.88 4,643,918.12 29.92 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 . 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF BUDGET 505 -TAX I & S BUDGET QUARTER ENCUMBRANCE BALANCE REVENUES Taxes 000 - 411900 Property Tax Revenue 7,329,862.00 3,861,752.02 3,783,422.72 3,861,752.02 - 3,468,109.98 52.69 TOTAL Taxes 7,329,862.00 3,861,752.02 3,783,422.72 3,861,752.02 3,468,109.98 52.69 % i Fund Transfers 000 - 486100 Transfer In - - - - - - - 000- 486401 Transfer In -Bond Project Fund - - - - - TOTAL Fund Transfers ' 0.00 - 0.00 % ' Miscellaneous 000 - 491000 Interest Earned 1,000.00 21.35 50.97 21.35 - 978.65 2.14 000 - 491200 Investment Income 4,000.00 169.93 342.71 169.93 - 3,830.07 4.25 000 - 495020 Contribution From YMCA 100,000.00 - 25,000.00 - - 100,000.00 - 000- 498000 Proceeds From Refunding Debt - 5,617.75 - 5,617.75 - (5,617.75) - TOTAL Miscellaneous 105,000.00 5,809.03 25,39168 5,809.03 - 99,190.97 5.53% TOTAL REVENUES 7,434,862.00 3,867,561.05 3,808,816.40 3,867,561.05 - 3,567,300.95 52.02 % '' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 , 2021 505 -TAX I & S CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET % OF BUDGET GENERAL GOVERNMENT BUDGET QUARTER ENCUMBRANCE BALANCE NON DEPARTMENTAL Professional Services 101 - 541500 Paying Agent 5,000.00 600.00 200.00 600.00 4,400.00 12.00 101 - 541502 Cost of Bond Issuance 45,000.00 44,693.39 174,799.52 44,693.39 306.61 99.32 TOTAL Professional Services 50,000.00 45,293.39 174,999.52 45,293.39 4,706.61 90.59 %'' Debt Service 101 - 555629 Bond -GO 2007 Principal 340000.00 - - - 340,000.00 - 101- 555629.1 Bond -GO 2007 Interest 85267.00 - 85,267.00 101- 555635 Bond -GO 2012 - Principal 375,000.00 - 375,000.00 101- 555635.1 Bond -GO 2012 - Interest 128,677.00 - 128,677.00 101- 555638 Bond -GO 2014 Refund - Principal 750,000.00 - 750,000.00 101- 555638.1 Bond -GO 2014 Refund - Interest 268,025.00 - 268,025.00 101- 555640.1 Bond -GO Ref 2015 - Interest 37,050.00 - 37,050.00 101- 555641 Tax Note - SR2015A- Principal 155,000.00 - 155,000.00 101- 555641.1 Tax Note - SR2015A - Interest 2,387.00 - 2,387.00 101- 555642 Bond -GO SR2016- Principal 245,000.00 - 245,000.00 101- 555642.1 Bond -GO SR2016- Interest 131,607.00 - 131,607.00 101- 555643 Bond- TaxableB CO SR2016- Princi 60,000.00 - 60,000.00 101- 555643.1 Bond - Taxable CO SR2016- Interes 40,263.00 - 40,263.00 101- 555644 Bond- NonTaxA CO SR2016- Princip 195,000.00 - 195,000.00 101- 555644.1 Bond- NonTax CO SR2016- Interest 40,469.00 - 40,469.00 101- 555645 Bond -CO SR2017- Principal 420,000.00 - 420,000.00 101- 555645.1 Bond -CO SR2017 - Interest 114,425.00 - 114,425.00 101- 555646 Bond -GO SR2017 - Principal 165,000.00 - 165,000.00 101- 555646.1 Bond -GO SR2017 - Interest 100,050.00 - 100,050.00 101- 555647 Bond -GO 2018 Refund- Principal 585,000.00 - 585,000.00 101- 555647.1 Bond -GO 2018 Refund - Interest 86,125.00 - - 86,125.00 - 101- 555648 Bond -CO SR2018 - Principal 245,000.00 - 245,000.00 - 100.00 101 - 555648.1 Bond -CO 2018 - Interest 163,888.00 - 85,006.25 78,881.75 51.87 101 - 555649 Bond -GO 2018 Ref - Principal 185,000.00 - 185,000.00 - 100.00 101 - 555649.1 Bond -GO 2018 Ref - Interest 181,819.00 - 93,221.88 88,597.12 51.27 101 - 555650 Bond -CO 2019 - Principal 265,000.00 - 265,000.00 - 100.00 101 - 555650.1 Bond -CO 2019 - Interest 114,900.00 - 59,437.50 55,462.50 51.73 101 - 555651.1 Bond -GO 2020 - Interest 211963.00 - 115,331.25 96,631.75 54.41 TOTAL Debt Service 6,626,915.00 - - - 1,982,996.88 4,643`,918.12 29.92% Other Financing Sources TOTAL EXPENDITURES 6,676,91;5.00 45,293.39 174,999.52 45,293.39 1,982,996.88 4,648,624.73 30.38% TAX 1 &S CASH IN BANK AND INVESTMENTS AS OF: December 31 , 2021 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,215,873.62 MBIA Investment- Tax I &S 3,693,770.71 Total Cash in Bank & Investments $ 4,909,644.33 620 -SED CORPORATION FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2021 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D ACTUAL Y -T -D BUDGET QUARTER ENCUMBRANCE 5,408,000.00 1,240,000.00 141,000.00 1,435,398.73 5,273.47 1,299,586.77 13, 587.60 1,435, 398.73 5,273.47 BUDGET % OF BALANCE BUDGET 3,972,601.27 26.54 1,240,000.00 - 135,726.53 3.74 EXPENDITURE SUMMARY NONDEPARTMENTAL City Assistance 3,139,038.00 - 200,000.00 - - 3,139,038.00 - Fund Charges /Transfers 1,240,000.00 - - - - 1,240,000.00 - TOTAL NONDEPARTMENTAL 4,379,038.00 - ` 200,000.00 - - 4,379,03800 0.00 %I MISC & PROJECTS PROJECTS ECONOMIC DEVELOPMENT Supplies 1,000.00 512.61 96.91 512.61 67.96 419.43 58.06 City Support Services 19,200.00 1,460.68 1,810.07 1,460.68 - 17,739.32 7.61 Utility Services 2,975.00 127.17 159.58 127.17 - 2,847.83 4.27 Operations Support 343,110.00 31,178.91 7,280.43 31,178.91 18,660.91 293,270.18 14.53 Staff Support 20,100.00 (264.40) 895.20 (264.40) 2,211.91 18,152.49 9.69 City Assistance 202,500.00 - - - - 202,500.00 - Professional Services 61,300.00 1,872.00 5,623.50 1,872.00 - 59,428.00 3.05 Fund Charges /Transfers 506,984.00 253,492.00 252,334.50 253,492.00 - 253,492.00 50.00 Operating Equipment 4,500.00 2,179.94 - 2,179.94 1,500.88 819.18 81.80 TOTAL ECONO DEVELOPMENT 1,161,669.00 290,558.91 268,200.1`9 290,558.91 22,441.66 848,668.43 26.94 %` SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: December 31, 2021 Cash in Bank Claim on Operating Cash Pool- Checking $ 296,647.26 Cash in Investments Texas Class Investment - Economic Development Corp 19,426,448.67 Schertz Bank & Trust - Certificate of Deposit 1,080,548.16 Schertz Bank & Trust - Certificate of Deposit 1,128,140.79 Total Cash in Bank & Investments $ 21,931,784.88