Loading...
HomeMy WebLinkAboutJuly 2009 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 70 11:45 09/25/09 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 O & M Department: Revenues Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 132-40000-000-000 Property Taxes 76,927.00- 76,927.00- 234.42- 79,904.21- 103.870 2,977.21 132-40010-000-000 Property Taxes/MUD Fire 603,648.00- 603,648.00- 1,838.97- 625,784.25- 103.667 22,136.25 132-40015-000-000 Property Taxes/P & I 1,000.00- 1,000.00- 15.53- 1,077.39- 107.739 77.39 132-40020-000-000 Property Taxes/Fire P&I 3,500.00- 3,500.00- 121.85- 8,001.60- 228.617 4,501.60 Subtotal: 685,075.00- 685,075.00- 2,210.77- 714,767.45- 104.334 29,692.45 132-48005-000-000 Utility Fees 86,250.00- 86,250.00- 47,150.00- 108,100.00- 125.333 21,850.00 Subtotal: 86,250.00- 86,250.00- 47,150.00- 108,100.00- 125.333 21,850.00 132-49010-000-000 Interest Income 10,000.00- 10,000.00- 86.51- 3,301.64- 33.016 6,698.36- 132-49015-000-000 Lease/Rental Income from Fire 154,000.00- 154,000.00- 154,000.00- 100.000 132-49900-000-000 Miscellaneous Income 125.98- 125.98 Subtotal: 164,000.00- 164,000.00- 86.51- 157,427.62- 95.992 6,572.38- Program number: 935,325.00- 935,325.00- 49,447.28- 980,295.07- 104.808 44,970.07 Department number: Revenues 935,325.00- 935,325.00- 49,447.28- 980,295.07- 104.808 44,970.07 Revenues Subtotal ----------- 935,325.00- 935,325.00- 49,447.28- 980,295.07- 104.808 44,970.07 . glbase_tbam rgonzale Trophy Club Entities Page 71 11:45 09/25/09 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 O & M Department: 50 Operating & Maintenance Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 132-50005-050-000 Salaries & Wages 9,200.00 9,200.00 400.00 10,800.00 117.391 1,600.00- 132-50030-050-000 Social Security Taxes 570.00 570.00 24.80 669.60 117.474 99.60- 132-50035-050-000 Medicare Taxes 133.00 133.00 5.80 156.60 117.744 23.60- 132-50040-050-000 Unemployment Taxes 121.00 121.00 2.00 72.00 59.504 49.00 132-50045-050-000 Workman's Compensation 60.00 60.00 13.06 52.24 87.067 7.76 Subtotal: 10,084.00 10,084.00 445.66 11,750.44 116.526 1,666.44- 132-55045-050-000 Legal 10,800.00 118,932.00 23,759.20 119,097.88 100.139 165.88- 132-55055-050-000 Auditing 12,989.00 12,989.00 8,340.00 64.208 4,649.00 132-55065-050-000 Tax Admin Fees 14,012.00 14,012.00 8,537.94 60.933 5,474.06 132-55160-050-000 Professional Outside Services 500.00 500.00- Subtotal: 37,801.00 145,933.00 23,759.20 136,475.82 93.520 9,457.18 132-60066-050-000 Publications/Books/Subscripts 10.00 10.00- 132-60070-050-000 Dues & Memberships 600.00 600.00 592.00 98.667 8.00 132-60075-050-000 Meetings 300.00 300.00 229.33 76.443 70.67 132-60080-050-000 Schools & Training 2,750.00 2,750.00 25.00 2,220.00 80.727 530.00 132-60100-050-000 Travel & per diem 6,353.00 6,353.00 5,581.64 87.858 771.36 132-60115-050-000 Elections 2,805.00 2,931.50 104.510 126.50- 132-60125-050-000 Advertising 410.00 410.00 396.90 96.805 13.10 132-60245-050-000 Miscellaneous Expenses 150.00 150.00 80.84 53.893 69.16 132-60336-050-000 Interfund Trans Out (MUD1 I&S) 90,169.00 90,169.00 90,169.00 100.000 132-60345-050-000 Intergov Trans Out (Fire Dept) 607,148.00 607,148.00 202,621.19 633,590.87 104.355 26,442.87- 132-60346-050-000 Loan to MUD 2 240,250.00 240,250.00 100.000 Subtotal: 707,880.00 950,935.00 202,646.19 976,052.08 102.641 25,117.08- 132-65085-050-000 Office Supplies 100.00 100.00 100.00 Subtotal: 100.00 100.00 100.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 29,378.65 99.999 .35 132-70005-050-000 Paying Agent Fees 750.00 750.00 750.00- Subtotal: 750.00 750.00 750.00- Program number: 785,244.00 1,136,431.00 227,601.05 1,154,406.99 101.582 17,975.99- Department number: Operating & Maintenance 785,244.00 1,136,431.00 227,601.05 1,154,406.99 101.582 17,975.99- . glbase_tbam rgonzale Trophy Club Entities Page 72 11:45 09/25/09 Budget Summary with Amendment Fund: 132 TROPHY CLUB M.U.D. 1 O & M Department: 50 Operating & Maintenance Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Expenditures Subtotal ----------- 785,244.00 1,136,431.00 227,601.05 1,154,406.99 101.582 17,975.99- Fund number: 132 TROPHY CLUB M.U.D. 1 O & M 150,081.00- 201,106.00 178,153.77 174,111.92 86.577 26,994.08 . glbase_tbam rgonzale Trophy Club Entities Page 86 11:45 09/25/09 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-43425-000-000 Intergov Trans in-MUD 2 Fire 58,650.00- 1,037,883.60- 1,037,883.60 315-43429-000-000 Intergov Trans In-MUD 2 740,250.00- 740,250.00 Subtotal: 58,650.00- 1,778,133.60- 1,778,133.60 315-49010-000-000 Interest Income 501.21- 3,794.89- 3,794.89 Subtotal: 501.21- 3,794.89- 3,794.89 Program number: 59,151.21- 1,781,928.49- 1,781,928.49 Department number: Revenues 59,151.21- 1,781,928.49- 1,781,928.49 Revenues Subtotal ----------- 59,151.21- 1,781,928.49- 1,781,928.49 Fund number: 315 MASTER DIST CIP FIRE STATION 59,151.21- 1,781,928.49- 1,781,928.49 . glbase_tbam rgonzale Trophy Club Entities Page 104 11:45 09/25/09 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 I & S Department: Revenues Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 532-40000-000-000 Property Taxes 490,081.00- 490,081.00- 1,492.97- 510,123.73- 104.090 20,042.73 532-40015-000-000 Property Taxes/P & I 3,553.00- 3,553.00- 98.93- 6,981.59- 196.498 3,428.59 Subtotal: 493,634.00- 493,634.00- 1,591.90- 517,105.32- 104.755 23,471.32 532-49010-000-000 Interest Income 12,000.00- 12,000.00- 180.21- 1,879.16- 15.660 10,120.84- 532-49035-000-000 Prior Year Reserves 60,000.00- 60,000.00- 60,000.00- 532-49140-000-000 Interfund Trans In (MUD1 O&M) 90,169.00- 90,169.00- 90,169.00- 100.000 Subtotal: 162,169.00- 162,169.00- 180.21- 92,048.16- 56.761 70,120.84- Program number: 655,803.00- 655,803.00- 1,772.11- 609,153.48- 92.887 46,649.52- Department number: Revenues 655,803.00- 655,803.00- 1,772.11- 609,153.48- 92.887 46,649.52- Revenues Subtotal ----------- 655,803.00- 655,803.00- 1,772.11- 609,153.48- 92.887 46,649.52- . glbase_tbam rgonzale Trophy Club Entities Page 105 11:45 09/25/09 Budget Summary with Amendment Fund: 532 TROPHY CLUB M.U.D. 1 I & S Department: 51 Interest & Sinking Program: Period Ending: 07/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 532-70005-051-000 Paying Agent Fee 910.00 910.00 300.00 32.967 610.00 532-70025-051-000 Bond Interest Expense 74,893.00 74,893.00 37,446.25 50.000 37,446.75 532-70035-051-000 Bond Principal Payment 580,000.00 580,000.00 580,000.00 Subtotal: 655,803.00 655,803.00 37,746.25 5.756 618,056.75 Program number: 655,803.00 655,803.00 37,746.25 5.756 618,056.75 Department number: Interest & Sinking 655,803.00 655,803.00 37,746.25 5.756 618,056.75 Expenditures Subtotal ----------- 655,803.00 655,803.00 37,746.25 5.756 618,056.75