Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-0802 Special Meeting Agenda Packet
BOARD OF DIRECTORS Special Meeting TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 August 2, 2017 1:00 P.M. SVORE MUNICIPAL BOARDROOM SPECIAL SESSION BUDGET WORKSHOP CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any presentations made to the Board at this time concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by the President or presiding officer. CLOSED SESSION 1. Consider and take appropriate action regarding FY 2018 draft budget. attachment: draft budget for FY 2018 ADJOURN THE STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § THIS NOTICE CERTIFIES THAT ON FRIDAY, JULY 28, 2017, BY 1:00 P.M., THE MEETING AGENDA OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS SPECIAL MEETING TO BE HELD ON WEDNESDAY, AUGUST 2, 2017 AT 1:00 P.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND NOTIFICATION WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE WATER CODE AND SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED. LAURIE SLAGHT, DISTRICT SECRETARY THIS OFFICIAL AGENDA WAS POSTED ON THE WINDOW OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADMINISTRATION BUILDING ON: DATE: _____________________________________ TIME: _______________ BY: _________________ August 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 1 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 FY 2018 BUDGET DRAFT ‐JULY 25, 2018 General Fund Fire Fund Tax Debt Service Fund Revenue Debt Service Fund WWTP Revenue Debt Service Fund SWIFT Revenue 9,491,982 Revenue 10,100 Revenue 220,954 Revenue 599,738 Revenue 278,684 FY 2018 Tax Collections 198,275 FY 2018 Tax Collections 1,054,419 FY 2018 Tax Collections 673,457 FY 2018 PID Surcharges 213,517 FY 2018 PID Assessment 486,640 PID Surcharge 122,047 Reserve Funds 0 Reserve Funds 0 Total Revenue 9,903,775 Total Revenue 1,551,159 Total Revenue 1,016,458 Total Revenue 599,738 Total Revenue 278,684 Water Expense 5,130,888 Fire Expense 1,551,159 Debt Service Expense 1,010,658 Debt Service Expense 598,738 Debt Service Expense 278,084 Wastewater Expense 2,984,647 Board of Directors Expense 12,980 Administration Expense 1,485,514 Non‐Departmental Expense 289,746 Total Expense 9,903,775 Total Expense 1,551,159 Total Expense 1,010,658 Total Expense 598,738 Total Expense 278,084 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 5,800 Net Budget Surplus/Deficit 1,000 Net Budget Surplus/Deficit 600 2018 PROPERTY VALUE SUMMARY TAX RATE SUMMARY MUD Tarrant Co.397,626,649 2017 2018 MUD Denton Co.1,137,123,525 O&M (General Fund) Tax 0.00472 0.01292 PID 708,028,353 I & S (Debt Service) Tax 0.05420 0.04363 Out of District & PID 295,974 Fire Tax 0.07222 0.06870 Total Value:2,243,074,501 Total Tax Rate:0.13114 0.12525 Increase/Decrease:‐0.00589 PID Fire Assessment Rate 0.07222 0.06870 Increase/Decrease:‐0.00352 BUDGET SUMMARY 1 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 2 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETDRAFT‐JULY 25, 2018FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 6/30/17General Fund Revenues135‐40000‐000‐000 Property Taxes57,250 60,977 60,977 198,275 60,607 99.39% SEE SCHEDULE TAX_ASSESS135‐40002‐000‐000 Property Taxes/Delinquent2,192 ‐ ‐ 200 267 0.00%135‐40015‐000‐000 Property Taxes/P & I746 650 650 200 240 36.92%135‐40025‐000‐000 PID Surcharges146,125 148,291 148,291 213,517 ‐ 0.00% SEE SCHEDULE TAX_ASSESS135‐47000‐000‐000 Water4,210,866 6,436,734 6,436,734 6,627,075 3,816,953 59.30% SEE SCHEDULE GF‐D135‐47005‐000‐000 Sewer2,359,115 2,629,524 2,629,524 2,615,024 1,841,298 70.02%SEE SCHEDULE GF‐ESTIMATED, NEWGEN STILL WORKING ON NUMBER135‐47025‐000‐000Penalties101,584 119,260 119,260 106,810 85,904 72.03% SEE SCHEDULE GF‐D135‐47030‐000‐000 Service Charges (Disconnect Fees)12,850 11,400 11,400 21,457 10,875 95.39% SEE SCHEDULE GF‐D135‐47035‐000‐000 Plumbing Inspections2,600 2,000 2,000 1,500 1,350 67.50%135‐47045‐000‐000 Sewer Inspections7,650 5,500 5,500 4,500 3,150 57.27%135‐47070‐000‐000 TCCC Effluent Charges45,511 61,188 61,188 60,000 44,507 72.74% SEE SCHEDULE GF‐E135‐48010‐000‐000 Utility Fees55,200 ‐ ‐ ‐ ‐ 0.00%135‐49010‐000‐000 Interest Income12,652 8,001 8,001 12,000 12,399 154.97% LESS INTEREST INCOME PROJECTED135‐49016‐000‐000 Cell Tower Revenue10,926 10,926 10,926 10,926 8,195 75.00% $910.53 PER MONTH135‐49018‐000‐000 Building Rent Income7,000 7,000 7,000 7,000 5,250 75.00% $583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN135‐49026‐000‐000 Proceeds from Sale of Assets30,935 2,000 2,000 2,000 ‐ 0.00%135‐49035‐000‐000 Prior Year Reserves‐ ‐ 295,408 ‐ ‐ 0.00%135‐49036‐000‐000 GASB Reserves13,088 ‐ ‐ ‐ ‐ 0.00%135‐49075‐000‐000 Oversize Meter Reimbursement51,654 21,609 21,609 18,270 16,834 77.90% SEE SCHEDULE GF‐D135‐49141‐000‐000 Interfund Transfer In8,034 ‐ ‐ ‐ ‐ 0.00%135‐49145‐000‐000 Intergov Transfer In‐ ‐ ‐ ‐ ‐ 0.00%135‐49900‐000‐000 Miscellaneous Income28,818 20,000 20,000 5,000 11,004 55.02% SCRAP SALES;UTILITY BILLING MISCELLANEOUS CHARGES135‐49901‐000‐000 Records Management Revenue44 20 20 20 32 160.00% REDUCED REVENUE135‐49903‐000‐000 Recovery of Prior Year Expense‐ ‐ ‐ ‐ ‐ 0.00%Total7,164,842 9,545,080 9,840,488 9,903,775 5,918,865 60.15%WaterGeneral Fund Expenses135‐50005‐010‐000 Salaries & Wages219,077 271,143 271,143 274,279 163,853 60.43% SEE SCHEDULE GF‐H135‐50010‐010‐000 Overtime13,385 19,500 19,500 20,000 9,098 46.66% SEE SCHEDULE GF‐H135‐50016‐010‐000 Longevity2,945 3,270 3,270 3,425 3,270 100.00% SEE SCHEDULE GF‐H135‐50017‐010‐000 Certification2,400 4,800 4,800 3,300 2,051 42.73% SEE SCHEDULE GF‐H135‐50020‐010‐000 Retirement20,866 27,151 27,151 27,843 16,169 59.55% SEE SCHEDULE GF‐J135‐50026‐010‐000 Medical Insurance38,990 55,914 55,914 52,196 22,951 41.05% SEE SCHEDULE GF‐I 135‐50027‐010‐000 Dental Insurance2,944 4,159 4,159 5,182 2,212 53.18% SEE SCHEDULE GF‐I135‐50028‐010‐000 Vision Insurance662 910 910 994 431 47.34% SEE SCHEDULE GF‐I135‐50029‐010‐000 Life Insurance & Other2,361 2,803 2,803 2,982 1,940 69.21% SEE SCHEDULE GF‐I135‐50030‐010‐000 Social Security Taxes14,627 19,021 19,021 18,662 10,793 56.74% SEE SCHEDULE GF‐H135‐50035‐010‐000 Medicare Taxes3,421 4,448 4,448 4,365 2,524 56.74% SEE SCHEDULE GF‐H135‐50040‐010‐000 Unemployment Taxes859 1,026 1,026 1,080 45 4.39% SEE SCHEDULE GF‐H135‐50045‐010‐000 Workman's Compensation12,438 13,152 13,152 11,854 8,641 65.70% TML INVOICE AMOUNT135‐50060‐010‐000 Pre‐emp Physicals/Testing236 1,300 1,300 200 ‐ 0.00%135‐50070‐010‐000 Employee Relations112 300 300 300 187 62.33%135‐55005‐010‐000 Engineering109,670 5,000 60,000 15,000 37,358 62.26%135‐55080‐010‐000 Maintenance & Repairs84,225 100,000 128,500 100,000 67,694 52.68% ADDITIONAL INFRASTRUCTURE MAINTENANCE 135‐55085‐010‐000 Generator Maintenance & Repairs‐ 3,000 3,000 3,000 1,350 45.00% MAINTENANCE & REPAIRS ON WATER GENERATOR135‐55090‐010‐000 Vehicle Maintenance6,229 8,000 8,000 4,000 1,420 17.75%135‐55105‐010‐000 Maintenance‐Heavy Equipment2,893 3,500 3,500 3,500 ‐ 0.00%135‐55135‐010‐000 Lab Analysis ‐ MUD6,389 5,500 5,500 5,500 2,791 50.75% MONTHLY BAC T; QUARTERLY TCEQ SAMPLES 135‐60010‐010‐000 Communications/Mobiles4,717 5,400 5,400 5,400 2,813 52.09% INCREASE IN COSTS135‐60020‐010‐000 Electricity150,535 172,737 172,737 175,356 106,102 61.42% SEE SCHEDULE GF‐K135‐60066‐010‐000 Publications/Books/Subscripts716 750 750 1,000 767 102.27% AWWA STANDARDS135‐60070‐010‐000 Dues & Memberships11 500 500 500 ‐ 0.00%135‐60080‐010‐000 Schools & Training1,545 4,222 4,222 2,785 590 13.97% SEE SCHEDULE GF‐G135‐60090‐010‐000 Safety Program249 400 400 400 ‐ 0.00%135‐60100‐010‐000 Travel & per diem87 1,500 1,500 1,735 124 8.27% SEE SCHEDULE GF‐G135‐60105‐010‐000 Rent/Lease Equipment379 1,500 1,500 1,500 ‐ 0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDEDCommentsGENERAL FUND Account Description% of Budget2 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 13 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETDRAFT‐JULY 25, 2018FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 6/30/17CommentsGENERAL FUND Account Description% of Budget135‐60135‐010‐000 TCEQ Fees & Permits ‐ MUD17,788 50,176 50,176 55,176 21,940 43.73% REG. ASSESSMENT ($0), WATER SYSTEM FEES ($10,000) & NTGW WELL FEES ($20,000)135‐60150‐010‐000 Wholesale Water2,030,607 2,998,802 2,998,802 2,796,753 1,273,168 42.46% SEE SCHEDULE GF‐C135‐60245‐010‐000 Miscellaneous Expenses‐ 200 200 200 103 51.50%135‐60280‐010‐000 Property Maintenance2,643 5,000 5,000 5,000 667 13.34% MORE PROPERTY REPAIRS AFTER LINE BREAKS135‐60285‐010‐000 Lawn Equipment & Maintenance‐ 14,750 14,750 14,750 3,750 25.42% MOWING $14,750135‐60332‐010‐000 Interfund Transfer Out‐ Revenue I&S‐ 297,011 297,011 278,084 197,036 66.34% SEE SCHEDULE GF‐B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS135‐60333‐010‐000 Interfund Transfer Out‐ Debt Reserve ‐ 64,920 64,920 37,613 118,022 181.80% TRANSFER FOR BOND RESERVE (REVENUE BONDS)135‐60334‐010‐000 Interfund Transfer Out‐Bank Reserve Account‐ 200,000 200,000 ‐ ‐ 0.00% TRANSFER FOR BANK RESERVE ACCOUNT135‐60360‐010‐000 Furniture/Equipment < $5000‐ 2,500 2,500 2,500 ‐ 0.00%135‐65005‐010‐000 Fuel & Lube12,647 33,011 24,829 20,000 6,292 25.34% ALL WATER TRUCKS, GAS TANK TRAILER (MISC GAS), AND GM VEHICLE135‐65010‐010‐000 Uniforms2,170 4,608 4,608 4,488 1,801 39.08% SEE SCHEDULE GF‐F135‐65030‐010‐000 Chemicals13,070 20,000 20,000 20,000 11,296 56.48% AMMONIA NEEDED FOR NEW SYSTEM135‐65035‐010‐000Small Tools868 1,200 1,200 1,200 868 72.33%135‐65040‐010‐000 Safety Equipment719 1,000 1,000 1,000 ‐ 0.00%135‐65050‐010‐000 Meter Expense88,942 115,000 31,500 50,000 17,070 54.19%135‐65053‐010‐000 Meter Change Out Program77,325 81,500 81,500 84,000 48,264 59.22% FY 18 METER REPLACEMENTS, PROFILE HEAD REPLACEMENTS 225 @$150 EACH, METER TESTING 15 @ $115 EACH135‐69005‐010‐000 Capital Outlays1,492,504 502,421 690,421 810,012 302,870 43.87% SEE SCHEDULE GF‐A135‐69008‐010‐000 Short Term Debt‐Principal130,700 ‐ ‐ ‐ ‐ 0.00% SEE SCHEDULE GF‐B135‐69009‐010‐000 Short Term Debt‐Interest1,178 ‐ ‐ ‐ ‐ 0.00% SEE SCHEDULE GF‐B135‐69195‐010‐000 Gasb34/Reserve for Replacement75,000 75,000 75,000 75,000 75,000 100.00% 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000135‐69281‐010‐000 Water Tank Inspection Contract126,958 118,774 126,957 118,774 126,958 100.00% ANNUAL MAINTENANCE CONTRACT135‐55135‐010‐001 Lab Analysis ‐ PID1,725 5,000 5,000 5,000 975 19.50% PID PORTION135‐60135‐010‐001 TCEQ Fees & Permits‐ PID‐ 5,000 5,000 5,000 ‐ 0.00% WATER SYSTEM FEES ($2.45/CONNECTION) AND OTHERSubtotal Water4,777,812 5,336,780 5,524,780 5,130,888 2,671,254 48.35%Wastewater 135‐50005‐020‐000 Salaries & Wages369,462 391,102 391,102 410,866 282,492 72.23%SEE SCHEDULE GF‐H135‐50010‐020‐000 Overtime35,175 29,500 29,500 30,000 24,432 82.82% SEE SCHEDULE GF‐H135‐50016‐020‐000 Longevity6,125 6,635 6,635 7,415 6,635 100.00% SEE SCHEDULE GF‐H135‐50017‐020‐000 Certification7,611 7,800 7,800 8,400 6,175 79.17% SEE SCHEDULE GF‐H135‐50020‐020‐000 Retirement36,694 39,584 39,584 42,243 29,025 73.33% SEE SCHEDULE GF‐J135‐50026‐020‐000 Medical Insurance66,679 73,022 73,022 62,175 41,005 56.15% SEE SCHEDULE GF‐I 135‐50027‐020‐000 Dental Insurance4,119 4,592 4,592 5,271 3,266 71.12% SEE SCHEDULE GF‐I135‐50028‐020‐000 Vision Insurance930 1,031 1,031 1,114 701 67.99% SEE SCHEDULE GF‐I135‐50029‐020‐000 Life Insurance & Other4,116 4,485 4,485 4,281 3,376 75.27% SEE SCHEDULE GF‐I135‐50030‐020‐000 Social Security Taxes23,597 27,886 27,886 28,314 18,641 66.85% SEE SCHEDULE GF‐H135‐50035‐020‐000 Medicare Taxes5,519 6,522 6,522 6,622 4,360 66.85% SEE SCHEDULE GF‐H135‐50040‐020‐000 Unemployment Taxes1,204 1,197 1,197 1,260 63 5.26% SEE SCHEDULE GF‐H135‐50045‐020‐000 Workman's Compensation7,003 11,347 11,347 17,990 12,123 106.84% TML INVOICE AMOUNT135‐50060‐020‐000 Pre‐emp Physicals/Testing238 300 300 300 80 26.67%135‐50070‐020‐000 Employee Relations722 650 650 650 392 60.31%135‐55005‐020‐000 Engineering‐ 70,000 70,000 ‐ 852 1.22%135‐55070‐020‐000 Independent Labor27,109 20,000 20,000 20,550 19,449 97.25% POTENTIAL EMERGENCY WW/COLLECTION 135‐55080‐020‐000 Maintenance & Repairs173,132 83,100 79,700 86,100 89,300 112.05%135‐55085‐020‐000 Generator Maintenance & Repairs‐ 20,000 20,000 20,000 1,566 7.83% MAINTENANCE & REPAIRS ON WW GENERATOR; 3 QUICK CONNECTS AT LIFT STATIONS $15,000135‐55090‐020‐000 Vehicle Maintenance7,165 4,000 6,600 8,000 7,585 114.92% LOWER DUE TO SPLIT OF SOME VEHICLE MAINTENANCE BETWEEN WATER & WASTEWATER135‐55105‐020‐000 Maintenance‐Heavy Equipment742 500 500 500 24 4.80%135‐55125‐020‐000 Dumpster Services41,801 55,000 55,000 60,000 41,136 74.79%135‐55135‐020‐000 Lab Analysis37,393 25,000 25,000 30,000 21,374 85.50% INCREASE FOR MORE TESTING 135‐60010‐020‐000 Communications/Pagers/Mobiles5,888 5,400 5,400 5,400 3,668 67.93%135‐60020‐020‐000 Electricity131,275 158,627 158,627 266,709 103,171 65.04% SEE SCHEDULE GF‐K (INCREASE DUE TO MBRS)135‐60066‐020‐000 Publications/Books/Subscripts‐ 400 400 200 144 36.00%135‐60070‐020‐000 Dues & Memberships300 250 267 300 267 100.00% LOWER AMOUNT OF DUES135‐60080‐020‐000 Schools & Training3,361 4,195 4,195 5,677 2,358 56.21% SEE SCHEDULE GF‐G135‐60090‐020‐000 Safety Program341 550 550 550 291 52.91%135‐60100‐020‐000 Travel & per diem977 1,600 2,400 1,635 2,287 95.29% SEE SCHEDULE GF‐G135‐60105‐020‐000 Rent/Lease Equipment8,639 9,000 9,000 9,000 ‐ 0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDED135‐60125‐020‐000 Advertising‐ ‐ ‐ 5,000 4,086 0.00%3 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 14 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETDRAFT‐JULY 25, 2018FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 6/30/17CommentsGENERAL FUND Account Description% of Budget135‐60135‐020‐000 TCEQ Fees & Permits18,527 17,150 17,150 10,000 15,152 88.35% REG. ASSESSMENT($0), ANNUAL FEE ($10,000)135‐60245‐020‐000 Miscellaneous Expenses423 450 450 450 ‐ 0.00%135‐60280‐020‐000 Property Maintenance‐ 6,622 6,622 6,622 ‐ 0.00% MAINTENANCE FOR WWTP 135‐60285‐020‐000 Lawn Equipment & Maintenance‐ 11,600 11,600 11,600 2,950 25.43% MOWING FOR LIFT STATIONS $11,100135‐60331‐020‐000 Interfund Transfer Out‐Tax I&S119,706 120,492 120,492 122,047 98,584 81.82% TRANSFER OF PID SURCHARGE135‐60332‐020‐000 Interfund Transfer Out‐ Revenue I&S444,838 595,638 595,638 598,738 487,340 81.82% SEE SCHEDULE GF‐B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS135‐60333‐020‐000 Interfund Transfer Out‐Debt Reserve123,336 123,492 123,492 134,719 67,359 54.55% TRANSFER FOR BOND RESERVE135‐60334‐020‐000 Interfund Transfer Out‐Bank Reserve Account‐ 200,000 200,000 200,000 ‐ 0.00% TRANSFER FOR BANK RESERVE ACCOUNT135‐60360‐020‐000 Furniture/Equipment < $5000‐ ‐ ‐ 4,000 ‐ 0.00%135‐65005‐020‐000 Fuel & Lube10,253 28,088 28,088 15,000 6,445 22.95% WASTEWATER TRUCKS, AND MISC FUELING (LIFT STATION GENERATORS)135‐65010‐020‐000 Uniforms4,142 4,459 4,459 4,459 3,754 84.19% SEE SCHEDULE GF‐F135‐65030‐020‐000 Chemicals28,882 25,000 21,000 27,500 17,907 85.27% INCREASE DUE TO MBR CHEMICAL CLEANING135‐65035‐020‐000 Small Tools1,787 2,000 2,000 1,000 1,406 70.30%135‐65040‐020‐000 Safety Equipment577 750 750 750 355 47.33%135‐65045‐020‐000 Lab Supplies17,349 14,000 14,000 14,000 12,806 91.47%135‐69005‐020‐000 Capital Outlays188,556 485,000 462,000 657,240 200,903 43.49% SEE SCHEDULE GF‐A135‐69008‐020‐000 Short Term Debt‐Principal21,277 ‐ ‐ ‐ ‐ 0.00% SEE SCHEDULE GF‐B135‐69009‐020‐000 Short Term Debt‐Interest197 ‐ ‐ ‐ ‐ 0.00% SEE SCHEDULE GF‐B135‐69195‐020‐000 Gasb34/Reserve for Replacement‐ ‐ ‐ 30,000 ‐ 0.00% PLANNED REPLACEMENT OF WW INFRASTRUCTURESubtotal Wastewater1,987,167 2,698,015 2,671,033 2,984,647 1,645,286 61.60%Board of Directors 0.00%135‐50005‐026‐000 Salaries & Wages9,100 ‐ ‐ ‐ ‐ 0.00%135‐50030‐026‐000 Social Security Taxes564 ‐ ‐ ‐ ‐ 0.00%135‐50035‐026‐000 Medicare Taxes132 ‐ ‐ ‐ ‐ 0.00%135‐55040‐026‐000 Unemployment Taxes2 ‐ ‐ ‐ ‐ 0.00%135‐50045‐026‐000 Workman's Compensation50 32 32 30 22 68.75% TML INVOICE AMOUNT135‐60066‐026‐000 Publications/Books/Subscripts‐ 150 150 150 ‐ 0.00%135‐60070‐026‐000 Dues & Memberships11 500 500 600 ‐ 0.00%135‐60075‐026‐000 Meetings474 1,200 1,200 1,200 ‐ 0.00%135‐60080‐026‐000 Schools & Training1,875 4,000 4,000 4,000 3,287 82.18%135‐60100‐026‐000 Travel & per diem3,314 5,000 5,000 5,000 2,447 48.94%135‐60245‐026‐000 Miscellaneous Expenses260 2,000 2,000 2,000 ‐ 0.00%Subtotal Board of Directors15,782 12,882 12,882 12,980 5,756 44.68%Administration 0.00%135‐50005‐030‐000 Salaries & Wages484,728 519,883 519,883 561,429 319,474 61.45% SEE SCHEDULE GF‐H135‐50010‐030‐000 Overtime901 1,000 2,500 1,500 3,292 131.68% SEE SCHEDULE GF‐H135‐50016‐030‐000 Longevity3,823 3,890 3,418 3,728 3,418 100.00% SEE SCHEDULE GF‐H135‐50020‐030‐000 Retirement42,642 47,768 47,768 52,416 29,476 61.71% SEE SCHEDULE GF‐H135‐50026‐030‐000 Medical Insurance61,243 84,289 84,289 63,485 34,155 40.52% SEE SCHEDULE GF‐I 135‐50027‐030‐000 Dental Insurance4,207 5,981 5,981 5,502 3,003 50.21% SEE SCHEDULE GF‐I135‐50028‐030‐000 Vision Insurance975 1,312 1,312 1,173 642 48.93% SEE SCHEDULE GF‐I135‐50029‐030‐000 Life Insurance & Other4,678 5,890 5,890 5,059 3,326 56.47% SEE SCHEDULE GF‐I135‐50030‐030‐000 Social Security Taxes28,227 32,777 32,777 35,133 19,243 58.71% SEE SCHEDULE GF‐H135‐50035‐030‐000 Medicare Taxes6,601 8,084 8,084 8,217 4,500 55.67% SEE SCHEDULE GF‐H135‐50040‐030‐000 Unemployment Taxes1,349 1,368 1,368 1,440 294 21.49% SEE SCHEDULE GF‐H135‐50045‐030‐000 Workman's Compensation2,067 1,784 1,784 1,977 1,360 76.23% TML INVOICE AMOUNT4 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 15 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETDRAFT‐JULY 25, 2018FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 6/30/17CommentsGENERAL FUND Account Description% of Budget135‐50060‐030‐000 Pre‐emp Physicals/Testing147 500 500 500 402 80.40%135‐50070‐030‐000 Employee Relations3,421 4,960 4,960 4,960 2,605 52.52%135‐55005‐030‐000 Engineering4,365 ‐ ‐ ‐ ‐ 0.00%135‐55030‐030‐000 Software & Support47,907 67,791 77,791 78,391 80,070 102.93% SEE SCHEDULE GF‐L135‐55045‐030‐000 Legal‐ ‐ ‐ 250,000 0.00%135‐55070‐030‐000 Independent Labor1,806 12,000 4,000 4,000 1,210 30.25%135‐55080‐030‐000 Maintenance & Repairs6,284 7,000 2,000 14,000 826 41.30% AC PREVENTATIVE MAINT AGREEMENT $600, BUILDING MAINT MERGED135‐55085‐030‐000 Generator Maintenance & Repairs‐ 10,000 10,000 10,000 485 4.85% MAINTENANCE & REPAIRS ON ADMIN GENERATOR135‐55100‐030‐000 Building Maint & Supplies6,890 7,000 7,000 ‐ 5,972 85.31% RECLASS TO MAINTENANCE & REPAIRS135‐55120‐030‐000 Cleaning Services7,017 10,429 8,000 10,000 4,805 60.06% CLEANING CONTRACT INCREASE135‐55160‐030‐000 Professional Outside Services69,683 63,325 60,000 63,325 57,332 95.55% M3 IT SERVICES $51,075135‐55165‐030‐000 Collection Fees‐ 200 200 200 ‐ 0.00%135‐55205‐030‐000 Utility Billing Contract8,516 8,200 8,200 9,000 5,618 68.51% COST FOR PRINTING MONTHLY STATEMENTS135‐60005‐030‐000 Telephone13,723 17,532 17,532 27,300 9,042 51.57% SEE SCHEDULE GF‐L 135‐60010‐030‐000 Communications/Mobiles4,041 4,150 3,500 3,500 2,479 70.83%135‐60020‐030‐000 Electricity7,245 12,631 12,631 16,261 7,189 56.92% SEE SCHEDULE GF‐K, 100% OF MUD/ANNEX BILL135‐60025‐030‐000 Water934 1,500 1,500 2,500 713 47.53% 100% WATER BILL135‐60035‐030‐000 Postage27,203 28,932 28,932 30,000 22,341 77.22%135‐60040‐030‐000 Bank Service Charges & Fees51,500 55,560 55,560 55,560 37,620 67.71%135‐60050‐030‐000 Bad Debt Expense3,459 3,500 3,500 3,500 527 15.06%135‐60055‐030‐000 Insurance33,573 55,692 55,692 56,000 41,873 75.19% TML INVOICE AMOUNT135‐60066‐030‐000 Publications/Books/Subscripts260 1,600 1,600 1,600 332 20.75%135‐60070‐030‐000 Dues & Memberships5,656 6,000 6,000 6,000 4,661 77.68%135‐60075‐030‐000 Meetings163 400 400 400 106 26.50%135‐60079‐030‐000 Public Education4,230 8,754 8,754 8,800 4,972 56.80% ADDITIONAL CUSTOMER EDUCATION MATERIALS, WATERFEST135‐60080‐030‐000 Schools & Training3,382 7,840 7,840 7,600 1,675 21.36% SEE SCHEDULE GF‐G135‐60100‐030‐000 Travel & per diem3,562 5,400 7,500 4,885 6,955 92.73% SEE SCHEDULE GF‐G135‐60110‐030‐000 Physicals/Testing‐ 200 200 200 ‐ 0.00%135‐60115‐030‐000 Elections3,610 7,500 7,500 7,500 2,925 39.00% MUD BOARD ELECTION135‐60125‐030‐000 Advertising1,549 7,500 7,500 7,500 1,698 22.64%135‐60235‐030‐000 Security‐ 1,350 1,350 2,700 ‐ 0.00% SEE SCHEDULE GF‐L135‐60245‐030‐000 Miscellaneous Expenses & GM Discretionary5,448 17,500 17,500 17,500 76 0.43%135‐60270‐030‐000 4th of July Celebration‐ ‐ ‐ ‐ ‐ 0.00%135‐60285‐030‐000 Lawn Equipment & Maintenance‐ ‐ ‐ ‐ ‐ 0.00%135‐60336‐030‐000 Interfund Trans Out (MUD1 I&S)‐ ‐ ‐ ‐ ‐ 0.00%135‐60360‐030‐000 Furniture/Equipment < $5000656 2,500 2,500 2,500 1,040 41.60%135‐65010‐030‐000 Uniforms23 1,855 855 875 142 16.61% SEE SCHEDULE GF‐F135‐65055‐030‐000 Hardware IT7,238 9,444 9,444 ‐ 2,300 24.35% SEE SCHEDULE GF‐L 135‐65085‐030‐000 Office Supplies5,632 9,000 9,000 9,000 4,395 48.83% ALL DEPARTMENTS COMBINED.135‐65090‐030‐000 Printer Supplies & Maintenance1,302 2,000 2,000 2,000 479 23.95% SEE SCHEDULE GF‐L135‐65095‐030‐000 Maintenance Supplies3,632 5,000 4,000 4,000 2,898 72.45%135‐65105‐030‐000 Printing3,232 4,800 2,500 4,800 2,331 93.24%135‐69005‐030‐000 Capital Outlays24,907 107,001 265,424 13,000 109,881 41.40% SEE SCHEDULE GF‐A135‐69170‐030‐000 Copier Lease Installments3,888 4,600 4,600 4,600 2,838 61.70% SEE SCHEDULE GF‐L135‐69195‐030‐000 GASB34/Reserve for Replacement‐ ‐ ‐ ‐ ‐ 0.00%Subtotal Administration1,017,525 1,295,172 1,443,019 1,485,514 852,994 59.11%Non Departmental 135‐55045‐039‐000 Legal338,721 150,000 150,000 250,000 53,391 35.59%135‐55055‐039‐000 Auditing29,039 23,860 23,860 24,500 18,809 78.83% FY 18 CONTRACT PRICE135‐55060‐039‐000 Appraisal10,088 11,115 11,115 11,446 8,667 77.98% TARRANT COUNTY $2,853; DENTON COUNTY $8,593135‐55065‐039‐000 Tax Admin Fees2,469 3,800 3,800 3,800 2,562 67.42%Subtotal Non Departmental380,317 188,775 188,775 289,746 83,429 44.19%Total General Fund Revenues7,164,842 9,545,080 9,840,488 9,903,775 5,918,865 Total General Fund Expenses8,178,601 9,531,625 9,840,488 9,903,775 5,258,721 Net Budget Surplus (Deficit)(1,013,759) 13,456 (0) (0) 660,144 5 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 16 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETADOPTED‐JULY 25, 2017AccountDescriptionFY 2015 FY 2015 FY 2016FY 2016FY2017 FY2017 FY 2018YTD TotalBudget Actual Budget Actual Budget Amend #1 Proposed thru 6/30/17Revenues‐Town122‐40001‐000‐000Assessment ‐ Emerg Svcs357,462 356,903 404,346 403,838 472,439 486,640 SEE SCHEDULE TAX_ASSESS122‐40003‐000‐000Emer Svcs Assessmen/Delinquent8,402 ‐ 346 ‐ ‐ 122‐40015‐000‐000Property Taxes/Assessments P&I750 3,337 ‐ ‐ 750 ‐ 122‐42014‐000‐000Fire Permits/Sprinkler & Plan Review6,000 8,400 5,000 5,200 5,000 100 122‐43400‐000‐000Fire Inspections950 1,575 825 1,075 825 ‐ 122‐43415‐000‐000Denton/Tarrant Cty Pledge‐Fire10,000 10,000 10,000 10,000 10,000 10,000 Revenues‐MUD122‐40001‐000‐000Assessment‐Emerg Svcs Reimb from Town‐ ‐ 112 122‐40010‐000‐000Property Taxes/MUD Fire872,859 873,241 889,963 875,978 1,035,810 1,054,419 1,029,872 SEE SCHEDULE TAX_ASSESS122‐40011‐000‐000Property Taxes/Fire‐Delinquent‐ 4,255 ‐ 18,076 ‐ ‐ 2,874 122‐40020‐000‐000Property Taxes/Fire P&I4,500 4,284 4,500 7,621 4,500 ‐ 3,542 122‐49000‐000‐000Capital Leases‐Other Financial Sources807,316 807,316 ‐ 122‐49026‐000‐000Proceeds from Sale of Assets‐ ‐ 60,000 60,000 ‐ ‐ 122‐49035‐000‐000Prior Year Reserves198,468 125,670 ‐ ‐ 122‐49036‐000‐000GASB Reserves‐ ‐ ‐ 36,182 ‐ ‐ ‐ 122‐49900‐000‐000Miscellaneous Income9,000 16,904 10,001 11,100 ‐ ‐ 149 Total Revenue2,267,305 2,220,287 1,384,635 1,429,416 1,529,324 ‐ 1,551,159 1,036,549 Expenses‐Town 122‐50005‐045‐000Salaries & Wages469,067 473,429 508,226 511,904 551,224 558,792 122‐50010‐045‐000Overtime46,745 41,589 48,735 58,952 50,237 50,122 122‐50011‐045‐000Holiday Pay14,930 14,526 15,852 14,718 ‐ ‐ 122‐50016‐045‐000Longevity5,505 5,319 5,761 5,730 5,618 5,879 122‐50017‐045‐000Certification4,800 5,129 4,200 4,740 5,400 4,950 122‐50020‐045‐000Retirement75,327 73,277 75,571 71,888 80,434 81,248 122‐50026‐045‐000Medical Insurance59,169 57,289 65,546 56,876 68,414 85,723 122‐50027‐045‐000Dental Insurance4,390 4,362 4,885 5,016 4,797 4,285 122‐50028‐045‐000Vision Insurance811 761 859 968 479 433 122‐50029‐045‐000Life Insurance & Other4,030 3,808 4,585 4,016 3,684 3,746 122‐50030‐045‐000Social Security Taxes33,421 30,862 36,132 32,993 37,974 37,565 122‐50035‐045‐000Medicare Taxes7,292 7,216 8,450 7,714 8,881 8,785 122‐50040‐045‐000Unemployment Taxes1,657 (263) 2,000 2,125 1,467 1,424 122‐50045‐045‐000Workman's Compensation8,692 7,908 9,379 9,379 9,969 10,139 122‐50060‐045‐000Pre‐employment Physicals/Test250 183 250 54 700 4,600 122‐50075‐045‐000Tuition Reimbursement300 ‐ ‐ ‐ 1,300 5,075 122‐55030‐045‐000Software & Support7,378 5,593 6,661 5,561 8,206 6,943 122‐55045‐045‐000Legal2,100 2,040 5,000 6,560 6,600 ‐ 122‐55080‐045‐000Maintenance & Repairs/Equipment14,552 15,885 25,218 54,653 21,370 17,240 122‐55085‐045‐000Generator Maintenance & Repairs‐ ‐ ‐ ‐ 2,000 ‐ 122‐55090‐045‐000Vehicle Maintenance16,000 15,493 10,000 14,808 20,000 46,000 122‐55100‐045‐000Building Maintenance‐ ‐ ‐ ‐ ‐ 16,750 122‐55160‐045‐000Professional Outside Services27,438 24,694 ‐ 2,744 ‐ 2,723 122‐60005‐045‐000Telephone75 63 50 59 50 ‐ 122‐60010‐045‐000Communications/Mobiles6,413 4,693 7,706 6,835 8,931 13,245 122‐60020‐045‐000Electricity/Gas9,026 6,343 7,412 5,686 6,673 8,140 122‐60025‐045‐000Water2,200 1,576 1,200 2,027 1,200 4,648 122‐60026‐045‐000Cable1,920 1,848 1,920 1,920 1,920 ‐ 122‐60035‐045‐000Postage100 16 50 46 50 50 122‐60066‐045‐000Publications/Books/Subscrips220 219 350 172 350 350 122‐60070‐045‐000Dues & Memberships15,689 15,633 15,582 15,457 15,582 19,295 122‐60080‐045‐000Schools & Training4,280 4,013 6,880 3,743 7,880 15,670 122‐60096‐045‐000Emergency Management1,400 1,220 1,000 1,000 1,000 1,000 122‐60100‐045‐000Travel & per diem13,577 8,691 2,081 1,147 4,081 7,066 122‐60110‐045‐000Physicals/Testing2,000 ‐ 4,700 6,804 8,085 ‐ Comments FIRE DEPARTMENT 6 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 17 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETADOPTED‐JULY 25, 2017AccountDescriptionFY 2015 FY 2015 FY 2016FY 2016FY2017 FY2017 FY 2018YTD TotalBudget Actual Budget Actual Budget Amend #1 Proposed thru 6/30/17Comments FIRE DEPARTMENT 122‐60125‐045‐000Advertising5,100 826 4,700 4,200 500 500 122‐60160‐045‐000Programs & Special Projects4,500 3,949 7,500 3,671 7,500 13,750 122‐60180‐045‐000Fire Inspection/Enforcement1,000 194 500 359 500 ‐ 122‐60195‐045‐000Flags & Repair2,000 792 3,184 2,355 3,050 3,500 122‐60243‐045‐000Prior Year Expense‐ ‐ ‐ ‐ ‐ ‐ 122‐60245‐045‐000Miscellaneous Expense1,000 729 1,001 1,119 1,000 6,000 122‐60280‐045‐000Property Maintenance‐ ‐ ‐ ‐ 12,000 ‐ 122‐65005‐045‐000Fuel8,829 5,576 15,122 4,729 21,111 13,613 122‐65010‐045‐000Uniforms3,000 2,408 3,640 9,516 3,140 6,687 122‐65015‐045‐000Protective Clothing35,200 27,703 9,000 47,907 28,000 30,200 122‐65030‐045‐000Chemicals200 134 600 1,191 1,500 ‐ 122‐65035‐045‐000Small Tools/Equipment2,500 1,446 2,000 1,868 6,000 5,000 122‐65055‐045‐000Hardware 9,000 6,161 750 394 750 1,100 122‐65085‐045‐000Office Supplies500 230 500 328 500 250 122‐65095‐045‐000Maintenance & Supplies‐ ‐ ‐ ‐ ‐ 1,500 122‐65105‐045‐000Printing548 38 498 ‐ 498 250 122‐00000‐045‐000Printer Supplies‐ ‐ ‐ ‐ ‐ 1,400 122‐69050‐045‐000Radios23,500 23,491 8,000 7,934 29,000 ‐ 122‐69255‐045‐000Airpacks10,400 10,235 ‐ ‐ 11,050 ‐ Expenses‐MUD 122‐55080‐045‐000Maintenance & Repairs (GASB34)‐ ‐ ‐ 10,754 122‐60030‐045‐000Rent And/Or Usage 211,829 211,829 214,379 214,379 216,754 218,954 216,754 SEE SCHEDULE FD‐B122‐60055‐045‐000Insurance12,179 11,281 18,451 9,072 16,513 18,000 12,385 TML INVOICE 122‐60337‐045‐000Transfer to Town/Fire Budget‐ ‐ ‐ 434,711 122‐69005‐045‐000Capital Outlays1,057,316 1,057,316 ‐ 7,918 16,836 ‐ ‐ 122‐69008‐045‐000Short Term Debt ‐Principal‐ ‐ ‐ ‐ ‐ ‐ ‐ 122‐69009‐045‐000Short Term Debt ‐Interest‐ ‐ ‐ ‐ ‐ ‐ ‐ 122‐69195‐045‐000GASB34/Reserve for Replacement17,950 17,950 81,420 81,420 81,420 81,420 81,420 ANNUAL RESERVE FOR NEW FIRE ENGINE122‐69305‐045‐000Capital Leases‐ ‐ 127,149 127,149 127,149 127,149 127,149 LEASE PAYMENT NO. 3 OF 7 FOR LADDER TRUCKTotal2,267,305 2,215,703 1,441,804 1,441,804 1,529,327 ‐ 1,551,159 883,173 Total Fire Revenues2,267,305 2,220,287 1,384,635 1,429,416 1,529,324 ‐ 1,551,159 Total Fire Expenses2,267,305 2,215,703 1,441,804 1,441,804 1,529,324 ‐ 1,551,159 Net Budget Surplus (Deficit)‐ 4,584 (57,169) (12,388) ‐ ‐ ‐ Fire Budget1,551,159 Less: Rent/Debt Service218,954 Less: Capital Leases127,149 Less: ESD Assessment486,640 TML Fire Insurance18,000 Less Capital Outlays‐ Less GASB34/Reserve for Replacement81,420 Less Denton County Fire Pledge10,000 Less Fire Permits/Sprinkler100 Less Fire Inspections‐ 122‐60337‐045‐000Transfer to Town from MUD/Fire Budget608,896 Monthly payment to Town Oct 17‐Sept 1850,741 Town/MUD Fire Contract Calculation FY 2018 7 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 18 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017TAccount Description Original Amend #1 PROPOSED YTD TotalBudget Budget FY 2018 thru 6/30/17CommentsDebt Service Revenues533‐40000‐000‐000 Property Taxes673,336 673,336 669,657 669,587 SEE SCHEDULE TAX_ASSESS533‐40002‐000‐000 Property Taxes/Delinquent3,501 3,501 1,800 1,695 533‐40015‐000‐000 Property Taxes/P & I2,000 2,000 2,000 1,833 533‐49010‐000‐000 Interest Income140 140 2,000 2,245 533‐49015‐000‐000 Lease/Rental Income216,754 216,754 218,954 216,754 SEE SCHEDULE FD‐B 533‐49110‐000‐000 Premium on Bonds Sold‐ ‐ ‐ ‐ 533‐49141‐000‐000 Interfund Transfer In‐PID Surchg120,492 120,492 122,047 98,584 Total1,016,223 1,016,223 1,016,458 990,698 Debt Service Expenses533‐70005‐051‐000 Paying Agent Fee2,550 2,550 2,150 1,250 SEE SCHEDULE GF‐B1 (LONG TERM DEBT)533‐70025‐051‐000Bond Interest Expense‐Tax300,583 300,583 283,508 150,491 SEE SCHEDULE GF‐B1 (LONG TERM DEBT)533‐70035‐051‐000 Bond Principal Payment‐Tax710,000 710,000 725,000 ‐ SEE SCHEDULE GF‐B1 (LONG TERM DEBT)Total1,013,133 1,013,133 1,010,658 151,741 Total Debt Service Fund Revenues1,016,223 1,016,223 1,016,458 Total Debt Service Fund Expenses1,013,133 1,013,133 1,010,658 Net Budget Surplus (Deficit)3,090 3,090 5,800 TAX DEBT SERVICE FUND (I&S)8 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 19 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017FY 2017 FY 2017 PROPOSED YTD TotalBudget Amended FY 2018 thru 6/30/17Debt Service Revenues534‐49010‐000‐000 Interest Income200 200 1,000 881 534‐49143‐000‐000 Interfund Transfer In‐ WW Sales595,638 595,638 598,738 487,340 WW Sales Revenue Transfer for Revenue Debt PaymentTotal595,838 595,838 599,738 488,221 Debt Service Expenses534‐70005‐051‐000 Paying Agent Fees‐ ‐ 400 ‐ 534‐70040‐051‐000Bond Interest Expense‐Rev Bonds387,649 387,649 223,338 115,519 See Schedule GF‐B2 (Long Term Debt)534‐70045‐051‐000 Bond Principal Payment‐Rev Bonds505,000 505,000 375,000 ‐ See Schedule GF‐B2 (Long Term Debt)Total892,649 892,649 598,738 115,519 Total Debt Service Fund Revenues595,838 595,838 599,738 Total Debt Service Fund Expenses892,649 892,649 598,738 Net Budget Surplus (Deficit)(296,811) (296,811) 1,000 REVENUE DEBT SERVICE FUND (I&S) ‐ WWTPAccountDescriptionComments9 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 110 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017FY 2017 FY 2017PROPOSEDYTD TotalBudget AmendedFY 2018thru 6/30/17Debt Service Revenues535‐49010‐000‐000 Interest Income200 200 600 441 535‐49142‐000‐000 Interfund Transfer In‐Water Sales297,011 297,011 278,084 197,036 Water Sales Revenue Transfer for Revenue Debt PaymenTotal297,211 297,211 278,684 197,477 Debt Service Expenses535‐70005‐051‐000 Paying Agent Fees‐ ‐ 400 ‐ 535‐70040‐051‐000 Bond Interest Expense‐Rev Bonds387,649 387,649 62,684 ‐ See Schedule GF‐B2 (Long Term Debt)535‐70045‐051‐000 Bond Principal Payment‐Rev Bonds505,000 505,000 215,000 ‐ See Schedule GF‐B2 (Long Term Debt)Total892,649 892,649 278,084 ‐ Total Debt Service Fund Revenues297,211 297,211 278,684 Total Debt Service Fund Expenses892,649 892,649 278,084 Net Budget Surplus (Deficit)(595,438) (595,438) 600 REVENUE DEBT SERVICE FUND (I&S) ‐ SWIFCommentsAccount Description10 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 111 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 21, 2017AccountDescriptionOriginal Amend #1 PROPOSED YTD TotalBudget Budget FY 2018 thru 6/30/17CommentsDebt Reserve Revenues528‐49010‐000‐000 Interest Income300 300 1,000 778 528‐49142‐000‐000 Interfund transfer In‐Water64,920 64,920 37,613 118,022 528‐49143‐000‐000 Interfund transfer In‐WW123,492 123,492 134,719 67,359 Total188,712 188,712 173,332 186,159 Debt Reserve ExpensesTotal‐ ‐ ‐ ‐ *Revenue bond covenants require 1 year debt service in reserves; usually allow 5 years from issuance date to accumulate the reserve.Total Debt Service Fund Revenues188,712 188,712 173,332 186,159 Total Debt Service Fund Expenses‐ ‐ ‐ ‐ Net Budget Surplus (Deficit)188,712 188,712 173,332 186,159 DEBT ‐ RESERVE FUND*11 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 112 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1FY 2018 BUDGETDRAFT‐JULY 25, 2018FIRE TAX/ASSESSMENT RATEOVERALL TAX RATE FY 2018:$0.12525NET TAX VALUE:TARRANT COUNTY: 397,626,64942,941 CertifiedDENTON COUNTY: 1,137,123,52542,934CertifiedDENTON CO. PID: 708,028,35342,934CertifiedOUT OF DISTRICT & PID 295,97442,934CertifiedREQUIRED REVENUETAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100FIREVals/100 = 22,430,745FY 2018 Tax/Assess Rate =0.068701,541,059TAX COMPARISON TO FY 2017Revenue from MUD Tax =1,054,419$ 2017 2018Revenue from PID Assess = 486,640$ O&M (General Fund) Tax 0.00438 0.01292Total: 1,541,059$ I & S (Debt Service) Tax 0.04839 0.04363Fire Tax 0.07445 0.06870Total Tax Rate:0.12722 0.12525O&M TAX/SURCHARGE RATENET TAX VALUE:Increase/Decrease: -0.00197397,626,649 TARRANT COUNTY: 1,137,123,525 PID Fire Assessment Rate0.07445 0.06870DENTON COUNTY: 708,028,353 Increase/Decrease: -0.00575DENTON CO. PID:TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100REQUIRED REVENUEVals/100 =22,427,785O&MFY 2018 Tax/Surcharge Rate =0.01292289,746Revenue from MUD Tax =198,275$ Revenue from PID Surcharge =91,471$ Total: 289,746$ I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PIDNET TAX VALUE:397,626,649 TARRANT COUNTY: 1,137,123,525 DENTON COUNTY: 708,028,353 DENTON CO. PID:TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100REQUIRED REVENUEVals/100 =22,427,785TAX DEBT 2014 AND AFTER (I&S)FY 2018 PID Surcharge Rate = 0.01723755NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE$386,600Revenue from MUD Tax = 264,553$ Revenue from PID Surcharge =122,047$ Total: 386,600$ MUD DEBT: CALCULATE MUD TAXNET TAX VALUE:397,626,649 TARRANT COUNTY: 1,137,123,525 DENTON COUNTY:TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100REQUIRED REVENUEVals/100 =15,347,502I&S MUD DEBTFY 2018 Tax Rate =0.04363 Revenue from MUD Tax =669,657$ $669,657Revenue from PID = N/A Total: 669,657$ SCHEDULE TAX_ASSESSTAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONS12 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 113 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017FYBond Payment Reimburse Reserve ($933,700)*Total Rent2018150,85868,096218,9542019147,88368,096215,9792020149,90868,096218,0042021151,75868,096219,8542022153,43368,096221,5292023153,43368,096221,5292024153,18368,096221,2792025152,68368,096220,7792026148,08368,096216,1792027153,36868,096221,4642028153,24368,096221,3392029152,78368,096220,8792030152,11368,096220,2092031151,16368,096219,259Total2,123,892953,3443,077,236*Based on ave. rate of 3.9% for 20 yearsSCHEDULE FD‐B RENT CALCULATION FOR FIRE STATION13 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 114 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017 WATER ‐ PURCHASESWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ PURCHASESDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTBEACON METER SOFTWAR11,012 INDIAN CREEK AND PHOENIX (TOWN410,000 AGENDA SOFTWARE13,000SUNDANCE CT/MEADOWBROOK LN (TOWN169,000PORTLAND DRIVE (MUD)70,000SCADA PANEL WATER PLANT & ELEVATED TANK EAS50,000 PUMP DISCHARGE HEAD50,000 VALVE REPLACEMENTS50,000 Total: $11,012 Total: $799,000 Total: $13,000WASTEWATER ‐ PURCHASESWASTEWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ MAINTENANCE & REPAIRSDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTON CALL TRUCK ‐ 4 WHEEL DRIVE27,515 LIFT STATION 1 RELOCATION‐ENGINEERING (ESTIMA70,000WW SUPERINTENDENT TRUCK ‐ 4 WHEEL DRI 34,500 STUDY7,100SMART COVER MANHOLES (10), STUDY & INS50,000VAC‐CON TRUCK 1/2391,025 Total: $503,040 Total: $77,100 Total: $0SCHEDULE GF ‐ AFY 2018 CAPITAL OUTLAYS14 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 115 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017 LONG TERM TAX DEBTMUD/PID PaidPar Principal FY 18 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee TotalMaturity DateFirst Callable DateProject/ReasonSeries 2010 (Tax)MUD$2,000,000 $85,000 $32,929 $32,929 $65,858$750 $151,6089/1/20319/1/2020Trophy Club Fire Station and costs related to the issuance of the Bonds.Series 2012 (Tax)MUD$2,355,000 $210,000 $19,613 $19,613 $39,225$500 $249,7259/1/20239/1/2020Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds.Series 2013 (Tax)MUD$1,905,000 $185,000 $18,613 $18,613 $37,225$500 $222,7259/1/20239/1/2023Refund 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 $480,000$71,154 $71,154 $142,308$1,750 $624,058Series 2014 (Tax) MUD/PID $5,765,000 $245,000 $70,600 $70,600 $141,200$400 $386,6009/1/20359/1/2024Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014SUBTOTAL ALL MUD/PID TAX BONDS:$5,765,000 $245,000 $70,600 $70,600 $141,200$400 $386,600TOTAL ALL BONDS:$12,025,000 $725,000 $141,754 $141,754 $283,508$2,150 $1,010,658SCHEDULE GF ‐ B1TAX DEBT PAYMENTS15 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 116 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017LONG TERM REVENUE DEBTMUD/PID PaidPar Principal FY 18 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee TotalMaturity DateFirst Callable DateProject/ReasonSeries 2015 (Revenue) WWTP $9,230,000 $375,000 $111,669 $111,669 $223,338$400 $598,7389/1/20359/1/2024Revenue Bonds for WWTP ExpansionSUBTOTAL REVENUE BONDS:$9,230,000 $375,000 $111,669 $111,669 $223,338$400 $598,738Series 2016 (Revenue) SWIFT$4,635,000 $215,000 $31,342 $31,342 $62,684$400 $278,084Revenue Bonds for Fort Worth Line Phase 2SUBTOTAL REVENUE BONDS:$4,635,000 $215,000 $31,342 $31,342 $62,684$400 $278,084 TOTAL ALL BONDS:$13,865,000 $590,000 $143,011 $143,011 $286,022$800 $876,822 SHORT TERM REVENUE DEBTOriginal PAR Outstanding Debt Principle FY 17 Interest 3/01 Interest 9/01 Subtotal InterestTotalPayoff DateProject/ReasonDepartmentTotal:$0$0$0$0$0$0$0 SCHEDULE GF ‐ B2REVENUE DEBT PAYMENTS16 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 117 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017 ANNUALIZE GROWTH IN WATER METERS =1.00%PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2016 =4,644 4376 100,272,333 OCT 4,648 22,912 106,493,8924386 50,924,333 1 NOV 4,652 11,611 54,009,7864404 41,774,667 2 DEC 4,656 9,485 44,158,0934413 39,183,333 3 JAN 4,659 8,880 41,375,1444428 41,660,333 4 FEB 4,663 9,409 43,878,2044451 45,383,667 5 MAR 4,667 10,197 47,592,3654466 61,529,333 6 APR 4,671 13,778 64,360,6544483 58,334,667 7 MAY 4,675 13,011 60,829,1844511 80,872,333 8 JUN 4,679 17,926 83,877,0454506 112,761,333 9 JUL 4,683 25,027 117,195,5094533 134,295,333 10 AUG 4,687 29,628 138,860,5004522 117,311,667 11 SEP 4,691 25,942 121,686,947AVERAGE4,66916,484TOTAL924,317,322CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)16,484PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY18 =(METERS)47Growth Rate Meters set May 2016 through April 2017:4 per monthGrowth Rate = Ave. New Meters Set/Total Meters at Apr 2017(4*12)/4644*100%=1.03%1% recommendedPurchased Water (gallons):924,317,322Increases$2.37$2,190,7242.02%$50,477.37$605,7283.90%$25$300 Total: $2,796,753 Out of District Volumetric Charge Per 1000 Gallons Rate of Use Charge Monthly Service Charge MonthlySCHEDULE GF‐C PROJECTED WATER USEPROJECTED FORT WORTH WATER COSTPurchased Water Expense (Projected Fort Worth Costs)Growth is slowing significantly as build out approachesITEM NO. MONTHPROJECTED EOM AND AVERAGE ANNUAL NO. OF WATER METERSAVERAGE WATER USE PER METER FOR THE LAST 3 YEARS (GALLONS)PROJECTED MONTHY WATER USE (GALLONS)METERS FOR LAST THREE YEARS COMBINEDWATER USE FOR LAST THREE YEARS COMBINED17 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 118 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017FY 2014Beginning End Block Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block‐ 1,000 1,000 213 73,000 4,054,000 4.22%310 129,000 4,029,000 6.72%390 182,000 4,014,000 7.96%342 133,000 4,036,000 11.16%359 147,000 4,049,000 10.37%294 131,000 4,127,000 13.27%260 103,000 4,146,000 7.52%233 104,000 4,202,000 10.18%184 66,000 4,236,000 6.42%170 62,000 4,232,000 4.07%170 56,000 4,279,000 3.02%172 64,000 4,259,000 3.35%3,097 1,250,000 49,663,000 5.86%1,000 2,000 1,000 104 208,000 3,981,000 4.14%230 460,000 3,900,000 6.51%318 636,000 3,832,000 7.60%224 448,000 3,903,000 10.79%265 530,000 3,902,000 10.00%183 366,000 3,996,000 12.85%166 332,000 4,043,000 7.33%105 210,000 4,098,000 9.92%85 170,000 4,170,000 6.32%91 182,000 4,170,000 4.01%56 112,000 4,223,000 2.98%56 112,000 4,195,000 3.30%1,883 3,766,000 48,413,000 5.71%2,000 3,000 1,000 140 420,000 3,877,000 4.04%344 1,032,000 3,670,000 6.12%501 1,503,000 3,514,000 6.97%365 1,095,000 3,679,000 10.17%435 1,305,000 3,637,000 9.32%307 921,000 3,813,000 12.26%236 708,000 3,877,000 7.03%138 414,000 3,993,000 9.67%85 255,000 4,085,000 6.19%113 339,000 4,079,000 3.92%72 216,000 4,167,000 2.94%64 192,000 4,139,000 3.25%2,800 8,400,000 46,530,000 5.49%3,000 4,000 1,000 137 548,000 3,737,000 3.89%439 1,756,000 3,326,000 5.55%586 2,344,000 3,013,000 5.97%515 2,060,000 3,314,000 9.16%483 1,932,000 3,202,000 8.20%354 1,416,000 3,506,000 11.27%284 1,136,000 3,641,000 6.60%154 616,000 3,855,000 9.34%116 464,000 4,000,000 6.06%122 488,000 3,966,000 3.82%85 340,000 4,095,000 2.89%80 320,000 4,075,000 3.20%3,355 13,420,000 43,730,000 5.16%4,000 5,000 1,000 171 855,000 3,600,000 3.75%391 1,955,000 2,887,000 4.82%532 2,660,000 2,427,000 4.81%495 2,475,000 2,799,000 7.74%500 2,500,000 2,719,000 6.97%402 2,010,000 3,152,000 10.14%258 1,290,000 3,357,000 6.09%155 775,000 3,701,000 8.96%110 550,000 3,884,000 5.88%126 630,000 3,844,000 3.70%92 460,000 4,010,000 2.83%102 510,000 3,995,000 3.14%3,334 16,670,000 40,375,000 4.76%5,000 6,000 1,000 178 1,068,000 3,429,000 3.57%348 2,088,000 2,496,000 4.16%443 2,658,000 1,895,000 3.76%467 2,802,000 2,304,000 6.37%468 2,808,000 2,219,000 5.68%357 2,142,000 2,750,000 8.84%288 1,728,000 3,099,000 5.62%182 1,092,000 3,546,000 8.59%105 630,000 3,774,000 5.72%140 840,000 3,718,000 3.58%100 600,000 3,918,000 2.76%71 426,000 3,893,000 3.06%3,147 18,882,000 37,041,000 4.37%6,000 7,000 1,000 199 1,393,000 3,251,000 3.38%303 2,121,000 2,148,000 3.58%314 2,198,000 1,452,000 2.88%384 2,688,000 1,837,000 5.08%318 2,226,000 1,751,000 4.49%283 1,981,000 2,393,000 7.70%276 1,932,000 2,811,000 5.10%169 1,183,000 3,364,000 8.15%115 805,000 3,669,000 5.56%142 994,000 3,578,000 3.44%102 714,000 3,818,000 2.69%108 756,000 3,822,000 3.00%2,713 18,991,000 33,894,000 4.00%7,000 8,000 1,000 166 1,328,000 3,052,000 3.18%226 1,808,000 1,845,000 3.08%244 1,952,000 1,138,000 2.26%303 2,424,000 1,453,000 4.02%273 2,184,000 1,433,000 3.67%288 2,304,000 2,110,000 6.79%207 1,656,000 2,535,000 4.60%169 1,352,000 3,195,000 7.74%128 1,024,000 3,554,000 5.38%144 1,152,000 3,436,000 3.31%87 696,000 3,716,000 2.62%95 760,000 3,714,000 2.92%2,330 18,640,000 31,181,000 3.68%8,000 9,000 1,000 156 1,404,000 2,886,000 3.00%180 1,620,000 1,619,000 2.70%156 1,404,000 894,000 1.77%225 2,025,000 1,150,000 3.18%198 1,782,000 1,160,000 2.97%237 2,133,000 1,822,000 5.86%209 1,881,000 2,328,000 4.22%179 1,611,000 3,026,000 7.33%128 1,152,000 3,426,000 5.19%162 1,458,000 3,292,000 3.17%108 972,000 3,629,000 2.56%116 1,044,000 3,619,000 2.85%2,054 18,486,000 28,851,000 3.40%9,000 14,000 5,000 803 9,598,000 12,006,000 12.50%662 7,768,000 5,695,000 9.50%435 4,983,000 2,583,000 5.12%562 6,467,000 3,224,000 8.92%598 6,845,000 3,283,000 8.41%776 9,053,000 6,114,000 19.66%793 9,496,000 8,989,000 16.30%935 11,132,000 12,277,000 29.73%775 9,341,000 14,981,000 22.70%869 10,428,000 13,912,000 13.39%685 8,295,000 16,310,000 11.50%731 8,838,000 16,119,000 12.67%8,624 102,244,000 115,493,000 13.62%14,000 17,000 3,000 425 6,806,000 5,362,000 5.58%237 3,785,000 2,087,000 3.48%90 1,431,000 810,000 1.61%123 1,960,000 958,000 2.65%116 1,834,000 954,000 2.44%236 3,765,000 2,180,000 7.01%346 5,532,000 3,628,000 6.58%491 7,827,000 5,216,000 12.63%519 8,314,000 7,060,000 10.70%514 8,191,000 6,236,000 6.00%468 7,531,000 8,083,000 5.70%488 7,837,000 7,857,000 6.18%4,053 64,813,000 50,431,000 5.95%17,000 20,000 3,000 356 6,701,000 4,087,000 4.25%167 3,173,000 1,453,000 2.42%47 887,000 586,000 1.16%56 1,054,000 654,000 1.81%67 1,271,000 675,000 1.73%178 3,351,000 1,510,000 4.86%255 4,842,000 2,682,000 4.86%383 7,244,000 3,847,000 9.32%441 8,371,000 5,563,000 8.43%431 8,138,000 4,759,000 4.58%422 7,989,000 6,653,000 4.69%491 9,323,000 6,355,000 5.00%3,294 62,344,000 38,824,000 4.58%20,000 25,000 5,000 411 9,325,000 4,780,000 4.98%136 3,098,000 1,563,000 2.61%52 1,178,000 708,000 1.40%52 1,181,000 801,000 2.22%59 1,337,000 767,000 1.97%141 3,193,000 1,643,000 5.28%269 6,123,000 3,023,000 5.48%376 8,571,000 4,361,000 10.56%527 12,044,000 6,684,000 10.13%482 11,065,000 5,595,000 5.38%638 14,570,000 8,350,000 5.89%584 13,295,000 7,660,000 6.02%3,727 84,980,000 45,935,000 5.42%25,000 29,000 4,000 220 6,024,000 2,584,000 2.69%66 1,802,000 836,000 1.39%16 437,000 429,000 0.85%27 734,000 479,000 1.32%32 865,000 425,000 1.09%70 1,916,000 902,000 2.90%140 3,825,000 1,589,000 2.88%225 6,139,000 2,262,000 5.48%307 8,415,000 3,656,000 5.54%228 6,225,000 2,949,000 2.84%358 9,828,000 4,678,000 3.30%323 8,842,000 4,311,000 3.39%2,012 55,052,000 25,100,000 2.96%29,000 34,000 5,000 183 5,841,000 2,194,000 2.28%43 1,373,000 766,000 1.28%17 545,000 457,000 0.91%22 706,000 483,000 1.34%13 411,000 419,000 1.07%50 1,570,000 790,000 2.54%107 3,420,000 1,362,000 2.47%145 4,592,000 1,847,000 4.47%231 7,363,000 3,154,000 4.78%202 6,433,000 2,595,000 2.50%288 9,160,000 4,118,000 2.90%273 8,706,000 3,854,000 3.03%1,574 50,120,000 22,039,000 2.60%34,000 39,000 5,000 85 3,111,000 1,456,000 1.52%19 691,000 590,000 0.98%11 412,000 388,000 0.77%10 374,000 399,000 1.10%13 483,000 361,000 0.92%15 552,000 637,000 2.05%50 1,844,000 939,000 1.70%89 3,272,000 1,261,000 3.05%147 5,427,000 2,184,000 3.31%124 4,576,000 1,760,000 1.69%199 7,298,000 2,847,000 2.01%170 6,214,000 2,649,000 2.08%932 34,254,000 15,471,000 1.82%39,000 44,000 5,000 63 2,632,000 1,095,000 1.14%16 676,000 517,000 0.86%10 422,000 332,000 0.66%8 332,000 345,000 0.95%7 289,000 301,000 0.77%14 591,000 570,000 1.83%24 1,007,000 746,000 1.35%44 1,816,000 895,000 2.17%94 3,925,000 1,544,000 2.34%84 3,532,000 1,236,000 1.19%127 5,319,000 2,046,000 1.44%109 4,569,000 1,988,000 1.56%600 25,110,000 11,615,000 1.37%44,000 50,000 6,000 38 1,800,000 1,004,000 1.04%12 556,000 514,000 0.86%9 421,000 331,000 0.66%7 331,000 371,000 1.03%6 276,000 318,000 0.81%9 420,000 600,000 1.93%21 995,000 755,000 1.37%38 1,796,000 850,000 2.06%62 2,944,000 1,386,000 2.10%43 2,013,000 1,039,000 1.00%82 3,859,000 1,775,000 1.25%103 4,871,000 1,725,000 1.36%430 20,282,000 10,668,000 1.26%50,000 59,000 9,000 24 1,307,000 1,205,000 1.25%9 479,000 677,000 1.13%7 383,000 429,000 0.85%8 430,000 480,000 1.33%4 209,000 432,000 1.11%21 1,143,000 768,000 2.47%21 1,153,000 940,000 1.70%20 1,090,000 999,000 2.42%59 3,193,000 1,467,000 2.22%33 1,802,000 1,232,000 1.19%79 4,290,000 1,915,000 1.35%61 3,319,000 1,799,000 1.41%346 18,798,000 12,343,000 1.46%59,000 69,000 10,000 23 1,481,000 1,114,000 1.16%14 888,000 642,000 1.07%4 256,000 420,000 0.83%9 584,000 463,000 1.28%9 575,000 424,000 1.09%14 901,000 685,000 2.20%13 825,000 858,000 1.56%18 1,162,000 930,000 2.25%30 1,936,000 1,226,000 1.86%17 1,089,000 1,116,000 1.07%51 3,299,000 1,530,000 1.08%38 2,428,000 1,506,000 1.18%240 15,424,000 10,914,000 1.29%69,000 +99 21,516,000 14,685,000 15.28%58 12,190,000 8,188,000 13.66%40 7,665,000 4,905,000 9.73%41 10,336,000 7,507,000 20.76%38 10,020,000 7,398,000 18.95%61 13,757,000 9,548,000 30.70%80 17,312,000 11,792,000 21.39%83 19,626,000 13,899,000 33.66%106 24,649,000 17,335,000 26.27%103 25,623,000 18,516,000 17.82%124 30,686,000 22,130,000 15.60%132 31,605,000 22,497,000 17.69%965 224,985,000 158,400,000 18.68%4,194 83,439,000 83,439,000 86.84% 4,210 49,448,000 49,448,000 82.49% 4,222 34,557,000 34,557,000 68.52% 4,245 40,639,000 40,639,000 112.39% 4,261 39,829,000 39,829,000 102.04% 4,290 53,616,000 53,616,000 172.42% 4,303 67,140,000 67,140,000 121.77% 4,331 81,624,000 81,624,000 197.68% 4,354 101,038,000 101,038,000 153.09% 4,340 95,260,000 95,260,000 91.66% 4,393 116,290,000 116,290,000 81.98% 4,367 114,031,000 114,031,000 89.65% 51,510 876,911,000 876,911,000 103.39%FY 2015Beginning End Block Number of Consumption% ConsumptionNumber of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block‐ 1,000 1,000 147 60,000 4,292,000 3.54%200 89,000 4,282,000 9.87%255 118,000 4,269,000 10.58%317 150,000 4,236,000 10.39%314 149,000 4,249,000 9.21%442 211,000 4,207,000 8.18%348 155,000 4,270,000 6.85%396 192,000 4,273,000 8.20%276 111,000 4,345,000 5.75%213 78,000 4,366,000 3.14%163 56,000 4,421,000 3.05%164 61,000 4,420,000 3.99%3,235 1,430,000 51,630,000 5.56%1,000 2,000 1,000 79 158,000 4,232,000 3.49%145 290,000 4,193,000 9.67%213 426,000 4,151,000 10.29%315 630,000 4,086,000 10.03%322 644,000 4,100,000 8.89%511 1,022,000 3,996,000 7.77%256 512,000 4,115,000 6.60%354 708,000 4,081,000 7.83%130 260,000 4,234,000 5.60%98 196,000 4,288,000 3.08%61 122,000 4,365,000 3.02%67 134,000 4,359,000 3.94%2,551 5,102,000 50,200,000 5.41%2,000 3,000 1,000 105 315,000 4,153,000 3.42%231 693,000 4,048,000 9.33%352 1,056,000 3,938,000 9.76%500 1,500,000 3,771,000 9.25%464 1,392,000 3,778,000 8.19%744 2,232,000 3,485,000 6.78%436 1,308,000 3,859,000 6.19%509 1,527,000 3,727,000 7.16%168 504,000 4,104,000 5.43%109 327,000 4,190,000 3.01%56 168,000 4,304,000 2.97%76 228,000 4,292,000 3.88%3,750 11,250,000 47,649,000 5.14%3,000 4,000 1,000 122 488,000 4,048,000 3.34%276 1,104,000 3,817,000 8.80%501 2,004,000 3,586,000 8.89%584 2,336,000 3,271,000 8.03%567 2,268,000 3,314,000 7.19%734 2,936,000 2,741,000 5.33%471 1,884,000 3,423,000 5.49%512 2,048,000 3,218,000 6.18%260 1,040,000 3,936,000 5.21%129 516,000 4,081,000 2.93%73 292,000 4,248,000 2.93%77 308,000 4,216,000 3.81%4,306 17,224,000 43,899,000 4.73%4,000 5,000 1,000 129 645,000 3,926,000 3.24%304 1,520,000 3,541,000 8.16%512 2,560,000 3,085,000 7.65%624 3,120,000 2,687,000 6.59%583 2,915,000 2,747,000 5.96%591 2,955,000 2,007,000 3.90%457 2,285,000 2,952,000 4.74%547 2,735,000 2,706,000 5.19%259 1,295,000 3,676,000 4.86%120 600,000 3,952,000 2.84%54 270,000 4,175,000 2.88%75 375,000 4,139,000 3.74%4,255 21,275,000 39,593,000 4.27%5,000 6,000 1,000 133 798,000 3,797,000 3.13%344 2,064,000 3,237,000 7.46%461 2,766,000 2,573,000 6.38%506 3,036,000 2,063,000 5.06%476 2,856,000 2,164,000 4.69%399 2,394,000 1,416,000 2.75%354 2,124,000 2,495,000 4.00%482 2,892,000 2,159,000 4.14%300 1,800,000 3,417,000 4.52%124 744,000 3,832,000 2.75%60 360,000 4,121,000 2.85%91 546,000 4,064,000 3.67%3,730 22,380,000 35,338,000 3.81%6,000 7,000 1,000 155 1,085,000 3,664,000 3.02%307 2,149,000 2,893,000 6.67%349 2,443,000 2,112,000 5.24%358 2,506,000 1,557,000 3.82%334 2,338,000 1,688,000 3.66%262 1,834,000 1,017,000 1.98%310 2,170,000 2,141,000 3.44%341 2,387,000 1,677,000 3.22%291 2,037,000 3,117,000 4.12%113 791,000 3,708,000 2.67%66 462,000 4,061,000 2.81%77 539,000 3,973,000 3.59%2,963 20,741,000 31,608,000 3.41%7,000 8,000 1,000 148 1,184,000 3,509,000 2.89%299 2,392,000 2,586,000 5.96%270 2,160,000 1,763,000 4.37%255 2,040,000 1,199,000 2.94%241 1,928,000 1,354,000 2.94%177 1,416,000 755,000 1.47%263 2,104,000 1,831,000 2.94%227 1,816,000 1,336,000 2.56%270 2,160,000 2,826,000 3.74%134 1,072,000 3,595,000 2.58%69 552,000 3,995,000 2.76%91 728,000 3,896,000 3.52%2,444 19,552,000 28,645,000 3.09%8,000 9,000 1,000 151 1,359,000 3,361,000 2.77%306 2,754,000 2,287,000 5.27%193 1,737,000 1,493,000 3.70%198 1,782,000 944,000 2.32%184 1,656,000 1,113,000 2.41%117 1,053,000 578,000 1.12%196 1,764,000 1,568,000 2.52%195 1,755,000 1,109,000 2.13%247 2,223,000 2,556,000 3.38%161 1,449,000 3,461,000 2.49%71 639,000 3,926,000 2.71%106 954,000 3,805,000 3.44%2,125 19,125,000 26,201,000 2.82%9,000 14,000 5,000 906 10,946,000 14,312,000 11.80%1,000 11,756,000 7,661,000 17.66%634 7,357,000 4,981,000 12.35%435 4,959,000 2,599,000 6.38%518 6,015,000 3,408,000 7.39%266 3,004,000 1,585,000 3.08%705 8,195,000 5,185,000 8.32%501 5,798,000 3,354,000 6.44%1,068 12,603,000 9,196,000 12.17%840 10,065,000 14,805,000 10.64%523 6,359,000 18,312,000 12.65%698 8,478,000 17,201,000 15.54%8,094 95,535,000 102,599,000 11.06%14,000 17,000 3,000 532 8,533,000 6,401,000 5.28%339 5,369,000 2,549,000 5.88%179 2,855,000 1,810,000 4.49%83 1,312,000 834,000 2.05%115 1,829,000 1,107,000 2.40%43 685,000 539,000 1.05%220 3,499,000 1,760,000 2.82%133 2,111,000 1,089,000 2.09%407 6,466,000 3,270,000 4.33%454 7,280,000 6,942,000 4.99%347 5,562,000 9,659,000 6.67%489 7,840,000 8,530,000 7.70%3,341 53,341,000 44,490,000 4.79%17,000 20,000 3,000 452 8,568,000 4,844,000 3.99%180 3,407,000 1,733,000 4.00%130 2,457,000 1,318,000 3.27%60 1,132,000 616,000 1.51%65 1,232,000 820,000 1.78%27 506,000 422,000 0.82%137 2,590,000 1,191,000 1.91%78 1,467,000 747,000 1.43%247 4,647,000 2,209,000 2.92%419 7,933,000 5,571,000 4.01%428 8,121,000 8,516,000 5.88%463 8,760,000 7,036,000 6.36%2,686 50,820,000 35,023,000 3.77%20,000 25,000 5,000 494 11,331,000 5,581,000 4.60%166 3,786,000 1,946,000 4.49%114 2,571,000 1,506,000 3.73%51 1,153,000 718,000 1.76%84 1,892,000 947,000 2.05%31 702,000 552,000 1.07%120 2,697,000 1,247,000 2.00%63 1,417,000 852,000 1.64%257 5,836,000 2,346,000 3.10%531 12,143,000 6,803,000 4.89%664 15,169,000 11,354,000 7.84%642 14,669,000 8,864,000 8.01%3,217 73,366,000 42,716,000 4.60%25,000 29,000 4,000 228 6,238,000 2,930,000 2.42%91 2,479,000 1,024,000 2.36%65 1,760,000 847,000 2.10%18 486,000 432,000 1.06%30 828,000 546,000 1.18%20 550,000 346,000 0.67%51 1,397,000 678,000 1.09%28 774,000 518,000 0.99%102 2,769,000 1,131,000 1.50%293 8,037,000 3,764,000 2.71%430 11,789,000 6,891,000 4.76%345 9,417,000 5,040,000 4.55%1,701 46,524,000 24,147,000 2.60%29,000 34,000 5,000 196 6,253,000 2,579,000 2.13%42 1,346,000 943,000 2.17%44 1,395,000 789,000 1.96%19 610,000 459,000 1.13%29 925,000 524,000 1.14%9 292,000 356,000 0.69%38 1,194,000 597,000 0.96%29 921,000 490,000 0.94%59 1,867,000 1,001,000 1.32%248 7,891,000 3,274,000 2.35%393 12,496,000 6,449,000 4.46%328 10,432,000 4,590,000 4.15%1,434 45,622,000 22,051,000 2.38%34,000 39,000 5,000 127 4,692,000 1,749,000 1.44%31 1,142,000 748,000 1.72%28 1,027,000 605,000 1.50%14 511,000 365,000 0.90%18 670,000 408,000 0.88%10 369,000 304,000 0.59%19 689,000 453,000 0.73%15 547,000 372,000 0.71%42 1,562,000 769,000 1.02%148 5,441,000 2,244,000 1.61%292 10,737,000 4,699,000 3.25%212 7,804,000 3,206,000 2.90%956 35,191,000 15,922,000 1.72%39,000 44,000 5,000 65 2,715,000 1,230,000 1.01%25 1,046,000 606,000 1.40%10 417,000 507,000 1.26%14 586,000 300,000 0.74%8 333,000 331,000 0.72%8 344,000 267,000 0.52%14 580,000 374,000 0.60%6 255,000 326,000 0.63%23 962,000 585,000 0.77%97 4,059,000 1,626,000 1.17%202 8,476,000 3,478,000 2.40%145 6,022,000 2,252,000 2.03%617 25,795,000 11,882,000 1.28%44,000 50,000 6,000 46 2,187,000 1,147,000 0.95%17 801,000 593,000 1.37%10 475,000 551,000 1.37%8 384,000 296,000 0.73%8 389,000 361,000 0.78%6 276,000 258,000 0.50%7 337,000 395,000 0.63%13 617,000 333,000 0.64%18 847,000 571,000 0.76%67 3,174,000 1,444,000 1.04%166 7,865,000 3,021,000 2.09%93 4,398,000 2,010,000 1.82%459 21,750,000 10,980,000 1.18%50,000 59,000 9,000 39 2,131,000 1,306,000 1.08%9 503,000 782,000 1.80%13 706,000 713,000 1.77%8 436,000 360,000 0.88%10 555,000 451,000 0.98%5 273,000 347,000 0.67%8 448,000 525,000 0.84%10 545,000 387,000 0.74%16 863,000 693,000 0.92%65 3,536,000 1,528,000 1.10%135 7,356,000 3,081,000 2.13%81 4,396,000 2,173,000 1.96%399 21,748,000 12,346,000 1.33%59,000 69,000 10,000 21 1,355,000 1,156,000 0.95%14 906,000 750,000 1.73%11 714,000 685,000 1.70%9 584,000 323,000 0.79%8 527,000 415,000 0.90%5 325,000 340,000 0.66%11 698,000 469,000 0.75%3 191,000 364,000 0.70%10 636,000 646,000 0.85%34 2,198,000 1,232,000 0.89%82 5,215,000 2,307,000 1.59%52 3,335,000 1,777,000 1.61%260 16,684,000 10,464,000 1.13%69,000 +104 25,039,000 17,863,000 14.73%67 14,351,000 9,728,000 22.43%62 13,426,000 9,148,000 22.68%27 6,907,000 5,044,000 12.38%36 7,692,000 5,208,000 11.29%31 7,718,000 5,579,000 10.85%42 18,507,000 15,609,000 25.05%35 10,588,000 8,173,000 15.69%60 15,512,000 11,372,000 15.05%104 26,400,000 19,224,000 13.82%193 39,782,000 26,465,000 18.28%151 37,767,000 27,348,000 24.70%912 223,689,000 160,761,000 17.33%4,379 96,080,000 96,080,000 79.21% 4,393 59,947,000 59,947,000 138.20% 4,406 50,430,000 50,430,000 125.02% 4,403 36,160,000 36,160,000 88.73% 4,414 39,033,000 39,033,000 84.64% 4,438 31,097,000 31,097,000 60.46% 4,463 55,137,000 55,137,000 88.49% 4,477 41,291,000 41,291,000 79.27% 4,510 66,000,000 66,000,000 87.33% 4,501 103,930,000 103,930,000 74.72% 4,528 141,848,000 141,848,000 98.00% 4,523 127,191,000 127,191,000 114.88% 53,435 848,144,000 848,144,000 91.41%FY 2016Beginning End Block Number of Consumption% ConsumptionNumber of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block‐ 1,000 1,000 182 64,000 4,438,000 3.66%431 230,000 4,354,000 10.04%416 176,000 4,345,000 10.77%401 166,000 4,355,000 10.69%370 150,000 4,388,000 9.51%342 137,000 4,419,000 8.59%336 140,000 4,435,000 7.12%359 172,000 4,455,000 8.55%272 122,000 4,520,000 5.98%191 70,000 4,555,000 3.27%164 60,000 4,573,000 3.16%188 85,000 4,573,000 4.13%3,652 1,572,000 53,410,000 5.76%1,000 2,000 1,000 80 160,000 4,374,000 3.61%506 1,012,000 4,124,000 9.51%367 734,000 4,169,000 10.34%286 572,000 4,189,000 10.28%270 540,000 4,238,000 9.19%245 490,000 4,282,000 8.32%208 416,000 4,295,000 6.89%333 666,000 4,283,000 8.22%173 346,000 4,398,000 5.82%87 174,000 4,485,000 3.22%70 140,000 4,513,000 3.12%100 200,000 4,488,000 4.05%2,725 5,450,000 51,838,000 5.59%2,000 3,000 1,000 89 267,000 4,294,000 3.54%607 1,821,000 3,618,000 8.34%539 1,617,000 3,802,000 9.43%498 1,494,000 3,903,000 9.58%442 1,326,000 3,968,000 8.60%378 1,134,000 4,037,000 7.85%357 1,071,000 4,087,000 6.56%450 1,350,000 3,950,000 7.58%225 675,000 4,225,000 5.59%90 270,000 4,398,000 3.16%73 219,000 4,443,000 3.07%143 429,000 4,388,000 3.96%3,891 11,673,000 49,113,000 5.29%3,000 4,000 1,000 93 372,000 4,205,000 3.47%648 2,592,000 3,011,000 6.94%685 2,740,000 3,263,000 8.09%598 2,392,000 3,405,000 8.36%508 2,032,000 3,526,000 7.65%464 1,856,000 3,659,000 7.11%361 1,444,000 3,730,000 5.99%474 1,896,000 3,500,000 6.72%302 1,208,000 4,000,000 5.29%109 436,000 4,308,000 3.10%93 372,000 4,370,000 3.02%187 748,000 4,245,000 3.83%4,522 18,088,000 45,222,000 4.87%4,000 5,000 1,000 106 530,000 4,112,000 3.39%492 2,460,000 2,363,000 5.45%599 2,995,000 2,578,000 6.39%615 3,075,000 2,807,000 6.89%470 2,350,000 3,018,000 6.54%458 2,290,000 3,195,000 6.21%390 1,950,000 3,369,000 5.41%458 2,290,000 3,026,000 5.81%311 1,555,000 3,698,000 4.89%116 580,000 4,199,000 3.02%78 390,000 4,277,000 2.95%162 810,000 4,058,000 3.67%4,255 21,275,000 40,700,000 4.39%5,000 6,000 1,000 104 624,000 4,006,000 3.30%342 2,052,000 1,871,000 4.31%455 2,730,000 1,979,000 4.91%513 3,078,000 2,192,000 5.38%458 2,748,000 2,548,000 5.52%409 2,454,000 2,737,000 5.32%352 2,112,000 2,979,000 4.78%373 2,238,000 2,568,000 4.93%337 2,022,000 3,387,000 4.48%101 606,000 4,083,000 2.94%88 528,000 4,199,000 2.90%172 1,032,000 3,896,000 3.52%3,704 22,224,000 36,445,000 3.93%6,000 7,000 1,000 131 917,000 3,902,000 3.22%219 1,533,000 1,529,000 3.52%345 2,415,000 1,524,000 3.78%383 2,681,000 1,679,000 4.12%377 2,639,000 2,090,000 4.53%353 2,471,000 2,328,000 4.53%284 1,988,000 2,627,000 4.22%268 1,876,000 2,195,000 4.21%306 2,142,000 3,050,000 4.04%138 966,000 3,982,000 2.86%105 735,000 4,111,000 2.84%192 1,344,000 3,724,000 3.36%3,101 21,707,000 32,741,000 3.53%7,000 8,000 1,000 143 1,144,000 3,771,000 3.11%184 1,472,000 1,310,000 3.02%237 1,896,000 1,179,000 2.92%303 2,424,000 1,296,000 3.18%277 2,216,000 1,713,000 3.71%293 2,344,000 1,975,000 3.84%257 2,056,000 2,343,000 3.76%249 1,992,000 1,927,000 3.70%267 2,136,000 2,744,000 3.63%131 1,048,000 3,844,000 2.76%106 848,000 4,006,000 2.77%200 1,600,000 3,532,000 3.19%2,647 21,176,000 29,640,000 3.19%8,000 9,000 1,000 144 1,296,000 3,628,000 2.99%154 1,386,000 1,126,000 2.60%190 1,710,000 942,000 2.34%210 1,890,000 993,000 2.44%219 1,971,000 1,436,000 3.11%267 2,403,000 1,682,000 3.27%247 2,223,000 2,086,000 3.35%199 1,791,000 1,678,000 3.22%264 2,376,000 2,477,000 3.28%130 1,170,000 3,713,000 2.67%113 1,017,000 3,900,000 2.69%169 1,521,000 3,332,000 3.01%2,306 20,754,000 26,993,000 2.91%9,000 14,000 5,000 842 10,205,000 15,837,000 13.06%451 5,246,000 3,792,000 8.74%395 4,518,000 2,748,000 6.81%449 5,185,000 2,814,000 6.91%664 7,712,000 4,501,000 9.76%749 8,740,000 5,329,000 10.36%906 10,655,000 7,166,000 11.50%696 8,118,000 5,769,000 11.08%995 11,710,000 8,845,000 11.70%773 9,348,000 16,441,000 11.82%761 9,204,000 17,485,000 12.08%788 9,473,000 14,256,000 12.88%8,469 100,114,000 104,983,000 11.31%14,000 17,000 3,000 504 8,088,000 7,446,000 6.14%138 2,196,000 1,413,000 3.26%109 1,720,000 938,000 2.33%95 1,490,000 877,000 2.15%196 3,124,000 1,451,000 3.15%212 3,375,000 1,769,000 3.44%313 4,997,000 2,475,000 3.97%218 3,479,000 2,122,000 4.07%366 5,822,000 3,254,000 4.31%516 8,251,000 7,909,000 5.69%521 8,340,000 8,561,000 5.91%494 7,880,000 6,607,000 5.97%3,682 58,762,000 44,822,000 4.83%17,000 20,000 3,000 470 8,937,000 5,951,000 4.91%103 1,944,000 1,033,000 2.38%61 1,153,000 677,000 1.68%58 1,095,000 652,000 1.60%103 1,948,000 959,000 2.08%132 2,486,000 1,208,000 2.35%177 3,326,000 1,646,000 2.64%153 2,876,000 1,511,000 2.90%234 4,410,000 2,286,000 3.02%451 8,542,000 6,404,000 4.60%487 9,251,000 7,026,000 4.85%410 7,774,000 5,217,000 4.71%2,839 53,742,000 34,570,000 3.73%20,000 25,000 5,000 606 13,802,000 6,992,000 5.76%103 2,326,000 1,151,000 2.65%59 1,336,000 796,000 1.97%52 1,192,000 797,000 1.96%85 1,951,000 1,096,000 2.38%111 2,481,000 1,316,000 2.56%176 3,989,000 1,804,000 2.90%149 3,385,000 1,720,000 3.30%241 5,463,000 2,528,000 3.34%563 12,859,000 7,999,000 5.75%663 15,161,000 8,676,000 5.99%510 11,609,000 6,214,000 5.61%3,318 75,554,000 41,089,000 4.43%25,000 29,000 4,000 302 8,292,000 3,782,000 3.12%39 1,064,000 641,000 1.48%23 634,000 479,000 1.19%20 544,000 480,000 1.18%39 1,074,000 619,000 1.34%46 1,259,000 769,000 1.50%61 1,658,000 957,000 1.54%65 1,777,000 944,000 1.81%107 2,924,000 1,329,000 1.76%344 9,426,000 4,570,000 3.29%351 9,596,000 4,837,000 3.34%256 7,028,000 3,448,000 3.11%1,653 45,276,000 22,855,000 2.46%29,000 34,000 5,000 267 8,507,000 3,229,000 2.66%29 931,000 635,000 1.46%20 642,000 487,000 1.21%17 539,000 506,000 1.24%19 603,000 607,000 1.32%36 1,148,000 749,000 1.46%56 1,795,000 921,000 1.48%49 1,559,000 883,000 1.70%91 2,880,000 1,136,000 1.50%303 9,636,000 4,014,000 2.89%311 9,884,000 4,330,000 2.99%214 6,850,000 3,099,000 2.80%1,412 44,974,000 20,596,000 2.22%34,000 39,000 5,000 146 5,394,000 2,165,000 1.78%22 805,000 492,000 1.13%15 552,000 392,000 0.97%19 696,000 415,000 1.02%27 1,002,000 504,000 1.09%22 811,000 598,000 1.16%28 1,028,000 686,000 1.10%35 1,292,000 672,000 1.29%43 1,581,000 799,000 1.06%179 6,599,000 2,783,000 2.00%210 7,719,000 2,994,000 2.07%145 5,325,000 2,125,000 1.92%891 32,804,000 14,625,000 1.58%39,000 44,000 5,000 74 3,094,000 1,573,000 1.30%16 676,000 407,000 0.94%6 249,000 335,000 0.83%10 414,000 339,000 0.83%15 624,000 384,000 0.83%15 624,000 499,000 0.97%18 761,000 579,000 0.93%15 630,000 540,000 1.04%24 991,000 615,000 0.81%118 4,970,000 2,048,000 1.47%141 5,876,000 2,087,000 1.44%80 3,343,000 1,553,000 1.40%532 22,252,000 10,959,000 1.18%44,000 50,000 6,000 58 2,731,000 1,469,000 1.21%7 329,000 405,000 0.93%11 517,000 351,000 0.87%8 388,000 366,000 0.90%4 189,000 403,000 0.87%16 753,000 505,000 0.98%11 515,000 589,000 0.95%18 847,000 541,000 1.04%17 809,000 631,000 0.83%92 4,343,000 1,759,000 1.26%77 3,648,000 1,850,000 1.28%63 2,977,000 1,423,000 1.29%382 18,046,000 10,292,000 1.11%50,000 59,000 9,000 70 3,826,000 1,631,000 1.34%13 701,000 510,000 1.18%7 384,000 448,000 1.11%10 542,000 447,000 1.10%10 540,000 535,000 1.16%13 707,000 624,000 1.21%23 1,260,000 740,000 1.19%16 864,000 649,000 1.25%22 1,186,000 743,000 0.98%71 3,856,000 1,863,000 1.34%84 4,598,000 2,027,000 1.40%55 2,971,000 1,553,000 1.40%394 21,435,000 11,770,000 1.27%59,000 69,000 10,000 26 1,676,000 1,332,000 1.10%9 576,000 465,000 1.07%7 457,000 434,000 1.08%7 447,000 414,000 1.02%8 515,000 513,000 1.11%7 452,000 599,000 1.16%13 843,000 646,000 1.04%7 445,000 612,000 1.17%8 513,000 691,000 0.91%45 2,873,000 1,498,000 1.08%41 2,610,000 1,591,000 1.10%30 1,920,000 1,330,000 1.20%208 13,327,000 10,125,000 1.09%69,000 +119 41,372,000 33,161,000 27.34%42 12,026,000 9,128,000 21.04%39 11,162,000 8,471,000 21.00%38 10,447,000 7,825,000 19.20%47 10,865,000 7,622,000 16.53%56 13,023,000 9,159,000 17.81%57 18,084,000 14,151,000 22.71%58 12,546,000 8,544,000 16.40%65 24,708,000 20,223,000 26.76%128 53,071,000 44,239,000 31.81%140 54,552,000 44,892,000 31.01%118 35,794,000 27,652,000 24.98%907 297,650,000 235,067,000 25.33%4,556 121,298,000 121,298,000 100.00% 4,555 43,378,000 43,378,000 100.00% 4,585 40,337,000 40,337,000 100.00% 4,590 40,751,000 40,751,000 100.00% 4,608 46,119,000 46,119,000 100.00% 4,624 51,438,000 51,438,000 100.00% 4,631 62,311,000 62,311,000 100.00% 4,642 52,089,000 52,089,000 100.00% 4,670 75,579,000 75,579,000 100.00% 4,676 139,094,000 139,094,000 100.00% 4,677 144,748,000 144,748,000 100.00% 4,676 110,713,000 110,713,000 100.00% 55,490 927,855,000 927,855,000 100.00%PROJECTED REVENUEProjected Number of Meters ‐ Oct 1st4,802 Projected Growth Rate2.00%Projected Accounts4,810 4,818 4,826 4,834 4,842 4,850 4,858 4,866 4,874 4,882 4,890 4,898 4,906 Projected Average Con per Account22,820 11,638 9,476 8,888 9,400 10,210 13,804 13,097 18,008 24,929 29,582 25,970 16,539 Projected Consumption109,763,759 56,072,779 45,731,723 42,964,876 45,512,862 49,516,919 67,060,653 63,729,376 87,770,788 121,701,909 144,658,284 127,200,691 81,141,408 Dist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenue‐ 1,000 1,000 4.25% 4,664,696 3.96 18,472$ 8.29% 4,648,477 3.96 18,408$ 10.08% 4,608,058 3.96 18,248$ 10.74% 4,615,206 3.96 18,276$ 10.15% 4,619,712 3.96 18,294$ 9.37% 4,638,154 3.96 18,367$ 6.96% 4,668,757 3.96 18,488$ 7.39% 4,708,583 3.96 18,646$ 5.40% 4,739,507 3.96 18,768$ 3.89% 4,731,957 3.96 18,739$ 3.29% 4,765,739 3.96 18,872$ 3.77% 4,789,701 3.96 18,967$ 56,198,546 3.96 222,546$ 1,000 2,000 1,000 4.18%4,592,814 3.96 18,188 8.00% 4,484,046 3.96 17,757 9.70% 4,434,361 3.96 17,560 10.36% 4,451,095 3.96 17,626 9.79% 4,457,297 3.96 17,651 9.01% 4,463,946 3.96 17,677 6.75% 4,524,164 3.96 17,916 7.12% 4,538,156 3.96 17,971 5.28% 4,631,339 3.96 18,340 3.83% 4,656,406 3.96 18,439 3.25% 4,703,981 3.96 18,628 3.71% 4,713,801 3.96 18,667 54,651,406 3.96 216,420 2,000 3,000 1,000 4.10% 4,496,849 3.96 17,808 7.42% 4,160,690 3.96 16,476 8.98% 4,106,674 3.96 16,262 9.66%4,149,555 3.96 16,432 9.11% 4,145,213 3.96 16,415 8.33% 4,122,440 3.96 16,325 6.41% 4,295,285 3.96 17,009 6.67% 4,249,742 3.96 16,829 5.12% 4,490,974 3.96 17,784 3.74% 4,557,112 3.96 18,046 3.21% 4,636,838 3.96 18,362 3.64% 4,633,201 3.96 18,347 52,044,572 3.96 206,097 3,000 4,000 1,000 3.99% 4,374,977 3.96 17,325 6.65% 3,726,856 3.96 14,758 7.87% 3,598,722 3.96 14,251 8.50% 3,651,375 3.96 14,459 8.03% 3,656,877 3.96 14,481 7.28% 3,602,725 3.96 14,267 5.85%3,921,450 3.96 15,529 6.04% 3,850,259 3.96 15,247 4.92% 4,318,049 3.96 17,099 3.65% 4,444,866 3.96 17,602 3.16% 4,564,668 3.96 18,076 3.56% 4,530,916 3.96 17,942 48,241,740 3.96 191,037 4,000 5,000 1,000 3.87% 4,246,537 3.96 16,816 5.75% 3,226,590 3.96 12,777 6.46% 2,952,105 3.96 11,690 7.05% 3,031,116 3.96 12,003 6.79% 3,089,519 3.96 12,234 6.14% 3,038,276 3.96 12,032 5.24% 3,516,009 3.96 13,923 5.39% 3,435,117 3.96 13,603 4.64% 4,072,771 3.96 16,128 3.55%4,315,352 3.96 17,089 3.09% 4,474,545 3.96 17,719 3.46% 4,406,583 3.96 17,450 43,804,520 3.96 173,466 5,000 6,000 1,000 3.73% 4,098,394 3.96 16,230 4.98% 2,790,921 3.96 11,052 5.14% 2,352,562 3.96 9,316 5.58% 2,397,334 3.96 9,493 5.55% 2,523,981 3.96 9,995 5.07% 2,510,560 3.96 9,942 4.64% 3,114,563 3.96 12,334 4.73% 3,012,692 3.96 11,930 4.36% 3,826,770 3.96 15,154 3.44% 4,185,118 3.96 16,573 3.04% 4,394,117 3.96 17,401 3.37% 4,284,058 3.96 16,965 39,491,068 3.96 156,385 6,000 7,000 1,000 3.60% 3,946,966 4.61 18,196 4.30% 2,411,409 4.61 11,117 4.06% 1,856,652 4.61 8,559 4.32% 1,854,197 4.61 8,548 4.42% 2,013,431 4.61 9,282 4.21% 2,086,860 4.61 9,620 4.11% 2,753,444 4.61 12,693 4.13% 2,635,058 4.61 12,148 4.05% 3,558,339 4.61 16,404 3.33% 4,053,804 4.61 18,688 2.98% 4,305,071 4.61 19,846 3.27% 4,163,339 4.61 19,193 35,638,570 4.61 164,294 7,000 8,000 1,000 3.43%3,769,997 4.61 17,380 3.76% 2,107,138 4.61 9,714 3.26% 1,488,824 4.61 6,863 3.36% 1,443,006 4.61 6,652 3.60% 1,638,712 4.61 7,554 3.55% 1,760,265 4.61 8,115 3.63% 2,437,374 4.61 11,236 3.69% 2,351,742 4.61 10,842 3.76% 3,300,761 4.61 15,217 3.21% 3,912,418 4.61 18,036 2.91% 4,207,049 4.61 19,394 3.17% 4,027,079 4.61 18,565 32,444,365 4.61 149,569 8,000 9,000 1,000 3.28% 3,603,244 4.61 16,611 3.29% 1,846,912 4.61 8,514 2.66% 1,214,779 4.61 5,600 2.63%1,128,308 4.61 5,201 2.97% 1,350,663 4.61 6,227 3.00% 1,484,587 4.61 6,844 3.24% 2,173,255 4.61 10,019 3.32% 2,116,859 4.61 9,759 3.49% 3,060,186 4.61 14,107 3.09% 3,765,275 4.61 17,358 2.84% 4,112,976 4.61 18,961 3.06% 3,887,566 4.61 17,922 29,744,610 4.61 137,123 9,000 14,000 5,000 14.01% 15,381,748 4.61 70,910 11.22% 6,293,887 4.61 29,015 8.23% 3,762,931 4.61 17,347 7.35% 3,156,849 4.61 14,553 8.95% 4,075,659 4.61 18,789 9.57% 4,738,169 4.61 21,843 11.56%7,752,803 4.61 35,740 12.23% 7,793,014 4.61 35,926 13.61% 11,946,265 4.61 55,072 13.35% 16,246,157 4.61 74,895 12.93% 18,709,286 4.61 86,250 13.52% 17,195,505 4.61 79,271 117,052,272 4.61 539,611 14,000 17,000 3,000 6.39% 7,009,085 4.61 32,312 3.96% 2,220,184 4.61 10,235 2.84% 1,298,342 4.61 5,985 2.27% 975,527 4.61 4,497 2.81% 1,278,924 4.61 5,896 3.30% 1,632,246 4.61 7,525 4.26% 2,856,621 4.61 13,169 4.82% 3,068,772 4.61 14,147 5.60% 4,914,241 4.61 22,655 6.23%7,586,313 4.61 34,973 6.53% 9,444,227 4.61 43,538 6.53% 8,310,775 4.61 38,313 50,595,259 4.61 233,244 17,000 20,000 3,000 4.95% 5,430,226 5.34 28,997 2.76% 1,548,514 5.34 8,269 2.06% 941,827 5.34 5,029 1.64% 702,497 5.34 3,751 1.96% 893,644 5.34 4,772 2.31% 1,141,990 5.34 6,098 2.99% 2,005,048 5.34 10,707 3.49% 2,223,194 5.34 11,872 4.15% 3,638,651 5.34 19,430 4.95% 6,020,266 5.34 32,148 5.51% 7,969,229 5.34 42,556 5.29% 6,725,533 5.34 35,914 39,240,619 5.34 209,545 20,000 25,000 5,000 5.77% 6,331,858 5.34 33,812 3.05% 1,710,375 5.34 9,133 2.40% 1,098,373 5.34 5,865 1.97% 846,505 5.34 4,520 2.25% 1,023,285 5.34 5,464 2.58% 1,276,920 5.34 6,819 3.29% 2,206,679 5.34 11,784 3.96% 2,524,718 5.34 13,482 4.76% 4,181,301 5.34 22,328 6.03% 7,338,076 5.34 39,185 7.04% 10,189,985 5.34 54,415 6.46% 8,218,249 5.34 43,885 46,946,323 5.34 250,693 25,000 29,000 4,000 3.09% 3,391,976 6.20 21,030 1.64% 917,950 6.20 5,691 1.40% 640,413 6.20 3,971 1.18% 508,415 6.20 3,152 1.27% 579,012 6.20 3,590 1.48% 733,565 6.20 4,548 1.75% 1,171,276 6.20 7,262 2.13% 1,356,130 6.20 8,408 2.52% 2,212,566 6.20 13,718 3.34% 4,059,201 6.20 25,167 4.07% 5,890,658 6.20 36,522 3.64% 4,625,973 6.20 28,681 26,087,135 6.20 161,740 29,000 34,000 5,000 2.66% 2,919,814 6.20 18,103 1.53% 860,326 6.20 5,334 1.38% 632,385 6.20 3,921 1.23% 529,248 6.20 3,281 1.24% 564,445 6.20 3,500 1.39% 689,195 6.20 4,273 1.56% 1,046,301 6.20 6,487 1.84% 1,172,594 6.20 7,270 2.18% 1,914,108 6.20 11,867 2.92% 3,555,533 6.20 22,044 3.70% 5,348,844 6.20 33,163 3.28% 4,172,014 6.20 25,866 23,404,808 6.20 145,110 34,000 39,000 5,000 1.79% 1,959,435 6.20 12,148 1.20% 671,671 6.20 4,164 1.11% 505,398 6.20 3,133 1.00% 430,928 6.20 2,672 1.02% 463,573 6.20 2,874 1.13% 559,721 6.20 3,470 1.13%754,936 6.20 4,681 1.32% 839,388 6.20 5,204 1.55% 1,357,349 6.20 8,416 2.01% 2,441,708 6.20 15,139 2.62% 3,784,441 6.20 23,464 2.27% 2,884,230 6.20 17,882 16,652,778 6.20 103,247 39,000 44,000 5,000 1.30% 1,422,324 6.20 8,818 1.00% 561,561 6.20 3,482 0.94% 428,402 6.20 2,656 0.84% 359,655 6.20 2,230 0.81% 369,985 6.20 2,294 0.98% 485,891 6.20 3,013 0.92% 617,245 6.20 3,827 1.01% 641,285 6.20 3,976 1.13% 992,688 6.20 6,155 1.45%1,766,434 6.20 10,952 1.89% 2,732,769 6.20 16,943 1.65% 2,093,778 6.20 12,981 12,472,016 6.20 77,327 44,000 50,000 6,000 1.20% 1,320,885 6.20 8,189 0.99% 554,954 6.20 3,441 0.98% 449,931 6.20 2,790 0.88% 377,565 6.20 2,341 0.87% 394,019 6.20 2,443 1.00% 495,711 6.20 3,073 0.94% 631,777 6.20 3,917 0.99% 627,811 6.20 3,892 1.07% 936,253 6.20 5,805 1.25% 1,526,113 6.20 9,462 1.65% 2,386,280 6.20 14,795 1.47% 1,864,268 6.20 11,558 11,565,568 6.20 71,707 50,000 59,000 9,000 1.38% 1,511,356 7.21 10,897 1.29% 722,689 7.21 5,211 1.27% 580,204 7.21 4,183 1.09% 470,402 7.21 3,392 1.13% 516,376 7.21 3,723 1.28% 632,459 7.21 4,560 1.19% 801,074 7.21 5,776 1.16% 741,065 7.21 5,343 1.20% 1,050,209 7.21 7,572 1.37% 1,663,182 7.21 11,992 1.74% 2,521,644 7.21 18,181 1.57% 1,996,914 7.21 14,398 13,207,574 7.21 95,227 59,000 69,000 10,000 1.20% 1,314,318 7.21 9,476 1.22%681,581 7.21 4,914 1.23% 561,593 7.21 4,049 1.02% 438,604 7.21 3,162 1.08% 492,342 7.21 3,550 1.19% 590,634 7.21 4,258 1.07% 716,789 7.21 5,168 1.09% 694,088 7.21 5,004 1.06% 927,208 7.21 6,685 1.14% 1,383,647 7.21 9,976 1.35% 1,948,951 7.21 14,052 1.31% 1,667,287 7.21 12,021 11,417,043 7.21 82,317 69,000 +21.84% 23,976,261 7.21 172,869 17.70% 9,926,049 7.21 71,567 17.97% 8,219,187 7.21 59,260 17.33% 7,447,489 7.21 53,696 16.18%7,366,193 7.21 53,110 17.84% 8,832,604 7.21 63,683 22.51% 15,095,804 7.21 108,841 17.49% 11,149,108 7.21 80,385 20.17% 17,701,252 7.21 127,626 24.23% 29,492,973 7.21 212,644 23.20% 33,566,987 7.21 242,018 22.02% 28,009,922 7.21 201,952 200,783,828 7.21 1,447,651 100.00% 109,763,759 584,587$ 100.00% 56,072,779 281,030$ 100.00% 45,731,723 226,541$ 100.00% 42,964,876 209,941$ 100.00% 45,512,862 222,138$ 100.00% 49,516,919 246,352$ 100.00% 67,060,653 346,506$ 100.00% 63,729,376 321,884$ 100.00% 87,770,788 456,331$ 100.00% 121,701,909 659,147$ 100.00%144,658,284 793,155$ 100.00% 127,200,691 686,742$ 961,684,619 5,034,354$ Total BaseProjected Revenue Summary:Base ChargesRatesProjectedRevenueRate Current Meter MonthlyVolumetric Revenue5,034,354$ 5/8" x 3/4"17.1558,248 998,953$ IncrementCountRevenueBase Charge Revenue1"32.2315.08 2,040 30,763$ Base998,953$ 1 1/2"56.9439.79 34 1,353 Increment (x 12)593,768 2"86.5869.43 106 7,360 Base Subtotal1,592,721$ 3"155.76138.61 36 4,990 4"254.59237.44 15 3,562 6"501.64484.49 3 1,453 Total Projected Revenue 6,627,075$ 49,481$ TABLE GF‐D 2AB C DMONTH SHUTOFFS FOR NON‐PAYMENTLATE FEES ($/Month)METER SET FEESMUDGROWTH RATE: RECOMMENDED0.50%May‐1630 $4,598.00 9$21,457Jun‐1630 $5,380.00 5$106,810Jul‐1616 $8,944.00 5$18,270Aug‐1628 $8,358.00 4Sep‐1628 $12,817.00 2Oct‐1630 $13,727.00 7Nov‐1637 $8,728.00 4Dec‐1637 $9,738.00 0Jan‐1744 $8,211.00 5Feb‐1735 $7,603.00 4Mar‐1751 $8,722.00 3Apr‐1761 $9,453.00 5Total427 $106,279 53Average Per Month36 $8,857 4SCHEDULE GF‐DPROJECTED WATER REVENUE MARCHOCTOBER NOVEMBER DECEMBER JANUARY FEBURARYTOTALJULY AUGUST SEPTEMBERAPRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALJULY AUGUST SEPTEMBERAPRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALJULY AUGUST SEPTEMBERAPRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALAUGUST SEPTEMBERAPRIL MAY JUNE JULYREVENUE FOR MUD TAP FEES:OTHER REVENUE SOURCESREVENUE FOR SHUTOFFS (MO. AVE. X 12 x $50):TOTAL LATE FEES:Increment Above Base18 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 119 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017OctNovDecJanFebMarAprMayJunJulAugSepAccounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage0 to 1,000199 4,664,696 345 4,648,477 388 4,608,058 387 4,615,206 380 4,619,712 392 4,638,154 342 4,668,757 357 4,708,583 264 4,739,507 207 4,731,957 179 4,765,739 189 4,789,701to 2,00096 4,592,814 323 4,484,046 328 4,434,361 301 4,451,095 312 4,457,297 341 4,463,946 228 4,524,164 287 4,538,156 140 4,631,339 100 4,656,406 67 4,703,981 81 4,713,8012,000 to 3,000122 4,496,849 433 4,160,690 508 4,106,674 498 4,149,555 489 4,145,213 519 4,122,440 373 4,295,285 397 4,249,742 172 4,490,974 113 4,557,112 72 4,636,838 102 4,633,2013,000 to 4,000129 4,374,977 499 3,726,856 647 3,598,722 620 3,651,375 568 3,656,877 564 3,602,725 405 3,921,450 412 3,850,259 244 4,318,049 130 4,444,866 90 4,564,668 124 4,530,9164,000 to 5,000149 4,246,537 435 3,226,590 600 2,952,105 633 3,031,116 566 3,089,519 527 3,038,276 401 3,516,009 420 3,435,117 245 4,072,771 131 4,315,352 81 4,474,545 122 4,406,5835,000 to 6,000152 4,098,394 379 2,790,921 496 2,352,562 543 2,397,334 511 2,523,981 423 2,510,560 360 3,114,563 375 3,012,692 267 3,826,770 132 4,185,118 89 4,394,117 121 4,284,0586,000 to 7,000178 3,946,966 304 2,411,409 368 1,856,652 411 1,854,197 375 2,013,431 326 2,086,860 315 2,753,444 281 2,635,058 256 3,558,339 142 4,053,804 98 4,305,071 136 4,163,3397,000 to 8,000167 3,769,997 260 2,107,138 274 1,488,824 314 1,443,006 288 1,638,712 275 1,760,265 264 2,437,374 233 2,351,742 239 3,300,761 148 3,912,418 94 4,207,049 139 4,027,0798,000 to 9,000165 3,603,244 234 1,846,912 197 1,214,779 231 1,128,308 219 1,350,663 226 1,484,587 236 2,173,255 207 2,116,859 230 3,060,186 164 3,765,275 105 4,112,976 141 3,887,5669,000 to 14,000935 15,381,748 774 6,293,887 535 3,762,931 528 3,156,849 649 4,075,659 651 4,738,169 872 7,752,803 771 7,793,014 1,022 11,946,265 896 16,246,157 708 18,709,286 800 17,195,50514,000 to 17,000535 7,009,085 261 2,220,184 138 1,298,342 110 975,527156 1,278,924 178 1,632,246 319 2,856,621 305 3,068,772 465 4,914,241 536 7,586,313 480 9,444,227 531 8,310,77517,000 to 20,000468 5,430,226 165 1,548,514 87941,827 64 702,49786893,644 122 1,141,990 206 2,005,048 222 2,223,194 332 3,638,651 470 6,020,266 481 7,969,229 492 6,725,53320,000 to 25,000554 6,331,858 148 1,710,375 82 1,098,373 57 846,50583 1,023,285 103 1,276,920 205 2,206,679 213 2,524,718 369 4,181,301 569 7,338,076 707 10,189,985 627 8,218,24925,000 to 29,000275 3,391,976 72 917,950 38640,413 24 508,41537579,012 49 733,565 91 1,171,276 115 1,356,130 186 2,212,566 312 4,059,201 410 5,890,658 334 4,625,97329,000 to 34,000237 2,919,814 42 860,326 30632,385 21 529,24822564,445 35 689,195 73 1,046,301 81 1,172,594 137 1,914,108 272 3,555,533 357 5,348,844 294 4,172,01434,000 to 39,000131 1,959,435 26 671,671 20505,398 16 430,92821463,573 17 559,721 35754,936 50 839,38884 1,357,349 163 2,441,708 252 3,784,441 190 2,884,23039,000 to 44,00074 1,422,324 21 561,561 9428,402 12 359,65511369,985 13 485,891 20617,245 24 641,28551992,688108 1,766,434 169 2,732,769 121 2,093,77844,000 to 50,00052 1,320,885 13 554,954 11449,9318377,5657394,019 11 495,711 14631,777 25 627,81135936,25373 1,526,113 117 2,386,280 94 1,864,26850,000 to 59,00049 1,511,356 11 722,689 10580,2049470,4029516,376 14 632,459 19801,074 17 741,06535 1,050,209 61 1,663,182 107 2,521,644 71 1,996,91459,000 to 69,00026 1,314,318 14 681,581 8561,5939438,6049492,3429590,634 13716,789 10 694,08817927,20835 1,383,647 63 1,948,951 43 1,667,28769,000 + +118 23,976,261 61 9,926,049 51 8,219,187 39 7,447,48944 7,366,193 54 8,832,604 65 15,095,804 64 11,149,108 83 17,701,252 121 29,492,973 164 33,566,987 145 28,009,922 SCHEDULE GF‐E (NEWGEN STILL WORKING ON SEWER AMOUNTS ESTIMATED $2,600,000)PROJECTED RETAIL WASTEWATER SALES FY 2018WATER USECATEGORY19 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 120 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017SCHEDULE GF‐FUNIFORMSWATER DEPARTMENTITEMNUMBER EMPLOYEES NUMBER PER EMPLOYEETOTAL # TO PURCHASECOST EACH SUBTOTALUNIFORM SHIRTS6 10 60 $14 $840POLO SHIRTS6424$17$408SWEATSHIRTS6530$18$540PANTS6742$25$1,050BOOTS616$175 $1,050JACKET414$150$600 TOTAL:$4,488WASTEWATER DEPARTMENTITEMNUMBER EMPLOYEES NUMBER PER EMPLOYEETOTAL # TO PURCHASECOST EACH SUBTOTALUNIFORM SHIRTS7 6 42 $18 $756POLO SHIRTS700$35$0SWEATSHIRTS7214$27$378PANTS7535$30$1,050BOOTS717$175 $1,225JACKET717$150 $1,050TOTAL:$4,459ADMINISTRATIONITEMNUMBER EMPLOYEES NUMBER PER EMPLOYEETOTAL # TO PURCHASECOST EACH SUBTOTALPOLO SHIRTS3 5 15 $35 $525(DIRECTOR) SHIRTS5210$35$350SWEATER00 0 $0JACKETS00 0 $0TOTAL:$87520 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 121 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017Department TrainingNumber to AttendEstimated Class Cost/PersonTotal TrainingEstimated Travel & Per Diem Cost Per PersonTotal Travel & Per DiemTotal Deptartment CostWATERWater Classes4$325$1,300$50$200CSI Class1$230$230$50$50CSI Renewals1$111$111$50$50 Management Classes1$350$350$100$100Management Conferences1$350$350$400$400 License Renewal4$111$444$100$400CDL Renewal0$75$0$0$0Miscellaneous Mileage/Travel (Miles)1,000$0$0.535$535 $2,785 $1,735 $4,520WASTEWATERWastewater Classes7$325$2,275$50$350Advanced Technology (MBR) Classes7$325$2,275$50$350Management Classes/Conferences1$350$350$400$400License Renewal7$111$777$0CDL Renewal0$75$0$0Miscellaneous Mileage/Travel (Miles)1,000$0$0.535$535 $5,677 $1,635 $7,312ADMINISTRATIONADM Management Classes2$350$700$300$600Management Conferences4$350$1,400$400 $1,600Elections Training2$350$700$400$800Public Funds Inv. Training3$300$900$100$300Govmt Accounting Conference2$350$700$400$800Software Training3$400$1,200$50$150AWWA Customer Service Workshop0$150$0$650$0CGFO Application and Testing1$500$500$100$100Customer Service Conferences0$350$0$200$0CPA/CFE Classes/Renewal0$1,200$0$300$0Miscellaneous Mileage/Travel (Miles)1,000$0.000$0$0.535$535Miscellaneous Travel (Legal)3$500$1,500$0$0 $7,600 $4,885 $12,485SCHEDULE GF‐GTRAVEL & TRAINING21 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 122 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017SCHEDULE GF‐HSALARY WORKSHEET COLA Merit TotalSocialTWC UNEMP WORKERS Pay Pay OTCertification Certification SalariesSecurity Medicare2.00% COMPWATER & DISTRIBUTION Base Pay 2.1%Pay Longevity Monthly Annually & Wages6.2% 1.45%UP TO $90000.0402744Water Superintendent77,260 1,622 1733 0 0 80,614 4,998 1,169 180 3,247Crew Leader51,892 1,090 1433 100 1200 55,614 3,448 806 180 2,240Utility Field Worker34,986 735 145 25 300 36,165 2,242 524 180 1,457Utility Field Worker34,986 735 115 25 300 36,135 2,240 524 180 1,455Utility Field Worker 34,986 0 0 75 900 35,886 2,225 520 180 1,445 Utility Field Worker (Trainee) 27,0000 025 300 27,300 1,693 396180 1,099Additional Cert Pay Level25 300 30019412Overtime Pay20,00020,000 1,240 290537DM Discretionary1,000 1,000 62 15 40Merit 7,989 7,989 495 116 322TOTAL: 262,109 4,182 7,989 20,000 3,425 3,300 301,004 18,662 4,365 1,080 11,854 COLA Merit TotalSocialTWC UNEMP WORKERS Pay Pay OTCertification Certification SalariesSecurity Medicare2.00% COMPWASTEWATER & COLLECTIONS Base Pay 2.1%Pay Longevity Rate Annually & Wages6.2% 1.45%UP TO $90000.0402744Wastewater Superintendent75,146 1,578.07 480‐ ‐ 77,204 4,787 1,119180 3,109Wastewater Shift Supervisor58,161 1,221.38 110 100 1,200 60,692 3,763 880 180 2,444Crew Leader59,540 1,250.34 1,763 125 1,500 64,053 3,971 929180 2,580Utility Field Worker53,414 1,121.70 1,373 150 1,800 57,709 3,578 837 180 2,324Utility Field Worker43,497 913.44 863 100 1,200 46,473 2,881 674 180 1,872Crew Leader57,768 1,213.12 1,845 100 1,200 62,026 3,846 899180 2,498Utility Field Worker42,189 885.96 983 100 1,200 45,257 2,806 656 180 1,823Additional Cert Pay Level25 300 300 19 4 12Overtime Pay30,000 30,000 1,860 435 805DM Discretionary1,000 1,000 62 15 40Merit 11,967 11,967 742 174 482TOTAL: 390,715 8,184 11,967 30,000 7,415 8,400 456,681 28,314 6,622 1,260 17,990 COLA Merit TotalSocialTWC UNEMP WORKERS Pay Pay OT Longevity CertificationSalariesSecurity Medicare2.00% COMPADMINISTRATION Base Pay 2.1%Pay Rate Certification & Wages6.2% 1.45%UP TO $90000.003492 General Manager120,000 2,520000 122,520 7,596 1,777180428 District Secretary80,635 1,69306300 82,959 5,143 1,203180290HR/Financial Analyst70,000 1,470000 71,470 4,431 1,036180250Finance Manager92,909 1,95102,0000 96,861 6,005 1,404180338Utility Billing Clerk35,094 73701800 36,011 2,233 522180126Reception/Utility Billing Clerk30,160 633000 30,793 1,909 447180108 Utility Billing Supv/Finance Asst.52,044 1,09308480 53,985 3,347 783180189 Communications Specialist52,044 1,093700 53,207 3,299 771180186Overtime Pay1,5000 1,500932203DM Discretionary1,0001,000 62 15 0 3Merit 16,352 16,352 1,014 237 0 57TOTAL: 533,886 11,191 16,352 1,500 3,728 0 566,657 35,133 8,217 1,440 1,97722 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 123 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017NO. 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$495$1,486Employee Only3$495$1,486Employee Only5$495$2,477Employee & Spouse0$760$0Employee & Spouse1$760$760Employee & Spouse 0$760$0Employee & Children0$897$0Employee & Children2$897$1,793Employee & Children2$897 $1,793Family3$1,232$3,696Family1$1,232 $1,232Family 1$1,232 $1,232TOTAL6 $5,182TOTAL7$5,271TOTAL8$5,502NO. 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$119$358Employee Only3$119$358Employee Only5$119$597Employee & Spouse0$180$0Employee & Spouse1$180$180Employee & Spouse 0$180$0Employee & Children1$172$172Employee & Children2$172$344Employee & Children2$172 $344Family 2$232 $464Family 1$232 $232Family 1$232 $232TOTAL6 $994TOTAL7$1,113TOTAL8$1,173NO. 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$6,236$24,945Employee Only3$6,236$18,709Employee Only4$6,236$24,945Employee & Spouse0$10,570$0Employee & Spouse1$10,570$10,570Employee & Spouse 0$10,570$0Employee & Children0$9,635$0Employee & Children2$9,635$19,270Employee & Children4$9,635$38,540Family2$13,626$27,252Family1$13,626$13,626Family0$13,626$0TOTAL6 $52,196TOTAL7$62,175TOTAL8$63,485 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL6$249$2,982TOTAL7$357$4,281TOTAL8$422$5,059FOR ALL DEPARTMENTS A 10% INCREASE IN EMPLOYEE BENEFITS IS BUDGETED LIFE & OTHERLIFE & OTHERDENTALVISIONVISIONDENTALLIFE & OTHERDENTALVISIONMEDICALADMINISTRATIONSCHEDULE GF‐IBENEFITS WORKSHEETMEDICALMEDICALWATERWASTEWATER23 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 124 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017Oct‐Dec Jan‐SeptTCDRS TCDRS9.25% 9.25%Water Superintendent80,614 1,864 5,593 7,457Crew Leader55,614 1,286 3,858 5,144Utility Field Worker36,165 836 2,509 3,345Utility Field Worker36,135 836 2,507 3,343Utility Field Worker35,886 830 2,490 3,319Utility Field Worker‐Trainee27,300 631 1,894 2,525Additional Cert Pay Level3007 21 28Overtime Pay20,000 463 1,388 1,850District Manager Discretion1,000 23 69 93Merit7,989 185 554 739TOTAL:301,004 6,961 20,882 27,843Oct‐Dec Jan‐SeptTCDRS TCDRS9.25% 9.25%Wastewater Superintendent77,204 1,785 5,356 7,141Wastewater Shift Supervisor60,692 1,404 4,211 5,614Crew Leader64,053 1,481 4,444 5,925Utility Field Worker57,709 1,335 4,004 5,338Utility Field Worker46,473 1,075 3,224 4,299Crew Leader62,026 1,434 4,303 5,737Utility Field Worker45,257 1,047 3,140 4,186Additional Cert Pay Level3007 21 28Overtime Pay30,000 694 2,081 2,775District Manager Discretion1,000 23 69 93Merit11,967 277 830 1,107TOTAL:456,681 10,561 31,682 42,243Oct‐Dec Jan‐SeptTCDRS TCDRS9.25% 9.25%General Manager122,520 2,833 8,500 11,333District Secretary82,959 1,918 5,755 7,674Administration Manager71,470 1,653 4,958 6,611Finance Manager96,861 2,240 6,720 8,960Utility Billing Clerk36,011 833 2,498 3,331Reception/Utility Billing Clerk30,793 712 2,136 2,848Communications Specialist53,985 1,248 3,745 4,994Vacant 53,207 1,230 3,691 4,922Overtime Pay1,500 35 104 139District Manager Discretion1,000 23 69 93Merit16,352 378 1,134 1,513TOTAL:566,657 13,104 39,312 52,416SCHEDULE GF‐JRETIREMENT WORKSHEETTOTAL FY 2018 SALARYWASTEWATERTCDRS FY 2017 TotalTOTAL FY 2018 SALARYTCDRS FY 2017 TotalWATERADMINISTRATIONTOTAL FY 2018 SALARYTCDRS FY 2017 Total24 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 125 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017SCHEDULE GF‐KELECTRICITY & GAS ANALYSIS FOR FY 2017‐2018Hudson EnergyFY 2017ESID # Expense Acct LocationKWH 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% INCREASE2836193 135‐60020‐010Water Well #1, Well #381,840 $5,779 93,600 $6,431 83,040 $6,099 69,360 $5,150 53760 $4,465 47040 $3,915 43680 $3,747 42000 $3,640 43,920 $3,700 56,400 $4,42465040 $4,902 72480 $5,366 752,16057,618 0.076603701$60,4992770721 135‐60020‐010Elevated Tank‐TW King587 $59 535 $54 562 $59 557 $57 524 $56 584 $59 1637 $151 588 $60 534 $54 583 $59 524 $54 522 $54 7,737 776 0.100246866$8142828381 135‐60020‐010Paluxy Well #413,600 $935 12,240 $858 13,040 $936 13,120 $915 12240 $898 13120 $914 13440 $937 12320 $871 12,320 $865 13,440 $935 12720 $893 12720 $902 154,32010,861 0.070380702$11,4042829590135‐60020‐010Paluxy Well #216,442 $1,12414,753 $1,037 15,686 $1,121 15,710 $1,08414765 $1,078 15843 $1,099 16324$1,141 14938 $1,059 14,984$1,046 16,376 $1,140 15445 $1,078 15363 $1,082 186,629 13,088 0.070129776$13,7432836131 135‐60020‐010Water Plant/Water Barn1,838 $200 1,808 $207 1,563 $192 1,266 $169 877 $146 1606 $335 5015 $602 2901 $431 1,679 $307 1,096 $315 874 $183 1257 $176 21,780 3,262 0.149755739$3,4252836162 135‐60020‐010Water plant pump station77,800 $7,843 23,000 $4,740 12,600 $2,9346,800 $1,489 54800 $5,850 42400 $3,996 33000 $2,960 29000 $4,640 31,600 $3,712 46,400 $5,438 10800 $2,051 57600 $6,302 425,80051,956 0.122020620$54,5548644641 135‐60020‐010100 Municipal Dr, Unit B300 $1,399 596 $5,111 58600 $5,128 55100 $4,889 1800 $1,834500 $1,648 300 $827 300 $58 300 $58 3400 $1,657 37600 $3,787 4400 $1,913 163,19628,308 0.173461482$29,7249130039 135‐60020‐0102901 Bobcat Unit A, Elev Tank982 $92 1025 $96 1047 $98 611 $61 585 $60 587 $60 896 $86 987 $94 1295 $118 1223 $113 1504 $136 1305 $121 12,047 1,136 0.094311447$1,193TOTAL:$175,3562828536135‐60020‐020Sewer Plant129,648 $9,046 122,578 $8,738 127,250$9,602 130765 $9,213 117929 $8,912 131019 $9,266 138072 $9,923 114327 $8,428 106,592 $7,878 97,604$7,415 92062 $7,071 95255 $7,330 1,403,101 102,823 0.073282707$107,9648611313 135‐60020‐020Maintenance Barn2505 $246 3188 $284 2634 $264 1628 $180 1128 $151 1049 $169 6687 $650 6649 $590 2,925 $350 1,181 $254 1145 $170 1749 $242 32,468 3,548 0.109290378$3,7268251800135‐60020‐020310 Skyline‐Lift Sta #6700 $159 400 $87 800 $174 800 $163 900 $191 500 $138 1000 $209 700 $115 800 $193 700 $106 1300 $197 600 $142 9,200 1,873 0.203600000$1,9675437067135‐60020‐020Lift Sta #2 Guard Light70 $12 70 $12 70 $13 70 $12 70 $13 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 70 $12 840 149 0.177059524$1562820941 135‐60020‐020Lift Station Trophy 20282 $33 231 $29 302 $36 230 $29 201 $28 288 $34 269 $33 184 $25 230 $29 244 $30 222 $28 209 $27 2,892 360 0.124598893$3786245046135‐60020‐020Lift Station #21,248 $180 1,096 $162 1,232 $188 1188 $181 1175 $177 1190 $327 1328 $180 1129 $189 1,124 $166 1,221 $282 1171 $309 1161 $160 14,263 2,500 0.175302461$2,6259215255 135‐60020‐020Lift Station #1900 $85 800 $77 800 $80 800 $77 800 $81 900 $87 900 $87 800 $78 900 $85 800 $77 900 $85 700 $69 10,000 968 0.096814000$1,0179843774135‐60020‐020Lift Station #7487 $50 479 $50 274 $34 214 $28 206 $28 194 $26 219 $28 187 $25 196 $26 197 $26 210 $27 217 $28 3,080 376 0.122227273$3958306586135‐60020‐020PID Lift Station #8378 $41 486 $50 612 $61 601 $61 742 $73 413 $45 324 $37 329 $38 334 $38 316 $36 346 $39 290 $34 5,171 553 0.106915490$5810051720135‐60020‐020PID Lift Station #9500 $56 600 $65 700 $74 600 $65 700 $83 800 $76 800 $84 800 $84 900 $92 800 $83 900 $92 700 $74 8,800 930 0.105673864$9760199280135‐60020‐020Lift Station #4 (new)1050 $215 900 $92 1050 $107 1000 $102 900 $94 1050 $107 1150 $117 1000 $103 1000 $101 1100 $111 1000 $101 1000 $102 12,200 1,353 0.110930328$1,421TOTAL: $121,2068797254122‐60020‐045Fire Station (TOWN)0 0 #DIV/0! $0MUD SHARE ONLYMUD SHARE ONLYTOTAL:$0Direct Energy (Split with Town) MUD 1/2 usage2836100135‐60020‐030MUD & PW Bldgs12,480 $426 12,510 $982 12,000 $974 10,470 $882 8,400 $751 9,240 $844 15,300 $1,290 10,680 $962 8,940 $878 9,000 $829 8,550 $753 8,550 $753 126,12010,3240.081861640$10,841TOTAL: $10,841Tri‐CountyMeter #165775/175637135‐60020‐020Lift Station 35377 $439 4260 $321 3708 $282 3492 $267 4414 $331 3485 $285 3096 $280 3578 $319 3412 $315 4007 $365 3831 $370 4867 $450 47,527 4,025 0.084688072$4,226170037 135‐60020‐020Lift Station 5 3541 $299 2950 $230 3160 $256 3045 $237 2719 $226 1716 $154 1587 $156 1975 $188 1831 $181 2061 $201 2127 $217 2460 $217 29,172 2,561 0.087780063$2,689170038 135‐60020‐020Lift Station 5 (Backup)24 $28 24 $27 26 $29 24 $27 28 $29 24 $28 24 $28 24 $28 24 $28 26 $28 25 $28 28 $28 301 335 1.114119601$352TOTAL: $7,267MP2 Energy ‐ Electricity for Construction Trailer at WWTPMeter #134143877LG 135‐60020‐020WWTP (MP2)4197 $350 6081 $495 6606 $610 3626 $418 4063 $444 8724 $741 6000 $553 3681 $375 2699 $343 2264 $266 2657 $264 3813 $326 54,411 5,185 0.095287166$5,444135‐60020‐020WWTP (Engie)4000 $365 4675 $358 7925 $576 8400 $843 13200 $1,442 9200 $878 9000 $1,230 71400 $4,152 69800 $4,377 60400 $4,23470200 $4,338 328,20022,792 0.069445308$23,932Dec 15 Includes $712 in temporary facilities charges.TOTAL:$7,487Atmos ‐ Gas @ Fire Station (Measures by Thousand Cubic Feet)MUD 1/2 usageMeter S/N11N375438122‐60020‐045Fire Station (TOWN)0 0 #DIV/0! $0TOTAL: $0Jun‐17 Jul‐16 Aug‐16 Sept‐16Oct‐16Nov‐16Dec‐16Jan‐17Feb‐17Mar‐17Apr‐17May‐1725 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 126 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017SCHEDULE GF‐LINFORMATION TECHNOLOGYAccountDescriptionAmount135‐55160‐030DescriptionProfessional Outside ServicesM3‐ It & Cell Phone Support$51,075Totals:51,075$ 135‐55030‐030DescriptionSoftware & SupportUsed R For Recurring, NR For Non‐Recurring.R‐Internet Connectivity‐WSC17,000$ R‐Internet Connectivity‐ATT (Backup & WWTP)3,816$ R‐Internet Connectivity‐Pump Room at Water Plant/SCAD1,040$ R‐E‐Fax132$ R‐STW‐Annual Support29,000$ R‐Clear Rec Annual Maintenance600$ R‐Web Hosting‐$ R‐Web Maintenance (Domains, SSL Cert, etc)116$ R‐Mail Chimp240$ R‐Photoshop120$ R‐ Timeclock Plus Support2,460$ Replacement for Connect CTY6,000$ R‐Annual Support for Website‐Four Man Furnace2,000$ R‐Automatic Meter Reading ‐Badger2,500$ R‐Pipelogix Maintenance1,980$ R‐AudioTel Remit Plus Annual Support1,802$ R‐AudioTel Annual Scanner Support585$ R‐SCADA Support (Includes Win‐911)1,000$ VMWare Software & Support (3 yrs support)8,000$ Totals:78,391$ 135‐60005‐030DescriptionTelephoneMain Phone Numbers & Long Distance 10,200$ Afterhours answering service2,500$ WWTP Phone Service (LS + 4 temp ofc phones)7,600$ Phone System Maintenance5,000$ Repairs (Non‐Maintenance)2,000$ Totals:27,300$ 26 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 127 of 28 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1FY 2018 BUDGETDRAFT‐JULY 25, 2017SCHEDULE GF‐LINFORMATION TECHNOLOGYAccountDescriptionAmount135‐60235‐030DescriptionSecurityR‐Access Control System (add cost of keypad)2,700$ Totals:2,700$ 135‐65055‐030DescriptionAmountHardwareR‐A/V Miscellaneous EquipmentReplacement Hardware‐ See List below *Totals:‐$ 122‐65105‐045DescriptionPrintingWe take the average toner yield and divide it bythe page counts to determine the amount of toner needed per device. We have also included a few maintenance kits for the older printers. This includesall supplies for the plotter.Totals:‐$ 135‐65090‐030Printer SuppliesDescriptionToner and CartridgesTotals:‐$ 135‐69170‐030Copier Rental/LeaseDescriptionAmountCopier Lease4,600$ Totals:4,600$ Total:164,066$ 27 of 27DRAFTAugust 2, 2017 Special Meeting Agenda Packet Trophy Club Municipal Utility District No. 128 of 28