Loading...
HomeMy WebLinkAbout2023-03 March Combined FinancialsAdopted Budget vs YTD Actuals Revenues & Expenses 34,846,354 $5,650,877 $11,733,354 MIW $11,733,354 FY 2023 Combined Financials YTD as of 3/31/2023 YTD Revenues • YTD Expenses $1,494 $43,704 0% $843,652 15% $1,936,248 34% 1 1% $2,825,779 50% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 88,979,203 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 101,683,000 41,702,881 49,007,000 52,466,000 49,082,000 46,119,000 34,501,000 41,572,3? Budget Consumption 36,351,669 34,390,563 33,792,116 —1—Actual Consumption Oct Nov Dec Jan Feb Mar 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 864,257,362 808,128,121 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 Water Revenue Budget vs Actual 5703,717 Budget Revenue —Ai—Actual Revenue Oct Nov Dec Jan Feb Mar $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 30 Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 $6,851,560 $4,070,848 Total Water Revenue $4,284,543 ■ Budgeted Water Revenue ■ Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses ■ Net Projected Water Revenue Minus Projected Expenses Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund CURRENT MONTH YEAR TO DATE ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE Budget Variance Report As Of: 03/31/2023 ANNUAL BUDGET TOTAL REMAINING % REVENUE SUMMARY Revenue, Asset, Liability, & Equity 769,363.05 977,388.37 (208,025.32) 4,846,354.45 5,864,330.22 (1,017,975.77) 41 11,733,354.00 (6,886,999.55) 59 TOTAL REVENUE 769,363.05 977,388.37 (208,025.32) 4,846,354.45 5,864,330.22 (1,017,975.77) 41 11,733,354.00 (6,886,999.55) 59 EXPENSE SUMMARY Revenue, Asset, Liability, & Equity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 637,427.05 547,941.66 (89,485.39) 2,825,779.49 3,287,649.96 461,870.47 43 6,577,932.00 (3,752,152.51) 57 Wastewater 268,694.75 290,877.74 22,182.99 1,936,247.62 1,745,266.44 (190,981.18) 55 3,491,931.00 (1,555,683.38) 45 Board of Directors 115.61 980.01 864.40 1,493.66 5,880.06 4,386.40 13 11,765.00 (10,271.34) 87 Administration 141,354.06 127,864.23 (13,489.83) 843,652.32 767,185.38 (76,466.94) 55 1,534,986.00 (691,333.68) 45 Non Deparmental 2,988.63 9,724.44 6,735.81 43,703.62 58,346.64 14,643.02 37 116,740.00 (73,036.38) 63 TOTAL EXPENSE 1,050,580.10 977,388.08 (73,192.02) 5,650,876.71 5,864,328.48 213,451.77 48 11,733,354.00 6,082,477.29 52 REVENUE OVER/(UNDER) EXPENDITURE (281,217.05) 0.29 (281,217.34) (804,522.26) 1.74 (804,524.00) 0.00 (12,969,476.84) 4/13/2023 9:58:06 AM Page 1 of 1 Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund Revenue Department: 000 - Revenue, 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49900-000 Total Departme Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Miscellaneous Income nt: 000 - Revenue, Asset, Liability, & Equity: Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Total Revenue: March Budget 7,326.73 24.99 24.99 12,080.91 559,024.55 319,845.84 6,497.40 466.48 24.99 8.33 4,998.00 1,666.00 1,178.36 2,082.50 47,722.57 13,661.20 171.43 583.10 March Activity 2,556.11 23.38 186.45 0.00 404,421.09 306,256.68 15,792.56 125.00 0.00 0.00 32.00 35,969.78 4,000.00 0.00 0.00 0.00 ▪ 0.00 0.00 Variance Favorable Percent (Unfavorable) Remaining -4,770.62 -1.61 161.46 -12,080.91 -154,603.46 -13,589.16 9,295.16 -341.48 -24.99 -8.33 -4,966.00 34,303.78 2,821.64 -2,082.50 -47,722.57 -13,661.20 -171.43 -583.10 -65.11% -6.44% 646.10% -100.00% -27.66% -4.25% 143.06% -73.20% -100.00% -100.00% -99.36% 2,059.05% 239.45% -100.00% -100.00% -100.00% -100.00% -100.00% YTD Budget 43,960.38 149.94 149.94 72,485.46 3,354,147.30 1,919,075.04 38,984.40 2,798.88 149.94 49.98 29,988.00 9,996.00 7,070.16 12,495.00 286,335.42 81,967.20 1,028.58 3,498.60 Monthly Budget Report Account Summary For Fiscal: Current Period Ending: 03/31/2023 YTD Activity 84,068.49 890.72 580.88 0.00 2,708,173.70 1,814,327.10 21, 716.02 700.00 0.00 0.00 11,875.20 179,435.83 21,178.81 391.30 0.00 0.00 0.00 3,016.40 Variance Favorable Percent (Unfavorable) Remaining 40,108.11 740.78 430.94 -72,485.46 -645,973.60 -104,747.94 -17,268.38 -2,098.88 -149.94 -49.98 -18,112.80 169,439.83 14,108.65 -12,103.70 -286,335.42 -81,967.20 -1,028.58 -482.20 91.24% 494.05% 287.41% -100.00% -19.26% -5.46% -44.30% -74.99% -100.00% -100.00% -60.40% 1,695.08% 199.55% -96.87% -100.00% -100.00% -100.00% -13.78% Total Budget 87,956.00 300.00 300.00 145,029.00 6,710,979.00 3,839,686.00 78,000.00 5,600.00 300.00 100.00 60,000.00 20,000.00 14,146.00 25,000.00 572,900.00 164,000.00 2,058.00 7,000.00 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 33,914.67 45,788.32 -11,873.65 -35.01% 203,488.02 203,574.84 1,416.10 1,897.86 -481.76 -34.02% 8,496.60 7,678.06 498.38 0.00 498.38 100.00% 2,990.28 0.00 299.88 0.00 299.88 100.00% 1,799.28 0.00 4,264.96 5,722.37 -1,457.41 -34.17% 25,589.76 25,403.99 6,890.74 7,282.28 -391.54 -5.68% 41,344.44 39,152.38 406.17 305.56 100.61 24.77% 2,437.02 1,934.80 62.05 63.04 -0.99 -1.60% 372.30 332.78 199.92 404.71 -204.79 -102.44% 1,199.52 2,337.01 2,240.02 2,913.36 -673.34 -30.06% 13,440.12 12,867.26 4/13/2023 9:58:57 AM ▪ -86.82 818.54 2,990.28 1,799.28 185.77 2,192.06 502.22 39.52 -1,137.49 572.86 -0.04% 9.63% 100.00% 100.00% 0.73% 5.30% 20.61% 10.62% -94.83% 4.26% 407,139.00 17,000.00 5,983.00 3,600.00 51, 200.00 82,722.00 4,876.00 745.00 2,400.00 26,891.00 Page 1 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 Variance Variance March March Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-010-50035-000 Medicare Taxes 523.87 681.34 -157.47 -30.06% 3,143.22 2,809.26 333.96 10.62% 6,289.00 135-010-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 629.70 44.98 584.72 92.86% 1,260.00 135-010-50045-000 Workman's Compensation 937.04 1,109.40 -172.36 -18.39% 5,622.24 6,656.40 -1,034.16 -18.39% 11,249.00 135-010-50060-000 Pre-emp Physicals/Testing 33.32 162.45 -129.13 -387.55% 199.92 312.45 -112.53 -56.29% 400.00 135-010-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 149.94 132.95 16.99 11.33% 300.00 135-010-55080-000 Maintenance & Repairs 19,142.34 8,779.15 10,363.19 54.14% 114,854.04 57,508.28 57,345.76 49.93% 229,800.00 135-010-55085-000 Generator Maint. and Repair 166.60 0.00 166.60 100.00% 999.60 875.96 123.64 12.37% 2,000.00 135-010-55090-000 Vehicle Maintenance 416.50 1,544.97 -1,128.47 -270.94% 2,499.00 3,221.34 -722.34 -28.91% 5,000.00 135-010-55105-000 Maintenance-Backhoe/SkidLoader 83.30 0.00 83.30 100.00% 499.80 0.00 499.80 100.00% 1,000.00 135-010-55120-000 Cleaning Services 208.25 161.23 47.02 22.58% 1,249.50 1,128.60 120.90 9.68% 2,500.00 135-010-55135-000 Lab Analysis 624.75 260.00 364.75 58.38% 3,748.50 2,217.84 1,530.66 40.83% 7,500.00 135-010-55135-001 Lab Analysis for PID 166.60 293.92 -127.32 -76.42% 999.60 693.92 305.68 30.58% 2,000.00 135-010-60010-000 Communications/Mobiles 624.75 960.18 -335.43 -53.69% 3,748.50 3,262.82 485.68 12.96% 7,500.00 135-010-60020-000 Electricity 19,013.22 10,441.80 8,571.42 45.08% 114,079.32 72,483.36 41,595.96 36.46% 228,250.00 135-010-60066-000 Publications/Books/Subscripts 83.30 0.00 83.30 100.00% 499.80 0.00 499.80 100.00% 1,000.00 135-010-60080-000 Schools & Training 302.37 243.64 58.73 19.42% 1,814.22 1,375.52 438.70 24.18% 3,630.00 135-010-60100-000 Travel & per diem 78.13 0.00 78.13 100.00% 468.78 44.79 423.99 90.45% 938.00 135-010-60135-000 TCEQ Fees & Permits 2,499.00 0.00 2,499.00 100.00% 14,994.00 20,280.63 -5,286.63 -35.26% 30,000.00 135-010-60135-001 TCEQ Fees & Permits for PID 0.00 0.00 0.00 0.00% 0.00 213.92 -213.92 0.00% 0.00 135-010-60150-000 Wholesale Water 219,922.99 263,311.93 -43,388.94 -19.73% 1,319,537.94 798,163.91 521,374.03 39.51% 2,640,132.00 135-010-60285-000 Lawn Equipment & Maintenance 1,041.25 600.00 441.25 42.38% 6,247.50 1,200.00 5,047.50 80.79% 12,500.00 135-010-60332-000 Interfund Transfer Out -Rev l&S 47,296.24 51,616.66 -4,320.42 -9.13% 283,777.44 309,699.96 -25,922.52 -9.13% 567,782.00 135-010-60360-000 Furniture/Equipment < $5000 208.25 0.00 208.25 100.00% 1,249.50 0.00 1,249.50 100.00% 2,500.00 135-010-65005-000 Fuel & Lube 1,249.50 1,217.30 32.20 2.58% 7,497.00 8,413.72 -916.72 -12.23% 15,000.00 135-010-65010-000 Uniforms 362.77 171.98 190.79 52.59% 2,176.62 2,205.56 -28.94 -1.33% 4,355.00 135-010-65030-000 Chemicals 2,082.50 6,334.48 -4,251.98 -204.18% 12,495.00 24,181.87 -11,686.87 -93.53% 25,000.00 135-010-65050-000 Meter Expense 1,666.00 0.00 1,666.00 100.00% 9,996.00 0.00 9,996.00 100.00% 20,000.00 135-010-65053-000 Meter Change Out Program 7,247.10 0.00 7,247.10 100.00% 43,482.60 0.00 43,482.60 100.00% 87,000.00 135-010-69005-000 Capital Outlays 145,941.60 225,159.12 -79,217.52 -54.28% 875,649.60 909,515.37 -33,865.77 -3.87% 1,752,000.00 135-010-69008-000 Short Term Debt -Principal 2,655.77 0.00 2,655.77 100.00% 15,934.62 31,882.11 -15,947.49 -100.08% 31,882.00 135-010-69009-000 Short Term Debt -Interest 39.15 0.00 39.15 100.00% 234.90 470.26 -235.36 -100.20% 470.00 135-010-69195-000 GASB Reserve for Replacement 13,547.82 0.00 13,547.82 100.00% 81,286.92 162,639.00 -81,352.08 -100.08% 162,639.00 135-010-69281-000 Water Tank Inspection Contract 9,454.55 0.00 9,454.55 100.00% 56,727.30 110,863.59 -54,136.29 -95.43% 113,500.00 Total Department: 010 - Water: 547,941.66 637,427.05 -89,485.39 -16.33% 3,287,649.96 2,825,779.49 461,870.47 14.05% 6,577,932.00 Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 25,794.26 28,874.36 -3,080.10 -11.94% 154,765.56 168,474.29 -13,708.73 -8.86% 309,655.00 135-020-50010-000 Overtime 2,748.90 2,038.40 710.50 25.85% 16,493.40 8,783.95 7,709.45 46.74% 33,000.00 135-020-50016-000 Longevity 336.11 0.00 336.11 100.00% 2,016.66 0.00 2,016.66 100.00% 4,035.00 135-020-50017-000 Certification 524.79 0.00 524.79 100.00% 3,148.74 0.00 3,148.74 100.00% 6,300.00 135-020-50020-000 Retirement 3,471.19 3,709.54 -238.35 -6.87% 20,827.14 21,324.78 -497.64 -2.39% 41,671.00 135-020-50026-000 Medical lnsurance 8,045.03 4,539.40 3,505.63 43.58% 48,270.18 34,636.01 13,634.17 28.25% 96,579.00 135-020-50027-000 Dental lnsurance 452.06 167.64 284.42 62.92% 2,712.36 1,575.64 1,136.72 41.91% 5,427.00 4/13/2023 9:58:57 AM Page 2 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 Variance Variance March March Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-020-50028-000 Vision Insurance 66.05 42.78 23.27 35.23% 396.30 291.14 105.16 26.54% 793.00 135-020-50029-000 Life Insurance & Other 199.92 236.32 -36.40 -18.21% 1,199.52 1,984.73 -785.21 -65.46% 2,400.00 135-020-50030-000 Social Security Taxes 1,823.02 1,868.64 -45.62 -2.50% 10,938.12 10,812.34 125.78 1.15% 21,885.00 135-020-50035-000 Medicare Taxes 426.32 437.00 -10.68 -2.51% 2,557.92 2,528.67 29.25 1.14% 5,118.00 135-020-50040-000 Unemployment Taxes 104.95 0.00 104.95 100.00% 629.70 43.66 586.04 93.07% 1,260.00 135-020-50045-000 Workman's Compensation 748.61 886.28 -137.67 -18.39% 4,491.66 5,317.68 -826.02 -18.39% 8,987.00 135-020-50060-000 Pre-emp Physicals/Testing 33.32 0.00 33.32 100.00% 199.92 150.00 49.92 24.97% 400.00 135-020-50070-000 Employee Relations 24.99 0.00 24.99 100.00% 149.94 663.09 -513.15 -342.24% 300.00 135-020-55080-000 Maintenance & Repairs 11,212.18 6,228.48 4,983.70 44.45% 67,273.08 101,636.79 -34,363.71 -51.08% 134,600.00 135-020-55081-000 Mainten & Repairs Collections 23,407.30 7,107.12 16,300.18 69.64% 140,443.80 107,585.45 32,858.35 23.40% 281,000.00 135-020-55085-000 Generator Maint. and Repair 749.70 0.00 749.70 100.00% 4,498.20 2,836.29 1,661.91 36.95% 9,000.00 135-020-55090-000 Vehicle Maintenance 383.18 0.00 383.18 100.00% 2,299.08 491.81 1,807.27 78.61% 4,600.00 135-020-55091-000 Veh Maintenance Collections 1,082.90 870.46 212.44 19.62% 6,497.40 4,666.02 1,831.38 28.19% 13,000.00 135-020-55105-000 Maintenance-Backhoe/SkidLoader 249.90 0.00 249.90 100.00% 1,499.40 1,408.94 90.46 6.03% 3,000.00 135-020-55120-000 Cleaning Services 166.60 161.22 5.38 3.23% 999.60 1,128.55 -128.95 -12.90% 2,000.00 135-020-55125-000 Dumpster Services 8,330.00 8,516.34 -186.34 -2.24% 49,980.00 40,704.23 9,275.77 18.56% 100,000.00 135-020-55135-000 Lab Analysis 3,332.00 3,471.60 -139.60 -4.19% 19,992.00 22,378.17 -2,386.17 -11.94% 40,000.00 135-020-60010-000 Communications/Mobiles 624.75 754.48 -129.73 -20.77% 3,748.50 2,940.85 807.65 21.55% 7,500.00 135-020-60020-000 Electricity 23,017.28 21,938.42 1,078.86 4.69% 138,103.68 111,469.48 26,634.20 19.29% 276,318.00 135-020-60080-000 Schools & Training 302.37 1,165.00 -862.63 -285.29% 1,814.22 1,741.00 73.22 4.04% 3,630.00 135-020-60100-000 Travel & per diem 86.46 0.00 86.46 100.00% 518.76 0.00 518.76 100.00% 1,038.00 135-020-60135-000 TCEQ Fees & Permits 999.60 0.00 999.60 100.00% 5,997.60 9,888.02 -3,890.42 -64.87% 12,000.00 135-020-60285-000 Lawn Equipment & Maintenance 1,332.80 1,010.00 322.80 24.22% 7,996.80 1,720.00 6,276.80 78.49% 16,000.00 135-020-60331-000 Interfund Transfer Out -Tax l&S 9,683.20 10,567.73 -884.53 -9.13% 58,099.20 63,406.38 -5,307.18 -9.13% 116,245.00 135-020-60332-000 Interfund Transfer Out -Rev l&S 57,637.85 62,902.88 -5,265.03 -9.13% 345,827.10 377,417.28 -31,590.18 -9.13% 691,931.00 135-020-60360-000 Furniture/Equipment < $5000 41.65 0.00 41.65 100.00% 249.90 0.00 249.90 100.00% 500.00 135-020-65005-000 Fuel & Lube 1,041.25 648.79 392.46 37.69% 6,247.50 5,725.15 522.35 8.36% 12,500.00 135-020-65010-000 Uniforms 367.76 0.00 367.76 100.00% 2,206.56 2,288.35 -81.79 -3.71% 4,415.00 135-020-65030-000 Chemicals 2,707.25 0.00 2,707.25 100.00% 16,243.50 12,677.47 3,566.03 21.95% 32,500.00 135-020-65031-000 Chemicals Collections 833.00 0.00 833.00 100.00% 4,998.00 6,002.80 -1,004.80 -20.10% 10,000.00 135-020-65045-000 Lab Supplies 2,748.90 2,515.68 233.22 8.48% 16,493.40 18,678.49 -2,185.09 -13.25% 33,000.00 135-020-69005-000 Capital Outlays 74,553.50 98,036.19 -23,482.69 -31.50% 447,321.00 551,336.32 -104,015.32 -23.25% 895,000.00 135-020-69008-000 Short Term Debt -Principal 7,144.30 0.00 7,144.30 100.00% 42,865.80 63,804.49 -20,938.69 -48.85% 85,766.00 135-020-69009-000 Short Term Debt -Interest 233.32 0.00 233.32 100.00% 1,399.92 1,952.31 -552.39 -39.46% 2,801.00 135-020-69195-000 GASB Reserve for Replacement 13,809.22 0.00 13,809.22 100.00% 82,855.32 165,777.00 -82,921.68 -100.08% 165,777.00 Total Department: 020 - Wastewater: 290,877.74 268,694.75 22,182.99 7.63% 1,745,266.44 1,936,247.62 -190,981.18 -10.94% 3,491,931.00 Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 1.24 0.62 0.62 50.00% 7.44 3.72 3.72 50.00% 15.00 135-026-60070-000 Dues & Memberships 62.47 0.00 62.47 100.00% 374.82 750.00 -375.18 -100.10% 750.00 135-026-60075-000 Meetings 124.95 114.99 9.96 7.97% 749.70 689.94 59.76 7.97% 1,500.00 135-026-60080-000 Schools & Training 333.20 0.00 333.20 100.00% 1,999.20 50.00 1,949.20 97.50% 4,000.00 135-026-60100-000 Travel & per diem 416.50 0.00 416.50 100.00% 2,499.00 0.00 2,499.00 100.00% 5,000.00 4/13/2023 9:58:57 AM Page 3 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 Variance Variance March March Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135-026-60245-000 Miscellaneous Expenses 0.00 41.65 100.00% 249.90 100.00% Total Department: 026 - Board of Directors: 980.01 115.61 864.40 88.20% 5,880.06 1,493.66 4,386.40 74.60% 11,765.00 Department: 030 - Administration 135-030-50005-000 Salaries & Wages 51,724.13 71,314.47 -19,590.34 -37.87% 310,344.78 297,616.64 12,728.14 4.10% 620,938.00 135-030-50010-000 Overtime 166.60 13.16 153.44 92.10% 999.60 574.42 425.18 42.54% 2,000.00 135-030-50016-000 Longevity 201.83 0.00 201.83 100.00% 1,210.98 0.00 1,210.98 100.00% 2,423.00 135-030-50020-000 Retirement 6,149.53 8,532.35 -2,382.82 -38.75% 36,897.18 35,785.32 1,111.86 3.01% 73,824.00 135-030-50026-000 Medical Insurance 9,686.95 5,629.38 4,057.57 41.89% 58,121.70 33,754.83 24,366.87 41.92% 116,290.00 135-030-50027-000 Dental Insurance 504.04 206.34 297.70 59.06% 3,024.24 1,545.20 1,479.04 48.91% 6,051.00 135-030-50028-000 Vision Insurance 74.88 46.50 28.38 37.90% 449.28 278.90 170.38 37.92% 899.00 135-030-50029-000 Life Insurance & Other 199.92 534.97 -335.05 -167.59% 1,199.52 2,889.77 -1,690.25 -140.91% 2,400.00 135-030-50030-000 Social Security Taxes 3,229.70 4,297.95 -1,068.25 -33.08% 19,378.20 17,515.19 1,863.01 9.61% 38,772.00 135-030-50035-000 Medicare Taxes 755.36 1,005.16 -249.80 -33.07% 4,532.16 4,162.12 370.04 8.16% 9,068.00 135-030-50040-000 Unemployment Taxes 125.94 4.86 121.08 96.14% 755.64 58.54 697.10 92.25% 1,512.00 135-030-50045-000 Workman's Compensation 124.61 107.60 17.01 13.65% 747.66 645.60 102.06 13.65% 1,496.00 135-030-50060-000 Pre-emp Physicals/Testing 41.65 0.00 41.65 100.00% 249.90 198.45 51.45 20.59% 500.00 135-030-50070-000 Employee Relations 333.20 0.00 333.20 100.00% 1,999.20 2,563.57 -564.37 -28.23% 4,000.00 135-030-55030-000 Software & Support 10,970.61 1,837.89 9,132.72 83.25% 65,823.66 67,088.65 -1,264.99 -1.92% 131,700.00 135-030-55070-000 Independent Labor 1,249.50 1,395.00 -145.50 -11.64% 7,497.00 5,235.69 2,261.31 30.16% 15,000.00 135-030-55080-000 Maintenance & Repairs 3,332.00 1,425.50 1,906.50 57.22% 19,992.00 10,241.19 9,750.81 48.77% 40,000.00 135-030-55085-000 Generator Maint. and Repair 249.90 0.00 249.90 100.00% 1,499.40 0.00 1,499.40 100.00% 3,000.00 135-030-55120-000 Cleaning Services 999.60 967.35 32.25 3.23% 5,997.60 7,069.69 -1,072.09 -17.88% 12,000.00 135-030-55160-000 Professional Outside Services 6,250.83 2,899.25 3,351.58 53.62% 37,504.98 69,676.51 -32,171.53 -85.78% 75,040.00 135-030-55205-000 Utility Billing Contract 749.70 643.15 106.55 14.21% 4,498.20 3,902.93 595.27 13.23% 9,000.00 135-030-60005-000 Telephone 499.80 492.52 7.28 1.46% 2,998.80 2,840.80 158.00 5.27% 6,000.00 135-030-60010-000 Communications/Mobiles 249.90 0.00 249.90 100.00% 1,499.40 0.00 1,499.40 100.00% 3,000.00 135-030-60020-000 Electricity/Gas 2,029.93 1,393.11 636.82 31.37% 12,179.58 9,020.78 3,158.80 25.94% 24,369.00 135-030-60025-000 Water 416.50 399.75 16.75 4.02% 2,499.00 2,341.38 157.62 6.31% 5,000.00 135-030-60035-000 Postage 2,499.00 1,915.08 583.92 23.37% 14,994.00 11,736.31 3,257.69 21.73% 30,000.00 135-030-60040-000 Service Charges & Fees 7,913.50 21,761.86 -13,848.36 -175.00% 47,481.00 60,771.09 -13,290.09 -27.99% 95,000.00 135-030-60050-000 Bad Debt Expense 124.95 0.00 124.95 100.00% 749.70 48.65 701.05 93.51% 1,500.00 135-030-60055-000 Insurance 7,347.06 8,117.81 -770.75 -10.49% 44,082.36 48,706.86 -4,624.50 -10.49% 88,200.00 135-030-60070-000 Dues & Memberships 541.45 0.00 541.45 100.00% 3,248.70 2,289.00 959.70 29.54% 6,500.00 135-030-60079-000 Public Education 3,332.00 1,727.50 1,604.50 48.15% 19,992.00 18,097.48 1,894.52 9.48% 40,000.00 135-030-60080-000 Schools & Training 270.72 0.00 270.72 100.00% 1,624.32 120.00 1,504.32 92.61% 3,250.00 135-030-60100-000 Travel & per diem 132.28 0.00 132.28 100.00% 793.68 0.00 793.68 100.00% 1,588.00 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 0.00 0.00% 0.00 88.00 -88.00 0.00% 0.00 135-030-60285-000 Lawn Equipment & Maintenance 416.50 469.67 -53.17 -12.77% 2,499.00 1,589.72 909.28 36.39% 5,000.00 135-030-60360-000 Furniture/Equipment < $5000 833.00 0.00 833.00 100.00% 4,998.00 13,052.82 -8,054.82 -161.16% 10,000.00 135-030-65010-000 Uniforms 44.14 0.00 44.14 100.00% 264.84 0.00 264.84 100.00% 530.00 135-030-65055-000 Hardware 699.72 2,943.80 -2,244.08 -320.71% 4,198.32 3,447.10 751.22 17.89% 8,400.00 135-030-65085-000 Office Supplies 499.80 53.31 446.49 89.33% 2,998.80 2,757.68 241.12 8.04% 6,000.00 4/13/2023 9:58:57 AM Page 4 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 135-030-65095-000 135-030-69005-000 135-030-69170-000 135-030-69195-000 Maintenance Supplies Capital Outlays Copier Lease Installments GASB Reserve for Replacement Total Department: 030 - Administration: Department: 039 - Non Deparmental 135-039-55045-000 Legal 135-039-55055-000 Auditing 135-039-55060-000 Appraisal 135-039-55065-000 Tax Admin Fees Total Department: 039 - Non Deparmental: Total Expense: Total Revenues Total Fund: 135 - MUD 1 General Fund: Report Total: March Budget March Activity �26 Variance Favorable Percent (Unfavorable) Remaining -375.06 -112.56% YTD Budget 1,999.20 0.00 260.00 -260.00 0.00% 0.00 Q� 69 1,999.20 2,227.10 0.00 2,227.10 100.00% 13,362.60 YTD Activity 3,133.96 74,465.10 1,606.38 26,736.00 Variance Favorable (Unfavorable) -1,134.76 -74,465.10 392.82 -13,373.40 Percent Remaining -56.76% 0.00% 19671 -100.08% Total Budget 4,000.00 0.00 4,000.00 26,736.00 127,864.23 5,414.50 2,815.54 1,077.90 416.50 141,354.06 825.00 0.00 2,163.63 0.00 -13,489.83 -10.55% 9,724.44 2,988.63 4,589.50 2,815.54 -1,085.73 416.50 84.76% 100.00% -100.73% 100.00% 767,185.38 32,487.00 16,893.24 6,467.40 2,499.00 843,652.32 10,170.00 22,551.10 6,936.52 4,046.00 -76,466.94 -9.97% 1,534,986.00 22,317.00 -5,657.86 -469.12 -1,547.00 68.70% -33.49% -7.25% -61.90% 65,000.00 33,800.00 12,940.00 5,000.00 6,735.81 69.27% 58,346.64 43,703.62 14,643.02 25.10% 116,740.00 977,388.08 1,050,580.10 -73,192.02 -7.49% 5,864,328.48 5,650,876.71 213,451.77 3.64% 11,733,354.00 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 4/13/2023 9:58:57 AM Page 5 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 Group Summary Departmen... Fund: 135 - MUD 1 General Fund Revenue 000 - Revenue, Asset, Liability, & Equity Expense 010 - Water 020 - Wastewater 026 - Board of Directors 030 - Administration 039 - Non Deparmental Total Revenue: Variance Variance March March Favorable Percent YTD YTD Favorable Percent Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 547,941.66 637,427.05 -89,485.39 -16.33% 3,287,649.96 2,825,779.49 461,870.47 14.05% 6,577,932.00 290,877.74 268,694.75 22,182.99 7.63% 1,745,266.44 1,936,247.62 -190,981.18 -10.94% 3,491,931.00 980.01 115.61 864.40 88.20% 5,880.06 1,493.66 4,386.40 74.60% 11,765.00 127,864.23 141,354.06 -13,489.83 -10.55% 767,185.38 843,652.32 -76,466.94 -9.97% 1,534,986.00 _ 9,724.44 2,988.63 _ 6,735.81 69.27% 58,346.64 43,703.62 14,643.02 25.10% 116,740.00 Total Expense: 977,388.08 1,050,580.10 -73,192.02 -7.49% 5,864,328.48 5,650,876.71 213,451.77 3.64% 11,733,354.00 Total Revenues 977,388.37 769,363.05 -208,025.32 -21.28% 5,864,330.22 4,846,354.45 -1,017,975.77 -17.36% 11,733,354.00 Total Fund: 135 - MUD 1 General Fund: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 Report Total: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 4/13/2023 9:58:57 AM Page 6 of 7 Monthly Budget Report For Fiscal: Current Period Ending: 03/31/2023 Fund Summary Variance Variance March March Favorable Percent YTD YTD Favorable Percent Fund Budget Activity (Unfavorable) Remaining Budget Activity (Unfavorable) Remaining Total Budget 135 - MUD 1 General Fund 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 Report Total: 0.29 -281,217.05 -281,217.34 1.74 -804,522.26 -804,524.00 0.00 4/13/2023 9:58:57 AM Page 7 of 7 Department Trophy Club Municipal Utility District No. 1 122 - Trophy Club MUD Fire Dept. Asset 000 - Revenue, Asset, Liability, & Equity 1,156,680.67 Liability 000 - Revenue, Asset, Liability, & Equity Equity 000 - Revenue, Asset, Liability, & Equity 135 - MUD 1 General Fund Balance Sheet Funds 122 - 528 Account Summary As Of 03/31/2023 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Consolidated Bond Const -SWIFT Bond 16" Revenue Bond GASB Waterline Reserve Fund 10,418,056.56 3,422,146.58 799,196.16 1,149, 344.83 Total 918,594.28 17,864,019.08 Total Asset: 1,156,680.67 10,418,056.56 3,422,146.58 799,196.16 1,149,344.83 918,594.28 17,864,019.08 22,198.00 775,040.75 0.00 81,691.15 158,280.07 0.00 1,037,209.97 Total Liability: 22,198.00 775,040.75 0.00 81,691.15 158,280.07 0.00 1,037,209.97 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Total Beginning Equity: 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 17,060,147.76 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 1,220,594.78 4,846,354.45 436,572.00 11,974.81 26,436.11 17,989.87 6,559,922.02 767,915.68 5,650,876.71 0.00 0.00 374,468.28 0.00 6,793,260.67 452,679.10 1,134,482.67 1,156,680.67 -804,522.26 9,643,015.81 10,418,056.56 436,572.00 3,422,146.58 3,422,146.58 11,974.81 717,505.01 799,196.16 -348,032.17 991,064.76 1,149,344.83 Monthly Financial Activity Footnotes: Fund 122 Activity • Daily property tax deposits • Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses • March Fire Station transfer OUT to cover GO Bond payment allocation into Fund 533 17,989.87 918,594.28 918,594.28 -233,338.65 16,826,809.11 17,864,019.08 Fund 135 Activity • Daily property tax deposits • All A/P checks are cut through the General Fund • Monthly transfer IN to cover other fund A/P expenses • Monthly transfer OUT for I&S Revenue Bond payments for Fund 534, 535, & 535 • Monthly bank interest Fund 137 Activity • Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity • Monthly bank interest Fund 520 Activity • Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses • Monthly bank interest Fund 528 Activity • Monthly bank interest 4/13/2023 11:24:01 AM Page 1 of 1 TROPHY CLUB WONEMPAL UTILETY 1 r T 1.Frr Department Trophy Club Municipal Utility District No. 1 533- MUD 1I&S 534-2015 Consolidated Revenue Bond I&S Asset 000 - Revenue, Asset, Liability, & Equity 925,372.02 535 - 2016 Rev Bond I&S-SWIFT 268, 700.95 130,497.97 536 - 2019 Rev Bond I&S- W&WW System Balance Sheet I&S Funds 533 - 536 Account Summary As Of 03/31/2023 Total 102,695.56 1,427,266.50 Total Asset: 925,372.02 268, 700.95 130,497.97 102,695.56 1,427,266.50 Liability 000 - Revenue, Asset, Liability, & Equity 51,819.75 0.00 0.00 0.00 51,819.75 Total Liability: 51,819.75 Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 4,145.11 0.00 0.00 27,958.35 6,554.77 0.00 51,819.75 1,429.17 40,087.40 4,145.11 27,958.35 943,985.99 74,578.83 333,061.35 92,318.75 6,554.77 1,429.17 151,712.45 27,769.25 208,535.14 107,268.75 40,087.40 1,637,294.93 301,935.58 869,407.16 873,552.27 925,372.02 240,742.60 268,700.95 268,700.95 123,943.20 130,497.97 130,497.97 101,266.39 102,695.56 102,695.56 1,335,359.35 1,375,446.75 1,427,266.50 Monthly Financial Activity Footnotes: Fund 533 Activity • Daily property tax deposits • Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments • 3/1 & 9/1 GO Bond payments (Interest and Principal) • Monthly bank interest Fund 534 Activity • Monthly transfer IN for semi annual Revenue Bond payment from Fund 533 • 3/1 & 9/1 Revenue Bond payments (Interest and Principal) • Monthly bank interest Fund 535 Activity • Monthly transfer IN for semi annual Revenue Bond payment from Fund 533 • 3/1 & 9/1 Revenue Bond payments (Interest and Principal) • Monthly bank interest Fund 536 Activity • Monthly transfer IN for semi annual Revenue Bond payment from Fund 533 • 3/1 & 9/1 Revenue Bond payments (Interest and Principal) • Monthly bank interest 4/13/2023 11:24:49 AM Page 1 of 1