Loading...
HomeMy WebLinkAboutAugust 2007 Budget Summaryglbase_tbam rgonzale Trophy Club Entities Page 49 10:56 10/05/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 08/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-│ │ 468.80-│ 91,699.94-│ 103.923 │ 3,461.94 132-40010-000-000 Property Taxes/MUD Fire │ 409,261.00-│ 409,261.00-│ │ 2,167.96-│ 407,113.92-│ 99.475 │ 2,147.08- 132-40015-000-000 Property Taxes/P & I │ 1,000.00-│ 1,000.00-│ │ 81.15-│ 908.50-│ 90.850 │ 91.50- 132-40020-000-000 Property Taxes/Fire P&I │ 2,000.00-│ 2,000.00-│ │ 375.40-│ 2,329.17-│ 116.459 │ 329.17 │ │ │ │ │ │ │ Subtotal: │ 500,499.00-│ 500,499.00-│ │ 3,093.31-│ 502,051.53-│ 100.310 │ 1,552.53 │ │ │ │ │ │ │ 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,947.61-│ 28,542.94-│ 150.226 │ 9,542.94 132-49900-000-000 Miscellaneous Income │ │ │ │ │ 56,530.50-│ │ 56,530.50 │ │ │ │ │ │ │ Subtotal: │ 19,000.00-│ 19,000.00-│ │ 2,947.61-│ 533,073.44-│ 2,805.650 │ 514,073.44 │ │ │ │ │ │ │ Program number: │ 519,499.00-│ 519,499.00-│ │ 6,040.92-│ 1,035,124.97-│ 199.254 │ 515,625.97 │ │ │ │ │ │ │ Department number: Revenues │ 519,499.00-│ 519,499.00-│ │ 6,040.92-│ 1,035,124.97-│ 199.254 │ 515,625.97 │ │ │ │ │ │ │ Revenues Subtotal ----------│ 519,499.00-│ 519,499.00-│ │ 6,040.92-│ 1,035,124.97-│ 199.254 │ 515,625.97 glbase_tbam rgonzale Trophy Club Entities Page 50 10:56 10/05/07 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 Department: 50 Operating & Maintenance Program: Period Ending: 08/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 │ │ 900.00 │ 6,700.00 │ 111.667 │ 700.00- 132-50030-050-000 Social Security Taxes │ 405.00 │ 405.00 │ │ 55.80 │ 415.40 │ 102.568 │ 10.40- 132-50035-050-000 Medicare Taxes │ 87.00 │ 87.00 │ │ 13.05 │ 97.15 │ 111.667 │ 10.15- 132-50040-050-000 Unemployment Taxes │ 50.00 │ 50.00 │ │ 4.50 │ 71.00 │ 142.000 │ 21.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 │ │ 973.35 │ 7,302.43 │ 111.114 │ 730.43- │ │ │ │ │ │ │ 132-55045-050-000 Legal │ 6,500.00 │ 6,500.00 │ │ 4,005.00 │ 24,813.57 │ 381.747 │ 18,313.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 │ │ 4,005.00 │ 58,057.08 │ 211.117 │ 30,557.08- │ │ │ │ │ │ │ 132-60066-050-000 Publications/Books/Subscripts │ │ │ │ 20.02 │ 20.02 │ │ 20.02- 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 │ │ │ 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 │ 375,155.99 │ 91.667 │ 34,105.01 │ │ │ │ │ │ │ Subtotal: │ 416,711.00 │ 416,711.00 │ │ 34,125.11 │ 388,194.10 │ 93.157 │ 28,516.90 │ │ │ │ │ │ │ 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 │ 29,378.65 │ 99.999 │ .35 │ │ │ │ │ │ │ Subtotal: │ 29,379.00 │ 29,379.00 │ │ 29,378.65 │ 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 │ │ 68,482.11 │ 926,292.45 │ 192.912 │ 446,130.45- │ │ │ │ │ │ │ Department number: Operating & Maintenance │ 480,162.00 │ 480,162.00 │ │ 68,482.11 │ 926,292.45 │ 192.912 │ 446,130.45- │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 480,162.00 │ 480,162.00 │ │ 68,482.11 │ 926,292.45 │ 192.912 │ 446,130.45- │ │ │ │ │ │ │ Fund number: 132 TROPHY CLUB M.U.D. 1 O & M │ 39,337.00-│ 39,337.00-│ │ 62,441.19 │ 108,832.52-│ 276.667 │ 69,495.52 glbase_tbam rgonzale Trophy Club Entities Page 72 10:56 10/05/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: Revenues Program: Period Ending: 08/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-│ │ 3,352.63-│ 633,021.75-│ 100.161 │ 1,016.75 532-40015-000-000 Property Taxes/P & I │ 3,500.00-│ 3,500.00-│ │ 579.51-│ 3,482.47-│ 99.499 │ 17.53- │ │ │ │ │ │ │ Subtotal: │ 635,505.00-│ 635,505.00-│ │ 3,932.14-│ 636,504.22-│ 100.157 │ 999.22 │ │ │ │ │ │ │ 532-49010-000-000 Interest Income │ 18,500.00-│ 18,500.00-│ │ 2,677.76-│ 22,909.33-│ 123.834 │ 4,409.33 │ │ │ │ │ │ │ Subtotal: │ 18,500.00-│ 18,500.00-│ │ 2,677.76-│ 22,909.33-│ 123.834 │ 4,409.33 │ │ │ │ │ │ │ Program number: │ 654,005.00-│ 654,005.00-│ │ 6,609.90-│ 659,413.55-│ 100.827 │ 5,408.55 │ │ │ │ │ │ │ Department number: Revenues │ 654,005.00-│ 654,005.00-│ │ 6,609.90-│ 659,413.55-│ 100.827 │ 5,408.55 │ │ │ │ │ │ │ Revenues Subtotal ----------│ 654,005.00-│ 654,005.00-│ │ 6,609.90-│ 659,413.55-│ 100.827 │ 5,408.55 glbase_tbam rgonzale Trophy Club Entities Page 73 10:56 10/05/07 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 Department: 51 Interest & Sinking Program: Period Ending: 08/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 │ 117,445.00 │ 100.000 │ 532-70035-051-000 Bond Principal Payment │ 535,000.00 │ 535,000.00 │ │ 535,000.00 │ 535,000.00 │ 100.000 │ │ │ │ │ │ │ │ Subtotal: │ 654,005.00 │ 654,005.00 │ │ 593,722.50 │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Program number: │ 654,005.00 │ 654,005.00 │ │ 593,722.50 │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Department number: Interest & Sinking │ 654,005.00 │ 654,005.00 │ │ 593,722.50 │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Expenditures Subtotal ----------│ 654,005.00 │ 654,005.00 │ │ 593,722.50 │ 652,745.00 │ 99.807 │ 1,260.00 │ │ │ │ │ │ │ Fund number: 532 TROPHY CLUB M.U.D. 1 I & S │ │ │ │ 587,112.60 │ 6,668.55-│ │ 6,668.55