Loading...
HomeMy WebLinkAbout2018-1126 November 26 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, November 26, 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. October 2018 Check Register  b. October 15, 2018 Regular Meeting Minutes  c. November 7, 2018 Special Meeting Minutes      attachments: Check Register                      October 15, 2018 meeting minutes    November 7, 2018 meeting minutes    REGULAR SESSION  2. Consider and take appropriate action to appoint representatives to the City of Fort Worth Wholesale  Water Customer Advisory Committee for the Fiscal Year beginning October 1, 2018 through September  30, 2019. (Staff)    attachment: Appointment form    3. Consider and take appropriate action regarding approval of Contract No. 2018112601 with United  Healthcare Company for employee healthcare benefits effective January 1, 2019. (Staff)   attachment: Employee insurance cost comparison   November 26, 2018 Regular Meeting Agenda Packet 1 of 136       4. Consider and take appropriate action relating to District rebranding. (Rose/Castonguay)   attachment: Rebranding revisions    5. Consider and take appropriate action to approve the Service Agreement for Laboratory Services with the  City of Fort Worth’s Centralized Water and Wastewater Laboratory. (Staff)   attachment: Service Agreement    6. Consider and take appropriate action regarding the October 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance            attachment: Combined Financials             Combined Variance  REPORTS & UPDATES  7. General Manager Monthly Reports and Update:  a. Regulatory Update  b. Capital Improvement Projects    Interconnect Water Transmission Line Phase 2   Wastewater Treatment Plant Upgrade Project   High Service Pump   c. Water System Operations  d. Wastewater System Operations  e. Holiday Office Closures – December 14, 2018 at 12 p.m.  f. Finance Update   Utility Billing Report   Permits Collected   Cash Report           attachments:  General Manager Report    Water Operations Report    Wastewater Operations Report    Utility Billing Report    Permits Collected    Cash Report  EXECUTIVE SESSION  8. 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  November 26, 2018 Regular Meeting Agenda Packet 2 of 136     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); and  c. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy  Club Drive, Trophy Club Texas.    9. 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  10. Consider and take appropriate action on matters deliberated in Executive Session:    11. Items for future agendas:     12. Set future Meeting dates:  Regular Board Meeting – Monday, December 17, 2018 at 6:30 p.m.       attachment: Meeting calendar    *THE BOARD RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE  MEETING PURSUANT TO THE APPLICABLE SECTION OF SUBCHAPTER D, CHAPTER 551, TEXAS GOVERNMENT  CODE, THE TEXAS OPEN MEETINGS ACT, WITH RESPECT TO ANY ITEM ON THE AGENDA.  NO FINAL ACTION,  DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION.  THIS NOTICE  MODIFIES  THE  DISTRICT'S  PRIOR  PRACTICE  OF  SPECIFICALLY  IDENTIFYING  ALL  AGENDA  ITEMS  TO  BE  DISCUSSED IN EXECUTIVE SESSION.    ADJOURN    November 26, 2018 Regular Meeting Agenda Packet 3 of 136 November 26, 2018 Regular Meeting Agenda Packet 4 of 136 November 26, 2018 Regular Meeting Agenda Packet 5 of 136 November 26, 2018 Regular Meeting Agenda Packet 6 of 136 November 26, 2018 Regular Meeting Agenda Packet 7 of 136     TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   October 15, 2018   REGULAR MEETING MINUTES       Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Regular Session Meeting on October 15, 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  Steve Flynn  Secretary/Treasurer  Kelly Castonguay  Director  Mark Chapman  Director    STAFF PRESENT:  John Carman  General Manager  Laurie Slaght  District Secretary  Mike McMahon  Operations Manager  Steven Krolczyk  Finance Manager  Tony Corbett  Legal Counsel    GUESTS PRESENT:   Leah Hodge PE         Halff and Associates    CALL TO ORDER AND ANNOUNCE A QUORUM   President Wilson announced the date of October 15, 2018, called the meeting to order and announced a  quorum present at 6:31 p.m.    CITIZEN COMMENTS  Patricia Zepeda        1040 Trophy Club Drive    CONSENT AGENDA  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    Motion made by Director Flynn and seconded by Director Chapman to approve the Consent Agenda as  presented.    Motion carried unanimously    October 15, 2018 Regular Meeting Minutes 1 of 5 November 26, 2018 Regular Meeting Agenda Packet 8 of 136     REGULAR SESSION  2. Introduction of new Wastewater Superintendent Frank Isola.     General Manager John Carman introduced the new Wastewater Superintendent, Frank Isola to the Board  of  Directors.    Mike  McMahon,  Operations  Manager  stated  that  he is  very  pleased  with  Franks  performance.  McMahon added that Frank was promoted to the position of Wastewater Superintendent  from an operator position effective October 1, 2018. Frank stated that he is very thankful for this  opportunity and truly enjoys working here.  The Board welcomed Mr. Isola to the position.    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.    Leah Hodge PE with Halff and Associates gave a presentation of the design and construction of the water  transmission line to the east side elevated water tank.  Mrs. Hodge outlined the easement acquisitions  that will be needed to proceed with the waterline placement; reviewed the Engineer’s Statement of  Probable Cost for the project; and discussed the project schedule.       Discussion only, no action taken    4. 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)    Motion made by Director Rose and seconded by Director Castonguay to approve the 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 not to exceed $26,571.    Motion carried unanimously    5. Discussion and possible action regarding access to wastewater plant during rain event.     General Manager John Carman stated that on September 21 ‐22nd the Town of Trophy Club had a  significant rain event and portions of the town received amounts up to 10” of rain and staff were unable  to access the wastewater plant due to flooded roads.      Motion made by Director Rose and seconded by Director Chapman to have the General Manager write a  letter to the town manager detailing the difficulties that the staff had making it to the wastewater  treatment plant during the rain event and that the discussion be limited to the occurrences within the  town.     Motion carried unanimously    6. Consider and take appropriate action regarding the following engineering matters:    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  October 15, 2018 Regular Meeting Minutes 2 of 5 November 26, 2018 Regular Meeting Agenda Packet 9 of 136     Order Basis.  6 a.  Motion made by Director Rose and seconded by Director Flynn to approve amendment No. 3 for an  amount not to exceed $20,000.    Motion carried unanimously      6 b.  Motion made by Director Flynn and seconded by Director Castonguay to approve Amendment No. 5 for  additional engineering construction services fee for an amount not to exceed $96,625.    Motion carried unanimously      6 c.  Motion made by Director Rose and seconded by Director Chapman to approve the agreement with Halff  Associates, Inc. for Professional Engineering Services to be implemented on a Task Order Basis.    Motion carried unanimously      7. Consider and take appropriate action regarding the September 2018 Combined Financials and Variance  Report.    a. Combined Financials   b. Combined Variance     Motion made by Director Rose and seconded by Director Castonguay to approve the September 2018  combined financials and combined variance report.    Motion carried unanimously    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   Cash Report    October 15, 2018 Regular Meeting Minutes 3 of 5 November 26, 2018 Regular Meeting Agenda Packet 10 of 136     General Manager John Carman presented his monthly update to the board and answered questions  related thereto.     The Board of Directors did not convene into Executive Session.    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.    The Board of Directors did not convene into Executive Session.    REGULAR SESSION  11. Consider and take appropriate action on matters deliberated in Executive Session:    There was no 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.         Motion made by Director Rose and seconded by Director Flynn to hold the November 2018 Regular  Meeting date to Monday, November 26, 2018.    Motion carried unanimously    ADJOURN    Motion made by Director Rose and seconded by Director Castonguay to adjourn the meeting.    Motion carried unanimously      October 15, 2018 Regular Meeting Minutes 4 of 5 November 26, 2018 Regular Meeting Agenda Packet 11 of 136     President Wilson called the meeting adjourned at 8:30 p.m.        ___________________________  Gregory Wilson, President                                                                                                         (SEAL)    ____________________________                                                 Steve Flynn, Secretary/Treasurer                                                                                                                                   ____________________________  Laurie Slaght, District Secretary        October 15, 2018 Regular Meeting Minutes 5 of 5 November 26, 2018 Regular Meeting Agenda Packet 12 of 136     TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   NOVEMBER 7, 2018   SPECIAL MEETING MINUTES     Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Special Session on November 7, 2018 at 5:30 P.M., in the Svore Municipal Boardroom at 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  Mark Chapman  Director    BOARD MEMBERS ABSENT:  Steve Flynn  Secretary/Treasurer    STAFF PRESENT:  John Carman  General Manager  Laurie Slaght  District Secretary  Mike McMahon  Operations Manager  Steven Krolczyk  Finance Manager    CALL TO ORDER AND ANNOUNCE A QUORUM   President Wilson announced the date of November 7, 2018, called the meeting to order and announced  a quorum present at 5:32 p.m.    CITIZEN COMMENTS  There were no Citizen Comments    REGULAR SESSION  1. Consider and take appropriate action to authorize Prosperity Bank to change the District savings  account type to a money market account to yield additional interest.       Motion made by Director Rose and seconded by Director Castonguay to authorize Prosperity Bank to  change the District savings account type to a money market account to yield additional interest.    Motion carried unanimously      2. Consider  and  take  appropriate  action  to  approve  bid  for  electrical  upgrades  to  lift  station  improvements  and  award  Contract  No.  2018110701  as  part  of  the  Fiscal  Year  2019  Capital  Improvement Projects.  November 7, 2018 Special Meeting Minutes 1 of 2 November 26, 2018 Regular Meeting Agenda Packet 13 of 136     Motion made by Director Rose and seconded by Director Chapman t o approve Contract No. 2018110701  for lift station improvements from DHS Automation an amount not to exceed $74,706.00.    Motion carried unanimously    3. Consider and take appropriate action regarding approval of acquisition of a CUES Transit 350 Demo  Unit (Camera Van) for the water department to be purchased through the Buy Board contract at CLS  Equipment Company for an amount of $193,528.50      Motion made by Director Wilson and seconded by Director Rose to approve acquisition of a CUES  Transit 350 Demo Unit (Camera Van) for the water department to be purchased through the Texas Buy  Board contract at CLS Equipment Company for an amount not to exceed $193,528.50.    Motion carried unanimously    ADJOURN      Motion by Director Rose and seconded by Director Chapman to adjourn the meeting    Motion carried unanimously      President Wilson adjourned the special meeting at 5:40 p.m.      ___________________________  Gregory Wilson, President                                                                                                     ____________________________                           (SEAL)               Steve Flynn, Secretary/Treasurer                                                                                                                                   ____________________________  Laurie Slaght, District Secretary    November 7, 2018 Special Meeting Minutes 2 of 2 November 26, 2018 Regular Meeting Agenda Packet 14 of 136   cfs01\water\Groups\WholeSale\Wholesale Customer Advisory Committee\Water APPT Sheets\OfficialAppointsmentsForm2019  APPOINTMENT FORM Wholesale Water and Wastewater Customer Advisory Committee DATE: _______________________ WHOLESALE CUSTOMER: ______________________________________________________ Check all that apply: □ Water □ Wastewater The following individuals have been officially appointed by the CUSTOMER’s GOVERNING BODY, under the terms of the Wholesale Contract for Services, Section 15, as the VOTING MEMBER and ALTERNATE for the Water and/or Wastewater System Advisory Committee. The term is for the Fiscal Year beginning October 1, 2018 through September 30, 2019. Voting Member: Alternate Member ________________________________ ________________________________ Name Name ________________________________ ________________________________ Title Title _______________________________ ________________________________ Office Phone Office Phone _______________________________ ________________________________ Cell Phone Cell Phone _______________________________ ________________________________ Email Address Email Address Mailing Address: Mailing Address: _______________________________ ________________________________ ________________________________ ________________________________ ________________________________ ________________________________ ________________________________ Official Seal Gregory Wilson, Board President Please complete and return as soon as possible, but no later than December 31, 2018 to: WaterWholesale@fortworthtexas.gov or City of Fort Worth Water Department Billing Section/Wholesale P. O. Box 870 Fort Worth, Texas 76101 November 26, 2018 Regular Meeting Agenda Packet 15 of 136 Employee Insurance Cost Comparison  FY 2019 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 4 $7,077 $28,308 Employee Only 4 $8,846 $35,386 Employee & Spouse 0 $11,223 $0 Employee & Spouse 0 $14,028 $0 Employee & Children 0 $10,717 $0 Employee & Children 0 $13,397 $0 Family 2 $15,773 $31,546 Family 2 $19,716 $39,432 TOTAL 6 $59,854 TOTAL 6 $74,818 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 4 $10,315 $41,259 Employee Only 4 $8,453 $33,812 Employee & Spouse 0 $15,472 $0 Employee & Spouse 0 $12,838 $0 Employee & Children 0 $15,472 $0 Employee & Children 0 $12,041 $0 Family 2 $20,630 $41,259 Family 2 $16,824 $33,649 TOTAL 6 $82,519 TOTAL 6 $67,461 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 2 $7,077 $14,154 Employee Only 2 $8,846 $17,693 Employee & Spouse 1 $11,223 $11,223 Employee & Spouse 1 $14,028 $14,028 Employee & Children 3 $10,717 $32,152 Employee & Children 3 $13,397 $40,190 Family 1 $15,773 $15,773 Family 1 $19,716 $19,716 TOTAL 7 $73,302 TOTAL 7 $91,627 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 2 $10,315 $20,630 Employee Only 2 $8,453 $16,906 Employee & Spouse 1 $15,472 $15,472 Employee & Spouse 1 $12,838 $12,838 Employee & Children 3 $15,472 $46,417 Employee & Children 3 $12,041 $36,122 Family 1 $20,630 $20,630 Family 1 $16,824 $16,824 TOTAL 7 $103,148 TOTAL 7 $82,690 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 4 $7,077 $28,308 Employee Only 4 $8,846 $35,386 Employee & Spouse 0 $11,223 $0 Employee & Spouse 0 $14,028 $0 Employee & Children 2 $10,717 $21,434 Employee & Children 2 $13,397 $26,793 Family 1 $15,773 $15,773 Family 1 $19,716 $19,716 TOTAL 7 $65,516 TOTAL 7 $81,895 NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT ANNUAL  COST  PROJECTED NO. EMPLOYEES ANNUAL RATE  (TCMUD Share) DISTRICT  ANNUAL COST   PROJECTED  Employee Only 4 $10,315 $41,259 Employee Only 4 $8,453 $33,812 Employee & Spouse 0 $15,472 $0 Employee & Spouse 0 $12,838 $0 Employee & Children 2 $15,472 $30,945 Employee & Children 2 $12,041 $24,081 Family 1 $20,630 $20,630 Family 1 $16,824 $16,824 TOTAL 7 $92,834 TOTAL 7 $74,718 UHC All Savers FY 19 Budget BCBS Aetna Aetna Budget UHC All SaversBCBS WASTEWATER Aetna UHC All Savers Budget BCBS ADMINISTRATION WATER Grand Total $198,671.64 $224,868.48 $278,500.44 $248,339.55 % Increase Cost From  Current Plan 0.00% 13.19% 40.18% 25.00% Company Aetna UHC All Savers BCBS FY 19 Budget November 26, 2018 Regular Meeting Agenda Packet 16 of 136 Please select your top 4 logos for the MUD:  First choice: ____ (4 pts.); Second choice: ____(3 pts.); Third Choice: ____(2 pts.); Fourth Choice: ____(1 pt.)The logo with the most points wins!!  Thanks for voting!!  November 26, 2018 Regular Meeting Agenda Packet17 of 136 November 26, 2018 Regular Meeting Agenda Packet18 of 136 November 26, 2018 Regular Meeting Agenda Packet19 of 136 November 26, 2018 Regular Meeting Agenda Packet20 of 136 November 26, 2018 Regular Meeting Agenda Packet21 of 136 November 26, 2018 Regular Meeting Agenda Packet22 of 136 November 26, 2018 Regular Meeting Agenda Packet23 of 136 November 26, 2018 Regular Meeting Agenda Packet24 of 136 November 26, 2018 Regular Meeting Agenda Packet25 of 136 November 26, 2018 Regular Meeting Agenda Packet26 of 136 November 26, 2018 Regular Meeting Agenda Packet27 of 136 November 26, 2018 Regular Meeting Agenda Packet28 of 136 November 26, 2018 Regular Meeting Agenda Packet29 of 136 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 278,787 PREPAID EXPENSES 16,403 ADVALOREM PROPERTY TAXES RECEIVABLE 1,117,393 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,412,583 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,117,392 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 1,117,392 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (248,693) TOTAL FUND BALANCE 295,191 TOTAL LIABILITIES AND FUND BALANCE 1,412,583 November 26, 2018 Regular Meeting Agenda Packet 30 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 11:31 11/19/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/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,117,000.00- 1,117,000.00- 17,258.14- 17,258.14- 1.545 1,099,741.86- 122-40011-000-000 Property Taxes/Fire-Delinquent 274.03- 274.03- 274.03 122-40020-000-000 Property Taxes/Fire P&I 39.01- 39.01- 39.01 Subtotal: 1,117,000.00- 1,117,000.00- 17,571.18- 17,571.18- 1.573 1,099,428.82- 122-49035-000-000 Prior Year Reserves 75,000.00- 75,000.00- 75,000.00- Subtotal: 75,000.00- 75,000.00- 75,000.00- Program number: 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- Revenues Subtotal ----------- 1,192,000.00- 1,192,000.00- 17,571.18- 17,571.18- 1.474 1,174,428.82- November 26, 2018 Regular Meeting Agenda Packet 31 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 11:31 11/19/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60030-045-000 Rent And/Or Usage 215,979.00 215,979.00 215,979.00 122-60055-045-000 Insurance 18,000.00 18,000.00 1,491.21 1,491.21 8.285 16,508.79 122-60337-045-000 Transfer to Town/Fire Budget 56,204.00 56,204.00 56,204.00- Subtotal: 233,979.00 233,979.00 57,695.21 57,695.21 24.658 176,283.79 122-69005-045-000 Capital Outlays 75,000.00 75,000.00 75,000.00 122-69195-045-000 GASB34/Reserve for Replacement 81,420.00 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 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 208,568.60 73.551 75,000.40 Program number: 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Department number: Fire 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Expenditures Subtotal ----------- 517,548.00 517,548.00 266,263.81 266,263.81 51.447 251,284.19 Fund number: 122 Trophy Club MUD Fire Dept. 674,452.00- 674,452.00- 248,692.63 248,692.63 -36.873 923,144.63- November 26, 2018 Regular Meeting Agenda Packet 32 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/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 172 10/01/2018 Property taxes (.40) (.40) GL 175 10/09/2018 Property Taxes (221.38) (221.78) GL 176 10/11/2018 Property Taxes (167.83) (389.61) GL 177 10/12/2018 Property Taxes (319.03) (708.64) GL 178 10/15/2018 Property Taxes (223.44) (932.08) GL 179 10/17/2018 Property Taxes (239.27) (1,171.35) GL 180 10/18/2018 Property Taxes (269.92) (1,441.27) GL 181 10/19/2018 Property Taxes (683.31) (2,124.58) GL 182 10/22/2018 Property Taxes (907.50) (3,032.08) GL 183 10/23/2018 Property Taxes (1,430.70) (4,462.78) GL 184 10/24/2018 Property Taxes (1,370.62) (5,833.40) GL 185 10/25/2018 Property Taxes (3,143.13) (8,976.53) GL 186 10/26/2018 Property Taxes (2,027.60) (11,004.13) GL 187 10/29/2018 Property Taxes (2,363.75) (13,367.88) GL 188 10/30/2018 Property Taxes (2,854.12) (16,222.00) GL 189 10/31/2018 Property Taxes (1,036.14) (17,258.14) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (17,258.14) (17,258.14) ** (1,117,000.00) Budgeted (1,099,741.86) Remaining 2 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 172 10/01/2018 Property taxes (80.01) (80.01) GL 174 10/05/2018 Property Taxes (21.10) (101.11) GL 175 10/09/2018 Property Taxes 15.26 (85.85) GL 180 10/18/2018 Property Taxes (60.61) (146.46) GL 182 10/22/2018 Property Taxes (122.89) (269.35) GL 189 10/31/2018 Property Taxes (4.68) (274.03) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (274.03) (274.03) ** .00 Budgeted 274.03 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 172 10/01/2018 Property taxes (11.84) (11.84) GL 174 10/05/2018 Property Taxes (2.46) (14.30) GL 180 10/18/2018 Property Taxes (5.45) (19.75) GL 182 10/22/2018 Property Taxes (12.51) (32.26) GL 186 10/26/2018 Property Taxes (2.18) (34.44) GL 189 10/31/2018 Property Taxes (4.57) (39.01) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (39.01) (39.01) ** .00 Budgeted 39.01 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 33 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 10/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-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 122-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (75,000.00) Budgeted (75,000.00) Remaining 0 % Used Department Totals: ----------------------------------- (17,571.18) ** (17,571.18) Monthly Total (1,192,000.00) Budgeted (1,174,428.82) Remaining 1 % Used November 26, 2018 Regular Meeting Agenda Packet 34 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/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-60030-045-000 Rent And/Or Usage .00 .00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 .00 ** 215,979.00 Budgeted 215,979.00 Remaining 0 % Used Account: 122-60055-045-000 Insurance 125 10/01/2018 Insurance/Wrk Comp Expense Oct 1,491.21 1,491.21 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,491.21 1,491.21 ** 18,000.00 Budgeted 16,508.79 Remaining 8 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 21 10/05/2018 October A/P October Fire admin 56,204.00 56,204.00 TOWN OF TROPHY CLUB 4649 AP _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: 56,204.00 56,204.00 ** .00 Budgeted (56,204.00) Remaining 0 % Used Account: 122-69005-045-000 Capital Outlays .00 .00 _______________ Account: 122-69005-045-000 Capital Outlays Totals: .00 .00 ** 75,000.00 Budgeted 75,000.00 Remaining 0 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Fire Truck Future Replacement 81,420.00 81,420.00 GL _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: 81,420.00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 42 10/10/2018 October A/P Lease payment FD ladder- T681 127,148.60 127,148.60 PNC Bank, N.A. 4656 AP _______________ Account: 122-69305-045-000 Capital Leases Totals: 127,148.60 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 266,263.81 ** 266,263.81 Monthly Total 517,548.00 Budgeted 251,284.19 Remaining 51 % Used November 26, 2018 Regular Meeting Agenda Packet 35 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 10/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: ----------------------------------- 248,692.63 248,692.63 Monthly Total (674,452.00) Budgeted (923,144.63) Remaining -37 % Used November 26, 2018 Regular Meeting Agenda Packet 36 of 136 TROPHY CLUB MUD #1 - O&M BALANCE SHEET OCTOBER 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 2,094,039 - 2,094,039 CASH IN BANK-SAVINGS-CASH RESERVE 983,515 - 983,515 INVESTMENTS-TEXPOOL 2,904,623 782,846 3,687,469 PREPAID EXPENSES 97,515 - 97,515 ADVALOREM PROPERTY TAXES RECEIVABLE 127,124 - 127,124 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,227,397 - 1,227,397 TOTAL ASSETS 7,434,813 782,846 8,217,659 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 127,124 - 127,124 ACCOUNTS AND OTHER PAYABLES 470,667 - 470,667 CUSTOMER DEPOSITS 311,465 - 311,465 - TOTAL LIABILITIES 909,256 - 909,256 FUND BALANCE NON-SPENDABLE FUND BALANCE 8,486 8,486 ASSIGNED FUND BALANCE 1,906,543 1,906,543 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 225,000 225,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 150,000 150,000 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 97,805 97,805 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 310,041 310,041 UNASSIGNED FUND BALANCE 4,594,239 - 4,594,239 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES 16,289 - 16,289 - TOTAL FUND BALANCE 6,525,557 782,846 7,308,403 TOTAL LIABILITIES AND FUND BALANCE 7,434,813 782,846 8,217,659 November 26, 2018 Regular Meeting Agenda Packet 37 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 132,384.00- 132,384.00- 1,964.94- 1,964.94- 1.484 130,419.06- 135-40002-000-000 Property Taxes/Delinquent 300.00- 300.00- 31.11- 31.11- 10.370 268.89- 135-40015-000-000 Property Taxes/P & I 300.00- 300.00- 4.23- 4.23- 1.410 295.77- 135-40025-000-000 PID Surcharges 171,983.00- 171,983.00- 171,983.00- Subtotal: 304,967.00- 304,967.00- 2,000.28- 2,000.28- .656 302,966.72- 135-47000-000-000 Water 6,599,484.00- 6,599,484.00- 353,428.58- 353,428.58- 5.355 6,246,055.42- 135-47005-000-000 Sewer 3,412,665.00- 3,412,665.00- 257,430.59- 257,430.59- 7.543 3,155,234.41- 135-47025-000-000 Penalties 136,418.00- 136,418.00- 9,876.08- 9,876.08- 7.240 126,541.92- 135-47030-000-000 Service Charges 17,000.00- 17,000.00- 1,425.00- 1,425.00- 8.382 15,575.00- 135-47035-000-000 Plumbing Inspections 1,500.00- 1,500.00- 1,500.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 4,500.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 17.60- 17.60- .029 59,982.40- Subtotal: 10,231,567.00- 10,231,567.00- 622,177.85- 622,177.85- 6.081 9,609,389.15- 135-49010-000-000 Interest Income 20,000.00- 20,000.00- 8,671.04- 8,671.04- 43.355 11,328.96- 135-49016-000-000 Cell Tower Revenue 14,146.00- 14,146.00- 1,505.48- 1,505.48- 10.642 12,640.52- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 583.33- 8.333 6,416.67- 135-49026-000-000 Proceeds from Sale of Assets 10,000.00- 10,000.00- 10,000.00- 135-49075-000-000 Oversize Meter Reimbursement 18,522.00- 18,522.00- 18,522.00- 135-49900-000-000 Miscellaneous Income 7,000.00- 7,000.00- 485.26- 485.26- 6.932 6,514.74- Subtotal: 76,668.00- 76,668.00- 11,245.11- 11,245.11- 14.667 65,422.89- Program number: 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- Department number: Revenues 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- Revenues Subtotal ----------- 10,613,202.00- 10,613,202.00- 635,423.24- 635,423.24- 5.987 9,977,778.76- November 26, 2018 Regular Meeting Agenda Packet 38 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 326,755.00 326,755.00 11,375.95 11,375.95 3.481 315,379.05 135-50010-010-000 Overtime 20,000.00 20,000.00 565.62 565.62 2.828 19,434.38 135-50016-010-000 Longevity 3,620.00 3,620.00 3,620.00 135-50017-010-000 Certification 4,800.00 4,800.00 200.00 200.00 4.167 4,600.00 135-50020-010-000 Retirement 33,304.00 33,304.00 2,174.42 2,174.42 6.529 31,129.58 135-50026-010-000 Medical Insurance 74,818.00 74,818.00 2,948.80 2,948.80 3.941 71,869.20 135-50027-010-000 Dental Insurance 4,317.00 4,317.00 213.65 213.65 4.949 4,103.35 135-50028-010-000 Vision Insurance 701.00 701.00 35.92 35.92 5.124 665.08 135-50029-010-000 Life Insurance & Other 3,131.00 3,131.00 197.61 197.61 6.311 2,933.39 135-50030-010-000 Social Security Taxes 22,021.00 22,021.00 741.36 741.36 3.367 21,279.64 135-50035-010-000 Medicare Taxes 5,150.00 5,150.00 173.37 173.37 3.366 4,976.63 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 12,895.00 12,895.00 930.94 930.94 7.219 11,964.06 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 300.00 300.00 300.00 Subtotal: 513,092.00 513,092.00 19,557.64 19,557.64 3.812 493,534.36 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 100,000.00 100,000.00 4,431.38 4,431.38 4.431 95,568.62 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 723.46 723.46 14.469 4,276.54 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55135-010-000 Lab Analysis 6,500.00 6,500.00 407.70 407.70 6.272 6,092.30 Subtotal: 143,214.00 143,214.00 5,562.54 5,562.54 3.884 137,651.46 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 370.98 370.98 7.420 4,629.02 135-60020-010-000 Electricity 154,204.00 154,204.00 18,928.67 18,928.67 12.275 135,275.33 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 500.00 135-60080-010-000 Schools & Training 4,651.00 4,651.00 120.00 120.00 2.580 4,531.00 135-60090-010-000 Safety Program 400.00 400.00 400.00 135-60100-010-000 Travel & per diem 2,345.00 2,345.00 2,345.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 1,500.00 135-60135-010-000 TCEQ Fees & Permits 58,000.00 58,000.00 58,000.00 135-60150-010-000 Wholesale Water 3,013,494.00 3,013,494.00 3,013,494.00 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 1,340.00 1,340.00 9.085 13,410.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 585,209.00 585,209.00 25,172.81 25,172.81 4.302 560,036.19 135-60333-010-000 Interfund Transfer Out-Reserve 55,193.00 55,193.00 4,600.00 4,600.00 8.334 50,593.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 November 26, 2018 Regular Meeting Agenda Packet 39 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 4,101,946.00 4,101,946.00 50,532.46 50,532.46 1.232 4,051,413.54 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 643.17 643.17 4.288 14,356.83 135-65010-010-000 Uniforms 5,190.00 5,190.00 5,190.00 135-65030-010-000 Chemicals 20,000.00 20,000.00 2,724.11 2,724.11 13.621 17,275.89 135-65035-010-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-010-000 Safety Equipment 1,000.00 1,000.00 1,000.00 135-65050-010-000 Meter Expense 70,000.00 70,000.00 70,000.00 135-65053-010-000 Meter Change Out Program 87,000.00 87,000.00 87,000.00 Subtotal: 199,390.00 199,390.00 3,367.28 3,367.28 1.689 196,022.72 135-69005-010-000 Capital Outlays 453,000.00 453,000.00 18,533.35 18,533.35 4.091 434,466.65 135-69008-010-000 Short Term Debt-Principal 30,068.00 30,068.00 30,068.00 135-69009-010-000 Short Term Debt-Interest 4,124.00 4,124.00 4,124.00 135-69195-010-000 Gasb34/Reserve for Replacement 75,000.00 75,000.00 75,000.00 75,000.00 100.000 135-69281-010-000 Water Tank Inspection Contract 120,000.00 120,000.00 120,000.00 Subtotal: 682,192.00 682,192.00 93,533.35 93,533.35 13.711 588,658.65 Program number: 5,639,834.00 5,639,834.00 172,553.27 172,553.27 3.060 5,467,280.73 November 26, 2018 Regular Meeting Agenda Packet 40 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/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 287.70 287.70 14.385 1,712.30 Subtotal: 2,000.00 2,000.00 287.70 287.70 14.385 1,712.30 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 287.70 287.70 14.385 1,712.30 Department number: Water 5,641,834.00 5,641,834.00 172,840.97 172,840.97 3.064 5,468,993.03 November 26, 2018 Regular Meeting Agenda Packet 41 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 421,699.00 421,699.00 13,037.12 13,037.12 3.092 408,661.88 135-50010-020-000 Overtime 30,000.00 30,000.00 987.41 987.41 3.291 29,012.59 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 135-50017-020-000 Certification 8,700.00 8,700.00 700.00 700.00 8.046 8,000.00 135-50020-020-000 Retirement 43,276.00 43,276.00 2,878.72 2,878.72 6.652 40,397.28 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,510.24 5,510.24 6.014 86,116.76 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 371.89 371.89 7.286 4,732.11 135-50028-020-000 Vision Insurance 826.00 826.00 58.90 58.90 7.131 767.10 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 285.20 285.20 6.345 4,209.80 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 821.24 821.24 2.831 28,184.76 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 192.07 192.07 2.831 6,591.93 135-50040-020-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-020-000 Workman's Compensation 16,941.00 16,941.00 1,205.73 1,205.73 7.117 15,735.27 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 300.00 Subtotal: 667,863.00 667,863.00 26,048.52 26,048.52 3.900 641,814.48 135-55005-020-000 Engineering 30,000.00 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 88,000.00 88,000.00 3,310.21 3,310.21 3.762 84,689.79 135-55085-020-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 8,000.00 8,000.00 46.48 46.48 .581 7,953.52 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,500.00 135-55120-020-000 Cleaning Services 5,214.00 5,214.00 5,214.00 135-55125-020-000 Dumpster Services 75,000.00 75,000.00 4,494.98 4,494.98 5.993 70,505.02 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 4,627.46 4,627.46 13.221 30,372.54 Subtotal: 267,714.00 267,714.00 12,479.13 12,479.13 4.661 255,234.87 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 382.49 382.49 7.650 4,617.51 135-60020-020-000 Electricity 174,165.00 174,165.00 24,917.76 24,917.76 14.307 149,247.24 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 69.00 69.00 23.000 231.00 135-60080-020-000 Schools & Training 7,155.00 7,155.00 111.00 111.00 1.551 7,044.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,895.00 1,895.00 1,895.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 30,000.00 30,000.00 16,345.22 16,345.22 54.484 13,654.78 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 6.98 6.98 .140 4,993.02 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 11,600.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,053.00 120,053.00 10,913.90 10,913.90 9.091 109,139.10 November 26, 2018 Regular Meeting Agenda Packet 42 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60332-020-000 Interfund Transfer Out-Rev I&S 688,330.00 688,330.00 54,203.45 54,203.45 7.875 634,126.55 135-60333-020-000 Interfund Transfer Out-Reserve 125,187.00 125,187.00 10,432.00 10,432.00 8.333 114,755.00 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.00 122,777.00 122,777.00 61.389 77,223.00 135-60360-020-000 Furniture/Equipment < $5000 3,500.00 3,500.00 3,500.00 Subtotal: 1,381,335.00 1,381,335.00 240,158.80 240,158.80 17.386 1,141,176.20 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 1,336.58 1,336.58 10.693 11,163.42 135-65010-020-000 Uniforms 5,495.00 5,495.00 1,035.41 1,035.41 18.843 4,459.59 135-65030-020-000 Chemicals 30,000.00 30,000.00 536.00 536.00 1.787 29,464.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 1,200.00 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 181.32 181.32 15.110 1,018.68 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 733.07 733.07 3.665 19,266.93 Subtotal: 70,395.00 70,395.00 3,822.38 3,822.38 5.430 66,572.62 135-69005-020-000 Capital Outlays 330,000.00 330,000.00 2,589.58 2,589.58 .785 327,410.42 135-69008-020-000 Short Term Debt-Principal 109,858.00 109,858.00 109,858.00 135-69009-020-000 Short Term Debt-Interest 14,917.00 14,917.00 14,917.00 135-69195-020-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 30,000.00 100.000 Subtotal: 484,775.00 484,775.00 32,589.58 32,589.58 6.723 452,185.42 Program number: 2,872,082.00 2,872,082.00 315,098.41 315,098.41 10.971 2,556,983.59 Department number: Wastewater 2,872,082.00 2,872,082.00 315,098.41 315,098.41 10.971 2,556,983.59 November 26, 2018 Regular Meeting Agenda Packet 43 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/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.12 2.12 7.067 27.88 Subtotal: 30.00 30.00 2.12 2.12 7.067 27.88 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 750.00 750.00 750.00 135-60075-026-000 Meetings 1,300.00 1,300.00 1,300.00 135-60080-026-000 Schools & Training 4,000.00 4,000.00 295.00 295.00 7.375 3,705.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 5,000.00 135-60245-026-000 Miscellaneous Expenses 2,000.00 2,000.00 2,000.00 Subtotal: 13,200.00 13,200.00 295.00 295.00 2.235 12,905.00 Program number: 13,230.00 13,230.00 297.12 297.12 2.246 12,932.88 Department number: Board of Directors 13,230.00 13,230.00 297.12 297.12 2.246 12,932.88 November 26, 2018 Regular Meeting Agenda Packet 44 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 441,006.00 441,006.00 13,370.27 13,370.27 3.032 427,635.73 135-50010-030-000 Overtime 2,000.00 2,000.00 3.16 3.16 .158 1,996.84 135-50016-030-000 Longevity 1,833.00 1,833.00 1,833.00 135-50020-030-000 Retirement 41,148.00 41,148.00 2,597.25 2,597.25 6.312 38,550.75 135-50026-030-000 Medical Insurance 81,895.00 81,895.00 4,145.24 4,145.24 5.062 77,749.76 135-50027-030-000 Dental Insurance 4,291.00 4,291.00 259.52 259.52 6.048 4,031.48 135-50028-030-000 Vision Insurance 701.00 701.00 42.51 42.51 6.064 658.49 135-50029-030-000 Life Insurance & Other 4,495.00 4,495.00 264.49 264.49 5.884 4,230.51 135-50030-030-000 Social Security Taxes 27,580.00 27,580.00 788.49 788.49 2.859 26,791.51 135-50035-030-000 Medicare Taxes 6,450.00 6,450.00 184.40 184.40 2.859 6,265.60 135-50040-030-000 Unemployment Taxes 1,260.00 1,260.00 1,260.00 135-50045-030-000 Workman's Compensation 1,295.00 1,295.00 106.55 106.55 8.228 1,188.45 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 500.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 5,000.00 Subtotal: 619,454.00 619,454.00 21,761.88 21,761.88 3.513 597,692.12 135-55030-030-000 Software & Support 77,849.00 77,849.00 61,104.08 61,104.08 78.491 16,744.92 135-55070-030-000 Independent Labor 175,000.00 175,000.00 11,666.14 11,666.14 6.666 163,333.86 135-55080-030-000 Maintenance & Repairs 20,000.00 20,000.00 315.00 315.00 1.575 19,685.00 135-55085-030-000 Generator Maint. and Repair 10,000.00 10,000.00 10,000.00 135-55120-030-000 Cleaning Services 10,000.00 10,000.00 10,000.00 135-55160-030-000 Professional Outside Services 66,055.00 66,055.00 66,055.00 135-55205-030-000 Utility Billing Contract 9,000.00 9,000.00 579.29 579.29 6.437 8,420.71 Subtotal: 367,904.00 367,904.00 73,664.51 73,664.51 20.023 294,239.49 135-60005-030-000 Telephone 23,500.00 23,500.00 1,423.08 1,423.08 6.056 22,076.92 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.49 237.49 5.937 3,762.51 135-60020-030-000 Electricity/Gas 8,690.00 8,690.00 557.71 557.71 6.418 8,132.29 135-60025-030-000 Water 2,000.00 2,000.00 48.39 48.39 2.420 1,951.61 135-60035-030-000 Postage 30,000.00 30,000.00 1,727.44 1,727.44 5.758 28,272.56 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 6,899.27 6,899.27 12.418 48,660.73 135-60050-030-000 Bad Debt Expense 1,500.00 1,500.00 1,500.00 135-60055-030-000 Insurance 65,000.00 65,000.00 6,302.73 6,302.73 9.697 58,697.27 135-60066-030-000 Publications/Books/Subscripts 1,000.00 1,000.00 1,000.00 135-60070-030-000 Dues & Memberships 6,000.00 6,000.00 200.00 200.00 3.333 5,800.00 135-60075-030-000 Meetings 400.00 400.00 400.00 135-60079-030-000 Public Education 6,000.00 6,000.00 6,000.00 135-60080-030-000 Schools & Training 8,950.00 8,950.00 8,950.00 135-60100-030-000 Travel & per diem 4,345.00 4,345.00 4,345.00 135-60110-030-000 Physicals/Testing 200.00 200.00 200.00 135-60125-030-000 Advertising 25,000.00 25,000.00 25,000.00 135-60235-030-000 Security 1,288.00 1,288.00 24.00 24.00 1.863 1,264.00 November 26, 2018 Regular Meeting Agenda Packet 45 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60245-030-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60246-030-000 General Manager Contingency 17,000.00 17,000.00 17,000.00 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 263,433.00 263,433.00 17,420.11 17,420.11 6.613 246,012.89 135-65010-030-000 Uniforms 2,050.00 2,050.00 2,050.00 135-65055-030-000 Hardware 7,064.00 7,064.00 7,064.00 135-65085-030-000 Office Supplies 6,000.00 6,000.00 474.06 474.06 7.901 5,525.94 135-65090-030-000 Printer Supplies & Maintenance 3,500.00 3,500.00 3,500.00 135-65095-030-000 Maintenance Supplies 4,000.00 4,000.00 444.04 444.04 11.101 3,555.96 135-65105-030-000 Printing 2,500.00 2,500.00 2,500.00 Subtotal: 25,114.00 25,114.00 918.10 918.10 3.656 24,195.90 135-69005-030-000 Capital Outlays 280,000.00 280,000.00 280,000.00 135-69170-030-000 Copier Lease Installments 4,000.00 4,000.00 293.89 293.89 7.347 3,706.11 Subtotal: 284,000.00 284,000.00 293.89 293.89 .103 283,706.11 Program number: 1,559,905.00 1,559,905.00 114,058.49 114,058.49 7.312 1,445,846.51 Department number: Administration 1,559,905.00 1,559,905.00 114,058.49 114,058.49 7.312 1,445,846.51 November 26, 2018 Regular Meeting Agenda Packet 46 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 11:31 11/19/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/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 11,839.68 11,839.68 8.642 125,160.32 135-55055-039-000 Auditing 30,800.00 30,800.00 5,000.00 5,000.00 16.234 25,800.00 135-55060-039-000 Appraisal 11,714.00 11,714.00 11,714.00 135-55065-039-000 Tax Admin Fees 4,800.00 4,800.00 4,800.00 Subtotal: 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Program number: 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Department number: Non Departmental 184,314.00 184,314.00 16,839.68 16,839.68 9.136 167,474.32 Expenditures Subtotal ----------- 10,271,365.00 10,271,365.00 619,134.67 619,134.67 6.028 9,652,230.33 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 16,288.57- 16,288.57- 4.765 325,548.43- November 26, 2018 Regular Meeting Agenda Packet 47 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 11:31 11/19/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/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- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00- 186,420.00 November 26, 2018 Regular Meeting Agenda Packet 48 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/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 172 10/01/2018 Property taxes (.05) (.05) GL 175 10/09/2018 Property Taxes (25.20) (25.25) GL 176 10/11/2018 Property Taxes (19.11) (44.36) GL 177 10/12/2018 Property Taxes (36.32) (80.68) GL 178 10/15/2018 Property Taxes (25.44) (106.12) GL 179 10/17/2018 Property Taxes (27.24) (133.36) GL 180 10/18/2018 Property Taxes (30.73) (164.09) GL 181 10/19/2018 Property Taxes (77.80) (241.89) GL 182 10/22/2018 Property Taxes (103.33) (345.22) GL 183 10/23/2018 Property Taxes (162.89) (508.11) GL 184 10/24/2018 Property Taxes (156.05) (664.16) GL 185 10/25/2018 Property Taxes (357.86) (1,022.02) GL 186 10/26/2018 Property Taxes (230.86) (1,252.88) GL 187 10/29/2018 Property Taxes (269.13) (1,522.01) GL 188 10/30/2018 Property Taxes (324.96) (1,846.97) GL 189 10/31/2018 Property Taxes (117.97) (1,964.94) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (1,964.94) (1,964.94) ** (132,384.00) Budgeted (130,419.06) Remaining 1 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 172 10/01/2018 Property taxes (8.91) (8.91) GL 174 10/05/2018 Property Taxes (2.42) (11.33) GL 175 10/09/2018 Property Taxes 1.74 (9.59) GL 180 10/18/2018 Property Taxes (6.95) (16.54) GL 182 10/22/2018 Property Taxes (14.10) (30.64) GL 189 10/31/2018 Property Taxes (.47) (31.11) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (31.11) (31.11) ** (300.00) Budgeted (268.89) Remaining 10 % Used Account: 135-40015-000-000 Property Taxes/P & I 172 10/01/2018 Property taxes (1.25) (1.25) GL 173 10/03/2018 Property Taxes .07 (1.18) GL 174 10/05/2018 Property Taxes (.28) (1.46) GL 180 10/18/2018 Property Taxes (.63) (2.09) GL 182 10/22/2018 Property Taxes (1.43) (3.52) GL 186 10/26/2018 Property Taxes (.24) (3.76) GL 189 10/31/2018 Property Taxes (.47) (4.23) GL November 26, 2018 Regular Meeting Agenda Packet 49 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/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-40015-000-000 Property Taxes/P & I Totals: (4.23) (4.23) ** (300.00) Budgeted (295.77) Remaining 1 % Used Account: 135-40025-000-000 PID Surcharges .00 .00 _______________ Account: 135-40025-000-000 PID Surcharges Totals: .00 .00 ** (171,983.00) Budgeted (171,983.00) Remaining 0 % Used Account: 135-47000-000-000 Water 163 10/08/2018 UB 10/08/2018 WT Adjustment UB20181008-20181008 User: 369.17 369.17 UB 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (353,797.75) (353,428.58) UB _______________ Account: 135-47000-000-000 Water Totals: (353,428.58) (353,428.58) ** (6,599,484.00) Budgeted (6,246,055.42) Remaining 5 % Used Account: 135-47005-000-000 Sewer 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (257,430.59) (257,430.59) UB _______________ Account: 135-47005-000-000 Sewer Totals: (257,430.59) (257,430.59) ** (3,412,665.00) Budgeted (3,155,234.41) Remaining 8 % Used Account: 135-47025-000-000 Penalties 14 10/03/2018 UB 10/03/2018 Penalty removal UB20181003-20181003 User: 302.07 302.07 UB 36 10/09/2018 UB 10/09/2018 Penalty removal UB20181009-20181009 User: 31.91 333.98 UB 72 10/17/2018 UB 10/17/2018 Penalty removal UB20181017-20181017 User: 57.78 391.76 UB 95 10/23/2018 UB 10/23/2018 Penalties UB20181023-20181023 User: (10,527.78) (10,136.02) UB 138 10/30/2018 UB 10/30/2018 Penalty removal UB20181030-20181030 User: 199.12 (9,936.90) UB 142 10/30/2018 UB 10/30/2018 Penalty removal UB20181030-20181030 User: 18.33 (9,918.57) UB 153 10/31/2018 UB 10/31/2018 Penalty removal UB20181031-20181031 User: 42.49 (9,876.08) UB _______________ Account: 135-47025-000-000 Penalties Totals: (9,876.08) (9,876.08) ** (136,418.00) Budgeted (126,541.92) Remaining 7 % Used Account: 135-47030-000-000 Service Charges 35 10/09/2018 UB 10/09/2018 Disconnect Fees UB20181009-20181009 User: (1,500.00) (1,500.00) UB 36 10/09/2018 UB 10/09/2018 Penalty removal UB20181009-20181009 User: 150.00 (1,350.00) UB November 26, 2018 Regular Meeting Agenda Packet 50 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 79 10/12/2018 UB 10/12/2018 NSF check UB20181012-20181012 User: (25.00) (1,375.00) UB 123 10/22/2018 UB 10/22/2018 NSF check UB20181022-20181022 User: (25.00) (1,400.00) UB 94 10/23/2018 UB 10/23/2018 NSF check UB20181023-20181023 User: (25.00) (1,425.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,425.00) (1,425.00) ** (17,000.00) Budgeted (15,575.00) Remaining 8 % Used Account: 135-47035-000-000 Plumbing Inspections .00 .00 _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: .00 .00 ** (1,500.00) Budgeted (1,500.00) Remaining 0 % Used Account: 135-47045-000-000 Sewer Inspections .00 .00 _______________ Account: 135-47045-000-000 Sewer Inspections Totals: .00 .00 ** (4,500.00) Budgeted (4,500.00) Remaining 0 % Used Account: 135-47070-000-000 TCCC Effluent Charges 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (17.60) (17.60) UB _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: (17.60) (17.60) ** (60,000.00) Budgeted (59,982.40) Remaining 0 % Used Account: 135-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (746.77) (746.77) GL 165 10/31/2018 Bank Interest- October (7,924.27) (8,671.04) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (8,671.04) (8,671.04) ** (20,000.00) Budgeted (11,328.96) Remaining 43 % Used Account: 135-49016-000-000 Cell Tower Revenue 157 10/15/2018 Cell Tower Rev AT&T October (1,178.81) (1,178.81) GL 158 10/15/2018 Cell Tower Rev AT&T Oct Supp (326.67) (1,505.48) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,505.48) (1,505.48) ** (14,146.00) Budgeted (12,640.52) Remaining 11 % Used November 26, 2018 Regular Meeting Agenda Packet 51 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 10/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-49018-000-000 Building Rent Income 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (583.33) (583.33) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (583.33) ** (7,000.00) Budgeted (6,416.67) Remaining 8 % Used Account: 135-49026-000-000 Proceeds from Sale of Assets .00 .00 _______________ Account: 135-49026-000-000 Proceeds from Sale of Assets Totals: .00 .00 ** (10,000.00) Budgeted (10,000.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement .00 .00 _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: .00 .00 ** (18,522.00) Budgeted (18,522.00) Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 199 10/15/2018 Recycling of Scrap Metal Sell/recycle of scrap metal (196.65) (196.65) GL 164 10/31/2018 UB 10/31/2018 Billing UB20181031-20181031 User: (288.61) (485.26) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (485.26) (485.26) ** (7,000.00) Budgeted (6,514.74) Remaining 7 % Used Department Totals: ----------------------------------- (635,423.24) ** (635,423.24) Monthly Total (10,613,202.00) Budgeted (9,977,778.76) Remaining 6 % Used November 26, 2018 Regular Meeting Agenda Packet 52 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 11,027.60 11,027.60 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (11,027.60) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 11,027.60 11,027.60 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (11,027.60) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 11,413.57 11,413.57 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (37.62) 11,375.95 GL _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 11,375.95 11,375.95 ** 326,755.00 Budgeted 315,379.05 Remaining 3 % Used Account: 135-50010-010-000 Overtime 44 10/05/2018 MUD P/R 10/05/2018 Overtime 300.45 300.45 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Overtime (300.45) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Overtime 300.45 300.45 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (300.45) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 565.62 565.62 PR _______________ Account: 135-50010-010-000 Overtime Totals: 565.62 565.62 ** 20,000.00 Budgeted 19,434.38 Remaining 3 % Used Account: 135-50016-010-000 Longevity .00 .00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 .00 ** 3,620.00 Budgeted 3,620.00 Remaining 0 % Used Account: 135-50017-010-000 Certification 67 10/19/2018 MUD Payroll 10/19/2018 Certification 200.00 200.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 200.00 ** 4,800.00 Budgeted 4,600.00 Remaining 4 % Used Account: 135-50020-010-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,047.84 1,047.84 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,047.84) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,047.84 1,047.84 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,126.58 2,174.42 PR November 26, 2018 Regular Meeting Agenda Packet 53 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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-50020-010-000 Retirement Totals: 2,174.42 2,174.42 ** 33,304.00 Budgeted 31,129.58 Remaining 7 % Used Account: 135-50026-010-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 1,474.40 1,474.40 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (1,474.40) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 1,474.40 1,474.40 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 1,474.40 2,948.80 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 2,948.80 ** 74,818.00 Budgeted 71,869.20 Remaining 4 % Used Account: 135-50027-010-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 106.85 106.85 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (106.85) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 106.85 106.85 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 106.80 213.65 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 213.65 ** 4,317.00 Budgeted 4,103.35 Remaining 5 % Used Account: 135-50028-010-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 17.98 17.98 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (17.98) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 17.98 17.98 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 17.94 35.92 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 35.92 ** 701.00 Budgeted 665.08 Remaining 5 % Used Account: 135-50029-010-000 Life Insurance & Other 2 10/01/2018 October A/P 110.60 110.60 Humana Inc 4572 AP 4 10/01/2018 October A/P 87.01 197.61 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 197.61 197.61 ** 3,131.00 Budgeted 2,933.39 Remaining 6 % Used Account: 135-50030-010-000 Social Security Taxes November 26, 2018 Regular Meeting Agenda Packet 54 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 703.88 703.88 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (703.88) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 703.88 703.88 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (703.88) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 743.69 743.69 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (2.33) 741.36 GL _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 741.36 741.36 ** 22,021.00 Budgeted 21,279.64 Remaining 3 % Used Account: 135-50035-010-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 164.61 164.61 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (164.61) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 164.61 164.61 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (164.61) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 173.92 173.92 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (.55) 173.37 GL _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 173.37 173.37 ** 5,150.00 Budgeted 4,976.63 Remaining 3 % Used Account: 135-50040-010-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: .00 .00 ** 1,080.00 Budgeted 1,080.00 Remaining 0 % Used Account: 135-50045-010-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 930.94 930.94 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 930.94 ** 12,895.00 Budgeted 11,964.06 Remaining 7 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 200.00 Budgeted 200.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 55 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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-50070-010-000 Employee Relations .00 .00 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 20,000.00 Budgeted 20,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 96 10/23/2018 October A/P UFD check 372.00 372.00 SES Group, LLC 4689 AP 96 10/23/2018 October A/P Prts 162.00 534.00 Core & Main LP 4672 AP 96 10/23/2018 October A/P Parts 373.20 907.20 Core & Main LP 4672 AP 114 10/26/2018 October A/P Mater boxes 1,443.12 2,350.32 Core & Main LP 4672 AP 114 10/26/2018 October A/P Repair clamps 256.78 2,607.10 Core & Main LP 4672 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 USA BLUE BOOK 240.41 2,847.51 USA BLUE BOOK PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*MT4F74YJ0 162.26 3,009.77 AMAZON.COM*MT4F74YJ0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AQUA-METRIC SALES INC. 900.00 3,909.77 AQUA-METRIC SALES INC. PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 75.97 3,985.74 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 36.01 4,021.75 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 72.77 4,094.52 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 HOMEDEPOT.COM 58.92 4,153.44 HOMEDEPOT.COM PC 141 10/30/2018 October A/P De-clor tabs 277.94 4,431.38 Core & Main LP 4672 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 4,431.38 4,431.38 ** 100,000.00 Budgeted 95,568.62 Remaining 4 % 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 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TX.GOV SERVICEFEE- 2.00 2.00 TX.GOV SERVICEFEE- PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DENTON VEHREG 7.50 9.50 DENTON VEHREG PC November 26, 2018 Regular Meeting Agenda Packet 56 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ROANOKE AUTO SUPPLY LT 20.48 29.98 ROANOKE AUTO SUPPLY LT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ROANOKE AUTO SUPPLY LT 19.76 49.74 ROANOKE AUTO SUPPLY LT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 KWIK KAR LUBE & TUNE O 7.00 56.74 KWIK KAR LUBE & TUNE O PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 130.41 187.15 GIERISCH CARE 0050292 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DISCOUNT TIRE TXD 75 196.50 383.65 DISCOUNT TIRE TXD 75 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 DISCOUNT TIRE TXD 75 179.76 563.41 DISCOUNT TIRE TXD 75 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 91.91 655.32 GIERISCH CARE 0050292 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 GIERISCH CARE 0050292 68.14 723.46 GIERISCH CARE 0050292 PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 723.46 723.46 ** 5,000.00 Budgeted 4,276.54 Remaining 14 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-55120-010-000 Cleaning Services .00 .00 _______________ Account: 135-55120-010-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55135-010-000 Lab Analysis 217 10/31/2018 October A/P water samples 200.00 200.00 TARRANT CTY PUBLIC HEALTH LAB 4735 AP 217 10/31/2018 October A/P TCEQ samples 207.70 407.70 LOWER COLORADO RIVER AUTHORITY 4728 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 407.70 407.70 ** 6,500.00 Budgeted 6,092.30 Remaining 6 % Used Account: 135-60010-010-000 Communications/Mobiles 96 10/23/2018 October A/P Cell phones-October 370.98 370.98 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 370.98 370.98 ** 5,000.00 Budgeted 4,629.02 Remaining 7 % Used Account: 135-60020-010-000 Electricity November 26, 2018 Regular Meeting Agenda Packet 57 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/26/2018 October A/P Electricity-October 10,557.91 10,557.91 HUDSON ENERGY SERVICES, LLC 4680 AP 260 10/31/2018 October A/P Electricity 10/10-11/8 8,370.76 18,928.67 HUDSON ENERGY SERVICES, LLC 4751 AP _______________ Account: 135-60020-010-000 Electricity Totals: 18,928.67 18,928.67 ** 154,204.00 Budgeted 135,275.33 Remaining 12 % Used Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships .00 .00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60080-010-000 Schools & Training 121 10/26/2018 Pcards 09/27/18 - 10/26/18 NCTCOG RTC TRAINING (165.00) (165.00) NCTCOG RTC TRAINING PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 NCTCOG RTC TRAINING (165.00) (330.00) NCTCOG RTC TRAINING PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 PAYPAL *PROLINEPUBL 100.00 (230.00) PAYPAL *PROLINEPUBL PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 PAYPAL *TEXASWATERW 350.00 120.00 PAYPAL *TEXASWATERW PC _______________ Account: 135-60080-010-000 Schools & Training Totals: 120.00 120.00 ** 4,651.00 Budgeted 4,531.00 Remaining 3 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem .00 .00 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 .00 ** 2,345.00 Budgeted 2,345.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 58 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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 .00 .00 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 .00 ** 58,000.00 Budgeted 58,000.00 Remaining 0 % Used Account: 135-60150-010-000 Wholesale Water .00 .00 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 .00 ** 3,013,494.00 Budgeted 3,013,494.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance 217 10/31/2018 October A/P October mowing 750.00 750.00 WATTS ELLISON LLC 4741 AP 217 10/31/2018 October A/P October mowing 590.00 1,340.00 WATTS ELLISON LLC 4741 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 1,340.00 1,340.00 ** 14,750.00 Budgeted 13,410.00 Remaining 9 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S November 26, 2018 Regular Meeting Agenda Packet 59 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 160 10/31/2018 Texpool Transfers October 25,172.81 25,172.81 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,172.81 25,172.81 ** 585,209.00 Budgeted 560,036.19 Remaining 4 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 160 10/31/2018 Texpool Transfers October 4,600.00 4,600.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,600.00 4,600.00 ** 55,193.00 Budgeted 50,593.00 Remaining 8 % Used Account: 135-60334-010-000 Interfund Transfer Out .00 .00 _______________ Account: 135-60334-010-000 Interfund Transfer Out Totals: .00 .00 ** 200,000.00 Budgeted 200,000.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65005-010-000 Fuel & Lube 114 10/26/2018 October A/P Fuel-October 643.17 643.17 US Bank Voyager Fleet Systems 4693 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 643.17 643.17 ** 15,000.00 Budgeted 14,356.83 Remaining 4 % Used Account: 135-65010-010-000 Uniforms .00 .00 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 .00 ** 5,190.00 Budgeted 5,190.00 Remaining 0 % Used Account: 135-65030-010-000 Chemicals 96 10/23/2018 October A/P Chemicals 908.30 908.30 HACH COMPANY 4678 AP November 26, 2018 Regular Meeting Agenda Packet 60 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 114 10/26/2018 October A/P Chlorine 558.41 1,466.71 DPC INDUSTRIES, INC 4675 AP 141 10/30/2018 October A/P lab supplies 91.80 1,558.51 HACH COMPANY 4678 AP 217 10/31/2018 October A/P Testing supplies 1,165.60 2,724.11 HACH COMPANY 4718 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 2,724.11 2,724.11 ** 20,000.00 Budgeted 17,275.89 Remaining 14 % Used Account: 135-65035-010-000 Small Tools .00 .00 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-010-000 Safety Equipment .00 .00 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense .00 .00 _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 .00 ** 70,000.00 Budgeted 70,000.00 Remaining 0 % Used Account: 135-65053-010-000 Meter Change Out Program .00 .00 _______________ Account: 135-65053-010-000 Meter Change Out Program Totals: .00 .00 ** 87,000.00 Budgeted 87,000.00 Remaining 0 % Used Account: 135-69005-010-000 Capital Outlays 254 10/31/2018 October A/P 16" water line phase II 18,400.85 18,400.85 Halff Associates, INC 4750 AP 254 10/31/2018 October A/P 16" water line bond app fee 132.50 18,533.35 CP&Y/WALLACE GROUP, INC. 4747 AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 18,533.35 18,533.35 ** 453,000.00 Budgeted 434,466.65 Remaining 4 % Used November 26, 2018 Regular Meeting Agenda Packet 61 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 10/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-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 30,068.00 Budgeted 30,068.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 .00 ** 4,124.00 Budgeted 4,124.00 Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Town Elevated Tank 45,000.00 45,000.00 GL 117 10/01/2018 GASB 34 transfers FY 2019 Water Replacement 30,000.00 75,000.00 GL _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: 75,000.00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract .00 .00 _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: .00 .00 ** 120,000.00 Budgeted 120,000.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 62 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 10/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 254 10/31/2018 October A/P TCEQ samples 207.70 207.70 LOWER COLORADO RIVER AUTHORITY 4757 AP 217 10/31/2018 October A/P Water samples-PID 80.00 287.70 TARRANT CTY PUBLIC HEALTH LAB 4735 AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 287.70 287.70 ** 2,000.00 Budgeted 1,712.30 Remaining 14 % Used Department 10 Totals: ----------------------------------- 172,840.97 ** 172,840.97 Monthly Total 5,641,834.00 Budgeted 5,468,993.03 Remaining 3 % Used November 26, 2018 Regular Meeting Agenda Packet 63 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 12,608.29 12,608.29 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (12,608.29) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 12,608.29 12,608.29 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (12,608.29) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 13,158.97 13,158.97 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (121.85) 13,037.12 GL _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 13,037.12 13,037.12 ** 421,699.00 Budgeted 408,661.88 Remaining 3 % Used Account: 135-50010-020-000 Overtime 44 10/05/2018 MUD P/R 10/05/2018 Overtime 3,666.56 3,666.56 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Overtime (3,666.56) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Overtime 3,666.56 3,666.56 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (3,666.56) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 987.41 987.41 PR _______________ Account: 135-50010-020-000 Overtime Totals: 987.41 987.41 ** 30,000.00 Budgeted 29,012.59 Remaining 3 % Used Account: 135-50016-020-000 Longevity .00 .00 _______________ Account: 135-50016-020-000 Longevity Totals: .00 .00 ** 7,445.00 Budgeted 7,445.00 Remaining 0 % Used Account: 135-50017-020-000 Certification 67 10/19/2018 MUD Payroll 10/19/2018 Certification 700.00 700.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 700.00 ** 8,700.00 Budgeted 8,000.00 Remaining 8 % Used Account: 135-50020-020-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,505.42 1,505.42 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,505.42) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,505.42 1,505.42 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,373.30 2,878.72 PR November 26, 2018 Regular Meeting Agenda Packet 64 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-50020-020-000 Retirement Totals: 2,878.72 2,878.72 ** 43,276.00 Budgeted 40,397.28 Remaining 7 % Used Account: 135-50026-020-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 2,607.69 2,607.69 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (2,607.69) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 2,607.69 2,607.69 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 2,902.55 5,510.24 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,510.24 5,510.24 ** 91,627.00 Budgeted 86,116.76 Remaining 6 % Used Account: 135-50027-020-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 185.96 185.96 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (185.96) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 185.96 185.96 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 185.93 371.89 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 371.89 ** 5,104.00 Budgeted 4,732.11 Remaining 7 % Used Account: 135-50028-020-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 29.46 29.46 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (29.46) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 29.46 29.46 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 29.44 58.90 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 58.90 ** 826.00 Budgeted 767.10 Remaining 7 % Used Account: 135-50029-020-000 Life Insurance & Other 2 10/01/2018 October A/P 164.36 164.36 Humana Inc 4572 AP 4 10/01/2018 October A/P 120.84 285.20 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 285.20 285.20 ** 4,495.00 Budgeted 4,209.80 Remaining 6 % Used Account: 135-50030-020-000 Social Security Taxes November 26, 2018 Regular Meeting Agenda Packet 65 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 948.39 948.39 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (948.39) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 948.39 948.39 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (948.39) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 828.40 828.40 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (7.16) 821.24 GL _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 821.24 821.24 ** 29,006.00 Budgeted 28,184.76 Remaining 3 % Used Account: 135-50035-020-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 221.81 221.81 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (221.81) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 221.81 221.81 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (221.81) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 193.74 193.74 PR 145 10/19/2018 Reverse 2 Accured FY18 Payroll (1.67) 192.07 GL _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 192.07 192.07 ** 6,784.00 Budgeted 6,591.93 Remaining 3 % Used Account: 135-50040-020-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-020-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 1,205.73 1,205.73 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 1,205.73 ** 16,941.00 Budgeted 15,735.27 Remaining 7 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 66 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-50070-020-000 Employee Relations .00 .00 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 .00 ** 300.00 Budgeted 300.00 Remaining 0 % Used Account: 135-55005-020-000 Engineering .00 .00 _______________ Account: 135-55005-020-000 Engineering Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-55070-020-000 Independent Labor .00 .00 _______________ Account: 135-55070-020-000 Independent Labor Totals: .00 .00 ** 15,000.00 Budgeted 15,000.00 Remaining 0 % Used Account: 135-55080-020-000 Maintenance & Repairs 121 10/26/2018 Pcards 09/27/18 - 10/26/18 MICHAELS KEYS 19.90 19.90 MICHAELS KEYS PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 15.38 35.28 THE HOME DEPOT #6581 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 FILTER ELEMENT STORE 184.93 220.21 FILTER ELEMENT STORE PC 217 10/31/2018 October A/P repairs 360.00 580.21 DHS AUTOMATION, INC 4717 AP 217 10/31/2018 October A/P repairs 360.00 940.21 DHS AUTOMATION, INC 4717 AP 217 10/31/2018 October A/P Lift Station #3 pump parts 2,370.00 3,310.21 SMITH PUMP COMPANY, INC. 4734 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 3,310.21 3,310.21 ** 88,000.00 Budgeted 84,689.79 Remaining 4 % Used Account: 135-55085-020-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-020-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55090-020-000 Vehicle Maintenance 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AUTOZONE #4206 25.00 25.00 AUTOZONE #4206 PC 217 10/31/2018 October A/P wiper blades 21.48 46.48 NAPA AUTO PARTS 4730 AP November 26, 2018 Regular Meeting Agenda Packet 67 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-55090-020-000 Vehicle Maintenance Totals: 46.48 46.48 ** 8,000.00 Budgeted 7,953.52 Remaining 1 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55120-020-000 Cleaning Services .00 .00 _______________ Account: 135-55120-020-000 Cleaning Services Totals: .00 .00 ** 5,214.00 Budgeted 5,214.00 Remaining 0 % Used Account: 135-55125-020-000 Dumpster Services 96 10/23/2018 October A/P Dumpster Service 992.03 992.03 L.H. CHANEY MATERIALS, INC. 4684 AP 217 10/31/2018 October A/P Sludge haul off 967.10 1,959.13 L.H. CHANEY MATERIALS, INC. 4726 AP 217 10/31/2018 October A/P sludge haul off 2,535.85 4,494.98 L.H. CHANEY MATERIALS, INC. 4726 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 4,494.98 4,494.98 ** 75,000.00 Budgeted 70,505.02 Remaining 6 % Used Account: 135-55135-020-000 Lab Analysis 96 10/23/2018 October A/P Effluent sampling 246.00 246.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P Effluent sampling 176.00 422.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P Lab testing 246.00 668.00 OXIDOR LABORATORIES LLC 4688 AP 96 10/23/2018 October A/P lab testing 176.00 844.00 OXIDOR LABORATORIES LLC 4688 AP 114 10/26/2018 October A/P 176.00 1,020.00 OXIDOR LABORATORIES LLC 4688 AP 114 10/26/2018 October A/P Lab analysis 246.00 1,266.00 OXIDOR LABORATORIES LLC 4688 AP 141 10/30/2018 October A/P lab testing 226.00 1,492.00 OXIDOR LABORATORIES LLC 4688 AP 141 10/30/2018 October A/P lab testing 176.00 1,668.00 OXIDOR LABORATORIES LLC 4688 AP 217 10/31/2018 October A/P effluent testing 226.00 1,894.00 OXIDOR LABORATORIES LLC 4732 AP 217 10/31/2018 October A/P effluent testing 176.00 2,070.00 OXIDOR LABORATORIES LLC 4732 AP 217 10/31/2018 October A/P Lab supplies 1,477.46 3,547.46 IDEXX DISTRIBUTION, INC 4721 AP 217 10/31/2018 October A/P Lab testing 1,080.00 4,627.46 HUTHER AND ASSOCIATES,INC 4720 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 4,627.46 4,627.46 ** 35,000.00 Budgeted 30,372.54 Remaining 13 % Used November 26, 2018 Regular Meeting Agenda Packet 68 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-60010-020-000 Communications/Mobiles 96 10/23/2018 October A/P Cell phones-October 382.49 382.49 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 382.49 382.49 ** 5,000.00 Budgeted 4,617.51 Remaining 8 % Used Account: 135-60020-020-000 Electricity 114 10/26/2018 October A/P Electricity-October 12,030.59 12,030.59 HUDSON ENERGY SERVICES, LLC 4680 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 193.33 12,223.92 TRI COUNTY ELECTRIC 4768 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 274.11 12,498.03 TRI COUNTY ELECTRIC 4768 AP 254 10/31/2018 October A/P Electricity 9/25-10/23 27.62 12,525.65 TRI COUNTY ELECTRIC 4768 AP 260 10/31/2018 October A/P Electricity 10/10-11/8 12,597.79 25,123.44 HUDSON ENERGY SERVICES, LLC 4751 AP 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (205.68) 24,917.76 AR _______________ Account: 135-60020-020-000 Electricity Totals: 24,917.76 24,917.76 ** 174,165.00 Budgeted 149,247.24 Remaining 14 % 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 Account: 135-60070-020-000 Dues & Memberships 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TX DPS DL OFFICE 69.00 69.00 TX DPS DL OFFICE PC _______________ Account: 135-60070-020-000 Dues & Memberships Totals: 69.00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Account: 135-60080-020-000 Schools & Training 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TCEQ IND RENEWAL L 111.00 111.00 TCEQ IND RENEWAL L PC _______________ Account: 135-60080-020-000 Schools & Training Totals: 111.00 111.00 ** 7,155.00 Budgeted 7,044.00 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 November 26, 2018 Regular Meeting Agenda Packet 69 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-60090-020-000 Safety Program Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem .00 .00 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 .00 ** 1,895.00 Budgeted 1,895.00 Remaining 0 % 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 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 114 10/26/2018 October A/P WWTP permit fees 9,888.02 9,888.02 TX COMMISSION ENVIRONMENTAL QU 4692 AP 254 10/31/2018 October A/P Well water 6,457.20 16,345.22 North Texas Groundwater 4761 AP _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: 16,345.22 16,345.22 ** 30,000.00 Budgeted 13,654.78 Remaining 54 % Used Account: 135-60245-020-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 .00 ** 450.00 Budgeted 450.00 Remaining 0 % Used Account: 135-60280-020-000 Property Maintenance 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 6.98 6.98 TRACTOR SUPPLY COMPANY PC November 26, 2018 Regular Meeting Agenda Packet 70 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-60280-020-000 Property Maintenance Totals: 6.98 6.98 ** 5,000.00 Budgeted 4,993.02 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 11,600.00 Budgeted 11,600.00 Remaining 0 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S 160 10/31/2018 Texpool Transfers October 10,913.90 10,913.90 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,913.90 10,913.90 ** 120,053.00 Budgeted 109,139.10 Remaining 9 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 160 10/31/2018 Texpool Transfers October 54,203.45 54,203.45 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,203.45 54,203.45 ** 688,330.00 Budgeted 634,126.55 Remaining 8 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 160 10/31/2018 Texpool Transfers October 10,432.00 10,432.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,432.00 10,432.00 ** 125,187.00 Budgeted 114,755.00 Remaining 8 % Used Account: 135-60334-020-000 Interfund Transfer Out 160 10/31/2018 Texpool Transfers October 122,777.00 122,777.00 GL _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: 122,777.00 122,777.00 ** 200,000.00 Budgeted 77,223.00 Remaining 61 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 November 26, 2018 Regular Meeting Agenda Packet 71 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-60360-020-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65005-020-000 Fuel & Lube 114 10/26/2018 October A/P Fuel-October 1,307.59 1,307.59 US Bank Voyager Fleet Systems 4693 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 OREILLY AUTO # 5521 28.99 1,336.58 OREILLY AUTO # 5521 PC _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,336.58 1,336.58 ** 12,500.00 Budgeted 11,163.42 Remaining 11 % Used Account: 135-65010-020-000 Uniforms 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 174.99 174.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 175.00 349.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 175.00 524.99 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 19.99 544.98 TRACTOR SUPPLY COMPANY PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*M89H74F10 158.46 703.44 AMAZON.COM*M89H74F10 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RED WING SHOES #652 161.99 865.43 RED WING SHOES #652 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 TRACTOR SUPPLY COMPANY 169.98 1,035.41 TRACTOR SUPPLY COMPANY PC _______________ Account: 135-65010-020-000 Uniforms Totals: 1,035.41 1,035.41 ** 5,495.00 Budgeted 4,459.59 Remaining 19 % Used Account: 135-65030-020-000 Chemicals 217 10/31/2018 October A/P MBR cleaning solution 536.00 536.00 Valley Solvent Company, INC 4740 AP _______________ Account: 135-65030-020-000 Chemicals Totals: 536.00 536.00 ** 30,000.00 Budgeted 29,464.00 Remaining 2 % Used Account: 135-65035-020-000 Small Tools .00 .00 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 .00 ** 1,200.00 Budgeted 1,200.00 Remaining 0 % Used Account: 135-65040-020-000 Safety Equipment 121 10/26/2018 Pcards 09/27/18 - 10/26/18 THE HOME DEPOT #6581 8.49 8.49 THE HOME DEPOT #6581 PC 217 10/31/2018 October A/P gloves 172.83 181.32 HD SUPPLY FACILITIES MAINT LTD 4719 AP November 26, 2018 Regular Meeting Agenda Packet 72 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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-65040-020-000 Safety Equipment Totals: 181.32 181.32 ** 1,200.00 Budgeted 1,018.68 Remaining 15 % Used Account: 135-65045-020-000 Lab Supplies 42 10/10/2018 October A/P gloves 152.00 152.00 LOU'S GLOVES INCORPORATED 4654 AP 96 10/23/2018 October A/P Lab supplies 131.09 283.09 HACH COMPANY 4678 AP 141 10/30/2018 October A/P lab supplies 449.98 733.07 HACH COMPANY 4678 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 733.07 733.07 ** 20,000.00 Budgeted 19,266.93 Remaining 4 % Used Account: 135-69005-020-000 Capital Outlays 254 10/31/2018 October A/P WWTP legal 1,615.00 1,615.00 Dubois Bryant Campbell LLP 4749 AP 254 10/31/2018 October A/P LS #1 easement survey 974.58 2,589.58 CP&Y/WALLACE GROUP, INC. 4747 AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 2,589.58 2,589.58 ** 330,000.00 Budgeted 327,410.42 Remaining 1 % Used Account: 135-69008-020-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-020-000 Short Term Debt-Principal Totals: .00 .00 ** 109,858.00 Budgeted 109,858.00 Remaining 0 % Used Account: 135-69009-020-000 Short Term Debt-Interest .00 .00 _______________ Account: 135-69009-020-000 Short Term Debt-Interest Totals: .00 .00 ** 14,917.00 Budgeted 14,917.00 Remaining 0 % Used Account: 135-69195-020-000 Gasb34/Reserve for Replacement 117 10/01/2018 GASB 34 transfers FY 2019 Sewer Replacement 30,000.00 30,000.00 GL _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: 30,000.00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used November 26, 2018 Regular Meeting Agenda Packet 73 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 10/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: ----------------------------------- 315,098.41 ** 315,098.41 Monthly Total 2,872,082.00 Budgeted 2,556,983.59 Remaining 11 % Used November 26, 2018 Regular Meeting Agenda Packet 74 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/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 125 10/01/2018 Insurance/Wrk Comp Expense Oct 2.12 2.12 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.12 2.12 ** 30.00 Budgeted 27.88 Remaining 7 % 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 .00 .00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 .00 ** 750.00 Budgeted 750.00 Remaining 0 % Used Account: 135-60075-026-000 Meetings .00 .00 _______________ Account: 135-60075-026-000 Meetings Totals: .00 .00 ** 1,300.00 Budgeted 1,300.00 Remaining 0 % Used Account: 135-60080-026-000 Schools & Training 3 10/01/2018 Ocotber A/P 295.00 295.00 AWBD 4557 AP _______________ Account: 135-60080-026-000 Schools & Training Totals: 295.00 295.00 ** 4,000.00 Budgeted 3,705.00 Remaining 7 % Used Account: 135-60100-026-000 Travel & per diem .00 .00 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses November 26, 2018 Regular Meeting Agenda Packet 75 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Department 26 Totals: ----------------------------------- 297.12 ** 297.12 Monthly Total 13,230.00 Budgeted 12,932.88 Remaining 2 % Used November 26, 2018 Regular Meeting Agenda Packet 76 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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 44 10/05/2018 MUD P/R 10/05/2018 Salaries & Wages 14,704.88 14,704.88 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Salaries & Wages (14,704.88) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Salaries & Wages 14,704.88 14,704.88 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (14,704.88) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Salaries & Wages 13,370.27 13,370.27 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 13,370.27 13,370.27 ** 441,006.00 Budgeted 427,635.73 Remaining 3 % Used Account: 135-50010-030-000 Overtime 67 10/19/2018 MUD Payroll 10/19/2018 Overtime 3.16 3.16 PR _______________ Account: 135-50010-030-000 Overtime Totals: 3.16 3.16 ** 2,000.00 Budgeted 1,996.84 Remaining 0 % Used Account: 135-50016-030-000 Longevity .00 .00 _______________ Account: 135-50016-030-000 Longevity Totals: .00 .00 ** 1,833.00 Budgeted 1,833.00 Remaining 0 % Used Account: 135-50020-030-000 Retirement 44 10/05/2018 MUD P/R 10/05/2018 Retirement 1,360.21 1,360.21 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Retirement (1,360.21) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Retirement 1,360.21 1,360.21 PR 67 10/19/2018 MUD Payroll 10/19/2018 Retirement 1,237.04 2,597.25 PR _______________ Account: 135-50020-030-000 Retirement Totals: 2,597.25 2,597.25 ** 41,148.00 Budgeted 38,550.75 Remaining 6 % Used Account: 135-50026-030-000 Medical Insurance 44 10/05/2018 MUD P/R 10/05/2018 Medical Insurance 2,072.63 2,072.63 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medical Insurance (2,072.63) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medical Insurance 2,072.63 2,072.63 PR 67 10/19/2018 MUD Payroll 10/19/2018 Medical Insurance 2,072.61 4,145.24 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 4,145.24 ** 81,895.00 Budgeted 77,749.76 Remaining 5 % Used November 26, 2018 Regular Meeting Agenda Packet 77 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-030-000 Dental Insurance 44 10/05/2018 MUD P/R 10/05/2018 Dental Insurance 129.78 129.78 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Dental Insurance (129.78) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Dental Insurance 129.78 129.78 PR 67 10/19/2018 MUD Payroll 10/19/2018 Dental Insurance 129.74 259.52 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 259.52 ** 4,291.00 Budgeted 4,031.48 Remaining 6 % Used Account: 135-50028-030-000 Vision Insurance 44 10/05/2018 MUD P/R 10/05/2018 Vision Insurance 21.28 21.28 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Vision Insurance (21.28) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Vision Insurance 21.28 21.28 PR 67 10/19/2018 MUD Payroll 10/19/2018 Vision Insurance 21.23 42.51 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 42.51 ** 701.00 Budgeted 658.49 Remaining 6 % Used Account: 135-50029-030-000 Life Insurance & Other 2 10/01/2018 October A/P 145.04 145.04 Humana Inc 4572 AP 4 10/01/2018 October A/P 119.45 264.49 METLIFE GROUP BENEFITS 4601 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 264.49 264.49 ** 4,495.00 Budgeted 4,230.51 Remaining 6 % Used Account: 135-50030-030-000 Social Security Taxes 44 10/05/2018 MUD P/R 10/05/2018 Social Security Taxes 873.68 873.68 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Social Security Taxes (873.68) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Social Security Taxes 873.68 873.68 PR 144 10/05/2018 Reverse 1 Accured FY18 Payroll (873.68) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Social Security Taxes 788.49 788.49 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 788.49 788.49 ** 27,580.00 Budgeted 26,791.51 Remaining 3 % Used Account: 135-50035-030-000 Medicare Taxes 44 10/05/2018 MUD P/R 10/05/2018 Medicare Taxes 204.33 204.33 GL 242 10/05/2018 REV MUD P/R 10.05.18 JE# 10 Medicare Taxes (204.33) .00 GL 10 10/05/2018 MUD P/R 10.05.18 Medicare Taxes 204.33 204.33 PR November 26, 2018 Regular Meeting Agenda Packet 78 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 144 10/05/2018 Reverse 1 Accured FY18 Payroll (204.33) .00 GL 67 10/19/2018 MUD Payroll 10/19/2018 Medicare Taxes 184.40 184.40 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 184.40 184.40 ** 6,450.00 Budgeted 6,265.60 Remaining 3 % Used Account: 135-50040-030-000 Unemployment Taxes .00 .00 _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: .00 .00 ** 1,260.00 Budgeted 1,260.00 Remaining 0 % Used Account: 135-50045-030-000 Workman's Compensation 125 10/01/2018 Insurance/Wrk Comp Expense Oct 106.55 106.55 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 106.55 106.55 ** 1,295.00 Budgeted 1,188.45 Remaining 8 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing .00 .00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-50070-030-000 Employee Relations .00 .00 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 .00 ** 5,000.00 Budgeted 5,000.00 Remaining 0 % Used Account: 135-55030-030-000 Software & Support 2 10/01/2018 October A/P 59,205.00 59,205.00 M3 Networks 4581 AP 21 10/05/2018 October A/P Internet-October 903.72 60,108.72 Charter Communications 4629 AP 96 10/23/2018 October A/P Microsoft Exchange 456.00 60,564.72 M3 Networks 4685 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 107.79 60,672.51 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 192.67 60,865.18 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 124.34 60,989.52 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 69.12 61,058.64 ATT*BILL PAYMENT PC November 26, 2018 Regular Meeting Agenda Packet 79 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ADOBE INC 32.45 61,091.09 ADOBE INC PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 RINGCENTRAL, INC 12.99 61,104.08 RINGCENTRAL, INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 61,104.08 61,104.08 ** 77,849.00 Budgeted 16,744.92 Remaining 78 % Used Account: 135-55070-030-000 Independent Labor 264 10/31/2018 October A/P Audit consulting 98.33 98.33 DOROTHY RENAE GONZALES 4771 AP 217 10/31/2018 October A/P Backflow renewal 2019 595.00 693.33 SC TRACKING SOLUTIONS LLC 4733 AP 217 10/31/2018 October A/P GM-October 12.81 706.14 Carman Consulting LLC. 4712 AP 217 10/31/2018 October A/P GM-October 10,960.00 11,666.14 Carman Consulting LLC. 4712 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,666.14 11,666.14 ** 175,000.00 Budgeted 163,333.86 Remaining 7 % Used Account: 135-55080-030-000 Maintenance & Repairs 96 10/23/2018 October A/P Roof repair MUD building 315.00 315.00 TK CONTRACTORS LLC 4691 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 315.00 315.00 ** 20,000.00 Budgeted 19,685.00 Remaining 2 % Used Account: 135-55085-030-000 Generator Maint. and Repair .00 .00 _______________ Account: 135-55085-030-000 Generator Maint. and Repair Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55120-030-000 Cleaning Services .00 .00 _______________ Account: 135-55120-030-000 Cleaning Services Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-55160-030-000 Professional Outside Services .00 .00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 .00 ** 66,055.00 Budgeted 66,055.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 80 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-55205-030-000 Utility Billing Contract 217 10/31/2018 October A/P Billings-Oct 579.29 579.29 DATAPROSE LLC 4716 AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 579.29 579.29 ** 9,000.00 Budgeted 8,420.71 Remaining 6 % Used Account: 135-60005-030-000 Telephone 21 10/05/2018 October A/P Answering svc-October 194.75 194.75 KEYSTONE PARK SECRETARIAL 4640 AP 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BUS PHONE PMT 461.83 656.58 ATT*BUS PHONE PMT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BILL PAYMENT 85.71 742.29 ATT*BILL PAYMENT PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 ATT*BUS PHONE PMT 860.79 1,603.08 ATT*BUS PHONE PMT PC 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (180.00) 1,423.08 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,423.08 1,423.08 ** 23,500.00 Budgeted 22,076.92 Remaining 6 % Used Account: 135-60010-030-000 Communications/Mobiles 67 10/19/2018 MUD Payroll 10/19/2018 Communications/Mobiles 150.00 150.00 PR 96 10/23/2018 October A/P Cell phones-October 87.49 237.49 VERIZON WIRELESS 4694 AP _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.49 237.49 ** 4,000.00 Budgeted 3,762.51 Remaining 6 % Used Account: 135-60020-030-000 Electricity/Gas 217 10/31/2018 October A/P Electricity admin 8/10-9/11 557.71 557.71 TOWN OF TROPHY CLUB 4738 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 557.71 557.71 ** 8,690.00 Budgeted 8,132.29 Remaining 6 % Used Account: 135-60025-030-000 Water 203 10/31/2018 Town Billed Invoices 1660-1663 AR 20181031-20181031 User: (58.32) (58.32) AR 217 10/31/2018 October A/P Water-October 106.71 48.39 TROPHY CLUB MUD (WATER BILLS) 4739 AP _______________ Account: 135-60025-030-000 Water Totals: 48.39 48.39 ** 2,000.00 Budgeted 1,951.61 Remaining 2 % Used Account: 135-60035-030-000 Postage 96 10/23/2018 October A/P overnight-TCEQ 20.25 20.25 FEDERAL EXPRESS CORP 4676 AP November 26, 2018 Regular Meeting Agenda Packet 81 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 141 10/30/2018 October A/P Postage lease 97.65 117.90 FRANCOTYP-POSTALIA, INC. 4677 AP 217 10/31/2018 October A/P Billings-Oct 1,609.54 1,727.44 DATAPROSE LLC 4716 AP _______________ Account: 135-60035-030-000 Postage Totals: 1,727.44 1,727.44 ** 30,000.00 Budgeted 28,272.56 Remaining 6 % Used Account: 135-60040-030-000 Service Charges & Fees 15 10/05/2018 Child Support Fee 1.50 1.50 GL 68 10/19/2018 Child Support Fee 1.50 3.00 GL 155 10/31/2018 Pace Credit Card Fees 6,276.89 6,279.89 GL 155 10/31/2018 Pace Credit Card Fees 157.68 6,437.57 GL 217 10/31/2018 October A/P Dig Tess-September 208.05 6,645.62 Texas Excavation Safety System 4737 AP 217 10/31/2018 October A/P Dig Tess-October 253.65 6,899.27 Texas Excavation Safety System 4737 AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 6,899.27 6,899.27 ** 55,560.00 Budgeted 48,660.73 Remaining 12 % 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 125 10/01/2018 Insurance/Wrk Comp Expense Oct 6,302.73 6,302.73 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,302.73 6,302.73 ** 65,000.00 Budgeted 58,697.27 Remaining 10 % Used Account: 135-60066-030-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-60070-030-000 Dues & Memberships 2 10/01/2018 October A/P 100.00 100.00 TX COMPTROLLER 4593 AP 260 10/31/2018 October A/P 100.00 200.00 NORTH CENTRAL TX COG 4762 AP November 26, 2018 Regular Meeting Agenda Packet 82 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-030-000 Dues & Memberships Totals: 200.00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 _______________ Account: 135-60075-030-000 Meetings Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % 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 .00 .00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 .00 ** 8,950.00 Budgeted 8,950.00 Remaining 0 % Used Account: 135-60100-030-000 Travel & per diem .00 .00 _______________ Account: 135-60100-030-000 Travel & per diem Totals: .00 .00 ** 4,345.00 Budgeted 4,345.00 Remaining 0 % 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-60125-030-000 Advertising .00 .00 November 26, 2018 Regular Meeting Agenda Packet 83 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-60125-030-000 Advertising Totals: .00 .00 ** 25,000.00 Budgeted 25,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security 96 10/23/2018 October A/P Monitoring service 24.00 24.00 Digital Air Control, Inc 4674 AP _______________ Account: 135-60235-030-000 Security Totals: 24.00 24.00 ** 1,288.00 Budgeted 1,264.00 Remaining 2 % Used Account: 135-60245-030-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60246-030-000 General Manager Contingency .00 .00 _______________ Account: 135-60246-030-000 General Manager Contingency Totals: .00 .00 ** 17,000.00 Budgeted 17,000.00 Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 .00 .00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used Account: 135-65010-030-000 Uniforms .00 .00 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 .00 ** 2,050.00 Budgeted 2,050.00 Remaining 0 % Used Account: 135-65055-030-000 Hardware .00 .00 November 26, 2018 Regular Meeting Agenda Packet 84 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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-65055-030-000 Hardware Totals: .00 .00 ** 7,064.00 Budgeted 7,064.00 Remaining 0 % Used Account: 135-65085-030-000 Office Supplies 42 10/10/2018 October A/P Postage machine ink 107.95 107.95 ASI BUSINESS SOLUTIONS LTD 4653 AP 96 10/23/2018 October A/P Office supplies-Water and WW 168.04 275.99 OFFICE DEPOT, INC 4687 AP 141 10/30/2018 October A/P Office supplies 53.20 329.19 OFFICE DEPOT, INC 4687 AP 141 10/30/2018 October A/P office supplies 11.99 341.18 OFFICE DEPOT, INC 4687 AP 254 10/31/2018 October A/P office supplies 73.38 414.56 OFFICE DEPOT, INC 4763 AP 217 10/31/2018 October A/P office supplies 59.50 474.06 OFFICE DEPOT, INC 4731 AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 474.06 474.06 ** 6,000.00 Budgeted 5,525.94 Remaining 8 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance .00 .00 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 .00 ** 3,500.00 Budgeted 3,500.00 Remaining 0 % Used Account: 135-65095-030-000 Maintenance Supplies 121 10/26/2018 Pcards 09/27/18 - 10/26/18 SAMSCLUB.COM 237.19 237.19 SAMSCLUB.COM PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 SAMSCLUB #4795 18.06 255.25 SAMSCLUB #4795 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 WALMART GROCERY 33.14 288.39 WALMART GROCERY PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 WAL-MART #0266 6.52 294.91 WAL-MART #0266 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMAZON.COM*MT7S82UA0 36.97 331.88 AMAZON.COM*MT7S82UA0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMZN MKTP US*MT70T19T0 80.99 412.87 AMZN MKTP US*MT70T19T0 PC 121 10/26/2018 Pcards 09/27/18 - 10/26/18 AMZN MKTP US*MT1CJ58C2 31.17 444.04 AMZN MKTP US*MT1CJ58C2 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 444.04 444.04 ** 4,000.00 Budgeted 3,555.96 Remaining 11 % Used Account: 135-65105-030-000 Printing .00 .00 _______________ Account: 135-65105-030-000 Printing Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 85 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 10/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 .00 .00 _______________ Account: 135-69005-030-000 Capital Outlays Totals: .00 .00 ** 280,000.00 Budgeted 280,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 114 10/26/2018 October A/P Copies 99.89 99.89 KYOCERA DOCUMENT SOLUTIONS 4683 AP 254 10/31/2018 October A/P Copier lease-OCt 194.00 293.89 TIAA COMMERCIAL FINANCE 4766 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 293.89 293.89 ** 4,000.00 Budgeted 3,706.11 Remaining 7 % Used Department 30 Totals: ----------------------------------- 114,058.49 ** 114,058.49 Monthly Total 1,559,905.00 Budgeted 1,445,846.51 Remaining 7 % Used November 26, 2018 Regular Meeting Agenda Packet 86 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 10/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 260 10/31/2018 October A/P Legal-Westlake easement 7,954.68 7,954.68 WHITAKER CHALK SWINDLE 4770 AP 260 10/31/2018 October A/P Legal 2,760.00 10,714.68 McLean & Howard, L.L.P. 4759 AP 260 10/31/2018 October A/P Legal 1,125.00 11,839.68 McLean & Howard, L.L.P. 4759 AP _______________ Account: 135-55045-039-000 Legal Totals: 11,839.68 11,839.68 ** 137,000.00 Budgeted 125,160.32 Remaining 9 % Used Account: 135-55055-039-000 Auditing 115 10/01/2018 Reverse PPD Audit Retainer 5,000.00 5,000.00 GL _______________ Account: 135-55055-039-000 Auditing Totals: 5,000.00 5,000.00 ** 30,800.00 Budgeted 25,800.00 Remaining 16 % Used Account: 135-55060-039-000 Appraisal .00 .00 _______________ Account: 135-55060-039-000 Appraisal Totals: .00 .00 ** 11,714.00 Budgeted 11,714.00 Remaining 0 % Used Account: 135-55065-039-000 Tax Admin Fees .00 .00 _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: .00 .00 ** 4,800.00 Budgeted 4,800.00 Remaining 0 % Used Department 39 Totals: ----------------------------------- 16,839.68 ** 16,839.68 Monthly Total 184,314.00 Budgeted 167,474.32 Remaining 9 % Used Fund 135 Totals: ----------------------------------- (16,288.57) (16,288.57) Monthly Total (341,837.00) Budgeted (325,548.43) Remaining 5 % Used November 26, 2018 Regular Meeting Agenda Packet 87 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 10/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 117 10/01/2018 GASB 34 transfers FY 2019 Town Elevated Tank (45,000.00) (45,000.00) GL 117 10/01/2018 GASB 34 transfers FY 2019 Water Replacement (30,000.00) (75,000.00) GL 117 10/01/2018 GASB 34 transfers FY 2019 Sewer Replacement (30,000.00) (105,000.00) GL _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: (105,000.00) (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept 117 10/01/2018 GASB 34 transfers FY 2019 Fire Truck Future Replacement (81,420.00) (81,420.00) GL _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: (81,420.00) (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** (186,420.00) Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) (186,420.00) Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 88 of 136 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET OCTOBER 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK 7 INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS 7 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 727,624 TOTAL LIABILITIES 727,624 FUND BALANCE ASSIGNED FUND BALANCE (807,739) NET REVENUES / EXPENDITURES 80,122 TOTAL FUND BALANCE (727,617) TOTAL LIABILITIES AND FUND BALANCE 7 November 26, 2018 Regular Meeting Agenda Packet 89 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-49010-000-000 Interest Income 7.29- 7.29- 7.29 Subtotal: 7.29- 7.29- 7.29 Program number: 7.29- 7.29- 7.29 Department number: Revenues 7.29- 7.29- 7.29 November 26, 2018 Regular Meeting Agenda Packet 90 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/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 122,777.00- 122,777.00- 122,777.00 Subtotal: 122,777.00- 122,777.00- 122,777.00 Program number: 122,777.00- 122,777.00- 122,777.00 Department number: Wastewater 122,777.00- 122,777.00- 122,777.00 Revenues Subtotal ----------- 122,784.29- 122,784.29- 122,784.29 November 26, 2018 Regular Meeting Agenda Packet 91 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 11:31 11/19/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 42,662.50 42,662.50 42,662.50- Subtotal: 42,662.50 42,662.50 42,662.50- Program number: 42,662.50 42,662.50 42,662.50- Department number: Wastewater 42,662.50 42,662.50 42,662.50- Expenditures Subtotal ----------- 42,662.50 42,662.50 42,662.50- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 80,121.79- 80,121.79- 80,121.79 November 26, 2018 Regular Meeting Agenda Packet 92 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 10/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 165 10/31/2018 Bank Interest- October (7.29) (7.29) GL _______________ Account: 517-49010-000-000 Interest Income Totals: (7.29) (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used Department Totals: ----------------------------------- (7.29) ** (7.29) Monthly Total .00 Budgeted 7.29 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 93 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 10/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 160 10/31/2018 Texpool Transfers October (122,777.00) (122,777.00) GL _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: (122,777.00) (122,777.00) ** .00 Budgeted 122,777.00 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 254 10/31/2018 October A/P WWTP improvements 23,790.06 23,790.06 CP&Y/WALLACE GROUP, INC. 4747 AP 217 10/31/2018 October A/P WWTP Improvements 18,872.44 42,662.50 WEBBER-CADAGUA PARTNERS 4742 AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 42,662.50 42,662.50 ** .00 Budgeted (42,662.50) Remaining 0 % Used Department 20 Totals: ----------------------------------- (80,114.50) ** (80,114.50) Monthly Total .00 Budgeted 80,114.50 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (80,121.79) (80,121.79) Monthly Total .00 Budgeted 80,121.79 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 94 of 136 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET OCTOBER 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 754,200 NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE 754,200 TOTAL LIABILITIES AND FUND BALANCE 767,358 November 26, 2018 Regular Meeting Agenda Packet 95 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 11:31 11/19/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-49010-000-000 Interest Income 19,506.92- 19,506.92- 19,506.92 Subtotal: 19,506.92- 19,506.92- 19,506.92 Program number: 19,506.92- 19,506.92- 19,506.92 Department number: Revenues 19,506.92- 19,506.92- 19,506.92 Revenues Subtotal ----------- 19,506.92- 19,506.92- 19,506.92 November 26, 2018 Regular Meeting Agenda Packet 96 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 11:31 11/19/18 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 519-60334-010-000 Interfund Transfer Out 797,679.25 797,679.25 797,679.25- Subtotal: 797,679.25 797,679.25 797,679.25- 519-69005-010-000 Capital Outlays 2,693,208.68 2,693,208.68 2,693,208.68- Subtotal: 2,693,208.68 2,693,208.68 2,693,208.68- Program number: 3,490,887.93 3,490,887.93 3,490,887.93- Department number: Water 3,490,887.93 3,490,887.93 3,490,887.93- Expenditures Subtotal ----------- 3,490,887.93 3,490,887.93 3,490,887.93- Fund number: 519 2016 Rev Bond Const-SWIFT 3,471,381.01 3,471,381.01 3,471,381.01- November 26, 2018 Regular Meeting Agenda Packet 97 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: Revenues Program: Period Ending: 10/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 (19,506.92) .00 (19,506.92) _______________ Account: 519-49010-000-000 Interest Income Totals: .00 (19,506.92) ** .00 Budgeted 19,506.92 Remaining 0 % Used Department Totals: ----------------------------------- (19,506.92) ** .00 Monthly Total .00 Budgeted 19,506.92 Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 98 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 519 2016 Rev Bond Const-SWIFT Department: 10 Water Program: Period Ending: 10/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 797,679.25 .00 797,679.25 _______________ Account: 519-60334-010-000 Interfund Transfer Out Totals: .00 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 ** .00 Monthly Total .00 Budgeted (3,490,887.93) Remaining 0 % Used Fund 519 Totals: ----------------------------------- 3,471,381.01 .00 Monthly Total .00 Budgeted (3,471,381.01) Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 99 of 136 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET OCTOBER 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 411,246 TOTAL LIABILITIES 411,246 FUND BALANCE ASSIGNED FUND BALANCE (411,246) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (411,246) TOTAL LIABILITIES AND FUND BALANCE - November 26, 2018 Regular Meeting Agenda Packet 100 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 11:31 11/19/18 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-69005-010-000 Capital Outlays 371,346.11 371,346.11 371,346.11- Subtotal: 371,346.11 371,346.11 371,346.11- Program number: 371,346.11 371,346.11 371,346.11- Department number: Water Department 371,346.11 371,346.11 371,346.11- Expenditures Subtotal ----------- 371,346.11 371,346.11 371,346.11- Fund number: 520 Revenue Bond 16" Waterline 371,346.11 371,346.11 371,346.11- November 26, 2018 Regular Meeting Agenda Packet 101 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 520 Revenue Bond 16" Waterline Department: 10 Water Department Program: Period Ending: 10/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 371,346.11 .00 371,346.11 _______________ Account: 520-69005-010-000 Capital Outlays Totals: .00 371,346.11 ** .00 Budgeted (371,346.11) Remaining 0 % Used Department 10 Totals: ----------------------------------- 371,346.11 ** .00 Monthly Total .00 Budgeted (371,346.11) Remaining 0 % Used Fund 520 Totals: ----------------------------------- 371,346.11 .00 Monthly Total .00 Budgeted (371,346.11) Remaining 0 % Used November 26, 2018 Regular Meeting Agenda Packet 102 of 136 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 623,048 ACCOUNTS RECEIVABLE - TOTAL ASSETS 623,048 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 606,910 NET REVENUES / EXPENDITURES 16,138 TOTAL FUND BALANCE 623,048 TOTAL LIABILITIES AND FUND BALANCE 623,048 November 26, 2018 Regular Meeting Agenda Packet 103 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 11:31 11/19/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49010-000-000 Interest Income 5,000.00- 5,000.00- 1,105.95- 1,105.95- 22.119 3,894.05- 528-49142-000-000 Interfund transfer in-Water 55,193.00- 55,193.00- 4,600.00- 4,600.00- 8.334 50,593.00- 528-49143-000-000 Interfund transfer in-WW 125,187.00- 125,187.00- 10,432.00- 10,432.00- 8.333 114,755.00- Subtotal: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Program number: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Department number: 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Revenues Subtotal ----------- 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- Fund number: 528 2015 Revenue Bond Reserve Fund 185,380.00- 185,380.00- 16,137.95- 16,137.95- 8.705 169,242.05- November 26, 2018 Regular Meeting Agenda Packet 104 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 10/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 165 10/31/2018 Bank Interest- October (1,105.95) (1,105.95) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (1,105.95) (1,105.95) ** (5,000.00) Budgeted (3,894.05) Remaining 22 % Used Account: 528-49142-000-000 Interfund transfer in-Water 160 10/31/2018 Texpool Transfers October (4,600.00) (4,600.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,600.00) (4,600.00) ** (55,193.00) Budgeted (50,593.00) Remaining 8 % Used Account: 528-49143-000-000 Interfund transfer in-WW 160 10/31/2018 Texpool Transfers October (10,432.00) (10,432.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,432.00) (10,432.00) ** (125,187.00) Budgeted (114,755.00) Remaining 8 % Used Department Totals: ----------------------------------- (16,137.95) ** (16,137.95) Monthly Total (185,380.00) Budgeted (169,242.05) Remaining 9 % Used Fund 528 Totals: ----------------------------------- (16,137.95) (16,137.95) Monthly Total (185,380.00) Budgeted (169,242.05) Remaining 9 % Used November 26, 2018 Regular Meeting Agenda Packet 105 of 136 TROPHY CLUB MUD #1 - I&S BALANCE SHEET OCTOBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 70,534 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 687,582 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 762,689 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 687,582 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 687,582 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 21,818 TOTAL FUND BALANCE 75,107 TOTAL LIABILITIES AND FUND BALANCE 762,689 November 26, 2018 Regular Meeting Agenda Packet 106 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 11:31 11/19/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 687,175.00- 687,175.00- 10,618.40- 10,618.40- 1.545 676,556.60- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 172.84- 172.84- 9.602 1,627.16- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 21.61- 21.61- 1.081 1,978.39- Subtotal: 690,975.00- 690,975.00- 10,812.85- 10,812.85- 1.565 680,162.15- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 91.48- 91.48- 4.574 1,908.52- 533-49015-000-000 Lease/Rental Income 215,979.00- 215,979.00- 215,979.00- 533-49141-000-000 Interfund Trans In-PID Surchg 120,053.00- 120,053.00- 10,913.90- 10,913.90- 9.091 109,139.10- Subtotal: 338,032.00- 338,032.00- 11,005.38- 11,005.38- 3.256 327,026.62- Program number: 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- Department number: Revenues 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- Revenues Subtotal ----------- 1,029,007.00- 1,029,007.00- 21,818.23- 21,818.23- 2.120 1,007,188.77- November 26, 2018 Regular Meeting Agenda Packet 107 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 11:31 11/19/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/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 2,150.00 533-70025-051-000 Bond Interest Expense-Tax 266,058.00 266,058.00 266,058.00 533-70035-051-000 Bond Principal Payment-Tax 755,000.00 755,000.00 755,000.00 Subtotal: 1,023,208.00 1,023,208.00 1,023,208.00 Program number: 1,023,208.00 1,023,208.00 1,023,208.00 Department number: Administration 1,023,208.00 1,023,208.00 1,023,208.00 Expenditures Subtotal ----------- 1,023,208.00 1,023,208.00 1,023,208.00 Fund number: 533 MUD 1 I&S Consolidated 5,799.00- 5,799.00- 21,818.23- 21,818.23- 376.241 16,019.23 November 26, 2018 Regular Meeting Agenda Packet 108 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/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 172 10/01/2018 Property taxes (.25) (.25) GL 175 10/09/2018 Property Taxes (136.21) (136.46) GL 176 10/11/2018 Property Taxes (103.26) (239.72) GL 177 10/12/2018 Property Taxes (196.28) (436.00) GL 178 10/15/2018 Property Taxes (137.47) (573.47) GL 179 10/17/2018 Property Taxes (147.21) (720.68) GL 180 10/18/2018 Property Taxes (166.07) (886.75) GL 181 10/19/2018 Property Taxes (420.42) (1,307.17) GL 182 10/22/2018 Property Taxes (558.37) (1,865.54) GL 183 10/23/2018 Property Taxes (880.27) (2,745.81) GL 184 10/24/2018 Property Taxes (843.30) (3,589.11) GL 185 10/25/2018 Property Taxes (1,933.85) (5,522.96) GL 186 10/26/2018 Property Taxes (1,247.54) (6,770.50) GL 187 10/29/2018 Property Taxes (1,454.33) (8,224.83) GL 188 10/30/2018 Property Taxes (1,756.06) (9,980.89) GL 189 10/31/2018 Property Taxes (637.51) (10,618.40) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (10,618.40) (10,618.40) ** (687,175.00) Budgeted (676,556.60) Remaining 2 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 172 10/01/2018 Property taxes (51.23) (51.23) GL 174 10/05/2018 Property Taxes (13.41) (64.64) GL 175 10/09/2018 Property Taxes 9.68 (54.96) GL 180 10/18/2018 Property Taxes (38.49) (93.45) GL 182 10/22/2018 Property Taxes (78.06) (171.51) GL 189 10/31/2018 Property Taxes (1.33) (172.84) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (172.84) (172.84) ** (1,800.00) Budgeted (1,627.16) Remaining 10 % Used Account: 533-40015-000-000 Property Taxes/P & I 172 10/01/2018 Property taxes (7.68) (7.68) GL 174 10/05/2018 Property Taxes (1.56) (9.24) GL 180 10/18/2018 Property Taxes (3.46) (12.70) GL 182 10/22/2018 Property Taxes (7.93) (20.63) GL 189 10/31/2018 Property Taxes (.98) (21.61) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (21.61) (21.61) ** (2,000.00) Budgeted (1,978.39) Remaining 1 % Used November 26, 2018 Regular Meeting Agenda Packet 109 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 10/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-49010-000-000 Interest Income 165 10/31/2018 Bank Interest- October (91.48) (91.48) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (91.48) (91.48) ** (2,000.00) Budgeted (1,908.52) Remaining 5 % Used Account: 533-49015-000-000 Lease/Rental Income .00 .00 _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 .00 ** (215,979.00) Budgeted (215,979.00) Remaining 0 % Used Account: 533-49141-000-000 Interfund Trans In-PID Surchg 160 10/31/2018 Texpool Transfers October (10,913.90) (10,913.90) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,913.90) (10,913.90) ** (120,053.00) Budgeted (109,139.10) Remaining 9 % Used Department Totals: ----------------------------------- (21,818.23) ** (21,818.23) Monthly Total (1,029,007.00) Budgeted (1,007,188.77) Remaining 2 % Used November 26, 2018 Regular Meeting Agenda Packet 110 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 10/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 .00 .00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 .00 ** 2,150.00 Budgeted 2,150.00 Remaining 0 % Used Account: 533-70025-051-000 Bond Interest Expense-Tax .00 .00 _______________ Account: 533-70025-051-000 Bond Interest Expense-Tax Totals: .00 .00 ** 266,058.00 Budgeted 266,058.00 Remaining 0 % Used Account: 533-70035-051-000 Bond Principal Payment-Tax .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment-Tax Totals: .00 .00 ** 755,000.00 Budgeted 755,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 1,023,208.00 Budgeted 1,023,208.00 Remaining 0 % Used Fund 533 Totals: ----------------------------------- (21,818.23) (21,818.23) Monthly Total (5,799.00) Budgeted 16,019.23 Remaining 376 % Used November 26, 2018 Regular Meeting Agenda Packet 111 of 136 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET OCTOBER 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 73,804 ACCOUNTS RECEIVABLE - TOTAL ASSETS 73,804 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 19,562 NET REVENUES / EXPENDITURES 54,242 TOTAL FUND BALANCE 73,804 TOTAL LIABILITIES AND FUND BALANCE 73,804 November 26, 2018 Regular Meeting Agenda Packet 112 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 11:31 11/19/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/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- 38.85- 38.85- 3.885 961.15- 534-49143-000-000 Interfund Transfer In-WW Sales 596,238.00- 596,238.00- 54,203.45- 54,203.45- 9.091 542,034.55- Subtotal: 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Program number: 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Department number: Revenues 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- Revenues Subtotal ----------- 597,238.00- 597,238.00- 54,242.30- 54,242.30- 9.082 542,995.70- November 26, 2018 Regular Meeting Agenda Packet 113 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 24 11:31 11/19/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/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 534-70040-051-000 Revenue Bond Interest Expense 215,838.00 215,838.00 215,838.00 534-70045-051-000 Revenue Bond Principal Expense 380,000.00 380,000.00 380,000.00 Subtotal: 596,238.00 596,238.00 596,238.00 Program number: 596,238.00 596,238.00 596,238.00 Department number: Administration 596,238.00 596,238.00 596,238.00 Expenditures Subtotal ----------- 596,238.00 596,238.00 596,238.00 Fund number: 534 2015 Revenue Bond I&S 1,000.00- 1,000.00- 54,242.30- 54,242.30- 5,424.230 53,242.30 November 26, 2018 Regular Meeting Agenda Packet 114 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 54 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 10/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 165 10/31/2018 Bank Interest- October (38.85) (38.85) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (38.85) (38.85) ** (1,000.00) Budgeted (961.15) Remaining 4 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 160 10/31/2018 Texpool Transfers October (54,203.45) (54,203.45) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,203.45) (54,203.45) ** (596,238.00) Budgeted (542,034.55) Remaining 9 % Used Department Totals: ----------------------------------- (54,242.30) ** (54,242.30) Monthly Total (597,238.00) Budgeted (542,995.70) Remaining 9 % Used November 26, 2018 Regular Meeting Agenda Packet 115 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 55 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 10/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 .00 .00 _______________ Account: 534-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 534-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 534-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 215,838.00 Budgeted 215,838.00 Remaining 0 % Used Account: 534-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 534-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 380,000.00 Budgeted 380,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 596,238.00 Budgeted 596,238.00 Remaining 0 % Used Fund 534 Totals: ----------------------------------- (54,242.30) (54,242.30) Monthly Total (1,000.00) Budgeted 53,242.30 Remaining ########## November 26, 2018 Regular Meeting Agenda Packet 116 of 136 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 27,763 ACCOUNTS RECEIVABLE - TOTAL ASSETS 27,763 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 2,584 NET REVENUES / EXPENDITURES 25,179 TOTAL FUND BALANCE 27,763 TOTAL LIABILITIES AND FUND BALANCE 27,763 November 26, 2018 Regular Meeting Agenda Packet 117 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 25 11:31 11/19/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/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- 6.15- 6.15- 1.025 593.85- 535-49142-000-000 Interfund Tran In-Water Sales 276,901.00- 276,901.00- 25,172.81- 25,172.81- 9.091 251,728.19- Subtotal: 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Program number: 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Department number: Revenues 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- Revenues Subtotal ----------- 277,501.00- 277,501.00- 25,178.96- 25,178.96- 9.073 252,322.04- November 26, 2018 Regular Meeting Agenda Packet 118 of 136 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 26 11:31 11/19/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/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 535-70040-051-000 Revenue Bond Interest Expense 61,501.00 61,501.00 61,501.00 535-70045-051-000 Revenue Bond Principal Expense 215,000.00 215,000.00 215,000.00 Subtotal: 276,901.00 276,901.00 276,901.00 Program number: 276,901.00 276,901.00 276,901.00 Department number: Administration 276,901.00 276,901.00 276,901.00 Expenditures Subtotal ----------- 276,901.00 276,901.00 276,901.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 600.00- 600.00- 25,178.96- 25,178.96- 4,196.493 24,578.96 ******* End of Report ********* November 26, 2018 Regular Meeting Agenda Packet 119 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 56 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 10/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 165 10/31/2018 Bank Interest- October (6.15) (6.15) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (6.15) (6.15) ** (600.00) Budgeted (593.85) Remaining 1 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 160 10/31/2018 Texpool Transfers October (25,172.81) (25,172.81) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,172.81) (25,172.81) ** (276,901.00) Budgeted (251,728.19) Remaining 9 % Used Department Totals: ----------------------------------- (25,178.96) ** (25,178.96) Monthly Total (277,501.00) Budgeted (252,322.04) Remaining 9 % Used November 26, 2018 Regular Meeting Agenda Packet 120 of 136 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 57 11:31 11/19/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 10/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 .00 .00 _______________ Account: 535-70005-051-000 Rev Bond Paying Agent Fee Totals: .00 .00 ** 400.00 Budgeted 400.00 Remaining 0 % Used Account: 535-70040-051-000 Revenue Bond Interest Expense .00 .00 _______________ Account: 535-70040-051-000 Revenue Bond Interest Expense Totals: .00 .00 ** 61,501.00 Budgeted 61,501.00 Remaining 0 % Used Account: 535-70045-051-000 Revenue Bond Principal Expense .00 .00 _______________ Account: 535-70045-051-000 Revenue Bond Principal Expense Totals: .00 .00 ** 215,000.00 Budgeted 215,000.00 Remaining 0 % Used Department 51 Totals: ----------------------------------- .00 ** .00 Monthly Total 276,901.00 Budgeted 276,901.00 Remaining 0 % Used Fund 535 Totals: ----------------------------------- (25,178.96) (25,178.96) Monthly Total (600.00) Budgeted 24,578.96 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- 3,691,211.95 **** (151,515.17) Monthly Total (1,209,068.00) Budgeted (4,900,279.95) Remaining ########## ******* End of Report ********* November 26, 2018 Regular Meeting Agenda Packet 121 of 136 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:October 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:18.3% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION FIRE REVENUES 122-40010 Property Taxes/Mud Fire $1,117,000 $17,258 $17,258 1.55%10/2018 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent $274 $274 10/2018 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I $39 $39 10/2018 Fire Taxes Penalties &Interest collected FIRE EXPENSES 122-69195-045 GASB34/ Reserve for Replacement $81,420 $81,420 $81,420 100.00%10/2018 Annual Contribution for Reserve Replacement 122-69305-045 Capital Leases $127,149 $127,149 $127,149 100.00%10/2018 Annual Fire Truck payment 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 November 26, 2018 Regular Meeting Agenda Packet 122 of 136 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:October 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:18.3% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-40000-000 Property Taxes $132,384 $1,965 $1,965 1.48%10/2018 Property Taxes 135-40015-000 Property Taxes/P & I $300 $4 $4 1.41%10/2018 Property Taxes/P & I 135-47000-000 Water $6,599,484 $353,429 $353,429 5.36%10/2018 Water Sales 135-47005-000 Sewer $3,412,665 $257,431 $257,431 7.54%10/2018 Winter Average Revenue 135-47025-000 Penalties $136,418 $9,876 $9,876 7.24%10/2018 Penalty Charges on Utility Billing 135-47070-000 TCCC Effluent Charges $60,000 $18 $18 0.03%10/2018 Effluent Charges 135-49900-000 MISC Income $7,000 $485 $485 6.93%10/2018 MISC Income EXPENSES WATER 135-69195-010 GASB34/Reserve for Replacement 75,000 75,000 75,000 100.00%10/2018 Annual GASB34 Replacement Payment WASTEWATER 135-60070-020 Dues & Memberships 300 69 69 23.00%10/2018 CDL Renewal 135-60135-020 TCEQ Fees & Permits 30,000 16,345 16,345 54.48%10/2018 WWTP Permit Fees; Well Water 135-60334-020 Interfund Transfer Out 200,000 122,777 122,777 61.39%10/2018 Fund transfer to cover WWTP Improvement Over Run 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 November 26, 2018 Regular Meeting Agenda Packet 123 of 136 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:October 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:18.3% 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-65010-020 Uniforms 5,495 1,035 1,035 18.84%10/2018 Red Wing Shoes; Tractor Supply; Amazon-Shoes 135-69195-020 GASB34/Reserve for Replacement 30,000 30,000 30,000 100.00%10/2018 Annual GASB34 Replacement Payment BOARD OF DIRECTORS ADMINISTRATION 135-55030-030 Software & support 77,849$ 61,104$ 61,104$ 78.49%10/2018 Annual IT Contract with M3 Networks Non-Departmental 135-55055-039 Auditing 30,800$ 5,000$ 5,000$ 16.23%10/2018 Upfront Audit Invoice November 26, 2018 Regular Meeting Agenda Packet 124 of 136 Trophy Club Municipal Utility District No. 1    Date:    11/26/2018  To:    Board of Directors  From:    John Robert Carman  Subject:  General Manager’s Report    Regulatory Updates  Sanitary Sewer Overflows (SSO) – No SSO’s were recorded since the previous regular Board  meeting.  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.  T CEQ  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 have been corrected within  30 days of the visit, although the TCEQ investigator suggested we collect 8 weeks of data on the  chemical usage record before submitting it.  New Items – A sewer force main, extending from the lift station (no. 2) on TW King Road, was  exposed through erosion in the last large precipitation events.  When you look the photo below,  our force main is the smaller line shown in the background of the photo and the other is an  abandoned  sewer  line.    Note  the  loss  of  the  stream  bank  for  the  property  owner  in  the  background.                November 26, 2018 Regular Meeting Agenda Packet 125 of 136 CP&Y has worked for us in the area of environmental permitting along this creek before, so staff  has  approached  them  for  assistance  in  this  matter  to  determine whether  or  not  any  environmental permitting will be required to repair stream bank and protect our infrastructure.   Working in this stream requires the permission of the Army Corp of Engineers, and depending on  scope of work the repair project may require environmental permitting. An email received last  week suggested that the environmental and engineering work would could be completed for  around $7,000.  Capital Improvement Projects   Interconnecting Pipeline Project Phase 2 – This phase of the project continues with final design  by Halff Engineering requesting permission to check their design against the model developed by  CP&Y.  Staff approved this cooperative modeling review between the engineering teams selected  by our Board.  WWTP – Our contractor had submitted a request for full substantial completion on Phase 3.  Our  engineering team has reviewed the request and has sent the second substantial completion  certificate, this time without exclusion for the electrical panel/laboratory/ operations control  room building which was also excluded on the first substantial completion request.   The only  exclusion from the second substantial completion request is the overhead crane installation  serving MBR basins 3‐6.  It is my understanding that all construction trailers have been removed  from the site.  High Service Pump Station Improvements – This project was originally put out for bids in  December of 2017 and all bids received were considerably higher than what was budgeted.  The  second request for bids was published on November 5, 2018 and a mandatory pre‐bid meeting  was held on November 15, 2018.  Sealed bids are due by 11:00 a.m. on December 5, 2018 at  which time they will be publicly opened and read.  The results of the bid opening will be brought  to the board for review and selection at the regular December meeting.   November 26, 2018 Regular Meeting Agenda Packet 126 of 136 FY October November December January February March April May June July August September Total Year 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 2019 47,193 47,193           FY October November December January February March April May June July August September Total Year 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 2019 60,576 60,576 FY October November December January February March April May June July August September 2014 Total 4139 4157 4173 4206 4209 4219 4240 4268 4280 4308 4333 4339 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 2019 Total 4741 4741 2019 MUD 3297 3297 2019 PID 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 2015 2016 2017 2018 2019 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 2015 2016 2017 2018 2019 November 26, 2018 Regular Meeting Agenda Packet 127 of 136 Influent EffluentInfluent EffluentInfluent Effluent2‐Oct 42.5 0.33 99.2% 211 2.0 99.1% 218 1.0 99.5%4‐Oct 42.5 0.84 98.0% 172 2.0 98.8% 218 1.0 99.5%      8‐Oct 45 0.20 99.6% 126 2.0 98.4% 208 1.0 99.5%10‐Oct 42.0 0.20 99.5% 132 2.0 98.5% 340 1.0 99.7%   15‐Oct 34.5 0.20 99.4% 62.6 2.0 96.8% 175 1.0 99.4%17‐Oct 30 0.20 99.3% 115 2.0 98.3% 128 1.0 99.2% 22‐Oct 28.9 0.20 99.3% 177 2.0 98.9% 165 1.0 99.4%23‐Oct 37.5 0.20 99.5% 119 2.0 98.3% 92.5 2.4 97.4%29‐Oct34.5 0.2499.3%193 2.099.0%276 1.099.6%30‐Oct42.5 0.2299.5%140 2.098.6%208 1.099.5%99.3%98.5%99.3%October 2018 ResultsAmmonia‐NCBOD5TSS0.302.01.2Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportNovember 26, 2018 Regular Meeting Agenda Packet128 of 136 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.2810.28300.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.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 LimitNovember 26, 2018 Regular Meeting Agenda Packet129 of 136 Max mg/L1.14Aver mg/L1.0Max mg/L8.8Aver mg/L5.0Total Suspended Solids (TSS)Nitrate - Nitrogen1.01.01.01.01.01.01.01.01.01.10.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.64.30.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 LimitNovember 26, 2018 Regular Meeting Agenda Packet130 of 136 Max mg/L5.0Aver mg/L1.8Max mg/L7.8Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.01.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.317.37.47.47.37.67.77.57.87.47.670.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 MaxNovember 26, 2018 Regular Meeting Agenda Packet131 of 136 Max mg/L7.8Aver mg/L7.3 Dissolved Oxygen (DO)7.87.57.87.67.47.47.06.57.17.40.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 LimitNovember 26, 2018 Regular Meeting Agenda Packet132 of 136 October November December January February March April May June July August September ebills 870 Bills Mailed 3921 Bank Draft 650 Credit Card Draft 1077 Online Payments 1157 Late Notices 402 Disconnects 29 M 3297 Connections P 1444 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 Trophy Club MUD #1 Utility Billing Report Fiscal Year 2019 Fiscal Year 2018 November 26, 2018 Regular Meeting Agenda Packet 133 of 136 MUD Permits Month: October 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 10/8/2018 2018-0040 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ -$ Total 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ -$ -$ 1,791.00$ November 26, 2018 Regular Meeting Agenda Packet 134 of 136 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $2,904,623 $2,904,623 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$311,465 $1,782,574 $2,094,039 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 $782,846 $0 $782,846 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $0 $0 $102,234 517-10300 Prosperity Bank Construction WWTP Improvements $7 $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 $623,048 $0 $623,048 533-10250 TexPool Tax I & S (XXXXX0003)$70,534 $0 $70,534 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $73,804 $0 $73,804 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $27,763 $0 $27,763 $3,747,139 $4,687,797 $8,434,936 Amount available in cash (MUD Accounts)$4,687,797 Amount available for spending (MUD Accounts)$4,687,797 * 10/31/2018 Customer Water Deposits $311,465 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $278,787 $278,787 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $278,787 $278,787 Amount available in cash (Fire Department Accounts)$278,787 Amount available for spending (Fire Department Accounts)$278,787 1,782,574$ Prosperity General Fund 2,904,623$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 4,687,797$ Nonspendable Fund Balance (Prepaids)8,486$ Assigned Fund Balance (FY2019 Capital Projects plus prior year carry forward)1,906,543$ Unassigned Fund Balance 4,594,239$ Current Year Revenue/Expenses 16,289$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $6,525,557 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF OCTOBER 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) November 26, 2018 Regular Meeting Agenda Packet 135 of 136 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 Club Mu Office Closes at p.m :pm Board of Dire Holiday - Office Closed Jan Holiday - Office Closed November 26, 2018 Regular Meeting Agenda Packet 136 of 136