Loading...
HomeMy WebLinkAbout2018-01 Jan 16 2018 Regular Meeting agenda packet        BOARD OF DIRECTORS  REGULAR MEETING    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262    January 16, 2018                                                          6:30 P.M.                                     Svore Municipal Boardroom   REGULAR MEETING    CALL TO ORDER AND ANNOUNCE A QUORUM    CITIZEN COMMENTS  This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda.  The Board is not permitted to take action on or discuss any presentations made to the Board at this time  concerning an item not listed on the agenda. The Board will hear presentations on specific agenda items prior  to the Board addressing those items. You may speak up to three (3) minutes or the time limit determined by  the President or presiding officer.    CONSENT AGENDA  All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be  enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that  item will be removed from the consent agenda and will be considered separately.    1. Consider and take appropriate action to approve the Consent Agenda.   a. December 2017 Check Register  b. December 19, 2017 Regular Meeting Minutes  c. Quarterly Investment Report – 1st  Quarter FY 2018  d. Tax Collections Report – 1st Quarter FY 2018          attachments:   December 2017 Check Register           December 19, 2017 Regular Meeting Minutes           Quarterly Investment Report – 1st Quarter FY2018           Tax Collections Report – 1st Quarter FY2018    REGULAR SESSION  2. Receive update from the Audit Committee.    3. Consider and take appropriate action to accept the Fiscal Year 2017 Annual Financial Audit performed  by LaFollet & Company, PLLC.     4. Consider and take appropriate action regarding Water Line Interconnect Alignment Study conducted by  Halff and Associates.     5. Consider and take appropriate action regarding future funding by District of Town of Trophy Club Fire  Department personnel expenses. (Thomas/Hase)    6. Consider and take appropriate action to approve matters related to May 5, 2018 General Election:  Trophy Club Municipal Utility District No. 1 1 of 164 January 16, 2018 - Regular Meeting Agenda Packet     a. Order No. 2018‐0116A calling the May 5, 2018 General Election  b. Notice of Appointment of Agent  c. Authorize General Manager to sign and execute all necessary documents relating to election  d. Other necessary actions as may be required for the May 5, 2018 General Election   attachments:   Order No. 2018‐0116A           Notice of Appointment of Agent    7. Consider and take appropriate action regarding the financing and acquisition of a Vactor Truck for  wastewater cleaning, vacuum extraction and other operations (Staff):  a. Adopt Resolution No. 2018‐0116A, entitled “A Resolution regarding a lease purchase agreement for  the purpose of financing a sewer truck”;  b. Approve Lease Purchase Agreement and execution of same by General Manager; and  c. Authorize such other action as may be necessary and convenient, including execution of all required  documentation, for the District to acquire the Vactor Truck pursuant to the lease purchase  agreement.    attachments:   Staff Report            Resolution No. 2018‐0116A            Lease Purchase Agreement      8. Consider and take appropriate action regarding the December 2017 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance    attachments:   Combined Financials   Combined Variance     REPORTS & UPDATES  9. General Manager Monthly Reports and Update:  a. Regulatory Update  b. Classification and Compensation study  c. Capital Improvement Projects    Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  d. Water System Operation  e. Wastewater System Operation  f. Website Analytics  g. Finance Update   Utility Billing Report   Permits Collected   Cash Report   attachments:  General Manager Update    Water Report    Wastewater Report    Website Analytics    Utility Billing Report  Trophy Club Municipal Utility District No. 1 2 of 164 January 16, 2018 - Regular Meeting Agenda Packet       Permits Collected                           Cash Report    EXECUTIVE SESSION  10. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in  Executive Session on a matter in which the duty of the attorney to the Governmental Body under the  Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open  Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation  or settlement offers:      a. Contractor breach, performance and payment issues related to District’s contract with Webber‐ Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and  b. Provision of District Fire, Water and Wastewater Services and Funding Obligations relating thereto,  for lands located both within the District and within the Town of Westlake (Carr)    REGULAR SESSION  11. Consider and take appropriate action on matters deliberated in Executive Session:    12. Items for future agendas:    13. Set future Meeting dates ‐ Regular Board Meeting on February 20, 2018 at 6:30 p.m.    attachment:  Meeting calendar    *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE  MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT  CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA.  NO FINAL ACTION,  DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN CLOSED SESSION.  THIS NOTICE MODIFIES  THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN  CLOSED SESSION.    ADJOURN    THE STATE OF TEXAS §   COUNTIES OF DENTON AND TARRANT §    THIS NOTICE CERTIFIES THAT ON FRIDAY, JANUARY 12, 2018, BY 6:30 P.M., THE MEETING AGENDA OF  TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS REGULAR MEETING TO BE HELD  ON TUESDAY, JANUARY 16, 2018 AT 6:30 P.M., WAS POSTED ON THE FRONT WINDOW OF TROPHY CLUB  MUNICIPAL UTILITY DISTRICT NO. 1  ADMINISTRATION BUILDING, 100 MUNICIPAL DRIVE, TROPHY CLUB,  TEXAS, WHICH IS A PLACE CONVENIENT TO THE PUBLIC AND WITHIN THE BOUNDARIES OF THE DISTRICT AND  NOTIFICATION WAS POSTED TO THE DISTRICT WEBSITE, IN ACCORDANCE WITH SECTION 49.063 OF THE  WATER CODE AND SECTION 551.054 OF THE TEXAS GOVERNMENT CODE, AS AMENDED.      LAURIE SLAGHT, DISTRICT SECRETARY                Trophy Club Municipal Utility District No. 1 3 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 4 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 5 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 6 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 7 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 8 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 9 of 164 January 16, 2018 - Regular Meeting Agenda Packet REGULAR MEETING MINUTES   TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   December 19, 2017 at 6:30 P.M.  100 Municipal Drive, Trophy Club, Texas 76262    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in  Regular Session on December 19, 2017 at 6:30 P.M., in the Boardroom of the Administration Building,  100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the  District, and was open to the public.    STATE OF TEXAS                            §  COUNTIES OF DENTON AND TARRANT       §    BOARD MEMBERS PRESENT:  Kevin R. Carr President  Gregory Wilson Vice President  William C. Rose Secretary/Treasurer  Jim Thomas Director arrived at 6:33 p.m.  Jim Hase Director    STAFF PRESENT:  John Carman General Manager  Laurie Slaght District Secretary  Renae Gonzales Finance Manager  Mike McMahon Water Superintendent  Karl Schlielig Wastewater Superintendent  Steven Krolczyk HR Manager/Financial Analyst  Tony Corbett Legal Counsel    CALL TO ORDER AND ANNOUNCE A QUORUM   President Carr announced the date of December 19, 2017, called the meeting to order and announced a  quorum present at 6:32 p.m.   CITIZEN COMMENTS  There were no citizen comments    CONSENT AGENDA  1.   Consider and take appropriate action to approve the Consent Agenda.   a. November 2017 Check Register  b. November 21, 2017 Regular Meeting minutes    Motion made by Director Thomas and seconded by Director Rose to approve the Consent Agenda.        Motion carried unanimously    REGULAR SESSION  2.   Consider and take appropriate action regarding water service demands for full buildout within the      Trophy Club Municipal Utility District No. 1 10 of 164 January 16, 2018 - Regular Meeting Agenda Packet District and potential capital improvement projects required to meet such demands. (Thomas/Hase)      Motion made by Director Thomas and seconded by Director Hase to direct the General Manager to  work with staff and review relevant information regarding the need for an additional third ground  storage tank as well as if the District would be in need of the waterline to Westlake and bring his  findings back to the Board.      For: Carr, Hase, Thomas  Opposed: Rose, Wilson    Motion Passed 3‐2      3.   Consider and take appropriate action regarding approval of waterline upgrades to Portland Drive as    a part of FY2018 capital improvement projects and award Contract No. 2019121901.       Motion made by Director Hase and seconded by Director Thomas to approve the waterline upgrades  to Portland Drive as a part of the FY 2018 capital improvement projects and award contract No.  2017121901 to the low bidder Rey‐Mar Construction for an amount not to exceed $70,000.     Motion carried unanimously      4.   Consider and take appropriate action regarding Order No. 2017‐1219A authorizing the General  Manager to approve certain expenditures, providing for the disbursement of District funds, and  containing other matters relating to the safekeeping of the District funds.     General Manager John Carman stated there are conflicting sections within the revised documents  and he would request that the board table this item.  Attorney Corbett requested that any comments  regarding the document be sent to the General Manager.      Agenda Item No. 4 tabled    5.   Consider and take appropriate action to approve an acting General Manager in accordance with  section 4.06 of the Bylaws of the Board of Directors adopted on September 19, 2017 and other  matters related thereto.       Motion made by Director Rose and seconded by Director Wilson to approve the designation of the  acting General Manager as put forth by the General Manager.         Motion carried unanimously      6.   Consider and take appropriate action regarding proposed Independent Contractor Agreement for    Financial Consulting Services.  Trophy Club Municipal Utility District No. 1 11 of 164 January 16, 2018 - Regular Meeting Agenda Packet   Motion made by Director Rose and seconded by Director Thomas to approve the Independent  Contractor Agreement for Financial Consulting Services with Renae Gonzales for a period of one year.  Motion to amend the main motion by Director Rose and seconded by Director Thomas to remove the  word “new” from Section 5.02 of the contract.    Amendment to the Main Motion carried unanimously    Main Motion as Amended carried unanimously      7.   Consider and take appropriate action to update signatories’ and financial transaction agreements   with Prosperity Bank:  a. Treasury Management Agreement  b. ACH Agreement  c. Master Agreement  d. Wire Agreement      Motion made by Director Wilson and seconded by Director Hase to update signatories and financial  transaction agreements with Prosperity Bank: a. Treasury Management Agreement, b. ACH  Agreement, c. Master Agreement and d. Wire Agreement.    Motion carried unanimously      8.   Consider and take appropriate action to approve Treasury Management Resolution No. 2017‐1219A  Authorization to Act for Customer.      Motion made by Director Carr and seconded by Director Rose to approve Treasury Management  Resolution No. 2017‐1219A Authorization to Act for Customer with Prosperity Bank to appoint the  General Manager.    Motion carried unanimously      9.   Consider and take appropriate action to authorize Prosperity Bank to change the District savings  account type to a money market account to yield additional interest. (Staff)      Motion made by Director Thomas and seconded by Director Wilson to authorize Prosperity Bank to  change the District Savings account type to a money market account.       Motion carried unanimously      10.  Consider and take appropriate action regarding financing and construction of water supply and   Trophy Club Municipal Utility District No. 1 12 of 164 January 16, 2018 - Regular Meeting Agenda Packet wastewater improvement projects:  a. Financing and Potential Construction of Capital Improvement Projects to Increase Water Supply at  Eastern Storage Tank  i. Report regarding updated cost estimates   ii. Discussion and possible action relating to potential evaluation of Alternative Water Supply  Projects and Water Management Strategies  b. Report Regarding cost overruns for wastewater treatment plant project  c. Discussion and possible action regarding financing of water supply and wastewater improvement  costs:  i. Adopt Revised Resolution Authorizing Application to the Texas Commission on  Environmental Project and Bonds to Increase Project Scope  ii. Discussion and possible action regarding preparation of application to TCEQ for  authorization to issue bonds  iii. Discussion regarding potential rate impacts associated with financing of projects  iv. Other matters relating to evaluation, funding and construction of water supply  improvement project and wastewater system costs    Director Hase would like to have additional information regarding change orders and make sure they are  brought to the Board for consideration.      Motion made by Director Thomas and seconded by Director Hase to issue up to 7.2 million 2017‐ 1219B revising the cap adopt Revised Resolution No. 2017‐1219B       For: Rose, Hase, Thomas  Opposed: Wilson, Carr    Motion passed 3‐2      Motion made by Director Carr and seconded by Director Rose to direct the General Manager to  execute a contract with CP&Y to continue with the application to TCEQ for an amount not to exceed  $13,500.00.    Motion carried unanimously      11.  Consider and take appropriate action regarding the November 2017 Combined Financials and  Variance Report.   a. Combined Financials   b. Combined Variance       Motion made by Director Rose and seconded by Director Wilson to approve the November 2017  Combined financials and variance report.           Motion carried unanimously    Trophy Club Municipal Utility District No. 1 13 of 164 January 16, 2018 - Regular Meeting Agenda Packet REPORTS & UPDATES  12.  General Manager Monthly Reports and Updates:  a. Update on Renewal of Wastewater Discharge Permit No. WQ0011593001;  b. TCEQ Agreed Order 2016‐0717‐MWD‐E  c. Employee Classification and Compensation study  d. Capital Improvement Projects   Wastewater Treatment Plant Upgrade Project  Waterline Replacement Projects  e.  Water System Operation  f. Wastewater System Operation  g. Website Analytics  h. Finance Update      Utility Billing Report      Permits Collected      Cash Report  i. Project Status Updates           General Manager John Carman presented the monthly reports and updates to the Board and  answered questions related thereto.       The Board did not convene into Executive Session    EXECUTIVE SESSION  13.  Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its  attorney in executive session on a matter in which the duty of the attorney to the Governmental  Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts  with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or  contemplated litigation or settlement offers:      a. Contractor breach, performance and payment issues related to District’s contract with Webber  Cadagua Partners for construction of the Wastewater Treatment Plant Improvements; and      REGULAR SESSION  14.  Consider and take appropriate action on matters deliberated in Closed Session: The Board did not  convene into Executive Session.    15.  Items for future agendas:  Fire taxation     16.  Set future Meeting dates ‐ Regular Board Meetings: January 16, 2018 at 6:30 p.m.      Motion made by Director Wilson and seconded by Director Rose to adjourn at 8:34 p.m.    Motion carried unanimously    Trophy Club Municipal Utility District No. 1 14 of 164 January 16, 2018 - Regular Meeting Agenda Packet ADJOURN    President Carr adjourned the Meeting at 8:34 p.m.      ___________________________  Kevin R. Carr President                                                                                                  ____________________________                                                                    (SEAL)  William C. Rose, Secretary/Treasurer                               ____________________________  Laurie Slaght, District Secretary        Trophy Club Municipal Utility District No. 1 15 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 I certify that this Investment Report complies with requirements of QUARTERLY INVESTMENT REPORT TCMUD's Investment Policy and the Public Funds Act. For Ending Period 12/31/17 (October, November, December 2017) John Carman DATE Rstricted/Account or Sec Rate /Call Purchase Begining Book Begining Market Ending Book Ending Market Gain/Loss Unrestricted CUSIP Type Par Coupon Maturity Date Price Yield %10/1/2017 10/1/2017 12/31/2017 12/31/2017 End MV-End BV Checking & Money Market Accounts Unrestricted XXX6372 Bank of the West Money Market Account 714,332$ 0.000%N/A N/A 100.000 0.250%713,927$ 713,927$ 714,332$ 714,332$ 0.00 Unrestricted XXX8701 Prosperity Bank Consolidated Cash-General Fund 1,654,954$ 0.000%N/A N/A 100.000 0.350%804,685$ 804,685$ 1,654,954$ 1,654,954$ 0.00 Unrestricted XXX8701 Prosperity Bank Consolidated Cash-Fire Dept -$ 0.000%N/A N/A 100.000 0.350%-$ -$ -$ -$ Restricted XXX8701 Prosperity Bank Consolidated Cash-Tax I&S 4,573$ 0.000%N/A N/A 100.000 0.350%4,573$ 4,573$ 4,573$ 4,573$ Pools & Funds Unrestricted XXXXX0002 TexPool Municipal Fund-Operating 1,304,616$ 0.000%N/A N/A 100.000 0.373%1,650,864$ 1,650,864$ 1,304,616$ 1,304,616$ 0.00 TexPool Municipal Fund-Fire Dept 762,115$ 0.000%N/A N/A 100.000 0.373%525,752$ 525,752$ 762,115$ 762,115$ 0.00 TexPool Municipal Fund-GASB Replacemenent 596,426$ 0.000%N/A N/A 100.000 0.373%410,006$ 410,006$ 596,426$ 596,426$ 0.00 Restricted XXXXX0003 TexPool Tax Debt Service 453,387$ 0.000%N/A N/A 100.000 0.373%27,768$ 27,768$ 453,387$ 453,387$ 0.00 Restricted XXXXX00011 TexPool WW Construction Tax 1,322,095$ 0.000%N/A N/A 100.000 0.373%2,699,309$ 2,699,309$ 1,322,095$ 1,322,095$ 0.00 Restricted XXXXX00012 Texpool WW Construction Revenue -$ 0.000%N/A N/A 100.000 0.373%-$ -$ -$ -$ 0.00 Restricted XXXXX00013 Texpool Revenue Bond I&S 179,719$ 0.000%N/A N/A 100.000 0.373%16,210$ 16,210$ 179,719$ 179,719$ 0.00 Restricted XXXXX00014 Texpool Revenue Bond Reserve 470,876$ 0.000%N/A N/A 100.000 0.373%426,579$ 426,579$ 470,876$ 470,876$ 0.00 Restricted XXXXX00015 Texpool Revenue Bond Construction-SWIFT -$ 0.000%N/A N/A 100.000 0.373%-$ -$ -$ -$ 0.00 Restricted XXXXX00016 Texpool Revenue Bond Reserve-SWIFT -$ 0.000%N/A N/A 100.000 0.373%-$ -$ -$ -$ 0.00 Restricted XXXXX00017 Texpool Revenue Bond I&S-SWIFT 76,875$ 0.000%N/A N/A 100.000 0.373%952$ 952$ 76,875$ 76,875$ 0.00 Savings Accounts Restricted XXXXX7724 Prosperity Bank Cash Reserve 581,493$ 0.000%N/A N/A 100.000 0.250%581,054$ 581,054$ 581,493$ 581,493$ 0.00 CD's Restricted X9534 Bank of the West CD-THB*35,316$ 0.000%06/15/18 N/A 100.000 0.450%35,316$ 35,316$ 35,316$ 35,316$ 0.00 US Treasuries NONE US Agencies NONE 8,156,776$ 7,896,994$ 7,896,994$ 8,156,776$ 8,156,776$ -$ EARNINGS SUMMARY Restricted/ Settle Date Sec Type Account Number Par Coupon Maturity Qtr Accrued Qtr Amort.Total Qtr Earnings Unrestricted Checking & Money Market Accounts Unrestricted Bank of the West Money Market Account XXX6372 714,332$ N/A N/A 445$ N/A 445$ Unrestricted Prosperity Bank Consolidated Cash-General Fund XXX8701 1,654,954$ N/A N/A 1,233$ N/A 1,233$ Unrestricted Prosperity Bank Consolidated Cash-Fire Dept XXX8701 -$ N/A N/A -$ N/A -$ Restricted Prosperity Bank Consolidated Cash-Tax I&S XXX8701 4,573$ N/A N/A -$ N/A -$ Pools & Funds Unrestricted TexPool Municipal Fund XXXXX0002 2,663,157$ N/A N/A 6,551$ N/A 6,551$ Restricted TexPool Tax Debt Service XXXXX0003 453,387$ N/A N/A 243$ N/A 243$ Restricted TexPool Construction Tax XXXXX00011 1,322,095$ N/A N/A 4,404$ N/A 4,404$ Restricted Texpool Construction Revenue XXXXX00012 -$ N/A N/A -$ N/A -$ Restricted Texpool Revenue Bond I&S XXXXX00013 179,719$ N/A N/A 216$ N/A 216$ Restricted Texpool Revenue Bond Reserve XXXXX00014 470,876$ N/A N/A 1,215$ N/A 1,215$ Restricted Texpool Revenue Bond Construction-SWIFT XXXXX00015 -$ N/A N/A -$ NA -$ Restricted Texpool Revenue Bond Reserve-SWIFT XXXXX00016 -$ N/A N/A -$ NA -$ Restricted Texpool Revenue Bond I&S-SWIFT XXXXX00017 76,875$ N/A N/A 82$ NA 82$ Savings Accounts Restricted Prosperity Bank Cash Reserve XXXXX7724 581,493$ N/A N/A 440$ N/A 440$ CD's Restricted Bank of the West CD-THB*X9534 35,316$ N/A N/A -$ N/A -$ US Treasuries NONE US Agencies NONE 14,828$ N/A 14,828$ * Bank of the West CD-THB is being held per agreement and will be turned over to THB in three years with all interest earned. PAR for this report is the statement balance on the last day of the quarter Trophy Club Municipal Utility District No. 1 16 of 164 January 16, 2018 - Regular Meeting Agenda Packet PerdueBrandonFielderCollins&Mott LLP ATTORNEYS AT LAW 500 EAST BORDER ST, SUITE 640 ARLINGTON, TEXAS 76010 TELEPHONE 817-461-3344 FAX 817-860-6509 www.pbfcm.com David S. Crawford Attorney At Law January 11, 2018 dcrawford@pbfcm.com Mr. Steven Krolczyk Trophy Club MUD No.1 100 Municipal Drive Trophy Club, Texas 76262 RE: Status of Collection of Delinquent Taxes Dear Mr. Krolczyk, Please find attached a copy of the Authority Analysis report for Trophy Club MUD No.1 as of today. Also included is a delinquent tax roll for all tax years through 2016, as well as a delinquent tax roll for only the 2016 tax year. This update is good through December 31, 2017. Through our collection efforts, we have reduced the 2016 tax base from $13,721.49 to $3,972.66 in the first six months of the delinquent collection year from July 1,2017 through December 31,2017. This results in a collection percentage of 71.05%. I have also included two charts that shows the amount of base taxes due to Trophy Club MUD No. 1 that are currently deferred because the taxpayer filed a deferral with the Denton CAD for their homestead since they are over 65 years of age. For 2016 alone, this amounts to $2,401.75. The ALL year total of deferred base tax is $16,188.79. Unfortunately, we cannot collect these amounts until the deferral is removed by the Denton CAD. If you have any questions or comments, please feel free to contact me at the office. Thank you for your continued support and interest in our efforts to collect the delinquent taxes for Trophy Club MUD No.1. PERDUE, BRANDON, FIELDER, COLLINS ~MOTT'/D'PiJ J ,QJJ~ David S. Crawford AMARILLO ARLINGTON AUSTIN CONROE GARLAND HOUSTON LUBBOCK MCALLEN MIDLAND SAN ANTONIO TYLER WICHITA FALLS Trophy Club Municipal Utility District No. 1 17 of 164 January 16, 2018 - Regular Meeting Agenda Packet PerdueBrandonFielderCollins&Mott LLP ArrOI-tNEYS A*r LAW 'vV\.V\/<.I., b f c nl . C 0 n~~ AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 1/11/2018, Last Tax Year Included 2016 In Bankruptcy 1 1.33% $35.18 .15% In Trust o .00% $.00 .00% In Deferral 7 9.33% $16,188.79 69.00% In Litigation 6 8.00% $2,830.04 12.06% In Partial Pay o .00% $.00 .00% In Uncollectable 5 6.67% $3.30 .01% In Bad Address 21 28.00% $1,911.35 8.15% Action Pending 35 46.67% $2,494.11 10.63% Totals 7S 100.00% $23,462.77 100.00% $0.01 $100.00 54 75.00% $798.69 3.40% $100.01 -$250.00 6 8.33% $1,097.00 4.68% $250.01 -$500.00 4 5.56% $1,246.97 5.31% $500.01 -$1000.00 4 5.56% $3,089.01 13.17% $1000.01 $2500.00 2 2.78% $4,502.36 19.19% $2500.01 $5000.00 1 1.39% $4,741.54 20.21% $5000.01 -$10,000.00 1 1.39% $7,987.20 34.04% Totals 72 100.00% $23,462.77 100.00% 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 1 1 1 1 1 1 1 1 1 3 7 9 6 13 14 12 13 .59% .59% .59% .59% .59% .59% .59% .59% .59% 1.78% 4.14% 5.33% 3.55% 7.69% 8.28% 7.10% 7.69% $71.22 $68.76 $58.94 $58.94 $58.94 $73.67 $110.02 $110.02 $110.02 $644.26 $970.56 $1,101.11 $981.60 $3,057.61 $2,477.69 $1,994.15 $2,156.68 .30% .29% .25% .25% .25% .31% .47% .47% .47% 2.75% 4.14% 4.69% 4.18% 13.03% 10.56% 8.50% 9.19% Trophy Club Municipal Utility District No. 1 18 of 164 January 16, 2018 - Regular Meeting Agenda Packet 2014 23 13.61% $2,637.73 11.24% 2015 27 15.98% $2,748.19 11.71% 2016 33 19.53% $3,972.66 16.93% Totals 169 100.00% $23,462.77 100.00% UNumber 0/properties moy differ in the first two sections because a property may reside in more thon one category In the first section. Trophy Club Municipal Utility District No. 1 19 of 164 January 16, 2018 - Regular Meeting Agenda Packet 2016 TROPHY CLUB MUD #1 OVER 65 DEFERRALS 2016 TAX YEAR ONLY Taxpayer# Name Base Tax Due 799 Baker, Bob J. $1,069.49 376 Masters, James & Sally $563.25 76 McDonald, James $400.74 968 Boren, Benjamin C & Beverly C $367.89 1570 Goswick, Cherie $0.37 90475 Cornwall, Karin $0.01 TOTAL $2,401.75 Trophy Club Municipal Utility District No. 1 20 of 164 January 16, 2018 - Regular Meeting Agenda Packet 2016 TROPHY CLUB MUD #1 OVER 65 DEFERRALS All Years Taxpayer# Name Base Tax Due 799 Baker, Bob J. $7,987.20 76 McDonald, James $4,741.54 1205 Shires, Brenda $30.88 968 Boren, Benjamin C & Beverly C $2,437.86 90475 Cornwall, Karin $0.01 376 lVIasters, James & Sally $990.93 1570 Goswick, Cherie $0.37 TOTAL $16,188.79 Trophy Club Municipal Utility District No. 1 21 of 164 January 16, 2018 - Regular Meeting Agenda Packet Descending Tax Roll TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 For Years 2016 Through 2016 For Amounts $0.01 To $999,999,999.99 TaxPl'Wer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 799 BAKER BOBJ $1,069.49 D DEFE II STEPHENS CT TROPHY CLUB. TX 76262-5421 ClientGE() Code Clietlt Property Code PTncOfh T~~ Tota/Due 209674DEN R29674 R 2016 $1,069.49 $U47.88 TaxP<:lyer # 376 Taxpayer name MASTERS W JAMES & SALLY P 10 FAIR GREEN DR TROPHY CLUB, TX 76262-5629 Base Tax $563.25 Cause # Judgment Date OOS LI BI PI D D Status Indicators TaxP<:lYE!L!L3axpayer naml:l_ 76 MCDONALD JAMES E 4 ROSSCT TROPHY CLUB. TX 76262-6711 Base Tax $400.74 !€lientOEO COde '72060DEN Cause # Judgment Date OOS Lie! PI D Status Indicators D DEFE ~li'operty Code PTD Code Y~~tkd TtlXDue: R72060 R 2016 $400.74 TotalDti:e $430.11 TaxP<:lYl:lr:lLJaxpayer namEL_ Base Tax Causl:I/L JudgmE.lllt Date OOS LI BI PI D Status Indicators 968 BOREN BENJAMIN C & BEVERLY C $367.89 D DEFE 14 EDGEMERE DR ,q~~~rty€ode .l'e4fS'Ittduded TuX,lJut.' Totm»",TROPHY CLUB. TX 76262-9725 R71012 R 2016 $367.89 $394.86 TaxpaYer 1# Taxpayer nl:lmE.l Base Tax Cause # JudgmE.lnt Date OOS LI 131 PI D Status Indicators 1042 HEBERT CHARLES M $360.26 29 TIMBERUNE DR ROANOKE, TX 76262-9770 1/11120189:21 :39 AM Page 2 of7 Trophy Club Municipal Utility District No. 1 22 of 164 January 16, 2018 - Regular Meeting Agenda Packet 70 Taxpayer # Taxpay~r name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 294 RENCHER RONNIE GLEN & CAROLE $260.05 DENISE PO BOX 1546 IClientOEOCQde C~Code PTlJC_fftllft~tletl TtlXl>It,', i:~s7~Da~ ROANOKE, TX 76262-1546 70222DEN R7222 R 2016 $260.05 $386.95 Tax~er # 914 Taxpayer # 1712 Taxpayer name m_____ MORTON DENVER & JANIE 3 HILLCREST CT TROPHY CLUB. TX 76262-5515 Taxpayer name HOLLIMAN VENTURES LLC 3440 CROSSBOW DR FRISCO. TX 75033-1123 Base Tax Cause # JlJ(jgment Date OOS LI BI PI D Status Indicators $218.89 Client GEOCode 72277DEN Property Code' PTDCode YtIIII'Slnciudetl R72277 R 2016 QPAY TtlXDw $218.89 Base Tax Cause # Ju(jgment Date OOS L.1131 PI D Status Indicators $206.35 15-03739-442 Cli¢nt·OEO Code ~PropertjCOOe 1563647DEN P563647 8/23/2016 L ,SUIT PTDClRte Yean IndRded TaxlJlle' P 2016 $206.35 rma[~J TDttII Drte $307.05 Taxpayer # Tax~yer nal1l~_____ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90619 WILLIAMS JEFFREY 0 & LARISSA $175.85 100 SILVER ROCK DR TROPHY CLUB, TX 76262-5 I 17 CienH~OCodt-- 189787DEN (;~r~operty CodePTDaNIe . Yeanl"'ded--'T~Ii* RI89787 R 2016 $175.85 .ToI!4~ $261.66 TaxpaY~rlL-.-Iaxpayer narn~ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 65 FIRST MADISON BANK FSB 14651 DALLAS PKWY STE 200 DALLAS, TX 75254 (214) 770-3711 $72.93 14-03488-21 I 141­ E31255-14 2/23/2012 L Included . SEL, SUIT Tux1Jlle ''l'~. $26.38 $39.25 40778495TAR R4778495TAR R 2016 $46.55 $69.27 Taxpayer # T':Il(pay~r nC!lme Base Tax Cause # JlJclgment Date OoS LI BI PI D Status Indicators YEAGER CAROL H $65.46 QPAY 12 HERJT AGE CT S TROPHY CLUB. TX 76262-5511 $92.69 1/11/20189:21 :40 AM Page 3 of7 Trophy Club Municipal Utility District No. 1 23 of 164 January 16, 2018 - Regular Meeting Agenda Packet 277 1769 Tax~f# Iax~y~!name Base Tax Cause # Judgment Date OOS 1.1 Ell PI 0 Status Indicators 1242 FORD LESLIE $59.08 15-06894-43\ L SUIT 529 SPICEWOOD CT I~GEOCode .. Client Property COde ''I!1z,t;mte Yean Indatied l'_1Jae TMJaieKELLER, TX 76248-8473 926478DEN P926478 P 2016 $59.08 $87.91 Taxpayer # Taxpay~r name m_______ Base Tax Cause # JlJdgment Date OOS LI Ell PI 0 Status Indicators TROPHY CLUB CLEANERS $33.76 301 TROPHY LAKE DR UNIT 104 Cl~t\J1t oro Code . .~ient Property: CC>de,': '1"1J1 C«k fe'lD'S:~ TaxDu. TMtllDIM! TROPHY CLUB. TX 76262-5237 929539DEN P929539 p 2016 $33.76 $50.23 Tax~y~r # II3)(Pfly~r name Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators CAMPUS CIRCLE WESTLAKE LLC $33.12 29 COMMONWEALTH AVE BOSTON, MA 02116 CIlentGEOCode . Client Property: Code P'tD Code' YiiiiSliidllded TtiXDw riJldlDrN 41463978T AR R41463978TAR R 2016 $33.12 $49,28 Taxpayer # Tax~y~rname Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators 759 MORRISON AVIATION LLC $30.23 . UP P. O. BOX 1691 'CfIdtI. y_~ClieD.tPmperty ~. 'rlJlidlJaeTX 75766-1691 P339971 P 2016 $30.23 $44.98 TaxQa'yer # II3)(~y~r ntllTle Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators 58 WEINBERGER DELI TWO LLC $17.01 3 VILLAGE CIR STE 116 C1i.~EO Code ~erty·e~:.· PTD C~e----Y~i~~ l'@1>#~ 'l'iiiiiiDue , "':': ~' ". .. ..\:tlh..h .. ,"WESTLAKE, TX 76262-7935 11514205TAR PIl514205TAR P 2016 $1701 $25,31 Taxpayer # TaxPflyer name Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators 1284 lHAHN GENERAL HOLDINGS CORP $11.20 1160 S PIONEER RD STE 5 SALT LAKE CITY, UT 84104-3738 $16.67 Taxpayer # TaxPflyer nalTl~ Base Tax Cause # m___ Judgment Date QQS LI BI PI 0 Status Indicators 1711 STYLES OF INDIA $10.88 2003 SH 114, STE 340 TROPHY CLUB, TX 76262 1/11/20189:21:40 AM Page 4 of7 Trophy Club Municipal Utility District No. 1 24 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90369 FOOT PALACE SPA 30 I TROPHY LAKE DR UNIT 124 ROANOKE, TX 76262-5237 $8.39 Client GEO Code 656969DEN Client Property Code I'TD Ci)t/a . Yetll'!l Included TaxDu, P656969 P 2016 $8.39 701l1lDue $12.48 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1638 NATIONAL DEFAULT TITLE SERVICE PO BOX 168608 IRVING, TX 75016 $3.17 Client QEO Code 13661787TAR eli~.t Property Code ptl'l) CtH1e Yetll'!l.lncluded TaxDti.( PI3661787TAR P 2016 $3.17 'Forlll Dae $4.68 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90310 BENEFIT ARCHITECTS INC 1301 SOLANA BLVD STE 2320 WESTLAKE, TX 76262-1676 Client GED Code 11062843TAR $2.40 Client Property Code PII062843TAR PTJ) Code Yetll'!l Included Tax Due P 2016 $2.40 Total Due $3.57 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 354 RS WATER HOLDING LLC 3201 PREMIER DR STE 300 IRVING, TX 75063-6075 Client QEO Code 14389563TAR 14479384TAR $0.55 Client llroPerty Code . P14389563TAR P14479384TAR PTDCodI Yeanlncluded P P 2016 2016 . UP TaxDae $0.46 $0.09 Totlll Due $0.63 $0.12 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 91051 AUTO-CHLOR SERVICES LLC 500 DAKIN ST DBA AUTO-CHLOR SERVICES OF JEFFERSON, LA 70121-4008 $0.53 Client: OEO Code 14384456TAR Client Property Code PTDf:Ode .'f~llU!bided Tax Due P 14384456T AR P 2016 $0.53 TotalDite $0.73 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1570 GOSWICK CHERIE $0.37 D DEFE 542 TIMBER RIDGE DR TROPHY CLUB, TX 76262-5644 '·ClientGEOCode Client Property Cod¢' · PTPCotk YeoI$lnelltt/e:d TaxDut! , Tiit4lDue 70677DEN R7677 R 2016 $0.37 $0.38 1/11/20189:21:41 AM Page50f7 Trophy Club Municipal Utility District No. 1 25 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # Taxpayer name Base Tax Cause # m_______ Judgment Date OOS mLLBiPl D Status Indicators 90713 ROYAL CUP INC $0.29 PO BOX 170971 Cll..<a:BO Code .qlietrt Property Code P'I'IJcJ:tde . ,f((ll'S l"daded l'axl)J,eBIRMINGHAM, AL 35217-0971 ~oi4iD~~J14380710TAR PI4380710TAR P 2016 $0.29 Taxpayer # Taxpayer name 90293 FIRST DATA MERCHANT SVCS INC 5755 DTC BLVD 4TH FL GREENWOOD VILLAGE. CO 80111 Taxpayer # Taxpayer name nm___ 63 PITNEY BOWES GLOBAL FINANCIAL 5310 CYPRESS CTR DR STE 1 \0 TAMPA FL 33609-1041 Taxpayer # Taxpayer name 112 HOT & CREAMY DONUTS 301 TROPHY LAKE DR UNIT 108 TROPHY CLUB, TX 76262-5237 Base Tax Cause # m ______----lI.Jdgment Date OOS I..LaU?J D Status Indicators $0.26 eenfGEO Code Client Property Code PrDC~ Years Incl4tletl Tax IJae TtIttII "., 1 4370986TAR P14370986TAR P 2016 $0.26 $0.36 ---------­ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $0.20 ~GOO Code CliCl¢~Code PTD c:9tli Fan ltiiiiided ---------tIix D"e rllttll D"e ! 14350063TAR P14350063T AR P 2016 $0.20 $0.29 a13seT;:Jx Cause # Judgment Date OOS 1..1 131 PI D Status Indicators $0.02 Client Client ProDeii~~; 929538DEN P929538 P 2016 Taxpayer # Taxpayer name l:3eseIax Cause # Judgment Date OOS LI BI PI D Status Indicators 1497 THIBAULT LAWRENCE R & JEANNETTE E I I I LAKESIDE DR ROANOKE. TX 76262-5231 $0.02 Client GE(H;~J~: Clieotpro~.~e. 203807DEN R23807 TaxmlYer # Taxpayer name l:3aseIIDL Cause # Judgment Date OOS LI BI PI D Status Indicators 90475 CORNWALL KARIN $0.01 D DEFE 28 FAIR GREEN DR TROPHY CLUB, TX 76262-5629 TaxpaYerlt ___Jaxpa~name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90798 ROACH DAVID & SHARLA $0.01 40XFORDPL TROPHY CLUB, TX 76262-5129 1/11/20189:21 :41 AM Page 6 of 7 Trophy Club Municipal Utility District No. 1 26 of 164 January 16, 2018 - Regular Meeting Agenda Packet ......... ..... ......... I\) 0 ..... CO to i-.l ..... :,;. ..... }>s: \;j -i ~ "0 III ~ (l).., '" Trophy Club Municipal Utility District No. 127 of 164January 16, 2018 - Regular Meeting Agenda Packet Descending Tax Roll TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 For Years 1994 Through 2016 For Amounts $0.01 To $999,999,999.99 Taxpayer # Taxpayer name 799 BAKERBOBJ II STEPHENS CT TROPHY CLUB. IX 76262-5421 TaxpaYE!~Taxp~YEJr n~rne 76 MCDONALD JAMES E 4 ROSSCT TROPHY CLUB, TX 76262-6711 Taxm:Jyer # Taxpayer name 968 BOREN BENJAMIN C & BEVERLY C 14 EDGE MERE DR TROPHY CLUB. TX 76262-9725 Base Tax Cause # Judgment Date OQSJ..LID1:ll D Status Indicators m_ $7,987.20 D DE FE ClieatOeo Code.CliCtlt Property CCIde; l'TIJiCtXk tetp'SI#i~tl -TIIX.lJ1f.e T(RalDue 209674DEN R29674 R 2010-2016 $7,987.20 $11.42633 Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators $4,741.54 D DEFE ciiiiiiboo Code Client Property Code . PTD ellde'je~i/iidiiikil illX~···· 'IotalDlie 72060DEN R72060 R 2006-2016 $4,74l.54 $7.168.98 Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators $2,437.86 D DEFE ClientGEO Code ·Clientl?roperty Code>JirlD elide Yeanlndutletf --------1'ax Due 'IotalDae 71012DEN R71012 R 2010-2016 $2,437.86 $3,214.27 Taxpayer # Taxpayer narne Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 59 SUMMERS, JAMES M $2,064.50 L-24321 1211/2011 L ,BKR. SUIT 532 LEA V ALLEY CIR COPPELL, TX 75019 cli~t',mro CQde if Property Code~~~'njjtt1d~· YM'l,fcliiilett T~i~Ui!l .Total DIlt: i11514221TAR PI 151422ITAR p 2008-2014 $2,064.50 $4,624.34 Taxpayer # TaxpaYer n~rnEJ Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 65 FIRST MADISON BANK FSB $1,658.86 14·03488-2 II 2/23/2012 L ,SEL, SUIT 141­14651 DALLAS PK WY STE 200 DALLAS, TX 75254 (214) 770·3711 E31255·14 R296671 R4778495TAR R R 2006-2007 2008-2016 $155.42 $533.69 $425.84 $\J33.46 1/11/20189:23:51 AM Page 2 of 12 Trophy Club Municipal Utility District No. 1 28 of 164 January 16, 2018 - Regular Meeting Agenda Packet 376 Taxpayer # Taxpayer name nBase Tax Cause # Ju<:tgment Date OOS LI BI PI D Status Indicators MASTERS W JAMES & SALL Y P $990.93 D 10 FAIR GREEN DR TROPHY CLUB, TX 76262-5629 :nt.GEO. Code . :glieni'Ptoperty Cod~ pnf(;..~rJliiS~j~ RI16467 R 2015·2016 Taxpayer # Taxpayer name Base Tax CaU!;~#__ Judgment Date OOS LI EHPI D Status Indicators 1712 HOLLIMAN VENTURES LLC $594.64 15-03739·442 8/23/2016 L , SUIT 3440 CROSSBOW DR fClientGEO. Code' '. ;"Q~~perty C~ !;rI'J)Code Yedniiielaiiiif FRISCO. TX 75033-1123 563647DEN P563647 P 2014-2016 TaXPID'!!LII_ Tax~y~r nl'.llTl~ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1042 HEBERT CHARLES M $360.26 29 TIMBERLINE DR ROANOKE, TX 76262-9770 IC~GEO CodeCi~tPropertY~l)dj i70924DEN R7924 I PTD COde Yl'lIn' btct.ded R 2016 T,*~.e: $360.26 Total Dlle $536.07 Taxpayer # Taxpayer name m_____ 123 DIEGO'S TEX-MEX STEAKS 3 VILLAGE CIR STE 108 WESTLAKE, TX 76262-7935 (817) 430-3558 TaxP!'OO![# Taxpayer name 1560 BURGAR BRANDON 301 TROPHY LAKE DR STE 120 TROPHY CLUB, TX 76262-5237 Tax~Y~rlL Tax~yer nalTl~_____ 294 RENCHER RONNIE GLEN & CAROLE DENISE PO BOX 1546 ROANOKE, TX 76262-1546 Tax~y~r # Tax~yer nl'.llTl~ 1242 FORD LESLIE 529 SPICEWOOD CT KELLER, TX 76248-8473 Base Tax Cause # JudgrTl~nt Date OOS LI al PI D Status Indicators $316.25 UP ..Client GEOt~~ Clien~Fii&p~~··. .1·:YiD~CiHle 'lmalDue 947887DEN 1'947887 P $84376 liefti oeo'iCode Base Tax Cause # JudgrTl~nt Date OOS LI al PI D Status Indicators $310.41 16-04123-158 L SUIT .1c,~i·:0i~~iiiIiJ# P620602 p 2013·2014 Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $260.05 Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $230.38 15-06894-431 L SUIT 1/11120189:23:53 AM Page 3 of 12 Trophy Club Municipal Utility District No. 1 29 of 164 January 16, 2018 - Regular Meeting Agenda Packet Tax~~# Tax:PEly~r nam~ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 914 MORTON DENVER & JANIE $218.89 QPAY 3 HILLCREST CT TROPHY CLUB, TX 76262-5515 Clieut~(;ooemClient]i>roperty~ 'YJ'D.~'. r.,:l_tfe1l TtUJJ"e ~"il 72277DEN R72277 R 2016 $218.89 $309.95 TaxPElY~L# TaxPEly~r l'll:lm~ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 759 MORRISON A VIA nON LLC $214.47 , UP P. O. BOX 1691 <;:tient GEO COde Client Property Code PTD CoJe-"]'iiiifliiidutled T(I;¥: Due TotIII Due .' 'I JACKSONVILLE, TX 75766-1691 339971DEN P339971 p $214.47 $415,22 TaxPElyer # TaxPElyer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90619 WILLIAMS JEFFREY 0 & LARISSA $175.85 100 SILVER ROCK DR f::1ient OEO Co!l.¢ Client Propel"tYGO&e. PT1J eM Yearsltildilt.6ltl TaD"e Tot_D"eTROPHY CLUB, TX 76262-5117 189787DEN RI89787 R 2016 $175,85 $261.66 Taxpl:ly~L~TaxPElyer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1769 CAMPUS CIRCLE WESTLAKE LLC $101.99 29 COMMONWEALTH AVE cn~GEOCcixte :rem'~~d ,99 r.ull,#!BOSTON, MA 02116 41463978TAR R41463978TAR R 2014-2016 $166,68 TaxPEly~r # TaxPElyer nam~ Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1184 VERIZON $82.41 301 TROPHY LAKE DR UNIT 124 CIieD~GEO Co4e l;ii.pient Pr~Code: ';4,~j)Cotk YetU'JIiiCfi,~;: TaJJ"e TOI81Dile ;1ROANOKE, TX 76262 1469054DEN P469054 P 20 1-2013 $82.41 $169,55 I TaxpaY~LIi TaxPElyer name Base TI:lx:Cause # Judgment Date OOS LI BI PI D Status Indicators 70 YEAGER CAROL II $65.46 QPAY 12 IIERIT AGE CT S 'Client{1eo ~::, r~,~.;•. ,,)y,;~,;)l'~W; lotN.~eTROPHY CLUB, TX 76262-5511 $65.46 $92.69 TaxPEly~r # TaxPElyer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 129 REMAX INTEGRITY $61.15 UP 100 TROPHY CLUB DR. STE, 102 ROANOKE, TX 76262 l'''''"; ',_,,'~'::'~''s';\ ,~\'~.","?;~T'ftixDiie"--,'2,.' , 't()fol:DJU•. ·.·.·.'·.l""" ".., ';. '", ,', :< .':",~':';:';.:::.!;.,:~~ $61.15 $154,00 --------------_..........._---------_.......... ......_._---­ 1/11/20189:23:55 AM Page 4 of 12 Trophy Club Municipal Utility District No. 1 30 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 130 POLO CLEANERS 2652 FM 407 E ARGYLE, TX 76226 (940) 241-1486 $59.40 Client GBO Code·· 953833DEN Client Property Code P953833 UP PTlJ cofif .• Yelll'S lllCluded T.xlJoe P 2008 $59.40 ToralDoe $150.28 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 57 J P TALBOT INSURANCE PO BOX 93152 SOUTHLAKE, TX 76092 $51.82 Client GEO Code ·.~lf~t Property Code 10374248TAR PI374248TAR UP PTDC,ode Yelll'S'lnchtded Tax.lJoe P 2008-2011 $51.82 Total Due $124.65 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1164 W ALJI SHANIF M 504 N OAK ST STE 1 ROANOKE, TX 76262-5005 $45.93 Client GEO Code 336817DEN Client Property Code .PTD ClHie ¥llfU'SlnchtderJ TaxDu,e P336817 P 2014-2015 $45.93 TotlllDu.e $77.99 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 103 FIDELITY NATIONAL TITLE 99 TROPHY CLUB DR TROPHY CLUB. TX 76262-5422 $42.70 CU~GEOCode 930792DEN ,Client PropertY Code PTD Code Years Included Taxl>{le P930792 P 2007-2008,20 I 0 $42.70 TotlllDoe $107.81 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1284 IBAHN GENERAL HOLDINGS CORP 1160 S PIONEER RD STE 5 SALT LAKE CITY, UT 84104-3738 $40.96 Client OBO Code 11648163TAR .Client ProPertY ;Code· ;PtlJ cOile· yennlnclulkt/. Tax Doe P11648163TAR P 2012-2016 $40.96 TotaI;lJoe $69.31 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1730 EARCARE HEARING AIDS 501 TROPHY LAKE DR STE 318 ROANOKE, TX 76262-5239 $35.18 ,~~t GEO Code ~tPropertyJ::ode 633172DEN P633172 B BKR l!f'D Code Years Inclu.ded TuD"e .. P 2014-2015 $35.18 TotIIlDoe $59.73 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 277 TROPHY CLUB CLEANERS $33.76 301 TROPHY LAKE DR UNIT 104 TROPHY CLUB, TX 76262-5237 C~;$tlC9<1e: .'¥e.«<r$J~~(l i:faxDt.« .~ ~;'ijtil;-:< 929539DEN P929539 P 2016 $33.76 $50.23 1/11/20189:23:57 AM Page 5 of 12 Trophy Club Municipal Utility District No. 1 31 of 164 January 16, 2018 - Regular Meeting Agenda Packet TaxPlllYl:!r 1# I;:ixPlllyer name Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators 1205 SHIRES BRENDA $30.88 D DEFE 7 LAKE FOREST CT cu~JIJ'op!ilt'ty(:';od\t lfIl1ciI(Je r--litel.". m TROPHY CLUB, TX 76262-5504 tii.»ae .~fJItIll1w«...... I" R7643 2014 $30.88 $38.08 --~~~~~~~ TaxPlllyer # Taxpayer name Base Tax Cause # nm_~gment Date OOS Ll aLI'I D Status Indicators 475 FIRST AMERICAN LEASING $29.05 UP PO BOX 168608 C\lliij!tGEOCode Client Property Code <ptjciiik -yea,."ladUdedTtaDue r«aJ hue IRVING, TX 75016-8608 !13427849TAR P 13427849TAR P 2008 $29.05 $65.14 Taxpayer # Taxp;:ijler name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1626 GARD JEFFERY L & MARGARET $25.00 p PONIG ~Code .'Y_~c'~OEoCode TaxDlie TMIIIBIU806 TURTLE DOVE TRL COLLEGE STATION, TX 77845-6058 16514DEN R116514 R 2014 $25.00 $44.40 Tax~ Tax:PaYI:!LI1;:ime Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 741 MIJOL REAL TY.COM $20.36 100 INDIAN CREEK DR STE 120 .Client .PTOpe!ti Code i::nD't~tinfj_"'Cli~ 'laDlle TOIIJf ... ROANOKE. TX 76262 P336821 P 2010·2011 $20.36 $46.50 TaxPlllyer # II3x:PaYl:!r n;:irne Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1711 STYLES OF INDIA $20.23 2003 SH 114, STE 340 TROPHY CLUB, TX 76262 P563646 P 2015-2016 TaxPlllyer # II3x:payer name Base Tax Cause # Judgment Date OOS LI BI PI 0 Status Indicators 90310 BENEFIT ARCHITECTS INC $17.04 l301 SOLANA BLVD STE 2320 •Yean/a ,,~~,', TottdBUi:Cllen~~erty C~ZWESTLAKE, TX 76262-1676 PII062843TAR p 2015-2016 $17.04 $27.46 TaxQI3W # Taxpayer narnl:! Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 58 WEINBERGER DELI TWO LLC $17.01 GEOCO<te 3 VILLAGE CIR STE 116 WESTLAKE. TX 76262-7935 1/11120189:23:59 AM Page 6 of 12 Trophy Club Municipal Utility District No. 1 32 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # 1530 Taxpa~Ll'll3m~ DESIRE SALON & SPA 2001 W SH 114 STE 150 TROPHY CLUB, TX 76262 Taxpayer # 90369 TaxIll'.lY~rnl3m~ FOOT PALACE SPA 30 I TROPHY LAKE DR UN[T 124 ROANOKE.1X 76262-5237 T~ayer # 122 T~xPl3yer n~m~ GARLITZ FfNANCIAL SVCE 103 SKYLfNE DR ROANOKE, TX 76262 (817) 49[-[454 TaxPl3yer # 887 TaxPl3yer name TONY CAO SALON & SPA 1901 LONG PRAIR[E RD STE 260 FLOWER MOUND, TX 75022 Base Tax $16.51 Cause # Judgment Date 005 LI BI PI D Status Indicators IClientGEOCod,e 1499622DEN C:li~tP~Oodewn1J'e~Y yetinl"claded. P499622 P 2013 ---~""'e $16.51 Total DIu $31.70 Base Tax $[5.61 CIient-OE(YCoae­ 656969DEN Cause # Judgment Date 005 LI BI PI D Status Indicators Clteat Property Code P656969 PTD C9tk Yt!IIJ"8./fJcluded T.fIXJ1H . P 2015·2016 $15.61 Totllll'hul $24.26 Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators $15.18 UP Client GOO Code Gliertt PropettY C~ . PTlJ;·C(J(/e; YetD'S l11datIerJ Td'XDIie r_l'hul P947758 P 2007 $15.18 $40.50 Base Tax Cause # Judgment Date 005 LI BI 1='1 D Status Indicators $13.48 Clielt;,$b~. Client Property COde lfiiiciide m,t_~~ti¥'~~-~-:--f~~(l 953825DEN P953825 P 2011 $13.48 $29.76 Taxlll'.lYer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 190 WHITTON CONSTRUCTION INC $11.56 r1241 CYPRESS CREEK CT SOUTHLAKE. TX 76092-4119 P 2011 $11.56 $25.52 Taxp~y~r 1# I~l(p~yer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 740 CJ HOOD CO INC $10.73 100 INDIAN CREEK DR CI~.nt Prqperty~. BTD.COtk ···.I'a~, XUlDJD.e.TROPHY CLUB, TX 76262 336819DEN P336819 P 2010 $10.73 $25.24 '~~.~ ;PTJ!iif:oifii: f_~iti.tI( ";'/<', ';:'/, 1'_D~e __ TaxPl3y~r 1# T~xPl3yer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 1638 NATIONAL DEFAULT TITLE SERVICE $9.12 PO BOX 168608 IRVING, TX 75016 1/11/2018 9:24:00 AM Page 7 of 12 Trophy Club Municipal Utility District No. 1 33 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 875 CHRISTLIEB LAW OFFICE 3 LLANO DR ROANOKE, TX 76262 $5.37 Client GEO Code 925240DEN CHent Property Code P925240 p!J!J)-(:tHlc. YetII'J fnclu.tl.ed P 2010-2011 TflXD"'e $5.37 TotalD.e $12.27 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1555 DONNA & ASSOCIATES $4.40 99 TROPIIY CLUB DR ROANOKE, TX 76262-5422 Client GEO Code 566115DEN Client Property Code P566115 PTD etHIc Yean fncluded P 2013 TflXD.e $4.40 Total Due $8.45 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90372 RAY DERSTEIN $3.61 99 TROPHY CLUB DR ROANOKE, TX 76262-5422 Client GEO Code 659398DEN Client Property Code P659398 PTJ) Code Yean Inclu.ded P 2015 TaxDNe $3.61 TotalDue $5.89 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1628 TROPHY CLUB TOWN OF $3.29 100 MUNICIPAL DR TROPHY CLUB, TX 76262-5420 IClient GEO Code . Client Property Code PTJ)CtHIe Yean Included TaxD. To/aiDNe 116598DEN RI16598 R 2014 $1.20 $2.13 116600DEN RI16600 R 2014 $1.11 $1.97 624324DEN R624324 R 2014 $0.52 $0.92 624325DEN R624325 R 2014 $0.46 $0.82 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90423 D L PETERSON TRUST PO BOX 13085 BALTIMORE. MD 21203-3085 $2.88 Client GEO Code 12675504TAR Client Property Code PI2675504TAR ..P'I'D Code Yetlt$lndudiid. P 2015 TaxDNe $2.88 TotaIJ1u.e $4.60 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 90303 RANDSTAD US LP $2.76 150 PRESIDENTIAL FL 4 WAY WOBURN, MA 01801-1100 G~tGE0C. T(aDue li11ti1Due .. GientProp~Code '. ..".\ .. 13730967T AR P 13730967T AR P 2014-2015 $2.76 $4.57 1/11/20189:24:02 AM Page 8 of 12 Trophy Club Municipal Utility District No. 1 34 of 164 January 16, 2018 - Regular Meeting Agenda Packet 1330 Taxpayer # Taxpayer name Base Tax Cause # ,Judgment Date OOS LI BI PI D Status Indicators nm_____ MUZAKLLC $1.30 '1'___3318 LAKEMONT BLVD ~~Pro~Code n:PCotk ¥~~ ,~.~ FORT MILL. SC 29708-8309 P566957 P 2015 $130 $2.12 Taxpayer # 1329 Taxpayer name HELM INSURANCE AGENCY 99 TROPHY CLUB DR TROPHY CLUR TX 76262-5422 Taxpayer # 90713 Taxpayer name ROYAL CUP INC PO BOX 170971 BIRMINGHAM, AL 35217-0971 Taxpayer # 354 Taxpaver name RS WATER HOLDING LLC 3201 PREMIER DR STE 300 IRVING. TX 75063-6075 Taxj:>ayer # Taxpayer name 9\051 TaxQayer # AUTO-CHLOR SERVICES LLC 500 DAKIN ST DBA AUTO-CI-ILOR SERVICES OF ..... _ ..... <'T"' 1111" ............ ,........, .... JEFFERSON, LA 70121-4008 Taxpayer name 90293 FIRST DATA MERCI-IANT SVCS INC 5755 DTC BLVD 4TH FL GREENWOOD VILLAGE. CO 80111 Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $0.87 Gliel1f~Code Glient Property Code .PTb eMil J(C'alSlniJladel TIIX Dw Tolm Due 335713DEN P335713 P 2012 $0.87 $180 Base Ia)(<::ause # Judgment Date OOS LI BI PI D Status Indicators $0.64 CIient&i:O Code 14380710TAR Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $0.55 ,UP CIi_~GEQ Code .~ ;:r_lndudetl .~- 14389563TAR PI4389563TAR p 2016 $0.46 $0.63 1 4479384TAR PI4479384TAR p 2016 $0.09 $0.12 Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $0.53 Clt••~liQ Code 14384456TAR Cli~'~pertjli;~ P14384456TAR PTJJCmk Yeiiiliiiiuded P 2016 ... " ~»u.ej TIII(II Due ~ 1 . , -------------­ I Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators $0.46 1/11/2018 9:24:04 AM Page 9 of 12 Trophy Club Municipal Utility District No. 1 35 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # TaxP/Elyer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1570 GOSWICK CHERIE 542 TIMBER RIDGE DR TROPHY CLUB, TX 76262-5644 $0.37 C1ientGEO Code 70677DEN Client Propert)t Code R7677 D DEFE lTJJ:tt..·} reiiiiiiidtUletl R 2016 TIQCDr¥ $0.37 .' ''I.lJJIe $0.38 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 298 NORTHERN LEASING SYSTEMS INC $0.22 419 E MAIN ST STE 102 MIDDLETOWN, NY 10940-2552 Client GEO Code Client Propertyp* . P'l'DCotie Yeanlll£llIded. Tax Datt "-c~'tiiiiiiI)tie 314763DEN P314763 P 2012 $0.22 $0.45 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 63 PITNEY BOWES GLOBAL FINANCIAL $0.20 5310 CYPRESS CTR DR STE 110 TAMPA FL 33609-1041 Client.GEO Code Clie:nt:··rrop~ Code PTD Code Yean IltCladeti TotallJlle 14350063TAR PI4350063TAR p 2016 $0.20 $0.29 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 91052 BLOOMBERG LP 731 LEXINGTON AVE NEW YORK NY 10022-133 I Client hoperty.Code PTD Code Yelll'Sl.cluded P14460527TAR p 2015 $0.18 TOtal DUe , $0.25 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1636 FIRST AMERICAN TITLE CO $0.15 I FIRST AMERICAN WAY SANTA ANA, CA 92707-5913 ,",i~~" YetU$,«"~;:l;·i 2014 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1290 SONIFI SOLUTIONS INC $0.15 3900 W INNOVATION ST .<;ll~t~~~ ~1n.clu4ed TIIXDatt T.DaeSIOUX FALLS, SO 57107-7002 PI4381350TAR P 2015 $0.15 $0.21 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date OOS LI BI PI D Status Indicators 1163 FULL CIRCLE LOGISTICS $0.07 99 TROPHY CLUB DR TROPHY CLUB, TX 76262-5422 1/11/20189:24:06 AM Page 10 of 12 Trophy Club Municipal Utility District No. 1 36 of 164 January 16, 2018 - Regular Meeting Agenda Packet Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 91045 AMERIGAS PROPANE LP PO BOX 798 VALLEY FORGE. P A 19482-0798 $0.05 Client GEO Code . 14358803TAR Client Property Code P14358803TAR PTD Code YetJl'$lncbtt/etl P 2015 TuDue $0.05 TotlllDtu $0.07 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 9I049 NEOPOST USA INC $0.04 478 WHEELERS FARMS RD MILFORD. CT 06461-9105 Client OEO Code 14448870T AR Client Property Code PI4448870TAR PTD Code YetU'slndudetl' P 2015 TuDUl! $0.04 TotalDtu $0.06 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 1497 THIBAUL T LAWRENCE R & JEANNETTE E 111 LAKESIDE DR $0.02 Client GEO Code Client Property Code PTD CtHk QPAY Yean lachtded Tax Due Total Due ROANOKE, TX 76262-5231 203807DEN R23807 R 2016 $0.02 $0.03 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 112 HOT & CREAMY DONUTS 301 TROPHY LAKE DR UNIT 108 TROPHY CLUB. TX 76262-5237 $0.02 Client GBO Code 929538DEN Client Property Code P929538 PTD Code Year'S I1Ichtt/etl P 2016 Taxllue $0.02 TotlllDue $0.03 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 1611 FULLER FLORENCE S 6 ALAMOSA DR ROANOKE. TX 76262-5205 $0.01 Client GEO Code 71150DEN Client Property Code R71150 QPAY PTD Code YelUSlnchtded. R 2014 Tax Due '. ·lot11llhle $0.01 $0.02 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 90798 ROACH DAVID & SHARLA 4 OXFORD PL TROPHY CLUB, TX 76262-5129 $0.01 Client OEO Code 558563DEN Client Property Code R558563 PTD Code YeIU'S rncludetl R 2016 TaxDw $0.01 TotIIlDue $0.01 Taxpayer # Taxpayer name Base Tax Cause # Judgment Date 005 LI BI PI D Status Indicators 90475 CORNWALL KARIN $0.01 D DEFE 28 FAIR GREEN DR TROPHY CLUB, TX 76262-5629 Client<1EO <;ode Cl~t.Pr~",cock . .P1'D~i! . recur 1"t:IIIIed~:rt/". ,;j~~~ti:;':i ::1;(11111 ~d' '-:--~'--'" ,> ' ;'':KY':::'''l'',:::r-;'''' 116498DEN R1l6498 R 2016 $0.01 $0.01 1/11/20189:24:08 AM Page 11 of 12 Trophy Club Municipal Utility District No. 1 37 of 164 January 16, 2018 - Regular Meeting Agenda Packet 0 -l .... .......... ..... '" ..... Ol <.0 ~ <::; Ol » s:: '" '" ~ "~ <>.... Vl ..... N o-..... N Trophy Club Municipal Utility District No. 138 of 164January 16, 2018 - Regular Meeting Agenda Packet     ORDER NO. 2018-0116A   AN ORDER OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 CALLING AN ELECTION FOR DIRECTORS; AUTHORIZING EXECUTION OF A JOINT ELECTION AGREEMENT AND ELECTION SERVICES AGREEMENT; AND APPROVING OTHER MATTERS RELATED TO SAID ELECTION     WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is a conservation and reclamation district created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Natural Resource Conservation Commission, now the Texas Commission on Environmental Quality (“TCEQ”), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended;     WHEREAS, the Board of Directors of the District desires to conduct an election for the purpose of electing three (3) directors of Trophy Club Municipal Utility District No. 1 on May 5, 2018;     WHEREAS, Section 271.002 et seq. of the Election Code authorizes joint elections to be held by certain entities, including two or more political subdivisions in all or part of the same territory, provided the governing bodies enter into an agreement to hold the election jointly;     WHEREAS, pursuant to Section 271.003 of the Election Code, a regular county polling place may be used for a common polling place in a joint election, and the voters of a political subdivision may be served in a joint election by a common polling place outside the boundary of the political subdivision if the location can adequately and conveniently serve the affected voters and will facilitate the orderly conduct of the election;     WHEREAS, the District intends to enter into a joint election contract with one or more other political subdivisions conducting an election on May 5, 2018 and further intends to enter into contracts with Denton and Tarrant Counties to conduct said joint election; and     WHEREAS, the Board of Directors of the District, in an open, public meeting, proper notice of which has been given as required by law, has given consideration to calling a director election for May 5, 2018 and authorizing execution of agreements with Denton County and Tarrant County for purpose of conducting the election.     NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT:     Trophy Club Municipal Utility District No. 1 39 of 164 January 16, 2018 - Regular Meeting Agenda Packet     Section 1: The matters and facts set out in the preamble of this Order are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2: An election for three (3) directors shall be held between the hours of 7:00 a.m. and 7:00 p.m., on the 5th day of May, 2018. The polling places designated for holding the election shall be the polling places determined by Denton County and Tarrant County to serve the counties’ respective regular election precincts within the District, which polling places are hereby approved, established and designated, and shall be attached hereto as Exhibit “A”. Such exhibit shall be revised and finalized to incorporate any changes to the polling places established by the Elections Administrators of Denton County or Tarrant County. After duly considering the requirements of the Texas Election Code, the Board hereby finds said polling places to be proper places for conducting the election. The Board of Directors specifically finds that the locations can adequately and conveniently serve the affected voters of the District and will facilitate the orderly conduct of the election.   Section 3: The Elections Administrators of Denton County and Tarrant County are conducting the election pursuant to a contract for election services between the District and such Election Administrators as authorized under Section 31.092 of the Texas Election Code (the “Election Services Agreements”). The election shall be held as a joint election pursuant to Chapter 271 of the Texas Election Code and a joint election agreement to be entered into between the District and the other eligible participating entities that are holding an election on May 5, 2018 (the “Joint Election Agreement”). The Board of Directors hereby authorizes and directs its General Manager to enter into the Election Services Agreements and Joint Election Agreement on behalf of the District.     Section 4: The boundaries of the District are hereby established and shall constitute one election precinct for purposes of the election. The District’s boundaries overlap areas within both Denton and Tarrant County and the District will therefore contract for election services with both counties to serve qualified voters of the District that reside in each county. The Denton County Elections Administrator is appointed to serve as the District’s Election Officer to conduct the election for qualified voters of the District residing in Denton County, and the Tarrant County Elections Administrator is appointed to serve as the District’s Election Officer to conduct the election for qualified District voters residing in Tarrant County.     Section 5: Early voting shall be conducted at the early voting polling locations established by Denton County and Tarrant County, which early polling locations are hereby approved, established and designated and shall be attached hereto as Exhibit “B”. These places shall remain open on the dates and at the times established by Denton County and Tarrant County, which times and dates shall also be set forth in Exhibit “B”. The Denton and Tarrant County Election Administrators are hereby appointed as the Early Voting Clerks for their Trophy Club Municipal Utility District No. 1 40 of 164 January 16, 2018 - Regular Meeting Agenda Packet     respective county. Early voting shall commence on the 12th day before the election (April 23, 2018) and continue through the 4th day preceding the date of the election (May 1, 2018) as provided by the provisions of the Texas Election Code. The Early Voting Clerks’ mailing addresses to which ballot applications and ballots to be voted by mail may be sent in are as follows:     For Qualified Voters of the District residing in Denton County: Early Voting Clerk Denton County Elections Administration 701 Kimberly Drive, Suite A101 Denton, Texas 76208   For Qualified Voters of the District residing in Tarrant County: Early Voting Clerk Tarrant County Elections Administration 2700 Premier Street Fort Worth, Texas 76111 Section 6: All resident, qualified electors of the District shall be entitled to vote at the election. Qualified electors of the District residing in Denton County shall vote at locations established by Denton County. Qualified electors of the District residing in Tarrant County shall vote at locations established by Tarrant County.   Section 7: At said election, there shall be submitted to the duly qualified resident electors of the District the matter of electing three (3) directors by submitting the names of those persons who have duly and legally filed as candidates for such office. The purpose of the election is to elect a Director to Place Three (3) for a four (4) year term, elect a Director to Place Four (4) for a four (4) year term, and elect a Director to Place Five (5) for a four (4) year term. Directors shall be elected by plurality vote by place number.   Section 8: Written application to have a person’s name printed on the ballot as a candidate for the office of Director of the District must be signed by the candidate and must be received by the District Secretary no later than 5:00 p.m. on February 16, 2018. No person’s name shall be placed on the ballot unless he or she is a least eighteen (18) years of age, a resident citizen of the State of Texas, owns land subject to taxation in the District, or is a qualified voter within the District. No person who is disqualified by the laws of the State of Texas from serving as a director of this District shall have his or her name placed on the ballot. The District Secretary is authorized to determine the qualifications of candidates for office. Any person not satisfied with the District Secretary’s ruling may appeal the decision to the Board of Directors of the Trophy Club Municipal Utility District No. 1 41 of 164 January 16, 2018 - Regular Meeting Agenda Packet     District. Blank applications and copies of this Order may be obtained from the District Secretary, who is hereby designated as the District’s agent for purposes of the May 5, 2018 election.   Section 9: The election shall be held and conducted and returns made to this Board of Directors in accordance with the Texas Election Code, as modified by Chapters 49 and 54, Texas Water Code.   Section 10: Immediately after the election, the officers holding same shall make and deliver the returns of the results thereof to the District Secretary, who shall safely keep them and deliver same to the Board of Directors at its next meeting, at which time the Board shall timely canvass said returns and declare the results of said election.   Section 11: The District Secretary is hereby directed to cause notice of the election to be published in English, Spanish and Vietnamese on the District website no earlier than April 5, 2018 and no later than April 25, 2018 and to post a copy of the notice of election on the bulletin board used for posting notices of District meetings not later than April 16, 2018.   Section 12: The rate of pay for judges and clerks of the election shall be determined by the Denton County Election Officer and the Tarrant County Election Officer in compliance with the Texas Election Code. Section 13: The District's President, Secretary, General Manager, and legal counsel are authorized and directed to take any action necessary to carry out the provisions of this Order, including entering into one or more joint election agreements with other political subdivisions in Denton and Tarrant Counties, Texas that will be conducting an election on May 5, 2018 at the locations identified on the exhibits attached hereto.           Trophy Club Municipal Utility District No. 1 42 of 164 January 16, 2018 - Regular Meeting Agenda Packet     ADOPTED, PASSED AND APPROVED the 16th day of January, 2018.                       ATTEST: Kevin R. Carr, President Board of Directors       William C. Rose, Secretary Board of Directors               Laurie Slaght, District Secretary (SEAL) Trophy Club Municipal Utility District No. 1 43 of 164 January 16, 2018 - Regular Meeting Agenda Packet     Exhibit “A” Election Precincts and Polling Locations Trophy Club Municipal Utility District No. 1 44 of 164 January 16, 2018 - Regular Meeting Agenda Packet     Exhibit “B” Early Voting Locations and Times Trophy Club Municipal Utility District No. 1 45 of 164 January 16, 2018 - Regular Meeting Agenda Packet NOTICE OF APPOINTMENT OF AGENT FOR MAY 5, 2018 DIRECTOR ELECTION TO: ALL PERSONS INTERESTED IN THE DIRECTOR ELECTION OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Notice is hereby given that the undersigned, Secretary of the Board of Directors of Trophy Club Municipal Utility District No. 1 (the “District”), acting pursuant to Section 31.123, Texas Election Code, appoints Laurie Slaght, District Secretary as the duly authorized agent (the “Agent”) for all purposes for the May 5, 2018 Director Election. The office for the Agent is located at 100 Municipal Drive, Trophy Club, Texas 76262, and the telephone number for the Agent is (682) 831-4600. The Agent shall be available for election duties at least three hours each day, during regular office hours on regular business days, beginning on March 16, 2017 the 50th day before Election Day and not ending earlier than June 14, 2018 the 40th day after Election Day. The Agent shall maintain in the Agent’s office the documents, records, and other papers relating to the election that: 1. by law are placed in the custody of the authority appointing the agent; and 2. are public information. The Agent shall receive any personally delivered document relating to the election that the appointing authority is authorized or required to receive; and make available for inspection and copying, in accordance with applicable regulations, the documents, records, and other papers that are required to be maintained in the Agent’s office. The Agent may perform any other ministerial duties in connection with the election that may lawfully be performed by an employee of the District. This Notice shall be posted on the bulletin board used for posting meetings of the District’s Board of Directors and shall remain continuously posted during the minimum period for maintaining the Agent’s office. _____________________________ William C. Rose Secretary, Board of Directors Trophy Club Municipal Utility District No. 1 Trophy Club Municipal Utility District No. 1 46 of 164 January 16, 2018 - Regular Meeting Agenda Packet       Trophy Club Municipal Utility District No. 1    Date:  1/16/2018  To:  Board of Directors  From:  John Robert Carman  Subject: Lease‐Purchase Agreement for the GPM Equipment Solutions ECO900    Truck mounted vacuums and high pressure water supply delivery systems are used for both  hydro‐excavation in response to main breaks in the water system and for cleaning sewers in the  wastewater collection system.  A replacement for our combination truck was budgeted in this fiscal year.  Staff reviewed three  different models available through BuyBoard, a government purchasing cooperative.   GPM Equipment Solutions ECO900    $ 358,600.40   GapVax      $ 408,397.26   Vaccon       $ 390,255.00  While the GPM Equipment Solutions ECO900 was the consensus favorite of the staff before  configurations were priced, it turned out to be the lowest cost also.  To minimize rate impacts, the staff chose to finance the vehicle over a 5 year period using a  lease‐purchase agreement.  The agreement and the truck specification are in your packet.  Staff recommends that the Board approve the lease –purchase agreement and direct the  General Manager to execute agreement.    Trophy Club Municipal Utility District No. 1 47 of 164 January 16, 2018 - Regular Meeting Agenda Packet RESOLUTION NO. 2018-0116A A RESOLUTION OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 REGARDING A LEASE PURCHASE AGREEMENT FOR THE PURPOSE OF FINANCING A SEWER TRUCK. WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) desires to enter into that certain Lease-Purchase Agreement No. 8076, by and between Trophy Club Municipal Utility District No. 1 and Government Capital Corporation, for the purpose of financing a Sewer Truck”. The District Desires to designate this agreement as a qualified tax exempt obligation of the District for the purposes of Section 265(b) (3) of the Internal Revenue Code of 1986, as amended. The District desires to designate John Carman, General Manager as an authorized signor of the Agreement. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the District enters into a Lease Purchase Agreement with Government Capital Corporation for the purpose of financing a sewer truck. Section 2. That the Lease Purchase Agreement dated as of February 1, 2018 by and between Trophy Club Municipal Utility District No. 1 and Government Capital Corporation is designated by the District as a “qualified tax exempt obligation” for the purposes of Section 265 (b) (3) of the Internal Revenue Code of 1986, as amended. Section 3. That the District designates John Carman, General Manager, as an authorized signor of the Lease-Purchase Agreement No. 8076 by and between Trophy Club Municipal Utility District No. 1 and Government Capital Corporation. RESOLVED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1 on the 16th day of January, 2018. Lessee: Trophy Club Municipal Utility District No. 1 Witness Signature: ______________________________ Kevin R. Carr, Board President ______________________________ (SEAL) William C. Rose, Secretary/Treasurer ______________________________ Laurie Slaght, District Secretary Trophy Club Municipal Utility District No. 1 48 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 149 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 150 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 151 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 152 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 153 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 154 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 155 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 156 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 157 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 158 of 164January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 159 of 164January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET DECEMBER 2017 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 762,115 PREPAID EXPENSES 11,429 ADVALOREM PROPERTY TAXES RECEIVABLE 473,804 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,247,348 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 473,804 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 473,804 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 251,291 TOTAL FUND BALANCE 773,544 TOTAL LIABILITIES AND FUND BALANCE 1,247,348 Trophy Club Municipal Utility District No. 1 60 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 20:22 01/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept.Department: Fire Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb.Month Total Budget Budget 122-40010-000-000 Property Taxes/MUD Fire 1,054,433.00- 1,054,433.00-567,258.11- 614,333.82-58.262 440,099.18- 122-40011-000-000 Property Taxes/Fire-Delinquent 323.08- 2,577.30-2,577.30 122-40020-000-000 Property Taxes/Fire P&I 138.42-476.49-476.49 Subtotal:1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Program number:1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Department number: Fire Revenues 1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00-567,719.61- 617,387.61-58.552 437,045.39- Trophy Club Municipal Utility District No. 1 61 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 20:22 01/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-55080-045-000 Maintenance & Repairs 1,490.49 1,490.49- Subtotal: 1,490.49 1,490.49- 122-60030-045-000 Rent And/Or Usage 218,954.00 218,954.00 218,954.00 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.87 3,809.61 21.165 14,190.39 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 152,227.50 25.000 456,682.50 Subtotal: 845,864.00 845,864.00 52,012.37 156,037.11 18.447 689,826.89 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 81,420.00 81,420.00 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,054,433.00 1,054,433.00 52,012.37 366,096.20 34.720 688,336.80 Department number: Fire 1,054,433.00 1,054,433.00 52,012.37 366,096.20 34.720 688,336.80 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.37 366,096.20 34.720 688,336.80 Fund number: 122 Trophy Club MUD Fire Dept. 515,707.24- 251,291.41- 251,291.41 Trophy Club Municipal Utility District No. 1 62 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40010-000-000 Property Taxes/MUD Fire 576 12/01/2017 Property Taxes (47,075.71) (802.26) (47,877.97) GL 577 12/04/2017 Property Taxes (2,499.45) (50,377.42) GL 578 12/05/2017 Property Taxes (2,849.13) (53,226.55) GL 579 12/06/2017 Property Taxes (6,625.57) (59,852.12) GL 580 12/07/2017 Property Taxes (3,234.39) (63,086.51) GL 617 12/07/2017 Property Taxes (3,234.39) (66,320.90) GL 618 12/07/2017 Reverse Property Taxes 580 3,234.39 (63,086.51) GL 581 12/08/2017 Property Taxes (5,640.99) (68,727.50) GL 582 12/11/2017 Property Taxes (8,531.98) (77,259.48) GL 583 12/12/2017 Property Taxes (7,685.37) (84,944.85) GL 610 12/12/2017 Property Taxes (7,685.37) (92,630.22) GL 611 12/12/2017 Reverse Property Tax 583 7,685.37 (84,944.85) GL 584 12/13/2017 Property Taxes (7,506.66) (92,451.51) GL 585 12/14/2017 Property Taxes (7,223.89) (99,675.40) GL 586 12/15/2017 Property Taxes (6,336.82) (106,012.22) GL 587 12/18/2017 Property Taxes (249,349.46) (355,361.68) GL 614 12/18/2017 Property Taxes (249,349.46) (604,711.14) GL 615 12/18/2017 Reverse Property Tax 587 249,349.46 (355,361.68) GL 588 12/19/2017 Property Taxes (4,865.25) (360,226.93) GL 589 12/20/2017 Property Taxes (11,675.27) (371,902.20) GL 590 12/21/2017 Property Taxes (3,990.48) (375,892.68) GL 591 12/22/2017 Property Taxes (21,870.81) (397,763.49) GL 612 12/22/2017 Property Taxes (21,870.81) (419,634.30) GL 613 12/22/2017 Reverse Property Tax 591 21,870.81 (397,763.49) GL 592 12/27/2017 Property Taxes (105,227.68) (502,991.17) GL 593 12/28/2017 Property Taxes (92,941.73) (595,932.90) GL 594 12/29/2017 Property Taxes (18,400.92) (614,333.82) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (567,258.11) (614,333.82) ** (1,054,433.00) Budgeted (440,099.18) Remaining 58 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 577 12/04/2017 Property Taxes (2,254.22) (25.01) (2,279.23) GL 578 12/05/2017 Property Taxes (13.40) (2,292.63) GL 579 12/06/2017 Property Taxes (4.63) (2,297.26) GL 580 12/07/2017 Property Taxes (.01) (2,297.27) GL 617 12/07/2017 Property Taxes (.01) (2,297.28) GL 618 12/07/2017 Reverse Property Taxes 580 .01 (2,297.27) GL 585 12/14/2017 Property Taxes 144.22 (2,153.05) GL 589 12/20/2017 Property Taxes (77.43) (2,230.48) GL 591 12/22/2017 Property Taxes (256.19) (2,486.67) GL Trophy Club Municipal Utility District No. 1 63 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept.Department: Fire Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 612 12/22/2017 Property Taxes (2,254.22)(256.19) (2,742.86)GL 613 12/22/2017 Reverse Property Tax 591 256.19 (2,486.67)GL 592 12/27/2017 Property Taxes (90.63) (2,577.30)GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals:(323.08) (2,577.30) ** .00 Budgeted 2,577.30 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 577 12/04/2017 Property Taxes (338.07)(11.76)(349.83)GL 578 12/05/2017 Property Taxes (4.01)(353.84)GL 579 12/06/2017 Property Taxes (1.07)(354.91)GL 582 12/11/2017 Property Taxes (3.07)(357.98)GL 587 12/18/2017 Property Taxes (17.74)(375.72)GL 614 12/18/2017 Property Taxes (17.73)(393.45)GL 615 12/18/2017 Reverse Property Tax 587 17.74 (375.71)GL 589 12/20/2017 Property Taxes (17.89)(393.60)GL 591 12/22/2017 Property Taxes (58.92)(452.52)GL 612 12/22/2017 Property Taxes (58.92)(511.44)GL 613 12/22/2017 Reverse Property Tax 591 58.92 (452.52)GL 592 12/27/2017 Property Taxes (23.73)(476.25)GL 593 12/28/2017 Property Taxes (.24)(476.49)GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals:(138.42)(476.49) ** .00 Budgeted 476.49 Remaining 0 % Used Department Totals: -----------------------------------(617,387.61) ** (567,719.61) Monthly Total (1,054,433.00) Budgeted (437,045.39) Remaining 59 % Used Trophy Club Municipal Utility District No. 1 64 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1,490.49 .00 1,490.49 _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: .00 1,490.49 ** .00 Budgeted (1,490.49) Remaining 0 % Used Account: 122-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 218,954.00 Budgeted 218,954.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 234 12/01/2017 Insurance/Wrk Comp Exp Dec 2,539.74 1,269.87 3,809.61 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.87 3,809.61 ** 18,000.00 Budgeted 14,190.39 Remaining 21 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 422 12/08/2017 Dec A/P Dec Fire Admin 101,485.00 50,742.50 152,227.50 TOWN OF TROPHY CLUB 3788 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 152,227.50 ** 608,910.00 Budgeted 456,682.50 Remaining 25 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 366,096.20 ** 52,012.37 Monthly Total 1,054,433.00 Budgeted 688,336.80 Remaining 35 % Used Trophy Club Municipal Utility District No. 1 65 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 122 Totals: ----------------------------------- (251,291.41) (515,707.24) Monthly Total .00 Budgeted 251,291.41 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 66 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - O&M BALANCE SHEET DECEMBER 2017 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,654,954 - 1,654,954 CASH IN BANK-SAVINGS-CASH RESERVE 581,493 - 581,493 CD-BANK OF THE WEST/THB DEPOSIT 35,316 - 35,316 INVESTMENTS-MONEY MARKET-BANK OF THE WEST 714,332 - 714,332 INVESTMENTS-TEXPOOL 1,304,616 596,426 1,901,042 PREPAID EXPENSES 79,754 - 79,754 ADVALOREM PROPERTY TAXES RECEIVABLE 54,267 - 54,267 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,097,819 - 1,097,819 TOTAL ASSETS 5,523,150 596,426 6,119,576 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 54,267 - 54,267 ACCOUNTS AND OTHER PAYABLES 633,955 - 633,955 CUSTOMER DEPOSITS 314,100 - 314,100 - TOTAL LIABILITIES 1,002,322 - 1,002,322 FUND BALANCE NON-SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,778,760 1,778,760 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 180,000 180,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 120,000 120,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 67,805 67,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 228,621 228,621 UNASSIGNED FUND BALANCE 2,368,122 - 2,368,122 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 370,461 - 370,461 - TOTAL FUND BALANCE 4,520,829 596,426 5,117,254 TOTAL LIABILITIES AND FUND BALANCE 5,523,150 596,426 6,119,576 Trophy Club Municipal Utility District No. 1 67 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 120,950.00- 120,950.00- 65,065.41- 70,465.06- 58.260 50,484.94- 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 33.53- 169.68- 84.840 30.32- 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- 13.85- 35.84- 17.920 164.16- 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 65,112.79- 70,670.58- 23.621 228,518.42- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 357,013.62- 1,289,167.00- 19.944 5,174,852.00- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 235,176.30- 706,218.09- 23.714 2,271,848.91- 135-47025-000-000 Penalties 106,279.00- 106,279.00- 14,594.33- 37,694.57- 35.468 68,584.43- 135-47030-000-000 Service Charges 21,350.00- 21,350.00- 1,400.00- 3,550.00- 16.628 17,800.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 600.00- 1,050.00- 70.000 450.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 1,000.00- 2,350.00- 52.222 2,150.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 8,570.40- 9,117.60- 15.196 50,882.40- Subtotal: 9,635,715.00- 9,635,715.00- 618,354.65- 2,049,147.26- 21.266 7,586,567.74- 135-49010-000-000 Interest Income 12,000.00- 12,000.00- 3,355.22- 8,510.13- 70.918 3,489.87- 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 978.81- 2,868.15- 26.251 8,057.85- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 2,000.00- 2,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 3,260.76- 6,347.76- 34.918 11,831.24- 135-49900-000-000 Miscellaneous Income 5,000.00- 5,000.00- 1,787.51- 5,463.23- 109.265 463.23 135-49901-000-000 Records Management Revenue 20.00- 20.00- 20.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 315,125.00- 9,965.63- 24,939.26- 7.914 290,185.74- Program number: 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- Department number: Revenues 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- Revenues Subtotal ----------- 10,250,029.00- 10,250,029.00- 693,433.07- 2,144,757.10- 20.924 8,105,271.90- Trophy Club Municipal Utility District No. 1 68 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 274,279.00 274,279.00 22,451.76 47,819.61 17.435 226,459.39 135-50010-010-000 Overtime 20,000.00 20,000.00 1,324.39 1,935.33 9.677 18,064.67 135-50016-010-000 Longevity 3,425.00 3,425.00 3,310.00 96.642 115.00 135-50017-010-000 Certification 3,300.00 3,300.00 150.00 550.00 16.667 2,750.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,213.17 6,369.34 22.876 21,473.66 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 1,889.76 6,850.39 13.124 45,345.61 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 205.93 711.62 13.733 4,470.38 135-50028-010-000 Vision Insurance 994.00 994.00 40.17 143.14 14.400 850.86 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 147.20 639.97 21.461 2,342.03 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,476.62 3,298.75 17.676 15,363.25 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 345.33 771.48 17.674 3,593.52 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 1.25 8.68 .804 1,071.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.92 2,699.76 22.775 9,154.24 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 163.05 163.05 81.525 36.95 135-50070-010-000 Employee Relations 300.00 300.00 18.99 6.330 281.01 Subtotal: 426,662.00 426,662.00 31,308.55 75,290.11 17.646 351,371.89 135-55005-010-000 Engineering 275,000.00 275,000.00 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 14,394.55 18,477.92 18.478 81,522.08 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 4,000.00 4,000.00 95.71 1,267.13 31.678 2,732.87 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 200.00 1,330.74 24.195 4,169.26 Subtotal: 391,000.00 391,000.00 14,690.26 21,075.79 5.390 369,924.21 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 320.79 640.34 13.624 4,059.66 135-60020-010-000 Electricity 175,356.00 175,356.00 11,225.68 38,530.00 21.972 136,826.00 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 2,785.00 2,785.00 2,785.00 135-60090-010-000 Safety Program 400.00 400.00 8.36 2.090 391.64 135-60100-010-000 Travel & per diem 1,735.00 1,735.00 87.48 5.042 1,647.52 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 55,176.00 55,176.00 7,685.65 13.929 47,490.35 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 166,739.52 374,798.62 13.276 2,448,371.38 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 214.70 7.157 2,785.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 2,250.00 15.254 12,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 25,280.31 75,840.93 27.273 202,243.07 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 12,249.00 25.000 36,747.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 5,019.66 200.786 2,519.66- Trophy Club Municipal Utility District No. 1 69 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,613,852.00 212,668.96 517,324.74 14.315 3,096,527.26 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 777.27 2,196.98 14.647 12,803.02 135-65010-010-000 Uniforms 4,488.00 4,488.00 332.42 829.64 18.486 3,658.36 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,104.88 3,712.54 18.563 16,287.46 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 50,000.00 50,000.00 50,000.00 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 84,000.00 Subtotal: 175,688.00 175,688.00 2,214.57 6,739.16 3.836 168,948.84 135-69005-010-000 Capital Outlays 810,012.00 810,012.00 9,573.61 63,982.86 7.899 746,029.14 135-69008-010-000 Short Term Debt-Principal 38,731.00 38,731.00 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 5,713.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 118,775.00 118,775.00 41,944.38 107,864.38 90.814 10,910.62 Subtotal: 1,048,231.00 1,048,231.00 51,517.99 246,847.24 23.549 801,383.76 Program number: 5,655,433.00 5,655,433.00 312,400.33 867,277.04 15.335 4,788,155.96 Trophy Club Municipal Utility District No. 1 70 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55135-010-001 Lab Analysis for PID 2,000.00 2,000.00 80.00 376.19 18.810 1,623.81 Subtotal: 2,000.00 2,000.00 80.00 376.19 18.810 1,623.81 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 80.00 376.19 18.810 1,623.81 Department number: Water 5,657,433.00 5,657,433.00 312,480.33 867,653.23 15.337 4,789,779.77 Trophy Club Municipal Utility District No. 1 71 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb.Month Total Budget Budget 135-50005-020-000 Salaries & Wages 410,866.00 410,866.00 46,019.02 92,099.60 22.416 318,766.40 135-50010-020-000 Overtime 30,000.00 30,000.00 2,691.33 6,688.37 22.295 23,311.63 135-50016-020-000 Longevity 7,415.00 7,415.00 7,415.00 100.000 135-50017-020-000 Certification 8,400.00 8,400.00 700.00 2,025.00 24.107 6,375.00 135-50020-020-000 Retirement 42,243.00 42,243.00 4,570.46 11,475.54 27.166 30,767.46 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 4,710.20 14,130.60 22.727 48,044.40 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 399.32 1,197.96 22.727 4,073.04 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 84.33 252.99 22.710 861.01 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 361.15 1,149.43 26.850 3,131.57 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 2,933.90 6,374.14 22.512 21,939.86 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 686.16 1,490.73 22.512 5,131.27 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 4,044.00 22.479 13,946.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 300.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal:626,601.00 626,601.00 64,503.87 148,343.36 23.674 478,257.64 135-55070-020-000 Independent Labor 20,550.00 20,550.00 20,550.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 714.10 7,070.32 8.212 79,029.68 135-55085-020-000 Generator Maint. and Repair 14,000.00 14,000.00 28.78 .206 13,971.22 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 179.47 2,828.19 35.352 5,171.81 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 500.00 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 7,213.77 15,113.25 25.189 44,886.75 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,356.00 10,183.82 33.946 19,816.18 Subtotal:219,150.00 219,150.00 10,463.34 35,224.36 16.073 183,925.64 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.81 763.37 16.242 3,936.63 135-60020-020-000 Electricity 266,709.00 266,709.00 16,458.64 43,454.93 16.293 223,254.07 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 300.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 5,677.00 135-60090-020-000 Safety Program 550.00 550.00 8.37 1.522 541.63 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 23.17 1.417 1,611.83 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 5,000.00 5,000.00 5,000.00 135-60135-020-000 TCEQ Fees & Permits 85,000.00 85,000.00 4,711.25- 30,022.52 35.321 54,977.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 4,000.00 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 1,770.00 15.259 9,830.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 11,094.81 33,284.43 27.273 88,758.57 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 54,430.72 163,292.16 27.273 435,445.84 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 30,834.00 25.000 92,502.00 Trophy Club Municipal Utility District No. 1 72 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 4,000.00 Subtotal: 1,438,938.00 1,438,938.00 87,932.73 303,452.95 21.089 1,135,485.05 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 653.58 2,187.19 17.498 10,312.81 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,614.63 36.211 2,844.37 135-65030-020-000 Chemicals 27,500.00 27,500.00 660.48 665.83 2.421 26,834.17 135-65035-020-000 Small Tools 1,000.00 1,000.00 93.65 341.41 34.141 658.59 135-65040-020-000 Safety Equipment 750.00 750.00 750.00 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,513.08 3,649.71 26.069 10,350.29 Subtotal: 60,209.00 60,209.00 2,920.79 8,458.77 14.049 51,750.23 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 1,657.50 11,528.49 2.106 535,798.51 135-69008-020-000 Short Term Debt-Principal 51,342.00 51,342.00 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 7,573.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 636,242.00 1,657.50 41,528.49 6.527 594,713.51 Program number: 2,981,140.00 2,981,140.00 167,478.23 537,007.93 18.014 2,444,132.07 Department number: Wastewater 2,981,140.00 2,981,140.00 167,478.23 537,007.93 18.014 2,444,132.07 Trophy Club Municipal Utility District No. 1 73 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50045-026-000 Workman's Compensation 30.00 30.00 2.42 7.26 24.200 22.74 Subtotal: 30.00 30.00 2.42 7.26 24.200 22.74 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 600.00 600.00 650.00 108.333 50.00- 135-60075-026-000 Meetings 1,200.00 1,200.00 1,200.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 445.00 1,135.00 28.375 2,865.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,021.73 1,021.73 51.087 978.27 Subtotal: 12,950.00 12,950.00 1,466.73 2,806.73 21.674 10,143.27 Program number: 12,980.00 12,980.00 1,469.15 2,813.99 21.679 10,166.01 Department number: Board of Directors 12,980.00 12,980.00 1,469.15 2,813.99 21.679 10,166.01 Trophy Club Municipal Utility District No. 1 74 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 432,863.00 432,863.00 58,622.84 105,210.54 24.306 327,652.46 135-50010-030-000 Overtime 2,000.00 2,000.00 168.22 342.42 17.121 1,657.58 135-50016-030-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50020-030-000 Retirement 40,553.00 40,553.00 5,438.16 12,398.73 30.574 28,154.27 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 3,822.05 10,757.49 16.945 52,727.51 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 348.90 990.40 18.001 4,511.60 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 75.82 213.88 18.234 959.12 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 447.01 1,107.66 21.895 3,951.34 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 3,557.84 6,540.23 24.062 20,640.77 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 832.08 1,529.56 24.061 4,827.44 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 6.73 11.77 .934 1,248.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 370.50 24.232 1,158.50 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 124.95 24.990 375.05 135-50070-030-000 Employee Relations 4,960.00 4,960.00 1,991.81 2,306.49 46.502 2,653.51 Subtotal: 595,970.00 595,970.00 75,434.96 145,452.12 24.406 450,517.88 135-55030-030-000 Software & Support 78,391.00 78,391.00 9,784.89 22,246.09 28.378 56,144.91 135-55070-030-000 Independent Labor 154,000.00 154,000.00 8,934.63 35,707.42 23.187 118,292.58 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 406.14 568.35 4.060 13,431.65 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55100-030-000 Building Maint & Supplies 360.00 360.00 360.00- 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 672.74 1,158.89 11.589 8,841.11 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 56,475.00 89.183 6,850.00 135-55165-030-000 Collection Fees 200.00 200.00 200.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 1,230.52 1,804.45 20.049 7,195.55 Subtotal: 338,916.00 338,916.00 21,388.92 118,320.20 34.911 220,595.80 135-60005-030-000 Telephone 27,300.00 27,300.00 1,223.99 2,743.21 10.048 24,556.79 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 361.75 849.74 21.244 3,150.26 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 644.52 3.964 15,616.48 135-60025-030-000 Water 2,500.00 2,500.00 58.10 174.30 6.972 2,325.70 135-60030-030-000 Rent And/Or Usage 616.40 616.40 616.40- 135-60035-030-000 Postage 30,000.00 30,000.00 4,680.20 6,383.11 21.277 23,616.89 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,293.01 16,454.30 29.615 39,105.70 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 56,000.00 56,000.00 6,100.36 18,301.08 32.681 37,698.92 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 1,600.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 35.00 135.00 2.250 5,865.00 135-60075-030-000 Meetings 400.00 400.00 48.62 12.155 351.38 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 7,600.00 7,600.00 2,608.00 34.316 4,992.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 363.84 440.52 9.018 4,444.48 Trophy Club Municipal Utility District No. 1 75 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 100.00 145.00 3.222 4,355.00 135-60125-030-000 Advertising 2,500.00 2,500.00 2,500.00 135-60235-030-000 Security 2,700.00 2,700.00 2,700.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 249,506.00 18,832.65 49,755.79 19.942 199,750.21 135-65010-030-000 Uniforms 700.00 700.00 700.00 135-65055-030-000 Hardware 7,420.00 7,420.00 597.95 8.059 6,822.05 135-65085-030-000 Office Supplies 7,000.00 7,000.00 142.79 1,962.80 28.040 5,037.20 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 98.06 1,658.06 82.903 341.94 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 493.61 1,157.28 28.932 2,842.72 135-65105-030-000 Printing 4,000.00 4,000.00 144.00 3.600 3,856.00 Subtotal: 25,120.00 25,120.00 734.46 5,520.09 21.975 19,599.91 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 7,841.00 60.315 5,159.00 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 230.66 644.67 14.015 3,955.33 Subtotal: 17,600.00 17,600.00 230.66 8,485.67 48.214 9,114.33 Program number: 1,227,112.00 1,227,112.00 116,621.65 327,533.87 26.691 899,578.13 Department number: Administration 1,227,112.00 1,227,112.00 116,621.65 327,533.87 26.691 899,578.13 Trophy Club Municipal Utility District No. 1 76 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 20:22 01/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 137,000.00 137,000.00 9,019.30 17,258.99 12.598 119,741.01 135-55055-039-000 Auditing 24,500.00 24,500.00 14,400.00 58.776 10,100.00 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 4,660.18 40.714 6,785.82 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Program number: 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Department number: Non Departmental 176,746.00 176,746.00 13,999.57 39,287.57 22.228 137,458.43 Expenditures Subtotal ----------- 10,055,411.00 10,055,411.00 612,048.93 1,774,296.59 17.645 8,281,114.41 Fund number: 135 MUD 1 General Fund 194,618.00- 194,618.00- 81,384.14- 370,460.51- 190.353 175,842.51 Trophy Club Municipal Utility District No. 1 77 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 20:22 01/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 Trophy Club Municipal Utility District No. 1 78 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 576 12/01/2017 Property Taxes (5,399.65) (92.02) (5,491.67) GL 577 12/04/2017 Property Taxes (286.69) (5,778.36) GL 578 12/05/2017 Property Taxes (326.80) (6,105.16) GL 579 12/06/2017 Property Taxes (759.97) (6,865.13) GL 580 12/07/2017 Property Taxes (370.99) (7,236.12) GL 617 12/07/2017 Property Taxes (370.99) (7,607.11) GL 618 12/07/2017 Reverse Property Taxes 580 370.99 (7,236.12) GL 581 12/08/2017 Property Taxes (647.03) (7,883.15) GL 582 12/11/2017 Property Taxes (978.63) (8,861.78) GL 583 12/12/2017 Property Taxes (881.52) (9,743.30) GL 610 12/12/2017 Property Taxes (881.52) (10,624.82) GL 611 12/12/2017 Reverse Property Tax 583 881.52 (9,743.30) GL 584 12/13/2017 Property Taxes (861.03) (10,604.33) GL 585 12/14/2017 Property Taxes (828.59) (11,432.92) GL 586 12/15/2017 Property Taxes (726.84) (12,159.76) GL 587 12/18/2017 Property Taxes (28,600.79) (40,760.55) GL 614 12/18/2017 Property Taxes (28,600.78) (69,361.33) GL 615 12/18/2017 Reverse Property Tax 587 28,600.79 (40,760.54) GL 588 12/19/2017 Property Taxes (558.05) (41,318.59) GL 589 12/20/2017 Property Taxes (1,339.17) (42,657.76) GL 590 12/21/2017 Property Taxes (457.72) (43,115.48) GL 591 12/22/2017 Property Taxes (2,508.62) (45,624.10) GL 612 12/22/2017 Property Taxes (2,508.62) (48,132.72) GL 613 12/22/2017 Reverse Property Tax 591 2,508.62 (45,624.10) GL 592 12/27/2017 Property Taxes (12,069.79) (57,693.89) GL 593 12/28/2017 Property Taxes (10,660.56) (68,354.45) GL 594 12/29/2017 Property Taxes (2,110.61) (70,465.06) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (65,065.41) (70,465.06) ** (120,950.00) Budgeted (50,484.94) Remaining 58 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 577 12/04/2017 Property Taxes (136.15) (4.81) (140.96) GL 578 12/05/2017 Property Taxes (1.64) (142.60) GL 579 12/06/2017 Property Taxes (.27) (142.87) GL 585 12/14/2017 Property Taxes 8.48 (134.39) GL 589 12/20/2017 Property Taxes (14.89) (149.28) GL 591 12/22/2017 Property Taxes (15.07) (164.35) GL 612 12/22/2017 Property Taxes (15.07) (179.42) GL 613 12/22/2017 Reverse Property Tax 591 15.07 (164.35) GL 592 12/27/2017 Property Taxes (5.33) (169.68) GL Trophy Club Municipal Utility District No. 1 79 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (33.53) (169.68) ** (200.00) Budgeted (30.32) Remaining 85 % Used Account: 135-40015-000-000 Property Taxes/P & I 577 12/04/2017 Property Taxes (21.99) (2.24) (24.23) GL 578 12/05/2017 Property Taxes (.62) (24.85) GL 579 12/06/2017 Property Taxes (.06) (24.91) GL 582 12/11/2017 Property Taxes (.35) (25.26) GL 587 12/18/2017 Property Taxes (2.03) (27.29) GL 614 12/18/2017 Property Taxes (2.04) (29.33) GL 615 12/18/2017 Reverse Property Tax 587 2.03 (27.30) GL 589 12/20/2017 Property Taxes (3.44) (30.74) GL 591 12/22/2017 Property Taxes (3.47) (34.21) GL 612 12/22/2017 Property Taxes (3.47) (37.68) GL 613 12/22/2017 Reverse Property Tax 591 3.47 (34.21) GL 592 12/27/2017 Property Taxes (1.60) (35.81) GL 593 12/28/2017 Property Taxes (.03) (35.84) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (13.85) (35.84) ** (200.00) Budgeted (164.16) Remaining 18 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (177,839.00) Budgeted (177,839.00) Remaining 0 % Used Account: 135-47000-000-000 Water 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (932,153.38) (357,013.62) (1,289,167.00) UB _______________ Account: 135-47000-000-000 Water Totals: (357,013.62) (1,289,167.00) ** (6,464,019.00) Budgeted (5,174,852.00) Remaining 20 % Used Account: 135-47005-000-000 Sewer 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (471,041.79) (235,176.30) (706,218.09) UB _______________ Account: 135-47005-000-000 Sewer Totals: (235,176.30) (706,218.09) ** (2,978,067.00) Budgeted (2,271,848.91) Remaining 24 % Used Trophy Club Municipal Utility District No. 1 80 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47025-000-000 Penalties 522 12/05/2017 Penalty removal UB20171205-20171205 User: (23,100.24) 67.17 (23,033.07) UB 487 12/21/2017 Penalities December 2017 UB20171221-20171221 User: (14,942.36) (37,975.43) UB 523 12/29/2017 Penalty removal UB20171229-20171229 User: 280.86 (37,694.57) UB _______________ Account: 135-47025-000-000 Penalties Totals: (14,594.33) (37,694.57) ** (106,279.00) Budgeted (68,584.43) Remaining 35 % Used Account: 135-47030-000-000 Service Charges 409 12/06/2017 Cut Off List UB20171206-20171206 User: (2,150.00) (1,350.00) (3,500.00) UB 525 12/12/2017 NSF check UB20171211-20171212 User: (50.00) (3,550.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,400.00) (3,550.00) ** (21,350.00) Budgeted (17,800.00) Remaining 17 % Used Account: 135-47035-000-000 Plumbing Inspections 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (450.00) (50.00) (500.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (150.00) (650.00) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (50.00) (700.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (50.00) (750.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (150.00) (900.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (50.00) (950.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (50.00) (1,000.00) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (50.00) (1,050.00) Drees Homes CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (600.00) (1,050.00) ** (1,500.00) Budgeted (450.00) Remaining 70 % Used Account: 135-47045-000-000 Sewer Inspections 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (1,350.00) (150.00) (1,500.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (50.00) (1,550.00) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (50.00) (1,600.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (150.00) (1,750.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (150.00) (1,900.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (150.00) (2,050.00) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (150.00) (2,200.00) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (150.00) (2,350.00) Drees Homes CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (1,000.00) (2,350.00) ** (4,500.00) Budgeted (2,150.00) Remaining 52 % Used Trophy Club Municipal Utility District No. 1 81 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-47070-000-000 TCCC Effluent Charges 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (547.20) (8,570.40) (9,117.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (8,570.40) (9,117.60) ** (60,000.00) Budgeted (50,882.40) Remaining 15 % Used Account: 135-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (5,154.91) (141.86) (5,296.77) GL 603 12/31/2017 December Bank Interest (465.19) (5,761.96) GL 603 12/31/2017 December Bank Interest (2,308.63) (8,070.59) GL 603 12/31/2017 December Bank Interest (439.54) (8,510.13) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (3,355.22) (8,510.13) ** (12,000.00) Budgeted (3,489.87) Remaining 71 % Used Account: 135-49016-000-000 Cell Tower Revenue 546 12/15/2017 AT&T Cell Tower Revenue (1,889.34) (978.81) (2,868.15) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (978.81) (2,868.15) ** (10,926.00) Budgeted (8,057.85) Remaining 26 % Used Account: 135-49018-000-000 Building Rent Income 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (1,166.66) (583.33) (1,749.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,749.99) ** (7,000.00) Budgeted (5,250.01) Remaining 25 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (2,000.00) Budgeted (2,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 437 12/05/2017 Permits-347 Tenison Trail 347 Tenison Trail (3,087.00) (343.00) (3,430.00) First Texas Homes CR 439 12/06/2017 Permits-Beck Intermediate Beck Intermediate (859.76) (4,289.76) Pogue Construction CR 517 12/15/2017 Permits-Ashton Wood Homes 412 Abbot Lane (343.00) (4,632.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (343.00) (4,975.76) Ashton Wood Homes CR Trophy Club Municipal Utility District No. 1 82 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 517 12/15/2017 Permits-Ashton Wood Homes 646 Sheldon Drive (3,087.00) (343.00) (5,318.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 416 Abbot Lane (343.00) (5,661.76) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (343.00) (6,004.76) Ashton Wood Homes CR 518 12/19/2017 Permits-Drees 24 Katie Lane (343.00) (6,347.76) Drees Homes CR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (3,260.76) (6,347.76) ** (18,179.00) Budgeted (11,831.24) Remaining 35 % Used Account: 135-49900-000-000 Miscellaneous Income 517 12/15/2017 Permits-Ashton Wood Homes 414 Abbot Lane (3,675.72) (800.00) (4,475.72) Ashton Wood Homes CR 517 12/15/2017 Permits-Ashton Wood Homes 601 Hogan's Drive (800.00) (5,275.72) Ashton Wood Homes CR 512 12/31/2017 Billing-December 2017 UB20171231-20171231 User: (187.51) (5,463.23) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,787.51) (5,463.23) ** (5,000.00) Budgeted 463.23 Remaining 109 % Used Account: 135-49901-000-000 Records Management Revenue .00 .00 _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 .00 ** (20.00) Budgeted (20.00) Remaining 0 % Used Account: 135-49910-000-000 Reimbursement/Revenue Bond .00 .00 _______________ Account: 135-49910-000-000 Reimbursement/Revenue Bond Totals: .00 .00 ** (260,000.00) Budgeted (260,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (2,144,757.10) ** (693,433.07) Monthly Total (10,250,029.00) Budgeted (8,105,271.90) Remaining 21 % Used Trophy Club Municipal Utility District No. 1 83 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 25,367.85 7,483.92 32,851.77 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 7,483.92 40,335.69 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 7,483.92 47,819.61 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 22,451.76 47,819.61 ** 274,279.00 Budgeted 226,459.39 Remaining 17 % Used Account: 135-50010-010-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 610.94 534.14 1,145.08 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 61.34 1,206.42 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 728.91 1,935.33 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,324.39 1,935.33 ** 20,000.00 Budgeted 18,064.67 Remaining 10 % Used Account: 135-50016-010-000 Longevity 3,310.00 .00 3,310.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,310.00 ** 3,425.00 Budgeted 115.00 Remaining 97 % Used Account: 135-50017-010-000 Certification 434 12/15/2017 MUD PR 12.15.17 Certification 400.00 150.00 550.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 150.00 550.00 ** 3,300.00 Budgeted 2,750.00 Remaining 17 % Used Account: 135-50020-010-000 Retirement 327 12/01/2017 MUD PR 12.01.17 Retirement 4,156.17 741.68 4,897.85 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 711.80 5,609.65 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 759.69 6,369.34 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,213.17 6,369.34 ** 27,843.00 Budgeted 21,473.66 Remaining 23 % Used Account: 135-50026-010-000 Medical Insurance 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 4,960.63 944.88 5,905.51 PR Trophy Club Municipal Utility District No. 1 84 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 4,960.63 944.88 6,850.39 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 1,889.76 6,850.39 ** 52,196.00 Budgeted 45,345.61 Remaining 13 % Used Account: 135-50027-010-000 Dental Insurance 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 505.69 102.98 608.67 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 102.95 711.62 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 205.93 711.62 ** 5,182.00 Budgeted 4,470.38 Remaining 14 % Used Account: 135-50028-010-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 102.97 20.10 123.07 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 20.07 143.14 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 40.17 143.14 ** 994.00 Budgeted 850.86 Remaining 14 % Used Account: 135-50029-010-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 492.77 147.20 639.97 METLIFE GROUP BENEFITS 3708 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 147.20 639.97 ** 2,982.00 Budgeted 2,342.03 Remaining 21 % Used Account: 135-50030-010-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 1,822.13 495.32 2,317.45 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 470.80 2,788.25 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 510.50 3,298.75 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,476.62 3,298.75 ** 18,662.00 Budgeted 15,363.25 Remaining 18 % Used Account: 135-50035-010-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 426.15 115.84 541.99 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 110.10 652.09 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 119.39 771.48 PR Trophy Club Municipal Utility District No. 1 85 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 345.33 771.48 ** 4,365.00 Budgeted 3,593.52 Remaining 18 % Used Account: 135-50040-010-000 Unemployment Taxes 327 12/01/2017 MUD PR 12.01.17 Unemployment Taxes 7.43 1.04 8.47 PR 434 12/15/2017 MUD PR 12.15.17 Unemployment Taxes .21 8.68 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 1.25 8.68 ** 1,080.00 Budgeted 1,071.32 Remaining 1 % Used Account: 135-50045-010-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 1,799.84 899.92 2,699.76 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.92 2,699.76 ** 11,854.00 Budgeted 9,154.24 Remaining 23 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 543 12/31/2017 Pcard 11/28/17 - 12/26/17 LCA*LABCORPHOLDINGS CL 50.00 50.00 LCA*LABCORPHOLDINGS CL PC 557 12/31/2017 December A/P Water-New Hire check 113.05 163.05 FIRST CHECK APPLICANT SCREENIN 3806 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 163.05 163.05 ** 200.00 Budgeted 36.95 Remaining 82 % Used Account: 135-50070-010-000 Employee Relations 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TX.GOV SERVICEFEE- 18.99 2.00 20.99 TX.GOV SERVICEFEE- PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 DENTON VEHREG 7.50 28.49 DENTON VEHREG PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 134.03 162.52 TOM THUMB #1789 PC 620 12/31/2017 Reclassification Pcard entries (2.00) 160.52 GL 620 12/31/2017 Reclassification Pcard entries (7.50) 153.02 GL 620 12/31/2017 Reclassification Pcard entries (134.03) 18.99 GL _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 18.99 ** 300.00 Budgeted 281.01 Remaining 6 % Used Account: 135-55005-010-000 Engineering .00 .00 Trophy Club Municipal Utility District No. 1 86 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 275,000.00 Budgeted 275,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 451 12/14/2017 Dec A/P Angle Stops & Bolts 4,083.37 1,368.60 5,451.97 Core & Main LP 3763 AP 451 12/14/2017 Dec A/P AVK Nozzles 170.36 5,622.33 Core & Main LP 3763 AP 488 12/21/2017 December 2017A/P Valve kits 152.88 5,775.21 Core & Main LP 3763 AP 488 12/21/2017 December 2017A/P Valve repair kits 710.65 6,485.86 Core & Main LP 3763 AP 537 12/31/2017 December A/P Remove and replace driveway @ 3,500.00 9,985.86 REY-MAR CONSTRUCTION 3825 AP 537 12/31/2017 December A/P Hand pumps 207.06 10,192.92 Core & Main LP 3798 AP 537 12/31/2017 December A/P Emergency repair & replace dri 8,285.00 18,477.92 REY-MAR CONSTRUCTION 3825 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 14,394.55 18,477.92 ** 100,000.00 Budgeted 81,522.08 Remaining 18 % Used Account: 135-55085-010-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55090-010-000 Vehicle Maintenance 543 12/31/2017 Pcard 11/28/17 - 12/26/17 KWIK KAR LUBE & TUNE O 1,171.42 7.00 1,178.42 KWIK KAR LUBE & TUNE O PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 27.05 1,205.47 ROANOKE AUTO SUPPLY LT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 41.91 1,247.38 ROANOKE AUTO SUPPLY LT PC 620 12/31/2017 Reclassification Pcard entries 2.00 1,249.38 GL 620 12/31/2017 Reclassification Pcard entries 7.50 1,256.88 GL 620 12/31/2017 Reclassification Pcard entries 8.25 1,265.13 GL 620 12/31/2017 Reclassification Pcard entries 2.00 1,267.13 GL _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 95.71 1,267.13 ** 4,000.00 Budgeted 2,732.87 Remaining 32 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 87 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-000 Lab Analysis 451 12/14/2017 Dec A/P Water Samples/MUD 1,130.74 200.00 1,330.74 TARRANT CTY PUBLIC HEALTH LAB 3785 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 1,330.74 ** 5,500.00 Budgeted 4,169.26 Remaining 24 % Used Account: 135-60010-010-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 319.55 320.79 640.34 VERIZON WIRELESS 3793 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 320.79 640.34 ** 4,700.00 Budgeted 4,059.66 Remaining 14 % Used Account: 135-60020-010-000 Electricity 451 12/14/2017 Dec A/P Electricity 11/7-12/7/17 27,304.32 17.33 27,321.65 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/18-17 11,208.35 38,530.00 HUDSON ENERGY SERVICES, LLC 3772 AP _______________ Account: 135-60020-010-000 Electricity Totals: 11,225.68 38,530.00 ** 175,356.00 Budgeted 136,826.00 Remaining 22 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training .00 .00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 .00 ** 2,785.00 Budgeted 2,785.00 Remaining 0 % Used Account: 135-60090-010-000 Safety Program Trophy Club Municipal Utility District No. 1 88 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 8.36 .00 8.36 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 8.36 ** 400.00 Budgeted 391.64 Remaining 2 % Used Account: 135-60100-010-000 Travel & per diem 87.48 .00 87.48 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 87.48 ** 1,735.00 Budgeted 1,647.52 Remaining 5 % Used Account: 135-60105-010-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60135-010-000 TCEQ Fees & Permits 7,685.65 .00 7,685.65 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 7,685.65 ** 55,176.00 Budgeted 47,490.35 Remaining 14 % Used Account: 135-60150-010-000 Wholesale Water 537 12/31/2017 December A/P Wholesale water 208,059.10 166,739.52 374,798.62 CITY OF FORT WORTH 3797 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 166,739.52 374,798.62 ** 2,823,170.00 Budgeted 2,448,371.38 Remaining 13 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 214.70 .00 214.70 Trophy Club Municipal Utility District No. 1 89 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 214.70 ** 3,000.00 Budgeted 2,785.30 Remaining 7 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2,250.00 .00 2,250.00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 2,250.00 ** 14,750.00 Budgeted 12,500.00 Remaining 15 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 504 12/27/2017 Texpool Transfers Dec 50,560.62 25,280.31 75,840.93 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,280.31 75,840.93 ** 278,084.00 Budgeted 202,243.07 Remaining 27 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 504 12/27/2017 Texpool Transfers Dec 8,166.00 4,083.00 12,249.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 12,249.00 ** 48,996.00 Budgeted 36,747.00 Remaining 25 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 537 12/31/2017 December A/P New testing machine 118.47 118.47 HACH COMPANY 3810 AP 537 12/31/2017 December A/P New testing machine 183.60 302.07 HACH COMPANY 3810 AP 537 12/31/2017 December A/P new testing machine 213.44 515.51 HACH COMPANY 3811 AP 537 12/31/2017 December A/P New testing machine 4,504.15 5,019.66 HACH COMPANY 3810 AP _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: 5,019.66 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube Trophy Club Municipal Utility District No. 1 90 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 537 12/31/2017 December A/P fuel 1,419.71 777.27 2,196.98 US Bank Voyager Fleet Systems 3831 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 777.27 2,196.98 ** 15,000.00 Budgeted 12,803.02 Remaining 15 % Used Account: 135-65010-010-000 Uniforms 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TRACTOR SUPPLY COMPANY 497.22 174.75 671.97 TRACTOR SUPPLY COMPANY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TRACTOR SUPPLY COMPANY (13.32) 658.65 TRACTOR SUPPLY COMPANY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RED WING SHOES #652 170.99 829.64 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 332.42 829.64 ** 4,488.00 Budgeted 3,658.36 Remaining 18 % Used Account: 135-65030-010-000 Chemicals 451 12/14/2017 Dec A/P 55 gal drum LAS 2,607.66 441.16 3,048.82 Valley Solvent Company, INC 3792 AP 537 12/31/2017 December A/P Chlorine 663.72 3,712.54 DPC INDUSTRIES, INC 3802 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,104.88 3,712.54 ** 20,000.00 Budgeted 16,287.46 Remaining 19 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense .00 .00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 50,000.00 Budgeted 50,000.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 91 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 84,000.00 Budgeted 84,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 451 12/14/2017 Dec A/P High Speed VFD 54,409.25 7,705.17 62,114.42 CP&Y/WALLACE GROUP, INC. 3765 AP 537 12/31/2017 December A/P 2017 Capital outlay VFD-Water 1,868.44 63,982.86 Star-Telegram Media 3826 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 9,573.61 63,982.86 ** 810,012.00 Budgeted 746,029.14 Remaining 8 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 38,731.00 Budgeted 38,731.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 5,713.00 Budgeted 5,713.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 .00 75,000.00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 537 12/31/2017 December A/P Annual tank inspection/mainten 65,920.00 41,944.38 107,864.38 UTILITY SERVICE CO, INC. 3832 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 41,944.38 107,864.38 ** 118,775.00 Budgeted 10,910.62 Remaining 91 % Used Trophy Club Municipal Utility District No. 1 92 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55135-010-001 Lab Analysis for PID 488 12/21/2017 December 2017A/P Water samples 296.19 80.00 376.19 TARRANT CTY PUBLIC HEALTH LAB 3785 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 376.19 ** 2,000.00 Budgeted 1,623.81 Remaining 19 % Used Department 10 Totals: ----------------------------------- 867,653.23 ** 312,480.33 Monthly Total 5,657,433.00 Budgeted 4,789,779.77 Remaining 15 % Used Trophy Club Municipal Utility District No. 1 93 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 46,080.58 15,349.00 61,429.58 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 15,366.28 76,795.86 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 15,303.74 92,099.60 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 46,019.02 92,099.60 ** 410,866.00 Budgeted 318,766.40 Remaining 22 % Used Account: 135-50010-020-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 3,997.04 1,025.12 5,022.16 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 809.41 5,831.57 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 856.80 6,688.37 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,691.33 6,688.37 ** 30,000.00 Budgeted 23,311.63 Remaining 22 % Used Account: 135-50016-020-000 Longevity 7,415.00 .00 7,415.00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 7,415.00 ** 7,415.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 434 12/15/2017 MUD PR 12.15.17 Certification 1,325.00 625.00 1,950.00 PR 456 12/15/2017 Supplemental P/R Run Certification 75.00 2,025.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 2,025.00 ** 8,400.00 Budgeted 6,375.00 Remaining 24 % Used Account: 135-50020-020-000 Retirement 327 12/01/2017 MUD PR 12.01.17 Retirement 6,905.08 1,514.60 8,419.68 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 1,554.08 9,973.76 PR 456 12/15/2017 Supplemental P/R Run Retirement 6.94 9,980.70 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 1,494.84 11,475.54 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,570.46 11,475.54 ** 42,243.00 Budgeted 30,767.46 Remaining 27 % Used Account: 135-50026-020-000 Medical Insurance Trophy Club Municipal Utility District No. 1 94 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 9,420.40 2,355.10 11,775.50 PR 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 2,355.10 14,130.60 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 4,710.20 14,130.60 ** 62,175.00 Budgeted 48,044.40 Remaining 23 % Used Account: 135-50027-020-000 Dental Insurance 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 798.64 199.69 998.33 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 199.63 1,197.96 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 399.32 1,197.96 ** 5,271.00 Budgeted 4,073.04 Remaining 23 % Used Account: 135-50028-020-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 168.66 42.19 210.85 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 42.14 252.99 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 84.33 252.99 ** 1,114.00 Budgeted 861.01 Remaining 23 % Used Account: 135-50029-020-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 788.28 361.15 1,149.43 METLIFE GROUP BENEFITS 3708 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 361.15 1,149.43 ** 4,281.00 Budgeted 3,131.57 Remaining 27 % Used Account: 135-50030-020-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 3,440.24 957.79 4,398.03 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 966.91 5,364.94 PR 456 12/15/2017 Supplemental P/R Run Social Security Taxes 4.65 5,369.59 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 1,004.55 6,374.14 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 2,933.90 6,374.14 ** 28,314.00 Budgeted 21,939.86 Remaining 23 % Used Account: 135-50035-020-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 804.57 223.99 1,028.56 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 226.14 1,254.70 PR Trophy Club Municipal Utility District No. 1 95 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 456 12/15/2017 Supplemental P/R Run Medicare Taxes 804.57 1.09 1,255.79 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 234.94 1,490.73 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 686.16 1,490.73 ** 6,622.00 Budgeted 5,131.27 Remaining 23 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 2,696.00 1,348.00 4,044.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 4,044.00 ** 17,990.00 Budgeted 13,946.00 Remaining 22 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-50070-020-000 Employee Relations 543 12/31/2017 Pcard 11/28/17 - 12/26/17 DENTON VEHREG 8.25 8.25 DENTON VEHREG PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TX.GOV SERVICEFEE- 2.00 10.25 TX.GOV SERVICEFEE- PC 620 12/31/2017 Reclassification Pcard entries (8.25) 2.00 GL 620 12/31/2017 Reclassification Pcard entries (2.00) .00 GL _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 350.00 Budgeted 350.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 20,550.00 Budgeted 20,550.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 96 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 537 12/31/2017 December A/P Replace of rubber 6,356.22 88.00 6,444.22 Huber Technology Inc 3813 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AIR MAC INC 575.60 7,019.82 AIR MAC INC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT 16.86 7,036.68 ROANOKE AUTO SUPPLY LT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 11.93 7,048.61 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 17.54 7,066.15 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 3.19 7,069.34 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ROANOKE AUTO SUPPLY LT .98 7,070.32 ROANOKE AUTO SUPPLY LT PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 714.10 7,070.32 ** 86,100.00 Budgeted 79,029.68 Remaining 8 % Used Account: 135-55085-020-000 Generator Maint. and Repair 28.78 .00 28.78 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 28.78 ** 14,000.00 Budgeted 13,971.22 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR WASH 2,648.72 6.00 2,654.72 MUSTANG ELITE CAR WASH PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 70.99 2,725.71 MUSTANG ELITE CAR PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 70.99 2,796.70 MUSTANG ELITE CAR PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR WASH 5.99 2,802.69 MUSTANG ELITE CAR WASH PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 MUSTANG ELITE CAR 25.50 2,828.19 MUSTANG ELITE CAR PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 179.47 2,828.19 ** 8,000.00 Budgeted 5,171.81 Remaining 35 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 451 12/14/2017 Dec A/P Sludge haul off 7,899.48 3,052.99 10,952.47 L.H. CHANEY MATERIALS, INC. 3775 AP 537 12/31/2017 December A/P Sludge haul off 1,984.48 12,936.95 L.H. CHANEY MATERIALS, INC. 3819 AP 537 12/31/2017 December A/P sludge haul off 2,176.30 15,113.25 L.H. CHANEY MATERIALS, INC. 3819 AP Trophy Club Municipal Utility District No. 1 97 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-55125-020-000 Dumpster Services Totals: 7,213.77 15,113.25 ** 60,000.00 Budgeted 44,886.75 Remaining 25 % Used Account: 135-55135-020-000 Lab Analysis 451 12/14/2017 Dec A/P Testing 7,827.82 246.00 8,073.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 8,319.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 176.00 8,495.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 8,741.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 176.00 8,917.82 OXIDOR LABORATORIES LLC 3783 AP 451 12/14/2017 Dec A/P Testing 246.00 9,163.82 OXIDOR LABORATORIES LLC 3783 AP 537 12/31/2017 December A/P ;ab supplies 176.00 9,339.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 246.00 9,585.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 176.00 9,761.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 246.00 10,007.82 OXIDOR LABORATORIES LLC 3823 AP 537 12/31/2017 December A/P Testing supplies 176.00 10,183.82 OXIDOR LABORATORIES LLC 3823 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,356.00 10,183.82 ** 30,000.00 Budgeted 19,816.18 Remaining 34 % Used Account: 135-60010-020-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 381.56 381.81 763.37 VERIZON WIRELESS 3793 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 381.81 763.37 ** 4,700.00 Budgeted 3,936.63 Remaining 16 % Used Account: 135-60020-020-000 Electricity 451 12/14/2017 Dec A/P Electricity 11/7-12/7/17 26,996.29 32.15 27,028.44 HUDSON ENERGY SERVICES, LLC 3772 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 147.89 27,176.33 TRI COUNTY ELECTRIC 3789 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 27.86 27,204.19 TRI COUNTY ELECTRIC 3789 AP 451 12/14/2017 Dec A/P Electricity 10/24-11/27/17 281.80 27,485.99 TRI COUNTY ELECTRIC 3789 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 445.69 27,931.68 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 7,363.73 35,295.41 HUDSON ENERGY SERVICES, LLC 3772 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/7/17 7,954.80 43,250.21 ENGIE Resources LLC 3768 AP 488 12/21/2017 December 2017A/P Electricity 11/8-12/8/17 270.95 43,521.16 MP2 ENERGY TEXAS LLC 3782 AP 537 12/31/2017 December A/P Electricity 12/8/17-12/18/17 110.77 43,631.93 MP2 ENERGY TEXAS LLC 3821 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (177.00) 43,454.93 AR _______________ Account: 135-60020-020-000 Electricity Totals: 16,458.64 43,454.93 ** 266,709.00 Budgeted 223,254.07 Remaining 16 % Used Trophy Club Municipal Utility District No. 1 98 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-020-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60070-020-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-60080-020-000 Schools & Training .00 .00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 .00 ** 5,677.00 Budgeted 5,677.00 Remaining 0 % Used Account: 135-60090-020-000 Safety Program 8.37 .00 8.37 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 8.37 ** 550.00 Budgeted 541.63 Remaining 2 % Used Account: 135-60100-020-000 Travel & per diem 23.17 .00 23.17 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 23.17 ** 1,635.00 Budgeted 1,611.83 Remaining 1 % Used Account: 135-60105-020-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60125-020-000 Advertising Trophy Club Municipal Utility District No. 1 99 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60125-020-000 Advertising Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 451 12/14/2017 Dec A/P WWTP Permit Renewal TO #4 34,733.77 288.75 35,022.52 CP&Y/WALLACE GROUP, INC. 3765 AP 451 12/14/2017 Dec A/P WWTP Improvements less credit (5,000.00) 30,022.52 CP&Y/WALLACE GROUP, INC. 3765 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: (4,711.25) 30,022.52 ** 85,000.00 Budgeted 54,977.48 Remaining 35 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance .00 .00 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 1,770.00 .00 1,770.00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 1,770.00 ** 11,600.00 Budgeted 9,830.00 Remaining 15 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 504 12/27/2017 Texpool Transfers Dec 22,189.62 11,094.81 33,284.43 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 11,094.81 33,284.43 ** 122,043.00 Budgeted 88,758.57 Remaining 27 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Trophy Club Municipal Utility District No. 1 100 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 504 12/27/2017 Texpool Transfers Dec 108,861.44 54,430.72 163,292.16 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,430.72 163,292.16 ** 598,738.00 Budgeted 435,445.84 Remaining 27 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 504 12/27/2017 Texpool Transfers Dec 20,556.00 10,278.00 30,834.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 30,834.00 ** 123,336.00 Budgeted 92,502.00 Remaining 25 % Used Account: 135-60334-020-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 537 12/31/2017 December A/P fuel 1,533.61 653.58 2,187.19 US Bank Voyager Fleet Systems 3831 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 653.58 2,187.19 ** 12,500.00 Budgeted 10,312.81 Remaining 17 % Used Account: 135-65010-020-000 Uniforms 1,614.63 .00 1,614.63 _______________ Account: 135-65010-020-000 Uniforms Totals: .00 1,614.63 ** 4,459.00 Budgeted 2,844.37 Remaining 36 % Used Account: 135-65030-020-000 Chemicals 543 12/31/2017 Pcard 11/28/17 - 12/26/17 INT*IN *AQUAFIX, INC. 5.35 660.48 665.83 INT*IN *AQUAFIX, INC. PC Trophy Club Municipal Utility District No. 1 101 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65030-020-000 Chemicals Totals: 660.48 665.83 ** 27,500.00 Budgeted 26,834.17 Remaining 2 % Used Account: 135-65035-020-000 Small Tools 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 247.76 55.81 303.57 THE HOME DEPOT #6581 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 THE HOME DEPOT #6581 37.84 341.41 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 93.65 341.41 ** 1,000.00 Budgeted 658.59 Remaining 34 % Used Account: 135-65040-020-000 Safety Equipment .00 .00 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-65045-020-000 Lab Supplies 451 12/14/2017 Dec A/P Lab supplies 2,136.63 279.67 2,416.30 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 386.98 2,803.28 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 358.32 3,161.60 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 57.58 3,219.18 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab supplies 91.30 3,310.48 HACH COMPANY 3771 AP 451 12/14/2017 Dec A/P Lab Supplies 333.67 3,644.15 HACH COMPANY 3771 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 5.56 3,649.71 TOM THUMB #1789 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,513.08 3,649.71 ** 14,000.00 Budgeted 10,350.29 Remaining 26 % Used Account: 135-69005-020-000 Capital Outlays 451 12/14/2017 Dec A/P Legal WWTP 9,870.99 1,657.50 11,528.49 Dubois Bryant Campbell LLP 3767 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 1,657.50 11,528.49 ** 547,327.00 Budgeted 535,798.51 Remaining 2 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 Trophy Club Municipal Utility District No. 1 102 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 51,342.00 Budgeted 51,342.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 7,573.00 Budgeted 7,573.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 537,007.93 ** 167,478.23 Monthly Total 2,981,140.00 Budgeted 2,444,132.07 Remaining 18 % Used Trophy Club Municipal Utility District No. 1 103 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50045-026-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 4.84 2.42 7.26 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.42 7.26 ** 30.00 Budgeted 22.74 Remaining 24 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used Account: 135-60070-026-000 Dues & Memberships 650.00 .00 650.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 650.00 ** 600.00 Budgeted (50.00) Remaining 108 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 568 12/31/2017 December AP Directors conference/training 690.00 445.00 1,135.00 ASSOC OF WATER BOARD DIRECTORS 3834 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 445.00 1,135.00 ** 4,000.00 Budgeted 2,865.00 Remaining 28 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses Trophy Club Municipal Utility District No. 1 104 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 543 12/31/2017 Pcard 11/28/17 - 12/26/17 WALGREENS #6264 1,021.73 1,021.73 WALGREENS #6264 PC _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: 1,021.73 1,021.73 ** 2,000.00 Budgeted 978.27 Remaining 51 % Used Department 26 Totals: ----------------------------------- 2,813.99 ** 1,469.15 Monthly Total 12,980.00 Budgeted 10,166.01 Remaining 22 % Used Trophy Club Municipal Utility District No. 1 105 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 327 12/01/2017 MUD PR 12.01.17 Salaries & Wages 46,587.70 16,289.35 62,877.05 PR 434 12/15/2017 MUD PR 12.15.17 Salaries & Wages 16,236.73 79,113.78 PR 501 12/29/2017 MUD PR 12.29.17 Salaries & Wages 26,096.76 105,210.54 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 58,622.84 105,210.54 ** 432,863.00 Budgeted 327,652.46 Remaining 24 % Used Account: 135-50010-030-000 Overtime 327 12/01/2017 MUD PR 12.01.17 Overtime 174.20 .77 174.97 PR 434 12/15/2017 MUD PR 12.15.17 Overtime 7.66 182.63 PR 501 12/29/2017 MUD PR 12.29.17 Overtime 159.79 342.42 PR _______________ Account: 135-50010-030-000 Overtime Totals: 168.22 342.42 ** 2,000.00 Budgeted 1,657.58 Remaining 17 % Used Account: 135-50016-030-000 Longevity 3,547.50 .00 3,547.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 3,547.50 ** 3,548.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 327 12/01/2017 MUD PR 12.01.17 Retirement 6,960.57 1,506.83 8,467.40 PR 434 12/15/2017 MUD PR 12.15.17 Retirement 1,502.60 9,970.00 PR 501 12/29/2017 MUD PR 12.29.17 Retirement 2,428.73 12,398.73 PR _______________ Account: 135-50020-030-000 Retirement Totals: 5,438.16 12,398.73 ** 40,553.00 Budgeted 28,154.27 Remaining 31 % Used Account: 135-50026-030-000 Medical Insurance 327 12/01/2017 MUD PR 12.01.17 Medical Insurance 6,935.44 1,911.02 8,846.46 PR 434 12/15/2017 MUD PR 12.15.17 Medical Insurance 1,911.03 10,757.49 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 3,822.05 10,757.49 ** 63,485.00 Budgeted 52,727.51 Remaining 17 % Used Account: 135-50027-030-000 Dental Insurance Trophy Club Municipal Utility District No. 1 106 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 327 12/01/2017 MUD PR 12.01.17 Dental Insurance 641.50 174.48 815.98 PR 434 12/15/2017 MUD PR 12.15.17 Dental Insurance 174.42 990.40 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 348.90 990.40 ** 5,502.00 Budgeted 4,511.60 Remaining 18 % Used Account: 135-50028-030-000 Vision Insurance 327 12/01/2017 MUD PR 12.01.17 Vision Insurance 138.06 37.94 176.00 PR 434 12/15/2017 MUD PR 12.15.17 Vision Insurance 37.88 213.88 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 75.82 213.88 ** 1,173.00 Budgeted 959.12 Remaining 18 % Used Account: 135-50029-030-000 Life Insurance & Other 307 12/01/2017 Dec A/P Dec Dental, Vision & other 660.65 383.01 1,043.66 METLIFE GROUP BENEFITS 3708 AP 488 12/21/2017 December 2017A/P Flex admin fee 64.00 1,107.66 BenefitMall 3762 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 447.01 1,107.66 ** 5,059.00 Budgeted 3,951.34 Remaining 22 % Used Account: 135-50030-030-000 Social Security Taxes 327 12/01/2017 MUD PR 12.01.17 Social Security Taxes 2,982.39 972.31 3,954.70 PR 434 12/15/2017 MUD PR 12.15.17 Social Security Taxes 957.61 4,912.31 PR 501 12/29/2017 MUD PR 12.29.17 Social Security Taxes 1,627.92 6,540.23 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 3,557.84 6,540.23 ** 27,181.00 Budgeted 20,640.77 Remaining 24 % Used Account: 135-50035-030-000 Medicare Taxes 327 12/01/2017 MUD PR 12.01.17 Medicare Taxes 697.48 227.41 924.89 PR 434 12/15/2017 MUD PR 12.15.17 Medicare Taxes 223.95 1,148.84 PR 501 12/29/2017 MUD PR 12.29.17 Medicare Taxes 380.72 1,529.56 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 832.08 1,529.56 ** 6,357.00 Budgeted 4,827.44 Remaining 24 % Used Account: 135-50040-030-000 Unemployment Taxes 327 12/01/2017 MUD PR 12.01.17 Unemployment Taxes 5.04 2.24 7.28 PR Trophy Club Municipal Utility District No. 1 107 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 434 12/15/2017 MUD PR 12.15.17 Unemployment Taxes 5.04 2.24 9.52 PR 501 12/29/2017 MUD PR 12.29.17 Unemployment Taxes 2.24 11.76 PR 606 12/31/2017 SUTA Qtrly 4 Adjustment .01 11.77 GL _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 6.73 11.77 ** 1,260.00 Budgeted 1,248.23 Remaining 1 % Used Account: 135-50045-030-000 Workman's Compensation 234 12/01/2017 Insurance/Wrk Comp Exp Dec 247.00 123.50 370.50 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 123.50 370.50 ** 1,529.00 Budgeted 1,158.50 Remaining 24 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 124.95 .00 124.95 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 124.95 ** 500.00 Budgeted 375.05 Remaining 25 % Used Account: 135-50070-030-000 Employee Relations 537 12/31/2017 December A/P Office supplies 314.68 18.99 333.67 COSTCO WHOLESALE 3800 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 10.81 344.48 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 19.66 364.14 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CRISTINA'S MEXICAN 12.45 376.59 CRISTINA'S MEXICAN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 BABE'S- ROANOKE LLC 282.81 659.40 BABE'S- ROANOKE LLC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 675.00 1,334.40 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 WM SUPERCENTER #5247 350.00 1,684.40 WM SUPERCENTER #5247 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 340.90 2,025.30 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 33.55 2,058.85 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 3.29 2,062.14 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CHICK-FIL-A #02892 67.01 2,129.15 CHICK-FIL-A #02892 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 12.10 2,141.25 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 26.68 2,167.93 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 16.98 2,184.91 TOM THUMB #1789 PC 620 12/31/2017 Reclassification Pcard entries (12.45) 2,172.46 GL 620 12/31/2017 Reclassification Pcard entries 134.03 2,306.49 GL _______________ Account: 135-50070-030-000 Employee Relations Totals: 1,991.81 2,306.49 ** 4,960.00 Budgeted 2,653.51 Remaining 47 % Used Trophy Club Municipal Utility District No. 1 108 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55030-030-000 Software & Support 451 12/14/2017 Dec A/P Internet 12,461.20 1,038.02 13,499.22 WHOLESALE CARRIER SERVICES INC 3794 AP 488 12/21/2017 December 2017A/P VMWARE-software support-3 year 7,945.33 21,444.55 M3 Networks 3777 AP 488 12/21/2017 December 2017A/P STW support 70.00 21,514.55 STW INC 3784 AP 488 12/21/2017 December 2017A/P STW Support 105.85 21,620.40 STW INC 3784 AP 488 12/21/2017 December 2017A/P Outlook 365 license 168.00 21,788.40 M3 Networks 3777 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE *IL CREATIVE CLD 19.99 21,808.39 ADOBE *IL CREATIVE CLD PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA FOR WORK MONTHLY 12.95 21,821.34 CANVA FOR WORK MONTHLY PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE 16.23 21,837.57 ADOBE PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 118.59 21,956.16 ATT*BILL PAYMENT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 85.56 22,041.72 ATT*BILL PAYMENT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ADOBE *PHOTOGPHY PLAN 119.88 22,161.60 ADOBE *PHOTOGPHY PLAN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA 01814-2780603 20.00 22,181.60 CANVA 01814-2780603 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 CANVA 01812-2736145 1.00 22,182.60 CANVA 01812-2736145 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 63.49 22,246.09 ATT*BILL PAYMENT PC _______________ Account: 135-55030-030-000 Software & Support Totals: 9,784.89 22,246.09 ** 78,391.00 Budgeted 56,144.91 Remaining 28 % Used Account: 135-55070-030-000 Independent Labor 539 12/31/2017 December AP GM December 26,772.79 8,925.00 35,697.79 Carman Consulting LLC. 3833 AP 539 12/31/2017 December AP GM December 9.63 35,707.42 Carman Consulting LLC. 3833 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 8,934.63 35,707.42 ** 154,000.00 Budgeted 118,292.58 Remaining 23 % Used Account: 135-55080-030-000 Maintenance & Repairs 451 12/14/2017 Dec A/P Rekey 162.21 303.67 465.88 MICHAEL'S KEYS INC. 3781 AP 451 12/14/2017 Dec A/P Rekey 102.47 568.35 MICHAEL'S KEYS INC. 3780 AP 451 12/14/2017 Dec A/P Rug Service 66.47 634.82 G & K SERVICES 3770 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (66.47) 568.35 AR _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 406.14 568.35 ** 14,000.00 Budgeted 13,431.65 Remaining 4 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 109 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55100-030-000 Building Maint & Supplies 537 12/31/2017 December A/P FIre Alarm monitoring 360.00 360.00 PRO FIRE & SPRINKLER LLC 3824 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 360.00 360.00 ** .00 Budgeted (360.00) Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services 488 12/21/2017 December 2017A/P Cleaning services 486.15 869.06 1,355.21 MEMBER'S BUILDING MAINTENANCE 3779 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (196.32) 1,158.89 AR _______________ Account: 135-55120-030-000 Cleaning Services Totals: 672.74 1,158.89 ** 10,000.00 Budgeted 8,841.11 Remaining 12 % Used Account: 135-55160-030-000 Professional Outside Services 56,475.00 .00 56,475.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 56,475.00 ** 63,325.00 Budgeted 6,850.00 Remaining 89 % Used Account: 135-55165-030-000 Collection Fees .00 .00 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 451 12/14/2017 Dec A/P Water Billing/November 573.93 626.16 1,200.09 DATAPROSE LLC 3766 AP 568 12/31/2017 December AP Billing-December 604.36 1,804.45 DATAPROSE LLC 3835 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,230.52 1,804.45 ** 9,000.00 Budgeted 7,195.55 Remaining 20 % Used Account: 135-60005-030-000 Telephone 392 12/05/2017 Dec A/P Answering Service 1,519.22 200.00 1,719.22 KEYSTONE PARK SECRETARIAL 3737 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BUS PHONE PMT 851.57 2,570.79 ATT*BUS PHONE PMT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RINGCENTRAL, INC 13.96 2,584.75 RINGCENTRAL, INC PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BUS PHONE PMT 384.59 2,969.34 ATT*BUS PHONE PMT PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 ATT*BILL PAYMENT 199.65 3,168.99 ATT*BILL PAYMENT PC Trophy Club Municipal Utility District No. 1 110 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: 1,519.22 (425.78) 2,743.21 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,223.99 2,743.21 ** 27,300.00 Budgeted 24,556.79 Remaining 10 % Used Account: 135-60010-030-000 Communications/Mobiles 451 12/14/2017 Dec A/P Cells 487.99 136.75 624.74 VERIZON WIRELESS 3793 AP 434 12/15/2017 MUD PR 12.15.17 Communications/Mobiles 225.00 849.74 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 361.75 849.74 ** 4,000.00 Budgeted 3,150.26 Remaining 21 % Used Account: 135-60020-030-000 Electricity/Gas 644.52 .00 644.52 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 644.52 ** 16,261.00 Budgeted 15,616.48 Remaining 4 % Used Account: 135-60025-030-000 Water 537 12/31/2017 December A/P Water 11/27-12/27/17 116.20 116.19 232.39 TROPHY CLUB MUD (WATER BILLS) 3830 AP 609 12/31/2017 Town Billed Invoice 1611-1616 AR 20171231-20171231 User: (58.09) 174.30 AR _______________ Account: 135-60025-030-000 Water Totals: 58.10 174.30 ** 2,500.00 Budgeted 2,325.70 Remaining 7 % Used Account: 135-60030-030-000 Rent And/Or Usage 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 616.40 616.40 RENAISSANCE HOTELS PC _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 616.40 616.40 ** .00 Budgeted (616.40) Remaining 0 % Used Account: 135-60035-030-000 Postage 451 12/14/2017 Dec A/P Overnight letter 1,702.91 7.18 1,710.09 FEDERAL EXPRESS CORP 3760 AP 451 12/14/2017 Dec A/P Water Billing/November 1,575.78 3,285.87 DATAPROSE LLC 3766 AP 488 12/21/2017 December 2017A/P PPD Postage for meter 1,500.00 4,785.87 U.S. Postal Service (CMRS-FP) 3791 AP 568 12/31/2017 December AP Billing-December 1,597.24 6,383.11 DATAPROSE LLC 3835 AP _______________ Account: 135-60035-030-000 Postage Totals: 4,680.20 6,383.11 ** 30,000.00 Budgeted 23,616.89 Remaining 21 % Used Trophy Club Municipal Utility District No. 1 111 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60040-030-000 Service Charges & Fees 328 12/01/2017 Child Support Fee 11,161.29 1.50 11,162.79 GL 435 12/15/2017 Child Support Fee 1.50 11,164.29 GL 502 12/29/2017 Child Support Fee 1.50 11,165.79 GL 544 12/31/2017 Pace Credit Card Fees 5,115.73 16,281.52 GL 544 12/31/2017 Pace Credit Card Fees 122.78 16,404.30 GL 557 12/31/2017 December A/P Direct Send Fees-November 50.00 16,454.30 Fiserv Solutions, LLC 3805 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,293.01 16,454.30 ** 55,560.00 Budgeted 39,105.70 Remaining 30 % Used Account: 135-60050-030-000 Bad Debt Expense .00 .00 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-60055-030-000 Insurance 234 12/01/2017 Insurance/Wrk Comp Exp Dec 12,200.72 6,100.36 18,301.08 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.36 18,301.08 ** 56,000.00 Budgeted 37,698.92 Remaining 33 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,600.00 Budgeted 1,600.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 451 12/14/2017 Dec A/P Tx Social Security Program 100.00 35.00 135.00 TX SOCIAL SECURITY PROGRAM 3790 AP _______________ Account: 135-60070-030-000 Dues & Memberships Totals: 35.00 135.00 ** 6,000.00 Budgeted 5,865.00 Remaining 2 % Used Account: 135-60075-030-000 Meetings 48.62 .00 48.62 Trophy Club Municipal Utility District No. 1 112 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60075-030-000 Meetings Totals: .00 48.62 ** 400.00 Budgeted 351.38 Remaining 12 % Used Account: 135-60079-030-000 Public Education .00 .00 _______________ Account: 135-60079-030-000 Public Education Totals: .00 .00 ** 6,000.00 Budgeted 6,000.00 Remaining 0 % Used Account: 135-60080-030-000 Schools & Training 2,608.00 .00 2,608.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 2,608.00 ** 7,600.00 Budgeted 4,992.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 327 12/01/2017 MUD PR 12.01.17 Travel & per diem 76.68 24.30 100.98 PR 434 12/15/2017 MUD PR 12.15.17 Travel & per diem 33.75 134.73 PR 501 12/29/2017 MUD PR 12.29.17 Travel & per diem 94.77 229.50 PR 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HOBBY-LOBBY #256 109.18 338.68 HOBBY-LOBBY #256 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 16.57 355.25 RENAISSANCE HOTELS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 BLUE BAKER 003 11.00 366.25 BLUE BAKER 003 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 7-ELEVEN 32921 28.49 394.74 7-ELEVEN 32921 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 RENAISSANCE HOTELS 14.11 408.85 RENAISSANCE HOTELS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 HYDE PARK BAR & GRILL 19.22 428.07 HYDE PARK BAR & GRILL PC 620 12/31/2017 Reclassification Pcard entries 12.45 440.52 GL _______________ Account: 135-60100-030-000 Travel & per diem Totals: 363.84 440.52 ** 4,885.00 Budgeted 4,444.48 Remaining 9 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used Account: 135-60115-030-000 Elections Trophy Club Municipal Utility District No. 1 113 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 451 12/14/2017 Dec A/P Election translation 45.00 100.00 145.00 Teneo Linquistics Company, LLC 3787 AP _______________ Account: 135-60115-030-000 Elections Totals: 100.00 145.00 ** 4,500.00 Budgeted 4,355.00 Remaining 3 % Used Account: 135-60125-030-000 Advertising .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 2,700.00 Budgeted 2,700.00 Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 211.99 .00 211.99 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 211.99 ** 2,500.00 Budgeted 2,288.01 Remaining 8 % Used Account: 135-65010-030-000 Uniforms .00 .00 Trophy Club Municipal Utility District No. 1 114 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 700.00 Budgeted 700.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware 597.95 .00 597.95 _______________ Account: 135-65055-030-000 Hardware Totals: .00 597.95 ** 7,420.00 Budgeted 6,822.05 Remaining 8 % Used Account: 135-65085-030-000 Office Supplies 537 12/31/2017 December A/P Office supplies 1,820.01 31.99 1,852.00 OFFICE DEPOT, INC 3822 AP 537 12/31/2017 December A/P Office supplies 28.50 1,880.50 OFFICE DEPOT, INC 3822 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 55.25 1,935.75 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON.COM 27.05 1,962.80 AMAZON.COM PC _______________ Account: 135-65085-030-000 Office Supplies Totals: 142.79 1,962.80 ** 7,000.00 Budgeted 5,037.20 Remaining 28 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 1,560.00 98.06 1,658.06 OFFICE DEPOT #1079 PC _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: 98.06 1,658.06 ** 2,000.00 Budgeted 341.94 Remaining 83 % Used Account: 135-65095-030-000 Maintenance Supplies 537 12/31/2017 December A/P Office supplies 663.67 17.56 681.23 COSTCO WHOLESALE 3800 AP 537 12/31/2017 December A/P Office supplies 50.07 731.30 OFFICE DEPOT, INC 3822 AP 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (25.26) 706.04 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 104.70 810.74 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TARGET 00008763 21.64 832.38 TARGET 00008763 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 10.88 843.26 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 KEURIG GREEN MOUNTAIN 47.99 891.25 KEURIG GREEN MOUNTAIN PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 STAPLES 00116533 77.90 969.15 STAPLES 00116533 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 131.92 1,101.07 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 TOM THUMB #1789 5.98 1,107.05 TOM THUMB #1789 PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (32.95) 1,074.10 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS (48.38) 1,025.72 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 14.99 1,040.71 OFFICE DEPOT #1079 PC Trophy Club Municipal Utility District No. 1 115 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 543 12/31/2017 Pcard 11/28/17 - 12/26/17 AMAZON MKTPLACE PMTS 663.67 81.33 1,122.04 AMAZON MKTPLACE PMTS PC 543 12/31/2017 Pcard 11/28/17 - 12/26/17 OFFICE DEPOT #1079 35.24 1,157.28 OFFICE DEPOT #1079 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 493.61 1,157.28 ** 4,000.00 Budgeted 2,842.72 Remaining 29 % Used Account: 135-65105-030-000 Printing 144.00 .00 144.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 144.00 ** 4,000.00 Budgeted 3,856.00 Remaining 4 % Used Account: 135-69005-030-000 Capital Outlays 7,841.00 .00 7,841.00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 7,841.00 ** 13,000.00 Budgeted 5,159.00 Remaining 60 % Used Account: 135-69170-030-000 Copier Lease Installments 451 12/14/2017 Dec A/P Copier lease 414.01 165.00 579.01 EVERBANK COMMERCIAL FINANCE 3769 AP 537 12/31/2017 December A/P Copies 65.66 644.67 KYOCERA DOCUMENT SOLUTIONS 3818 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 230.66 644.67 ** 4,600.00 Budgeted 3,955.33 Remaining 14 % Used Department 30 Totals: ----------------------------------- 327,533.87 ** 116,621.65 Monthly Total 1,227,112.00 Budgeted 899,578.13 Remaining 27 % Used Trophy Club Municipal Utility District No. 1 116 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 451 12/14/2017 Dec A/P Legal 8,239.69 6,919.30 15,158.99 McLean & Howard, L.L.P. 3778 AP 451 12/14/2017 Dec A/P Legal 2,100.00 17,258.99 McLean & Howard, L.L.P. 3778 AP _______________ Account: 135-55045-039-000 Legal Totals: 9,019.30 17,258.99 ** 137,000.00 Budgeted 119,741.01 Remaining 13 % Used Account: 135-55055-039-000 Auditing 14,400.00 .00 14,400.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 14,400.00 ** 24,500.00 Budgeted 10,100.00 Remaining 59 % Used Account: 135-55060-039-000 Appraisal 392 12/05/2017 Dec A/P 1st Qtr Budget Allocation 2,648.31 2,011.87 4,660.18 DENTON CENTRAL APPRAISAL DISTR 3727 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 4,660.18 ** 11,446.00 Budgeted 6,785.82 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 605 12/31/2017 Tax Collection fees/Denton Cty 2,968.40 2,968.40 GL _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 2,968.40 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 39,287.57 ** 13,999.57 Monthly Total 176,746.00 Budgeted 137,458.43 Remaining 22 % Used Fund 135 Totals: ----------------------------------- (370,460.51) (81,384.14) Monthly Total (194,618.00) Budgeted 175,842.51 Remaining 190 % Used Trophy Club Municipal Utility District No. 1 117 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 118 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET DECEMBER 2017 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS 1,322,095 ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,322,095 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 680,448 TOTAL LIABILITIES 680,448 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (350,932) TOTAL FUND BALANCE 641,647 TOTAL LIABILITIES AND FUND BALANCE 1,322,095 Trophy Club Municipal Utility District No. 1 119 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 20:22 01/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 1,353.26- 4,403.58- 4,403.58 Subtotal: 1,353.26- 4,403.58- 4,403.58 Program number: 1,353.26- 4,403.58- 4,403.58 Department number: Revenues 1,353.26- 4,403.58- 4,403.58 Revenues Subtotal ----------- 1,353.26- 4,403.58- 4,403.58 Trophy Club Municipal Utility District No. 1 120 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 20:22 01/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 40,812.03 355,335.78 355,335.78- Subtotal: 40,812.03 355,335.78 355,335.78- Program number: 40,812.03 355,335.78 355,335.78- Department number: Wastewater 40,812.03 355,335.78 355,335.78- Expenditures Subtotal ----------- 40,812.03 355,335.78 355,335.78- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 39,458.77 350,932.20 350,932.20- Trophy Club Municipal Utility District No. 1 121 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (3,050.32) (1,353.26) (4,403.58) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (1,353.26) (4,403.58) ** .00 Budgeted 4,403.58 Remaining 0 % Used Department Totals: ----------------------------------- (4,403.58) ** (1,353.26) Monthly Total .00 Budgeted 4,403.58 Remaining 0 % Used Trophy Club Municipal Utility District No. 1 122 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-69005-020-000 Capital Outlays 451 12/14/2017 Dec A/P WWTP Improvements less credit 314,523.75 40,812.03 355,335.78 CP&Y/WALLACE GROUP, INC. 3765 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 40,812.03 355,335.78 ** .00 Budgeted (355,335.78) Remaining 0 % Used Department 20 Totals: ----------------------------------- 355,335.78 ** 40,812.03 Monthly Total .00 Budgeted (355,335.78) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 350,932.20 39,458.77 Monthly Total .00 Budgeted (350,932.20) Remaining 0 % Used Trophy Club Municipal Utility District No. 1 123 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET DECEMBER 2017 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 4,496,529 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 4,496,529 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 270,948 TOTAL LIABILITIES 270,948 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 4,225,581 TOTAL LIABILITIES AND FUND BALANCE 4,496,529 Trophy Club Municipal Utility District No. 1 124 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET DECEMBER 2017 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 39,899 TOTAL LIABILITIES 39,899 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (39,899) TOTAL LIABILITIES AND FUND BALANCE 0 Trophy Club Municipal Utility District No. 1 125 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2017 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 470,876 ACCOUNTS RECEIVABLE - TOTAL ASSETS 470,876 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,578 NET REVENUES / EXPENDITURES 44,298 TOTAL FUND BALANCE 470,876 TOTAL LIABILITIES AND FUND BALANCE 470,876 Trophy Club Municipal Utility District No. 1 126 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 20:22 01/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 1,000.00- 1,000.00- 458.18- 1,214.70- 121.470 214.70 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 12,249.00- 25.000 36,747.00- 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 30,834.00- 25.000 92,502.00- Subtotal: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Program number: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Department number: 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Revenues Subtotal ----------- 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 14,819.18- 44,297.70- 25.557 129,034.30- Trophy Club Municipal Utility District No. 1 127 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 528-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (756.52) (458.18) (1,214.70) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (458.18) (1,214.70) ** (1,000.00) Budgeted 214.70 Remaining 121 % Used Account: 528-49142-000-000 Interfund transfer in-Water 504 12/27/2017 Texpool Transfers Dec (8,166.00) (4,083.00) (12,249.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (12,249.00) ** (48,996.00) Budgeted (36,747.00) Remaining 25 % Used Account: 528-49143-000-000 Interfund transfer in-WW 504 12/27/2017 Texpool Transfers Dec (20,556.00) (10,278.00) (30,834.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (30,834.00) ** (123,336.00) Budgeted (92,502.00) Remaining 25 % Used Department Totals: ----------------------------------- (44,297.70) ** (14,819.18) Monthly Total (173,332.00) Budgeted (129,034.30) Remaining 26 % Used Fund 528 Totals: ----------------------------------- (44,297.70) (14,819.18) Monthly Total (173,332.00) Budgeted (129,034.30) Remaining 26 % Used Trophy Club Municipal Utility District No. 1 128 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - I&S BALANCE SHEET DECEMBER 2017 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 453,387 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 300,745 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 758,705 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 300,745 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 300,745 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 425,619 TOTAL FUND BALANCE 457,960 TOTAL LIABILITIES AND FUND BALANCE 758,705 Trophy Club Municipal Utility District No. 1 129 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 20:22 01/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 669,660.00- 669,660.00- 360,254.67- 390,151.56- 58.261 279,508.44- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 197.35- 1,692.27- 94.015 107.73- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 69.83- 248.00- 12.400 1,752.00- Subtotal: 673,460.00- 673,460.00- 360,521.85- 392,091.83- 58.221 281,368.17- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 170.08- 243.04- 12.152 1,756.96- 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 11,094.81- 33,284.43- 27.273 88,758.57- Subtotal: 342,997.00- 342,997.00- 11,264.89- 33,527.47- 9.775 309,469.53- Program number: 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- Department number: Revenues 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 371,786.74- 425,619.30- 41.873 590,837.70- Trophy Club Municipal Utility District No. 1 130 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 20:22 01/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,150.00 2,150.00 2,150.00 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 283,508.00 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 Subtotal: 1,010,658.00 1,010,658.00 1,010,658.00 Program number: 1,010,658.00 1,010,658.00 1,010,658.00 Department number: Administration 1,010,658.00 1,010,658.00 1,010,658.00 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 1,010,658.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 371,786.74- 425,619.30- 7,339.529 419,820.30 Trophy Club Municipal Utility District No. 1 131 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 576 12/01/2017 Property Taxes (29,896.89) (509.49) (30,406.38) GL 577 12/04/2017 Property Taxes (1,587.34) (31,993.72) GL 578 12/05/2017 Property Taxes (1,809.43) (33,803.15) GL 579 12/06/2017 Property Taxes (4,207.78) (38,010.93) GL 580 12/07/2017 Property Taxes (2,054.08) (40,065.01) GL 617 12/07/2017 Property Taxes (2,054.08) (42,119.09) GL 618 12/07/2017 Reverse Property Taxes 580 2,054.08 (40,065.01) GL 581 12/08/2017 Property Taxes (3,582.45) (43,647.46) GL 582 12/11/2017 Property Taxes (5,418.52) (49,065.98) GL 583 12/12/2017 Property Taxes (4,880.83) (53,946.81) GL 610 12/12/2017 Property Taxes (4,880.83) (58,827.64) GL 611 12/12/2017 Reverse Property Tax 583 4,880.83 (53,946.81) GL 584 12/13/2017 Property Taxes (4,767.33) (58,714.14) GL 585 12/14/2017 Property Taxes (4,587.76) (63,301.90) GL 586 12/15/2017 Property Taxes (4,024.37) (67,326.27) GL 587 12/18/2017 Property Taxes (158,357.09) (225,683.36) GL 614 12/18/2017 Property Taxes (158,357.09) (384,040.45) GL 615 12/18/2017 Reverse Property Tax 587 158,357.09 (225,683.36) GL 588 12/19/2017 Property Taxes (3,089.84) (228,773.20) GL 589 12/20/2017 Property Taxes (7,414.75) (236,187.95) GL 590 12/21/2017 Property Taxes (2,534.31) (238,722.26) GL 591 12/22/2017 Property Taxes (13,889.70) (252,611.96) GL 612 12/22/2017 Property Taxes (13,889.70) (266,501.66) GL 613 12/22/2017 Reverse Property Tax 591 13,889.70 (252,611.96) GL 592 12/27/2017 Property Taxes (66,828.18) (319,440.14) GL 593 12/28/2017 Property Taxes (59,025.36) (378,465.50) GL 594 12/29/2017 Property Taxes (11,686.06) (390,151.56) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (360,254.67) (390,151.56) ** (669,660.00) Budgeted (279,508.44) Remaining 58 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 577 12/04/2017 Property Taxes (1,494.92) (13.35) (1,508.27) GL 578 12/05/2017 Property Taxes (7.96) (1,516.23) GL 579 12/06/2017 Property Taxes (3.01) (1,519.24) GL 585 12/14/2017 Property Taxes 93.74 (1,425.50) GL 589 12/20/2017 Property Taxes (41.35) (1,466.85) GL 591 12/22/2017 Property Taxes (166.52) (1,633.37) GL 612 12/22/2017 Property Taxes (166.52) (1,799.89) GL 613 12/22/2017 Reverse Property Tax 591 166.52 (1,633.37) GL 592 12/27/2017 Property Taxes (58.90) (1,692.27) GL Trophy Club Municipal Utility District No. 1 132 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (197.35) (1,692.27) ** (1,800.00) Budgeted (107.73) Remaining 94 % Used Account: 533-40015-000-000 Property Taxes/P & I 577 12/04/2017 Property Taxes (178.17) (6.14) (184.31) GL 578 12/05/2017 Property Taxes (2.13) (186.44) GL 579 12/06/2017 Property Taxes (.69) (187.13) GL 589 12/20/2017 Property Taxes (9.55) (196.68) GL 591 12/22/2017 Property Taxes (38.30) (234.98) GL 612 12/22/2017 Property Taxes (38.30) (273.28) GL 613 12/22/2017 Reverse Property Tax 591 38.30 (234.98) GL 592 12/27/2017 Property Taxes (13.02) (248.00) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (69.83) (248.00) ** (2,000.00) Budgeted (1,752.00) Remaining 12 % Used Account: 533-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (72.96) (170.08) (243.04) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (170.08) (243.04) ** (2,000.00) Budgeted (1,756.96) Remaining 12 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (218,954.00) Budgeted (218,954.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 504 12/27/2017 Texpool Transfers Dec (22,189.62) (11,094.81) (33,284.43) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (11,094.81) (33,284.43) ** (122,043.00) Budgeted (88,758.57) Remaining 27 % Used Department Totals: ----------------------------------- (425,619.30) ** (371,786.74) Monthly Total (1,016,457.00) Budgeted (590,837.70) Remaining 42 % Used Trophy Club Municipal Utility District No. 1 133 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 283,508.00 Budgeted 283,508.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 725,000.00 Budgeted 725,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,010,658.00 Budgeted 1,010,658.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (425,619.30) (371,786.74) Monthly Total (5,799.00) Budgeted 419,820.30 Remaining ########## Trophy Club Municipal Utility District No. 1 134 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET DECEMBER 2017 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 179,719 ACCOUNTS RECEIVABLE - TOTAL ASSETS 179,719 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,210 NET REVENUES / EXPENDITURES 163,509 TOTAL FUND BALANCE 179,719 TOTAL LIABILITIES AND FUND BALANCE 179,719 Trophy Club Municipal Utility District No. 1 135 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 20:22 01/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb.Month Total Budget Budget 534-49010-000-000 Interest Income 1,000.00- 1,000.00-134.53-216.13-21.613 783.87- 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00-54,430.72- 163,292.16-27.273 435,445.84- Subtotal:599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Program number:599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Department number: Revenues 599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Revenues Subtotal ----------- 599,738.00- 599,738.00-54,565.25- 163,508.29-27.263 436,229.71- Trophy Club Municipal Utility District No. 1 136 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 20:22 01/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 223,338.00 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 Subtotal: 598,738.00 598,738.00 598,738.00 Program number: 598,738.00 598,738.00 598,738.00 Department number: Administration 598,738.00 598,738.00 598,738.00 Expenditures Subtotal ----------- 598,738.00 598,738.00 598,738.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,565.25- 163,508.29- ############### 162,508.29 Trophy Club Municipal Utility District No. 1 137 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (81.60) (134.53) (216.13) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (134.53) (216.13) ** (1,000.00) Budgeted (783.87) Remaining 22 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 504 12/27/2017 Texpool Transfers Dec (108,861.44) (54,430.72) (163,292.16) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,430.72) (163,292.16) ** (598,738.00) Budgeted (435,445.84) Remaining 27 % Used Department Totals: ----------------------------------- (163,508.29) ** (54,565.25) Monthly Total (599,738.00) Budgeted (436,229.71) Remaining 27 % Used Trophy Club Municipal Utility District No. 1 138 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 534-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals:.00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals:.00 .00 ** 223,338.00 Budgeted 223,338.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals:.00 .00 ** 375,000.00 Budgeted 375,000.00 Remaining 0 % Used Department 51 Totals: -----------------------------------.00 ** .00 Monthly Total 598,738.00 Budgeted 598,738.00 Remaining 0 % Used Fund 534 Totals: -----------------------------------(163,508.29) (54,565.25) Monthly Total (1,000.00) Budgeted 162,508.29 Remaining ########## Trophy Club Municipal Utility District No. 1 139 of 164 January 16, 2018 - Regular Meeting Agenda Packet TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2017 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 76,875 ACCOUNTS RECEIVABLE - TOTAL ASSETS 76,875 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 75,923 TOTAL FUND BALANCE 76,875 TOTAL LIABILITIES AND FUND BALANCE 76,875 Trophy Club Municipal Utility District No. 1 140 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 20:22 01/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb.Month Total Budget Budget 535-49010-000-000 Interest Income 600.00-600.00-55.89-82.41-13.735 517.59- 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00-25,280.31- 75,840.93-27.273 202,243.07- Subtotal:278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Program number:278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Department number: Revenues 278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Revenues Subtotal ----------- 278,684.00- 278,684.00-25,336.20- 75,923.34-27.244 202,760.66- Trophy Club Municipal Utility District No. 1 141 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 20:22 01/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 12/2017 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb.Month Total Budget Budget 535-70005-051-000 Rev Bond Paying Agent Fee 400.00 400.00 400.00 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 62,684.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal:278,084.00 278,084.00 278,084.00 Program number:278,084.00 278,084.00 278,084.00 Department number: Administration 278,084.00 278,084.00 278,084.00 Expenditures Subtotal ----------- 278,084.00 278,084.00 278,084.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00-600.00-25,336.20- 75,923.34- ############### 75,323.34 ******* End of Report ********* Trophy Club Municipal Utility District No. 1 142 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-49010-000-000 Interest Income 603 12/31/2017 December Bank Interest (26.52)(55.89)(82.41)GL _______________ Account: 535-49010-000-000 Interest Income Totals:(55.89)(82.41) ** (600.00) Budgeted (517.59) Remaining 14 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 504 12/27/2017 Texpool Transfers Dec (50,560.62)(25,280.31) (75,840.93)GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals:(25,280.31) (75,840.93) ** (278,084.00) Budgeted (202,243.07) Remaining 27 % Used Department Totals: -----------------------------------(75,923.34) ** (25,336.20) Monthly Total (278,684.00) Budgeted (202,760.66) Remaining 27 % Used Trophy Club Municipal Utility District No. 1 143 of 164 January 16, 2018 - Regular Meeting Agenda Packet . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 20:23 01/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 12/2017 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 535-70005-051-000 Rev Bond Paying Agent Fee .00 .00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals:.00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals:.00 .00 ** 62,684.00 Budgeted 62,684.00 Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals:.00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: -----------------------------------.00 ** .00 Monthly Total 278,084.00 Budgeted 278,084.00 Remaining 0 % Used Fund 535 Totals: -----------------------------------(75,923.34) (25,336.20) Monthly Total (600.00) Budgeted 75,323.34 Remaining ########## Grand Totals: ---------------------------------------------------------------------------------------------------------(1,166,588.35) **** (1,024,139.98) Monthly Total (375,349.00) Budgeted 791,239.35 Remaining 311 % Used ******* End of Report ********* Trophy Club Municipal Utility District No. 1 144 of 164 January 16, 2018 - Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:December 2017 REVENUE VARIANCE:16.6% EXPENSE VARIANCE:34.9% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Fire 1,054,433 567,258 614,334 58.262%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent 323 2,577 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 138 476 10/2017 Fire Taxes Penalties &Interest collected FIRE EXPENSES Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed Trophy Club Municipal Utility District No. 1 145 of 164 January 16, 2018 - Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:December 2017 REVENUE VARIANCE:16.6% EXPENSE VARIANCE:34.9% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47070-000 TCCC Effluent Charges 60,000 8,570 9,118 15.20%11/2017 TCCC Effluent Collected EXPENSES WATER 135-50060-010 Pre-emp Physicals/Testing 200 163 163 81.53%12/2017 New Hire Operator 135-60360-010 Equipment/Furniture 2,500 5,020 5,020 200.79%12/2017 New Testing Machine, and Testing Pieces 135-69281-010 Water Tank Inspection Contract 118,775 41,944 107,864 90.81%12/2017 Last Tank For Inspection WASTEWATER 135-55090-020 Vehicle Maintenance 8,000 179 2,828 35.35%12/2017 Mustang Elite Car Service 135-60135-020 TCEQ Fees & Permits 85,000 (4,711) 30,023 35.32%12/2017 Refund Wastewater Renewal from CP&Y BOARD OF DIRECTORS 135-60245-026 Miscellaneous Expenses 2,000 1,022 1,022 51.09%12/2017 Renae Retirement Gift Card ADMINISTRATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed Trophy Club Municipal Utility District No. 1 146 of 164 January 16, 2018 - Regular Meeting Agenda Packet BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:December 2017 REVENUE VARIANCE:16.6% EXPENSE VARIANCE:34.9% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed 135-50070-030 Employee Relations 4,960$ 1,992$ 2,306$ 46.50%12/2017 Annual Christmas Party and Renae's Retirement Party 135-65090-030 Printer Supplies and Maint 2,000$ 98$ 1,658$ 82.90%11/2017 Ink Replacements Printers Non-Departmental 135-55060-039 Appraisal 11,446$ 2,012$ 4,660$ 40.71%12/2017 Denton Central Appraisal District 135-55065-039 Tax Admin Fees 3,800$ 2,968$ 2,968$ 78.12%12/2017 Interlocal Aggreement Denton County Tax Service Fees Trophy Club Municipal Utility District No. 1 147 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1    Date:  1/16/2017  To:  Board of Directors  From:  John Robert Carman  Subject: General Manager’s Report    Note:  General Manager’s report from December 19, 2017 failed to make it into the Board  Packet but was sent out to the Board via email.  I was asked to repeat it in this month’s Board  packet so that it became an official part of the Board record.  The portions of this report  repeated from last month are shown in italics at the end of each section.  Regulatory Updates  Sanitary Sewer Overflows (SSO) ‐ On December 23rd, we had an SSO at 1500 Plantation Oaks  Drive. The volume was estimated at 1106 gallons.  After the blockage was cleared, the site was  cleaned and the report was filed with TCEQ.  No other sanitary sewer overflows were observed  since the last Board meeting.  Breaks and Leaks – One break and one leak were observed since the last Board meeting.  The  break occurred when a contractor working in Hogan’s Glen hit our main during excavation.  The  leak occurred on Oak Hill Lane.  Both incidents triggered the TCEQ requirement to sample for  bacteria near the repair, and both samples came back negative so no further compliance action  was required.  Supplemental Environmental Project (SEP) – An SEP was conducted in lieu of paying the fine  assessed to the District by TCEQ for the incident where a tree limb fell from a tree and damaged  a sewer line in a remote area.  The SEP program is intended to allow permittee’s to direct fines  to system improvements, and in our situation, we lined a deteriorating manhole near the  wastewater treatment plant.  While this work was completed early in 2017, the hearing to  consider the Agreed Order was held in Austin on November 17, 2017.  The agreed order was approved, subject to the submission of documentation for the project.   While the documentation was submitted in August 2017, staff will resubmit to ensure it gets to  the correct parties.  Permit Renewal – As a part of settling the contested discharge permit renewal case, the District  committed to do two things: 1) post its discharge monitoring reports (DMRs) in the news  section of the public information link on the main web page for the District and 2) Apply for  Trophy Club Municipal Utility District No. 1 148 of 164 January 16, 2018 - Regular Meeting Agenda Packet technical, financial and regulatory compliance assistance through the free TCEQ program for  technical support.  If TCEQ approves this application, then we are to post it on our web site.  In the spirit of transparency, the staff has not only posted its DMRs on the web site since the  settlement agreement was reached, we posted all of them for 2017.  Furthermore, we have  chosen to post all regulatory compliance documentation associated with our discharge permit.   Recent biomonitoring testing and soil testing associated with irrigation with reuse water has  also been posted.  Going one step further, we have also chosen to post TCEQ compliance submissions for drinking  water even though this is not required under the settlement.  This data is posted and may be  seen today under the Regulatory Compliance tab accessible by clicking the Public Information  menu link.  The settlement calls for the information to posted one level down under the News  sub‐link, but staff felt that was too hard to find and gave it its own link under public  information.  Staff is discussing the possibility of rearranging the menus links themselves to  move compliance data up to the main menu page to make it easier to find.  Staff believes there  is a good story to be told and it should be visible in a more prominent way.  The application for technical assistance from TCEQ is not due until March 6th 2018.  Staff  anticipates no issues in complying with this provision of the settlement.              ________________  As previously noted, we have received our discharge permit renewal from TCEQ.  This discharge  permit, TPDES Permit No. WQ0011593001, replaces the permit last issued on November 29,  2011 and expires at midnight on September 1, 2021.  In a separate matter, an anonymous complaint was filed with TCEQ regarding alleged violations  of the Safe Drinking Water Act arising from failure to issue boil orders after main breaks.  TCEQ  investigated the matter and found that we were in compliance.  The letter from TCEQ is  attached.  In the last meeting of the Board, I reported verbally on the costs of legal counsel and expert  witness associated with the discharge permit renewal case.  Subsequently I was asked to take a  look at the same costs associated with PUC Rate case.    Case       Expert Witness and Attorney Costs*  PUC Rate Case        $ 133,607.75  Permit Renewal Case       $   48,134.33  *  These costs do not reflect staff time costs      Trophy Club Municipal Utility District No. 1 149 of 164 January 16, 2018 - Regular Meeting Agenda Packet Classification and Compensation Study  Staff has been working with the Segal preparing and updating job descriptions for each  position.  We have also been working on a draft list of organizations which will be surveyed as a  part of our Classification and Compensation Study.  Our objective is to get to eight (8)  comparable organizations that we compete for talent with, and that have similar positions to  ours.  The draft list is attached to this report and staff would appreciate it if Board members wishing  to provide input on this list do so directly, either in a phone call or via email, in the next week to  10 days.  Once the list is finalized and the job descriptions are completed, the Segal team will  conduct the interviews.  Since working with us results in expenditure of resources by staff for other organizations, often  their human resources and financial staff resources, commitment to participate in the survey  often leads to a request for a copy of the study outcome.  Staff supports this and anticipates  providing a copy of the study results at the conclusion to those survey partners who request it.    _________________  One of the objectives set for the General Manager was to look at the organization of staff and  recommend changes to enable employee and leadership development, and succession planning.   To that end, my review of the job descriptions, minimum qualifications and the associated salary  range data being used suggests a need to update all three.   Attached are 1) a statement of qualifications for the consultant I am planning on engaging for  this work, and 2) the contract and scope of work.  After negotiations with the consultant, we  have settled on a fee for the work that fits within my discretionary line item in the budget.   While this work is within my expenditure authority, it seemed prudent to let the Board know in  advance of my intention to proceed with this study.    Capital Improvement Projects   WWTP – Partial substantial completion for Phase 1 of the project was signed by the engineer  and owner on January 9, 2018.  Withheld from substantial completion in Phase 1 were the  permeate pumps, the waste activated sludge pumps and the membranes themselves.   Substantial completion on the pumps will be issued once they are determined to meet the  performance specification, and the membranes when we can be assured in writing that the  vendor will stand behind the warranty.  Our engineer, with staff concurrence, set out some conditions under which we are comfortable  moving forward with phase 3 of the project even though phase 2 is not substantially complete.   We hope to hear back from the contractor on that soon.  The contractor, at our direction has  drained and cleaned the basin for phase 3.  Once the conditions are satisfied we will authorize  the demolition aspects of phase 3.  Trophy Club Municipal Utility District No. 1 150 of 164 January 16, 2018 - Regular Meeting Agenda Packet High Service Booster Pump – Bids were opened yesterday for the high service booster pump  project which had a construction budget of $350,000.  Four bidders participated in the bidding,  and the low bid came in at $513,700.  Discussions with the bidders led the conclusion that the  discrepancy between the installation schedule and the lead time needed to procure and deliver  the pumps may have led to higher than anticipated bid costs.  Our staff and engineer are going  back to the drawing board to see if changes to the bidding documents can be made to produce  a more attractive bid in alignment with our budget.  Joint Projects with Town  Two of our budgeted projects with the Town of Trophy Club were bid on January 5, 2018.   These projects were the Indian Creek Drive (from Fair Green Drive to Meadowbrook Drive) and  Phoenix Drive (from Pebble Beach Drive to Shields Drive).The lowest qualified base bid came in  at $426,022.50 with an additive alternate bid of $36,565.00.  Our budget for these projects was  $410,000.  Installation of the new pipe may require the removal of some trees in our  easements.  The alternate bid reflects the additional costs that would be incurred if the boring  under the trees was required instead of removal.  Staff maintains that trees in the easement  could be removed if they interfere with construction of the replacement line.  Trophy Club Municipal Utility District No. 1 151 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club MUDComparable Employers ‐ Compensation Study 2018OrganizationCity LocatedCity Population in 20102016 City Population EstimateCity Population Change Since 2010Proximity to Trophy MUDServicesDecember 2017 ERI Factor (Cost of Labor Comparison)Geographic Differential1American Water Works Association (AWWA) (10,000-100,000 level)US Average NA NA NA NAWater and WastewaterNA NA2 Benbrook Water Authority Benbrook, TX 21,234 22,403 105.5% 41 MilesWater and Wastewater97.0 103.4%3 City of Aledo, Texas Aledo, TX 2,716 3,190 117.5% 40 MilesWater and WastewaterNA NA4 City of Fort Worth, Texas Fort Worth, TX 741,206 815,930 110.1% 25 MilesWater and Wastewater97.2 103.2%5 City of Grapevine, Texas Grapevine, TX 46,334 50,538 109.1% 9 MilesWater and Wastewater97.0 103.4%6 City of Keller, Texas Keller, TX 39,627 44,250 111.7% 7 MilesWater and Wastewater97.2 103.2%7 City of Lewisville, Texas Lewisville, TX 95,290 102,327 107.4% 20 MilesWater and Wastewater101.0 99.3%8 City of Mansfield, Texas Mansfield, TX 56,368 63,141 112.0% 36 MilesWater and Wastewater98.5 101.8%9 City of Roanoke, Texas Roanoke, TX 5,962 7,055 118.3% 3 MilesWater and Wastewater100.6 99.7%10 City of Southlake, Texas Southlake, TX 26,575 29,101 109.5% 7 MilesWater and Wastewater98.4 101.9%11 Town of Flower Mound, Texas Flower Mound, TX 64,669 69,966 108.2% 16 MilesWater and Wastewater102.3 98.0%12 Town of Northlake, Texas Northlake, TX 1,724 2,894 167.9% 15 MilesWater and WastewaterNA NA13 Town of Westlake, Texas Westlake, TX 992 1,124 113.3% 1 MileWater and WastewaterNA NA14 Trinity River Authority Arlington, TX 365,438 383,899 105.1% 26 MilesWater and Wastewater97.0 103.4%Data collected from: http://factfinder.census.gov/ and ERI Geographic AssessorUtilitiesDoc ID:5715280v3Trophy Club Municipal Utility District No. 1152 of 164January 16, 2018 - Regular Meeting Agenda Packet FY October November December January February March April May June July August September Total Year 2008 63,250 47,082 33,371 37,194 31,472 30,766 40,313 48,829 78,091 91,664 115,042 75,494 692,568 2009 63,730 48,170 35,215 35,759 32,240 39,331 46,151 37,382 56,370 125,089 91,724 79,137 690,298 2010 39,794 39,713 29,547 30,305 25,328 23,279 41,646 53,439 102,921 89,760 128,687 82,331 686,750 2011 70,502 50,909 44,365 35,983 27,845 55,972 69,165 61,467 99,326 117,707 170,464 123,692 927,397 2012 85,869 53,571 40,815 30,616 31,665 35,263 47,194 84,905 114,104 137,174 144,573 108,622 914,371 2013 85,488 75,251 48,527 39,601 34,450 43,137 56,947 76,542 85,312 110,072 130,945 114,497 900,769 2014 82,660 48,813 34,482 39,767 37,085 54,794 66,337 84,384 99,240 92,913 113,135 110,873 864,483 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 200,471 FY October November December January February March April May June July August September Total Year 2008 64,370 50,090 35,320 36,610 34,630 34,750 42,900 63,116 78,399 114,256 98,670 72,551 725,662 2009 65,110 48,570 36,411 36,587 36,385 44,120 48,881 38,250 66,450 116,823 94,525 81,500 713,612 2010 40,803 41,600 32,700 31,400 30,145 27,240 43,400 62,646 113,049 94,950 131,650 76,159 725,742 2011 70,502 50,993 44,220 33,789 36,053 54,775 71,306 63,500 116,350 152,002 169,621 117,190 980,301 2012 83,750 54,245 41,650 34,740 31,581 46,519 62,649 100,402 110,324 153,813 139,005 123,045 981,723 2013 85,966 77,758 55,110 39,283 37,867 56,743 60,969 87,168 96,602 119,414 145,988 120,342 983,210 2014 81,909 51,769 39,769 48,758 42,395 61,100 71,283 96,481 95,206 110,173 123,369 115,607 937,819 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 225,466 FY October November December January February March April May June July August September 2008 2869 2857 2867 2853 2865 2865 2855 2897 2897 2914 2927 2929 2009 2946 2952 2956 2976 2977 3013 3014 3004 3056 3064 3083 3105 2010 3113 3127 3146 3151 3168 3201 3210 3229 3251 3260 3282 3298 2011 3318 3334 3351 3358 3366 3392 3409 3465 3433 3471 3559 3573 2012 3542 3540 3582 3640 3667 3701 3725 3735 3759 3796 3815 3863 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 2014 MUD 3014 3015 3014 3028 3026 3031 3037 3052 3058 3072 3078 3080 2014 PID 1125 1142 1159 1178 1183 1188 1203 1216 1222 1236 1255 1259 2015 Total 4353 4363 4377 4404 4413 4429 4443 4459 4478 4486 4498 4517 2015 MUD 3083 3087 3095 3119 3120 3122 3123 3128 3133 3134 3137 3149 2015 PID 1270 1276 1282 1285 1293 1307 1320 1331 1345 1352 1361 1368 2016 Total 4531 4538 4556 4568 4593 4604 4607 4616 4622 4627 4632 4636 2016 MUD 3155 3158 3167 3172 3176 3181 3183 3186 3188 3192 3196 3200 2016 PID 1376 1380 1389 1396 1417 1423 1424 1430 1434 1435 1436 1436 2017 Total 4644 4647 4661 4657 4663 4666 4670 4676 4685 4690 4696 4700 2017 MUD 3208 3210 3220 3216 3221 3224 3228 3234 3242 3247 3252 3256 2017 PID 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 2018 Total 4701 4706 4712000000000 2018 MUD 3257 3262 3268 2018 PID 1444 1444 1444 Monthly Water Operations Report FY 2018 Water Billed Water Pumped Active Connections 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September WATER BILLED IN MILLIONS OF GALLONS 2014 2015 2016 2017 2018 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September WATER PUMPED IN MILLIONS OF GALLONS 2014 2015 2016 2017 2018 Trophy Club Municipal Utility District No. 1 153 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 154 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 155 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 156 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 157 of 164 January 16, 2018 - Regular Meeting Agenda Packet Trophy Club Municipal Utility District No. 1 158 of 164 January 16, 2018 - Regular Meeting Agenda Packet Language Sessions % Sessions 1.en-us 2,107 98.05% 2.en-gb 10 0.47% 3.zh-cn 10 0.47% 4.(not set)6 0.28% 5.c 2 0.09% 6.fr 2 0.09% 7.ko 2 0.09% 8.de-de 1 0.05% 9.en 1 0.05% 10.es-xl 1 0.05% Audience Overview Dec 1, 2017 - Dec 31, 2017 Overview  Sessions …Dec 8 Dec 15 Dec 22 Dec 29 100100 200200 Sessions 2,149 Users 1,687 Pageviews 3,799 Pages / Session 1.77 Avg. Session Duration 00:01:20 Bounce Rate 69.57% % New Sessions 46.72% Returning Visitor New Visitor 46.7% 53.3% © 2018 Google All Users 100.00% Sessions Trophy Club MUD All Web Site Data GO TO REPORT Trophy Club Municipal Utility District No. 1 159 of 164 January 16, 2018 - Regular Meeting Agenda Packet Page Pageviews % Pageviews 1.1,965 51.72% 2.285 7.50% 3.176 4.63% 4.156 4.11% 5.121 3.19% 6.112 2.95% 7.76 2.00% 8.70 1.84% 9.68 1.79% 10.38 1.00% Overview Dec 1, 2017 - Dec 31, 2017 Overview  Pageviews …Dec 8 Dec 15 Dec 22 Dec 29 200200 400400 Pageviews 3,799 Unique Pageviews 3,216 Avg. Time on Page 00:01:44 Bounce Rate 69.57% % Exit 56.57% / /customer-service/email-bills-and-online-payments/ /my-account/ /customer-service/contact-us-2/ /public-informatio/agendas-meetings-online/ /my-account/about-your-bill/ /services/water/ /administratio/staff/ /customer-service/establish-service/ /customer-service/form/ © 2018 Google All Users 100.00% Pageviews Trophy Club MUD All Web Site Data GO TO REPORT Trophy Club Municipal Utility District No. 1 160 of 164 January 16, 2018 - Regular Meeting Agenda Packet October November December January February March April May June July August September ebills 796 828 829 Bills Mailed 3906 3900 3912 Bank Draft 631 623 639 Credit Card Draft 1018 1020 1026 Online Payments 1037 1079 1,072 Late Notices 391 420 457 Disconnects 25 27 27 M 3257 3262 3268 Connections P 1444 1444 1444 October November December January February March April May June July August September ebills 758 758 778 780 780 799 810 819 821 809 820 819 Bills Mailed 3870 3866 3900 3884 3875 3876 3877 3890 3907 3903 3920 3910 Bank Draft 624 610 623 608 617 620 622 626 637 645 641 631 Credit Card Draft 882 897 949 944 945 927 964 960 964 969 978 1011 Online Payments 1041 1057 1,029 1,028 1,025 1,062 1,027 1,062 1,071 1065 1075 1087 Late Notices 506 455 471 382 491 500 476 439 435 466 406 467 Disconnects 30 37 37 44 35 51 61 40 45 44 23 11 3208 3210 3214 3216 3221 3224 3228 3234 3242 3247 3252 3256 Active Connections 1436 1437 1441 1441 1442 1442 1442 1442 1443 1443 1444 1444 Trophy Club MUD #1 Utility Billing Report Fiscal Year 2018 Fiscal Year 2017 Trophy Club Municipal Utility District No. 1 161 of 164 January 16, 2018 - Regular Meeting Agenda Packet MUD Permits Month: December 2017 Date of Permit Permit No. Customer Deposit 135-25030 Due to FW Water 135- 20500 Oversize Meter 135-49075 Plumbing Inspections 135- 47035 Sewer Inspections 135- 47045 Fire Line 135-49900 Misc Income 135-49900 Total 12/21/2017 2018-0019 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 12/19/2017 2018-0017 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 12/14/2017 2018-0016 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 12/14/2017 2018-0015 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 12/14/2017 2018-0014 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 800.00$ 2,591.00$ 12/14/2017 2018-0011 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 800.00$ 2,591.00$ 12/14/2017 2018-0010 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 12/5/2017 2018-0013 820.00$ -$ 859.76$ 150.00$ 50.00$ 1,879.76$ 12/5/2017 2018-0012 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ Total 1,420.00$ 9,384.00$ 3,603.76$ 1,350.00$ 450.00$ 1,600.00$ -$ 17,807.76$ Trophy Club Municipal Utility District No. 1 162 of 164 January 16, 2018 - Regular Meeting Agenda Packet 135-10154 Bank of the West-THB (X6718) 3 yr CD $35,316 $0 $35,316 135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $714,332 $714,332 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $1,304,616 $1,304,616 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $596,426 $0 $596,426 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $1,322,095 $0 $1,322,095 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$4,496,529 $0 $4,496,529 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $470,876 $0 $470,876 533-10250 TexPool Tax I & S (XXXXX0003)$453,387 $0 $453,387 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $179,719 $0 $179,719 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $76,875 $0 $76,875 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$314,100 $1,340,854 $1,654,954 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$581,493 $0 $581,493 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 $8,531,389 $3,360,402 $11,891,790 Amount available in cash (MUD Accounts)$3,360,402 Amount available for spending (MUD Accounts)$3,360,402 * 12/31/2017 Customer Water Deposits $314,100 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $762,115 $762,115 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $762,115 $762,115 Amount available in cash (Fire Department Accounts)$762,115 Amount available for spending (Fire Department Accounts)$762,115 714,332$ Bank of the West MM 1,340,854$ Prosperity General Fund 1,304,616$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 3,360,402$ Nonspendable Fund Balance (Prepaids)$3,486 Assigned Fund Balance (FY2018 Capital Projects plus prior year carry forward)1,778,760$ Unassigned Fund Balance 2,368,122$ Current Year Revenue/Expenses 370,461$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $4,520,829 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF DECEMBER 2017 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) Trophy Club Municipal Utility District No. 1 163 of 164 January 16, 2018 - Regular Meeting Agenda Packet February 2018CalendarsFS Conference RoomFS Training RoomPS Large Conference RoomSvore Board RoomSunMonTueWedThuFriSat56789Jan 28, 2018293031Feb 12310:30am Parks/Re9am Mgt Team Me7am FD Officers M7pm Trophy Club W4567891010:30am Parks/Re7pm (No title) (Fred Z9am Mgt Team Me111213141516179am EMS Training10:30am Parks/Re7pm TCEVA Meeti9am EMS Training9am Mgt Team Me9am EMS Training1819202122232410:30am Parks/Re6pm Trophy Club M6pm Lakes of Trop9am Mgt Team Me10am Special Eve25262728Mar 12310:30am Parks/Re9am Mgt Team Me7am FD Officers M7pm Trophy Club WPowered byTC Meeting Spaces1/9/2018Trophy Club Municipal Utility District No. 1164 of 164January 16, 2018 - Regular Meeting Agenda Packet