The URL can be used to link to this page

Home My WebLink AboutOrdinance 3600 ORDINANCE NO. 3600 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, ADOPTING THE BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2019 THROUGH SEPTEMBER 30, 2020, IN ACCORDANCE WITH THE CHARTER OF THE CITY OF NORTH RICHLAND HILLS, TEXAS; PROVIDING FOR THE FILING OF THE BUDGET; ADOPTING THE AMENDED BUDGET FOR OCTOBER 1, 2018 THROUGH SEPTEMBER 30, 2019, PROVIDING FOR INVESTMENTS AND TRANSFERS; PROVIDING A SEVERABILITY CLAUSE AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the City of North Richland Hills is a home rule city acting under its charter adopted by the electorate pursuant to Article XI, Section 5 of the Texas Constitution and Chapter 9 of the Local Government Code; and WHEREAS, the City Manager of the City of North Richland Hills submitted an amended budget for the fiscal year beginning October 1, 2018, and ending September 30, 2019 to the City Council as required by the City Charter of the City of North Richland Hills; and WHEREAS, the City Manager of the City of North Richland Hills submitted a proposed budget for the ensuing fiscal year beginning October 1, 2019, and ending September 30, 2020 to the City Council at least forty-five (45) days prior to the beginning of the fiscal year as required by the City Charter of the City of North Richland Hills; and WHEREAS, the proposed budget meets the requirements of Title 4, Chapter 102, Section 102.003 of Texas Local Government Code; and WHEREAS, the City Council finds that all provisions pertaining to the adoption of the proposed budget and approval of the amended budget contained in the City Charter and in state law have been, in all things complied with; and WHEREAS, in accordance with Section 102.001, et seq, Texas Local Government Code, the City Council determined that a public hearing should be held at a time and place which was set forth in a notice published as required by law; and WHEREAS, such public hearing on the budget was duly held on August 26, 2019, and all taxpayers were given an opportunity to attend and participate in such public hearing; and WHEREAS, after full and final consideration, the City Council is of the opinion that the budget should be approved and adopted. Ordinance No. 3600 Page 1 of 3 NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, THAT: SECTION 1. The budget of revenues and expenditures of the City of North Richland Hills for the Fiscal Year beginning October 1, 2019 and ending September 30, 2020, as set forth in Attachments A and B, operating and capital projects budgets for FY 2019/2020, is hereby adopted and approved as the said City of North Richland Hills budget for the Fiscal Year beginning the first day of October, 2019, and ending the thirtieth day of September, 2020. SECTION 2. The revised budget of revenues and expenditures of the City of North Richland Hills for the Fiscal Year beginning October 1, 2018 and ending September 30, 2019, as set forth in Attachments A and B, operating and capital projects budgets for FY 2018/2019, is hereby amended. SECTION 3. The budget for Fiscal Year 2019/2020 and the amended budget for Fiscal Year 2018/2019 are on file with the City Secretary in accordance with state law and the City Charter. SECTION 4. The City Manager is hereby authorized to make inter-departmental and inter-fund transfers during the fiscal year as deemed necessary in order to avoid over-expenditure of particular accounts. SECTION 5. The City Manager, or his designee, is hereby authorized to invest any funds not needed for current use in any lawful manner. Interest accrued from investments shall be deposited to the interest income account of the funds from which the principal was invested. SECTION 6. This ordinance shall be cumulative of all provisions of ordinances and of the Code of Ordinances, City of North Richland Hills, Texas, as amended, except where the provisions are in direct conflict with the provisions of other ordinances, in which event the conflicting provisions of the other ordinances are hereby repealed. SECTION 7. It is hereby declared to be the intention of the City Council that the phrases, clauses, sentences, paragraphs and sections of this ordinance are severable, and if any phrase, clause, sentence, paragraph or section of this ordinance shall be declared unconstitutional by the valid judgment or decree of any court of competent jurisdiction, such unconstitutionality shall not affect any of the remaining phrases, clauses, sentences, paragraphs and sections of this ordinance, since the same would have been enacted by the City Council without the incorporation in this ordinance of any . such unconstitutional phrase, clause, sentence, paragraph or section. Ordinance No. 3600 Page 2 of 3 SECTION 8. This ordinance shall be in full force and effect from and after its passage as provided by law, and it is so ordained. AND IT IS SO ORDAINED PASSED AND APPROVED on this 9th day of September, 2019. CITY F ORT RI LAND HILLS By: scar re , Mayor �\,\��`j6S6Uf117s��e'/`J, ATTEST:611A(A016,e-r)t' 7 Alicia Richardson, City cros ary ''°'''''' 44/ pj, APPROVED AS TO FORM AND LEGALITY: Maleshia B. McGinnis, City Attorney APPROVED AS TO CONTENT: Robert yers, Budget & Research Director Ordinance No. 3600 Page 3 of 3 Ordinance No. 3600 Attachment A City of North Richland Hills Fiscal Year 2019/2020 Proposed Budget This budget will raise more total property taxes than last year's budget by $1 ,939,300 or 6.1 percent, and of that amount $462,347 is tax revenue to be raised from new property added to the tax roll this year. The total amount of municipal debt obligations secured by property taxes for the City of North Richland Hills is$121,140,000. Visit our website at:www.nrhtx.com Ordinance No.3600 Attachment A Page 1 of 31 lir -AV — it r , '\ ---- ,_ . , ' ' . —=:------ : _____--------=------------------===_.....--. 1 , -,.- ....:473,. .- -' ' - "' " - . i _________,..77___ 0,•,,, .. ...i....,..i..1.i..., z ,_ ,,,.........____i , rfiL„...,,es , ,,„ ,,,,i,___„(air„,..,___t,„„, _....,...„....„ _________ .,, ,,,2 ,,,, . 1, . 1--.. ,7P,S--..11 j .„„,,..... ,...... 7.... ..,....... , C.70.—,11 .1.,v,,--) ' ---'''. ,tewii, , ' d w, -- ---0 „-, ---= f ,--,. _ -fir I --�— ILI 4r---- I z.> 11; --j J V ,-j kj '14fr �; � I _ 1 -- - .� —== e�ea�M wur��r-G�ifeua4wy- _p .� � ��_ _ ems--=- PROPOSED OPERATING BUDGET FISCAL YEAR 2019-20 City of North Richland Hills Email: Budget@nrhtx.com Tel: 817.426.6053 Website: www.nrhtx.com 4301 City Point Dr. North Richland Hills, TX 76180 NRH •r•mance lo. ... ''ac men Page 2 of 31 FISCAL YEAR 2019-2020 SUMMARY OF REVENUES AND EXPENDITURES CITY-WIDE FUNDS AT A GLANCE ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES General Fund $ 46,543,427 $ 47,755,865 $ 48,363,805 $ 48,379,814 $ 50,307,203 General Debt Service 13,338,381 11,771,459 12,187,902 12,200,011 12,211,310 Park and Recreation Facilities Development Fund 9,850,226 9,279,770 8,949,141 9,507,055 9,479,683 Crime Control District Fund 6,409,746 5,449,405 5,567,958 5,709,184 5,727,125 Promotional Fund 283,127 310,526 285,500 290,000 290,000 Donations Fund 402,600 442,730 327,802 367,862 301,164 Special Investigations Fund 298,123 144,569 261,325 261,325 262,300 Drainage Utility Fund 1,193,790 1,337,876 1,649,755 920,000 1,657,000 1 Gas Development Fund 456,827 561,724 528,300 1,576,800 1,487,479 Traffic Safety Fund 1,130,060 1,062,521 1,096,015 843,129 86,726 Utility Fund 33,513,452 37,067,738 35,364,459 34,866,435 38,233,116 Aquatic Park Fund 5,583,880 3,826,627 4,568,509 4,183,593 4,506,323 Golf Course Fund 2,687,743 2,403,235 2,601,454 2,566,361 1,651,547 TOTAL REVENUES $ 121,691,383 $ 121,414,046 $ 121,751,925 $ 121,671,569 $ 126,200,976 EXPENDITURES General Fund $ 45,280,398 $ 46,577,212 $ 48,363,805 $ 48,379,814 $ 50,307,203 General Debt Service 13,314,573 11,732,877 12,187,902 12,090,571 12,211,310 Park and Recreation Facilities Development Fund 9,711,159 8,877,840 8,949,141 9,507,055 9,479,683 Crime Control District Fund 6,359,027 5,275,825 5,567,958 5,709,184 5,727,125 Promotional Fund 238,336 240,320 285,500 290,000 290,000 Donations Fund 269,185 291,176 298,388 329,755 264,388 Special Investigations Fund 299,653 117,183 261,325 261,325 262,300 1 Drainage Utility Fund 1,097,838 1,190,272 1,649,755 920,000 1,657,000 Gas Development Fund 70,174 520,485 528,300 1,576,800 1,487,479 Traffic Safety Fund 1,044,272 974,374 1,096,015 843,129 86,726 Utility Fund 32,654,650 36,191,047 35,364,459 34,866,435 38,233,116 Aquatic Park Fund 5,583,881 4,373,834 4,568,509 4,183,593 4,506,323 Golf Course Fund 2,762,464 2,435,847 2,601,454 2,566,361 1,651,547 TOTAL EXPENDITURES $ 118,685,609 $ 118,798,292 $ 121,722,511 $ 121,524,022 $ 126,164,200 BALANCE $3,005,774 $2,615,754 $29,414 $147,547 $36,776 Note:The City-Wide total excludes TIF debt of$2,175,789 and Internal Service Funds$27,223,942.Internal Service funds are funded by allocation payments made by the major funds and therefore,are not included to prevent double counting those transfers. INTERNAL SERVICE FUNDS Facilities and Construction Mgmt Fund $ 2,824,185 $ 2,733,615 $ 2,985,340 $ 3,083,460 $ 2,982,718 Fleet Services Fund 3,338,280 3,930,351 4,591,313 5,204,463 4,511,499 1 Self Insurance Fund 13,704,271 13,197,105 15,058,070 15,312,226 15,788,103 Information Technology Fund 3,185,276 3,281,041 3,641,821 3,992,770 3,941,622 TOTAL EXPENDITURES $ 23,052,012 $ 23,142,112 $ 26,276,544 $ 27,592,919 $ 27,223,942 Ordinance No.3600 Attachment A Page 3 of 31 FISCAL YEAR 2019-2020 SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 . FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Taxes $31,174,148 $32,290,436 $33,675,379 $33,486,913 $35,342,093 Fines&Forfeitures 2,212,430 1,973,660 2,137,226 2,028,210 2,110,367 Licenses&Permits 2,670,456 2,538,181 2,205,100 2,483,973 2,440,521 Charges for Service 2,373,761 2,245,180 2,458,053 2,338,850 2,842,585 Intergovernmental 5,433,392 5,270,464 5,515,015 5,339,928 5,325,176 Miscellaneous 2,549,240 3,102,861 2,373,032 2,513,220 2,141,661 SUB-TOTAL $46,413,427 $47,420,782 $48,363,805 $48,191,094 $50,202,403 APPROPRIATION FROM FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Fund 130,000 49,950 0 3,436 59,800 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 0 0 45,000 Record Preservation Fee 0 0 0 0 0 Previous Year Encumbrances 0 285,133 0 185,284 0 General Fund Reserves 0 0 0 0 0 SUB-TOTAL APPROPRIATIONS $130,000 $335,083 $0 $188,720 $104,800 TOTAL REVENUES $46,543,427 $47,755,865 $48,363,805 $48,379,814 $50,307,203 EXPENDITURES City Council $123,193 $106,691 $133,893 $141,383 $133,893 City Manager 637,328 667,721 686,945 687,474 734,957 Communications 363,033 360,103 383,452 391,254 394,874 City Secretary 407,739 425,931 460,637 460,813 475,819 Legal 292,596 363,156 411,439 411,615 429,510 Human Resources 130,520 144,405 136,869 137,116 141,545 Finance 698,913 701,536 746,670 751,068 771,524 Budget&Research 354,072 392,588 417,313 417,312 427,236 Municipal Court 1,420,784 1,331,385 1,402,604 1,339,806 1,394,917 Planning and Inspections 1,129,531 1,283,774 1,334,141 1,353,280 1,318,419 Economic Development 322,752 313,961 350,163 317,164 350,958 Library 2,102,149 2,134,157 2,219,861 2,222,683 2,282,980 Neighborhood Services 1,722,233 1,882,428 2,071,606 2,054,924 2,105,253 Public Works 3,110,625 3,126,989 3,340,412 3,291,137 3,411,978 Parks&Recreation 2,083,853 2,023,686 2,138,611 2,106,796 2,158,075 Police 13,473,858 14,544,932 15,014,364 15,109,861 15,879,537 Emergency Management 976,835 0 0 0 0 Fire 11,608,211 12,943,835 13,621,936 13,508,055 14,317,885 Building Services 836,737 812,101 812,101 812,101 812,101 Non-Departmental 841,749 1,008,854 1,111,037 1,359,255 1,095,643 SUB-TOTAL DEPARTMENTS $42,636,711 $44,568,231 $46,794,054 $46,873,097 $48,637,104 RESERVES&OTHER EXPENDITURES Reserves $1,369,492 $1,218,753 $137,259 $137,735 $148,684 Transfers Out 513,055 560,280 1,229,492 1,229,492 1,387,423 Other 761,140 229,948 203,000 139,490 133,992 SUB-TOTAL RESERVES AND OTHER $2,643,687 $2,008,981 $1,569,751 $1,506,717 $1,670,099 TOTAL EXPENDITURES $45,280,398 $46,577,212 $48,363,805 $48,379,814 $50,307,203 BALANCE $1,263,029 $1,178,653 $0 $0 $0 Ordinance No.3600 Attachment A Page 4 of 31 FISCAL YEAR 2019-2020 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 TAXES Current Property Taxes $15,609,935 $16,178,973 $17,279,976 $17,344,725 $19,099,518 Delinquent Property Taxes 98,895 147,739 217,977 90,000 207,396 Penalty and Interest 135,401 143,598 135,200 198,428 135,200 Franchise Fees 3,968,853 3,997,024 4,064,328 4,158,340 3,828,538 Utility Fund Franchise Taxes 895,441 1,003,680 1,020,989 938,800 1,116,527 Sales Taxes 9,929,417 10,281,105 10,395,887 10,189,931 10,398,713 Mixed Beverages 145,222 145,495 145,333 151,000 151,000 Payment in Lieu of Taxes 390,983 392,821 415,689 415,689 405,201 SUB-TOTAL $31,174,148 $32,290,436 $33,675,379 $33,486,913 $35,342,093 1 FINES AND FORFEITURES Municipal Court Fines $1,954,602 $1,763,618 $1,888,650 $1,825,510 $1,868,450 Warrant&Arrest Fees 198,758 156,735 188,576 153,700 181,917 Library Fines 59,070 53,307 60,000 49,000 60,000 SUB-TOTAL $2,212,430 $1,973,660 $2,137,226 $2,028,210 $2,110,367 LICENSES AND PERMITS Building Permits $1,405,784 $1,142,662 $1,140,560 $1,270,000 $1,270,000 Electrical Permits 61,695 80,706 63,600 63,600 63,600 Plumbing Permits 146,448 137,375 134,567 126,950 126,950 Mechanical Permits 107,875 147,131 87,980 131,000 117,900 Gas Drilling Permits 0 226 0 0 0 Burglar Alarm Permits 83,940 107,735 86,800 93,000 93,000 Miscellaneous Permits 89,873 82,104 91,328 80,494 77,124 Apartment Inspection Fees 100,877 101,747 104,800 102,400 102,400 Curb&Drainage Insp.Fees 142,307 110,665 62,569 108,099 123,659 Re-Inspection Fees 29,829 35,868 24,000 32,000 32,000 License Fees 22,185 35,084 19,000 31,000 19,000 Contractor Registration Fees 89,265 79,608 0 31,813 0 Plan/Review/Application Fee 94,778 73,680 38,743 71,564 82,335 Animal License/Adoption Fees 72,631 69,435 73,500 60,500 62,000 Animal Control Impoundment 22,837 12,614 23,000 17,300 17,300 Auto Impoundment Fees 15,463 14,315 15,200 15,200 15,200 I. Food Service Permits 158,581 171,733 161,053 161,053 161,053 Food Managers School 7,177 5,381 5,400 4,000 4,000 Fire Inspection/Alarm Fees 18,911 130,113 73,000 84,000 73,000 SUB-TOTAL $2,670,456 $2,538,181 $2,205,100 $2,483,973 $2,440,521 CHARGES FOR SERVICE Park Facility Rental $9,074 $6,645 $10,050 $10,150 $10,050 Ambulance Fees 1,688,414 1,620,898 1,727,500 1,664,125 1,725,625 Ambulance Supplemental Program 0 0 0 0 400,000 Garbage Billing 448,063 466,786 485,108 473,000 482,460 Contributions 10,000 10,000 10,000 10,000 10,000 Recreation Fees 700 875 770 875 875 Athletic Revenue 107,979 21,737 123,250 84,657 112,600 Recreation Special Events (240) 3,810 4,000 2,068 4,000 Planning&Zoning Fees 43,547 50,109 40,000 45,000 38,000 Sale of Accident Reports 7,435 9,151 7,300 8,900 8,900 Vital Statistics 0 0 0 0 0 Mowing 51,749 48,699 44,000 34,000 44,000 Fire Dept Certification/CPR Citizen Class 6,946 6,117 6,000 6,000 6,000 Miscellaneous 95 352 75 _ 75 75 SUB-TOTAL $2,373,761 $2,245,180 $2,458,053 $2,338,850 $2,842,585 Ordinance No.3600 Attachment A Page 5 of 31 FISCAL YEAR 2019-2020 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 INTERGOVERNMENTAL Indirect Costs: Utility Fund 2,304,572 2,304,572 2,304,572 2,304,572 2,182,170 Park&Rec Facilities Dev.Corp. 498,988 500,885 499,065 499,003 497,541 Crime Control District 52,124 31,678 29,858 29,796 28,334 Aquatic Park Fund 166,631 0 174,963 0 0 Consolidation Reimbursements 2,411,077 2,433,328 2,506,557 2,506,557 2,617,131 SUB-TOTAL $5,433,392 $5,270,464 • $5,515,015 $5,339,928 $5,325,176 MISCELLANEOUS Interest Income $129,320 $208,466 $208,700 $243,988 $243,988 Radio Reimbursement 257,395 265,117 273,607 255,605 273,607 Sale of City Property 258,962 376,319 3,000 3,000 3,000 Grant Proceeds 0 52,760 54,000 54,000 54,000 Overtime Reimbursements 13,866 7,693 5,000 281 281 Teen Court Reimbursement 20,300 0 20,114 40,228 20,114 Other Income 122,348 592,505 708,611 816,118 812,615 Golf Course Loan Repayment 147,760 0 0 0 0 Designated Funds for City Hall Project Debt 1,599,289 1,600,000 1,100,000 1,100,000 734,056 SUB-TOTAL $2,549,240 $3,102,861 $2,373,032 $2,513,220 $2,141,661 APPROPRIATION-FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Funds 130,000 49,950 0 3,436 59,800 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 0 0 45,000 Record Preservations Fee 0 0 0 0 0 Previous Year Encumbrances 0 285,133 0 185,284 0 General Fund Designated Reserves _ 0 0 0 0 0 SUB-TOTAL $130,000 $335,083 . $0 $188,720 $104,800 TOTAL REVENUES $46,543,427 $47,755,865 $48,363,805 $48,379,814 $50,307,203 Ordinance No.3600 Attachment A Page 6 of 31 FISCAL YEAR 2019-2020 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 EXPENDITURES City Council(2) $123,193 $106,691 $133,893 $141,383 $133,893 City Manager $637,328 $667,721 $686,945 $687,474 $734,957 Communications Public Information $244,572 $249,457 $262,583 $270,033 $269,961 Citicable 118,461 110,647 120,869 121,221 124,913 Total Communications $363,033 $360,103 $383,452 $391,254 $394,874 City Secretary City Secretary(1) $310,602 $339,247 $350,211 $350,387 $363,037 Record Management 97,137 86,684 110,426 110,426 112,782 Total City Secretary $407,739 $425,931 $460,637 $460,813 $475,819 Legal $292,596 $363,156 $411,439 $411,615 $429,510 Human Resources $130,520 $144,405 $136,869 $137,116 $141,545 Finance Accounting&Administration $455,438 $450,858 $477,828 $480,946 $493,471 Purchasing") 243,475 250,678 268,842 270,122 278,053 Total Finance $698,913 $701,536 $746,670 $751,068 $771,524 Budget&Research Budget") $135,721 $176,790 $189,442 $189,441 $195,086 Tax 201,806 215,798 227,871 227,871 232,150 Internal Audit 16,546 0 0 0 0 Total Budget&Research $354,072 $392,588 $417,313 $417,312 $427,236 Municipal Court Administration/Prosecution $451,630 $394,051 $365,597 $369,385 $370,677 Court Records 468,705 439,969 505,872 493,685 502,929 Warrants 407,834 399,782 419,683 364,932 405,224 Teen Court 92,615 97,583 111,452 111,804 116,087 Total Municipal Court $1,420,784 $1,331,385 $1,402,604 $1,339,806 $1,394,917 Planning and Development Planning&Administration 325,297 347,042 361,699 362,079 312,311 • Inspections 804,234 936,731 972,442 991,201 1,006,108 Total Planning and Development $1,129,531 $1,283,774 $1,334,141 $1,353,280 $1,318,419 Economic Development $322,752 $313,961 $350,163 $317,164 $350,958 Library General Services $357,178 $386,836 $405,116 $405,116 $420,030 Public Services 894,607 910,014 944,292 945,703 961,320 Technical Services 850,364 837,307 870,453 871,864 901,630 Total Library $2,102,149 $2,134,157 $2,219,861 $2,222,683 $2,282,980 Ordinance No.3600 Attachment A Page 7 of 31 FISCAL YEAR 2019-2020 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 Neighborhood Services Neighborhood Resources $307,995 $328,015 $352,655 $353,007 $363,738 Animal Services 704,283 773,642 819,985 814,474 818,581 Consumer Health 317,846 328,222 349,760 349,760 361,449 Code Compliance 392,109 452,548 549,206 537,683 561,485 Total Neighborhood Services $1,722,233 $1,882,428 $2,071,606 $2,054,924 $2,105,253 Public Works General Services $307,407 $334,521 $359,393 $364,656 $380,905 Traffic Control 1,171,674 1,110,455 1,099,309 1,094,030 1,115,755 Street&Drainage 1,631,544 1,682,013 1,881,710 1,832,451 1,915,318 Total Public Works $3,110,625 $3,126,989 $3,340,412 $3,291,137 $3,411,978 Parks&Recreation General Services $168,557 $171,285 $178,450 $178,626 $182,141 Parks Maintenance 940,970 928,964 926,488 925,193 949,265 Recreation Services 487,102 487,102 487,102 487,102 487,102 Athletic Program Services 171,090 117,002 197,355 170,743 201,047 Senior Adult Services 276,754 279,796 303,080 298,996 292,384 Youth Outreach&Cultural 39,379 39,537 46,136 46,136 46,136 Total Parks&Recreation $2,083,853 $2,023,686 $2,138,611 $2,106,796 $2,158,075 Police General Services $1,134,358 $1,240,294 $1,201,242 $1,337,803 $1,329,485 Administrative Services 557,921 545,450 602,247 638,672 596,676 Criminal Investigations 2,500,286 2,580,558 2,738,937 2,786,010 2,885,473 Uniform Patrol 5,292,948 5,901,507 5,939,640 5,945,664 6,306,802 Detention Services 1,530,825 1,584,123 1,717,916 1,662,269 1,781,505 Property Evidence 314,122 516,137 367,896 413,157 511,216 Communications 2,143,397 2,176,863 2,446,486 2,326,286 2,468,380 Total Police $13,473,858 $14,544,932 $15,014,364 $15,109,861 $15,879,537 Emergency Management $976,835 $0 $0 $0 $0 Fire Department General Services $398,372 $443,436 $440,811 $441,684 $450,379 Operations 8,794,648 9,288,668 9,850,851 9,846,422 10,583,039 Emergency Medical 1,770,525 1,605,761 1,758,750 1,737,123 1,781,242 Fire Inspections 644,666 652,836 705,206 666,586 702,910 Emergency Management 0 953,134 866,318 816,240 800,315 Total Fire $11,608,211 $12,943,835 $13,621,936 $13,508,055 $14,317,885 Building Services $836,737 $812,101 $812,101 $812,101 $812,101 Non Departmentalc2) $841,749 $1,008,854 $1,111,037 $1,359,255 $1,095,643 SUB-TOTAL DEPARTMENTS $42,636,711 $44,568,231 , $46,794,054 $46,873,097 $48,637,104 Ordinance No.3600 Attachment A Page 8 of 31 FISCAL YEAR 2019-2020 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 RESERVES&OTHER EXPENDITURES Other Economic Development Incentives $234,630 $211,948 $203,000 $139,490 $133,992 Legal Settlement 526,510 18,000 0 0 0 Other Total $761,140 $229,948 $203,000 $139,490 $133,992 Transfers Capital Projects $180,000 $61,297 $1,094,000 $1,094,000 $1,000,000 Capital Projects-Sidewalk Maintenance 50,000 386,258 50,000 50,000 50,000 Fleet Services 0 0 0 0 0 Special Investigations 105,080 0 0 0 0 Information Services 77,975 82,725 85,492 85,492 193,954 Transfer to Crime Control District Fund 0 0 0 0 143,469 Neighborhood Revitalization Program 100,000 30,000 0 0 0 Transfers Total $513,055 $560,280 $1,229,492 $1,229,492 $1,387,423 Contribution to Reserves General Fund Reserves $1,215,141 $1,218,753 $6,066 $6,066 $18,264 Public,Educational,Governmental(PEG)Fees 154,351 0 131,193 131,669 130,420 Tranportation Projects(Future) 0 0 0 0 0 Contribution to Reserves Total $1,369,492 $1,218,753 $137,259 $137,735 $148,684 TOTAL RESERVES&OTHER EXPENDITURES $2,643,687 $2,008,981 $1,569,751 $1,506,717 $1,670,099 TOTAL EXPENDITURES $45,280,398 $46,577,212 $48,363,805 $48,379,814 $50,307,203 BALANCE $1,263,029 $1,178,653 $0 $0 $0 As required by Local Government Code 140.0045 as added in the 85th Legislature(S.B.622)and amended in the 86th Legislature(H.B. 1495). (1) Legal Notice Expenditures for FY 18-19 were$8,350 and for the FY 19-20 Proposed Budget are$8,800. (2) Legislative advocacy expenditures for FY 18-19 were$63,477 and for the FY 19-20 Proposed Budget are$63,477. Ordinance No.3600 Attachment A Page 9 of 31 FISCAL YEAR 2019-2020 SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: M&O I&S TOTAL Total Appraised Value as of July 25,2019 7,543,068,265 Less: Absolute Exemption (350,523,519) Cases Before ARB (268,684,754) Incomplete Accounts (131,258,328) Disabled Veteran (31,947,089) Over 65 (194,564,265) Homestead (561,600,896) Disabled Persons (9,586,564) Freeport Inventory Value Loss (4,417,238) Pollution Control (293,015) Solar&Wind Powered Devices (7) Nominal Value Accounts (1,249,094) Miscellaneous Personal Property (31,151,466) In Process (386,151) Total Reduction to Values (1,585,662,386) NET TAXABLE VALUE AT JULY 25,2019 5,957,405,879 Add: Estimated Minimum ARB protested values 156,965,647 Incomplete Property 72,505,768 In Process 0 ESTIMATED NET TAXABLE VALUE AT JULY 25,2019 6,186,877,294 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 6,186,877,294 Less:TIF#1 Incremental Value(Closed 2018) 0 Less:TIF#1A Incremental Value(Closed 2019 0 Less:TIF#2 Incremental Value (547,772,944) Less:Tax Ceiling Taxable Values (914,281,198) Net Taxable Values 4,724,823,152 Proposed.TaxRate per$100 Valuation- 0.334938 0.237062:..... 0.572000 Estimated Total Tax Levy at 100%Collection 15,825,228 11,200,798 27,026,026 Less:Estimated Uncollectable(1.5%) (237,378) (237,378) Less:Estimated I&S Uncollectable(1.5%) (168,012) (168,012) Estimated Revenue from Property Tax 15,419,838 11,200,798 26,620,636 Estimated Revenue from Property Tax 15,419,838 11,200,798 26,620,636 Plus:Tax Ceiling Account Revenue 3,724,760 - 3,724,760 Less:Estimated Uncollectable(1.5%) (55,871) - (55,871) Plus:TIF Tax Rate Differential(0.002000) 10,955 - 10,955 Less:Estimated I&S Uncollectable(1.5%) (164) - (164) ESTIMATED PROPERTY TAX DISTRIBUTION 19,099,518 11,200,798 30,300,316 Ordinance No.3600 Attachment A Page 10 of 31 FISCAL YEAR 2019-2020 SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES General Debt Service Taxes $9,674,703 $10,683,052 $11,315,208 $11,315,208 $11,200,798 SUB-TOTAL AD VALOREM TAXES $9,674,703 $10,683,052 $11,315,208 $11,315,208 $11,200,798 Transfer in From: Drainage Utility $373,018 $362,674 $261,139 $268,276 $278,599 Park&Rec.Facilities Dev.Corp 320,393 627,685 524,550 524,555 509,030 Fleet Services Fund 448,414 0 0 0 130,911 Facilities Services Fund 26,193 0 0 0 0 Donations Fund 41,400 0 0 0 0 SUB-TOTAL TRANSFER IN $1,209,418 $990,359 $785,689 $792,831 $918,540 Proceeds Bond Issuance Proceeds $1,754,180 $0 $0 $0 $0 Interest Income 8,415 15,195 4,152 9,119 9,119 City of Watauga,CIP Participation 82,853 82,853 82,853 82,853 82,853 Miscellaneous Revenues 1,092 0 0 0 0 Transfer In 607,721 0 0 0 0 Appropriation of Fund Balance 0 0 0 0 0 SUB-TOTAL OTHER $2,454,260 $98,048 $87,005 $91,972 $91,972 TOTAL REVENUES $13,338,381 $11,771,459 $12,187,902 $12,200,011 $12,211,310 EXPENDITURES Existing Bonds&C.O.'s $11,539,266 $11,724,762 $12,146,203 $12,048,872 $12,202,610 Issuance Costs/Paying Agent Fees 93,288 8,115 41,699 41,699 8,700 Bond Defeaseance/Refunding 1,682,019 0 0 0 0 TOTAL EXPENDITURES $13,314,573 $11,732,877 $12,187,902 $12,090,571 $12,211,310 BALANCE $23,809 $38,582 $0 $109,440 $0 Ordinance No.3600 Attachment A Page 11 of 31 FISCAL YEAR 2019-2020 SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: TAX INCREMENT FINANCING DISTRICT#2 Taxable Value(2019 Tax Year) $558,442,812 Less: Base Taxable Value(1998 Tax Year) 40,020,188 Taxable Value Increment(2019 Tax Year) Gain/(Loss): $518,422,624 ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE TAX INCREMENT FINANCING DISTRICT#2 Current Taxable Value Increment:TIF District#2 $518,422,624 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#2 Property Tax Revenue at 100% $2,955,009 Estimated Collection Rate 98.50% Estimated TIF District#2 Property Tax Revenue $2,910,684 TOTAL ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE(1)(2) $2,910,684 Notes: (1)The information presented on this schedule represents the contribution of the City of North Richland Hills to the Tax Increment Financing Districts in which it participates. This schedule does not reflect the contribution of other entities. (2)TIF#1 Closed in 2018.TIF#1A Closed in 2019. Ordinance No.3600 Attachment A Page 12 of 31 FISCAL YEAR 2019-2020 SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 TAX INCREMENT FINANCING DISTRICT#1 REVENUES Tax Increment Financing District#1 Taxes City of North Richland Hills 45,432 $110,702 $95,408 $95,408 $0 Tarrant County Hospital District 18,164 37,547 38,178 38,178 0 Tarrant County College District 11,536 27,208 23,816 23,816 0 Tarrant County 0 36,325 41,507 41,507 0 Birdville ISD 115,882 121,009 0 0 0 Sub-Total 191,014 $332,791 $198,909 $198,909 $0 Other Funding Sources Investment Income 3,313 $649 $11,440 $20,403 $20,403 Bond Defeasance/Refunding Proceeds 0 0 0 0 0 Appropriation of Fund Balance 471,719 433,935 0 0 0 Sub-Total 475,032 $434,584 $11,440 $20,403 $20,403 TOTAL REVENUES 666,047 $767,374 $210,349 $219,312 $20,403 EXPENDITURES&TRANSFERS TIF#1 Debt Service 666,046 $659,532 $111,958 $111,958 $210 Bond Defeasance/Refunding 0 0 0 0 0 TOTAL EXPENDITURES 666,046 $659,532 $111,958 $111,958 $210 BALANCE 0 $107,843 $98,391 $107,354 $20,193 TAX INCREMENT FINANCING DISTRICT#2 REVENUES Tax Increment Financing District#2 Taxes City of North Richland Hills 1,896,052 $2,321,974 $2,610,197 $2,610,197 $2,910,684 Tarrant County Hospital District 811,368 976,874 1,115,729 1,115,729 1,244,834 Tarrant County College District 517,776 609,688 696,316 696,316 776,906 Tarrant County 879,200 1,022,008 1,213,025 1,213,025 1,353,388 Sub-Total 4,104,396 $4,930,544 $5,635,267 $5,635,267 $6,285,812 Other Funding Sources Investment Income 1,938 ($22,497) $0 $0 $0 Bond Defeasance/Refunding Proceeds 0 $0 $0 $0 $0 Sub-Total 1,938 ($22,497) $0 $0 $0 TOTAL REVENUES 4,106,334 $4,908,047 $5,635,267 $5,635,267 $6,285,812 EXPENDITURES&TRANSFERS TIF#2 Debt Service 2,346,287 $2,291,946 $2,232,753 $2,232,753 $2,175,579 • Bond Defeasance/Refunding 0 0 0 0 0 Sub-Total 2,346,287 2,291,946 2,232,753 2,232,753 2,175,579 TOTAL EXPENDITURES 2,346,287 2,291,946 2,232,753 2,232,753 2,175,579 BALANCE 1,760,047 $2,616,101 $3,402,514 $3,402,514 $4,110,233 Ordinance No.3600 Attachment A Page 13 of 31 FISCAL YEAR 2019-2020 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Sales Tax $4,964,710 $5,140,554 $5,197,739 $5,094,966 $5,199,346 Interest Income 35,561 50,082 40,600 69,745 69,653 Youth Assn.Maintenance Fees 72,845 42,817 35,500 38,809 39,000 Tennis Center Revenue 356,075 356,139 365,300 386,000 420,600 Transfer in from Aquatic Park Fund 83,685 0 0 0 0 Park Impact Fees 82,121 87,880 95,000 252,000 95,000 Grants/Foundation 50,000 150,000 0 0 0 Other Income 20,952 22,083 900 71,290 1,500 SUB-TOTAL $5,665,949 $5,849,556 $5,735,039 $5,912,810 $5,825,099 NRH CENTRE Memberships/Drop-In Passes $1,347,606 $1,406,929 $1,390,000 $1,420,000 $1,420,000 Fitness 464,730 486,893 465,000 453,000 453,000 Recreation/Sports 223,099 303,196 281,000 324,000 324,000 Grand Hall Rental 271,875 417,244 273,100 468,550 402,150 Catering&Event Fees 17,536 25,612 17,900 31,450 28,275 Aquatic Programs 255,350 250,290 245,000 255,000 255,000 Pool Rental 3,574 2,875 4,000 3,000 3,000 Gym Rental 2,352 3,978 4,000 16,000 12,000 Concessions/Merchandise 17,077 28,252 27,000 27,000 27,000 Special Events 8,289 8,132 10,000 8,783 9,000 Other 14,379 9,711 10,000 10,000 10,000 General Fund 487,102 487,102 487,102 487,102 487,102 SUB-TOTAL $3,112,969 $3,430,214 $3,214,102 $3,503,885 $3,430,527 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $41,307 $0 $0 $90,360 $0 Appropriation of Park Impact Fee Reserves 900,000 0 0 0 0 Appropriation of Sales Tax Reserves 130,000 0 0 0 224,057 SUB-TOTAL $1,071,307 $0 $0 $90,360 $224,057 TOTAL REVENUES $9,850,226 $9,279,770 $8,949,141 $9,507,055 $9,479,683 Ordinance No.3600 Attachment A Page 14 of 31 FISCAL YEAR 2019-2020 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 EXPENDITURES OPERATING Park Facilities Development Admin. $828,882 $823,120 $846,010 $902,832 $956,834 Parks&Public Grounds 1,994,481 2,049,782 2,174,057 2,266,815 2,129,790 Tennis Center Operations 550,292 544,843 627,412 627,010 627,934 SUB-TOTAL $3,373,655 $3,417,745 $3,647,479 $3,796,657 $3,714,558 NRH CENTRE Center Management $676,213 $701,603 $776,077 $776,959 $825,518 Fitness 414,846 427,782 404,955 404,955 513,399 Building Operations 254,584 223,378 218,334 219,040 223,910 Aquatic 538,999 650,536 653,093 665,445 659,956 Recreation Sports 279,242 324,784 291,862 313,195 313,492 1 Event Center 260,687 304,695 300,451 430,537 377,310 Building Services 351,900 284,090 274,090 274,090 277,788 SUB-TOTAL $2,776,471 $2,916,869 $2,918,862 $3,084,221 $3,191,373 OTHER&RESERVES Debt Services-CO's $320,393 $627,685 $524,550 $524,555 $509,030 Indirect Costs 498,988 500,885 499,065 499,003 497,541 Non-Departmental 165,151 42,675 52,402 46,511 57,043 Transfers to Capital Projects Capital Projects 913,180 666,284 569,000 569,000 1,046,000 Capital Projects-Grant/Donation/Foundation 150,000 0 0 0 0 Capital Projects-Impact Fees 1,100,000 205,000 89,000 89,000 0 Contributions to Reserves Operating Reserve 0 150,548 343,600 308,070 0 Impact Fee Reserve 0 0 0 163,000 95,000 Economic Development Reserve 124,118 128,514 129,943 127,374 129,984 NRH Centre Reserve 289,204 221,635 175,240 299,664 239,154 SUB-TOTAL $3,561,033 $2,543,226 $2,382,800 $2,626,177 $2,573,752 TOTAL EXPENDITURES $9,711,159 $8,877,840 $8,949,141 $9,507,055 $9,479,683 BALANCE $139,067 $401,930 $0 $0 $0 Ordinance No.3600 Attachment A Page 15 of 31 FISCAL YEAR 2019-2020 SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Sales Tax $4,944,187 $5,098,136 $5,171,241 $5,057,338 $5,160,426 Franchise Tax 47,129 96,127 96,127 110,793 96,127 Interest Income 4,531 9,653 2,465 15,400 15,400 SRO Reimibursement(BISD) 209,520 219,296 226,194 226,194 240,826 Other 7,220 26,194 55,086 59,352 70,877 Contribution from the General Fund 0 0 0 0 143,469 Prior Year Encumbrances 70,214 0 0 141,288 0 Appropriation of Fund Balance 1,126,946 0 16,845 98,819 0 TOTAL REVENUES $6,409,746 $5,449,405 $5,567,958 $5,709,184 $5,727,125 EXPENDITURES Administration $10,177 $7,234 $9,500 $9,500 $16,000 Community Resources 931,368 1,006,212 1,126,890 1,127,867 1,195,721 Investigations 481,350 485,927 491,527 499,066 527,912 Uniform Patrol 2,866,629 2,979,103 2,998,357 3,036,524 3,005,620 Technical Services 532,098 554,693 556,876 557,357 573,686 Property Evidence 267,545 32,815 214,443 309,734 222,668 SUB-TOTAL $5,089,168 $5,065,984 $5,397,593 $5,540,048 $5,541,607 OTHER&RESERVES Partner Agency Funding $61,816 $69,525 $36,530 $36,530 $44,426 Other 79,920 92,510 103,977 102,810 112,758 Indirect Costs 52,124 31,678 29,858 29,796 28,334 Transfer to Capital Projects 1,076,000 0 0 0 0 Reserves 0 16,127 0 0 0 SUB-TOTAL $1,269,859 $209,841 $170,365 $169,136 $185,518 TOTAL EXPENDITURES $6,359,027 $5,275,825 $5,567,958 $5,709,184 $5,727,125 BALANCE $50,719 $173,580 $0 $0 $0 Ordinance No.3600 Attachment A Page 16 of 31 FISCAL YEAR 2019-2020 SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Occupancy Tax Proceeds $278,764 $301,835 $280,000 $280,000 $280,000 Interest Income 4,363 6,252 5,500 10,000 10,000 Prior Year Encumbrances 0 2,439 0 0 0 SUB-TOTAL $283,127 $310,526 $285,500 $290,000 $290,000 TOTAL REVENUES $283,127 $310,526 $285,500 $290,000 $290,000 EXPENDITURES Economic Development $113,807 $120,587 $126,176 $126,264 $127,891 Cultural&Leisure 124,404 119,556 135,159 135,159 145,222 Non-Departmental 125 178 474 386 533 Contribution to Reserves 0 0 23,691 28,191 16,354 ' SUB-TOTAL $238,336 $240,320 $285,500 $290,000 $290,000 TOTAL EXPENDITURES $238,336 $240,320 $285,500 $290,000 $290,000 BALANCE $44,791 $70,206 $0 $0 $0 Ordinance No.3600 Attachment A Page 17 of 31 FISCAL YEAR 2019-2020 SCHEDULE 11-SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Contributions NRH Water Bills $60,490 $61,414 $60,200 $60,200 $60,200 SUB-TOTAL $60,490 $61,414 $60,200 $60,200 $60,200 Donations Spay/Neuter $11,351 $10,766 $8,500 $8,500 $8,500 Shelter Fund 39,092 12,056 8,400 17,152 10,800 Duncan 15,000 15,000 15,000 15,000 15,000 Santa Cops 2,631 9,747 5,000 5,000 2,500 SUB-TOTAL $68,074 $47,569 $36,900 $45,652 $36,800 Proceeds Library Book Sale $10,316 $8,885 $9,000 $9,000 $9,000 SUB-TOTAL $10,316 $8,885 $9,000 $9,000 $9,000 Other Interest Income $5,241 $6,979 $3,614 $9,076 $9,076 Other Income 163,189 158,407 163,250 124,120 124,150 Appropriation of Fund Balance Teen Court 0 400 400 400 400 Library 43,196 22,320 14,765 18,815 18,815 Neighborhood Services 4,969 73,830 8,873 6,823 9,923 Parks&Recreations 42,375 59,027 29,700 34,942 29,700 Police 4,750 400 1,100 32,993 3,100 Fire 0 0 0 1,159 0 Encumbrance Roll 0 3,500 0 24,682 0 SUB-TOTAL $263,720 $324,863 $221,702 $253,010 $195,164 TOTAL REVENUES $402,600 $442,730 $327,802 $367,862 $301,164 EXPENDITURES Library-Book Collection $80,165 $72,985 $68,865 $73,170 $68,865 Neighborhood Services Animal Services 22,694 21,925 19,810 19,810 19,810 Keep NRH Beautiful 17,217 15,082 17,013 17,013 17,013 Municipal Court-Teen Court 4,000 5,000 5,000 5,000 5,000 Parks-Special Events and Arts 62,920 98,858 114,000 137,458 114,500 Police Department 30,789 46,339 43,700 41,093 9,200 Fire Department 0 987 0 1,959 0 Transfers Out 51,400 30,000 30,000 34,252 30,000 TOTAL EXPENDITURES $269,185 $291,176 $298,388 $329,755 $264,388 BALANCE $133,415 $151,555 $29,414 $38,107 $36,776 Ordinance No.3600 Attachment A Page 18 of 31 FISCAL YEAR 2019-2020 I SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES 1 SPECIAL INVESTIGATIONS FUND ADOPTED REVISED PROPOSED • ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Forefeited Funds $92,345 $86,783 $141,000 $142,500 $141,000 AFIS Reimbursements 13,500 26,250 13,500 13,500 13,500 911 Telecom (58,000) 0 0 0 0 Interest Income 2,056 2,744 2,304 0 0 Other Income 105,757 25,492 0 0 0 Prior Year Encumbrances 39,531 3,300 0 0 0 Appropriation of Fund Balance 102,935 0 104,521 105,325 107,800 TOTAL REVENUES $298,123 $144,569 $261,325 $261,325 $262,300 EXPENDITURES Federal Forefeited Funds $93,434 $36,869 $145,000 $145,000 $145,000 MDT Maintenance 0 0 0 0 0 Radio Maintenance 0 0 0 0 0 State Forfeitured Funds 42,592 28,564 105,000 105,000 105,000 1 Local Forfeited Funds 46,255 0 0 0 1,000 AFIS Maintenance&Equipment 87,672 51,750 4,300 4,300 4,300 911 Telecom 29,700 0 0 0 0 Leose Contributions 0 0 7,025 7,025 7,000 Reserve for City Hall Project: 911 Telecom 0 0 0 0 0 Automated Fingerprint Identification Sys.(AFIS) 0 0 0 0 0 Reserves 0 0 0 0 0 TOTAL EXPENDITURES $299,653 $117,183 $261,325 $261,325 $262,300 BALANCE ($1,530) $27,386 $0 $0 $0 Ordinance No.3600 Attachment A Page 19 of 31 FISCAL YEAR 2019-2020 SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Drainage Fees $883,195 $896,000 $1,647,000 $910,000 $1,647,000 Interest Income 4,667 3,772 2,755 10,000 10,000 Appropriation of Fund Balance 305,928 438,103 0 0 0 SUB-TOTAL $1,193,790 $1,337,876 $1,649,755 $920,000 $1,657,000 TOTAL REVENUES $1,193,790 $1,337,876 $1,649,755 $920,000 $1,657,000 EXPENDITURES Debt Service $373,018 $362,674 $261,139 $268,276 $278,599 Transfer to Capital Projects 695,000 797,850 230,000 230,000 575,000 Other Expenditures 29,820 29,748 30,000 30,366 30,000 Contribution to Reserves 0 0 1,128,616 391,358 773,401 TOTAL EXPENDITURES $1,097,838 $1,190,272 $1,649,755 $920,000 $1,657,000 BALANCE $95,952 $147,604 $0 $0 $0 Ordinance No.3600 Attachment A Page 20 of 31 FISCAL YEAR 2019-2020 SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES BONUSES General Fund Purposes $0 $0 $0 $0 $0 SUB-TOTAL $0 $0 $0 $0 $0 ROYALITIES/OVERRIDES General Fund Purposes $454,264 $555,185 $522,500 $500,000 $500,000 SUB-TOTAL $454,264 $555,185 $522,500 $500,000 $500,000 OTHER Right of Way Usage Fees $0 $0 $0 $0 $0 Sales of Property 0 0 0 0 0 Interest Income 2,563 6,539 5,800 16,800 16,800 Other Income 0 0 0 1,060,000 0 SUB-TOTAL $2,563 $6,539 $5,800 $1,076,800 • $16,800 APPROPRIATION OF RESERVES General Fund Purposes $0 $0 $0 $0 $970,679 SUB-TOTAL $0 $0 $0 $0 $970,679 TOTAL REVENUES $456,827 $561,724 $528,300 $1,576,800 $1,487,479 EXPENDITURES OPERATING Transfer to Capital Projects $0 $100,000 $0 $0 $790,000 Interfund Loan 0 0 0 0 697,479 Contribution to Reserves 0 398,300 528,300 1,573,230 0 Other 70,174 22,185 0 3,570 0 TOTAL EXPENDITURES $70,174 $520,485 $528,300 $1,576,800 $1,487,479 BALANCE $386,653 $41,239 $0 $0 $0 • Ordinance No.3600 Attachment A Page 21 of 31 FISCAL YEAR 2019-2020 SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES Gross Fine Revenues $1,088,773 $977,595 $1,088,115 $830,000 $0 Interest Income 6,281 8,416 7,900 13,129 0 Transfer from General CIP 0 0 0 0 0 Prior Year Encumbrances 0 76,510 0 0 0 Appropriation of Fund Balance 35,006 0 0 0 86,726 TOTAL REVENUES $1,130,060 $1,062,521 $1,096,015 $843,129 $86,726 EXPENDITURES Contractor Payments $593,690 $484,545 $612,000 $408,000 $0 Program Administration 270,264 298,120 319,409 317,209 0 Payment to State 141,200 98,204 78,353 52,396 0 Traffic Enforcement/Traffic Safety 22,972 76,510 23,000 38,000 70,145 Pedestrian Safety 16,147 16,994 16,415 16,415 16,581 Transfer to Capital Projects 0 0 0 0 0 Contribution to Reserves 0 0 46,838 11,109 0 SUB-TOTAL OTHER EXPENDITURES $1,044,272 $974,374 $1,096,015 $843,129 $86,726 TOTAL EXPENDITURES $1,044,272 $974,374 $1,096,015 $843,129 $86,726 BALANCE $85,788 $88,147 $0 $0 $0 Ordinance No.3600 Attachment A Page 22 of 31 FISCAL YEAR 2019-2020 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND • ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES WATER SALES AND CHARGES Water Sales $19,093,425 $22,064,283 $22,563,509 $19,823,862 $24,556,883 Water Prior Year Settle-up $315,360 $1,108,469 $0 $308,637 $0 Water Taps 41,715 38,815 34,515 34,515 44,200 Water Inspection Fees 52,121 35,816 24,882 24,000 24,000 SUB-TOTAL $19,502,621 $23,247,383 $22,622,906 $20,191,014 $24,625,083 SEWER SALES AND CHARGES Sewer Sales $10,611,314 $11,497,849 $11,469,477 $11,469,477 $12,660,706 Sewer Prior Year Settle-Up $0 $608,287 $0 $169,741 $0 Sewer Taps 12,800 11,750 10,600 12,600 12,600 Sewer Inspection Fees 43,071 35,789 24,000 24,000 24,000 SUB-TOTAL $10,667,185 $12,153,675 $11,504,077 $11,675,818 $12,697,306 MISCELLANEOUS Interest Income $89,926 $105,213 $103,500 $144,000 $144,000 Service Charges 173,855 171,314 153,500 134,500 153,500 Late Charges 410,157 449,044 420,000 420,000 420,000 Miscellaneous 142,377 50,666 36,034 36,034 36,034 Joint Use Reimbursement-Watauga 112,583 57,724 60,000 175,940 93,000 Subdivision Meter Revenue 58,365 56,994 56,193 64,193 64,193 Bond Refunding Proceeds 0 0 0 0 0 Interfund Loan Repayments 48,003 0 0 0 0 1 SUB-TOTAL $1,035,266 $890,955 $829,227 $974,667 $910,727 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $385,280 $89,843 $0 $129,210 $0 Appropriation of Fund Balance 1,923,100 685,883 408,249 1,895,726 0 SUB-TOTAL $2,308,380 $775,726 $408,249 $2,024,936 $0 TOTAL REVENUES $33,513,452 $37,067,738 $35,364,459 $34,866,435 $38,233,116 Ordinance No.3600 Attachment A Page 23 of 31 FISCAL YEAR 2019-2020 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 EXPENDITURES OPERATING Administration $315,392 $330,729 $346,147 $346,322 $356,793 Development 840,824 835,637 914,673 929,860 946,578 Right of Way Maintenance 114,776 245,981 271,118 266,053 352,976 SUB-TOTAL $1,270,991 $1,412,347 $1,531,938 $1,542,235 $1,656,347 WATER SERVICES Water Operations $4,521,124 $4,481,466 $4,798,521 $4,890,692 $4,799,523 Purchase of Water FTW 3,608,262 4,706,889 4,448,150 4,638,043 4,294,242 Purchase of Water TRA 6,108,256 6,499,342 6,353,955 5,359,031 6,197,623 SUB-TOTAL $14,237,641 $15,687,697 $15,600,626 $14,887,766 $15,291,388 SEWER SERVICES Sewer Operations $1,323,464 $1,380,901 $1,489,643 $1,499,116 $1,499,013 Sewer Treatment FTW 1,168,452 1,435,478 1,326,214 1,551,288 1,522,893 Sewer Treatment TRA 4,323,559 4,594,248 4,813,368 4,779,181 5,073,378 SUB-TOTAL $6,815,475 $7,410,628 $7,629,225 $7,829,585 $8,095,284 FINANCE/UTILITY COLLECTIONS Meter Reading $477,799 $501,660 $532,122 $528,179 $571,258 Utility Billing/Customer Service 925,364 934,234 995,968 1,035,026 1,051,214 Utility Collection Services 263,305 230,834 246,057 241,742 249,273 Accounting Services 372,187 403,832 429,282 432,268 444,255 Budget&Research 172,402 218,301 229,883 229,882 236,339 SUB-TOTAL $2,211,057 $2,288,861 $2,433,312 $2,467,097 $2,552,339 Building Services $1,822,929 $1,822,929 $1,822,929 $1,822,929 $1,822,929 Non Departmental $201,994 $177,419 $302,286 $329,770 $317,120 SUB-TOTAL DEPARTMENTS $26,560,087 $28,799,880 $29,320,316 $28,879,382 $29,735,407 OTHER&RESERVES Debt Service $1,128,567 $1,109,688 $1,391,236 $1,416,335 $1,673,546 Bond Defeasance/Refunding 0 0 0 0 0 Franchise Fees 895,441 1,003,680 1,020,989 938,800 1,116,527 Indirect Costs 2,304,572 2,304,572 2,304,572 2,304,572 2,182,170 Payment in Lieu of Taxes 390,983 392,821 415,689 415,689 405,201 Transfer to Information Technology 175,000 175,000 175,000 175,000 175,000 Transfer to Equipment Services 0 0 0 0 0 Transfer to Capital 1,200,000 757,523 736,657 736,657 901,657 Contribution to Reserves 0 1,647,883 0 0 2,043,608 SUB-TOTAL $6,094,563 $7,391,167 $6,044,143 $5,987,053 $8,497,709 TOTAL EXPENDITURES $32,654,650 $36,191,047 $35,364,459 $34,866,435 $38,233,116 BALANCE $858,802 $876,692 $0 $0 $0 Ordinance No.3600 Attachment A Page 24 of 31 • FISCAL YEAR 2019-2020 SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 ATTENDANCE 202,515 184,064 220,000 190,000 210,000 REVENUES OPERATING Admissions $3,027,498 $2,840,631 $3,295,000 $2,955,078 $3,259,118 Food and Beverage 834,519 675,021 870,700 804,476 848,881 Merchandise 144,398 113,567 154,000 147,000 150,087 Rentals 126,093 130,093 185,000 176,400 180,105 Aquatic Classes/Special Events 5,568 10,416 0 0 0 SUB-TOTAL $4,089,301 $3,769,728 $4,504,700 $4,082,954 $4,438,191 OTHER REVENUES Interest Income $11,134 $14,537 $16,309 $20,632 $20,632 Other Income 31,113 42,362 47,500 47,500 47,500 Bond Refunding Proceeds 198,864 0 0 0 0 SUB-TOTAL $241,111 $56,899 $63,809 $68,132 $68,132 SUB-TOTAL REVENUES $4,330,412 $3,826,627 $4,568,509 $4,151,086 $4,506,323 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $1,253,468 $0 $0 $32,507 $0 SUB-TOTAL $1,253,468 $0 $0 $32,507 $0 TOTAL REVENUES $5,583,880 $3,826,627 $4,568,509 $4,183,593 $4,506,323 EXPENDITURES OPERATING General Services&Utilities $913,210 $816,727 $847,256 $682,030 $673,365 Public Grounds/Aquatics/Maint. 1,380,100 1,156,580 1,121,077 1,120,988 1,130,995 Business&Office Administration 585,200 511,154 548,376 550,602 516,070 Gift Shop/Concessions 632,597 548,513 597,780 598,097 601,103 Sales/Special Events/Admissions 260,630 259,626 273,508 273,807 317,519 SUB-TOTAL $3,771,737 $3,292,600 $3,387,997 $3,225,524 $3,239,052 OTHER&RESERVES Debt Service $954,205 $905,186 $779,516 $807,979 $754,279 Bond Defeasance/Refunding 201,896 0 0 0 0 Indirect Costs 166,631 0 174,963 0 0 Transfer Out-PARD 83,685 0 0 0 0 Transfer to Capital Projects 335,000 100,000 100,000 100,000 100,000 Reserve For Infrastructure&Major Repairs 0 24,049 73,651 0 357,669 Non-Departmental 70,727 52,000 52,382 50,090 55,323 SUB-TOTAL $1,812,144 $1,081,235 $1,180,512 $958,069 $1,267,271 TOTAL EXPENDITURES $5,583,881 $4,373,834 $4,568,509 $4,183,593 $4,506,323 BALANCE $0 ($547,207) $0 $0 $0 Ordinance No.3600 Attachment A Page 25 of 31 FISCAL YEAR 2019-2020 SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 ROUNDS 49,147 42,953 51,000 47,300 16,841 REVENUES Green Fees $951,730 $845,548 $1,002,000 $959,997 $295,900 Pro Shop 403,867 446,520 413,500 417,900 196,400 Driving Range 79,132 58,709 75,000 75,000 34,500 Carts 409,075 383,638 391,000 384,000 133,900 Food&Beverage 714,299 625,910 681,500 689,696 253,600 General&Administrative 126 77 0 0 0 Interfund Loan 0 0 0 0 697,479 Other Revenue 129,514 42,832 38,454 39,768 39,768 Appropriation of Fund Balance 0 0 0 0 0 TOTAL REVENUE $2,687,743 $2,403,235 $2,601,454 $2,566,361 $1,651,547 EXPENDITURES OPERATING Pro Shop $136,669 $91,489 $166,710 $145,350 $73,110 Pro Shop:Cost of Goods Sold 191,202 160,495 143,000 149,000 59,000 Driving Range 8,150 14,862 18,200 17,750 16,500 Golf Carts 214,717 243,858 224,030 237,984 156,604 Course Maintenance 590,172 595,870 632,200 577,921 552,181 Food&Beverage 340,789 311,547 304,202 290,792 163,090 Food&Beverage:Cost of Goods Sold 226,256 209,681 206,064 211,598 80,280 Sales&Membership 36,415 280 56,764 0 0 General&Administrative 312,998 355,242 287,755 360,017 278,775 Clubhouse 118,783 96,681 97,434 91,534 90,100 Management Fees 144,714 135,903 144,714 144,712 130,033 Capital 129,405 156,105 154,000 122,654 0 1 SUB-TOTAL $2,450,271 $2,372,013 $2,435,073 $2,349,312 $1,599,673 OTHER&RESERVES Debt Service $116,430 $63,834 $62,743 $62,530 $51,874 Transfer to Capital Projects 0 0 103,638 0 0 Payment to Interdepartmental Loans Water Fund 48,003 0 0 0 0 General Fund 147,760 0 0 0 0 Contribution to Reserves 0 0 0 154,519 0 SUB-TOTAL $312,193 $63,834 $166,381 $217,049 $51,874 TOTAL EXPENDITURES $2,762,464 $2,435,847 $2,601,454 $2,566,361 $1,651,547 BALANCE ($74,721) ($32,612) $0 $0 $0 Ordinance No.3600 Attachment A Page 26 of 31 FISCAL YEAR 2019-2020 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $836,737 $812,101 $812,101 $812,101 $812,101 Park Development Fund 351,900 284,090 274,090 274,090 277,788 Utility Fund 1,822,929 1,822,929 1,822,929 1,822,929 1,822,929 SUB-TOTAL $3,011,566 $2,919,120 $2,909,120 $2,909,120 $2,912,818 OTHER REVENUES Insurance Settlements $0 $0 $0 $0 $0 Interest Income 16,021 24,743 23,000 33,000 33,000 Rent From Rental Properties 71,492 55,481 39,600 39,600 36,900 Other Income 100 (45,260) 0 0 0 SUB-TOTAL $87,613 $34,964 $62,600 $72,600 $69,900 SUB-TOTAL REVENUES $3,099,179 $2,954,084 $2,971,720 $2,981,720 $2,982,718 APPROPRIATION OF FUND BALANCE II Building Services Fund Reserves $60,440 $0 $13,620 $101,740 $0 Prior Year Encumbrances 0 0 0 0 0 SUB-TOTAL $60,440 $0 $13,620 $101,740 $0 TOTAL REVENUES $3,159,619 $2,954,084 $2,985,340 $3,083,460 $2,982,718 EXPENDITURES General Services $330,864 $325,124 $356,927 $307,003 $265,629 Building Services 2,308,154 2,182,135 2,359,714 2,307,329 2,474,383 Rental Property Program 25,220 66,509 36,120 36,120 36,120 Transfer to Capital Budget 120,800 0 212,000 310,000 53,000 SUB-TOTAL $2,785,039 $2,573,768 $2,964,761 $2,960,452 $2,829,132 OTHER&RESERVES Debt Service $26,193 $0 $0 $0 $0 Other 12,953 16,077 20,579 123,008 22,762 Contribution of Facility Reserves 0 143,770 0 0 130,824 SUB-TOTAL $39,146 $159,847 $20,579 $123,008 $153,586 TOTAL EXPENDITURES $2,824,185 $2,733,615 $2,985,340 $3,083,460 $2,982,718 BALANCE $335,434 $220,469 $0 $0 $0 Ordinance No.3600 Attachment A Page 27 of 31 FISCAL YEAR 2019-2020 SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $1,389,677 $1,389,677 $1,389,677 $1,389,677 $1,389,677 Utility Fund 1,967,647 1,967,647 1,967,647 1,967,647 1,967,647 Utility CIP/Utility Construction 288,678 288,678 288,678 288,678 288,678 Crime Control District 170,426 170,426 170,426 170,426 170,426 Park&Recreation Dev.Fund 143,939 143,817 171,939 171,939 171,939 Other Funds 40,278 24,119 24,119 24,119 24,119 SUB-TOTAL $4,000,645 $3,984,365 $4,012,486 $4,012,486 $4,012,486 OTHER REVENUES Interst Income $23,305 $35,726 $30,000 $42,000 $42,000 Sale of City Property 18,501 10,997 50,000 20,000 20,000 Other Income 11,505 56,540 3,300 0 0 Transfer from General Fund 0 0 0 0 0 Transfer from Utility Fund 0 0 0 0 0 SUB-TOTAL $53,310 $103,263 $83,300 $62,000 $62,000 SUB-TOTAL REVENUES $4,053,955 $4,087,628 $4,095,786 $4,074,486 $4,074,486 APPROPRIATION OF FUND BALANCE Equipment Services Fund Reserves $41,565 $0 $495,527 $495,527 $437,013 Appropriation-PY Encumbrances 0 732,668 0 634,450 0 SUB-TOTAL $41,565 $732,668 $495,527 $1,129,977 $437,013 TOAL REVENUES $4,095,520 $4,820,296 $4,591,313 $5,204,463 $4,511,499 EXPENDITURES General Services $222,030 $176,085 $275,794 $275,794 $292,713 Equipment Services Operations 1,367,037 1,563,460 1,618,490 1,631,942 1,574,364 Fire Fleet Maintenance 286,138 358,744 330,907 320,357 323,461 Equipment Purchases 3,989 471,993 425,875 565,348 746,830 Fire Vehicles/Equipment 390,511 162,229 0 68,950 107,280 Police Vehicles/Equipment 63,126 337,029 774,375 1,183,935 553,000 SUB-TOTAL $2,332,832 $3,069,541 $3,425,441 $4,046,326 $3,597,648 OTHER&RESERVES Debt Service $448,414 $421,484 $537,302 $519,706 $629,884 Transfer to Capital Projects 503,000 192,232 609,000 609,000 162,411 Other 12,469 15,498 19,570 29,431 21,556 Equipment Services Reserve 41,565 231,596 0 0 100,000 SUB-TOTAL $1,005,448 $860,810 $1,165,872 $1,158,137 $913,851 TOTAL EXPENDITURES $3,338,280 $3,930,351 $4,591,313 $5,204,463 $4,511,499 BALANCE $757,241 $889,944 $0 $0 $0 Ordinance No.3600 Attachment A Page 28 of 31 FISCAL YEAR 2019-2020 SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 _ REVENUES TELECOMMUNICATIONS Transfer From: General Fund $353,538 $371,220 $369,544 $369,544 $369,544 I Park Fund 35,708 37,493 37,493 37,493 37,493 Crime Control District 30,018 30,796 32,472 32,952 39,739 Utility Fund 89,489 93,965 93,965 93,965 93,965 Other Funds 64,273 65,309 71,067 71,067 67,487 SUB-TOTAL $573,026 $598,783 $604,541 $605,021 $608,228 COMPUTERS Transfer From: General Fund $1,048,660 $1,098,076 $1,093,677 $1,093,677 $1,093,677 Park Fund 112,863 118,506 118,506 118,506 118,506 Crime Control District 188,622 194,627 199,175 199,175 210,252 Utility Fund 734,822 771,562 771,562 771,562 771,562 Other Funds 306,823 322,166 327,623 327,623 322,166 SUB-TOTAL $2,391,790 $2,504,937 $2,510,543 $2,510,543 $2,516,163 OTHER REVENUES 1 Interest Income $13,923 $20,445 $17,000 $29,167 $29,167 Transmitter Lease 155,324 175,948 152,958 152,958 152,958 Other Income 2,606 3,418 0 0 0 Transfer from General Fund 77,975 82,725 85,492 85,492 193,954 Transfer from Utility Fund 175,000 175,000 175,000 175,000 175,000 SUB-TOTAL $424,827 $457,536 $430,450 $442,617 $551,079 1 SUB-TOTAL REVENUES $3,389,643 $3,561,256 $3,545,534 $3,558,181 $3,675,470 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $0 $7,969 $0 $74,618 $0 Appropriation of Information Systems Reserves 15,000 0 96,287 359,971 266,152 SUB-TOTAL $15,000 $7,969 $96,287 $434,589 $266,152 I TOAL REVENUES $3,404,643 $3,569,225 $3,641,821 $3,992,770 $3,941,622 I EXPENDITURES General Services $256,207 $266,607 $281,324 $281,324 $266,283 l Major Computer Systems 331,827 372,734 343,255 318,747 346,426 Microcomputer Systems 634,629 683,493 781,059 806,551 776,217 Telecommunications 471,458 425,989 478,087 496,658 500,599 Data Network 653,370 751,287 856,422 926,064 938,810 GIS System 161,406 175,726 184,536 184,536 183,145 Public Safety 511,854 540,204 701,515 791,403 642,645 SUB-TOTAL $3,020,750 $3,216,040 $3,626,198 $3,805,283 $3,654,125 1 OTHER&RESERVES • Other $8,526 $9,789 $13,123 $11,007 $14,497 Transfer to Capital Projects 156,000 0 2,500 176,480 273,000 Reserve for System Improvements 0 55,212 0 0 0 SUB-TOTAL $164,526 $65,001 $15,623 $187,487 $287,497 TOTAL EXPENDITURES $3,185,276 $3,281,041 $3,641,821 $3,992,770 $3,941,622 BALANCE $219,367 $288,184 $0 $0 $0 Ordinance No.3600 Attachment A Page 29 of 31 FISCAL YEAR 2019-2020 SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2018/19 FY 2018/19 FY 2019/20 REVENUES ALLOCATIONS Health/Medical City Contribution $8,551,168 $9,243,366 $9,897,806 $9,897,806 $10,384,304 Health/Medical Employee Contribution 2,097,967 2,371,080 2,634,129 2,634,129 2,764,264 Worker's Compensation 48,340 500,390 593,500 593,500 589,500 Administration Allocation 1,009,412 605,920 506,478 506,478 517,637 Other Insurance 583,445 701,581 753,227 753,227 813,925 SUB-TOTAL 12,290,332 $13,422,337 $14,385,140 $14,385,140 $15,069,630 OTHER REVENUES Interest Income $39,655 $57,782 $39,430 $81,473 $81,473 Other Income 137,444 132,519 133,500 145,613 137,000 Expenditure Reimbursement 567,953 783,065 400,000 600,000 400,000 SUB-TOTAL 745,051 $973,366 $572,930 $827,086 $618,473 SUB-TOTAL REVENUES $13,035,383 $14,395,703 $14,958,070 $15,212,226 $15,688,103 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $987,341 $100,000 $100,000 $100,000 $100,000 SUB-TOTAL $987,341 $100,000 $100,000 $100,000 $100,000 TOAL REVENUES $14,022,724 $14,495,703 $15,058,070 $15,312,226 $15,788,103 EXPENDITURES 1 Health/Medical $11,984,074 $11,483,456 $12,526,510 $11,826,510 $13,259,089 Worker's Compensation 334,487 35,901 593,500 593,500 589,500 Personnel Expenses 481,122 472,280 495,012 495,012 508,784 Other Insurance 577,519 551,421 644,228 644,228 678,926 Reserve for Insurance Claims 0 0 0 0 0 Other Expenses 127,529 105,129 133,500 145,688 137,000 Life Insurance Premium 99,540 105,713 109,000 109,000 135,000 SUB-TOTAL $13,604,271 $12,753,900 $14,501,750 $13,813,938 $15,308,299 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $100,000 $100,000 $100,000 $100,000 Contribution to Reserves 0 343,205 456,320 1,398,288 379,804 SUB-TOTAL 100,000 $443,205 $556,320 $1,498,288 $479,804 TOTAL EXPENDITURES $13,704,271 $13,197,105 $15,058,070 $15,312,226 $15,788,103 BALANCE $318,453 $1,298,598 $0 $0 $0 Ordinance No.3600 Attachment A Page 30 of 31 FISCAL YEAR 2019-2020 . WORKING CAPITAL BALANCE SUMMARY-ALL FUNDS Working Capital is defined as current assets minus current liabilities and other restrictions(existing encumbrances,balances in projects underway,and other 1 restrictions). Maintaining an appropriate level of working capital balance is essential for the City to mitigate financial risk that can occur from unforeseen revenue shortfalls,unanticipated expenditures,or any other adverse circumstances. The City maintains an appropriate working capital balance level within each fund as determined by best practice and City policy. The Working Capital Balance Summary shows an estimated beginning balance as of September 1 30,2018 for all budgeted funds along with the estimated impact based upon the FY 2018-2019 Revised Budget and FY 2019-2020 Proposed Budget. FY 2018-2019 FY 2019-2020 Revised Budget FY 2018-2019 Proposed Budget FY 2019-2020 ESTIMATE AS OF Increase Revised Budget Increase Proposed Budget FUND 09/30/18 (Decrease) Ending Balance (Decrease) Ending Balance General Fund(Unreserved/Undesignated) $ 11,958,610 $ (179,218) $ 11,779,392 $ 18,264 $ 11,797,656 General Fund Designated for Municipal Court $ 643,223 $ (3,436) $ 639,787 $ (59,800) $ 579,987 Technology&Security General Fund Designated for Franchise Peg $ 480,886 $ 131,669 $ 612,555 $ 85,420 $ 697,975 Fees General Fund Designated for Record $ 4,000 $ $ 4,000 $ $ 4,000 Preservation Fee General Debt Service Fund* $ 910,366 $ 109,440 $ 1,019,806 $ - $ 1,019,806 Utility Fund Unrestricted $ 4,607,433 $ (2,024,936) $ 2,582,497 $ 2,043,608 $ 4,626,105 Golf Course Fund Unrestricted $ (130,549) $ 154,519 $ 23,970 $ - $ 23,970 Aquatic Park Fund Unrestricted $ (428,717) $ (32,507) $ (461,224) $ 357,669 $ (103,555) Facilities&Construction Services Fund $ 2,344,904 $ (101,740) $ 2,243,164 $ 130,824 $ 2,373,988 Fleet Services Fund $ 2,775,390 $ (1,129,977) $ 1,645,413 $ (437,013) $ 1,208,400 Self Insurance Fund $ 3,873,876 $ 1,298,288 $ 5,172,164 $ 279,804 $ 5,451,968 Information Technology Fund $ 2,068,016 $ (434,589) $ 1,633,427 $ (266,152) $ 1,367,275 Promotional Fund $ 705,831 $ 28,191 $ 734,022 $ 16,354 $ 750,376 Donations Fund $ 657,358 $ (81,707) $ 575,651 $ (25,162) $ 550,489 Special Investigation Fund $ 313,115 $ (105,325) $ 207,790 $ (107,800) $ 99,990 Drainage Utility Fund $ 666,745 $ 391,358 $ 1,058,103 $ 773,401 $ 1,831,504 Gas Development Fund $ 923,858 $ 1,573,230 $ 2,497,088 $ (970,679) $ 1,526,409 Traffic Safety Fund $ 648,433 $ 11,109 $ 659,542 $ (86,726) $ 572,816 Park&Recreation Facilities Development Fund $ 722,383 $ 217,710 $ 940,093 $ (224,057) $ 716,036 Recreation Centre $ 2,419,940 $ 299,664 $ 2,719,604 $ 239,154 $ 2,958,758 Economic Development Fund $ 1,231,031 $ 127,374 $ 1,358,405 $ 129,984 $ 1,488,389 Crime Control&Prevention District Fund $ 808,487 $ (240,107) $ 568,380 $ - $ 568,380 *CAFR undesignated fund balance. Ordinance No.3600 Attachment A Page 31 of 31 Ordinance No. 3600 Attachment B City of North Richland Hills Fiscal Year 2019/2020 Proposed Budget This budget will raise more total property taxes than last year's budget by $1 ,939,300 or 6.1 percent, and of that amount $462,347 is tax revenue to be raised from new property added to the tax roll this year. The total amount of municipal debt obligations secured by property taxes for the City of North Richland Hills is$121,140,000. Visit our website at:www.nrhtx.com Ordinance No.3600 Attachment B Page 1 of 22 4c . i /""P0 2,,,;; .' :;;I:,,,.;-.'--.,""'-.-''''''::'..'-.''' ' _.'....''... '"''—."...."'''".."a'"--....:::--..--.71----,':4 -'7:7±-40011------±: ------: "':-;-'1:1:-.,,.::,g7-1;. '7:-;--'1.::::Trij:'t1:1—:' t,z., i,,1 : • r • r ' -� ,, }. ,r. Y.. .. ;' " so t . -} e _ i - .-J ' ,,, ' F ,kC. S . � . .__ , , _,____ 1 -27-p-- , fig _..... ,.. .....,...........,„ ...... „I _R — - • T r 4. PROPOSED CAPITAL PROJECTS BUDGET FISCAL YEAR 2019-20 City of North Richland Hills Email: Budget@nrhtx.com Tel: 817.426.6053 Website: www.nrhtx.com 4301 City Point Dr. North Richland Hills, TX 76180 NRH •r.mance l o. .if , ac men : Page 2 of 22 Fiscal Year 2019/20 Proposed CIP Budget $13,804,443 Uses of Funds Parks&Recreation 30.07% Aquatic Park 0.72% Facilities $e is 2.70% . � Major Capital Utility Equipment 44.95% - Z � �.'� r, P` 11.98% it Economic Development 0.00% CIP Personnel 2.44% Drainage 4.17% Street&Sidewalk Other 17.48% 0.00% Sources of Funds C.O.BONDS,62.0% ; rs Reserves,35.6% Sales Tax,1.7% 0 Other,0.8% Ordinance No.3600 Attachment B Page 3 of 22 Summary of Project Expenditures 2019/2020 Capital Improvement Program Project To Proposed Estimated 2021 to Total Program Classification Date 2019/2020 2020/2021 Completion Expenditures Street&Sidewalk 41,498,539 2,413,375 0 0 $ 43,911,914 Drainage 2,134,108 575,000 0 0 $ 2,709,108 Utility 11,466,249 4,205,000 0 0 $ 15,671,249 Parks&Recreation 8,974,750 4,151,000 0 0 $ 13,125,750 Aquatic Park 100,000 100,000 0 0 $ 200,000 Facilities 71,743,515 373,000 0 0 $ 72,116,515 Major Capital Equipment 10,114,980 1,650,411 100,000 0 $ 11,865,391 Economic Development 14,231,756 0 0 0 $ 14,231,756 CIP Personnel 666,661 336,657 0 0 $ 1,003,318 Other 600,796 0 0 0 $ 600,796 Total CIP Project Expenditures $ 161,531,354 $ 13,804,443 $ 100,000 $ 0 $ 175,435,797 Ordinance No.3600 Attachment B Page 4 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Funding Source Date 2019/2020 2020/2021 Completion General Obligation Bonds 56,640,000 0 0 0 56,640,000 Certificates of Obligation 45,209,312 8,555,000 0 0 53,764,312 Federal/State Grants 21,541,961 0 0 0 21,541,961 Reserves 23,684,819 4,909,443 100,000 0 28,694,262 Sales Tax 2,072,126 235,000 0 0 2,307,126 Other 12,383,136 105,000 0 0 12,488,136 Total CIP Project Funding $ 161,531,354 $13,804,443 $ 100,000 $ 0 $ 175,435,797 Ordinance No.3600 Attachment B Page 5 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Program Date 2019/2020 2020/2021 Completion Street&Sidewalk General Obligation Bonds G.O. Bonds 1994 Program 760,000 0 0 0 $ 760,000 G.O. Bonds 2003 Program 7,630,000 0 0 0 $ 7,630,000 General Obligation Bonds $ 8,390,000 $ 0 $ 0 $ 0 $ 8,390,000 Certificates of Obligation Certificates of Obligation 8,370,000 380,000 0 0 $ 8,750,000 Certificates of Obligation $ 8,370,000 $ 380,000 $ 0 $ 0 $ 8,750,000 FederaUState Grants ISTEA Grant Funds 2,240,040 0 0 0 $ 2,240,040 Other 1,075,190 0 0 0 $ 1,075,190 TEA-21 Grant Funds 9,712,000 0 0 0 $ 9,712,000 TXDOT Funding 180,000 0 0 0 $ 180,000 Federal Grant 6,282,697 0 0 0 $ 6,282,697 Tarrant County Grant Funds 600,000 0 0 0 $ 600,000 FederaUState Grants $ 20,089,927 $ 0 $ 0 $ 0 $ 20,089,927 Reserves 1994 Bond Program Project Savings 365,010 0 0 0 $ 365,010 G.O. Bonds 1994 Program 75,000 0 0 0 $ 75,000 General Fund (001) 86,297 1,050,000 0 0 $ 1,136,297 Reserves 1,183,640 0 0 0 $ 1,183,640 Permanent Sidewalk Maintenance Fund 102,784 0 0 0 $ 102,784 Unspecified Project Savings 375,000 0 0 0 $ 375,000 Utility Operations for Capital Projects 200,000 0 0 0 $ 200,000 Project Savings 958,881 0 0 0 $ 958,881 Gas Development Fund Reserves(145) 0 790,000 0 0 $ 790,000 Bond Program Project Savings 65,000 0 0 0 $ 65,000 Utility Reserve for Future Construction 557,000 0 0 0 $ 557,000 Streets&Sidewalks CIP (355) 0 193,375 0 0 $ 193,375 Reserves $ 3,968,612 $ 2,033,375 $ 0 $ 0 $ 6,001,987 Other Other 430,000 0 0 0 $ 430,000 Tarrant County Grant Funds 250,000 0 0 0 $ 250,000 Other $ 680,000 $ 0 $ 0 $ 0 $ 680,000 Street&Sidewalk Sub-Total $ 41,498,539 $ 2,413,375 $ 0 $ 0 $ 43,911,914 Drainage Reserves Ordinance No.3600 Attachment B Page 6 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Program Date 2019/2020 2020/2021 Completion Drainage Utility Fund 1,137,850 575,000 0 0 $ 1,712,850 Reserves 846,258 0 0 0 $ 846,258 Reserves $ 1,984,108 $ 575,000 $ 0 $ 0 $ 2,559,108 Other Project Savings 150,000 0 0 0 $ 150,000 Other $ 150,000 $ 0 $ 0 $ 0 $ 150,000 Drainage Sub-Total $ 2,134,108 $ 575,000 $ 0 $ 0 $ 2,709,108 Utility Certificates of Obligation Certificates of Obligation 6,239,724 3,640,000 0 0 $ 9,879,724 Certificates of Obligation $ 6,239,724 $ 3,640,000 $ 0 $ 0 $ 9,879,724 Reserves Reserves 216,525 0 0 0 $ 216,525 Unspecified Project Savings 55,000 0 0 0 $ 55,000 Utility Operations for Capital Projects 1,280,000 0 0 0 $ 1,280,000 Utility Fund (405) 400,000 565,000 0 0 $ 965,000 Utility Reserve for Future Construction 275,000 0 0 0 $ 275,000 Reserves $ 2,226,525 $ 565,000 $ 0 $ 0 $ 2,791,525 Other . Impact Fees 3,000,000 0 0 0 $ 3,000,000 Other $ 3,000,000 $ 0 $ 0 $ 0 $ 3,000,000 Utility Sub-Total $ 11,466,249 $ 4,205,000 $ 0 $ 0 $ 15,671,249 Parks&Recreation Certificates of Obligation Certificates of Obligation 4,185,000 3,000,000 0 0 $ 7,185,000 Certificates of Obligation $. 4,185,000 $ 3,000,000 $ 0 $ 0 $ 7,185,000 Federal/State Grants TXDOT Funding 576,217 0 0 0 $ 576,217 Federal Grant 500,000 0 0 0 $ 500,000 Federal/State Grants $ 1,076,217 $ 0 $ 0 $ 0 $ 1,076,217 Reserves Impact Fees 89,000 0 0 0 $ 89,000 Project Savings 354,319 0 0 0 $ 354,319 Sales Tax Reserve for CIP 100,536 0 0 0 $ 100,536 Park Sales Tax(125) 120,000 811,000 0 0 $ 931,000 Ordinance No.3600 Attachment B Page 7 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Program Date 2019/2020 2020/2021 Completion Reserves $ 663,855 $ 811,000 $ 0 $ 0 $ 1,474,855 Sales Tax Project Savings 9,505 0 0 0 $ 9,505 Sales Tax Reserve for CIP 402,400 0 0 0 $ 402,400 Park Sales Tax(125) 1,566,583 235,000 0 0 $ 1,801,583 Sales Tax $ 1,978,488 $ 235,000 $ 0 $ 0 $ 2,213,488 Other Donations Fund 19,283 0 0 0 $ 19,283 Impact Fees 900,000 0 0 0 $ 900,000 Other 150,000 105,000 0 0 $ 255,000 Project Savings 1,907 0 0 0 $ 1,907 Other $ 1,071,190 $ 105,000 $ 0 $ 0 $ 1,176,190 Parks& Recreation Sub-Total $ 8,974,750 $ 4,151,000 $ 0 $ 0 $ 13,125,750 Aquatic Park Reserves Aquatic Park Infrastructure Reserve 100,000 100,000 0 0 $ 200,000 Reserves $ 100,000 $ 100,000 $ 0 $ 0 $ 200,000 Aquatic Park Sub-Total $ 100,000 $ 100,000 $ 0 $ 0 $ 200,000 Facilities General Obligation Bonds G.O. Bonds 2003 Program 250,000 0 0 0 $ 250,000 G.O. Bonds 2012 Program 48,000,000 0 0 0 $ 48,000,000 General Obligation Bonds $ 48,250,000 $ 0 $ 0 $ 0 $ 48,250,000 1 Certificates of Obligation Certificates of Obligation 18,600,000 320,000 0 0 $ 18,920,000 Certificates of Obligation $ 18,600,000 $ 320,000 $ 0 $ 0 $ 18,920,000 Reserves Building Services Fund Reserve(505) 212,000 53,000 0 0 $ 265,000 Future Construction Funds 120,800 0 0 0 $ 120,800 Other 2,126,428 0 0 0 $ 2,126,428 Reserves $ 2,459,228 $ 53,000 $ 0 $ 0 $ 2,512,228 Other Other 2,434,287 0 0 0 $ 2,434,287 Other $ 2,434,287 $ 0 $ 0 $ 0 $ 2,434,287 Ordinance No.3600 Attachment B Page 8 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Program Date 2019/2020 2020/2021 Completion Facilities Sub-Total $ 71,743,515 $ 373,000 $ 0 $ 0 $ 72,116,515 Major Capital Equipment Certificates of Obligation Certificates of Obligation 4,814,588 1,215,000 0 0 $ 6,029,588 Certificates of Obligation $ 4,814,588 $ 1,215,000 $ 0 $ 0 $ 6,029,588 FederaUState Grants Other 75,817 0 0 0 $ 75,817 Federal Grant 300,000 0 0 0 $ 300,000 FederaUState Grants $ 375,817 $ 0 $ 0 $ 0 $ 375,817 Reserves Equipment Services Fund(510) 304,912 162,411 0 0 $ 467,323 Information Services Reserve 492,663 273,000 100,000 0 $ 865,663 Reserves 1,096,000 0 0 0 $ 1,096,000 Unspecified Project Savings 31,000 0 0 0 $ 31,000 Reserves $ 1,924,575 $ 435,411 $ 100,000 $ 0 $ 2,459,986 Other Other 3,000,000 0 0 0 $ 3,000,000 Other $ 3,000,000 $ 0 $ 0 $ 0 $ 3,000,000 Major Capital Equipment Sub-Total $ 10,114,980 $ 1,650,411 $ 100,000 $ 0 $ 11,865,391 Economic Development Certificates of Obligation Certificates of Obligation 3,000,000 0 0 0 $ 3,000,000 Certificates of Obligation $ 3,000,000 $ 0 $ 0 $ 0 $ 3,000,000 Reserves General Fund (001) 130,000 0 0 0 $ 130,000 General Fund Pay-As-You-Go Reserves 50,000 0 0 0 $ 50,000 Other 50,000 0 0 0 $ 50,000 Reserves 5,935,000 0 0 0 $ 5,935,000 General Fund Designated Reserves 1,200,000 0 0 0 $ 1,200,000 1 Gas Fund Reserves(Designated for ED Ac 1,469,097 0 0 0 $ 1,469,097 Economic Development Sales Tax 450,000 0 0 0 $ 450,000 Reserves $ 9,284,097 $ 0 $ 0 $ 0 $ 9,284,097 Other Other 1,521,184 0 0 0 $ 1,521,184 Commercial Loan 426,475 0 0 0 $ 426,475 Ordinance No.3600 Attachment B Page 9 of 22 Summary of Project Funding 2019/2020 Capital Improvement Program Funding To Proposed Estimated 2021 to Total Funds Program Date 2019/2020 2020/2021 Completion Other $ 1,947,659 $ 0 $ 0 $ 0 $ 1,947,659 Economic Development Sub-Total $ 14,231,756 $ 0 $ 0 $ 0 $ 14,231,756 CIP Personnel Reserves Utility Fund(405) 666,661 336,657 0 0 $ 1,003,318 Reserves $ 666,661 $ 336,657 $ 0 $ 0 $ 1,003,318 CIP Personnel Sub-Total $ 666,661 $ 336,657 $ 0 $ 0 $ 1,003,318 Other Reserves Donations Fund 61,000 0 0 0 $ 61,000 General Fund (001) 94,000 0 0 0 $ 94,000 Other 252,158 0 0 0 $ 252,158 Reserves $ 407,158 $ 0 $ 0 $ 0 $ 407,158 Sales Tax Economic Development Sales Tax 93,638 0 0 0 $ 93,638 Sales Tax $ 93,638 $ 0 $ 0 $ 0 $ 93,638 Other General Fund (001) 75,000 0 0 0 $ 75,000 1 Other 25,000 0 0 0 $ 25,000 Other $ 100,000 $ 0 $ 0 $ 0 $ 100,000 Other Sub-Total $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Total CIP Project Funding $ 161,531,354 $13,804,443 $ 100,000 $ 0 $ 175,435,797 Ordinance No.3600 Attachment B Page 10 of 22 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects ST0401 Davis Blvd/Mid-Cities Blvd Intersection 7,690,000 0 0 0 $ 7,690,000 ST0904 Grand Avenue(Library to Health Markets Access Road) 75,000 0 0 0 $ 75,000 ST1102 Main St.Streetscaping&Snider St.Extension Project 2,866,050 0 0 0 $ 2,866,050 PW1602 Meadow Lakes Drive&Rufe Snow Drive Intersection 1,065,000 0 0 0 $ 1,065,000 SM1801 Preventive Street Maintenance(2018) 1,000,000 0 0 0 $ 1,000,000 SM1901 Preventive Street Maintenance(2019) 1,000,000 0 0 0 $ 1,000,000 SM1902 Preventive Street Maintenance(Multi-Year) 1,575,000 0 0 0 $ 1,575,000 ST0202 Rufe Snow Dr.Street&Utility Imp.(Mid-Cities to Hightower)[TEA-21] 21,703,236 0 0 0 $ 21,703,236 CDBG19 Schiller Drive Road Reconstruction(CDBG) 35,000 0 0 0 $ 35,000 SD1801 Sidewalk Rehabilitation and Replacement Project(2018) 50,000 0 0 0 $ 50,000 ' SD1901 Sidewalk Rehabilitation and Replacement Project(2019) 50,000 0 0 0 $ 50,000 ST1801 Smithfield Middle School Safe Routes to School(NCTCOG Grant) 263,921 0 0 0 $ 263,921 ST1304 Smithfield Road(Davis Blvd to Mid-Cities Blvd) 3,343,640 0 0 0 $ 3,343,640 ST1902 Street Assessment Project 140,000 0 0 0 $ 140,000 ST1901 TEXRail Signal Timing Coordination 100,000 0 0 0 $ 100,000 ST1005 Traffic Signalization at Davis Boulevard&Creek View Drive 300,000 0 0 0 $ 300,000 ST1701 Vance and Glenview Signal Upgrades 241,692 0 0 0 $ 241,692 Total Continuing Projects $ 41,498,539 $ 0 $ 0 $ 0 $ 41,498,539 New Projects ST2004 Transportation Management Project 0 193,375 0 0 $ 193,375 ST2003 Northeast Parkway/Davis Blvd.Traffic Signal 0 380,000 0 0 $ 380,000 ST2005 Northeast Parkway Extension 0 790,000 0 0 $ 790,000 SM2001 Preventive Street Maintenance(2020) 0 1,000,000 0 0 $ 1,000,000 SD2001 Sidewalk Rehabilitation and Replacement Project(2020) 0 50,000 0 0 $ 50,000 Total New Projects $ 0 $ 2,413,375 $ 0 $ 0 $ 2,413,375 Total Project Costs $ 41,498,539 $ 2,413,375 $ 0 $ 0 $ 43,911,914 Funding Sources General Obligation Bonds 8,390,000 0 0 0 $ 8,390,000 Certificates of Obligation 8,370,000 380,000 0 0 $ 8,750,000 Federal/State Grants 20,089,927 0 0 0 $ 20,089,927 'Reserves 3,968,612 2,033,375 0 0 $ 6,001,987 Other 680,000 0 0 0 $ 680,000 Total Sources of Funds $ 41,498,539 $ 2,413,375 $ 0 $ 0 $ 43,911,914 Ordinance No.3600 Attachment B Page 11 of 22 Schedule 2 Drainage Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects DR1503 Calloway Branch Channel Repair Project 1,446,258 0 0 0 $ 1,446,258 DR1901 Emerald Circle Drainage Project 130,000 0 0 0 $ 130,000 DR1801 Snow Heights Drainage Improvements Project 150,000 170,000 0 0 $ 320,000 DR1902 Street Drainage Improvements Project(2019) 100,000 0 0 0 $ 100,000 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 307,850 0 0 0 $ 307,850 Total Continuing Projects $ 2,134,108 $ 170,000 $ 0 $ 0 $ 2,304,108 New Projects DR2004 Big Fossil Creek Flood Study-BFC7 0 120,000 0 0 $ 120,000 DR2005 Mackey Creek Flood Study 0 120,000 0 0 $ 120,000 DR2002 North Hills Addition-Bewley Drive Drainage Improvements 0 65,000 0 0 $ 65,000 DR2003 Street Drainage Improvements Project(2020) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 405,000 $ 0 $ 0 $ 405,000 Total Project Costs $ 2,134,108 $ 575,000 $ 0 $ 0 $ 2,709,108 Funding Sources Reserves 1,984,108 575,000 0 0 $ 2,559,108 Other 150,000 0 0 0 $ 150,000 Total Sources of Funds $ 2,134,108 $ 575,000 $ 0 $ 0 $ 2,709,108 Ordinance No.3600 Attachment B Page 12 of 22 Schedule 3 Utility Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects UT1801 Assess and Repair 16-inch Water Transmission Main 500,000 0 0 0 $ 500,000 UT0201 Big Fossil Creek Wastewater Outran 1,231,604 0 0 0 $ 1,231,604 UT1701 College Hill Ground Storage Tank Stand Pipe 85,000 0 0 0 $ 85,000 UT1601 Franklin Court Sewer Addition and Gifford Connection 150,000 0 0 0 $ 150,000 UT1402 Johnson Pump Station Component and Infrastructure Replacements 275,000 0 0 0 $ 275,000 UT1901 Large Valve Replacement Project 95,000 0 0 0 $ 95,000 UT1902 Main/Snider/Center Utility Project 225,000 0 0 0 $ 225,000 UT1903 Miscellaneous Water/Sewer Main Replacement(2019) 445,000 0 0 0 $ 445,000 UT1404 Motor Operated Transfer Valves 730,000 0 0 0 $ 730,000 UT1703 Sanitary Sewer System Rehabilitation(Various Locations) 150,000 0 0 0 $ 150,000 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 98,120 0 0 0 $ 98,120 UT1904 Sewer Manhole Replacement and Rehabilation Project 150,000 0 0 0 $ 150,000 UT1705 Small Water Main Replacements(2017) 420,000 0 0 0 $ 420,000 UT1905 Small Water Main Replacements(2019) 440,000 0 0 0 $ 440,000 UT1906 Telemetric Water Meter Annual Maintenance(2019) 400,000 0 0 0 $ 400,000 UT1607 Walker Branch Interceptor Project 6,016,525 0 0 0 $ 6,016,525 UT0810 Western Center Water Facility Expansion 55,000 0 0 0 $ 55,000 Total Continuing Projects $ 11,466,249 $ 0 $ 0 $ 0 $ 11,466,249 New Projects UT2004 24"Wastewater Main Replacement 0 1,255,000 0 0 $ 1,255,000 UT2008 Conn Pump Station Pump and Electrical Rehabilitation 0 1,500,000 0 0 $ 1,500,000 CDBG20 Garwood Drive Sanitary Sewer(CDBG) 0 15,000 0 0 $ 15,000 UT2002 Miscellaneous Water/Sewer Main Replacement(2020) 0 445,000 0 0 $ 445,000 UT2001 Small Water Main Replacements(2020) 0 440,000 0 0 $ 440,000 UT2003 Telemetric Water Meter Annual Maintenance(2020) 0 400,000 0 0 $ 400,000 UT2006 Utility Risk and Resiliency Assessment 0 150,000 0 0 $ 150,000 Total New Projects $ 0 $ 4,205,000 $ 0 $ 0 $ 4,205,000 Total Project Costs $ 11,466,249 $ 4,205,000 $ 0 $ 0 $ 15,671,249 Funding Sources Certificates of Obligation 6,239,724 3,640,000 0 0 $ 9,879,724 Reserves 2,226,525 565,000 0 0 $ 2,791,525 I Other 3,000,000 0 0 0 $ 3,000,000 Total Sources of Funds $ 11,466,249 $ 4,205,000 $ 0 $ 0 $ 15,671,249 Ordinance No.3600 Attachment B Page 13 of 22 Schedule 4 Parks & Recreation Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects PK1901 Annual Tree Planting 2019 45,000 0 0 0 $ 45,000 PK1701 Barfield Family Foundation Grant Program 19,283 0 0 0 $ 19,283 PK1801 Green Valley Raceway Historical Area 60,717 50,000 0 0 $ 110,717 PK1802 Hometown Lakes Pedestrian Bridge Trail Connections 80,000 0 0 0 $ 80,000 GC1901 Iron Horse Golf Course Improvements 285,000 3,000,000 0 0 $ 3,285,000 PK1902 Linda Spurlock Park Renovation 189,000 811,000 0 0 $ 1,000,000 PK1603 NdrthfieldParkRenovation 6,125,312 0 0 0 $ 6,125,312 PK1903 NRH Centre Indoor Aquatic Pool Re-Plaster 120,000 0 0 0 $ 120,000 PK1506 Park Infrastructure Maintenance 2015 232,597 0 0 0 $ 232,597 PK1804 Park Infrastructure Maintenance 2018 301,905 0 0 0 $ 301,905 PK1904 Park Infrastructure Maintenance 2019 285,907 0 0 0 $ 285,907 PK1606 Park System Signage 479,486 0 0 0 $ 479,486 PK1905 Richland Tennis Center Infrastructure Maintenance 2019 20,000 0 0 0 $ 20,000 PK1806 Trail and On-Road Safety Projects 730,543 0 0 0 $ 730,543 Total Continuing Projects $ 8,974,750 $ 3,861,000 $ 0 $ 0 $ 12,835,750 New Projects PK2004 Park Infrastructure Maintenance(2020) 0 190,000 0 0 $ 190,000 PK2005 Richland Tennis Center Infrastructure Improvements(2020) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 290,000 $ 0 $ 0 $ 290,000 Total Project Costs $ 8,974,750 $ 4,151,000 $ 0 $ 0 $ 13,125,750 Funding Sources Certificates of Obligation 4,185,000 3,000,000 0 0 $ 7,185,000 Federal/State Grants 1,076,217 0 0 0 $ 1,076,217 Reserves 663,855 811,000 0 0 $ 1,474,855 Sales Tax 1,978,488 235,000 0 0 $ 2,213,488 Other 1,071,190 105,000 0 0 $ 1,176,190 Total Sources of Funds $ 8,974,750 $ 4,151,000 $ 0 $ 0 $ 13,125,750 Ordinance No.3600 Attachment B Page 14 of 22 Schedule 5 Aquatic Park Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects WP1901 General Facility Improvements(2019) 100,000 0 0 0 $ 100,000 Total Continuing Projects $ 100,000 $ 0 $ 0 $ 0 $ 100,000 New Projects WP2001 General Facility Improvements(2020) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 100,000 $ 0 $ 0 $ 100,000 Total Project Costs $ 100,000 $ 100,000 $ 0 $ 0 $ 200,000 Funding Sources Reserves 100,000 100,000 0 0 $ 200,000 Total Sources of Funds $ 100,000 $ 100,000 $ 0 $ 0 $ 200,000 Ordinance No.3600 Attachment B Page 15 of 22 Schedule 6 Facilities Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects FC1205 City Hall(Municipal Government Complex) 71,410,715 0 0 0 $ 71,410,715 FC1701 Overhead Door Replacement 52,000 0 0 0 $ 52,000 FC1702 Overhead Door Safety Edges&Remote Control Assemblies 68,800 0 0 0 $ 68,800 FC1902 Permanent Records Roof Replacement&Building Envelope Seal 78,000 0 0 0 $ 78,000 FC1903 Replacement of HVAC Systems at Fire Stations#1 and#4 59,000 0 0 0 $ 59,000 FC1904 Upgrade/Remodel of Public Works'Restrooms 75,000 0 0 0 $ 75,000 Total Continuing Projects $ 71,743,515 $ 0 $ 0 $ 0 $ 71,743,515 New Projects FC2001 Carpet Replacement at the Public Library 0 321,000 0 0 $ 321,000 FC2002 Fencing around Fire Training pad 0 52,000 0 0 $ 52,000 Total New Projects $ 0 $ 373,000 $ 0 $ 0 $ 373,000 Total Project Costs $ 71,743,515 $ 373,000 $ 0 $ 0 $ 72,116,515 Funding Sources General Obligation Bonds 48,250,000 0 0 0 $ 48,250,000 Certificates of Obligation 18,600,000 320,000 0 0 $ 18,920,000 Reserves 2,459,228 53,000 0 0 $ 2,512,228 Other 2,434,287 0 0 0 $ 2,434,287 Total Sources of Funds $ 71,743,515 $ 373,000 $ 0 $ 0 $ 72,116,515 Ordinance No.3600 Attachment B Page 16 of 22 Schedule 7 Major Capital Equipment Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Proiect Costs Continuing Projects IS1401 Cell Phone Signal Boosters in NRH Centre 98,000 0 0 0 $ 98,000 FS1901 Crack Sealing Machine Replacement(Unit 6632) 95,000 0 0 0 $ 95,000 FS1902 Distributor Truck Replacement(Unit681) 200,000 0 0 0 $ 200,000 FS1903 Dump Truck Replacement(Unit 6617) 120,412 0 0 0 $ 120,412 IT1701 Enterprise Computer System Replacement 3,173,980 0 0 0 $ 3,173,980 IT1901 Network Replacement for Offsite City Facilities 122,500 98,000 0 0 $ 220,500 FS1904 Pothole Patcher Replacement(Unit 6609) 202,588 0 0 0 $ 202,588 IT1702 Public Safety Technology 1,306,000 0 0 0 $ 1,306,000 IS1502 Replacement of CAD/RMS Public Safety Software Platform 3,020,000 0 0 0 $ 3,020,000 FS1912 Replacement of Fire Truck(Unit 945) 1,285,000 0 0 0 $ 1,285,000 FS1909 Utility Tractor Replacement(Unit 787) 55,000 0 0 0 $ 55,000 FS1910 Utility Tractor Replacement(Unit788) 34,500 0 0 0 $ 34,500 FS1911 Vac-con Replacement(Unit 5522) 402,000 0 0 0 $ 402,000 Total Continuing Projects $ 10,114,980 $ 98,000 $ 0 $ 0 $ 10,212,980 New Projects FS2001 Ambulance Replacement(Unit 977) 0 364,411 0 0 $ 364,411 FS2002 Backhoe Replacement(Unit 483) 0 140,000 0 0 $ 140,000 FS2003 Backhoe Replacement(Unit 5525) 0 140,000 0 0 $ 140,000 FS2004 Fuel System Enhancements 0 163,000 0 0 $ 163,000 IT2001 Purchase/Replacement of Storage Area Network(SAN)Hardware 0 175,000 100,000 0 $ 275,000 FS2005 Roller Replacement(Unit 6620) 0 65,000 0 0 $ 65,000 FS2006 Utility Tractor Replacement(Unit 790) 0 65,000 0 0 $ 65,000 FS2008 Wheel Loader Replacement(Unit 6602) 0 220,000 0 0 $ 220,000 FS2007 Wheel Loader Replacement(Unit 685) 0 220,000 0 0 $ 220,000 Total New Projects $ 0 $ 1,552,411 $ 100,000 $ 0 $ 1,652,411 Total Project Costs $ 10,114,980 $ 1,650,411 $ 100,000 $ 0 $ 11,865,391 Funding Sources Certificates of Obligation 4,814,588 1,215,000 0 0 $ 6,029,588 Federal/State Grants 375,817 0 0 0 $ 375,817 Reserves 1,924,575 435,411 100,000 0 $ 2,459,986 Other 3,000,000 0 0 0 $ 3,000,000 Total Sources of Funds $ 10,114,980 $ 1,650,411 $ 100,000 $ 0 $ 11,865,391 Ordinance No.3600 Attachment B Page 17 of 22 Schedule 8 Economic Development Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Protect Costs Continuing Projects ED0801 Business Improvement and Growth(BIG)Program 350,000 0 0 0 $ 350,000 ED1901 Davis Boulevard Improvement 2019 450,000 0 0 0 $ 450,000 ED1002 Loop 820 Redevelopment 2010 1,595,572 0 0 0 $ 1,595,572 ED1602 Loop 820 Redevelopment 2016 7,250,000 0 0 0 $ 7,250,000 ED1501 Neighborhood Revitalization Program(NRP) 336,184 0 0 0 $ 336,184 PW0402 Sign Removal Assistance Program 50,000 0 0 0 $ 50,000 ED0601 TIF 1 Expansion-Intersection Improvements/Utility Burial 3,000,000 0 0 0 $ 3,000,000 ED1503 TOD Land Management 1,200,000 0 0 0 $ 1,200,000 Total Continuing Projects $ 14,231,756 $ 0 $ 0 $ 0 $ 14,231,756 Total Project Costs $ 14,231,756 $ 0 $ 0 $ 0 $ 14,231,756 Funding Sources Certificates of Obligation 3,000,000 0 0 0 $ 3,000,000 Reserves 9,284,097 0 0 0 $ 9,284,097 Other 1,947,659 0 0 0 $ 1,947,659 Total Sources of Funds $ 14,231,756 $ 0 $ 0 $ 0 $ 14,231,756 Ordinance No.3600 Attachment B Page 18 of 22 Schedule 9 CIP Personnel Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects UC1901 Utility Capital Projects Personnel 666,661 336,657 0 0 $ 1,003,318 Total Continuing Projects $ 666,661 $ 336,657 $ 0 $ 0 $ 1,003,318 Total Project Costs $ 666,661 $ 336,657 $ 0 $ 0 $ 1,003,318 Funding Sources Reserves 666,661 336,657 0 0 $ 1,003,318 Total Sources of Funds $ 666,661 $ 336,657 $ 0 $ 0 $ 1,003,318 Ordinance No.3600 Attachment B Page 19 of 22 Schedule 10 Other Capital Projects Budget Summary Project To 2019/20 2020/21 2021 To Total Date Proposed Estimated Completion Project Costs Continuing Projects - - ES0902 Litter Not Program 25,000 0 0 0 $ 25,000 - - ES0901 Neighborhood Initiative Program 407,158 0 0 0 $ 407,158 - - PL1501 Strategic Plan 168,638 0 0 0 $ 168,638 Total Continuing Projects $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Total Project Costs $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Funding Sources Reserves 407,158 0 0 0 $ 407,158 Sales Tax 93,638 0 0 0 $ 93,638 Other 100,000 0 0 0 $ 100,000 Total Sources of Funds $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Ordinance No.3600 Attachment B Page 20 of 22 Schedule 11 2018-19 Budget Revisions Budget Summary Adopted Budget 2018-19 Project Project Through Revision Revised Number Name 2018-19 2018-19 Budget STREET&SIDEWALK CAPITAL PROJECTS ST0102 Rufe Snow Improvements(Karen to 820) $1,475,950 ($7,303) $1,468,647 ST0401 Davis Blvd/Mid-Cities Blvd Intersection $7,359,231 $330,769 7,690,000 ST1701 Vance and Glenview Signal UpgradE 230,000 7,303 237,303 ST1201 Rufe Snow Drive&Glenview Drive Intersection Improvement: 1,685,000 (4,389) 1,680,611 ST1701 Vance and Glenview Signal UpgradE 237,303 4,389 241,692 Sub-Total $10,987,484 $330,769 $11,318,253 DRAINAGE CAPITAL PROJECTS DR1701 Walker Branch Channel Repair $627,850 ($320,000) $307,850 DR1503 Calloway Branch Channel Repair Project 1,126,258 320,000 1,446,258 Sub-Total $1,754,108 $0 $1,754,108 PARKS&RECREATION CAPITAL PROJECTS PK1603 Northfield Park Renovation $6,116,659 $8,653 $6,125,312 • PK1504 Northfield Park Security Lights/Electrical Systerr $35,000 ($8,653) 26,347 PK1201 Adventure World Playground Renovator $653,239 ($667) 652,572 PK1401 Barfield/Cotton Belt Trail Connector $65,000 ($932) 64,068 PK1805 Iron Horse Pump House A $100,000 ($2,116) 97,884 PK1703 Park Infrastructure Maintenance 2017 $257,000 ($308) 256,692 PK1904 Park Infrastructure Maintenance 2015 284,000 1,907 285,907 PK1701 Barfield Family Foundation Grant Prograrr 50,000 (30,717) 19,283 PK1801 Green Valley Raceway Historical Ares 30,000 30,717 60,717 1 Sub-Total $7,590,898 ($2,116) $7,588,782 UTILITY CAPITAL PROJECTS CDBG18 Meadow Court Road Reconstruction(CDBG) $308,456 ($10,878) $297,578 UT1804 Telemetric Water Meter Annual Maintenance(2018) 400,000 (64) 399,936 UT0201 Big Fossil Creek Wastewater Outfall 1,200,000 31,604 1,231,604 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 125,000 (31,604) 93,396 UT1802 Miscellaneous Water/Sewer Main Replacements(2018) 420,000 50,886 470,886 UT1803 Small Water Main Replacements(2018) 420,000 (50,886) 369,114 UT1702 Small Water Main Replacements(2017) 420,000 (29,483) 390,517 UT1803 Small Water Main Replacements(2018) 369,114 27,049 396,163 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 93,396 4,724 98,120 UT1604 Sanitary Sewer Line Replacements(Crabtree&Onyx N.) 125,000 (4,724) 120,276 Sub-Total $3,880,966 ($13,376) $3,867,590 MAJOR CAPITAL EQUIPMENT FS1802 Backhoe Replacement(Unit#479) $125,000 ($34,655) $90,345 FS1903 Dump Truck Replacement(Unit 6617) $120,000 $412 120,412 FS1904 Pothole Patcher Replacement(Unit 6609: $210,000 ($412) 209,588 FS1803 Bucket Truck Replacement Unit 602 $220,000 ($85,243) 134,757 F$1801 Ambulance Replacement Unit 972 $362,232 ($2,681) 359,551 FS1907 Skid Steer Loader Replacement Unit 663C $90,000 ($10,550) 79,450 FS1908 Street Sweeper Replacement Unit 6612 $70,000 ($18,000) 52,000 FS1905 NRH/Senior Centre Accessible Van $62,000 ($1,021) 60,979 FS1906 NRH/Senior Centre Accessible Van $62,000 ($1,021) 60,979 FS1904 Pothole Patcher Replacement(Unit 6609: $209,588 ($7,000) 202,588 FS1911 Vac-con Replacement(Unit 5522) $395,000 $7,000 402,000 IS1402 Replacement of Fuel Management Software Systerr $135,025 ($4,289) 130,736 IT1701 Enterprise Computer System Replacement $3,000,000 $173,980 3,173,980 Sub-Total $5,060,845 $16,520 $5,077,365 AQUATIC CAPITAL PROJECTS WP1801 General Facility Improvements(2018) $100,000 ($2,661) $97,339 WP1802 Main Filtration Replacement 600,000 (8,513) 591,487 Sub-Total $700,000 ($11,174) $688,826 FACILITY CAPITAL PROJECTS FC1803 Fire Maintenance Awninc $60,000 ($250) $59,750 Sub-Total $60,000 ($250) $59,750 ECONOMIC DEVELOPMENT PROJECTS ED1901 Davis Boulevard Development 2015 $0 $450,000 $450,000 Sub-Total $0 $450,000 $450,000 Ordinance No.3600 Attachment B Page 21 of 22 Schedule 11 2018-19 Budget Revisions Budget Summary Adopted Budget 2018-19 Project Project Through Revision Revised Number Name 2018-19 2018-19 Budget OTHER CAPITAL PROJECTS PL1501 Strategic Plan $150,000 $18,638 $168,638 Sub-Total $150,000 $18,638 $168,638 Total All Projects $30,184,301 $789,011 $30,973,312 SOURCES OF FUNDS General Obligation Bonds $2,475,950 $0 $2,475,950 Certificates of Obligations 11,578,702 (93,756) 11,484,946 Federal/State Grants 5,198,730 501,476 5,700,206 Reserves 6,756,180 (337,347) 6,418,833 Sales Tax 1,670,014 469,305 2,139,319 Other 2,504,725 249,333 2,754,058 Total Sources of Funds $30,184,301 $789,011 $30,973,312 Ordinance No.3600 Attachment B Page 22 of 22