Loading...
HomeMy WebLinkAboutFeb 2010 Budget Summary . glbase_tbam rgonzale Trophy Club Entities Page 43 14:46 03/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: Fire Revenues Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 51,966.00- 7,190.22- 38,356.44- 73.811 13,609.56- 122-40010-000-000 Property Taxes/MUD Fire 1,117,013.00- 1,117,013.00- 78,802.29- 1,069,798.93- 95.773 47,214.07- 122-40020-000-000 Property Taxes/Fire P&I 6,500.00- 6,500.00- 1,135.40- 3,246.64- 49.948 3,253.36- Subtotal: 1,123,513.00- 1,175,479.00- 87,127.91- 1,111,402.01- 94.549 64,076.99- 122-42014-000-000 Fire Permits/Sprinkler 2,400.00- 2,400.00- 2,400.00 Subtotal: 2,400.00- 2,400.00- 2,400.00 122-43400-000-000 Fire Inspections 450.00- 450.00- 450.00 122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 13,750.00- 13,750.00- 10,000.00- 72.727 3,750.00- 122-43426-000-000 Intergov Trans (PID Fire) 51,966.00- 6,563.41- 6,563.41- 6,563.41 122-43599-000-000 Misc Fire Revenue 1,200.00- 1,200.00- 1,200.00- Subtotal: 66,916.00- 14,950.00- 7,013.41- 17,013.41- 113.802 2,063.41 122-49010-000-000 Interest Income 4.91- 26.78- 26.78 Subtotal: 4.91- 26.78- 26.78 Program number: 1,190,429.00- 1,190,429.00- 96,546.23- 1,130,842.20- 94.995 59,586.80- Department number: Fire Revenues 1,190,429.00- 1,190,429.00- 96,546.23- 1,130,842.20- 94.995 59,586.80- . glbase_tbam rgonzale Trophy Club Entities Page 45 14:46 03/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 398,849.00 398,620.00 31,109.84 150,785.24 37.827 247,834.76 122-50010-045-000 Overtime 40,298.00 39,268.00 3,095.87 14,026.43 35.720 25,241.57 122-50011-045-000 DPS Holiday Pay 11,329.00 11,464.00 11,463.22 99.993 .78 122-50016-045-000 Longevity 2,704.00 2,798.00 2,797.22 99.972 .78 122-50017-045-000 Certification 5,356.00 5,356.00 629.44 2,517.76 47.008 2,838.24 122-50020-045-000 Retirement 59,532.00 59,532.00 4,517.63 25,288.45 42.479 34,243.55 122-50026-045-000 Medical Insurance 42,897.00 42,897.00 3,628.23 18,121.30 42.244 24,775.70 122-50027-045-000 Dental Insurance 3,052.00 3,052.00 258.11 1,289.23 42.242 1,762.77 122-50028-045-000 Vision Insurance 493.00 493.00 41.71 208.33 42.258 284.67 122-50029-045-000 Life Insurance & Other 2,582.00 2,582.00 192.58 975.05 37.763 1,606.95 122-50030-045-000 Social Security Taxes 26,516.00 26,516.00 1,960.12 11,721.08 44.204 14,794.92 122-50035-045-000 Medicare Taxes 6,201.00 6,201.00 458.45 2,741.17 44.205 3,459.83 122-50040-045-000 Unemployment Taxes 549.00 549.00 143.91 338.80 61.712 210.20 122-50045-045-000 Workman's Compensation 9,799.00 9,799.00 1,058.00 6,667.10 68.039 3,131.90 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 675.00 Subtotal: 610,832.00 609,802.00 47,093.89 248,940.38 40.823 360,861.62 122-55060-045-000 Appraisal 430.00 105.90 24.628 324.10 122-55065-045-000 Tax Admin Fee 600.00 488.40 81.400 111.60 122-55080-045-000 Maintenance & Repairs 5,400.00 5,400.00 9.97 664.40 12.304 4,735.60 122-55090-045-000 Vehicle Maintenance 13,500.00 13,500.00 130.61 5,048.23 37.394 8,451.77 122-55095-045-000 Equipment Maintenance 3,500.00 3,500.00 656.43 672.26 19.207 2,827.74 122-55100-045-000 Building Maintenance 11,000.00 11,000.00 145.64 1,002.30 9.112 9,997.70 122-55110-045-000 Maintenance-Radios 1,000.00 1,000.00 1,000.00 122-55160-045-000 Professional Outside Services 40,000.00 40,000.00 1,635.23 30,121.74 75.304 9,878.26 Subtotal: 74,400.00 75,430.00 2,577.88 38,103.23 50.515 37,326.77 122-60005-045-000 Telephone 100.00 100.00 1.71 10.11 10.110 89.89 122-60010-045-000 Communications/Pagers/Mobiles 2,477.00 2,477.00 180.83 904.66 36.522 1,572.34 122-60020-045-000 Electricity 16,571.00 16,571.00 1,080.83 4,431.74 26.744 12,139.26 122-60025-045-000 Water 3,100.00 3,100.00 85.20 432.92 13.965 2,667.08 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 93.00 93.00 3.76 79.61 85.602 13.39 122-60055-045-000 Insurance 19,024.00 19,024.00 19,024.00 122-60066-045-000 Publications/Books/Subscrips 364.00 364.00 43.04 11.824 320.96 122-60070-045-000 Dues & Memberships 7,960.00 7,960.00 5,547.52 6,112.52 76.790 1,847.48 122-60075-045-000 Meetings 300.00 300.00 67.52 22.507 232.48 122-60080-045-000 Schools & Training 6,300.00 6,300.00 75.00 1,385.00 21.984 4,915.00 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,769.00 6,769.00 65.37 1,189.09 17.567 5,579.91 122-60110-045-000 Physicals/Testing 1,843.00 1,843.00 1,800.00 97.667 43.00 122-60125-045-000 Advertising 150.00 150.00 150.00 122-60160-045-000 Programs & Special Projects 4,000.00 4,000.00 37.50 445.87 11.147 3,554.13 . glbase_tbam rgonzale Trophy Club Entities Page 46 14:46 03/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60180-045-000 Fire Inspection/Enforcement 1,000.00 1,000.00 251.99 25.199 748.01 122-60195-045-000 Flags & Repair 2,307.00 2,307.00 75.00 641.44 27.804 1,665.56 122-60245-045-000 Miscellaneous Expense 1,200.00 1,200.00 37.56 98.98 8.248 1,101.02 Subtotal: 382,558.00 382,558.00 315,190.28 326,894.49 85.450 55,663.51 122-65005-045-000 Fuel & Lube 15,795.00 15,795.00 59.00 2,387.18 15.114 13,407.82 122-65010-045-000 Uniforms 4,230.00 4,230.00 120.00 343.56 8.122 3,886.44 122-65015-045-000 Protective Clothing 4,600.00 4,600.00 6.79 721.25 15.679 3,878.75 122-65030-045-000 Chemicals 1,500.00 1,500.00 1,500.00 122-65035-045-000 Small Tools 7,890.00 7,890.00 59.85 719.55 9.120 7,170.45 122-65085-045-000 Office Supplies 310.00 310.00 96.73 31.203 213.27 122-65095-045-000 Maintenance Supplies 2,526.00 2,526.00 150.49 701.88 27.786 1,824.12 122-65105-045-000 Printing 100.00 100.00 22.49 22.49 22.490 77.51 Subtotal: 36,951.00 36,951.00 418.62 4,992.64 13.512 31,958.36 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69035-045-000 Vehicles 7,500.00 7,500.00 4,182.59 4,182.59 55.768 3,317.41 122-69251-045-000 Engine 681 Payment 72,943.00 72,943.00 6,971.30 6,971.30 9.557 65,971.70 122-69255-045-000 Airpacks 2,245.00 2,245.00 2,245.00 Subtotal: 85,688.00 85,688.00 11,153.89 11,153.89 13.017 74,534.11 Program number: 1,190,429.00 1,190,429.00 376,434.56 630,084.63 52.929 560,344.37 . glbase_tbam rgonzale Trophy Club Entities Page 44 14:46 03/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 26 TC WOMEN'S CLUB GRANT FY09-10 Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-45000-045-026 Grant Revenue 1,200.00- 1,200.00 Subtotal: 1,200.00- 1,200.00 Program number: 26 TC WOMEN'S CLUB GRANT FY09-10 1,200.00- 1,200.00 Department number: Fire 1,200.00- 1,200.00 Revenues Subtotal ----------- 1,190,429.00- 1,190,429.00- 96,546.23- 1,132,042.20- 95.095 58,386.80- . glbase_tbam rgonzale Trophy Club Entities Page 47 14:46 03/11/10 Budget Summary with Amendment Fund: 122 TROPHY CLUB MUD FIRE DEPT Department: 45 Fire Program: 26 TC WOMEN'S CLUB GRANT FY09-10 Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-65035-045-026 Small Tools 1,099.00 1,099.00- Subtotal: 1,099.00 1,099.00- Program number: 26 TC WOMEN'S CLUB GRANT FY09-10 1,099.00 1,099.00- Department number: Fire 1,190,429.00 1,190,429.00 376,434.56 631,183.63 53.022 559,245.37 Expenditures Subtotal ----------- 1,190,429.00 1,190,429.00 376,434.56 631,183.63 53.022 559,245.37 Fund number: 122 TROPHY CLUB MUD FIRE DEPT 279,888.33 500,858.57- 500,858.57 . glbase_tbam rgonzale Trophy Club Entities Page 48 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: Revenues Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 277,854.00- 277,854.00- 19,025.69- 265,086.65- 95.405 12,767.35- 135-40015-000-000 Property Taxes/P & I 265.60- 2,013.95- 2,013.95 Subtotal: 277,854.00- 277,854.00- 19,291.29- 267,100.60- 96.130 10,753.40- 135-47000-000-000 Water 1,683,525.00- 1,683,525.00- 72,205.82- 374,270.28- 22.231 1,309,254.72- 135-47005-000-000 Sewer 1,058,620.00- 1,058,620.00- 65,122.51- 322,783.01- 30.491 735,836.99- 135-47010-000-000 Commercial Water 748,780.00- 748,780.00- 28,378.76- 187,367.69- 25.023 561,412.31- 135-47015-000-000 Commercial Sewer 333,595.00- 333,595.00- 19,590.88- 93,898.31- 28.147 239,696.69- 135-47020-000-000 Standby 1,140.00- 1,140.00- 58.40- 289.80- 25.421 850.20- 135-47025-000-000 Penalties 55,000.00- 55,000.00- 3,149.52- 16,244.90- 29.536 38,755.10- 135-47030-000-000 Service Charges 16,000.00- 16,000.00- 1,020.94- 9,802.65- 61.267 6,197.35- 135-47035-000-000 Plumbing Inspections 50.00- 350.00- 350.00 135-47045-000-000 Sewer Inspections 1,250.00- 1,250.00- 150.00- 1,050.00- 84.000 200.00- 135-47070-000-000 TCCC Effluent Charges 60,000.00- 60,000.00- 3,935.91- 6.560 56,064.09- 135-47270-000-000 Fire Line 3,150.00- 3,150.00 135-47400-000-000 Water-Out of Dist/Port Meters 36,150.00- 36,150.00- 106.16- 14,298.23- 39.553 21,851.77- 135-47405-000-000 Out of District Sewer 15,500.00- 15,500.00- 905.68- 4,439.01- 28.639 11,060.99- 135-47410-000-000 Out of Dist/Portable Penalties 200.00- 200.00- 701.74- 350.870 501.74 135-47600-000-000 PID #1 Water 201,396.00- 201,396.00- 7,845.70- 48,625.97- 24.144 152,770.03- 135-47605-000-000 PID #1 Sewer 59,900.00- 59,900.00- 4,103.14- 17,562.15- 29.319 42,337.85- Subtotal: 4,271,056.00- 4,271,056.00- 202,687.51- 1,098,769.65- 25.726 3,172,286.35- 135-49010-000-000 Interest Income 2,000.00- 2,000.00- 212.62- 900.98- 45.049 1,099.02- 135-49015-000-000 Lease/Rental Income 10,164.00- 10,164.00- 847.00- 3,388.00- 33.333 6,776.00- 135-49030-000-000 Vending Revenue 850.00- 850.00- 300.00- 35.294 550.00- 135-49036-000-000 GASB Reserves 12,710.00- 12,710.00- 12,710.00- 135-49075-000-000 New Oversize Meter Reimburse 36,000.00- 36,000.00- 3,328.00- 17,152.00- 47.644 18,848.00- 135-49900-000-000 Miscellaneous Income 21,100.00- 21,100.00- 5,759.93- 11,428.51- 54.164 9,671.49- 135-49901-000-000 Records Management Revenue 158.00- 158.00 135-49902-000-000 Sewer/Septic Dump Revenue 32,000.00- 32,000.00- 3,882.50- 17,630.00- 55.094 14,370.00- 135-49905-000-000 Gas Well Revenue 6,200.00- 6,200.00- 192.74- 811.58- 13.090 5,388.42- Subtotal: 121,024.00- 121,024.00- 14,222.79- 51,769.07- 42.776 69,254.93- Program number: 4,669,934.00- 4,669,934.00- 236,201.59- 1,417,639.32- 30.357 3,252,294.68- Department number: Revenues 4,669,934.00- 4,669,934.00- 236,201.59- 1,417,639.32- 30.357 3,252,294.68- Revenues Subtotal ----------- 4,669,934.00- 4,669,934.00- 236,201.59- 1,417,639.32- 30.357 3,252,294.68- . glbase_tbam rgonzale Trophy Club Entities Page 49 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 159,774.00 159,774.00 9,383.70 45,589.31 28.534 114,184.69 135-50010-010-000 Overtime 8,814.00 8,814.00 1,184.57 6,590.37 74.772 2,223.63 135-50016-010-000 Longevity 1,910.00 1,910.00 1,910.00 100.000 135-50017-010-000 Certification 1,500.00 1,500.00 115.00 460.00 30.667 1,040.00 135-50020-010-000 Retirement 22,360.00 22,360.00 1,416.61 7,681.47 34.354 14,678.53 135-50026-010-000 Medical Insurance 23,135.00 23,135.00 1,266.18 6,330.90 27.365 16,804.10 135-50027-010-000 Dental Insurance 1,569.00 1,569.00 87.74 438.70 27.960 1,130.30 135-50028-010-000 Vision Insurance 282.00 282.00 16.06 80.30 28.475 201.70 135-50029-010-000 Life Insurance & Other 1,125.00 1,125.00 63.85 319.25 28.378 805.75 135-50030-010-000 Social Security Taxes 10,616.00 10,616.00 654.45 3,748.64 35.311 6,867.36 135-50035-010-000 Medicare Taxes 2,483.00 2,483.00 153.06 876.68 35.307 1,606.32 135-50040-010-000 Unemployment Taxes 270.00 270.00 53.42 105.34 39.015 164.66 135-50045-010-000 Workman's Compensation 5,496.00 5,496.00 2,284.00- 862.00 15.684 4,634.00 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 200.00 135-50070-010-000 Employee Relations 350.00 350.00 103.00 29.429 247.00 Subtotal: 239,884.00 239,884.00 12,110.64 75,095.96 31.305 164,788.04 135-55005-010-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-010-000 Maintenance & Repairs 26,000.00 26,000.00 741.77 2.853 25,258.23 135-55090-010-000 Vehicle Maintenance 3,180.00 3,180.00 422.36 2,075.41 65.264 1,104.59 135-55100-010-000 Building Maint & Supplies 750.00 750.00 8.15 1.087 741.85 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 48.80 1.683 2,851.20 135-55135-010-000 Lab Analysis 3,350.00 3,350.00 617.00 18.418 2,733.00 Subtotal: 37,680.00 37,680.00 422.36 3,491.13 9.265 34,188.87 135-60010-010-000 Communications/Pagers/Mobiles 2,016.00 2,016.00 133.64 676.16 33.540 1,339.84 135-60020-010-000 Electricity 195,000.00 195,000.00 6,571.98 33,310.38 17.082 161,689.62 135-60035-010-000 Postage 100.00 100.00 10.90 10.900 89.10 135-60050-010-000 Bad Debt Expense 4,200.00 4,200.00 451.27 10.745 3,748.73 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 166.00 5.929 2,634.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 104.50 649.45 20.295 2,550.55 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 500.00 135-60135-010-000 Annual Permit Fee 6,600.00 6,600.00 6,133.95 92.939 466.05 135-60150-010-000 Bulk Water 1,410,000.00 1,410,000.00 61,575.43 258,655.23 18.344 1,151,344.77 135-60245-010-000 Miscellaneous Expenses 15.88 15.88 15.88- 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 487.00 11.595 3,713.00 135-60285-010-000 Lawn Equipment & Maintenance 2,000.00 2,000.00 2,000.00 Subtotal: 1,631,316.00 1,631,316.00 68,401.43 300,556.22 18.424 1,330,759.78 . glbase_tbam rgonzale Trophy Club Entities Page 50 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 10 Water Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 15,216.00 15,216.00 2,733.37 17.964 12,482.63 135-65010-010-000 Uniforms 3,690.00 3,690.00 291.83 841.72 22.811 2,848.28 135-65030-010-000 Chemicals 5,200.00 5,200.00 169.72 2,648.56 50.934 2,551.44 135-65035-010-000 Small Tools 2,500.00 2,500.00 115.82 4.633 2,384.18 135-65040-010-000 Safety Equipment 2,500.00 2,500.00 2,500.00 135-65050-010-000 Meter Expense 75,000.00 75,000.00 62,886.00 83.848 12,114.00 135-65055-010-000 Hardware 1,000.00 1,000.00 51.74 51.74 5.174 948.26 135-65095-010-000 Maintenance Supplies 30,000.00 30,000.00 1,828.10 3,320.68 11.069 26,679.32 135-65100-010-000 Copies 50.00 50.00 50.00 135-65105-010-000 Printing 150.00 150.00 150.00 Subtotal: 135,306.00 135,306.00 2,341.39 72,597.89 53.655 62,708.11 135-69005-010-000 Capital Expenses 38,500.00 38,500.00 1,785.00 4.636 36,715.00 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 9,000.00 9,000.00 9,000.00 135-69281-010-000 Capital Repair-Ground Storage 124,771.00 124,771.00 97,741.64 78.337 27,029.36 135-69295-010-000 Unexpected Maintenance 250.00 250.00 250.00 135-69305-010-000 Capital Leases 11,490.00 11,490.00 11,490.00 Subtotal: 214,011.00 214,011.00 99,526.64 46.505 114,484.36 Program number: 2,258,197.00 2,258,197.00 83,275.82 551,267.84 24.412 1,706,929.16 Department number: Water 2,258,197.00 2,258,197.00 83,275.82 551,267.84 24.412 1,706,929.16 . glbase_tbam rgonzale Trophy Club Entities Page 51 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 171,607.00 171,607.00 13,200.56 63,986.04 37.286 107,620.96 135-50010-020-000 Overtime 10,166.00 10,166.00 1,516.20 7,653.84 75.289 2,512.16 135-50016-020-000 Longevity 3,153.00 3,153.00 3,152.50 99.984 .50 135-50017-020-000 Certification 2,550.00 2,550.00 175.00 700.00 27.451 1,850.00 135-50020-020-000 Retirement 24,372.00 24,372.00 1,974.64 10,598.89 43.488 13,773.11 135-50026-020-000 Medical Insurance 27,503.00 27,503.00 2,291.92 11,459.60 41.667 16,043.40 135-50027-020-000 Dental Insurance 1,983.00 1,983.00 165.28 826.40 41.674 1,156.60 135-50028-020-000 Vision Insurance 357.00 357.00 29.76 148.80 41.681 208.20 135-50029-020-000 Life Insurance & Other 1,198.00 1,198.00 88.95 444.75 37.124 753.25 135-50030-020-000 Social Security Taxes 9,936.00 9,936.00 781.96 4,513.27 45.423 5,422.73 135-50035-020-000 Medicare Taxes 2,324.00 2,324.00 182.88 1,055.52 45.418 1,268.48 135-50040-020-000 Unemployment Taxes 270.00 270.00 71.70 149.23 55.270 120.77 135-50045-020-000 Workman's Compensation 5,991.00 5,991.00 316.00- 3,113.34 51.967 2,877.66 135-50070-020-000 Employee Relations 250.00 250.00 250.00 Subtotal: 261,660.00 261,660.00 20,162.85 107,802.18 41.199 153,857.82 135-55005-020-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-020-000 Independent Labor 750.00 750.00 750.00 135-55080-020-000 Maintenance & Repairs 20,250.00 20,250.00 5,681.58 28.057 14,568.42 135-55090-020-000 Vehicle Maintenance 2,292.00 2,292.00 1,213.14 52.929 1,078.86 135-55100-020-000 Building Maint & Supplies 1,400.00 1,400.00 358.00 25.571 1,042.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 2,950.00 2,950.00 303.53 10.289 2,646.47 135-55125-020-000 Dumpster Services 28,000.00 28,000.00 680.90 5,772.10 20.615 22,227.90 135-55135-020-000 Lab Analysis 20,750.00 20,750.00 1,672.75 4,749.75 22.890 16,000.25 Subtotal: 77,892.00 77,892.00 2,353.65 18,078.10 23.209 59,813.90 135-60005-020-000 Telephone 10.00 .86 10.68 106.800 .68- 135-60010-020-000 Communications/Pagers/Mobiles 3,276.00 3,276.00 238.37 1,205.64 36.802 2,070.36 135-60020-020-000 Electricity 230,000.00 230,000.00 15,754.68 69,910.49 30.396 160,089.51 135-60025-020-000 Water 1,600.00 1,600.00 75.82 583.78 36.486 1,016.22 135-60035-020-000 Postage 120.00 120.00 120.00 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60080-020-000 Schools & Training 1,320.00 1,320.00 40.00 3.030 1,280.00 135-60090-020-000 Safety Program 200.00 200.00 200.00 135-60100-020-000 Travel & per diem 1,250.00 1,250.00 197.00 955.20 76.416 294.80 135-60105-020-000 Rent/Lease Equipment 200.00 200.00 200.00 135-60135-020-000 Annual Permit Fee 7,500.00 7,490.00 7,432.50 99.232 57.50 135-60245-020-000 Miscellaneous Expenses 525.00 525.00 25.72 25.72 4.899 499.28 135-60285-020-000 Lawn Equipment & Maintenance 525.00 525.00 525.00 Subtotal: 247,016.00 247,016.00 16,292.45 80,164.01 32.453 166,851.99 135-65005-020-000 Fuel & Lube 3,775.00 3,775.00 862.94 22.859 2,912.06 . glbase_tbam rgonzale Trophy Club Entities Page 52 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 20 Wastewater Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65010-020-000 Uniforms 2,205.00 2,205.00 317.83 989.29 44.866 1,215.71 135-65030-020-000 Chemicals 9,900.00 9,900.00 169.71 4,639.03 46.859 5,260.97 135-65035-020-000 Small Tools 1,260.00 1,260.00 206.93 16.423 1,053.07 135-65040-020-000 Safety Equipment 540.00 540.00 246.56 45.659 293.44 135-65045-020-000 Lab Supplies 6,085.00 6,085.00 299.95 2,131.84 35.034 3,953.16 135-65055-020-000 Hardware 525.00 525.00 525.00 135-65085-020-000 Office Supplies 400.00 400.00 400.00 135-65095-020-000 Maintenance Supplies 13,260.00 13,260.00 698.96 5.271 12,561.04 135-65115-020-000 Other Consumables 110.00 110.00 5.44 4.945 104.56 Subtotal: 38,060.00 38,060.00 787.49 9,780.99 25.699 28,279.01 135-69005-020-000 Capital Expenses 144,689.00 144,689.00 144,689.00 135-69280-020-000 Capital Repairs 51,800.00 51,800.00 14,994.25 28.946 36,805.75 Subtotal: 196,489.00 196,489.00 14,994.25 7.631 181,494.75 Program number: 821,117.00 821,117.00 39,596.44 230,819.53 28.110 590,297.47 Department number: Wastewater 821,117.00 821,117.00 39,596.44 230,819.53 28.110 590,297.47 . glbase_tbam rgonzale Trophy Club Entities Page 53 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 132,345.00 132,313.00 10,174.50 49,438.05 37.364 82,874.95 135-50010-021-000 Overtime 14,145.00 14,145.00 828.61 4,256.52 30.092 9,888.48 135-50016-021-000 Longevity 2,888.00 2,920.00 2,920.00 100.000 135-50017-021-000 Certification 1,200.00 1,200.00 125.00 500.00 41.667 700.00 135-50020-021-000 Retirement 19,575.00 19,575.00 1,475.59 8,015.44 40.947 11,559.56 135-50026-021-000 Medical Insurance 18,043.00 18,043.00 1,503.56 7,517.80 41.666 10,525.20 135-50027-021-000 Dental Insurance 1,426.00 1,426.00 118.88 594.40 41.683 831.60 135-50028-021-000 Vision Insurance 206.00 206.00 18.52 92.60 44.951 113.40 135-50029-021-000 Life Insurance & Other 914.00 914.00 67.66 338.30 37.013 575.70 135-50030-021-000 Social Security Taxes 8,396.00 8,396.00 624.74 3,622.32 43.143 4,773.68 135-50035-021-000 Medicare Taxes 1,964.00 1,964.00 146.11 847.16 43.134 1,116.84 135-50040-021-000 Unemployment Taxes 203.00 203.00 53.63 112.18 55.261 90.82 135-50045-021-000 Workman's Compensation 3,147.00 3,147.00 316.00- 1,485.38 47.200 1,661.62 135-50070-021-000 Employee Relations 250.00 250.00 250.00 Subtotal: 204,702.00 204,702.00 14,820.80 79,740.15 38.954 124,961.85 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55070-021-000 Independent Labor 200.00 200.00 200.00 135-55080-021-000 Maintenance & Repairs 10,000.00 10,000.00 1,079.18 3,198.90 31.989 6,801.10 135-55090-021-000 Vehicle Maintenance 2,068.00 2,068.00 741.79 35.870 1,326.21 135-55100-021-000 Building Maint & Supplies 750.00 750.00 750.00 Subtotal: 14,518.00 14,518.00 1,079.18 3,940.69 27.143 10,577.31 135-60010-021-000 Communications/Pagers/Mobiles 2,112.00 2,112.00 174.44 873.14 41.342 1,238.86 135-60020-021-000 Electricity 22,250.00 22,250.00 1,953.22 8,694.62 39.077 13,555.38 135-60025-021-000 Water 750.00 750.00 3.12 28.08 3.744 721.92 135-60035-021-000 Postage 150.00 150.00 150.00 135-60070-021-000 Dues & Memberships 255.00 255.00 111.00 43.529 144.00 135-60080-021-000 Schools & Training 2,818.00 2,818.00 90.00 3.194 2,728.00 135-60090-021-000 Safety Program 750.00 750.00 750.00 135-60100-021-000 Travel & per diem 1,500.00 1,500.00 29.50 268.25 17.883 1,231.75 135-60105-021-000 Rent/Lease Equipment 39,000.00 39,000.00 39,000.00 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 15.88 15.88 15.880 84.12 135-60280-021-000 Property Maintenance 1,000.00 1,000.00 1,000.00 Subtotal: 70,685.00 70,685.00 2,176.16 10,080.97 14.262 60,604.03 135-65005-021-000 Fuel & Lube 10,700.00 10,700.00 3,200.43 29.911 7,499.57 135-65010-021-000 Uniforms 2,505.00 2,505.00 228.97 558.95 22.313 1,946.05 135-65030-021-000 Chemicals 10,000.00 10,000.00 519.00 5.190 9,481.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 1,500.00 135-65040-021-000 Safety Equipment 1,150.00 1,150.00 1,150.00 135-65055-021-000 Hardware 750.00 750.00 750.00 . glbase_tbam rgonzale Trophy Club Entities Page 54 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 21 Collection Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65095-021-000 Maintenance Supplies 16,050.00 16,050.00 16,050.00 Subtotal: 42,655.00 42,655.00 228.97 4,278.38 10.030 38,376.62 135-69005-021-000 Capital Expenses 10,000.00 10,000.00 10,000.00 135-69280-021-000 Capital Repairs 20,000.00 20,000.00 20,000.00 Subtotal: 30,000.00 30,000.00 30,000.00 Program number: 362,560.00 362,560.00 18,305.11 98,040.19 27.041 264,519.81 Department number: Collection 362,560.00 362,560.00 18,305.11 98,040.19 27.041 264,519.81 . glbase_tbam rgonzale Trophy Club Entities Page 55 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 26 Board of Directors Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 15,000.00 15,000.00 1,700.00 4,300.00 28.667 10,700.00 135-50030-026-000 Social Security Taxes 1,290.00 1,290.00 105.40 310.00 24.031 980.00 135-50035-026-000 Medicare Taxes 302.00 302.00 24.65 72.50 24.007 229.50 135-50040-026-000 Unemployment Taxes 375.00 375.00 8.50 25.00 6.667 350.00 135-50045-026-000 Workman's Compensation 120.00 120.00 23.00- 45.68 38.067 74.32 Subtotal: 17,087.00 17,087.00 1,815.55 4,753.18 27.818 12,333.82 135-55045-026-000 Legal 32,500.00 32,500.00 6,779.50 33,547.46 103.223 1,047.46- 135-55060-026-000 Appraisal 18,874.00 18,374.00 6,785.89 36.932 11,588.11 135-55065-026-000 Tax Admin Fees 2,380.00 2,880.00 27.38 2,866.41 99.528 13.59 Subtotal: 53,754.00 53,754.00 6,806.88 43,199.76 80.366 10,554.24 135-60066-026-000 Publications/Books/Subscripts 54.00 54.00 54.00 135-60070-026-000 Dues & Memberships 1,096.00 2,096.00 1,925.00 91.842 171.00 135-60075-026-000 Meetings 600.00 600.00 66.61 11.102 533.39 135-60080-026-000 Schools & Training 5,775.00 5,775.00 1,325.00 22.944 4,450.00 135-60100-026-000 Travel & per diem 12,147.00 11,147.00 40.75 .366 11,106.25 135-60125-026-000 Advertising 820.00 820.00 820.00 135-60245-026-000 Miscellaneous Expenses 300.00 300.00 300.00 Subtotal: 20,792.00 20,792.00 3,357.36 16.147 17,434.64 135-65085-026-000 Office Supplies 200.00 200.00 7.50 3.750 192.50 Subtotal: 200.00 200.00 7.50 3.750 192.50 Program number: 91,833.00 91,833.00 8,622.43 51,317.80 55.882 40,515.20 Department number: Board of Directors 91,833.00 91,833.00 8,622.43 51,317.80 55.882 40,515.20 . glbase_tbam rgonzale Trophy Club Entities Page 56 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-027-000 Salaries & Wages 249,499.00 249,499.00 19,140.12 92,320.60 37.002 157,178.40 135-50010-027-000 Overtime 1,750.00 1,750.00 900.68 2,050.09 117.148 300.09- 135-50016-027-000 Longevity 3,056.00 3,056.00 3,056.25 100.008 .25- 135-50020-027-000 Retirement 32,982.00 32,982.00 2,645.58 13,803.05 41.850 19,178.95 135-50026-027-000 Medical Insurance 22,317.00 22,317.00 1,859.72 9,298.61 41.666 13,018.39 135-50027-027-000 Dental Insurance 1,446.00 1,446.00 120.51 602.58 41.672 843.42 135-50028-027-000 Vision Insurance 269.00 269.00 22.36 111.83 41.572 157.17 135-50029-027-000 Life Insurance & Other 1,501.00 1,501.00 105.26 542.89 36.169 958.11 135-50030-027-000 Social Security Taxes 15,459.00 15,459.00 1,185.79 6,542.47 42.321 8,916.53 135-50035-027-000 Medicare Taxes 3,615.00 3,615.00 277.33 1,530.10 42.326 2,084.90 135-50040-027-000 Unemployment Taxes 304.00 304.00 60.38 158.71 52.207 145.29 135-50045-027-000 Workman's Compensation 671.00 671.00 334.00 718.10 107.019 47.10- 135-50070-027-000 Employee Relations 838.00 838.00 36.34 113.27 13.517 724.73 Subtotal: 333,707.00 333,707.00 26,688.07 130,848.55 39.211 202,858.45 135-55070-027-000 Independent Labor 720.00 720.00 45.00 266.25 36.979 453.75 135-55075-027-000 Records Management 100.00 100.00 52.50 121.50 121.500 21.50- 135-55160-027-000 Professional Outside Services 1,000.00 1,000.00 126.87 12.687 873.13 Subtotal: 1,820.00 1,820.00 97.50 514.62 28.276 1,305.38 135-60005-027-000 Telephone 265.00 265.00 22.07 107.09 40.411 157.91 135-60010-027-000 Communications/Pagers/Mobiles 2,775.00 2,775.00 242.85 1,381.90 49.798 1,393.10 135-60035-027-000 Postage 1,071.00 1,071.00 100.87 454.86 42.471 616.14 135-60040-027-000 Service Charges & Fees 50.00 50.00 50.00- 135-60066-027-000 Publications/Books/Subscripts 350.00 350.00 53.35 15.243 296.65 135-60070-027-000 Dues & Memberships 1,673.00 1,673.00 300.00 1,183.66 70.751 489.34 135-60075-027-000 Meetings 961.00 961.00 22.00 2.289 939.00 135-60080-027-000 Schools & Training 2,715.00 2,715.00 726.00 26.740 1,989.00 135-60100-027-000 Travel & per diem 2,094.00 2,094.00 14.18 1,062.46 50.738 1,031.54 135-60115-027-000 Elections 3,500.00 3,500.00 476.80 760.68 21.734 2,739.32 135-60125-027-000 Advertising 650.00 650.00 650.00 135-60245-027-000 Miscellaneous Expenses 100.00 100.00 100.00 135-60270-027-000 4th of July Celebration 10,000.00 10,000.00 10,000.00 135-60360-027-000 Furniture/Equipment < $5000 1,750.00 1,750.00 75.99 75.99 4.342 1,674.01 Subtotal: 27,904.00 27,904.00 1,282.76 5,877.99 21.065 22,026.01 135-65085-027-000 Office Supplies 2,450.00 2,450.00 283.66 884.88 36.118 1,565.12 135-65105-027-000 Printing 515.00 515.00 515.00 Subtotal: 2,965.00 2,965.00 283.66 884.88 29.844 2,080.12 Program number: 366,396.00 366,396.00 28,351.99 138,126.04 37.699 228,269.96 . glbase_tbam rgonzale Trophy Club Entities Page 57 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 27 Manager's Office Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Manager's Office 366,396.00 366,396.00 28,351.99 138,126.04 37.699 228,269.96 . glbase_tbam rgonzale Trophy Club Entities Page 58 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 28 Human Resources Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-028-000 Salaries & Wages 25,698.00 25,698.00 1,976.80 9,601.58 37.363 16,096.42 135-50016-028-000 Longevity 98.00 98.00 97.50 99.490 .50 135-50020-028-000 Retirement 3,353.00 3,353.00 262.12 1,378.57 41.115 1,974.43 135-50026-028-000 Medical Insurance 2,669.00 2,669.00 222.38 1,111.92 41.661 1,557.08 135-50027-028-000 Dental Insurance 155.00 155.00 12.91 64.61 41.684 90.39 135-50028-028-000 Vision Insurance 30.00 30.00 2.48 12.42 41.400 17.58 135-50029-028-000 Life Insurance & Other 184.00 184.00 13.57 67.85 36.875 116.15 135-50030-028-000 Social Security Taxes 1,587.00 1,587.00 122.57 678.97 42.783 908.03 135-50035-028-000 Medicare Taxes 371.00 371.00 28.65 158.77 42.795 212.23 135-50040-028-000 Unemployment Taxes 34.00 34.00 9.90 19.78 58.176 14.22 135-50045-028-000 Workman's Compensation 68.00 68.00 38.92 57.235 29.08 135-50070-028-000 Employee Relations 1,625.00 1,625.00 86.73 1,089.78 67.063 535.22 135-50075-028-000 Tuition Reimbursement 1,500.00 1,500.00 115.50 7.700 1,384.50 135-50994-028-000 Employee Assistance Program 106.40 522.20 522.20- 135-50995-028-000 Flexible Benefits Admin Fee 659.86 659.86- Subtotal: 37,372.00 37,372.00 2,844.51 15,618.23 41.791 21,753.77 135-60005-028-000 Telephone 26.00 26.00 1.44 5.538 24.56 135-60010-028-000 Communications/Pagers/Mobiles 210.00 210.00 16.04 80.08 38.133 129.92 135-60035-028-000 Postage 102.00 102.00 3.03 43.35 42.500 58.65 135-60066-028-000 Publications/Books/Subscripts 440.00 440.00 440.00 135-60070-028-000 Dues & Memberships 504.00 504.00 75.00 14.881 429.00 135-60075-028-000 Meetings 130.00 130.00 87.50 67.308 42.50 135-60080-028-000 Schools & Training 539.00 539.00 539.00 135-60100-028-000 Travel & per diem 8.00 8.00 8.00 135-60110-028-000 Physicals/Testing 960.00 960.00 165.00 17.188 795.00 Subtotal: 2,919.00 2,919.00 19.07 452.37 15.497 2,466.63 135-65085-028-000 Office Supplies 412.00 412.00 3.52 .854 408.48 135-65105-028-000 Printing 110.00 110.00 110.00 Subtotal: 522.00 522.00 3.52 .674 518.48 Program number: 40,813.00 40,813.00 2,863.58 16,074.12 39.385 24,738.88 Department number: Human Resources 40,813.00 40,813.00 2,863.58 16,074.12 39.385 24,738.88 . glbase_tbam rgonzale Trophy Club Entities Page 59 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 29 Finance Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-029-000 Salaries & Wages 135,172.00 133,457.00 10,396.34 43,400.55 32.520 90,056.45 135-50010-029-000 Overtime 2,000.00 3,683.00 642.56 3,682.05 99.974 .95 135-50016-029-000 Longevity 1,259.00 1,259.00 870.00 69.102 389.00 135-50020-029-000 Retirement 17,996.00 17,996.00 1,463.78 6,906.01 38.375 11,089.99 135-50026-029-000 Medical Insurance 10,550.00 10,550.00 952.68 4,515.11 42.797 6,034.89 135-50027-029-000 Dental Insurance 765.00 765.00 63.71 286.34 37.430 478.66 135-50028-029-000 Vision Insurance 127.00 127.00 10.55 46.54 36.646 80.46 135-50029-029-000 Life Insurance & Other 830.00 830.00 77.00 261.52 31.508 568.48 135-50030-029-000 Social Security Taxes 8,265.00 8,265.00 624.39 3,103.56 37.551 5,161.44 135-50035-029-000 Medicare Taxes 1,933.00 1,933.00 146.01 725.85 37.550 1,207.15 135-50040-029-000 Unemployment Taxes 135.00 135.00 37.63 87.17 64.570 47.83 135-50045-029-000 Workman's Compensation 365.00 365.00 208.94 57.244 156.06 135-50060-029-000 Pre-emp Physicals/Testing 32.00 31.47 98.344 .53 Subtotal: 179,397.00 179,397.00 14,414.65 64,125.11 35.745 115,271.89 135-55055-029-000 Auditing 40,000.00 40,000.00 34,250.00 85.625 5,750.00 135-55160-029-000 Professional Outside Services 105.00 105.00 100.000 Subtotal: 40,000.00 40,105.00 34,355.00 85.663 5,750.00 135-60005-029-000 Telephone 103.00 103.00 10.06 39.43 38.282 63.57 135-60010-029-000 Communications/Pagers/Mobiles 506.00 506.00 36.03 180.07 35.587 325.93 135-60035-029-000 Postage 900.00 900.00 33.91 342.92 38.102 557.08 135-60040-029-000 Service Charges & Fees 75.00 75.00 32.50 43.333 42.50 135-60066-029-000 Publications/Books/Subscripts 250.00 250.00 25.70 10.280 224.30 135-60070-029-000 Dues & Memberships 1,361.00 1,361.00 85.00 834.35 61.304 526.65 135-60075-029-000 Meetings 66.00 66.00 11.00 22.00 33.333 44.00 135-60080-029-000 Schools & Training 1,370.00 1,370.00 77.50 426.05 31.099 943.95 135-60100-029-000 Travel & per diem 1,635.00 1,635.00 21.35 138.94 8.498 1,496.06 135-60245-029-000 Miscellaneous Expenses 1,000.00 895.00 895.00 Subtotal: 7,266.00 7,161.00 274.85 2,041.96 28.515 5,119.04 135-65085-029-000 Office Supplies 800.00 800.00 299.55 619.04 77.380 180.96 135-65105-029-000 Printing 900.00 900.00 900.00 Subtotal: 1,700.00 1,700.00 299.55 619.04 36.414 1,080.96 Program number: 228,363.00 228,363.00 14,989.05 101,141.11 44.290 127,221.89 Department number: Finance 228,363.00 228,363.00 14,989.05 101,141.11 44.290 127,221.89 . glbase_tbam rgonzale Trophy Club Entities Page 60 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-033-000 Salaries & Wages 58,883.00 58,883.00 4,529.42 22,000.04 37.362 36,882.96 135-50016-033-000 Longevity 278.00 338.00 337.50 99.852 .50 135-50020-033-000 Retirement 7,691.00 7,691.00 600.59 3,172.61 41.251 4,518.39 135-50026-033-000 Medical Insurance 4,928.00 4,928.00 410.69 2,053.45 41.669 2,874.55 135-50027-033-000 Dental Insurance 310.00 310.00 25.81 129.05 41.629 180.95 135-50028-033-000 Vision Insurance 60.00 60.00 4.97 24.85 41.417 35.15 135-50029-033-000 Life Insurance & Other 384.00 384.00 28.40 142.00 36.979 242.00 135-50030-033-000 Social Security Taxes 3,668.00 3,668.00 280.84 1,562.71 42.604 2,105.29 135-50035-033-000 Medicare Taxes 858.00 858.00 65.68 365.44 42.592 492.56 135-50040-033-000 Unemployment Taxes 68.00 68.00 18.45 41.09 60.426 26.91 135-50045-033-000 Workman's Compensation 156.00 156.00 89.30 57.244 66.70 Subtotal: 77,284.00 77,344.00 5,964.85 29,918.04 38.682 47,425.96 135-55030-033-000 Software & Support 56,190.00 56,130.00 5,052.48 18,146.48 32.329 37,983.52 135-55070-033-000 Independent Labor 1,464.00 1,464.00 125.00 8.538 1,339.00 Subtotal: 57,654.00 57,594.00 5,052.48 18,271.48 31.725 39,322.52 135-60005-033-000 Telephone 20,520.00 20,520.00 1,213.48 7,130.32 34.748 13,389.68 135-60010-033-000 Communications/Pagers/Mobiles 1,081.00 1,081.00 85.02 373.36 34.538 707.64 135-60035-033-000 Postage 100.00 100.00 1.73 1.730 98.27 135-60066-033-000 Publications/Books/Subscripts 63.00 138.00 65.88 65.88 47.739 72.12 135-60070-033-000 Dues & Memberships 177.00 177.00 99.97 56.480 77.03 135-60075-033-000 Meetings 75.00 75.00 75.00 135-60080-033-000 Schools & Training 1,738.00 1,663.00 187.50 586.50 35.268 1,076.50 135-60100-033-000 Travel & per diem 1,464.00 1,464.00 1,464.00 135-60235-033-000 Security 1,902.00 1,902.00 131.66 719.76 37.842 1,182.24 Subtotal: 27,120.00 27,120.00 1,683.54 8,977.52 33.103 18,142.48 135-65055-033-000 Hardware 36,682.00 36,682.00 596.79 7,599.16 20.716 29,082.84 135-65085-033-000 Office Supplies 300.00 300.00 49.00 126.80 42.267 173.20 135-65090-033-000 Printer Supplies & Maintenance 4,845.00 4,845.00 39.72 1,311.34 27.066 3,533.66 135-65105-033-000 Printing 100.00 100.00 100.00 Subtotal: 41,927.00 41,927.00 685.51 9,037.30 21.555 32,889.70 135-69170-033-000 Copier Lease Installments 3,450.00 3,450.00 273.29 1,093.16 31.686 2,356.84 135-69195-033-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 273.29 1,093.16 3.601 29,267.84 Program number: 234,346.00 234,346.00 13,659.67 67,297.50 28.717 167,048.50 . glbase_tbam rgonzale Trophy Club Entities Page 61 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 33 Information Systems Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Department number: Information Systems 234,346.00 234,346.00 13,659.67 67,297.50 28.717 167,048.50 . glbase_tbam rgonzale Trophy Club Entities Page 62 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 37 Facilities Maintenance Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55100-037-000 Building Maint & Supplies 11,400.00 6,595.00 118.48 1,307.32 19.823 5,287.68 135-55120-037-000 Cleaning Services 9,000.00 9,000.00 673.26 3,388.87 37.654 5,611.13 Subtotal: 20,400.00 15,595.00 791.74 4,696.19 30.113 10,898.81 135-60020-037-000 Electricity 19,900.00 19,900.00 1,594.90 6,086.39 30.585 13,813.61 135-60025-037-000 Water 1,030.00 1,030.00 34.20 157.06 15.249 872.94 135-60030-037-000 Rent And/Or Usage 13,182.00 13,182.00 1,098.51 5,492.55 41.667 7,689.45 135-60055-037-000 Insurance 29,601.00 34,406.00 34,404.71 99.996 1.29 Subtotal: 63,713.00 68,518.00 2,727.61 46,140.71 67.341 22,377.29 135-65095-037-000 Maintenance Supplies 2,000.00 2,000.00 373.51 776.25 38.813 1,223.75 135-65097-037-000 Vending Machine Supplies 1,000.00 1,000.00 180.55 392.96 39.296 607.04 Subtotal: 3,000.00 3,000.00 554.06 1,169.21 38.974 1,830.79 Program number: 87,113.00 87,113.00 4,073.41 52,006.11 59.700 35,106.89 Department number: Facilities Maintenance 87,113.00 87,113.00 4,073.41 52,006.11 59.700 35,106.89 . glbase_tbam rgonzale Trophy Club Entities Page 63 14:46 03/11/10 Budget Summary with Amendment Fund: 135 MUD 1 O&M CONSOLIDATED Department: 38 Utility Billing Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-038-000 Salaries & Wages 79,238.00 79,238.00 6,095.24 29,476.58 37.200 49,761.42 135-50010-038-000 Overtime 750.00 750.00 103.86 566.27 75.503 183.73 135-50016-038-000 Longevity 185.00 185.00 185.00 100.000 135-50020-038-000 Retirement 10,422.00 10,422.00 822.00 4,288.46 41.148 6,133.54 135-50026-038-000 Medical Insurance 10,675.00 10,675.00 889.56 4,447.80 41.666 6,227.20 135-50027-038-000 Dental Insurance 826.00 826.00 68.88 344.40 41.695 481.60 135-50028-038-000 Vision Insurance 133.00 133.00 11.08 55.40 41.654 77.60 135-50029-038-000 Life Insurance & Other 558.00 558.00 41.33 206.65 37.034 351.35 135-50030-038-000 Social Security Taxes 4,920.00 4,920.00 376.03 2,070.54 42.084 2,849.46 135-50035-038-000 Medicare Taxes 1,151.00 1,151.00 87.93 484.23 42.070 666.77 135-50040-038-000 Unemployment Taxes 135.00 135.00 31.00 61.40 45.481 73.60 135-50045-038-000 Workman's Compensation 212.00 212.00 121.36 57.245 90.64 Subtotal: 109,205.00 109,205.00 8,526.91 42,308.09 38.742 66,896.91 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 803.99 3,894.86 35.408 7,105.14 Subtotal: 11,800.00 11,800.00 803.99 3,894.86 33.007 7,905.14 135-60005-038-000 Telephone 75.00 75.00 11.03 35.52 47.360 39.48 135-60010-038-000 Communications/Pagers/Mobiles 420.00 420.00 32.08 160.18 38.138 259.82 135-60035-038-000 Postage 15,820.00 15,820.00 1,225.28 5,863.13 37.062 9,956.87 135-60040-038-000 Service Charges & Fees 15,000.00 15,000.00 993.50 4,769.47 31.796 10,230.53 135-60070-038-000 Dues & Memberships 71.00 71.00 71.00 135-60080-038-000 Schools & Training 800.00 800.00 800.00 135-60100-038-000 Travel & per diem 605.00 605.00 605.00 135-60130-038-000 Reg Assessment Fee (5%) 20,000.00 20,000.00 17,174.03 85.870 2,825.97 135-60245-038-000 Miscellaneous Expenses 200.00 200.00 .06 .030 199.94 Subtotal: 52,991.00 52,991.00 2,261.89 28,002.39 52.844 24,988.61 135-65085-038-000 Office Supplies 700.00 700.00 8.84 371.39 53.056 328.61 135-65105-038-000 Printing 4,500.00 4,500.00 4,500.00 Subtotal: 5,200.00 5,200.00 8.84 371.39 7.142 4,828.61 Program number: 179,196.00 179,196.00 11,601.63 74,576.73 41.617 104,619.27 Department number: Utility Billing 179,196.00 179,196.00 11,601.63 74,576.73 41.617 104,619.27 Expenditures Subtotal ----------- 4,669,934.00 4,669,934.00 225,339.13 1,380,666.97 29.565 3,289,267.03 Fund number: 135 MUD 1 O&M CONSOLIDATED 10,862.46- 36,972.35- 36,972.35 . glbase_tbam rgonzale Trophy Club Entities Page 74 14:46 03/11/10 Budget Summary with Amendment Fund: 315 MASTER DIST CIP FIRE STATION Department: Revenues Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 315-49010-000-000 Interest Income 206.98- 1,397.44- 1,397.44 Subtotal: 206.98- 1,397.44- 1,397.44 Program number: 206.98- 1,397.44- 1,397.44 Department number: Revenues 206.98- 1,397.44- 1,397.44 Revenues Subtotal ----------- 206.98- 1,397.44- 1,397.44 Fund number: 315 MASTER DIST CIP FIRE STATION 206.98- 1,397.44- 1,397.44 . glbase_tbam rgonzale Trophy Club Entities Page 91 14:46 03/11/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 703,310.00- 703,310.00- 50,475.10- 675,567.14- 96.055 27,742.86- 533-40015-000-000 Property Taxes/P & I 9,000.00- 9,000.00- 915.57- 2,569.95- 28.555 6,430.05- Subtotal: 712,310.00- 712,310.00- 51,390.67- 678,137.09- 95.203 34,172.91- 533-48005-000-000 Utility Fees 345,000.00- 345,000.00- 27,600.00- 140,300.00- 40.667 204,700.00- Subtotal: 345,000.00- 345,000.00- 27,600.00- 140,300.00- 40.667 204,700.00- 533-49010-000-000 Interest Income 2,000.00- 2,000.00- 113.90- 357.17- 17.859 1,642.83- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 310,000.00- 310,000.00- 308,113.90- 308,357.17- 99.470 1,642.83- Program number: 1,367,310.00- 1,367,310.00- 387,104.57- 1,126,794.26- 82.410 240,515.74- Department number: Revenues 1,367,310.00- 1,367,310.00- 387,104.57- 1,126,794.26- 82.410 240,515.74- Revenues Subtotal ----------- 1,367,310.00- 1,367,310.00- 387,104.57- 1,126,794.26- 82.410 240,515.74- . glbase_tbam rgonzale Trophy Club Entities Page 92 14:46 03/11/10 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 02/2010 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 4,000.00 533-70025-051-000 Bond Interest Expense 308,310.00 308,310.00 154,155.00 154,155.00 50.000 154,155.00 533-70035-051-000 Bond Principal Payment 1,055,000.00 1,055,000.00 1,055,000.00 Subtotal: 1,367,310.00 1,367,310.00 154,155.00 154,155.00 11.274 1,213,155.00 Program number: 1,367,310.00 1,367,310.00 154,155.00 154,155.00 11.274 1,213,155.00 Department number: Administration 1,367,310.00 1,367,310.00 154,155.00 154,155.00 11.274 1,213,155.00 Expenditures Subtotal ----------- 1,367,310.00 1,367,310.00 154,155.00 154,155.00 11.274 1,213,155.00