Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
May 2010 Budget Summary
. glbase_tbam rgonzale Trophy Club Entities Page 45 19:40 06/08/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 05/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- 105.68- 49,222.95- 94.721 2,743.05- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 5,015.16- 1,120,798.15- 100.339 3,785.15 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 444.64- 9,525.49- 146.546 3,025.49 Subtotal: 1,123,513.00- 1,175,479.00- 5,565.48- 1,179,546.59- 100.346 4,067.59 122-42014-000-000 Fire Permits/Sprinkler 400.00- 3,600.00- 3,600.00 Subtotal: 400.00- 3,600.00- 3,600.00 122-43400-000-000 Fire Inspections 75.00- 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- 75.00- 17,238.41- 115.307 2,288.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- 6,040.48- 1,200,511.80- 100.847 10,082.80 Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 6,040.48- 1,200,511.80- 100.847 10,082.80 . glbase_tbam rgonzale Trophy Club Entities Page 47 19:40 06/08/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 05/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 30,157.81 258,721.14 64.904 139,898.86 122-50010-045-000 Overtime 40,298.00 40,298.00 3,204.00 22,724.06 56.390 17,573.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 603.70 4,354.60 81.303 1,001.40 122-50020-045-000 Retirement 59,532.00 59,532.00 4,233.58 40,242.17 67.598 19,289.83 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,292.09 28,334.21 66.052 14,562.79 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 236.24 2,019.93 66.184 1,032.07 122-50028-045-000 Vision Insurance 493.00 493.00 37.94 325.97 66.120 167.03 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 178.19 1,524.01 59.024 1,057.99 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 1,929.96 18,514.14 69.823 8,001.86 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 451.35 4,329.88 69.826 1,871.12 122-50040-045-000 Unemployment Taxes 549.00 549.00 42.81 1,528.29 278.377 979.29- 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 675.00 Subtotal: 610,832.00 610,832.00 44,367.67 406,350.49 66.524 204,481.51 122-55080-045-000 Maintenance & Repairs 5,400.00 5,400.00 167.00 3,338.04 61.816 2,061.96 122-55090-045-000 Vehicle Maintenance 13,500.00 13,500.00 95.00 11,508.99 85.252 1,991.01 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 2.09 772.26 22.065 2,727.74 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 217.20 1,382.16 12.565 9,617.84 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 2,690.00 38,387.99 95.970 1,612.01 Subtotal: 74,400.00 74,400.00 3,171.29 55,389.44 74.448 19,010.56 122-60005-045-000 Telephone 100.00 100.00 6.26 32.70 32.700 67.30 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 1,266.09 51.114 1,210.91 122-60020-045-000 Electricity 16,571.00 16,571.00 616.44 6,820.42 41.159 9,750.58 122-60025-045-000 Water 3,100.00 3,100.00 133.52 754.96 24.354 2,345.04 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 50.00 1,310.00 20.794 4,990.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 213.45 465.44 46.544 534.56 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 37.50 1,081.44 46.876 1,225.56 . glbase_tbam rgonzale Trophy Club Entities Page 48 19:40 06/08/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 05/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 145.95 392.07 32.673 807.93 Subtotal: 382,558.00 382,558.00 1,203.12 332,528.76 86.922 50,029.24 122-65005-045-000 Fuel & Lube 15,795.00 12,095.00 693.20 4,785.11 39.563 7,309.89 122-65010-045-000 Uniforms 4,230.00 4,230.00 52.88 1,710.20 40.430 2,519.80 122-65015-045-000 Protective Clothing 4,600.00 4,600.00 1,641.24 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 1,893.90 2,613.45 33.124 5,276.55 122-65085-045-000 Office Supplies 310.00 310.00 175.36 56.568 134.64 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 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 4,281.22 14,105.38 42.421 19,145.62 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 53,023.30 819,527.96 68.843 370,901.04 . glbase_tbam rgonzale Trophy Club Entities Page 46 19:40 06/08/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: 05/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- 6,040.48- 1,201,711.80- 100.948 11,282.80 . glbase_tbam rgonzale Trophy Club Entities Page 49 19:40 06/08/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: 05/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 53,023.30 820,626.96 68.935 369,802.04 Expenditures Subtotal ----------- 1,190,429.00 1,190,429.00 53,023.30 820,626.96 68.935 369,802.04 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 46,982.82 381,084.84- 381,084.84 . glbase_tbam rgonzale Trophy Club Entities Page 50 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 05/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,247.15- 277,515.03- 99.878 338.97- 135-40015-000-000 Property Taxes/P & I 114.04- 3,337.04- 3,337.04 Subtotal: 277,854.00- 277,854.00- 1,361.19- 280,852.07- 101.079 2,998.07 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 121,822.42- 670,136.35- 39.806 1,013,388.65- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 87,377.55- 552,574.44- 52.198 506,045.56- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 49,651.53- 302,420.02- 40.388 446,359.98- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 20,878.78- 152,751.41- 45.789 180,843.59- 135-47020-000-000 Standby 1,140.00- 1,140.00- 71.00- 489.10- 42.904 650.90- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 3,959.47- 24,709.88- 44.927 30,290.12- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,253.00- 13,630.65- 85.192 2,369.35- 135-47035-000-000 Plumbing Inspections 50.00- 650.00- 650.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 150.00- 1,950.00- 156.000 700.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 4,681.82- 8,617.73- 14.363 51,382.27- 135-47270-000-000 Fire Line 525.00- 4,725.00- 4,725.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 162.72- 14,777.87- 40.879 21,372.13- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 886.96- 7,006.29- 45.202 8,493.71- 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- 13,267.94- 77,358.12- 38.411 124,037.88- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 6,919.31- 32,679.05- 54.556 27,220.95- Subtotal: 4,271,056.00- 4,271,056.00- 311,657.50- 1,865,177.65- 43.670 2,405,878.35- 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 207.39- 1,500.66- 75.033 499.34- 135-49015-000-000 Lease/Rental Income 10,164.00- 5,082.00 135-49016-000-000 Cell Tower Revenue 10,164.00- 6,776.00- 6,776.00- 66.667 3,388.00- 135-49018-000-000 Building Rent Income 7,000.00- 4,666.64- 4,666.64- 66.666 2,333.36- 135-49030-000-000 Vending Revenue 850.00- 850.00- 350.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- 4,352.00- 32,512.00- 90.311 3,488.00- 135-49900-000-000 Miscellaneous Income 21,100.00- 14,100.00- 4,083.31 10,619.90- 75.318 3,480.10- 135-49901-000-000 Records Management Revenue 80.00- 276.00- 276.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 5,485.00- 34,125.00- 106.641 2,125.00 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 144.19- 1,494.14- 24.099 4,705.86- Subtotal: 121,024.00- 121,024.00- 12,895.91- 92,620.34- 76.531 28,403.66- Program number: 4,669,934.00- 4,669,934.00- 325,914.60- 2,238,650.06- 47.938 2,431,283.94- Department number: Revenues 4,669,934.00- 4,669,934.00- 325,914.60- 2,238,650.06- 47.938 2,431,283.94- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 325,914.60- 2,238,650.06- 47.938 2,431,283.94- . glbase_tbam rgonzale Trophy Club Entities Page 51 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 05/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 78,664.31 49.235 81,109.69 135-50010-010-000 Overtime 8,814.00 8,814.00 618.68 9,556.53 108.424 742.53- 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 805.00 53.667 695.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,356.65 12,506.26 55.931 9,853.74 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 10,129.44 43.784 13,005.56 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 701.92 44.737 867.08 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 128.48 45.560 153.52 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 510.80 45.404 614.20 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 626.44 5,980.87 56.338 4,635.13 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 146.51 1,398.74 56.333 1,084.26 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 103.00 29.429 247.00 Subtotal: 239,884.00 239,884.00 13,794.63 125,397.35 52.274 114,486.65 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 2,524.37 9.709 23,475.63 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 135.00 1,355.40 40.460 1,994.60 Subtotal: 37,680.00 37,680.00 135.00 6,528.42 17.326 31,151.58 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 944.65 46.858 1,071.35 135-60020-010-000 Electricity 195,000.00 195,000.00 11,557.29 62,589.09 32.097 132,410.91 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 1,015.10 1,466.37 34.914 2,733.63 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 111.00 377.02 13.465 2,422.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 99.10 988.20 30.881 2,211.80 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 68,848.94 432,008.47 30.998 961,641.53 135-60245-010-000 Miscellaneous Expenses 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 52.70- 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 81,578.73 505,161.64 31.280 1,109,804.36 . glbase_tbam rgonzale Trophy Club Entities Page 52 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 05/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 628.19 5,743.43 37.746 9,472.57 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 1,353.79 4,009.92 77.114 1,190.08 135-65035-010-000 Small Tools 2,500.00 2,500.00 53.35 196.86 7.874 2,303.14 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 280.52 280.52 11.221 2,219.48 135-65050-010-000 Meter Expense 75,000.00 75,000.00 10,489.50 73,375.50 97.834 1,624.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 675.89 7,006.99 23.357 22,993.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 13,481.24 91,506.68 67.629 43,799.32 135-69005-010-000 Capital Expenses 38,500.00 54,850.00 14,500.00 69,326.56 126.393 14,476.56- 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 14,500.00 194,096.35 84.257 36,264.65 Program number: 2,258,197.00 2,258,197.00 123,489.60 922,690.44 40.860 1,335,506.56 Department number: Water 2,258,197.00 2,258,197.00 123,489.60 922,690.44 40.860 1,335,506.56 . glbase_tbam rgonzale Trophy Club Entities Page 53 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 05/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,200.56 110,147.81 64.186 61,459.19 135-50010-020-000 Overtime 10,166.00 10,166.00 1,228.10 12,039.78 118.432 1,873.78- 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,225.00 48.039 1,325.00 135-50020-020-000 Retirement 24,372.00 24,372.00 1,936.44 17,371.13 71.275 7,000.87 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 18,335.36 66.667 9,167.64 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 1,322.24 66.679 660.76 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 238.08 66.689 118.92 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 711.60 59.399 486.40 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 764.12 7,255.85 73.026 2,680.15 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 178.70 1,696.92 73.017 627.08 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 20,058.83 179,080.28 68.440 82,579.72 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 10,015.38 49.459 10,234.62 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 39.75 2,152.97 93.934 139.03 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,726.45 9,901.74 35.363 18,098.26 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,252.25 8,008.00 38.593 12,742.00 Subtotal: 77,892.00 77,892.00 3,018.45 32,489.62 41.711 45,402.38 135-60005-020-000 Telephone 10.00 2.21 36.86 368.600 26.86- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 1,683.42 51.386 1,592.58 135-60020-020-000 Electricity 230,000.00 230,000.00 14,975.44 118,180.14 51.383 111,819.86 135-60025-020-000 Water 1,600.00 1,600.00 228.50 1,138.24 71.140 461.76 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 167.00 1,575.70 126.056 325.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 29.97 88.17 16.794 436.83 Subtotal: 247,016.00 247,016.00 15,403.12 130,311.75 52.754 116,704.25 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 313.64 1,918.75 50.828 1,856.25 . glbase_tbam rgonzale Trophy Club Entities Page 54 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 05/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 900.00 9,739.03 98.374 160.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 24.70 353.88 65.533 186.12 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 665.40 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 205.88 1,614.27 12.174 11,645.73 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 2,109.62 18,373.93 48.276 19,686.07 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 40,590.02 375,249.83 45.700 445,867.17 Department number: Wastewater 821,117.00 821,117.00 40,590.02 375,249.83 45.700 445,867.17 . glbase_tbam rgonzale Trophy Club Entities Page 55 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 05/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 85,067.30 64.292 47,245.70 135-50010-021-000 Overtime 14,145.00 14,145.00 741.57 6,309.95 44.609 7,835.05 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 875.00 72.917 325.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,464.83 13,061.90 66.727 6,513.10 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 12,028.48 66.666 6,014.52 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 951.04 66.693 474.96 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 148.16 71.922 57.84 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 541.28 59.221 372.72 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 619.71 5,786.30 68.917 2,609.70 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 144.94 1,353.26 68.903 610.74 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 250.00 Subtotal: 204,702.00 204,702.00 14,985.03 131,995.74 64.482 72,706.26 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 163.35 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 163.35 4,183.54 28.816 10,334.46 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 78.47 1,376.67 65.183 735.33 135-60020-021-000 Electricity 22,250.00 22,250.00 1,671.57 14,231.10 63.960 8,018.90 135-60025-021-000 Water 750.00 750.00 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 32.00 376.25 25.083 1,123.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 1,782.04 16,238.34 22.973 54,446.66 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 730.77 5,903.25 55.171 4,796.75 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 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 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 05/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 165.00 178.95 1.115 15,871.05 Subtotal: 42,655.00 42,655.00 895.77 9,761.15 22.884 32,893.85 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 17,826.19 162,178.77 44.732 200,381.23 Department number: Collection 362,560.00 362,560.00 17,826.19 162,178.77 44.732 200,381.23 . glbase_tbam rgonzale Trophy Club Entities Page 57 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 05/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,300.00 8,800.00 58.667 6,200.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 80.60 589.00 45.659 701.00 135-50035-026-000 Medicare Taxes 302.00 302.00 18.85 137.75 45.613 164.25 135-50040-026-000 Unemployment Taxes 375.00 375.00 27.30 146.70 39.120 228.30 135-50045-026-000 Workman's Compensation 120.00 120.00 80.02 66.683 39.98 Subtotal: 17,087.00 17,087.00 1,426.75 9,753.47 57.081 7,333.53 135-55045-026-000 Legal 32,500.00 32,500.00 3,936.25 46,063.16 141.733 13,563.16- 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,984.00 2,866.41 96.059 117.59 Subtotal: 53,754.00 53,858.00 3,936.25 58,862.35 109.292 5,004.35- 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 48.30 290.91 48.485 309.09 135-60080-026-000 Schools & Training 5,775.00 5,775.00 2,070.00 3,395.00 58.788 2,380.00 135-60100-026-000 Travel & per diem 12,147.00 11,147.00 40.75 .366 11,106.25 135-60115-026-000 Elections 44.64- 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,073.66 5,642.02 27.272 15,045.98 135-65085-026-000 Office Supplies 200.00 200.00 5.40 12.90 6.450 187.10 Subtotal: 200.00 200.00 5.40 12.90 6.450 187.10 Program number: 91,833.00 91,833.00 7,442.06 74,270.74 80.876 17,562.26 Department number: Board of Directors 91,833.00 91,833.00 7,442.06 74,270.74 80.876 17,562.26 . glbase_tbam rgonzale Trophy Club Entities Page 58 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 05/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,536.82 161,872.70 64.879 87,626.30 135-50010-027-000 Overtime 1,750.00 1,750.00 24.51 2,550.46 145.741 800.46- 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,726.42 23,092.01 70.014 9,889.99 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 14,877.77 66.666 7,439.23 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.50 964.11 66.674 481.89 135-50028-027-000 Vision Insurance 269.00 269.00 22.36 178.92 66.513 90.08 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 858.67 57.207 642.33 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,218.07 10,715.48 69.315 4,743.52 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 284.86 2,506.03 69.323 1,108.97 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 865.47 978.74 116.795 140.74- Subtotal: 333,707.00 333,707.00 27,763.99 223,319.42 66.921 110,387.58 135-55070-027-000 Independent Labor 720.00 720.00 60.00 405.00 56.250 315.00 135-55075-027-000 Records Management 100.00 100.00 202.24 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 262.24 920.61 50.583 899.39 135-60005-027-000 Telephone 265.00 265.00 28.28 168.24 63.487 96.76 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 40.46 1,906.22 68.693 868.78 135-60035-027-000 Postage 1,071.00 1,071.00 2.02- 1,027.63 95.951 43.37 135-60040-027-000 Service Charges & Fees 50.00 50.00- 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 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 11.00 364.04 37.881 596.96 135-60080-027-000 Schools & Training 2,715.00 2,715.00 345.00 1,071.00 39.448 1,644.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 5.00 1,090.07 52.057 1,003.93 135-60115-027-000 Elections 3,500.00 3,500.00 421.58 2,662.57 76.073 837.43 135-60125-027-000 Advertising 650.00 650.00 878.53 2,537.01 390.309 1,887.01- 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- 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 817.50 893.49 51.057 856.51 Subtotal: 27,904.00 27,904.00 2,545.33 13,308.66 47.694 14,595.34 135-65085-027-000 Office Supplies 2,450.00 2,450.00 282.85 1,510.03 61.634 939.97 135-65105-027-000 Printing 515.00 515.00 84.65 16.437 430.35 Subtotal: 2,965.00 2,965.00 282.85 1,594.68 53.783 1,370.32 . glbase_tbam rgonzale Trophy Club Entities Page 59 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 05/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 30,854.41 239,143.37 65.269 127,252.63 Department number: Manager's Office 366,396.00 366,396.00 30,854.41 239,143.37 65.269 127,252.63 . glbase_tbam rgonzale Trophy Club Entities Page 60 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 05/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 16,520.38 64.287 9,177.62 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.12 2,296.01 68.476 1,056.99 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 1,779.06 66.656 889.94 135-50027-028-000 Dental Insurance 155.00 155.00 12.90 103.31 66.652 51.69 135-50028-028-000 Vision Insurance 30.00 30.00 2.48 19.88 66.267 10.12 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 108.56 59.000 75.44 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 122.56 1,107.93 69.813 479.07 135-50035-028-000 Medicare Taxes 371.00 371.00 28.66 259.09 69.836 111.91 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 11.00 1,130.90 69.594 494.10 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 29.09 144.59 9.639 1,355.41 135-50994-028-000 Employee Assistance Program 99.40 728.00 728.00- 135-50995-028-000 Flexible Benefits Admin Fee 88.81 1,155.74 1,155.74- Subtotal: 37,372.00 37,372.00 2,869.77 25,603.83 68.511 11,768.17 135-60005-028-000 Telephone 26.00 26.00 1.02 3.68 14.154 22.32 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 112.19 53.424 97.81 135-60035-028-000 Postage 102.00 102.00 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 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 128.00 293.00 30.521 667.00 Subtotal: 2,919.00 2,919.00 129.02 772.18 26.454 2,146.82 135-65085-028-000 Office Supplies 412.00 412.00 26.94 6.539 385.06 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 26.94 5.161 495.06 Program number: 40,813.00 40,813.00 2,998.79 26,402.95 64.692 14,410.05 Department number: Human Resources 40,813.00 40,813.00 2,998.79 26,402.95 64.692 14,410.05 . glbase_tbam rgonzale Trophy Club Entities Page 61 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 05/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 7,936.56 78,149.32 58.558 55,307.68 135-50010-029-000 Overtime 2,000.00 3,683.00 149.89 4,419.53 119.998 736.53- 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 1,056.72 11,595.88 64.436 6,400.12 135-50026-029-000 Medical Insurance 10,550.00 10,550.00 503.37 6,923.89 65.629 3,626.11 135-50027-029-000 Dental Insurance 765.00 765.00 55.95 469.77 61.408 295.23 135-50028-029-000 Vision Insurance 127.00 127.00 8.07 75.73 59.630 51.27 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 430.77 51.900 399.23 135-50030-029-000 Social Security Taxes 8,265.00 8,265.00 449.32 5,131.65 62.089 3,133.35 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 105.07 1,200.17 62.088 732.83 135-50040-029-000 Unemployment Taxes 135.00 135.00 2.46 381.21 282.378 246.21- 135-50045-029-000 Workman's Compensation 365.00 365.00 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 10,313.54 109,992.80 61.313 69,404.20 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 1,137.50 1,242.50 45.933 1,462.50 Subtotal: 40,000.00 40,105.00 1,137.50 34,833.50 86.856 5,271.50 135-60005-029-000 Telephone 103.00 103.00 13.69 73.05 70.922 29.95 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 252.16 49.834 253.84 135-60035-029-000 Postage 900.00 900.00 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 994.35 73.060 366.65 135-60075-029-000 Meetings 66.00 66.00 11.00 55.00 83.333 11.00 135-60080-029-000 Schools & Training 1,370.00 1,370.00 47.50 571.05 41.682 798.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 15.99 581.99 35.596 1,053.01 135-60245-029-000 Miscellaneous Expenses 1,000.00 895.00 53.88 6.020 841.12 135-60360-029-000 Furniture/Equipment < $5000 343.00 152.75 405.24 118.146 62.24- Subtotal: 7,266.00 7,504.00 240.93 3,442.60 45.877 4,061.40 135-65085-029-000 Office Supplies 800.00 457.00 18.58 421.62 92.258 35.38 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,357.00 18.58 421.62 31.070 935.38 Program number: 228,363.00 228,363.00 11,710.55 148,690.52 65.111 79,672.48 Department number: Finance 228,363.00 228,363.00 11,710.55 148,690.52 65.111 79,672.48 . glbase_tbam rgonzale Trophy Club Entities Page 62 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 05/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 37,853.01 64.285 21,029.99 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.60 5,274.69 68.583 2,416.31 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.69 3,285.50 66.670 1,642.50 135-50027-033-000 Dental Insurance 310.00 310.00 25.82 206.48 66.606 103.52 135-50028-033-000 Vision Insurance 60.00 60.00 4.95 39.73 66.217 20.27 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 227.20 59.167 156.80 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 280.81 2,545.57 69.399 1,122.43 135-50035-033-000 Medicare Taxes 858.00 858.00 65.67 595.29 69.381 262.71 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.36 50,687.90 65.536 26,656.10 135-55030-033-000 Software & Support 56,190.00 56,130.00 3,498.88 31,041.58 55.303 25,088.42 135-55070-033-000 Independent Labor 1,464.00 1,464.00 1,215.63 83.035 248.37 Subtotal: 57,654.00 57,594.00 3,498.88 32,257.21 56.008 25,336.79 135-60005-033-000 Telephone 20,520.00 20,520.00 768.42 9,163.68 44.657 11,356.32 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 2.34 526.29 48.685 554.71 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 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 9.75 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 780.51 11,741.38 43.294 15,378.62 135-65055-033-000 Hardware 36,682.00 36,682.00 302.10 25,821.24 70.392 10,860.76 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 178.70 1,909.69 39.416 2,935.31 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 480.80 27,860.18 66.449 14,066.82 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 1,913.03 55.450 1,536.97 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,913.03 6.301 28,447.97 Program number: 234,346.00 234,346.00 10,979.84 124,459.70 53.109 109,886.30 . glbase_tbam rgonzale Trophy Club Entities Page 63 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 05/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,979.84 124,459.70 53.109 109,886.30 . glbase_tbam rgonzale Trophy Club Entities Page 64 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 05/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 1,180.98 2,902.62 44.012 3,692.38 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 673.26 5,437.10 60.412 3,562.90 Subtotal: 20,400.00 15,595.00 1,854.24 8,339.72 53.477 7,255.28 135-60020-037-000 Electricity 19,900.00 19,900.00 921.94 9,881.05 49.654 10,018.95 135-60025-037-000 Water 1,030.00 1,030.00 51.66 269.20 26.136 760.80 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 8,788.08 66.667 4,393.92 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,072.11 53,443.04 77.999 15,074.96 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 124.52 1,217.04 60.852 782.96 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 490.69 49.069 509.31 Subtotal: 3,000.00 3,000.00 124.52 1,707.73 56.924 1,292.27 Program number: 87,113.00 87,113.00 4,050.87 63,490.49 72.883 23,622.51 Department number: Facilities Maintenance 87,113.00 87,113.00 4,050.87 63,490.49 72.883 23,622.51 . glbase_tbam rgonzale Trophy Club Entities Page 65 19:40 06/08/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 05/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 6,079.25 50,768.38 64.071 28,469.62 135-50010-038-000 Overtime 750.00 750.00 156.95 1,031.76 137.568 281.76- 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 826.92 7,173.48 68.830 3,248.52 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 7,116.48 66.665 3,558.52 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 551.04 66.712 274.96 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 88.64 66.647 44.36 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 330.64 59.254 227.36 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 378.33 3,394.53 68.995 1,525.47 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 88.48 793.88 68.973 357.12 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,540.78 71,993.87 65.925 37,211.13 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 143.10- 5,510.39 50.094 5,489.61 Subtotal: 11,800.00 11,800.00 143.10- 5,510.39 46.698 6,289.61 135-60005-038-000 Telephone 75.00 75.00 10.21 61.54 82.053 13.46 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 224.39 53.426 195.61 135-60035-038-000 Postage 15,820.00 15,820.00 532.10 8,840.79 55.884 6,979.21 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 971.87 7,831.32 52.209 7,168.68 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 149.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 1,663.18 34,281.13 64.692 18,709.87 135-65085-038-000 Office Supplies 700.00 700.00 106.94 486.99 69.570 213.01 135-65105-038-000 Printing 4,500.00 4,500.00 4,500.00 Subtotal: 5,200.00 5,200.00 106.94 486.99 9.365 4,713.01 Program number: 179,196.00 179,196.00 10,167.80 112,272.38 62.653 66,923.62 Department number: Utility Billing 179,196.00 179,196.00 10,167.80 112,272.38 62.653 66,923.62 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 260,110.13 2,248,849.19 48.156 2,421,084.81 Fund number: 135 MUD 1 O&M CONSOLIDATED 65,804.47- 10,199.13 10,199.13- . glbase_tbam rgonzale Trophy Club Entities Page 76 19:40 06/08/10 Budget Summary with Amendment Fund: 315 MUD 1 CIP FIRE STATION Department: Revenues Program: Period Ending: 05/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 293.68- 2,173.99- 2,173.99 Subtotal: 293.68- 2,173.99- 2,173.99 Program number: 293.68- 2,173.99- 2,173.99 Department number: Revenues 293.68- 2,173.99- 2,173.99 Revenues Subtotal ----------- 293.68- 2,173.99- 2,173.99 Fund number: 315 MUD 1 CIP FIRE STATION 293.68- 2,173.99- 2,173.99 . glbase_tbam rgonzale Trophy Club Entities Page 101 19:40 06/08/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 05/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,157.82- 708,896.11- 100.794 5,586.11 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 279.95- 6,378.47- 70.872 2,621.53- Subtotal: 712,310.00- 712,310.00- 3,437.77- 715,274.58- 100.416 2,964.58 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 36,800.00- 266,800.00- 77.333 78,200.00- Subtotal: 345,000.00- 345,000.00- 36,800.00- 266,800.00- 77.333 78,200.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 220.49- 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- 220.49- 313,052.91- 100.985 3,052.91 Program number: 1,367,310.00- 1,367,310.00- 40,458.26- 1,295,127.49- 94.721 72,182.51- Department number: Revenues 1,367,310.00- 1,367,310.00- 40,458.26- 1,295,127.49- 94.721 72,182.51- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 40,458.26- 1,295,127.49- 94.721 72,182.51- . glbase_tbam rgonzale Trophy Club Entities Page 102 19:40 06/08/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 05/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 300.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 300.00 155,255.00 11.355 1,212,055.00 Program number: 1,367,310.00 1,367,310.00 300.00 155,255.00 11.355 1,212,055.00 Department number: Administration 1,367,310.00 1,367,310.00 300.00 155,255.00 11.355 1,212,055.00 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 300.00 155,255.00 11.355 1,212,055.00