Loading...
HomeMy WebLinkAboutSeptember 2009 Budget Summary-Consolidation . glbase_tbam rgonzale Trophy Club Entities Page 81 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 3,057.69 355.77- 351.27- -11.488 3,408.96 135-40010-000-000 Property Taxes/MUD Fire 21,909.50 3,081.63- 3,072.27- -14.023 24,981.77 135-40015-000-000 Property Taxes/P & I 520.25 96.42 65.37 12.565 454.88 135-40020-000-000 Property Taxes/Fire P & I 4,818.86 556.20- 841.26- -17.458 5,660.12 Subtotal: 30,306.30 3,897.18- 4,199.43- -13.857 34,505.73 135-47000-000-000 Water 608,138.51- 159,580.06- 344,512.95- 56.650 263,625.56- 135-47005-000-000 Sewer 312,227.46- 90,837.78- 189,362.68- 60.649 122,864.78- 135-47010-000-000 Commercial Water 220,903.82- 76,248.28- 167,403.58- 75.781 53,500.24- 135-47015-000-000 Commercial Sewer 109,459.56- 26,018.97- 60,151.45- 54.953 49,308.11- 135-47020-000-000 Standby 551.60- 65.00- 130.00- 23.568 421.60- 135-47025-000-000 Penalties 29,775.86- 4,348.33- 10,758.91- 36.133 19,016.95- 135-47030-000-000 Service Charges 12,115.19 1,542.55- 3,016.84- -24.901 15,132.03 135-47035-000-000 Plumbing Inspections 2,100.00 50.00- 150.00- -7.143 2,250.00 135-47045-000-000 Sewer Inspections 4,109.00- 150.00- 450.00- 10.952 3,659.00- 135-47050-000-000 Tap Fees 42,742.00- 42,742.00- 135-47070-000-000 TCCC Effluent Charges 36,349.64- 10,824.55- 21,842.81- 60.091 14,506.83- 135-47270-000-000 Fire Line 5,250.00 5,250.00 135-47400-000-000 Water-Out of Dist/Port Meters 7,333.27 7,551.83- 13,307.31- -181.465 20,640.58 135-47405-000-000 Out of District Sewer 4,222.94 1,166.54- 2,218.32- -52.530 6,441.26 135-47410-000-000 Out of Dist/Portable Penalties 1,660.74- 2.50- 634.28- 38.193 1,026.46- 135-47600-000-000 PID #1 Water 31,135.84- 13,695.61- 29,757.90- 95.574 1,377.94- 135-47605-000-000 PID #1 Sewer 43,023.31- 2,649.89- 4,853.82- 11.282 38,169.49- Subtotal: 1,409,055.94- 394,731.89- 848,550.85- 60.221 560,505.09- 135-48005-000-000 Utility Fees 87,400.00 50,600.00- 82,800.00- -94.737 170,200.00 Subtotal: 87,400.00 50,600.00- 82,800.00- -94.737 170,200.00 135-49005-000-000 Loan Proceeds 377,750.00- 377,750.00- 135-49010-000-000 Interest Income 56,911.93- 210.09- 503.21- .884 56,408.72- 135-49015-000-000 Lease/Rental Income 1,694.00- 1,694.00- 2,541.00- 150.000 847.00 135-49030-000-000 Vending Revenue 950.00- 303.00- 303.00- 31.895 647.00- 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 135-49075-000-000 New Oversize Meter Reimburse 6,600.12 4,864.00- 9,984.00- -151.270 16,584.12 135-49900-000-000 Miscellaneous Income 8,771.35 1,348.66- 1,967.35- -22.429 10,738.70 135-49901-000-000 Records Management Revenue 146.59 9.05- 13.35- -9.107 159.94 135-49902-000-000 Sewer/Septic Dump Revenue 8,845.00- 2,575.00- 5,630.00- 63.652 3,215.00- 135-49903-000-000 Recovery of Prior Year Expense 4,977.00 4,977.00 135-49905-000-000 Gas Well Revenue 3,983.48- 402.86- 622.63- 15.630 3,360.85- Subtotal: 442,349.35- 11,406.66- 21,564.54- 4.875 420,784.81- . glbase_tbam rgonzale Trophy Club Entities Page 82 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 1,733,698.99- 460,635.73- 957,114.82- 55.207 776,584.17- Department number: Revenues 1,733,698.99- 460,635.73- 957,114.82- 55.207 776,584.17- Revenues Subtotal ----------- 1,733,698.99- 460,635.73- 957,114.82- 55.207 776,584.17- . glbase_tbam rgonzale Trophy Club Entities Page 83 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 18,088.23 14,861.52 23,887.12 132.059 5,798.89- 135-50010-010-000 Overtime 2,962.74 2,467.51 3,677.03 124.109 714.29- 135-50017-010-000 Certification 890.00 230.00 345.00 38.764 545.00 135-50020-010-000 Retirement 17,578.75 1,344.21 2,607.96 14.836 14,970.79 135-50026-010-000 Medical Insurance 15,845.88 1,209.00 2,418.00 15.259 13,427.88 135-50027-010-000 Dental Insurance 1,081.07 69.18 138.36 12.798 942.71 135-50028-010-000 Vision Insurance 284.02 17.88 35.76 12.591 248.26 135-50029-010-000 Life Insurance & Other 1,077.80 66.22 132.44 12.288 945.36 135-50030-010-000 Social Security Taxes 8,366.22 679.03 1,317.20 15.744 7,049.02 135-50035-010-000 Medicare Taxes 1,956.77 158.81 308.06 15.743 1,648.71 135-50040-010-000 Unemployment Taxes 1,764.00 1,764.00 135-50045-010-000 Workman's Compensation 2,144.81 2,144.81 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 135-50070-010-000 Employee Relations 986.93 42.89 4.346 944.04 Subtotal: 73,227.22 21,103.36 34,909.82 47.673 38,317.40 135-55080-010-000 Maintenance & Repairs 4,618.74 1,405.49 4,618.49 99.995 .25 135-55090-010-000 Vehicle Maintenance 1,179.37 43.48 43.48 3.687 1,135.89 135-55100-010-000 Building Maint & Supplies 343.83 343.83 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,885.17 139.00 139.00 4.818 2,746.17 135-55135-010-000 Lab Analysis 1,324.00 293.00 1,363.00 102.946 39.00- Subtotal: 10,351.11 1,880.97 6,163.97 59.549 4,187.14 135-60010-010-000 Communications/Pagers/Mobiles 879.46 298.56 508.24 57.790 371.22 135-60020-010-000 Electricity 55,050.21 25,515.03 44,226.63 80.339 10,823.58 135-60035-010-000 Postage 100.00 100.00 135-60050-010-000 Bad Debt Expense 1,528.93 208.15- 250.90- -16.410 1,779.83 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 135-60070-010-000 Dues & Memberships 115.00 35.00 30.435 80.00 135-60080-010-000 Schools & Training 3.00 3.00 135-60090-010-000 Safety Program 500.00 500.00 135-60100-010-000 Travel & per diem 599.13 144.65 255.75 42.687 343.38 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 135-60135-010-000 Annual Permit Fee 259.37 259.37 135-60150-010-000 Bulk Water 397,278.06 222,488.97 372,427.20 93.745 24,850.86 135-60245-010-000 Miscellaneous Expenses 1.17 1.17 135-60280-010-000 Property Maintenance 371.50 796.63 959.15 258.183 587.65- 135-60285-010-000 Lawn Equipment & Maintenance 1,810.91 29.97 1.655 1,780.94 Subtotal: 459,046.74 249,035.69 418,191.04 91.100 40,855.70 135-65005-010-000 Fuel & Lube 8,043.29 845.03 1,590.31 19.772 6,452.98 135-65010-010-000 Uniforms 1,782.01 1,782.01 . glbase_tbam rgonzale Trophy Club Entities Page 84 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-010-000 Chemicals 971.14 627.19 627.19 64.583 343.95 135-65035-010-000 Small Tools 2,479.07 59.98 76.47 3.085 2,402.60 135-65040-010-000 Safety Equipment 2,457.77 2,457.77 135-65050-010-000 Meter Expense 30,559.00 370.00 1.211 30,189.00 135-65055-010-000 Hardware 626.50 626.50 135-65085-010-000 Office Supplies 14.00 13.70 13.70 97.857 .30 135-65095-010-000 Maintenance Supplies 17,903.91 622.25 1,368.86 7.646 16,535.05 135-65100-010-000 Copies 50.00 50.00 135-65105-010-000 Printing 30.50 30.50 Subtotal: 64,917.19 2,168.15 4,046.53 6.233 60,870.66 135-69005-010-000 Capital Expenses .61 .61 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 135-69235-010-000 Variable Speed Pump .09 .09 135-69280-010-000 Capital Repairs 48,295.00 48,295.00 135-69281-010-000 Capital Repair-Ground Storage .52 .52 135-69295-010-000 Unexpected Maintenance 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,084.37 96.470 405.63 Subtotal: 90,036.22 11,084.37 12.311 78,951.85 Program number: 697,578.48 274,188.17 474,395.73 68.006 223,182.75 Department number: Water 697,578.48 274,188.17 474,395.73 68.006 223,182.75 . glbase_tbam rgonzale Trophy Club Entities Page 85 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 25,378.71 20,917.96 33,610.76 132.437 8,232.05- 135-50010-020-000 Overtime 2,849.47 2,069.90 3,315.44 116.353 465.97- 135-50016-020-000 Longevity .50 .50 135-50017-020-000 Certification 525.00 350.00 525.00 100.000 135-50020-020-000 Retirement 3,510.84 1,787.46 3,510.68 99.995 .16 135-50026-020-000 Medical Insurance 4,354.20 2,177.22 4,354.44 100.006 .24- 135-50027-020-000 Dental Insurance 294.53 147.50 295.00 100.160 .47- 135-50028-020-000 Vision Insurance 65.62 32.58 65.16 99.299 .46 135-50029-020-000 Life Insurance & Other 184.85 92.22 184.44 99.778 .41 135-50030-020-000 Social Security Taxes 1,523.82 778.44 1,524.28 100.030 .46- 135-50035-020-000 Medicare Taxes 356.85 182.05 356.47 99.894 .38 135-50040-020-000 Unemployment Taxes 4.82 4.82 135-50045-020-000 Workman's Compensation .84 .84 135-50070-020-000 Employee Relations .96 .96 Subtotal: 39,051.01 28,535.33 47,741.67 122.255 8,690.66- 135-55005-020-000 Engineering 1,285.00 1,200.00 1,200.00 93.385 85.00 135-55070-020-000 Independent Labor 90.00 90.00 135-55080-020-000 Maintenance & Repairs 2,693.90 1,104.60 2,051.77 76.164 642.13 135-55090-020-000 Vehicle Maintenance 1,368.80 89.03 89.03 6.504 1,279.77 135-55100-020-000 Building Maint & Supplies 1,431.78 1,431.78 135-55105-020-000 Maintenance-Backhoe/SkidLoader 55.00 55.07 100.127 .07- 135-55125-020-000 Dumpster Services 5,797.40 2,344.10 5,797.00 99.993 .40 135-55135-020-000 Lab Analysis 2,460.50 3,357.00 3,357.00 136.436 896.50- Subtotal: 15,182.38 8,094.73 12,549.87 82.661 2,632.51 135-60005-020-000 Telephone 4.77 4.77 4.77- 135-60010-020-000 Communications/Pagers/Mobiles 607.09 378.53 607.27 100.030 .18- 135-60020-020-000 Electricity 31,489.19 25,154.29 40,046.13 127.174 8,556.94- 135-60025-020-000 Water 1,129.86 55.86 283.06 25.053 846.80 135-60035-020-000 Postage 100.00 100.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 135-60080-020-000 Schools & Training 114.00 111.00 97.368 3.00 135-60090-020-000 Safety Program 200.00 200.00 135-60100-020-000 Travel & per diem 407.09 223.85 407.55 100.113 .46- 135-60105-020-000 Rent/Lease Equipment 189.00 114.40 114.40 60.529 74.60 135-60135-020-000 Annual Permit Fee 2,139.00 2,139.00 135-60245-020-000 Miscellaneous Expenses 59.09 59.09 135-60280-020-000 Property Maintenance .71 .71 135-60285-020-000 Lawn Equipment & Maintenance 393.30 393.30 Subtotal: 37,328.33 25,931.70 41,574.18 111.374 4,245.85- . glbase_tbam rgonzale Trophy Club Entities Page 86 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 538.38 333.42 538.29 99.983 .09 135-65010-020-000 Uniforms 1,034.37 1,034.37 135-65030-020-000 Chemicals 2,809.41 2,809.20 99.993 .21 135-65035-020-000 Small Tools 897.32 897.32 135-65040-020-000 Safety Equipment 192.39 54.90 54.90 28.536 137.49 135-65045-020-000 Lab Supplies 818.40 818.81 100.050 .41- 135-65055-020-000 Hardware 417.27 417.27 135-65085-020-000 Office Supplies 46.01 13.82 30.037 32.19 135-65095-020-000 Maintenance Supplies 72.32 249.55 249.55 345.064 177.23- 135-65115-020-000 Other Consumables 100.00 100.00 Subtotal: 6,925.87 637.87 4,484.57 64.751 2,441.30 135-69005-020-000 Capital Expenses 292,644.75 44,939.00 298,939.00 102.151 6,294.25- 135-69280-020-000 Capital Repairs .27- .27- Subtotal: 292,644.48 44,939.00 298,939.00 102.151 6,294.52- Program number: 391,132.07 108,138.63 405,289.29 103.620 14,157.22- Department number: Wastewater 391,132.07 108,138.63 405,289.29 103.620 14,157.22- . glbase_tbam rgonzale Trophy Club Entities Page 87 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 36,807.04 16,131.61 25,920.41 70.422 10,886.63 135-50010-021-000 Overtime 4,185.93 734.93 1,487.76 35.542 2,698.17 135-50017-021-000 Certification 250.00 375.00 375.00- 135-50020-021-000 Retirement 5,104.70 1,287.98 2,590.38 50.745 2,514.32 135-50026-021-000 Medical Insurance 3,985.92 1,517.48 3,034.96 76.142 950.96 135-50027-021-000 Dental Insurance 310.24 106.08 212.16 68.386 98.08 135-50028-021-000 Vision Insurance 91.60 23.00 46.00 50.218 45.60 135-50029-021-000 Life Insurance & Other 462.11 70.14 140.28 30.356 321.83 135-50030-021-000 Social Security Taxes 2,958.28 588.80 1,184.93 40.055 1,773.35 135-50035-021-000 Medicare Taxes 691.91 137.70 277.12 40.051 414.79 135-50040-021-000 Unemployment Taxes 1,119.18 1,119.18 135-50045-021-000 Workman's Compensation 852.54 852.54 135-50070-021-000 Employee Relations 211.78 211.78 Subtotal: 56,781.23 20,847.72 35,269.00 62.114 21,512.23 135-55005-021-000 Engineering 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 135-55080-021-000 Maintenance & Repairs 12,285.76 12,285.76 135-55090-021-000 Vehicle Maintenance 1,348.12 1,348.12 135-55100-021-000 Building Maint & Supplies 750.00 750.00 Subtotal: 16,083.88 16,083.88 135-60010-021-000 Communications/Pagers/Mobiles 1,062.14 548.47 677.45 63.782 384.69 135-60020-021-000 Electricity 7,177.32 3,254.70 4,972.52 69.281 2,204.80 135-60025-021-000 Water 1,065.52 9.06 18.12 1.701 1,047.40 135-60035-021-000 Postage 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 135-60080-021-000 Schools & Training 2,156.00 268.00 268.00 12.430 1,888.00 135-60090-021-000 Safety Program 750.00 750.00 135-60100-021-000 Travel & per diem 243.91 45.10 161.15 66.069 82.76 135-60105-021-000 Rent/Lease Equipment 39,000.00 36,411.50 93.363 2,588.50 135-60245-021-000 Miscellaneous Expenses 57.00 57.00 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 Subtotal: 52,916.89 4,125.33 42,508.74 80.331 10,408.15 135-65005-021-000 Fuel & Lube 5,310.50 566.00 1,234.61 23.248 4,075.89 135-65010-021-000 Uniforms 1,509.25 1,509.25 135-65030-021-000 Chemicals 7,993.05 7,993.05 135-65035-021-000 Small Tools 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,048.49 1,048.49 135-65055-021-000 Hardware 750.00 750.00 135-65095-021-000 Maintenance Supplies 16,154.69 16,154.69 . glbase_tbam rgonzale Trophy Club Entities Page 88 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 34,265.98 566.00 1,234.61 3.603 33,031.37 135-69005-021-000 Capital Expenses 53,000.00 53,000.00 135-69280-021-000 Capital Repairs 24,680.00 24,680.00 Subtotal: 77,680.00 77,680.00 Program number: 237,727.98 25,539.05 79,012.35 33.236 158,715.63 Department number: Collection 237,727.98 25,539.05 79,012.35 33.236 158,715.63 . glbase_tbam rgonzale Trophy Club Entities Page 89 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 800.00- 700.00 2,100.00 -262.500 2,900.00- 135-50030-026-000 Social Security Taxes 49.20- 86.80 -176.423 136.00- 135-50035-026-000 Medicare Taxes 12.20- 20.30 -166.393 32.50- 135-50040-026-000 Unemployment Taxes 229.00 7.00 3.057 222.00 135-50045-026-000 Workman's Compensation 15.52 15.52 Subtotal: 616.88- 700.00 2,214.10 -358.919 2,830.98- 135-55045-026-000 Legal 16,277.12 3,766.50 3,766.50 23.140 12,510.62 135-55055-026-000 Auditing 7,358.00 7,358.00 135-55065-026-000 Tax Admin Fees 8,492.24 3,633.95 3,633.95 42.791 4,858.29 135-55160-026-000 Professional Outside Services 500.00- 500.00- Subtotal: 31,627.36 7,400.45 7,400.45 23.399 24,226.91 135-60035-026-000 Postage 20.53- 20.53- 135-60066-026-000 Publications/Books/Subscripts 20.00- 20.00- 135-60070-026-000 Dues & Memberships 8.00 8.00 135-60075-026-000 Meetings 92.34 50.00 54.148 42.34 135-60080-026-000 Schools & Training 805.00 805.00 135-60100-026-000 Travel & per diem 552.39- 76.75 76.75 -13.894 629.14- 135-60115-026-000 Elections 253.00- 253.00- 135-60125-026-000 Advertising 26.20 42.00 42.00 160.305 15.80- 135-60245-026-000 Miscellaneous Expenses 190.16 190.16 135-60336-026-000 Interfund Trans Out (MUD1 I&S) 38.63 200,500.00 200,500.00 ############### 200,461.37- 135-60344-026-000 Intergov Trans Out (Fire CIP) 127,633.60- 127,633.60- 135-60345-026-000 Intergov Trans Out (Fire Dept) 26,533.38- 26,533.38- Subtotal: 153,852.57- 200,618.75 200,668.75 -130.429 354,521.32- 135-65085-026-000 Office Supplies 200.00 200.00 Subtotal: 200.00 200.00 135-69290-026-000 To MUD2 Water Plant Renovation .35 .35 Subtotal: .35 .35 135-70005-026-000 Paying Agent Fees 750.00- 750.00- Subtotal: 750.00- 750.00- Program number: 123,391.74- 208,719.20 210,283.30 -170.419 333,675.04- Department number: Board of Directors 123,391.74- 208,719.20 210,283.30 -170.419 333,675.04- . glbase_tbam rgonzale Trophy Club Entities Page 90 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 38,718.25 31,938.56 51,239.03 132.338 12,520.78- 135-50010-027-000 Overtime .34 254.85 321.37 ############### 321.03- 135-50016-027-000 Longevity .50 .50 135-50020-027-000 Retirement 4,736.85 2,372.19 4,736.90 100.001 .05- 135-50026-027-000 Medical Insurance 3,435.60 1,717.86 3,435.70 100.003 .10- 135-50027-027-000 Dental Insurance .90 99.93 199.84 ############### 198.94- 135-50028-027-000 Vision Insurance .79 25.10 50.20 6,354.430 49.41- 135-50029-027-000 Life Insurance & Other 239.91 120.04 240.08 100.071 .17- 135-50030-027-000 Social Security Taxes .43 1,172.47 2,335.44 ############### 2,335.01- 135-50035-027-000 Medicare Taxes .40 274.20 546.17 ############### 545.77- 135-50040-027-000 Unemployment Taxes 623.16 .46 .46 .074 622.70 135-50045-027-000 Workman's Compensation 87.93 87.93 135-50060-027-000 Pre-emp Physicals/Testing 196.00- 196.00- 135-50070-027-000 Employee Relations 201.58 186.73 238.68 118.405 37.10- Subtotal: 47,850.64 38,162.39 63,343.87 132.378 15,493.23- 135-55045-027-000 Legal 4,125.68 497.75 4,125.25 99.990 .43 135-55070-027-000 Independent Labor 355.50 41.25 11.603 314.25 135-55075-027-000 Records Management 429.84 429.84 Subtotal: 4,911.02 497.75 4,166.50 84.840 744.52 135-60005-027-000 Telephone 8.08 13.98 54.76 677.723 46.68- 135-60010-027-000 Communications/Pagers/Mobiles .13 400.10 539.53 ############### 539.40- 135-60035-027-000 Postage .33 117.88 176.33 ############### 176.00- 135-60066-027-000 Publications/Books/Subscripts .55 38.00 6,909.091 37.45- 135-60070-027-000 Dues & Memberships .88 .88 135-60075-027-000 Meetings 72.21 72.00 99.709 .21 135-60080-027-000 Schools & Training 50.00 50.00- 135-60100-027-000 Travel & per diem .16 25.30 348.90 ############### 348.74- 135-60115-027-000 Elections .81 .81 135-60125-027-000 Advertising .48 .48 135-60245-027-000 Miscellaneous Expenses .46 .46 135-60360-027-000 Furniture/Equipment < $5000 .22 .22 Subtotal: 84.31 557.26 1,279.52 1,517.637 1,195.21- 135-65085-027-000 Office Supplies .02 248.35 306.31 ############### 306.29- 135-65105-027-000 Printing 219.24 7.50 3.421 211.74 Subtotal: 219.26 248.35 313.81 143.122 94.55- Program number: 53,065.23 39,465.75 69,103.70 130.224 16,038.47- . glbase_tbam rgonzale Trophy Club Entities Page 91 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 53,065.23 39,465.75 69,103.70 130.224 16,038.47- . glbase_tbam rgonzale Trophy Club Entities Page 92 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-028-000 Salaries & Wages 2,152.76 1,465.67 3,403.71 158.109 1,250.95- 135-50016-028-000 Longevity .50 .50 135-50020-028-000 Retirement 473.62 236.64 473.28 99.928 .34 135-50026-028-000 Medical Insurance 403.09 201.49 402.99 99.975 .10 135-50027-028-000 Dental Insurance 75.58 11.54 23.07 30.524 52.51 135-50028-028-000 Vision Insurance 7.30 2.98 5.97 81.781 1.33 135-50029-028-000 Life Insurance & Other 28.47 14.07 28.14 98.841 .33 135-50030-028-000 Social Security Taxes 140.92 20.08 140.23 99.510 .69 135-50035-028-000 Medicare Taxes 33.58 4.71 32.82 97.737 .76 135-50040-028-000 Unemployment Taxes 138.85 138.85 135-50045-028-000 Workman's Compensation 14.27 14.27 135-50070-028-000 Employee Relations 71.22 14.38 18.36 25.779 52.86 135-50994-028-000 Employee Assistance Program 218.60 105.00 210.00 96.066 8.60 135-50995-028-000 Flexible Benefits Admin Fee 317.60 91.68 408.36 128.577 90.76- Subtotal: 4,076.36 2,168.24 5,146.93 126.263 1,070.57- 135-60005-028-000 Telephone 26.04 .31 1.51 5.799 24.53 135-60010-028-000 Communications/Pagers/Mobiles 68.27 31.46 46.92 68.727 21.35 135-60035-028-000 Postage 41.17 25.83 39.44 95.798 1.73 135-60066-028-000 Publications/Books/Subscripts 79.76 79.76 135-60070-028-000 Dues & Memberships 268.44 80.00 29.802 188.44 135-60075-028-000 Meetings 130.00 130.00 135-60080-028-000 Schools & Training 221.00 221.00 135-60100-028-000 Travel & per diem 67.93 67.93 135-60110-028-000 Physicals/Testing 407.50 407.50 Subtotal: 1,310.11 57.60 167.87 12.813 1,142.24 135-65085-028-000 Office Supplies 313.30 2.91 8.30 2.649 305.00 135-65105-028-000 Printing 67.45 67.45 Subtotal: 380.75 2.91 8.30 2.180 372.45 Program number: 5,767.22 2,228.75 5,323.10 92.299 444.12 Department number: Human Resources 5,767.22 2,228.75 5,323.10 92.299 444.12 . glbase_tbam rgonzale Trophy Club Entities Page 93 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 38,562.59 18,536.95 28,730.89 74.505 9,831.70 135-50010-029-000 Overtime 1,537.34 512.06 656.20 42.684 881.14 135-50016-029-000 Longevity 115.25 115.25 135-50020-029-000 Retirement 4,987.54 1,263.06 2,525.33 50.633 2,462.21 135-50026-029-000 Medical Insurance 3,424.57 911.84 1,823.69 53.253 1,600.88 135-50027-029-000 Dental Insurance 213.55 56.90 113.80 53.290 99.75 135-50028-029-000 Vision Insurance 75.18 12.43 24.87 33.081 50.31 135-50029-029-000 Life Insurance & Other 384.55 63.45 126.88 32.994 257.67 135-50030-029-000 Social Security Taxes 2,725.71 685.92 1,271.36 46.643 1,454.35 135-50035-029-000 Medicare Taxes 637.23 160.39 297.31 46.657 339.92 135-50040-029-000 Unemployment Taxes 555.84 555.84 135-50045-029-000 Workman's Compensation 79.23 79.23 135-50060-029-000 Pre-emp Physicals/Testing .54 .54 Subtotal: 53,299.12 22,203.00 35,570.33 66.737 17,728.79 135-55055-029-000 Auditing 4,730.00 4,730.00 Subtotal: 4,730.00 4,730.00 135-60005-029-000 Telephone 82.23 3.32 12.65 15.384 69.58 135-60010-029-000 Communications/Pagers/Mobiles 103.43 71.45 106.91 103.365 3.48- 135-60035-029-000 Postage 111.91 36.86 58.24 52.042 53.67 135-60040-029-000 Service Charges & Fees 197.50 197.50 135-60066-029-000 Publications/Books/Subscripts 172.00 172.00 135-60070-029-000 Dues & Memberships .50 67.50 ############### 67.00- 135-60075-029-000 Meetings 130.89 130.89 135-60080-029-000 Schools & Training .36 135.00 ############### 134.64- 135-60100-029-000 Travel & per diem 727.44 12.24 19.36 2.661 708.08 135-60245-029-000 Miscellaneous Expenses 185.12 4.00- -2.161 189.12 Subtotal: 1,711.38 123.87 395.66 23.119 1,315.72 135-65085-029-000 Office Supplies 1,054.21 553.71 557.54 52.887 496.67 135-65105-029-000 Printing 124.82 268.68 268.68 215.254 143.86- Subtotal: 1,179.03 822.39 826.22 70.076 352.81 Program number: 60,919.53 23,149.26 36,792.21 60.395 24,127.32 Department number: Finance 60,919.53 23,149.26 36,792.21 60.395 24,127.32 . glbase_tbam rgonzale Trophy Club Entities Page 94 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-033-000 Salaries & Wages 10,557.37 7,307.99 11,748.60 111.283 1,191.23- 135-50016-033-000 Longevity .50 .50 135-50020-033-000 Retirement 1,243.23 542.20 1,084.38 87.223 158.85 135-50026-033-000 Medical Insurance 821.04 403.00 806.00 98.168 15.04 135-50027-033-000 Dental Insurance 48.48 23.06 46.10 95.091 2.38 135-50028-033-000 Vision Insurance 16.41 5.96 11.92 72.639 4.49 135-50029-033-000 Life Insurance & Other 132.57 29.36 58.72 44.294 73.85 135-50030-033-000 Social Security Taxes 628.87 274.89 549.77 87.422 79.10 135-50035-033-000 Medicare Taxes 147.48 64.29 128.57 87.178 18.91 135-50040-033-000 Unemployment Taxes 280.02 280.02 135-50045-033-000 Workman's Compensation 33.99 33.99 Subtotal: 13,909.96 8,650.75 14,434.06 103.768 524.10- 135-55030-033-000 Software & Support 14,484.78 15,944.48 19,843.59 136.996 5,358.81- 135-55070-033-000 Independent Labor 846.50 846.50 Subtotal: 15,331.28 15,944.48 19,843.59 129.432 4,512.31- 135-60005-033-000 Telephone 9,121.33 404.20 2,523.99 27.671 6,597.34 135-60010-033-000 Communications/Pagers/Mobiles 284.24 143.00 216.25 76.080 67.99 135-60035-033-000 Postage 77.48 5.17 5.17 6.673 72.31 135-60040-033-000 Service Charges & Fees .93 .93 135-60066-033-000 Publications/Books/Subscripts 56.33 56.33 135-60070-033-000 Dues & Memberships 47.03 44.50 44.50 94.620 2.53 135-60075-033-000 Meetings 64.00 64.00 135-60080-033-000 Schools & Training 1,338.00 1,338.00 135-60100-033-000 Travel & per diem 1,379.86 4.95 .359 1,374.91 135-60235-033-000 Security 1,322.75 82.25 128.50 9.715 1,194.25 Subtotal: 13,691.95 679.12 2,923.36 21.351 10,768.59 135-65055-033-000 Hardware 6,780.45 1,313.93 1,704.35 25.136 5,076.10 135-65085-033-000 Office Supplies 120.98 7.81 6.456 113.17 135-65090-033-000 Printer Supplies & Maintenance 1,888.60 1,156.03 1,432.23 75.836 456.37 135-65105-033-000 Printing 100.00 100.00 Subtotal: 8,890.03 2,469.96 3,144.39 35.370 5,745.64 135-69170-033-000 Copier Lease Installments 717.10 273.29 546.58 76.221 170.52 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 100.000 Subtotal: 27,628.10 27,184.29 27,457.58 99.383 170.52 Program number: 79,451.32 54,928.60 67,802.98 85.339 11,648.34 . glbase_tbam rgonzale Trophy Club Entities Page 95 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Information Systems 79,451.32 54,928.60 67,802.98 85.339 11,648.34 . glbase_tbam rgonzale Trophy Club Entities Page 96 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55100-037-000 Building Maint & Supplies 13,161.29 3,082.23 3,403.10 25.857 9,758.19 135-55120-037-000 Cleaning Services 1,730.12 694.35 1,921.24 111.047 191.12- Subtotal: 14,891.41 3,776.58 5,324.34 35.754 9,567.07 135-60020-037-000 Electricity 7,494.86 2,769.90 4,015.05 53.571 3,479.81 135-60025-037-000 Water 405.78 72.23 161.55 39.812 244.23 135-60030-037-000 Rent And/Or Usage 2,196.90 2,197.02 2,197.02 100.005 .12- 135-60055-037-000 Insurance 4,915.67 125.00 2.543 4,790.67 Subtotal: 15,013.21 5,039.15 6,498.62 43.286 8,514.59 135-65095-037-000 Maintenance Supplies 1,978.70 162.86 263.34 13.309 1,715.36 135-65097-037-000 Vending Machine Supplies 107.81 144.28 144.28 133.828 36.47- Subtotal: 2,086.51 307.14 407.62 19.536 1,678.89 Program number: 31,991.13 9,122.87 12,230.58 38.231 19,760.55 Department number: Facilities Maintenance 31,991.13 9,122.87 12,230.58 38.231 19,760.55 . glbase_tbam rgonzale Trophy Club Entities Page 97 21:55 11/13/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 11,699.81 9,641.05 15,480.32 132.313 3,780.51- 135-50010-038-000 Overtime 112.54 104.40 171.19 152.115 58.65- 135-50020-038-000 Retirement 1,678.18 721.20 1,442.33 85.946 235.85 135-50026-038-000 Medical Insurance 1,805.97 902.74 1,805.48 99.973 .49 135-50027-038-000 Dental Insurance 217.65 55.30 110.60 50.816 107.05 135-50028-038-000 Vision Insurance 65.62 14.04 28.08 42.792 37.54 135-50029-038-000 Life Insurance & Other 222.74 42.85 85.70 38.475 137.04 135-50030-038-000 Social Security Taxes 1,042.05 340.79 681.54 65.404 360.51 135-50035-038-000 Medicare Taxes 243.39 79.70 159.39 65.487 84.00 135-50040-038-000 Unemployment Taxes 558.00 558.00 135-50045-038-000 Workman's Compensation 44.78 44.78 Subtotal: 17,690.73 11,902.07 19,964.63 112.854 2,273.90- 135-55205-038-000 Utility Billing Contract 1,597.14 827.97 1,604.53 100.463 7.39- Subtotal: 1,597.14 827.97 1,604.53 100.463 7.39- 135-60005-038-000 Telephone 200.57 5.91 15.35 7.653 185.22 135-60010-038-000 Communications/Pagers/Mobiles 94.17 62.92 93.85 99.660 .32 135-60035-038-000 Postage 4,029.14 1,219.33 2,388.59 59.283 1,640.55 135-60040-038-000 Service Charges & Fees 2,764.37 3,033.12 4,207.21 152.194 1,442.84- 135-60070-038-000 Dues & Memberships 54.00 54.00 135-60080-038-000 Schools & Training 800.00 800.00 135-60100-038-000 Travel & per diem 860.00 860.00 135-60130-038-000 Reg Assessment Fee (5%) 3,189.48 3,189.48 135-60245-038-000 Miscellaneous Expenses 152.66 152.66 Subtotal: 12,144.39 4,321.28 6,705.00 55.211 5,439.39 135-65085-038-000 Office Supplies 118.57 39.83 39.83 33.592 78.74 135-65105-038-000 Printing .96 .96 Subtotal: 119.53 39.83 39.83 33.322 79.70 Program number: 31,551.79 17,091.15 28,313.99 89.738 3,237.80 Department number: Utility Billing 31,551.79 17,091.15 28,313.99 89.738 3,237.80 Expenditures Subtotal ----------- 1,465,793.01 762,571.43 1,388,547.23 94.730 77,245.78 Fund number: 135 MUD 1 O&M CONSOLIDATED 267,905.98- 301,935.70 431,432.41 -161.039 699,338.39- . glbase_tbam rgonzale Trophy Club Entities Page 124 21:55 11/13/09 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-43425-000-000 Intergov Trans in-MUD 2 Fire 1,037,883.60- 1,037,883.60 315-43429-000-000 Intergov Trans In-MUD 2 740,250.00- 740,250.00 Subtotal: 1,778,133.60- 1,778,133.60 315-49010-000-000 Interest Income 413.42- 4,719.88- 4,719.88 Subtotal: 413.42- 4,719.88- 4,719.88 Program number: 413.42- 1,782,853.48- 1,782,853.48 Department number: Revenues 413.42- 1,782,853.48- 1,782,853.48 Revenues Subtotal ----------- 413.42- 1,782,853.48- 1,782,853.48 Fund number: 315 MASTER DIST CIP FIRE STATION 413.42- 1,782,853.48- 1,782,853.48 . glbase_tbam rgonzale Trophy Club Entities Page 146 21:55 11/13/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 21,012.19 3,508.46- 3,473.79- -16.532 24,485.98 533-40015-000-000 Property Taxes/P & I 2,188.78 642.84- 982.40- -44.883 3,171.18 Subtotal: 23,200.97 4,151.30- 4,456.19- -19.207 27,657.16 533-43235-000-000 Contribution from MUD 1 200,500.00- 200,500.00- 200,500.00 Subtotal: 200,500.00- 200,500.00- 200,500.00 533-49010-000-000 Interest Income 21,179.60- 4.21- 285.41- 1.348 20,894.19- 533-49035-000-000 Prior Year Reserves 110,000.00- 110,000.00- 533-49090-000-000 From M1 Water Plant Renovation .35- .35- 533-49141-000-000 Interfund Trans In (O&M) 24,961.37 24,961.37 Subtotal: 106,218.58- 4.21- 285.41- .269 105,933.17- Program number: 83,017.61- 204,655.51- 205,241.60- 247.227 122,223.99 Department number: Revenues 83,017.61- 204,655.51- 205,241.60- 247.227 122,223.99 Revenues Subtotal ----------- 83,017.61- 204,655.51- 205,241.60- 247.227 122,223.99 . glbase_tbam rgonzale Trophy Club Entities Page 147 21:55 11/13/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 09/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 2,160.00 609.50 2,159.50 99.977 .50 533-70025-051-000 Bond Interest Expense 174,718.50 174,717.50 99.999 1.00 533-70035-051-000 Bond Principal Payment 1,025,000.00 1,025,000.00 100.000 Subtotal: 1,201,878.50 609.50 1,201,877.00 100.000 1.50 Program number: 1,201,878.50 609.50 1,201,877.00 100.000 1.50 Department number: Administration 1,201,878.50 609.50 1,201,877.00 100.000 1.50 Expenditures Subtotal ----------- 1,201,878.50 609.50 1,201,877.00 100.000 1.50