Loading...
HomeMy WebLinkAboutJuly 2007 Budget Summary glbase_tbam rgonzale Trophy Club Entities Page 49 13:47 08/30/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 07/2007 Account Description Total Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 132-40000-000-000 Property Taxes │ 88,238.00-│ 88,238.00-│ │ 396.46-│ 91,231.14-│ 103.392 │ 2,993.14 132-40010-000-000 Property Taxes/MUD Fire │ 409,261.00-│ 409,261.00-│ │ 1,837.81-│ 404,945.96-│ 98.946 │ 4,315.04- 132-40015-000-000 Property Taxes/P & I │ 1,000.00-│ 1,000.00-│ │ 27.49-│ 827.35-│ 82.735 │ 172.65- 132-40020-000-000 Property Taxes/Fire P&I │ 2,000.00-│ 2,000.00-│ │ 127.36-│ 1,953.77-│ 97.689 │ 46.23- │ │ │ │ │ │ │ Subtotal: │ 500,499.00-│ 500,499.00-│ │ 2,389.12-│ 498,958.22-│ 99.692 │ 1,540.78- │ │ │ │ │ │ │ 132-49005-000-000 Loan Proceeds │ │ │ │ 448,000.00-│ 448,000.00-│ │ 448,000.00 132-49010-000-000 Interest Income │ 19,000.00-│ 19,000.00-│ │ 2,706.49-│ 25,595.33-│ 134.712 │ 6,595.33 132-49900-000-000 Miscellaneous Income │ │ │ │ │ 56,530.50-│ │ 56,530.50 │ │ │ │ │ │ │ Subtotal: │ 19,000.00-│ 19,000.00-│ │ 450,706.49-│ 530,125.83-│ 2,790.136 │ 511,125.83 │ │ │ │ │ │ │ Program number: │ 519,499.00-│ 519,499.00-│ │ 453,095.61-│ 1,029,084.05-│ 198.092 │ 509,585.05 │ │ │ │ │ │ │ Department number: Revenues │ 519,499.00-│ 519,499.00-│ │ 453,095.61-│ 1,029,084.05-│ 198.092 │ 509,585.05 │ │ │ │ │ │ │ Revenues Subtotal ----------│ 519,499.00-│ 519,499.00-│ │ 453,095.61-│ 1,029,084.05-│ 198.092 │ 509,585.05 glbase_tbam rgonzale Trophy Club Entities Page 50 13:47 08/30/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: 50 Operating & Maintenance Program: Period Ending: 07/2007 Account Description Total Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 132-50005-050-000 Salaries & Wages │ 6,000.00 │ 6,000.00 │ │ 700.00 │ 5,800.00 │ 96.667 │ 200.00 132-50030-050-000 Social Security Taxes │ 405.00 │ 405.00 │ │ 43.40 │ 359.60 │ 88.790 │ 45.40 132-50035-050-000 Medicare Taxes │ 87.00 │ 87.00 │ │ 10.15 │ 84.10 │ 96.667 │ 2.90 132-50040-050-000 Unemployment Taxes │ 50.00 │ 50.00 │ │ 3.50 │ 66.50 │ 133.000 │ 16.50- 132-50045-050-000 Workman's Compensation │ 30.00 │ 30.00 │ │ │ 18.88 │ 62.933 │ 11.12 │ │ │ │ │ │ │ Subtotal: │ 6,572.00 │ 6,572.00 │ │ 757.05 │ 6,329.08 │ 96.304 │ 242.92 │ │ │ │ │ │ │ 132-55045-050-000 Legal │ 6,500.00 │ 6,500.00 │ │ 11,643.98 │ 20,808.57 │ 320.132 │ 14,308.57- 132-55055-050-000 Auditing │ 9,000.00 │ 9,000.00 │ │ │ 7,933.00 │ 88.144 │ 1,067.00 132-55065-050-000 Tax Admin Fees │ 12,000.00 │ 12,000.00 │ │ │ 10,310.51 │ 85.921 │ 1,689.49 132-55160-050-000 Professional Outside Services │ │ │ │ │ 15,000.00 │ │ 15,000.00- │ │ │ │ │ │ │ Subtotal: │ 27,500.00 │ 27,500.00 │ │ 11,643.98 │ 54,052.08 │ 196.553 │ 26,552.08- │ │ │ │ │ │ │ 132-60070-050-000 Dues & Memberships │ 600.00 │ 600.00 │ │ │ 585.00 │ 97.500 │ 15.00 132-60080-050-000 Schools & Training │ 1,200.00 │ 1,200.00 │ │ │ 2,440.00 │ 203.333 │ 1,240.00- 132-60100-050-000 Travel & per diem │ 5,500.00 │ 5,500.00 │ │ 550.49 │ 6,353.09 │ 115.511 │ 853.09- 132-60245-050-000 Miscellaneous Expenses │ 150.00 │ 150.00 │ │ │ 3,640.00 │ 2,426.667 │ 3,490.00- 132-60345-050-000 Intergov Trans Out (Fire Dept) │ 409,261.00 │ 409,261.00 │ │ 34,105.09 │ 341,050.90 │ 83.333 │ 68,210.10 │ │ │ │ │ │ │ Subtotal: │ 416,711.00 │ 416,711.00 │ │ 34,655.58 │ 354,068.99 │ 84.968 │ 62,642.01 │ │ │ │ │ │ │ 132-65085-050-000 Office Supplies │ │ │ │ │ 78.19 │ │ 78.19- │ │ │ │ │ │ │ Subtotal: │ │ │ │ │ 78.19 │ │ 78.19- │ │ │ │ │ │ │ 132-69190-050-000 Capital Projects │ │ │ │ 442,782.00 │ 442,782.00 │ │ 442,782.00- 132-69290-050-000 To MUD2 Water Plant Renovation │ 29,379.00 │ 29,379.00 │ │ │ │ │ 29,379.00 │ │ │ │ │ │ │ Subtotal: │ 29,379.00 │ 29,379.00 │ │ 442,782.00 │ 442,782.00 │ 1,507.138 │ 413,403.00- │ │ │ │ │ │ │ 132-70005-050-000 Paying Agent Fees │ │ │ │ 500.00 │ 500.00 │ │ 500.00- │ │ │ │ │ │ │ Subtotal: │ │ │ │ 500.00 │ 500.00 │ │ 500.00- │ │ │ │ │ │ │ Program number: │ 480,162.00 │ 480,162.00 │ │ 490,338.61 │ 857,810.34 │ 178.650 │ 377,648.34- │ │ │ │ │ │ │ Department number: Operating & Maintenance │ 480,162.00 │ 480,162.00 │ │ 490,338.61 │ 857,810.34 │ 178.650 │ 377,648.34- │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 480,162.00 │ 480,162.00 │ │ 490,338.61 │ 857,810.34 │ 178.650 │ 377,648.34- │ │ │ │ │ │ │ Fund number: 132 TROPHY CLUB M.U.D. 1 O & M │ 39,337.00-│ 39,337.00-│ │ 37,243.00 │ 171,273.71-│ 435.401 │ 131,936.71 glbase_tbam rgonzale Trophy Club Entities Page 72 13:47 08/30/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 07/2007 Account Description Total Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 532-40000-000-000 Property Taxes │ 632,005.00-│ 632,005.00-│ │ 2,838.07-│ 629,669.12-│ 99.630 │ 2,335.88- 532-40015-000-000 Property Taxes/P & I │ 3,500.00-│ 3,500.00-│ │ 196.73-│ 2,902.96-│ 82.942 │ 597.04- │ │ │ │ │ │ │ Subtotal: │ 635,505.00-│ 635,505.00-│ │ 3,034.80-│ 632,572.08-│ 99.538 │ 2,932.92- │ │ │ │ │ │ │ 532-49010-000-000 Interest Income │ 18,500.00-│ 18,500.00-│ │ 2,930.29-│ 20,231.57-│ 109.360 │ 1,731.57 │ │ │ │ │ │ │ Subtotal: │ 18,500.00-│ 18,500.00-│ │ 2,930.29-│ 20,231.57-│ 109.360 │ 1,731.57 │ │ │ │ │ │ │ Program number: │ 654,005.00-│ 654,005.00-│ │ 5,965.09-│ 652,803.65-│ 99.816 │ 1,201.35- │ │ │ │ │ │ │ Department number: Revenues │ 654,005.00-│ 654,005.00-│ │ 5,965.09-│ 652,803.65-│ 99.816 │ 1,201.35- │ │ │ │ │ │ │ Revenues Subtotal ----------│ 654,005.00-│ 654,005.00-│ │ 5,965.09-│ 652,803.65-│ 99.816 │ 1,201.35- glbase_tbam rgonzale Trophy Club Entities Page 73 13:47 08/30/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: 51 Interest & Sinking Program: Period Ending: 07/2007 Account Description Total Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 532-70005-051-000 Paying Agent Fee │ 1,560.00 │ 1,560.00 │ │ │ 300.00 │ 19.231 │ 1,260.00 532-70025-051-000 Bond Interest Expense │ 117,445.00 │ 117,445.00 │ │ │ 58,722.50 │ 50.000 │ 58,722.50 532-70035-051-000 Bond Principal Payment │ 535,000.00 │ 535,000.00 │ │ │ │ │ 535,000.00 │ │ │ │ │ │ │ Subtotal: │ 654,005.00 │ 654,005.00 │ │ │ 59,022.50 │ 9.025 │ 594,982.50 │ │ │ │ │ │ │ Program number: │ 654,005.00 │ 654,005.00 │ │ │ 59,022.50 │ 9.025 │ 594,982.50 │ │ │ │ │ │ │ Department number: Interest & Sinking │ 654,005.00 │ 654,005.00 │ │ │ 59,022.50 │ 9.025 │ 594,982.50 │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 654,005.00 │ 654,005.00 │ │ │ 59,022.50 │ 9.025 │ 594,982.50 │ │ │ │ │ │ │ Fund number: 532 TROPHY CLUB M.U.D. 1 I & S │ │ │ │ 5,965.09-│ 593,781.15-│ │ 593,781.15