Loading...
HomeMy WebLinkAboutDecember 2009 Budget Summary-Consolidation . glbase_tbam rgonzale Trophy Club Entities Page 47 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 12/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- 48,549.99- 62,854.70- 22.621 214,999.30- 135-40015-000-000 Property Taxes/P & I 225.42- 852.82- 852.82 Subtotal: 277,854.00- 277,854.00- 48,775.41- 63,707.52- 22.928 214,146.48- 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 79,648.67- 257,638.74- 15.304 1,425,886.26- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 67,377.13- 214,912.78- 20.301 843,707.22- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 32,560.62- 129,151.14- 17.248 619,628.86- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 19,271.88- 54,950.59- 16.472 278,644.41- 135-47020-000-000 Standby 1,140.00- 1,140.00- 64.40- 200.40- 17.579 939.60- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 2,643.12- 10,462.87- 19.023 44,537.13- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,242.56- 7,281.71- 45.511 8,718.29- 135-47035-000-000 Plumbing Inspections 150.00- 150.00- 150.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 450.00- 450.00- 36.000 800.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 3,935.91- 6.560 56,064.09- 135-47270-000-000 Fire Line 525.00- 2,625.00- 2,625.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 144.48- 13,767.03- 38.083 22,382.97- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 780.88- 2,022.37- 13.048 13,477.63- 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,432.99- 33,190.39- 16.480 168,205.61- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 3,593.53- 9,928.62- 16.575 49,971.38- Subtotal: 4,271,056.00- 4,271,056.00- 217,885.26- 741,369.29- 17.358 3,529,686.71- 135-48005-000-000 Utility Fees 66,700.00 Subtotal: 66,700.00 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 167.32- 498.32- 24.916 1,501.68- 135-49015-000-000 Lease/Rental Income 10,164.00- 10,164.00- 847.00- 2,541.00- 25.000 7,623.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- 3,072.00- 11,008.00- 30.578 24,992.00- 135-49900-000-000 Miscellaneous Income 21,100.00- 21,100.00- 2,769.67- 4,451.93- 21.099 16,648.07- 135-49901-000-000 Records Management Revenue 158.00- 158.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 3,887.50- 10,145.00- 31.703 21,855.00- 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 242.94- 375.03- 6.049 5,824.97- Subtotal: 121,024.00- 121,024.00- 10,986.43- 29,177.28- 24.109 91,846.72- Program number: 4,669,934.00- 4,669,934.00- 210,947.10- 834,254.09- 17.864 3,835,679.91- Department number: Revenues 4,669,934.00- 4,669,934.00- 210,947.10- 834,254.09- 17.864 3,835,679.91- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 210,947.10- 834,254.09- 17.864 3,835,679.91- . glbase_tbam rgonzale Trophy Club Entities Page 48 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 12/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 32,654.89 20.438 127,119.11 135-50010-010-000 Overtime 8,814.00 8,814.00 2,043.99 5,237.04 59.417 3,576.96 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 230.00 15.333 1,270.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,409.71 4,887.89 21.860 17,472.11 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 3,798.54 16.419 19,336.46 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 263.22 16.776 1,305.78 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 48.18 17.085 233.82 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 191.55 17.027 933.45 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 707.93 2,458.26 23.156 8,157.74 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 165.56 574.90 23.153 1,908.10 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 15,262.66 53,930.47 22.482 185,953.53 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 550.00 696.77 2.680 25,303.23 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 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 1.683 2,851.20 135-55135-010-000 Lab Analysis 3,350.00 3,350.00 135.00 317.00 9.463 3,033.00 Subtotal: 37,680.00 37,680.00 685.00 2,715.62 7.207 34,964.38 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 287.30 380.73 18.885 1,635.27 135-60020-010-000 Electricity 195,000.00 195,000.00 7,868.85 19,929.86 10.220 175,070.14 135-60035-010-000 Postage 100.00 100.00 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 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 176.00 502.15 15.692 2,697.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 92.939 466.05 135-60150-010-000 Bulk Water 1,410,000.00 1,410,000.00 71,063.05 134,823.35 9.562 1,275,176.65 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 297.00 319.00 7.595 3,881.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 79,692.20 162,210.94 9.944 1,469,105.06 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 705.18 2,083.18 13.691 13,132.82 . glbase_tbam rgonzale Trophy Club Entities Page 49 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 12/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 252.41 252.41 6.840 3,437.59 135-65030-010-000 Chemicals 5,200.00 5,200.00 487.18 1,756.66 33.782 3,443.34 135-65035-010-000 Small Tools 2,500.00 2,500.00 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 51,442.00 56,502.00 75.336 18,498.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 1,290.92 1,451.13 4.837 28,548.87 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 54,177.69 62,161.20 45.941 73,144.80 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 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 71,573.02 33.444 142,437.98 Program number: 2,258,197.00 2,258,197.00 149,817.55 352,591.25 15.614 1,905,605.75 Department number: Water 2,258,197.00 2,258,197.00 149,817.55 352,591.25 15.614 1,905,605.75 . glbase_tbam rgonzale Trophy Club Entities Page 50 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 12/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,069.59 45,817.11 26.699 125,789.89 135-50010-020-000 Overtime 10,166.00 10,166.00 1,442.44 4,473.55 44.005 5,692.45 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 350.00 13.725 2,200.00 135-50020-020-000 Retirement 24,372.00 24,372.00 1,793.29 6,568.14 26.950 17,803.86 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 6,875.76 25.000 20,627.24 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 495.84 25.005 1,487.16 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 89.28 25.008 267.72 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 266.85 22.275 931.15 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 769.28 2,911.24 29.300 7,024.76 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 179.90 680.85 29.296 1,643.15 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 20,005.41 73,395.79 28.050 188,264.21 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 3,795.66 5,553.53 27.425 14,696.47 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 18.53 148.58 6.483 2,143.42 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 358.00 358.00 25.571 1,042.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 303.53 10.289 2,646.47 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 2,344.10 3,855.90 13.771 24,144.10 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 799.00 2,006.00 9.667 18,744.00 Subtotal: 77,892.00 77,892.00 7,315.29 12,225.54 15.696 65,666.46 135-60005-020-000 Telephone 1.77 6.71 6.71- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 494.79 692.09 21.126 2,583.91 135-60020-020-000 Electricity 230,000.00 230,000.00 15,215.10 35,238.20 15.321 194,761.80 135-60025-020-000 Water 1,600.00 1,600.00 160.80 218.50 13.656 1,381.50 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 40.00 40.00 3.030 1,280.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 125.40 486.75 38.940 763.25 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 16,037.86 44,114.75 17.859 202,901.25 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 218.13 705.14 18.679 3,069.86 . glbase_tbam rgonzale Trophy Club Entities Page 51 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 12/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 41.05 213.36 39.511 326.64 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 57.44 1,304.83 21.443 4,780.17 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 67.15 603.47 4.551 12,656.53 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 383.77 6,588.53 17.311 31,471.47 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 43,742.33 142,894.61 17.402 678,222.39 Department number: Wastewater 821,117.00 821,117.00 43,742.33 142,894.61 17.402 678,222.39 . glbase_tbam rgonzale Trophy Club Entities Page 52 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 12/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.35 35,431.19 26.772 96,913.81 135-50010-021-000 Overtime 14,145.00 14,145.00 664.11 2,243.49 15.861 11,901.51 135-50016-021-000 Longevity 2,888.00 2,888.00 2,920.00 101.108 32.00- 135-50017-021-000 Certification 1,200.00 1,200.00 125.00 250.00 20.833 950.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,339.13 4,987.13 25.477 14,587.87 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 4,510.68 25.000 13,532.32 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 356.64 25.010 1,069.36 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 55.56 26.971 150.44 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 202.98 22.208 711.02 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 614.78 2,336.77 27.832 6,059.23 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 143.79 546.51 27.826 1,417.49 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 14,773.78 54,741.64 26.742 149,960.36 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 2,119.72 21.197 7,880.28 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 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 2,861.51 19.710 11,656.49 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 305.46 522.15 24.723 1,589.85 135-60020-021-000 Electricity 22,250.00 22,250.00 1,872.76 4,142.12 18.616 18,107.88 135-60025-021-000 Water 750.00 750.00 21.84 24.96 3.328 725.04 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 64.35 206.25 13.750 1,293.75 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 39,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 70,685.00 70,685.00 2,264.41 5,096.48 7.210 65,588.52 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 1,099.44 2,580.06 24.113 8,119.94 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 519.00 519.00 5.190 9,481.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 53 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 12/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,618.44 3,099.06 7.265 39,555.94 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 18,656.63 65,798.69 18.148 296,761.31 Department number: Collection 362,560.00 362,560.00 18,656.63 65,798.69 18.148 296,761.31 . glbase_tbam rgonzale Trophy Club Entities Page 54 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 12/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 3,300.00 22.000 11,700.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 62.00 204.60 15.860 1,085.40 135-50035-026-000 Medicare Taxes 302.00 302.00 14.50 47.85 15.844 254.15 135-50040-026-000 Unemployment Taxes 375.00 375.00 5.00 16.50 4.400 358.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 3,603.29 21.088 13,483.71 135-55045-026-000 Legal 32,500.00 32,500.00 3,526.35 6,332.75 19.485 26,167.25 135-55060-026-000 Appraisal 18,874.00 18,874.00 3,146.89 3,146.89 16.673 15,727.11 135-55065-026-000 Tax Admin Fees 2,380.00 2,380.00 3,639.00 3,639.00 152.899 1,259.00- Subtotal: 53,754.00 53,754.00 10,312.24 13,118.64 24.405 40,635.36 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 1,375.00 1,925.00 175.639 829.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 1,375.00 1,991.61 9.579 18,800.39 135-65085-026-000 Office Supplies 200.00 200.00 7.50 3.750 192.50 Subtotal: 200.00 200.00 7.50 3.750 192.50 Program number: 91,833.00 91,833.00 12,768.74 18,721.04 20.386 73,111.96 Department number: Board of Directors 91,833.00 91,833.00 12,768.74 18,721.04 20.386 73,111.96 . glbase_tbam rgonzale Trophy Club Entities Page 55 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 12/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,001.31 66,573.93 26.683 182,925.07 135-50010-027-000 Overtime 1,750.00 1,750.00 178.53 1,019.01 58.229 730.99 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,341.86 8,595.06 26.060 24,386.94 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 5,579.16 25.000 16,737.84 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.53 361.56 25.004 1,084.44 135-50028-027-000 Vision Insurance 269.00 269.00 22.37 67.09 24.941 201.91 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 110.79 332.37 22.143 1,168.63 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,132.40 4,210.00 27.233 11,249.00 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 264.83 984.60 27.237 2,630.40 135-50040-027-000 Unemployment Taxes 304.00 304.00 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 60.00 76.93 9.180 761.07 Subtotal: 333,707.00 333,707.00 25,092.34 91,049.29 27.284 242,657.71 135-55070-027-000 Independent Labor 720.00 720.00 48.75 116.25 16.146 603.75 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 48.75 243.12 13.358 1,576.88 135-60005-027-000 Telephone 265.00 265.00 30.67 59.48 22.445 205.52 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 494.23 790.03 28.470 1,984.97 135-60035-027-000 Postage 1,071.00 1,071.00 52.10 173.37 16.188 897.63 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 17.50 5.000 332.50 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 421.00 883.66 52.819 789.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 193.50 461.00 16.980 2,254.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 481.41 1,034.28 49.393 1,059.72 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 1,672.91 3,441.32 12.333 24,462.68 135-65085-027-000 Office Supplies 2,450.00 2,450.00 125.19 574.36 23.443 1,875.64 135-65105-027-000 Printing 515.00 515.00 515.00 Subtotal: 2,965.00 2,965.00 125.19 574.36 19.371 2,390.64 Program number: 366,396.00 366,396.00 26,939.19 95,308.09 26.012 271,087.91 . glbase_tbam rgonzale Trophy Club Entities Page 56 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 12/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 26,939.19 95,308.09 26.012 271,087.91 . glbase_tbam rgonzale Trophy Club Entities Page 57 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 12/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.80 6,899.40 26.848 18,798.60 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 241.36 854.31 25.479 2,498.69 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.39 667.15 24.996 2,001.85 135-50027-028-000 Dental Insurance 155.00 155.00 12.92 38.77 25.013 116.23 135-50028-028-000 Vision Insurance 30.00 30.00 2.50 7.46 24.867 22.54 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 40.71 22.125 143.29 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 122.57 433.84 27.337 1,153.16 135-50035-028-000 Medicare Taxes 371.00 371.00 28.67 101.47 27.350 269.53 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 324.10 1,003.05 61.726 621.95 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 115.50 115.50 7.700 1,384.50 135-50994-028-000 Employee Assistance Program 103.60 310.80 310.80- 135-50995-028-000 Flexible Benefits Admin Fee 103.14 324.41 324.41- Subtotal: 37,372.00 37,372.00 3,267.12 10,913.83 29.203 26,458.17 135-60005-028-000 Telephone 26.00 26.00 .91 1.27 4.885 24.73 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 32.00 48.00 22.857 162.00 135-60035-028-000 Postage 102.00 102.00 9.59 39.88 39.098 62.12 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 440.00 135-60070-028-000 Dues & Memberships 504.00 504.00 75.00 14.881 429.00 135-60075-028-000 Meetings 130.00 130.00 87.50 87.50 67.308 42.50 135-60080-028-000 Schools & Training 539.00 539.00 539.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 960.00 960.00 165.00 17.188 795.00 Subtotal: 2,919.00 2,919.00 130.00 416.65 14.274 2,502.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,397.12 11,330.48 27.762 29,482.52 Department number: Human Resources 40,813.00 40,813.00 3,397.12 11,330.48 27.762 29,482.52 . glbase_tbam rgonzale Trophy Club Entities Page 58 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 12/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,847.86 30,129.03 22.289 105,042.97 135-50010-029-000 Overtime 2,000.00 2,000.00 998.69 3,144.26 157.213 1,144.26- 135-50016-029-000 Longevity 1,259.00 1,259.00 870.00 69.102 389.00 135-50020-029-000 Retirement 17,996.00 17,996.00 1,076.69 4,149.27 23.057 13,846.73 135-50026-029-000 Medical Insurance 10,550.00 10,550.00 764.38 2,609.71 24.737 7,940.29 135-50027-029-000 Dental Insurance 765.00 765.00 50.79 158.89 20.770 606.11 135-50028-029-000 Vision Insurance 127.00 127.00 8.08 25.46 20.047 101.54 135-50029-029-000 Life Insurance & Other 830.00 830.00 46.13 138.39 16.673 691.61 135-50030-029-000 Social Security Taxes 8,265.00 8,265.00 490.20 1,934.62 23.407 6,330.38 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 114.63 452.46 23.407 1,480.54 135-50040-029-000 Unemployment Taxes 135.00 135.00 .14 .80 .593 134.20 135-50045-029-000 Workman's Compensation 365.00 365.00 104.47 28.622 260.53 Subtotal: 179,397.00 179,397.00 11,397.59 43,717.36 24.369 135,679.64 135-55055-029-000 Auditing 40,000.00 40,000.00 8,750.00 16,750.00 41.875 23,250.00 135-55160-029-000 Professional Outside Services 105.00 105.00- Subtotal: 40,000.00 40,000.00 8,750.00 16,855.00 42.138 23,145.00 135-60005-029-000 Telephone 103.00 103.00 6.65 24.27 23.563 78.73 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 72.00 108.00 21.344 398.00 135-60035-029-000 Postage 900.00 900.00 75.71 160.49 17.832 739.51 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 10.280 224.30 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 484.35 564.35 41.466 796.65 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 294.05 21.464 1,075.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 86.98 5.320 1,548.02 135-60110-029-000 Physicals/Testing 14.97 14.97 14.97- 135-60245-029-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 Subtotal: 7,266.00 7,266.00 653.68 1,289.81 17.751 5,976.19 135-65085-029-000 Office Supplies 800.00 800.00 115.97 14.496 684.03 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,700.00 115.97 6.822 1,584.03 Program number: 228,363.00 228,363.00 20,801.27 61,978.14 27.140 166,384.86 Department number: Finance 228,363.00 228,363.00 20,801.27 61,978.14 27.140 166,384.86 . glbase_tbam rgonzale Trophy Club Entities Page 59 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 12/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 15,808.57 26.847 43,074.43 135-50016-033-000 Longevity 278.00 278.00 337.50 121.403 59.50- 135-50020-033-000 Retirement 7,691.00 7,691.00 553.04 1,971.43 25.633 5,719.57 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.70 1,232.07 25.001 3,695.93 135-50027-033-000 Dental Insurance 310.00 310.00 25.82 77.43 24.977 232.57 135-50028-033-000 Vision Insurance 60.00 60.00 4.97 14.91 24.850 45.09 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 85.20 22.188 298.80 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 280.83 1,001.03 27.291 2,666.97 135-50035-033-000 Medicare Taxes 858.00 858.00 65.67 234.09 27.283 623.91 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 5,898.85 20,806.88 26.923 56,477.12 135-55030-033-000 Software & Support 56,190.00 56,190.00 832.49 5,897.28 10.495 50,292.72 135-55070-033-000 Independent Labor 1,464.00 1,464.00 125.00 125.00 8.538 1,339.00 Subtotal: 57,654.00 57,654.00 957.49 6,022.28 10.446 51,631.72 135-60005-033-000 Telephone 20,520.00 20,520.00 1,059.15 5,154.33 25.119 15,365.67 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 143.98 215.97 19.979 865.03 135-60035-033-000 Postage 100.00 100.00 .22 1.73 1.730 98.27 135-60066-033-000 Publications/Books/Subscripts 63.00 63.00 63.00 135-60070-033-000 Dues & Memberships 177.00 177.00 49.97 99.97 56.480 77.03 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 1,253.32 5,882.60 21.691 21,237.40 135-65055-033-000 Hardware 36,682.00 36,682.00 4,201.13 6,712.38 18.299 29,969.62 135-65085-033-000 Office Supplies 300.00 300.00 49.49 16.497 250.51 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 80.00 1,124.12 23.202 3,720.88 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 4,281.13 7,885.99 18.809 34,041.01 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 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 .900 30,087.71 Program number: 234,346.00 234,346.00 12,390.79 40,871.04 17.440 193,474.96 . glbase_tbam rgonzale Trophy Club Entities Page 60 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 12/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 12,390.79 40,871.04 17.440 193,474.96 . glbase_tbam rgonzale Trophy Club Entities Page 61 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 12/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 413.28 3.625 10,986.72 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 701.71 2,042.35 22.693 6,957.65 Subtotal: 20,400.00 20,400.00 701.71 2,455.63 12.037 17,944.37 135-60020-037-000 Electricity 19,900.00 19,900.00 1,375.16 2,508.98 12.608 17,391.02 135-60025-037-000 Water 1,030.00 1,030.00 88.66 122.86 11.928 907.14 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 2,197.02 3,295.53 25.000 9,886.47 135-60055-037-000 Insurance 29,601.00 29,601.00 25.00 34,404.71 116.228 4,803.71- Subtotal: 63,713.00 63,713.00 3,685.84 40,332.08 63.303 23,380.92 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 102.03 247.43 12.372 1,752.57 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 26.09 125.79 12.579 874.21 Subtotal: 3,000.00 3,000.00 128.12 373.22 12.441 2,626.78 Program number: 87,113.00 87,113.00 4,515.67 43,160.93 49.546 43,952.07 Department number: Facilities Maintenance 87,113.00 87,113.00 4,515.67 43,160.93 49.546 43,952.07 . glbase_tbam rgonzale Trophy Club Entities Page 62 09:41 01/14/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 12/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,095.24 21,133.63 26.671 58,104.37 135-50010-038-000 Overtime 750.00 750.00 228.56 469.73 62.631 280.27 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 772.13 2,660.35 25.526 7,761.65 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 2,668.68 24.999 8,006.32 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 206.64 25.017 619.36 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 33.24 24.992 99.76 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 123.99 22.220 434.01 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 383.76 1,325.92 26.950 3,594.08 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 89.74 310.09 26.941 840.91 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,580.28 29,177.95 26.719 80,027.05 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 800.14 1,495.45 13.595 9,504.55 Subtotal: 11,800.00 11,800.00 800.14 1,495.45 12.673 10,304.55 135-60005-038-000 Telephone 75.00 75.00 4.49 20.40 27.200 54.60 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 64.02 96.02 22.862 323.98 135-60035-038-000 Postage 15,820.00 15,820.00 1,212.09 2,233.80 14.120 13,586.20 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 1,118.39 2,749.06 18.327 12,250.94 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 800.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 20,000.00 20,000.00 17,174.03 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 19,573.02 22,273.37 42.032 30,717.63 135-65085-038-000 Office Supplies 700.00 700.00 4.83 362.55 51.793 337.45 135-65105-038-000 Printing 4,500.00 4,500.00 4,500.00 Subtotal: 5,200.00 5,200.00 4.83 362.55 6.972 4,837.45 Program number: 179,196.00 179,196.00 28,958.27 53,309.32 29.749 125,886.68 Department number: Utility Billing 179,196.00 179,196.00 28,958.27 53,309.32 29.749 125,886.68 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 321,987.56 885,963.59 18.972 3,783,970.41 Fund number: 135 MUD 1 O&M CONSOLIDATED 111,040.46 51,709.50 51,709.50- . glbase_tbam rgonzale Trophy Club Entities Page 73 09:41 01/14/10 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 12/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 316.63- 943.48- 943.48 Subtotal: 316.63- 943.48- 943.48 Program number: 316.63- 943.48- 943.48 Department number: Revenues 316.63- 943.48- 943.48 Revenues Subtotal ----------- 316.63- 943.48- 943.48 Fund number: 315 MASTER DIST CIP FIRE STATION 316.63- 943.48- 943.48 . glbase_tbam rgonzale Trophy Club Entities Page 85 09:41 01/14/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 12/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- 123,057.13- 160,437.87- 22.812 542,872.13- 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 307.68- 1,024.75- 11.386 7,975.25- Subtotal: 712,310.00- 712,310.00- 123,364.81- 161,462.62- 22.667 550,847.38- 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 92,000.00- 92,000.00- 26.667 253,000.00- Subtotal: 345,000.00- 345,000.00- 92,000.00- 92,000.00- 26.667 253,000.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 58.26- 151.33- 7.567 1,848.67- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 310,000.00- 310,000.00- 58.26- 151.33- .049 309,848.67- Program number: 1,367,310.00- 1,367,310.00- 215,423.07- 253,613.95- 18.548 1,113,696.05- Department number: Revenues 1,367,310.00- 1,367,310.00- 215,423.07- 253,613.95- 18.548 1,113,696.05- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 215,423.07- 253,613.95- 18.548 1,113,696.05- . glbase_tbam rgonzale Trophy Club Entities Page 86 09:41 01/14/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 12/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