Loading...
HomeMy WebLinkAbout2016-0419B Resolution Amending FY Budget 2016 General Fund Fire Fund Tax Debt Service Fund Revenue Debt Service Fund Revenue 7,856,593 Revenue 90,326 Revenue 214,519 Revenue 444,838 FY 2016 Tax Collections 58,181 FY 2016 Tax Collections 889,963 FY 2016 Tax Collections 671,998 FY 2016 PID Surcharges 146,125 FY 2016 PID Assessment 404,346 PID Surcharge 119,706 Reserve Funds 548,668 Reserve Funds 0 Total Revenue 8,609,567 Total Revenue 1,384,635 Total Revenue 1,006,223 Total Revenue 444,838 Water Expense 4,814,885 Fire Expense 1,384,635 Debt Service Expense 1,004,533 Debt Service Expense 444,838 Wastewater Expense 2,140,864 Board of Directors Expense 26,368 Administration Expense 1,203,215 Non-Departmental Expense 424,234 Total Expense 8,609,567 Total Expense 1,384,635 Total Expense 1,004,533 Total Expense 444,838 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 1,690 Net Budget Surplus/Deficit 0 2016 Property Value Summary Tax Rate Summary MUD Tarrant Co.299,983,661 2015 2016 MUD Denton Co.932,292,617 O&M (General Fund) Tax 0.01486 0.00472 PID 559,559,219 I & S (Debt Service) Tax 0.04126 0.05420 Out of District & PID 313,864 Fire Tax 0.07727 0.07222 Total Value:1,792,149,361 Total Tax Rate:0.13339 0.13114 Increase/Decrease:-0.00225 PID Fire Assessment Rate 0.07727 0.07222 Reduction:-0.00505 Budget Summary TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 FY 2016 BUDGET AMENDMENT #1 APRIL 19, 2016 1 GENERAL FUND Account Description Original FY 2016 4/19/2016 YTD Total Budget Amend#1 thru 3/31/16 Comments General Fund Revenues 135-40000-000-000 Property Taxes 58,181 58,181 56,966 SEE SCHEDULE TAX_ASSESS 135-40002-000-000 Property Taxes/Delinquent 0 0 276 135-40015-000-000 Property Taxes/P & I 650 650 238 135-40025-000-000 PID Surcharges 146,125 146,125 24,739 PER AUDITOR MONEY COLLECTED IS IN ACCT 135-25041 PID SURCHARGE LIABILITY UNTIL ANNUAL RECONCILIATION 135-47000-000-000 Water 5,080,244 5,080,244 1,646,998 SEE SCHEDULE GF-D 135-47005-000-000 Sewer 2,413,776 2,413,776 1,009,111 SEE SCHEDULE GF-E 135-47025-000-000 Penalties 90,985 90,985 54,468 SEE SCHEDULE GF-D 135-47030-000-000 Service Charges (Disconnect Fees)9,000 9,000 7,925 SEE SCHEDULE GF-D 135-47035-000-000 Plumbing Inspections 2,000 2,000 1,650 135-47045-000-000 Sewer Inspections 5,500 5,500 4,800 135-47070-000-000 TCCC Effluent Charges 61,330 61,330 7,400 SEE SCHEDULE GF-E 135-48005-000-000 Utility Fees 69,000 55,200 55,200 SEE SCHEDULE GF-D; REVISED BASED ON FINAL PROCEEDS 135-49010-000-000 Interest Income 6,000 10,000 5,933 INCREASED INTEREST RATES 135-49016-000-000 Cell Tower Revenue 10,926 10,926 5,463 $910.53 PER MONTH 135-49018-000-000 Building Rent Income 7,000 7,000 3,500 $583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN 135-49026-000-000 Proceeds from Sale of Assets 0 30,935 30,935 AUCTION PROCEEDS & TRADE IN OF BACKHOE 135-49030-000-000 Vending Revenue 0 0 0 NO LONGER PROVIDING VENDING AT WWTP 135-49035-000-000 Prior Year Reserves 8,020 548,668 0 STW SERVER UPGRADE- FUNDS FROM 137; AMMONIA SYSTEM; AERIAL WWW LINE; WATER STUDY 135-49036-000-000 GASB Reserves 0 0 0 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARE 135-49075-000-000 Oversize Meter Reimbursement 15,778 15,778 33,963 SEE SCHEDULE GF-D 135-49141-000-000 Interfund Transfer In 0 0 8,034 REMAINDER OF CAPITAL PROJECTS FUND 135-49900-000-000 Miscellaneous Income 63,249 63,249 1,161 INCLUDES $3108 FROM TOWN FOR JANITORIAL; PID LOC INTEREST 135-49901-000-000 Records Management Revenue 20 20 20 REDUCED REVENUE 135-49903-000-000 Recovery of Prior Year Expense 0 0 0 Total 8,047,784 8,609,567 2,958,782 General Fund Expenses Water & Distribution 135-50005-010-000 Salaries & Wages 265,614 260,062 100,809 SEE SCHEDULE GF-H- STAFF CHANGES 135-50010-010-000 Overtime 19,500 19,500 6,061 SEE SCHEDULE GF-H 135-50016-010-000 Longevity 2,945 2,945 2,945 SEE SCHEDULE GF-H 135-50017-010-000 Certification 4,200 3,600 1,125 SEE SCHEDULE GF-H 135-50020-010-000 Retirement 25,558 25,018 9,790 SEE SCHEDULE GF-J 135-50026-010-000 Medical Insurance 51,398 51,398 18,460 SEE SCHEDULE GF-I 135-50027-010-000 Dental Insurance 3,999 3,999 1,380 SEE SCHEDULE GF-I 135-50028-010-000 Vision Insurance 910 910 311 SEE SCHEDULE GF-I 135-50029-010-000 Life Insurance & Other 2,803 2,803 1,158 SEE SCHEDULE GF-I 135-50030-010-000 Social Security Taxes 18,563 18,144 6,816 SEE SCHEDULE GF-H 135-50035-010-000 Medicare Taxes 4,341 4,243 1,594 SEE SCHEDULE GF-H 135-50040-010-000 Unemployment Taxes 1,242 1,026 764 SEE SCHEDULE GF-H- CHANGE IN RATE 135-50045-010-000 Workman's Compensation 14,754 14,754 5,062 TML INVOICE AMOUNT 135-50060-010-000 Pre-emp Physicals/Testing 1,300 1,300 236 2 Account Description Original FY 2016 4/19/2016 YTD Total Budget Amend#1 thru 3/31/16 Comments 135-50070-010-000 Employee Relations 300 300 75 135-55005-010-000 Engineering 5,000 109,400 13,395 WATER STUDY $94,400; ENGINEERING FOR MAPS $10,000 135-55080-010-000 Maintenance & Repairs 85,000 99,500 56,408 MOWING FOR WATER SITES $14,500 135-55090-010-000 Vehicle Maintenance 8,000 8,000 2,868 135-55105-010-000 Maintenance-Heavy Equipment 3,500 3,500 2,893 135-55135-010-000 Lab Analysis - MUD 5,500 5,500 2,009 TCEQ ESTIMATE + MONTHLY BAC T & REDUCED FOR PID PORTION 135-60010-010-000 Communications/Pagers/Mobiles 5,400 5,400 2,184 INCREASE IN COSTS 135-60020-010-000 Electricity 166,823 166,823 58,091 SEE SCHEDULE GF-K 135-60066-010-000 Publications/Books/Subscripts 500 500 0 135-60070-010-000 Dues & Memberships 500 500 11 135-60080-010-000 Schools & Training 5,773 5,773 1,075 SEE SCHEDULE GF-G 135-60090-010-000 Safety Program 400 400 249 135-60100-010-000 Travel & per diem 1,400 1,400 78 SEE SCHEDULE GF-G 135-60105-010-000 Rent/Lease Equipment 1,500 1,500 0 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-010-000 TCEQ Fees & Permits - MUD 49,275 49,275 10,501 REG. ASSESSMENT ($22,500), WATER SYSTEM FEES ($6,775) & NTGW WELL FEES ($20,000) 135-60150-010-000 Wholesale Water 2,948,742 2,948,742 717,771 SEE SCHEDULE GF-C 135-60245-010-000 Miscellaneous Expenses 200 200 0 135-60280-010-000 Property Maintenance 3,500 3,500 2,200 135-60285-010-000 Lawn Equipment & Maintenance 250 250 0 135-60360-010-000 Furniture/Equipment < $5000 2,500 2,500 0 135-65005-010-000 Fuel & Lube 35,947 35,947 7,620 SEE SCHEDULE GF-M 135-65010-010-000 Uniforms 4,608 4,608 2,007 SEE SCHEDULE GF-F 135-65030-010-000 Chemicals 12,000 13,000 6,447 INCREASE IN COSTS 135-65035-010-000 Small Tools 1,200 1,200 0 135-65040-010-000 Safety Equipment 1,000 1,000 443 135-65050-010-000 Meter Expense 115,000 115,000 87,305 135-65053-010-000 Meter Change Out Program 50,000 77,325 77,325 FY 16 SCHED. METER CHANGEOUTS: 148 RESID. METERS & 7 COMM. METERS; ADDED $33,750 FOR 225 PROF.HEADS 135-69005-010-000 Capital Outlays 201,000 400,250 306,981 SEE SCHEDULE GF-A 135-69006-010-000 Long Term Debt Payment from Water Sales 0 0 0 SEE SCHEDULE GF-B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 135-69008-010-000 Short Term Debt-Principal 130,720 130,720 130,700 SEE SCHEDULE GF-B 135-69009-010-000 Short Term Debt-Interest 1,209 1,209 1,178 SEE SCHEDULE GF-B 135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000 135-69281-010-000 Tank Inspection Contract 126,958 126,958 126,958 ANNUAL MAINTENANCE CONTRACT 135-55135-010-001 Lab Analysis - PID 5,000 5,000 737 PID PORTION 135-60135-010-001 TCEQ Fees & Permits- PID 5,000 5,000 0 WATER SYSTEM FEES ($2.15/CONNECTION) AND OTHER Subtotal Water 4,475,834 4,814,885 1,849,020 3 Account Description Original FY 2016 4/19/2016 YTD Total Budget Amend#1 thru 3/31/16 Comments Wastewater 135-50005-020-000 Salaries & Wages 351,671 351,671 167,357 SEE SCHEDULE GF-H 135-50010-020-000 Overtime 19,500 29,500 16,284 SEE SCHEDULE GF-H- ADDITIONAL STAFF TIME AT WWTP DUE TO CONSTRUCTION 135-50016-020-000 Longevity 6,125 6,125 6,125 SEE SCHEDULE GF-H 135-50017-020-000 Certification 7,200 7,200 3,600 SEE SCHEDULE GF-H 135-50020-020-000 Retirement 33,652 33,652 17,056 SEE SCHEDULE GF-J 135-50026-020-000 Medical Insurance 65,989 65,989 30,733 SEE SCHEDULE GF-I 135-50027-020-000 Dental Insurance 4,184 4,184 1,858 SEE SCHEDULE GF-I 135-50028-020-000 Vision Insurance 972 972 423 SEE SCHEDULE GF-I 135-50029-020-000 Life Insurance & Other 3,655 3,655 1,986 SEE SCHEDULE GF-I 135-50030-020-000 Social Security Taxes 24,665 24,665 10,947 SEE SCHEDULE GF-H 135-50035-020-000 Medicare Taxes 5,768 5,768 2,560 SEE SCHEDULE GF-H 135-50040-020-000 Unemployment Taxes 1,449 1,204 1,204 SEE SCHEDULE GF-H- CHANGE IN RATE 135-50045-020-000 Workman's Compensation 9,317 9,317 2,344 TML INVOICE AMOUNT 135-50060-020-000 Pre-emp Physicals/Testing 300 300 238 135-50070-020-000 Employee Relations 650 650 283 135-55070-020-000 Independent Labor 50,000 50,000 81,943 ENGINEERING FEES FOR PERMIT RENEWAL 135-55080-020-000 Maintenance & Repairs 72,600 83,100 58,933 MOWING FOR LIFT STATIONS $10,500 135-55090-020-000 Vehicle Maintenance 5,000 7,500 4,151 GAP VAX REPAIRS; REPLACE WINDSHIELD ON ON CALL TRUCK 135-55105-020-000 Maintenance-Heavy Equipment 500 500 291 135-55125-020-000 Dumpster Services 55,000 55,000 19,477 135-55135-020-000 Lab Analysis 35,000 35,000 22,682 INCREASE FOR PERMIT RENEWAL TESTING 135-60010-020-000 Communications/Pagers/Mobiles 5,400 5,400 2,868 INCREASE IN COSTS 135-60020-020-000 Electricity 161,582 161,582 57,181 SEE SCHEDULE GF-K 135-60066-020-000 Publications/Books/Subscripts 400 400 0 135-60070-020-000 Dues & Memberships 300 300 200 135-60080-020-000 Schools & Training 3,771 3,771 2,242 SEE SCHEDULE GF-G 135-60090-020-000 Safety Program 550 550 297 135-60100-020-000 Travel & per diem 1,600 1,600 620 SEE SCHEDULE GF-G 135-60105-020-000 Rent/Lease Equipment 9,000 9,000 0 EMERGENCY EQUIPMENT RENTAL IF NEEDED 135-60135-020-000 TCEQ Fees & Permits 37,150 37,150 34,469 REG. ASSESSMENT($8,550), ANNUAL FEE ($8,600), PERMIT RENEWAL ($20,000) 135-60243-020-000 Prior Year Expense 0 0 0 135-60245-020-000 Miscellaneous Expenses 300 300 150 135-60285-020-000 Lawn Equipment & Maintenance 500 500 0 135-60331-020-000 Interfund Transfer Out-Tax I&S 119,706 119,706 19,951 TRANSFER OF PID SURCHARGE 135-60332-020-000 Interfund Transfer Out- Revenue I&S 444,831 444,831 228,736 SEE SCHEDULE GF-B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS 13560333-020-000 Interfund Transfer Out-Reserve 123,336 123,336 61,668 TRANSFER FOR BOND RESERVE 135-60360-020-000 Furniture/Equipment < $5000 0 0 0 135-65005-020-000 Fuel & Lube 32,021 32,021 5,814 SEE SCHEDULE GF-M 135-65010-020-000 Uniforms 4,241 4,241 2,504 SEE SCHEDULE GF-F 135-65030-020-000 Chemicals 27,000 27,000 17,698 INCREASE IN CHEMICALS NEEDED 4 Account Description Original FY 2016 4/19/2016 YTD Total Budget Amend#1 thru 3/31/16 Comments 135-65035-020-000 Small Tools 2,000 2,000 221 135-65040-020-000 Safety Equipment 750 750 577 135-65045-020-000 Lab Supplies 13,000 13,000 10,480 135-69005-020-000 Capital Outlays 150,000 356,000 57,941 SEE SCHEDULE GF-A 135-69007-020-000 Long Term Debt Payment from WW Sales 0 0 0 135-69008-020-000 Short Term Debt-Principal 21,280 21,280 21,277 SEE SCHEDULE GF-B 135-69009-020-000 Short Term Debt-Interest 197 197 197 SEE SCHEDULE GF-B Subtotal Wastewater 1,912,107 2,140,864 975,566 Board of Directors 238 135-50005-026-000 Salaries & Wages 12,500 12,500 3,300 MORE MEETINGS 135-50030-026-000 Social Security Taxes 775 775 205 MORE MEETINGS 135-50035-026-000 Medicare Taxes 181 181 48 MORE MEETINGS 135-50040-026-000 Unemployment Taxes 230 12 12 EXEMPT STATUS FOR ELECTED OFFICALS 135-50045-026-000 Workman's Compensation 37 50 31 INCREASE IN TML INVOICE AMOUNT 135-60066-026-000 Publications/Books/Subscripts 150 150 0 135-60070-026-000 Dues & Memberships 500 500 11 135-60075-026-000 Meetings 1,200 1,200 22 MORE MEETINGS 135-60080-026-000 Schools & Training 4,000 4,000 905 135-60100-026-000 Travel & per diem 5,000 5,000 1,602 135-60245-026-000 Miscellaneous Expenses 2,000 2,000 50 Subtotal Board of Directors 26,573 26,368 6,187 Administration 135-50005-030-000 Salaries & Wages 488,508 493,632 227,284 SEE SCHEDULE GF-H 135-50010-030-000 Overtime 1,000 500 152 SEE SCHEDULE GF-H- REALLOCATION OF FUNDS 135-50016-030-000 Longevity 3,823 3,823 3,823 SEE SCHEDULE GF-H 135-50020-030-000 Retirement 43,202 43,652 20,404 SEE SCHEDULE GF-H 135-50026-030-000 Medical Insurance 68,196 68,196 30,596 SEE SCHEDULE GF-I (Updated with Board approved plan rates) 135-50027-030-000 Dental Insurance 4,807 4,807 2,084 SEE SCHEDULE GF-I 135-50028-030-000 Vision Insurance 1,114 1,114 481 SEE SCHEDULE GF-I 135-50029-030-000 Life Insurance & Other 4,431 5,431 4,510 SEE SCHEDULE GF-I- CHANGE IN RATINGS 135-50030-030-000 Social Security Taxes 30,823 31,141 13,374 SEE SCHEDULE GF-I 135-50035-030-000 Medicare Taxes 7,599 7,678 3,128 SEE SCHEDULE GF-H 135-50040-030-000 Unemployment Taxes 1,449 1,197 1,151 SEE SCHEDULE GF-H - CHANGE IN RATE 135-50045-030-000 Workman's Compensation 1,554 1,554 1,179 TML INVOICE AMOUNT 135-50060-030-000 Pre-emp Physicals/Testing 500 500 0 135-50070-030-000 Employee Relations 5,000 4,500 2,880 REALLOCATION OF FUNDS 135-55030-030-000 Software & Support 78,483 81,097 31,477 SEE SCHEDULE GF-L; TIME CLOCK PLUS VER.7 $2,614 135-55070-030-000 Independent Labor 12,000 12,000 12,972 135-55080-030-000 Maintenance & Repairs 29,500 7,000 11,128 MOVED $25,000 MOWING CONTRACT TO WATER/WW 135-55100-030-000 Building Maint & Supplies 7,000 7,000 4,327 INCREASE IN COSTS 135-55120-030-000 Cleaning Services 10,125 10,125 2,665 CLEANING CONTRACT INCREASE 135-55160-030-000 Professional Outside Services 61,075 72,575 53,073 RATE ASSISTANCE $10,000; IT RFP ASSISTANCE $1,500 5 Account Description Original FY 2016 4/19/2016 YTD Total Budget Amend#1 thru 3/31/16 Comments 135-55161-030-000 Town Personnel Contract 0 0 0 SERVICES NET ZERO THIS YEAR 135-55165-030-000 Collection Fees 200 200 0 135-55205-030-000 Utility Billing Contract 8,200 8,200 3,122 COST FOR PRINTING MONTHLY STATEMENTS 135-60005-030-000 Telephone 16,349 16,349 6,396 SEE SCHEDULE GF-L AND $2,500 AFTER HOURS ANSWERING SERVICE 135-60010-030-000 Communications/Mobiles 4,150 4,150 2,028 INCREASE IN COSTS 135-60020-030-000 Electricity 10,768 10,768 3,711 SEE SCHEDULE GF-K 135-60025-030-000 Water 1,500 1,500 459 135-60035-030-000 Postage 28,932 28,932 12,192 INCREASE OF $432 FOR POSTAGE MACHINE RENTAL 135-60040-030-000 Bank Service Charges & Fees 44,000 55,560 31,061 CREDIT CARD FEES CONTINUING TO INCREASE 135-60050-030-000 Bad Debt Expense 3,500 3,500 2,015 135-60055-030-000 Insurance 52,797 52,797 16,837 TML INVOICE AMOUNT 135-60066-030-000 Publications/Books/Subscripts 1,600 1,600 0 135-60070-030-000 Dues & Memberships 6,000 6,000 5,006 135-60075-030-000 Meetings 400 400 29 135-60079-030-000 Public Education 5,000 5,000 3,646 135-60080-030-000 Schools & Training 9,935 9,935 3,273 SEE SCHEDULE GF-G 135-60100-030-000 Travel & per diem 5,400 5,400 2,468 SEE SCHEDULE GF-G 135-60110-030-000 Physicals/Testing 200 200 0 135-60115-030-000 Elections 7,500 7,500 6 ELECTION TO BE HELD IN FY 16 135-60125-030-000 Advertising 7,500 7,500 62 INCREASED ADVERTISING 135-60235-030-000 Security 1,350 1,350 0 SEE SCHEDULE GF-L 135-60245-030-000 Miscellaneous Expenses & DM Discretionary 17,500 17,500 4,074 135-60270-030-000 4th of July Celebration 0 0 0 135-60336-030-000 Intergov Trans Out (MUD I&S)0 0 0 135-60344-030-000 Intergov Trans Out (Fire Dept.)0 0 0 135-60360-030-000 Furniture/Equipment < $5000 2,500 2,500 656 135-65010-030-000 Uniforms 1,855 1,855 23 SEE SCHEDULE GF-F 135-65055-030-000 Hardware IT 29,594 13,594 5,872 SEE SCHEDULE GF-L- MOVED METER READING LAPTOP TO CAPITAL OUTLAYS 135-65085-030-000 Office Supplies 9,000 9,000 3,424 ALL DEPARTMENTS COMBINED. 135-65090-030-000 Printer Supplies & Maintenance 4,003 4,003 406 SEE SCHEDULE GF-L 135-65095-030-000 Maintenance Supplies 5,000 5,000 2,092 135-65097-030-000 Vending Machine Supplies 0 0 0 NO LONGER PROVIDING VENDING AT WWTP 135-65105-030-000 Printing 4,800 4,800 60 ADDITIONAL PRINTING FOR CUSTOMER PUBLICATIONS 135-69005-030-000 Capital Outlays 56,000 56,000 6,158 SEE SCHEDULE GF-A 135-69170-030-000 Copier Lease Installments 4,600 4,600 1,673 SEE SCHEDULE GF-L 135-69195-030-000 Gasb34/Reserve for Replacement IT 0 0 0 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARE Subtotal Administration 1,210,322 1,203,215 543,437 Non Departmental 135-55045-039-000 Legal 386,130 386,130 120,596 PLAN FOR RATE CHALLENGE 135-55055-039-000 Auditing 22,750 24,039 24,039 FY 16 CONTRACT PRICE- ADDITIONAL EXPENSES 135-55060-039-000 Appraisal 10,265 10,265 6,224 135-55065-039-000 Tax Admin Fees 3,800 3,800 2,469 Subtotal Non Departmental 422,945 424,234 153,329 Total General Fund Revenues 8,047,784 8,609,567 Total General Fund Expenses 8,047,784 8,609,567 Net Budget Surplus (Deficit)0 0 6 FIRE DEPARTMENT Account Description Original 4/19/2016 YTD Total Budget Amend #1 thru 3/31/16 Revenues 122-40001-000-000 Assessment - Emerg Svcs 404,346 404,346 371,291 SEE SCHEDULE TAX_ASSESS 122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 0 346 122-40010-000-000 Property Taxes/MUD Fire 889,963 889,963 871,635 SEE SCHEDULE TAX_ASSESS 122-40011-000-000 Property Taxes/Fire-Delinquent 0 0 2,228 122-40015-000-000 Property Taxes/Assessments P&I 750 0 0 TCMUD NO LONGER RECEIVES THIS 122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 2,964 122-42014-000-000 Fire Permits/Sprinkler 5,000 5,000 4,000 122-43400-000-000 Fire Inspections 825 825 850 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 122-49026-000-000 Proceeds from Sale of Assets 0 60,000 60,000 PROCEEDS FROM SALE OF 1996 LADDER TRUCK 122-49035-000-000 Prior Year Reserves 0 0 0 122-49900-000-000 Miscellaneous Income 50,000 10,000 8,500 $40,000 FROM SALE OF 1996 LADDER TRUCK-MOVED TO PROCEEDS FROM SALE OF ASSETS Total 1,365,384 1,384,635 1,331,815 Expenses 122-50005-045-000 Salaries & Wages 508,226 508,226 223,161 SEE SCHEDULE GF-H 122-50010-045-000 Overtime 48,735 48,735 30,031 SEE SCHEDULE GF-H 122-50011-045-000 Holiday Pay 15,852 15,852 14,718 SEE SCHEDULE GF-H 122-50016-045-000 Longevity 5,761 5,761 5,730 SEE SCHEDULE GF-H 122-50017-045-000 Certification 4,200 4,200 1,590 SEE SCHEDULE GF-J 122-50020-045-000 Retirement 75,571 75,571 34,424 SEE SCHEDULE GF-I 122-50026-045-000 Medical Insurance 65,546 65,546 25,738 SEE SCHEDULE GF-I 122-50027-045-000 Dental Insurance 4,885 4,885 2,529 SEE SCHEDULE GF-I 122-50028-045-000 Vision Insurance 859 859 520 SEE SCHEDULE GF-I 122-50029-045-000 Life Insurance & Other 4,585 4,585 1,796 SEE SCHEDULE GF-I 122-50030-045-000 Social Security Taxes 36,132 36,132 15,972 SEE SCHEDULE GF-H 122-50035-045-000 Medicare Taxes 8,450 8,450 3,734 SEE SCHEDULE GF-H 122-50040-045-000 Unemployment Taxes 1,724 2,000 1,940 INCREASE DUE TO EMPLOYEE TURN-OVER (UT PAID ON FIRST $9,000 OF SALARY) 122-50045-045-000 Workman's Compensation 9,379 9,379 0 SEE SCHEDULE GF-H 122-50060-045-000 Pre-employment Physicals/Test 250 250 54 122-50075-045-000 Tuition Reimbursement 0 0 0 MUD FY 2016 SHARE 122-55030-045-000 Software & Support 6,661 6,661 2,775 SEE SCHEDULE GF-L 122-55045-045-000 Legal 2,000 5,000 0 FIRE SOG REVIEW 122-55080-045-000 Maintenance & Repairs 16,370 25,218 15,819 NUMEROUS BUILDING REPAIRS 122-55090-045-000 Vehicle Maintenance 10,000 10,000 5,699 122-60005-045-000 Telephone 50 50 23 122-60010-045-000 Communications/Mobiles 6,653 7,706 5,233 ACTIVE 911 $240- ADDITIONAL EXPENSE OF $1,035 PER FORMER FIRE CHIEF 122-60020-045-000 Electricity/Gas 7,412 7,412 2,152 SEE SCHEDULE GF-K: 50% PAID BY TOWN 122-60025-045-000 Water 1,200 1,200 798 50% PAID BY TOWN 122-60026-045-000 Cable 1,920 1,920 1,053 122-60030-045-000 Rent And/Or Usage 214,379 214,379 214,379 SEE SCHEDULE FD-B 122-60035-045-000 Postage 50 50 8 7 Account Description Original 4/19/2016 YTD Total Budget Amend #1 thru 3/31/16 122-60055-045-000 Insurance 14,077 18,451 11,412 ADDED AMOUNT FOR NEW FIRE TRUCK- TOTAL FOR YEAR $18,451 122-60066-045-000 Publications/Books/Subscrips 350 350 172 AERIAL TRAINING BOOK 122-60070-045-000 Dues & Memberships 15,582 15,582 15,457 SEE SCHEDULE FD-A 122-60080-045-000 Schools & Training 7,880 6,880 2,383 SEE SCHEDULE FD-A- REALLOCATION OF FUNDS PER FORMER FIRE CHIEF 122-60096-045-000 Emergency Management 1,000 1,000 0 122-60100-045-000 Travel & per diem 4,081 2,081 958 SEE SCHEDULE FD-A-REALLOCATION OF FUNDS PER FORMER FIRE CHIEF 122-60110-045-000 Physicals/Testing 4,700 4,700 0 ALL STAFF WILL DO PHYSICALS AND 2 HAZMAT FIT FOR DUTY 122-60125-045-000 Advertising 500 4,700 4,200 ADVERTISING FOR SALE OF FIRE TRUCK 122-60160-045-000 Programs & Special Projects 7,500 7,500 688 $2750 FIRE EDUCATION SCHOOL; $3000 FIRE CAMP & CFA; EVENT COVERAGE 122-60180-045-000 Fire Inspection/Enforcement 500 500 359 122-60195-045-000 Flags & Repair 3,184 3,184 390 ADDITIONAL POLE MAINTENANCE 122-60243-045-000 Prior Year Expense 0 0 0 122-60245-045-000 Miscellaneous Expense 1,000 1,000 491 122-65005-045-000 Fuel & Lube 15,122 15,122 2,195 SEE SCHEDULE GF-M 122-65010-045-000 Uniforms 3,140 3,640 3,011 NEW EMPLOYEE UNIFORMS PER FORMER FIRE CHIEF 122-65015-045-000 Protective Clothing 9,000 9,000 2,886 TWO SETS OF GEAR & ADVANCED CLEANING 122-65030-045-000 Chemicals 600 600 0 FOAM FOR NEW TRUCK 122-65035-045-000 Small Tools 2,000 2,000 1,862 122-65055-045-000 Hardware 750 750 195 SEE SCHEDULE GF-L REPLACEMENT 122-65085-045-000 Office Supplies 500 500 60 122-65105-045-000 Printing 498 498 0 SEE SCHEDULE GF-L 122-69005-045-000 Capital Outlays 0 0 0 122-69008-045-000 Short Term Debt -Principal 0 0 0 122-69009-045-000 Short Term Debt -Interest 0 0 0 122-69050-045-000 Radios 8,000 8,000 0 CONTINUATION OF RADIO REPLACEMENTS 122-69195-045-000 GASB34/Reserve for Replacement 81,420 81,420 81,420 1/10 COST OF NEW FIRE ENGINE; $40,000 FUNDED FROM SALE OF 1996 LADDER TRUCK 122-69255-045-000 Airpacks 0 0 0 REPLACEMENT PROGRAM FOR NFPA STANDARDS; 4 REPLACED PER YEAR ON 3 YEAR CYCLE 122-69305-045-000 Capital Leases 127,149 127,149 127,149 LEASE PAYMENT NO. 1 OF 7 FOR LADDER TRUCK Total 1,365,384 1,384,635 865,166 Total Fire Revenues 1,365,384 1,384,635 Total Fire Expenses 1,365,384 1,384,635 Net Budget Surplus (Deficit)0 0 8 SCHEDULE FD-A Fire Department Dues, Training, and Travel Account Description FY 2016 Budget Detail 122-60070 Dues & Memberships Texas Commission on Fire Protection $1,445 $85.00 per FF X 17 Annual fee TCFP Training Facility $170 Annual fee SFFMA (Volunteer) $275 $100 per dept, $35 per FF (5) NEFDA $12,997 Annual fee increase due to equipment replacement Denton County Chiefs $280 Annual fee Tarrant County Chiefs $100 Annual fee Texas Fire Chiefs $150 Annual fee International Fire Chiefs $165 Annual fee TOTAL:$15,582 122-60080 Schools and Training TCCC Live Fire Training $700 TCFP Annual Certification classes TCCC / NFA $2,000 8 NFA classes TCFP / TEEX / NFA on site classes $500 Instructor cost Haz-Mat Certification $1,480 (2) staff cert Conference regestration $1,700 SFR / Homeland / FMC / FDIC Office Management Classes(Excel, Access)$500 TOTAL:$6,880 122-60100 Travel and Per Diem Southwest Fire / Rescue (Chief Conf)$441 Chief or training officer conference. Homeland Security Conference $800 EMC and Training officer (1) Texas Fire Marshal Conference $840 Fire Marshal Fire Department Instructor Conf (FDIC) International Fire Chiefs $0 Chief or Training Officer TOTAL:$2,081 9 SCHEDULE GF - A FY 16 CAPITAL OUTLAYS WATER - PURCHASES WATER - MAINTENANCE & REPAIRS ADMINISTRATION - PURCHASES DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT 1/2 Ton Truck-Under budget $2,000 25,000 Valley Wood Looping Water Line- Under budget $4,751 30,250 Catepillar 416F Backhoe-Trade In of $14,000 77,000 Transfer Switch Water Plant 26,000 Meter Reading Laptop- Moved from Hardware 16,000 FY 16 Valve Replacements 30,000 Refurnish Pump Housings Water Plant 20,000 Ammonia System 176,000 Total:118,000 Total:282,250 Total:0 WASTEWATER - PURCHASES WASTEWATER - MAINTENANCE & REPAIRS ADMINISTRATION - MAINTENANCE & REPAIRS DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT Portable generator- Reallocated funds 0 Lift Station Control Panels-Recallocation of $17,000 18,000 RESTROOM ADA REMODEL 56,000 Lift Station Pumps - LS#3 & LS#5- Reallocation of $22,000 23,000 Fence 15,000 Aerial WW Line 300,000 Total:0 Total:356,000 Total:56,000 10 SCHEDULE GF-L INFORMATION TECHNOLOGY Account Description Amount 135-55160-030 Professional Outside Services M3- It & Cell Phone Support $51,075 Totals:51,075$ 135-55030-030 Software & Support Used R For Recurring, NR For Non-Recurring. R-Internet Connectivity-WSC 15,600$ R-Internet Connectivity-ATT (Backup & WWTP)1,560$ R-E-Fax 96$ R-STW-Annual Support 36,133$ R-Clear Rec Annual Maintenance 600$ R-Web Hosting 360$ R-Web Maintenance (Domains, SSL Cert, etc)70$ R-Mail Chimp 240$ R-Photoshop 120$ R- Timeclock Plus Support 487$ N- Upgrade of Timeclock Plus Ver.7 2,614$ Replacement for Connect CTY 3,650$ R-Annual Support for Website-Four Man Furnace 2,000$ R-Automatic Meter Reading -Badger 3,950$ R-Pipelogix Maintenance 1,980$ R-AudioTel Remit Plus Annual Support 1,802$ R-AudioTel Annual Scanner Support 585$ ORS software for Meter Reading 9,250$ Totals:81,097$ 135-60005-030 Telephone Main Phone Numbers & Long Distance 50% Shared 4,817$ WWTP Phone Service 5,784$ Phone System Maintenance, 50% Shared.2,248$ Repairs (Non-Maintenance), 50% Shared.1,000$ Totals:13,849$ 135-60235-030 Security R-Access Control System, 50% Shared 1350 Totals:1,350$ 122-55030-045 Description Amount Software & Support - Fire Dept.R-Firehouse Support and Maintenance 263$ R-Denton County RMS Bandwidth, 50% shared 5,700$ R-Web Maintenance (Domains, SSL Cert, etc) 50% shared -$ R-Symantec Image Maintenance, 50% shared -$ 11 R-Anti-Virus Maintenance and Support, 50% shared.80$ R-Malware-Bytes Maintenance and Support, 50% shared.48$ R-Hosted Exchange, 50% shared 510$ R-Web Hosting, 50% shared 60$ Totals:6,661$ 122-65055-045 Description Amount Hardware R-Repair and Maintenance 750$ NR-Replacement Computers -$ NR-Replacement Copiers & Printers -$ NR-Replacement First Responders MDT, 50% shared Totals:750$ 135-65055-030 Description Amount Hardware R-A/V Miscellaneous Equipment, 50% Shared.1,200$ Meter Reading Laptop per MM -$ Moved to Capital Outlay Replacement Hardware 12,394$ Totals:13,594$ 122-65105-045 annual costs. We take the average toner yield Printing and divide it by the page counts to determine the amount of toner needed per device. We have also included a few maintenance kits for the older printers. It does include all the plotter supplies.498$ Totals:498$ We use the following formula to determine the 135-65090-030 annual costs. We take the average toner yield Printer Supplies and divide it by the page counts to determine the amount of toner needed per device. We have also included a few maintenance kits for the older printers. It does include all the plotter supplies.4,003$ Totals:4,003$ 135-69170-030 Copier Rental/Lease Description Amount Monthly lease for the following copiers.4,600$ Totals:4,600$ 135-69195-030 Transfer to Future Replacment Reserve Description Amount Information Systems Replacement Fund -$ ($50,893 Total Assets) Totals:-$ 12