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 Modi er
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