Loading...
HomeMy WebLinkAboutApril 2010 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 45 15:28 05/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 04/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- 1,775.49- 49,117.27- 94.518 2,848.73- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 24,533.64- 1,115,782.99- 99.890 1,230.01- 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 3,139.14- 9,080.85- 139.705 2,580.85 Subtotal: 1,123,513.00- 1,175,479.00- 29,448.27- 1,173,981.11- 99.873 1,497.89- 122-42014-000-000 Fire Permits/Sprinkler 400.00- 3,200.00- 3,200.00 Subtotal: 400.00- 3,200.00- 3,200.00 122-43400-000-000 Fire Inspections 75.00- 600.00- 600.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- 75.00- 17,163.41- 114.805 2,213.41 122-49010-000-000 Interest Income 26.80- 26.80 122-49900-000-000 Miscellaneous Income 100.00- 100.00 Subtotal: 126.80- 126.80 Program number: 1,190,429.00- 1,190,429.00- 29,923.27- 1,194,471.32- 100.340 4,042.32 Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 29,923.27- 1,194,471.32- 100.340 4,042.32 . glbase_tbam rgonzale Trophy Club Entities Page 47 15:28 05/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 04/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 45,895.82 228,563.33 57.339 170,056.67 122-50010-045-000 Overtime 40,298.00 40,298.00 3,292.81 19,520.06 48.439 20,777.94 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 1,233.14 3,750.90 70.032 1,605.10 122-50020-045-000 Retirement 59,532.00 59,532.00 6,404.61 36,008.59 60.486 23,523.41 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,314.82 25,042.12 58.377 17,854.88 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 237.90 1,783.69 58.443 1,268.31 122-50028-045-000 Vision Insurance 493.00 493.00 38.20 288.03 58.424 204.97 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 178.19 1,345.82 52.123 1,236.18 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 2,948.47 16,584.18 62.544 9,931.82 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 689.56 3,878.53 62.547 2,322.47 122-50040-045-000 Unemployment Taxes 549.00 549.00 44.54 1,485.48 270.579 936.48- 122-50045-045-000 Workman's Compensation 9,799.00 9,799.00 2,804.55 9,471.65 96.659 327.35 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 675.00 Subtotal: 610,832.00 610,832.00 67,082.61 361,982.82 59.261 248,849.18 122-55080-045-000 Maintenance & Repairs 5,400.00 5,400.00 9.14 3,171.04 58.723 2,228.96 122-55090-045-000 Vehicle Maintenance 13,500.00 13,500.00 6,276.86 11,413.99 84.548 2,086.01 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 97.91 770.17 22.005 2,729.83 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 67.30 1,164.96 10.591 9,835.04 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 35,697.99 89.245 4,302.01 Subtotal: 74,400.00 74,400.00 6,451.21 52,218.15 70.186 22,181.85 122-60005-045-000 Telephone 100.00 100.00 13.24 26.44 26.440 73.56 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 181.20 1,266.09 51.114 1,210.91 122-60020-045-000 Electricity 16,571.00 16,571.00 707.44 6,203.98 37.439 10,367.02 122-60025-045-000 Water 3,100.00 3,100.00 103.32 621.44 20.046 2,478.56 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 .44 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 33.00 120.52 40.173 179.48 122-60080-045-000 Schools & Training 6,300.00 6,300.00 1,260.00 20.000 5,040.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 445.87 11.147 3,554.13 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 251.99 25.199 748.01 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 402.50 1,043.94 45.251 1,263.06 . glbase_tbam rgonzale Trophy Club Entities Page 48 15:28 05/13/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 04/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 246.12 20.510 953.88 Subtotal: 382,558.00 382,558.00 1,441.14 331,325.64 86.608 51,232.36 122-65005-045-000 Fuel & Lube 15,795.00 12,095.00 725.23 4,091.91 33.831 8,003.09 122-65010-045-000 Uniforms 4,230.00 4,230.00 602.14 1,657.32 39.180 2,572.68 122-65015-045-000 Protective Clothing 4,600.00 4,600.00 656.16 2,199.25 47.810 2,400.75 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 719.55 9.120 7,170.45 122-65085-045-000 Office Supplies 310.00 310.00 8.76 175.36 56.568 134.64 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 140.48 958.28 37.937 1,567.72 122-65105-045-000 Printing 100.00 100.00 22.49 22.490 77.51 Subtotal: 36,951.00 33,251.00 2,132.77 9,824.16 29.545 23,426.84 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 77,107.73 766,504.66 64.389 423,924.34 . glbase_tbam rgonzale Trophy Club Entities Page 46 15:28 05/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: 04/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- 29,923.27- 1,195,671.32- 100.440 5,242.32 . glbase_tbam rgonzale Trophy Club Entities Page 49 15:28 05/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: 04/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 77,107.73 767,603.66 64.481 422,825.34 Expenditures Subtotal ----------- 1,190,429.00 1,190,429.00 77,107.73 767,603.66 64.481 422,825.34 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 47,184.46 428,067.66- 428,067.66 . glbase_tbam rgonzale Trophy Club Entities Page 50 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 04/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- 5,976.81- 276,267.88- 99.429 1,586.12- 135-40015-000-000 Property Taxes/P & I 670.02- 3,223.00- 3,223.00 Subtotal: 277,854.00- 277,854.00- 6,646.83- 279,490.88- 100.589 1,636.88 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 105,658.48- 548,313.93- 32.569 1,135,211.07- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 82,006.17- 465,196.89- 43.944 593,423.11- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 38,659.32- 252,768.49- 33.757 496,011.51- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 19,617.24- 131,872.63- 39.531 201,722.37- 135-47020-000-000 Standby 1,140.00- 1,140.00- 65.00- 418.10- 36.675 721.90- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 2,500.01- 20,750.41- 37.728 34,249.59- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,400.00- 12,377.65- 77.360 3,622.35- 135-47035-000-000 Plumbing Inspections 150.00- 600.00- 600.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 450.00- 1,800.00- 144.000 550.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 3,935.91- 6.560 56,064.09- 135-47270-000-000 Fire Line 525.00- 4,200.00- 4,200.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 197.04- 14,615.15- 40.429 21,534.85- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 918.16- 6,119.33- 39.480 9,380.67- 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- 8,596.37- 64,090.18- 31.823 137,305.82- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 4,201.04- 25,759.74- 43.005 34,140.26- Subtotal: 4,271,056.00- 4,271,056.00- 264,943.83- 1,553,520.15- 36.373 2,717,535.85- 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 195.69- 1,293.27- 64.664 706.73- 135-49015-000-000 Lease/Rental Income 10,164.00- 10,164.00- 5,082.00- 50.000 5,082.00- 135-49030-000-000 Vending Revenue 850.00- 850.00- 300.00- 35.294 550.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- 2,048.00- 28,160.00- 78.222 7,840.00- 135-49900-000-000 Miscellaneous Income 21,100.00- 21,100.00- 1,204.37- 14,703.21- 69.683 6,396.79- 135-49901-000-000 Records Management Revenue 38.00- 196.00- 196.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 6,505.00- 28,640.00- 89.500 3,360.00- 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 242.00- 1,349.95- 21.773 4,850.05- Subtotal: 121,024.00- 121,024.00- 10,233.06- 79,724.43- 65.875 41,299.57- Program number: 4,669,934.00- 4,669,934.00- 281,823.72- 1,912,735.46- 40.959 2,757,198.54- Department number: Revenues 4,669,934.00- 4,669,934.00- 281,823.72- 1,912,735.46- 40.959 2,757,198.54- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 281,823.72- 1,912,735.46- 40.959 2,757,198.54- . glbase_tbam rgonzale Trophy Club Entities Page 51 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 04/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 14,046.70 69,166.79 43.290 90,607.21 135-50010-010-000 Overtime 8,814.00 8,814.00 1,676.80 8,937.85 101.405 123.85- 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 230.00 690.00 46.000 810.00 135-50020-010-000 Retirement 22,360.00 22,360.00 2,115.43 11,149.61 49.864 11,210.39 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 8,863.26 38.311 14,271.74 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 614.18 39.145 954.82 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 112.42 39.865 169.58 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 446.95 39.729 678.05 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 981.21 5,354.43 50.437 5,261.57 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 229.47 1,252.23 50.432 1,230.77 135-50040-010-000 Unemployment Taxes 270.00 270.00 1.74 567.00 210.000 297.00- 135-50045-010-000 Workman's Compensation 5,496.00 5,496.00 1,573.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 103.00 29.429 247.00 Subtotal: 239,884.00 239,884.00 22,288.18 111,602.72 46.524 128,281.28 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 1,628.77 2,524.37 9.709 23,475.63 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 71.76 2,201.42 69.227 978.58 135-55100-010-000 Building Maint & Supplies 750.00 750.00 251.44 259.59 34.612 490.41 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 138.84 187.64 6.470 2,712.36 135-55135-010-000 Lab Analysis 3,350.00 3,350.00 453.40 1,220.40 36.430 2,129.60 Subtotal: 37,680.00 37,680.00 2,544.21 6,393.42 16.968 31,286.58 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 134.10 944.65 46.858 1,071.35 135-60020-010-000 Electricity 195,000.00 195,000.00 10,274.13 51,031.80 26.170 143,968.20 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 451.27 10.745 3,748.73 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 15.02 266.02 9.501 2,533.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 82.50 889.10 27.784 2,310.90 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 53,545.25 363,159.53 26.058 1,030,490.47 135-60245-010-000 Miscellaneous Expenses 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 63.00 613.60 14.610 3,586.40 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 29.97 29.97 1.499 1,970.03 Subtotal: 1,631,316.00 1,614,966.00 64,143.97 423,582.91 26.229 1,191,383.09 . glbase_tbam rgonzale Trophy Club Entities Page 52 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 04/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 919.76 5,115.24 33.618 10,100.76 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 7.57 2,656.13 51.079 2,543.87 135-65035-010-000 Small Tools 2,500.00 2,500.00 143.51 5.740 2,356.49 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 2,500.00 135-65050-010-000 Meter Expense 75,000.00 75,000.00 62,886.00 83.848 12,114.00 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 2,366.81 6,331.10 21.104 23,668.90 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 3,294.14 78,025.44 57.666 57,280.56 135-69005-010-000 Capital Expenses 38,500.00 54,850.00 53,041.56 54,826.56 99.957 23.44 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 53,041.56 179,596.35 77.963 50,764.65 Program number: 2,258,197.00 2,258,197.00 145,312.06 799,200.84 35.391 1,458,996.16 Department number: Water 2,258,197.00 2,258,197.00 145,312.06 799,200.84 35.391 1,458,996.16 . glbase_tbam rgonzale Trophy Club Entities Page 53 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 04/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 19,762.65 96,947.25 56.494 74,659.75 135-50010-020-000 Overtime 10,166.00 10,166.00 1,717.04 10,811.68 106.351 645.68- 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 350.00 1,050.00 41.176 1,500.00 135-50020-020-000 Retirement 24,372.00 24,372.00 2,894.62 15,434.69 63.330 8,937.31 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 16,043.44 58.333 11,459.56 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 1,156.96 58.344 826.04 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 208.32 58.353 148.68 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 622.65 51.974 575.35 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 1,212.12 6,491.73 65.335 3,444.27 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 283.47 1,518.22 65.328 805.78 135-50040-020-000 Unemployment Taxes 270.00 270.00 13.93 756.00 280.000 486.00- 135-50045-020-000 Workman's Compensation 5,991.00 5,991.00 1,714.67 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 30,524.41 159,021.45 60.774 102,638.55 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 2,432.80 10,015.38 49.459 10,234.62 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 503.97 2,113.22 92.200 178.78 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 358.00 25.571 1,042.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,167.89 8,175.29 29.197 19,824.71 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,071.00 6,755.75 32.558 13,994.25 Subtotal: 77,892.00 77,892.00 5,175.66 29,471.17 37.836 48,420.83 135-60005-020-000 Telephone 10.00 3.81 34.65 346.500 24.65- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 239.21 1,683.42 51.386 1,592.58 135-60020-020-000 Electricity 230,000.00 230,000.00 15,694.19 103,204.70 44.872 126,795.30 135-60025-020-000 Water 1,600.00 1,600.00 144.26 909.74 56.859 690.26 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 151.00 11.439 1,169.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 234.50 1,408.70 112.696 158.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 58.20 58.20 11.086 466.80 Subtotal: 247,016.00 247,016.00 16,374.17 114,908.63 46.519 132,107.37 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 384.52 1,605.11 42.519 2,169.89 . glbase_tbam rgonzale Trophy Club Entities Page 54 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 04/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 4,200.00 8,839.03 89.283 1,060.97 135-65035-020-000 Small Tools 1,260.00 1,260.00 279.88 22.213 980.12 135-65040-020-000 Safety Equipment 540.00 540.00 33.15 329.18 60.959 210.82 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 90.46 2,807.99 46.146 3,277.01 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 351.03 1,408.39 10.621 11,851.61 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 5,059.16 16,264.31 42.733 21,795.69 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 57,133.40 334,659.81 40.757 486,457.19 Department number: Wastewater 821,117.00 821,117.00 57,133.40 334,659.81 40.757 486,457.19 . glbase_tbam rgonzale Trophy Club Entities Page 55 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 04/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 15,268.53 74,886.94 56.598 57,426.06 135-50010-021-000 Overtime 14,145.00 14,145.00 839.34 5,568.38 39.366 8,576.62 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 250.00 750.00 62.500 450.00 135-50020-021-000 Retirement 19,575.00 19,575.00 2,169.06 11,597.07 59.244 7,977.93 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 10,524.92 58.332 7,518.08 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 832.16 58.356 593.84 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 129.64 62.932 76.36 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 473.62 51.818 440.38 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 948.99 5,166.59 61.536 3,229.41 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 221.94 1,208.32 61.523 755.68 135-50040-021-000 Unemployment Taxes 203.00 203.00 21.50 567.00 279.310 364.00- 135-50045-021-000 Workman's Compensation 3,147.00 3,147.00 900.69 2,386.07 75.820 760.93 135-50070-021-000 Employee Relations 250.00 250.00 250.00 Subtotal: 204,702.00 204,702.00 22,328.67 117,010.71 57.161 87,691.29 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 3,198.90 31.989 6,801.10 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 39.75 821.29 39.714 1,246.71 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 14,518.00 14,518.00 39.75 4,020.19 27.691 10,497.81 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 250.42 1,298.20 61.468 813.80 135-60020-021-000 Electricity 22,250.00 22,250.00 1,714.11 12,559.53 56.447 9,690.47 135-60025-021-000 Water 750.00 750.00 9.36 37.44 4.992 712.56 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 90.00 3.194 2,728.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 344.25 22.950 1,155.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,011.89 14,456.30 20.452 56,228.70 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 779.27 5,172.48 48.341 5,527.52 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 2,601.00 3,120.00 31.200 6,880.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 56 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 04/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 13.95 .087 16,036.05 Subtotal: 42,655.00 42,655.00 3,380.27 8,865.38 20.784 33,789.62 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 27,760.58 144,352.58 39.815 218,207.42 Department number: Collection 362,560.00 362,560.00 27,760.58 144,352.58 39.815 218,207.42 . glbase_tbam rgonzale Trophy Club Entities Page 57 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 04/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 1,900.00 7,500.00 50.000 7,500.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 117.80 508.40 39.411 781.60 135-50035-026-000 Medicare Taxes 302.00 302.00 27.55 118.90 39.371 183.10 135-50040-026-000 Unemployment Taxes 375.00 375.00 39.90 119.40 31.840 255.60 135-50045-026-000 Workman's Compensation 120.00 120.00 34.34 80.02 66.683 39.98 Subtotal: 17,087.00 17,087.00 2,119.59 8,326.72 48.731 8,760.28 135-55045-026-000 Legal 32,500.00 32,500.00 11,541.95 42,126.91 129.621 9,626.91- 135-55060-026-000 Appraisal 18,874.00 18,374.00 9,932.78 54.059 8,441.22 135-55065-026-000 Tax Admin Fees 2,380.00 2,880.00 2,866.41 99.528 13.59 Subtotal: 53,754.00 53,754.00 11,541.95 54,926.10 102.180 1,172.10- 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 154.00 242.61 40.435 357.39 135-60080-026-000 Schools & Training 5,775.00 5,775.00 1,325.00 22.944 4,450.00 135-60100-026-000 Travel & per diem 12,147.00 11,147.00 40.75 .366 11,106.25 135-60125-026-000 Advertising 820.00 820.00 820.00 135-60245-026-000 Miscellaneous Expenses 300.00 300.00 300.00 Subtotal: 20,792.00 20,792.00 154.00 3,568.36 17.162 17,223.64 135-65085-026-000 Office Supplies 200.00 200.00 7.50 3.750 192.50 Subtotal: 200.00 200.00 7.50 3.750 192.50 Program number: 91,833.00 91,833.00 13,815.54 66,828.68 72.772 25,004.32 Department number: Board of Directors 91,833.00 91,833.00 13,815.54 66,828.68 72.772 25,004.32 . glbase_tbam rgonzale Trophy Club Entities Page 58 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 04/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 30,073.50 141,335.88 56.648 108,163.12 135-50010-027-000 Overtime 1,750.00 1,750.00 279.11 2,525.95 144.340 775.95- 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 4,024.79 20,365.59 61.748 12,616.41 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 13,018.05 58.332 9,298.95 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.52 843.61 58.341 602.39 135-50028-027-000 Vision Insurance 269.00 269.00 22.37 156.56 58.201 112.44 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 753.41 50.194 747.59 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,825.09 9,497.41 61.436 5,961.59 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 426.85 2,221.17 61.443 1,393.83 135-50040-027-000 Unemployment Taxes 304.00 304.00 25.91 758.13 249.385 454.13- 135-50045-027-000 Workman's Compensation 671.00 671.00 192.05 910.15 135.641 239.15- 135-50070-027-000 Employee Relations 838.00 838.00 113.27 13.517 724.73 Subtotal: 333,707.00 333,707.00 38,955.17 195,555.43 58.601 138,151.57 135-55070-027-000 Independent Labor 720.00 720.00 30.00 345.00 47.917 375.00 135-55075-027-000 Records Management 100.00 100.00 186.50 186.500 86.50- 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 30.00 658.37 36.174 1,161.63 135-60005-027-000 Telephone 265.00 265.00 13.99 139.96 52.815 125.04 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 241.61 1,865.76 67.235 909.24 135-60035-027-000 Postage 1,071.00 1,071.00 102.29 1,029.65 96.139 41.35 135-60040-027-000 Service Charges & Fees 50.00 50.00- 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 203.40 256.75 73.357 93.25 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 1,233.66 73.739 439.34 135-60075-027-000 Meetings 961.00 961.00 891.26 353.04 36.737 607.96 135-60080-027-000 Schools & Training 2,715.00 2,715.00 726.00 26.740 1,989.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 14.11 1,085.07 51.818 1,008.93 135-60115-027-000 Elections 3,500.00 3,500.00 2,240.99 64.028 1,259.01 135-60125-027-000 Advertising 650.00 650.00 1,078.91 1,658.48 255.151 1,008.48- 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-60350-027-000 Transfer to Debt Service 47.98 47.98 47.98- 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 75.99 4.342 1,674.01 Subtotal: 27,904.00 27,904.00 2,593.55 10,763.33 38.573 17,140.67 135-65085-027-000 Office Supplies 2,450.00 2,450.00 197.79 1,227.18 50.089 1,222.82 135-65105-027-000 Printing 515.00 515.00 84.65 16.437 430.35 Subtotal: 2,965.00 2,965.00 197.79 1,311.83 44.244 1,653.17 . glbase_tbam rgonzale Trophy Club Entities Page 59 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 04/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 41,776.51 208,288.96 56.848 158,107.04 Department number: Manager's Office 366,396.00 366,396.00 41,776.51 208,288.96 56.848 158,107.04 . glbase_tbam rgonzale Trophy Club Entities Page 60 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 04/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 2,965.20 14,543.58 56.594 11,154.42 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 393.19 2,033.89 60.659 1,319.11 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 1,556.68 58.324 1,112.32 135-50027-028-000 Dental Insurance 155.00 155.00 12.89 90.41 58.329 64.59 135-50028-028-000 Vision Insurance 30.00 30.00 2.50 17.40 58.000 12.60 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 94.99 51.625 89.01 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 183.84 985.37 62.090 601.63 135-50035-028-000 Medicare Taxes 371.00 371.00 43.00 230.43 62.111 140.57 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 19.46 58.38 85.853 9.62 135-50070-028-000 Employee Relations 1,625.00 1,625.00 11.25 1,119.90 68.917 505.10 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 115.50 7.700 1,384.50 135-50994-028-000 Employee Assistance Program 628.60 628.60- 135-50995-028-000 Flexible Benefits Admin Fee 229.44 1,066.93 1,066.93- Subtotal: 37,372.00 37,372.00 4,096.72 22,734.06 60.832 14,637.94 135-60005-028-000 Telephone 26.00 26.00 1.20 2.66 10.231 23.34 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 16.07 112.19 53.424 97.81 135-60035-028-000 Postage 102.00 102.00 41.48 84.83 83.167 17.17 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 440.00 135-60070-028-000 Dues & Memberships 504.00 504.00 115.98 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 165.00 17.188 795.00 Subtotal: 2,919.00 2,919.00 174.73 643.16 22.034 2,275.84 135-65085-028-000 Office Supplies 412.00 412.00 7.10 26.94 6.539 385.06 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 7.10 26.94 5.161 495.06 Program number: 40,813.00 40,813.00 4,278.55 23,404.16 57.345 17,408.84 Department number: Human Resources 40,813.00 40,813.00 4,278.55 23,404.16 57.345 17,408.84 . glbase_tbam rgonzale Trophy Club Entities Page 61 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 04/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 133,457.00 16,415.88 70,212.76 52.611 63,244.24 135-50010-029-000 Overtime 2,000.00 3,683.00 362.53 4,269.64 115.928 586.64- 135-50016-029-000 Longevity 1,259.00 1,259.00 870.00 69.102 389.00 135-50020-029-000 Retirement 17,996.00 17,996.00 2,224.78 10,539.16 58.564 7,456.84 135-50026-029-000 Medical Insurance 10,550.00 10,550.00 952.73 6,420.52 60.858 4,129.48 135-50027-029-000 Dental Insurance 765.00 765.00 63.76 413.82 54.094 351.18 135-50028-029-000 Vision Insurance 127.00 127.00 10.57 67.66 53.276 59.34 135-50029-029-000 Life Insurance & Other 830.00 830.00 61.56 384.64 46.342 445.36 135-50030-029-000 Social Security Taxes 8,265.00 8,265.00 980.25 4,682.33 56.653 3,582.67 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 229.27 1,095.10 56.653 837.90 135-50040-029-000 Unemployment Taxes 135.00 135.00 378.75 280.556 243.75- 135-50045-029-000 Workman's Compensation 365.00 365.00 104.47 313.41 85.866 51.59 135-50060-029-000 Pre-emp Physicals/Testing 32.00 31.47 98.344 .53 Subtotal: 179,397.00 179,397.00 21,405.80 99,679.26 55.564 79,717.74 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 2,705.00 105.00 3.882 2,600.00 Subtotal: 40,000.00 40,105.00 33,696.00 84.019 6,409.00 135-60005-029-000 Telephone 103.00 103.00 13.05 59.36 57.631 43.64 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 36.06 252.16 49.834 253.84 135-60035-029-000 Postage 900.00 900.00 54.76 397.68 44.187 502.32 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 40.00 994.35 73.060 366.65 135-60075-029-000 Meetings 66.00 66.00 11.00 44.00 66.667 22.00 135-60080-029-000 Schools & Training 1,370.00 1,370.00 523.55 38.215 846.45 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 371.17 566.00 34.618 1,069.00 135-60245-029-000 Miscellaneous Expenses 1,000.00 895.00 53.88 53.88 6.020 841.12 135-60360-029-000 Furniture/Equipment < $5000 343.00 252.49 73.612 90.51 Subtotal: 7,266.00 7,504.00 579.92 3,201.67 42.666 4,302.33 135-65085-029-000 Office Supplies 800.00 457.00 403.04 88.193 53.96 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,357.00 403.04 29.701 953.96 Program number: 228,363.00 228,363.00 21,985.72 136,979.97 59.983 91,383.03 Department number: Finance 228,363.00 228,363.00 21,985.72 136,979.97 59.983 91,383.03 . glbase_tbam rgonzale Trophy Club Entities Page 62 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 04/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 6,794.13 33,323.59 56.593 25,559.41 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 900.88 4,674.09 60.774 3,016.91 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.68 2,874.81 58.336 2,053.19 135-50027-033-000 Dental Insurance 310.00 310.00 25.81 180.66 58.277 129.34 135-50028-033-000 Vision Insurance 60.00 60.00 4.97 34.78 57.967 25.22 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 198.80 51.771 185.20 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 421.23 2,264.76 61.744 1,403.24 135-50035-033-000 Medicare Taxes 858.00 858.00 98.51 529.62 61.727 328.38 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 44.65 133.95 85.865 22.05 Subtotal: 77,284.00 77,344.00 8,729.26 44,741.54 57.847 32,602.46 135-55030-033-000 Software & Support 56,190.00 56,130.00 8,114.83 27,542.70 49.069 28,587.30 135-55070-033-000 Independent Labor 1,464.00 1,464.00 403.13 1,215.63 83.035 248.37 Subtotal: 57,654.00 57,594.00 8,517.96 28,758.33 49.933 28,835.67 135-60005-033-000 Telephone 20,520.00 20,520.00 499.36 8,395.26 40.913 12,124.74 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 78.52 523.95 48.469 557.05 135-60035-033-000 Postage 100.00 100.00 1.73 1.730 98.27 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 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 331.82 331.82 22.665 1,132.18 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 920.70 10,960.87 40.416 16,159.13 135-65055-033-000 Hardware 36,682.00 36,682.00 2,256.18 25,519.14 69.569 11,162.86 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 392.65 1,730.99 35.727 3,114.01 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 2,648.83 27,379.38 65.303 14,547.62 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 1,639.74 47.529 1,810.26 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 1,639.74 5.401 28,721.26 Program number: 234,346.00 234,346.00 21,090.04 113,479.86 48.424 120,866.14 . glbase_tbam rgonzale Trophy Club Entities Page 63 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 04/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 21,090.04 113,479.86 48.424 120,866.14 . glbase_tbam rgonzale Trophy Club Entities Page 64 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 04/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 414.32 1,721.64 26.105 4,873.36 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 701.71 4,763.84 52.932 4,236.16 Subtotal: 20,400.00 15,595.00 1,116.03 6,485.48 41.587 9,109.52 135-60020-037-000 Electricity 19,900.00 19,900.00 1,254.39 8,959.11 45.021 10,940.89 135-60025-037-000 Water 1,030.00 1,030.00 37.00 217.54 21.120 812.46 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 7,689.57 58.334 5,492.43 135-60055-037-000 Insurance 29,601.00 34,406.00 100.00 34,504.71 100.287 98.71- Subtotal: 63,713.00 68,518.00 2,489.90 51,370.93 74.974 17,147.07 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 119.07 1,092.52 54.626 907.48 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 61.66 490.69 49.069 509.31 Subtotal: 3,000.00 3,000.00 180.73 1,583.21 52.774 1,416.79 Program number: 87,113.00 87,113.00 3,786.66 59,439.62 68.233 27,673.38 Department number: Facilities Maintenance 87,113.00 87,113.00 3,786.66 59,439.62 68.233 27,673.38 . glbase_tbam rgonzale Trophy Club Entities Page 65 15:28 05/13/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 04/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 9,129.18 44,689.13 56.399 34,548.87 135-50010-038-000 Overtime 750.00 750.00 178.49 874.81 116.641 124.81- 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 1,234.21 6,346.56 60.896 4,075.44 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 6,226.92 58.332 4,448.08 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 482.16 58.373 343.84 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 77.56 58.316 55.44 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 289.31 51.848 268.69 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 568.75 3,016.20 61.305 1,903.80 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 133.02 705.40 61.286 445.60 135-50040-038-000 Unemployment Taxes 135.00 135.00 23.27 378.00 280.000 243.00- 135-50045-038-000 Workman's Compensation 212.00 212.00 60.68 182.04 85.868 29.96 Subtotal: 109,205.00 109,205.00 12,338.45 63,453.09 58.105 45,751.91 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 792.57 5,653.49 51.395 5,346.51 Subtotal: 11,800.00 11,800.00 792.57 5,653.49 47.911 6,146.51 135-60005-038-000 Telephone 75.00 75.00 10.31 51.33 68.440 23.67 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 32.13 224.39 53.426 195.61 135-60035-038-000 Postage 15,820.00 15,820.00 1,199.44 8,308.69 52.520 7,511.31 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 1,011.17 6,859.45 45.730 8,140.55 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 800.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 2,253.05 32,617.95 61.554 20,373.05 135-65085-038-000 Office Supplies 700.00 700.00 8.66 380.05 54.293 319.95 135-65105-038-000 Printing 4,500.00 4,500.00 4,500.00 Subtotal: 5,200.00 5,200.00 8.66 380.05 7.309 4,819.95 Program number: 179,196.00 179,196.00 15,392.73 102,104.58 56.979 77,091.42 Department number: Utility Billing 179,196.00 179,196.00 15,392.73 102,104.58 56.979 77,091.42 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 352,331.79 1,988,739.06 42.586 2,681,194.94 Fund number: 135 MUD 1 O&M CONSOLIDATED 70,508.07 76,003.60 76,003.60- . glbase_tbam rgonzale Trophy Club Entities Page 76 15:28 05/13/10 Budget Summary with Amendment Fund: 315 MUD 1 CIP FIRE STATION Department: Revenues Program: Period Ending: 04/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 243.92- 1,880.31- 1,880.31 Subtotal: 243.92- 1,880.31- 1,880.31 Program number: 243.92- 1,880.31- 1,880.31 Department number: Revenues 243.92- 1,880.31- 1,880.31 Revenues Subtotal ----------- 243.92- 1,880.31- 1,880.31 Fund number: 315 MUD 1 CIP FIRE STATION 243.92- 1,880.31- 1,880.31 . glbase_tbam rgonzale Trophy Club Entities Page 96 15:28 05/13/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 04/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- 15,978.75- 705,738.29- 100.345 2,428.29 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 2,072.42- 6,098.52- 67.761 2,901.48- Subtotal: 712,310.00- 712,310.00- 18,051.17- 711,836.81- 99.934 473.19- 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 13,800.00- 230,000.00- 66.667 115,000.00- Subtotal: 345,000.00- 345,000.00- 13,800.00- 230,000.00- 66.667 115,000.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 3,317.66- 3,832.42- 191.621 1,832.42 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- 1,000.00 Subtotal: 310,000.00- 310,000.00- 4,317.66- 312,832.42- 100.914 2,832.42 Program number: 1,367,310.00- 1,367,310.00- 36,168.83- 1,254,669.23- 91.762 112,640.77- Department number: Revenues 1,367,310.00- 1,367,310.00- 36,168.83- 1,254,669.23- 91.762 112,640.77- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 36,168.83- 1,254,669.23- 91.762 112,640.77- . glbase_tbam rgonzale Trophy Club Entities Page 97 15:28 05/13/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 04/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 500.00 800.00 20.000 3,200.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 500.00 154,955.00 11.333 1,212,355.00 Program number: 1,367,310.00 1,367,310.00 500.00 154,955.00 11.333 1,212,355.00 Department number: Administration 1,367,310.00 1,367,310.00 500.00 154,955.00 11.333 1,212,355.00 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 500.00 154,955.00 11.333 1,212,355.00