Loading...
HomeMy WebLinkAboutJune 2010 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 46 23:59 07/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 51,966.00- 49,222.95- 94.721 2,743.05- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 6,047.68- 1,126,845.83- 100.880 9,832.83 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 878.97- 10,404.46- 160.069 3,904.46 Subtotal: 1,123,513.00- 1,175,479.00- 6,926.65- 1,186,473.24- 100.935 10,994.24 122-42014-000-000 Fire Permits/Sprinkler 3,600.00- 3,600.00 Subtotal: 3,600.00- 3,600.00 122-43400-000-000 Fire Inspections 675.00- 675.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 13,750.00- 13,750.00- 10,000.00- 72.727 3,750.00- 122-43426-000-000 Intergov Trans (PID Fire) 51,966.00- 122-43599-000-000 Misc Fire Revenue 1,200.00- 1,200.00- 6,563.41- 546.951 5,363.41 Subtotal: 66,916.00- 14,950.00- 17,238.41- 115.307 2,288.41 122-49010-000-000 Interest Income 26.80- 26.80 122-49020-000-000 Contributions 325.00- 325.00- 325.00 122-49900-000-000 Miscellaneous Income 100.00- 100.00 Subtotal: 325.00- 451.80- 451.80 Program number: 1,190,429.00- 1,190,429.00- 7,251.65- 1,207,763.45- 101.456 17,334.45 Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 7,251.65- 1,207,763.45- 101.456 17,334.45 . glbase_tbam rgonzale Trophy Club Entities Page 48 23:59 07/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 398,849.00 398,620.00 31,119.69 289,840.83 72.711 108,779.17 122-50010-045-000 Overtime 40,298.00 40,298.00 2,911.42 25,635.48 63.615 14,662.52 122-50011-045-000 DPS Holiday Pay 11,329.00 11,464.00 11,463.22 99.993 .78 122-50016-045-000 Longevity 2,704.00 2,798.00 2,797.22 99.972 .78 122-50017-045-000 Certification 5,356.00 5,356.00 477.96 4,832.56 90.227 523.44 122-50020-045-000 Retirement 59,532.00 59,532.00 4,233.39 44,475.56 74.709 15,056.44 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,285.82 31,620.03 73.712 11,276.97 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 235.89 2,255.82 73.913 796.18 122-50028-045-000 Vision Insurance 493.00 493.00 37.91 363.88 73.809 129.12 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 178.19 1,702.20 65.926 879.80 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 1,963.88 20,478.02 77.229 6,037.98 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 459.27 4,789.15 77.232 1,411.85 122-50040-045-000 Unemployment Taxes 549.00 549.00 71.86 1,600.15 291.466 1,051.15- 122-50045-045-000 Workman's Compensation 9,799.00 9,799.00 9,471.65 96.659 327.35 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 278.30 278.30 41.230 396.70 Subtotal: 610,832.00 610,832.00 45,253.58 451,604.07 73.933 159,227.93 122-55080-045-000 Maintenance & Repairs 5,400.00 5,400.00 125.00 3,463.04 64.130 1,936.96 122-55090-045-000 Vehicle Maintenance 13,500.00 13,500.00 548.62 12,057.61 89.316 1,442.39 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 772.26 22.065 2,727.74 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 931.40 2,313.56 21.032 8,686.44 122-55110-045-000 Maintenance-Radios 1,000.00 1,000.00 1,000.00 122-55160-045-000 Professional Outside Services 40,000.00 40,000.00 38,387.99 95.970 1,612.01 Subtotal: 74,400.00 74,400.00 1,605.02 56,994.46 76.605 17,405.54 122-60005-045-000 Telephone 100.00 100.00 5.17 37.87 37.870 62.13 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 183.66 1,449.75 58.528 1,027.25 122-60020-045-000 Electricity 16,571.00 16,571.00 729.34 7,549.76 45.560 9,021.24 122-60025-045-000 Water 3,100.00 3,100.00 145.60 900.56 29.050 2,199.44 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 93.00 93.00 65.10 70.000 27.90 122-60055-045-000 Insurance 19,024.00 19,024.00 19,024.00 122-60066-045-000 Publications/Books/Subscrips 364.00 364.00 43.04 11.824 320.96 122-60070-045-000 Dues & Memberships 7,960.00 7,960.00 6,322.52 79.429 1,637.48 122-60075-045-000 Meetings 300.00 300.00 120.52 40.173 179.48 122-60080-045-000 Schools & Training 6,300.00 6,300.00 1,390.00 2,700.00 42.857 3,600.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,769.00 6,769.00 2,608.59 38.537 4,160.41 122-60110-045-000 Physicals/Testing 1,843.00 1,843.00 1,800.00 97.667 43.00 122-60125-045-000 Advertising 150.00 150.00 150.00 122-60160-045-000 Programs & Special Projects 4,000.00 4,000.00 512.20 958.07 23.952 3,041.93 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 465.44 46.544 534.56 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 320.00 1,401.44 60.747 905.56 . glbase_tbam rgonzale Trophy Club Entities Page 49 23:59 07/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,200.00 1,200.00 25.72 417.79 34.816 782.21 Subtotal: 382,558.00 382,558.00 3,311.69 335,840.45 87.788 46,717.55 122-65005-045-000 Fuel & Lube 15,795.00 12,095.00 782.13 5,567.24 46.029 6,527.76 122-65010-045-000 Uniforms 4,230.00 4,230.00 450.46 2,160.66 51.079 2,069.34 122-65015-045-000 Protective Clothing 4,600.00 4,600.00 3,840.49 83.489 759.51 122-65030-045-000 Chemicals 1,500.00 1,500.00 1,500.00 122-65035-045-000 Small Tools 7,890.00 7,890.00 216.56 2,830.01 35.868 5,059.99 122-65085-045-000 Office Supplies 310.00 310.00 17.68 193.04 62.271 116.96 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 101.23 1,059.51 41.944 1,466.49 122-65105-045-000 Printing 100.00 100.00 22.49 22.490 77.51 Subtotal: 36,951.00 33,251.00 1,568.06 15,673.44 47.137 17,577.56 122-69006-045-000 Grant Match 3,000.00 10,000.00 10,000.00 122-69035-045-000 Vehicles 7,500.00 4,200.00 4,182.59 99.585 17.41 122-69251-045-000 Engine 681 Payment 72,943.00 72,943.00 6,971.30 9.557 65,971.70 122-69255-045-000 Airpacks 2,245.00 2,245.00 2,245.00 Subtotal: 85,688.00 89,388.00 11,153.89 12.478 78,234.11 Program number: 1,190,429.00 1,190,429.00 51,738.35 871,266.31 73.189 319,162.69 . glbase_tbam rgonzale Trophy Club Entities Page 47 23:59 07/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 26 TC WOMEN'S CLUB GRANT FY09-10 Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-45000-045-026 Grant Revenue 1,200.00- 1,200.00 Subtotal: 1,200.00- 1,200.00 Program number: 26 TC WOMEN'S CLUB GRANT FY09-10 1,200.00- 1,200.00 Department number: Fire 1,200.00- 1,200.00 Revenues Subtotal ----------- 1,190,429.00- 1,190,429.00- 7,251.65- 1,208,963.45- 101.557 18,534.45 . glbase_tbam rgonzale Trophy Club Entities Page 50 23:59 07/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 26 TC WOMEN'S CLUB GRANT FY09-10 Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-65035-045-026 Small Tools 1,099.00 1,099.00- Subtotal: 1,099.00 1,099.00- Program number: 26 TC WOMEN'S CLUB GRANT FY09-10 1,099.00 1,099.00- Department number: Fire 1,190,429.00 1,190,429.00 51,738.35 872,365.31 73.282 318,063.69 Expenditures Subtotal ----------- 1,190,429.00 1,190,429.00 51,738.35 872,365.31 73.282 318,063.69 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 44,486.70 336,598.14- 336,598.14 . glbase_tbam rgonzale Trophy Club Entities Page 51 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 277,854.00- 277,854.00- 1,483.93- 278,998.96- 100.412 1,144.96 135-40015-000-000 Property Taxes/P & I 240.66- 3,577.70- 3,577.70 Subtotal: 277,854.00- 277,854.00- 1,724.59- 282,576.66- 101.700 4,722.66 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 222,852.84- 893,020.31- 53.045 790,504.69- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 103,882.39- 656,456.83- 62.011 402,163.17- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 87,112.58- 389,532.60- 52.022 359,247.40- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 22,241.60- 174,993.01- 52.457 158,601.99- 135-47020-000-000 Standby 1,140.00- 1,140.00- 77.00- 566.10- 49.658 573.90- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 2,753.25- 27,463.13- 49.933 27,536.87- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 378.00- 14,008.65- 87.554 1,991.35- 135-47035-000-000 Plumbing Inspections 200.00- 850.00- 850.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 675.00- 2,625.00- 210.000 1,375.00 135-47050-000-000 Tap Fees 1,500.00- 1,500.00- 1,500.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 9,153.03- 17,770.76- 29.618 42,229.24- 135-47270-000-000 Fire Line 4,725.00- 4,725.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 1,053.82- 15,831.69- 43.794 20,318.31- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 1,342.48- 8,348.77- 53.863 7,151.23- 135-47410-000-000 Out of Dist/Portable Penalties 200.00- 200.00- 701.74- 350.870 501.74 135-47600-000-000 PID #1 Water 201,396.00- 201,396.00- 18,696.69- 96,054.81- 47.694 105,341.19- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 7,909.47- 40,588.52- 67.760 19,311.48- Subtotal: 4,271,056.00- 4,271,056.00- 479,828.15- 2,345,036.92- 54.905 1,926,019.08- 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 1,500.66- 75.033 499.34- 135-49015-000-000 Lease/Rental Income 10,164.00- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 7,623.00- 75.000 2,541.00- 135-49018-000-000 Building Rent Income 7,000.00- 583.33- 5,249.97- 75.000 1,750.03- 135-49030-000-000 Vending Revenue 850.00- 850.00- 650.00- 76.471 200.00- 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 12,710.00- 135-49075-000-000 New Oversize Meter Reimburse 36,000.00- 36,000.00- 6,414.50- 38,926.50- 108.129 2,926.50 135-49900-000-000 Miscellaneous Income 21,100.00- 14,100.00- 2,938.98- 13,558.88- 96.162 541.12- 135-49901-000-000 Records Management Revenue 276.00- 276.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 4,510.00- 38,635.00- 120.734 6,635.00 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 194.05- 1,688.19- 27.229 4,511.81- Subtotal: 121,024.00- 121,024.00- 15,487.86- 108,108.20- 89.328 12,915.80- Program number: 4,669,934.00- 4,669,934.00- 497,040.60- 2,735,721.78- 58.582 1,934,212.22- Department number: Revenues 4,669,934.00- 4,669,934.00- 497,040.60- 2,735,721.78- 58.582 1,934,212.22- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 497,040.60- 2,735,721.78- 58.582 1,934,212.22- . glbase_tbam rgonzale Trophy Club Entities Page 52 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 159,774.00 159,774.00 9,497.52 88,161.83 55.179 71,612.17 135-50010-010-000 Overtime 8,814.00 8,814.00 888.90 10,445.43 118.510 1,631.43- 135-50016-010-000 Longevity 1,910.00 1,910.00 1,910.00 100.000 135-50017-010-000 Certification 1,500.00 1,500.00 115.00 920.00 61.333 580.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,392.50 13,898.76 62.159 8,461.24 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 11,395.62 49.257 11,739.38 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 789.66 50.329 779.34 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 144.54 51.255 137.46 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 574.65 51.080 550.35 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 643.17 6,624.04 62.397 3,991.96 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 150.42 1,549.16 62.391 933.84 135-50040-010-000 Unemployment Taxes 270.00 270.00 567.00 210.000 297.00- 135-50045-010-000 Workman's Compensation 5,496.00 5,496.00 2,435.00 44.305 3,061.00 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 12.50 115.50 33.000 234.50 Subtotal: 239,884.00 239,884.00 14,133.84 139,531.19 58.166 100,352.81 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-010-000 Maintenance & Repairs 26,000.00 26,000.00 597.35 3,121.72 12.007 22,878.28 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 2,201.42 69.227 978.58 135-55100-010-000 Building Maint & Supplies 750.00 750.00 259.59 34.612 490.41 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 187.64 6.470 2,712.36 135-55135-010-000 Lab Analysis 3,350.00 3,350.00 165.00 1,520.40 45.385 1,829.60 Subtotal: 37,680.00 37,680.00 762.35 7,290.77 19.349 30,389.23 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 133.80 1,078.45 53.495 937.55 135-60020-010-000 Electricity 195,000.00 195,000.00 15,998.04 78,587.13 40.301 116,412.87 135-60035-010-000 Postage 100.00 100.00 47.14 47.140 52.86 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 88.70- 1,377.67 32.802 2,822.33 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 50.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 185.00 562.02 20.072 2,237.98 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 65.50 1,053.70 32.928 2,146.30 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 6,133.95 92.939 466.05 135-60150-010-000 Bulk Water 1,410,000.00 1,393,650.00 111,747.51 543,755.98 39.017 849,894.02 135-60245-010-000 Miscellaneous Expenses 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 560.90 13.355 3,639.10 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 29.97 1.499 1,970.03 Subtotal: 1,631,316.00 1,614,966.00 128,041.15 633,202.79 39.208 981,763.21 . glbase_tbam rgonzale Trophy Club Entities Page 53 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 845.40 6,588.83 43.302 8,627.17 135-65010-010-000 Uniforms 3,690.00 3,690.00 841.72 22.811 2,848.28 135-65030-010-000 Chemicals 5,200.00 5,200.00 411.84 4,421.76 85.034 778.24 135-65035-010-000 Small Tools 2,500.00 2,500.00 19.97 216.83 8.673 2,283.17 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 280.52 11.221 2,219.48 135-65050-010-000 Meter Expense 75,000.00 75,000.00 133.00 73,508.50 98.011 1,491.50 135-65055-010-000 Hardware 1,000.00 1,000.00 51.74 5.174 948.26 135-65095-010-000 Maintenance Supplies 30,000.00 30,000.00 93.00 7,099.99 23.667 22,900.01 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 150.00 Subtotal: 135,306.00 135,306.00 1,503.21 93,009.89 68.740 42,296.11 135-69005-010-000 Capital Expenses 38,500.00 54,850.00 17,343.10 86,669.66 158.012 31,819.66- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 9,000.00 9,000.00 9,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 124,771.00 124,769.79 99.999 1.21 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 11,490.00 Subtotal: 214,011.00 230,361.00 17,343.10 211,439.45 91.786 18,921.55 Program number: 2,258,197.00 2,258,197.00 161,783.65 1,084,474.09 48.024 1,173,722.91 Department number: Water 2,258,197.00 2,258,197.00 161,783.65 1,084,474.09 48.024 1,173,722.91 . glbase_tbam rgonzale Trophy Club Entities Page 54 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 171,607.00 171,607.00 13,189.92 123,337.73 71.872 48,269.27 135-50010-020-000 Overtime 10,166.00 10,166.00 668.04 12,707.82 125.003 2,541.82- 135-50016-020-000 Longevity 3,153.00 3,153.00 3,152.50 99.984 .50 135-50017-020-000 Certification 2,550.00 2,550.00 175.00 1,400.00 54.902 1,150.00 135-50020-020-000 Retirement 24,372.00 24,372.00 1,860.77 19,231.90 78.910 5,140.10 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 20,627.28 75.000 6,875.72 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 1,487.52 75.014 495.48 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 267.84 75.025 89.16 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 800.55 66.824 397.45 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 728.71 7,984.56 80.360 1,951.44 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 170.44 1,867.36 80.351 456.64 135-50040-020-000 Unemployment Taxes 270.00 270.00 756.00 280.000 486.00- 135-50045-020-000 Workman's Compensation 5,991.00 5,991.00 4,828.01 80.588 1,162.99 135-50070-020-000 Employee Relations 250.00 250.00 250.00 Subtotal: 261,660.00 261,660.00 19,368.79 198,449.07 75.842 63,210.93 135-55005-020-000 Engineering 1,500.00 1,500.00 1,750.00 116.667 250.00- 135-55070-020-000 Independent Labor 750.00 750.00 750.00 135-55080-020-000 Maintenance & Repairs 20,250.00 20,250.00 325.00 10,340.38 51.064 9,909.62 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 57.87 2,210.84 96.459 81.16 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 260.00 618.00 44.143 782.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 303.53 10.289 2,646.47 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 1,692.65 11,594.39 41.409 16,405.61 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,071.00 9,079.00 43.754 11,671.00 Subtotal: 77,892.00 77,892.00 3,406.52 35,896.14 46.085 41,995.86 135-60005-020-000 Telephone 10.00 4.77 41.63 416.300 31.63- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 239.21 1,922.63 58.688 1,353.37 135-60020-020-000 Electricity 230,000.00 230,000.00 17,444.81 135,624.95 58.967 94,375.05 135-60025-020-000 Water 1,600.00 1,600.00 237.86 1,376.10 86.006 223.90 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60080-020-000 Schools & Training 1,320.00 1,320.00 311.00 462.00 35.000 858.00 135-60090-020-000 Safety Program 200.00 200.00 200.00 135-60100-020-000 Travel & per diem 1,250.00 1,250.00 94.00 1,669.70 133.576 419.70- 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 200.00 135-60135-020-000 Annual Permit Fee 7,500.00 7,490.00 7,432.50 99.232 57.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 25.72 4.899 499.28 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 88.17 16.794 436.83 Subtotal: 247,016.00 247,016.00 18,331.65 148,643.40 60.176 98,372.60 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 379.41 2,298.16 60.878 1,476.84 . glbase_tbam rgonzale Trophy Club Entities Page 55 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,205.00 2,205.00 989.29 44.866 1,215.71 135-65030-020-000 Chemicals 9,900.00 9,900.00 5,875.04 15,614.07 157.718 5,714.07- 135-65035-020-000 Small Tools 1,260.00 1,260.00 235.73 515.61 40.921 744.39 135-65040-020-000 Safety Equipment 540.00 540.00 15.96 369.84 68.489 170.16 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 3,473.39 57.081 2,611.61 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 400.00 135-65095-020-000 Maintenance Supplies 13,260.00 13,260.00 900.00 2,514.27 18.961 10,745.73 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 7,406.14 25,780.07 67.735 12,279.93 135-69005-020-000 Capital Expenses 144,689.00 144,689.00 144,689.00 135-69280-020-000 Capital Repairs 51,800.00 51,800.00 14,994.25 28.946 36,805.75 Subtotal: 196,489.00 196,489.00 14,994.25 7.631 181,494.75 Program number: 821,117.00 821,117.00 48,513.10 423,762.93 51.608 397,354.07 Department number: Wastewater 821,117.00 821,117.00 48,513.10 423,762.93 51.608 397,354.07 . glbase_tbam rgonzale Trophy Club Entities Page 56 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 132,345.00 132,313.00 10,180.36 95,247.66 71.987 37,065.34 135-50010-021-000 Overtime 14,145.00 14,145.00 1,244.84 7,554.79 53.410 6,590.21 135-50016-021-000 Longevity 2,888.00 2,920.00 2,920.00 100.000 135-50017-021-000 Certification 1,200.00 1,200.00 125.00 1,000.00 83.333 200.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,531.55 14,593.45 74.551 4,981.55 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 13,532.04 74.999 4,510.96 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 1,069.92 75.029 356.08 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 166.68 80.913 39.32 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 608.94 66.624 305.06 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 650.92 6,437.22 76.670 1,958.78 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 152.22 1,505.48 76.654 458.52 135-50040-021-000 Unemployment Taxes 203.00 203.00 567.00 279.310 364.00- 135-50045-021-000 Workman's Compensation 3,147.00 3,147.00 2,386.07 75.820 760.93 135-50070-021-000 Employee Relations 250.00 250.00 12.50 12.50 5.000 237.50 Subtotal: 204,702.00 204,702.00 15,606.01 147,601.75 72.106 57,100.25 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 10,000.00 10,000.00 277.99 3,476.89 34.769 6,523.11 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 984.64 47.613 1,083.36 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 14,518.00 14,518.00 277.99 4,461.53 30.731 10,056.47 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 133.09 1,509.76 71.485 602.24 135-60020-021-000 Electricity 22,250.00 22,250.00 1,774.78 16,005.88 71.937 6,244.12 135-60025-021-000 Water 750.00 750.00 6.24 43.68 5.824 706.32 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 111.00 43.529 144.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 390.00 480.00 17.033 2,338.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 38.00 414.25 27.617 1,085.75 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 39,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 15.88 15.880 84.12 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 70,685.00 70,685.00 2,342.11 18,580.45 26.286 52,104.55 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 2,994.52 8,897.77 83.157 1,802.23 135-65010-021-000 Uniforms 2,505.00 2,505.00 558.95 22.313 1,946.05 135-65030-021-000 Chemicals 10,000.00 10,000.00 10,000.00 13,120.00 131.200 3,120.00- 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 1,150.00 135-65055-021-000 Hardware 750.00 750.00 750.00 . glbase_tbam rgonzale Trophy Club Entities Page 57 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 178.95 1.115 15,871.05 Subtotal: 42,655.00 42,655.00 12,994.52 22,755.67 53.348 19,899.33 135-69005-021-000 Capital Expenses 10,000.00 10,000.00 10,000.00 135-69280-021-000 Capital Repairs 20,000.00 20,000.00 20,000.00 Subtotal: 30,000.00 30,000.00 30,000.00 Program number: 362,560.00 362,560.00 31,220.63 193,399.40 53.343 169,160.60 Department number: Collection 362,560.00 362,560.00 31,220.63 193,399.40 53.343 169,160.60 . glbase_tbam rgonzale Trophy Club Entities Page 58 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 15,000.00 15,000.00 300.00 9,100.00 60.667 5,900.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 18.60 607.60 47.101 682.40 135-50035-026-000 Medicare Taxes 302.00 302.00 4.35 142.10 47.053 159.90 135-50040-026-000 Unemployment Taxes 375.00 375.00 6.30 153.00 40.800 222.00 135-50045-026-000 Workman's Compensation 120.00 120.00 80.02 66.683 39.98 Subtotal: 17,087.00 17,087.00 329.25 10,082.72 59.008 7,004.28 135-55045-026-000 Legal 32,500.00 32,500.00 5,864.04 51,927.20 159.776 19,427.20- 135-55060-026-000 Appraisal 18,874.00 18,374.00 3,147.71 13,080.49 71.190 5,293.51 135-55065-026-000 Tax Admin Fees 2,380.00 2,984.00 116.92 2,983.33 99.978 .67 Subtotal: 53,754.00 53,858.00 9,128.67 67,991.02 126.241 14,133.02- 135-60066-026-000 Publications/Books/Subscripts 54.00 54.00 54.00 135-60070-026-000 Dues & Memberships 1,096.00 2,096.00 1,960.00 93.511 136.00 135-60075-026-000 Meetings 600.00 600.00 97.00 387.91 64.652 212.09 135-60080-026-000 Schools & Training 5,775.00 5,775.00 3,395.00 58.788 2,380.00 135-60100-026-000 Travel & per diem 12,147.00 11,147.00 2,573.37 2,614.12 23.451 8,532.88 135-60115-026-000 Elections 44.64- 44.64 135-60125-026-000 Advertising 820.00 820.00 820.00 135-60245-026-000 Miscellaneous Expenses 300.00 196.00 196.00 Subtotal: 20,792.00 20,688.00 2,670.37 8,312.39 40.180 12,375.61 135-65085-026-000 Office Supplies 200.00 200.00 111.00 123.90 61.950 76.10 Subtotal: 200.00 200.00 111.00 123.90 61.950 76.10 Program number: 91,833.00 91,833.00 12,239.29 86,510.03 94.204 5,322.97 Department number: Board of Directors 91,833.00 91,833.00 12,239.29 86,510.03 94.204 5,322.97 . glbase_tbam rgonzale Trophy Club Entities Page 59 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 249,499.00 249,499.00 20,540.54 182,413.24 73.112 67,085.76 135-50010-027-000 Overtime 1,750.00 1,750.00 12.18 2,562.64 146.437 812.64- 135-50016-027-000 Longevity 3,056.00 3,056.00 3,056.25 100.008 .25- 135-50020-027-000 Retirement 32,982.00 32,982.00 2,725.29 25,817.30 78.277 7,164.70 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 16,737.49 74.999 5,579.51 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.53 1,084.64 75.010 361.36 135-50028-027-000 Vision Insurance 269.00 269.00 22.36 201.28 74.825 67.72 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 963.93 64.219 537.07 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,217.53 11,933.01 77.191 3,525.99 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 284.74 2,790.77 77.200 824.23 135-50040-027-000 Unemployment Taxes 304.00 304.00 758.13 249.385 454.13- 135-50045-027-000 Workman's Compensation 671.00 671.00 910.15 135.641 239.15- 135-50070-027-000 Employee Relations 838.00 838.00 28.99 1,007.73 120.254 169.73- Subtotal: 333,707.00 333,707.00 26,917.14 250,236.56 74.987 83,470.44 135-55070-027-000 Independent Labor 720.00 720.00 48.75 453.75 63.021 266.25 135-55075-027-000 Records Management 100.00 100.00 388.74 388.740 288.74- 135-55160-027-000 Professional Outside Services 1,000.00 1,000.00 126.87 12.687 873.13 Subtotal: 1,820.00 1,820.00 48.75 969.36 53.262 850.64 135-60005-027-000 Telephone 265.00 265.00 19.47 187.71 70.834 77.29 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 208.58 2,114.80 76.209 660.20 135-60035-027-000 Postage 1,071.00 1,071.00 38.27- 989.36 92.377 81.64 135-60040-027-000 Service Charges & Fees 50.00 50.00- 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 79.00 335.75 95.929 14.25 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 75.00 1,308.66 78.222 364.34 135-60075-027-000 Meetings 961.00 961.00 11.00 375.04 39.026 585.96 135-60080-027-000 Schools & Training 2,715.00 2,715.00 1,071.00 39.448 1,644.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 705.00 1,795.07 85.724 298.93 135-60115-027-000 Elections 3,500.00 3,500.00 2,662.57 76.073 837.43 135-60125-027-000 Advertising 650.00 650.00 2,334.00- 203.01 31.232 446.99 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60271-027-000 Town 25th Anniversary 2,500.00 2,500.00 2,500.00- 135-60350-027-000 Transfer to Debt Service 47.98 47.98- 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 893.49 51.057 856.51 Subtotal: 27,904.00 27,904.00 1,225.78 14,534.44 52.087 13,369.56 135-65085-027-000 Office Supplies 2,450.00 2,450.00 118.58 1,628.61 66.474 821.39 135-65105-027-000 Printing 515.00 515.00 84.65 16.437 430.35 Subtotal: 2,965.00 2,965.00 118.58 1,713.26 57.783 1,251.74 . glbase_tbam rgonzale Trophy Club Entities Page 60 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 366,396.00 366,396.00 28,310.25 267,453.62 72.996 98,942.38 Department number: Manager's Office 366,396.00 366,396.00 28,310.25 267,453.62 72.996 98,942.38 . glbase_tbam rgonzale Trophy Club Entities Page 61 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-028-000 Salaries & Wages 25,698.00 25,698.00 1,976.80 18,497.18 71.979 7,200.82 135-50016-028-000 Longevity 98.00 98.00 97.50 99.490 .50 135-50020-028-000 Retirement 3,353.00 3,353.00 262.13 2,558.14 76.294 794.86 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 2,001.44 74.988 667.56 135-50027-028-000 Dental Insurance 155.00 155.00 12.91 116.22 74.981 38.78 135-50028-028-000 Vision Insurance 30.00 30.00 2.48 22.36 74.533 7.64 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 122.13 66.375 61.87 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 122.56 1,230.49 77.536 356.51 135-50035-028-000 Medicare Taxes 371.00 371.00 28.65 287.74 77.558 83.26 135-50040-028-000 Unemployment Taxes 34.00 34.00 94.50 277.941 60.50- 135-50045-028-000 Workman's Compensation 68.00 68.00 58.38 85.853 9.62 135-50070-028-000 Employee Relations 1,625.00 1,625.00 9.75 1,140.65 70.194 484.35 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 144.59 9.639 1,355.41 135-50994-028-000 Employee Assistance Program 99.40 827.40 827.40- 135-50995-028-000 Flexible Benefits Admin Fee 88.82 1,244.56 1,244.56- Subtotal: 37,372.00 37,372.00 2,839.45 28,443.28 76.109 8,928.72 135-60005-028-000 Telephone 26.00 26.00 1.64 5.32 20.462 20.68 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 16.07 128.26 61.076 81.74 135-60035-028-000 Postage 102.00 102.00 22.07 106.90 104.804 4.90- 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 240.00 240.00 54.545 200.00 135-60070-028-000 Dues & Memberships 504.00 504.00 190.98 37.893 313.02 135-60075-028-000 Meetings 130.00 130.00 87.50 67.308 42.50 135-60080-028-000 Schools & Training 539.00 539.00 539.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 960.00 960.00 35.00 328.00 34.167 632.00 Subtotal: 2,919.00 2,919.00 314.78 1,086.96 37.237 1,832.04 135-65085-028-000 Office Supplies 412.00 412.00 15.00 41.94 10.180 370.06 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 15.00 41.94 8.034 480.06 Program number: 40,813.00 40,813.00 3,169.23 29,572.18 72.458 11,240.82 Department number: Human Resources 40,813.00 40,813.00 3,169.23 29,572.18 72.458 11,240.82 . glbase_tbam rgonzale Trophy Club Entities Page 62 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 135,172.00 127,457.00 7,819.25 85,968.57 67.449 41,488.43 135-50010-029-000 Overtime 2,000.00 5,683.00 170.03 4,589.56 80.759 1,093.44 135-50016-029-000 Longevity 1,259.00 870.00 870.00 100.000 135-50020-029-000 Retirement 17,996.00 16,907.00 1,059.37 12,655.25 74.852 4,251.75 135-50026-029-000 Medical Insurance 10,550.00 9,550.00 799.33 7,723.22 80.871 1,826.78 135-50027-029-000 Dental Insurance 765.00 765.00 55.97 525.74 68.724 239.26 135-50028-029-000 Vision Insurance 127.00 127.00 8.08 83.81 65.992 43.19 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 476.90 57.458 353.10 135-50030-029-000 Social Security Taxes 8,265.00 7,965.00 429.58 5,561.23 69.821 2,403.77 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 100.48 1,300.65 67.287 632.35 135-50040-029-000 Unemployment Taxes 135.00 382.00 381.21 99.793 .79 135-50045-029-000 Workman's Compensation 365.00 565.00 313.41 55.471 251.59 135-50060-029-000 Pre-emp Physicals/Testing 100.00 31.47 31.470 68.53 Subtotal: 179,397.00 173,134.00 10,488.22 120,481.02 69.588 52,652.98 135-55055-029-000 Auditing 40,000.00 37,400.00 33,591.00 89.816 3,809.00 135-55160-029-000 Professional Outside Services 8,705.00 1,633.25 2,875.75 33.036 5,829.25 Subtotal: 40,000.00 46,105.00 1,633.25 36,466.75 79.095 9,638.25 135-60005-029-000 Telephone 103.00 103.00 6.76 79.81 77.485 23.19 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 36.06 288.22 56.960 217.78 135-60035-029-000 Postage 900.00 900.00 175.95- 221.73 24.637 678.27 135-60040-029-000 Service Charges & Fees 75.00 75.00 32.50 43.333 42.50 135-60066-029-000 Publications/Books/Subscripts 250.00 250.00 25.70 10.280 224.30 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 172.50 1,166.85 85.735 194.15 135-60075-029-000 Meetings 66.00 66.00 11.00 66.00 100.000 135-60080-029-000 Schools & Training 1,370.00 1,370.00 571.05 41.682 798.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 462.13 1,044.12 63.861 590.88 135-60245-029-000 Miscellaneous Expenses 1,000.00 895.00 53.88 6.020 841.12 135-60360-029-000 Furniture/Equipment < $5000 406.00 405.24 99.813 .76 Subtotal: 7,266.00 7,567.00 512.50 3,955.10 52.268 3,611.90 135-65085-029-000 Office Supplies 800.00 657.00 21.01 442.63 67.371 214.37 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,557.00 21.01 442.63 28.428 1,114.37 Program number: 228,363.00 228,363.00 12,654.98 161,345.50 70.653 67,017.50 Department number: Finance 228,363.00 228,363.00 12,654.98 161,345.50 70.653 67,017.50 . glbase_tbam rgonzale Trophy Club Entities Page 63 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-033-000 Salaries & Wages 58,883.00 58,883.00 4,529.42 42,382.43 71.977 16,500.57 135-50016-033-000 Longevity 278.00 338.00 337.50 99.852 .50 135-50020-033-000 Retirement 7,691.00 7,691.00 600.59 5,875.28 76.392 1,815.72 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.69 3,696.19 75.004 1,231.81 135-50027-033-000 Dental Insurance 310.00 310.00 25.84 232.32 74.942 77.68 135-50028-033-000 Vision Insurance 60.00 60.00 4.96 44.69 74.483 15.31 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 255.60 66.563 128.40 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 280.81 2,826.38 77.055 841.62 135-50035-033-000 Medicare Taxes 858.00 858.00 65.66 660.95 77.034 197.05 135-50040-033-000 Unemployment Taxes 68.00 68.00 188.98 277.912 120.98- 135-50045-033-000 Workman's Compensation 156.00 156.00 133.95 85.865 22.05 Subtotal: 77,284.00 77,344.00 5,946.37 56,634.27 73.224 20,709.73 135-55030-033-000 Software & Support 56,190.00 56,130.00 2,728.08 33,769.66 60.163 22,360.34 135-55070-033-000 Independent Labor 1,464.00 1,464.00 218.75 1,434.38 97.977 29.62 Subtotal: 57,654.00 57,594.00 2,946.83 35,204.04 61.124 22,389.96 135-60005-033-000 Telephone 20,520.00 20,520.00 367.82 9,531.50 46.450 10,988.50 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 133.15 659.44 61.003 421.56 135-60035-033-000 Postage 100.00 100.00 1.73 1.730 98.27 135-60046-033-000 Prompt Payment Act Interest 2.30 2.30 2.30- 135-60066-033-000 Publications/Books/Subscripts 63.00 138.00 65.88 47.739 72.12 135-60070-033-000 Dues & Memberships 177.00 177.00 137.47 77.667 39.53 135-60075-033-000 Meetings 75.00 75.00 11.00 14.667 64.00 135-60080-033-000 Schools & Training 1,738.00 1,663.00 774.00 46.542 889.00 135-60100-033-000 Travel & per diem 1,464.00 1,464.00 341.57 23.331 1,122.43 135-60235-033-000 Security 1,902.00 1,902.00 719.76 37.842 1,182.24 Subtotal: 27,120.00 27,120.00 503.27 12,244.65 45.150 14,875.35 135-65055-033-000 Hardware 36,682.00 36,682.00 108.48 25,929.72 70.688 10,752.28 135-65085-033-000 Office Supplies 300.00 300.00 129.25 43.083 170.75 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 445.50 2,355.19 48.611 2,489.81 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 553.98 28,414.16 67.771 13,512.84 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 2,186.32 63.372 1,263.68 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 273.29 2,186.32 7.201 28,174.68 Program number: 234,346.00 234,346.00 10,223.74 134,683.44 57.472 99,662.56 . glbase_tbam rgonzale Trophy Club Entities Page 64 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Information Systems 234,346.00 234,346.00 10,223.74 134,683.44 57.472 99,662.56 . glbase_tbam rgonzale Trophy Club Entities Page 65 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55100-037-000 Building Maint & Supplies 11,400.00 6,595.00 10.96 2,913.58 44.179 3,681.42 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 701.70 6,138.80 68.209 2,861.20 Subtotal: 20,400.00 15,595.00 712.66 9,052.38 58.047 6,542.62 135-60020-037-000 Electricity 19,900.00 19,900.00 1,252.70 11,133.75 55.948 8,766.25 135-60025-037-000 Water 1,030.00 1,030.00 97.46 366.66 35.598 663.34 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 9,886.59 75.001 3,295.41 135-60055-037-000 Insurance 29,601.00 34,406.00 34,504.71 100.287 98.71- Subtotal: 63,713.00 68,518.00 2,448.67 55,891.71 81.572 12,626.29 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 92.81 1,309.85 65.493 690.15 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 43.54 534.23 53.423 465.77 Subtotal: 3,000.00 3,000.00 136.35 1,844.08 61.469 1,155.92 Program number: 87,113.00 87,113.00 3,297.68 66,788.17 76.668 20,324.83 Department number: Facilities Maintenance 87,113.00 87,113.00 3,297.68 66,788.17 76.668 20,324.83 . glbase_tbam rgonzale Trophy Club Entities Page 66 23:59 07/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 79,238.00 79,238.00 5,946.20 56,714.58 71.575 22,523.42 135-50010-038-000 Overtime 750.00 750.00 39.33 1,071.09 142.812 321.09- 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 793.68 7,967.16 76.446 2,454.84 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 8,006.04 74.998 2,668.96 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 619.92 75.051 206.08 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 99.72 74.977 33.28 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 371.97 66.661 186.03 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 362.78 3,757.31 76.368 1,162.69 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 84.85 878.73 76.345 272.27 135-50040-038-000 Unemployment Taxes 135.00 135.00 378.00 280.000 243.00- 135-50045-038-000 Workman's Compensation 212.00 212.00 182.04 85.868 29.96 Subtotal: 109,205.00 109,205.00 8,237.69 80,231.56 73.469 28,973.44 135-55070-038-000 Independent Labor 800.00 800.00 800.00 135-55205-038-000 Utility Billing Contract 11,000.00 11,000.00 1,673.61 7,184.00 65.309 3,816.00 Subtotal: 11,800.00 11,800.00 1,673.61 7,184.00 60.881 4,616.00 135-60005-038-000 Telephone 75.00 75.00 11.04 72.58 96.773 2.42 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 32.13 256.52 61.076 163.48 135-60035-038-000 Postage 15,820.00 15,820.00 2,488.78 11,329.57 71.615 4,490.43 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 1,181.24 9,012.56 60.084 5,987.44 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 149.00 18.625 651.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 20,000.00 20,000.00 17,174.03 85.870 2,825.97 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .06 .030 199.94 Subtotal: 52,991.00 52,991.00 3,713.19 37,994.32 71.700 14,996.68 135-65085-038-000 Office Supplies 700.00 700.00 12.42 499.41 71.344 200.59 135-65105-038-000 Printing 4,500.00 4,500.00 841.62 841.62 18.703 3,658.38 Subtotal: 5,200.00 5,200.00 854.04 1,341.03 25.789 3,858.97 Program number: 179,196.00 179,196.00 14,478.53 126,750.91 70.733 52,445.09 Department number: Utility Billing 179,196.00 179,196.00 14,478.53 126,750.91 70.733 52,445.09 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 325,891.08 2,574,740.27 55.134 2,095,193.73 Fund number: 135 MUD 1 O&M CONSOLIDATED 171,149.52- 160,981.51- 160,981.51 . glbase_tbam rgonzale Trophy Club Entities Page 77 23:59 07/13/10 Budget Summary with Amendment Fund: 315 MUD 1 CIP FIRE STATION Department: Revenues Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 2,173.99- 2,173.99 Subtotal: 2,173.99- 2,173.99 Program number: 2,173.99- 2,173.99 Department number: Revenues 2,173.99- 2,173.99 Revenues Subtotal ----------- 2,173.99- 2,173.99 Fund number: 315 MUD 1 CIP FIRE STATION 2,173.99- 2,173.99 . glbase_tbam rgonzale Trophy Club Entities Page 98 23:59 07/13/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 703,310.00- 703,310.00- 3,964.93- 712,861.04- 101.358 9,551.04 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 626.72- 7,005.19- 77.835 1,994.81- Subtotal: 712,310.00- 712,310.00- 4,591.65- 719,866.23- 101.061 7,556.23 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 39,100.00- 305,900.00- 88.667 39,100.00- Subtotal: 345,000.00- 345,000.00- 39,100.00- 305,900.00- 88.667 39,100.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 4,052.91- 202.646 2,052.91 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 533-49110-000-000 Premium on Bonds Sold 1,000.00- 1,000.00 Subtotal: 310,000.00- 310,000.00- 313,052.91- 100.985 3,052.91 Program number: 1,367,310.00- 1,367,310.00- 43,691.65- 1,338,819.14- 97.916 28,490.86- Department number: Revenues 1,367,310.00- 1,367,310.00- 43,691.65- 1,338,819.14- 97.916 28,490.86- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 43,691.65- 1,338,819.14- 97.916 28,490.86- . glbase_tbam rgonzale Trophy Club Entities Page 99 23:59 07/13/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 06/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,100.00 27.500 2,900.00 533-70025-051-000 Bond Interest Expense 308,310.00 308,310.00 154,155.00 50.000 154,155.00 533-70035-051-000 Bond Principal Payment 1,055,000.00 1,055,000.00 1,055,000.00 Subtotal: 1,367,310.00 1,367,310.00 155,255.00 11.355 1,212,055.00 Program number: 1,367,310.00 1,367,310.00 155,255.00 11.355 1,212,055.00 Department number: Administration 1,367,310.00 1,367,310.00 155,255.00 11.355 1,212,055.00 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 155,255.00 11.355 1,212,055.00