Loading...
HomeMy WebLinkAbout2015-0915 Resolution Amending FY2015 BudgetRESOLUTION NO. 2015-0915 A RESOLUTION TO AMEND 2015 FISCAL YEAR BUDGET Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, a body corporate and politic and governmental agency ofthe State ofTexas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Title 30, Texas Administrative Code, Section 293.97(b), provides that prior to the start of a fiscal year, the governing board of each active district shall adopt an operating budget for the upcoming fiscal year. The rule further provides that the adopted budget and any subsequent amendments thereto shall be passed and approved by a resolution of the governing board and shall be made a part of the governing board minutes; WHEREAS, the Board of Directors of the District previously approved a resolution adopting the 2015 fiscal year budget for the District; and WHEREAS, the Board of Directors now desires to amend its fiscal year budget. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: Section 1. The Board of Directors hereby amends the budget for fiscal year 2015. A copy of the budget amendment is attached to this Resolution. The budget amendment is hereby approved for all purposes. Section 2. A copy of this resolution amending the fiscal year 2015 budget shall be attached to the meeting minutes of September 15,2015 regular meeting. Section 3. The President and Secretary of the Board are hereby authorized and directed to execute this Resolution. After this Resolution is executed, an original Resolution shall be filed in the permanent records of the District. ATTEST: £::4 Kevin R. Carr Secretary, Board ofDirectors Trophy Club Municipal Utility District No. 1 General Fund Fire Fund Debt Service Tax Fund*Debt Service Revenue Fund* Revenue 7,540,350 Revenue 31,200 Revenue 281,559 Revenue 136,989 FY 2015 Tax Collections 167,857 FY 2015 Tax Collections 872,859 FY 2015 Tax Collections 466,019 FY 2015 PID Surcharges 133,997 FY 2015 PID Assessment 357,462 Reserve (PID Fees/Other)14,000 Reserve Funds 1,004,309 Reserve Funds 198,468 Total Revenue 8,846,514 Total Revenue 1,459,989 Total Revenue 761,578 Total Revenue 136,989 Water Expense 5,688,555 Fire Expense 1,459,989 Debt Service Expense 726,534 Debt Service Expense 136,989 Wastewater Expense 1,353,397 Board of Directors Expense 22,881 Administration Expense 1,277,988 Non-Departmental Expense 503,694 Total Expense 8,846,514 Total Expense 1,459,989 Total Expense 726,534 Total Expense 136,989 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 35,044 Net Budget Surplus/Deficit 0 * Debt Service Fund was split into two funds- One for Tax Debt and One for Revenue Debt 2015 Property Value Summary Tax Rate Summary MUD Tarrant Co.294,312,465 2014 2015 MUD Denton Co.835,270,435 O&M (General Fund) Tax 0.00935 0.01486 PID 462,597,909 I & S (Debt Service) Tax 0.03666 0.04126 Total Value:1,592,180,809 Fire Tax 0.08738 0.07727 Total Tax Rate:0.13339 0.13339 Increase/Decrease:0.00000 PID Fire Assessment Rate 0.08738 0.07727 Reduction:-0.01011 Budget Summary TROPHY CLUB M.U.D. NO. 1 FY 2015 BUDGET AMENDMENT #3 September 15, 2015 1 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 GENERAL FUND Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 Comments General Fund Revenues 135-40000-000-000 Property Taxes 167,857 167,857 167,857 167,857 167,510 135-40002-000-000 Property Taxes/Delinquent 0 0 0 0 443 135-40015-000-000 Property Taxes/P & I 900 900 900 900 630 135-40025-000-000 PID Surcharges 133,997 133,997 133,997 133,997 128,970 135-43215-000-000 Insurance Settlement 0 0 0 0 0 135-47000-000-000 Water 5,286,045 5,286,045 4,747,789 4,747,789 3,102,852 135-47005-000-000 Sewer 2,270,982 2,270,982 2,270,982 2,270,982 1,879,533 135-47025-000-000 Penalties 63,416 63,416 80,000 80,000 84,892 135-47030-000-000 Service Charges (Disconnect Fees)8,000 8,000 10,000 10,000 9,574 135-47035-000-000 Plumbing Inspections 2,000 2,000 2,000 2,000 1,800 135-47045-000-000 Sewer Inspections 5,000 5,000 5,000 5,000 5,400 135-47070-000-000 TCCC Effluent Charges 86,815 86,815 86,815 86,815 52,562 135-48005-000-000 Utility Fees 184,000 184,000 184,000 184,000 202,400 135-49010-000-000 Interest Income 5,000 5,000 5,000 5,000 5,557 135-49016-000-000 Cell Tower Revenue 10,164 10,164 10,164 10,164 10,016 135-49018-000-000 Building Rent Income 7,000 7,000 7,000 7,000 5,833 135-49030-000-000 Vending Revenue 350 350 0 0 0 135-49035-000-000 Prior Year Reserves 0 0 929,603 929,603 0 135-49036-000-000 GASB Reserves 74,706 74,706 74,706 74,706 74,706 135-49075-000-000 Oversize Meter Reimbursement 84,000 84,000 42,000 42,000 47,520 135-49141-000-000 Interfund Transfer In 0 0 19,607 19,607 36,767 135-49900-000-000 Miscellaneous Income 54,000 88,600 68,994 68,994 108,556 135-49901-000-000 Records Management Revenue 100 100 100 100 14 135-49903-000-000 Recovery of Prior Year Expense 0 0 0 0 0 135-49905-000-000 Gas Well Revenue 0 0 0 0 0 Total 8,444,333 8,478,933 8,846,514 8,846,514 5,925,534 General Fund Expenses Water & Distribution 135-50005-010-000 Salaries & Wages 301,101 301,101 244,578 244,578 195,443 135-50010-010-000 Overtime 19,500 19,500 19,500 17,768 13,299 REALLOCATED FUNDS 135-50016-010-000 Longevity 5,343 5,343 2,705 2,705 2,705 135-50017-010-000 Certification 4,800 4,800 3,900 3,900 2,500 135-50020-010-000 Retirement 29,349 29,349 23,987 23,987 19,094 135-50026-010-000 Medical Insurance 44,988 44,988 51,487 39,487 31,467 CHANGE IN EMPLOYEE'S MEDICAL ELECTIONS 135-50027-010-000 Dental Insurance 3,288 3,288 4,188 4,188 2,515 135-50028-010-000 Vision Insurance 834 834 990 990 584 135-50029-010-000 Life Insurance & Other 3,074 3,074 3,074 3,074 2,010 135-50030-010-000 Social Security Taxes 21,135 21,135 17,192 17,192 13,072 135-50035-010-000 Medicare Taxes 4,943 4,943 4,021 4,021 3,057 135-50040-010-000 Unemployment Taxes 1,242 1,242 1,242 1,242 23 135-50045-010-000 Workman's Compensation 16,020 16,020 16,020 16,020 8,117 135-50060-010-000 Pre-emp Physicals/Testing 1,000 1,000 1,300 1,300 1,037 135-50070-010-000 Employee Relations 300 300 300 300 148 135-55005-010-000 Engineering 10,000 10,000 10,000 110,000 -1,290 WATER SYSTEM STUDY MOVED FROM CAPITAL TO ENGINEERING 135-55080-010-000 Maintenance & Repairs 71,242 71,242 81,113 81,113 60,123 135-55090-010-000 Vehicle Maintenance 8,000 8,000 8,000 8,000 7,466 135-55105-010-000 Maintenance-Heavy Equipment 3,500 3,500 3,500 4,700 3,827 $2,960.65 JUNE BACKHOE REPAIR 135-55135-010-000 Lab Analysis - MUD 5,500 5,500 5,500 5,500 3,973 135-60010-010-000 Communications/Pagers/Mobiles 4,913 4,913 4,913 4,913 3,599 135-60020-010-000 Electricity 170,765 170,765 160,765 150,765 115,724 LESS ELECTRIC USE THAN PROJECTED 135-60066-010-000 Publications/Books/Subscripts 500 500 500 750 739 AWWA STANDARDS 135-60070-010-000 Dues & Memberships 500 500 500 500 0 135-60080-010-000 Schools & Training 4,138 4,138 4,138 1,738 1,353 LESS PAID FOR TRAINING 135-60090-010-000 Safety Program 400 400 400 400 0 135-60100-010-000 Travel & per diem 1,500 1,500 1,500 700 240 LESS TRAVEL 135-60105-010-000 Rent/Lease Equipment 1,500 1,500 1,500 1,500 0 2 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 Comments 135-60135-010-000 TCEQ Fees & Permits - MUD 49,275 49,275 49,275 49,275 23,918 135-60150-010-000 Wholesale Water 2,928,308 2,928,308 2,928,308 2,928,308 1,454,268 135-60245-010-000 Miscellaneous Expenses 200 200 200 200 0 135-60280-010-000 Property Maintenance 3,500 3,500 3,500 2,500 1,446 REALLOCATED FUNDS 135-60285-010-000 Lawn Equipment & Maintenance 250 250 250 250 0 135-60360-010-000 Furniture/Equipment < $5000 3,500 3,500 3,500 2,300 1,823 LESS FURNITURE/EQUIPMENT PURCHASES 135-65005-010-000 Fuel & Lube 29,173 29,173 19,173 14,173 11,383 LOWER FUEL COSTS DUE TO GAS PRICES 135-65010-010-000 Uniforms 3,620 3,620 3,620 3,620 3,185 135-65030-010-000 Chemicals 7,000 7,000 10,000 11,000 9,355 ADDITIONAL CHEMICALS TO TREAT WATER 135-65035-010-000 Small Tools 1,200 1,200 1,200 1,200 638 135-65040-010-000 Safety Equipment 1,000 1,000 1,000 1,000 457 135-65050-010-000 Meter Expense 161,500 161,500 165,000 133,000 119,269 NEW GENERATOR IN CAPITAL OUTLAYS 135-69005-010-000 Capital Outlays 1,089,006 1,177,566 1,457,597 1,394,997 293,475 REMOVED WATER SYSTEM STUDY; ADDED GENERATOR; $5,400 CHANGE ORDER FOR PEBBLE BEACH 135-69006-010-000 Long Term Debt Payment from Water Sales 0 0 0 0 0 135-69008-010-000 Short Term Debt-Principal 129,000 129,000 129,000 129,000 129,000 135-69009-010-000 Short Term Debt-Interest 3,612 3,612 3,612 3,612 3,632 135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 75,000 135-69281-010-000 Tank Inspection Contract 151,507 151,507 151,507 151,507 126,958 135-55135-010-001 Lab Analysis - PID 5,000 5,000 5,000 5,000 2,783 135-60135-010-001 TCEQ Fees & Permits- PID 5,000 5,000 5,000 5,000 2,419 Subtotal Water 5,386,025 5,474,585 5,688,555 5,662,273 2,749,832 135-50005-020-000 Salaries & Wages 305,744 305,744 307,875 307,875 272,079 135-50010-020-000 Overtime 19,500 19,500 24,500 26,500 24,967 MORE ONCALL EARLIER IN THE YEAR; ADDITIONAL AFTER HOURS CUSTOMER CALL OUTS 135-50016-020-000 Longevity 5,617 5,617 5,617 5,617 5,615 135-50017-020-000 Certification 6,600 6,600 6,600 6,600 6,050 135-50020-020-000 Retirement 29,948 29,948 30,317 30,317 27,558 135-50026-020-000 Medical Insurance 61,001 61,001 56,244 56,244 51,052 135-50027-020-000 Dental Insurance 4,146 4,146 3,696 3,696 3,264 135-50028-020-000 Vision Insurance 990 990 912 912 756 135-50029-020-000 Life Insurance & Other 3,194 3,194 3,194 3,194 3,135 135-50030-020-000 Social Security Taxes 21,680 21,680 21,812 21,812 17,360 135-50035-020-000 Medicare Taxes 5,070 5,070 5,101 5,101 4,045 135-50040-020-000 Unemployment Taxes 1,242 1,242 1,242 1,242 14 135-50045-020-000 Workman's Compensation 16,020 16,020 16,020 16,020 8,117 135-50060-020-000 Pre-emp Physicals/Testing 150 150 300 300 189 135-50070-020-000 Employee Relations 550 550 650 650 523 135-55070-020-000 Independent Labor 0 0 0 0 0 135-55080-020-000 Maintenance & Repairs 58,000 58,000 72,600 75,162 87,984 ADDED $2562 WWTP BAR SCREEN REPAIR 135-55090-020-000 Vehicle Maintenance 3,000 3,000 3,000 4,000 3,523 LARGE VEHICLE REPAIRS IN SPRING 135-55105-020-000 Maintenance-Heavy Equipment 500 500 500 1,000 803 $1,348 BACKHOE REPAIR (1/2 MUD & 1/2 TOWN) 135-55125-020-000 Dumpster Services 55,000 55,000 55,000 55,000 43,100 135-55135-020-000 Lab Analysis 25,000 25,000 25,000 27,000 24,246 ADDITIONAL LAB ANALYSIS 135-60010-020-000 Communications/Pagers/Mobiles 4,662 4,662 4,662 5,500 4,914 SPLIT OF CELL PHONES FROM TOWN TO MUD IN JAN 135-60020-020-000 Electricity 149,292 149,292 139,292 145,500 134,470 ADDITIONAL ELECTRIC USAGE 135-60066-020-000 Publications/Books/Subscripts 400 400 400 400 135 135-60070-020-000 Dues & Memberships 250 250 250 325 307 AWWA 135-60080-020-000 Schools & Training 4,065 4,065 3,065 3,065 1,526 135-60090-020-000 Safety Program 550 550 550 550 0 135-60100-020-000 Travel & per diem 1,600 1,600 2,000 2,000 1,826 135-60105-020-000 Rent/Lease Equipment 9,000 9,000 7,500 2,000 1 REALLOCATED FUNDS 135-60135-020-000 TCEQ Fees & Permits 17,150 17,150 17,150 17,150 9,019 135-60243-020-000 Prior Year Expense 0 0 0 0 0 135-60245-020-000 Miscellaneous Expenses 300 300 300 300 19 135-60285-020-000 Lawn Equipment & Maintenance 500 500 500 1,000 785 JULY $511.97 MOWER REPAIR 135-60331-020-000 Interfund Transfer Out-Tax I&S 0 0 65,255 65,255 30,645 135-60332-020-000 Interfund Transfer Out- Rev I&S 357,538 295,933 136,989 136,989 136,989 135-60333-020-000 Interfund Transfer Out-Reserve 0 0 71,946 71,946 61,668 Wastewater & Collections 3 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 Comments 135-60360-020-000 Furniture/Equipment < $5000 0 0 0 0 0 135-65005-020-000 Fuel & Lube 36,328 36,328 20,328 20,328 16,173 135-65010-020-000 Uniforms 2,778 2,778 2,778 2,778 2,598 135-65030-020-000 Chemicals 30,000 30,000 24,000 24,000 18,098 135-65035-020-000 Small Tools 2,000 2,000 1,500 1,500 1,427 135-65040-020-000 Safety Equipment 750 750 750 750 626 135-65045-020-000 Lab Supplies 13,000 13,000 13,000 13,000 12,341 135-69005-020-000 Capital Outlays 150,000 150,000 142,000 142,000 198,660 $45,000 IN FY 14 CAPITAL BUDGET PAID FOR IN FY 13; $10,947 NEW AC & HEATER AT WWTP 135-69008-020-000 Short Term Debt-Principal 56,991 56,991 56,991 56,991 56,991 135-69009-020-000 Short Term Debt-Interest 2,011 2,011 2,011 2,011 1,952 Subtotal Wastewater 1,462,117 1,400,512 1,353,397 1,363,580 1,275,551 Board of Directors 135-50005-026-000 Salaries & Wages 10,000 10,000 10,000 15,000 13,500 MORE MEETINGS THAN ANTICIPATED FOR FY 15 135-50030-026-000 Social Security Taxes 620 620 620 930 775 MORE MEETINGS THAN ANTICIPATED FOR FY 15 135-50035-026-000 Medicare Taxes 145 145 145 218 181 MORE MEETINGS THAN ANTICIPATED FOR FY 15 135-50040-026-000 Unemployment Taxes 230 230 230 230 65 135-50045-026-000 Workman's Compensation 36 36 36 36 32 135-60066-026-000 Publications/Books/Subscripts 150 150 150 150 0 135-60070-026-000 Dues & Memberships 500 500 500 500 35 135-60075-026-000 Meetings 1,200 1,200 950 950 276 135-60080-026-000 Schools & Training 4,000 4,000 4,000 4,000 1,330 135-60100-026-000 Travel & per diem 5,000 5,000 4,250 4,250 3,479 135-60245-026-000 Miscellaneous Expenses 1,000 1,000 2,000 2,000 1,645 Subtotal Board of Directors 22,881 22,881 22,881 28,264 21,318 Administration 135-50005-030-000 Salaries & Wages 477,578 477,578 470,732 470,732 413,979 135-50010-030-000 Overtime 1,000 1,000 1,000 1,000 516 135-50016-030-000 Longevity 3,283 3,283 3,283 3,283 3,283 135-50020-030-000 Retirement 42,840 42,840 42,184 42,184 37,292 135-50026-030-000 Medical Insurance 65,015 65,015 62,000 62,000 53,877 135-50027-030-000 Dental Insurance 4,944 4,944 4,494 4,494 3,245 135-50028-030-000 Vision Insurance 1,158 1,158 1,116 1,116 894 135-50029-030-000 Life Insurance & Other 4,333 4,333 4,333 4,333 4,016 135-50030-030-000 Social Security Taxes 30,079 30,079 29,654 29,654 24,451 4 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 Comments 135-50035-030-000 Medicare Taxes 7,422 7,422 7,317 7,317 5,718 135-50040-030-000 Unemployment Taxes 1,449 1,449 1,449 1,449 144 135-50045-030-000 Workman's Compensation 1,636 1,636 1,636 1,636 960 135-50060-030-000 Pre-emp Physicals/Testing 500 500 500 500 38 135-50070-030-000 Employee Relations 5,000 5,000 5,000 4,300 2,690 REALLOCATED FUNDS 135-55030-030-000 Software & Support 75,588 87,423 121,635 121,635 110,023 135-55070-030-000 Independent Labor 8,000 32,550 32,550 32,550 34,211 $24,575 ONE TIME IT LABOR 135-55080-030-000 Maintenance & Repairs 4,500 4,500 4,500 4,500 535 135-55100-030-000 Building Maint & Supplies 6,500 6,500 6,500 7,000 6,433 ADDITIONAL SUPPLY USAGE FOR ADDITIONAL MEETINGS FY 15 135-55120-030-000 Cleaning Services 8,100 8,100 8,100 8,100 6,275 135-55160-030-000 Professional Outside Services 58,000 58,000 61,950 61,950 20,117 135-55161-030-000 Town Personnel Contract 6,170 26,170 26,170 26,170 26,170 135-55165-030-000 Collection Fees 200 200 200 200 0 135-55205-030-000 Utility Billing Contract 8,200 8,200 8,200 8,200 6,188 135-60005-030-000 Telephone 13,360 13,360 13,360 13,360 10,626 135-60010-030-000 Communications/Mobiles 4,057 4,057 4,057 4,057 3,715 135-60020-030-000 Electricity 14,978 14,978 12,000 12,000 8,510 135-60025-030-000 Water 1,500 1,500 1,500 1,500 913 135-60035-030-000 Postage 28,500 28,500 28,500 30,500 27,582 ADDITIONAL CUSTOMER MAILINGS 135-60040-030-000 Bank Service Charges & Fees 32,000 32,000 32,000 45,000 40,371 INCREASING CREDIT CARD FEES 135-60050-030-000 Bad Debt Expense 6,200 6,200 6,200 3,000 1,712 LESS BAD DEBT 135-60055-030-000 Insurance 48,751 48,751 48,751 48,751 45,047 135-60066-030-000 Publications/Books/Subscripts 1,000 1,000 1,600 1,600 1,224 135-60070-030-000 Dues & Memberships 5,000 5,000 6,000 6,000 4,558 135-60075-030-000 Meetings 400 400 400 400 60 135-60079-030-000 Public Education 5,000 5,000 4,079 4,079 3,385 135-60080-030-000 Schools & Training 10,235 10,235 10,235 7,235 2,938 REALLOCATED FUNDS 135-60100-030-000 Travel & per diem 5,400 5,400 5,400 4,000 1,969 REALLOCATED FUNDS 135-60110-030-000 Physicals/Testing 200 200 200 200 0 135-60115-030-000 Elections 0 0 0 0 1,289 FY 14 EXPENSE; DID NOT RECEIVE BILL UNTIL FY 15 135-60125-030-000 Advertising 2,500 2,500 2,500 7,255 5,755 PUBLIC NOTICES & BID ADVERTISING 135-60235-030-000 Security 1,350 1,350 1,350 1,350 60 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 17,500 17,500 17,500 17,500 10,732 135-60270-030-000 4th of July Celebration 10,000 10,000 10,000 10,000 10,000 135-60336-030-000 Intergov Trans Out (MUD I&S)0 0 14,000 14,000 14,000 135-60344-030-000 Intergov Trans Out (Fire Dept.)0 0 0 0 0 135-60360-030-000 Furniture/Equipment < $5000 10,475 10,475 10,475 11,036 5,036 $2,000 BINDING MACHINE; $3,000 PLOTTER 135-65010-030-000 Uniforms 1,855 1,855 1,855 1,855 1,043 135-65055-030-000 Hardware IT 75,966 35,226 35,226 35,226 34,312 135-65085-030-000 Office Supplies 9,000 9,000 9,000 9,000 7,717 135-65090-030-000 Printer Supplies & Maintenance 4,732 4,732 4,732 4,732 2,761 135-65095-030-000 Maintenance Supplies 5,000 5,000 5,000 5,000 3,935 135-65097-030-000 Vending Machine Supplies 200 200 200 200 0 135-65105-030-000 Printing 4,800 4,800 4,800 3,000 1,333 REALLOCATED FUNDS 135-69005-030-000 Capital Outlays 125,000 67,000 62,000 62,000 61,822 135-69170-030-000 Copier Lease Installments 4,236 4,236 4,236 4,236 3,407 135-69195-030-000 Gasb34/Reserve for Replacement IT 16,329 16,329 16,329 16,329 16,329 Subtotal Administration 1,287,018 1,244,663 1,277,988 1,288,704 1,093,197 Non Departmental 135-55045-039-000 Legal 250,000 300,000 467,403 467,403 452,945 135-55055-039-000 Auditing 22,491 22,491 22,491 22,491 16,836 135-55060-039-000 Appraisal 10,000 10,000 10,000 10,000 7,964 135-55065-039-000 Tax Admin Fees 3,800 3,800 3,800 3,800 2,456 Subtotal Non Departmental 286,291 336,291 503,694 503,694 480,201 Total General Fund Revenues 8,444,333 8,478,933 8,846,514 8,846,514 Total General Fund Expenses 8,444,333 8,478,933 8,846,514 8,846,514 Net Budget Surplus (Deficit)0 0 0 0 5 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 FIRE DEPARTMENT Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 Revenues 122-40001-000-000 Assessment - Emerg Svcs 357,462 357,462 357,462 357,462 356,646 122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 0 0 0 8,402 122-40010-000-000 Property Taxes/MUD Fire 872,859 872,859 872,859 872,859 871,029 122-40011-000-000 Property Taxes/Fire-Delinquent 0 0 0 0 4,056 122-40015-000-000 Property Taxes/Assessments P&I 750 750 750 750 3,304 122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 4,500 4,500 3,746 122-42014-000-000 Fire Permits/Sprinkler 6,000 6,000 6,000 6,000 5,200 122-43400-000-000 Fire Inspections 700 700 950 950 975 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 10,000 10,000 122-49035-000-000 Prior Year Reserves 125,670 125,670 171,030 198,468 125,670 ADDED $27,438 FIRE OPERATIONAL ASSESSMENT FROM RESERVES 122-49900-000-000 Miscellaneous Income 6,000 6,000 9,000 9,000 10,404 Total 1,383,940 1,383,940 1,432,551 1,459,989 1,399,432 Expenses 122-50005-045-000 Salaries & Wages 469,067 469,067 469,067 469,067 422,175 122-50010-045-000 Overtime 46,745 46,745 46,745 46,745 38,496 122-50011-045-000 Holiday Pay 14,930 14,930 14,930 14,930 14,526 122-50016-045-000 Longevity 5,505 5,505 5,505 5,505 5,319 122-50017-045-000 Certification 4,800 4,800 4,800 4,800 4,482 122-50020-045-000 Retirement 91,396 91,396 75,327 75,327 65,931 122-50026-045-000 Medical Insurance 59,169 59,169 59,169 59,169 50,431 122-50027-045-000 Dental Insurance 4,390 4,390 4,390 4,390 3,859 122-50028-045-000 Vision Insurance 811 811 811 811 671 122-50029-045-000 Life Insurance & Other 4,030 4,030 4,030 4,030 3,372 122-50030-045-000 Social Security Taxes 33,421 33,421 33,421 33,421 27,740 122-50035-045-000 Medicare Taxes 7,292 7,292 7,292 7,292 6,486 122-50040-045-000 Unemployment Taxes 1,657 1,657 1,657 1,657 -271 122-50045-045-000 Workman's Compensation 8,692 8,692 8,692 8,692 7,249 122-50060-045-000 Pre-employment Physicals/Test 250 250 250 250 183 122-50075-045-000 Tuition Reimbursement 300 300 300 300 0 122-55030-045-000 Software & Support 7,378 7,378 7,378 7,378 5,131 122-55045-045-000 Legal 1,500 1,500 1,500 2,100 2,040 ADDITIONAL LEGAL BILLS 122-55080-045-000 Maintenance & Repairs 18,552 18,552 18,552 14,552 10,669 REDUCED FOR PUMP AND VALVES REPAIR FUND DURING TRUCK MAINTENANCE 122-55090-045-000 Vehicle Maintenance 12,000 12,000 12,000 16,000 11,006 ADDED FOR PUMP AND VALVES REPAIR FUND DURING TRUCK MAINTENANCE 122-55160-045-000 Professional Outside Services 0 0 0 27,438 1,895 FIRE OPERATIONAL ASSESSMENT 122-60005-045-000 Telephone 50 50 50 75 51 LONG DISTANCE CALLS 122-60010-045-000 Communications/Mobiles 5,000 5,000 6,413 6,413 4,353 6 Trophy Club MUD No.1 Amendment #3 FY 15 Budget 09/15/15 Account Description Original FY 2015 12/16/2014 4/21/2015 9/15/2015 YTD Total Budget Amend #1 Amend #2 Amend #3 thru 8/31/15 122-60020-045-000 Electricity/Gas 9,026 9,026 9,026 9,026 5,699 122-60025-045-000 Water 1,200 1,200 1,200 2,200 1,780 08-15 WATER BILL WAS $706.24 (1/2 MUD 1/2 TOWN) 122-60026-045-000 Cable 1,920 1,920 1,920 1,920 1,689 122-60030-045-000 Rent And/Or Usage 211,829 211,829 211,829 211,829 211,829 122-60035-045-000 Postage 100 100 100 100 16 122-60055-045-000 Insurance 12,179 12,179 12,179 12,179 10,341 122-60066-045-000 Publications/Books/Subscrips 200 200 220 220 219 122-60070-045-000 Dues & Memberships 15,180 15,180 15,689 15,689 15,633 122-60080-045-000 Schools & Training 4,280 4,280 4,280 4,280 4,013 122-60096-045-000 Emergency Management 1,400 1,400 1,400 1,400 1,220 122-60100-045-000 Travel & per diem 13,577 13,577 13,577 13,577 7,936 122-60110-045-000 Physicals/Testing 2,000 2,000 2,000 2,000 0 122-60125-045-000 Advertising 5,100 5,100 5,100 5,100 826 122-60160-045-000 Programs & Special Projects 4,500 4,500 4,500 4,500 2,456 122-60180-045-000 Fire Inspection/Enforcement 1,000 1,000 1,000 1,000 194 122-60195-045-000 Flags & Repair 2,000 2,000 2,000 2,000 555 122-60243-045-000 Prior Year Expense 0 0 0 0 0 122-60245-045-000 Miscellaneous Expense 1,000 1,000 1,000 1,000 574 122-65005-045-000 Fuel & Lube 10,454 10,454 10,454 8,829 5,014 REDUCED FOR REALLOCATION FOR LEGAL & WATER 122-65010-045-000 Uniforms 2,000 2,000 3,000 3,000 2,408 122-65015-045-000 Protective Clothing 5,200 15,200 35,200 35,200 16,177 122-65030-045-000 Chemicals 200 200 200 200 134 122-65035-045-000 Small Tools 2,500 2,500 2,500 2,500 1,124 122-65055-045-000 Hardware 9,000 9,000 9,000 9,000 0 122-65085-045-000 Office Supplies 500 500 500 500 80 122-65105-045-000 Printing 548 548 548 548 38 122-69005-045-000 Capital Outlays 0 0 250,000 250,000 250,000 122-69008-045-000 Short Term Debt -Principal 158,262 158,262 0 0 0 122-69009-045-000 Short Term Debt -Interest 50,000 50,000 0 0 0 122-69050-045-000 Radios 23,500 23,500 23,500 23,500 23,491 122-69195-045-000 GASB34/Reserve for Replacement 17,950 17,950 17,950 17,950 17,950 122-69255-045-000 Airpacks 20,400 10,400 10,400 10,400 10,235 Total 1,383,940 1,383,940 1,432,551 1,459,989 Total Fire Revenues 1,383,940 1,383,940 1,432,551 1,459,989 Total Fire Expenses 1,383,940 1,383,940 1,432,551 1,459,989 Net Budget Surplus (Deficit)0 0 0 0 FIRE TRUCK LEASE ADDITIONAL JOURNAL ENTRY REQUIRED 122-49000-000-000 Capital Lease-Other Financing Sources 0 807,316 FIRE TRUCK LEASE 122-69005-045-000 Capital Outlays 807,316 0 NEW FIRE TRUCK 7 SCHEDULE GF - A FY 15 CAPITAL OUTLAYS WATER - PURCHASES WATER - MAINTENANCE & REPAIRS ADMINISTRATION - PURCHASES DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT GPS System 10,100 10 Valves $6500 each 65,000 SUV 20,000 Backhoe 0 Ft. Worth Water Line 838,924 1 ton Truck 43,000 12 inch valve @ water plant-Increased actual costs vs. budgeted 13,810 1/2 ton Truck 0 Pin Oak (Streets Project)80,156 Generator 32,000 Timber Line Ct. (Streets Project)31,250 Pebble Beach ( Streets Project) - Change Order $5,400 202,900 TW King EST Drain Line and Valve 25,960 Water Supply Feasibility & Route Study with Westlake 32,600 6" water line replacement on Campus Circle- two prior repairs 19,297 within a year-replacing old pipe 0 Water System Study 100,000 Water System Study moved to Engineering -100,000 Total:85,100 Total:1,309,897 Total:20,000 WASTEWATER - PURCHASES WASTEWATER - MAINTENANCE & REPAIRS ADMINISTRATION - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Crane Truck Bed 30,000 Force Main Upgrade at Lift #2*112,000 Front Office Remodel (UB Booths)0 Oakhill Sewer Line Rehab 0 Hardware (see Schedule GF-L)*42,000 *Bid amount plus engineering and contigency Total:30,000 Total:112,000 Total:42,000 *Hardware was budgeted but auditor requested 4 items over $5000 be moved to Capital Outlay. 8