Loading...
HomeMy WebLinkAboutRes 06-38 Approving Amendments to the Budget for the Fiscal Year 2005-2006 TOWN OF WESTLAKE RESOLUTION NO. 06-38 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS, APPROVING FY 2005-06 BUDGET AMENDMENTS TO THE TOWN'S GENERAL FUND, UTILITY FUND, VISITOR'S ASSOCIATION FUND, CAPITAL PROJECTS FUND, PERMANENT CAPITAL MAINTENANCE FUND, 4A AND 4B ECONOMIC DEVELOPMENT FUNDS 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 2005-2006 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: V 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, 4A and 4B Economic Development Funds 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 12th DAY OF JUNE, 2006. C v- Scott Bradt y, Mayor T EST: J Dwinnell,Town Secretary Trent O. Petty, To ager APPR O F L. tanton L , T wra- Corney General Fund Program Summary Proposed Adopted/ Amended Actual Amended Budget Summary FY 04105 FY 05106 FY 05106 Beginning Balance (Cash) $ 1,255,426 $ 1,223,306 $ 925,697 Balance Sheet Affect to Cash * (267,080) (9,250) 114,436 Revenue 3,609,987 3,788,104 4,934,458 Expenditures 3,680,114 3,727,769 4,819,070 Transfers In 107,632 1,965,337 2,070,381 Transfers Out 100,153 1,020,190 865,592 Ending Gash Balance 925,697 2,219,539 2,360,310 Restricted/Designated Funds" 351,185 1 364,741 367,321 Ending Balance $ 574,512 $ 1,854,798 $ 1,992,989 #Days Operating 100 217 238 Proposed Adopted/ Amended Actual Amended Budget Transfers In FY 04105 FY 05106 FY 05106 Capital Projects Civic Campus- Interest $ 16 $ - $ - 4A Funds Dissolution of Fund - 1,880,337 1,994,623 Fidelity Payment 35,758 - 35,758 Utility Fund Fort Worth Impact Fee Revenues 71,857 85,000 40,000 Total Transfers In $ 107,632 $ 1,965,337 1 $ 2,070,381 Proposed Adopted/ Amended Actual Amended Budget Transfers Out FY 04105 FY 05106 FY 05106 Transfer to Permanent Capital Maint Fund Preventative Maintenance $ - $ 10,000 $ 10,000 Dove Road Improvements 40,440 57,300 Pearson Road Improvements 25,560 16,308 Transfer to Special Revenue Fund -Grants Town's 10% portion of FEMA grant 44,801 44,801 Transfer to Capital Project Fund Portable Buildings - 57,400 - Temporary Parking 2,690 93,800 98„800 Civic Campus Expansion 97,447 266,525 270,000 413 Economic Development Fund 16 Debt Service Fund Shortfall of 4B funding for Debt Service 481,664 368,383 Total Transfers Out $ 100,153 $ 1,020,190 $ 865,592 General Fund Program Summary Proposed Adopted/ Amended Actual Amended Budget Restricted Funds/Designated" FY 04105 FY 05106 FY 05106 Trail Escrow 75,000 75,000 75,000 GW Farms Trail & Dove Rd Escrow 149,185 149,185 149,185 Court Technology 55,000 55,563 64,500 Court Security 72,000 84,993 78,636 Total Restricted/Designated Funds $ 351,185 $ 364,741 $ 367,321 Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. FUNC 30 - General Fund PROPOSED BUDGE AENDMENTS as of May S, 2006 Proposed as of Amendments 05108106 a ADOPTED1 PROPOSED Variance of Audited YTD a r AMENDED AMENDED Adopted Actuals Actuals m Monthly _ . Budget Budget ws FY 04105 FY 05106 o Average g . s a FY 05106 FY 05106 Amended Comments REVENUE ADMINISTRATIVE -DEPARTMENT 11 PY Avg for last 5 months=$177K;Avg of$175K for 7 months 31310 11 Sales Tax Revenue 994,606 999,908 6 166,651 12 1,999,816L474,816 1,320,000 1,525,000 205,000 amended 31430 11 Mixed Beverage Tax 13,846 6,752 2 3,376 4 13,504 10,500 13,000 2,500 Per a conversation with ATT representative,the last quarter'05 and the first quarter'06 retums showed-0-. They are in process of 3182011 AT&T 33,669 0 1 0 4 050,500 40,000 10,500 researching 31821 11 Verizon 7,632 3,218 1 3,218 4 12,872 12,000 6,600 (5,400) 31822 11 TXUTAtmos Gas 9,629 15,112 1 15,112 1 15,112 0 14,000 15,112 1,112 31823 11 Charter 222 266 2 133 4 532 192 250 340 90 31824 11 One Source 860 2,129 3 710 4 2,838 138 750 2,700 1,950 3182511 Southwest Bell 61,318 29,331 2 14,665 4 58,661F242 67,250 60,000 (7,250) Based on actual to-date 31826 11 Tri County Electric 228,243 130,121 2 65,060 4 260,242 205,000 260,000 55,000 31827 11 Trint Waste Services 8,404 7930 7 1,133 12 13,594 7,250 12,000 4,750 31828 11 Misc Franchise Fees 4138 1,365 7 195 12 2,339 5,100 2,000 (3,1003211011 Li uorPermitFees 0 710 1 710 1 710 0 710 710 32208 11 Other Misc Permits 300 900 1 goo 1 900 500 900 400 33700 11 Private Contributions 0 1,200,000 1 1,200,000 1 1,200000 0 1,200,000 1;200,000 Donation for land purchase 33701 11 Sale of Land 412;239 - 1 0 4 0 0 0 0 0 34130 11 Development Fees 35,422 14,335 1 14,335 1 14,335 (165) 210,550 14,500 (196,050) 34133 11 Special Event Fee 0 480 1 480 1 480 (20) 500 500 0 34141 11 Sales of Printed Material 233 126 1 126 1 126 (24) 500 150 350) 3610911 Note Receivable Principal 0 - 1 0 1 0 (17,042) 17;042 17,042 0 36110 11 Interest Earned 12,659 14,929 7 2,133 12 25,593 5,593 9,000 20,000 11,000 Based on actual to-date 36111 11 Note Receivable Interest 4,767 - 1 0 1 0 (3,690) 3,690 3,690 0 3880511 I/FDebt Pymtfrom UF 0 27,590 1 27,590 1 27,595 0 27,590 27,590 0 3940011 Misc.Income 8,860 245 8 41 12 489L4;17,19002,032,577 15,000 10,000 5,000) 39410 11 Texas Student Housing Rental Income 6,018 _ 3,270 7 467 12 5,605 5,605 5,605 0 39500 11 Texas Student Housing Donation Incom 0 100,000 1 100,000 1 100,000 50,000 100,000 50,000 Restricted to"Bldg Fund" DEPT 11-TOTAL G&A REVENUE 1,841,074 2,556,715 3,755,339 3,337,439 1 1,304,862 1,304,862 BUILDING OFFICIAL-DEPARTMENT 12 32209 12 Grading/Excavation Permits 20,900 13,200 8 1,650 12 19,800 1,800 22,321 18,000 (4,321) Budgeted for 48 new SFR for the year,actual=13 starts to-date 32210 12 Buildin2 Permits 398,722 259,538 8 32,442 12 389,306 15,306 396,476 374,00022,476 Budgeted for 48 new SFR for the year;actual=13 starts to-date 32211 12 InspectionlPlan Reviews 215,281 153,657 8 19,207 12 230,466 14,486 221,831 216,000 (5,831) Budgeted for48 new SFR for the year;actual=13 starts to-late 3221212 Reinspection Fees 2,860 1,500 8 188 12 2,250 (50) 600 2,300 1,700 34129 12 Pre-Submittal Reviews 800 2,000 1 2,000 1 2,000 0 0 2,000 2,000 34132 12 Contractor Registrations 19,225 6,450 B 806 12 9,675 1,325 17,524 11,000 (6,524) istrations than anticipated. 34141 12 Code Book Sales 0 265 8 33 13 431 0 0 520 520 8 IRC code books at$65 each DEPT 12-TOTAL BUILDING REVENUEJ 657,788 1 436,6101 1 653,948 30,217 656,752 623,820 1 (34,932) (34,932) 1 Df 16 677/2006 11:19 AM FUNCT "10 - General Fund PROPOSED BUDGEZ IENDMENTS as of May 8, 2006 Proposed as of Amendments 05108f05 n m ADOPTED! PROPOSED Variance of Audited YTP m a AMENDED AMENDED Adopted Actuals Actuals Monthly - Budget Budget Its FY 64165 FY 05106 o Average FY 05106 FY 65166 Amended Comments FIREIEMS-DEPARTMENT 14 34000 14 EMS User Fee 33,034 22,330 8 2,791 12 33,495_ 4,995 21,000 28,500 7,500 increase to match ear end trend 34005 14 FEMA Federal Grant Revenue 1,864 - 7 0 12 0 0 0 D 0 34OD6 14 Homeland Security Grant 25,842 - 7 0 12 6 0 0 0 0 34007 14 NCTTRAC Grant 0 3,163 1 3,163 1 3,163 0 0 3,163 3,163 Unanticipated grant 34010 14 Fire Code Permits 1,000 200 7 29 12 343 (57) 600 400 200 34015 14 Fire Sprinkler Permits 8,900 7,418 8 927 12 11,127 1,627 7,150 9,500 2,350 Based on actual to-date 35180 14 Law Enforcement 0 1,331 1 1,331 1 1,331 D 0 1;331 1,331 Based on actual to-date 39400 14 Misc Revenue 1,581 198 1 198 1 1e$ (1,402) 1,600 1,600 0 DEPT 14-TOTAL EMS REVENUE 72,226 34,640 +49,556 1 5,162 1 30,350 1 44,4941 14,144 14.944 MUNICIPAL COURT-DEPARTMENT 15 35110 15 Citation Revenue 809,126 490,109 8 61,264 12 735,164 16,164 815,000 725,00090,000} Collections clown&allocated to 6 other accounts 35111 15 FTO Citation Revenue 0 1 0 1 0 0 97,650 0 97,650) No FTO program revenue for current year 35115 15 Citation Refunds 19,519 (11,401) 7 (1,629) 12 (19,545) 545 0 (19,0001_ (19,000) Reflect amounts refunded to defendants for various reasons. 35120 15 Court Technology 29,921 13,378 7 1,911 _12 22,934 434 22,500 22,500 0 Allocated from Citation Revenue 35130 15 Court Security 22,441 10,034 7 1,433 12 17,200 (300) 17,500 17,504 0 35140 15 Warrant Revenue-SIO 113,886 42,856 7 6,122 12 73,457 467 0 73,000 73,000 Allocated from Citation Revenue $50 percitation! 35150 15 Warrant Fees 50,787 24,008 7 3,430 12 41,156 156 70,000 41,000 (29,000) Still in process of training 2nd person to collect warrants 3516015 NSF Check Revenue 500 450 7 64 12 771 4 500 775 275 Allocated from Citation Revenue 35170 15 Efficiency Fees 0 368 7 53 12 631 (19) 250 650 400 Allocated from Citation Revenue 351BO16 LawEnforecement 1,479 655 1 655 1 655 (0) 700 655 45 _ 35190 15 Collection Fees D 3,637 7 520 12 6,235 11 765 0 18,000 18,000 %based on warrant age 36110 15 Interest Earned 4,033 5,404 7 772 12 9,2$4 564 1,900 8,700 6,800 Increase to match ytd trend 39401 15 Credit Card Admin Fee 3,583 2,359 7 337 12 4,043 43 2,000 4,000 2,000 jAllocatvd from Citation Revenue DEPT 15-TOTAL COURT REVENUE 1,016,238 581,855 897,975 (805} 1,028,000 1 592,780 1 (135,220) {135,220) PARKS&RECREATION-DEPARTMENT 19 31110 19 Lessons 0 7 0 12 0 {500 500 500 0 3112019 Clinics 137 - 7 0 12 0 (500)1 500 500 0 3113019 Tournaments 11793 390 7 56 12 669 (931) 1,600 1,600 0 3114019 Leagues 0 - 7 0 12 0 (2,500) 2,500 2,500 0 32120 19 Kid's Programs 1,338 287 7 41 12 492 5,508) 6,000 6,000 0 32130 19 Wellness Program 0 - 7 0 12 0 (500) 500 500 0 33110 19 Court Fee 0 - 7 0 12 0 (250) 250 250 0 34110 19 Special Events 0 7 0 12 0 75) 75 75 0 37500 19 Glenwyck HOA Reimbursement __ 18,945 15,347 7 2,192 12 26,308 3,308 151500_ 23,000 7,_500 50%of sidewalk and additional park electricity increase 39400 19 Mise Income455 - 7 0 12 0 (1,000! 1,000 1,000 0 DEPT 19-TOTAL PARK&REC REVENUE 22,667 167023 27,469 8,456) 26,425 35,925 7,596 - 7,560 INFORMATION TECHNOLOGY-DEPARTMENT 20 31150 20 Sponsorshi IAdvartising Revenues 0 7 0 12 D 0 5,000 0 (5,000) 31155 20 Webhosting Revenue 0 7 _ 0 12 D 0 3,000 0 (3,000) 31160 20 Real Estate Listing Revenue 0 7 0 12 0 D 2,000 0 (2,000) DEPT 26-TOTAL IIT REVENUE 0 - 0 6 10,006 0 1 (10,000) (10,000) 2 of 16 61712006 11:19 AM FDNC 10 - General Fund PROPOSED BUDGET .IENDMENTS as of May 8, 2006 Proposed as of Amendments 05!00106 m ADOPTED/ PROPOSED Variance of Audited YTD m ¢ r AMENDED AMENDED Adapted Actuals AgOalsY Monthly - Budget Budget vs FY 04105 FY 05106 Q Average FY 05f06 FY 05!(16 Amended Comments TRANSFERS IN 5253088 Transfer In from Civic Campus 16 - 1 0 1 0 1 01- 0 _0 0 52560 88 Transfer In from OF-Impact Fees 71,857 16,519 1 16,519 2 33,038r(2,O 62) 85,000 40,000 (45,000) Corresponds to 11F transfers out 52570 88 Transfer In from 4A-dissolution 0 - 1 0 1 023) 1,880,337 1,994,623 114,286 Corresponded to 4A transfers out 52570 88 Transfer In from 4A-Fidel P&I Pymt 35,758 35,758 1 35,758 1 35,7580 0 35,758 35,758 DI PT 88-TOTAL TRANSFERS INV 107,633 52,277 33,03885)1 1966337T72070,381 105,044 105,044 Total Revenue 3,609,987 3,627,844 0 0 0 5,378,388 93 443, 0 54 3,788,104 4,934,458 1,146,3 _ ToW Transfers In 107,532 52,277 0 0 0 33,038 (2,037,343)1 1,965,337 2,070,381 105,044 TOTALI 3,717,618 1 3,680,121 0 D 1 0 1 5,411,426 1 (1,593,413)1 5,753,441 1 7,004,839 1,251,398 1,251,398 3 of 16 61712006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGE1 IENDMENTS as of May 8, 2006 Proposed as of Amendments 05108106 ADOPTEDI PROPOSED Variance of Audited YTD oil21 MENDED AMENQED Adapted Actuals Actuals :,? Monthly - Budget budget vs FY 04f05 FY 05106 'o Average FY 05106 FY 05106 Amended Comments EXPENDITURES ADMINISTRATIVE -DEPARTMENT 11 4111011 Salaries 29,176 19,060 17 1,121 26 29,151 (801) 29,952 29,952 0 4211011 Medical Insurance 4,017 2,149 8 269 12 3,224 59 4,912 3,165 (1,747) 2,149+4x254 42111 11 Dental Insurance 0 197 8 25 12 296 (45) 0 341 341 197+4 x 36 42130 11 LTD,AD&D,Life 1,028 152 8 19 12 227 (7) 368 234 (134) 151+4x21 _ 4221011 Social Security 2,301 1,150 17 68 26 1,759 (98) 1,857 1,857 0 4222011 Medicare 524 269 17 16 26 411 (23) 434 434 0 _ 4231011 TMRS 2,364 1,368 17 80 26 2,092 (97) 2,189 2,189 0 42510 11 Unemployment Taxes 156 189 1 189 1 189 0 19 189 170 42610 11 Workers Compensation 79 135 1 135 1 135 0 121 135 14 43110 11 Intern Program 8,267 - 15 0 26 0 0 10,500 0 (10,500 43130 11 Payroll Expenses-Other (2,073) 757 1 757 1 757 (43) 300 800 500 43205 11 Adminlstrative Expense 134,613 76,783 15 5,119 24 122,853 1,556 124,409 124,409 0 43206 11 Capitalized Administrative Expense __C50,000 (50,000) 1 (50,000) 1 (50,000) D (50,000) (50,000) 43215 11 Civil Engineering 87,931 11,719 6 1,953 12 23,438 (16,562) 125,000 40,000 (85,000) 43246 11 Appraisal Fees 3,250 - 7 0 12 0 0 0 0 0 43247 11 Surveyor Fees 3,650 1 3,650 1 3,650 0 0 3,650 3,650 4330511 Misc.Legal 8,256 5,961 7 852 12 10,219 219 10,000 10,000 0 43307 11 Litigation Counsel 172,250 - 1 0 1 0 0 0 0 0 43310 11 Boyle&Lowry 155,064 40,281 6 6,714 12 80,562 (44,438) 125,000 125,000 0 _ 43315 11 Goins,Underkofler 91,374 46,960 6 7,827 12 93,921 6,079 100,000 100,000 0 Previously amended to add$15K for 3rd&4th sessions pertaining 4332511 Legislative 58,644 23,391 7 3,342 12 40,099 (14,901) 55,000 _65,000 0 to Charter Schools 43405 11 Computer Equipment/Software 9,075 928 1 928 1 928 72) 1,000 1,000 0 43515 11 Community Service 2,708 1 0 1 0 (3,500) 3,500 3,500 0 4352011 Contingency 2,457 3,163 1 3,163 1 3,153 ____16,8371 10,000 10,000 0 4430011 Copier Repairs&Maint 0 297 7 42 12 509 1,291) 1,800 1,800 0 44302 11 Copier Lease 2,215 1,842 6 307 12 3,684 564 3,120 3,120 0 45205 11 Insurance Deductible 1,000 1,000 1 1,000 1 1,000 0 0 1,000 1,000 Deductible for Sherry Gray case with TML(not budgeted) 45209 11 Insurance-Law Enforcement 0 605 1 605 1 605 0 0 605 605 Separated by coverage type Premiums increased due to claims(Kennel Kare)lsep.by coverage 4521011 Insumnce-GeneralLiabili 17,375 9,044 1 9,044 1 9,044 0 19,115 9,044 10,071) type Premiums increased due to claims(Kennel Kare)Isep.by coverage 45211 11 insurance-Errors&Ommissions 0 14,918 1 14,918 1 14,918 (402) 0 15,320 15,320 type Speciatty coverage for areas not covered by general liability or 45213 11 Insurance-Crime&Theft 0 1,124 1 1,124 1 1,124 0 0 1,124 1,124_ property (forgery and electronic fraud,etc) 4221411 Insurance-Auto 0 456 1 456 1 456 0 0 456 456 Separated bycoveragtype 45215 11 Insurance-Property 7,588 148 1 148 1 148 0 435 148 (287) Separated by coverage type 45305 11 Telephone Service 6,262 2,667 6 445 12 5,334 1,390) 6,724 6,724 0 4531011 Mobile Phone 1,422 620 6 103 12 1,240 (510) 1,750 1,750 0 45324 11 Building Lease-Portables 0 - 1 0 1 0 (24,716) 17,685 24,716 7,031 4 months rent at Solona at$6178.98 per month vs portable lease 45325 11 Postage Machine Lease 893 698 6 116 12 1,395 495 900 900 0 4580511 Airfare 246 - 1 0 1 D 100 100 100 0 45815 11 Lodging 0 1 0 1 fl 100) 100 100 0 4582011 Meals 116 1 0 1 0 (200) 200 200 0 45825 11 Mileage 22 3 1 3 1 397 100 100 0 4583011 Training,Seminars,Meetings 728 1,538 1 1,53B 1 1,538 (62) 500 1,600 1,100 Mostly due to table purchased for Legacy of Women($825) 46_1_05 11 Office Supplies 7,359 4,110 6 685 128219 1,819 6,400 6,400 0 46106 11 Hospitality Items 3,028 1,659 7 237 12 2,844 244 2,600 2,600 0 _ 4 of 16 6/712006 11:19 AM FUNC 40 - General Fund PROPOSED BUDGE' AENDMENTS as of May 8, 2006 Proposed as of Amendments 25-106106 r m ADOPIE01 PROPOSED Variance of Audited YTD en _ AMEN DEQ AMENDED Adap[ed Actuals Actuals P MoMhty Budges Budget vs FY 04105 J_FY 05106 a Average FY 05!06 FY 25m6 Amended Comments 46115 11 Dues&Subscriptions 9,390 5,397 7 771 12 9,252 1,252 8,000 8,000 0 Northwest Metroport Chamber of$2,500 already paid for the year 4612011 Postage&Supplies 2,902 1,510 6 252 12 3,020 20 3,000 3,000 0 4612511 Printin 10 - 1 0 1 0 (100) 100 100 0 _ 4613011 Books&Printed Materials 0 1 0 1 0 250 250 250 0 4613511 Bank Charges 31 1 0 1 0 200 200 200 0 46140 11 Moving Expense 0 1 0 1 0 (6,000) 6,000 6,000 0 Move to Solana for Court,TSH and Town Secretary 4614511 Courier Service 0 1 0 1 0 00 0 0 4616011 CreditCard Processing 293 66 1 66 1 66 (34) 100._ 100 0 v®� 46190 11 Misc.Expense 2,429 919 1 919 1 919 (81) 0 1,000 1,000 4620511 Utilities-water 7,039 1,490 6 248 12 2,961 (650) 3,630 3,630 0 4621511 Vehicle Fuel/MaintfRepairs 1,550 294 7 42 12 504 (246) 1,500 750 (750) 46220 11 Utilities-Electric 20,658 6,821 7 974 12 11,693 1,036 10,655 10,655 0 46225 11 Utilities-Gas 2,899 2,061 6 343 12 4,121 321 1,574 3,600 2,226 Increase in Gas rates of.0269 GCR plus seasonal usage 46520 11 Economic Development Principal 18,281 16,426 1 16,426 1 16,426 0 0 16,426 16,426_ _ 46522 11 Economic Development Interest 17,477 19,333 1 19,333 1 19,333 0 0 19,333 19,333 47412 11 Land Purchase 146,600 - 1 0 1 0 1,204,000 0 1,204,000 1,204,000 Anticipated land purchase+closing costs&survey$4K 47900 11 Westlake Academy Grant 0 - 1 0 1 0 0 50,000 0 (50,000) Received$100K to be restricted to"Building Fund" DEPT 11-TOTAL G&A EXPENDITURES 999,274 283,305 487,447 (1,329,458) 701,099 1,816,905 1 1,115,806 1,115,806 5 of 16 6/712006 11:19 AM FDNC 30 - General Fund PROPOSED BUDGE, IIENDMENTS as of May 8, 2006 Proposed as of Amendments WOW T m ADOPTED! PROPOSED Variance of Audited YTD m a AMENDED AMENDED Adopted Actuals Actuals Monthly 'a Budget Budget vs FY 04105 FY 05105 n Average FY 05F06 FY 05!06 Amentled Comments BUILDING OFFICIAL-DEPARTMENT 12 4111012 Salaries 53,418 34,816 17 2,048 26 53,249 (1,637) 54,886 54,886 0 41640 12 Auto Allowance 900 - 1 0 1 0 0 0 0 0 4211012 Medical Insurance 18,670 5,773 8 722 12 8,659 (373) 21,570 9,032 (12,538 5,772+4 x 815-changed from age banded rating to compos'de fabrij 42111 12 Dental Insurance 0 293 8 37 12 440 (73) 0 513 513 293+4x55 42130 12 LTD,AD&D,Life 280 _281 8 35 12 422 (19) 525 447 84 281+040 4221012 Social Security 3,017 2,020 17 119 26 3,090 10 3,403 3,100 (303) 4222012 Medicare 718 472 17 28 26 723 67 796 790 (6) --- 4231012 TMRS 4,284 2,498 17 147 26 3,820 (80) 4,012 3,900 112 4251012 Unemployment Taxes 27 270 1 270 1 270 0 27 270 243 4261012 Worker's Compensation 421 420 1 420 1 420 (130) 682 550 132 43260 12 Building Inspectlon/Plan Review 13,460 22,716 7 3,245 12 38,942 9,207 15,000 29,735 14,735 First American outsourced plan review was not anticipated. 43405 12 Computer Equipment 0 - 1 0 1 0 5,700) 6,700 5,700 (1,000) Computer screen,Mdcopier,camera construction record 4521412 Insurance-Automobile 0 506 1 506 1 506 0 0 506 506 4531012 Mobile Phone 1,559 768 6 128 12 1,537 87 1,300 1,450 150_ $120 per month x 12 months=$1,440 45815 12 Lodging 634 454 1 454 1 454 446 _ 900 900 0 4582012 Meals 0 44 1 44 1 44 (6) 0 50 50 45825 12 Mileage 160 297 1 297 1 297 (3) 0 300 _ 300 45830 12 Training,Seminars,Meetings _ 2,130 1,249 6 208 12 2,498 (902) 3,500 3,400 (100) 4610512 Office Supplies 534 508 fi 85 12 1,017 17 1,000 1,000 0 46110 12 Office Equipment 0 1 0 1 0 (1,400) 1,500 1,400 100 46115 12 Dues&Subscriptions 260 305 6 51 12 610L(209) 750 650 (100 4612512 Printing _ 1,020 1,162_ 1 1,162 1 1,162 750 1,140 390 4613012 Books&'Printed Matedals 1,751 1,088 7 155 12 1,865 2,800 2,700 (100) New cycle of code books printed 2006 to be adopted 48215 12 Vehiele Fuel/MaintlRe airs 846 346 fi 58 12 697 1,000 900 {100 4660512 Uniforms 0 558 7 80 12 956 500 500 0 4741012 Vehicles 15,704 - 1 0 1 0 0 0 0 DEPT 12-TOTAL BUILDING EXPENDITURES 119,793 76,84fi 121,fi71 121,607 1 123,8131-- 2,272 2;212 6 of 16 6/7/2005 11:19 AM FUNC 30 - General Fund PROPOSED BUDGE IIENDMENTS as of May 8, 2006 Proposed as of Amendments 05108106 m PROPOSED Variance of Audited YTD m ? AMENDED Adopted Actuals Actuals a Monthly - ENE FY04105FY 05106 S AverageFY 05198 Amended Comments TOWN SECRETARY-DEPARTMENT 13 4111013 Salaries 69,041 42,221 17 2,484 26 64,574 (1,917) 66,491 66,491 0 4111013 Payroll Credit from TSH 18,779 (12,800) 7 (1,829) 12 21,942 0 21,942 21,942 0 42110 13 Medical insurance 7,294 2,973 8 372 12 4,459 70 7,017 4,389 2,628) 2,973+4x354 42111 13 Dental Insurance 0 173 8 22 12 260 (13) 0 273 273 173+4x25 42130 13 LTD,AD&D,Life 270 - 8 0 12 0 0 525 0 (525) 42210 13 Social Security 4,253 2,515 17 148 26 3,847 153 4,122 4,000 122 4222013 Medicare 987 588 17 35 26 900 (64) 964 964 0 4231013 TMRS 5,429 3,031 17 178 26 4,635 (65) 4,860 4,700 160 4251013 Unemployment Taxes 54 270 1 270 1 270 0 27 270 243 42610 13 Worker's Compensation 151 193 1 193 1 193 0 269 193 (76) 43241 13 Records management 0 1 0 1 0 (13,500) 13,500 13,500 0 Year-end expense 43305 13 Misc Legal 122 - 1 0 1 0 0 0 0 0 4430013 Copier RentalIR&M/Copy Chg 0 315 1 315 4 1,260 630 750 630 (120) 4 quarters at$157.50 4430213 Copier lease 2,861 858 6 _143 12 1,716 366 1,380 1,350 30 Y"fD actual_$744_pllus 5 months $113=$1310 45325 13 Misc Rental 0 1 �0 1 0 300 300 300 0 45405 13 Advertising-Public Notices 1,416 897 1 897 1 897 (369) 2,500 1,266 (1,234) Actual$416 plus$850 far remaWng notices 4581513 Lodging a 180 1 __ 160 1 160 01 0 160 160 4582013 Meals 0 63 1~ 63 1 63 0 0 63 63 45830 13 Training,Seminars,Meetings 699 281 1 281 1 281 (650) 1,000 931 (69) Actual$281 plus$650 for NTMCA meetings 46105 13 Office Supplies _3.33 579 1 57_9 1 579 _X171 400 750 350 Additional needed to set up office at Solana 46115 13 Dues&Subscriptions 95 2TT 1 220 1 220 0 200 220 20 46120 13 Postage&Supplies 68 14 6 2 12 27 73 100 100 0 4613013 Books&Printed Materials 100 50 1 50 '1 50 (50) 100 100 0 4615013 Licenses/Registrations 71 1 0 1 0 0 0 0 0 4617613 Meeting Expense 45 1 0 1 0 100) 100 100 0 4618013 Election Expense �- 0 3,079 1 3,079 2 6,158 842 7,000 7,000 0 4618513 Codification 3,448 3,436 3 1,145 12 13,745 745 13,000 13,000 0 Year-end expense 46190 13 Misc Expense 80 - 7 0 12 0 (1 15)1 115 115 O DEPT 13-TOWN SECRETARY EXPENDITURES 78,03$ 49,1171 1 1 1 82,352 1 (16,571)1 102,778 1 98;923 1 (3,855) 7 of 16 6/712006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGE1 iENDMENTS as of May 8, 2006 Proposed as ofAmendments 05106106 m ADOPTED! PROPOSED Variance of Audited YTD m a r AMENDED AMENDE❑ Adopted Actuals Actuals Monthly ■ audgek Budget vs FY 04105 FY 05106 C, Average i r FY 05106 FY 05106 Amendetl Comments FIREIEMS-DEPARTMENT 14 41110 14 EMS Salaries 489,440 301,628 16 18,852 25 471,293 (28,707) 532,012 500,000 (32,012) Vacant position far 4 months-will fill position-increase trend 41120 14 EMS Overtime 32,993 30,350 16 1,897 25 47,422 6,422 34,000 41,000 7,000 New position will reduce overtime trend;performing insps in-house Contract labor firefighters now paid through payroll as part-time/ 41210 14 Part Time Regular 0 8,767 16 548 25 13,698 7,302 0 21,000 21,000 previously coded to Supplemental Fireman labor 4151014 FLSA RegularMO 4,985 3,249 16 203 25 5,077 (923) 13,000 6,000 7,000 Vacant position for months-will fill position-increase trend 41515 14 Warrant Officer OT 6,350 - 16 0 25 0 0 0 0 0 41640 14_Auto Allowance 4,819 3,046 16 190 25 4,760 401 4,800 4,800 0 4211014 Medical Insurance 69,106 42,331 6 5,291 12 63,496 (10,504) 79,176 74,000 5,176) Vacant posifion for 4 months-will fill position-increase trend 4211114 Dental Insurance 0 2,926 8 366 12 4,388 698) 0 5,086 5,086 2926+4x540 42130 14 LTD,AD&D,Life 4,206 1,706 8 213 12 2,559 (175) 5,565 2,734 (2,831) 1706+4 x 257 4221014 SocW Security 31,475 20,713 16 1,295 25 32,364 (3,535) 35,899 35,899 0 Vacant position for months-will fill position-increase trend 4222014 Medicare 7,293 4,844 16 303 25 7,569 (827) 8,396 8,396 0 4231014 TMRS 41,795 24,381 16 1,524 25 36,096 (4,230) 42,326 42,326 0 Vacant position for 4months-will fill position-increase trend 42510 14 UnempinymentTaxes 728 2,789 1 2,789 1 2,789 (0) 297 2,789 2,492 Prior year rate was.3%and current calendar year is 3% 4261014 Workers Compensation 14,341 12,810 1 12,810 1 12,810 4,268) 17,078 17,078 0 Vacant position for 4 months-will fill position-increase trend 4312514 Pre-employment Physicals 711 1;236 7 177 12 2,119 1,269 0 850 850 4313514 Pre-employment Testin3,351 1,044 7 149 12 1,789 211 2,000 2,000 0 43140 14 Employee Physicals 0 - 7 0 12 0 (4,675) 4,675 4,675 0 Not scheduled to date-1 time expense 43255 14 Keller Police Contract 685_,589 532,755 3 177,585 4 710,340 1 710,339 710,339 0 Budgeted for funding of FTO coverage;assuming no FTO program 43335 14 Supplemental Firemen Labor 51,904 21,944 7 3,135 12 37,618 15,674 108,775 21,944 86,831 prior to year-end 43336 14 Contracted Services 15,600 5,150 6 858 12 10,300 3,300 16,795 7,0009( 795) Performing inspections in-house-see offset in overtime salary 43337 14 Exterminator Service 247 180 2 90 4 360 0 0 360 360 Increase to year end trend Law Enforcement Program that was to be purchase at year end of $14,575 will not be purchased but an additional 2 desktop units are 4340514 Computer Equip./Software 467 700 1 700 1 700 3,500 14,575 4,200 10,375 needed to replace laptops put in vehicles to run Intermedix 44209 14 Cleaning Supplies 355 1,135 7 162 12 1,946 (4) 1,000 1,950 950 Allocated from Facilit acct 44210 44210 14 Facility Supplies 2,394 345 7 49 12 591 (59) 1,600 650 (950) Allocate to Cleaning acct 44209 44211 14 Safety Supplies 949 23 7 3 12 39 (1,961) 2,000 2,000 0 Purchases to be made in Summer 06 _ 44212 14 Building Supplies 619 8 7 1 12 14 (1,186) 1,200 1,200^ 0 Purchases to be made in Summer 06 44213 14 Fire Fighter Sulies 1,675 1,767 1 1,767 1 1,767 (83) 1,850 1,850 -0 44226 14 Misc Hand Tools 246 - 1 0 1 0 (100) 100 100 0 4521414 Insurance-Auto 4,500 3,466 1 3,466 1 3,466 0 5,000 3,466 (1,534) Actual 45215 14 Insurance-Property 183 172 1 _ 172 1 172 22 150 150 0 4530514 Tele hone 2,136 1,265 6 211 12 2,529 494 2,039 2,035 0 45310 14 Mobile Phones 1;081 670 6 112 12 1,340 670 670 670 0 4531514 Internet Expense 337 432 2 216 4 863 63 _ _ 800 Boo 0 4532514 Rentals/Leases-Building 4,811 2,806 6 468 12 5,612 797 4,815 4,615 0 45820 14 Travel Meals 111 26 1 26 1 26 X124 150 150 0 4583014 Training/Seminars/Meetings 2,862 2,115 6 353 12 4,230 (2,270) 6,500 6,500 0 45907 14 HVAC Repairs&Maintenance 0 495 1 495 1 495 0 0 495 495 _ 4591014 Mechanical Repair&Maintenance 0 50 1 50 1 50 0 0 50 50 _ 4610514 Office Supplies 443 495 7 71 12 849 351 1,200 1,200 0 46106 14 Hosp'ltatity Items 19 44 1 44 1 44 (16) 0 60 60 Already paid Solana annual fee of$2,640 and NE Fire Deprt Assoc 46115 14 Dues&Subscriptions 5,470 7,651 1 7,651 1 7,651 219 7,870 7,870 0 of$4,519. 4612014 Postage/Shipping/Supplies 29 65 1 65 1 65 (35) 100 100 0 46125 14 Printing 0 144 1 144 1 144 6 0 150 180 Business cards 46130 14 Books&Printed Materials _ 237 647 7 92 12 11109 1,191) 3,500 2,300 (1,2 0Allocate to Uniform acct 46605 46150 14 Licenses&Re istration 1,222 709 7 101 12 1,215 (585) 1,800 1,800 0 46155.14 Misc.Suppies 419 1 13 7 2 12 22 726 750 750 0 _ 8 of 16 6/712006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGET IENDMENTS as of May 8, 2006 Proposed as of Amendments 05!06106 m AnoPTEnf PRdPOSEn Variance of Audited YTD mZ, ENDED AMENDED Adopted Actuals Actualsa Monthly 'ry Bvtlget Budget vs FY 04105 FY 05!06 o Average a FY 05!06 FY 45106 Amended Comments 46190 14 Misc Expense 0 5 7 1 12 9 4 0 5 5 4620514 Utilities-Water/Sewer 2,237 1,023 6 170 12 2,045 (280) 2,325 2,325 0 4621514 Vehicle Fuel/MaintfRepairs 13,349 10,025 6 1,671 12 20,049 951 21,000 21,000 0 46220 14 Utilities-Electric_ 4,260 2,807 7 401 12 4,812 382 4,430 4,430 0 46225 14 Utilities-Gas 1,161 2,076 7 297 12 3,559 159 1,665 3,400 1,735 Increase in Gas rates of.0269 GCR plus seasonal usage 46605 14 Uniforms/Personal Gear 8,576 5,665 7 809 12 9,712 2,382 5,780 7,330 1,550 Allocated from 46130&46610 46610 14 Weapons&Accessories 1,826 3,033 7 433 12 5,200 1,430 4,250 3,770 480) Allocate to Uniform acct 46605 Replace expired drugs&purchase new drugs required by medical 46615 14 Medical Supplies&Equipment 3,457 5,251 7 750 12 9,002 3,352 5;650 5,650 0 control _ 46620 14 FEMA Grant Exp(WL 10%) 177 - 1 0 1 0 0 0 0 0 46621 14 FEMA Grant Exp(FEMA 90%) 1,593 1 0 1 0 0 0_0 0 46622 14 Homeland Security Grant 25,920 1 0 1 0 0 0 0 0 DEPT 14-TOTAL EMS EXPENDITURE 1,556,054 1,076,973 1,558,173 (43,324) 1,717,898 1,691,497 (116,401} {116,401) 9 of 16 6!712006 11:19 AM FUN[ 10 - General Fund PROPOSED BUDGE1 1ENDMENTS as of May 8, 2006 Proposed as of Amendments 05106106 h m 7APTEDf PROPOSED Variance of Audited YTD °� ' - +Actuals Aduals Monthly FY 04105 FY 05166 © Average 2 + + 05106 FY 05Y06 Amended Comments MUNICIPAL COURT-DEPARTMENT 15 4111015 Salaries 129,740 98,405 17 5,789 26 150,502 10,646 161,148 161,148 0 4112015 Overtime 3,2_72 1,192 17 70 23 1,823 (677) 2,500 2,500 0 41515 15 Bail€iff Security Overtime 1,826 1,012 17 60 26 1,548 (302) 0 1,850 1,850 New payroll line-originally in court security expense 4211015 Medical insurance 27,049 13,899 8 1,737 12 20,848 (199) 43,244 21,047 (22,197) $13,899+4x$1,787 4211115 Dental Insurance 0 763 8 95 12 1,144 (115) 0 1,259 1,259 $763+4x$124 42130 15 LTD,AD&D,Life 931 628 8 78 12 941 (47) 1,670 988 (682) $628+4 x$90 42210 15 Social Security 8,336 6,134 17 361 26 9;382 (764) 10,146 10,145 0 4222015 Medicare 1,932 1,435 17 84 26 2,194 179 2,373 2,373 0 4231015 TMRS 9,309 7,139 17 420 26 10,919 (1,044) 11,963 11,963 0 4251015 Unemployment Taxes 236 990 1 990 1 990 0 135 990 855 .31%in previous calendar year;3%for cu rrent year 42610 15 Worker's Compensation 773 1,330 1 1 330 1 1,330 (0 4,089 1,330 (2,759) Second warrant officer converted to clerk position 43135 15 Pre-Employment Testin _ 305 - 7 0 12_ 0 (305) 305 305 0 43310 15 Legal Services-Boyle&Lowry 31,890 9,225 6 1,538 12 18,450 (1,550) 20,000 20,000 0 4333015 Legal Services-Judge Services 27,243 21,050 8 2,631 12 31,575 1,575 30,000 30,000 0 4333515 Contract Labor 677 - 7 0 12 0 0 0 0 0 Fees paid for Warrant Collections by outside source which is mostly offset by service fee to defendentslinterpreterlcourt reporter;see 43336 16 Contracted Services 0 6,834 4 1,709 12 20,503 503 0 20,000 20,000 Collection Fees in revenue for offset 4340515 Computer Equipment 0 837 1 837 1 837 _ (63) 0 900 900 4430015 Copier Repairs/Maint/CDpyChg 0 315 7 45 12 540 (210) 750 750 0 4430215 Copier Lease 3,482 858 7 123 12 1,471 91 1,380 1,380 0 44410 15 Rent Y 0 - 1 0 1 0 24,716 0 24,716 24,716 4 months rent at Solana at$6178.98 per month 45214 15 Insurance-Auto 0 355 1 355 1 355 0 0 355 355 Increase to match actual spent YTD 45305 15 Telephone D 1 0 1 0 1,000 0 1,600 1,000 Solona phone casts 4531515 Internet Expense-T1 line D 1 0 1 0 (1,000) 0 1,000 1,000 At Solona(T1=250 a month x 4 4532515 Misc Rental/Lease 1,089 1,677 7 240 12 2,874 359 2,485 2,485 0 45810 15 Travel Car Rental/Parking 18 7 0 12 0 0 0 0 0 45815 15 Travel Lodging 475 279 1 279 1 279 71 350 350 0 45B20 15 Travel Meals 177 18 1 18 1 18 (182) 200 200 0 _ 45825 15 Travel Mileage 1,059 63 1 63 1 63 (817) 880 880 0 Expenses will pCCur in Summer months 45830 15 Training/Seminars/Meetings 1,144 105 7 15 12 180 2,070 2,250 2,250 0 Expenses will occur in Summer months 46105 15 Court Office Supplies 3,162 1,490 7 213 12 2,554 1,946) 4,500 4,500 0 Per AD-anticipate more cost for move to Solona 46106 15 Hospitality Items 76 8 1 8 1 8 (22) 30 30 0 46115 15 Dues&Subscriptions 548 180 7 26 12 309 (21) 330 330 0 46120 15 Postage&Supplies 1,619 703 7 100 12 1,205 295 1,500 1,500 0 4612515 Printing 4,796 2,556 7 365 12 4;382 2,618) 4,500 7,000 2,500 Printing new tickets and forms with new address 46135 15 Bank Service Charge 2,946 7 0 12 0 100 100 100 0 4614015 Moving Expense 658 - 7 0 12 0 0 0 0 0 46160 15 Credit Card Processing 7,493 3,796 7 542 12 6,507 507 6,000 6,000 0 46165 15 Court Technology 17,580 12,816 8 1,602 12 19,228 2,373 16,850 16,850 0 Expenses will occur in Summer months 46167 15 Court Efficiency 0 230 1 230 1 230 420) 0 650 650 Corresponds to efficiency revenue 46170 15 Court Security 364 361 7 52 12 619 (11,868) 3,500 12,487 8,987 Expenses wlll occur in Summer months inc.$10,837 for Solana serve 46171 15 Court TCLEOSE 649 - 7 0 12 0 (650) 650 650 0 4619015 Misc.Court Expense 28 3 7 0 12 6 6 1,000 0 (1,0091 Allocated to other expense accou nts 46215 15 Vehicle FuellMaint/Repairs 727 2,012 7 287 12 3,449 249 5,000 3,200 (1,600) Expenses will occur in Summer months 46220.14_ Utilities-Electric 0 - 1 0 1 0 (2,200) 0 2,200 2,200 Electricity not included in lease 4660515 Uniforms 238 108 7 15 12 185 77 0 108 108 47412 15 Vehicle 1,800 1,800 Vehicle and vehicle lettering 47415 15 FurniturelFixtures0 5,403 1 5,403 3 15,669 669 0 15,000 15,000 Furniturelfixtures at Solona for Court DEPT 15-TOTAL COURT EXPENDITURE 291,851 204,207 333,112 59,658) 339,826 1 394,570 54,742 547742 10 of 16 61712006 11 19 AM FUNS' 90 - General Fund PROPOSED BUDGE- 1ENDMENTS as of May 8, 2008 Proposed as of Amendments 05/08/06 x m ApOPTEOf PROPOSED Variance of Audited YTP m r AMEN�E€� kMEN DEB Adopted Actuals Actuals y Monthly = Budget Budget vs FY 04105 FY 05106 'o Average ■ r r FY 05106 FY 05!06 Amentletl Comments PUBLIC WORKS-DEPARTMENT 16 4111016 Salaries 10,706 7,142 17 420 26 10,924 287 11,211 11,211 0 4211016 Medical Insurance 2,028 1,663 8 208 12 2,495 (388) 2,753 2,883 130 1,663+4 x 305 42111 16 Dental Insurance 0 103 8 13 12 154 (33� 0 187 187 103+4 x 21 42130 16 LTD,AD&D,Life 119 58 8 7 12 87 3 131 90 (41) 58+4 x 8 _ 42210 16 Social Security 588 368 17 22 26 562 133 695 695 0 42220 16 Medicare 122 86 17 5 26 132 (31) 163 163 0 42310 16 TMRS 980 512 17 30 26 783 371 820 820 0 42510 16 Unemployment Taxes 7 68 1 68 1 68 0 7 68 61 .3%in previous calendar year;3%for current year 42610 16 Worker's Compensation 340 388 1 388 1 368 (294) 682 682 0 43211 16 Street Materials 0 - 7 0 12 0 0 500 D 500Moved to pot We repair 43212 16 Pot Hole Repair in house repair) 5,295 - 7 0 12 0 (500) 0 500 500 From street materials 4321316 ROW Two Removal 1,510 295 6 49 12 590 (1,410) 2,000 2,000 0 43214 16 Street Drains 9a 7,170 __ -_ 7--.-_ 0_12 0 (6,196) 10,000 6,196 (3,804) 43215 16 Civil Engineering 1,677 7 0 12 0 (3,400) 3,400 3,400 0 44206 16 Waming Devices 1,162 1,084 7 155 12 1,856 774 500 1,084 584 One time purchase of illuminated pavement markers 44303 16 Road Repairs&Maint.(contractor) 2,566 6,421 7 917 12 11,007 (189) 15,000 11,196 (3,804) 44304 16 Sign Repair&Maint. 1,738 - 7 0 12 0 3,000 3,000 3,000 0 44305 16 ROW Irrigation 73,577 23,070 7 3,296 12 39,549 (20,451) 25,000 60,000 35,000 ROW irrigation demand by vaquero due to drought 46215 16 Vehicle Fuel/Maint/Repairs 1,450 906 6 151 12 1,8121,088 2,900 2,900 0 4622016 ROW Electric 0 245 6 41 12 489 (11) 0 500 500 2 electric meters DEPT 16-TOTAL PW EXPENDITURE 111,034 42,409 1 1 70,898 (36,676] 78,7621 107,6751 28,813 28,813 11 of 16 617/2006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGET 1ENDMENTS as of May 8, 2006 Proposed as of Amendments 05108105 T m ADDPTEDI PROPOSED Variance of Audited YTD m 1 AMENDED AMENDED Adopted Actuals Actuals ? Monthly 'a Budget Budget vs FY 04M5 FY 05!06 i5 Average r r FY 05fOfi FY 05148 Amended Comments FACILITIES&GROUND_ S MAINTENANCE-DEPARTMENT 17 _ 4111017 Salaries 26,539 17,324 17 1,019 26 26,496 (812) 27,308 27,308 0 42110 17 Medical Insurance 3,691 3,230 8 404 12 4,845 (825) 3,407 5,670 2,263 3,230+4 x 610 -Added a dependent 42111 17 Dental Insurance 0 206 8 26 12 309 (65) 6 374 374 206+4 x 42 4213017 LTD,AD&D,Life 233 141 8 18 12 211 10 263 221 (42) 141+4 x 20 42210 17 Social Security 1,510 966 17 57 26 1,477 216) 1,693 1;693 0 _ 4222017 Medicare 353 226 17 13 26 346 50 396 396 0 4231017 TMRS 2,105 1,243 17 73 26 1,900 (96) 1,996 1,996 0 42510 17 Unemployment Taxes 14 135 1 135 1 135 0 14 135 121 .3%in previous calendar year,3%for current year 42610 17 Worker's Compensation 318 744 1 744 1 744 857) 1,601 1,601 0 43337 17 Contract Exterminator 2,603 35 7 5 12 60 (41940) 5,000 5,000 0 43338 17 Contract Mechanical Maint-LSI 5,471 3,785 8 473 12 5,678 678 5,000 5,000 0 4333917 Contract Sweeping/Washing 148 - 7 0 12 0 (1,000) 1,000 1,000 0 43340 17 Contract Irrigation Maintenance 4,970 3,487 8 436 12 5,231 2,231 3,000 3,000 0 4334117 Contract WindowCleanink 545 371 7 53 12 636 (2,364) 3,000 3,000 0 43342 17 Contract Carpet Cleaning 1,605 780 7 111 12 1,337 2,663 4,000 4,000 0 43344 17 Contract Median Maintenance 8,338 3,145 7 449 12 5,391 13,609) 7,000 19,000 12,000 Tree trimming over roadwa 4334517 Contract Building Janitorial 38,472 u 25,448 7 3,635 12 43,625 2,375) 46,000 46,000 0 4334617 Contract Building Maintenance 7,500 4,795 1 4,795 6 28,770 (230) 29,000 29,000 0 4334717 Contract HVAC Maintenance 7,994 3,972 7 667 12 6,809 4,191) 11,000 11,000 0 4334817 Lands�e Maint Civic Campus 27,179 14,424 6 2,404 12 28,848 (3,153) 32,000 32,000 0 43350 17 Contract Security Monitoring 0 809 1 809 1 809 109 700 700 0 43351 17 Contract Wastewater Treatment _ 1,570 - 7 0 12 0 (2,400) 2,400 2,400 0 4335217 Contract Electrical/Lighting 11,500 3,750 2 1,875 4 7,500 (4,000) 11,500 11,500 0 Invoiced for additional dumpsters(1 free with contract and 3 4335317 Contract Sa nitation/Wa ste Removal 313 1,519 1 1,519 1 1,5.1.9 6 0 1,525 1,525 additional charges) for seasonal Town cleanup 43354 17 Gontract Security Maintenance 9,255 - 7 0 12 0 (10,000) 10,000 10,000 0 44210 17 Facility Supplies 5„559 4,509 8 564 12 6,763 763 6,000 6,000 0 4421217 Building Supplies 1,391 303 7 43 12 519 3,4611 4,000 4,000 0 44213 17 Electrical Supplies 691 - 7 0 12 0 (4500) 4,500 4,500 0 _ 44216 17 Ground Supplies 2,295 44 7 6 12 76 (3,924) 4,000 4,0_00 0 4421717 HVAC Supplies 313 - 7 0 12 0 0 0 0 0 4421817 Lamp/Bulb Supplies 2,665 3,133 8 392 12 4,700 1,200 3,500 3,$00 0 44219 17 Mechanical Supplies 1,099 - 7 0 12 0 (5,00-01 5,000 5,000 0 4422017 Painting Supplies 0 7 0 12 0 2,000 2,000 2,000 0 44221 17 Communication Supplies 552 7 0 12 0 (700) 700 700 0 44224 17 Sanitation Supplies 1,288 7 0 12 0 (3,000) 3,000 3,000 0 4422517 Water Treatment Supplies 1,158 360 7 51 12 618 3,382 4,000 4,000 0 44226 17 Misc Hand Tools 937 169 7 24 12 2_90 910 1,200 1,200 0 44306 17 Grounds maintenance 0 - 7 0 12 0 (12,000) 12,000 12,000 0 45310 17 Mobile Phone 1,032 708 7 101 12 1,214 14 1,200 1,200 0 45315 17 Internet Expense-DSL Line 379 208 7 30 12 356 (344) 700 700 0 45325 17 Rental-Misc Equipment 181 846 7 121 12 1,451 (1,649) 3,000 3,000 0 4583017 Training/Seminars/Meetings 1,189 289 7 41 12 495 (4,005) 4,500 4,500 0 45901 17 Audio Visual R&M 977 50 7 7 12 86 (914) 1,000 _1,000 0 45902 17 Electrical R&M 3,532 - 7 0 12 0 4,000 4,000 4,000 0 45903 17 Elevator R&M 683 700 6 117 12 1,400 (100) 1,500 1,500 0 45904 17 Plumbing R&M 2,254 950 6 119 12 1,425 425 1,000 1,000 0 _ 45905 17 Fire Sprinkler R&M 2,688 976 7 139 12 1,673 (1,8271 3,500 3,500 0 45906 17 Fire/Life Safe -AED R&M 145 193 7 28 12 331 (4,669) 5,000 5,000 0 45907 17 HVAC R&M 9,994 1,564 7 223 12 2,681 681 2,000 2.000 0_ 4590817 Building Interior R&M 486 2,319 8 290 12 3,478 1,278 L 2,200 2,200 0 12 of 16 6/7/2006 11:19 AM FUNC 90 - General Funs! PROPOSED BUDGE`, AENDMENTS as of May 8, 2006 Praposed as of Amendments 0510&106 r m ADOPTED) PROPOSED Variance of Audited YTO m a AME NDED AMENDED Adoptetl Actuals Actuals M Monthly r Budget Budget vs FY 04105 FY 05!06 n Average FY 05106 FY 05106 Amended Comments 45909 17 Building Exterior R&M _ _105 106 7 15 12 182 4,818) 5,000 5,000 0 45910 17 Lawn Mower R&M 40 101 7 14 12 172 2,328 2,500 2,500 0 46105 17 Office Sup lues 151 20 7 3 12 34 466) 500 500 0 4611517 Dues&Subscriptions 481 106 7 15 12 1$2 718 900 900 0 4613017 Books&Printed Materials 31 - 7 0 12 0 0 0 0 0 4615017 Licenses&Registrations 180 - 7 0 12 0 (500) 500 500 0 u 46190 17 Misc Expense _ 2,280 175 7 25 12 300 (3,700)1 4,000 4,000 0 46215 17 Vehicle Fuel&Maintenance 327 188 7 27 12_ 323 (77) 0 400 400 Increase in fuel costs 4660517 Uniforms 149 61 7 9 12 104 (896) 1,000 1,000 0 4741117 Mechanical Equipment 8,239 - 7 0 12 0 {{0,000) 10,000 10,000 0 DEPT 17-TOTAL FACIGRND EXPENDITURES 215,694 108,61? 201,529 (126,290) 311,17$ 327,819 16,641 76,641 13 of 16 6/7/2006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGE1 IENDMENTS as of May 8, 2006 Proposed as of Amendments 0510&OS T m ADOPTED! PROPOSED Variance of Audited YTD m n AMENDED AMENDED Adopted Actuals Actuals Monthly - Budget budget vs FY 04105 FY 05106 a Average Ps FY O5f06 FY 05!06 Amended Comments FINANCE/HUMAN RESOURCE-DEPARTMENT 18 4111018 Salaries 99,804 65,158 17 3,833 26 99,654 (3,291) 102,945 102,945 0 41111 18 Capitalized salary expenditure (10,000) 20,000 1 20,000 1 2D,000} 0 (20,000) (20,000) 0 Booked at year end 41120 18 Overtime_ 5,607 2,319 17 136 26 3,547 47 3,500 3,500 0 42110 18 Medical Insurance 12,719 7,185 8 898 12 10,777 (404) 15,597 11,181 _ 4,415 7,185+4`999-Changed from age banded rating to composite rating 42111 18 Denta I Insure nce 0 413 8 52 12 620 65 0 685 685 413+4"68 42130 18 LTD,AD&D,Life 822 546 8 68_12 819 39 936 858 (78) 546+4`78 42210 18 Social Security 6,298 3,937 17 232 26^ 6,021 (579) 6,600 6,600 0 4222018 Medicare 1,454 921 17 54 26 1,408 135) 1,543 1,543 0 42310_18_TMRS 8,204 4,841 17 285 25 7,404 (377) 7,781 7,781 0 42510 18 Unemployment Taxes 65 507 1 507 1 507 p 51 507 456 .3%in previous calendar year,3%for current year 42610 18 Worker's Compensation 214 314 1 314 1 314 (105) 419 419 0 4313518 Pre-Employment Testing 57 - 7 0 12 0 0 0 0 0 4324518 Financial Consulan_t _ __ 2,5001,500_ _ 1,500 1 1,500 1 11500 5,000) 6,500 6,500 43250 18 Auditor Q 70% 15,400 17,500_ 1 17,500 1 17,500 0 17,500 17,500 0 43405 18 Computer Equi ment/Software 791 71 7 10 12 122 (878) 1,000 1,000 0 44310 18 Accounting Software Maint 6,806 793 7 113 12 11359 1,266 2,625 2,625 0 4540518 Advertising for HR 1,284 313 7 45 12 536 _(2 14) 750 750 0 45610 18 Employee Relations 358 - 7 0 12 D 250 250 250 0 4550518 Airfare 157 - 7 0 12 0 350 350 350 0 45810 18 Car Rental/Parkin 69 7 0 12 0 (100) 100 100 0 4581518 Lodging 955 311 7 44 12 534 (666) 1,2001 1,200 0 4582018 Meals 0 - 7 0 12 0 (250)1 250 250 0 45825 18 Mileage 36 7 0 12 D 250 250 250 0 45830 18 Training,Seminars,Meetings 1,418 718 7 103 12 1,231 (1,769) 3,000 3,000 0 46105 18 Office Supplies 1,875 370 7 53 12 633 1,167 1,800 1,800 0 4611518 Dues&Subscriptions 1,77_0 770 7 110 12 1,320 180) 1,500 1,500 0 4613018 Books&Printed Materials 92 118 7 17 12 202 102 100 100 0 4619018 Misc Expense 0 - 7 0 12 0 500) 500 500 0 DEPT 16-TOTAL FINANCE EXPENDTFURES 1 158,745 88,6051 1 1 1 136,009 (17,665) 167,0471 163,694 (3,353) (3,353) 14 of 16 6/7/2006 11:19 AM FUND `O - General Fund PROPOSED BUDGET ENDMENTS as of May 8, 2006 Proposed as of Amendments 05108106 ADOPTEW PROPOSED Variance of m Audited YTD m AMENDED AMENDED Adopted n Actuals Actuals 9 Monthly '� � Budget Budget vs FY 04105 FY 05106 5 Average FY 85166 FY 05M6 Amended Comments PARKS&RECREATION-DEPARTMENT 19 _ 9111019 Salaries 26,539 17,324 17 1,019 26 26495 (813) 27,308 27,308 a 4211019 Medical Insurance 3,691 3,230 B 404 12 4,845 (825) 3,407 5,670 2,263 3,230+4x610 -Added dependent 42111 19 Denial Insurance 0 206 8 26 12 309 65) 0 374 374 206+4 x 42 42130 19 LTD,AD&D,Life 233 141 8 18 12 211 (10 263 221 (42) 141+4x 20 4221019 Social Security 1,510 966 17 57 26 1,477 (216) 1,693 1,693 0 4222019 Medicare 353 226 17 13 26 345 (51) 396 396 0 4231019 TMRS 2,105 1,243 17 73 26 1,900 95 1,996 1,995 0 42510 19 Unemployment Taxes 14 135 1 135 1 136 0 14 135 121 .31A in previous calendar year;3%for current year 4261019 Worker's Compensation 318 744 1 744 1 744 857 1,601 1,601 0 4333619 Contract Services-Officials/other 1,450 542 7 77 12 929 3,071) 4,000 4,000 0 _ 4334019 Contract Irrigation Maintenance 0 100 7 14 12 171 (1,829) 2,000 2,000 0 43343 19 Contract Trail Maintenance 3,015 6,678 8 1,085 12 13,D17 4,117 8,900 8,900 0 Sidewalk cost of$7,415(50%reimbursed by HOA) 43349 19 Landscape MaintGW Farms _ 18,313 8,641 8 1,080 12 12,961 (3,539) 16,500 16,500 0 43531 19 Marketing& Promotions 0 - 7 0 12 0 (1,000 1,000 1,000 0 44222 19 Recreation Supplies 8,248 414 7 59 12 710 7,290) 10,000 8,000 2,000 Move to HOC Projects 45912 44306 19 Cemetery Maintenance 9,057 678 7 97 12 1,162 (8,638) 10,000 10,000 0 4540519 Advertising 0 - 7 0 12 0 (2,000) 2,000 2,000 0 45911 19 GWFarms Park Maintenance 12,062 384 7 55 12 65B 14,342) 15,000 15,000 0 4591219 HOC Projects 0 - 7 0 12 0 (2,000 0 2,000 2,000 Allocated for prep work of playground equilament 4610619 Hospitality Items coaches/refs) 59 7 0 12 0 1,000) 1,000 1,000 0 4612019 PostagetShipping/Supplies 0 6 7 1 12 10 (990) 1,000 1,000 0 _ 4612519 Printing 0 7 0 12 0 500) 500 500 0 46190 19 Misc Expense 35 - 7 0 12 0 0 0 0 0 46215 19 Vehicle Fuel&Maintenance 0 188 7 27 12 323 177 0 500 500 Increase of gas costs Due to transfer error from developer to Town by Tri-County,bills were sent to HOA and not paid for six months. Once billing was corrected by Tri-County we experienced additional expenditures. 46220 19 Park Electricity %653_ 9,386 10 939 12 11,263 1,263L6,000 10,000 4,000 with 50%reimbursement from HOA included in revenue line-item. 43528 19 Fertillzers/Soils for Resale 0 434 7 62 12 744 3090 435 43543527 19 Snack Purchases for Resale 0 20 7 3 12 34 140 20 2043527 19 Drink Purchases for Resale 0 24 7 3 12 41 160 25 25 DEPT19-TOTAL PARKIREC EXPENDITURES 46,655 53,707 78,484 (43,790) 578 1-22,2741 7,696 1 7,696 15 of 16 6/712006 11:19 AM FUNC 10 - General Fund PROPOSED BUDGEZ IENDMENTS as of May 8, 2006 Pro]Of as of Amen 05100!06 m - ADDPTEDI PROPOSED VarianceAudited YTD nAMENDED AMENDED AdActuals Actuals 2 Monthly BOdDO Budget FY OM05 FY 05106 v Average k r FY 05!00 FY 05106 AmeComments INFORMATION TECHNOLOGY-DEPARTMENT 20 4326520 Technology Consultant 40,147 4,283 7 612 12 7,342 (22,658) 35,040 30,000 5,000) Reclass(see below) 43266 20 Technology Maintenance Contracts 9,729 8,254 7 1,179 12 14,150 3 150 11,000 11,000 0 SBC Datacomm invoice for$8,254 already paid 4326720 Systems Admin&Support Services 1,100 11,500 7 1,643 12 19,714 4,714 10,000 15,000 5,000 Reclass(see above) 4340520 Computer Equipment 0 3,273 7 468 12 5,611 (10,389) 16,000 16,000 0 4341520 Website Development 0 523 7 75 12 896 896 11,000 0 (11,000) DEPT 20•TOTAL!fT EXPENDITURES 50,976 27,8331 1 47,713 (24,287} B3,000 1 72,000 (11,000} (111000) TRANSFERS OUT _ 6256099 Xfr Out to 48 16 - 1 0 1 0 0 D 0 Q Bond payments already made;as we receive monthly sales tax 6258099 Xfr Out to DS 0 649,442 1 649,442 1 649,442 281,059 481,664 368,383 113,281 revenues in 4B will net against this transfer 6259099 Xfr Out to CP-Civic Campus 97,447 41,743 1 41,743 1 41,743 228,257) 266,525 270,000 3,475 6259099 Xfr Out to CP-Portable Buildings 0 628 1 628 1 628 628 57,400 0 (57,400) 6259099 Xfr Out to CP-Ternp Parking Lot 2;690 923 1 923 1 923 (97,877) 93,800 98,800 5,000 6260099 Xfr Out to PCM-Street Repair 0 16,308 1 16,308 1 16,308 (57,300 66,000 73,608 7,608 6290099 Xfr Out to PCM-General Maintenanc i 10,000 10,000 0 6261099 Xfr Out to SRF 0 - 1 0 1 0 (44,801)1 44,801 44,801 0 DEPT 99-TOTAL TRANSFERS OUT 1 100,153 1 709,D44 1 709,044 (146,540)1 1,020,190 865,592 (154,598) (154,598) Total Expenditures 3,680,114 2,011,614 1 2,011,6_14 1 2,417,614 2,807,456) 3,727,769 4,819,070 1,091,301 Total Transfers Out 100,153 709,044 1 709,044 1 709,444 1 (156.548)1 1,020,190 865,592 (154,598) ---- TOTALI 3,780,2671 2,720,658 1 Q 1 0 1 0 1 3,8.26,432 1 (1,846,430)1 4,747,959 1 5,684,662 1 3 936,703 SUMMARY_ Total Revenue _ 3,609,987 3,627,844 1 3,627,844 1 3,627,844 t(1,306.13141 3,788,104 4,934,458Transfers In 107,632 52,277 1 52,277 1 52,277 ,104) 1,965,337 2,070;381 105,044 Total Expenditures (3,680,114) (2,011,614) 1 (2,011,614) 1 (2,011,674) ,456 (3,727,789 (4,819,070) {1,091,307} Transfers Out (100,153) (709,044) 1 (709,044) 1 (709,044} ,548 (1,020,190) (865,592) 154,598 NET (62,649) 959,462 959462 ,715) 1,005,482 1,320,777 314,69b 314,695 CASH SUMMARY Beginning Cash 1,255,426 925,697 1 925,697 1 925 897 0 1,223,306 925,697 297,609) BIS Affect to Cash (267,080) (101,740) 1 101,740) 1 101,740) (216,176) (9,250) 114,436 123,685 Total Revenue 3,609,987 3,627,844 1 3,627,844 1_ 3,627,844 (1,306,6 3,768,104 4,934,458 1,146,354 Transfers In 107,632 52,277 1 52,277 1 52,277 (2,018,104) 1,965,337 2,070,381 105,044 TetalExpendltures (3,680,114) (2,011,614) 1 (2011614) 1 (2,071,614) 2,807,456 (3,727,769) (4,819,070) 1,091,301) Transfers Out (100,153) (709,044) 1 (709,044) 1 (709,044) 156,548 (1,020,190) (865,592) 154,598 NET 925,697 1,783,419 1,783,419 (57fi,891) 2,219,539 2,360,310 140;771 140„771 16 of 16 617/2006 11:19 AM UTILITY FUND Program Summary Adoptedl Proposed Amended Amended Actual Budget Budget Summary FY 04105 FY 05106 FY 05106 Beginning Balance (Cash) $ 336,394 $ 289,433 $ 643,898 Balance Sheet Affect to Cash * (212,420) $ (9,329) $ 32,811 Revenue 2,095,626 $ 2,146,770 $ 1,804,090 Expenses (Net of depreciation/amortization) 1,443,865 $ 1,535,963 $ 1,563,836 Capital Project Expenses 59,981 $ 559,390 $ 461,956 Transfers Out 71,857 $ 122,000 $ 77,000 Ending Balance $ 643,898 $ 209,521 $ 378,007 Restricted/Designated Funds** 388,357 75,000 75,000 Ending Balance $ 255,540 $ 134,521 1 $ 303,007 Adopted Proposed Amended Amended Actual Budget Budget Transfers Out FY 04105 FY 05106 FY 05106 Transfer to Permanent Capital Maint. Fund General Maintenance $ - $ 10,000 $ 10,000 Sanitary Sewer Inflow& Infiltration Repairs 27,000 27,000 Transfer to GF - FW Impact Fee Revenue 71,857 85,000 40,000 Total Transfers Out $ 71,857 $ 122,000 $ 77,000 Adopted/ Proposed Amended Amended Actual Budget Budget Capital Projects FY 04105 FY 05106 FY 05106 Keller Waterline $ 14,146 $ - $ - Water Meter Automation 10,301 37,000 15,000 TRA Assumption of N-1 Sewer 28,024 145,000 120,000 Sewer/water Installation for Portable Bldg. 26,500 - Fidelity Waterline Extension 7,510 350,890 326,956 Total Capital Projects $ 59,981 $ 559,390 $ 461,956 Adopted/ Proposed Amended Amended Actual Budget Budget Restricted/Designated Funds** FY 04105 FY 05106 FY 05106 Customer Deposits $ 77,410 $ 75,000 $ 75,000 Fidelity Waterline 310,947 - - Total Customer Deposits $ 388,357 $ 75,000 $ 75,000 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. 6/7/2006 11:00 AM FUND 50n - Utility Fund PROPOSED BUDGET An'-VDMENTS as of MF 2006 Proposed as of Amendments 05106/06 >, m ADOPTEDI PROPOSED Variance of AUDITED YTD ym, ti AMENDED AMENDED Adopted Actuals Actuals v Monthly + Budget Budget vs FY 04f05 FY 05106 i] Average + + . FY 05106 FY 05106 Amended Comments REVENUE _ Received in$350,890 in September 21005 and will request the remaining 33700 11 _Private Contributions 370,551 0 6 0 12 0 (16,010) 350,890 16,010 (334,880) $16,010 to complete project. 34410 11 Water Revenue 1,151,693 544,959 7 77,851 12 934,215 (346,290) 1,280,505 1,280,505 0 Consumption during winter months is less than monthly average. 34411 11 DS-Hillwood Service Area 34,768 13,088 6 2,181 12 26,175 (17,825) 44,000 44,000 0 34412 11 DS-Town Service Area 222,896 12,842 6 2,140 12 25,684 (10,316) 36,000 36,000 0 34420 11 Sewer Revenue 262,826 150,988 7 21,570 12 258,837 (163) 259,000 259,000 0 Consumption durinR winter months is less than monthly avers e. 34421 11 Sewer Revenue-keller 0 396 7 57 12 678 53 0 625 625 34430 11 Water Tap Fees 49,003 19,900 6 3,317 12 39,80D 5,200) 66,150 45,000 21,150) Fewer home starts duringwinter months. 34440 11 Sewer Tap Fees 14,375 4,635 6 773 12 9,270 (5,730) 20,625 15,000 5,625) Fewer home starts duringwinter months 34450 11 Ft.Worth Impact Fees 71,857 19,913 6 3,319 12 39,826 174 85,000 40,000 45,000) Corresponds with transfers out 34470 11 Meter Repair/Replacement 552 1,506 7 215 12 2,582 382 100 2,200 2,100 36110 11 Interest Famed 2,416 15,447 7 2,207 12 26,481 1,481 2,500 25,040 22,500 36200 11 Duct Bank Leases 22,585 _29,250 1 29,250 1 29,250 D 0 29,250 29,250 36201 11 TRA Wastewater Settle-u 82,145 0 1 0 1 0 0 0 0 0 39406-1-1 Misc income 9,959 11,478 1 11,478 1 11,478 (22)1 2,000 11,500 9,500 TOTAL REVENUE 2,D95,626 8.24,401 1 1 1 1 1,404,276 1 (399,814)1 2,146,770 1,804,090 (342,680) (342,680) EXPENSES 41110 00 Utility Salaries 26,606 20,140 16 1,259 26 32,728 (906) 33,634 33,634 0 42110 00 Medical Insurance 8,519 4,990 8 624 12 7,485 442 8,258 7,043 (1,215) 587x12months 42111 00 Dental Insurance 0 309 8 39 12 463 13 0 450 450 38 x 12 months 42130 00 LTD,AD&D,Life 59 173 8 22 12 269 13 394 273 121 23 x 12 months 42210 00 Social Security 1,707 1,037 16 65 26 11685 400 2,085 2,085 0 42220 00 Medicare 401 242 16 15 26 394 (94) 488 488 0 42310 00 TMRS 2,603 1,439 16 90 26 2,338 121) 2,459 2,459 0 42510 00 Unemployment Taxes 20 203 1 203 1 203 0 20 203 183 .3°/a previous year rate;3%current year calendar rate 42610 00 Worker's Compensation 1,019 1 1,164 1 1,164 1 1,164 1 (881)1 2,045 2,045 0 TOTAL UTILITY PAYROLL 40,9351 29,6971 1 46,719 (1,960)1 49,383 1 48,686 (704 (704) 41110 11 Administrative Salaries 6,303 3,835 16 240 26 6,232 (186) 6,418 6,418 0 42110 11 Medical Insurance_ 865 455 8 57 12 683 13 1,003 670 333 56 x 12 months 42111 11 Dental Insurance _ 0 42 8 5 12 63 (1) 0 64 64 5 x 12 months 42130 11 LTD,AD&D,Life 244 32 8 4 12 49 (4) 79 53 26 4 x 12 months 42210 11 Social Security p 500 232 16 14 26 377 (21) 398 398 0 42220 11 Medicare 115 54 16 3 26 88 (5) 93 93 0 42310 11 TMRS _ 515 274 16 17 26 445 (24) 469 469 0 42510 11 Unemployment Taxes 32 41 1 Ti- 1 41 0 4 41 37 .3%previous year rate;3%current year calendar rate 42610 11 Workers Compensation 17 29 1 29 1 29 3 28 26 0 _ 43205 11 Administrative Expense 28,962 16,174 14 1,155 24 27,726 1,067 26,659 26,659 0 TOTAL ADMIN PAYROLL 37,553 21,168 35,732 842 35,149 34,891 (259) (259) 1 of 4 6/712006 11:02 AM FUND 500 - Utility Fund PROPOSED BUDGET AP-NDMENTS as of ME , 2006 Proposed as of Amendments 05108106 ?, po ADOPTED! PROPOSED Variance of AUDITED YTD m n AMENDED AMENDED Adopted Actuals Actuals .5 Monthly r Budget Budget vs FY 64105 FY 05106 6 Average n r >t r FY 05106 FY 05f06 Amended Comments 43215 16 Misc Engineering_ 0 0 6 0 12 0 5,000 5,000 5,000 0 y Includes waterline study for upper Trinity waterline&377 temporary 43220 16 Water Utility Engineer 23,446 3,545 6 591 12 7,090 69,4101 76,500 76,500 0 waterline to Hillwood ranch house 43250 16 Auditor a 15% 3,300 3,750 1 3,750 1 3,750 0 3,750 3,750 0 43310 16 Boyle&Lowry 6,863 3,506 6 584 12 7,013 7,988 15,000 15,000 0 43335 16 Contracted Labor 0 0 6 0 12 0 7,000 7,000 7,000 0 43405 16 Computer Equipment 1,119 0 6 0 12 0 1,000 1,000 1,000 0 43533 16 Photo Supplies 0 0 6 0 12 0 50) 50 50 0 44105 16 Water Purchases 434,671 148,930 6 24,822 12 297,859 132,141 430,000 430,000 0 44106 16 Water Service Charge 600 250 6 42 12 500 100 600 600 0 44110 16 Peak Payment 157,740 88,493 6 14,749 12 176,987 18,013 195,000 195,000 0 _ 44111 16 Water Tower Landscape Maint 598 0 6 0 12 0 6,000 6,0.00 6,000 0 Includes 2"waterline installation from pump station to Hillwood ranch 44112 16 Water Main Maintenance 334 3,000 6 500 12 6,000 (3,000) 5,000 9,000 4,000 house(temporary)and repair of two fire hydrants at Daimler Chrysler 44113 16 Tower Maintenance 0 0 6 0 12 0 (1,000) 1,000 1,000 0 44114 16 Sewer Main Maintenanaoe 3,096 662 6 110 12 1,324 1,177 2,500 2,500 0 44115 16 TRA Wastewater Treatment _ 83,284 73,278 7 10,468 12 126,619 C6,1171 122,000 131,737 9,737 $73,277+5 x$11691.75 44116 16 Pump Station Landscape Maintenanace 638 0 6 0 12 0 1,530 1,530 1,530 0 44117 16 Lift Station Maintenance 1,388 996 6 166 12 1,992 42 1,950 1,950 0 SCADA and equipment repairs at pumpstaiion and lift station.- 44118 16 Instrument Repair;&Maintenance 521 1,344 6 224 12 2,667 (313) 500 3,000 2,500 Unexpected failures. 44119 16 Ground Storage Tank Maintenance 1,113 0 6 0 12 0 (1,000)1 1,000 1,000 0 44120 16 Southlake J TRA Maintenance 25,725 2,338 6 _ 390 12 4,675 (45,325) 50,000 50,000 0 44121 16 Generator Maintenance 948 0 6 0 12 0 (1,500) 1,500 1,500 0 44122 16 Bacterial Testing 215 195 6 33 12 390 (410) 800 800 0 44123 16 Pump Station R&M 0 0 6 0 12 0 14,000 14,000 14,000 0 44130 16 Meter Repairs and Replacements 0 900 6 150 12 1,800 0 0 1,800 1,800 44135 16 Utility.Billing 21799 1,266 6 211 12 2,533 (67) 2,600 2,600 0 44210 16 Facility Supplies 0 0 6 0 12 0 (100) 100 100 0 44211 16 Safety Equipment 0 _ 0 6 0 12 0 (50) 50 50 0 44220 16 Line Location 1,025 398 6 66 12 795 (705) 1,500 1,500 0 44226 16 Misc Hand Tools 1,269 52 6 9 12 104 _ (396) 1,040 500 500 44227 16 Chemical Supplies 100 688 6 115 12 1,376 688 500 688 188 Purchase of road salt fors reader. 44310 16 App Software Maintenance 1,916 396 6 66 12 792 (86) 878 878 0 44312 16 Keller Waste Water 0 210 6 35 12 421 (279) 0 700 700 45214 16 Insurance-Automobile 0 464 1 464 1 464 (1) 465 465 0 45215 16 Insurance-PropertyW 5,358 3,239 1 3,239 1 3,239 (0) 5,589 3,239 2,350 45305 16 Telephone Service 1,342 572 6 95 12 1,143 (298) 1,441 1,441 0 45310 16 Mobile Phone 1,063 528 6 88 12 1,056 156 1,600 900 700 451830 16 Training,Seminars,Meetings 299 709 6 118 12 1,418 693 800 725 75 _ 46105 16 Office Supplies 44 7 6 1 12 14 (137) 150 150 0 46110 16 Office Equipment 0 0 6 0 12 0 (100) 100 100 0 46115 16 Dues&Subscriptions 0 105 6 18 12 210 (210) 420 420 0 One time mass mailing for utility account information request from water 46120 16 Postage&Supplies 131 380 6 53 12 761 486 250 275 25 customers. 46125 16 Printing 345 450 1 450 1 450 0 300 450 150 Co and printing of old as-buift water and sewer plans 46135 16 Bank Charges 31 0 6 0 12 0 0 35 0 35 46155 16 Misc Supplies 6 0 6 0 12 0 0 0 0 0 46190 16 Misc Expense 293 0 6 0 12 0 (500) 500 500 0 46205 16 Town Water(15%) 1,508 319 6 53 12 639 111 3,059 750 (2,309) Reclass pump station to separate line-item(see below) 46206 16 Pump Station Water(100%) 2,083 3,652 7 5_22 12 6,26_1 761 0 5,500 5,500 Dry winter 46215 16 Vehicle Fuel&Maintenance 1,884 906 6 151 12_1,612_ 412 2,900 1,400 (1,500) 46220 16 Town Electric(15%) 41,458 1,194 6 199 12 21368 (612) 29,490 3,000 26,490 Reclass pump station to new gl account 46221 42661 16 Pump Station Electric 100% 0 24,789 7 3,541 12 42,496 2,504 0 45,000 45,000 Net difference of reclass is due to pumping more water in current year 46225 16 Town Gas 15%0 621 483 7 69 12 828 203 337 625 288 46605 16 Uniforms 212 0 6 0 12 0 50 700 250 450 61712006- 1-.02�AM FUND 500 - Utility Fund PROPOSED BUDGET AP-NDMENTS as of ML , 2006 Proposed as of Amendments 0510SIOADOPTED! PROPOSED Variance of AUDITED YTp m a . AMENDED AMENDED Adopted Actuals Actuals y Monthly . Budget Budget vs FY D4105 FY 05106 o Average .-. FY 051D6 FY 05106 Amended Comments 47105 16 Depreciation Expense 413,060 0 6 0 12 0 0 1 0 0 0 47110 16 Amortization Expense 31,760 0 6 0 12 0 0 0 0 0 47411 16 Mechanical Equipment 0 1,000 1 1,000 1 1,000 0 1,000 1,000 0 One time purchase of sanding equipment 47420 16 Water Meters 35,314 13,129 6 2,188 12 26,257 .1,257 30,000 25,000 (5,000) 47421 16 Water Taps 0 2,100 6 350 12 4,200 200 4,000 4,000 0 48801 16 Interfund Payable due to GF 0 0 6 0 12 0 (27,590) 27,590 27,590 0 48806 16 Interfund Payable due to 413 0 0 6 0 12 0 (29,731) 29,731 29,731 0 48810 16 DS-Keller OHS-Princiipal 0 102,539 6 102,539 1 102,539 (1) 102,540 102,540 0 48811 16 DS-Keller OHS-Interest 70,273 137,648 6 137,546 1 137,648 0 137,648 137,648 0 48820 16 GS-Hillwood Service Area 34,768 13,088 6 2,181 12 26,175 17,825) 44,000 44,000 0 48821 16 DS-Town Servioe Area 22,896 12,842 6 2,140 12 25,684 (10,316) 36;000 36,000 0 48823 16 DS-Hillwood-Interest344,515 0 6 0 12 0 0 0 0 0 TOTAL PW EXPENDITURES 1,762,032 654,338 1,030,387 (408,044) 1,408,953 1 1,439,431 30,479 30,479 41110 18 Finance Salaries 34,389 17;482 16 1,093 26 28,408 (1,138)1 29,546 29,546 0 41120 18 Overtime 4,603 1,493 16 93 26 2,426 (24) 2,450 2,450 0 42110 18 Medlcallnsurance 4,048 2,277 8 285 12 3,415 101 1 5,287 3,3141,9� 276x12months 42111 18 Dental Insurance 0 131 8 16 12 196 (4) 0 200 200 17 x 12 months 42130 18 LTD,AD&D,Life 259 156 8 20 12 235 (9) 268 244 24 20 x_12 months 42210 18 Soclat Security 1,782 1,124 16 70 26 1,826 (158) 1,984 1,984 0 42220 18 Medicare 421 263 16 16 26 427 (37) 464 464 0 42310 18 TMRS 2,491 1,357 16 85 26 2,205 (134) 2,339 2,339 0 _ 42510 18 Unemployment Taxes 8 rig 1 172 1 172 0 18 172 154 .3%previous year rate;3%current year calendar rate 42610 18 Worker's Compensation 164 1 108 1 108 12 1,292 1,170 122 122 0 TOTAL FINANCE PAYR6-LLj 46,165 1 24,561 40,602 1 (233)1 427478 40,835 (1,643) (1,643) CAPITAL PROJECTS 16600 02 Keller Water Line 14,146 14,146 1 14,146 1 14,146 14,146 0 0 0 16600 03 Water Motor Automation 10,301 10,301 1 10,301 1 10,301 4,699) 37,000 15,000 (22,000) Not as far along as anticipated 16600 05 TRA Assumption of N1 Sewer 28,024 29,799 1 29,799 1 29,799 (90,201) 145,000 120,000 (25,000) TRA delays-moved construction into FY06107 16600 07 Sewer/Water for Portable Bldgs 0 0 1 0 1 0 0 26,500 0 26,5_00) Court moving to Solona instead 16600 08 Fidelity Waterline 7,510 335,242 1 335,242 1 335,242 8,286 350,890 326,956 (23,934) PY expenses netted from Fidelity payment TOTAL CAPITAL PROJECTS1 59,981 389,488 1 51 389,488 1 51 389,488 {72,466}7 559,390 1 461,956 (97,434) (97,434) OTHER SOURCES& USES 62510 99 Xfr Out to General Fund 71,857 16,519 1 16,519 2 33,038 {6,982) 85,000 40,000 (45,0.00)f Impact fees-less. Fewer home starts. 62600 99 Xfr Out to PC Maintenance 0 0 1 0 1 0 (37,000) 37,000 37,000 0 f TOTAL TRANSFERS OUTI 71,857 1 1 33,038 (43,962)1 122,000 1 77,000 1 (45,000) (45,000) Total Expenditures 1,888,685729,765 0 0 0 1,153,441 (410,395) 1,535,963 1,563,836 27,873 Capital Projects 59,981 389,488 348,978 1 348,978 559,390 461,956 (97,434) Total Transfers Out 71,857 16,519 0 0 0 33,038 (43,962) 122,004 77,000 (45,000) TOTAL 2,020,522 1,135,772 1,535,457 (454,357) 2,217,353 1 2,1027792 (114,561) (114,561) 3 04 6/7/2006 11:02 AM FUND 500 - Utility Fund PROPOSED BUDGET AV-NDMENTS as of W 2006 Proposetl as or Amendments 05100106 ADOPTEDI PROPOSED Variance of AUDITED YTO m a - a AMENDED AMENDED Adopted Actuals Actuals 2: Monthly - Budget Budget vs FY 04105 FY 05106 o Average •• r FY 05106 rY 05106 Amended Comments SUMMARY Total Revenue 2,095,626 824,401 0 0 0 1,404,276 4 399,814 2,146,770 1,804,090 342,680) Total Expenses 1,888,685) (729,765) 0 0 0 (1,153,441) 410,395 1,535,963 1,563,836) (27,8731 Capital Projects (59,981 (389,48$ 0 0 (389,488) 559,390) (461,956} 97,434 Transfers Out (71,857) (16,519) 0 0 0 (33,038) 43,962 (122,000) (77,000) 45,000 NET 75,104 {311;371} 0 0 D (177,692) 54,543 (70,583) (298,702) (228,119) (228,i9S CASH SUMMARY Beginning Balance 336,394 643,898 1 643,898 1 643,898 0 289,433 643,898 354;464 *"BIS Affect to Cash 232,400 237,660 1 237,660 1 237,660 204,849 (9,329) 32,811 42,140 Total Revenue 2,095,626 824,401 1 824,401 1 1,404,276 399,814) 2,146,770 1,804,090 (342,680) ***Total Expenses (1,888,685) (729,765) 1 (729,765) 1 (1,153,441) 410,395 (1,535,963) (1,563,836) (27,873) Capital Projects (59,9 (389,488) 1 (389,488) (389,488) (559,390) (461,956) 97,434 Transfers Out (71,857) (16,519) 1 (16,519) 1 (33,038) 43,962 (122,000) (77,000) 45,000 NET 643,898 570,187 6 570,187 5 709,866 259,392 209,521 378,047 166,486 468,485 *** These totals do not agree with the Program Summary because the depreciation and amortization expenses are included. This column represents the"Audited"balances that must include these expenses which are offset in the balance sheet and net to zero. The Program Summary balance shows a clearer picture of our actual expenses. 4 of 4 6/712006 11:02 AM VISITOR'S ASSOCIATION FUND Program Summary Proposed Adopted Budget Actual Budget Amendments Summary FY 04/05 FY 05106 FY 05106 Beginning Balance (Cash) 843,082 825,076 771,233 Balance Sheet Affect to Cash * (33,187) - 3,229 Revenues 411,323 453,000 490,000 Expenditures 449,985 450,257 442,755 Ending Balance 771,233 827,819 821,707 Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. 6/7/2006 11:50 AM FUND ?"() - Visitor's Association Fund PROPOSED BUDGET AMEN' LENTS as of May 8, 2406 Proposed as of Amendments 05108/06 PROPOSED Variance of T AUDITED YTD m ro ADOPTED AMENDED Adopted Actuals Actuals n Monthly g Budget Budget vs FY 04105 FY 05106 Q Average :-i FY 05/06 FY 05106 Amended Comments REVENUE 3132011 Hotel Occupancy Tax 381,221 235,519 7 33,646 13 437,392 12,392 425,000 425,000 0 Averaging$32Klperiod. Reevd 6 of 13 payments. 3413311 Special Events(50 Year) 0 5,000 7 714 12 8,571 571 0 8,000 8,000 Received$5K donation from First Ameri can 34142 11 Historical Board Income 5,688 18,405 1 18,405 1 18,405 (1,595) 5,000 20,000 15,000 Received$15K donation from First American 34143 11 Tree City/Arbor Days Income 4,113 5,910 1 5,910 1 5,910 1,090 6,000 7,000 1,000 36110 11 Interest Income 20,301 19,026 7 2,718 12 32,617 2,617 17,000 30,000 13,000 TOTAL REVENUE 411,323 283,860 1 1 502,895 1 12,8951 453,000 490,000 37,000 1 37,000 EXPENDITURES 41110 00 Visitor Assoc Salaries 82,865 50,327 16 3,145 26 81,781 (2,849) 84,630 84,630 0 42110 00 Medical Insurance 11,800 4,988 8 624 12 7,482 512 13,629 6,970 6,659) $580 x 12 months 42111 00 Dental Insurance 0 281 8 35 12 422 1 0 421 421 $35 x 12 months 4213000 LTDIAD&D/Life Insurance 1,379 433 8 54 12 650 (31) 1,000 681 (319) $56 x 12 42210 00 Social Security 5,133 2,959 16 185 26 4,808 (439) 5,247 5,247 0 42220 00 Medicare 1,200 692 16 43 26 1,124 (103) 1,227 1,227 0 42310 00 TMRS 6,868 3,597 16 225 26 5,846 (340) 6,186 6,186 0 42510 00 Unemployment Taxes 207 270 1 270 1 270 0 27 270 243 PY.3%;CY 3.0%(Based on calendar year) 42610 00 Workers Comp 251 151 1 151 1 151 (189) 340 340 0 TOTAL VISITOR PAYROLLI 109,704 63,6991 1 1 1 102,534 1 (3,438) 112,286 1 105,972 1 (6,314) (6,314) 41110 11 Administrative Salaries 6,266 3,835 16 240 26 6,231 (187) 6,418 6,418 0 4211011 Medical Insurance 746 401 8 50 12 601 (17) 1,053 618 (435) $51 x 12 42111 11 Dental Insurance 0 42 8 5 12 63 0 0 63 _ 63 $5 x 12 42130 11 LTD/AD&D/Life Insurance; 53 _ 32 8 4 12 49 (2) 79 51 28) $4 x 12 42210 11 Social Security 390 232 16 14 26 377 21) 398 398 0 42220 11 Medicare 92 54 16 3 26 88 5 93 93 0 4231011 TMRS 502 274 16 17 26 446 (23) 469 469 0 4251011 Unemployment Taxes 31 �41 1 41 1 41 0 4 41 37 PY.3%;CY 3.0%(Based on calendar year) 42610 11 Workers Comp 26 29 1 29 1 29 (1) 26 30 4 43205 11 Admin Expense 28,962 16,174 14 1,155 24 27,726 1,067 26,659 26,659 0 43250 11 Auditor @ 15% 3,300 3,750 1 3,750 1 3,750 750 3,000 3,000 0 43310 11 Boyle&Lowry 4,106 0 6 0 12 0 0 3,500 0 (3,500 43405 11 Computer Eqpt/Software 199 0 1 0 1 0 (500) v 500 500 0 4341511 Website Development/Maint 15,529 0 1 0 1 0 0 5,000 0 (5,000) 43505 11 Historical Board Expense 16,280 4,652 6 775 12 9,304 (10,696) 10,000 20,000 10,000 1$15K donation from First American 1 of 3 6/7/2006 11:50 AM FUND 2"O - Visitor's Association Fund PROPOSED BUDGET AMEN" LENTS as of May 8, 2006 Proposed as of Amendments 05108100 PROPOSED Variance of 7+ AUDITED YTD ADOPTED AMENDED Adopted Actuals Actuals :2 Monthly EL r Budget Budget vs FY 04105 FY 05106 o Average ■ r FY 05/06 FY 05106 Amended Comments 43510 11 Tree City 7,498 4,552 6 759 12 9,105 2,105 4,000 7,000 3,000 Committee overspent 43515 11 Community Service 4,243 621 6 103 12 1,241 (3,759) 5,000 5,000 0 Majority of events have not occurred yet 43526 11 Masterworks 2,000 3,000 1 3,000 1 3,000 0 3,000 3,000 0 4352911 Marriott Marketing 47,870 0 6 0 12 0 (48,000) 48,000 48,000 0 4353011 Marriott Transportation 152,000 107,166 7 15,309 12 183,713 27,713 156,000 156,000 0 43531 11 Marketing&Promotions 4,077 195 6 33 12 390 (5,610) 6,000 6,000 0 Working on brochures,Masterwork banners,etc. 45305 11 Telephone Expense 1,342 572 6 95 12 1,143 (298) 1,441 1,441 0 45310 11 Mobile Phone 260 157 6 26 12 313 (87) 400 400 0 45610 11 Special Events(50 year celebt 0 270 6 45 12 540 _ (7,460) 13,000 8,000 (5,000) Reduced by$5k due to First American donation 45805 11 Travel Airfare 417 124 6 21 12 248 (252) 500 500 0 45810 11 Travel Car Rental 66 0 6 0 12 0 (100) 100 100 0 _ 45815 11 Travel Lodging 102 0 6 0 12 0 (500) 500 500 O 45825 11 Travel Mileage 0 0 6 0 12 0 (500) 500 500 0 4583011 Train inglSeminarslMeetings 847 310 6 52 12 620 1,220) 1,090 1,840 750 Expenses will occur in Summer Months 46105 11 Office Supplies 1,368 157 6 26 12 313 (167) 500 500 0 4611511 Dues&Subscriptions 1,876 970 6 162 12 1,940 (560) 3,250 2,500 (750) Expenses will occur in Summer Months 4612011 Postage&Supplies 132 315 6 53 12 631 (369) 1,000 1,000 0 46125 11 Printing 1,385 25 6 4 12 49 (951) 1,000 1,000 0 Expenses will occur in Summer Months 46190 11 Misc Expense 74 _ 0 6 0 12 0 0 0 0 0 46205 11 Utilities-water 1,508 319 6 53 12 639L 778 778 0 46220 11 Utilities-electric 4,427 1,235 6 206 12 2,471 2,283 2,500 217 46225 11 Utilities-gas 621 442 6 74 12 864 337 825 488_ 47900 11 Dove RoadlRandol Mill 2,000 0 6 0 12 0 0 0 0 TOTAL ADMINISTRATIVE 310,594 149,945 255,945 305,878 305,724 (154) (154} 2 of 3 617/2006 11:50 AM FUND 2'19 - Visitor's Association Fund PROPOSED BUDGET AMEW VENTS as of May 8, 2006 Proposed as of Amendments 05108/06 PROPOSED Variance of T AUDITED YTD m ADOPTED AMENDED Adopted m T Actuals Actuals a Monthly Budget Budget vs FY 04105 FY 05106 O Average r FY 05!06 I FY 05106 Amended Comments 41110 18 Finance Salaries 22,980 13,878 16 867 26 22,552 (829) 23,381 23,381 0 41120 18 Overtime 45 640 16 40 26 1,040 (10) 1,050 1,050 0 42110 18 Medical Insurance 2,631 1,670 8 209 12 2_,505 89 3,686 2,416 (1,270) $201 x 12 42111 18 Dental Insurance 0 96 8 12 Q 144 (3) 0 147 147 $12 x 12 42130 18 LTDIAD&D/Life Insurance 328 124 8 15 12 186 (9) 213 195 (18) $16 x 12 42210 18 Social Security 1,426 850 16 53 26 1,381 (134) 1,515 1,515 0 42220 18 Medicare 334 199 16 12 26 323 31) 354 354 0 42310 18 TMRS 1,757 1,038 16 65 26 1,687 (99) 1,786 1,786 0 42510 18 Unemployment Taxes 93 120 1 120 1 120 0 12 1.20 10.8 Previous year rate was.3%;Current year is 3% 42610 18 Workers Comp 93 74 1 74 1 74 (22) 96 96 0 TOTAL FINANCE PAYROLL 29,687 18,688 30,010 (1,050) 32,093 31,060 (1,033) {1,033} TOTAL,EXPENDITURES1 449,985 1 232,331 10 1 0 10 1 388,489 (54,267)1 450,257 1 442,755 1 (7,502) (7,502) SUMMARY Total Revenues 411,323 283,860 0 0 0 502,895 12,895 453,000 490,000 37,000 Total Expenditures (449,985) (232,331) 0 0 0 (388,489) 54,267 (450,257) (442,755) 7,502 NET (38,662) 51,529 D 1 0 101 114,406 67,161 2,7437T 47,2451 44,502 44,502 CAS_ H SUMMARY Beginning Balance 843,082 771,233 0 0 0 825,076 53,843 825,076 771,233 (53,843) BIS Affect to Cash (33,187) 88,752) 0 0 0 0 3,229) 0 3,229 3,229 Total Revenue 411,323 283,860 0 0 0 502,895 12,895 453,000 490,000 37,000 Total Expenditures (449,985) (232,331) 0 0 0 (388,489) 54,267 (450,257) (442,755) 7,502 NET TOTAL 771,233 734,D1q 0 0 0 939,482 117,775 827,819 821,707 (6,112) (6,112) rL Arbor Das Event Tree Cit October,2005 Revenues 5,378 Expenditures (7,671) Net Exp.Over Revenues (2,293)_ 3 of 3 617/2006 11:50 AM CAPITAL PROJECTS FUND - GOVERNMENTAL Program Summary Proposed Amended Actual Adapted Budget Summary FY 04105 FY 05106 FY 05/06 Beginning Balance (Cash) $ - $ _ $ _ Balance Sheet Affect to Cash * 50,129 28,470 Revenue 141,140 222,237 150,000 Expenditures 410,669 1,939,962 627,270 Transfers In 219,400 1,717,725 448,800 Ending Balance $ _ $ _ $ _ Proposed Amended Actual Adopted Budget Transfers In FY 04/05 FY 05106 FY 05106 Other Sources Westlake Academy Foundation (Art/Science Building) $ - $ 1,300,000 $ - General Fund Portable Buildings - 57,400 _ Temporary Parking 2,690 93,800 98,800 Civic Campus Expansion 97,447 266,525 270,000 4A Economic Development Fund 114 Commerical Growth 119,263 80,000 Total Transfers In $ 219,400 $ 1,717,725 $ 448,800 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. FUND 4,10 - Capital Projects PROPOSED BUDGET AM` -7MENTS as of Ma, J, 2006 Proposed as of Amendments 051D8106 PROPOSED Variance of T AUDITED YTD m m ADOPTED AMENDED Adopted Actuals Actuals �0 Monthly a Budget Budget vs FY 04105 FY 05106 o Average 2 - ■ FY 05/06 PY 05106 Amended Comments REVENUE VVas recognize as revenl7e InVYanclsetupasan 33700 00 FM 1938-Southlake Contributic 72,237 0 1 0 1 0 0 72,237 0 (72,237) AIR-cash was offset in the BIS account(Accrual) 33700 00 FM 1938-Keller Contributions 68,903 0 1 0 1 0 0 0 0 0 33700 00 FM 1938-Tarrant County 0 150,000 1 150,000 1 150,000 0 150,000 150,000 0 TOTAL REVENUE 141,140 150,000 150,000 0 222,237 150,000 (72,237} EXPENDITURES 43215 00 FM1938 173,265 59,390 4 14,848 12 178,171 (299) 222,237 178,470 (43,767) TOTAL OPERATING 173,265 59,390 178,171 (299} 222,237 178,470 (43,767)11 72000 04 Civic Campus Expansion 87,921 10,227 6 1,704 12 20,453 (249,547) 266,525 270,000 3,475 Increase in material costs Capital Campaign not started as quickly as 72000 07 Art/Science,Building 0 0 1 0 1 0 0 1,300,000 0 1,300,000) anticipated Per bids received;majority of construction in 73000 06 Temporary Parkirt4 9,153 1,003 1 1,0_03 1 1,003 97,797) 93,800 98,800 5,000 summer 73000 08 Portable Buildings 0 628 1 628 1 628 628 57,400 0 (57,400) Moving to Solana 74400 02 Hwy 114 development(Mall) 140,331 77,483 1 77,483 1 77,483 (2,518) 0 80,000 80,000 Expenditures related to mall;legal,etc TOTAL CAPITAL 237,404 89,341 99,567 (349,233) 1,717,725 448,800 (1,268,925) TOTAL EXPENC)ITURES 410,669 14$,731 0 D D 277,738 (349,532) 1,939,962 1 627,270 (1,312,692) OTHER SOURCES & USES 52510 88 Xfr in from GF-Civic Campus 97,447 10,227 1 10,227 1 10,227 (259,773) 266,525 270,000 3,475 see above 52510 88 Xfr in from GF-Portable Buildii 0 628 1 628 1 628 628 57,400 0 57,400 see above 52510 88 Xfr in from GF-Temp Parking 1 2,690 1,003 1 1,003 1 1,003 (97,797) 93,800 98,800 5,000 see above 52570 88 Xfr In from 4A-Mall 119,263 77,483 1 77,483 1 77,483 (2,518) 0 80,000 80,000 52590 88 Xfr in from Outside Sources 0 0 1 0 1 0 0 1,300,000 0 (1,300,000) campaign TRANSERSINI 219,400 1 89,341 1 89,341 1 (359,459)1 1,717,725 1 448,800 1 (1,268,925) SUMMARY Total Revenue 141,140 150,000 1 150,000 1 150,000 d 1 222,237 150,000 72,237) Total Expenditures (410,669) (148,731) 1 (148,731) 1 (148,731) 478,539 (1,939,962) (627,270) 1,312,692 Transfers In 219,400 89,341 1 89,341 1 89,341 (359,459) 1,717,725 448,800 (1,268,925) NET TOTAL (50,129) 90,610 90,610 119,080 0 (28,470) (28,470) GASH SUMMARY _ Beginning Baianee 0 0 1 0 1 0 0 0 0 0 BIS Affect to Cash 50,129 28,470 1 28,470 1 28,470 0 0 28,470 28,470 Revenues 141,140 150,000 1 150,000 1 150,000 0 222,237 150,000 (72,237) Expenditures (410,669) (148,731) 1 (148,731) 1 (148,731) 478,539 (1,939,962) (627,270) 1,312,692 Transfers In 219,400 89,341 1 89,341 1 89,341 (359,459) 1,717,725 448,800 (1,268,925) NET TOTAL 0 1 119,0801 5 1 119,080 1 5 1 119,080 119,080 0 1 01 0 PERMANENT CAPITAL MAINTENANCE FUND Program Summary Proposed Adopted Amended Actual Budget Budget Summary FY 04105 FY 05106 FY 05106 Beginning Balance (Cash) $ - $ - $ - Balance Sheet Affect to Cash - Transfers In - 113,000 120,608 Expenditures - 93,000 100,608 Ending Balance $ - $ 20,000 $ 20,000 Proposed Adopted Amended Actual Budget Budget Transfers In FY 04105 FY 05106 FY 05106 Utility Fund - General Maintenance $ - $ 10,000 $ 10,000 Sanitary Sewer Inflow& Infiltration Repairs - 27,000 27,000 General Fund - - - General Maintenance - 10,000 10,000 Dove Road Improvements - 40,440 57,300 Pearson Lane Improvements 25,560 16,308 Total Transfers In $ - $ 113,000 1 $ 120,608 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. FUND Frio - Permanent Capital Maintenance PROPOSED BUDGET AMI" -7MENTS as of Nay 8, 2006 Proposed as of Amendments 05108/06 ADOPTED/ PROPOSED Varianceto AUDITED YTD m m ■ AMENDED AMENDED Adopted Actuals Actuals M Monthly EL ■ Budget Budget vs FY D4I05 FY 05!06 a Average ■ ■ ■ FY 05!06 FY 05106 Amended Comments TRANSERS IN _ 5251088 Transfers in from GF 0 0 1 0 1 0 (10,000) 10,000 10,000 0 GF-General Maintenance 5251088 Transfers in from GF 0 0 1 0 1 0 (57,300) 40,440 57,300 16,860 GF-Dove Road Improvements 5251088 Transfers in from GF 0 16,308 1 16,308 1 16,308 0) 25,550 16,308 (9,252) GF-Pearson Lane Improvements 5255088 Transfers in from OF 0 0 1 0 1 0 (27,000) 27,000 27,000 0 OF-Sewer Inflow&Infiltration Repairs 52550 88 Transfers in from OF 0 0 1 0 1 0 (10,000)1 10,000 10,000 0 1 UF-General Maintenance TOTAL REVENUEJ 0 16,308 16,308 1 (104,300)1 113,000 1 120,608 1 7,608 EXPENDITURES 44302 00 Road Repairs&Maint. 0 0 1 0 1 0 (57,300) 40,440 57,30D 16,860 GF-Dove Road Improvements 44302)1.15 Road Repairs&Maint. 0 16,308 1 16,308 1 16,308 (0) 25,560 16,308 (9,252) GF-Pearson Lane Improvements 44114 00 Sewer Repairs 0 0 1 0 1 0 (27,000) 27,000 27,000 0 OF-Sewer Inflow& Infiltration Repairs TOTAL EXPENDITURES1 0 16,308 1 1 1 1 16,308 (84,300) 93,000 100,608 7,608 SUMMARY Transfers In 0 16,308 0 0 0 16,308 (104,300) 113,000 120,608 7,608 Total Expenditures 0 (16,308) 0 0 0 (16,308) 84,300 (93,000) (100,608) (7,608) NET TOTALI 0 010 1 010-1 0 (20,000)1 20,000 20,000 0 CASH SUMMARY Beginnin Castt 0 0 0 0 0 0 0 0 0 0 8!S Affect to Cash 0 0 0 0 0 0 0 0 0 0 Transfers In 0 16,308 0 0 0 16,308 (104,300) 113,000 120,608 7,608 Expenditures 0 1 (16,308) 0 0 0 (16,308) 84,300 (93,000) (100,608) (7,608) NET TOTAL 01 01 0 1 D 1 0 1 0 (20,000)1 20,000 20,000 0 1 of 1 6/7/2006 11:04 AM DEBT SERVICE FUND Program Summary Proposed Amended Actual Adopted Budget Summary FY 04]05 FY 05106 FY 05106 Beginning Balance (Cash) $ - $ - $ - Balance Sheet Affect to Cash - - - Transfers In 1,028,104 1,378,864 1,378,334 Expenditures 1,028,104 1,378,864 1,378,334 Ending Balance $ - $ - $ - Proposed Amended Actual Adopted Budget Transfers In FY 04105 FY 05106 FY 05106 4B Economic Development Fund $ 1,028,104 $ 897,200 $ 1,009,951 General Fund To cover 46 shortfall for Series 2002 and 2003 - 481,664 368,383 Total Transfers In $ - 1,378,864 1,378,334 " Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. 6/7/2006 10:59 AM FUND '100 - Debt Service Fund PROPOSED BUDGET AMf 'DMENTS as of IVidy S, 2006 Proposed as of Amendments 05/08106 PROPOSED Variance of AUDITED YTD op m ■ ADOPTED AMENDED Adopted Actuals Actuals L� Monthly a ■ Budget Budget vs FY 04105 FY 05106 o Average 2 ■ ■ ■ FY 05106 FY 05!06 Amended Comments TRANSERS IN 52510 88 Transfer in from GF 0 649,442 1 649,442 1 649,442 281,059 481,664 368,383 (113,281) 52560 88 Transfer in from 46 1,028,104 728,892 1 728,892 1 728,892 (281,059) 897,200 1,009,951 112,751 Add'I sales tax receipts TOTAL REVENUE 1,028,104 1,378,334 1,378,334 (0)1 1,378,8641 1,378,334 1 (530) EXPENDITURES 46135 0 Bank Service Charge 300 530 1 530 2 1,060 530 L350,000 ,060 530 (530) 48840 0 Debt Service Principal 0 350,000 1 350,000 1 350,000 0 350,000 0 48850 0 Debt Service Interest 1,027,804 1,027,804 1 ######## 1 1,027,804 (0) 1 ,804 1,027,804 0 TOTAL EXPENDITURES 1,028,104 1,378,334 1,378,864 530 1,378,864 1 1,378,334 (530) SUMMARY Transfers In 1,028,104 1,378,334 0 0 0 1,378,334 (0) 1,378,864 1,378,334 (530) Total Expenditures (1,028,104) (1,378,334) 0 0 0 (1,378,864) (530) (1,378,864) (1,378,334) 530 NET TOTALI 0 0 0 0 1 0 (530) (530) 0 0 0 CASH SUMMARY Beginning Cash 0 0 0 0 0 0 0 0 0 0 BIS Affect to Cash 0 0 0 0 0 0 0 0 0 0 Transfers In 1,028,104 1,378,334 0 0 0 1,378,334 (0) 1,378,864 1,378,334 (530 Expenditures (1,028,104) (1,378,334) 0 0 0 (1,378,864) (530) (1,378,864) (1,378,334) 530 NET TOTAL 0 1 0 1 01 0 1 D 1 (530) (530) 0 1 0 1 0 1 of 1 6/7/2006 10:59 AM 4A ECONOMIC DEVELOPMENT FUND Program Summary Proposed Amended Actual Adopted Budget Summary FY 04/05 FY 05106 FY 05106 Beginning Balance (Cash) $ 902,312 $ 1,240,595 $ 1,305,126 Balance Sheet Affect to Cash * 18,332 - (10,745) Revenues 540,459 677,000 817,500 Expenditures 956 37,258 1,500 Transfers Out 155,022 1,880,337 2,110,381 Ending Balance $ 1,305,126 $ 0 $ - Proposed Amended Actual Adopted Budget Transfers Out FY 04105 FY 05/06 FY 05106 4A Economic Development Fund Fidelity Payment $ 35,758 $ 35,758 General Fund Dissolution of 4A 1,880,337 1,994,623 Capital Projects SH 114 Commerical Growth 119,264 - 80,000 [Total Transfers Out $ 155,022 $ 1,880,337 $ 2,110,381 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. 6/7/2006 10:59 AM FUND T'n - 4A Economic Development Fund PROPOSED BUDGET AMS- WENTS as of Ma, s, 2006 Proposed as of Amendments 05108106 PROPOSED Variance of AUDITED YTD op .21.2 ADOPTED AMENDED Adopted Actuals Actuals 2 Monthly Budget Budget vs FY 04105 FY 05106 1 o I Average � i r FY 05106 FY 05106 Amended Comments REVENUE 313100 Sales Tax Revenue 497,303 L 499,954 7 71,422 12 857,064"94,564 660,000 762,500 102,500 Avg of$175K remaining of yr 36110 0 Interest Earned 29,758 34,221 7 4,889 12 58,66 17,000 55,000 38,000 Interest rate at 4.7%current) 39400 0 Misc Income 13,398 0 6 0 12 0 0 0 TOTAL REVENUE 540,459 534,176 915,72 677,000 817,500 140,500 140,500 EXPENDITURES 43310 0 Boyle&Lowry 956 0 1 0 1 0 (1,50o)l 1,500 1,500 0 46520 0 Fidelity Reimbursement 0 0 1 0 1 0 0 1 35,758 0 (35,758} TOTAL EXPENDITURES1 956 01 1 1 1 0 (1,500) 37,258 1,500 (35,758) (35,758) OTHER SOURCES_& USES Contract with Town not 4A;4Ajust funding it;slb paid 62510 99 Xfr Out to GF-Fidelity Paymei 35,758 35,758 1 0 1 0 (35,758 0 35,758 35,758 out of GF 62510 99 Xfr Out to GF-4A dissolution 0 0 1 0 1 0 (1,994,623) 1,880,337 1,994,623 114,286 Dissolution of 4A _ 62590 99 Xfr Out to Capital Projects 119,263 67,976 1 67,976 1 67,976 (12,024) 0 80,000 80,000 Hwy 114 development TRANSFERS OUT 155,Q22 11 103,734 67,976 (2,042,405) 1,880,337 2,110,381 1 230,044 Total Expenditures 956 0 1 0 1 (1,500)l 37,258 1,500 (35,758) Transfers Out 155,022 103,734 1 103,734 1 1Q3,734 (2,006,647} 1,880,337 2,110,381 230,044 Total Expenditures and Transfers Outj 155,978 103,7341 1 1 1 103,7341 008,147} 1,917,595 1 2,111,881 1 194,286 194,286 SUMMARY Total Revenue 540;459 534,176 0 0 0 915,729 98,229 677,000 817,500 140,500 Total Expenditures 956) 0 0 0 0 0 1,500 (37,258) (1,500) (35,758} Transfers Out (155,022) (103,734) 0 0 0 (67,976) 2,042,405 (1,$80,337) (2,110,381) 230,044 NET TOTAL 384,481 430,441 0 0 0 847,753 2,142,134 (1,240,595) (1,294,381) (53,786) (53,786) CASH SUMMARY Beginning Cash 902,312 1,305,126 0 0 0 0 1,305,126 1,240,595 1,305,126 64,531 BIS Affect to Cash 18,332 102,135 0 0 0 0 10,745 0 (10,745) (10,745 Revenues 540,459 534,176 0 0 0 915,729 98,229 677,000 817,500 140,500 Expenditures 956) 0 0 0 0 0 1,500_ (37,258) (1,540) 35,758 Transfers Out (155,022) (103,734) 0 0 0 (67,976) 2,042,405 (1,880,337) (2,110,381) (230,044) NET TOTALI 1,305,126 1 1,633,433 1 D 1 0 1 0 1 847,753 847,753.111 1 0 (0) 0 1 of 1 6/7/2006 10:59 AM 413 ECONOMIC DEVELOPMENT FUND Program Summary Proposed Amended Actual Adopted Budget Summary FY 04105 FY 05106 FY 05106 Beginning Balance (Cash) $ 505,456 $ 204,969 $ 221,681 Balance Sheet Affect to Cash * 31,064 - (7,810) Revenues 500,481 692,231 796,081 Expenditures 530 - - Transfers In 213,314 - - Transfers Out 1,028,104 897,200 1,009,951 Ending Balance $ 221,681 $ - $ - Proposed Amended Actual Adopted Budget Transfers In FY 04105 FY 05/06 FY 05106 Civic Campus $ 213,314 $ Is - Total Transfers In $ 2135314 $ - $ - Proposed Amended Actual Adopted Budget Transfers Out FY 04105 FY 05106 FY 05106 Debt Service for Civic Campus $ 1,028,104 $ 897,200 $ 1,009,951 Total Transfers Out $ 1,028,104 $ 897,200 1 $ 1,009,951 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. 617/2006 10:58 AM FUND 1% - 413 Economic Development Fund PROPOSED BUDGET AM` 'WENTS as of Kuy 8, 2006 Proposed as of Amendments 05/08106 Variance of AUDITED YTD m ■ ADOPTED PROPOSED Adopted Actuals Actuals a Monthly ■ Budget Budget vs FY 04105 FY 05106 inAverage n ■ ■ ■ FY 05106 FY 05106 Admended comments REVENUE 31310 00 Sales Tax Revenue 497,303 499,954 7 71,42_2 12 857,064 94_,564 660,000 762,500 102,500 Avg of$175K remaining ofyr 36110 00 Interest Earned 3,178 3,208 7 458 12 5,499 1,649 2,500 3,850 1,350 38805 00 Debt Pymt from OF 0 0 1 0 1 0 (29,731) 29,731 29,731 0 TOTAL REVENUE 500,481 503,162 862,563 66,482 692,231 796,081 103,850 103,854 52510 88 Xfr in from General Fund 16 0 1 0 1 0 0 0 0 0 52530 88 Xfr in from Civic Campus 213,297 0 1 0 1 0 0 0 0 0 TRANSERS IN 213,314 0 1 1 1 0 0 1 0 1 D 0 TOTALI 713,794 1 503,162 1 1 1 1 862,563 1 66,482 1 692,231 1 796,081 103,850 1 103,850 EXPENDITURES _ 46135 00 Bank Admin Charges 530 0 1 0 1 0 0 0 0 0 TOTAL EXPENDITURES 530 0 0 0 D D 0 62580 99 Xfr Out to Debt Service 1,028,104 728,892 1 728,892 1 728,892 (281,060) 897,200 1,009,951 112,751 Due to additional sales tax revenue TRANSERS OUT 1,028,104 728,892 728,892 (281,060) 897,200 1,009,951 112,751 112,751 TOTAL 1,028,634 728,892 1 1 1 1 728,892 (281,060) 897,200 1 1,009,951 112,7511 112,751 SUMMARY Total Revenue 500,481 503,162 0 0 0 862,563L;d 692,231 796,081 103,850 Total Expenditures (530) 0 0 0 0 0 0 0 0Transfers In 213,314 0 0 0 0 0 0 0 0 Transfers Out (1,028,104) (728,892) 0 0 0 (728,892) (897,200) (1,009,951) (112,751) NET TOTAL (314,839) (225,730) 0 1 0 1 01 133,672 (204,969) (213,870) (8,901) (8,901) CASH SUMMARY Beginning Balance 505,456 221,681 0 1,323 0 1,323 (220,357} 204,969 221,681 16,712 BIS Affect to Cash 31,064 5,373 0 0 0 0 7,810 - (7,810) (7,810) Total Revenue 500,481 503,162 0 0 0 862,563 66,482 692,231 796,081 103,850 Total Expenditures (530) 0 0 0 0 0 0 - - 0 Transfers In 213,314 0 0 0 0 0 0 - 0 Transfers Out (1,028,104) (728,892) 0 0 0 (728,892) 281,060 (897,200) (1,009,951) (112,751) NETTOTALI 221,681 1 1,3231 0 1 1,323 1 0 134,995 134,995 0 1 D 0 1 of 1 6/712006 10:58 AM