Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
August 2009 Budget Summary-Consolidation
. glbase_tbam rgonzale Trophy Club Entities Page 74 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 08/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 4.50 4.50 .147 3,053.19 135-40010-000-000 Property Taxes/MUD Fire 21,909.50 9.36 9.36 .043 21,900.14 135-40015-000-000 Property Taxes/P & I 520.25 31.05- 31.05- -5.968 551.30 135-40020-000-000 Property Taxes/Fire P & I 4,818.86 285.06- 285.06- -5.916 5,103.92 Subtotal: 30,306.30 302.25- 302.25- -.997 30,608.55 135-47000-000-000 Water 608,138.51- 184,932.89- 184,932.89- 30.410 423,205.62- 135-47005-000-000 Sewer 312,227.46- 98,524.90- 98,524.90- 31.555 213,702.56- 135-47010-000-000 Commercial Water 220,903.82- 91,155.30- 91,155.30- 41.265 129,748.52- 135-47015-000-000 Commercial Sewer 109,459.56- 34,132.48- 34,132.48- 31.183 75,327.08- 135-47020-000-000 Standby 551.60- 65.00- 65.00- 11.784 486.60- 135-47025-000-000 Penalties 29,775.86- 6,410.58- 6,410.58- 21.529 23,365.28- 135-47030-000-000 Service Charges 12,115.19 1,474.29- 1,474.29- -12.169 13,589.48 135-47035-000-000 Plumbing Inspections 2,100.00 100.00- 100.00- -4.762 2,200.00 135-47045-000-000 Sewer Inspections 4,109.00- 300.00- 300.00- 7.301 3,809.00- 135-47050-000-000 Tap Fees 42,742.00- 42,742.00- 135-47070-000-000 TCCC Effluent Charges 36,349.64- 11,018.26- 11,018.26- 30.312 25,331.38- 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 5,755.48- 5,755.48- -78.484 13,088.75 135-47405-000-000 Out of District Sewer 4,222.94 1,051.78- 1,051.78- -24.906 5,274.72 135-47410-000-000 Out of Dist/Portable Penalties 1,660.74- 631.78- 631.78- 38.042 1,028.96- 135-47600-000-000 PID #1 Water 31,135.84- 16,062.29- 16,062.29- 51.588 15,073.55- 135-47605-000-000 PID #1 Sewer 43,023.31- 2,203.93- 2,203.93- 5.123 40,819.38- Subtotal: 1,409,055.94- 453,818.96- 453,818.96- 32.207 955,236.98- 135-48005-000-000 Utility Fees 87,400.00 32,200.00- 32,200.00- -36.842 119,600.00 Subtotal: 87,400.00 32,200.00- 32,200.00- -36.842 119,600.00 135-49005-000-000 Loan Proceeds 377,750.00- 377,750.00- 135-49010-000-000 Interest Income 56,911.93- 293.12- 293.12- .515 56,618.81- 135-49015-000-000 Lease/Rental Income 1,694.00- 847.00- 847.00- 50.000 847.00- 135-49030-000-000 Vending Revenue 950.00- 950.00- 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 135-49075-000-000 New Oversize Meter Reimburse 6,600.12 5,120.00- 5,120.00- -77.574 11,720.12 135-49900-000-000 Miscellaneous Income 8,771.35 618.69- 618.69- -7.054 9,390.04 135-49901-000-000 Records Management Revenue 146.59 4.30- 4.30- -2.933 150.89 135-49902-000-000 Sewer/Septic Dump Revenue 8,845.00- 3,055.00- 3,055.00- 34.539 5,790.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- 219.77- 219.77- 5.517 3,763.71- Subtotal: 442,349.35- 10,157.88- 10,157.88- 2.296 432,191.47- . glbase_tbam rgonzale Trophy Club Entities Page 75 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Program number: 1,733,698.99- 496,479.09- 496,479.09- 28.637 1,237,219.90- Department number: Revenues 1,733,698.99- 496,479.09- 496,479.09- 28.637 1,237,219.90- Revenues Subtotal ----------- 1,733,698.99- 496,479.09- 496,479.09- 28.637 1,237,219.90- . glbase_tbam rgonzale Trophy Club Entities Page 76 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 69,174.23 9,025.60 9,025.60 13.048 60,148.63 135-50010-010-000 Overtime 2,123.74 1,209.52 1,209.52 56.952 914.22 135-50017-010-000 Certification 890.00 115.00 115.00 12.921 775.00 135-50020-010-000 Retirement 17,578.75 1,263.75 1,263.75 7.189 16,315.00 135-50026-010-000 Medical Insurance 15,845.88 1,209.00 1,209.00 7.630 14,636.88 135-50027-010-000 Dental Insurance 1,081.07 69.18 69.18 6.399 1,011.89 135-50028-010-000 Vision Insurance 284.02 17.88 17.88 6.295 266.14 135-50029-010-000 Life Insurance & Other 1,077.80 66.22 66.22 6.144 1,011.58 135-50030-010-000 Social Security Taxes 8,366.22 638.17 638.17 7.628 7,728.05 135-50035-010-000 Medicare Taxes 1,956.77 149.25 149.25 7.627 1,807.52 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 42.89 4.346 944.04 Subtotal: 123,474.22 13,806.46 13,806.46 11.182 109,667.76 135-55080-010-000 Maintenance & Repairs 2,801.74 3,213.00 3,213.00 114.679 411.26- 135-55090-010-000 Vehicle Maintenance 1,179.37 1,179.37 135-55100-010-000 Building Maint & Supplies 343.83 343.83 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,885.17 2,885.17 135-55135-010-000 Lab Analysis 1,324.00 1,070.00 1,070.00 80.816 254.00 Subtotal: 8,534.11 4,283.00 4,283.00 50.187 4,251.11 135-60010-010-000 Communications/Pagers/Mobiles 879.46 209.68 209.68 23.842 669.78 135-60020-010-000 Electricity 55,050.21 18,711.60 18,711.60 33.990 36,338.61 135-60035-010-000 Postage 100.00 100.00 135-60050-010-000 Bad Debt Expense 1,528.93 42.75- 42.75- -2.796 1,571.68 135-60066-010-000 Publications/Books/Subscripts 50.00 50.00 135-60070-010-000 Dues & Memberships 115.00 35.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 111.10 111.10 18.544 488.03 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 149,938.23 149,938.23 37.741 247,339.83 135-60245-010-000 Miscellaneous Expenses 1.17 1.17 135-60280-010-000 Property Maintenance 2,845.50 162.52 162.52 5.711 2,682.98 135-60285-010-000 Lawn Equipment & Maintenance 1,810.91 29.97 29.97 1.655 1,780.94 Subtotal: 461,520.74 169,155.35 169,155.35 36.652 292,365.39 135-65005-010-000 Fuel & Lube 8,043.29 745.28 745.28 9.266 7,298.01 135-65010-010-000 Uniforms 1,782.01 1,782.01 . glbase_tbam rgonzale Trophy Club Entities Page 77 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-010-000 Chemicals 971.14 971.14 135-65035-010-000 Small Tools 2,479.07 16.49 16.49 .665 2,462.58 135-65040-010-000 Safety Equipment 2,457.77 2,457.77 135-65050-010-000 Meter Expense 30,559.00 370.00 370.00 1.211 30,189.00 135-65055-010-000 Hardware 626.50 626.50 135-65095-010-000 Maintenance Supplies 17,903.91 746.61 746.61 4.170 17,157.30 135-65100-010-000 Copies 50.00 50.00 135-65105-010-000 Printing 30.50 30.50 Subtotal: 64,903.19 1,878.38 1,878.38 2.894 63,024.81 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 11,084.37 96.470 405.63 Subtotal: 90,036.22 11,084.37 11,084.37 12.311 78,951.85 Program number: 748,468.48 200,207.56 200,207.56 26.749 548,260.92 Department number: Water 748,468.48 200,207.56 200,207.56 26.749 548,260.92 . glbase_tbam rgonzale Trophy Club Entities Page 78 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages .71 12,692.80 12,692.80 ############### 12,692.09- 135-50010-020-000 Overtime .47 1,245.54 1,245.54 ############### 1,245.07- 135-50016-020-000 Longevity .50 .50 135-50017-020-000 Certification 950.00 175.00 175.00 18.421 775.00 135-50020-020-000 Retirement .84 1,723.22 1,723.22 ############### 1,722.38- 135-50026-020-000 Medical Insurance .20 2,177.22 2,177.22 ############### 2,177.02- 135-50027-020-000 Dental Insurance .53 147.50 147.50 ############### 146.97- 135-50028-020-000 Vision Insurance .62 32.58 32.58 5,254.839 31.96- 135-50029-020-000 Life Insurance & Other 129.85 92.22 92.22 71.020 37.63 135-50030-020-000 Social Security Taxes .82 745.84 745.84 ############### 745.02- 135-50035-020-000 Medicare Taxes .85 174.42 174.42 ############### 173.57- 135-50040-020-000 Unemployment Taxes 554.82 554.82 135-50045-020-000 Workman's Compensation 795.84 795.84 135-50070-020-000 Employee Relations 163.96 163.96 Subtotal: 2,600.01 19,206.34 19,206.34 738.703 16,606.33- 135-55005-020-000 Engineering 1,500.00 1,500.00 135-55070-020-000 Independent Labor 90.00 90.00 135-55080-020-000 Maintenance & Repairs 2,693.90 947.17 947.17 35.160 1,746.73 135-55090-020-000 Vehicle Maintenance 1,368.80 1,368.80 135-55100-020-000 Building Maint & Supplies 1,431.78 1,431.78 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,900.00 55.07 55.07 1.899 2,844.93 135-55125-020-000 Dumpster Services 9,888.40 3,452.90 3,452.90 34.919 6,435.50 135-55135-020-000 Lab Analysis 6,400.50 6,400.50 Subtotal: 26,273.38 4,455.14 4,455.14 16.957 21,818.24 135-60010-020-000 Communications/Pagers/Mobiles .09 228.74 228.74 ############### 228.65- 135-60020-020-000 Electricity 35,997.19 14,891.84 14,891.84 41.369 21,105.35 135-60025-020-000 Water 1,129.86 227.20 227.20 20.109 902.66 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 474.00 111.00 111.00 23.418 363.00 135-60090-020-000 Safety Program 200.00 200.00 135-60100-020-000 Travel & per diem .09 183.70 183.70 ############### 183.61- 135-60105-020-000 Rent/Lease Equipment 189.00 189.00 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: 41,182.33 15,642.48 15,642.48 37.983 25,539.85 135-65005-020-000 Fuel & Lube .38 204.87 204.87 ############### 204.49- . glbase_tbam rgonzale Trophy Club Entities Page 79 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 1,034.37 1,034.37 135-65030-020-000 Chemicals 2,119.41 2,809.20 2,809.20 132.546 689.79- 135-65035-020-000 Small Tools 897.32 897.32 135-65040-020-000 Safety Equipment 192.39 192.39 135-65045-020-000 Lab Supplies .40 818.81 818.81 ############### 818.41- 135-65055-020-000 Hardware 417.27 417.27 135-65085-020-000 Office Supplies 46.01 13.82 13.82 30.037 32.19 135-65095-020-000 Maintenance Supplies 3,124.32 3,124.32 135-65115-020-000 Other Consumables 100.00 100.00 Subtotal: 7,931.87 3,846.70 3,846.70 48.497 4,085.17 135-69005-020-000 Capital Expenses 251,009.75 254,000.00 254,000.00 101.191 2,990.25- 135-69280-020-000 Capital Repairs 26,043.73 26,043.73 Subtotal: 277,053.48 254,000.00 254,000.00 91.679 23,053.48 Program number: 355,041.07 297,150.66 297,150.66 83.695 57,890.41 Department number: Wastewater 355,041.07 297,150.66 297,150.66 83.695 57,890.41 . glbase_tbam rgonzale Trophy Club Entities Page 80 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 08/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 9,788.80 9,788.80 26.595 27,018.24 135-50010-021-000 Overtime 4,185.93 752.83 752.83 17.985 3,433.10 135-50017-021-000 Certification 125.00 125.00 125.00- 135-50020-021-000 Retirement 5,104.70 1,302.40 1,302.40 25.514 3,802.30 135-50026-021-000 Medical Insurance 3,985.92 1,517.48 1,517.48 38.071 2,468.44 135-50027-021-000 Dental Insurance 310.24 106.08 106.08 34.193 204.16 135-50028-021-000 Vision Insurance 91.60 23.00 23.00 25.109 68.60 135-50029-021-000 Life Insurance & Other 462.11 70.14 70.14 15.178 391.97 135-50030-021-000 Social Security Taxes 2,958.28 596.13 596.13 20.151 2,362.15 135-50035-021-000 Medicare Taxes 691.91 139.42 139.42 20.150 552.49 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 14,421.28 14,421.28 25.398 42,359.95 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 128.98 128.98 12.143 933.16 135-60020-021-000 Electricity 7,177.32 1,717.82 1,717.82 23.934 5,459.50 135-60025-021-000 Water 1,065.52 9.06 9.06 .850 1,056.46 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 2,156.00 135-60090-021-000 Safety Program 750.00 750.00 135-60100-021-000 Travel & per diem 243.91 116.05 116.05 47.579 127.86 135-60105-021-000 Rent/Lease Equipment 39,000.00 36,411.50 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 38,383.41 38,383.41 72.535 14,533.48 135-65005-021-000 Fuel & Lube 5,310.50 668.61 668.61 12.590 4,641.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 81 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 34,265.98 668.61 668.61 1.951 33,597.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 53,473.30 53,473.30 22.493 184,254.68 Department number: Collection 237,727.98 53,473.30 53,473.30 22.493 184,254.68 . glbase_tbam rgonzale Trophy Club Entities Page 82 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 08/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- 1,400.00 1,400.00 -175.000 2,200.00- 135-50030-026-000 Social Security Taxes 49.20- 86.80 86.80 -176.423 136.00- 135-50035-026-000 Medicare Taxes 12.20- 20.30 20.30 -166.393 32.50- 135-50040-026-000 Unemployment Taxes 229.00 7.00 7.00 3.057 222.00 135-50045-026-000 Workman's Compensation 15.52 15.52 Subtotal: 616.88- 1,514.10 1,514.10 -245.445 2,130.98- 135-55045-026-000 Legal 16,277.12 16,277.12 135-55055-026-000 Auditing 7,358.00 7,358.00 135-55065-026-000 Tax Admin Fees 8,492.24 8,492.24 135-55160-026-000 Professional Outside Services 500.00- 500.00- Subtotal: 31,627.36 31,627.36 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 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- 552.39- 135-60115-026-000 Elections 253.00- 253.00- 135-60125-026-000 Advertising 26.20 26.20 135-60245-026-000 Miscellaneous Expenses 190.16 190.16 135-60336-026-000 Interfund Trans Out (MUD1 I&S) 38.63 38.63 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- 50.00 50.00 -.032 153,902.57- 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- 1,564.10 1,564.10 -1.268 124,955.84- Department number: Board of Directors 123,391.74- 1,564.10 1,564.10 -1.268 124,955.84- . glbase_tbam rgonzale Trophy Club Entities Page 83 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages .25 19,300.47 19,300.47 ############### 19,300.22- 135-50006-027-000 Salary Adjustments 36,330.00 36,330.00 135-50010-027-000 Overtime .34 66.52 66.52 ############### 66.18- 135-50016-027-000 Longevity .50 .50 135-50020-027-000 Retirement .85 2,364.71 2,364.71 ############### 2,363.86- 135-50026-027-000 Medical Insurance .60 1,717.84 1,717.84 ############### 1,717.24- 135-50027-027-000 Dental Insurance .90 99.91 99.91 ############### 99.01- 135-50028-027-000 Vision Insurance .79 25.10 25.10 3,177.215 24.31- 135-50029-027-000 Life Insurance & Other .91 120.04 120.04 ############### 119.13- 135-50030-027-000 Social Security Taxes .43 1,162.97 1,162.97 ############### 1,162.54- 135-50035-027-000 Medicare Taxes .40 271.97 271.97 ############### 271.57- 135-50040-027-000 Unemployment Taxes 623.16 623.16 135-50045-027-000 Workman's Compensation 87.93 87.93 135-50070-027-000 Employee Relations 201.58 51.95 51.95 25.771 149.63 Subtotal: 37,248.64 25,181.48 25,181.48 67.604 12,067.16 135-55045-027-000 Legal .68 3,627.50 3,627.50 ############### 3,626.82- 135-55070-027-000 Independent Labor 355.50 41.25 41.25 11.603 314.25 135-55075-027-000 Records Management 429.84 429.84 Subtotal: 786.02 3,668.75 3,668.75 466.750 2,882.73- 135-60005-027-000 Telephone 8.08 40.78 40.78 504.703 32.70- 135-60010-027-000 Communications/Pagers/Mobiles .13 139.43 139.43 ############### 139.30- 135-60035-027-000 Postage .33 58.45 58.45 ############### 58.12- 135-60066-027-000 Publications/Books/Subscripts .55 38.00 38.00 6,909.091 37.45- 135-60070-027-000 Dues & Memberships .88 .88 135-60075-027-000 Meetings .21 72.00 72.00 ############### 71.79- 135-60080-027-000 Schools & Training 50.00 50.00 50.00- 135-60100-027-000 Travel & per diem .16 323.60 323.60 ############### 323.44- 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: 12.31 722.26 722.26 5,867.262 709.95- 135-65085-027-000 Office Supplies .02 57.96 57.96 ############### 57.94- 135-65105-027-000 Printing 219.24 7.50 7.50 3.421 211.74 Subtotal: 219.26 65.46 65.46 29.855 153.80 Program number: 38,266.23 29,637.95 29,637.95 77.452 8,628.28 . glbase_tbam rgonzale Trophy Club Entities Page 84 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 38,266.23 29,637.95 29,637.95 77.452 8,628.28 . glbase_tbam rgonzale Trophy Club Entities Page 85 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-028-000 Salaries & Wages 2,000.76 1,938.04 1,938.04 96.865 62.72 135-50016-028-000 Longevity .50 .50 135-50020-028-000 Retirement 245.62 236.64 236.64 96.344 8.98 135-50026-028-000 Medical Insurance 366.09 201.50 201.50 55.041 164.59 135-50027-028-000 Dental Insurance 75.58 11.53 11.53 15.255 64.05 135-50028-028-000 Vision Insurance 7.30 2.99 2.99 40.959 4.31 135-50029-028-000 Life Insurance & Other 11.47 14.07 14.07 122.668 2.60- 135-50030-028-000 Social Security Taxes 120.92 120.15 120.15 99.363 .77 135-50035-028-000 Medicare Taxes 28.58 28.11 28.11 98.355 .47 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 3.98 3.98 5.588 67.24 135-50994-028-000 Employee Assistance Program 218.60 105.00 105.00 48.033 113.60 135-50995-028-000 Flexible Benefits Admin Fee 147.60 316.68 316.68 214.553 169.08- Subtotal: 3,447.36 2,978.69 2,978.69 86.405 468.67 135-60005-028-000 Telephone 26.04 1.20 1.20 4.608 24.84 135-60010-028-000 Communications/Pagers/Mobiles 68.27 15.46 15.46 22.645 52.81 135-60035-028-000 Postage 41.17 13.61 13.61 33.058 27.56 135-60066-028-000 Publications/Books/Subscripts 79.76 79.76 135-60070-028-000 Dues & Memberships 268.44 80.00 80.00 29.802 188.44 135-60075-028-000 Meetings 130.00 130.00 135-60080-028-000 Schools & Training 850.00 850.00 135-60100-028-000 Travel & per diem 67.93 67.93 135-60110-028-000 Physicals/Testing 407.50 407.50 Subtotal: 1,939.11 110.27 110.27 5.687 1,828.84 135-65085-028-000 Office Supplies 313.30 5.39 5.39 1.720 307.91 135-65105-028-000 Printing 67.45 67.45 Subtotal: 380.75 5.39 5.39 1.416 375.36 Program number: 5,767.22 3,094.35 3,094.35 53.654 2,672.87 Department number: Human Resources 5,767.22 3,094.35 3,094.35 53.654 2,672.87 . glbase_tbam rgonzale Trophy Club Entities Page 86 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 08/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 10,193.94 10,193.94 26.435 28,368.65 135-50010-029-000 Overtime 1,537.34 144.14 144.14 9.376 1,393.20 135-50016-029-000 Longevity 115.25 115.25 135-50020-029-000 Retirement 4,987.54 1,262.27 1,262.27 25.308 3,725.27 135-50026-029-000 Medical Insurance 3,424.57 911.85 911.85 26.627 2,512.72 135-50027-029-000 Dental Insurance 213.55 56.90 56.90 26.645 156.65 135-50028-029-000 Vision Insurance 75.18 12.44 12.44 16.547 62.74 135-50029-029-000 Life Insurance & Other 384.55 63.43 63.43 16.495 321.12 135-50030-029-000 Social Security Taxes 2,725.71 585.44 585.44 21.478 2,140.27 135-50035-029-000 Medicare Taxes 637.23 136.92 136.92 21.487 500.31 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 13,367.33 13,367.33 25.080 39,931.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 9.33 9.33 11.346 72.90 135-60010-029-000 Communications/Pagers/Mobiles 103.43 35.46 35.46 34.284 67.97 135-60035-029-000 Postage 642.91 21.38 21.38 3.326 621.53 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.50 ############### 67.00- 135-60075-029-000 Meetings 130.89 130.89 135-60080-029-000 Schools & Training .36 135.00 135.00 ############### 134.64- 135-60100-029-000 Travel & per diem 727.44 7.12 7.12 .979 720.32 135-60245-029-000 Miscellaneous Expenses 185.12 4.00- 4.00- -2.161 189.12 Subtotal: 2,242.38 271.79 271.79 12.121 1,970.59 135-65085-029-000 Office Supplies 523.21 3.83 3.83 .732 519.38 135-65105-029-000 Printing 124.82 124.82 Subtotal: 648.03 3.83 3.83 .591 644.20 Program number: 60,919.53 13,642.95 13,642.95 22.395 47,276.58 Department number: Finance 60,919.53 13,642.95 13,642.95 22.395 47,276.58 . glbase_tbam rgonzale Trophy Club Entities Page 87 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 08/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 4,440.61 4,440.61 42.062 6,116.76 135-50016-033-000 Longevity .50 .50 135-50020-033-000 Retirement 1,243.23 542.18 542.18 43.611 701.05 135-50026-033-000 Medical Insurance 821.04 403.00 403.00 49.084 418.04 135-50027-033-000 Dental Insurance 48.48 23.04 23.04 47.525 25.44 135-50028-033-000 Vision Insurance 16.41 5.96 5.96 36.319 10.45 135-50029-033-000 Life Insurance & Other 132.57 29.36 29.36 22.147 103.21 135-50030-033-000 Social Security Taxes 628.87 274.88 274.88 43.710 353.99 135-50035-033-000 Medicare Taxes 147.48 64.28 64.28 43.586 83.20 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 5,783.31 5,783.31 41.577 8,126.65 135-55030-033-000 Software & Support 14,484.78 3,899.11 3,899.11 26.919 10,585.67 135-55070-033-000 Independent Labor 846.50 846.50 Subtotal: 15,331.28 3,899.11 3,899.11 25.432 11,432.17 135-60005-033-000 Telephone 9,271.33 2,119.79 2,119.79 22.864 7,151.54 135-60010-033-000 Communications/Pagers/Mobiles 134.24 73.25 73.25 54.566 60.99 135-60035-033-000 Postage 77.48 77.48 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 47.03 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 4.95 .359 1,374.91 135-60235-033-000 Security 1,322.75 46.25 46.25 3.497 1,276.50 Subtotal: 13,691.95 2,244.24 2,244.24 16.391 11,447.71 135-65055-033-000 Hardware 6,780.45 390.42 390.42 5.758 6,390.03 135-65085-033-000 Office Supplies 120.98 7.81 7.81 6.456 113.17 135-65090-033-000 Printer Supplies & Maintenance 1,888.60 276.20 276.20 14.625 1,612.40 135-65105-033-000 Printing 100.00 100.00 Subtotal: 8,890.03 674.43 674.43 7.586 8,215.60 135-69170-033-000 Copier Lease Installments 717.10 273.29 273.29 38.110 443.81 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 Subtotal: 27,628.10 273.29 273.29 .989 27,354.81 Program number: 79,451.32 12,874.38 12,874.38 16.204 66,576.94 . glbase_tbam rgonzale Trophy Club Entities Page 88 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Information Systems 79,451.32 12,874.38 12,874.38 16.204 66,576.94 . glbase_tbam rgonzale Trophy Club Entities Page 89 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 08/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 320.87 320.87 2.438 12,840.42 135-55120-037-000 Cleaning Services 1,730.12 1,226.89 1,226.89 70.914 503.23 Subtotal: 14,891.41 1,547.76 1,547.76 10.394 13,343.65 135-60020-037-000 Electricity 7,494.86 1,245.15 1,245.15 16.613 6,249.71 135-60025-037-000 Water 405.78 89.32 89.32 22.012 316.46 135-60030-037-000 Rent And/Or Usage 2,196.90 2,196.90 135-60055-037-000 Insurance 4,915.67 125.00 125.00 2.543 4,790.67 Subtotal: 15,013.21 1,459.47 1,459.47 9.721 13,553.74 135-65095-037-000 Maintenance Supplies 1,978.70 100.48 100.48 5.078 1,878.22 135-65097-037-000 Vending Machine Supplies 107.81 107.81 Subtotal: 2,086.51 100.48 100.48 4.816 1,986.03 Program number: 31,991.13 3,107.71 3,107.71 9.714 28,883.42 Department number: Facilities Maintenance 31,991.13 3,107.71 3,107.71 9.714 28,883.42 . glbase_tbam rgonzale Trophy Club Entities Page 90 15:26 10/05/09 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 08/2009 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 13,581.81 5,839.27 5,839.27 42.993 7,742.54 135-50010-038-000 Overtime 25.54 66.79 66.79 261.511 41.25- 135-50020-038-000 Retirement 1,678.18 721.13 721.13 42.971 957.05 135-50026-038-000 Medical Insurance 1,085.97 902.74 902.74 83.128 183.23 135-50027-038-000 Dental Insurance 217.65 55.30 55.30 25.408 162.35 135-50028-038-000 Vision Insurance 65.62 14.04 14.04 21.396 51.58 135-50029-038-000 Life Insurance & Other 222.74 42.85 42.85 19.238 179.89 135-50030-038-000 Social Security Taxes 1,042.05 340.75 340.75 32.700 701.30 135-50035-038-000 Medicare Taxes 243.39 79.69 79.69 32.742 163.70 135-50040-038-000 Unemployment Taxes 558.00 558.00 135-50045-038-000 Workman's Compensation 44.78 44.78 Subtotal: 18,765.73 8,062.56 8,062.56 42.964 10,703.17 135-55070-038-000 Independent Labor 800.00 800.00 135-55205-038-000 Utility Billing Contract 1,597.14 776.56 776.56 48.622 820.58 Subtotal: 2,397.14 776.56 776.56 32.395 1,620.58 135-60005-038-000 Telephone 200.57 9.44 9.44 4.707 191.13 135-60010-038-000 Communications/Pagers/Mobiles .17 30.93 30.93 ############### 30.76- 135-60035-038-000 Postage 4,029.14 1,169.26 1,169.26 29.020 2,859.88 135-60040-038-000 Service Charges & Fees 679.37 1,174.09 1,174.09 172.820 494.72- 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: 9,965.39 2,383.72 2,383.72 23.920 7,581.67 135-65085-038-000 Office Supplies 422.57 422.57 135-65105-038-000 Printing .96 .96 Subtotal: 423.53 423.53 Program number: 31,551.79 11,222.84 11,222.84 35.570 20,328.95 Department number: Utility Billing 31,551.79 11,222.84 11,222.84 35.570 20,328.95 Expenditures Subtotal ----------- 1,465,793.01 625,975.80 625,975.80 42.706 839,817.21 Fund number: 135 MUD 1 O&M CONSOLIDATED 267,905.98- 129,496.71 129,496.71 -48.337 397,402.69- . glbase_tbam rgonzale Trophy Club Entities Page 109 15:26 10/05/09 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 08/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 511.57- 4,306.46- 4,306.46 Subtotal: 511.57- 4,306.46- 4,306.46 Program number: 511.57- 1,782,440.06- 1,782,440.06 Department number: Revenues 511.57- 1,782,440.06- 1,782,440.06 Revenues Subtotal ----------- 511.57- 1,782,440.06- 1,782,440.06 Fund number: 315 MASTER DIST CIP FIRE STATION 511.57- 1,782,440.06- 1,782,440.06 . glbase_tbam rgonzale Trophy Club Entities Page 129 15:26 10/05/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 08/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 34.67 34.67 .165 20,977.52 533-40015-000-000 Property Taxes/P & I 2,188.78 339.56- 339.56- -15.514 2,528.34 Subtotal: 23,200.97 304.89- 304.89- -1.314 23,505.86 533-49010-000-000 Interest Income 21,179.60- 281.20- 281.20- 1.328 20,898.40- 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- 281.20- 281.20- .265 105,937.38- Program number: 83,017.61- 586.09- 586.09- .706 82,431.52- Department number: Revenues 83,017.61- 586.09- 586.09- .706 82,431.52- Revenues Subtotal ----------- 83,017.61- 586.09- 586.09- .706 82,431.52- . glbase_tbam rgonzale Trophy Club Entities Page 130 15:26 10/05/09 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 08/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 1,550.00 1,550.00 71.759 610.00 533-70025-051-000 Bond Interest Expense 174,718.50 174,717.50 174,717.50 99.999 1.00 533-70035-051-000 Bond Principal Payment 1,025,000.00 1,025,000.00 1,025,000.00 100.000 Subtotal: 1,201,878.50 1,201,267.50 1,201,267.50 99.949 611.00 Program number: 1,201,878.50 1,201,267.50 1,201,267.50 99.949 611.00 Department number: Administration 1,201,878.50 1,201,267.50 1,201,267.50 99.949 611.00 Expenditures Subtotal ----------- 1,201,878.50 1,201,267.50 1,201,267.50 99.949 611.00