The URL can be used to link to this page

Home My WebLink AboutOrdinance 3475 ORDINANCE NO. 3475 AN ORDINANCE ADOPTING THE BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2017 THOURGH SEPTEMBER 30, 2018, 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, 2016 THROUGH SEPTEMBER 30, 2017, PROVIDING FOR INVESTMENTS AND TRANSFERS; PROVIDING A SEVERABILITY CLAUSE AND PROVIDING AND 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 a budget proposal 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 City Council finds that all provisions pertaining to the adoption of a 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, TEX. LOC. GOV'T Code, the 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 28, 2017, 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. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL, CITY OF NORTH RICHLAND HILLS, TEXAS, THAT: SECTION 1. The budget of the Revenues of the City of North Richland Hills and the Expenses of conducting the affairs thereof for the ensuing Fiscal Year beginning October 1, 2017 and ending September 30, 2018, as modified by the City Council attached hereto as Exhibit A, be, and the same is, in all things, adopted and approved as the said City of North Richland Hills budget for the Fiscal Year beginning the first day of October, 2017, and ending the thirtieth day of September, 2018. Ordinance No. 3475 Page 1 of 3 SECTION 2. The City Manager be and 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 3. The City Manager or his designee be and 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 4. The amended budget for the City of North Richland Hills for the fiscal year beginning October 1, 2016, and ending September 30, 2017, filed herewith and included in Exhibit A is hereby amended and approved. SECTION 5. The amended capital projects budget for the City of North Richland Hills for the fiscal year beginning October 1, 2016, and ending September 30, 2017, filed herewith and included in Exhibit A is hereby amended and approved. 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. 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. PASSED AND APPROVED on this the 11th day of September, 2017. CIT • /NOR airHLAND HILLS Y B jAdrAM Osc 'e Mayor Ordinance No. 3475 Page 2 of 3 ATTEST: \\ '\\F ... Alicia Richardson, Cityretary •:;� e APPROVED AS TO FORM AND LEGALITY: A\/\ ak'IG:W■: Maleshia B. McGinnis, City Attorney APPROVED AS TO CONTENT: Robert Myers, Bu:get & Research Director Ordinance No. 3475 Page 3 of 3 Exhibit A - Ordinance No. 3475 FISCAL YEAR 2017-2018 SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Taxes $29,106,753 $30,382,593 $31,053,012 $31,157,009 $32,144,108 Fines&Forfeitures 2,222,995 1,892,511 2,077,475 2,181,888 2,175,366 Licenses&Permits 1,852,803 2,796,748 2,134,034 2,421,348 2,205,406 Charges for Service 2,184,223 2,421,983 2,243,192 2,455,699 2,401,541 Intergovernmental 4,556,084 5,215,730 5,413,175 5,421,290 5,446,957 Miscellaneous 2,634,492 1,601,013 2,253,797 2,553,595 2,233,234 SUB-TOTAL $42,557,349 $44,310,579 $45,174,685 $46,190,829 $46,606,612 APPROPRIATION FROM FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Fund 3,250 59,851 130,000 130,000 0 Utility Assistance Program 1,906 0 0 0 0 PEG Fees 5,500 0 0 0 0 Record Preservation Fee 8,000 0 0 0 0 Previous Year Encumbrances 102,079 428,833 0 184,621 0 General Fund Reserves 1,200,000 3,870,000 0 0 0 SUB-TOTAL APPROPRIATIONS $1,320,735 $4,358,684 $130,000 $314,621 $0 TOTAL REVENUES $43,878,084 $48,669,263 $45,304,685 $46,505,450 $46,606,612 EXPENDITURES City Council $116,848 $119,155 $130,378 $130,378 $131,079 City Manager 595,828 637,412 641,381 641,646 667,063 Communications 339,844 344,974 360,125 367,928 367,310 City Secretary 426,363 399,561 427,800 449,387 447,396 Legal 265,100 337,071 314,000 327,679 385,803 Human Resources 122,253 131,385 139,776 139,988 150,464 Finance 625,357 682,896 690,732 703,248 720,828 Budget&Research 359,536 366,334 400,576 375,143 412,093 Municipal Court 1,335,981 1,382,680 1,448,105 1,462,637 1,388,506 Planning and Inspections 1,030,914 1,054,078 1,142,820 1,163,194 1,271,250 Economic Development 310,638 325,017 330,433 329,371 336,148 Library 2,033,512 1,960,936 2,146,480 2,158,300 2,200,342 Neighborhood Services 1,644,081 1,701,576 1,806,011 1,844,295 1,978,654 Public Works 3,989,119 3,061,675 3,271,770 3,254,269 3,185,518 Parks&Recreation 2,024,804 2,033,662 2,115,117 2,147,067 2,148,142 Police 12,644,381 13,208,533 13,582,482 13,553,599 14,440,270 Emergency Management 828,451 795,810 1,005,152 1,044,438 0 Fire 10,664,645 11,049,544 11,720,494 12,007,819 12,931,029 Building Services 737,070 848,774 836,737 836,737 812,101 Non-Departmental 767,629 1,112,210 1,098,506 959,635 1,067,329 SUB-TOTAL DEPARTMENTS $40,862,354 $41,553,282 $43,608,875 $43,896,758 $45,041,325 RESERVES&OTHER EXPENDITURES Reserves $211,929 $1,180,306 $1,176,950 $1,369,492 $1,180,291 Transfers Out 1,642,623 4,050,653 307,975 407,975 187,725 Other 28,000 253,495 210,885 831,225 197,271 SUB-TOTAL RESERVES AND OTHER $1,882,551 $5,484,454 $1,695,810 $2,608,692 $1,565,287 TOTAL EXPENDITURES $42,744,905 $47,037,736 $45,304,685 $46,505,450 $46,606,612 BALANCE $1,133,179 $1,631,527 $0 $0 $0 1 FISCAL YEAR 2017-2018 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 TAXES Current Property Taxes $13,773,694 $14,813,054 $15,254,440 $15,535,833 $15,966,660 Delinquent Property Taxes 114,085 59,740 110,000 100,000 264,799 Penalty and Interest 135,959 123,473 135,200 135,200 135,200 Franchise Fees 4,406,765 4,360,700 4,264,770 3,942,953 4,103,418 Utility Fund Franchise Taxes 857,706 823,128 945,688 914,505 943,831 Sales Taxes 9,297,668 9,675,943 9,808,431 9,992,202 10,192,046 Mixed Beverages 138,100 139,062 143,500 145,333 145,333 Payment in Lieu of Taxes 382,777 387,493 390,983 390,983 392,821 SUB-TOTAL $29,106,753 $30,382,593 $31,053,012 $31,157,009 $32,144,108 FINES AND FORFEITURES Municipal Court Fines $1,946,216 $1,661,309 $1,842,975 $1,933,312 $1,926,790 Warrant&Arrest Fees 212,774 168,976 174,500 188,576 188,576 Library Fines 64,005 62,227 60,000 60,000 60,000 SUB-TOTAL $2,222,995 $1,892,511 $2,077,475 $2,181,888 $2,175,366 LICENSES AND PERMITS Building Permits $706,249 $1,601,749 $1,000,000 $1,262,248 $1,076,000 Electrical Permits 43,436 84,552 70,560 53,600 50,000 Plumbing Permits 99,046 150,256 126,950 126,950 126,950 Mechanical Permits 70,977 93,281 72,480 91,233 77,000 Gas Drilling Permits 20,000 0 10,000 10,000 0 Burglar Alarm Permits 55,358 89,755 100,000 100,000 100,000 Miscellaneous Permits 91,467 92,875 79,410 93,167 86,881 Apartment Inspection Fees 98,279 100,646 100,000 100,000 102,400 Curb&Drainage Insp.Fees 112,179 56,117 70,058 64,510 62,569 Re-Inspection Fees 18,146 19,996 15,600 21,015 21,000 License Fees 21,970 19,425 21,600 19,000 19,000 Contractor Registration Fees 93,024 97,795 93,050 84,828 93,050 Plan/Review/Application Fee 74,734 37,334 43,780 42,981 38,743 Animal License/Adoption Fees 53,178 62,979 58,200 66,828 66,000 Animal Control Impoundment 26,250 23,972 23,000 23,000 23,825 Auto Impoundment Fees 13,856 12,402 13,000 13,000 13,000 Food Service Permits 151,286 157,936 153,346 161,053 161,053 Food Managers School 29,970 5,278 3,000 7,935 7,935 Fire Inspection/Alarm Fees 73,399 90,400 80,000 80,000 80,000 SUB-TOTAL $1,852,803 $2,796,748 $2,134,034 $2,421,348 $2,205,406 CHARGES FOR SERVICE Park Facility Rental $8,475 $7,378 $8,325 $8,175 $8,325 Ambulance Fees 1,527,887 1,737,332 1,596,000 1,782,302 1,706,000 Garbage Billing 399,090 429,813 412,427 440,891 440,891 Contributions 10,000 10,000 10,000 10,000 10,000 Recreation Fees 194 560 400 455 400 Athletic Revenue 114,306 119,694 121,805 97,585 119,625 Recreation Special Events 8,094 10,197 12,235 0 10,000 Planning&Zoning Fees 43,616 41,496 35,000 48,202 40,000 Sale of Accident Reports 6,389 7,129 6,000 7,289 7,300 Vital Statistics 27,453 0 0 0 0 Mowing 31,679 53,348 35,000 55,000 53,000 Fire Dept Certification/CPR Citizen Class 6,793 4,959 6,000 5,800 6,000 Miscellaneous 248 78 0 0 0 SUB-TOTAL $2,184,223 $2,421,983 $2,243,192 $2,455,699 $2,401,541 2 FISCAL YEAR 2017-2018 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 INTERGOVERNMENTAL Indirect Costs: Utility Fund 2,090,315 2,194,831 2,304,573 2,304,572 2,304,572 Park&Rec Facilities Dev.Corp. 410,189 448,405 474,033 476,676 498,789 Crime Control District 4,871 22,821 27,169 29,812 29,582 Aquatic Park Fund 151,139 158,696 166,631 166,631 174,963 Consolidation Reimbursements 1,899,570 2,390,977 2,440,769 2,443,599 2,439,051 SUB-TOTAL $4,556,084 $5,215,730 $5,413,175 $5,421,290 $5,446,957 MISCELLANEOUS Interest Income $137,172 $111,336 $95,193 $143,282 $117,282 Radio Reimbursement 195,467 234,422 273,609 257,395 273,609 Sale of City Property 14,424 10,981 3,000 5,683 3,000 Grant Proceeds 18,124 0 20,000 20,000 84,249 Overtime Reimbursements 15,545 5,057 0 14,702 5,000 Teen Court Reimbursement 20,405 20,300 21,272 20,300 20,114 Other Income 85,595 112,096 93,670 345,180 129,980 Golf Course Loan Repayment 147,760 147,760 147,764 147,764 0 Designated Funds for City Hall Project Debt 2,000,000 959,062 1,599,289 1,599,289 1,600,000 SUB-TOTAL $2,634,492 $1,601,013 $2,253,797 $2,553,595 $2,233,234 APPROPRIATION-FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Funds 3,250 59,851 130,000 130,000 0 Utility Assistance Program 1,906 0 0 0 0 PEG Fees 5,500 0 0 0 0 Record Preservations Fee 8,000 0 0 0 0 Previous Year Encumbrances 102,079 428,833 0 184,621 0 General Fund Designated Reserves 1,200,000 3,870,000 0 0 0 SUB-TOTAL $1,320,735 $4,358,684 $130,000 $314,621 $0 TOTAL REVENUES $43,878,084 $48,669,263 $45,304,685 $46,505,450 $46,606,612 3 FISCAL YEAR 2017-2018 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 EXPENDITURES City Council $116,848 $119,155 $130,378 $130,378 $131,079 City Manager $595,828 $637,412 $641,381 $641,646 $667,063 Communications Public Information $222,562 $230,571 $238,994 $247,395 $247,870 Citicable 117,283 114,403 121,131 120,533 119,440 Total Communications $339,844 $344,974 $360,125 $367,928 $367,310 City Secretary City Secretary $272,461 $288,668 $300,584 $324,501 $339,701 Record Management 153,902 110,892 127,216 124,886 107,695 Total City Secretary $426,363 $399,561 $427,800 $449,387 $447,396 Legal $265,100 $337,071 $314,000 $327,679 $385,803 Human Resources $122,253 $131,385 $139,776 $139,988 $150,464 Finance Accounting&Administration $433,457 $461,137 $450,989 $462,666 $461,784 Purchasing 191,900 221,759 239,743 240,582 259,044 Total Finance $625,357 $682,896 $690,732 $703,248 $720,828 Budget&Research Budget $144,830 $151,577 $156,056 $137,826 $162,867 Tax 191,991 191,613 220,638 220,638 225,157 Internal Audit 22,716 23,144 23,882 16,679 24,069 Total Budget&Research $359,536 $366,334 $400,576 $375,143 $412,093 Municipal Court Administration/Prosecution $416,897 $477,794 $429,732 $441,547 $367,483 Court Records 433,356 457,649 494,807 496,464 497,022 Warrants 393,936 351,547 419,604 420,311 417,696 Teen Court 91,792 95,691 103,962 104,315 106,305 Total Municipal Court $1,335,981 $1,382,680 $1,448,105 $1,462,637 $1,388,506 Planning and Development Planning&Administration 252,651 266,585 334,523 335,335 346,773 Inspections 778,263 787,492 808,297 827,859 924,477 Total Planning and Development $1,030,914 $1,054,078 $1,142,820 $1,163,194 $1,271,250 Economic Development $310,638 $325,017 $330,433 $329,371 $336,148 Library General Services $219,866 $292,901 $318,647 $364,475 $391,225 Public Services 944,570 807,046 907,136 914,988 912,701 Technical Services 869,076 860,990 920,697 878,837 896,416 Total Library $2,033,512 $1,960,936 $2,146,480 $2,158,300 $2,200,342 4 FISCAL YEAR 2017-2018 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 Neighborhood Services Neighborhood Resources $252,792 $305,443 $310,050 $316,173 $337,406 Animal Services 711,251 682,246 710,594 732,287 770,927 Consumer Health 283,853 318,341 325,311 326,494 333,331 Code Compliance 396,185 395,547 460,056 469,341 536,990 Total Neighborhood Services $1,644,081 $1,701,576 $1,806,011 $1,844,295 $1,978,654 Public Works General Services $313,551 $314,271 $334,625 $321,575 $348,214 Traffic Control 1,056,586 1,118,882 1,166,514 1,193,088 1,060,840 Street&Drainage 2,618,981 1,628,522 1,770,631 1,739,606 1,776,464 Total Public Works $3,989,119 $3,061,675 $3,271,770 $3,254,269 $3,185,518 Parks&Recreation General Services $176,013 $180,743 $170,306 $174,687 $176,408 Parks Maintenance 898,649 893,018 942,460 969,500 954,402 Recreation Services 487,102 487,102 487,102 487,102 487,102 Athletic Program Services 166,711 165,716 191,236 190,706 196,186 Senior Adult Services 250,309 267,035 278,327 279,386 287,908 Youth Outreach&Cultural 46,021 40,049 45,686 45,686 46,136 Total Parks&Recreation $2,024,804 $2,033,662 $2,115,117 $2,147,067 $2,148,142 Police General Services $1,033,408 $1,123,316 $1,118,932 $1,145,785 $1,153,635 Administrative Services 489,975 478,814 532,180 553,372 578,388 Criminal Investigations 2,250,625 2,466,203 2,476,851 2,480,559 2,625,500 Uniform Patrol 5,260,552 5,163,999 5,274,066 5,265,634 5,562,210 Detention Services 1,359,044 1,501,067 1,589,236 1,576,959 1,642,093 Property Evidence 303,640 321,507 362,264 359,064 529,136 Communications 1,947,137 2,153,627 2,228,953 2,172,226 2,349,308 Total Police $12,644,381 $13,208,533 $13,582,482 $13,553,599 $14,440,270 Emergency Management $828,451 $795,810 $1,005,152 $1,044,438 $0 Fire Department General Services $361,806 $384,216 $396,273 $398,056 $439,947 Operations 8,185,792 8,498,293 8,997,235 9,005,203 9,290,758 Emergency Medical 1,501,204 1,503,372 1,668,416 1,776,217 1,578,105 Fire Inspections 615,843 663,662 658,570 667,542 765,133 Emergency Management 0 0 0 160,801 857,086 Total Fire $10,664,645 $11,049,544 $11,720,494 $12,007,819 $12,931,029 Building Services $737,070 $848,774 $836,737 $836,737 $812,101 Non Departmental $767,629 $1,112,210 $1,098,506 $959,635 $1,067,329 SUB-TOTAL DEPARTMENTS $40,862,354 $41,553,282 $43,608,875 $43,896,758 $45,041,325 5 FISCAL YEAR 2017-2018 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 RESERVES&OTHER EXPENDITURES Other Economic Development Incentives $28,000 $103,495 $210,885 $215,020 $197,271 Legal Settlement 0 150,000 0 616,205 0 Other Total $28,000 $253,495 $210,885 $831,225 $197,271 Transfers Capital Projects $1,476,198 $3,924,950 $180,000 $180,000 $25,000 Capital Projects-Sidewalk Maintenance 68,000 50,000 50,000 50,000 50,000 Fleet Services 21,040 0 0 0 0 Information Services 77,385 75,703 77,975 77,975 82,725 Neighborhood Revitalization Program 0 0 0 100,000 30,000 Transfers Total $1,642,623 $4,050,653 $307,975 $407,975 $187,725 Contribution to Reserves General Fund Reserves $0 $1,000,000 $1,000,000 $1,215,141 $1,025,941 Public,Educational,Governmental(PEG)Fees 11,929 180,306 176,950 154,351 154,350 Tranportation Projects(Future) 200,000 0 0 0 0 Contribution to Reserves Total $211,929 $1,180,306 $1,176,950 $1,369,492 $1,180,291 TOTAL RESERVES&OTHER EXPENDITURES $1,882,551 $5,484,454 $1,695,810 $2,608,692 $1,565,287 TOTAL EXPENDITURES $42,744,905 $47,037,737 $45,304,685 $46,505,450 $46,606,612 BALANCE $1,133,178 $1,631,526 $0 $0 $0 6 FISCAL YEAR 2017-2018 SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: M&O I&S TOTAL Total Appraised Value as of July 25,2017 6,358,270,025 Less: Absolute Exemption (359,527,429) Cases Before ARB (329,784,186) Incomplete Accounts (86,359,214) Disabled Veteran (21,834,225) Over 65 (170,405,699) Homestead (441,721,036) Disabled Persons (8,363,482) Freeport Inventory Value Loss (621,268) Pollution Control (34,824) Solar&Wind Powered Devices (2) Nominal Value Accounts (72,857) Miscellaneous Personal Property 0 In Process (234,348) Total Reduction to Values (1,418,958,570) NET TAXABLE VALUE AT JULY 25,2017 4,939,311,455 Add: Estimated Minimum ARB protested values 190,918,935 Incomplete Property 33,119,801 ESTIMATED NET TAXABLE VALUE AT JULY 25,2017 224,038,736 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 5,163,350,191 Less:TIF#1 Incremental Value (8,323,069) Less:TIF#1A Incremental Value 5,872,079 Less:TIF#2 Incremental Value (444,242,488) Less:Tax Ceiling Taxable Values (629,180,517) Net Taxable Values 4,087,476,196 Proposed Tax Rate per$100 Valuation 0.328640 0.261360 0.590000 Estimated Total Tax Levy at 100%Collection 13,433,082 10,683,052 24,116,134 Less:Estimated Uncollectable(1.5%) (201,496) (201,496) Less:Estimated l&S Uncollectable(1.5%) (160,246) (160,246) Estimated Revenue from Property Tax 13,071,340 10,683,052 23,754,392 Estimated Revenue from Property Tax* 13,071,340 10,683,052 23,754,392 Plus:Tax Ceiling Account Revenue 2,850,072 - 2,850,072 Less:Estimated Uncollectable(1.5%) (42,751) - (42,751) Plus:TIF Tax Rate Differential(2 cents) 89,339 - 89,339 Less:Estimated I&S Uncollectable(1.5%) (1,340) - (1,340) ESTIMATED PROPERTY TAX DISTRIBUTION 15,966,660 10,683,052 26,649,712 7 FISCAL YEAR 2017-2018 SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES General Debt Service Taxes $8,840,000 $8,391,108 $9,674,703 $9,674,703 $10,683,052 SUB-TOTAL AD VALOREM TAXES $8,840,000 $8,391,108 $9,674,703 $9,674,703 $10,683,052 Transfer in From: Drainage Utility $565,838 $553,789 $447,197 $373,018 $362,674 Park&Rec.Facilities Dev.Corp 341,536 329,055 320,393 320,393 627,685 Fleet Services Fund 447,714 480,406 448,414 448,414 0 Facilities Services Fund 24,670 27,399 26,193 26,193 0 Donations Fund 0 34,849 37,279 41,400 0 SUB-TOTAL TRANSFER IN $1,379,758 $1,425,498 $1,279,476 $1,209,418 $990,359 Proceeds Bond Issuance Proceeds $5,910,943 $1,046,865 $0 $0 $0 Interest Income 15,685 15,418 10,883 6,500 6,500 City of Watauga,CIP Participation 82,853 82,853 82,853 82,853 82,853 Miscellaneous Revenues 108 31 0 0 0 Transfer In 0 2,424,790 607,721 607,721 0 Appropriation of Fund Balance 648,073 581,736 0 41,286 0 SUB-TOTAL OTHER $6,657,662 $4,151,693 $701,457 $738,360 $89,353 TOTAL REVENUES $16,877,420 $13,968,299 $11,655,636 $11,622,481 $11,762,764 EXPENDITURES Existing Bonds&C.O.'s $10,923,172 $12,641,854 $11,561,900 $11,528,745 $11,724,765 Issuance Costs/Paying Agent Fees 258,140 45,517 93,736 93,736 37,999 Bond Defeaseance/Refunding 5,648,056 1,020,134 0 0 0 TOTAL EXPENDITURES $16,829,369 $13,707,505 $11,655,636 $11,622,481 $11,762,764 BALANCE $48,051 $260,794 $0 $0 $0 Notes: (1)Beginning in Fiscal Year 2014/2015,TIF activitiy will be reported on Schedule 7-Tax Increment Financing Fund 8 FISCAL YEAR 2017-2018 SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: TAX INCREMENT FINANCING DISTRICT#1 Taxable Value(2017 Tax Year) $9,475,998 Less: Base Taxable Value(1998 Tax Year) 1,152,929 Taxable Value Increment(2016 Tax Year) Gain/(Loss): $8,323,069 TAX INCREMENT FINANCING DISTRICT#1A Taxable Value(2017 Tax Year) $77,740,723 Less: Base Taxable Value(2008 Tax Year) 83,563,510 Taxable Value Increment(2016 Tax Year) Gain/(Loss): ($5,822,787) TAX INCREMENT FINANCING DISTRICT#2 Taxable Value(2017 Tax Year) $451,035,894 Less: Base Taxable Value(1998 Tax Year) 40,020,188 Taxable Value Increment(2016 Tax Year) Gain/(Loss): $411,015,706 ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE TAX INCREMENT FINANCING DISTRICT#1 Current Taxable Value Increment:TIF District#1 $8,323,069 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#1 Property Tax Revenue at 100% $47,441 Estimated Collection Rate 98.50% Estimated TIF District#1 Property Tax Revenue $46,730 TAX INCREMENT FINANCING DISTRICT#1A Current Taxable Value Increment:TIF District#1A $0 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#1A Property Tax Revenue at 100% $0 Estimated Collection Rate 98.50% Estimated TIF District#1A Property Tax Revenue $0 TAX INCREMENT FINANCING DISTRICT#2 Current Taxable Value Increment:TIF District#2 $411,015,706 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#2 Property Tax Revenue at 100% $2,342,790 Estimated Collection Rate 98.50% Estimated TIF District#2 Property Tax Revenue $2,307,648 TOTAL ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE(1) $2,354,378 Notes: (I)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. 9 FISCAL YEAR 2017-2018 SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 TAX INCREMENT FINANCING DISTRICT#1 REVENUES Tax Increment Financing District#1 Taxes City of North Richland Hills 41,834 $22,458 $44,750 $45,432 $46,730 Tarrant County Hospital District 16,726 16,726 18,164 18,164 18,968 Tarrant County College District 10,972 10,972 11,916 11,916 12,046 Tarrant County 0 19,376 21,042 21,042 21,141 Birdville ISD 105,318 106,705 114,376 114,376 121,009 Sub-Total 174,849 $176,236 $210,248 $210,930 $219,894 Other Funding Sources Investment Income 8,287 $7,687 $4,500 $5,816 $5,816 Bond Defeasance/Refunding Proceeds 122,383 0 0 0 0 Appropriation of Fund Balance 512,717 497,745 451,047 451,047 433,935 Sub-Total 643,387 $505,432 $455,547 $456,863 $439,751 TOTAL REVENUES 818,236 $681,668 $665,795 $667,793 $659,645 EXPENDITURES&TRANSFERS TIF#1 Debt Service 695,852 $681,668 $665,795 $665,795 $659,645 Bond Defeasance/Refunding 122,384 0 0 0 0 TOTAL EXPENDITURES 818,236 $681,668 $665,795 $665,795 $659,645 BALANCE 0 $0 $0 $1,998 $0 TAX INCREMENT FINANCING DISTRICT#2 REVENUES Tax Increment Financing District#2 Taxes City of North Richland Hills 1,412,841 $1,568,740 $1,895,692 $1,896,052 $2,307,648 Tarrant County Hospital District 556,250 691,531 769,476 769,476 998,181 Tarrant County College District 381,177 453,674 504,775 504,775 633,902 Tarrant County 707,616 801,082 891,375 891,375 1,112,493 Sub-Total 3,057,885 $3,515,026 $4,061,318 $4,061,678 $5,052,224 Other Funding Sources Investment Income 3,544 $12,003 $0 $0 $0 Bond Defeasance/Refunding Proceeds 4,646,137 $997,157 $0 $0 $0 Sub-Total 4,649,681 $1,009,160 $0 $0 $0 TOTAL REVENUES 7,707,566 $4,524,186 $4,061,318 $4,061,678 $5,052,224 EXPENDITURES&TRANSFERS TIF#2 Debt Service 2,503,532 $2,146,045 $2,344,585 $2,344,585 $2,292,323 Bond Defeasance/Refunding 4,646,137 $1,005,586 $0 $0 $0 Sub-Total 2,503,532 $2,146,045 $2,344,585 $2,344,585 $2,292,323 TOTAL EXPENDITURES 2,503,532 $2,146,045 $2,344,585 $2,344,585 $2,292,323 BALANCE 5,204,033 $2,378,141 $1,716,733 $1,717,093 $2,759,901 10 FISCAL YEAR 2017-2018 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Sales Tax $4,648,842 $4,837,974 $4,904,216 $4,995,905 $5,095,823 Interest Income 21,367 26,801 19,378 25,640 26,160 Youth Assn.Maintenance Fees 47,444 38,245 55,910 58,918 44,500 Tennis Center Revenue 329,384 368,664 372,350 374,148 372,550 Transfer in from Aquatic Park Fund 77,379 81,248 83,685 83,685 87,869 Park Impact Fees 60,635 104,351 70,000 70,000 70,000 Grants/Foundation 0 95,686 50,000 200,000 0 Other Income 46,351 50,733 1,000 15,533 500 SUB-TOTAL $5,231,403 $5,603,703 $5,556,539 $5,823,829 $5,697,402 NRH CENTRE Memberships/Drop-In Passes $1,425,002 $1,385,697 $1,491,000 $1,375,000 $1,420,000 Fitness 385,800 450,633 398,260 441,000 429,000 Recreation/Sports 234,463 237,921 272,340 245,980 274,000 Grand Hall Rental 184,919 184,074 203,750 231,895 232,100 Catering&Event Fees 15,215 11,062 13,420 17,900 17,900 Aquatic Programs 218,325 224,422 212,580 227,580 237,500 Pool Rental 4,061 3,200 5,000 5,000 5,500 Gym Rental 1,991 3,108 3,100 4,000 4,000 Concessions/Merchandise 30,919 24,602 27,000 36,400 27,000 Special Events 8,374 8,802 10,000 10,000 10,000 Other 22,967 20,705 15,300 20,000 24,000 General Fund 487,102 487,102 487,102 487,102 487,102 SUB-TOTAL $3,019,137 $3,041,328 $3,138,852 $3,101,857 $3,168,102 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $0 $8,767 $0 $41,307 $0 Appropriation of Park Impact Fee Reserves 0 0 130,000 1,030,000 135,000 Appropriation of Sales Tax Reserves 0 0 0 100,536 0 SUB-TOTAL $0 $8,767 $130,000 $1,171,843 $135,000 TOTAL REVENUES $8,250,540 $8,653,798 $8,825,391 $10,097,529 $9,000,504 11 FISCAL YEAR 2017-2018 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 EXPENDITURES OPERATING Park Facilities Development Admin. $710,339 $731,370 $756,856 $773,072 $764,159 Parks&Public Grounds 1,883,460 1,894,305 2,078,873 2,082,439 2,155,009 Tennis Center Operations 550,900 562,987 632,254 641,176 616,486 SUB-TOTAL $3,144,700 $3,188,661 $3,467,983 $3,496,687 $3,535,654 NRH CENTRE Center Management $659,089 $636,010 $731,388 $774,631 $792,553 Fitness 367,092 481,875 394,551 394,551 395,271 Building Operations 197,357 197,335 211,904 249,749 203,842 Aquatic 524,000 539,337 577,321 577,674 625,629 Recreation Sports 279,766 293,449 355,033 345,209 358,837 Event Center 231,986 249,876 352,168 340,953 362,838 Building Services 320,000 360,750 351,900 351,900 294,150 SUB-TOTAL $2,579,290 $2,758,632 $2,974,265 $3,034,667 $3,033,120 OTHER&RESERVES Debt Services-CO's 341,536 329,055 320,393 320,393 627,685 Indirect Costs 410,189 448,405 474,033 476,676 498,789 Non-Departmental 40,319 83,209 58,437 92,170 50,127 Transfers to Capital Projects Capital Projects 407,949 510,544 536,000 636,536 575,400 Capital Projects-Grant/Donation/Foundation 0 0 0 150,000 0 Capital Projects-Impact Fees 0 55,000 200,000 1,100,000 205,000 Contributions to Reserves Operating Reserve 726,219 0 507,088 598,312 211,938 Impact Fee Reserve 0 49,351 0 0 0 Economic Development Reserve 116,221 120,949 122,605 124,898 127,396 NRH Centre Reserve 450,999 282,909 164,587 67,190 135,395 SUB-TOTAL $2,493,432 $1,879,423 $2,383,143 $3,566,175 $2,431,730 TOTAL EXPENDITURES $8,217,422 $7,826,716 $8,825,391 $10,097,529 $9,000,504 BALANCE $33,118 $827,082 $0 $0 $0 12 FISCAL YEAR 2017-2018 SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Sales Tax $4,624,993 $4,810,105 $4,872,587 $4,970,436 $5,069,844 Franchise Tax 95,538 76,443 87,248 47,129 87,248 Interest Income 2,140 4,347 2,472 3,134 3,028 SRO Reimibursement(BISD) 174,244 198,650 203,890 209,520 210,918 Other 0 39,159 0 7,219 0 Prior Year Encumbrances 0 152,219 0 70,214 0 Appropriation of Fund Balance 17,439 0 1,197,160 1,197,160 9,557 SUB-TOTAL $4,914,354 $5,280,923 $6,363,357 $6,504,812 $5,380,595 EXPENDITURES Administration $0 $115,215 $9,500 $9,500 $9,500 Administrative Services 710,799 850,948 918,572 921,839 1,006,895 Investigations 418,933 419,162 483,781 485,584 510,117 Uniform Patrol 2,749,387 2,840,031 2,935,565 2,935,933 3,046,166 Technical Services 528,698 506,928 548,783 550,529 565,477 Property Evidence 156,317 188,672 202,338 271,810 30,400 SUB-TOTAL $4,564,135 $4,920,957 $5,098,539 $5,175,195 $5,168,555 OTHER&RESERVES Partner Agency Funding $61,146 $73,570 $73,100 $73,100 $84,288 Other 77,525 77,712 88,549 82,108 98,170 Indirect Costs 4,871 22,821 27,169 29,812 29,582 Transfer to Capital Projects 0 0 1,076,000 1,076,000 0 Reserves 0 0 0 68,597 0 SUB-TOTAL $143,542 $174,103 $1,264,818 $1,329,617 $212,040 TOTAL EXPENDITURES $4,707,677 $5,095,059 $6,363,357 $6,504,812 $5,380,595 BALANCE $206,677 $185,864 $0 $0 $0 13 FISCAL YEAR 2017-2018 SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Occupancey Tax Proceeds $232,793 $275,072 $255,253 $255,253 $255,253 Interest Income 3,436 3,828 2,836 2,836 3,769 Prior Year Encumbrances 0 6,000 0 0 0 SUB-TOTAL $236,229 $284,900 $258,089 $258,089 $259,022 TOAL REVENUES $236,229 $284,900 $258,089 $258,089 $259,022 EXPENDITURES Economic Development $98,084 $108,337 $116,580 $118,140 $120,280 Cultural&Leisure 90,546 101,416 133,986 134,197 132,158 Non-Departmental 215 123 904 639 443 Contribution to Reserves 0 0 6,619 5,113 6,141 SUB-TOTAL $188,846 $209,876 $258,089 $258,089 $259,022 TOTAL EXPENDITURES $188,846 $209,876 $258,089 $258,089 $259,022 BALANCE $47,383 $75,024 $0 $0 $0 14 FISCAL YEAR 2017-2018 SCHEDULE 11 -SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Contributions NRH Water Bills $59,251 $56,457 $57,183 $59,080 $59,080 SUB-TOTAL $59,251 $56,457 $57,183 $59,080 $59,080 Donations Spay/Neuter $18,206 $13,809 $15,000 $13,800 $13,800 Shelter Fund 48,958 26,391 23,500 23,850 23,850 Duncan 15,250 15,500 15,000 15,000 15,000 Santa Cops 5,000 8,123 5,500 2,631 2,600 SUB-TOTAL $87,414 $63,823 $59,000 $55,281 $55,250 Proceeds Library Book Sale $9,547 $9,152 $6,650 $10,700 $9,000 SUB-TOTAL $9,547 $9,152 $6,650 $10,700 $9,000 Other Interest Income $4,672 $5,002 $3,814 $4,620 $4,620 Other Income 85,595 127,366 94,600 139,165 136,500 Appropriation of Fund Balance Teen Court 0 3,000 0 0 400 Library 19,546 19,086 43,196 43,196 24,265 Neighborhood Services 58,500 4,969 4,969 4,969 4,969 Parks&Recreations 40,908 37,986 42,375 42,375 18,920 Police 1,100 3,409 4,750 4,750 9,000 SUB-TOTAL $210,321 $200,818 $193,704 $239,075 $198,674 TOTAL REVENUES $366,532 $330,251 $316,537 $364,136 $322,004 EXPENDITURES Library-Book Collection $48,682 $57,651 $81,225 $81,225 $76,420 Neighborhood Services Animal Services 31,626 13,551 25,310 27,310 29,310 Keep NRH Beautiful 9,555 11,168 19,969 19,969 19,969 Municipal Court-Teen Court 7,000 5,200 5,000 5,000 5,000 Parks-Special Events and Arts 34,987 53,752 67,000 83,800 94,000 Police Department 22,720 32,157 39,250 64,358 45,000 Transfers Out 78,500 44,849 37,279 41,400 41,400 TOTAL EXPENDITURES $233,069 $218,327 $275,033 $323,062 $311,099 BALANCE $133,463 $111,924 $41,504 $41,074 $10,905 15 FISCAL YEAR 2017-2018 SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Forefeited Funds $67,598 $112,118 $111,000 $111,000 $111,000 AFIS Reimbursements 12,759 13,500 13,500 13,500 26,250 911 Telecom 178,779 148,290 178,000 0 0 Interest Income 4,563 2,821 2,781 2,034 2,034 Other Income 79 112,175 45,000 0 0 Prior Year Encumbrances 0 0 0 39,531 0 Appropriation of Fund Balance 68,296 128,317 96,719 142,466 113,016 TOTAL REVENUES $332,075 $517,221 $447,000 $308,531 $252,300 EXPENDITURES Federal Forefeited Funds $61,178 $86,556 $100,000 $139,067 $100,000 MDT Maintenance 0 13,238 0 0 0 Radio Maintenance 0 14,962 0 0 0 State Forfeitured Funds 31,016 40,591 100,000 100,000 100,000 Local Forfeited Funds 1,000 62,382 46,000 46,000 1,000 AFIS Maintenance&Equipment 18,357 19,446 23,000 23,464 51,300 911 Telecom 61,058 147,638 178,000 0 0 Leose Contributions 0 0 0 0 0 Reserve for City Hall Project: 911 Telecom 55,010 0 0 0 0 Automated Fingerprint Identification Sys.(AFIS) 0 0 0 0 0 Reserves 0 0 0 0 0 TOTAL EXPENDITURES $227,619 $384,813 $447,000 $308,531 $252,300 BALANCE $104,456 $132,407 $0 $0 $0 16 FISCAL YEAR 2017-2018 SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Drainage Fees $860,836 $881,379 $861,000 $861,000 $867,849 Interest Income 5,948 7,419 5,269 5,269 5,269 Appropriation of Fund Balance 800,000 0 305,928 305,928 317,406 SUB-TOTAL $1,666,784 $888,797 $1,172,197 $1,172,197 $1,190,524 TOTAL REVENUES $1,666,784 $888,797 $1,172,197 $1,172,197 $1,190,524 EXPENDITURES Debt Service $565,838 $553,789 $447,197 $373,018 $362,674 Transfer to Capital Projects 800,000 0 695,000 695,000 797,850 Other Expenditures 33,557 130,559 30,000 30,000 30,000 Contribution to Reserves 0 0 0 74,179 0 TOTAL EXPENDITURES $1,399,395 $684,348 $1,172,197 $1,172,197 $1,190,524 BALANCE $267,389 $204,449 $0 $0 $0 17 FISCAL YEAR 2017-2018 SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES BONUSES General Fund Purposes $5,040 $0 $0 $0 $0 SUB-TOTAL $5,040 $0 $0 $0 $0 ROYALITIES/OVERRIDES General Fund Purposes $664,788 $263,932 $203,061 $350,000 $217,000 SUB-TOTAL $664,788 $263,932 $203,061 $350,000 $217,000 OTHER Right of Way Usage Fees $3,160 $0 $0 $0 $0 Sales of Property 0 3,202,805 0 0 0 Interest Income 14,230 6,851 1,035 2,300 2,300 Other Income 0 0 53,100 55,350 93,373 SUB-TOTAL $17,390 $3,209,656 $54,135 $57,650 $95,673 APPROPRIATION OF RESERVES General Fund Purposes $0 $2,796,070 $0 $0 $0 SUB-TOTAL $0 $2,796,070 $0 $0 $0 TOTAL REVENUES $687,218 $6,269,658 $257,196 $407,650 $312,673 EXPENDITURES OPERATING Transfer to Capital Projects $20,000 $2,796,070 $0 $0 $100,000 Interfund Loan Repayment 0 3,226,239 0 0 0 Contribution to Reserves 0 0 257,196 307,650 212,673 Other 0 0 0 100,000 0 TOTAL EXPENDITURES $20,000 $6,022,309 $257,196 $407,650 $312,673 BALANCE $667,218 $247,348 $0 $0 $0 18 FISCAL YEAR 2017-2018 SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES Gross Fine Revenues $1,226,566 $1,322,940 $1,096,776 $1,096,776 $1,002,236 Interest Income 3,384 5,349 3,046 5,780 5,780 Transfer from General CIP 0 0 0 0 0 Prior Year Encumbrances 0 0 0 59,981 0 Appropriation of Fund Balance 0 0 5,222 35,006 0 TOTAL REVENUES $1,229,951 $1,328,289 $1,105,044 $1,197,543 $1,008,016 EXPENDITURES Contractor Payments $601,820 $552,770 $612,000 $661,230 $612,000 Program Administration 191,977 160,573 237,286 291,272 322,937 Payment to State 216,385 275,184 123,745 102,128 33,296 Traffic Enforcement/Traffic Safety 26,373 6,075 115,767 126,667 22,508 Pedestrian Safety 15,033 15,921 16,246 16,246 16,568 Transfer to Capital Projects 0 0 0 0 0 Contribution to Reserves 0 0 0 0 707 SUB-TOTAL OTHER EXPENDITURES $1,051,588 $1,010,523 $1,105,044 $1,197,543 $1,008,016 TOTAL EXPENDITURES $1,051,588 $1,010,523 $1,105,044 $1,197,543 $1,008,016 BALANCE $178,363 $317,766 $0 $0 $0 19 FISCAL YEAR 2017-2018 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES WATER SALES AND CHARGES Water Sales $18,490,684 $18,651,612 $20,550,893 $19,826,818 $21,440,826 Water Taps 28,715 52,000 32,070 39,000 34,515 Water Inspection Fees 33,770 28,613 27,120 27,455 24,882 SUB-TOTAL $18,553,169 $18,732,225 $20,610,083 $19,893,273 $21,500,223 SEWER SALES AND CHARGES Sewer Sales $9,838,360 $9,960,496 $11,001,674 $11,001,674 $11,259,548 Sewer Taps 9,825 14,350 9,900 9,900 10,600 Sewer Inspection Fees 27,161 20,943 25,300 24,000 24,000 SUB-TOTAL $9,875,346 $9,995,788 $11,036,874 $11,035,574 $11,294,148 MISCELLANEOUS Interest Income $94,614 $95,997 $72,464 $78,309 $78,309 Service Charges 88,952 155,166 153,180 153,930 153,200 Late Charges 432,123 417,162 456,918 421,822 420,000 Miscellaneous 43,618 59,232 36,542 53,815 51,634 Joint Use Reimbursement-Watauga 60,439 111,265 94,700 104,048 104,048 Subdivision Meter Revenue 43,380 61,903 45,710 53,565 49,332 Bond Refunding Proceeds 107,085 792,063 0 0 0 Interfund Loan Repayments 0 3,310,868 0 0 0 SUB-TOTAL $870,211 $5,003,654 $859,514 $865,489 $856,523 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $63,150 $43,824 $0 $385,280 $0 Appropriation of Fund Balance 2,076,449 2,882,572 1,752,804 2,308,380 685,883 SUB-TOTAL $2,139,599 $2,926,396 $1,752,804 $2,693,660 $685,883 TOTAL REVENUES $31,438,325 $36,658,064 $34,259,275 $34,487,996 $34,336,777 20 FISCAL YEAR 2017-2018 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 EXPENDITURES OPERATING Administration $296,621 $311,446 $321,057 $322,195 $334,024 Development 791,669 814,543 882,243 884,192 896,822 Right of Way Maintenance 149,328 145,520 233,754 233,754 233,754 SUB-TOTAL $1,237,617 $1,271,508 $1,437,054 $1,440,141 $1,464,600 WATER SERVICES Water Operations $4,199,796 $4,101,097 $4,777,957 $4,794,953 $4,701,399 Purchase of Water FTW 4,726,223 4,139,257 4,957,292 5,305,876 4,787,352 Purchase of Water TRA 5,059,788 5,911,008 5,328,960 5,013,600 5,788,101 SUB-TOTAL $13,985,806 $14,151,362 $15,064,209 $15,114,429 $15,276,852 SEWER SERVICES Sewer Operations $1,285,498 $1,273,582 $1,431,799 $1,434,536 $1,455,258 Sewer Treatment FTW 1,307,619 1,588,456 1,431,223 1,453,574 1,390,101 Sewer Treatment TRA 3,602,954 4,142,146 3,955,418 4,040,531 4,561,306 SUB-TOTAL $6,196,071 $7,004,184 $6,818,440 $6,928,641 $7,406,665 FINANCE/UTILITY COLLECTIONS Meter Reading $464,214 $463,574 $503,697 $504,404 $519,638 Utility Billing/Customer Service 809,496 845,117 869,621 944,031 974,423 Utility Collection Services 282,857 276,130 290,015 290,545 240,027 Accounting Services 361,333 391,193 405,571 423,753 420,264 Budget&Research 206,950 211,529 219,546 201,584 227,555 SUB-TOTAL $2,124,850 $2,187,543 $2,288,450 $2,364,317 $2,381,907 Building Services $1,598,063 $1,752,816 $1,822,929 $1,822,929 $1,822,929 Non Departmental $219,211 $178,106 $283,355 $283,883 $291,069 SUB-TOTAL DEPARTMENTS $25,361,619 $26,545,520 $27,714,437 $27,954,340 $28,644,022 OTHER&RESERVES Debt Service $1,091,823 $1,060,260 $1,128,595 $1,148,596 $1,119,008 Bond Defeasance/Refunding 107,085 798,283 0 0 0 Franchise Fees 857,706 823,128 945,688 914,505 943,831 Indirect Costs 2,090,315 2,194,830 2,304,572 2,304,572 2,304,572 Payment in Lieu of Taxes 382,777 387,493 390,983 390,983 392,821 Transfer to Information Technology 175,000 175,000 175,000 175,000 175,000 Transfer to Equipment Services 50,000 50,000 0 0 0 Transfer to Capital 1,322,000 208,262 1,600,000 1,600,000 757,523 Contribution to Reserves 0 3,226,239 0 0 0 SUB-TOTAL $6,076,706 $8,923,494 $6,544,838 $6,533,656 $5,692,755 TOTAL EXPENDITURES $31,438,325 $35,469,014 $34,259,275 $34,487,996 $34,336,777 BALANCE $0 $1,189,050 $0 $0 $0 21 FISCAL YEAR 2017-2018 SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 ATTENDANCE 227,525 221,101 255,000 240,000 255,000 REVENUES OPERATING Admissions $3,109,013 $2,733,058 $3,442,500 $3,436,850 $3,678,150 Food and Beverage 805,873 837,352 1,009,352 979,570 1,019,552 Merchandise 127,737 143,644 157,836 151,900 158,100 Rentals 148,066 142,436 249,787 183,787 249,787 Aquatic Classes/Special Events 3,823 2,096 0 0 0 SUB-TOTAL $4,194,512 $3,858,587 $4,859,475 $4,752,107 $5,105,589 OTHER REVENUES Interest Income $13,337 $12,403 $8,900 $12,600 $12,600 Other Income 46,201 149,139 50,000 50,964 50,250 Bond Refunding Proceeds 954,326 206,912 0 0 0 SUB-TOTAL $1,013,863 $368,454 $58,900 $63,564 $62,850 SUB-TOTAL REVENUES $5,208,375 $4,227,040 $4,918,375 $4,815,671 $5,168,439 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $637,974 $488,641 $531,000 $531,000 $100,000 SUB-TOTAL $637,974 $488,641 $531,000 $531,000 $100,000 TOTAL REVENUES $5,846,349 $4,715,681 $5,449,375 $5,346,671 $5,268,439 EXPENDITURES OPERATING General Services&Utilities $790,280 $850,094 $918,666 $853,973 $850,866 Public Grounds/Aquatics/Maint. 1,155,830 1,189,848 1,237,395 1,219,953 1,253,254 Business&Office Administration 558,520 608,201 598,421 595,984 602,287 Gift Shop/Concessions 535,119 571,046 612,490 626,530 632,994 Sales/Special Events/Admissions 230,591 254,431 279,256 265,842 288,297 SUB-TOTAL $3,270,342 $3,473,621 $3,646,228 $3,562,282 $3,627,698 OTHER&RESERVES Debt Service $776,753 $461,386 $956,140 $953,108 $904,109 Bond Defeasance/Refunding 954,326 209,105 0 0 0 Indirect Costs 151,139 158,696 166,631 166,631 174,963 Transfer Out-PARD 77,379 81,248 83,685 83,685 87,869 Transfer to Capital Projects 575,000 288,675 531,000 531,000 100,000 Reserve For Infrastructure&Major Repairs 0 0 18,025 4,415 323,749 Non-Departmental 41,410 42,950 47,666 45,550 50,051 SUB-TOTAL $2,576,008 $1,242,060 $1,803,147 $1,784,389 $1,640,741 TOTAL EXPENDITURES $5,846,349 $4,715,681 $5,449,375 $5,346,671 $5,268,439 BALANCE $0 $0 $0 $0 $0 22 FISCAL YEAR 2017-2018 SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 ROUNDS 45,339 43,250 51,300 50,000 51,000 REVENUES Green Fees $870,480 $971,821 $1,006,024 $1,008,000 $1,002,000 Pro Shop 388,861 400,426 353,090 394,586 392,000 Driving Range 92,330 86,163 85,000 87,000 85,000 Carts 370,048 401,580 391,436 409,187 391,000 Food&Beverage 660,051 728,709 650,000 692,566 690,000 General&Administrative 405 1,167 0 1,200 1,167 Other Revenue 41,355 39,018 909 14,438 13,904 Appropriation of Fund Balance 0 27,796 0 0 0 TOTAL REVENUE $2,423,530 $2,656,679 $2,486,459 $2,606,977 $2,575,071 EXPENDITURES OPERATING Pro Shop $158,563 $132,812 $162,461 $160,837 $165,461 Pro Shop:Cost of Goods Sold 138,415 154,542 139,750 153,000 143,000 Driving Range 8,562 10,446 11,200 11,200 16,200 Golf Carts 230,040 230,142 223,866 218,671 222,224 Course Maintenance 542,122 598,974 586,385 586,385 626,700 Food&Beverage 263,935 307,435 252,346 275,703 280,952 Food&Beverage:Cost of Goods Sold 197,226 208,740 201,500 201,500 215,660 Sales&Membership 54,682 51,649 54,370 57,030 56,764 General&Administrative 264,863 290,979 229,143 229,143 232,523 Clubhouse 126,275 115,306 121,144 121,144 120,544 Management Fees 137,560 146,353 109,698 112,399 113,434 Capital 0 67,297 130,707 130,707 217,641 SUB-TOTAL $2,122,244 $2,314,676 $2,222,570 $2,257,719 $2,411,103 OTHER&RESERVES Debt Service $119,516 $109,615 $116,125 $116,350 $63,968 Transfer to Capital Projects 0 0 0 0 100,000 Payment to Interdepartmental Loans Water Fund 0 84,628 0 0 0 General Fund 147,760 147,760 147,764 147,764 0 Contribution to Reserves 5,385 0 0 85,144 0 SUB-TOTAL $272,661 $342,003 $263,889 $349,258 $163,968 TOTAL EXPENDITURES $2,394,905 $2,656,679 $2,486,459 $2,606,977 $2,575,071 BALANCE $28,625 $0 $0 $0 $0 23 FISCAL YEAR 2017-2018 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $737,070 $848,774 $836,737 $836,737 $812,101 Park Development Fund 320,000 360,750 351,900 351,900 294,150 Utility Fund 1,598,063 1,752,816 1,822,929 1,822,929 1,822,929 SUB-TOTAL $2,655,133 $2,962,340 $3,011,566 $3,011,566 $2,929,180 OTHER REVENUES Insurance Settlements $24,588 $0 $0 $0 $0 Interest Income 14,295 14,887 11,446 13,102 13,102 Rent From Rental Properties 76,804 70,785 72,000 72,000 72,000 Other Income 530 91 0 0 0 SUB-TOTAL $116,217 $85,763 $83,446 $85,102 $85,102 SUB-TOTAL REVENUES $2,771,350 $3,048,103 $3,095,012 $3,096,668 $3,014,282 APPROPRIATION OF FUND BALANCE Building Services Fund Reserves $240,485 $532,064 $28,939 $28,939 $0 Prior Year Encumbrances 0 0 0 31,501 0 SUB-TOTAL $240,485 $532,064 $28,939 $60,440 $0 TOAL REVENUES $3,011,835 $3,580,167 $3,123,951 $3,157,108 $3,014,282 EXPENDITURES General Services $324,362 $329,806 $332,468 $333,175 $345,312 Building Servcies 2,025,558 2,188,912 2,577,848 2,611,468 2,357,416 Rental Property Program 30,385 115,787 46,120 46,120 46,120 Transfer to Capital Budget 294,000 439,116 120,800 120,800 60,000 SUB-TOTAL $2,674,305 $3,073,621 $3,077,236 $3,111,563 $2,808,848 OTHER&RESERVES Debt Service $24,670 $27,399 $26,193 $26,193 $0 Other 13,079 12,591 20,522 17,696 19,084 Contribution of Facility Reserves 21,090 0 0 1,656 186,350 SUB-TOTAL $58,839 $39,990 $46,715 $45,545 $205,434 TOTAL EXPENDITURES $2,733,144 $3,113,611 $3,123,951 $3,157,108 $3,014,282 BALANCE $278,691 $466,556 $0 $0 $0 24 FISCAL YEAR 2017-2018 SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $1,190,157 $1,273,471 $1,389,677 $1,389,677 $968,193 Utility Fund 1,751,354 1,873,949 1,967,647 1,967,647 1,967,647 Utility CIP/Utility Construction 256,945 274,931 288,678 288,678 288,678 Crime Control District 151,692 162,310 170,426 170,426 170,426 Park&Recreation Dev. Fund 128,117 137,085 143,939 143,939 143,939 Other Funds 35,851 38,360 40,278 40,278 40,278 SUB-TOTAL $3,514,116 $3,760,106 $4,000,645 $4,000,645 $3,579,161 OTHER REVENUES Interst Income $16,805 $20,005 $14,551 $17,608 $17,608 Sale of City Property 55,214 49,564 519,408 25,000 50,000 Other Income 30,488 7,212 6,660 6,660 6,660 Transfer from General Fund 21,040 0 0 0 0 Transfer from Utility Fund 50,000 50,000 0 0 0 SUB-TOTAL $173,548 $126,780 $540,619 $49,268 $74,268 SUB-TOTAL REVENUES $3,687,664 $3,886,886 $4,541,264 $4,049,913 $3,653,429 APPROPRIATION OF FUND BALANCE Equipment Services Fund Reserves $542,264 $129,535 $0 $0 $0 Appropriation-PY Encumbrances 0 0 0 41,565 0 SUB-TOTAL $542,264 $129,535 $0 $41,565 $0 TOAL REVENUES $4,229,928 $4,016,421 $4,541,264 $4,091,478 $3,653,429 EXPENDITURES General Services $297,282 $224,090 $342,021 $342,021 $341,567 Equipment Services Operations 1,481,835 1,376,118 1,679,639 1,688,850 1,533,410 Fire Fleet Maintenance 252,134 259,683 314,205 314,912 300,146 Equipment Purchases 300,096 677,721 314,111 314,111 368,535 Fire Vehicles/Equipment 36,638 0 190,815 190,815 76,582 Police Vehicles/Equipment 438,780 344,330 227,779 259,779 537,118 SUB-TOTAL $2,806,765 $2,881,941 $3,068,570 $3,110,488 $3,157,358 OTHER&RESERVES Debt Service $447,714 $480,406 $448,414 $448,414 $0 Transfer to Capital Projects 330,000 178,400 849,000 433,536 192,232 Other 12,506 12,132 18,599 18,246 18,092 Equipment Services Reserve 49,173 0 156,681 80,794 285,747 SUB-TOTAL $839,393 $670,938 $1,472,694 $980,990 $496,071 TOTAL EXPENDITURES $3,646,158 $3,552,879 $4,541,264 $4,091,478 $3,653,429 BALANCE $583,770 $463,542 $0 $0 $0 25 FISCAL YEAR 2017-2018 SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES TELECOMMUNICATIONS Transfer From: General Fund $321,798 $337,942 $353,038 $353,038 $371,220 Park Fund 32,387 34,007 35,708 35,708 37,493 Crime Control District 26,592 27,922 29,318 29,318 30,256 Utility Fund 81,168 85,226 89,489 89,489 93,965 Other Funds 58,297 61,212 64,273 64,273 67,487 SUB-TOTAL $520,242 $546,309 $571,826 $571,826 $600,421 COMPUTERS Transfer From: General Fund $932,796 $979,436 $1,039,779 $1,041,210 $1,096,395 Park Fund 102,370 107,489 112,863 112,863 118,506 Crime Control District 171,086 179,640 188,622 188,622 193,427 Utility Fund 666,505 699,831 734,822 734,822 771,562 Other Funds 281,155 292,212 306,823 306,823 322,166 SUB-TOTAL $2,153,912 $2,258,608 $2,382,909 $2,384,340 $2,502,056 OTHER REVENUES Interest Income $12,055 $12,090 $8,657 $12,322 $12,322 Transmitter Lease 136,940 145,073 152,958 152,958 152,958 Other Income 35,796 7,069 0 0 0 Transfer from General Fund 77,385 75,703 0 77,975 82,725 Transfer from Utility Fund 175,000 175,000 175,000 175,000 175,000 SUB-TOTAL $437,177 $414,935 $336,615 $418,255 $423,005 SUB-TOTAL REVENUES $3,111,331 $3,219,852 $3,291,350 $3,374,421 $3,525,482 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $0 $108,825 $0 $15,000 $0 Appropriation of Information Systems Reserves 1,339,373 0 0 0 0 SUB-TOTAL $1,339,373 $108,825 $0 $15,000 $0 TOAL REVENUES $4,450,704 $3,328,677 $3,291,350 $3,389,421 $3,525,482 EXPENDITURES General Services $245,714 $252,128 $259,577 $259,930 $270,868 Major Computer Systems 298,297 318,606 345,448 345,801 397,658 Microcomputer Systems 605,516 680,208 781,808 798,478 788,657 Telecommunications 354,386 458,954 394,875 395,166 485,886 Data Network 588,592 647,639 769,206 789,126 775,032 GIS System 178,592 161,929 180,523 180,523 181,162 Public Safety 382,167 355,379 363,222 363,752 530,875 SUB-TOTAL $2,653,264 $2,874,841 $3,094,659 $3,132,776 $3,430,138 OTHER&RESERVES Other $8,614 $8,257 $15,982 $13,686 $12,619 Transfer to Capital Projects 1,228,944 95,000 156,000 156,000 0 Reserve for System Improvements 0 0 24,709 86,959 82,725 SUB-TOTAL $1,237,558 $103,257 $196,691 $256,645 $95,344 TOTAL EXPENDITURES $3,890,822 $2,978,098 $3,291,350 $3,389,421 $3,525,482 BALANCE $559,881 $350,579 $0 $0 $0 26 FISCAL YEAR 2017-2018 SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2014/15 FY 2015/16 FY 2016/17 FY 2016/17 FY 2017/18 REVENUES ALLOCATIONS Health/Medical City Contribution $7,405,448 $7,840,526 $8,495,856 $8,495,856 $9,163,410 Health/Medical Employee Contribution 1,829,126 1,927,452 2,130,363 2,130,363 2,312,371 Worker's Compensation 500,390 605,035 584,920 586,463 592,520 Administration Allocation 568,619 400,528 472,832 471,289 512,517 Other Insurance 576,360 567,049 579,182 579,182 696,798 SUB-TOTAL $10,879,943 $11,340,590 $12,263,153 $12,263,153 $13,277,616 OTHER REVENUES Interest Income $54,014 $45,708 $39,430 $39,430 $36,604 Other Income 110,060 153,145 95,800 95,800 95,800 Expenditure Reimbursement 633,327 697,616 400,000 550,000 400,000 SUB-TOTAL $797,401 $896,469 $535,230 $685,230 $532,404 SUB-TOTAL REVENUES $11,677,345 $12,237,059 $12,798,383 $12,948,383 $13,810,020 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $439,392 $1,851,859 $100,000 $987,341 $100,000 SUB-TOTAL $439,392 $1,851,859 $100,000 $987,341 $100,000 TOAL REVENUES $12,116,737 $14,088,917 $12,898,383 $13,935,724 $13,910,020 EXPENDITURES Health/Medical $10,096,330 $11,885,570 $11,027,505 $12,016,061 $11,870,884 Worker's Compensation 840,925 605,035 586,463 586,463 592,520 Personnel Expenses 449,136 470,918 498,956 498,956 515,347 Other Insurance 397,704 484,378 489,183 548,444 589,799 Reserve for Insurance Claims 0 0 10,476 0 0 Other Expenses 145,906 133,194 95,800 95,800 95,800 Life Insurance Premium 86,736 87,958 90,000 90,000 107,000 SUB-TOTAL $12,016,737 $13,667,053 $12,798,383 $13,835,724 $13,771,350 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $100,000 $100,000 $100,000 $100,000 Contribution to Reserves 0 0 0 0 38,670 SUB-TOTAL $100,000 $100,000 $100,000 $100,000 $138,670 TOTAL EXPENDITURES $12,116,737 $13,767,053 $12,898,383 $13,935,724 $13,910,020 BALANCE $0 $321,864 $0 $0 $0 27 Fiscal Year 2017/18 Proposed CIP Budget $13,657,149 Uses of Funds Utility,45.40% Parks& -creation, 12.10% Aquatic Park, 5.13% Facilities,0.44% Major Capital Equipment,5.18% Economic .......... Development, 0.95% Drainage,5.84%_ Street&Sidewalk, CIP Personnel, 22.43% Other,0.36% 2.62% Sources of Funds Federal/State Grants,10.77% Reserves,22.38% Sales Tax,4.21% Other,17.20% C.O.Bonds,41.41% G.O. Bonds,4.03% 1 Summary of Project Expenditures 2017/2018 Capital Improvement Program Project To Proposed Estimated 2019 to Total Program Classification Date 2017/2018 2018/2019 Completion Expenditures Street&Sidewalk 38,100,012 3,063,776 461,000 0 $ 41,624,788 Drainage 2,839,593 797,850 0 0 $ 3,637,443 Utility 4,922,525 6,140,000 0 0 $ 11,062,525 Parks&Recreation 12,111,574 1,652,018 0 0 $ 13,763,592 Aquatic Park 3,911,425 700,000 0 0 $ 4,611,425 Facilities 70,968,118 60,000 0 0 $ 71,028,118 Major Capital Equipment 8,541,651 707,232 2,905,000 0 $ 12,153,883 Economic Development 16,047,826 130,000 0 0 $ 16,177,826 CIP Personnel 3,046,831 357,523 0 0 $ 3,404,354 Other 1,701,661 48,750 0 0 $ 1,750,411 Total CIP Project Expenditures $ 162,191,216 $ 13,657,149 $ 3,366,000 $ 0 $ 179,214,365 2 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Funding Source Date 2017/2018 2018/2019 Completion General Obligation Bonds 57,719,279 550,000 0 0 58,269,279 Certificates of Obligation 33,300,231 5,655,000 460,000 0 39,415,231 Federal/State Grants 23,281,205 1,471,286 0 0 24,752,491 Reserves 32,538,191 3,056,713 1,000 0 35,595,904 Sales Tax 3,601,822 575,400 0 0 4,177,222 Other 11,750,488 2,348,750 2,905,000 0 17,004,238 Total CIP Project Funding $ 162,191,216 $13,657,149 $ 3,366,000 $ 0 $ 179,214,365 3 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/18 2018/19 Completion Street&Sidewalk General Obligation Bonds 7,840,000 550,000 0 0 8,390,000 Certificates of Obligation 6,515,000 1,000,000 460,000 0 7,975,000 Federal/State Grants 18,457,106 853,992 0 0 19,311,098 Reserves 3,557,906 659,784 1,000 0 4,218,690 Other 1,730,000 0 0 0 1,730,000 Street& Sidewalk Sub-Total $ 38,100,012 $ 3,063,776 $ 461,000 $ 0 $ 41,624,788 Drainage General Obligation Bonds 1,629,279 0 0 0 1,629,279 Reserves 1,210,314 797,850 0 0 2,008,164 Drainage Sub-Total $ 2,839,593 $ 797,850 $ 0 $ 0 $ 3,637,443 Utility Certificates of Obligation 1,705,000 3,540,000 0 0 5,245,000 Federal/State Grants 396,000 0 0 0 396,000 Reserves 2,621,525 400,000 0 0 3,021,525 Other 200,000 2,200,000 0 0 2,400,000 Utility Sub-Total $ 4,922,525 $ 6,140,000 $ 0 $ 0 $ 11,062,525 Parks&Recreation Certificates of Obligation 3,900,000 0 0 0 3,900,000 Federal/State Grants 3,382,928 617,294 0 0 4,000,222 Reserves 299,816 359,324 0 0 659,140 Sales Tax 3,076,822 575,400 0 0 3,652,222 Other 1,452,008 100,000 0 0 1,552,008 Parks&Recreation Sub-Total $ 12,111,574 $ 1,652,018 $ 0 $ 0 $ 13,763,592 Aquatic Park Certificates of Obligation 2,600,000 600,000 0 0 3,200,000 Reserves 1,311,425 100,000 0 0 1,411,425 Aquatic Park Sub-Total $ 3,911,425 $ 700,000 $ 0 $ 0 $ 4,611,425 Facilities General Obligation Bonds 48,250,000 0 0 0 48,250,000 Certificates of Obligation 18,600,000 0 0 0 18,600,000 Reserves 1,470,800 60,000 0 0 1,530,800 Other 2,647,318 0 0 0 2,647,318 Facilities Sub-Total $ 70,968,118 $ 60,000 $ 0 $ 0 $ 71,028,118 Major Capital Equipment Certificates of Obligation 1,915,000 515,000 0 0 2,430,000 Federal/State Grants 145,171 0 0 0 145,171 4 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/18 2018/19 Completion Reserves 3,297,480 192,232 0 0 3,489,712 Other 3,184,000 0 2,905,000 0 6,089,000 Major Capital Equipment Sub-Total $ 8,541,651 $ 707,232 $ 2,905,000 $ 0 $ 12,153,883 Economic Development Certificates of Obligation 3,000,000 0 0 0 3,000,000 Reserves 10,600,167 130,000 0 0 10,730,167 Sales Tax 450,000 0 0 0 450,000 Other 1,997,659 0 0 0 1,997,659 Economic Development Sub-Total $ 16,047,826 $ 130,000 $ 0 $ 0 $ 16,177,826 CIP Personnel Certificates of Obligation -4,934,769 0 0 0 -4,934,769 Reserves 7,981,600 357,523 0 0 8,339,123 CIP Personnel Sub-Total $ 3,046,831 $ 357,523 $ 0 $ 0 $ 3,404,354 Other Federal/State Grants 900,000 0 0 0 900,000 Reserves 187,158 0 0 0 187,158 Sales Tax 75,000 0 0 0 75,000 Other 539,503 48,750 0 0 588,253 Other Sub-Total $ 1,701,661 $ 48,750 $ 0 $ 0 $ 1,750,411 Total CIP Project Funding $ 162,1 91,216 $13,657,149 $ 3,366,000 $ 0 $ 179,214,365 5 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Street&Sidewalk General Obligation Bonds G.O. Bonds 1994 Program 760,000 0 0 0 $ 760,000 G.O. Bonds 2003 Program 7,080,000 550,000 0 0 $ 7,630,000 General Obligation Bonds $ 7,840,000 $ 550,000 $ 0 $ 0 $ 8,390,000 Certificates of Obligation Certificates of Obligation 6,515,000 1,000,000 460,000 0 $ 7,975,000 Certificates of Obligation $ 6,515,000 $ 1,000,000 $ 460,000 $ 0 $ 7,975,000 Federal/State Grants ISTEA Grant Funds 2,240,040 0 0 0 $ 2,240,040 Other 550,000 0 0 0 $ 550,000 TEA-21 Grant Funds 9,712,000 0 0 0 $ 9,712,000 TXDOT Funding 180,000 0 0 0 $ 180,000 Federal Grant 5,175,066 853,992 0 0 $ 6,029,058 Tarrant County Grant Funds 600,000 0 0 0 $ 600,000 Federal/State Grants $ 18,457,106 $ 853,992 $ 0 $ 0 $ 19,311,098 Reserves 1994 Bond Program Project Savings 440,010 0 0 0 $ 440,010 G.O. Bonds 1994 Program 75,000 0 0 0 $ 75,000 Permanent Sidewalk Maintenance Fund 50,000 102,784 0 0 $ 152,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 2,352,896 0 1,000 0 $ 2,353,896 Bond Program Project Savings 65,000 0 0 0 $ 65,000 Utility Reserve for Future Construction 0 557,000 0 0 $ 557,000 Reserves $ 3,557,906 $ 659,784 $ 1,000 $ 0 $ 4,218,690 Other Other 1,730,000 0 0 0 $ 1,730,000 Other $ 1,730,000 $ 0 $ 0 $ 0 $ 1,730,000 Street&Sidewalk Sub-Total $ 38,100,012 $ 3,063,776 $ 461,000 $ 0 $ 41,624,788 Drainage General Obligation Bonds G.O. Bonds 2003 Program 1,629,279 0 0 0 $ 1,629,279 General Obligation Bonds $ 1,629,279 $ 0 $ 0 $ 0 $ 1,629,279 Reserves Drainage Utility Fund 695,000 797,850 0 0 $ 1,492,850 6 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Reserves 515,314 0 0 0 $ 515,314 Reserves $ 1,210,314 $ 797,850 $ 0 $ 0 $ 2,008,164 Drainage Sub-Total $ 2,839,593 $ 797,850 $ 0 $ 0 $ 3,637,443 Utility Certificates of Obligation Certificates of Obligation 1,705,000 3,540,000 0 0 $ 5,245,000 Certificates of Obligation $ 1,705,000 $ 3,540,000 $ 0 $ 0 $ 5,245,000 Federal/State Grants CDBG Grant Funds 396,000 0 0 0 $ 396,000 Federal/State Grants $ 396,000 $ 0 $ 0 $ 0 $ 396,000 Reserves Reserves 591,525 400,000 0 0 $ 991,525 Unspecified Project Savings 55,000 0 0 0 $ 55,000 Utility Operations for Capital Projects 1,700,000 0 0 0 $ 1,700,000 Utility Reserve for Future Construction 275,000 0 0 0 $ 275,000 Reserves $ 2,621,525 $ 400,000 $ 0 $ 0 $ 3,021,525 Other Impact Fees 200,000 2,200,000 0 0 $ 2,400,000 Other $ 200,000 $ 2,200,000 $ 0 $ 0 $ 2,400,000 Utility Sub-Total $ 4,922,525 $ 6,140,000 $ 0 $ 0 $ 11,062,525 Parks&Recreation Certificates of Obligation Certificates of Obligation 3,900,000 0 0 0 $ 3,900,000 Certificates of Obligation $ 3,900,000 $ 0 $ 0 $ 0 $ 3,900,000 Federal/State Grants ISTEA Grant Funds 2,882,928 0 0 0 $ 2,882,928 TXDOT Funding 0 617,294 0 0 $ 617,294 Federal Grant 500,000 0 0 0 $ 500,000 Federal/State Grants $ 3,382,928 $ 617,294 $ 0 $ 0 $ 4,000,222 Reserves Impact Fees 0 205,000 0 0 $ 205,000 Reserves 71,795 0 0 0 $ 71,795 Project Savings 127,485 154,324 0 0 $ 281,809 Sales Tax Reserve for CIP 100,536 0 0 0 $ 100,536 Reserves $ 299,816 $ 359,324 $ 0 $ 0 $ 659,140 7 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Sales Tax Sales Tax Reserve for CIP 0 402,400 0 0 $ 402,400 Park Sales Tax 3,076,822 173,000 0 0 $ 3,249,822 Sales Tax $ 3,076,822 $ 575,400 $ 0 $ 0 $ 3,652,222 Other Donations Fund 142,000 0 0 0 $ 142,000 Golf Course Reserve 0 100,000 0 0 $ 100,000 Impact Fees 1,155,000 0 0 0 $ 1,155,000 Other 155,008 0 0 0 $ 155,008 Other $ 1,452,008 $ 100,000 $ 0 $ 0 $ 1,552,008 Parks& Recreation Sub-Total $ 12,111,574 $ 1,652,018 $ 0 $ 0 $ 13,763,592 Aquatic Park Certificates of Obligation Certificates of Obligation 2,600,000 600,000 0 0 $ 3,200,000 Certificates of Obligation $ 2,600,000 $ 600,000 $ 0 $ 0 $ 3,200,000 Reserves Aquatic Park Infrastructure Reserve 1,311,425 100,000 0 0 $ 1,411,425 Reserves $ 1,311,425 $ 100,000 $ 0 $ 0 $ 1,411,425 Aquatic Park Sub-Total $ 3,911,425 $ 700,000 $ 0 $ 0 $ 4,611,425 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 Certificates of Obligation Certificates of Obligation 18,600,000 0 0 0 $ 18,600,000 Certificates of Obligation $ 18,600,000 $ 0 $ 0 $ 0 $ 18,600,000 Reserves Future Construction Funds 120,800 0 0 0 $ 120,800 Reserves 0 60,000 0 0 $ 60,000 General Fund Designated Reserves 1,350,000 0 0 0 $ 1,350,000 Reserves $ 1,470,800 $ 60,000 $ 0 $ 0 $ 1,530,800 Other Other 2,434,287 0 0 0 $ 2,434,287 North Tarrant Express ROW Proceeds 213,031 0 0 0 $ 213,031 8 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Other $ 2,647,318 $ 0 $ 0 $ 0 $ 2,647,318 Facilities Sub-Total $ 70,968,118 $ 60,000 $ 0 $ 0 $ 71,028,118 Major Capital Equipment Certificates of Obligation Certificates of Obligation 1,915,000 515,000 0 0 $ 2,430,000 Certificates of Obligation $ 1,915,000 $ 515,000 $ 0 $ 0 $ 2,430,000 FederaUState Grants Other 74,000 0 0 0 $ 74,000 Federal Grant 71,171 0 0 0 $ 71,171 FederaUState Grants $ 145,171 $ 0 $ 0 $ 0 $ 145,171 Reserves Equipment Services Fund 346,000 0 0 0 $ 346,000 Information Services Reserve 1,666,944 0 0 0 $ 1,666,944 Reserves 1,183,536 192,232 0 0 $ 1,375,768 Unspecified Project Savings 31,000 0 0 0 $ 31,000 Utility Fund 70,000 0 0 0 $ 70,000 Reserves $ 3,297,480 $ 192,232 $ 0 $ 0 $ 3,489,712 Other Certificates of Obligation 0 0 2,905,000 0 $ 2,905,000 Other 3,054,000 0 0 0 $ 3,054,000 Court Technology Fund 130,000 0 0 0 $ 130,000 Other $ 3,184,000 $ 0 $ 2,905,000 $ 0 $ 6,089,000 Major Capital Equipment Sub-Total $ 8,541,651 $ 707,232 $ 2,905,000 $ 0 $ 12,153,883 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 Balance 100,000 30,000 0 0 $ 130,000 General Fund Pay-As-You-Go Reserves 50,000 0 0 0 $ 50,000 Reserves 7,781,070 0 0 0 $ 7,781,070 General Fund Designated Reserves 1,200,000 0 0 0 $ 1,200,000 Sales Tax Reserve for Economic Develop 100,000 0 0 0 $ 100,000 Gas Fund Reserves (Designated for ED Ac 1,369,097 100,000 0 0 $ 1,469,097 Reserves $ 10,600,167 $ 130,000 $ 0 $ 0 $ 10,730,167 9 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Sales Tax Sales Tax Reserve for Economic Develop 450,000 0 0 0 $ 450,000 Sales Tax $ 450,000 $ 0 $ 0 $ 0 $ 450,000 Other Other 1,571,184 0 0 0 $ 1,571,184 Commercial Loan 426,475 0 0 0 $ 426,475 Other $ 1,997,659 $ 0 $ 0 $ 0 $ 1,997,659 Economic Development Sub-Total $ 16,047,826 $ 130,000 $ 0 $ 0 $ 16,177,826 CIP Personnel Certificates of Obligation Certificates of Obligation -4,934,769 0 0 0 $ -4,934,769 Certificates of Obligation $ -4,934,769 $ 0 $ 0 $ 0 $ -4,934,769 Reserves General CIP Reserves and Interest Income 995,183 0 0 0 $ 995,183 Utility Reserves and Interest Income 6,986,417 357,523 0 0 $ 7,343,940 Municipal Facilities Project Funding 0 0 0 0 $ 0 Reserves $ 7,981,600 $ 357,523 $ 0 $ 0 $ 8,339,123 CIP Personnel Sub-Total $ 3,046,831 $ 357,523 $ 0 $ 0 $ 3,404,354 Other FederaUState Grants Other 900,000 0 0 0 $ 900,000 FederaUState Grants $ 900,000 $ 0 $ 0 $ 0 $ 900,000 Reserves Other 187,158 0 0 0 $ 187,158 Reserves $ 187,158 $ 0 $ 0 $ 0 $ 187,158 Sales Tax Economic Development Sales Tax 75,000 0 0 0 $ 75,000 Sales Tax $ 75,000 $ 0 $ 0 $ 0 $ 75,000 Other Donations Fund 22,444 0 0 0 $ 22,444 General Fund Balance 50,000 25,000 0 0 $ 75,000 Other 467,059 23,750 0 0 $ 490,809 Reserves 0 0 0 0 $ 0 Other $ 539,503 $ 48,750 $ 0 $ 0 $ 588,253 10 Summary of Project Funding 2017/2018 Capital Improvement Program Funding To Proposed Estimated 2019 to Total Funds Program Date 2017/2018 2018/2019 Completion Other Sub-Total $ 1,701,661 $ 48,750 $ 0 $ 0 $ 1,750,411 Total C/P Project Funding $ 162,191,216 $13,657,149 $ 3,366,000 $ 0 $ 179,214,365 11 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - 2 ST0401 Davis Blvd/Mid-Cities Blvd Intersection 5,200,726 1,502,018 0 0 $ 6,702,744 - 3 ST0904 Grand Avenue(Library to Health Markets Access Road) 75,000 0 0 0 $ 75,000 - 4 ST1403 Illuminated Street Name Sign Replacement Project 75,000 0 0 0 $ 75,000 - - ST1601 Infrastructure Painting Project 100,000 0 0 0 $ 100,000 - 5 ST1101 Main Street Streetscaping Project 66,000 0 461,000 0 $ 527,000 - 6 PW1602 Meadow Lakes Drive&Rufe Snow Drive Intersection 1,315,000 0 0 0 $ 1,315,000 - - SM1601 Preventive Street Maintenance(2016) 800,000 0 0 0 $ 800,000 - - SM1701 Preventive Street Maintenance(2017) 1,000,000 0 0 0 $ 1,000,000 - 8 ST0202 Rufe Snow Dr.Street&Utility Imp.(Mid-Cities to Hightower)[fEA-21] 21,703,236 0 0 0 $ 21,703,236 - 9 ST1201 Rufe Snow Drive&Glenview Drive Intersection Improvements 2,185,000 0 0 0 $ 2,185,000 - - SD1701 Sidewalk Rehabilitation and Replacement Project(2017) 50,000 0 0 0 $ 50,000 - 10 ST1304 Smithfield Road(Davis Blvd to Mid-Cities Blvd) 2,200,000 0 0 0 $ 2,200,000 - 11 ST1102 Snider Street Extension Project 2,800,050 0 0 0 $ 2,600,050 - 12 ST1005 Traffic Signalization at Davis Boulevard&Creek View Drive 300,000 0 0 0 $ 300,000 - 13 ST1701 Vance and Glenview Signal Upgrades 230,000 0 0 0 $ 230,000 Total Continuing Projects $ 38,100,012 $ 1,502,018 $ 461,000 $ 0 $ 40,063,030 New Projects - 14 CDBG18 Meadow Court Road Reconstruction 0 247,837 0 0 $ 247,837 - - SM1801 Preventive Street Maintenance(2018) 0 1,000,000 0 0 $ 1,000,000 - - SD1801 Sidewalk Rehabilitation and Replacement Project(2018) 0 50,000 0 0 $ 50,000 - 15 ST1801 Smithfield Middle School Safe Routes to School(NCTCOG Grant) 0 263,921 0 0 $ 263,921 Total New Projects $ 0 $ 1,561,758 $ 0 $ 0 $ 1,561,758 Total Project Costs $ 38,100,012 $ 3,063,776 $ 461,000 $ 0 $ 41,624,788 Funding Sources General Obligation Bonds G.O.Bonds 1994 Program 760,000 0 0 0 $ 760,000 G.O.Bonds 2003 Program 7,080,000 550,000 0 0 $ 7,630,000 Total General Obligation Bonds $ 7,840,000 $ 550,000 $ 0 $ 0 $ 8,390,000 Certificates of Obligation Certificates of Obligation 6,515,000 1,000,000 460,000 0 $ 7,975,000 Total Certificates of Obligation $ 6,515,000 $ 1,000,000 $ 460,000 $ 0 $ 7,975,000 Federal/State Grants ISTEA Grant Funds 2,240,040 0 0 0 $ 2,240,040 Other 550,000 0 0 0 $ 550,000 12 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion TEA-21 Grant Funds 9,712,000 0 0 0 $ 9,712,000 TXDOT Funding 180,000 0 0 0 $ 180,000 Federal Grant 5,175,066 853,992 0 0 $ 6,029,058 Tarrant County Grant Funds 600,000 0 0 0 $ 600,000 Total Federal/State Grants $ 18,457,106 $ 853,992 $ 0 $ 0 $ 19,311,098 Reserves 1994 Bond Program Project Savings 440,010 0 0 0 $ 440,010 G.O.Bonds 1994 Program 75,000 0 0 0 $ 75,000 Permanent Sidewalk Maintenance Fund 50,000 102,784 0 0 $ 152,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 2,352,896 0 1,000 0 $ 2,353,896 Bond Program Project Savings 65,000 0 0 0 $ 65,000 Utility Reserve for Future Construction 0 557,000 0 0 $ 557,000 Total Reserves $ 3,557,906 $ 659,784 $ 1,000 $ 0 $ 4,218,690 Other Other 1,730,000 0 0 0 $ 1,730,000 Total Other $ 1,730,000 $ 0 $ 0 $ 0 $ 1,730,000 Total Sources of Funds $ 38,100,012 $ 3,063,776 $ 461,000 $ 0 $ 41,624,788 13 Schedule 2 Drainage Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Proiect Costs Continuing Projects - 1 DR1503 Calloway Branch Channel Repair Project 1,115,314 0 0 0 $ 1,115,314 - 4 DR1004 Meadowview Estates Channel Drainage Improvements 1,629,279 0 0 0 $ 1,629,279 - 5 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 95,000 797,850 0 0 $ 892,850 Total Continuing Projects $ 2,839,593 $ 797,850 $ 0 $ 0 $ 3,637,443 Total Project Costs $ 2,839,593 $ 797,850 $ 0 $ 0 $ 3,637,443 Funding Sources General Obligation Bonds G.O.Bonds 2003 Program 1,629,279 0 0 0 $ 1,629,279 Total General Obligation Bonds $ 1,629,279 $ 0 $ 0 $ 0 $ 1,629,279 Reserves Drainage Utility Fund 695,000 797,850 0 0 $ 1,492,850 Reserves 515,314 0 0 0 $ 515,314 Total Reserves $ 1,210,314 $ 797,850 $ 0 $ 0 $ 2,008,164 Total Sources of Funds $ 2,839,593 $ 797,850 $ 0 $ 0 $ 3,637,443 14 Schedule 3 Utility Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - - UT0201 Big Fossil Creek Wastewater Outfall 1,200,000 0 0 0 $ 1,200,000 - 1 UT1701 College Hill Ground Storage Tank Stand Pipe 85,000 0 0 0 $ 85,000 - 2 UT1601 Franklin Court Sewer Addition and Gifford Connection 150,000 0 0 0 $ 150,000 - 3 CDBG17 Harmonson Road Sanitary Sewer Improvements 771,000 0 0 0 $ 771,000 - 4 UT1402 Johnson Pump Station Component and Infrastructure Replacements 275,000 0 0 0 $ 275,000 - 6 UT1702 Miscellaneous Water/Sewer Main Replacements(2017) 420,000 0 0 0 $ 420,000 - 7 UT1404 Motor Operated Transfer Valves 730,000 0 0 0 $ 730,000 - 8 UT1604 Sanitary Sewer Line Replacements(Crabtree&Onyx N.) 125,000 0 0 0 $ 125,000 - - UT1703 Sanitary Sewer System Rehabilitation(Various Locations) 150,000 0 0 0 $ 150,000 - 9 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 125,000 D 0 0 $ 125,000 - 10 UT1705 Small Water Main Replacements(2017) 420,000 0 0 0 $ 420,000 - 11 UT1607 Walker Branch Interceptor Project 416,525 4,400,000 0 0 $ 4,816,525 - 13 UT0810 Western Center Water Facility Expansion 55,000 0 0 0 $ 55,000 Total Continuing Projects $ 4,922,525 $ 4,400,000 $ 0 $ 0 $ 9,322,525 New Projects - 14 UT1801 Assess and Repair 16-inch Water Transmission Main 0 500,000 0 0 $ 500,000 - - UT1B02 Miscellaneous Water/Sewer Main Replacements(2018) 0 420,000 0 0 $ 420,000 - - UT1803 Small Water Main Replacements(2018) 0 420,000 0 0 $ 420,000 - - UT1804 Telemetric Water Meter Annual Maintenance(2018) 0 400,000 0 0 $ 400,000 Total New Projects $ 0 $ 1,740,000 $ 0 $ 0 $ 1,740,000 Total Project Costs $ 4,922,525 $ 6,140,000 $ 0 $ 0 $ 11,062,525 Funding Sources Certificates of Obligation Certificates of Obligation 1,705,000 3,540,000 0 0 $ 5,245,000 Total Certificates of Obligation $ 1,705,000 $ 3,540,000 $ 0 $ 0 $ 5,245,000 Federal/State Grants CDBG Grant Funds 396,000 0 0 0 $ 396,000 Total Federal/State Grants $ 396,000 $ 0 $ 0 $ 0 $ 396,000 Reserves Reserves 591,525 400,000 0 0 $ 991,525 Unspecified Project Savings 55,000 0 0 0 $ 55,000 Utility Operations for Capital Projects 1,700,000 0 0 0 $ 1,700,000 Utility Reserve for Future Construction 275,000 0 0 0 $ 275,000 Total Reserves $ 2,621,525 $ 400,000 $ 0 $ 0 $ 3,021,525 15 Schedule 3 Utility Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Other Impact Fees 200,000 2,200,000 0 0 $ 2,400,000 Total Other $ 200,000 $ 2,200,000 $ 0 $ 0 $ 2,400,000 Total Sources of Funds $ 4,922,525 $ 6,140,000 $ 0 $ 0 $ 11,062,525 16 Schedule 4 Parks & Recreation Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - 1 PK1701 Barfield Family Foundation Grant Program 50,000 0 0 0 $ 50,000 - 2 PK1401 Barfield/Cotton Belt Trail Connector 65,000 0 0 0 $ 65,000 - 3 PK9601 Calloway Branch Trail Development[CMA4] 1,484,311 0 0 0 $ 1,484,311 - 4 PK1702 Green Valley Playground Replacement and Shade Structure Project 200,000 0 0 0 $ 200,000 - 5 PK9602 Little Bear Creek Trail Development(John Barfield Trail 2,731,342 0 0 0 $ 2,731,342 Development)(ISTEA] - 6 PK1503 Major Trail Neighborhood Connectors 133,000 0 0 0 $ 133,000 - 7 PK1602 Major Trail Rest Stations 55,000 0 0 0 $ 55,000 - 8 PK1603 Northfield Park Renovation 6,083,521 0 0 0 $ 6,083,521 - - PK1506 Park Infrastructure Maintenance 2015 232,597 0 0 0 $ 232,597 - - PK1604 Park Infrastructure Maintenance 2016 175,000 0 0 0 $ 175,000 - - PK1703 Park Infrastructure Maintenance 2017 257,000 0 0 0 $ 257,000 - - PK1605 Park System Playground Replacement 100,000 0 0 0 $ 100,000 - - PK1606 Park System Signage 306,486 173,000 0 0 $ 479,486 - 9 PK1607 Richland Tennis Center Infrastructure Maintenance(2016) 30,000 0 0 0 $ 30,000 - 10 PK1704 Richland Tennis Center Infrastructure Maintenance 2017 18,000 0 0 0 $ 18,000 - 12 PK1608 Trail Head Gateways 2016 122,260 0 0 0 $ 122,260 - - PK1705 Trail Identification and 9-1-1 Emergency Response Signage 1,514 0 0 0 $ 1,514 - - PK1609 Unforeseen Park Damage 66,543 0 0 0 $ 66,543 Total Continuing Projects $ 12,111,574 $ 173,000 $ 0 $ 0 $ 12,284,574 New Projects - 13 PK1801 Green Valley Raceway Historical Area 0 30,000 0 0 $ 30,000 - 14 PK1802 Hometown Lakes Pedestrian Bridge Trail Connections 0 80,000 0 0 $ 80,000 - 15 PK1803 Norich Park Playground Replacement and Shade 0 205,000 0 0 $ 205,000 - - PK1804 Park Infrastructure Maintenance 2018 0 292,400 0 0 $ 292,400 - 16 PK1805 Pump House A 0 100,000 0 0 $ 100,000 - - PK1806 Trail and On-Road Safety Projects 0 771,618 0 0 $ 771,618 Total New Projects $ 0 $ 1,479,018 $ 0 $ 0 $ 1,479,018 Total Project Costs $ 12,111,574 $ 1,652,018 $ 0 $ 0 $ 13,763,592 Funding Sources Certificates of Obligation Certificates of Obligation 3,900,000 0 0 0 $ 3,900,000 Total Certificates of Obligation $ 3,900,000 $ 0 $ 0 $ 0 $ 3,900,000 Federal/State Grants ISTEA Grant Funds 2,882,928 0 0 0 $ 2,882,928 17 Schedule 4 Parks & Recreation Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion TXDOT Funding 0 617,294 0 0 $ 617,294 Federal Grant 500,000 0 0 0 $ 500,000 Total Federal/State Grants $ 3,382,928 $ 617,294 $ 0 $ 0 $ 4,000,222 Reserves Impact Fees 0 205,000 0 0 $ 205,000 Reserves 71,795 0 0 0 $ 71,795 Project Savings 127,485 154,324 0 0 $ 281,809 Sales Tax Reserve for CIP 100,536 0 0 0 $ 100,536 Total Reserves $ 299,816 $ 359,324 $ 0 $ 0 $ 659,140 Sales Tax Sales Tax Reserve for CIP 0 402,400 0 0 $ 402,400 Park Sales Tax 3,076,822 173,000 0 0 $ 3,249,822 Total Sales Tax $ 3,076,822 $ 575,400 $ 0 $ 0 $ 3,652,222 Other Donations Fund 142,000 0 0 0 $ 142,000 Golf Course Reserve 0 100,000 0 0 $ 100,000 Impact Fees 1,155,000 0 0 0 $ 1,155,000 Other 155,008 0 0 0 $ 155,008 Total Other $ 1,452,008 $ 100,000 $ 0 $ 0 $ 1,552,008 Total Sources of Funds $ 12,111,574 $ 1,652,018 $ 0 $ 0 $ 13,763,592 18 Schedule 5 Aquatic Park Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - 1 WP1701 Beachside Bay Cabana Project 304,694 0 0 0 $ 304,694 - 2 WP1702 Endless River Bridge Replacements 126,306 0 0 0 $ 126,306 - - WP1501 General Facility Improvements(2015) 100,000 0 0 0 $ 100,000 - - WP1601 General Facility Improvements(2016) 100,000 0 0 0 $ 100,000 - - WP1703 General Facility Improvements(2017) 100,000 0 0 0 $ 100,000 - - WP1502 NRH2O Facility Enhancements and Improvements 200,000 0 0 0 $ 200,000 - 3 WP1503 NRH2OSlideTowerReplacement 2,980,425 0 0 0 $ 2,980,425 Total Continuing Projects $ 3,911,425 $ 0 $ 0 $ 0 $ 3,911,425 New Projects - - WP1801 General Facility Improvements(2018) 0 100,000 0 0 $ 100,000 - - WP1802 Main Filtration Replacement 0 600,000 0 0 $ 600,000 Total New Projects $ 0 $ 700,000 $ 0 $ 0 $ 700,000 Total Project Costs $ 3,911,425 $ 700,000 $ 0 $ 0 $ 4,611,425 Funding Sources Certificates of Obligation Certificates of Obligation 2,600,000 600,000 0 0 $ 3,200,000 Total Certificates of Obligation $ 2,600,000 $ 600,000 $ 0 $ 0 $ 3,200,000 Reserves Aquatic Park Infrastructure Reserve 1,311,425 100,000 0 0 $ 1,411,425 Total Reserves $ 1,311,425 $ 100,000 $ 0 $ 0 $ 1,411,425 Total Sources of Funds $ 3,911,425 $ 700,000 $ 0 $ 0 $ 4,611,425 19 Schedule 6 Facilities Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - 1 BD0809 820 Widening-City Hall Modifications 1,050,000 0 0 0 $ 1,050,000 - 2 BD0905 820 Widening-Professional Services 300,000 0 0 0 $ 300,000 - 3 FC1205 City Hall(Municipal Government Complex) 69,284,287 0 0 0 $ 69,284,287 - - FC1204 Loop 820 Expansion Preparation 213,031 0 0 0 $ 213,031 - 4 FC1701 Overhead Door Replacement 52,000 0 0 0 $ 52,000 - 5 FC1702 Overhead Door Safety Edges&Remote Control Assemblies 68,800 0 0 0 $ 68,800 Total Continuing Projects $ 70,968,118 $ 0 $ 0 $ 0 $ 70,968,118 New Projects - 8 FC1803 Fire Maintenance Awning 0 60,000 0 0 $ 60,000 Total New Projects $ 0 $ 60,000 $ 0 $ 0 $ 60,000 Total Project Costs $ 70,968,118 $ 60,000 $ 0 $ 0 $ 71,028,118 Funding Sources 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 Total General Obligation Bonds $ 48,250,000 $ 0 $ 0 $ 0 $ 48,250,000 Certificates of Obligation Certificates of Obligation 18,600,000 0 0 0 $ 18,600,000 Total Certificates of Obligation $ 18,600,000 $ 0 $ 0 $ 0 $ 18,600,000 Reserves Future Construction Funds 120,800 0 0 0 $ 120,800 Reserves 0 60,000 0 0 $ 60,000 General Fund Designated Reserves 1,350,000 0 0 0 $ 1,350,000 Total Reserves $ 1,470,800 $ 60,000 $ 0 $ 0 $ 1,530,800 Other Other 2,434,287 0 0 0 $ 2,434,287 North Tarrant Express ROW Proceeds 213,031 0 0 0 $ 213,031 Total Other $ 2,647,318 $ 0 $ 0 $ 0 $ 2,647,318 Total Sources of Funds $ 70,968,118 $ 60,000 $ 0 $ 0 $ 71,028,118 20 Schedule 7 Major Capital Equipment Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - - FS1701 Aerial Fire Apparatus(1) 705,838 0 0 0 $ 705,838 - - FS1702 Aerial Fire Apparatus(2) 705,838 0 0 0 $ 705,838 - - 151401 Cell Phone Signal Boosters in NRH Centre 98,000 0 0 0 $ 98,000 - - IT1701 Enterprise Computer System Replacement 95,000 0 2,905,000 0 $ 3,000,000 - - FS1703 Fire Engine 590,860 0 0 0 $ 590,860 - - 151503 Network Equipment Replacement 1,103,944 0 0 0 $ 1,103,944 - - IT1702 Public Safety Technology 1,306,000 0 0 0 $ 1,306,000 - - 151501 Replace/Enhance Dispatch Center Recording Equipment 196,171 0 0 0 $ 196,171 - - 151502 Replacement of CAD/RMS Public Safety Software Platform 3,020,000 0 0 0 $ 3,020,000 - - IT1703 Replacement of Hand-Held Citation Writers and Citation Portable 130,000 0 0 0 $ 130,000 Printers - - 151402 Replacement of the Fuel Management Software System 90,000 0 0 0 $ 90,000 - - FD1501 SCBA Air Pack Replacement 400,000 0 0 0 $ 400,000 - - 151203 Teleworks Replacement for Online and VOIP Platforms 100,000 0 0 0 $ 100,000 Total Continuing Projects $ 8,541,661 $ 0 $ 2,905,000 $ 0 $ 11,446,651 New Projects - - F51801 Ambulance Replacement Unit 973 0 362,232 0 0 $ 362,232 - - FS1802 Backhoe Replacement Unit 479 0 125,000 0 0 $ 125,000 - - FS1803 Bucket Truck Replacement Unit 602 0 220,000 0 0 $ 220,000 Total New Projects $ 0 $ 707,232 $ 0 $ 0 $ 707,232 Total Project Costs $ 8,541,651 $ 707,232 $ 2,905,000 $ 0 $ 12,153,883 Funding Sources Certificates of Obligation Certificates of Obligation 1,915,000 515,000 0 0 $ 2,430,000 Total Certificates of Obligation $ 1,915,000 $ 515,000 $ 0 $ 0 $ 2,430,000 Federal/State Grants Other 74,000 0 0 0 $ 74,000 Federal Grant 71,171 0 0 0 $ 71,171 Total Federal/State Grants $ 145,171 $ 0 $ 0 $ 0 $ 145,171 Reserves Equipment Services Fund 346,000 0 0 0 $ 346,000 Information Services Reserve 1,666,944 0 0 0 $ 1,666,944 Reserves 1,183,536 192,232 0 0 $ 1,375,768 Unspecified Project Savings 31,000 0 0 0 $ 31,000 Utility Fund 70,000 0 0 0 $ 70,000 21 Schedule 7 Major Capital Equipment Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Total Reserves $ 3,297,480 $ 192,232 $ 0 $ 0 $ 3,489,712 Other Certificates of Obligation 0 0 2,905,000 0 $ 2,905,000 Other 3,054,000 0 0 0 $ 3,054,000 Court Technology Fund 130,000 0 0 0 $ 130,000 Total Other $ 3,184,000 $ 0 $ 2,905,000 $ 0 $ 6,089,000 Total Sources of Funds $ 8,541,651 $ 707,232 $ 2,905,000 $ 0 $ 12,153,883 22 Schedule 8 Economic Development Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - 1 ED0803 Boulevard 26 Intersection Imp.(@ Rodger Line Rd.) 450,000 0 0 0 $ 450,000 - 2 ED0801 Business Improvement and Growth(BIG)Program 250,000 100,000 0 0 $ 350,000 - - ED1601 City Point Infrastructure 2,596,070 0 0 0 $ 2,596,070 - 3 ED1002 Loop 820 Redevelopment 2010 1,595,572 0 0 0 $ 1,595,572 - 4 ED1602 Loop 820 Redevelopment 2016 6,500,000 0 0 0 $ 6,500,000 - 5 ED1501 Neighborhood Revitalization Program(NRP) 306,184 30,000 0 0 $ 336,184 - 6 ED1001 SH 121/183&Bedford-Euless Road Access Plan 100,000 0 0 0 $ 100,000 - - PW0402 Sign Removal Assistance Program 50,000 0 0 0 $ 50,000 - 7 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 $ 16,047,826 $ 130,000 $ 0 $ 0 $ 16,177,826 Total Project Costs $ 16,047,826 $ 130,000 $ 0 $ 0 $ 16,177,826 Funding Sources Certificates of Obligation Certificates of Obligation 3,000,000 0 0 0 $ 3,000,000 Total Certificates of Obligation $ 3,000,000 $ 0 $ 0 $ 0 $ 3,000,000 Reserves General Fund Balance 100,000 30,000 0 0 $ 130,000 General Fund Pay-As-You-Go Reserves 50,000 0 0 0 $ 50,000 Reserves 7,781,070 0 0 0 $ 7,781,070 General Fund Designated Reserves 1,200,000 0 0 0 $ 1,200,000 Sales Tax Reserve for Economic Development 100,000 0 0 0 $ 100,000 Gas Fund Reserves(Designated for ED Activities) 1,369,097 100,000 0 0 $ 1,469,097 Total Reserves $ 10,600,167 $ 130,000 $ 0 $ 0 $ 10,730,167 Sales Tax Sales Tax Reserve for Economic Development 450,000 0 0 0 $ 450,000 Total Sales Tax $ 450,000 $ 0 $ 0 $ 0 $ 450,000 Other Other 1,571,184 0 0 0 $ 1,571,184 Commercial Loan 426,475 0 0 0 $ 426,475 Total Other $ 1,997,659 $ 0 $ 0 $ 0 $ 1,997,659 Total Sources of Funds $ 16,047,826 $ 130,000 $ 0 $ 0 $ 16,177,826 23 Schedule 9 CIP Personnel Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects GCIP12 General CIP Personnel Costs 995,183 0 0 0 $ 995,183 MFPF12 Municipal Facilities Project Funding 0 0 0 0 $ 0 UCIP12 Utility CIP Personnel 2,035,849 330,810 0 0 $ 2,366,659 UCNP12 Utility Construction Personnel 4,950,568 866,713 0 0 $ 5,817,281 UCPF12 Utility Construction Project Funding -4,934,769 -840,000 0 0 $ -5,774,769 Total Continuing Projects $ 3,046,831 $ 357,523 $ 0 $ 0 $ 3,404,354 Total Project Costs $ 3,046,831 $ 357,523 $ 0 $ 0 $ 3,404,354 Funding Sources Certificates of Obligation Certificates of Obligation -4,934,769 0 0 0 $ -4,934,769 Total Certificates of Obligation $ -4,934,769 $ 0 $ 0 $ 0 $ 4,934,769 Reserves General CIP Reserves and Interest Income 995,183 0 0 0 $ 995,183 Utility Reserves and Interest Income 6,986,417 357,523 0 0 $ 7,343,940 Municipal Facilities Project Funding 0 0 0 0 $ 0 Total Reserves $ 7,981,600 $ 357,523 $ 0 $ 0 $ 8,339,123 Total Sources of Funds $ 3,046,831 $ 357,523 $ 0 $ 0 $ 3,404,354 24 Schedule 10 Other Capital Projects Budget Summary Pg. Map Project To 2017/18 2018/19 2019 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - - ES1201 Atmos Residential Energy Efficiency Program 401,859 23,750 0 0 $ 425,609 - - ES0902 Litter Not Program 25,000 0 0 0 $ 25,000 - - ES0901 Neighborhood Initiative Program 209,602 0 0 0 $ 209,602 - - FC1603 North Texas Anti-Gang Center 2016 900,000 0 0 0 $ 900,000 - - PL1501 Strategic Plan 125,000 25,000 0 0 $ 150,000 - - PW1601 TEX Rail 40,200 0 0 0 $ 40,200 Total Continuing Projects $ 1,701,661 $ 48,750 $ 0 $ 0 $ 1,750,411 Total Project Costs $ 1,701,661 $ 48,750 $ 0 $ 0 $ 1,750,411 Funding Sources Federal/State Grants Other 900,000 0 0 0 $ 900,000 Total Federal/State Grants $ 900,000 $ 0 $ 0 $ 0 $ 900,000 Reserves Other 187,158 0 0 0 $ 187,158 Total Reserves $ 187,158 $ 0 $ 0 $ 0 $ 187,158 Sales Tax Economic Development Sales Tax 75,000 0 0 0 $ 75,000 Total Sales Tax $ 75,000 $ 0 $ 0 $ 0 $ 75,000 Other Donations Fund 22,444 0 0 0 $ 22,444 General Fund Balance 50,000 25,000 0 0 $ 75,000 Other 467,059 23,750 0 0 $ 490,809 Reserves 0 0 0 0 $ 0 Total Other $ 539,503 $ 48,750 $ 0 $ 0 $ 588,253 Total Sources of Funds $ 1,701,661 $ 48,750 $ 0 $ 0 $ 1,750,411 25 Schedule 11 2016/2017 Budget Revisions Budget Summary Adopted Budget 2016/2017 Page Project Project Through Revision Revised Remaining No Number Name 2016/2017 2016/2017 Budget Amount Total STREET&SIDEWALK CAPITAL PROJECTS 121 SM 1501 Preventive Street Maintenance 2015 $ 700,000 $ (45,100) $ 654,900 $ - $ 654,900 Sub-Total $ 700,000 $ (45,100) $ 654,900 $ - $ 654,900 DRAINAGE CAPITAL PROJECTS 122 DR1503 Calloway Branch Channel Repair Projects $ 698,500 $ 281,814 $ 980,314 $ - $ 980,314 123 DR 1401 Concrete Lined Channel Rehabilitation Project 131,500 (83,815) 47,685 - 47,685 124 DR 1601 Drainage Improvements 95,000 (84,056) 10,944 - 10,944 125 DR 1501 Main Street Drainage Improvements 1,020,000 45,100 1,065,100 - 1,065,100 126 DR 1004 Meadowview Estates Channel Drainage 1,743,222 (113,943) 1,629,279 - 1,629,279 Improvements Sub-Total $ 3,688,222 $ 45,100 $ 3,733,322 $ - $ 3,733,322 UTILITY CAPITAL PROJECTS 127 CDBG17 Harmonson Road Sanitary Sewer Improvements $ 396,000 $ 375,000 $ 771,000 $ - $ 771,000 128 UT 1307 Sanitary Sewer Systems Rehabilition of Main 1,500,000 (375,000) 1,125,000 - 1,125,000 Lines Phase II Sub-Total $ 1,896,000 $ - $ 1,896,000 $ - $ 1,896,000 PARKS&RECREATION CAPITAL PROJECTS 129 PK9602 Little Bear Creek Trail Development $ 2,830,420 $ (99,078) $ 2,731,342 $ - $ 2,731,342 130 PK 1603 Northfield Park Renovation 4,305,500 1,778,021 6,083,521 - 6,083,521 131 PK 1402 Park Pond and Drainage 255,000 - 255,000 - 255,000 132 PK1606 Park System Signage 273,000 33,486 306,486 - 306,486 133 PK1705 Trail Identification and 9-1-1 Emergency 35,000 (33,486) 1,514 - 1,514 Response Signage 134 PK 1609 Unforeseen Park Damage 61,535 5,008 66,543 66,543 Sub-Total $ 7,760,455 $ 1,683,951 $ 9,444,406 $ - $ 9,444,406 AQUATIC PARK CAPITAL PROJECTS 135 WP1701 Beachside Bay Cabana Project $ 196,000 $ 108,694 $ 304,694 $ - $ 304,694 136 WP1702 Endless River Bridge Replacement 235,000 (108,694) 126,306 - 126,306 Sub-Total $ 431,000 $ - $ 431,000 $ - $ 431,000 FACILITIES CAPITAL PROJECTS 137 FC1602 Building ACM Abatement and Site Demolition $ 630,000 $ (20,000) $ 610,000 $ - $ 610000 Sub-Total $ 630,000 $ (20,000) $ 610,000 $ - $ 610,000 MAJOR CAPITAL EQUIPMENT CAPITAL PROJECTS 138 FS1701 Aerial Fire Apparatus 1 $ 931,000 $ (225,162) $ 705,838 $ - $ 705,838 139 FS1702 Aerial Fire Apparatus 2 931,000 (225,162) 705,838 - 705,838 140 FS1703 Fire Engine 556,000 34,860 590,860 - 590,860 141 IS1502 Replacement of CAD/RMS 3,000,000 20,000 3,020,000 - 3,020,000 Sub-Total $ 5,418,000 $ (395,464) $ 5,022,536 $ - $ 5,022,536 ECONOMIC DEVELOPMENT CAPITAL PROJECTS $ - $ - $ - $ - $ - Sub-Total $ - $ - $ - $ - $ - OTHER CAPITAL PROJECTS 142 ES 0901 Neighborhood Initiative Program $ 247,158 $ 5,000 $ 252,158 $ - $ 252,158 Sub-Total $ 247,158 $ 5,000 $ 252,158 $ - $ 252,158 Total All Projects $ 20,770,835 $ 1,273,487 $ 22,044,322 $ - $ 22,044,322 SOURCES OF FUNDS General Obligation Bonds $ 1,863,222 $ (113,943) $ 1,749,279 $ - $ 1,749,279 Certificates of Obligations 8,815,000 - 8,815,000 - 8,815,000 Federal/State Grants 2,545,808 500,000 3,045,808 - 3,045,808 Reserves 5,263,285 325,380 5,588,665 - 5,588,665 Sales Tax 1,649,112 922 1,550,034 - 1,550,034 Other 634,408 561,128 1,195,536 - 1,195,536 Total Sources of Funds $ 20,770,835 $ 1,273,487 $ 22,044,322 $ - $ 22,044,322 26 NCH Street & Sidewalk Capital Projects Preventive Street Maintenance (2015) SM1501 PROJECT DESCRIPTION&JUSTIFICATION This is an annual program where funds are dedicated to enhance the city's efforts for preventive maintenance of city streets. The scope of this project provides crack sealing for approximately 15-25 streets, slurry seals for 15-25 streets and a 2"asphalt overlay or 12-15 streets. In addition to these three maintenance methods, staff will be searching for new preventive procedures to consider in the future. Preventive maintenance activities delay more costly street reconstruction and extends the life of the current street system. This project provides staff with funding to apply the appropriate maintenance activities to the streets selected for the program. Depending on the current condition of the street and the type of preventive measures taken,the street life can be extended for a minimum cost in comparison to a total reconstruction. Funding sources are Permanent Street Maintenance Fund Reserves at$700,000. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2014 09/2015 Other REVISION EXPLANATION Funds will be transfered from this project into DR1501 to help complete the final 305 feet of street repair on Main Street. FINANCIAL DATA ADOPTED F REVISED TOTAL BUDGET THRU '~" BUDGET THRU REMAINING PROJECT 2016/17 • 2016/17 BALANCE COST Reserves $700,000 TM a $654,900 $654,900 0 $0 0 $0 '" 0 $0 0 $0 Total $700 000 QQ $654 900 $0 $654 900 $0 $0 Professional Services ' 0 $0 Engineering/Design ` lk 3 k "x6 mss= Land/ROW Acquistion 0 $0 Construction 700,000 ., ®0); 654,900 $654,900 Other 0 $0 Total $700,000 , (.$45,100), $654,900 $0 $654,900 IMPACT ON OPERATING BUDGET Minimal operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 28 Drainage Capital Projects Calloway Branch Channel Repair Project DR 1503 PROJECT DESCRIPTION&JUSTIFICATION This is for the repair of failing channel along the Calloway Branch Channel that has resulted in the loss of material in several backyards along Waggoner Ranch Road. With the extraordinary rainfall this spring the side slopes of a portion of this channel failed, sliding into Staff hired a Geotechnical firm to learn exactly what caused the channel bottom and causing a loss of material inf several of the backyards talong co Waggoner Ranch Road. the failure and what could be done o correct the problem. Unfortunately it is not as simple as replacing the dislodged material back onto the channel bank. The clay material is not suited to exist at the required slope with elevated moisture content.While the rains this year were unusually high, it is a high probability that we will experience the level of rainfall again at some point. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016117 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2015 02/2016 Land/ROW Acquisition Construction Other REVISION EXPLANATION nd DR14 Available project savings in projects DR1004, DR1601, and are being requested to be transfer into project DR1503- Calloway Branch Channel Repair project. The construction bid received is$376,840.00 over the estimated budget. FINANCIAL DATA . ADOPTED REVISED TOTAL BUDGET THRU + BUDGET THRU REMAINING PROJECT 2016/17 + k 2016117 BALANCE COST FUNDI; c,0 :R . r v ,?.. .:. v° Reserves $698,500 s $980,314 $980,314 4 0 $0 0 $0 1 w $0, 0 0 $0 Total $698 500 $980,314 $0 $980,314 Total C EXPENDITURES r , , . .. .<". ' °"�, s . ., . .. ,. .A,;+,.� xv v^.* k$..a�V'w^;':r.-'3+d �,.7:4.1 �. ..ak...v .,°':' ro`-a<r .# .x. =W+a,.::',�,n e'n v.Mn x w $0 $0 Professional Services Engineering/Design 98,500 .� 98,500 $98,500 Land/ROW Acquistion 0 $0 Construction 600 000 881,814 $881,814 Other .r 0 $0 Total $698,500x. a " $980,314 $0 $980,314 IMPACT ON OPERATING BUDGET No operating impact is anticipated. 2018/19 2019/20 2020/21 TOTAL ANNUAL OPERATING IMPACT 2016/17 2017/18 Projected $0 29 Drainage Capital Projects Concrete Lined Channel Rehabilitation Project DR1401 PROJECT DESCRIPTION&JUSTIFICATION This project involves beginning a rehabilitation process of the City's seven(7)miles of concreted lined channels.The scope of the project will include repairing areas of concrete lined channels that have deteriorated, cracked, dropped, collapsed, heaved or hold water due to heavy ground movement and/or age. The list of needed repairs will include patching sections of channel walls and bottoms and replacement of sections of channel walls and bottoms. Staff has inventoried all concrete lined channels and estimates that 50,000 square feet of repairs are initially needed to begin the repair process. Concrete channels transport storm water run-off during rain events. When those channels have areas of deteriorated walls or bottoms,flowing water has the ability to penetrate the sub-grade,which undermines the integrity of the channel and poses a threat to public and private property. Some areas in the concrete channels hold extensive amounts of water because of deterioration that has occurred,which becomes a breeding ground for mosquito larvae and raises citizen concern. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2013 01/2016 Other REVISION EXPLANATION Available project savings in project DR1401 is being requested to be transfered into project DR1503-Calloway Branch Channel Repair project. The construction bid received on DR1503 came in$376,840.00 over the estimated budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU *, : BUDGET THRU REMAINING PROJECT 2016117 •+ 2016/17 BALANCE COST $R rGS r 131 500 x?ftVlitWiStriti y�,`{3-s°-=i'^';N*✓"t}.UU,.^.a $47,685 $47,685 0 $0 0 $0 "414 + 0 $0 0 $0 Total $131500 2 $47 685 $0 $47,685 Professional Services $0 $0 Engineering/Design * - 0 $0 Land/ROW Acquistion 0 $0, Construction 131,500 :` ,115) 47,685 $47,685 Other r 0 $0 Total $131,500 . m($8.., 71 0 $47,685 $0 $47,685 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018119 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 30 Drainage Capital Projects Drainage Improvements DR1601 PROJECT DESCRIPTION&JUSTIFICATION There are two sections to the drainage improvement project. The first section consists of construction of a concrete drainage flume in the Holiday West Addition, between Meadow Park Drive North and the Holiday West Channel.The second section consists of reconstructing a concrete flume in the Steeple Ridge subdivision. In the Meadow Park Drive section of this project,the in ground drainage system in the Holiday West Addition outfalls into the Holiday West Channel by way of several curb inlets and three storm drain pipes.A concrete flume can be constructed within an existing drainage easement between two homes, providing an additional path for the runoff and eliminating this problem. In the Steeple Ridge section of the project,the existing concrete flume between Steeple Ridge and High Point Estates is experiencing structural problems, highlighted by the extreme weather conditions this spring.The flume is being undermined by upstream flow, causing loss of sub-grade and erosion problems on adjacent properties. This project will remove and reconstruct the flume, address any subsurface stability issues, and improve the capacity of this drainage connection. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2015 09/2016 Land/ROW Acquisition Construction 10/2015 09/2016 Other REVISION EXPLANATION Available project savings in project DR1601 is being requested to be transfered into project DR1503-Calloway Branch Channel Repair project. The construction bid received on DR1503 came in$376,840.00 over the estimated budget. FINANCIAL DATA ADOPTED analitg.140 REVISED TOTAL BUDGET THRU • BUDGET THRU REMAINING PROJECT 2016/17 •N*° 2016/17 BALANCE COST wit; *MO 71,411046Afiri*AwigMMOVAMIg.;:„: Reserves $05,000 ` 41)', $10,944 $10,944 0 $0 0 $0 0 $0 0 $0 Total $95 000 $10f,944 $0 $101944 mtpoRgrm�..r. r r+ '°T.d' �+t 3'e °'^ ;. '"'' ' '' +. r ;..s ,:? sr :. r. . r=a$O $0 Professional Services Engineering/Design 20,000 lC ._° w 10,944 $10,944 Land/ROW Acquistion 0 $0 Construction 75,000 urtooiArtIaii,a oCo 0 $0 Others 0 $0 Total I $95,000 . � ��1 $10,944 $0 $10,944 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 31 Drainage Capital Projects Main Street Drainage Improvements DR 1501 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of replacing approximately 1000 linear feet of 18"and 21" Reinforced Concrete Pipe(RCP)with 30" and 36" RCP beginning at Chilton Drive and ending at Crane Road.A branch of the new system will be extended up Jerry Court and will connect to an existing system. Because much of the storm drainage system will be underneath the existing street pavement the street cuts will be patched and the entire street will be overlaid to provide a uniform pavement finish and look. Some driveways and curb and gutter will be reconstructed. There will also be the relocation of approximately 400 feet of an existing 6"water and 6"sanitary sewer line. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 05/2015 10/2015 Land/ROW Acquisition Construction 12/2015 11/2016 Other REVISION EXPLANATION Funds are required to complete the final 305 feet of street repair on Main Street. In order to pay for construction, funds will need to be transfered into this project. FINANCIAL DATA ew REVISED e p 'r TOTAL BUDGET THRU 1 • BUDGET THRU REMAINING PROJECT 2016/17 ` • 2016/17 BALANCE COST Reserves $900,000 +a $945,100 $945,100 General Obligation Bonds 120 000 .< 120,000 $120,000 0 $0 f 0 $0 0 $0 Total $1 020 000 $1 065 100 0 $1 065 100 PROJECT EXPENDITURES �;Pc m. L .,,x ;,,r;€ ..,,. .'"..,'... i'^'.' yr ,n.t.far,. :r M t :F s,*, �..n,a csd?`a? �-0'*x"�` y+-. `',s- '� Professional Services Engineering/Design 89,500 89,500 $89,500 Land/ROW Acquistion y 0 $0 Construction 930,500 w® 97859,,65$0 75,600 $975,600 5.14 0 $0 Other �� ,� Total $1,020,000 (` ` °$4:5,100 $1,065,100 $0 $1,065,100 IMPACT ON OPERATING BUDGET Minimal operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019120 2020/21 TOTAL Projected so 32 Drainage Capital Projects Meadowview Estates Channel Drainage Improvements DR 1004 PROJECT DESCRIPTION&JUSTIFICATION This project consists of reconstructing the existing concrete channel from Northfield Park to Jill Court and reconstructing a larger bridge(box culverts)at Northfield Drive. The length of the channel is approximately 1,800 linear feet.The new box culverts will be designed for the 100 year rain event. This channel was constructed in the early 1980's. Sections of this channel are failing and are a continuous maintenance problem.The failed sections are also causing erosion problems to adjacent property owners. A section of the channel failed a few years ago and cost approximately$70,000 for this one repair. In addition to the channel failing, the concrete portion of the channel was only designed for the 25 year rain event. This project will extend the concrete lining to the top of the bank and consequently,will provide for more channel capacity.This will eliminate the need to mow or apply herbicide to the section of side slop that is currently earthen bank and as such will reduce future maintenance cost. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2010 04/2013 Land/ROW Acquisition Construction 04/2014 10/2015 Other REVISION EXPLANATION Available project savings in project DR1004 is being requested to be transfered into project DR1503-Calloway Branch Channel Repair project. The construction bid received on DR1503 came in$376,840.00 over the estimated budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ° °• BUDGET THRU REMAINING PROJECT 2016117 + 2016/17 BALANCE COST at 0 , `.SOU "kyrva:''4.. 1,n.' x�. .. "aa':'''',74'1";. :.:—'4,,'4":..r. :. ?i, ,---;., .;a. l aa,'` ,..,,aa,xa.'a• "`�x.` General Obligation Bonds $1,743,222 c $1,629,279 $1,629,279 0 $0 0 $0 0 $0 0 $0 Total 1 743 222 11 629 279 $0 1 629 279 Professional Services $0 $0 Engineering/Design 415 000 i, ,',2 •..: 393,057 $393,057 Land/ROW Acquistion 0 $0 Construction 1,328,222 t® ,$ $1,236,222 Other �a 7 A ,k 0 $0 am $1,629,279$1,743,222 ,h ( _ yLL.Total $0 $1,629,279 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 33 Utility Capital Projects Harmonson Road Sanitary Sewer Improvements CDBG17 PROJECT DESCRIPTION&JUSTIFICATION This is the 42nd year Community Development Block Grant(CDBG) Project. The project will consist of replacing approximately 1,850 linear feet of 18"sanitary sewer pipe within Harmonson Road right-of-way between Dawn Drive and Lochridge Court. The existing clay pipe has become problematic requiring regular maintenance.The pipe has partially collapsed in areas and roots have intruded within the pipe through sections. Note: The Federal/State funds shown in the"Sources of Funds"are CDBG entitlement funds,which are administered entirely by Tarrant County. This includes design, ultimate contractor selection, construction management and contract close-out activities. As with all previous CDBG projects,the City will have to provide construction inspection services. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 09/2017 Land/ROW Acquisition Construction 10/2016 09/2017 Other REVISION EXPLANATION We need to transfer the funds to cover construction expenses for the city's portion of the project. Currently, CDBG17 contains only grant funds in the amount of$396,000. The additional funding is coming from UT1307 Sanitary Sewer Rehab project savings. FINANCIAL DATA ADOPTED t. ° REVISED TOTAL BUDGET THRU , `• BUDGET THRU REMAINING PROJECT / y.� 2016/17 ` o 2016/17 BALANCE COST MSD. _ ��:a,.,ts,.. ,..,. .' :...,.'. ^.,,.. �w r .^+ ,F�#it#a.,�,�,y„ e,#ao.�sv,,, _ .....<<,. ,.�. a,.w., 4. t Federal/State Grants $396 000 $396,000 $396,000 Reserves 0 x. i Y: 375,000 $375,000 0 $0 ,r.. 0 $0 . » 0 $0 yT+gfotal iy.�„ �j jW;3,.. $396 000 ..,. ' ++ $771 000 ,,. „„� $0,,�y 7571 000 A . ..,.c.. DITU reb`a. f ,. ' §(#M ^. ": #`+*:w't U *A,4..5 1 '+',s^at9�',;53#. R..$0 Professional Services so Engineering/Design 79,200 ,7 .. 79,200 $79,200 Land/ROW Acquistion 0 $0 Construction 316 800 : ,. , 000 691,800 $691,800 Other 0 $0 Total $396,000 „ „ , ,,,0,0` $771,000 $0 $771,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019120 2020/21 TOTAL Projected $0 34 Utility Capital Projects Sanitary Sewer Systems Rehabilitation of Main Lines (Phase II) UT1307 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of replacing approximately 11,000 linear feet of sanitary sewer main lines in the southern portion of the City(south of Northeast Loop 820). In 2010,the City conducted a sanitary sewer assessment for the southern portion of the City(project UT0902). The study found that approximately 11,000 linear feet of sanitary main lines are in need of replacement. The main lines are made of vitrified clay tile and have deteriorated to a point where pipe failures have occurred causing blockage and overflows. Many of the joint pipe sections are separated, allowing ground water and surface water intrusion resulting in capacity issues and added cost for the treatment of wastewater. PROJECT STATUS ORIGINAL 2016117 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2011 10/2013 Land/ROW Acquisition Construction 11/2012 10/2013 Other REVISION EXPLANATION We need to transfer project savings into CDBG17 Harmonson Sanitary Sewer to cover construction expenses for the city's portion of the CDBG project. FINANCIAL DATA ADOPTED 4,:49;i:c REVISED TOTAL BUDGET THRU ''* BUDGET THRU REMAINING PROJECT �+y / 2016/17 ® 2016/17 BALANCE COST Reserves $1,420,000 $1,045,000 $1,045,000 Other 80,000 80,000 $80,000 1:- 0 $0 '° 0 $0 0 $0 Total 1 500 000 @ e : $1 125 000 $0 1 125 000 P.°• `.'EN.r RCt ` : "' Professional Services $0 Engineering/Design 300,000 7" a, 300,000 $300,000 Land/ROW Acquistion .. . . °; 0 $0 Construction 1,200,000 825,000 $825,000 Other Total $1,500,000 44 ( 3: 0,4 $1,125,000 $0 $1,125,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 35 Parks & Recreation Capital Projects Little Bear Creek Trail Development(John Barfield Trail Development) ISTEA PK9602 PROJECT DESCRIPTION&JUSTIFICATION Project previously named as Little Bear Creek Trail(ISTEA). This project provides for land acquisition, design, and construction of 3.5 miles of multi-use trail along Little Bear Creek. The project has terminus points at Precinct Line and the Cotton Belt Trail intersection and at the northern end of Calloway Branch Trail. The project will provide trail access to Northfield Park,J.B. Sandlin Park, Tommy&Sue Brown Park and Dr. Pillow Park. All of the individual easements and right-of-way parcels for the trail have been assembled as subdivision development along the corridor has occurred since the project was originally initiated. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 04/1996 04/1996 09/2012 09/2012 Land/ROW Acquisition Construction 04/2013 04/2013 12/2016 12/2017 Other REVISION EXPLANATION To release a portion of funds back to reserves to be reallocated to other projects. FINANCIAL DATA ADOPTED ':,. ', REVISED TOTAL BUDGET THRU `. :' . .• BUDGET THRU REMAINING PROJECT 2016/17 gi 2016/17 BALANCE COST Ft!FU »...,, re , .0 ,'<'tt n v, ,.,. `./ w ." y ads' �t 'a' ^,:; ea'!�fi`+�' ,. ':,, .e k 4 .%„: .ti �*2,� x . nY f.3A. P'&+ !*.. Federal/State Grants $2,149 808 $2,149,808 $2,149,808 Sales Tax 680,612 r ) 581,534 $581,534 0 $0 0 $0 0 $0 Total $2830420 ' 2 731 342 $0 $2 731 342 + ® ,4 .+! ►®,tie" .,�.uffi,^ ww +*.rv± wa, a., . ;",. Professional Services $0 $0 Engineering/Design 495,130 ; 489,739 $489,739 Land/ROW Acquistion 22,000 ::4:47:47-u-(0.7.1-T-',..'.. 19,179 $19,179 Construction 2313290 ., 2,222,424 $2,222,424 Other 0 $Q Total $2,830,420 ti ° '' *(a ' , .,. , �.' $2,731,342 $0 $2,731,342 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 36 Parks & Recreation Capital Projects Northfield Park Redevelopment PK1603 PROJECT DESCRIPTION&JUSTIFICATION This project involves the redevelopment of the existing community park through the design and construction of new amenities based on meetings to gather stakeholder input. Recommended elements for the redevelopment of the park include a new park entry, a more efficient park layout, upgrade of all equipment and support facilities and introduction of loop trails. The project will also ensure the protection of the natural creek corridor and provide engaging views to natural areas. PROJECT STATUS ORIGINAL 2016117 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services 03/2017 03/2017 Engineering 03/2016 03/2016 Land/ROW Acquisition Construction 05/2017 05/2017 05/2018 05/2018 Other REVISION EXPLANATION The revision to the project is to account for a grant awarded by the TPWD in the amount of$500,000. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ® BUDGET THRU REMAINING PROJECT 2016/17 • 2016/17 BALANCE COST Certificates of Obligation $3,900,000 t $3,900,000 $3,900,000 Sales Tax 405,500a +�® 506,036 $506,036 Federal/State Grants 0 t M a e 500,000 $500,000 Project Savings/Other 0 277,485 $277,485 Impact Fees 0 Ora 900,000 $900,000 TotalTotal $4 305 500 ® $6 083 521 $0 $6 083 521 PRt ,T EXP9 DITU s .M, Professional Services L Engineering/Design 402,500 t . 402,500 $402,500 Land/ROW Acquistion 0 $0 Construction 3,903,000 ; 1,7 ®® „ 5,681,021 $5,681,021 Other 0 $0 Total $4,305,500 ;'�.; N ,0 1' $6,083,521 $0 $6,083,521 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 37 Parks & Recreation Capital Projects Park Pond and Drainage PK14O2 PROJECT DESCRIPTION&JUSTIFICATION This project consists of correcting and preventing erosion along the pond edge at Linda Spurlock Park and the front pond edge at Green Valley Park. Repairs and renovation to the banks of both ponds will consist of hardscape elements such as modular block or natural stone. Based on priorities listed in the Asset Management Plan, the erosion control protection to the front pond at Green Valley Park and Linda Spurlock pond is critical to ensure surrounding infrastructure is not compromised by the eroding banks.As ground water flows over the edge of bank,the edges continue to erode toward the street and sidewalk areas. The safety of park users may also be impacted if the pond edging is not restored, as the retreating edge will likely compromise the integrity of areas where people stand or sit to fish. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services 10/2013 02/2014 Engineering Land/ROW Acquisition Construction 09/2014 09/2015 08/2017 Other REVISION EXPLANATION In project transfer to cover added construction expenses for erosion control. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU % `' BUDGET THRU REMAINING PROJECT 2016/17 * =o. 2016/17 BALANCE COST ® a ?" . I .= � .r ,. , ` � �,,, 7 x Sales Tax $255 000 n a $255,000 $0 $255,0.00 . e 0 $0 0 $0 ' 0 $0 Total $255 000 $255000 $0 $255,000, Professional Services $30 000 ,00 $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion = 7 0 $0 Construction 225,000 00 :00'0,0„00,0 255,000 $255,000 Other °j 'N 0 $0 Total $255,000 .. $255,000 $0 $255,000 IMPACT ON OPERATING BUDGET No operating impact is expected. ANNUAL OPERATING IMPACT 2016/17 2017118 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 38 Parks & Recreation Capital Projects Park System Signage PK1606 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the design and construction of new, updated park signage that will provide a gateway to each park, consistent with the vision of"City as Park"as supported by the Parks, Recreation and Open Space Master Plan.All park entry signs are scheduled to be replaced over a three year period. Each year, as funding becomes available, Parks and Recreation staff will inspect and evaluate all signs, and respond with sign replacement projects in order of greatest priority. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2015 10/2015 09/2018 09/2018 Other REVISION EXPLANATION To reallocate savings from PK1705 Trail ID and 9-1-1 Signage to PK1606 to help cover the cost of park sign replacement. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU • BUDGET THRU REMAINING PROJECT 2016/17 0,P1. .$ 2016/17 BALANCE COST Sales Tax $273,000 =« $306,486 $306,486 0 $0 0 $0 0 $0 III 0 $0 Total $273 000 $306 486 $0 $306 486 1-• = '-, DIT Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 273,000 4 3 306,486 $306,486 Other 0 $0 Total $273,000 ••' $306,486 $0 $306,486 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 39 Parks & Recreation Capital Projects Trail Identification and 9-1-1 Emergency Response Signage PK 1705 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the design and installation of updated trail identification and 9-1-1 emergency response signage to be introduced along the major trails within the city.The trail identification signs will be placed at selected trail and street intersections throughout the city as a means to identify which trail crosses a particular roadway. The 9-1-1 emergency response signage will be introduced at regular designated intervals along trails, and tied to a local GPS coordinate system to pinpoint the location of citizens in need of assistance. PROJECT STATUS ORIGINAL 2016117 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 10/2016 10/2017 07/2017 Other REVISION EXPLANATION To reallocate savings from PK1705 Trail ID and 9-1-1 Signage to PK1606 to help cover the cost of park sign replacement. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU BUDGET THRU REMAINING PROJECT 2016/17 2016/17 BALANCE COST Sales Tax $35,000 , $1,514 $1,514 0 $0`' 0 $0 0 $0 0 $0 Total 35,000 $1 514 $0 $1 514 Professional Services $0 $0 Engineering/Design °' 0 $0 Land/ROW Acquistion _> 0 $0 Construction 35,000 `.r 1,514 $1,514 Other 0 $0 Total $35,000 .,51q;:,* $1,514 $0 $1,514 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2016117 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 40 Parks & Recreation Capital Projects PK 1609 Unforeseen Park Damage PROJECT DESCRIPTION&JUSTIFICATION This project provides for the repair and replacement of park amenities and structures, as well as street and right-of-way landscape, hardscape, furniture and other enhancements in response to unanticipated or foreseen damage resulting from vandalism or accidents. This project allows for quickly responding to damage or vandalism of landscape features, amenities and structures in our parks and within our rights-of-way arising from accidents or vandalism. Often, public safety is paramount to taking quick action to repair such damage. Because processing insurance claims is a time consuming course of action, allocated funds to repair this damage allows staff to respond to the accident or vandalism event quickly, preserving public safety and maintaining a positive City image, especially when located in areas of high visibility. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 09/2017 Other REVISION EXPLANATION This project is a result of damage that occurred at various places around the city parks. More damage has occurred during this fiscal year. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU BUDGET THRU REMAINING PROJECT 2016/17 + 2016117 BALANCE COST 4 ; " Reserves $61,535 r $66,543 $0 $66,543 0 $0 $0 _ 0 $0 0 $0 Total '? ` ®s 5� $0 $66 543 °�,="" BEN! " E3E� � .u.,�. .., � ,..�. . y � �,�,� �a��.�;�x,.;��.._� . Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 61 535 '_" +® s, 66,543 $66,543 Other _ 0 $ 0 Total $61,535 '• ' $66,543 $0 $66,543 IMPACT ON OPERATING BUDGET Minimal impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 41 Aquatic Park Capital Projects Beachside Bay Cabana Project WP1701 PROJECT DESCRIPTION&JUSTIFICATION This project consists of the renovation of the existing Beachside Bay volleyball court area and the construction of a cabana village.The water park is currently undergoing a rebranding process directed by our contracted branding agency Forrec, and this is one of their recommendations. The cabana village will increase the private seating options available to water park guests from the current 4 to a total of 12.The new cabana village will also provide an additional revenue generating area for the water park. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services 10/2016 05/2017 11/2016 08/2017 Engineering Land/ROW Acquisition Construction 11/2016 10/2017 09/2017 06/2018 Other REVISION EXPLANATION A budget transfer is being processed to reallocate savings from WP1702 to WP1701 to help cover the cost of the Beachside Bay Cabana project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU +' BUDGET THRU REMAINING PROJECT 2016/17 t.:L 2016/17 BALANCE COST L RCEs a ,ARS.e sDeINry es '5.,.. s .ss v z,'.',x`` '? .;.<,,_ * "t ✓ :,` .ziS''., �'`''" .. ,.> .?Y;,i'.'3'� k ,�..-:„' $196,000 +e «•. $304,694 $304,694 0 $0 .rM= 0 $0 0 $0 0 $0 Total $196 000 ® i $304 694 0 $304 694 - : .. *,. Professional Services $5 000 ;. $5,000 $5,000 Engineering/Design 5 0 $0 Land/ROW Acquistion 0 $0 Construction 191,000 µ , r + 299,694 $299,694 Other 0 $0 Total $196,000 1 l ,694 $304,694 $0 $304,694 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 42 Aquatic Park Capital Projects Endless River Bridge Replacement WP 1702 PROJECT DESCRIPTION&JUSTIFICATION This project is for the replacement of 3 bridges over the Endless River in response to use and age.The current bridges were installed when the park opened in 1995. Each bridge is a Continental truss style pedestrian bridge with a 5 ton weight limit measuring approximately 25 long by 7'wide.The bridges are primarily used for moving pedestrian traffic over the Endless River as well as smaller vehicles used to aide in facility repairs. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016117 START DATE REVISION END DATE REVISION Professional Services 10/2016 11/2016 11/2016 11/2016 Engineering Land/ROW Acquisition Construction 10/2016 12/2016 09/2017 05/2017 Other REVISION EXPLANATION A budget transfer is being processed to reallocate savings from WP1702 to WP1701 to help cover the cost of the Beachside Bay Cabana project. FINANCIAL DATA ADOPTED ' A REVISED TOTAL BUDGET THRU 'F"'°. BUDGET THRU REMAINING PROJECT 2016117 2016/17 BALANCE COST Reserves $235,000 . 5.0 $126,306 $126,306 0 $0 0 $0 Total $235 000 '< •°'' $126 306 $0 $126 306 „ .. .^ .` ® �,�Ri .: +4w+,i "§.".,u " "" �1"'�.,'� Professional Services $15,000 . [ $9 358 $9,358 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 220000 .n:,41:104714, 116,948 $116,948 Other 0 $0 Total $235,000 'f, k,4.( :,!, , °& $126,306 $0 $126,306 IMPACT ON OPERATING BUDGET ILI ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected $0 43 Municipal Facility Capital Projects Building ACM Abatement and Site Demolition FC 1602 PROJECT DESCRIPTION&JUSTIFICATION Contract with a materials monitoring company and with an ACM abatement/demolition contractor for the city building and all flatwork located at 6720 NE Loop 820. Complete removal of all utilities back to the service tap and the demolition and removal of all structures and concrete flatwork from the site. This will leave the property a vacant lot for future development.With the completion of the new City Hall Complex all departments currently located at 6720 and 7301 NE Loop 820 will relocate to the new City Hall. To prepare for the sale and/or future development of this site, all existing structures and concrete flatwork is to be removed. Demolition of structures and flatwork will provide a clean site for future investment and or development opportunities. PROJECT STATUS ORIGINAL 2014/15 ORIGINAL 2014/15 START DATE REVISION END DATE REVISION Professional Services 01/2016 01/2016 08/2016 08/2016 Engineering Land/ROW Acquisition Construction 04/2016 04/2016 08/2016 08/2016 Other REVISION EXPLANATION Provide funding for the additional electrical equipment added to the emergency power electrical circuits in the Emergency Operations Center. FINANCIAL DATA ADOPTED " _ REVISED TOTAL BUDGET THRU s u BUDGET THRU REMAINING PROJECT 2014/15 l, 0 2014/15 BALANCE COST FU DI r r IL, CIP Building Reserves $630,000 .x u® $610,000 $610,000 .; , 0 $0 0 $0 0 $0 0 so Total y $630 000 n n e s $610 000 $0 $610 000 PROt *:17f :,P,F®.C,i.:a :.... .. ..v.` `».d+- }.L 4n.:a:•:a#.. F*`"'. +fi,'�,."ha";:.w i..0,`'25'.i+§,?'t:. Professional Services $74,000 , $74,000 $74,000 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 556,000 N e r 536,000 $536,000 Other 0 $0 Total $630,000 mar, i a r w $610,000 $0 $555,909 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2014/15 2015/16 2016/17 2017/2018 2018/2019 TOTAL Projected $0 44 Major Capital Equipment Capital Projects Aerial Fire Apparatus 1 FS1701 PROJECT DESCRIPTION&JUSTIFICATION This project is for the purchase of a 107'Aerial Fire Apparatus.This purchase will replace Unit 974, an American LaFrance 100' aerial platform. This purchase will replace Unit 974.The replacement for this aerial device purchased in 2017 will be 12-years due to these units not rotating into reserve status. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 12/2016 Land/ROW Acquisition Construction 01/2017 01/2018 Other REVISION EXPLANATION Project funding included the sale of Unit 974 when purchasing the new Engine, Unit 974 was traded in, not sold. This revision is to reflect that changes and actual pricing of the new unit. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU °+ BUDGET THRU REMAINING PROJECT 2016/17 {• 2016/17 BALANCE COST Certificates of Obligation $680,000 Dle :: ��r3 $685,000 $0 $685,000 Reserves 3,152 y 20,838 $20,838 Other-Sale of Unit 974 247,848 0 $0 0 $0 M. 0 $0 Total, $931 000 $705 838 $0 $705,838 -'a 111 ` wa +is i $0 $0 Professional Services Engineering/Design 0 $0 Land/ROW Acquistion arr . 0 $0 Construction 931,000 705,838 $705,838 Other 0 $0 Total $931,000 o •'"; $705,838 $0 $699,636 IMPACT ON OPERATING BUDGET No Operating Impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 45 Major Capital Equipment Capital Projects Aerial Fire Apparatus 2 FS1702 PROJECT DESCRIPTION&JUSTIFICATION This project is for the purchase of a 107"Aerial Fire Apparatus. This piece of equipment will replace Unit 981, a 77'Tandem Axle Quint. This purchase will replace Unit 981.The replacement for this aerial device purchased in 2017 will be 12-years due to these units not rotating into reserve status. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 12/2016 Land/ROW Acquisition Construction 01/2017 01/2018 Other REVISION EXPLANATION Project funding included the sale of Unit 981,when purchasing the new aerial, Unit 981 was traded in, not sold. This revision is to reflect that changes and actual pricing of the new unit. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU + ,,1 BUDGET THRU REMAINING PROJECT 2016/17 = e lb 2016/17 BALANCE 0, COST Certificates of Obligation $710,000 .L $705,000 $0 $705,000 Reserves 2,040 838 $838 Other Sale of Unit 981 218,960 f. •a k' 0 $0 0 $0 0 $0 Total $931 000 $705 838 $0 $705 838 Professional Services $0 $0 Engineering/Design , 0 $0 Land/ROW Acquistion 0 $0 Construction 931,000 705,838 $705,838 Other 0 $0 Total $931,000 ,:e./[.'.411,-2.51.1020,, $705,838 $0 $712,040 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 46 Major Capital Equipment Capital Projects Fire Engine FS1703 PROJECT DESCRIPTION&JUSTIFICATION This is the replacement of a 1997 aerial quint, Unit 945, assigned to the Fire Department.The replacement of this equipment will be a fire engine. The normal replacement life for large fire apparatus is 20 years.The new aerial will replace an E-1 quint that will be 21 years old when taken out of service. Unit 945 has over 120,000 miles. Due to age of the apparatus, maintenance costs are increasing and parts availability is becoming more difficult. PROJECT STATUS ORIGINAL 2016/17 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 12/2016 Land/ROW Acquisition Construction 01/2017 01/2018 Other REVISION EXPLANATION Project funding included the sale of Unit 945 when purchasing the new Engine, Unit 945 was traded in, not sold. This revision is to reflect that change and actual pricing of the new unit. FINANCIAL DATA ADOPTED r REVISED TOTAL BUDGET THRU « BUDGET THRU REMAINING PROJECT .,y 1J g, vsN,ry:;..w;?:..✓ COST 2016/17 C M Certificates of Obligation $525,000 ! $525,000 $0 $525,000 Reserves 3,400 OA:: 65,860 0 $65,860 Other-Sale of Unit 945 27,600 0 0 $0 0 $0 0 $0 Total $556 000 ' $590 860 $0 $590 860 Professional Services le7t041140 $0 $0 Engineering/Design n 0 $0 .�. 0 $0 Land/ROW Acquistion Construction 556,000 •®a 590,860 0 $590,860 Other 0 $0 Total $556,000 , ..i.�$34 $590,860 $0 $590,860 IMPACT ON OPERATING BUDGET No operating impact anticipated. ANNUAL OPERATING IMPACT 2016/17 2017/18 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 47 Major Capital Equipment Capital Projects Replacement of CAD/RMS Public Safety Software Platform 1S1502 PROJECT DESCRIPTION&JUSTIFICATION Replacement of the current CAD/RMS software platform (CRIMES)with a different software and vendor. Increase building electrical service with an additional 400amp service panel. Install re-purposed generator/transfer switch and four(4) UPS units with all related panels,wiring and receptacles to provide the necessary power for the E.O.C. PROJECT STATUS ORIGINAL 2014115 ORIGINAL 2014115 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2014 10/2014 12/2015 01/2017 REVISION EXPLANATION Additional electrical equipment added to the emergency power electrical circuits. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU + BUDGET THRU REMAINING PROJECT 2014115 0 2014115 BALANCINE COST >FUNDIIV ®;, * Z, . < , " ., . 're ,.. $3,000,000 $3,000,000 $3,000,000 CIP FC1602 Buildings Reserve Funds r r 20,000 $20,000 0 $0 0 $0 0 $0 Total $3 000 000 ' a o a $3 020 000 $0 $3 020 000 bc PRO t 4PR ® .U _. Professional Services r $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction r i t® 20,000 $20,000 Other 3,000,000 r''` 3,000,000 $3,000,000 Total $3,000,000 :; i0tt=` $3,020,000 $0 $3,020,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2014/15 2015/16 2016/17 2017/2018 2018/2019 TOTAL Projected $0 48 Other Capital Projects Neighborhood Initiative Program ES0901 PROJECT DESCRIPTION&JUSTIFICATION The Neighborhood Initiative Program was developed in Jan.2004. This program helps seniors, single parents and physically challenged individuals with minor exterior home repairs. In 2007, the City Council gave an additional$90,000 for NIP and $15,000 for Neighborhood Looks through the TXU settlement to assist low income families with emergency repairs. The Neighborhood Initiative Program was expanded,to provide cash incentives for residential homeowners to reinvest in their homes and to provide some monetary support to volunteer groups helping with larger exterior renovations. Donations from business and faith communities are used to sustain the program. Neighborhood Revitalization continues to be at the forefront of the City Council's goals. Encouraging homeowners to reinvest in their homes will also give them pride in homeownership and they will be more likely to remain in our City and not turn their home into rental property. This money is to be reinvested in the City, as long as funds are available,to maintain the quality of life desired. PROJECT STATUS ORIGINAL 2016117 ORIGINAL 2016/17 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 01/2004 09/2017 REVISION EXPLANATION A grant in the form of a gift card from the Home Depot Foundation was received in Oct. 2017 to apply to this project. FINANCIAL DATA ADOPTED r" REVISED TOTAL BUDGET THRU :4:::1441.44'411, ,4 BUDGETTHRU REMAINING PROJECT 2016117 w " 2016/17 BALANCE COST Reserves $187,158 sr. �' $187,158 $0 $187,158 Other-Donations 60,000 " ®®! 65,000 0 $65,000 r 0 $0 0 $0 f k' 0 $0 Total 7 158 a s'" $252 158 $0 $252 158 y , Professional Services $0 $0 Engineering/Design .r 0 $0 Land/ROW Acquistion e 0 $0 Construction 0 $0 Other 247,158 ' pit 252,158 0 $252,158 Total $247,158 `�.a -.00 $252,158 $0 $252,158 IMPACT ON OPERATING BUDGET No operating impact. ANNUAL OPERATING IMPACT 2016/17 2017118 2018/19 2019/20 2020/21 TOTAL Projected 0 0 0 0 0 $0 49