Loading...
HomeMy WebLinkAboutNov 2011 Financial Summary . glbase_tbam rgonzale Trophy Club Entities Page 1 10:40 12/16/11 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 193,233.00- 193,233.00- 12,545.11- 16,305.23- 8.438 176,927.77- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 7.75- 7.75 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 61,809.88- 65,846.17- 6.114 1,011,129.83- 122-40011-000-000 Property Taxes/Fire-Delinquent 394.18- 2,177.05 2,177.05- 122-40015-000-000 Property Taxes/Assessments P&I 3.88- 5.42- 5.42 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 57.54- 296.28- 3.950 7,203.72- Subtotal: 1,277,709.00- 1,277,709.00- 74,810.59- 80,283.80- 6.283 1,197,425.20- 122-42014-000-000 Fire Permits/Sprinkler 1,200.00- 1,200.00- 1,200.00 Subtotal: 1,200.00- 1,200.00- 1,200.00 122-43400-000-000 Fire Inspections 225.00- 225.00- 225.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 122-43599-000-000 Misc Fire Revenue 1,124.00- 1,124.00- 1,124.00- Subtotal: 11,124.00- 11,124.00- 225.00- 225.00- 2.023 10,899.00- 122-49035-000-000 Prior Year Reserves 23,101.00- 23,101.00- 23,101.00- 122-49900-000-000 Miscellaneous Income 1,675.00- 1,675.00- 1,675.00 Subtotal: 23,101.00- 23,101.00- 1,675.00- 1,675.00- 7.251 21,426.00- Program number: 1,311,934.00- 1,311,934.00- 77,910.59- 83,383.80- 6.356 1,228,550.20- Department number: Fire Revenues 1,311,934.00- 1,311,934.00- 77,910.59- 83,383.80- 6.356 1,228,550.20- Revenues Subtotal ----------- 1,311,934.00- 1,311,934.00- 77,910.59- 83,383.80- 6.356 1,228,550.20- . glbase_tbam rgonzale Trophy Club Entities Page 2 10:40 12/16/11 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 425,748.00 425,748.00 31,550.99 63,979.88 15.028 361,768.12 122-50010-045-000 Overtime 42,000.00 42,000.00 4,915.95 8,978.28 21.377 33,021.72 122-50011-045-000 DPS Holiday Pay 12,133.00 12,133.00 13,773.02 13,773.02 113.517 1,640.02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 494.70 989.40 24.292 3,083.60 122-50020-045-000 Retirement 68,264.00 68,264.00 7,642.38 12,684.53 18.582 55,579.47 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,339.37 6,679.65 12.560 46,504.35 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 291.82 583.78 17.755 2,704.22 122-50028-045-000 Vision Insurance 857.00 857.00 65.90 131.85 15.385 725.15 122-50029-045-000 Life Insurance & Other 2,740.00 2,740.00 2,740.00 122-50030-045-000 Social Security Taxes 30,231.00 30,231.00 3,189.67 5,296.57 17.520 24,934.43 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 745.94 1,238.72 17.521 5,831.28 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 8.56 33.10 2.243 1,442.90 122-50045-045-000 Workman's Compensation 8,793.00 8,793.00 8,309.50 94.501 483.50 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 35.00 35.00 5.185 640.00 Subtotal: 664,179.00 664,179.00 69,767.76 126,427.74 19.035 537,751.26 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 79.21 79.21 .828 9,482.79 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 14,850.00 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 9,808.00 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 993.84 1,705.49 15.504 9,294.51 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 1,103.00 122-55160-045-000 Professional Outside Services 20,000.00 20,000.00 20,000.00 Subtotal: 66,323.00 66,323.00 1,073.05 1,784.70 2.691 64,538.30 122-60005-045-000 Telephone 106.00 106.00 11.09 10.462 94.91 122-60010-045-000 Communications/Pagers/Mobiles 4,411.00 4,411.00 409.30 440.28 9.981 3,970.72 122-60020-045-000 Electricity 18,270.00 18,270.00 943.76 1,544.69 8.455 16,725.31 122-60025-045-000 Water 3,289.00 3,289.00 184.23 1,105.54 33.613 2,183.46 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 122-60035-045-000 Postage 97.00 97.00 1.72 10.59 10.918 86.41 122-60055-045-000 Insurance 20,974.00 20,974.00 8,078.00 38.514 12,896.00 122-60066-045-000 Publications/Books/Subscrips 401.00 401.00 401.00 122-60070-045-000 Dues & Memberships 8,560.00 8,560.00 250.00 5,426.34 63.392 3,133.66 122-60080-045-000 Schools & Training 6,946.00 6,946.00 83.47 83.47 1.202 6,862.53 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 6,788.00 6,788.00 1,620.88 23.879 5,167.12 122-60110-045-000 Physicals/Testing 1,918.00 1,918.00 1,918.00 122-60125-045-000 Advertising 156.00 156.00 156.00 122-60160-045-000 Programs & Special Projects 4,162.00 4,162.00 624.91 15.015 3,537.09 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 181.00 181.00 9.526 1,719.00 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 402.50 15.828 2,140.50 . glbase_tbam rgonzale Trophy Club Entities Page 3 10:40 12/16/11 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 26.25 26.25 2.122 1,210.75 Subtotal: 390,758.00 390,758.00 3,079.73 20,555.54 5.260 370,202.46 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 688.87 688.87 3.956 16,725.13 122-65010-045-000 Uniforms 4,357.00 4,357.00 37.50 396.50 9.100 3,960.50 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 28.50 28.50 .375 7,571.50 122-65030-045-000 Chemicals 1,545.00 1,545.00 1,545.00 122-65035-045-000 Small Tools 8,371.00 8,371.00 129.00 221.50 2.646 8,149.50 122-65085-045-000 Office Supplies 329.00 329.00 48.64 99.60 30.274 229.40 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 21.75 .781 2,763.25 122-65105-045-000 Printing 106.00 106.00 24.77 24.77 23.368 81.23 Subtotal: 42,507.00 42,507.00 957.28 1,481.49 3.485 41,025.51 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 13,709.00 13,709.00 21,529.55 10,764.78 32,294.33 235.570 18,585.33- 122-69050-045-000 Radios 2,500.00 2,500.00 2,500.00 122-69195-045-000 GASB34/Reserve for Replacement 41,890.00 41,890.00 41,890.00 122-69251-045-000 Engine 681 Payment 73,203.00 73,203.00 73,203.00 122-69255-045-000 Airpacks 13,865.00 13,865.00 13,865.00 Subtotal: 148,167.00 148,167.00 21,529.55 10,764.78 32,294.33 21.796 115,872.67 Program number: 1,311,934.00 1,311,934.00 21,529.55 85,642.60 182,543.80 13.914 1,129,390.20 Department number: 45 Fire 1,311,934.00 1,311,934.00 21,529.55 85,642.60 182,543.80 13.914 1,129,390.20 Expenditures Subtotal ----------- 1,311,934.00 1,311,934.00 21,529.55 85,642.60 182,543.80 13.914 1,129,390.20 Fund number: 122 Trophy Club MUD Fire Dept. 21,529.55 7,732.01 99,160.00 99,160.00- . glbase_tbam rgonzale Trophy Club Entities Page 4 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 97,495.00- 97,495.00- 5,595.43- 5,960.82- 6.114 91,534.18- 135-40002-000-000 Property Taxes/Delinquent 31.72- 124.99 124.99- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 162.09- 390.15 -29.247 1,724.15- Subtotal: 98,829.00- 98,829.00- 5,789.24- 5,445.68- 5.510 93,383.32- 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 121,730.50- 301,399.25- 15.140 1,689,400.75- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 84,805.36- 192,009.55- 14.491 1,132,990.45- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 51,584.88- 136,810.66- 16.583 688,189.34- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 20,506.82- 50,697.97- 14.083 309,302.03- 135-47020-000-000 Standby 775.00- 775.00- 72.00- 138.00- 17.806 637.00- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 8,603.88- 15,670.18- 31.030 34,829.82- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 1,212.38- 2,940.38- 16.802 14,559.62- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 150.00- 150.00- 12.500 1,050.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 450.00- 450.00- 10.000 4,050.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 8,212.62- 8,212.62- 14.283 49,287.38- 135-47270-000-000 Fire Line 5,000.00- 5,000.00- 5,000.00- 135-47400-000-000 Water-Out of Dist/Port Meters 41,595.00- 41,595.00- 6,526.73- 14,908.07- 35.841 26,686.93- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 781.43- 1,741.74- 14.752 10,065.26- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 4.68- 4.68- 1.560 295.32- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 33,094.82- 76,499.59- 18.000 348,500.41- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 17,248.04- 37,643.88- 20.348 147,356.12- Subtotal: 5,301,477.00- 5,301,477.00- 354,984.14- 839,276.57- 15.831 4,462,200.43- 135-48005-000-000 Utility Fees 338,880.00- 338,880.00- 41,400.00- 78,980.00- 23.306 259,900.00- Subtotal: 338,880.00- 338,880.00- 41,400.00- 78,980.00- 23.306 259,900.00- 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 394.10- 728.98- 16.200 3,771.02- 135-49016-000-000 Cell Tower Revenue 847.00- 1,694.00- 1,694.00 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,166.66- 16.667 5,833.34- 135-49030-000-000 Vending Revenue 600.00- 600.00- 600.00- 135-49035-000-000 Prior Year Reserves 241,981.00- 241,981.00- 241,981.00- 135-49036-000-000 GASB Reserves 26,911.00- 26,911.00- 26,911.00- 135-49075-000-000 Oversize Meter Reimbursement 64,000.00- 64,000.00- 6,424.00- 11,972.00- 18.706 52,028.00- 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 316.49- 333.49- 3.335 9,666.51- 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 48.62- 48.62- 6.078 751.38- Subtotal: 355,792.00- 355,792.00- 8,613.54- 15,943.75- 4.481 339,848.25- Program number: 6,094,978.00- 6,094,978.00- 410,786.92- 939,646.00- 15.417 5,155,332.00- Department number: Revenues 6,094,978.00- 6,094,978.00- 410,786.92- 939,646.00- 15.417 5,155,332.00- . glbase_tbam rgonzale Trophy Club Entities Page 5 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Revenues Subtotal ----------- 6,094,978.00- 6,094,978.00- 410,786.92- 939,646.00- 15.417 5,155,332.00- . glbase_tbam rgonzale Trophy Club Entities Page 6 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 199,759.00 199,759.00 12,581.46 25,162.92 12.597 174,596.08 135-50010-010-000 Overtime 13,250.00 13,250.00 790.25 1,975.22 14.907 11,274.78 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 300.00 16.667 1,500.00 135-50020-010-000 Retirement 25,508.00 25,508.00 2,285.67 4,256.24 16.686 21,251.76 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,883.94 3,767.88 16.667 18,839.12 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 134.28 268.56 12.382 1,900.44 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 63.52 11.028 512.48 135-50029-010-000 Life Insurance & Other 1,161.00 1,161.00 1,161.00 135-50030-010-000 Social Security Taxes 13,481.00 13,481.00 947.55 1,757.12 13.034 11,723.88 135-50035-010-000 Medicare Taxes 3,153.00 3,153.00 221.61 410.95 13.034 2,742.05 135-50040-010-000 Unemployment Taxes 945.00 945.00 945.00 135-50045-010-000 Workman's Compensation 5,581.00 5,581.00 5,581.00 100.000 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 27.59 27.59 7.883 322.41 Subtotal: 293,160.00 293,160.00 21,674.11 46,191.00 15.756 246,969.00 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-010-000 Independent Labor 500.00 500.00 500.00 135-55080-010-000 Maintenance & Repairs 29,500.00 29,500.00 363.10 913.10 3.095 28,586.90 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 1,684.48 1,797.37 53.177 1,582.63 135-55100-010-000 Building Maint & Supplies 750.00 750.00 365.50 48.733 384.50 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 2,900.00 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 180.00 360.00 8.000 4,140.00 Subtotal: 43,030.00 43,030.00 2,227.58 3,435.97 7.985 39,594.03 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 318.76 318.76 19.935 1,280.24 135-60020-010-000 Electricity 162,000.00 162,000.00 11,053.80 19,395.80 11.973 142,604.20 135-60035-010-000 Postage 500.00 500.00 6.51 6.51 1.302 493.49 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 391.00 13.964 2,409.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 76.05 154.87 4.840 3,045.13 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 7,965.75 7,965.75 120.693 1,365.75- 135-60150-010-000 Bulk Water 1,720,000.00 1,720,000.00 155,009.23 155,009.23 9.012 1,564,990.77 135-60245-010-000 Miscellaneous Expenses 1,000.00 1,000.00 1,000.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 4,200.00 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 7 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Subtotal: 1,910,799.00 1,910,799.00 174,541.10 183,241.92 9.590 1,727,557.08 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,345.37 1,345.37 8.842 13,870.63 135-65010-010-000 Uniforms 3,690.00 3,690.00 114.97 753.18 20.411 2,936.82 135-65030-010-000 Chemicals 6,200.00 6,200.00 6,200.00 135-65035-010-000 Small Tools 2,500.00 2,500.00 2,500.00 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 2,500.00 135-65050-010-000 Meter Expense 85,000.00 85,000.00 51,329.00 55,736.00 65.572 29,264.00 135-65055-010-000 Hardware 1,000.00 1,000.00 1,000.00 135-65095-010-000 Maintenance Supplies 32,000.00 32,000.00 4,822.21 5,320.88 16.628 26,679.12 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 58.50 39.000 91.50 Subtotal: 148,306.00 148,306.00 57,611.55 63,213.93 42.624 85,092.07 135-69005-010-000 Capital Expenses 888,432.00 888,432.00 392,150.00 392,747.19 44.207 495,684.81 135-69035-010-000 Vehicles 27,000.00 27,000.00 29,438.70 29,438.70 109.032 2,438.70- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 24,000.00 24,000.00 24,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 124,771.00 69,788.02 69,788.02 55.933 54,982.98 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 11,490.00 Subtotal: 1,105,943.00 1,105,943.00 29,438.70 461,938.02 491,973.91 44.485 613,969.09 Program number: 3,501,238.00 3,501,238.00 29,438.70 717,992.36 788,056.73 22.508 2,713,181.27 Department number: 10 Water 3,501,238.00 3,501,238.00 29,438.70 717,992.36 788,056.73 22.508 2,713,181.27 . glbase_tbam rgonzale Trophy Club Entities Page 8 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 182,147.00 182,147.00 9,477.02 40,190.99 22.065 141,956.01 135-50010-020-000 Overtime 10,166.00 10,166.00 1,641.24 2,357.50 23.190 7,808.50 135-50016-020-000 Longevity 3,976.00 3,976.00 2,587.50 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 325.00 13.542 2,075.00 135-50020-020-000 Retirement 27,816.00 27,816.00 1,958.43 6,633.74 23.849 21,182.26 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 1,734.68 4,221.62 13.704 26,583.38 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 136.94 322.90 16.300 1,658.10 135-50028-020-000 Vision Insurance 552.00 552.00 34.44 80.36 14.558 471.64 135-50029-020-000 Life Insurance & Other 884.00 884.00 884.00 135-50030-020-000 Social Security Taxes 8,597.00 8,597.00 766.07 2,675.85 31.125 5,921.15 135-50035-020-000 Medicare Taxes 2,011.00 2,011.00 179.14 625.78 31.118 1,385.22 135-50040-020-000 Unemployment Taxes 567.00 567.00 567.00 135-50045-020-000 Workman's Compensation 2,685.00 2,685.00 2,685.00 100.000 135-50060-020-000 Pre-emp Physicals/Testing 30.45 30.45 30.45- 135-50070-020-000 Employee Relations 350.00 350.00 350.00 Subtotal: 274,937.00 274,937.00 18,670.91 64,124.19 23.323 210,812.81 135-55070-020-000 Independent Labor 750.00 750.00 750.00 135-55080-020-000 Maintenance & Repairs 17,750.00 17,750.00 737.76 3,858.70 21.739 13,891.30 135-55090-020-000 Vehicle Maintenance 4,998.00 4,998.00 4,998.00 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 1,400.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 2,950.00 135-55125-020-000 Dumpster Services 35,000.00 35,000.00 3,225.00 4,837.50 13.821 30,162.50 135-55135-020-000 Lab Analysis 22,760.00 22,760.00 1,168.75 2,243.32 9.856 20,516.68 Subtotal: 85,608.00 85,608.00 5,131.51 10,939.52 12.779 74,668.48 135-60005-020-000 Telephone 6.20 6.20- 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 375.36 375.36 12.512 2,624.64 135-60020-020-000 Electricity 205,000.00 205,000.00 15,733.60 23,307.74 11.370 181,692.26 135-60025-020-000 Water 1,900.00 1,900.00 160.31 257.91 13.574 1,642.09 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 438.17 87.634 61.83 135-60080-020-000 Schools & Training 1,320.00 1,320.00 1,320.00 135-60090-020-000 Safety Program 200.00 200.00 200.00 135-60100-020-000 Travel & per diem 1,750.00 1,750.00 233.10 349.65 19.980 1,400.35 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 901.30 450.650 701.30- 135-60125-020-000 Advertising 987.36 987.36 987.36- 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: 222,540.00 222,540.00 18,391.03 34,056.19 15.303 188,483.81 . glbase_tbam rgonzale Trophy Club Entities Page 9 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-020-000 Fuel & Lube 6,875.00 6,875.00 444.50 444.50 6.465 6,430.50 135-65010-020-000 Uniforms 3,140.00 3,140.00 645.96 645.96 20.572 2,494.04 135-65030-020-000 Chemicals 13,180.00 13,180.00 149.11 1,499.11 11.374 11,680.89 135-65035-020-000 Small Tools 1,260.00 1,260.00 1,260.00 135-65040-020-000 Safety Equipment 925.00 925.00 925.00 135-65045-020-000 Lab Supplies 19,160.00 19,160.00 277.01 277.01 1.446 18,882.99 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 23.14 23.14 5.785 376.86 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 190.52 345.66 3.901 8,514.34 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 54,435.00 1,730.24 3,235.38 5.944 51,199.62 135-69005-020-000 Capital Expenses 161,189.00 161,189.00 34,800.26 34,800.26 21.590 126,388.74 135-69035-020-000 Vehicles 18,279.55 18,279.55 18,279.55- 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 217,189.00 18,279.55 34,800.26 53,079.81 24.439 164,109.19 Program number: 854,709.00 854,709.00 18,279.55 78,723.95 165,435.09 19.356 689,273.91 Department number: 20 Wastewater 854,709.00 854,709.00 18,279.55 78,723.95 165,435.09 19.356 689,273.91 . glbase_tbam rgonzale Trophy Club Entities Page 10 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 145,481.00 145,481.00 11,082.16 22,164.32 15.235 123,316.68 135-50010-021-000 Overtime 7,297.00 7,297.00 730.15 1,381.87 18.938 5,915.13 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 125.00 250.00 16.667 1,250.00 135-50020-021-000 Retirement 21,074.00 21,074.00 2,192.65 3,871.87 18.373 17,202.13 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 3,405.36 14.817 19,577.64 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 234.76 15.314 1,298.24 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 59.44 16.650 297.56 135-50029-021-000 Life Insurance & Other 978.00 978.00 978.00 135-50030-021-000 Social Security Taxes 9,785.00 9,785.00 901.09 1,577.36 16.120 8,207.64 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 210.74 368.90 16.123 1,919.10 135-50040-021-000 Unemployment Taxes 567.00 567.00 567.00 135-50045-021-000 Workman's Compensation 3,056.00 3,056.00 3,056.00 100.000 135-50070-021-000 Employee Relations 250.00 250.00 250.00 Subtotal: 220,697.00 220,697.00 20,639.07 39,917.38 18.087 180,779.62 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 23,700.00 23,700.00 2,241.78 2,400.23 10.128 21,299.77 135-55090-021-000 Vehicle Maintenance 1,943.00 1,943.00 130.00 6.691 1,813.00 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 28,093.00 28,093.00 2,241.78 2,530.23 9.007 25,562.77 135-60005-021-000 Telephone 3.23 3.23- 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 406.18 406.18 14.527 2,389.82 135-60020-021-000 Electricity 23,625.00 23,625.00 1,281.91 1,927.39 8.158 21,697.61 135-60025-021-000 Water 750.00 750.00 750.00 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 255.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 2,818.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 80.48 177.06 11.804 1,322.94 135-60105-021-000 Rent/Lease Equipment 44,107.00 44,107.00 44,107.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: 77,851.00 77,851.00 1,768.57 2,513.86 3.229 75,337.14 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 1,454.09 1,454.09 12.428 10,245.91 135-65010-021-000 Uniforms 2,505.00 2,505.00 350.00 350.00 13.972 2,155.00 135-65030-021-000 Chemicals 12,500.00 12,500.00 12,500.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 . glbase_tbam rgonzale Trophy Club Entities Page 11 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 1,150.00 135-65055-021-000 Hardware 750.00 750.00 44.95 44.95 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 15.12 15.12 .094 16,034.88 Subtotal: 46,155.00 46,155.00 1,864.16 1,864.16 4.039 44,290.84 135-69005-021-000 Capital Expenses 15,000.00 15,000.00 31,991.00 31,991.00 213.273 16,991.00- 135-69280-021-000 Capital Repairs 20,000.00 20,000.00 20,000.00 Subtotal: 35,000.00 35,000.00 31,991.00 31,991.00 91.403 3,009.00 Program number: 407,796.00 407,796.00 58,504.58 78,816.63 19.327 328,979.37 Department number: 21 Collection 407,796.00 407,796.00 58,504.58 78,816.63 19.327 328,979.37 . glbase_tbam rgonzale Trophy Club Entities Page 12 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 500.00 1,300.00 13.000 8,700.00 135-50030-026-000 Social Security Taxes 620.00 620.00 31.00 80.60 13.000 539.40 135-50035-026-000 Medicare Taxes 145.00 145.00 7.25 18.85 13.000 126.15 135-50040-026-000 Unemployment Taxes 210.00 210.00 4.00 10.40 4.952 199.60 135-50045-026-000 Workman's Compensation 120.00 120.00 120.00 100.000 Subtotal: 11,095.00 11,095.00 542.25 1,529.85 13.789 9,565.15 135-60066-026-000 Publications/Books/Subscripts 50.00 50.00 50.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 585.00 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 66.00 110.00 8.607 1,168.00 135-60080-026-000 Schools & Training 4,150.00 4,150.00 530.00 610.00 14.699 3,540.00 135-60100-026-000 Travel & per diem 6,199.00 6,199.00 6,199.00 135-60245-026-000 Miscellaneous Expenses 3,200.00 3,200.00 3,200.00 Subtotal: 16,977.00 16,977.00 1,181.00 1,405.00 8.276 15,572.00 135-65085-026-000 Office Supplies 50.00 50.00 50.00 Subtotal: 50.00 50.00 50.00 Program number: 28,122.00 28,122.00 1,723.25 2,934.85 10.436 25,187.15 Department number: 26 Board of Directors 28,122.00 28,122.00 1,723.25 2,934.85 10.436 25,187.15 . glbase_tbam rgonzale Trophy Club Entities Page 13 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 236,831.00 236,831.00 13,026.05 26,679.93 11.265 210,151.07 135-50010-027-000 Overtime 1,000.00 1,000.00 419.72 621.08 62.108 378.92 135-50016-027-000 Longevity 1,845.00 1,845.00 1,845.00 1,845.00 100.000 135-50020-027-000 Retirement 33,471.00 33,471.00 2,165.17 4,127.09 12.330 29,343.91 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,145.37 2,414.49 12.844 16,383.51 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 86.90 181.52 14.615 1,060.48 135-50028-027-000 Vision Insurance 341.00 341.00 21.72 45.70 13.402 295.30 135-50029-027-000 Life Insurance & Other 1,337.00 1,337.00 1,337.00 135-50030-027-000 Social Security Taxes 14,860.00 14,860.00 910.82 1,727.91 11.628 13,132.09 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 213.05 404.15 11.630 3,070.85 135-50040-027-000 Unemployment Taxes 756.00 756.00 .03 9.97 1.319 746.03 135-50045-027-000 Workman's Compensation 580.00 580.00 580.00 100.000 135-50070-027-000 Employee Relations 5,000.00 5,000.00 54.76 111.33 2.227 4,888.67 Subtotal: 319,536.00 319,536.00 19,888.59 38,748.17 12.126 280,787.83 135-55070-027-000 Independent Labor 840.00 840.00 41.25 75.00 8.929 765.00 135-55075-027-000 Records Management 500.00 500.00 500.00 135-55160-027-000 Professional Outside Services 176,870.00 176,870.00 176,870.00 Subtotal: 178,210.00 178,210.00 41.25 75.00 .042 178,135.00 135-60005-027-000 Telephone 300.00 300.00 40.37 13.457 259.63 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 278.66 278.66 11.515 2,141.34 135-60035-027-000 Postage 17.47 255.39 255.39- 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 88.50 88.50 19.667 361.50 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 474.00 724.00 41.561 1,018.00 135-60075-027-000 Meetings 312.00 312.00 312.00 135-60080-027-000 Schools & Training 2,555.00 2,555.00 130.00 5.088 2,425.00 135-60100-027-000 Travel & per diem 3,851.00 3,851.00 61.05 97.90 2.542 3,753.10 135-60115-027-000 Elections 2,500.00 2,500.00 2,500.00 135-60125-027-000 Advertising 4,700.00 4,700.00 4,700.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 2,225.00 2,225.00 2,225.00 Subtotal: 31,155.00 31,155.00 919.68 1,614.82 5.183 29,540.18 135-65085-027-000 Office Supplies 2,450.00 2,450.00 71.57 189.23 7.724 2,260.77 135-65105-027-000 Printing 515.00 515.00 515.00 Subtotal: 2,965.00 2,965.00 71.57 189.23 6.382 2,775.77 Program number: 531,866.00 531,866.00 20,921.09 40,627.22 7.639 491,238.78 . glbase_tbam rgonzale Trophy Club Entities Page 14 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: 27 Manager's Office 531,866.00 531,866.00 20,921.09 40,627.22 7.639 491,238.78 . glbase_tbam rgonzale Trophy Club Entities Page 15 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50070-028-000 Employee Relations 1,967.00 1,967.00 293.83 343.94 17.486 1,623.06 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 1,561.00 Subtotal: 3,528.00 3,528.00 293.83 343.94 9.749 3,184.06 135-60005-028-000 Telephone 28.00 28.00 28.00 135-60035-028-000 Postage 106.00 106.00 106.00 135-60066-028-000 Publications/Books/Subscripts 485.00 485.00 485.00 135-60070-028-000 Dues & Memberships 555.00 555.00 555.00 135-60075-028-000 Meetings 138.00 138.00 138.00 135-60080-028-000 Schools & Training 594.00 594.00 594.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 1,560.00 1,560.00 1,560.00 Subtotal: 3,474.00 3,474.00 3,474.00 135-65085-028-000 Office Supplies 437.00 437.00 437.00 135-65105-028-000 Printing 116.00 116.00 116.00 Subtotal: 553.00 553.00 553.00 Program number: 7,555.00 7,555.00 293.83 343.94 4.552 7,211.06 Department number: 28 Human Resources 7,555.00 7,555.00 293.83 343.94 4.552 7,211.06 . glbase_tbam rgonzale Trophy Club Entities Page 16 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 94,404.00 94,404.00 7,492.63 14,992.63 15.881 79,411.37 135-50010-029-000 Overtime 1,000.00 1,000.00 408.58 596.36 59.636 403.64 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 1,376.88 2,465.46 18.112 11,146.54 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 921.69 1,843.04 16.664 9,216.96 135-50027-029-000 Dental Insurance 773.00 773.00 73.54 147.03 19.021 625.97 135-50028-029-000 Vision Insurance 207.00 207.00 12.51 25.00 12.077 182.00 135-50029-029-000 Life Insurance & Other 567.00 567.00 567.00 135-50030-029-000 Social Security Taxes 5,386.00 5,386.00 534.63 943.06 17.509 4,442.94 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 125.03 220.55 17.504 1,039.45 135-50040-029-000 Unemployment Taxes 284.00 284.00 284.00 135-50045-029-000 Workman's Compensation 235.00 235.00 211.00 89.787 24.00 Subtotal: 130,611.00 130,611.00 12,767.99 23,266.63 17.814 107,344.37 135-55160-029-000 Professional Outside Services 5,000.00 5,000.00 5,000.00 Subtotal: 5,000.00 5,000.00 5,000.00 135-60005-029-000 Telephone 103.00 103.00 11.44 11.107 91.56 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 98.41 98.41 14.408 584.59 135-60035-029-000 Postage 700.00 700.00 26.40 59.84 8.549 640.16 135-60040-029-000 Service Charges & Fees 79.00 79.00 79.00 135-60066-029-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-029-000 Dues & Memberships 660.00 660.00 660.00 135-60075-029-000 Meetings 300.00 300.00 22.00 7.333 278.00 135-60080-029-000 Schools & Training 2,000.00 2,000.00 2,000.00 135-60100-029-000 Travel & per diem 1,500.00 1,500.00 15.04 1.003 1,484.96 135-60125-029-000 Advertising 1,210.00 1,210.00 1,210.00 135-60245-029-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 7,935.00 7,935.00 124.81 206.73 2.605 7,728.27 135-65085-029-000 Office Supplies 849.00 849.00 11.80 11.80 1.390 837.20 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 11.80 11.80 .865 1,352.20 Program number: 144,910.00 144,910.00 12,904.60 23,485.16 16.207 121,424.84 Department number: 29 Finance 144,910.00 144,910.00 12,904.60 23,485.16 16.207 121,424.84 . glbase_tbam rgonzale Trophy Club Entities Page 17 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55030-033-000 Software & Support 64,149.00 64,149.00 7,065.92 8,813.68 13.739 55,335.32 135-55070-033-000 Independent Labor 1,650.00 1,650.00 218.75 13.258 1,431.25 Subtotal: 65,799.00 65,799.00 7,065.92 9,032.43 13.727 56,766.57 135-60005-033-000 Telephone 6,540.00 6,540.00 820.62 1,638.87 25.059 4,901.13 135-60235-033-000 Security 1,350.00 1,350.00 1,350.00 Subtotal: 7,890.00 7,890.00 820.62 1,638.87 20.771 6,251.13 135-65055-033-000 Hardware 83,238.00 83,238.00 3,745.72 5,885.08 7.070 77,352.92 135-65085-033-000 Office Supplies 371.00 371.00 107.12 107.12 28.873 263.88 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,036.50 1,626.38 28.374 4,105.62 Subtotal: 89,341.00 89,341.00 4,889.34 7,618.58 8.528 81,722.42 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 256.85 7.445 3,193.15 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 256.85 .846 30,104.15 Program number: 193,391.00 193,391.00 13,032.73 18,546.73 9.590 174,844.27 Department number: 33 Information Systems 193,391.00 193,391.00 13,032.73 18,546.73 9.590 174,844.27 . glbase_tbam rgonzale Trophy Club Entities Page 18 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-037-000 Salaries & Wages 31,512.00 31,512.00 31,512.00 135-50020-037-000 Retirement 4,412.00 4,412.00 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 9,027.00 9,027.00 135-50027-037-000 Dental Insurance 549.00 549.00 549.00 135-50028-037-000 Vision Insurance 138.00 138.00 138.00 135-50029-037-000 Life Insurance & Other 228.00 228.00 228.00 135-50030-037-000 Social Security Taxes 1,954.00 1,954.00 1,954.00 135-50035-037-000 Medicare Taxes 457.00 457.00 457.00 135-50040-037-000 Unemployment Taxes 189.00 189.00 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00 100.000 135-50060-037-000 Pre-emp Physicals/Testing 250.00 250.00 250.00 Subtotal: 49,577.00 49,577.00 861.00 1.737 48,716.00 135-55100-037-000 Building Maint & Supplies 5,000.00 5,000.00 155.88 187.86 3.757 4,812.14 135-55120-037-000 Cleaning Services 1,549.89 2,228.07 2,228.07- Subtotal: 5,000.00 5,000.00 1,705.77 2,415.93 48.319 2,584.07 135-60020-037-000 Electricity 21,940.00 21,940.00 976.26 1,403.71 6.398 20,536.29 135-60025-037-000 Water 1,093.00 1,093.00 42.96 120.85 11.057 972.15 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 2,197.02 16.667 10,984.98 135-60055-037-000 Insurance 32,635.00 32,635.00 28,589.50 87.604 4,045.50 135-60360-037-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,500.00 Subtotal: 71,350.00 71,350.00 2,117.73 32,311.08 45.285 39,038.92 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 23.51 191.73 8.695 2,013.27 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 19.69 1.969 980.31 Subtotal: 3,205.00 3,205.00 23.51 211.42 6.597 2,993.58 Program number: 129,132.00 129,132.00 3,847.01 35,799.43 27.723 93,332.57 Department number: 37 Facilities Maintenance 129,132.00 129,132.00 3,847.01 35,799.43 27.723 93,332.57 . glbase_tbam rgonzale Trophy Club Entities Page 19 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 84,946.00 84,946.00 6,568.50 13,144.26 15.474 71,801.74 135-50010-038-000 Overtime 2,000.00 2,000.00 30.28 55.23 2.762 1,944.77 135-50016-038-000 Longevity 220.00 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 965.53 1,900.18 15.571 10,302.82 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.36 1,848.72 15.005 10,472.28 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.66 183.32 17.867 842.68 135-50028-038-000 Vision Insurance 260.00 260.00 21.62 43.25 16.635 216.75 135-50029-038-000 Life Insurance & Other 604.00 604.00 604.00 135-50030-038-000 Social Security Taxes 5,404.00 5,404.00 386.98 760.46 14.072 4,643.54 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 90.50 177.84 14.070 1,086.16 135-50040-038-000 Unemployment Taxes 473.00 473.00 .04 10.02 2.118 462.98 135-50045-038-000 Workman's Compensation 211.00 211.00 235.00 111.374 24.00- Subtotal: 120,932.00 120,932.00 9,299.47 18,578.28 15.363 102,353.72 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 917.72 8.343 10,082.28 Subtotal: 11,800.00 11,800.00 917.72 7.777 10,882.28 135-60005-038-000 Telephone 100.00 100.00 20.91 20.910 79.09 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 68.47 68.47 14.506 403.53 135-60035-038-000 Postage 18,000.00 18,000.00 1,403.12 7.795 16,596.88 135-60040-038-000 Service Charges & Fees 18,000.00 18,000.00 3,293.51 6,460.01 35.889 11,539.99 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%) 22,500.00 22,500.00 22,500.00 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 60,748.00 60,748.00 3,361.98 7,952.51 13.091 52,795.49 135-65085-038-000 Office Supplies 700.00 700.00 13.80 53.74 7.677 646.26 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 13.80 53.74 1.361 3,896.26 Program number: 197,430.00 197,430.00 12,675.25 27,502.25 13.930 169,927.75 Department number: 38 Utility Billing 197,430.00 197,430.00 12,675.25 27,502.25 13.930 169,927.75 . glbase_tbam rgonzale Trophy Club Entities Page 20 10:40 12/16/11 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 55,000.00 55,000.00 6,590.00 6,590.00 11.982 48,410.00 135-55055-039-000 Auditing 20,200.00 20,200.00 5,050.00 25.000 15,150.00 135-55060-039-000 Appraisal 20,000.00 20,000.00 5,472.82 8,533.65 42.668 11,466.35 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,451.63 2,451.63 67.557 1,177.37 Subtotal: 98,829.00 98,829.00 14,514.45 22,625.28 22.893 76,203.72 Program number: 98,829.00 98,829.00 14,514.45 22,625.28 22.893 76,203.72 Department number: 39 Non Departmental 98,829.00 98,829.00 14,514.45 22,625.28 22.893 76,203.72 Expenditures Subtotal ----------- 6,094,978.00 6,094,978.00 47,718.25 935,133.10 1,204,173.31 19.757 4,890,804.69 Fund number: 135 MUD 1 General Fund 47,718.25 524,346.18 264,527.31 264,527.31- . glbase_tbam rgonzale Trophy Club Entities Page 21 10:40 12/16/11 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: Revenues Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-49025-000-000 Auction Sales 22,570.00- 22,570.00 Subtotal: 22,570.00- 22,570.00 Program number: 22,570.00- 22,570.00 Department number: Revenues 22,570.00- 22,570.00 Revenues Subtotal ----------- 22,570.00- 22,570.00 . glbase_tbam rgonzale Trophy Club Entities Page 22 10:40 12/16/11 Budget Summary with Amendment Fund: 522 2010 GO/Fire Station Department: 65 Construction Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 522-60031-065-000 Temporary Housing & Storage 41.58 41.58- Subtotal: 41.58 41.58- Program number: 41.58 41.58- Department number: 65 Construction 41.58 41.58- Expenditures Subtotal ----------- 41.58 41.58- Fund number: 522 2010 GO/Fire Station 22,528.42- 22,528.42 . glbase_tbam rgonzale Trophy Club Entities Page 23 10:40 12/16/11 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 11/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 550,663.00- 550,663.00- 31,603.67- 33,667.41- 6.114 516,995.59- 533-40002-000-000 Property Taxes/Delinquent 277.70- 1,499.81 1,499.81- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 38.11- 223.21- 4.449 4,793.79- Subtotal: 555,680.00- 555,680.00- 31,919.48- 32,390.81- 5.829 523,289.19- 533-48005-000-000 Utility Fees 6,120.00- 6,120.00- 6,120.00- 100.000 Subtotal: 6,120.00- 6,120.00- 6,120.00- 100.000 533-49010-000-000 Interest Income 500.00- 500.00- 10.70- 18.39- 3.678 481.61- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 308,500.00- 308,500.00- 10.70- 18.39- .006 308,481.61- Program number: 870,300.00- 870,300.00- 31,930.18- 38,529.20- 4.427 831,770.80- Department number: Revenues 870,300.00- 870,300.00- 31,930.18- 38,529.20- 4.427 831,770.80- Revenues Subtotal ----------- 870,300.00- 870,300.00- 31,930.18- 38,529.20- 4.427 831,770.80- . glbase_tbam rgonzale Trophy Club Entities Page 24 10:40 12/16/11 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 11/2011 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 301,300.00 301,300.00 301,300.00 533-70035-051-000 Bond Principal Payment 565,000.00 565,000.00 565,000.00 Subtotal: 870,300.00 870,300.00 870,300.00 Program number: 870,300.00 870,300.00 870,300.00 Department number: 51 Administration 870,300.00 870,300.00 870,300.00 Expenditures Subtotal ----------- 870,300.00 870,300.00 870,300.00 Fund number: 533 MUD 1 I&S CONSOLIDATED 31,930.18- 38,529.20- 38,529.20 ******* End of Report *********