Loading...
HomeMy WebLinkAboutDec 2011 Financial Summary . glbase_tbam rgonzale Trophy Club Entities Page 1 10:06 01/27/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 12/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- 79,791.09- 96,096.32- 49.731 97,136.68- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 8.00- 7.75- 96.875 .25- 122-40010-000-000 Property Taxes/MUD Fire 1,076,976.00- 1,076,976.00- 336,981.84- 402,828.01- 37.404 674,147.99- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,603.00- 3,595.71 5,772.76 -103.030 11,375.76- 122-40015-000-000 Property Taxes/Assessments P&I 6.00- 5.42- 90.333 .58- 122-40020-000-000 Property Taxes/Fire P&I 7,500.00- 7,500.00- 12.03- 308.31- 4.111 7,191.69- Subtotal: 1,277,709.00- 1,283,326.00- 413,189.25- 493,473.05- 38.453 789,852.95- 122-42014-000-000 Fire Permits/Sprinkler 2,000.00- 1,200.00- 2,400.00- 120.000 400.00 Subtotal: 2,000.00- 1,200.00- 2,400.00- 120.000 400.00 122-43400-000-000 Fire Inspections 500.00- 225.00- 450.00- 90.000 50.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,624.00- 225.00- 450.00- 3.871 11,174.00- 122-49035-000-000 Prior Year Reserves 23,101.00- 9,984.00- 9,984.00- 122-49900-000-000 Miscellaneous Income 5,000.00- 1,775.00- 3,450.00- 69.000 1,550.00- Subtotal: 23,101.00- 14,984.00- 1,775.00- 3,450.00- 23.025 11,534.00- Program number: 1,311,934.00- 1,311,934.00- 416,389.25- 499,773.05- 38.094 812,160.95- Department number: Fire Revenues 1,311,934.00- 1,311,934.00- 416,389.25- 499,773.05- 38.094 812,160.95- Revenues Subtotal ----------- 1,311,934.00- 1,311,934.00- 416,389.25- 499,773.05- 38.094 812,160.95- . glbase_tbam rgonzale Trophy Club Entities Page 2 10:06 01/27/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 32,886.68 96,866.56 22.752 328,881.44 122-50010-045-000 Overtime 42,000.00 42,000.00 3,314.69 12,292.97 29.269 29,707.03 122-50011-045-000 DPS Holiday Pay 12,133.00 12,133.00 13,773.02 113.517 1,640.02- 122-50016-045-000 Longevity 3,647.00 3,647.00 3,714.46 101.850 67.46- 122-50017-045-000 Certification 4,073.00 4,073.00 579.70 1,569.10 38.524 2,503.90 122-50020-045-000 Retirement 68,264.00 68,264.00 4,939.45 17,623.98 25.817 50,640.02 122-50026-045-000 Medical Insurance 53,184.00 53,184.00 3,339.61 10,019.26 18.839 43,164.74 122-50027-045-000 Dental Insurance 3,288.00 3,288.00 291.85 875.63 26.631 2,412.37 122-50028-045-000 Vision Insurance 857.00 857.00 65.94 197.79 23.079 659.21 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 2,088.97 7,385.54 24.430 22,845.46 122-50035-045-000 Medicare Taxes 7,070.00 7,070.00 488.58 1,727.30 24.431 5,342.70 122-50040-045-000 Unemployment Taxes 1,476.00 1,476.00 13.19 46.29 3.136 1,429.71 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 17.45 52.45 7.770 622.55 Subtotal: 664,179.00 664,179.00 48,026.11 174,453.85 26.266 489,725.15 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 79.21 .828 9,482.79 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 24.95 24.95 .168 14,825.05 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 129.00 129.00 1.315 9,679.00 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 421.48 2,126.97 19.336 8,873.03 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 575.43 2,360.13 3.559 63,962.87 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 191.78 632.06 14.329 3,778.94 122-60020-045-000 Electricity/Gas 18,270.00 18,270.00 1,208.10 2,752.79 15.067 15,517.21 122-60025-045-000 Water 3,289.00 3,289.00 161.03 1,266.57 38.509 2,022.43 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 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 495.00 5,921.34 69.175 2,638.66 122-60080-045-000 Schools & Training 6,946.00 6,946.00 83.47 1.202 6,862.53 122-60096-045-000 Emergency Management 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 180.00 361.00 19.000 1,539.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:06 01/27/12 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 12/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 380.32 406.57 32.867 830.43 Subtotal: 390,758.00 390,758.00 2,616.23 23,171.77 5.930 367,586.23 122-65005-045-000 Fuel & Lube 17,414.00 17,414.00 688.87 3.956 16,725.13 122-65010-045-000 Uniforms 4,357.00 4,357.00 10.00 406.50 9.330 3,950.50 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 55.00 83.50 1.099 7,516.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 233.21 454.71 5.432 7,916.29 122-65085-045-000 Office Supplies 329.00 329.00 399.91 499.51 151.827 170.51- 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 352.24 373.99 13.429 2,411.01 122-65105-045-000 Printing 106.00 106.00 24.77 23.368 81.23 Subtotal: 42,507.00 42,507.00 1,050.36 2,531.85 5.956 39,975.15 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 250.00 11,014.78 80.347 2,694.22 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 250.00 11,014.78 7.434 137,152.22 Program number: 1,311,934.00 1,311,934.00 52,518.13 213,532.38 16.276 1,098,401.62 Department number: Fire 1,311,934.00 1,311,934.00 52,518.13 213,532.38 16.276 1,098,401.62 Expenditures Subtotal ----------- 1,311,934.00 1,311,934.00 52,518.13 213,532.38 16.276 1,098,401.62 Fund number: 122 Trophy Club MUD Fire Dept. 363,871.12- 286,240.67- 286,240.67 . glbase_tbam rgonzale Trophy Club Entities Page 4 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/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- 30,505.72- 36,466.54- 37.403 61,028.46- 135-40002-000-000 Property Taxes/Delinquent 451.00- 601.29 726.28 -161.038 1,177.28- 135-40015-000-000 Property Taxes/P & I 1,334.00- 1,334.00- 55.64- 334.51 -25.076 1,668.51- Subtotal: 98,829.00- 99,280.00- 29,960.07- 35,405.75- 35.663 63,874.25- 135-47000-000-000 Water 1,990,800.00- 1,990,800.00- 104,128.85- 405,528.10- 20.370 1,585,271.90- 135-47005-000-000 Sewer 1,325,000.00- 1,325,000.00- 79,020.71- 271,030.26- 20.455 1,053,969.74- 135-47010-000-000 Commercial Water 825,000.00- 825,000.00- 38,788.48- 175,599.14- 21.285 649,400.86- 135-47015-000-000 Commercial Sewer 360,000.00- 360,000.00- 20,505.40- 71,203.37- 19.779 288,796.63- 135-47020-000-000 Standby 775.00- 775.00- 67.00- 205.00- 26.452 570.00- 135-47025-000-000 Penalties 50,500.00- 50,500.00- 4,378.75- 20,048.93- 39.701 30,451.07- 135-47030-000-000 Service Charges 17,500.00- 17,500.00- 1,236.28- 4,176.66- 23.867 13,323.34- 135-47035-000-000 Plumbing Inspections 1,200.00- 1,200.00- 350.00- 500.00- 41.667 700.00- 135-47045-000-000 Sewer Inspections 4,500.00- 4,500.00- 1,050.00- 1,500.00- 33.333 3,000.00- 135-47070-000-000 TCCC Effluent Charges 57,500.00- 57,500.00- 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- 94.81- 15,002.88- 36.069 26,592.12- 135-47405-000-000 Out of District Sewer 11,807.00- 11,807.00- 987.83- 2,729.57- 23.118 9,077.43- 135-47410-000-000 Out of Dist/Portable Penalties 300.00- 300.00- 23.63- 28.31- 9.437 271.69- 135-47600-000-000 PID #1 Water 425,000.00- 425,000.00- 27,618.37- 104,117.96- 24.498 320,882.04- 135-47605-000-000 PID #1 Sewer 185,000.00- 185,000.00- 16,236.98- 53,880.86- 29.125 131,119.14- Subtotal: 5,301,477.00- 5,301,477.00- 294,487.09- 1,133,763.66- 21.386 4,167,713.34- 135-48005-000-000 Utility Fees 338,880.00- 338,880.00- 105,800.00- 184,780.00- 54.527 154,100.00- Subtotal: 338,880.00- 338,880.00- 105,800.00- 184,780.00- 54.527 154,100.00- 135-49010-000-000 Interest Income 4,500.00- 4,500.00- 309.34- 1,038.32- 23.074 3,461.68- 135-49016-000-000 Cell Tower Revenue 10,164.00- 847.00- 2,541.00- 25.000 7,623.00- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 583.33- 1,749.99- 25.000 5,250.01- 135-49030-000-000 Vending Revenue 600.00- 600.00- 32.50- 32.50- 5.417 567.50- 135-49035-000-000 Prior Year Reserves 241,981.00- 265,707.00- 265,707.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- 15,382.00- 27,354.00- 42.741 36,646.00- 135-49900-000-000 Miscellaneous Income 10,000.00- 10,000.00- 333.49- 3.335 9,666.51- 135-49905-000-000 Gas Well Revenue 800.00- 800.00- 48.62- 6.078 751.38- Subtotal: 355,792.00- 389,682.00- 17,154.17- 33,097.92- 8.494 356,584.08- Program number: 6,094,978.00- 6,129,319.00- 447,401.33- 1,387,047.33- 22.630 4,742,271.67- Department number: Revenues 6,094,978.00- 6,129,319.00- 447,401.33- 1,387,047.33- 22.630 4,742,271.67- . glbase_tbam rgonzale Trophy Club Entities Page 5 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 12/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Revenues Subtotal ----------- 6,094,978.00- 6,129,319.00- 447,401.33- 1,387,047.33- 22.630 4,742,271.67- . glbase_tbam rgonzale Trophy Club Entities Page 6 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 37,744.38 18.895 162,014.62 135-50010-010-000 Overtime 13,250.00 13,250.00 1,313.27 3,288.49 24.819 9,961.51 135-50016-010-000 Longevity 2,620.00 2,620.00 2,620.00 100.000 135-50017-010-000 Certification 1,800.00 1,800.00 150.00 450.00 25.000 1,350.00 135-50020-010-000 Retirement 25,508.00 25,508.00 1,988.74 6,244.98 24.482 19,263.02 135-50026-010-000 Medical Insurance 22,607.00 22,607.00 1,883.94 5,651.82 25.000 16,955.18 135-50027-010-000 Dental Insurance 2,169.00 2,169.00 134.28 402.84 18.573 1,766.16 135-50028-010-000 Vision Insurance 576.00 576.00 31.76 95.28 16.542 480.72 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 817.51 2,574.63 19.098 10,906.37 135-50035-010-000 Medicare Taxes 3,153.00 3,153.00 191.18 602.13 19.097 2,550.87 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 20.00 47.59 13.597 302.41 Subtotal: 293,160.00 293,160.00 19,112.14 65,303.14 22.276 227,856.86 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 6,869.31 7,782.41 26.381 21,717.59 135-55090-010-000 Vehicle Maintenance 3,380.00 3,380.00 92.40 1,889.77 55.910 1,490.23 135-55100-010-000 Building Maint & Supplies 750.00 750.00 106.35 471.85 62.913 278.15 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 540.00 12.000 3,960.00 Subtotal: 43,030.00 43,030.00 7,248.06 10,684.03 24.829 32,345.97 135-60010-010-000 Communications/Pagers/Mobiles 1,599.00 1,599.00 162.22 480.98 30.080 1,118.02 135-60020-010-000 Electricity 162,000.00 162,000.00 842.68 20,238.48 12.493 141,761.52 135-60035-010-000 Postage 500.00 500.00 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 55.00 446.00 15.929 2,354.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 210.35 365.22 11.413 2,834.78 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 120.693 1,365.75- 135-60150-010-000 Bulk Water 1,720,000.00 1,720,000.00 124,925.14 279,934.37 16.275 1,440,065.63 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 299.99 299.99 19.999 1,200.01 . glbase_tbam rgonzale Trophy Club Entities Page 7 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 12/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 126,495.38 309,737.30 16.210 1,601,061.70 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 1,885.23 3,230.60 21.232 11,985.40 135-65010-010-000 Uniforms 3,690.00 3,690.00 753.18 20.411 2,936.82 135-65030-010-000 Chemicals 6,200.00 6,200.00 1,066.47 1,066.47 17.201 5,133.53 135-65035-010-000 Small Tools 2,500.00 2,500.00 68.00 68.00 2.720 2,432.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 367.00 56,103.00 66.004 28,897.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 1,490.66 6,811.54 21.286 25,188.46 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 4,877.36 68,091.29 45.913 80,214.71 135-69005-010-000 Capital Expenses 888,432.00 888,432.00 102,000.00 494,747.19 55.688 393,684.81 135-69035-010-000 Vehicles 27,000.00 27,000.00 27,000.00 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 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 102,000.00 564,535.21 51.046 541,407.79 Program number: 3,501,238.00 3,501,238.00 259,732.94 1,018,350.97 29.085 2,482,887.03 Department number: Water 3,501,238.00 3,501,238.00 259,732.94 1,018,350.97 29.085 2,482,887.03 . glbase_tbam rgonzale Trophy Club Entities Page 8 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 12,957.02 53,148.01 29.179 128,998.99 135-50010-020-000 Overtime 10,166.00 10,166.00 976.44 3,333.94 32.795 6,832.06 135-50016-020-000 Longevity 3,976.00 3,976.00 3,975.00 99.975 1.00 135-50017-020-000 Certification 2,400.00 2,400.00 125.00 450.00 18.750 1,950.00 135-50020-020-000 Retirement 27,816.00 27,816.00 1,990.69 8,624.43 31.005 19,191.57 135-50026-020-000 Medical Insurance 30,805.00 30,805.00 2,145.38 6,367.00 20.669 24,438.00 135-50027-020-000 Dental Insurance 1,981.00 1,981.00 165.36 488.26 24.647 1,492.74 135-50028-020-000 Vision Insurance 552.00 552.00 41.20 121.56 22.022 430.44 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 773.68 3,449.53 40.125 5,147.47 135-50035-020-000 Medicare Taxes 2,011.00 2,011.00 180.94 806.72 40.115 1,204.28 135-50040-020-000 Unemployment Taxes 567.00 567.00 27.84 27.84 4.910 539.16 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 200.00 30.45 15.225 169.55 135-50070-020-000 Employee Relations 350.00 350.00 20.00 20.00 5.714 330.00 Subtotal: 274,937.00 275,137.00 19,403.55 83,527.74 30.359 191,609.26 135-55070-020-000 Independent Labor 750.00 750.00 750.00 135-55080-020-000 Maintenance & Repairs 17,750.00 17,750.00 10,666.54 14,525.24 81.832 3,224.76 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 4,300.00 9,137.50 26.107 25,862.50 135-55135-020-000 Lab Analysis 22,760.00 22,760.00 1,139.00 3,382.32 14.861 19,377.68 Subtotal: 85,608.00 85,608.00 16,105.54 27,045.06 31.592 58,562.94 135-60005-020-000 Telephone 100.00 .56 6.76 6.760 93.24 135-60010-020-000 Communications/Pagers/Mobiles 3,000.00 3,000.00 276.07 651.43 21.714 2,348.57 135-60020-020-000 Electricity 205,000.00 205,000.00 23,307.74 11.370 181,692.26 135-60025-020-000 Water 1,900.00 1,900.00 618.41 876.32 46.122 1,023.68 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 139.86 489.51 27.972 1,260.49 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 901.30 450.650 701.30- 135-60125-020-000 Advertising 1,000.00 987.36 98.736 12.64 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 223,640.00 1,034.90 35,091.09 15.691 188,548.91 . glbase_tbam rgonzale Trophy Club Entities Page 9 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 12/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 309.98 754.48 10.974 6,120.52 135-65010-020-000 Uniforms 3,140.00 3,140.00 645.96 20.572 2,494.04 135-65030-020-000 Chemicals 13,180.00 13,180.00 1,058.46 2,557.57 19.405 10,622.43 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 2,422.83 2,699.84 14.091 16,460.16 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 27.44 50.58 12.645 349.42 135-65095-020-000 Maintenance Supplies 8,860.00 8,860.00 316.13 661.79 7.469 8,198.21 135-65115-020-000 Other Consumables 110.00 110.00 110.00 Subtotal: 54,435.00 54,435.00 4,134.84 7,370.22 13.539 47,064.78 135-69005-020-000 Capital Expenses 161,189.00 161,189.00 34,800.26 21.590 126,388.74 135-69280-020-000 Capital Repairs 56,000.00 56,000.00 56,000.00 Subtotal: 217,189.00 217,189.00 34,800.26 16.023 182,388.74 Program number: 854,709.00 856,009.00 40,678.83 187,834.37 21.943 668,174.63 Department number: Wastewater 854,709.00 856,009.00 40,678.83 187,834.37 21.943 668,174.63 . glbase_tbam rgonzale Trophy Club Entities Page 10 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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 33,246.48 22.853 112,234.52 135-50010-021-000 Overtime 7,297.00 7,297.00 1,093.20 2,475.07 33.919 4,821.93 135-50016-021-000 Longevity 3,548.00 3,548.00 3,547.50 99.986 .50 135-50017-021-000 Certification 1,500.00 1,500.00 125.00 375.00 25.000 1,125.00 135-50020-021-000 Retirement 21,074.00 21,074.00 1,741.74 5,613.61 26.638 15,460.39 135-50026-021-000 Medical Insurance 22,983.00 22,983.00 1,702.68 5,108.04 22.225 17,874.96 135-50027-021-000 Dental Insurance 1,533.00 1,533.00 117.38 352.14 22.971 1,180.86 135-50028-021-000 Vision Insurance 357.00 357.00 29.72 89.16 24.975 267.84 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 703.64 2,281.00 23.311 7,504.00 135-50035-021-000 Medicare Taxes 2,288.00 2,288.00 164.56 533.46 23.316 1,754.54 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 19.97 19.97 7.988 230.03 Subtotal: 220,697.00 220,697.00 16,780.05 56,697.43 25.690 163,999.57 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 415.62 2,815.85 11.881 20,884.15 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 415.62 2,945.85 10.486 25,147.15 135-60005-021-000 Telephone 50.00 7.95 11.18 22.360 38.82 135-60010-021-000 Communications/Pagers/Mobiles 2,796.00 2,796.00 204.14 610.32 21.828 2,185.68 135-60020-021-000 Electricity 23,625.00 23,625.00 165.55 2,092.94 8.859 21,532.06 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 90.47 267.53 17.835 1,232.47 135-60105-021-000 Rent/Lease Equipment 44,107.00 76,098.00 76,098.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 109,892.00 468.11 2,981.97 2.714 106,910.03 135-65005-021-000 Fuel & Lube 11,700.00 11,700.00 1,143.75 2,597.84 22.204 9,102.16 135-65010-021-000 Uniforms 2,505.00 2,505.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:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 12/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 5.993 705.05 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 15.12 .094 16,034.88 Subtotal: 46,155.00 46,155.00 1,143.75 3,007.91 6.517 43,147.09 135-69005-021-000 Capital Expenses 15,000.00 15,000.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 91.403 3,009.00 Program number: 407,796.00 439,837.00 18,807.53 97,624.16 22.196 342,212.84 Department number: Collection 407,796.00 439,837.00 18,807.53 97,624.16 22.196 342,212.84 . glbase_tbam rgonzale Trophy Club Entities Page 12 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 12/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 1,300.00 13.000 8,700.00 135-50030-026-000 Social Security Taxes 620.00 620.00 80.60 13.000 539.40 135-50035-026-000 Medicare Taxes 145.00 145.00 18.85 13.000 126.15 135-50040-026-000 Unemployment Taxes 210.00 210.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 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 685.00 32.619 1,415.00 135-60075-026-000 Meetings 1,278.00 1,278.00 64.82 174.82 13.679 1,103.18 135-60080-026-000 Schools & Training 4,150.00 4,150.00 265.00 875.00 21.084 3,275.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 329.82 1,734.82 10.219 15,242.18 135-65085-026-000 Office Supplies 50.00 50.00 8.90 8.90 17.800 41.10 Subtotal: 50.00 50.00 8.90 8.90 17.800 41.10 Program number: 28,122.00 28,122.00 338.72 3,273.57 11.641 24,848.43 Department number: Board of Directors 28,122.00 28,122.00 338.72 3,273.57 11.641 24,848.43 . glbase_tbam rgonzale Trophy Club Entities Page 13 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 12/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,949.40 40,629.33 17.155 196,201.67 135-50010-027-000 Overtime 1,000.00 1,000.00 254.22 875.30 87.530 124.70 135-50016-027-000 Longevity 1,845.00 1,845.00 1,845.00 100.000 135-50020-027-000 Retirement 33,471.00 33,471.00 2,011.25 6,138.34 18.339 27,332.66 135-50026-027-000 Medical Insurance 18,798.00 18,798.00 1,330.16 3,744.65 19.920 15,053.35 135-50027-027-000 Dental Insurance 1,242.00 1,242.00 98.42 279.94 22.539 962.06 135-50028-027-000 Vision Insurance 341.00 341.00 25.12 70.82 20.768 270.18 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 674.43 2,402.34 16.166 12,457.66 135-50035-027-000 Medicare Taxes 3,475.00 3,475.00 195.60 599.75 17.259 2,875.25 135-50040-027-000 Unemployment Taxes 756.00 756.00 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 3,199.87 3,311.20 66.224 1,688.80 Subtotal: 319,536.00 319,536.00 21,738.47 60,486.64 18.930 259,049.36 135-55070-027-000 Independent Labor 840.00 840.00 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 95,384.68 95,384.68 53.929 81,485.32 Subtotal: 178,210.00 178,210.00 95,384.68 95,459.68 53.566 82,750.32 135-60005-027-000 Telephone 300.00 300.00 37.21 77.58 25.860 222.42 135-60010-027-000 Communications/Pagers/Mobiles 2,420.00 2,420.00 141.61 420.27 17.367 1,999.73 135-60035-027-000 Postage 1,000.00 177.85 433.24 43.324 566.76 135-60066-027-000 Publications/Books/Subscripts 450.00 450.00 26.25 114.75 25.500 335.25 135-60070-027-000 Dues & Memberships 1,742.00 1,742.00 302.95- 421.05 24.170 1,320.95 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 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 299.99 299.99 13.483 1,925.01 Subtotal: 31,155.00 32,155.00 379.96 1,994.78 6.204 30,160.22 135-65085-027-000 Office Supplies 2,450.00 2,450.00 172.76 361.99 14.775 2,088.01 135-65105-027-000 Printing 515.00 515.00 395.00 395.00 76.699 120.00 Subtotal: 2,965.00 2,965.00 567.76 756.99 25.531 2,208.01 Program number: 531,866.00 532,866.00 118,070.87 158,698.09 29.782 374,167.91 . glbase_tbam rgonzale Trophy Club Entities Page 14 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 27 Manager's Office Program: Period Ending: 12/2011 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 531,866.00 532,866.00 118,070.87 158,698.09 29.782 374,167.91 . glbase_tbam rgonzale Trophy Club Entities Page 15 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 28 Human Resources Program: Period Ending: 12/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 1,067.16 1,411.10 71.739 555.90 135-50075-028-000 Tuition Reimbursement 1,561.00 1,561.00 1,561.00 Subtotal: 3,528.00 3,528.00 1,067.16 1,411.10 39.997 2,116.90 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 105.00 105.00 6.731 1,455.00 Subtotal: 3,474.00 3,474.00 105.00 105.00 3.022 3,369.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 1,172.16 1,516.10 20.068 6,038.90 Department number: Human Resources 7,555.00 7,555.00 1,172.16 1,516.10 20.068 6,038.90 . glbase_tbam rgonzale Trophy Club Entities Page 16 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 29 Finance Program: Period Ending: 12/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,500.00 22,492.63 23.826 71,911.37 135-50010-029-000 Overtime 1,000.00 1,000.00 246.08 842.44 84.244 157.56 135-50016-029-000 Longevity 1,823.00 1,823.00 1,822.50 99.973 .50 135-50020-029-000 Retirement 13,612.00 13,612.00 1,096.84 3,562.30 26.170 10,049.70 135-50026-029-000 Medical Insurance 11,060.00 11,060.00 921.70 2,764.74 24.998 8,295.26 135-50027-029-000 Dental Insurance 773.00 773.00 73.52 220.55 28.532 552.45 135-50028-029-000 Vision Insurance 207.00 207.00 12.48 37.48 18.106 169.52 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 412.01 1,355.07 25.159 4,030.93 135-50035-029-000 Medicare Taxes 1,260.00 1,260.00 96.37 316.92 25.152 943.08 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 10,359.00 33,625.63 25.745 96,985.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 19.93 31.37 30.456 71.63 135-60010-029-000 Communications/Pagers/Mobiles 683.00 683.00 51.56 149.97 21.958 533.03 135-60035-029-000 Postage 700.00 700.00 59.84 8.549 640.16 135-60040-029-000 Service Charges & Fees 79.00 79.00 32.50 32.50 41.139 46.50 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 103.99 310.72 3.916 7,624.28 135-65085-029-000 Office Supplies 849.00 849.00 9.70 21.50 2.532 827.50 135-65105-029-000 Printing 515.00 515.00 515.00 Subtotal: 1,364.00 1,364.00 9.70 21.50 1.576 1,342.50 Program number: 144,910.00 144,910.00 10,472.69 33,957.85 23.434 110,952.15 Department number: Finance 144,910.00 144,910.00 10,472.69 33,957.85 23.434 110,952.15 . glbase_tbam rgonzale Trophy Club Entities Page 17 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 33 Information Systems Program: Period Ending: 12/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,915.88 16,729.56 26.079 47,419.44 135-55070-033-000 Independent Labor 1,650.00 1,650.00 156.25 375.00 22.727 1,275.00 Subtotal: 65,799.00 65,799.00 8,072.13 17,104.56 25.995 48,694.44 135-60005-033-000 Telephone 6,540.00 6,540.00 1,223.46 2,862.33 43.767 3,677.67 135-60235-033-000 Security 1,350.00 1,350.00 1,350.00 Subtotal: 7,890.00 7,890.00 1,223.46 2,862.33 36.278 5,027.67 135-65055-033-000 Hardware 83,238.00 83,238.00 51,795.49 57,680.57 69.296 25,557.43 135-65085-033-000 Office Supplies 371.00 371.00 107.12 28.873 263.88 135-65090-033-000 Printer Supplies & Maintenance 5,732.00 5,732.00 36.00 1,662.38 29.002 4,069.62 Subtotal: 89,341.00 89,341.00 51,831.49 59,450.07 66.543 29,890.93 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 256.85 513.70 14.890 2,936.30 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 513.70 1.692 29,847.30 Program number: 193,391.00 193,391.00 61,383.93 79,930.66 41.331 113,460.34 Department number: Information Systems 193,391.00 193,391.00 61,383.93 79,930.66 41.331 113,460.34 . glbase_tbam rgonzale Trophy Club Entities Page 18 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 37 Facilities Maintenance Program: Period Ending: 12/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 135-50020-037-000 Retirement 4,412.00 135-50026-037-000 Medical Insurance 9,027.00 135-50027-037-000 Dental Insurance 549.00 135-50028-037-000 Vision Insurance 138.00 135-50029-037-000 Life Insurance & Other 228.00 135-50030-037-000 Social Security Taxes 1,954.00 135-50035-037-000 Medicare Taxes 457.00 135-50040-037-000 Unemployment Taxes 189.00 135-50045-037-000 Workman's Compensation 861.00 861.00 861.00- 135-50060-037-000 Pre-emp Physicals/Testing 250.00 Subtotal: 49,577.00 861.00 861.00- 135-55100-037-000 Building Maint & Supplies 5,000.00 29,577.00 303.82 491.68 1.662 29,085.32 135-55120-037-000 Cleaning Services 25,000.00 1,678.51 3,906.58 15.626 21,093.42 Subtotal: 5,000.00 54,577.00 1,982.33 4,398.26 8.059 50,178.74 135-60020-037-000 Electricity 21,940.00 21,940.00 1,289.54 2,693.25 12.276 19,246.75 135-60025-037-000 Water 1,093.00 1,093.00 46.01 166.86 15.266 926.14 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 3,295.53 25.000 9,886.47 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,434.06 34,745.14 48.697 36,604.86 135-65095-037-000 Maintenance Supplies 2,205.00 2,205.00 55.37 247.10 11.206 1,957.90 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 46.65 66.34 6.634 933.66 Subtotal: 3,205.00 3,205.00 102.02 313.44 9.780 2,891.56 Program number: 129,132.00 129,132.00 4,518.41 40,317.84 31.222 88,814.16 Department number: Facilities Maintenance 129,132.00 129,132.00 4,518.41 40,317.84 31.222 88,814.16 . glbase_tbam rgonzale Trophy Club Entities Page 19 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 38 Utility Billing Program: Period Ending: 12/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,585.24 19,729.50 23.226 65,216.50 135-50010-038-000 Overtime 2,000.00 2,000.00 54.22 109.45 5.473 1,890.55 135-50016-038-000 Longevity 220.00 220.00 220.00 100.000 135-50020-038-000 Retirement 12,203.00 12,203.00 940.15 2,840.33 23.276 9,362.67 135-50026-038-000 Medical Insurance 12,321.00 12,321.00 924.35 2,773.07 22.507 9,547.93 135-50027-038-000 Dental Insurance 1,026.00 1,026.00 91.65 274.97 26.800 751.03 135-50028-038-000 Vision Insurance 260.00 260.00 21.63 64.88 24.954 195.12 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 375.87 1,136.33 21.028 4,267.67 135-50035-038-000 Medicare Taxes 1,264.00 1,264.00 87.90 265.74 21.024 998.26 135-50040-038-000 Unemployment Taxes 473.00 473.00 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,081.01 27,659.29 22.872 93,272.71 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 2,112.71 3,030.43 27.549 7,969.57 Subtotal: 11,800.00 11,800.00 2,112.71 3,030.43 25.682 8,769.57 135-60005-038-000 Telephone 100.00 100.00 10.30 31.21 31.210 68.79 135-60010-038-000 Communications/Pagers/Mobiles 472.00 472.00 36.69 105.16 22.280 366.84 135-60035-038-000 Postage 18,000.00 18,000.00 2,801.36 4,204.48 23.358 13,795.52 135-60040-038-000 Service Charges & Fees 18,000.00 18,000.00 2,500.87 8,960.88 49.783 9,039.12 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 25,071.20 25,071.20 111.428 2,571.20- 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 200.00 Subtotal: 60,748.00 60,748.00 30,420.42 38,372.93 63.167 22,375.07 135-65085-038-000 Office Supplies 700.00 700.00 22.18 75.92 10.846 624.08 135-65105-038-000 Printing 3,250.00 3,250.00 3,250.00 Subtotal: 3,950.00 3,950.00 22.18 75.92 1.922 3,874.08 Program number: 197,430.00 197,430.00 41,636.32 69,138.57 35.019 128,291.43 Department number: Utility Billing 197,430.00 197,430.00 41,636.32 69,138.57 35.019 128,291.43 . glbase_tbam rgonzale Trophy Club Entities Page 20 10:06 01/27/12 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 12/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 11,174.74 17,764.74 32.300 37,235.26 135-55055-039-000 Auditing 20,200.00 20,200.00 10,100.00 15,150.00 75.000 5,050.00 135-55060-039-000 Appraisal 20,000.00 20,000.00 8,533.65 42.668 11,466.35 135-55065-039-000 Tax Admin Fees 3,629.00 3,629.00 2,451.63 67.557 1,177.37 Subtotal: 98,829.00 98,829.00 21,274.74 43,900.02 44.420 54,928.98 135-60344-039-000 Intergov Trans Out (Fire CIP) 2,277.85 2,277.85 2,277.85- Subtotal: 2,277.85 2,277.85 2,277.85- Program number: 98,829.00 98,829.00 23,552.59 46,177.87 46.725 52,651.13 Department number: Non Departmental 98,829.00 98,829.00 23,552.59 46,177.87 46.725 52,651.13 Expenditures Subtotal ----------- 6,094,978.00 6,129,319.00 580,364.99 1,736,820.05 28.336 4,392,498.95 Fund number: 135 MUD 1 General Fund 132,963.66 349,772.72 349,772.72- . glbase_tbam rgonzale Trophy Club Entities Page 21 10:06 01/27/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 12/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- 546,716.00- 172,300.63- 205,968.04- 37.674 340,747.96- 533-40002-000-000 Property Taxes/Delinquent 3,947.00- 2,394.24 3,894.05 -98.658 7,841.05- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 4.13- 227.34- 4.531 4,789.66- Subtotal: 555,680.00- 555,680.00- 169,910.52- 202,301.33- 36.406 353,378.67- 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- 11.67- 30.06- 6.012 469.94- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- Subtotal: 308,500.00- 308,500.00- 11.67- 30.06- .010 308,469.94- Program number: 870,300.00- 870,300.00- 169,922.19- 208,451.39- 23.952 661,848.61- Department number: Revenues 870,300.00- 870,300.00- 169,922.19- 208,451.39- 23.952 661,848.61- Revenues Subtotal ----------- 870,300.00- 870,300.00- 169,922.19- 208,451.39- 23.952 661,848.61- . glbase_tbam rgonzale Trophy Club Entities Page 22 10:06 01/27/12 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 12/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: 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 169,922.19- 208,451.39- 208,451.39 ******* End of Report *********