Loading...
Res 07-33 Approving Amendments to the Budget for the Fiscal Year 2006-2007TOWN OF WESTLAKE RESOLUTION NO. 07-33 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS, APPROVING FY 2006-07 BUDGET AMENDMENTS TO THE TOWN'S GENERAL FUND, UTILITY FUND, VISITOR'S ASSOCIATION FUND, CAPITAL PROJECTS FUND, PERMANENT CAPITAL MAINTENANCE FUND, 4B ECONOMIC DEVELOPMENT FUND, PROPERTY TAX REDUCTION FUND, SPECIAL REVENUE GRANT FUND AND DEBT SERVICE FUND. WHEREAS, the Board of Aldermen has directed the Town staff to review each annual budget midway through the budget year to identify necessary amendments; and WHEREAS, the Board of Aldermen has determined it is appropriate to amend the fiscal year 2006-2007 budgets in accordance with proper governmental accounting and financial reporting practices; and WHEREAS, the Board finds that all of the attached amendments are necessary and appropriate and consistent with proper governmental accounting. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE: SECTION 1: That the Board of Aldermen of the Town of Westlake does hereby approve the budget amendments to the Town's General Fund, Utility Fund, Visitor's Association Fund, Capital Projects Fund, Permanent Capital Maintenance Fund, 4B Economic Development Fund, Property Tax Reduction Fund, Special Revenue Fund and Debt Service Fund as proposed in the attached documents. SECTION 2: That this Resolution shall become effective upon the date of its passage. PASSED AND APPROVED ON THIS 21st DAY OF MAY, 2007. ATTEST Kim Su er, TRMC, Town Secretary APPRO O O L. Stanton T Attorney Scott Bradley', Mayor Trent O. Petty, Tow M ager FUND 400 - General Fund Propost__ Sudget Amendments REVENUE ADMINISTRATIVE -DEPARTMENT 11 M Q Q Q A M Q Q C7 31310 11 Sales Tax Revenue as o 1,500,000 %% 1,768,409 18% - 1,500,000 Sales tax is so volatile, we will be conservative and not adjust 31430 03131/07 Mixed Beverage Tax (Qtrly, Projected Proposed Proposed 15,432 13% Audited Adopted 1 YTD Projected Actual vs Amended Amended 105,000 44,021 Actuals Budget Actuals Actual Adopted Amount Budget Verizon 4,695 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments REVENUE ADMINISTRATIVE -DEPARTMENT 11 M Q Q Q A M Q Q C7 31310 11 Sales Tax Revenue 1,810,707 1,500,000 589,470 1,768,409 18% - 1,500,000 Sales tax is so volatile, we will be conservative and not adjust 31430 11 Mixed Beverage Tax (Qtrly, 13,674 13,650 3,858 15,432 13% - 13,650 Amendment reflects Fidelity 2 project. 31820 11 AT&T/SBC 118,649 105,000 44,021 176,084 68% - 105,000 Amendment reflects Fidelity 2 project. 31821 11 Verizon 4,695 6,930 2,767 5,534 -20%p (1,430) 5,500 Reinspection fees not monitored or followed up on while C&C making inspections.. 31822 11 TXU/Atmos Gas (Annual) 15,112 15,868 18,609 18,609 17% 2,741 18,609 31823 11 Charter 357 357 210 503 41% 143 500 _ 31824 11 One Source 2,973 2,835 1,875 3,749 32% 915 3,750 31826 11 Tri County Electric (Qtrly) 297,073 273,000 72,445 289,779 6% - 273,000 31827 11 Trinity Waste Services 15,928 12,600 0 _12,600 0% - 12,600 31828 11 Franchise Fees 2,217 2,100 1,673 3,347 59% 900 3,000 32110 11 Liquor Permit Fees 710 746 710 1,420 90% - 746 32208 11 Other Misc Permits 980 945 1,000 2,000 112% - - 945 33700 11 Private Contributions 1,205,628 1 0 0 0 0% - 34130 11 Development Fees 17,935 15,225 21,238 42,475 179% 40,000 55,225 Approx $18K from Fidelity hasn't been received yet 34133 11 Special Event Fee 755 525 250 500 -5% - 525 34141 11 Sales of Printed Material 126 158 30 60 -62% - 158 36109 11 Note Receivable Principal 0 18,192 0 18,192 0% - 18,192 36110 11 Interest Earned 39,758 50,000 65,027 130,055 160% 50,000 100,000 Additional interest due to the transfer from 4A in previous year; debt payment, etc. Texpool currently at 5.3% 36111 11 Note Receivable interest 3,689 2,539 0 2,539 0% - 2,539 38805 11 IIF Debt Pymt from OF 0 27,590 0 27,590 0% - 27,590 Payment usually made at year-end 39400 11 Misc. Income 310 500 0 500 0% - 500 39410 11 TSH Rental Income 4,204 3,885 0 0 -100% (3,885) - TSH paying allocation of Solana now 39500 11 TSH Donation Income 100,000 1 100,000 50,000 100,000 0%e - 100,000 DEPT 11 -TOTAL G&A REVENUEJ 3,655,4791 2,152,6451 873,182 2,619,379 1 22%1 89,384 1 2,242,029 BUILDING OFFICIAL - DEPARTMENT 12 32209 12 Grading/Excavation Permits 19,800 15,000 7,800 15,600 4% - 15,000 32210 12 Building Permits 400,708 307,450 319,989 717,450 133% 410,000 717,450 Amendment reflects Fidelity 2 project. 32211 12 Inspection/Plan Reviews 239,968 177,550 139,480 447,550 152% 270,000 447,550 Amendment reflects Fidelity 2 project. 32212 12 Reinspection Fees 2,550 2,025 75 750 -63% (1,275) 750 Reinspection fees not monitored or followed up on while C&C making inspections.. 34129 12 Pre -Submittal Reviews 2,400 1,200 0 1,200 0% - 1,200 34132 34141 12 12 Contractor Registrations Sales of Printed Material 11,650 628 9,900 585 5,250 0 10,500 585 6% 0% - - 9,900 585 Will pick up when new codes are adopted. EPT 12 - TOTAL BUILDING REVENUEJ 677,7041 513,710 1 472,594 1 1,193,6*,1,7 132%1 678,725 1,192,435 FUN[ '100 - General Fund Propose. Budget Amendments FIRVEM,S - DEPARTMENT 14 34000 34007 14 14 EMS User Fee NCTTRAC Grant as o 38,865 3,000 0 0 138,350 3,000 256% 09% 99,485 - 138,350 3,000 Went with Intermedics for collection for CY (see exp below) 34010 03/31/07 Fire Code Inspections Projected Proposed Proposed 1,500 275% Audited Adopted YTD Projected Actual vs Amended Amended 7,150 5,832 Actuals Budget Actuals Actual Adopted Amount Budget FTO Citation Revenue 0 FY 05106 FY 06107 FY 06/07 FY 06107 FY 06107 FY 06107 FY 06107 Comments FIRVEM,S - DEPARTMENT 14 34000 34007 14 14 EMS User Fee NCTTRAC Grant 36,355 3,163 38,865 3,000 69,175 0 138,350 3,000 256% 09% 99,485 - 138,350 3,000 Went with Intermedics for collection for CY (see exp below) 34010 14 Fire Code Inspections 725 400 1,250 1,500 275% 1,100 1,500 First American complete on project 34015 14 Fire Sprinkler Permits 9,493 7,150 5,832 11,664 63% - 7,150 FY07 = 4379 violations vs 5206 in FY06. 827 less violations. 35111 14 FTO Citation Revenue 0 72,000 0 32,000 -56% (40,000) 32,000 To begin in 3rd quarter 35180 14 Law Enforcement Stds 1,331 4,500 1,393 2,786 -38% - 4,500 39400 14 Misc Revenue 198 1 10,000 65 0 -100% (10,000) - Recovery from major incidents program has not transpired as anticipated due to lack of incidents -71 DEPT 14 - TOTAL EMS REVENUEJ 51,2661 135,915 1 77,715 1 189,300 39%1 50,585 1 186,500 MUNICIPAL COURT - DEPARTMENT 15 35110 15 Citation Revenue 599,840 725,000 242,018 484,036 -33% (253,750) 471,250 FY07 = 4379 violations vs 5206 in FY06. 827 less violations. 35115 15 Citation Refunds (21,488) (19,000) (12,708) (25,415) 34% (6,000) (25,000) FY07 = 4379 violations vs 5206 in FY06. 827 less violations. 35120 15 Court Technology 23,888 22,500 9,534 19,068 -15% (3,500) 19,000 FY07 = 4379 violations vs 5206 in FY06. 827 less violations. 35130 15 Court Security 17,916 17,500 7,128 14,257 -19% (3,500) 14,000 FY07 = 4379 violations vs 5206 in FY06. 827 less violations. 35140 15 Warrant Revenue 74,280 148,000 69,937 139,874 -5% 148,000 35150 15 Warrant Fees 46,050 70,000 34,469 68,938 -29% 70,000 35160 15 NSF Check Revenue 625 775 100 200 -74% _ 775 35170 15 Efficiency Fees 618 650 561 1,121 72% 650 _ 35180 35190 15 15 Law Enforcement Stnds Collection Fees 655 7,321 655 18,000 658 3,674 658 7,349 0% -59% (10,500) 655 7,500 Annual receipt 36110 15 Interest Earned 10,130 8,700 8,258 1_6,515 90% 4,300 13,000 Average of $250K at 5.3% 39400 15 Misc Income 1,890 0 0 0 0% - - 39401 15 Credit Card Admin Fee 4,742 1 4,000 3,572 7,145 79% 2,000 6,000 DEPT 15 - TOTAL COURT REVENUEJ 766,467 996,780 1 367,201 1 733,745 -26% (270,950)1 725,834 PARKS & RECREATION - DEPARTMENT 19 31130 19 Tournaments 390 0 0 0 0% - 32120 19 Kid's Programs 287 0 35 35 100% 35 35 37500 19 Glenwyck HOA Reim 23,999 18,000 7,888 15,775 -12% - 18,000 39400 19 Misc Income 483 1,000 D 1,000 0% - 1,000 DEPT 19 -TOTAL PARK & REC REV 25,159 1 19,0001 7,923 1 16,810 1 .12%1 351 19,035 2 of 17 5/1612007 11:04 AM FUND 400 - General Fund Propost~- Budget Amendments TRANSFERS IN 52560 88 Transfer In/Utility Fund 35,319 50,000 14,412 57,648 15% 50,000 Fort Worth Impact fees 52570 88 Transfer In14A Fund 2,230,072 0 0 0 0% - DEPT 88 - TOTAL TRANSFERS INI 2,265,391 50,0001 14,412 1 57,648 16%1 0 1 50,000 TOTAL REVENUEJ 7,441,465 1 3,868,050 1 1,813,028 1 4,810,517 1 24%1__547,779 1 4,415,829 3 of 17 5/1612007 11:04 AM as o %% 03/31/07 Projected Proposed Proposed Audited Adopted 1 YTD Projected Actual vs Amended Amended Actuals Budget Actuals Actual Adopted Amount Budget FY 05/06 FY 06107 FY 06/07 FY 08107 FY 06107 FY 06107 FY 06/07 Comments TRANSFERS IN 52560 88 Transfer In/Utility Fund 35,319 50,000 14,412 57,648 15% 50,000 Fort Worth Impact fees 52570 88 Transfer In14A Fund 2,230,072 0 0 0 0% - DEPT 88 - TOTAL TRANSFERS INI 2,265,391 50,0001 14,412 1 57,648 16%1 0 1 50,000 TOTAL REVENUEJ 7,441,465 1 3,868,050 1 1,813,028 1 4,810,517 1 24%1__547,779 1 4,415,829 3 of 17 5/1612007 11:04 AM FUND A()a - General Fund Propose. taudget Amendments EXPENDITURES ADMINISTRATIVE -DEPARTMENT 11 41110 11 Full -Time Regular Admin as o 35,563 %% 37,750 6% 2,187 37,750 interim pay for Assistant performing Town Secretary job 42110 03131/07 Medical Insurance Projected Proposed Proposed 3,360 0% Audited Adopted 1 YTD Projected Actual vs Amended Amended 229 178 Actuals Budget Actuals Actual Adopted Amount Budget LTD/AD&D1Life Insurance 251 FY 05/06 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments EXPENDITURES ADMINISTRATIVE -DEPARTMENT 11 41110 11 Full -Time Regular Admin 30,176 35,563 19,626 37,750 6% 2,187 37,750 interim pay for Assistant performing Town Secretary job 42110 11 Medical Insurance 3,165 3,360 1,639 3,360 0% - 3,360 42111 11 Dental Insurance 295 229 178 295 29% 66 295 42130 11 LTD/AD&D1Life Insurance 251 315 166 330 5% 15 330 42210 11 Social Security Admin 1,829 2,205 1,205 2,300 4% 95 2,300 42220 11 Medicare Admin 428 516 282 516 0% - 516 42310 11 TMRSAdmin 2,209 2,916 1,555 3,105 6% 189 3,105 42510 11 Unemployment Taxes Admi 189 189 0 50 -74% (139) 50 42610 11 Worker's Comp Admin 135 109 118 118 8% 9 118 43130 11 Payroll Expense 757 800 0 800 0% - 800 43205 11 Administrative Expense 120,770 50,252 26,370 52,318 4% 2,066 52,318 Proportionate increase from salary adjustment 43206 11 Capitalized Admin Exp (50,000) 0 0 0 0% - - 43215 11 Civil Engineering 24,046 30,000 15,272 30,000 0% - 30,000 43247 11 Surveyor Fees 3,650 0 0 0 0% - - 43305 11 Misc Legal 17,651 10,000 2,267 10,000 0% - 10,000 43310 11 Boyle & Lowry 74,121 100,000 31,324 100,000 0% - 100,000 43315 11 Goins & Underkofler 54,894 25,000 17,448 25,000 011/0 - 25,000 43325 11 Legislative 32,447 60,000 14,482 60,000 0% - 60,000 43335 11 Contracted Labor 0 1,200 482 1,200 0% - 1,200 43405 11 Computer Egpmt/Software 928 1,000 0 1,000 0% - 1,000 43515 11 Community Services 2,500 2,500 2,500 2,500 0% - 2,500 43520 11 Contingency 3,163 10,000 8,702 10,000 0% - 10,000 44300 11 Copier R&MlSupplies/Copyi 570 1,092 450 1,092 0% - 1,092 44302 11 Copier Lease 2,872 3,120 1,546 3,120 0% - 3,120 44410 11 Office Rent 17,242 96,337 34,485 96,337 0% - 96,337 We will be paying more when the Town staff moves to Solana 45205 45209 11 11 Insurance Deductible Insurance Law Enf 2,000 605 0 666 0 589 0 589 0% -12% - (77) - 589 Actual paid 45210 11 Insurance General Liability 9,167 9,948 9,585 9,585 4% (363) 9,585 Actual paid 45211 11 Insurance E & O 15,104 16,852 14,149 14,149 -16% (2,703) 14,149 Budgeted at 10% increase based on inflation; came in less plus we received a 3% discount for prepayment 45213 11 Insurance Crime &Theft 1,124 1,236 1,547 1,547 25% 311 1,547 Actual paid 45214 11 Insurance Automobile 456 502 422 422 -16% (80) 422 Actual paid 45215 11 Insurance Property 4,807 162 148 148 -9% (14) 148 Actual paid 45305 11 Telephone Service 6,231 7,789 3,481 7,789 0% - 7,789 45310 11 Mobile Phone 1,043 1,700 484 1,700 0% - 1,700 5718IZ007 r1 :D4 AM FUND '90 - General Fund Propose.. Budget Amendments 4532511 Misc Rentalll-ease as o 1,000 %% 1,000 0% - 1,000 45805 11 03/31/07 0 Projected Proposed Proposed 0% - 100 Audited 1 Adopted YTD Projected Actual vs Amended Amended 10 0% Actuals Budget Actuals Actual Adopted Amount Budget 0 100 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 Comments 4532511 Misc Rentalll-ease 1,047 1,000 252 1,000 0% - 1,000 45805 11 Travel Airfare 0 100 (173) 100 0% - 100 45810 11 Travel Car Rental/Parking 0 0 5 10 0% 10 10 45815 11 Travel Lodging 0 100 0 100 0% - 100 45820 11 Travel Meals 0 200 10 200 0% - 200 45825 11 Travel Mileage 39 1,300 40 1,300 0% - 1,300 45830 11 Training/Seminars/Meeting<. 1,559 1,600 402 1,600 0% - 1,600 46105 11 Office Supplies 7,317 6,400 3,366 6,400 0% - 6,400 46106 11 Hospitality Items 2,814 2,600 1,217 2,600 0% - 2,600 46115 11 Dues & Subscriptions 8,403 8,000 1,965 8,000 0% - 8,000 Chamber $25001 NTComm $12001 ICMA $1280 Newspapers $3001 TML $5001 NWCP $3001TCMA $350 46120 11 Postage & Supplies 2,245 3,000 922 3,000 0% - 3,000 46125 11 Printing 181 100 89 100 0%a - 100 46130 11 Books & Printed Materials 26 250 128 250 0% - 250 46135 11 Bank Service Charges 0 100 0 100 0% - 100 46140 11 Moving Expense 4,079 5,000 0 5,000 0% - 5,000 46160 11 Credit Card Processing 66 100 93 100 0% - 100 46190 11 Misc. Expense 2,834 10,000 1,811 10,000 0% - 10,000 46205 11 Utilities Water 3,672 4,069 496 4,069 0% - 4,069 46215 11 Vehicle FuelfMaint 418 750 203 750 0% - 750 46220 11 Utilities Electric 13,927 16,683 5,195 16,683 0% - 16,683 46225 11 Utilities Gas 2,080 4,418 1,219 4,418 0% - 4,418 46520 11 Economic Dev Principal 16,426 15,314 15,314 15,314 0% - 15,314 46522 11 Economic Dev Interest 19,333 20,444 20,444 20,444 0% - 20,444 46523 11 Economic Dev 1 st Americar 0 150,000 0 150,000 0% - 150,000 Haven't received final notice for us to start the audit of the taxes received 47412 11 Land 1,199,596 0 0 0 0% - - 47413 11 Comp Hardware/Software 0 5,000 0 5,000 0% - 5,000 47415 11 Furniture & Fixtures 0 1 25,000 5,051 25,000 0% - 25,000 1 Will use these funds when we move to Solana DEPT 11 -TOTAL ADMIN UPI 1,670,8891 757,086 1 268,5471 758,658 1 0%1 1,572 1 758,658 5 of 17 5/16/2007 11:04 AM FUND ,400 - General Fund Propose.- r3udget Amendments BUILDING OFFICIAL - DEPARTMENT 12 41110 12 Full -Time Bldg Official as o 56,127 %% 56,127 0% - 56,127 41641 03131/07 Cell Phone Allowance Projected Proposed Proposed 1,600 100% Audited Adopted 1 YTD Projected Actual vs Amended Amended 8,300 3,559 Actuals Budget Actuals Actual Adopted Amount Budget Dental insurance 467 FY 05106 FY 06107 FY 06/07 FY 06/07 FY 06107 FY 06107 FY 06107 Comments BUILDING OFFICIAL - DEPARTMENT 12 41110 12 Full -Time Bldg Official 49,169 56,127 24,600 56,127 0% - 56,127 41641 12 Cell Phone Allowance 0 0 500 1,600 100% 1,600 1,600 Moved from 45310; Allowance included in Eddie's salary; Jim's was a reimbursement 42110 12 Medical Insurance 8,341 8,300 3,559 8,300 0% - 8,300 42111 12 Dental insurance 467 535 252 535 0% - 535 42130 12 LTDIAD&D/Life Insurance 460 525 (43) 525 0% - 525 Jim to Eddie employment gap. 42210 12 Social Security Bldg Official 2,871 3,480 1,318 3,480 0% - 3,480 Jim to Eddie employment gap. 42220 12 Medicare Bldg Official 671 814 308 814 0% - 814 Jim to Eddie employment gap. 42310 12 TMRS Bldg Official 3,584 4,602 1,979 4,602 0% - 4,602 42510 12 Unemployment Taxes Bldg 270 270 0 270 0% - 270 Jim to Eddie employment gap. 42610 12 Worker's Camp 420 589 393 589 0% - 589 Jim to Eddie employment gap. 43260 12 Building Inspection 37,376 30,000 35,717 80,000 167% 50,000 80,000 Estimated increase needed for Fidelity 2 project. 43335 12 Contract Labor 880 0 671 671 100% 671 671 Contract labor for organization and filing when Eddie was hired 43405 12 Computer Egpmt/Software 0 5,700 2,769 5,700 0% - 5,700 45214 12 Insurance Automobile 506 557 612 612 10% 55 612 Insurance paid at first of year. 45310 12 Mobile Phone 1,465 1,600 139 139 -91% (1,461) 139 Moved to 41641 45815 12 Travel Lodging 454 900 0 900 0% - 900 Seminars and classes not attended yet. 45820 12 Travel Meals 44 500 0 500 0% - 500 Seminars and classes not attended yet. 45825 12 Travel Mileage 297 1,600 0 1,600 0% - 1,600 Seminars and classes not attended yet. 45830 12 Training/SeminarslMeetingE 1,769 3,400 0 3,400 0% - 3,400 Seminars and classes not attended yet. 46905 12 Office Supplies 860 1,000 277 1,000 0% - 1,000 Will be purchasing soon. 46110 12 Office Equipment 0 1,500 0 1,500 0% - 1,500 Will be purchasing soon. 46115 12 Dues & Subscriptions 305 750 55 750 0% - 750 Will be purchasing soon. 46125 12 Printing 1,162 750 0 750 0% - 750 Will be purchasing soon. 46.130 12 Books & Printed Materials 2,060 2,000 0 2,000 0% - 2,000 Will be purchasing soon. 46215 12 Vehicle Fuel/Maint 961 1,200 1,402 3,000 150% 1,800 3,000 Increase based on first 1/2 yr. spending. + Inc in fuel 46605 12 Uniforms 570 500 0 500 0% - 500 Will be purchasing soon. DEPT 12 - TOTAL BUILDING EXPI 114,963 127,199 1 74,508 1 179,864 41%1 52,665 1 179,864 6 of 17 5/16/2007 11:04 AM FUND 100 - General Fund Propose cdudget Amendments TOWN SECRETARY - DEPARTMENT 13 41110 13 Full -Time Secretary as o 68,156 %% 50,900 -25%m 41111 13 TSH Salary Credit (21,942) (23,855) 03/31107 (18,900) Projected Proposed Proposed Medical Insurance 4,389 Audited 1 Adopted YTD Projected Actual vs Amended Amended 272 327 Actuals Budget Actuals Actual Adopted Amount Budget 450 0 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments TOWN SECRETARY - DEPARTMENT 13 41110 13 Full -Time Secretary 69,515 68,156 15,000 50,900 -25%m 41111 13 TSH Salary Credit (21,942) (23,855) (5,687) (18,900) -21% 42110 13 Medical Insurance 4,389 4,800 1,500 3,900 -19% 42111 13 Dental Insurance 272 327 108 300 -8% 42130 13 LTDIA'D&D/Life Insurance 452 450 0 250 -44% 42210 13 Social Security Secretary 4,150 4,226 930 3,165 -25% 42220 13 Medicare Secretary 971 988 218 738 -25% 42310 13 TMRS Secretary 5,097 5,589 1,262 4,281 -23% 42510 13 Unemployment Taxes Secr( 270 270 270 27 -90% 42610 13 Worker's Comp Secretary 193 245 169 169 -31% 43241 13 Records Management 3,535 1,000 104 1,000 0% 43305 13 Misc Legal 0 200 0 200 0% 44300 13 Copier R&M1Supplies/Copyi 473 750 373 750 0% 44302 13 Copier Lease 1,424 1,380 679 1,380 0% 45325 13 Misc Rental/Lease 37 300 0 300 0% 45405 13 Advertising Public Notices 1,444 2,000 33 2,000 0% 45815 13 Travel Lodging 358 400 0 400 0% 45820 13 Travel Meals 63 150 0 150 0% 45830 13 Training/Seminars/Meeting: 281 700 60 700 0% 46105 13 Office Supplies 794 800 825 1,440 80% 46115 13 Dues & Subscriptions 220 250 445 445 78% 46120 13 Postage & Supplies 19 100 0 100 0% 46125 13 Printing 0 0 27 30 100% 46130 13 Books & Printed Materials 140 310 236 310 0% 46150 13 Lioenses/Registrations 0 100 0 100 0% 46175 13 Meeting Expense 0 100 0 100 0% 46180 13 Election Expense 3,079 3,000 0 7,000 133% 46185 13 Codification 4,628 3,030 313 5,030 66% 46190 13 Misc. Expense 32 1 200 54 200 0% DEPT 13 - TOWN SECRETARY EXP 1 79,8941 75,9661 16,918 1 66,465 -13% 17,256) 50,900 No Town Secretary until January, 2007; includes 3 month review increase for Secretary 4,955 (18,900) (900) 3,900 (27) 300 (200) 250 (1,061) 3,165 (250) 738 (1,308) 4,281 T (243) 27 (76) 169 - 1,000 - 200 - 750 - 1,380 - 300 - 2,000 - 400 - 150 - 700 640 1,440 Additional copy paper, tabs, dividers, toner, drum, mayor newsletter 195 445 Add NW Community Partnership $195 - 100 30 30 Business cards - 310 - 7,000Additional A2000 run-off election expense 2,000PD Codification - 7 of 17 5/16/2007 11:04 AM FUND "00 - General Fund Propose,.. Budget Amendments FIRVEMS - DEPARTMENT 14 41110 41120 14 14 Full -Time Regular EMS Full -Time Overtime EMS as o 541,318 34,000 %% 541,318 34,000 0% 0% - - 541,318 34,000 41210 03/31/07 Part -Time Regular EMS Projected Proposed Proposed 36,000 0% Audited Adopted 1 YTD Projected Actual vs Amended Amended 10,000 2,329 Actuals Budget Actuals Actual Adopted Amount Budget Warrant Officer Overtime 170 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 FY 06107 Comments FIRVEMS - DEPARTMENT 14 41110 41120 14 14 Full -Time Regular EMS Full -Time Overtime EMS 497,369 49,109 541,318 34,000 259,015 8,774 541,318 34,000 0% 0% - - 541,318 34,000 41210 14 Part -Time Regular EMS 16,821 36,000 11,131 36,000 0% - 36,000 41510 14 FLSA Regular 5,468 10,000 2,329 10,000 0% - 10,000 41515 14 Warrant Officer Overtime 170 0 0 0 0% - 41640 14 Auto Allowance EMS 4,800 4,800 2,308 4,800 0% - 4,800 42110 14 Medical Insurance 61,539 68,914 34,049 68,914 0% - 68,914 42111 14 Dental Insurance 4,454 5,418 2,865 5,418 0% - 5,418 42130 14 LTDIAD&D1Life Insurance 3,621 5,947 2,467 5,947 0% - 5,947 42210 14 Social Security EMS 34,309 38,819 16,991 38,819 0%a - 38,819 42220 14 Medicare EMS 8,024 9,079 3,974 9,079 0% - 9,079 42310 14 TMRS EMS 40,923 48,390 21,806 48,390 0% - 48,390 42510 14 Unemployment Taxes EMS 3,146 4,050 365 4,050 0% - 4,050 42610 14 Worker's Comp EMS 12,810 19,199 16,334 19,199 0% - 19,199 43125 14 Pre-employment Physicals 1,236 600 0 600 0% - 600 43135 14 Pre -Employment Testing 1,569 1,600 397 1,600 0% - 1,600 NFACT Quarterly Testing 43140 43255 43334 43335 14 14 14 14 Employee Physicals Keller Police Contract EMS User Fee Pymt Sup Fireman Labor 4,000 710,340 0 21,944 5,225 729,932 0 0 0 364,966 5,877 0 5,225 729,932 20,700 0 0% 0% 100% 0% - - _ 20,700 - 5,225 729,932 20,700 - Co-ordinate with neighboring departments- usually in August Based on 15% of revenues of $138K (See revenue increase in revenue section -15%) 43336 14 Contract Services 14,010 14,350 5,376 14,350 0% - 14,350 Medical Control Contract - Paid 1st Quarter 43337 14 Exterminator Service 315 360 93 360 0% - 360 Pest Extermination Bi -monthly visits 43347 14 Contract HVAC Maint 160 0 0 0 0% - - 43405 44209 14 14 Computer EgpmUSoftware Cleaning Supplies 700 1,613 0 2,235 735 652 735 2,235 100% 0% 835 - 835 2,235 FireHouse Computer Program maintenance fee Purchased in bulk as needed 44210 14 Facility Supplies 724 8,600 5,362 8,600 0% - 8,600 44211 14 Safety Supplies 267 1,570 1,621 1,621 3% 51 1,621 Radio and SCBA Maintenance Cost 44212 14 Building Supplies 385 600 563 600 0% - 600 44213 14 Firefighter Supplies 3,169 5,315 875 5,315 0% - 5,315 44221 14 Radios/Com Supplies 0 0 0 900 100% 900 900 New Acct - to distinguish radios and communication supplies (reallocated from other line items) 44226 14 Misc Hand Tools 269 350 0 350 0% - 350 44306 14 Grounds Maintenance 0 0 160 160 100% 160 160 Paid in full 45214 14 Insurance Automobile 3,466 3,813 3,999 3,999 5% 186 3,999 Paid in full 45215 14 Insurance Property 172 1 165 98 165 0% - 165 45305 14 Telephone Service 1,824 2,250 865 2,250 0% - 2,250 45310 14 Mobile Phone 1,168 1,100 1,042 1,IlUbf17 0% - 1,100 5/16/2007 11:04 AM FUND 400 - General Fund Propose,. Budget Amendments 45315 14 Internet Expense as o 3,860 5,550 %% 3,860 5,550 0% 0%4 - - 3,860 5,550 45325 14 Trailer Rental 4,811 03/31/07 14 Projected Proposed Proposed 0 0 Audited Adopted 1 YTD Projected Actual vs Amended Amended 158 150 Actuals Budget Actuals Actual Adopted Amount Budget 14 Travel Mileage FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments 45315 14 Internet Expense 731 3,860 5,550 240 2,974 3,860 5,550 0% 0%4 - - 3,860 5,550 45325 14 Trailer Rental 4,811 45815 14 Travel Lodging 446 0 0 0 0% - 45820 14 Travel Meals 158 150 0 150 0% - 150 45825 14 Travel Mileage 228 0 0 0 0% - - 45830 14 Train! nglSeminarslMeeting: 2,715 8,270 622 8,270 0% - 8,270 Course schedules and times have limited participation - increase activity this next quarter 45904 14 Plumbing 0 1,500 1,397 1,400 -7% (100) 1,400 $100 transfer to Radio/Communication Supplies. Account part of Trailer moving funds 45907 14 HVAC R&M 495 145 0 145 0% - 145 45910 14 Mechanical R&M 50 50 0 50 0% - 50 46105 14 Office Supplies 737 1,200 339 1,200 0% - 1,2_00 46106 14 Hospitality Items 73 100 41 100 0% - 100 46115 14 Dues & Subscriptions 7,811 7,850 7,199 9,100 16% 1,250 9,100 NFPA- online annual standard updates 46120 14 Postage & Supplies 165 100 2 100 0% - 100 46125 14 Printing 144 150 0 150 0% 150 46130 14 Books & Printed Materials 1,695_ 900 1,400 170 995 900 1,150 0% -18% - (250) 900 1,150 Reduction of $250 - transferred to Dues and Subscriptions 46150 14 Licenses/Registrations 879 46155 14 Misc. Supplies 223 1,970 102 1,970 0% - 1,970 Purchase of vehicle equipment (computer docking station) not associated with existing account 46170 14 Security 0 0 1,550 812 278 812 1,550 100% 0% 812 - 812 1,550 Two key pads for Fire house 46190 14 Misc. Expense 5 46205 14 Utilities Water 2,053 2,325 1,000 2,325 0% - 2,325 46215 14 Vehicle Fuel/Maint/Repairs 21,744 28,575 6,161 _ 28,575 0% - 28,575 46220 14 Utilities Electric 3,915 4,430 1,523 4,430 0% - 4,430 Items purchase/ordered 1st quarter due to delivery time 46225 14 Utilities Gas 2,178 3,400 1,544 3,400 0% - 3,400 46605 14 Uniforms 7,736 7,332 4,558 7,982 9% 650 7,982 Routine purchases based on supplies used. 46610 14 Weapons/Accessories 3,033 3,800 0 2,800 -26% (1,000) 2,800 Reallocated portion to new line -item above 46615 14 Medical Supplies 8,073 6,300 2,251 5,650 -10% (650) 5,650 46622 14 Homeland Security/Fed 0 0 0 0 0% - 47415 14 Furniture & Fixtures 0 1 3,530 0 3,530 0% - 31530 DEPT 14 -TOTAL EMS EXPI 1,579,977 1,698,4361 807,299 1,721,880 1 1% 23,6441 1,721,980 9 of 17 5/16/2007 11:04 AM FUND '100 - General Fund Propose.. Budget Amendments MUNICIPAL COURT - DEPARTMENT 15 41110 15 Full -Time Regular Court 147,206 185,194 76,922 41120 15 Fuil-Time Overtime Court as o 0 0 0 41515 15 Baillif Security Overtime 1,012 1,850 485 03131/07 15 Projected Proposed Proposed 0 42110 Audited Adopted YTD Projected Actual vs Amended Amended Dental lnsur_ance 1,085 Actuals Budget Actuals Actual Adopted Amount Budget 587 42210 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 FY 06107 Comments MUNICIPAL COURT - DEPARTMENT 15 41110 15 Full -Time Regular Court 147,206 185,194 76,922 41120 15 Fuil-Time Overtime Court 3,156 0 3,711 41515 15 Baillif Security Overtime 1,012 1,850 485 41516 15 Warrant Officer Security 0 10,000 0 42110 15 Medical Insurance 19,606 28,668 11,486 42111 15 Dental lnsur_ance 1,085 1,962 674 42130 15 LTD/AD&DILife Insurance 936 2,664 587 42210 15 Social Security Court _ 9,283 11,597 4,953 42220 15 Medicare Court 2,166 2,712 1,163 42310 15 TMRS Court 10,985 15,338 6,466 42510 15 Unemployment Taxes 1,350 1,350 269 42610 15 Worker's Comp Court 1,330 2,342 1,767 43125 15 Pre -Employment Physicals 409 0 0 43135 15 Pre -Employment Testing 210 300 0 43310 15 Boyle & Lowry 21,619 20,000 9,263 43330 15 Court Legal Judge Srvs 31,050 30,000 15,000 43335 15 Contracted Labor 858 1,000 300 43336 15 Contract Services 12,709 17,000 327 43405 44209 15 15 Computer Egpmt/Software Cleaning Supplies 837 0 0 _ 0 45 60 44300 15 Copier R&M/SupplieslCopyi 473 750 373 44302 15 Copier Lease 1,424 1,380 679 45214 15 Insurance Automobile 355 391 290 45305 15 Telephone Service 214 0 222 45315 15 Internet Expense 931 2,857 1,345 45325 15 Misc Rental/Lease 2,845 3,244 1,711 45805 15 Travel Airfare 241 250 280 45810 15 Travel Car Rental/Parking 0 25 218 45815 15 Travel Lodging 279 500 467 45820 15 _ Travel Meals 72 650 78 45825 15 Travel Mileage 63 950 273 45830 15 Training/Seminars/Meeting: 280 1,525 130 46105 15 Office Supplies 5,077 4,500 1,887 173,000 6,000 -7% 100% (12,194) 6,000 173,000 6,000 Additional clerk was originally budgeted but not hired Overtime due to Warrant Round -ups, Evening Court, etc 1,850 10,000 0% 0% - - 1,850 10,000 Will reclass at year-end from Security revenue 25,000 -13% (3,668) 25,000 1,600 -18% (362) 1,600 1,900 -29% (764) 1,900 10,500 -9% (1,097) 10,500 2,500 14,000 -8% -9%a (212) (1,338) 2,500 14,000 550 -59% (800) 550 2,000 -15% (342) 2,000 0 0% - - 300 0% - 300 20,000 0% - 20,000 30,000 0% - 30,000 1,000 17,000 0% 0% - - 1,000 17,000 ^T American Municipal - 3 invoices received and paid in April 45 100% 45 45 52 100% 52 52 750 0% - 750 1,380 0% - 1,380 290 -26% (101) 290 Paid in full 500 100% 500 500 Alarm line 2,857 0% - 2,857 3,244 0% - 3,244 12% 30 280 Higher variance due to continuing education travel of Judge and Administrator _280 220 780% 195 220 Higher variance due to rental for Administrator at annual meeting 500 0%4 - 500 Higher variance due to hotel fees for Administrators annual meeting 650 0% - 650 950 0% - 950 1,525 0% - 1,525 4,500 of 17 0% - 4,500 5/1612007 11:04 AM FUND ''00 - General Fund Propose, Budget Amendments 114% 100 200 Variance due to increased jury trials 0% as o 0% %% 0% 46106 15 Hospitality Items 271 100 03131/07 214 Projected Proposed Proposed 599 370 Audited Adopted 1 YTD Projected Actual vs Amended Amended 1,154 1,500 Actuals Budget Actuals Actual Adopted Amount Budget 46135 15 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments 114% 100 200 Variance due to increased jury trials 0% - 370 0% - 1,500 0% 46106 15 Hospitality Items 271 100 107 214 46115 15 Dues & Subscriptions 599 370 162 370 46120 15 Postage & Supplies 1,878 1,500 1,154 1,500 46125 15 Printing 6,709 5,000 162 5,000 46135 15 Bank Service Charges 0 100 0 100 46160 15 Credit Card Processing 6,268 6,000 4,039 6,000 46165 15 Court Technology 32,772 17,100 3,697 17,100 46167 15 Court Efficiency 230 650 0 650 46170 15 Court Security 22,026 3,500 700 3,500 46171 15 Court TCLEOSE 0 650 0 650 46190 15 Misc. Expense 84 1,000 239 1,000 46215 15 Vehicle Fuel/Maint/Repairs 1,025 3,200 339 3,200 46605 15 Uniforms 108 200 0 200 47410 15 Motor Vehicles 1,500 0 0 0 47413 15 Com Hardware/Software 0 16,000 16,640 16,640 47415 15 Furniture & Fixtures 10,308 0 0 0 DEPT 15 - TOTAL COURT EXPI 361,839 404,3691 100,0701 1 391,067 114% 100 200 Variance due to increased jury trials 0% - 370 0% - 1,500 0% - 5,000 0% - 100 0% - 6,000 0% - 17,100 0% - 650 0% - 3,500 0% - 650 0% - 1,000 0% - 3,200 0% - 200 0% - - 4% 640 16,640 0% - 11 of 17 5/16/2007 11:04 AM FUND "UO - General Fund Propose. i3udget Amendments PUBLIC WORKS - DEPARTMENT 16 41110 16 Full -Time Public Works as o 13,756 0 13,756 0% - 13,756 42110 03/31107 Medical Insurance Projected Proposed Proposed 2,000 -23% Audited Adopted 1 YTD Projected Actual vs Amended Amended 182 98 Actuals Budget Actuals Actual Adopted Amount Budget LTD/AD&D/Life Insurance 91 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments PUBLIC WORKS - DEPARTMENT 16 41110 16 Full -Time Public Works 11,287 13,756 6,729 13,756 0% - 13,756 42110 16 Medical Insurance 2,348 2,613 927 2,000 -23% (613) 2,000 42111 16 Dental Insurance 150 182 98 200 10% 18 200 42130 16 LTD/AD&D/Life Insurance 91 128 64 128 0% - 128 42210 16 Social Security Public Work 585 853 380 775 -9% (78) 775 42220 16 Medicare Public Works 137 199 89 180 -10% (19) 180 42310 16 TMRS Public Works 826 1,128 536 1,128 0% - 1,128 42510 16 Unemployment Taxes Publi 68 68 0 25 -63% (43) 25 42610 16 Worker's Comp 388 588_ _ 463 475 -19% (113) 475 43212 16 Pothole Repairs (In house) 500 200 18 200 0% - 200 43213_16 Row Tree Removal 2,295 2,000 0 2,000 0% - 2,000 _ _4_3214 16 Street Drainage 0 5,000 1,964 5,000 0% - 5,000 43215 16 Civil Engineering 0 5,000 0 5,000 0% - 5,000 _ Have not had any need for engineering services to - date 44206 16 Warning Devices 1,151 500 0 500 0% - 500 44303 16 Road Repair/Maintenance 8,056 10,000 7,237 13,000 30% 3,000 13,000 Includes repair of shoulders along Precinct Line Road & major pot hole repairs on Roanoke Rd & Ottinger Road. Need to increase by $3,000 to make additional shoulder repairs along Dove Road. 44304 16 Sign Repair/Maintenance 21 1,500 545 1,500 0% - 1,500 44305 16 ROW Irrigation 87,928 73,000 7,259 73,000 0% - 73,000 Increased wet weather & cooler temperatures has reduced need for irrigation - however consumption will increase during summer months. 45214 16 Insurance Automobile 0 0 626 626 100% 626 626 2nd PW truck insuranceomitted on original invoice 46215 16 Vehicle Fuel/Maint/Repairs_ 1,979 4,000 236 4,000 0% - 4,000 46220 16 ROW Electric 425 600 176 600 0% - 600 47411 16 Mechanical Equipment 0 0 120 300 100% 300 300 This is a new line item that includes small engine repair & maintenance for item like the salt sand spreader & mowing equipment. DEPT 16 - TOTAL PUBLIC WKS EXPI 118,233 1 121,3151 27,467 1 124,393 1 3%1 3,078 1 124,393 12 of 17 5/16/2007 11:04 AM FUND '00 - General Fund Propose,, Budget Amendments FACILITIES & GROUNDS MAINTENANCE - DEPARTMENT 17 41110 17 Full -Time Fac Maint 27,500 21,093 10,652 21,250 1% as o 21,250 1/01/0 17 Medical Insurance 4,600 3,920 2,036 3,920 03/31107 - Projected Proposed Proposed Dental Insurance 300 Audited Adopted YTD Projected Actual vs Amended Amended 17 LTDIAD&DlLife Insurance Actuals Budget Actuals Actual Adopted Amount Budget 42210 17 FY 05106 FY 06/07 FY 06/07 FY 06107 FY 06107 FY 06107 FY 06107 Comments FACILITIES & GROUNDS MAINTENANCE - DEPARTMENT 17 41110 17 Full -Time Fac Maint 27,500 21,093 10,652 21,250 1% 157 21,250 42110 17 Medical Insurance 4,600 3,920 2,036 3,920 0% - 3,920 42111 17 Dental Insurance 300 272 142 300 10% 28 300 42130 17 LTDIAD&DlLife Insurance 227 199 102 210 6% 11 210 42210 17 Social Security Fac Maint 1,536 1,308 587 1,275 -3% (33) 1,275 42220 17 Medicare Fac Maint 359 306 137 300 -2% (6) 300 42310 17 TMRS Fac Maint 2,013 1,730 847 1,730 0% - 1,730 42510 17 Unemployment Taxes Fac A 135 101 0 25 -75% (76) 25 42610 17 Worker's Comp Fac Maint 744 812 866 866 7% 54 866 43337 17 Contract Exterminator 594 5,000 1,525 3,000 -40% (2,000) 3,000 43338 17 Contract Mechanical Maint 6,062 7,000 1,885 7,000 0% - 7,000 43339 17 Contract Sweep ing/Washinl 0 1,000 0 1,000 0% - 1,000 43340 17 Contract Irrigation Maintena 5,708 4,000 3,278 4,000 0%, - 4,000 43341 17 Contract Window Cleaning 603 3,000 0 3,000 0% - 3,000 43342 17 Contract Carpet Cleaning 2,260 420 0 420 0% - 420 43344 17 Contract Median Maint 22,614 13,000 4,824 13,000 0% - 13,000 43345 17 Contract Janitorial Service 35,470 6,020 2,245 6,020 0% 6,020 43346 17 Contract Building Maint 29,488 16,000 3,276 16,000 0% - 16,000 43347 17 Contract HVAG Maint 9,704 12,000 2,842 12,000 0% - 12,000 43348 17 Contract Landscape - Civic 30,278 33,500 10,965 33,500 0% - 33,500 43350 17 Contract Security Monitor 809 1,600 891 1,600 0% - 1,600 43351 17 Contract Wastewater Treatr 269 2,400 743 2,400 0% - 2,400 43352 17 Contract Electrical/Lighting 5,625 12,500 3,750 12,500 0% - 12,500 43353 17 Contract Sanitation/Waste F 1,839 2,000 (364) 2,000 0% - 2,000 43354 17 Contract Security Maint 9,000 3,000 0 3,000 0% - 3,000 44210 17 Facility Supplies 5,325 350 591 600 71% 250 600 44212 17 Building Supplies 2,320 4,000 777 3,500 -13% (500) 3,500 44213 17 Electrical Supplies 450 5,000 1,353 7,000 40% 2,000 7,000 44216 17 Ground Supplies 2,557 4,500 1,499 3,500 -22% (1,000) 3,500 44217 17 HVAC Supplies 75 100 0 100 0% - 100 44218 17 LamplBulb Supplies 5,786 4,500 1,616 4,000 -11% (500) 4,000 44219 17 Mechanical Supplies 875 5,500 3,517 5,500 0% - 5,500 44220 17 Painting Supplies 3,178 6,000 0 6,000 0% - 6,000 44224 17 Sanitation Supplies 2,500 0 2,500 0% - 2,500 44225 17 Water Treatment Supplies 445 4,000 459 4,000 0% - 4,000 44226 17 Misc Hand Tools 896 1,400 312 1,400 0% - 1,400 44306 17 Grounds Maintenance 0 12,000 0 12,000 0% - 12,000 45310 17 Mobile Phone 1,246 1,200 448 1,200 0% - 1,200 45315 17 Internet Expense 337 700 111 600 -14% (100) 600 Parking lights/ move 2,000 for 4337 FUND 100 -+General Fund Proposc 3udget Amendments 45325 45810 45820 17 17 17 Misc Rental/Lease Travel Car Rental/Parking Travel Meals is of 3,000 0 0 %% 3,000 0 0 0% 0% 0% - - - 3,000 - 45830 17 03/31/07 444 Projected Proposed Proposed -11% (500) Audited Adopted 1 YTD Projected Actual vs Amended Amended 6,000 0% Actuals Budget Actuals Actual Adopted Amount Budget 255 4,000 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments 45325 45810 45820 17 17 17 Misc Rental/Lease Travel Car Rental/Parking Travel Meals 3,525 15 27 3,000 0 0 5B6 0 0 3,000 0 0 0% 0% 0% - - - 3,000 - 45830 17 Train ing/Seminars/MeetingE 444 4,500 225 4,000 -11% (500) 4,000 45901 17 Audio Visual R&M 1,352 6,000 1,331 6,000 0% - 6,000 45902 17 Electrical R&M 1,131 4,000 255 4,000 0% - 4,000 45903 17 Elevator R&M 1,200 1,500 500 1,500 0% - _ 1,500 45904 17 Plumbing R&M 2,465 4,000 1,251 4,000 0% - 4,000 45905 17 Fire Sprinkler R&M 1,548 3,500 0 3,500 0% - 3,500 45906 17 Fire/Life-AED R&M 2,203 5,000 650 5,000 0% - 5,000 New 17 Off site storage maint 0 0 3,500 100% 3,500 3,500 Parchman house maintenance/landsca 45907 17 HVAC R&M 2,057 4,500 3,039 4,500 0% - 4,500 45908 17 Interior Building R&M 2,319 6,000 0 6,000 0% - 6,000 45909 17 Building Exterior R&M 254 6,000 3,834 6,000 0% - 6,000 45910 17 Mechanical R&M 703 2,500 26 2,500 0% - _ 2,500 45912 17 HOC Projects 1,056 0 0 0 0% - 46105 17 Office Supplies 78 500 36 500 0% - 500 46115 17 Dues & Subscriptions 166 900 0 450 -50% (450) 450 46150 17 Licenses/Registrations 180 500 60 350 -30% (150) 350 46190 17 Misc. Expense 220 2,500 1,057 2,000 -20% (500) 2,000 46215 17 Vehicle Fuel/Maint 451 500 173 500 0% - _ 500 46605 17 Uniforms 301 1,000 153 900 -1D%° (100) 900 DEPT 17 - TOTAL FACIGROUND EXP 243,020 260,331 75,088 260,416 0% 85 260,416 14 of 17 5/16/2007 11:04 AM FUND 400 - General Fund Propose: Budget Amendments FINANCEIHUMAN RESOURCE - DEPARTMENT 18 41110 18 Full -Time Regular Financell asp 105,440 ti 10 105,440 0% - 105,440 41112 18 03/31107 (20,000) Projected Proposed Proposed 0% - Audited Adopted 1 YTD Projected Actual vs Amended Amended 4,200 12% Actuals Budget Actuals Actual Adopted Amount Budget 5,145 10,204 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments FINANCEIHUMAN RESOURCE - DEPARTMENT 18 41110 18 Full -Time Regular Financell 103,466 105,440 51,433 105,440 0% - 105,440 41112 18 Capitalized Payroll Exp (20,000) 0 0 0 0% - _ - 41120 18 Full -Time Overtime 4,104 3,750 1,913 4,200 12% 460 _ 4,200 42110 18 Medical Insurance 10,376 10,204 5,145 10,204 0% - 10,204 42111 18 Dental Insurance 633 743 367 743 061. - 743 42130 18 LTDIAD&DlLife Insurance 858 1,031 484 1,000 -3% (31) 1,000 42210 18 Social Security Finance/HR 6,280 6,537 3,126 6,537 0% - 6,537 42220 18 Medicare Finance/HR 1,469 1,529 731 1,529 0% - 1,529 42310 18 TMRS Finance/HR 7,881 8,646 4,267 8,546 0% - 8,646 42510 18 Unemployment Taxes 507 486 0 125 -74% (361) 125 42610 43135 43245 18 18 18 Worker's Comp Pre_ -Employment Testing Financial Consultant 314 _ 23 1,500 374 250 6,500 304 12 0 304 200 6,500 -19_%_ -20% 0% (70) (50) - 304 200 6,500 f 43250 18 Auditor 17,500 16,450_ 16,450 16,450 0% - 16,450 43405 18 Computer EgpmtlSoftware 71_ 500 0 500 0%s _ - 500 44310 18 Application Software Maint. 6,505 1,950 5,890 6,000 208% 4,050 Budget amount erroneously excluded due to 6,000 payment billing late in year by vendor 45405 18 Advertising 946 _ 750 0 750 0% - 750 45610 45805 45810 18 18 18 Special Events Travel Airfare Travel Car Rental/Parking 536 0 0 _ 250 350 100 25 127 68 250 350 100 0% 0% 0% - - - 250 350 100 45815 45820 18 18 Travel Lodging Travel Meals 311 6 1,200 250 385 0 1,200 250 0%e 0% - - 1,200 250 45825 18 Travel Mileage 0 250 29 250 0% - _ 250 45830 18 Train inglSeminarslMeetingE 1,157 3,000 1,373 3,000 0% 3,000 46105 18 Office Supplies 860 1,800 669 1,800 0% - 1,800 46115 18 Dues & Subscriptions 1,493 1,500 270 1,500 0% - 1,500 46130 18 Books & Printed Materials 118 100 0 100 0% - 100 46190 18 Misc. Expense 0 _ 500 0 500 0% - 500 47413 18 Computer HardwarelSoftwa 0 1 16,875 2,115 16,875 0% - 16,875 1STW implementation to be completed in June DEPT 18 - TOTAL FINANCE EXP 1 146,916 1 191,3151 95,184 1 195,303 1 2%1 3,988 1 195,303 15 of 17 5/16/2007 11:04 AM FUND "10 - General Fund Propose%. Budget Amendments PARKS & RECREATION - DEPARTMENT 19 41110 19 Full -Time ParklRecs as o 21,093 0 0 21,250 1% 157 21,250 42110 19 03/31/07 4,600 Projected Proposed Proposed 0% - Audited Adapted 1 YTD Projected Actual vs Amended Amended 300 10% Actuals Budget Actuals Actual Adopted Amount Budget 102 210 FY 05108 FY 06107 FY 06107 FY 06107 FY 06/07 FY 06107 FY 06107 Comments PARKS & RECREATION - DEPARTMENT 19 41110 19 Full -Time ParklRecs 27,499 21,093 10,652 21,250 1% 157 21,250 42110 19 Medical Insurance 4,600 3,920 2,036 3,920 0% - _ 3,920 42111 19 Dental Insurance 300 272 142 300 10% 28 300 42130 19 LTDIAD&D/Life Insurance 227 199 102 210 6% 11 210 42210 19 Social Security 1,536 1,308 _ 588 1,275 -3% (33) 1,275 42220 19 Medicare 359 306 137 300 -2% (6) 300 42310 19 TMRS 2,013 _ 1,730 847 1,730 0% - 1,730 42510 19 Unemployment Taxes 135 101 0 25 -75% (76) 25 42610 19 Worker's Compensation 744 812 866 866 7% 54 866 43336_19 Contract Services 542 4,000 0 4,000 0% - 4,000 43340 19 Contract Irrigation Maint 1,504 3,000 1,487 3,000 0% - 3,000 43343 19 Contract Trail Maint 8,972 5,000 390 4,000 -20% (1,000) 4,000 43349 19 Cont Landscape - GW Fms 15,349 17,500 7,019 17,500 0% - 17,500 44222 19 Recreation Supplies 1,954 5,000 0 5,000 0% - 5,000 44306 19 Grounds Maintenance 6,154 10,000 677 10,000 _ 0% 10,000 45405 19 Advertising Public Notices 0 1,000 0 1,000 0% - 1,000 45911 19 GWF Park Maintenance 4,004 14,000 0 14,000 0% - 14,000 45912 19 HOC Projects 0 2,000 0 2,000 0% - 2,000 46120 19 Postage 6 0 0 0 0% - 46190 19 Misc. Expense (564) 500 0 500 0% - 500 46215 19 Vehicle Fuel/Maint 451 500 168 500 0% - _ 500 46220 19 Utilities Electric 15,659 12,000 3,566 11,350 -5% (650) 11,350 9 - TOTAL PARKS/RECREATION EXPI 91,4441 104,241 1 28,67$ 1 102,726 1 -1 % (1,516)1 102,726 INFORMATION TECHNOLOGY - DEPARTMENT 20 43265 20 Technology Consultant - IT 15,078 25,000 5,240 20,000 -20% (5,000) 20,000 43266 43267 20 20 SWIHW Maint Contracts System Admin & Support 8,548 15,375 13,000 20,000 7,528 4,936 11,000 20,000 -15% 09% (2,000) - We negotiated reduced rates for Cisco 3 year 11,000 contract 20,000 43405 43415 20 Computer Egpmt/Soft_ware 20 Website Dev/Maint 7,771 523 1 12,000 3,000 404 0 10,000 3,000 -17% 0% (2,000) - 10,000 3,000 DEPT 20 - TOTAL IIT EXPI 47,2941 73,000 1 18,108 1 64,000 42% (9,000)1 64,000 TOTAL EXPENDITURES1 5,113,727 1 3,813,258 1 1,580,467 1 3,864,772 1 1%1 54,6001 3,867,858 16 of 17 5/16/2007 11:04 AM FUND 0100 - General Fund Propos._- 3udget Amendments Y "KI&I 2.13MI1111 62580 99 Transfer Out to IDS 168,223 0 as o 0 %% - By year-end this transfer will be cleared with - repayment from 4B and PTR Fund sales receipts 62590 99 Transfer out to CP Fund 402,792 834,174 6,308 03/31/07 0% Projected Proposed Proposed 83,459 10,000 Audited Adopted I YTD Projected Actual vs Amended Amended 0 0 Actuals Budget Actuals Actual Adopted Amount Budget 59,340 L 844,174 1 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments Y "KI&I 2.13MI1111 62580 99 Transfer Out to IDS 168,223 0 53,032 0 0% - By year-end this transfer will be cleared with - repayment from 4B and PTR Fund sales receipts 62590 99 Transfer out to CP Fund 402,792 834,174 6,308 834,174 0% - 834,174 62600 99 Transfer Out to PCM Fund 83,459 10,000 0 10,000 0% - 10,000 62610 99 Transfer Out to SRF 4,784 0 0 0 0% - - DEPT 99 - TOTAL TRANSFERS OUT 669,2591 844,1741 59,340 L 844,174 1 0% 01 844,174 SPECIAL ITEMS 72500 99 TSH donation Xfr to WAF 0 0 150,000 150,000 100% 150,000 150,000 DEPT XX - TOTAL SPECIAL ITEMS 0 1 0 1 160,0001 150,000 100% 150,0001 150,000 SUMMARY Total Revenue 5,176,075 3,818,050 1,798,616 4,752,869 24% 547,779 4,365,829 Transfers In 2,265,391 50,000 14,412 57,648 15% 0 50,000 Total Expenditures 5,113,727 3,813,258 1,580,467 3,864,772 1% 54,600 3,867,858 Transfers Out 659,259 844,174 59,340 844,174 0% 844,174 Special Items 0 0 150,000 150,000 100% _0 150,000 150,000 NETI 1,668,479 (789,382) 23,221 1 (48,429)1 1 343,179 (446,203) CASH SUMMARY Beginning Cash 925,697 (A) 2,495,598 2,647,185 2,647,185 6% 151,587 2,647,185 _ B/S Affect to Cash 53,009 114,436 771,738 114,436 0% - 114,436 _ Revenues 5,176,075 3,818,050 1,798,616 4,752,869 24% 547,779 4,365,829 Inspection Fees/Bldg Permitsllnterest Transfers In 2,265,391 50,000 14,412 57,648 15% - 50,000 Expenditures 5,113,727 3,813,258 1,580,467 3,864,772 1% 54,600 3,867,858 Contracted inspection fees Transfers Out 659,259 844,174 59,340 844,174 0% - 844,174 Special Items 0 1 0 150,000 150,000 100% 150,000 150,000 Transfer of TSH funds to WAF NETJ 2,647,1851 1,820,652 1 3,442,1441 2,713,1931 1 494,766 2,315,418 (A) The transfer into Fund Balance from the dissolution of 4A funds in FY 05-06 will be used to fund this amount. This amount reflects the transfer out of capital project funds; i.e. $509K Civic Campus, $118K Roanoke/Ottinger Road Reconstruction, $200K FM 1938 Pedestrian crossing and $22K High School soccer field. 17 of 17 5/16/2007 11:04 AM FUND "00 - 413 Economic Development Corp rand Proposeu Budget Amendments REVENUES 31310 0 Sales Tax 905,353 750,000 294,735 884,205 36110 0 Interest Income 3,939 3,500 6 12 38805 0 IFA Debt Receipt from OF - 29,731 29,731 TOTAL REVENUE 909,25311 783,231 1 294,741 1 913,947 TRANSFERS OUT 18% Only 4 months are recorded due to accruals, we will be conservative and leave sales tax revenue 750,000 as originally budgeted All payments are being directed to GF for )) 500 repayment of debt payment earlier in year 29.731 Paid at vear-end Debt payment was made by GF but as revenues are realized the due to GF will be reduced and total debt payment should be made from 4B and 62580 0 Transfer Out to DS 1,210,411 783,231 ?Y C,,"' -'5v 780,231 0% (3,000) 780,231 PTR funds TRANSERS OUTI 1,210,411 11 783,231 1 226,852 1 780,231 1 0% (3,000)1 780,231 SUMMARY GASH SUMMARY Total Revenue 909,293 783,231 294,741 913,947 17% (3,000) 780,231 Transfers Out 1,210,411 783,231 226,852 780,231 0% (3,000) 780,231 7 -KKK I�1337 Transfers Out 1,210,411 5!16/2007 11:10 AM as of %% 03131/07 Projected Proposed Proposed Audited Adopted 1 YTD Projected Actual vs Amended Amended Actuals Budget Actuals Actual Adopted Amount Budget FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS REVENUES 31310 0 Sales Tax 905,353 750,000 294,735 884,205 36110 0 Interest Income 3,939 3,500 6 12 38805 0 IFA Debt Receipt from OF - 29,731 29,731 TOTAL REVENUE 909,25311 783,231 1 294,741 1 913,947 TRANSFERS OUT 18% Only 4 months are recorded due to accruals, we will be conservative and leave sales tax revenue 750,000 as originally budgeted All payments are being directed to GF for )) 500 repayment of debt payment earlier in year 29.731 Paid at vear-end Debt payment was made by GF but as revenues are realized the due to GF will be reduced and total debt payment should be made from 4B and 62580 0 Transfer Out to DS 1,210,411 783,231 ?Y C,,"' -'5v 780,231 0% (3,000) 780,231 PTR funds TRANSERS OUTI 1,210,411 11 783,231 1 226,852 1 780,231 1 0% (3,000)1 780,231 SUMMARY GASH SUMMARY Total Revenue 909,293 783,231 294,741 913,947 17% (3,000) 780,231 Transfers Out 1,210,411 783,231 226,852 780,231 0% (3,000) 780,231 7 -KKK I�1337 Transfers Out 1,210,411 5!16/2007 11:10 AM FUND '"10 - Visitors Association Fund Proposed audget Amendment REVENUE 31320 11 Hotel Occupancy Tax 415,544 as of 210,600 %% 7% Avg of $36,221 in PY for summer months; but with the Southlake Hilton opening, will be - 400,000 conservative and leave budget as is 34133 11 Special Event Revenue 5,000 0 03/31107 0 Projected Proposed Proposed Historical Board Revenue 19,052 Audited Adopted 1 YTD Projected Actual vs Amended Amended 6,910 6,000 Actuals Budget Actuals Actual Adopted Amount Budget 1 40,000 24,369 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments REVENUE 31320 11 Hotel Occupancy Tax 415,544 400,000 210,600 427,926 7% Avg of $36,221 in PY for summer months; but with the Southlake Hilton opening, will be - 400,000 conservative and leave budget as is 34133 11 Special Event Revenue 5,000 0 0 0 0% - - 34142 11 Historical Board Revenue 19,052 5,000 425 5,000 0% - 5,000 34143 11 Tree City Income 6,910 6,000 7,956 8,000 33% 2,000 8,000 36110 11 Interest Earned 37,060 1 40,000 24,369 40,000 0% 5,000 45,000 0 TOTAL REVENUEJ 483,566 1 461,0001 243,350 1 480,926 6.647/. 7,000 1 458,000 EXPENDITURES 41110 0 Full -Time 66,863 1 0 0 0 0% 42110 0 Medical Insurance 5,884 0 0 0 42111 0 Dental Insurance 344 0 0 0 42130 0 LTD/AD&D/Life Insurance 566 0 0 0 42210 0 Social Security 3,931 0 0 0 42220 0 Medicare 919 0 0 0 42310 0 TMRS 4,849 0 0 0 42510 0 Unemployment Taxes 270 0 0 0 42610 0 Worker's Compensation 151 1 0 0 0 TOTAL VISITOR PAYROLLI 83,7791 01 0 0 41110 11 Full -Time Regular 6,466.17 7,621 4,205 8,025 42110 11 Medical Insurance 618.48 720 351 720 42111 11 Dental Insurance 63.14 49 38 75 42130 11 LTDIAD&D/Life Insurance 53.85 68 36 72 42210 11 Social Security 392.59 472 258 500 42220 11 Medicare 91.87 111 60 120 42310 11 TMRS 473.45 625 333 650 42510 11 Unemployment Taxes 40.50 41 0 25 42610 11 Worker's Compensation 28.97 23 25 25 43205 11 Administrative Expense 25,879.29 39,484 20,719 41,107 43250 11 Auditor 3,750.00 3,525 3,525 3,525 43310 11 Boyle & Lowry 562.50 0 248 250 43415 11 Website Development / Maint. - 2,500 0 2,500 0%n 0%n 0% 0% 0% 0% 0% 0% }.00%0 5% 404 0% - 53% 26 6% 4 6% 28 8% 9 4% 25 -39% (16 9% 2 4% 1,623 0%n 100% 250 0% 8,025 720 75 72 500 120 650 25 - 25 41,107 Proportionate increase from salary 3,525 250 Site plan & zoning issues - Marriott 2,500 1 of 4 5/16/2007 11:11 AM FUND "10 - Visitors Association Fund Proposes Budget Amendment 2 of 4 5/16/2007 11:11 AM as of %% 43505 11 Historical Board 03131/07 20,000 Projected Proposed Proposed 20,000 Audited Adopted YTD Projected Actual vs Amended Amended 0% Actuals Budget Actuals Actual Adopted Amount Budget 0 0% FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 FY 06107 Comments 2 of 4 5/16/2007 11:11 AM 43505 11 Historical Board 5,364.79 20,000 1,692 20,000 0% 20,000 43510 11 Tree City USA 8,223.60 6,000 4,704 6,000 0% 6,000 43515 11 Community Services 620.61 0 0 0 0% 43526 11 Masterworks 3,000.00 3,750 3,750 3,750 0% 3,750 43529 11 Marriott Marketing 48,000.00 0 0 0 100% 43530 11 Marriott Transportation 156,000.00 50,000 10,000 50,000 0% 50,000 43531 11 Marketing & Promotions 1,025.00 4,000 689 4,000 0% 4,000 44310 11 Application Software - 0 109 110 100% 110 110 Annual support for AS400 for GL - 15% 44410 11 Office Rent - 11,095 0 11,095 0% 11,095 45305 11 Telephone Service 1,335.17 1,960 746 1,960 0% 1,960 45310 11 Mobile Phone 247.27 0 104 225 100% 22 5 225 Allocation of phone exp (15%Q) 45610 11 Special Events 2,352.32 500 3,819 6,000 1100% 5,500 6,000 Added Time Capsule @ $2,200 & Sealing of Time Capsule @ $2,850 45805 11 45830 11 Travel Airfare Training/Seminars/Meetings 124.10 496.00 0 0 0 0 0 0 100% 100% - - - 46105 11 Office Supplies 271.71 0 333 350 100% 350 350 Allocation for new printer (15%) 46115 11 Dues & Subscriptions 969.95 0 275 275 100% 275 275 "The Quorum" subscription 46120 11 Postage & Supplies 338.54 500 142 500 0% 500 46.125 11 Printing - 500 0 500 0% 500 46140 11 Moving Expense - 2,500 0 2,500 0% 2,500 46190 11 Misc. Expense - 4,500 0 4,500 0% 4,500 46205 11 Utilities Water 786.80 1,061 106 1,061 0% 1,061 46220 11 Utilities Electric 2,767.25 3,402 679 3,402 0%" 3,402 46225 11 Utilities Gas 446.23 1,122 261 1,122 0% 1,122 47411 11 Mechanical Equipment 7,262.52 0 0 0 0% - 47413 11 Computer Hardware/Software - 5,125 0 5,125 0% 5,125 47415 11 Fumiture/Fixtures - 12,500 0 12,500 0% 12500 Will be used during Solana move TOTAL ADMINISTRATIVEI 278.052.6711 183,7641 57,2091 192,569 1 4.80%1 8,8161 192,569 2 of 4 5/16/2007 11:11 AM FUND `-10 - Visitors Association Fund Proposed Idudget Amendment 41110 18 Salaries Finance/HR 23,504 as of 14,419 %% 0% 7,031 1,307 41110 17 Salaries Facilities 0 7,031 03/31/07 7,031 Projected Proposed Proposed Medical insurance 0 Audited Adopted 1 YTD Projected Actual vs Amended Amended 0 0 91 66 Actuals Budget Actuals Actual Adopted Amount Budget 436 166 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments 41110 18 Salaries Finance/HR 23,504 30,123 14,419 30,123 0% 7,031 1,307 41110 17 Salaries Facilities 0 7,031 3,015 7,031 0% 7,031 42110 17 Medical insurance 0 1,307 547 1,307 0% 1,307 42111 17 42130 17 Dental Insurance LTD/AD&D/Life Insurance 0 0 91 66 38 27 91 66 0% 0% 91 66 42210 17 Social Security 0 436 166 436 0% 436 42220 17 Medicare 0 102 39 102 0% 102 42310 17 TMRS 0 577 242 577 0% 577 42510 17 Unemployment Taxes 0 34 0 34 0% 34 42610 17 Worker's Compensation 0 271 0 271 0% 271 Tf1TA1 CA9-11 171C0 DAV091 1 n a 044 A n7A 4 0114 A nn��. _ 9_Q15 41110 18 Salaries Finance/HR 23,504 30,123 14,419 30,123 0% 7,031 1,307 30,123 41120 18 Overtime Finance/HR 1,231 1,125 574 1,125 0%4 42130 19 1,125 42110 18 Medical Insurance 2,416 2,975 1,440 2,975 0% Social Security 2,975 42111 18 Dental Insurance 147 213 103 213 0% 0 213 42130 18 LTD/AD&D/Life Insurance 195 297 135 297 0% 577 297 42210 18 Social Security 1,448 1,868 887 1,868 0% 0 0 1,868 42220 18 Medicare 338 437 207 437 0% 0.00% 437 42310 18 TMRS Finance/HR 1,811 2,470 1,203 2,500 1% 30 2,500 42510 18 Unemployment Taxes 120 150 0 50 -67% (100) 50 42610 18 Worker's Compensation 74 106 93 95 -10% (11) 95 TOTAL FINANCE PAYROLLI 31.28511 39,764 1 19,061 1 39,683 1 -0.20% (81)1 38,683 41110 19 42110 19 Full -Time Regular Medical Insurance 0 0 7,031 1,307 3,015 547 7,031 1,307 0% 0% 7,031 1,307 42111 19 Dental Insurance 0 91 38 91 0% 91 42130 19 LTD/AD&D/Life Insurance 0 66 27 66 0% 66 42210 19 Social Security 0 436 166 436 0% 436 42220 19 Medicare 0 102 39 102 0% 102 42310 19 TMRS 0 577 242 577 0%fl 577 42510 19 42610 19 Unemployment Taxes Worker's Compensation 0 0 34 271 0 0 34 271 0% 0% 34 271 TOTAL PARKSIREC PAYROLL 0 1 9,915 -4,0-7-41 9,915 1 0.00% 9,915 TOTAL EXPENDITURESI 393,11611 243,3481 84,418 1 252,082 1 3.69%1 8,7341 252,082 3 of 4 5116/2007 11:11 AM FUND O-''0 - Visitors Association Fund Proposed Idudget Amendment SUMMARY Total Revenues Total Expenditures 483,566 393,116 451,000 243,348 as of 480,926 252,082 %% 7,000 8,734 45$,000 252,082 NET 90,449 207,652 1f:-8,33 1 03131/07 10.21% Projected Proposed Proposed Audited Adopted YTD Projected Actual vs Amended Amended 828,593 863,720 Actuals Budget Actuals Actual Adopted Amount Budget (20,605) 243,350 84,418 0 480,926 252,082 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 Comments SUMMARY Total Revenues Total Expenditures 483,566 393,116 451,000 243,348 243,350 84,418 480,926 252,082 6.64% 3.59% 7,000 8,734 45$,000 252,082 NET 90,449 207,652 1f:-8,33 1 228,844 1 10.21% (1,734)1 205,918" CASH SUMMARY_ Beginning Balance 771,233 828,593 863,720 863,720 4% 35,127 863,720 BIS Affect to Cash Total Revenue Total Expenditures 2,038 483,566 393,116 0 451,000 243,348 (20,605) 243,350 84,418 0 480,926 252,082 0% 7% 4% 7,000 8,734 - 458,000 252,082 NETTOTALI 863.720 1.036.245 i. ti 'F',.1! J 1 1,092,564 1 33,393 1 1,069,638 4 of 4 5/16/2007 11:11 AM FUND "'50 - Special Revenue Grant Fund Proposeu judget Amendments REVENUES 250.34005.00 Federal Funds 43,047 - - - as of - %% 250.34006_.00 State Funds - 12,550 100% 12,550 Received unexpected 100% grant from Texas 12,550 Commission on Fire Protection 03131/07 43,047 Projected Proposed Proposed 12,550 11 71 EXPENDITURES Audited Adopted 1 YTD Projected Actual vs Amended Amended - - 0% Actuals Budget Actuals Actual Adopted Amount Budget - 250.46605.14 Uniforms/Personal Gear 250.44213.14 Fire Fighter Supplier FY 05106 FY 06107 FY 06/07 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS REVENUES 250.34005.00 Federal Funds 43,047 - - - 0% - - 250.34006_.00 State Funds - 12,550 100% 12,550 Received unexpected 100% grant from Texas 12,550 Commission on Fire Protection TOTAL REVENUE 43,047 1 12,550 100% 12,550 1 12,550 11 71 EXPENDITURES 250.46620.00 FY 2006 FEMA 10% 4,784 - - - 0% - - 250.46621.00 FY 2006 FEMA 90% 43,047 - - 0% - - 250.46605.14 Uniforms/Personal Gear 250.44213.14 Fire Fighter Supplier - - 11,200 - 1,350 100% 100% 11,200 1,350 11,200 1,350 TOTAL EXPENDITURES 47,831 12,550 100% 12,550 12,550 OTHER SOURCES & USES 250.52510.88 Xfr In from Gen. Fund -2006 4,784 - - 0% - - TRANSPERSINJ 4,784 0% SUMMARY 1 oral txpenaaures '+r,00 CASH SUMMARY Beginning Cash Balance Sheet Affect to Cash 0 - 0 - _ 0% - - - - 0% Revenues 43,047 - - 12,550 0% 12,550 12,550 Expenditures 47,831 - - (12,550) -1009% (12,550) 12,550 Transfers In 4,784 - - 0% - - _ RIFT TnTAI I n - .511612007 11:11 AM FUND "RO - Property Tax Reduction Fund Proposeu judget Amendments REVENUES as of %% Only 4 months are recorded due to accruals; 03131/07 Projected Proposed Proposed we will be conservative and leave sales tax 31310 0 Sales Tax Audited Adopted 1 YTD Projected Actual vs Amended Amended revenue as originally budgeted _ Actuals Budget Actuals Actual Adopted Amount (Budget Beginning year revenue is being transferred back to FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS REVENUES CASH SUMMARY Beginning Balance - - 0.00% - B15 Affect to Cash - (68,412) - 0.00% Revenues 0 753,500 295,072 885,705 17.55% (2,000) 751,500 Transfers Out 0 598,953 226,322 554,125 -7.48% (44,828) 554,125 5/16/2007 11:12 AM Only 4 months are recorded due to accruals; we will be conservative and leave sales tax 31310 0 Sales Tax 0_ 750,000 294,735 884,205 17.89% - 750,000 revenue as originally budgeted _ Beginning year revenue is being transferred back to the GF for repayment of first debt service payment in November when there were no funds in this fund yet; therefore, the interest is being paid in the GF vs this 36110 0 Interestlncome 0 3,500 337 1,500 -57.14%m (2,000) 1,500 fund TOTAL REVENUEJ 01 753,5001 295,072 1 885,705 1 17.55% (2,000)1 751,500 TRANSFERS OUT he 2007 Refunded bonds, payments from 62580 0 Transfer Out to DS 0 598,953 226,322 554,125 -7.48% (44,828) 554,125 L4Bandthis fund are reduced by the savings TRANSERS OUTI 0 698,9531 226,322 1 554,125 -1.48% (44,828)1 554,125 SUMMARY _ Total Revenue 0 753,500 295,072 885,705 17.55% (2,000) 751,500 Transfers Out 0 598,953 226,322 554,125 -7.48% (44,828) 554,125 CASH SUMMARY Beginning Balance - - 0.00% - B15 Affect to Cash - (68,412) - 0.00% Revenues 0 753,500 295,072 885,705 17.55% (2,000) 751,500 Transfers Out 0 598,953 226,322 554,125 -7.48% (44,828) 554,125 5/16/2007 11:12 AM FUND ''10 - Debt Service Fund Proposes Judget Amendments EXPENDITURES 46135 00 Bank Service Charge 830 as of 530 %% 0.00% - 830 48840 00 48850 00 Debt Pymt - Principal Debt Pymt- Interest 350,000 1,027,804 03/31/07 - 505,677 Projected Proposed Proposed 470,000 Principal pymt made May 1st 863,826 Net svgs from 2007 Bond Refunding ($47K) Audited Adopted 1 YTD Projected Actual vs Amended Amended 1,334,656 TRANSFERSIN 52510 88 Xfr In from General Fund 52560 88 Xfr In from 4B Fund Actuals Budget Actuals Actual Adopted Amount Budget 52600 88 Xfr In from PTR Fund FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 FY 06107 COMMENTS EXPENDITURES 46135 00 Bank Service Charge 830 830 530 830 0.00% - 830 48840 00 48850 00 Debt Pymt - Principal Debt Pymt- Interest 350,000 1,027,804 370,000 1,011,354 - 505,677 470,000 863,826 27.03% 44.59% 100,000 (147,528) 470,000 Principal pymt made May 1st 863,826 Net svgs from 2007 Bond Refunding ($47K) TOTAL EXPENDITURES 1,378,634 1,382,1841 506,2071 1,334,656 -3.44% (47,528)1 1,334,656 TRANSFERSIN 52510 88 Xfr In from General Fund 52560 88 Xfr In from 4B Fund 168,223 1,210,411 - 783,231 53,032 226,852 - 780,231 0.00% -0.38% - (3,000) 780,231 52600 88 Xfr In from PTR Fund - 598,953 226,322 554,425 -7.43% (44,528) 554,425 TRANSFERS IN 1,378,634 1,382,184 506,207 1,334,656 -3A4% (47,528) 1,334,656 SUMMARY Total Expenditures 1,378,634 1,382,184 506,207 1,334,656 -3.44% (47,528) 1,334,656 Transfers In 1,378,634 1,382,184 506,207 1,334,656 -3.44% (47,528) 1,334,656 NFT TnTAI I Inti - CASH SUMMARY Beginning Cash - - - 0.00% - Balance Sheet Affect to Cash - - 0.00% - Expenditures 1,378,634 1,382,184 506,207 1,334,656 -3.44% (47,528) 1,334,656 Transfers In 1,378,634 1,382,184 506,207 1,334,656 -3.44% (47,528) 1,334,656 NFT TnTA1 I n - I - 5/16/2007 11:12 AM FUND "10 - Capital Projects Fund Proposea ,dudget Amendments Payment for FM 1938 from Maguire Partners received: No Foundation funds expected by year - 33700 0 Private Contributions 150,000 1,176,818 246,353 246,353 -79% (930,465) 246,353end TOTAL REVENUEJ 150,000 1,176,816 1 246,3631 246,353 -79% (930,466)1 246,383 TRANSFFRSIN 52510 88 Transfer In from GF 402,792 834,174 6,308 834,174 0% 0 834,174 52560 88 Transfer in from OF 15,000 - 15,000 0% 0 15,000 52570 88 Transfer in from -4A 67,976 - - - 0% 0 TRANSERS IN 470.769 849.1741 6,3081 849.174F-0%1 01 849,174 OTHER RESOURCES 2007 Visitors Assoc COs - - 2,500,040 100% 2,500,000 2,500,000 Bond proceeds TOTAL OTHER RESOURCES 608.435 1 2,500,000 1 100%1 2,500,000 1 2,500,000 EXPENDITURES 43215 0 Eng - FM1938 (114/1709) as of 0 %% 72000 0 Art/Science Center 73000 0 Temporary Parking 03131/07 0 Projected Proposed Proposed RoanokelOttinger Reconstruct 74400 Audited Adopted 1 YTD Projected Actual vs Amended Amended 0 200,000 Actuals Budget Actuals Actual Adopted Amount Budget 1,187,034 2,408,493 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS Payment for FM 1938 from Maguire Partners received: No Foundation funds expected by year - 33700 0 Private Contributions 150,000 1,176,818 246,353 246,353 -79% (930,465) 246,353end TOTAL REVENUEJ 150,000 1,176,816 1 246,3631 246,353 -79% (930,466)1 246,383 TRANSFFRSIN 52510 88 Transfer In from GF 402,792 834,174 6,308 834,174 0% 0 834,174 52560 88 Transfer in from OF 15,000 - 15,000 0% 0 15,000 52570 88 Transfer in from -4A 67,976 - - - 0% 0 TRANSERS IN 470.769 849.1741 6,3081 849.174F-0%1 01 849,174 OTHER RESOURCES 2007 Visitors Assoc COs - - 2,500,040 100% 2,500,000 2,500,000 Bond proceeds TOTAL OTHER RESOURCES 608.435 1 2,500,000 1 100%1 2,500,000 1 2,500,000 EXPENDITURES 43215 0 Eng - FM1938 (114/1709) 72000 0 Civic Campus Expansion 72000 0 Art/Science Center 73000 0 Temporary Parking 74400 0 Hwy 114 Development (Mall) 74400 0 RoanokelOttinger Reconstruct 74400 0 FM1938 Pedestrian Crossing 74400 0 Hiqh School Soccer Field SUMMARY 78,609 99,860 258,930 509,000 6,308 509,000 1,176,818 112,931 - 77,483 - - 118,174 2.00,000 22,000 13,462 99,860 0% 0 99,860 6,308 509,000 0% 0 509,000 - 238,000 -80% (938,818) 2382000 Construction to - - 0% 0 - _ - 0%° 0 - - 118,174 0% 0 118,174 - 200,000 0% 0 200,000 - 22,000 0% 0-22,00- 22,0019,770 19,770 1,187,034 -44% (938,818)1 1,187,034 later than Total Revenue 150,000 1,176,818 246,353 246,353 -79% (930,465) 246,353 Transfers In 470,769 849,174 6,308 849,174 0% 0 849,174 Other Resources - - 2,500,000 100% 2,500,000 2,500,000 Total Expenditures 527,953 2,125,852 19,770 1,187,034 -44% (938,818) 1,187,034 NET TOTALI 93,816 11 (99,860)1 232,891 1 2,408,493 -2512-/.L 2,508,3631 2,408,493 5116/2007 11:14 AM FUND "10 -Capital Projects Fund Proposed Budget Amendments CASH SUMMARY _ as of - %% 274,326 Revenues 150,000 Transfers In 470,_769 03/31/07 849,174 Projected Proposed Proposed 2,125, 852 Audited Adopted 1 YTD Projected Actual vs Amended Amended Actuals Budget Actuals Actual Adopted Amount Budget FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 COMMENTS CASH SUMMARY _ Beginning Balance - B13 Affect to Cash 274,326 Revenues 150,000 Transfers In 470,_769 Other Resources 849,174 Exoenditures 527,953 99,860 367,142 367,142 - (259,293) - 1,176,818 246,353 246,353 849,174 6,308 849,174 - 2,500,000 2,125, 852 19,770 1,187,034 340,741 ,635 1 268% 0 367,142 $1 0% 0 (264,455) -79% (930,465) 246,353 0% 0 849,174 100% 2,500,000 2,500,000 -44% (938,818) 1,187,034 r-2,5-09,353 1 2,511,180 lin 18 FM 1938; $264,455 A/P 5/1612007 11:14 AM CAPITAL PROJECT (AMENDED) FY 2006/2007 Westlake Performing Arts & Science Center Phase I of the Westlake Performing Arts & Science Center will include the shell of the building, basic climate control systems and power requirements. Phase II will include the interior finish of the black box and science labs with all school related improvements to be funded with Westlake Academy Foundation contributions. The Town is issuing the CO's with the ex ectation of being re aid by the Foundation. N E T 01 2,262,000 1 (1,762,000)1 0 1 0 10 CAPITAL PROJECT EXPENDITURES OPERATING BUDGET YTD THRU 09130/06 BUDGET FY06/07 FUTURE CAPITAL EXPENDITURES 07108 08109 1 09110 FUTURE FUNDING 07108 1 08109 1 PROJECT TOTAL 05 Purchase 0 0 0 0 0 0 10 Design 0 110,000 276,000 0 0 386,000 15 Construction 0 20,000 1,743,591 0 0 1,763,591 20 Implementation 0 0 200,000 0 0 200,000 25 Engineering 0 100,000 34,409 0 0 134,409 30 Legal 0 8,000E 8,000 0 0 16,000 35 Auditor I 0 0 0 0, 0 0 40 Payroll & Related 1 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical 0 0 0 0 0 0 60 Postage/Shipping 0 0 0 0 0 0 65 Copies/Reproduction 0 0 0 0 0 0 70 Public Advertisements 0 0 0 0 i 0 0 71 Science Labs 00 500,000 0 0 'i 500,000 PROJECT EXPENDITURE TOTAL 0 238,000 2,262,000 01 01 3,000,000 N E T 01 2,262,000 1 (1,762,000)1 0 1 0 10 CAPITAL PROJECT FUNDING OPERATING BUDGET YTD THRU 09/30/06 I BUDGET FY06/07 FUTURE FUNDING 07108 1 08109 1 09110 PROJECT TOTAL General Fund 0 0 0I 0 0 1 0 Utility Fund 0 0 0 0 0 0 2007 Visitor Association CO 0 2,500,000: 0 0 0 2,500,000 Westlake Academy Foundation 0 0 500,000 0 0 500,000 PROJECT FUNDING TOTAL 0 2,500,000 500,000 Q 0 3,000,000 N E T 01 2,262,000 1 (1,762,000)1 0 1 0 10 IMPACT ON OPERATING BUDGET Town Portion BUDGET Visitors Assn FY06107 FUTURE OPERATING EXPENDITURES 07108 08109 09110 PROJECT TOTAL Supplies (Paper, Etc) 15% 0 750 t,500 1,500 3,750 Maintenance (HVAC, Ldscape,etc) I 100% 0 5,000 30,000 30,000 65,000 Services (Cleaning) I 50% 0 2,500 5,000 5,000 12,500 Equipment (Lighting, AV) 50% 0 0 4,000 4,000 8,000 OPERATING IMPACT TOTAL 0 8,250 40,500 40,500 89,250 FUND -10 - Utility Fund Proposed oudget Amendments REVENUE S S 33700 11 Private Contributions as of - %%q 0.00% - 03131107 Projected Proposed Proposed Audited Adopted 1 YTD Projected Actual vs Amended Amended Actuals Budget Actuals Actual Adopted Amount Budget FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS REVENUE S S 33700 11 Private Contributions 19,653 - - 0.00% - Increased wet weather and cooler temperatures has reduced the need for water. - However consumption will increase during summer months as well as an increase in the number of homeowners occupying 34410 11 Water Revenue 1,375,827 1,843,438 390,741 1,843,438 0.00% 1,843,438 newly constructed houses 34411 11 DS-Hillwood Service Area Acct 39,699 44,000 11,957 39,991 -9.11% - 44,000 34412 11 DS -Town Service Area Accts 40,4.01 36,000 11,032 39_,933 10.93% 36_,000 Sewer charges for residents are based on new annual average consumption and an increase in the number of homeowners occupying newly constructed 34420 11 Sewer Revenue 301,843 323,750 129,505 330,934 2.22% - 323,750 houses 34421 11 Sewer Revenue - Keller 845 1,200 379 996 -16.99% 1,200_ Increased revenue to match increase in water tap 34430 11 Water Tap Fees 36,450 40,000 23,925 47,850 19.63% 6,000 46,000 expenditure = $6,000. 34440 11 Sewer Tap Fees 9,510 15,000 7,125 14,250 -5.00% - 15,000 Increase in number of water taps at beg. of year; 34450 11 Fort Worth Impact fees 35,319 50,000 32,532 65,064 30.13% - 50,000 should slow down. 34470 11 Meter Repair/Replacement 2,346 2,000 1,235 2,470 23.50% 2,000 4,000 Increased revenue to match expenditure 11 Interest Earned 25,601_ 25,000 19,307 38,615 54.46% 15,000 40,000 Avg of $700K for remaining portion of FY _36110 36200 11 Duct Bank Leases 25,949 - - - 0.00% - - - Reclass of this line -item to proper revenue 39400 11 Misc Revenue 30,076 11,500 - - -100.00% (8,000) 3,500 1 (overpayment on statements) TOTAL REVENUE 1 1,943,518 1 2,391,888 627,738 2,423,541 1.32%1 15,0001 2,406,888 TRANSFERSIN PY transferred to PCMF; should have created Dept in 11 Transfers in from PCMF - 10,000 100.00% 10,000 10,000 OF and restricted funds in same fund TnTAI TRAMgFFRS IN 1 10.000loo.00%1 10.000 10,000 1 of 6 5117/2007 9:32 AM FUND !"-f) - Utility Fund Proposed oudget Amendments EXPENSES 20,188 41,268 as of - %°% 33,861 42110 - Medical Insurance Utility 7,044 42111 03/31107 Dental Insurance Utility Projected Proposed Proposed LTDIAD&D1Life Insurance Utilit 272 Audited Adopted 1 YTD Projected Actual vs. Amended Amended 410 42310 Actuals Budget Actuals Actual Adopted Amount Budget 42610 - FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS EXPENSES 20,188 41,268 41110 - Full -Time Regular Utility 33,861 42110 - Medical Insurance Utility 7,044 42111 - Dental Insurance Utility 450 42130 - LTDIAD&D1Life Insurance Utilit 272 42210 - Social Security Utility 1,753 42220 - Medicare Utility 410 42310 - TMRS Utility 2,478 42510 - Unemployment Taxes Utility 203 42610 - Worker's Compensation Utility 1,164 0.00% - TOTAL UTILITY PAYROLL_ 47,635 - 25 -87.68% (178) 41110 11 Full -Time Regular Admin 6,_466 42110 11 Medical Insurance Admin 673 42111 11 Dental Insurance 63 42130 11 LTDIAD&DlLife Insurance Adrr 54 42210 11 Social Security Ad min 393 42220 11 Medicare Admin 92 42310 11 TMRS Admin 473 42510 11 Unemployment Taxes admin 41 42610 11 Worker's Compensation 29 43205 11 Administrative Expense 25,879 5.88% 4 TOTAL ADMIN PAYROLL 34,163 2.58 500 5.93% 28 S S S 41,268 20,188 41,268 0.00% - 41,268 7,839 2,780 6,000 -23.46% (1,839) 6,000 545 271 545 0.00% - 545 383 191 383 -0.03% - 383 2,559 1,140 2,300 -10.12% (259) 2,300 598 267 550 -8.03°% (48) 550 3,384 1,608 3,384 0.00% - 3,384 203 - 25 -87.68% (178) 25 1,765 1,390 1,800 1.98% 35 1,800 58,5441 27,836 1 56,255 -3.91% (2,289)F-56,255 43405 16 Computer EgpmtlSoftware - 2,000 7,621 4,206 8,025 5.30% 404 8,025 720 351 720 0.00% - 720 49 38 85 73.47% 36 85 68 36 72 5.88% 4 72 472 2.58 500 5.93% 28 500 111 60 120 8.11% 9 120 625 333 650 4.00% 25 650 41 will increase during summer months and an increase 25 -39.02% (16) 25 23 25 25 8.70% 2 25 89,771 47,089 93,426 4.07% 3,655 93,426 99.501 1 52.397 1 103.6481 4.17%1 4,1471 103,648 43215 16 Civil Engineering 1,265 5,000 2,455 4,911 -1.79% - 5,000 43224 16 Water Utility Engineering 4,860 15,000 2,146 4,292 -71.39% (10,000) 5,000 Majority of exp. is now coded to actual project 43250 16 Auditor 3,750 3,525 3,525 3,525 0.00% - 3,525 43305 16 Legal Fees - - 10,000 100.00% 10,000 10,000 Solana MUD 1 Reviews 43310 16 Boyle & Lowry 4,219 15,000 638 1,275 -91.50% - 15,000 43335 16 Contracted Labor - 7,000 - 7,000 0.00% 7,040 43405 16 Computer EgpmtlSoftware - 2,000 2,000 0.00% - 2,040 43533 16 Photo Supplies - 50 - 50 0.00% - 50 Increased wet weather and cooler temperatures has reduced the need for water. - However consumption will increase during summer months and an increase in the number of homeowners occupying newly 44105 16 Water Purchases 511,672 695,610 600 101,819 200 695,610 600 0.00% 0.00% - 695,610 - 600 constructed houses 44106 16 Water Service Charge 600 44110 16 Peak Payment 237,648 257,376 76,409 257,376 0.40°x6 - 257,376 44111 16 Water Tower Landscape Maint 6,400 - 6,000 4.00°% - 6,000 1 Payment upon receipt of invoice from Keller 2 of 6 5/17/2007 9:20 AM FUND'"10 - Utility Fund Proposea _.adget Amendments 44112 16 Water Main Maintenance as of 10,000 %% 12,656 26.56% 5,000 15,000 Unusually high number of repairs to fire hydrants and water mains. Previous year contained substantial repair to 16" water line. 44113 03131107 Tower Maintenance Projected Proposed Proposed 1,000 0.00% Audited Adopted 1 YTD Projected Actual vs Amended Amended 2,500 850 Actuals Budget Actuals Actual Adopted Amount Budget TRA -Wastewater Treatment 131,398 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS 44112 16 Water Main Maintenance 44,417 10,000 6,328 12,656 26.56% 5,000 15,000 Unusually high number of repairs to fire hydrants and water mains. Previous year contained substantial repair to 16" water line. 44113 16 Tower Maintenance - 1,000 - 1,000 0.00% - 1,000 Inspection to be made in summer 44114 16 Sewer Main Maintenance 662 2,500 850 1,700 -32.00% - 2,500 Repairs to be made during summer 44115 16 TRA -Wastewater Treatment 131,398 170,000 75,134 144,946 -14.74% - 170,000 An increase in the number of homeowners occupying newly constructed houses 44116 16 Pump Station Landscape Main 118 200 2,000 1,500 - - 570 118 2,000 1,140 -41.12% 0.00°% -24.02°% - - 9,000 200 2,000 10,500 Increased by $9,000 to include SCADA installation for Vaquero lift station. Vaquero to contribute approximately 50°% of the cost. 44117 16 Lift Station Maintenance 996 44118 16 Instrument Maintenance 2,259 44119 16 Ground Storage Tank Maint - 2,000 - 2,000 0.00°% - 2,000 44120 16 Southlake Wastewater Trealmc 2,338 50,000 3,318 50,000 0.00°% - 50,000 Payment upon receipt of invoice from Southlake 44121 16 Generator Maintenance - 1,500 1,265 1,500 0.00% - 1,500 44122 16 Testing-Water/Bacteria/Rgitry 583 300 2,515 3,000 900,00% 2,700 3,000 This includes new state testing requirements that were not previously budgeted 44123 16 Pump Station R&M 14,067 14,000 2,740 14,000 0.00°% - 14,000 44124 16 Duct Bank R&M - - - 1,500 0.00°% 1,500 1,500 New line item created as a result of anticipated maintenance of aging infastructure 44130 16 Meter Repair & Replacement 900 2,000 2,713 4,000 100.00°% 2,000 4,000 This item includes routine replacement of exisitng meters. It also includes repairs to meters and meter boxes damaged by builders with off setting revenue. Increase to $4,000. 44135 16 Utility Billing 2,468 2,900 751 2,500 -13.79% (400) 2,500 44210 16 Facility Supplies 50 50 1,500 - 8 232 50 50 463 0.00°% 0.00% -69.13% - - - 50 50 1,500 44211 16 Safety Equipment 44220 16 Line Location 685 44226 16 Misc Hand Tools 86 500 - 500 0.00°% - 500 44227 16 Chemical Supplies 688 500 - 500 0.00% - 500 44306 16 Grounds Maintenance 478 - - - 0.00°% - - 44310 16 Application Software Maint. 2,181 1,950 1,609 1,950 0.00% - 1,950 44312 16 Keller Waste Water 631 1,200 351 701 -41.58% - 1,200 44410 16 Office Rent 11,095 - 12,572 13.31% 1,477 12,572 Solana Rent (May - Sept @ $2,514) 25% allocation of total lease 45214 16 Insurance Automobile 464 488 600 600 22.95°% 112 600 Actual paid in full 45215 16 Insurance Property 3,239 3,401 2,844 2,844 -16.38% (557) 2,844 Actual paid in full 45305 16 Telephone Service 1,335 1,936 746 1,600 -17.36x% (336) 1,600 45310 16 Mobile Phone 930 900 429 858 -4.64°% - 900 45325 16 Misc Rental - 92 95 0.00% 95 95 Jackhammer for water service repair 45810 16 Travel Car Rental/Parking 7 - 10 20 0.00°% 20 20 Parking fees when going to Courthouse 3 of 6 5117/2007 9:29 AM FUND lr^l - Utility Fund Proposed rddget Amendments 45825 16 Travel Mileage as of - %% - 0.00% - - 45830 03/31/07 Training/Seminars/Meetings Projected Proposed Proposed 800 0.00% Audited Adopted 1 YTD Projected Actual yrs Amended Amended - 119 Actuals Budget Actuals Actual Adapted Amount Budget Office Supplies 107 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS 45825 16 Travel Mileage 204 - - - 0.00% - - 45830 16 Training/Seminars/Meetings 709 800 - 800 0.00% - 800 45901 16 Audio Visial Equipment - - 119 119 0.00% 119 119 This was for the purchase of digital camera. No additional purchases expected. 46105 16 Office Supplies 107 150 468 935 523.65% 785 935 % of New Printer; new office set-up 46115 16 Dues & Subscriptions 210 100 - 100 0.00% - 100 46120 16 Postage 412 600 85 450 -25.00% (150) 450 46125 16 Printing 450 500 116 500 0.00% - 500 46140 16 Moving Expense - 2,500 - 2,500 0.00% - 2,500 46205 16 Utilities Water 787 1,008 6,000 106 1,151 750 6,000 -25.60% 0.00% (258) - 750 6,000 Consumption will increase during summer months 46206 16 Water - Pump Station 6,678 46215 16 Vehicle Fuel/Maint 2,033 4,000 1,230 4,000 0.00% - 4,000 46220 16 Electric - Town Allocation 2,726 4,032 679 2,394 -40.62% (2,407) 1,625 $261 actual thru April - May -Sept $625 at Solana 46221 16 Electric - Pump Station 55,220 83,870 - 13,912 79 83,870 198 0.00% 0.00% - 150 _ 83,870 150 Increased wet weather and cooler temperatures has reduced the need for water. - However consumption will increase during summer months; Electricity rate increase 46222 16 Electric - Online Meter 118 46225 16 Gas - Town Allocation 487 840 261 261 -68.93% (579) 261 $261 actual thru April - May -Sept ak Solana _ 46605 16 Uniforms 267 300 139 279 -7.07% - 300 47105 16 Depreciation Expense 415,329 - _ - - - - - - - 0.00% 0.00% 0.00% - - - - - 47110 16 Amortization Expense 31,760 47411 16 Mechanical Equipment 1,000 47413 16 Computer Hardware/Software 22,000 1,916 22,000 0.00% 22,000 STW converstion to be completed in June 47414 16 Construction Expense - 4,500 - 4,500 0.00% 4,500 Solana allow of $3/ft (25%) 47415 16 Furniture and Fixtures - 12,500 25,000 - 15,537 12,500 31,074 0.00% 24.30% _ - - 12,500 25,000 Solana Includes the replacement of 6" meter for Vaquero Golf Course due to age and consumption (life tyle) and build up of inventory of meters of various sizes. 47420 16 Water Meters /Equipment 26,923 47421 16 Water Taps 2,100 7,430 14,860 271.50% 6,000 10,000 This item is off set by the tap fee revenue collected from new water customers when a new service is 48801 16 IFA Debt Pymt to GF _4,000 27,590 29,731 56,082 64,292 40,000 - - 56,082 64,292 11,957 27,590 29,731 56,082 64,292 40,000 0.00% 0.00% 0.00% 0.00% 0.00% - - 0 (0) 27,590 29,731 56,082 _64,292 40,000 Payment to be made at year-end Payment to be made at year-end _ J 48806 16 IFA Debt Pymt to 413 - 48810 16 DS -Keller OHS Principal - 48811 16 DS -Keller OHS Interest 67,374 48820 16 DS-Hillwood Service Area Acct 39,699 48821 16 DS -Town Service Area Accts 40,401 50,000 - 11,032 0 50,000 0 0.00% 0.00% - - 50,000 - 48823 16 DS-Hillwood Interest 344,759 TOTAL PW EXPENSES 1 2,014,696 1,731,026 1 476,8881 1,713,287 -1.02% 24,271 1 1,755,297 4 of 6 5/1712007 9:20 AM FUND?' I - Utility Fund Proposed oudget Amendments 41110 18 Full -Time Regular as of 31,832 %% 31,832 0.00% - 31,832 41120 18 03/31107 2,873 Projected Proposed Proposed 14.29% 375 Audited Adopted 1 YTD Projected Actual vs Amended Amended 3,455 0.00% Actuals Budget Actuals Actual Adopted Amount Budget 122 245 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06/07 COMMENTS 41110 18 Full -Time Regular 29,662 31,832 15,410 31,832 0.00% - 31,832 41120 18 Full -Time Overtime 2,873 2,625 1,339 32000 14.29% 375 3,000 42110 18 Medical Insurance Finance 3,313 3,455 1,697 3,455 0.00% 33.33% 3,455 42111 18 Dental Insurance 202 245 122 245 0.00% 0.00% 245 42130 18 LTD/AD&D/Life Insurance 246 307 146 307 0.00% - 307 42210 18 Social Security Finance/HR 1,927 1,973 1,000 2,100 6.44% 127 2,100 42220 18 Medicare Finance/HR 451 462 234 500 8.23% 38 500 42310 18 TMRS Finance/HR 2,383 2,611 1,350 2,800 7.24% 189 2,800 42510 18 Unemployment Taxes 172 177 - 50 -71.75% (127) 50 42610 18 Worker's Compensation 107 1 117 110 110 -5.98% (7) 110 TOTAL FINANCE PAYROLL 1 41,3361 43,8041 21,408 1 44,3991 1.36%1 595 1 44,399 44114 Sewer Repairs - - - 37,000 100.00% 37,000 37,000 New Dept; Move from PCM Fund TOTAL EXPENSES 2,137,829 1 1,932,875 696,268 1 1,964,5891 1.12%1 63,7241 1,996,599 16600 03 Water Meter Automation 7,985 34,690 - 34,690 0.00% - 34,690 35,319 16600 05 TRA Assumption of N1 Sewer 2;490 1821500 - 26,733 440 182,500 440 0.00% 0.00% - 182,500 440 440 Remaining engineering costs that carried over to FY 06-07 16600 08 Fidelity Waterline 304,825 16600 09 UT Secondary Water Source - 30,000 26,453 40,000 33.33% 10,000 40,000 Additional easement investigation for waterline alignment 16600 10 Ottinger Road Waterline - 1 85,000 - 85,000 0.00% - 85,000 CAPITAL PROJECTS 1 315,3001 332,1901 53,626 1 342,630 1 3.14%1 10,440 1 342,630 Balances are for informational purposes only - expenses are recorded in the Balance Sheet for tixea asset capitailzation or project. TOTAL EXP INCL CAPITAL. PROJ 1 2,453,130 1 2,265,065 1 749,8941 2,297,2191 1.42%1 74,1641 2,339,229 62510 99 Transfer Out to GF 62590 99 Transfer Out to CP Fund 35,319 50,000 15,000 14,412 50,000 - 15,000 0.00% - 0.00% - 50,000 Impact fee revenues 15,000 62600 99 Transfer Out to PCM Fund 10,000 37,000 - - -100.00% (37,000) - Created Dept for PCM in Utility Fund - see above Tr1TAI TReNRFFRS OUT 1 45.319 102.000 1 14.412 1 65.000 1 -36.27% (37,000)1 65,000 5 of 6 5/17/2007 9:20 AM FUND °'10 - Utility Fund Proposed _.fidget Amendments SUMMARY Total Revenue 1,943,518 2,391,888 as of 2423,541 %% 15,000 2,406,888 Transfers In BIS Affect to Cash (134,290) 32,811 03/31107 100 Projected Proposed Proposed Billing has historically been sporadic with inconsistent charges (Jarrod reviewing) Total Revenue Audited Adopted 1 YTD Projected Actual vs Amended Amended 2,265,065 749,894 Actuals Budget Actuals Actual Adopted Amount Budget 14,412 65,000 FY 05106 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 FY 06107 COMMENTS SUMMARY Total Revenue 1,943,518 2,391,888 627,738 2423,541 1.32% 15,000 2,406,888 Transfers In BIS Affect to Cash (134,290) 32,811 10,000 100 10,000 10,000 Total Expenses & Capital (Net of Billing has historically been sporadic with inconsistent charges (Jarrod reviewing) Total Revenue 1,943,518 _ 2,391,888 627,738 2,423,541 1.32% Depreciation, Amortization & Hillwood 1,661,281 2,265,065 749,894 2,297,219 1.42% 74,164 2,339,229 Total Transfers Out 45,319 102,000 14,412 65,000 -36.27% 37,000 65,000 NET 1 236,918 24,$231 (136,568)1 61,3221 147.04% (22,164) 2,660 CASH SUMMARY Beginning Cash 643,898 383,239 746,526 746,526 94.79% 363,286 746,526 Repairs were delayed to FY 06-07 BIS Affect to Cash (134,290) 32,811 171,302 32,811 0.00% - 32,811 Billing has historically been sporadic with inconsistent charges (Jarrod reviewing) Total Revenue 1,943,518 _ 2,391,888 627,738 2,423,541 1.32% 15,000 2,406,888 Mostly Interest income Transfers In 5,583 Maintenance not needed Miscellaneus other expenditures under budget 10,000 100 10,000 10,000 Total Expenses & Capital (Net of MUD reviews; $91K SCADA install at Vaquero; $51K Depreciation, Amortization & Hillwood water main maintenance; $1 OK Secondary Water Accrued Int Exp)) 1,661,281 2,265,065 749,894 2,297,219 1.42% 74,164 2,339,229 Source Toal Transfers Out 45,319 102,000 14,412 65,000 -36.27% (37,000) 65,000 ** Variance of $363,286 in ending FY 2006 cash and actual is mostly attibuted to the following excess budget over expenses: Capital Projects 150,000 $117,000 TRA Assumption not spent; $7,015 Water Meter Automation and $22,131 on Fidelity Waterline Pump Station Maintenance 11,876 Repairs were delayed to FY 06-07 Utility Engineering 71,640 UTRWD feasibility study was anticipated to be completed by FY 05-06; Other costs were allocated to appropriate projects Boyle & Lowry 10,781 Legal counsel not utilized SUTRA Maintenance 47,682 Billing has historically been sporadic with inconsistent charges (Jarrod reviewing) Tansfer out to PCMF forSewer Inflow & Infiltration repairs 27,000 Delayed until FY 06-07 TRA Wastewater 18,602 Based on volume of sewer; lower than anticipated Contracted Labor 7,000 Contract labor not utilized Water Main Maintenance 5,583 Maintenance not needed Miscellaneus other expenditures under budget 13,122 Various line item were under budget 363,286 6 of 6 5117/2007 9:20 AM FUND F')D - Permanent Capital Maintenance Proposea oudget Amendments 5/16/2007 11:14 AM Audited Actuals FY 05106 Adopted Budget FY 06107 as of 03131/07 YTD Actuals FY 06107 Projected Actual FY 06107 %% Projected Actual us Adopted FY 06107 Proposed Amended Amount FY 06107 Amended Budget FY 06107 COMMENTS :XPENDITURES 44114 00 Sewer Repairs 0 27,000 - - -100% (27,000) - See explanation below 44303 01.15 Road R&M - Pearson Lane 44303 02.15 Road R&M - Dove Road 16,308 57,152 - - - - - 0% 0% - - - - TOTAL EXPENDITURES 73,459 27,000 - -100% (27,000) )THER SOURCES & USES 52510 88 Xfr In from General Fund 83,459 10,000 - 10,000 0% - 10,000 52550 88 Xfr In from Utility Fund 10,000 37,000 - - -100% (37,000) - PCMF for Utility Fund has to be on accrual basis and other funds are on modified accrual. We have added a department in the Utility Fund for the Permanent Capital Maintenance and will restrict budgeted amounts to accumulate funds forfuture capital maintenance. TRANSFERS IN 93,459 47,000 10,000 -100% (37,000) 10,000 52550 99 Xfr out to Utility Fund 0 - 10,000 100% 10,000 10,000 PY Utility Fund Contribution sib in Utility Fund (restricted cash) TRANSFERS OUT 0 10,000 1 100%J 10,0001 10,000 SUMMARY Total Expenditures 73,459 27,000 - - 0% (27,000) - Transfers In 93,459 47,000 10,000 0% (37,000) 10,000 NET TOTAL 1 20,00011 20,000 1 1 10,000 00,00011 10,000 ;ASH SUMMARY Beginning Cash - - Balance Sheet Affect to Cash (20,000) - - 20,000 20,000 Expenditures 73,459 27,000 - 1.00% (27,000) Transfers In 93,459 47,000 10,000 0% (37,000) 10,000 Transfers Out 10,000 0% 10,000 10,000 NET TOTALI 0 20,000 - 20,000 1 (20,000) 20,000 5/16/2007 11:14 AM