Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
June 2011 Budget Summary
Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 6/30/2011 ASSETS ASSETS CASH ON HAND 450 CASH IN BANK 753,303 INVESTMENTS 2,116,673 RESTRICTED ASSETS: INVESTMENTS 341,555 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 3,266 UTILITY AND OTHER ACCOUNTS RECEIVABLE 598,057 TOTAL ASSETS 3,813,305$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,266$ ACCOUNTS PAYABLE 441,734 CUSTOMER DEPOSITS 179,052 TOTAL LIABILITIES 624,052 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT 162,503 UNDESIGNATED FUND BALANCE 3,026,750 TOTAL FUND BALANCE 3,189,253 TOTAL LIABILITIES AND FUND BALANCE 3,813,305$ June 30, 2011 9/12 Months (75% of Fiscal Year) DescriptionYTD BudgetTotal BudgetMTD RevYTD RevYTD VarianceRemaining %[FUND] 180 : MUD 1 General Fund180-000-000-30100 : Property Taxes86,314.0086,314.00268.5486,324.04-10.04-0.01180-000-000-30125 : Property Taxes/Delinquent0.000.000.75747.88-747.880.00180-000-000-30150 : Property Taxes/Penalty & Interest0.000.0030.451,380.92-1,380.920.00180-000-000-35050 : Interest Income2,000.002,000.00332.294,404.48-2,404.48-120.22180-000-000-35150 : Cell Tower Lease Revenue10,164.0010,164.000.007,623.002,541.0025.00180-000-000-35170 : Building Rent7,000.007,000.00583.335,249.971,750.0325.00180-000-000-36100 : Gas Well Revenues2,000.002,000.000.00679.061,320.9466.05180-000-000-36400 : Auction Sales0.000.000.00202.12-202.120.00180-000-000-36500 : Vending Revenue850.00850.000.00463.00387.0045.53180-000-000-36700 : Miscellaneous Revenue14,500.0014,500.00150.009,211.105,288.9036.48180-000-000-36900 : Recovery of Prior Year Expense0.000.000.002,119.00-2,119.000.00180-000-000-38100 : Water - Residential1,709,811.001,709,811.00229,814.411,171,884.82537,926.1831.46180-000-000-38120 : Water - Commercial777,075.00777,075.0079,262.18492,238.22284,836.7836.66180-000-000-38130 : Water - PID195,249.00195,249.0030,603.92188,190.867,058.143.62180-000-000-38140 : Portable Meters - Out of District16,000.0016,000.001,258.8027,422.60-11,422.60-71.39180-000-000-38200 : Sewer - Residential1,098,146.001,098,146.00111,182.47800,071.20298,074.8027.14180-000-000-38220 : Sewer - Commercial300,403.00300,403.0034,570.79200,591.7099,811.3033.23180-000-000-38230 : Sewer - PID74,364.0074,364.0017,125.00110,078.49-35,714.49-48.03180-000-000-38240 : Sewer - Out of District10,000.0010,000.001,847.8311,742.75-1,742.75-17.43180-000-000-38250 : TCCC Effluent Charges47,500.0047,500.004,800.2528,958.3418,541.6639.04180-000-000-38300 : Standby0.000.0071.00541.60-541.600.00180-000-000-38320 : Penalties50,000.0050,000.004,181.4730,320.6919,679.3139.36180-000-000-38340 : Service Charges17,500.0017,500.00778.0011,483.426,016.5834.38180-000-000-38360 : Penalities - Out of District500.00500.000.00270.19229.8145.96180-000-000-38400 : Plumbing Inspections0.000.00100.001,550.00-1,550.000.00180-000-000-38420 : Sewer Inspections3,000.003,000.00300.004,650.00-1,650.00-55.00180-000-000-38500 : PID Utility Fees167,900.00167,900.0011,500.0011,500.00156,400.0093.15180-000-000-38540 : Sewer/Septic Dump Fees48,000.0048,000.000.000.0048,000.00100.00180-000-000-38560 : Fire Line Fees5,000.005,000.000.00525.004,475.0089.50180-000-000-38600 : Oversize Meter Reimbursements50,000.0050,000.007,884.0040,389.009,611.0019.22180-000-000-39290 : Transfer In - Future Replacement Rese54,314.0054,314.000.000.0054,314.00100.00 Grand Total : 4,747,590.004,747,590.00536,645.483,250,813.451,496,776.5531.53Trophy Club Municipal Utility Dist #1Budget Revenue ReportTo Date: 06/30/2011 180-010-000-40100 Salaries - Regular 165,718.00 165,718.00 12,232.32 97,919.25 67,798.75 59.1 180-010-000-40130 Salaries - Overtime 8,814.00 8,814.00 1,367.13 10,320.10 (1,506.10) 117.1 180-010-000-40140 Salaries - Longevity 2,150.00 2,150.00 0.00 2,150.00 0.00 100.0 180-010-000-40160 Salaries - Certification 1,500.00 1,500.00 150.00 1,280.00 220.00 85.3 180-010-000-41200 Retirement 24,945.00 24,945.00 1,946.93 15,845.76 9,099.24 63.5 180-010-000-41210 Medical Insurance 27,748.00 27,748.00 2,125.96 15,897.30 11,850.70 57.3 180-010-000-41215 Dental Insurance 1,446.00 1,446.00 127.44 934.02 511.98 64.6 180-010-000-41216 Vision Insurance 269.00 269.00 22.28 168.15 100.85 62.5 180-010-000-41218 Life Insurance & Other 1,177.00 1,177.00 0.00 301.92 875.08 25.7 180-010-000-42220 Social Security Taxes 10,994.00 10,994.00 801.66 6,615.96 4,378.04 60.2 180-010-000-42225 Medicare Taxes 2,571.00 2,571.00 187.49 1,547.28 1,023.72 60.2 180-010-000-42250 Unemployment Taxes 720.00 720.00 0.00 329.40 390.60 45.7 180-010-000-42260 Workman's Compensation 7,764.00 7,764.00 0.00 5,526.52 2,237.48 71.2 180-010-000-42290 Pre-employment Physicals/Testing 200.00 200.00 0.00 0.00 200.00 # 180-010-000-42960 Employee Relations 350.00 350.00 14.61 226.04 123.96 64.6 180-010-000-50500 Engineering 1,500.00 1,500.00 0.00 80.15 1,419.85 5.3 180-010-000-52400 Lab Analysis 3,850.00 3,850.00 0.00 1,908.00 1,942.00 49.6 180-010-000-57000 Independent Labor 500.00 500.00 0.00 0.00 500.00 # 180-010-000-58000 Bulk Water 1,410,000.00 1,410,000.00 110,137.50 763,458.47 646,541.53 54.1 180-010-000-60300 Postage 250.00 250.00 0.00 13.35 236.65 5.3 180-010-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-010-000-61000 Fuel 15,216.00 15,216.00 0.00 6,131.75 9,084.25 40.3 180-010-000-62100 Uniforms 3,690.00 3,690.00 0.00 1,882.87 1,807.13 51.0 180-010-000-62300 Chemicals 6,200.00 6,200.00 312.26 3,214.64 2,985.36 51.8 180-010-000-72100 Electricity 175,000.00 175,000.00 15,155.90 92,822.87 82,177.13 53.0 180-010-000-73200 Communications /Pagers/Mobiles 1,599.00 1,599.00 330.26 1,350.29 248.71 84.4 180-010-000-73350 Copies 50.00 50.00 0.00 0.00 50.00 # 180-010-000-73400 Printing 150.00 150.00 0.00 0.00 150.00 # 180-010-000-74100 Dues & Membership 150.00 150.00 0.00 61.00 89.00 40.7 180-010-000-74200 Travel & per diem 3,200.00 3,200.00 68.85 684.87 2,515.13 21.4 180-010-000-74300 Schools & Training 2,800.00 2,800.00 361.00 1,508.00 1,292.00 53.9 180-010-000-74700 Safety Program 500.00 500.00 0.00 7.17 492.83 1.4 180-010-000-75200 Annual Permit Fee 6,600.00 6,600.00 0.00 6,133.95 466.05 92.9 180-010-000-78100 Meter Expense 85,000.00 85,000.00 (850.00) 83,182.24 1,817.76 97.9 180-010-000-78200 Small Tools 2,500.00 2,500.00 24.11 284.87 2,215.13 11.4 180-010-000-78300 Safety Equipment 2,500.00 2,500.00 0.00 0.00 2,500.00 # 180-010-000-78500 Furniture/Equipment<$5,000 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-010-000-78600 Hardware 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-79150 Equipment Rental/Lease 500.00 500.00 0.00 770.00 (270.00) 154.0 page 1 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-010-000-79400 Bad Debt Expense 4,200.00 4,200.00 0.00 2,172.73 2,027.27 51.7 180-010-000-79999 Miscellaneous Expense 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-010-000-80250 Maintenance and Repairs 29,500.00 29,500.00 0.00 7,217.11 22,282.89 24.5 180-010-000-80300 Non-routine Maintenance 250.00 250.00 0.00 0.00 250.00 # 180-010-000-81100 Property Maintenance 4,200.00 4,200.00 0.00 702.85 3,497.15 16.7 180-010-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-010-000-81300 Vehicle Maintenance 3,380.00 3,380.00 47.00 2,182.50 1,197.50 64.6 180-010-000-81360 Maintenance - Backhoe/Skid Loader 2,900.00 2,900.00 0.00 0.00 2,900.00 # 180-010-000-81500 Lawn Maintenance 2,000.00 2,000.00 0.00 0.00 2,000.00 # 180-010-000-81900 Maintenance Supplies 32,000.00 32,000.00 1,148.02 8,128.51 23,871.49 25.4 180-010-000-91000 Capital Lease 11,490.00 11,490.00 0.00 0.00 11,490.00 # 180-010-000-93700 Capital Expenses 130,932.00 130,932.00 (38,100.00) 215,853.45 (84,921.45) 164.9 180-010-000-97000 Capital Repairs 9,000.00 9,000.00 0.00 0.00 9,000.00 # 180-010-000-97100 Capital Repairs - Ground Storage 124,771.00 124,771.00 0.00 97,741.64 27,029.36 78.3 180-010-000-99500 Transfer to Future Replacement Reserve 30,000.00 30,000.00 0.00 0.00 30,000.00 # Total Water 2,367,044.00 2,367,044.00 107,610.72 1,456,554.98 910,489.02 page 2 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-40100 Salaries - Regular 176,791.00 176,791.00 13,603.20 125,910.85 50,880.15 71.2 180-020-000-40130 Salaries - Overtime 10,166.00 10,166.00 1,490.09 10,046.20 119.80 98.8 180-020-000-40140 Salaries - Longevity 3,483.00 3,483.00 0.00 3,482.50 0.50 100.0 180-020-000-40160 Salaries - Certification 2,550.00 2,550.00 200.00 1,775.00 775.00 69.6 180-020-000-41200 Retirement 27,019.00 27,019.00 2,165.52 19,951.31 7,067.69 73.8 180-020-000-41210 Medical Insurance 37,298.00 37,298.00 2,785.32 25,068.09 12,229.91 67.2 180-020-000-41215 Dental Insurance 1,983.00 1,983.00 154.98 1,379.37 603.63 69.6 180-020-000-41216 Vision Insurance 341.00 341.00 29.76 267.84 73.16 78.5 180-020-000-41218 Life Insurance & Other 1,237.00 1,237.00 0.00 415.01 821.99 33.5 180-020-000-42220 Social Security Taxes 10,504.00 10,504.00 805.15 7,639.77 2,864.23 72.7 180-020-000-42225 Medicare Taxes 2,457.00 2,457.00 188.31 1,786.72 670.28 72.7 180-020-000-42250 Unemployment Taxes 720.00 720.00 0.00 434.45 285.55 60.3 180-020-000-42260 Workman's Compensation 8,410.00 8,410.00 0.00 5,986.36 2,423.64 71.2 180-020-000-42960 Employee Relations 250.00 250.00 0.00 151.88 98.12 60.8 180-020-000-50500 Engineering 4,000.00 4,000.00 0.00 2,800.00 1,200.00 70.0 180-020-000-52400 Lab Analysis 18,750.00 18,750.00 1,168.75 9,978.75 8,771.25 53.2 180-020-000-57000 Independent Labor 750.00 750.00 0.00 0.00 750.00 # 180-020-000-60100 Office Supplies 400.00 400.00 0.00 7.24 392.76 1.8 180-020-000-60300 Postage 120.00 120.00 0.00 0.00 120.00 # 180-020-000-60400 Publications/Books/Subscriptions 500.00 500.00 0.00 0.00 500.00 # 180-020-000-61000 Fuel 6,875.00 6,875.00 0.00 1,620.27 5,254.73 23.6 180-020-000-62100 Uniforms 2,205.00 2,205.00 0.00 1,449.17 755.83 65.7 180-020-000-62300 Chemicals 13,000.00 13,000.00 149.11 4,028.28 8,971.72 31.0 180-020-000-62800 Lab Supplies 6,085.00 6,085.00 426.57 3,559.06 2,525.94 58.5 180-020-000-62900 Other Consumables 110.00 110.00 50.14 50.14 59.86 45.6 180-020-000-72100 Electricity 205,000.00 205,000.00 17,299.79 148,595.10 56,404.90 72.5 180-020-000-72200 Water 1,900.00 1,900.00 48.82 1,240.02 659.98 65.3 180-020-000-72400 Dumpster Services 35,000.00 35,000.00 1,664.75 11,319.25 23,680.75 32.3 180-020-000-73100 Telephone 0.00 10.00 0.88 1.36 8.64 13.6 180-020-000-73200 Communications /Pagers/Mobiles 3,000.00 3,000.00 479.92 2,605.90 394.10 86.9 180-020-000-74200 Travel & per diem 1,750.00 1,750.00 197.37 1,701.81 48.19 97.2 180-020-000-74300 Schools & Training 1,320.00 1,320.00 0.00 900.00 420.00 68.2 180-020-000-74700 Safety Program 200.00 200.00 0.00 7.18 192.82 3.6 180-020-000-75200 Annual Permit Fee 7,500.00 7,500.00 1,256.64 10,704.14 (3,204.14) 142.7 180-020-000-78200 Small Tools 1,260.00 1,260.00 0.00 481.71 778.29 38.2 180-020-000-78300 Safety Equipment 540.00 540.00 27.95 658.23 (118.23) 121.9 180-020-000-78600 Hardware 525.00 525.00 35.81 35.81 489.19 6.8 180-020-000-79150 Equipment Rental/Lease 200.00 200.00 0.00 0.00 200.00 # 180-020-000-79999 Miscellaneous Expense 525.00 515.00 0.00 0.00 515.00 # 180-020-000-80250 Maintenance and Repairs 17,750.00 17,750.00 15.33 11,439.01 6,310.99 64.4 page 3 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-020-000-81200 Building Maintenance 1,400.00 1,400.00 0.00 0.00 1,400.00 # 180-020-000-81300 Vehicle Maintenance 4,998.00 4,998.00 0.00 1,049.74 3,948.26 21.0 180-020-000-81360 Maintenance - Backhoe/Skid Loader 2,950.00 2,950.00 0.00 1,126.76 1,823.24 38.2 180-020-000-81500 Lawn Maintenance 525.00 525.00 (36.15) 95.90 429.10 18.3 180-020-000-81900 Maintenance Supplies 5,860.00 5,860.00 123.90 761.82 5,098.18 13.0 180-020-000-93700 Capital Expenses 136,189.00 136,189.00 0.00 5,861.00 130,328.00 4.3 180-020-000-97000 Capital Repairs 35,000.00 35,000.00 0.00 1,500.00 33,500.00 4.3 Total Wastewater 799,396.00 799,396.00 44,331.91 427,873.00 371,523.00 page 4 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-021-000-40100 Salaries - Regular 136,341.00 136,341.00 10,518.72 97,218.24 39,122.76 71.3 180-021-000-40130 Salaries - Overtime 14,145.00 14,145.00 966.42 13,119.78 1,025.22 92.8 180-021-000-40140 Salaries - Longevity 3,128.00 3,128.00 0.00 3,160.00 (32.00) 101.0 180-021-000-40160 Salaries - Certification 1,200.00 1,200.00 125.00 1,125.00 75.00 93.7 180-021-000-41200 Retirement 21,674.00 21,674.00 1,644.00 16,172.60 5,501.40 74.6 180-021-000-41210 Medical Insurance 28,228.00 28,228.00 1,978.38 16,893.19 11,334.81 59.8 180-021-000-41215 Dental Insurance 1,426.00 1,426.00 118.88 1,010.81 415.19 70.9 180-021-000-41216 Vision Insurance 253.00 253.00 19.86 170.70 82.30 67.5 180-021-000-41218 Life Insurance & Other 942.00 942.00 0.00 316.23 625.77 33.6 180-021-000-42220 Social Security Taxes 8,769.00 8,769.00 636.68 6,590.74 2,178.26 75.2 180-021-000-42225 Medicare Taxes 2,051.00 2,051.00 148.90 1,543.89 507.11 75.3 180-021-000-42250 Unemployment Taxes 540.00 540.00 0.00 333.23 206.77 61.7 180-021-000-42260 Workman's Compensation 4,412.00 4,412.00 0.00 3,140.52 1,271.48 71.2 180-021-000-42960 Employee Relations 250.00 250.00 0.00 191.59 58.41 76.6 180-021-000-50500 Engineering 1,500.00 1,500.00 0.00 80.14 1,419.86 5.3 180-021-000-57000 Independent Labor 200.00 200.00 0.00 0.00 200.00 # 180-021-000-60300 Postage 150.00 150.00 0.00 0.00 150.00 # 180-021-000-61000 Fuel 11,700.00 11,700.00 0.00 5,928.03 5,771.97 50.7 180-021-000-62100 Uniforms 2,505.00 2,505.00 0.00 860.75 1,644.25 34.4 180-021-000-62300 Chemicals 12,500.00 12,500.00 0.00 0.00 12,500.00 # 180-021-000-72100 Electricity 23,625.00 23,625.00 1,568.18 13,556.89 10,068.11 57.4 180-021-000-72200 Water 750.00 750.00 0.00 0.00 750.00 # 180-021-000-73100 Telephone 0.00 0.00 16.40 20.58 (20.58) # 180-021-000-73200 Communications /Pagers/Mobiles 2,796.00 2,796.00 409.91 2,129.28 666.72 76.2 180-021-000-74100 Dues & Membership 255.00 255.00 0.00 0.00 255.00 # 180-021-000-74200 Travel & per diem 1,500.00 1,500.00 20.91 551.26 948.74 36.8 180-021-000-74300 Schools & Training 2,818.00 2,818.00 0.00 55.00 2,763.00 2.0 180-021-000-74700 Safety Program 750.00 750.00 0.00 7.18 742.82 1.0 180-021-000-78200 Small Tools 1,500.00 1,500.00 0.00 220.58 1,279.42 14.7 180-021-000-78300 Safety Equipment 1,150.00 1,150.00 0.00 62.84 1,087.16 5.5 180-021-000-78600 Hardware 750.00 750.00 0.00 0.00 750.00 # 180-021-000-79150 Equipment Rental/Lease 44,107.00 44,107.00 0.00 0.00 44,107.00 # 180-021-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # 180-021-000-80250 Maintenance and Repairs 23,700.00 23,700.00 0.00 4,158.72 19,541.28 17.5 180-021-000-81100 Property Maintenance 1,000.00 1,000.00 0.00 0.00 1,000.00 # 180-021-000-81200 Building Maintenance 750.00 750.00 0.00 0.00 750.00 # 180-021-000-81300 Vehicle Maintenance 8,143.00 8,143.00 0.00 641.37 7,501.63 7.9 180-021-000-81900 Maintenance Supplies 16,050.00 16,050.00 0.00 2,050.63 13,999.37 12.8 180-021-000-93700 Capital Expenses 15,000.00 15,000.00 0.00 0.00 15,000.00 # 180-021-000-97000 Capital Repairs 20,000.00 20,000.00 0.00 0.00 20,000.00 # page 5 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Total Collection 416,658.00 416,658.00 18,172.24 191,309.77 225,348.23 page 6 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-130-000-40100 Salaries - Regular 10,000.00 10,000.00 400.00 4,200.00 5,800.00 42.0 180-130-000-42220 Social Security Taxes 620.00 620.00 24.80 260.40 359.60 42.0 180-130-000-42225 Medicare Taxes 145.00 145.00 5.80 60.90 84.10 42.0 180-130-000-42250 Unemployment Taxes 210.00 210.00 3.20 57.00 153.00 27.1 180-130-000-42260 Workman's Compensation 120.00 120.00 0.00 85.41 34.59 71.2 180-130-000-60100 Office Supplies 50.00 50.00 0.00 0.00 50.00 # 180-130-000-60300 Postage 0.00 0.00 0.00 (1.86) 1.86 # 180-130-000-60400 Publications/Books/Subscriptions 50.00 50.00 0.00 0.00 50.00 # 180-130-000-74100 Dues & Membership 2,100.00 2,100.00 0.00 79.00 2,021.00 3.8 180-130-000-74200 Travel & per diem 5,805.00 5,805.00 85.79 759.02 5,045.98 13.1 180-130-000-74300 Schools & Training 4,000.00 4,000.00 345.00 2,140.00 1,860.00 53.5 180-130-000-74600 Meetings 1,278.00 1,278.00 22.00 289.00 989.00 22.6 180-130-000-79999 Miscellaneous Expense 150.00 150.00 0.00 0.00 150.00 # 180-130-000-87110 Water Conservation Program/Public Information 0.00 0.00 0.00 2,334.72 (2,334.72) # Total Board of Directors 24,528.00 24,528.00 886.59 10,263.59 14,264.41 page 7 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-140-000-40100 Salaries - Regular 214,374.00 214,374.00 16,211.28 147,725.00 66,649.00 68.9 180-140-000-40130 Salaries - Overtime 500.00 500.00 39.94 221.48 278.52 44.3 180-140-000-40140 Salaries - Longevity 2,580.00 2,580.00 0.00 2,755.00 (175.00) 106.8 180-140-000-41200 Retirement 30,360.00 30,360.00 1,969.25 20,837.38 9,522.62 68.6 180-140-000-41210 Medical Insurance 17,925.00 17,925.00 866.08 13,115.17 4,809.83 73.2 180-140-000-41215 Dental Insurance 930.00 930.00 51.64 744.65 185.35 80.1 180-140-000-41216 Vision Insurance 179.00 179.00 9.96 138.00 41.00 77.1 180-140-000-41218 Life Insurance & Other 1,205.00 1,205.00 0.00 373.34 831.66 31.0 180-140-000-42220 Social Security Taxes 13,474.00 13,474.00 1,003.70 9,333.77 4,140.23 69.3 180-140-000-42225 Medicare Taxes 3,151.00 3,151.00 234.73 2,206.59 944.41 70.0 180-140-000-42250 Unemployment Taxes 630.00 630.00 18.74 428.58 201.42 68.0 180-140-000-42260 Workman's Compensation 783.00 783.00 0.00 557.34 225.66 71.2 180-140-000-42290 Pre-employment Physicals/Testing 0.00 0.00 0.00 52.45 (52.45) # 180-140-000-42960 Employee Relations 1,000.00 1,000.00 319.22 906.17 93.83 90.6 180-140-000-50100 Professional Outside Services 229,076.00 229,076.00 0.00 228,075.63 1,000.37 99.6 180-140-000-52100 Elections 2,500.00 2,500.00 (87.07) 1,952.65 547.35 78.1 180-140-000-54200 Records Management 500.00 500.00 0.00 120.00 380.00 24.0 180-140-000-57000 Independent Labor 840.00 840.00 0.00 322.50 517.50 38.4 180-140-000-60100 Office Supplies 2,450.00 2,450.00 0.00 1,232.55 1,217.45 50.3 180-140-000-60300 Postage 1,571.00 1,571.00 361.60 1,336.15 234.85 85.1 180-140-000-60400 Publications/Books/Subscriptions 450.00 450.00 0.00 215.40 234.60 47.9 180-140-000-73100 Telephone 200.00 200.00 42.80 180.25 19.75 90.1 180-140-000-73200 Communications /Pagers/Mobiles 1,798.00 1,798.00 332.99 2,169.10 (371.10) 120.6 180-140-000-73300 Advertising 1,500.00 1,500.00 0.00 0.00 1,500.00 # 180-140-000-73400 Printing 515.00 515.00 0.00 3,170.00 (2,655.00) 615.5 180-140-000-73600 Service Charges & Fees 0.00 0.00 0.00 32.50 (32.50) # 180-140-000-74100 Dues & Membership 1,612.00 1,612.00 0.00 1,714.50 (102.50) 106.4 180-140-000-74200 Travel & per diem 3,088.00 3,088.00 0.00 1,201.01 1,886.99 38.9 180-140-000-74300 Schools & Training 2,555.00 2,555.00 463.93 1,640.93 914.07 64.2 180-140-000-74600 Meetings 312.00 312.00 22.00 116.00 196.00 37.2 180-140-000-76700 July 4 Celebration 10,000.00 10,000.00 0.00 0.00 10,000.00 # 180-140-000-78500 Furniture/Equipment<$5,000 1,750.00 1,750.00 0.00 675.73 1,074.27 38.6 180-140-000-79999 Miscellaneous Expense 100.00 100.00 0.00 0.00 100.00 # Total Managers Office 547,908.00 547,908.00 21,860.79 443,549.82 104,358.18 page 8 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-611-000-40100 Salaries - Regular 70,839.00 70,839.00 5,518.74 49,472.36 21,366.64 69.8 180-611-000-40130 Salaries - Overtime 3,500.00 3,500.00 434.27 10,994.94 (7,494.94) 314.1 180-611-000-40140 Salaries - Longevity 1,710.00 1,710.00 0.00 1,710.00 0.00 100.0 180-611-000-41200 Retirement 10,647.00 10,647.00 842.95 8,885.70 1,761.30 83.5 180-611-000-41210 Medical Insurance 8,583.00 8,583.00 715.24 6,249.19 2,333.81 72.8 180-611-000-41215 Dental Insurance 393.00 393.00 43.06 366.66 26.34 93.3 180-611-000-41216 Vision Insurance 75.00 75.00 4.98 44.82 30.18 59.8 180-611-000-41218 Life Insurance & Other 424.00 424.00 0.00 140.01 283.99 33.0 180-611-000-42220 Social Security Taxes 4,697.00 4,697.00 308.63 3,463.99 1,233.01 73.7 180-611-000-42225 Medicare Taxes 1,099.00 1,099.00 72.18 810.13 288.87 73.7 180-611-000-42250 Unemployment Taxes 180.00 180.00 0.00 129.59 50.41 72.0 180-611-000-42260 Workman's Compensation 274.00 274.00 0.00 195.03 78.97 71.2 180-611-000-50100 Professional Outside Services 5,000.00 5,000.00 0.00 2,437.50 2,562.50 48.7 180-611-000-60100 Office Supplies 600.00 600.00 0.00 481.49 118.51 80.2 180-611-000-60300 Postage 500.00 500.00 26.16 306.75 193.25 61.4 180-611-000-60400 Publications/Books/Subscriptions 250.00 250.00 0.00 0.00 250.00 # 180-611-000-73100 Telephone 100.00 100.00 2.09 11.59 88.41 11.6 180-611-000-73200 Communications /Pagers/Mobiles 670.00 670.00 105.66 508.17 161.83 75.8 180-611-000-73300 Advertising 500.00 500.00 0.00 207.40 292.60 41.5 180-611-000-73400 Printing 500.00 500.00 0.00 0.00 500.00 # 180-611-000-73600 Service Charges & Fees 77.00 77.00 0.00 0.00 77.00 # 180-611-000-74100 Dues & Membership 413.00 413.00 0.00 22.00 391.00 5.3 180-611-000-74200 Travel & per diem 1,547.00 1,547.00 43.14 145.13 1,401.87 9.4 180-611-000-74300 Schools & Training 1,040.00 1,040.00 0.00 309.00 731.00 29.7 180-611-000-74600 Meetings 88.00 88.00 0.00 0.00 88.00 # Total Finance 113,706.00 113,706.00 8,117.10 86,891.45 26,814.55 page 9 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-620-000-40100 Salaries - Regular 112,537.00 112,537.00 4,998.09 64,615.50 47,921.50 57.4 180-620-000-40130 Salaries - Overtime 1,500.00 1,500.00 40.50 611.44 888.56 40.8 180-620-000-40140 Salaries - Longevity 245.00 245.00 0.00 405.00 (160.00) 165.3 180-620-000-41200 Retirement 15,999.00 15,999.00 713.46 8,787.96 7,211.04 54.9 180-620-000-41210 Medical Insurance 21,773.00 21,773.00 1,150.48 12,380.14 9,392.86 56.9 180-620-000-41215 Dental Insurance 1,136.00 1,136.00 79.16 810.70 325.30 71.4 180-620-000-41216 Vision Insurance 209.00 209.00 13.54 143.40 65.60 68.6 180-620-000-41218 Life Insurance & Other 800.00 800.00 0.00 249.23 550.77 31.2 180-620-000-42220 Social Security Taxes 7,029.00 7,029.00 274.73 3,913.86 3,115.14 55.7 180-620-000-42225 Medicare Taxes 1,644.00 1,644.00 64.26 915.34 728.66 55.7 180-620-000-42250 Unemployment Taxes 540.00 540.00 5.37 384.48 155.52 71.2 180-620-000-42260 Workman's Compensation 411.00 411.00 0.00 292.56 118.44 71.2 180-620-000-56200 Utility Billing Contract 11,000.00 11,000.00 879.19 7,786.84 3,213.16 70.8 180-620-000-57000 Independent Labor 800.00 800.00 0.00 0.00 800.00 # 180-620-000-60100 Office Supplies 700.00 700.00 14.00 184.09 515.91 26.3 180-620-000-60300 Postage 18,000.00 18,000.00 1,357.11 11,788.80 6,211.20 65.5 180-620-000-73100 Telephone 100.00 100.00 20.80 95.35 4.65 95.4 180-620-000-73200 Communications /Pagers/Mobiles 472.00 472.00 74.72 373.03 98.97 79.0 180-620-000-73400 Printing 3,000.00 3,000.00 2,152.00 2,152.00 848.00 71.7 180-620-000-73600 Service Charges & Fees 18,000.00 18,000.00 1,969.65 16,180.32 1,819.68 89.9 180-620-000-74100 Dues & Membership 71.00 71.00 0.00 0.00 71.00 # 180-620-000-74200 Travel & per diem 605.00 605.00 0.00 30.09 574.91 5.0 180-620-000-74300 Schools & Training 800.00 800.00 0.00 0.00 800.00 # 180-620-000-75600 TCEQ Annual Assessment Fee 20,000.00 20,000.00 0.00 19,248.17 751.83 96.2 180-620-000-79999 Miscellaneous Expense 200.00 200.00 0.00 1.84 198.16 0.9 Total Utility Billing 237,571.00 237,571.00 13,807.06 151,350.14 86,220.86 page 10 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-630-000-42290 Pre-employment Physicals/Testing 1,260.00 1,260.00 0.00 152.41 1,107.59 12.1 180-630-000-42960 Employee Relations 1,788.00 1,788.00 176.49 474.97 1,313.03 26.6 180-630-000-43240 Tuition Reimbursement 1,530.00 1,530.00 0.00 74.65 1,455.35 4.9 180-630-000-60100 Office Supplies 424.00 424.00 0.00 0.00 424.00 # 180-630-000-60300 Postage 104.00 104.00 0.00 0.00 104.00 # 180-630-000-60400 Publications/Books/Subscriptions 462.00 462.00 0.00 0.00 462.00 # 180-630-000-73100 Telephone 27.00 27.00 0.00 0.00 27.00 # 180-630-000-73400 Printing 113.00 113.00 0.00 0.00 113.00 # 180-630-000-74100 Dues & Membership 529.00 529.00 0.00 0.00 529.00 # 180-630-000-74200 Travel & per diem 8.00 8.00 0.00 0.00 8.00 # 180-630-000-74300 Schools & Training 566.00 566.00 0.00 0.00 566.00 # 180-630-000-74600 Meetings 134.00 134.00 0.00 0.00 134.00 # Total Human Resources 6,945.00 6,945.00 176.49 702.03 6,242.97 page 11 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-640-000-50700 Security 1,350.00 1,350.00 0.00 42.51 1,307.49 3.1 180-640-000-55000 Software & Support 50,453.00 50,453.00 1,969.20 39,539.17 10,913.83 78.4 180-640-000-57000 Independent Labor 1,464.00 1,464.00 0.00 2,348.75 (884.75) 160.4 180-640-000-60100 Office Supplies 371.00 371.00 0.00 244.61 126.39 65.9 180-640-000-60200 Printer Supplies 5,732.00 5,732.00 1,094.56 4,788.46 943.54 83.5 180-640-000-73100 Telephone 8,040.00 8,040.00 888.00 7,975.77 64.23 99.2 180-640-000-74200 Travel & per diem 0.00 0.00 0.00 16.18 (16.18) # 180-640-000-75900 Prompt Payment Interest 0.00 0.00 0.00 14.53 (14.53) # 180-640-000-78600 Hardware 60,152.00 60,152.00 5,516.48 36,641.27 23,510.73 60.9 180-640-000-79100 Copier Rental/Lease 3,450.00 3,450.00 273.29 2,186.32 1,263.68 63.4 180-640-000-99500 Transfer to Future Replacement Reserve 26,911.00 26,911.00 0.00 0.00 26,911.00 # Total Information Services 157,923.00 157,923.00 9,741.53 93,797.57 64,125.43 page 12 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-710-000-52400 Lab Analysis 0.00 0.00 0.00 1,168.75 (1,168.75) # 180-710-000-62520 Vending Machine Supplies 1,000.00 1,000.00 0.00 429.28 570.72 42.9 180-710-000-72100 Electricity 20,895.00 20,895.00 1,115.43 9,649.48 11,245.52 46.2 180-710-000-72200 Water 1,061.00 1,061.00 64.97 479.29 581.71 45.2 180-710-000-75000 Insurance 31,081.00 31,081.00 250.00 23,475.81 7,605.19 75.5 180-710-000-79200 Building Rental/Lease 13,182.00 13,182.00 1,098.51 9,886.59 3,295.41 75.0 180-710-000-81200 Building Maintenance 11,970.00 11,970.00 985.65 13,334.94 (1,364.94) 111.4 180-710-000-81600 Cleaning Services 9,450.00 9,450.00 707.85 6,303.95 3,146.05 66.7 180-710-000-81900 Maintenance Supplies 2,100.00 2,100.00 83.54 1,464.78 635.22 69.8 Total Facilities Maintenance 90,739.00 90,739.00 4,305.95 66,192.87 24,546.13 page 13 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 180-810-000-50200 Auditing 27,500.00 27,500.00 0.00 27,500.00 0.00 100.0 180-810-000-50300 Legal 35,000.00 35,000.00 649.00 27,933.31 7,066.69 79.8 180-810-000-51100 Appraisal 20,211.00 20,211.00 2,931.93 12,332.41 7,878.59 61.0 180-810-000-51150 Tax Administration 3,603.00 3,603.00 0.00 2,640.32 962.68 73.3 Total Non Departmental 86,314.00 86,314.00 3,580.93 70,406.04 15,907.96 Total Expenses 4,848,732.00 4,848,732.00 232,591.31 2,998,891.26 1,849,840.74 page 14 Budget to Actual - Fund 180 Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 380-010-000-93700 Capital Expenses 0.00 0.00 52,862.31 112,162.31 (112,162.31) # 380-020-000-93700 Capital Expenses 0.00 0.00 750.00 58,220.60 (58,220.60) # Total Capital Projects 0.00 0.00 53,612.31 170,382.91 (170,382.91) page 1 Budget to Actual - Capital Pro Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Municipal Utility District No 1 - I & S Interim Balance Sheet Balance @ 6/30/2011 ASSETS ASSETS CASH AND CASH IN BANK 48,300$ INVESTMENTS 1,336,934 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 25,563 TOTAL ASSETS 1,410,797$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 2,300$ DEFERRED REVENUE 25,563$ TOTAL LIABILITIES 27,863 FUND BALANCE DESIGNATED FOR DEBT SERVICE 1,382,934 TOTAL LIABILITIES AND FUND BALANCE 1,410,797$ June 30, 2011 9/12 Months 75% of Fiscal Year) DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 680 : Debt Service680-000-000-30100 : Property Taxes755,712.00755,712.002,351.17755,489.15222.850.03680-000-000-30125 : Property Taxes/Delinquent0.000.004.774,271.82-4,271.820.00680-000-000-30150 : Property Taxes/Penalty & Interes9,500.009,500.00265.743,628.965,871.0461.80680-000-000-35050 : Interest Income500.00500.0084.22820.21-320.21-64.04680-000-000-35170 : Building Rent308,000.00308,000.000.00308,000.000.000.00680-000-000-38500 : PID Utility Fees246,100.00246,100.0046,000.00246,100.000.000.00 Grand Total : 1,319,812.001,319,812.0048,705.901,318,310.141,501.860.11Trophy Club Municipal Utility Dist #1 Debt ServiceBudget Revenue Report6/30/2011 680-680-000-89000 Bond Principal 1,115,000.00 1,115,000.00 0.00 0.00 1,115,000.00 # 680-680-000-89100 Bond Interest 379,559.00 379,559.00 0.00 206,598.55 172,960.45 54.4 680-680-000-89200 Paying Agent Fees 3,500.00 3,500.00 300.00 910.00 2,590.00 26.0 Total Debt Service 1,498,059.00 1,498,059.00 300.00 207,508.55 1,290,550.45 page 1 Budget to Actual -Debt Service Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 6/30/2011 ASSETS ASSETS CASH IN BANK 10,000$ INVESTMENTS 512,425 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 28,710 ACCOUNTS RECEIVABLE - PID EMERGENCY SERVICES ASSESSMENTS 9,375 OTHER RECEIVABLES 18,855 TOTAL ASSETS 579,365$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 38,085$ ACCOUNTS PAYABLE 29,606 TOTAL LIABILITIES 67,691 FUND BALANCE UNDESIGNATED FUND BALANCE 511,674 TOTAL LIABILITIES AND FUND BALANCE 579,365$ June 30, 2011 9/12 Months (75% of Fiscal Year) DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 190 : Fire Department Operations190-000-000-30050 : Emergency Service Assessment111,648.00111,648.00719.16115,616.07-3,968.07-3.55190-000-000-30060 : Emergency Services Assessment - Penalty & Inter0.000.00105.771,024.47-1,024.470.00190-000-000-30100 : Property Taxes1,072,786.001,072,786.003,337.671,068,471.684,314.320.40190-000-000-30125 : Property Taxes/Delinquent0.000.005.878,603.50-8,603.500.00190-000-000-30150 : Property Taxes/Penalty & Interest7,500.007,500.00376.964,609.092,890.9138.55190-000-000-32014 : Fire Permits/Sprinkler0.000.000.001,200.00-1,200.000.00190-000-000-33050 : Fire Inspections0.000.000.00150.00-150.000.00190-000-000-33420 : Denton/Tarrant County - Fire13,750.0013,750.000.0010,000.003,750.0027.27190-000-000-35050 : Interest Income0.000.000.0075.00-75.000.00190-000-000-36700 : Miscellaneous Revenue2,500.002,500.000.001,050.001,450.0058.00 Grand Total : 1,208,184.001,208,184.004,545.431,210,799.81-2,615.81-0.22Trophy Club Municipal Utility Dist #1 Fire Dept.Budget Revenue ReportTo Date: 06/30/2011 190-045-000-40100 Salaries - Regular 390,466.00 390,466.00 30,444.93 280,833.30 109,632.70 71.9 190-045-000-40130 Salaries - Overtime 40,298.00 40,298.00 4,135.72 38,862.46 1,435.54 96.4 190-045-000-40140 Salaries - Longevity 2,946.00 2,946.00 0.00 2,986.99 (40.99) 101.4 190-045-000-40160 Salaries - Certification 5,401.00 5,401.00 494.70 6,088.24 (687.24) 112.7 190-045-000-40180 Salaries - Holiday Pay 11,604.00 11,604.00 0.00 12,154.86 (550.86) 104.7 190-045-000-41200 Retirement 63,016.00 63,016.00 4,634.89 46,744.53 16,271.47 74.2 190-045-000-41210 Medical Insurance 54,809.00 54,809.00 3,838.70 36,140.68 18,668.32 65.9 190-045-000-41215 Dental Insurance 2,819.00 2,819.00 235.10 2,202.32 616.68 78.1 190-045-000-41216 Vision Insurance 505.00 505.00 37.80 355.84 149.16 70.5 190-045-000-41218 Life Insurance & Other 2,491.00 2,491.00 0.00 843.63 1,647.37 33.9 190-045-000-42220 Social Security Taxes 26,252.00 26,252.00 1,987.43 19,755.52 6,496.48 75.3 190-045-000-42225 Medicare Taxes 6,140.00 6,140.00 464.79 4,623.29 1,516.71 75.3 190-045-000-42250 Unemployment Taxes 1,387.00 1,387.00 18.54 920.97 466.03 66.4 190-045-000-42260 Workman's Compensation 13,134.00 13,134.00 0.00 9,348.96 3,785.04 71.2 190-045-000-42290 Pre-employment Physicals/Testing 675.00 675.00 0.00 195.50 479.50 29.0 190-045-000-50100 Professional Outside Services 40,000.00 40,000.00 0.00 0.00 40,000.00 # 190-045-000-54100 Physicals/Testing 1,880.00 1,880.00 0.00 0.00 1,880.00 # 190-045-000-60100 Office Supplies 319.00 319.00 0.00 215.63 103.37 67.6 190-045-000-60300 Postage 95.00 95.00 0.88 92.26 2.74 97.1 190-045-000-60400 Publications/Books/Subscriptions 382.00 382.00 0.00 0.00 382.00 # 190-045-000-61000 Fuel 16,585.00 16,585.00 0.00 7,011.52 9,573.48 42.3 190-045-000-62100 Uniforms 4,357.00 4,357.00 0.00 3,530.32 826.68 81.0 190-045-000-62150 Protective Clothing 7,600.00 7,600.00 319.00 756.18 6,843.82 9.9 190-045-000-62300 Chemicals 1,545.00 1,545.00 0.00 305.00 1,240.00 19.7 190-045-000-72100 Electricity 17,400.00 17,400.00 1,127.29 7,845.25 9,554.75 45.1 190-045-000-72200 Water 3,193.00 3,193.00 25.42 401.41 2,791.59 12.6 190-045-000-73100 Telephone 103.00 103.00 18.41 114.25 (11.25) 110.9 190-045-000-73200 Communications /Pagers/Mobiles 1,874.00 1,874.00 363.14 2,014.64 (140.64) 107.5 190-045-000-73300 Advertising 153.00 153.00 0.00 0.00 153.00 # 190-045-000-73400 Printing 103.00 103.00 0.00 0.00 103.00 # 190-045-000-74100 Dues & Membership 8,358.00 8,358.00 0.00 6,466.60 1,891.40 77.4 190-045-000-74200 Travel & per diem 7,107.00 7,107.00 14.80 3,531.41 3,575.59 49.7 190-045-000-74300 Schools & Training 6,615.00 6,615.00 35.00 3,316.95 3,298.05 50.1 190-045-000-74400 Emergency Management 1,000.00 1,000.00 0.00 1,000.00 0.00 100.0 190-045-000-74600 Meetings 0.00 0.00 0.00 22.00 (22.00) # 190-045-000-75000 Insurance 19,975.00 19,975.00 0.00 8,714.00 11,261.00 43.6 190-045-000-77300 Fire Inspections/Enforcement 1,000.00 1,000.00 0.00 205.12 794.88 20.5 page 1 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % 190-045-000-78200 Small Tools 8,127.00 8,127.00 952.21 4,564.53 3,562.47 56.2 190-045-000-79200 Building Rental/Lease 308,000.00 308,000.00 0.00 308,000.00 0.00 100.0 190-045-000-79999 Miscellaneous Expense 1,213.00 1,213.00 66.78 205.76 1,007.24 17.0 190-045-000-80250 Maintenance and Repairs 5,562.00 5,562.00 0.00 1,952.28 3,609.72 35.1 190-045-000-81200 Building Maintenance 11,000.00 11,000.00 3,066.92 6,804.64 4,195.36 61.9 190-045-000-81300 Vehicle Maintenance 13,500.00 13,500.00 168.09 8,458.68 5,041.32 62.7 190-045-000-81350 Equipment Maintenance 3,675.00 3,675.00 167.00 521.71 3,153.29 14.2 190-045-000-81400 Radio Maintenance 1,050.00 1,050.00 0.00 465.00 585.00 44.3 190-045-000-81800 Flags & Repairs 2,422.00 2,422.00 905.00 1,972.50 449.50 81.4 190-045-000-81900 Maintenance Supplies 2,652.00 2,652.00 49.57 925.60 1,726.40 34.9 190-045-000-85000 Grant Match 3,000.00 3,000.00 0.00 1,308.60 1,691.40 43.6 190-045-000-87100 Programs & Special Projects 4,080.00 4,080.00 0.00 882.85 3,197.15 21.6 190-045-000-90100 Radios 2,500.00 2,500.00 0.00 807.50 1,692.50 32.3 190-045-000-90200 Fire Engine 681 Payment 73,388.00 73,388.00 0.00 5,693.95 67,694.05 7.8 190-045-000-93200 Vehicles 4,183.00 4,183.00 0.00 4,164.55 18.45 99.6 190-045-000-93600 Airpacks 2,245.00 2,245.00 0.00 0.00 2,245.00 # Total Fire Department 1,208,184.00 1,208,184.00 53,572.11 854,327.78 353,856.22 page 2 Budget to Actual - Fire Dept. Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget % Municipal Utility District No 1 Fire Station Construction 2010 General Obligation $2M Bond Fund Interim Balance Sheet 9/12 Months (75% of Fiscal Year) Balance @ 6/30/2011 ASSETS ASSETS INVESTMENTS (16,822)$ OTHER RECEIVABLES - TOTAL ASSETS (16,822)$ LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS PAYABLE 123,201$ TOTAL LIABILITIES 123,201 FUND BALANCE DESIGNATED FOR FIRE STATION CONSTRUCTION (140,023) TOTAL LIABILITIES AND FUND BALANCE (16,822)$ June 30, 2011 Trophy Club Municipal Utility Dist #1 Fire ConstructionBudget Revenue ReportTo Date: 06/30/2011DescriptionYTD BudgetTotal BudgetMTD RevYTD RevTotal VarianceRemaining %[FUND] 491 : Bond Fund 2010 GO 2M Fire491-000-000-35050 : Interest Income1,295.001,295.005.361,053.58241.4218.64 Grand Total : 1,295.001,295.005.361,053.58241.4218.64 491-045-000-94000 Temporary Housing and Storage 0.00 10,500.00 1,135.71 9,441.25 1,058.75 89.9 491-045-000-95000 Construction 0.00 1,405,652.00 164,842.92 1,547,882.66 (142,230.66) 110.1 491-045-000-96300 Engineering 0.00 41,000.00 0.00 39,609.75 1,390.25 96.6 Total Fire Department 0.00 1,457,152.00 165,978.63 1,596,933.66 (139,781.66) page 1 Budget to Actual - Fire Const Trophy Club Municipal Utility Dist #1 For Period Ending 06/30/2011 Account # Description Adopted Budget Amended Budget Curr Month Year to Date Remaining Budget %