Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 2021 TCMUD Budget 2021-0421
FY 2021 Adopted Annual Budget TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 Trophy Club Municipal Utility District No.1 100 Municipal Dr Trophy Club, TX 76262 (682) 831-4600 General Fund Revenue Tax Collections PID Surcharges Reserve Funds Total Revenue Water Expense Wastewater Expense Board of Directors Expense Administration Expense Non -Departmental Expense Total Expense Net Budget Surplus/Deficit Tax Debt Service Fund Revenue Tax Collections PID Surcharge Total Revenue Debt Service Expense FY 21 Budget Summary TAX RATE SUMMARY Fiscal Years M&O (General Fund) Tax M&O Fire Tax 1 & S (Debt Service) Tax 2020 0.00748 0.06738 0.03787 2021 0.00709 0.06476 0.03589 Total Tax Rate: 0.11273 0.10774 Increase/Decrease: PID Fire Assessment Rate Increase/Decrease: -0.00345 0.06738 0.00019 - 0.00499 0.06476 - 0.00262 PROPERTY VALUE SUMMARY MUD Tarrant Co. MUD Denton Co. PID Out of District & PID Total Value: 9,927,021 136,531 163,725 0 10,227,277 5,327,165 3,026,690 13,230 1,669,510 185,575 10,222,170 5,107 205,281 691,010 114,681 1,010,973 1,002,973 Total Expense 1,002,973 Net Budget Surplus/Deficit 8,000 522,432,262 1,403,005,151 788,523,995 276,544 2,714,237,952 Fire Fund Revenue Tax Collections PID Assessment Reserve Funds Total Revenue Fire Expense Total Expense Net Budget Surplus/Deficit Revenue Debt Service Fund Revenue Total Revenue Debt Service Expense 51,000 1,246,877 510,812 0 1,808,689 1,808,689 1,808,689 0 1,258,324 1,258,324 1,253,824 Total Expense 1,253,824 Net Budget Surplus/Deficit 4,500 FY 2021 Budget Calendar 5/01/2020 - 5/30/2020 Create and update Workforce for new FY budget in OpenGov, create FY Base Budget in OpenGov Create new FY Base Budget in excel, carry over and update prior year data, finalize budget calendar 5/27/2020 Departmental budget meeting for base budget needs and wants, gather supporting documents for Finance, OpenGov training on proposals with departments 6/01/2020 - 6/15/2020 Update excel budget worksheets- Revenue and Tax Bond Debt, TexPool Transfers (I&S) employee cost projections, preliminary tax valuations 6/16/2020 Manager meeting; CIP with 5 year per department 6/16/2020 - 6/21/2020 Meeting individually with Department Heads to address budget demands and projected increases/decreases, department budget proposal submissions due to Finance Department 6/16/2020 - 6/29/2020 Update budget with current YTD through May. Start projections and forecasting for water cost and consumptions Calculate revenues for both water and wastewater, employee benefit forecasting 6/22/2020 - 6/29/2020 Approve/request for resubmittal department proposals, Reach out to Fire Department/Town for proposed Fire budget, update the excel budget with preliminary tax evaluations, calculate preliminary District tax rate 6/30/2020 Meeting with Managers and GM to present "proposed" budget and Capital Needs Update Rate Model and provide NewGen rate reports for assessment 7/01/2020 - 7/15/2020 Finance department updating and finalizing budget projections Work with New Strategies for final rate assessment calculations and PowerPoint 7/10/2020 Budget Meeting with Budget Committee members 7/20/2020 Regular Board Meeting- Committee updates Directors on Budget 7/25/2020 Certified final tax roll numbers released Calculate No-New Revenue and Voter Approval Tax Rates, fill out AG worksheets 7/30/2020 Joint Meeting MUD Board with Council for Fire Budget 8/3/2020 Final projections of budget to New Strategies for rate assessment 8/7/2020 Notify Town of Trophy Club of preliminary fire assessment rate 8/17/2020 Regular Board Meeting- Review Budget and Rates (NewGen presents) if required 8/30/2020 Notice of Public Hearing/Current and proposed tax rates published in Star Telegram paper 9/21/2020 Public Hearing/Board meeting, adoption of property tax rates, passage of tax resolutions 9/22/2020 Post Notice to Purchaser with new tax rates *Some of the following dates are estimated and maybe subject to change as needed I FY 2021 Tax/Assess Rate = 0.064761 Certified 7/24/2020 7/27/2020 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 19,254,374 FY 2021 Tax Rate = 0.035891 TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: DENTON CO. PID: $522,432,262 $1,403,005,151 $788,523,995 OUT OF DISTRICT & PID $276,544 REQUIRED REVENUE FIRE $1,757,689 M&O TAX/SURCHARGE RATE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 27,142,380 Revenue from MUD Tax = Revenue from PID Assess = NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: $ 1,246,877 $ 510,812 Total: $ 1,757,689 522,432,262 1,403,005,151 DENTON CO. PID: 788,523,995 REQUIRED REVENUE M&O 185,575 168,800 *MUD (All of Dept. 39 Budget) "PID (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID Certified 7/24/2020 7/27/2020 7/27/2020 7/24/2020 Certified 7/24/2020 7/27/2020 7/27/2020 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 27,139,614 FV 2021 MUD M&O Tax Rate = 0.00709 FY 2021 PID Tax/Surcharge Rate = 0.00622 Revenue from MUD Tax = Revenue from PID Surcharge = NET TAX VALUE: $ 136,531 $ 49,044 Total: $ 185,575 TARRANT COUNTY: $522,432,262 DENTON COUNTY: $1,403,005,151 DENTON CO. PID: $788,523,995 REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $394,713 MUD DEBT: CALCULATE MUD TAX Certified 7/24/2020 7/27/2020 7/27/2020 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 27,139,614 FY 2021 PID Surcharge Rate = 0.01454 ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax = Revenue from PID Surcharge = $ 280,031 $ 114,681 NET TAX VALUE: Total: $ 394,713 TARRANT COUNTY: $522,432,262 DENTON COUNTY: $1,403,005,151 REQUIRED REVENUE I&S MUD DEBT 5691,010 Revenue from MUD Tax = Revenue from PID = N/A 691,010 Total: $ 691,010 OVERALL TAX RATE FY 2021: $0.107738 VOTER APPROVAL RATE $0.109106 M&O (General Fund) Tax M&O Fire Tax I & S (Debt Service) Tax Total Tax Rate: Increase/Decrease: PID Fire Assessment Rate TAX COMPARISON 2020 2021 0.00748 0.00709 0.06738 0.06476 0.03787 0.03589 0.11273 0.10774 -0.00345 -0.00499 0.06738 0.06476 FIRE DEPARTMENT Account Description FY 2018 Actual FY 2019 Actual FY 2020 Adopted FY 2021 Adopted Budget vs Budget Net Budget Change % FY 2020 Actual FY 2020 Budget % Revenues -Town 122-01-256-40004 Assessment - Emerg Svcs 490,697 500,666 506,789 510,812 4,023 0.79% 513,618 101.35% 122-01-256-40003 122-01-256-40015 122-01-256-41320 122-01-256-43400 122-01-256-44004 122-01-256-42500 Emer Svcs Assessmen/Delinquent Property Taxes/Assessments P&I Fire Permits/Sprinkler & Plan Review Fire Inspections Denton/Tarrant Cty Pledge -Fire Grant Revenue 83,704 57,841 46,000 35,000 10,000 10,000 Revenues -MUD 122-40001-000-000 122-40010-000-000 122-40011-000-000 122-40020-000-000 122-49000-000-000 122-49026-000-000 122-49035-000-000 122-49036-000-000 122-49900-000-000 1 1 Assessment-Emerg Svcs Reimb from Town Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&I Capital Leases -Other Financial Sources Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Expenses -Town 122-01-256-50100 122-01-256-50101 122-01-256-50130 122-01-256-50140 122-01-256-50160 122-01-256-51200 122-01-256-51210 122-01-256-51215 122-01-256-51216 122-01-256-51218 122-01-256-52220 122-01-256-52225 122-01-256-52250 122-01-256-52260 122-01-256-52290 122-01-256-53240 122-01-256-60100 122-01-256-60800 122-01-256-61150 122-01-256-63200 122-01-256-63250 122-01-256-63551 122-01-256-64000 122-01-256-64100 122-01-256-64300 122-01-256-64400 122-01-256-65200 122-01-256-65300 122-01-256-65350 122-01-256-66250 122-01-256-66500 122-01-256-68100 122-01-256-68190 122-01-256-68200 122-01-256-70100 122-01-256-70200 122-01-256-70300 122-01-256-70400 122-01-256-71000 122-01-256-72100 122-01-256-72300 122-01-256-78400 122-01-256-78600 122-01-256-79100 122-01-256-79999 122-01-256-83700 122-01-256-87100 10,000 16,000 55,000 (11,000) -23.91% 47,977 104.30% 6,000 60.00% 17,072 170.72% (55,000) -100.00% 17,009 30.93% 1 1 1 1,066,061 3,945 4,787 1,103,690 1,214,230 1,246,877 3,166 5,126 32,647 2.69% 1,223,805 3,736 6,897 100.79% 0.00% Miscellaneous Income 135,611 - - - 24,423 Total Revenue 1,659,193 1,816,100 1,832,019 1,808,689 (23,330) -1.27% 1,854,538 101.23% Salaries- Regular Salaries- Part Time Salaries- Overtime Salaries- Longevity Certification Pay Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Physicals/Testing Tuition Reimbursement Professional Outside Services Software & Support Tax Adminstration Advertising Printing Schools & Training Electricity Water Telephone Communications/Mobiles Building Maintenance Vehicle Maintenance Equipment Maintenance Emergency Management Dispatch- Denton County Dues & Memberships Flags & Repair Travel & per diem Office Supplies Printer Supplies Postage Publications/Books/Subscrips Fuel Uniforms Safety Equipment/Protective Clothing Small Equipment Hardware Maintenance & Supplies Miscellaneous Expense Capital Outlays Programs & Special Projects 582,657 665,043 71,354 91,609 5,856 6,358 4,950 7,564 83,513 103,227 59,991 93,982 5,388 5,447 569 599 3,316 3,989 37,002 46,593 8,651 10,893 1,620 291 8,639 9,638 7,417 3,117 3,488 3,289 125 550 2,784 12,123 1,529 155 15,392 4,895 3,203 15,884 14,335 49,770 12,394 158 3,045 19,601 1,000 7,280 289 1,041 53 267 9,082 6,338 25,217 5,499 914 386 3,246 10,745 219 12,887 4,790 2,823 12,792 24,520 46,433 11,202 1,000 3,706 19,616 9,441 11,153 317 1,020 82 344 10,611 5,787 31,343 6,428 3,268 444 3,949 13,309 685,229 670,420 50,078 72,896 72,896 6,890 6,730 9,750 9,750 99,005 106,114 79,220 78,087 6,670 6,045 612 576 4,982 5,171 46,795 51,123 10,944 11,956 1,625 1,625 16,762 20,177 6,675 6,675 8,290 8,290 5,500 1,750 16,749 17,164 1,605 1,605 1,500 1,500 300 500 24,505 19,900 8,400 8,400 4,000 4,000 16,691 16,691 22,200 22,200 41,800 40,800 18,000 18,000 1,000 1,000 3,986 3,946 20,337 20,337 14,510 300 1,400 100 350 12,215 7,145 27,700 4,950 4,458 1,500 4,000 14,900 14,510 500 1,400 100 350 12,215 9,645 27,700 4,950 4,458 1,500 4,000 17,005 (14,809) -2.16% 671,577 50,078 0.00% 0.00% 75,008 (160) -2.32% 6,838 0.00% 9,063 7,109 7.18% 100,538 (1,133) -1.43% 76,605 (625) -9.37% 5,514 (36) -5.88% 525 189 3.79% 4,087 4,328 9.25% 44,880 1,012 9.25% 10,496 0.00% 426 3,415 20.37% 15,004 0.00% 3,867 0.00% 1,497 (3,750) -68.18% - 415 2.48% 12,495 (0) -0.03% 0.00% 200 66.67% 141 (4,605) -18.79% 14,427 0.00% 4,970 0.00% 3,935 0.00% - 0.00% 12,345 0.00% 22,727 (1,000) -2.39% 31,865 0.00% 5,719 0.00% 1,000 (40) -1.00% 3,986 0.00% 19,782 0.00% - 0.00% 5,326 200 66.67% 390 0.00% 0.00% 31 0.00% 334 0.00% 6,959 2,500 34.99% 7,001 0.00% 24,353 0.00% 3,591 0.00% 2,592 0.00% 1,113 0.00% 27,936 0.00% - 2,105 14.13% 18,023 98.01% 0.00% 102.90% 99.24% 92.95% 101.55% 96.70% 82.66% 85.86% 82.03% 95.91% 95.91% 26.20% 89.51% 57.93% 18.06% 0.00% 74.60% 0.00% 0.00% 46.86% 58.87% 59.17% 98.38% 0.00% 73.96% 102.37% 76.23% 31.77% 100.00% 100.00% 97.27% 0.00% 36.71% 130.11% 0.00% 31.25% 95.56% 56.97% 97.99% 87.92% 72.54% 58.15% 74.18% 698.39% 0.00% 120.96% FIRE DEPARTMENT Account Description FY 2018 Actual FY 2019 Actual FY 2020 Adopted FY 2021 Adopted Budget vs Budget Net Budget Change % FY 2020 Actual FY 2020 Budget % Expenses -MUD 122-55080-045-000 Maintenance & Repairs (GASB34) 1,490 - - - 5,900 122-60030-045-000 122-60055-045-000 122-60337-045-000 122-69005-045-000 122-69008-045-000 122-69009-045-000 122-69195-045-000 122-69305-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Capital Outlays Short Term Debt -Principal Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases Principal Total 218,954 215,979 218,004 197,281 15,238 17,895 21,000 21,000 64,482 48,000 (20,723) -9.51% 0.00% 218,004 100.00% 19,691 93.76% (48,000) -100.00% 39,743 82.80% 14,768 11,958 9,078 6,127 (2,951) -32.51% 9,078 100.00% 81,420 81,420 81,420 81,420 - 0.00% 81,420 100.00% 112,381 115,190 118,070 121,022 2,952 2.50% 118,070 100.00% 1,541,761 1,810,249 1,832,019 1,808,689 (23,330) -1.27% 1,748,871 95.46% Total Fire Revenues Total Fire Expenses Net Budget Surplus (Deficit) 1,659,193 1,816,100 1,832,019 1,808,689 (23,330) -1.27% 1,854,538 101.23% 1,541,761 1,810,249 1,832,019 1,808,689 (23,330) -1.27% 1,748,871 95.46% 117,432 5,851 - - 105,667 Town/MUD Fire Contract Calculation 1 1 1 FY 2020 1 FY 2021 Fire Budget 1,832,019 1,808,689 Less: Rent/Debt Service 218,004 197,281 Less: TML Fire Insurance 21,000 21,000 Less: Capital Outlays 48,000 - Less: Capital Leases lnterest 9,078 6,127 Less: Capital Leases Principal 118,070 121,022 Less: GASB34/Reserve for Replacement 81,420 81,420 Less: ESD Assessment 506,789 510,812 Less: Fire Permits/Sprinkler 46,000 35,000 Less: Fire Inspections - - Less: Denton County Fire Pledge 10,000 16,000 Less: Grant Proceeds 55,000 - 122-60337-045-000 Transfer to Town from MUD/Fire Budget 718,657 820,027 Monthly payment to Town Oct -Sept 59,888 68,336 General Fund Account Description FY 2017 Actual FY 2018 Actual FY 2019 Actual FY 2020 Adopted FY 2020 Amended FY 2021 Adopted Budget vs Budget Net Prior Year Change % FY 2020 Actual FY 2020 Budget % General Fund Revenues 135-40000-000-000 Property Taxes 135-40002-000-000 Property Taxes/Delinquent 135-40015-000-000 Property Taxes/P & I 135-40025-000-000 PID Surcharges 135-47000-000-000 Water 135-47005-000-000 Sewer 135-47025-000-000 Penalties 135-47030-000-000 Service Charges (Disconnect Fees) 135-47035-000-000 Plumbing Inspections 135-47045-000-000 Sewer Inspections 135-47070-000-000 TCCC Effluent Charges 135-48010-000-000 Utility Fees 135-49000-000-000 Capital Lease- Oth Fin Sources 135-49011-000-000 Interest Income 135-49016-000-000 Cell Tower Revenue 135-49018-000-000 Building Rent Income 135-49026-000-000 Proceeds from Sale of Assets 135-49035-000-000 Prior Year Reserves 135-49036-000-000 GASB Reserves 135-49005-000-000 Loan Proceeds 135-49075-000-000 Oversize Meter Reimbursement 135-49141-000-000 Interfund Transfer In 135-49145-000-000 Intergov Transfer In 135-49900-000-000 Miscellaneous Income 135-49901-000-000 Records Management Revenue 135-49903-000-000 Recovery of Prior Year Expense 135-00000-000-000 Reimbursement 1Total 1 61,008 122,279 125,687 134,871 134,871 136,531 1,660 1.23% 135,857 100.73% 290 347 (327) 300 300 300 - 0.00% 402 133.93% 350 530 570 300 300 300 - 0.00% 769 256.21% 103,619 195,528 163,043 164,253 164,253 163,725 (528) -0.32% 164,700 100.27% 5,822,785 6,035,804 5,243,386 6,486,623 6,000,000 5,932,489 (554,134) -8.54% 5,765,931 88.89% 2,587,176 3,035,824 3,124,552 3,503,885 3,200,000 3,677,146 173,261 4.94% 3,254,599 92.89% 121,528 119,594 98,969 112,608 60,000 112,608 - 0.00% 61,753 54.84% 14,100 13,881 15,850 15,150 10,000 16,550 1,400 9.24% 9,950 65.68% 2,400 2,200 2,750 750 4,500 750 - 0.00% 5,300 706.67% 4,800 5,800 4,150 2,500 2,500 2,500 - 0.00% 5,050 202.00% 87,159 81,611 57,003 50,000 80,000 50,000 - 0.00% 89,037 178.07% - - - - - - - 0.00% - 0.00% - - 205,504 - - - - 0.00% - 0.00% 18,940 61,282 139,388 120,000 80,000 100,000 (20,000) -16.67% 81,518 67.93% 10,926 12,077 15,651 14,146 14,146 14,146 0.00% 12,967 91.67% 7,000 7,000 7,000 7,000 7,000 - (7,000) -100.00% 5,833 83.33% 39,899 15,400 52,600 13,000 13,000 5,000 (8,000) -61.54% 12,520 96.31% - - - 160,011 - - 0.00% - 0.00% - 150,000 - - 0.00% 0.00% - 360,100 32,080 - - - - 0.00% - 0.00% 20,864 14,237 41,295 12,691 12,691 8,232 (4,459) -35.14% 19,732 155.48% 797,834 32,080 - - - - 0.00% - 0.00% - - - - - 0.00% - 0.00% (27,448) 16,547 14,216 7,000 21,000 7,000 - 0.00% 35,761 510.86% 32 2 6 - - - - 0.00% - 0.00% 81,791 - - 0.00% 0.00% - - - - - 0.00% - 0.00% 8,957,220 1 10,897,878 1 9,525,452 1 10,645,077 1 9,964,572 1 10,227,277 1 (417,800)1 -3.92%1 9,661,678 1 Water General Fund Expenses - 135-50005-010-000 Salaries & Wages 232,082 245,349 308,939 350,267 350,267 365,309 15,042 4.29% 358,683 102.40% 135-50010-010-000 Overtime 13,069 14,433 12,323 17,000 20,000 17,000 - 0.00% 20,986 123.45% 135-50016-010-000 Longevity 3,270 3,310 3,620 3,920 5,083 5,435 1,515 38.65% 5,083 129.66% 135-50017-010-000 Certification 2,600 2,425 2,125 5,400 5,400 6,000 600 11.11% 4,900 90.74% 135-50020-010-000 Retirement 21,489 24,919 30,416 34,863 34,863 36,520 1,657 4.75% 35,476 101.76% 135-50026-010-000 Medical Insurance 30,038 32,816 41,853 84,326 84,326 86,182 1,856 2.20% 59,351 70.38% 135-50027-010-000 Dental Insurance 2,942 2,589 2,995 4,725 4,725 4,933 208 4.41% 3,641 77.06% 135-50028-010-000 Vision Insurance 578 460 490 767 767 789 21 2.79% 563 73.35% 135-50029-010-000 Life Insurance & Other 2,576 2,573 2,574 3,132 4,132 3,289 156 4.98% 3,752 119.79% 135-50030-010-000 Social Security Taxes 15,286 16,345 19,845 23,348 23,348 24,412 1,064 4.56% 23,871 102.24% 135-50035-010-000 Medicare Taxes 3,575 3,823 4,641 5,461 5,461 5,709 249 4.56% 5,583 102.24% 135-50040-010-000 Unemployment Taxes 51 819 47 1,080 1,080 1,080 - 0.00% 974 90.16% 135-50045-010-000 Workman's Compensation 11,864 10,799 10,901 11,850 11,850 10,877 (973) -8.21% 8,846 74.65% 135-50060-010-000 Pre-emp Physicals/Testing 347 285 370 400 400 400 - 0.00% 235 58.73% 135-50070-010-000 Employee Relations 187 178 74 300 300 300 0.00% 87 29.02% 135-55005-010-000 Engineering 25,390 - 6,069 20,000 - 20,000 - 0.00% - 0.00% 135-55080-010-000 Maintenance & Repairs 87,258 100,901 128,828 100,000 75,000 124,000 24,000 24.00% 60,089 60.09% 135-55085-010-000 Generator Maintenance & Repairs 2,459 770 1,906 3,000 3,000 3,000 - 0.00% 847 28.23% 135-55090-010-000 Vehicle Maintenance 2,253 5,216 4,770 5,000 5,000 5,000 - 0.00% 6,003 120.06% 135-55105-010-000 Maintenance -Heavy Equipment - 35 3,500 3,500 3,500 - 0.00% 1,828 52.23% 135-55120-010-000 Cleaning Services - 175 1,000 1,000 1,000 - 0.00% 1,050 105.00% 135-55135-010-000 Lab Analysis - MUD 3,948 7,413 8,104 7,500 7,500 7,500 - 0.00% 4,561 60.81% 135-60010-010-000 Communications/Mobiles 4,589 3,973 3,771 5,000 5,500 7,500 2,500 50.00% 5,334 106.67% 135-60020-010-000 Electricity 156,752 140,190 113,377 125,677 125,677 123,487 (2,190) -1.74% 131,998 105.03% 135-60066-010-000 Publications/Books/Subscripts 767 767 790 1,000 1,000 1,000 - 0.00% 850 85.00% 135-60070-010-000 Dues & Memberships - - 122 500 500 500 - 0.00% 105 21.00% 135-60080-010-000 Schools & Training 936 2,889 3,581 7,426 2,500 7,426 - 0.00% 2,920 39.32% 135-60090-010-000 Safety Program 8 - 400 400 400 - 0.00% - 0.00% 135-60100-010-000 Travel & per diem 124 87 2,544 2,845 500 2,875 30 1.05% 0.00% 135-60105-010-000 Rent/Lease Equipment - - - 1,500 1,500 1,500 - 0.00% - 0.00% 135-60135-010-000 TCEQ Fees & Permits - MUD 31,064 24,220 21,084 63,000 30,000 30,000 (33,000) -52.38% 25,706 40.80% 135-60150-010-000 Wholesale Water 2,068,311 2,257,593 1,977,849 2,714,710 2,299,249 2,596,295 (118,415) -4.36% 1,865,024 68.70% 135-60245-010-000 Miscellaneous Expenses 103 - 200 200 200 - 0.00% - 0.00% 135-60280-010-000 Property Maintenance 775 975 612 3,000 3,000 3,000 0.00% 1,392 46.40% 135-60285-010-000 Lawn Equipment & Maintenance 8,250 11,250 8,090 14,750 14,750 14,750 - 0.00% 6,000 40.68% 135-60332-010-000 Interfund Transfer Out- Revenue I&S 240,822 278,084 276,901 527,381 527,381 565,820 38,438 7.29% 527,381 100.00% 135-60333-010-000 Interfund Transfer Out- Bond Reserve 48,047 48,996 55,200 55,193 36,800 - (55,193) -100.00% 36,800 66.68% 135-60334-010-000 Interfund Transfer Out -Bank Reserve Account - - - 180,000 180,000 75,000 (105,000) -58.33% - 0.00% 135-60360-010-000 Furniture/Equipment < $5000 - 5,020 - 2,500 2,500 2,500 - 0.00% 562 22.47% 135-65005-010-000 Fuel & Lube 8,733 11,489 10,479 15,000 15,000 15,000 0.00% 10,066 67.11% 135-65010-010-000 Uniforms 3,064 2,632 2,219 5,190 5,190 5,190 - 0.00% 3,425 66.00% 135-65030-010-000 Chemicals 24,217 18,687 22,270 20,000 20,000 25,000 5,000 25.00% 21,491 107.46% 135-65035-010-000 Small Tools 868 - - 1,200 1,200 1,200 - 0.00% - 0.00% General Fund Account Description FY 2017 Actual FY 2018 Actual FY 2019 Actual FY 2020 Adopted FY 2020 Amended FY 2021 Adopted Budget vs Budget Net Prior Year Change % FY 2020 Actual FY 2020 % Budget 135-65040-010-000 Safety Equipment 507 1,081 641 1,000 1,000 1,000 - 0.00% - 0.00 135-65050-010-000 Meter Expense 24,000 24,976 55,003 70,000 70,000 70,000 - 0.00% 61,774 88.25% 135-65053-010-000 Meter Change Out Program 71,160 82,313 86,949 87,000 87,000 87,000 - 0.00% 36,900 42.41% 135-69005-010-000 Capital Outlays 323,263 488,427 1,147,521 684,875 772,475 740,000 55,125 8.05% 451,480 65.92% 135-69008-010-000 Short Term Debt -Principal - - 30,068 30,512 30,512 30,962 450 1.47% 30,512 100.00% 135-69009-010-000 Short Term Debt -Interest - 2,271 4,124 3,231 3,231 2,324 (907) -28.07% 3,230 99.98% 135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 75,000 75,000 - 0.00% 475,899 634.53% 135-69281-010-000 Water Tank Inspection Contract 126,958 107,864 99,877 120,000 102,077 108,000 (12,000) -10.00% 102,077 85.06% 135-70040-010-000 Bond Related Expenses - - 39,160 - - - - 0.00% 1,220 0.00% 135-55135-010-001 Lab Analysis - PID 2,183 1,753 1,799 2,000 2,000 2,000 - 0.00% 2,216 110.78% 135-60135-010-001 TCEQ Fees & Permits - PID - - - - - 0.00% - 0.00% !Subtotal Water 1 3,681,756 1 4,066,003 1 4,630,096 1 5,506,929 1 5,063,144 1 5,327,165 1 (179,765)1 -3.26961 4,410,770 1 0.00% Wastewater ` 1 1 1 ` 1 135-50005-020-000 Salaries & Wages 387,947 362,490 354,641 441,799 441,799 483,633 41,834 9.47% 425,068 96.21% 135-50010-020-000 Overtime 31,979 37,047 33,704 33,000 30,000 33,000 - 0.00% 22,679 68.72% 135-50016-020-000 Longevity 6,635 7,415 7,445 8,035 6,873 7,420 (615) -7.65% 6,873 85.53% 135-50017-020-000 Certification 8,275 8,436 8,575 9,000 9,000 8,100 (900) -10.0096 7,575 84.17% 135-50020-020-000 Retirement 38,208 38,361 37,618 45,531 45,531 49,358 3,827 8.40% 42,091 92.44% 135-50026-020-000 Medical Insurance 55,136 65,584 60,272 104,858 104,858 122,035 17,177 16.38% 84,736 80.81% 135-50027-020-000 Dental Insurance 4,464 4,692 4,181 5,817 5,817 6,443 625 10.74% 4,900 84.23% 135-50028-020-000 Vision Insurance 954 803 677 948 948 1,098 149 15.75% 784 82.70% 135-50029-020-000 Life Insurance & Other 4,552 4,205 4,088 4,500 4,500 4,725 225 5.00% 4,563 101.39% 135-50030-020-000 Social Security Taxes 25,343 23,764 23,840 30,494 30,494 32,993 2,500 8.20% 27,142 89.01% 135-50035-020-000 Medicare Taxes 5,927 5,558 5,576 7,132 7,132 7,716 585 8.20% 6,348 89.01% 135-50040-020-000 Unemployment Taxes 63 1,134 54 1,260 1,260 1,440 180 14.29% 1,100 87.34% 135-50045-020-000 Workman's Compensation 14,903 16,176 14,119 15,373 15,373 14,607 (766) -4.98% 12,653 82.31% 135-50060-020-000 Pre-emp Physicals/Testing 80 273 190 400 400 400 - 0.00% 357 89.25% 135-50070-020-000 Employee Relations 461 - 76 300 300 300 - 0.00% 105 34.90% 135-55005-020-000 Engineering 852 - - 30,000 30,000 30,000 - 0.00% 23,200 77.33% 135-55070-020-000 Independent Labor 19,449 2,145 2,921 15,000 15,000 15,000 - 0.00% 3,000 20.00% 135-55080-020-000 Maintenance & Repairs 97,990 74,141 114,795 88,000 73,000 108,000 20,000 22.73% 87,020 98.89% 135-55081-020-000 Maintenance & Repairs- Collections - - - 10,000 25,000 157,500 147,5001475.00% 27,259 272.59% 135-55085-020-000 Generator Maintenance & Repairs 6,076 1,595 6,160 10,000 2,500 10,000 - 0.00% 3,198 31.98% 135-55090-020-000 Vehicle Maintenance 9,836 9,572 2,894 4,000 4,000 4,000 - 0.00% 1,203 30.08% 135-55091-020-000 Vehicle Maintenance- Collections - - - 8,000 8,000 13,000 5,000 62.50% 2,173 27.17% 135-55105-020-000 Maintenance -Heavy Equipment 24 395 8,781 3,000 3,000 3,000 - 0.00% 1,471 49.02% 135-55120-020-000 Cleaning Services - 263 1,500 1,500 1,500 - 0.00% 1,050 70.00% 135-55125-020-000 Dumpster Services 56,329 68,016 71,124 100,000 100,000 100,000 - 0.00% 91,387 91.39% 135-55135-020-000 Lab Analysis 32,416 31,558 33,902 40,000 40,000 40,000 - 0.00% 37,205 93.01% 135-60010-020-000 Communications/Mobiles 5,460 4,844 4,927 5,000 5,500 7,500 2,500 50.00% 5,716 114.32% 135-60020-020-000 Electricity 145,449 161,571 147,288 160,067 160,067 157,735 (2,332) -1.46% 132,686 82.89% 135-60066-020-000 Publications/Books/Subscripts 150 - - 200 200 200 - 0.00% - 0.00% 135-60070-020-000 Dues & Memberships 267 60 191 300 300 300 - 0.00% 216 72.00% 135-60080-020-000 Schools & Training 2,959 658 1,794 4,991 4,991 4,991 - 0.00% 4,349 87.13% 135-60090-020-000 Safety Program 291 352 314 1,000 1,000 1,000 - 0.00% 109 10.91% 135-60100-020-000 Travel & per diem 2,625 90 2,523 1,545 1,545 1,575 30 1.94% 411 26.58% 135-60105-020-000 Rent/Lease Equipment - - 3,491 5,000 5,000 5,000 - 0.00% - 0.00% 135-60125-020-000 Advertising 4,086 - - 2,500 2,500 2,500 - 0.00% - 0.00% 135-60135-020-000 TCEQ Fees & Permits 32,564 30,273 16,545 15,000 15,000 45,000 30,000 200.00% 10,088 67.25% 135-60245-020-000 Miscellaneous Expenses 113 0 4 450 450 450 - 0.00% - 0.00% 135-60280-020-000 Property Maintenance - 274 4,134 5,000 5,000 5,000 - 0.00% 2,618 52.37% 135-60285-020-000 Lawn Equipment & Maintenance 6,490 8,730 7,119 14,000 14,000 14,000 - 0.00% 6,525 46.61% 135-60331-020-000 Interfund Transfer Out -Tax l&S 120,492 122,043 120,053 114,563 114,563 114,681 118 0.10% 114,563 100.00% 135-60332-020-000 Interfund Transfer Out- Revenue I&S 595,638 598,738 596,238 673,867 673,867 688,005 14,137 2.10% 673,867 100.00% 135-60333-020-000 Interfund Transfer Out -Bond Reserve - 123,336 125,184 125,187 46,000 - (125,187) -100.00% 46,000 36.75% 135-60334-020-000 Interfund Transfer Out -Bank Reserve Account 180,417 - - 180,000 180,000 75,000 (105,000) -58.33% - 0.00% 135-60360-020-000 Furniture/Equipment < $5000 - 1,762 791 2,000 2,000 2,000 - 0.0096 1,055 52.75% 135-65005-020-000 Fuel & Lube 8,722 9,009 12,243 12,500 12,500 12,500 - 0.00% 8,220 65.76% 135-65010-020-000 Uniforms 3,754 2,930 2,713 5,495 5,495 6,280 785 14.2996 3,732 67.92% 135-65030-020-000 Chemicals 25,101 19,716 31,632 20,000 27,000 25,000 5,000 25.00% 23,055 115.27% 135-65031-020-000 Chemicals -Collections - - - 17,500 10,500 17,500 - 0.0096 10,449 59.71% 135-65035-020-000 Small Tools 2,191 1,436 1,143 1,200 1,200 1,200 0.00% - 0.00% 135-65040-020-000 Safety Equipment 517 1,158 1,638 1,200 1,200 1,200 - 0.0096 1,167 97.21% 135-65045-020-000 Lab Supplies 13,258 20,748 18,456 20,000 25,000 28,000 8,000 40.00% 26,446 132.23% 135-69005-020-000 Capital Outlays 276,328 128,991 756,778 530,500 602,910 335,000 (195,500) -36.8596 324,270 61.13% 135-69008-020-000 Short Term Debt -Principal - - 58,709 79,133 79,133 81,273 2,140 2.70% 79,142 100.01% 135-69009-020-000 Short Term Debt -Interest - 3,011 9,458 11,277 11,277 8,532 (2,745) -24.3496 11,269 99.93% 135-69195-020-000 Gasb34/Reserve for Replacement - 30,000 30,000 130,000 130,000 130,000 - 0.00% 530,899 408.38% 135-70020-020 Capital Lease Issuance Cost - 1,500 1,500 - - - - 0.00% 0.00% !Subtotal Wastewater '4,586 1 2,750,762 1 3,157,421 1 3,144,482 1 3,026,690 1 (130,730)1 -4.14961 2,941 Account Description FY 2017 Actual FY 2018 Actual FY 2019 Actual FY 2020 Adopted FY 2020 Amended FY 2021 Adopted Budget vs Budget Net Prior Year Change % FY 2020 Actual General Fund Board of Directors 135-50005-026-000 135-50030-026-000 135-50035-026-000 135-55040-026-000 135-50045-026-000 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Salaries & Wages Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses !Subtotal Board of Directors 30 29 25 30 30 30 - 150 150 150 - 650 650 750 750 750 145 135 105 1,300 1,300 1,300 3,557 2,755 920 4,000 500 4,000 2,690 4,768 800 5,000 500 5,000 75 1,474 - 2,000 500 2,000 I 6,498 1 9,811 1 2,500 1 13,230 1 3,730 1 13,230 1 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%1 FY 2021d! Budget 0.00% 0.00% 0.00% - 0.00% 24 79.50% - 0.00% 675 90.00% 1,034 79.52% - 0.00% 0.00% - 0.00% 1,733 1 0.00% - Administration ' I i 1 1 1i 1 1 1 1 1 135-50005-030-000 Salaries & Wages 432,978 383,692 380,629 628,298 475,000 626,592 (1,706) -0.27% 453,839 72.23% 135-50010-030-000 Overtime 3,498 566 58 2,000 2,000 2,000 - 0.00% 50 2.52% 135-50016-030-000 Longevity 3,418 3,548 1,833 2,208 2,208 2,668 460 20.84% 2,208 100.00% 135-50020-030-000 Retirement 37,687 36,819 35,474 58,554 42,000 58,550 (4) -0.01% 41,774 71.34% 135-50026-030-000 Medical Insurance 44,204 49,850 51,652 124,394 81,000 136,834 12,440 10.00% 80,099 64.39% 135-50027-030-000 Dental Insurance 3,938 3,277 3,409 6,464 4,500 7,109 645 9.98% 4,436 68.62% 135-50028-030-000 Vision Insurance 842 590 547 1,035 1,035 1,138 103 9.92% 667 64.47% 135-50029-030-000 Life Insurance & Other 4,426 3,735 3,894 4,500 4,500 4,730 230 5.11% 4,307 95.70% 135-50030-030-000 Social Security Taxes 25,994 23,075 22,675 39,215 26,000 39,138 (77) -0.20% 26,325 67.13% 135-50035-030-000 Medicare Taxes 6,079 5,397 5,303 9,171 6,200 9,153 (18) -0.20% 6,157 67.13% 135-50040-030-000 Unemployment Taxes 294 1,146 60 1,440 1,440 1,440 - 0.00% 1,008 70.00% 135-50045-030-000 Workman's Compensation 1,796 1,482 1,239 1,775 1,775 1,573 (202) -11.39% 1,178 66.37% 135-50060-030-000 Pre-emp Physicals/Testing 701 212 180 500 500 500 - 0.00% - 0.00% 135-50070-030-000 Employee Relations 2,692 4,351 3,165 8,000 4,000 8,000 0.00% 3,140 39.25% 135-55005-030-000 Engineering - - - - - - - 0.00% - 0.00% 135-55030-030-000 Software & Support 88,943 68,007 139,396 134,681 154,681 126,854 (7,827) -5.81% 124,037 92.10% 135-55070-030-000 Independent Labor 30,925 153,669 152,578 135,000 100,000 15,000 (120,000) -88.89% 90,481 67.02% 135-55080-030-000 Maintenance & Repairs 826 10,584 5,676 15,000 30,000 40,000 25,000 166.67% 18,794 125.29% 135-55085-030-000 Generator Maintenance & Repairs 485 5,205 928 10,000 10,000 10,000 - 0.00% 1,169 11.69% 135-55100-030-000 Building Maint & Supplies 7,705 - - - - - - 0.00% - 0.00% 135-55120-030-000 Cleaning Services 6,705 10,046 10,429 10,000 15,000 15,000 5,000 50.00% 17,143 171.43% 135-55160-030-000 Professional Outside Services 63,965 62,300 69,427 65,600 65,600 104,925 39,325 59.95% 57,100 87.04% 135-55205-030-000 Utility Billing Contract 7,514 7,063 6,974 9,000 9,000 9,000 - 0.00% 7,132 79.25% 135-60005-030-000 Telephone 14,081 18,246 17,696 23,680 23,680 9,680 (14,000) -59.12% 24,055 101.58% 135-60010-030-000 Communications/Mobiles 3,621 2,986 2,853 4,000 3,000 3,000 (1,000) -25.00% 2,784 69.61% 135-60020-030-000 Electricity 11,002 6,591 6,792 6,879 6,879 14,512 7,633 110.96% 6,315 91.80% 135-60025-030-000 Water 1,041 719 682 1,500 1,500 5,000 3,500 233.33% 1,945 129.64% 135-60035-030-000 Postage 27,334 21,120 21,652 30,000 25,000 30,000 - 0.00% 20,402 68.01% 135-60040-030-000 Bank Service Charges & Fees 52,782 62,356 66,236 67,000 67,000 67,000 - 0.00% 73,964 110.39% 135-60050-030-000 Bad Debt Expense 1,674 - - 1,500 1,500 1,500 - 0.00% 16,874 1124.95% 135-60055-030-000 Insurance 59,614 76,999 75,633 84,000 80,419 84,000 - 0.00% 79,988 95.22% 135-60066-030-000 Publications/Books/Subscripts 770 360 - 1,000 1,000 1,000 - 0.00% 125 12.50% 135-60070-030-000 Dues & Memberships 4,851 3,988 4,269 6,000 6,000 6,000 - 0.00% 4,607 76.79% 135-60075-030-000 Meetings 122 134 176 400 400 400 - 0.00% 149 37.22% 135-60079-030-000 Public Education 4,972 - 561 6,000 6,000 6,000 - 0.00% 1,875 31.25% 135-60080-030-000 Schools & Training 2,255 3,238 1,172 6,850 3,000 6,850 - 0.00% 3,018 44.06% 135-60100-030-000 Travel & per diem 7,112 1,677 218 3,545 1,500 3,575 30 0.85% 1,205 33.99% 135-60110-030-000 Physicals/Testing - - 200 200 200 - 0.00% - 0.00% 135-60115-030-000 Elections 2,961 220 - - 200 5,000 5,000 0.00% 138 0.00% 135-60125-030-000 Advertising 2,323 925 1,222 2,500 6,000 2,500 - 0.00% 6,112 244.47% 135-60235-030-000 Security - 442 288 1,288 1,288 1,288 - 0.00% 264 20.50% 135-60245-030-000 Miscellaneous Expenses 503 169 124 500 500 500 - 0.00% 6,096 1219.20% 135-60246-030-000 General Manager Contingency 17,000 17,000 17,000 17,000 - 0.00% - 0.00% 135-60285-030-000 Lawn Equipment & Maintenance - - - - - 5,000 5,000 0.00% - 0.00% 135-60360-030-000 Furniture/Equipment < $5000 1,056 212 1,579 2,500 2,500 2,500 - 0.00% 2,027 81.08% 135-65010-030-000 Uniforms 475 747 746 2,050 2,050 2,050 - 0.00% - 0.00% 135-65055-030-000 Hardware IT 2,300 6,802 5,526 26,485 26,485 20,253 (6,232) -23.53% 24,611 92.93% 135-65085-030-000 Office Supplies 5,353 5,331 6,651 6,000 6,000 6,000 - 0.00% 5,383 89.72% 135-65090-030-000 Printer Supplies & Maintenance 754 2,365 - 3,500 - - (3,500) -100.00% - 0.00% 135-65095-030-000 Maintenance Supplies 3,985 4,199 4,849 4,000 7,500 4,000 - 0.00% 4,596 114.89% 135-65105-030-000 Printing 2,593 144 - 2,500 2,500 2,500 - 0.00% - 0.00% 135-69005-030-000 Capital Outlays 129,301 48,355 67,391 195,000 180,000 138,000 (57,000) -29.23% 156,107 80.05% 135-69170-030-000 Copier Lease Installments 3,929 3,231 3,306 4,000 4,000 4,000 - 0.00% 3,027 75.67% !Subtotal Administration 1135-55045-039-000 Legal 1 135-55055-039-000 Auditing 1 135-55060-039-000 Appraisal 1 135-55065-039-000 Tax Admin Fees total Non Depart 118,762 18,809 10,713 2,562 151,171 25,659 10,696 2,968 138,579 26,460 11,057 3,653 135,000 33,800 11,761 4,000 135,000 33,800 11,761 4,000 135,000 33,800 11,925 4,850 185,575 164 850 1,014 0.00% 0.00% 1.39% 21.25% 0.55% 109,011 31,908 11,909 3,756 1ggir 80.75% 94.40%1 101.26%1 93.90%1 0.00%1 Total General Fund Revenues Total General Fund Expenses Net Budget Surplus (Deficit) 8,957,220 10,897,878 7,196,250 7,424,061 1,760,970 3,473,817 9,525,452 8,748,253 777,200 10,645,077 9,964,572 10,227,277 10,638,853 9,915,457 10,222,170 6,224 49,115 5,107 (417,800) (416,683) (1,117) -3.92% -3.92% 9,661,678 8,897,786 763,892 90.76%1 83.63%1 1 FY 2021 Budget Revenues District by Type • Building/Space Rental Revenue • Debt Revenue- Capital Leases, Notes, Escrow Fire Revenue Inter Transfers Revenue • Interest Revenue • MUD Property Taxes Revenue Miscellaneous Revenues Utility Billing Revenue • PID Revenue $132,408 {1.3%) • Reserves and Prior Year Revenue • Revenue of Assets • Sewer • Utility Billing Revenue Water Sewer $3,727,146 (36.4%) FY 2021 Budget Expenses District by Type • Wholesale Water Fort Worth • Personnel Costs • Overhead Cost • Bond Related Cost • Capital Expenses Maintenance & Equipment Cost • Contribution to Reserves • Capital Lease Related Cost • Miscellaneous Expense Personnel Costs $2,269,345 (22.2%) Overhead Cost $1,461,634 (14.3%) Wholesale Water Fort Worth $2,596,295 (25.4%) Water $5,940,721 (58.1%) BuildingiSpace Rental Revenue $14,146 (0.1%) Interest Revenue $100,000 (1.0%) MUD Property Taxes Revenue $137,132 (1.3%) Miscellaneous Revenues $7,000 (0.1%) PID Revenue $163,724 (1.6%) Bond Related Cost $1,368,505 (13.4%) Capital Expenses $1,263,000 (12.4%) Maintenance & Equipment Cost $782,150 (7.7%) Contribution to Reserves $355,000 (3.5%) Capital Lease Related Cost $123,091 (1.2%) Miscellaneous Expense $3,150 (0.0%) FY 2021 Budget Expenses by Department All Departments ■ Water Wastewater • Administration Non Deparmental • Board of Directors Water $5,327,165 (52.1%) FY 2021 Budget Expenses by Department Water • Wholesale Water Fort Worth Capital Expenses ■ Bond Related Cost Personnel Costs • Maintenance & Equipment Cost • Overhead Cost • Contribution to Reserves • Capital Lease Related Cost ■ Miscellaneous Expense Capital Expenses $760,000 (14.3%) Wholesale Water Fort worth $2,596,295 (48.7%) Wastewater $3,026,690 (29.6%) Bond Related Cost $565,820 (10.6%) 4IP Administration $1,669,510 (16.3%) Non Deparmental $185,575 (1.8%) Board of Directors $13,230 (0.1%) Personnel Costs $580,552 (10.9%) Maintenance & Equipment Cost $416,450 (7.8%) Overhead Cost $224,562 (4.2%) Contribution to Reserves $150,000 (2.8%) Capital Lease Related Cost $33,286 (0.6%) Miscellaneous Expense $200 (0.0%) FY 2021 Budget Expenses by Department Wastewater • Bond Related Cost Personnel Costs • Capital Expenses Overhead Cost • Contribution to Reserves • Maintenance & Equipment Cost • Capital Lease Related Cost • Miscellaneous Expense Personnel Costs $784,240 (25.9%) Capital Expenses $365,000 (12.1%) Bond Related Cost $802,685 (26.5%) FY 2021 Budget Expenses by Department Board of Directors • Overhead Cost • Personnel Costs 1 Miscellaneous Expense Overhead Cost $7,200 (54.4%) Overhead Cost $468,810 (15.5%) Contribution to Reserves $205,000 (6.8%) Maintenance & Equipment Cost $310,700 (10.3%) Capital Lease Related Cost $89,805 (3.0%) Miscellaneous Expense $450 (0.0%) Personnel Costs $4,030 (30.5%) Miscellaneous Expense $2,000 (15.1%) FY 2021 Budget Expenses by Department Administration • Personnel Costs • Overhead Cost • Capital Expenses • Maintenance & Equipment Cost • Miscellaneous Expense Personnel Costs $900,523 (53.9%) FY 2021 Budget Expenses by Department Non -Departmental Legal • Auditing Appraisal • TaxAdmin Fees Legal $135,000 (72.7%) Overhead Cost $575,487 (34.5%) Capital Expenses $138,000 (8.3%) Maintenance & Equipment Cost $55,000 (3.3%) Miscellaneous Expense $500 (0.0%u) 4 Auditing $33,800 (18.2%) Appraisal $11,925 (6.4%) TaxAdmin Fees $4,850 (2.6%) $2,000,000 $2,355,000 $1,905,000 LONG TERM TAX DEBT Series 2010 (Tax) Series 2012 (Tax) Series 2013 (Tax) Series 2020 (Tax) Series 2014 (Tax) SUBTOTAL MUD -ONLY TAX BONDS: SUBTOTAL ALL MUD/PID TAX BONDS: TOTAL ALL TAX BONDS: LONG TERM REVENUE DEBT Series 2015 (Revenue) WWTP Series 2016 (Revenue) SWIFT Series 2019 (Revenue) Water & Waste Water Systems TAX DEBT PAYMENTS MUD/PID Paid Par Principal FY21 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason MUD MUD MUD MUD MUD/PID $1,220,000 $7,480,000 $5,765,000 S5.765.000 $13,245,000 $95,000 $230,000 $205,000 $15,000 $545,000 $265,000 $265,000 $810,000 $1,663 $10,800 $9,988 $7,930 $30,380 $64,656 $64,656 $95,036 $1,663 $10,800 $9,988 $7,930 $30,380 $64,656 564.656 $95,036 $3,325 $21,600 $19,975 $15,860 $60,760 $129,313 $129,313 5190,073 $750 $500 $500 $750 $2,500 $400 $400 $2,900 $99,075 $252,100 $225,475 $31,610 $608,260 $394,713 5394.713 51,002,973 9/1/2021 9/1/2023 9/1/2023 9/1/2031 9/1/2034 N/A 9/1/2020 9/1/2023 9/1/2031 9/1/2024 Trophy Club Fire Station and costs related to the issuance of the Bonds. Refund 2020 Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Bonds. Refund MUD #2 Unlimited Tax Bonds Series 2003 and MUD #2 Unlimited Tax Refunding Bonds Series 2005 and costs related to the issuance of the Bonds. Refund MUD #1 Unlimited Tax Bonds Series 2010 and costs related to the issuance of the Bonds, Trophy Club Fire Station and costs related to the issuance of the Bonds. Tax Bonds for Wastewater Plant Expansion Issued 10/1/2014 REVENUE DEBT PAYMENTS MUD/PID Paid Par Principal FY 21 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason $9,230,000 $400,000 $100,219 $100,219 $200,438 $400 $600,838 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion $4,635,000 $215,000 $29,300 $29,299 $58,599 $400 $273,999 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Revenue Bonds for 16in Water Line (77%) and $7,080,000 $155,000 $111,794 $111,794 $223,588 $400 $378,988 9/1/2049 9/1/2028 Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: SHORT TERM REVENUE DEBT Vaccon Truck (Water usage 43%) Vaccon Truck (WW usage 57%) Camera Van 520,945,000 $770,000 5241,312 5241,312 $482,624 $1,200 51,253,824 CAPITAL LEASE PAYMENTS MUD/PID Paid Original PAR Principal FY 21 Interest 2/01 Interest 8/01 Subtotal Interest $154,843 $30,962 $1,390 $934 $2,324 $205,257 $41,043 $1,843 $1,238 $3,081 $205,504 $40,230 $2,922 $2,529 $5,451 Total: $565,604 $112,235 $6,156 $4,700 510,856 Total Payoff Date Project/Reason Department $33,286 2/1/2023 Replacement Water $44,123 2/1/2023 Replacement Wastewater $45,681 2/1/2024 Replacement Wastewater 5123,091 $2,500,000.00 $2,000,000.00 $1,500,000.00 - $1,000,000.00 - $500,000.00 - $- Annual Long -Term Debt Payments 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 M1 W&S Rev SERIES 2019 ($7,080,000) ■ M1 W&S Rev SERIES 2016 ($4,635,000) ■ M1 W&SS Rev SERIES 2015 ($9,230,000) ■ M1 Go Series 2020 ($1,220,000) ■ M1 UT SERIES 2014 ($5,765,000) ■ M1 UTR SERIES 2013 ($1,910,000) ■ M1 GO SERIES 2012 ($2,355,000) ■ M1 GO SERIES 2010 ($2,000,000) 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $- Annual Capital Lease Payments L. 2021 2022 ■ LADDER TRUCK LEASE 2015 ($1,057,316) 2023 2024 ■ VAC TRUCK LEASE 2018 ($360,100.40) ■ CAMERA VAN LEASE 2019 ($210,000) CAPITAL OUTLAYS Category FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Notes Water Water System Improvements Valve Replacement/Addition $ 50,000 $ 52,500 $ 55,125 $ 57,881 $ 60,775 Yearly Change Out Engineer Master Plan of Improvements $ 100,000 $ - $ - $ - $ - Engineer Master Plan of Improvements Water Line Replacement $ 500,000 $ 525,000 $ 551,250 $ 578,813 $ 607,753 Water Line Replacement RRA/ERP $ 75,000 $ - $ - $ - $ - Risk Resilience Assessment Totals $ 725,000 $ 577,500 $ 606,375 $ 636,694 $ 668,528 Parking and Driveway Repair Town/MUD Joint $ 280,000 $ 250,000 $ 150,000 $ - $ - Building Maintenance $ - $ - $ - $ - $ - Totals $ - $ - $ - $ - $ - Lift Station Fence Change Out Building Maintenance $ 50,000 $ - $ - $ - $ - Replace WWTP Fence Fencing $ 15,000 $ 15,000 $ 15,000 $ - $ - Yearly Upgrades/Improvements Totals $ 15,000 $ 15,000 $ 15,000 $ - $ - Fleet $ - $ - $ - $ - $ - Fleet Replacement $ - $ 35,000 $ 50,000 $ 41,000 $ - Fleet Replacement Totals $ - $ 35,000 $ 50,000 $ 41,000 $ - Contingency For Carryover Totals $ - $ - $ - $ - $ - Water Grand Totals $ 740,000 $ 627,500 $ 671,375 $ 677,694 $ 668,528 WASTEWATER Wastewater System Improvements Aeration Pump for MBR's $ 30,000 $ - $ - $ - $ - Aeration Pump for MBR's Engineer Master Plan of Improvements $ 100,000 $ - $ - $ - $ - Engineer Master Plan of Improvements WWTP Legal $ 150,000 $ - $ - $ - $ - WWTP Legal Building & Property Maintenance LS #1 Upgrades $ - $ 250,000 $ 150,000 $ - $ - Parking and Driveway Repair Totals $ 280,000 $ 250,000 $ 150,000 $ - $ - Building Maintenance $ 20,000 $ 20,000 $ 20,000 $ - $ - Lift Station Fencing $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 Lift Station Fence Change Out WWTP Fencing Replacement $ 50,000 $ - $ - $ - $ - Replace WWTP Fence Totals $ 33,000 $ - $ - $ - $ - Totals $ 55,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 Fleet $ - $ - $ - $ - $ - Fleet Truck Replacement $ - $ - $ 35,000 $ 35,000 $ - Fleet Truck Replacement Totals $ - $ - $ 35,000 $ 35,000 $ - Contingency For Carryover Totals $ - $ - $ - $ - $ - Wastewater Grand Totals $ 335,000 $ 255,000 $ 190,000 $ 40,000 $ 5,000 ADMIN Information Technology Improvements CM MS $ 50,000 $ - $ - $ - $ - Implementation and Integration Website Rebuild $ 35,000 $ - $ - $ - $ - Rebuild of Current District Website Totals $ 85,000 $ - $ - $ - $ - Building & Property Maintenance Pavement and Driveway Repair $ 20,000 $ 20,000 $ 20,000 $ - $ - Parking and Driveway Repair $ - $ - $ - $ - $ - Totals $ 20,000 $ 20,000 $ 20,000 $ - $ - Fleet Fleet Replacement $ 33,000 $ - $ - $ - $ - Fleet Replacement Totals $ 33,000 $ - $ - $ - $ - Contingency For Carryover Totals $ - $ - $ - $ - $ - Admin Grand Totals $ 138,000 $ 20,000 $ 20,000 $ - $ - AVG METERS AS OF COMPLETED LAST THREE FISCAL YEARS PROJECTED FORT WORTH WATER COST AVG WATER USE OF COMPLETED LAST THREE FISCAL YEARS ANNUALIZE GROWTH IN WATER METERS = 0.50% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2020 = ITEM NO. 4705 70,837,667 1 4705 62,868,333 2 4710 44,040,667 3 4709 37,298,000 4 4713 39,078,000 5 4726 48,848,000 6 4729 59,744,000 7 4748 71,119,667 8 4779 99,610,333 9 4759 109,536,667 10 4763 123,901,667 11 4753 98,590,333 12 AVERAGE TOTAL MONTH OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP PROJECTED EOM AND AVERAGE ANNUAL NO. OF WATER METERS 4,827 4,829 4,831 4,833 4,835 4,837 4,839 4,841 4,843 4,845 4,847 4,849 4,825 AVERAGE WATER USE PER METER FOR THE LAST 3 COMPLETE FISCAL YEARS (GALLONS) 15,056 13,362 9,350 7,920 8,292 10,336 12,633 14,978 20,845 23,015 26,015 20,743 PROJECTED MONTHY WATER USE (GALLONS) 72,674,634 64,525,514 45,172,388 38,277,812 40,092,904 49,996,073 61,130,524 72,509,211 100,953,932 111,511,562 126,099,795 100,585,379 4,838 15,212 883,529,729 CALCULATED AVERAGE WATER USE PER METER PER MONTH = PROJECTED TOTAL NO. OF NEW RETAIL METERS = PROJECTED TOTAL OF ADDITIONAL GALLONS = (GALS/METER/MN) (METERS) (GALLONS) Purchased Water Expense (Projected Fort Worth Costs) 1 Purchased Water (gallons): Out of District Volumetric Charge Per 1000 Gallons $2.33 Rate of Use Charge Monthly $34,710.00 Increase Monthly Rate of Use Charge- Projected True Up $10,000.00 Service Charge Monthly $25 Total: 15,212 24 365,090 883,894,819 $2,059,475 $416,520 $120,000 $300 $2,596,295 Water Use History and Projections Gallons in Thousands 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 Consumption in gallons 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Years Number of Connections per Year 60000 55000 50000 45000 40000 35000 30000 25000 20000 15000 10000 5000 0 Total Connections by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Years Revenue in Thousands $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $- Revenue by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Years Consumtipon per Connection 21,000 19,500 18,000 16,500 15,000 13,500 12,000 10,500 9,000 7,500 6,000 4,500 3,000 1,500 Consumption per Connection by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Years Rates PROJECTED WASTEWATER REVENUE Minimum Charge All Meter Sizes Volumetric Charge (000's) 0-4,000 4,001-8,000 8,001-12,000 12,000+ Commercial Billing Determinants Annual # of Meters Volumes (000's) 0 -4,000 gallons 4,001 - 8,000 gallons 8,001 - 12,000 gallons > 12,001 gallons Commercial (000's) Projected Revenue Meter Charge Revenue Residential 0 -4,000 gallons 4,001 - 8,000 gallons 8,001 - 12,000 gallons > 12,001 gallons Subtotal Commercial Total Revenue Residential (Winter Average) Commercial $22.15 $22.15 $4.10 $5.85 $8.25 $11.75 Total $6.94 54,348 1,176 55,524 185,267 185,267 80,515 80,515 27,235 27,235 29,166 29,166 322,183 322,183 93,558 93,558 $1,203,808 $26,048 $1,229,857 $759,595 $759,595 $471,013 $471,013 $224,689 $224,689 $342,701 $342,701 $1,797,997 $0 $1,797,997 $649,293 $649,293 $3,001,805 $675,341 $3,677,146 Account 135-55160-030 Professional Outside Services 135-55030-030 Software & Support INFORMATION TECHNOLOGY Description 1 1 Amount Description M3- It & Cell Phone Support, includes Mobile Client $ 59,925 Totals: $ 59,925 Description Used R For Recurring, NR For Non -Recurring. R -Internet Connectivity- Charter Spectrum $ 12,000 R -Internet Connectivity -ATT (Backup & WWTP) $ 2,000 R -Internet Connectivity -Pump Room at Water Plant/SCADA $ 1,000 R- M3- Microft Office 365 Licenses $ 6,200 R-STW-Annual Support, Annual Lease, & Report Coding $ 29,000 R -Clear Rec Annual Maintenance $ 600 R- Peak Agenda Management $ 3,638 R -Web Hosting $ 500 R -Web Maintenance (Domains, SSL Cert, etc) $ 116 R -Mail Chimp $ 240 R -Photoshop $ 120 R- Adobe Licenses/Support $ 600 R- Timeclock Plus License and Support $ 1,500 R- MCCI Annual Support Online Records $ 5,200 R -Annual Support for Website -Four Man Furnace $ 2,000 R -Automatic Meter Reading -Badger $ 2,500 R-Pipelogix Maintenance $ 1,980 R-AudioTel Remit Plus Annual Support $ 1,975 R-AudioTel Annual Scanner Support $ 585 R-SCADA Support (Includes Win -911) $ 1,000 R- Onsolve Intermediate Holding (Code Red) $ 4,000 R- Budget Software $ 30,100 R- Element Annual CMMS License Fee $ 10,000 R- Halff GIS/CMMS Hosting and Annual Software Support $ 10,000 NR- VMWare Software & Support (3 yrs support) $ - Totals: $ 126,854 135-60005-030 Description Telephone R- 8x8 Phone System Admin, Water, & Wastewater $ 5,500 R- Afterhours answering service $ 3,000 R- WWTP Phone Service (LS + 4 temp ofc phones) $ - R -E -Fax $ 180 Phone System Maintenance/Replacement $ 1,000 Totals: $ 9,680 135-60235-030 Description Security R- Monitoring Service $ 288 R -Access Control System (Cards, Fobs, Print Supplies) $ 1,000 Totals: $ 1,288 135-65055-030 Description Qty Per Item Amount Hardware R-A/V Miscellaneous Equipment 0 $ - $ - WIFI (MUD & Public) 0 $ - $ - Replacement Hardware: Dell Laptop 2 $ 1,869 $ 3,738 Dell Docking Station 1 $ 179 $ 179 Dell 22" Monitor 4 $ 200 $ 800 Dell Monitor Stand 2 $ 189 $ 378 Dell Desktop 2 $ 1,000 $ 2,000 Keyboard/Mouse combo 2 $ 79 $ 158 Network SAN ( Warranty Renewal) 0 $ 6,500 $ - Server Rotation 1 $ 13,000 $ 13,000 Printers 0 $ - $ - Totals: $ 20,253 135-65105030 Description Printing Events or Special Mailers $ 2,500 Totals: $ 2,500 135-65090-030 Printer Supplies Description Toner and Cartridges $ Totals: 135-69170-030 Copier Rental/Lease Description Copier Lease $ 4,000 Totals: $ 4,000 Grand Total: $ 224,500