Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 2019 TCMUD Budget
CERTIFICATE OF RESOLUTION 2018-0917B THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT § § I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. I of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: I. That I am the dul y qualified Secretary of th e Board of Directors of the District, . and that, as such , I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 17 , 2018 , at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors , to wit: Gregory Wilson William C. Rose Steve Flynn Kelly Castonguay Mark Chapman President Vice President Secretary rr reasu rer Director Director All members of the Board were present except Dire ctors Flynn a nd Chapman , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: A RESOLUTION APPROVING THE 2019 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 and duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and , after due discussion,. such motion , carrying with it the adoption of such Resolution, prevailed and carried by the following vote : AYES : 3 NAYS : 0 ABSTENSIONS: - 3 . That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been dul y recorded in the minutes of the Boa rd of Directors for such meetin g; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein , that each was duly and sufficiently notified offici a ll y and personally , in advance , of the time , place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting , and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2 , is true and conect; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551 , Texas Government Code, as amended. SIGNED AND SEALED the 17th day of September 2018. Steve Flynn, Secretary/Trea u·er Board of Directors Laune Slaght, District Seer RESOLUTION NO. 2018-0917B A RESOLUTION APPROVING THE 2019 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a . conservation and reclamation district of the State of Texas created under Article XVI, Sec. 59 of the Texas Constitution, and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.057(b) of the Texas Water Code requires the bom;d of directors of a water district to adopt an annual budget; WHEREAS, Title 30, Section 293.97(b), Texas Administrative Code, provides that an operating budget shall be passed and approved by a resolution of the governing board of a water district and shall be made a part of the governing board minutes; and WHEREAS, the Board ofDirectors of the District desires to adopt a budget for the 2019 fiscal year in an open, public meeting, proper notice of which has been given as required by law. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1: Section 1. That the facts and recitations found in the preamble of this Resolution are hereb~ found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. That the annual budget of revenues and expenditures necessmy for conducting the operations and affairs of the District for Fiscal Year 2019, attached hereto and incorporated herein as Exhibit A, is hereby approved and adopted. Said budget document shall be on file for public inspection in the office of the District. Section 3. That the District's expenditures during the fiscal year shall be made in accordance with the approved budget and any amendments thereto approved by the Board of Directors. Section 4. A copy of this Resolution and the budget approved hereby shall be attached to the minutes of the Board's September 17, 2018 meeting . · Section 5. passage. That this Resolution shall become effective immediately upon its RESOLVED, PASSED AND APPROVED by the Board ofDirectors of Trophy Club Municipal Utility District No. 1, this the 17th day of September 2018 . Gregory Wilson , President Board of Directo s Steve Flynn, Seer ,tary/Treasurer Board of Directors EXIDBIT "A" (Approved FY 2019 Budget) MUD Tarrant Co.433,850,584 2018 2019 MUD Denton Co.1,228,583,025 O&M (General Fund) Tax 0.00788 0.00765 PID 745,061,830 I & S (Debt Service) Tax 0.04363 0.04134 Out of District & PID 338,989 Fire Tax 0.06870 0.06719 Total Value:2,407,834,428 Total Tax Rate:0.12021 0.11618 Increase/Decrease:-0.00403 PID Fire Assessment Rate:0.06870 0.06719 Increase/Decrease:-0.00151 Revenue 10,308,835 FY 2019 Tax Collections 132,384 FY 2019 PID Surcharges 171,983 Revenue Reserve Funds - FY 2019 Tax Collections Total Revenue:10,613,203 PID Surcharge Water Expense 5,641,835 Total Revenue: Wastewater Expense 2,872,082 Debt Service Expense Board of Directors Expense 13,230 Total Expense: Administration Expense 1,559,905 Net Budget Surplus/Deficit Non-Departmental Expense 184,314 Total Expense:10,271,366 Net Budget Surplus/Deficit 341,837 Revenue Total Revenue: Debt Service Expense Total Expense: Revenue 175,000 Net Budget Surplus/Deficit FY 2019 Tax Collections 1,117,000 FY 2019 PID Assessment 500,839 Reserve Funds - Revenue Total Revenue:1,792,839 Total Revenue: Fire Expense 1,792,839 Debt Service Expense Total Expense:1,792,839 Total Expense: Net Budget Surplus/Deficit - Net Budget Surplus/Deficit 600 Adopted Fiscal Year 2019 Budget 596,238 1,000 Trophy Club Municipal Utility District No. 1 597,238 597,238 596,238 TAX RATE SUMMARY Revenue Debt Service Fund WWTP Tax Debt Service Fund 277,501 277,501 Revenue Debt Service Fund SWIFT 276,901 276,901 1,029,008 1,023,208 1,023,208 5,800 Fire Fund 2019 PROPERTY VALUE SUMMARY 217,979 690,975 120,053 General Fund Resolution No. 2018-0917B - Exhibit "A" 1 of 25 GENERAL FUND General Fund Expenses 135-69008-010-000 Short Term Debt-Principal 129,000 130,700 - 38,731 - 30,068 30,068 135-65053-010-000 Meter Change Out Program - 77,325 71,160 84,000 84,000 87,000 87,000 135-69005-010-000 Capital Outlays 439,705 1,492,504 323,263 810,012 1,085,012 453,000 453,000 135-65040-010-000 Safety Equipment 457 719 507 1,000 1,000 1,000 1,000 135-65050-010-000 Meter Expense 119,269 88,942 24,000 50,000 50,000 70,000 70,000 135-65030-010-000 Chemicals 10,195 13,070 24,217 20,000 20,000 20,000 20,000 135-65035-010-000 Small Tools 995 868 868 1,200 1,200 1,200 1,200 135-65005-010-000 Fuel & Lube 12,517 12,647 8,733 15,000 15,000 15,000 15,000 135-65010-010-000 Uniforms 3,185 2,170 3,064 4,488 4,488 5,190 5,190 135-60334-010-000 Interfund Transfer Out-Bank Reserve Account --- 200,000 200,000 200,000 200,000 135-60360-010-000 Furniture/Equipment < $5000 1,823 --2,500 2,500 2,500 2,500 135-60332-010-000 Interfund Transfer Out- Revenue I&S -- 240,822 278,084 278,084 585,209 585,209 135-60333-010-000 Interfund Transfer Out- Bond Reserve -- 48,047 48,996 48,996 55,193 55,193 135-60280-010-000 Property Maintenance 1,583 2,643 775 3,000 3,000 3,000 3,000 135-60285-010-000 Lawn Equipment & Maintenance -- 8,250 14,750 14,750 14,750 14,750 135-60150-010-000 Wholesale Water 2,266,895 2,030,607 2,068,311 2,823,170 2,823,170 3,013,494 3,013,494 135-60245-010-000 Miscellaneous Expenses --103 200 200 200 200 135-60105-010-000 Rent/Lease Equipment -379 -1,500 1,500 1,500 1,500 135-60135-010-000 TCEQ Fees & Permits - MUD 30,058 17,788 31,064 55,176 55,176 58,000 58,000 135-60090-010-000 Safety Program -249 -400 400 400 400 135-60100-010-000 Travel & per diem 240 87 124 1,735 1,735 2,345 2,345 135-60070-010-000 Dues & Memberships -11 -500 500 500 500 135-60080-010-000 Schools & Training 1,353 1,545 936 2,785 2,785 4,651 4,651 135-60020-010-000 Electricity 147,907 150,535 156,752 175,356 150,000 154,204 154,204 135-60066-010-000 Publications/Books/Subscripts 739 716 767 1,000 1,000 1,000 1,000 135-55135-010-000 Lab Analysis - MUD 4,961 6,389 3,948 5,500 5,500 6,500 6,500 135-60010-010-000 Communications/Mobiles 3,997 4,717 4,589 4,700 4,700 5,000 5,000 135-55105-010-000 Maintenance-Heavy Equipment 4,417 2,893 -3,500 3,500 3,500 3,500 135-55120-010-000 Cleaning Services --5,214 5,214 135-55085-010-000 Generator Maintenance & Repairs -- 2,459 3,000 3,000 3,000 3,000 135-55090-010-000 Vehicle Maintenance 7,466 6,229 2,253 4,000 4,000 5,000 5,000 135-55005-010-000 Engineering 1,710 109,670 25,390 275,000 - 20,000 20,000 135-55080-010-000 Maintenance & Repairs 62,171 84,225 87,258 100,000 100,000 100,000 100,000 135-50060-010-000 Pre-emp Physicals/Testing 1,037 236 347 200 200 200 200 135-50070-010-000 Employee Relations 192 112 187 300 300 300 300 135-50040-010-000 Unemployment Taxes 24 859 51 1,080 1,080 1,080 1,080 135-50045-010-000 Workman's Compensation 8,975 12,438 11,864 11,854 11,854 12,895 12,895 135-50030-010-000 Social Security Taxes 14,868 14,627 15,286 18,662 18,662 22,021 22,021 135-50035-010-000 Medicare Taxes 3,477 3,421 3,575 4,365 4,365 5,150 5,150 135-50028-010-000 Vision Insurance 677 662 578 994 994 701 701 135-50029-010-000 Life Insurance & Other 2,975 2,361 2,576 2,982 2,982 3,131 3,131 135-50026-010-000 Medical Insurance 36,698 38,990 30,038 52,196 52,196 74,818 74,818 135-50027-010-000 Dental Insurance 2,927 2,944 2,942 5,182 5,182 4,317 4,317 135-50017-010-000 Certification 2,725 2,400 2,600 3,300 3,300 4,800 4,800 135-50020-010-000 Retirement 21,735 20,866 21,489 27,843 27,843 33,304 33,304 135-50010-010-000 Overtime 16,318 13,385 13,069 20,000 20,000 20,000 20,000 135-50016-010-000 Longevity 2,705 2,945 3,270 3,425 3,425 3,620 3,620 Water 135-50005-010-000 Salaries & Wages 221,838 219,077 232,082 274,279 274,279 326,755 326,755 135-00000-000-000 Reimbursement from 2.42 Revenue Bond-Eng 260,000 260,000 -- Total 7,964,090 7,164,842 8,957,219 10,248,327 11,098,872 10,489,599 10,613,203 135-49901-000-000 Records Management Revenue 18 44 32 20 20 -- 135-49903-000-000 Recovery of Prior Year Expense -- 81,791 ---- 135-49145-000-000 Intergov Transfer In 1,074,337 ------ 135-49900-000-000 Miscellaneous Income 98,675 28,818 (27,448) 5,000 15,000 7,000 7,000 135-49075-000-000 Oversize Meter Reimbursement 58,023 51,654 20,864 18,179 18,179 18,522 18,522 135-49141-000-000 Interfund Transfer In - 8,034 -- 796,145 -- 135-49035-000-000 Prior Year Reserves ------- 135-49036-000-000 GASB Reserves 74,706 13,088 ----- 135-49018-000-000 Building Rent Income 7,000 7,000 7,000 7,000 7,000 7,000 7,000 135-49026-000-000 Proceeds from Sale of Assets 46,750 30,935 39,899 2,000 15,400 10,000 10,000 135-49010-000-000 Interest Income 6,117 12,652 18,940 12,000 50,000 20,000 20,000 135-49016-000-000 Cell Tower Revenue 10,926 10,926 10,926 10,926 10,926 14,146 14,146 135-47070-000-000 TCCC Effluent Charges 67,064 45,511 87,159 60,000 60,000 60,000 60,000 135-48010-000-000 Utility Fees 239,200 55,200 ---- 135-47035-000-000 Plumbing Inspections 2,450 2,600 2,400 1,500 1,500 1,500 1,500 135-47045-000-000 Sewer Inspections 7,350 7,650 4,800 4,500 4,500 4,500 4,500 135-47025-000-000 Penalties 100,639 101,584 121,528 106,279 106,279 136,418 136,418 135-47030-000-000 Service Charges (Disconnect Fees)10,599 12,850 14,100 21,350 14,350 17,000 17,000 135-47000-000-000 Water 3,781,229 4,210,866 5,822,785 6,464,019 6,464,019 6,599,484 6,599,484 135-47005-000-000 Sewer 2,179,235 2,359,115 2,587,176 2,976,365 2,976,365 3,289,061 3,412,665 135-40015-000-000 Property Taxes/P & I 727 746 350 200 200 300 300 135-40025-000-000 PID Surcharges 30,645 146,125 103,619 177,839 177,839 171,983 171,983 135-40000-000-000 Property Taxes 167,935 57,250 61,008 120,950 120,950 132,384 132,384 135-40002-000-000 Property Taxes/Delinquent 464 2,192 290 200 200 300 300 Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2018 Amended FY 2019 Proposed FY 2019 Adopted General Fund Revenues Resolution No. 2018-0917B - Exhibit "A" 2 of 25 Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2018 Amended FY 2019 Proposed FY 2019 Adopted 135-69009-010-000 Short Term Debt-Interest 3,632 1,178 - 5,713 5,713 4,124 4,124 135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 75,000 75,000 75,000 135-69281-010-000 Water Tank Inspection Contract 126,958 126,958 126,958 118,774 110,000 120,000 120,000 135-55135-010-001 Lab Analysis - PID 3,046 1,725 2,183 2,000 2,000 2,000 2,000 135-60135-010-001 TCEQ Fees & Permits - PID ------- Subtotal Water 3,796,451 4,777,812 3,681,755 5,657,433 5,584,571 5,641,835 5,641,835 Wastewater 135-50005-020-000 Salaries & Wages 305,552 369,462 387,947 410,866 410,866 421,699 421,699 135-50010-020-000 Overtime 27,622 35,175 31,979 30,000 30,000 30,000 30,000 135-50016-020-000 Longevity 5,615 6,125 6,635 7,415 7,415 7,445 7,445 135-50017-020-000 Certification 6,600 7,611 8,275 8,400 8,400 8,700 8,700 135-50020-020-000 Retirement 30,826 36,694 38,208 42,243 42,243 43,276 43,276 135-50026-020-000 Medical Insurance 57,602 66,679 55,136 62,175 62,175 91,627 91,627 135-50027-020-000 Dental Insurance 3,682 4,119 4,464 5,271 5,271 5,104 5,104 135-50028-020-000 Vision Insurance 853 930 954 1,114 1,114 826 826 135-50029-020-000 Life Insurance & Other 4,399 4,116 4,552 4,281 4,281 4,495 4,495 135-50030-020-000 Social Security Taxes 19,403 23,597 25,343 28,314 28,314 29,006 29,006 135-50035-020-000 Medicare Taxes 4,523 5,519 5,927 6,622 6,622 6,784 6,784 135-50040-020-000 Unemployment Taxes 14 1,204 63 1,260 1,260 1,260 1,260 135-50045-020-000 Workman's Compensation 8,975 7,003 14,903 17,990 17,990 16,941 16,941 135-50060-020-000 Pre-emp Physicals/Testing 189 238 80 300 300 400 400 135-50070-020-000 Employee Relations 523 722 461 350 350 300 300 135-55005-020-000 Engineering --852 -- 30,000 30,000 135-55070-020-000 Independent Labor - 27,109 19,449 20,550 5,550 15,000 15,000 135-55080-020-000 Maintenance & Repairs 96,664 173,132 97,990 86,100 86,100 88,000 88,000 135-55085-020-000 Generator Maintenance & Repairs -- 6,076 14,000 14,000 10,000 10,000 135-55090-020-000 Vehicle Maintenance 3,540 7,165 9,836 8,000 8,000 8,000 8,000 135-55105-020-000 Maintenance-Heavy Equipment 803 742 24 500 500 1,500 1,500 135-55120-020-000 Cleaning Services --5,214 5,214 135-55125-020-000 Dumpster Services 48,977 41,801 56,329 60,000 60,000 75,000 75,000 135-55135-020-000 Lab Analysis 26,355 37,393 32,416 30,000 30,000 35,000 35,000 135-60010-020-000 Communications/Pagers/Mobiles 5,274 5,888 5,460 4,700 4,700 5,000 5,000 135-60020-020-000 Electricity 136,622 131,275 145,449 266,709 176,709 174,165 174,165 135-60066-020-000 Publications/Books/Subscripts 135 -150 200 200 200 200 135-60070-020-000 Dues & Memberships 307 300 267 300 300 300 300 135-60080-020-000 Schools & Training 1,526 3,361 2,959 5,677 5,677 7,155 7,155 135-60090-020-000 Safety Program -341 291 550 550 1,000 1,000 135-60100-020-000 Travel & per diem 2,257 977 2,625 1,635 1,635 1,895 1,895 135-60105-020-000 Rent/Lease Equipment 1 8,639 - 5,000 5,000 5,000 5,000 135-60125-020-000 Advertising -- 4,086 5,000 5,000 2,500 2,500 135-60135-020-000 TCEQ Fees & Permits 9,019 18,527 32,564 85,000 85,000 30,000 30,000 135-60245-020-000 Miscellaneous Expenses 19 423 113 450 450 450 450 135-60280-020-000 Property Maintenance --- 4,000 4,000 5,000 5,000 135-60285-020-000 Lawn Equipment & Maintenance 785 - 6,490 11,600 11,600 11,600 11,600 135-60331-020-000 Interfund Transfer Out-Tax I&S 30,645 119,706 120,492 122,043 122,043 120,053 120,053 135-60332-020-000 Interfund Transfer Out- Revenue I&S 136,989 444,838 595,638 598,738 598,738 688,330 688,330 135-60333-020-000 Interfund Transfer Out-Bond Reserve 71,946 123,336 - 123,336 123,336 125,187 125,187 135-60334-020-000 Interfund Transfer Out-Bank Reserve Account -- 180,417 200,000 944,512 200,000 200,000 135-60360-020-000 Furniture/Equipment < $5000 --- 4,000 4,000 3,500 3,500 135-65005-020-000 Fuel & Lube 17,164 10,253 8,722 12,500 12,500 12,500 12,500 135-65010-020-000 Uniforms 2,598 4,142 3,754 4,459 4,459 5,495 5,495 135-65030-020-000 Chemicals 21,409 28,882 25,101 27,500 27,500 30,000 30,000 135-65035-020-000 Small Tools 1,504 1,787 2,191 1,000 1,000 1,200 1,200 135-65040-020-000 Safety Equipment 626 577 517 750 750 1,200 1,200 135-65045-020-000 Lab Supplies 12,341 17,349 13,258 14,000 14,000 20,000 20,000 135-69005-020-000 Capital Outlays 196,760 188,556 276,328 547,327 547,327 330,000 330,000 135-69008-020-000 Short Term Debt-Principal 56,991 21,277 - 51,342 - 109,858 109,858 135-69009-020-000 Short Term Debt-Interest 1,952 197 - 7,573 7,573 14,917 14,917 135-69195-020-000 Gasb34/Reserve for Replacement --- 30,000 30,000 30,000 30,000 Subtotal Wastewater 1,359,587 1,987,167 2,234,770 2,981,140 3,569,310 2,872,082 2,872,082 Board of Directors 135-50005-026-000 Salaries & Wages 14,900 9,100 ----- 135-50030-026-000 Social Security Taxes 924 564 ----- 135-50035-026-000 Medicare Taxes 216 132 ----- 135-55040-026-000 Unemployment Taxes 67 2 ----- 135-50045-026-000 Workman's Compensation 35 50 30 30 30 30 30 135-60066-026-000 Publications/Books/Subscripts ---150 150 150 150 135-60070-026-000 Dues & Memberships 35 11 -600 600 750 750 135-60075-026-000 Meetings 276 474 145 1,200 1,200 1,300 1,300 135-60080-026-000 Schools & Training 2,950 1,875 3,557 4,000 4,000 4,000 4,000 135-60100-026-000 Travel & per diem 3,479 3,314 2,690 5,000 5,000 5,000 5,000 135-60245-026-000 Miscellaneous Expenses 1,659 260 75 2,000 2,000 2,000 2,000 Subtotal Board of Directors 24,541 15,782 6,498 12,980 12,980 13,230 13,230 GENERAL FUND Resolution No. 2018-0917B - Exhibit "A" 3 of 25 Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Budget FY 2018 Amended FY 2019 Proposed FY 2019 Adopted Administration 135-50005-030-000 Salaries & Wages 464,345 484,728 432,978 432,863 432,863 441,006 441,006 135-50010-030-000 Overtime 608 901 3,498 2,000 2,000 2,000 2,000 135-50016-030-000 Longevity 3,283 3,823 3,418 3,548 3,548 1,833 1,833 135-50020-030-000 Retirement 41,787 42,642 37,687 40,553 40,553 41,148 41,148 135-50026-030-000 Medical Insurance 61,099 61,243 44,204 63,485 63,485 81,895 81,895 135-50027-030-000 Dental Insurance 3,754 4,207 3,938 5,502 5,502 4,291 4,291 135-50028-030-000 Vision Insurance 1,012 975 842 1,173 1,173 701 701 135-50029-030-000 Life Insurance & Other 5,203 4,678 4,426 5,059 5,059 4,495 4,495 135-50030-030-000 Social Security Taxes 27,363 28,227 25,994 27,181 27,181 27,580 27,580 135-50035-030-000 Medicare Taxes 6,399 6,601 6,079 6,357 6,357 6,450 6,450 135-50040-030-000 Unemployment Taxes 144 1,349 294 1,260 1,260 1,260 1,260 135-50045-030-000 Workman's Compensation 1,048 2,067 1,796 1,529 1,529 1,295 1,295 135-50060-030-000 Pre-emp Physicals/Testing 38 147 701 500 500 500 500 135-50070-030-000 Employee Relations 2,796 3,421 2,692 4,960 4,960 5,000 5,000 135-55005-030-000 Engineering - 4,365 ----- 135-55030-030-000 Software & Support 112,750 47,907 88,943 78,391 78,391 77,849 77,849 135-55045-030-000 Legal ------- 135-55070-030-000 Independent Labor 57,935 1,806 30,925 154,000 154,000 175,000 175,000 135-55080-030-000 Maintenance & Repairs 535 6,284 826 14,000 14,000 20,000 20,000 135-55085-030-000 Generator Maintenance & Repairs 6,368 -485 10,000 10,000 10,000 10,000 135-55100-030-000 Building Maint & Supplies 7,530 6,890 7,705 ---- 135-55120-030-000 Cleaning Services 22,602 7,017 6,705 10,000 10,000 10,000 10,000 135-55160-030-000 Professional Outside Services 26,170 69,683 63,965 63,325 63,325 66,055 66,055 135-55165-030-000 Collection Fees ---200 200 -- 135-55205-030-000 Utility Billing Contract 7,872 8,516 7,514 9,000 9,000 9,000 9,000 135-60005-030-000 Telephone 11,851 13,723 14,081 27,300 17,300 23,500 23,500 135-60010-030-000 Communications/Mobiles 4,053 4,041 3,621 4,000 4,000 4,000 4,000 135-60020-030-000 Electricity 11,326 7,245 11,002 16,261 16,261 8,690 8,690 135-60025-030-000 Water 922 934 1,041 2,500 2,500 2,000 2,000 135-60035-030-000 Postage 31,693 27,203 27,334 30,000 30,000 30,000 30,000 135-60040-030-000 Bank Service Charges & Fees 45,820 51,500 52,782 55,560 55,560 55,560 55,560 135-60050-030-000 Bad Debt Expense 1,712 3,459 1,674 1,500 1,500 1,500 1,500 135-60055-030-000 Insurance 49,110 33,573 59,614 56,000 56,000 65,000 65,000 135-60066-030-000 Publications/Books/Subscripts 1,225 260 770 1,600 1,600 1,000 1,000 135-60070-030-000 Dues & Memberships 4,558 5,656 4,851 6,000 6,000 6,000 6,000 135-60075-030-000 Meetings 60 163 122 400 400 400 400 135-60079-030-000 Public Education 3,385 4,230 4,972 6,000 6,000 6,000 6,000 135-60080-030-000 Schools & Training 2,938 3,382 2,255 7,600 7,600 8,950 8,950 135-60100-030-000 Travel & per diem 2,018 3,562 7,112 4,885 4,885 4,345 4,345 135-60110-030-000 Physicals/Testing ---200 200 200 200 135-60115-030-000 Elections 1,289 3,610 2,961 4,500 4,500 -- 135-60125-030-000 Advertising 6,983 1,549 2,323 2,500 2,500 25,000 25,000 135-60235-030-000 Security 60 -- 2,700 2,700 1,288 1,288 135-60245-030-000 Miscellaneous Expenses 10,801 5,448 503 500 500 500 500 135-60246-030-000 General Manager Contingency - 17,000 17,000 17,000 17,000 135-60270-030-000 4th of July Celebration 10,000 ------ 135-60285-030-000 Lawn Equipment & Maintenance ------- 135-60336-030-000 Interfund Trans Out (MUD1 I&S)14,000 ------ 135-60360-030-000 Furniture/Equipment < $5000 6,339 656 1,056 2,500 2,500 2,500 2,500 135-65010-030-000 Uniforms 1,043 23 475 700 700 2,050 2,050 135-65055-030-000 Hardware IT 35,172 7,238 2,300 7,420 7,420 7,064 7,064 135-65085-030-000 Office Supplies 8,145 5,632 5,353 7,000 7,000 6,000 6,000 135-65090-030-000 Printer Supplies & Maintenance 2,870 1,302 754 2,000 2,000 3,500 3,500 135-65095-030-000 Maintenance Supplies 4,461 3,632 3,985 4,000 4,000 4,000 4,000 135-65105-030-000 Printing 1,333 3,232 2,593 4,000 4,000 2,500 2,500 135-69005-030-000 Capital Outlays 61,822 24,907 129,301 13,000 13,000 280,000 280,000 135-69170-030-000 Copier Lease Installments 3,485 3,888 3,929 4,600 4,600 4,000 4,000 Subtotal Administration 1,199,115 1,017,525 1,122,380 1,227,111 1,217,112 1,559,904 1,559,905 Non Departmental 135-55045-039-000 Legal 495,151 338,721 118,762 137,000 137,000 137,000 137,000 135-55055-039-000 Auditing 16,836 29,039 18,809 24,500 24,500 30,800 30,800 135-55060-039-000 Appraisal 9,846 10,088 10,713 11,446 11,446 11,714 11,714 135-55065-039-000 Tax Admin Fees 2,456 2,469 2,562 3,800 3,800 4,800 4,800 Subtotal Non Departmental 524,289 380,317 150,846 176,746 176,746 184,314 184,314 Total General Fund Revenues 7,964,090 7,164,842 8,957,219 10,248,327 11,098,872 10,489,599 10,613,203 Total General Fund Expenses 6,903,983 8,178,601 7,196,249 10,055,410 10,560,719 10,271,365 10,271,366 Net Budget Surplus (Deficit)1,060,107 (1,013,759) 1,760,970 192,917 538,153 218,233 341,837 GENERAL FUND Resolution No. 2018-0917B - Exhibit "A" 4 of 25 Account Description FY 2016 Actual FY 2017 Actual FY2018 Budget FY 2019 Proposed FY 2019 Amended YTD Totals Revenues-Town 122-40001-000-000 Assessment - Emerg Svcs 403,838 427,439 486,626 538,869 500,839 122-40003-000-000 Emer Svcs Assessmen/Delinquent 346 ---- 122-40015-000-000 Property Taxes/Assessments P&I -750 --- 122-42014-000-000 Fire Permits/Sprinkler & Plan Review 5,200 5,000 100 65,000 90,000 122-43400-000-000 Fire Inspections 1,075 825 --- 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 10,000 10,000 10,000 Revenues-MUD 122-40001-000-000 Assessment-Emerg Svcs Reimb from Town -112 --- 122-40010-000-000 Property Taxes/MUD Fire 875,978 1,036,680 1,054,433 1,201,853 1,117,000 1,065,982 122-40011-000-000 Property Taxes/Fire-Delinquent 18,076 3,196 ---3,945 122-40020-000-000 Property Taxes/Fire P&I 7,621 4,184 ---4,778 122-49000-000-000 Capital Leases-Other Financial Sources - 122-49026-000-000 Proceeds from Sale of Assets 60,000 60,000 ---- 122-49035-000-000 Prior Year Reserves ----75,000 - 122-49036-000-000 GASB Reserves 36,182 23,164 ---- 122-49900-000-000 Miscellaneous Income 11,100 149 --- Total Revenue 1,429,416 1,571,499 1,551,159 1,815,722 1,792,839 1,084,705 Expenses-Town 122-50005-045-000 Salaries & Wages 511,904 537,947 558,792 638,481 642,064 122-50010-045-000 Overtime 58,952 74,868 50,122 73,688 73,688 122-50011-045-000 Holiday Pay 14,718 ---- 122-50016-045-000 Longevity 5,730 5,599 5,879 6,566 6,566 122-50017-045-000 Certification 4,740 4,988 4,950 4,950 4,950 122-50020-045-000 Retirement 71,888 79,312 81,248 90,511 90,511 122-50026-045-000 Medical Insurance 56,876 61,919 85,723 85,791 75,498 122-50027-045-000 Dental Insurance 5,016 4,373 4,285 4,998 5,985 122-50028-045-000 Vision Insurance 968 429 433 536 536 122-50029-045-000 Life Insurance & Other 4,016 2,853 3,746 4,068 4,068 122-50030-045-000 Social Security Taxes 32,993 34,575 37,565 43,901 44,123 122-50035-045-000 Medicare Taxes 7,714 8,084 8,785 10,267 10,319 122-50040-045-000 Unemployment Taxes 2,125 144 1,424 1,628 1,628 122-50045-045-000 Workman's Compensation 9,379 7,885 10,139 11,203 11,269 122-50060-045-000 Pre-employment Physicals/Test 54 2,917 4,600 7,794 7,794 122-50075-045-000 Tuition Reimbursement -2,184 5,075 9,600 9,600 122-55030-045-000 Software & Support 5,561 608 6,943 12,813 12,813 122-55045-045-000 Legal 6,560 ---- 122-55080-045-000 Maintenance & Repairs/Equipment 54,653 5,214 17,240 21,900 21,900 122-55085-045-000 Generator Maintenance & Repairs ---- 122-55090-045-000 Vehicle Maintenance 14,808 23,053 46,000 48,500 48,500 122-55100-045-000 Building Maintenance - 13,758 16,750 93,000 18,000 122-55160-045-000 Professional Outside Services 2,744 2,327 2,723 3,000 3,000 122-60005-045-000 Telephone 59 ---- 122-60010-045-000 Communications/Mobiles 6,835 11,235 13,245 8,925 8,925 122-60020-045-000 Electricity/Gas 5,686 6,446 8,140 8,000 8,000 122-60080-045-000 Schools & Training 3,743 3,825 15,670 24,090 24,090 122-60025-045-000 Water 2,027 2,758 4,648 3,800 3,800 122-60026-045-000 Cable 1,920 ---- 122-60035-045-000 Postage 46 57 50 100 100 122-60096-045-000 Emergency Management 1,000 1,919 1,000 1,000 1,000 122-60100-045-000 Travel & per diem 1,147 1,979 7,066 13,507 13,507 122-60066-045-000 Publications/Books/Subscrips 172 350 350 350 350 122-60070-045-000 Dues & Memberships 15,457 15,404 19,295 20,417 20,417 122-60110-045-000 Physicals/Testing 6,804 ---- 122-60125-045-000 Advertising 4,200 398 500 750 750 122-60160-045-000 Programs & Special Projects 3,671 6,581 13,750 15,300 15,300 122-60180-045-000 Fire Inspection/Enforcement 359 ---- 122-60195-045-000 Flags & Repair 2,355 3,311 3,500 9,419 9,419 122-60243-045-000 Prior Year Expense ----- 122-60245-045-000 Miscellaneous Expense 1,119 767 6,000 6,000 6,000 122-60280-045-000 Property Maintenance ----- 122-66500-045-000 Dispatch- Denton County -2,376 -3,481 3,481 122-65005-045-000 Fuel 4,729 15,614 13,613 13,933 13,933 122-65010-045-000 Uniforms 9,516 9,266 6,687 5,907 5,907 122-65015-045-000 Protective Clothing 47,907 27,815 30,200 31,600 31,600 122-65030-045-000 Chemicals 1,191 ---- 122-65035-045-000 Small Tools/Equipment 1,868 17,681 5,000 25,800 8,300 122-65055-045-000 Hardware 394 - 1,100 4,200 4,200 122-65085-045-000 Office Supplies 328 815 250 250 250 122-65095-045-000 Maintenance & Supplies -410 1,500 1,500 1,500 122-65105-045-000 Printing -265 250 250 250 122-00000-045-000 Printer Supplies -- 1,400 1,400 1,400 122-69050-045-000 Radios 7,934 ---- 122-69255-045-000 Airpacks ----- 122-83700-045-000 Capital Expenses - 28,962 ---- FIRE DEPARTMENT Resolution No. 2018-0917B - Exhibit "A" 5 of 25 Expenses-MUD 122-55080-045-000 Maintenance & Repairs (GASB34)-----1,490 122-60030-045-000 Rent And/Or Usage 214,379 214,379 218,954 215,979 215,979 218,954 122-60055-045-000 Insurance 9,072 9,072 18,000 18,000 18,000 13,969 122-60337-045-000 Transfer to Town/Fire Budget -----558,168 122-69005-045-000 Capital Outlays 7,918 7,918 --75,000 - 122-69008-045-000 Short Term Debt -Principal ------ 122-69009-045-000 Short Term Debt -Interest ------ Total Fire Expenses 1,441,804 1,471,209 1,551,159 1,815,722 1,792,839 122-69195-045-000 GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 122-69305-045-000 Capital Leases 127,149 127,149 127,149 127,149 127,149 127,149 Total 1,441,804 1,471,209 1,551,159 1,815,722 1,792,839 1,001,149 Net Budget Surplus (Deficit)(12,388) 100,290 --- Town/MUD Fire Contract Calculation FY 2019 Total Fire Revenues 1,429,416 1,571,499 1,551,159 1,815,722 1,792,839 Fire Budget 1,792,839 Less: Rent/Debt Service 215,979 Less: Capital Leases 127,149 Less: ESD Assessment 500,839 Less: TML Fire Insurance 18,000 Less: Capital Outlays 75,000 Less: GASB34/Reserve for Replacement 81,420 Less: Denton County Fire Pledge 10,000 Less: Fire Permits/Sprinkler 90,000 Less: Fire Inspections - 122-60337-045-000 Transfer to Town from MUD/Fire Budget 674,452 Monthly payment to Town Oct 18-Sept 19 56,204 Account Description FY 2016 Actual FY 2017 Actual FY2018 Budget FY 2019 Proposed FY 2019 Amended YTD Totals FIRE DEPARTMENT Resolution No. 2018-0917B - Exhibit "A" 6 of 25 Account Description FY 2018 Budget FY 2018 Amended PROPOSED FY 2019 YTD Total thru 08/31/18 Comments Debt Service Revenues 533-40000-000-000 Property Taxes 669,660 669,660 687,175 677,002 SEE SCHEDULE TAX_ASSESS 533-40002-000-000 Property Taxes/Delinquent 1,800 1,800 1,800 2,625 533-40015-000-000 Property Taxes/P & I 2,000 2,000 2,000 2,004 533-49010-000-000 Interest Income 2,000 2,000 2,000 8,842 533-49015-000-000 Lease/Rental Income 218,954 218,954 215,979 218,954 SEE SCHEDULE FD-B 533-49110-000-000 Premium on Bonds Sold ---- 533-49141-000-000 Interfund Transfer In-PID Surchg 122,043 122,043 120,053 122,043 Total 1,016,458 1,016,458 1,029,208 1,031,470 Debt Service Expenses 533-70005-051-000 Paying Agent Fee 2,150 2,150 2,150 1,650 SEE SCHEDULE GF-B1 (LONG TERM DEBT) 533-70025-051-000 Bond Interest Expense-Tax 283,508 283,508 266,058 283,508 SEE SCHEDULE GF-B1 (LONG TERM DEBT) 533-70035-051-000 Bond Principal Payment-Tax 725,000 725,000 755,000 725,000 SEE SCHEDULE GF-B1 (LONG TERM DEBT) Total 1,010,658 1,010,658 1,023,208 1,010,158 Total Debt Service Fund Revenues 1,016,458 1,016,458 1,029,008 Total Debt Service Fund Expenses 1,010,658 1,010,658 1,023,208 Net Budget Surplus (Deficit)5,800 5,800 5,800 TAX DEBT SERVICE FUND (I&S) Resolution No. 2018-0917B - Exhibit "A" 7 of 25 Account FY 2018 Budget FY 2018 Amended PROPOSED FY 2019 YTD Total thru 08/31/18 Comments Debt Service Revenues 534-49010-000-000 Interest Income 1,000 1,000 1,000 3,319 534-49143-000-000 Interfund Transfer In- WW Sales 598,738 598,738 596,238 598,738 WW Sales Revenue Transfer for Revenue Debt Payment Total 599,738 599,738 597,238 602,057 Debt Service Expenses 534-70005-051-000 Paying Agent Fees 400 400 400 400 534-70040-051-000 Bond Interest Expense-Rev Bonds 223,338 223,338 215,838 223,338 See Schedule GF-B2 (Long Term Debt) 534-70045-051-000 Bond Principal Payment-Rev Bonds 375,000 375,000 380,000 375,000 See Schedule GF-B2 (Long Term Debt) Total 598,738 598,738 596,238 598,738 599,738 599,738 597,238 598,738 598,738 596,238 1,000 1,000 1,000 FY 2017 originally budgeted both Revenue Bonds together. Created separate funds 534 and 535 in FY 2017. Total Debt Service Fund Expenses Net Budget Surplus (Deficit) REVENUE DEBT SERVICE FUND (I&S) - WWTP Total Debt Service Fund Revenues Description Resolution No. 2018-0917B - Exhibit "A" 8 of 25 Account FY 2018 Budget FY 2018 Amended PROPOSED FY 2019 YTD Total thru 08/31/18 Comments Debt Service Revenues535-49010-000-000 600 600 600 1,628 535-49142-000-000 278,084 278,084 276,901 278,084 Water Sales Revenue Transfer for Revenue Debt Payment Total 278,684 278,684 277,501 279,711 Debt Service Expenses535-70005-051-000 400 400 400 400 535-70040-051-000 62,684 62,684 61,501 62,684 See Schedule GF-B2 (Long Term Debt) 535-70045-051-000 215,000 215,000 215,000 215,000 See Schedule GF-B2 (Long Term Debt) Total 278,084 278,084 276,901 278,084 278,684 278,684 277,501 278,084 278,084 276,901 600 600 600 FY 2017 originally budgeted both Revenue Bonds together. Created separate funds 534 and 535 in FY 2017. Net Budget Surplus (Deficit) Description Paying Agent Fees Bond Interest Expense-Rev Bonds Bond Principal Payment-Rev Bonds Interest Income Interfund Transfer In-Water Sales REVENUE DEBT SERVICE FUND (I&S) - SWIFT Total Debt Service Fund Revenues Total Debt Service Fund Expenses Resolution No. 2018-0917B - Exhibit "A" 9 of 25 FY 2018 Amended PROPOSED FY 2019 YTD Total thru 08/31/18 Comments Debt Service Revenues Interest Income 1,000 5,000 7,027 48,996 55,193 44,913 In Addition projected new 16in waterline 2018 Bond first year payment cost@ 77% water 123,336 125,187 113,058 In Addition projected WWTP Overrun 2018 Bond first year payment cost@ 23% wastewater Total 173,332 185,380 164,998 --- Total --- 173,332 185,380 164,998 --- 173,332 185,380 164,998 *Revenue bond covenants require 1 year debt service in reserves; usually allow 5 years from issuance date to accumulate the reserve. 173,332 - FY 2018 Budget 173,332 - - 173,332 528-49143-000-000 DEBT - RESERVE FUND Net Budget Surplus (Deficit) Interfund transfer In-Water Interfund transfer In-WW Debt Reserve Expenses Account Total Debt Service Fund Revenues Total Debt Service Fund Expenses Description 528-49010-000-000 1,000 123,336 528-49142-000-000 48,996 Resolution No. 2018-0917B - Exhibit "A" 10 of 25 FIRE TAX/ASSESSMENT RATE NET TAX VALUE:OVERALL TAX RATE FY 2019:$0.116180 Certified TARRANT COUNTY:$433,850,584 7/20/2018 DENTON COUNTY:$1,228,583,025 7/14/2018 DENTON CO. PID:$745,061,830 7/14/2018 2018 2019 OUT OF DISTRICT & PID $338,989 7/14/2018 O&M (General Fund) Tax 0.00788 0.00765 I & S (Debt Service) Tax 0.04363 0.04134 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Fire Tax 0.06870 0.06719 FIRE Vals/100 = 24,078,344 Total Tax Rate:0.120210 0.11618 FY 2019 Tax/Assess Rate =0.06719 Increase/Decrease:-0.00403 $1,617,839 Revenue from MUD Tax =1,117,000$ PID Fire Assessment Rate 0.06870 0.06719 Revenue from PID Assess =500,839$ Increase/Decrease:-0.00151 Total: 1,617,839$ MAX ROLLBACK RATE 0.11660 O&M TAX/SURCHARGE RATE NET TAX VALUE: Certified TARRANT COUNTY:433,850,584 7/20/2018 DENTON COUNTY:1,228,583,025 7/14/2018 DENTON CO. PID:745,061,830 7/14/2018 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 O&M Vals/100 = 24,074,954 184,314 *FY 2019 MUD O&M Tax Rate = 0.00765 167,800 **FY 2019 PID Tax/Surcharge Rate = 0.00697 *MUD (All of Dept. 39 Budget) **PID (Legal and Auditor only Dept 39 Budget)Revenue from MUD Tax =132,384$ Revenue from PID Surcharge =51,930$ Total: 184,314$ I&S TAX/SURCHARGE RATE NET TAX VALUE: NEW DEBT: CALCULATE AMOUNT DUE FROM PID Certified TARRANT COUNTY:$433,850,584 7/20/2018 DENTON COUNTY:$1,228,583,025 7/14/2018 DENTON CO. PID:$745,061,830 7/14/2018 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 TAX DEBT 2014 AND AFTER (I&S)Vals/100 = 24,074,954 FY 2019 PID Surcharge Rate =0.01611 *** $387,925 ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax =267,872$ Revenue from PID Surcharge =120,053$ Total: 387,925$ MUD DEBT: CALCULATE MUD TAX NET TAX VALUE: Certified TARRANT COUNTY:$433,850,584 7/20/2018 DENTON COUNTY:$1,228,583,025 7/14/2018 REQUIRED REVENUE I&S MUD DEBT TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 =16,624,336 $687,175 FY 2019 Tax Rate =0.04134 Revenue from MUD Tax =687,175$ Revenue from PID = N/A -$ Total: 687,175$ TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS TAX COMPARISON TO FY 2018 Resolution No. 2018-0917B - Exhibit "A" 11 of 25 FY Bond Payment Reimburse Reserve ($933,700)Total Rent 2019 147,883 68,096 215,979 2020 149,908 68,096 218,004 2021 151,758 68,096 219,854 2022 153,433 68,096 221,529 2023 153,433 68,096 221,529 2024 153,183 68,096 221,279 2025 152,683 68,096 220,779 2026 148,083 68,096 216,179 2027 153,368 68,096 221,464 2028 153,243 68,096 221,339 2029 152,783 68,096 220,879 2030 152,113 68,096 220,209 2031 151,163 68,096 219,259 TOTAL 1,973,034 885,248 2,858,282 RENT CALCULATION FOR FIRE STATION *Based on an average rate of 3.9% for 20 years Resolution No. 2018-0917B - Exhibit "A" 12 of 25 DEPARTMENT FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Water Line Replacement- Carnoustie\Creek $ 275,000 $ - $ - $ - $ - Valve Replacement $ 50,000 $ - $ - $ - $ - Engineer Master Plan of Improvements $ - $ - $ 50,000 $ - $ - Totals $ 325,000 $ - $ 50,000 $ - $ - Fencing $ 100,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Totals $ 100,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 On Call Truck (Water) $ 28,000 $ - $ - $ - $ - Totals $ 28,000 $ - $ - $ - $ - Water Grand Totals $ 453,000 $ 10,000 $ 60,000 $ 10,000 10,000$ LS Upgrades (Lights, Control Pannels, Quick Connects) $ 75,000 $ 50,000 $ 10,000 $ 10,000 $ 10,000 Spare Part Inventory $ 50,000 $ - $ - $ - $ - Lift Station #1 Engineering $ 30,000 $ - $ - $ - $ - In-Plant Water System $ 100,000 $ - $ - $ - $ - Smart Cover Manhole (Study and Install) $ - $ - $ 30,000 $ - $ - Engineer Master Plan of Improvements $ - $ - $ 50,000 $ - $ - Totals $ 255,000 $ 50,000 $ 90,000 $ 10,000 $ 10,000 Fencing $ - $ 5,000 $ 5,000 $ 5,000 $ 5,000 Paving Road and Driveway WWTP $ - $ 125,000 $ - $ - $ - Totals $ 130,000 $ 5,000 $ 5,000 $ 5,000 Back Up Generator (WW)75,000$ $ - $ - $ - $ - Totals $ 75,000 $ - $ - $ - $ - Wastewater Grand Totals $ 330,000 $ 180,000 $ 95,000 $ 15,000 $ 15,000 GIS Mapping Development $ 30,000 $ - $ -$ -$ - CMMS (Asset Management) Development $ 35,000 $ 10,000 $ -$ -$ - Board Room Audio and Video Improvements $ 85,000 $ - $ -$ -$ - Phase 2 WWTP Security Improvements $ 65,000 $ 20,000 $ -$ -$ - Point to Point Communication/Town Project $ 35,000 $ - $ -$ -$ - Budget Software $ 30,000 $ - $ -$ -$ - Totals $ 280,000 $ 30,000 $ -$ -$ - Building Maintenance $ - $ - $ - $ - $ - Totals $ - $ - $ - $ - $ - Administration Grand Totals $ 280,000 $ 30,000 CAPITAL OUTLAYS ADMINISTRATION Information Technology Improvements Building Maintenance Wastewater System Improvements Building Maintenance Fleet Fleet WASTEWATER WATER Water System Improvements Building Maintenance Resolution No. 2018-0917B - Exhibit "A" 13 of 25 LONG TERM TAX DEBT MUD/PID Paid Par Principal FY 19 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2010 (Tax)MUD $2,000,000 $85,000 $31,441 $31,441 $62,883 $750 $148,633 9/1/2031 9/1/2020 Trophy Club Fire Station and costs related to the issuance of the Bonds. Series 2012 (Tax)MUD $2,355,000 $225,000 $16,988 $16,988 $33,975 $500 $259,475 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Series 2013 (Tax)MUD $1,905,000 $195,000 $15,838 $15,838 $31,675 $500 $227,175 9/1/2023 9/1/2023 Refund MUD #2 Unlimited Tax Bonds Series 2003 and MUD #2 Unlimited Tax Refunding Bonds Series 2005 and costs related to the issuance of the Bonds. SUBTOTAL MUD-ONLY TAX BONDS:$6,260,000 $505,000 $64,266 $64,266 $128,533 $1,750 $635,283 Series 2014 (Tax)MUD/PID $5,765,000 $250,000 $68,763 $68,763 $137,525 $400 $387,925 9/1/2035 9/1/2024 Tax Bonds for Wastewater Plant ExpansionIssued 10/1/2014 SUBTOTAL ALL MUD/PID TAX BONDS:$5,765,000 $250,000 $68,763 $68,763 $137,525 $400 $387,925 TOTAL ALL BONDS:$12,025,000 $755,000 $133,029 $133,029 $266,058 $2,150 $1,023,208 TAX DEBT PAYMENTS Resolution No. 2018-0917B - Exhibit "A" 14 of 25 LONG TERM REVENUE DEBT Par Principal FY 19 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP $ 9,230,000 $ 380,000 $ 107,919 $ 107,919 $ 215,838 $ 400 $ 596,238 9/1/2035 9/1/2024 Revenue Bonds for WWTP Expansion SUBTOTAL REVENUE BONDS: $ 9,230,000 $ 380,000 $ 107,919 $ 107,919 $ 215,838 $ 400 $ 596,238 Series 2016 (Revenue) SWIFT $ 4,635,000 $ 215,000 $ 30,751 $ 30,751 $ 61,501 $ 400 $ 276,901 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII SUBTOTAL REVENUE BONDS: $ 4,635,000 $ 215,000 $ 30,751 $ 30,751 $ 61,501 $ 400 $ 276,901 *Series 2018 (Revenue) 16 inch Water $ 7,200,000 $ 317,130 $ - $ 82,870 $ 82,870 $ 400 $ 400,400 Revenue Bonds for 16in Water Line (77%) and Overrun for WWTP Expansion (23%) SUBTOTAL REVENUE BONDS: $ 7,200,000 $ 317,130 $ - $ 82,870 $ 82,870 $ 400 $ 400,400 TOTAL ALL BONDS: $ 21,065,000 $ 912,130 $ 138,669 $ 221,539 $ 360,209 $ 1,200 $ 1,273,539 SHORT TERM REVENUE DEBT Original PAR Outstanding Debt Principal FY 19 Interest 2/1 Interest 8/01 Subtotal Interest Total Payoff Date Project/ Reason Department Vaccon Truck (Water usage 43%) $ 154,843 $ 242,872 $ 30,068 $ 2,284 $ 1,840 $ 4,124 $ 34,193 Replacement Water Vaccon Truck (WW usage 57%) $ 205,257 $ 321,947 $ 39,858 $ 3,028 $ 2,440 $ 5,467 $ 45,325 Replacement Wastewater Camera Van $ 210,000 $ 210,000 $ 70,000 $ 4,725 $ 4,725 $ 9,450 $ 79,450 Replacement Wastewater Total: $ 570,100 $ 774,818 $ 139,927 $ 10,036 $ 9,005 $ 19,042 $ 158,968 REVENUE DEBT PAYMENTS Resolution No. 2018-0917B - Exhibit "A" 15 of 25 ANNUALIZE GROWTH IN WATER METERS: 50% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2019 : 4,740 AVG METERS AS OF COMPLETED LAST THREE FISCAL YEARS AVG WATER USE OF COMPLETED LAST THREE FISCAL YEARS ITEM NO. MONTH PROJECTED EOM AND AVERAGE ANNUAL NO. OF WATER METERS AVERAGE WATER USE PER METER FOR THE LAST 3 COMPLETE FISCAL YEARS (GALLONS) PROJECTED MONTHY WATER USE (GALLONS) 4535 100,906,333 1 OCT 4,742 22,249 105,503,890 4542 59,541,000 2 NOV 4,744 13,109 62,188,370 4559 44,636,333 3 DEC 4,746 9,792 46,469,904 4555 38,902,000 4 JAN 4,748 8,541 40,552,473 4565 42,846,000 5 FEB 4,750 9,385 44,578,015 4583 52,877,000 6 MAR 4,752 11,538 54,829,261 4596 59,388,667 7 APR 4,754 12,922 61,428,276 4612 67,059,333 8 MAY 4,756 14,540 69,150,547 4643 87,210,000 9 JUN 4,758 18,784 89,372,805 4635 119,888,667 10 JUL 4,760 25,868 123,125,257 4644 137,177,000 11 AUG 4,762 29,539 140,655,764 4641 119,590,000 12 SEP 4,764 25,768 122,753,154 4,753 16,836 960,607,716 16,836 24 404,070 Growth is slowing significantly as build out approaches .05% recommended Purchased Water (gallons):960,607,716 $2.46 $2,362,230 $44,246.97 $530,964 $10,000.00 $120,000 $25 $300 Total:$3,013,494 Service Charge Monthly PROJECTED FORT WORTH WATER COST Purchased Water Expense (Projected Fort Worth Costs) Out of District Volumetric Charge Per 1000 Gallons Rate of Use Charge Monthly Increase Monthly Rate of Use Charge- Projected True Up AVERAGE TOTAL Calculated average water use per meter per month (GALS/METER/MN) Projected total number of New retail meters in FY19 (METERS) Projected total additional gallons in FY19 (GALLONS) Resolution No. 2018-0917B - Exhibit "A" 16 of 25 Water Use History and Projections 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 1,000,000 1,100,000 2014 2015 2016 2017 2018 2019 Years Consumption in gallons 47500 49500 51500 53500 55500 57500 2014 2015 2016 2017 2018 2019 Years Total Connections by Year $- $1,000.00 $2,000.00 $3,000.00 $4,000.00 $5,000.00 $6,000.00 $7,000.00 $8,000.00 2014 2015 2016 2017 2018 2019 Years Revenue by Year 015003000 4500 6000 7500 900010500 12000 13500 15000 1650018000 2014 2015 2016 2017 2018 2019 Years Consumption per Connection by Year Resolution No. 2018-0917B - Exhibit "A" 17 of 25 (Residential Winter Average) Commercial Total Rates 20.60$ 20.60$ 0 - 4,000 3.24$ 4,001 - 8,000 4.60$ 8,001 - 12,000 6.56$ 12,000 +9.32$ Commercial 6.30$ Billing Determinants 52,968 1,278 54,246 0 - 4,000 190,040 190,040 4,001 - 8,000 100,184 100,184 8,001 - 12,000 39,464 39,464 12,000 +36,844 36,844 366,532 366,532 Commercial (000's)97,834 97,834 Projected Revenue 1,091,131$ 26,334$ 1,117,465$ Residential 0 - 4,000 615,730$ 615,730$ 4,001 - 8,000 460,846$ 460,846$ 8,001 - 12,000 258,884$ 258,884$ 12,000 +343,386$ 343,386$ 1,678,846$ -$ 1,678,846$ Commercial 616,354$ 616,354$ Total Revenue 2,769,977$ 642,688$ 3,412,665$ Revenue Requirement 3,368,106$ Over/(Under) Recovery ($)44,559$ Over/(Under) Recovery (%)1.32% Meter Charge Revenue PROJECTED WASTEWATER REVENUE Volumetric Rate All Meter Sizes Minimum Charge Volumes (000's) Annual # of Meters Resolution No. 2018-0917B - Exhibit "A" 18 of 25 WATER DEPARTMENT ITEM NUMBER OF EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 6 10 60 $ 16 $ 960 POLO SHIRTS 6 4 24 $ 20 $ 480 SWEATSHIRTS 6 5 30 $ 25 $ 750 PANTS 6 7 42 $ 25 $ 1,050 BOOTS 6 1 6 $ 175 $ 1,050 JACKET 6 1 6 $ 150 $ 900 TOTAL: $ 5,190 WASTEWATER DEPARTMENT ITEM NUMBER OF EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 7 10 70 $ 16 $ 1,120 POLO SHIRTS 7 0 0 $ 20 $ - SWEATSHIRTS 7 5 35 $ 25 $ 875 PANTS 7 7 49 $ 25 $ 1,225 BOOTS 7 1 7 $ 175 $ 1,225 JACKET 7 1 7 $ 150 $ 1,050 TOTAL: $ 5,495 ADMINISTRATION ITEM NUMBER OF EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL POLO SHIRTS 6 5 30 $ 35 $ 1,050 (DIRECTOR) SHIRTS 5 2 10 $ 35 $ 350 SWEATER 2 1 2 $ 25 $ 50 JACKETS 6 1 6 $ 100 $ 600 TOTAL: $ 2,050 UNIFORMS PROJECTIONS Resolution No. 2018-0917B - Exhibit "A" 19 of 25 Training No. to Attend Estimated Class Cost/Person Total Training Estimated Travel & Per Diem Cost Per Person Total Travel & Per Diem Total Dept. Cost Water Water Classes 6 $ 325 $ 1,950 $ 50 $ 300 CSI Class 2 $ 230 $ 460 $ 50 $ 100 CSI Renewals 2 $ 111 $ 222 $ 50 $ 100 Management Classes 1 $ 500 $ 500 $ 500 $ 500 Management Conferences 1 $ 1,000 $ 1,000 $ 400 $ 400 License Renewal 4 $ 111 $ 444 $ 100 $ 400 CDL Renewal 1 $ 75 $ 75 $ - $ - Miscellaneous Mileage/Travel (Miles)1,000 $ - $ 0.545 $ 545 4,651$ —2,345$ 6,996$ Wastewater Wastewater Classes 7 325$ 2,275$ 50$ 350$ Advanced Technology (MBR) Classes 10 325$ 3,250$ 50$ 500$ Management Classes/Conferences 1 1,000$ 1,000$ 500$ 500$ License Renewal 5 111$ 555$ -$ CDL Renewal 1 75$ 75$ -$ Miscellaneous Mileage/Travel (Miles)1,000 -$ 1$ 545$ 7,155$ —1,895$ 9,050$ Administration ADM Management Classes 2 $ 350 $ 700 $ 300 $ 600 Management Conferences 2 $ 1,000 $ 2,000 $ 500 $ 1,000 Elections Training 1 $ 350 $ 350 $ 400 $ 400 Public Funds Inv. Training 2 $ 300 $ 600 $ 100 $ 200 Govmt Accounting Conference 1 $ 500 $ 500 $ 400 $ 400 Software Training 4 $ 400 $ 1,600 $ 100 $ 400 AWWA Customer Service Workshop 0 $ 150 $ - $ 650 $ - GFOA Application and Testing 1 $ 1,000 $ 1,000 $ 400 $ 400 Customer Service Conferences 2 $ 350 $ 700 $ 200 $ 400 CPA/CFE Classes/Renewal 0 $ 1,200 $ - $ 300 $ - Webinars 10 $ 150 $ 1,500 $ - $ - Miscellaneous Mileage/Travel (Miles)1,000 $ - $ - $ 0.545 $ 545 8,950$ —4,345$ 13,295$ Totals: TRAVEL & TRAINING Totals: Totals: Resolution No. 2018-0917B - Exhibit "A" 20 of 25 COLA Total Social TWC UNEMP WORKERS WATER & DISTRIBUTION Base Pay Pay Merit OT Longevity Certification Certification Salaries Security Medicare 2.00% COMP 3.5% Pay Pay Rate & Wages 6.2% 1.45%UP TO $9000 0.0370008 Operations Manager 97,500 3,413 1823 0 0 102,735 6,370 1,490 180 3,801 Crew Leader 54,282 1,900 1523 75 900 58,604 3,633 850 180 2,168 Utility Field Worker 37,800 1,323 205 50 600 39,928 2,476 579 180 1,477 Utility Field Worker 34,320 1,201 70 25 300 35,891 2,225 520 180 1,328 Utility Field Worker 41,250 0 0 100 1200 42,450 2,632 616 180 1,571 Utility Field Worker 41,250 0 0 100 1200 42,450 2,632 616 180 1,571 Additional Cert Pay Level 50 600 600 37 9 22 Overtime Pay 20,000 20,000 1,240 290 493 DM Discretionary 3,000 3,000 186 44 111 Merit 9,517 9,517 590 138 352 WATER & DISTRIBUTION TOTAL: 309,402 7,837 9,517 20,000 3,620 4,800 355,175 22,021 5,150 1,080 12,895 COLA Total Social TWC UNEMP WORKERS WASTEWATER & COLLECTIONS Base Pay Pay Merit OT Longevity Certification Certification Salaries Security Medicare 2.00% COMP 3.5% Pay Pay Rate & Wages 6.2% 1.45%UP TO $9000 0.0370008 Wastewater Superintendent 65,000 2275 0 - - 67,275 4,171 975 180 2,489 Wastewater Shift Supervisor 60,422 2115 170 100 1,200 63,907 3,962 927 180 2,365 Crew Leader 61,830 2164 1,853 150 1,800 67,647 4,194 981 180 2,503 Utility Field Worker 55,576 1945 1,463 150 1,800 60,783 3,769 881 180 2,249 Utility Field Worker 45,710 1600 953 100 1,200 49,462 3,067 717 180 1,830 Crew Leader 60,020 2101 1,935 100 1,200 65,256 4,046 946 180 2,415 Utility Field Worker 44,115 1544 1,073 100 1,200 47,931 2,972 695 180 1,773 Additional Cert Pay Level 25 300 300 19 4 11 Overtime Pay 30,000 30,000 1,860 435 740 DM Discretionary 3,000 3,000 186 44 111 Merit 12,282 12,282 762 178 454 WASTEWATER & COLLECTION TOTAL: 395,673 13,744 12,282 30,000 7,445 8,700 467,844 29,006 6,784 1,260 16,941 COLA Total Social TWC UNEMP WORKERS ADMINISTRATION Base Pay Pay Merit OT Longevity Certification Certification Salaries Security Medicare 2.00% COMP 3.5% Pay Pay Rate & Wages 6.2% 1.45%UP TO $9000 0.002916 Finance Manager 101,000 3,535 115 0 104,650 6,488 1,517 180 305 District Secretary 84,329 2,952 720 0 88,000 5,456 1,276 180 257 Staff Accountant 52,500 0 0 0 52,500 3,255 761 180 153 Utility Billing Supv/Finance Asst. 57,150 2,000 938 0 60,088 3,725 871 180 175 Utility Billing Clerk/Receptionist 32,540 1,139 0 0 33,679 2,088 488 18098 Utility Billing Clerk/Receptionist 32,540 1,139 60 0 33,739 2,092 489 180 98 Communications Specialist 54,338 0 0 0 54,338 3,369 788 180 158 Overtime Pay 2,000 0 2,000 124 29 0 4 DM Discretionary 3,000 3,000 186 44 0 9 Merit 12,845 12,845 796 186 0 37 ADMINISTRATION TOTAL: 417,397 10,765 12,845 2,000 1,833 0 444,839 27,580 6,450 1,260 1,295 SALARY WORKSHEET Resolution No. 2018-0917B - Exhibit "A" 21 of 25 NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage$0No coverage$0No coverage$0Employee Only3$418$1,253Employee Only2$418$835Employee Only4$418$1,671Employee & Spouse0$627$0Employee & Spouse1$627$627Employee & Spouse 0$627$0Employee & Children0$800$0Employee & Children2$800$1,599Employee & Childre2$800$1,599Family3$1,021$3,064Family2$1,021$2,042Family1$1,021$1,021TOTAL6 $4,317TOTAL7$5,104TOTAL7$4,291NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage$0No coverage$0No coverage$0Employee Only3$83$249Employee Only3$83$249Employee Only5$83$415Employee & Spouse0$125$0Employee & Spouse1$125$125Employee & Spouse 0$125$0Employee & Children1$120$120Employee & Children1$120$120Employee & Childre1$120$120Family2$166$331Family2$166$331Family1$166$166TOTAL6 $701TOTAL7 $825TOTAL7 $701NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage$0No coverage$0No coverage$0Employee Only4$8,846$35,386Employee Only 2$8,846$17,693Employee Only 4$8,846$35,386Employee & Spouse0$14,028$0Employee & Spouse 1$14,028$14,028Employee & Spouse 0$14,028$0Employee & Children0$13,397$0Employee & Children 3$13,397$40,190Employee & Childre2$13,397$26,793Family2$19,716$39,432Family 1 $19,716$19,716Family 1 $19,716$19,716TOTAL6 $74,818TOTAL7 $91,627TOTAL7 $81,895 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL6$261$3,131TOTAL7$375$4,495TOTAL7$375$4,495*ALL DEPARTMENTS PROJECTED 25% INCREASE IN MEDICAL EMPLOYEE BENEFITS IS BUDGETED ADMINISTRATIONBENEFITS WORKSHEETMEDICALMEDICALWATERWASTEWATERLIFE & OTHERLIFE & OTHERDENTALVISIONVISIONDENTALLIFE & OTHERDENTALVISIONMEDICAL Resolution No. 2018-0917B - Exhibit "A"22 of 25 WATER TOTAL SALARY FY 2019 Oct-Dec TCDRS 9.25% Jan-Sept TCDRS 9.25% TCDRS FY 2019 Total Operations Manager 102,735 2,376 7,127 9,503 Crew Leader 58,604 1,355 4,066 5,421 Utility Field Worker 39,928 923 2,770 3,693 Utility Field Worker 47,314 1,094 3,282 4,377 Utility Field Worker 35,891 830 2,490 3,320 Utility Field Worker-Trainee 42,450 982 2,945 3,927 Additional Cert Pay Level 600 14 42 56 Overtime Pay 20,000 463 1,388 1,850 General Manager Discretion 3,000 69 208 278 Merit 9,517 220 660 880 TOTAL: 360,039 8,326 24,978 33,304 WASTEWATER TOTAL SALARY FY 2019 Oct-Dec TCDRS 9.25% Jan-Sept TCDRS 9.25% TCDRS FY 2019 Total Wastewater Superintendent 67,275 1,556 4,667 6,223 Wastewater Shift Supervisor 63,907 1,478 4,434 5,911 Crew Leader 67,647 1,564 4,693 6,257 Utility Field Worker 60,783 1,406 4,217 5,622 Utility Field Worker 49,462 1,144 3,431 4,575 Crew Leader 65,256 1,509 4,527 6,036 Utility Field Worker 47,931 1,108 3,325 4,434 Additional Cert Pay Level 300 7 21 28 Overtime Pay 30,000 694 2,081 2,775 General Manager Discretion 3,000 69 208 278 Merit 12,282 284 852 1,136 TOTAL: 467,844 10,819 32,457 43,276 ADMINISTRATION TOTAL SALARY FY 2019 Oct-Dec TCDRS 9.25% Jan-Sept TCDRS 9.25% TCDRS FY 2019 Total District Secretary 88,000 2,035 6,105 8,140 Finance Manager 104,650 2,420 7,260 9,680 Staff Accountant 52,500 1,214 3,642 4,856 Utility Billing Clerk/Receptionist 33,679 779 2,336 3,115 Utility Billing Clerk/Receptionist 33,739 780 2,341 3,121 Utility Billing Supervisor/Finance Asst.60,088 1,390 4,169 5,558 Communications/HR Specialist 54,338 1,257 3,770 5,026 Overtime Pay 2,000 46 139 185 General Manager Discretion 3,000 69 208 278 Merit 12,845 297 891 1,188 TOTAL: 444,839 10,287 30,861 41,148 RETIREMENT WORKSHEET Resolution No. 2018-0917B - Exhibit "A" 23 of 25 Hudson EnergyWater DepartmentFY 2019LocationKWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWHAnnual Total $Cost per KWH5% INCREASEWater Well #1, Well #380,160 $5,837 84,240 $6,023 88,080 $6,223 74,400 $5,537 62640 $4,840 60720 $4,734 56880 $3,853 49920 $3,287 49,680 $3,249 63,600 $3,795 70560 $4,219 87840 $4,897 828,720 $56,495 0.068171119 $59,320Elevated Tank-TW King590 $59 527 $54 657 $65 624 $63 582 $59 623 $64 1126 $95 1244 $98 1,446 $111 1568 $120 1017 $82 510 $45 10,514 $918 0.087281720 $964Paluxy Well #414,000 $971 12,160 $860 13,920 $956 12,240 $873 11600 $83212080 $865 13760 $800 12160 $665 12,080 $658 13,280 $705 12160 $685 12720 $704 152,160 $9,573 0.062911606 $10,051Paluxy Well #216,848 $1,163 14,644 $1,023 16,583 $1,128 14,494 $1,033 14103 $996 15102 $1,059 16557 $948 14600 $793 14,565 $779 16,121 $840 14543 $807 14933 $819 183,093 $11,389 0.062203962 $11,959Water Plant/Water Barn1,675 $199 1,657 $197 1,566 $182 1,168 $151 900 $226 1559 $323 5808 $574 5247 $543 3,423 $427 1,637 $268 1330 $249 1704 $224 27,674 $3,561 0.128672039 $3,739Water plant pump station64 $6,797 72,200 $7,281 67,600 $7,033 66,200 $7,059 54400 $5,354 47600 $4,163 37400 $3,078 32200 $2,669 29,600 $2,225 39,800 $3,444 47000 $4,100 69600 $5,901 563,664 $59,103 0.104854598 $62,058100 Municipal Dr, Unit B5200 $1,909 300 $58 7300 $2,115 200 $52 300 $58 300 $81 300 $78 300 $76 300 $79 300 $76 300 $77 300 $145 15,400 $4,804 0.311933766 $5,0442901 Bobcat Unit A, Elev Tank1880 $169 1817 $163 2063 $184 1494 $137 295 $34 102 $17 673 $59 597 $51 598 $50 650 $54 583 $50 592 $51 11,344 $1,019 0.089857193 $1,070TOTAL: $146,861$154,204Wastewater DepartmentFY 2019LocationKWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWHAnnual Total $Cost per KWH5% INCREASESewer Plant Old Meter104,367 $7,821 101,039 $7,591 110,096 $8,040 95580 $7,311 87618 $6,828 84836 $6,872 75527 $5,339 11594 $2,497 0 $58670,657 $52,355 0.078065181 $54,973New Sewer Plant Meter16400 $982 180,000 $10,682 195,800 $11,443 164600 $9,660 180200 $10,076 737,000 $42,842 0.058130801 $44,985Coll Barn for Vaccon Mtr# 114234431LG1698 $202 1800 $216 2601 $306 2842 $359 1884 $258 2759 $315 8031 $566 7726 $513 6,171 $449 4,069 $349 2905 $302 1468 $213 43,954 $4,048 0.092102653 $4,251Maintenance Barn (Town paying)310 Skyline-Lift Sta #6700 $89 600 $116 900 $417 800 $179 800 $187 900 $158 900 $139 800 $139 800 $146 800 $138 700 $127 800 $115 9,500 $1,950 0.205309474 $2,048Lift Sta #2 Guard Light70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $1170 $11 70 $11 70 $11 70 $11 840 $142 0.168928571 $149Lift Station Trophy 20228 $29 193 $26 199 $26 152 $22 153 $22 193 $25 229 $26 215 $24 215 $23 270 $27 222 $24 210 $23 2,479 $299 0.120500202 $314Lift Station #21,382 $172 1,152 $158 1,297 $187 1070 $145 1021 $152 1060 $154 1215 $158 1031 $134 1,067 $244 1,179 $139 1067 $136 1159 $139 13,700 $1,919 0.140063504 $2,015Lift Station #1900 $86 700 $69 800 $764 800 $78 700 $69 700 $70 1500 $123 1200 $94 900 $72 900 $72 700 $59 700 $59 10,500 $1,613 0.153585714 $1,693Lift Station #7228 $29 183 $25 204 $26 182 $25 178 $24 206 $26 252 $27 210 $23 199 $22 238 $25 188 $22 198 $22 2,466 $295 0.119760746 $310PID Lift Station #8282 $33 246 $30 310 $36 273 $33 261 $32 270 $32 288 $31 273 $28 294 $29 305 $30 290 $29 297 $30 3,389 $371 0.109613455 $390PID Lift Station #9800 $84 700 $74 800 $83 700 $74 500 $52 700 $70 700 $62 700 $56 500 $44 600 $51 600 $51 600 $52 7,900 $753 0.095254430 $790Lift Station #4 (new)1150 $116 950 $97 1050 $106 950 $98 950 $90 1050 $1011300 $108 1050 $83 1050 $82 1100 $86 1050 $84 1150 $91 12,800 $1,141 0.089166406 $1,198Temp Meter3329 $293 3543 $358 2592 $315 1768 $291 1748 $234 2202 $215 15,182 $1,706 0.112399552 $1,792TOTAL: $109,435$114,907Tri-County Meter #FY 2019LocationKWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWHAnnual Total $Cost per KWH5% INCREASELift Station 34867 $450 4588 $391 4561 $330 4834 $348 3443 $282 3154 $268 3120 $298 3499 $313 3317 $298 3120 $290 3327 $307 3329 $307 45,159 $3,882 0.085973782 $4,077Lift Station 5 2460 $241 2656 $237 2154 $170 1801 $146 1640 $148 1791 $164 1821 $185 2188 $206 1831 $176 1701 $170 1843 $182 $1,752 $179 23,638 $2,202 0.093169473 $2,312Lift Station 5 (Backup)28 $28 24 $28 27 $28 23 $27 28 $28 25 $28 23 $28 27 $28 23 $28 24 $28 25 $28 26 $28 303 $334 1.101023102 $350TOTAL: $6,418$6,739MP2 Energy - Electricity for Construction Trailer at WWTPFY 2019LocationKWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWHAnnual Total $Cost per KWH5% INCREASEWWTP (MP2) ESID 2219923813 $326 3684 $323 3096 $259 2516 $234 1527 $204 3219 $38217,855 $1,728 0.096784654 $1,814WWTP (Engie) ESID 22313970200 $4,338 61877.1 $4,159 74600 $4,592 76000 $4,719 83800 $5,399 130800 $7,955 149800 $8,617 134000 $8,511781,077 $48,290 0.061824694 $50,704TOTAL: $50,018$52,519Gexa Energy (Split with Town) MUD Admin 1/2 usageFY 2019LocationKWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWHAnnual Total $Cost per KWH5% INCREASEMUD & PW Bldgs12,750 $1,017 12,450 $1,006 11,580 $9566,540 $645 4,380 $506 4,770 $547 8,760 $647 10,800 $763 8,820 $746 5,430 $497 5,070 $467 $5,250 $482 96,600 $8,276 0.085676915 $8,690TOTAL: $8,276$8,690$321,009$337,059ENERGY WORKSHEETMay-18Jun-18 Jul-17 Aug-17 Sept-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Dec-17Jan-18Feb-18Mar-18Apr-18 Jul-17 Aug-17 Sept-17Oct-17Nov-17Mar-18Apr-18May-18Jun-18 Jul-17 Aug-17 Sept-17Oct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Oct-17Nov-17Dec-17Jan-18Feb-18Grand Totals for All Departments Jul-17 Aug-17 Sept-17Oct-17Nov-17May-18Jun-18Dec-17Jan-18Feb-18Mar-18Apr-18 Jul-17 Aug-17 Sept-17 Resolution No. 2018-0917B - Exhibit "A"24 of 25 Account Description Amount Totals 135-55160-030 M3- It & Cell Phone Support, includes Mobile Client 59,205$ Totals:59,205$ Description 135-55030-030 Used R For Recurring, NR For Non-Recurring. Software & Support R-Internet Connectivity- Charter Spectrum 12,000$ R-Internet Connectivity-ATT (Backup & WWTP)4,000$ R-Internet Connectivity-Pump Room at Water Plant/SCADA R- M3- Microft Office 365 Licenses 1,050$ R-E-Fax 5,750$ R- M3- Microft Office 365 Licenses 168$ R-STW-Annual Support, Annual Lease, & Report Coding 29,000$ R-Clear Rec Annual Maintenance 600$ R- Peak Agenda Management 3,465$ R-Web Hosting 500$ R-Web Maintenance (Domains, SSL Cert, etc) R-Mail Chimp 116$ R-Mail Chimp 240$ R-Photoshop 120$ R- Adobe Licenses/Support 600$ R- Timeclock Plus License and Support 1,000$ R- MCCI Annual Support Online Records 5,200$ R-Annual Support for Website-Four Man Furnace 2,000$ R-Automatic Meter Reading -Badger 2,500$ R-Pipelogix Maintenance 1,980$ R-AudioTel Remit Plus Annual Support 1,975$ R-AudioTel Annual Scanner Support 585$ R-SCADA Support (Includes Win-911)1,000$ R- Onsolve Intermediate Holding (Code Red) R- Budget Software 4,000$ R- Budget Software - NR- VMWare Software & Support (3 yrs support)- Totals:77,849$ Description 135-60005-030 R- Main Phone Numbers & Long Distance 10,500$ Telephone R- Afterhours answering service 2,500$ R- WWTP Phone Service (LS + 4 temp ofc phones)8,000$ Phone System Maintenance/Replacement 1,500$ Repairs (Non-Maintenance)1,000$ Totals:23,500$ Description 135-60235-030 R- Monitoring Service 288$ Security R-Access Control System (Cards, Fobs, Print Supplies)1,000$ Totals:1,288$ Description Qty 135-65055-030 R-A/V Miscellaneous Equipment 0 Hardware WIFI (MUD & Public)0 1,704$ Replacement Hardware: Dell Laptop 2 1,869$ 3,738$ Dell Docking Station 1 179$ 179$ Dell 22" Monitor 4 200$ 800$ Dell Monitor Stand 1 189$ 189$ Dell Desktop 2 1,000$ 2,000$ Keyboard/Mouse combo 2 79$ 158$ Printers 0 300$ Totals:7,064$ 135-65105-030 Description 2,500$ Printing Events or Special Mailers Totals:2,500$ 135-65090-030 Description Printer Supplies 3,500$ Totals 3,500$ 135-69170-030 Description Copier Rental/Lease Copier Lease 4,000$ Totals:4,000$ 172,906$ Grand Total: INFORMATION TECHNOLOGY SERVICES Professional Outside Services Resolution No. 2018-0917B - Exhibit "A" 25 of 25