Loading...
HomeMy WebLinkAboutJuly 2010 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 46 17:02 08/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 07/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- 100.42- 49,323.37- 94.915 2,642.63- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 7,188.45- 1,134,034.28- 101.524 17,021.28 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 5,032.11- 15,436.57- 237.486 8,936.57 Subtotal: 1,123,513.00- 1,175,479.00- 12,320.98- 1,198,794.22- 101.983 23,315.22 122-42014-000-000 Fire Permits/Sprinkler 3,600.00- 3,600.00 Subtotal: 3,600.00- 3,600.00 122-43400-000-000 Fire Inspections 675.00- 675.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 13,750.00- 13,750.00- 10,000.00- 72.727 3,750.00- 122-43426-000-000 Intergov Trans (PID Fire) 51,966.00- 122-43599-000-000 Misc Fire Revenue 1,200.00- 1,200.00- 6,563.41- 546.951 5,363.41 Subtotal: 66,916.00- 14,950.00- 17,238.41- 115.307 2,288.41 122-49010-000-000 Interest Income 26.80- 26.80 122-49020-000-000 Contributions 500.00- 825.00- 825.00 122-49026-000-000 Revenue from Sale of Asset 18,000.00- 18,000.00- 18,000.00 122-49900-000-000 Miscellaneous Income 100.00- 100.00 Subtotal: 18,500.00- 18,951.80- 18,951.80 Program number: 1,190,429.00- 1,190,429.00- 30,820.98- 1,238,584.43- 104.045 48,155.43 Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 30,820.98- 1,238,584.43- 104.045 48,155.43 . glbase_tbam rgonzale Trophy Club Entities Page 48 17:02 08/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 398,849.00 398,620.00 31,448.49 321,289.32 80.600 77,330.68 122-50010-045-000 Overtime 40,298.00 40,298.00 3,708.24 29,343.72 72.817 10,954.28 122-50011-045-000 DPS Holiday Pay 11,329.00 11,464.00 11,463.22 99.993 .78 122-50016-045-000 Longevity 2,704.00 2,798.00 2,797.22 99.972 .78 122-50017-045-000 Certification 5,356.00 5,356.00 477.96 5,310.52 99.151 45.48 122-50020-045-000 Retirement 59,532.00 59,532.00 4,506.40 48,981.96 82.278 10,550.04 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,572.61 35,192.64 82.040 7,704.36 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 252.84 2,508.66 82.197 543.34 122-50028-045-000 Vision Insurance 493.00 493.00 41.09 404.97 82.144 88.03 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 190.01 1,892.21 73.285 689.79 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 2,024.77 22,502.79 84.865 4,013.21 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 473.59 5,262.74 84.869 938.26 122-50040-045-000 Unemployment Taxes 549.00 549.00 64.38 1,664.53 303.193 1,115.53- 122-50045-045-000 Workman's Compensation 9,799.00 9,799.00 2,804.55 12,276.20 125.280 2,477.20- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 278.30 41.230 396.70 Subtotal: 610,832.00 610,832.00 49,564.93 501,169.00 82.047 109,663.00 122-55080-045-000 Maintenance & Repairs 5,400.00 5,400.00 3,463.04 64.130 1,936.96 122-55090-045-000 Vehicle Maintenance 13,500.00 13,500.00 101.57 12,159.18 90.068 1,340.82 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 1,488.64 2,260.90 64.597 1,239.10 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 818.73 3,132.29 28.475 7,867.71 122-55110-045-000 Maintenance-Radios 1,000.00 1,000.00 1,000.00 122-55160-045-000 Professional Outside Services 40,000.00 40,000.00 38,387.99 95.970 1,612.01 Subtotal: 74,400.00 74,400.00 2,408.94 59,403.40 79.843 14,996.60 122-60005-045-000 Telephone 100.00 100.00 5.23 43.10 43.100 56.90 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 225.82 1,675.57 67.645 801.43 122-60020-045-000 Electricity 16,571.00 16,571.00 621.09 8,170.85 49.308 8,400.15 122-60025-045-000 Water 3,100.00 3,100.00 23.76 924.32 29.817 2,175.68 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 189.75 232.79 63.953 131.21 122-60070-045-000 Dues & Memberships 7,960.00 7,960.00 6,322.52 79.429 1,637.48 122-60075-045-000 Meetings 300.00 300.00 120.52 40.173 179.48 122-60080-045-000 Schools & Training 6,300.00 6,300.00 1,313.53 4,013.53 63.707 2,286.47 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 917.49 3,526.08 52.092 3,242.92 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 958.07 23.952 3,041.93 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 465.44 46.544 534.56 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 146.00 1,547.44 67.076 759.56 . glbase_tbam rgonzale Trophy Club Entities Page 49 17:02 08/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 07/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 34.57 452.36 37.697 747.64 Subtotal: 382,558.00 382,558.00 3,477.24 339,317.69 88.697 43,240.31 122-65005-045-000 Fuel & Lube 15,795.00 12,095.00 663.62 6,230.86 51.516 5,864.14 122-65010-045-000 Uniforms 4,230.00 4,230.00 2,160.66 51.079 2,069.34 122-65015-045-000 Protective Clothing 4,600.00 4,600.00 3,840.49 83.489 759.51 122-65030-045-000 Chemicals 1,500.00 1,500.00 511.00 511.00 34.067 989.00 122-65035-045-000 Small Tools 7,890.00 7,890.00 301.64 3,131.65 39.691 4,758.35 122-65085-045-000 Office Supplies 310.00 310.00 17.85 210.89 68.029 99.11 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 74.29 1,133.80 44.885 1,392.20 122-65105-045-000 Printing 100.00 100.00 22.49 22.490 77.51 Subtotal: 36,951.00 33,251.00 1,568.40 17,241.84 51.854 16,009.16 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-69220-045-000 Computer Equipment 23,734.00 23,744.00 23,744.00 100.042 10.00- 122-69251-045-000 Engine 681 Payment 72,943.00 72,943.00 500.00 7,471.30 10.243 65,471.70 122-69255-045-000 Airpacks 2,245.00 2,245.00 2,245.00 2,245.00 100.000 Subtotal: 85,688.00 113,122.00 23,744.00 2,745.00 37,642.89 33.276 75,479.11 Program number: 1,190,429.00 1,214,163.00 23,744.00 59,764.51 954,774.82 78.636 259,388.18 . glbase_tbam rgonzale Trophy Club Entities Page 47 17:02 08/11/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: 07/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- 30,820.98- 1,239,784.43- 104.146 49,355.43 . glbase_tbam rgonzale Trophy Club Entities Page 50 17:02 08/11/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: 07/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,214,163.00 23,744.00 59,764.51 955,873.82 78.727 258,289.18 Expenditures Subtotal ----------- 1,190,429.00 1,214,163.00 23,744.00 59,764.51 955,873.82 78.727 258,289.18 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 23,734.00 23,744.00 28,943.53 283,910.61- -1,196.219 307,644.61 . glbase_tbam rgonzale Trophy Club Entities Page 51 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 07/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,622.38- 280,621.34- 100.996 2,767.34 135-40015-000-000 Property Taxes/P & I 1,381.48- 4,959.18- 4,959.18 Subtotal: 277,854.00- 277,854.00- 3,003.86- 285,580.52- 102.781 7,726.52 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 178,897.00- 1,071,917.31- 63.671 611,607.69- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 100,527.96- 756,984.79- 71.507 301,635.21- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 92,404.22- 481,936.82- 64.363 266,843.18- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 25,555.02- 200,548.03- 60.117 133,046.97- 135-47020-000-000 Standby 1,140.00- 1,140.00- 71.00- 637.10- 55.886 502.90- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 4,746.66- 32,209.79- 58.563 22,790.21- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 828.00- 14,836.65- 92.729 1,163.35- 135-47035-000-000 Plumbing Inspections 50.00- 900.00- 900.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 150.00- 2,775.00- 222.000 1,525.00 135-47050-000-000 Tap Fees 1,500.00- 1,500.00 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 12,274.68- 30,045.44- 50.076 29,954.56- 135-47270-000-000 Fire Line 4,725.00- 4,725.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 265.40- 16,097.09- 44.529 20,052.91- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 1,510.96- 9,859.73- 63.611 5,640.27- 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- 30,442.74- 126,497.55- 62.810 74,898.45- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 9,121.77- 49,710.29- 82.989 10,189.71- Subtotal: 4,271,056.00- 4,271,056.00- 456,845.41- 2,801,882.33- 65.602 1,469,173.67- 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 313.88- 2,081.16- 104.058 81.16 135-49015-000-000 Lease/Rental Income 10,164.00- 847.00- 847.00- 847.00 135-49016-000-000 Cell Tower Revenue 10,164.00- 7,623.00- 75.000 2,541.00- 135-49018-000-000 Building Rent Income 7,000.00- 583.33- 5,833.30- 83.333 1,166.70- 135-49030-000-000 Vending Revenue 850.00- 850.00- 217.50- 867.50- 102.059 17.50 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 12,710.00- 135-49075-000-000 Oversize Meter Reimbursement 36,000.00- 36,000.00- 3,840.00- 42,766.50- 118.796 6,766.50 135-49900-000-000 Miscellaneous Income 21,100.00- 14,100.00- 913.00- 14,471.88- 102.637 371.88 135-49901-000-000 Records Management Revenue 276.00- 276.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 4,400.00- 43,035.00- 134.484 11,035.00 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 199.63- 1,887.82- 30.449 4,312.18- Subtotal: 121,024.00- 121,024.00- 11,314.34- 119,689.16- 98.897 1,334.84- Program number: 4,669,934.00- 4,669,934.00- 471,163.61- 3,207,152.01- 68.677 1,462,781.99- Department number: Revenues 4,669,934.00- 4,669,934.00- 471,163.61- 3,207,152.01- 68.677 1,462,781.99- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 471,163.61- 3,207,152.01- 68.677 1,462,781.99- . glbase_tbam rgonzale Trophy Club Entities Page 52 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 07/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 97,659.35 61.123 62,114.65 135-50010-010-000 Overtime 8,814.00 8,814.00 1,038.24 11,483.67 130.289 2,669.67- 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 1,035.00 69.000 465.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,412.30 15,311.06 68.475 7,048.94 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 12,661.80 54.730 10,473.20 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 877.40 55.921 691.60 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 160.60 56.950 121.40 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 638.50 56.756 486.50 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 652.45 7,276.49 68.543 3,339.51 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 152.57 1,701.73 68.535 781.27 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 1,573.00 4,008.00 72.926 1,488.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 115.50 33.000 234.50 Subtotal: 239,884.00 239,884.00 15,874.91 155,406.10 64.784 84,477.90 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,122.61 4,244.33 16.324 21,755.67 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 1,520.40 45.385 1,829.60 Subtotal: 37,680.00 37,680.00 1,122.61 8,413.38 22.329 29,266.62 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 234.25 1,312.70 65.114 703.30 135-60020-010-000 Electricity 195,000.00 195,000.00 16,973.18 95,560.31 49.005 99,439.69 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 157.41- 1,220.26 29.054 2,979.74 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 562.02 20.072 2,237.98 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 3,200.00 3,200.00 164.50 1,218.20 38.069 1,981.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 139,077.17 682,833.15 48.996 710,816.85 135-60245-010-000 Miscellaneous Expenses 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 560.90 13.355 3,639.10 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 466.43 496.40 24.820 1,503.60 Subtotal: 1,631,316.00 1,614,966.00 156,758.12 789,960.91 48.915 825,005.09 . glbase_tbam rgonzale Trophy Club Entities Page 53 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 07/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 650.05 7,238.88 47.574 7,977.12 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 698.00 5,119.76 98.457 80.24 135-65035-010-000 Small Tools 2,500.00 2,500.00 216.83 8.673 2,283.17 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 107.61 388.13 15.525 2,111.87 135-65050-010-000 Meter Expense 75,000.00 75,000.00 823.50 74,332.00 99.109 668.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 1,041.02 8,141.01 27.137 21,858.99 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,320.18 96,330.07 71.194 38,975.93 135-69005-010-000 Capital Expenses 38,500.00 54,850.00 3,136.10 89,805.76 163.730 34,955.76- 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 10,726.23 10,726.23 93.353 763.77 Subtotal: 214,011.00 230,361.00 13,862.33 225,301.78 97.804 5,059.22 Program number: 2,258,197.00 2,258,197.00 190,938.15 1,275,412.24 56.479 982,784.76 Department number: Water 2,258,197.00 2,258,197.00 190,938.15 1,275,412.24 56.479 982,784.76 . glbase_tbam rgonzale Trophy Club Entities Page 54 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 07/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 136,538.29 79.565 35,068.71 135-50010-020-000 Overtime 10,166.00 10,166.00 724.45 13,432.27 132.129 3,266.27- 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,575.00 61.765 975.00 135-50020-020-000 Retirement 24,372.00 24,372.00 1,869.67 21,101.57 86.581 3,270.43 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 22,919.20 83.333 4,583.80 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 1,652.80 83.348 330.20 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 297.60 83.361 59.40 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 889.50 74.249 308.50 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 732.90 8,717.46 87.736 1,218.54 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 171.39 2,038.75 87.726 285.25 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 1,714.67 6,542.68 109.208 551.68- 135-50070-020-000 Employee Relations 250.00 250.00 250.00 Subtotal: 261,660.00 261,660.00 21,164.55 219,613.62 83.931 42,046.38 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 3,926.00 14,266.38 70.451 5,983.62 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 2,210.84 96.459 81.16 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 618.00 44.143 782.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 303.53 10.289 2,646.47 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 1,138.25 12,732.64 45.474 15,267.36 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,182.75 10,261.75 49.454 10,488.25 Subtotal: 77,892.00 77,892.00 6,247.00 42,143.14 54.105 35,748.86 135-60005-020-000 Telephone 10.00 7.05 48.68 486.800 38.68- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 493.61 2,416.24 73.756 859.76 135-60020-020-000 Electricity 230,000.00 230,000.00 16,626.17 152,251.12 66.196 77,748.88 135-60025-020-000 Water 1,600.00 1,600.00 113.06 1,489.16 93.073 110.84 135-60035-020-000 Postage 120.00 120.00 13.65 13.65 11.375 106.35 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 462.00 35.000 858.00 135-60090-020-000 Safety Program 200.00 200.00 200.00 135-60100-020-000 Travel & per diem 1,250.00 1,250.00 88.50 1,758.20 140.656 508.20- 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 102.24 190.41 36.269 334.59 Subtotal: 247,016.00 247,016.00 17,444.28 166,087.68 67.238 80,928.32 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 448.80 2,746.96 72.767 1,028.04 . glbase_tbam rgonzale Trophy Club Entities Page 55 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 07/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 16,514.07 166.809 6,614.07- 135-65035-020-000 Small Tools 1,260.00 1,260.00 515.61 40.921 744.39 135-65040-020-000 Safety Equipment 540.00 540.00 216.96 586.80 108.667 46.80- 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 970.72 4,444.11 73.034 1,640.89 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 44.76 2,559.03 19.299 10,700.97 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 2,581.24 28,361.31 74.517 9,698.69 135-69005-020-000 Capital Expenses 144,689.00 144,689.00 118,689.39 118,689.39 82.031 25,999.61 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 118,689.39 133,683.64 68.036 62,805.36 Program number: 821,117.00 821,117.00 166,126.46 589,889.39 71.840 231,227.61 Department number: Wastewater 821,117.00 821,117.00 166,126.46 589,889.39 71.840 231,227.61 . glbase_tbam rgonzale Trophy Club Entities Page 56 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 07/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,175.27 105,422.93 79.677 26,890.07 135-50010-021-000 Overtime 14,145.00 14,145.00 1,439.82 8,994.61 63.589 5,150.39 135-50016-021-000 Longevity 2,888.00 2,920.00 2,920.00 100.000 135-50017-021-000 Certification 1,200.00 1,200.00 125.00 1,125.00 93.750 75.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,556.74 16,150.19 82.504 3,424.81 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 15,035.60 83.332 3,007.40 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 1,188.80 83.366 237.20 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 185.20 89.903 20.80 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 676.60 74.026 237.40 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 662.68 7,099.90 84.563 1,296.10 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 154.99 1,660.47 84.545 303.53 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 900.69 3,286.76 104.441 139.76- 135-50070-021-000 Employee Relations 250.00 250.00 12.50 5.000 237.50 Subtotal: 204,702.00 204,702.00 16,723.81 164,325.56 80.276 40,376.44 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,476.89 34.769 6,523.11 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 984.64 47.613 1,083.36 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 14,518.00 14,518.00 4,461.53 30.731 10,056.47 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 405.19 1,914.95 90.670 197.05 135-60020-021-000 Electricity 22,250.00 22,250.00 1,913.71 17,919.59 80.537 4,330.41 135-60025-021-000 Water 750.00 750.00 12.48 56.16 7.488 693.84 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 480.00 17.033 2,338.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 41.00 455.25 30.350 1,044.75 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 37,046.79 37,046.79 94.992 1,953.21 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 39,419.17 57,999.62 82.054 12,685.38 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 816.19 9,713.96 90.785 986.04 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 13,120.00 131.200 3,120.00- 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 107.62 107.62 9.358 1,042.38 135-65055-021-000 Hardware 750.00 750.00 750.00 . glbase_tbam rgonzale Trophy Club Entities Page 57 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 178.95 1.115 15,871.05 Subtotal: 42,655.00 42,655.00 923.81 23,679.48 55.514 18,975.52 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 57,066.79 250,466.19 69.083 112,093.81 Department number: Collection 362,560.00 362,560.00 57,066.79 250,466.19 69.083 112,093.81 . glbase_tbam rgonzale Trophy Club Entities Page 58 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 15,000.00 15,000.00 300.00 9,400.00 62.667 5,600.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 18.60 626.20 48.543 663.80 135-50035-026-000 Medicare Taxes 302.00 302.00 4.35 146.45 48.493 155.55 135-50040-026-000 Unemployment Taxes 375.00 375.00 6.30 159.30 42.480 215.70 135-50045-026-000 Workman's Compensation 120.00 120.00 34.34 114.36 95.300 5.64 Subtotal: 17,087.00 17,087.00 363.59 10,446.31 61.136 6,640.69 135-55045-026-000 Legal 32,500.00 51,927.20- 135-55060-026-000 Appraisal 18,874.00 13,080.49- 135-55065-026-000 Tax Admin Fees 2,380.00 2,983.33- Subtotal: 53,754.00 67,991.02- 135-60066-026-000 Publications/Books/Subscripts 54.00 54.00 54.00 135-60070-026-000 Dues & Memberships 1,096.00 2,096.00 1,960.00 93.511 136.00 135-60075-026-000 Meetings 600.00 600.00 22.00 409.91 68.318 190.09 135-60080-026-000 Schools & Training 5,775.00 5,775.00 3,395.00 58.788 2,380.00 135-60100-026-000 Travel & per diem 12,147.00 11,147.00 587.40 3,201.52 28.721 7,945.48 135-60115-026-000 Elections 44.64- 44.64 135-60125-026-000 Advertising 820.00 820.00 100.00 100.00 12.195 720.00 135-60245-026-000 Miscellaneous Expenses 300.00 196.00 22.54 22.54 11.500 173.46 Subtotal: 20,792.00 20,688.00 731.94 9,044.33 43.718 11,643.67 135-65085-026-000 Office Supplies 200.00 200.00 11.00 134.90 67.450 65.10 Subtotal: 200.00 200.00 11.00 134.90 67.450 65.10 Program number: 91,833.00 37,975.00 66,884.49- 19,625.54 51.680 18,349.46 Department number: Board of Directors 91,833.00 37,975.00 66,884.49- 19,625.54 51.680 18,349.46 . glbase_tbam rgonzale Trophy Club Entities Page 59 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 07/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,521.12 202,934.36 81.337 46,564.64 135-50010-027-000 Overtime 1,750.00 1,750.00 136.82 2,699.46 154.255 949.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,732.53 28,549.83 86.562 4,432.17 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.73 18,597.22 83.332 3,719.78 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.53 1,205.17 83.345 240.83 135-50028-027-000 Vision Insurance 269.00 269.00 22.37 223.65 83.141 45.35 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 1,069.19 71.232 431.81 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,224.04 13,157.05 85.109 2,301.95 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 286.26 3,077.03 85.118 537.97 135-50040-027-000 Unemployment Taxes 304.00 304.00 1.07 759.20 249.737 455.20- 135-50045-027-000 Workman's Compensation 671.00 671.00 192.05 1,102.20 164.262 431.20- 135-50070-027-000 Employee Relations 838.00 838.00 1,007.73 120.254 169.73- Subtotal: 333,707.00 333,707.00 27,201.78 277,438.34 83.138 56,268.66 135-55070-027-000 Independent Labor 720.00 720.00 37.50 491.25 68.229 228.75 135-55075-027-000 Records Management 100.00 100.00 29.50 418.24 418.240 318.24- 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 67.00 1,036.36 56.943 783.64 135-60005-027-000 Telephone 265.00 265.00 20.64 208.35 78.623 56.65 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 327.63 2,442.43 88.015 332.57 135-60035-027-000 Postage 1,071.00 1,071.00 259.72 1,249.08 116.627 178.08- 135-60040-027-000 Service Charges & Fees 50.00 50.00- 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 335.75 95.929 14.25 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 1,308.66 78.222 364.34 135-60075-027-000 Meetings 961.00 961.00 92.00 467.04 48.599 493.96 135-60080-027-000 Schools & Training 2,715.00 2,715.00 1,071.00 39.448 1,644.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 1,795.07 85.724 298.93 135-60115-027-000 Elections 3,500.00 3,500.00 2,662.57 76.073 837.43 135-60125-027-000 Advertising 650.00 650.00 203.01 31.232 446.99 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 10,000.00 100.000 135-60271-027-000 Town 25th Anniversary 2,500.00 2,500.00- 135-60350-027-000 Transfer to Debt Service 47.98- 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 893.49 51.057 856.51 Subtotal: 27,904.00 27,904.00 10,652.01 25,186.45 90.261 2,717.55 135-65085-027-000 Office Supplies 2,450.00 2,450.00 228.75 1,857.36 75.811 592.64 135-65105-027-000 Printing 515.00 515.00 84.65 16.437 430.35 Subtotal: 2,965.00 2,965.00 228.75 1,942.01 65.498 1,022.99 . glbase_tbam rgonzale Trophy Club Entities Page 60 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 07/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 38,149.54 305,603.16 83.408 60,792.84 Department number: Manager's Office 366,396.00 366,396.00 38,149.54 305,603.16 83.408 60,792.84 . glbase_tbam rgonzale Trophy Club Entities Page 61 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 07/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 20,473.98 79.671 5,224.02 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.11 2,820.25 84.111 532.75 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 2,223.82 83.320 445.18 135-50027-028-000 Dental Insurance 155.00 155.00 12.90 129.12 83.303 25.88 135-50028-028-000 Vision Insurance 30.00 30.00 2.49 24.85 82.833 5.15 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 135.70 73.750 48.30 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 122.56 1,353.05 85.258 233.95 135-50035-028-000 Medicare Taxes 371.00 371.00 28.68 316.42 85.288 54.58 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 77.84 114.471 9.84- 135-50070-028-000 Employee Relations 1,625.00 1,625.00 72.38 1,213.03 74.648 411.97 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 144.59 9.639 1,355.41 135-50994-028-000 Employee Assistance Program 102.20 929.60 929.60- 135-50995-028-000 Flexible Benefits Admin Fee 229.44 1,474.00 1,474.00- Subtotal: 37,372.00 37,372.00 3,064.97 31,508.25 84.310 5,863.75 135-60005-028-000 Telephone 26.00 26.00 .31 5.63 21.654 20.37 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 23.84 152.10 72.429 57.90 135-60035-028-000 Postage 102.00 102.00 106.90 104.804 4.90- 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 240.00 54.545 200.00 135-60070-028-000 Dues & Memberships 504.00 504.00 190.98 37.893 313.02 135-60075-028-000 Meetings 130.00 130.00 87.50 67.308 42.50 135-60080-028-000 Schools & Training 539.00 539.00 334.00 334.00 61.967 205.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 960.00 960.00 328.00 34.167 632.00 Subtotal: 2,919.00 2,919.00 358.15 1,445.11 49.507 1,473.89 135-65085-028-000 Office Supplies 412.00 412.00 18.04 59.98 14.558 352.02 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 18.04 59.98 11.490 462.02 Program number: 40,813.00 40,813.00 3,441.16 33,013.34 80.889 7,799.66 Department number: Human Resources 40,813.00 40,813.00 3,441.16 33,013.34 80.889 7,799.66 . glbase_tbam rgonzale Trophy Club Entities Page 62 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 135,172.00 127,457.00 7,819.40 93,787.97 73.584 33,669.03 135-50010-029-000 Overtime 2,000.00 5,683.00 645.56 5,235.12 92.119 447.88 135-50016-029-000 Longevity 1,259.00 870.00 870.00 100.000 135-50020-029-000 Retirement 17,996.00 16,907.00 1,122.46 13,777.71 81.491 3,129.29 135-50026-029-000 Medical Insurance 10,550.00 9,550.00 799.31 8,522.53 89.241 1,027.47 135-50027-029-000 Dental Insurance 765.00 765.00 55.96 581.70 76.039 183.30 135-50028-029-000 Vision Insurance 127.00 127.00 8.07 91.88 72.346 35.12 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 523.03 63.016 306.97 135-50030-029-000 Social Security Taxes 8,265.00 7,965.00 459.09 6,020.32 75.585 1,944.68 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 107.36 1,408.01 72.841 524.99 135-50040-029-000 Unemployment Taxes 135.00 382.00 381.21 99.793 .79 135-50045-029-000 Workman's Compensation 365.00 565.00 142.81 456.22 80.747 108.78 135-50060-029-000 Pre-emp Physicals/Testing 100.00 31.47 31.470 68.53 Subtotal: 179,397.00 173,134.00 11,206.15 131,687.17 76.061 41,446.83 135-55055-029-000 Auditing 40,000.00 33,591.00- 135-55160-029-000 Professional Outside Services 8,705.00 735.00 3,610.75 41.479 5,094.25 Subtotal: 40,000.00 8,705.00 32,856.00- 3,610.75 41.479 5,094.25 135-60005-029-000 Telephone 103.00 103.00 4.19 84.00 81.553 19.00 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 40.16 328.38 64.897 177.62 135-60035-029-000 Postage 900.00 900.00 221.73 24.637 678.27 135-60040-029-000 Service Charges & Fees 75.00 75.00 32.50 43.333 42.50 135-60066-029-000 Publications/Books/Subscripts 250.00 250.00 9.97 35.67 14.268 214.33 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 1,166.85 85.735 194.15 135-60075-029-000 Meetings 66.00 66.00 11.00 77.00 116.667 11.00- 135-60080-029-000 Schools & Training 1,370.00 1,370.00 571.05 41.682 798.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 26.97 1,071.09 65.510 563.91 135-60245-029-000 Miscellaneous Expenses 1,000.00 895.00 53.88 6.020 841.12 135-60360-029-000 Furniture/Equipment < $5000 406.00 405.24 99.813 .76 Subtotal: 7,266.00 7,567.00 92.29 4,047.39 53.487 3,519.61 135-65085-029-000 Office Supplies 800.00 657.00 39.74 482.37 73.420 174.63 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,557.00 39.74 482.37 30.981 1,074.63 Program number: 228,363.00 190,963.00 21,517.82- 139,827.68 73.222 51,135.32 Department number: Finance 228,363.00 190,963.00 21,517.82- 139,827.68 73.222 51,135.32 . glbase_tbam rgonzale Trophy Club Entities Page 63 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 07/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 46,911.85 79.670 11,971.15 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 6,475.88 84.201 1,215.12 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.69 4,106.88 83.338 821.12 135-50027-033-000 Dental Insurance 310.00 310.00 25.83 258.15 83.274 51.85 135-50028-033-000 Vision Insurance 60.00 60.00 4.97 49.66 82.767 10.34 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 284.00 73.958 100.00 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 280.80 3,107.18 84.710 560.82 135-50035-033-000 Medicare Taxes 858.00 858.00 65.66 726.61 84.686 131.39 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 178.60 114.487 22.60- Subtotal: 77,284.00 77,344.00 5,991.02 62,625.29 80.970 14,718.71 135-55030-033-000 Software & Support 56,190.00 56,130.00 1,596.42 35,366.08 63.007 20,763.92 135-55070-033-000 Independent Labor 1,464.00 1,464.00 125.00 1,559.38 106.515 95.38- Subtotal: 57,654.00 57,594.00 1,721.42 36,925.46 64.113 20,668.54 135-60005-033-000 Telephone 20,520.00 20,520.00 1,281.01 10,812.51 52.693 9,707.49 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 122.83 782.27 72.365 298.73 135-60035-033-000 Postage 100.00 100.00 1.73 1.730 98.27 135-60046-033-000 Prompt Payment Act Interest 2.30 2.30- 135-60066-033-000 Publications/Books/Subscripts 63.00 138.00 65.88 47.739 72.12 135-60070-033-000 Dues & Memberships 177.00 177.00 137.47 77.667 39.53 135-60075-033-000 Meetings 75.00 75.00 11.00 14.667 64.00 135-60080-033-000 Schools & Training 1,738.00 1,663.00 774.00 46.542 889.00 135-60100-033-000 Travel & per diem 1,464.00 1,464.00 341.57 23.331 1,122.43 135-60235-033-000 Security 1,902.00 1,902.00 195.11 914.87 48.100 987.13 Subtotal: 27,120.00 27,120.00 1,598.95 13,843.60 51.046 13,276.40 135-65055-033-000 Hardware 36,682.00 36,682.00 842.89 26,772.61 72.986 9,909.39 135-65085-033-000 Office Supplies 300.00 300.00 112.26 241.51 80.503 58.49 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 292.00 2,647.19 54.638 2,197.81 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 1,247.15 29,661.31 70.745 12,265.69 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 2,459.61 71.293 990.39 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 273.29 2,459.61 8.101 27,901.39 Program number: 234,346.00 234,346.00 10,831.83 145,515.27 62.094 88,830.73 . glbase_tbam rgonzale Trophy Club Entities Page 64 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 07/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,831.83 145,515.27 62.094 88,830.73 . glbase_tbam rgonzale Trophy Club Entities Page 65 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 07/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 538.45 3,452.03 52.343 3,142.97 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 673.26 6,812.06 75.690 2,187.94 Subtotal: 20,400.00 15,595.00 1,211.71 10,264.09 65.817 5,330.91 135-60020-037-000 Electricity 19,900.00 19,900.00 11,133.75 55.948 8,766.25 135-60025-037-000 Water 1,030.00 1,030.00 84.98 451.64 43.849 578.36 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 10,985.10 83.334 2,196.90 135-60055-037-000 Insurance 29,601.00 34,406.00 50.00 34,554.71 100.432 148.71- Subtotal: 63,713.00 68,518.00 1,233.49 57,125.20 83.373 11,392.80 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 119.51 1,429.36 71.468 570.64 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 534.23 53.423 465.77 Subtotal: 3,000.00 3,000.00 119.51 1,963.59 65.453 1,036.41 Program number: 87,113.00 87,113.00 2,564.71 69,352.88 79.613 17,760.12 Department number: Facilities Maintenance 87,113.00 87,113.00 2,564.71 69,352.88 79.613 17,760.12 . glbase_tbam rgonzale Trophy Club Entities Page 66 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 07/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,091.28 62,805.86 79.262 16,432.14 135-50010-038-000 Overtime 750.00 750.00 1,071.09 142.812 321.09- 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 807.70 8,774.86 84.196 1,647.14 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 8,895.60 83.331 1,779.40 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 688.80 83.390 137.20 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 110.80 83.308 22.20 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 413.30 74.068 144.70 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 369.33 4,126.64 83.875 793.36 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 86.37 965.10 83.849 185.90 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 60.68 242.72 114.491 30.72- Subtotal: 109,205.00 109,205.00 8,426.21 88,657.77 81.185 20,547.23 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 814.34 7,998.34 72.712 3,001.66 Subtotal: 11,800.00 11,800.00 814.34 7,998.34 67.783 3,801.66 135-60005-038-000 Telephone 75.00 75.00 8.86 81.44 108.587 6.44- 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 58.23 314.75 74.940 105.25 135-60035-038-000 Postage 15,820.00 15,820.00 1,660.90 12,990.47 82.114 2,829.53 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 1,420.10 10,432.66 69.551 4,567.34 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 198.00 347.00 43.375 453.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 20,000.00 20,000.00 17,174.03 85.870 2,825.97 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .06 .030 199.94 Subtotal: 52,991.00 52,991.00 3,346.09 41,340.41 78.014 11,650.59 135-65085-038-000 Office Supplies 700.00 700.00 9.96 509.37 72.767 190.63 135-65105-038-000 Printing 4,500.00 4,500.00 841.62 18.703 3,658.38 Subtotal: 5,200.00 5,200.00 9.96 1,350.99 25.981 3,849.01 Program number: 179,196.00 179,196.00 12,596.60 139,347.51 77.763 39,848.49 Department number: Utility Billing 179,196.00 179,196.00 12,596.60 139,347.51 77.763 39,848.49 . glbase_tbam rgonzale Trophy Club Entities Page 67 17:02 08/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 39 Non Departmental Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 32,500.00 55,025.20 55,025.20 169.308 22,525.20- 135-55055-039-000 Auditing 37,400.00 33,591.00 33,591.00 89.816 3,809.00 135-55060-039-000 Appraisal 18,374.00 13,080.49 13,080.49 71.190 5,293.51 135-55065-039-000 Tax Admin Fees 2,984.00 2,983.33 2,983.33 99.978 .67 Subtotal: 91,258.00 104,680.02 104,680.02 114.708 13,422.02- Program number: 91,258.00 104,680.02 104,680.02 114.708 13,422.02- Department number: Non Departmental 91,258.00 104,680.02 104,680.02 114.708 13,422.02- Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 497,992.95 3,072,733.22 65.798 1,597,200.78 Fund number: 135 MUD 1 O&M CONSOLIDATED 26,829.34 134,418.79- 134,418.79 . glbase_tbam rgonzale Trophy Club Entities Page 78 17:02 08/11/10 Budget Summary with Amendment Fund: 315 MUD 1 CIP FIRE STATION Department: Revenues Program: Period Ending: 07/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 342.56- 2,821.48- 2,821.48 Subtotal: 342.56- 2,821.48- 2,821.48 Program number: 342.56- 2,821.48- 2,821.48 Department number: Revenues 342.56- 2,821.48- 2,821.48 Revenues Subtotal ----------- 342.56- 2,821.48- 2,821.48 Fund number: 315 MUD 1 CIP FIRE STATION 342.56- 2,821.48- 2,821.48 . glbase_tbam rgonzale Trophy Club Entities Page 99 17:02 08/11/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 07/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- 10,114.68- 722,975.72- 102.796 19,665.72 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 6,371.92- 13,377.11- 148.635 4,377.11 Subtotal: 712,310.00- 712,310.00- 16,486.60- 736,352.83- 103.375 24,042.83 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 32,200.00- 338,100.00- 98.000 6,900.00- Subtotal: 345,000.00- 345,000.00- 32,200.00- 338,100.00- 98.000 6,900.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 272.93- 4,560.93- 228.047 2,560.93 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- 272.93- 313,560.93- 101.149 3,560.93 Program number: 1,367,310.00- 1,367,310.00- 48,959.53- 1,388,013.76- 101.514 20,703.76 Department number: Revenues 1,367,310.00- 1,367,310.00- 48,959.53- 1,388,013.76- 101.514 20,703.76 Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 48,959.53- 1,388,013.76- 101.514 20,703.76 . glbase_tbam rgonzale Trophy Club Entities Page 100 17:02 08/11/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 07/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 2,159.50 3,259.50 81.488 740.50 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 2,159.50 157,414.50 11.513 1,209,895.50 Program number: 1,367,310.00 1,367,310.00 2,159.50 157,414.50 11.513 1,209,895.50 Department number: Administration 1,367,310.00 1,367,310.00 2,159.50 157,414.50 11.513 1,209,895.50 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 2,159.50 157,414.50 11.513 1,209,895.50