Loading...
HomeMy WebLinkAbout2018-1015 October 15, 2018 Regular Meeting Agenda Packet        BOARD OF DIRECTORS  REGULAR MEETING    TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  100 MUNICIPAL DRIVE  TROPHY CLUB, TEXAS 76262     Monday, October 15, 2018        6:30 P.M.                                     Svore Municipal Boardroom    REGULAR MEETING AGENDA   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 comments made to the Board at this time  concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to  the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the  President or presiding officer. To speak during this item, you must complete the Speaker’s form that includes  the topic(s) of your statement.  Citizen Comments should be limited to matters over which the Board has  authority.     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 Age nda.   a. September 2018 Check Register  b. September 17, 2018 Regular Meeting Minutes  c. Tax Collections Report – 4th Quarter FY2018  d. Quarterly Investment Report – 4th Quarter FY2018    attachments:     Check Register    Regular Meeting Minutes    Tax Collections Report    Quarterly Investment Report    REGULAR SESSION  2. Introduction of new Wastewater Superintendent Frank Isola. (Staff)    3. Receive presentation and update from Leah Hodge PE with Halff and Associates regarding Design and  Construction of Water Transmission Line to elevated water tank located on T.W. King Road.    attachments:     Interconnect Waterline Probable Cost    4. Consider and take appropriate action regarding approval of acquisition of a 2019 Dodge 1500 Quad Cab  October 15, 2018 Regular Meeting Agenda Packet 1 of 171     truck for the water department to be purchased through the Buy Board contract at Grapevine Dodge  Chrysler Jeep for an amount of $26,571. (Staff)    attachments:    Staff Report            Buy Board Summary vehicle summary    5. Discussion and possible action regarding access to wastewater plant during rain event. (Staff)    6. Consider and take appropriate action regarding the following engineering matters: (Staff)    a. Request by CP&Y for Additional Engineering Fees relating to Preparation of Application to the Texas  Commission on Environmental Quality for Approval for Issuance of Bonds by the District.  b. Request by CP&Y for Approval of Amendment No. 5 to Contract for Professional Engineering Services  related to Wastewater Treatment Plant Project to authorize payment of additional engineering fees  for construction phase services.  c. Agreement with Halff Associates, Inc. for Professional Engineering Services to be implemented on a Task  Order Basis.    attachments:     CP&Y Amendment to Task Order 3         CP&Y Addendum 5 – Additional Engineering fee         Halff Associates Master Engineering Contract    7. Consider and take appropriate action regarding the September 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance     attachments:     Combined Financials   Combined Variance    REPORTS & UPDATES  8. General Manager Monthly Reports and Update:  a. Regulatory Update  b. Capital Improvement Projects    Interconnect Water Transmission Line Phase 1   Interconnect Water Transmission Line Phase 2   Wastewater Treatment Plant Upgrade Project   High Service Pump    Joint Projects with Town  c. Fire Department Summary  d. Water System Operations  e. Wastewater System Operations  f. Finance Update   Utility Billing Report   Permits Collected  October 15, 2018 Regular Meeting Agenda Packet 2 of 171      Cash Report          attachments:     General Manager Report    Water Operations Report    Wastewater Operations Report    Utility Billing Report    Permits Collected    Cash Report    EXECUTIVE SESSION  9. 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. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant  County, 141st Judicial District (Cause No. 141‐299351‐18).    c. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy  Club Drive, Trophy Club Texas    10. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,  exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental  effect on the position of the governmental body in negotiations with a third person:    a. District real property located at 100 Municipal Drive and 1501 Junction Way.    REGULAR SESSION  11. Consider and take appropriate action on matters deliberated in Executive Session:    12. Items for future agendas:     13. Consider and take appropriate action regarding rescheduling November and December meeting dates  for the Board of Directors of the District.      attachments:    November Meeting Calendar            December 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,  October 15, 2018 Regular Meeting Agenda Packet 3 of 171     DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION.  THIS NOTICE  MODIFIES  THE  DISTRICT'S  PRIOR  PRACTICE  OF  SPECIFICALLY  IDENTIFYING  ALL  AGENDA  ITEMS  TO  BE  DISCUSSED IN EXECUTIVE SESSION.    ADJOURN    October 15, 2018 Regular Meeting Agenda Packet 4 of 171 October 15, 2018 Regular Meeting Agenda Packet 5 of 171 October 15, 2018 Regular Meeting Agenda Packet 6 of 171 October 15, 2018 Regular Meeting Agenda Packet 7 of 171 October 15, 2018 Regular Meeting Agenda Packet 8 of 171 October 15, 2018 Regular Meeting Agenda Packet 9 of 171 October 15, 2018 Regular Meeting Agenda Packet 10 of 171 October 15, 2018 Regular Meeting Agenda Packet 11 of 171 October 15, 2018 Regular Meeting Agenda Packet 12 of 171 October 15, 2018 Regular Meeting Agenda Packet 13 of 171 October 15, 2018 Regular Meeting Agenda Packet 14 of 171 October 15, 2018 Regular Meeting Agenda Packet 15 of 171     PUBLIC HEARING REGULAR MEETING MINUTES  TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   September 17, 2018 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 a  Public  Hearing  and  Regular  Meeting  on  September  17,  2018  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:  Gregory Wilson  President  William C. Rose  Vice President  Kelly Castonguay  Director    BOARD MEMBERS ABSENT:  Steve Flynn  Secretary/Treasurer  Mark Chapman  Director      STAFF PRESENT:  John Carman  General Manager  Laurie Slaght  District Secretary  Mike McMahon  Water Superintendent  Steven Krolczyk  Finance Manager  Tony Corbett  Legal Counsel    GUESTS PRESENT:   Chris Ekrut  NewGen Strategies  Andrew Friedman    Samco Capital Marketing    CALL TO ORDER AND ANNOUNCE A QUORUM   President Wilson announced the date of September 17, 2018, called the meeting to order and announced a  quorum present at 6:34 p.m.    CITIZEN COMMENTS    Luanne Wing  1115 Wilshire Drive      PUBLIC HEARING  1. Trophy Club Municipal Utility District No. 1 will conduct a Public Hearing regarding adoption of the final  District Tax Rates for Tax Year 2018.    Director Wilson opened the Public Hearing at 6:35 p.m.     October 15, 2018 Regular Meeting Agenda Packet 16 of 171     There were no speakers for the Public Hearing    Director Wilson closed the Public Hearing at 6:36 p.m.    CONSENT AGENDA  2. Consider and take appropriate action to approve the Consent Age nda.   a. August 2018 Check Register  b. August 20, 2018 Regular Meeting Minutes     Motion made by Director Rose and seconded by Director  Castonguay to approve the consent agenda as  presented.    Motion carried unanimously     REGULAR SESSION  3. Receive  report  from  District  Rate  Consultant  regarding  proposed  water  and  sewer  rate  recommendations.     Chris Ekrut, Director at NewGen Strategies and Rate Consultant to the District presented proposed water  and sewer rates for FY2019 and answered questions related thereto.    Discussion Only, No Action Taken    4. Receive report from District Financial Advisor regarding outstanding District debt, issuance of proposed  revenue bonds, debt service funding obligations, future capital improvement project financing, and  general District financial recommendations.    Andrew Friedman, Managing Director at SAMCO Capital Markets and Financial Advisor to the District  provided an update to the board regarding the upcoming bond issuance and answered questions related  thereto.  Mr. Friedman stated that he has reviewed the proposed FY19 Budget and feels the District  meets the revenue requirements for the upcoming bond issuance.     Discussion Only, No Action Taken    5. Consider and take appropriate action to approve Resolution No. 2018‐0917A amending the Fiscal Year  2018 Budget.    Steven  Krolcyzk,  Finance  Manager  reviewed  the  amendments  to  the  Fiscal  Year  2018  Budget  and  answered questions related thereto.      Motion made by Director Rose and seconded by Director Castonguay to approve Resolution No. 2018‐ 0917A amending the Fiscal Year 2018 Budget.     October 15, 2018 Regular Meeting Agenda Packet 17 of 171     Motion carried unanimously    6. Consider and take appropriate action  regarding adoption of Resolution No.  2018‐0917B approving  Budget for Fiscal Year 2019.    Motion made by Director Rose and seconded by Director Castonguay to adopt  Resolution No. 2018‐0917B  approving Budget for Fiscal Year 2019 using option 3 for the water and sewer rate increase.    For: Rose, Castonguay  Opposed: Wilson    Motion Failed 2‐1    Motion made by Director Wilson to approve the fiscal year budget as presented with option 2 for the  water and sewer rates.    Motion died for lack of a second.     Motion made by Director Rose and seconded by Director Castonguay to adopt  Resolution No. 2018‐0917B  approving Budget for Fiscal Year 2019 using option 3 for the water and sewer rate increase.    For: Rose, Castonguay  Opposed: Wilson    Motion Failed 2‐1    Motion by director Wilson to approve the FY budget using Option 2 for the water and sewer increase.  Motion dies for the lack of a second.     Motion by Wilson seconded by Director Rose to adopt Resolution No. 2018‐0917B approving Budget for  Fiscal Year 2019 using option 2 for the water and sewer rate increase.    Motion carried unanimously    7. Consider and take appropriate action to adopt Rate Order No. 2018‐0917A amending water and sewer  rates and setting an effective date of October 1, 2018.    Motion made by Director Wilson and seconded by Director Rose to adopt Rate Order No. 2018‐0917A  amending water and sewer rates and setting an effective date of October 1, 2018.     Amendment to the Motion     Motion by Director Rose and seconded by Director Castonguay to amend Section 1.10 of Rate Order 2018‐ October 15, 2018 Regular Meeting Agenda Packet 18 of 171     0917A to read as follows: 1.10 FORT WORTH IMPACT FEE.  Each customer requesting an initial connection  to the Districts water system shall also pay to the District the applicable City of Fort Worth Impact Fee.   Motion to amend Section 1.10 of the Rate Order carried unanimously    Motion to adopt Rate Order 2018‐0917A as amended carried unanimously    8. Consider and take appropriate action regarding Order No. 2018‐0917B, fixing and levying Trophy Club  Municipal Utility District No. 1 Debt Service Tax Rate and Operations and Maintenance Tax Rate for 2018  Tax Year.    Motion made by Director Rose and seconded by Director Castonguay to approve Order No. 2018‐0917B,  fixing and levying Trophy Club Municipal Utility District No. 1 Debt Service Tax Rate and Operations and  Maintenance Tax Rate for 2018 Tax Year.    Motion carried unanimously    9. Consider and take appropriate action regarding approval of amendment to District Information Form,  including Notice to Purchaser Form.    Motion made by Director Wilson and seconded by Director Castonguay to approve the amendment to  District Information form including Notice to Purchaser Form with a rate of .11618 per $100 valuation.    Motion carried unanimously    10. Consider and take appropriate action regarding adoption of Resolution 2018‐0917C approving FY 2018  Tax Roll for Trophy Club Municipal Utility District No. 1.    Motion  made  by  Director  Wilson  and  seconded  by  Director  Rose  to  adopt  Resolution  2018‐0917C  approving FY 2018 Tax Roll for Trophy Club Municipal Utility District No. 1.    Motion carried unanimously    11. Consider and take appropriate action regarding annual review of District Investment Policy and  Investment Strategies including:  a. Appoint District Investment Officer(s).   b. Order No. 2018‐0917C Adopting Amended and Restated Investment Policy.    Motion  made  by  Director  Rose  and  seconded  by  Director  Wilson  to  approve Order No. 2018‐0917C  Adopting Amended and Restated Investment Policy.      Amendment to the Motion      Motion made by Director Rose second by Director Castonguay to amend the Section 7.02 Investment  October 15, 2018 Regular Meeting Agenda Packet 19 of 171     Training and delete board appointed treasurer 7.02 and treasurer in sentenance 2.    For: none  Opposed: Rose, Wilson and Castonguay    Motion to amend Section 7.02 of the Investment Policy Failed 0‐3    Motion approve Order No. 2018‐0917C carried unanimously    12. Consider and take appropriate action regarding adoption of Order No. 2018‐0917D Approving Cash  Reserve Policy.     Motion made by Director Rose  and seconded by Director Castonguay delegate Director Rose and Director  Flynn work with the General Manager and Finance Manager to work on a reserve policy to bring back to  the Board for approval.    Motion carried unanimously    13. Consider and take appropriate action regarding the August 2018 combined financials and variance  report.   a. Combined financials   b. Variance report    Motion  made  by  Director  Rose  and  seconded  by  Director  Castonguay  to  approve  the  August  2018  Combined Financials and Variance Report.    Motion carried unanimously    REPORTS & UPDATES  14. General Manager Monthly Reports and Updates   a. Regulatory Update  b. Capital Improvement Projects    Interconnect Water Transmission Line Phase 1   Interconnect Water Transmission Line Phase 2   Wastewater Treatment Plant Upgrade Project   Joint Projects with Town  c. Fire Department Summary  d. Water System Operations  e. Wastewater System Operations  f. Finance Update   Utility Billing Report   Permits Collected   Cash Report  October 15, 2018 Regular Meeting Agenda Packet 20 of 171     General Manager John Carman presented his monthly update to the Board and answered questions  related thereto.     The Board convened into Executive Session at 9:18 P.M.    EXECUTIVE SESSION  15. 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. Trophy Club Municipal Utility District No. 1 v. Acadia Services, LLC, In the District Court of Tarrant  County, 141st Judicial District (Cause No. 141‐299351‐18).  c. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy  Club Drive, Trophy Club Texas.    16. Pursuant to Section 551.072 of the Texas Open Meetings Act, the Board may deliberate the purchase,  exchange, lease, or value of real property if deliberation in an open meeting would have a detrimental  effect on the position of the governmental body in negotiations with a third person:    a. District real property located at 100 Municipal Drive and 1501 Junction Way.    The Board convened into Regular Session at 9:52 p.m.    REGULAR SESSION  Director Wilson stated that no final decisions, actions or votes were taken in Executive Session.    17. Consider and take appropriate action on matters deliberated in Executive Session:    No action was taken     18. Items for future agendas:  Director Rose would like to discuss rebranding.    19. Review and set future Meeting dates: Regular Board Meeting – Monday, October 15, 2018 at 6:30 p.m.    ADJOURN    Motion made by Director Rose and seconded by Director Castonguay to adjourn the meeting.    Motion carried unanimously  October 15, 2018 Regular Meeting Agenda Packet 21 of 171       Director Wilson adjourned the Meeting at 9:52 p.m.        ___________________________  Gregory Wilson, President                                                                                                         (SEAL)    ____________________________                                                 Steve Flynn, Secretary/Treasurer                                                                                                                                   ____________________________  Laurie Slaght, District Secretary    October 15, 2018 Regular Meeting Agenda Packet 22 of 171 PERDUE RANDON FIELDER(OLUNS&MOTT LLP ATTORNEYS AT LAW David S. Crawford Attorney at Law 500 East Border, Suite 640 Arlington, Texas 76010 p: 817-461-3344 f: 817-860-6509 w: www.pbfcm.com October 9, 2018 Mr. Steven Krolczyk Trophy Club MUD No. 1 1 00 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 2017, as well as a delinquent tax roll for only the 2017 tax year. This update is good through September 30, 2018. Through our collection efforts, we have reduced the 2017 tax base from $5,630.81 to $4,509.41 in the delinquent collection year from July 1, 2018 through September 30, 2018. This results in a collection percentage of 19.92%. 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 201 7 alone, this amounts to $2,041.59. The ALL year total of deferred base tax is $18,230.27. 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, L.L.P. £lJ J. (V /) # DavidS. Crawfor;;-r AMARILLO ARLINGTON AUSTIN CONROE EDINBURG GARLAND HOUSTON LUBBOCK MIDLAND SAN ANTONIO TYLER WICHITA FALLS October 15, 2018 Regular Meeting Agenda Packet 23 of 171 ER UE F~ElDER LtP ATTORNEYS AT lAl'l' AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 10/9/2018, Last Tax Year Included 2017 4.71% 0.01% 9.41% 69.64% 7.06% 13.25% 0.00% 0.00% 21.18% 4.41% 14.12% 4.92% 43.53% 7.77% $0.01 -$1 00.00 $1 00.01 -$250.00 $1,371.27 5.24% $250.01 -$500.00 $3,309.15 12.64% $500.01 -$1 000.00 $1,566.20 5.98% $1000.01 -$2500.00 $3,643.8 13.92% $2500.01 -$5000.00 28.92% $5000.01 -$10,000.00 30.51 Totals 100.00% 100.00%, As Of 10/9/2018 Total Base Tax: $26,178.77 October 15, 2018 Regular Meeting Agenda Packet 24 of 171 As Of ER UE FIElDER( .,-4TTORNEYS AT Lill\l 1 1 1 1 1 1 3 7 9 6 13 14 11 13 18 22 24 34 Totals 183 10/9/2018 N 0.55% 0.55% 0.55% 0.55% 0.55% 0.28 0.55% 0.42 0.55% 0.55% 0.42 1.64% 3.83% 4.92% 4.21% 3.28% 3.75 7.10% 7.65% 6.01% 7.10% 8.24% 9.84% 9.20% 12.02% 9.62 13.11 % 10.08 18.58% 100.00% Total Base Tax: $26,178.77 October 15, 2018 Regular Meeting Agenda Packet 25 of 171 2017 TROPHY CLUB MUD #1 OVER 65 DEFERRALS 2017 TAX YEAR ONLY Taxpayer# Name Base Tax Due 376 Masters, W. James & Sally P. $588.44 77 Foust, Amanda $476.32 968 Boren, Benjamin C. & Beverly C. $385.38 91176 Parrow, James J. & Elena $385.31 1570 Goswick, Cherie $200.77 76 McDonald, James E. $5.37 TOTAL $2,041.59 October 15, 2018 Regular Meeting Agenda Packet 26 of 171 2017 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,746.91 1205 Shires, Brenda $30.88 968 Boren, Benjamin C & Beverly C $2,823.24 376 Masters, James & Sally $1,579.37 77 Foust, Amanda $476.32 91176 Parrow, James J. & Elena $385.31 1570 Goswick, Cherie $201.14 TOTAL $18,230.37 October 15, 2018 Regular Meeting Agenda Packet 27 of 171 Descending Tax Roll TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 For Amounts $0.01 To $999,999,999.99 For Years 2017 Through 2017 Taxpayer# Name 376 MASTERS W JAMES & SALLY P Address 10 FAIR GREEN DR City/State/Zip TROPIN CLUB, TX 76262-5629 Phone No. Client GEO Code Client Property Code ll6467DEN R116467 77 Address FOUST AivfANDA 31 0 OAKtvfONT DR City/State/Zip TROPHY CLUB, TX 76262-5473 Phone No. Client GEO Code Client Property Code 72073DEN R72073 90337 WISE JEFFREY L 116 ROLLING ROCK DR City/State/Zip ROANOKE, TX 76262-5114 Phone No. Client GEO Code Client Property Code 189825DEN R189825 10/9/2018 11:34:08 AM Cause# Jdg Date PTD Code Year Span R 2017 PTD Code Year Span R 2017 5/8/2017 PTD Code Year Span R 2017 Status Indicators Tax Due $588.44 Tax Due $476.32 Tax Due $406.37 Base Tax: oos LIBIPID $588.44 D Total Due $608.04 $476.32 D Total Due $685.90 $406.37 Total Due $590.05 Page 2 of9 October 15, 2018 Regular Meeting Agenda Packet 28 of 171 968 Address BOREN BENJAMIN C & BEVERLY C 14 EDGEMERE DR City/State/Zip TROPHY CLUB, TX 76262-9725 Phone No. Client GEO Code Client Property Code 71012DEN R71012 91176 PARROvV JAMES J & ELENA Address 8 BROOKFIELD CT City/State/Zip TROPHY CLUB, TX 76262 Phone .No. Client GEO Code Client Property Code 71779DEN R71779 90829 FOREMAN DR. JOSHUA 925 TROPHY CLUB DR City/State/Zip ROANOKE, TX 76262-5582 Phone No. Client GEO Code Client Property Code 650109DEN P650109 914 Address 110RTON DE:t\T\'ER & JANIE 3 HILLCREST CT City/State/Zip TROP!-IY CLUB, TX 76262-5515 Phone No. Client GEO Code Client Property Code 72277DEN R72277 1209 JONES BRETT W .A.ddress 159 CREEK COURTS DR City/State/Zip TROPHY CLUB, TX 76262-5441 10/9/2018 11:34:08 AM PTD Code R PTD Code R 17-3915-442 PTD Code p PTD Code R DEFE $385.38 D Year Span Tax Due Total Due 2017 $385.38 $398.21 DEFE $385.31 D Year Span Tax Due Total Due 2017 $385.31 $398.14 3/2/2018 SUIT $305.65 L Year Span Tax Due Total Due 2017 $305.65 $443.80 $285.68 Year Span Tax Due Total Due 2017 $285.68 $414.81 $267.50 Page 3 of9 October 15, 2018 Regular Meeting Agenda Packet 29 of 171 Phone No. Client GEO Code Client Property Code 71072DEN R71072 90894 MCDOWELL NANCY Address 41 MEADOWBROOK LN City/State/Zip TROPHY CLUB, TX 76262-5639 Client GEO Code Client Property Code 70277DEN R7277 1570 GOS\VICK CHERIE 542 TIMBER RfDGE DR City/State/Zip TROPHY CLUB~ TX 76262-5644 Phone No. Client GEO Code Client Property Code 70677DEN R7677 90738 BG FOX LLC Address 2234 EDINBURGH AVE City/State/Zip TROPHY CLUB, TX 76262 Phm:teNo. Client GEO Code Client Property Code 42203277TAR R42203277T AR 42229993TAR R42229993TAR 91111 ASAAD NEAL ~1\TD TRAN ASAAD KIM M Address 2025 GRANADA TRL City/State/Zip WESTLAKE, TX 76262 Phone No. 10/9/2018 11:34:08 AM PTD Code Year Span Tax Due Total Due R 2017 $267.50 $388.41 QPAY $251.59 PTD Code Year Span Tax Due Total Due R 2017 $251.59 $347.19 DEFE $200.77 D PTD Code Year Span Tax Due Total Due R 2017 $200.77 $202.44 $166.32 PTD Code Year Span Tax Due Total Due R 2017 $6.71 $9.74 R 2017 $159.61 $231.75 $138.01 Page 4 of9 October 15, 2018 Regular Meeting Agenda Packet 30 of 171 Client GEO Code Client Property Code PTD Code 42ll0333TAR R42110333TAR R 91222 PENDERGRASS JIM E AND PENDERGRASS CATHER Address 1616 LIS"tY10RE CT City/State/Zip ROANOKE, TX 76262 Phone No. Client GEO Code Client Property Code 42110589TAR .R42110589TAR 1750 LYNCH HELEN M 207 CARNOUSTIE DR City/State/Zip TROPHY CLUB, TX 76262-5462 Phone No. Client GEO Code Client Property Code 72370DEN R72370 58 Address \VEINBERGER DELI TWO LLC 3 VILLAGE CI.R STE 116 City/State/Zip WESTLAKE, TX 76262-7935 Phone No. Client GEO Code Client Property Code 11514205TAR P11514205TAR 1242 FORD LESLIE Address 1300 KELLER PKWY APT 523 City/State/Zip KELLER, TX 76248-8473 Phone No. Client GEO Code Client Property Code 926478DEN P926478 10/9/2018 11:34:08 AM PTD Code R PTD Code R PTD Code p 15-06894-431 PTD Code p Year Span 2017 Year Span 2017 Year Span 2017 Year Span 2017 8/25/2016 3/21/2014 11/6/2014 Year Span 2017 Tax Due $138.01 Tax Due $120.05 QPAY Tax Due $106.05 Tax Due $96.45 _,SUIT Tax Due $73.69 Total Due $200.39 $120.05 Total Due $174.31 $106.05 Total Due $146.35 $96.45 Total Due $140.05 $73.69 L Total Due $107.00 Page 5 of9 October 15, 2018 Regular Meeting Agenda Packet 31 of 171 90466 Address LA SCALA RJSTORANTE ITALIANO 1301 SOLANA BLVD STE 4115 City/State/Zip Vv"'ESTLAKE, TX 76262-1660 Phone No. Client GEO Code Client Property Code 10755195TAR P1755195TAR 65 FIRST MAD[SON BANK FSB Address 14651 DALLAS PKW'l STE 200 City/State/Zip DALLAS, TX 75254 Phone No. (214) 770-3711 Client GEO Code Client Property Code 173225DEN R173225 40778495T AR R4778495TAR 1769 Address CAMPUS CIRCLE WESTLAIZE LLC 29 COMMONWEALTH AVE City/State/Zip BOSTON, I\1A 02116 Phon.e No. 759 Client GEO Code Client Property Code 41463978TAR R41463978TAR MORRISON AVIATION LLC P. 0. BOX 1691 City/State/Zip JACKSONVILLE, TX 75766-1691 Phone No. Client GEO Code Client Property Code 339971DEN P339971 , .. , ,., .. ,. '"""""""""" ·······.·~·~···-·--·~··~ 91071 TURNER CONSTRUCTION CO 10/9/2018 11:34:08 AM $69.98 PTD Code Year Span Tax Due Total Due p 2017 $69.98 $101.61 14-03488-211 1/29/2016 , SUIT $62.76 L 141-E31255-14 2/4/2016 2/23/2012 PTD Code Year Span Tax Due Total Due R 2017 $18.78 $27.27 R 2017 $43.98 $63.86 $32.50 PTD Code Year Span Tax Due Total Due R 2017 $32.50 $47.19 . UP $28.57 PTD Code Year Span Tax Due Total Due p 2017 $28.57 $41.48 $20.46 Page 6 of9 October 15, 2018 Regular Meeting Agenda Packet 32 of 171 Address 10100 N CENTRAL EXPW STE 600 City/State/Zip DALLAS, TX 75231 Phone No. Client GEO Code Client Property Code 14454543TAR P14454543TAR '-.. ····-···-··· 90837 THE BRONZE BAR A.ddress 2003 E :t:UGHW A Y 114 STE 400 City/State/Zip ROANOKE, TX 76262-6678 Phone No. Client GEO Code Client Property Code 656967DEN P656967 90369 FOOT' PALACE SPA Address 301 TROPHY LAKE DR UNIT 124 City/State/Zip ROANOKE, 'I'X 76262-5237 Phone No. Client GEO Code Client Property Code 656969DEN P656969 91068 :HEART TEST LABORATORIES INC Address 5611 COLLEYVILLE BLVD City/State/Zip COLLEYVILLE, TX 76034 .Phone No. Client GEO Code Client Property Code 13442112T AR P13442112TAR 76 A.ddress MCDONALD JAMES E 4ROSS CT City/State/Zip TROPHY CLUB, TX 76262-671 l Phone No. 10/9/2018 11:34:08 AM PTD Code Year Span Tax Due Total Due p 2017 $20.46 $29.71 $14.54 PTD Code Year Span Tax Due Total Due p 2017 $14.54 $21.11 $9.53 PTD Code Year Span Tax Due Total Due p 2017 $9.53 $13.84 $6.45 PTD Code Year Span Tax Due Total Due p 2017 $6.45 $9.37 DEFE $5.37 D Page 7 of9 October 15, 2018 Regular Meeting Agenda Packet 33 of 171 Client GEO Code Client Property Code 72060DEN R72060 91141 Address CHIP :tviUNDY INC 2003 E H\VY 114 City/State/Zip ROANOKE, TX 76262 Phone No. Client GEO Code Client Property Code 659388DEN P659388 1588 BOICE SHON Address 3 GLENDALE CT City/State/Zip TROPHY CLUB, TX 76262-5520 Phone No. 1638 Client GEO Code Client Property Code 72595DEN R72595 NATIONAL DEFAULT TITLE SERVICE 1 FIRST Aivt:ERICAN vV A Y City/State/Zip SANTA ANA, CA 92707 Phone No. Client GEO Code Client Property Code PTD Code R PTD Code p PTD Code R PTD Code 13661787TAR P13661787TAR P 1497 THIBAULT LA'W'RENCE R & JEANNETTE E Address 111 LAKESIDE DR City/State/Zip ROANOKE, TX 76262-5231 Phone No. Client GEO Code Client Property Code 203807DEN R23807 10/9/2018 11:34:08 AM PTD Code R Year Span Tax Due Total Due 2017 $5.37 $5.55 $4.85 Year Span Tax Due Total Due 2017 $4.85 $7.04 QPAY $0.70 Year Span Tax Due Total Due 2017 $0.70 $0.97 $0.07 Year Span Tax Due Total Due 2017 $0.07 $0.10 QPAY $0.02 Year Span Tax Due Total Due 2017 $0.02 $0.03 Page 8 of9 October 15, 2018 Regular Meeting Agenda Packet 34 of 171 893 BULAND RlJDY A QPAY $0.01 Address 213 PHOENIX DR City/State/Zip ROANOKE, TX 76262 Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 72300DEN R 2017 $0.01 $0.01 "'•'''W'''•""~'" ·~-· '''' '''0''W'0''0'0''''" 'YW•0'~''"''"•'''-'0°-Y 91159 STvHTH MIL TON $0.01 Addn:.ss 1120 SUNSET DR City/State/Zip TROPI-lY CLUB, TX 76262 Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 70021DEN R721 R 2017 $0.01 $0.01 -" .. ~ .... 91203 SISODIYA KAMLESH J AND SISODIY A $0.01 HARSHA Address 7003 GLADVvYNE CT City/State/Zip COLLEYVU.I . .E, TX 76034-6625 ·Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 4211 0520T AR R42110520TAR R 2017 $0.01 $0.01 32 Taxpayers $4,509.41 10/9/2018 11:34:08 AM Page 9 of9 October 15, 2018 Regular Meeting Agenda Packet 35 of 171 Descending Tax oil TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 For Amounts $0.01 To $999,999,999.99 For Years 1994 Through 2017 Taxpayer# Name 799 BAlCER BOB J 1 1 STEPHENS CT City/State/Zip TROPI-N CLUB, TX 76262-5421 Phone No. Client GEO Code Client Property Code 209674DEN R29674 76 Address MCDONALD JAMES E 4 ROSS CT City/State/Zii> TROPHY CLUB, TX 76262-6711 Phone No. Client GEO Code Client Property Code 72060DEN R72060 968 BOREN BENJAMIN C & BEVERLY C Address 14 EDGEMERE DR City/State/Zip TROPI-N CLUB, TX 76262-9725 Phone No. Client GEO Code Client Property Code 71012DEN R71012 10/9/2018 11:33:13 AM Cause# PTD Code R PTD Code R PTD Code R Jdg Date Year Span 2010-2016 Year Span 2006-2017 Year Span 2010-2017 Status Indicators DEFE Tax Due $7,987.20 DEFE Tax Due $4,746.91 DEFE Tax Due $2,823.24 Base Tax: oos LIBIPID $7,987.20 D Total Due $11,738.23 $4,746.91 D Total Due $7,352.36 $2,823.24 D Total Due $3,703.90 Page 2 of19 October 15, 2018 Regular Meeting Agenda Packet 36 of 171 59 Address SlJ1'v1MERS, JAMES M 532 LEA VALLEY CIR City/State/Zip COPPELL, TX 75019 Phone No. Client GEO Code Client Property Code 11514221TAR Pl1514221TAR 65 FIRST 1\tiADISON BANK FSB Address 14651 DALLAS PK\VY STE 200 City/State/Zip DALLAS, TX 75254 Phone No. (214) 770-3711 Client GEO Code Client Property Code 173225DEN Rl73225 296671DEN R296671 40778495TAR R4778495TAR . ···---··· -··-·. 376 IviASTERS W JAMES & SALLY P Address 10 FAIR GREEN DR City/State/Zip TROPHY CLUB, TX 76262-5629 77 Client GEO Code Client Property Code 116467DEN R116467 FOUST Al\t1ANDA 310 OAKMONT DR City/State/Zip TROPI-IY CLUB, TX 76262-5473 Plume No. Client GEO Code Client Property Code 72073DEN R72073 10/9/2018 11:33:13 AM L-24321 12il/2011 BKR, SUIT, lJP $2,064.50 L PTD Code Year Span Tax Due Total Due p 2008-2014 $2,064.50 $4,845.78 14-03488-211 1/29/2016 , StiTT $1,721.62 L 141-E31255-14 2/4/2016 2/23/2012 PTD Code Year Span Tax Due Total Due R 1997-2017 $988.53 $3,113.29 R 2006-2007 $155.42 $441.91 R 2008-2017 $577.67 $1,254.58 .. ._ ....... ·-·············~··· $1,579.37 D PTD Code Year Span Tax Due Total Due R 2015-2017 $1,579.37 $2,164.95 $476.32 D PTD Code Year Span Tax Due Total Due R 2017 $476.32 $685.90 Page 3 of 19 October 15, 2018 Regular Meeting Agenda Packet 37 of 171 90337 WISE JEFFREY L Address 116 ROLLING ROCK DR City/State/Zip ROANOKE, TX 76262-5114 Phone No. Client GEO Code Client Property Code 189825DEN R189825 91176 Address PARROW JAfv1ES J & ELENA 8 BROOKFIELD CT City/State/Zi.p TROPHY CLUB, TX 76262 Phone No. Client GEO Code Client Property Code 71779DEN R71779 123 Address DIEGO'S TEX-MEX STEAKS 3 VILLAGE CIR STE 1 08 City/State/Zip WESTLAKE, TX 76262-7935 Phone No. (817) 430-3558 Client GEO Code Client Property Code 947887DEN P947887 1560 BURGARBRANDON 301 TROPHY LAKE DR STE 120 City/State/Zip TROPHY CLUB, TX 76262-5237 Phone No. Client GEO Code Client Property Code 620602DEN P620602 90829 FOREMAN DR. JOSHUA 925 TROPf-N CLUB DR City/State/Zip ROANOKE, TX 76262-5582 10/9/2018 11:33:13 AM PTD Code R PTD Code R PTD Code p 16-04123-158 PTD Code p 17-3915-442 5/8/2017 $406.37 Year Span Tax Due Total Due 2017 $406.37 $590.05 ~ • .,. •• • ••y••w•'"' ' DEFE $385.31 D Year Span Tax Due Total Due 2017 $385.31 $398.14 UP $316.25 Year Span Tax Due Total Due 2007 $316.25 $876.49 SUIT $310.41 L Year Span Tax Due Total Due 2013-2014 $310.41 $605.13 3/2/2018 SUIT $305.65 L Page 4 of 19 October 15, 2018 Regular Meeting Agenda Packet 38 of 171 Phone No. Client GEO Code Client Property Code 650109DEN P650109 1242 FORD LESLIE Address 1300 KELLER PKWY APT 523 City/State/Zip KELLER, TX 76248-8473 Phone No. Client GEO Code Client Property Code 9264 78DEN P9264 78 914 MORTON DENVER & JANIE Address 3 HILLCREST CT City/State/Zip TROPHY CLUB, TX 76262-5515 Phone No. Client GEO Code Client Property Code 72277DEN R72277 1209 JONES BRETT W Address 159 CREEK COURTS DR City/State/Zip TROPI-IY CLUB, TX 76262-5441 Phone No. Client GEO Code Client Property Code 71072DEN R71072 90894 Addxess MCDOWELL NANCY 4111EADOWBROOK LN City/State/Zip TROPHY CLUB, TX 76262-5639 Plume No. 10/9/2018 11:33:13 AM PTD Code p 15-06894-431 PTD Code p PTD Code R PTD Code R Year Span 2017 8/25/2016 3/21/2014 ll/6/2014 Year Span 2012-2017 Year Span 2017 Year Span 2017 Tax Due $305.65 , SUIT Tax Due $304.07 Tax Due $285.68 Tax Due $267.50 QPAY Total Due $443.80 $304.07 L Total Due $523.88 $285.68 Total Due $414.81 $267.50 Total Due $388.41 $251.59 Page 5 of 19 October 15, 2018 Regular Meeting Agenda Packet 39 of 171 Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 70277DEN R7277 R 2017 $251.59 $347.19 759 :!'vfORRISON AVIATION LLC , UP $243.04 i\ddress P. 0. BOX 1691 City/State/Zip JACKSONVILLE, TX 75766-1691 .Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 339971DEN P339971 p 2010-2017 $243.04 $479.86 ' .... _.·~· ~~ , .. , .. ,.,_ .... _._._. ________ 1570 GOSWICK CHERIE DEFE $201.14 D Address 542 TIMBER RIDGE DR City/State/Zip TROPHY CLUB, TX 76262-5644 "Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 70677DEN R7677 R 2016-2017 $201.14 $202.84 90738 BGFOX LLC $166.32 Address 2234 EDINBURGH AVE City/State/Zip TROPHY CLUB, TX 76262 Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 42203277TAR R42203277TAR R 2017 $6.71 $9.74 42229993TAR R42229993T AR R 2017 $159.61 $231.75 ····················-········ 91111 ASAAD NEAL AND TRAN ASAAD KI.l\tl M $138.01 Address 2025 GRANADA TRL City/State/Zip \VESTLAKE, TX 76262 .Phone No. Client GEO Code Client Property Code PTD Code Year Span Tax Due Total Due 42110333TAR R42110333TAR R 2017 $138.01 $200.39 10/9/2018 11:33:13 AM Page 6 of19 October 15, 2018 Regular Meeting Agenda Packet 40 of 171 1769 Address CAMPUS CIRCLE WESTLAKE LLC 29 COM.\10N\VEALTH AVE City/State/Zip BOSTON, .MA 02116 Phone No. Client GEO Code Client Property Code 41463978TAR R41463978TAR PTD Code R 91222 PENDERGRASS JIM E AND PENDERGRASS CATHER Address 1616 LIS-MORE CT City/State/Zip ROANOKE, TX 76262 Client GEO Code Client Property Code PTD Code 4211 0589T AR R4211 0589T AR R 58 \VEINBERGER DELI T\VO LLC Address 3 VILLAGE CIR STE 116 City/State/Zip WESTLAKE, TX 76262-7935 ·Phone No. Client GEO Code Client Property Code PTD Code 11514205TAR Pl1514205TAR p 1750 LYNCHHELENM Address 207 CARNOUSTIE DR City/State/Zip TROPHY CLUB, TX 76262-5462 Phone No. Client GEO Code Client Property Code PTD Code 72370DEN R72370 R 1184 VERIZON A.ddress 301 TROPHY LAKE DR UNIT 124 City/State/Zip ROANOKE, TX 76262 10/9/2018 11:33:13 AM $134.49 Year Span Tax Due Total Due 2014-2017 $134.49 $224.88 $120.05 Year Span Tax Due Total Due 2017 $120.05 $174.31 $113.46 Year Span Tax Due Total Due 2016-2017 $113.46 $167.20 QPAY $106.05 Year Span Tax Due Total Due 2017 $106.05 $146.35 UP $82.41 Page 7 of19 October 15, 2018 Regular Meeting Agenda Packet 41 of 171 Phone No. Client GEO Code Client Property Code 469054DEN P469054 90466 LA SCALA RISTORANTE ITALIANO Addxess 1301 SOLANA BLVD STE 4115 City/State/Zip vVESTLAKE, TX 76262-1660 Client GEO Code Client Property Code 10755195TAR P1755195TAR 129 REMAX INTEGRITY Address I 00 TROPHY CLUB DR STE. 1 02 City/State/Zip ROANOKE, TX 76262 .Phone No. Client GEO Code Client Property Code 953826DEN P953826 130 POLO CLEANERS 2652 FM 407 E City/State/Zip .ARGYLE, TX 76226 Phone No. (940) 241-1486 Client GEO Code Client Property Code 953833DEN P953833 57 J P TALBOT INSlJRANCE Address PO BOX 93152 City/State/Zip SOUTHLAKE, TX 76092 Phone No. 10/9/2018 11:33:13 AM PTD Code p PTD Code p PTD Code p PTD Code p Year Span Tax Due Total Due 2011-2013 $82.41 $178.44 $69.98 Year Span Tax Due Total Due 2017 $69.98 $101.61 UP $61.15 Year Span Tax Due Total Due 2007-2010 $61.15 $160.45 ,, ... _. ... ,. '""""'""'"''""''' UP $59.40 Year Span Tax Due Total Due 2008 $59.40 $156.43 UP $51.82 Page 8 of 19 October 15, 2018 Regular Meeting Agenda Packet 42 of 171 Client GEO Code Client Property Code l0374248TAR P1374248TAR 1164 WALJI SHANIF Ivf Address 504 N OAK ST STE 1 City/State/Zip ROANOKE, TX 76262-5005 Plume No. Client GEO Code Client Property Code 336817DEN P336817 103 FIDELITY NATIONAL TITLE Address 99 TROPHY CLUB DR City/State/Zip TROPHY CLUB, TX 76262-5422 Plume No. Client GEO Code Client Property Code 930792DEN P930792 1730 EARCARE HEARING AIDS Address 501 TROPHY LAKE DR STE 318 City/State/Zip ROANOKE, TX 76262-5239 Phone No. Client GEO Code Client Property Code 633172DEN P633172 1205 SHIRES BRENDA Address 7 LAKE FOREST CT City/State/Zip TROPHY CLUB, TX 76262-5504 Phone No. Client GEO Code Client Property Code 70643DEN R7643 475 FIRST AMERICAN LEASING 10/9/2018 11:33:13 AM PTD Code p PTD Code p PTD Code p PTD Code p PTD Code R Year Span Tax Due Total Due 2008-2011 $51.82 $130.18 UP $45.93 Year Span Tax Due Total Due 2014-2015 $45.93 $82.94 _. ... ,._ ... ,-..,.,.•.•y"""' UP $42.70 Year Span Tax Due Total Due 2007-2008, 2010 $42.70 $112.29 UP $35.18 Year Span Tax Due Total Due 2014-2015 $35.18 $63.54 DEFE $30.88 D Year Span Tax Due Total Due 2014 $30.88 $39.24 UP $29.05 Page 9 of 19 October 15, 2018 Regular Meeting Agenda Packet 43 of 171 Address PO BOX 168608 City/State/Zip IRVING, TX 75016-8608 Phone No. Client GEO Code Client Property Code 13427849TAR P13427849TAR •..• , • "' '""""""••n•••••• 90369 FOOT PALACE SPA .Address 301 TROPHY LAKE DR UNIT 124 City/State/Zip ROANOKE, TX 76262-5237 .Phone No. Client GEO Code Client Property Code 656969DEN P656969 91071 TURNER CONSTRUCTION CO Address 10100 N CENTRAL EXP\V STE 600 City/State/Zip DALLAS, TX 75231 Client GEO Code Client Property Code 14454543TAR Pl4454543TAR 741 MIJOL REALTY.COM Address 100 INDIAN CREEK DR STE 120 City/State/Zip ROANOKE, TX 76262 Phone No. Client GEO Code Client Property Code 336821DEN P336821 1711 STYLES OF INDIA 2003 SH 114, STE 340 City/State/Zip TROPHY CLUB, TX 76262 Phone No. 10/9/2018 11:33:13 AM PTD Code Year Span Tax Due Total Due p 2008 $29.05 $68.15 $25.14 PTD Code Year Span Tax Due Total Due p 2015-2017 $25.14 $39.79 $20.46 PTD Code Year Span Tax Due Total Due p 2017 $20.46 $29.71 UP $20.36 PTD Code Year Span Tax Due Total Due p 2010-2011 $20.36 $48.70 $20.23 Page 10 of 19 October 15, 2018 Regular Meeting Agenda Packet 44 of 171 Client GEO Code Client Property Code 563646DEN P563646 '' "'¥""·-·w· ~··•· ···~·•··--••• •·•· •• 1530 DESIRE SALON & SPA Address 2001 W SH 114 STE 150 C.ity/State/Zip TROPHY CLUB, TX 76262 Phone No. Client GEO Code Client Property Code 499622DEN P499622 122 GARLITZ FINANCIAL SVCE Address 103 SKYLINE DR City/State/Zip ROANOKE, TX 76262 Phone No. (817) 491-1454 Client GEO Code Client Property Code 947758DEN P947758 90837 THE BRONZE BAR Address 2003 E HIGHWAY 114 STE 400 City/State/Zip ROANOKE, TX 76262-6678 Phone No. Client GEO Code Client Property Code 656967DEN P656967 887 TONY CAO SALON & SPA Addxess 1901 LONG PRAIRIE RD STE 260 City/State/Zip FLOWER 1\10UND, TX 75022 Phone No. Client GEO Code Client Property Code 953825DEN P953825 10/9/2018 11:33:13 AM · PTD Code Year Span Tax Due Total Due p 2015-2016 $20.23 $33.63 UP $16.51 PTD Code Year Span Tax Due Total Due _p 2013 $16.51 $33.48 UP $15.18 PTD Code Year Span Tax Due Total Due p 2007 $15.18 $42.07 $14.54 PTD Code Year Span Tax Due Total Due p 2017 $14.54 S21.11 UP $13.48 PTD Code Year Span Tax Due Total Due p 2011 $13.48 $31.22 Page 11 of 19 October 15, 2018 Regular Meeting Agenda Packet 45 of 171 190 WHITTON CONSTRUCTION INC 1241 CYPRESS CREEK CT City/State/Zip SOUTHLAKE, TX 76092-4119 Phone No. Client GEO Code Client Property Code 11457732TAR Pl1457732TAR 740 CJ HOOD CO INC 100 INDIAN CREEK DR City/State/Zip TROPHY CLUB, TX 76262 Phone No. Client GEO Code Client Property Code 336819DEN P336819 1284 Address IBAHN GENERAL HOLDINGS CORP 1160 S PIONEER RD STE 5 City/State/Zip SALT LAKE CITY, UT 84104-3738 Phone No. Client GEO Code Client Property Code 11648163TAR Pl1648163TAR 91068 HEART TEST LABORATORIES INC Address 5611 COLLEYVILLE BLVD City/State/Zip COLLEYviLLE, TX 76034 Phone No. Client GEO Code Client Property Code l3442112TAR P13442112TAR 875 CHRISTLIEB LA \V OFFICE Address 3 LLANO DR City/State/Zip ROANOKE, TX 76262 10/9/2018 11:33:13 AM PTD Code p PTD Code p PTD Code p PTD Code p UP $11.56 Year Span Tax Due Total Due 2011 $11.56 $26.77 UP $10.73 Year Span Tax Due Total Due 2010 $10.73 $26.40 $6.48 Year Span Tax Due Total Due 2012-2013 $6.48 $13.65 $6.45 Year Span Tax Due Total Due 2017 $6.45 $9.37 UP $5.37 Page 12 of19 October 15, 2018 Regular Meeting Agenda Packet 46 of 171 Phone No. Client GEO Code Client Property Code 925240DEN P925240 91141 CHIP 1\t1UNDY INC Address 2003 E HW'{ 114 City/State/Zip ROANOKE, TX 76262 Phone No. Client GEO Code Client Property Code 659388DEN P659388 1555 DONNA & ASSOCIATES Address 99 TROPHY CLUB DR City/State/Zip ROANOKE, TX 76262-5422 Phone .No. Client GEO Code Client Property Code 566115DEN P566115 ,__.,_.,, .. _.. ·-···· •··w~w.w.-· .. ~·- 90372 RAY DERSTEIN 99 TROPHY CLUB DR City/State/Zip ROANOKE, TX 76262-5422 Phone No. Client GEO Code Client Property Code 659398DEN P659398 1628 TROPHY CLUB TOVvN OF Address 1 TROPHY WOOD DR City/State/Zip ROANOKE, TX 76262 Phone No. 10/9/2018 11:33:13 AM PTD Code p PTD Code p PTD Code p PTD Code p Year Span Tax Due Total Due 2010-2011 $5.37 $12.84 $4.85 Year Span Tax Due Total Due 2017 $4.85 $7.04 $4.40 Year Span Tax Due Total Due 2013 $4.40 $8.92 $3.61 Year Span Tax Due Total Due 2015 $3.61 $6.28 E $3.29 Page 13 of 19 October 15, 2018 Regular Meeting Agenda Packet 47 of 171 Client GEO Code Client Property Code 116598DEN R116598 116600DEN R116600 624324DEN R624324 624325DEN R624325 90423 D L PETERSON TRUST POBOX 13085 City/State/Zip BALTIM.ORE, 1\tfD 21203-3085 l'hone No. Client GEO Code Client Property Code 12675504TAR P12675504TAR 90303 RANDSTAD US LP Address 150 PRESIDENTIAL FL 4 Vo./A Y City/State/Zip \VOBURN, l\IIA 01801-1100 Client GEO Code Client Property Code 13730967TAR P13730967TAR ·~ W'o ,y""oYoo'•'•""•'•-'•Y'''" "''"'"""'""""~'' '' "" W•''•'''-"'''' 90482 DAIICHI SANKYO INC Address 2 HILTONCT City/State/Zip PARSIPPANY, NJ 07054-4410 Phone No. Client GEO Code Client Property Code 14511121TAR Pl4511121TAR 1329 Address HELM INSURANCE AGENCY 99 TROPHY CLUB DR City/State/Zip TROPHY CLUB, TX 76262-5422 Phone No. 10/9/2018 11:33:13 AM PTD Code Year Span Tax Due Total Due R 2014 $1.20 $2.26 R 2014 $1.11 $2.09 R 2014 $0.52 $0.98 R 2014 $0.46 $0.87 $2.88 PTD Code Year Span Tax Due Total Due p 2015 $2.88 $4.91 $2.76 PTD Code Year Span Tax Due Total Due p 2014-2015 $2.76 $4.87 $2.24 PTD Code Year Span Tax Due Total Due p 2016 $2.24 $3.17 $0.87 Page 14 of 19 October 15, 2018 Regular Meeting Agenda Packet 48 of 171 Client GEO Code Client Property Code 335713DEN P335713 1588 BOICE SHON 3 GLENDALE CT City/State/Zip TROPHY CLUB, TX 76262-5520 .Phone No. Client GEO Code Client Property Code 72595DEN R 72595 90713 ROYAL CUP INC Address PO BOX 170971 City/State/Zip BIRMINGHAM, AL 35217-0971 ·Phone No. Client GEO Code Client Property Code 1438071 OTAR P14380710TAR 91207 Address DELL MARKETING LP 1 DELL WAY #RRl-35 City/State/Zip ROlTND ROCK, TX 78682-7000 Phone No. Client GEO Code Client Property Code 14461451TAR P14461451 TAR 91052 BLOOMBERG LP 731 LEXINGTON AVE City/State/Zip NEW YORK, NY 10022-1331 Phone No. Client GEO Code Client Property Code 1 4460527TAR P14460527TAR 354 RS WATER HOLDING LLC 10/9/2018 11:33:13 AM PTD Code p PTD Code R PTD Code p PTD Code p PTD Code p Year Span Tax Due Total Due 2012 $0.87 $1.89 QPAY $0.70 Year Span Tax Due Total Due 2017 $0.70 $0.97 $0.64 Year Span Tax Due Total Due 2015-2016 $0.64 $0.96 $0.61 Year Span Tax Due Total Due 2016 $0.61 $0.88 $0.57 Year Span Tax Due Total Due 2015-2016 $0.57 $0.83 , lJP $0.55 Page 15 of 19 October 15, 2018 Regular Meeting Agenda Packet 49 of 171 Address 3201 PREMIER DR STE 300 City/State/Zip IRVING, TX 75063-6075 Phone No. Client GEO Code Client Property Code 14389563TAR Pl4389563TAR 14479384TAR Pl4479384TAR 90293 _A_ddress FIRST DATA Mf,RCHANT SVCS INC 5755 DTC BLVD 4THFL City/State/Zip GREENWOOD VILLAGE, CO 80111 Phone No. Client GEO Code Client Property Code 143 70986T AR Pl4370986TAR 63 Address PITNEY BO\\lES GLOBAL FINANCIAL 5310 CYPRESS CTR DR STE 110 City/State/Zip TAMPA, FL 33609-1041 Phone No. Client GEO Code Client Property Code 14350063TAR P14350063TAR 1290 SONIFI SOLUTIONS INC Address 3900 W IJ\i'NOVATION ST City/State/ZiJl SIOUX FALLS, SD 57107-7002 Phone No. Client GEO Code Client Property Code 14381350TAR Pl4381350TAR 91051 Address AUTO-CHLOR SERVICES LLC 500 DAKIN ST City/State/Z_ip JEFFERSON, LA 70121-4008 10/9/2018 11:33:13 AM PTD Code Year Span Tax Due Total Due p 2016 $0.46 $0.68 p 2016 $0.09 $0.13 $0.46 PTD Code Year Span Tax Due Total Due p 2015-2016 $0.46 $0.69 $0.20 PTD Code Year Span Tax Due Total Due p 2016 $0.20 $0.31 $0.15 PTD Code Year Span Tax Due Total Due p 2015 $0.15 $0.23 $0.11 Page 16 of 19 October 15, 2018 Regular Meeting Agenda Packet 50 of 171 Phone No. Client GEO Code Client Property Code 14384456TAR P14384456TAR 91045 AMERIGAS PROPANE LP Address POBOX 798 City/State/Zip VALLEY FORGE, PA 19482-0798 Client GEO Code Client Property Code 14358803TAR P14358803TAR 1638 NAT'IONAL DEFAULT TITLE SERVICE Address 1 FIRST AMERICAN \VA Y City/State/Zip SANTA ANA, CA 92707 Client GEO Code Client Property Code 13661787T AR P13661787TAR ~· "·'~"" '·-·--··w·v~··""' 1163 FlJLL CIRCLE LOGISTICS Address 99 TROPHY CLUB DR City/State/Zip TROPHY CLUB, TX 76262-5422 Phone No. Client GEO Code Client Property Code 335711 DEN P335711 91049 NEOPOST USA INC Address 4 78 "/HEELERS FARMS RD City/State/Zip MILFORD, CT 06461-91 05 Plume No. 10/9/2018 11:33:13 AM PTD Code p PTD Code p PTD Code p PTD Code p Year Span Tax Due Total Due 2016 $0.1.1 $0.16 $0.10 Year Span Tax Due Total Due 2015-2016 $0.10 $0.15 $0.07 Year Span Tax Due Total Due 2017 $0.07 $0.10 $0.07 Year Span Tax Due Total Due 2011 $0.07 $0.16 $0.04 Page 17 of 19 October 15, 2018 Regular Meeting Agenda Packet 51 of 171 Client GEO Code Client Property Code PTD Code 14448870T AR Pl4448870TAR p 1497 .Address THIBAULT LAWRENCE R & JEANNETTE E 111 LAKESIDE DR City/State/Zip ROANOKE, TX 76262-5231 :Ph{rne No. Client GEO Code Client Property Code 203807DEN R23807 893 BULAND RUDY A Address 213 PHOENIX DR City/State/Zip ROANOKE, TX 76262 Client GEO Code Client Property Code 72300DEN 90798 ROACH DAVID & SHARLA Address 40XFORDPL City/State/Zip TROPHY CLUB, TX 76262-5129 Phone No. Client GEO Code Client Property Code 558563DEN R558563 91159 SMITH MILTON A .. ddrcss 1120 SUNSET DR City/State/Zip TROPHY CLUB, TX 76262 Plume No. Client GEO Code Client Property Code 70021DEN R721 ·········~·· . 91203 SISODIY A KAMLESH J AND SISODIY A HARSHA -10/9/2018 11:33:13 AM PTD Code R PTD Code R PTD Code R PTD Code R Year Span Tax Due Total Due 2015 $0.04 $0.06 QPAY $0.02 Year Span Tax Due Total Due 2017 $0.02 $0.03 QPAY $0.01 Year Span Tax Due Total Due 2017 $0.01 $0.01 $0.01 Year Span Tax Due Total Due 2016 $0.01 $0.02 $0.01 Year Span Tax Due Total Due 2017 $0.01 $0.01 $0.01 Page 18 of 19 October 15, 2018 Regular Meeting Agenda Packet 52 of 171 Add:ress 7003 GLADWYNE CT City/State/Zip COLLEYVILLE, TX 76034-6625 Phone No. Client GEO Code Client Property Code 42110520TAR R421l0520TAR 73 Taxpayers 10/9/2018 11:33:13 AM PTD Code Year Span Tax Due Total Due R 2017 $0.01 $0.01 $26,178.77 Page 19 of 19 October 15, 2018 Regular Meeting Agenda Packet 53 of 171 Trophy Club Municipal Utility District No. 1I certify that this Investment Report complies with requirements of QUARTERLY INVESTMENT REPORTTCMUD's Investment Policy and the Public Funds Act. For Ending Period 09/30/2018 (July, August, and September 2018)John CarmanDATERstricted/Account orSec Rate /Call Purchase Begining Book Begining Market Ending Book Ending Market Gain/LossUnrestrictedCUSIPTypeParCoupon Maturity Date Price Yield % 6/30/20186/30/2018 9/30/2018 9/30/2018 End MV-End BVChecking & Money Market AccountsUnrestricted- 135XXX6372Bank of the West Money Market Account-$ 0.000% N/A N/A 100.000 0.000%715,223$ 715,223$ -$ -$ 0.00Unrestricted- 135XXX8701Prosperity Bank Consolidated Cash-General Fund 1,067,537$ 0.000% N/A N/A 100.0000.350%1,362,938$ 1,362,938$ 1,067,537$ 1,067,537$ 0.00Unrestricted- 122XXX8701Prosperity Bank Consolidated Cash-Fire Dept-$ 0.000% N/A N/A 100.000 0.350%60,743$ 60,743$ -$ -$ 0.00Restricted- 533XXX8701Prosperity Bank Consolidated Cash-Tax I&S4,573$ 0.000% N/A N/A 100.000 0.350%4,573$ 4,573$ 4,573$ 4,573$ 0.00Pools & Funds Unrestricted- 135XXXXX0002TexPool Municipal Fund-Operating3,227,798$ 0.000% N/A N/A 100.0001.950%2,261,972$ 2,261,972$ 3,227,798$ 3,227,798$ 0.00Restricted- 122TexPool Municipal Fund-Fire Dept543,883$ 0.000% N/A N/A 100.000 1.950%691,610$ 691,610$ 543,883$ 543,883$ 0.00Restricted- 137TexPool Municipal Fund-GASB Replacemenent596,426$ 0.000% N/A N/A 100.000 1.950%596,426$ 596,426$ 596,426$ 596,426$ 0.00Restricted- 533XXXXX0003TexPool Tax Debt Service48,716$ 0.000% N/A N/A 100.000 1.950%888,505$ 888,505$ 48,716$ 48,716$ 0.00Restricted- 517XXXXX00011TexPool WW Construction Tax-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 534XXXXX00013Texpool Revenue Bond I&S19,562$ 0.000% N/A N/A 100.000 1.950%396,346$ 396,346$ 19,562$ 19,562$ 0.00Restricted- 528XXXXX00014Texpool Revenue Bond Reserve606,910$ 0.000% N/A N/A 100.000 1.950%561,007$ 561,007$ 606,910$ 606,910$ 0.00Restricted- 519XXXXX00015Texpool Revenue Bond Construction-SWIFT-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 520XXXXX00016Texpool Revenue Bond Reserve-SWIFT-$ 0.000% N/A N/A 100.000 1.950%-$ -$ -$ -$ 0.00Restricted- 535XXXXX00017Texpool Revenue Bond I&S-SWIFT2,584$ 0.000% N/A N/A 100.000 1.950%197,971$ 197,971$ 2,584$ 2,584$ 0.00Savings Accounts RestrictedXXXXX7724Prosperity Bank Cash Reserve983,515$ 0.000% N/A N/A 100.000 0.400%782,658$ 782,658$ 983,515$ 983,515$ 0.00CD's NONEUS TreasuriesNONEUS Agencies NONE 7,101,504$ 8,519,972$ 8,519,972$ 7,101,504$ 7,101,504$ -$ EARNINGS SUMMARYRestricted/ Settle DateSec TypeAccount Number Par Coupon Maturity Qtr Accrued Qtr Amort. Total Qtr EarningsUnrestrictedChecking & Money Market AccountsUnrestricted- 135Bank of the West Money Market AccountXXX6372-$ N/A N/A309$ N/A309$ Unrestricted- 135 Prosperity Bank Consolidated Cash-General FundXXX8701 1,067,537$ N/A N/A 1,750$ N/A1,750$ Unrestricted- 122Prosperity Bank Consolidated Cash-Fire DeptXXX8701-$ N/A N/A-$ N/A-$ Restricted- 533Prosperity Bank Consolidated Cash-Tax I&SXXX87014,573$ N/A N/A-$ N/A-$ Pools & FundsUnrestricted TexPool Municipal FundXXXXX0002 4,368,107$ N/A N/A 18,332$ N/A18,332$ Restricted- 533 TexPool Tax Debt ServiceXXXXX0003 48,716$ N/A N/A 2,616$ N/A2,616$ Restricted- 517TexPool Construction TaxXXXXX00011-$ N/A N/A-$ N/A-$ Restricted- 534Texpool Revenue Bond I&SXXXXX00013 19,562$ N/A N/A 1,223$ N/A1,223$ Restricted- 528Texpool Revenue Bond ReserveXXXXX00014 606,910$ N/A N/A 2,820$ N/A2,820$ Restricted- 519Texpool Revenue Bond Construction-SWIFTXXXXX00015-$ N/A N/A-$ NA-$ Restricted- 520Texpool Revenue Bond Reserve-SWIFTXXXXX00016-$ N/A N/A-$ NA-$ Restricted- 535Texpool Revenue Bond I&S-SWIFTXXXXX00017 2,584$ N/A N/A594$ NA594$ Savings AccountsRestricted Prosperity Bank Cash ReserveXXXXX7724 983,515$ N/A N/A857$ N/A857$ CD'sNONEUS Treasuries NONE US Agencies NONE28,500$ N/A28,500$ PAR for this report is the statement balance on the last day of the quarterOctober 15, 2018 Regular Meeting Agenda Packet54 of 171 Project:Interconnect Prepared by:LMH Client:TCMUD No.1 Date:10/10/2018 UNIT PRICE EXTENDED PRICE 1 Mobilization (5% Max)LS 1 $129,000.00 $129,000.00 2 General Site Preparation STA 84 $1,500.00 $125,250.00 3 Construction Staking LS 1 $25,000.00 $25,000.00 4 Project Signs EA 2 $750.00 $1,500.00 5 SWPPP LS 1 $10,000.00 $10,000.00 6 Sawcut and Remove Concrete Pavement SY 1,357 $20.00 $27,140.00 7 Flexible Base (6")SY 1,424 $35.00 $49,840.00 8 Concrete Replacement (8")SY 1,357 $65.00 $88,205.00 9 12-Inch Waterline (C-900) (Open Cut)LF 522 $60.00 $31,320.00 10 14-Inch Waterline (C-900) (Open Cut)LF 127 $75.00 $9,525.00 11 16-Inch Waterline (C-900) (Open Cut)LF 2,385 $100.00 $238,500.00 12 18-Inch Waterline (C-900) (Open Cut)LF 2,678 $175.00 $468,650.00 13 Trench Safety LF 5,712 $3.00 $17,136.00 14 24-Inch Steel Casing Pipe LF 43 $250.00 $10,750.00 15 30-Inch Steel Casing Pipe LF 38 $275.00 $10,450.00 16 36-Inch Steel Casing Pipe LF 20 $300.00 $6,000.00 17 16-Inch Carrier Pipe in 30-Inch Steel Casing Pipe by OTOC LF 350 $500.00 $175,000.00 18 18-Inch Carrier Pipe in 36-Inch Steel Casing Pipe by OTOC LF 100 $875.00 $87,500.00 19 16-Inch Waterline (HDPE) (Directional Drill)LF 1,620 $475.00 $769,500.00 20 12-Inch Gate Valve EA 4 $2,000.00 $8,000.00 21 14-Inch Gate Valve EA 2 $5,000.00 $10,000.00 22 16-Inch Gate Valve EA 8 $12,500.00 $100,000.00 23 18-Inch Gate Valve EA 6 $15,000.00 $90,000.00 24 Blow-Off Valve (6")EA 3 $10,000.00 $30,000.00 25 Air Release Valve EA 3 $7,500.00 $22,500.00 26 Connect to Existing Water Line (12-Inch to 14-Inch)EA 1 $8,000.00 $8,000.00 27 Connect to Existing Water Line (14-Inch to 10-Inch)EA 1 $8,000.00 $8,000.00 28 Connect to Existing Water Line (12-Inch to 12-Inch)EA 1 $8,000.00 $8,000.00 29 Connect to Elevated Storage Tank EA 1 $10,000.00 $10,000.00 30 Sodding SY 8,169 $5.00 $40,845.00 31 Topsoil (4-Inches)SY 8,169 $3.00 $24,507.00 32 Silt Fence LF 4,902 $3.00 $14,706.00 33 Traffic Control LS 1 $50,000.00 $50,000.00 34 Storm Drain Junction Box (5'x3')EA 1 $5,000.00 $5,000.00 35 RCP (18")LF 12 $55.00 $660.00 Subtotal Section I $2,710,500 SUBTOTAL CONSTRUCTION $2,710,500 CONTINGENCY (10%)$271,050 TOTAL CONSTRUCTION $2,981,550 BASIC ENGINEERNIG SERVICES (SURVEYING AND ENGINEERING DESIGN)$357,500 RIGHT-OF-WAY ACQUISTION SERVICES (7 PARCELS)$121,088 CONSTRUCTION INSPECTION SERVICES $103,680 PROPERTY OWNER COMPENSATION FOR EASEMENTS $386,000 CONSTRUCTION MATERIAL TESTING (2.5%)$67,763 ISSUANCE COSTS $420,000 PROJECT TOTAL COST $4,437,581 ENGINEER'S STATEMENT OF PROBABLE COST TROPHY CLUB MUD No.1 PRELIMINARY (50%) DESIGN From HSPS to EST NOTE: This statement was prepared utilizing standard cost and/or estimating practices. It is understood and agreed that this is a statement of probable construction cost only, and the Engineer shall not be liable to the Owner or any Third Party for any failure to accurately estimate the cost and/or quantities for the project, or any part thereof. ITEM NO.DESCRIPTION UNIT QTY Engineer's Estimate Section I - Water Line Waterline Interconnect_Probable Cost for Board (10-10-2018) HALFF ASSOCIATES, INC. 4000 Fossil Creek Boulevard Fort Worth, Texas 76137 (817) 817-1422 1 of 1 10/10/2018 October 15, 2018 Regular Meeting Agenda Packet 55 of 171       STAFF REPORT  October 15, 2018      Agenda Item ‐ Consider and take appropriate action regarding approval of acquisition of a 2019  Dodge 1500 Quad Cab truck for the water department to be purchased through the Buy Board  contract at Grapevine Dodge Chrysler Jeep for an amount of $26,571.      Staff Report – This vehicle will replace the current on‐call truck a 2011 Ford F150.  This vehicle  has over 70,000 miles and has required full brake replacement twice in the last twelve months.   Staff is noticing issues with the transmission and requested to have the new vehicle placed on  an agenda for approval.  Anticipated delivery time from date of order is expected to be 3 – 4  months at which time the current on‐call vehicle will be 8 years old and have over 80,000 miles.      October 15, 2018 Regular Meeting Agenda Packet 56 of 171  16,993  kkkkk      End Use: TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1                 Rep:       Dennis Thomas       Contact:  MIKE MCMAHON                      Phone:   817‐410‐7541    Phone/Email: MMCMAHON@TCMUD.ORG                                              Email:   dthomas@grapevinedcj.com  Product Description:   2019 1500 QUAD CAB     r1                                   Date:     10/02/2018    A.       Bid Series       1500 QUAD CAB                                  A. Base Price:     B.      Published Options [Itemize each below]  Code  Options  Bid Price Code Options  Bid Price DS1L41  QUAD CAB 4X2 3756 27B 5.7L HEMI V8/8 SP AUTOMATIC 1892 DSA  ANTI SPIN AXLE 480 AJY POPULAR EQUIPMENT GROUP 640 V9X8  CLOTH SEATING/CARPET 305PW7WHITE NC AED  EXTERIOR APPEARANCE GRP 674 TXN LT265/70R17E A/T TIRES 243   SPRAY BEDLINER INCL CLASS 4 HITCH INCL RA2  UCONNECT 5.0 BLUETOOTH 674 AJB REMOTE START 383 CLF  HD VINYL MATS 131     XAC  BACKUP CAMERA INCL         Total of B. Published Options: 9,178           C.      Unpublished Options                                 $=           0.0%  Options Bid Price Options Bid Price                                      Total of C. Unpublished Options: ‐    D. Pre‐delivery Inspection:              E.  Texas State Inspection:                                                                                                                                                        $   F.  Manufacturer Destination/Delivery:                                                                                                                                 $        G.  Floor Plan Interest (for in‐stock and/or equipped vehicles):                                                                                        $  H.  Lot Insurance (for in stock and/or equipped vehicles):                                                                                                 $  I.  Contract Price Adjustment:                                                                      J. Additional Delivery Charge:     miles                                                        FOB GRAPEVINE  K.  Subtotal:                                                                                                                                                                                $        26,171  L.  Quantity Ordered                   x K =                                                                                                          $  M.  Trade in:  N. Buy Board fee            $             400  O. TOTAL PURCHASE PRICE                                                                                                                                                    $      26,571  PRODUCT PRICING SUMMARY BASED ON CONTRACT  BUY BOARD 521‐16  Grapevine Dodge Chrysler Jeep       2601 William D Tate, Grapevine, TX 76051  October 15, 2018 Regular Meeting Agenda Packet 57 of 171 October 15, 2018 Regular Meeting Agenda Packet58 of 171 October 15, 2018 Regular Meeting Agenda Packet59 of 171 October 15, 2018 Regular Meeting Agenda Packet60 of 171   Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 1 of 4                   _____________/________________  Revised 24 August 2018        Client Initial / Date  AGREEMENT FOR PROFESSIONAL ENGINEERING SERVICES ON A TASK ORDER BASIS  This Agreement for Professional Engineering Services, hereinafter called “Agreement,” is entered into by the Trophy  Club Municipal Utility District No. 1 a Municipal Utility District of the State of Texas, hereinafter referred to as  “Client”, duly authorized to act by the Board of Directors of said Client, and HALFF ASSOCIATES, INC., a Texas  corporation,  acting  through  a  duly  authorized  officer,  herein  called  “Engineer,”  relative  to  Engineer  providing  professional engineering services to the Client.  Client and Engineer when mentioned collectively shall be referred to  as the “Parties”.    W I T N E S S E T H:    For the mutual promises and benefits herein described, the Client and Engineer agree as follows:    I. Term of Agreement. This Agreement shall become effective on the date of its execution by both Parties, and shall  continue in effect thereafter until terminated as provided herein.    II. Services to be Performed by Engineer.  Engineer shall provide to the Client basic engineering services on an “as  needed” or “task order” basis as determined by the Client which services may include, but will not be limited to, those  services normally rendered by an engineer to a similar client.  It is anticipated that such services may include, but not be  limited to planning, surveying, project design, project development, and consultation regarding general engineering issues,  review of documentation, GIS services, database services, and defined construction phase services to assist the Client, as  determined by the Client.  Engineer, upon specific written request by the Client, will prepare a detailed fee schedule for the  Client’s review and approval.  Should the Client request, Engineer may agree to assist the Client in developing and preparing  a scope(s) of services responsive to a particular Task Order.  Such task orders shall be bound by and interpreted by the  terms of this Agreement.  Task Orders shall be numbered sequentially.  Task Orders will be individual stand‐alone proposals  and when executed by both Parties shall incorporate the terms of this Agreement such that this Agreement shall be  amended.   Engineer shall perform its obligations under this Agreement as an independent contractor and not as an agent  or fiduciary of any other party. Engineer shall not undertake any services prior to execution of a Task Order for such service s  executed by Client.  This Agreement is non‐exclusive, and Client may retain other professional engineers to provide services  on Client’s behalf.      III. Compensation of Engineer. Client agrees that Engineer shall be paid for any services requested by the Client, at  the hourly rates or lump sum.  Each Task Order shall specify the method of compensation applicable to the services  identified in the Task Order.  The hourly rate will be Labor Costs times 2.3 multiplier. A range of hourly rates per position is  reflected in Exhibit A, attached hereto, plus reasonable and necessary reimbursable expenses (Direct Costs) incurred by  Engineer in the performance of the requested services. Direct costs shall include, but are not limited to, long distance  telephone, postage, equipment, expendables, mileage, subcontractors or special consultants, freight, testing fees, copies  and blueprints.  See Exhibit B for the current Unit Pricing Schedule for direct costs.  Direct Costs shall be billed at 1.1 times  actual costs.  If additional services, trips or expenses are requested, Engineer will not provide such additional services until  authorized by the Client in writing to proceed.       Engineer agrees to submit monthly statements to the Client for basic professional engineering services.  These  statements will be based upon Engineer’s actual services performed and reimbursable expenses incurred, if any, and the  Client shall endeavor to make prompt payments. Each monthly invoice submitted by Engineer to the Client shall be  reasonably itemized to show the amount of work performed during  that month broken down by the identity of the person(s)  performing such work, the amount of time expended by such person(s) in performing that work, the billing rate for each  such person, and a brief summary of the work performed by each such person.   If the Client fails to pay Engineer within  thirty (30) calendar days of the receipt of Engineer’s invoice, Engineer may, after giving ten (10) days written notice to the  Client, suspend professional engineering services until payment is received.  Client agrees that Engineer shall be entitled to  interest on nondisputed accounts that are greater than 45 days and such interest shall be reimbursed to Engineer at a rate  of one percent (1%) per month.  The assessment of interest on accounts receivable shall not preclude Engineer from  suspending services as described above.    IV. Client’s  Obligations.    The  Client  agrees  that  it  will  (i)  designate  a  specific  person to act as  the Client’s  October 15, 2018 Regular Meeting Agenda Packet 61 of 171   Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 2 of 4                   _____________/________________  Revised 24 August 2018        Client Initial / Date  representative,  (ii)  provide  Engineer  with  any  previous  studies,  reports,  data,  budget  constraints,  special  Client  requirements, or other pertinent information known to the Client, when necessitated by a project, (iii) assist Engineer in  obtaining access to property necessary for performance of Engineer’s work for the Client, (iv) make prompt payments in  response to Engineer’s statements and (v) respond in a timely fashion to requests from Engineer.  Engineer is entitled to  rely upon and use, without independent verification and without liability, all information and services provided by the Client  or the Client’s representatives.     V. Termination of Work ‐ The Client may terminate this Agreement at any time with or without cause upon giving  the  other  Party  ten  (10)  calendar  days’  prior  written  notice.  Client  agrees  that  termination  of  Engineer  for  Client’s  convenience shall only be utilized in good faith.  Following Engineer’s receipt of such termination notice the Client shall,  within ten (10) calendar days of Client’s receipt of Engineer’s final invoice, pay the Engineer for all authorized services  rendered and all costs incurred up to the date of Engineer’s receipt of such notice of termination.    VI. Ownership of Documents ‐ Upon Engineer’s completion of services and receipt of payment in full, Engineer shall  grant to Client a non‐exclusive license to possess the final drawings and instruments produced in connection with Engineer’s  performance  of  the  work  under  this  Agreement,  if  any.  Said  drawings  and  instruments  may  be  copied,  duplicated,  reproduced and used by Client for the purpose of constructing, operating and maintaining the improvements. Client agrees  that such documents are not intended or represented to be suitable for reuse by Client or others for purposes outside the  Scope of Services of this Agreement. Notwithstanding the foregoing, Client understands and agrees that any and all  computer programs, GIS applications, proprietary data or processes, and standardized information related to the services  performable under this Agreement are and shall remain the sole and exclusive property of Engineer and may not be used  or reused, in any form, by Client without the express written authorization of Engineer.  Client agrees that any reuse by  Client, or by those who obtain said information from or through Client, without written verification or adaptation by  Engineer, will be at Client’s sole risk and without liability or legal exposure to Engineer or to Engineer’s employees, agents,  representatives, officers, directors, affiliates, shareholders, owners, members, managers, attorneys, subsidiary entities,  advisors, subconsultants or independent contractors or associates. Engineer may reuse all drawings, reports, data and other  information developed in performing the services described by this Agreement in Engineer’s other activities.    VII. Notices.  Any notices to be given hereunder by either party to the other may be affected either by personal  delivery, in writing, or by registered or certified mail.    VIII. Sole Parties and Entire Agreement.  This Agreement shall not create any rights or benefits to anyone except the  Client and Engineer, and contains the entire agreement between the parties.  Oral modifications to this Agreement shall  have no force or effect.     IX. Insurance.  Engineer shall, at its own expense, purchase, maintain and keep in force throughout the duration of  this Agreement and for a period of four (4) years thereafter, professional liability insurance.  The limits of liability shall be  $1,000,000 per claim and in the aggregate.  Engineer shall submi t to the Client a certificate of insurance prior to commencing   work for the Client.     X. Prompt Performance by Engineer.  All services provided by Engineer hereunder shall be performed in accordance  with the degree of care and skill ordinarily exercised under similar circumstances by competent members of the engineering  profession in the State of Texas applicable to such engineering services contemplated by this Agreement.      XI. Client Objection to Personnel.  If at any time after entering into this Agreement, the Client has any reasonable  objection to any of Engineer’s personnel, or any personnel, professionals and/or consultants retained by Engineer, Engineer  shall promptly propose substitutes to whom the Client has no reasonable objection, and Engineer’s compensation shall be  equitably adjusted to reflect any difference in Engineer’s costs occasioned by such substitution.    XII. Assignment and Delegation.  Neither the Client nor Engineer may assign their rights or delegate their duties  without the written consent of the other party.  This Agreement is binding on the Client and Engineer to the fullest extent  permitted by law.  Nothing herein is to be construed as creating any personal liability on the part of any Client officer,  employee or agent.    October 15, 2018 Regular Meeting Agenda Packet 62 of 171   Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 3 of 4                   _____________/________________  Revised 24 August 2018        Client Initial / Date  XIII. Jurisdiction and Venue ‐ This Agreement shall be administered under the substantive laws of the State Texas (and  not its conflicts of law principles) which shall be used to govern all matters arising out of, or relating to, this Agreement and  all of the transactions it contemplates, including without limitation, its validity, interpretation, construction, performance  and enforcement.  Venue shall lie exclusively in Denton and Tarrant County, Texas.    XIV. Integration, Merger and Severability – This Agreement and the authorized Task Orders are fully incorporated  herein and represent the entire understanding of Client and Engineer. No prior oral or written understanding shall be of  any force or effect with respect to those matters covered herein. The Agreement may not be modified or altered except in  writing signed by both Parties. This Agreement constitutes, represents and is intended by the Parties to be the complete  and final statement and expression of all of the terms and arrangements between the Parties to this Agreement with respect  to the matters provided for in this Agreement.  This Agreement supersedes  any  and  all  prior  or  contemporaneous  agreements, understandings, negotiations, and discussions between the Parties and all such matters are merged into this  Agreement.  Should any one or more of the provisions contained in this Agreement be determined by a court of competent  jurisdiction or by legislative pronouncement to be void, invalid, illegal, or unenforceable in any respect, such voiding,  invalidity, illegality, or unenforceability shall not affect any other provision hereof, and this Agreement shall be considered  as if the entirety of such void, invalid, illegal, or unenforceable provision had never been contained in this Agreement.    XV. Exclusivity of Remedies – The Parties acknowledge and agree that the remedies set forth in this Agreement,  including those set forth in Article XIX. Agreed Remedies are and shall remain the Parties’ sole and exclusive remedy with  respect to any claim arising from, or out of, or related to, the subject matter of this Agreement.   The Parties agree that  Engineer is to have no liability or responsibility whatsoever to Client for any claim(s) or loss(es) of any nature, except as set  forth in this Agreement.   No Party shall be able to avoid the limitations expressly set forth in this Agreement by electing to  pursue some other remedy.     XVI.   Timeliness of Performance ‐ Engineer shall perform its professional services with due and reasonable diligence  consistent with sound professional practices.    XVII. Dispute Resolution.  In the event of any disagreement or conflict concerning the interpretation of this Agreement,  and such disagreement cannot be resolved by the signatories hereto, the signatories agree to schedule a series of no less  than two meetings of senior personnel of Client and Engineer in which the disagreement or conflict will be discussed.  The  first of such meetings will be scheduled as soon as possible following identification of such disagreement or conflict and the  second meeting must occur within thirty (30) days following the initial meeting.  Subsequent meetings, if any may be  scheduled upon mutual agreement of the parties.  The parties agree that these two meetings are conditions precedent to  the institution of legal proceedings unless such meetings will adversely affect the rights of one or more of the parties as  such rights relate to statutes of limitation or repose.     XVIII. Signatories.  The Client and Engineer mutually warrant and represent that the representation of each who is  executing this Agreement on behalf of the Client or Engineer, respectively, has full authority to execute this Agreement and  bind the entity so represented.    XIX.   PROJECT ENHANCEMENT ‐ IF DUE TO ANY ALLEGED OR ACTUAL BREACH OF CONTRACT, NEGLIGENCE, ERROR,  OR DEFICIENCY IN THE SERVICES OF ENGINEER OR ANY OF ITS CONSULTANTS, ANY ITEM, COMPONENT, OR CONDITION  OF THE SERVICES IS INACCURATE OR OMITTED FROM ANY OF THE DESIGN  DOCUMENTS  PRODUCED  THROUGH  ENGINEER’S SERVICES, EGINEER’S AND ITS CONSULTANT’S LIABILITY, IF ANY, SHALL BE LIMITED TO THE DIFFERENCE  BETWEEN: I) THE COST OF ADDING, CORRECTING OR REPLACING THE ITEM AT THE TIME THE ERROR IS DISCOVERED, AND  II) THE COST HAD THE ITEM OR COMPONENT BEEN INCLUDED OR CORRECT IN THE DESIGN DOCUMENTS PROVIDED PRIOR  TO THE TIME CONSTRUCTION BEGAN. HOWEVER, IF THE CORRECTION TO THE  DESIGN  PROVIDES  ADDED  VALUE,  UPGRADE, OR ENHANCEMENT TO THE PROJECT OF CLIENT/OWNER, THE AMOUNT OF DAMAGES, IF ANY, SHALL BE  ADJUSTED DOWN BASED ON SUCH ADDED VALUE, UPGRADE, OR ENHANCEMENT OF THE PROJECT. CLIENT/OWNER  SHALL BE RESPONSIBLE FOR ANY COST OR EXPENSE ASSOCIATED WITH THE CORRECTION THAT PROVIDES ADDED VALUE,  UPGRADE, OR ENHANCEMENT OF THE PROJECT. IN NO EVENT AND REGARDLESS OF THE LEGAL THEORY OR FACTUAL  BASIS  OF  ANY  CLAIM, SHALL  ENGINEER’S  OR ITS  CONSULTANT’S  LIABILITY  INCLUDE  ANY  COST  OR  EXPENSE  THAT  PROVIDES  ADDED  VALUE,  UPGRADE,  OR  ENHANCEMENT  OF  THE  PROJECT.  IN  ADDITION,  IF  ANY  SUCH  ITEM,  COMPONENT,  OR  CONDITION  HAS  AN  IDENTIFIABLE  USEFUL  LIKE  THAT  IS LESS THAN THE BUILDING ITSELF, THE  DAMAGES OF THE CLIENT/OWNER SHALL BE REDUCED TO THE EXTENT THAT THE USEFUL LIFE OF THE COMPONENT WILL  October 15, 2018 Regular Meeting Agenda Packet 63 of 171   Agreement For Professional Services (Municipal Client‐Task Order) ‐ Page 4 of 4                   _____________/________________  Revised 24 August 2018        Client Initial / Date  BE EXTENDED BY THE REPLACEMENT THEREOF.  NOTWITHSTANDING THE FO REGOING OR ANY OTHER PROVISION HEREIN  TO THE CONTRARY, IN THE EVENT THAT ANY PROJECT OR WORK IS DEFECTIVE AND NEEDS TO BE CORRECTED DUE TO A  BREACH OF CONTRACT, NEGLIGENCE, ERROR OR DEFICIENCY IN THE SERVICES RENDERED BY ENGINEER, THE FOREGOING  LIMITATION OF LIABILITY SHALL NOT APPLY AND ENGINEER SHALL BE RESPONSIBLE FOR THE NON‐BETTERMENT COSTS  OF REPAIRING OR REPLACING SUCH DEFECTIVE WORK OR PROJECT.     XX.   AGREED REMEDIES   A.   IT IS THE INTENT OF THE PARTIES TO THIS AGREEMENT THAT ENGINEER'S SERVICES UNDER THIS AGREEMENT  SHALL NOT SUBJECT ENGINEER'S INDIVIDUAL EMPLOYEES, OFFICERS OR DIRECTORS TO ANY PERSONAL LEGAL EXPOSURE  FOR CLAIMS AND RISKS ASSOCIATED WITH THE SERVICES PERFORMED OR PERFORMABLE UNDER THIS AGREEMENT.      XXI.   Waiver ‐ Any failure by either party to require strict compliance with any provision of this Agreement shall not be  construed  as  a  waiver  of  such  provision,  and  either  party  may  subsequently  require  strict  compliance  at  any  time,  notwithstanding any prior failure to do so.           IN WITNESS WHEREOF, the parties, having read and understood this Agreement, have executed such in duplicate copies,  each of which shall have full dignity and force as an original, on the _____ day of _______________________, 20___.        HALFF ASSOCIATES, INC.                                              CLIENT: TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1    By:    ______________________________  By:   _______________________________   Signature     Signature      ______________________________    ________________________________   Printed Name     Printed Name      ______________________________    ________________________________   Title      Title      ______________________________    ________________________________   Date      Date    October 15, 2018 Regular Meeting Agenda Packet 64 of 171 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET SEPTEMBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 543,883 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 15,308 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 559,191 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 15,308 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 15,308 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 522,253 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 21,631 TOTAL FUND BALANCE 543,883 TOTAL LIABILITIES AND FUND BALANCE 559,191 October 15, 2018 Regular Meeting Agenda Packet 65 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 22:50 10/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2018 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- 79.09- 1,066,060.62- 101.103 11,627.62 122-40011-000-000 Property Taxes/Fire-Delinquent 3,945.10- 3,945.10 122-40020-000-000 Property Taxes/Fire P&I 8.71- 4,786.64- 4,786.64 Subtotal: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Program number: 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Department number: Fire Revenues 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 Revenues Subtotal ----------- 1,054,433.00- 1,054,433.00- 87.80- 1,074,792.36- 101.931 20,359.36 October 15, 2018 Regular Meeting Agenda Packet 66 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 22:50 10/11/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2018 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 100.000 122-60055-045-000 Insurance 18,000.00 18,000.00 1,269.84 15,238.41 84.658 2,761.59 122-60337-045-000 Transfer to Town/Fire Budget 608,910.00 608,910.00 50,742.50 608,910.00 100.000 Subtotal: 845,864.00 845,864.00 52,012.34 843,102.41 99.674 2,761.59 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.34 1,053,161.50 99.879 1,271.50 Department number: Fire 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50 Expenditures Subtotal ----------- 1,054,433.00 1,054,433.00 52,012.34 1,053,161.50 99.879 1,271.50 Fund number: 122 Trophy Club MUD Fire Dept. 51,924.54 21,630.86- 21,630.86 October 15, 2018 Regular Meeting Agenda Packet 67 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 9/2018 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 2153 09/04/2018 Property Taxes (1,065,981.53) (54.72) (1,066,036.25) GL 2154 09/28/2018 Property Taxes (24.37) (1,066,060.62) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (79.09) (1,066,060.62) ** (1,054,433.00) Budgeted 11,627.62 Remaining 101 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent (3,945.10) .00 (3,945.10) _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: .00 (3,945.10) ** .00 Budgeted 3,945.10 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 2153 09/04/2018 Property Taxes (4,777.93) (3.83) (4,781.76) GL 2154 09/28/2018 Property Taxes (4.88) (4,786.64) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (8.71) (4,786.64) ** .00 Budgeted 4,786.64 Remaining 0 % Used Department Totals: ----------------------------------- (1,074,792.36) ** (87.80) Monthly Total (1,054,433.00) Budgeted 20,359.36 Remaining 102 % Used October 15, 2018 Regular Meeting Agenda Packet 68 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2018 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 218,954.00 .00 218,954.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 218,954.00 ** 218,954.00 Budgeted .00 Remaining 100 % Used Account: 122-60055-045-000 Insurance 243 09/01/2018 Insurance/Wrk Comp Exp Sep 13,968.57 1,269.84 15,238.41 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,269.84 15,238.41 ** 18,000.00 Budgeted 2,761.59 Remaining 85 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 2034 09/07/2018 September A/P September Fire Admin 558,167.50 50,742.50 608,910.00 TOWN OF TROPHY CLUB 4552 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 50,742.50 608,910.00 ** 608,910.00 Budgeted .00 Remaining 100 % 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: ----------------------------------- 1,053,161.50 ** 52,012.34 Monthly Total 1,054,433.00 Budgeted 1,271.50 Remaining 100 % Used October 15, 2018 Regular Meeting Agenda Packet 69 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 9/2018 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: ----------------------------------- (21,630.86) 51,924.54 Monthly Total .00 Budgeted 21,630.86 Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 70 of 171 TROPHY CLUB MUD #1 - O&M BALANCE SHEET SEPTEMBER 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 1,379,652 - 1,379,652 CASH IN BANK-SAVINGS-CASH RESERVE 983,515 - 983,515 CD-BANK OF THE WEST/THB DEPOSIT - - - INVESTMENTS-MONEY MARKET-BANK OF THE WEST - - - INVESTMENTS-TEXPOOL 3,227,798 596,426 3,824,224 PREPAID EXPENSES 8,486 - 8,486 ADVALOREM PROPERTY TAXES RECEIVABLE 1,644 - 1,644 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,473,411 - 1,473,411 TOTAL ASSETS 7,075,105 596,426 7,671,531 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,644 - 1,644 ACCOUNTS AND OTHER PAYABLES 308,547 - 308,547 CUSTOMER DEPOSITS 312,115 - 312,115 - TOTAL LIABILITIES 622,306 - 622,306 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 2,302,431 - 2,302,431 - TOTAL FUND BALANCE 6,452,799 596,426 7,049,225 TOTAL LIABILITIES AND FUND BALANCE 7,075,105 596,426 7,671,531 October 15, 2018 Regular Meeting Agenda Packet 71 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 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- 9.08- 122,278.88- 101.099 1,328.88 135-40002-000-000 Property Taxes/Delinquent 200.00- 200.00- 347.07- 173.535 147.07 135-40015-000-000 Property Taxes/P & I 200.00- 200.00- .99- 530.33- 265.165 330.33 135-40025-000-000 PID Surcharges 177,839.00- 177,839.00- 177,839.00- Subtotal: 299,189.00- 299,189.00- 10.07- 123,156.28- 41.163 176,032.72- 135-47000-000-000 Water 6,464,019.00- 6,464,019.00- 489,452.77- 5,953,140.59- 92.097 510,878.41- 135-47005-000-000 Sewer 2,978,067.00- 2,978,067.00- 258,662.34- 2,992,699.99- 100.491 14,632.99 135-47025-000-000 Penalties 106,279.00- 106,279.00- 16,306.53- 119,593.62- 112.528 13,314.62 135-47030-000-000 Service Charges 21,350.00- 14,350.00- 1,550.00- 13,880.50- 96.728 469.50- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 150.00- 2,200.00- 146.667 700.00 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 450.00- 5,800.00- 128.889 1,300.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 5,025.60- 81,611.20- 136.019 21,611.20 Subtotal: 9,635,715.00- 9,628,715.00- 771,597.24- 9,168,925.90- 95.225 459,789.10- 135-49010-000-000 Interest Income 12,000.00- 50,000.00- 8,443.30- 58,856.46- 117.713 8,856.46 135-49016-000-000 Cell Tower Revenue 10,926.00- 10,926.00- 1,178.81- 12,077.44- 110.539 1,151.44 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.36- 6,999.99- 100.000 .01- 135-49026-000-000 Proceeds from Sale of Assets 2,000.00- 15,400.00- 15,400.00- 100.000 135-49075-000-000 Oversize Meter Reimbursement 18,179.00- 18,179.00- 1,029.00- 14,236.76- 78.314 3,942.24- 135-49141-000-000 Interfund Transfer In 796,145.00- 1,053,935.08 797,834.14- 100.212 1,689.14 135-49900-000-000 Miscellaneous Income 5,000.00- 15,000.00- 419.28 59,047.04- 393.647 44,047.04 135-49901-000-000 Records Management Revenue 20.00- 20.00- 2.00- 10.000 18.00- 135-49910-000-000 Reimbursement/Revenue Bond 260,000.00- 260,000.00- 260,000.00- Subtotal: 315,125.00- 1,172,670.00- 1,043,119.89 964,453.83- 82.244 208,216.17- Program number: 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- Department number: Revenues 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- Revenues Subtotal ----------- 10,250,029.00- 11,100,574.00- 271,512.58 10,256,536.01- 92.396 844,037.99- October 15, 2018 Regular Meeting Agenda Packet 72 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 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 26,095.72 234,283.97 85.418 39,995.03 135-50010-010-000 Overtime 20,000.00 20,000.00 1,191.16 14,133.01 70.665 5,866.99 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 200.00 2,425.00 73.485 875.00 135-50020-010-000 Retirement 27,843.00 27,843.00 2,542.54 24,919.02 89.498 2,923.98 135-50026-010-000 Medical Insurance 52,196.00 52,196.00 2,948.80 32,815.76 62.870 19,380.24 135-50027-010-000 Dental Insurance 5,182.00 5,182.00 213.65 2,589.29 49.967 2,592.71 135-50028-010-000 Vision Insurance 994.00 994.00 35.92 459.83 46.261 534.17 135-50029-010-000 Life Insurance & Other 2,982.00 2,982.00 215.61 2,555.15 85.686 426.85 135-50030-010-000 Social Security Taxes 18,662.00 18,662.00 1,685.10 15,638.91 83.801 3,023.09 135-50035-010-000 Medicare Taxes 4,365.00 4,365.00 394.10 3,657.49 83.791 707.51 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 818.68 75.804 261.32 135-50045-010-000 Workman's Compensation 11,854.00 11,854.00 899.88 10,799.00 91.100 1,055.00 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 285.05 142.525 85.05- 135-50070-010-000 Employee Relations 300.00 300.00 138.84 178.13 59.377 121.87 Subtotal: 426,662.00 426,662.00 36,561.32 348,868.29 81.767 77,793.71 135-55005-010-000 Engineering 275,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 1,111.78 100,900.75 100.901 900.75- 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 147.97 5,216.24 130.406 1,216.24- 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 35.00 1.000 3,465.00 135-55135-010-000 Lab Analysis 5,500.00 5,500.00 817.70 7,412.86 134.779 1,912.86- Subtotal: 391,000.00 116,000.00 2,077.45 113,564.85 97.901 2,435.15 135-60010-010-000 Communications/Mobiles 4,700.00 4,700.00 369.91 3,972.63 84.524 727.37 135-60020-010-000 Electricity 175,356.00 150,000.00 15,109.51 140,190.42 93.460 9,809.58 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 767.00 76.700 233.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 680.00 2,888.78 103.726 103.78- 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 24,220.32 43.896 30,955.68 135-60150-010-000 Wholesale Water 2,823,170.00 2,823,170.00 291,820.90 2,162,163.82 76.586 661,006.18 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 974.70 32.490 2,025.30 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 750.00 11,250.00 76.271 3,500.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 278,084.00 278,084.00 278,083.50 100.000 .50 135-60333-010-000 Interfund Transfer Out-Reserve 48,996.00 48,996.00 4,083.00 48,996.00 100.000 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 1,053,935.08- 200,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 5,019.66 200.786 2,519.66- October 15, 2018 Regular Meeting Agenda Packet 73 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 3,613,852.00 3,588,496.00 741,121.76- 2,678,622.67 74.645 909,873.33 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 993.47 11,207.95 74.720 3,792.05 135-65010-010-000 Uniforms 4,488.00 4,488.00 1,382.63 2,631.77 58.640 1,856.23 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,603.29 18,687.20 93.436 1,312.80 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,080.95 108.095 80.95- 135-65050-010-000 Meter Expense 50,000.00 50,000.00 24,975.75 49.952 25,024.25 135-65053-010-000 Meter Change Out Program 84,000.00 84,000.00 82,312.50 97.991 1,687.50 Subtotal: 175,688.00 175,688.00 3,979.39 140,896.12 80.197 34,791.88 135-69005-010-000 Capital Outlays 810,012.00 1,085,012.00 79,244.33- 511,131.56 47.108 573,880.44 135-69008-010-000 Short Term Debt-Principal 38,731.00 135-69009-010-000 Short Term Debt-Interest 5,713.00 5,713.00 2,271.24 39.756 3,441.76 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 110,001.00 107,864.38 98.058 2,136.62 Subtotal: 1,048,231.00 1,275,726.00 79,244.33- 696,267.18 54.578 579,458.82 Program number: 5,655,433.00 5,582,572.00 777,747.93- 3,978,219.11 71.261 1,604,352.89 October 15, 2018 Regular Meeting Agenda Packet 74 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2018 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 367.70 1,752.78 87.639 247.22 Subtotal: 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 367.70 1,752.78 87.639 247.22 Department number: Water 5,657,433.00 5,584,572.00 777,380.23- 3,979,971.89 71.267 1,604,600.11 October 15, 2018 Regular Meeting Agenda Packet 75 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 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 25,205.59 349,759.54 85.127 61,106.46 135-50010-020-000 Overtime 30,000.00 30,000.00 2,706.07 33,380.39 111.268 3,380.39- 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 8,436.00 100.429 36.00- 135-50020-020-000 Retirement 42,243.00 42,243.00 2,646.58 38,360.85 90.810 3,882.15 135-50026-020-000 Medical Insurance 62,175.00 62,175.00 5,518.69 65,584.02 105.483 3,409.02- 135-50027-020-000 Dental Insurance 5,271.00 5,271.00 371.89 4,691.74 89.010 579.26 135-50028-020-000 Vision Insurance 1,114.00 1,114.00 58.90 802.86 72.070 311.14 135-50029-020-000 Life Insurance & Other 4,281.00 4,281.00 321.20 4,168.88 97.381 112.12 135-50030-020-000 Social Security Taxes 28,314.00 28,314.00 1,593.24 22,807.95 80.554 5,506.05 135-50035-020-000 Medicare Taxes 6,622.00 6,622.00 372.62 5,334.11 80.551 1,287.89 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,134.00 90.000 126.00 135-50045-020-000 Workman's Compensation 17,990.00 17,990.00 1,348.00 16,176.00 89.917 1,814.00 135-50060-020-000 Pre-emp Physicals/Testing 300.00 300.00 38.00 273.00 91.000 27.00 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 626,601.00 626,601.00 40,880.78 558,324.34 89.104 68,276.66 135-55070-020-000 Independent Labor 20,550.00 5,550.00 2,145.00 38.649 3,405.00 135-55080-020-000 Maintenance & Repairs 86,100.00 86,100.00 4,747.50 82,754.50 96.114 3,345.50 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 149.70 9,821.71 122.771 1,821.71- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 500.00 500.00 395.40 79.080 104.60 135-55125-020-000 Dumpster Services 60,000.00 60,000.00 3,359.30 68,016.07 113.360 8,016.07- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,286.00 31,558.02 105.193 1,558.02- Subtotal: 219,150.00 204,150.00 10,542.50 194,719.48 95.381 9,430.52 135-60010-020-000 Communications/Mobiles 4,700.00 4,700.00 381.26 4,843.51 103.053 143.51- 135-60020-020-000 Electricity 266,709.00 176,709.00 13,857.87 161,570.67 91.433 15,138.33 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 60.00 20.000 240.00 135-60080-020-000 Schools & Training 5,677.00 5,677.00 658.00 11.591 5,019.00 135-60090-020-000 Safety Program 550.00 550.00 351.72 63.949 198.28 135-60100-020-000 Travel & per diem 1,635.00 1,635.00 90.46 5.533 1,544.54 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 30,272.52 35.615 54,727.48 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 .01 .002 449.99 135-60280-020-000 Property Maintenance 4,000.00 4,000.00 231.73 273.61 6.840 3,726.39 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 8,730.00 75.259 2,870.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 122,043.00 122,043.00 100.000 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 598,738.00 598,738.00 100.000 135-60333-020-000 Interfund Transfer Out-Reserve 123,336.00 123,336.00 10,278.00 123,336.00 100.000 October 15, 2018 Regular Meeting Agenda Packet 76 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 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 944,512.00 27,213.59 671,726.04 71.119 272,785.96 135-60360-020-000 Furniture/Equipment < $5000 4,000.00 4,000.00 1,762.00 44.050 2,238.00 Subtotal: 1,438,938.00 2,093,450.00 52,552.45 1,724,455.54 82.374 368,994.46 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 812.01 8,932.87 71.463 3,567.13 135-65010-020-000 Uniforms 4,459.00 4,459.00 1,075.40 2,929.97 65.709 1,529.03 135-65030-020-000 Chemicals 27,500.00 27,500.00 4,957.86 19,715.59 71.693 7,784.41 135-65035-020-000 Small Tools 1,000.00 1,000.00 1,436.14 143.614 436.14- 135-65040-020-000 Safety Equipment 750.00 750.00 1,157.50 154.333 407.50- 135-65045-020-000 Lab Supplies 14,000.00 14,000.00 1,872.67 20,747.74 148.198 6,747.74- Subtotal: 60,209.00 60,209.00 8,717.94 54,919.81 91.215 5,289.19 135-69005-020-000 Capital Outlays 547,327.00 547,327.00 85.00 108,729.29 19.866 438,597.71 135-69008-020-000 Short Term Debt-Principal 51,342.00 135-69009-020-000 Short Term Debt-Interest 7,573.00 7,573.00 3,010.73 39.756 4,562.27 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 636,242.00 584,900.00 85.00 141,740.02 24.233 443,159.98 Program number: 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81 Department number: Wastewater 2,981,140.00 3,569,310.00 112,778.67 2,674,159.19 74.921 895,150.81 October 15, 2018 Regular Meeting Agenda Packet 77 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2018 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.38 29.00 96.667 1.00 Subtotal: 30.00 30.00 2.38 29.00 96.667 1.00 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 31.74 135.00 11.250 1,065.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 2,755.00 68.875 1,245.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 4,768.22 95.364 231.78 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 1,473.98 73.699 526.02 Subtotal: 12,950.00 12,950.00 31.74 9,782.20 75.538 3,167.80 Program number: 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80 Department number: Board of Directors 12,980.00 12,980.00 34.12 9,811.20 75.587 3,168.80 October 15, 2018 Regular Meeting Agenda Packet 78 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 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 31,785.74 368,987.21 85.243 63,875.79 135-50010-030-000 Overtime 2,000.00 2,000.00 2.95 566.00 28.300 1,434.00 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 2,940.44 36,818.75 90.792 3,734.25 135-50026-030-000 Medical Insurance 63,485.00 63,485.00 4,145.24 47,490.83 74.806 15,994.17 135-50027-030-000 Dental Insurance 5,502.00 5,502.00 259.52 3,276.89 59.558 2,225.11 135-50028-030-000 Vision Insurance 1,173.00 1,173.00 42.51 589.88 50.288 583.12 135-50029-030-000 Life Insurance & Other 5,059.00 5,059.00 282.49 3,716.55 73.464 1,342.45 135-50030-030-000 Social Security Taxes 27,181.00 27,181.00 1,892.22 22,201.40 81.680 4,979.60 135-50035-030-000 Medicare Taxes 6,357.00 6,357.00 442.53 5,192.25 81.678 1,164.75 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 6.23 1,145.77 90.934 114.23 135-50045-030-000 Workman's Compensation 1,529.00 1,529.00 123.50 1,482.00 96.926 47.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 211.90 42.380 288.10 135-50070-030-000 Employee Relations 4,960.00 4,960.00 3,273.18 65.992 1,686.82 Subtotal: 595,970.00 595,970.00 41,923.37 498,500.11 83.645 97,469.89 135-55030-030-000 Software & Support 78,391.00 78,391.00 1,929.11 68,007.47 86.754 10,383.53 135-55070-030-000 Independent Labor 154,000.00 154,000.00 14,150.30 153,669.10 99.785 330.90 135-55080-030-000 Maintenance & Repairs 14,000.00 14,000.00 5,183.13 10,583.61 75.597 3,416.39 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 4,624.58 46.246 5,375.42 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 869.06 9,176.75 91.768 823.25 135-55160-030-000 Professional Outside Services 63,325.00 63,325.00 3,060.00 62,300.00 98.381 1,025.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,170.74 7,062.54 78.473 1,937.46 Subtotal: 338,916.00 338,916.00 26,362.34 315,424.05 93.069 23,491.95 135-60005-030-000 Telephone 27,300.00 17,300.00 3,016.78 18,245.89 105.468 945.89- 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.33 2,986.16 74.654 1,013.84 135-60020-030-000 Electricity/Gas 16,261.00 16,261.00 602.05 6,590.97 40.532 9,670.03 135-60025-030-000 Water 2,500.00 2,500.00 58.32 718.83 28.753 1,781.17 135-60035-030-000 Postage 30,000.00 30,000.00 3,270.58 21,120.05 70.400 8,879.95 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,639.91 62,305.61 112.141 6,745.61- 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.33 76,999.29 137.499 20,999.29- 135-60066-030-000 Publications/Books/Subscripts 1,600.00 1,600.00 153.40 359.78 22.486 1,240.22 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 3,988.42 66.474 2,011.58 135-60075-030-000 Meetings 400.00 400.00 133.56 33.390 266.44 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 3,238.00 42.605 4,362.00 135-60100-030-000 Travel & per diem 4,885.00 4,885.00 5.78 1,677.10 34.332 3,207.90 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60115-030-000 Elections 4,500.00 4,500.00 220.00 4.889 4,280.00 October 15, 2018 Regular Meeting Agenda Packet 79 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60125-030-000 Advertising 2,500.00 2,500.00 625.00 925.00 37.000 1,575.00 135-60235-030-000 Security 2,700.00 2,700.00 24.00 442.00 16.370 2,258.00 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 124.50 24.900 375.50 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 100.000 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 211.99 8.480 2,288.01 Subtotal: 249,506.00 239,506.00 20,733.48 217,287.15 90.723 22,218.85 135-65010-030-000 Uniforms 700.00 700.00 473.72 747.45 106.779 47.45- 135-65055-030-000 Hardware 7,420.00 7,420.00 4,795.74 6,802.42 91.677 617.58 135-65085-030-000 Office Supplies 7,000.00 7,000.00 1,082.36 5,331.03 76.158 1,668.97 135-65090-030-000 Printer Supplies & Maintenance 2,000.00 2,000.00 2,365.05 118.253 365.05- 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 401.91 4,198.62 104.966 198.62- 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 6,753.73 19,588.57 77.980 5,531.43 135-69005-030-000 Capital Outlays 13,000.00 13,000.00 48,354.99 371.961 35,354.99- 135-69170-030-000 Copier Lease Installments 4,600.00 4,600.00 668.74 3,231.05 70.240 1,368.95 Subtotal: 17,600.00 17,600.00 668.74 51,586.04 293.103 33,986.04- Program number: 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08 Department number: Administration 1,227,112.00 1,217,112.00 96,441.66 1,102,385.92 90.574 114,726.08 October 15, 2018 Regular Meeting Agenda Packet 80 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 22:50 10/11/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2018 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 26,092.31 148,454.21 108.361 11,454.21- 135-55055-039-000 Auditing 24,500.00 24,500.00 25,658.70 104.729 1,158.70- 135-55060-039-000 Appraisal 11,446.00 11,446.00 2,011.87 10,695.79 93.446 750.21 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 2,968.40 78.116 831.60 Subtotal: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Program number: 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Department number: Non Departmental 176,746.00 176,746.00 28,104.18 187,777.10 106.241 11,031.10- Expenditures Subtotal ----------- 10,055,411.00 10,560,720.00 540,021.60- 7,954,105.30 75.318 2,606,614.70 Fund number: 135 MUD 1 General Fund 194,618.00- 539,854.00- 268,509.02- 2,302,430.71- 426.491 1,762,576.71 October 15, 2018 Regular Meeting Agenda Packet 81 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 22:50 10/11/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2018 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 October 15, 2018 Regular Meeting Agenda Packet 82 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 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 2153 09/04/2018 Property Taxes (122,269.80) (6.28) (122,276.08) GL 2154 09/28/2018 Property Taxes (2.80) (122,278.88) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (9.08) (122,278.88) ** (120,950.00) Budgeted 1,328.88 Remaining 101 % Used Account: 135-40002-000-000 Property Taxes/Delinquent (347.07) .00 (347.07) _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: .00 (347.07) ** (200.00) Budgeted 147.07 Remaining 174 % Used Account: 135-40015-000-000 Property Taxes/P & I 2153 09/04/2018 Property Taxes (529.34) (.44) (529.78) GL 2154 09/28/2018 Property Taxes (.55) (530.33) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (.99) (530.33) ** (200.00) Budgeted 330.33 Remaining 265 % 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 2103 09/18/2018 UB 09/18/2018 Payment Adjustme UB20180918-20180918 User: (5,463,687.82) 289.03 (5,463,398.79) UB 2115 09/24/2018 UB 09/24/2018 Water adjustment UB20180924-20180924 User: 239.94 (5,463,158.85) UB 2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: 534.48 (5,462,624.37) UB 2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: 439.89 (5,462,184.48) UB 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (490,956.11) (5,953,140.59) UB _______________ Account: 135-47000-000-000 Water Totals: (489,452.77) (5,953,140.59) ** (6,464,019.00) Budgeted (510,878.41) Remaining 92 % Used Account: 135-47005-000-000 Sewer 2150 09/25/2018 222 oak Hill drive UB20180925-20180925 User: (2,734,037.65) 79.12 (2,733,958.53) UB October 15, 2018 Regular Meeting Agenda Packet 83 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (2,734,037.65) (258,741.46) (2,992,699.99) UB _______________ Account: 135-47005-000-000 Sewer Totals: (258,662.34) (2,992,699.99) ** (2,978,067.00) Budgeted 14,632.99 Remaining 100 % Used Account: 135-47025-000-000 Penalties 2026 09/06/2018 UB 09/06/2018 Penalty removal UB20180906-20180906 User: (103,287.09) 88.14 (103,198.95) UB 2109 09/21/2018 UB 09/21/2018 Penalties UB20180921-20180921 User: (22,752.51) (125,951.46) UB 2122 09/25/2018 UB 09/25/2018 Penalty removal UB20180925-20180925 User: 142.27 (125,809.19) UB 2129 09/27/2018 UB 09/27/2018 Penalty removal UB20180927-20180927 User: 6,157.89 (119,651.30) UB 2133 09/27/2018 UB 09/27/2018 Penalty Removal UB20180927-20180927 User: 43.53 (119,607.77) UB 2137 09/28/2018 UB 09/28/2018 Penalty removal UB20180928-20180928 User: 14.15 (119,593.62) UB _______________ Account: 135-47025-000-000 Penalties Totals: (16,306.53) (119,593.62) ** (106,279.00) Budgeted 13,314.62 Remaining 113 % Used Account: 135-47030-000-000 Service Charges 2005 09/05/2018 UB 09/05/2018 Disconnect Fees UB20180905-20180905 User: (12,330.50) (1,500.00) (13,830.50) UB 2107 09/20/2018 UB 09/20/2018 NSF check UB20180920-20180920 User: (25.00) (13,855.50) UB 2106 09/21/2018 UB 09/21/2018 NSF check UB20180921-20180921 User: (25.00) (13,880.50) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,550.00) (13,880.50) ** (14,350.00) Budgeted (469.50) Remaining 97 % Used Account: 135-47035-000-000 Plumbing Inspections 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (2,050.00) (50.00) (2,100.00) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (50.00) (2,150.00) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (50.00) (2,200.00) Drees Custom CR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (150.00) (2,200.00) ** (1,500.00) Budgeted 700.00 Remaining 147 % Used Account: 135-47045-000-000 Sewer Inspections 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (5,350.00) (150.00) (5,500.00) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (150.00) (5,650.00) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (150.00) (5,800.00) Drees Custom CR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (450.00) (5,800.00) ** (4,500.00) Budgeted 1,300.00 Remaining 129 % Used October 15, 2018 Regular Meeting Agenda Packet 84 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 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 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (76,585.60) (5,025.60) (81,611.20) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (5,025.60) (81,611.20) ** (60,000.00) Budgeted 21,611.20 Remaining 136 % Used Account: 135-49010-000-000 Interest Income 2155 09/30/2018 Bank Interest- September (50,413.16) (457.98) (50,871.14) GL 2155 09/30/2018 Bank Interest- September (7,286.80) (58,157.94) GL 2155 09/30/2018 Bank Interest- September (857.44) (59,015.38) GL 2171 09/30/2018 Recode THB CD Int from 06/18 158.92 (58,856.46) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (8,443.30) (58,856.46) ** (50,000.00) Budgeted 8,856.46 Remaining 118 % Used Account: 135-49016-000-000 Cell Tower Revenue 2158 09/28/2018 Cell Tower Rev AT&T September (10,898.63) (1,178.81) (12,077.44) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (12,077.44) ** (10,926.00) Budgeted 1,151.44 Remaining 111 % Used Account: 135-49018-000-000 Building Rent Income 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (6,416.63) (583.36) (6,999.99) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.36) (6,999.99) ** (7,000.00) Budgeted (.01) Remaining 100 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets (15,400.00) .00 (15,400.00) _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 (15,400.00) ** (15,400.00) Budgeted .00 Remaining 100 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 650 Sheldon drive (13,207.76) (343.00) (13,550.76) Ashton Wood Homes CR 2162 09/28/2018 Permits-650 Sheldon,4 Sadie C 4 Sadie Court (343.00) (13,893.76) Drees Homes CR 2180 09/30/2018 Permits 26 Katie Lane 26 Katie Lane (343.00) (14,236.76) Drees Custom CR October 15, 2018 Regular Meeting Agenda Packet 85 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (1,029.00) (14,236.76) ** (18,179.00) Budgeted (3,942.24) Remaining 78 % Used Account: 135-49141-000-000 Interfund Transfer In 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,851,769.22) 1,053,935.08 (797,834.14) GL _______________ Account: 135-49141-000-000 Interfund Transfer In Totals: 1,053,935.08 (797,834.14) ** (796,145.00) Budgeted 1,689.14 Remaining 100 % Used Account: 135-49900-000-000 Miscellaneous Income 2138 09/28/2018 Acct rfd-2850 Sherwood UB20180928-20180928 User: (59,466.32) 550.00 (58,916.32) UB 2146 09/30/2018 UB 09/2018 Billing UB20180930-20180930 User: (130.72) (59,047.04) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: 419.28 (59,047.04) ** (15,000.00) Budgeted 44,047.04 Remaining 394 % Used Account: 135-49901-000-000 Records Management Revenue (2.00) .00 (2.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (2.00) ** (20.00) Budgeted (18.00) Remaining 10 % 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: ----------------------------------- (10,256,536.01) ** 271,512.58 Monthly Total (11,100,574.00) Budgeted (844,037.99) Remaining 92 % Used October 15, 2018 Regular Meeting Agenda Packet 86 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 208,188.25 10,140.46 218,328.71 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 15,955.26 234,283.97 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 26,095.72 234,283.97 ** 274,279.00 Budgeted 39,995.03 Remaining 85 % Used Account: 135-50010-010-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 12,941.85 872.68 13,814.53 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 318.48 14,133.01 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,191.16 14,133.01 ** 20,000.00 Budgeted 5,866.99 Remaining 71 % 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 2089 09/21/2018 MUD Payroll 09/21/2018 Certification 2,225.00 200.00 2,425.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 2,425.00 ** 3,300.00 Budgeted 875.00 Remaining 73 % Used Account: 135-50020-010-000 Retirement 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 22,376.48 1,018.71 23,395.19 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,523.83 24,919.02 PR _______________ Account: 135-50020-010-000 Retirement Totals: 2,542.54 24,919.02 ** 27,843.00 Budgeted 2,923.98 Remaining 89 % Used Account: 135-50026-010-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 29,866.96 1,474.40 31,341.36 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 1,474.40 32,815.76 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 32,815.76 ** 52,196.00 Budgeted 19,380.24 Remaining 63 % Used October 15, 2018 Regular Meeting Agenda Packet 87 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-010-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 2,375.64 106.85 2,482.49 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 106.80 2,589.29 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 2,589.29 ** 5,182.00 Budgeted 2,592.71 Remaining 50 % Used Account: 135-50028-010-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 423.91 17.98 441.89 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 17.94 459.83 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 459.83 ** 994.00 Budgeted 534.17 Remaining 46 % Used Account: 135-50029-010-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 2,339.54 110.60 2,450.14 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 87.01 2,537.15 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 18.00 2,555.15 BenefitMall 4558 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 2,555.15 ** 2,982.00 Budgeted 426.85 Remaining 86 % Used Account: 135-50030-010-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 13,953.81 675.78 14,629.59 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,009.32 15,638.91 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,685.10 15,638.91 ** 18,662.00 Budgeted 3,023.09 Remaining 84 % Used Account: 135-50035-010-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 3,263.39 158.04 3,421.43 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 236.06 3,657.49 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 394.10 3,657.49 ** 4,365.00 Budgeted 707.51 Remaining 84 % Used Account: 135-50040-010-000 Unemployment Taxes 818.68 .00 818.68 October 15, 2018 Regular Meeting Agenda Packet 88 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 818.68 ** 1,080.00 Budgeted 261.32 Remaining 76 % Used Account: 135-50045-010-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 9,899.12 899.88 10,799.00 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 899.88 10,799.00 ** 11,854.00 Budgeted 1,055.00 Remaining 91 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 285.05 .00 285.05 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 285.05 ** 200.00 Budgeted (85.05) Remaining 143 % Used Account: 135-50070-010-000 Employee Relations 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 39.29 (1.19) 38.10 TOM THUMB #1789 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 119.49 157.59 TOM THUMB #1789 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DOLLARTREE 6.50 164.09 DOLLARTREE PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 14.04 178.13 WM SUPERCENTER #5247 PC _______________ Account: 135-50070-010-000 Employee Relations Totals: 138.84 178.13 ** 300.00 Budgeted 121.87 Remaining 59 % Used Account: 135-55080-010-000 Maintenance & Repairs 2116 09/24/2018 September A/P 15A chlorine nozzle 99,788.97 475.25 100,264.22 SCOOP 4586 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 19.12 100,283.34 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.28 100,291.62 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 25.59 100,317.21 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 4.29 100,321.50 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 199.99 100,521.49 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE AUTO SUPPLY LT 18.36 100,539.85 ROANOKE AUTO SUPPLY LT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 (93.01) 100,446.84 FERGUSON ENT 1241 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.32 100,455.16 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TEX-TURF 185.60 100,640.76 TEX-TURF PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 6.96 100,647.72 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT1MV3TD2 30.44 100,678.16 AMAZON.COM*MT1MV3TD2 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #3625 7.47 100,685.63 TOM THUMB #3625 PC October 15, 2018 Regular Meeting Agenda Packet 89 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 HOMEDEPOT.COM 99,788.97 26.24 100,711.87 HOMEDEPOT.COM PC 2152 09/30/2018 September A/P 2" ball valves 188.88 100,900.75 Core & Main LP 4631 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,111.78 100,900.75 ** 100,000.00 Budgeted (900.75) Remaining 101 % 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 2160 09/30/2018 September A/P Battery, washer fluid 5,068.27 147.97 5,216.24 NAPA AUTO PARTS 4643 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 147.97 5,216.24 ** 4,000.00 Budgeted (1,216.24) Remaining 130 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 35.00 .00 35.00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 35.00 ** 3,500.00 Budgeted 3,465.00 Remaining 1 % Used Account: 135-55135-010-000 Lab Analysis 2116 09/24/2018 September A/P Water samples 6,595.16 410.00 7,005.16 TARRANT CTY PUBLIC HEALTH LAB 4588 AP 2116 09/24/2018 September A/P TCEQ sampling 207.70 7,212.86 LOWER COLORADO RIVER AUTHORITY 4580 AP 2173 09/30/2018 September A/P water samples 200.00 7,412.86 TARRANT CTY PUBLIC HEALTH LAB 4657 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 817.70 7,412.86 ** 5,500.00 Budgeted (1,912.86) Remaining 135 % Used Account: 135-60010-010-000 Communications/Mobiles 2116 09/24/2018 September A/P Cell phones 3,602.72 369.91 3,972.63 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 369.91 3,972.63 ** 4,700.00 Budgeted 727.37 Remaining 85 % Used October 15, 2018 Regular Meeting Agenda Packet 90 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-010-000 Electricity 2117 09/24/2018 September A/P Electricity 125,080.91 15,109.51 140,190.42 HUDSON ENERGY SERVICES, LLC 4573 AP _______________ Account: 135-60020-010-000 Electricity Totals: 15,109.51 140,190.42 ** 150,000.00 Budgeted 9,809.58 Remaining 93 % Used Account: 135-60066-010-000 Publications/Books/Subscripts 767.00 .00 767.00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 767.00 ** 1,000.00 Budgeted 233.00 Remaining 77 % 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 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 2,208.78 165.00 2,373.78 NCTCOG RTC TRAINING PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG RTC TRAINING 165.00 2,538.78 NCTCOG RTC TRAINING PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 PAYPAL *TEXASWATERW 350.00 2,888.78 PAYPAL *TEXASWATERW PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 680.00 2,888.78 ** 2,785.00 Budgeted (103.78) Remaining 104 % Used Account: 135-60090-010-000 Safety Program 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 October 15, 2018 Regular Meeting Agenda Packet 91 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 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 24,220.32 .00 24,220.32 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 24,220.32 ** 55,176.00 Budgeted 30,955.68 Remaining 44 % Used Account: 135-60150-010-000 Wholesale Water 2116 09/24/2018 September A/P Water 1,870,342.92 291,820.90 2,162,163.82 CITY OF FORT WORTH 4562 AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 291,820.90 2,162,163.82 ** 2,823,170.00 Budgeted 661,006.18 Remaining 77 % 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 974.70 .00 974.70 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 974.70 ** 3,000.00 Budgeted 2,025.30 Remaining 32 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 2152 09/30/2018 September A/P September mowing 10,500.00 750.00 11,250.00 WATTS ELLISON LLC 4651 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 11,250.00 ** 14,750.00 Budgeted 3,500.00 Remaining 76 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S October 15, 2018 Regular Meeting Agenda Packet 92 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 278,083.50 .00 278,083.50 _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: .00 278,083.50 ** 278,084.00 Budgeted .50 Remaining 100 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 2161 09/30/2018 Texpool Transfers September 44,913.00 4,083.00 48,996.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,083.00 48,996.00 ** 48,996.00 Budgeted .00 Remaining 100 % Used Account: 135-60334-010-000 Interfund Transfer Out 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,053,935.08 (1,053,935.08) .00 GL _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 5,019.66 .00 5,019.66 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 5,019.66 ** 2,500.00 Budgeted (2,519.66) Remaining 201 % Used Account: 135-65005-010-000 Fuel & Lube 2139 09/28/2018 September A/p Fuel 10,214.48 993.47 11,207.95 US Bank Voyager Fleet Systems 4607 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 993.47 11,207.95 ** 15,000.00 Budgeted 3,792.05 Remaining 75 % Used Account: 135-65010-010-000 Uniforms 2116 09/24/2018 September A/P uniforms 1,249.14 1,075.41 2,324.55 RON MONTGOMERY & ASSOC INC 4585 AP 2116 09/24/2018 September A/P uniforms 307.22 2,631.77 RON MONTGOMERY & ASSOC INC 4585 AP _______________ Account: 135-65010-010-000 Uniforms Totals: 1,382.63 2,631.77 ** 4,488.00 Budgeted 1,856.23 Remaining 59 % Used Account: 135-65030-010-000 Chemicals October 15, 2018 Regular Meeting Agenda Packet 93 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2116 09/24/2018 September A/P Testing supplies 17,083.91 709.84 17,793.75 HACH COMPANY 4570 AP 2116 09/24/2018 September A/P Chlorine 893.45 18,687.20 DPC INDUSTRIES, INC 4568 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,603.29 18,687.20 ** 20,000.00 Budgeted 1,312.80 Remaining 93 % 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 1,080.95 .00 1,080.95 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 1,080.95 ** 1,000.00 Budgeted (80.95) Remaining 108 % Used Account: 135-65050-010-000 Meter Expense 24,975.75 .00 24,975.75 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 24,975.75 ** 50,000.00 Budgeted 25,024.25 Remaining 50 % Used Account: 135-65053-010-000 Meter Change Out Program 82,312.50 .00 82,312.50 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 82,312.50 ** 84,000.00 Budgeted 1,687.50 Remaining 98 % Used Account: 135-69005-010-000 Capital Outlays 2116 09/24/2018 September A/P 16" water line Phase I 590,375.89 115.26 590,491.15 Halff Associates, INC 4569 AP 2116 09/24/2018 September A/P 16" waterline Phase II 21,954.38 612,445.53 Halff Associates, INC 4569 AP 2116 09/24/2018 September A/P Scada panels 24,767.50 637,213.03 DHS AUTOMATION, INC 4566 AP 2123 09/25/2018 September A/P 16" water line phase I 1,543.00 638,756.03 Star-Telegram Media 4606 AP 2123 09/25/2018 September A/P Credit for double paying invoi (1,868.44) 636,887.59 Star-Telegram Media 4606 AP 2152 09/30/2018 September A/P Capitol projects 5,250.00 642,137.59 TEAGUE, NALL & PERKINS,INC 4647 AP 2174 09/30/2018 Due To/From -Fund 520 Sept 18 (157,313.85) 484,823.74 GL October 15, 2018 Regular Meeting Agenda Packet 94 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2179 09/30/2018 September A/P 16" water line 590,375.89 26,307.82 511,131.56 Halff Associates, INC 4661 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: (79,244.33) 511,131.56 ** 1,085,012.00 Budgeted 573,880.44 Remaining 47 % Used Account: 135-69009-010-000 Short Term Debt-Interest 2,271.24 .00 2,271.24 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 2,271.24 ** 5,713.00 Budgeted 3,441.76 Remaining 40 % 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 107,864.38 .00 107,864.38 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 107,864.38 ** 110,001.00 Budgeted 2,136.62 Remaining 98 % Used October 15, 2018 Regular Meeting Agenda Packet 95 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 9/2018 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 2116 09/24/2018 September A/P water samples 1,385.08 80.00 1,465.08 TARRANT CTY PUBLIC HEALTH LAB 4588 AP 2116 09/24/2018 September A/P TCEQ samples PID 207.70 1,672.78 LOWER COLORADO RIVER AUTHORITY 4580 AP 2173 09/30/2018 September A/P Water samples-PID 80.00 1,752.78 TARRANT CTY PUBLIC HEALTH LAB 4657 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 367.70 1,752.78 ** 2,000.00 Budgeted 247.22 Remaining 88 % Used Department 10 Totals: ----------------------------------- 3,979,971.89 ** (777,380.23) Monthly Total 5,584,572.00 Budgeted 1,604,600.11 Remaining 71 % Used October 15, 2018 Regular Meeting Agenda Packet 96 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 324,553.95 12,602.79 337,156.74 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 12,602.80 349,759.54 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 25,205.59 349,759.54 ** 410,866.00 Budgeted 61,106.46 Remaining 85 % Used Account: 135-50010-020-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 30,674.32 1,521.28 32,195.60 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Overtime 1,184.79 33,380.39 PR _______________ Account: 135-50010-020-000 Overtime Totals: 2,706.07 33,380.39 ** 30,000.00 Budgeted (3,380.39) Remaining 111 % 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 2089 09/21/2018 MUD Payroll 09/21/2018 Certification 7,736.00 700.00 8,436.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 8,436.00 ** 8,400.00 Budgeted (36.00) Remaining 100 % Used Account: 135-50020-020-000 Retirement 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 35,714.27 1,306.48 37,020.75 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,340.10 38,360.85 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,646.58 38,360.85 ** 42,243.00 Budgeted 3,882.15 Remaining 91 % Used Account: 135-50026-020-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 60,065.33 2,759.36 62,824.69 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,759.33 65,584.02 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,518.69 65,584.02 ** 62,175.00 Budgeted (3,409.02) Remaining 105 % Used October 15, 2018 Regular Meeting Agenda Packet 97 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50027-020-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 4,319.85 185.96 4,505.81 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 185.93 4,691.74 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 4,691.74 ** 5,271.00 Budgeted 579.26 Remaining 89 % Used Account: 135-50028-020-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 743.96 29.46 773.42 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 29.44 802.86 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 802.86 ** 1,114.00 Budgeted 311.14 Remaining 72 % Used Account: 135-50029-020-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 3,847.68 164.36 4,012.04 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 120.84 4,132.88 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 36.00 4,168.88 BenefitMall 4558 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 321.20 4,168.88 ** 4,281.00 Budgeted 112.12 Remaining 97 % Used Account: 135-50030-020-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 21,214.71 796.78 22,011.49 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 796.46 22,807.95 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,593.24 22,807.95 ** 28,314.00 Budgeted 5,506.05 Remaining 81 % Used Account: 135-50035-020-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,961.49 186.36 5,147.85 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 186.26 5,334.11 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 372.62 5,334.11 ** 6,622.00 Budgeted 1,287.89 Remaining 81 % Used Account: 135-50040-020-000 Unemployment Taxes 1,134.00 .00 1,134.00 October 15, 2018 Regular Meeting Agenda Packet 98 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 1,134.00 ** 1,260.00 Budgeted 126.00 Remaining 90 % Used Account: 135-50045-020-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 14,828.00 1,348.00 16,176.00 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,348.00 16,176.00 ** 17,990.00 Budgeted 1,814.00 Remaining 90 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 2116 09/24/2018 September A/P employee drug screen-Frank Iso 235.00 38.00 273.00 CARENOW CORPORATE 4560 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 38.00 273.00 ** 300.00 Budgeted 27.00 Remaining 91 % Used Account: 135-50070-020-000 Employee Relations .00 .00 _______________ 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 2,145.00 .00 2,145.00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 2,145.00 ** 5,550.00 Budgeted 3,405.00 Remaining 39 % Used Account: 135-55080-020-000 Maintenance & Repairs 2034 09/07/2018 September A/P Lift station uPS 78,007.00 492.25 78,499.25 DHS AUTOMATION, INC 4534 AP 2034 09/07/2018 September A/P Lift station UPS 752.25 79,251.50 DHS AUTOMATION, INC 4534 AP 2116 09/24/2018 September A/P Bags for augers 1,200.00 80,451.50 Huber Technology Inc 4571 AP 2116 09/24/2018 September A/P LS #3 pump parts 1,330.16 81,781.66 SMITH PUMP COMPANY, INC. 4587 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (3.88) 81,777.78 TELEDYNE INSTRUMENTS I PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROANOKE WINNELSON CO 25.28 81,803.06 ROANOKE WINNELSON CO PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM 515.50 82,318.56 AMAZON.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TELEDYNE INSTRUMENTS I (27.78) 82,290.78 TELEDYNE INSTRUMENTS I PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 48.76 82,339.54 THE HOME DEPOT #6581 PC October 15, 2018 Regular Meeting Agenda Packet 99 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 78,007.00 29.99 82,369.53 TRACTOR SUPPLY COMPANY PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT 6581 99.83 82,469.36 THE HOME DEPOT 6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ROYAL BRASS AND HOSE 36.62 82,505.98 ROYAL BRASS AND HOSE PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 8.70 82,514.68 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 23.61 82,538.29 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 THE HOME DEPOT #6581 17.40 82,555.69 THE HOME DEPOT #6581 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 35.79 82,591.48 TRACTOR SUPPLY COMPANY PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 FERGUSON ENT 1241 163.02 82,754.50 FERGUSON ENT 1241 PC _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 4,747.50 82,754.50 ** 86,100.00 Budgeted 3,345.50 Remaining 96 % 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 2152 09/30/2018 September A/P Clamps for vac truck 9,672.01 149.70 9,821.71 CLS SEWER EQUIPMENT CO., INC 4630 AP _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 149.70 9,821.71 ** 8,000.00 Budgeted (1,821.71) Remaining 123 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 395.40 .00 395.40 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 395.40 ** 500.00 Budgeted 104.60 Remaining 79 % Used Account: 135-55125-020-000 Dumpster Services 2117 09/24/2018 September A/P Dumpster services 64,656.77 914.29 65,571.06 L.H. CHANEY MATERIALS, INC. 4578 AP 2140 09/28/2018 September A/P dumpster services 849.65 66,420.71 L.H. CHANEY MATERIALS, INC. 4599 AP 2152 09/30/2018 September A/P Dumpster service 1,595.36 68,016.07 L.H. CHANEY MATERIALS, INC. 4641 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 3,359.30 68,016.07 ** 60,000.00 Budgeted (8,016.07) Remaining 113 % Used Account: 135-55135-020-000 Lab Analysis October 15, 2018 Regular Meeting Agenda Packet 100 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2020 09/05/2018 September A/P Effluent testing 29,272.02 246.00 29,518.02 OXIDOR LABORATORIES LLC 4521 AP 2020 09/05/2018 September A/P effluent testing 176.00 29,694.02 OXIDOR LABORATORIES LLC 4521 AP 2116 09/24/2018 September A/P Lab samples 246.00 29,940.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P lab samples 176.00 30,116.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P Lab testing 176.00 30,292.02 OXIDOR LABORATORIES LLC 4584 AP 2116 09/24/2018 September A/P Lab testing 246.00 30,538.02 OXIDOR LABORATORIES LLC 4584 AP 2140 09/28/2018 September A/P lab testing 176.00 30,714.02 OXIDOR LABORATORIES LLC 4605 AP 2140 09/28/2018 September A/P Lab testing 221.00 30,935.02 OXIDOR LABORATORIES LLC 4605 AP 2140 09/28/2018 September A/P lab testing 201.00 31,136.02 OXIDOR LABORATORIES LLC 4605 AP 2160 09/30/2018 September A/P lb testing 176.00 31,312.02 OXIDOR LABORATORIES LLC 4645 AP 2160 09/30/2018 September A/P lab testing 246.00 31,558.02 OXIDOR LABORATORIES LLC 4645 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,286.00 31,558.02 ** 30,000.00 Budgeted (1,558.02) Remaining 105 % Used Account: 135-60010-020-000 Communications/Mobiles 2116 09/24/2018 September A/P Cell phones 4,462.25 381.26 4,843.51 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 381.26 4,843.51 ** 4,700.00 Budgeted (143.51) Remaining 103 % Used Account: 135-60020-020-000 Electricity 2116 09/24/2018 September A/P Electricity 7/26-8/24 147,712.80 63.88 147,776.68 TRI COUNTY ELECTRIC 4592 AP 2116 09/24/2018 September A/P Electricity 7/26-8/24 300.10 148,076.78 TRI COUNTY ELECTRIC 4592 AP 2116 09/24/2018 September A/P Electricity 7/26-8/24 27.83 148,104.61 TRI COUNTY ELECTRIC 4592 AP 2117 09/24/2018 September A/P Electricity 13,069.48 161,174.09 HUDSON ENERGY SERVICES, LLC 4573 AP 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (201.74) 160,972.35 AR 2178 09/30/2018 September A/P Electricity 8/24-9/25 168.73 161,141.08 TRI COUNTY ELECTRIC 4659 AP 2178 09/30/2018 September A/P Electricity 8/24-9/25 400.45 161,541.53 TRI COUNTY ELECTRIC 4659 AP 2178 09/30/2018 September A/P Electricity 8/24-9/25 29.14 161,570.67 TRI COUNTY ELECTRIC 4659 AP _______________ Account: 135-60020-020-000 Electricity Totals: 13,857.87 161,570.67 ** 176,709.00 Budgeted 15,138.33 Remaining 91 % Used 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 October 15, 2018 Regular Meeting Agenda Packet 101 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-020-000 Dues & Memberships 60.00 .00 60.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 60.00 ** 300.00 Budgeted 240.00 Remaining 20 % Used Account: 135-60080-020-000 Schools & Training 658.00 .00 658.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 658.00 ** 5,677.00 Budgeted 5,019.00 Remaining 12 % Used Account: 135-60090-020-000 Safety Program 351.72 .00 351.72 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 351.72 ** 550.00 Budgeted 198.28 Remaining 64 % Used Account: 135-60100-020-000 Travel & per diem 90.46 .00 90.46 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 90.46 ** 1,635.00 Budgeted 1,544.54 Remaining 6 % 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 .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 October 15, 2018 Regular Meeting Agenda Packet 102 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 30,272.52 .00 30,272.52 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 30,272.52 ** 85,000.00 Budgeted 54,727.48 Remaining 36 % Used Account: 135-60245-020-000 Miscellaneous Expenses .01 .00 .01 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .01 ** 450.00 Budgeted 449.99 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 WM SUPERCENTER #5247 41.88 26.80 68.68 WM SUPERCENTER #5247 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TRACTOR SUPPLY COMPANY 204.93 273.61 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-60280-020-000 Property Maintenance Totals: 231.73 273.61 ** 4,000.00 Budgeted 3,726.39 Remaining 7 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 2152 09/30/2018 September A/P September mowing 8,140.00 590.00 8,730.00 WATTS ELLISON LLC 4651 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 8,730.00 ** 11,600.00 Budgeted 2,870.00 Remaining 75 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 122,043.00 .00 122,043.00 _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: .00 122,043.00 ** 122,043.00 Budgeted .00 Remaining 100 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 598,738.00 .00 598,738.00 _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: .00 598,738.00 ** 598,738.00 Budgeted .00 Remaining 100 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve October 15, 2018 Regular Meeting Agenda Packet 103 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2161 09/30/2018 Texpool Transfers September 113,058.00 10,278.00 123,336.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,278.00 123,336.00 ** 123,336.00 Budgeted .00 Remaining 100 % Used Account: 135-60334-020-000 Interfund Transfer Out 2161 09/30/2018 Texpool Transfers September 644,512.45 27,213.59 671,726.04 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 27,213.59 671,726.04 ** 944,512.00 Budgeted 272,785.96 Remaining 71 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 1,762.00 .00 1,762.00 _______________ Account: 135-60360-020-000 Furniture/Equipment < $5000 Totals: .00 1,762.00 ** 4,000.00 Budgeted 2,238.00 Remaining 44 % Used Account: 135-65005-020-000 Fuel & Lube 2139 09/28/2018 September A/p Fuel 8,120.86 812.01 8,932.87 US Bank Voyager Fleet Systems 4607 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 812.01 8,932.87 ** 12,500.00 Budgeted 3,567.13 Remaining 71 % Used Account: 135-65010-020-000 Uniforms 2116 09/24/2018 September A/P uniforms 1,854.57 1,075.40 2,929.97 RON MONTGOMERY & ASSOC INC 4585 AP _______________ Account: 135-65010-020-000 Uniforms Totals: 1,075.40 2,929.97 ** 4,459.00 Budgeted 1,529.03 Remaining 66 % Used Account: 135-65030-020-000 Chemicals 2116 09/24/2018 September A/P CIP solution 14,757.73 536.00 15,293.73 Valley Solvent Company, INC 4594 AP 2117 09/24/2018 September A/P Collection chemicals 3,379.50 18,673.23 MICKEY D CARSON DBA/NUSCO 4582 AP 2140 09/28/2018 September A/P CIP solution 1,042.36 19,715.59 Valley Solvent Company, INC 4608 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 4,957.86 19,715.59 ** 27,500.00 Budgeted 7,784.41 Remaining 72 % Used Account: 135-65035-020-000 Small Tools October 15, 2018 Regular Meeting Agenda Packet 104 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,436.14 .00 1,436.14 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 1,436.14 ** 1,000.00 Budgeted (436.14) Remaining 144 % Used Account: 135-65040-020-000 Safety Equipment 1,157.50 .00 1,157.50 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 1,157.50 ** 750.00 Budgeted (407.50) Remaining 154 % Used Account: 135-65045-020-000 Lab Supplies 2116 09/24/2018 September A/P Lab supplies 18,875.07 352.74 19,227.81 HACH COMPANY 4570 AP 2116 09/24/2018 September A/P Sampling supplies 1,318.20 20,546.01 IDEXX DISTRIBUTION, INC 4574 AP 2116 09/24/2018 September A/P sampling supplies 197.77 20,743.78 IDEXX DISTRIBUTION, INC 4574 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #1789 3.96 20,747.74 TOM THUMB #1789 PC _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,872.67 20,747.74 ** 14,000.00 Budgeted (6,747.74) Remaining 148 % Used Account: 135-69005-020-000 Capital Outlays 2140 09/28/2018 September A/P Legal WWTP 108,644.29 85.00 108,729.29 Dubois Bryant Campbell LLP 4598 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 85.00 108,729.29 ** 547,327.00 Budgeted 438,597.71 Remaining 20 % Used Account: 135-69009-020-000 Short Term Debt-Interest 3,010.73 .00 3,010.73 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 3,010.73 ** 7,573.00 Budgeted 4,562.27 Remaining 40 % 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 October 15, 2018 Regular Meeting Agenda Packet 105 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department 20 Totals: ----------------------------------- 2,674,159.19 ** 112,778.67 Monthly Total 3,569,310.00 Budgeted 895,150.81 Remaining 75 % Used October 15, 2018 Regular Meeting Agenda Packet 106 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2018 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 243 09/01/2018 Insurance/Wrk Comp Exp Sep 26.62 2.38 29.00 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.38 29.00 ** 30.00 Budgeted 1.00 Remaining 97 % 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 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 TOM THUMB #2580 103.26 31.74 135.00 TOM THUMB #2580 PC _______________ Account: 135-60075-026-000 Meetings Totals: 31.74 135.00 ** 1,200.00 Budgeted 1,065.00 Remaining 11 % Used Account: 135-60080-026-000 Schools & Training 2,755.00 .00 2,755.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 2,755.00 ** 4,000.00 Budgeted 1,245.00 Remaining 69 % Used Account: 135-60100-026-000 Travel & per diem 4,768.22 .00 4,768.22 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 4,768.22 ** 5,000.00 Budgeted 231.78 Remaining 95 % Used Account: 135-60245-026-000 Miscellaneous Expenses October 15, 2018 Regular Meeting Agenda Packet 107 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,473.98 .00 1,473.98 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 1,473.98 ** 2,000.00 Budgeted 526.02 Remaining 74 % Used Department 26 Totals: ----------------------------------- 9,811.20 ** 34.12 Monthly Total 12,980.00 Budgeted 3,168.80 Remaining 76 % Used October 15, 2018 Regular Meeting Agenda Packet 108 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 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 2004 09/07/2018 MUD Payroll 09/07/2018 Salaries & Wages 337,201.47 13,385.75 350,587.22 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Salaries & Wages 18,399.99 368,987.21 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 31,785.74 368,987.21 ** 432,863.00 Budgeted 63,875.79 Remaining 85 % Used Account: 135-50010-030-000 Overtime 2004 09/07/2018 MUD Payroll 09/07/2018 Overtime 563.05 2.95 566.00 PR _______________ Account: 135-50010-030-000 Overtime Totals: 2.95 566.00 ** 2,000.00 Budgeted 1,434.00 Remaining 28 % 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 2004 09/07/2018 MUD Payroll 09/07/2018 Retirement 33,878.31 1,238.44 35,116.75 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Retirement 1,702.00 36,818.75 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,940.44 36,818.75 ** 40,553.00 Budgeted 3,734.25 Remaining 91 % Used Account: 135-50026-030-000 Medical Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Medical Insurance 43,345.59 2,072.63 45,418.22 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medical Insurance 2,072.61 47,490.83 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 47,490.83 ** 63,485.00 Budgeted 15,994.17 Remaining 75 % Used Account: 135-50027-030-000 Dental Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Dental Insurance 3,017.37 129.78 3,147.15 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Dental Insurance 129.74 3,276.89 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 3,276.89 ** 5,502.00 Budgeted 2,225.11 Remaining 60 % Used October 15, 2018 Regular Meeting Agenda Packet 109 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50028-030-000 Vision Insurance 2004 09/07/2018 MUD Payroll 09/07/2018 Vision Insurance 547.37 21.28 568.65 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Vision Insurance 21.23 589.88 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 589.88 ** 1,173.00 Budgeted 583.12 Remaining 50 % Used Account: 135-50029-030-000 Life Insurance & Other 1930 09/01/2018 September A/P Employee benfits 3,434.06 145.04 3,579.10 Humana Inc 4481 AP 1981 09/01/2018 September A/P Employee benefits-September 119.45 3,698.55 METLIFE GROUP BENEFITS 4505 AP 2116 09/24/2018 September A/P Café 125 18.00 3,716.55 BenefitMall 4558 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 282.49 3,716.55 ** 5,059.00 Budgeted 1,342.45 Remaining 73 % Used Account: 135-50030-030-000 Social Security Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Social Security Taxes 20,309.18 792.05 21,101.23 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Social Security Taxes 1,100.17 22,201.40 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 1,892.22 22,201.40 ** 27,181.00 Budgeted 4,979.60 Remaining 82 % Used Account: 135-50035-030-000 Medicare Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Medicare Taxes 4,749.72 185.25 4,934.97 PR 2089 09/21/2018 MUD Payroll 09/21/2018 Medicare Taxes 257.28 5,192.25 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 442.53 5,192.25 ** 6,357.00 Budgeted 1,164.75 Remaining 82 % Used Account: 135-50040-030-000 Unemployment Taxes 2004 09/07/2018 MUD Payroll 09/07/2018 Unemployment Taxes 1,139.54 6.23 1,145.77 PR _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 6.23 1,145.77 ** 1,260.00 Budgeted 114.23 Remaining 91 % Used Account: 135-50045-030-000 Workman's Compensation 243 09/01/2018 Insurance/Wrk Comp Exp Sep 1,358.50 123.50 1,482.00 GL October 15, 2018 Regular Meeting Agenda Packet 110 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 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-030-000 Workman's Compensation Totals: 123.50 1,482.00 ** 1,529.00 Budgeted 47.00 Remaining 97 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 211.90 .00 211.90 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 211.90 ** 500.00 Budgeted 288.10 Remaining 42 % Used Account: 135-50070-030-000 Employee Relations 3,273.18 .00 3,273.18 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 3,273.18 ** 4,960.00 Budgeted 1,686.82 Remaining 66 % Used Account: 135-55030-030-000 Software & Support 2116 09/24/2018 September A/P Internet-Sept 66,078.36 903.72 66,982.08 Charter Communications 4561 AP 2116 09/24/2018 September A/P Microsoft exchange 456.00 67,438.08 M3 Networks 4581 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 DNH*GODADDY.COM 149.98 67,588.06 DNH*GODADDY.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 124.34 67,712.40 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 107.79 67,820.19 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 85.71 67,905.90 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 69.12 67,975.02 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ADOBE SYSTEMS INC 32.45 68,007.47 ADOBE SYSTEMS INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 1,929.11 68,007.47 ** 78,391.00 Budgeted 10,383.53 Remaining 87 % Used Account: 135-55070-030-000 Independent Labor 2140 09/28/2018 September A/P Video MUD meeting 139,518.80 577.50 140,096.30 MIGUEL CRUZ 4602 AP 2152 09/30/2018 September A/P GM September 13,530.80 153,627.10 Carman Consulting LLC. 4628 AP 2160 09/30/2018 September A/P taxes consulting 42.00 153,669.10 DRG ENTERPRISES 4634 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 14,150.30 153,669.10 ** 154,000.00 Budgeted 330.90 Remaining 100 % Used Account: 135-55080-030-000 Maintenance & Repairs October 15, 2018 Regular Meeting Agenda Packet 111 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2034 09/07/2018 September A/P rug cleaning reimbursement 5,400.48 166.29 5,566.77 TOWN OF TROPHY CLUB 4552 AP 2116 09/24/2018 September A/P Storage room building upgrade 4,716.84 10,283.61 3RD EYE SURVEILLANCE SYSTEMS 4555 AP 2116 09/24/2018 September A/P A/C admin 300.00 10,583.61 BRANDON R REED 4559 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 5,183.13 10,583.61 ** 14,000.00 Budgeted 3,416.39 Remaining 76 % Used Account: 135-55085-030-000 Generator Maint. and Repair 4,624.58 .00 4,624.58 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 4,624.58 ** 10,000.00 Budgeted 5,375.42 Remaining 46 % Used Account: 135-55120-030-000 Cleaning Services 2139 09/28/2018 September A/p Janitorial service 8,307.69 869.06 9,176.75 MEMBER'S BUILDING MAINTENANCE 4600 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 9,176.75 ** 10,000.00 Budgeted 823.25 Remaining 92 % Used Account: 135-55160-030-000 Professional Outside Services 2116 09/24/2018 September A/P FY 19 Rate consulting 59,240.00 3,060.00 62,300.00 NEW GEN STRATEGIES & SOLUTIONS 4583 AP _______________ Account: 135-55160-030-000 Professional Outside Services Totals: 3,060.00 62,300.00 ** 63,325.00 Budgeted 1,025.00 Remaining 98 % 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 2116 09/24/2018 September A/P August billings 5,891.80 585.74 6,477.54 DATAPROSE LLC 4565 AP 2160 09/30/2018 September A/P Water billings 585.00 7,062.54 DATAPROSE LLC 4633 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 1,170.74 7,062.54 ** 9,000.00 Budgeted 1,937.46 Remaining 78 % Used October 15, 2018 Regular Meeting Agenda Packet 112 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 2034 09/07/2018 September A/P Answering service-sept 15,229.11 195.12 15,424.23 KEYSTONE PARK SECRETARIAL 4541 AP 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 858.55 16,282.78 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 449.92 16,732.70 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BILL PAYMENT 190.36 16,923.06 ATT*BILL PAYMENT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RINGCENTRAL, INC 13.95 16,937.01 RINGCENTRAL, INC PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 GOVERNMENT FINANCE OFF 170.00 17,107.01 GOVERNMENT FINANCE OFF PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 ATT*BUS PHONE PMT 460.33 17,567.34 ATT*BUS PHONE PMT PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AT&T *PAYMENT 858.55 18,425.89 AT&T *PAYMENT PC 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (180.00) 18,245.89 AR _______________ Account: 135-60005-030-000 Telephone Totals: 3,016.78 18,245.89 ** 17,300.00 Budgeted (945.89) Remaining 105 % Used Account: 135-60010-030-000 Communications/Mobiles 2089 09/21/2018 MUD Payroll 09/21/2018 Communications/Mobiles 2,748.83 150.00 2,898.83 PR 2116 09/24/2018 September A/P Cell phones 87.33 2,986.16 VERIZON WIRELESS 4595 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.33 2,986.16 ** 4,000.00 Budgeted 1,013.84 Remaining 75 % Used Account: 135-60020-030-000 Electricity/Gas 2152 09/30/2018 September A/P Electricity admin 7/11-8/10 5,988.92 602.05 6,590.97 TOWN OF TROPHY CLUB 4649 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 602.05 6,590.97 ** 16,261.00 Budgeted 9,670.03 Remaining 41 % Used Account: 135-60025-030-000 Water 2152 09/30/2018 September A/P Water-September 660.51 116.64 777.15 TROPHY CLUB MUD (WATER BILLS) 4650 AP 2167 09/30/2018 Town Billed Invoices 1656-1659 AR 20180930-20180930 User: (58.32) 718.83 AR _______________ Account: 135-60025-030-000 Water Totals: 58.32 718.83 ** 2,500.00 Budgeted 1,781.17 Remaining 29 % Used Account: 135-60035-030-000 Postage 2116 09/24/2018 September A/P August billings 17,849.47 1,621.31 19,470.78 DATAPROSE LLC 4565 AP 2152 09/30/2018 September A/P Overnight- AT& T 5.50 19,476.28 FEDERAL EXPRESS CORP 4635 AP 2152 09/30/2018 September A/P Overnight-Denotn county tax 11.00 19,487.28 FEDERAL EXPRESS CORP 4635 AP 2160 09/30/2018 September A/P Water billings 1,632.77 21,120.05 DATAPROSE LLC 4633 AP October 15, 2018 Regular Meeting Agenda Packet 113 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60035-030-000 Postage Totals: 3,270.58 21,120.05 ** 30,000.00 Budgeted 8,879.95 Remaining 70 % Used Account: 135-60040-030-000 Service Charges & Fees 2006 09/07/2018 Child Support Fee 55,665.70 1.50 55,667.20 GL 2091 09/21/2018 Child Support Fee 1.50 55,668.70 GL 2152 09/30/2018 September A/P direct send fees 50.00 55,718.70 Fiserv Solutions, LLC 4636 AP 2156 09/30/2018 Pace Credit Card Fees 6,271.28 61,989.98 GL 2156 09/30/2018 Pace Credit Card Fees 128.40 62,118.38 GL 2160 09/30/2018 September A/P safety deposit box opening 187.23 62,305.61 Bank of the West 4627 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,639.91 62,305.61 ** 55,560.00 Budgeted (6,745.61) Remaining 112 % 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 243 09/01/2018 Insurance/Wrk Comp Exp Sep 70,898.96 6,100.33 76,999.29 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,100.33 76,999.29 ** 56,000.00 Budgeted (20,999.29) Remaining 137 % Used Account: 135-60066-030-000 Publications/Books/Subscripts 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 NCTCOG AGENCY SRVCS 206.38 153.40 359.78 NCTCOG AGENCY SRVCS PC _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 153.40 359.78 ** 1,600.00 Budgeted 1,240.22 Remaining 22 % Used Account: 135-60070-030-000 Dues & Memberships 3,988.42 .00 3,988.42 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,988.42 ** 6,000.00 Budgeted 2,011.58 Remaining 66 % Used October 15, 2018 Regular Meeting Agenda Packet 114 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 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 133.56 .00 133.56 _______________ Account: 135-60075-030-000 Meetings Totals: .00 133.56 ** 400.00 Budgeted 266.44 Remaining 33 % 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 3,238.00 .00 3,238.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 3,238.00 ** 7,600.00 Budgeted 4,362.00 Remaining 43 % Used Account: 135-60100-030-000 Travel & per diem 2139 09/28/2018 September A/p Tolls 1,671.32 5.78 1,677.10 NTTA 4603 AP _______________ Account: 135-60100-030-000 Travel & per diem Totals: 5.78 1,677.10 ** 4,885.00 Budgeted 3,207.90 Remaining 34 % 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 220.00 .00 220.00 _______________ Account: 135-60115-030-000 Elections Totals: .00 220.00 ** 4,500.00 Budgeted 4,280.00 Remaining 5 % Used Account: 135-60125-030-000 Advertising October 15, 2018 Regular Meeting Agenda Packet 115 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2123 09/25/2018 September A/P Public hearing tax notice 300.00 625.00 925.00 Star-Telegram Media 4606 AP _______________ Account: 135-60125-030-000 Advertising Totals: 625.00 925.00 ** 2,500.00 Budgeted 1,575.00 Remaining 37 % Used Account: 135-60235-030-000 Security 2116 09/24/2018 September A/P Monitoring service 418.00 24.00 442.00 Digital Air Control, Inc 4567 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 442.00 ** 2,700.00 Budgeted 2,258.00 Remaining 16 % Used Account: 135-60245-030-000 Miscellaneous Expenses 124.50 .00 124.50 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 124.50 ** 500.00 Budgeted 375.50 Remaining 25 % Used Account: 135-60246-030-000 General Manager Contingency 17,000.00 .00 17,000.00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 17,000.00 ** 17,000.00 Budgeted .00 Remaining 100 % 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 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 273.73 169.99 443.72 RED WING SHOES #652 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 RED WING SHOES #652 303.73 747.45 RED WING SHOES #652 PC _______________ Account: 135-65010-030-000 Uniforms Totals: 473.72 747.45 ** 700.00 Budgeted (47.45) Remaining 107 % Used Account: 135-65055-030-000 Hardware October 15, 2018 Regular Meeting Agenda Packet 116 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2116 09/24/2018 September A/P Computer replacement-Bert, rec 2,006.68 4,795.74 6,802.42 M3 Networks 4581 AP _______________ Account: 135-65055-030-000 Hardware Totals: 4,795.74 6,802.42 ** 7,420.00 Budgeted 617.58 Remaining 92 % Used Account: 135-65085-030-000 Office Supplies 2139 09/28/2018 September A/p Office supplies 4,248.67 106.65 4,355.32 OFFICE DEPOT, INC 4604 AP 2139 09/28/2018 September A/p Office supplies' 49.39 4,404.71 OFFICE DEPOT, INC 4604 AP 2139 09/28/2018 September A/p Office supplies 79.98 4,484.69 OFFICE DEPOT, INC 4604 AP 2160 09/30/2018 September A/P Tags for portable meters 20.95 4,505.64 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P wall calendars, foot rest, key 643.16 5,148.80 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P drafting stool-Timi 118.76 5,267.56 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P File rail kit 49.98 5,317.54 OFFICE DEPOT, INC 4644 AP 2160 09/30/2018 September A/P office supplies 13.49 5,331.03 OFFICE DEPOT, INC 4644 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 1,082.36 5,331.03 ** 7,000.00 Budgeted 1,668.97 Remaining 76 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 2,365.05 .00 2,365.05 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 2,365.05 ** 2,000.00 Budgeted (365.05) Remaining 118 % Used Account: 135-65095-030-000 Maintenance Supplies 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB #4795 3,796.71 6.08 3,802.79 SAMSCLUB #4795 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 42.67 3,845.46 SAMSCLUB.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 SAMSCLUB.COM 254.77 4,100.23 SAMSCLUB.COM PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMAZON.COM*MT5214OE1 43.70 4,143.93 AMAZON.COM*MT5214OE1 PC 2163 09/26/2018 Pcard 08/28/18 - 09/26/18 AMZN MKTP US*MT6KC44C2 54.69 4,198.62 AMZN MKTP US*MT6KC44C2 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 401.91 4,198.62 ** 4,000.00 Budgeted (198.62) Remaining 105 % 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 October 15, 2018 Regular Meeting Agenda Packet 117 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69005-030-000 Capital Outlays 48,354.99 .00 48,354.99 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 48,354.99 ** 13,000.00 Budgeted (35,354.99) Remaining 372 % Used Account: 135-69170-030-000 Copier Lease Installments 2116 09/24/2018 September A/P Copier lease 2,562.31 388.00 2,950.31 TIAA COMMERCIAL FINANCE 4590 AP 2116 09/24/2018 September A/P Copier lease 86.74 3,037.05 KYOCERA DOCUMENT SOLUTIONS 4577 AP 2152 09/30/2018 September A/P Copier lease 194.00 3,231.05 TIAA COMMERCIAL FINANCE 4648 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 668.74 3,231.05 ** 4,600.00 Budgeted 1,368.95 Remaining 70 % Used Department 30 Totals: ----------------------------------- 1,102,385.92 ** 96,441.66 Monthly Total 1,217,112.00 Budgeted 114,726.08 Remaining 91 % Used October 15, 2018 Regular Meeting Agenda Packet 118 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 9/2018 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 2123 09/25/2018 September A/P Southlake easement legal 122,361.90 22,432.31 144,794.21 WHITAKER CHALK SWINDLE 4609 AP 2173 09/30/2018 September A/P Legal 2,610.00 147,404.21 McLean & Howard, L.L.P. 4655 AP 2173 09/30/2018 September A/P Legal 1,050.00 148,454.21 McLean & Howard, L.L.P. 4655 AP _______________ Account: 135-55045-039-000 Legal Totals: 26,092.31 148,454.21 ** 137,000.00 Budgeted (11,454.21) Remaining 108 % Used Account: 135-55055-039-000 Auditing 25,658.70 .00 25,658.70 _______________ Account: 135-55055-039-000 Auditing Totals: .00 25,658.70 ** 24,500.00 Budgeted (1,158.70) Remaining 105 % Used Account: 135-55060-039-000 Appraisal 2034 09/07/2018 September A/P Appraisel 4th qtr DCAD budget 8,683.92 2,011.87 10,695.79 DENTON CENTRAL APPRAISAL DISTR 4533 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 2,011.87 10,695.79 ** 11,446.00 Budgeted 750.21 Remaining 93 % Used Account: 135-55065-039-000 Tax Admin Fees 2,968.40 .00 2,968.40 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 2,968.40 ** 3,800.00 Budgeted 831.60 Remaining 78 % Used Department 39 Totals: ----------------------------------- 187,777.10 ** 28,104.18 Monthly Total 176,746.00 Budgeted (11,031.10) Remaining 106 % Used Fund 135 Totals: ----------------------------------- (2,302,430.71) (268,509.02) Monthly Total (539,854.00) Budgeted 1,762,576.71 Remaining 426 % Used October 15, 2018 Regular Meeting Agenda Packet 119 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 9/2018 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 October 15, 2018 Regular Meeting Agenda Packet 120 of 171 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET SEPTEMBER 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 785,925 TOTAL LIABILITIES 785,925 FUND BALANCE ASSIGNED FUND BALANCE 992,579 NET REVENUES / EXPENDITURES (1,778,504) TOTAL FUND BALANCE (785,925) TOTAL LIABILITIES AND FUND BALANCE - October 15, 2018 Regular Meeting Agenda Packet 121 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 9,348.16- 9,348.16 Subtotal: 9,348.16- 9,348.16 Program number: 9,348.16- 9,348.16 Department number: Revenues 9,348.16- 9,348.16 October 15, 2018 Regular Meeting Agenda Packet 122 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49141-020-000 Interfund Transfers In Gen 27,213.59- 671,726.04- 671,726.04 Subtotal: 27,213.59- 671,726.04- 671,726.04 Program number: 27,213.59- 671,726.04- 671,726.04 Department number: Wastewater 27,213.59- 671,726.04- 671,726.04 Revenues Subtotal ----------- 27,213.59- 681,074.20- 681,074.20 October 15, 2018 Regular Meeting Agenda Packet 123 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 22:50 10/11/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-60335-020-000 Intergov Transfer Out (GF) 154.89 154.89- Subtotal: 154.89 154.89- 517-69005-020-000 Capital Outlays 129,440.21 2,459,423.18 2,459,423.18- Subtotal: 129,440.21 2,459,423.18 2,459,423.18- Program number: 129,440.21 2,459,578.07 2,459,578.07- Department number: Wastewater 129,440.21 2,459,578.07 2,459,578.07- Expenditures Subtotal ----------- 129,440.21 2,459,578.07 2,459,578.07- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 102,226.62 1,778,503.87 1,778,503.87- October 15, 2018 Regular Meeting Agenda Packet 124 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 9/2018 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 (9,348.16) .00 (9,348.16) _______________ Account: 517-49010-000-000 Interest Income Totals: .00 (9,348.16) ** .00 Budgeted 9,348.16 Remaining 0 % Used Department Totals: ----------------------------------- (9,348.16) ** .00 Monthly Total .00 Budgeted 9,348.16 Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 125 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 517-49141-020-000 Interfund Transfers In Gen 2161 09/30/2018 Texpool Transfers September (644,512.45) (27,213.59) (671,726.04) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (27,213.59) (671,726.04) ** .00 Budgeted 671,726.04 Remaining 0 % Used Account: 517-60335-020-000 Intergov Transfer Out (GF) 154.89 .00 154.89 _______________ Account: 517-60335-020-000 Intergov Transfer Out (GF) Totals: .00 154.89 ** .00 Budgeted (154.89) Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 2116 09/24/2018 September A/P WWTP Improvement 2,329,982.97 27,213.59 2,357,196.56 CP&Y/WALLACE GROUP, INC. 4564 AP 2152 09/30/2018 September A/P WWTP Improvements 102,226.62 2,459,423.18 WEBBER-CADAGUA PARTNERS 4652 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 129,440.21 2,459,423.18 ** .00 Budgeted (2,459,423.18) Remaining 0 % Used Department 20 Totals: ----------------------------------- 1,787,852.03 ** 102,226.62 Monthly Total .00 Budgeted (1,787,852.03) Remaining 0 % Used Fund 517 Totals: ----------------------------------- 1,778,503.87 102,226.62 Monthly Total .00 Budgeted (1,778,503.87) Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 126 of 171 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET SEPTEMBER 2018 519 ASSETS REVENUE BOND CONSTRUCTION CASH IN BANK - CASH IN ESCROW 767,358 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 767,358 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 13,158 TOTAL LIABILITIES 13,158 FUND BALANCE ASSIGNED FUND BALANCE 4,225,581 NET REVENUES / EXPENDITURES (3,471,381) TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 October 15, 2018 Regular Meeting Agenda Packet 127 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 22:50 10/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 17,972.75- 19,506.92- 19,506.92 519-49141-000-000 Interfund Transfer In-Gen Fund 1,053,935.08 Subtotal: 1,035,962.33 19,506.92- 19,506.92 Program number: 1,035,962.33 19,506.92- 19,506.92 Department number: Revenues 1,035,962.33 19,506.92- 19,506.92 Revenues Subtotal ----------- 1,035,962.33 19,506.92- 19,506.92 October 15, 2018 Regular Meeting Agenda Packet 128 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 22:50 10/11/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 1,053,935.08- 797,679.25 797,679.25- Subtotal: 1,053,935.08- 797,679.25 797,679.25- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68- Program number: 1,053,935.08- 3,490,887.93 3,490,887.93- Department number: Water 1,053,935.08- 3,490,887.93 3,490,887.93- Expenditures Subtotal ----------- 1,053,935.08- 3,490,887.93 3,490,887.93- Fund number: 519 2016 Rev Bond Const-SWIFT 17,972.75- 3,471,381.01 3,471,381.01- October 15, 2018 Regular Meeting Agenda Packet 129 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-49010-000-000 Interest Income 2170 09/30/2018 Swift Bond Escrow Int 2018~ Oct 2017 Interest (1,534.17) (1,376.62) (2,910.79) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Nov 2017 Interest (1,480.54) (4,391.33) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Dec 2017 Interest (1,561.42) (5,952.75) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Jan 2018 Interest (2,095.94) (8,048.69) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Feb 2018 Interest (2,491.50) (10,540.19) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Mar 2018 Interest (2,390.02) (12,930.21) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Apr 2018 Interest (2,287.26) (15,217.47) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ May 2018 Interest (1,127.83) (16,345.30) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ June 2018 Interest (711.39) (17,056.69) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ July 2018 Interest (757.25) (17,813.94) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Aug 2018 Interest (838.05) (18,651.99) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Sept 2018 Interest (854.57) (19,506.56) GL 2170 09/30/2018 Swift Bond Escrow Int 2018~ Realized Gain 2018 (.36) (19,506.92) GL _______________ Account: 519-49010-000-000 Interest Income Totals: (17,972.75) (19,506.92) ** .00 Budgeted 19,506.92 Remaining 0 % Used Account: 519-49141-000-000 Interfund Transfer In-Gen Fund 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 (1,053,935.08) 1,053,935.08 .00 GL _______________ Account: 519-49141-000-000 Interfund Transfer In-Gen Fund Totals: 1,053,935.08 .00 ** .00 Budgeted .00 Remaining 0 % Used Department Totals: ----------------------------------- (19,506.92) ** 1,035,962.33 Monthly Total .00 Budgeted 19,506.92 Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 130 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 519-60334-010-000 Interfund Transfer Out 2065 09/30/2018 Correct Intrfd Trnsfr 519/135 1,851,614.33 (1,053,935.08) 797,679.25 GL _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: (1,053,935.08) 797,679.25 ** .00 Budgeted (797,679.25) Remaining 0 % Used Account: 519-69005-010-000 Capital Outlays 2,693,208.68 .00 2,693,208.68 _______________ Account: 519-69005-010-000 Capital Outlays Totals: .00 2,693,208.68 ** .00 Budgeted (2,693,208.68) Remaining 0 % Used Department 10 Totals: ----------------------------------- 3,490,887.93 ** (1,053,935.08) Monthly Total .00 Budgeted (3,490,887.93) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,471,381.01 (17,972.75) Monthly Total .00 Budgeted (3,471,381.01) Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 131 of 171 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET SEPTEMBER 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 370,772 TOTAL LIABILITIES 370,772 FUND BALANCE ASSIGNED FUND BALANCE (39,899) NET REVENUES / EXPENDITURES (330,873) TOTAL FUND BALANCE (370,772) TOTAL LIABILITIES AND FUND BALANCE - October 15, 2018 Regular Meeting Agenda Packet 132 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 22:50 10/11/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 157,313.85 330,872.79 330,872.79- Subtotal: 157,313.85 330,872.79 330,872.79- Program number: 157,313.85 330,872.79 330,872.79- Department number: Water Department 157,313.85 330,872.79 330,872.79- Expenditures Subtotal ----------- 157,313.85 330,872.79 330,872.79- Fund number: 520 Revenue Bond 16" Waterline 157,313.85 330,872.79 330,872.79- October 15, 2018 Regular Meeting Agenda Packet 133 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 520-69005-010-000 Capital Outlays 2174 09/30/2018 Due To/From -Fund 520 Sept 18 173,558.94 157,313.85 330,872.79 GL _______________ Account: 520-69005-010-000 Capital Outlays Totals: 157,313.85 330,872.79 ** .00 Budgeted (330,872.79) Remaining 0 % Used Department 10 Totals: ----------------------------------- 330,872.79 ** 157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 330,872.79 157,313.85 Monthly Total .00 Budgeted (330,872.79) Remaining 0 % Used October 15, 2018 Regular Meeting Agenda Packet 134 of 171 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 606,910 ACCOUNTS RECEIVABLE - TOTAL ASSETS 606,910 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 426,579 NET REVENUES / EXPENDITURES 180,331 TOTAL FUND BALANCE 606,910 TOTAL LIABILITIES AND FUND BALANCE 606,910 October 15, 2018 Regular Meeting Agenda Packet 135 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 22:50 10/11/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2018 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- 972.67- 7,999.41- 799.941 6,999.41 528-49142-000-000 Interfund transfer in-Water 48,996.00- 48,996.00- 4,083.00- 48,996.00- 100.000 528-49143-000-000 Interfund transfer in-WW 123,336.00- 123,336.00- 10,278.00- 123,336.00- 100.000 Subtotal: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Program number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Department number: 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Revenues Subtotal ----------- 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 Fund number: 528 2015 Revenue Bond Reserve Fund 173,332.00- 173,332.00- 15,333.67- 180,331.41- 104.038 6,999.41 October 15, 2018 Regular Meeting Agenda Packet 136 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 9/2018 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 2155 09/30/2018 Bank Interest- September (7,026.74) (972.67) (7,999.41) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (972.67) (7,999.41) ** (1,000.00) Budgeted 6,999.41 Remaining 800 % Used Account: 528-49142-000-000 Interfund transfer in-Water 2161 09/30/2018 Texpool Transfers September (44,913.00) (4,083.00) (48,996.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,083.00) (48,996.00) ** (48,996.00) Budgeted .00 Remaining 100 % Used Account: 528-49143-000-000 Interfund transfer in-WW 2161 09/30/2018 Texpool Transfers September (113,058.00) (10,278.00) (123,336.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,278.00) (123,336.00) ** (123,336.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (180,331.41) ** (15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used Fund 528 Totals: ----------------------------------- (180,331.41) (15,333.67) Monthly Total (173,332.00) Budgeted 6,999.41 Remaining 104 % Used October 15, 2018 Regular Meeting Agenda Packet 137 of 171 TROPHY CLUB MUD #1 - I&S BALANCE SHEET SEPTEMBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 48,716 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 9,502 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 62,791 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 9,502 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 9,502 FUND BALANCE ASSIGNED FUND BALANCE 32,341 NET REVENUES / EXPENDITURES 20,948 TOTAL FUND BALANCE 53,289 TOTAL LIABILITIES AND FUND BALANCE 62,791 October 15, 2018 Regular Meeting Agenda Packet 138 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 22:50 10/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2018 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- 50.23- 677,052.35- 101.104 7,392.35 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 2,624.77- 145.821 824.77 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 5.53- 2,009.74- 100.487 9.74 Subtotal: 673,460.00- 673,460.00- 55.76- 681,686.86- 101.222 8,226.86 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 80.24- 8,921.74- 446.087 6,921.74 533-49015-000-000 Lease/Rental Income 218,954.00- 218,954.00- 218,954.00- 100.000 533-49141-000-000 Interfund Trans In-PID Surchg 122,043.00- 122,043.00- 122,043.00- 100.000 Subtotal: 342,997.00- 342,997.00- 80.24- 349,918.74- 102.018 6,921.74 Program number: 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 Department number: Revenues 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 Revenues Subtotal ----------- 1,016,457.00- 1,016,457.00- 136.00- 1,031,605.60- 101.490 15,148.60 October 15, 2018 Regular Meeting Agenda Packet 139 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 22:50 10/11/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2018 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 500.00 2,150.00 100.000 533-70025-051-000 Bond Interest Expense-Tax 283,508.00 283,508.00 283,507.50 100.000 .50 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 725,000.00 725,000.00 100.000 Subtotal: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Program number: 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Department number: Administration 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Expenditures Subtotal ----------- 1,010,658.00 1,010,658.00 500.00 1,010,657.50 100.000 .50 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 364.00 20,948.10- 361.236 15,149.10 October 15, 2018 Regular Meeting Agenda Packet 140 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2018 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 2153 09/04/2018 Property Taxes (677,002.12) (34.75) (677,036.87) GL 2154 09/28/2018 Property Taxes (15.48) (677,052.35) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (50.23) (677,052.35) ** (669,660.00) Budgeted 7,392.35 Remaining 101 % Used Account: 533-40002-000-000 Property Taxes/Delinquent (2,624.77) .00 (2,624.77) _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: .00 (2,624.77) ** (1,800.00) Budgeted 824.77 Remaining 146 % Used Account: 533-40015-000-000 Property Taxes/P & I 2153 09/04/2018 Property Taxes (2,004.21) (2.43) (2,006.64) GL 2154 09/28/2018 Property Taxes (3.10) (2,009.74) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (5.53) (2,009.74) ** (2,000.00) Budgeted 9.74 Remaining 100 % Used Account: 533-49010-000-000 Interest Income 2155 09/30/2018 Bank Interest- September (8,841.50) (80.24) (8,921.74) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (80.24) (8,921.74) ** (2,000.00) Budgeted 6,921.74 Remaining 446 % Used Account: 533-49015-000-000 Lease/Rental Income (218,954.00) .00 (218,954.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (218,954.00) ** (218,954.00) Budgeted .00 Remaining 100 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg (122,043.00) .00 (122,043.00) _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: .00 (122,043.00) ** (122,043.00) Budgeted .00 Remaining 100 % Used October 15, 2018 Regular Meeting Agenda Packet 141 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 9/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ----------------------------------- (1,031,605.60) ** (136.00) Monthly Total (1,016,457.00) Budgeted 15,148.60 Remaining 101 % Used October 15, 2018 Regular Meeting Agenda Packet 142 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 9/2018 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 2097 09/21/2018 TCMUD1-13 Paying Agent Fee 1,650.00 500.00 2,150.00 GL _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: 500.00 2,150.00 ** 2,150.00 Budgeted .00 Remaining 100 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax 283,507.50 .00 283,507.50 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 283,507.50 ** 283,508.00 Budgeted .50 Remaining 100 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax 725,000.00 .00 725,000.00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 725,000.00 ** 725,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 1,010,657.50 ** 500.00 Monthly Total 1,010,658.00 Budgeted .50 Remaining 100 % Used Fund 533 Totals: ----------------------------------- (20,948.10) 364.00 Monthly Total (5,799.00) Budgeted 15,149.10 Remaining 361 % Used October 15, 2018 Regular Meeting Agenda Packet 143 of 171 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 19,562 ACCOUNTS RECEIVABLE - TOTAL ASSETS 19,562 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 16,211 NET REVENUES / EXPENDITURES 3,351 TOTAL FUND BALANCE 19,562 TOTAL LIABILITIES AND FUND BALANCE 19,562 October 15, 2018 Regular Meeting Agenda Packet 144 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 22:50 10/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2018 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- 32.05- 3,350.84- 335.084 2,350.84 534-49143-000-000 Interfund Transfer In-WW Sales 598,738.00- 598,738.00- 598,738.00- 100.000 Subtotal: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Program number: 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Department number: Revenues 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 Revenues Subtotal ----------- 599,738.00- 599,738.00- 32.05- 602,088.84- 100.392 2,350.84 October 15, 2018 Regular Meeting Agenda Packet 145 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 22:50 10/11/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2018 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 100.000 534-70040-051-000 Revenue Bond Interest Expense 223,338.00 223,338.00 223,337.50 100.000 .50 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 375,000.00 375,000.00 100.000 Subtotal: 598,738.00 598,738.00 598,737.50 100.000 .50 Program number: 598,738.00 598,738.00 598,737.50 100.000 .50 Department number: Administration 598,738.00 598,738.00 598,737.50 100.000 .50 Expenditures Subtotal ----------- 598,738.00 598,738.00 598,737.50 100.000 .50 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 32.05- 3,351.34- 335.134 2,351.34 October 15, 2018 Regular Meeting Agenda Packet 146 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 9/2018 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 2155 09/30/2018 Bank Interest- September (3,318.79) (32.05) (3,350.84) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (32.05) (3,350.84) ** (1,000.00) Budgeted 2,350.84 Remaining 335 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales (598,738.00) .00 (598,738.00) _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: .00 (598,738.00) ** (598,738.00) Budgeted .00 Remaining 100 % Used Department Totals: ----------------------------------- (602,088.84) ** (32.05) Monthly Total (599,738.00) Budgeted 2,350.84 Remaining 100 % Used October 15, 2018 Regular Meeting Agenda Packet 147 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 9/2018 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 400.00 .00 400.00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense 223,337.50 .00 223,337.50 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 223,337.50 ** 223,338.00 Budgeted .50 Remaining 100 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense 375,000.00 .00 375,000.00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 375,000.00 ** 375,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 598,737.50 ** .00 Monthly Total 598,738.00 Budgeted .50 Remaining 100 % Used Fund 534 Totals: ----------------------------------- (3,351.34) (32.05) Monthly Total (1,000.00) Budgeted 2,351.34 Remaining 335 % Used October 15, 2018 Regular Meeting Agenda Packet 148 of 171 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 2,584 ACCOUNTS RECEIVABLE - TOTAL ASSETS 2,584 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 952 NET REVENUES / EXPENDITURES 1,632 TOTAL FUND BALANCE 2,584 TOTAL LIABILITIES AND FUND BALANCE 2,584 October 15, 2018 Regular Meeting Agenda Packet 149 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 22:50 10/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/2018 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- 4.24- 1,632.02- 272.003 1,032.02 535-49142-000-000 Interfund Tran In-Water Sales 278,084.00- 278,084.00- 278,083.50- 100.000 .50- Subtotal: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Program number: 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Department number: Revenues 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 Revenues Subtotal ----------- 278,684.00- 278,684.00- 4.24- 279,715.52- 100.370 1,031.52 October 15, 2018 Regular Meeting Agenda Packet 150 of 171 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 22:50 10/11/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/2018 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 100.000 535-70040-051-000 Revenue Bond Interest Expense 62,684.00 62,684.00 62,683.50 99.999 .50 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 100.000 Subtotal: 278,084.00 278,084.00 278,083.50 100.000 .50 Program number: 278,084.00 278,084.00 278,083.50 100.000 .50 Department number: Administration 278,084.00 278,084.00 278,083.50 100.000 .50 Expenditures Subtotal ----------- 278,084.00 278,084.00 278,083.50 100.000 .50 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 4.24- 1,632.02- 272.003 1,032.02 ******* End of Report ********* October 15, 2018 Regular Meeting Agenda Packet 151 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 9/2018 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 2155 09/30/2018 Bank Interest- September (1,627.78) (4.24) (1,632.02) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (4.24) (1,632.02) ** (600.00) Budgeted 1,032.02 Remaining 272 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales (278,083.50) .00 (278,083.50) _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: .00 (278,083.50) ** (278,084.00) Budgeted (.50) Remaining 100 % Used Department Totals: ----------------------------------- (279,715.52) ** (4.24) Monthly Total (278,684.00) Budgeted 1,031.52 Remaining 100 % Used October 15, 2018 Regular Meeting Agenda Packet 152 of 171 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 22:50 10/11/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 9/2018 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 400.00 .00 400.00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 400.00 ** 400.00 Budgeted .00 Remaining 100 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense 62,683.50 .00 62,683.50 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 62,683.50 ** 62,684.00 Budgeted .50 Remaining 100 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 .00 215,000.00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 215,000.00 ** 215,000.00 Budgeted .00 Remaining 100 % Used Department 51 Totals: ----------------------------------- 278,083.50 ** .00 Monthly Total 278,084.00 Budgeted .50 Remaining 100 % Used Fund 535 Totals: ----------------------------------- (1,632.02) (4.24) Monthly Total (600.00) Budgeted 1,032.02 Remaining 272 % Used Grand Totals: --------------------------------------------------------------------------------------------------------- 2,864,013.23 **** 9,977.28 Monthly Total (720,585.00) Budgeted (3,584,598.23) Remaining ########## ******* End of Report ********* October 15, 2018 Regular Meeting Agenda Packet 153 of 171 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:September 2018 REVENUE VARIANCE:100.0% EXPENSE VARIANCE:100.0% 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 79 1,066,061 101.10%10/2017 Property Taxes collected 122-40011 Property Taxes/Fire - Delinquent - 3,945 10/2017 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I 9 4,787 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 October 15, 2018 Regular Meeting Agenda Packet 154 of 171 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:September 2018 REVENUE VARIANCE:100.0% EXPENSE VARIANCE:100.0% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-47000-000 Water 6,464,019 489,453 5,953,141 92.10%01/2018 Water Sales 135-47030-000 Service Charges 14,350 1,550 13,881 96.73%01/2018 Service Charges 135-49075-000 Oversized Meter Reimbursment 18,179 1,029 14,237 78.31%06/2018 Oversize Meter Reimbursment 135-49901-000 Records Management Revenue 20 - 2 10.00%07/2018 Open Record Request EXPENSES WATER 135-55080-010 Maintenance & Repairs 100,000 1,112 100,901 100.90%09/2018 Normal Mainteance & Repairs 135-55090-010 Vehicle Maintenance 4,000 148 5,216 130.41%09/2018 NAPA Auto Parts 135-55135-010 Lab Analysis 5,500 818 7,413 134.78%06/2018 Normal Lab Testing 135-60080-010 Schools & Training 2,785 680 2,889 103.73%09/2018 Normal Training WASTEWATER 135-50010-020 Overtime 30,000 2,706 33,380 111.27%05/2018 WWTP Overtime 135-50026-020 Medical Insurance 62,175 5,519 65,584 105.48%09/2018 WWTP Medical Ins 135-55090-020 Vehicle Maintenance 8,000 150 9,822 122.77%07/2018 Blagg Tire, CLS Sewer Equipment (GAP Vax) 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 October 15, 2018 Regular Meeting Agenda Packet 155 of 171 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:September 2018 REVENUE VARIANCE:100.0% EXPENSE VARIANCE:100.0% 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-55125-020 Dumpster Services 60,000 3,359 68,016 113.36%01/2018 L.H. Chaney- Haul offs 135-55135-020 Lab Analysis 30,000 2,286 31,558 105.19%09/2018 Normal Lab Testing 135-60010-020 Communications/Mobiles 4,700 381 4,844 103.05%09/2018 WWTP Phones 135-65045-020 Lab Supplies 14,000 1,873 20,748 148.20%06/2018 Lab Supplies BOARD OF DIRECTORS ADMINISTRATION 135-60005-030 Telephone 17,300$ 3,017$ 18,246$ 105.47%09/2018 Admin Phone 135-60040-030 Service Charge & Fees 55,560$ 6,640$ 62,306$ 112.14%08/2018 Pace Credit Card Fees 135-60055-030 Insurance 56,000$ 6,100$ 76,999$ 137.50%02/2018 TML WC True-Up Adjustment FY17 135-65010-030 Uniforms 700$ 474$ 747$ 106.78%09/2018 Safety Shoes 135-65095-030 Maintenance Supplies 4,000$ 402$ 4,199$ 104.97%09/2018 Sams, Amazon Non-Departmental 135-55045-039 Legal 137,000$ 26,092$ 148,454$ 108.36%09/2018 Whitaker Chalk Swindle, McLean & Howard October 15, 2018 Regular Meeting Agenda Packet 156 of 171 Trophy Club Municipal Utility District No. 1    Date:    10/15/2018  To:    Board of Directors  From:    John Robert Carman  Subject:  General Manager’s Report    Regulatory Updates  Sanitary Sewer Overflows (SSO) – One large SSO occurred since the last Board meeting.  This  SSO happened at the wastewater treatment plant during the significant precipitation event  occurring on September 21st and 22nd near 1500 Junction Way, in Trophy Club Texas.  An  estimated 10,000 gallons spilled, and the spill was reported to TCEQ in Austin and TCEQ Region  4 in Fort Worth as required.  This sewer overflow was one of the significant effects resulting  from the intense precipitation event which saw flooding in the other low lying areas of Trophy  club.  The operators demonstrated creativity in minimizing the overflow by using Basin 4, which  is reserved for future expansion, as an equalization basin during the high flows.  This spill  required an extensive cleanup effort, primarily on the plant site but also for a small area outside  the fence line.  Here are the before and after cleanup pictures.    It is common after a spill to put lime on the material which disinfects by lowering pH  significantly.  Here is another before and after picture showing an area cleaned up by our team.  October 15, 2018 Regular Meeting Agenda Packet 157 of 171     Breaks and Leaks – No reportable breaks or leaks have occurred since the last Board meeting.   A leak on a service line in the Solana area was found but did not meet the criteria for reporting  to TCEQ.  Compliance Investigation ‐ TCEQ met with District and Town staff on September 25, 2018.   TCEQ sent us with an exit interview form that found two areas of non‐compliance: 1) quarterly  calibration records for handheld chlorine residual measurement devices and 2) maintaining a  daily record of chemicals used in the water plant.  Both of these items will be corrected within  30 days of the visit.  Capital Improvement Projects   Interconnecting Pipeline Project Phase 1 – Contractor has completed boring under the road at  Trophy Club Drive and all the infrastructure for this phase has been completed.  No progress  has been made on the final punch list items.  It is my understanding that revegetation  throughout the easement acquired for phase one is required to close out the phase one  project.  We are working with our engineer to push the contractor to complete the work.  Interconnecting Pipeline Project Phase 2 – Our design team for Phase 2 of the project is going  to provide an in person update on this project at today’s meeting.  WWTP – Our contractor has submitted a request for full substantial completion on Phase 3 of  the project and our engineering team is reviewing the request.  This is good news, and while  there is still a considerable punch list to be completed before the work is fully complete,   High Service Pump Project – Last winter this project was put out for bid and all bids we  received were considerably higher than what was budgeted.  This is work that has to be done  during the low flow months of the year so the project was put on hold until the peak demand  October 15, 2018 Regular Meeting Agenda Packet 158 of 171 months had passed.  Activity on this project has picked up again and we anticipate going back  out to bid before the end of the year.  Joint Projects with Town ‐ The Phoenix Drive project is complete.  On October 11, 2018 at 6:00  PM another pre‐construction meeting was held at Town Hall to talk about the Indian Creek  portion of the project.  The meeting was well attended with approximately 30 citizens coming  hear about the project and voice their concerns about a variety of project impacts.  No  concerns were raised about the water aspects of that work.  Fire Department Summary  During the month of September the fire department responded to 74 calls for emergency  service.  The fire inspector completed 17 inspections finding 60 life safety violations for which  he is working with building owners and tenants to correct.  Fire crews also facilitated 7 public  education classes for 41 adults and 86 children.  On October 4th nine members of the  community graduated from our Citizens Fire Academy.  Although this is not our first academy  here in Trophy Club it was the first of its kind.  Class members actively participated in events  including; fire extinguisher use, airway management and IV practice on manikins, toured a  Careflite helicopter, cut up a car using the “Jaws of Life”, climbed our aerial ladder and entered  a live fire training scenario wearing bunker gear and an SCBA to extinguish a fire.  This was a  great benefit to both our firefighters and our participating residents.  We witnessed  participants building new relationships as they learned about our day‐to‐day operations and we  gained future ambassadors of the department and friendships within our community.  The fire  department will have its next citizen’s fire academy next fall and we look forward to building  upon our strong relationship with the community.  In September the fire department also  received word that we were awarded two grants for which we applied last year.  Below is  information about our grants awarded:    The Trophy Club Fire Department has successfully sought and received a grant from FEMA to  help offset the necessary costs associated with securing a Fire Marshal to oversee the fire  prevention and enforcement programs for the fire department.  The department began  working on the grant application in February 2018 and was awarded $104,429 in late  September towards the hiring, equipping, salaries and benefits of a full time Fire Marshal  position.  The position will be charged with the following responsibilities:  1. Oversight of all new construction and remodels both commercial and residential  a. Including PD 30 and 25 projects  2. Complete all high hazard fire inspections  3. Complete all certificates of occupancy inspections  4. Investigate cause and origin of all fires  5. Investigate all arson cases to prosecution  October 15, 2018 Regular Meeting Agenda Packet 159 of 171 6. Train all shift inspectors for low hazard/medium hazard inspections  7. Follow up on all violations and complaints  8. Complete all foster home inspections  9. Oversight of all public education programs  10. Assist with pulling of statistical data for the purpose of reporting  11. Assist with policy creation and review  12. Oversee the AED inspection program for the Town of Trophy Club and MUD 1  13. TCOLE Administrator for the Fire Department  14. Assist with oversight of fire crews at emergency scenes  The accepting of the grant is contingent matching funds of $5,221.00 which the MUD has  agreed to pay.  The fire marshal will be a Texas Commission on Fire Protection certified  Inspection/Plan Reviewer, Arson Investigator, Firefighter and Texas Commission on Law  Enforcement certified Peace Officer.   We expect to have a candidate hired by November 1,  2018.    The Fire Department was also awarded a grant by Firehouse Subs Public Safety Foundation in  the amount of $21,900.00 for the purchase of 14 Automatic External Defibrillators (AED), 2 AED  training units and associated equipment.  The grant was awarded October 1, 2018.  The AEDs  will be distributed as follows:  1. 2 units at Town Hall   2. 1 at Fire Station  3. 1 at Indy East  4. 1 at Indy West  5. 1 at Harmony Park  6. 1 at Trophy Club Park  7. 1 at Parks Barn  8. 3 for PD vehicles  9. 1 at MUD Admin building  10. 1 at Water Treatment Plant  11. 1 at Water Barn  The units to be purchased will utilize defibrillation pads that match the pads used by the  department’s heart monitors allowing fire department personnel to simply detach the pads  from the AED and attach to our Lifepac 15 heart monitors.  The units will be inspected annually  during the fire and life safety inspections conducted by the Fire Department.  Free training is  offered to citizens by the fire department on an as needed basis as part of our CPR classes.   October 15, 2018 Regular Meeting Agenda Packet 160 of 171 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 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 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 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 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 4712 4716 4720 4724 4724 4728 4732 4735 4736 4738 2018 MUD 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 2018 PID 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 1444 Monthly Water Operations Report 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 THOUSANDS OF GALLONS 2014 2015 2016 2017 2018 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 October November December January February March April May June July August September WATER PUMPED IN THOUSANDS OF GALLONS 2014 2015 2016 2017 2018 October 15, 2018 Regular Meeting Agenda Packet 161 of 171 Influent EffluentInfluent EffluentInfluent Effluent4‐Sep 42.8 0.2 99.5% 166 2.0 98.8% 205 1.0 99.5%5‐Sep 34.5 0.29 99.2% 157 2.0 98.7% 218 1.0 99.5%      10‐Sep 44.5 0.20 99.6% 175 2.0 98.9% 328 1.0 99.7%11‐Sep 47.0 0.20 99.6% 124 2.0 98.4% 130 1.0 99.2%   17‐Sep 42.5 0.20 99.5% 113 2.0 98.2% 175 1.2 99.3%18‐Sep 49.6 0.20 99.6% 218 2.0 99.1% 298 1.0 99.7% 24‐Sep 37.0 0.28 99.2% 121 2.0 98.3% 248 1.0 99.6%27‐Sep 42.5 0.68 98.4% 201 2.0 99.0% 288 1.0 99.7%99.3%98.7%99.5%September 2018 ResultsAmmonia‐NCBOD5TSS0.282.01.0Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportOctober 15, 2018 Regular Meeting Agenda Packet162 of 171 Max mg/L0.49Aver mg/L0.292Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.2510.2800.2200.2000.3700.28100.511.522.533.5Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18NH‐3 mg/LAveragePermit Limit2.02.02.02.02.02.02.02.02.00.0001.0002.0003.0004.0005.0006.000Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18CBOD5AveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet163 of 171 Max mg/L1.04Aver mg/L1.0Max mg/L8.8Aver mg/L5.0Total Suspended Solids (TSS)Nitrate - Nitrogen1.01.01.01.01.01.01.01.01.00.02.04.06.08.010.012.014.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18TSSAveragePermit Limit8.84.07.44.73.53.84.64.04.60.05.010.015.020.025.030.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18Nitrate‐NAveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet164 of 171 Max mg/L5.0Aver mg/L1.9Max mg/L7.8Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.01.01.01.01.00.020.040.060.080.0100.0120.0140.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18E. ColiAveragePermit Limit7.27.27.27.37.37.27.27.57.277.37.47.47.37.67.77.57.87.40.01.02.03.04.05.06.07.08.09.010.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18pH MinAveragePermit Limit MinPermit Limit MaxpH MaxOctober 15, 2018 Regular Meeting Agenda Packet165 of 171 Max mg/L7.8Aver mg/L7.3 Dissolved Oxygen (DO)7.87.57.87.67.47.47.06.57.10.01.02.03.04.05.06.07.08.09.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18DOAveragePermit LimitOctober 15, 2018 Regular Meeting Agenda Packet166 of 171 October November December January February March April May June July August September ebills 796 828 829 834 839 844 841 849 848 851 860 865 Bills Mailed 3906 3900 3912 3911 3908 3913 3921 3935 3956 3946 3948 3929 Bank Draft 631 623 639 653 657 656 655 654 660 651 654 653 Credit Card Draft 1018 1020 1026 1033 1042 1056 1054 1056 1067 1068 1061 1076 Online Payments 1037 1079 1,072 1,065 1,086 1,097 1,019 1,080 1,084 1128 1130 1102 Late Notices 391 420 457 362 424 407 299 355 413 352 427 438 Disconnects 25 27 27 25 22 27 24 17 20 20 16 30 M 3257 3262 3268 3272 3276 3280 3280 3284 3288 3291 3292 3294 Connections P 1444 1444 1444 1444 1444 1444 1444 1444 1444 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 October 15, 2018 Regular Meeting Agenda Packet 167 of 171 MUD Permits Month: September 2018 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 9/26/2018 2018-0035 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 9/28/2018 2018-0044 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ Total 150.00$ 2,346.00$ 686.00$ 300.00$ 100.00$ -$ -$ 3,582.00$ October 15, 2018 Regular Meeting Agenda Packet 168 of 171 135-10175 Bank of the West MMA (XXX6372) General Fund Operating $0 $0 $0 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $3,227,798 $3,227,798 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$312,115 $1,067,537 $1,379,652 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$983,515 $0 $983,515 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $596,426 $0 $596,426 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $0 $0 $0 517-10300 Prosperity Bank Construction WWTP Improvements $0 $0 $0 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$767,358 $0 $767,358 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $606,910 $0 $606,910 533-10250 TexPool Tax I & S (XXXXX0003)$48,716 $0 $48,716 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $19,562 $0 $19,562 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $2,584 $0 $2,584 $3,341,758 $4,295,934 $7,637,692 Amount available in cash (MUD Accounts)$4,295,934 Amount available for spending (MUD Accounts)$4,295,934 * 09/30/18 Customer Water Deposits $312,115 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $543,883 $543,883 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $543,883 $543,883 Amount available in cash (Fire Department Accounts)$543,883 Amount available for spending (Fire Department Accounts)$543,883 -$ Bank of the West MM 1,067,537$ Prosperity General Fund 3,227,798$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 4,295,934$ Nonspendable Fund Balance (Prepaids)8,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 2,302,431$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $6,457,799 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF SEPTEMBER 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) October 15, 2018 Regular Meeting Agenda Packet 169 of 171 TC Meeting Spaces Modier November 2018 Powered by Calendars FS Conference Room FS Training Room PS Large Conference Room Svore Board Room Sun Mon Tue Wed Thu Fri Sat 44 45 46 47 48 Oct , Nov :pm Trophy Clu pm Office Closes a Holiday Dec October 15, 2018 Regular Meeting Agenda Packet 170 of 171 TC Meeting Spaces Modier December 2018 Powered by Calendars FS Conference Room FS Training Room PS Large Conference Room Svore Board Room Sun Mon Tue Wed Thu Fri Sat 48 49 50 51 52 1 Nov , Dec :pm Trophy Clu Jan October 15, 2018 Regular Meeting Agenda Packet 171 of 171