Loading...
Ordinance 2022-56 ORDINANCE NO. 2022-56 AN ORDINANCE OF THE CITY OF WYLIE, TEXAS, ADOPTING A BUDGET AND APPROPRIATING RESOURCES FOR FISCAL YEAR 2022-2023, BEGINNING OCTOBER 1, 2022, AND ENDING SEPTEMBER 30, 2023; REPEALING ALL CONFLICTING ORDINANCES; CONTAINING A SEVERABILITY CLAUSE; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS,the City Manager and staff have prepared and filed with the City Secretary a proposed budget for operation of the City during Fiscal Year 2022-2023; and WHEREAS,the proposed budget appears to be in form and substance which fully complies with all applicable provisions of the City Charter and State law; and WHEREAS,the proposed budget has been available for public inspection and review;and WHEREAS,the City Council on August 23,2022,conducted a public hearing to receive input from the citizens of the City concerning the content of the budget; and WHEREAS, the Council having considered the proposed budget at length, and having provided input into its preparation, has determined that the proposed budget and the revenues and expenditures contained therein is in the best interest of the City and therefore desires to adopt the same by formal action; NOW THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF WYLIE,TEXAS: Section 1. That the proposed budget of the revenues of the City and the expenses of conducting the affairs thereof, as summarized in the attached Exhibit A and fully incorporated herein by reference, be,and the same hereby is,completely adopted and approved as the Budget for the City for Fiscal Year 2022-2023. Section 2. That the sum of one hundred forty-eight million, twenty-five thousand, three hundred ninety dollars, $148,025,390 is hereby appropriated for the City's FY 2022-2023 Budget. These funds are payment of operating, capital, and debt service expenses associated with the operation and administration of the City according to the various purposes and intents described in the FY 2022-2023 budget document. Section 3. The specific authority is hereby given to the City Manager to transfer appropriations budgeted from an account classification or activity to another within any individual department or activity; and to transfer appropriations from designated appropriations to any individual department or activity as provided in the City Charter. Section 4. Should any paragraph, sentence, sub-division, clause,phrase or section of this ordinance be adjudged or held to be unconstitutional, illegal, or invalid,the same shall not affect the validity of this ordinance as a whole or any part or provision thereof, other than the part or parts as declared to be invalid, illegal,or unconstitutional. Section 5. This ordinance shall be in full force and effect from and after its adoption by the City Council pursuant to the law and the City Charter. Section 6. That all other ordinances and code provisions in conflict herewith are hereby repealed to the extent of any such conflict or inconsistency. Ordinance No.2022-56 Approval of FY 2022-2023 Budget Page I of 2 DULY PASSED AND APPROVED by the City Council of the City of Wylie, Texas, on this the 23`d day of August, 2022. e � b tthew Porter, Mayor 1 k4, ATTEST: r g„ GULF COS s AG 4� /// 4r Step anie Storm, Cit Secretary Ordinance No.2022-56 Approval of FY 2022-2023 Budget Page 2 of 2 FY2023 PROPOSED BUDGET NOTICE FOR THE CITY OF WYLIE This budget will raise more total property taxes than last year's budget by $890,943 or 2.62%, and of that amount, $962,429 is tax revenue to be raised from new property added to the tax roll this year. NOTICE OF PUBLIC HEARING AND BUDGET SUMMARY FOR FY2022 CITY OF WYLIE NOTICE IS HEREBY GIVEN,pursuant to Article VII Section 3 of the City of Wylie City Charter,that the Wylie City Council will conduct a public hearing on the proposed City Budget for Fiscal Year 2023 on the 23rd day of August 2022,at 6:00 p.m. in the Council Chambers of the Wylie Municipal Complex,300 Country Club Rd,Wylie,TX.Copies of the proposed budget are available for inspection by the public at the Rita and Truett Smith Public Library,the City Secretary's Office and the City Manager's Office during regular business hours,and can be viewed online at www.wylietexas. gov/departments/finance/budget.php. The following is a General Summary of the budget which has been proposed. SUMMARY OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE ALL OPERATING .AND CAPITAL FUNDS FISCAL YF AR 2022-2023 BUDGET llI?B'1'tiliRV'U:F.I UNllS I)R0I'RIFT,\RYF(1N, 1ll SPECIAL CAPITAL GENERAL REVENUE G O DEBT 4B DEBT PROJECTS TOTAL ALL FUND FUNDS SERVICE SERVICE FUNDS UTILITY FUND FUNDS ESTIMATED BEGINNING BALANCES S 24,560,256 S 18,309,360 S 826,398 S 186,132 S 29,616,871 S 25,182,535 98,681,552 REVENUES: _Ad V'alorcm Taxes 28,956,551 - 9,057,658 - 38,014,209 Non-Propem Taxes 8,278,293 8,476,387 - - 16,754,680 Franchise Dees 2,802,41H1 - - - - 2,802,41)0 Licenses&Permits 1,442,750 28,428 - - - 1,471,178 Intergovernmental 2429011 7,221,251) - 9,650,261 Service Fees 4,338,970 1,613,888 - - 1,460,001) 20,345,619 33,819,477 Court Fees 339,0011 20,0(x) - - - 359,000 Interest&Misc.Income 275,417 4,138,465 2,400 99,000 4,515,282 OTAL REVENUES 48,862,392 14,337,168 9,060,058 8,681,250 26,444,619 107,385,487 Transfers from Other Funds 2,563,305 34,200 - 388,050 - - 2,985,555 Issuance of I ong term Debt - l U 0110 11011 - 10,000,000 TOTAL AVAILABLE RESOURCES 75,985,953 32,68o,728 9,986,456 574,182 48,298,121 51,627,154 219,052,594 EXPENDITURES: General Government 13,ol l,742 12,250 - - - 13,023,992 Public Safety 29,417,532 146,784 29,564,316 Devclopmcnt Seri-ices 1,257,378 - 1,257,378 Streets 5,259,846 - - - - - 5,259,846 Communitv Seri ices 5,121,432 4,963,683 10,085,115 Utilities - - - 24,459,542 24,459,542 Debt Scrviec 9,429,005 388,051) - 1,438,292 11,255,347 Capital Proiccts - 33,990,613 - 33,990,613 Fconomic Development - 16,143,686 - - - 16,143,686 TOTAL EXPENDITURES 54,067,930 21,266,446 9,429,005 388,050 33,990,613 25,897,834 145,039,835 Transfers to Other Funds - 422,250 - - - 2,563,305 2,985,555 ENDING FUND BALANCE S 21,918,023 S 10 992,075 S 457,451 S 186,132 S 14,307,508 S 23,166,015 S 71,027,204 TOT, 1,111;VI{NUBS S 12o,371,042 NFT DIiCRI;.ASF(INCRI?_ASF)IN FUND B.A].-ANCF 27,654,348 TO"C\I..APPROPR1.AB1T FUNDS S 148,025,390 City of Wylie Fiscal Year 2022-2023 Budget Cover Page This budget will raise more revenue from property taxes than last year's budget by an amount of $890,943, which is a 2.62 percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is $962,429. CITY OF WYLIE, TEXAS PROPOSED BUDGET Fiscal Year 2022-2023 �„zk3'�L,,irk k' �;kk:ku ikk;ic ar k§ lk, YY� � t OUR MISSION Honoring our past; Embracing our present; Planning our future OUR VISION Past: Building on our heritage Present: Celebrating our home town character Future: Creating opportunities for our growth OUR VALUES Integrity: Ethical, honest, and responsible Stewardship: Fiscally accountable Respect: Value diversity Our Community Deserves Nothing Less TABLE OF CONTENTS MANAGER'S MESSAGE Letter to Mayor and City Council FUND SUMMARIES Property Tax Distribution Colco1udous---------------------------------- l Summary of Revenues, Expenditures 8c Changes in Fund Balance....................................................... 2 Departmental Staffing Summary.................................................................................................................. 4 GENERALFUND FundNozzxdvc------------------------------------------------ 5 Fund 6 GeneralFund Revenues................................................................................................................................ 8 5111 - City Council........................................................................................................................................1O 5112 - 12 5113 - City Secretary.-------------------------------------------- 15 5114- City -------------------------------------------- 18 5131 - Finance............................................................................................................................................... 30 5132 - Facilities.............................................................................................................................................. 24 5152 - 26 5153 ' Human Resources............................................................................................................................. 29 5154-Purchasing --------------------------------------------- 3l 5155 Information -------------------------------------.. 33 5211 -Police................................................................................................................................................... 36 5231 Fire.--------------------------------------------------4l 5241 - 5251 -/loimul CootroL-------------------------------------------.49 5311 - 52 5312 - 55 5313 - Code -----------------------------------------58 5411 - Stzoet -------------------------------------------------6l 5511 Parks.....................................................................................................................................................65 5551 Library..................................................................................................................................................68 5181 General Fund Combined Services.................................................................................................. 7l ENTERPRISE FUNDS Utility Fund Fund Narrative -----------------------------------------------.73 Fund 74 Summary of Utility Fund Revenues 8c Expenditures...............................................................................75 UtilityFund Revenues...................................................................................................................................76 5711 - Utility Administration........................................................................................................................77 5712 - TJd|hico—Wutcr------------------------------------------' 79 5713 - 84 5714- lJti|hico—Wuutcwutcr---------------------------------------'O8 5715 - Utility Billing ---------------------------------------I3 Sewer Repair and Replacement Fund Fund Narrative ----------------------------------97 Fund -----------------------------------------------.98 Sewer Repair and Replacement Revenues and Expenditures---------------------..99 SPECIAL REVENUE/OTHER FUNDS Wylie Economic Development Cofl2oration FundNarrative............................................................................................................................................. 1OO Fund ----------------------------------------------..1O1 Wylie Economic Development Corporation Revenues ---------------------. lO2 561l - Economic Development C -----------------------------. lO4 413 Sales Tax Revenue Fund FundNarrative.............................................................................................................................................l05 Fund -------------------------------------.1O6 Summary of 4B Sales Tax Fund l<cvcuuca & Expenditures.................................................................1O7 48 Sales Tax Fund Revenues.....................................................................................................................1O8 5612 - 48 Brown House............................................................................................................................. 1O9 5613 - 48 Senior Activities.........................................................................................................................1D 5614- 48 Parks............................................................................................................................................ D4 5625 - 48 Recreation Center......................................................................................................................D7 5627 - 48Stouchmvon House.....................................................................................................................l2U 500O ' 4D Sales Tax Combined Services.................................................................................................. l22 Park Acquisition and Improvement Fund Fund &urrudvc.............................................................................................................................................. 124 Fund 125 Puck Acquisition and Improvement Fund Revenues.............................................................................126 5621 -West Zone.........................................................................................................................................127 5622 - Central Zone.....................................................................................................................................128 5623 - East Zone..........................................................................................................................................l29 Fire Training Center Fund FundNarrative.............................................................................................................................................l]O Fund ----------------------------------------------..l]l Fire Training Center Fund Revenues and -----------------------.l]2 Fire Development Fund FundNarrative............................................................................................................................................. 133 Fund ---------------------------------------------134 Fine Development Fund Revenues and ------------------------'135 Municipal Court Technology Fund FundNarzudvc..............................................................................................................................................l]6 Fund ----------------------------------------------..l]7 Municipal Court Building Security Fund FundNarrative.............................................................................................................................................139 FundSummary.............................................................................................................................................140 Municipal Court Building Security Fund Revenues and Expenditures...............................................141 Municipal Court Judicial Efficiency Fund FundNarrative............................................................................................................................................. 142 FundSummary.............................................................................................................................................143 Municipal Court Judicial Efficiency Fund Revenues and Expenditures.............................................144 Municipal Court Truancy Court Fund FundNarrative.............................................................................................................................................145 FundSummary............................................................................................................................................. 146 Municipal Court Judicial Efficiency Fund Revenues and Expenditures.............................................147 Municipal Jury Fund FundNarrative............................................................................................................................................. 148 FundSummary.............................................................................................................................................149 Municipal Court Jury Fund Revenues and Expenditures......................................................................150 Hotel Occupancy Tax Fund FundNarrative.............................................................................................................................................151 FundSummary.............................................................................................................................................152 Hotel Occupancy Tax Fund Revenues and Expenditures.................................................................... 153 Public Arts Fund FundNarrative............................................................................................................................................. 154 FundSummary.............................................................................................................................................155 Public Arts Fund Revenues and Expenditures........................................................................................156 DEBT SERVICE FUNDS General Obligation Debt Service Fund Summary..................................................................................157 General Obligation Debt Service Fund Revenues and Expenditures.................................................158 413 Debt Service Funds Summary............................................................................................................. 159 413 Debt Service Fund 2013 Revenues and Expenditures.....................................................................160 City of Wylie Debt Service Schedules For Fiscal Year 2022-2023...............................................161-167 CAPITATa IMPROVEMENT PROGRAM Capital Program Five Year Schedule for Fiscal Years 2023-2027........................................................168 1AICITY OF Our fission... ..to be responsible stewards of the public trust to strive for excellence in public service WYLIE and to enhance the quality of life for all. August 5, 2022 To the Honorable Mayor and City Council, On behalf of the City of Wylie staff, and in accordance with the City of ylie's Charter,Article VII, Section 2, I am pleased to submit the Fiscal Year 2022-23 Budget. The proposed tax rate for the FY 22-23 budget is $0.562333, which is a reduction of$0.08 from the current tax rate. Council and staff began developing the FY 22-23 budget in April. Budget worksessions with Council were held in June and July to discuss the proposed budget and the needs of the departments to maintain a high level of service to the citizens. The following pages provide an overview of the factors affecting the budget and summaries of the major individual funds, including their purpose, revenue sources and proposed expenditures. This document would not be possible without the hard work of City Council, city staff, and more specifically the work by Finance Director Melissa Beard,Assistant Finance Director Ron Arp, and Budget Manager Debbie Przyby. Respectfully Submitted, � - &-:,-� /-C— Brent Parker City Manager CityManager's Office - 300 Country Club Road - Wylie,Texas 7 - 972.516.6000 - WylieTexas.gov ........................................................................................................................................................................................................................................................................ EACTORS,AFFECTING THE BUDGET —------------- ................. ................ Expanded Levels of Service Each year, department directors submit a proposed budget that consists of an updated base budget which is intended to provide for the status quo of service delivery and staffing and identify cost increases to maintain the current level of service. In addition, requests for new personnel, new equipment, vehicle replacements and new software are submitted individually. The requests that are recommended for inclusion in the Fiscal Year(FY) 22-23 Budget are listed within each fund category. Any listed personnel request assumes that the total cost of salary, benefits and all other associated costs which may include uniforms, vehicles and equipment are recommended for funding. Strategic Goals The City's Mission, Vision and Values Statements and eight Strategic Goals continue to provide the direction for our operations, service delivery and long term planning. Each Department's FY22-23 Objectives are geared toward these identified strategies and our success will be measured in our effectiveness in carrying out these goals. Compensation Included in the FY 22-23 budget is a cost of living adjustment for all general pay plan employees effective October 2022. This adjustment averages 3% with some entry level positions receiving higher increases to become more competitive with the market. A 2% average merit increase is included and will be effective January 2023. A 2.5% step increase for public safety employees is also part of the FY 22-23 budget. The public safety pay plan will be reviewed fully next fiscal year. As with the FY 22-23 budget, future budget years will alternate between general employee and public safety pay plan adjustments to limit budget impact. Insurance The projection is for a 7.25 percent increase in healthcare costs. GENERAL FUND ............... The General Fund is the largest of the operating funds within the City of Wylie's budget. The primary source of revenue for the General Fund is from property taxes, followed by sales tax and various fees and permits. Because of this, considerable thought is given each year in developing annual projections for these revenue sources that are informed, logical and conservative. The General Fund accounts for resources traditionally associated with government functions that are not required to be accounted for in a separate enterprise or special revenue fund. Operations funded within the General Fund include basic services such as public safety, parks, development services, streets and administration. General Fund revenues and expenditures were presented to Council on the June 28th work session with estimated GF revenue to be $51,425,695 and the proposed base budget expenditures to be $49,070,732. The assumptions affecting the budget included additional ad valorem revenue based on a new construction value of $172.5 million and a 8.8% increase in sales tax revenue based on projections for FY 21-22 which was 1.00% of budgeted amount. The General Fund expenditure assumptions included funding of the step plan for salary increases for public safety, a 2% merit increase for non-public safety employees and a cost of living adjustment to the general pay plan and a healthcare increase of 5%. $2,004,963 of department requests were recommended at that time. The budget was balanced with revenues equaling expenses. The use of the fund balance in the amount of$350,000 was included for construction of a traffic signal. The 4B Sales Tax Fund and Utility Fund were also reviewed. The proposed revenues and recommended department requests were reviewed again at the July 12 work session for General Fund, 4B Fund and Utility Fund. The no new revenue and sales tax projections did not change. The 4B Sales Tax Fund revenues were increased$150,000 based on a new rate structure that was presented. On July 26, a final work session was held to present any changes as well as recapping the revenues and expenditures for the General Fund, 4B Sales Tax Fund and Utility Fund. During that meeting, the water and sewer rates were discussed and a decision was made to keep the recommended 7% increase in water rates and 2.75% increase in sewer rates for FY 22-23 and revisit the sewer rate methodology in a future rate study. Council was presented with the healthcare change of 7.25% increase. At the July 26th meeting, the City Council gave direction to propose a budget with a no new revenue tax rate. The final certified totals were received from Collin, Rockwall and Dallas counties indicating a taxable value of$6.2 billion which is a 17.38% increase from the FY 21-22 taxable value. The new construction was valued at $171 million. On July 30th, the Collin County Tax Assessors Office provided the no new revenue rate and voter approval tax rate calculations at $0.562333 and $0.580038 respectively. This budget is based on the no new revenue tax rate. The recommended General Fund personnel and non personnel requests total $2,456,363 as shown below: Recommended General Fund Personnel Requests Department Description $Amount Police Two Sworn Officers (2) 232,874 Police Crossing Guard Supervisor 19,294 Police Two Crossing Guards (2) 20,958 Police Mental Health Coordinator- Upgrade to Full Time 51,046 Police Upgrade Officer to Sergeant 25,286 Fire Six Firefighters for Fire Station 4 (6) 656,233 Fire Upgrade Fire Prevention Clerk to Fire Records Analyst 4,979 Total I $ 1,010,670 Recommended Non Personnel and Vehicle Replacement Requests Department Description $Amount City Secretary Zoning Ordinance Hosting 10,000 Finance Budget and Transparency Software 81,000 Facilities Scissor Lift 25,000 IT Security Camera System Replacement 60,000 IT Trane Building Management Software Upgrade 7,500 IT MYGOV Code Enforcement Software 8,293 Police Patrol Tahoe for New Officers 81,400 Police Two CID Vehicles (2) 92,800 Fire 3rd Full Time Ambulance %year 315,000 Animal Services Key Card Access Control 58,000 Streets Vehicle for Traffic Signal Technician Crew Leader 51,000 Streets Sand/Salt Spreader for Dump Truck 43,000 Streets Replacement Paint Striper 28,000 Streets Mini Track Loader 25,500 Streets Angle Broom 84 inch 9,200 Total Non Personnel $ 895,693 Police FY 2024 Replacement Vehicles 149,000 Streets Replacement of Unit#324 51,000 Total Vehicle Replacements $200,000 Total Non Personnel and Vehicle Replacements $1,095,693 Streets Woodbridge Pkwy/Hensley Signal Construction 350,000 Use of Fund Balance 350,000 Total Requests 2,456,363 Every budget year, there are certain projects or purchases that are not able to be completed prior to the end of the budget year. Staff is asked to identify those items that need to be carried forward to the new budget year. This year the General Fund carry forward amount is $2,292,233. The amount is greater than previous years due to supply constraints causing longer wait times to receive items. See below for a list of the items over $50,000. Recommended Carry Forward Requests Department Description $Amount IT Council Technology Upgrades 1.50,000 IT Upgrade Council Streaming Equipment 75,000 IT Department Software Solutions 1.50,000 Police FY 2023 Vehicles Advance Order 217,500 Fire Horton Model 623 Ambulance 338,840 Fire 6 Lifepak 15 Monitors 243,125 Streets County Rehab of Stone Road 389,997 Streets RR Median at Brown 81,899 Streets FY 2023 Vehicles Advance Order 91,530 Streets McCreary/Hensley Signal Design 60,000 Comb Svcs Downtown Traffic Impact Analysis 52,380 Library Book Sorter 1.20,000 Various Items under $50,000 321,962 TOTAL GENERAL FUND 2,292,233 General Fund Summary Beginning Fund Balance 10/1/22 24,560,256 a) Proposed Revenues FY 22-23 51,425,697 Proposed Expenditures FY 22-23 (51,425,697) Use of Fund Balance (350,000) Carry-Forward of Funds ( 2,292.233) Estimated Ending Fund Balance 9/30/23 21,918,023b) a) Funds from the American Rescue Plan Act are unearned revenue and not included as part of the unassigned fund balance: $6,099,650. b) Policy requirement is 25%of budgeted expenditures. This Ending Fund Balance is 42% which is well above the 30% recommended by the City' Financial Advisors. UTILITY FUND The City's water and wastewater utilities are financed and operated in a manner similar to private business enterprises, where costs of providing services to the public are financed primarily through user charges. Departments in this fund include Utility Administration, Water, Wastewater, Engineering and Utility Billing. A water and wastewater rate study update was conducted which evaluated wholesale cost increases from the North Texas Municipal Water District, operating costs for the City and future capital projects. The rate increases that were recommended as a part of the adopted rate structure are 7.0% increase for water and 2.75% increase for sewer and are factored into the revenue estimates for FY 22-23. An expense was included to update the water and wastewater rate study each year. There were no requests for new personnel in the FY 22-23 budget. Recommended Utility Fund Equipment Department Description $Amount Water Lead and Copper Rule Revision 190,000 Water Cold Climate Automatic Flushers/De-Chlorinators 136,000 Water Backhoe Unit M-906 Replacement with Midsize Excavator 133,000 Water SCADA Pack PLC and Radio Replacement 72,000 Water Sample Stations Replacement 9,200 Water Hydraulic Chainsaw 8,000 Water Portable Parallel Analyzer 5,400 Water Utility Line Locator 4,000 Engineering Dogwood Drive Waterline Replacement Design 100,000 Wastewater Wastewater Pump Replacement 30,000 Total Equipment $ 687,600 As with the General Fund, every budget year there are certain projects or purchases that are not able to be completed prior to the end of the budget year. Staff is asked to identify those items that need to be carried forward to the new budget year. The total amount of carry forward items is $2,082,268. See below for the items over $50,000. Recommended Utility Fund Carry Forward Requests Department Description $Amount Utility Admin Department Software Solutions 135,730 Utility Admin Wastewater Treatment Plant Decommissioning Design 65,739 Water Water Pump Station Backup Power Generators 1,278,969 Water Pump Station Backup Power Generators Water (Contingency) 373,411 Water Newport Harbor Tank Repairs 130,000 Various Items under$50,000 98,419 TOTAL UTILITY FUND $2,082,268 [`tility .Fund Suns Liar y ------------------------------------------------------------- ....... —------------------------------------------------------------------ Beginning Fund Balance 10/1/22 22,512,631 Proposed Revenues FY 22-223 26,027,619 Proposed Expenditures FY 22-23 (24,878,871) Carry-Forward of Funds ( 2,082,268) Estimated Ending Fund Balance 9/30/23 21,579,111 a) a) Policy requirement is 90 days of operating expenditures, which is $6,134,516. 4B SA LES TA X RE 1,"E,Nt,,E FUND ------- The Wylie Parks and Recreation Facilities Development Corporation (the 4B Corporation) was established to promote park and recreational development within the City. This special revenue fund accounts for the use of the 4B 1/2 cent sales tax authorized by State Law and by the Wylie voters in 1994. Departments in this fund include the Brown House, Stonchaven House, Wylie Senior Recreation Center, the Recreation Center, and a portion of the Parks function. The 4B Corporation Board meets annually to authorize the expenditure of sales tax funds for projects approved by the City Council. The Board is composed of four Councilmembers and three citizen members, one of which is required to be appointed from the Park Board. Sales tax revenue is projected to increase 8.8% from projected FY 21-22 for the FY 22-23 budget. The total revenue estimate for this fund also includes the projected revenue generated by Recreation Center operations, including membership and activity fees. A very healthy fund balance is projected to be earmarked for future park and recreation projects. Recommended 4B Fund Personnel and Equipment Requests Department Description $Amount 4B Parks Irrigation Technician 65,392 Total Personnel $ 65,392 4B Parks Pour and Play Surfacing for Olde City Park 160,000 4B Parks Replacement of Birmingham Farms Playground 60,000 4B Parks Drainage Flume Areas for Founders Park 55,000 4B Parks Parks Building HVAC Replacement 30,000 4B Parks Holiday Yard Decorations at Olde City Park 24,000 4B Parks New Rear Discharge Zero Turn Mower 15,000 4B Parks Two Sets of Soccer Goals for Dodd Park 8,800 Total Equipment and One Time Uses $352,800 Total Requests $418,192 The total amount of carry forward items is $678,565. See below for the items over$50,000. Recommended 413 Fund Carry Forward Requests Department Description $Amount SRC Senior Center Renovation Design and Engineering 222,065 4B Parks Design for Dog Park and Splash Pads 156,000 4B Parks Replacement of Valentine Park Playground 70,000 Brown House House Painting 50,000 Stonehaven House Stonehaven House Phase I 120,000 Various Items less than $50,000 60,500 TOTAL 413 SALES TAX FUND $678,565 ........................................................................................................................................................................................................................................................................ 4B -Vales 7iix Fund Swnmai-y .......................................................................... ...................................................................................... Beginning Fund Balance 10/1/21 5,697,190 Proposed Revenues FY 21-22 5,091,346 Proposed Expenditures FY 21-22 (4,361,637) Carry-Forward of Funds (678,565) Estimated Ending Fund Balance 9/30/21 5,748,334 a) a) Policy requirement is 25% of the budgeted sales tax revenue ($4,124,146 x 25% — $1,031,037). P.4R,lf,'Y,,�,ICQI,11,�ITfON,4.i'\T].,) IMI-wOrEIIENT FLIA111) ............... The Parks Acquisition and Improvement (A&I) Fund is supported through Parkland Dedication Fees paid during the development process. The City is divided into three geographical zones and the accumulated fees are available for projects within those areas. The projected revenues for the A&I Funds in FY 22-23 are $511,480 The FY 22-23 projects in the budget are concrete additions for the community garden and trail and the backstop replacement at Avalon park. Although policy does not require a fund balance, the FY21-22 ending fund balance is projected to be $790,849. .................................................................. SE WER R EPA IR A ND R EPLA CE 1WE',N 7'FUND ------------------------ ........... ------------------- The Sewer Repair and Replacement Fund is supported by a $2.00 per month charge on utility bills. The purpose of the fund is to allow revenue to accrue in order to pay for large sewer repair and maintenance projects. The beginning fund balance is $2,669,904 with projected revenue for FY 22-23 of $417,000. A four-phase comprehensive sewer system assessment which included inspections, flow monitoring, and smoke testing was completed in FY 19-20. In FY 22-23, $1,500,000 is carried forward for the repairs. The FY 22-23 ending fund balance is projected to be $1,586,904. ..... ......... ......... ......... ......... ......... ff..7 ......... ......... ......... ......... ......... ......... ............. HOTFL 10TEL FUND The Hotel Occupancy Tax is levied on a person who pays for a room or space in a hotel costing $15.00 or more each day. This fund is utilized to support the activities that will draw people to Wylie from other areas and follows the "heads in beds" funding criteria required by State Law. These funds are to be spent on the promotion of the arts, historic preservation, advertising to promote the community, convention and visitor centers, and convention registration. State Law also sets out that a minimum 1/7 of the revenue be utilized for advertising to promote the area, a maximum of 15% for the promotion of the arts, and a maximum of 50% for projects related to historic preservation or restoration. Proposed revenues for the Hotel/Motel Occupancy Tax Fund are $228,660. A transfer of $34,200 to the Public Arts Fund will provide funding for arts projects throughout the city. The Hotel/Motel Fund also includes an allocation of $35,000 for advertising and promotion. The infrastructure for the Arts Festival and Bluegrass on Ballard are funded through this fund. Although policy does not require a fund balance, the remaining fund balance is approximately $730,850. Revenues for the Public Art Fund primarily come from three sources: transfers from the Hotel/Motel Fund; revenues generated from special events such as the Arts Festival and Bluegrass on Ballard; and a 1% allocation for art from certain Capital Improvement Project (CIP) budgets. The revenues are utilized to maintain existing public art and to purchase new art that meets the criteria of the adopted Public Arts Program. The FY 22-23 Budget includes a carry forward of $112,000 for Municipal Complex trail sculptures. The FY 22-23 ending fund balance is projected to be $430,953 although none is required by adopted policy. The Fire Training Center Fund was established in FY00-01. The majority of the revenue is from response fees into the county for emergency services rendered. Expenditures are related to training, as well as upkeep and maintenance of the facilities behind Fire Station #2. Revenue is budgeted to be $28,728 with an ending fund balance of$221,324. -------------------- .............................................-----------........................................... FIRE DEV'ELOVITENT FUND The Fire Development Fund receives revenue from fire development fees established by ordinance in 2007. The fund is to be utilized solely for needs directly associated with new growth and development. The ending fund balance is projected to be $1,131,98 1. Recommended Fire Development Carry-Forward Requests Department Description $Amount Fire Development Station 4 Architectural Services 46,784 Fire Development Emergency Services Consultant 55,000 TOTAL FIRE DEVELOPMENT 1 $ 101,7841 IIL�AICIPAL COURT TLVHN0L0('IV'YFU.1N'D ------------------------ State law requires the assessment and collection of a Municipal Court Technology Fee, and further requires that those fees be kept in a separate fund. Revenues are estimated to be $8,000. The ending fund balance will be $26.440. MIJA1,1(,,'IPAL COtIRTBI.IILD,11\,(;,VL,7(111,,'RITYI,t,,�AID ------------- A building security fee is collected on each Class C misdemeanor violation issued for the purpose of implementing, improving, and enhancing court security. Permitted expenditures include training and equipment purchases related to court security. Revenues are estimated to be $7,000 with an ending fund balance of$23,304. PROPERTY TAX DISTRIBUTION CALCULATIONS CURRENT TAX RATE FY2022-23 FY2021-22 Tax Year 2022 Tax Year 2021 TAX ROLL: Assessed Valuation(100%) $6,199,027,298 $5,289,616,023 Rate per$100 0.562333 0.643751 Tax Levy Freeze Adjusted 34,859,176 34,051,956 Tax Levy -Frozen (Disabled/Over 65)* 2,905,032 2,636,853 Total Tax Levy 37,764,208 36,688,809 Percent of Collection 100% 100% Estimated Current Tax Collections $ 37,764,208 $ 36,688,809 SUMMARY OF TAX COLLECTIONS: Current Tax $ 34,859,176 $ 34,051,956 Revenue From Tax Freeze Property 2,905,032 2,636,853 Delinquent Tax 150,000 150,000 Penalty and Interest TOTAL TAX COLLECTIONS $ 37,91.4,208 $ 36,838,809 FY2022-23 FY2022-23 PERCENT FY2022-23 FY2021-22 TAX RATE OF TOTAL AMOUNT AMOUNT GENERAL FUND: Current Tax $ 0.427919 $ 26,526,816 $ 26,017,717 Revenue From Tax Freeze Property 2,219,735 2,014,819 Delinquent Tax 110,000 110,000 Penalty and Interest Total General Fund $ 0.427919 76.10% $ 28,856,551 $ 28,1.42,536 DEBT SERVICE FUND: Current Tax $ 0.134414 $ 8,332,361 $ 8,034,239 Revenue From Tax Freeze Property 685,297 622,034 Delinquent Tax 40,000 40,000 Penalty and Interest Total Debt Service $ 0.134414 23.90% $ 9,057,658 $ 8,696,273 DISTRIBUTION $ 0.562333 100.00% $ 37,914,208 $ 36,838,809 1 SUMMARY OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE ALL OPERATING AND CAPITAL,FUNDS FISCAL YEAR 2022-2023 BUDGET DEBT SERVICE FUNDS SPECIAL GENERAL REVENUE G O DEBT 4B DEBT FUND FUNDS SERVICE SERVICE ESTIMATED BEGINNING BALANCES $ 24,560,256 $ 18,309,360 $ 826,398 $ 186,132 REVENUES: Ad Valorem Taxes 28,956,551 - 9,057,658 - Non-Property Taxes 8,278,293 8,476,387 - Franchise Fees 2,802,400 - - Licenses&Permits 1,442,750 28,428 - Intergovernmental 2,429,011 - Service Fees 4,338,970 1,673,888 - - Court Fees 339,000 20,000 - - Interest&Misc.Income 275,417 4,138,465 2,400 TOTAL REVENUES 48,862,392 14,337,168 9,060,058 - Transfers from Other Funds 2,563,305 34,200 - 388,050 Issuance of Long Term Debt - - - - TOTAL AVAILABLE RESOURCES 75,985,953 32,680,728 9,886,456 574,182 EXPENDITURES: General Government 13,011,742 12,250 - - Public Safety 29,417,532 146,784 - Development Services 1,257,378 - - Streets 5,259,846 - - Community Services 5,121,432 4,963,683 - Utilities - - - - Debt Service - 9,429,005 388,050 Capital Projects - - - Economic Development - 16,143,686 - - TOTAL EXPENDITURES 54,067,930 21,266,403 9,429,005 388,050 Transfers to Other Funds - 422,250 - - ENDING FUND BALANCE $ 21,918,023 $ 10,992,075 $ 457,451 $ 186,132 2 SUMMARY OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE ALL OPERATING AND CAPITAL,FUNDS FISCAL YEAR 2022-2023 BUDGET PROPRIETARY FUND CAPITAL PROJECTS TOTAL ALL FUNDS UTILITY FUND FUNDS ESTIMATED BEGINNING BALANCES $ 29,616,871 $ 25,182,535 $ 98,681,552 REVENUES: Ad Valorem Taxes - - 38,014,209 Non-Property Taxes - - 16,754,680 Franchise Fees - - 2,802,400 Licenses&Permits - 1,471,178 Intergovernmental 7,221,250 - 9,650,261 Service Fees 1,460,000 26,345,619 33,818,477 Court Fees - - 359,000 Interest&Misc.Income 99,000 4,515,282 TOTAL REVENUES 8,681,250 26,444,619 107,385,487 Transfers from Other Funds - - 2,985,555 Issuance of Long Term Debt 10,000,000 - 10,000,000 TOTAL AVAILABLE RESOURCES 48,298,121 51,627,154 219,052,594 EXPENDITURES: General Government - - 13,023,992 Public Safety 29,564,316 Development Services 1,257,378 Streets 5,259,846 Community Services - 10,085,115 Utilities 24,459,542 24,459,542 Debt Service - 1,438,292 11,255,347 Capital Projects 33,990,613 - 33,990,613 Economic Development - - 16,143,686 TOTAL EXPENDITURES 33,990,613 25,897,834 145,039,835 Transfers to Other Funds - 2,563,305 2,985,555 ENDING FUND BALANCE $ 14,307,508 $ 23,166,015 $ 71,027,204 TOTAL.REVENUES $ 120,371,042 NET DECREASE.(INCREASE)IN FUND BALANCE 27,654,348 TOTAL APPROPRIABLE FUNDS $ 148,025,390 3 FY 2023 DEPARTMENTAL STAFFING SUMMARY (ALL POSITIONS SHOWN AS FULL-TIME EQUIVALENT) BUDGET BUDGET BUDGET BUDGET 2019-2020 2020-2021 2021-2022 2022-2023 General Fund City Manager 7.50 7.50 7.50 7.50 City Secretary 3.00 3.00 3.00 3.00 Finance 9.00 9.00 8.00 8.00 Facilities 3.00 3.00 4.00 4.00 Municipal Court 5.00 5.00 5.00 5.00 Human Resources 5.00 5.00 6.00 6.00 Purchasing 2.00 2.00 3.00 3.00 Information Technology 6.00 6.00 6.00 6.00 Police 80.50 86.50 91.00 94.50 Fire 60.50 65.50 71.50 77.50 Emergency Communications 14.00 15.00 16.00 16.00 Animal Control 7.50 7.50 7.50 7.50 Planning 3.00 3.00 3.00 3.00 Building Inspections 6.00 6.00 6.00 6.00 Code Enforcement 3.00 3.00 3.00 3.00 Streets 19.00 20.00 21.00 21.00 Parks 17.75 17.75 17.75 17.75 Library 27.00 27.00 27.00 26.50 Total General Fund 278.75 291.75 306.25 315.25 Utility Fund Utilities Administration 6.00 6.00 2.00 2.00 Utilities -Water 16.00 16.00 16.00 16.00 Utilities - Engineering - - 6.00 6.00 Utilities -Wastewater 11.00 12.00 12.00 12.00 Utility Billing 8.00 9.00 9.00 9.00 Total Utility Fund 41.00 43.00 45.00 45.00 Wylie Economic Development 3.00 3.00 4.00 4.00 Total WEDC 3.00 3.00 4.00 4.00 4B Sales Tax Fund Brown House 2.00 2.00 6.50 6.50 Senior Activities 8.00 8.00 8.00 8.00 Parks 5.00 5.00 5.00 6.00 Recreation Center 24.50 24.50 25.00 25.00 Total 4B Sales Tax Fund 39.50 39.50 44.50 45.50 TOTAL ALL FUNDS 362.25 377.25 399.75 409.75 4 CITY OF WYLIE GENERAL FUND FUND DESCRIPTION The General Fund accounts for resources traditionally associated with governments that are not required to be accounted for in another fund. During the budget process,the General Fund receives extensive scrutiny from City staff,City Council and the Public.The attention is deserved because this fund has many critical issues affecting the community. The issues vary from establishing a tax rate to determining employee staffing and benefits.The following narrative reports the major aspects of the General Fund budget for the concluding and new fiscal year.Operational accomplishments and goals are reported in the departmental narratives. 5 City Of Wylie Fund Summary General Fund Audited General Fund Unassigned Ending Balance 09/30/21 $ 30,403,003 (a) Projected '22 Revenues $ 49,026,908 Available Funds 79,429,911 Projected '22 Expenditures (54,869,655) (b) Estimated Ending Fund Balance 09/30/22 $ 24,560,256 Estimated Beginning Fund Balance- 10/01/22 $ 24,560,256 Proposed Revenues '23 51,425,697 Proposed Expenditures '23 (51,425,697) Use of Fund Balance -Woodbridge/Hensley Signal Light (350,000) Carryforward Expenditures (2,292,233) Estimated Ending Unassigned Fund Balance 09/30/23 $ 21,918,023 (c) a) Funds from the American Rescue Plan Act are unearned revenue and not included as part of the unassigned fund balance or proposed revenues: $6,099,650. b) Carry forward items are taken out of projected 2022 expense and included in 2023 expense. See manager's letter for detailed list totaling $2,292,233. c) Policy requirement is 25% of budgeted expenditures. This Ending Fund Balance is 42%. 6 GENERAL FUND SUMMARY OF REVENUES AND EXPENDITURES 2020-2021 2021-2022 2021-2022 2022-2023 ACTUAL BUDGET PROJECTED PROPOSED REVENUES: Ad Valorem Taxes 27,155,766 28,142,536 28,239,536 28,956,551 Sales Taxes 7,785,625 7,609,932 7,609,932 8,278,293 Franchise Fees 2,696,702 2,896,800 2,674,400 2,802,400 Licenses&Permits 1,278,509 1,079,430 1,442,750 1,442,750 Intergovernmental Revenue 4,971,523 2,134,902 2,059,382 2,429,011 Service Fees 4,224,911 4,008,588 3,983,588 4,338,970 Court Fees 290,479 248,950 296,445 339,000 Interest&Misc.Income 253,928 215,230 232,230 275,417 Other Financing Sources 2,524,891 2,488,645 2,488,645 2,563,305 TOTAL REVENUES $ 51,182,334 $ 48,825,013 $ 49,026,908 $ 51,425,697 EXPENDITURES: General Government City Council 56,342 97,263 96,057 95,165 City Manager 1,132,831 1,329,836 1,325,496 1,281,121 City Secretary 415,176 388,450 383,648 391,327 City Attorney 103,254 170,000 170,000 170,000 Finance 1,218,974 1,221,631 1,221,631 1,343,989 Facilities 792,998 978,273 978,273 1,045,597 Municipal Court 412,569 530,514 530,514 576,256 Human Resources 660,149 743,111 743,111 809,979 Purchasing 195,402 284,296 284,296 326,557 Information Technology 1,749,473 2,127,721 1,752,670 2,358,252 Combined Services 4,405,712 4,228,057 4,175,677 4,640,792 Public Safety Police 10,824,313 12,340,753 12,115,542 13,131,224 Fire 9,580,702 11,675,327 10,947,523 13,157,375 Emergency Communications 1,737,111 2,251,800 2,250,775 2,396,484 Animal Control 435,784 559,267 559,267 723,449 Development Services Planning 295,316 330,908 330,908 368,297 Building Inspection 570,847 588,629 588,629 593,933 Code Enforcement 219,673 262,419 262,419 276,855 Streets 2,926,280 5,068,738 4,264,811 5,259,846 Community Services Parks 2,617,231 2,823,034 2,823,034 2,777,610 Library 1,946,031 2,178,698 2,058,699 2,343,822 Transfers to Other Funds 272,775 7,006,672 7,006,672 - TOTAL EXPENDITURES $ 42,568,943 $ 57,185,397 $ 54,869,652 $ 54,067,930 7 PROPOSED BUDGET FY 2023 100-GENERAL FUND GENERAL FUND REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 40110 PROPERTY TAXES-CURRENT $26,862,512 $28,032,536 $28,032,536 $28,746,551 40120 PROPERTY TAXES-DELINQUENT $155,510 $110,000 $110,000 $110,000 40190 PENALTY AND INTEREST-TAXES $137,744 $0 $97,000 $100,000 40210 SALES TAX $7,750,942 $7,579,932 $7,579,932 $8,248,293 40220 ALCOHOLIC BEVERAGE TAX $34,683 $30,000 $30,000 $30,000 TOTAL TAXES $34,941,391 $35,752,468 $35,849,468 $37,234,844 41110 FRANCHISE FEE-ELECTRIC $1,783,128 $1,785,000 $1,785,000 $1,900,000 41210 FRANCHISE FEE-GAS $286,632 $265,200 $265,200 $265,200 41310 FRANCHISE FEE-TELEPHONE $7,057 $122,400 $7,200 $7,200 41410 FRANCHISE FEE-CABLE $508,470 $612,000 $500,000 $510,000 41610 FRANCHISE FEE-SANITATION $111,415 $112,200 $117,000 $120,000 TOTAL FRANCHISE FEES $2,696,702 $2,896,800 $2,674,400 $2,802,400 42130 CONTRACTOR REGISTRATION FEES $72,382 $100,680 $75,000 $75,000 42540 GARAGE SALE PERMITS $830 $0 $0 $0 42570 PLUMBING PERMITS $141,378 $125,000 $125,000 $125,000 42590 FENCE PERMITS $26,120 $25,000 $25,000 $25,000 42640 ELECTRICAL PERMITS $100,629 $95,500 $95,500 $95,500 42650 NEW DWELLING PERMITS $819,890 $600,000 $1,000,000 $1,000,000 42660 MECHANICAL PERMITS $53,871 $61,000 $50,000 $50,000 42670 ADMIN FEE/INSPECTION $31,244 $40,000 $40,000 $40,000 42910 OTHER PERMITS/FEES $32,165 $32,250 $32,250 $32,250 TOTAL LICENSE AND PERMITS $1,278,509 $1,079,430 $1,442,750 $1,442,750 43110 FEDERAL GOVT LAKE PATROL $36,470 $45,665 $52,230 $57,500 43420 LONE STAR AND LIBRARY GRANTS $25,798 $0 $0 $0 43450 COUNTY PROCEEDS $2,914,423 $0 $0 $0 43500 COLLIN COUNTY-CHILD SAFETY $45,465 $49,755 $49,755 $49,755 43510 COUNTY LIBRARY GRANTS $6,868 $6,868 $6,868 $0 43512 FIRE GRANTS $13,840 $0 $0 $0 43513 POLICE GRANTS $48,401 $23,908 $23,908 $23,934 43520 WISD CROSSING GUARD REIMB. $127,561 $87,125 $120,000 $143,000 43525 WISD SRO REIMBURSEMENT $498,678 $600,000 $450,000 $537,000 43527 WISD ATHLETIC EVENT REIMB. $131,725 $120,000 $150,000 $165,000 43530 FIRE SERVICES $862,084 $937,914 $937,914 $1,157,914 43532 FIRE DISPATCHER SERVICES $222,958 $253,987 $255,277 $273,000 43535 FIRE SERVICE/BLDG INSPECTIONS $3,675 $4,250 $8,000 $13,600 43537 FIRE SERVICE/PLAN REVIEW FEES $4,393 $5,430 $5,430 $8,308 43560 JAIL SERVICES $9,375 $0 $0 $0 43570 POLICE SEIZED FUNDS $19,810 $0 $0 $0 TOTAL INTERGOVERNMENTAL REVENUE $4,971,523 $2,134,902 $2,059,382 $2,429,011 44121 911 FEES $452,858 $360,000 $360,000 $433,745 44122 ALARM PERMITS $289,192 $270,000 $270,000 $292,838 44123 ANIMAL CONTROL FEES/FINES $27,114 $35,000 $35,000 $35,000 44126 ETMC TRANSPORT/MEDICAL FEES $28,400 $9,000 $9,000 $3,763 44132 DEVELOPMENT FEES $456,417 $325,000 $325,000 $325,000 44141 TRASH $2,848,091 $2,874,588 $2,874,588 $3,138,624 44151 CONCESSION FEES/VENDING $100 $0 $0 $0 44153 LIGHTING FEES $40,266 $40,000 $40,000 $40,000 44155 LEAGUE ATHLETIC FEES $28,254 $30,000 $30,000 $30,000 8 PROPOSED BUDGET FY 2023 100-GENERAL FUND GENERAL FUND REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 44170 MOWING (CODE ENFORCEMENT) $20,611 $10,000 $10,000 $10,000 44181 LIBRARY FINES $33,607 $55,000 $30,000 $30,000 TOTAL SERVICE FEES $4,224,911 $4,008,588 $3,983,588 $4,338,970 45110 MUNICIPAL COURT FINES $189,489 $175,000 $213,000 $250,000 45130 COURT ADMIN/WARRANT FEES $36,537 $30,000 $43,000 $45,000 45131 CHILD SAFETY FEES $4,535 $5,000 $2,700 $5,000 45133 JUVENILE CASE MANAGER FEE $7,648 $7,500 $7,500 $8,000 45138 TRUANCY PREVENTION ANDDIVERSION $145 $1,000 $145 $1,000 45139 TEEN COURT PROGRAM $50 $450 $100 $0 45140 CODE FINES $52,075 $30,000 $30,000 $30,000 TOTAL FINES AND FORFEITURES $290,479 $248,950 $296,445 $339,000 46110 ALLOCATED INTEREST EARNINGS $17,978 $25,000 $42,000 $60,000 TOTAL INTEREST INCOME $17,978 $25,000 $42,000 $60,000 48110 RENTAL INCOME $3,000 $3,000 $3,000 $3,000 48125 PARK PAVILION RENTALS $5,277 $4,500 $4,500 $4,500 48410 MISCELLANEOUS INCOME $212,989 $156,951 $156,951 $187,917 48440 CONTRIBUTIONS/DONATIONS $14,684 $25,779 $25,779 $20,000 TOTAL MISCELLANEOUS INCOME $235,950 $190,230 $190,230 $215,417 49151 TRANSFER FROM UTILITY FUND $2,416,161 $2,488,645 $2,488,645 $2,563,305 49210 PROCEEDS FR SALE OF CAP ASSETS $93,287 $0 $0 $0 49600 INSURANCE RECOVERIES $15,443 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $2,524,891 $2,488,645 $2,488,645 $2,563,305 TOTAL GENERAL FUND REVENUES $51,182,333 $48,825,013 $49,026,908 $51,425,697 9 CITY OF WYLIE CITY COUNCIL DEPARTMENT DESCRIPTION The City Council is presented as a non-departmental account. Funds are appropriated for special projects not directly related to City operations. Also included are expenses incurred by the Mayor and six members of the Council in performing their responsibilities as elected officials of the City. CITY COUNCIL: TERM OF OFFICE: Matthew Porter, Mayor Nov 2020 through May 2023 David R. Duke,Councilmember Place 1 May 2022 through May 2025 David Strang,Councilmember Place 2 May 2021 through May 2024 Jeff Forrester, Mayor Pro Tern May 2022 through May 2025 Scott Williams,Councilmember Place 4 May 2021 through May 2024 Dr.Timothy T.Wallis,Councilmember Place 5 Nov 2020 through May 2023 Garrett Mize,Councilmember Place 6 Nov 2020 through May 2023 10 PROPOSED BUDGET FY 2023 100-GENERAL FUND CITY COUNCIL FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51220 PHONE ALLOWANCE $0 $1,200 $0 $1,200 51240 CITY COUNCIL $22,800 $22,800 $22,800 $22,800 51440 FICA $1,414 $1,414 $1,414 $1,414 51450 MEDICARE $331 $331 $331 $331 51470 WORKERS COMP PREMIUM $142 $181 $175 $175 TOTAL PERSONNEL SERVICES $24,686 $25,926 $24,720 $25,920 52010 OFFICE SUPPLIES $656 $650 $650 $650 52040 POSTAGE AND FREIGHT $0 $0 $0 $0 52070 COMPUTER SOFTWARE $0 $0 $600 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $600 $0 $600 52810 FOOD SUPPLIES $1,594 $1,790 $1,790 $2,890 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $2,249 $3,040 $3,040 $4,140 54630 TOOLS AND EQUIPMENT $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 56040 SPECIAL SERVICES $2,550 $7,570 $7,570 $7,570 56050 UNIFORM CONTRACT $0 $0 $0 $0 56080 ADVERTISING $1,668 $2,000 $2,000 $2,000 56110 COMMUNICATIONS $7,512 $8,736 $8,736 $5,544 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $385 $29,191 $29,191 $29,191 56250 DUES AND SUBSCRIPTIONS $16,332 $16,800 $16,800 $16,800 56990 OTHER $959 $4,000 $4,000 $4,000 TOTAL CONTRACTURAL SERVICES $29,407 $68,297 $68,297 $65,105 TOTAL CITY COUNCIL $56,342 $97,263 $96,057 $95,165 11 CITY OF WYLIE CITY MANAGER DEPARTMENT DESCRIPTION The function of the City Manager's Office is to provide leadership and direction in carrying out the policies established by City Council and by overseeing the activities of the operating and administrative departments of the City of Wylie. Principal functions of the City Manager's Office include providing support to Council in their policy making role;ensuring that City ordinances, resolutions and regulations are executed and enforced;submitting annual proposed operating and capital budgets;and responding to concerns and requests from citizens and Council. FISCAL YEAR 2023 GOALS AND OBJECTIVES Represent Wylie's position to local, regional and state entities including the North Texas Municipal Water District,Collin County Commissioners Court,Texas Department of Transportation,and the North Central Texas Council of Governments. Strategic Goals: Planning Management;Community Focused Government; Infrastructure Represent Wylie's interest regarding regional transportation initiatives including Collin County Future Mobility Study,TXDOT and NCTCOG.Will emphasize work within the downtown historic district as well as major intersections. Strategic Goals: Planning Management; Financial Health, Infrastructure; Community Focused Government Continue to review long-term capital needs with regard to long-term financial capabilities. Strategic Goals: Planning Management; Financial Health Review opportunities to establish a new Demand Response Transportation Program to replace the Interloca) Public Transit Service with Dallas Area Rapid Transit Mobility Service, LGC. Strategic Goals: Infrastructure;Community Focused Government Develop a new council member orientation program.This can also serve as an orientation for new boards and commissions members. Strategic Goals: Infrastructure;Community Focused Government Finalize the Cemetery transition from the Wylie Cemetery Association to the city of Wylie. Strategic Goals: Infrastructure;Community Focused Government FISCAL YEAR 2022 ACCOMPLISHMENTS Successfully worked with the Citizens Bond Advisory Committee and City Council to get a$50,100,000 bond package approved by voters to focus on improving infrastructure in neighborhoods,on city streets,and throughout our Historic Downtown District. Strategic Goals: Infrastructure;Community Focused Government Successfully established the Cemetery Advisory Board. Strategic Goals: Community Focused Government Finalized a Transition Plan and ADA Coordinator to conform to the federally mandated requirement by Title II (State and Local Government)of the Americans with Disabilities Act. Strategic Goals: Infrastructure Restructured Public Works, Engineering and Parks and Recreation to better meet the needs of our growing community Strategic Goals: Infrastructure;Community Focused Government 12 CITY MANAGER CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 City Manager 1.0 1.0 1.0 1.0 Deputy City Manager 0.0 0.0 1.0 1.0 Assistant City Manager 2.0 2.0 1.0 1.0 Public Information Officer 1.0 1.0 1.0 1.0 Communications Specialist 1.0 0.0 0.0 0.0 Digital Media Specialist 0.0 1.0 1.0 1.0 Administrative Assistant II 1.0 1.0 1.0 1.0 Administrative Assistant 1 1.0 1.0 1.0 1.0 Public Arts Coordinator 0.5 0.5 0.5 0.5 TOTAL 7.5 7.5 7.5 7.5 13 PROPOSED BUDGET FY 2023 100-GENERAL FUND CITY MANAGER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $795,571 $944,106 $944,106 $864,256 51112 SALARIES-PART TIME $20,058 $20,696 $19,856 $21,731 51130 OVERTIME $1,884 $6,500 $6,500 $6,500 51140 LONGEVITY PAY $3,884 $4,170 $4,170 $3,953 51210 CAR ALLOWANCE $0 $0 $0 $6,600 51310 TMRS $123,567 $147,990 $147,990 $133,142 51350 DEFERRED COMPENSATION $0 $0 $3,000 $6,000 51410 HOSPITAL AND LIFE INSURANCE $83,204 $78,885 $78,885 $104,866 51420 LONG-TERM DISABILITY $3,326 $4,677 $4,677 $3,198 51440 FICA $39,313 $44,822 $44,822 $55,951 51450 MEDICARE $11,500 $14,144 $14,144 $13,085 51470 WORKERS COMP PREMIUM $860 $1,109 $1,109 $1,036 51480 UNEMPLOYMENT COMP(TWC) $2,096 $2,160 $2,160 $2,160 51510 TEMPORARY PERSONNEL $0 $0 $0 $0 TOTAL PERSONNEL SERVICES $1,085,263 $1,269,259 $1,271,419 $1,222,478 52010 OFFICE SUPPLIES $1,895 $4,500 $4,500 $4,500 52040 POSTAGE AND FREIGHT $0 $0 $0 $0 52070 COMPUTER SOFTWARE $16,920 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 52310 FUEL AND LUBRICANTS $0 $0 $0 $0 52810 FOOD SUPPLIES $653 $1,010 $1,010 $1,010 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $19,469 $5,510 $5,510 $5,510 56040 SPECIAL SERVICES $10,197 $22,420 $15,920 $6,500 56050 UNIFORM CONTRACT $0 $0 $0 $0 56080 ADVERTISING $3,554 $4,000 $4,000 $4,000 56110 COMMUNICATIONS $344 $456 $456 $456 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $8,588 $20,400 $20,400 $32,514 56250 DUES AND SUBSCRIPTIONS $5,416 $7,791 $7,791 $9,663 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $28,099 $55,067 $48,567 $53,133 TOTAL CITY MANAGER $1,132,831 $1,329,836 $1,325,496 $1,281,121 14 CITY OF WYLIE CITY SECRETARY DEPARTMENT DESCRIPTION The City Secretary is the chief election official for the City of Wylie and is the official Records Management Officer. Open Records Requests generate through the City Secretary and are accounted for as to their timeliness. This office compiles applications for all City Boards and Commissions and arranges for the interviews, using innovative ways to engage citizens and improve the application process.The office generates Council information, including the bi-weekly agenda packets and special called meetings.The office is responsible for ensuring compliance with state and federal laws related to open records,open meetings,elections,ethics training, records management,and public notices. FISCAL YEAR 2023 GOALS AND OBJECTIVES Wylie General Election (May 2023)-Continue contracting with Collin County Elections for Collin County voters and contract with Dallas and Rockwall County Elections to make it more convenient for the voters. Strategic Goals:Community Focused Government Boards and Commission facilitating. Strategic Goals:Community Focused Government Complete the Code of Ordinance updates. Strategic Goals:Community Focused Government Notice and publication processing while focusing on fiscal accountability and customer service. Strategic Goals:Community Focused Government Continue records management service for the City. Strategic Goals:Community Focused Government Public Information Request processing with a focus on transparency in government. Strategic Goals:Community Focused Government Continue to build and provide City forms online and workflows for easy access by the public and faster processing internally. Strategic Goals:Community Focused Government FISCAL YEAR 2022 ACCOMPLISHMENTS Completed the 2021/2022 Board and Commission appointments and installations utilizing the electronic application with 75 applications received. Strategic Goals:Community Focused Government Provided training to all Board and Commission members in Open Meetings, Public Information, Records Management, Conflicts of Interest, Local Government Code 171 and 176,and City of Wylie Code of Ethics. Strategic Goals:Community Focused Government Provided electronic storage and staff assistance in Laserfiche for City documents. From October 1,2021 to June 6,2022 27,632 documents,or 164,852 pages,have been added in the Laserfiche system. 7,297 documents,or 33,524 pages,of those documents/pages were brought in utilizing Laserfiche Forms. Strategic Goals:Community Focused Government Processed and closed approximately 500 public information requests from October 1,2021 to June 6,2022. Strategic Goals:Community Focused Government From October 1,2021 to June 6,2022 staff created six new workflows and recreated four existing workflows,and created four new electronic forms and recreated three existing electronic forms in Laserfiche for various departments. Strategic Goals:Community Focused Government Facilitated the live-stream and on-demand video of all permanent Boards and Commission meetings. Strategic Goals:Community Focused Government Distributed documents and held 14 City Council meetings and one Special Called meeting from October 1,2021 to June 6, 2022. Strategic Goals:Community Focused Government 15 CITY SECRETARY CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 City Secretary 1.0 1.0 1.0 1.0 Deputy City Secretary 1.0 1.0 0.0 1.0 Records Analyst 1.0 1.0 1.0 1.0 Administrative Assistant II 0.0 0.0 1.0 0.0 TOTAL 3.0 3.0 3.0 3.0 ACTIVITY DEMAND j ACTIVITY WORKLOAD MEASURE FY 2020 1 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ TARGETjPROJ Number of all City agendas posted including Council,and boards 183 130 130 and commissions Number of requests for Public Information 600 600 600 Number of Resolutions for consideration 65 38 33 Number of Ordinances for consideration 58 62 75 60 Number of TABC applications received 6 6 9 7 Number of Documents Created in Laserfiche 49,534 48,307 49,000 49,000 Number of Municode Meetings Portal subscribers 470 490 500 Number of Board and Commission applications received 55 75 48 55 EFFICIENCY j EFFECTIVENESS MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGETJPROJ TARGET/PROD Promote a good relationship with the public by providing courteous 350 400 and prompt service for Open Records Requests and reply within the first four business days. Promote accessibility and efficiency by continuing to create 6 8 7 7 electronic Laserfiche Forms. Assist departments with efficiency by building workflow processes 3 7 6 in Laserfiche. 16 PROPOSED BUDGET FY 2023 100-GENERAL FUND CITY SECRETARY FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $168,642 $183,304 $183,304 $206,794 51130 OVERTIME $1,634 $500 $500 $500 51140 LONGEVITY PAY $868 $1,053 $1,053 $1,109 51310 TMRS $26,434 $28,654 $28,654 $32,302 51410 HOSPITAL AND LIFE INSURANCE $30,069 $28,026 $28,026 $34,979 51420 LONG-TERM DISABILITY $750 $1,005 $1,005 $765 51440 FICA $9,576 $11,461 $11,461 $12,921 51450 MEDICARE $2,240 $2,680 $2,680 $3,022 51470 WORKERS COMP PREMIUM $187 $231 $231 $240 51480 UNEMPLOYMENT COMP(TWC) $756 $810 $810 $810 TOTAL PERSONNEL SERVICES $241,155 $257,726 $257,724 $293,442 52010 OFFICE SUPPLIES $1,477 $2,540 $2,540 $2,570 52070 COMPUTER SOFTWARE $36,358 $0 $0 $0 52810 FOOD SUPPLIES $928 $1,200 $1,200 $1,200 TOTAL SUPPLIES $38,762 $3,740 $3,740 $3,770 54810 COMPUTER HARD/SOFTWARE $6,271 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $6,271 $0 $0 $0 56040 SPECIAL SERVICES $18,119 $16,861 $12,061 $31,105 56070 ELECTIONS $99,352 $93,500 $93,500 $50,500 56080 ADVERTISING $4,932 $6,500 $6,500 $5,500 56210 TRAVEL AND TRAINING $6,056 $9,270 $9,270 $6,000 56250 DUES AND SUBSCRIPTIONS $529 $853 $853 $1,010 TOTAL CONTRACTURAL SERVICES $128,987 $126,984 $122,184 $94,115 TOTAL CITY SECRETARY $415,176 $388,450 $383,648 $391,327 17 CITY OF WYLIE CITY ATTORNEY DEPARTMENT DESCRIPTION The City Attorney acts as legal advisor,Attorney,and counselor for the City and all of its officers in matters relating to their official duties. It is the City Attorney's function to advise the City Council and the various departments of the City,as to the scope of the City's authority and to counsel the City of Wylie in legal issues. 18 PROPOSED BUDGET FY 2023 100-GENERAL FUND CITY ATTORNEY FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51250 JUDICIAL PAY $0 $0 $0 $0 51440 FICA $0 $0 $0 $0 51450 MEDICARE $0 $0 $0 $0 51470 WORKERS COMP PREMIUM $0 $0 $0 $0 TOTAL PERSONNEL SERVICES $0 $0 $0 $0 56530 COURT AND LEGAL COSTS $103,254 $170,000 $170,000 $170,000 56540 LEGAL INDIRECT COSTS $0 $0 $0 $0 56550 LEGAL LITIGATION $0 $0 $0 $0 56560 LEGAL OTHER COUNSEL $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $103,254 $170,000 $170,000 $170,000 TOTAL CITY ATTORNEY $103,254 $170,000 $170,000 $170,000 19 CITY OF WYLIE FINANCE DEPARTMENT DESCRIPTION The Finance Department's mission is to administer the City's fiscal affairs in accordance with applicable local,state and federal guidelines,to ensure fiscal responsibility to citizens and to provide competent,quality service to external and internal customers.The Finance Department includes accounting,auditing,accounts payable, revenue collections,cash management,debt management,and capital assets. The department prepares an annual comprehensive financial report (ACFR)and assists the City Manager with development of the City's annual operating and capital budgets,as well as development and maintenance of a five and ten year financial plan. FISCAL YEAR 2023 GOALS AND OBJECTIVES' Continue to participate in GFOA's award programs. Strategic Goal: Financial Health Continue to participate in the Texas State Comptroller's Transparency Star program. Strategic Goal: Financial Health Review and update Financial, Investment and Debt policies. Strategic Goal: Financial Health Review bond rating agency requirements in preparation for upcoming issuances. Strategic Goal: Financial Health Develop a written guide for the Finance Section of the EOC. Strategic Goal: Financial Health Continue to develop and cross train staff with in-house training, professional conferences and Governmental Accounting Academy. Strategic Goals: Financial Health,Workforce Review all department processes for possible improvements in efficiency(including paperless alternatives)and customer service(external and internal). Strategic Goals: Financial Health,Workforce Continue to develop alternatives for working remotely(when necessary)while maintaining the integrity of all systems and continuing to provide excellent customer service. Strategic Goals: Financial Health,Workforce Implement new budgeting software to reduce time required to produce the budget book and to provide more transparent information online. Strategic Goals: Financial Health,Workforce FISCAL YEAR 2022 ACCOMPLISHMENTS Awarded Certificate of Achievement for Excellence in Financial Reporting by Government Finance Officers Association for the 2021 ACFR Strategic Goal: Financial Health Awarded Distinguished Budget Presentation Award by Government Finance Officers Association for the 2022 Budget. Strategic Goal: Financial Health Rating upgrade by Moody's Investors Service from Aa2 to Aa1. Maintained AA bond rating from Standard and Poor Global Ratings. Strategic Goal: Financial Health 20 FINANCE CONTINUED Upgraded the City's financial software to Incode Version 10 and provided in-house training to all users,city-wide. Strategic Goal: Financial Health,Workforce Developed processes for the Finance Section of the EOC. Strategic Goal: Financial Health BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Finance Director 1.0 1.0 1.0 1.0 Asst. Finance Director 1.0 1.0 1.0 1.0 Budget Manager 1.0 1.0 1.0 1.0 Accountant 2.0 2.0 2.0 2.0 Payroll Specialist 1.0 1.0 0.0 0.0 Accounts Payable Specialist 2.0 2.0 2.0 2.0 Administrative Assistant 1 1.0 1.0 0.0 0.0 Administrative Assistant II 0.0 0.0 1.0 1.0 TOTAL 9.0 9.0 8.0 8.0 21 FINANCE CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ I TARGET/PROD Number of Purchase Orders Processed 5,996 5,796 5,900 5,900 Number of Journal Entries Posted 2,095 1,988 2,100 2,100 EFFICIENCY/EFFECTIVENESS MEASURE BENCHMARK FY 2020 FY 2021 FY 2022 FY 2023' ACTUAL ACTUAL TARGET/PROJ TARGET/PROJ Budget approved by August 5th August 5th August 7th August 5th August 5th August 5th Budget Book Completed 90 days after adoption of 90 days 80 days 90 days 90 days 90 days the budget Provide information to financial advisors, S&P=AAA AA AA AA AA+ bondholders,underwriters and rating agencies(S&P) to lower city interest expense Provide information to financial advisors, Moodys=Aaa Aa2 Aa2 Aa1 Aa1 bondholders,underwriters and rating agencies (Moodys)to lower city interest expense Provide stewardship of financial resources balancing at or below$2,000 1,257 1,062 1,081 1,288 the City's short and long term needs by maintaining the current Net Direct Debt Per Capita per the Debt Management Policy Provide stewardship of financial resources balancing minimum of 35% 54.31% 71.69% 46% 43% the City's short and long term needs by maintaining a healthy General Fund balance(unassigned fund balance as a%of operating budget) Maintain percent of current property taxes collected 100% 99.12% 99.7% 100% 100% (major revenue source) Complete and present to the governing body an January 28 January 28 January 26 January 25 January 24 independent audit within 120 days of fiscal year end. Provide stewardship of financial resources balancing at or below 4% .0139 .0119 .0107 .0132 the City's short and long term needs by maintaining a ratio of Net Direct Debt to Assessed Value of properties in the City per the Debt Management Policy 22 PROPOSED BUDGET FY 2023 100-GENERAL FUND FINANCE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $605,355 $552,585 $552,585 $575,973 51112 SALARIES-PART TIME $0 $0 $0 $0 51130 OVERTIME $0 $2,000 $2,000 $2,000 51140 LONGEVITY PAY $3,792 $4,207 $4,207 $2,943 51310 TMRS $94,640 $94,512 $94,512 $90,042 51410 HOSPITAL AND LIFE INSURANCE $85,722 $78,633 $78,633 $87,678 51420 LONG-TERM DISABILITY $2,488 $3,395 $3,395 $2,131 51440 FICA $36,827 $37,805 $37,805 $36,017 51450 MEDICARE $8,668 $8,842 $8,842 $8,428 51470 WORKERS COMP PREMIUM $599 $783 $783 $667 51480 UNEMPLOYMENT COMP(TWC) $2,268 $2,430 $2,430 $2,160 TOTAL PERSONNEL SERVICES $840,358 $785,191 $785,192 $808,039 52010 OFFICE SUPPLIES $7,509 $7,850 $7,850 $7,850 52810 FOOD SUPPLIES $1,624 $800 $800 $800 TOTAL SUPPLIES $9,133 $8,650 $8,650 $8,650 54810 COMPUTER HARD/SOFTWARE $0 $0 $0 $81,000 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $81,000 56040 SPECIAL SERVICES $16,267 $27,500 $27,500 $29,500 56080 ADVERTISING $3,807 $6,600 $6,600 $6,600 56180 RENTAL $3,303 $3,600 $3,600 $3,600 56210 TRAVEL AND TRAINING $2,259 $12,000 $12,000 $12,000 56250 DUES AND SUBSCRIPTIONS $1,200 $1,630 $1,630 $1,690 56330 BANK SERVICE CHARGES $6,184 $8,800 $8,800 $6,200 56340 CCARD ONLINE SERVICE FEES $31,367 $30,000 $30,000 $30,000 56350 APPRAISAL FEES $237,910 $262,700 $262,700 $280,360 56510 AUDIT AND LEGAL SERVICES $67,185 $74,960 $74,960 $76,350 TOTAL CONTRACTURAL SERVICES $369,483 $427,790 $427,790 $446,300 TOTAL FINANCE $1 218,974 $1,221,631 $1,221,632 $1,343 989 23 CITY OF WYLIE FACILITIES DEPARTMENT DESCRIPTION The Facilities Department is a division of Support Services. It is responsible for the maintenance of all municipal facilities. Facility maintenance functions include general custodial duties and repair or upkeep of offices and public areas, HVAC,plumbing,electrical,and building systems. FISCAL YEAR 2023 GOALS AND OBJECTIVES Work with all departments to assist with projects and improvements to all facilities. Strategic Goals: Infrastructure Reduce downtime and maintain the efficiency of critical systems by continuing to improve preventative maintenance procedures. Strategic Goals: Infrastructure Continue to improve customer service as well as tracking and response time for maintenance work orders. Strategic Goals: Infrastructure Develop a long-range plan to maintain major systems and projected facility needs. Strategic Goals: Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS Assist with projects and improvements to all city departments such as renovations at Fire Stations,the Brown House,and City Hall as well as upgrades to Parks and Animal Control. Strategic Goals: Infrastructure Improve tracking and response time for maintenance work orders. Strategic Goals: Infrastructure Maintain the efficiency of critical systems by continuing to improve preventative maintenance procedures as well as performing major repairs to HVAC and chill water systems. Strategic Goals: Infrastructure BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Facilities Manager 1.0 1.0 1.0 1.0 Maintenance Technician 2.0 2.0 3.0 3.0 TOTAL 3.0 3.0 4.0 4.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE BENCHMARK FY 2022 FY 2023 TARGET/PROJ TARGET/PROJ Respond and complete work orders.Total as of May 31,2022 is 474. 60 per month 720 720 24 PROPOSED BUDGET FY 2023 100-GENERAL FUND FACILITIES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $213,429 $261,227 $261,227 $271,710 51112 SALARIES-PART TIME $0 $0 $0 $0 51130 OVERTIME $3,958 $3,717 $3,717 $3,717 51140 LONGEVITY PAY $960 $1,151 $1,151 $1,957 51310 TMRS $33,768 $41,245 $41,245 $42,995 51410 HOSPITAL AND LIFE INSURANCE $33,468 $38,650 $38,650 $45,737 51420 LONG-TERM DISABILITY $1,013 $1,431 $1,431 $1,005 51440 FICA $12,947 $16,498 $16,498 $17,198 51450 MEDICARE $3,028 $3,859 $3,859 $4,022 51470 WORKERS COMP PREMIUM $485 $755 $755 $676 51480 UNEMPLOYMENT COMP(TWC) $826 $1,080 $1,080 $1,080 TOTAL PERSONNEL SERVICES $303,883 $369,613 $369,613 $390,097 52010 OFFICE SUPPLIES $0 $100 $100 $100 52130 TOOLS/EQUIP(NON-CAPITAL) $131 $3,350 $3,350 $1,500 52210 JANITORIAL SUPPLIES $36,781 $45,000 $45,000 $47,000 52310 FUEL AND LUBRICANTS $3,736 $6,000 $6,000 $7,000 52710 WEARING APPAREL AND UNIFORMS $0 $500 $500 $500 52740 FLAGS $4,791 $5,000 $5,000 $5,000 52810 FOOD SUPPLIES $9,739 $10,560 $10,560 $12,900 TOTAL SUPPLIES $55,178 $70,510 $70,510 $74,000 54810 COMPUTER HARD/SOFTWARE $4,032 $13,905 $13,905 $0 54910 BUILDINGS $210,656 $213,000 $213,000 $235,000 TOTAL MATERIALS FOR MAINTENANCE $214,687 $226,905 $226,905 $235,000 56040 SPECIAL SERVICES $188,610 $310,045 $310,045 $321,500 56110 COMMUNICATIONS $0 $1,200 $1,200 $0 TOTAL CONTRACTURAL SERVICES $188,610 $311,245 $311,245 $321,500 58510 MOTOR VEHICLES $30,640 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $0 $0 $0 $25,000 TOTAL CAPITAL OUTLAY $30,640 $0 $0 $25,000 TOTAL FACILITIES $792,998 $978,273 $978,273 $1,045,597 25 CITY OF WYLIE MUNICIPAL COURT DEPARTMENT DESCRIPTION The court's mission is to provide a fair,impartial and timely adjudication of misdemeanor offenses committed and filed in the City of Wylie. To properly administer this function,the department must schedule offenders to appear before the court,adjudicate the trial,collect fines from guilty offenders,and issue warrants of arrest. FISCAL YEAR 2023 GOALS AND OBJECTIVES Staff will continue to participate in the continuing education and certification programs through TMCEC. Strategic Goals: Workforce, Health,Safety and Well-Being The Juvenile Case Manager program will continue to expand Teen Court and other programs for youth to reduce recidivism. Teen Court Attorneys will participate in the Teen Court Association of Texas Mock Trial competition. Strategic Goal: Community Focused Government Continue to schedule Annual Warrant Resolution Open Docket Day. Strategic Goals: Community Focused Government,Workforce Continue to host training with the Texas Court Clerks Association. Strategic Goal: Workforce Continue to participate in Municipal Court Week. Strategic Goal: Workforce Continue to participate in National Night Out. Strategic Goals: Workforce,Community Focused Government FISCAL YEAR'2022 ACCOMPLISHMENTS All staff continue to participate in continuing education and certification programs through Texas Municipal Courts Education Center.The Juvenile Case Manager maintained Level II Certification, Deputy Clerk maintained Level II Certification,Senior Clerk maintained Level I certification,and Court Administrator maintained Level III certification. Strategic Goals: Community Focused Government, Health,Safety and Well-Being Juvenile Case Manager program beginning sixth year for the Wylie Teen Court program. Strategic Goal: Community Focused Government The Juvenile Case Manager program continued to partner with MADD to host Victim Impact Panels at our facility. Strategic Goals: Community Focused Government,Workforce Participated in Municipal Court Week, luncheon for court staff with city management. Strategic Goal:Workforce Hosted mock trial competitions for Wylie ISD and Classical Conversations Home School organization. Strategic Goal:Community Focused Government Participated in National Night Out, provided a DWI simulator loaned from Texas AandM Agrilife Extension Alcohol and Drug Awareness program along with Teen Court and traffic safety promotional items. Strategic Goal:Community Focused Government,Safety and Well-Being Continued to adjust court operating procedures adhering to mandates and guidelines provided and ordered by the Supreme Court of Texas as a result of the pandemic. Successfully commenced jury trials and re-established procedures for due dates to eliminate backlog of disposed cases caused by orders from the Supreme Court of Texas as a result of the pandemic. Strategic Goals: Workforce, Health,Safety and Well-Being MUNICIPAL COURT CONTINUED Upgraded court software to Incode 10 Court,final implementation August 2022. New software will provide the option to request Driving Safety and Deferred Disposition online. Strategic Goals:Workforce,Community Focused Government Collaborated with Wylie Presiding and Associate Judges,Collin County Probation,Collin County District Attorney,and arresting agencies to successfully implement procedures for Emergency Protective Order Modification and Bond Condition Violation hearings scheduled through the Wylie Municipal Court. Strategic Goal:Workforce BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Court Administrator 1.0 1.0 1.0 1.0 Juvenile Case Manager 1.0 1.0 1.0 1.0 Senior Court Clerk 1.0 1.0 1.0 1.0 Deputy Court Clerk 2.0 2.0 2.0 2.0 TOTAL 5.0 5.0 5.0 5.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ TARGET/PROJ Clearance Rate-the number of outgoing cases as a 84% 96% 139% 95% percentage of the number of incoming cases. Goal is equal to or greater than 95%. 27 PROPOSED BUDGET FY 2023 100-GENERAL FUND MUNICIPAL COURT FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $225,105 $240,469 $240,469 $266,822 51130 OVERTIME $1,730 $4,500 $4,500 $5,500 51140 LONGEVITY PAY $1,100 $1,332 $1,332 $1,361 51160 CERTIFICATION INCENTIVE $0 $0 $0 $1,200 51250 JUDICIAL PAY $55,606 $90,000 $90,000 $100,000 51310 TMRS $35,215 $38,177 $38,177 $42,607 51410 HOSPITAL AND LIFE INSURANCE $38,106 $42,334 $42,334 $47,769 51420 LONG-TERM DISABILITY $912 $1,840 $1,840 $1,357 51440 FICA $17,209 $19,921 $19,921 $23,243 51450 MEDICARE $4,025 $4,659 $4,659 $5,436 51470 WORKERS COMP PREMIUM $304 $428 $428 $431 51480 UNEMPLOYMENT COMP(TWC) $1,260 $1,890 $1,890 $1,890 TOTAL PERSONNEL SERVICES $380,573 $445,549 $445,550 $497,616 52010 OFFICE SUPPLIES $5,990 $6,500 $6,500 $6,500 52810 FOOD SUPPLIES $1,867 $4,800 $4,800 $5,000 TOTAL SUPPLIES $7,858 $11,300 $11,300 $11,500 56040 SPECIAL SERVICES $4,789 $5,700 $5,700 $5,700 56110 COMMUNICATIONS $0 $0 $0 $475 56210 TRAVEL AND TRAINING $4,149 $7,500 $7,500 $10,500 56250 DUES AND SUBSCRIPTIONS $275 $465 $465 $465 56510 AUDIT AND LEGAL SERVICES $14,925 $60,000 $60,000 $50,000 TOTAL CONTRACTURAL SERVICES $24,138 $73,665 $73,665 $67,140 TOTAL MUNICIPAL COURT $412,569 $530,514 $530,515 $576,256 28 CITY OF WYLIE HUMAN RESOURCES DEPARTMENT DESCRIPTION The City of Wylie Human Resources Department exists to serve the employees of the City to the best of our ability while maintaining the integrity of established policies, procedures,and expectations.We strive to promote the positive aspects of working for this great city while fostering an atmosphere of fairness and employee engagement.These goals are accomplished by a conscious effort to be present and available to departments on casual and formal occasions and be involved at the level required by the individual departments and managers.The Human Resources team includes our HR Director, Risk Administrator, two HR Analysts, Payroll Specialist,and an Administrative Assistant.This department is responsible for employee relations, policy administration,safety, benefits, recruiting, payroll,tuition reimbursement,city-wide events,wellness programs,and training. FISCAL YEAR 2023 GOALS AND OBJECTIVES Review and update recruiting and retention approach Strategic Goal:Workforce Continue to expand in-person training Strategic Goal:Workforce Explore cost containment strategies for all employee benefits while staying competitive Strategic Goals:Workforce; Health,Safety,and Well-Being FISCAL YEAR 2022 ACCOMPLISHMENTS New carrier for medical, dental, life insurance, long-term disability Strategic Goals:Workforce; Health,Safety,and Well-Being Implemented online benefits enrollment to streamline the process Strategic Goals:Workforce; Health,Safety,and Well-Being Pre-employment and post-accident testing brought in-house Strategic Goals:Workforce; Health,Safety,and Well-Being Market study for all positions Strategic Goal:Workforce Relocated payroll to the HR department Strategic Goal:Workforce BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Human Resources Director 1.0 1.0 1.0 1.0 Risk Coordinator 1.0 1.0 1.0 1.0 Benefits & Recruiting Specialist 1.0 0.0 0.0 0.0 Human Resource Analyst 1.0 2.0 2.0 2.0 Payroll Specialist 0.0 0.0 1.0 1.0 Administrative Assistant 1 1.0 1.0 1.0 1.0 TOTAL 5.0 5.0 6.0 6.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROD TARGET/PRO1 Annual Turnover 29 11% 18% 15% Applications Received/Reviewed 1,999 1,799 2,000 PROPOSED BUDGET FY 2023 100-GENERAL FUND HUMAN RESOURCES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $369,770 $439,699 $439,699 $462,467 51112 SALARIES-PART TIME $3,275 $8,175 $8,175 $8,175 51130 OVERTIME $0 $250 $250 $250 51140 LONGEVITY PAY $2,048 $2,281 $2,281 $3,088 51250 TUITION REIMBURSEMENT $14,203 $12,530 $12,530 $20,000 51310 TMRS $57,763 $60,649 $60,649 $72,200 51410 HOSPITAL AND LIFE INSURANCE $44,570 $52,074 $52,074 $58,519 51420 LONG-TERM DISABILITY $1,495 $2,149 $2,149 $1,711 51440 FICA $22,899 $24,766 $24,766 $29,387 51450 MEDICARE $5,355 $5,792 $5,792 $6,873 51470 WORKERS COMP PREMIUM $388 $505 $505 $544 51480 UNEMPLOYMENT COMP(TWC) $1,541 $1,485 $1,485 $1,755 TOTAL PERSONNEL SERVICES $523,309 $610,356 $610,355 $664,969 52010 OFFICE SUPPLIES $3,922 $3,000 $3,000 $3,000 52810 FOOD SUPPLIES $498 $2,500 $2,500 $2,500 TOTAL SUPPLIES $4,420 $5,500 $5,500 $5,500 54810 COMPUTER HARD/SOFTWARE $0 $11,025 $11,025 $17,550 TOTAL MATERIALS FOR MAINTENANCE $0 $11,025 $11,025 $17,550 56040 SPECIAL SERVICES $113,438 $84,800 $84,800 $85,950 56080 ADVERTISING $3,397 $5,000 $5,000 $5,000 56210 TRAVEL AND TRAINING $12,266 $22,945 $22,945 $28,000 56250 DUES AND SUBSCRIPTIONS $3,319 $3,485 $3,485 $3,010 TOTAL CONTRACTURAL SERVICES $132,420 $116,230 $116,230 $121,960 TOTAL HUMAN RESOURCES $660,149 $743,111 $743,110 $809,979 30 CITY OF WYLIE PURCHASING DEPARTMENT DESCRIPTION The mission of the Purchasing Department is to process purchases and bids,and manage contracts for the organization in a timely manner,ensure compliance with policies, procedures,and regulations;facilitate asset disposal;and manage risk requirements and insurance coverage for property,vehicles and general liability,and process liability claims. To promote fiscal responsibility by obtaining the right product,for the right purpose,at the right time,for the right price. To actively seek fair competition in the procurement process. To ensure ethical compliance with Federal,State and local laws. To treat suppliers fairly and equitably. To increase public confidence in public purchasing. FISCAL YEAR 2023 GOALS AND OBJECTIVES' Fill purchasing position vacancy,complete orientation to the City's culture and procurement policies,and begin succession planning/training. Strategic Goal: Financial Health Job Order Contracting Program; review existing program and the additional firms Strategic Goal: Financial Health Fund Balance Program: complete the bid processes for these projects. Strategic Goal: Financial Health Create a procurement education series; 1-2 hour classes on specific topics that would be offered through the internal quarterly HR training calendar. Strategic Goal: Financial Health Roll out of new contract information to departments. Strategic Goal: Financial Health FISCAL YEAR 2O22 ACCOMPLISHMENTS Council approval of the 2022 Procurement Manual. Strategic Goal: Financial Health Roll out new Vehicle/Property Incident Report through Laserfiche forms(worked with City Secretary Office) Strategic Goal: Financial Health Roll out new Citizen Claim report through Laserfiche forms(worked with City Secretary Office) Strategic Goal: Financial Health Assisted departments with 118+bids/project orders and quotes;including the Fund Balance Projects and Fire Station 4. Strategic Goal: Financial Health BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Purchasing Manager 1.0 1.0 1.0 1.0 Senior Buyer 0.0 0.0 1.0 1.0 Buyer 1.0 1.0 1.0 1.0 TOTAL 2.0 2.0 3.0 3.0 31 PROPOSED BUDGET FY 2023 100-GENERAL FUND PURCHASING FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $128,717 $175,489 $175,489 $209,310 51130 OVERTIME $0 $0 $0 $0 51140 LONGEVITY PAY $696 $837 $837 $616 51310 TMRS $20,279 $27,332 $27,332 $32,539 51410 HOSPITAL AND LIFE INSURANCE $16,949 $29,932 $29,932 $36,107 51420 LONG-TERM DISABILITY $575 $1,022 $1,022 $775 51440 FICA $8,124 $10,933 $10,933 $13,015 51450 MEDICARE $1,900 $2,556 $2,556 $3,044 51470 WORKERS COMP PREMIUM $129 $235 $235 $241 51480 UNEMPLOYMENT COMP(TWC) $504 $810 $810 $810 TOTAL PERSONNEL SERVICES $177,872 $249,146 $249,146 $296,457 52010 OFFICE SUPPLIES $935 $2,700 $2,700 $2,500 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $3,600 $3,600 $0 52310 FUEL AND LUBRICANTS $0 $0 $0 $0 TOTAL SUPPLIES $935 $6,300 $6,300 $2,500 56040 SPECIAL SERVICES $13,500 $11,000 $11,000 $11,000 56050 UNIFORM CONTRACT $0 $0 $0 $0 56080 ADVERTISING $1,822 $5,300 $5,300 $5,400 56110 COMMUNICATIONS $0 $0 $0 $0 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $75 $10,000 $10,000 $9,000 56250 DUES AND SUBSCRIPTIONS $1,198 $2,550 $2,550 $2,200 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $16,595 $28,850 $28,850 $27,600 TOTAL PURCHASING $195,402 $284,296 $284,296 $326,557 32 CITY OF WYLIE INFORMATION TECHNOLOGY DEPARTMENT DESCRIPTION The mission of the Information Technology Department is to provide technical support to the organization for current software and equipment as well as planning for future technology initiatives.Support includes assisting in the development and implementation of technology related policies and procedures. FISCAL YEAR 2023 GOALS AND OBJECTIVES Add Redundancy to all City Buildings Strategic Goals: Infrastructure Complete Backup Dispatch at FH4 Strategic Goals: Infrastructure Complete a Fiber Ring to City Hall Strategic Goals: Infrastructure Cleanup Directory Services Strategic Goals: Infrastructure/Workforce Improve Cybersecurity Program Strategic Goals: Infrastructure/Workforce FISCAL YEAR 2022 ACCOMPLISHMENTS Upgraded Brown House Technology to Accommodate More Staff Strategic Goals: Infrastructure/Workforce Added Internet Failover at PSB Strategic Goals: Infrastructure Updated Public Safety Gateways Strategic Goals: Infrastructure Redundant Infrastructure at PSB Strategic Goals: Infrastructure Brought Fire Station 4 Online Strategic Goals: Infrastructure Upgraded Finance and Utility Billing to Incode 10 Strategic Goals: Infrastructure/Workforce Updated the Video Server and Firewal) in MICP Strategic Goals: Infrastructure/Workforce Upgraded Laserfiche Suite Strategic Goals: Infrastructure Migrated to Disk/Online Backup System Strategic Goals: Infrastructure Created Dashboard for the Citizens Strategic Goals:Community Focused Government 33 INFORMATION TECHNOLOGY CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Operations Director 0.0 0.0 1.0 1.0 Information Technology Manager 1.0 1.0 1.0 1.0 Systems Analyst 1.0 1.0 0.0 0.0 IT Specialist 2.0 2.0 2.0 2.0 GIS Manager 0.0 0.0 1.0 1.0 GIS Analyst 1.0 1.0 0.0 0.0 GIS Technician 1.0 1.0 1.0 1.0 TOTAL 6.0 6.0 6.0 6.0 ACTIVITY DEMAND ACTIVITY WORKLOAD MEASURE FY 2021 FY 2022 IFY 2023 ACTUAL TARGET/PRO! TARGET/PROJ IT support tickets resolved. 1,656 1,718 1,700 34 PROPOSED BUDGET FY 2023 100-GENERAL FUND INFORMATION TECHNOLOGY FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $366,592 $402,749 $402,749 $424,424 51130 OVERTIME $15,499 $18,000 $18,000 $18,000 51140 LONGEVITY PAY $880 $1,135 $1,135 $1,341 51310 TMRS $59,217 $65,392 $65,392 $68,784 51410 HOSPITAL AND LIFE INSURANCE $55,055 $53,123 $53,123 $66,789 51420 LONG-TERM DISABILITY $1,575 $2,095 $2,095 $1,571 51440 FICA $23,518 $26,157 $26,157 $27,513 51450 MEDICARE $5,500 $6,117 $6,117 $6,435 51470 WORKERS COMP PREMIUM $386 $503 $503 $510 51480 UNEMPLOYMENT COMP(TWC) $1,512 $1,620 $1,620 $1,620 TOTAL PERSONNEL SERVICES $529,735 $576,892 $576,891 $616,987 52010 OFFICE SUPPLIES $237 $1,256 $1,256 $1,000 52070 COMPUTER SOFTWARE $10,008 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $148,331 $318,050 $168,500 $313,300 TOTAL SUPPLIES $158,576 $319,306 $169,756 $314,300 54810 COMPUTER HARD/SOFTWARE $968,590 $1,030,877 $880,877 $1,200,787 TOTAL MATERIALS FOR MAINTENANCE $968,590 $1,030,877 $880,877 $1,200,787 56040 SPECIAL SERVICES $3,417 $13,000 $13,000 $38,540 56110 COMMUNICATIONS $3,991 $6,336 $6,336 $6,603 56180 RENTAL $77,665 $82,180 $82,180 $82,180 56210 TRAVEL AND TRAINING $7,500 $23,800 $23,300 $23,500 56250 DUES AND SUBSCRIPTIONS $0 $330 $330 $355 TOTAL CONTRACTURAL SERVICES $92,572 $125,646 $125,146 $151,178 58810 COMPUTER HARD/SOFTWARE $0 $75,000 $0 $75,000 TOTAL CAPITAL OUTLAY $0 $75,000 $0 $75,000 TOTAL INFORMATION TECHNOLOGY $1,749,473 $2,127,721 $1,752,670 $2,358,252 35 CITY OF WYLIE POLICE DEPARTMENT DEPARTMENT DESCRIPTION The Wylie Police Department is an organization that is devoted to our mission of providing a professional level of service. We strive to foster support and build relationships with those we serve. This is achieved through the enforcement of state law, city ordinances and by establishing partnerships with the community through programs that involve citizens,churches,and businesses regarding problem solving and crime prevention.Although a low crime rate is something that we are certainly proud of,there is much more to policing than what is measured by a crime rate. People move to Wylie for a better quality of life,which we strive to improve each year. Our budget this year has been designed to help us maintain and improve the quality of life as well as meet the standards that the citizens of Wylie have come to expect and appreciate. Impacting the quality of life by providing a professional level of service that will foster support and build relationships with those we serve. FISCAL YEAR 2023 GOALS AND OBJECTIVES Maintain or reduce the crime rate and traffic collisions. Strategic Goals: Health,Safety,and Well-Being Develop a plan to reduce the recidivism of crisis related calls for mental health consumers. Strategic Goals: Health,Safety,and Well-Being Improve the department's social media platforms to push important information out to citizens. Strategic Goal:Community Focused Government Continue working towards achieving accreditation in the Texas Police Chiefs Association Best Practices. Strategic Goal:Community Focused Government Achieve 100%policy update to meet the requirements for Texas Best Practices. Strategic Goal:Community Focused Government Continue working to fill vacancies within the department. Strategic Goal:Workforce Continue to examine more efficient ways to accomplish tasks and minimize the extra duties carried by personnel. Strategic Goal:Workforce Create and implement a training program for new supervisors. Strategic Goal:Workforce Develop a task book that employees can work through in order to prepare them for new positions within the department. Attrition over the next several years is a major concern,especially with tenured employees,which requires immediate action to begin preparing for progression within the department. Strategic Goal:Workforce Have an independent company conduct a staffing study for the department. Strategic Goal:Workforce Continue to work on and update the department's strategic plan for the future. Strategic Goal: Infrastructure 36 POLICE DEPARTMENT CONTINUED FISCAL YEAR 2022 ACCOMPLISHMENTS Wylie Police Department saw a 12%reduction in crime,despite a 13 percent increase in population. Strategic Goals: Health,Safety,and Well-Being Police Department personnel have exceeded the fitness test proficiency standards set by the department in the first year. Strategic Goals: Health,Safety,and Well-Being Submitted the required documents and received grant funding to start the process for The Texas Police Chiefs Best Practices Accreditation Program. Strategic Goal:Community Focused Government 85%of Departmental policies have been updated to comply with the Best Practices Standards. Strategic Goal:Community Focused Government Department added a Training Coordinator to help track and submit training hours to the Texas Commission on Law Enforcement. The training coordinator has also been instrumental in overseeing the Best Practices Program. Strategic Goal:Workforce A part-time Mental Health Coordinator was hired,which provided immediate resources and follow up for citizens and family member's dealing with individuals experiencing a mental crisis. Strategic Goal:Workforce The department hired several new officers filling many of the vacant positions. Strategic Goal:Workforce BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Police Chief 1.0 1.0 1.0 1.0 Assistant Police Chief 1.0 1.0 1.0 1.0 Police Lieutenant 4.0 4.0 4.0 4.0 Police Sergeant 8.0 8.0 8.0 9.0 Police Corporal 5.0 5.0 5.0 5.0 Detective 9.0 9.0 9.0 9.0 Patrol Officer 27.0 27.0 27.0 28.0 Traffic Officer 2.0 2.0 2.0 2.0 School Resource Officer 8.0 8.0 8.0 8.0 Bailiff/Warrant Officer 1.5 1.5 1.5 1.5 Jail Manager 1.0 1.0 1.0 1.0 Detention Officer 0.0 6.0 8.0 8.0 Crime Prevention Officer 1.0 1.0 1.0 1.0 Administrative Assistant II 1.0 1.0 1.0 1.0 Administrative Assistant 1 1.0 1.0 1.5 1.5 Records Supervisor 1.0 1.0 1.0 1.0 Records Clerk 2.0 37 2.0 2.0 2.0 POLICE DEPARTMENT CONTINUED Crime Scene Tech/Criminialist 2.0 2.0 2.0 2.0 Crime Victim Advocate 1.0 1.0 1.0 1.0 Training Coordinator 0.0 0.0 1.0 1.0 Mental Health Coordinator 0.0 0.0 0.5 1.0 Quartermaster 0.0 0.0 0.5 0.5 Crossing Guard 4.0 4.0 4.0 5.0 TOTAL 80.5 86.5 91.0 94.5 ACTIVITY DEMAND J ACTIVITY WORKLOAD MEASURE BENCHMARK FY 2020 FY 2021 FY'2022 FY 2023 ACTUAL ACTUAL TARGET/PRO1 TARGET/PRO1 Crime Rate(Is figured per 1,000 population) 3%Reduction 26.26(10% 23.23(12% 22.53(3% 21.85(3% Reduction) Reduction) Reduction) Reduction) Traffic Stops 5%Increase 8,036 9,641(20% 10,123(5% 10,629(5% Increase) Increase) Increase) Mental Health Related Arrests by Police Officer 5%Reduction 159(16% 205(29% 195(5% 185(5% Without a Warrant(APOWW) Increase) Increase) Reduction) Reduction) Motor Vehicle Collisions(Includes minor, 3%Reduction 710(18% 888(25% 861(3% 835(3% major,and fatal accidents) Reduction) Increase) Decrease) Decrease) Calls for Service(CFS) 3%Increase 28,206(5% 29,994(6% 30,894(3% 31,821(3% Decrease) Increase) Increase) Increase) 38 PROPOSED BUDGET FY 2023 100-GENERAL FUND POLICE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $5,899,937 $6,438,802 $6,438,802 $7,007,283 51112 SALARIES-PART TIME $248,122 $265,625 $265,625 $315,529 51130 OVERTIME $763,911 $858,375 $858,375 $822,649 51140 LONGEVITY PAY $35,992 $37,116 $37,116 $35,427 51150 FIELD TRAINING OFFICER PAY $10,273 $14,400 $14,400 $14,400 51160 CERTIFICATION INCENTIVE $79,615 $88,800 $81,000 $107,000 51170 PARAMEDIC INCENTIVE $2,507 $2,500 $2,500 $2,500 51310 TMRS $1,048,642 $1,150,943 $1,150,943 $1,237,952 51410 HOSPITAL AND LIFE INSURANCE $884,072 $978,716 $978,716 $1,118,540 51420 LONG-TERM DISABILITY $23,964 $34,061 $34,061 $26,368 51440 FICA $415,979 $476,845 $476,845 $514,768 51450 MEDICARE $97,744 $111,520 $111,520 $120,388 51470 WORKERS COMP PREMIUM $65,418 $78,240 $78,329 $89,087 51480 UNEMPLOYMENT COMP(TWC) $27,330 $29,970 $29,970 $32,130 TOTAL PERSONNEL SERVICES $9,603,505 $10,565,913 $10,558,202 $11,444,021 52010 OFFICE SUPPLIES $17,831 $22,400 $22,400 $20,700 52040 POSTAGE AND FREIGHT $1,202 $1,200 $1,200 $600 52130 TOOLS/EQUIP(NON-CAPITAL) $351,507 $339,885 $339,885 $356,259 52210 JANITORIAL SUPPLIES $753 $1,200 $1,200 $500 52250 MEDICAL AND SURGICAL $7,676 $13,210 $13,210 $10,475 52310 FUEL AND LUBRICANTS $98,978 $153,000 $153,000 $156,600 52710 WEARING APPAREL AND UNIFORMS $79,653 $59,467 $59,467 $86,236 52810 FOOD SUPPLIES $13,087 $31,300 $31,300 $26,750 52990 OTHER $48,395 $56,250 $56,250 $74,110 TOTAL SUPPLIES $619,082 $677,912 $677,912 $732,230 54510 MOTOR VEHICLES $10,004 $10,000 $10,000 $10,000 54530 HEAVY EQUIPMENT $1,419 $6,000 $6,000 $4,000 54630 TOOLS AND EQUIPMENT $9,568 $10,000 $10,000 $10,000 54810 COMPUTER HARD/SOFTWARE $22,300 $28,400 $28,400 $930 54910 BUILDINGS $0 $3,000 $3,000 $3,000 TOTAL MATERIALS FOR MAINTENANCE $43,290 $57,400 $57,400 $27,930 56040 SPECIAL SERVICES $45,564 $65,324 $65,324 $56,694 56110 COMMUNICATIONS $66,335 $76,888 $76,888 $81,360 56150 LAB ANALYSIS $19,879 $20,000 $20,000 $20,000 56180 RENTAL $34,446 $34,100 $34,100 $34,400 56210 TRAVEL AND TRAINING $103,139 $258,891 $258,891 $247,169 56250 DUES AND SUBSCRIPTIONS $4,696 $8,485 $8,485 $8,920 56990 OTHER $7,741 $20,000 $20,000 $15,000 TOTAL CONTRACTURAL SERVICES $281,799 $483,688 $483,688 $463,543 39 PROPOSED BUDGET FY 2023 100-GENERAL FUND POLICE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 58510 MOTOR VEHICLES $276,637 $509,500 $292,000 $463,500 58850 MAJOR TOOLS AND EQUIPMENT $0 $46,340 $46,340 $0 TOTAL CAPITAL OUTLAY $276,637 $555,840 $338,340 $463,500 TOTAL POLICE $10,824,313 $12,340,753 $12,115,542 $13,131,224 40 CITY OF WYLIE FIRE DEPARTMENT DEPARTMENT DESCRIPTION The Wylie Fire Rescue is an all-hazard professional fire and rescue organization of 66.5 FTEs. The department has 5 divisions which include administration,operations,communications, prevention,and emergency management. Fire Administration consists of the Fire Chief's office and emergency management which includes 7 administration personnel. Fire Prevention consists of 4.5 prevention personnel. Operations are the largest division and are based out of 4 strategically located fire stations across the city with 60 personnel assigned to it. Currently,operations have a minimum of 19 personnel duty at all times. To dedicate ourselves to providing a progressive department of professionally trained and equipped personnel in order to protect the lives,property,and environment of our community. The Fire Department's objectives are to protect the lives, property,and environment of our community in the event of a man-made or natural threat;and to provide Advanced Life Support Emergency Medical Services.To accomplish these objectives,the department performs the following functions: 1.Community risk reduction which includes:fire inspection, prevention,and investigation 2. Fire suppression 3. Emergency medical response 4.Specialized programs which include: hazardous materials,water rescue,and technical rescue 5.Coordination of the community's emergency management activities. FISCAL YEAR 2023 GOALS AND OBJECTIVES Maintain our ISO#1 through a comprehensive planning program to be ready by November 2022. Strategic Goals: Health,Safety and Well-Being, Infrastructure Renew EMS Contract and add a 3rd Full-time ambulance Strategic Goal: Health Safety,and Well-Being, Infrastructure Hire 6 additional firefighters Strategic Goal:Workforce Install 1 new outdoor warning siren and Upgrade 1 outdoor warning siren Strategic Goal: Health,Safety and Well-Being, Infrastructure Coordinate construction and delivery of 2 New Quints, 1 Air/Light Truck,and 1 Ambulance Strategic Goal: Health,Safety,and Well-Being Acquire and Monitor grant opportunities. Strategic Goals: Community-Focused Government, Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS Managed the COVID-19 pandemic disaster through aggressive emergency management activities. Strategic Goal: Health,Safety and Well-Being,Community Focused Government Prevented loss of life to fire through detectors,awareness,and public education. Strategic Goals: Health Safety and Well-Being,Community Focused Government Emergency services provided to community demands in accordance with ISO 1. Maintained ISO#1 certification. Strategic Goals: Health Safety and Well-Being,Community Focused Government Maintained low incidence of fires in high-value and commercial properties. Strategic Goals: Health Safety and Well-Being,Community Focused Government FIRE DEPARTMENT CONTINUED Finished construction on Fire Station#4. Strategic Goal: Infrastructure Acquired a new Fire apparatus(Quint)for Fire Station 4. Strategic Goal: Infrastructure, Health,Safety,and Well-Being Acquired 3 new vehicles through the city's vehicle replacement plan. Strategic Goal: Infrastructure Acquired a new outdoor warning siren communications system and installed 1 new outdoor warning siren. Strategic Goals: Health,Safety and Well-Being, Infrastructure Maintained compliance with the Texas Commission on Fire Protection required training and certification. Maintained compliance with the Texas Department of State Health Services required training and certifications. Maintained Best Practices designation by the Texas Fire Chiefs Association. Strategic Goal:Workforce BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Fire Chief 1.0 1.0 1.0 1.0 Assistant Fire Chief 1.0 1.0 1.0 1.0 Battalion Chief 3.0 4.0 4.0 4.0 Captain 10.0 9.0 12.0 12.0 Fire Marshal 1.0 1.0 1.0 1.0 Fire Inspector/Investigator 2.0 2.0 2.0 2.0 Emergency Management Coordinator 1.0 1.0 1.0 1.0 Fire Apparatus Operator 9.0 9.0 12.0 12.0 Firefighter 28.0 33.0 33.0 39.0 Alarm Permit Coordinator 1.0 1.0 1.0 1.0 Administrative Assistant 1 1.0 1.0 1.0 1.0 Fire Prevention Clerk 1.0 1.0 1.0 0.0 Fire Records Analyst 0.0 0.0 0.0 1.0 Support Services Coordinator 1.0 1.0 1.0 1.0 Summer Intern 0.5 0.5 0.5 0.5 TOTAL 60.5 65.5 71.5 77.5 42 FIRE DEPARTMENT CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2021 FY 2022 FY 2023 ACTUAL TARGET/PROD TARGET/PROD Calls for Service 7,300 7,500 7,500 EFFICIENCY/EFFECTIVENESS MEASURE BENCHMARK FY 2021 FY 2022 FY 2023 ACTUAL TARGET/PROD TARGET/PROJ Response times across the City 5.20 seconds 90% 5.06 seconds 4.30 Seconds 4.30 seconds of time Reduce total fire losses >1 million >1 million 43 PROPOSED BUDGET FY 2023 100-GENERAL FUND FIRE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $4,685,748 $5,626,198 $5,626,198 $6,330,874 51112 SALARIES-PART TIME $4,160 $4,480 $4,480 $5,000 51113 BACKUP AMBULANCE $17,550 $22,000 $22,000 $22,000 51130 OVERTIME $708,820 $483,954 $483,953 $565,222 51135 FLSA OVERTIME $245,076 $417,868 $417,867 $454,198 51140 LONGEVITY PAY $26,344 $29,451 $29,451 $31,892 51160 CERTIFICATION INCENTIVE $64,607 $75,600 $75,600 $73,800 51170 PARAMEDIC INCENTIVE $104,671 $155,000 $155,000 $182,500 51310 TMRS $903,967 $1,054,222 $1,054,221 $1,185,050 51410 HOSPITAL AND LIFE INSURANCE $767,766 $845,463 $845,463 $1,017,272 51420 LONG-TERM DISABILITY $20,270 $30,318 $30,318 $24,198 51440 FICA $341,714 $421,932 $421,932 $474,331 51450 MEDICARE $80,122 $98,681 $98,681 $110,932 51470 WORKERS COMP PREMIUM $58,361 $110,586 $110,586 $104,914 51480 UNEMPLOYMENT COMP(TWC) $17,009 $19,440 $19,440 $21,870 TOTAL PERSONNEL SERVICES $8,046,184 $9,395,191 $9,395,190 $10,604,053 52010 OFFICE SUPPLIES $13,705 $15,725 $15,725 $15,700 52040 POSTAGE AND FREIGHT $16 $200 $200 $200 52070 COMPUTER SOFTWARE $5,124 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $245,775 $187,260 $132,415 $243,295 52210 JANITORIAL SUPPLIES $8,475 $14,000 $14,000 $15,000 52250 MEDICAL AND SURGICAL $35,177 $21,350 $21,350 $21,350 52310 FUEL AND LUBRICANTS $51,041 $102,500 $102,500 $72,100 52380 CHEMICALS $11,713 $17,200 $17,200 $18,750 52630 AUDIO-VISUAL $8,825 $14,400 $14,400 $15,200 52710 WEARING APPAREL AND UNIFORMS $197,778 $247,674 $234,060 $263,359 52740 DRY GOODS AND NOTIONS $0 $0 $0 $0 52810 FOOD SUPPLIES $11,286 $16,000 $16,000 $22,000 52990 OTHER $0 $1,600 $1,600 $1,600 TOTAL SUPPLIES $588,914 $637,909 $569,450 $688,554 54250 STREET SIGNS AND MARKINGS $0 $1,100 $1,100 $2,500 54510 MOTOR VEHICLES $100,932 $106,200 $96,806 $108,994 54530 HEAVY EQUIPMENT $85,832 $92,880 $92,880 $81,950 54610 FURNITURE AND FIXTURES $12,395 $13,500 $13,500 $15,500 54630 TOOLS AND EQUIPMENT $28,120 $36,050 $36,050 $40,150 54650 COMMUNICATIONS $7,096 $63,800 $63,800 $67,100 54810 COMPUTER HARD/SOFTWARE $17,604 $23,300 $23,300 $31,101 54910 BUILDINGS $146,252 $139,000 $114,000 $165,250 54990 OTHER $399 $8,450 $8,450 $8,000 TOTAL MATERIALS FOR MAINTENANCE $398,630 $484,280 $449,886 $520,545 56040 SPECIAL SERVICES $50,044 $80,845 $80,845 $69,660 56050 UNIFORM CONTRACT $0 $0 $0 $0 56060 AMBULANCE CONTRACT $178,641 $185,000 $175,000 $513,900 44 PROPOSED BUDGET FY 2023 100-GENERAL FUND FIRE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 56080 ADVERTISING $0 $0 $0 $0 56110 COMMUNICATIONS $6,469 $7,450 $7,250 $8,000 56150 LAB ANALYSIS $3,300 $0 $0 $0 56180 RENTAL $0 $1,500 $1,500 $1,500 56210 TRAVEL AND TRAINING $86,322 $99,115 $99,115 $99,766 56250 DUES AND SUBSCRIPTIONS $27,404 $29,197 $29,197 $36,647 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $352,181 $403,107 $392,907 $729,473 58510 MOTOR VEHICLES $40,985 $504,840 $133,215 $371,625 58810 COMPUTER HARD/SOFTWARE $19,920 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $133,888 $250,000 $6,875 $243,125 58910 BUILDINGS $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $194,793 $754,840 $140,090 $614,750 TOTAL FIRE $9,580,702 $11,675,327 $10,947,523 $13,157,375 45 CITY OF WYLIE EMERGENCY COMMUNICATIONS DEPARTMENT DESCRIPTION' The Emergency Communications Division is also known as Public Safety Communications(PSC). Funding is derived from 9- 1-1 fees,alarm fees, intergovernmental grants,interest income,and support from the General Fund.Wylie PSC is only one (1)of four(4)Texas cities providing Direct Alarm Monitoring, removing time from every alarm response. Fire/EMS dispatch is also provided to neighboring agencies to quicken their response to Wylie when needed and for revenue.All dispatchers are licensed Telecommunicators through the Texas Commission of Law Enforcement(TCOLE)as well as certified Emergency Medical Dispatchers. We the members of the Wylie Fire Rescue place safety as our first priority. Take pride in meeting and exceeding the expectations of our community. Encourage innovation and apply technologies that advance the quality of our life and fire service. Encourage and respect open honesty, honest communication, mutual trust and respect for each other. Recognize and value the benefits and the diversity of every individual background and experience. Commit to the professional development of individual members as an investment in the future of our organization. Depend upon teamwork,with our individual and division working together to ensure our success. FISCAL YEAR 2023 GOALS AND OBJECTIVES' PSAP Supervisor to attain Emergency Number Profession (ENP)credential. Strategic Goal:Workforce Implementation of an upgraded alarm system that will directly insert alarm information into CAD,further reducing response times. Strategic Goal: Infrastructure Send two additional telecommunicators to participate in a week-long intensive leadership conference through the Dispatcher 360 program. Strategic Goal:Workforce All telecommunicators obtain NENA Excellence in Dispatch Certifications. Strategic Goal:Workforce Establish a 9-1-1 Public Education teaching forum to utilize in educating the public. Strategic Goal:Community Focused Government FISCAL YEAR 2022 ACCOMPLISHMENTS Established the sixth (6th)fully functioning CAD station,which includes the phone system, Motorola Radio System,and CAD License. Strategic Goal: Infrastructure Added one(1) VESTA phone system,giving the dispatch center a total of six(6)fully functioning CAD stations and one backup station at CAD station seven(7). Strategic Goal:Workforce Established a stable backup dispatch site with the construction of Wylie Fire Station Four to ensure continuity of services. Strategic Goal: Infrastructure Certifications achieved by current personnel: One(1) Dispatcher received their Communications Training Officer(CTO)certification. One(1)dispatcher attained her EMD-Q Certification, increasing our quality assurance personnel for EMD to a total of four. Both Supervisors obtained NENA Center Manager Certification Manager obtained NENA Excellence in Dispatch Certificate Strategic Goal:Workforce 46 EMERGENCY COMMUNICATIONS CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Communications Manager 1.0 1.0 1.0 1.0 Assistant Communications Manager 0.0 0.0 1.0 1.0 Communications Supervisor 2.0 2.0 2.0 2.0 Dispatcher 11.0 12.0 12.0 12.0 TOTAL 14.0 15.0 16.0 16.0 ACTIVITY DEMAND J ACTIVITY WORKLOAD MEASURE BENCHMARK FY 2022 FY 2023 TARGET/PROJ TARGETJPROJ Answer percentage of 9-1-1 calls within ten seconds 90 percent within 10 seconds 99.70 99.70 Maintain an average EMD score within EMD recommended Average Score of 8 or above 8.54 8.60 Complaint range Employees have an adequate receive to queue time. Under 1 minute 0.39 0.39 Employees have an adequate queue to dispatch time. 1 minute or less 1.06 0.59 EFFICIENCY J EFFECTIVENESS MEASURE BENCHMARK FY 2022 FY 2023 TARGETJPROJ TARGETJPROJ Employees collectively achieve at least 500 TCOLE training hours 500 500 per year. 47 PROPOSED BUDGET FY 2023 100-GENERAL FUND EMERGENCY COMMUNICATIONS FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $657,460 $896,772 $896,772 $977,925 51112 SALARIES-PART TIME $0 $0 $0 $0 51130 OVERTIME $52,924 $72,421 $72,421 $72,421 51135 FLSA OVERTIME $79,583 $110,597 $110,597 $116,619 51140 LONGEVITY PAY $4,436 $5,118 $5,118 $5,630 51160 CERTIFICATION INCENTIVE $17,578 $23,400 $23,400 $25,200 51310 TMRS $125,521 $170,885 $170,885 $185,658 51410 HOSPITAL AND LIFE INSURANCE $138,942 $159,299 $159,299 $174,644 51420 LONG-TERM DISABILITY $2,969 $4,056 $4,056 $3,618 51440 FICA $48,662 $65,944 $65,944 $74,263 51450 MEDICARE $11,401 $15,423 $15,423 $17,368 51470 WORKERS COMP PREMIUM $1,401 $1,168 $1,167 $2,348 51480 UNEMPLOYMENT COMP(TWC) $4,040 $4,050 $4,050 $4,320 TOTAL PERSONNEL SERVICES $1,144,917 $1,529,132 $1,529,132 $1,660,014 52010 OFFICE SUPPLIES $2,458 $6,590 $6,590 $6,700 52130 TOOLS/EQUIP(NON-CAPITAL) $6,003 $13,550 $12,525 $14,575 52310 FUEL AND LUBRICANTS $513 $2,700 $2,700 $2,200 52630 AUDIO-VISUAL $903 $2,000 $2,000 $2,500 52710 WEARING APPAREL AND UNIFORMS $909 $6,000 $6,000 $6,800 52810 FOOD SUPPLIES $1,046 $2,000 $2,000 $2,500 TOTAL SUPPLIES $11,832 $32,840 $31,815 $35,275 54510 MOTOR VEHICLES $1,810 $1,850 $1,850 $1,850 54530 HEAVY EQUIPMENT $8,400 $8,500 $8,500 $8,000 54610 FURNITURE AND FIXTURES $421 $500 $500 $500 54630 TOOLS AND EQUIPMENT $109 $500 $500 $500 54650 COMMUNICATIONS $148,529 $208,347 $208,347 $215,442 54810 COMPUTER HARD/SOFTWARE $62,530 $75,929 $75,929 $82,364 TOTAL MATERIALS FOR MAINTENANCE $221,799 $295,626 $295,626 $308,656 56040 SPECIAL SERVICES $141,957 $156,608 $156,608 $157,816 56110 COMMUNICATIONS $54,638 $60,900 $60,900 $60,900 56120 911-EMERGENCY SERVICES $140,762 $156,047 $156,047 $156,047 56180 RENTAL $8,811 $0 $0 $0 56210 TRAVEL AND TRAINING $10,679 $18,136 $18,136 $15,138 56250 DUES AND SUBSCRIPTIONS $1,716 $2,511 $2,511 $2,638 TOTAL CONTRACTURAL SERVICES $358,563 $394,202 $394,202 $392,539 TOTAL EMERGENCY COMMUNICATIONS $1,737,111 $2,251,800 $2,250,775 $2,396,484 48 CITY OF WYLIE ANIMAL SERVICES DEPARTMENT DESCRIPTION Animal Services is a division of the Police Department.The division's primary function is to safeguard the public's health and safety and ensure responsible pet ownership. Responsibilities include responsive action, investigation,and enforcement of all local,state,and federal laws pertaining to animals within its jurisdiction. Its mission is to provide a safe, maintained,clean and compassionate environment for all animals sheltered in their care.They will foster and support a coordinated approach with residents, rescue organizations,and wildlife rehabilitators to achieve positive outcomes for as many animals in the community as possible. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue to provide our community with a licensed state quarantine facility compliant with all state law regulations. Strategic Goals: Health,Safety,and Well-Being,Workforce, Infrastructure Continue to achieve high positive outcome rates while balancing resources,community safety,and expectations effectively. Strategic Goals:Community-Focused Government,Workforce Reopen volunteer,community service,and community assistance programs through actively seeking,training,and state certifying animal services officers. Strategic Goals: Community-Focused Government, Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS The Texas Department of State Health Services and annual veterinary facility inspections were positive in all areas without infractions. Strategic Goals: Health,Safety,and Well-Being,Workforce, Infrastructure Accomplished an above ninety-five percent positive outcome rate for 2021. Strategic Goals:Workforce,Community-Focused Government Improved workflow efficiency of shelter operations through the implementation of online pet licensing. Strategic Goals:Workforce, Infrastructure,Community Focused Government Improved workflow efficiency of field services through a complete revision of Chapter 18 Animal Ordinances.Complying with state and federal laws,department standards, community expectations,and proactively addressing future law changes. Strategic Goals:Workforce, Infrastructure BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Animal Control Manager 1.0 1.0 1.0 1.0 Lead Animal Control Officer 1.0 1.0 1.0 1.0 Animal Control Officer 4.0 4.0 5.0 5.0 Kennel Attendant 0.5 0.5 0.5 0.5 Administrative Assistant 1.0 1.0 0.0 0.0 TOTAL 7.5 7.5 7.5 7.5 49 ANIMAL SERVICES CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE BENCHMARK FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROD TARGET/PROJ Pet Data Pet Licensing 3%Increase 1183 1043(12% 856 Projection 882(3%increase) decrease) (18%decrease) Calls for Service(CFS) 3%Increase 2226 1641(26% 1690(3% 1741(3% decrease) increase) increase) Positive Outcome of Domestic Impounded 90%Live Outcome 97.08% 95.89%(1.19% 96%Projection 90%Target Animals decrease) (.11%increase) 50 PROPOSED BUDGET FY 2023 100-GENERAL FUND ANIMAL CONTROL FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $224,675 $284,907 $284,907 $341,786 51112 SALARIES-PART TIME $11,375 $12,495 $12,495 $13,545 51130 OVERTIME $20,106 $28,552 $28,552 $33,782 51140 LONGEVITY PAY $1,424 $1,757 $1,757 $1,997 51310 TMRS $37,993 $48,859 $48,859 $58,523 51410 HOSPITAL AND LIFE INSURANCE $40,974 $63,653 $63,653 $75,835 51420 LONG-TERM DISABILITY $994 $1,743 $1,743 $1,265 51440 FICA $15,367 $20,351 $20,351 $24,249 51450 MEDICARE $3,594 $4,720 $4,720 $5,671 51470 WORKERS COMP PREMIUM $4,982 $6,291 $6,291 $6,987 51480 UNEMPLOYMENT COMP(TWC) $1,505 $2,160 $2,160 $2,160 TOTAL PERSONNEL SERVICES $362,988 $475,488 $475,488 $565,800 52010 OFFICE SUPPLIES $4,208 $5,760 $5,760 $5,730 52040 POSTAGE AND FREIGHT $345 $700 $700 $700 52070 COMPUTER SOFTWARE $0 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $7,296 $12,145 $12,145 $10,595 52210 JANITORIAL SUPPLIES $1,530 $3,275 $3,275 $3,275 52250 MEDICAL AND SURGICAL $16,774 $30,320 $30,320 $30,320 52310 FUEL AND LUBRICANTS $3,994 $4,534 $4,534 $13,500 52380 CHEMICALS $2,064 $3,180 $3,180 $3,180 52710 WEARING APPAREL AND UNIFORMS $2,354 $5,405 $5,405 $5,015 52810 FOOD SUPPLIES $463 $975 $975 $975 52990 OTHER $2,423 $4,000 $4,000 $4,000 TOTAL SUPPLIES $41,450 $70,294 $70,294 $77,290 54510 MOTOR VEHICLES $0 $1,500 $1,500 $1,500 54630 TOOLS AND EQUIPMENT $1,863 $3,000 $3,000 $3,000 54650 COMMUNICATIONS $308 $350 $350 $350 TOTAL MATERIALS FOR MAINTENANCE $2,171 $4,850 $4,850 $4,850 56040 SPECIAL SERVICES $3,366 $2,450 $2,450 $9,650 56150 LAB ANALYSIS $139 $600 $600 $600 56210 TRAVEL AND TRAINING $1,258 $5,385 $5,385 $7,059 56250 DUES AND SUBSCRIPTIONS $0 $0 $0 $0 56680 TRASH DISPOSAL $0 $200 $200 $200 TOTAL CONTRACTURAL SERVICES $4,763 $8,635 $8,635 $17,509 58910 BUILDINGS $24,412 $0 $0 $58,000 TOTAL CAPITAL OUTLAY $24,412 $0 $0 $58,000 TOTAL ANIMAL CONTROL $435,784 $559,267 $559,267 $723,449 51 CITY OF WYLIE PLANNING DEPARTMENT DESCRIPTION The mission of the Planning Department is to preserve and enhance community quality of life; promote responsible commercial and residential development;encourage re-development for economic vitality,diversity,and equity;and responsibly deliver public services. The Planning Department is responsible for administration of the Planning and Zoning Commission,the Zoning Board of Adjustment,the Historic Review Commission,and the Impact Fee Advisory Committee. It is responsible for the processing and reviewing of requests for changes in zoning, land platting,and commercial site plans.The Planning Department is also responsible for maintaining and recommending updates to the Comprehensive Plan,Zoning Ordinance,and Subdivision Regulations.Additionally,the department performs demographic analysis and other development-related research. FISCAL YEAR 2023 GOALS AND OBJECTIVES Publish an amended Zoning Ordinance that includes website designs and components Strategic Goal: Planning Management Begin preliminary work on Subdivision Regulations amendments for 2023-24 updates. Strategic Goal: Planning Management Coordinate with GIS to provide improved planning related mapping Strategic Goal:Community Focused Government Expand various planning and demographic information and analysis Strategic Goal: Planning Management Begin implementing goals and strategies from the updated Comp Plan Strategic Goal: Health,Safety,and Well-being and Planning Management. FISCAL YEAR 2022 ACCOMPLISHMENTS Completed an updated Comprehensive Master Plan Strategic Goal: Planning Management Analysis of 2020 Census Strategic Goals: Planning Management,Community Focused Government Established Historical Landmark Program Strategic Goal: Planning Management BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Community Development Director 0.0 0.0 0.0 1.0 Planning Manager 1.0 1.0 1.0 0.0 Senior Planner 1.0 1.0 1.0 1.0 Administrative Assistant II 1.0 1.0 1.0 1.0 TOTAL 3.0 3.0 3.0 3.0 52 PLANNING CONTINUED ACTIVITY DEMAND J ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 ACTUAL ACTUAL TARGET/PROD Zoning Cases(FY 22-May YTD) 12 22 24 Historic Review Commission cases 5 3 4 Site Plans 20 15 23 Plats 31 37 42 Zoning Board of Adjustments variance requests 11 17 10 53 PROPOSED BUDGET FY 2023 100-GENERAL FUND PLANNING FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $207,802 $216,458 $216,458 $247,707 51130 OVERTIME $0 $0 $0 $0 51140 LONGEVITY PAY $1,844 $1,985 $1,985 $2,129 51310 TMRS $32,474 $33,858 $33,858 $38,724 51410 HOSPITAL AND LIFE INSURANCE $26,305 $28,398 $28,398 $32,360 51420 LONG-TERM DISABILITY $921 $1,188 $1,188 $917 51440 FICA $12,761 $13,544 $13,544 $15,490 51450 MEDICARE $2,984 $3,168 $3,168 $3,623 51470 WORKERS COMP PREMIUM $864 $274 $274 $287 51480 UNEMPLOYMENT COMP(TWC) $756 $810 $810 $810 TOTAL PERSONNEL SERVICES $286,711 $299,683 $299,683 $342,047 52010 OFFICE SUPPLIES $606 $1,500 $1,500 $1,650 52810 FOOD SUPPLIES $165 $275 $275 $300 TOTAL SUPPLIES $770 $1,775 $1,775 $1,950 56040 SPECIAL SERVICES $52 $14,000 $14,000 $5,500 56080 ADVERTISING $4,916 $6,000 $6,000 $6,000 56210 TRAVEL AND TRAINING $2,233 $8,250 $8,250 $11,300 56250 DUES AND SUBSCRIPTIONS $635 $1,200 $1,200 $1,500 TOTAL CONTRACTURAL SERVICES $7,836 $29,450 $29,450 $24,300 TOTAL PLANNING $295,316 $330,908 $330,908 $368,297 54 CITY OF WYLIE BUILDING INSPECTIONS ORGUNIT DESCRIPTION The mission of the Building Inspections Department is to provide for the health,safety,and welfare of the citizens, business owners and visitors to our city thorough knowledge and exceptional service pertaining to the building,electrical, plumbing, mechanical,and energy code regulations which supports our commitment to the safety of the citizens and to the integrity of the department.Our commitment starts at the front counter and continues through the plan review stage then throughout the field inspection stage to assure compliance with the city's codes and ordinances. This Organizational Unit contains the City of Wylie Building Inspections department.The department performs 4 essential functions. 1. Permit administration and records retention 2. Plan Review 3. Field Inspections 4. Issuance and maintenance of Certificates of Occupancy FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue with the selection process and implementation of software to replace outgoing IMPACT software.The new software will have a true customer portal and will operate on a multi-departmental platform, providing for more efficient operations and service. Strategic Goal:Community Focused Government Continue to amass additional certifications,which is ongoing from year to year. Strategic Goal:Workforce Electronic document storage/retention. Strategic Goals: Infrastructure,Workforce Adopt updated Editions of all ICC codes in preparation for ISO audit. Strategic Goal:Community Focused Government FISCAL YEAR 2022 ACCOMPLISHMENTS Permits Issued (estimated total for September 30 2022) Single-Family Detached 395 Single-Family Attached 168 Finished Commercial Buildings 15 Commercial Tenant Finish-out 20 Commercial Re-model 30 Commercial Shell Building 5 Accessory/Storage Building 175 Certificates of Occupancy 100 Concrete 58 Fence 591 Irrigation 335 Foundation Repair 127 Patio Cover 148 Plumbing-Water Heaters and Sewer Repairs 588 Signs 132 Swimming Pools 46 Signs 147 Strategic Goal: Health,Safety and Well-Being Adopted the 2021 International Codes with North Central Texas Council of Government amendments and the 2020 National Electrical Code. 55 BUILDING INSPECTIONS CONTINUED Strategic Goal:Workforce Added approximately 25 ICC certifications,with one inspector obtaining Master Code Professional status. Strategic Goal:Workforce Department moved up one step in ISO rating from the last evaluation four years ago. Strategic Goal:Community Focused Government Added the fifth Texas Plumbing Inspector license to the department,after only having two for several years. Strategic Goal:Workforce Implemented MyGov Building Inspections software,which allows for mostly electronic permitting, plan review,contractor registration and inspections. Most applicants now apply and monitor their permit applications from their office or home, but the department offers two kiosk workstations if in-person business is desired. Strategic Goal:Community Focused Government. Conducted permit fee schedule study and adopted new permit fees which is generating a great deal more revenue than last year, particularly on single-family permits. Moved from a combination fee schedule with a set amount plus square footage to a total square footage based system. Maintained Wylie's fees to be competitive with surrounding municipalities. Strategic Goal: Infrastructure BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Chief Building Official 1.0 1.0 1.0 1.0 Plans Examiner 1.0 1.0 1.0 1.0 Building Inspector 3.0 3.0 3.0 3.0 Permit Technician 1.0 1.0 1.0 1.0 TOTAL 6.0 6.0 6.0 6.0 ACTIVITY DEMAND J ACTIVITY WORKLOAD MEASURE FY 2022 FY 2022 FY 2023 TARGETJPROJ ESTIMATE TARGETJPROJ Turnaround single family permits in 7 business days from time of 7 days 7 days submission. Research remote virtual inspection technology. Partial implementation calendar 2022 Work with IT to close all permit data from the IMPACT database system and End of FY 22-23 backup data so the IMPACT server can be shut down.Goal will be the end of FY 22-23. 56 PROPOSED BUDGET FY 2023 100-GENERAL FUND BUILDING INSPECTIONS FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $367,521 $382,426 $382,426 $372,861 51130 OVERTIME $10,219 $6,100 $6,100 $6,222 51140 LONGEVITY PAY $916 $1,185 $1,185 $1,473 51310 TMRS $59,150 $60,405 $60,405 $58,986 51410 HOSPITAL AND LIFE INSURANCE $81,572 $67,166 $67,166 $74,172 51420 LONG-TERM DISABILITY $1,766 $2,096 $2,096 $1,380 51440 FICA $21,930 $24,163 $24,163 $23,594 51450 MEDICARE $5,129 $5,651 $5,651 $5,518 51470 WORKERS COMP PREMIUM $822 $1,030 $1,030 $872 51480 UNEMPLOYMENT COMP(TWC) $1,512 $1,620 $1,620 $1,620 TOTAL PERSONNEL SERVICES $550,536 $551,841 $551,842 $546,698 52010 OFFICE SUPPLIES $3,791 $4,700 $4,700 $4,794 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $850 $850 $885 52310 FUEL AND LUBRICANTS $4,495 $4,818 $4,818 $13,500 52710 WEARING APPAREL AND UNIFORMS $1,673 $2,100 $2,100 $2,142 52810 FOOD SUPPLIES $32 $500 $500 $500 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $9,991 $12,968 $12,968 $21,821 56040 SPECIAL SERVICES $0 $10,000 $10,000 $10,000 56110 COMMUNICATIONS $3,459 $2,520 $2,520 $3,888 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $5,326 $8,000 $8,000 $8,160 56250 DUES AND SUBSCRIPTIONS $1,534 $3,300 $3,300 $3,366 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $10,320 $23,820 $23,820 $25,414 TOTAL BUILDING INSPECTIONS $570,847 $588,629 $588,630 $593,933 57 CITY OF WYLIE CODE ENFORCEMENT DEPARTMENT DESCRIPTION The Code Enforcement department's mission is to make the city a safer and cleaner place to live,work,and play through a cooperative effort between the city and its citizens.We strive to provide prom,courteous,and professional service.The department works to educate the community in order to gain willing compliance and encourage responsible property maintenance.The department also helps maintain property values and a strong tax base.This goal is accomplished by conducting inspections of residential and commercial properties to ensure proper maintenance and compliance of minimum standards. FISCAL YEAR 2023 GOALS AND OBJECTIVES Educate our community so we do not increase violation notices. Strategic Goal:Community Focused Government Continue to attend training for Code Enforcement along with attending meetings on all updated laws and requirements. Strategic Goal:Workforce Due to growth over the past years,the officers strive to continue an active amount of proactive inspections in an attempt to improve curbside appeal in our communities. Strategic Goal:Community Focused Government Continue to conduct research on all vacant homes that appear to be under construction to ensure the proper permits are obtained for remodeling homes. Strategic Goal:Community Focused Government Continue to attend training with the Building Professional Institute and assisting the Building Officials Association of Texas with disaster assessments as needed. Strategic Goals:Community Focused Government;Workforce FISCAL YEAR 2022 ACCOMPLISHMENTS Researched and reviewed Code Enforcement software packages in hopes to obtain a system that would assist the officers in being more efficient. Strategic Goals:Workforce Assisted Building Inspection in implementing and entering data into the new MyGov Software for Building Inspection and Permitting. Strategic Goals:Workforce Adjusted inspection techniques due to the real estate market changing. Identified multiple homes with construction projects that were not permitted. Strategic Goal:Community Focused Government BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Code Enforcement Officer 2.0 2.0 2.0 2.0 Permit Technician 1.0 1.0 1.0 1.0 TOTAL 3.0 3.0 3.0 3.0 58 CODE ENFORCEMENT CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2021 FY 2022 FY 2023 ACTUAL TARGET/PROJ TARGET/PROJ Non-Compliance Notifications-First Notice of Violation 1,080 2,250 2,400 Public Nuisance 530 567 Final Notices-Second Notice of Violation 500 535 Blocked Sidewalk 53 56 Closed Cases 2,675 2,862 High Grass and Weeds 547 785 840 Bulk and Debris 425 480 514 Address Numbers 165 176 Trees/Vegetation in Public Right of Way 100 107 Junk Vehicle 60 64 Fence Maintenance 70 75 Off-Street Parking 95 100 EFFICIENCY/EFFECTIVENESS MEASURE FY 2022 FY 2023 TARGET/PROJ TARGET/PROJ Code Enforcement will conduct research of the law as to help with the enforcement of repeat FY 22-23 violations. At the current time,we have the minimum state law,stating,a notice must be given for a violation and the owner/occupant will have seven days to correct the violation. If the person corrects the violation the case is closed.If the same violation occurs again,the process starts over. Code Enforcement is conducting research to change the ordinances to help with repeat offenders.With the new ordinance only one notice will be given for the same violation within the sixth month time frame. If the same violation reoccurs within a sixth month time frame a notice of violation will not be required and enforcement actions may take place. Review other municipalities regulations regarding notice of violations for accumulation of FY 22-23 outside storage.Current ordinance language is weak in this area. 59 PROPOSED BUDGET FY 2023 100-GENERAL FUND CODE ENFORCEMENT FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $154,755 $159,178 $159,178 $166,982 51130 OVERTIME $0 $3,068 $3,068 $3,130 51140 LONGEVITY PAY $1,300 $1,437 $1,437 $1,580 51310 TMRS $24,327 $25,371 $25,371 $26,612 51410 HOSPITAL AND LIFE INSURANCE $17,417 $17,253 $17,253 $19,763 51420 LONG-TERM DISABILITY $692 $880 $880 $618 51440 FICA $9,318 $10,149 $10,149 $10,645 51450 MEDICARE $2,179 $2,374 $2,374 $2,490 51470 WORKERS COMP PREMIUM $304 $296 $296 $272 51480 UNEMPLOYMENT COMP(TWC) $756 $810 $810 $810 TOTAL PERSONNEL SERVICES $211,048 $220,815 $220,816 $232,902 52010 OFFICE SUPPLIES $1,258 $1,260 $1,260 $1,285 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $300 $300 $306 52310 FUEL AND LUBRICANTS $351 $2,514 $2,514 $5,400 52710 WEARING APPAREL AND UNIFORMS $1,137 $1,500 $1,500 $1,734 52810 FOOD SUPPLIES $0 $150 $150 $153 TOTAL SUPPLIES $2,746 $5,724 $5,724 $8,878 54630 TOOLS AND EQUIPMENT $0 $200 $200 $204 54650 COMMUNICATIONS $205 $1,440 $1,440 $0 TOTAL MATERIALS FOR MAINTENANCE $205 $1,640 $1,640 $204 56040 SPECIAL SERVICES $0 $10,000 $10,000 $10,200 56080 ADVERTISING $0 $1,000 $1,000 $1,000 56110 COMMUNICATIONS $2,285 $2,880 $2,880 $2,904 56210 TRAVEL AND TRAINING $375 $2,800 $2,800 $2,856 56250 DUES AND SUBSCRIPTIONS $150 $560 $560 $571 56530 COURT AND LEGAL COSTS $1,140 $5,000 $5,000 $5,100 56810 MOWING SERVICES $1,725 $12,000 $12,000 $12,240 TOTAL CONTRACTURAL SERVICES $5,675 $34,240 $34,240 $34,871 TOTAL CODE ENFORCEMENT $219,673 $262,419 $262,420 $276,855 60 CITY OF WYLIE STREETS [DEPARTMENT DEPARTMENT DESCRIPTION The Streets Department comprises four divisions;Street Maintenance,Stormwater,Signs and Signals,and Fleet Services. These 21 employees are responsible for maintaining approximately 270 miles of streets and alleys,sidewalks throughout the city,200 miles of Stormwater conveyance,26 traffic signal intersections,95 School Zone lights,street signs and roadway markings within city limits,and approximately 160 city vehicles. In addition,the Streets division picks up trash,trims weeds, brush,and trees in public rights-of-ways,and performs mosquito surveillance and fogging. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue mosquito surveillance and control throughout the City for mosquito-borne disease. Strategic Goal: Health,Safety,and Well-Being Continue GIS mapping of regulatory street signs and stormwater infrastructure. Strategic Goal: Health,Safety,and Well-Being Maintain all facets of the traffic signal network for motorists and pedestrians. Strategic Goal: Infrastructure Continue stormwater infrastructure maintenance city-wide,including clearing, repairing,and replacing pipe,culverts, inlets, and channels. Strategic Goal: Health,Safety,and Well-Being Complete and submit the Annual Storm Water Report to TCEQ. Strategic Goal: Health,Safety,and Well-Being Continue installation and repair of street signs, markings,and striping for school zones,crosswalk areas, lane line delineations,and road closings. Strategic Goal: Health,Safety,and Well-Being Continue severe weather event emergency response for flooding,snow,and ice, including street sanding, potable water protection,and high water barricading. Strategic Goal: Health,Safety,and Well-Being Continue asphalt and concrete repairs as needed to streets,alleys,curbs,and gutters. Strategic Goal: Infrastructure Continue repairing and installing sidewalk panels city-wide as needed. Strategic Goal: Infrastructure Continue asphalt overlay on city streets. Strategic Goal: Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS Completed annual mosquito surveillance and control throughout the City for mosquito-borne disease. Strategic Goal: Health,Safety,and Well-Being Continued replacement of street name and regulatory signs that fail to meet visibility safety standards. Strategic Goal: Health,Safety,and Well-Being Maintained all facets of the traffic signal network for motorists and pedestrians, including coordination with TxDOT to maintain State on-system intersections. Strategic Goal: Health,Safety,and Well-Being STREETS DEPARTMENT CONTINUED Corrected deficiencies found in our railroad quiet zones throughout the city to maintain no train horn usage through these crossings. Strategic goal: Health,Safety,and Well-being Performed stormwater infrastructure maintenance city-wide, including clearing,repairing,and replacing pipe,culverts, inlets,and channels. Strategic Goal: Health,Safety,and Well-Being Completed and submitted the Annual Storm Water Report to TCEQ. Strategic Goal: Health,Safety,and Well-Being Performed annual installation and repair of street signs, markings,and striping for school zones,crosswalk areas,lanes line delineations,and road closings. Strategic Goal: Health,Safety,and Well-Being Responded to the February Winter Storm, including sanding roadways and assisting with customer water issues. Strategic Goal: Health,Safety,and Well-Being Performed asphalt and concrete street repairs as needed to streets,alleys,curbs,and gutters. Strategic Goal: Infrastructure Continued program to repair and install sidewalk panels and handicap ramps city-wide as requested or needed. Strategic Goal: Infrastructure Overlaid approximately 2.5 miles of roadway with new asphalt. Strategic Goal: Infrastructure Repaired 15 locations of street settlements that were holding water. Strategic Goal: Infrastructure Filled approximately 210 potholes on asphalt and concrete streets city-wide. Strategic Goal: Infrastructure Performed routine maintenance on 26 traffic lights city-wide. Strategic Goal: Infrastructure Cleaned drainage ditches on Jefferson, Keefer,and Marble Strategic Goal: Infrastructure Completed approximately 40 inhouse sidewalk rehabilitation projects Strategic Goal: Infrastructure Replaced failing drainage headwall on Foxwood Ln. Strategic Goal: Infrastructure 62 STREETS DEPARTMENT CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Public Works Superintendent 1.0 1.0 0.0 0.0 Streets Manager 0.0 0.0 1.0 1.0 Streets Supervisor 1.0 1.0 0.0 0.0 Crew Leader 4.0 4.0 4.0 4.0 Fleet Maintenance Coordinator 1.0 1.0 1.0 1.0 Equipment Operator 2.0 2.0 3.0 3.0 Lead Signal Technician 0.0 0.0 1.0 1.0 Maintenance Worker II 4.0 4.0 4.0 4.0 Maintenance Worker 6.0 7.0 7.0 7.0 TOTAL 19.00 20.00 21.00 21.00 ACTIVITY DEMAND f ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 ACTUAL ACTUAL TARGET/PROJ STREET DIVISION 308 286 290 Potholes filled on asphalt&concrete roadways during the fiscal year SIGNS&SIGNALS DIVISION 85 45 Amount of total work orders completed and closed during the fiscal year. STORMWATER DIVISION 27 49 Inspection of the stormwater outfall system MS4 in various subdivisions during the reporting period. STREET DIVISION 123 91 The number of sidewalk requests that were completed and closed out during the fiscal year. SIGNS&SIGNALS DIVISION 10 26 26 The total number of traffic signals maintained by the City Of Wylie. EFFICIENCY/EFFECTIVENESS MEASURE BENCHMARK FY 2020 FY 2021 FY 2022 ACTUAL ACTUAL " TARGET/PROJ POT-HOLE COMPLAINTS:Survey and repair(fill)damaged area within same day 36 hour 24 hour 24 hour 24 hrs.of receiving notification of repair needed. response response response response or sooner CDL license Class A:Continuation of training new employees to 6 months 75% 90%employees obtain CDL license within 6 months of hire-in. employees certified certified Sidewalk Complaints:Assess,meet with the resident, and schedule Within 24 hours 36 hours 24 hours within 24 hours replacement if needed. Address deficiencies in streets,sidewalks,pavement markings,and 100% stormwater in Zone 1 of the Public Works Map 63 PROPOSED BUDGET FY 2023 100-GENERAL FUND STREETS FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $819,697 $856,083 $856,083 $951,704 51130 OVERTIME $38,521 $26,300 $26,300 $28,110 51140 LONGEVITY PAY $6,296 $7,187 $7,187 $5,016 51310 TMRS $134,437 $136,597 $136,597 $152,649 51410 HOSPITAL AND LIFE INSURANCE $185,968 $231,690 $231,690 $215,788 51420 LONG-TERM DISABILITY $4,215 $5,141 $5,141 $3,521 51440 FICA $50,108 $54,639 $54,639 $61,059 51450 MEDICARE $11,719 $12,778 $12,778 $14,280 51470 WORKERS COMP PREMIUM $17,453 $21,115 $21,115 $21,012 51480 UNEMPLOYMENT COMP(TWC) $5,918 $5,940 $5,940 $5,670 TOTAL PERSONNEL SERVICES $1,274,331 $1,357,470 $1,357,470 $1,458,809 52010 OFFICE SUPPLIES $345 $80 $80 $80 52040 POSTAGE AND FREIGHT $125 $250 $250 $250 52130 TOOLS/EQUIP(NON-CAPITAL) $11,436 $26,050 $26,050 $23,950 52250 MEDICAL AND SURGICAL $0 $500 $500 $500 52310 FUEL AND LUBRICANTS $22,976 $30,000 $30,000 $41,870 52380 CHEMICALS $2,798 $3,000 $3,000 $3,000 52510 BOTANICAL AND AGRICULTURAL $1,291 $1,500 $1,500 $2,000 52710 WEARING APPAREL AND UNIFORMS $6,631 $18,220 $18,220 $18,100 52810 FOOD SUPPLIES $1,946 $2,100 $2,100 $2,000 TOTAL SUPPLIES $47,549 $81,700 $81,700 $91,750 54210 STREETS AND ALLEYS $1,274,528 $1,590,550 $1,811,299 $2,146,656 54220 SIDEWALKS $0 $200,000 $200,000 $200,000 54230 DRAINAGE $0 $180,000 $180,000 $150,000 54250 STREET SIGNS AND MARKINGS $156,765 $168,070 $148,070 $187,500 54530 HEAVY EQUIPMENT $35,596 $35,000 $35,000 $40,000 54630 TOOLS AND EQUIPMENT $2,768 $2,500 $2,500 $2,500 54990 OTHER $0 $776,705 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $1,469,657 $2,952,825 $2,376,869 $2,726,656 56040 SPECIAL SERVICES $20,716 $202,000 $202,000 $93,500 56110 COMMUNICATIONS $20,629 $19,380 $19,380 $18,000 56150 LAB ANALYSIS $0 $1,000 $1,000 $1,000 56180 RENTAL $3,068 $12,000 $12,000 $12,000 56210 TRAVEL AND TRAINING $3,185 $14,000 $14,000 $16,200 56250 DUES AND SUBSCRIPTIONS $4,661 $4,460 $4,460 $4,460 56570 ENGINEERING/ARCHITECTURAL $82,059 $212,903 $143,109 $59,794 56680 TRASH DISPOSAL $425 $1,000 $1,000 $1,000 TOTAL CONTRACTURAL SERVICES $134,742 $466,743 $396,949 $205,954 58220 STREET LIGHTS $0 $0 $0 $350,000 58510 MOTOR VEHICLES $0 $125,000 $33,470 $193,530 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $60,000 58810 COMPUTER HARD/SOFTWARE $0 $46,000 $0 $46,000 58850 MAJOR TOOLS AND EQUIPMENT $0 $39,000 $18,353 $127,147 TOTAL CAPITAL OUTLAY $0 $210,000 $51,823 $776,677 TOTAL STREETS $2,926,280 $5,068,738 $4,264,811 $5,259,846 64 CITY OF WYLIE PARKS DEPARTMENT DEPARTMENT DESCRIPTION The Parks division of the Parks and Recreation Department is responsible for the development and maintenance of parks, landscaped roadway areas,and other public rights of way; including areas located on S. Highway 78, FM 544,and all City facilities. The Department receives supplemental funding from the 4B Sales Tax Revenue Fund found in 4B Parks.Our mission is to spark connection with self,family,and community through meaningful park and recreation experiences. FISCAL YEAR 2023 GOALS AND OBJECTIVES Maintain the quality of maintenance to the City's parks,open spaces, playgrounds,and athletic fields. Strategic Goal: Health,Safety,and Well-Being Continue working with local sports associations on field and infrastructure improvements. Strategic Goal: Planning Management Expand on several park improvements by replacing aging equipment and adding additional staff. Strategic Goal: Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS Renewed Tree City USA designation for the 9th consecutive year. Strategic Goal:Community Focused Government Continued quality maintenance to the City's parks,open spaces, playgrounds,and athletic fields. Strategic Goal: Health,Safety,and Well-Being Replaced several aging pieces of equipment(Tennis Court Light Poles at Founders Park,added a few bobcat skid steer attachments). Strategic Goal: Infrastructure Added four new wireless irrigation controllers to the parks for a total of twenty one. This helps Irrigation Tech with troubleshooting the systems while away from the designated park. Strategic Goal: Infrastructure Completed the installation of card reader access to the Parks Administration Building. Strategic Goal: Health,Safety,and Well-Being 65 PARKS DEPARTMENT CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Parks & Recreation Director 1.0 1.0 1.0 1.0 Assistant Parks and Recreation Director 0.0 0.0 0.0 1.0 Parks Manager 1.0 1.0 1.0 0.0 Parks Supervisor 1.0 1.0 1.0 2.0 Crew Leader 1.0 1.0 1.0 0.0 Lead Chemical Applicator 2.0 2.0 2.0 2.0 Equipment Operator 1 1.0 1.0 1.0 7.0 Equipment Operator II 0.0 0.0 0.0 2.0 Irrigation Technician 1.0 1.0 1.0 1.0 Maintenance Worker 11 2.0 2.0 2.0 0.0 Maintenance Worker 6.0 6.0 6.0 0.0 Administrative Assistant II 1.0 1.0 1.0 1.0 Seasonal Worker 0.75 0.75 0.75 0.75 TOTAL 17.75 17.75 17.75 17.75 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGETJPROI TARGET/PROD Park Pavilion Rental Participants(Non-Profits) 2,560 2,640 4,950 5,500 Park Pavilion Rental Participants(Community Events) 16,000 18,850 30,050 32,500 Local Athletic Youth Sports Participants 2,721 4,639 5,350 5,500 Park Pavilion Rental Participants 2,064 2,995 3,650 4,000 Number of Playgrounds in Neighborhood Parks 19 19 22 23 Athletic Field Rental Hours(Local Leagues and Select 160 379 900 1,000 Leagues) 66 PROPOSED BUDGET FY 2023 100-GENERAL FUND PARKS FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $850,625 $847,194 $847,194 $904,634 51112 SALARIES-PART TIME $29,382 $20,802 $20,802 $21,500 51130 OVERTIME $23,510 $25,000 $25,000 $28,500 51140 LONGEVITY PAY $6,792 $7,508 $7,508 $6,904 51310 TMRS $135,525 $136,354 $136,354 $145,706 51410 HOSPITAL AND LIFE INSURANCE $185,736 $159,484 $159,484 $178,564 51420 LONG-TERM DISABILITY $3,654 $4,838 $4,838 $3,347 51440 FICA $53,235 $55,831 $55,831 $59,615 51450 MEDICARE $12,450 $13,058 $13,058 $13,942 51470 WORKERS COMP PREMIUM $7,692 $8,930 $8,930 $9,208 51480 UNEMPLOYMENT COMP(TWC) $5,336 $5,400 $5,400 $5,400 TOTAL PERSONNEL SERVICES $1,313,936 $1,284,399 $1,284,399 $1,377,320 52010 OFFICE SUPPLIES $1,867 $3,030 $3,030 $3,030 52130 TOOLS/EQUIP(NON-CAPITAL) $19,615 $20,200 $20,200 $12,000 52210 JANITORIAL SUPPLIES $6,171 $7,000 $7,000 $7,000 52250 MEDICAL AND SURGICAL $312 $1,500 $1,500 $1,500 52310 FUEL AND LUBRICANTS $29,664 $35,065 $35,065 $50,800 52380 CHEMICALS $57,593 $59,000 $59,000 $59,000 52510 BOTANICAL AND AGRICULTURAL $26,039 $26,000 $26,000 $26,000 52550 IRRIGATION SYSTEM PARTS $28,770 $29,000 $29,000 $29,000 52610 RECREATIONAL SUPPLIES $81,953 $84,600 $84,600 $84,600 52710 WEARING APPAREL AND UNIFORMS $9,747 $15,030 $15,030 $15,030 52810 FOOD SUPPLIES $2,662 $2,700 $2,700 $2,700 TOTAL SUPPLIES $264,393 $283,125 $283,125 $290,660 54210 STREETS AND ALLEYS $6,697 $7,000 $7,000 $7,000 54250 STREET SIGNS AND MARKINGS $8,161 $10,000 $10,000 $10,000 54530 HEAVY EQUIPMENT $23,537 $25,750 $25,750 $25,750 54630 TOOLS AND EQUIPMENT $2,661 $2,600 $2,600 $2,600 54910 BUILDINGS $12,913 $43,000 $43,000 $13,000 TOTAL MATERIALS FOR MAINTENANCE $53,970 $88,350 $88,350 $58,350 56040 SPECIAL SERVICES $537,378 $631,485 $631,485 $631,485 56110 COMMUNICATIONS $9,436 $12,720 $12,720 $14,640 56180 RENTAL $13,695 $16,200 $16,200 $23,400 56210 TRAVEL AND TRAINING $21,848 $25,250 $25,250 $25,250 56250 DUES AND SUBSCRIPTIONS $3,746 $7,040 $7,040 $7,040 56570 ENGINEERING/ARCHITECTURAL $11,000 $0 $0 $0 56610 UTILITIES-ELECTRIC $89,296 $122,465 $122,465 $122,465 56630 UTILITIES-WATER $269,982 $200,000 $200,000 $225,000 56680 TRASH DISPOSAL $1,552 $2,000 $2,000 $2,000 TOTAL CONTRACTURAL SERVICES $957,933 $1,017,160 $1,017,160 $1,051,280 58510 MOTOR VEHICLES $26,999 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $0 $150,000 $150,000 $0 TOTAL CAPITAL OUTLAY $26,999 $150,000 $150,000 $0 TOTAL PARKS $2,617,231 $2,823,034 $2,823,034 $2,777,610 67 CITY OF WYLIE LIBRARY DEPARTMENT DESCRIPTION The Library's mission statement is to inspire, inform and interact.The library staff strives to inspire through quality programs such as storytime, inform through a quality collection in a variety of formats and interact as a vibrant part of the community. The Smith Public Library also offers wifi,computers for public use,streaming services,services to the business community and meeting spaces.We are organized into four different departments:Technical Services,Circulation,Adult Services and Youth Services.Our outreach efforts include services to Wylie I.S.D.as well as fruitful partnerships with other local organizations such as the Chamber of Commerce and Collin College. FISCAL YEAR 2023 GOALS AND OBJECTIVES Partnering with Collin College to provide events. Strategic Goal:Community Focused Government Partnering with the Chamber of Commerce to provide resources for local businesses. Strategic Goal:Community Focused Government Create a digital media lab for small business use. Strategic Goal:Community Focused Government With input from Wylie I.S.D.staff,create a large print collection in youth services for vision impaired students. Strategic Goal:Community Focused Government Expand STEAM kits to include specialized content targeting specific issues and interests. Strategic Goal:Culture Introduce staff to a variety of people from other City departments and community organizations at staff meetings to expand their knowledge about city and community services. Strategic Goal:Workforce Purchase, implement and train staff on new sorter. Strategic Goal:Workforce Expand and improve the library garden. Strategic Goal:Community Focused Government FISCAL YEAR 2022 ACCOMPLISHMENTS Items Checked Out: 620,034(including 65,026 digital items) Programs Offered:415 (In-person and virtual) Program Attendance:99,777(In-person and virtual) Implemented 2 new streaming services adding hundreds of thousands of items to the digital collection. Over 4,500 hours logged on our learning databases. Over 19,000 searches on online databases such as Ancestry and Data Axle. Expanded Silver Linings Deliveries to anyone with a mobility impairment. Strategic Goals: Health,Safety and Well-Being,Community Focused Government Implemented Kanopy and Hoopla,two new streaming services for patron use. Strategic Goals:Workforce,Community Focused Government Received funds to update the library sorter. Strategic Goals: Infrastructure Completed the three year strategic plan. Strategic Goal:Community Focused Government 2021 Achievement of Library Excellence Award from the Texas Municipal Library Directors Association. Strategic Goal:Community Focused Government 68 LIBRARY CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Library Director 1.0 1.0 1.0 1.0 Assistant Library Director 0.0 0.0 1.0 1.0 Public Services Supervisor 1.0 1.0 1.0 1.0 Youth Services Supervisor 1.0 1.0 1.0 1.0 Circulation Services Supervisor 1.0 1.0 1.0 1.0 Children's Services Librarian 2.0 2.0 2.0 2.0 Teen Services Librarian 1.0 1.0 1.0 1.0 Adult Services Librarian 2.0 2.0 2.0 2.0 Electronic Services Librarian 1.0 1.0 0.0 0.0 Technical Librarian 1.0 1.0 1.0 1.0 Administrative Assistant 1.0 1.0 1.0 1.0 Reference Assistant 7.0 7.0 7.0 7.0 Library Technician 6.0 6.0 6.0 6.0 Library Clerk 2.0 2.0 2.0 1.5 TOTAL 27.0 27.0 27.0 26.5 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 1 FY 207-1 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ TARGET/PROJ Circulation(Check-outs and renewals of physical items) 401,659 555,851 564,189 572,652 Library Visitors(Door Count)2 152,594 129,398 142,337 156,570 Holds Processed 60,890 64,186 64,186 64,186 New Registered Borrowers 2,810 3,765 4,141 4,555 Drive-Thru Window 3,494 4,860 3,402 2,552 EFFICIENCY/EFFECTIVENESS MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ TARGET/PROD Texas State Library Annual Report for Accreditation April 1 April 8 April 15 April 15 Texas Municipal Library Directors Association Library of Excellence December December 16 December 15 Application 29 69 PROPOSED BUDGET FY 2023 100-GENERAL FUND LIBRARY FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $917,509 $917,435 $917,435 $986,814 51112 SALARIES-PART TIME $216,112 $286,865 $286,865 $331,642 51130 OVERTIME $487 $0 $0 $0 51140 LONGEVITY PAY $5,672 $5,952 $5,952 $6,449 51310 TMRS $172,504 $179,326 $179,326 $204,713 51410 HOSPITAL AND LIFE INSURANCE $136,834 $144,445 $144,445 $166,613 51420 LONG-TERM DISABILITY $3,864 $5,137 $5,137 $3,651 51440 FICA $70,079 $75,036 $75,036 $82,144 51450 MEDICARE $16,389 $17,549 $17,549 $19,211 51470 WORKERS COMP PREMIUM $1,524 $1,890 $1,890 $2,040 51480 UNEMPLOYMENT COMP(TWC) $8,983 $9,180 $9,180 $9,180 TOTAL PERSONNEL SERVICES $1,549,956 $1,642,814 $1,642,815 $1,812,457 52010 OFFICE SUPPLIES $42,266 $43,076 $43,076 $41,750 52040 POSTAGE AND FREIGHT $4,760 $4,800 $4,800 $4,800 52070 COMPUTER SOFTWARE $0 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $40,252 $15,181 $15,181 $2,350 52510 BOTANICAL AND AGRICULTURAL $0 $0 $0 $0 52620 LIBRARY BOOKS $143,402 $147,631 $147,631 $150,895 52630 AUDIO-VISUAL $81,127 $112,694 $112,694 $116,450 52810 FOOD SUPPLIES $775 $600 $600 $600 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $312,580 $323,982 $323,982 $316,845 54810 COMPUTER HARD/SOFTWARE $22,906 $39,723 $39,723 $41,345 54910 BUILDINGS $2,245 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $25,151 $39,723 $39,723 $41,345 56040 SPECIAL SERVICES $42,677 $36,539 $36,539 $37,520 56110 COMMUNICATIONS $8,715 $0 $0 $0 56210 TRAVEL AND TRAINING $4,755 $12,842 $12,842 $12,800 56250 DUES AND SUBSCRIPTIONS $2,197 $2,798 $2,798 $2,855 TOTAL CONTRACTURAL SERVICES $58,343 $52,179 $52,179 $53,175 58850 MAJOR TOOLS AND EQUIPMENT $0 $120,000 $0 $120,000 TOTAL CAPITAL OUTLAY $0 $120,000 $0 $120,000 TOTAL LIBRARY $1,946,031 $2,178,698 $2,058,699 $2,343,822 70 CITY OF WYLIE GENERAL FUND COMBINED SERVICES DEPARTMENT DESCRIPTION This department reflects expenditures incurred by the City's General Fund,as a single entity, in the conduct of its operations. These expenditures include sanitation contracts,insurance premiums,communications, utilities, postage and other miscellaneous expenses. 71 PROPOSED BUDGET FY 2023 100-GENERAL FUND GF COMBINED SERVICES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52040 POSTAGE AND FREIGHT $19,861 $20,000 $20,000 $20,000 TOTAL SUPPLIES $19,861 $20,000 $20,000 $20,000 54510 MOTOR VEHICLES $187,520 $200,000 $200,000 $200,000 54810 COMPUTER HARD/SOFTWARE $4,200 $12,000 $12,000 $12,000 TOTAL MATERIALS FOR MAINTENANCE $191,720 $212,000 $212,000 $212,000 56040 SPECIAL SERVICES $222,040 $202,967 $202,967 $389,127 56110 COMMUNICATIONS $135,058 $130,000 $130,000 $138,600 56310INSURANCE $292,867 $394,000 $394,000 $394,000 56570 ENGINEERING/ARCHITECTURAL $3,070 $0 $0 $52,380 56610 UTILITIES-ELECTRIC $350,946 $200,000 $200,000 $217,800 56612 STREET LIGHTING $476,046 $480,000 $480,000 $500,000 56630 UTILITIES-WATER $42,583 $30,000 $30,000 $44,625 56660 UTILITIES-GAS $21,784 $45,600 $45,600 $23,000 56680 TRASH DISPOSAL $2,258,056 $2,116,350 $2,116,350 $2,491,637 56990 OTHER $36,425 $40,000 $40,000 $40,000 TOTAL CONTRACTURAL SERVICES $3,838,876 $3,638,917 $3,638,917 $4,291,169 57410 PRINCIPAL PAYMENT $331,574 $331,666 $279,286 $108,405 57415 INTEREST EXPENSE $23,681 $25,474 $25,474 $9,218 TOTAL DEBT SERVICE AND CAP.REPL $355,255 $357,140 $304,760 $117,623 59131 TRANSFER TO SPECIAL REVENUE $0 $3,070 $3,070 $0 59430 TRANSFER TO CAPITAL PROJ FUND $272,775 $7,003,602 $7,003,602 $0 TOTAL OTHER FINANCING(USES) $272,775 $7,006,672 $7,006,672 $0 TOTAL GF COMBINED SERVICES $4,678,487 $11,234,729 $11,182,349 $4,640,792 72 CITY OF WYLIE UTILITY FUND FUND DESCRIPTION The City's water and wastewater utilities are financed and operated in a manner similar to private business enterprises,where costs of providing services to the public are financed primarily through user charges. Departments in the fund include Utility Administration,Water,Wastewater, Utility Billing and Utility Fund Combined Services. 73 City Of Wylie Fund Summary Utility Fund Audited Utility Fund Ending Balance 09/30/21 $ 24,740,623 (615) C.O. 2007 Total Equity (79,927) (620) Sewer Repair& Replacement Total Equity (2,252,904) (625) C.O. 2017 Total Equity (1,451,153) Net Fund 611 Unrestricted 20,956,639 Projected '22 Revenues 25,211,725 Available Funds 46,168,364 Projected '22 Expenditures (23,655,733) a) Estimated Ending Fund Balance 09/30/22 $ 22,512,631 Estimated Beginning Fund Balance-10/01/22 $ 22,512,631 Proposed Revenues '23 26,027,619 b) Proposed Expenditures'23 (24,191,271) New Fleet and Equipment One Time Uses $ (687,600) Carryforward Expenditures $ (2,082,268) Estimated Ending Fund Balance 09/30/23 $ 21,579,111 c) a) Carry forward items are taken out of projected 2022 expense and included in 2023 expense. See manager's letter for detailed list totalling$2,082,268. b)Assumes 7.00%water rate increase and 2.75%sewer rate increase per the 2020 rate study. c) Policy requirement is 90 days of operating expenditures. This Ending Fund Balance is 322 days. 74 UTILITY FUND SUMMARY OF REVENUES AND EXPENDITURES 2020-2021 2021-2022 2021-2022 2022-2023 ACTUAL BUDGET PROJECTED PROPOSED REVENUES: Service Fees 24,174,503 25,091,934 25,091,934 25,933,619 Interest&Misc. Income 20,646 78,500 87,950 94,000 Other Financing Sources 1,639,762 31,841 31,841 - TOTAL REVENUES 25,834,911 25,202,275 25,211,725 26,027,619 EXPENDITURES: Utility Administration 873,348 1,106,839 855,164 657,213 Water 1,505,162 5,648,591 3,825,586 4,208,355 Engineering - 447,538 447,539 1,101,015 Wastewater 982,566 1,347,231 1,339,641 1,337,397 Utility Billing 949,663 1,320,992 1,320,992 1,241,167 Combined Services 13,424,705 15,866,811 15,866,811 18,415,992 TOTAL EXPENDITURES 17,735,444 25,738,002 23,655,733 26,961,139 75 PROPOSED BUDGET FY 2023 611-UTILITY FUND UTILITY FUND REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 44135 WEEKEND INSPECTION FEES $62,300 $50,000 $50,000 $50,000 44511 WATER SALES $11,030,466 $11,649,554 $11,649,554 $12,300,891 44512 SEWER SALES $12,416,039 $12,721,872 $12,721,872 $12,871,728 44513 SEWER PASS THRU $0 $0 $0 $0 44514 SEWER SALES-BULK $218,163 $175,000 $175,000 $260,000 44515 PENALTY $176,051 $210,000 $210,000 $195,000 44516 WATER TAP FEES $77,544 $60,000 $60,000 $60,000 44517 SEWER TAP FEES $10,720 $12,000 $12,000 $12,000 44518 TURN ON/OFF FEES $31,750 $40,000 $40,000 $40,000 44519 WATER SALES-BULK $33,270 $48,000 $48,000 $24,000 44520 UTILITY PRETREATMENT FEES $118,201 $125,508 $125,508 $120,000 44561 IMPACT FEES-WATER $0 $0 $0 $0 44563 IMPACT FEES-SEWER $0 $0 $0 $0 TOTAL SERVICE FEES $24,174,503 $25,091,934 $25,091,934 $25,933,619 46110 ALLOCATED INTEREST EARNINGS $8,732 $8,500 $17,950 $24,000 46210 BANK MONEY MARKET INTEREST $45,919 $0 $0 $0 TOTAL INTEREST INCOME $54,651 $8,500 $17,950 $24,000 48410 MISCELLANEOUS INCOME ($96,799) $50,000 $50,000 $50,000 48412 MISC REVENUE UTILITY $16,930 $20,000 $20,000 $20,000 48430 GAIN/(LOSS)SALE OF CAP ASSETS $45,863 $0 $0 $0 TOTAL MISCELLANEOUS INCOME ($34,005) $70,000 $70,000 $70,000 49410 CONTRIBUTIONS-WATER $511,360 $0 $0 $0 49420 CONTRIBUTIONS-SEWER $1,124,684 $0 $0 $0 49600 INSURANCE RECOVERIES $3,718 $31,841 $31,841 $0 49911 TRANSFER FROM GEN CAP ASSETS $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $1,639,762 $31,841 $31,841 $0 TOTAL UTILITY FUND REVENUES $25,834,911 $25,202,275 $25,211,725 $26,027,619 76 CITY OF WYLIE UTILITY ADMINISTRATION DEPARTMENT DESCRIPTION The Utility Administration Department is responsible for supplying supervision,technical,administrative and direct support to Public Works.Engineering moved to a separate department in FY 22. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue implementation of a system-wide wastewater infrastructure rehabilitation program,outlined by the completed CMCM inspection. Strategic Goal: Health,Safety,and Well-Being Continue implementation of the Water Conservation Plan,Water Resource and Emergency Management Plan,and Storm Water Management Plan(SWMP). Strategic Goal: Health,Safety,and Well-Being Continue compliance with all regulatory agency reporting and documentation. Strategic Goal: Health,Safety,and Well-Being Continue the program for city-wide pavement rehabilitation using the 2020 results of the Pavement Assessment project. Strategic Goal: Infrastructure Continue to work towards department accreditation by the American Public Works Association (APWA). Strategic Goal:Workforce Continue to work towards department-wide licensing Strategic Goal:Workforce FISCAL YEAR 2022 ACCOMPLISHMENTS Completed all TCEQ,TWDB,and NTMWD water sample collections and reporting requirements. Strategic Goal: Health,Safety,and Well-Being Executed agreement with vendor to assist in sidewalk rehabilitation citywide Strategic Goal: Infrastructure Assisted with winter storm coordination,working with all Public Works divisions. Strategic Goal: Health,Safety,and Well-Being Identified areas of drainage that are in need of repair Strategic Goal: Infrastructure Entered into an agreement with Texas 811 for water and sewer line locating Strategic Goal: Infrastructure BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Public Works Director 1.0 1.0 1.0 1.0 Engineering Const. Supervisor 1.0 1.0 0.0 0.0 Utility Inspector 1.0 1.0 0.0 0.0 Engineering Project Manager 1.0 1.0 0.0 0.0 Right of Way Inspector 1.0 1.0 0.0 0.0 Administrative Assistant II 1.0 1.0 1.0 1.0 TOTAL 6.0 6.0 2.0 2.0 77 PROPOSED BUDGET FY 2023 611-UTILITY FUND UTILITY ADMINISTRATION FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $441,515 $249,087 $249,087 $164,028 51130 OVERTIME $45,225 $49,000 $49,000 $5,000 51140 LONGEVITY PAY $2,312 $2,604 $2,604 $372 51310 TMRS $74,341 $46,608 $46,608 $26,257 51410 HOSPITAL AND LIFE INSURANCE $64,245 $54,290 $54,290 $26,621 51420 LONG-TERM DISABILITY $1,793 $1,322 $1,322 $607 51440 FICA $28,912 $18,641 $18,641 $10,503 51450 MEDICARE $6,762 $4,360 $4,360 $2,456 51470 WORKERS COMP PREMIUM $973 $1,266 $1,266 $355 51480 UNEMPLOYMENT COMP(TWC) $1,729 $1,620 $1,620 $540 TOTAL PERSONNEL SERVICES $667,806 $428,799 $428,798 $236,739 52010 OFFICE SUPPLIES $1,737 $6,020 $6,020 $3,520 52040 POSTAGE AND FREIGHT $0 $0 $0 $0 52070 COMPUTER SOFTWARE $0 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $242 $5,200 $5,200 $600 52250 MEDICAL AND SURGICAL $0 $0 $0 $0 52310 FUEL AND LUBRICANTS $5,775 $9,000 $9,000 $0 52710 WEARING APPAREL AND UNIFORMS $2,693 $4,080 $4,080 $480 52810 FOOD SUPPLIES $655 $700 $700 $1,100 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $11,102 $25,000 $25,000 $5,700 54810 COMPUTER HARD/SOFTWARE $44,777 $201,130 $65,400 $207,230 54990 OTHER $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $44,777 $201,130 $65,400 $207,230 56040 SPECIAL SERVICES $150 $15,200 $15,200 $15,200 56080 ADVERTISING $9 $200 $200 $250 56110 COMMUNICATIONS $1,607 $780 $780 $0 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $3,549 $7,200 $7,200 $500 56250 DUES AND SUBSCRIPTIONS $56,177 $67,230 $67,230 $75,650 56530 COURT AND LEGAL COSTS $0 $0 $0 $0 56570 ENGINEERING/ARCHITECTURAL $88,171 $309,550 $225,356 $84,194 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $149,664 $400,160 $315,966 $175,794 58570 ENGINEERING/ARCHITECTURAL $0 $31,750 $0 $31,750 58910 BUILDINGS $66,877 $20,000 $20,000 $0 58995 CONTRA CAPITAL OUTLAY ($66,877) $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $51,750 $20,000 $31,750 TOTAL UTILITY ADMINISTRATION $873,348 $1,106,839 $855,164 $657,213 78 CITY OF WYLIE UTILITIES - WATER DEPARTMENT DESCRIPTION The Water Department's goal is to continuously supply safe, uninterrupted potable water service to Wylie residents and businesses.The City purchases water from the North Texas Municipal Water District(NTMWD). Department staff is responsible for maintaining approximately 188 miles of water distribution mains including approximately 15,000 service connections,three(3) pump stations,and three(3)elevated storage tanks.Typical duties include monthly sampling of water,operating and maintenance of valves and fire hydrants, hydrant meter program tracking, performing routine inspections of pump stations,and responding to water main emergency repairs.The Water Department is also responsible for maintaining water quality through routine testing, monitoring the backflow testing program, performing customer service inspections,flushing hydrants, reporting to regulatory agencies,supporting the cross-connection control program, and close coordination with the NTMWD. FISCAL YEAR 2023 GOALS AND OBJECTIVES' Continue to implement the Cross Connection Control Program. Strategic Goal: Health,Safety,and Well-Being Continue Unidirectional Flushing(UDF)in the distribution system. Strategic Goal: Health,Safety,and Well-Being Continue to GPS locate all water mains,valves,and fire hydrants. Strategic Goal: Health,Safety,and Well-Being Prepare the Consumer Confidence Report and submit it to the Texas Commission on Environmental Quality(TCEQ). Strategic Goal: Health,Safety,and Well-Being Prepare the Water Conservation Report and submit it to the North Texas Municipal Water District(NTMWD). Strategic Goal: Health,Safety,and Well-Being Complete the Risk and Resilience Assessment,and Emergency Response Plan per EPA Strategic Goal: Health,Safety,and Well-Being Complete the Emergency Preparedness Plan per TCEQ Strategic Goal: Health,Safety,and Well-Being Prepare the Water Use Survey and Water Loss Audit Reports and submit them to the Texas Water Development Board (TWDB). Strategic Goal: Health,Safety,and Well-Being FISCAL YEAR 2022 ACCOMPLISHMENTS Performed interior inspection and cleaning of water storage reservoirs. Strategic Goal: Health,Safety,and Well-Being Collected GPS data of water mains,valves,and fire hydrants. Strategic Goal: Health,Safety,and Well-Being Continued with valve exercise and maintenance program. Strategic Goal: Health,Safety,and Well-Being Completed Consumer Confidence Report and submitted to the TCEQ. Strategic Goal: Health,Safety,and Well-Being Completed Water Conservation Report and submitted to the NTMWD. Strategic Goal: Health,Safety,and Well-Being UTILITIES - WATER CONTINUED Completed Water Use Survey and Water Loss Audit and submitted to the TWDB. Strategic Goal: Health,Safety,and Well-Being Installed two(2)6-inch water valves at the intersection of Oak Street and Jackson Street. Strategic Goal: Health,Safety,and Well-Being Responded to emergency calls during the 2022 Winter Weather Storm. Strategic Goal: Health,Safety,and Well-Being Completed Risk and Resilience Assessment and Emergency Response Plan for Water Utility Infrastructure Act per EPA Strategic Goal: Health,Safety,and Well-Being Completed Emergency Preparedness Plan per TCEQ Strategic Goal: Health,Safety,and Well-Being BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Assistant PW Superintendent 1.0 1.0 0.0 0.0 Utilities Manager 0.0 0.0 1.0 1.0 Water Utility Supervisor 1.0 1.0 1.0 1.0 Water Quality Specialist 2.0 2.0 2.0 2.0 Crew Leader 2.0 2.0 2.0 2.0 Equipment Operator II 0.0 0.0 0.0 4.0 Equipment Operator 2.0 2.0 2.0 6.0 Maintenance Worker 11 2.0 2.0 2.0 0.0 Maintenance Worker 6.0 6.0 6.0 0.0 TOTAL 16.0 16.0 16.0 16.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE BENCHMARK FY 2020 FY 2021 ACTUAL ACTUAL Water Division-Total of miles of water mains maintained 100% 185 188 Water Division-Total of fire hydrants maintained 100% 1,800 1,938 Water Division-Water Leaks Repaired (Main Lines) 100% 1 10 Water Division-Water Leak Repaired(Service Lines) 100% 22 50 Water Division-Water Leaks Repaired(Curb Stop) 100% 32 47 Water Division-Water Leaks Repaired(CO-OP Main) 100% 4 14 80 UTILITIES - WATER CONTINUED EFFICIENCY/EFFECTIVENESS MEASURE BENCHMARK FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROD TARGET/PROD Provide and monitor adequate water pressure and volume 45 PSI 45 PSI 45 PSI delivered for the City's water distribution system and fire protection needs(Maintain an average water pressure of 45 PSI in the Upper and Lower Pressure Planes of the Water System)(%of time system meets 45 PSI) Provide responsive service during the regular hours to 30 Min 30 Min 30 Min customer requests and inquiries within prescribed parameters(Response times:water main break or sewer backups-30 minutes) Provide responsive service after hours to customer 1 Hour 1 Hour 1 Hour requests and inquiries within prescribed parameters (Response times:water main break or sewer backups-1 hour)(Albert.Garza@wylietexas.gov @ 6/2/2022 2:45:00 PM) Provide water quality management services(Provide 100% 100% 100% 100% 100 water quality testing per TCEQ requirements) 81 PROPOSED BUDGET FY 2023 611-UTILITY FUND WATER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $654,314 $749,381 $749,381 $819,520 51130 OVERTIME $33,461 $30,000 $30,000 $35,000 51140 LONGEVITY PAY $5,584 $5,783 $5,783 $5,200 51310 TMRS $106,225 $121,701 $121,701 $133,257 51410 HOSPITAL AND LIFE INSURANCE $115,961 $182,397 $182,397 $155,349 51420 LONG-TERM DISABILITY $2,383 $4,069 $4,069 $3,033 51440 FICA $41,942 $48,680 $48,680 $53,303 51450 MEDICARE $9,809 $11,385 $11,385 $12,466 51470 WORKERS COMP PREMIUM $8,614 $11,103 $11,103 $10,833 51480 UNEMPLOYMENT COMP(TWC) $3,921 $4,320 $4,320 $4,320 TOTAL PERSONNEL SERVICES $982,217 $1,168,820 $1,168,819 $1,232,281 52010 OFFICE SUPPLIES $1,501 $200 $200 $200 52040 POSTAGE AND FREIGHT $9 $200 $200 $200 52130 TOOLS/EQUIP(NON-CAPITAL) $15,476 $49,500 $49,500 $27,600 52250 MEDICAL AND SURGICAL $430 $400 $400 $400 52310 FUEL AND LUBRICANTS $24,050 $31,140 $31,140 $66,600 52350 METER/SERVICE CONNECT SUPPLIES $48,115 $54,140 $54,140 $63,840 52380 CHEMICALS $2,075 $6,600 $6,600 $7,600 52510 BOTANICAL AND AGRICULTURAL $1,736 $3,000 $3,000 $3,000 52710 WEARING APPAREL AND UNIFORMS $5,051 $14,120 $14,120 $15,400 52810 FOOD SUPPLIES $674 $1,600 $1,600 $1,600 TOTAL SUPPLIES $99,117 $160,900 $160,900 $186,440 54210 STREETS AND ALLEYS $18,547 $30,000 $30,000 $30,000 54250 STREET SIGNS AND MARKINGS $2,856 $2,400 $2,400 $2,400 54310 UTILITY PLANT-WATER $21,651 $219,341 $89,341 $187,500 54330 WATER MAINS AND FIRE HYDRANTS $24,291 $1,235,000 $1,235,000 $35,000 54530 HEAVY EQUIPMENT $26,264 $30,000 $30,000 $40,000 54630 TOOLS AND EQUIPMENT $465 $900 $900 $900 54810 COMPUTER HARD/SOFTWARE $0 $2,550 $2,550 $2,550 54910 BUILDINGS $16 $19,600 $19,600 $4,000 TOTAL MATERIALS FOR MAINTENANCE $94,090 $1,539,791 $1,409,791 $302,350 56040 SPECIAL SERVICES $75,532 $75,640 $75,640 $245,240 56110 COMMUNICATIONS $2,220 $1,980 $1,980 $2,580 56150 LAB ANALYSIS $0 $200 $200 $200 56180 RENTAL $9,756 $5,000 $5,000 $5,000 56210 TRAVEL AND TRAINING $7,771 $10,300 $10,300 $12,100 56250 DUES AND SUBSCRIPTIONS $7,295 $7,460 $7,460 $7,660 56570 ENGINEERING/ARCHITECTURAL $19,204 $16,000 $0 $16,000 56610 UTILITIES-ELECTRIC $193,732 $170,000 $170,000 $180,000 56680 TRASH DISPOSAL $500 $500 $500 $500 TOTAL CONTRACTURAL SERVICES $316,010 $287,080 $271,080 $469,280 82 PROPOSED BUDGET FY 2023 611-UTILITY FUND WATER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 58310 WATER MAINS/HYDRANTS AND ETC $64,062 $625,000 $625,000 $136,000 58510 MOTOR VEHICLES $101,253 $36,000 $36,000 $0 58570 ENGINEERING/ARCHITECTURAL $28,080 $75,120 $50,496 $24,624 58850 MAJOR TOOLS AND EQUIPMENT $0 $1,755,880 $103,500 $1,857,380 58995 CONTRA CAPITAL OUTLAY ($179,667) $0 $0 $0 TOTAL CAPITAL OUTLAY $13,728 $2,492,000 $814,996 $2,018,004 TOTAL WATER $1,505,162 $5,648,591 $3,825,586 $4,208,355 83 CITY OF WYLIE ENGINEERING DEPARTMENT DEPARTMENT DESCRIPTION The Engineering Department oversees the planning,design,and construction of capital improvement projects(CIPs),and reviews development engineering plans and subdivision plats.The Department coordinates with other departments on the identification and design of projects and evaluates the impact of development on existing infrastructure.The Department also consults with developers,engineers,citizens,the Texas Department of Transportation,the North Texas Municipal Water District,the North Central Texas Council of Governments,and surrounding local governments. Functions include construction inspection,CIP management,development project management,and the implementation of design and construction standards.Moved from the Utility Administration Department in FY 2022 into a separate department. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue to provide construction and right-of-way inspections of residential subdivisions,commercial projects,and utility installations throughout the City. Strategic Goal: Health,Safety,and Well-Being Continue construction of the Ballard 1.5 Million Gallon Elevated Storage Tank. Strategic Goal: Infrastructure Continue construction of the Newport Harbor, East Brown,and Nortex Pump Station Backup Generators project. Strategic Goal: Health,Safety,and Well-Being Continue acquisition and construction activities related to the E FM 544(Stone Road, Phase 3)project Strategic Goal: Infrastructure Continue construction activities relating to the Eubanks Lane paving project. Strategic Goal: Infrastructure Complete design and begin construction of the McMillen Drive project. Strategic Goal: Infrastructure Begin construction of the Woodbridge Parkway at Hensley Lane Signal. Strategic Goal: Infrastructure Continue to coordinate with TxDOT on FM 2514 and Country Club/FM 544 Intersection projects through construction. Strategic Goal: Health,Safety,and Well-Being/Infrastructure Continue design of the Park Boulevard Extension project. Strategic Goal: Infrastructure Continue coordination of the Wylie Historic Area Drainage Master Plan. Strategic Goal: Health,Safety,and Well-Being Continue coordination for Downtown Traffic Impact Analysis. Strategic Goal: Infrastructure FISCAL YEAR 2022'ACCOMPLISHMENTS Provided construction and right-of-way inspections on residential,commercial,and utility construction city-wide. Strategic Goal: Health,Safety,and Well-Being Complete design of the Ballard 1.5 Million Gallon Elevated Storage Tank. Strategic Goal: Infrastructure Complete design and bid of the Newport Harbor Pump Station Backup Generators project. Strategic Goal: Health,Safety,and Well-Being 84 ENGINEERING DEPARTMENT CONTINUED Complete design of the Parker Road Waterline and Country Club and FM 544 Waterline Relocation projects. Strategic Goal: Infrastructure Complete design of the E FM 544(Stone Road, Phase 3) project and begin right-of-way acquisition processes. Strategic Goal: Infrastructure Completed design of the Wylie Wastewater Plant Demolition plans. Strategic Goal: Health,Safety,and Well-Being Complete design and right-of-way acquisition process of the Eubanks Lane paving project. Strategic Goal: Infrastructure Complete design and construction of the Rowlett Dam#4 Improvements project. Strategic Goal: Health,Safety,and Well-Being Complete design of the Woodbridge Parkway at Hensley Lane Signal Project. Strategic Goal: Infrastructure Coordination with TxDOT and Collin County on HSIP Intersections, FM 2514, Park Boulevard Extension,and Country Club at FM 544 Intersection Projects. Strategic Goal: Infrastructure Begin design of the Park Boulevard Extension project. Strategic Goal: Infrastructure Begin design of the Wylie Historic Area Drainage Master Plan. Strategic Goal: Health,Safety,and Well-Being Begin coordination for Downtown Traffic Impact Analysis. Strategic Goal: Infrastructure Complete Geotechnical study of Stone Road,east of WA Allen. Strategic Goal: Infrastructure BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 City Engineer 0.0 0.0 1.0 1.0 Engineering Development Manager 0.0 0.0 1.0 1.0 Engineering Const. Supervisor 0.0 0.0 1.0 1.0 Utility Inspector 0.0 0.0 1.0 1.0 Engineering Project Manager 0.0 0.0 1.0 1.0 Right of Way Inspector 0.0 0.0 1.0 1.0 TOTAL 0.0 0.0 6.0 6.0 85 ENGINEERING DEPARTMENT CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2022 FY 2023 TARGET/PROD TARGET/PROJ Track and Report the Number of Site Plan/SUP Plans Reviewed 33 35 Track and Report the Number of Right-of-Way Permits Issued 222 250 Track and Report the Number of Right-of-Way Inspections Performed 2,357 2,500 Track and Report the Number of Capital Improvements Projects Managed 17 18 Track and Report the Number of Civil Plans Reviewed and Authorized for Construction 34 35 Track and Report the Number of Pre-Development Meetings Attended 38 35 EFFICIENCY/EFFECTIVENESS MEASURE BENCHMARK FY 2022 FY 2023 TARGET/PROD TARGET/PROD Percent(%)of Civil Construction Plan Reviews Performed in 10 100% 50% 90% Business Days Percent(%)of Site Plan or Pre-Development Plan In-House 100% 80% 100% Reviews Performed in 5 Business Days 86 PROPOSED BUDGET FY 2023 611-UTILITY FUND ENGINEERING FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $0 $324,722 $324,722 $517,795 51130 OVERTIME $0 $0 $0 $44,000 51140 LONGEVITY PAY $0 $0 $0 $3,308 51310 TMRS $0 $50,332 $50,332 $87,591 51410 HOSPITAL AND LIFE INSURANCE $0 $45,346 $45,346 $68,978 51420 LONG-TERM DISABILITY $0 $1,851 $1,851 $1,916 51440 FICA $0 $20,133 $20,133 $35,036 51450 MEDICARE $0 $4,708 $4,708 $8,194 51470 WORKERS COMP PREMIUM $0 $177 $177 $1,377 51480 UNEMPLOYMENT COMP(TWC) $0 $270 $270 $1,620 TOTAL PERSONNEL SERVICES $0 $447,538 $447,539 $769,815 52010 OFFICE SUPPLIES $0 $0 $0 $1,000 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $1,600 52310 FUEL AND LUBRICANTS $0 $0 $0 $13,500 52710 WEARING APPAREL AND UNIFORMS $0 $0 $0 $2,100 52810 FOOD SUPPLIES $0 $0 $0 $600 TOTAL SUPPLIES $0 $0 $0 $18,800 56040 SPECIAL SERVICES $0 $0 $0 $200 56050 UNIFORM CONTRACT $0 $0 $0 $0 56080 ADVERTISING $0 $0 $0 $200 56110 COMMUNICATIONS $0 $0 $0 $1,500 56180 RENTAL $0 $0 $0 $0 56210 TRAVEL AND TRAINING $0 $0 $0 $8,500 56250 DUES AND SUBSCRIPTIONS $0 $0 $0 $2,000 56570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $200,000 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $0 $0 $0 $212,400 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $100,000 TOTAL CAPITAL OUTLAY $0 $0 $0 $100,000 TOTAL ENGINEERING $0 $447,538 $447,539 $1,101,015 87 CITY OF WYLIE UTILITIES - WASTEWATER DEPARTMENT DESCRIPTION The goal of the Wastewater Division is to supply uninterrupted wastewater services to Wylie residents and businesses.The City delivers its sewage to the City's treatment plant operated under contract by NTMWD.The department's staff is responsible for maintaining approximately 219 miles of sewer collection lines and ten(10) lift stations.Typical duties include routine inspections of pumps and lift stations,emergency repairs to sewer mains, high-pressure jetting of mains,and responding to sewer stoppages. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue to perform wastewater collection system repairs and rehabilitation of severe inflow and infiltration deficiencies identified during the Capacity Management Operations and Maintenance(CMOM)assessment. Strategic Goal: Health,Safety,and Well-Being Continue to perform grease trap inspections at commercial sites. Strategic Goal: Health,Safety,and Well-Being Operate and maintain the collection system to prevent Sanitary Sewer Overflows(SSOs). Strategic Goal: Health,Safety,and Well-Being Perform smoke testing as needed to identify Inflow and Infiltration (1/1) in the wastewater collection system. Strategic Goal: Health,Safety,and Well-Being Continue to submit reports to the TCEQ regarding the condition of the City's wastewater collection system. Strategic Goal: Health,Safety,and Well-Being Camera inspect,clean,and repair wastewater lateral lines, manholes,and main lines identified during the CMOM study as having severe inflow and infiltration issues. Strategic Goal: Infrastructure FISCAL YEAR 2022 ACCOMPLISHMENTS Performed systematic camera inspections and jetting of main lines as a preventive maintenance measure city-wide. Strategic Goal: Health,Safety,and Well-Being Performed approximately 135 commercial grease trap inspections to maintain system integrity by preventing grease accumulation in main lines. Strategic Goal: Health,Safety,and Well-Being Installed (2)40KW emergency backup generators,one at Harvest Bend and one at Wylie Lakes Lift Stations. Strategic Goal: Infrastructure Replaced (1) lift station pump at Rushcreek Lift Station Strategic Goal: Infrastructure Responded to emergency calls during the 2022 Winter Weather Storm. Strategic Goal: Health,Safety,and Well-Being Decommission Old Muddy Creek Treatment Plant on Alanis. Strategic Goal: Infrastructure Relined (2) 10inch Sewer crossings on Kreymer Lane totaling approximately 300ft. Strategic Goal: Infrastructure 88 UTILITIES - WASTEWATER CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Crew Leader 2.0 2.0 2.0 2.0 Equipment Operator 11 0.0 0.0 0.0 4.0 Equipment Operator 2.0 2.0 2.0 6.0 Maintenance Worker 11 1.0 2.0 2.0 0.0 Maintenance Worker 6.0 6.0 6.0 0.0 TOTAL 11.0 12.0 12.0 12.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE BENCHMARK FY,2020 FY 2021 ACTUAL ACTUAL Wastewater Division-Total Linear feet of Wastewater mains Hydro-Jetted 200,000 25,398 105,434 Wastewater Division-Total linear feet of mains camera inspected 40,000 6,125 7.210 Wastewater Division-Total Grease Trap Inspections 100% 150 135 Wastewater Division-Total number of Sewer Lateral Lines Repaired 100% 24 49 Wastewater Division-Total number of manholes maintained 2,865 3,755 Wastewater Division- Total of miles of Wastewater Collection System Mains maintained 204 219 EFFICIENCY/EFFECTIVENESS FY 2022 FY 2023 MEASURE BENCHMARK TARGET/P TARGET/PRC►J RUB Wastewater Division-Provide responsive service during the regular hours to customer 30 Min 30 Min 30 Min requests and inquiries within prescribed parameters(Response times:sewer backups- 30 minutes) Wastewater Division-Provide responsive service after hours to customer requests and 1 Hour 1 Hour 1 Hour inquiries within prescribed parameters(Response times:sewer backups-1 hour) 89 PROPOSED BUDGET FY 2023 611-UTILITY FUND WASTEWATER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $433,396 $472,478 $472,478 $538,928 51130 OVERTIME $26,955 $20,000 $20,000 $26,000 51140 LONGEVITY PAY $2,768 $3,231 $3,231 $3,122 51310 TMRS $69,337 $76,835 $76,835 $88,048 51410 HOSPITAL AND LIFE INSURANCE $104,818 $128,974 $128,974 $110,487 51420 LONG-TERM DISABILITY $1,770 $2,545 $2,545 $1,994 51440 FICA $26,410 $30,734 $30,734 $35,219 51450 MEDICARE $6,177 $7,187 $7,187 $8,237 51470 WORKERS COMP PREMIUM $3,960 $6,117 $6,117 $7,157 51480 UNEMPLOYMENT COMP(TWC) $3,848 $3,240 $3,240 $3,240 TOTAL PERSONNEL SERVICES $679,438 $751,340 $751,341 $822,432 52010 OFFICE SUPPLIES $1,524 $200 $200 $200 52040 POSTAGE AND FREIGHT $0 $100 $100 $100 52070 COMPUTER SOFTWARE $0 $0 $0 $0 52130 TOOLS/EQUIP(NON-CAPITAL) $4,601 $18,800 $11,971 $16,029 52210 JANITORIAL SUPPLIES $0 $0 $0 $0 52250 MEDICAL AND SURGICAL $5 $300 $300 $300 52310 FUEL AND LUBRICANTS $7,779 $18,000 $18,000 $24,300 52380 CHEMICALS $1,287 $5,600 $5,600 $5,600 52510 BOTANICAL AND AGRICULTURAL $1,173 $2,500 $2,500 $2,500 52710 WEARING APPAREL AND UNIFORMS $3,560 $11,440 $11,440 $12,400 52810 FOOD SUPPLIES $808 $1,200 $1,200 $1,200 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $20,738 $58,140 $51,311 $62,629 54210 STREETS AND ALLEYS $15,455 $30,000 $30,000 $30,000 54250 STREET SIGNS AND MARKINGS $1,619 $1,250 $1,250 $1,250 54350 METER AND SERVICE CONNECTIONS $876 $6,000 $6,000 $10,000 54410 UTILITY PLANT-SEWER $15,149 $66,015 $66,015 $66,000 54430 SANITARY SEWERS $9,487 $66,500 $66,500 $66,500 54530 HEAVY EQUIPMENT $23,960 $26,000 $26,000 $40,000 54630 TOOLS AND EQUIPMENT $556 $2,500 $2,500 $2,500 54910 BUILDINGS $1,736 $2,500 $2,500 $2,500 TOTAL MATERIALS FOR MAINTENANCE $68,838 $200,765 $200,765 $218,750 56040 SPECIAL SERVICES $128,364 $167,800 $167,800 $165,800 56080 ADVERTISING $0 $500 $500 $500 56110 COMMUNICATIONS $631 $600 $600 $600 56180 RENTAL $1,557 $2,000 $2,000 $2,000 56210 TRAVEL AND TRAINING $2,606 $7,225 $7,225 $11,025 56250 DUES AND SUBSCRIPTIONS $293 $2,400 $2,400 $2,400 56570 ENGINEERING/ARCHITECTURAL $36,691 $23,960 $23,199 $761 56610 UTILITIES-ELECTRIC $43,111 $45,000 $45,000 $50,000 56680 TRASH DISPOSAL $300 $500 $500 $500 TOTAL CONTRACTURAL SERVICES $213,552 $249,985 $249,224 $233,586 90 PROPOSED BUDGET FY 2023 611-UTILITY FUND WASTEWATER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 58510 MOTOR VEHICLES $38,355 $31,000 $31,000 $0 58850 MAJOR TOOLS AND EQUIPMENT $57,910 $56,000 $56,000 $0 58995 CONTRA CAPITAL OUTLAY ($96,265) $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $87,000 $87,000 $0 TOTAL WASTEWATER $982,566 $1,347,231 $1,339,641 $1,337,397 91 CITY OF WYLIE UTILITY BILLING DEPARTMENT DESCRIPTION Utility Billing is a division of the Finance Department. It is responsible for the billing and collection of utility fees, revenue collections for all departments,and utility customer service.Our mission is to ensure all citizens and utility customers that we uphold respectful and responsive customer service. FISCAL YEAR 2023 GOALS AND OBJECTIVES 75%Watersmart adoption rate in the second year Strategic Goals:Community Focused Government; Financial Health Provide training to other departments that could utilize the metering software so they can better help citizens with leak and backflow questions Strategic Goal:Workforce Provide PDF bill printing through Watersmart portal for electronic billed customers Strategic Goals:Community Focused Government Convert 50%of customers to electronic billing Strategic Goal:Workforce FISCAL YEAR 2022 ACCOMPLISHMENTS Completed integration with Watersmart Customer Portal Strategic Goals:Workforce; Infrastructure;Community Focused Government Cross train all Utility Billing and Meter Service employees on new metering software Strategic Goals:Community Focused Government; Financial Health Completed mobile service orders Strategic Goal:Workforce 50%Watersmart adoption rate in the first year Strategic Goals:Community Focused Government; Financial Health Cross train all Utility Billing and Meter Service employees on the Watersmart Software and Invoice Cloud payment portal. Strategic Goals:Workforce;Community Focused Government Implemented texting notifications through Watersmart customer portal Strategic Goal:Community Focused Government; Financial Health Completed text pay so customers can pay over the phone by texting Strategic Goals:Community Focused Government;Workforce; Financial Health Upgrade to Incode 10. Strategic Goal:Workforce Implement an interactive customer portal to allow customers current data and text capability notifications. Strategic Goals:Community Focused Government; Financial Health Completed a policy page on the Utility Billing webpage Community Focused Government;Workforce Implemented customer auto draft and the ability to schedule a single credit card payment online. Strategic Goals:Community Focused Government; Financial Health;Workforce Completed cross training of Utility clerks in the field to learn how to better answer customer field related questions Strategic Goals:Community Focused Government;Workforce UTILITY BILLING CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Utility Manager 1.0 1.0 1.0 1.0 Utility Billing Supervisor 0.0 0.0 0.0 0.0 Senior Billing Clerk 1.0 1.0 1.0 1.0 Billing Clerk 3.0 3.0 3.0 3.0 Utility Technician 3.0 2.0 2.0 2.0 AMI Analyst 0.0 1.0 1.0 1.0 AMI Field Specialist 0.0 1.0 1.0 1.0 TOTAL 8.0 9.0 9.0 9.0 ACTIVITY DEMAND f ACTIVITY WORKLOAD MEASURE FY 2021 FY 2022 FY 2023 ACTUAL TARGET/PROD TARGET/PROD Number of new active customers 3,041 2,300 3,100 Number of new build meter sets 199 245 291 Number of paperless billing 3,500 4,700 7,600 93 PROPOSED BUDGET FY 2023 611-UTILITY FUND UTILITY BILLING FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $365,466 $396,135 $396,135 $420,909 51112 SALARIES-PART TIME $0 $0 $0 $0 51130 OVERTIME $3,716 $4,200 $4,200 $4,200 51140 LONGEVITY PAY $1,964 $2,379 $2,379 $2,643 51160 CERTIFICATION INCENTIVE $0 $0 $0 $2,400 51310 TMRS $56,650 $62,420 $62,420 $66,674 51410 HOSPITAL AND LIFE INSURANCE $91,690 $108,352 $108,352 $90,803 51420 LONG-TERM DISABILITY $1,522 $2,135 $2,135 $1,557 51440 FICA $21,412 $24,969 $24,969 $26,669 51450 MEDICARE $5,008 $5,839 $5,839 $6,237 51470 WORKERS COMP PREMIUM $2,000 $2,366 $2,366 $2,231 51480 UNEMPLOYMENT COMP(TWC) $2,539 $2,430 $2,430 $2,430 TOTAL PERSONNEL SERVICES $551,968 $611,225 $611,225 $626,753 52010 OFFICE SUPPLIES $6,019 $7,850 $7,850 $7,850 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $4,750 $4,750 $1,150 52310 FUEL AND LUBRICANTS $0 $10,800 $10,800 $12,000 52350 METER/SERVICE CONNECT SUPPLIES $24,672 $64,925 $64,925 $115,000 52710 WEARING APPAREL AND UNIFORMS $1,356 $2,460 $2,460 $2,460 52810 FOOD SUPPLIES $443 $700 $700 $700 TOTAL SUPPLIES $32,490 $91,485 $91,485 $139,160 54810 COMPUTER HARD/SOFTWARE $260 $57,366 $57,366 $60,000 TOTAL MATERIALS FOR MAINTENANCE $260 $57,366 $57,366 $60,000 56040 SPECIAL SERVICES $41,255 $86,612 $86,612 $88,950 56080 ADVERTISING $0 $12,150 $12,150 $0 56110 COMMUNICATIONS $3,294 $6,000 $6,000 $6,000 56180 RENTAL $1,390 $1,500 $1,500 $1,500 56210 TRAVEL AND TRAINING $0 $7,000 $7,000 $7,000 56250 DUES AND SUBSCRIPTIONS $0 $304 $304 $304 56330 BANK SERVICE CHARGES $3,018 $3,500 $3,500 $3,500 56340 CCARD ONLINE SERVICE FEES $315,988 $338,850 $338,850 $308,000 TOTAL CONTRACTURAL SERVICES $364,945 $455,916 $455,916 $415,254 58510 MOTOR VEHICLES $0 $105,000 $105,000 $0 TOTAL CAPITAL OUTLAY $0 $105,000 $105,000 $0 TOTAL UTILITY BILLING $949,663 $1,320,992 $1,320,992 $1,241,167 94 CITY OF WYLIE UTILITY FUND COMBINED SERVICES DEPARTMENT DESCRIPTION This department reflects expenditures incurred by the City's Utility Fund,as a single entity, in the conduct of its operations. These expenditures include water purchases,sewer treatment costs,debt service,communications, postage, insurance premiums and engineering fees. 95 PROPOSED BUDGET FY 2023 611-UTILITY FUND UTILITY COMBINED SERVICES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52040 POSTAGE AND FREIGHT $72,406 $97,650 $97,650 $84,000 TOTAL SUPPLIES $72,406 $97,650 $97,650 $84,000 54510 MOTOR VEHICLES ($1,195) $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE ($1,195) $0 $0 $0 56040 SPECIAL SERVICES $2,199 $40,717 $40,717 $76,525 56310INSURANCE $104,461 $126,250 $126,250 $133,870 56410 PENSION EXPENSE $35,662 $0 $0 $0 56530 COURT AND LEGAL COSTS $47,760 $60,000 $60,000 $60,000 56630 UTILITIES-WATER $5,515,752 $5,651,791 $5,651,791 $6,350,000 56640 UTILITIES-SEWER $6,022,820 $5,933,175 $5,933,175 $7,710,000 TOTAL CONTRACTURAL SERVICES $11,728,655 $11,811,933 $11,811,933 $14,330,395 57110 DEBT SERVICE $0 $750,000 $750,000 $745,000 57210 DEBT SERVICE-INTEREST $364,711 $347,983 $347,983 $322,694 57410 PRINCIPAL PAYMENT $0 $307,282 $307,282 $313,745 57415 INTEREST EXPENSE $46,944 $63,317 $63,317 $56,853 57420 BOND ISSUE COSTS $478 $0 $0 $0 57610 DEPRECIATION EXPENSE $2,586,964 $0 $0 $0 57611 AMORTIZATION EXPENSE ($55,883) $0 $0 $0 57710 BAD DEBT EXPENSE $0 $0 $0 $0 TOTAL DEBT SERVICE AND CAP.REPL $2,943,214 $1,468,582 $1,468,582 $1,438,292 58995 CONTRA CAPITAL OUTLAY ($3,832,649) $0 $0 $0 TOTAL CAPITAL OUTLAY ($3,832,649) $0 $0 $0 59111 TRANSFER TO GENERAL FUND $2,416,161 $2,488,646 $2,488,646 $2,563,305 59430 TRANSFER TO CAPITAL PROJ FUND $98,112 $0 $0 $0 TOTAL OTHER FINANCING(USES) $2,514,273 $2,488,646 $2,488,646 $2,563,305 TOTAL UTILITY COMBINED SERVICES $13,424,705 $15,866,811 $15,866,811 $18,415,992 96 CITY OF WYLI E SEWER REPAIR AND REPLACEMENT FUN[ FUND DESCRIPTION The Sewer Repair and Replacement Fund was established several years ago to create a source of funds that can be used for large sewer repair and maintenance projects. Utility customers are charged$2.00 per month on their utility bills and these revenues Pre accrued in an account for maintenance of the wastewater system. 97 City Of Wylie Fund Summary Sewer Repair and Replacement Fund Sewer Repair and Replacement Fund Ending Balance 09/30/21 $ 2,252,904 Projected '22 Revenues 417,000 Available Funds 2,669,904 Projected '22 Expenditures 0 Estimated Ending Fund Balance 09/30/22 $ 2,669,904 Estimated Beginning Fund Balance- 10/01/22 $ 2,669,904 Proposed Revenues '23 417,000 Proposed Expenditures '23 0 Carryforward Expenditures (1,500,000) a) Estimated Ending Fund Balance 09/30/23 $ 1,586,904 a) Carryforward of sanitary sewer repairs identified from Sanitary Sewer Assessment 98 PROPOSED BUDGET FY 2023 620-SEWER REPAIR AND REPLACEMENT SEWER REPAIR AND REPLACEMENT REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 44512 SEWER SALES $406,002 $412,000 $412,000 $412,000 TOTAL SERVICE FEES $406,002 $412,000 $412,000 $412,000 46110 ALLOCATED INTEREST EARNINGS $1,025 $5,000 $5,000 $5,000 TOTAL INTEREST INCOME $1,025 $5,000 $5,000 $5,000 TOTAL SEWER REPAIR AND REPLACEMENT REVENUES $407,027 $417,000 $417,000 $417,000 620-SEWER REPAIR AND REPLACEMENT SEWER REPAIR AND REPLACEMENT EXPENDITURES FY ZOZ1 FY ZOZZ FY ZOZZ FY ZOZ3 ACTUAL BUDGET PROJECTED PROPOSED 58410 SANITARY SEWER $0 $1,500,000 $0 $1,500,000 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $1,500,000 $0 $1,500,000 TOTAL SEWER REPAIR AND REPLACEMENT $0 $1,500,000 $0 $1,500,000 99 WYLIE ECONOMIC DEVELOPMENT CORPORATION The Wylie citizens, as authorized by the Texas State Legislature, created the Wylie Economic Development Corporation (WEDC) via the passage of a half-cent sales tax increase in 1990. Funds received by the WEDC are used solely to enhance and promote economic development within the Wylie community. BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Executive Director 1.0 1.0 1.0 1.0 Director of Business Retention 1.0 1.0 1.0 1.0 Senior Assistant 1.0 1.0 1.0 1.0 Administrative Assistant 0.0 0.0 1.0 1.0 TOTAL 3.0 3.0 4.0 4.0 The primary objectives of the WEDC are to increase local employment opportunities while enhancing and diversifying the City of Wylie's tax base. The WEDC currently employs four full-time staff members to manage daily operations and reports directly to a 5-member Board of Directors appointed by the Wylie City Council. Ex-Officio Members of the Board include the sitting Mayor and current City Manager. Meetings typically occur on the third Wednesday of each month at 7:30 a.m. and on an as-needed basis at WEDC offices located at 250 S. Highway 78. The Wylie City Council provides oversight of the WEDC via approval of Bylaws, appointment of Board Members, approval of annual budgets, review of monthly expenditures and project approval. The City of Wylie Finance Department processes all financial functions of the WEDC and coordinates an annual Financial Audit by an independent, third-party firm. While WEDC staff are City employees for the purpose of participating in group insurance plans, WEDC staff reports directly to the WEDC Board of Directors. WEDC Board of Directors Current Appointment Term Expires Demond Dawkins, President 07/2021 06/2024 Melisa Whitehead, Vice President 06/2022 06/2025 Gino Mulligi, Secretary 06/2022 06/2025 Tim Gilchrist, Treasurer 07/2020 06/2023 Blake Brininstool 07/2021 06/2024 100 City Of Wylie Fund Summary Wylie Economic Development Corporation Audited Wylie Economic Development Corp Ending Balance 09/30/21 $ 2,951,908 Projected '22 Revenues 20,372,472 a) Available Funds 23,324,380 Projected '22 Expenditures (13,502,692) Estimated Ending Fund Balance 09/30/22 $ 9,821,688 Estimated Beginning Fund Balance- 10/01/22 $ 9,821,688 Proposed Revenues '23 8,180,146 Proposed Expenditures '23 (16,143,686) b) Estimated Ending Fund Balance 09/30/23 $ 1,858,148 a) Includes $16.2 MM in Loan Proceeds b) Proposed Sales Tax is an 8.8% increase over the FY 22 Projected and Projected FY 22 is 100%of budget amount (7 month actuals at 61%). Revenues also include an anticipated Gain/Loss Sale of Property in the amount of$3,915,685. 101 PROPOSED BUDGET FY 2023 111-W EDC WEDC REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 40210 SALES TAX $3,875,471 $3,789,966 $3,789,966 $4,124,241 TOTAL TAXES $3,875,471 $3,789,966 $3,789,966 $4,124,241 43518 380 ECONOMIC AGREEMENTS $0 $0 $0 $0 TOTAL INTERGOVERNMENTAL REVENUE $0 $0 $0 $0 46050 CERTIFICATE OF DEPOSIT $0 $0 $0 $0 46110 ALLOCATED INTEREST EARNINGS $1,136 $6,000 $6,000 $6,000 TOTAL INTEREST INCOME $1,136 $6,000 $6,000 $6,000 48110 RENTAL INCOME $135,505 $132,240 $136,240 $134,220 48310 RECOVERY-PRIOR YEAR EXPEND $0 $0 $0 $0 48410 MISCELLANEOUS INCOME $1,435 $0 $0 $0 48430 GAIN/(LOSS)SALE OF CAP ASSETS ($31,208) $2,601,116 $179,721 $3,915,685 TOTAL MISCELLANEOUS INCOME $105,732 $2,733,356 $315,961 $4,049,905 49160 TRANSFER FROM GENERAL FUND $0 $0 $0 $0 49325 BANK NOTE PROCEEDS $0 $8,108,000 $16,216,000 $0 49550 LEASE PRINCIPAL PAYMENTS(OFS) $0 $0 $0 $0 49600 INSURANCE RECOVERIES $40,614 $0 $44,545 $0 TOTAL OTHER FINANCING SOURCES $40,614 $8,108,000 $16,260,545 $0 TOTAL WEDC REVENUES $4,022,953 $14,637,322 $20,372,472 $8,180,146 102 PROPOSED BUDGET FY 2023 111-W EDC WEDC FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $244,095 $286,558 $286,558 $310,346 51130 OVERTIME $1,810 $0 $0 $0 51140 LONGEVITY PAY $588 $729 $729 $914 51310 TMRS $37,687 $44,530 $44,530 $48,245 51410 HOSPITAL AND LIFE INSURANCE $35,148 $49,304 $49,304 $51,987 51415 EXECUTIVE HEALTH PLAN $0 $0 $0 $0 51420 LONG-TERM DISABILITY $951 $1,707 $1,707 $1,769 51440 FICA $14,186 $18,623 $18,623 $19,298 51450 MEDICARE $3,318 $4,355 $4,355 $4,513 51470 WORKERS COMP PREMIUM $247 $391 $391 $855 51480 UNEMPLOYMENT COMP(TWC) $843 $1,080 $1,080 $1,080 TOTAL PERSONNEL SERVICES $338,873 $407,277 $407,277 $439,008 52010 OFFICE SUPPLIES $6,981 $5,000 $5,000 $5,000 52040 POSTAGE AND FREIGHT $31 $300 $300 $300 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 52810 FOOD SUPPLIES $1,493 $6,100 $6,100 $3,000 52990 OTHER $0 $0 $0 $0 TOTAL SUPPLIES $8,505 $11,400 $11,400 $8,300 54610 FURNITURE AND FIXTURES $26,252 $2,500 $7,570 $2,500 54630 TOOLS AND EQUIPMENT $0 $0 $0 $0 54810 COMPUTER HARD/SOFTWARE $5,530 $5,500 $5,500 $7,650 54910 BUILDINGS $0 $0 $0 $0 54990 OTHER $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $31,782 $8,000 $13,070 $10,150 56030INCENTIVES $808,259 $1,043,973 $401,433 $3,209,183 56040 SPECIAL SERVICES $90,799 $1,962,496 $2,470,496 $34,770 56042 SPECIAL SERVICES-INFRASTRUCTURE $0 $0 $0 $8,375,000 56041 SPECIAL SERVICES-REAL ESTATE $0 $0 $0 $276,300 56080 ADVERTISING $55,902 $129,100 $109,100 $129,100 56090 COMMUNITY DEVELOPMENT $20,903 $52,050 $44,550 $54,950 56110 COMMUNICATIONS $4,424 $6,400 $6,400 $7,900 56180 RENTAL $27,167 $27,000 $27,000 $27,000 56210 TRAVEL AND TRAINING $14,028 $74,600 $54,600 $73,000 56250 DUES AND SUBSCRIPTIONS $30,390 $39,810 $45,160 $57,824 56310 INSURANCE $4,770 $6,303 $6,303 $6,303 56510 AUDIT AND LEGAL SERVICES $12,918 $33,000 $23,000 $23,000 56570 ENGINEERING/ARCHITECTURAL $43,690 $189,300 $277,300 $87,500 56610 UTILITIES-ELECTRIC $2,166 $2,400 $2,400 $2,400 TOTAL CONTRACTURAL SERVICES $1,115,414 $3,566,432 $3,467,742 $12,364,230 103 PROPOSED BUDGET FY 2023 111-W EDC WEDC FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 57410 PRINCIPAL PAYMENT $365,464 $5,403,249 $5,041,124 $575,974 57415 INTEREST EXPENSE $206,137 $326,452 $338,198 $656,024 TOTAL DEBT SERVICE AND CAP.REPL $571,601 $5,729,701 $5,379,321 $1,231,998 58110 LAND-PURCHASE PRICE $407,332 $3,983,393 $4,223,882 $2,090,000 58210 STREETS AND ALLEYS $198,555 $2,425,000 $0 $0 58830 FURNITURE AND FIXTURES $797 $0 $0 $0 58995 CONTRA CAPITAL OUTLAY ($407,332) $0 $0 $0 TOTAL CAPITAL OUTLAY $199,352 $6,408,393 $4,223,882 $2,090,000 TOTAL WEDC $2,265,527 $16,131,202 $13,502,692 $16,143,686 104 CITY OF WYLIE 48 SALES TALC REVENUE FUND FUND DESCRIPTION The Wylie Park and Recreation Facilities Development Corporation (the 4B Corporation)was established to promote park and recreational development within the City of Wylie. The activities of the 4B Corporation are accounted for in two fund types. The two funds are titled the 4B Sales Tax Revenue Fund and the 4B Debt Service Fund. The special revenue fund accounts for the use of the 4B Corporation sales tax revenue and is restricted by State legislation to improve the appeal of the City as a place to live,work and visit through the promotion of park and recreational development. Sales taxes are levied in Wylie at 8.2S%of goods and services sold within the City's boundaries. Departments in this fund include 4B Brown House,4B Senior Activities,4B Parks,4B Recreation Center,4B Stonehaven House and 4B Sales Tax Combined Services. 105 City Of Wylie Fund Summary 413 Sales Tax Revenue Fund Audited 4B Sales Tax Revenue Fund Ending Balance 09/30/21 $ 5,121,099 Projected '22 Revenues 4,589,466 Available Funds 9,710,565 Projected '22 Expenditures (4,013,375) a) Estimated Ending Fund Balance 09/30/22 $ 5,697,190 Estimated Beginning Fund Balance- 10/01/22 $ 5,697,190 Proposed Revenues '23 5,091,346 b) Proposed Expenditures '23 (4,361,637) Carryforward Expenditures (678,565) Estimated Ending Fund Balance 09/30/23 $ 5,748,334 c) a) Carry forward items are taken out of projected 2022 expense and included in 2023 expense. See manager's letter for detailed list totalling $678,565. b) Total includes sales tax revenue and revenue from the Recreation Center. c) Policy requirement is 25% of budgeted sales tax revenue ($4,124,146x 25% _ $1,031,037). 106 413 SALES TAX FUND SUMMARY OF REVENUES AND EXPENDITURES 2020-2021 2021-2022 2021-2022 2022-2023 ACTUAL BUDGET PROJECTED PROPOSED REVENUES: Sales Taxes 3,875,471 3,789,966 3,789,966 4,124,146 Service Fees 655,553 552,500 767,500 928,000 Interest&Misc. Income 12,551 18,950 32,000 39,200 Other Financing Sources 47,390 - - - TOTAL REVENUES 4,590,965 4,361,416 4,589,466 5,091,346 EXPENDITURES: Brown House 132,038 360,133 304,133 363,438 Senior Center 405,787 790,537 568,472 796,429 4B Parks 351,569 1,025,706 757,206 1,137,877 Recreation Center 1,712,334 2,003,659 1,991,659 2,202,032 Stonehaven House - 121,000 1,000 121,000 Combined Services 398,079 390,905 390,905 419,426 TOTAL EXPENDITURES 2,999,807 4,691,940 4,013,375 5,040,202 107 PROPOSED BUDGET FY 2023 112-413 SALES TAX 4B SALES TAX REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 40210 SALES TAX $3,875,471 $3,789,966 $3,789,966 $4,124,146 TOTAL TAXES $3,875,471 $3,789,966 $3,789,966 $4,124,146 44150 RECREATION MEMBERSHIP FEES $436,473 $400,000 $450,000 $600,000 44152 RECREATION MERCHANDISE $5,322 $2,500 $2,500 $8,000 44156 RECREATION CLASS FEES $213,758 $150,000 $315,000 $320,000 TOTAL SERVICE FEES $655,553 $552,500 $767,500 $928,000 46110 ALLOCATED INTEREST EARNINGS $1,879 $1,700 $5,000 $7,200 TOTAL INTEREST INCOME $1,879 $1,700 $5,000 $7,200 48120 COMMUNITY ROOM FEES $10,463 $15,000 $25,000 $30,000 48410 MISCELLANEOUS INCOME $209 $2,250 $2,000 $2,000 TOTAL MISCELLANEOUS INCOME $10,672 $17,250 $27,000 $32,000 49600 INSURANCE RECOVERIES $47,390 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $47,390 $0 $0 $0 TOTAL 4B SALES TAX REVENUES $4,590,966 $4,361,416 $4,589,466 $5,091,346 108 CITY OF WYLIE 4B BROWN HOUSE DEPARTMENT DESCRIPTION Under the Parks and Recreation Department,the Recreation Division manages the Welcome Center at Thomas and Mattie Brown House.This division ensures ongoing preservation of Wylie's past by maintaining the historic site.A visit to this establishment serves as a welcome to Wylie's visitors and provides a rare opportunity to glimpse into the City's rich historical background. It is the mission of Wylie Parks and Recreation to spark connection with self,family,and community through meaningful park and recreation experiences. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue to add operating hours to the Welcome Center and reestablish momentum lost during COVID-19. Strategic Goal:Community Focused Government. Continue to enhance the Welcome Center experience with history exhibits,tours,and educational opportunities. Strategic Goal:Community Focused Government Continue to support downtown events,e.g. Boo on Ballard, Bluegrass,and Arts Festival. Strategic Goal:Community Focused Government. FISCAL YEAR 2022 ACCOMPLISHMENTS Facility upgrade:Completed ADA Accessible Ramp and Parking project. Strategic Goal:Community Focused Government. Supported downtown events including, Pedal Car Race, Bluegrass, Boo on Ballard,and Arts Festival. Strategic Goal:Community Focused Government. Curated a History of Wylie exhibit to enhance the guest experience at the Welcome Center. Strategic Goal:Community Focused Government. BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Rec. Supervisor-Brown House 1.0 1.0 1.0 1.0 Recreation Monitor 0.5 0.5 2.5 2.5 Guest Service Specialist 0.5 0.5 3.0 3.0 TOTAL 2.0 2.0 6.5 6.5 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PRO.! TARGET/PROD General Attendance Hourly Headcount 100 400 Celebrations Attendance Free downtown events 5,079 3,000 5,360 5,600 109 PROPOSED BUDGET FY 2023 112-413 SALES TAX BROWN HOUSE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $51,905 $54,144 $54,144 $56,430 51112 SALARIES-PART TIME $13 $76,161 $76,161 $79,398 51130 OVERTIME $0 $1,000 $1,000 $1,000 51140 LONGEVITY PAY $284 $332 $332 $380 51310 TMRS $8,054 $12,692 $12,692 $14,072 51410 HOSPITAL AND LIFE INSURANCE $11,789 $12,876 $12,876 $12,542 51420 LONG-TERM DISABILITY $233 $298 $298 $209 51440 FICA $3,038 $8,162 $8,162 $9,426 51450 MEDICARE $710 $1,909 $1,909 $2,204 51470 WORKERS COMP PREMIUM $291 $167 $167 $175 51480 UNEMPLOYMENT COMP(TWC) $253 $540 $540 $810 TOTAL PERSONNEL SERVICES $76,571 $168,281 $168,281 $176,646 52010 OFFICE SUPPLIES $121 $1,008 $1,008 $1,008 52130 TOOLS/EQUIP(NON-CAPITAL) $1,387 $19,955 $13,955 $14,655 52210 JANITORIAL SUPPLIES $532 $2,621 $2,621 $2,621 52250 MEDICAL AND SURGICAL $40 $360 $360 $360 52310 FUEL AND LUBRICANTS $0 $0 $0 $0 52610 RECREATIONAL SUPPLIES $0 $410 $410 $410 52650 RECREATION MERCHANDISE $0 $8,675 $8,675 $8,675 52710 WEARING APPAREL AND UNIFORMS $0 $450 $450 $450 52810 FOOD SUPPLIES $197 $525 $525 $525 TOTAL SUPPLIES $2,277 $34,004 $28,004 $28,704 54910 BUILDINGS $35,004 $106,050 $56,050 $104,800 TOTAL MATERIALS FOR MAINTENANCE $35,004 $106,050 $56,050 $104,800 56040 SPECIAL SERVICES $13,270 $32,473 $32,473 $32,953 56080 ADVERTISING $0 $5,960 $5,960 $5,960 56110 COMMUNICATIONS $1,101 $1,620 $1,620 $1,500 56140 REC CLASS EXPENSES $0 $2,900 $2,900 $2,900 56180 RENTAL $1,065 $1,900 $1,900 $1,900 56210 TRAVEL AND TRAINING $534 $3,250 $3,250 $3,250 56250 DUES AND SUBSCRIPTIONS $2,217 $3,695 $3,695 $4,825 TOTAL CONTRACTURAL SERVICES $18,186 $51,798 $51,798 $53,288 TOTAL BROWN HOUSE $132,038 $360,133 $304,133 $363,438 110 CITY OF WYLIE 4B SENIOR CENTER DEPARTMENT DESCRIPTION Under the Parks and Recreation Department,the Recreation Division manages the City of Wylie's Recreation offerings at Wylie Senior Recreation Center.The Wylie Senior Recreation Center supports the well-being of Wylie citizens,ages 55 years and older by providing recreational and educational programs.The division ensures the ongoing operations,participation, and marketing of the recreation programs provided by the City of Wylie at the Senior Recreation Center. It is the mission of Wylie Parks and Recreation to spark connection with self,family,and community through meaningful park and recreation experiences. FISCAL YEAR 2023 GOALS AND OBJECTIVES Continue to regain program momentum lost due to COVID-19,and continue to meet increasing and evolving program needs. Strategic Goal:Community Focused Government. Prepare for the upcoming renovation. Strategic Goal:Community Focused Government. Continue to respond to customer needs in regards to equipment and spaces. Strategic Goal: Health,Safety,and Well-Being. FISCAL YEAR 2022 ACCOMPLISHMENTS Programming:Offerings include Special Events(Eighth Annual Senior Prom was postponed from 2020 due to COVID and resumed April 22,2022), Drop In Fitness, Drop In Play, Health and Fitness,The Arts,Outings,and Trips.Continue to get back to pre-COVID offerings including field trips and overnight trips. Partnered with Wellness Center for Older Adults in Plano to offer transportation,counseling services,and informative sessions. Strategic Goal: Health,Safety,and Well-Being. Facility improvements: Broader variety of fitness equipment geared towards 55+with a larger emphasis on health and fitness. Parking lot lighting added. Strategic Goal: Health,Safety,and Well-Being. Provided EOC Logistic Support through vehicles and staffing during Ice Storm 2022 and COVID-19(employee COVID-19 screenings). Strategic Goal: Health,Safety,and Well-Being. Provided a facility and staffing for Elections. Strategic Goal:Community Focused Government. STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Recreation Supervisor 1.0 1.0 1.0 1.0 Rec. Programmer-Senior Activities 1.0 1.0 1.0 1.0 Administrative Assistant 1.0 1.0 1.0 1.0 Guest Services Specialist 1.5 1.5 1.5 1.5 Recreation Monitor 3.0 3.0 3.0 3.0 Bus Driver 0.5 0.5 0.5 0.5 TOTAL 8.0 8.0 8.0 8.0 111 4B SENIOR CENTER CONTINUED ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROJ TARGET/PROJ General Attendance Hourly Headcount 42,501 17,400 37,000 38,500 Paid Activity Participation Registrations:Activities and 1,033 973 1119 1175 Flex Reg Fitness 112 PROPOSED BUDGET FY 2023 112-413 SALES TAX SENIOR CENTER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $133,964 $140,941 $140,941 $146,078 51112 SALARIES-PART TIME $111,339 $154,658 $154,658 $177,515 51130 OVERTIME $2,760 $2,750 $2,750 $2,750 51140 LONGEVITY PAY $812 $948 $948 $1,092 51310 TMRS $27,787 $28,540 $28,540 $30,667 51410 HOSPITAL AND LIFE INSURANCE $28,660 $31,840 $31,840 $31,507 51420 LONG-TERM DISABILITY $600 $766 $766 $541 51440 FICA $14,862 $18,557 $18,557 $20,301 51450 MEDICARE $3,476 $4,343 $4,343 $4,748 51470 WORKERS COMP PREMIUM $1,642 $1,872 $1,872 $1,961 51480 UNEMPLOYMENT COMP(TWC) $3,208 $2,160 $2,160 $2,160 TOTAL PERSONNEL SERVICES $329,110 $387,375 $387,375 $419,320 52010 OFFICE SUPPLIES $1,442 $2,110 $2,110 $1,922 52130 TOOLS/EQUIP(NON-CAPITAL) $11,823 $20,500 $20,500 $10,500 52210 JANITORIAL SUPPLIES $687 $3,535 $3,535 $3,535 52250 MEDICAL AND SURGICAL $745 $1,000 $1,000 $1,200 52310 FUEL AND LUBRICANTS $977 $6,480 $6,480 $9,000 52610 RECREATIONAL SUPPLIES $21,846 $37,050 $37,050 $32,930 52650 RECREATION MERCHANDISE $837 $4,012 $4,012 $4,012 52710 WEARING APPAREL AND UNIFORMS $24 $1,280 $1,280 $1,480 52810 FOOD SUPPLIES $406 $525 $525 $525 TOTAL SUPPLIES $38,790 $76,492 $76,492 $65,104 54530 HEAVY EQUIPMENT $4,604 $13,900 $13,900 $9,500 54910 BUILDINGS $1,197 $26,433 $26,433 $4,900 TOTAL MATERIALS FOR MAINTENANCE $5,801 $40,333 $40,333 $14,400 56040 SPECIAL SERVICES $7,628 $16,885 $16,885 $16,885 56080 ADVERTISING $2,630 $8,659 $8,659 $3,503 56110 COMMUNICATIONS $1,817 $4,344 $4,344 $2,172 56140 REC CLASS EXPENSES $5,813 $11,000 $11,000 $27,025 56180 RENTAL $5,534 $3,748 $3,748 $1,620 56210 TRAVEL AND TRAINING $5,144 $12,150 $12,150 $15,325 56250 DUES AND SUBSCRIPTIONS $3,006 $4,186 $4,186 $5,710 56360 ACTIVENET ADMINISTRATIVE FEES $515 $3,300 $3,300 $3,300 TOTAL CONTRACTURAL SERVICES $32,087 $64,272 $64,272 $75,540 58570 ENGINEERING/ARCHITECTURAL $0 $222,065 $0 $222,065 TOTAL CAPITAL OUTLAY $0 $222,065 $0 $222,065 TOTAL SENIOR CENTER $405,787 $790,537 $568,472 $796,429 113 CITY OF WYLIE 48 PARKS DEPARTMENT DESCRIPTION The 4B Parks Division is responsible for the development and maintenance of parks throughout the City. It is a division of the Parks and Recreation Department. The 4B Sales Tax Revenue Fund,4B Parks,is a supplemental cost-center to the General Fund Parks Department.The sales tax revenue is restricted by State legislation to improve the appeal of the City as a place to live,work,and visit while promoting economic development. FISCAL YEAR 2023 GOALS AND OBJECTIVES Identify new development opportunities at existing parks and dedicated park land. Strategic Goals: Planning Management Continue providing quality maintenance of parks and open spaces. Strategic Goals: Health,Safety,and Well-Being Expand and improve maintenance practices and efficiency. Strategic Goals: Health,Safety,and Well-Being FISCAL YEAR 2022 ACCOMPLISHMENTS Continued quality maintenance to the City's parks,open spaces, playgrounds,and athletic fields. Strategic Goal: Health,Safety,and Well-Being Replaced several aging pieces of equipment(Kubota Tractor,added new spray rig,turf renovator, new Christmas tree). Strategic Goal: Infrastructure Added new irrigation pump to Founders Park Softball Complex. This was needed to split the current system into two separate systems for better efficiency of water management. Strategic Goal: Infrastructure Replaced two softball infields with MasterSeal infield conditioner to improve the playability of the turf during inclement weather conditions. Strategic Goal: Health,Safety,and Well-Being Replaced Valentine Park playground with a modular structure and new swing sets. Strategic Goal: Health,Safety,and Well-Being BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Field Supervisor 1.0 1.0 1.0 1.0 Irrigation Technician 0.0 0.0 0.0 1.0 Equipment Operator II 0.0 0.0 0.0 1.0 Equipment Operator 1 1.0 1.0 1.0 3.0 Maintenance Worker 3.0 3.0 3.0 0.0 TOTAL 5.0 5.0 5.0 6.0 114 4B PARKS CONTINUED ACTIVITY DEMAND/ACTIVITY"WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGET/PROD TARGET/PROD'' Park Pavilion Rental Participants(Non-Profits) 2,560 2,640 4,950 5,500 Park Pavilion Rental Participants(Community Events) 16,000 18,850 30,050 32,500 Local Athletic Youth Sports Participants 2,721 4,639 5,350 5,500 Park Pavilion Rental Participants 2,064 2,995 3,650 4,000 Athletic Field Rental Hours(Local Leagues and Select 160 379 900 1,000 Leagues) Number of Playgrounds in Neighborhood Parks 19 19 22 23 115 PROPOSED BUDGET FY 2023 112-4B SALES TAX 4B PARKS FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $218,264 $224,273 $224,273 $285,293 51130 OVERTIME $9,887 $8,000 $8,000 $14,000 51140 LONGEVITY PAY $2,148 $2,419 $2,419 $2,777 51310 TMRS $35,562 $36,377 $36,377 $46,821 51410 HOSPITAL AND LIFE INSURANCE $42,237 $47,513 $47,513 $63,447 51420 LONG-TERM DISABILITY $977 $1,243 $1,243 $1,146 51440 FICA $14,191 $14,551 $14,551 $18,728 51450 MEDICARE $3,319 $3,403 $3,403 $4,380 51470 WORKERS COMP PREMIUM $2,037 $2,642 $2,642 $3,045 51480 UNEMPLOYMENT COMP(TWC) $1,260 $1,350 $1,350 $1,620 TOTAL PERSONNEL SERVICES $329,883 $341,771 $341,771 $441,257 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $30,000 $30,000 $32,800 52710 WEARING APPAREL AND UNIFORMS $2,805 $4,320 $4,320 $4,320 TOTAL SUPPLIES $2,805 $34,320 $34,320 $37,120 54530 HEAVY EQUIPMENT $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 56040 SPECIAL SERVICES $115 $6,000 $6,000 $1,000 56570 ENGINEERING/ARCHITECTURAL $11,315 $50,000 $50,000 $50,000 TOTAL CONTRACTURAL SERVICES $11,430 $56,000 $56,000 $51,000 58150 LAND-BETTERMENTS $7,450 $185,000 $72,500 $407,500 58570 ENGINEERING/ARCHITECTURAL $0 $301,615 $145,615 $156,000 58850 MAJOR TOOLS AND EQUIPMENT $0 $107,000 $107,000 $15,000 58910 BUILDINGS $0 $0 $0 $30,000 TOTAL CAPITAL OUTLAY $7,450 $593,615 $325,115 $608,500 TOTAL 4B PARKS $351 569 $1,025,706 $757,206 $1,137,877 116 CITY OF WYLIE 4B RECREATION CENTER DEPARTMENT DESCRIPTION ' Within the Parks and Recreation Department,the Recreation Division manages the City's recreational offerings at Wylie Recreation Center.The Wylie Recreation Center supports the well-being of Wylie citizens by providing access to recreational and educational programs.The division ensures the ongoing operations, participation,and marketing of recreational programs at Wylie Recreation Center.This division provides support and supervisory assistance to all recreation programs. It is the mission of Wylie Parks and Recreation to spark connection with self,family,and community through meaningful park and recreation experiences. FISCAL YEAR 2023 GOALS AND OBJECTIVES Meet increasing and evolving program needs. Strategic Goal: Health,Safety,and Well-Being. Continue to upgrade fitness equipment. Strategic Goal: Health,Safety,and Well-Being. Continue to respond to customer needs in regards to current equipment and spaces. Strategic Goal: Health,Safety,and Well-Being. Implement new Rec Pas fees. Financial Health: Meet the financial needs of the City while maintaining a balanced budget through efficient use of resources,expenditures,and revenues. FISCAL YEAR 2022 ACCOMPLISHMENTS Continued to upgrade fitness equipment. Strategic Goal: Health,Safety,and Well-Being. Readers Choice Award for Best Fitness Facility 2022. Strategic Goal: Health,Safety,and Well-Being. Designed and implemented online Rec Pass purchase options. Strategic Goal:Community Focused Government. All registered Special Events sold out including Pumpkins on the Prairie,Gingerbread Workshop, Donuts with Santa,and Easter Bunny Brunch. Strategic Goal:Community Focused Government. Centralized fitness equipment maintenance across the Recreation Division. Strategic Goal: Health,Safety,and Well-Being. 117 46 RECREATION CENTER CONTINUED BUDGET BUDGET BUDGET BUDGET STAFFING 2019-2020 2020-2021 2021-2022 2022-2023 Recreation Manager 1.0 1.0 1.0 0.0 Recreation Supervisor 1.0 1.0 1.0 2.0 Recreation Programmer 3.0 3.0 3.0 3.0 Building Attendant 1.0 1.0 1.0 1.0 Administrative Assistant 1.0 1.0 1.0 1.0 Guest Services Specialist 4.5 4.5 5.0 5.0 Recreation Monitor 13.0 13.0 13.0 13.0 TOTAL 24.5 24.5 25.0 25.0 ACTIVITY DEMAND/ACTIVITY WORKLOAD MEASURE FY 2020 FY 2021 FY 2022 FY 2023 ACTUAL ACTUAL TARGETJPROJ TARGET/PROD General Attendance Hourly Headcount 226,693 267,705 318,600 335,000 Paid Activity Participation Registrations:Activities and 4,300 5,796 5,000 5,250 Flex Reg Fitness Paid Rentals Hours Rented per Year 254 183 210 215 118 PROPOSED BUDGET FY 2023 112-413 SALES TAX RECREATION CENTER FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 51110 SALARIES $349,574 $391,872 $391,872 $376,397 51112 SALARIES-PART TIME $505,824 $527,905 $527,905 $617,905 51130 OVERTIME $5,000 $7,000 $7,000 $7,000 51140 LONGEVITY PAY $2,176 $2,423 $2,423 $2,838 51270 REC INSTRUCTOR PAY $22,464 $35,000 $35,000 $60,000 51310 TMRS $81,106 $80,920 $80,920 $84,261 51410 HOSPITAL AND LIFE INSURANCE $73,357 $98,118 $98,118 $89,064 51420 LONG-TERM DISABILITY $1,544 $2,134 $2,134 $1,393 51440 FICA $53,958 $59,718 $59,718 $62,257 51450 MEDICARE $12,619 $13,966 $13,966 $14,560 51470 WORKERS COMP PREMIUM $7,823 $10,614 $10,614 $10,051 51480 UNEMPLOYMENT COMP(TWC) $12,701 $5,400 $5,400 $5,400 TOTAL PERSONNEL SERVICES $1,128,146 $1,235,070 $1,235,070 $1,331,126 52010 OFFICE SUPPLIES $2,932 $5,852 $5,852 $5,852 52130 TOOLS/EQUIP(NON-CAPITAL) $14,915 $20,370 $20,370 $20,220 52210 JANITORIAL SUPPLIES $10,222 $28,479 $28,479 $28,479 52250 MEDICAL AND SURGICAL $3,529 $4,420 $4,420 $4,420 52310 FUEL AND LUBRICANTS $725 $3,990 $3,990 $6,300 52610 RECREATIONAL SUPPLIES $70,211 $99,035 $99,035 $109,691 52650 RECREATION MERCHANDISE $2,672 $7,475 $7,475 $7,475 52710 WEARING APPAREL AND UNIFORMS $1,628 $7,470 $7,470 $7,470 52810 FOOD SUPPLIES $1,155 $1,200 $1,200 $1,200 TOTAL SUPPLIES $107,988 $178,291 $178,291 $191,107 54530 HEAVY EQUIPMENT $7,376 $21,090 $21,090 $26,090 54910 BUILDINGS $37,462 $45,920 $33,920 $43,720 TOTAL MATERIALS FOR MAINTENANCE $44,839 $67,010 $55,010 $69,810 56040 SPECIAL SERVICES $52,588 $91,370 $91,370 $91,370 56080 ADVERTISING $85,342 $99,977 $99,977 $99,977 56110 COMMUNICATIONS $1,062 $1,800 $1,800 $1,800 56140 REC CLASS EXPENSES $102,440 $76,300 $76,300 $152,650 56180 RENTAL $1,355 $3,300 $3,300 $3,300 56210 TRAVEL AND TRAINING $5,739 $25,600 $25,600 $29,790 56250 DUES AND SUBSCRIPTIONS $6,002 $12,071 $12,071 $13,532 56310INSURANCE $27,614 $35,300 $35,300 $40,000 56360 ACTIVENET ADMINISTRATIVE FEES $39,304 $58,600 $58,600 $58,600 56610 UTILITIES-ELECTRIC $88,950 $98,970 $98,970 $98,970 56630 UTILITIES-WATER $20,966 $20,000 $20,000 $20,000 56660 UTILITIES-GAS $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $431,360 $523,288 $523,288 $609,989 TOTAL RECREATION CENTER $1,712,334 $2,003,659 $1,991,659 $2,202,032 119 CITY OF WYLIE 413 STONEHAVEN HOUSE DEPARTMENT DESCRIPTION Under the Parks and Recreation Department,the Recreation Division manages the maintenance of Stonehaven House.This division ensures ongoing preservation of Wylie's past by maintaining the historic site.Similar to the Brown House,a visit to the Stonehaven House provides another rare opportunity to glimpse into the City's rich historical background. FISCAL YEAR 2023 GOALS AND OBJECTIVES Add utilities and infrastructure Improvements to the house to aid in future preservation efforts. Strategic Goals: Planning Management Discussion with Wylie Historical Society regarding possible shared use of the Stonehaven House and house improvement plan. Strategic Goals: Planning Management FISCAL YEAR 2022 ACCOMPLISHMENTS None 120 PROPOSED BUDGET FY 2023 112-413 SALES TAX STONEHAVEN HOUSE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 54210 STREETS AND ALLEYS $0 $0 $0 $0 54510 MOTOR VEHICLES $0 $0 $0 $0 54530 HEAVY EQUIPMENT $0 $0 $0 $0 54630 TOOLS AND EQUIPMENT $0 $0 $0 $0 54650 COMMUNICATIONS $0 $0 $0 $0 54810 COMPUTER HARD/SOFTWARE $0 $0 $0 $0 54910 BUILDINGS $0 $121,000 $1,000 $121,000 TOTAL MATERIALS FOR MAINTENANCE $0 $121,000 $1,000 $121,000 TOTAL STONEHAVEN HOUSE $0 $121,000 $1,000 $121,000 121 CITY OF WYLI E 4B SALES TAX REVENUE COMBINED SERVICES DEPARTMENT DESCRIPTION This department reflects expenditures incurred by the City's 413 Sales Tax Revenue Fund,as a single entity,in the conduct of its operations. These expenditures include debt service payments,etc. 122 PROPOSED BUDGET FY 2023 112-413 SALES TAX 4B COMBINED SERVICES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 56040 SPECIAL SERVICES $5,829 $7,280 $7,280 $31,376 56310INSURANCE $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $5,829 $7,280 $7,280 $31,376 59125 TRANSFER TO RECREATION FUND $0 $0 $0 $0 59132 TRANSFER TO 413 DEBT SERVICE $392,250 $383,625 $383,625 $388,050 59430 TRANSFER TO CAPITAL PROJ FUND $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $392,250 $383,625 $383,625 $388,050 TOTAL 4B COMBINED SERVICES $398,079 $390,905 $390,905 $419,426 123 CITY OF WYLIE PARKS ACQUISITION & IMPROVEMENT FUN[ DEPARTMENT DESCRIPTION The Park Acquisition and Improvement Fund resources are derived from the payment of fees obtained as part of the development process. Fees are accepted in lieu of parkland dedications to the City. For administrative purposes,the City is divided into three park zones:West,Central,and East. The accumulated funds are available for the acquisition, development and improvement of park land within the zones from which they are collected. The Park Acquisition and Improvement Fund is utilized by the Parks Division with input from the Parks and Recreation Board for the betterment of parks and open spaces throughout the City. Funds are utilized for the purposes of land acquisition for future park development and for the continual improvement of existing parks and open space facilities and amenities. Funds can also be used as matching requirements for available County and State grant opportunities for part acquisition and improvement. FISCAL YEAR 2023 GOALS AND OBJECTIVES West Zone 5621: To improve the overall look of the Municipal Complex Trail and Community Garden by creating a more accessible route and shade to the Community Garden from the Municipal Complex. Strategic Goal: Health,Safety,and Well-Being Central Zone 5622: No projects funded for FY23 East Zone 5623: Complete the renovation to the baseball backstops at Avalon Park. Strategic Goal: Health,Safety,and Well-Being FISCAL YEAR 2022 ACCOMPLISHMENTS West Zone 5621: No projects were funded for FY 21-22 Central Zone 5622: Completed the parking lot lighting for Community Park and the Senior Recreation Center. Strategic Goals: Infrastructure Completed the installation of a new playground at Twin Lakes Park. Strategic Goals: Health,Safety,and Well Being East Zone 5623: No projects were funded for FY 21-22 124 City Of Wylie Fund Summary Park A & I Fund Audited Park A&I Fund Ending Balance 09/30/21 $ 568,319 Projected '22 Revenues 400 Available Funds 568,719 Projected '22 Expenditures (192,419) Estimated Ending Fund Balance 09/30/22 $ 376,300 Estimated Beginning Fund Balance- 10/01/22 $ 376,300 Proposed Revenues '23 511,480 Proposed Expenditures '23 (96,931) Carryforward Expenditures $ - Estimated Ending Fund Balance 09/30/23 $ 790,849 125 PROPOSED BUDGET FY 2023 121-PARKS AANDI PARKS A AND I REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 43514 PARK GRANTS $60,000 $0 $0 $0 TOTAL INTERGOVERNMENTAL REVENUE $60,000 $0 $0 $0 44134 PARK LAND DEVELOPMENT $344,300 $614,500 $0 $511,000 TOTAL SERVICE FEES $344,300 $614,500 $0 $511,000 46110 ALLOCATED INTEREST EARNINGS $320 $353 $400 $480 46140 TEXPOOL INTEREST $0 $0 $0 $0 TOTAL INTEREST INCOME $320 $353 $400 $480 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 48440 CONTRIBUTIONS/DONATIONS $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 49111 TRANSFER FROM GENERAL FUND $0 $0 $0 $0 49131 TRANSFER FROM SPECIAL REVENUE $0 $0 $0 $0 49450 COUNTY PROCEEDS(OFS) $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $0 $0 $0 $0 TOTAL PARKS AANDI REVENUES $404,620 $614,853 $400 $511,480 126 PROPOSED BUDGET FY 2023 121-PARKS AANDI PARKS A AND I WEST ZONE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 52150 NON-CAPITAL IMPROVEMENTS $0 $0 $0 $0 52510 BOTANICAL AND AGRICULTURAL $0 $0 $0 $0 52610 RECREATIONAL SUPPLIES $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 54250 STREET SIGNS AND MARKINGS $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 56040 SPECIAL SERVICES $0 $0 $0 $0 56570 ENGINEERING/ARCHITECTURAL $43,981 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $43,981 $0 $0 $0 58110 LAND-PURCHASE PRICE $0 $0 $0 $0 58150 LAND-BETTERMENTS $28,873 $0 $0 $58,431 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $0 58830 FURNITURE AND FIXTURES $0 $0 $0 $0 58840 OUTDOOR FURNITURE AND EQUIPMENT $0 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $28,873 $0 $0 $58,431 59447 TRANSFER TO 2008 GEN OBLIG $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL PARKS AANDI WEST ZONE $72,854 $0 $0 $58,431 127 PROPOSED BUDGET FY 2023 121-PARKS AANDI PARKS A AND I CENTRAL ZONE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 52150 NON-CAPITAL IMPROVEMENTS $0 $0 $0 $0 52510 BOTANICAL AND AGRICULTURAL $0 $0 $0 $0 52610 RECREATIONAL SUPPLIES $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 54250 STREET SIGNS AND MARKINGS $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 56040 SPECIAL SERVICES $0 $0 $0 $0 56570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $0 56990 OTHER $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $0 $0 $0 $0 58110 LAND-PURCHASE PRICE $0 $0 $0 $0 58150 LAND-BETTERMENTS $79,253 $192,419 $192,419 $0 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $0 58830 FURNITURE AND FIXTURES $0 $0 $0 $0 58840 OUTDOOR FURNITURE AND EQUIPMENT $0 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $0 $0 $0 $0 58910 BUILDINGS $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $79,253 $192,419 $192,419 $0 59447 TRANSFER TO 2008 GEN OBLIG $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL PARKS AANDI CENTRAL ZONE $79,253 $192,419 $192,419 $0 128 PROPOSED BUDGET FY 2023 121-PARKS AANDI PARKS A AND I EAST ZONE FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52150 NON-CAPITAL IMPROVEMENTS $0 $0 $0 $0 52510 BOTANICAL AND AGRICULTURAL $0 $0 $0 $0 52610 RECREATIONAL SUPPLIES $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 54250 STREET SIGNS AND MARKINGS $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 56040 SPECIAL SERVICES $25,000 $0 $0 $0 56570 ENGINEERING/ARCHITECTURAL $94,265 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $119,265 $0 $0 $0 58150 LAND-BETTERMENTS $113,097 $0 $0 $38,500 58570 ENGINEERING/ARCHITECTURAL $0 $0 $0 $0 58830 FURNITURE AND FIXTURES $0 $0 $0 $0 58840 OUTDOOR FURNITURE AND EQUIPMENT $0 $0 $0 $0 58850 MAJOR TOOLS AND EQUIPMENT $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $113,097 $0 $0 $38,500 59447 TRANSFER TO 2008 GEN OBLIG $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL PARKS AANDI EAST ZONE $232,362 $0 $0 $38,500 129 CITY OF WYLIE FIRE TRAINING CENTER FUN[ DEPARTMENT DESCRIPTION The Fire Training Center Fund is a special revenue fund that was established in FY 2001. Expenditures from this fund are related to public safety training,as well as upkeep and maintenance of the fire training facilities. The Fire training center is physically located behind Fire Station 2. The facility is also used as a regional training center by other city departments and area fire departments. Major funding comes from response fees collected within our response area for emergency services rendered. Other funding comes from fees assessed on users. A master use plan has been drawn up that will develop the acres available in order to meet the growing needs due to population and commercial growth. FISCAL YEAR 2023 GOALS AND OBJECTIVES' Expend funds dedicated to the public safety training field to maintain the training facility, improve training offerings,and provide quality training to Wylie public safety personnel. Strategic Goals: Infrastructure;Workforce; Planning Management 130 City Of Wylie Fund Summary Fire Training Center Fund Audited Fire Training Center Fund Ending Balance 09/30/21 $ 238,374 Projected '22 Revenues 29,222 Available Funds 2671596 Projected '22 Expenditures (30,000) Estimated Ending Fund Balance 09/30/22 $ 237,596 Estimated Beginning Fund Balance- 10/01/22 $ 237,596 Proposed Revenues '23 28,728 Proposed Expenditures '23 (45,000) Estimated Ending Fund Balance 09/30/23 $ 221,324 131 PROPOSED BUDGET FY 2023 132-FIRE TRAINING CENTER FIRE TRAINING CENTER REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 42110 FIRST RESPONDER FEES $44,901 $29,000 $29,000 $28,428 TOTAL LICENSE AND PERMITS $44,901 $29,000 $29,000 $28,428 43512 FIRE GRANTS $0 $0 $0 $0 TOTAL INTERGOVERNMENTAL REVENUE $0 $0 $0 $0 46110 ALLOCATED INTEREST EARNINGS $110 $108 $222 $300 46140 TEXPOOL INTEREST $0 $0 $0 $0 TOTAL INTEREST INCOME $110 $108 $222 $300 48110 RENTAL INCOME $0 $0 $0 $0 48310 RECOVERY-PRIOR YEAR EXPEND $0 $0 $0 $0 48440 CONTRIBUTIONS/DONATIONS $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 49111 TRANSFER FROM GENERAL FUND $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $0 $0 $0 $0 TOTAL FIRE TRAINING CENTER REVENUES $45,011 $29,108 $29,222 $28,728 132-FIRE TRAINING CENTER FIRE TRAINING CENTER EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $29,382 $20,000 $20,000 $40,000 52630 AUDIO-VISUAL $0 $10,000 $10,000 $5,000 TOTAL SUPPLIES $29,382 $30,000 $30,000 $45,000 TOTAL FIRE TRAINING CENTER $29,382 $30,000 $30,000 $45,000 132 CITY OF WYLIE FIRE DEVELOPMENT FUND DEPARTMENT DESCRIPTION The Fire Development Fee Fund benefits the City of Wylie by providing a portion of the capital expenditure money to maintain fire protection service levels caused by increases in growth and population.The City established fire development fees by Ordinance No.2007-12.The fund cannot be used for any operations or replacement costs. Projects in the coming years are Fire Station 5 property,and construction of Fire Station 5,as well as the new apparatus for each. FISCAL YEAR 2023 GOALS AND OBJECTIVES Receive revenues from Fire Development Fees Strategic Goals: Financial Health; Economic Growth Began the land location process for construction of Fire Station 5 Strategic Goals: Planning Management, Financial Health FISCAL YEAR 2022 ACCOMPLISHMENTS Completed construction and opened Fire Station#4 Strategic Goals: Planning Management; Financial Health 133 City Of Wylie Fund Summary Fire Development Fund Audited Fire Development Fund Ending Balance 09/30/21 $ 849,300 Projected '22 Revenues 260,860 Available Funds 1,110,160 Projected '22 Expenditures (112,483) a) Estimated Ending Fund Balance 09/30/22 $ 997,677 Estimated Beginning Fund Balance- 10/01/22 $ 997,677 Proposed Revenues '23 236,088 Proposed Expenditures '23 - Carryforward Expenditures $ (101,784) Estimated Ending Fund Balance 09/30/23 $ 1,131,981 a) Carry forward items are taken out of projected 2022 expense and included in 2023 expense. See manager's letter for detailed list totalling $101,784. 134 PROPOSED BUDGET FY 2023 133-FIRE DEVELOPMENT FIRE DEVELOPMENT REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 44127 FIRE DEVELOPMENT REVENUE $255,678 $260,000 $260,000 $234,888 TOTAL SERVICE FEES $255,678 $260,000 $260,000 $234,888 46110 ALLOCATED INTEREST EARNINGS $619 $716 $860 $1,200 TOTAL INTEREST INCOME $619 $716 $860 $1,200 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL FIRE DEVELOPMENT REVENUES $256,297 $260,716 $260,860 $236,088 133-FIRE DEVELOPMENT FIRE DEVELOPMENT EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 56040 SPECIAL SERVICES $0 $55,000 $0 $55,000 56510 AUDIT AND LEGAL SERVICES $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $0 $55,000 $0 $55,000 58110 LAND-PURCHASE PRICE $0 $0 $0 $0 58510 MOTOR VEHICLES $0 $0 $0 $0 58570 ENGINEERING/ARCHITECTURAL $377,842 $159,267 $112,483 $46,784 58580 CONSTRUCTION PROF SERVICES $0 $0 $0 $0 58910 BUILDINGS $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $377,842 $159,267 $112,483 $46,784 59430 TRANSFER TO CAPITAL PROJ FUND $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL FIRE DEVELOPMENT $377,842 $214,267 $112,483 $101,784 135 CITY OF 1 YLIE MUNICIPAL COURT TECHNOLOGY FUND FUND DESCRIPTION Texas Code of Criminal Procedure,Article 102.017, provides for the establishment of the Building Security Fund and the assessment and collection of a Building Security Fee. For offenses occurring on or after January 1,2020,this fund became a component of the Local Consolidated Fee, provided by the Local Government Code,Article 134.103. A person convicted of a misdemeanor offense in the Municipal Court shall pay,in addition to all other costs,the Building Security Fee. This money may only be used for security personnel,services,or items related to buildings that house the operation of a municipal court. 136 City Of Wylie Fund Summary Municipal Court Technology Fund Audited Municipal Court Technology Fund Ending Balance 09/30/21 $ 16,240 Projected '22 Revenues 6,200 Available Funds 22,440 Projected '22 Expenditures (2,000) Estimated Ending Fund Balance 09/30/22 $ 20,440 Estimated Beginning Fund Balance- 10/01/22 $ 20,440 Proposed Revenues '23 8,000 Proposed Expenditures '23 (2,000) Estimated Ending Fund Balance 09/30/23 $ 26,440 137 PROPOSED BUDGET FY 2023 151-MUNICIPAL COURT TECH MUNICIPAL COURT TECH REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 45135 COURT TECHNOLOGY FEES $6,157 $5,000 $6,200 $8,000 TOTAL FINES AND FORFEITURES $6,157 $5,000 $6,200 $8,000 46110 ALLOCATED INTEREST EARNINGS $6 $0 $0 $0 TOTAL INTEREST INCOME $6 $0 $0 $0 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 49111 TRANSFER FROM GENERAL FUND $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $0 $0 $0 $0 TOTAL MUNICIPAL COURT TECH REVENUES $6,163 $5,000 $6,200 $8,000 151-MUNICIPAL COURT TECH MUNICIPAL COURT TECH EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $2,000 $2,000 $2,000 TOTAL SUPPLIES $0 $2,000 $2,000 $2,000 54810 COMPUTER HARD/SOFTWARE $0 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $0 $0 $0 $0 58110 LAND-PURCHASE PRICE $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $0 $0 59430 TRANSFER TO CAPITAL PROJ FUND $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL MUNICIPAL COURT TECH $0 $2,000 $2,000 $2,000 138 CITY OF WYLIE MUNICIPAL COURT BUILDING SECURITY FUN[ FUND DESCRIPTION Texas Code of Criminal Procedure, Article 102.017, provides for the establishment of the Building Security Fund and the assessment and collection of a Building Security Fee. For offenses occurring on or after January 1,2020,this fund became a component of the Local Consolidated Fee, provided by the Local Government Code,Article 134.103. A person convicted of a misdemeanor offense in the Municipal Court shall pay, in addition to all other costs,the Building Security Fee. This money may only be used for security personnel, services, or items related to buildings that house the operation of a municipal court. 139 City Of Wylie Fund Summary Municipal Court Building Security Fund Audited Municipal Court Building Security Fund Ending Balance 09/30/21 $ 24,604 Projected '22 Revenues 7,200 Available Funds 31,804 Projected '22 Expenditures (6,250) Estimated Ending Fund Balance 09/30/22 $ 25,554 Estimated Beginning Fund Balance- 10/01/22 $ 25,554 Proposed Revenues '23 7,000 Proposed Expenditures '23 (9,250) Estimated Ending Fund Balance 09/30/23 $ 23,304 140 PROPOSED BUDGET FY 2023 152-MUNICIPAL COURT BLDG SECURITY MUNICIPAL COURT BLDG SECURITY REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 45136 COURT BLDG SEC FEES $7,248 $5,000 $7,200 $7,000 TOTAL FINES AND FORFEITURES $7,248 $5,000 $7,200 $7,000 46110 ALLOCATED INTEREST EARNINGS $10 $0 $0 $0 TOTAL INTEREST INCOME $10 $0 $0 $0 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 49111 TRANSFER FROM GENERAL FUND $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $0 $0 $0 $0 TOTAL MUNICIPAL COURT BLDG SECURITY REVENUES $7,258 $5,000 $7,200 $7,000 152-MUNICIPAL COURT BLDG SECURITY MUNICIPAL COURT BLDG SECURITY EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 56210 TRAVEL AND TRAINING $200 $6,250 $6,250 $9,250 TOTAL CONTRACTURAL SERVICES $200 $6,250 $6,250 $9,250 58910 BUILDINGS $0 $0 $0 $0 TOTAL CAPITAL OUTLAY $0 $0 $0 $0 59430 TRANSFER TO CAPITAL PROJ FUND $0 $0 $0 $0 TOTAL OTHER FINANCING(USES) $0 $0 $0 $0 TOTAL MUNICIPAL COURT BLDG SECURITY $200 $6,250 $6,250 $9,250 141 CITY OF WYLI E JUDICIAL EFFICIENCY FUN[ FUND DESCRIPTION Local Government Code,Section 133.103, provides for the establishment of the Judicial Efficiency Fee which is a component of the Time Payment Fee. A person convicted of an offense dated on or before December 31, 2019,shall pay, in addition to all other costs,the Time Payment Fee if the person has not satisfied the full payment of fine and court costs on or before the 31st day after the date judgment is entered.Code of Criminal Procedure,Article 102.030, provides for the establishment of the Time Payment Reimbursement Fee. A person convicted of an offense dated on or after January 1,2020,shall pay,in addition to all other costs,the Time Payment Reimbursement Fee if the person has not satisfied the full payment of fine and court costs on or before the 31st day after the date judgment is entered. The money from these fees are to be used for the purpose of improving the efficiency of the administration of justice in the Municipal Court. 142 City Of Wylie Fund Summary Municipal Court Judicial Efficiency Fund Audited Municipal Court Judicial Efficiency Fund Ending Balance 09/30/21 $ 5,423 Projected '22 Revenues 1,900 Available Funds 7,323 Projected '22 Expenditures - Estimated Ending Fund Balance 09/30/22 $ 7,323 Estimated Beginning Fund Balance- 10/01/22 $ 7,323 Proposed Revenues '23 1,000 Proposed Expenditures '23 - Estimated Ending Fund Balance 09/30/23 $ 8,323 143 PROPOSED BUDGET FY 2023 153-MUNICIPAL COURT JUDICIAL EFFICIENCY MUNICIPAL COURT JUDICIAL EFFICIENCY REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 45137 JUDICIAL EFFICIENCY FEES $150 $1,000 $1,900 $1,000 TOTAL FINES AND FORFEITURES $150 $1,000 $1,900 $1,000 46110 ALLOCATED INTEREST EARNINGS $3 $0 $0 $0 TOTAL INTEREST INCOME $3 $0 $0 $0 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MUNICIPAL COURT JUDICIAL EFFICIENCY $153 $1,000 $1,900 $1,000 153-MUNICIPAL COURT JUDICIAL EFFICIENCY MUNICIPAL COURT JUDICIAL EFFICIENCY EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52130 TOOLS/EQUIP(NON-CAPITAL) $0 $0 $0 $0 TOTAL SUPPLIES $0 $0 $0 $0 56210 TRAVEL AND TRAINING $0 $0 $0 $0 TOTAL CONTRACTURAL SERVICES $0 $0 $0 $0 TOTAL MUNICIPAL COURT JUDICIAL EFFICIENCY $0 $0 $0 $0 144 CITY OF WYLIE TRUANCY COURT FUN[ FUND DESCRIPTION Texas Family Code,Section 65.107, provides the establishment of a Truant Conduct court cost. The court may order a person who is found to have engaged in truant conduct,to pay a Truant Conduct court cost. The money from this cost may only be used to offset the cost of the operations of the truancy court. 145 Citv Of Wvlie Fund Summary Truancy Court Fund Audited Truancy Court Fund Ending Balance 09/30/21 $ 16,830 Projected '22 Revenues 2,400 Available Funds 19,230 Projected '22 Expenditures (1,000) Estimated Ending Fund Balance 09/30/22 $ 18,230 Estimated Beginning Fund Balance- 10/01/22 $ 18,230 Proposed Revenues '23 3,000 Proposed Expenditures '23 (1,000) Estimated Ending Fund Balance 09/30/23 $ 20,230 146 PROPOSED BUDGET FY 2023 154-TRUANCY COURT TRUANCY COURT REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 45142 TRUANT CONDUCT FEE $850 $1,500 $2,400 $3,000 TOTAL FINES AND FORFEITURES $850 $1,500 $2,400 $3,000 46110 ALLOCATED INTEREST EARNINGS $8 $0 $0 $0 TOTAL INTEREST INCOME $8 $0 $0 $0 TOTAL TRUANCY COURT REVENUES $858 $1,500 $2,400 $3,000 154-TRUANCY COURT TRUANCY COURT EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 56510 AUDIT AND LEGAL SERVICES $0 $1,000 $1,000 $1,000 TOTAL CONTRACTURAL SERVICES $0 $1,000 $1,000 $1,000 TOTAL TRUANCY COURT $0 $1,000 $1,000 $1,000 147 CITY OF WYLIE MUNICIPAL JURY FUND FUND DESCRIPTION Local Government Code,Section 134.103, provides the Municipal Jury Fee as a component of the Local Consolidated Fee. A person convicted of a misdemeanor offense shall pay, in addition to all other costs,the Municipal Jury Fee. This money may only be used only to fund juror reimbursements and otherwise finance jury services. 148 City Of Wylie Fund Summary Municipal Jury Audited Municipal Jury Fund Ending Balance 09/30/21 199 Projected '22 Revenues 140 Available Funds 339 Projected '22 Expenditures - Estimated Ending Fund Balance 09/30/22 $ 339 Estimated Beginning Fund Balance- 10/01/22 $ 339 Proposed Revenues '23 1,000 Proposed Expenditures '23 - Estimated Ending Fund Balance 09/30/23 1,339 149 PROPOSED BUDGET FY 2023 155-MUNICIPAL JURY MUNICIPAL JURY REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 45143 MUNICIPAL JURY FEES $138 $100 $140 $1,000 TOTAL FINES AND FORFEITURES $138 $100 $140 $1,000 46110 ALLOCATED INTEREST EARNINGS $0 $0 $0 $0 TOTAL INTEREST INCOME $0 $0 $0 $0 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $0 $0 $0 $0 TOTAL MUNICIPAL JURY REVENUES $138 $100 $140 $1,000 150 CITY OF WYLIE HOTEL OCCUPANCY TAX FUND FUND DESCRIPTION The Hotel Occupancy Tax was created by Ordinance No. 2004-23 amending Section 106-42 of the Wylie Code of Ordinances. The Hotel Occupancy Tax is imposed on a person who pays for a room or space in a hotel costing$15.00 or more each day. The Hotel Occupancy Tax is levied (i) upon the cost of occupancy of any room or space furnished by any hotel where such cost of occupancy is at the rate of$2.00 or more per day,such tax to be equal to seven percent(7%)of the consideration paid by the occupant of such room,space or facility to such hotel,exclusive of other occupancy taxes imposed by other governmental agencies,(ii)and hotel occupancy tax provided herein shall be imposed in the city extraterritorial jurisdiction, provided, however,that the levy of such taxes shall not result in a combined rate of state,county or municipal hotel occupancy taxes in the extraterritorial jurisdiction which exceeds fifteen percent(15%)of the price paid for a room in a hotel. 151 City Of Wylie Fund Summary Hotel Occupancy Tax Fund Audited Hotel Occupancy Tax Fund Ending Balance 09/30/21 $ 549,370 Projected '22 Revenues 322,720 Available Funds 872,090 Projected '22 Expenditures (240,700) Estimated Ending Fund Balance 09/30/22 $ 631,390 Estimated Beginning Fund Balance- 10/01/22 $ 631,390 Proposed Revenues '23 228,660 Proposed Expenditures '23 (129,200) Carryforward Expenditures 0 Estimated Ending Fund Balance 09/30/23 $ 730,850 46 PROPOSED BUDGET FY 2023 161-HOTEL OCCUPANCY TAX HOTEL OCCUPANCY TAX REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 40230 HOTEL OCCUPANCY TAX $171,308 $200,000 $322,248 $228,000 TOTAL TAXES $171,308 $200,000 $322,248 $228,000 46110 ALLOCATED INTEREST EARNINGS $232 $200 $472 $660 TOTAL INTEREST INCOME $232 $200 $472 $660 TOTAL HOTEL OCCUPANCY TAX REVENUES $171,540 $200,200 $322,720 $228,660 161-HOTEL OCCUPANCY TAX HOTEL OCCUPANCY TAX EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 54910 BUILDINGS $12,950 $0 $0 $0 TOTAL MATERIALS FOR MAINTENANCE $12,950 $0 $0 $0 56040 SPECIAL SERVICES $0 $35,000 $35,000 $60,000 56080 ADVERTISING $21,105 $35,000 $35,000 $35,000 TOTAL CONTRACTURAL SERVICES $21,105 $70,000 $70,000 $95,000 58150 LAND BETTERMENTS $0 $70,200 $70,200 $0 58570 ARCHITECTURAL/ENGINEERING $22,605 $0 $0 $0 58910 BUILDINGS $6,721 $70,500 $70,500 $0 TOTAL CAPITAL OUTLAY $29,326 $140,700 $140,700 $0 59180 TRANSFER TO PUBLIC ARTS $30,000 $30,000 $30,000 $34,200 TOTAL OTHER FINANCING(USES) $30,000 $30,000 $30,000 $34,200 TOTAL HOTEL OCCUPANCY TAX $93,381 $240,700 $240,700 $129,200 153 CITY OF WYLIE PUBLIC ARTS FUND DEPARTMENT DESCRIPTION The Public Arts Advisory Board consists of seven members,appointed by the City Council for a two year term. The Public Arts Advisory Board was created by Ordinance No.2006-37. Funding for the public arts program is accomplished by annually designating one(1)percent of eligible CIP funding for public art,which is derived from the City's capital project fund,enterprise fund and/or grants.Additional funding is raised through community events focused on the arts. Through the Public Art Advisory Board, provide a variety of public art, in all disciplines,to create an environment of creativity, history and quality of life for all. Provide quality visual and performing art events to attract citizens and visitors to the City and provide creativity, innovation,and variety through art, music,and literature. FISCAL YEAR 2023 GOALS AND OBJECTIVES The Advisory Board will purchase an entry piece to be placed at the Y behind City hall to begin the History of the Blackland Prairie theme for the Municipal Trails. Strategic Goal:Culture-Education Continue plans for two pieces of art each year to be placed along the trails of the Municipal Complex. Strategic Goals: Infrastructure;Culture Continue providing and facilitating visual and performing art events to attract citizens and visitors to the City: Wylie Arts Festival—Expand the Wylie Arts Festival to include more vendors and attract larger audiences Bluegrass on Ballard-Expand vendors for the Bluegrass on Ballard Strategic Goals:Community Focused Government;Culture FISCAL YEAR 2022 ACCOMPLISHMENTS Provided quality visual performing art events including a variety of music and innovative and creative arts and craft vendors. Events included: Completed"NEVER FORGET"for Fire Station#4 2021 Wylie Arts Festival—Revenue$26,000(over 155 art vendors) 2021 Bluegrass on Ballard-Revenue$17,000(125 art/craft vendors) Strategic Goals:Culture Continue discussions regarding future calls for artists for sculptures along the Municipal Trails using events funding. Strategic Goals: Infrastructure;Culture 154 City Of Wylie Fund Summary Public Arts Fund Audited Public Arts Fund Ending Balance 09/30/21 $ 521,710 Projected '22 Revenues 70,523 Available Funds 592,233 Projected '22 Expenditures (116,600) Estimated Ending Fund Balance 09/30/22 $ 475,633 Estimated Beginning Fund Balance- 10/01/22 $ 475,633 Proposed Revenues '23 74,920 Proposed Expenditures '23 (7,600) Carryforward Expenditures $ (112,000) a) Estimated Ending Fund Balance 09/30/23 $ 430,953 a) Carry forward for Municipal Trail Sculptures 155 PROPOSED BUDGET FY 2023 175-PUBLIC ARTS PUBLIC ARTS REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 46110 ALLOCATED INTEREST EARNINGS $240 $228 $523 $720 TOTAL INTEREST INCOME $240 $228 $523 $720 48130 ARTS FESTIVAL $42,492 $40,000 $40,000 $40,000 48410 MISCELLANEOUS INCOME $0 $0 $0 $0 48440 CONTRIBUTIONS/DONATIONS $0 $0 $0 $0 TOTAL MISCELLANEOUS INCOME $42,492 $40,000 $40,000 $40,000 49140 TRANSFER FROM CAP PROJ FUND $65,000 $0 $0 $0 49161 TRANSFER FROM HOTEL TAX $30,000 $30,000 $30,000 $34,200 49170 TRANSFER FROM GEN OBLIG 2006 $0 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $95,000 $30,000 $30,000 $34,200 TOTAL PUBLIC ARTS REVENUES $137,732 $70,228 $70,523 $74,920 175-PUBLIC ARTS PUBLIC ARTS EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 52010 OFFICE SUPPLIES $379 $1,600 $1,600 $1,600 52810 FOOD SUPPLIES $0 $0 $0 $0 TOTAL SUPPLIES $379 $1,600 $1,600 $1,600 56040 SPECIAL SERVICES $21,940 $26,000 $25,000 $6,000 56080 ADVERTISING $0 $0 $0 $0 56610 UTILITIES-ELECTRIC $0 $5,500 $0 $0 TOTAL CONTRACTURAL SERVICES $21,940 $31,500 $25,000 $6,000 58150 LAND-BETTERMENTS $10,000 $202,000 $90,000 $112,000 TOTAL CAPITAL OUTLAY $10,000 $202,000 $90,000 $112,000 TOTAL PUBLIC ARTS $32,318 $235,100 $116,600 $119,600 156 City Of Wylie Fund Summary General Obligation Debt Service Fund Audited GO Debt Service Fund Ending Balance 09/30/21 $ 1,122,215 Projected '22 Revenues 8,698,395 Available Funds 9,820,610 Projected '22 Expenditures (8,994,212) Estimated Ending Fund Balance 09/30/22 $ 826,398 Estimated Beginning Fund Balance- 10/01/22 $ 826,398 Proposed Revenues '23 9,060,058 Proposed Expenditures '23 (9,429,005) Estimated Ending Fund Balance 09/30/23 $ 457,451 157 PROPOSED BUDGET FY 2023 311-G O DEBT SERVICE G O DEBT SERVICE REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 40110 PROPERTY TAXES-CURRENT $8,380,569 $8,656,273 $8,656,273 $9,017,658 40120 PROPERTY TAXES-DELINQUENT $55,118 $40,000 $40,000 $40,000 40190 PENALTY AND INTEREST-TAXES $32,721 $0 $0 $0 TOTAL TAXES $8,468,409 $8,696,273 $8,696,273 $9,057,658 46110 ALLOCATED INTEREST EARNINGS $1,229 $3,800 $2,122 $2,400 TOTAL INTEREST INCOME $1,229 $3,800 $2,122 $2,400 49300 BOND PREMIUM FROM DEBT ISSUE $641,594 $0 $0 $0 49500 BONDS ISSUED $4,855,000 $0 $0 $0 TOTAL OTHER FINANCING SOURCES $5,496,594 $0 $0 $0 TOTAL G O DEBT SERVICE REVENUES $13,966,231 $8,700,073 $8,698,395 $9,060,058 311-G O DEBT SERVICE G O DEBT SERVICE EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 57110 DEBT SERVICE $6,035,000 $6,345,000 $6,345,000 $6,820,000 57210 DEBT SERVICE-INTEREST $2,503,950 $2,641,212 $2,641,212 $2,601,005 57310 DEBT SERVICE-FISCAL AGENT FEES $4,800 $8,000 $8,000 $8,000 57420 BOND ISSUE COSTS $77,381 $0 $0 $0 TOTAL DEBT SERVICE AND CAP.REPL $8,621,131 $8,994,212 $8,994,212 $9,429,005 59400 PAYMENT TO REFUNDING AGENT $5,521,619 $0 $0 $0 TOTAL OTHER FINANCING(USES) $5,521,619 $0 $0 $0 TOTAL G O DEBT SERVICE $14,142,750 $8,994,212 $8,994,212 $9,429,005 158 City Of Wylie Fund Summary 413 Debt Service Funds Audited 4B Debt Service Funds Ending Balance 09/30/21 $ 186,132 Projected '22 Revenues 383,625 Available Funds 569,757 Projected '22 Expenditures (383,625) Estimated Ending Fund Balance 09/30/22 $ 186,132 Estimated Beginning Fund Balance- 10/01/22 $ 186,132 Proposed Revenues '23 388,050 Proposed Expenditures '23 (388,050) Estimated Ending Fund Balance 09/30/23 $ 186,132 159 PROPOSED BUDGET FY 2023 313-413 DEBT SERVICE FUND 2013 4B DEBT SERVICE REVENUES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 49131 TRANSFER FROM SPECIAL REVENUE $0 $0 $0 $0 49132 TRANSFER FROM 4B REVENUE $392,250 $383,625 $383,625 $388,050 TOTAL OTHER FINANCING SOURCES $392,250 $383,625 $383,625 $388,050 TOTAL 4B DEBT SERVICE REVENUES $392,327 $383,625 $383,625 $388,050 313-413 DEBT SERVICE FUND 2013 4B DEBT SERVICE EXPENDITURES FY 2021 FY 2022 FY 2022 FY 2023 ACTUAL BUDGET PROJECTED PROPOSED 57110 DEBT SERVICE $345,000 $345,000 $345,000 $360,000 57210 DEBT SERVICE-INTEREST $47,250 $38,625 $38,625 $28,050 TOTAL DEBT SERVICE AND CAP.REPL $392,250 $383,625 $383,625 $388,050 TOTAL 4B DEBT SERVICE $392,250 $383,625 $383,625 $388,050 160 CITY OF WYLIE PROPERTY TAX SUPPORTED DEBT DEBT SERVICE REQUIREMENTS FISCAL YEAR 2022-2023 Required Required Total Principal Interest Required 2022-2023 2022-2023 2022-2023 GENERAL OBLIGATION BONDS: 2013 410,000 32,100 442,100 2015 2,155,000 547,875 2,702,875 2016 2,890,000 906,000 3,796,000 2021 700,000 148,700 848,700 2022 125,000 593,341 718,341 TOTAL 6,280,000 2,228,016 8,508,016 COMBINATION TAX & REVENUE CERTIFICATES OF OBLIGATION: 2018 340,000 246,231 586,231 2021 200,000 126,756 326,756 TOTAL 540,000 372,987 91.2,987 TOTAL PROPERTY TAX SUPPORTED DEBT SERVICE REQUIREMENTS: 6,820,000 2,601,003 9,421,003 161 CITY OF WYLIE UTILITY FUND SUPPORTED DEBT DEBT SERVICE REQUIREMENTS FISCAL YEAR 2022-2023 Required Required Total Principal Interest Required 2022-2023 2022-2023 2022-2023 GENERAL OBLIGATION BONDS: 2016 415,000 104,375 519,375 TOTAL 415,000 104,375 519,375 COMBINATION TAX & REVENUE CERTIFICATES OF OBLIGATION: 2017 330,000 218,31.9 548,31.9 TOTAL 330,000 218,31.9 548,319 TOTAL UTILITYFUND SUPPORTED DEBT SERVICE REQUIREMENTS: 745,000 322,694 1,067,694 162 CITY OF WYLIE 4B SALES TAX SUPPORTED DEBT DEBT SERVICE REQUIREMENTS FISCAL YEAR 2022-2023 Required Required Total Principal Interest Required 2022-2023 2022-2023 2022-2023 GENERAL OBLIGATION BONDS (FUND 313): 2013 360,000 28,050 388,050 TOTAL 360,000 28,050 388,050 163 CITY OF WYLIE PROPERTY TAX SUPPORTED DEBT TOTAL DEBT SERVICE REQUIREMENTS Period Total Ending Principal Interest Debt Service GENERAL OBLIGATION BONDS: 9/30/2023 6,280,000 2,228,016 8,508,016 9/30/2024 6,650,000 1,755,925 8,405,925 9/30/2025 6,970,000 1,439,150 8,409,150 9/30/2026 7,325,000 1,107,050 8,432,050 9/30/2027 7,680,000 755,100 8,435,100 9/30/2028 8,285,000 390,900 8,675,900 9/30/2029 1,985,000 167,200 2,152,200 9/30/2030 275,000 122,000 397,000 9/30/2031 290,000 110,700 400,700 9/30/2032 305,000 98,800 403,800 9/30/2033 270,000 88,650 358,650 9/30/2034 275,000 80,475 355,475 9/30/2035 285,000 72,075 357,075 9/30/2036 295,000 63,375 358,375 9/30/2037 305,000 54,375 359,375 9/30/2038 315,000 45,075 360,075 9/30/2039 320,000 35,550 355,550 9/30/2040 330,000 25,800 355,800 9/30/2041 340,000 15,750 355,750 9/30/2042 355,000 5,325 360,325 TOTAL 49,135,000 8,661,291 57,796,291 164 CITY OF WYLIE PROPERTY TAX SUPPORTED DEBT TOTAL DEBT SERVICE REQUIREMENTS Period Total Ending Principal Interest Debt Service COMBINATION TAX&REVENUE CERTIFICATES OF OBLIGATION: 9/30/2023 540,000 372,987 912,987 9/30/2024 560,000 350,987 910,987 9/30/2025 585,000 328,087 913,087 9/30/2026 605,000 304,287 909,287 9/30/2027 630,000 279,587 909,587 9/30/2028 650,000 253,987 903,987 9/30/2029 680,000 229,537 909,537 9/30/2030 705,000 206,212 911,212 9/30/2031 730,000 183,387 913,387 9/30/2032 760,000 162,837 922,837 9/30/2033 780,000 143,366 923,366 9/30/2034 810,000 122,913 932,913 9/30/2035 835,000 101,387 936,387 9/30/2036 860,000 78,791 938,791 9/30/2037 885,000 54,916 939,916 9/30/2038 915,000 30,012 945,012 9/30/2039 325,000 14,481 339,481 9/30/2040 330,000 8,750 338,750 9/30/2041 335,000 2,931 337,931 TOTAL 12,520,000 3,229,442 1.5,749,442 165 CITY OF WYLIE UTILITY FUND SUPPORTED DEBT TOTAL DEBT SERVICE REQUIREMENTS Period Total Ending Principal Interest Debt Service GENERAL OBLIGATION BONDS: 9/30/2023 415,000 104,375 519,375 9/30/2024 435,000 83,125 518,125 9/30/2025 460,000 60,750 520,750 9/30/2026 480,000 37,250 51.7,250 9/30/2027 505,000 12,625 517,625 TOTAL 2,295,000 298,125 2,593,125 COMBINATION TAX&REVENUE CERTIFICATES OF OBLIGATION: 9/30/2023 330,000 218,31.9 548,319 9/30/2024 340,000 204,919 544,919 9/30/2025 350,000 191,119 541,1.19 9/30/2026 360,000 176,919 536,919 9/30/2027 370,000 162,31.9 532,319 9/30/2028 385,000 147,219 532,219 9/30/2029 400,000 131,51.9 531,519 9/30/2030 420,000 117,219 537,219 9/30/2031 435,000 104,394 539,394 9/30/2032 450,000 90,838 540,838 9/30/2033 470,000 76,463 546,463 9/30/2034 490,000 61,156 551,156 9/30/2035 510,000 44,906 554,906 9/30/2036 530,000 27,675 557,675 9/30/2037 555,000 9,362 564,362 TOTAL 6,395,000 1,764,346 8,159,346 166 CITY OF WYLIE 4B SALES TAX SUPPORTED DEBT TOTAL DEBT SERVICE REQUIREMENTS Period Total Ending Principal Interest Debt Service GENERAL OBLIGATION BONDS (FUND 313): 9/30/2023 360,000 28,050 388,050 9/30/2024 370,000 1.7,100 387,1.00 9/30/2025 385,000 5,775 390,775 TOTAL 1,115,000 50,925 1,165,925 167 CAPITAL IMPROVEMENT PROGRAM SUMMARY FY 2023 - 2027 m w ^^w m a •m w w ® o e ® a w ENG 1BE STREET E FM 544(STONE RD PHASE III) 447 2005 BOND $ 5,400,000 IN PROGRESS $ - $ 2,654,785 $ 2,745,215 $ 5,400,000 S ENG 1BE STREET E FM 544(STONE RD PHASE III) 415 COUNTY $ 4,521,250 IN PROGRESS $ 300,000 $ 2,000,000 $ 2,221,250 $ 4,221,250 ENG 1CD STREET McMILLEN DR(McCREARY RD TO COUNTRY CLUB RD) 415 COUNTY $ 5,827,500 IN PROGRESS $ 1,500,000 $ 2,290,379 $ 2,037,121 $ 4,327,500'r ENG 1CD STREET McMILLEN DR(McCREARY RD TO COUNTRY CLUB RD) 471 2021 BOND $ 20,600,000 IN PROGRESS $ - $ 7,000,000 $ 8,000,000 $ 5,600,000 $ 20,600,000 ENG 1CD STREET McMILLEN DR(McCREARY RD TO COUNTRY CLUB RD) UNFUNDED $ 462,500 IN PROGRESS $ - $ 462,500 $ 462,500 I ENG 1DA STREET EUBANKS LN(HWY 78 TO NTMWD DRIVE) 413 WEST THOR IF $ 95,200 IN PROGRESS $ - $ 95,200 $ 95,200 ENG 1DA STREET EUBANKS LN(HWY 78 TO NTMWD DRIVE) 414 EAST THOR IF $ 633,900 IN PROGRESS $ 200,000 $ 434,000 $ 434,000+ ENG STREET PARK BLVD(COUNTRY CLUB DR TO FM 2514) 471 2021 BOND $ 10,000,000 IN PROGRESS $ 200,000 $ 1,000,000 $ 5,000,000 $ 3,800,000 $ 9,800,000 ENG STREET PARK BLVD(COUNTRY CLUB DR TO FM 2514) 415 COUNTY $ 2,000,000 IN PROGRESS $ - $ 200,000 $ 1,800,000 $ 2,000,000 ENG 1DB STREET ANN DR(KAMBER LN TO FM 2514) 413 WEST THOR IF $ 1,450,000 FUTURE/UNFUNDED $ 98,000 $ ENG STREET SANDEN BLVD(FM 544 to SH 78) 413 WEST THOR IF $ 1,100,000 PLANNED $ - $ 300,000 $ 800,000 $ 1,100,000 ENG STREET SANDEN BLVD(FM 544 to SH 78) EDC WEDC $ 2,000,000 PLANNED/UNFUNDED $ $ 2,000,000 $ 2,000,000 ENG STREET ALANIS DR(SH 78 TO S BALLARD AVE) 414 EAST THOR IF $ 2,000,000 PLANNED $ - $ 250,000 $ 1,750,000 $ 2,000,000 ENG STREET HENSLEY LANE(WOODBRIDGE PKWY TO SANDEN) 413 WEST THOR IF $ 2,170,000 PLANNED $ $ 600,000 $ 1,570,000 $ 2,170,000 ENG STREET HENSLEY LANE(WOODBRIDGE PKWY TO SANDEN) EDC WEDC $ 3,000,000 PLANNED/UNFUNDED $ - $ 3,000,000 $ 3,000,000 s PW STREET MISC STREETS&ALLEYS 472 2021 BOND $ 10,000,000 IN PROGRESS $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ 2,000,000 $ '. 8,000,000 PW STREET DOWNTOWN-IMPROVEMENTS(GENERAL) 473 2021 BOND $ 5,000,000 IN PROGRESS $ - $ 2,197,280 $ 1,000,000 $ 1,000,000 $ 802,720 $ 5,000,000 ENG STREET DOWNTOWN-JACKSON AVE(BROWN STTO FM 2514) 413 WEST THOR IF $ 720,000 PLANNED $ $ 720,000 $ 720,000 ENG STREET +.DOWNTOWN-BIRMINGHAM ST(MARBLE ST TO E BROWN ST) 413 WEST THOR IF $ 650,000 PLANNED $ - $ 650,000 $ 650,000 ENG STREET DOWNTOWN-BALLARD ST(SH 78 TO BROWN ST) 413 WEST THOR IF $ 30,000 PLANNED $ - $ 30,000 $ 30,000 PW STREET SIDEWALKS 470 GFFB $ 600,000 PLANNED $ 380,975 $ 219,025 $ 219,025 PW STREET DRAINAGE REHAB PROJECTS 470 GFFB $ 500,000 PLANNED $ 23,925 $ 476,075 $ 476,075 ENG 2CC WATER +.BALLARD ELEVATED STORAGE TANK 613 WATER IF $ 4,500,000 IN PROGRESS $ - $ 2,000,000 $ 2,500,000 $ `, 4,500,000 ENG WATER BALLARD ELEVATED STORAGE TANK(24"DISTRIBUTION LINE) 613 WATER IF $ 275,000 IN PROGRESS $ 46,757 $ 228,243 $ 228,243 ENG 2CC WATER BALLARD ELEVATED STORAGE TANK 625 CO $ 1,646,768 IN PROGRESS $ 566,000 $ 1,080,768 $ 1,080,768 ENG WATER SH 78 DISTRIBUTION LINE NO.2(E BROWN TO EUBANKS) 613 WATER IF $ 573,400 PLANNED $ - $ 573,400 $ 573,400 ENG I WATER COTTON BELT AVE WATERLINE REPLACEMENT 613 WATER IF $ 133,000 PLANNED $ - $ 133,000 $ 133,000 ENG WATER SH 78&SPRING CREEK PKWY LOOP 613 WATER IF $ 976,000 PLANNED $ $ 976,000 $ 976,000 ENG WW ICITY-WIDE SYSTEM CAPACITY STUDY 613 WWIF $ 250,000 PLANNED $ - $ 250,000 $ 250,000 ENG DALLAS CO SACHSE RD(COUNTRY CLUB DR TO DALLAS CO LINE) 471 2021 BOND $ 4,500,000 IN PROGRESS $ $ 1,500,000 $ 3,000,000 $ 4,500,000 ENG DALLAS CO PLEASANT VALLEY RD(DALLAS CO LIMITS TO CITY LIMITS) 414 EAST THOR IF $ 600,000 FUTURE/UNFUNDED $ 36,198 $ 563,802 $ 563,802 ENG DALLAS CO PLEASANT VALLEY RD(DALLAS CO LIMITS TO CITY LIMITS) UNFUNDED $ 4,000,000 FUTURE/UNFUNDED $ - $ 2,000,000 $ 2,000,000 $ 4,000,000 ENG COLLIN CO PLEASANT VALLEY RD(COLLIN CO TO DALLAS CO) 415 COUNTY $ 2,000,000 FUTURE/UNFUNDED $ - $ 2,000,000 $ 2,000,000 ENG TXDOT HSIP INT IMPROVEMENTS(FM 544/MCCREARY&HWY 78/BROWN) 425 TXDOT $ 1,300,000 IN PROGRESS $ 300,000 $ 1,000,000 $ 1,000,000 I FIRE FIRE STATION#4 461 FIRE CNST $ 8,570,000 IN PROGRESS $ 7,689,098 $ 567,994 $ 567,994 FIRE TWO QUINTS AND UTILITY VEHICLE 470 GFFB $ 3,153,062 IN PROGRESS $ - $ 3,153,062 $ 3,153,062 4B PARKS TWO SPLASHPADS 470 GFFB $ 1,300,000 IN PROGRESS $ - $ 1,300,000 $ 1,300,000 4B PARKS DOGPARK 470 GFFB $ 700,000 IN PROGRESS $ $ 700,000 $ 700,000 4B SRC SRC REMODEL 470 GFFB $ 750,000 IN PROGRESS $ - $ 750,000 $ 750,000 SUBTOTAL $ 113,987,580 $ 13,340,953 $ 33,990,613 $ 31,396,986 $ 16,895,500 $ 10,128,720 $ 6,570,000 $ 98,981,819 168