Loading...
HomeMy WebLinkAboutNovember 2009 Budget Summary-Consolidation . glbase_tbam rgonzale Trophy Club Entities Page 62 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 11/2009 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- 14,251.89- 14,304.71- 5.148 263,549.29- 135-40015-000-000 Property Taxes/P & I 620.98- 627.40- 627.40 Subtotal: 277,854.00- 277,854.00- 14,872.87- 14,932.11- 5.374 262,921.89- 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 84,087.11- 177,990.07- 10.572 1,505,534.93- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 70,413.31- 147,535.65- 13.937 911,084.35- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 45,114.32- 96,590.52- 12.900 652,189.48- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 20,157.32- 35,678.71- 10.695 297,916.29- 135-47020-000-000 Standby 1,140.00- 1,140.00- 71.00- 136.00- 11.930 1,004.00- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 3,255.60- 7,819.75- 14.218 47,180.25- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,827.98- 6,039.15- 37.745 9,960.85- 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 1,250.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 3,935.91- 6.560 56,064.09- 135-47270-000-000 Fire Line 2,100.00- 2,100.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 12,715.83- 13,622.55- 37.683 22,527.45- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 681.04- 1,241.49- 8.010 14,258.51- 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- 9,765.37- 23,757.40- 11.796 177,638.60- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 3,274.06- 6,335.09- 10.576 53,564.91- Subtotal: 4,271,056.00- 4,271,056.00- 251,362.94- 523,484.03- 12.257 3,747,571.97- 135-48005-000-000 Utility Fees 32,200.00- 66,700.00- 66,700.00 Subtotal: 32,200.00- 66,700.00- 66,700.00 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 155.93- 331.00- 16.550 1,669.00- 135-49015-000-000 Lease/Rental Income 10,164.00- 10,164.00- 847.00- 1,694.00- 16.667 8,470.00- 135-49030-000-000 Vending Revenue 850.00- 850.00- 850.00- 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 12,710.00- 135-49075-000-000 New Oversize Meter Reimburse 36,000.00- 36,000.00- 4,096.00- 7,936.00- 22.044 28,064.00- 135-49900-000-000 Miscellaneous Income 21,100.00- 21,100.00- 740.26- 1,682.26- 7.973 19,417.74- 135-49901-000-000 Records Management Revenue 158.00- 158.00- 158.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 3,522.50- 6,257.50- 19.555 25,742.50- 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 132.09- 132.09- 2.130 6,067.91- Subtotal: 121,024.00- 121,024.00- 9,651.78- 18,190.85- 15.031 102,833.15- Program number: 4,669,934.00- 4,669,934.00- 308,087.59- 623,306.99- 13.347 4,046,627.01- Department number: Revenues 4,669,934.00- 4,669,934.00- 308,087.59- 623,306.99- 13.347 4,046,627.01- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 308,087.59- 623,306.99- 13.347 4,046,627.01- . glbase_tbam rgonzale Trophy Club Entities Page 63 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 11/2009 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,386.64 23,268.25 14.563 136,505.75 135-50010-010-000 Overtime 8,814.00 8,814.00 1,387.10 3,193.05 36.227 5,620.95 135-50016-010-000 Longevity 1,910.00 1,910.00 1,910.00 1,910.00 100.000 135-50017-010-000 Certification 1,500.00 1,500.00 115.00 115.00 7.667 1,385.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,562.73 3,478.18 15.555 18,881.82 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 2,532.36 10.946 20,602.64 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 175.48 11.184 1,393.52 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 32.12 11.390 249.88 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 127.70 11.351 997.30 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 785.62 1,750.33 16.488 8,865.67 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 183.72 409.34 16.486 2,073.66 135-50040-010-000 Unemployment Taxes 270.00 270.00 270.00 135-50045-010-000 Workman's Compensation 5,496.00 5,496.00 1,573.00 28.621 3,923.00 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 103.00 29.429 247.00 Subtotal: 239,884.00 239,884.00 16,764.64 38,667.81 16.119 201,216.19 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 146.77 .565 25,853.23 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 863.06 1,653.05 51.983 1,526.95 135-55100-010-000 Building Maint & Supplies 750.00 750.00 750.00 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 48.80 48.80 1.683 2,851.20 135-55135-010-000 Lab Analysis 3,350.00 3,350.00 182.00 5.433 3,168.00 Subtotal: 37,680.00 37,680.00 911.86 2,030.62 5.389 35,649.38 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 93.43 4.634 1,922.57 135-60020-010-000 Electricity 195,000.00 195,000.00 7,706.54 12,061.01 6.185 182,938.99 135-60035-010-000 Postage 100.00 100.00 10.90 10.90 10.900 89.10 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 4,200.00 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 50.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 135-60080-010-000 Schools & Training 2,800.00 2,800.00 111.00 111.00 3.964 2,689.00 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 160.05 326.15 10.192 2,873.85 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 6,133.95 92.939 466.05 135-60150-010-000 Bulk Water 1,410,000.00 1,410,000.00 63,760.30 4.522 1,346,239.70 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 22.00 22.00 .524 4,178.00 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 1,631,316.00 1,631,316.00 14,144.44 82,518.74 5.058 1,548,797.26 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,378.00 1,378.00 9.056 13,838.00 . glbase_tbam rgonzale Trophy Club Entities Page 64 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 11/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-010-000 Uniforms 3,690.00 3,690.00 3,690.00 135-65030-010-000 Chemicals 5,200.00 5,200.00 389.74 1,269.48 24.413 3,930.52 135-65035-010-000 Small Tools 2,500.00 2,500.00 75.84 115.82 4.633 2,384.18 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 2,500.00 135-65050-010-000 Meter Expense 75,000.00 75,000.00 5,060.00 6.747 69,940.00 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65095-010-000 Maintenance Supplies 30,000.00 30,000.00 160.21 160.21 .534 29,839.79 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 2,003.79 7,983.51 5.900 127,322.49 135-69005-010-000 Capital Expenses 38,500.00 38,500.00 38,500.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69235-010-000 Variable Speed Pump 1,785.00 1,785.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 69,788.02 69,788.02 55.933 54,982.98 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 11,490.00 Subtotal: 214,011.00 214,011.00 69,788.02 71,573.02 33.444 142,437.98 Program number: 2,258,197.00 2,258,197.00 103,612.75 202,773.70 8.979 2,055,423.30 Department number: Water 2,258,197.00 2,258,197.00 103,612.75 202,773.70 8.979 2,055,423.30 . glbase_tbam rgonzale Trophy Club Entities Page 65 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 11/2009 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 32,747.52 19.083 138,859.48 135-50010-020-000 Overtime 10,166.00 10,166.00 657.34 3,031.11 29.816 7,134.89 135-50016-020-000 Longevity 3,153.00 3,153.00 3,152.50 3,152.50 99.984 .50 135-50017-020-000 Certification 2,550.00 2,550.00 175.00 175.00 6.863 2,375.00 135-50020-020-000 Retirement 24,372.00 24,372.00 2,098.33 4,774.85 19.592 19,597.15 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 4,583.84 16.667 22,919.16 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 330.56 16.670 1,652.44 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 59.52 16.672 297.48 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 177.90 14.850 1,020.10 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 924.19 2,141.96 21.558 7,794.04 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 216.15 500.95 21.556 1,823.05 135-50040-020-000 Unemployment Taxes 270.00 270.00 270.00 135-50045-020-000 Workman's Compensation 5,991.00 5,991.00 1,714.67 28.621 4,276.33 135-50070-020-000 Employee Relations 250.00 250.00 250.00 Subtotal: 261,660.00 261,660.00 22,999.98 53,390.38 20.404 208,269.62 135-55005-020-000 Engineering 1,500.00 1,500.00 1,500.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 1,718.60 1,757.87 8.681 18,492.13 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 50.55 130.05 5.674 2,161.95 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 1,400.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 40.43 303.53 10.289 2,646.47 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 276.50 1,511.80 5.399 26,488.20 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,207.00 1,207.00 5.817 19,543.00 Subtotal: 77,892.00 77,892.00 3,293.08 4,910.25 6.304 72,981.75 135-60005-020-000 Telephone 3.14 4.94 4.94- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 197.30 6.023 3,078.70 135-60020-020-000 Electricity 230,000.00 230,000.00 14,316.86 20,023.10 8.706 209,976.90 135-60025-020-000 Water 1,600.00 1,600.00 57.70 3.606 1,542.30 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60080-020-000 Schools & Training 1,320.00 1,320.00 1,320.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 103.40 361.35 28.908 888.65 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 200.00 135-60135-020-000 Annual Permit Fee 7,500.00 7,500.00 7,432.50 99.100 67.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 525.00 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 247,016.00 247,016.00 14,423.40 28,076.89 11.366 218,939.11 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 487.01 487.01 12.901 3,287.99 . glbase_tbam rgonzale Trophy Club Entities Page 66 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 11/2009 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 2,205.00 135-65030-020-000 Chemicals 9,900.00 9,900.00 3,569.32 36.054 6,330.68 135-65035-020-000 Small Tools 1,260.00 1,260.00 186.97 14.839 1,073.03 135-65040-020-000 Safety Equipment 540.00 540.00 52.35 172.31 31.909 367.69 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 1,247.39 20.499 4,837.61 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 400.00 135-65095-020-000 Maintenance Supplies 13,260.00 13,260.00 387.05 536.32 4.045 12,723.68 135-65115-020-000 Other Consumables 110.00 110.00 5.44 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 931.85 6,204.76 16.303 31,855.24 135-69005-020-000 Capital Expenses 144,689.00 144,689.00 144,689.00 135-69280-020-000 Capital Repairs 51,800.00 51,800.00 6,570.00 12.683 45,230.00 Subtotal: 196,489.00 196,489.00 6,570.00 3.344 189,919.00 Program number: 821,117.00 821,117.00 41,648.31 99,152.28 12.075 721,964.72 Department number: Wastewater 821,117.00 821,117.00 41,648.31 99,152.28 12.075 721,964.72 . glbase_tbam rgonzale Trophy Club Entities Page 67 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 11/2009 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,345.00 10,178.82 25,252.84 19.081 107,092.16 135-50010-021-000 Overtime 14,145.00 14,145.00 561.80 1,579.38 11.166 12,565.62 135-50016-021-000 Longevity 2,888.00 2,888.00 2,920.00 2,920.00 101.108 32.00- 135-50017-021-000 Certification 1,200.00 1,200.00 125.00 125.00 10.417 1,075.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,683.23 3,648.00 18.636 15,927.00 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 3,007.12 16.666 15,035.88 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 237.76 16.673 1,188.24 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 37.04 17.981 168.96 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 135.32 14.805 778.68 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 789.51 1,721.99 20.510 6,674.01 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 184.64 402.72 20.505 1,561.28 135-50040-021-000 Unemployment Taxes 203.00 203.00 203.00 135-50045-021-000 Workman's Compensation 3,147.00 3,147.00 900.69 28.621 2,246.31 135-50070-021-000 Employee Relations 250.00 250.00 250.00 Subtotal: 204,702.00 204,702.00 18,151.62 39,967.86 19.525 164,734.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 570.24 2,119.72 21.197 7,880.28 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 39.75 741.79 35.870 1,326.21 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 14,518.00 14,518.00 609.99 2,861.51 19.710 11,656.49 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 43.03 216.69 10.260 1,895.31 135-60020-021-000 Electricity 22,250.00 22,250.00 1,706.70 2,269.36 10.199 19,980.64 135-60025-021-000 Water 750.00 750.00 3.12 .416 746.88 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 111.00 43.529 144.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 90.00 3.194 2,728.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 45.10 141.90 9.460 1,358.10 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 39,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 70,685.00 70,685.00 1,794.83 2,832.07 4.007 67,852.93 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 1,480.62 1,480.62 13.838 9,219.38 135-65010-021-000 Uniforms 2,505.00 2,505.00 2,505.00 135-65030-021-000 Chemicals 10,000.00 10,000.00 10,000.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 1,150.00 135-65055-021-000 Hardware 750.00 750.00 750.00 . glbase_tbam rgonzale Trophy Club Entities Page 68 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 11/2009 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 16,050.00 Subtotal: 42,655.00 42,655.00 1,480.62 1,480.62 3.471 41,174.38 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 22,037.06 47,142.06 13.003 315,417.94 Department number: Collection 362,560.00 362,560.00 22,037.06 47,142.06 13.003 315,417.94 . glbase_tbam rgonzale Trophy Club Entities Page 69 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 11/2009 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,000.00 2,300.00 15.333 12,700.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 62.00 142.60 11.054 1,147.40 135-50035-026-000 Medicare Taxes 302.00 302.00 14.50 33.35 11.043 268.65 135-50040-026-000 Unemployment Taxes 375.00 375.00 5.00 11.50 3.067 363.50 135-50045-026-000 Workman's Compensation 120.00 120.00 34.34 28.617 85.66 Subtotal: 17,087.00 17,087.00 1,081.50 2,521.79 14.759 14,565.21 135-55045-026-000 Legal 32,500.00 32,500.00 2,806.40 8.635 29,693.60 135-55060-026-000 Appraisal 18,874.00 18,874.00 18,874.00 135-55065-026-000 Tax Admin Fees 2,380.00 2,380.00 2,380.00 Subtotal: 53,754.00 53,754.00 2,806.40 5.221 50,947.60 135-60066-026-000 Publications/Books/Subscripts 54.00 54.00 54.00 135-60070-026-000 Dues & Memberships 1,096.00 1,096.00 550.00 550.00 50.182 546.00 135-60075-026-000 Meetings 600.00 600.00 66.61 11.102 533.39 135-60080-026-000 Schools & Training 5,775.00 5,775.00 5,775.00 135-60100-026-000 Travel & per diem 12,147.00 12,147.00 12,147.00 135-60125-026-000 Advertising 820.00 820.00 820.00 135-60245-026-000 Miscellaneous Expenses 300.00 300.00 300.00 Subtotal: 20,792.00 20,792.00 550.00 616.61 2.966 20,175.39 135-65085-026-000 Office Supplies 200.00 200.00 7.50 7.50 3.750 192.50 Subtotal: 200.00 200.00 7.50 7.50 3.750 192.50 Program number: 91,833.00 91,833.00 1,639.00 5,952.30 6.482 85,880.70 Department number: Board of Directors 91,833.00 91,833.00 1,639.00 5,952.30 6.482 85,880.70 . glbase_tbam rgonzale Trophy Club Entities Page 70 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 11/2009 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 19,239.30 47,572.62 19.067 201,926.38 135-50010-027-000 Overtime 1,750.00 1,750.00 279.24 840.48 48.027 909.52 135-50016-027-000 Longevity 3,056.00 3,056.00 3,056.25 3,056.25 100.008 .25- 135-50020-027-000 Retirement 32,982.00 32,982.00 2,734.01 6,253.20 18.959 26,728.80 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 3,719.44 16.666 18,597.56 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.51 241.03 16.669 1,204.97 135-50028-027-000 Vision Insurance 269.00 269.00 22.36 44.72 16.625 224.28 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 110.79 221.58 14.762 1,279.42 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,342.89 3,077.60 19.908 12,381.40 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 314.07 719.77 19.911 2,895.23 135-50040-027-000 Unemployment Taxes 304.00 304.00 .92 1.28 .421 302.72 135-50045-027-000 Workman's Compensation 671.00 671.00 192.05 28.621 478.95 135-50070-027-000 Employee Relations 838.00 838.00 16.93 2.020 821.07 Subtotal: 333,707.00 333,707.00 29,080.06 65,956.95 19.765 267,750.05 135-55070-027-000 Independent Labor 720.00 720.00 37.50 67.50 9.375 652.50 135-55075-027-000 Records Management 100.00 100.00 100.00 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 37.50 194.37 10.680 1,625.63 135-60005-027-000 Telephone 265.00 265.00 15.92 28.81 10.872 236.19 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 43.01 295.80 10.659 2,479.20 135-60035-027-000 Postage 1,071.00 1,071.00 60.24 121.27 11.323 949.73 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 17.50 17.50 5.000 332.50 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 230.00 462.66 27.655 1,210.34 135-60075-027-000 Meetings 961.00 961.00 22.00 2.289 939.00 135-60080-027-000 Schools & Training 2,715.00 2,715.00 155.00 267.50 9.853 2,447.50 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 23.93 552.87 26.403 1,541.13 135-60115-027-000 Elections 3,500.00 3,500.00 3,500.00 135-60125-027-000 Advertising 650.00 650.00 650.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 1,750.00 Subtotal: 27,904.00 27,904.00 545.60 1,768.41 6.337 26,135.59 135-65085-027-000 Office Supplies 2,450.00 2,450.00 142.87 449.17 18.333 2,000.83 135-65105-027-000 Printing 515.00 515.00 515.00 Subtotal: 2,965.00 2,965.00 142.87 449.17 15.149 2,515.83 Program number: 366,396.00 366,396.00 29,806.03 68,368.90 18.660 298,027.10 . glbase_tbam rgonzale Trophy Club Entities Page 71 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 11/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 366,396.00 366,396.00 29,806.03 68,368.90 18.660 298,027.10 . glbase_tbam rgonzale Trophy Club Entities Page 72 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 11/2009 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.79 4,922.60 19.156 20,775.40 135-50016-028-000 Longevity 98.00 98.00 97.50 97.50 99.490 .50 135-50020-028-000 Retirement 3,353.00 3,353.00 253.26 612.95 18.281 2,740.05 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 444.76 16.664 2,224.24 135-50027-028-000 Dental Insurance 155.00 155.00 12.92 25.85 16.677 129.15 135-50028-028-000 Vision Insurance 30.00 30.00 2.47 4.96 16.533 25.04 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 27.14 14.750 156.86 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 128.62 311.27 19.614 1,275.73 135-50035-028-000 Medicare Taxes 371.00 371.00 30.07 72.80 19.623 298.20 135-50040-028-000 Unemployment Taxes 34.00 34.00 34.00 135-50045-028-000 Workman's Compensation 68.00 68.00 19.46 28.618 48.54 135-50070-028-000 Employee Relations 1,625.00 1,625.00 582.85 678.95 41.782 946.05 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 135-50994-028-000 Employee Assistance Program 103.60 207.20 207.20- 135-50995-028-000 Flexible Benefits Admin Fee 221.27 221.27- Subtotal: 37,372.00 37,372.00 3,424.03 7,646.71 20.461 29,725.29 135-60005-028-000 Telephone 26.00 26.00 .24 .36 1.385 25.64 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 16.00 7.619 194.00 135-60035-028-000 Postage 102.00 102.00 12.04 30.29 29.696 71.71 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 440.00 135-60070-028-000 Dues & Memberships 504.00 504.00 37.50 75.00 14.881 429.00 135-60075-028-000 Meetings 130.00 130.00 130.00 135-60080-028-000 Schools & Training 539.00 539.00 539.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 960.00 960.00 7.50- 165.00 17.188 795.00 Subtotal: 2,919.00 2,919.00 42.28 286.65 9.820 2,632.35 135-65085-028-000 Office Supplies 412.00 412.00 412.00 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 522.00 Program number: 40,813.00 40,813.00 3,466.31 7,933.36 19.438 32,879.64 Department number: Human Resources 40,813.00 40,813.00 3,466.31 7,933.36 19.438 32,879.64 . glbase_tbam rgonzale Trophy Club Entities Page 73 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 11/2009 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 135,172.00 7,951.77 22,281.17 16.484 112,890.83 135-50010-029-000 Overtime 2,000.00 2,000.00 1,371.96 2,145.57 107.279 145.57- 135-50016-029-000 Longevity 1,259.00 1,259.00 870.00 870.00 69.102 389.00 135-50020-029-000 Retirement 17,996.00 17,996.00 1,228.48 3,072.58 17.074 14,923.42 135-50026-029-000 Medical Insurance 10,550.00 10,550.00 837.91 1,845.33 17.491 8,704.67 135-50027-029-000 Dental Insurance 765.00 765.00 50.81 108.10 14.131 656.90 135-50028-029-000 Vision Insurance 127.00 127.00 8.08 17.38 13.685 109.62 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 92.26 11.116 737.74 135-50030-029-000 Social Security Taxes 8,265.00 8,265.00 572.94 1,444.42 17.476 6,820.58 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 133.99 337.83 17.477 1,595.17 135-50040-029-000 Unemployment Taxes 135.00 135.00 .66 .66 .489 134.34 135-50045-029-000 Workman's Compensation 365.00 365.00 104.47 28.622 260.53 Subtotal: 179,397.00 179,397.00 13,072.73 32,319.77 18.016 147,077.23 135-55055-029-000 Auditing 40,000.00 40,000.00 8,000.00 20.000 32,000.00 135-55160-029-000 Professional Outside Services 105.00 105.00 105.00- Subtotal: 40,000.00 40,000.00 105.00 8,105.00 20.263 31,895.00 135-60005-029-000 Telephone 103.00 103.00 12.17 17.62 17.107 85.38 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 36.00 7.115 470.00 135-60035-029-000 Postage 900.00 900.00 47.47 84.78 9.420 815.22 135-60040-029-000 Service Charges & Fees 75.00 75.00 75.00 135-60066-029-000 Publications/Books/Subscripts 250.00 250.00 25.70 25.70 10.280 224.30 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 40.00 80.00 5.878 1,281.00 135-60075-029-000 Meetings 66.00 66.00 11.00 16.667 55.00 135-60080-029-000 Schools & Training 1,370.00 1,370.00 132.50 294.05 21.464 1,075.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 80.49 86.98 5.320 1,548.02 135-60245-029-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 7,266.00 7,266.00 338.33 636.13 8.755 6,629.87 135-65085-029-000 Office Supplies 800.00 800.00 56.82 115.97 14.496 684.03 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,700.00 56.82 115.97 6.822 1,584.03 Program number: 228,363.00 228,363.00 13,572.88 41,176.87 18.031 187,186.13 Department number: Finance 228,363.00 228,363.00 13,572.88 41,176.87 18.031 187,186.13 . glbase_tbam rgonzale Trophy Club Entities Page 74 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 11/2009 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 11,279.15 19.155 47,603.85 135-50016-033-000 Longevity 278.00 278.00 337.50 337.50 121.403 59.50- 135-50020-033-000 Retirement 7,691.00 7,691.00 594.25 1,418.39 18.442 6,272.61 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.68 821.37 16.667 4,106.63 135-50027-033-000 Dental Insurance 310.00 310.00 25.80 51.61 16.648 258.39 135-50028-033-000 Vision Insurance 60.00 60.00 4.98 9.94 16.567 50.06 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 56.80 14.792 327.20 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 301.74 720.20 19.635 2,947.80 135-50035-033-000 Medicare Taxes 858.00 858.00 70.55 168.42 19.629 689.58 135-50040-033-000 Unemployment Taxes 68.00 68.00 68.00 135-50045-033-000 Workman's Compensation 156.00 156.00 44.65 28.622 111.35 Subtotal: 77,284.00 77,284.00 6,303.32 14,908.03 19.290 62,375.97 135-55030-033-000 Software & Support 56,190.00 56,190.00 2,235.71 5,064.79 9.014 51,125.21 135-55070-033-000 Independent Labor 1,464.00 1,464.00 1,464.00 Subtotal: 57,654.00 57,654.00 2,235.71 5,064.79 8.785 52,589.21 135-60005-033-000 Telephone 20,520.00 20,520.00 763.34 4,095.18 19.957 16,424.82 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 71.99 6.660 1,009.01 135-60035-033-000 Postage 100.00 100.00 1.51 1.510 98.49 135-60066-033-000 Publications/Books/Subscripts 63.00 63.00 63.00 135-60070-033-000 Dues & Memberships 177.00 177.00 50.00 28.249 127.00 135-60075-033-000 Meetings 75.00 75.00 75.00 135-60080-033-000 Schools & Training 1,738.00 1,738.00 1,738.00 135-60100-033-000 Travel & per diem 1,464.00 1,464.00 1,464.00 135-60235-033-000 Security 1,902.00 1,902.00 410.60 21.588 1,491.40 Subtotal: 27,120.00 27,120.00 763.34 4,629.28 17.070 22,490.72 135-65055-033-000 Hardware 36,682.00 36,682.00 580.74 2,511.25 6.846 34,170.75 135-65085-033-000 Office Supplies 300.00 300.00 49.49 49.49 16.497 250.51 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 937.04 1,044.12 21.550 3,800.88 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 1,567.27 3,604.86 8.598 38,322.14 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 273.29 7.921 3,176.71 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 273.29 .900 30,087.71 Program number: 234,346.00 234,346.00 11,142.93 28,480.25 12.153 205,865.75 . glbase_tbam rgonzale Trophy Club Entities Page 75 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 11/2009 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 11,142.93 28,480.25 12.153 205,865.75 . glbase_tbam rgonzale Trophy Club Entities Page 76 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 11/2009 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 11,400.00 21.09 413.28 3.625 10,986.72 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 673.26 1,340.64 14.896 7,659.36 Subtotal: 20,400.00 20,400.00 694.35 1,753.92 8.598 18,646.08 135-60020-037-000 Electricity 19,900.00 19,900.00 804.24 1,133.82 5.698 18,766.18 135-60025-037-000 Water 1,030.00 1,030.00 34.20 3.320 995.80 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51- 1,098.51 8.333 12,083.49 135-60055-037-000 Insurance 29,601.00 29,601.00 34,379.71 116.144 4,778.71- Subtotal: 63,713.00 63,713.00 294.27- 36,646.24 57.518 27,066.76 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 143.91 145.40 7.270 1,854.60 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 99.70 99.70 9.970 900.30 Subtotal: 3,000.00 3,000.00 243.61 245.10 8.170 2,754.90 Program number: 87,113.00 87,113.00 643.69 38,645.26 44.362 48,467.74 Department number: Facilities Maintenance 87,113.00 87,113.00 643.69 38,645.26 44.362 48,467.74 . glbase_tbam rgonzale Trophy Club Entities Page 77 21:32 12/17/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 11/2009 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,060.97 15,038.39 18.979 64,199.61 135-50010-038-000 Overtime 750.00 750.00 67.63 241.17 32.156 508.83 135-50016-038-000 Longevity 185.00 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 770.89 1,888.22 18.118 8,533.78 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 1,779.12 16.666 8,895.88 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 137.76 16.678 688.24 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 22.16 16.662 110.84 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 82.66 14.814 475.34 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 383.12 942.16 19.150 3,977.84 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 89.60 220.35 19.144 930.65 135-50040-038-000 Unemployment Taxes 135.00 135.00 135.00 135-50045-038-000 Workman's Compensation 212.00 212.00 60.68 28.623 151.32 Subtotal: 109,205.00 109,205.00 8,568.06 20,597.67 18.861 88,607.33 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 695.31 6.321 10,304.69 Subtotal: 11,800.00 11,800.00 695.31 5.892 11,104.69 135-60005-038-000 Telephone 75.00 75.00 8.89 15.91 21.213 59.09 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 32.00 7.619 388.00 135-60035-038-000 Postage 15,820.00 15,820.00 1,021.71 6.458 14,798.29 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 1,630.67 1,630.67 10.871 13,369.33 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 800.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 20,000.00 20,000.00 20,000.00 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .06 .030 199.94 Subtotal: 52,991.00 52,991.00 1,639.56 2,700.35 5.096 50,290.65 135-65085-038-000 Office Supplies 700.00 700.00 37.50 357.72 51.103 342.28 135-65105-038-000 Printing 4,500.00 4,500.00 4,500.00 Subtotal: 5,200.00 5,200.00 37.50 357.72 6.879 4,842.28 Program number: 179,196.00 179,196.00 10,245.12 24,351.05 13.589 154,844.95 Department number: Utility Billing 179,196.00 179,196.00 10,245.12 24,351.05 13.589 154,844.95 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 237,814.08 563,976.03 12.077 4,105,957.97 Fund number: 135 MUD 1 O&M CONSOLIDATED 70,273.51- 59,330.96- 59,330.96 . glbase_tbam rgonzale Trophy Club Entities Page 89 21:32 12/17/09 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 11/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 309.60- 626.85- 626.85 Subtotal: 309.60- 626.85- 626.85 Program number: 309.60- 626.85- 626.85 Department number: Revenues 309.60- 626.85- 626.85 Revenues Subtotal ----------- 309.60- 626.85- 626.85 Fund number: 315 MASTER DIST CIP FIRE STATION 309.60- 626.85- 626.85 . glbase_tbam rgonzale Trophy Club Entities Page 98 21:32 12/17/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 11/2009 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- 37,755.33- 37,380.74- 5.315 665,929.26- 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 656.80- 717.07- 7.967 8,282.93- Subtotal: 712,310.00- 712,310.00- 38,412.13- 38,097.81- 5.348 674,212.19- 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 345,000.00- Subtotal: 345,000.00- 345,000.00- 345,000.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 44.33- 93.07- 4.654 1,906.93- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 310,000.00- 310,000.00- 44.33- 93.07- .030 309,906.93- Program number: 1,367,310.00- 1,367,310.00- 38,456.46- 38,190.88- 2.793 1,329,119.12- Department number: Revenues 1,367,310.00- 1,367,310.00- 38,456.46- 38,190.88- 2.793 1,329,119.12- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 38,456.46- 38,190.88- 2.793 1,329,119.12- . glbase_tbam rgonzale Trophy Club Entities Page 99 21:32 12/17/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 11/2009 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 4,000.00 533-70025-051-000 Bond Interest Expense 308,310.00 308,310.00 308,310.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 1,367,310.00 Program number: 1,367,310.00 1,367,310.00 1,367,310.00 Department number: Administration 1,367,310.00 1,367,310.00 1,367,310.00 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 1,367,310.00