Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 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