Loading...
HomeMy WebLinkAboutFY 2018 TCMUD 1 Approved Budget General Fund Fire Fund Revenue Debt Service Fund WWTP Revenue 9,630,723 Revenue 10,100 Revenue 220,954 Revenue 599,738 Revenue 278,684 FY 2018 Tax Collections 120,950 FY 2018 Tax Collections 1,054,433 FY 2018 Tax Collections 673,460 FY 2018 PID Surcharges 177,839 FY 2018 PID Assessment 486,626 PID Surcharge 122,043 Reserve Funds 125,897 Reserve Funds 0         Total Revenue 10,055,410 Total Revenue 1,551,159 Total Revenue 1,016,458 Total Revenue 599,738 Total Revenue 278,684 Water Expense 5,657,433 Fire Expense 1,551,159 Debt Service Expense 1,010,658 Debt Service Expense 598,738 Debt Service Expense 278,084 Wastewater Expense 2,981,140              Board of Directors Expense 12,980              Administration Expense 1,227,111              Non‐Departmental Expense 176,746 Total Expense 10,055,410 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 MUD Tarrant Co.397,692,733 2017 2018 MUD Denton Co.1,137,123,525 O&M (General Fund) Tax 0.00438 0.00788 PID 708,028,353 I & S (Debt Service) Tax 0.04839 0.04363 Out of District & PID 295,974 Fire Tax 0.07445 0.06870 Total Value:2,243,140,585 Total Tax Rate:0.12722 0.120210 Increase/Decrease:‐0.00701 PID Fire Assessment Rate 0.07445 0.06870 Increase/Decrease:‐0.00575 TAX RATE SUMMARY2018 PROPERTY VALUE SUMMARY BUDGET SUMMARY Revenue Debt Service Fund  SWIFTTax Debt Service Fund Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 Budget September 19, 2017 1 of 29 FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 8/31/17General Fund Revenues135‐40000‐000‐000 Property Taxes57,250                  60,977              60,977              120,950                     60,906                99.88% SEE SCHEDULE TAX_ASSESS135‐40002‐000‐000 Property Taxes/Delinquent2,192                     ‐                          ‐                         200                             269                      0.00%135‐40015‐000‐000 Property Taxes/P & I746                       650                    650                    200                             260                      40.00%135‐40025‐000‐000 PID Surcharges146,125               148,291            148,291            177,839                     ‐                           0.00% SEE SCHEDULE TAX_ASSESS135‐47000‐000‐000 Water4,210,866            6,436,734         6,436,734         6,464,019                  5,101,008          79.25% SEE SCHEDULE GF‐D135‐47005‐000‐000 Sewer2,359,115            2,629,524         2,629,524         2,978,067                  2,319,735          88.22% SEE SCHEDULE GF‐E‐2135‐47025‐000‐000Penalties101,584               119,260            119,260            106,279                     107,186              89.88% SEE SCHEDULE GF‐D135‐47030‐000‐000 Service Charges (Disconnect Fees)12,850                  11,400              11,400              21,350                       13,425                117.76% SEE SCHEDULE GF‐D135‐47035‐000‐000 Plumbing Inspections2,600                    2,000                 2,000                 1,500                          2,350                  117.50%135‐47045‐000‐000 Sewer Inspections7,650                    5,500                 5,500                 4,500                          4,650                  84.55%135‐47070‐000‐000 TCCC Effluent Charges45,511                  61,188              61,188              60,000                       71,990                117.65% 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                       16,094                201.15% LESS INTEREST INCOME PROJECTED135‐49016‐000‐000 Cell Tower Revenue10,926                  10,926              10,926              10,926                       10,016                91.67% $910.53 PER MONTH135‐49018‐000‐000 Building Rent Income7,000                    7,000                 7,000                 7,000                          6,417                  91.67% $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,179                       20,521                94.97% 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                          12,338                61.69% 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%135‐00000‐000‐000 Reimbursement from 2.42 Revenue Bond‐Eng260,000                     Total7,164,842            9,545,080         9,840,488         10,250,029               7,747,196          78.73%WaterGeneral Fund Expenses135‐50005‐010‐000 Salaries & Wages219,077               271,143            271,143            274,279                     197,797              72.95% SEE SCHEDULE GF‐H135‐50010‐010‐000 Overtime13,385                  19,500              19,500              20,000                       11,242                57.65% 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,400                  50.00% SEE SCHEDULE GF‐H135‐50020‐010‐000 Retirement20,866                  27,151              27,151              27,843                       19,540                71.97% SEE SCHEDULE GF‐J135‐50026‐010‐000 Medical Insurance38,990                  55,914              55,914              52,196                       27,203                48.65% SEE SCHEDULE GF‐I 135‐50027‐010‐000 Dental Insurance2,944                    4,159                 4,159                 5,182                          2,661                  63.98% SEE SCHEDULE GF‐I135‐50028‐010‐000 Vision Insurance662                       910                    910                    994                             520                      57.12% SEE SCHEDULE GF‐I135‐50029‐010‐000 Life Insurance & Other2,361                    2,803                 2,803                 2,982                          2,328                  83.05% SEE SCHEDULE GF‐I135‐50030‐010‐000 Social Security Taxes14,627                  19,021              19,021              18,662                       13,042                68.57% SEE SCHEDULE GF‐H135‐50035‐010‐000 Medicare Taxes3,421                    4,448                 4,448                 4,365                          3,050                  68.56% SEE SCHEDULE GF‐H135‐50040‐010‐000 Unemployment Taxes859                       1,026                 1,026                 1,080                          47                        4.58% SEE SCHEDULE GF‐H135‐50045‐010‐000 Workman's Compensation12,438                  13,152              13,152              11,854                       10,790                82.04% TML INVOICE AMOUNT135‐50060‐010‐000 Pre‐emp Physicals/Testing236                       1,300                 1,300                 200                             347                      26.69%135‐50070‐010‐000 Employee Relations112                       300                    300                    300                             187                      62.33%135‐55005‐010‐000 Engineering109,670               5,000                 60,000              275,000                     28,762                47.94%135‐55080‐010‐000 Maintenance & Repairs84,225                  100,000            128,500            100,000                     74,934                58.31% ADDITIONAL INFRASTRUCTURE MAINTENANCE 135‐55085‐010‐000 Generator Maintenance & Repairs‐                            3,000                 3,000                 3,000                          2,459                  81.97% MAINTENANCE & REPAIRS ON WATER GENERATOR135‐55090‐010‐000 Vehicle Maintenance6,229                    8,000                 8,000                 4,000                          2,103                  26.29%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                          3,748                  68.15% MONTHLY BAC T; QUARTERLY TCEQ SAMPLES 135‐60010‐010‐000 Communications/Mobiles4,717                    5,400                 5,400                 4,700                          3,524                  65.26% NEW EMPLOYEES & REPLACEMENTS CELL PHONES135‐60020‐010‐000 Electricity150,535               172,737            172,737            175,356                     138,808              80.36% 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                          825                      19.54% 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.30% SEE SCHEDULE GF‐G135‐60105‐010‐000 Rent/Lease Equipment379                       1,500                 1,500                 1,500                           ‐                           0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDEDGENERAL FUND  Account Description% of BudgetCommentsTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20172 of 29 FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 8/31/17GENERAL FUND  Account Description% of BudgetComments135‐60135‐010‐000 TCEQ Fees & Permits ‐ MUD17,788                  50,176              50,176              55,176                       24,978                49.78% 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,823,170                  1,736,537          57.91% SEE SCHEDULE GF‐C135‐60245‐010‐000 Miscellaneous Expenses‐                            200                    200                    200                             103                      51.35%135‐60280‐010‐000 Property Maintenance2,643                    5,000                 5,000                 3,000                          667                      13.33% PROPERTY REPAIRS AFTER LINE BREAKS135‐60285‐010‐000 Lawn Equipment & Maintenance‐                            14,750              14,750              14,750                       6,750                  45.76% MOWING $14,750135‐60332‐010‐000 Interfund Transfer Out‐ Revenue I&S‐                            297,011            297,011            278,084                     240,822              81.08% SEE SCHEDULE GF‐B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS135‐60333‐010‐000 Interfund Transfer Out‐ Bond Reserve ‐                            64,920              64,920              48,996                       43,964                67.72% SWIFT REVENUE BOND RESERVE PER COVENANTS135‐60334‐010‐000 Interfund Transfer Out‐Bank Reserve Account‐                            200,000            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              15,000                       7,694                  30.99% ALL WATER TRUCKS, GAS TANK TRAILER (MISC GAS), AND GM VEHICLE135‐65010‐010‐000 Uniforms2,170                    4,608                 4,608                 4,488                          2,924                  63.45% SEE SCHEDULE GF‐F135‐65030‐010‐000 Chemicals13,070                  20,000              20,000              20,000                       22,833                114.17% 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                          507                      50.70%135‐65050‐010‐000 Meter Expense88,942                  115,000            31,500              50,000                       24,000                76.19%135‐65053‐010‐000 Meter Change Out Program77,325                  81,500              81,500              84,000                       71,160                87.31% 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                     343,088              49.69% SEE SCHEDULE GF‐A135‐69008‐010‐000 Short Term Debt‐Principal130,700               ‐                         ‐                         38,731                       ‐                           0.00% SEE SCHEDULE GF‐B135‐69009‐010‐000 Short Term Debt‐Interest1,178                     ‐                          ‐                         5,713                           ‐                           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                 2,000                          1,503                  30.06% PID PORTION135‐60135‐010‐001 TCEQ Fees & Permits ‐ PID‐                            5,000                 5,000                 ‐                                   Subtotal Water4,777,812            5,336,780         5,524,780         5,657,433                  3,280,830          59.38%Wastewater 135‐50005‐020‐000 Salaries & Wages369,462               391,102            391,102            410,866                     342,452              87.56% SEE SCHEDULE GF‐H135‐50010‐020‐000Overtime35,175                  29,500              29,500              30,000                       28,559                96.81% 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                          7,575                  97.12% SEE SCHEDULE GF‐H135‐50020‐020‐000 Retirement36,694                  39,584              39,584              42,243                       35,083                88.63% SEE SCHEDULE GF‐J135‐50026‐020‐000 Medical Insurance66,679                  73,022              73,022              62,175                       50,425                69.05% SEE SCHEDULE GF‐I 135‐50027‐020‐000 Dental Insurance4,119                    4,592                 4,592                 5,271                          4,065                  88.52% SEE SCHEDULE GF‐I135‐50028‐020‐000 Vision Insurance930                       1,031                 1,031                 1,114                          870                      84.38% SEE SCHEDULE GF‐I135‐50029‐020‐000 Life Insurance & Other4,116                    4,485                 4,485                 4,281                          4,159                  92.73% SEE SCHEDULE GF‐I135‐50030‐020‐000 Social Security Taxes23,597                  27,886              27,886              28,314                       22,446                80.49% SEE SCHEDULE GF‐H135‐50035‐020‐000 Medicare Taxes5,519                    6,522                 6,522                 6,622                          5,250                  80.50% 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                       13,976                123.17% TML INVOICE AMOUNT135‐50060‐020‐000 Pre‐emp Physicals/Testing238                       300                    300                    300                             80                        26.67%135‐50070‐020‐000 Employee Relations722                       650                    650                    350                             461                      70.92%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                       96,989                121.69% CSEP CODED HERE IN CURRENT YEAR135‐55085‐020‐000 Generator Maintenance & Repairs‐                            20,000              20,000              14,000                       6,076                  30.38% MAINTENANCE & REPAIRS ON WW GENERATOR135‐55090‐020‐000 Vehicle Maintenance7,165                    4,000                 6,600                 8,000                          7,782                  117.91%135‐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                       49,945                90.81%135‐55135‐020‐000 Lab Analysis37,393                  25,000              25,000              30,000                       30,265                121.06% INCREASE FOR MORE TESTING 135‐60010‐020‐000 Communications/Pagers/Mobiles5,888                    5,400                 5,400                 4,700                          4,710                  87.22% CELL SERVICE, NEW EMPLOYEES & REPLACEMENT CELL PHONES135‐60020‐020‐000 Electricity131,275               158,627            158,627            266,709                     130,049              81.98% 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% ANNUAL 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.93%135‐60100‐020‐000 Travel & per diem977                       1,600                 2,400                 1,635                          2,486                  103.58% SEE SCHEDULE GF‐G135‐60105‐020‐000 Rent/Lease Equipment8,639                    9,000                 9,000                 5,000                           ‐                           0.00% EMERGENCY EQUIPMENT RENTAL IF NEEDED135‐60125‐020‐000 Advertising‐                             ‐                          ‐                         5,000                          4,086                  0.00%Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20173 of 29 FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 8/31/17GENERAL FUND  Account Description% of BudgetComments135‐60135‐020‐000 TCEQ Fees & Permits18,527                  17,150              17,150              85,000                       18,348                106.99% REG. ASSESSMENT($0),  ANNUAL FEE ($10,000), SOAH (75,000)135‐60245‐020‐000 Miscellaneous Expenses423                       450                    450                    450                             113                      25.17%135‐60280‐020‐000 Property Maintenance‐                            6,622                 6,622                 4,000                           ‐                           0.00% MAINTENANCE FOR WWTP 135‐60285‐020‐000 Lawn Equipment & Maintenance‐                            11,600              11,600              11,600                       5,310                  45.78% MOWING FOR LIFT STATIONS $11,100135‐60331‐020‐000 Interfund Transfer Out‐Tax I&S119,706               120,492            120,492            122,043                     120,492              100.00% TRANSFER OF PID SURCHARGE135‐60332‐020‐000 Interfund Transfer Out‐ Revenue I&S444,838               595,638            595,638            598,738                     595,638              100.00% SEE SCHEDULE GF‐B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS135‐60333‐020‐000 Interfund Transfer Out‐Bond Reserve123,336               123,492            123,492            123,336                     170,139              137.77% 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              12,500                       7,814                  27.82% 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                       23,248                110.70% INCREASE DUE TO MBR CHEMICAL CLEANING MONTHLY135‐65035‐020‐000 Small Tools1,787                    2,000                 2,000                 1,000                          1,682                  84.10%135‐65040‐020‐000 Safety Equipment577                       750                    750                    750                             517                      68.93%135‐65045‐020‐000 Lab Supplies17,349                  14,000              14,000              14,000                       13,096                93.54%135‐69005‐020‐000 Capital Outlays188,556               485,000            462,000            547,327                     200,903              43.49% SEE SCHEDULE GF‐A REMOVED VEHICLES (3), ADDED LEGAL SOAH, WWTP LITIGATION, PREVIOUSLY ADMIN LEGAL135‐69008‐020‐000 Short Term Debt‐Principal21,277                  ‐                         ‐                         51,342                       ‐                           0.00% SEE SCHEDULE GF‐B  3 YR LOAN VACCON,  WWTP ONCALL AND SUPERINTENDENT TRUCKS135‐69009‐020‐000 Short Term Debt‐Interest197                        ‐                          ‐                         7,573                           ‐                           0.00% SEE SCHEDULE GF‐B  3 YR LOAN VACCON,  WWTP ONCALL AND SUPERINTENDENT TRUCKS135‐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,981,140                  2,038,928          76.33%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                               28                        87.50% 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                          145                      12.12%135‐60080‐026‐000 Schools & Training1,875                    4,000                 4,000                 4,000                          3,557                  88.93%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                       6,177                  47.95%Administration 0.00%135‐50005‐030‐000 Salaries & Wages484,728               519,883            519,883            432,863                     381,324              73.35% SEE SCHEDULE GF‐H135‐50010‐030‐000 Overtime901                       1,000                 2,500                 2,000                          3,410                  136.40% SEE SCHEDULE GF‐H135‐50016‐030‐000 Longevity3,823                    3,890                 3,418                 3,548                          3,418                  100.00% SEE SCHEDULE GF‐H135‐50020‐030‐000 Retirement42,642                  47,768              47,768              40,553                       35,208                73.71% SEE SCHEDULE GF‐H135‐50026‐030‐000 Medical Insurance61,243                  84,289              84,289              63,485                       41,327                49.03% SEE SCHEDULE GF‐I 135‐50027‐030‐000 Dental Insurance4,207                    5,981                 5,981                 5,502                          3,664                  61.26% SEE SCHEDULE GF‐I135‐50028‐030‐000 Vision Insurance975                       1,312                 1,312                 1,173                          785                      59.83% SEE SCHEDULE GF‐I135‐50029‐030‐000 Life Insurance & Other4,678                    5,890                 5,890                 5,059                          4,148                  70.42% SEE SCHEDULE GF‐I135‐50030‐030‐000 Social Security Taxes28,227                  32,777              32,777              27,181                       22,911                69.90% SEE SCHEDULE GF‐H135‐50035‐030‐000 Medicare Taxes6,601                    8,084                 8,084                 6,357                          5,358                  66.28% SEE SCHEDULE GF‐H135‐50040‐030‐000 Unemployment Taxes1,349                    1,368                 1,368                 1,260                          294                      21.49% SEE SCHEDULE GF‐H135‐50045‐030‐000 Workman's Compensation2,067                    1,784                 1,784                 1,529                          1,651                  92.54% TML INVOICE AMOUNT135‐50060‐030‐000 Pre‐emp Physicals/Testing147                       500                    500                    500                             607                      121.40%135‐50070‐030‐000 Employee Relations3,421                    4,960                 4,960                 4,960                          2,640                  53.23% CHRISTMAS PARTY, STAFF MEETINGS135‐55005‐030‐000 Engineering4,365                    ‐                         ‐                         ‐                                   ‐                           0.00%135‐55030‐030‐000 Software & Support47,907                  67,791              77,791              78,391                       87,205                112.10% SEE SCHEDULE GF‐L135‐55045‐030‐000 Legal‐                            ‐                         ‐                         ‐                                   ‐                           0.00%135‐55070‐030‐000 Independent Labor1,806                    12,000              4,000                 154,000                     17,455                436.38% VIDEO OF MEETINGS, GMTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20174 of 29 FY 2016 FY 2017 FY 2017 FY 2018 YTD TotalActual Budget Amend #1 Proposed thru 8/31/17GENERAL FUND  Account Description% of BudgetComments135‐55080‐030‐000 Maintenance & Repairs6,284                    7,000                 2,000                 14,000                       826                      41.30% AC PREVENTATIVE MAINT AGREEMENT $600, BUILDING MAINT MERGED, LOSS OF TOWN SHARED EXPENSE135‐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                  ‐                                   6,770                  96.71% RECLASS TO MAINTENANCE & REPAIRS135‐55120‐030‐000 Cleaning Services7,017                    10,429              8,000                 10,000                       6,072                  75.90% CLEANING CONTRACT INCREASE135‐55160‐030‐000 Professional Outside Services69,683                  63,325              60,000              63,325                       61,418                102.36% M3 IT SERVICES $56,475, NEWGEN STRATEGIES135‐55165‐030‐000 Collection Fees‐                            200                    200                    200                             ‐                           0.00%135‐55205‐030‐000 Utility Billing Contract8,516                    8,200                 8,200                 9,000                          6,878                  83.88% COST FOR PRINTING MONTHLY STATEMENTS135‐60005‐030‐000 Telephone13,723                  17,532              17,532              27,300                       12,816                73.10% SEE SCHEDULE GF‐L, PREVIOUSLY SHARED WITH TOWN135‐60010‐030‐000 Communications/Mobiles4,041                    4,150                 3,500                 4,000                          3,005                  85.86% CELL PHONES, ACCESSORIES, GM CELL PHONE & LINE135‐60020‐030‐000 Electricity7,245                    12,631              12,631              16,261                       8,023                  63.52% SEE SCHEDULE GF‐K, 100% OF MUD/ANNEX BILL135‐60025‐030‐000 Water934                       1,500                 1,500                 2,500                          980                      65.33% 100% WATER BILL135‐60035‐030‐000 Postage27,203                  28,932              28,932              30,000                       25,674                88.74%135‐60040‐030‐000 Bank Service Charges & Fees51,500                  55,560              55,560              55,560                       47,591                85.66%135‐60050‐030‐000 Bad Debt Expense3,459                    3,500                 3,500                 1,500                          527                      15.06%135‐60055‐030‐000 Insurance33,573                  55,692              55,692              56,000                       54,950                98.67% TML INVOICE AMOUNT135‐60066‐030‐000 Publications/Books/Subscripts260                       1,600                 1,600                 1,600                          770                      48.13% SALARY STUDY135‐60070‐030‐000 Dues & Memberships5,656                    6,000                 6,000                 6,000                          4,851                  80.85%135‐60075‐030‐000 Meetings163                       400                    400                    400                             122                      30.50%135‐60079‐030‐000 Public Education4,230                    8,754                 8,754                 6,000                          4,972                  56.80% ADDITIONAL CUSTOMER EDUCATION MATERIALS, WATERFEST135‐60080‐030‐000 Schools & Training3,382                    7,840                 7,840                 7,600                          2,255                  28.76% SEE SCHEDULE GF‐G135‐60100‐030‐000 Travel & per diem3,562                    5,400                 7,500                 4,885                          7,112                  94.83% SEE SCHEDULE GF‐G135‐60110‐030‐000 Physicals/Testing‐                            200                    200                    200                             ‐                           0.00%135‐60115‐030‐000 Elections3,610                    7,500                 7,500                 4,500                          2,970                  39.60% MUD BOARD ELECTION135‐60125‐030‐000 Advertising1,549                    7,500                 7,500                 2,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 5,448                    17,500              17,500              500                             161                      0.92% SPLIT MISCELLANEOUS & GM CONTINGENCY135‐60246‐030‐000 General Manager Contingency 17,000                        ‐                           0.00% SPLIT MISCELLANEOUS & GM CONTINGENCY135‐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,056                  42.24%135‐65010‐030‐000 Uniforms23                          1,855                 855                    700                             142                      16.65% SEE SCHEDULE GF‐F135‐65055‐030‐000 Hardware IT7,238                    9,444                 9,444                 7,420                          2,300                  24.36% SEE SCHEDULE GF‐L     135‐65085‐030‐000 Office Supplies5,632                    9,000                 9,000                 7,000                          5,125                  56.94% ALL DEPARTMENTS COMBINED.135‐65090‐030‐000 Printer Supplies & Maintenance1,302                    2,000                 2,000                 2,000                          754                      37.70% SEE SCHEDULE GF‐L135‐65095‐030‐000 Maintenance Supplies3,632                    5,000                 4,000                 4,000                          3,684                  92.10%135‐65105‐030‐000 Printing3,232                    4,800                 2,500                 4,000                          2,554                  102.16%135‐69005‐030‐000 Capital Outlays24,907                  107,001            265,424            13,000                       119,756              45.12% SEE SCHEDULE GF‐A135‐69170‐030‐000 Copier Lease Installments3,888                    4,600                 4,600                 4,600                          3,365                  73.15% SEE SCHEDULE GF‐LSubtotal Administration1,017,525            1,295,172         1,443,019         1,227,111                  1,011,065          70.07%Non Departmental 135‐55045‐039‐000 Legal338,721               150,000            150,000            137,000                     151,326              100.88% REDUCED DUE TO ROLLBACK RATE135‐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‐000Tax Admin Fees2,469                    3,800                 3,800                 3,800                          2,562                  67.41%Subtotal Non Departmental380,317               188,775            188,775            176,746                     181,364              96.07%Total General Fund Revenues7,164,842            9,545,080         9,840,488         10,250,029               7,747,196           Total General Fund Expenses8,178,601            9,531,625         9,840,488         10,055,410               6,518,365          Net Budget Surplus (Deficit)(1,013,759)          13,456              (0)                       194,619                     1,228,831          Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20175 of 29 AccountDescriptionFY 2015 FY 2015 FY 2016 FY 2016 FY2017 FY 2018 YTD TotalBudget Actual Budget Actual Budget Proposed thru 6/30/17Revenues‐Town122‐40001‐000‐000 Assessment ‐ Emerg Svcs357,462            356,903            404,346          403,838          472,439          486,626            SEE SCHEDULE TAX_ASSESS122‐40003‐000‐000 Emer Svcs Assessmen/Delinquent8,402                ‐                       346                 ‐                       ‐                         122‐40015‐000‐000 Property Taxes/Assessments P&I750                    3,337                ‐                       ‐                       750                  ‐                         122‐42014‐000‐000 Fire Permits/Sprinkler & Plan Review6,000                8,400                5,000              5,200              5,000               100                    122‐43400‐000‐000 Fire Inspections950                    1,575                825                 1,075              825                  ‐                         122‐43415‐000‐000 Denton/Tarrant Cty Pledge‐Fire10,000              10,000              10,000            10,000            10,000             10,000              Revenues‐MUD122‐40001‐000‐000 Assessment‐Emerg Svcs Reimb from Town‐                     ‐                    112                  122‐40010‐000‐000 Property Taxes/MUD Fire872,859            873,241            889,963          875,978          1,035,810       1,054,433         1,029,872      SEE SCHEDULE TAX_ASSESS122‐40011‐000‐000Property Taxes/Fire‐Delinquent‐                     4,255                 ‐                       18,076            ‐                       ‐                         2,874              122‐40020‐000‐000 Property Taxes/Fire P&I4,500                4,284                4,500              7,621              4,500               ‐                         3,542              122‐49000‐000‐000 Capital Leases‐Other Financial Sources807,316            807,316            ‐                       122‐49026‐000‐000 Proceeds from Sale of Assets‐                     ‐                    60,000            60,000            ‐                       ‐                         122‐49035‐000‐000 Prior Year Reserves198,468            125,670            ‐                       ‐                       122‐49036‐000‐000 GASB Reserves‐                     ‐                    ‐                       36,182            ‐                       ‐                         ‐                        122‐49900‐000‐000 Miscellaneous 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‐000 Salaries & Wages469,067            473,429            508,226          511,904          551,224          558,792            122‐50010‐045‐000 Overtime46,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‐000 Longevity5,505                5,319                5,761              5,730              5,618               5,879                122‐50017‐045‐000 Certification4,800                5,129                4,200              4,740              5,400               4,950                122‐50020‐045‐000 Retirement75,327              73,277              75,571            71,888            80,434             81,248              122‐50026‐045‐000 Medical Insurance59,169              57,289              65,546            56,876            68,414             85,723              122‐50027‐045‐000 Dental Insurance4,390                4,362                4,885              5,016              4,797               4,285                122‐50028‐045‐000 Vision Insurance811                    761                   859                 968                 479                  433                    122‐50029‐045‐000 Life Insurance & Other4,030                3,808                4,585              4,016              3,684               3,746                122‐50030‐045‐000 Social Security Taxes33,421              30,862              36,132            32,993            37,974             37,565              122‐50035‐045‐000 Medicare 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‐000 Workman's Compensation8,692                7,908                9,379              9,379              9,969               10,139              122‐50060‐045‐000 Pre‐employment Physicals/Test250                    183                   250                 54                    700                  4,600                122‐50075‐045‐000 Tuition Reimbursement300                    ‐                    ‐                  ‐                       1,300               5,075                122‐55030‐045‐000 Software & 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‐000 Maintenance & Repairs/Equipment14,552              15,885              25,218            54,653            21,370             17,240              122‐55085‐045‐000 Generator Maintenance & Repairs‐                     ‐                    ‐                  ‐                       2,000               ‐                         122‐55090‐045‐000 Vehicle Maintenance16,000              15,493              10,000            14,808            20,000             46,000              122‐55100‐045‐000 Building Maintenance‐                     ‐                    ‐                  ‐                       ‐                       16,750              122‐55160‐045‐000Professional Outside Services27,438              24,694              ‐                  2,744              ‐                       2,723                Comments FIRE DEPARTMENT Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20176 of 29 AccountDescriptionFY 2015 FY 2015 FY 2016 FY 2016 FY2017 FY 2018 YTD TotalBudget Actual Budget Actual Budget Proposed thru 6/30/17Comments FIRE DEPARTMENT 122‐60005‐045‐000 Telephone75                      63                     50                    59                    50                    ‐                         122‐60010‐045‐000 Communications/Mobiles6,413                4,693                7,706              6,835              8,931               13,245              122‐60020‐045‐000 Electricity/Gas9,026                6,343                7,412              5,686              6,673               8,140                122‐60025‐045‐000 Water2,200                1,576                1,200              2,027              1,200               4,648                122‐60026‐045‐000 Cable1,920                1,848                1,920              1,920              1,920               ‐                         122‐60035‐045‐000 Postage100                    16                     50                    46                    50                    50                      122‐60066‐045‐000Publications/Books/Subscrips220                    219                   350                 172                 350                  350                    122‐60070‐045‐000 Dues & Memberships15,689              15,633              15,582            15,457            15,582             19,295              122‐60080‐045‐000 Schools & Training4,280                4,013                6,880              3,743              7,880               15,670              122‐60096‐045‐000 Emergency Management1,400                1,220                1,000              1,000              1,000               1,000                122‐60100‐045‐000 Travel & per diem13,577              8,691                2,081              1,147              4,081               7,066                122‐60110‐045‐000 Physicals/Testing2,000                ‐                    4,700              6,804              8,085               ‐                         122‐60125‐045‐000 Advertising5,100                826                   4,700              4,200              500                  500                    122‐60160‐045‐000 Programs & Special Projects4,500                3,949                7,500              3,671              7,500               13,750              122‐60180‐045‐000 Fire Inspection/Enforcement1,000                194                   500                 359                 500                  ‐                         122‐60195‐045‐000 Flags & Repair2,000                792                   3,184              2,355              3,050               3,500                122‐60243‐045‐000Prior Year Expense‐                     ‐                    ‐                  ‐                       ‐                       ‐                         122‐60245‐045‐000 Miscellaneous Expense1,000                729                   1,001              1,119              1,000               6,000                122‐60280‐045‐000 Property Maintenance‐                     ‐                    ‐                  ‐                       12,000             ‐                         122‐65005‐045‐000 Fuel8,829                5,576                15,122            4,729              21,111             13,613              122‐65010‐045‐000 Uniforms3,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‐000 Chemicals200                    134                   600                 1,191              1,500               ‐                         122‐65035‐045‐000 Small Tools/Equipment2,500                1,446                2,000              1,868              6,000               5,000                122‐65055‐045‐000 Hardware 9,000                6,161                750                 394                 750                  1,100                122‐65085‐045‐000 Office Supplies500                    230                   500                 328                 500                  250                    122‐65095‐045‐000 Maintenance & Supplies‐                     ‐                    ‐                  ‐                       ‐                       1,500                122‐65105‐045‐000 Printing548                    38                     498                 ‐                       498                  250                    122‐00000‐045‐000 Printer Supplies‐                     ‐                    ‐                  ‐                       ‐                       1,400                122‐69050‐045‐000 Radios23,500              23,491              8,000              7,934              29,000             ‐                         122‐69255‐045‐000 Airpacks10,400              10,235              ‐                  ‐                       11,050             ‐                          Expenses‐MUD 122‐55080‐045‐000 Maintenance & 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‐000 Insurance12,179              11,281              18,451            9,072              16,513             18,000              12,385            TML INVOICE 122‐60337‐045‐000 Transfer to Town/Fire Budget‐                     ‐                    ‐                         434,711          122‐69005‐045‐000 Capital Outlays1,057,316         1,057,316         ‐                  7,918              16,836             ‐                         ‐                        122‐69008‐045‐000Short Term Debt ‐Principal‐                     ‐                    ‐                  ‐                       ‐                       ‐                         ‐                        122‐69009‐045‐000 Short Term Debt ‐Interest‐                     ‐                    ‐                  ‐                       ‐                       ‐                         ‐                          122‐69195‐045‐000 GASB34/Reserve for Replacement17,950              17,950              81,420            81,420            81,420             81,420              81,420            ANNUAL RESERVE FOR NEW FIRE ENGINE122‐69305‐045‐000 Capital 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        Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20177 of 29 AccountDescriptionFY 2015 FY 2015 FY 2016 FY 2016 FY2017 FY 2018 YTD TotalBudget Actual Budget Actual Budget Proposed thru 6/30/17Comments FIRE DEPARTMENT 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,626            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,910            Monthly payment to Town Oct 17‐Sept 1850,743               Town/MUD Fire Contract Calculation FY 2018 Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20178 of 29 AccountDescriptionOriginal Amend #1 PROPOSED YTD TotalBudget Budget FY 2018 thru 6/30/17CommentsDebt Service Revenues533‐40000‐000‐000 Property Taxes673,336            673,336          669,660                    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‐000Premium on Bonds Sold‐                        ‐                       ‐                                 ‐                              533‐49141‐000‐000 Interfund Transfer In‐PID Surchg120,492            120,492          122,043                    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)Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 20179 of 29 FY 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 Fees200                    200                  400                            ‐                              534‐70040‐051‐000Bond Interest Expense‐Rev Bonds230,638            230,638          223,338                    115,519                 See Schedule GF‐B2 (Long Term Debt)534‐70045‐051‐000 Bond Principal Payment‐Rev Bonds365,000            365,000          375,000                    ‐                              See Schedule GF‐B2 (Long Term Debt)Total595,838            595,838          598,738                    115,519                 Total Debt Service Fund Revenues595,838            595,838          599,738                     Total Debt Service Fund Expenses595,838            595,838          598,738                    Net Budget Surplus (Deficit)‐                        ‐                       1,000                        REVENUE DEBT SERVICE FUND (I&S) ‐ WWTPAccountDescriptionCommentsTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201710 of 29 FY 2017 FY 2017 PROPOSED YTD TotalBudget Amended FY 2018 thru 6/30/17Debt Service Revenues535‐49010‐000‐000 Interest Income200                    200                  600                            441                         535‐49142‐000‐000 Interfund Transfer In‐Water Sales240,422            240,422          278,084                    197,036                 Water Sales Revenue Transfer for Revenue Debt PaymentTotal240,622            240,622          278,684                    197,477                 Debt Service Expenses535‐70005‐051‐000 Paying Agent Fees200                    200                  400                            ‐                              535‐70040‐051‐000Bond Interest Expense‐Rev Bonds50,422              50,422            62,684                      ‐                              See Schedule GF‐B2 (Long Term Debt)535‐70045‐051‐000 Bond Principal Payment‐Rev Bonds190,000            190,000          215,000                    ‐                              See Schedule GF‐B2 (Long Term Debt)Total240,622            240,622          278,084                    ‐                              Total Debt Service Fund Revenues240,622            240,622          278,684                     Total Debt Service Fund Expenses240,622            240,622          278,084                    Net Budget Surplus (Deficit)0                       ‐                       600                            FY 2017 originally budgeted both Revenue Bonds together.  Created separate funds 534 and 535 in FY 2017.REVENUE DEBT SERVICE FUND (I&S) ‐ SWIFTCommentsAccount DescriptionTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201711 of 29 AccountDescriptionOriginal 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            48,996            118,022          528‐49143‐000‐000 Interfund transfer In‐WW123,492            123,492          123,336          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*Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201712 of 29 FIRE TAX/ASSESSMENT RATENET TAX VALUE:OVERALL TAX RATE FY 2018:$0.12020970TARRANT COUNTY:$397,692,733 42,941 CertifiedDENTON COUNTY:$1,137,123,525 42,934 CertifiedDENTON CO. PID:$708,028,353 42,934 CertifiedOUT OF DISTRICT & PID$295,974 42,934 CertifiedREQUIRED REVENUETAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100FIREVals/100 =22,431,406FY 2018 Tax/Assess Rate =0.06870$1,541,059TAX COMPARISON TO FY 2017Revenue from MUD Tax =1,054,433$      2017 2018Revenue from PID Assess =486,626$         O&M (General Fund) Tax0.00438 0.00788Total: 1,541,059$      I & S (Debt Service) Tax0.04839 0.04363Fire Tax0.07445 0.06870Total Tax Rate:0.12722 0.120210O&M TAX/SURCHARGE RATENET TAX VALUE:Increase/Decrease:‐0.00701TARRANT COUNTY:397,692,733PID Fire Assessment Rate0.07445 0.06870DENTON COUNTY:1,137,123,525Increase/Decrease:‐0.00575DENTON CO. PID:708,028,353REQUIRED REVENUETAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100MAX ROLLBACK RATE0.120263O&MVals/100 =22,428,446FY 2018 Tax/Surcharge Rate =0.00788176,746                                                                Revenue from MUD Tax =120,950$         Revenue from PID Surcharge =55,796$             Total: 176,746$         I&S TAX/SURCHARGE RATENEW DEBT: CALCULATE AMOUNT DUE FROM PIDNET TAX VALUE:TARRANT COUNTY:$397,692,733DENTON COUNTY:$1,137,123,525DENTON CO. PID:$708,028,353REQUIRED REVENUETAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100TAX DEBT 2014 AND AFTER (I&S)Vals/100 =22,428,446NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHAREFY 2018 PID Surcharge Rate = 0.01723704$386,600 Revenue from MUD Tax =264,557$         Revenue from PID Surcharge = 122,043$         Total: 386,600$         MUD DEBT: CALCULATE MUD TAXNET TAX VALUE:TARRANT COUNTY:DENTON COUNTY:$397,692,733$1,137,123,525 REQUIRED REVENUEI&S MUD DEBTTAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100Vals/100 =15,348,163$669,660FY 2018 Tax Rate =0.04363 Revenue from MUD Tax =669,660$         Revenue from PID = N/A Total: 669,660$         SCHEDULE TAX_ASSESSTAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONSTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201713 of 29 FYBond 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,259Total$2,123,892$953,344$3,077,236*Based on ave. rate of 3.9% for 20 yearsSCHEDULE FD‐B RENT CALCULATION FOR FIRE STATIONTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201714 of 29    WATER ‐  PURCHASESWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ PURCHASESDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTBEACON METER SOFTWARE11,012 INDIAN CREEK AND PHOENIX (TOWN)410,000 AGENDA SOFTWARE13,000SUNDANCE CT/MEADOWBROOK LN (TOWN)169,000PORTLAND DRIVE (MUD)70,000SCADA PANEL WATER PLANT & ELEVATED TANK EAST50,000PUMP DISCHARGE HEAD50,000  VALVE REPLACEMENTS50,000Total: $11,012Total: $799,000Total:$13,000WASTEWATER ‐  PURCHASESWASTEWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ MAINTENANCE & REPAIRSDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTSMART COVER MANHOLES (5), STUDY & INSTALL30,000 LIFT STATION 1 RELOCATION STUDY10,000LEGAL/WWTP175,000CP&Y ENGINEERING/WWTP332,327Total: $537,327Total:$10,000Total:$0SCHEDULE GF ‐ AFY 2018 CAPITAL OUTLAYSTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201715 of 29  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 PAYMENTSTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201716 of 29 LONG 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 Principal FY 18 Interest 3/1 Interest 9/01 Subtotal InterestTotalPayoff DateProject/ReasonDepartmentVaccon, 2 WWTP Vehicles (Water 43%)$193,657$193,657 $38,731 $2,856 $2,856$5,713$44,444Vaccon, 2 WWTP Vehicles (WW 57%)$256,708$256,708 $51,342 $3,787 $3,787$7,573$58,915Total:$450,365$450,365 $90,073 $6,643 $6,643$13,286$103,359 SCHEDULE GF ‐ B2REVENUE DEBT PAYMENTSTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201717 of 29 ANNUALIZE GROWTH IN WATER METERS =1.00%PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2017 =4,700  4376                                        100,272,333 OCT 4,704 22,912 107,778,0564386                                          50,924,333 1 NOV 4,708 11,611 54,661,0674404                                          41,774,667 2 DEC 4,712 9,485 44,690,5764413                                          39,183,333 3 JAN 4,716 8,880 41,874,0694428                                          41,660,333 4 FEB 4,720 9,409 44,407,3124451                                          45,383,667 5 MAR 4,724 10,197 48,166,2614466                                          61,529,333 6 APR 4,727 13,778 65,136,7514483                                          58,334,667 7 MAY 4,731 13,011 61,562,6974511                                          80,872,333 8 JUN 4,735 17,926 84,888,4824506                                        112,761,333 9 JUL 4,739 25,027 118,608,7194533                                        134,295,333 10 AUG 4,743 29,628 140,534,9594522                                        117,311,667 11 SEP 4,747 25,942 123,154,317AVERAGE4,72616,484TOTAL935,463,267CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)16,484PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY18 =(METERS)47PROJECTED TOTAL OF ADDITIONAL GALLONS IN FY18 =(GALLONS)774,746Growth Rate Meters set May 2016 through April 2017:4 per monthGrowth Rate = Ave.New Meters Set/TotalMeters at April 2017(4*12)/4700*100%=1.01%1% recommendedPurchased Water (gallons): 935,463,267Increases$2.37$2,217,1412.02%$50,477.37$605,7283.90%$25$300                     Total: $2,823,170      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 COMPLETE FISCAL YEARS (GALLONS)PROJECTED MONTHY WATER USE (GALLONS)AVG METERS FOR LAST THREE YEARS COMBINEDAVG WATER USE FOR LAST THREE YEARS COMBINEDTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201718 of 29 Beginning 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 % Consumption Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By 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.66% 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.52% 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.31% 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     4.99% 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.60% 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.22% 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     3.87% 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.56% 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.29% 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.17% 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.75% 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.43% 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.24% 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.86% 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.51% 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.76% 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.32% 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.22% 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.41% 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.24% 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.06% 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  100.00% Beginning 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 % Consumption Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By 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     6.09% 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.92% 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.62% 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     5.18% 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.67% 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     4.17% 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.73% 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.38% 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     3.09% 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  12.10% 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     5.25% 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     4.13% 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     5.04% 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.85% 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.60% 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.88% 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.40% 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.29% 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.46% 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.23% 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  18.95% 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  100.00% Beginning 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 % Consumption Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By 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 REVENUE Projected Number of Meters ‐ Oct 1st FY18 4,700                      Projected Growth Rate 1.00% Projected Meters 4,704                   4,708                               4,712                      4,716                      4,720                    4,724                    4,728                    4,732                    4,736                    4,740                      4,744                     4,748                    4,748                     Projected Average Consumption Per Meter 22,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                  Total Projected Consumption 107,344,849      54,792,579                    44,651,446           41,916,085           44,366,111         48,230,500         65,266,111         61,974,395         85,285,689         118,162,034         140,339,243        123,305,203       78,528,211          Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue ‐               1,000           1,000            4.25% 4,561,898            3.96                      18,065$               8.29% 4,542,347         3.96                    17,988$                          10.08% 4,499,206                    3.96                    17,817$                 10.74% 4,502,547         3.96                    17,830$                 10.15% 4,503,312         3.96                   17,833$                9.37% 4,517,657       3.96                  17,890$                6.96% 4,543,821       3.96                  17,994$                7.39% 4,578,918       3.96                  18,133$                5.40% 4,605,315       3.96                  18,237$                3.89% 4,594,321         3.96                    18,194$                 3.29% 4,623,449         3.96                    18,309$                3.77% 4,643,018       3.96                  18,386$                54,715,810       3.96                  216,675$               1,000          2,000           1,000            4.18% 4,491,600            3.96                      17,787                 8.00% 4,381,670         3.96                    17,351                             9.70% 4,329,613                    3.96                    17,145                   10.36% 4,342,442         3.96                    17,196                   9.79% 4,344,990         3.96                   17,206                 9.01% 4,347,975       3.96                  17,218                 6.75% 4,403,097       3.96                  17,436                 7.12% 4,413,184       3.96                  17,476                 5.28% 4,500,210       3.96                  17,821                 3.83% 4,520,968         3.96                    17,903                   3.25% 4,563,535         3.96                    18,072                  3.71% 4,569,442       3.96                  18,095                 53,208,727       3.96                  210,707                2,000          3,000           1,000            4.10% 4,397,750            3.96                      17,415                 7.42% 4,065,697         3.96                    16,100                             8.98% 4,009,666                    3.96                    15,878                   9.66% 4,048,263         3.96                    16,031                   9.11% 4,040,770         3.96                   16,001                 8.33% 4,015,341       3.96                  15,901                 6.41% 4,180,343       3.96                  16,554                 6.67% 4,132,712       3.96                  16,366                 5.12% 4,363,818       3.96                  17,281                 3.74% 4,424,562         3.96                    17,521                   3.21% 4,498,397         3.96                    17,814                  3.64% 4,491,311       3.96                  17,786                 50,668,630       3.96                  200,648                3,000          4,000           1,000            3.99% 4,278,564            3.96                      16,943                 6.65% 3,641,768         3.96                    14,421                             7.87% 3,513,713                    3.96                    13,914                   8.50% 3,562,243         3.96                    14,106                   8.03% 3,564,738         3.96                   14,116                 7.28% 3,509,128       3.96                  13,896                 5.85% 3,816,512       3.96                  15,113                 6.04% 3,744,230       3.96                  14,827                 4.92% 4,195,790       3.96                  16,615                 3.65% 4,315,581         3.96                    17,090                   3.16% 4,428,381         3.96                    17,536                  3.56% 4,392,158       3.96                  17,393                 46,962,807       3.96                  185,973                4,000          5,000           1,000            3.87% 4,152,955            3.96                      16,446                 5.75% 3,152,923         3.96                    12,486                             6.46% 2,882,370                    3.96                    11,414                   7.05% 2,957,125         3.96                    11,710                   6.79% 3,011,674         3.96                   11,926                 6.14% 2,959,344       3.96                  11,719                 5.24% 3,421,920       3.96                  13,551                 5.39% 3,340,521       3.96                  13,228                 4.64% 3,957,457       3.96                  15,672                 3.55% 4,189,833         3.96                    16,592                   3.09% 4,340,949         3.96                    17,190                  3.46% 4,271,633       3.96                  16,916                 42,638,705       3.96                  168,849                5,000          6,000           1,000            3.73% 4,008,076            3.96                      15,872                 4.98% 2,727,202         3.96                    10,800                             5.14% 2,296,989                    3.96                    9,096                      5.58% 2,338,814         3.96                    9,262                      5.55% 2,460,386         3.96                   9,743                    5.07% 2,445,337       3.96                  9,684                    4.64% 3,031,217       3.96                  12,004                 4.73% 2,929,728       3.96                  11,602                 4.36% 3,718,420       3.96                  14,725                 3.44% 4,063,387         3.96                    16,091                   3.04% 4,262,922         3.96                    16,881                  3.37% 4,152,859       3.96                  16,445                 38,435,339       3.96                  152,204                6,000          7,000           1,000            3.60% 3,859,985            4.61                      17,795                 4.30% 2,356,354         4.61                    10,863                             4.06% 1,812,794                    4.61                    8,357                      4.32% 1,808,935         4.61                    8,339                      4.42% 1,962,700         4.61                   9,048                    4.21% 2,032,645       4.61                  9,370                    4.11% 2,679,762       4.61                  12,354                 4.13% 2,562,494       4.61                  11,813                 4.05% 3,457,590       4.61                  15,939                 3.33% 3,935,894         4.61                    18,144                   2.98% 4,176,535         4.61                    19,254                  3.27% 4,035,838       4.61                  18,605                 34,681,525       4.61                  159,882                7,000          8,000           1,000            3.43%3,686,916            4.61                      16,997                 3.76% 2,059,030         4.61                    9,492                               3.26% 1,453,655                    4.61                    6,701                      3.36% 1,407,781         4.61                    6,490                      3.60% 1,597,423         4.61                   7,364                    3.55% 1,714,535       4.61                  7,904                    3.63% 2,372,150       4.61                  10,936                 3.69% 2,286,980       4.61                  10,543                 3.76% 3,207,305       4.61                  14,786                 3.21% 3,798,619         4.61                    17,512                   2.91% 4,081,440         4.61                    18,815                  3.17% 3,903,751       4.61                  17,996                 31,569,584       4.61                  145,536                8,000          9,000           1,000            3.28% 3,523,838            4.61                      16,245                 3.29% 1,804,745         4.61                    8,320                               2.66% 1,186,083                    4.61                    5,468                      2.63% 1,100,765         4.61                    5,075                      2.97% 1,316,631         4.61                   6,070                    3.00% 1,446,019       4.61                  6,666                    3.24% 2,115,099       4.61                  9,751                    3.32% 2,058,565       4.61                  9,490                    3.49% 2,973,541       4.61                  13,708                 3.09% 3,655,756         4.61                    16,853                   2.84% 3,990,176         4.61                    18,395                  3.06% 3,768,511       4.61                  17,373                 28,939,729       4.61                  133,412                9,000          14,000        5,000            14.01% 15,042,774          4.61                      69,347                 11.22% 6,150,191         4.61                    28,352                             8.23% 3,674,043                    4.61                    16,937                   7.35% 3,079,789         4.61                    14,198                   8.95% 3,972,968         4.61                   18,315                 9.57% 4,615,074       4.61                  21,275                 11.56% 7,545,338       4.61                  34,784                 12.23% 7,578,410       4.61                  34,936                 13.61% 11,608,024     4.61                  53,513                 13.35% 15,773,614       4.61                    72,716                   12.93% 18,150,685       4.61                    83,675                  13.52% 16,668,897     4.61                  76,844                 113,859,807    4.61                  524,894                14,000        17,000        3,000            6.39% 6,854,623            4.61                      31,600                 3.96% 2,169,495         4.61                    10,001                             2.84% 1,267,673                    4.61                    5,844                      2.27% 951,714             4.61                    4,387                      2.81% 1,246,700         4.61                   5,747                    3.30% 1,589,841       4.61                  7,329                    4.26% 2,780,178       4.61                  12,817                 4.82% 2,984,265       4.61                  13,757                 5.60% 4,775,102       4.61                  22,013                 6.23% 7,365,654         4.61                    33,956                   6.53% 9,162,252         4.61                    42,238                  6.53% 8,056,260       4.61                  37,139                 49,203,756       4.61                  226,829                17,000        20,000        3,000            4.95% 5,310,558            5.34                      28,358                 2.76% 1,513,159         5.34                    8,080                               2.06%919,580                        5.34                    4,911                      1.64% 685,348             5.34                    3,660                      1.96% 871,128             5.34                   4,652                    2.31% 1,112,322       5.34                  5,940                    2.99% 1,951,393       5.34                  10,420                 3.49% 2,161,972       5.34                  11,545                 4.15% 3,535,628       5.34                  18,880                 4.95% 5,845,158         5.34                    31,213                   5.51% 7,731,292         5.34                    41,285                  5.29% 6,519,565       5.34                  34,814                 38,157,103       5.34                  203,759                20,000        25,000        5,000            5.77% 6,192,320            5.34                      33,067                 3.05% 1,671,326         5.34                    8,925                               2.40% 1,072,427                    5.34                    5,727                      1.97% 825,841             5.34                    4,410                      2.25% 997,502             5.34                   5,327                    2.58% 1,243,746       5.34                  6,642                    3.29% 2,147,628       5.34                  11,468                 3.96% 2,455,192       5.34                  13,111                 4.76% 4,062,914       5.34                  21,696                 6.03% 7,124,638         5.34                    38,046                   7.04% 9,885,744         5.34                    52,790                  6.46% 7,966,567       5.34                  42,541                 45,645,845       5.34                  243,749                25,000        29,000        4,000            3.09% 3,317,225            6.20                      20,567                 1.64% 896,993             6.20                    5,561                               1.40%625,286                        6.20                    3,877                      1.18% 496,004             6.20                    3,075                      1.27% 564,423             6.20                   3,499                    1.48% 714,508           6.20                  4,430                    1.75% 1,139,933       6.20                  7,068                    2.13% 1,318,785       6.20                  8,176                    2.52% 2,149,921       6.20                  13,330                 3.34% 3,941,133         6.20                    24,435                   4.07% 5,714,782         6.20                    35,432                  3.64% 4,484,303       6.20                  27,803                 25,363,294       6.20                  157,252                29,000        34,000        5,000            2.66% 2,855,469            6.20                      17,704                 1.53% 840,684             6.20                    5,212                               1.38%617,447                        6.20                    3,828                      1.23% 516,329             6.20                    3,201                      1.24% 550,223             6.20                   3,411                    1.39% 671,290           6.20                  4,162                    1.56% 1,018,302       6.20                  6,313                    1.84% 1,140,303       6.20                  7,070                    2.18% 1,859,913       6.20                  11,531                 2.92% 3,452,115         6.20                    21,403                   3.70% 5,189,145         6.20                    32,173                  3.28% 4,044,247       6.20                  25,074                 22,755,467       6.20                  141,084                34,000        39,000        5,000            1.79% 1,916,254            6.20                      11,881                 1.20% 656,336             6.20                    4,069                               1.11%493,459                        6.20                    3,059                      1.00% 420,409             6.20                    2,607                      1.02% 451,893             6.20                   2,802                    1.13% 545,180           6.20                  3,380                    1.13% 734,733           6.20                  4,555                    1.32% 816,273           6.20                  5,061                    1.55% 1,318,918       6.20                  8,177                    2.01% 2,370,688         6.20                    14,698                   2.62% 3,671,450         6.20                    22,763                  2.27% 2,795,901       6.20                  17,335                 16,191,493       6.20                  100,387                39,000        44,000        5,000            1.30% 1,390,979            6.20                      8,624                   1.00% 548,740             6.20                    3,402                               0.94%418,282                        6.20                    2,593                      0.84% 350,876             6.20                    2,175                      0.81% 360,663             6.20                   2,236                    0.98% 473,268           6.20                  2,934                    0.92% 600,728           6.20                  3,725                    1.01% 623,625           6.20                  3,866                    1.13% 964,582           6.20                  5,980                    1.45% 1,715,055         6.20                    10,633                   1.89% 2,651,177         6.20                    16,437                  1.65% 2,029,656       6.20                  12,584                 12,127,630       6.20                  75,191                  44,000        50,000        6,000            1.20% 1,291,777            6.20                      8,009                   0.99% 542,284             6.20                    3,362                               0.98%439,303                        6.20                    2,724                      0.88% 368,348             6.20                    2,284                      0.87% 384,091             6.20                   2,381                    1.00% 482,833           6.20                  2,994                    0.94% 614,871           6.20                  3,812                    0.99% 610,522           6.20                  3,785                    1.07% 909,744           6.20                  5,640                    1.25% 1,481,723         6.20                    9,187                      1.65% 2,315,034         6.20                    14,353                  1.47% 1,807,175       6.20                  11,204                 11,247,706       6.20                  69,736                  50,000        59,000        9,000            1.38% 1,478,049            7.21                      10,657                 1.29% 706,189             7.21                    5,092                               1.27%566,498                        7.21                    4,084                      1.09% 458,920             7.21                    3,309                      1.13% 503,366             7.21                   3,629                    1.28% 616,028           7.21                  4,442                    1.19% 779,638           7.21                  5,621                    1.16% 720,657           7.21                  5,196                    1.20% 1,020,474       7.21                  7,358                    1.37% 1,614,806         7.21                    11,643                   1.74% 2,446,356         7.21                    17,638                  1.57% 1,935,759       7.21                  13,957                 12,846,739       7.21                  92,625                  59,000        69,000        10,000         1.20% 1,285,353            7.21                      9,267                   1.22% 666,020             7.21                    4,802                               1.23%548,327                        7.21                    3,953                      1.02% 427,897             7.21                    3,085                      1.08% 479,937             7.21                   3,460                    1.19% 575,290           7.21                  4,148                    1.07% 697,608           7.21                  5,030                    1.09% 674,974           7.21                  4,867                    1.06% 900,956           7.21                  6,496                    1.14% 1,343,401         7.21                    9,686                      1.35% 1,890,762         7.21                    13,632                  1.31% 1,616,227       7.21                  11,653                 11,106,753       7.21                  80,080                  69,000        +21.84% 23,447,886          7.21                      169,059               17.70% 9,699,427         7.21                    69,933                             17.97% 8,025,033                    7.21                    57,860                   17.33% 7,265,692         7.21                    52,386                   16.18% 7,180,593         7.21                   51,772                 17.84% 8,603,139       7.21                  62,029                 22.51% 14,691,840     7.21                  105,928               17.49% 10,842,084     7.21                  78,171                 20.17% 17,200,068     7.21                  124,012               24.23% 28,635,127       7.21                    206,459                 23.20% 32,564,782       7.21                    234,792                22.02% 27,152,125     7.21                  195,767               195,307,796    7.21                  1,408,169            100.00% 107,344,849       571,704$            100.00% 54,792,579       274,613$                        100.00% 44,651,446                  221,190$               100.00% 41,916,085       204,816$               100.00% 44,366,111       216,541$              100.00% 48,230,500     239,952$              100.00% 65,266,111     337,233$              100.00% 61,974,395     313,020$              100.00% 85,285,689     443,411$              100.00% 118,162,034    639,975$               100.00% 140,339,243    769,474$              100.00% 123,305,203  665,711$              935,634,245    4,897,640$           Total Base Projected Revenue Summary:0.00% Projected Revenue Rate Current Meter Monthly Volumetric Revenue 4,897,640$           $21,350 5/8" x 3/4"17.15 56,712              972,611$             Increment Count Revenue Base Charge Revenue $106,279 1"32.23 15.08                   2,040                 30,763$             Base 972,611$               $18,179 1 1/2"56.94 39.79                   34                       1,353                 Increment (x 12) 593,768                  2"86.58 69.43                   106                     7,360                 Base Subtotal 1,566,379$            3"155.76 138.61                 36                       4,990                  4"254.59 237.44                 15                       3,562                  6"501.64 484.49                 3                          1,453                 Total Projected Revenue 6,464,019$                   TOTALS 2,234                 49,481$              TABLE GF‐D 2 AB C D MONTH SHUTOFFS  FOR NON‐ PAYMENT LATE FEES  ($/Month) METER SET FEES   MUD May‐16 30 $4,598.00 9 Jun‐16 30 $5,380.00 5 Jul‐16 16 $8,944.00 5 Aug‐16 28 $8,358.00 4 Sep‐16 28 $12,817.00 2 Oct‐16 30 $13,727.00 7 Nov‐16 37 $8,728.00 4 Dec‐16 37 $9,738.00 0 Jan‐17 44 $8,211.00 5 Feb‐17 35 $7,603.00 4 Mar‐17 51 $8,722.00 3 Apr‐17 61 $9,453.00 5 Total 427 $106,279 53 Average  Per Month 36 $8,857 4 Base  Charges FY 2016 FY 2015 FY 2014 Oversize Meter Reimbursement OTHER REVENUE SOURCES REVENUE FOR SHUTOFFS (MO.  TOTAL LATE FEES: Increment Above Base GROWTH RATE: RECOMMENDEDRates APRIL MAY JUNE JULYOCTOBERNOVEMBERDECEMBERJANUARYFEBURARYMARCH TOTALAUGUST SEPTEMBER APRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCH TOTALJULYAUGUSTSEPTEMBER APRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCH TOTALJULYAUGUSTSEPTEMBER APRIL MAY JUNE SCHEDULE GF‐D PROJECTED WATER REVENUE  MARCHOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY TOTALJULYAUGUSTSEPTEMBER Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 Budget September 19, 2017 19 of 29 OctNovDecJanFebMarAprMayJunJulAugSepAccounts 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,000194 4,561,898 337 4,542,347 378 4,499,206 378 4,502,547 371 4,503,312 381 4,517,657 333 4,543,821 348 4,578,918 256 4,605,315 201 4,594,321 173 4,623,449 183 4,643,018to 2,00094 4,491,600 315 4,381,670 320 4,329,613 294 4,342,442 305 4,344,990 332 4,347,975 222 4,403,097 279 4,413,184 136 4,500,210 97 4,520,968 65 4,563,535 78 4,569,4422,000 to 3,000120 4,397,750 423 4,065,697 496 4,009,666 486 4,048,263 477 4,040,770 506 4,015,341 363 4,180,343 386 4,132,712 167 4,363,818 109 4,424,562 70 4,498,397 99 4,491,3113,000 to 4,000126 4,278,564 488 3,641,768 632 3,513,713 605 3,562,243 554 3,564,738 549 3,509,128 394 3,816,512 401 3,744,230 237 4,195,790 126 4,315,581 88 4,428,381 120 4,392,1584,000 to 5,000145 4,152,955 425 3,152,923 586 2,882,370 618 2,957,125 552 3,011,674 513 2,959,344 390 3,421,920 408 3,340,521 238 3,957,457 127 4,189,833 78 4,340,949 119 4,271,6335,000 to 6,000149 4,008,076 370 2,727,202 485 2,296,989 529 2,338,814 498 2,460,386 412 2,445,337 351 3,031,217 365 2,929,728 260 3,718,420 128 4,063,387 87 4,262,922 117 4,152,8596,000 to 7,000174 3,859,985 297 2,356,354 359 1,812,794 401 1,808,935 366 1,962,700 318 2,032,645 307 2,679,762 274 2,562,494 249 3,457,590 138 3,935,894 95 4,176,535 132 4,035,8387,000 to 8,000164 3,686,916 254 2,059,030 268 1,453,655 307 1,407,781 281 1,597,423 268 1,714,535 257 2,372,150 227 2,286,980 233 3,207,305 143 3,798,619 91 4,081,440 135 3,903,7518,000 to 9,000162 3,523,838 229 1,804,745 192 1,186,083 226 1,100,765 214 1,316,631 220 1,446,019 230 2,115,099 202 2,058,565 224 2,973,541 159 3,655,756 102 3,990,176 137 3,768,5119,000 to 14,000914 15,042,774 756 6,150,191 522 3,674,043 515 3,079,789 633 3,972,968 634 4,615,074 848 7,545,338 750 7,578,410 993 11,608,024 870 15,773,614 687 18,150,685 776 16,668,89714,000 to 17,000523 6,854,623 255 2,169,495 135 1,267,673 107 951,714152 1,246,700 174 1,589,841 310 2,780,178 296 2,984,265 452 4,775,102 520 7,365,654 466 9,162,252 515 8,056,26017,000 to 20,000458 5,310,558 161 1,513,159 85919,580 62 685,34884871,128 119 1,112,322 201 1,951,393 216 2,161,972 323 3,535,628 456 5,845,158 466 7,731,292 477 6,519,56520,000 to 25,000541 6,192,320 145 1,671,326 80 1,072,427 55 825,84181997,502 100 1,243,746 199 2,147,628 207 2,455,192 359 4,062,914 553 7,124,638 686 9,885,744 608 7,966,56725,000 to 29,000269 3,317,225 70 896,993 37625,286 23 496,00436564,423 48 714,508 89 1,139,933 112 1,318,785 181 2,149,921 303 3,941,133 397 5,714,782 323 4,484,30329,000 to 34,000231 2,855,469 41 840,684 29617,447 21 516,32922550,223 34 671,290 71 1,018,302 78 1,140,303 133 1,859,913 264 3,452,115 346 5,189,145 285 4,044,24734,000 to 39,000128 1,916,254 26 656,336 19493,459 15 420,40921451,893 17 545,180 34734,733 49 816,27381 1,318,918 158 2,370,688 245 3,671,450 184 2,795,90139,000 to 44,00072 1,390,979 20 548,740 9418,282 11 350,87611360,663 13 473,268 20600,728 23 623,62549964,582105 1,715,055 164 2,651,177 117 2,029,65644,000 to 50,00051 1,291,777 13 542,284 11439,3038368,3486384,091 11 482,833 14614,871 24 610,52234909,74471 1,481,723 113 2,315,034 91 1,807,17550,000 to 59,00048 1,478,049 11 706,189 10566,4989458,9209503,366 14 616,028 18779,638 16 720,65734 1,020,474 59 1,614,806 104 2,446,356 69 1,935,75959,000 to 69,00025 1,285,353 13 666,020 8548,3279427,8979479,9379575,290 13697,608 10 674,97417900,95634 1,343,401 61 1,890,762 42 1,616,22769,000 + +115 23,447,886 60 9,699,427 50 8,025,033 38 7,265,69243 7,180,593 52 8,603,139 63 14,691,840 62 10,842,084 81 17,200,068 117 28,635,127 159 32,564,782 140 27,152,125 SCHEDULE GF‐E   PROJECTED RETAIL WASTEWATER SALES FY 2018WATER USECATEGORYTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201720 of 29 Residential (Winter Average) Commercial Total Rates Minimum Charge All Meter Sizes $17.50 $17.50 Volumetric Charge (000's) 0‐4,000 $2.84 4,001‐8,000 $4.03 8,001‐12,000 $5.74 12,000+$8.16 Commercial $4.89 Billing Determinants 7,539 Annual # of Meters 52,704 1,272 53,976 Volumes (000's) 0 ‐4,000 gallons 184,888 184,888 4,001 ‐ 8,000 gallons 83,692 83,692 8,001 ‐ 12,000 gallons 29,140 29,140 > 12,001 gallons 27,536 27,536 325,256 325,256 Commercial (000's)93,794 93,794 Projected Revenue Meter Charge Revenue $922,320 $22,260 $944,580 Residential  0 ‐4,000 gallons $525,082 $525,082 4,001 ‐ 8,000 gallons $337,279 $337,279 8,001 ‐ 12,000 gallons $167,264 $167,264 > 12,001 gallons $224,694 $224,694 Subtotal $1,254,318 $0 $1,254,318 Commercial $458,653 $458,653 Total Revenue $2,176,638 $480,913 $2,657,551 Revenue Requirement $3,454,120 Over/(Under) Recovery ($)‐$796,569 Over/(Under) Recovery (%)‐23.06% SCHEDULE GF‐E‐2  PROJECTED RETAIL WASTEWATER SALES FY 2018 Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 Budget September 19, 2017 21 of 29 WATER DEPARTMENT ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 6 10 60 $14 $840 POLO SHIRTS 6 4 24 $17 $408 SWEATSHIRTS 6 5 30 $18 $540 PANTS 6 7 42 $25 $1,050 BOOTS 6 1 6 $175 $1,050 JACKET 4 1 4 $150 $600  TOTAL:$4,488 WASTEWATER DEPARTMENT ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL UNIFORM SHIRTS 7 6 42 $18 $756 POLO SHIRTS 7 0 0 $35 $0 SWEATSHIRTS 7 2 14 $27 $378 PANTS 7 5 35 $30 $1,050 BOOTS 7 1 7 $175 $1,225 JACKET 7 1 7 $150 $1,050 TOTAL:$4,459 ADMINISTRATION ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL POLO SHIRTS 3 5 15 $35 $525 (DIRECTOR) SHIRTS 5 2 5 $35 $175 SWEATER 00 0 $0 JACKETS 00 0 $0 TOTAL:$700 SCHEDULE GF‐F  UNIFORMS Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 Budget September 19, 2017 22 of 29 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 3$500$1,500$0$0 $7,600 $4,885 $12,485SCHEDULE GF‐GTRAVEL & TRAININGTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201723 of 29   COLA TotalSocialTWC UNEMP WORKERS Pay Merit OT Certification Certification SalariesSecurity Medicare2.00% COMPWATER  & DISTRIBUTION Base Pay 2.1% Pay Pay Longevity Monthly Annually & Wages6.2% 1.45%UP TO $90000.0402744Water Superintendent77,260 1,622 17330 0 80,614 4,998 1,169180 3,247Crew Leader51,892 1,090 1433 100 1200 55,614 3,448 806180 2,240Utility Field Worker34,986 735 14525 300 36,165 2,242 524180 1,457Utility Field Worker34,986 735 11525 300 36,135 2,240 524180 1,455Utility Field Worker 34,9860 075 900 35,886 2,225 520180 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,0001,000621540Merit7,9897,989 495 116322TOTAL: 262,109 4,182 7,989 20,000 3,4253,300 301,004 18,662 4,365 1,080 11,854  COLA TotalSocialTWC UNEMP WORKERS Pay Merit OT Certification Certification SalariesSecurity Medicare2.00% COMPWASTEWATER & COLLECTIONS Base Pay 2.1% Pay Pay Longevity Rate Annually & Wages6.2% 1.45%UP TO $90000.0402744Wastewater Superintendent 75,146 1,578.07           480‐                ‐                 77,204 4,787 1,119180 3,109Wastewater Shift Supervisor 58,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 929 180 2,580Utility Field Worker53,414 1,121.70          1,373 150               1,800        57,709 3,578 837180 2,324Utility Field Worker43,497 913.44             863 100               1,200        46,473 2,881 674180 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 656180 1,823Additional Cert Pay Level25 300            30019412Overtime Pay30,00030,000 1,860 435805DM Discretionary1,0001,000621540Merit11,96711,967 742 174482TOTAL: 390,715 8,184 11,967 30,000 7,4158,400 456,681 28,314 6,622 1,260 17,990 COLA Merit TotalSocialTWC UNEMP WORKERS Pay Pay OT Longevity Certification SalariesSecurity Medicare2.00% COMPADMINISTRATION Base Pay 2.1%Pay Rate Certification & Wages6.2% 1.45%UP TO $90000.003492 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 Clerk/Receptionist 31,500 662000 32,162 1,994 466180112Utility Billing Clerk/Receptionist 31,500 662000 32,162 1,994 466180112Utility Billing Supv/Finance Asst. 52,044 1,09308480 53,985 3,347 783180189Communications Specialist52,044 1,093700 53,207 3,299 771180186Overtime Pay2,0000 2,000 1242905DM Discretionary1,0001,000621503Merit12,60812,608 782 183044TOTAL: 411,632 8,623 12,608 2,000 3,5480 438,411 27,181 6,357 1,260 1,529SCHEDULE GF‐HSALARY WORKSHEETTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201724 of 29 NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST  PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST  PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST  PROJECTED No coverage$0No coverage$0No coverage$0Employee Only3$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 ADMINISTRATIONSCHEDULE GF‐IBENEFITS WORKSHEETMEDICALMEDICALWATERWASTEWATERLIFE & OTHERLIFE & OTHERDENTALVISIONVISIONDENTALLIFE & OTHERDENTALVISIONMEDICALTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201725 of 29 Oct‐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 6993Merit11,967277 830 1,107TOTAL:456,681 10,561 31,682 42,243Oct‐Dec Jan‐SeptTCDRS TCDRS9.25% 9.25%General Manager00 00District Secretary82,959 1,918 5,755 7,674HR Mgr/Financial Analyst71,470 1,653 4,958 6,611Finance Manager96,861 2,240 6,720 8,960Utility Billing Clerk/Receptionist32,162 744 2,231 2,975Utility Billing Clerk/Receptionist32,162 744 2,231 2,975Utility Billing Supervisor/Finance Asst.53,985 1,248 3,745 4,994Communications Specialist53,207 1,230 3,691 4,922Overtime Pay2,000 46 139 185District Manager Discretion1,000 23 69 93Merit12,608 292 875 1,166TOTAL:438,411 10,138 30,415 40,553ADMINISTRATIONTOTAL FY 2018 SALARYTCDRS FY 2017 TotalSCHEDULE GF‐JRETIREMENT WORKSHEETTOTAL FY 2018 SALARYWASTEWATERTCDRS FY 2017 TotalTOTAL FY 2018 SALARYTCDRS FY 2017 TotalWATERTrophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201726 of 29 SCHEDULE 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‐17Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201727 of 29 SCHEDULE GF‐LINFORMATION TECHNOLOGYAccountDescriptionAmount135‐55160‐030DescriptionProfessional Outside ServicesM3‐ It & Cell Phone Support, Includes outlook email license$56,475Totals:56,475$        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/SCADA1,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$        Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201728 of 29 SCHEDULE GF‐LINFORMATION TECHNOLOGYAccountDescriptionAmount135‐60235‐030DescriptionSecurityR‐Access Control System (add cost of keypad)2,700$                     Totals:2,700$          135‐65055‐030DescriptionQtyPer ItemAmountHardware R‐A/V Miscellaneous Equipment0WIFI (MUD & Public)11,704$                    1,704$          Replacement Hardware: Dell Laptop11,869$                    1,869$          Dell Docking Station1179$                        179$             Dell 22" Monitor4200$                        800$             Dell Monitor Stand1189$                        189$             Dell Desktop 21,000$                    2,000$          Keyboard/Mouse combo179$                          79$                Printers2300$                        600$             Totals:7,420$          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:176,886$     Trophy Club Municipal Utility District No. 1 Adopted Fiscal Year 2018 BudgetSeptember 19, 201729 of 29