Loading...
HomeMy WebLinkAboutSeptember 2010 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 46 15:46 10/15/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 09/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- 418.72- 49,742.09- 95.720 2,223.91- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 303.20- 1,138,916.32- 101.961 21,903.32 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 163.11- 16,591.37- 255.252 10,091.37 Subtotal: 1,123,513.00- 1,175,479.00- 885.03- 1,205,249.78- 102.533 29,770.78 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 825.00- 825.00 122-49026-000-000 Revenue from Sale of Asset 18,000.00- 18,000.00 122-49900-000-000 Miscellaneous Income 100.00- 100.00 Subtotal: 18,951.80- 18,951.80 Program number: 1,190,429.00- 1,190,429.00- 885.03- 1,245,039.99- 104.588 54,610.99 Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 885.03- 1,245,039.99- 104.588 54,610.99 . glbase_tbam rgonzale Trophy Club Entities Page 49 15:46 10/15/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 09/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 47,335.16 400,871.59 100.565 2,251.59- 122-50010-045-000 Overtime 40,298.00 40,298.00 4,963.17 37,267.38 92.479 3,030.62 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 306.66 2,380.89 44.453 2,975.11 122-50020-045-000 Retirement 59,532.00 59,532.00 6,631.04 60,008.93 100.801 476.93- 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,555.51 42,311.16 98.634 585.84 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 251.62 3,012.37 98.702 39.63 122-50028-045-000 Vision Insurance 493.00 493.00 40.93 486.88 98.759 6.12 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 190.01 2,272.23 88.003 309.77 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 3,078.07 27,604.17 104.104 1,088.17- 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 719.87 6,455.75 104.108 254.75- 122-50040-045-000 Unemployment Taxes 549.00 549.00 37.37 1,762.82 321.097 1,213.82- 122-50045-045-000 Workman's Compensation 9,799.00 9,799.00 12,276.20 125.280 2,477.20- 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 296.45 43.919 378.55 Subtotal: 610,832.00 610,832.00 67,109.41 611,267.26 100.071 435.26- 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 19,500.00 6,506.09 19,377.47 99.372 122.53 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 1,088.26 3,349.16 95.690 150.84 122-55100-045-000 Building Maintenance 11,000.00 5,000.00 271.94 3,629.32 72.586 1,370.68 122-55110-045-000 Maintenance-Radios 1,000.00 1,000.00 735.42 735.42 73.542 264.58 122-55160-045-000 Professional Outside Services 40,000.00 40,000.00 39,027.99 97.570 972.01 Subtotal: 74,400.00 74,400.00 8,601.71 69,582.40 93.525 4,817.60 122-60005-045-000 Telephone 100.00 100.00 2.29 46.44 46.440 53.56 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 338.62 2,043.66 82.505 433.34 122-60020-045-000 Electricity 16,571.00 16,571.00 1,125.09 10,740.63 64.816 5,830.37 122-60025-045-000 Water 3,100.00 3,100.00 38.76 1,117.28 36.041 1,982.72 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 25.89 90.99 97.839 2.01 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 232.79 63.953 131.21 122-60070-045-000 Dues & Memberships 7,960.00 7,960.00 575.00 6,897.52 86.652 1,062.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 943.85 5,050.54 80.167 1,249.46 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 196.00 3,743.64 55.306 3,025.36 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 2,826.00 3,784.07 94.602 215.93 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 200.00 665.44 66.544 334.56 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 477.79 2,025.23 87.786 281.77 . glbase_tbam rgonzale Trophy Club Entities Page 50 15:46 10/15/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 09/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 53.46 1,267.78 105.648 67.78- Subtotal: 382,558.00 382,558.00 6,802.75 348,626.53 91.130 33,931.47 122-65005-045-000 Fuel & Lube 15,795.00 12,095.00 796.45 7,734.93 63.951 4,360.07 122-65010-045-000 Uniforms 4,230.00 4,230.00 976.17 3,136.83 74.157 1,093.17 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 34.067 989.00 122-65035-045-000 Small Tools 7,890.00 7,890.00 4,169.53 7,301.18 92.537 588.82 122-65085-045-000 Office Supplies 310.00 310.00 7.13 218.02 70.329 91.98 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 44.95 1,323.37 52.390 1,202.63 122-65105-045-000 Printing 100.00 100.00 50.00 72.49 72.490 27.51 Subtotal: 36,951.00 33,251.00 6,044.23 24,138.31 72.594 9,112.69 122-69006-045-000 Grant Match 3,000.00 10,000.00 10,000.00 10,000.00 100.000 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 8,586.00 23,744.00 63.866 10.00- 122-69251-045-000 Engine 681 Payment 72,943.00 72,943.00 73,442.60 100.685 499.60- 122-69255-045-000 Airpacks 2,245.00 2,245.00 2,245.00 100.000 Subtotal: 85,688.00 113,122.00 18,586.00 113,614.19 92.845 492.19- Program number: 1,190,429.00 1,214,163.00 107,144.10 1,167,228.69 95.427 46,934.31 . glbase_tbam rgonzale Trophy Club Entities Page 47 15:46 10/15/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: 09/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 . glbase_tbam rgonzale Trophy Club Entities Page 51 15:46 10/15/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: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-65035-045-026 Small Tools 60.72 1,200.00 1,200.00- Subtotal: 60.72 1,200.00 1,200.00- Program number: 26 TC WOMEN'S CLUB GRANT FY09-10 60.72 1,200.00 1,200.00- . glbase_tbam rgonzale Trophy Club Entities Page 48 15:46 10/15/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 27 TX FOREST SVC FY09/10-VEHICLE Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-49006-045-027 Grant Match 10,000.00- 10,000.00- 10,000.00 Subtotal: 10,000.00- 10,000.00- 10,000.00 Program number: 27 TX FOREST SVC FY09/10-VEHICLE 10,000.00- 10,000.00- 10,000.00 Department number: Fire 10,000.00- 11,200.00- 11,200.00 Revenues Subtotal ----------- 1,190,429.00- 1,190,429.00- 10,885.03- 1,256,239.99- 105.528 65,810.99 . glbase_tbam rgonzale Trophy Club Entities Page 52 15:46 10/15/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 27 TX FOREST SVC FY09/10-VEHICLE Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-69035-045-027 Vehicles 10,000.00 10,000.00 10,000.00- Subtotal: 10,000.00 10,000.00 10,000.00- Program number: 27 TX FOREST SVC FY09/10-VEHICLE 10,000.00 10,000.00 10,000.00- Department number: Fire 1,190,429.00 1,214,163.00 117,204.82 1,178,428.69 96.350 35,734.31 Expenditures Subtotal ----------- 1,190,429.00 1,214,163.00 117,204.82 1,178,428.69 96.350 35,734.31 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 23,734.00 106,319.79 77,811.30- -364.023 101,545.30 . glbase_tbam rgonzale Trophy Club Entities Page 53 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 09/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- 79.29- 281,849.26- 101.438 3,995.26 135-40015-000-000 Property Taxes/P & I 19.47- 4,464.88- 4,464.88 Subtotal: 277,854.00- 277,854.00- 98.76- 286,314.14- 103.045 8,460.14 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 166,831.00- 1,508,245.19- 89.589 175,279.81- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 97,896.16- 961,009.20- 90.779 97,610.80- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 78,770.26- 665,127.60- 88.828 83,652.40- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 22,897.04- 251,696.47- 75.450 81,898.53- 135-47020-000-000 Standby 1,140.00- 1,140.00- 70.50- 772.60- 67.772 367.40- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 5,810.74- 42,578.61- 77.416 12,421.39- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,276.19- 17,190.84- 107.443 1,190.84 135-47035-000-000 Plumbing Inspections 100.00- 1,050.00- 1,050.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 300.00- 3,225.00- 258.000 1,975.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- 28,365.77- 58,411.21- 97.352 1,588.79- 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- 2,092.52- 21,207.01- 58.664 14,942.99- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 968.08- 12,051.73- 77.753 3,448.27- 135-47410-000-000 Out of Dist/Portable Penalties 200.00- 200.00- 28.70- 730.44- 365.220 530.44 135-47600-000-000 PID #1 Water 201,396.00- 201,396.00- 42,919.82- 198,505.03- 98.565 2,890.97- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 11,683.16- 71,834.89- 119.925 11,934.89 Subtotal: 4,271,056.00- 4,271,056.00- 460,009.94- 3,819,860.82- 89.436 451,195.18- 135-48005-000-000 Utility Fees 52,900.00- 80,500.00- 80,500.00 Subtotal: 52,900.00- 80,500.00- 80,500.00 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 451.00- 2,957.13- 147.857 957.13 135-49015-000-000 Lease/Rental Income 10,164.00- 135-49016-000-000 Cell Tower Revenue 10,164.00- 9,317.00- 91.667 847.00- 135-49018-000-000 Building Rent Income 7,000.00- 583.33- 6,999.96- 99.999 .04- 135-49026-000-000 Revenue from Sale of Asset 7,476.14- 7,476.14 135-49030-000-000 Vending Revenue 850.00- 850.00- 215.00- 1,082.50- 127.353 232.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- 6,400.00- 53,262.50- 147.951 17,262.50 135-49900-000-000 Miscellaneous Income 21,100.00- 14,100.00- 1,099.50- 15,571.38- 110.435 1,471.38 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- 43,530.00- 136.031 11,530.00 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 112.87- 2,113.30- 34.085 4,086.70- Subtotal: 121,024.00- 121,024.00- 8,861.70- 142,585.91- 117.816 21,561.91 Program number: 4,669,934.00- 4,669,934.00- 521,870.40- 4,329,260.87- 92.705 340,673.13- . glbase_tbam rgonzale Trophy Club Entities Page 54 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Revenues 4,669,934.00- 4,669,934.00- 521,870.40- 4,329,260.87- 92.705 340,673.13- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 521,870.40- 4,329,260.87- 92.705 340,673.13- . glbase_tbam rgonzale Trophy Club Entities Page 55 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 159,774.00 159,774.00 14,246.28 121,398.93 75.982 38,375.07 135-50010-010-000 Overtime 8,814.00 8,814.00 875.68 13,423.33 152.296 4,609.33- 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,265.00 84.333 235.00 135-50020-010-000 Retirement 22,360.00 22,360.00 2,020.42 18,746.61 83.840 3,613.39 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,390.70 15,318.68 66.214 7,816.32 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 1,052.88 67.105 516.12 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 192.72 68.340 89.28 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 766.20 68.107 358.80 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 913.62 8,843.87 83.307 1,772.13 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 213.67 2,068.31 83.299 414.69 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 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 153.85 43.957 196.15 Subtotal: 239,884.00 239,884.00 19,943.02 189,715.38 79.086 50,168.62 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 5,078.68 19.533 20,921.32 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 2,280.92 71.727 899.08 135-55100-010-000 Building Maint & Supplies 750.00 750.00 260.48 520.07 69.343 229.93 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 870.00 2,540.40 75.833 809.60 Subtotal: 37,680.00 37,680.00 1,130.48 10,607.71 28.152 27,072.29 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 255.31 1,568.01 77.778 447.99 135-60020-010-000 Electricity 195,000.00 195,000.00 19,046.58 134,840.09 69.149 60,159.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 41.65- 1,178.61 28.062 3,021.39 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 311.00 984.02 35.144 1,815.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 77.50 1,372.70 42.897 1,827.30 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 6,133.95 92.939 466.05 135-60150-010-000 Bulk Water 1,410,000.00 1,393,650.00 162,583.92 980,704.41 70.369 412,945.59 135-60245-010-000 Miscellaneous Expenses 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 12.50 939.34 22.365 3,260.66 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 496.40 24.820 1,503.60 Subtotal: 1,631,316.00 1,614,966.00 182,245.16 1,128,280.55 69.864 486,685.45 . glbase_tbam rgonzale Trophy Club Entities Page 56 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 09/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 609.46 8,823.99 57.992 6,392.01 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 389.74 5,732.86 110.247 532.86- 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 388.13 15.525 2,111.87 135-65050-010-000 Meter Expense 75,000.00 75,000.00 3,945.00 78,277.00 104.369 3,277.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 225.57 8,638.45 28.795 21,361.55 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 5,169.77 102,970.72 76.102 32,335.28 135-69005-010-000 Capital Expenses 38,500.00 294,850.00 1,835.00- 140,070.76 47.506 154,779.24 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 93.353 763.77 Subtotal: 214,011.00 470,361.00 1,835.00- 275,566.78 58.586 194,794.22 Program number: 2,258,197.00 2,498,197.00 206,653.43 1,707,141.14 68.335 791,055.86 Department number: Water 2,258,197.00 2,498,197.00 206,653.43 1,707,141.14 68.335 791,055.86 . glbase_tbam rgonzale Trophy Club Entities Page 57 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 171,607.00 171,607.00 19,800.84 169,539.69 98.795 2,067.31 135-50010-020-000 Overtime 10,166.00 10,166.00 1,555.76 16,315.68 160.493 6,149.68- 135-50016-020-000 Longevity 3,153.00 3,153.00 3,152.50 99.984 .50 135-50017-020-000 Certification 2,550.00 2,550.00 175.00 1,925.00 75.490 625.00 135-50020-020-000 Retirement 24,372.00 24,372.00 2,855.09 25,906.31 106.295 1,534.31- 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 27,503.04 100.000 .04- 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 1,983.36 100.018 .36- 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 357.12 100.034 .12- 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 1,067.40 89.098 130.60 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 1,193.65 10,681.39 107.502 745.39- 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 279.16 2,498.06 107.490 174.06- 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 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 28,435.41 268,228.23 102.510 6,568.23- 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 4,650.00 19,193.59 94.783 1,056.41 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 55.14 673.14 48.081 726.86 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 1,281.25 1,672.70 56.702 1,277.30 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 3,889.00 17,696.64 63.202 10,303.36 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 3,417.75 15,732.75 75.820 5,017.25 Subtotal: 77,892.00 77,892.00 13,293.14 58,929.66 75.656 18,962.34 135-60005-020-000 Telephone 10.00 51.35 513.500 41.35- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 479.62 2,895.86 88.396 380.14 135-60020-020-000 Electricity 230,000.00 230,000.00 18,586.90 187,022.95 81.314 42,977.05 135-60025-020-000 Water 1,600.00 1,600.00 194.18 1,843.20 115.200 243.20- 135-60035-020-000 Postage 120.00 120.00 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 220.00 2,149.70 171.976 899.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 31.96 222.37 42.356 302.63 Subtotal: 247,016.00 247,016.00 19,512.66 202,119.30 81.824 44,896.70 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 3,828.48 6,734.04 178.385 2,959.04- . glbase_tbam rgonzale Trophy Club Entities Page 58 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 09/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 140.61 16,654.68 168.229 6,754.68- 135-65035-020-000 Small Tools 1,260.00 1,260.00 19.96 535.57 42.506 724.43 135-65040-020-000 Safety Equipment 540.00 540.00 50.10 636.90 117.944 96.90- 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 49.51 5,159.34 84.788 925.66 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 18.98 3,167.60 23.888 10,092.40 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 4,107.64 33,882.86 89.025 4,177.14 135-69005-020-000 Capital Expenses 144,689.00 144,689.00 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 133,683.64 68.036 62,805.36 Program number: 821,117.00 821,117.00 65,348.85 696,843.69 84.865 124,273.31 Department number: Wastewater 821,117.00 821,117.00 65,348.85 696,843.69 84.865 124,273.31 . glbase_tbam rgonzale Trophy Club Entities Page 59 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 132,345.00 132,313.00 15,270.54 130,861.49 98.903 1,451.51 135-50010-021-000 Overtime 14,145.00 14,145.00 1,797.19 11,881.82 84.000 2,263.18 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,375.00 114.583 175.00- 135-50020-021-000 Retirement 19,575.00 19,575.00 2,279.75 19,939.33 101.861 364.33- 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 18,042.72 99.998 .28 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 1,426.56 100.039 .56- 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 222.24 107.883 16.24- 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 811.92 88.832 102.08 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 1,000.75 8,741.20 104.111 345.20- 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 234.05 2,044.32 104.090 80.32- 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 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 22,415.90 202,132.86 98.745 2,569.14 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 86.50 3,563.39 35.634 6,436.61 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 86.50 4,548.03 31.327 9,969.97 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 408.57 2,323.52 110.015 211.52- 135-60020-021-000 Electricity 22,250.00 22,250.00 1,513.87 21,161.35 95.107 1,088.65 135-60025-021-000 Water 750.00 750.00 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 69.00 180.00 70.588 75.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 221.75 700.50 46.700 799.50 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 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 2,213.19 61,964.20 87.662 8,720.80 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 766.34 11,427.27 106.797 727.27- 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 820.95 820.95 54.730 679.05 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 187.47 16.302 962.53 135-65055-021-000 Hardware 750.00 750.00 750.00 . glbase_tbam rgonzale Trophy Club Entities Page 60 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 09/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 14.29 217.00 1.352 15,833.00 Subtotal: 42,655.00 42,655.00 1,601.58 26,331.64 61.732 16,323.36 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 10,552.00 52.760 9,448.00 Subtotal: 30,000.00 30,000.00 10,552.00 35.173 19,448.00 Program number: 362,560.00 362,560.00 26,317.17 305,528.73 84.270 57,031.27 Department number: Collection 362,560.00 362,560.00 26,317.17 305,528.73 84.270 57,031.27 . glbase_tbam rgonzale Trophy Club Entities Page 61 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 09/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,700.00 12,000.00 80.000 3,000.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 105.40 787.40 61.039 502.60 135-50035-026-000 Medicare Taxes 302.00 302.00 24.65 184.15 60.977 117.85 135-50040-026-000 Unemployment Taxes 375.00 375.00 35.70 213.90 57.040 161.10 135-50045-026-000 Workman's Compensation 120.00 120.00 114.36 95.300 5.64 Subtotal: 17,087.00 17,087.00 1,865.75 13,299.81 77.836 3,787.19 135-55045-026-000 Legal 32,500.00 135-55060-026-000 Appraisal 18,874.00 135-55065-026-000 Tax Admin Fees 2,380.00 Subtotal: 53,754.00 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 44.00 453.91 75.652 146.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 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 493.75 60.213 326.25 135-60245-026-000 Miscellaneous Expenses 300.00 196.00 22.54 11.500 173.46 Subtotal: 20,792.00 20,688.00 44.00 9,482.08 45.834 11,205.92 135-65085-026-000 Office Supplies 200.00 200.00 134.90 67.450 65.10 Subtotal: 200.00 200.00 134.90 67.450 65.10 Program number: 91,833.00 37,975.00 1,909.75 22,916.79 60.347 15,058.21 Department number: Board of Directors 91,833.00 37,975.00 1,909.75 22,916.79 60.347 15,058.21 . glbase_tbam rgonzale Trophy Club Entities Page 62 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 09/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 31,174.36 255,016.44 102.211 5,517.44- 135-50010-027-000 Overtime 1,750.00 1,750.00 39.53 2,743.37 156.764 993.37- 135-50016-027-000 Longevity 3,056.00 3,056.00 3,056.25 100.008 .25- 135-50020-027-000 Retirement 32,982.00 32,982.00 4,091.73 35,366.47 107.230 2,384.47- 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 22,316.66 99.998 .34 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.52 1,446.21 100.015 .21- 135-50028-027-000 Vision Insurance 269.00 269.00 22.36 268.37 99.766 .63 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 1,279.71 85.257 221.29 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,878.52 16,275.39 105.281 816.39- 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 439.33 3,806.30 105.292 191.30- 135-50040-027-000 Unemployment Taxes 304.00 304.00 7.48 774.29 254.701 470.29- 135-50045-027-000 Workman's Compensation 671.00 671.00 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 39,738.81 344,459.39 103.222 10,752.39- 135-55070-027-000 Independent Labor 720.00 720.00 56.25 592.50 82.292 127.50 135-55075-027-000 Records Management 100.00 100.00 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 56.25 1,137.61 62.506 682.39 135-60005-027-000 Telephone 265.00 265.00 21.28 248.45 93.755 16.55 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 373.45 2,815.88 101.473 40.88- 135-60035-027-000 Postage 1,071.00 1,071.00 205.50 1,479.94 138.183 408.94- 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 70.00 1,378.66 82.406 294.34 135-60075-027-000 Meetings 961.00 961.00 467.04 48.599 493.96 135-60080-027-000 Schools & Training 2,715.00 2,715.00 680.00 1,751.00 64.494 964.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 1.80 1,814.37 86.646 279.63 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 73.80 340.80 52.431 309.20 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 100.000 135-60271-027-000 Town 25th Anniversary 2,500.00 2,500.00- 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 1,485.66 2,419.12 138.235 669.12- Subtotal: 27,904.00 27,904.00 2,911.49 28,263.58 101.289 359.58- 135-65085-027-000 Office Supplies 2,450.00 2,450.00 148.40 2,173.33 88.707 276.67 135-65105-027-000 Printing 515.00 515.00 84.65 16.437 430.35 Subtotal: 2,965.00 2,965.00 148.40 2,257.98 76.154 707.02 . glbase_tbam rgonzale Trophy Club Entities Page 63 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 09/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 42,854.95 376,118.56 102.654 9,722.56- Department number: Manager's Office 366,396.00 366,396.00 42,854.95 376,118.56 102.654 9,722.56- . glbase_tbam rgonzale Trophy Club Entities Page 64 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-028-000 Salaries & Wages 25,698.00 25,698.00 2,965.20 25,415.98 98.903 282.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 393.20 3,475.57 103.656 122.57- 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 2,668.60 99.985 .40 135-50027-028-000 Dental Insurance 155.00 155.00 12.92 154.95 99.968 .05 135-50028-028-000 Vision Insurance 30.00 30.00 2.48 29.82 99.400 .18 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 162.84 88.500 21.16 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 183.84 1,659.46 104.566 72.46- 135-50035-028-000 Medicare Taxes 371.00 371.00 42.98 388.05 104.596 17.05- 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 77.84 114.471 9.84- 135-50070-028-000 Employee Relations 1,625.00 1,625.00 32.64 1,261.91 77.656 363.09 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 170.47 11.365 1,329.53 135-50994-028-000 Employee Assistance Program 201.60 1,131.20 1,131.20- 135-50995-028-000 Flexible Benefits Admin Fee 90.21 1,881.92 1,881.92- Subtotal: 37,372.00 37,372.00 4,161.02 38,670.61 103.475 1,298.61- 135-60005-028-000 Telephone 26.00 26.00 .72 6.54 25.154 19.46 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 32.19 184.29 87.757 25.71 135-60035-028-000 Postage 102.00 102.00 106.90 104.804 4.90- 135-60046-028-000 Prompt Payment Act Interest .09 .09 .09- 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 270.98 53.766 233.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 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 516.57 844.57 87.976 115.43 Subtotal: 2,919.00 2,919.00 549.57 2,074.87 71.082 844.13 135-65085-028-000 Office Supplies 412.00 412.00 4.49 74.23 18.017 337.77 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 4.49 74.23 14.220 447.77 Program number: 40,813.00 40,813.00 4,715.08 40,819.71 100.016 6.71- Department number: Human Resources 40,813.00 40,813.00 4,715.08 40,819.71 100.016 6.71- . glbase_tbam rgonzale Trophy Club Entities Page 65 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 09/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 12,373.34 113,980.73 89.427 13,476.27 135-50010-029-000 Overtime 2,000.00 5,683.00 289.66 6,160.86 108.409 477.86- 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,679.09 16,577.99 98.054 329.01 135-50026-029-000 Medical Insurance 10,550.00 9,550.00 743.19 10,008.90 104.805 458.90- 135-50027-029-000 Dental Insurance 765.00 765.00 55.98 693.63 90.671 71.37 135-50028-029-000 Vision Insurance 127.00 127.00 8.07 108.02 85.055 18.98 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 615.29 74.131 214.71 135-50030-029-000 Social Security Taxes 8,265.00 7,965.00 729.79 7,219.04 90.635 745.96 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 170.69 1,688.37 87.345 244.63 135-50040-029-000 Unemployment Taxes 135.00 382.00 13.53 394.74 103.335 12.74- 135-50045-029-000 Workman's Compensation 365.00 565.00 456.22 80.747 108.78 135-50060-029-000 Pre-emp Physicals/Testing 100.00 20.00 64.44 64.440 35.56 Subtotal: 179,397.00 173,134.00 16,129.47 158,838.23 91.743 14,295.77 135-55055-029-000 Auditing 40,000.00 135-55160-029-000 Professional Outside Services 8,705.00 2,712.50 9,211.12 105.814 506.12- Subtotal: 40,000.00 8,705.00 2,712.50 9,211.12 105.814 506.12- 135-60005-029-000 Telephone 103.00 103.00 17.92 105.97 102.883 2.97- 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 52.84 381.22 75.340 124.78 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 35.67 14.268 214.33 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 1,345.85 98.887 15.15 135-60075-029-000 Meetings 66.00 66.00 11.00 88.00 133.333 22.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 16.29 1,095.85 67.024 539.15 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 464.54 869.78 214.232 463.78- Subtotal: 7,266.00 7,567.00 562.59 4,801.50 63.453 2,765.50 135-65085-029-000 Office Supplies 800.00 657.00 154.40 668.78 101.793 11.78- 135-65105-029-000 Printing 900.00 900.00 524.20 524.20 58.244 375.80 Subtotal: 1,700.00 1,557.00 678.60 1,192.98 76.620 364.02 Program number: 228,363.00 190,963.00 20,083.16 174,043.83 91.140 16,919.17 Department number: Finance 228,363.00 190,963.00 20,083.16 174,043.83 91.140 16,919.17 . glbase_tbam rgonzale Trophy Club Entities Page 66 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-033-000 Salaries & Wages 58,883.00 58,883.00 6,794.12 58,235.39 98.900 647.61 135-50016-033-000 Longevity 278.00 338.00 337.50 99.852 .50 135-50020-033-000 Retirement 7,691.00 7,691.00 900.89 7,977.40 103.724 286.40- 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.68 4,928.25 100.005 .25- 135-50027-033-000 Dental Insurance 310.00 310.00 25.82 309.79 99.932 .21 135-50028-033-000 Vision Insurance 60.00 60.00 4.96 59.60 99.333 .40 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 340.80 88.750 43.20 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 421.22 3,809.22 103.850 141.22- 135-50035-033-000 Medicare Taxes 858.00 858.00 98.51 890.79 103.822 32.79- 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 178.60 114.487 22.60- Subtotal: 77,284.00 77,344.00 8,684.60 77,256.32 99.887 87.68 135-55030-033-000 Software & Support 56,190.00 56,130.00 4,529.20 46,545.44 82.924 9,584.56 135-55070-033-000 Independent Labor 1,464.00 1,464.00 187.50 1,934.38 132.130 470.38- Subtotal: 57,654.00 57,594.00 4,716.70 48,479.82 84.175 9,114.18 135-60005-033-000 Telephone 20,520.00 20,520.00 897.16 12,024.51 58.599 8,495.49 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 117.49 899.76 83.234 181.24 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 32.25 373.82 25.534 1,090.18 135-60235-033-000 Security 1,902.00 1,902.00 929.25 1,844.12 96.957 57.88 Subtotal: 27,120.00 27,120.00 1,976.15 16,134.59 59.493 10,985.41 135-65055-033-000 Hardware 36,682.00 36,682.00 4,060.16 32,026.25 87.308 4,655.75 135-65085-033-000 Office Supplies 300.00 300.00 104.05 345.56 115.187 45.56- 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 854.33 3,989.28 82.338 855.72 135-65105-033-000 Printing 100.00 100.00 16.68 16.68 16.680 83.32 Subtotal: 41,927.00 41,927.00 5,035.22 36,377.77 86.765 5,549.23 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 3,006.19 87.136 443.81 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 30,361.00 30,361.00 273.29 29,917.19 98.538 443.81 Program number: 234,346.00 234,346.00 20,685.96 208,165.69 88.828 26,180.31 . glbase_tbam rgonzale Trophy Club Entities Page 67 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 09/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 20,685.96 208,165.69 88.828 26,180.31 . glbase_tbam rgonzale Trophy Club Entities Page 68 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 09/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 431.21 3,990.88 60.514 2,604.12 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 559.50 8,044.82 89.387 955.18 Subtotal: 20,400.00 15,595.00 990.71 12,035.70 77.177 3,559.30 135-60020-037-000 Electricity 19,900.00 19,900.00 1,429.01 15,315.84 76.964 4,584.16 135-60025-037-000 Water 1,030.00 1,030.00 39.80 635.70 61.718 394.30 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 13,182.12 100.001 .12- 135-60055-037-000 Insurance 29,601.00 34,406.00 34,854.71 101.304 448.71- Subtotal: 63,713.00 68,518.00 2,567.32 63,988.37 93.389 4,529.63 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 252.87 1,697.27 84.864 302.73 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 72.22 760.83 76.083 239.17 Subtotal: 3,000.00 3,000.00 325.09 2,458.10 81.937 541.90 Program number: 87,113.00 87,113.00 3,883.12 78,482.17 90.092 8,630.83 Department number: Facilities Maintenance 87,113.00 87,113.00 3,883.12 78,482.17 90.092 8,630.83 . glbase_tbam rgonzale Trophy Club Entities Page 69 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 79,238.00 79,238.00 9,496.82 78,334.00 98.859 904.00 135-50010-038-000 Overtime 750.00 750.00 3.67 1,167.93 155.724 417.93- 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 1,211.43 10,798.39 103.611 376.39- 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 10,674.72 99.997 .28 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 826.56 100.068 .56- 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 132.96 99.970 .04 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 495.96 88.882 62.04 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 580.72 5,078.76 103.227 158.76- 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 135.82 1,187.78 103.195 36.78- 135-50040-038-000 Unemployment Taxes 135.00 135.00 7.66 385.66 285.674 250.66- 135-50045-038-000 Workman's Compensation 212.00 212.00 242.72 114.491 30.72- 135-50060-038-000 Pre-emp Physicals/Testing 53.95 53.95 53.95- Subtotal: 109,205.00 109,205.00 12,500.92 109,564.39 100.329 359.39- 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 853.23 9,687.65 88.070 1,312.35 Subtotal: 11,800.00 11,800.00 853.23 9,687.65 82.099 2,112.35 135-60005-038-000 Telephone 75.00 75.00 7.63 99.14 132.187 24.14- 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 74.69 389.44 92.724 30.56 135-60035-038-000 Postage 15,820.00 15,820.00 1,287.61 15,548.91 98.286 271.09 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 12,388.96 82.593 2,611.04 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 486.00 60.750 314.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,369.93 46,086.54 86.971 6,904.46 135-65085-038-000 Office Supplies 700.00 700.00 118.58 640.32 91.474 59.68 135-65105-038-000 Printing 4,500.00 4,500.00 72.90 914.52 20.323 3,585.48 Subtotal: 5,200.00 5,200.00 191.48 1,554.84 29.901 3,645.16 Program number: 179,196.00 179,196.00 14,915.56 166,893.42 93.135 12,302.58 Department number: Utility Billing 179,196.00 179,196.00 14,915.56 166,893.42 93.135 12,302.58 . glbase_tbam rgonzale Trophy Club Entities Page 70 15:46 10/15/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 39 Non Departmental Program: Period Ending: 09/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 8,182.35 66,842.32 205.669 34,342.32- 135-55055-039-000 Auditing 37,400.00 33,591.00 89.816 3,809.00 135-55060-039-000 Appraisal 18,374.00 3,147.71 16,228.20 88.322 2,145.80 135-55065-039-000 Tax Admin Fees 2,984.00 2,983.33 99.978 .67 Subtotal: 91,258.00 11,330.06 119,644.85 131.106 28,386.85- Program number: 91,258.00 11,330.06 119,644.85 131.106 28,386.85- Department number: Non Departmental 91,258.00 11,330.06 119,644.85 131.106 28,386.85- Expenditures Subtotal ----------- 4,669,934.00 4,909,934.00 418,697.09 3,896,598.58 79.362 1,013,335.42 Fund number: 135 MUD 1 O&M CONSOLIDATED 240,000.00 103,173.31- 432,662.29- -180.276 672,662.29 . glbase_tbam rgonzale Trophy Club Entities Page 82 15:46 10/15/10 Budget Summary with Amendment Fund: 315 MUD 1 CIP FIRE STATION Department: Revenues Program: Period Ending: 09/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 142.39- 3,187.04- 3,187.04 Subtotal: 142.39- 3,187.04- 3,187.04 Program number: 142.39- 3,187.04- 3,187.04 Department number: Revenues 142.39- 3,187.04- 3,187.04 Revenues Subtotal ----------- 142.39- 3,187.04- 3,187.04 Fund number: 315 MUD 1 CIP FIRE STATION 142.39- 3,187.04- 3,187.04 . glbase_tbam rgonzale Trophy Club Entities Page 106 15:46 10/15/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 09/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- 179.76- 726,324.32- 103.272 23,014.32 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 49.30- 14,094.80- 156.609 5,094.80 Subtotal: 712,310.00- 712,310.00- 229.06- 740,419.12- 103.946 28,109.12 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 345,000.00- 100.000 Subtotal: 345,000.00- 345,000.00- 345,000.00- 100.000 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 48.39- 4,848.37- 242.419 2,848.37 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- 48.39- 313,848.37- 101.241 3,848.37 Program number: 1,367,310.00- 1,367,310.00- 277.45- 1,399,267.49- 102.337 31,957.49 Department number: Revenues 1,367,310.00- 1,367,310.00- 277.45- 1,399,267.49- 102.337 31,957.49 Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 277.45- 1,399,267.49- 102.337 31,957.49 . glbase_tbam rgonzale Trophy Club Entities Page 107 15:46 10/15/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 09/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 3,259.50 81.488 740.50 533-70025-051-000 Bond Interest Expense 308,310.00 308,310.00 308,310.00 100.000 533-70035-051-000 Bond Principal Payment 1,055,000.00 1,055,000.00 1,055,000.00 100.000 Subtotal: 1,367,310.00 1,367,310.00 1,366,569.50 99.946 740.50 Program number: 1,367,310.00 1,367,310.00 1,366,569.50 99.946 740.50 Department number: Administration 1,367,310.00 1,367,310.00 1,366,569.50 99.946 740.50 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 1,366,569.50 99.946 740.50