Loading...
HomeMy WebLinkAbout2015-08-19 Budget Workshop Agenda Packet    BOARD OF DIRECTORS  Special Meeting     TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262   August 19, 2015 8:30 A.M. Svore Municipal Boardroom    SPECIAL SESSION & BUDGET WORKSHOP    CALL TO ORDER AND ANNOUNCE A QUORUM    SPECIAL SESSION     1. Consider and take appropriate action regarding insurance proposals from Texas Municipal League  and Texas Water Conservation Commission.    2. Consider and take appropriate action regarding water system water loss and improvements  related thereto for inclusion in Fiscal Year 2016 budget.    3. Consider and take appropriate action regarding draft Fiscal Year 2016 budget.   attachment: DRAFT Fiscal Year 2016 budget    4. Consider and take appropriate action to set date for a public hearing to adopt Trophy Club  Municipal Utility District No. 1 tax rate for Fiscal Year 2016.    ADJOURN     CERTIFICATION   THE STATE OF TEXAS    §  COUNTIES OF DENTON AND TARRANT §   THIS CERTIFIES THAT ON AUGUST 14, 2015 BY 4:00 P.M. A COPY OF THE ABOVE NOTICE OF TROPHY CLUB  MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS SPECIAL MEETING BUDGET WORKSHOP TO BE  HELD ON WEDNESDAY, AUGUST 19, 2015 AT 8:30 A.M., WAS POSTED ON THE FRONT WINDOW OF  TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, ADMINISTRATION BUILDING LOCATED AT 100  MUNICIPAL DRIVE, TROPHY CLUB, TEXAS, WHICH IS A PLACE CONVENIENT TO THE PUBLIC WITHIN THE  BOUNDARIES OF THE DISTRICT. A COPY OF THIS NOTICE WAS ALSO PROVIDED TO THE COUNTY CLERKS  OF DENTON AND TARRANT COUNTIES TO BE POSTED ON THEIR WEBSITES OR AT A PLACE CONVENIENT  TO THE PUBLIC PURSUANT TO SECTION 49.063 OF THE WATER CODE AND SECTION 551.054 OF THE OPEN  MEETINGS ACT, CHAPTER 551 OF THE TEXAS GOVERNMENT CODE.        LAURIE SLAGHT, DISTRICT SECRETARY  Trophy Club Municipal Utility District No. 1 1 of 33 August 19, 2015 - Special Meeting Agenda Packet General FundFire FundTax Debt Service FundRevenue Debt Service FundRevenue7,855,239Revenue31,075 Revenue214,519 Revenue444,838FY 2016 Tax Collections58,181FY 2016 Tax Collections 917,627 FY 2016 Tax Collections 671,998FY 2016 PID Surcharges146,125FY 2016 PID Assessment 416,682 PID Surcharge119,706Reserve Funds8,020Reserve Funds0 Total Revenue 8,067,565Total Revenue 1,365,384Total Revenue 1,006,223Total Revenue 444,838Water Expense4,475,834Fire Expense1,365,384 Debt Service Expense1,004,533 Debt Service Expense444,838Wastewater Expense1,912,109 Board of Directors Expense26,573 Administration Expense1,226,319 Non-Departmental Expense426,729Total Expense 8,067,566Total Expense 1,365,384Total Expense 1,004,533Total Expense 444,838Net Budget Surplus/Deficit0Net Budget Surplus/Deficit0 Net Budget Surplus/Deficit 1,690 Net Budget Surplus/Deficit0 2016 Property Value SummaryTax Rate SummaryMUD Tarrant Co.299,983,6612015 2016MUD Denton Co.932,292,617O&M (General Fund) Tax 0.01486 0.00472PID559,559,219I & S (Debt Service) Tax 0.04126 0.05420Total Value:1,791,835,497Fire Tax0.07727 0.07447Total Tax Rate:0.13339 0.13339 Increase/Decrease:0.00000 PID Fire Assessment Rate0.07727 0.07447 Reduction: -0.00281 Budget SummaryTROPHY CLUB M.U.D. NO. 1FY 2016 BUDGET DRAFT AUGUST 19, 2015 1Trophy Club Municipal Utility District No. 12 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15GENERAL FUNDAccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15CommentsGeneral Fund Revenues135‐40000‐000‐000 Property Taxes167,857 167,85758,181 166,927 SEE SCHEDULE TAX_ASSESS135‐40002‐000‐000 Property Taxes/Delinquent000424135‐40015‐000‐000 Property Taxes/P & I900900650602135‐40025‐000‐000 PID Surcharges133,997 133,997146,125 104,709 SEE SCHEDULE TAX_ASSESS135‐47000‐000‐000 Water5,286,045 4,747,7895,080,244 2,086,645 SEE SCHEDULE GF‐D135‐47005‐000‐000 Sewer2,270,982 2,270,9822,413,776 1,407,508 SEE SCHEDULE GF‐E135‐47025‐000‐000 Penalties63,416 80,00090,985 65,132 SEE SCHEDULE GF‐D135‐47030‐000‐000Service Charges (Disconnect Fees)8,000 10,0009,0007,974 SEE SCHEDULE GF‐D135‐47035‐000‐000 Plumbing Inspections2,000 2,0002,3001,700 SEE SCHEDULE GF‐D135‐47045‐000‐000 Sewer Inspections5,000 5,0006,9005,100 SEE SCHEDULE GF‐D135‐47070‐000‐000 TCCC Effluent Charges86,815 86,81561,330 18,418 SEE SCHEDULE GF‐E135‐48005‐000‐000 Utility Fees184,000 184,00069,000 188,600 SEE SCHEDULE GF‐D135‐49010‐000‐000 Interest Income5,000 5,0006,0004,523 ADDITIONAL INTEREST DUE TO BOND PROCEEDS 135‐49016‐000‐000Cell Tower Revenue10,164 10,16410,9268,195 $910.53 PER MONTH135‐49018‐000‐000 Building Rent Income7,000 7,0007,0005,250 $583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN135‐49030‐000‐000 Vending Revenue350000 NO LONGER PROVIDING VENDING AT WWTP135‐49035‐000‐000 Prior Year Reserves0 929,6038,0200 STW SERVER UPGRADE REQUIRED DUE TO NO LONGER SUPPORTING EXISTING ‐ FUNDS FROM 137135‐49036‐000‐000 GASB Reserves74,706 74,7060 74,706 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARE135‐49075‐000‐000 Oversize Meter Reimbursement84,000 42,00054,000 44,776135‐49141‐000‐000 Interfund Transfer In0 19,6070 36,767135‐49900‐000‐000 Miscellaneous Income54,000 68,99443,108 104,732 INCLUDES $3108 FROM TOWN FOR JANITORIAL135‐49901‐000‐000 Records Management Revenue1001002012 REDUCED REVENUE135‐49903‐000‐000 Recovery of Prior Year Expense0000Total8,444,333 8,846,5148,067,565 4,332,698 General Fund ExpensesWater & Distribution135‐50005‐010‐000Salaries & Wages301,101 244,578265,614 146,657 SEE SCHEDULE GF‐H135‐50010‐010‐000 Overtime19,500 19,50019,500 10,323 SEE SCHEDULE GF‐H135‐50016‐010‐000 Longevity5,343 2,7052,9452,705 SEE SCHEDULE GF‐H135‐50017‐010‐000 Certification4,800 3,9004,2002,050 SEE SCHEDULE GF‐H135‐50020‐010‐000 Retirement29,349 23,98725,558 14,442 SEE SCHEDULE GF‐J135‐50026‐010‐000 Medical Insurance44,988 51,48751,398 23,679 SEE SCHEDULE GF‐I 135‐50027‐010‐000 Dental Insurance3,288 4,1883,9991,909 SEE SCHEDULE GF‐I135‐50028‐010‐000Vision Insurance834990910446 SEE SCHEDULE GF‐I135‐50029‐010‐000 Life Insurance & Other3,074 3,0742,8031,569 SEE SCHEDULE GF‐I135‐50030‐010‐000 Social Security Taxes21,135 17,19218,5639,882 SEE SCHEDULE GF‐H135‐50035‐010‐000 Medicare Taxes4,943 4,0214,3412,311 SEE SCHEDULE GF‐H135‐50040‐010‐000 Unemployment Taxes1,242 1,2421,24218 SEE SCHEDULE GF‐H135‐50045‐010‐000 Workman's Compensation16,020 16,02014,7546,401 TML INVOICE AMOUNT135‐50060‐010‐000Pre‐emp Physicals/Testing1,000 1,3001,3001,037135‐50070‐010‐000 Employee Relations300300300148135‐55005‐010‐000 Engineering10,000 10,0005,000‐2,090135‐55080‐010‐000 Maintenance & Repairs71,242 81,11385,000 54,929 ADDITIONAL MAINTENANCE FY 16 135‐55090‐010‐000 Vehicle Maintenance8,000 8,0008,0005,523135‐55105‐010‐000 Maintenance‐Heavy Equipment3,500 3,5003,5003,463135‐55135‐010‐000 Lab Analysis ‐ MUD5,500 5,5005,5003,290 TCEQ ESTIMATE + MONTHLY BAC T & REDUCED FOR PID PORTION2Trophy Club Municipal Utility District No. 13 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15Comments135‐60010‐010‐000 Communications/Pagers/Mobiles4,913 4,9135,4002,803 INCREASE IN COSTS135‐60020‐010‐000 Electricity170,765 160,765166,823 84,680 SEE SCHEDULE GF‐K135‐60066‐010‐000 Publications/Books/Subscripts500500500739135‐60070‐010‐000 Dues & Memberships5005005000135‐60080‐010‐000 Schools & Training4,138 4,1385,7731,173 SEE SCHEDULE GF‐G135‐60090‐010‐000 Safety Program4004004000135‐60100‐010‐000 Travel & per diem1,500 1,5001,40099 SEE SCHEDULE GF‐G135‐60105‐010‐000 Rent/Lease Equipment1,500 1,5001,5000 EMERGENCY EQUIPMENT RENTAL IF NEEDED135‐60135‐010‐000TCEQ Fees & Permits ‐ MUD49,275 49,27549,275 20,657 REG. ASSESSMENT ($22,500), WATER SYSTEM FEES ($6,775) & NTGW WELL FEES ($20,000)135‐60150‐010‐000 Wholesale Water2,928,308 2,928,3082,948,742 1,039,926 SEE SCHEDULE GF‐C135‐60245‐010‐000 Miscellaneous Expenses2002002000135‐60280‐010‐000 Property Maintenance3,500 3,5003,5001,265135‐60285‐010‐000 Lawn Equipment & Maintenance2502502500135‐60360‐010‐000 Furniture/Equipment < $50003,500 3,5002,500925135‐65005‐010‐000Fuel & Lube29,173 19,17335,9479,035 SEE SCHEDULE GF‐M135‐65010‐010‐000 Uniforms3,620 3,6204,6083,075 SEE SCHEDULE GF‐F135‐65030‐010‐000 Chemicals7,000 10,00012,0007,568 MORE WATER TREATED135‐65035‐010‐000 Small Tools1,200 1,2001,200290135‐65040‐010‐000 Safety Equipment1,000 1,0001,000457135‐65050‐010‐000 Meter Expense161,500 165,000165,000 92,664135‐69005‐010‐000 Capital Outlays1,089,006 1,457,597201,000 234,151 SEE SCHEDULE GF‐A135‐69006‐010‐000 Long Term Debt Payment from Water Sales0000 SEE SCHEDULE GF‐B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS135‐69008‐010‐000Short Term Debt‐Principal129,000 129,000130,720 129,000 SEE SCHEDULE GF‐B135‐69009‐010‐000 Short Term Debt‐Interest3,612 3,6121,2092,416 SEE SCHEDULE GF‐B135‐69195‐010‐000 Gasb34/Reserve for Replacement75,000 75,00075,000 75,000 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000135‐69281‐010‐000 Tank Inspection Contract151,507 151,507126,958 126,958 ANNUAL MAINTENANCE CONTRACT135‐55135‐010‐001Lab Analysis ‐ PID5,000 5,0005,0002,514 PID PORTION135‐60135‐010‐001 TCEQ Fees & Permits‐ PID5,000 5,0005,0002,419 WATER SYSTEM FEES ($2.15/CONNECTION)  AND OTHERSubtotal Water5,386,025 5,688,5554,475,834 2,126,506135‐50005‐020‐000 Salaries & Wages305,744 307,875351,671 212,670 SEE SCHEDULE GF‐H135‐50010‐020‐000 Overtime19,500 24,50019,500 21,297 SEE SCHEDULE GF‐H135‐50016‐020‐000 Longevity5,617 5,6176,1255,615 SEE SCHEDULE GF‐H135‐50017‐020‐000 Certification6,600 6,6007,2004,950 SEE SCHEDULE GF‐H135‐50020‐020‐000 Retirement29,948 30,31733,652 21,840 SEE SCHEDULE GF‐J135‐50026‐020‐000 Medical Insurance61,001 56,24465,989 41,678 SEE SCHEDULE GF‐I 135‐50027‐020‐000 Dental Insurance4,146 3,6964,1842,665 SEE SCHEDULE GF‐I135‐50028‐020‐000Vision Insurance990912972618 SEE SCHEDULE GF‐I135‐50029‐020‐000 Life Insurance & Other3,194 3,1943,6552,556 SEE SCHEDULE GF‐I135‐50030‐020‐000 Social Security Taxes21,680 21,81224,665 13,693 SEE SCHEDULE GF‐H135‐50035‐020‐000 Medicare Taxes5,070 5,1015,7683,188 SEE SCHEDULE GF‐H135‐50040‐020‐000 Unemployment Taxes1,242 1,2421,44914 SEE SCHEDULE GF‐H135‐50045‐020‐000 Workman's Compensation16,020 16,0209,3176,401 TML INVOICE AMOUNT135‐50060‐020‐000 Pre‐emp Physicals/Testing150300300126135‐50070‐020‐000 Employee Relations550650650451135‐55070‐020‐000 Independent Labor0050,0000 ENGINEERING FEES FOR PERMIT RENEWAL135‐55080‐020‐000 Maintenance & Repairs58,000 72,60072,600 71,631135‐55090‐020‐000 Vehicle Maintenance3,000 3,0005,0003,325 REPLACE TIRES ON GAP VAX; REPLACE WINDSHIELD ON ON CALL TRUCKWastewater 3Trophy Club Municipal Utility District No. 14 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15Comments135‐55105‐020‐000 Maintenance‐Heavy Equipment500500500129135‐55125‐020‐000 Dumpster Services55,000 55,00055,000 36,716135‐55135‐020‐000 Lab Analysis25,000 25,00035,000 18,680 INCREASE FOR PERMIT RENEWAL TESTING135‐60010‐020‐000 Communications/Pagers/Mobiles4,662 4,6625,4003,992 INCREASE IN COSTS135‐60020‐020‐000 Electricity149,292 139,292161,582 94,077 SEE SCHEDULE GF‐K135‐60066‐020‐000 Publications/Books/Subscripts400400400135135‐60070‐020‐000 Dues & Memberships250250300307135‐60080‐020‐000 Schools & Training4,065 3,0653,7711,326 SEE SCHEDULE GF‐G135‐60090‐020‐000Safety Program5505505500135‐60100‐020‐000 Travel & per diem1,600 2,0001,6001,797 SEE SCHEDULE GF‐G135‐60105‐020‐000 Rent/Lease Equipment9,000 7,5009,0001 EMERGENCY EQUIPMENT RENTAL IF NEEDED135‐60135‐020‐000 TCEQ Fees & Permits17,150 17,15037,1509,019 REG. ASSESSMENT($8,550),  ANNUAL FEE ($8,600), PERMIT RENEWAL ($20,000)135‐60243‐020‐000 Prior Year Expense0000135‐60245‐020‐000 Miscellaneous Expenses3003003000135‐60285‐020‐000 Lawn Equipment & Maintenance500500500273135‐60331‐020‐000Interfund Transfer Out‐Tax I&S0 65,255119,7060 TRANSFER OF PID SURCHARGE135‐60332‐020‐000 Interfund Transfer Out‐ Revenue I&S0 136,989444,8310 SEE SCHEDULE GF‐B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS13560333‐020‐000 Interfund Transfer Out‐Reserve0 71,946123,336 41,112 TRANSFER FOR BOND RESERVE135‐60360‐020‐000 Furniture/Equipment < $50000000135‐65005‐020‐000 Fuel & Lube36,328 20,32832,021 14,026 SEE SCHEDULE GF‐M135‐65010‐020‐000Uniforms2,778 2,7784,2412,598 SEE SCHEDULE GF‐F135‐65030‐020‐000 Chemicals30,000 24,00027,000 14,086 INCREASE IN CHEMICALS NEEDED135‐65035‐020‐000 Small Tools2,000 1,5002,000879135‐65040‐020‐000 Safety Equipment750750750626135‐65045‐020‐000 Lab Supplies13,000 13,00013,000 10,151135‐69005‐020‐000 Capital Outlays150,000 142,000150,000 118,396 SEE SCHEDULE GF‐A135‐69007‐020‐000 Long Term Debt Payment from WW Sales357,538000135‐69008‐020‐000 Short Term Debt‐Principal56,991 56,99121,280 21,000 SEE SCHEDULE GF‐B135‐69009‐020‐000 Short Term Debt‐Interest2,011 2,011197393 SEE SCHEDULE GF‐BSubtotal Wastewater1,462,115 1,353,3971,912,109 802,434Board of Directors135‐50005‐026‐000 Salaries & Wages10,000 10,00012,5009,400 MORE MEETINGS135‐50030‐026‐000 Social Security Taxes620620775583 MORE MEETINGS135‐50035‐026‐000 Medicare Taxes145145181136 MORE MEETINGS135‐50040‐026‐000 Unemployment Taxes23023023062 MORE MEETINGS135‐50045‐026‐000 Workman's Compensation36363726 TML INVOICE AMOUNT135‐60066‐026‐000 Publications/Books/Subscripts1501501500135‐60070‐026‐000 Dues & Memberships50050050035135‐60075‐026‐000 Meetings1,2009501,200176 MORE MEETINGS135‐60080‐026‐000 Schools & Training4,000 4,0004,0001,330135‐60100‐026‐000 Travel & per diem5,000 4,2505,0002,558135‐60245‐026‐000 Miscellaneous Expenses1,000 2,0002,0001,625Subtotal Board of Directors22,881 22,88126,573 15,931Administration 135‐50005‐030‐000 Salaries & Wages477,578 470,732502,028 324,012 SEE SCHEDULE GF‐H135‐50010‐030‐000 Overtime1,000 1,0001,000495 SEE SCHEDULE GF‐H135‐50016‐030‐000 Longevity3,283 3,2833,6733,283 SEE SCHEDULE GF‐H135‐50020‐030‐000 Retirement42,840 42,18444,375 29,274 SEE SCHEDULE GF‐H4Trophy Club Municipal Utility District No. 15 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15Comments135‐50026‐030‐000 Medical Insurance65,015 62,00068,196 43,544 SEE SCHEDULE GF‐I (Updated with Board approved plan rates)135‐50027‐030‐000 Dental Insurance4,944 4,4944,8072,517 SEE SCHEDULE GF‐I135‐50028‐030‐000 Vision Insurance1,158 1,1161,114726 SEE SCHEDULE GF‐I135‐50029‐030‐000 Life Insurance & Other4,333 4,3334,4313,277 SEE SCHEDULE GF‐I135‐50030‐030‐000 Social Security Taxes30,079 29,65431,643 19,167 SEE SCHEDULE GF‐I135‐50035‐030‐000 Medicare Taxes7,422 7,3177,8054,482 SEE SCHEDULE GF‐H135‐50040‐030‐000Unemployment Taxes1,449 1,4491,656144 SEE SCHEDULE GF‐H135‐50045‐030‐000 Workman's Compensation1,636 1,6361,776786 TML INVOICE AMOUNT135‐50060‐030‐000 Pre‐emp Physicals/Testing50050050038135‐50070‐030‐000 Employee Relations5,000 5,0005,0002,462135‐55030‐030‐000 Software & Support75,588 121,63578,483 101,224 SEE SCHEDULE GF‐L135‐55070‐030‐000 Independent Labor8,000 32,55012,000 30,114135‐55080‐030‐000 Maintenance & Repairs4,500 4,50029,500440 INCLUDES MOWING CONTRACT $25,000135‐55100‐030‐000Building Maint & Supplies6,500 6,5007,0005,447 INCREASE IN COSTS135‐55120‐030‐000 Cleaning Services8,100 8,10010,1255,020 CLEANING CONTRACT INCREASE135‐55160‐030‐000 Professional Outside Services58,000 61,95061,075 16,600 M3 IT SERVICES $51,075 ‐SEE SCHEDULE GF‐L135‐55161‐030‐000 Town Personnel Contract6,170 26,1700 26,170 SERVICES NET ZERO THIS YEAR135‐55165‐030‐000 Collection Fees2002002000135‐55205‐030‐000 Utility Billing Contract8,200 8,2008,2004,915 COST FOR PRINTING MONTHLY STATEMENTS135‐60005‐030‐000Telephone13,360 13,36016,3499,084 SEE SCHEDULE GF‐L AND $2,500 AFTER HOURS ANSWERING SERVICE135‐60010‐030‐000 Communications/Mobiles4,057 4,0574,1503,077 INCREASE IN COSTS135‐60020‐030‐000 Electricity14,978 12,00010,7685,113 SEE SCHEDULE GF‐K135‐60025‐030‐000 Water1,500 1,5001,500601135‐60035‐030‐000 Postage28,500 28,50028,932 21,309 INCREASE OF $432 FOR POSTAGE MACHINE RENTAL135‐60040‐030‐000 Bank Service Charges & Fees32,000 32,00044,000 31,998 CREDIT CARD FEES CONTINUING TO INCREASE135‐60050‐030‐000Bad Debt Expense6,200 6,2003,5001,712135‐60055‐030‐000 Insurance48,751 48,75152,797 36,921 TML INVOICE AMOUNT135‐60066‐030‐000 Publications/Books/Subscripts1,000 1,6001,6001,224135‐60070‐030‐000 Dues & Memberships5,000 6,0006,0004,335135‐60075‐030‐000 Meetings40040040060135‐60079‐030‐000 Public Education5,000 4,0795,0003,385135‐60080‐030‐000 Schools & Training10,235 10,2359,9352,938 SEE SCHEDULE GF‐G135‐60100‐030‐000 Travel & per diem5,400 5,4005,4001,546 SEE SCHEDULE GF‐G135‐60110‐030‐000 Physicals/Testing2002002000135‐60115‐030‐000Elections007,5000 ELECTION TO BE HELD IN FY 16135‐60125‐030‐000 Advertising2,500 2,5007,5005,631 INCREASED ADVERTISING135‐60235‐030‐000 Security1,350 1,3501,35060 SEE SCHEDULE GF‐L135‐60245‐030‐000 Miscellaneous Expenses & DM Discretionary17,500 17,50017,5006,088135‐60270‐030‐000 4th of July Celebration10,000 10,00000135‐60336‐030‐000 Intergov Trans Out (MUD I&S)0 14,00000135‐60344‐030‐000 Intergov Trans Out (Fire Dept.)0000135‐60360‐030‐000 Furniture/Equipment < $500010,475 10,4752,5005,036135‐65010‐030‐000 Uniforms1,855 1,8551,8551,043 SEE SCHEDULE GF‐F135‐65055‐030‐000 Hardware IT75,966 35,22629,594 34,203 SEE SCHEDULE GF‐L     135‐65085‐030‐000 Office Supplies9,000 9,0009,0005,970 ALL DEPARTMENTS COMBINED.135‐65090‐030‐000 Printer Supplies & Maintenance4,732 4,7324,0032,730 SEE SCHEDULE GF‐L135‐65095‐030‐000 Maintenance Supplies5,000 5,0005,0003,272135‐65097‐030‐000 Vending Machine Supplies20020000 NO LONGER PROVIDING VENDING AT WWTP 135‐65105‐030‐000Printing4,800 4,8004,8001,333 ADDITIONAL PRINTING FOR CUSTOMER PUBLICATIONS 5Trophy Club Municipal Utility District No. 16 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15Comments135‐69005‐030‐000 Capital Outlays125,000 62,00056,000 61,822 SEE SCHEDULE GF‐A135‐69170‐030‐000 Copier Lease Installments4,236 4,2364,6003,027 SEE SCHEDULE GF‐L135‐69195‐030‐000 Gasb34/Reserve for Replacement IT16,329 16,3290 16,329 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARESubtotal Administration1,287,018 1,277,9881,226,319 893,982Non Departmental135‐55045‐039‐000 Legal250,000 467,403389,914 433,588 PLAN FOR RATE CHALLENGE135‐55055‐039‐000 Auditing22,491 22,49122,750 16,836 FY 16 CONTRACT PRICE135‐55060‐039‐000Appraisal10,000 10,00010,2657,964135‐55065‐039‐000 Tax Admin Fees3,800 3,8003,8002,456Subtotal Non Departmental286,291 503,694426,729 460,845Total General Fund Revenues8,444,333 8,846,5148,067,565 Total General Fund Expenses8,444,333 8,846,5148,067,565Net Budget Surplus (Deficit)0006Trophy Club Municipal Utility District No. 17 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15FIRE DEPARTMENTAccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15Revenues122‐40001‐000‐000 Assessment ‐ Emerg Svcs357,462 357,462416,682 356,068 SEE SCHEDULE TAX_ASSESS122‐40003‐000‐000 Emer Svcs Assessmen/Delinquent0008,402122‐40010‐000‐000 Property Taxes/MUD Fire872,859 872,859917,627 867,999 SEE SCHEDULE TAX_ASSESS122‐40011‐000‐000 Property Taxes/Fire‐Delinquent0003,879122‐40015‐000‐000 Property Taxes/Assessments P&I7507507503,295122‐40020‐000‐000 Property Taxes/Fire P&I4,500 4,5004,5003,585122‐42014‐000‐000 Fire Permits/Sprinkler6,000 6,0005,0005,200122‐43400‐000‐000 Fire Inspections700950825975122‐43415‐000‐000 Denton/Tarrant Cty Pledge‐Fire10,000 10,00010,000 10,000122‐49035‐000‐000 Prior Year Reserves 125,670 171,03000122‐49900‐000‐000 Miscellaneous Income6,000 9,00010,000 10,404Total1,383,940 1,432,551 1,365,384 1,269,808Expenses 122‐50005‐045‐000 Salaries & Wages469,067 469,067508,226 327,853 SEE SCHEDULE GF‐H122‐50010‐045‐000 Overtime46,745 46,74548,735 27,604 SEE SCHEDULE GF‐H122‐50011‐045‐000 Holiday Pay14,930 14,93015,852 14,526 SEE SCHEDULE GF‐H122‐50016‐045‐000 Longevity5,505 5,5055,7615,319 SEE SCHEDULE GF‐H122‐50017‐045‐000 Certification4,800 4,8004,2003,732 SEE SCHEDULE GF‐J122‐50020‐045‐000 Retirement91,396 75,32775,571 51,854 SEE SCHEDULE GF‐I122‐50026‐045‐000 Medical Insurance59,169 59,16965,546 40,769 SEE SCHEDULE GF‐I122‐50027‐045‐000Dental Insurance4,390 4,3904,8853,140 SEE SCHEDULE GF‐I122‐50028‐045‐000 Vision Insurance811811859546 SEE SCHEDULE GF‐I122‐50029‐045‐000 Life Insurance & Other4,030 4,0304,5852,762 SEE SCHEDULE GF‐I  122‐50030‐045‐000 Social Security Taxes33,421 33,42136,132 21,591 SEE SCHEDULE GF‐H122‐50035‐045‐000 Medicare Taxes7,292 7,2928,4505,048 SEE SCHEDULE GF‐H122‐50040‐045‐000 Unemployment Taxes1,657 1,6571,724‐293 SEE SCHEDULE GF‐H122‐50045‐045‐000Workman's Compensation8,692 8,6929,3795,931 SEE SCHEDULE GF‐H122‐50060‐045‐000 Pre‐employment Physicals/Test250250250148122‐50075‐045‐000 Tuition Reimbursement30030000 MUD FY 2016 SHARE122‐55030‐045‐000Software & Support7,378 7,3786,6612,818 SEE SCHEDULE GF‐L122‐55045‐045‐000 Legal1,500 1,5002,0001,800122‐55080‐045‐000 Maintenance & Repairs18,552 18,55216,3706,565 INCLUDES FIRE EXTINGUISHERS & MISC OF $1260122‐55090‐045‐000 Vehicle Maintenance12,000 12,00010,0009,833122‐60005‐045‐000 Telephone50505051122‐60010‐045‐000 Communications/Mobiles5,000 6,4136,6533,861 ACTIVE 911 $240122‐60020‐045‐000 Electricity/Gas9,026 9,0267,4123,857 SEE SCHEDULE GF‐K: 50% PAID BY TOWN122‐60025‐045‐000 Water1,200 1,2001,200965 50% PAID BY TOWN122‐60026‐045‐000 Cable1,920 1,9201,9201,388122‐60030‐045‐000 Rent And/Or Usage 211,829 211,829214,379 211,829 SEE SCHEDULE FD‐B122‐60035‐045‐000 Postage1001005016122‐60055‐045‐000 Insurance12,179 12,17914,0778,461 TML INVOICE 7Trophy Club Municipal Utility District No. 18 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15122‐60066‐045‐000 Publications/Books/Subscrips200220350219 AERIAL TRAINING BOOK122‐60070‐045‐000 Dues & Memberships15,180 15,68915,582 15,419 SEE SCHEDULE FD‐A122‐60080‐045‐000 Schools & Training4,280 4,2806,3802,513 SEE SCHEDULE FD‐A122‐60096‐045‐000 Emergency Management1,400 1,4001,000220122‐60100‐045‐000 Travel & per diem13,577 13,5774,0815,194 SEE SCHEDULE FD‐A122‐60110‐045‐000 Physicals/Testing2,000 2,0004,7000 ALL STAFF WILL DO PHYSICALS AND 2 HAZMAT FIT FOR DUTY122‐60125‐045‐000 Advertising5,100 5,1005,100124 VOLUNTEER PROGRAM ADVERTISMENT122‐60160‐045‐000 Programs & Special Projects4,500 4,5007,5001,325 KIDS CAMP FOR FALL122‐60180‐045‐000 Fire Inspection/Enforcement1,000 1,000500194122‐60195‐045‐000 Flags & Repair2,000 2,0003,184‐110 ADDITIONAL POLE MAINTENANCE122‐60243‐045‐000 Prior Year Expense0000122‐60245‐045‐000 Miscellaneous Expense1,000 1,0001,000574122‐65005‐045‐000 Fuel & Lube10,454 10,45416,5164,184 SEE SCHEDULE GF‐M122‐65010‐045‐000 Uniforms2,000 3,0003,1402,049122‐65015‐045‐000 Protective Clothing5,200 35,2009,000 14,777 TWO SETS OF GEAR & ADVAMA CLEANING122‐65030‐045‐000 Chemicals200200600134 FOAM FOR NEW TRUCK122‐65035‐045‐000 Small Tools2,500 2,5002,000849122‐65055‐045‐000 Hardware 9,000 9,0007500 SEE SCHEDULE GF‐L REPLACEMENT122‐65085‐045‐000 Office Supplies50050050080122‐65105‐045‐000 Printing54854849838 SEE SCHEDULE GF‐L122‐69005‐045‐000 Capital Outlays0 250,0000 1,057,316122‐69008‐045‐000 Short Term Debt ‐Principal158,262000 SEE SCHEDULE GF‐B1122‐69009‐045‐000 Short Term Debt ‐Interest50,000000 SEE SCHEDULE GF‐B1122‐69050‐045‐000 Radios23,500 23,5008,0000 CONTINUATION OF RADIO REPLACEMENTS122‐69195‐045‐000 GASB34/Reserve for Replacement17,950 17,95076,926 17,950 1/10 COST OF NEW FIRE ENGINE122‐69255‐045‐000 Airpacks20,400 10,4000 10,235 REPLACEMENT PROGRAM FOR NFPA STANDARDS; 4 REPLACED PER YEAR ON 3 YEAR CYCLE122‐69305‐045‐000 Capital Leases00127,1490 LEASE PAYMENT NO. 1 OF 7 FOR LADDER TRUCKTotal1,383,940 1,432,551 1,365,384 1,895,258Total Fire Revenues1,383,940 1,432,551 1,365,384Total Fire Expenses1,383,940 1,432,551 1,365,384Net Budget Surplus (Deficit)000 8Trophy Club Municipal Utility District No. 19 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15TAX DEBT SERVICE FUND (I&S)AccountDescriptionOriginal Amend #2 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15CommentsDebt Service Revenues533‐40000‐000‐000 Property Taxes466,019 466,019667,898 463,487 533‐40002‐000‐000 Property Taxes/Delinquent2,500 2,5002,3001,750 533‐40015‐000‐000 Property Taxes/P & I1,600 1,6001,8001,665 533‐48005‐000‐000 Reserve Funds (PID Utility Fees/Other)100,000 14,00000 533‐48015‐000‐000 WW Sales Revenue Transfer for Debt357,538000SEE DEBT SVC I&S REVENUE533‐49010‐000‐000Interest Income3753751403,441 533‐49015‐000‐000 Lease/Rental Income211,829 211,829214,379 211,829 SEE SCHEDULE FD‐B   533‐49110‐000‐000 Premium on Bonds Sold0004,958 533‐49141‐000‐000 Interfund Transfer In‐PID Surchg0 65,255119,7060 Total1,139,861 761,5781,006,223 687,129 Debt Service Expenses533‐70005‐051‐000 Paying Agent Fee2,550 2,5502,5501,250 533‐70025‐051‐000 Bond Interest Expense‐Tax403,103 283,984316,98389,254 SEE SCHEDULE GF‐B1 (LONG TERM DEBT)533‐70035‐051‐000Bond Principal Payment‐Tax440,000 440,000685,0000 SEE SCHEDULE GF‐B1 (LONG TERM DEBT)533‐70040‐051‐000 Bond Interest Expense‐Rev Bonds292,283000SEE DEBT SVC I&S REVENUE533‐70045‐051‐000 Bond Principal Payment‐Rev Bonds0000SEE DEBT SVC I&S REVENUETotal1,137,936 726,5341,004,53390,504 Total Debt Service Fund Revenues1,139,861 761,5781,006,223 Total Debt Service Fund Expenses1,137,936 726,5341,004,533Net Budget Surplus (Deficit)1,925 35,0441,6909Trophy Club Municipal Utility District No. 110 of 33August 19, 2015 - Special Meeting Agenda Packet Trophy Club MUD No.1DRAFT FY 2016 Budget 08/19/15REVENUE DEBT SERVICE FUND (I&S)AccountDescriptionOriginal Amend #1 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15CommentsDebt Service Revenues534‐49010‐000‐000 Interest Income00710,440 534‐49110‐000 Bond Premium0004,615 534‐49142‐000‐000 Interfund Transfer In‐Water Sales0000 Water Sales Revenue Transfer for Revenue Debt Payment534‐49143‐000‐000 Interfund Transfer In‐ WW Sales0 136,989444,8310 WW Sales Revenue Transfer for Revenue Debt PaymentTotal0 136,989444,8380 Debt Service Expenses534‐70040‐051‐000Bond Interest Expense‐Rev Bonds0 136,989234,8380 See Schedule GF‐B2 (Long Term Debt)534‐70045‐051‐000 Bond Principal Payment‐Rev Bonds00210,0000 See Schedule GF‐B2 (Long Term Debt)Total0 136,989444,8380 Total Debt Service Fund Revenues0 136,989444,838 Total Debt Service Fund Expenses0 136,989444,838Net Budget Surplus (Deficit)00010Trophy Club Municipal Utility District No. 111 of 33August 19, 2015 - Special Meeting Agenda Packet Debt Reserve Fund*AccountDescriptionOriginal Amend #1 PROPOSED YTD TotalBudget Budget FY 2016 thru 6/30/15CommentsDebt Reserve Revenues528‐49141‐000‐000 Interfund transfer In‐General Fund0 71,946 123,336 41,112 $10,278 FOR 12 MONTHSTotal0 71,946 123,336 41,112Debt Reserve Expenses0000Total0000*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 Revenues0 71,946 123,336 41,112 Total Debt Service Fund Expenses0000Net Budget Surplus (Deficit)0 71,946 123,336 41,11211Trophy Club Municipal Utility District No. 112 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE TAX_ASSESSTAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONSFIRE TAX/ASSESSMENT RATEOVERALL TAX RATE FY 2016:$0.13339NET TAX VALUETARRANT COUNTY: 299,983,6617/30/2015DENTON COUNTY:932,292,6177/30/2015  DENTON CO. PID:559,559,2197/30/2015REQUIRED REVENUETAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100FIREVals/100 = 17,918,354.97FY 2016 Tax/Assess Rate = 0.074471,334,309TAX COMPARISON TO FY 2015Revenue from MUD Tax =917,627$ 2015 2016Revenue from PID Assess =416,682$ O&M (General Fund) Tax 0.01486 0.00472Total: 1,334,309$ I & S (Debt Service) Tax 0.041256 0.05420Fire Tax 0.077273 0.07447O&M TAX/SURCHARGE RATETotal Tax Rate:0.13339 0.13339NET TAX VALUEIncrease/Decrease:0.00000TARRANT COUNTY:299,983,661 DENTON COUNTY:932,292,617 PID Fire Assessment Rate0.07727 0.07447DENTON CO. PID:559,559,219 Reduction:-0.00281REQUIRED REVENUETAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100O&MVals/100 = 17,918,354.97FY 2015 Tax/Surcharge Rate = 0.00472 84,600 Revenue from MUD Tax =58,181$  Revenue from PID Surcharge =26,419$ Total: 84,600$ I&S TAX/SURCHARGE RATENEW DEBT: CALCULATE AMOUNT DUE FROM PIDNET TAX VALUETARRANT COUNTY: 299,983,661 DENTON COUNTY:932,292,617 DENTON CO. PID: 559,559,219 REQUIRED REVENUETAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100TAX NEW DEBT (I&S)Vals/100 = 17,918,354.97FY 2015 PID Surcharge Rate = 0.02139NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE383,325Revenue from MUD Tax =263,619$ Revenue from PID Surcharge = 119,706$ Total: 383,325$ MUD DEBT: CALCULATE MUD TAXNET TAX VALUETARRANT COUNTY: 299,983,661 DENTON COUNTY:932,292,617 REQUIRED REVENUETAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 I&S MUD DEBTVals/100 = 12,322,762.78FY 2016 Tax Rate =0.05420 667,898Revenue from MUD Tax = 667,898$ Revenue from PID = N/A-$ Total: 667,898$   12Trophy Club Municipal Utility District No. 113 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE FD‐A       Fire Department Dues, Training, and TravelAccountDescriptionFY 2016 BudgetDetail122‐60070 Dues & MembershipsTexas Commission on Fire Protection$1,445$85.00 per FF X 17 Annual feeTCFP Training Facility$170Annual feeSFFMA (Volunteer) $275$100 per dept, $35 per FF (5)NEFDA $12,997Annual fee increase due to equipment replacementDenton County Chiefs$280Annual fee Tarrant County Chiefs$100Annual feeTexas Fire Chiefs$150Annual feeInternational Fire Chiefs$165Annual feeTOTAL: $15,582122‐60080 Schools and TrainingTCCC Live Fire Training$700TCFP Annual Certification classes TCCC / NFA$2,0008 NFA classesTCFP / TEEX / NFA on site classes$500Instructor cost Haz‐Mat Certification $1,480(2) staff cert Conference regestration $1,700SFR / Homeland / FMC / FDICTOTAL: $6,380122‐60100 Travel and Per DiemSouthwest Fire / Rescue (Chief Conf)$720Chief or  training officer conference. Homeland Security Conference $800EMC and Training officer (1)Texas Fire Marshal Conference$840Fire Marshal Fire Department Instructor Conf (FDIC) International Fire Chiefs$1,721Chief or Training OfficerTOTAL: $4,08113Trophy Club Municipal Utility District No. 114 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE FD‐B        RENT CALCULATION FOR FIRE STATIONFYBond Payment Reimburse Reserve ($933,700)*Total Rent2016146,28368,096214,3792017148,65868,096216,7542018150,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,259 *Based on ave. rate of 3.9% for 20 years14Trophy Club Municipal Utility District No. 115 of 33August 19, 2015 - Special Meeting Agenda Packet                                                  SCHEDULE GF ‐ A                                                    FY 16 CAPITAL OUTLAYS WATER ‐  PURCHASESWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ PURCHASESDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNT1/2 Ton Truck27,000 Valley Wood Looping Water Line35,000Catepillar 416F Backhoe63,000 Transfer Switch Water Plant26,000Cost of $77,000 less projected trade in of $14,000FY 16 Valve Replacements30,000Refurnish Pump Housings Water Plant20,000   Total:90,000Total: 111,000Total:0WASTEWATER ‐  PURCHASESWASTEWATER ‐ MAINTENANCE & REPAIRSADMINISTRATION ‐ MAINTENANCE & REPAIRSDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTDESCRIPTIONAMOUNTPortable generator55,000 Lift Station Control Panels35,000 RESTROOM ADA REMODEL56,000  Lift Station Pumps45,000Fence15,000Total:55,000Total: 95,000Total:56,00015Trophy Club Municipal Utility District No. 116 of 33August 19, 2015 - Special Meeting Agenda Packet LONG TERM TAX DEBTMUD/PID PaidPar Principle FY 16 Interest 3/01 Interest 9/01 Subtotal Interest TotalMaturity DateFirst Callable DateProject/ReasonSeries 2010 (Tax)MUD$2,000,000 $75,000 $35,641 $35,641 $71,283 $146,2839/1/20319/1/2020Trophy Club Fire Station and costs related to the issuance of the Bonds.Series 2012 (Tax)MUD$2,355,000 $200,000 $24,675 $24,675 $49,350 $249,3509/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 $175,000 $24,013 $24,013 $48,025 $223,0259/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 $450,000 $84,329 $84,329 $168,658 $618,658Series 2014 (Tax) MUD/PID  $5,765,000 $235,000 $74,163 $74,163 $148,325 $383,3259/1/20359/1/2024Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014SUBTOTAL ALL MUD/PID TAX BONDS:$5,765,000 $235,000 $74,163 $74,163 $148,325 $383,325TOTAL ALL BONDS:$12,025,000 $685,000 $158,491 $158,491 $316,983 $1,001,983SCHEDULE GF ‐ B1TAX DEBT PAYMENTS16Trophy Club Municipal Utility District No. 117 of 33August 19, 2015 - Special Meeting Agenda Packet LONG TERM REVENUE DEBTMUD/PID PaidPar Principle FY 16 Interest 3/01 Interest 9/01 Subtotal Interest TotalMaturity DateFirst Callable DateProject/ReasonSeries 2015 (Revenue)$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,8389/1/20359/1/2024Revenue Bonds for WWTP ExpansionSUBTOTAL REVENUE BONDS:$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,838TOTAL ALL BONDS:$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,838 SHORT TERM REVENUE DEBTOriginal PAR Outstanding Debt Principle FY 15 Interest 3/01 Interest 9/01 Subtotal Interest TotalPayoff DateProject/ReasonDepartment2013 Revenue Note$445,000$152,000 $152,000 $1,406$0$1,406 $153,4069/1/20162013 Capital Projects86% WATER & 14% WWTotal:$445,000$152,000 $152,000 $1,406$0$1,406$153,406 SCHEDULE GF ‐ B2REVENUE DEBT PAYMENTS17Trophy Club Municipal Utility District No. 118 of 33August 19, 2015 - Special Meeting Agenda Packet ANNUALIZE GROWTH IN WATER METERS =2.00%PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2015 =4,500 ITEMMONTHPROJECTEDAVERAGEPROJECTEDNO.EOM AND AVERAGEWATER USEMONTHLY ANNUAL NO. OFPER METERWATER WATERFOR LASTUSE PER METERS3 YEARSMONTH(GALLONS)(GALLONS)3892 84,661,333 1OCT4,50821,75198,041,6963911 59,494,000 2NOV4,51515,21268,682,2183941 41,381,667 3DEC4,52310,50047,487,9833955 37,389,667 4 JAN 4,530 9,453 42,822,6863978 35,620,000 5 FEB 4,538 8,953 40,627,6194021 44,318,000 6MAR4,54511,02150,091,2564030 57,479,000 7APR4,55314,26364,935,0574075 81,762,333 8MAY4,56020,06691,508,0874095 101,693,333 9JUN4,56824,834113,438,3984113 115,294,000 10JUL4,57628,029128,250,0474146 132,760,000 11AUG4,58332,019146,747,5924135 113,284,333 12SEP4,59127,394125,762,310AVERAGE4,54918,625TOTAL1,018,394,947CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)18,625PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY16 =(METERS)91Growth Rate Meters set June 2014 through May 2015:15 per monthGrowth Rate = Ave. New Meters Set/Total Meters at May 2015(15*12)/4268 x 100% =4.2%2.0% recommendedONLY 46 PID METERS LEFT 6/15Purchased Water (gallons):1,018,394,947$2.2542 per 1000 gals$2,295,666 7.34% Increase$54,398 per month$652,776 1.90% Increase$25 per month$300 Total:$2,948,742METERS FOR LAST THREE YEARS COMBINEDWATER USE FOR LAST THREE YEARS COMBINEDService ChargeSCHEDULE GF-C PROJECTED WATER USEPROJECTED RETAIL WATER SALESPurchased Water Expense (Projected Fort Worth Costs) Out of District Volumetric Charge Rate of Use Charge 18Trophy Club Municipal Utility District No. 119 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐DPROJECTED WATER REVENUEFY 2012BeginningEnd Block Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block- 1,000 1,000 172 61,000 3,449,000 4.06%261 99,000 3,438,000 6.32%314 105,000 3,451,000 8.37%409 175,000 3,443,000 11.05%381 149,000 3,476,000 10.83%377 144,000 3,533,000 9.85%310 108,000 3,555,000 7.49%210 58,000 3,655,000 4.30%195 45,000 3,683,000 3.19%200 32,000 3,690,000 2.63%118 31,000 3,793,000 2.54%189 75,000 3,760,000 3.41%3,136 1,082,000 42,926,000 4.63%1,000 2,000 1,000 67 134,000 3,388,000 3.99%187 374,000 3,339,000 6.14%198 396,000 3,346,000 8.11%273 546,000 3,268,000 10.48%282 564,000 3,327,000 10.37%254 508,000 3,389,000 9.44%171 342,000 3,447,000 7.26%87 174,000 3,597,000 4.23%51 102,000 3,638,000 3.15%40 80,000 3,658,000 2.61%41 82,000 3,762,000 2.51%66 132,000 3,685,000 3.35%1,717 3,434,000 41,844,000 4.51%2,000 3,000 1,000 100 300,000 3,321,000 3.91%245 735,000 3,152,000 5.80%268 804,000 3,148,000 7.63%398 1,194,000 2,995,000 9.61%380 1,140,000 3,045,000 9.49%370 1,110,000 3,135,000 8.74%267 801,000 3,276,000 6.90%75 225,000 3,510,000 4.13%67 201,000 3,587,000 3.11%41 123,000 3,618,000 2.58%46 138,000 3,721,000 2.49%88 264,000 3,619,000 3.29%2,345 7,035,000 40,127,000 4.33%3,000 4,000 1,000 105 420,000 3,221,000 3.79%292 1,168,000 2,907,000 5.35%328 1,312,000 2,880,000 6.98%478 1,912,000 2,597,000 8.33%484 1,936,000 2,665,000 8.30%446 1,784,000 2,765,000 7.71%297 1,188,000 3,009,000 6.34%88 352,000 3,435,000 4.04%61 244,000 3,520,000 3.05%52 208,000 3,577,000 2.55%35 140,000 3,675,000 2.46%81 324,000 3,531,000 3.21%2,747 10,988,000 37,782,000 4.07%4,000 5,000 1,000 90 450,000 3,116,000 3.67%234 1,170,000 2,615,000 4.81%381 1,905,000 2,552,000 6.19%435 2,175,000 2,119,000 6.80%419 2,095,000 2,181,000 6.80%370 1,850,000 2,319,000 6.46%275 1,375,000 2,712,000 5.71%107 535,000 3,347,000 3.94%66 330,000 3,459,000 3.00%56 280,000 3,525,000 2.52%48 240,000 3,640,000 2.43%86 430,000 3,450,000 3.13%2,567 12,835,000 35,035,000 3.78%5,000 6,000 1,000 112 672,000 3,026,000 3.56%243 1,458,000 2,381,000 4.38%322 1,932,000 2,171,000 5.26%348 2,088,000 1,684,000 5.40%377 2,262,000 1,762,000 5.49%339 2,034,000 1,949,000 5.43%267 1,602,000 2,437,000 5.13%102 612,000 3,240,000 3.81%83 498,000 3,393,000 2.94%36 216,000 3,469,000 2.48%35 210,000 3,592,000 2.40%89 534,000 3,364,000 3.06%2,353 14,118,000 32,468,000 3.50%6,000 7,000 1,000 101 707,000 2,914,000 3.43%227 1,589,000 2,138,000 3.93%278 1,946,000 1,849,000 4.48%285 1,995,000 1,336,000 4.29%270 1,890,000 1,385,000 4.32%257 1,799,000 1,610,000 4.49%226 1,582,000 2,170,000 4.57%87 609,000 3,138,000 3.69%79 553,000 3,310,000 2.87%49 343,000 3,433,000 2.45%43 301,000 3,557,000 2.38%84 588,000 3,275,000 2.97%1,986 13,902,000 30,115,000 3.25%7,000 8,000 1,000 115 920,000 2,813,000 3.31%177 1,416,000 1,911,000 3.52%245 1,960,000 1,571,000 3.81%198 1,584,000 1,051,000 3.37%224 1,792,000 1,115,000 3.47%221 1,768,000 1,353,000 3.77%208 1,664,000 1,944,000 4.10%107 856,000 3,051,000 3.59%90 720,000 3,231,000 2.80%45 360,000 3,384,000 2.41%58 464,000 3,514,000 2.35%79 632,000 3,191,000 2.90%1,767 14,136,000 28,129,000 3.03%8,000 9,000 1,000 130 1,170,000 2,698,000 3.18%171 1,539,000 1,734,000 3.19%193 1,737,000 1,326,000 3.21%148 1,332,000 853,000 2.74%169 1,521,000 891,000 2.78%171 1,539,000 1,132,000 3.15%186 1,674,000 1,736,000 3.66%149 1,341,000 2,944,000 3.46%90 810,000 3,141,000 2.72%69 621,000 3,339,000 2.38%48 432,000 3,456,000 2.31%103 927,000 3,112,000 2.83%1,627 14,643,000 26,362,000 2.84%9,000 14,000 5,000 634 7,644,000 11,608,000 13.66%619 7,266,000 6,415,000 11.80%582 6,725,000 4,242,000 10.28%399 4,536,000 2,475,000 7.94%424 4,874,000 2,548,000 7.94%517 6,001,000 3,568,000 9.94%686 8,070,000 6,216,000 13.10%608 7,334,000 12,797,000 15.05%537 6,475,000 14,212,000 12.31%368 4,481,000 15,679,000 11.19%355 4,283,000 16,353,000 10.93%510 6,176,000 14,081,000 12.79%6,239 73,865,000 110,194,000 11.88%14,000 17,000 3,000 395 6,311,000 5,398,000 6.35%228 3,626,000 2,582,000 4.75%155 2,470,000 1,488,000 3.61%101 1,605,000 806,000 2.59%85 1,336,000 785,000 2.45%144 2,292,000 1,176,000 3.28%283 4,509,000 2,290,000 4.82%402 6,417,000 6,144,000 7.23%332 5,335,000 7,233,000 6.26%289 4,621,000 8,414,000 6.00%268 4,313,000 8,916,000 5.96%372 5,956,000 7,129,000 6.47%3,054 48,791,000 52,361,000 5.65%17,000 20,000 3,000 339 6,428,000 4,265,000 5.02%188 3,561,000 1,949,000 3.58%104 1,970,000 1,078,000 2.61%51 958,000 553,000 1.77%58 1,094,000 573,000 1.79%94 1,786,000 806,000 2.25%191 3,630,000 1,553,000 3.27%382 7,249,000 4,964,000 5.84%350 6,653,000 6,199,000 5.37%332 6,321,000 7,520,000 5.37%302 5,747,000 8,062,000 5.39%360 6,832,000 6,013,000 5.46%2,751 52,229,000 43,535,000 4.69%20,000 25,000 5,000 383 8,799,000 5,224,000 6.15%188 4,312,000 2,252,000 4.14%116 2,631,000 1,191,000 2.89%54 1,223,000 643,000 2.06%49 1,114,000 664,000 2.07%77 1,725,000 830,000 2.31%162 3,710,000 1,610,000 3.39%489 11,217,000 6,007,000 7.07%496 11,325,000 8,085,000 7.00%535 12,294,000 10,324,000 7.37%533 12,243,000 11,333,000 7.57%512 11,781,000 7,816,000 7.10%3,594 82,374,000 55,979,000 6.04%25,000 29,000 4,000 238 6,486,000 2,852,000 3.36%88 2,405,000 1,213,000 2.23%36 988,000 648,000 1.57%13 350,000 373,000 1.20%18 498,000 400,000 1.25%20 548,000 484,000 1.35%52 1,423,000 827,000 1.74%259 7,074,000 3,219,000 3.79%298 8,152,000 4,854,000 4.20%347 9,536,000 6,457,000 4.61%387 10,664,000 7,241,000 4.84%315 8,642,000 4,527,000 4.11%2,071 56,766,000 33,095,000 3.57%29,000 34,000 5,000 198 6,303,000 2,466,000 2.90%75 2,382,000 1,092,000 2.01%26 833,000 649,000 1.57%18 572,000 395,000 1.27%16 501,000 397,000 1.24%27 858,000 485,000 1.35%44 1,394,000 778,000 1.64%204 6,473,000 2,812,000 3.31%326 10,403,000 4,509,000 3.91%389 12,408,000 6,177,000 4.41%378 12,037,000 7,000,000 4.68%284 9,023,000 4,067,000 3.69%1,985 63,187,000 30,827,000 3.32%34,000 39,000 5,000 105 3,869,000 1,679,000 1.98%37 1,359,000 801,000 1.47%14 518,000 542,000 1.31%6 222,000 333,000 1.07%10 372,000 342,000 1.07%15 548,000 373,000 1.04%32 1,182,000 594,000 1.25%132 4,863,000 1,970,000 2.32%191 7,019,000 3,130,000 2.71%270 9,951,000 4,471,000 3.19%296 10,919,000 5,300,000 3.54%185 6,833,000 2,898,000 2.63%1,293 47,655,000 22,433,000 2.42%39,000 44,000 5,000 61 2,538,000 1,234,000 1.45%24 1,002,000 646,000 1.19%12 509,000 481,000 1.17%7 292,000 299,000 0.96%8 343,000 301,000 0.94%7 290,000 317,000 0.88%12 508,000 480,000 1.01%92 3,838,000 1,385,000 1.63%125 5,216,000 2,321,000 2.01%178 7,451,000 3,319,000 2.37%226 9,472,000 3,973,000 2.66%124 5,167,000 2,066,000 1.88%876 36,626,000 16,822,000 1.81%44,000 50,000 6,000 41 1,943,000 1,183,000 1.39%20 939,000 635,000 1.17%10 477,000 505,000 1.22%4 185,000 321,000 1.03%3 139,000 313,000 0.98%7 334,000 344,000 0.96%17 804,000 482,000 1.02%65 3,050,000 1,162,000 1.37%120 5,670,000 2,046,000 1.77%176 8,370,000 2,942,000 2.10%192 9,087,000 3,465,000 2.32%100 4,724,000 1,806,000 1.64%755 35,722,000 15,204,000 1.64%50,000 59,000 9,000 44 2,400,000 1,370,000 1.61%15 832,000 811,000 1.49%16 874,000 632,000 1.53%4 217,000 449,000 1.44%8 454,000 441,000 1.37%6 332,000 455,000 1.27%13 724,000 596,000 1.26%42 2,290,000 1,270,000 1.49%93 5,058,000 2,055,000 1.78%122 6,641,000 2,917,000 2.08%149 8,093,000 3,541,000 2.37%85 4,618,000 1,826,000 1.66%597 32,533,000 16,363,000 1.76%59,000 69,000 10,000 22 1,399,000 1,181,000 1.39%11 708,000 759,000 1.40%8 516,000 584,000 1.42%5 325,000 460,000 1.48%9 559,000 368,000 1.15%7 461,000 448,000 1.25%8 506,000 534,000 1.13%31 2,010,000 1,071,000 1.26%44 2,807,000 1,601,000 1.39%78 4,974,000 2,232,000 1.59%105 6,705,000 2,680,000 1.79%40 2,559,000 1,419,000 1.29%368 23,529,000 13,337,000 1.44%69,000 +108 26,009,000 18,557,000 21.84%70 16,426,000 11,596,000 21.33%54 10,641,000 6,915,000 16.76%43 7,686,000 4,719,000 15.14%34 7,462,000 5,116,000 15.94%40 8,174,000 5,414,000 15.09%50 10,668,000 7,218,000 15.21%89 18,441,000 12,300,000 14.47%139 37,838,000 28,247,000 24.47%186 50,837,000 38,003,000 27.12%217 54,013,000 39,040,000 26.09%122 33,892,000 25,474,000 23.14%1,152 282,087,000 202,599,000 21.84%3,560 84,963,000 84,963,000 100.00% 3,600 54,366,000 54,366,000 100.00% 3,660 41,249,000 41,249,000 100.00% 3,677 31,172,000 31,172,000 100.00% 3,708 32,095,000 32,095,000 100.00% 3,766 35,885,000 35,885,000 100.00% 3,757 47,464,000 47,464,000 100.00% 3,807 85,018,000 85,018,000 100.00% 3,833 115,454,000 115,454,000 100.00% 3,858 140,148,000 140,148,000 100.00% 3,880 149,614,000 149,614,000 100.00% 3,874 110,109,000 110,109,000 100.00% 44,980 927,537,000 927,537,000 100.00%FY 2013BeginningEnd Block Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block- 1,000 1,000 225 88,000 3,786,000 4.42%211 87,000 3,799,000 5.09%282 151,000 3,810,000 7.88%273 124,000 3,795,000 9.40%357 187,000 3,796,000 10.87%306 136,000 3,838,000 8.83%245 104,000 3,889,000 6.72%240 83,000 3,929,000 5.00%206 75,000 3,967,000 4.48%217 53,000 3,978,000 3.60%184 53,000 4,035,000 3.05%186 57,000 4,036,000 3.49%2,932 1,198,000 46,658,000 5.12%1,000 2,000 1,000 104 208,000 3,698,000 4.32%96 192,000 3,712,000 4.97%238 476,000 3,659,000 7.57%198 396,000 3,671,000 9.10%343 686,000 3,609,000 10.33%200 400,000 3,702,000 8.52%160 320,000 3,785,000 6.54%112 224,000 3,846,000 4.89%77 154,000 3,892,000 4.39%76 152,000 3,925,000 3.55%59 118,000 3,982,000 3.01%44 88,000 3,979,000 3.44%1,707 3,414,000 45,460,000 4.99%2,000 3,000 1,000 118 354,000 3,594,000 4.20%132 396,000 3,616,000 4.84%287 861,000 3,421,000 7.08%292 876,000 3,473,000 8.61%467 1,401,000 3,266,000 9.35%324 972,000 3,502,000 8.06%199 597,000 3,625,000 6.27%117 351,000 3,734,000 4.75%111 333,000 3,815,000 4.31%62 186,000 3,849,000 3.48%56 168,000 3,923,000 2.96%73 219,000 3,935,000 3.40%2,238 6,714,000 43,753,000 4.80%3,000 4,000 1,000 125 500,000 3,476,000 4.06%155 620,000 3,484,000 4.67%337 1,348,000 3,134,000 6.48%381 1,524,000 3,181,000 7.88%606 2,424,000 2,799,000 8.01%405 1,620,000 3,178,000 7.31%261 1,044,000 3,426,000 5.92%155 620,000 3,617,000 4.60%126 504,000 3,704,000 4.18%62 248,000 3,787,000 3.43%69 276,000 3,867,000 2.92%60 240,000 3,862,000 3.34%2,742 10,968,000 41,515,000 4.56%4,000 5,000 1,000 160 800,000 3,351,000 3.92%177 885,000 3,329,000 4.46%367 1,835,000 2,797,000 5.79%432 2,160,000 2,800,000 6.94%457 2,285,000 2,193,000 6.28%409 2,045,000 2,773,000 6.38%274 1,370,000 3,165,000 5.47%161 805,000 3,462,000 4.40%147 735,000 3,578,000 4.04%78 390,000 3,725,000 3.37%63 315,000 3,798,000 2.87%63 315,000 3,802,000 3.29%2,788 13,940,000 38,773,000 4.26%5,000 6,000 1,000 150 900,000 3,191,000 3.73%180 1,080,000 3,152,000 4.22%309 1,854,000 2,430,000 5.03%443 2,658,000 2,368,000 5.87%361 2,166,000 1,736,000 4.97%330 1,980,000 2,364,000 5.44%270 1,620,000 2,891,000 5.00%164 984,000 3,301,000 4.20%148 888,000 3,431,000 3.87%73 438,000 3,647,000 3.30%64 384,000 3,735,000 2.82%64 384,000 3,739,000 3.23%2,556 15,336,000 35,985,000 3.95%6,000 7,000 1,000 159 1,113,000 3,041,000 3.55%176 1,232,000 2,972,000 3.98%282 1,974,000 2,121,000 4.39%387 2,709,000 1,925,000 4.77%272 1,904,000 1,375,000 3.94%311 2,177,000 2,034,000 4.68%277 1,939,000 2,621,000 4.53%169 1,183,000 3,137,000 3.99%148 1,036,000 3,283,000 3.71%81 567,000 3,574,000 3.24%49 343,000 3,671,000 2.77%93 651,000 3,675,000 3.18%2,404 16,828,000 33,429,000 3.67%7,000 8,000 1,000 152 1,216,000 2,882,000 3.37%175 1,400,000 2,796,000 3.74%259 2,072,000 1,839,000 3.80%311 2,488,000 1,538,000 3.81%211 1,688,000 1,103,000 3.16%232 1,856,000 1,723,000 3.97%242 1,936,000 2,344,000 4.05%154 1,232,000 2,968,000 3.77%136 1,088,000 3,135,000 3.54%102 816,000 3,493,000 3.16%60 480,000 3,622,000 2.74%84 672,000 3,582,000 3.10%2,118 16,944,000 31,025,000 3.41%8,000 9,000 1,000 136 1,224,000 2,730,000 3.19%178 1,602,000 2,621,000 3.51%215 1,935,000 1,580,000 3.27%209 1,881,000 1,227,000 3.04%144 1,296,000 892,000 2.55%206 1,854,000 1,491,000 3.43%251 2,259,000 2,102,000 3.63%206 1,854,000 2,814,000 3.58%158 1,422,000 2,999,000 3.39%97 873,000 3,391,000 3.07%76 684,000 3,562,000 2.69%106 954,000 3,498,000 3.02%1,982 17,838,000 28,907,000 3.17%9,000 14,000 5,000 713 8,543,000 11,531,000 13.47%828 9,891,000 10,514,000 14.08%711 8,366,000 5,237,000 10.83%621 7,190,000 3,586,000 8.89%368 4,258,000 2,846,000 8.15%663 7,723,000 4,866,000 11.20%777 9,055,000 7,432,000 12.85%841 10,110,000 11,376,000 14.47%828 9,922,000 12,535,000 14.15%626 7,634,000 15,340,000 13.89%446 5,423,000 16,609,000 12.55%598 7,179,000 15,767,000 13.63%8,020 95,294,000 117,639,000 12.91%14,000 17,000 3,000 396 6,323,000 5,234,000 6.12%389 6,175,000 4,407,000 5.90%201 3,190,000 1,735,000 3.59%122 1,952,000 1,069,000 2.65%120 1,903,000 1,003,000 2.87%207 3,286,000 1,633,000 3.76%290 4,638,000 2,930,000 5.07%400 6,371,000 4,872,000 6.19%399 6,346,000 5,602,000 6.32%412 6,591,000 7,591,000 6.87%325 5,244,000 8,839,000 6.68%440 7,055,000 7,957,000 6.88%3,701 59,074,000 52,872,000 5.80%17,000 20,000 3,000 340 6,446,000 4,101,000 4.79%301 5,684,000 3,342,000 4.48%107 2,015,000 1,234,000 2.55%64 1,211,000 756,000 1.87%60 1,141,000 721,000 2.06%98 1,844,000 1,129,000 2.60%198 3,749,000 2,141,000 3.70%332 6,266,000 3,727,000 4.74%373 7,066,000 4,448,000 5.02%401 7,617,000 6,365,000 5.76%376 7,143,000 7,768,000 5.87%406 7,708,000 6,650,000 5.75%3,056 57,890,000 42,382,000 4.65%20,000 25,000 5,000 362 8,273,000 4,948,000 5.78%340 7,768,000 3,893,000 5.21%127 2,887,000 1,442,000 2.98%68 1,539,000 894,000 2.22%73 1,636,000 811,000 2.32%138 3,119,000 1,254,000 2.89%237 5,385,000 2,390,000 4.13%375 8,571,000 4,371,000 5.56%429 9,761,000 5,241,000 5.92%589 13,501,000 8,051,000 7.29%579 13,318,000 10,538,000 7.96%632 14,499,000 8,439,000 7.29%3,949 90,257,000 52,272,000 5.74%25,000 29,000 4,000 207 5,678,000 2,807,000 3.28%152 4,169,000 2,101,000 2.81%61 1,671,000 778,000 1.61%32 885,000 529,000 1.31%18 497,000 483,000 1.38%47 1,280,000 633,000 1.46%114 3,122,000 1,212,000 2.10%186 5,075,000 2,321,000 2.95%252 6,862,000 2,802,000 3.16%324 8,903,000 4,571,000 4.14%373 10,229,000 6,452,000 4.87%347 9,547,000 4,748,000 4.10%2,113 57,918,000 29,437,000 3.23%29,000 34,000 5,000 181 5,763,000 2,489,000 2.91%122 3,848,000 1,865,000 2.50%41 1,305,000 701,000 1.45%20 641,000 516,000 1.28%21 661,000 492,000 1.41%30 939,000 579,000 1.33%69 2,200,000 1,029,000 1.78%163 5,186,000 2,014,000 2.56%195 6,180,000 2,350,000 2.65%295 9,363,000 4,043,000 3.66%398 12,651,000 6,054,000 4.57%305 9,692,000 4,167,000 3.60%1,840 58,429,000 26,299,000 2.89%34,000 39,000 5,000 107 3,952,000 1,754,000 2.05%90 3,305,000 1,350,000 1.81%15 556,000 556,000 1.15%13 476,000 424,000 1.05%9 327,000 416,000 1.19%19 701,000 470,000 1.08%44 1,610,000 724,000 1.25%101 3,739,000 1,355,000 1.72%102 3,757,000 1,604,000 1.81%195 7,198,000 2,828,000 2.56%265 9,730,000 4,340,000 3.28%196 7,201,000 2,877,000 2.49%1,156 42,552,000 18,698,000 2.05%39,000 44,000 5,000 73 3,037,000 1,265,000 1.48%49 2,067,000 1,016,000 1.36%8 338,000 496,000 1.03%10 420,000 370,000 0.92%13 549,000 372,000 1.06%11 461,000 392,000 0.90%19 793,000 567,000 0.98%51 2,122,000 928,000 1.18%72 3,012,000 1,159,000 1.31%130 5,457,000 1,997,000 1.81%184 7,697,000 3,221,000 2.43%136 5,681,000 2,037,000 1.76%756 31,634,000 13,820,000 1.52%44,000 50,000 6,000 60 2,851,000 1,141,000 1.33%32 1,505,000 937,000 1.25%9 425,000 539,000 1.12%9 420,000 378,000 0.94%4 196,000 392,000 1.12%12 560,000 392,000 0.90%15 715,000 583,000 1.01%26 1,229,000 883,000 1.12%48 2,252,000 998,000 1.13%92 4,364,000 1,696,000 1.54%168 7,955,000 2,795,000 2.11%92 4,347,000 1,739,000 1.50%567 26,819,000 12,473,000 1.37%50,000 59,000 9,000 32 1,749,000 1,256,000 1.47%32 1,743,000 1,115,000 1.49%10 551,000 726,000 1.50%5 283,000 519,000 1.29%10 554,000 522,000 1.49%8 439,000 507,000 1.17%17 942,000 731,000 1.26%38 2,064,000 1,019,000 1.30%40 2,176,000 1,103,000 1.25%64 3,513,000 1,807,000 1.64%134 7,284,000 2,726,000 2.06%73 3,961,000 1,814,000 1.57%463 25,259,000 13,845,000 1.52%59,000 69,000 10,000 18 1,160,000 1,148,000 1.34%17 1,079,000 986,000 1.32%13 849,000 702,000 1.45%5 307,000 502,000 1.24%2 130,000 512,000 1.47%4 248,000 492,000 1.13%10 624,000 644,000 1.11%14 898,000 882,000 1.12%13 850,000 983,000 1.11%45 2,869,000 1,424,000 1.29%73 4,683,000 2,026,000 1.53%42 2,683,000 1,455,000 1.26%256 16,380,000 11,756,000 1.29%69,000 +105 25,404,000 18,159,000 21.22%91 19,940,000 13,661,000 18.30%62 13,680,000 9,402,000 19.45%49 10,218,000 6,837,000 16.94%50 9,047,000 5,597,000 16.02%48 9,813,000 6,501,000 14.96%61 13,811,000 9,602,000 16.60%81 19,678,000 14,089,000 17.91%90 24,169,000 17,959,000 20.27%121 29,741,000 21,392,000 19.36%165 38,198,000 26,813,000 20.26%125 32,580,000 23,955,000 20.70%1,048 246,279,000 173,967,000 19.10%3,923 85,582,000 85,582,000 100.00% 3,923 74,668,000 74,668,000 100.00% 3,941 48,339,000 48,339,000 100.00% 3,944 40,358,000 40,358,000 100.00% 3,966 34,936,000 34,936,000 100.00% 4,008 43,453,000 43,453,000 100.00% 4,030 57,833,000 57,833,000 100.00% 4,086 78,645,000 78,645,000 100.00% 4,098 88,588,000 88,588,000 100.00% 4,142 110,474,000 110,474,000 100.00% 4,166 132,376,000 132,376,000 100.00% 4,165 115,713,000 115,713,000 100.00% 48,392 910,965,000 910,965,000 100.00%FY 2014BeginningEnd Block Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% Consumption Number of Consumption% ConsumptionBlockBlockValueAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy BlockAccountsReportedTotalBy Block- 1,000 1,000 213 73,000 4,054,000 4.86%310 129,000 4,029,000 8.15%390 182,000 4,014,000 11.62%342 133,000 4,036,000 9.93%359 147,000 4,049,000 10.17%294 131,000 4,127,000 7.70%260 103,000 4,146,000 6.18%233 104,000 4,202,000 5.15%184 66,000 4,236,000 4.19%170 62,000 4,232,000 4.44%170 56,000 4,279,000 3.68%172 64,000 4,259,000 3.73%3,097 1,250,000 49,663,000 5.66%1,000 2,000 1,000 104 208,000 3,981,000 4.77%230 460,000 3,900,000 7.89%318 636,000 3,832,000 11.09%224 448,000 3,903,000 9.60%265 530,000 3,902,000 9.80%183 366,000 3,996,000 7.45%166 332,000 4,043,000 6.02%105 210,000 4,098,000 5.02%85 170,000 4,170,000 4.13%91 182,000 4,170,000 4.38%56 112,000 4,223,000 3.63%56 112,000 4,195,000 3.68%1,883 3,766,000 48,413,000 5.52%2,000 3,000 1,000 140 420,000 3,877,000 4.65%344 1,032,000 3,670,000 7.42%501 1,503,000 3,514,000 10.17%365 1,095,000 3,679,000 9.05%435 1,305,000 3,637,000 9.13%307 921,000 3,813,000 7.11%236 708,000 3,877,000 5.77%138 414,000 3,993,000 4.89%85 255,000 4,085,000 4.04%113 339,000 4,079,000 4.28%72 216,000 4,167,000 3.58%64 192,000 4,139,000 3.63%2,800 8,400,000 46,530,000 5.31%3,000 4,000 1,000 137 548,000 3,737,000 4.48%439 1,756,000 3,326,000 6.73%586 2,344,000 3,013,000 8.72%515 2,060,000 3,314,000 8.15%483 1,932,000 3,202,000 8.04%354 1,416,000 3,506,000 6.54%284 1,136,000 3,641,000 5.42%154 616,000 3,855,000 4.72%116 464,000 4,000,000 3.96%122 488,000 3,966,000 4.16%85 340,000 4,095,000 3.52%80 320,000 4,075,000 3.57%3,355 13,420,000 43,730,000 4.99%4,000 5,000 1,000 171 855,000 3,600,000 4.31%391 1,955,000 2,887,000 5.84%532 2,660,000 2,427,000 7.02%495 2,475,000 2,799,000 6.89%500 2,500,000 2,719,000 6.83%402 2,010,000 3,152,000 5.88%258 1,290,000 3,357,000 5.00%155 775,000 3,701,000 4.53%110 550,000 3,884,000 3.84%126 630,000 3,844,000 4.04%92 460,000 4,010,000 3.45%102 510,000 3,995,000 3.50%3,334 16,670,000 40,375,000 4.60%5,000 6,000 1,000 178 1,068,000 3,429,000 4.11%348 2,088,000 2,496,000 5.05%443 2,658,000 1,895,000 5.48%467 2,802,000 2,304,000 5.67%468 2,808,000 2,219,000 5.57%357 2,142,000 2,750,000 5.13%288 1,728,000 3,099,000 4.62%182 1,092,000 3,546,000 4.34%105 630,000 3,774,000 3.74%140 840,000 3,718,000 3.90%100 600,000 3,918,000 3.37%71 426,000 3,893,000 3.41%3,147 18,882,000 37,041,000 4.22%6,000 7,000 1,000 199 1,393,000 3,251,000 3.90%303 2,121,000 2,148,000 4.34%314 2,198,000 1,452,000 4.20%384 2,688,000 1,837,000 4.52%318 2,226,000 1,751,000 4.40%283 1,981,000 2,393,000 4.46%276 1,932,000 2,811,000 4.19%169 1,183,000 3,364,000 4.12%115 805,000 3,669,000 3.63%142 994,000 3,578,000 3.76%102 714,000 3,818,000 3.28%108 756,000 3,822,000 3.35%2,713 18,991,000 33,894,000 3.87%7,000 8,000 1,000 166 1,328,000 3,052,000 3.66%226 1,808,000 1,845,000 3.73%244 1,952,000 1,138,000 3.29%303 2,424,000 1,453,000 3.58%273 2,184,000 1,433,000 3.60%288 2,304,000 2,110,000 3.94%207 1,656,000 2,535,000 3.78%169 1,352,000 3,195,000 3.91%128 1,024,000 3,554,000 3.52%144 1,152,000 3,436,000 3.61%87 696,000 3,716,000 3.20%95 760,000 3,714,000 3.26%2,330 18,640,000 31,181,000 3.56%8,000 9,000 1,000 156 1,404,000 2,886,000 3.46%180 1,620,000 1,619,000 3.27%156 1,404,000 894,000 2.59%225 2,025,000 1,150,000 2.83%198 1,782,000 1,160,000 2.91%237 2,133,000 1,822,000 3.40%209 1,881,000 2,328,000 3.47%179 1,611,000 3,026,000 3.71%128 1,152,000 3,426,000 3.39%162 1,458,000 3,292,000 3.46%108 972,000 3,629,000 3.12%116 1,044,000 3,619,000 3.17%2,054 18,486,000 28,851,000 3.29%9,000 14,000 5,000 803 9,598,000 12,006,000 14.39%662 7,768,000 5,695,000 11.52%435 4,983,000 2,583,000 7.47%562 6,467,000 3,224,000 7.93%598 6,845,000 3,283,000 8.24%776 9,053,000 6,114,000 11.40%793 9,496,000 8,989,000 13.39%935 11,132,000 12,277,000 15.04%775 9,341,000 14,981,000 14.83%869 10,428,000 13,912,000 14.60%685 8,295,000 16,310,000 14.03%731 8,838,000 16,119,000 14.14%8,624 102,244,000 115,493,000 13.17%14,000 17,000 3,000 425 6,806,000 5,362,000 6.43%237 3,785,000 2,087,000 4.22%90 1,431,000 810,000 2.34%123 1,960,000 958,000 2.36%116 1,834,000 954,000 2.40%236 3,765,000 2,180,000 4.07%346 5,532,000 3,628,000 5.40%491 7,827,000 5,216,000 6.39%519 8,314,000 7,060,000 6.99%514 8,191,000 6,236,000 6.55%468 7,531,000 8,083,000 6.95%488 7,837,000 7,857,000 6.89%4,053 64,813,000 50,431,000 5.75%17,000 20,000 3,000 356 6,701,000 4,087,000 4.90%167 3,173,000 1,453,000 2.94%47 887,000 586,000 1.70%56 1,054,000 654,000 1.61%67 1,271,000 675,000 1.69%178 3,351,000 1,510,000 2.82%255 4,842,000 2,682,000 3.99%383 7,244,000 3,847,000 4.71%441 8,371,000 5,563,000 5.51%431 8,138,000 4,759,000 5.00%422 7,989,000 6,653,000 5.72%491 9,323,000 6,355,000 5.57%3,294 62,344,000 38,824,000 4.43%20,000 25,000 5,000 411 9,325,000 4,780,000 5.73%136 3,098,000 1,563,000 3.16%52 1,178,000 708,000 2.05%52 1,181,000 801,000 1.97%59 1,337,000 767,000 1.93%141 3,193,000 1,643,000 3.06%269 6,123,000 3,023,000 4.50%376 8,571,000 4,361,000 5.34%527 12,044,000 6,684,000 6.62%482 11,065,000 5,595,000 5.87%638 14,570,000 8,350,000 7.18%584 13,295,000 7,660,000 6.72%3,727 84,980,000 45,935,000 5.24%25,000 29,000 4,000 220 6,024,000 2,584,000 3.10%66 1,802,000 836,000 1.69%16 437,000 429,000 1.24%27 734,000 479,000 1.18%32 865,000 425,000 1.07%70 1,916,000 902,000 1.68%140 3,825,000 1,589,000 2.37%225 6,139,000 2,262,000 2.77%307 8,415,000 3,656,000 3.62%228 6,225,000 2,949,000 3.10%358 9,828,000 4,678,000 4.02%323 8,842,000 4,311,000 3.78%2,012 55,052,000 25,100,000 2.86%29,000 34,000 5,000 183 5,841,000 2,194,000 2.63%43 1,373,000 766,000 1.55%17 545,000 457,000 1.32%22 706,000 483,000 1.19%13 411,000 419,000 1.05%50 1,570,000 790,000 1.47%107 3,420,000 1,362,000 2.03%145 4,592,000 1,847,000 2.26%231 7,363,000 3,154,000 3.12%202 6,433,000 2,595,000 2.72%288 9,160,000 4,118,000 3.54%273 8,706,000 3,854,000 3.38%1,574 50,120,000 22,039,000 2.51%34,000 39,000 5,000 85 3,111,000 1,456,000 1.74%19 691,000 590,000 1.19%11 412,000 388,000 1.12%10 374,000 399,000 0.98%13 483,000 361,000 0.91%15 552,000 637,000 1.19%50 1,844,000 939,000 1.40%89 3,272,000 1,261,000 1.54%147 5,427,000 2,184,000 2.16%124 4,576,000 1,760,000 1.85%199 7,298,000 2,847,000 2.45%170 6,214,000 2,649,000 2.32%932 34,254,000 15,471,000 1.76%39,000 44,000 5,000 63 2,632,000 1,095,000 1.31%16 676,000 517,000 1.05%10 422,000 332,000 0.96%8 332,000 345,000 0.85%7 289,000 301,000 0.76%14 591,000 570,000 1.06%24 1,007,000 746,000 1.11%44 1,816,000 895,000 1.10%94 3,925,000 1,544,000 1.53%84 3,532,000 1,236,000 1.30%127 5,319,000 2,046,000 1.76%109 4,569,000 1,988,000 1.74%600 25,110,000 11,615,000 1.32%44,000 50,000 6,000 38 1,800,000 1,004,000 1.20%12 556,000 514,000 1.04%9 421,000 331,000 0.96%7 331,000 371,000 0.91%6 276,000 318,000 0.80%9 420,000 600,000 1.12%21 995,000 755,000 1.12%38 1,796,000 850,000 1.04%62 2,944,000 1,386,000 1.37%43 2,013,000 1,039,000 1.09%82 3,859,000 1,775,000 1.53%103 4,871,000 1,725,000 1.51%430 20,282,000 10,668,000 1.22%50,000 59,000 9,000 24 1,307,000 1,205,000 1.44%9 479,000 677,000 1.37%7 383,000 429,000 1.24%8 430,000 480,000 1.18%4 209,000 432,000 1.08%21 1,143,000 768,000 1.43%21 1,153,000 940,000 1.40%20 1,090,000 999,000 1.22%59 3,193,000 1,467,000 1.45%33 1,802,000 1,232,000 1.29%79 4,290,000 1,915,000 1.65%61 3,319,000 1,799,000 1.58%346 18,798,000 12,343,000 1.41%59,000 69,000 10,000 23 1,481,000 1,114,000 1.34%14 888,000 642,000 1.30%4 256,000 420,000 1.22%9 584,000 463,000 1.14%9 575,000 424,000 1.06%14 901,000 685,000 1.28%13 825,000 858,000 1.28%18 1,162,000 930,000 1.14%30 1,936,000 1,226,000 1.21%17 1,089,000 1,116,000 1.17%51 3,299,000 1,530,000 1.32%38 2,428,000 1,506,000 1.32%240 15,424,000 10,914,000 1.24%69,000 +99 21,516,000 14,685,000 17.60%58 12,190,000 8,188,000 16.56%40 7,665,000 4,905,000 14.19%41 10,336,000 7,507,000 18.47%38 10,020,000 7,398,000 18.57%61 13,757,000 9,548,000 17.81%80 17,312,000 11,792,000 17.56%83 19,626,000 13,899,000 17.03%106 24,649,000 17,335,000 17.16%103 25,623,000 18,516,000 19.44%124 30,686,000 22,130,000 19.03%132 31,605,000 22,497,000 19.73%965 224,985,000 158,400,000 18.06%4,194 83,439,000 83,439,000 100.00% 4,210 49,448,000 49,448,000 100.00% 4,222 34,557,000 34,557,000 100.00% 4,245 40,639,000 40,639,000 100.00% 4,261 39,829,000 39,829,000 100.00% 4,290 53,616,000 53,616,000 100.00% 4,303 67,140,000 67,140,000 100.00% 4,331 81,624,000 81,624,000 100.00% 4,354 101,038,000 101,038,000 100.00% 4,340 95,260,000 95,260,000 100.00% 4,393 116,290,000 116,290,000 100.00% 4,367 114,031,000 114,031,000 100.00% 51,510 876,911,000 876,911,000 100.00%PROJECTED REVENUEProjected Number of Meters - Oct 1st4,498 Projected Growth Rate2.00%Projected Accounts4,505 4,513 4,521 4,529 4,537 4,545 4,553 4,561 4,569 4,577 4,585 4,593 4,601 Projected Average Con per Account21,859 15,293 10,574 9,428 8,937 10,956 14,196 20,142 24,981 28,316 32,269 27,439 18,823 Projected Consumption98,473,756 69,019,457 47,803,352 42,698,963 40,548,411 49,795,242 64,633,132 91,867,519 114,140,041 129,601,659 147,953,812 126,026,974 86,605,993 Dist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenueDist %Dist (Gal)RateRevenue- 1,000 1,000 4.44% 4,376,930 3.03 13,262$ 6.31% 4,356,592 3.03 13,200$ 9.08% 4,341,559 3.03 13,155$ 10.05% 4,291,632 3.03 13,004$ 10.59% 4,295,794 3.03 13,016$ 8.65% 4,306,344 3.03 13,048$ 6.72% 4,344,184 3.03 13,163$ 4.80% 4,414,219 3.03 13,375$ 3.90% 4,446,927 3.03 13,474$ 3.44% 4,458,919 3.03 13,511$ 3.04% 4,497,531 3.03 13,628$ 3.55% 4,470,330 3.03 13,545$ 52,600,962 3.03 159,381$ 1,000 2,000 1,000 4.36% 4,290,857 3.03 13,001 6.14% 4,234,780 3.03 12,831 8.73% 4,172,902 3.03 12,644 9.67% 4,127,184 3.03 12,505 10.14% 4,112,518 3.03 12,461 8.34% 4,152,412 3.03 12,582 6.54% 4,226,115 3.03 12,805 4.71% 4,322,459 3.03 13,097 3.84% 4,377,339 3.03 13,263 3.40% 4,403,838 3.03 13,344 3.00% 4,445,524 3.03 13,470 3.49% 4,397,648 3.03 13,325 51,263,577 3.03 155,329 2,000 3,000 1,000 4.25% 4,184,235 3.03 12,678 5.85% 4,036,402 3.03 12,230 8.12% 3,882,566 3.03 11,764 9.05% 3,862,621 3.03 11,704 9.31% 3,774,804 3.03 11,438 7.86% 3,913,837 3.03 11,859 6.25% 4,039,828 3.03 12,241 4.58% 4,208,602 3.03 12,752 3.77% 4,297,649 3.03 13,022 3.34% 4,326,275 3.03 13,109 2.97% 4,387,573 3.03 13,294 3.44% 4,336,091 3.03 13,138 49,250,484 3.03 149,229 3,000 4,000 1,000 4.11% 4,045,433 3.03 12,258 5.44% 3,757,589 3.03 11,385 7.27% 3,475,942 3.03 10,532 8.11% 3,461,018 3.03 10,487 8.11% 3,288,345 3.03 9,964 7.11% 3,538,933 3.03 10,723 5.84% 3,776,704 3.03 11,443 4.45% 4,085,007 3.03 12,378 3.68% 4,199,252 3.03 12,724 3.28% 4,245,340 3.03 12,863 2.92% 4,322,935 3.03 13,098 3.37% 4,252,654 3.03 12,886 46,449,152 3.03 140,741 4,000 5,000 1,000 3.96% 3,903,141 3.03 11,827 4.95% 3,414,971 3.03 10,347 6.26% 2,994,231 3.03 9,073 6.88% 2,937,983 3.03 8,902 6.64% 2,691,464 3.03 8,155 6.20% 3,087,624 3.03 9,356 5.35% 3,461,104 3.03 10,487 4.28% 3,936,318 3.03 11,927 3.58% 4,085,890 3.03 12,380 3.21% 4,156,911 3.03 12,595 2.87% 4,252,725 3.03 12,886 3.31% 4,170,701 3.03 12,637 43,093,064 3.03 130,572 5,000 6,000 1,000 3.80% 3,739,912 3.03 11,332 4.50% 3,104,835 3.03 9,408 5.23% 2,501,354 3.03 7,579 5.67% 2,419,515 3.03 7,331 5.35% 2,169,336 3.03 6,573 5.31% 2,645,304 3.03 8,015 4.89% 3,158,623 3.03 9,571 4.11% 3,777,891 3.03 11,447 3.47% 3,965,046 3.03 12,014 3.13% 4,059,490 3.03 12,300 2.82% 4,177,314 3.03 12,657 3.24% 4,077,624 3.03 12,355 39,796,244 3.03 120,583 6,000 7,000 1,000 3.62% 3,569,317 3.53 12,600 4.07% 2,806,688 3.53 9,908 4.37% 2,087,799 3.53 7,370 4.54% 1,940,637 3.53 6,850 4.22% 1,711,715 3.53 6,042 4.54% 2,261,037 3.53 7,981 4.41% 2,849,395 3.53 10,058 3.93% 3,610,102 3.53 12,744 3.36% 3,839,338 3.53 13,553 3.06% 3,966,190 3.53 14,001 2.77% 4,103,389 3.53 14,485 3.17% 3,994,558 3.53 14,101 36,740,163 3.53 129,693 7,000 8,000 1,000 3.44% 3,391,355 3.53 11,971 3.67% 2,533,676 3.53 8,944 3.66% 1,751,256 3.53 6,182 3.60% 1,538,653 3.53 5,431 3.42% 1,385,385 3.53 4,890 3.90% 1,942,312 3.53 6,856 3.96% 2,557,409 3.53 9,028 3.76% 3,450,926 3.53 12,182 3.25% 3,711,385 3.53 13,101 2.98% 3,864,271 3.53 13,641 2.72% 4,031,322 3.53 14,231 3.09% 3,888,872 3.53 13,728 34,046,821 3.53 120,185 8,000 9,000 1,000 3.27% 3,223,474 3.53 11,379 3.35% 2,310,161 3.53 8,155 3.06% 1,463,230 3.53 5,165 2.88% 1,229,552 3.53 4,340 2.75% 1,116,732 3.53 3,942 3.34% 1,664,785 3.53 5,877 3.58% 2,311,151 3.53 8,158 3.58% 3,289,878 3.53 11,613 3.14% 3,578,942 3.53 12,634 2.90% 3,755,234 3.53 13,256 2.67% 3,955,168 3.53 13,962 3.01% 3,793,199 3.53 13,390 31,691,506 3.53 111,871 9,000 14,000 5,000 13.84% 13,626,292 3.53 48,101 12.68% 8,748,760 3.53 30,883 9.72% 4,644,601 3.53 16,395 8.28% 3,534,487 3.53 12,477 8.12% 3,292,519 3.53 11,623 10.94% 5,448,660 3.53 19,234 13.13% 8,484,839 3.53 29,951 14.86% 13,651,645 3.53 48,190 13.68% 15,611,760 3.53 55,110 12.99% 16,835,603 3.53 59,430 12.37% 18,303,656 3.53 64,612 13.53% 17,045,846 3.53 60,172 129,228,669 3.53 456,177 14,000 17,000 3,000 6.30% 6,201,136 3.53 21,890 5.09% 3,509,713 3.53 12,389 3.25% 1,552,950 3.53 5,482 2.53% 1,078,428 3.53 3,807 2.57% 1,040,462 3.53 3,673 3.75% 1,868,529 3.53 6,596 5.13% 3,316,423 3.53 11,707 6.62% 6,079,383 3.53 21,460 6.52% 7,443,346 3.53 26,275 6.43% 8,333,682 3.53 29,418 6.49% 9,598,349 3.53 33,882 6.75% 8,507,905 3.53 30,033 58,530,305 3.53 206,612 17,000 20,000 3,000 4.90% 4,828,232 4.09 19,747 3.78% 2,607,922 4.09 10,666 2.33% 1,115,906 4.09 4,564 1.75% 747,248 4.09 3,056 1.84% 747,144 4.09 3,056 2.59% 1,290,255 4.09 5,277 3.70% 2,389,863 4.09 9,775 5.11% 4,695,866 4.09 19,206 5.31% 6,064,672 4.09 24,805 5.39% 6,985,889 4.09 28,572 5.65% 8,352,028 4.09 34,160 5.60% 7,052,405 4.09 28,844 46,877,431 4.09 191,729 20,000 25,000 5,000 5.89% 5,797,135 4.09 23,710 4.32% 2,980,704 4.09 12,191 2.69% 1,286,488 4.09 5,262 2.08% 889,998 4.09 3,640 2.10% 850,735 4.09 3,480 2.80% 1,395,873 4.09 5,709 4.07% 2,632,373 4.09 10,766 6.01% 5,520,208 4.09 22,578 6.56% 7,486,372 4.09 30,619 6.93% 8,981,536 4.09 36,734 7.59% 11,226,555 4.09 45,917 7.04% 8,868,349 4.09 36,272 57,916,325 4.09 236,878 25,000 29,000 4,000 3.25% 3,195,946 4.75 15,181 2.33% 1,604,816 4.75 7,623 1.49% 714,287 4.75 3,393 1.23% 525,700 4.75 2,497 1.22% 496,325 4.75 2,358 1.52% 756,176 4.75 3,592 2.10% 1,359,853 4.75 6,459 3.18% 2,922,089 4.75 13,880 3.71% 4,232,176 4.75 20,103 4.04% 5,237,169 4.75 24,877 4.61% 6,824,494 4.75 32,416 4.00% 5,038,068 4.75 23,931 32,907,099 4.75 156,309 29,000 34,000 5,000 2.81% 2,771,784 4.75 13,166 2.09% 1,439,694 4.75 6,839 1.46% 695,805 4.75 3,305 1.24% 530,649 4.75 2,521 1.22% 496,325 4.75 2,358 1.39% 694,378 4.75 3,298 1.84% 1,187,810 4.75 5,642 2.72% 2,499,244 4.75 11,871 3.28% 3,746,179 4.75 17,794 3.71% 4,801,768 4.75 22,808 4.31% 6,379,087 4.75 30,301 3.56% 4,482,568 4.75 21,292 29,725,291 4.75 141,195 34,000 39,000 5,000 1.92% 1,895,545 4.75 9,004 1.54% 1,059,952 4.75 5,035 1.20% 572,200 4.75 2,718 1.03% 440,050 4.75 2,090 1.05% 424,609 4.75 2,017 1.11% 554,304 4.75 2,633 1.31% 845,973 4.75 4,018 1.87% 1,717,598 4.75 8,159 2.27% 2,588,242 4.75 12,294 2.62% 3,394,399 4.75 16,123 3.14% 4,638,695 4.75 22,034 2.48% 3,123,854 4.75 14,838 21,255,420 4.75 100,963 39,000 44,000 5,000 1.42% 1,393,453 4.75 6,619 1.22% 842,625 4.75 4,002 1.05% 504,044 4.75 2,394 0.90% 385,996 4.75 1,833 0.91% 369,588 4.75 1,756 0.96% 479,024 4.75 2,275 1.04% 672,055 4.75 3,192 1.31% 1,201,495 4.75 5,707 1.65% 1,879,637 4.75 8,928 1.89% 2,455,028 4.75 11,661 2.32% 3,432,493 4.75 16,304 1.79% 2,258,713 4.75 10,729 15,874,150 4.75 75,402 44,000 50,000 6,000 1.31% 1,290,320 4.75 6,129 1.17% 806,662 4.75 3,832 1.11% 529,458 4.75 2,515 0.95% 407,313 4.75 1,935 0.96% 388,181 4.75 1,844 1.00% 500,372 4.75 2,377 1.06% 682,176 4.75 3,240 1.18% 1,084,266 4.75 5,150 1.45% 1,657,403 4.75 7,873 1.64% 2,127,167 4.75 10,104 2.02% 2,984,857 4.75 14,178 1.55% 1,954,263 4.75 9,283 14,412,437 4.75 68,459 50,000 59,000 9,000 1.51% 1,485,341 5.52 8,199 1.46% 1,006,587 5.52 5,556 1.44% 688,103 5.52 3,798 1.29% 551,205 5.52 3,043 1.31% 529,338 5.52 2,922 1.30% 647,937 5.52 3,577 1.31% 849,721 5.52 4,690 1.34% 1,231,457 5.52 6,798 1.52% 1,730,358 5.52 9,552 1.72% 2,231,708 5.52 12,319 2.05% 3,039,465 5.52 16,778 1.60% 2,016,933 5.52 11,133 16,008,153 5.52 88,365 59,000 69,000 10,000 1.36% 1,334,907 5.52 7,369 1.34% 923,059 5.52 5,095 1.37% 656,913 5.52 3,626 1.27% 542,450 5.52 2,994 1.22% 494,807 5.52 2,731 1.22% 608,611 5.52 3,360 1.18% 763,137 5.52 4,213 1.18% 1,079,772 5.52 5,960 1.25% 1,425,441 5.52 7,868 1.38% 1,788,064 5.52 9,870 1.57% 2,316,561 5.52 12,787 1.29% 1,624,226 5.52 8,966 13,557,950 5.52 74,840 69,000 +20.24% 19,929,010 5.52 110,008 18.74% 12,933,269 5.52 71,392 17.09% 8,171,757 5.52 45,108 16.99% 7,256,642 5.52 40,057 16.95% 6,872,284 5.52 37,935 16.14% 8,038,534 5.52 44,373 16.59% 10,724,399 5.52 59,199 16.42% 15,089,094 5.52 83,292 20.83% 23,772,690 5.52 131,225 22.53% 29,193,178 5.52 161,146 22.09% 32,684,092 5.52 180,416 21.16% 26,672,168 5.52 147,230 201,337,117 5.52 1,111,381 100.00% 98,473,756 399,431$ 100.00% 69,019,457 271,913$ 100.00% 47,803,352 182,025$ 100.00% 42,698,963 160,505$ 100.00% 40,548,411 152,232$ 100.00% 49,795,242 188,597$ 100.00% 64,633,132 249,808$ 100.00% 91,867,519 363,766$ 100.00% 114,140,041 468,611$ 100.00% 129,601,659 541,683$ 100.00% 147,953,812 625,496$ 100.00% 126,026,974 521,828$ 1,022,562,319 4,125,893$ Total BaseProjected Revenue Summary:Base Charges RatesProjectedRevenueRate Current Meter MonthlyVolumetric Revenue4,125,893$ 5/8" x 3/4"12.9954,588 709,098$ IncrementCountRevenueBase Charge Revenue1"20.397.40 1,650 12,210$ Base709,098$ 1 1/2"32.2319.24 19 366 Increment (x 12)245,253 2"46.4333.44 104 3,478 Base Subtotal954,351$ 3"79.5866.59 28 1,865 4"126.93113.94 16 1,823 6"245.29232.30 3 697 Total Projected Revenue5,080,244$ 20,438$ TABLE GF-D 2AB C DEMONTH SHUTOFFS FOR NON-PAYMENTNEW METERS SET (TAP FEES)LATE FEES ($/Month)PID MUD$9,000SERVICE CHGSJan-1526 5 12 7881.32$90,985PENALTIESFeb-1535 8 3 7049.42$9,200Mar-1530 12 2 5199.87$69,000Apr-1522 13 5 5449.08May-1529 12 3 7979.14Jun-1428 11 2 4078.88Jul-1433 20 3 8881.23Aug-1427 7 2 10281.2Sep-1436 4 2 7896.83Oct-1437 9 6 9480.95Nov-1433 6 3 11438.62Dec-1425 6 3 5368.81Total361 113 46 $90,985Average Per Mh30 9 4 $7,582REVENUE FOR MUD TAP FEES:REVENUE FOR PID UTILITY FEES:GROWTH RATE : 2.00% recommendedOTHER REVENUE SOURCESREVENUE FOR SHUTOFFS (MO. AVE. X 12 x $25):TOTAL LATE FEES:Increment Above BaseAPRIL MAY JUNE JULYOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALAUGUST SEPTEMBERAPRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALJULY AUGUST SEPTEMBERAPRIL MAY JUNEOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY MARCHTOTALJULY AUGUST SEPTEMBERTOTALAPRIL MAY JUNE JULY AUGUST SEPTEMBERMARCHOCTOBER NOVEMBER DECEMBER JANUARY FEBURARY19Trophy Club Municipal Utility District No. 120 of 33August 19, 2015 - Special Meeting Agenda Packet OctNovDecJanFebMarAprMayJunJulAugSepAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsageAccountsUsage AccountsUsageAccountsUsageAccountsUsageAccountsUsage AccountsUsage AccountsUsage0 to 1,000 235 4,376,930 301 4,356,592 377 4,341,559 391 4,291,632 417 4,295,794 368 4,306,344 307 4,344,184 255 4,414,219 218 4,446,927 218 4,458,9191744,497,5312034,470,3301,000 to 2,000 106 4,290,857 197 4,234,780 288 4,172,902 265 4,127,184 338 4,112,518 240 4,152,412 187 4,226,115 113 4,322,459 79 4,377,339 77 4,403,838584,445,524614,397,6482,000 to 3,000 138 4,184,235 277 4,036,402 404 3,882,566 403 3,862,621 487 3,774,804 377 3,913,837 264 4,039,828 123 4,208,602 98 4,297,649 80 4,326,275644,387,573834,336,0913,000 to 4,000 142 4,045,433 341 3,757,589 478 3,475,942 524 3,461,018 598 3,288,345 454 3,538,933 317 3,776,704 148 4,085,007 113 4,199,252 88 4,245,340704,322,935824,252,6544,000 to 5,000 162 3,903,141 308 3,414,971 489 2,994,231 520 2,937,983 523 2,691,464 445 3,087,624 304 3,461,104 158 3,936,318 120 4,085,890 96 4,156,911754,252,725934,170,7015,000 to 6,000 170 3,739,912 297 3,104,835 411 2,501,354 480 2,419,515 458 2,169,336 387 2,645,304 311 3,158,623 167 3,777,891 125 3,965,046 92 4,059,490734,177,314834,077,6246,000 to 7,000 177 3,569,317 272 2,806,688 334 2,087,799 403 1,940,637 327 1,711,715 321 2,261,037 293 2,849,395 159 3,610,102 127 3,839,338 101 3,966,190724,103,3891063,994,5587,000 to 8,000 167 3,391,355 222 2,533,676 286 1,751,256 310 1,538,653 269 1,385,385 279 1,942,312 247 2,557,409 160 3,450,926 132 3,711,385 108 3,864,271764,031,322963,888,8728,000 to 9,000 163 3,223,474 203 2,310,161 216 1,463,230 222 1,229,552 194 1,116,732 231 1,664,785 243 2,311,151 199 3,289,878 140 3,578,942 122 3,755,234863,955,1681203,793,1999,000 to 14,000 829 13,626,292 811 8,748,760 661 4,644,601 604 3,534,487 528 3,292,519 737 5,448,660 850 8,484,839 890 13,651,645 796 15,611,760 69116,835,603 548 18,303,656 681 17,045,84614,000 to 17,000 469 6,201,136 328 3,509,713 171 1,552,950 132 1,078,428 122 1,040,462 221 1,868,529 346 3,316,423 482 6,079,383 465 7,443,346 451 8,333,6823919,598,3494818,507,90517,000 to 20,000 399 4,828,232 252 2,607,922 99 1,115,906 65 747,248 70 747,144 139 1,290,255 243 2,389,863 409 4,695,866 433 6,064,672 432 6,985,889405 8,352,028 465 7,052,40520,000 to 25,000 446 5,797,135 255 2,980,704 113 1,286,488 66 889,998 69 850,735 134 1,395,873 252 2,632,373 463 5,520,208 540 7,486,372 596 8,981,53664511,226,5556408,868,34925,000 to 29,000 257 3,195,946 118 1,604,816 43 714,287 27 525,700 26 496,325 52 756,176 115 1,359,853 250 2,922,089 319 4,232,176 333 5,237,169 412 6,824,4943655,038,06829,000 to 34,000 217 2,771,784 92 1,439,694 32 695,805 23 530,649 19 496,325 40 694,378 83 1,187,810 191 2,499,244 280 3,746,179 329 4,801,768 392 6,379,0873194,482,56834,000 to 39,000 115 1,895,545 56 1,059,952 15 572,200 11 440,050 12 424,609 18 554,304 47 845,973 120 1,717,598 164 2,588,242 218 3,394,399 280 4,638,6952043,123,85439,000 to 44,000 76 1,393,453 34 842,625 11 504,044 10 385,996 11 369,588 12 479,024 21 672,055 70 1,201,495 108 1,879,637 145 2,455,028 198 3,432,493 1372,258,71344,000 to 50,000 54 1,290,320 25 806,662 11 529,458 8 407,313 5 388,181 11 500,372 20 682,176 48 1,084,266 86 1,657,403 115 2,127,167 163 2,984,857 109 1,954,26350,000 to 59,000 39 1,485,341 22 1,006,587 13 688,103 6 551,205 8 529,338 13 647,937 19 849,721 37 1,231,457 71 1,730,358 81 2,231,708 133 3,039,465 81 2,016,93359,000 to 69,000 24 1,334,907 16 923,059 10 656,913 7 542,450 8 494,807 9 608,611 12 763,137 24 1,079,772 32 1,425,441 52 1,788,064 84 2,316,561 44 1,624,22669,000 + + 120 19,929,010 84 12,933,269 60 8,171,757 51 7,256,642 46 6,872,284 56 8,038,534 72 10,724,399 94 15,089,094 125 23,772,690 152 29,193,178187 32,684,092 140 26,672,168WASTEWATER RATES FOR ALL METER SIZES Gallons Included in Minimum Bill =0% of Sewer Meters not Subject to Cap2.25%$ Amount of Minimum Bill =15.35 MIN BILL =$15.350 to 6,999$2.637,000 to 18,000$2.63Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts UsageAccountsUsage AccountsUsage AccountsUsage0 to 1,000 $3,612 $11,511 $4,617 $11,458 $5,788 $11,418 $5,999 $11,287 $6,401 $11,298 $5,650 $11,326 $4,711 $11,425 $3,912 $11,609 $3,340 $11,695 $3,342$11,727$2,671$11,829$3,109$11,7571,000 to 2,000$1,629$11,285$3,029$11,137$4,426$10,975$4,072$10,854$5,193$10,816$3,684$10,921$2,873$11,115$1,741$11,368$1,216$11,512$1,179$11,582$883$11,692$943$11,5662,000 to 3,000$2,120$11,005$4,257$10,616$6,198$10,211$6,181$10,159$7,481$9,928$5,789$10,293$4,058$10,625$1,890$11,069$1,501$11,303$1,230$11,378$984$11,539$1,279$11,4043,000 to 4,000$2,173$10,639$5,231$9,882$7,343$9,142$8,050$9,102$9,179$8,648$6,968$9,307$4,867$9,933$2,274$10,744$1,730$11,044$1,344$11,165$1,069$11,369$1,256$11,1844,000 to 5,000$2,493$10,265$4,735$8,981$7,513$7,875$7,980$7,727$8,029$7,079$6,830$8,120$4,665$9,103$2,423$10,353$1,844$10,746$1,480$10,933$1,149$11,185$1,426$10,9695,000 to 6,000$2,606$9,836$4,552$8,166$6,304$6,579$7,370$6,363$7,037$5,705$5,933$6,957$4,769$8,307$2,566$9,936$1,918$10,428$1,418$10,676$1,126$10,986$1,273$10,7246,000 to 7,000$2,718$9,387$4,168$7,382$5,130$5,491$6,187$5,104$5,018$4,502$4,921$5,947$4,503$7,494$2,434$9,495$1,952$10,097$1,549$10,431$1,098$10,792$1,620$10,5067,000 to 8,000$2,564$8,919$3,413$6,664$4,391$4,606$4,757$4,047$4,131$3,644$4,285$5,108$3,798$6,726$2,463$9,076$2,021$9,761$1,657$10,163$1,160$10,602$1,466$10,2288,000 to 9,000$2,499$8,478$3,123$6,076$3,311$3,848$3,410$3,234$2,982$2,937$3,551$4,378$3,734$6,078$3,058$8,652$2,147$9,413$1,867$9,876$1,313$10,402$1,847$9,9769,000 to 14,000$12,732$35,837$12,452$23,009$10,143$12,215$9,269$9,296$8,111$8,659$11,311 $14,330 $13,041 $22,315 $13,654$35,904$12,217$41,059 $10,607 $44,278$8,408$48,139 $10,451$44,83114,000 to 17,000$7,201$16,309$5,042$9,231$2,618$4,084$2,027$2,836$1,873$2,736$3,395$4,914$5,312$8,722$7,405$15,989$7,136$19,576$6,918$21,918$6,003$25,244$7,388$22,37617,000 to 20,000$6,129$1,312$3,873$803$1,514$320$1,002$212$1,080$225$2,140$435$3,723$765$6,283$1,330$6,645$1,472$6,627$1,523$6,224$1,537$7,143$1,61420,000 to 25,000$6,846$1,490$3,920$833$1,732$366$1,019$223$1,056$227$2,059$427$3,862$802$7,102$1,516$8,289$1,831$9,144$2,063$9,901$2,323$9,820$2,16925,000 to 29,000$3,938$849$1,807$398$663$153$422$102$397$96$792$177$1,769$377$3,837$816$4,893$1,070$5,118$1,167$6,326$1,463$5,598$1,23629,000 to 34,000$3,328$721$1,417$323$493$124$352$90$292$78$619$145$1,272$283$2,932$639$4,293$941$5,044$1,129$6,020$1,386$4,899$1,08634,000 to 39,000$1,759$407$862$207$235$73$170$54$187$56$283$80$728$172$1,844$411$2,512$574$3,353$762$4,300$995$3,131$70939,000 to 44,000$1,167$278$525$138$176$59$146$47$163$49$185$59$318$93$1,071$250$1,661$389$2,232$519$3,038$712$2,097$48544,000 to 50,000$823$214$378$111$164$59$117$44$76$36$162$57$306$92$739$188$1,313$318$1,771$422$2,501$595$1,676$39650,000 to 59,000$592$187$331$115$194$73$100$49$128$53$202$72$295$100$573$169$1,096$286$1,247$341$2,048$523$1,245$32859,000 to 69,000$373$141$248$96$147$63$111$51$117$49$145$60$179$75$361$124$497$168$797$239$1,296$354$682$21069,000 + +$1,848$1,489$1,293$982$916$637$779$560$712$526$862$620$1,104$820$1,449$1,136$1,912$1,727$2,334$2,118$2,863$2,414$2,154$1,939REVENUE:$69,152$150,560$69,275$116,606$69,397$88,372$69,520 $81,442$69,643$77,347$69,766 $93,735 $69,889 $115,421 $70,011 $150,772 $70,134 $165,410 $70,257 $174,412 $70,380 $186,079 $70,503$175,692PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$0AMOUNT FROM BASE:$837,926AMOUNT FROM USAGE:$1,575,850TOTAL:$2,413,776TROPHY CLUB COUNTRY CLUB EFFLUENT REVENUEMonthMil Gals ChargesJul-14 17.924 $12,547Aug-14 19.676 $13,773Sep-14 23.703 $16,592Oct-14 10.225 $7,158Nov-147.211$5,048Dec-140.847$593Jan-15 0.401$281Feb-15 1.252$876Mar-15 0.843$590Apr-15 1.891$1,324May-15 0$0Jun-15 3.641$2,549TOTAL: 87.614 $61,330SCHEDULE GF-E PROJECTED RETAIL WASTEWATER SALES FY 15WATER USECATEGORYPROJECTED FY 2015 RETAIL WASTEWATER REVENUES Usage Groups20Trophy Club Municipal Utility District No. 121 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF-FUNIFORMSWATERITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTALUNIFORM SHIRTS 6 10 60 $14 $810POLO SHIRTS 6 4 24 $17 $408SWEATSHIRTS 6 5 30 $18 $540PANTS 6 7 42 $25 $1,050BOOTS 6 1 6 $175 $1,050JACKET 5 1 5 $150 $750 TOTAL: $4,608WASTEWATERITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTALUNIFORM SHIRTS 7 6 42 $18 $756POLO SHIRTS 1 4 4 $35 $140SWEATSHIRTS 7 5 35 $27 $945PANTS 7 5 35 $25 $875BOOTS 7 1 7 $175 $1,225JACKET 2 1 2 $150 $300TOTAL: $4,241ADMINISTRATIONITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTALPOLO SHIRTS 7 5 35 $35 $1,225(Director) SHIRTS 5 2 10 $35 $350SWEATER 7 1 7 $40 $280PANTS 0 0 0 $25 $0TOTAL: $1,85521Trophy Club Municipal Utility District No. 122 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF-GTRAVEL & TRAININGTrainingNumber to AttendEstimated Class Cost/Person Total TrainingEstimated Travel & Per Diem Cost Per PersonTotal Travel & Per DiemTotal Dept. CostWATERWater/WW Classes 12 $325 $3,900 $50 $300CSI Class 0 $170 $0 $50 $0CSI Renewals 0 $111 $0 $50 $0 Management Classes0$350$0$100$0Management Conferences1$350$350$400$400 License Renewal8$111$888$100$400CDL Renewal1$75$75$0$0Miscellaneous Mileage/Travel (Miles)1,000$0.56$560$0$300 $5,773 $1,400 $7,173WASTEWATERWastewater/Distribution Classes8$325$2,600$50$400Management Classes0$350$0$200$400Management Conferences1$350$350$400$400License Renewal1$111$111$100$100CDL Renewal2$75$150$0$0Miscellaneous Mileage/Travel (Miles)1,000$0.56$560$0$300 $3,771 $1,600 $5,371ADMINISTRATIONManagement Classes2$350$700$300$600Management Conferences4$350$1,400$400 $1,600Elections Training2$350$700$400$800Public Funds Inv. Training2$300$600$100$200Govmt Accounting Conference2$350$700$400$800Software Training4$300$1,200$50$200Photoshop 1$975$975$100$100Customer Service Conferences2$350$700$400$800CPA/CFE Classes/Renewal1$900$900$0$0Miscellaneous Mileage/Travel (Miles)1,000$0.56$560$0$300Miscellaneous Travel (Legal)3$500$1,500$0$0 $9,935 $5,400 $15,33522Trophy Club Municipal Utility District No. 123 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐HSALARY WITHOUT FIRE STIPEND WORKSHEETCOLA Merit 50% Town Total  SocialTWC WORKERSBase Pay Base Pay Pay Pay Stipend Salaries OT Holiday LongevityCertificationSecurity MediUNEMP COMPFIRE DEPARTMENT%No Split With Split 0.0% 4%* ($)& Wages Pay Pay Rate Longevity Rate Certification6.2% 1.45%2.3% TO $4500  (9/year)Fire Chief50.00% 106,318 53,159 0 1,605 0 54,765 0 0 728 72800 3,441 805 104 1,015Fire Captain50.00% 69,334 34,667 0 1,047 0 35,714 3,304 1,301 439 439 600600 2,564 600 104662Fire Captain50.00% 78,263 39,132 0 1,182 0 40,313 3,738 1,468 874 874 450450 2,904 679 104747Fire Captain50.00% 74,602 37,301 0 1,126 0 38,427 3,556 1,399 563 563 600600 2,762 646 104712Fire Fighter/EMT‐P50.00% 51,680 25,840 0 780 0 26,620 2,475 969 368 368 450450 1,915 448 104494Fire Fighter/EMT‐P50.00% 50,724 25,362 0 766 0 26,128 2,383 951 281 28100 1,844 431 104484Engineer ‐ Fire Fighter/EMT‐P 50.00% 64,018 32,009 0 967 0 32,976 3,061 1,201 593 593 450450 2,373 555 104611Engineer ‐ Fire Fighter/EMT‐P 50.00% 62,690 31,345 0 947 0 32,292 2,990 1,178 435 435 450450 2,315 542 104600Engineer ‐ Fire Fighter/EMT‐P 50.00% 62,792 31,396 0 948 0 32,344 3,007 1,178 473 473 600600 2,331 545 104600Fire Fighter/EMT‐P50.00% 57,602 28,801 0 870 0 29,671 2,743 1,081 473 473 300300 2,125 497 104550Fire Fighter/EMT‐P50.00% 54,123 27,062 0 817 0 27,879 2,575 1,015 390 390 300300 1,994 466 104517Fire Fighter/EMT‐P50.00% 49,171 24,586 0 246 0 24,832 2,250 887 0 000 1,734 406 104483Fire Fighter/EMT‐P50.00% 50,356 25,178 0 760 0 25,938 2,349 945 0 9000 1,818 425 104481Fire Fighter/EMT‐P50.00% 49,706 24,853 0 751 0 25,604 2,317 933 58 5800 1,792 419 104475Fire Fighter/EMT‐P50.00% 49,171 24,586 0 246 0 24,832 2,250 887 0 000 1,734 406 104462Fire Fighter/EMT‐P       NEW 50.00% 35,780 17,890 0 179 0 18,069 1,537 459 0 000 1,244 291 104266Part‐Time Staff50.00% 23,646 11,823 0 0 0 11,823 0 0 0 000 733 17168220FTO50.00%0 0 0 0 0 0 0 0 0 0000 000 50.00%0 0 0 0 0 N/A0 0 0 0000 000 50.00%0 0 0 0 0 N/A0 0 0 0000 000Special Event OT50.00%0 0 0 0 0 N/A 8,200 0 0 000 508 11900TOTAL:989,977 494,988 0 13,237 0 508,226 48,735 15,8525,7614,200 36,132 8,450 1724 9,379* Merit up to 2% 10/1/16 and up to 2% 4/01/16           Total w/OT:** New position funded 3/4 of a yearCOLAMerit Merit TotalSocialTWC UNEMP WORKERS  Pay Pay Pay Salaries OT Holiday Longevity CertificationSecurity Medicare2.30% COMPADMINISTRATION % Base Pay Base Pay 2.5% 0% ($)& Wages Pay Pay Rate Longevity Rate Certification6.2% 1.45%UP TO $9000 General Manager100% 110,591 110,591 2,765 0 1,500 114,856 0 0 210 21000 7,147 1,772 207222District Secretary100% 75,000 75,000 1,875 0 1,100 77,975 0 0 300 30000 4,872 1,206 207222Administration Manager100% 82,500 82,500 2,063 0 1,100 85,663 0 0 180 18000 5,333 1,322 207222Finance Manager100% 86,741 86,741 2,169 0 1,100 90,009 0 0 2,000 2,00000 5,829 1,419 207222Utility Billing Clerk100% 43,617 43,617 1,090 0 1,040 45,747 0 0 668 66800 2,919 715 207222Reception/Utility Billing Clerk 100% 27,540 27,540 689 0 1,040 29,269 0 0 60 6000 1,822 452 207222Communications Specialist 100% 41,902 41,902 1,048 0 1,040 43,989 0 0 255 25500 2,759 682 207222Part‐Time Front Desk100% 13,520 13,520 0 0 0 13,520 0 0 0 000 838 208 207222Overtime Pay1,00062 15DM Discretionary1,00062 15TOTAL:481,410 481,410 11,697 0 7,920 502,028 1,000 03,6730 31,643 7,805 1,656 1,776556,96123Trophy Club Municipal Utility District No. 124 of 33August 19, 2015 - Special Meeting Agenda Packet   SCHEDULE GF‐HSALARY WORKSHEET   COLA Merit Merit TotalSocialTWC UNEMP WORKERS  Pay Pay Pay Salaries OT Holiday Longevity CertificationSecurity Medicare2.30% COMPWATER  & DISTRIBUTION% Base Pay Base Pay 2.5% 0% ($)& Wages Pay Pay Rate Longevity Rate Certification6.2% 1.45%UP TO $9000Water Superintendent100% 71,000 71,000 1,775 0 1,500      74,275 0 0 1553 155300 4,798 1,122 207 2,459Crew Leader100% 47,625 47,625 1,191 0 1,040      49,856 0 0 1253 1253 15001500 3,432 803 207 2,459Utility Field Worker100% 36,811 36,811 920 0 1,040      38,771 0 0 140 140 900900 2,533 592 207 2,459Utility Field Worker100% 37,440 37,440 0 0 1,040      38,480 0 0 0 0 600600 2,460 575 207 2,459Utility Field Worker100% 33,280 33,280 832 0 1,040      35,152 0 0 0 0 900900 2,291 536 207 2,459Utility Field Worker100% 27,040 27,040 0 0 1,040      28,080 0 0 0 0 300300 1,778 416 207 2,459Overtime Pay19,5001,209 283DM Discretionary1,00062 15TOTAL:253,196 253,196 4,718 0 6,700 265,614 19,500 02,9454,200 18,563 4,341 1,242 14,754    COLA Merit Merit TotalSocialTWC UNEMP WORKERS  Pay Pay Pay Salaries OT Holiday Longevity CertificationSecurity Medicare2.30% COMPWASTEWATER & COLLECTIONS % Base Pay Base Pay 2.5% 0% ($)& Wages Pay Pay Rate Longevity Rate Certification6.2% 1.45%UP TO $9000Wastewater Superintendent 100% 71,300 71,300 1,782.50    0 1,400 74,483 0 0 200 200‐               ‐                     4,643 1,086 207 1,331Wastewater Shift Supervisor 100% 28,500 28,500‐              0 28,500 0 0 0 0 600              600                    1,841 431 207 1,331Crew Leader100% 55,248 55,248 1,381.21    0 1,040 57,669 0 0 1583 1,583 1,800           1,800                 3,995 934 207 1,331Utility Field Worker100% 49,243 49,243 1,231.08    0 1,040 51,514 0 0 1193 1,193 1,800           1,800                 3,565 834 207 1,331Utility Field Worker100% 39,183 39,183 979.58        0 1,040 41,203 0 0 683 683 1,200           1,200                 2,788 652 207 1,331Crew Leader100% 53,504 53,504 1,337.60    0 1,040 55,881 0 0 1,665 1,665 1,200 1,200 3,820 893 207 1,331Utility Field Worker100% 39,395 39,395 984.88        0 1,040 41,420 0 0 803 803 600600 2,742 641 207 1,331Overtime Pay19,500‐        00‐               ‐                     1,209 283DM Discretionary1,000‐         ‐        00‐               ‐                     62 15TOTAL:336,374 336,374 7,697 0 6,600 351,671 19,500 06,1257,200 24,665 5,768 1,449 9,317 24Trophy Club Municipal Utility District No. 125 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐H.1FIRE SALARY WORKSHEETCOLA MeritMeritMeritBase Pay Base Pay PayPayPayPayTotal FIRE DEPARTMENT% No Split With Split 0.0% 2.0%1.0%Total Salary 10/1/2015 4/1/2016 For FY 16 FY 16 100.0% Town's SSFire Chief50.00% 106,318 53,159 01,0635421,605 54,765 109,529 109,117Fire Captain50.00% 69,334 34,667 06933541,047 35,714 71,428 71,187Fire Captain50.00% 78,263 39,132 07833991,182 40,313 80,627 80,337Fire Captain50.00% 74,602 37,301 07463801,126 38,427 76,855 76,589Fire Fighter/EMT‐P50.00% 51,680 25,840 0517264780 26,620 53,241 53,053Fire Fighter/EMT‐P50.00% 50,724 25,362 0507259766 26,128 52,256 52,061Engineer ‐ Fire Fighter/EMT‐P 50.00% 64,018 32,009 0640326967 32,976 65,951 65,731Engineer ‐ Fire Fighter/EMT‐P 50.00% 62,690 31,345 0627320947 32,292 64,584 64,463Engineer ‐ Fire Fighter/EMT‐P 50.00% 62,792 31,396 0628320948 32,344 64,688 64,463Fire Fighter/EMT‐P50.00% 57,602 28,801 0576294870 29,671 59,342 59,144Fire Fighter/EMT‐P50.00% 54,123 27,062 0541276817 27,879 55,758 55,561Fire Fighter/EMT‐P50.00% 49,171 24,586 00246246 24,831 49,663 49,663Fire Fighter/EMT‐P50.00% 50,356 25,178 0504257760 25,938 51,877 51,703Fire Fighter/EMT‐P50.00% 49,706 24,853 0497254751 25,604 51,207 51,041Fire Fighter/EMT‐P50.00% 49,171 24,5860246246 24,831 49,663 49,663Fire Fighter/EMT‐P       NEW 50.00%35,780 17,890 00179179 18,069 36,1380TOTAL:966,331 483,165 08,3224,91513,237 496,403 992,805 953,77625Trophy Club Municipal Utility District No. 126 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐IBENEFITS WORKSHEETAdded Benefits for New Fire Position‐FamilyFIRE DEPARTMENTADMINISTRATIONNO. EMPLOYEESANNUAL RATE (TCMUD Share @ 50%)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED Employee Only3 $207 $621 No coverage 0 $0 $0Employee & Spouse 3 $283$849Employee Only 2$463 $925Employee & Children 1 $291$291Employee & Spouse 2$635 $1,271Family 8.75 $357$3,124Employee & Children 1$724 $724 Family 2$944 $1,887TOTAL15.75 $4,885TOTAL 7$4,807NO. EMPLOYEESANNUAL RATE (TCMUD Share @ 50%)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED Employee Only 8 $41 $324 No coverage 0 $0 $0Employee and Family 7.75$69 $535Employee Only 2$119 $239 Employee & Spouse 2$161 $323 Employee & Children 1$156 $156 Family 2$198 $396TOTAL15.75 $859TOTAL 7$1,114NO. EMPLOYEESANNUAL RATE (TCMUD Share @ 50%)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED Employee Only5 $2,868 $14,340 No coverage 0 $ - $0Employee & Spouse 4$4,475 $17,900Employee Only 3 8,247$ $24,741Employee & Children 1 $3,728$3,728Employee & Spouse 2 11,564$ $23,127Family 5.75 $5,144$29,578Employee & Children 2 10,164$ $20,327 Family 0 13,480$ $0TOTAL15.75 $65,546TOTAL 7$68,196 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $4,585TOTAL$4,431DENTAL DENTALMEDICAL MEDICALLIFE & OTHER LIFE & OTHERVISION VISION26Trophy Club Municipal Utility District No. 127 of 33August 19, 2015 - Special Meeting Agenda Packet  BENEFITS WORKSHEETWATERWASTEWATERNO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0Employee Only 3$463 $1,388Employee Only 2.5$463 $1,156Employee & Spouse 0$635 $0Employee & Spouse 1$635 $635Employee & Children 1$724 $724Employee & Children 2$724 $1,449Family 2$944 $1,887Family 1$944 $944TOTAL6 $3,999TOTAL 6.5$4,184NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0Employee Only 3$119 $358Employee Only 2.5$119 $299Employee & Spouse 0$161 $0Employee & Spouse 1$161 $161Employee & Children 1$156 $156Employee & Children 2$156 $313Family 2$198 $396Family 1$198 $198TOTAL6 $910TOTAL 6.5$971NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED NO. EMPLOYEESANNUAL RATE (TCMUD Share)DISTRICT ANNUAL COST PROJECTED No coverage 0 $0 $0 No coverage 0 $0 $0Employee Only 5 8,247$ $41,235Employee Only 2.5 8,247$ $20,617Employee & Spouse 0 11,564$ $0Employee & Spouse 1 11,564$ $11,564Employee & Children 1 10,164$ $10,164Employee & Children 2 10,164$ $20,327Family 0 13,480$ $0Family 1 13,480$ $13,480TOTAL6 $51,398TOTAL 6.5$65,989 DISTRICT ANNUAL COST PROJECTED DISTRICT ANNUAL COST PROJECTED TOTAL $2,803TOTAL$3,655FOR ALL DEPARTMENTS (EXCLUDING FIRE) A 10% INCREASE IN EMPLOYEE BENEFITS WAS BUDGETED AS RENEWAL IS NOT UNTIL DECEMBER 2015LIFE & OTHERDENTALVISIONMEDICALMEDICALLIFE & OTHERDENTALVISION27Trophy Club Municipal Utility District No. 128 of 33August 19, 2015 - Special Meeting Agenda Packet               SCHEDULE GF‐JRETIREMENT WORKSHEETFIRE DEPARTMENT Oct‐Dec Jan‐Sept TMRS TMRS TMRS TOTAL FY 2016 SALARY13.62% 12.75% FY 16 TotalWATEROct‐Dec Jan‐SeptFire Chief55,492 1890 5306 7196TCDRS TCDRS TCDRSFire Lieutenant41,358 1408 3955 5363TOTAL FY 2016 SALARY8.91% 8.73% FY 16 TotalFire Lieutenant46,843 1595 4479 6074 Water Superintendent75,828 1689 4965 6654Fire Lieutenant44,545 1517 4260 5776 Crew Leader52,608 1172 3445 4616Fire Fighter/EMT‐P30,882 1052 2953 4005 Utility Field Worker39,811 887 2607 3493Fire Fighter/EMT‐P29,743 1013 2844 3857 Utility Field Worker39,080 871 2559 3429Engineer ‐ Fire Fighter/EMT‐P38,280 1303 3661 4964 Utility Field Worker36,052 803 2361 3164Engineer ‐ Fire Fighter/EMT‐P37,345 1272 3571 4843 Utility Field Worker28,380 632 1858 2490Engineer ‐ Fire Fighter/EMT‐P37,602 1280 3596 4876 Overtime Pay19,500 434 1277 1711Fire Fighter/EMT‐P34,267 1167 3277 4444TOTAL:291,259 6,488 19,070 25,558Fire Fighter/EMT‐P32,159 1095 3075 4170Fire Fighter/EMT‐P27,969 952 2674 3627Fire Fighter/EMT‐P29,322 998 2804 3802Fire Fighter/EMT‐P 28,911 984 2765 3749Fire Fighter/EMT‐P 27,969 952 2674 3627WASTEWATEROct‐DecJan‐SeptFire Fighter/EMT‐P     NEW20,065 683 1919 2602TCDRS TCDRS TCDRSPart‐Time Staff11,823 403 1131 1533TOTAL FY 2016 SALARY8.91% 8.73% FY 16 Total 0 0 0 0 Wastewater Superintendent74,683 1,664 4890 6553Overtime Pay (Total)8,200 279 784 1063 Wastewater Shift Supervisor29,100 648 1905 2554TOTAL:582,774 19,843 55,728 75,571Crew Leader61,052 1,360 3997 5357Utility Field Worker54,507 1,214 3569 4783Utility Field Worker43,085 960 2821 3781Crew Leader58,746 1,309 3846 5155Utility Field Worker42,823 954 2804 3758ADMINISTRATION Oct‐Dec Jan‐SeptOvertime Pay19,500 434 1277 1711 TCDRS TCDRS TCDRSTOTAL:383,496 8,542 25,109 33,652 TOTAL FY 2016 SALARY8.91% 8.73% FY 16 TotalGeneral Manager115,066 2,563 7,534 10,097District Secretary78,275 1,744 5,125 6,869Administration Manager85,843 1,912 5,621 7,533Finance Manager92,009 2,050 6,024 8,074Utility Billing Clerk46,415 1,034 3,039 4,073Reception/Utility Billing Clerk29,329 653 1,920 2,574Communications Specialist44,244 986 2,897 3,882Part‐Time Front Desk13,520 301 885 1,186Overtime Pay1,000 22 65 88TOTAL:505,700 11,264 33,111 44,37528Trophy Club Municipal Utility District No. 129 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐KElectricity & Gas Analysis for FY 2015‐2016Hudson EnergyFY 2016ESID # 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‐010 Water Well #1, Well #394,800 $7,361 87,360 $6,884 151,625 $12,073 38,215 $2,997 64080 $5,450 13680 $2,214 13440 $1,472 12480 1587 12,000 $1,369 13,920 $1,907 19920 $2,376 33600 $3,150 555,120 48,840 0.087980491 $51,2822770721 135‐60020‐010 Elevated Tank‐TW King145 $23 185 $27 312 $45 83 $11 216 $29 661 $71 927 $88 1011 $94 1,160 $108 999 $94 860 $82 834 $80 7,393 751 0.101609631 $7892828381 135‐60020‐010 Paluxy Well #413,600 $1,052 12,240 $964 20,591 $1,646 5,329 $418 12320 $977 12720 $1,002 11440 $835 12560 $881 12,320 $863 13,360 $921 11120 $795 12720 $891 150,320 11,244 0.074803552 $11,8072829590 135‐60020‐010 Paluxy Well #215,762 $1,223 15,150 $1,175 24,128 $1,921 6,253 $487 14475 $922 15006 $1,410 16123 $1,127 15236 $1,054 14,758 $1,030 16,081 $1,112 13622 $975 15398 $1,072 181,992 13,508 0.074224746 $14,1842836131 135‐60020‐010 Water Plant/Water Barn1,753 $237 1,677 $232 2,988 $1,679 624 $96 1298 $329 4030 $531 6462 $657 4944 $661 6,443 $726 1,832 $291 1177 $228 1314 $183 34,542 5,850 0.169361357 $6,1432836162 135‐60020‐010 Water plant pump station33,600 $5,885 34,800 $6,021 40,907 $8,080 3,493 $1,136 4400 $1,544 4400 $613 5800 $824 5000 $1,461 6,800 $1,604 2,400 $1,275 9600 $2,459 39600 $4,901 190,800 35,802 0.187644025 $37,5938644641 135‐60020‐010 100 Municipal Dr, Unit B34600 $3,815 33100 $3,717 78953 $7,784 24047 $2,243 45700 $4,593 32600 $3,718 27800 $3,218 26000 $2,796 24100 $2,907 35000 $3,534 23400 $2,856 300 $593 385,600 41,775 0.108337085 $43,8649130039 135‐60020‐010 2901 Bobcat Unit A, Elev Tank754 $80 683 $73 1095 $117 274 $29 724 $77 702 $75 703 $69 795 $76 1507 $137 1523 $138 1369 $125 1206 $112 11,335 1,108 0.097775033 $1,164TOTAL:$166,8232828536 135‐60020‐020 Sewer Plant131,898 $10,423 121,322 $9,710 211,950 $16,910 56014 $4,434 128748 $10,386 134459 $10,723 130929 $9,321 118297 $8,465 127,224 $17,464 134,108 $9,296 119940 $8,695 128970 $17,856 1,543,859 133,683 0.086590045 $140,367TOTAL:$140,3678611313 135‐60020‐021 Collection Barn for Vac‐Con493 $89 173 $61 336 $102 104 $27 213 $140 5146 $474 7787 $584 4582 $397 6,766 $912 1,582 $228 412 $138 378 $250 27,972 3,401 0.121599814 $3,5718251800 135‐60020‐021 310 Skyline‐Lift Sta #6600 $164 500 $97 956 $253 244 $52 400 $84 400 $92 600 $108 800 $167 700 $287 700 $112 500 $179 600 $290 7,000 1,884 0.269167143 $1,9785437067 135‐60020‐021 Lift Sta #2 Guard Light70 $13 70 $13 112 $21 28 $5 70 $13 70 $13 70 $13 70 $13 70 $25 70 $13 70 $13 70 $25 840 181 0.214904762 $1902820941 135‐60020‐021 Lift Station Trophy 20424 $49 244 $32 362 $49 92 $12 223 $30 262 $34 277 $33 240 $30 285 $63 301 $35 309 $36 431 $83 3,450 486 0.140918841 $5106245046 135‐60020‐021 Lift Station #21,632 $373 1,437 $210 2,298 $353 597 $103 1309 $382 1306 $195 1458 $184 1269 $192 1,374 $540 1,370 $290 1383 $224 1449 $536 16,882 3,582 0.212201161 $3,7619215255 135‐60020‐021 Lift Station #1800 $192 700 $125 1116 $164 284 $42 700 $103 700 $143 900 $109 800 $127 900 $242 900 $108 1000 $144 1000 $294 9,800 1,793 0.182982653 $1,8839843774 135‐60020‐021 Lift Station #7204 $28 158 $24 330 $46 69 $10 193 $27 189 $27 238 $29 245 $30 203 $57 226 $29 252 $31 276 $64 2,583 402 0.155520712 $4228306586 135‐60020‐021 PID Lift Station #8557 $61 509 $57 928 $102 236 $26 617 $67 571 $62 601 $61 716 $70 567 $57 633 $63 672 $66 634 $63 7,241 755 0.104297749 $7930051720 135‐60020‐021 PID Lift Station #9300 $40 300 $40 401 $48 81 $12 300 $40 300 $40 200 $29 400 $46 200 $28 400 $47 300 $38 300 $38 3,482 448 0.128546812 $4700199280 135‐60020‐021 PID Lift Station #4 (new)850 $96 650 $76 1195 $156 305 $35 700 $80 850 $95 1000 $102 1000 $101 900 $93 950 $97 1000 $102 1000 $102 10,400 1,134 0.109075962 $1,191TOTAL:$14,7708797254 122‐60020‐045 Fire Station7241 $623 6710 $585 10966 $932 2425 $213 4385 $411 4339 $410 4885 $399 4315 $365 4,432 $378 4858 $394 9070 $758 5595 $456 69,221 5,925 0.085590644 $6,221MUD SHARE ONLYMUD SHARE ONLYTOTAL:$6,221Direct Energy (Split with Town)  MUD 1/2 usage2836100 135‐60020‐030 MUD & PW Bldgs10,950 $916 10,230 $877 5,576 $499 3,814 $341 7,560 $888 11,880 $1,073 14,220 $1,204 12,000 $1,050 12,090 $1,149 8,280 $750 7,440 $695 8,527 $813 112,567 10,256 0.091106008 $10,768TOTAL:$10,768Tri‐CountyMeter #165775 135‐60020‐021 Lift Station 33689 $405 3380 $364 3322 $341 2827 $294 2878 $306 3053 $308 2584 $245 2653 $250 2806 $263 3459 $328 3792 $357 4437 $357 38,880 3,818 0.098200874 $4,009170037 135‐60020‐021 Lift Station 5  2020 $233 1776 $204 1650 $182 1383 $157 1394 $162 1390 $154 1143 $123 1209 $128 1232 $130 1545 $161 1708 $175 2074 $175 18,524 1,984 0.107091341 $2,083170038 135‐60020‐021 Lift Station 5 (Backup)24 $28 24 $28 28 $28 23 $28 24 $28 28 $28 24 $28 24 $28 23 $28 27 $28 25 $28 26 $28 300 336 1.119266667 $353TOTAL:$6,444Atmos ‐ Gas @ Fire Station (Measures by Thousand Cubic Feet)MUD 1/2 usageMeter S/N11N37543122‐60020‐045 Fire Station22 $37 24 $39 29 $51 15 $25 96 $91 199 $166 415 $311 188 $137 330 $155 37 $38 11 $25 31 $59 1,397 1,134 0.811911238 $1,191TOTAL:$1,191Jun‐15 Jul‐14 Aug‐14 Sept‐14Oct‐14Nov‐14Dec‐14Jan‐15Feb‐15Mar‐15Apr‐15May‐1529Trophy Club Municipal Utility District No. 130 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐LINFORMATION TECHNOLOGYAccountDescriptionAmount135-55160-030Professional Outside ServicesM3- It & Cell Phone Support$51,075Totals:51,075$ 135-55030-030Software & SupportUsed R For Recurring, NR For Non-Recurring.R-Internet Connectivity-WSC15,600$ R-Internet Connectivity-ATT (Backup & WWTP)1,560$ R-E-Fax96$ R-STW-Annual Support36,133$ R-Clear Rec Annual Maintenance600$ R-Web Hosting360$ R-Web Maintenance (Domains, SSL Cert, etc)70$ R-Mail Chimp240$ R-Photoshop120$ R- Timeclock Plus Support487$ Replacement for Connect CTY3,650$ R-Annual Support for Website-Four Man Furnace2,000$ R-Automatic Meter Reading -Badger3,950$ R-Pipelogix Maintenance1,980$ R-AudioTel Remit Plus Annual Support1,802$ R-AudioTel Annual Scanner Support585$ ORS software for Meter Reading9,250$ Totals:78,483$ 135-60005-030TelephoneMain Phone Numbers & Long Distance 50% Shared4,817$                      WWTP Phone Service5,784$                      Phone System Maintenance, 50% Shared.2,248$                      Repairs (Non‐Maintenance), 50% Shared.1,000$                      Totals:13,849$ 135-60235-030SecurityR-Access Control System, 50% Shared1350Totals: 1,350$ 122-55030-045Description AmountSoftware & Support - Fire Dept. R-Firehouse Support and Maintenance 263$ R-Denton County RMS Bandwidth, 50% shared 5,700$ R-Web Maintenance (Domains, SSL Cert, etc) 50% shared -$ R-Symantec Image Maintenance, 50% shared -$ R-Anti-Virus Maintenance and Support, 50% shared. 80$ R-Malware-Bytes Maintenance and Support, 50% shared. 48$ R-Hosted Exchange, 50% shared 510$ 30Trophy Club Municipal Utility District No. 131 of 33August 19, 2015 - Special Meeting Agenda Packet R-Web Hosting, 50% shared60$ Totals:6,661$ 122-65055-045DescriptionAmountHardwareR-Repair and Maintenance750$ NR-Replacement Computers-$ NR-Replacement Copiers & Printers-$ NR-Replacement First Responders MDT, 50% sharedTotals:750$ 135-65055-030DescriptionAmountHardwareR-A/V Miscellaneous Equipment, 50% Shared.1,200$ Meter Reading Laptop per MM16,000$ Replacement Hardware12,394$ Totals:29,594$ We use the following formula to determine the122-65105-045annual costs. We take the average toner yieldPrintingand divide it by the page counts to determinethe amount of toner needed per device. Wehave also included a few maintenance kits forthe older printers.It does include all the plotter supplies.498$ Totals:498$ We use the following formula to determine the135-65090-030annual costs. We take the average toner yieldPrinter Suppliesand divide it by the page counts to determinethe amount of toner needed per device. Wehave also included a few maintenance kits forthe older printers.It does include all the plotter supplies.4,003$ Totals:4,003$ 135-69170-030Copier Rental/LeaseDescriptionAmountMonthly lease for the following copiers.4,600$ Totals:4,600$ AccountDescriptionAmount135-69195-030Transfer to Future Replacment ReserveDescriptionAmountInformation Systems Replacement Fund-$ ($50,893 Total Assets)Totals:-$ 31Trophy Club Municipal Utility District No. 132 of 33August 19, 2015 - Special Meeting Agenda Packet SCHEDULE GF‐MFUEL & ROUTINE VEHICLE & GENERATOR MAINTENANCE COSTSWater DepartmentGallonsPrice Average Price /GallonNo. Vehicles No./Year Total/Year Cost Each Total Amt.OIL CHANGES7 4 28 $50 $1,400MISC Gas100.00$280.00$2.80Generator Maint.2 22 2,500$         $5,000MISC Diesel300.00 $1,023.00$3.412001 Ford F650300.00 $882.00$2.942007 Dodge 1,085.35 $2,712.50$2.502002 Ford F1501,800.00 $4,500.00$2.502011 Ford F150750.00 $1,875.00$2.502012 Ford F150850.00 $2,125.00$2.502015 Ford F3501,133.00 $2,923.88$2.582015 Ford Escape450.00 $1,125.00$2.50Portable Generators100.00$300.00$3.00Caterpillar Generator750.00 $2,250.00$3.00350 kw Generator1,200.00 $3,600.00$3.00Total Fuel and Lube:$35,947Average:8818.35 $23,596.38$2.779700.19$29,547$3.0510% IncreaseWastewater DepartmentMISC Gas142.51 $356.28$2.50MISC Diesel826.08 $2,326.07$2.822013 Chevy C15001,490.37 $3,725.90$2.502013 Chevy C15001,576.58 $3,941.50$2.502009 Gap Vax692.19 $1,803.31$2.61No. Vehicles No./Year Total/Year Cost Each Total Amt.2001 GMC Camera Van70.34$175.85$2.50OIL CHANGES6 4 24 $50 $1,2002002 Ford F350 580.64 $1,451.60$2.50OIL‐ GAP VAX1 11 $1,200 $1,2002015 Chevy 3500667.60 $1,845.36$2.76Generator Maint.2 22 2000 $4,00058 kW Portable Generator300.00 $900.00$3.0041 kw Generator @ Lift Station #1500.00 $1,500.00$3.00600 kw Generator1,000.00 $3,000.00$3.00Total Fuel and Lube:$32,021AVERAGE:7846.31 $21,025.87$2.708630.94$25,621$2.9710% IncreaseFire DepartmentMISC Gas7.74 $21.86$2.82No. Vehicles No./Year Total/Year Cost Each Total Amt.Vehicle U681-2011 Ford 150448.83 $1,122.10$2.50OIL CHANGES‐Gas1 11 $60 $60Vehicle Q681-1996 Ladder Truck303.16$835.26$2.76OIL CHANGES‐Diesel1 11 $120 $120Vehicle BRUS 681- 2001 Ford Brush 160.98$430.50$2.67Pierce Fire Engine1 11 $1,295 $1,295Vehicle ENG 681- 2007 Fire Engine1,054.10 $2,876.43$2.731995 Ladder Truck1 11 $1,295 $1,295160 kW Generator750.00 $2,250.00$3.002015 Ladder Truck1 11 $1,295 $1,295Vehicle F Chief Exped 2009335.47 $1,098.48$3.27Generator Maint.1 11 $2,000 $2,000AVERAGE:3060.28 $8,634.63$2.8210% Increase3366.31$10,451$3.10Total Fuel and Lube:$16,51632Trophy Club Municipal Utility District No. 133 of 33August 19, 2015 - Special Meeting Agenda Packet