Loading...
HomeMy WebLinkAbout2018-1217 December 17, 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, December 17, 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. November 2018 Check Register  b. November 26, 2018 Regular Meeting Minutes    attachments: November 2018 Check Register         November 26, 2018 Regular Meeting Minutes    REGULAR SESSION  2. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee.    3. Consider and take appropriate regarding lease purchase agreement for acquisition of a Ford CUES Transit  350 Demo Unit (Camera Van) for the water department to be purchased through the Buy Board contract  at Rush Truck Center:  a. Adopt Order No. 2018‐1217 authorizing General Manager to negotiate and execute Lease Purchase  Agreement for acquisition of the Camera Van at a price not to exceed $206,000; and  b. Authorize General Manager and District Officials to execute documents as may be necessary and  convenient for the District to acquire the Camera Van pursuant to the lease purchase agreement.  attachment: Order No. 2018‐1217     December 17, 2018 Regular Meeting Agenda Packet 1 of 126     4. Consider and take appropriate action to award Contract No. 2018121701 for construction of fence  improvements at the water treatment plant as part of Fiscal Year 2019 Capital Improvement Projects.    attachment: Staff Report     5. Consider and take appropriate action regarding the November 2018 Combined Financials and Variance  Report.   a. Combined Financials   b. Combined Variance     attachments: Combined Financials         Combined Variance    REPORTS & UPDATES  6. 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. Fire Department Summary  d. Water System Operations  e. Wastewater System Operations  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  7. 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  December 17, 2018 Regular Meeting Agenda Packet 2 of 126     County, 141st Judicial District (Cause No. 141‐299351‐18).  c. Agreement with Wilbow‐Solana LLC relating to Partial Release of Easement Rights and Relocation of  Fire Hydrant Improvements.  d. Claims for damages caused by District facilities and/or operations to property located at 1040 Trophy  Club Drive, Trophy Club, Texas.    8. 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  9. Consider and take appropriate action on matters deliberated in Executive Session:    10. Items for future agendas:     11. Set future Meeting dates:  Regular Board Meeting – Monday, January 21, 2019 at 6:30 p.m.      attachment: January 2019 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    December 17, 2018 Regular Meeting Agenda Packet 3 of 126 December 17, 2018 Regular Meeting Agenda Packet 4 of 126 December 17, 2018 Regular Meeting Agenda Packet 5 of 126 December 17, 2018 Regular Meeting Agenda Packet 6 of 126 December 17, 2018 Regular Meeting Agenda Packet 7 of 126 December 17, 2018 Regular Meeting Agenda Packet 8 of 126 December 17, 2018 Regular Meeting Agenda Packet 9 of 126 December 17, 2018 Regular Meeting Agenda Packet 10 of 126     TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1  BOARD OF DIRECTORS   November 26, 2018   REGULAR MEETING MINUTES    Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a  Regular Session on November 26, 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  Steven Krolczyk  Finance Manager  Tony Corbett  Legal Counsel    GUESTS PRESENT:   Prichard Bevis  Whitaker Chalk Swindle & Schwartz Pllc    CALL TO ORDER AND ANNOUNCE A QUORUM   President Wilson announced the date of November 26, 2018, called the meeting to order and announced a  quorum present at 6:30 p.m.    CITIZEN COMMENTS  There were no citizen comments    CONSENT AGENDA  1. Consider and take appropriate action to approve the Consent Agenda.    a. October 2018 Check Register  b. October 15, 2018 Regular Meeting Minutes  c. November 7, 2018 Special Meeting Minutes    Motion made by Director Flynn and seconded by Director Chapman to approve the Consent Agenda as  presented.    Motion carried unanimously    President Wilson requested agenda items 8 and 9 be brought forward for discussion.  With no objections,  the items were brought forward.   December 17, 2018 Regular Meeting Agenda Packet 11 of 126       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)    Motion made by Director Rose and seconded by Director Castonguay to appoint Mike McMahon as the  Voting Member to the Water Customer Advisory Committee and Steven Krolczyk as the alternate for the  Fiscal year beginning October 1, 2018 through September 30, 2019.    Motion carried unanimously    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)    Motion made by Director Rose and seconded by Director Flynn to approve Contract No. 2018112601 with  United Healthcare Company for employee healthcare benefits effective January 1, 2019.    Motion carried unanimously    4. Consider and take appropriate action relating to District rebranding. (Rose/Castonguay)    Motion made by Director Wilson and seconded by Director Flynn not to proceed with the rebranding.    For: Wilson, Chapman, and Flynn  Oppose: Rose and Castonguay    Motion passed 3‐2    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)    Motion  made  by  Director  Chapman  and  seconded  by  Director  Castonguay  to  approve  the  Service  Agreement for Laboratory Services with the City of Fort Worth Centralized  Water  and  Wastewater  Laboratory.    Motion carried unanimously    6. Consider and take appropriate action regarding the October 2018 Combined Financials and Variance  Report.    a. Combined Financials   b. Combined Variance     Motion  made  by  Director  Flynn  and  seconded  by  Director  Chapman  to  approve  the  October  2018  Combined financials and variance report    Motion carried unanimously      December 17, 2018 Regular Meeting Agenda Packet 12 of 126     REPORTS & UPDATES  7. 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. Holiday Office Closures – December 14, 2018 at 12 p.m.  g. Finance Update   Utility Billing Report   Permits Collected   Cash Report    General Manager John Carman presented his monthly reports and updates to the board and answered  questions related thereto.     The Board convened into Executive Session at 6:34 p.m.    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  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.    The Board reconvened into Regular Session at 7:44 p.m.    REGULAR SESSION    President Wilson stated that no final decisions, actions or votes were taken in Executive Session.    10. Consider and take appropriate action on matters deliberated in Executive Session:  December 17, 2018 Regular Meeting Agenda Packet 13 of 126     No action was taken.    11. Items for future agendas:     12. Set future Meeting dates:  Regular Board Meeting – Monday, December 17, 2018 at 6:30 p.m.       ADJOURN  Motion made by Director Rose and seconded by Director Castonguay to adjourn.    Motion carried unanimously    President Wilson adjourned the meeting at 8:49 p.m.      ___________________________  Gregory Wilson, President                                                                                                   ____________________________                (SEAL)  Steve Flynn, Secretary/Treasurer                                                                                                                                             ____________________________  Laurie Slaght, District Secretary      December 17, 2018 Regular Meeting Agenda Packet 14 of 126 ORDER NO. 2018-1217 AN ORDER AUTHORIZING GENERAL MANAGER TO EXECUTE LEASE PURCHASE AGREEMENT (Camera Van) WHEREAS, Trophy Club Municipal Utility District No. 1 (the “District”) is a duly created and existing municipal utility district created and operating under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.218 of the Texas Water Code authorizes a water district to acquire any property, real or personal, considered necessary for the purpose of accomplishing any one or more of the district’s governmental purposes and further authorizes a district to lease property from others for its use on such terms and conditions as the board of the district may determine to be advantageous; WHEREAS, Section 271.005 et seq. of the Texas Local Government Code (Public Property Finance Act) authorizes conservation and reclamation districts and other political subdivisions of the State of Texas to execute, perform, and make payments under a contract with any person for the purchase or acquisition of personal property, including contracts that provide for a lease with an option to purchase such personal property; WHEREAS, the Board of Directors of the District has determined that it is necessary, useful and appropriate for the District to acquire a CUES Transit 350 Demo Unit for the District’s water department as more particularly described in Exhibit “A” attached hereto (the “Camera Van”); and WHEREAS, Section 49.056(a) of the Texas Water Code authorizes the board of directors of a municipal utility district to delegate to its general manager full authority to manage and operate the affairs of the district subject only to the orders of the board; and WHEREAS, pursuant to the foregoing authority, the Board of Directors desires to authorize the District’s General Manager to negotiate and execute a lease purchase agreement on behalf of the District for the lease purchase of the Camera Van under the terms and conditions set forth herein. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The facts and recitations found in the preamble of this Order are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. December 17, 2018 Regular Meeting Agenda Packet 15 of 126 Section 2. The Board of Directors hereby authorizes the General Manager to enter into a lease purchase agreement on behalf of the District for the purchase of the Camera Van subject to the following parameters and limitations: i. The total principal cost of the Camera Van shall not exceed $206,000; ii. The final price of the Camera Van shall be determined through the District’s Buy Board contract; iii. The Camera Van shall be purchased from Rush Truck Center; iv. The lease purchase agreement shall be entered into with Government Capital Corporation, as lessor; and v. The form of the lease purchase agreement shall be subject to review and approval by the District’s legal counsel prior to execution by the General Manager. ADOPTED, PASSED, AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, Trophy Club, Texas this 17th day of December 2018. _________________________________ Gregory Wilson, President Board of Directors _________________________________ (SEAL) Steve Flynn, Secretary/Treasurer Board of Directors _________________________________ Laurie Slaght, District Secretary December 17, 2018 Regular Meeting Agenda Packet 16 of 126 Exhibit “A” Description of Camera Van December 17, 2018 Regular Meeting Agenda Packet 17 of 126 C LS North Service Center CLS South Service Center 726 S. Sherman Street 8000 N. Loop East Richardson, Texas 75081 Houston, Texas 77028 Office: 972-479-1335 Office: 281-440-1881 Fax: 972-479-1336 Fax: 281-440-1879 ____________________________________________________________________ www.SewerTools.com 12/12/2018 Trophy Club MUD 100 Municipal Drive Trophy Club, TX 76262 ATTN: Mike McMahon/John Carman RE: CUES Transit 350 Demo Unit Quote Gentlemen, Please see the following specifications and pricing for the CUES CCTV unit on the Transit 350 gasoline chassis as demonstrated: 1 FORD TRANSIT 350 GASOLINE CARGO VAN 2X4 DRW 10360LB GVWR CHASSIS 1 LED TRAFFIC DIRECTOR WITH 30FT CABLE 1 HIDE-A-WAY STROBE KIT WITH POWER SUPPLY 1 TRANSIT VAN EXTERIOR LIGHTING & CONTROL ROOM - EVOLUTION 3.0 TO INCLUDE: 1 Amber LED Strobe Warning Beacon center rear 2 Adjustable LED Floodlights Rear of Vehicle Area Illumination Control Room Interior: 1 Lonseal Lonplate Flooring 1 Kemlite Wall & Ceiling Covering 1 Bulkhead Wall with Passage Door from Control Room to Equipment Room 1 Tinted Viewing Window in Bulkhead Wall 1 Tinted Viewing Window in Bulkhead Door 1 Above Desk Control Console with Rack Mount for Electronic Equipment 1 Desktop / Work Area 1 LED Light Fixture 2 Electrical Outlet with Dual Receptacles 1 Fire Extinguisher with Bracket, 10BC Rating 1 Operators Chair 1 Breaker Box Storage Area with Locking Positive Latch 1 9200BTU ROOF MOUNTED AIR CONDITIONER 1 STORAGE CABINET UNDER CONTROL ROOM DESKTOP 1 TRANSIT VAN EQUIPMENT ROOM INTERIOR - EVOLUTION 3.0 TO INCLUDE: 1 Lonseal Lonplate Flooring 1 Kemlite Wall & Ceiling Covering 1 Electrical Outlet with Dual Receptacles 1 LED Light Fixture 1 15 Minute Courtesy Timer Located at Rear Door Area for 12V LED Interior Lights December 17, 2018 Regular Meeting Agenda Packet 18 of 126 C LS North Service Center CLS South Service Center 726 S. Sherman Street 8000 N. Loop East Richardson, Texas 75081 Houston, Texas 77028 Office: 972-479-1335 Office: 281-440-1881 Fax: 972-479-1336 Fax: 281-440-1879 ____________________________________________________________________ www.SewerTools.com 1 10-GALLON WASHDOWN SYSTEM TO INCLUDE: 1 10-Gallon Fresh Water Tank 1 Electric Water Pump 1 Retractable Hose Reel with 25'Water Hose and Nozzle 1 UPPER AND LOWER STORAGE CABINET IN EQUIPMENT ROOM 1 Lower Storage Cabinet / Work Top 1 Upper Wall Mounted Storage Cabinet 1 ADDITIONAL LIGHTING AND OUTLET 1 Light Mounted Above Work Top 1 Dual Receptacle Outlet Above Work Top 1 TOOL CHEST, MODULINE, 5 DRAWER 1 24" REAR FLAT SCREEN MONITOR MOUNTED IN BULKHEAD WALL 1 Flat Screen Monitor 1 Cable Assembly - Video Monitor to Monitor in Control Room 1 Electrical Outlet 1 ON-BOARD AC POWER SYSTEM, DYNAMIC INVERTER, 6.3KW 1 DIGITAL ENGINEERING PANEL FOR INVERTER SYSTEM, BLACK 1 P&T ZOOM III M/C BUILT-IN SONDE LED CAMERA (OZ3) 1 Solid State Color Sewer TV Camera 1 Pan & Rotate Camera Head, 40:1 Zoom Ratio, 10x Optical Zoom, 4x Digital Zoom 1 NTSC Color Standard with 4x Light Integration 1 4 x 5W Cluster LED's for 6" through 72" lines 1 Built In Transmitter, 512 Hz 1 Camera Transportation and Storage Case 1 BRASS COMP STEERABLE CAM TRANS, WHEELED -60V (CPR) 1 Steerable Unit Designed to Turn 360 Degrees within Its Own Radius 1 Set of Driven Rubber Wheels to Inspect 6" Pipe 1 Two (2) Speed Transmission to Maximize Torque in Large Diameter Pipe with: 1 Manual Shifter on Camera Carrier 1 Unit Shall Have Forward, Free Wheel, and Power Reverse Capabilities 1 All Six (6) Wheel Drive Transporter Assem bly to Include: 1 Motor & Enclosed Drive Train 1 Tip up Rear Connector 1 8" RUBBER WHEEL KIT FOR COMPACT TRANSPORTER 1 10-15" RUBBER WHEEL KIT FOR COMPACT TRANSPORTER 1 6"-15"PIPE SPACER KIT December 17, 2018 Regular Meeting Agenda Packet 19 of 126 C LS North Service Center CLS South Service Center 726 S. Sherman Street 8000 N. Loop East Richardson, Texas 75081 Houston, Texas 77028 Office: 972-479-1335 Office: 281-440-1881 Fax: 972-479-1336 Fax: 281-440-1879 ____________________________________________________________________ www.SewerTools.com 1 12"-15" PNEUMATIC TIRE KIT FOR COMPACT TRANSPORTER 1 6" STEEL 10/12 GR WHEEL KIT FOR COMPACT TRANSPORTER 1 8" STEEL 10/12 GR WHEEL KIT FOR COMPACT TRANSPORTER 1 10-15" STEEL 10/12 GR WHEEL KIT FOR COMPACT TRANSPORTER 1 QUICK CABLE LOCK PIGTAIL COUPLER KIT 2 HD CABLE TERMINATION TO STANDARD 12-PIN TERMINATION ADAPTER CABLE 1 1200' HD 12PIN MULTI-CONDUCTOR CABLE, .450 1 1200'Gold Multi Conductor Kevlar Fiber Armored Cable, .450 Diameter 1 Kevlar Armored Cable Terminal Connector with Coaxial Pin 1 12-Pin Dummy Protector Plug 1 Cable Strain Relief 1 TV REEL ASSEMBLY FOR DUC, MECHANICAL FOOTAGE FOR SUMMIT .450 CABLE W/AUTO PAYOUT 1 Black Thermoplastic Powder Coated Frame 1 Power Level-wind & Multi Ratio Manual Transmission 1 Automatic Cable Payout System 1 Footage Meter with Local Counter and Remote Counter 1 Transmission Control at Viewing Station 1 Local Reel Mount Electrical and Mechanical Control 1 Sealed Continuous Contact Collecto r Assembly 1 Sealed Continuous Contact Video Connection 1 Removable Drip Pan for Cleaning 1 CABLE ASSY, TEST, SYS SEL, DUC, CATVS 2 19" (MINIMUM) FLATSCREEN COLOR INDUSTRIAL TV MONITOR NTSC / PAL COLOR STANDARDS 1 PCU ASSEMBLY [RACK MOUNT] 1 CCU ASSEMBLY [RACK MOUNT] 1 Alpha Numeric Information Display, with Multi Paging and Defect Coding 1 Remote "QWERTY" Keyboard 1 On Screen Footage Display 1 TEST CABLE 1 8.7" MINI KEYBOARD 1 BRACKET, LOGITECH CONTROLLER, K2 December 17, 2018 Regular Meeting Agenda Packet 20 of 126 C LS North Service Center CLS South Service Center 726 S. Sherman Street 8000 N. Loop East Richardson, Texas 75081 Houston, Texas 77028 Office: 972-479-1335 Office: 281-440-1881 Fax: 972-479-1336 Fax: 281-440-1879 ____________________________________________________________________ www.SewerTools.com 1 WIRED & WIRELESS USB CONTROLLER 1 Joystick Control for Pan and Tilt Zoom Camera to Include: 1 360 Degree Rotate 1 330 Degree Optical Pan 1 Joystick Control for All Steering Functions & Forward / Reverse Directions for Transporter 1 Camera Lift Control for Optional Electronic Camera Lift 1 All Other Controls for Camera to Include: 1 Camera Iris and Focus Override & Zoom 1 Camera Lights & Shutter Control for Light Enhancement 1 Camera Diagnostics & Auto Home 1 Cruise Control to Set Speed of the Trans porter for Hands off Operation 1 All Reel Controls to Include: Retrieve, Release, and Variable Speed 1 COMPUTER WITH GNET BASIC TO INLCUDE (MINIMUM): 1 Motherboard with LGA 1151 Socket and Intel Z270 Chipset 1 Intel Core i7-6700K 4.0 GHz Processor 1 8 GB of DDR4 (Double Data Rate) 2133 RAM 1 USB Video Capture Device for MPEG 1 / 2 / 4 / WMV 1 Video Display Adapter, 2GB, HDMI, DVI, VGA 1 LAN, On Board Network Connections, 10 / 100 / 1000 Mbps 4 USB 2.0 Ports 4 USB 3.0 Ports 2 USB 3.1 Ports 2 RS232 Serial Com Ports 1 Bluetooth v4.0 1 WiFi MU-MIMO 802.11 a/b/g/n/ac dual frequency band 2.4/5 GHz 5 On Board Audio Ports 1 DVD + / - RW DVD Burner 20x / CD - RW 40x Internal Optical Drive 1 1 TB (7,200 RPM) SATA Hard Drive 1 250 GB M.2 Solid State D rive 1 500-Watt 1U ATX Power Supply 1 Industrial Hardened Case Slim 2U Design for 19" Rack 1 Windows 10 Professional 64 -bit Operating System 1 GNet Basic Support Plan 1 ESRI Interface Module, GNet software: 1 ESRI ARCGIS Run Time Engine: 1 ESRI Import Module: 1 Granite Net Office Kit: 1 Granite Net Office Support Plan: December 17, 2018 Regular Meeting Agenda Packet 21 of 126 C LS North Service Center CLS South Service Center 726 S. Sherman Street 8000 N. Loop East Richardson, Texas 75081 Houston, Texas 77028 Office: 972-479-1335 Office: 281-440-1881 Fax: 972-479-1336 Fax: 281-440-1879 ____________________________________________________________________ www.SewerTools.com 1 USB BLACK COMPUTER KEYBOARD AND MOUSE 1 HP OFFICEJET COLOR PRINTER 1 EXTERIOR CAT -5 CONNECTION 1 MANHOLE TOP ROLLER ASSEMBLY, TV ONLY 1 MANHOLE ADAPTER CLAW HOOK 6 POLE ASSY, RETRIEVAL/DOWNHOLE TL, 58" 1 INVERT ROLLER ASSEMBLY 1 RETRIEVAL HOOK 1 MULTI CONDUCTOR TV ONLY TOOL KIT 1 Milliamp meter Tool 1 Electrical Tape 1 Needle Nose Pliers 1 Six-In-One Screwdriver 1 6" Adjustable Wrench 1 Anti Seize Grease 1 9-Piece Allen Wrench kit 1 Solder Iron Kit 1 Industrial Pliers 1 5/32 T-Handle Hex Wrench 1 Multi Conductor TV Only Operation Manual 1 Parts Catalog 1 Cable Repair Kit DVD 1 TV Only Training DVD 1 Pop Up Canopy on Rear Doors 1 DELIVERY AND 3 DAYS ON SITE TRAINING AT TROPHY CLUB, TX Price for CUES Transit 350 Demo Unit as listed above: $205,503.50 Please call with any questions. Regards, Paul M. Baumy 281-850-1721 December 17, 2018 Regular Meeting Agenda Packet 22 of 126 TEXAS LOCAL GOVERNMENT PURCHASING COOPERATIVE BUYBOARD Vendor RUSH TRUCK CENTER Date Prepared 12/12/2018 DREW NEUBAUER Phone 830-302-5254 End User:Trophy Club MUD Phone/Fax Ford Fleet A: Base Price in Bid/Proposal Number:521-16 Series: Transit $22,530.00 B: Published Options(Itemize Below ) DESCRIPTION AMOUNT OPT #DESCRIPTION AMOUNT Ford 2,514.00$ RTC0051 1,236.00$ Ford 245.00$ RTC1060 1,895.00$ Ford 295.00$ RTC1059 682.00$ Ford 485.00$ Ford 1,385.00$ RTC1056 213,000.00$ RTC0053 2,438.00$ Subtotal Column 1:220,362.00$ Subtotal Column 2:3,813.00$ Published Options added to Base Price(Subtotal of "Col 1" & "Col 2")224,175.00$ C: Subtotal of A + B $246,705.00 D: Non Published Options -$44,991.50 Subtotal Column 1:-$44,991.50 Subtotal Column 2:-$ Unpublished Options added to Base price (Subtotal "Col 1 + Col 2")-$44,991.50 E: Contract Price Adjustment (If any, explain here ) 1,995.00$ F: Total of C + D +/- E 203,708.50$ G: Quantity ordered Units: 1.00 x F 203,708.50$ H: BUYBOARD Administrative Fee 400.00$ I: Non-Equipment Charges & Credits (I.e.: Ext. Warranty, Trade-In, Delivery, etc.) Ford Drip Ship and delivery 1,395.00$ 1,395.00$ J: TOTAL PURCHASE PRICE INCLUDING (G+H+I)$205,503.50 Rush Care / PDI Contact for Vendor: End User Contact: Product Description: Vinyl Package Reverse Park Aid 10,360 GVW Package Demo Flooring Insurance Trailer Tow Pkg Mirrors, long power/sync pkg/cruise Body Prep Package CUES Sewer Package Sewer Camera Body/Pkg 2018 YM PL 855 December 17, 2018 Regular Meeting Agenda Packet 23 of 126       STAFF REPORT  December 17, 2018     Agenda Item – Consider and take appropriate action to award Contract No. 2018121701 for  construction of fence improvements at the water treatment plant as part of Fiscal Year Capital  Improvement Projects.    Staff Report – Bids were sought to replace and repair the fence at the water treatment plant.   Specifically, the portion that is adjacent to the parking lot as shown in the picture below with  the red line.          The following bids were received:   Hook N Ladder Fence     $90,269.25  Alliance Fence Company   $62,875.00  Gaver Solutions      $72,075.00    Staff Recommendation – Staff recommends the awarding the contract construction of fence  improvements at the water treatment plant to the low bidder Alliance Fence Company for an  amount not to exceed $62,875.00.    Mike McMahon  Operations Manager  December 17, 2018 Regular Meeting Agenda Packet 24 of 126 TROPHY CLUB MUD #1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2018 122 ASSETS FIRE DEPT. CASH IN BANK 56,204 INVESTMENTS 279,877 PREPAID EXPENSES 14,912 ADVALOREM PROPERTY TAXES RECEIVABLE 1,059,358 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE - UTILITY AND OTHER ACCOUNTS RECEIVABLE - TOTAL ASSETS 1,410,351 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,059,358 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 1,059,358 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON-SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 543,884 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (192,890) TOTAL FUND BALANCE 350,993 TOTAL LIABILITIES AND FUND BALANCE 1,410,351 December 17, 2018 Regular Meeting Agenda Packet 25 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 1 17:08 12/12/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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- 56,976.59- 74,234.73- 6.646 1,042,765.27- 122-40011-000-000 Property Taxes/Fire-Delinquent 228.38- 502.41- 502.41 122-40020-000-000 Property Taxes/Fire P&I 88.95- 127.96- 127.96 Subtotal: 1,117,000.00- 1,117,000.00- 57,293.92- 74,865.10- 6.702 1,042,134.90- 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- 57,293.92- 74,865.10- 6.281 1,117,134.90- Department number: Fire Revenues 1,192,000.00- 1,192,000.00- 57,293.92- 74,865.10- 6.281 1,117,134.90- Revenues Subtotal ----------- 1,192,000.00- 1,192,000.00- 57,293.92- 74,865.10- 6.281 1,117,134.90- December 17, 2018 Regular Meeting Agenda Packet 26 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 2 17:08 12/12/18 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 2,982.42 16.569 15,017.58 122-60337-045-000 Transfer to Town/Fire Budget 56,204.00 56,204.00- Subtotal: 233,979.00 233,979.00 1,491.21 59,186.42 25.296 174,792.58 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 100.000 122-69305-045-000 Capital Leases 127,149.00 127,149.00 127,148.60 100.000 .40 Subtotal: 283,569.00 283,569.00 208,568.60 73.551 75,000.40 Program number: 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Department number: Fire 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Expenditures Subtotal ----------- 517,548.00 517,548.00 1,491.21 267,755.02 51.735 249,792.98 Fund number: 122 Trophy Club MUD Fire Dept. 674,452.00- 674,452.00- 55,802.71- 192,889.92 -28.600 867,341.92- December 17, 2018 Regular Meeting Agenda Packet 27 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 1 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/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 342 11/01/2018 Property Taxes (17,258.14) (1,300.14) (18,558.28) GL 343 11/02/2018 Property Taxes (3,205.93) (21,764.21) GL 344 11/05/2018 Property Taxes (1,568.01) (23,332.22) GL 345 11/06/2018 Property Taxes (2,161.16) (25,493.38) GL 346 11/07/2018 Property Taxes (3,439.52) (28,932.90) GL 347 11/08/2018 Property Taxes (1,564.41) (30,497.31) GL 348 11/09/2018 Property Taxes (2,053.24) (32,550.55) GL 349 11/13/2018 Property Taxes (758.63) (33,309.18) GL 350 11/14/2018 Property Taxes (1,654.09) (34,963.27) GL 351 11/15/2018 Property Taxes (3,492.79) (38,456.06) GL 352 11/16/2018 Property Taxes (2,475.88) (40,931.94) GL 353 11/19/2018 Property Taxes (4,314.03) (45,245.97) GL 354 11/20/2018 Property Taxes (2,746.55) (47,992.52) GL 355 11/21/2018 Property Taxes (286.83) (48,279.35) GL 356 11/26/2018 Property Taxes (4,954.65) (53,234.00) GL 357 11/27/2018 Property Taxes (1,698.89) (54,932.89) GL 358 11/28/2018 Property Taxes (3,867.22) (58,800.11) GL 359 11/29/2018 Property Taxes (13,669.07) (72,469.18) GL 360 11/30/2018 Property Taxes (1,765.55) (74,234.73) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (56,976.59) (74,234.73) ** (1,117,000.00) Budgeted (1,042,765.27) Remaining 7 % Used Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 343 11/02/2018 Property Taxes (274.03) (18.95) (292.98) GL 345 11/06/2018 Property Taxes 21.56 (271.42) GL 346 11/07/2018 Property Taxes (158.80) (430.22) GL 350 11/14/2018 Property Taxes (71.20) (501.42) GL 354 11/20/2018 Property Taxes 6.59 (494.83) GL 360 11/30/2018 Property Taxes (7.58) (502.41) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (228.38) (502.41) ** .00 Budgeted 502.41 Remaining 0 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 343 11/02/2018 Property Taxes (39.01) (4.61) (43.62) GL 346 11/07/2018 Property Taxes (64.08) (107.70) GL 347 11/08/2018 Property Taxes (.87) (108.57) GL 348 11/09/2018 Property Taxes (1.24) (109.81) GL 349 11/13/2018 Property Taxes (6.17) (115.98) GL December 17, 2018 Regular Meeting Agenda Packet 28 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 2 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 352 11/16/2018 Property Taxes (39.01) (9.52) (125.50) GL 353 11/19/2018 Property Taxes (.79) (126.29) GL 360 11/30/2018 Property Taxes (1.67) (127.96) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (88.95) (127.96) ** .00 Budgeted 127.96 Remaining 0 % Used 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: ----------------------------------- (74,865.10) ** (57,293.92) Monthly Total (1,192,000.00) Budgeted (1,117,134.90) Remaining 6 % Used December 17, 2018 Regular Meeting Agenda Packet 29 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 3 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 1,491.21 1,491.21 2,982.42 GL _______________ Account: 122-60055-045-000 Insurance Totals: 1,491.21 2,982.42 ** 18,000.00 Budgeted 15,017.58 Remaining 17 % Used Account: 122-60337-045-000 Transfer to Town/Fire Budget 56,204.00 .00 56,204.00 _______________ Account: 122-60337-045-000 Transfer to Town/Fire Budget Totals: .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 81,420.00 .00 81,420.00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 81,420.00 ** 81,420.00 Budgeted .00 Remaining 100 % Used Account: 122-69305-045-000 Capital Leases 127,148.60 .00 127,148.60 _______________ Account: 122-69305-045-000 Capital Leases Totals: .00 127,148.60 ** 127,149.00 Budgeted .40 Remaining 100 % Used Department 45 Totals: ----------------------------------- 267,755.02 ** 1,491.21 Monthly Total 517,548.00 Budgeted 249,792.98 Remaining 52 % Used December 17, 2018 Regular Meeting Agenda Packet 30 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 4 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/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: ----------------------------------- 192,889.92 (55,802.71) Monthly Total (674,452.00) Budgeted (867,341.92) Remaining -29 % Used December 17, 2018 Regular Meeting Agenda Packet 31 of 126 TROPHY CLUB MUD #1 - O&M BALANCE SHEET NOVEMBER 2018 GTBGT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 - 600 CASH IN BANK-CHECKING 2,255,850 - 2,255,850 CASH IN BANK-SAVINGS-CASH RESERVE 984,482 - 984,482 INVESTMENTS-TEXPOOL 2,813,018 782,846 3,595,864 CASH- ESCROW 361,026 - 361,026 PREPAID EXPENSES 88,967 - 88,967 ADVALOREM PROPERTY TAXES RECEIVABLE 120,517 - 120,517 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,937,924 - 1,937,924 TOTAL ASSETS 8,562,384 782,846 9,345,230 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 120,517 - 120,517 ACCOUNTS AND OTHER PAYABLES 612,690 - 612,690 CUSTOMER DEPOSITS 311,805 - 311,805 - TOTAL LIABILITIES 1,045,012 - 1,045,012 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 5,709,156 - 5,709,156 COMMITTED FUND BALANCE - - - NET REVENUES / EXPENDITURES (106,813) - (106,813) - TOTAL FUND BALANCE 7,517,372 782,846 8,300,218 TOTAL LIABILITIES AND FUND BALANCE 8,562,384 782,846 9,345,230 December 17, 2018 Regular Meeting Agenda Packet 32 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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- 6,487.20- 8,452.14- 6.385 123,931.86- 135-40002-000-000 Property Taxes/Delinquent 300.00- 300.00- 26.43- 57.54- 19.180 242.46- 135-40015-000-000 Property Taxes/P & I 300.00- 300.00- 10.26- 14.49- 4.830 285.51- 135-40025-000-000 PID Surcharges 171,983.00- 171,983.00- 171,983.00- Subtotal: 304,967.00- 304,967.00- 6,523.89- 8,524.17- 2.795 296,442.83- 135-47000-000-000 Water 6,599,484.00- 6,599,484.00- 325,801.18- 596,566.14- 9.040 6,002,917.86- 135-47005-000-000 Sewer 3,412,665.00- 3,412,665.00- 265,819.47- 480,126.48- 14.069 2,932,538.52- 135-47025-000-000 Penalties 136,418.00- 136,418.00- 10,143.60- 20,019.68- 14.675 116,398.32- 135-47030-000-000 Service Charges 17,000.00- 17,000.00- 1,125.00- 2,550.00- 15.000 14,450.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- .029 59,982.40- Subtotal: 10,231,567.00- 10,231,567.00- 602,889.25- 1,099,279.90- 10.744 9,132,287.10- 135-49010-000-000 Interest Income 20,000.00- 20,000.00- 9,101.45- 17,772.49- 88.862 2,227.51- 135-49016-000-000 Cell Tower Revenue 14,146.00- 14,146.00- 1,178.81- 2,684.29- 18.976 11,461.71- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 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- 303.27- 788.53- 11.265 6,211.47- Subtotal: 76,668.00- 76,668.00- 11,166.86- 22,411.97- 29.232 54,256.03- Program number: 10,613,202.00- 10,613,202.00- 620,580.00- 1,130,216.04- 10.649 9,482,985.96- Department number: Revenues 10,613,202.00- 10,613,202.00- 620,580.00- 1,130,216.04- 10.649 9,482,985.96- Revenues Subtotal ----------- 10,613,202.00- 10,613,202.00- 620,580.00- 1,130,216.04- 10.649 9,482,985.96- December 17, 2018 Regular Meeting Agenda Packet 33 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 4 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 34,365.20 45,741.15 13.999 281,013.85 135-50010-010-000 Overtime 20,000.00 20,000.00 1,290.42 1,856.04 9.280 18,143.96 135-50016-010-000 Longevity 3,620.00 3,620.00 3,620.00 3,620.00 100.000 135-50017-010-000 Certification 4,800.00 4,800.00 200.00 400.00 8.333 4,400.00 135-50020-010-000 Retirement 33,304.00 33,304.00 3,651.49 5,825.91 17.493 27,478.09 135-50026-010-000 Medical Insurance 74,818.00 74,818.00 2,948.80 5,897.60 7.883 68,920.40 135-50027-010-000 Dental Insurance 4,317.00 4,317.00 213.65 427.30 9.898 3,889.70 135-50028-010-000 Vision Insurance 701.00 701.00 35.92 71.84 10.248 629.16 135-50029-010-000 Life Insurance & Other 3,131.00 3,131.00 215.61 413.22 13.198 2,717.78 135-50030-010-000 Social Security Taxes 22,021.00 22,021.00 2,429.98 3,171.34 14.401 18,849.66 135-50035-010-000 Medicare Taxes 5,150.00 5,150.00 568.31 741.68 14.402 4,408.32 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 1,861.88 14.439 11,033.12 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 50,470.32 70,027.96 13.648 443,064.04 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 885.91 5,317.29 5.317 94,682.71 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 943.00 943.00 31.433 2,057.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 61.97 785.43 15.709 4,214.57 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 200.00 607.70 9.349 5,892.30 Subtotal: 143,214.00 143,214.00 2,090.88 7,653.42 5.344 135,560.58 135-60010-010-000 Communications/Mobiles 5,000.00 5,000.00 367.25 738.23 14.765 4,261.77 135-60020-010-000 Electricity 154,204.00 154,204.00 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 291.00 411.00 8.837 4,240.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 7,685.65 7,685.65 13.251 50,314.35 135-60150-010-000 Wholesale Water 3,013,494.00 3,013,494.00 136,507.63 136,507.63 4.530 2,876,986.37 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 750.00 2,090.00 14.169 12,660.00 135-60332-010-000 Interfund Transfer Out-Rev I&S 585,209.00 585,209.00 25,172.81 50,345.62 8.603 534,863.38 135-60333-010-000 Interfund Transfer Out-Reserve 55,193.00 55,193.00 4,600.00 9,200.00 16.669 45,993.00 135-60334-010-000 Interfund Transfer Out 200,000.00 200,000.00 200,000.00 December 17, 2018 Regular Meeting Agenda Packet 34 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 5 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 175,374.34 225,906.80 5.507 3,876,039.20 135-65005-010-000 Fuel & Lube 15,000.00 15,000.00 933.72 1,576.89 10.513 13,423.11 135-65010-010-000 Uniforms 5,190.00 5,190.00 1,417.41 1,417.41 27.310 3,772.59 135-65030-010-000 Chemicals 20,000.00 20,000.00 1,958.32 4,682.43 23.412 15,317.57 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 55.80 55.80 .080 69,944.20 135-65053-010-000 Meter Change Out Program 87,000.00 87,000.00 87,000.00 Subtotal: 199,390.00 199,390.00 4,365.25 7,732.53 3.878 191,657.47 135-69005-010-000 Capital Outlays 453,000.00 453,000.00 12,084.25 30,617.60 6.759 422,382.40 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 100.000 135-69281-010-000 Water Tank Inspection Contract 120,000.00 120,000.00 57,932.73 57,932.73 48.277 62,067.27 Subtotal: 682,192.00 682,192.00 70,016.98 163,550.33 23.974 518,641.67 Program number: 5,639,834.00 5,639,834.00 302,317.77 474,871.04 8.420 5,164,962.96 December 17, 2018 Regular Meeting Agenda Packet 35 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 6 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/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 80.00 367.70 18.385 1,632.30 Subtotal: 2,000.00 2,000.00 80.00 367.70 18.385 1,632.30 Program number: 1 Lab Analysis for PID 2,000.00 2,000.00 80.00 367.70 18.385 1,632.30 Department number: Water 5,641,834.00 5,641,834.00 302,397.77 475,238.74 8.423 5,166,595.26 December 17, 2018 Regular Meeting Agenda Packet 36 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 7 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 39,380.11 52,417.23 12.430 369,281.77 135-50010-020-000 Overtime 30,000.00 30,000.00 5,638.08 6,625.49 22.085 23,374.51 135-50016-020-000 Longevity 7,445.00 7,445.00 7,445.00 7,445.00 100.000 135-50017-020-000 Certification 8,700.00 8,700.00 700.00 1,400.00 16.092 7,300.00 135-50020-020-000 Retirement 43,276.00 43,276.00 4,917.59 7,796.31 18.015 35,479.69 135-50026-020-000 Medical Insurance 91,627.00 91,627.00 5,215.37 10,725.61 11.706 80,901.39 135-50027-020-000 Dental Insurance 5,104.00 5,104.00 371.89 743.78 14.572 4,360.22 135-50028-020-000 Vision Insurance 826.00 826.00 58.90 117.80 14.262 708.20 135-50029-020-000 Life Insurance & Other 4,495.00 4,495.00 321.20 606.40 13.491 3,888.60 135-50030-020-000 Social Security Taxes 29,006.00 29,006.00 3,147.41 3,968.65 13.682 25,037.35 135-50035-020-000 Medicare Taxes 6,784.00 6,784.00 736.09 928.16 13.682 5,855.84 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 2,411.46 14.234 14,529.54 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 69,137.37 95,185.89 14.252 572,677.11 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 10,720.72 14,030.93 15.944 73,969.07 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 99.48 145.96 1.825 7,854.04 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 10,280.27 14,775.25 19.700 60,224.75 135-55135-020-000 Lab Analysis 35,000.00 35,000.00 2,864.46 7,491.92 21.405 27,508.08 Subtotal: 267,714.00 267,714.00 23,964.93 36,444.06 13.613 231,269.94 135-60010-020-000 Communications/Mobiles 5,000.00 5,000.00 371.19 753.68 15.074 4,246.32 135-60020-020-000 Electricity 174,165.00 174,165.00 378.97 25,296.73 14.525 148,868.27 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 23.000 231.00 135-60080-020-000 Schools & Training 7,155.00 7,155.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 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 .140 4,993.02 135-60285-020-000 Lawn Equipment & Maintenance 11,600.00 11,600.00 590.00 590.00 5.086 11,010.00 135-60331-020-000 Interfund Transfer Out-Tax I&S 120,053.00 120,053.00 10,913.90 21,827.80 18.182 98,225.20 December 17, 2018 Regular Meeting Agenda Packet 37 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 8 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 108,406.90 15.749 579,923.10 135-60333-020-000 Interfund Transfer Out-Reserve 125,187.00 125,187.00 10,432.00 20,864.00 16.666 104,323.00 135-60334-020-000 Interfund Transfer Out 200,000.00 200,000.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 76,889.51 317,048.31 22.952 1,064,286.69 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 1,254.05 2,590.63 20.725 9,909.37 135-65010-020-000 Uniforms 5,495.00 5,495.00 854.08 1,889.49 34.386 3,605.51 135-65030-020-000 Chemicals 30,000.00 30,000.00 536.00 1.787 29,464.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 14.97 14.97 1.248 1,185.03 135-65040-020-000 Safety Equipment 1,200.00 1,200.00 370.86 552.18 46.015 647.82 135-65045-020-000 Lab Supplies 20,000.00 20,000.00 1,702.70 2,435.77 12.179 17,564.23 Subtotal: 70,395.00 70,395.00 4,196.66 8,019.04 11.391 62,375.96 135-69005-020-000 Capital Outlays 330,000.00 330,000.00 41,610.74 44,200.32 13.394 285,799.68 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 100.000 Subtotal: 484,775.00 484,775.00 41,610.74 74,200.32 15.306 410,574.68 Program number: 2,872,082.00 2,872,082.00 215,799.21 530,897.62 18.485 2,341,184.38 Department number: Wastewater 2,872,082.00 2,872,082.00 215,799.21 530,897.62 18.485 2,341,184.38 December 17, 2018 Regular Meeting Agenda Packet 38 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 9 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 4.24 14.133 25.76 Subtotal: 30.00 30.00 2.12 4.24 14.133 25.76 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 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 2.235 12,905.00 Program number: 13,230.00 13,230.00 2.12 299.24 2.262 12,930.76 Department number: Board of Directors 13,230.00 13,230.00 2.12 299.24 2.262 12,930.76 December 17, 2018 Regular Meeting Agenda Packet 39 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 10 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 42,419.32 55,789.59 12.651 385,216.41 135-50010-030-000 Overtime 2,000.00 2,000.00 3.16 6.32 .316 1,993.68 135-50016-030-000 Longevity 1,833.00 1,833.00 1,832.50 1,832.50 99.973 .50 135-50020-030-000 Retirement 41,148.00 41,148.00 4,093.58 6,690.83 16.260 34,457.17 135-50026-030-000 Medical Insurance 81,895.00 81,895.00 4,145.24 8,290.48 10.123 73,604.52 135-50027-030-000 Dental Insurance 4,291.00 4,291.00 259.52 519.04 12.096 3,771.96 135-50028-030-000 Vision Insurance 701.00 701.00 42.51 85.02 12.128 615.98 135-50029-030-000 Life Insurance & Other 4,495.00 4,495.00 282.49 546.98 12.169 3,948.02 135-50030-030-000 Social Security Taxes 27,580.00 27,580.00 2,665.14 3,453.63 12.522 24,126.37 135-50035-030-000 Medicare Taxes 6,450.00 6,450.00 623.32 807.72 12.523 5,642.28 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 213.10 16.456 1,081.90 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 52.39 52.39 1.048 4,947.61 Subtotal: 619,454.00 619,454.00 56,525.72 78,287.60 12.638 541,166.40 135-55030-030-000 Software & Support 77,849.00 77,849.00 7,007.87 68,111.95 87.492 9,737.05 135-55070-030-000 Independent Labor 175,000.00 175,000.00 11,700.76 23,366.90 13.353 151,633.10 135-55080-030-000 Maintenance & Repairs 20,000.00 20,000.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 869.06 869.06 8.691 9,130.94 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 580.27 1,159.56 12.884 7,840.44 Subtotal: 367,904.00 367,904.00 20,157.96 93,822.47 25.502 274,081.53 135-60005-030-000 Telephone 23,500.00 23,500.00 1,556.38 2,979.46 12.679 20,520.54 135-60010-030-000 Communications/Mobiles 4,000.00 4,000.00 237.49 474.98 11.875 3,525.02 135-60020-030-000 Electricity/Gas 8,690.00 8,690.00 557.71 6.418 8,132.29 135-60025-030-000 Water 2,000.00 2,000.00 59.01 107.40 5.370 1,892.60 135-60035-030-000 Postage 30,000.00 30,000.00 1,617.95 3,345.39 11.151 26,654.61 135-60040-030-000 Service Charges & Fees 55,560.00 55,560.00 5,333.10 12,232.37 22.017 43,327.63 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 12,605.46 19.393 52,394.54 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 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 48.00 3.727 1,240.00 December 17, 2018 Regular Meeting Agenda Packet 40 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 11 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 15,130.66 32,550.77 12.356 230,882.23 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 1,246.49 1,246.49 17.646 5,817.51 135-65085-030-000 Office Supplies 6,000.00 6,000.00 750.50 1,224.56 20.409 4,775.44 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 370.71 814.75 20.369 3,185.25 135-65105-030-000 Printing 2,500.00 2,500.00 2,500.00 Subtotal: 25,114.00 25,114.00 2,367.70 3,285.80 13.084 21,828.20 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 278.35 572.24 14.306 3,427.76 Subtotal: 284,000.00 284,000.00 278.35 572.24 .201 283,427.76 Program number: 1,559,905.00 1,559,905.00 94,460.39 208,518.88 13.367 1,351,386.12 Department number: Administration 1,559,905.00 1,559,905.00 94,460.39 208,518.88 13.367 1,351,386.12 December 17, 2018 Regular Meeting Agenda Packet 41 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 12 17:08 12/12/18 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 5,235.00 17,074.68 12.463 119,925.32 135-55055-039-000 Auditing 30,800.00 30,800.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 5,235.00 22,074.68 11.977 162,239.32 Program number: 184,314.00 184,314.00 5,235.00 22,074.68 11.977 162,239.32 Department number: Non Departmental 184,314.00 184,314.00 5,235.00 22,074.68 11.977 162,239.32 Expenditures Subtotal ----------- 10,271,365.00 10,271,365.00 617,894.49 1,237,029.16 12.043 9,034,335.84 Fund number: 135 MUD 1 General Fund 341,837.00- 341,837.00- 2,685.51- 106,813.12 -31.247 448,650.12- December 17, 2018 Regular Meeting Agenda Packet 42 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 13 17:08 12/12/18 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer-General Fund 105,000.00- 105,000.00 137-49146-000-000 Intergov Transfer-Fire Dept 81,420.00- 81,420.00 Subtotal: 186,420.00- 186,420.00 Program number: 186,420.00- 186,420.00 Department number: 186,420.00- 186,420.00 Revenues Subtotal ----------- 186,420.00- 186,420.00 Fund number: 137 MUD 1 Consolidated GASB 186,420.00- 186,420.00 December 17, 2018 Regular Meeting Agenda Packet 43 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 5 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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 342 11/01/2018 Property Taxes (1,964.94) (148.03) (2,112.97) GL 343 11/02/2018 Property Taxes (365.02) (2,477.99) GL 344 11/05/2018 Property Taxes (178.53) (2,656.52) GL 345 11/06/2018 Property Taxes (246.07) (2,902.59) GL 346 11/07/2018 Property Taxes (391.61) (3,294.20) GL 347 11/08/2018 Property Taxes (178.12) (3,472.32) GL 348 11/09/2018 Property Taxes (233.78) (3,706.10) GL 349 11/13/2018 Property Taxes (86.38) (3,792.48) GL 350 11/14/2018 Property Taxes (188.33) (3,980.81) GL 351 11/15/2018 Property Taxes (397.68) (4,378.49) GL 352 11/16/2018 Property Taxes (281.90) (4,660.39) GL 353 11/19/2018 Property Taxes (491.18) (5,151.57) GL 354 11/20/2018 Property Taxes (312.72) (5,464.29) GL 355 11/21/2018 Property Taxes (32.66) (5,496.95) GL 356 11/26/2018 Property Taxes (564.12) (6,061.07) GL 357 11/27/2018 Property Taxes (193.43) (6,254.50) GL 358 11/28/2018 Property Taxes (440.31) (6,694.81) GL 359 11/29/2018 Property Taxes (1,556.31) (8,251.12) GL 360 11/30/2018 Property Taxes (201.02) (8,452.14) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (6,487.20) (8,452.14) ** (132,384.00) Budgeted (123,931.86) Remaining 6 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 343 11/02/2018 Property Taxes (31.11) (2.17) (33.28) GL 345 11/06/2018 Property Taxes 2.23 (31.05) GL 346 11/07/2018 Property Taxes (18.21) (49.26) GL 350 11/14/2018 Property Taxes (8.17) (57.43) GL 354 11/20/2018 Property Taxes .76 (56.67) GL 360 11/30/2018 Property Taxes (.87) (57.54) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (26.43) (57.54) ** (300.00) Budgeted (242.46) Remaining 19 % Used Account: 135-40015-000-000 Property Taxes/P & I 343 11/02/2018 Property Taxes (4.23) (.53) (4.76) GL 346 11/07/2018 Property Taxes (7.35) (12.11) GL 347 11/08/2018 Property Taxes (.10) (12.21) GL 348 11/09/2018 Property Taxes (.14) (12.35) GL 349 11/13/2018 Property Taxes (.70) (13.05) GL December 17, 2018 Regular Meeting Agenda Packet 44 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 6 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 350 11/14/2018 Property Taxes (4.23) (.08) (13.13) GL 352 11/16/2018 Property Taxes (1.08) (14.21) GL 353 11/19/2018 Property Taxes (.09) (14.30) GL 360 11/30/2018 Property Taxes (.19) (14.49) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (10.26) (14.49) ** (300.00) Budgeted (285.51) Remaining 5 % 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 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (270,764.96) (325,801.18) (596,566.14) UB _______________ Account: 135-47000-000-000 Water Totals: (325,801.18) (596,566.14) ** (6,599,484.00) Budgeted (6,002,917.86) Remaining 9 % Used Account: 135-47005-000-000 Sewer 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (214,307.01) (265,819.47) (480,126.48) UB _______________ Account: 135-47005-000-000 Sewer Totals: (265,819.47) (480,126.48) ** (3,412,665.00) Budgeted (2,932,538.52) Remaining 14 % Used Account: 135-47025-000-000 Penalties 205 11/05/2018 UB 11/05/2018 Penalty Removal UB20181105-20181105 User: (9,876.08) 147.59 (9,728.49) UB 274 11/19/2018 UB 11/19/2018 Penalty Removal UB20181119-20181119 User: 4,188.92 (5,539.57) UB 289 11/21/2018 UB 11/21/2018 Penalties UB20181121-20181121 User: (14,973.99) (20,513.56) UB 309 11/27/2018 UB 11/27/2018 Penalty removal UB20181127-20181127 User: 366.63 (20,146.93) UB 314 11/29/2018 UB 11/29/2018 Penalty removal UB20181129-20181129 User: 127.25 (20,019.68) UB _______________ Account: 135-47025-000-000 Penalties Totals: (10,143.60) (20,019.68) ** (136,418.00) Budgeted (116,398.32) Remaining 15 % Used Account: 135-47030-000-000 Service Charges 204 11/01/2018 UB 11/01/2018 Returned NSF UB20181101-20181101 User: (1,425.00) (25.00) (1,450.00) UB December 17, 2018 Regular Meeting Agenda Packet 45 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 7 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 216 11/07/2018 UB 11/07/2018 Disconnect Fees UB20181107-20181107 User: (1,425.00) (1,100.00) (2,550.00) UB 253 11/15/2018 UB 11/15/2018 DF adjustment UB20181115-20181115 User: 50.00 (2,500.00) UB 301 11/21/2018 UB 11/21/2018 NSF Checks UB20181121-20181121 User: (50.00) (2,550.00) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (1,125.00) (2,550.00) ** (17,000.00) Budgeted (14,450.00) Remaining 15 % 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 (17.60) .00 (17.60) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (17.60) ** (60,000.00) Budgeted (59,982.40) Remaining 0 % Used Account: 135-49010-000-000 Interest Income 379 11/30/2018 Bank Interest- November (8,671.04) (940.54) (9,611.58) GL 379 11/30/2018 Bank Interest- November (7,193.48) (16,805.06) GL 403 11/30/2018 November Interest Pros Savings (967.43) (17,772.49) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (9,101.45) (17,772.49) ** (20,000.00) Budgeted (2,227.51) Remaining 89 % Used Account: 135-49016-000-000 Cell Tower Revenue 374 11/20/2018 Cell Tower Rev AT&T November (1,505.48) (1,178.81) (2,684.29) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (1,178.81) (2,684.29) ** (14,146.00) Budgeted (11,461.71) Remaining 19 % Used December 17, 2018 Regular Meeting Agenda Packet 46 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 8 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/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 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: (583.33) (583.33) (1,166.66) AR _______________ Account: 135-49018-000-000 Building Rent Income Totals: (583.33) (1,166.66) ** (7,000.00) Budgeted (5,833.34) Remaining 17 % 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 331 11/30/2018 UB 11/30/2018 Billing UB20181130-20181130 User: (485.26) (303.27) (788.53) UB _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (303.27) (788.53) ** (7,000.00) Budgeted (6,211.47) Remaining 11 % Used Department Totals: ----------------------------------- (1,130,216.04) ** (620,580.00) Monthly Total (10,613,202.00) Budgeted (9,482,985.96) Remaining 11 % Used December 17, 2018 Regular Meeting Agenda Packet 47 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 9 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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 140 11/02/2018 MUD Payroll 11/02/2018 Salaries & Wages 11,375.95 11,481.88 22,857.83 PR 234 11/16/2018 MUD Payroll 11/16/2018 Salaries & Wages 11,469.75 34,327.58 PR 304 11/30/2018 MUD Payroll 11/30/2018 Salaries & Wages 11,413.57 45,741.15 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 34,365.20 45,741.15 ** 326,755.00 Budgeted 281,013.85 Remaining 14 % Used Account: 135-50010-010-000 Overtime 140 11/02/2018 MUD Payroll 11/02/2018 Overtime 565.62 665.67 1,231.29 PR 234 11/16/2018 MUD Payroll 11/16/2018 Overtime 142.00 1,373.29 PR 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 482.75 1,856.04 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,290.42 1,856.04 ** 20,000.00 Budgeted 18,143.96 Remaining 9 % Used Account: 135-50016-010-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 3,620.00 3,620.00 PR _______________ Account: 135-50016-010-000 Longevity Totals: 3,620.00 3,620.00 ** 3,620.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 234 11/16/2018 MUD Payroll 11/16/2018 Certification 200.00 200.00 400.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 200.00 400.00 ** 4,800.00 Budgeted 4,400.00 Remaining 8 % Used Account: 135-50020-010-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 Retirement 2,174.42 1,123.65 3,298.07 PR 234 11/16/2018 MUD Payroll 11/16/2018 Retirement 1,092.58 4,390.65 PR 248 11/16/2018 Longevity 11/16/2018 Retirement 334.84 4,725.49 PR 304 11/30/2018 MUD Payroll 11/30/2018 Retirement 1,100.42 5,825.91 PR _______________ Account: 135-50020-010-000 Retirement Totals: 3,651.49 5,825.91 ** 33,304.00 Budgeted 27,478.09 Remaining 17 % Used Account: 135-50026-010-000 Medical Insurance December 17, 2018 Regular Meeting Agenda Packet 48 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 10 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medical Insurance 2,948.80 1,474.40 4,423.20 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medical Insurance 1,474.40 5,897.60 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,948.80 5,897.60 ** 74,818.00 Budgeted 68,920.40 Remaining 8 % Used Account: 135-50027-010-000 Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 213.65 106.85 320.50 PR 234 11/16/2018 MUD Payroll 11/16/2018 Dental Insurance 106.80 427.30 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 213.65 427.30 ** 4,317.00 Budgeted 3,889.70 Remaining 10 % Used Account: 135-50028-010-000 Vision Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Vision Insurance 35.92 17.98 53.90 PR 234 11/16/2018 MUD Payroll 11/16/2018 Vision Insurance 17.94 71.84 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 35.92 71.84 ** 701.00 Budgeted 629.16 Remaining 10 % Used Account: 135-50029-010-000 Life Insurance & Other 124 11/01/2018 November A/P Employee LTD & STD 197.61 87.01 284.62 METLIFE GROUP BENEFITS 4686 AP 124 11/01/2018 November A/P Employee Benefits 110.60 395.22 Humana Inc 4679 AP 302 11/26/2018 November A/P Caf 125 18.00 413.22 BenefitMall 4773 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 215.61 413.22 ** 3,131.00 Budgeted 2,717.78 Remaining 13 % Used Account: 135-50030-010-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 Social Security Taxes 741.36 745.78 1,487.14 PR 234 11/16/2018 MUD Payroll 11/16/2018 Social Security Taxes 719.60 2,206.74 PR 248 11/16/2018 Longevity 11/16/2018 Social Security Taxes 224.45 2,431.19 PR 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes 740.15 3,171.34 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 2,429.98 3,171.34 ** 22,021.00 Budgeted 18,849.66 Remaining 14 % Used Account: 135-50035-010-000 Medicare Taxes December 17, 2018 Regular Meeting Agenda Packet 49 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 11 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medicare Taxes 173.37 174.43 347.80 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medicare Taxes 168.29 516.09 PR 248 11/16/2018 Longevity 11/16/2018 Medicare Taxes 52.49 568.58 PR 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes 173.10 741.68 PR _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 568.31 741.68 ** 5,150.00 Budgeted 4,408.32 Remaining 14 % 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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 930.94 930.94 1,861.88 GL _______________ Account: 135-50045-010-000 Workman's Compensation Totals: 930.94 1,861.88 ** 12,895.00 Budgeted 11,033.12 Remaining 14 % 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 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 December 17, 2018 Regular Meeting Agenda Packet 50 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 12 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-55080-010-000 Maintenance & Repairs 255 11/15/2018 November A/P sample station valves 4,431.38 384.30 4,815.68 KORALEEN ENTERPRISES 4754 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 maintenance &repairs 42.85 4,858.53 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 maintenance & repairs 31.20 4,889.73 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 maintenance and repairs 77.88 4,967.61 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 repair supplies 161.86 5,129.47 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 repair supplies 86.06 5,215.53 THE HOME DEPOT 6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pipe repair supplies 101.76 5,317.29 THE HOME DEPOT #6581 PC _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 885.91 5,317.29 ** 100,000.00 Budgeted 94,682.71 Remaining 5 % Used Account: 135-55085-010-000 Generator Maint. and Repair 371 11/30/2018 November A/P Generator repair 943.00 943.00 Sluder Emergency Power Service 4804 AP _______________ Account: 135-55085-010-000 Generator Maint. and Repair Totals: 943.00 943.00 ** 3,000.00 Budgeted 2,057.00 Remaining 31 % Used Account: 135-55090-010-000 Vehicle Maintenance 324 11/26/2018 Pcard 10/27/18 - 11/26/18 inspection fee 723.46 7.50 730.96 DENTON VEHREG PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 fee for veh reg 2.00 732.96 TX.GOV SERVICEFEE- PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 brakes 34.48 767.44 AUTOZONE #4206 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 hardware kit 10.99 778.43 AUTOZONE #4206 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 safety inspection 7.00 785.43 KWIK KAR LUBE & TUNE O PC _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 61.97 785.43 ** 5,000.00 Budgeted 4,214.57 Remaining 16 % 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 December 17, 2018 Regular Meeting Agenda Packet 51 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 13 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-000 Lab Analysis 398 11/30/2018 November A/P water samples 407.70 200.00 607.70 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 200.00 607.70 ** 6,500.00 Budgeted 5,892.30 Remaining 9 % Used Account: 135-60010-010-000 Communications/Mobiles 255 11/15/2018 November A/P cell phones-November 370.98 251.95 622.93 VERIZON WIRELESS 4769 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone case 34.97 657.90 AMZN MKTP US*M85UV3RT1 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone case 30.96 688.86 AMAZON.COM*M86R03MY1 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 charger & screen protectors 49.37 738.23 AMZN MKTP US*M84RT4MF1 PC _______________ Account: 135-60010-010-000 Communications/Mobiles Totals: 367.25 738.23 ** 5,000.00 Budgeted 4,261.77 Remaining 15 % Used Account: 135-60020-010-000 Electricity 18,928.67 .00 18,928.67 _______________ Account: 135-60020-010-000 Electricity Totals: .00 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 drivers license renewal 120.00 69.00 189.00 TX DPS DL OFFICE PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 license renewal 111.00 300.00 TCEQ IND RENEWAL L PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 license renewal 111.00 411.00 TCEQ IND RENEWAL L PC December 17, 2018 Regular Meeting Agenda Packet 52 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 14 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-60080-010-000 Schools & Training Totals: 291.00 411.00 ** 4,651.00 Budgeted 4,240.00 Remaining 9 % 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 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 302 11/26/2018 November A/P Water system fee 7,685.65 7,685.65 TX COMMISSION ENVIRONMENTAL QU 4785 AP _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: 7,685.65 7,685.65 ** 58,000.00 Budgeted 50,314.35 Remaining 13 % Used Account: 135-60150-010-000 Wholesale Water 398 11/30/2018 November A/P wholesale water 136,507.63 136,507.63 CITY OF FORT WORTH AP _______________ Account: 135-60150-010-000 Wholesale Water Totals: 136,507.63 136,507.63 ** 3,013,494.00 Budgeted 2,876,986.37 Remaining 5 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 December 17, 2018 Regular Meeting Agenda Packet 53 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 15 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-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 371 11/30/2018 November A/P November mowing 1,340.00 750.00 2,090.00 WATTS ELLISON LLC 4813 AP _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: 750.00 2,090.00 ** 14,750.00 Budgeted 12,660.00 Remaining 14 % Used Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S 235 11/30/2018 TexPool Transfers November TexPool O&M to 16Swift Rev I&S 25,172.81 25,172.81 50,345.62 GL _______________ Account: 135-60332-010-000 Interfund Transfer Out-Rev I&S Totals: 25,172.81 50,345.62 ** 585,209.00 Budgeted 534,863.38 Remaining 9 % Used Account: 135-60333-010-000 Interfund Transfer Out-Reserve 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr 4,600.00 4,600.00 9,200.00 GL _______________ Account: 135-60333-010-000 Interfund Transfer Out-Reserve Totals: 4,600.00 9,200.00 ** 55,193.00 Budgeted 45,993.00 Remaining 17 % 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 December 17, 2018 Regular Meeting Agenda Packet 54 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 16 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-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 320 11/30/2018 A/P November Fuel Cards Fuel 643.17 933.72 1,576.89 US Bank Voyager Fleet Systems 4810 AP _______________ Account: 135-65005-010-000 Fuel & Lube Totals: 933.72 1,576.89 ** 15,000.00 Budgeted 13,423.11 Remaining 11 % Used Account: 135-65010-010-000 Uniforms 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 419.51 419.51 AMAZON.COM*M86H67Y60 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 shoes 166.49 586.00 RED WING SHOES #652 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 Uniforms 149.93 735.93 ACADEMY SPORTS #141 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 shoes 165.74 901.67 RED WING SHOES #652 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 shoes 165.74 1,067.41 RED WING SHOES #652 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 shoes 175.00 1,242.41 RED WING SHOES #652 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 Shoes 175.00 1,417.41 RED WING SHOES #652 PC _______________ Account: 135-65010-010-000 Uniforms Totals: 1,417.41 1,417.41 ** 5,190.00 Budgeted 3,772.59 Remaining 27 % Used Account: 135-65030-010-000 Chemicals 371 11/30/2018 November A/P testing supplies 2,724.11 741.91 3,466.02 HACH COMPANY 4793 AP 371 11/30/2018 November A/P LAS 434.64 3,900.66 Valley Solvent Company, INC 4812 AP 371 11/30/2018 November A/P chlorine 781.77 4,682.43 DPC INDUSTRIES, INC 4790 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 1,958.32 4,682.43 ** 20,000.00 Budgeted 15,317.57 Remaining 23 % 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 December 17, 2018 Regular Meeting Agenda Packet 55 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 17 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-010-000 Safety Equipment Totals: .00 .00 ** 1,000.00 Budgeted 1,000.00 Remaining 0 % Used Account: 135-65050-010-000 Meter Expense 255 11/15/2018 November A/P meter parts 55.80 55.80 ATLAS UTILITY SUPPLY CO. 4745 AP _______________ Account: 135-65050-010-000 Meter Expense Totals: 55.80 55.80 ** 70,000.00 Budgeted 69,944.20 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 399 11/30/2018 November A/P 16" water line phase II 18,533.35 12,084.25 30,617.60 Halff Associates, INC AP _______________ Account: 135-69005-010-000 Capital Outlays Totals: 12,084.25 30,617.60 ** 453,000.00 Budgeted 422,382.40 Remaining 7 % Used 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 75,000.00 .00 75,000.00 December 17, 2018 Regular Meeting Agenda Packet 56 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 18 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/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-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 75,000.00 ** 75,000.00 Budgeted .00 Remaining 100 % Used Account: 135-69281-010-000 Water Tank Inspection Contract 371 11/30/2018 November A/P Tank inspection 57,932.73 57,932.73 UTILITY SERVICE CO, INC. 4811 AP _______________ Account: 135-69281-010-000 Water Tank Inspection Contract Totals: 57,932.73 57,932.73 ** 120,000.00 Budgeted 62,067.27 Remaining 48 % Used December 17, 2018 Regular Meeting Agenda Packet 57 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 19 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: 1 Lab Analysis for PID Period Ending: 11/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 398 11/30/2018 November A/P water samples-pid 287.70 80.00 367.70 TARRANT CTY PUBLIC HEALTH LAB AP _______________ Account: 135-55135-010-001 Lab Analysis for PID Totals: 80.00 367.70 ** 2,000.00 Budgeted 1,632.30 Remaining 18 % Used Department 10 Totals: ----------------------------------- 475,238.74 ** 302,397.77 Monthly Total 5,641,834.00 Budgeted 5,166,595.26 Remaining 8 % Used December 17, 2018 Regular Meeting Agenda Packet 58 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 20 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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 140 11/02/2018 MUD Payroll 11/02/2018 Salaries & Wages 13,037.12 13,092.68 26,129.80 PR 234 11/16/2018 MUD Payroll 11/16/2018 Salaries & Wages 13,243.59 39,373.39 PR 304 11/30/2018 MUD Payroll 11/30/2018 Salaries & Wages 13,043.84 52,417.23 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 39,380.11 52,417.23 ** 421,699.00 Budgeted 369,281.77 Remaining 12 % Used Account: 135-50010-020-000 Overtime 140 11/02/2018 MUD Payroll 11/02/2018 Overtime 987.41 2,948.48 3,935.89 PR 234 11/16/2018 MUD Payroll 11/16/2018 Overtime 1,462.00 5,397.89 PR 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 1,227.60 6,625.49 PR _______________ Account: 135-50010-020-000 Overtime Totals: 5,638.08 6,625.49 ** 30,000.00 Budgeted 23,374.51 Remaining 22 % Used Account: 135-50016-020-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 7,445.00 7,445.00 PR _______________ Account: 135-50016-020-000 Longevity Totals: 7,445.00 7,445.00 ** 7,445.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-020-000 Certification 234 11/16/2018 MUD Payroll 11/16/2018 Certification 700.00 700.00 1,400.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 700.00 1,400.00 ** 8,700.00 Budgeted 7,300.00 Remaining 16 % Used Account: 135-50020-020-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 Retirement 2,878.72 1,483.80 4,362.52 PR 234 11/16/2018 MUD Payroll 11/16/2018 Retirement 1,425.02 5,787.54 PR 248 11/16/2018 Longevity 11/16/2018 Retirement 688.67 6,476.21 PR 304 11/30/2018 MUD Payroll 11/30/2018 Retirement 1,320.10 7,796.31 PR _______________ Account: 135-50020-020-000 Retirement Totals: 4,917.59 7,796.31 ** 43,276.00 Budgeted 35,479.69 Remaining 18 % Used Account: 135-50026-020-000 Medical Insurance December 17, 2018 Regular Meeting Agenda Packet 59 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 21 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medical Insurance 5,510.24 2,607.70 8,117.94 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medical Insurance 2,607.67 10,725.61 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 5,215.37 10,725.61 ** 91,627.00 Budgeted 80,901.39 Remaining 12 % Used Account: 135-50027-020-000 Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 371.89 185.96 557.85 PR 234 11/16/2018 MUD Payroll 11/16/2018 Dental Insurance 185.93 743.78 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 371.89 743.78 ** 5,104.00 Budgeted 4,360.22 Remaining 15 % Used Account: 135-50028-020-000 Vision Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Vision Insurance 58.90 29.46 88.36 PR 234 11/16/2018 MUD Payroll 11/16/2018 Vision Insurance 29.44 117.80 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 58.90 117.80 ** 826.00 Budgeted 708.20 Remaining 14 % Used Account: 135-50029-020-000 Life Insurance & Other 124 11/01/2018 November A/P Employee LTD & STD 285.20 120.84 406.04 METLIFE GROUP BENEFITS 4686 AP 124 11/01/2018 November A/P Employee Benefits 164.36 570.40 Humana Inc 4679 AP 302 11/26/2018 November A/P Caf 125 36.00 606.40 BenefitMall 4773 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 321.20 606.40 ** 4,495.00 Budgeted 3,888.60 Remaining 13 % Used Account: 135-50030-020-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 Social Security Taxes 821.24 929.06 1,750.30 PR 234 11/16/2018 MUD Payroll 11/16/2018 Social Security Taxes 869.32 2,619.62 PR 248 11/16/2018 Longevity 11/16/2018 Social Security Taxes 461.59 3,081.21 PR 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes 887.44 3,968.65 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 3,147.41 3,968.65 ** 29,006.00 Budgeted 25,037.35 Remaining 14 % Used Account: 135-50035-020-000 Medicare Taxes December 17, 2018 Regular Meeting Agenda Packet 60 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 22 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 140 11/02/2018 MUD Payroll 11/02/2018 Medicare Taxes 192.07 217.26 409.33 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medicare Taxes 203.31 612.64 PR 248 11/16/2018 Longevity 11/16/2018 Medicare Taxes 107.96 720.60 PR 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes 207.56 928.16 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 736.09 928.16 ** 6,784.00 Budgeted 5,855.84 Remaining 14 % 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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 1,205.73 1,205.73 2,411.46 GL _______________ Account: 135-50045-020-000 Workman's Compensation Totals: 1,205.73 2,411.46 ** 16,941.00 Budgeted 14,529.54 Remaining 14 % 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 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 December 17, 2018 Regular Meeting Agenda Packet 61 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 23 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-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 261 11/16/2018 November A/P Gate repair at WWTP 3,310.21 1,870.00 5,180.21 Alan's Gates, Inc. 4744 AP 302 11/26/2018 November A/P Socks and oil pads 138.39 5,318.60 Ritz Safety, LLC 4782 AP 302 11/26/2018 November A/P Bags 1,300.00 6,618.60 Huber Technology Inc 4775 AP 302 11/26/2018 November A/P man hole rehab 4,887.79 11,506.39 REY-MAR CONSTRUCTION 4781 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 broom, wd 40, echo pb kit 55.15 11,561.54 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 tape, faucet covers,bucket,etc 109.35 11,670.89 THE HOME DEPOT #6581 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 clear mint gal 4 156.93 11,827.82 WAGNER SUPPLY PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 drum pump kit 431.95 12,259.77 AMAZON.COM*M80XZ5BA2 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 filter replacement 288.43 12,548.20 FILTER ELEMENT STORE PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 maintenance & repairs 54.09 12,602.29 THE HOME DEPOT #6581 PC 371 11/30/2018 November A/P Pump disconnect MBR #2 490.00 13,092.29 DHS AUTOMATION, INC 4788 AP 371 11/30/2018 November A/P Shipping for pump to be repair 938.64 14,030.93 PostNet TX193 4803 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 10,720.72 14,030.93 ** 88,000.00 Budgeted 73,969.07 Remaining 16 % 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 returned battery 46.48 (35.00) 11.48 AUTOZONE #4206 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 batteries & fule inj hose 134.48 145.96 AUTOZONE #4206 PC _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: 99.48 145.96 ** 8,000.00 Budgeted 7,854.04 Remaining 2 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader .00 .00 December 17, 2018 Regular Meeting Agenda Packet 62 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 24 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-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 255 11/15/2018 November A/P sludge haul off 4,494.98 3,520.27 8,015.25 L.H. CHANEY MATERIALS, INC. 4755 AP 302 11/26/2018 November A/P sludge haul off 2,535.00 10,550.25 L.H. CHANEY MATERIALS, INC. 4777 AP 371 11/30/2018 November A/P sludge haul off 3,380.00 13,930.25 L.H. CHANEY MATERIALS, INC. 4800 AP 371 11/30/2018 November A/P sludge haul off 845.00 14,775.25 L.H. CHANEY MATERIALS, INC. 4800 AP _______________ Account: 135-55125-020-000 Dumpster Services Totals: 10,280.27 14,775.25 ** 75,000.00 Budgeted 60,224.75 Remaining 20 % Used Account: 135-55135-020-000 Lab Analysis 255 11/15/2018 November A/P sludge testing 4,627.46 1,367.50 5,994.96 OXIDOR LABORATORIES LLC 4764 AP 255 11/15/2018 November A/P effluent testing 246.00 6,240.96 OXIDOR LABORATORIES LLC 4764 AP 255 11/15/2018 November A/P effluent testing 176.00 6,416.96 OXIDOR LABORATORIES LLC 4764 AP 302 11/26/2018 November A/P Effluent testing 246.00 6,662.96 OXIDOR LABORATORIES LLC 4780 AP 302 11/26/2018 November A/P effluent testing 176.00 6,838.96 OXIDOR LABORATORIES LLC 4780 AP 371 11/30/2018 November A/P Effluent testing 246.00 7,084.96 OXIDOR LABORATORIES LLC 4802 AP 371 11/30/2018 November A/P Effluent testing 176.00 7,260.96 OXIDOR LABORATORIES LLC 4802 AP 371 11/30/2018 November A/P lab trays 230.96 7,491.92 IDEXX DISTRIBUTION, INC 4795 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,864.46 7,491.92 ** 35,000.00 Budgeted 27,508.08 Remaining 21 % Used Account: 135-60010-020-000 Communications/Mobiles 255 11/15/2018 November A/P cell phones-November 382.49 371.19 753.68 VERIZON WIRELESS 4769 AP _______________ Account: 135-60010-020-000 Communications/Mobiles Totals: 371.19 753.68 ** 5,000.00 Budgeted 4,246.32 Remaining 15 % Used Account: 135-60020-020-000 Electricity December 17, 2018 Regular Meeting Agenda Packet 63 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 25 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 398 11/30/2018 November A/P Electricity 10/23-11/27 24,917.76 184.64 25,102.40 TRI COUNTY ELECTRIC AP 398 11/30/2018 November A/P Electricity 10/23-11/27 348.24 25,450.64 TRI COUNTY ELECTRIC AP 398 11/30/2018 November A/P Electricity 10/23-11/27 28.25 25,478.89 TRI COUNTY ELECTRIC AP 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: (182.16) 25,296.73 AR _______________ Account: 135-60020-020-000 Electricity Totals: 378.97 25,296.73 ** 174,165.00 Budgeted 148,868.27 Remaining 15 % 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 69.00 .00 69.00 _______________ Account: 135-60070-020-000 Dues & Memberships Totals: .00 69.00 ** 300.00 Budgeted 231.00 Remaining 23 % Used Account: 135-60080-020-000 Schools & Training 111.00 .00 111.00 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 111.00 ** 7,155.00 Budgeted 7,044.00 Remaining 2 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ 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 December 17, 2018 Regular Meeting Agenda Packet 64 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 26 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-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 16,345.22 .00 16,345.22 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 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 6.98 .00 6.98 _______________ Account: 135-60280-020-000 Property Maintenance Totals: .00 6.98 ** 5,000.00 Budgeted 4,993.02 Remaining 0 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 371 11/30/2018 November A/P November mowing 590.00 590.00 WATTS ELLISON LLC 4813 AP _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: 590.00 590.00 ** 11,600.00 Budgeted 11,010.00 Remaining 5 % Used Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S December 17, 2018 Regular Meeting Agenda Packet 65 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 27 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 235 11/30/2018 TexPool Transfers November TexPool O&M to I&S- PID Debt 10,913.90 10,913.90 21,827.80 GL _______________ Account: 135-60331-020-000 Interfund Transfer Out-Tax I&S Totals: 10,913.90 21,827.80 ** 120,053.00 Budgeted 98,225.20 Remaining 18 % Used Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S 54,203.45 54,203.45 108,406.90 GL _______________ Account: 135-60332-020-000 Interfund Transfer Out-Rev I&S Totals: 54,203.45 108,406.90 ** 688,330.00 Budgeted 579,923.10 Remaining 16 % Used Account: 135-60333-020-000 Interfund Transfer Out-Reserve 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr 10,432.00 10,432.00 20,864.00 GL _______________ Account: 135-60333-020-000 Interfund Transfer Out-Reserve Totals: 10,432.00 20,864.00 ** 125,187.00 Budgeted 104,323.00 Remaining 17 % Used Account: 135-60334-020-000 Interfund Transfer Out 122,777.00 .00 122,777.00 _______________ Account: 135-60334-020-000 Interfund Transfer Out Totals: .00 122,777.00 ** 200,000.00 Budgeted 77,223.00 Remaining 61 % Used Account: 135-60360-020-000 Furniture/Equipment < $5000 .00 .00 _______________ 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 fuel 1,336.58 47.70 1,384.28 7-ELEVEN 32921 PC 320 11/30/2018 A/P November Fuel Cards Fuel 1,206.35 2,590.63 US Bank Voyager Fleet Systems 4810 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 1,254.05 2,590.63 ** 12,500.00 Budgeted 9,909.37 Remaining 21 % Used Account: 135-65010-020-000 Uniforms December 17, 2018 Regular Meeting Agenda Packet 66 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 28 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 1,035.41 86.95 1,122.36 ACADEMY SPORTS #81 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 119.93 1,242.29 ACADEMY SPORTS #81 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 110.93 1,353.22 ACADEMY SPORTS #81 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 80.97 1,434.19 #02 DICKIES OUTLET FW PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 143.49 1,577.68 WAL-MART #4240 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 waders 59.85 1,637.53 AMAZON.COM*M84SR2GT0 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 boots 164.99 1,802.52 ACADEMY SPORTS #141 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 pants 86.97 1,889.49 #02 DICKIES OUTLET FW PC _______________ Account: 135-65010-020-000 Uniforms Totals: 854.08 1,889.49 ** 5,495.00 Budgeted 3,605.51 Remaining 34 % Used Account: 135-65030-020-000 Chemicals 536.00 .00 536.00 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 536.00 ** 30,000.00 Budgeted 29,464.00 Remaining 2 % Used Account: 135-65035-020-000 Small Tools 324 11/26/2018 Pcard 10/27/18 - 11/26/18 sprayer 14.97 14.97 THE HOME DEPOT #6581 PC _______________ Account: 135-65035-020-000 Small Tools Totals: 14.97 14.97 ** 1,200.00 Budgeted 1,185.03 Remaining 1 % Used Account: 135-65040-020-000 Safety Equipment 302 11/26/2018 November A/P Raincotas and pants 181.32 241.64 422.96 Ritz Safety, LLC 4782 AP 302 11/26/2018 November A/P Pads 61.11 484.07 Ritz Safety, LLC 4782 AP 302 11/26/2018 November A/P raincoats and pants 68.11 552.18 Ritz Safety, LLC 4782 AP _______________ Account: 135-65040-020-000 Safety Equipment Totals: 370.86 552.18 ** 1,200.00 Budgeted 647.82 Remaining 46 % Used Account: 135-65045-020-000 Lab Supplies 371 11/30/2018 November A/P chemicals 733.07 75.20 808.27 HACH COMPANY 4793 AP 371 11/30/2018 November A/P oven calibration 1,627.50 2,435.77 TigerFrog Ventures, LLC 4807 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 1,702.70 2,435.77 ** 20,000.00 Budgeted 17,564.23 Remaining 12 % Used December 17, 2018 Regular Meeting Agenda Packet 67 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 29 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/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-020-000 Capital Outlays 218 11/07/2018 November A/P Decal for Vac truck 2,589.58 95.00 2,684.58 M-KAM LTD. 4729 AP 255 11/15/2018 November A/P LS upgrades 37,353.00 40,037.58 DHS AUTOMATION, INC 4748 AP 371 11/30/2018 November A/P Legal WWTP 1,530.00 41,567.58 Dubois Bryant Campbell LLP 4791 AP 398 11/30/2018 November A/P VFD Publication 863.40 42,430.98 Star-Telegram Media AP 399 11/30/2018 November A/P WWTP watersystem 394.34 42,825.32 Halff Associates, INC AP 399 11/30/2018 November A/P LS #1 easement 1,375.00 44,200.32 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 135-69005-020-000 Capital Outlays Totals: 41,610.74 44,200.32 ** 330,000.00 Budgeted 285,799.68 Remaining 13 % 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 30,000.00 .00 30,000.00 _______________ Account: 135-69195-020-000 Gasb34/Reserve for Replacement Totals: .00 30,000.00 ** 30,000.00 Budgeted .00 Remaining 100 % Used Department 20 Totals: ----------------------------------- 530,897.62 ** 215,799.21 Monthly Total 2,872,082.00 Budgeted 2,341,184.38 Remaining 18 % Used December 17, 2018 Regular Meeting Agenda Packet 68 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 30 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 2.12 2.12 4.24 GL _______________ Account: 135-50045-026-000 Workman's Compensation Totals: 2.12 4.24 ** 30.00 Budgeted 25.76 Remaining 14 % 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 295.00 .00 295.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .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 December 17, 2018 Regular Meeting Agenda Packet 69 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 31 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/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: ----------------------------------- 299.24 ** 2.12 Monthly Total 13,230.00 Budgeted 12,930.76 Remaining 2 % Used December 17, 2018 Regular Meeting Agenda Packet 70 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 32 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 140 11/02/2018 MUD Payroll 11/02/2018 Salaries & Wages 13,370.27 14,112.76 27,483.03 PR 234 11/16/2018 MUD Payroll 11/16/2018 Salaries & Wages 14,150.86 41,633.89 PR 304 11/30/2018 MUD Payroll 11/30/2018 Salaries & Wages 14,155.70 55,789.59 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 42,419.32 55,789.59 ** 441,006.00 Budgeted 385,216.41 Remaining 13 % Used Account: 135-50010-030-000 Overtime 304 11/30/2018 MUD Payroll 11/30/2018 Overtime 3.16 3.16 6.32 PR _______________ Account: 135-50010-030-000 Overtime Totals: 3.16 6.32 ** 2,000.00 Budgeted 1,993.68 Remaining 0 % Used Account: 135-50016-030-000 Longevity 248 11/16/2018 Longevity 11/16/2018 Longevity 1,832.50 1,832.50 PR _______________ Account: 135-50016-030-000 Longevity Totals: 1,832.50 1,832.50 ** 1,833.00 Budgeted .50 Remaining 100 % Used Account: 135-50020-030-000 Retirement 140 11/02/2018 MUD Payroll 11/02/2018 Retirement 2,597.25 1,305.42 3,902.67 PR 234 11/16/2018 MUD Payroll 11/16/2018 Retirement 1,308.96 5,211.63 PR 248 11/16/2018 Longevity 11/16/2018 Retirement 169.50 5,381.13 PR 304 11/30/2018 MUD Payroll 11/30/2018 Retirement 1,309.70 6,690.83 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,093.58 6,690.83 ** 41,148.00 Budgeted 34,457.17 Remaining 16 % Used Account: 135-50026-030-000 Medical Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Medical Insurance 4,145.24 2,072.63 6,217.87 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medical Insurance 2,072.61 8,290.48 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,145.24 8,290.48 ** 81,895.00 Budgeted 73,604.52 Remaining 10 % Used Account: 135-50027-030-000 Dental Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Dental Insurance 259.52 129.78 389.30 PR December 17, 2018 Regular Meeting Agenda Packet 71 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 33 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 234 11/16/2018 MUD Payroll 11/16/2018 Dental Insurance 259.52 129.74 519.04 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 259.52 519.04 ** 4,291.00 Budgeted 3,771.96 Remaining 12 % Used Account: 135-50028-030-000 Vision Insurance 140 11/02/2018 MUD Payroll 11/02/2018 Vision Insurance 42.51 21.28 63.79 PR 234 11/16/2018 MUD Payroll 11/16/2018 Vision Insurance 21.23 85.02 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 42.51 85.02 ** 701.00 Budgeted 615.98 Remaining 12 % Used Account: 135-50029-030-000 Life Insurance & Other 124 11/01/2018 November A/P Employee LTD & STD 264.49 119.45 383.94 METLIFE GROUP BENEFITS 4686 AP 124 11/01/2018 November A/P Employee Benefits 145.04 528.98 Humana Inc 4679 AP 302 11/26/2018 November A/P Caf 125 18.00 546.98 BenefitMall 4773 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 282.49 546.98 ** 4,495.00 Budgeted 3,948.02 Remaining 12 % Used Account: 135-50030-030-000 Social Security Taxes 140 11/02/2018 MUD Payroll 11/02/2018 Social Security Taxes 788.49 836.99 1,625.48 PR 234 11/16/2018 MUD Payroll 11/16/2018 Social Security Taxes 836.70 2,462.18 PR 248 11/16/2018 Longevity 11/16/2018 Social Security Taxes 113.61 2,575.79 PR 304 11/30/2018 MUD Payroll 11/30/2018 Social Security Taxes 877.84 3,453.63 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,665.14 3,453.63 ** 27,580.00 Budgeted 24,126.37 Remaining 13 % Used Account: 135-50035-030-000 Medicare Taxes 140 11/02/2018 MUD Payroll 11/02/2018 Medicare Taxes 184.40 195.76 380.16 PR 234 11/16/2018 MUD Payroll 11/16/2018 Medicare Taxes 195.67 575.83 PR 248 11/16/2018 Longevity 11/16/2018 Medicare Taxes 26.57 602.40 PR 304 11/30/2018 MUD Payroll 11/30/2018 Medicare Taxes 205.32 807.72 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 623.32 807.72 ** 6,450.00 Budgeted 5,642.28 Remaining 13 % Used Account: 135-50040-030-000 Unemployment Taxes December 17, 2018 Regular Meeting Agenda Packet 72 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 34 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 106.55 106.55 213.10 GL _______________ Account: 135-50045-030-000 Workman's Compensation Totals: 106.55 213.10 ** 1,295.00 Budgeted 1,081.90 Remaining 16 % 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 halloween decor 4.87 4.87 MICHAELS STORES 5062 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 halloween decor 12.97 17.84 JOANN STORES #2035 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 halloween decor 7.58 25.42 DOLLAR TREE PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 halloween decor & candy 26.97 52.39 WAL-MART #0266 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 halloween 8.86 61.25 DOLLAR GENERAL #12244 PC 377 11/29/2018 Employee Reimbur Pcard Usage (8.86) 52.39 GL _______________ Account: 135-50070-030-000 Employee Relations Totals: 52.39 52.39 ** 5,000.00 Budgeted 4,947.61 Remaining 1 % Used Account: 135-55030-030-000 Software & Support 218 11/07/2018 November A/P Internet-November 61,104.08 903.72 62,007.80 Charter Communications 4713 AP 255 11/15/2018 November A/P Microsoft exchange 504.00 62,511.80 M3 Networks 4758 AP 261 11/16/2018 November A/P Annual software support 2019 5,180.75 67,692.55 MCCI 4760 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 internet 69.12 67,761.67 ATT*BILL PAYMENT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 internet 107.79 67,869.46 ATT*BILL PAYMENT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 internet 124.34 67,993.80 ATT*BILL PAYMENT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 internet 85.70 68,079.50 ATT*BILL PAYMENT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 adobe 32.45 68,111.95 ADOBE INC PC _______________ Account: 135-55030-030-000 Software & Support Totals: 7,007.87 68,111.95 ** 77,849.00 Budgeted 9,737.05 Remaining 87 % Used December 17, 2018 Regular Meeting Agenda Packet 73 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 35 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-55070-030-000 Independent Labor 371 11/30/2018 November A/P GM November 11,666.14 29.43 11,695.57 Carman Consulting LLC. 4786 AP 371 11/30/2018 November A/P GM November 9,680.00 21,375.57 Carman Consulting LLC. 4786 AP 371 11/30/2018 November A/P Audist consulting 1,991.33 23,366.90 DOROTHY RENAE GONZALES 4789 AP _______________ Account: 135-55070-030-000 Independent Labor Totals: 11,700.76 23,366.90 ** 175,000.00 Budgeted 151,633.10 Remaining 13 % Used Account: 135-55080-030-000 Maintenance & Repairs 315.00 .00 315.00 _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: .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 302 11/26/2018 November A/P October janitorial 869.06 869.06 MEMBER'S BUILDING MAINTENANCE 4778 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 869.06 869.06 ** 10,000.00 Budgeted 9,130.94 Remaining 9 % 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 Account: 135-55205-030-000 Utility Billing Contract 398 11/30/2018 November A/P November billings 579.29 580.27 1,159.56 DATAPROSE LLC AP _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 580.27 1,159.56 ** 9,000.00 Budgeted 7,840.44 Remaining 13 % Used December 17, 2018 Regular Meeting Agenda Packet 74 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 36 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60005-030-000 Telephone 218 11/07/2018 November A/P answering service-November 1,423.08 207.75 1,630.83 KEYSTONE PARK SECRETARIAL 4725 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone 192.68 1,823.51 ATT*BILL PAYMENT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone 861.43 2,684.94 ATT*BUS PHONE PMT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone 461.53 3,146.47 ATT*BUS PHONE PMT PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 phone 12.99 3,159.46 RINGCENTRAL, INC PC 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: (180.00) 2,979.46 AR _______________ Account: 135-60005-030-000 Telephone Totals: 1,556.38 2,979.46 ** 23,500.00 Budgeted 20,520.54 Remaining 13 % Used Account: 135-60010-030-000 Communications/Mobiles 255 11/15/2018 November A/P cell phones-November 237.49 87.49 324.98 VERIZON WIRELESS 4769 AP 234 11/16/2018 MUD Payroll 11/16/2018 Communications/Mobiles 150.00 474.98 PR _______________ Account: 135-60010-030-000 Communications/Mobiles Totals: 237.49 474.98 ** 4,000.00 Budgeted 3,525.02 Remaining 12 % Used Account: 135-60020-030-000 Electricity/Gas 557.71 .00 557.71 _______________ Account: 135-60020-030-000 Electricity/Gas Totals: .00 557.71 ** 8,690.00 Budgeted 8,132.29 Remaining 6 % Used Account: 135-60025-030-000 Water 371 11/30/2018 November A/P Water-November 48.39 118.02 166.41 TROPHY CLUB MUD (WATER BILLS) 4808 AP 400 11/30/2018 Town Billed Invoices 1664-1667 AR 20181130-20181130 User: (59.01) 107.40 AR _______________ Account: 135-60025-030-000 Water Totals: 59.01 107.40 ** 2,000.00 Budgeted 1,892.60 Remaining 5 % Used Account: 135-60035-030-000 Postage 398 11/30/2018 November A/P November billings 1,727.44 1,617.95 3,345.39 DATAPROSE LLC AP _______________ Account: 135-60035-030-000 Postage Totals: 1,617.95 3,345.39 ** 30,000.00 Budgeted 26,654.61 Remaining 11 % Used Account: 135-60040-030-000 Service Charges & Fees December 17, 2018 Regular Meeting Agenda Packet 75 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 37 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 143 11/02/2018 Child Support Fee 6,899.27 1.50 6,900.77 GL 236 11/16/2018 Child Support Fee 1.50 6,902.27 GL 306 11/30/2018 Child Support Fee 1.50 6,903.77 GL 371 11/30/2018 November A/P Direct send fees 50.00 6,953.77 Fiserv Solutions, LLC 4792 AP 376 11/30/2018 Pace Credit Card Fees 4,948.26 11,902.03 GL 376 11/30/2018 Pace Credit Card Fees 138.44 12,040.47 GL 399 11/30/2018 November A/P Service fees 191.90 12,232.37 Texas Excavation Safety System AP _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 5,333.10 12,232.37 ** 55,560.00 Budgeted 43,327.63 Remaining 22 % 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 126 11/01/2018 Insurance/Wrk Comp Expense Nov 6,302.73 6,302.73 12,605.46 GL _______________ Account: 135-60055-030-000 Insurance Totals: 6,302.73 12,605.46 ** 65,000.00 Budgeted 52,394.54 Remaining 19 % 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 200.00 .00 200.00 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 200.00 ** 6,000.00 Budgeted 5,800.00 Remaining 3 % Used Account: 135-60075-030-000 Meetings .00 .00 December 17, 2018 Regular Meeting Agenda Packet 76 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 38 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60075-030-000 Meetings 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 _______________ 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 302 11/26/2018 November A/P monitoring service 24.00 24.00 48.00 Digital Air Control, Inc 4774 AP December 17, 2018 Regular Meeting Agenda Packet 77 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 39 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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-60235-030-000 Security Totals: 24.00 48.00 ** 1,288.00 Budgeted 1,240.00 Remaining 4 % 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 fans, battery, capacitor 672.76 672.76 LEIGHTRONIX INC PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 inspection 250.00 922.76 LEIGHTRONIX INC PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 recording server 323.73 1,246.49 THE UPS STORE #3653 PC _______________ Account: 135-65055-030-000 Hardware Totals: 1,246.49 1,246.49 ** 7,064.00 Budgeted 5,817.51 Remaining 18 % Used Account: 135-65085-030-000 Office Supplies December 17, 2018 Regular Meeting Agenda Packet 78 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 40 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 302 11/26/2018 November A/P Business cards-mike, steven, d 474.06 216.85 690.91 SIGMA SIGNS & PRINTING 4783 AP 302 11/26/2018 November A/P office supplies 176.05 866.96 OFFICE DEPOT, INC 4779 AP 302 11/26/2018 November A/P Return of file boxes (74.16) 792.80 OFFICE DEPOT, INC 4779 AP 324 11/26/2018 Pcard 10/27/18 - 11/26/18 plates 20.00 812.80 KELLER TROPHY & AWAR PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 lifecam studio for business 49.80 862.60 AMZN MKTP US*M81UU3YC1 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 battery backups 148.00 1,010.60 AMZN MKTP US*M85KN67O2 PC 398 11/30/2018 November A/P office supplies 94.14 1,104.74 OFFICE DEPOT, INC AP 398 11/30/2018 November A/P office supplies 5.86 1,110.60 OFFICE DEPOT, INC AP 398 11/30/2018 November A/P office supplies 44.99 1,155.59 OFFICE DEPOT, INC AP 398 11/30/2018 November A/P office supplies 68.97 1,224.56 OFFICE DEPOT, INC AP _______________ Account: 135-65085-030-000 Office Supplies Totals: 750.50 1,224.56 ** 6,000.00 Budgeted 4,775.44 Remaining 20 % 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 324 11/26/2018 Pcard 10/27/18 - 11/26/18 febreeze 444.04 34.45 478.49 SAMSCLUB #6781 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 cleaning supplies, paper goods 175.62 654.11 SAMSCLUB.COM PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 coffee supplies 19.23 673.34 AMZN MKTP US*M80NS6YI0 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 coffee supplies 27.44 700.78 AMZN MKTP US*M854Y9IQ0 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 cleaning supplies 12.76 713.54 WAL-MART #2834 PC 324 11/26/2018 Pcard 10/27/18 - 11/26/18 coffee supplies 101.21 814.75 AMZN MKTP US*M88R38M30 PC _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 370.71 814.75 ** 4,000.00 Budgeted 3,185.25 Remaining 20 % 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 Account: 135-69005-030-000 Capital Outlays .00 .00 December 17, 2018 Regular Meeting Agenda Packet 79 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 41 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/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 Totals: .00 .00 ** 280,000.00 Budgeted 280,000.00 Remaining 0 % Used Account: 135-69170-030-000 Copier Lease Installments 302 11/26/2018 November A/P copies 293.89 84.35 378.24 KYOCERA DOCUMENT SOLUTIONS 4776 AP 302 11/26/2018 November A/P Copier Lease-Nov 194.00 572.24 TIAA COMMERCIAL FINANCE 4784 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 278.35 572.24 ** 4,000.00 Budgeted 3,427.76 Remaining 14 % Used Department 30 Totals: ----------------------------------- 208,518.88 ** 94,460.39 Monthly Total 1,559,905.00 Budgeted 1,351,386.12 Remaining 13 % Used December 17, 2018 Regular Meeting Agenda Packet 80 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 42 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/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 398 11/30/2018 November A/P legal 11,839.68 4,110.00 15,949.68 McLean & Howard, L.L.P. AP 398 11/30/2018 November A/P Legal 1,125.00 17,074.68 McLean & Howard, L.L.P. AP _______________ Account: 135-55045-039-000 Legal Totals: 5,235.00 17,074.68 ** 137,000.00 Budgeted 119,925.32 Remaining 12 % Used Account: 135-55055-039-000 Auditing 5,000.00 .00 5,000.00 _______________ Account: 135-55055-039-000 Auditing Totals: .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: ----------------------------------- 22,074.68 ** 5,235.00 Monthly Total 184,314.00 Budgeted 162,239.32 Remaining 12 % Used Fund 135 Totals: ----------------------------------- 106,813.12 (2,685.51) Monthly Total (341,837.00) Budgeted (448,650.12) Remaining -31 % Used December 17, 2018 Regular Meeting Agenda Packet 81 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 43 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2018 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 137-49145-000-000 Intergov Transfer-General Fund (105,000.00) .00 (105,000.00) _______________ Account: 137-49145-000-000 Intergov Transfer-General Fund Totals: .00 (105,000.00) ** .00 Budgeted 105,000.00 Remaining 0 % Used Account: 137-49146-000-000 Intergov Transfer-Fire Dept (81,420.00) .00 (81,420.00) _______________ Account: 137-49146-000-000 Intergov Transfer-Fire Dept Totals: .00 (81,420.00) ** .00 Budgeted 81,420.00 Remaining 0 % Used Department Totals: ----------------------------------- (186,420.00) ** .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used Fund 137 Totals: ----------------------------------- (186,420.00) .00 Monthly Total .00 Budgeted 186,420.00 Remaining 0 % Used December 17, 2018 Regular Meeting Agenda Packet 82 of 126 TROPHY CLUB MUD #1 - TAX BOND CONSTRUCTION BALANCE SHEET NOVEMBER 2018 517 ASSETS CONSTRUCTION FUND CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE - TOTAL ASSETS - LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,434,911 TOTAL LIABILITIES 1,434,911 FUND BALANCE ASSIGNED FUND BALANCE (1,479,465) NET REVENUES / EXPENDITURES 44,554 TOTAL FUND BALANCE (1,434,911) TOTAL LIABILITIES AND FUND BALANCE - December 17, 2018 Regular Meeting Agenda Packet 83 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 14 17:08 12/12/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/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 Subtotal: 7.29- 7.29 Program number: 7.29- 7.29 Department number: Revenues 7.29- 7.29 December 17, 2018 Regular Meeting Agenda Packet 84 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 15 17:08 12/12/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/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 Subtotal: 122,777.00- 122,777.00 Program number: 122,777.00- 122,777.00 Department number: Wastewater 122,777.00- 122,777.00 Revenues Subtotal ----------- 122,784.29- 122,784.29 December 17, 2018 Regular Meeting Agenda Packet 85 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 16 17:08 12/12/18 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/2018 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 517-69005-020-000 Capital Outlays 35,568.08 78,230.58 78,230.58- Subtotal: 35,568.08 78,230.58 78,230.58- Program number: 35,568.08 78,230.58 78,230.58- Department number: Wastewater 35,568.08 78,230.58 78,230.58- Expenditures Subtotal ----------- 35,568.08 78,230.58 78,230.58- Fund number: 517 2014 MUD 1 Tax Bond Const WWTP 35,568.08 44,553.71- 44,553.71 December 17, 2018 Regular Meeting Agenda Packet 86 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 44 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/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 (7.29) .00 (7.29) _______________ Account: 517-49010-000-000 Interest Income Totals: .00 (7.29) ** .00 Budgeted 7.29 Remaining 0 % Used Department Totals: ----------------------------------- (7.29) ** .00 Monthly Total .00 Budgeted 7.29 Remaining 0 % Used December 17, 2018 Regular Meeting Agenda Packet 87 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 45 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: 20 Wastewater Program: Period Ending: 11/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 (122,777.00) .00 (122,777.00) _______________ Account: 517-49141-020-000 Interfund Transfers In Gen Totals: .00 (122,777.00) ** .00 Budgeted 122,777.00 Remaining 0 % Used Account: 517-69005-020-000 Capital Outlays 371 11/30/2018 November A/P WWTP Improvements 42,662.50 24,590.79 67,253.29 WEBBER-CADAGUA PARTNERS 4814 AP 399 11/30/2018 November A/P WWTP Improvements 10,977.29 78,230.58 CP&Y/WALLACE GROUP, INC. AP _______________ Account: 517-69005-020-000 Capital Outlays Totals: 35,568.08 78,230.58 ** .00 Budgeted (78,230.58) Remaining 0 % Used Department 20 Totals: ----------------------------------- (44,546.42) ** 35,568.08 Monthly Total .00 Budgeted 44,546.42 Remaining 0 % Used Fund 517 Totals: ----------------------------------- (44,553.71) 35,568.08 Monthly Total .00 Budgeted 44,553.71 Remaining 0 % Used December 17, 2018 Regular Meeting Agenda Packet 88 of 126 TROPHY CLUB MUD #1 - REVENUE BOND CONSTRUCTION SWIFT FUNDING BALANCE SHEET NOVEMBER 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 December 17, 2018 Regular Meeting Agenda Packet 89 of 126 TROPHY CLUB MUD #1 - 16" WATERLINE FUTURE REVENUE BOND BALANCE SHEET NOVEMBER 2018 520 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS - ACCOUNTS RECEIVABLE 45,000 TOTAL ASSETS 45,000 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 411,246 TOTAL LIABILITIES 411,246 FUND BALANCE ASSIGNED FUND BALANCE (366,246) NET REVENUES / EXPENDITURES - TOTAL FUND BALANCE (366,246) TOTAL LIABILITIES AND FUND BALANCE 45,000 December 17, 2018 Regular Meeting Agenda Packet 90 of 126 TROPHY CLUB MUD #1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2018 528 ASSETS REVENUE BOND RESERVE CASH IN BANK - INVESTMENTS 639,210 ACCOUNTS RECEIVABLE - TOTAL ASSETS 639,210 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 606,910 NET REVENUES / EXPENDITURES 32,300 TOTAL FUND BALANCE 639,210 TOTAL LIABILITIES AND FUND BALANCE 639,210 December 17, 2018 Regular Meeting Agenda Packet 91 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 17 17:08 12/12/18 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/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,129.97- 2,235.92- 44.718 2,764.08- 528-49142-000-000 Interfund transfer in-Water 55,193.00- 55,193.00- 4,600.00- 9,200.00- 16.669 45,993.00- 528-49143-000-000 Interfund transfer in-WW 125,187.00- 125,187.00- 10,432.00- 20,864.00- 16.666 104,323.00- Subtotal: 185,380.00- 185,380.00- 16,161.97- 32,299.92- 17.424 153,080.08- Program number: 185,380.00- 185,380.00- 16,161.97- 32,299.92- 17.424 153,080.08- Department number: 185,380.00- 185,380.00- 16,161.97- 32,299.92- 17.424 153,080.08- Revenues Subtotal ----------- 185,380.00- 185,380.00- 16,161.97- 32,299.92- 17.424 153,080.08- Fund number: 528 2015 Revenue Bond Reserve Fund 185,380.00- 185,380.00- 16,161.97- 32,299.92- 17.424 153,080.08- December 17, 2018 Regular Meeting Agenda Packet 92 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 46 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/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 379 11/30/2018 Bank Interest- November (1,105.95) (1,129.97) (2,235.92) GL _______________ Account: 528-49010-000-000 Interest Income Totals: (1,129.97) (2,235.92) ** (5,000.00) Budgeted (2,764.08) Remaining 45 % Used Account: 528-49142-000-000 Interfund transfer in-Water 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr (4,600.00) (4,600.00) (9,200.00) GL _______________ Account: 528-49142-000-000 Interfund transfer in-Water Totals: (4,600.00) (9,200.00) ** (55,193.00) Budgeted (45,993.00) Remaining 17 % Used Account: 528-49143-000-000 Interfund transfer in-WW 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bond Resevr (10,432.00) (10,432.00) (20,864.00) GL _______________ Account: 528-49143-000-000 Interfund transfer in-WW Totals: (10,432.00) (20,864.00) ** (125,187.00) Budgeted (104,323.00) Remaining 17 % Used Department Totals: ----------------------------------- (32,299.92) ** (16,161.97) Monthly Total (185,380.00) Budgeted (153,080.08) Remaining 17 % Used Fund 528 Totals: ----------------------------------- (32,299.92) (16,161.97) Monthly Total (185,380.00) Budgeted (153,080.08) Remaining 17 % Used December 17, 2018 Regular Meeting Agenda Packet 93 of 126 TROPHY CLUB MUD #1 - I&S BALANCE SHEET NOVEMBER 2018 INTEREST & SINKING- 533 ASSETS CASH IN BANK 4,573 INVESTMENTS 116,821 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 651,739 ACCOUNTS RECEIVABLE-OTHER - TOTAL ASSETS 773,133 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 651,739 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 651,739 FUND BALANCE ASSIGNED FUND BALANCE 53,289 NET REVENUES / EXPENDITURES 68,105 TOTAL FUND BALANCE 121,394 TOTAL LIABILITIES AND FUND BALANCE 773,133 December 17, 2018 Regular Meeting Agenda Packet 94 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 18 17:08 12/12/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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- 35,056.03- 45,674.43- 6.647 641,500.57- 533-40002-000-000 Property Taxes/Delinquent 1,800.00- 1,800.00- 145.52- 318.36- 17.687 1,481.64- 533-40015-000-000 Property Taxes/P & I 2,000.00- 2,000.00- 24.88- 46.49- 2.325 1,953.51- Subtotal: 690,975.00- 690,975.00- 35,226.43- 46,039.28- 6.663 644,935.72- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 146.45- 237.93- 11.897 1,762.07- 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- 21,827.80- 18.182 98,225.20- Subtotal: 338,032.00- 338,032.00- 11,060.35- 22,065.73- 6.528 315,966.27- Program number: 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99- Department number: Revenues 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99- Revenues Subtotal ----------- 1,029,007.00- 1,029,007.00- 46,286.78- 68,105.01- 6.619 960,901.99- December 17, 2018 Regular Meeting Agenda Packet 95 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 19 17:08 12/12/18 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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- 46,286.78- 68,105.01- 1,174.427 62,306.01 December 17, 2018 Regular Meeting Agenda Packet 96 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 47 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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 342 11/01/2018 Property Taxes (10,618.40) (799.95) (11,418.35) GL 343 11/02/2018 Property Taxes (1,972.52) (13,390.87) GL 344 11/05/2018 Property Taxes (964.76) (14,355.63) GL 345 11/06/2018 Property Taxes (1,329.71) (15,685.34) GL 346 11/07/2018 Property Taxes (2,116.22) (17,801.56) GL 347 11/08/2018 Property Taxes (962.54) (18,764.10) GL 348 11/09/2018 Property Taxes (1,263.30) (20,027.40) GL 349 11/13/2018 Property Taxes (466.76) (20,494.16) GL 350 11/14/2018 Property Taxes (1,017.70) (21,511.86) GL 351 11/15/2018 Property Taxes (2,149.02) (23,660.88) GL 352 11/16/2018 Property Taxes (1,523.36) (25,184.24) GL 353 11/19/2018 Property Taxes (2,654.29) (27,838.53) GL 354 11/20/2018 Property Taxes (1,689.84) (29,528.37) GL 355 11/21/2018 Property Taxes (176.48) (29,704.85) GL 356 11/26/2018 Property Taxes (3,048.43) (32,753.28) GL 357 11/27/2018 Property Taxes (1,045.27) (33,798.55) GL 358 11/28/2018 Property Taxes (2,379.40) (36,177.95) GL 359 11/29/2018 Property Taxes (8,410.19) (44,588.14) GL 360 11/30/2018 Property Taxes (1,086.29) (45,674.43) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (35,056.03) (45,674.43) ** (687,175.00) Budgeted (641,500.57) Remaining 7 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 343 11/02/2018 Property Taxes (172.84) (12.04) (184.88) GL 345 11/06/2018 Property Taxes 13.22 (171.66) GL 346 11/07/2018 Property Taxes (100.85) (272.51) GL 350 11/14/2018 Property Taxes (45.22) (317.73) GL 354 11/20/2018 Property Taxes 4.18 (313.55) GL 360 11/30/2018 Property Taxes (4.81) (318.36) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (145.52) (318.36) ** (1,800.00) Budgeted (1,481.64) Remaining 18 % Used Account: 533-40015-000-000 Property Taxes/P & I 343 11/02/2018 Property Taxes (21.61) (2.64) (24.25) GL 346 11/07/2018 Property Taxes (21.18) (45.43) GL 360 11/30/2018 Property Taxes (1.06) (46.49) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (24.88) (46.49) ** (2,000.00) Budgeted (1,953.51) Remaining 2 % Used December 17, 2018 Regular Meeting Agenda Packet 97 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 48 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/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 379 11/30/2018 Bank Interest- November (91.48) (146.45) (237.93) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (146.45) (237.93) ** (2,000.00) Budgeted (1,762.07) Remaining 12 % 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 235 11/30/2018 TexPool Transfers November TexPool O&M to I&S- PID Debt (10,913.90) (10,913.90) (21,827.80) GL _______________ Account: 533-49141-000-000 Interfund Trans In-PID Surchg Totals: (10,913.90) (21,827.80) ** (120,053.00) Budgeted (98,225.20) Remaining 18 % Used Department Totals: ----------------------------------- (68,105.01) ** (46,286.78) Monthly Total (1,029,007.00) Budgeted (960,901.99) Remaining 7 % Used December 17, 2018 Regular Meeting Agenda Packet 98 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 49 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/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: ----------------------------------- (68,105.01) (46,286.78) Monthly Total (5,799.00) Budgeted 62,306.01 Remaining ########## December 17, 2018 Regular Meeting Agenda Packet 99 of 126 TROPHY CLUB MUD #1 - REVENUE BOND I&S BALANCE SHEET NOVEMBER 2018 534 ASSETS REVENUE BOND I&S CASH IN BANK - INVESTMENTS 128,148 ACCOUNTS RECEIVABLE - TOTAL ASSETS 128,148 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 19,562 NET REVENUES / EXPENDITURES 108,586 TOTAL FUND BALANCE 128,148 TOTAL LIABILITIES AND FUND BALANCE 128,148 December 17, 2018 Regular Meeting Agenda Packet 100 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 20 17:08 12/12/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/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- 140.29- 179.14- 17.914 820.86- 534-49143-000-000 Interfund Transfer In-WW Sales 596,238.00- 596,238.00- 54,203.45- 108,406.90- 18.182 487,831.10- Subtotal: 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96- Program number: 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96- Department number: Revenues 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96- Revenues Subtotal ----------- 597,238.00- 597,238.00- 54,343.74- 108,586.04- 18.181 488,651.96- December 17, 2018 Regular Meeting Agenda Packet 101 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 21 17:08 12/12/18 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/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,343.74- 108,586.04- ############### 107,586.04 December 17, 2018 Regular Meeting Agenda Packet 102 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 50 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: Revenues Program: Period Ending: 11/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 379 11/30/2018 Bank Interest- November (38.85) (140.29) (179.14) GL _______________ Account: 534-49010-000-000 Interest Income Totals: (140.29) (179.14) ** (1,000.00) Budgeted (820.86) Remaining 18 % Used Account: 534-49143-000-000 Interfund Transfer In-WW Sales 235 11/30/2018 TexPool Transfers November TexPool O&M to Rev Bd WWTP I&S (54,203.45) (54,203.45) (108,406.90) GL _______________ Account: 534-49143-000-000 Interfund Transfer In-WW Sales Totals: (54,203.45) (108,406.90) ** (596,238.00) Budgeted (487,831.10) Remaining 18 % Used Department Totals: ----------------------------------- (108,586.04) ** (54,343.74) Monthly Total (597,238.00) Budgeted (488,651.96) Remaining 18 % Used December 17, 2018 Regular Meeting Agenda Packet 103 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 51 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/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: ----------------------------------- (108,586.04) (54,343.74) Monthly Total (1,000.00) Budgeted 107,586.04 Remaining ########## December 17, 2018 Regular Meeting Agenda Packet 104 of 126 TROPHY CLUB MUD #1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2018 535 ASSETS SWIFT REVENUE BOND I&S CASH IN BANK - INVESTMENTS 52,989 ACCOUNTS RECEIVABLE - TOTAL ASSETS 52,989 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES - FUND BALANCE ASSIGNED FUND BALANCE 2,584 NET REVENUES / EXPENDITURES 50,405 TOTAL FUND BALANCE 52,989 TOTAL LIABILITIES AND FUND BALANCE 52,989 December 17, 2018 Regular Meeting Agenda Packet 105 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 22 17:08 12/12/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 11/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- 53.39- 59.54- 9.923 540.46- 535-49142-000-000 Interfund Tran In-Water Sales 276,901.00- 276,901.00- 25,172.81- 50,345.62- 18.182 226,555.38- Subtotal: 277,501.00- 277,501.00- 25,226.20- 50,405.16- 18.164 227,095.84- Program number: 277,501.00- 277,501.00- 25,226.20- 50,405.16- 18.164 227,095.84- Department number: Revenues 277,501.00- 277,501.00- 25,226.20- 50,405.16- 18.164 227,095.84- Revenues Subtotal ----------- 277,501.00- 277,501.00- 25,226.20- 50,405.16- 18.164 227,095.84- December 17, 2018 Regular Meeting Agenda Packet 106 of 126 . glbase_tbam skrolczyk Trophy Club MUD No.1 Page 23 17:08 12/12/18 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/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,226.20- 50,405.16- 8,400.860 49,805.16 ******* End of Report ********* December 17, 2018 Regular Meeting Agenda Packet 107 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 52 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: Revenues Program: Period Ending: 11/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 379 11/30/2018 Bank Interest- November (6.15) (53.39) (59.54) GL _______________ Account: 535-49010-000-000 Interest Income Totals: (53.39) (59.54) ** (600.00) Budgeted (540.46) Remaining 10 % Used Account: 535-49142-000-000 Interfund Tran In-Water Sales 235 11/30/2018 TexPool Transfers November TexPool O&M to 16Swift Rev I&S (25,172.81) (25,172.81) (50,345.62) GL _______________ Account: 535-49142-000-000 Interfund Tran In-Water Sales Totals: (25,172.81) (50,345.62) ** (276,901.00) Budgeted (226,555.38) Remaining 18 % Used Department Totals: ----------------------------------- (50,405.16) ** (25,226.20) Monthly Total (277,501.00) Budgeted (227,095.84) Remaining 18 % Used December 17, 2018 Regular Meeting Agenda Packet 108 of 126 . glpdatb2 skrolczyk Trophy Club MUD No.1 Page 53 17:08 12/12/18 Detailed Accounting Trial Balance Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/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: ----------------------------------- (50,405.16) (25,226.20) Monthly Total (600.00) Budgeted 49,805.16 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (190,666.80) **** (164,938.83) Monthly Total (1,209,068.00) Budgeted (1,018,401.20) Remaining 16 % Used ******* End of Report ********* December 17, 2018 Regular Meeting Agenda Packet 109 of 126 BUDGET VARIANCE REPORT FUND:122 - Fire O&M FINANCIALS MONTH:November 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:26.6% 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 $56,977 $74,235 6.65%10/2018 Property Taxes/MUD Fire 122-40011 Property Taxes/Fire - Delinquent $228 $502 10/2018 Delinquent Fire Taxes collected 122-40020 Property Taxes/Fire P&I $89 $128 10/2018 Fire Taxes Penalties &Interest collected FIRE EXPENSES Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed December 17, 2018 Regular Meeting Agenda Packet 110 of 126 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:November 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:26.6% NOTE: ACCOUNT DESCRIPTION TOTAL BUDGET CURRENT MONTH YTD TOTAL YTD % DATE OF COMMENT VARIANCE EXPLANATION REVENUE 135-40000-000 Property Taxes $132,384 $6,487 $8,452 6.38%10/2018 Property Taxes 135-40015-000 Property Taxes/P & I $300 $10 $14 4.83%10/2018 Property Taxes/P & I 135-47070-000 TCCC Effluent Charges $60,000 $0 $18 0.03%10/2018 Effluent Charges EXPENSES WATER 135-50016-010 Longevity $3,620 $3,620 $3,620 100.00%11/2018 Longevity 135-55085-010 Generator Maint. And Repair $3,000 $943 $943 31.43%11/2018 Generator Repair 135-65010-010 Uniforms $5,190 $1,417 $1,417 27.31%11/2018 Red Wing Shoes;Amazon- Pants 135-69281-010 Water Inspection Contract $120,000 $57,933 $57,933 48.28%11/2018 Tank Inspection WASTEWATER 135-50016-020 Longevity $7,445 $7,445 $7,445 100.00%11/2018 Longevity 135-65010-020 Uniforms $5,495 $845 $1,889 34.39%10/2018 Academy-Pants, Boots; Dickies-Pants; Walmart-Pants; Amazon-Waders 135-65040-020 Safety Equipment $1,200 $371 $552 46.02%10/2018 Ritz Safety BOARD OF DIRECTORS ADMINISTRATION Explanation provided for all accounts with a Year-To-Date percentage (YTD%) less than the Revenue Variance and greater than or equal to the Expense Variance. The Revenue and Expense Variance is calculated on a straight-line method (Financials Month x 8.3%), less 8.3% for revenues and plus 10% for expenses. Only accounts with current month activity will be listed December 17, 2018 Regular Meeting Agenda Packet 111 of 126 BUDGET VARIANCE REPORT FUND:135 - MUD 1 O&M FINANCIALS MONTH:November 2018 REVENUE VARIANCE:8.3% EXPENSE VARIANCE:26.6% 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-50016-030 Longevity $1,833 $1,833 $1,833 99.97%11/2018 Longevity 135-55030-030 Software & support $77,849 $7,008 $68,112 87.49%10/2018 Annual IT Contract with M3 Networks and MCCI Non-Departmental December 17, 2018 Regular Meeting Agenda Packet 112 of 126 Trophy Club Municipal Utility District No. 1    Date:    12/17/2018  To:    Board of Directors  From:    John Robert Carman  Subject:  General Manager’s Report    Regulatory Updates  Sanitary Sewer Overflows (SSO) – An SSO occurred on December 11, 2018 at the construction  site located at the corner of Trophy Wood Drive and the west bound TX‐114 Frontage Road.  The  contractor called 811 before digging and our team located the force main for the contractor using  a hydro‐excavation technique.  In spite of best efforts, the force main was broken for the second  time (March 23, 2018) on this project.    As you may recall, the terminology “force main” is used to denote a pressurized sewer pipe,  usually on the discharge side of a lift station.  In this case, the force main leaves Lift Station #3  and runs uphill along the frontage road to the top of the hill where it is discharged into a manhole  and flows the rest of the way to the waste water treatment plant by gravity.  When a force main is broken, all the fluid above the break elevation flows back to the break.   Once the force main is dewatered, the repair can completed.  Th e report came in at 9:40 AM and  the SSO was stopped at 10:24 AM.  This was accomplished by using our vac truck to collect the  back flow from the break in the force main and transport it to Lift Station #2.  Once the force  main was dewatered, we called in our contractor to affect the repair.  The repair was complete  at approximately 4:30 PM and Lift Station #3 was placed back in service.   Our team estimated 5,000 gallons was spilled in this incident, a entering a storm drain near the  break.  The affected areas were cleaned with a disinfectant. The SSO was reported to both TCEQ  in Austin and TCEQ Region 4 in a timely manner.  Breaks and Leaks – No reportable breaks or leaks have occurred since the last Board meeting.    Stream repair permitting – A sewer force main, extending from Lift Station #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.    December 17, 2018 Regular Meeting Agenda Packet 113 of 126 Update: An Environmental Specialist with CP&Y came to the site and to ok several measurements  around the affected area.  She believes that since the affected stream bank is less than 500 feet  long, we can begin repair with a letter to the Corp.  During her onsite visit, I met the homeowner  with most direct access to this part of the stream.  He offered to let us access the repair through  his driveway.   In the last Board meeting, one of the directors asked about the abandoned pipe in the foreground  of this photo.  There is no risk of contamination from this pipe, and it has been out of service for  more than a decade.  In this particular place, just to the right of the photographed section, is an  old reinforcement of the abandoned main.  Back then, it was common to place rocks on both  sides of an exposed pipe and pour concrete over the top of it.  That reinforcement is an eyesore  today, so I have asked that the design include cutting out the old pipe and removing the broken  concrete.                    Capital Improvement Projects   Interconnecting Pipeline Project Phase 2 – The definition of easement needs for this project are  nearly complete.  Halff has sent our staff easement definitions for all the areas where we will  need to acquire easements along the preferred alignment.  There was part of the alignment that,  from our perspective, would be better in the TxDOT right‐of‐way, but early indication suggested  TxDOT felt the corridor was too congested to allow it.  I am told that when the Halff Engineering  team met with TxDOT representatives in Denton on Monday, December 12, 2018 it was a very  positive meeting and that we might be able to keep that segment in the TxDOT right of way.  The schedule on this project originally called for final design and cost estimate in January 2019  with bidding in March of 2019.  It looks like the schedule might slip a month, so look for final  design and cost estimates in February 2019.  December 17, 2018 Regular Meeting Agenda Packet 114 of 126 WWTP – Substantial completion has been granted to the contractor with one exception:  The  crane  structure  that  supports  basins  3,4,5  &  6.    The  crane  structure  is  the  single  biggest  uncertainty on the project schedule.  Punch lists from each phase of the project have been  developed and many outstanding items have been completed.     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.  Three sealed bids were received at 11:00 a.m. on December 5,  2018. Every one of these bids were higher than the bids received for the first solicitation, ranging  from $592,000 to $696,000.  Our budget, in Fiscal Year 17, was $370,000.  We have spent about  $45,000 engineering and bidding services to date.  Staff is uncertain about how to move forward, but there seems to be two basic choices: 1) defer  the project until next fiscal year and add more money to budget or 2) ask the Board to open and  amend this year’s budget.      Fire Department Summary  During the month of November, the Fire Department responded to 66 calls for emergency  service, 46 of which were EMS related.  This 70% value was unusually high as we usually average  55% EMS and 45% fire related calls.  Our busiest district remains the area around our hotels and  hospital locations.  Last month I did not get the opportunity to share with you our statistics but  the most impressive was our number of public education contacts.    October was fire prevention month and we focused many of our efforts on public education in  our local schools.  During the last two months we taught public education classes to 127 adults  and  2,115  children.   These  classes  taught  children  basic  fire  safety  and  the  importance  of  reporting possible problems to adults.  During the month of November, we also participated in  21 continuing education and training classes (80 hours of instruction) for different disciplines of  the fire service.  Annual hydrant testing began in November and we are now putting the finishing  touches on our reports.   I am working with the Westlake Fire Department to obtain testing data for the MUD owned  hydrants in their emergency response district.  This cooperation work very well last year and I  expect the same this year.  In October we hired our full time Fire Marshal Gary Cochran who has  been doing an excellent job for us on a part time basis and we are now enjoying the added hours  of his expertise and 37 years of experience as we move forward on the substantial building  projects underway throughout the town.    During the month of November, we completed 25 inspections of our current businesses finding  112 life safety violations of which all but 5 have been corrected.  Gary is working closely with our  business  owners  and  managers  to  ensure  that  all  life  safety  violations  are  corrected  in  a  December 17, 2018 Regular Meeting Agenda Packet 115 of 126 reasonable time frame.  Gary also completed one (1) plan review during November for the BNHS  Field House.    Gary meets weekly with job superintendents at their weekly construction meetings and visits all  active job sites daily.  The Fire Marshal is also taking over other prevention activities such as  Public Education Programs. Administratively we are working on several grants to help offset  funding needs, we are working with Denton County to facilitate a CERT training in Trophy Club  and we are working through new onboarding and quality control processes.      If you have any further questions, please contact Chief Carroll.    December 17, 2018 Regular Meeting Agenda Packet 116 of 126 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 41,933 89,126           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 53,119 113,695 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 4743 4743 2019 MUD 3297 3299 3299 2019 PID 1444 1444 1444 Monthly Water Operations Report Water Billed Water Pumped Active Connections 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 October November December January February March April May June July August September WATER BILLED IN THOUSANDS OF GALLONS 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 December 17, 2018 Regular Meeting Agenda Packet 117 of 126 Influent EffluentInfluent EffluentInfluent Effluent5‐Nov 47.2 0.2 99.6% 588 2.0 99.7% 204 1.0 99.5%6‐Nov 50.2 0.2 99.6% 370 2.0 99.5% 168 1.0 99.4%    12‐Nov 44.5 0.20 99.6% 213 2.0 99.1% 248 1.0 99.6%13‐Nov 42.2 0.44 99.0% 201 2.0 99.0% 220 1.0 99.5%   19‐Nov 42.5 0.20 99.5% 155 2.0 98.7% 216 1.0 99.5%20‐Nov 42.2 0.20 99.5% 165 2.0 98.8% 214 1.0 99.5% 26‐Nov 38.0 0.40 98.9% 231 2.0 99.1% 248 1.0 99.6%27‐Nov 40 0.32 99.2% 158 2.0 98.7% 222 1.0 99.5%99.4%99.1%99.5%November 2018 ResultsAmmonia‐NCBOD5TSS0.272.01.0Ammonia‐NCBOD5TSSDate% Removal% Removal% RemovalReportDecember 17, 2018 Regular Meeting Agenda Packet118 of 126 Max mg/L0.49Aver mg/L0.290Max mg/L2.0Aver mg/L2.0Ammonia NitrogenCarbonaceous Biochemical Demand (CBOD5)0.210.3300.4900.2510.2800.2200.2000.3700.2810.2830.2700.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.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 LimitDecember 17, 2018 Regular Meeting Agenda Packet119 of 126 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.11.00.02.04.06.08.010.012.014.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18TSSAveragePermit Limit8.84.07.44.73.53.84.64.04.64.35.40.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 LimitDecember 17, 2018 Regular Meeting Agenda Packet120 of 126 Max mg/L5.0Aver mg/L1.7Max mg/L7.8Min mg/L7.2Aver mg/L7.3Potential for Hydrogen (pH)E. Coli1.04.01.05.02.01.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.437.37.47.47.37.67.77.57.87.47.677.630.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 MaxDecember 17, 2018 Regular Meeting Agenda Packet121 of 126 Max mg/L8.14Aver mg/L7.4 Dissolved Oxygen (DO)7.87.57.87.67.47.47.06.57.17.48.10.01.02.03.04.05.06.07.08.09.0Jan‐18 Feb‐18 Mar‐18 Apr‐18 May‐18 Jun‐18 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18DOAveragePermit LimitDecember 17, 2018 Regular Meeting Agenda Packet122 of 126 October November December January February March April May June July August September ebills 870 867 Bills Mailed 3921 3921 Bank Draft 650 650 Credit Card Draft 1077 1109 Online Payments 1157 1130 Late Notices 402 432 Disconnects 29 22 M 3297 3299 Connections P 1444 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 December 17, 2018 Regular Meeting Agenda Packet 123 of 126 MUD Permits Month: November 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 11/8/2018 2019-01 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 1,791.00$ 11/12/2018 2019-02 75.00$ 1,173.00$ 343.00$ 150.00$ 50.00$ 800.00$ 2,591.00$ Total 150.00$ 2,346.00$ 686.00$ 300.00$ 100.00$ 800.00$ -$ 4,382.00$ December 17, 2018 Regular Meeting Agenda Packet 124 of 126 135-10250 TexPool O & M (XXXXX0002)-General Fund Operating ***$0 $2,813,018 $2,813,018 135-10300 Prosperity Bank (XXX8701) General Fund Operating *$311,805 $1,944,045 $2,255,850 135-10305 Prosperity Bank Reserve-Savings Acct (XXXXX7724)$984,482 $0 $984,482 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 135-11160 Cash- Escrow $361,026 $0 $361,026 137-10250 TexPool O & M (XXXXX0002) GASB Replacement $782,846 $0 $782,846 517-10250 TexPool Construction Tax (XXXXX011) WWTP Improvements $0 $0 $0 517-10300 Prosperity Bank Construction WWTP Improvements $0 $0 $0 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 519-11155 Cash-Bond Escrow Bank of Texas (SWIFT)$767,358 $0 $767,358 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $639,210 $0 $639,210 533-10250 TexPool Tax I & S (XXXXX0003)$116,821 $0 $116,821 533-10300 Prosperity Bank (XXX8701) Tax I&S $4,573 $0 $4,573 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $128,148 $0 $128,148 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $52,989 $0 $52,989 $4,149,257 $4,757,663 $8,906,920 Amount available in cash (MUD Accounts)$4,757,663 Amount available for spending (MUD Accounts)$4,757,663 * 11/30/2018 Customer Water Deposits $311,805 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $279,877 $279,877 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $56,204 $56,204 $0 $336,081 $336,081 Amount available in cash (Fire Department Accounts)$336,081 Amount available for spending (Fire Department Accounts)$336,081 1,944,045$ Prosperity General Fund 2,813,018$ Texpool General Fund 600$ Petty Cash Total General Fund 135 Available for Spending 4,757,663$ Nonspendable Fund Balance (Prepaids)8,486$ Assigned Fund Balance (FY2019 Capital Projects plus prior year carry forward)1,906,543$ Unassigned Fund Balance 5,709,156$ Current Year Revenue/Expenses 106,813$ Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $7,730,998 General Fund 135 Available General Fund 135 Fund Balances Fire Department Cash CASH STATUS AS OF NOVEMBER 2018 Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) December 17, 2018 Regular Meeting Agenda Packet 125 of 126 TC Meeting Spaces Modier January 2019 Powered by Calendars FS Conference Room FS Training Room PS Large Conference Room Svore Board Room Sun Mon Tue Wed Thu Fri Sat 1 2 3 4 5 Dec , Jan Holiday - Office Closed :pm Board of Dire Feb December 17, 2018 Regular Meeting Agenda Packet 126 of 126