Loading...
HomeMy WebLinkAbout2017-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