Loading...
HomeMy WebLinkAboutSeptember 2007 Budget Summary glbase_tbam rgonzale Trophy Club Entities Page 50 19:07 10/23/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 09/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-│ │ 333.84-│ 92,033.78-│ 104.302 │ 3,795.78 132-40010-000-000 Property Taxes/MUD Fire │ 409,261.00-│ 409,261.00-│ │ 1,547.55-│ 408,661.47-│ 99.854 │ 599.53- 132-40015-000-000 Property Taxes/P & I │ 1,000.00-│ 1,000.00-│ │ 66.25-│ 974.75-│ 97.475 │ 25.25- 132-40020-000-000 Property Taxes/Fire P&I │ 2,000.00-│ 2,000.00-│ │ 307.10-│ 2,636.27-│ 131.814 │ 636.27 │ │ │ │ │ │ │ Subtotal: │ 500,499.00-│ 500,499.00-│ │ 2,254.74-│ 504,306.27-│ 100.761 │ 3,807.27 │ │ │ │ │ │ │ 132-49005-000-000 Loan Proceeds │ │ │ │ │ 448,000.00-│ │ 448,000.00 132-49010-000-000 Interest Income │ 19,000.00-│ 19,000.00-│ │ 2,062.46-│ 30,605.40-│ 161.081 │ 11,605.40 132-49900-000-000 Miscellaneous Income │ │ │ │ │ 56,530.50-│ │ 56,530.50 │ │ │ │ │ │ │ Subtotal: │ 19,000.00-│ 19,000.00-│ │ 2,062.46-│ 535,135.90-│ 2,816.505 │ 516,135.90 │ │ │ │ │ │ │ Program number: │ 519,499.00-│ 519,499.00-│ │ 4,317.20-│ 1,039,442.17-│ 200.085 │ 519,943.17 │ │ │ │ │ │ │ Department number: Revenues │ 519,499.00-│ 519,499.00-│ │ 4,317.20-│ 1,039,442.17-│ 200.085 │ 519,943.17 │ │ │ │ │ │ │ Revenues Subtotal ----------│ 519,499.00-│ 519,499.00-│ │ 4,317.20-│ 1,039,442.17-│ 200.085 │ 519,943.17 glbase_tbam rgonzale Trophy Club Entities Page 51 19:07 10/23/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: 50 Operating & Maintenance Program: Period Ending: 09/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 │ │ 3,000.00 │ 9,700.00 │ 161.667 │ 3,700.00- 132-50030-050-000 Social Security Taxes │ 405.00 │ 405.00 │ │ 186.00 │ 601.40 │ 148.494 │ 196.40- 132-50035-050-000 Medicare Taxes │ 87.00 │ 87.00 │ │ 43.50 │ 140.65 │ 161.667 │ 53.65- 132-50040-050-000 Unemployment Taxes │ 50.00 │ 50.00 │ │ 15.00 │ 86.00 │ 172.000 │ 36.00- 132-50045-050-000 Workman's Compensation │ 30.00 │ 30.00 │ │ │ 18.88 │ 62.933 │ 11.12 │ │ │ │ │ │ │ Subtotal: │ 6,572.00 │ 6,572.00 │ │ 3,244.50 │ 10,546.93 │ 160.483 │ 3,974.93- │ │ │ │ │ │ │ 132-55045-050-000 Legal │ 6,500.00 │ 6,500.00 │ │ 12,649.40 │ 37,462.97 │ 576.353 │ 30,962.97- 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 │ │ 3,052.54 │ 13,363.05 │ 111.359 │ 1,363.05- 132-55160-050-000 Professional Outside Services │ │ │ │ │ 15,000.00 │ │ 15,000.00- │ │ │ │ │ │ │ Subtotal: │ 27,500.00 │ 27,500.00 │ │ 15,701.94 │ 73,759.02 │ 268.215 │ 46,259.02- │ │ │ │ │ │ │ 132-60066-050-000 Publications/Books/Subscripts │ │ │ │ │ 20.02 │ │ 20.02- 132-60070-050-000 Dues & Memberships │ 600.00 │ 600.00 │ │ │ 585.00 │ 97.500 │ 15.00 132-60075-050-000 Meetings │ │ │ │ 35.35 │ 35.35 │ │ 35.35- 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 │ │ │ 6,353.09 │ 115.511 │ 853.09- 132-60125-050-000 Advertising │ │ │ │ 396.90 │ 396.90 │ │ 396.90- 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 │ 409,261.08 │ 100.000 │ .08- │ │ │ │ │ │ │ Subtotal: │ 416,711.00 │ 416,711.00 │ │ 34,537.34 │ 422,731.44 │ 101.445 │ 6,020.44- │ │ │ │ │ │ │ 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- 132-69290-050-000 To MUD2 Water Plant Renovation │ 29,379.00 │ 29,379.00 │ │ │ 29,378.65 │ 99.999 │ .35 │ │ │ │ │ │ │ Subtotal: │ 29,379.00 │ 29,379.00 │ │ │ 472,160.65 │ 1,607.137 │ 442,781.65- │ │ │ │ │ │ │ 132-70005-050-000 Paying Agent Fees │ │ │ │ │ 500.00 │ │ 500.00- │ │ │ │ │ │ │ Subtotal: │ │ │ │ │ 500.00 │ │ 500.00- │ │ │ │ │ │ │ Program number: │ 480,162.00 │ 480,162.00 │ │ 53,483.78 │ 979,776.23 │ 204.051 │ 499,614.23- │ │ │ │ │ │ │ Department number: Operating & Maintenance │ 480,162.00 │ 480,162.00 │ │ 53,483.78 │ 979,776.23 │ 204.051 │ 499,614.23- │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 480,162.00 │ 480,162.00 │ │ 53,483.78 │ 979,776.23 │ 204.051 │ 499,614.23- glbase_tbam rgonzale Trophy Club Entities Page 52 19:07 10/23/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: 50 Operating & Maintenance Program: Period Ending: 09/2007 Account Description Total Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Fund number: 132 TROPHY CLUB M.U.D. 1 O & M │ 39,337.00-│ 39,337.00-│ │ 49,166.58 │ 59,665.94-│ 151.679 │ 20,328.94 glbase_tbam rgonzale Trophy Club Entities Page 75 19:07 10/23/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 09/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,389.84-│ 635,411.59-│ 100.539 │ 3,406.59 532-40015-000-000 Property Taxes/P & I │ 3,500.00-│ 3,500.00-│ │ 474.24-│ 3,956.71-│ 113.049 │ 456.71 │ │ │ │ │ │ │ Subtotal: │ 635,505.00-│ 635,505.00-│ │ 2,864.08-│ 639,368.30-│ 100.608 │ 3,863.30 │ │ │ │ │ │ │ 532-49010-000-000 Interest Income │ 18,500.00-│ 18,500.00-│ │ 305.51-│ 23,214.84-│ 125.486 │ 4,714.84 │ │ │ │ │ │ │ Subtotal: │ 18,500.00-│ 18,500.00-│ │ 305.51-│ 23,214.84-│ 125.486 │ 4,714.84 │ │ │ │ │ │ │ Program number: │ 654,005.00-│ 654,005.00-│ │ 3,169.59-│ 662,583.14-│ 101.312 │ 8,578.14 │ │ │ │ │ │ │ Department number: Revenues │ 654,005.00-│ 654,005.00-│ │ 3,169.59-│ 662,583.14-│ 101.312 │ 8,578.14 │ │ │ │ │ │ │ Revenues Subtotal ----------│ 654,005.00-│ 654,005.00-│ │ 3,169.59-│ 662,583.14-│ 101.312 │ 8,578.14 glbase_tbam rgonzale Trophy Club Entities Page 76 19:07 10/23/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: 51 Interest & Sinking Program: Period Ending: 09/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 │ │ │ 117,445.00 │ 100.000 │ 532-70035-051-000 Bond Principal Payment │ 535,000.00 │ 535,000.00 │ │ │ 535,000.00 │ 100.000 │ │ │ │ │ │ │ │ Subtotal: │ 654,005.00 │ 654,005.00 │ │ │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Program number: │ 654,005.00 │ 654,005.00 │ │ │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Department number: Interest & Sinking │ 654,005.00 │ 654,005.00 │ │ │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 654,005.00 │ 654,005.00 │ │ │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Fund number: 532 TROPHY CLUB M.U.D. 1 I & S │ │ │ │ 3,169.59-│ 9,838.14-│ │ 9,838.14